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