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;
}
