<?php
/**
* @copyright (C) 2013 iJoomla, Inc. - All rights reserved.
* @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html)
* @author iJoomla.com <webmaster@ijoomla.com>
* @url https://www.jomsocial.com/license-agreement
* The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0
* More info at https://www.jomsocial.com/license-agreement
*/
defined('_JEXEC') or die('Restricted access');

use Joomla\CMS\Factory;

if(!class_exists('modCommunityDiscussions'))
{
    class modCommunityDiscussions
    {
        var $db;
        var $limit;
        var $filter;
        var $groups;
        var $show_avatar;

        function __construct( $params )
        {
            $this->db       = Factory::getDBO();
            $this->limit    = $params->get( 'limit' , 10 );
            $this->filter     = $params->get( 'displaysetting', 0 );
            $this->groups   = $params->get('jsgroup', array());
            $this->show_avatar = $params->get('show_avatar', 0);
        }

        function getDiscussion($showPrivateDiscussion = TRUE)
        {
            $filter = '';
            if($this->filter == 2){
                //type 2 is group specific
                if(empty($this->groups)){
                    return array();
                }

                $groups = implode(',', $this->groups);
                $filter = ' AND g.id IN('.$groups.') ';
            }elseif($this->filter == 1){
                //1 = show own discussion only
                $my = Factory::getUser();
                $filter = ' AND a.creator = '.$this->db->quote($my->id).' ';
            }

            $privacyCondition = ' ';
            if(empty($showPrivateDiscussion))
            {
                $privacyCondition = ' AND g.approvals = ' . $this->db->quote('0') . ' ';
            }

            $sql        = 'SELECT a. * , count( b.id ) AS counter, c.name AS username '
                        . 'FROM ' . $this->db->quoteName( '#__community_groups_discuss' ) . ' AS a '
                        . 'INNER JOIN ' . $this->db->quoteName( '#__users' ) . ' AS c ON a.creator = c.id '
                        . 'LEFT JOIN ' . $this->db->quoteName( '#__community_wall' ) . ' AS b ON b.contentid = a.id '
                        . 'AND b.type = ' . $this->db->Quote('discussions') . ' '
                        . 'AND a.parentid = ' . $this->db->Quote('0'). ' '
                        . 'INNER JOIN ' . $this->db->quoteName('#__community_groups') . 'AS g ON g.id = a.groupid '
                        . 'WHERE g.published = ' . $this->db->quote('1') . ' '
                        . $privacyCondition
                        . $filter
                        . 'GROUP BY a.id '
                        . 'ORDER BY a.created DESC '
                        . 'LIMIT ' . $this->limit;
            $query = $this->db->setQuery($sql);
            try {
                $row = $this->db->loadObjectList();
            } catch (Exception $e) {
                Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
            }

            return $row;
        }

        function getGroupName($id)
        {
            $sql ='SELECT name '
                . 'FROM ' . $this->db->quoteName( '#__community_groups' ) . ' '
                . 'WHERE ' . $this->db->quoteName( 'id' ) . ' = ' . $this->db->quote( $id );

            $query = $this->db->setQuery($sql);
            try {
                $row = $this->db->loadObject();
            } catch (Exception $e) {
                Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
            }

            return $row->name;
        }
    }
}