public function get_county_consumption_level_new($year = null, $month = null, $commodity_id = null, $category_id = null, $district_id = null, $option = null) { $county_id = $this->session->userdata('county_id'); $county_name = counties::get_county_name($county_id); $category_data = array(); $series_data = array(); $year = isset($year) ? $year : date("Y"); $month = isset($month) ? $month : date("m"); $option_new = isset($option) ? $option : "packs"; $district_data = isset($district_id) && $district_id > 0 ? districts::get_district_name($district_id)->toArray() : null; $district_name = isset($district_data) ? " :" . $district_data[0]['district'] . " subcounty" : null; //get the data from the db $consumption_data = facility_stock::get_county_drug_consumption_level($county_id, $category_id, $year, $month, $commodity_id, $district_id, $option); foreach ($consumption_data as $commodity_detail) { $category_data = array_merge($category_data, array(preg_replace("/[^A-Za-z0-9 ]/", "", $commodity_detail['drug_name']))); $series_data = array_merge($series_data, array((int) $commodity_detail['total'])); } $data['category_data'] = stripslashes(json_encode($category_data)); $data['series_data'] = stripslashes(json_encode($series_data)); $data['year'] = $year; $data['month'] = date("F", strtotime(date($year . "-" . $month))); $data['county'] = $county_name[0]['county'] . $district_name; $data['consumption_option'] = $option_new; $this->load->view("county/ajax_view/county_consumption_graphical_data_v", $data); }