@php $authStatusClass = \App\ConstValue::authStatusClass; if(!isset($approvalLogs)){ $approvalLogs = DB::table('gnr_approval_users_log') ->selectRaw('gnr_approval_steps.*, gnr_approval_users_log.*, ifnull(emp_id, users.name) as emp_id, ifnull(emp_name_english, users.name) as emp_name_english') ->join('gnr_approval_steps', 'gnr_approval_users_log.stepId', 'gnr_approval_steps.id') ->leftJoin('users', 'gnr_approval_users_log.authorizeBy', 'users.id') ->leftJoin('hr_emp_general_info', 'users.emp_id_fk', 'hr_emp_general_info.id') ->where([['entityUid', $entityUid], ['eventId', $approvalEventId]]) ->orderBy('arrivalTime', 'asc') ->orderBy('gnr_approval_users_log.id', 'asc') ->get(); } @endphp @foreach ($approvalLogs as $approvalLog) @if ($approvalLog->departureTime) @else @endif @endforeach

Approval Log/History
SL	Step	Step Name	Employee ID	Employee Name	Arr. Time	Dep. Time	Auth. Date	Remarks	Status
{{ $loop->iteration }}	{{ $approvalLog->stepNo }}	{{ $approvalLog->name }}	{{ $approvalLog->emp_id }}	{{ $approvalLog->emp_name_english }}	{{ date('d-m-Y h:i A', strtotime($approvalLog->arrivalTime)) }}	@if ($approvalLog->departureTime) {{ date('d-m-Y h:i A', strtotime($approvalLog->departureTime)) }} @else N/A @endif	@if ($approvalLog->authorizeDate) {{ date('d-m-Y h:i A', strtotime($approvalLog->authorizeDate)) }} @else N/A @endif	@php $num_words = 13; $words = array(); $words = explode(" ", $approvalLog->remarks); @endphp @if(count($words) > $num_words) {{ implode(' ', array_slice($words, 0, $num_words)) }} More {{ implode(' ', array_slice($words, $num_words, count($words))) }} Less @else {{$approvalLog->remarks}} @endif	{{ strtoupper($approvalLog->authStatus) }}	{{ strtoupper('Awaiting') }}