XoopsModules\Newbb\ReportHandler

Complexity

Total Complexity

15

Size/Duplication

Total Lines	105
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	getByPost()	0	13	3
A	cleanOrphan()	0	3	1
A	synchronization()	0	2	1
B	getAllReports()	0	46	9

<?php

namespace XoopsModules\Newbb;

/**
 * NewBB 5.0x,  the forum module for XOOPS project
 *
 * @copyright      XOOPS Project (https://xoops.org)
 * @license        GNU GPL 2 or later (https://www.gnu.org/licenses/gpl-2.0.html)
 * @author         Taiwen Jiang (phppp or D.J.) <phppp@users.sourceforge.net>
 * @since          4.00
 * @package        module::newbb
 */



\defined('NEWBB_FUNCTIONS_INI') || require $GLOBALS['xoops']->path('modules/newbb/include/functions.ini.php');

/**
 * Class ReportHandler
 */
class ReportHandler extends \XoopsPersistableObjectHandler
{
    /**
     * @param \XoopsDatabase|null $db
     */
    public function __construct(\XoopsDatabase $db = null)
    {
        parent::__construct($db, 'newbb_report', Report::class, 'report_id', '');
    }

    /**
     * @param $posts
     * @return array
     */
    public function getByPost($posts)
    {
        $ret = [];
        if (!$posts) {
            return $ret;
        }
        if (!\is_array($posts)) {
            $posts = [$posts];
        }
        $post_criteria = new \Criteria('post_id', '(' . \implode(', ', $posts) . ')', 'IN');
        $ret           = $this->getAll($post_criteria);

        return $ret;
    }

    /**
     * @param int|array  $forums
     * @param string     $order
     * @param int        $perpage
     * @param            $start
     * @param int        $report_result
     * @param int        $reportId
     * @return array
     */
    public function getAllReports($forums = 0, $order = 'ASC', $perpage = 0, &$start, $report_result = 0, $reportId = 0)
    {
        $forumCriteria = '';
        $row           = [];
        if ('DESC' === $order) {
            $operator_for_position = '>';
        } else {
            $order                 = 'ASC';
            $operator_for_position = '<';
        }
        $order_criteria = " ORDER BY r.report_id $order";

        if ($perpage <= 0) {
            $perpage = 10;
        }
        if (empty($start)) {
            $start = 0;
        }
        $result_criteria = ' AND r.report_result = ' . $report_result;

        if ($forums) {
            $forumCriteria = '';
        } elseif (!\is_array($forums)) {
            $forums        = [$forums];
            $forumCriteria = ' AND p.forum_id IN (' . \implode(',', $forums) . ')';
        }
        $tables_criteria = ' FROM ' . $this->db->prefix('newbb_report') . ' r, ' . $this->db->prefix('newbb_posts') . ' p WHERE r.post_id= p.post_id';

        if ($reportId) {
            $result = $this->db->query('SELECT COUNT(*) as report_count' . $tables_criteria . $forumCriteria . $result_criteria . " AND report_id $operator_for_position $reportId" . $order_criteria);
            if ($result) {
                $row = $this->db->fetchArray($result);
            }
            $position = $row['report_count'];
            $start    = (int)($position / $perpage) * $perpage;
        }

        $sql    = 'SELECT r.*, p.subject, p.topic_id, p.forum_id' . $tables_criteria . $forumCriteria . $result_criteria . $order_criteria;
        $result = $this->db->query($sql, $perpage, $start);
        $ret    = [];
        //$reportHandler =  Newbb\Helper::getInstance()->getHandler('Report');
        while (false !== ($myrow = $this->db->fetchArray($result))) {
            $ret[] = $myrow; // return as array
        }

        return $ret;
    }

    /**
     * @return bool|void
     */
    public function synchronization()
    {
        //        return;
    }

    /**
     * clean orphan items from database
     *
     * @param string $table_link
     * @param string $field_link
     * @param string $field_object
     * @return bool   true on success
     */
    public function cleanOrphan($table_link = '', $field_link = '', $field_object = '') //cleanOrphan()
    {
        return parent::cleanOrphan($this->db->prefix('newbb_posts'), 'post_id');
    }
}