File manager - Edit - /var/www/payraty/accounting_main/app/Exports/InvoiceExport.php
Back
<?php namespace App\Exports; use App\Models\Customer; use App\Models\Invoice; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\WithHeadings; class InvoiceExport implements FromCollection, WithHeadings { /** * @return \Illuminate\Support\Collection */ public function collection() { $data = []; // $data = Invoice::where('created_by' , \Auth::user()->id)->get(); if (!\Auth::guard('customer')->check()) { $data = Invoice::where('created_by', \Auth::user()->id)->get(); } else { $data = Invoice::where('customer_id', '=', \Auth::guard('customer')->check())->where('status', '!=', '0')->get(); } if (!empty($data)) { foreach ($data as $k => $Invoice) { $customer = Invoice::customers($Invoice->customer_id); $category = Invoice::Invoicecategory($Invoice->category_id); if($Invoice->status == 0) { $status = 'Draft'; } elseif($Invoice->status == 1) { $status = 'Sent'; } elseif($Invoice->status == 2) { $status = 'Unpaid'; } elseif($Invoice->status == 3) { $status = 'Partialy Paid'; } elseif($Invoice->status == 4) { $status = 'Paid'; } unset($Invoice->discount_apply,$Invoice->shipping_display,$Invoice->id,$Invoice->created_by, $Invoice->updated_at, $Invoice->created_at); if(!\Auth::guard('customer')->check()) { $data[$k]["invoice_id"] = \Auth::user()->invoiceNumberFormat($Invoice->invoice_id); } else{ $data[$k]["invoice_id"] = Customer::invoiceNumberFormat($Invoice->invoice_id); } $data[$k]["customer_id"] = $customer; $data[$k]["category_id"] = $category; $data[$k]["status"] = $status; } } return $data; } public function headings(): array { return [ "Invoice Id", "Customer Name", "Issue Date", "Due Date", "Send Date", "Category_name", "Ref number", "status", ]; } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 1.34 |
proxy
|
phpinfo
|
Settings