public function tracer_report() { //seth //THIS REPORT IS CURRENTLY STATIC UNTIL AN INTERFACE IS MADE // $t_report = Facility_stocks::get_tracer_items_report_new($facility_code, $district_id, $county_id, $category_id, $commodity_id, $option, $from, $to, $report_type, $tracer); $county_name = counties::get_county_name(1); $t_report = Facility_stocks::get_tracer_items_report_new(NULL, NULL, 1, NULL, NULL, NULL, 1427839200, 1430344800, NULL, 1, "packs"); //can add 'mos' for months of stock $stock_lvl = Facility_stocks::get_county_stock_level_tracer(1, NULL, NULL, "ksh"); //county id only $excel_data = array('doc_creator' => 'HCMP Kenya', 'doc_title' => 'Tracer Commodity Report For $county_name[\'county_name\']', 'file_name' => 'Nairobi County Tracer Commodity Monthly Report'); $row_data = array(); $column_data = array("KEMSA Code", "Proprietary Drug Name", "Unit Of Issue", "Consumption (AMC) in Packs", "Current Stock Level in Packs"); $excel_data['column_data'] = $column_data; // echo "<pre>";print_r($stock_lvl);echo "</pre>";exit; $chopped_down = array(); foreach ($t_report as $chunk) { foreach ($stock_lvl as $chunket) { if ($chunk['commodity_id'] == $chunket['commodity_id']) { $chopped_down[] = array('commodity_code' => $chunk['commodity_code'], 'commodity_name' => $chunket['commodity_name'], 'issue_unit' => $chunk['unit_size'], 'consumption' => $chunk['total'], 'stock_total' => $chunket['total']); //end of chopped down array assignments } //end of if } //stock level foreach } //tracer report foreach foreach ($chopped_down as $spliced) { array_push($row_data, array($spliced["commodity_code"], $spliced["commodity_name"], $spliced["issue_unit"], $spliced["consumption"], $spliced["stock_total"])); } $excel_data['row_data'] = $row_data; // echo "<pre>";print_r($chopped_down);echo "</pre>";exit; $this->hcmp_functions->create_excel($excel_data); }