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 sub_county_program_reports()
{
$user_indicator = $district_id = $this->session->userdata('user_indicator');
switch ($user_indicator) {
case district:
$district_id = $this->session->userdata('district_id');
$facilities = Facilities::get_district_facilities($district_id);
$index = 0;
foreach ($facilities as $ids) {
$facility_id = $ids['facility_code'];
$report_malaria = Malaria_Data::get_facility_report_details($facility_id);
$report_RH = RH_Drugs_Data::get_facility_report_details($facility_id);
if (!empty($report_RH) && !empty($report_malaria)) {
$report_RH_report[$index] = $report_RH;
$report_malaria_report[$index] = $report_malaria;
} else {
}
$index++;
}
$data['malaria'] = $report_malaria_report;
$data['RH'] = $report_RH_report;
$data['title'] = "Program Reports";
$data['banner_text'] = "Program Reports";
$data['report_view'] = "subcounty/reports/program_reports_v";
break;
case county:
$county_id = $this->session->userdata('county_id');
break;
}
$data['content_view'] = "facility/facility_reports/reports_v";
$data['sidebar'] = "shared_files/report_templates/side_bar_sub_county_v";
$this->load->view('shared_files/template/template', $data);
}
