function stock_level() { $data['title'] = "Stock level"; $data['content_view'] = "stock"; $data['scripts'] = array("FusionCharts/FusionCharts.js"); $data['banner_text'] = "Stock Level"; $data['quick_link'] = "load_stock"; $data['link'] = "home"; $data['counties'] = Counties::getAll(); $data['categories'] = Drug_category::getAll(); $data['quick_link'] = "load_stock"; $this->load->view("template", $data); }
public function manage_users() { $permissions = 'super_permissions'; $data['title'] = "Users"; $data['content_view'] = "Admin/users_v"; $data['listing'] = Users::get_user_list_all(); $data['counts'] = Users::get_users_count(); $data['counties'] = Counties::getAll(); $data['facilities'] = Facilities::getAll(); $data['sub_counties'] = Districts::getAll(); $data['user_types'] = Access_level::get_access_levels($permissions); $this->load->view("shared_files/template/dashboard_v", $data); }
public function submit() { $id = $this->input->post('id'); $password = $this->input->post('password'); $use_id = $id; if ($this->_submit_validate() === FALSE) { $this->index($use_id); return; } $pass = Doctrine::getTable('user')->findOneById($id); $pass->password = $password; $pass->save(); $data['title'] = "View Users"; $data['content_view'] = "users_facility_v"; $data['banner_text'] = "Facility Users"; $data['result'] = User::getAll2(); $data['counties'] = Counties::getAll(); $this->load->view("template", $data); }
public function addCounty() { $results = Counties::getAll(); $dyn_table = "<table border='1' id='patient_listing' cellpadding='5' class='dataTables'>"; $dyn_table .= "<thead><tr><th>County Name</th><th> Options</th></tr></thead><tbody>"; if ($results) { foreach ($results as $result) { if ($result['active'] == '1') { $option = "<a href='#edit_counties' data-toggle='modal' role='button' class='edit' table='counties' county='" . $result['county'] . "' county_id='" . $result['id'] . "'>Edit</a> | <a href='" . base_url() . "admin_management/disable/counties/" . $result['id'] . "' class='red'>Disable</a>"; } else { $option = "<a href='#edit_counties' data-toggle='modal' role='button' class='edit' table='counties' county='" . $result['county'] . "' county_id='" . $result['id'] . "'>Edit</a> | <a href='" . base_url() . "admin_management/enable/counties/" . $result['id'] . "' class='green'>Enable</a>"; } $dyn_table .= "<tr><td>" . $result['county'] . "</td><td>" . $option . "</td></tr>"; } } $dyn_table .= "</tbody></table>"; $data['label'] = 'County'; $data['table'] = 'counties'; $data['actual_page'] = 'View Counties'; $data['dyn_table'] = $dyn_table; $this->base_params($data); }
public function get_counties_json_data() { echo json_encode(Counties::getAll()); }
public function user_create() { //get user details in session $identifier = $this->session->userdata('user_indicator'); $user_type_id = $this->session->userdata('user_type_id'); $district = $this->session->userdata('district_id'); $county = $this->session->userdata('county_id'); $facility = $this->session->userdata('facility_id'); //query to get user listing by type of user switch ($identifier) { case 'moh': $permissions = 'moh_permissions'; $template = 'shared_files/template/dashboard_template_v'; break; case 'facility_admin': $permissions = 'facilityadmin_permissions'; $data['listing'] = Users::get_user_list_facility($facility); $template = 'shared_files/template/template'; break; case 'district': $permissions = 'district_permissions'; $data['listing'] = Users::get_user_list_district($district); $data['facilities'] = Facilities::getFacilities($district); $data['counts'] = Users::get_users_district($district); $template = 'shared_files/template/template'; break; case 'moh_user': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/dashboard_template_v'; break; case 'district_tech': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'rtk_manager': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'super_admin': $permissions = 'super_permissions'; $data['title'] = "Users"; $data['content_view'] = "Admin/users_v"; $data['listing'] = Users::get_user_list_all(); $data['counts'] = Users::get_users_count(); $data['counties'] = Counties::getAll(); $template = 'shared_files/template/dashboard_v'; break; case 'allocation_committee': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'county': $permissions = 'county_permissions'; $data['listing'] = Users::get_user_list_county($county); $data['district_data'] = districts::getDistrict($county); $data['counts'] = Users::get_users_county($county); $template = 'shared_files/template/template'; break; } $data['title'] = "User Management"; $data['user_types'] = Access_level::get_access_levels($permissions); $data['banner_text'] = "User Management"; $data['content_view'] = "shared_files/user_creation_v"; $this->load->view($template, $data); }
public function user_create_multiple($facility_code = null) { //get user details in session $identifier = $this->session->userdata('user_indicator'); $user_type_id = $this->session->userdata('user_type_id'); $district = $this->session->userdata('district_id'); $county = $this->session->userdata('county_id'); $facility = $this->session->userdata('facility_id'); //query to get user listing by type of user switch ($identifier) { case 'moh': $permissions = 'moh_permissions'; $template = 'shared_files/template/dashboard_template_v'; break; case 'facility_admin': $permissions = 'facilityadmin_permissions'; $data['listing'] = Users::get_user_list_facility($facility); $template = 'shared_files/template/template'; break; case 'district': $permissions = 'district_permissions'; $data['listing'] = Users::get_user_list_district($district); if ($facility_code == 0) { $data['facilities'] = Facilities::getFacilities($district); $facility_name = null; $facility_banner_text = null; $no_of_facilities = 0; } else { $data['facilities'] = Facilities::getFacilities_from_facility_code($facility_code); $facility_banner_text = ' to: ' . $data['facilities'][0]['facility_name']; $facility_name = $data['facilities'][0]['facility_name']; $no_of_facilities = 1; } $data['counts'] = Users::get_users_district($district); $template = 'shared_files/template/template'; break; case 'moh_user': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/dashboard_template_v'; break; case 'district_tech': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'rtk_manager': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'super_admin': $permissions = 'super_permissions'; $data['title'] = "Users"; $data['content_view'] = "Admin/users_v"; $data['listing'] = Users::get_user_list_all(); $data['counts'] = Users::get_users_count(); $data['counties'] = Counties::getAll(); $template = 'shared_files/template/dashboard_v'; break; case 'allocation_committee': $data['listing'] = Users::get_user_list($user_type_id); $template = 'shared_files/template/template'; break; case 'county': $permissions = 'county_permissions'; if ($facility_code == 0) { $data['facilities'] = Facilities::getFacilities($district); $facility_name = null; $facility_banner_text = null; $district_name = null; $district_id = null; $no_of_facilities = 0; } else { $data['facilities'] = Facilities::getFacilities_from_facility_code($facility_code); $facility_banner_text = ' to: ' . $data['facilities'][0]['facility_name']; $facility_name = $data['facilities'][0]['facility_name']; $district_id = $data['facilities'][0]['district']; $district_data = Districts::get_district_name($district_id); $district_name = $district_data[0]['district']; $no_of_facilities = 1; } $data['listing'] = Users::get_user_list_county($county); $data['district_data'] = districts::getDistrict($county); $data['counts'] = Users::get_users_county($county); $template = 'shared_files/template/template'; break; } $data['title'] = "Add Multiple Users"; $data['user_types'] = Access_level::get_access_levels($permissions); $data['banner_text'] = "Multiple User Addition"; $data['facility_name'] = $facility_name; $data['facility_code'] = $facility_code; $data['facility_banner_text'] = $facility_banner_text; $data['district_name'] = $district_name; $data['district_id'] = $district_id; $data['no_of_facilities'] = $no_of_facilities; $data['content_view'] = "shared_files/add_users_multiple"; $this->load->view($template, $data); }
function rtk_county_sidebar() { $counties = Counties::getAll(); $table_data = ""; $allocation_rate = 0; $total_facilities_in_county = 0; $total_facilities_allocated_in_county = 1; $total_facilities = 0; $total_allocated = 0; foreach ($counties as $county_detail) { $countyid = $county_detail->id; $facilities_in_county = $this->db->query('SELECT * FROM facilities, districts, counties WHERE facilities.district = districts.id AND districts.county = counties.id AND counties.id =' . $countyid . ' AND facilities.rtk_enabled =1'); $facilities_num = $facilities_in_county->num_rows(); $sql = "SELECT DISTINCT lab_commodity_orders.id, lab_commodity_orders.facility_code\n FROM lab_commodity_details, counties, facilities, districts, lab_commodity_orders\n WHERE lab_commodity_details.facility_code = facilities.facility_code\n AND counties.id = districts.county\n AND counties.id ={$countyid} \n AND facilities.district = districts.id\n AND lab_commodity_details.order_id = lab_commodity_orders.id\n AND lab_commodity_details.allocated >0"; $allocated_facilities = $this->db->query($sql); $allocated_facilities_num = $allocated_facilities->num_rows(); // $county_map_id=$county_detail->kenya_map_id; $countyname = trim($county_detail->county); $county_detail = rtk_stock_status::get_allocation_rate_county($countyid); // $total_facilities_in_county=$county_detail['total_facilities_in_county']; $total_facilities_in_county = $total_facilities_in_county + $facilities_num; $total_facilities_allocated_in_county = $county_detail['total_facilities_allocated_in_county']; $total_facilities = $total_facilities + $facilities_num; $total_allocated = $total_allocated + $allocated_facilities_num; $table_data .= "<tr><td><a href=" . site_url() . "rtk_management/allocation_county_detail_zoom/{$countyid}> {$countyname}</a> </td><td>{$allocated_facilities_num} / {$facilities_num}</td></tr>"; } return $table_data .= "<tr><td>TOTAL </td><td> {$total_allocated} | {$total_facilities_in_county} </td><tr>"; }
public function edit_facility() { $use_id = $_POST['user_id']; //echo $use_id; /*$myobj = Doctrine::getTable('user')->findOneById($use_id); $disto=$myobj->district; $faci=$myobj->facility; $type=$myobj->usertype_id; $data['counties'] = Counties::getAll3($type); echo $faci;*/ $fname = $_POST['fname']; $lname = $_POST['lname']; $tell = $_POST['tell']; $email = $_POST['email']; $username = $_POST['username']; $type = $_POST['type']; //$use_id=$_POST['user_id']; $state = Doctrine::getTable('user')->findOneById($use_id); $state->fname = $fname; $state->lname = $lname; $state->telephone = $tell; $state->email = $email; $state->username = $username; $state->usertype_id = $type; $state->save(); $facility = $this->session->userdata('news'); $id = $this->session->userdata('user_db_id'); $data['title'] = "View Users"; $data['content_view'] = "users_facility_v"; $data['banner_text'] = "Facility Users"; $data['result'] = User::getAll2($facility, $id); $data['quick_link'] = "users_facility_v"; $data['counties'] = Counties::getAll(); $this->load->view("template", $data); }
public function dist_order() { $data['title'] = "Order View"; $data['content_view'] = "dist_order_v"; $data['banner_text'] = "Order View"; $data['link'] = "home"; $data['counties'] = Counties::getAll(); $data['myClass'] = $this; $data['quick_link'] = "moh_order_v"; $data['order_list'] = Ordertbl::get_all_orders_moh(); $this->load->view("template", $data); }
public function home($pop_up = NULL) { !$this->session->userdata('user_id') ? redirect('user') : null; $data['title'] = "Home"; $access_level = $this->session->userdata('user_indicator'); $facility_c = $this->session->userdata('news'); /* go to application/controllers/home_controller.php and check for this if statement */ if ($access_level == "scmlt") { // print_r($this->session->userdata());die; /* $district = $this->session->userdata('district_id'); $data['facilities'] = Facilities::get_total_facilities_rtk_in_district($district); $facilities = Facilities::get_total_facilities_rtk_in_district($district); $district_name = districts::get_district_name_($district); // $facilities=Facilities::get_facility_details(6); $table_body = ''; $reported = 0; $nonreported = 0; foreach ($facilities as $facility_detail) { date_default_timezone_set("EUROPE/Moscow"); $lastmonth = date('F', strtotime("last day of previous month")); $table_body .="<tr><td><a class='ajax_call_1' id='county_facility' name='" . base_url() . "rtk_management/get_rtk_facility_detail/$facility_detail[facility_code]' href='#'>" . $facility_detail["facility_code"] . "</td>"; $table_body .="<td>" . $facility_detail['facility_name'] . "</td><td>" . $district_name['district'] . "</td>"; $table_body .="<td>"; $lab_count = lab_commodity_orders::get_recent_lab_orders($facility_detail['facility_code']); // echo "<pre>";print_r($lab_count);echo "</pre>"; if ($lab_count > 0) { $reported = $reported + 1; //".site_url('rtk_management/get_report/'.$facility_detail['facility_code'])." $table_body .="<span class='label label-success'>Submitted for $lastmonth </span><a href=" . site_url('rtk_management/rtk_orders') . " class='link'> View</a></td>"; } else { $nonreported = $nonreported + 1; $table_body .="<span class='label label-danger'> Pending for $lastmonth </span> <a href=" . site_url('rtk_management/get_report/' . $facility_detail['facility_code']) . " class='link'> Report</a></td>"; } $table_body .="</td>"; } $county = $this->session->userdata('county_name'); $countyid = $this->session->userdata('county_id'); $data['countyid'] = $countyid; $data['county'] = $county; $data['table_body'] = $table_body; $data['content_view'] = "rtk/rtk/dpp/dpp_home_with_table"; $data['banner_text'] = "Home"; $data['link'] = "home"; $total = $reported + $nonreported; $percentage_complete = $reported / $total * 100; $percentage_complete = number_format($percentage_complete, 0); $data['percentage_complete'] = $percentage_complete; $data['reported'] = $reported; $data['nonreported'] = $nonreported;*/ redirect('rtk_management/scmlt_home'); } else { if ($access_level == "rtk_manager") { redirect('rtk_management/rtk_manager_home'); } else { if ($access_level == "rtk_county_admin") { redirect('rtk_management/county_home'); } else { if ($access_level == "rtk_partner_admin") { redirect('rtk_management/partner_home'); } else { if ($access_level == "allocation_committee") { redirect('rtk_management/allocation_home'); $counties = Counties::getAll(); $table_data = ""; $allocation_rate = 0; $total_facilities_in_county = 0; $total_facilities_allocated_in_county = 1; $total_facilities = 0; $total_allocated = 0; foreach ($counties as $county_detail) { $countyid = $county_detail->id; $this->load->database(); $facilities_in_county = $this->db->query('SELECT * FROM facilities, districts, counties WHERE facilities.district = districts.id AND districts.county = counties.id AND counties.id =' . $countyid . ' AND facilities.rtk_enabled =1'); $facilities_num = $facilities_in_county->num_rows(); $q = 'SELECT DISTINCT lab_commodity_orders.id, lab_commodity_orders.facility_code FROM lab_commodity_details, counties, facilities, districts, lab_commodity_orders WHERE lab_commodity_details.facility_code = facilities.facility_code AND counties.id = districts.county AND counties.id =' . $countyid . ' AND facilities.district = districts.id AND lab_commodity_details.order_id = lab_commodity_orders.id AND lab_commodity_details.allocated >0'; $allocated_facilities = $this->db->query($q); $allocated_facilities_num = $allocated_facilities->num_rows(); // $county_map_id=$county_detail->kenya_map_id; $countyname = trim($county_detail->county); $county_detail = rtk_stock_status::get_allocation_rate_county($countyid); // var_dump($county_detail); // die; // $total_facilities_in_county=$county_detail['total_facilities_in_county']; $total_facilities_in_county = $total_facilities_in_county + $facilities_num; $total_facilities_allocated_in_county = $county_detail['total_facilities_allocated_in_county']; $total_facilities = $total_facilities + $facilities_num; $total_allocated = $total_allocated + $allocated_facilities_num; $table_data .= "<tr><td><a href=" . site_url() . "rtk_management/allocation_county_detail_zoom/{$countyid}> {$countyname}</a> </td><td>{$allocated_facilities_num} / {$facilities_num}</td></tr>"; } $table_data .= "<tr><td>TOTAL </td><td> {$total_allocated} | {$total_facilities_in_county} </td><tr>"; $data['table_data'] = $table_data; $data['pop_up'] = $pop_up; $data['counties'] = $counties = Counties::getAll(); $data['content_view'] = "allocation_committee/home_v"; } } } } } $data['banner_text'] = "Home"; $data['link'] = "home"; $this->load->view("rtk/template", $data); }
function get_facility_stock() { $data['title'] = "Stock level"; $data['content_view'] = "moh/stock"; $data['banner_text'] = "Stock Level"; $data['quick_link'] = "load_stock"; $data['link'] = "home"; $data['stock_count'] = Facility_Stock::count_facility_stock($this->uri->segment(3)); $data['facility'] = $this->uri->segment(4); $data['counties'] = Counties::getAll(); $data['quick_link'] = "load_stock"; $this->load->view("template", $data); }