<?php

namespace App\Exports;

use App\Models\Invoice;
use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Illuminate\Support\Arr;
use Auth;

class InvoiceReportExport implements FromView
{
    protected $date;

    function __construct($date) {
            $this->date = $date;
    }

    /**
    * @return \Illuminate\Support\Collection
    */
    public function view(): View
    {

        
        if (!empty($this->date)) 
        {
            $cust_ids = Arr::flatten(Auth::user()->customer->toArray()); 
            $query = Invoice::query();
            $query->whereIn('customer_id',$cust_ids)->where('type',1);
            $brokenDate = explode(' - ', $this->date);
            $startDate = $brokenDate[0];
            $endDate = $brokenDate[1];
            $date = $this->date;
            if($startDate == $endDate){
                $invoices =  $query->whereDate('created_at', $startDate)->paginate(10);
            }
            else{
                $invoices =  $query->whereDate('created_at','>=', $startDate)->whereDate('created_at','<=',$endDate)->get();
            }

        // foreach($invoices as $invoice)
        // {
        //     dd($invoice->lineItem);
        // }
       

        return view('report.export_report', [
            'invoice' => $invoices
        ]);
          }
    }
}