/**
* Dashboard statistics section
*/
public function getDashboardStat()
{
global $database;
$darray = array();
$open_ticket_count = $database->dbNumRows($database->db_query("SELECT * FROM support_ticket WHERE status ='Open' "));
$open_schedule_count = $database->dbNumRows($database->db_query("SELECT * FROM schedule WHERE status ='Open' "));
$open_worksheet_count = $database->dbNumRows($database->db_query("SELECT * FROM work_sheet_form WHERE status ='Open' "));
$awaiting_ticket_count = $database->dbNumRows($database->db_query("SELECT * FROM support_ticket WHERE status ='Customer Reply' "));
$closed_worksheet_count = $database->dbNumRows($database->db_query("SELECT * FROM work_sheet_form WHERE status ='Closed' "));
$client_count = $database->dbNumRows($database->db_query("SELECT * FROM tbl_client"));
$client_products = $database->dbNumRows($database->db_query("SELECT * FROM client_product"));
//$schedule
$openPendings = Ticket::find_by_sql("SELECT * FROM support_ticket WHERE (status ='Admin Reply' OR status='Customer Reply') OR status ='Open' ");
// print_r($openPendings);
$clients = Client::find_all();
$darray = array("cproducts" => $client_products, "clients" => $clients, "oworksheet" => $open_worksheet_count, "oschedule" => $open_schedule_count, "otcount" => $open_ticket_count, "atcount" => $awaiting_ticket_count, "openPend" => $openPendings);
return $darray;
}
public function getList()
{
$all = Client::find_all();
return $all;
}
