@if (!empty($workflow_documents))
@php
$sl=0;
@endphp
@foreach($workflow_documents as $key=> $document)
@php
$bg_color='';
$unread_user = App\WorkflowDocumentUser::where('workflow_document_id', '=', $document->id)
->where('user_id', Auth::user()->id)
->where('is_read', '0')
->where('status', 'Y')
->first();
if(isset($unread_user) && !empty($unread_user))
{
$bg_color="background-color: rgba(135, 243, 108, 0.57)";
}
$return_user_process = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->where('user_id', Auth::user()->id)->where('status', '=', 'R')->orderBy('id', 'desc')->first();
$user_process = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->where('user_id', Auth::user()->id)->orderBy('id', 'desc')->first();
if(isset($user_process)){
$parent_user_process = App\WorkflowDocumentProcess::where('id', '=', $user_process->parent_id)->first();
if(isset($parent_user_process) && !empty($parent_user_process) && $parent_user_process->status == 'R' && $user_process->status=='P')
{
$bg_color="background-color: peachpuff";
}
}
$userAsSupporter = App\WorkflowDocumentUser::where('workflow_document_id', '=', $document->id)->where('user_type','=','S')->where('status', '=', 'Y')->where('user_id', '=', Auth::user()->id)->first();
@endphp
@if(!empty($user_process))
@php
$sl++;
@endphp
| {{ $sl }} |
{{ $document->registration_number != '' ? $document->registration_number : $document->temporary_registration_number }} |
{{ $document->registration_date != '' ? date('d-m-Y', strtotime($document->registration_date)) : '' }} |
{{ $document->topic }} |
@if($document->status == 'Complete' || $document->status=='Approved')
@elseif($document->is_rejected =='1')
@elseif(isset($user_process))
@if($user_process->status=='R')
@elseif($user_process->status=='A')
@elseif($user_process->status=='SA')
@else
@endif
@else
@endif
|
@php
$senders = App\WorkflowDocumentSender::where('workflow_document_id', '=', $document->id)->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($senders)
@foreach($senders as $sender)
{{ $sender->contact_organization_name }}
@endforeach
@endif
|
@php
$reviewer = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->orderBy('id', 'desc')->first();
$user = App\User::join('role_user', 'users.id', '=', 'role_user.user_id')
->join('roles', 'role_user.role_id', '=', 'roles.id')
->where('users.id', '=', $reviewer->user_id)
->select('users.*', 'roles.name as role_name', 'roles.id as role_id', 'users.id as id')
->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
@endphp
{{ $reviewer_user_name }}
|
@php
$supporters = App\WorkflowDocumentUser::where('workflow_document_id', '=', $document->id)->where('user_type','=','S')->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($supporters)
@foreach($supporters as $key => $supporter)
@php
$user = App\User::join('role_user', 'users.id', '=', 'role_user.user_id')
->join('roles', 'role_user.role_id', '=', 'roles.id')
->where('users.id', '=', $supporter->user_id)
->select('users.*', 'roles.name as role_name', 'roles.id as role_id', 'users.id as id')
->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
@endphp
{{ $supporter_user_name }}
@endforeach
@endif
|
{{ $document->creator_name }} |
@if($document->is_workflow_free !=1)
@endif
|
@elseif($document->creator_id == Auth::user()->id || check_permissions(1) === true)
@php
$sl++;
@endphp
| {{ $sl }} |
{{ $document->registration_number != '' ? $document->registration_number : $document->temporary_registration_number }} |
{{ $document->registration_date != '' ? date('d-m-Y', strtotime($document->registration_date)) : '' }} |
{{ $document->topic }} |
@if($document->status == 'Complete' || $document->status=='Approved')
@elseif($document->is_rejected =='1')
@else
@endif
|
@php
$senders = App\WorkflowDocumentSender::where('workflow_document_id', '=', $document->id)->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($senders)
@foreach($senders as $sender)
{{ $sender->contact_organization_name }}
@endforeach
@endif
|
@php
$reviewer_user_name='';
$reviewer = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->orderBy('id', 'desc')->first();
if(isset($reviewer)){
$user = App\User::join('role_user', 'users.id', '=', 'role_user.user_id')
->join('roles', 'role_user.role_id', '=', 'roles.id')
->where('users.id', '=', $reviewer->user_id)
->select('users.*', 'roles.name as role_name', 'roles.id as role_id', 'users.id as id')
->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
}
@endphp
{{ $reviewer_user_name }}
|
@php
$supporters = App\WorkflowDocumentUser::where('workflow_document_id', '=', $document->id)->where('user_type','=','S')->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($supporters)
@foreach($supporters as $key => $supporter)
@php
$user = App\User::join('role_user', 'users.id', '=', 'role_user.user_id')
->join('roles', 'role_user.role_id', '=', 'roles.id')
->where('users.id', '=', $supporter->user_id)
->select('users.*', 'roles.name as role_name', 'roles.id as role_id', 'users.id as id')
->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
@endphp
{{ $supporter_user_name }}
@endforeach
@endif
|
{{ $document->creator_name }} |
|
@elseif(!empty($userAsSupporter))
@php
$sl++;
@endphp
| {{ $sl }} |
{{ $document->registration_number != '' ? $document->registration_number : $document->temporary_registration_number }} |
{{ $document->registration_date != '' ? date('d-m-Y', strtotime($document->registration_date)) : '' }} |
{{ $document->topic }} |
@if($document->status == 'Complete' || $document->status=='Approved')
@elseif($document->is_rejected =='1')
@else
@endif
|
@php
$senders = App\WorkflowDocumentSender::where('workflow_document_id', '=', $document->id)->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($senders)
@foreach($senders as $sender)
{{ $sender->contact_organization_name }}
@endforeach
@endif
|
@php
$reviewer = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->orderBy('id', 'desc')->first();
$user = App\User::join('role_user', 'users.id', '=', 'role_user.user_id')
->join('roles', 'role_user.role_id', '=', 'roles.id')
->where('users.id', '=', $reviewer->user_id)
->select('users.*', 'roles.name as role_name', 'roles.id as role_id', 'users.id as id')
->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$reviewer_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
@endphp
{{ $reviewer_user_name }}
|
@php
$supporters = App\WorkflowDocumentUser::where('workflow_document_id', '=', $document->id)->where('user_type','=','S')->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
@endphp
@if($supporters)
@foreach($supporters as $key => $supporter)
@php
$user = App\User::getUserDocument()->where('users.id', '=', $supporter->user_id)->first();
$user_department = App\Department::where('id',$user['department_id'])->first();
if(isset($user_department))
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).', '.dataTranslation($user_department->name).' Dep.)';
else
$supporter_user_name = $user['first_name'].' '.$user['last_name'].' - ('.dataTranslation($user['role_name']).') ';
@endphp
{{ $supporter_user_name }}
@endforeach
@endif
|
{{ $document->creator_name }} |
|
@endif
@endforeach
@else
| {{ __('No record found') }} |
@endif