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); }