<?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
 */

use Joomla\CMS\Factory;
use Joomla\CMS\Table\Table;
use Joomla\CMS\Uri\Uri;
use Joomla\Filesystem\File;
use Joomla\Filesystem\Folder;
use Joomla\Registry\Registry;

defined('_JEXEC') or die('Restricted access');

Table::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_community/tables');

class CTablePhoto extends Table {

    var $id = null;
    var $albumid = null;
    var $caption = null;
    var $permissions = null;
    var $created = null;
    var $thumbnail = null;
    var $image = null;
    var $creator = null;
    var $published = null;
    var $original = null;
    var $filesize = null;
    var $storage = 'file';
    var $hits = 0;
    var $ordering = null;
    var $status = null;
    var $params = null;
    private $_params = null;

    /**
     * Constructor
     */
    public function __construct(&$db) {
        parent::__construct('#__community_photos', 'id', $db);
        $this->_params = new Registry($this->params);
    }

    /**
     * 	Allows us to test if the user has access to the album
     * */
    public function hasAccess($userId, $permissionType) {
        //CFactory::load( 'helpers' , 'owner' );
        // @rule: For super admin, regardless of what permission, they should be able to access
        if (COwnerHelper::isCommunityAdmin())
            return true;

        $album = Table::getInstance('Album', 'CTable');
        $album->load($this->albumid);

        switch ($album->type) {
            case PHOTOS_USER_TYPE:

                if ($permissionType == 'delete') {
                    return $this->creator == $userId;
                }

                break;
            case PHOTOS_GROUP_TYPE:

                //CFactory::load( 'models' , 'groups' );
                $group = Table::getInstance('Group', 'CTable');
                $group->load($album->groupid);

                if ($permissionType == 'delete') {
                    return $album->creator == $userId || COwnerHelper::isMine($userId, $this->creator) || $group->isAdmin($userId);
                }

                return false;
                break;
            case PHOTOS_PAGE_TYPE:
                $page = Table::getInstance('Page', 'CTable');
                $page->load($album->pageid);

                if ($permissionType == 'delete') {
                    return $album->creator == $userId || COwnerHelper::isMine($userId, $this->creator) || $page->isAdmin($userId);
                }

                return false;
                break;
        }
    }

    /**
    * Allows us to test if the user has access to the photo
    * @param userId integer
    * @param id integer, Group or Event Id
    * @param type string, Group or Event
    */
    public function hasPhotoOwner($userId = 0, $id = 0, $type = null) {
        // @rule: For super admin and group admin/owner, regardless of what permission, they should be able to access
        if (COwnerHelper::isCommunityAdmin()) {
            return true;
        } else if ($id && $type) {
            if ($type == 'group') { 
                $group = Table::getInstance('Group', 'CTable');
                $group->load($id);

                if ($group->isAdmin($userId)) {
                    return true;
                }
            } else {
                $event = Table::getInstance('Event', 'CTable');
                $event->load($id);
                
                if ($event->isAdmin($userId)) {
                    return true;
                }
            }
        }

        if ($userId == $this->creator) {
            return true;
        }

        return false;
    }

    public function getNextPhoto() {
        $db = Factory::getDBO();
        $query = 'SELECT * FROM ' . $db->quoteName('#__community_photos') . ' '
                . 'WHERE ' . $db->quoteName('albumid') . '=' . $db->Quote($this->albumid) . ' '
                . 'ORDER BY ' . $db->quoteName('ordering') . ' ASC '
                . 'LIMIT 1';

        $db->setQuery($query);
        $result = $db->loadObject();

        $photo = Table::getInstance('Photo', 'CTable');
        if (!is_null($result))
            $photo->bind($result);

        return $photo;
    }

    public function check() {
        //CFactory::load( 'helpers', 'string');
        // Santinise data
        $safeHtmlFilter = CFactory::getInputFilter();
        $this->caption = CStringHelper::nl2br($safeHtmlFilter->clean($this->caption));

        return true;
    }

