public function donation_report_download($year = null, $county_id = null, $district_id = null, $facility_code = null)
{
//reset the values here
$year = $year == "NULL" ? date('Y') : $year;
$county_id = $this->session->userdata('county_id');
$banner = $this->session->userdata('banner_name');
$pieces = explode(",", $banner);
//echo "<pre>";var_dump($pieces[0]);echo "</pre>";exit;
$district_id = $district_id == "NULL" ? null : $this->session->userdata('district_id');
$facility_code = $facility_code == "NULL" ? null : $facility_code;
$redistribute_array = redistribution_data::get_redistribution_data($facility_code, $district_id, $county_id, $year);
//echo "<pre>";print_r($redistribute_array);echo "</pre>";exit;
$excel_data = array('doc_creator' => $county_id, 'doc_title' => 'Redistribution Summary ', 'file_name' => 'Redistribution Summary For ' . $pieces[0] . ' by ' . $pieces[1] . ' ' . '(' . $year . ')');
$row_data = array();
$column_data = array("Facility From", "Facility To", "Subcounty To", "Commodity Name", "Unit Size", "Batch No", "Expiry Date", "Manufacturer", "Quantity Sent", "Quantity Received", "Date Sent", "Date Received", "Status");
$excel_data['column_data'] = $column_data;
foreach ($redistribute_array as $column) {
array_push($row_data, array($column["source_facility_name"], $column["receiver_facility_name"], $column['receiver_district'] == "" ? $column['source_district'] : $column['receiver_district'], $column["commodity_name"], $column["unit_size"], $column["batch_no"], $column["expiry_date"], $column["manufacturer"], $column["quantity_sent"], $column["quantity_received"], $column["date_sent"], $column["date_received"], $column["status"] == 1 ? 'Delivered' : $column["status"] == 2 ? 'Non HCMP' : 'Pending'));
$facility['Date Last Ordered'] != 0 ? date('j M, Y', strtotime($facility['Date Last Ordered'])) : "No Data Available";
}
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
}
public function donation_reports($year = null, $district_id = null, $facility_code = null)
{
//reset the values here
$year = $year == "NULL" ? date('Y') : $year;
$district_id = $district_id == "NULL" ? null : $district_id;
$facility_code = $facility_code == "NULL" ? null : $facility_code;
$county_id = $this->session->userdata('county_id');
$expiries_array = redistribution_data::get_redistribution_data($facility_code, $district_id, $county_id, $year);
$graph_data = $series_data = array();
//echo "<pre>";print_r($expiries_array);echo "</pre>";
foreach ($expiries_array as $facility_expiry_data) {
$total_units = $facility_expiry_data['total_commodity_units'];
$sent_units = $facility_expiry_data['quantity_sent'];
$received_units = $facility_expiry_data['quantity_received'];
$total_sent = round($sent_units / $total_units, 1);
$total_received = round($received_units / $total_units, 1);
///date_sent
$date_received = strtotime($facility_expiry_data['date_received']) ? date('d M, Y', strtotime($facility_expiry_data['date_received'])) : "N/A";
$status = $facility_expiry_data['status'] == 0 ? "<span class='label label-danger'>Pending</span>" : ($facility_expiry_data['status'] == 1 ? "<span class='label label-success'>Received</span>" : null);
array_push($series_data, array($facility_expiry_data['source_facility_name'] . " :" . $facility_expiry_data['source_facility_code'], $facility_expiry_data['receiver_facility_name'] . " :" . $facility_expiry_data['receiver_facility_code'], $facility_expiry_data['commodity_name'], $facility_expiry_data['commodity_code'], $facility_expiry_data['unit_size'], $facility_expiry_data['batch_no'], date('d M, Y', strtotime($facility_expiry_data['expiry_date'])), $facility_expiry_data['manufacturer'], $total_sent, $sent_units, $total_received, $received_units, date('d M, Y', strtotime($facility_expiry_data['date_sent'])), $date_received, $status));
}
$total_expiry = number_format($total_expiry, 2, '.', ',');
// array_push($series_data, array("","","Total for the next $year months",$total_expiry,''));
$category_data = array(array("From", 'To', "Commodity Name", "Commodity Code", "Unit Size", 'Batch No', 'Expiry Date', 'Manufacturer', 'Quantity Sent(units)', 'Quantity Sent(packs)', 'Quantity Received (units)', 'Quantity Received (packs)', 'Date sent', 'Date Received', 'status'));
$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";
return $this->load->view("shared_files/report_templates/data_table_template_v", $data);
}
