edms/resources/views/admin/documents/index.blade.php

@extends('admin.layouts.master')

@section('pageTitle', 'Manage Documents')
@section('content')

		
		<div class="page-header">
			<h1 class="page-title">Manage Documents</h1>
			<ol class="breadcrumb">
				<li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
				<li class="breadcrumb-item active">Manage Documents</li>
			</ol>
		</div>
		

		
		<div class="page-content">
			<div class="row">
					<div class="col-md-12">
						<form action="{{route('present-documents')}}" method="get">
							<div class="form-inline float-right">
								<input type="search" class="form-control" name="search" value="{{$search ?? ''}}">
								<button type="submit" class="btn btn-primary"><i class="fa fa-search" aria-hidden="true"></i></button>
							</div>
						</form>
					</div>
				</div>
			<div class="panel">
				<div class="panel-body">
					<table class="table table-hover dataTable table-striped w-full" data-plugin="dataTablex">
						<thead>
							<tr>
								<th>#</th>
								<th>{{ __('REG. Number') }}</th>
								<th>{{ __('Registration Date') }}</th>
								<th>{{ __('Topic') }}</th>
								<th>{{ __('Workflow Type') }}</th>
								<th>{{ __('Status') }}</th>
								<th>{{ __('Sender') }} / {{ __('Recipient') }}</th>
								<th>{{ __('Reviewer User') }}</th>
								<th>{{ __('Supporter User') }}</th>
								<th>{{ __('Creator') }}</th>
								<th>{{ __('Action') }}</th>
							</tr>
						</thead>
						<tbody>
							@if (!empty($workflow_documents))
								@php
									$sl=0;
								@endphp
								@foreach($workflow_documents as $key=> $document)
									@php	
										$bg_color='';
									@endphp
										<tr style="{{ $bg_color }}">
											@php
												$sl++;
												$workflow_type = $workflow_types->where('id', $document->workflow_type_id)->first();
											@endphp
											<td><b>{{ $sl }}</b></td>
											<td><b>{{ $document->registration_number != '' ? $document->registration_number :$document->temporary_registration_number }}</b></td>
											<td><b>{{ $document->registration_date != '' ? date('d/m/Y', strtotime($document->registration_date)) : '' }}</b></td>
											<td><b>{{ $document->topic }}</b></td>
											<td><b>{{ dataTranslation($workflow_type->name) }}</b></td>
											<td>
											@if($document->status=='Complete')
												<button type="button" class="btn btn-success"><i class="icon wb-stats-bars" aria-hidden="true"></i> <b>{{ __('Complete') }}</b></button>
											@else
												<button type="button" class="btn btn-warning"><i class="icon wb-stats-bars" aria-hidden="true"></i> <b>{{ __('Pending') }}</b></button>
											@endif
											</td>
											@php
												$senders = App\WorkflowDocumentSender::where('workflow_document_id', '=', $document->id)->where('status', '=', 'Y')->orderBy('id', 'asc')->get();
											@endphp
											<td>
												@if($senders)
													@foreach($senders as $sender)
														<b>{{ $sender->contact_organization_name }}</b><br>
													@endforeach
												@endif
											</td>
											<td>
												@php
													$reviewer = App\WorkflowDocumentProcess::where('workflow_document_id', '=', $document->id)->orderBy('id', 'desc')->first();
													if($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();
															//print_r($user);exit;
														$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']).') ';
													}
													else{
														$reviewer_user_name = '';
													}
												@endphp
												<b>{{ $reviewer_user_name }}</b>
											</td>
											<td>
												@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();
																//print_r($user);exit;
															$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
														<b>{{ $supporter_user_name }}</b>
													@endforeach
												@endif
											</td>
											<td><b>{{ $document->creator_name }}</b></td>
											<td>
												<a class="btn btn-sm btn-icon btn-default btn-outline btn-round" onclick="confirm('Are you sure you want to delete this record?') ? '' : event.preventDefault();" href="{{ route('delete-document', base64_encode($document->id)) }}" data-toggle="tooltip" data-original-title="Delete"><i class="icon wb-trash" aria-hidden="true"></i></a>
											</td>
										</tr>
								@endforeach
							@else
								<tr>
									<td colspan="100%" class="text-center">No record found</td>
								</tr>
							@endif
						</tbody>
					</table>
							<span class="pull-right" style="margin:3px;">{!! $workflow_documents->links() !!}</span> 
				</div>
			</div>
		</div>
		
@endsection