@php
    use App\Http\Controllers\StudentController;
    use Carbon\Carbon;

@endphp
@extends('layouts.master')
@section('title', 'Import Student')

@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')
    {{-- <section class="video-wrapper bg-overlay bg-overlay-gradient px-12 mt-0 min-vh-60 bg-cover bg-image"
        data-image-src="{{ asset('/bg/bg_01_new.png') }}"
        style="background-image: url({{ asset('/bg/bg_01_new.png') }}); background-size: 100%; background-position: center;">
        <div class="video-content">
            <div class="container text-center">
                <div class="row">
                    <div class="col-lg-8 col-xl-6 text-center text-white mx-auto">
                        <h1 class="display-1 fs-54 text-white mb-5"><span class="rotator-zoom">Import Student</span></h1>

                    </div>
                </div>
            </div>
        </div>
    </section> --}}

    @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 Student</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('/studentimport_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="{{ route('student.template') }}">sample
                                                file</a>
                                            {{-- <a href="{{ asset('/importexcel/studentlist/Student_ImportV8.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 (StudentController::check_type(trim($new_data->student_typeofdebtor)) == 0)
                                                @php $error_array[] = 'Check the name of Type.' @endphp
                                            @endif
                                            @if (StudentController::check_curriculum(trim($new_data->student_curriculum)) == 0)
                                                @php $error_array[] = 'Check the name of curriculum.' @endphp
                                            @endif
                                            @if (StudentController::check_schools(trim($new_data->student_school)) == 0)
                                                @php $error_array[] = 'Check the name of School.' @endphp
                                            @endif
                                            @if (StudentController::check_nationality(trim($new_data->student_nationality)) == 0)
                                                @php $error_array[] = 'Check the name of Nationality.' @endphp
                                            @endif
                                            @if (StudentController::check_advisor(trim($new_data->student_advisor)) == 0)
                                                @php $error_array[] = 'Check the name of Advisor.' @endphp
                                            @endif
                                            @if (StudentController::check_academicstatus(trim($new_data->student_academic_status)) == 0)
                                                @php $error_array[] = 'Check the name of Academicstatus.' @endphp
                                            @endif
                                            @if (StudentController::check_start_year(trim($new_data->student_scholarshipstartdate)) == 0)
                                                @php $error_array[] = 'Check the Year.' @endphp
                                            @endif
                                            @if (StudentController::check_end_year(trim($new_data->student_scholarshipenddate)) == 0)
                                                @php $error_array[] = 'Check the Year.' @endphp
                                            @endif
                                            @if (StudentController::check_scholarshipprogram(trim($new_data->student_scholarshipprogram),
                                                    $new_data->student_typeofdebtor) == 0)
                                                @php $error_array[] = 'Check the name of Scholarship Program.' @endphp
                                            @endif
                                            @php
                                                $academic_status = trim($new_data->student_academic_status);
                                                $enddate_siit = trim($new_data->student_enddateofstudentstatussiit);
                                                $enddate_tu = trim($new_data->student_enddateofstudentstatus);
                                                $requireEndDate = in_array($academic_status, [
                                                    'No Registration',
                                                    'Resign',
                                                    'Death',
                                                ]);
                                            @endphp

                                            {{-- SIIT --}}
                                            @if ($requireEndDate && !preg_match('/^\d{4}-\d{2}-\d{2}$/', $enddate_siit))
                                                @php $error_array[] = 'Check the date of End Date of Student Status (Exec. SIIT).' @endphp
                                            @endif

                                            {{-- TU --}}
                                            @if ($requireEndDate && !preg_match('/^\d{4}-\d{2}-\d{2}$/', $enddate_tu))
                                                @php $error_array[] = 'Check the date of End Date of Student Status (TU).' @endphp
                                            @endif
                                            @if (!is_numeric($new_data->student_theoutstandingbalance))
                                                @php $error_array[] = 'Outstanding Balance must be a number.' @endphp
                                            @endif
                                            @php
                                                $status = trim($new_data->student_enddebtorstatus);
                                            @endphp

                                            @if (!empty($status) && StudentController::check_end_debtor_status($status) == 0)
                                                @php $error_array[] = 'Check the name of End Debtor Status.' @endphp
                                            @endif
                                        @endforeach
                                        @if (count($error_array) == 0)
                                            <a href="{{ url('/studentimport_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">Student ID</th>
                                                <th style="vertical-align: middle; text-align: center">Name</th>
                                                <th style="vertical-align: middle; text-align: center">Nationality</th>
                                                <th style="vertical-align: middle; text-align: center">Degree</th>
                                                <th style="vertical-align: middle; text-align: center">Curriculum</th>
                                                <th style="vertical-align: middle; text-align: center">School</th>
                                                <th style="vertical-align: middle; text-align: center">Scholarship Start
                                                    Date</th>
                                                <th style="vertical-align: middle; text-align: center">Start Semester</th>
                                                <th style="vertical-align: middle; text-align: center">Scholarship End
                                                    Date</th>
                                                <th style="vertical-align: middle; text-align: center">End Semester</th>
                                                <th style="vertical-align: middle; text-align: center">Title</th>
                                                <th style="vertical-align: middle; text-align: center">Advisor</th>
                                                <th style="vertical-align: middle; text-align: center">Academic Status</th>
                                                <th style="vertical-align: middle; text-align: center">End Date of Student
                                                    Status (Exec. SIIT)</th>
                                                <th style="vertical-align: middle; text-align: center">End Date of Student
                                                    Status (TU)</th>
                                                <th style="vertical-align: middle; text-align: center">Type of Debtor</th>
                                                <th style="vertical-align: middle; text-align: center">Scholarship Program
                                                </th>
                                                <th style="vertical-align: middle; text-align: center">Original Scholarship
                                                    & Loan Agreement No.</th>
                                                <th style="vertical-align: middle; text-align: center">Original Scholarship
                                                    & Loan Agreement Date</th>
                                                <th style="vertical-align: middle; text-align: center">Installment Agreement
                                                    No.</th>
                                                <th style="vertical-align: middle; text-align: center">Installment Agreement
                                                    Date</th>
                                                <th style="vertical-align: middle; text-align: center">Guarantor First Name
                                                </th>
                                                <th style="vertical-align: middle; text-align: center">Guarantor Last Name
                                                </th>
                                                <th style="vertical-align: middle; text-align: center">Guarantor E-mail</th>
                                                <th style="vertical-align: middle; text-align: center">Debt Status</th>
                                                <th style="vertical-align: middle; text-align: center">End Debtor Status
                                                </th>
                                                <th style="vertical-align: middle; text-align: center">Exec No.</th>
                                                <th style="vertical-align: middle; text-align: center">Exec Date</th>
                                                <th style="vertical-align: middle; text-align: center">The Outstanding
                                                    Balance (THB)</th>
                                                <th style="vertical-align: middle; text-align: center">Due Date of the
                                                    Outstanding Balance Payment</th>
                                                <th style="vertical-align: middle; text-align: center">Remark</th>
                                            </tr>
                                        </thead>
                                        @if (!empty($data))
                                            @foreach ($data as $key => $new_data)
                                                <tr>
                                                    <td align="center">{{ ++$key }}</td>
                                                    <td align="center">{{ $new_data->student_code }}</td>
                                                    <td>{{ $new_data->student_firstname }}
                                                        {{ $new_data->student_lastname }}</td>
                                                    <td align="center">
                                                        @if (StudentController::check_nationality(trim($new_data->student_nationality)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_nationality }}</span>
                                                        @else
                                                            {{ $new_data->student_nationality }}
                                                        @endif
                                                    </td>
                                                    <td>{{ $new_data->student_degree }}</td>
                                                    <td align="center">
                                                        @if (StudentController::check_curriculum(trim($new_data->student_curriculum)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_curriculum }}</span>
                                                        @else
                                                            {{ $new_data->student_curriculum }}
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if (StudentController::check_schools(trim($new_data->student_school)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_school }}</span>
                                                        @else
                                                            {{ $new_data->student_school }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (StudentController::check_start_year(trim($new_data->student_scholarshipstartdate)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_scholarshipstartdate }}</span>
                                                        @else
                                                            {{ $new_data->student_scholarshipstartdate }}
                                                        @endif
                                                    </td>
                                                    <td align="center">{{ $new_data->student_start_semester }}</td>
                                                    <td align="center">
                                                        @if (StudentController::check_end_year(trim($new_data->student_scholarshipenddate)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_scholarshipenddate }}</span>
                                                        @else
                                                            {{ $new_data->student_scholarshipenddate }}
                                                        @endif
                                                    </td>
                                                    <td align="center">{{ $new_data->student_end_semester }}</td>
                                                    <td align="center">
                                                        @if(empty($new_data->student_title))
                                                            -
                                                        @else
                                                        {{ $new_data->student_title }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (StudentController::check_advisor(trim($new_data->student_advisor)) == 0)
                                                            <span style="color: red">
                                                                {{ trim($new_data->student_advisor) }}</span>
                                                        @else
                                                            {{ trim($new_data->student_advisor) }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (StudentController::check_academicstatus(trim($new_data->student_academic_status)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_academic_status }}</span>
                                                        @else
                                                            {{ $new_data->student_academic_status }}
                                                        @endif
                                                    </td>

                                                    @php
                                                        $academic_status = trim($new_data->student_academic_status);
                                                        $enddate_siit = trim(
                                                            $new_data->student_enddateofstudentstatussiit,
                                                        );
                                                        $enddate_tu = trim($new_data->student_enddateofstudentstatus);

                                                        $requireEndDate = in_array($academic_status, [
                                                            'No Registration',
                                                            'Resign',
                                                            'Death',
                                                        ]);
                                                    @endphp
                                                    {{-- End Date (SIIT) --}}
                                                    <td align="center"
                                                        style="color: {{ ($requireEndDate && empty($enddate_siit)) || ($requireEndDate && !preg_match('/^\d{4}-\d{2}-\d{2}$/', $enddate_siit)) ? 'red' : 'black' }}">

                                                        @if (empty($enddate_siit))
                                                            -
                                                        @else
                                                            {{ $enddate_siit }}
                                                        @endif
                                                    </td>

                                                    @php
                                                        $enddate_status = trim(
                                                            $new_data->student_enddateofstudentstatus,
                                                        );
                                                        $isValid =
                                                            empty($enddate_status) ||
                                                            preg_match('/^\d{4}-\d{2}-\d{2}$/', $enddate_status);
                                                    @endphp
                                                    {{-- End Date (TU) --}}
                                                    <td align="center"
                                                        style="color: {{ ($requireEndDate && empty($enddate_tu)) || ($requireEndDate && !preg_match('/^\d{4}-\d{2}-\d{2}$/', $enddate_tu)) ? 'red' : 'black' }}">
                                                        @if (empty($enddate_tu))
                                                            -
                                                        @else
                                                            {{ $enddate_tu }}
                                                        @endif
                                                    </td>

                                                    <td align="center">
                                                        @if (StudentController::check_type(trim($new_data->student_typeofdebtor)) == 0)
                                                            <span style="color: red">
                                                                {{ $new_data->student_typeofdebtor }}</span>
                                                        @else
                                                            {{ $new_data->student_typeofdebtor }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (trim($new_data->student_typeofdebtor) == 'Loan')
                                                            @if (!empty($new_data->student_scholarshipprogram) || !empty($new_data->student_scholarshipstatus))
                                                                <span style="color: red">Invalid Scholarship Data for Loan
                                                                    Type</span>
                                                            @else
                                                                -
                                                            @endif
                                                        @else
                                                            @if (StudentController::check_scholarshipprogram(trim($new_data->student_scholarshipprogram),
                                                                    $new_data->student_typeofdebtor) == 0)
                                                                <span style="color: red">
                                                                    {{ $new_data->student_scholarshipprogram }}
                                                                </span>
                                                            @else
                                                                {{ $new_data->student_scholarshipprogram }}
                                                            @endif
                                                        @endif
                                                    </td>
                                                    <td align="center">{{ $new_data->student_scholarshiploanagreementno }}
                                                    </td>
                                                    <td align="center">
                                                        {{ $new_data->student_scholarshiploanagreementdate }}</td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_agreementno))
                                                            -
                                                        @else
                                                            {{ $new_data->student_agreementno }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_agreementdate))
                                                            -
                                                        @else
                                                            {{ $new_data->student_agreementdate }}
                                                        @endif
                                                    </td>
                                                    <td align="center">{{ $new_data->student_guarantor_firstname }}</td>
                                                    <td align="center">{{ $new_data->student_guarantor_lastname }}</td>
                                                    <td align="center">{{ $new_data->student_guarantor_email }}</td>
                                                    <td align="center">{{ $new_data->student_debtstatus }}</td>
                                                    <td align="center">
                                                        @php
                                                            $enddebstatus = trim($new_data->student_enddebtorstatus);
                                                        @endphp
                                                        {{-- @if (empty($status))
                                                            -
                                                        @elseif (StudentController::check_end_debtor_status($status) == 0)
                                                            <span style="color: red">{{ $status }}</span>
                                                        @else
                                                            {{ $status }}
                                                        @endif --}}
                                                        @if (empty($enddebstatus))
                                                            -
                                                        @else
                                                            {{ $enddebstatus }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_exec_no))
                                                            -
                                                        @else
                                                            {{ $new_data->student_exec_no }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_exec_date))
                                                            -
                                                        @else
                                                            {{ $new_data->student_exec_date }}
                                                        @endif
                                                    </td>
                                                    <td align="center"
                                                        @if (!is_numeric($new_data->student_theoutstandingbalance)) style="color: red" @endif>
                                                        {{ is_numeric($new_data->student_theoutstandingbalance)
                                                            ? number_format($new_data->student_theoutstandingbalance, 2)
                                                            : $new_data->student_theoutstandingbalance }}
                                                    </td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_duedate))
                                                            -
                                                        @else
                                                            {{ $new_data->student_duedate }}
                                                        @endif
                                                    </td>
                                                    <td align="center">
                                                        @if (empty($new_data->student_remark))
                                                            -
                                                        @else
                                                        {{ $new_data->student_remark }}
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    </table>
                                </div>
                            @endif
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    @include('layouts.footer')
@endsection