public function filtered_consumption($commodity_id = null, $option = null, $from = null, $to = null, $report_type = null) { $year = isset($year) && $year > 0 ? $year : date("Y"); $option = isset($option) ? $option : "units"; $year = $year == 0 ? date("Y") : $year; $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']; $consumption = Facility_stocks::get_facility_consumption_level_new($facility_code, $commodity_id, $year, $option); //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" => 'Consumption for ' . $facility_name)); $graph_data = array_merge($graph_data, array("graph_type" => 'column')); $graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'Total Consumption')); $graph_data = array_merge($graph_data, array("graph_categories" => array())); $graph_data = array_merge($graph_data, array("series_data" => array("Consumption" => array()))); if ($option == "service_point") { $graph_data = array_merge($graph_data, array("graph_type" => 'column')); $consumption = Facility_stocks::get_facility_consumption_level_new($facility_code, $commodity_id, $year, $option); foreach ($consumption as $facility_consumption) { $graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($facility_consumption['service_name'])); $graph_data['series_data']['Consumption'] = array_merge($graph_data['series_data']['Consumption'], array((int) $facility_consumption['total_consumption'])); } } else { $graph_data = array_merge($graph_data, array("graph_type" => 'line')); //$consumption = Facility_stocks::get_facility_consumption_level_new($facility_code, $commodity_id, $year, $option); $consumption = Facility_stocks::get_filtered_commodity_consumption_level($facility_code, $commodity_id, $year, $option); foreach ($consumption as $facility_consumption) { $graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($facility_consumption['month'])); $graph_data['series_data']['Consumption'] = array_merge($graph_data['series_data']['Consumption'], array((int) $facility_consumption['total_consumption'])); } } $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); }