/**
* load initail data for support ticket form needed during
* creating and editing support ticket
* data
*/
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$myproducts = Cproduct::find_all();
$lastSignoff = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM sign_off_form ")));
$lastWorkSheet = array_shift($database->fetch_assoc($database->db_query("SELECT MAX(id) as lastID, prod_id FROM work_sheet_form ")));
/**
* issues may arise that when database
* is cleared emp_dept may not be 5
*/
$clients = Client::find_all();
// print_r($clients);
$techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
$zone = Zone::find_by_sql("SELECT * FROM zone");
$startups = array("clients" => $clients, "departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee, "lastsf" => $lastSignoff, "lastws" => $lastWorkSheet);
return $startups;
}
/**
* load initail data for support ticket form needed during
* creating and editing support ticket
* data
*/
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$myproducts = Cproduct::find_all();
/**
* issues may arise that when database
* is cleared emp_dept may not be 5
*/
$techEmployee = Employee::find_by_sql("SELECT * FROM employee WHERE emp_dept = 5");
$zone = Zone::find_by_sql("SELECT * FROM zone");
$startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, "myproducts" => $myproducts, "techstaff" => $techEmployee);
return $startups;
}
public function getData()
{
global $database;
$depts = Department::find_all();
$role = Roles::find_all();
$country = Country::find_all();
$vendors = Vendor::find_all();
$zone = Zone::find_by_sql("SELECT * FROM zone");
$clietproducts = Cproduct::find_all();
$startups = array("departs" => $depts, "country" => $country, "zone" => $zone, "vendors" => $vendors, "role" => $role, 'products' => $clietproducts);
return $startups;
}
