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