public function load_filtered_cost_of_orders($year = null)
{
$year = isset($year) ? $year : date("Y");
$facility_code = isset($facility_code) ? $facility_code : $this->session->userdata('facility_id');
$facility_name = Facilities::get_facility_name_($facility_code)->toArray();
$facility_name = $facility_name[0]['facility_name'];
$cost_of_orders = facility_orders::get_cost_of_orders($facility_code, $year);
//Holds all the months of the year
//Build the line graph showing the expiries graph
$graph_data = array();
$graph_data = array_merge($graph_data, array("graph_id" => 'graph-section'));
$graph_data = array_merge($graph_data, array("graph_title" => 'Total Cost of Orders in ' . $facility_name));
$graph_data = array_merge($graph_data, array("graph_type" => 'line'));
$graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'Total Cost of Orders (Order Value)'));
$graph_data = array_merge($graph_data, array("graph_categories" => array()));
$graph_data = array_merge($graph_data, array("series_data" => array("Total Cost" => array())));
foreach ($cost_of_orders as $facility_cost_of_orders) {
$graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($facility_cost_of_orders['mwaka']));
$graph_data['series_data']['Total Cost'] = array_merge($graph_data['series_data']['Total Cost'], array((int) $facility_cost_of_orders['order_total']));
}
$data['high_graph'] = $this->hcmp_functions->create_high_chart_graph($graph_data);
return $this->load->view("shared_files/report_templates/high_charts_template_v", $data);
}
