@foreach($leaves as $leave) @php $r_name = ''; if($leave->relieve != '') { $employee = Illuminate\Support\Facades\DB::table('user_personal') ->where('username', $leave->relieve)->first(); $r_name = $employee->name; } $status = ''; $class= ''; if($leave->status == 0) { $status = 'Pending'; $class= 'grey'; } elseif($leave->status == 1) { $status = 'Approved'; $class= 'green'; } elseif($leave->status == 2) { $status = 'Rejected'; $class= 'red'; } elseif($leave->status == 3) { $status = 'Recommended'; $class= 'blue'; } elseif($leave->status == 4) { $status = 'Cancelled'; $class= 'yellow'; } elseif($leave->status == 5) { $status = 'Cancellation Pending'; $class= 'orange'; } $leaveDays = Illuminate\Support\Facades\DB::table('leave_days')->where('leave_id', $leave->id)->first(); @endphp @endforeach
Type Date Days Reason Cancellation Reason Reject Reason Status Action
{{ $leave->type }} {{ date('d-m-Y', strtotime($leave->start_date)) }} {{ $leave->no_days }} {{ $leave->reason }} {{ isset($leaveDays) ? $leaveDays->cancellation_reason :''}} {{ isset($leaveDays) ? $leaveDays->reject_reason :''}} {{ $status }}