public function potential_expiries_reports($county_id, $year)
{
$district_id = $this->session->userdata('district_id');
$dist_id = isset($district_id) ? $district_id : null;
$expiries_array = Facility_stocks::get_potential_expiry_summary($county_id, $year, $dist_id);
// echo "<pre>";print_r($expiries_array);echo "</pre>";exit;
$graph_data = $series_data = array();
$total_expiry = 0;
foreach ($expiries_array as $facility_expiry_data) {
$district = $facility_expiry_data['district'];
$name = $facility_expiry_data['facility_name'];
$mfl = $facility_expiry_data['facility_code'];
$total = $facility_expiry_data['total'];
$total_expiry = $total_expiry + $total;
$total = number_format($total, 2, '.', ',');
$district_id = $facility_expiry_data['district_id'];
$link = base_url("reports/potential_exp_process_subcounty/{$mfl}");
array_push($series_data, array($district, $name, $mfl, $total, '<a href="' . $link . '">
<button type="button" class="btn btn-xs btn-success"><span class="glyphicon glyphicon-zoom-in"></span>View</button></a>'));
}
$total_expiry = number_format($total_expiry, 2, '.', ',');
array_push($series_data, array("", "", "Total for the next {$year} months", $total_expiry, ''));
$category_data = array(array("Sub-county", "Facility Name", "Mfl", "TOTAL (ksh)", ''));
$graph_data = array_merge($graph_data, array("table_id" => 'dem_graph_1'));
$graph_data = array_merge($graph_data, array("table_header" => $category_data));
$graph_data = array_merge($graph_data, array("table_body" => $series_data));
$data['active_panel'] = "expiries";
$data['table'] = $this->hcmp_functions->create_data_table($graph_data);
$data['table_id'] = "dem_graph_1";
return $this->load->view("shared_files/report_templates/data_table_template_v", $data);
}
