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; }