XoopsModules\Publisher\TrelloManagement

Complexity

Total Complexity

4

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getProjectTaskByStatus()	0	8	1
A	getAllStatus()	0	8	1
A	__construct()	0	3	1
A	editTaskStatus()	0	8	1

<?php declare(strict_types=1);

namespace XoopsModules\Publisher;

/**
 * Class TrelloManagement
 */
class TrelloManagement
{
    private $xoopsDb;

    /**
     * TrelloManagement constructor.
     * @param $xoopsDb
     */
    public function __construct($xoopsDb)
    {
        $this->xoopsDb = $xoopsDb;
    }

    /**
     * @param $statusId
     * @param $itemId
     * @return mixed
     */
    public function getProjectTaskByStatus($statusId, $itemId)
    {
        $helper   = Helper::getInstance();
        $dbHandle = new TrelloDBController($this->xoopsDb);
        $query    = 'SELECT * FROM ' . $GLOBALS['xoopsDB']->prefix($helper->getDirname() . '_items') . 'WHERE status= ? AND itemid = ?';
        $result   = $dbHandle->runQuery($query, 'ii', [$statusId, $itemId]);

        return $result;
    }

    /**
     * @return mixed
     */
    public function getAllStatus()
    {
        $helper   = Helper::getInstance();
        $dbHandle = new TrelloDBController($this->xoopsDb);
        $query    = 'SELECT itemid, title, status FROM ' . $GLOBALS['xoopsDB']->prefix($helper->getDirname() . '_items');
        $result   = $dbHandle->runBaseQuery($query);

        return $result;
    }

    /**
     * @param $statusId
     * @param $itemId
     */
    public function editTaskStatus($statusId, $itemId)
    {
        $helper   = Helper::getInstance();
        $dbHandle = new TrelloDBController($this->xoopsDb);
        $query    = 'UPDATE ' . $GLOBALS['xoopsDB']->prefix($helper->getDirname() . '_items') . ' SET status = ? WHERE itemid = ?';
        $result   = $dbHandle->update($query, 'ii', [$statusId, $itemId]);

Are you sure the assignment to $result is correct as $dbHandle->update($query, 'ii', array($statusId, $itemId)) targeting XoopsModules\Publisher\TrelloDBController::update() seems to always return null.

        return $result;
    }
}