public function home()
{
//
$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);
//Check if the user is a pharmacist. If so, update his/her local envirinment with current values
if ($this->session->userdata('user_indicator') == "pharmacist") {
$facility_code = $this->session->userdata('facility');
//Retrieve the Totals of the records in the master database that have clones in the clients!
$today = date('m/d/Y');
$timestamp = strtotime($today);
$data['scheduled_patients'] = Patient_Appointment::getAllScheduled($timestamp);
}
$data['title'] = "System Home";
$data['content_view'] = "home_v";
$data['banner_text'] = "System Home";
$data['link'] = "home";
$this->load->view("template", $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);
}
