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 get_district_facility_mapping_($district_id)
{
$facility_data = facilities::getFacilities($district_id);
$table_body = "";
$dpp_details = user::get_dpp_details($district_id)->toArray();
$district_name = districts::get_district_name($district_id)->toArray();
$dpp_fname = '';
$dpp_lname = '';
$dpp_phone = '';
$dpp_email = '';
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'];
}
$indicator = "District";
$no_of_facility_users = 0;
$no_of_facility_users_online = 0;
$no_of_facilities = 0;
$no_of_facilities_using = 0;
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;
if ($facility_extra_data[0]['number_of_users'] > 0) {
$no_of_facilities_using = $no_of_facilities_using + 1;
}
$table_body .= "<tr>";
$status = null;
$temp = $facility_extra_data[0]['status'];
$temp == "Active" ? $status = "<span class='label label-success'>{$temp}</span>" : ($status = "<span class='label label-important'>{$temp}</span>");
$table_body .= "<td>{$facility_code}</td>\n\t <td>{$facility_detail->facility_name}</td>\n\t <td>{$facility_detail->owner}</td>\n\t <td>{$status}</td>\n\t <td>" . $facility_extra_data[0]['number_of_users'] . "</td>\n\t <td>" . $facility_extra_data[0]['number_of_users_online'] . "</td>";
$table_body .= "</tr>";
}
$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 in The ' . $indicator . ' </label></td>
<td><a class="badge" >' . $no_of_facilities . '</a></td>
</tr>
<tr>
<td><label style="font-weight: ">Total No of Facilities in The ' . $indicator . ' Using HCMP </label></td>
<td> <a class="badge">' . $no_of_facilities_using . '</a></td>
</tr>
</table>
<table style="float:left">
<tr>
<td><label style="font-weight: ">Total No of Users in The ' . $indicator . ' </label></td>
<td><a class="badge" >' . $no_of_facility_users . '</a></td>
</tr>
<tr>
<td><label style="font-weight: ">Users online in The ' . $indicator . '</label></td>
<td><a class="badge" >' . $no_of_facility_users_online . '</a></td>
</tr>
</table>
';
$data['stats_data'] = $stats_data;
$data['table_body'] = $table_body;
$this->load->view("county/ajax_view/facility_mapping_v", $data);
}
