public function ors_zinc_consumption_report()
{
//Set the current year
$year = date("Y");
$county_total = array();
$excel_data = array();
$excel_data = array('doc_creator' => "HCMP", 'doc_title' => ' consumption report ', 'file_name' => 'stock level report');
$row_data = array();
$column_data = array("County", "Sub-County", "Facility Code", "Facility Name", "Commodity Name", "Unit Cost(KES)", "Supplier", "Batch Number", "Quantity Consumed (Packs)", "Quantity Consumed (Units)", "Date Last Issued", "Days From Last Issue");
$excel_data['column_data'] = $column_data;
//the commodities variable will hold the values for the three commodities ie ORS and Zinc
$commodities = array(51, 267, 36, 456);
foreach ($commodities as $commodities) {
$commodity_stock_level = array();
//holds the data for the entire county
//once it is done executing for one commodity it will reset to zero
$commodity_total = array();
//pick the commodity names and details
//get the consumption for that commodity
$commodity_consumption = facility_issues::get_consumption_report_ors_zinc($commodities);
//Start building the excel file
foreach ($commodity_consumption as $commodity_consumption) {
//pick the facility code from the data
$facility_code = $commodity_consumption["facility_code"];
//get the last date of issue from the database
$date_last_issue = Facilities::get_last_issue($facility_code);
//ensure that if the date is null change the message
$date_of_last_issue = $date_last_issue[0]['Date Last Issued'] != 0 ? date('j M, Y', strtotime($date_last_issue[0]['Date Last Issued'])) : "No Data Found";
$days_since_last_issue = $date_last_issue[0]['Days From Last Issue'] != 0 ? $date_last_issue[0]['Days From Last Issue'] : 0;
array_push($row_data, array($commodity_consumption["county"], $commodity_consumption["district"], $commodity_consumption["facility_code"], $commodity_consumption["facility_name"], $commodity_consumption["commodity_name"], $commodity_consumption["unit_cost"], $commodity_consumption["source_name"], $commodity_consumption["batch_no"], $commodity_consumption["total_packs"], $commodity_consumption["total_units"], $date_of_last_issue, $days_since_last_issue));
}
}
$excel_data['row_data'] = $row_data;
$excel_data['report_type'] = "download_file";
$excel_data['file_name'] = "Consumption Report For Zinc & ORS";
$excel_data['excel_title'] = "Consumption Report for Zinc sulphate Tablets 20mg and ORS sachet (for 500ml) low osmolality (100) & (50) as at " . date("jS F Y");
//Start the email section of the report
//Get the number of facilities using HCMP
$no_of_facilities = Facilities::get_all_on_HCMP();
$subject = "Consumption Report: Zinc sulphate Tablets 20mg and ORS sachet (for 500ml) low osmolality ";
$message = "<p>Find attached an excel sheet with a Consumption Report for\n\tZinc Sulphate 20mg, ORS sachet (for 500ml) low osmolality (100 & 50) and ORS 4 Satchets & Zinc 10 Tablets 20 Mg as at " . date("jS F Y") . "</p>";
$message .= "<p>Number of facilities using HCMP: " . $no_of_facilities . "</p>";
$message .= $message_body;
$message .= "\n\t<p>You may log onto health-cmp.or.ke for follow up.</p>\n\n\t<p>----</p>\n\n\t<p>HCMP</p>\n\n\t<p>This email was automatically generated. Please do not respond to this email address or it will be ignored.</p>";
$report_type = "ors_report";
$this->create_excel($excel_data, $report_type);
//exit;
//path for windows
$handler = "./print_docs/excel/excel_files/" . $excel_data['file_name'] . ".xls";
//path for Mac
//$handler = "/Applications/XAMPP/xamppfiles/htdocs/hcmp/print_docs/excel/excel_files/" . $excel_data['file_name'] . ".xls";
$email_address = "*****@*****.**";
$bcc = "karsanrichard@gmail.com,kelvinmwas@gmail.com";
$this->hcmp_functions->send_email($email_address, $message, $subject, $handler, $bcc);
}