<?php
/**
* @package		Komento
* @copyright	Copyright (C) 2010 - 2018 Stack Ideas Sdn Bhd. All rights reserved.
* @license		GNU/GPL, see LICENSE.php
* Komento is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
defined('_JEXEC') or die('Unauthorized Access');

require_once(__DIR__ . '/abstract.php');

class KomentoComOhanah extends KomentoExtension
{
	public $_item;
	public $_map = array(
		'id' => 'id',
		'title' => 'title',
		'hits' => 'hits',
		'created_by' => 'created_by',
		'catid' => 'ohanah_category_id',
		'permalink' => 'permalink'
		);

	public function __construct($component)
	{
		parent::__construct($component);
	}

	/**
	 * Method to load a plugin object by content id number
	 *
	 * @access	public
	 *
	 * @return	object	Instance of this class
	 */
	public function load($cid)
	{
		static $instances = null;

		if (is_null($instances)) {
			$instances = array();
		}

		// If there is no id passed, get from the url
		$cid = $cid ?: $this->input->get('id', 0, 'int');

		if (!array_key_exists($cid, $instances)) {
			$db = KT::db();
			$query = 'SELECT * FROM ' . $db->nameQuote('#__ohanah_events')
					. ' WHERE ' . $db->nameQuote('ohanah_event_id') . '=' . $db->quote($cid);

			$db->setQuery($query);

			if (!$this->_item = $db->loadObject()) {
				return $this->onLoadArticleError($cid);
			}

			// Ohanah does not store hits for some reason.
			$this->_item->hits = 0;

			$link = 'index.php?option=com_ohanah&view=event&id=' . $this->_item->ohanah_event_id;
			$this->_item->permalink = $this->prepareLink($link);

			$instances[$cid] = $this->_item;
		}

		$this->_item = $instances[$cid];

		return $this;
	}

	public function getContentIds($categories = '')
	{
		$db = KT::db();
		$query = '';

		if (empty($categories)) {
			$query = 'SELECT `ohanah_event_id` FROM ' . $db->nameQuote('#__ohanah_events') . ' ORDER BY `ohanah_event_id`';
		} else {
			if (is_array($categories)) {
				$categories = implode(',', $categories);
			}

			$query = 'SELECT `ohanah_event_id` FROM ' . $db->nameQuote('#__ohanah_events') . ' WHERE `ohanah_category_id` IN (' . $categories . ') ORDER BY `ohanah_event_id`';
		}

		$db->setQuery($query);
		return $db->loadResultArray();
	}

	public function getCategories()
	{
		$db = KT::db();
		$query = 'SELECT c.ohanah_category_id AS id, c.title'
				. ' FROM `#__ohanah_categories` as c';
		$db->setQuery($query);
		$categories	= $db->loadObjectList();

		return $categories;
	}

	public function isListingView()
	{
		$views = array('events');

		return in_array($this->input->get('view', '', 'string'), $views);
	}

	public function isEntryView()
	{
		return $this->input->get('view', '', 'string') == 'event';
	}

	public function onExecute(&$article, $html, $view, $options = array())
	{
		if ($view == 'listing') {
			$article->text .= $html;
			return $html;
		}

		if ($view == 'entry') {
			// Since we are using onBeforeContentDisplay,
			// We need to append the komento form below the description
			$article->description .= $html;
		}
	}

	public function getEventTrigger()
	{
		$trigger = 'onContentBeforeDisplay';

		return $trigger;
	}

	public function getContext()
	{
		$context = 'com_ohanah.event';

		return $context;
	}

	public function onBeforeLoad($eventTrigger, $context, &$article, &$params, &$page, &$options)
	{
		// We got to go through 3 checks:
		// 1. Check if POST parameter have id (this is when user go to an event page through event listings)
		// 2. Check if page parameter have id (this is when user assign an event on a menu item)
		// 3. Find back the id based on text parameter passed in (this was the old trigger before changing from onPrepareContent to onAfterDisplayContent for Joomla 1.5)

		$cid = $this->input->get('id', 0, 'int');

		if (!$cid) {
			$pageParameters = JFactory::getApplication()->getPageParameters();
			$cid = $pageParameters->get('id');
		}

		if (!$cid) {

			// Bad fallback due to limited data that is being passed in
			// Use the description text to backtrace and search for the article id
			$text = $article->text;
			$text = str_ireplace('<!--{emailcloak=off}-->', '', $text);
			$db = KT::db();
			$query = 'SELECT ohanah_event_id FROM `#__ohanah_events` WHERE description = ' . $db->quote($text);
			$db->setQuery($query);
			$cid = $db->loadResult();
		}

		// If we still can't get the id of the ohanah event, we'll try to load it based on the "slug"
		$slug = $this->input->get('slug', '', 'string');

		if (!$cid && $slug) {

			// Query the database to retrieve the id of the event
			$db = KT::db();
			$query = 'select `ohanah_event_id` from `#__ohanah_events` WHERE `slug`=' . $db->Quote($slug);
			$db->setQuery($query);
			$cid = $db->loadResult();
		}

		// If cid is still empty then we don't continue
		if (empty($cid)) {
			return false;
		}

		$article->id = $cid;

		return true;
	}
}