    /**
     * Overrides parent store function as we need to clean up some variables
     * */
    public function store($updateNulls = false) {
        if (!$this->check()) {
            return false;
        }

        $this->image = CString::str_ireplace('\\', '/', $this->image);
        $this->thumbnail = CString::str_ireplace('\\', '/', $this->thumbnail);
        $this->original = CString::str_ireplace('\\', '/', $this->original);

        $isGif = ($this->_params->get('animated_gif')) ? true : false;

        // Store params

        if($this->id && !is_string($this->params)){
            $this->params = $this->_params->toString();
        }else{
            if($this->params instanceof CParameter) {
                $this->params = $this->params->toString();
            }
        }

        $parameter = new CParameter($this->params);
        $isGif = ($parameter->get('animated_gif')) ? true : false;


        //lets add watermark if there is any and only for new photos and do not add this to Gif
        if(CPhotosHelper::photoWatermarkEnabled() && !$this->id && !$isGif){

            $config = CFactory::getConfig();
            $watermark = JPATH_ROOT .'/'. COMMUNITY_WATERMARKS_PATH .'/'.WATERMARK_DEFAULT_NAME.'.png';
            list( $watermarkWidth , $watermarkHeight )	= getimagesize( $watermark );
            //original photo
            $thumbPath = JPATH_ROOT .'/'.$this->original;

            if(!$this->original){
                //if empty, add the watermark to image
                $thumbPath = JPATH_ROOT .'/'.$this->image;
            }

            if(file_exists($thumbPath) && is_file($thumbPath)){
                $thumbInfo		= getimagesize( $thumbPath );
                $thumbWidth		= $thumbInfo[ 0 ];
                $thumbHeight	= $thumbInfo[ 1 ];
                $thumbMime		= $thumbInfo[ 'mime' ];
                if($config->get('min_width_img_watermark') <= $thumbWidth && $config->get('min_height_img_watermark') <= $thumbHeight
                    && $thumbHeight >= $watermarkHeight && $thumbWidth >= $watermarkWidth){
                    $thumbPosition	= $this->_getPositions( $config->get('watermark_position') , $thumbWidth , $thumbHeight , $watermarkWidth , $watermarkHeight );
                    CImageHelper::addWatermark( $thumbPath , $thumbPath , $thumbMime , $watermark , $thumbPosition->x , $thumbPosition->y );
                }
            }
        }

        //do not use the photo name as the caption for the first time when uploaded
        if(!$this->id){
            $this->caption = '';
        }

        $result = parent::store();

        if ($this->status != 'temp' && $result) {
            // Changes in photos will affect the album. Do a store on album
            $album = Table::getInstance('Album', 'CTable');
            $album->load($this->albumid);
            $album->store();
        }

        return $result;
    }

    /**
     * Retrieve the proper x and y position depending on the user's choice of the watermark position.
     **/
    private function _getPositions( $location , $imageWidth , $imageHeight , $watermarkWidth , $watermarkHeight )
    {
        $position	= new stdClass();

        // @rule: Get the appropriate X/Y position for the avatar
        switch( $location )
        {
            case 'left_top':
                $position->x	= 0;
                $position->y	= 0;
                break;
            case 'right_top':
                $position->x	= $imageWidth -  $watermarkWidth;
                $position->y	= 0;
                break;
            case 'left_bottom':
                $position->x	= 0;
                $position->y	= $imageHeight - $watermarkHeight;
                break;
            case 'right_bottom':
                $position->x 	= $imageWidth - $watermarkWidth;
                $position->y	= $imageHeight - $watermarkHeight;
                break;
        }
        return $position;
    }

