public function load_expiries() { $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']; $expired_commodities = Facility_stocks::get_expiries($facility_code); //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 Expiries in ' . $facility_name)); $graph_data = array_merge($graph_data, array("graph_type" => 'line')); $graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'Total Expiries (values in units)')); $graph_data = array_merge($graph_data, array("graph_categories" => array())); $graph_data = array_merge($graph_data, array("series_data" => array("Expiries" => array()))); foreach ($expired_commodities as $facility_stock_expired) { $graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($facility_stock_expired['month'])); $graph_data['series_data']['Expiries'] = array_merge($graph_data['series_data']['Expiries'], array((int) $facility_stock_expired['total_expiries'])); } $faciliy_expiry_data = $this->hcmp_functions->create_high_chart_graph($graph_data); $data['title'] = "Facility Expiries"; $data['banner_text'] = "Facility Expiries"; $data['graph_data'] = $faciliy_expiry_data; $data['sidebar'] = "shared_files/report_templates/side_bar_v"; $data['report_view'] = "facility/facility_reports/ajax/facility_expiry_filter_v"; $data['content_view'] = "facility/facility_reports/reports_v"; $view = 'shared_files/template/template'; $data['active_panel'] = 'statistics'; $this->load->view($view, $data); }