<?php
/**
 * @package RSFeedback! Komento integration
 * @copyright (C) 2010-2018 www.rsjoomla.com
 * @license GPL, http://www.gnu.org/copyleft/gpl.html
 */
defined('_JEXEC') or die('Unauthorized Access');

class KomentoComRSFeedback extends KomentoExtension
{
    public $_item;

    public $_map = array(
        'id'			=> 'id',
        'catid'			=> 'cat_id',
        'created_by'	=> 'user_id',
        'title'			=> 'title',
        'hits'			=> 'hits',
        'state'         => 'published'
    );

    public function __construct($component)
    {
        // Add com_rsfeedback's helper & router file
        $this->addFile(JPATH_ROOT . '/components/com_rsfeedback/helpers/rsfeedback.php');
        $this->addFile(JPATH_ROOT . '/components/com_rsfeedback/helpers/route.php');

        $lang 		= JFactory::getLanguage();
        $lang->load('com_rsfeedback');

        parent::__construct($component);
    }

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

        if( !isset( $instances[$cid] ) )
        {
            $db		= JFactory::getDBO();
            $query  = $db->getQuery(true);

            $query->select(
                    $db->qn('f.id').', '.
                    $db->qn('f.title').', '.
                    $db->qn('f.cat_id').', '.
                    $db->qn('f.user_id').', '.
                    $db->qn('f.hits').', '.
                    $db->qn('f.published').', '.
                    $db->qn('c.name', 'category_title').', '.
                    $db->qn('u.name', 'author'))
                ->from($db->qn( '#__rsfeedback_feedbacks', 'f'))
                ->join('left', $db->qn( '#__rsfeedback_categories', 'c').' ON '.$db->qn('c.id').' = '.$db->qn('f.cat_id'))
                ->join('left', $db->qn( '#__users', 'u').' ON '.$db->qn('u.id').' = '.$db->qn('f.user_id'))
                ->where($db->qn('f.id') . ' = ' . $db->q( (int) $cid ));
            $db->setQuery( $query );

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

            $instances[$cid] = $result;
        }

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

        return $this;
    }

    public function getContentIds( $categories = '' )
    {
        $db		= JFactory::getDBO();
        $query = $db->getQuery(true);

        if( empty( $categories ) )
        {
            $query->select($db->qn('id'))->from($db->qn('#__rsfeedback_feedbacks'))->order($db->qn('id'));
        }
        else
        {
            if( is_array( $categories ) )
            {
                $categories = implode( ',', $categories );
            }
            $query->select($db->qn('id'))->from($db->qn('#__rsfeedback_feedbacks'))->where($db->qn('cat_id').' IN (' . $categories . ')')->order($db->qn('id'));
        }
        $db->setQuery( $query );

        return $db->loadColumn();
    }

    public function getCategories()
    {
        $db		= JFactory::getDBO();
        $query  = $db->getQuery(true)->select($db->qn('c.id'). ', ' .$db->qn('c.name', 'title'))->from($db->qn('#__rsfeedback_categories', 'c'))->order('c.ordering');

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

        return $categories;
    }

    public function isListingView()
    {
        $views = array('categories', 'feedbacks');

        return in_array(JFactory::getApplication()->input->get('view', '', 'cmd'), $views);
    }

    public function isEntryView()
    {
        return JFactory::getApplication()->input->get('view', '', 'cmd') == 'feedback';
    }

    public function onExecute( &$article, $html, $view, $options = array() )
    {
        return $html;
    }

    public function getContentPermalink()
    {
        return $this->prepareLink(RSFeedbackRoute::Feedback($this->_item->id, JFactory::getApplication()->input->get('tmpl', '', 'cmd')));
    }
    
    public function getContext()
    {
        if ($this->isEntryView()) {
            return 'com_rsfeedback.feedback';
        }

        if ($this->isListingView()) {
            return false;
        }

        return false;
    }
}