| public get_statuses ( ) : array | ||
| return | array | |
public function get_statuses()
{
$p = $this->kga['server_prefix'];
$query = "SELECT * FROM {$p}statuses\n ORDER BY status;";
$this->conn->Query($query);
$arr = array();
$i = 0;
$this->conn->MoveFirst();
$rows = $this->conn->RecordsArray(MYSQLI_ASSOC);
if ($rows === false) {
return array();
}
foreach ($rows as $row) {
$arr[] = $row;
$arr[$i]['timeSheetEntryCount'] = $this->status_timeSheetEntryCount($row['statusID']);
$i++;
}
return $arr;
}