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