@extends('layouts.master')
    
@section('title', 'Request Import')
    
@section('style')
	<style>

	</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" 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('/requestreadfile') }}">
									{{ 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/Request_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

											@if(count($error_array) == 0 and count($data) != 0)
												<a href="{{ url('/requestimportfile', $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))
									<div style="overflow-x:auto">
										<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">user_fullname</th>
													<th style="vertical-align: middle; text-align: center">user_staff_no</th>
													<th style="vertical-align: middle; text-align: center">user_staff_id</th>
													<th style="vertical-align: middle; text-align: center">request_year</th>
													<th style="vertical-align: middle; text-align: center">request_type</th>
													<th style="vertical-align: middle; text-align: center">request_notify</th>
													<th style="vertical-align: middle; text-align: center">request_specify_type</th>
													<th style="vertical-align: middle; text-align: center">request_business_type</th>
													<th style="vertical-align: middle; text-align: center">request_sick_type</th>
													<th style="vertical-align: middle; text-align: center">request_from</th>
													<th style="vertical-align: middle; text-align: center">request_to</th>
													<th style="vertical-align: middle; text-align: center">request_total</th>
													<th style="vertical-align: middle; text-align: center">request_reason</th>
													<th style="vertical-align: middle; text-align: center">request_answer</th>
													<th style="vertical-align: middle; text-align: center">request_section</th>
													<th style="vertical-align: middle; text-align: center">request_position</th>
													<th style="vertical-align: middle; text-align: center">request_status</th>
													<th style="vertical-align: middle; text-align: center">request_detail</th>
												</tr>
											</thead>
											<tbody>
												@foreach($data as $key=>$new_data)
													<tr>
														<td>{{ ++$key  }}</td>
														<td>
															{{ $new_data->user_fullname }} <br>
															{{ $new_data->user_fullname_preview }}
														</td>
														<td>{{ $new_data->user_staff_no }}</td>
														<td>
															{{ $new_data->user_staff_id }} <br>
															{{ $new_data->user_staff_id_key }} <br>
															{{ $new_data->user_staff_id_preview }}
														</td>
														<td>{{ $new_data->request_year }}</td>
														<td>
															{{ $new_data->request_type }} <br>
															{{ $new_data->request_type_preview }}
														</td>
														<td>{{ $new_data->request_notify }}</td>
														<td>
															{{ $new_data->request_specify_type }} <br>
															{{ $new_data->request_specify_type_key }} <br>
															{{ $new_data->request_specify_type_preview }}
														</td>
														<td>
															{{ $new_data->request_business_type }} <br>
															{{ $new_data->request_business_type_key }} <br>
															{{ $new_data->request_business_type_preview }}
														</td>
														<td>{{ $new_data->request_sick_type }}</td>
														<td>{{ $new_data->request_from }}</td>
														<td>{{ $new_data->request_to }}</td>
														<td>{{ $new_data->request_total }}</td>
														<td>{{ $new_data->request_reason }}</td>
														<td>{{ $new_data->request_answer }}</td>
														<td>{{ $new_data->request_section }}</td>
														<td>{{ $new_data->request_position }}</td>
														<td>
															{{ $new_data->request_status }} <br>
															{{ $new_data->request_status_preview }}
														</td>
														<td>
															@php
																$request_detail = explode('///', $new_data->request_detail);
															
																foreach($request_detail as $key=>$new_detail){
																	$cut = explode(',,', $new_detail);
															
																	echo '#'.++$key.' Date: '.$cut[0].'-'.$cut[1].' ('.$cut[2].') ('.$cut[3].')';
																	echo '<br>';
																}
															@endphp
														</td>
													</tr>
												@endforeach
											</tbody>
										</table>
									</div>
								@endif

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

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




















	@include('layouts.footer')
@endsection