File manager - Edit - /var/www/payraty/hris/app/Exports/LeaveExport.php
Back
<?php namespace App\Exports; use App\Models\Employee; use App\Models\Leave; use App\Models\LeaveType; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\WithHeadings; class LeaveExport implements FromCollection, WithHeadings { /** * @return \Illuminate\Support\Collection */ public function collection() { $user = \Auth::user(); $data= Leave::where('created_by', \Auth::user()->creatorId())->get(); if (\Auth::user()->type == 'employee') { $employee = Employee::where('user_id', '=', $user->id)->first(); $data= Leave::where('employee_id', '=', $employee->id)->where('created_by', \Auth::user()->creatorId())->get(); foreach($data as $k=>$leave) { $data[$k]["employee_id"]=Employee::employee_name($leave->employee_id); $data[$k]["leave_type_id"]= !empty(\Auth::user()->getLeaveType($leave->leave_type_id))?\Auth::user()->getLeaveType($leave->leave_type_id)->title:''; $data[$k]["created_by"]=Employee::login_user($leave->created_by); unset($leave->created_at,$leave->updated_at); } } else{ $data= Leave::where('created_by', \Auth::user()->creatorId())->get(); foreach($data as $k=>$leave) { $data[$k]["employee_id"]=Employee::employee_name($leave->employee_id); $data[$k]["leave_type_id"]= !empty(\Auth::user()->getLeaveType($leave->leave_type_id))?\Auth::user()->getLeaveType($leave->leave_type_id)->title:''; $data[$k]["created_by"]=Employee::login_user($leave->created_by); unset($leave->created_at,$leave->updated_at); } return $data; } return $data; } public function headings(): array { return [ "ID", "Employee Name", "Leave Type ", "Applied On", "Start Date", "End Date", "Total Leaves Days", "Leave Reason", "Remark", "Status", "Created By" ]; } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 0.41 |
proxy
|
phpinfo
|
Settings