<?php
namespace App\Exports;
use Maatwebsite\Excel\Concerns\FromCollection;
class VoucherExport implements FromCollection
{
/**
* @return \Illuminate\Support\Collection
*/
public function collection()
{
// $voucher = \App\PurchaseVoucher::query()->get();
$voucher = \App\PurchaseVoucher::query()
->join('imali_accounts', 'imali_accounts.user_id', '=', 'purchase_vouchers.user_id')
->join('users', 'users.id', '=', 'purchase_vouchers.user_id')
->select('reqMsgID as transaction', 'vouchername', 'vouchervalue','vouchercode', 'purchase_vouchers.pin', 'account_number', 'users.name', 'users.last_name',
'purchase_vouchers.created_at as data')
// ->whereDate('purchase_vouchers.created_at', '=', date('Y-m-d', strtotime(' -1 day')))
->get();
// $voucher->makeHidden(['id',
// 'user_id',
// 'client_id',
// 'voucher_list_id',
// 'comissao',
// 'transaction',
// 'price',
// 'voucherinfo',
// 'receipt',
// 'smsreceipt'
// ]);
return $voucher;
}
}