public function create_excel_facility_program_report($report_id, $facility_code, $report_type)
{
if ($report_type == "malaria") {
$facility_details = Facilities::get_facility_name_($facility_code)->toArray();
$from_malaria_data_table = Malaria_Data::get_facility_report($report_id, $facility_code);
$from_malaria_data_table_count = count(Malaria_Data::get_facility_report($report_id, $facility_code));
$excel_data = array('doc_creator' => $facility_details[0]['facility_name'], 'doc_title' => 'facility programm report template ', 'file_name' => $facility_details[0]['facility_name'] . 'facility programm report template ');
$row_data = array();
$column_data = array("Product Code", "Item description(Name/form/strength)", "Beginning Balance", "Quantity Received", "Quantity Dispensed", "Losses Excluding Expiries", "Adjustments", "Physical Count", "Amount Expired", "Days Out of Stock", "Report Total");
$excel_data['column_data'] = $column_data;
$from_malaria_data_table_count = count(Malaria_Data::get_facility_report($report_id, $facility_code));
for ($i = 0; $i < $from_malaria_data_table_count; $i++) {
$adjs = $from_malaria_data_table[$i]['Positive_Adjustments'] + $from_malaria_data_table[$i]['Negative_Adjustments'];
$mydrug_name = Doctrine::getTable('Malaria_drugs')->findOneBykemsa_code($from_malaria_data_table[$i]['Kemsa_Code']);
array_push($row_data, array($from_malaria_data_table[$i]["Kemsa_Code"], $commodityname = $mydrug_name->drug_name, $from_malaria_data_table[$i]["Beginning_Balance"], $from_malaria_data_table[$i]["Quantity_Received"], $from_malaria_data_table[$i]["Quantity_Dispensed"], $from_malaria_data_table[$i]["Losses_Excluding_Expiries"], $adjs, $from_malaria_data_table[$i]["Physical_Count"], $from_malaria_data_table[$i]["Expired_Drugs"], $from_malaria_data_table[$i]["Days_Out_Stock"], $from_malaria_data_table[$i]["Report_Total"]));
}
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
} elseif ($report_type == "RH") {
$facility_details = Facilities::get_facility_name_($facility_code)->toArray();
$from_RH_data_table = RH_Drugs_Data::get_facility_report($report_id, $facility_code);
$from_RH_data_table_count = count(RH_Drugs_Data::get_facility_report($report_id, $facility_code));
$excel_data = array('doc_creator' => $facility_details[0]['facility_name'], 'doc_title' => 'facility program report ', 'file_name' => $facility_details[0]['facility_name'] . 'facility program report template');
$row_data = array();
$column_data = array("Beginning Balance", "Received This Month", "Dispensed", "Losses", "Adjustments", "AEnding Balance", "Quantity Requested");
$excel_data['column_data'] = $column_data;
$from_RH_data_table_count = count(RH_Drugs_Data::get_facility_report($report_id, $facility_code));
for ($i = 0; $i < $from_RH_data_table_count; $i++) {
array_push($row_data, array($from_RH_data_table[$i]["Beginning_Balance"], $from_RH_data_table[$i]["Received_This_Month"], $from_RH_data_table[$i]["Dispensed"], $from_RH_data_table[$i]["Losses"], $from_RH_data_table[$i]["Adjustments"], $from_RH_data_table[$i]["Ending_Balance"], $from_RH_data_table[$i]["Quantity_Requested"]));
//
}
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
} elseif ($report_type == "TB") {
$facility_details = Facilities::get_facility_name_($facility_code)->toArray();
$from_TB_data_table = tb_data::get_all_other($report_id);
$from_TB_data_table_2 = tb_data::get_all_other_2($report_id);
$tb_drug_names = tb_data::get_tb_drug_names();
$excel_data = array('doc_creator' => $facility_details[0]['facility_name'], 'doc_title' => 'facility program report ', 'file_name' => $facility_details[0]['facility_name'] . 'facility program report template');
$row_data = array();
$column_data = array("Drug Name", "Pack", "Beginning Date", "Quantity Recieved This Month", "Ending Date", "Beginning Balance", "Quantity Dispensed", "Positive Adjustments", "Negative Adjustments", "Losses", "Physical Count", "Earliest Expiry", "Quantity Requested", "Report Date");
$excel_data['column_data'] = $column_data;
$from_TB_data_table_count = count(tb_data::get_all_other($report_id));
for ($i = 0; $i < $from_TB_data_table_count; $i++) {
array_push($row_data, array($tb_drug_names[$i]["drug_name"], $tb_drug_names[$i]['unit_size'], $from_TB_data_table[$i]['beginning_date'], $from_TB_data_table[$i]['currently_recieved'], $from_TB_data_table[$i]['ending_date'], $from_TB_data_table[$i]['beginning_balance'], $from_TB_data_table[$i]['quantity_dispensed'], $from_TB_data_table[$i]['positive_adjustment'], $from_TB_data_table[$i]['negative_adjustment'], $from_TB_data_table[$i]['losses'], $from_TB_data_table[$i]['physical_count'], $from_TB_data_table[$i]['earliest_expiry'], $from_TB_data_table[$i]['quantity_needed'], $from_TB_data_table[$i]["report_date"]));
//
}
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
}
}
public function RH_report($facility = NULL)
{
//Used to pick the kemsa code and assign it to elements displayed on the report
$rhtable = '';
if ($facility == NULL) {
$facility = $this->session->userdata('facility_id');
}
$user_id = $this->session->userdata('user_id');
$facility_info = tb_data::get_facility_name($facility);
$district_name_ = Districts::get_district_name_($facility_district);
$district_name = $this->session->userdata('district');
$data['facility_code'] = $facility_info['facility_code'];
$data['district_region_name'] = $district_name_['district'];
$data['facility_name'] = $facility_info['facility_name'];
$data['facility_type_'] = $facility_info['owner'];
$data['rh_data'] = $this->createrhreport($facility);
$data['content_view'] = "facility/facility_reports/facility_reports_RH_reports_v";
$data['sidebar'] = "shared_files/report_templates/side_bar_v";
$data['title'] = "RH Report";
$data['banner_text'] = "Facility RH Commodities Order";
// $view = 'shared_files/template/template';
$this->load->view($data['content_view'], $data);
}
