@php
    use App\Http\Controllers\FacultyController;
@endphp
@extends('layouts.master')
@section('title', 'Import Faculty Member')

@section('style')
    <style></style>
@endsection

@section('script')
    <script>
        $('#file').change(function() {

            var fullPath = document.getElementById('file').value;
            if (fullPath) {
                var startIndex = (fullPath.indexOf('\\') >= 0 ? fullPath.lastIndexOf('\\') : fullPath.lastIndexOf(
                    '/'));
                var filename = fullPath.substring(startIndex);
                if (filename.indexOf('\\') === 0 || filename.indexOf('/') === 0) {
                    filename = filename.substring(1);
                }
            }

            $('#show_file').html(filename);
        })
    </script>
@endsection

@section('content')
    @include('layouts.header')
    @include('layouts.title')

    <section class="wrapper bg-light">
        <div class="container py-15 py-md-17">
            <div class="d-flex justify-content-between align-items-center mb-3">
                <div>
                    <span class="text-dark fs-30">Import Faculty Member</span>
                </div>
                <div>
                    {{-- <a href="{{ asset('/') }}" class="btn btn-lg btn-primary rounded-pill p-1 px-3"><i
                    class="uil uil-plus"></i>
                Add</a> --}}
                </div>
            </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('/facultyimport_readfile') }}">
                                {{ 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="{{ url('/facultytemplate') }}">
	                                                Download Template
											</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 = [];
                                        @endphp


                                        {{-- ========================================== --}}
                                        {{-- ตรวจ Error ของแต่ละแถวจาก excel_faculty --}}
                                        {{-- ========================================== --}}

                                        @foreach($data as $new_data)

                                            @if(!empty($new_data->errors))

                                                @foreach($new_data->errors as $error)

                                                    @php
                                                        $error_array[] = $error;
                                                    @endphp

                                                @endforeach

                                            @endif

                                        @endforeach


                                        {{-- ========================================== --}}
                                        {{-- ถ้าไม่มี Error แสดงปุ่ม Import --}}
                                        {{-- ========================================== --}}

                                        @if(count($error_array) == 0)

                                            <a href="{{ url('/facultyimport_importfile', $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 (isset($show))
                                <div class="table-responsive">
                                    <table class="table table-hover">
                                        <thead class="thead-ligth">
                                            <tr>
                                                <th style="vertical-align: middle; text-align: center">No.</th>
                                                <th style="vertical-align: middle; text-align: center">Staff ID</th>
                                                <th style="vertical-align: middle; text-align: center">Title</th>
                                                <th style="vertical-align: middle; text-align: center">First Name</th>
                                                <th style="vertical-align: middle; text-align: center">Last Name</th>
                                                <th style="vertical-align: middle; text-align: center">E-mail</th>
                                                <th style="vertical-align: middle; text-align: center">School</th>
                                                 <th style="vertical-align: middle; text-align: center">Program</th>
                                                <th style="vertical-align: middle; text-align: center">Position (Optional)</th>
                                                
                                            </tr>
                                        </thead>
                                        @if (!empty($data))
                                            @foreach($data as $key => $new_data)

                                                <tr>

                                                    <td align="center">
                                                        {{ $key + 1 }}
                                                    </td>


                                                    <td align="center">
                                                        {{ $new_data->faculty_code }}
                                                    </td>


                                                    <td align="center">
                                                        {{ $new_data->faculty_title }}
                                                    </td>


                                                    <td>
                                                        {{ $new_data->faculty_firstname }}
                                                    </td>


                                                    <td>
                                                        {{ $new_data->faculty_lastname }}
                                                    </td>


                                                    <td>
                                                        {{ $new_data->faculty_email }}
                                                    </td>


                                                    {{-- ========================================== --}}
                                                    {{-- School --}}
                                                    {{-- ========================================== --}}

                                                    <td align="center">

                                                        @if(isset($new_data->errors['school']))

                                                            <span
                                                                style="color:red;"
                                                                title="{{ $new_data->errors['school'] }}">

                                                                {{ $new_data->faculty_school }}

                                                            </span>

                                                        @else

                                                            {{ $new_data->faculty_school }}

                                                        @endif

                                                    </td>


                                                    {{-- ========================================== --}}
                                                    {{-- Program --}}
                                                    {{-- ========================================== --}}

                                                    <td align="center">

                                                        @if(isset($new_data->errors['program']))

                                                            <span
                                                                style="color:red;"
                                                                title="{{ $new_data->errors['program'] }}">

                                                                {{ $new_data->faculty_program }}

                                                            </span>

                                                        @else

                                                            @if(!empty($new_data->faculty_program_names))

                                                                @foreach($new_data->faculty_program_names as $programName)

                                                                    <span class="badge bg-soft-primary text-primary rounded-pill">
                                                                        {{ $programName }}
                                                                    </span>

                                                                @endforeach

                                                            @else

                                                                -

                                                            @endif

                                                        @endif

                                                    </td>


                                                    {{-- ========================================== --}}
                                                    {{-- Position --}}
                                                    {{-- ========================================== --}}

                                                    <td align="center">
                                                        @if(isset($new_data->errors['position']))
                                                            <span class="text-danger"
                                                                  title="{{ $new_data->errors['position'] }}">
                                                                {{ $new_data->faculty_position }}
                                                            </span>
                                                        @else
                                                            {{ $new_data->faculty_position ?: '-' }}
                                                        @endif
                                                    </td>

                                                </tr>

                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    @include('layouts.footer')
@endsection