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