public function scmlt_home()
{
$msg = $this->session->flashdata('message');
if (isset($msg)) {
$data['notif_message'] = $msg;
}
if (isset($popout)) {
$data['popout'] = $popout;
}
$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);
$table_body = '';
$reported = 0;
$nonreported = 0;
$date = date('d', time());
$sql = "select distinct rtk_settings.* \n from rtk_settings, facilities \n where facilities.zone = rtk_settings.zone \n and facilities.rtk_enabled = 1";
$res_ddl = $this->db->query($sql);
$deadline_date = null;
$settings = $res_ddl->result_array();
foreach ($settings as $key => $value) {
$deadline_date = $value['deadline'];
$five_day_alert = $value['5_day_alert'];
$report_day_alert = $value['report_day_alert'];
$overdue_alert = $value['overdue_alert'];
}
date_default_timezone_set("EUROPE/Moscow");
foreach ($facilities as $facility_detail) {
$lastmonth = date('F', strtotime("last day of previous month"));
if ($date > $deadline_date) {
$report_link = "<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>";
} else {
$report_link = "<span class='label label-danger'> Pending for {$lastmonth} </span> <a href=" . site_url('rtk_management/get_report/' . $facility_detail['facility_code']) . " class='link report'> Report</a></td>";
}
$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 .= $report_link;
}
$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['title'] = "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;
$this->load->view('rtk/template', $data);
}
