Ejemplo n.º 1
0
 public function generate_commodities_excel()
 {
     $commodities = Commodities::get_all_with_suppliers();
     $column_data = array("Commodity Code", "Commodity Name", "Commodity Source", "Unit Size");
     $row_data = array();
     foreach ($commodities as $key => $facility_data_item) {
         array_push($row_data, array($facility_data_item["commodity_code"], $facility_data_item["commodity_name"], $facility_data_item["commodity_source"], $facility_data_item["unit_size"]));
     }
     // echo "<pre>";print_r($row_data);exit;
     $excel_data = array('doc_creator' => "HCMP", 'doc_title' => "HCMP Commodities", 'file_name' => "HCMP Commodities");
     $excel_data['column_data'] = $column_data;
     $excel_data['row_data'] = $row_data;
     $this->hcmp_functions->create_new_excel($excel_data);
 }