<?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
 */
// no direct access
defined('_JEXEC') or die('Restricted access');

/**
 * Class exists checking
 */
if (!class_exists('modCommunityPhotoComments')) {

    /**
     *
     */
    class modCommunityPhotoComments {

        /**
         *
         * @param type $params
         * @return type
         */
        static public function getList(&$params) {
            $user = CFactory::getUser();
            $db = JFactory::getDBO();

            $extraQuery = '';
            switch($params->get('album_type',0)){
                case 1 :
                    //profile albums
                    $extraQuery = " AND c.".$db->quoteName('type')." LIKE '%profile%'";
                    break;
                case 2 :
                    //group albums
                    $extraQuery = ' AND c.'.$db->quoteName('type').' LIKE '.$db->quote('%group%');
                    break;
                case 3 :
                    //event albums
                    $extraQuery = ' AND c.'.$db->quoteName('type').' LIKE '.$db->quote('%event%');
                    break;
                default :
                    //all albums
            }

            /* Do query */

            $query = 'SELECT a.*,b.*,c.' . $db->quoteName('type') . ' as phototype,c.' . $db->quoteName('groupid')
                    . ' FROM ' . $db->quoteName('#__community_wall') . ' AS a '
                    . ' INNER JOIN ' . $db->quoteName('#__community_photos') . ' AS b '
                    . ' ON a.' . $db->quoteName('contentid') . '=b.' . $db->quoteName('id')
                    . ' INNER JOIN ' . $db->quoteName('#__community_photos_albums') . ' AS c '
                    . ' ON b.' . $db->quoteName('albumid') . '=c.' . $db->quoteName('id')
                    . ' WHERE a.' . $db->quoteName('type') . ' =' . $db->Quote('photos')
                    . ' AND a.'.$db->quoteName('comment').' != "" '
                    . $extraQuery
                    . ' ORDER BY a.' . $db->quoteName('date') . ' DESC ';
            $db->setQuery($query);
            $comments = $db->loadObjectList();

            //Once results are loaded, filter the count and the user premission level
            $counter = $params->get('limit', 10);
            $data = array();

            foreach ($comments as $comment) {
                /* permission checking */
                $permission = CPrivacy::getAccessLevel($user->id, $comment->creator);
                if ($permission >= $comment->permissions) {
                    $data[] = $comment;
                    if (--$counter == 0) {
                        break;
                    }
                }
            }

            return $data;
        }

    }

}