���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /home/zhaagvlk/web.zhaap.com/app__1b5d5ff/Exports/PaymentExport.php
���ѧ٧ѧ�
<?php namespace App\Exports; use App\Models\Payment; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\WithHeadings; class PaymentExport implements FromCollection, WithHeadings { protected $date; function __construct($date) { $this->date = $date; } /** * @return \Illuminate\Support\Collection */ public function collection() { $data = []; if(\Auth::user()->type =='company') { $data = Payment::where('created_by' , \Auth::user()->id)->get(); } else{ $data = Payment::get(); } // $data = Payment::where('created_by' , \Auth::user()->id); if($this->date!=null && $this->date!=0) { if (str_contains($this->date, ' to ')) { $date_range = explode(' to ', $this->date); $data->whereBetween('date', $date_range); }elseif(!empty($this->date)){ $data->where('date', $this->date); } } // $data = $data->get(); if (!empty($data)) { foreach ($data as $k => $Payment) { // dd($Payment); $account = Payment::accounts($Payment->account_id); $vendor = Payment::vendors($Payment->vender_id); $category = Payment::categories($Payment->category_id); unset($Payment->created_by, $Payment->updated_at, $Payment->created_at, $Payment->payment_method, $Payment->add_receipt); $data[$k]["account_id"] = $account; $data[$k]["vender_id"] = $vendor; $data[$k]["category_id"] = $category; } } return $data; } public function headings(): array { return [ "Payment Id", "Date", "Amount", "Account", "Vendor", "Description", "Category", "Reference", ]; } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.34 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