avail_status = $context['avail_status'];
$this->avail_edit = $context['avail_edit'];
$this->link_view = $context['link_view'];
$this->link_edit = $context['link_edit'];
$this->group_id = $context['group_id'];
$this->status = $context['status'];
$this->department_id = $context['department_id'];
$this->db_name = $context['db_name'];
$this->account_id = $context['account_id'];
$this->order = (empty($context['order'])) ? "ASC" : $context['order'];
$this->method = (empty($context['method'])) ? "email" : $context['method'];
}
public function get_data()
{
global $database;
$db_name = $this->db_name;
$account_id = $this->account_id;
$status = $this->status;
$group_id = $this->group_id;
$department_id = $this->department_id;
$group = ($group_id != "all") ? "AND group_id = '$group_id'" : "";
$get_tasks = "
SELECT *
FROM $db_name"."tasks
WHERE status = '$status' and department_id = '$department_id'
";
$results = $database->getAll($get_tasks);
//bug::bug_array('',$results);
/* $get_company = "
SELECT
id,
company_name
FROM companies
";
$companies = $database->getAll($get_company);
$company_name = array();
foreach($companies AS $company)
{
$company_name[$company['id']]= $company['company_name'];
}
$get_location = "
SELECT
id,
CONCAT(address,', ',suburb,', ',state,', ',post_code,', ',country) AS 'address'
FROM companies_locations
";
$locations = $database->getAll($get_location);
$location_address = array();
foreach($locations AS $location)
{
$location_address[$location['id']]= $location['address'];
}
*/
$count = 0;
$return_results = array();
//$users = common_tasks::get_taskss();
foreach($results AS $result)
{
$id = $result['id'];
$task_name = $result['task_name'];
$department_id = $result['department_id'];
$rate = $result['rate'];
$unit = $result['unit'];
$status = $result['status'];
$submitter = $result['submitter'];
$date_submitted = $result['date_submitted'];
//$name = $first_name." ".$last_name;
//$group = common_ref_global_client::get_group($group_id);
//$company_id = common_users::get_user_company($id);
//$company = $company_name[$company_id];
//$location_id = common_users::get_user_location($id);
//$location = $location_address[$location_id];
$submitter = common_users::full_name($submitter);
$date_submitted = dates::change_date_time($date_submitted);
$return_results[] = array("id" => $id,"task_name" => $task_name, "department_id" => $department_id, "rate" => $rate, "unit" => $unit ,"status" => $status,"submitter" => $submitter,"date_submitted" => $date_submitted);
}
$this->final_results = $return_results;
return $this;
}
public function show()
{
global $database;
$order = $this->order;
$method = $this->method;
$results = $this->final_results;
$avail_status = $this->avail_status;
$avail_edit = $this->avail_edit;
$link_view = $this->link_view;
$link_edit = $this->link_edit;
$normalised_results = filter::sort_results($method,$order,$results);
$normalise_get = filter::normalise_get($order);
$pagination_results = filter::pagination($normalised_results,$normalise_get);
filter::pagination_html($pagination_results);
$pagination = $pagination_results['pagination'];
$start = $pagination_results['start'];
$size = $pagination_results['size'];
$total_results = $pagination_results['total_results'];
$max_size = $pagination_results['max_size'];
$order = ($order == "ASC") ? "DESC" : "ASC";
$normalise_get = filter::normalise_get($order);
$new_normalised_results = array();
foreach($normalised_results AS $key => $value)
$new_normalised_results[] = $key;
?>
0)
{
?>
