@extends('layouts.master')
    
@section('title', 'Member Import')
    
@section('style')
	<style>
		.btn_status{
			display: inline-block;
			padding: .25em .4em;
			font-size: 75%;
			font-weight: 700;
			line-height: 1;
			color: #fff;
			text-align: center;
			white-space: nowrap;
			vertical-align: baseline;
			border-radius: .25rem;
		}
		
		.reject{
			background-color: rgba(var(--bs-red-rgb), var(--bs-bg-opacity)) !important;
		}
		.confirm{
			background-color: rgba(var(--bs-green-rgb), var(--bs-bg-opacity)) !important;
		}
		.pending{
			background-color: rgba(var(--bs-orange-rgb), var(--bs-bg-opacity)) !important;
		}
	</style>
@endsection
    
@section('script')
	<script>
		$('#file').change(function(){
			check_upload_xlsx('file');
		})
	</script>
@endsection
    


@section('content')
    
@include('layouts.header')
@include('layouts.header-sub')



<section class="wrapper bg-light">
	<div class="container-fluid py-14 py-md-16">
		<div class="row gx-lg-8 gx-xl-12">

			<div class="col-md-12">
				<h5 class="display-1 mb-3 font_menu" style="font-size: 30px">@yield('title')</h5>
				<p class="lead fs-lg pe-lg-15 pe-xxl-12"></p>
			</div>
        
			<div class="col-lg-12">
				<div class="blog single">
					<div class="card">
						<div class="card-body">
                        
							<form method="post" class="contact-form" enctype="multipart/form-data" action="{{ url('/memberreadfile') }}">
								{{ csrf_field() }}

								<div class="row">
									<div class="col-md-3">
										File Import : <br>
										<span style="color:red; font-size:15px; font-weight:normal">(.xlsx only)</span>
										<br>
										<div>
											<a href="{{ asset('/files/Template/Member_Import.xlsx') }}">sample file</a>
										</div>
									</div>
									<div class="col-md-9">
										<label class="btn btn-primary btn-sm" style="cursor:pointer" >
											Browse <input type="file" name="file" id="file" accept=".xlsx" style="display: none;" required>
										</label>
										<span id="show_file"></span>
									</div>
                                </div>
                                
								<hr>
 
                                <div class="col-12 text-center">
                                    <input type="submit" class="btn btn-aqua btn-sm rounded-pill" value="Preview">
									
                                    @if(!empty($data))
										
										@php $error_array = array() @endphp


										@foreach($data as $key=>$new_data)
											@if(MemberController::email_exists($new_data->user_email) != 0)
												@php $error_array[] = 'Email already registered' @endphp
											@endif
										@endforeach

										@foreach($data as $key => $new_data)
											@if(MemberController::get_user_role($new_data->user_role)== 0)
												@php $error_array[] = 'Please check recorded Role' @endphp
											@endif
										@endforeach

									
										@foreach($data as $key=>$new_data)
											@if(MemberController::get_school($new_data->user_school) == 0)

												@php $error_array[] = 'Please check recorded School/Division' @endphp
											@endif
										@endforeach

										@foreach($data as $key=>$new_data)
											@if(MemberController::get_user_member_role($new_data->user_member_role) == 0)

												@php $error_array[] = 'Please check recorded Role Type' @endphp
											@endif
										@endforeach

										@foreach($data as $key=>$new_data)
											@if( MemberController::get_user_member_type($new_data->user_member_type) == 0)

												@php $error_array[] = 'Please check recorded Member Type' @endphp
											@endif
										@endforeach

										@foreach($data as $key=>$new_data)
											@if(MemberController::check_dateformat($new_data->user_working) != '1')

												@php $error_array[] = 'Please check date format' @endphp
											@endif
										@endforeach
										

									
										


									
										@if(count($error_array) == 0 and count($data) != 0)
											<a href="{{ url('/memberimportfile', $name_file) }}" onclick="return confirm('Confirm Import ?');" id="btn_import">
												<input type="button" class="btn btn-green btn-sm rounded-pill" value="Import" >
											</a>
										@else
											<br><br>
											@php $error_array = array_unique($error_array) @endphp
											@foreach($error_array as $error)
												<li style="color: red">{{ $error }}</li>
											@endforeach
										@endif
                                    @endif
                                </div>
                            </form>
							
							<br>

                            @if(!empty($data))
							

								<table id="example" class="table table-hover table-bordered table-striped table-condensed">
									<thead class="thead-light">
                                        <tr>
											<th style="vertical-align: middle; text-align: center">No.</th>
											<th style="vertical-align: middle; text-align: center">Title</th>
											<th style="vertical-align: middle; text-align: center">Firstname</th>
											<th style="vertical-align: middle; text-align: center">Lastname</th>
											<th style="vertical-align: middle; text-align: center">IDNo</th>
											<th style="vertical-align: middle; text-align: center">Staff ID</th>
											<th style="vertical-align: middle; text-align: center">Barcode</th>
											<th style="vertical-align: middle; text-align: center">Email</th>
											<th style="vertical-align: middle; text-align: center">Position</th>
											<th style="vertical-align: middle; text-align: center">Role</th>
											<th style="vertical-align: middle; text-align: center">School/Division</th>
											<th style="vertical-align: middle; text-align: center">Role Type</th>
											<th style="vertical-align: middle; text-align: center">Member Type</th>
											<th style="vertical-align: middle; text-align: center">Date Working (YYYY-MM-DD)</th>
											<th style="vertical-align: middle; text-align: center">Status</th>
                                        </tr>
									</thead>
									<tbody>
                                        @foreach($data as $key=>$new_data)
											
											<tr>
												<td>{{ ++$key  }}</td>
												<td>{{ $new_data->user_title }}</td>
												<td>{{ $new_data->user_firstname }}</td>
												<td>{{ $new_data->user_lastname }}</td>
												<td>{{ $new_data->user_staff_no }}</td>
												<td>{{ $new_data->user_staff_id }}</td>
												<td>{{ $new_data->user_staff_barcode }}</td>
												<td>
													@if(MemberController::email_exists($new_data->user_email) != 0)
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_email }}
												</td>
												<td>{{ $new_data->user_position }}</td>
												<td>
													@if(MemberController::get_user_role($new_data->user_role) == 0)
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_role }}
												</td>

												<td>
													@if(MemberController::get_school($new_data->user_school) == 0)
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_school }}
												</td>
												<td>
													@if(MemberController::get_user_member_role($new_data->user_member_role) == 0)
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_member_role }}
												</td>
												<td>
													@if(MemberController::get_user_member_type($new_data->user_member_type) == 0)
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_member_type }}
												</td>
												<td>
													@if(MemberController::check_dateformat($new_data->user_working) != '1')
														<i class="uil uil-times-circle" style="color: red !important; font-size: 18px"></i>
													@else
														<i class="uil uil-check-circle" style="color: green !important; font-size: 18px"></i>
													@endif
													{{ $new_data->user_working }}
												</td>
												<td>{{ $new_data->user_status }}</td>
												
											</tr>
											
                                        @endforeach
                                    </tbody>
                                </table>

								
                            @endif

						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
</section>


@include('layouts.footer')
    
@endsection