Ejemplo n.º 1
0
 public function get_reversed_table()
 {
     $graph_data = array();
     $current_reversed = Facility_issues::get_reversed_issues();
     foreach ($current_reversed as $key => $value) {
         $facility_name = $value['facility_name'];
         $facility_code = $value['facility_code'];
         $issue_date_raw = $value['created_at'];
         $issue_date = date('F, m Y', strtotime($issue_date_raw));
         $issuer = $value['fname'] . ' ' . $value['lname'];
         $issuer_id = $value['issued_by'];
         $issue_date_timestamp = strtotime($issue_date_raw);
         $data_id = $facility_code . '/' . $issue_date_timestamp . '/' . $issuer_id;
         $button_dets_link = '<button class="btn btn-success reverse_status_btn form-control" style="width:98%"  data-id="' . $data_id . '" id="' . $data_id . '" data-attr="' . $data_id . '" data-value="' . $data_id . '">View Details</button>';
         $button_reverse_link = "<a href=\"" . base_url() . 'admin/undo_reverse_issue/' . $facility_code . '/' . $issue_date_timestamp . '/' . $issuer_id . '/reverse' . "\"><button class=\"btn btn-danger  form-control\" style=\"width:98%\">Undo Reverse Issue</button></a>";
         $output[] = array($facility_code, $facility_name, $issue_date, $issuer, $button_dets_link, $button_reverse_link);
     }
     $category_data = array(array("Facility Code", "Facility Name", "Date of Issue", "Name of Issuer", "Details", "Action"));
     $graph_data = array_merge($graph_data, array("table_id" => 'reversed_issues_tbl'));
     $graph_data = array_merge($graph_data, array("table_header" => $category_data));
     $graph_data = array_merge($graph_data, array("table_body" => $output));
     $data = array();
     $data['table'] = $this->hcmp_functions->create_data_table($graph_data);
     // $data['table_id'] = "issues_tbl";
     return $this->load->view("shared_files/report_templates/data_table_template_v", $data);
     // echo json_encode($output);
 }