@if (str_contains(url()->current(), '/send-file'))
@elseif(str_contains(url()->current(), '/send-letter')) @elseif(str_contains(url()->current(), '/send-summary')) @endif @csrf
Your Send Files ({{ $efiles->count() }})
@foreach ($efiles as $eaccess) @php $efile = DB::table('efileshares') ->where('doc_type', 2) ->where('id', $eaccess->draft_id) ->first(); @endphp @if (isset($efile)) @php $draftre = DB::table('draftshares') ->where('draft_id', $efile->id) ->where('fromuser', Auth::user()->id) ->orderBy('id', 'DESC') ->first(); @endphp @if (isset($draftre)) @php $getuname = DB::table('users') ->where('id', $draftre->touser) ->first(); $getusection = DB::table('departments') ->where('id', $getuname->department_id) ->first(); @endphp @endif @php $notifycheckSC = DB::table('draftremarks') ->where('draft_id', $efile->draft_id) ->where('job_title', 'SO') ->where('notify', 'Notify') ->get(); $getfwdSO = DB::table('users') ->where('jobtitle', 'AS') ->where('odep_id', Auth::user()->odep_id) ->first(); $getexistancefwdSO = DB::table('draftshares') ->where('draft_id', $efile->id) ->where('touser', $getfwdSO->id) ->first(); $getfwdDS = DB::table('users') ->where('jobtitle', 'Draftsman') ->where('odep_id', Auth::user()->odep_id) ->first(); $getexistancefwdDS = DB::table('draftshares') ->where('draft_id', $efile?->id ?? '') ->where('touser', $getfwdDS?->id ?? '') ->first(); $getfwdAS = DB::table('users') ->where('jobtitle', 'AS') ->where('odep_id', Auth::user()->odep_id) ->first(); $getexistancefwdAS = DB::table('draftshares') ->where('draft_id', $efile->id) ->where('touser', $getfwdAS->id) ->first(); $getfwdDraftsman = DB::table('users') ->where('jobtitle', 'Draftsman') ->where('odep_id', Auth::user()->odep_id) ->first(); $getexistanceDraftsman = DB::table('draftshares') ->where('draft_id', $efile?->id ?? '') ->where('touser', $getfwdDraftsman?->id ?? '') ->first(); $getfwdSecretary = DB::table('users') ->where('jobtitle', 'Draftsman') ->where('odep_id', Auth::user()->odep_id) ->first(); $getexistanceSecretary = DB::table('draftshares') ->where('draft_id', $efile?->id ?? '') ->where('touser', $getfwdSecretary?->id ?? '') ->first(); @endphp @if ($notifycheckSC->count() > 0 and Auth::user()->jobtitle == 'SC') @endif @endif @endforeach
Document No. Title Send to Receiving Date
@if (isset($efile->doc_no))

{{ $efile->doc_no }}

@endif
{{ $efile->subject }}
@if (isset($getuname, $draftre)) {{ $getuname->jobtitle }} @if (isset($getusection)) ({{ $getusection->name }}) @endif @endif {{ $efile->created_at }}
@csrf