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);
}
