public function regimen_breakdown()
{
$selected_facility = $this->input->post('facility');
if (isset($selected_facility)) {
$facility = $this->input->post('facility');
}
$data = array();
$data['current'] = "patient_management";
$data['title'] = "webADT | Patient Regimen Breakdown";
$data['content_view'] = "patient_regimen_breakdown_v";
$data['banner_text'] = "Patient Regimen Breakdown";
$data['facilities'] = Reporting_Facility::getAll();
//Get the regimen data
$data['optimal_regimens'] = Regimen::getOptimalityRegimens("1");
$data['sub_optimal_regimens'] = Regimen::getOptimalityRegimens("2");
$months = 12;
$months_previous = 11;
$regimen_data = array();
for ($current_month = 1; $current_month <= $months; $current_month++) {
$start_date = date("Y-m-01", strtotime("-{$months_previous} months"));
$end_date = date("Y-m-t", strtotime("-{$months_previous} months"));
//echo $start_date." to ".$end_date."</br>";
if ($facility) {
$get_month_statistics_sql = "SELECT regimen,count(patient_id) as patient_numbers,sum(months_of_stock) as months_of_stock FROM (select distinct patient_id,months_of_stock,regimen,dispensing_date from `patient_visit` where facility = '" . $facility . "' and dispensing_date between str_to_date('" . $start_date . "','%Y-%m-%d') and str_to_date('" . $end_date . "','%Y-%m-%d')) patient_visits group by regimen";
} else {
$get_month_statistics_sql = "SELECT regimen,count(patient_id) as patient_numbers,sum(months_of_stock) as months_of_stock FROM (select distinct patient_id,months_of_stock,regimen,dispensing_date from `patient_visit` where dispensing_date between str_to_date('" . $start_date . "','%Y-%m-%d') and str_to_date('" . $end_date . "','%Y-%m-%d')) patient_visits group by regimen";
}
$month_statistics_query = $this->db->query($get_month_statistics_sql);
foreach ($month_statistics_query->result_array() as $month_data) {
$regimen_data[$month_data['regimen']][$start_date] = array("patient_numbers" => $month_data['patient_numbers'], "mos" => $month_data['months_of_stock']);
}
//echo $get_month_statistics_sql . "<br>";
$months_previous--;
}
$data['regimen_data'] = $regimen_data;
$this->load->view("platform_template", $data);
}
