<?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 InvoiceExport implements FromView
{
    protected $TYPE;

    function __construct($TYPE) {
            $this->TYPE = $TYPE;
    }
    /**
    * @return \Illuminate\Support\Collection
    */
    public function view(): View
    {
        $cust_ids = Arr::flatten(Auth::user()->customer->toArray()); 
         $invoice = Invoice::whereIn('customer_id',$cust_ids)->where('type',$this->TYPE)->get();
         //->leftjoin('line_items as li','li.invoice_id','=','invoices.id')->select('invoices.*','li.price','li.product_id','li.qty')->where(['li.posted_by'=>auth()->user()->id])->get();

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