<?php
/**
* @package      Komento
* @copyright    Copyright (C) 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');
require_once(JPATH_ROOT . '/components/com_easyblog/router.php');

class KomentoComeasyblog3 extends KomentoExtension
{
	public $_item;
	public $_map = [
		'id' => 'id',
		'title' => 'title',
		'hits' => 'hits',
		'created_by' => 'created_by',
		'catid' => 'category_id',
		'permalink' => 'permalink',
		'state' => 'published'
		);

	public function __construct( $component )
	{
		$this->addFile( JPATH_ROOT . '/components/com_easyblog/helpers/helper.php' );

		parent::__construct( $component );
	}

	public function load($cid )
	{
		static $instances = [];

		if (!isset( $instances[$cid])) 
		{
			$this->_item = EasyBlogHelper::getTable( 'Blog', 'Table' );

			if (!$this->_item->load($cid)) {
				return $this->onLoadArticleError( $cid );
			}

			$blogger = EasyBlogHelper::getTable( 'Profile', 'Table' );
			$blogger->load( $this->_item->created_by );

			$this->_item->blogger = $blogger;

			$link = 'index.php?option=com_easyblog&view=entry&id=' . $this->getContentId();

			// forcefully get item id if request is ajax
			$format = $this->input->get('format', 'html', 'string');

			if ($format === 'ajax') {
				$itemid = $this->input->get('pageItemId', 0, 'int');

				if (!empty($itemid)) {
					$link .= '&Itemid=' . $itemid;
				}
			}

			$link   = EasyBlogRouter::_( $link );
			$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 )) {
			$groups = KT::getUsergroups();
			$gids = [];

			foreach ($groups as $group) {
				$gids[] = $group->id;
			}
			$user   = JFactory::getUser();

			$result = [];

			// Get all the categories first
			$query = 'SELECT ' . $db->nameQuote( 'id' ) . ' FROM ' . $db->nameQuote( '#__easyblog_category' ) . ' WHERE ' . $db->nameQuote( 'private' ) . ' = ' . $db->quote( '0' );

			if (!$user->guest) {
				$query .= ' OR ' . $db->nameQuote( 'private' ) . ' = ' . $db->quote( '1' );
			}

			$db->setQuery( $query );
			$result = array_merge( $result, $db->loadResultArray() );

			$query = 'SELECT DISTINCT (' . $db->nameQuote( 'a' ) . '.' . $db->nameQuote( 'id' ) . ') FROM ' . $db->nameQuote( '#__easyblog_category' ) . ' AS ' . $db->nameQuote( 'a' );
			$query .= ' LEFT JOIN ' . $db->nameQuote( '#__easyblog_category_acl' ) . ' AS ' . $db->nameQuote( 'b' );
			$query .= ' ON ' . $db->nameQuote( 'b' ) . '.' . $db->nameQuote( 'category_id' ) . ' = ' . $db->nameQuote( 'a' ) . '.' . $db->nameQuote( 'id' );
			$query .= ' WHERE ' . $db->nameQuote( 'a' ) . '.' . $db->nameQuote( 'private' ) . ' = ' . $db->quote( '2' );
			$query .= ' AND ' . $db->nameQuote( 'b' ) . '.' . $db->nameQuote( 'acl_id' ) . ' = ' . $db->quote( '1' );
			$query .= ' AND ' . $db->nameQuote( 'b' ) . '.' . $db->nameQuote( 'content_id' ) . ' IN (' . $gids . ')';

			$db->setQuery( $query );
			$result = array_merge( $result, $db->loadResultArray() );

			$categories = implode( ',', $result );

			$query = 'SELECT ' . $db->nameQuote( 'id' ) . ' FROM ' . $db->nameQuote( '#__easyblog_post' );
			$query .= ' WHERE ' . $db->nameQuote( 'category_id' ) . ' IN (' . $categories . ')';
			$query .= ' ORDER BY ' . $db->nameQuote( 'id' );

		} else {
			
			if (is_array($categories)) {
				$categories = implode( ',', $categories );
			}

			$query = 'SELECT `id` FROM ' . $db->nameQuote( '#__easyblog_post' ) . ' WHERE `category_id` IN (' . $categories . ') ORDER BY `id`';
		}

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

	public function getCategories()
	{
		$db     = KT::db();
		$query  = 'SELECT a.`id`, a.`title`, a.`parent_id`, count(b.`id`) - 1 AS level'
				. ' FROM `#__easyblog_category` AS a'
				. ' INNER JOIN `#__easyblog_category` AS b ON a.`lft` BETWEEN b.`lft` and b.`rgt`'
				. ' GROUP BY a.`id`'
				. ' ORDER BY a.`lft` ASC';

		$db->setQuery( $query );
		$categories = $db->loadObjectList();

		foreach ($categories as &$row) {
			$repeat = $row->level;
			$row->treename = str_repeat('.&#160;&#160;&#160;', $repeat) . ($row->level > 0 ? '|_&#160;' : '') . $row->title;
		}

		return $categories;
	}

	public function getCommentAnchorId()
	{
		return 'comments';
	}

	public function isListingView()
	{
		// integration done in Easyblog
		return false;
	}

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

	public function onExecute( &$article, $html, $view, $options = array() )
	{
		if ($view == 'entry' && $options['trigger']  == 'onDisplayComments') {
			return $html;
		}
	}

	public function getEventTrigger()
	{
		return 'onDisplayComments';
	}

	public function getAuthorName()
	{
		return $this->_item->blogger->getName();
	}

	public function getAuthorPermalink()
	{
		return $this->_item->blogger->getProfileLink();
	}

	public function getAuthorAvatar()
	{
		return $this->_item->blogger->getAvatar();
	}
}