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