<?php
defined('_JEXEC') or die;

use Joomla\CMS\MVC\Model\ListModel;
use Joomla\CMS\Factory;

class Djcatalog2ModelMysubscriptions extends ListModel
{
	public function __construct($config = array())
	{
		parent::__construct($config);
	}

	public function getItems()
	{
		// Get a db connection.
		$db = Factory::getDbo();
		$user = Factory::getUser();
		$userId = $user->id;


		// Create a new query object.
		$query = $db->getQuery(true);

		// Select all fields from the #__djc2_subscriptions table.
		$query->select('*')
			->from($db->quoteName('#__djc2_subscriptions', 's'))
			->innerJoin($db->quoteName('#__djc2_items', 'i') . ' ON ' . $db->quoteName('s.item_id') . ' = ' . $db->quoteName('i.id'))
			->where($db->quoteName('s.user_id') . ' = ' . (int) $userId);

		// Set the query and load the results as a list of objects.
		$db->setQuery($query);
		$items = $db->loadObjectList();

		return $items;
	}
}