@php
$getefile = DB::table('efileshares')
->where('id', $getfileshare->id)
->first();
@endphp
@php
$draftremarks = DB::table('draftremarks')
->where('draft_id', $getefile->draft_id)
->get();
@endphp
@php
$getname = DB::table('users')
->where('id', $efile->sharefrom)
->first();
$getsection = DB::table('departments')
->where('id', $getname->department_id)
->first();
@endphp
@php
$draftre = DB::table('draftremarks')
->where('draft_id', $efile->draft_id)
->orderBy('id', 'DESC')
->first();
@endphp
@if (isset($draftre->user_id))
@php
$getuname = DB::table('users')
->where('id', $draftre->user_id)
->first();
@endphp
@endif
@if (isset($getuname, $draftre))
{{ $getuname->name }}
({{ $getuname->jobtitle }})
@endif
@php
$getefile = DB::table('efileshares')
->where('id', $getfileshare->id)
->first();
@endphp