private function export() { $output = fopen('php://output', 'w') or Utils::fatalError(); header('Content-Type:application/csv'); header('Content-Disposition:attachment;filename=export.csv'); $clients = Client::scope()->get(); AccountController::exportData($output, $clients->toArray()); $contacts = Contact::scope()->get(); AccountController::exportData($output, $contacts->toArray()); $invoices = Invoice::scope()->get(); AccountController::exportData($output, $invoices->toArray()); $invoiceItems = InvoiceItem::scope()->get(); AccountController::exportData($output, $invoiceItems->toArray()); $payments = Payment::scope()->get(); AccountController::exportData($output, $payments->toArray()); $credits = Credit::scope()->get(); AccountController::exportData($output, $credits->toArray()); fclose($output); exit; }
private function export() { $fecha = Input::get('invoice_date'); $output = fopen('php://output', 'w') or Utils::fatalError(); header('Content-Type:application/csv'); header('Content-Disposition:attachment;filename=export.csv'); $BookSale = DB::table('book_sales')->select('nit_client', 'rz_client', 'number_invoice', 'na_account', 'date_invoice', 'amount', 'ice', 'exempt', 'net_amount', 'iva', 'status', 'cc_invoice')->where('account_id', '=', Auth::user()->account_id)->where('date_invoice', 'LIKE', '%' . $fecha . '%')->get(); AccountController::exportData($output, Utils::toArray($BookSale)); // $clients = Client::scope()->get(); // AccountController::exportData($output, $clients->toArray()); // $contacts = Contact::scope()->get(); // AccountController::exportData($output, $contacts->toArray()); // $invoices = Invoice::scope()->get(); // AccountController::exportData($output, $invoices->toArray()); // $invoiceItems = InvoiceItem::scope()->get(); // AccountController::exportData($output, $invoiceItems->toArray()); // $credits = Credit::scope()->get(); // AccountController::exportData($output, $credits->toArray()); fclose($output); exit; }