avail_status = $context['avail_status'];
$this->avail_edit = $context['avail_edit'];
$this->link_view = $context['link_view'];
$this->link_edit = $context['link_edit'];
$this->status = $context['status'];
$this->job_id = $context['id'];
$this->order = (empty($context['order'])) ? "ASC" : $context['order'];
$this->method = (empty($context['method'])) ? "id" : $context['method'];
}
public function get_data()
{
global $database;
$db_name = $this->db_name;
$status = $this->status;
if($this->job_id == "")
{
$results = common_job_trackings::get_all_job_trackings_by_status($status);
}
else
{
$results = common_job_trackings::get_job_tracking_by_job($this->job_id);
}
//bug::bug_array("result", $results);
$job_id = common_quotes::get_quote_id($this->job_id);
$results = common_job_trackings::get_job_budget($job_id);
$count = 0;
$return_results = array();
foreach($results as $result)
{
$id = $result['id'];
$job_id = $this->job_id;
$job_number = common_jobs::get_one_job_number($job_id);
$job_name = common_jobs::get_one_job_name($job_id);
$department_name = $result['department_name'];
$department_id = $result['production_departments_id'];
$sum_time=common_job_trackings::get_total_time_per_dept_job($id,$this->job_id);
$completed=common_job_trackings::get_completed_job($id,$this->job_id);
$locked=common_job_trackings::get_locked_job($id,$this->job_id);
$start_time = $result['start_time'];
$end_time = $result['end_time'];
$hours = $result['hours'];
$alert = $result['alert'];
$submitter = common_users::full_name($result['submitter']);
$date_submitted = $result['date_submitted'];
$duration = common_job_trackings::get_duration($start_time,$end_time);
$return_results[] = array(
"id" => $id,
"job_id" => $job_id,
"job_number" => $job_number,
"job_name" => $job_name,
"department_name" => $department_name,
"department_id" => $department_id,
"hours" => $hours,
"sum_time" => $sum_time,
"completed" =>$completed,
"locked" =>$locked,
"start_time" => $start_time,
"end_time" => $end_time,
"duration" => $duration,
"alert" => $alert,
"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;
?>
';
if($variance == 0 )
{
$rating ='green-rate';
}
elseif($variance < 0)
{
$rating ='red-rate';
$negative_flag=true;
}
else
{
$rating = 'blue-rate';
}
}
else
{
if($variance < 0 )
{
$rating ='red-rate';
$negative_flag=true;
}
else
{
if($percentage > 80)
{
$rating = 'orange-rate';
}
else
{
$rating = 'green-rate';
}
}
}
//locked
$checked_mark='';
if($locked != 0 )
{
$complete_mark ='
';
}
?>