public function listing() { $access_level = $this->session->userdata('user_indicator'); $source = 0; if ($access_level == "pharmacist") { $source = $this->session->userdata('facility'); } $data = array(); $data['styles'] = array("jquery-ui.css"); $data['scripts'] = array("jquery-ui.js"); $data['regimens'] = Regimen::getAll($source); $data['regimens_enabled'] = Regimen::getAllEnabled($source); $data['regimen_categories'] = Regimen_Category::getAll(); $data['regimen_service_types'] = Regimen_Service_Type::getAll(); $data['drug_codes'] = Drugcode::getAll($source); $data['drug_codes_enabled'] = Drugcode::getAllEnabled($source); $this->base_params($data); }
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); }