class/TrelloManagement.php
<?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]);
return $result;
}
}