public function edit_district($code)
{
$district = District::getDistrict($code);
$data['district'] = $district[0];
$data['title'] = "District Management::Edit " . $district->name . " District";
$data['module_view'] = "add_district_view";
$data['quick_link'] = "new_district";
$data['provinces'] = Province::getAll();
$this->base_params($data);
}
public function edit_user($id)
{
$user = Users::getUser($id);
$data['user'] = $user;
$data['title'] = "User Management::Edit " . $user->Name . "'s Details";
$data['title'] = "User Management::Add New User";
$data['module_view'] = "add_user_view";
$data['levels'] = Access_Level::getAll();
$data['districts'] = District::getAll();
$data['provinces'] = Province::getAll();
$this->base_params($data);
}
public function view_list()
{
$year = $this->input->post("year");
$epiweek = $this->input->post("epiweek");
$dnr_districts = District::getDNRDistricts($year, $epiweek);
$provinces = Province::getAll();
$data['provinces'] = $provinces;
$data['dnr_districts'] = $dnr_districts;
$data['report_view'] = "dnr_districts_v";
$data['small_title'] = "DNR Districts in " . $year . " Epiweek " . $epiweek;
$this->base_params($data);
}
public function edit_weekly_data($epiweek, $reporting_year, $district)
{
$provinces = Province::getAll();
$districts = District::getAll();
$diseases = Disease::getAllObjects();
$data['provinces'] = $provinces;
$data['districts'] = $districts;
$data['diseases'] = $diseases;
$data['prediction'] = Surveillance::getPrediction();
$data['surveillance_data'] = Surveillance::getSurveillanceData($epiweek, $reporting_year, $district);
$data['lab_data'] = Lab_Weekly::getWeeklyDistrictLabData($epiweek, $reporting_year, $district);
$data['editing'] = true;
$data['scripts'] = array("special_date_picker.js", "validationEngine-en.js", "validator.js");
$data["styles"] = array("validator.css");
$this->base_params($data);
}
public function add()
{
$provinces = Province::getAll();
$districts = District::getAll();
$facilities = Facilities::getAll();
$diseases = Disease::getAllObjects();
$data['provinces'] = $provinces;
$data['districts'] = $districts;
$data['facilities'] = $facilities;
$data['diseases'] = $diseases;
$data['scripts'] = array("jquery.ui.core.js", "jquery.ui.datepicker.js", "jquery.ui.widget.js");
$data['styles'] = array("jquery.ui.all.css");
$data['title'] = "Line List Data";
$data['content_view'] = "linelist_data_add_v";
$data['banner_text'] = "Linelist Data";
$data['link'] = "submissions_management";
$data['quick_link'] = "linelisted_data_management";
$this->base_params($data);
//$this -> load -> view("template", $data);
}
public function edit_duplicate($number_of_diseases, $first_surveillance_id, $malaria_data_id)
{
$last_surveillance_id = $first_surveillance_id + $number_of_diseases - 1;
$provinces = Province::getAll();
$districts = District::getAll();
$diseases = Disease::getAllObjects();
$data['provinces'] = $provinces;
$data['districts'] = $districts;
$data['diseases'] = $diseases;
$data['prediction'] = Surveillance::getPrediction();
$data['surveillance_data'] = Surveillance::getSurveillanceDataRange($first_surveillance_id, $last_surveillance_id);
$data['lab_data'] = Lab_Weekly::getLabObjects($malaria_data_id);
$data['editing'] = true;
$data['scripts'] = array("special_date_picker.js", "validationEngine-en.js", "validator.js");
$data["styles"] = array("validator.css");
$data['title'] = "Duplicate Data Editing";
$data['content_view'] = "weekly_data_add_v";
$data['banner_text'] = "Weekly Data Correction";
$data['link'] = "data_quality_management";
$this->load->view("template", $data);
}
public function provincialDetails($epiweek, $diseaseId)
{
$currentyear = date('Y');
$submissions = Surveillance::getLastEpiweek($currentyear);
$provinces = Province::getAll();
$years = Surveillance::getYears();
$data['selected_epiweek'] = $submissions->epiweek;
$data['provinces'] = $provinces;
$data['years'] = $years;
$data['values'] = $this->getAllProvinces($epiweek, $diseaseId, $provinces);
$name = Disease::getName($diseaseId);
$data['diseaseName'] = $name->Name;
$data['content_view'] = 'submissions_prov_v';
$this->base_params($data);
}
function dave()
{
$year = $_POST['year'];
$disease = $_POST['disease'];
$province = $_POST['province'];
$epiweek = $_POST['epiweek'];
$values = array($year, $disease, $province, $epiweek);
$currentyear = date('Y');
$rights = User_Right::getRights($this->session->userdata('access_level'));
$menu_data = array();
$menus = array();
$counter = 0;
foreach ($rights as $right) {
$menu_data['menus'][$right->Menu] = $right->Access_Type;
$menus['menu_items'][$counter]['url'] = $right->Menu_Item->Menu_Url;
$menus['menu_items'][$counter]['text'] = $right->Menu_Item->Menu_Text;
$counter++;
}
$this->session->set_userdata($menu_data);
$this->session->set_userdata($menus);
$provinces = Province::getAll();
$epiweeks = Surveillance::getEpiweek();
$years = Surveillance::getYears();
$diseases = Diseases::getAllObjects();
$this->load->database();
$sql = 'select Districts.name as District, Lmcase,Gmcase,Lfcase,Gfcase from Surveillance,Districts,Diseases where Epiweek = ? and Disease = ? and Reporting_Year = ? and abs(Lmcase) != 0 and abs(Gmcase) != 0 and abs(Lfcase) != 0 and ABS(Gfcase) != 0 and surveillance.disease=diseases.id and surveillance.district=districts.id';
$query = $this->db->query($sql, array($epiweek, $disease, $year));
$data['epidemiks'] = $query->result_array();
$data['epiweeks'] = $epiweeks;
$data['provinces'] = $provinces;
$data['years'] = $years;
$data['diseases'] = $diseases;
$data['values'] = $values;
$data['scripts'] = array("FusionCharts/FusionCharts.js");
$data['title'] = "System Home";
$data['content_view'] = "home_v";
$data['banner_text'] = "System Home";
$data['link'] = "home";
$this->load->view("template", $data);
}
public function generate()
{
$bata_buffer = "";
$year = $this->input->post('year_from');
$epiweek = $this->input->post('epiweek_to');
$province = $this->input->post('province');
$district = $this->input->post('district');
$display_type = $this->input->post('display_type');
$weekending = Surveillance::getWeekEnding($year, $epiweek);
$provinces = array();
$districts = array();
//Check if a province has been specified
if ($province > 0) {
//if so, retrieve it's details from the database
$provinces = Province::getProvince($province);
} else {
//if not, retrieve all provinces
$provinces = Province::getAll();
}
//Check if a district has been specified
if ($district > 0) {
//if so, retrieve it's details from the database
$districts = District::getDistrict($district);
//also, retrieve the province details for this district
$provinces = Province::getProvince($districts[0]['Province']);
} else {
//if not, empty the array
$districts = array();
}
//Start displaying the header of the table
$bata_buffer .= " <table class='data-table'>\n <tr style='background: #F5D2AE;'>\n <th rowspan=2>Province</th>\n <th rowspan=2>District</th>\n <th rowspan=2>Reports Expected</th>\n <th rowspan=2>Reports Received</th>\n <th rowspan=2>%RR</th>";
$diseases["reports"] = "reports";
$diseases["submitted"] = "submitted";
$diseases["percentage"] = "percentage";
$disease_array = Disease::getAll();
foreach ($disease_array as $disease) {
if ($disease['Name'] == 'Malaria') {
$diseases[$disease['id']] = $disease['Name'];
$diseases["tested"] = "tested";
$diseases["positive"] = "positive";
$bata_buffer .= "<th rowspan=2>" . $disease['Name'] . "</th>";
$bata_buffer .= "<th colspan=2 style='color:green;'>" . $disease['Name'] . " Indicators</th>";
} else {
$diseases[$disease['id']] = $disease['Name'];
$bata_buffer .= "<th rowspan=2>" . $disease['Name'] . "</th>";
}
}
//Finish Displaying the Header
$bata_buffer .= " </tr>\n <tr style='background: #F5D2AE'>\n <th >Tested</th><th >Positive</th>\n </tr>\n\t\t";
//Start retrieving all the rows for the data
foreach ($provinces as $province_object) {
$bata_buffer .= "<tr class='even'><td style='font-weight:bold; font-size:14px'>" . $province_object->Name . "</td></tr>";
$province_districts = array();
//check if a district was specified
if (count($districts) > 0) {
$province_districts = $districts;
} else {
//Get all the districts for this province
$province_districts = district::getProvinceDistrict($province_object->id);
}
//loop through all the districts to get their data
foreach ($province_districts as $province_district) {
$available_data = array();
$surveillance_counter = 2;
$bata_buffer .= "<tr class='even' style='background:#C4E8B7'><td></td><td>" . $province_district['Name'] . "</td>";
$surveillance_data = Surveillance::getWeeklySummaries($year, $epiweek, $province_district['id']);
//Check if any surveillance data exists
if (isset($surveillance_data[0])) {
$available_data['reports'] = $surveillance_data[0]['Expected'];
$available_data['submitted'] = $surveillance_data[0]['Submitted'];
//Calculate the reporting
$available_data['percentage'] = floor($available_data['submitted'] / $available_data['reports'] * 100);
//Display these Parameters
$bata_buffer .= "<td>" . $available_data['reports'] . "</td><td>" . $available_data['submitted'] . "</td><td>" . $available_data['percentage'] . "</td>";
} else {
$bata_buffer .= "<td>DNR</td><td>DNR</td><td>0</td>";
}
//Check if there is any surveillance data
if (isset($surveillance_data[0])) {
//Loop through all the surveillance data returned
foreach ($surveillance_data as $disease_data) {
$bata_buffer .= "<td>" . $disease_data['Cases'] . "(" . $disease_data['Deaths'] . ")</td>";
//Check if the disease is malaria and if so, get the lab data and display it
if ($disease_data['Disease'] == 1) {
//Get malaria data
$lab_weekly_data = Lab_Weekly::getWeeklyLabData($year, $epiweek, $province_district['id']);
//Check if any data exists
if (isset($lab_weekly_data)) {
$bata_buffer .= "<td>" . $lab_weekly_data['Tested'] . "</td><td>" . $lab_weekly_data['Positive'] . "</td>";
} else {
$bata_buffer .= "<td>DNR</td><td>DNR</td>";
}
}
}
} else {
$total_diseases = count($disease_array);
$total_elements = $total_diseases + 1;
for ($x = 0; $x <= $total_elements; $x++) {
$bata_buffer .= "<td>DNR</td>";
}
}
//Marks the end of data for one district
$bata_buffer .= "</tr>";
}
//End districts loop
}
//End provinces loop
//Finish the table
$bata_buffer .= "</table>";
//Start section that shows cumulative data
$bata_buffer .= "<table class='data-table'>\n <tr style='background: #F5D2AE;'>\n <th rowspan='2' colspan='5'>Cumulative Summaries</th>";
//Loop through all the diseases to display their names
foreach ($disease_array as $disease) {
if ($disease['Name'] == 'Malaria') {
$diseases[$disease['id']] = $disease['Name'];
$diseases["tested"] = "tested";
$diseases["positive"] = "positive";
$bata_buffer .= "<th rowspan=2>" . $disease['Name'] . "</th>";
$bata_buffer .= "<th colspan=2 style='color:green;'>" . $disease['Name'] . " Indicators</th>";
} else {
$diseases[$disease['id']] = $disease['Name'];
$bata_buffer .= "<th rowspan=2>" . $disease['Name'] . "</th>";
}
}
//end diseases loop
$bata_buffer .= "</tr>\n <tr style='background: #F5D2AE'>\n <th >Tested</th><th >Positive</th>\n </tr>";
//Get the malaria lab data summaries
$lab_weekly_summary = Lab_Weekly::getWeeklyLabSummaries($year, $epiweek);
//Start Displaying this week summary
$bata_buffer .= "<tr class='even'><td rowspan='2' colspan='5'>Week " . $epiweek . " Summary</td>";
//Get the summary for the week. Disease cases vs. deaths
$disease_deaths = array();
foreach ($disease_array as $disease_object) {
$disease_summaries = Surveillance::getWeeklyDiseaseSummaries($year, $epiweek, $disease_object['id']);
$bata_buffer .= "<td>" . $disease_summaries['Cases'] . "</td>";
$disease_deaths[$disease_object['id']] = $disease_summaries['Deaths'];
//check if the disease is Malaria. If so, display lab data
if ($disease_object['Name'] == "Malaria") {
$bata_buffer .= "<td rowspan=2>" . $lab_weekly_summary['Tested'] . "</td>";
$bata_buffer .= "<td rowspan=2>" . $lab_weekly_summary['Positive'] . "</td>";
}
}
//Finish the cases row
$bata_buffer .= "</tr>";
//Start the deaths row
$bata_buffer .= "<tr>";
//Loop through one more time to display the total number of deaths
foreach ($disease_array as $disease_object) {
$bata_buffer .= "<td>(" . $disease_deaths[$disease_object['id']] . ")</td>";
}
//finish the deaths row
$bata_buffer .= "</tr>";
//Get the annual summary
//Get the malaria lab data summaries
$lab_weekly_summary = Lab_Weekly::getAnnualLabSummaries($year);
//Start Displaying this week summary
$bata_buffer .= "<tr class='even' style='background:#BB00FF'><td rowspan='2' colspan='5'>Years Cummulative Summary</td>";
//Get the summary for the week. Disease cases vs. deaths
$disease_deaths = array();
foreach ($disease_array as $disease_object) {
$disease_summaries = Surveillance::getAnnualDiseaseSummaries($year, $disease_object['id']);
$bata_buffer .= "<td>" . $disease_summaries['Cases'] . "</td>";
$disease_deaths[$disease_object['id']] = $disease_summaries['Deaths'];
//check if the disease is Malaria. If so, display lab data
if ($disease_object['Name'] == "Malaria") {
$bata_buffer .= "<td rowspan=2>" . $lab_weekly_summary['Tested'] . "</td>";
$bata_buffer .= "<td rowspan=2>" . $lab_weekly_summary['Positive'] . "</td>";
}
}
//Finish the cases row
$bata_buffer .= "</tr>";
//Start the deaths row
$bata_buffer .= "<tr class='even' style='background:#BB00FF'>";
//Loop through one more time to display the total number of deaths
foreach ($disease_array as $disease_object) {
$bata_buffer .= "<td>(" . $disease_deaths[$disease_object['id']] . ")</td>";
}
//finish the deaths row
$bata_buffer .= "</tr></table>";
$this->generatePDF($year, $bata_buffer, $epiweek, $weekending, $display_type);
}