    /**
     * Delete the photo, the original and the actual resized photos and thumbnails
     */
    public function delete($pk = null) {
        $storage = CStorage::getStorage($this->storage);

        if($this->image){
            $storage->delete($this->image);
        }

        if($this->thumbnail){
            $storage->delete($this->thumbnail);
        }

        // delete animated temp file
        $isGIF = pathinfo($this->image, PATHINFO_EXTENSION);
        if (strtolower($isGIF) == 'gif') {
            $animatedGifFile = preg_replace('/^(.*)\.' . $isGIF . '$/', '$1_animated.' . $isGIF, $this->image);
            $storage->delete($animatedGifFile);
        }

        /* We did store original than now time to remove it */
        if (!empty($this->original)) {
            /* Original do not sync with 3rd storage than we don't need to use $storage->delete; even it would be same */
            if (is_file(JPATH_ROOT . '/' . $this->original)) {
                File::delete(JPATH_ROOT . '/' . $this->original);
            }
            $originalDir = dirname(JPATH_ROOT . '/' . $this->original);
            $files = Folder::files($originalDir);
            /* If the original path is empty, we can delete it too */
            if (empty($files)) {
                Folder::delete($originalDir);
            }
        }

        // if the photo is the album cover, set the album cover as default 0
        $album = Table::getInstance('Album', 'CTable');
        $album->load($this->albumid);
        if($album->photoid == $this->id){
            $album->set('photoid', 0);
            $album->store();
        }

        // delete the tags
        CFactory::load('libraries', 'phototagging');
        $phototagging = new CPhotoTagging();
        $phototagging->removeTagByPhoto($this->id);

        // delete the activities
        CActivities::remove('photos', $this->id);
        //Remove photo from activity stream
        CActivityStream::remove('photo.like', $this->id);

        // delete the comments
        $wall = CFactory::getModel('wall');
        $wall->deleteAllChildPosts($this->id, 'photos');

        // do a check on current user avatar, remove the avatar too if this photo is the avatar
        $my = CFactory::getUser();
        $params = $my->getParams();
        $avatarid = $params->get('avatar_photo_id');

        if($this->id == $avatarid){
            //reset the user avatar
            $userModel = CFactory::getModel('User');
            $userModel->removeProfilePicture($my->id, 'avatar');
            $userModel->removeProfilePicture($my->id, 'thumb');
        }

        $db = Factory::getDbo();
        //remove all stats from the photo stats
        $query = "DELETE FROM ".$db->quoteName('#__community_photo_stats')
            ." WHERE ".$db->quoteName('pid')."=".$db->quote($this->id);
        $db->setQuery($query);
        $db->execute();

        /* And now finally we do delete this photo in database */
        /* return parent::delete(); */

        /**
         * @since 3.2
         * We do not delete database record for now. Leave it for cron !
         * @todo Considering local files should be deleted this time or not ?
         */
        $this->published = 0;
        $this->status = 'delete';
        $this->store();
    }

    /**
     * Return the exact URL
     */
    public function getThumbURI() {
        // CDN or local
        $config = CFactory::getConfig();
        $file = $this->thumbnail;

        // Remote storage
        if ($this->storage != 'file') {

            $storage = CStorage::getStorage($this->storage);
            $uri = $storage->getURI($file);
            return $uri;
        }

        // Default avatar
        if (empty($file) || !is_file(JPATH_ROOT . '/' . $file)) {

            $template = new CTemplateHelper();
            $asset = $template->getTemplateAsset('photo_thumb.png', 'images');
            $uri = $asset->url;
            return $uri;
        }

        // Strip cdn path if exists.
        // Note: At one point, cdn path was stored along with the avatar path
        //       in the db which is the mistake we are trying to rectify here.
        $file = str_ireplace($config->get('photocdnpath'), '', $file);

        // CDN or local
        $baseUrl = $config->get('photobaseurl') or
                $baseUrl = Uri::root();
        $uri = str_replace('\\', '/', rtrim($baseUrl, '/') . '/' . ltrim($file, '/'));
        return $uri;
    }

    /**
     * Return unencoded version of thr uri
     */
    public function getRawPhotoURI() {
        $album = Table::getInstance('Album', 'CTable');
        $album->load($this->albumid);


        $url = 'index.php?option=com_community&view=photos&task=photo&albumid=' . $album->id;
        $url .= $album->groupid ? '&groupid=' . $album->groupid : '&userid=' . $album->creator;
        $url .= '&photoid=' . $this->id;
        return $url;
    }

    public function getPhotoURI($external = false, $xhtml = true) {
        return $this->getPhotoLink($external, $xhtml);
    }

    public function getPhotoLink($external = false, $xhtml = true) {
        $url = $this->getRawPhotoURI();

        if ($external) {
            return CRoute::getExternalURL($url);
        }

        return CRoute::_($url, $xhtml);
    }

