@if(str_contains(url()->current(), '/send-file'))

Your Received Files

@foreach ($efiles as $eaccess) @if(str_contains(url()->current(), '/send-file')) @php $efile = DB::table('efileshares')->where('doc_type' , 1)->where('id', $eaccess->draft_id)->first(); @endphp @elseif(str_contains(url()->current(), '/send-letter')) @php $efile = DB::table('efileshares')->where('doc_type' , 2)->where('id', $eaccess->draft_id)->where('sharefrom', Auth::user()->id)->first(); @endphp @elseif(str_contains(url()->current(), '/send-summary')) @php $efile = DB::table('efileshares')->where('doc_type' , 3)->where('id', $eaccess->draft_id)->first(); @endphp @endif @if(isset($efile)) @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 @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(Auth::user()->jobtitle == 'SO') @endif

@csrf

@php $getefile = DB::table('efileshares')->where('id', $getfileshare->id)->first(); @endphp @php $draftremarks = DB::table('draftremarks')->where('draft_id' , $getefile->draft_id)->get(); @endphp

Date: {{ \Carbon\Carbon::parse($getefile->created_at)->format('j F, Y') }}

Title: {{ $getefile->subject }}

@php $getsection = DB::table('odepartments')->where('id', $getefile->department_id)->first(); @endphp

From Which Department Received: {{ $getsection->name }}

Action Taken:

Notings

@php $getnottingsname = DB::table('users')->where('id', $getefile->sharefrom)->first(); @endphp @if(isset($getnottingsname->name)) @if(isset($getefile->nottings))

{{$getnottingsname->name}} ({{$getnottingsname->jobtitle}}): {!!$getefile->nottings!!}

@endif @endif

@foreach ($draftremarks as $draftremark) @php $getname = DB::table('users')->where('id', $draftremark->user_id)->first(); @endphp @if(isset($draftremark->scale_id)) @if($draftremark->touser == Auth::user()->id)

@if(isset($draftremark->remark)) @if(isset($getname->name))

{{$getname->name}} ({{$draftremark->job_title}}): {{$draftremark->remark}}

@endif @endif @if(isset($draftremark->notify)) @if(isset($getname->name))

{{$getname->name}} ({{$draftremark->job_title}}): {{$draftremark->notify}}

@endif @endif

@elseif(Auth::user()->scale_level <= $draftremark->scale_id )

@if(isset($draftremark->remark)) @if(isset($getname->name))

{{$getname->name}} ({{$draftremark->job_title}}): {{$draftremark->remark}}

@endif @endif @if(isset($draftremark->notify)) @if(isset($getname->name))

{{$getname->name}} ({{$draftremark->job_title}}): {{$draftremark->notify}}

@endif @endif

@endif @endif @endforeach @if(Auth::user()->jobtitle == 'Secretary')

Notify

@endif @php $notifycheck = DB::table('draftremarks')->where('draft_id' , $getefile->draft_id)->where('job_title' , "Secretary")->where('notify' , "Notify")->get(); @endphp @if($notifycheck->count()>0 AND Auth::user()->jobtitle == 'Draftsman')

Notify

@endif @php $notifycheckAS = DB::table('draftremarks')->where('draft_id' , $getefile->draft_id)->where('job_title' , "Draftsman")->where('notify' , "Notify")->get(); $getSecretary = DB::table('users')->where('jobtitle', 'Draftsman')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceSecretary = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getSecretary->id)->first(); @endphp @if($notifycheckAS->count()>0 AND Auth::user()->jobtitle == 'AS')

Notify

@elseif(isset($getexistanceSecretary) AND Auth::user()->jobtitle == 'AS')

Notify

@endif @php $notifycheckDS = DB::table('draftremarks')->where('draft_id' , $getefile->draft_id)->where('job_title' , "AS")->where('notify' , "Notify")->get(); $getDraftsman = DB::table('users')->where('jobtitle', 'Draftsman')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceDraftsman = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getDraftsman->id)->first(); $getSecretary = DB::table('users')->where('jobtitle', 'Draftsman')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceSecretary = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getSecretary->id)->first(); @endphp @if($notifycheckDS->count()>0 AND Auth::user()->jobtitle == 'DS')

Notify

@elseif(isset($getexistanceDraftsman) AND Auth::user()->jobtitle == 'DS')

Notify

@elseif(isset($getexistanceSecretary) AND Auth::user()->jobtitle == 'DS')

Notify

@endif @php $notifycheckSO = DB::table('draftremarks')->where('draft_id' , $getefile->draft_id)->where('job_title' , "DS")->where('notify' , "Notify")->get(); $getAS = DB::table('users')->where('jobtitle', 'AS')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceAS = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getAS->id)->first(); $getDraftsman = DB::table('users')->where('jobtitle', 'Draftsman')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceDraftsman = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getDraftsman->id)->first(); $getSecretary = DB::table('users')->where('jobtitle', 'Draftsman')->where('odep_id', Auth::user()->odep_id)->first(); $getexistanceSecretary = DB::table('draftshares')->where('draft_id', $getefile->id)->where('touser', $getSecretary->id)->first(); @endphp @if($notifycheckSO->count()>0 AND Auth::user()->jobtitle == 'SO')

Notify

@elseif(isset($getexistanceAS) AND Auth::user()->jobtitle == 'SO')

Notify

@elseif(isset($getexistanceDraftsman) AND Auth::user()->jobtitle == 'SO')

Notify

@elseif(isset($getexistanceSecretary) AND Auth::user()->jobtitle == 'SO')

Notify

@endif

Add noting

@php $quickreplies = DB::table('quickreplies')->get(); @endphp

@foreach ($quickreplies as $quickreply) {{ $quickreply->name }} @endforeach

Assigned Section:

Member to share

@php $getefile = DB::table('efileshares')->where('id', $getfileshare->id)->first(); @endphp

@endif @endforeach

Document No.	Title	Status	Receiving Register Created by	Receiving Date
@if(isset($efile->doc_no)) {{ $efile->doc_no }} @endif	{{ $efile->subject }}	@if(isset($getuname, $draftre)) {{$getuname->name}} ({{$getuname->jobtitle}}) @endif	@php $getfileshare = DB::table('efileshares')->where('id', $efile->id)->first(); $getname = DB::table('users')->where('id', $efile->sharefrom)->first(); $getsection = DB::table('departments')->where('id', $getname->department_id)->first(); @endphp {{ $getname->name }} ({{$getname->jobtitle}}) - @if(isset($getsection)) {{$getsection->name}} @endif	{{ $efile->created_at }}		@csrf

Your Received Files

{{ $efile->subject }}