public function division_commodities_stock_level_graph($district_id = NULL, $county_id = NULL, $facility_code = NULL, $commodity_id = null, $division_id = NULL)
{
$county_id = $county_id == 'NULL' ? $this->session->userdata('user_indicator') == 'county' ? $this->session->userdata('county_id') : null : $county_id;
$district_id = $district_id == 'NULL' ? $this->session->userdata('user_indicator') == 'district' ? $this->session->userdata('district_id') : null : $district_id;
$facility_code = $facility_code == 'NULL' ? $this->session->userdata('user_indicator') == 'facility' ? $this->session->userdata('facility_code') : null : $facility_code;
$division_id = $division_id == 'NULL' ? null : $division_id;
$final_graph_data = facility_stocks_temp::get_division_commodities_stock($district_id, $county_id, $facility_code, $division_id);
$month = date('F Y');
if (isset($division_id)) {
$division_name = commodity_division_details::get_all_divisions($division_id)->toArray();
$title .= ' ' . @$division_name[0]['division_name'];
} else {
$division_name = null;
}
if (isset($county_id)) {
$county_name = counties::get_county_name($county_id);
$title .= ' ' . $county_name['county'] . " County ";
} else {
$county_name = null;
}
if (isset($district_id)) {
$district_name = districts::get_district_name_($district_id);
$title .= ' ' . $district_name['district'] . " Sub-County ";
} else {
$district_name = null;
}
if (isset($facility_code)) {
$facility_name = Facilities::get_facility_name2($facility_code);
$title .= ' ' . $facility_name['facility_name'];
} else {
$facility_name = null;
}
if (!isset($district_id) && !isset($facility_code) && !isset($division_id) && !isset($option)) {
$county_id = $this->session->userdata('county_id');
$county_name = counties::get_county_name($county_id);
$title .= ' ' . $county_name['county'] . " County ";
}
$graph_data = array();
$graph_data = array_merge($graph_data, array("graph_id" => 'default_graph_'));
$graph_data = array_merge($graph_data, array("graph_title" => "Months Of Stock For " . $title . ""));
$graph_data = array_merge($graph_data, array("graph_type" => 'bar'));
$graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'Months of Stock'));
$graph_data = array_merge($graph_data, array("graph_categories" => array()));
$graph_data = array_merge($graph_data, array("series_data" => array("Stock" => array())));
foreach ($final_graph_data as $final_graph_data_) {
$graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($final_graph_data_['commodity_name']));
$graph_data['series_data']['Stock'] = array_merge($graph_data['series_data']['Stock'], array((int) $final_graph_data_['total']));
}
$data['high_graph'] = $this->hcmp_functions->create_high_chart_graph($graph_data);
//echo $data['high_graph'];exit;
return $this->load->view("shared_files/report_templates/high_charts_template_v", $data);
}
public function login_submit()
{
$user = new Users();
$password = $this->input->post('password');
$username = $this->input->post('username');
$returned_user = $user->login($username, $password);
//If user successfully logs in, proceed here
if ($returned_user) {
//Create basic data to be saved in the session
$reply = Users::login($username, $password);
$user_data = $reply->toArray();
$access_typeid = $user_data['usertype_id'];
$fname = $user_data['fname'];
$user_id = $user_data['id'];
$lname = $user_data['lname'];
$district_id = $user_data['district'];
$facility_id = $user_data['facility'];
$phone = $user_data['telephone'];
$user_email = $user_data['email'];
$county_id = $user_data['county_id'];
$partner_id = $user_data['partner'];
$fullname = $fname . ' ' . $lname;
$banner_name = '';
$access_level = Access_level::get_access_level_name($access_typeid);
$user_indicator = $access_level['user_indicator'];
if ($user_indicator == 'district') {
//get county name
$district_name = districts::get_district_name_($district_id);
$banner_name = $district_name['district'] . " Sub-county";
} elseif ($user_indicator == 'county') {
//get county name
$county_name = Counties::get_county_name($county_id);
$banner_name = $county_name['county'] . " County";
} elseif ($user_indicator == 'facility' || $user_indicator == 'facility_admin') {
//get county name
$facility_name = Facilities::get_facility_name2($facility_id);
$banner_name = $facility_name['facility_name'];
}
$session_data = array('county_id' => $county_id, 'partner_id' => $partner_id, 'phone_no' => $phone, 'user_email' => $user_email, 'user_id' => $user_id, 'user_indicator' => $user_indicator, 'fname' => $fname, 'lname' => $lname, 'facility_id' => $facility_id, 'district_id' => $district_id, 'user_type_id' => $access_typeid, 'full_name' => $fullname, 'banner_name' => $banner_name);
$this->session->set_userdata($session_data);
//get menu items
$menu_items = Menu::getByUsertype($access_typeid);
//Create array that will hold all the accessible menus in the session
$menus = array();
$menuids = array();
$counter = 0;
foreach ($menu_items as $menu_item) {
$menus[$counter] = array("menu_text" => $menu_item->menu_text, "menu_url" => $menu_item->menu_url, "menu_id" => $menu_item->id, "parent_status" => $menu_item->parent_status);
$counter++;
$menuids[] = $menu_item->id;
}
$sub_menus = array();
foreach ($menuids as $parentid) {
$sub_items = Sub_menu::getByparent((int) $parentid);
foreach ($sub_items as $item) {
$sub_menus[] = array("submenu_text" => $item->subm_text, "submenu_url" => $item->subm_url, "menu_id" => $item->parent_id);
}
}
//Save this menus array in the session
$this->session->set_userdata("menus", $menus);
//Save this sub menus array in the session
$_SESSION["submenus"] = $sub_menus;
//creating a new log value
Log::update_log_out_action($this->session->userdata('user_id'));
$u1 = new Log();
$action = 'Logged In';
$u1->user_id = $this->session->userdata('user_id');
$u1->action = $action;
$u1->save();
redirect('home');
} else {
$data['popup'] = "errorpopup";
$data['title'] = "Login";
$this->load->view("shared_files/login_pages/login_v", $data);
}
}
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);
}
public function password_recovery()
{
$email = $_POST['username'];
if ($email != NULL) {
$password = '******';
$mycount = User::check_user_exist($email);
if ($mycount > 0) {
$account_details = User::get_user_details($email)->toArray();
$access_level = access_level::get_access_level_name($account_details[0]['usertype_id']);
$access_level = $access_level['level'];
switch ($account_details[0]['usertype_id']) {
case 2:
$facility_name = facilities::get_facility_name_($account_details[0]['facility']);
$user_delegation = "Facility: {$facility_name['facility_name']}";
$user_level = "Facility Level";
break;
case 5:
$facility_name = facilities::get_facility_name_($account_details[0]['facility']);
$user_delegation = "Facility: {$facility_name['facility_name']}";
$user_level = "Facility Level";
break;
case 3:
$district_name = districts::get_district_name_($account_details[0]['district']);
$user_level = "District Level";
$user_delegation = "District: {$district_name['district']}";
break;
default:
break;
}
$subject = "Password reset";
$message = 'Hello ' . $account_details[0]['fname'] . 'you requested for a password reset check you email address for more details (HCMP)';
$message_1 = 'Hello ' . $account_details[0]['fname'] . ', <br> <br> You requested for a password reset on the Health Commodities Management Platform (HCMP).
<br>
<br>
Web link: http://health-cmp.or.ke/
<br>
<br>
Please find your log in credentials below:
<br>
<br>
' . $user_delegation . '
<br>
User Level: ' . $user_level . '
<br>
User Type: ' . $access_level . '
<br>
User Name: ' . $email . '
<br>
Password: '******'
<br>
<br>';
//hash then reset password
$salt = '#*seCrEt!@-*%';
$value = md5($salt . $password);
$updatep = Doctrine_Manager::getInstance()->getCurrentConnection();
$updatep->execute("UPDATE user SET password='******' WHERE username='******' or email='{$email}'; ");
//send mail
$response = $this->send_email($email, $message_1, $subject);
$this->send_sms($account_details[0]['telephone'], $message);
$data['email'] = $email;
$data['popup'] = "Successpopup";
$this->load->view("login_v", $data);
} else {
$data['popup'] = "errorpopup";
$this->load->view("forgotpassword_v", $data);
}
} else {
$data['popup'] = "errorpopup";
$this->load->view("forgotpassword_v", $data);
}
}
public function district_store_internal()
{
//THIS FUNCTION VANISHES WHEN A COLLINS RELATED PULL GOES DOWN
//#collins_repo #my_function_my_choice #hahahaha # this was some random thing so that i can commit this function. Cheers
$district_id = $this->session->userdata('district_id');
$dist = districts::get_district_name_($district_id);
$data['district_id'] = $this->session->userdata('district_id');
$data['district_data'] = districts::get_district_name_($district_id);
$data['content_view'] = "subcounty/drug_store/drug_store_internal";
$data['donate_destination'] = "facility";
$data['subcounties'] = districts::getAll();
$data['banner_text'] = "Redistribute Commodities to District Stores";
$data['title'] = "Redistribute Commodities";
//$data['service_point']=service_points::get_all_active($facility_code);
$data['commodities'] = facility_stocks::get_distinct_stocks_for_this_district_store($district_id, 1);
// echo "<pre>";print_r($data['commodities']);echo "</pre>";exit;
$data['facility_stock_data'] = json_encode(facility_stocks::get_distinct_stocks_for_this_district_store($district_id, "batch_data"));
$this->load->view("shared_files/template/template", $data);
}
public function send_system_usage_specific($county_id = NULL, $district_id = NULL, $facility_code = NULL, $listing_email_address = NULL)
{
//Karsan
$time = date('M , d Y');
$county_name = counties::get_county_name($county_id);
$district_name = districts::get_district_name_($district_id);
$cp_email_query = "SELECT * FROM email_listing_new WHERE county = {$county_id} AND usertype = 10";
$cp_emails = $this->db->query($cp_email_query)->result_array();
$scp_email_query = "SELECT * FROM email_listing_new WHERE county = {$county_id} AND usertype = 3";
$scp_emails = $this->db->query($scp_email_query)->result_array();
// echo "<pre>";print_r($cp_emails);exit;
//CP
$cp_emails_str = '';
foreach ($cp_emails as $emails => $value) {
$cp_emails_str = $cp_emails_str . ',' . $value['email'];
// echo "<pre>";print_r($value['email']);exit;
}
$cp_emails_str = ltrim($cp_emails_str, ',');
//SCP
$scp_emails_str = '';
foreach ($scp_emails as $emails => $value) {
$scp_emails_str = $scp_emails_str . ',' . $value['email'];
// echo "<pre>";print_r($value['email']);exit;
}
$scp_emails_str = ltrim($scp_emails_str, ',');
// echo $scp_emails_str;exit;
// echo "<pre>";print_r($scp_emails);exit;
// echo "<pre>";print_r($district_name);
// echo "<pre>OVER ";
$appended = !empty($district_name) ? $district_name['district'] . " Subcounty" : $county_name['county'] . " County";
$excel_title = 'HCMP facility activity log summary for ' . $appended;
$email_subject = 'HCMP System usage report for ' . $appended . ' as at ' . $time;
// echo $county_name.' '.$district_name;
// echo $excel_title;exit;
$active_facilities = Facilities::getAll_($county_id, $district_id);
// echo "<pre>";print_r($active_facilities);echo "</pre>";exit;
$last_seen = Facilities::get_facility_data_specific(NULL, $county_id, $district_id, $facility_code, 'all');
$last_issued = Facilities::get_facility_data_specific('last_issued', $county_id, $district_id, $facility_code, 'all');
$last_ordered = Facilities::get_facility_data_specific('last_ordered', $county_id, $district_id, $facility_code, 'all');
$decommissioned = Facilities::get_facility_data_specific('last_decommissioned', $county_id, $district_id, $facility_code, 'all');
$redistributed = Facilities::get_facility_data_specific('last_redistributed', $county_id, $district_id, $facility_code, 'all');
$added_stock = Facilities::get_facility_data_specific('last_added_stock', $county_id, $district_id, $facility_code, 'all');
// $all_faciliteis = Facilities::getAll_();
// echo "<pre>";print_r($active_facilities);echo "</pre>";exit;
$facility_count = empty($active_facilities) ? NULL : count($active_facilities);
$final_array = array();
$last_seen_count = count($last_seen);
$last_issued_count = count($last_issued);
$last_ordered_count = count($last_ordered);
$decommissioned_count = count($decommissioned);
$redistributed_count = count($redistributed);
$added_stock_count = count($added_stock);
foreach ($active_facilities as $a_c) {
$final_array[] = array('Facility Name' => $a_c['facility_name'], 'Facility Code' => $a_c['facility_code'], 'County' => $a_c['county'], 'Sub-County' => $a_c['subcounty']);
}
//active_facilities foreach
$final_array_count = count($final_array);
$last_seen_time = NULL;
$last_issued_time = NULL;
$last_order_time = NULL;
$last_deccommissioned_time = NULL;
$last_redistributed_time = NULL;
$last_added_stock_time = NULL;
foreach ($final_array as $keyy => $value) {
foreach ($last_seen as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $last_seen[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($last_seen[$key]['last_seen'] > $last_seen_time) {
$last_seen_time = $last_seen[$key]['last_seen'];
$days_last_seen = $last_seen[$key]['difference_in_days'];
// echo "<pre>".$last_seen_time;
}
$final_array[$keyy]['Date Last Seen'] = $last_seen_time;
$final_array[$keyy]['Days From Last Seen'] = $days_last_seen;
// echo "<pre>".$last_seen_time;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_seen_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
// echo "<pre>";print_r($final_array);echo "</pre>";exit;
//last issued time
foreach ($final_array as $keyy => $value) {
foreach ($last_issued as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $last_issued[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($last_issued[$key]['last_seen'] > $last_issued_time) {
$last_issued_time = $last_issued[$key]['last_seen'];
$days = $last_issued[$key]['difference_in_days'];
// echo "<pre>".$last_order_time;
}
$final_array[$keyy]['Date Last Issued'] = $last_issued_time;
$final_array[$keyy]['Days From Last Issue'] = $days;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_issued_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
//last ordered
foreach ($final_array as $keyy => $value) {
foreach ($last_ordered as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $last_ordered[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($last_ordered[$key]['last_seen'] > $last_order_time) {
$last_order_time = $last_ordered[$key]['last_seen'];
$days_last_ordered = $last_ordered[$key]['difference_in_days'];
// echo "<pre>".$last_order_time;
}
$final_array[$keyy]['Date Last Ordered'] = $last_order_time;
$final_array[$keyy]['Days From Last Order'] = $days_last_ordered;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_order_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
foreach ($final_array as $keyy => $value) {
foreach ($decommissioned as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $decommissioned[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($decommissioned[$key]['last_seen'] > $last_deccommissioned_time) {
$last_deccommissioned_time = $decommissioned[$key]['last_seen'];
$days_last_decommissioned = $decommissioned[$key]['difference_in_days'];
// echo "<pre>".$last_order_time;
}
$final_array[$keyy]['Date Last Decommissioned'] = $last_deccommissioned_time;
$final_array[$keyy]['Days From Last Decommissioned'] = $days_last_decommissioned;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_deccommissioned_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
foreach ($final_array as $keyy => $value) {
foreach ($redistributed as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $redistributed[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($redistributed[$key]['last_seen'] > $last_redistributed_time) {
$last_redistributed_time = $redistributed[$key]['last_seen'];
$days_last_redistributed = $redistributed[$key]['difference_in_days'];
// echo "<pre>".$last_order_time;
}
$final_array[$keyy]['Date Last Redistributed'] = $last_redistributed_time;
$final_array[$keyy]['Days From Last Redistributed'] = $days_last_redistributed;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_redistributed_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
foreach ($final_array as $keyy => $value) {
foreach ($added_stock as $key => $value) {
if ($final_array[$keyy]['Facility Code'] == $added_stock[$key]['facility_code']) {
// echo "<pre>".$last_ordered[$j]['last_seen']." ".$last_ordered[$j]['facility_code'];
if ($added_stock[$key]['last_seen'] > $last_added_stock_time) {
$last_added_stock_time = $added_stock[$key]['last_seen'];
$days_last_added_stock = $added_stock[$key]['difference_in_days'];
// echo "<pre>".$last_order_time;
}
$final_array[$keyy]['Date Last Received Order'] = $last_added_stock_time;
$final_array[$keyy]['Days From Last Received Order'] = $days_last_added_stock;
// $final_array[$i]['Days From Last Seen'] = abs($last_seen_time - $now);
$last_added_stock_time = NULL;
}
//end of facility code if
}
//end of last seen foreach
}
// echo "<pre>";print_r($final_array);exit;
$row_data = array();
$counterrrr = 0;
foreach ($final_array as $facility) {
// echo "<pre>". $counterrrr . "</pre>";
// $counterrrr = $counterrrr + 1;
//random code to allow for commit
$issue_date = isset($facility['Date Last Issued']) ? date('Y-m-d', strtotime($facility['Date Last Issued'])) : "No Data Available";
$last_seen = isset($facility['Date Last Seen']) ? date('Y-m-d', strtotime($facility['Date Last Seen'])) : "No Data Available";
$redistribution = isset($facility['Date Last Redistributed']) ? date('Y-m-d', strtotime($facility['Date Last Redistributed'])) : "No Data Available";
$order_date = isset($facility['Date Last Ordered']) ? date('Y-m-d', strtotime($facility['Date Last Ordered'])) : "No Data Available";
$decommission_date = isset($facility['Date Last Decommissioned']) ? date('Y-m-d', strtotime($facility['Date Last Decommissioned'])) : "No Data Available";
$date_order = isset($facility['Date Last Received Order']) ? date('Y-m-d', strtotime($facility['Date Last Received Order'])) : "No Data Available";
$days_from_last_seen = isset($facility['Days From Last Seen']) ? $facility['Days From Last Seen'] : ' - ';
$days_from_last_issued = isset($facility['Days From Last Issue']) ? $facility['Days From Last Issue'] : ' - ';
$days_from_last_redist = isset($facility['Days From Last Redistributed']) ? $facility['Days From Last Redistributed'] : ' - ';
$days_from_last_ordered = isset($facility['Days From Last Order']) ? $facility['Days From Last Order'] : ' - ';
$decomissioned_days = isset($facility['Days From Last Decommissioned']) ? $facility['Days From Last Decommissioned'] : ' - ';
$days_from_last_recieved = isset($facility['Days From Last Received Order']) ? $facility['Days From Last Received Order'] : ' - ';
array_push($row_data, array($facility['Facility Name'], $facility['Facility Code'], $facility['Sub-County'], $facility['County'], $last_seen, $days_from_last_seen, $issue_date, $days_from_last_issued, $redistribution, $days_from_last_redist, $order_date, $days_from_last_ordered, $decommission_date, $decomissioned_days, $date_order, $days_from_last_recieved));
}
$excel_data = array();
// $excel_data = array('doc_creator' => 'HCMP ', 'doc_title' => 'System Usage Breakdown ', 'file_name' => 'system usage breakdown');
$excel_data = array('doc_creator' => 'HCMP-Kenya', 'doc_title' => $excel_title, 'file_name' => 'HCMP_Facility_Activity_Log_Summary_as_at_' . $time);
$column_data = array("Facility Name", "Facility Code", "Sub County", "County", "Date Last Logged In", "Days From Last Log In", "Date Last Issued", "Days From Last Issue", "Date Last Redistributed", "Days From Last Redistribution", "Date Last Ordered", "Days From Last Order", "Date Last Decommissioned", "Days From Last Decommission", "Date Last Received Order", "Days From Last Stock Addition");
$excel_data['column_data'] = $column_data;
$excel_data['row_data'] = $row_data;
$excel_data['report_type'] = 'Log Summary';
// echo "<pre>";print_r($excel_data);echo "</pre>";exit;
$res = $this->hcmp_functions->create_excel($excel_data);
// echo 'This '.$res;exit;
$message = '';
$message .= "<style> table {\n\t\t\tborder-collapse: collapse; \n\t\t}td,th{\n\t\t\tpadding: 12px;\n\t\t\ttext-align:center;\n\t\t}\n\n\t\t*{margin:0;padding:0}*{font-family:'Helvetica Neue',Helvetica,Helvetica,Arial,sans-serif}img{max-width:100%}.collapse{padding:0}body{-webkit-font-smoothing:antialiased;-webkit-text-size-adjust:none;width:100%!important;height:100%}a{color:#2BA6CB}.btn{text-decoration:none;color:#FFF;background-color:#666;padding:10px 16px;font-weight:700;margin-right:10px;text-align:center;cursor:pointer;display:inline-block}p.callout{padding:15px;background-color:#ECF8FF;margin-bottom:15px}.callout a{font-weight:700;color:#2BA6CB}table.social{background-color:#ebebeb}.social .soc-btn{padding:3px 7px;font-size:12px;margin-bottom:10px;text-decoration:none;color:#FFF;font-weight:700;display:block;text-align:center}a.fb{background-color:#3B5998!important}a.tw{background-color:#1daced!important}a.gp{background-color:#DB4A39!important}a.ms{background-color:#000!important}.sidebar .soc-btn{display:block;width:100%}table.head-wrap{width:100%}.header.container table td.logo{padding:15px}.header.container table td.label{padding:15px 15px 15px 0}table.body-wrap{width:100%}table.footer-wrap{width:100%;clear:both!important}.footer-wrap .container td.content p{border-top:1px solid #d7d7d7;padding-top:15px;font-size:9px;font-weight:500}h1,h2,h3,h4,h5,h6{font-family:HelveticaNeue-Light,'Helvetica Neue Light','Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;line-height:1.1;margin-bottom:15px;color:#000}h1 small,h2 small,h3 small,h4 small,h5 small,h6 small{font-size:60%;color:#6f6f6f;line-height:0;text-transform:none}h1{font-weight:200;font-size:44px}h2{font-weight:200;font-size:37px}h3{font-weight:500;font-size:27px}h4{font-weight:500;font-size:23px}h5{font-weight:900;font-size:17px}h6{font-weight:900;font-size:14px;text-transform:uppercase;color:#444}.collapse{margin:0!important}p,ul{margin-bottom:10px;font-weight:400;font-size:14px;line-height:1.6}p.lead{font-size:17px}p.last{margin-bottom:0}ul li{margin-left:5px;list-style-position:inside}ul.sidebar{background:#ebebeb;display:block;list-style-type:none}ul.sidebar li{display:block;margin:0}ul.sidebar li a{text-decoration:none;color:#666;padding:10px 16px;cursor:pointer;border-bottom:1px solid #777;border-top:1px solid #FFF;display:block;margin:0}ul.sidebar li a.last{border-bottom-width:0}ul.sidebar li a h1,ul.sidebar li a h2,ul.sidebar li a h3,ul.sidebar li a h4,ul.sidebar li a h5,ul.sidebar li a h6,ul.sidebar li a p{margin-bottom:0!important}.container{display:block!important;max-width:100%!important;margin:0 auto!important;clear:both!important}.content{padding:15px;max-width:80%px;margin:0 auto;display:block}.content table{width:100%}.column{width:300px;float:left}.column tr td{padding:15px}.column-wrap{padding:0!important;margin:0 auto;max-width:600px!important}.column table{width:100%}.social .column{width:280px;min-width:279px;float:left}.clear{display:block;clear:both}@media only screen and (max-width:600px){a[class=btn]{display:block!important;margin-bottom:10px!important;background-image:none!important;margin-right:0!important}div[class=column]{width:auto!important;float:none!important}table.social div[class=column]{width:auto!important}}</style>";
$message .= '
<tr>
<td colspan="12">
</tr>
</tbody>
</table>';
$message .= "<!-- BODY -->\n\t\t<table class='body-wrap'>\n\t\t\t<tr>\n\t\t\t\t<td></td>\n\t\t\t\t<td class='container' bgcolor='#FFFFFF'>\n\n\t\t\t\t\t<div class='content'>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>\n\n\t\t\t\t\t\t\t\t\t<p class='lead'>Find attached a summary of Facility Activity Log, as at {$time}</p>\n\n\t\t\t\t\t\t\t\t\t<table class='social' width='100%'>\n\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t<td>\n\n\t\t\t\t\t\t\t\t\t\t\t\t<!-- column 1 -->\n\t\t\t\t\t\t\t\t\t\t\t\t<table align='left' class='column'>\n\n\t\t\t\t\t\t\t\t\t\t\t\t</table><!-- /column 1 -->\t\n\n\t\t\t\t\t\t\t\t\t\t\t\t<!-- column 2 -->\n\t\t\t\t\t\t\t\t\t\t\t\t<table align='left' class='column'>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\n\n\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t\t\t</table><!-- /column 2 -->\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class='clear'></span>\t\n\n\t\t\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t</table><!-- /social & contact -->\n\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</div><!-- /content -->\n\n\t\t\t\t</td>\n\t\t\t\t<td></td>\n\t\t\t</tr>\n\t\t</table><!-- /BODY -->";
$handler = "./print_docs/excel/excel_files/" . $excel_data['file_name'] . ".xls";
// $subject = $excel_title." as at ".$time;
// $email_address = "smutheu@clintonhealthaccess.org,sethrichard40@gmail.com,ttunduny@gmail.com,teddyodera@gmail.com";
// $email_address = $listing_email_address;
$email_address = $cp_emails_str;
$cc_email = $scp_emails_str;
$bcc_email = "smutheu@clintonhealthaccess.org,karsanrichard@gmail.com,ttunduny@gmail.com,teddyodera@gmail.com,ronohb@gmail.com,odiwuorybrian@gmail.com,mwakiojoy@gmail.com,kevgithuka@gmail.com,margie.odora@gmail.com,kiganyastephenthua@gmail.com";
// $email_address = "*****@*****.**";
// $bcc_email = "";
// $cc_email = "";
// $email_address = "karsanrichard@gmail.com,ttunduny@gmail.com";
// $email_address = "*****@*****.**";
//$bcc = "";
if (!empty($facility_count) && $facility_count > 0) {
$status = $this->hcmp_functions->send_email($email_address, $message, $email_subject, $handler, $bcc_email, $cc_email);
}
// echo "I work till here";exit;
// echo "<pre>";print_r($status);exit;
// redirect('sms/new_weekly_usage');
}
