<?php

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die('Restricted access');

use Joomla\CMS\MVC\Model\BaseDatabaseModel;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;

jimport('joomla.application.component.model');

class DefaultsModelDefaults extends BaseDatabaseModel
{

	/**
	 * Method to get weblinks item data
	 *
	 * @access public
	 * @return array
	 */
	function getData()
	{

		// Lets load the content if it doesn't already exist
		if (empty($this->_data))
		{
			$db    = Factory::getDbo();
			$query = $db->getQuery(true);

			$query->select("def.*");
			$query->from("#__jev_defaults as def");

			// Join over the language and category
			$query->select('l.title AS language_title');
			$query->select('c.title AS category_title');
			// some servers have mixed collations
			$query->join('LEFT', $db->quoteName('#__languages') . ' AS l ON BINARY l.lang_code = BINARY def.language');
			$query->join('LEFT', $db->quoteName('#__categories') . ' AS c ON c.id = def.catid');

			$language = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_language", 'filter_language', "*");
			if (count($this->getLanguages()) == 1)
			{
				$language = "*";
			}
			if ($language != "")
			{
				$query->where('def.language = ' . $db->quote($language));
			}

			$filter_published = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_published", 'filter_published', "");
			if ($filter_published != "")
			{
				$query->where('def.state = ' . intval($filter_published));
			}

			$layouttype = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_layout_type", 'filter_layout_type', "jevents");
			if ($layouttype != "")
			{
				if ($layouttype == "jevlocations")
				{
					$query->where('def.name like ("com_jevlocations%")');
				}
				if ($layouttype == "jevpeople")
				{
					$query->where('def.name like ("com_jevpeople%")');
				}
				if ($layouttype == "jevents")
				{
					$query->where('def.name NOT like ("com_jevpeople%") AND def.name NOT like ("com_jevlocations%")');
				}
			}

			$filter_catid = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_catid", 'filter_catid', "0");
			if ($filter_catid != "0" && $layouttype == "jevents")
			{
				$query->where('def.catid = ' . intval($filter_catid));
			}
			else
			{
				$query->where('def.catid = 0');
			}

			// Currently no option to customise event editing by category
			if ($filter_catid != "0" && $filter_catid != "")
			{
				$query->where('def.name <> "icalevent.edit_page"');
			}


			$query->order("def.title asc");
			$db->setQuery($query);
			$this->_data = $db->loadObjectList();
			//echo $db->getQuery();
			//var_dump($this->_data);
		}

		return $this->_data;
	}

	function getLanguages()
	{

		static $languages;
		if (!isset($languages))
		{
			$db = Factory::getDbo();

			// get the list of languages first 
			$query = $db->getQuery(true);
			$query->select("l.*");
			$query->from("#__languages as l");
			$query->where('l.lang_code <> "xx-XX"');
			$query->order("l.lang_code asc");

			$db->setQuery($query);
			$languages = $db->loadObjectList('lang_code');
		}

		return $languages;
	}

	/**
	 * Method to get the total number of weblink items
	 *
	 * @access public
	 * @return integer
	 */
	function getTotal()
	{

		// Lets load the content if it doesn't already exist
		if (empty($this->_total))
		{
			// Manually add the form data which is not stored in the database in the same way
			$db       = Factory::getDbo();
			$language = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_language", 'filter_language', "*");

			$query = $db->getQuery(true);

			$query->select("count(*)");
			$query->from("#__jev_defaults as def");

			if (count($this->getLanguages()) == 1)
			{
				$language = "*";
				if ($language != "")
				{
					$query->where('def.language = ' . $db->quote($language));
				}
			}
			$db->setQuery($query);

			$this->_total = $db->loadResult();
		}

		return $this->_total;
	}

	function getCategories()
	{

		$filter_published = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_published", 'filter_published', "0,1");
		if ($filter_published == "")
		{
			$filter_published = "0,1";
		}

		// Do not filter on category being published or not!
		$filter_published = "0,1";
		//$filter_language = Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_language", 'filter_language', "*");
		//$options = HTMLHelper::_('category.options', JEV_COM_COMPONENT, array('filter.published' => explode(',', $filter_published), 'filter.language' => explode(',', $filter_language)));
		$options = HTMLHelper::_('category.options', JEV_COM_COMPONENT, array('filter.published' => explode(',', $filter_published)));

		// if only published entries then allow option to look across all categories
		if (Factory::getApplication()->getUserStateFromRequest("jevdefaults.filter_published", 'filter_published', "0,1") == 1)
		{
			array_unshift($options, HTMLHelper::_('select.option', '0', Text::_('JEV_ANY_CATEGORY')));
		}

		return $options;
	}
}
