mambax7 / xooghost

class/RldHandler.php

<?php

namespace XoopsModules\Xooghost;

/**
 * Xooghost module
 *
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 *
 * @copyright       XOOPS Project (https://xoops.org)
 * @license         GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
 * @package         Xooghost
 * @since           2.6.0
 * @author          Laurent JEN (Aka DuGris)
 */
use Xoops\Core\Database\Connection;

/**
 * Class XooghostRldHandler
 */
class RldHandler extends \XoopsPersistableObjectHandler
{
    public $db;

    /**
     * @param null|\Xoops\Core\Database\Connection $db
     */
    public function __construct(Connection $db = null)
    {
        $this->db = $db;
        parent::__construct($db, 'xooghost_rld', Rld::class, 'xooghost_rld_id', 'xooghost_rld_page');
    }

    /**
     * @return mixed
     */
    public static function getInstance()
    {
        static $instance;
        if (!isset($instance)) {
            $class = __CLASS__;
            $instance = new $class($db);
        }

        return $instance;
    }

    /**
     * @param $page_id
     *
     * @return int
     */
    public function getVotes($page_id)
    {
        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('xooghost_rld_page', $page_id));
        $criteria->add(new \Criteria('xooghost_rld_rates', 0, '!='));

        return parent::getCount($criteria);
    }

    /**
     * @param $page_id
     *
     * @return int
     */
    public function getbyUser($page_id)
    {
        $xoops = \Xoops::getInstance();
        $uid = $xoops->isUser() ? $xoops->user->getVar('uid') : 0;
        $ip = $xoops->getEnv('REMOTE_ADDR');

        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('xooghost_rld_page', $page_id));

        $criteria2 = new \CriteriaCompo();
        $criteria2->add(new \Criteria('xooghost_rld_uid', $uid), 'OR');
        $criteria2->add(new \Criteria('xooghost_rld_ip', $ip), 'OR');
        $criteria->add($criteria2, 'AND');
        $tmp = $this->getObjects($criteria, false, false);
        if (0 != count($tmp)) {
            return $tmp[0]['xooghost_rld_rates'];
        }

        return 0;
    }

    /**
     * @param $page_id
     * @param $like_dislike
     *
     * @return bool
     */
    public function setLikeDislike($page_id, $like_dislike)
    {
        $xoops = \Xoops::getInstance();
        $uid = $xoops->isUser() ? $xoops->user->getVar('uid') : 0;
        $ip = $xoops->getEnv('REMOTE_ADDR');
        $like = (1 == $like_dislike) ? 1 : 0;
        $dislike = (0 == $like_dislike) ? 1 : 0;

        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('xooghost_rld_page', $page_id));

        $criteria2 = new \CriteriaCompo();
        $criteria2->add(new \Criteria('xooghost_rld_uid', $uid), 'OR');
        $criteria2->add(new \Criteria('xooghost_rld_ip', $ip), 'OR');
        $criteria->add($criteria2, 'AND');
        $tmp = $this->getObjects($criteria, false, false);
        if (0 == count($tmp)) {
            $rldObject = $this->create();
            $rldObject->setVar('xooghost_rld_page', $page_id);
            $rldObject->setVar('xooghost_rld_uid', $uid);
            $rldObject->setVar('xooghost_rld_time', time());
            $rldObject->setVar('xooghost_rld_ip', $ip);
            $rldObject->setVar('xooghost_rld_rates', 0);
            $rldObject->setVar('xooghost_rld_like', $like);
            $rldObject->setVar('xooghost_rld_dislike', $dislike);
            if ($this->insert($rldObject)) {
                return true;
            }
        }

        return false;
    }

    /**
     * @param $page_id
     * @param $vote
     *
     * @return array|bool
     */
    public function setRate($page_id, $vote)
    {
        $xoops = \Xoops::getInstance();
        $uid = $xoops->isUser() ? $xoops->user->getVar('uid') : 0;
        $ip = $xoops->getEnv('REMOTE_ADDR');

        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('xooghost_rld_page', $page_id));

        $criteria2 = new \CriteriaCompo();
        $criteria2->add(new \Criteria('xooghost_rld_uid', $uid), 'OR');
        $criteria2->add(new \Criteria('xooghost_rld_ip', $ip), 'OR');
        $criteria->add($criteria2, 'AND');
        $tmp = $this->getObjects($criteria, false, false);
        if (0 == count($tmp)) {
            $rldObject = $this->create();
            $rldObject->setVar('xooghost_rld_page', $page_id);
            $rldObject->setVar('xooghost_rld_uid', $uid);
            $rldObject->setVar('xooghost_rld_time', time());
            $rldObject->setVar('xooghost_rld_ip', $ip);
            $rldObject->setVar('xooghost_rld_rates', $vote);
            $rldObject->setVar('xooghost_rld_like', 0);
            $rldObject->setVar('xooghost_rld_dislike', 0);
            if ($tmp = $this->insert($rldObject)) {

The assignment to $tmp is dead and can be removed.

                return $this->getAverage($page_id, $vote);
            }
        }

        return false;
    }

    /**
     * @param $page_id
     * @param $vote
     *
     * @return array
     */
    private function getAverage($page_id, $vote)
    {
        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('xooghost_rld_page', $page_id));
        $criteria->add(new \Criteria('xooghost_rld_rates', 0, '!='));

        $res = $this->getObjects($criteria, false, false);
        $rates = 0;
        $voters = 0;
        foreach ($res as $k => $v) {
            $rates += $v['xooghost_rld_rates'];
            ++$voters;
        }

        return ['voters' => $voters, 'average' => ($rates / $voters), 'vote' => $vote];
    }
}