public function edit($record_no)
{
$sql = "SELECT p.*,\n\t\t rst.Name as service_name,\n\t\t dp.child,\n\t\t s.secondary_spouse \n\t\t FROM patient p \n\t\t LEFT JOIN regimen_service_type rst ON rst.id=p.service \n\t\t LEFT JOIN dependants dp ON p.patient_number_ccc=dp.parent \n\t\t \t LEFT JOIN spouses s ON p.patient_number_ccc=s.primary_spouse\n\t\t WHERE p.id='{$record_no}'\n\t\t GROUP BY p.id";
$query = $this->db->query($sql);
$results = $query->result_array();
if ($results) {
$results[0]['other_illnesses'] = $this->extract_illness($results[0]['other_illnesses']);
$data['results'] = $results;
}
$data['record_no'] = $record_no;
$data['districts'] = District::getPOB();
$data['genders'] = Gender::getAll();
$data['statuses'] = Patient_Status::getStatus();
$data['sources'] = Patient_Source::getSources();
$data['drug_prophylaxis'] = Drug_Prophylaxis::getAll();
$data['service_types'] = Regimen_Service_Type::getHydratedAll();
$data['facilities'] = Facilities::getAll();
$data['family_planning'] = Family_Planning::getAll();
$data['other_illnesses'] = Other_Illnesses::getAll();
$data['pep_reasons'] = Pep_Reason::getActive();
$data['regimens'] = Regimen::getRegimens();
$data['drugs'] = Drugcode::getAllEnabled();
$data['who_stages'] = Who_Stage::getAllHydrated();
$data['content_view'] = 'edit_patients_v';
//Hide side menus
$data['hide_side_menu'] = '1';
$this->base_params($data);
}
public function graph_patients_enrolled_in_year($year = "")
{
$main_array = array();
$facility_code = $this->session->userdata('facility');
$months = array('1' => 'Jan', '2' => 'Feb', '3' => 'Mar', '4' => 'Apr', '5' => 'May', '6' => 'Jun', '7' => 'Jul', '8' => 'Aug', '9' => 'Sep', '10' => 'Oct', '11' => 'Nov', '12' => 'Dec');
$services_data = Regimen_Service_Type::getHydratedAll();
foreach ($services_data as $service) {
$services[] = $service['Name'];
}
//Loop through all services
foreach ($services as $service) {
$service_array = array();
$month_data = array();
$service_array['name'] = $service;
//Loop through all months
foreach ($months as $month => $month_name) {
$sql = "SELECT COUNT(*) AS total\n\t\t\t\t\t FROM patient p \n\t\t\t\t\t LEFT JOIN regimen_service_type rst ON p.service=rst.id\n\t\t\t\t\t WHERE YEAR(p.date_enrolled)='{$year}' \n\t\t\t\t\t AND MONTH(p.date_enrolled)='{$month}'\n\t\t\t\t\t AND rst.name LIKE '%{$service}%'\n\t\t\t\t\t AND p.facility_code='{$facility_code}'";
$query = $this->db->query($sql);
$results = $query->result_array();
if ($results) {
$month_data[] = @(int) $results[0]['total'];
} else {
$month_data[] = 0;
}
}
$service_array['data'] = $month_data;
//append service data to main array
$main_array[] = $service_array;
}
//chart data
$resultArray = json_encode($main_array);
$categories = json_encode(array_values($months));
//chart settings
$data['resultArraySize'] = 7;
$data['container'] = 'chart_sales';
$data['chartType'] = 'line';
$data['title'] = 'Chart';
$data['chartTitle'] = 'Listing of Patients Enrolled for the Year: ' . $year;
$data['categories'] = $categories;
$data['xAxix'] = 'Months of the Year';
$data['suffix'] = '';
$data['yAxix'] = 'Totals';
$data['resultArray'] = $resultArray;
$data['graphs'] = $this->load->view('graph_v', $data, TRUE);
$data['title'] = "webADT | Reports";
$data['hide_side_menu'] = 1;
$data['banner_text'] = "Facility Reports";
$data['selected_report_type_link'] = "standard_report_row";
$data['selected_report_type'] = "Standard Reports";
$data['report_title'] = "Graph of Number of Patients Enrolled Per Month in a Given Year";
$data['facility_name'] = $this->session->userdata('facility_name');
$data['content_view'] = 'reports/graphs_on_patients_v';
$this->load->view('template', $data);
}
