<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;

class CredelecExport implements FromCollection
{
    /**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        $credelec = \App\Credelec::query()
            ->join('imali_accounts', 'imali_accounts.user_id', '=', 'credelecs.user_id')
            ->join('users', 'users.id', '=', 'credelecs.user_id')
            ->whereDate('credelecs.created_at', '=', date('Y-m-d', strtotime(' -1 day')))
            ->select('reqMsgID as transaction', 'contador', 'amount', 'StandardTokenTx_token as codigoRecarga',
                'account_number', 'name as first_name', 'last_name', 'credelecs.created_at as data')
            ->get();

        return $credelec;
    }
}