public function potential_expiries_dashboard_ajax_titus($county = NULL, $district = NULL, $facility_code = NULL, $option = null, $period = null)
{
// echo "<pre>";print_r($data['report_data']);echo "</pre>";exit;
// $facility_code = isset($f_code_ext)? $f_code_ext : $this -> session -> userdata('facility_id') ;
// echo $facility_code;exit;
$data['title'] = "Reports";
$data['content_view'] = "facility/facility_reports/reports_v";
$data['facility_code'] = $facility_code;
$view = 'shared_files/template/template';
$data['report_view'] = "facility/facility_reports/potential_expiries_v";
$data['sidebar'] = "shared_files/report_templates/side_bar_v";
$potential_expiries = Facility_stocks::potential_expiries_seth('11304');
$data['active_panel'] = 'expiries';
// $this -> load -> view($view, $data);
foreach ($potential_expiries as $data) {
$temp_array = array_merge($temp_array, array($data["facility_code"] => $data['facility_code'], $data["commodity_code"] => $data['commodity_code'], $data["batch_no"] => $data['batch_no'], $data["manufacturer"] => $data['manufacturer'], $data["initial_quantity"] => $data['initial_quantity'], $data["current_balance"] => $data['current_balance'], $data["date_added"] => $data['date_added'], $data["date_modified"] => $data['date_modified'], $data["expiry_date"] => $data['expiry_date']));
$series_data_ = array_merge($series_data_, array(array($data["facility_code"], $data["batch_no"], $data["commodity_name"], $data["manufacturer"], $data["initial_quantity"], $data["current_balance"], $data["date_added"], $data["date_modified"], $data["expiry_date"])));
$expiries_excel = array_merge($expiries_excel, array($data["facility_code"] => $data['facility_code'], $data["commodity_code"] => $data['commodity_code'], $data["batch_no"] => $data['batch_no'], $data["manufacturer"] => $data['manufacturer'], $data["initial_quantity"] => $data['initial_quantity'], $data["current_balance"] => $data['current_balance'], $data["date_added"] => $data['date_added'], $data["date_modified"] => $data['date_modified'], $data["expiry_date"] => $data['expiry_date']));
}
// echo "<pre>";print_r($series_data_);echo "</pre>";exit;
//get_county_cost_of_expiries_new/0/null/88/0/17401
$year = $year == "NULL" ? null : $year;
//$month=($month=="NULL") ? NULL :$month;
$district_id = $district_id == "NULL" ? null : $district_id;
$option = $option == "NULL" ? null : $option;
$period = $period == "NULL" ? null : $period;
$facility_code = $facility_code == "NULL" ? null : $facility_code;
$option = $option == "NULL" || $option == "null" ? null : $option;
//set up the variables
$year = isset($year) ? $year : date("Y");
$county_id = $this->session->userdata('county_id');
$district_id_checker = $this->session->userdata('district_id');
$county_name = counties::get_county_name($county_id);
$category_data = array();
$series_data = $series_data_ = $series_data_2 = $series_data_3 = $series_data2 = array();
$temp_array = $temp_array2 = $temp_array_ = array();
$graph_data = array();
$graph_type = '';
$title = '';
//months
$months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
//$month_ = isset($month) ?$months[(int) $month-1] : null ;
//check if the district is set
$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;
$option_new = isset($option) ? $option : "units";
$facility_code_ = isset($facility_code) ? facilities::get_facility_name_($facility_code)->toArray() : null;
$facility_name = $facility_code_[0]['facility_name'];
$title = isset($facility_code) && isset($district_id) ? "{$district_name_} : {$facility_name}" : (isset($district_id) && !isset($facility_code) ? "{$district_name_}" : "{$county_name['county']} county");
//get the expiry for the entire year either for a facility sub-county or county
$commodity_array = Facility_stocks::get_sub_county_cost_of_exipries($facility_code, $district_id, $county_id, $year, null, $option_new, "all");
// echo "<pre>";print_r($commodity_array);echo "</pre>";exit;
//for the potential expiries
$commodity_array2 = Facility_stocks::get_county_cost_of_potential_expiries_new($facility_code, $district_id, $county_id, $year, null, $option_new, "all", $period);
foreach ($commodity_array as $data) {
$temp_array = array_merge($temp_array, array($data["cal_month"] => (int) $data['total']));
$series_data_ = array_merge($series_data_, array(array($data["district"], $data["facility_name"], $data["commodity_name"], $data["month"], (int) $data['total'])));
$expiries_excel = array_merge($expiries_excel, array($data["cal_month"] => (int) $data['total']));
}
foreach ($commodity_array2 as $data2) {
$temp_array2 = array_merge($temp_array2, array($data2["cal_month"] => (int) $data2['total_potential']));
$series_data_2 = array_merge($series_data_2, array(array($data2["cal_month"], (int) $data2['total_potential'])));
$series_data_3 = array_merge($series_data_3, array(array($data2["district"], $data2["facility_name"], $data2["commodity_name"], $data2["month_potential"], (int) $data2['total_potential'])));
//$series_data_ = array_push($series_data_, array($data2["district"], $data2["facility_name"], $data2["commodity_name"], $data2["month_potential"], (int)$data2['total_potential']));
//$series_data_ = array_merge($series_data_, $series_data_3);
$potential_excel = array_merge($potential_excel, array($data2["cal_month"] => (int) $data2['total_potential']));
}
foreach ($months as $key => $data) {
$val = array_key_exists($data, $temp_array) ? (int) $temp_array[$data] : (int) 0;
$val2 = array_key_exists($data, $temp_array2) ? (int) $temp_array2[$data] : (int) 0;
$series_data = array_merge($series_data, array($val));
$series_data2 = array_merge($series_data2, array($val2));
}
if ($report_type == "csv_data") {
$excel_data = array('doc_creator' => $this->session->userdata('full_name'), 'doc_title' => "stock expired in {$title} in {$year}", 'file_name' => "Stock_expired{$title} in {$year}");
$row_data = array();
$column_data = array("Sub-county", "Facility Name", "Commodity Name", " Month expired(Actual expiries)", "Actual expiries in {$option_new}");
$excel_data['column_data'] = $column_data;
$row_data = array_merge($row_data, $series_data_);
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
} elseif ($report_type == "table") {
$category_data = array(array("Sub-county", "Facility Name", "Commodity Name", " Month expired(Actual expiries)", "Actual expiries in {$option_new}"));
$graph_data = array_merge($graph_data, array("table_id" => 'graph_default'));
$graph_data = array_merge($graph_data, array("table_header" => $category_data));
$graph_data = array_merge($graph_data, array("table_body" => $series_data_));
$data = array();
$data['table'] = $this->hcmp_functions->create_data_table($graph_data);
$data['table_id'] = "graph_default";
return $this->load->view("shared_files/report_templates/data_table_template_v", $data);
} else {
$graph_type = 'column';
$graph_data = array_merge($graph_data, array("graph_id" => 'dem_graph_'));
$graph_data = array_merge($graph_data, array("graph_title" => "Expiries in {$title} {$month_} {$year}"));
$graph_data = array_merge($graph_data, array("graph_type" => $graph_type));
$graph_data = array_merge($graph_data, array("graph_yaxis_title" => "{$option_new}"));
$graph_data = array_merge($graph_data, array("graph_categories" => $months));
$graph_data = array_merge($graph_data, array("series_data" => array()));
$data = array();
$graph_data['series_data'] = array_merge($graph_data['series_data'], array("Potential Expiries" => $series_data2));
$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);
}
}
