public function getall()
{
$Connection = new CreateConnection();
$mysqli = $Connection->connectToDatabase();
$SQL = "SELECT * FROM priority";
$result = $mysqli->query("{$SQL}");
$list = array();
while ($row = $result->fetch_object()) {
$list[] = $row;
}
$Connection->closeConnection();
return $list;
}
public function getbytype($type)
{
$Connection = new CreateConnection();
$mysqli = $Connection->connectToDatabase();
$SQL = "SELECT id,name FROM user WHERE group_id=" . $type . "";
$result = $mysqli->query("{$SQL}");
$listUser = array();
while ($row = $result->fetch_object()) {
$listUser[] = $row;
}
$Connection->closeConnection();
return $listUser;
}
public function getaging()
{
$Connection = new CreateConnection();
$mysqli = $Connection->connectToDatabase();
$SQL = "select i.title, IFNULL(u1.name,'Unassigned') as programer_name,IFNULL(u2.name,'Unassigned') as customer_name,i.created, DATEDIFF(Now(), date(i.created)) AS days,i.customer_id,i.programer_id from issue i left join user u1 on u1.id = i.programer_id left join user u2 on u2.id = i.customer_id where i.state = 1 or i.state = 2 order by days Desc";
$result = $mysqli->query("{$SQL}");
$list = array();
while ($row = $result->fetch_object()) {
$list[] = $row;
}
$Connection->closeConnection();
return $list;
}
