public function index() { $county_id = $this->session->userdata('county_id'); $data['district_data'] = districts::getDistrict($county_id); $data['banner_text'] = "Facility Training Evaluation Results"; $data['title'] = "Facility Training Evaluation Results"; $data['report_view'] = "subcounty/reports/analysis_home"; $data['sidebar'] = "shared_files/report_templates/side_bar_sub_county_v"; $data['content_view'] = "facility/facility_reports/reports_v"; $data['report_view'] = "subcounty/reports/analysis_home"; $this->load->view('shared_files/template/template', $data); }
public function get_district_facility_mapping_($district_id) { $facility_data = facilities::getFacilities($district_id); $dpp_details = Users::get_dpp_details($district_id)->toArray(); $district_name = districts::getDistrict(null, $district_id)->toArray(); $table_body = ""; $dpp_fname = ''; $dpp_lname = ''; $dpp_phone = ''; $dpp_email = ''; $indicator = "SubCounty"; $no_of_facility_users = 0; $no_of_facility_users_online = 0; $no_of_facilities = 0; $no_of_facilities_using = 0; $no_of_facilities_using_targetted = 0; $series_data = $graph_data = array(); if (count($dpp_details) > 0) { $dpp_fname = $dpp_details[0]['fname']; $dpp_lname = $dpp_details[0]['lname']; $dpp_phone = $dpp_details[0]['telephone']; $dpp_email = $dpp_details[0]['email']; } foreach ($facility_data as $facility_detail) { $facility_code = $facility_detail->facility_code; $facility_extra_data = facilities::get_facility_status_no_users_status($facility_code); $no_of_facility_users = $no_of_facility_users + $facility_extra_data[0]['number_of_users']; $no_of_facility_users_online = $no_of_facility_users_online + $facility_extra_data[0]['number_of_users_online']; $no_of_facilities = $no_of_facilities + 1; $using = $facility_detail->using_hcmp; $status_radio = $facility_detail->targetted == 1 ? 'checked="true"' : null; $using == 1 ? $no_of_facilities_using = $no_of_facilities_using + 1 : ($status = null); $temp = $facility_extra_data[0]['status']; $status_using = $using == 1 ? 'checked="true"' : null; $a_date = strtotime($facility_detail->date_of_activation) ? date('d M, Y', strtotime($facility_detail->date_of_activation)) : "N/A"; $using == 1 ? $status = "<span class='label label-success'>Active</span>" : ($status = "<span class='label label-warning'>Inactive</span>"); $facility_detail->targetted == 1 ? $no_of_facilities_using_targetted = $no_of_facilities_using_targetted + 1 : null; array_push($series_data, array($district_name[0]['district'], $facility_detail->facility_name, $facility_code, $facility_detail->owner, $status, "<input id='{$facility_detail->id}' type='checkbox' name='targetted' class='checkbox' {$status_radio}/>", "<input id='{$facility_detail->id}' name='using_hcmp' type='checkbox' class='checkbox' {$status_using}/>", $a_date, $facility_extra_data[0]['number_of_users'])); } $stats_data = ' <table style="float:left"> <tr> <td><label style=" font-weight: ">' . $district_name[0]['district'] . ' ' . $indicator . ' Pharmacist :</label></td> <td><a class="badge">' . $dpp_fname . ' ' . $dpp_lname . '</a></td> </tr> <tr> <td><label style="font-weight: ">Phone No.</label></td> <td><a class="badge">' . $dpp_phone . '</a></td> </tr> <tr> <td><label style="font-weight: ">Email Address</label></td> <td><a class="badge">' . $dpp_email . '</a></td> </tr> </table> <table style="float:left"> <tr> <td><label style=" font-weight: ">Total No of Facilities</label></td> <td><a class="badge" >' . $no_of_facilities . '</a></td> </tr> <tr> <td><label style="font-weight: ">Total No of Facilities Targeted</label></td> <td> <a class="badge">' . $no_of_facilities_using_targetted . '</a></td> </tr> <tr> <td><label style="font-weight: ">Total No of Facilities Using HCMP </label></td> <td> <a class="badge">' . $no_of_facilities_using . '</a></td> </tr> <tr> <td><label style="font-weight: ">Total No of Users</label></td> <td><a class="badge" >' . $no_of_facility_users . '</a></td> </tr> </table> </br><p>'; $category_data = array(array("Sub County", 'Facility Name', "MLF No", "Owner", "Facility Status", "Targeted For Roll Out", "Using HCMP", "Date Activated", "No. Facility Users")); $graph_data = array_merge($graph_data, array("table_id" => 'dem_graph_1')); $graph_data = array_merge($graph_data, array("table_header" => $category_data)); $graph_data = array_merge($graph_data, array("table_body" => $series_data)); $data['table'] = $this->hcmp_functions->create_data_table($graph_data); $data['table_id'] = "dem_graph_1"; $data['stats_data'] = $stats_data; return $this->load->view("shared_files/report_templates/data_table_template_v", $data); }
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); }
public function compare_counties($county1, $county2, $month = null, $year = null) { if ($month == null) { $year = date('Y', time()); $month = date('m', time()); } else { $year = $year; $month = $month; } $current_month_year = $year . '-' . $month . '-01'; $period = $month . $year; $month_prev = date('Y-m-d', strtotime("last month", strtotime($current_month_year))); $month_prev = date('m', strtotime("{$month_prev}")); //echo "$month_prev";die(); $year_prev = date('Y', strtotime("last month", strtotime($current_month_year))); $period_prev = $month_prev . $year_prev; $previous_month_year = date('Y-m-d', strtotime("last month", strtotime($current_month_year))); $month_prev1 = date('m', strtotime("last month", strtotime($previous_month_year))); $year_prev1 = date('Y', strtotime("last month", strtotime($previous_month_year))); $period_prev1 = $month_prev1 . $year_prev1; $period = $month . '' . $year; $county_one_current = $this->_requested_vs_allocated($year, $month, $county1); $county_one_previous = $this->_requested_vs_allocated($year_prev, $month_prev, $county1); $county_one_previous1 = $this->_requested_vs_allocated($year_prev1, $month_prev1, $county1); $county_two_current = $this->_requested_vs_allocated($year, $month, $county2); $county_two_previous = $this->_requested_vs_allocated($year_prev, $month_prev, $county2); $county_two_previous1 = $this->_requested_vs_allocated($year_prev1, $month_prev1, $county2); $districts_in_county1 = count(districts::getDistrict($county1)); $districts_in_county2 = count(districts::getDistrict($county2)); $county1_facilities = count($this->_facilities_in_county($county1)); $county2_facilities = count($this->_facilities_in_county($county2)); $total_districts = array($districts_in_county1, $districts_in_county2); $total_facilities = array($county1_facilities, $county2_facilities); $returnable = array('Period' => $period, 'district_totals' => $total_districts, 'facility_totals' => $total_facilities, 'first_county' => $county_one_current, 'second_county' => $county_two_current); $returnable_prev = array('Period' => $period_prev, 'district_totals' => $total_districts, 'facility_totals' => $total_facilities, 'first_county' => $county_one_previous, 'second_county' => $county_two_previous); $returnable_prev1 = array('Period' => $period_prev1, 'district_totals' => $total_districts, 'facility_totals' => $total_facilities, 'first_county' => $county_one_previous1, 'second_county' => $county_two_previous1); $returnable_final = array('Current Month' => $returnable, 'Previous Month' => $returnable_prev, 'Two Months Ago' => $returnable_prev1); //$stats = $this->_county_allocation_stats($county1); return $returnable_final; }
public function facility_profile($mfl) { $data = array(); $lastday = date('Y-m-d', strtotime("last day of previous month")); $County = $this->session->userdata('county_name'); $Countyid = $this->session->userdata('county_id'); $districts = districts::getDistrict($Countyid); $sql = "select * from facilities where facility_code={$mfl}"; $facility = $this->db->query($sql)->result_array(); $mfl = $facility[0]['facility_code']; $data['reports'] = $this->_monthly_facility_reports($mfl); $data['facility_county'] = $data['reports'][0]['county']; $data['facility_district'] = $data['reports'][0]['district']; $data['district_id'] = $data['reports'][0]['district_id']; $data['facilities_in_district'] = json_encode($this->_facilities_in_district($data['district_id'])); $data['facilities_in_district'] = str_replace('"', "'", $data['facilities_in_district']); $data['county_id'] = $data['reports'][0]['county_id']; $data['districts'] = $districts; $data['county'] = $County; $data['mfl'] = $mfl; $data['countyid'] = $Countyid; $data['title'] = $facility[0]['facility_name'] . '-' . $mfl; $data['facility_name'] = $facility[0]['facility_name']; $data['banner_text'] = 'Facility Profile: ' . $facility[0]['facility_name'] . '-' . $mfl; $data['content_view'] = "rtk/rtk/shared/facility_profile_view"; $this->load->view("rtk/template", $data); }
public function get_county_district_access_list() { $first_day_of_the_month = date("Y-m-1", strtotime("this month")); $last_day_of_the_month = date("Y-m-t", strtotime("this month")); $date_1 = new DateTime($first_day_of_the_month); $date_2 = new DateTime($last_day_of_the_month); $county_id = $this->session->userdata('county_id'); $district_data = districts::getDistrict($county_id); $series_data = array(); $category_data = array(); $interval = $date_1->diff($date_2); for ($i = 0; $i < $interval->d; $i++) { $day = 1 + $i; $new_date = date("Y") . "-" . date("m") . "-" . $day; $new_date = date('Y-m-d', strtotime($new_date)); if (date('N', strtotime($new_date)) < 6) { //echo $new_date."<BR>"; $date_ = date('D d', strtotime($new_date)); $category_data = array_merge($category_data, array($date_)); $temp_1 = array(); foreach ($district_data as $district_) { $district_id = $district_->id; $district_name = $district_->district; $county_data = Log::get_county_login_count($county_id, $district_id, $new_date); array_key_exists($district_name, $series_data) ? $series_data[$district_name] = array_merge($series_data[$district_name], array((int) $county_data[0]['total'])) : ($series_data = array_merge($series_data, array($district_name => array((int) $county_data[0]['total'])))); } } else { // do nothing } } $string = null; print_r($series_data); exit; foreach ($series_data as $key => $raw_data) { /*$string .="{ name: '$key', data:[ ";*/ print_r($raw_data); exit; /* foreach ($raw_data as $key_data): $string .="$key_data,"; endforeach; $string .="]},";*/ } echo $string; }