    /**
     * Return the exist URL to be displayed.
     * @param size string, (normal, origianl, small)
     */
    public function getImageURI($size = 'normal') {

        $uri = '';
        if ($this->storage != 'file') {
            $storage = CStorage::getStorage($this->storage);
            $uri = $storage->getURI($this->image);
        } else {
            $config = CFactory::getConfig();
            $baseUrl = $config->get('photobaseurl');

            if (!empty($baseUrl)) {
                if (is_file(JPATH_ROOT . '/' . $this->image)) {
                    //$uri	= rtrim( $baseUrl , '/' ) . '/' . $this->image;
                    // Strip cdn path if necessary
                    $path = $this->image;

                    $cdnpath = $config->get('photocdnpath');
                    if ($cdnpath) {
                        $path = str_replace($cdnpath, '', $path);
                    }
                    $path = ltrim($path, '/');
                    $uri = rtrim($baseUrl, '/') . '/' . $path;
                } else {
                    $uri = Uri::root() . 'index.php?option=com_community&view=photos&task=showimage&tmpl=component&imgid=' . $this->image;
                }
            } else {
                // If the resized photos exist, use it instead
                if (is_file(JPATH_ROOT . '/' . $this->image)) {
                    $uri = Uri::root() . $this->image;
                } else {
                    $uri = Uri::root() . 'index.php?option=com_community&view=photos&task=showimage&tmpl=component&imgid=' . $this->image;
                }
            }
        }
        return $uri;
    }

    public function getGifURI(){
        $uri = '';
        $params = new Registry($this->params);
        if($params->get('animated_gif','') == ''){
            return false;
        }
        return Uri::root().$params->get('animated_gif',''); //we will need to implement s3 related if we are going to store this in s3
    }

    /**
     * Return the URI of the original photo
     */
    public function getOriginalURI() {
        if (is_file(JPATH_ROOT . '/' . $this->original)) {
            return rtrim(Uri::root(), '/') . '/' . $this->original;
        }

        // If original url was deleted, we use the resized image as the original photo
        return rtrim(Uri::root(), '/') . '/' . $this->image;
    }

    // Load the Photo object given the image path
    public function loadFromImgPath($path) {
        $db = Factory::getDBO();

        $strSQL = 'SELECT ' . $db->quoteName('id') . ' FROM ' . $db->quoteName('#__community_photos')
                . 'WHERE ' . $db->quoteName('image') . '=' . $db->Quote($path);

        //echo $strSQL;
        $db->setQuery($strSQL);
        try {
            $result = $db->loadObject();
        } catch (Exception $e) {
            Factory::getApplication()->enqueueMessage($e->getMessage(), 'error');
        }

        // Backward compatibility because anything prior to this version uses id
        // @since 1.6
        if (!$result) {
            $id = $path;
            $this->load($id);
            return $id;
        }

        $this->load($result->id);
        return $result;
    }

    /**
     * Override parent's hit method as we don't really want to
     * carefully increment it every time a photo is viewed.
     * */
    public function hit($pk = null) {
        $session = Factory::getSession();
        if ($session->get('photo-view-' . $this->id, false) == false) {
            parent::hit();
            $session->set('photo-view-' . $this->id, true);

            //@since 4.1 we dump the info into photo stats
            $statsModel = CFactory::getModel('stats');
            $statsModel->addPhotoStats($this->id,'view');

            //@rule: We need to test if the album for this photo also has the hits.
            // otherwise it would not tally when photo has large hits but not the album.
            // The album hit() will take care of the album hits session correctly.
            $album = Table::getInstance('Album', 'CTable');
            $album->load($this->albumid);
            $album->hit();
        }
    }

    /**
     * Set the ordering of the current photo based on the maximum
     * ordering in the photos table for the current album.
     * */
    public function setOrdering() {
        $db = Factory::getDBO();

        $this->ordering = $this->getNextOrder($db->quoteName('albumid') . '=' . $db->Quote($this->albumid));
    }

    public function lastId() {
        $db = Factory::getDBO();

        $query = 'SELECT ' . $db->quoteName('id') . ' FROM ' . $db->quoteName('#__community_photos') . ' ORDER BY ' . $db->quoteName('id') . ' DESC';

        $db->setQuery($query);
        $result = $db->loadObject();

        return $result->id;
    }

    public function getInfo() {
        $path = JPATH_ROOT . '/' . $this->image;
        if ( is_file($path)) {
             $info = getimagesize ( $path);
             if ( $info[0] > $info[1])  {
                 $info['size'] = 'landscape';
             } else {
                 if ( $info[0] == $info[1]) {
                     $info['size'] = 'square';
                 } else {
                     if ( $info[0] < $info[1]) {
                         $info['size'] = 'portrait';
                     }
                 }
             }
             return $info;
        }
       return false;
    }
}