public function postposting(Request $request) { $sel_ag = $request->ag; $sel_ch = $request->ch; $sel_rg = $request->rg; $sel_st = $request->st; $sel_us = $request->us; $sel_ty = $request->ty; $frm = $request->fr; $to = $request->to; $agencies = ComplianceRepository::getAllAgency(); $regions = ComplianceRepository::getAllRegion(); $channels = ComplianceRepository::getAllChannel(); $stores = ComplianceRepository::getAllStore(); $users = ComplianceRepository::getAllUser(); $types = ['1' => 'OSA', '2' => 'Assoertment']; if (!empty($frm)) { $data['from'] = $frm; } if (!empty($to)) { $data['to'] = $to; } if (!empty($sel_ag)) { $data['agencies'] = $sel_ag; } if (!empty($sel_rg)) { $data['regions'] = $sel_rg; } if (!empty($sel_ch)) { $data['channels'] = $sel_ch; } if (!empty($sel_st)) { $data['stores'] = $sel_st; } if (!empty($sel_us)) { $data['users'] = $sel_us; } if (!empty($sel_ty)) { $data['types'] = $sel_ty; } $postings = HistoryRepositiry::getHistory($data); if ($request->has('submit')) { return view('history.posting', compact('postings', 'frm', 'to', 'agencies', 'sel_ag', 'regions', 'sel_rg', 'channels', 'sel_ch', 'stores', 'sel_st', 'users', 'sel_us', 'types', 'sel_ty')); } if ($request->has('download')) { $fileName = "Posting History Report.csv"; $writer = WriterFactory::create(Type::CSV); // for CSV files $writer->openToBrowser($fileName); // stream data directly to the browser $writer->addRow(array('Agency Code', 'Agency Name', 'Region Code', 'Region Name', 'Channel Code', 'Channel Name', 'Distributor', 'Store Name', 'Store Code', 'Username', 'Transaction Date', 'Posting Date', 'Posting Type')); foreach ($postings as $row) { $_data[0] = $row->agency_code; $_data[1] = $row->agency; $_data[2] = $row->region_code; $_data[3] = $row->region_name; $_data[4] = $row->channel_code; $_data[5] = $row->channel_name; $_data[6] = $row->distributor; $_data[7] = $row->store_name; $_data[8] = $row->store_code; $_data[9] = $row->username; $_data[10] = $row->transaction_date; $_data[11] = $row->updated_at; $_data[12] = $row->type; $writer->addRow($_data); // add multiple rows at a time } $writer->close(); } }