public function get_county_cost_of_expiries_new($year = null, $month = null, $district_id = null, $option = null, $facility_code = null)
{
$county_id = $this->session->userdata('county_id');
$county_name = counties::get_county_name($county_id);
$category_data = array();
$series_data = array();
$temp_array = array();
$months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
$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;
$year = $year != "null" ? $year : date("Y");
$month = isset($month) ? $month : date("m");
$option_new = isset($option) && $option != 'null' ? $option : "ksh";
$facility_code = (int) $facility_code > 0 ? facilities::get_facility_name($facility_code)->toArray() : facilities::get_facilities_which_are_online($district_id);
$district_id = isset($district_id) && $district_id > 0 ? array('id' => $district_id) : districts::getDistrict($county_id)->toArray();
if (count($district_id) > 1 && $month == "null") {
$category_data = array_merge($category_data, $months);
$commodity_array = Facility_Stock::get_county_cost_of_exipries_new($county_id, $year, $month, "all", $option_new, null);
foreach ($commodity_array as $data) {
$temp_array = array_merge($temp_array, array($data["cal_month"] => $data['total']));
}
foreach ($months as $key => $data) {
$val = array_key_exists($data, $temp_array) ? (int) $temp_array[$data] : (int) 0;
$series_data = array_merge($series_data, array($val));
}
}
if (count($facility_code) == 1 && count($district_id) == 1) {
$commodity_array = Facility_Stock::get_county_cost_of_exipries_new($county_id, $year, $month, 'facility', $option_new, $facility_code[0]['facility_code']);
foreach ($commodity_array as $facility_data) {
$category_data = array_merge($category_data, array($facility_data['drug_name']));
$series_data = array_merge($series_data, array(array((int) $facility_data['total'])));
}
}
if (count($district_id) == 1 && count($facility_code) >= 1 && count($category_data) == 0) {
foreach ($facility_code as $facility_) {
$category_data = array_merge($category_data, array($facility_['facility_name']));
$commodity_array = Facility_Stock::get_county_cost_of_exipries_new($county_id, $year, $month, $facility_['district'], $option_new, $facility_['facility_code']);
$series_data = array_merge($series_data, array(array((int) $commodity_array[0]['total'])));
}
}
if (count($district_id) > 1 && $month != "null") {
$district_ = districts::getDistrict($county_id)->toArray();
foreach ($district_ as $data) {
$category_data = array_merge($category_data, array($data['district']));
$commodity_array = Facility_Stock::get_county_cost_of_exipries_new($county_id, $year, $month, $data['id'], $option_new, "null");
$series_data = array_merge($series_data, array(array((int) $commodity_array[0]['total'])));
}
}
$data = array();
$data['category_data'] = stripslashes(json_encode($category_data));
$data['series_data'] = json_encode($series_data);
$data['year'] = $year;
$data['month'] = date("F", strtotime(date($year . "-" . $month)));
$data['total'] = 2;
$data['expiry_option'] = $option_new;
$data['county'] = $county_name[0]['county'];
$data['consumption_option'] = $option_new;
$this->load->view("county/ajax_view/county_expiries_graphical_data_v", $data);
}
