<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;

class WaterExport implements FromCollection
{
    /**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        $water = \App\Water::query()
            ->join('imali_accounts', 'imali_accounts.user_id', '=', 'waters.user_id')
            ->join('users', 'users.id', '=', 'waters.user_id')
            ->whereDate('waters.created_at', '=', date('Y-m-d', strtotime(' -1 day')))
            ->select('reqMsgID as transaction', 'clientNumber', 'entityNumber', 'clientName',
                'account_number', 'name as first_name', 'last_name', 'purchaseValue', 'TransactionCost', 'waters.created_at as data')
            ->get();

        return $water;

    }
}