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->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; $results = common_leaves::get_all_leaves_by_status($status); $count = 0; $return_results = array(); foreach($results AS $result) { $id = $result['id']; $user_id = $result['user_id']; $name = common_users::full_name($user_id); $start_date = $result['start_date']; $start_time = $result['start_time']; $end_date = $result['end_date']; $end_time = $result['end_time']; $description = $result['description']; $type = $result['type']; $certificate = $result['certificate']; $status = $result['status']; $creator = $result['creator']; $date_created = $result['date_created']; $submitter = common_users::full_name($result['submitter']); $date_submitted = $result['date_submitted']; if($type == 0) { $type = "Annual Leave"; } else if($type == 1) { if ( $certificate == 0 ) { $type = "Personal (No Cert)"; } else { $type = "Personal (With Cert)"; } } if($type == 2) { $type = "Trade School"; } $return_results[] = array( "id" => $id, "user_id" => $user_id, "name" => $name, "start_date" => $start_date, "start_time" => $start_time, "end_date" => $end_date, "end_time" => $end_time, "description" => $description, "type" => $type, "creator" => $creator, "date_created" => $date_created, "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) { for($i = $start; $i < $max_size; $i++) { $key = $new_normalised_results[$i]; $mod = $count%2; $class = ($mod == 0) ? "odd" : "even"; $count++; //bug::bug_array("result",$results); $id = $results[$key]['id']; $name = $results[$key]['name']; $type = $results[$key]['type']; $start_date = dates::change_date_time($results[$key]['start_date']); $end_date = dates::change_date_time($results[$key]['end_date']); $start_time = common_leaves::convert_time($results[$key]['start_time']); $end_time = common_leaves::convert_time($results[$key]['end_time']); $description = $results[$key]['description']; $submitter = $results[$key]['submitter']; $date_submitted = $results[$key]['date_submitted']; $date_submitted = dates::change_date_time($date_submitted); if($alert == 0) { ?>

	Edit	ID	Name	Type	Start Date	Start Time	End Date	End Time	Description	Submitter	Last Modified