public function stock_out_reports($district_id = null, $facility_code = null)
{
$district_id = $district_id == "NULL" ? null : $district_id;
$facility_code = $facility_code == "NULL" ? null : $facility_code;
$county_id = $this->session->userdata('county_id');
$stock_out_array = Facility_stocks::get_items_that_have_stock_out_in_facility($facility_code, $district_id, $county_id);
$graph_data = $series_data = array();
foreach ($stock_out_array as $facility_stock_data) {
$day = date('j M, Y ', strtotime($facility_stock_data['last_day']));
$ts1 = strtotime($facility_stock_data['last_day']);
$ts2 = strtotime(date("Y/m/d"));
$seconds_diff = $ts2 - $ts1;
$days = floor($seconds_diff / 3600 / 24);
array_push($series_data, array($facility_stock_data['district'], $facility_stock_data['facility_name'], $facility_stock_data['facility_code'], $facility_stock_data['commodity_name'], $facility_stock_data['commodity_code'], $day, $days));
}
$category_data = array(array("Sub County", 'Facility Name', "MLF No.", "Commodity Name", "Commodity Code", "Last day of usage", "No. days out of stock"));
$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['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);
}
