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

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

@php
    if (empty($activity)) {
        $activity_id = '';
        $activity_code = '';
        $activity_academic_year = '';
        $activity_name_en = '';
        $activity_name_th = '';
        $activity_name = '';
        $activity_type1 = '';
        $activity_type_code = '';
        // $activity_organized = '';
        $activity_club = '';
        $activity_date_begin = '';
        $activity_date_end = '';
        $activity_time = '';
        $activity_place = '';
        $activity_detail_en = '';
        $activity_detail_th = '';
        $activity_participants = '';
        // $activity_academic_gen = '';
    } else {
        $activity_id = $activity->activity_id;
        $activity_code = $activity->activity_code;
        $activity_academic_year = $activity->activity_academic_year;
        $activity_name_en = $activity->activity_name_en;
        $activity_name_th = $activity->activity_name_th;
        $activity_name = $activity->activity_name;
        $activity_type1 = $activity->activity_type1;
        $activity_type_code = $activity->activity_type_code;
        // $activity_organized = $activity->activity_organized;
        $activity_club = $activity->activity_club;
        $activity_date_begin = $activity->activity_date_begin;
        $activity_date_end = $activity->activity_date_end;
        $activity_time = $activity->activity_time;
        $activity_place = $activity->activity_place;
        $activity_detail_en = $activity->activity_detail_en;
        $activity_detail_th = $activity->activity_detail_th;
        $activity_participants = $activity->activity_participants;
        // $activity_academic_gen = $activity->activity_academic_gen;
    }
    $academicyear_cut = DB::table('academic_year')->where('academic_year_id', $activity_academic_year)->first();

    $cut_str = '';
    if ($academicyear_cut && isset($academicyear_cut->academic_year)) {
        $cut_str = substr($academicyear_cut->academic_year, 2);
    }
    // echo $cut_str;
    $activity_count = DB::table('report_activity')->get();
    $count_activity = count($activity_count);

    // echo $count_activity;
    $number = str_pad($count_activity, 3, '0', STR_PAD_LEFT);
    $number1 = str_pad((int) $number + 1, 3, '0', STR_PAD_LEFT);

    $number = 0;
    $gencode = 'AP45';

    function get_type($name)
    {
        $type = DB::table('type')->where('type_code', $name)->first();

        if ($type == '') {
            return 0;
        } else {
            return $type->type_id;
        }
    }

    function get_tu_greats($tu_greats)
    {
        $tugreats = DB::table('tu_greats')->where('tugreats_code', $tu_greats)->first();

        if ($tugreats == '') {
            return 0;
        } else {
            return $tugreats->tu_greats_id;
        }
    }

@endphp

@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);
                }
            }

            // ตรวจสอบว่าไฟล์เป็น .xlsx หรือไม่
            var fileExtension = filename.split('.').pop().toLowerCase();
            if (fileExtension !== 'xlsx') {
                alert('❌ Only XLSX files are allowed!'); // แจ้งเตือน Popup
                $('#file').val(''); // รีเซ็ตค่า input file
                $('#show_file').html(''); // เคลียร์ชื่อไฟล์ที่แสดง
                return; // หยุดการทำงาน
            }

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

@section('content')
    @include('layouts.header')
    <section class="wrapper image-wrapper bg-image bg-overlay text-white" data-image-src="{{ asset('/bg/bgg02.png') }}"
        style="background-image: url('{{ asset('/bg/bgg02.png') }}');">
        <div class="container pt-14 pt-md-16 pb-23 pb-md-15 text-center">
            <div class="row">
                <div class="row">
                    <div class="col-lg-8 col-xxl-7 mx-auto text-center" data-cues="slideInDown" data-group="page-title"
                        data-delay="600">
                        <h1 class="fs-58 mb-2 text-light">Activity Import</h1>
                        {{-- <h2 class="fs-16 text-uppercase ls-xl text-light mb-4">Hello! This is Sandbox</h2> --}}
                    </div>
                </div>
            </div>
        </div>
    </section>

    <div class="container py-10">
        <div class="d-flex justify-content-between align-items-center mb-3">
            <div>
                <span class="text-dark fs-30">Activity Import</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('/activityimport_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="{{ asset('/importexcel/activity/activityV6.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 (ActivityController::check_academic(trim($new_data->activity_year)) == 0)
                                            @php $error_array[] = 'Check the year of Academic Year.' @endphp
                                        @endif



                                        {{-- @if (ActivityController::check_activity_name_en(trim($new_data->activity_name_en)) == 0)
                                            @php $error_array[] = 'Check the name of Activity Name(EN).' @endphp
                                        @endif

                                        @if (ActivityController::check_activity_name_th(trim($new_data->activity_name_th)) == 0)
                                            @php $error_array[] = 'Check the name of Activity Name(TH).' @endphp
                                        @endif --}}
                                        {{-- {{trim($new_data->type)}} --}}
                                        @php
                                            $check_type = explode(',', $new_data->type);
                                        @endphp

                                        @foreach ($check_type as $i => $check_type1)
                                            @if (get_type($check_type1) == '0')
                                                {{-- @if (ActivityController::check_type(trim($new_data->type)) == 0) --}}
                                                @php $error_array[] = 'Check the name of Type.' @endphp
                                            @endif
                                        @endforeach

                                        @php
                                            $check_tu_greats = explode(',', $new_data->activity_tu_greats);
                                        @endphp

                                        {{-- @foreach ($check_tu_greats as $i => $tugreats)
                                            @if (get_tu_greats($tugreats) == '0')
                                                @php $error_array[] = 'Check the type of Tu Greats.' @endphp
                                            @endif
                                        @endforeach --}}

                                        {{-- @if (ActivityController::check_organized_coordinated(trim($new_data->organized)) == 0)
                                            @php $error_array[] = 'Check the name of Organized/Coordinated.' @endphp
                                        @endif --}}

                                        @if (ActivityController::check_club(trim($new_data->club)) == 0)
                                            @php $error_array[] = 'Check the name of Club.' @endphp
                                        @endif
                                    @endforeach
                                    @if (count($error_array) == 0)
                                        <a href="{{ url('/activityimport_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; width: 5%">No.</th>
                                            {{-- <th style="vertical-align: middle; text-align: center; width: 8%">Code</th> --}}
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Academic Year
                                            </th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Activity
                                                Name(EN)</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Activity
                                                Name(TH)</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Type</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Tu Greats</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">
                                                Club</th>
                                            <th style="vertical-align: middle; text-align: center; width: 20%">Date of
                                                Activity</th>
                                            <th style="vertical-align: middle; text-align: center; width: 15%">Time</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Place</th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Detail(EN)
                                            </th>
                                            <th style="vertical-align: middle; text-align: center; width: 8%">Detail(Th)
                                            </th>
                                            {{-- <th style="vertical-align: middle; text-align: center">Status</th> --}}
                                        </tr>
                                    </thead>
                                    @if (!empty($data))
                                        @foreach ($data as $key => $new_data)
                                            <tr>
                                                @php
                                                    $cut_str2 = substr($new_data->activity_year, 2);
                                                    $get_year = DB::table('academic_year')
                                                        ->where('academic_year', $new_data->activity_year)
                                                        ->first();
                                                @endphp
                                                <td align="center">
                                                    {{ ++$key }}
                                                </td>
                                                {{-- <td align="center">
                                                    {{ $gencode }}{{ $cut_str2 }}
                                                </td> --}}
                                                <td align="center">
                                                    {{ $new_data->activity_year }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_name_en }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_name_th }}
                                                </td>
                                                <td align="center">
                                                    @php
                                                        $check_type = explode(',', $new_data->type);
                                                    @endphp
                                                    @foreach ($check_type as $i => $check_type1)
                                                        @if (get_type($check_type1) == '0')
                                                            <span style="color: red"> {{ $check_type1 }}</span>
                                                        @else
                                                            {{ $check_type1 }}
                                                        @endif
                                                        <br>
                                                    @endforeach
                                                </td>
                                                <td align="center">
                                                    @php
                                                        $check_tu_greats = explode(',', $new_data->activity_tu_greats);
                                                    @endphp
                                                    @foreach ($check_tu_greats as $i => $tugreats)
                                                        @if (get_tu_greats($tugreats) == '0')
                                                            <span style="color: red"> {{ $tugreats }}</span>
                                                        @else
                                                            {{ $tugreats }}
                                                        @endif
                                                        <br>
                                                    @endforeach
                                                </td>

                                                <td align="center">
                                                    @if (ActivityController::check_club(trim($new_data->club)) == 0)
                                                        <span style="color: red"> {{ $new_data->club }}</span>
                                                    @else
                                                        {{ $new_data->club }}
                                                    @endif

                                                </td>
                                                <td align="center">
                                                    @php
                                                        $date_start = $new_data->date_start ?? null;
                                                        $date_end = $new_data->date_end ?? null; // แก้ไขให้ใช้ date_end ด้วย

                                                        if ($date_start && Carbon::hasFormat($date_start, 'd/m/Y')) {
                                                            $date_start = Carbon::createFromFormat(
                                                                'd/m/Y',
                                                                $date_start,
                                                            )->format('Y-m-d');
                                                        } else {
                                                            $date_start = 'Invalid Date';
                                                        }

                                                        if ($date_end && Carbon::hasFormat($date_end, 'd/m/Y')) {
                                                            $date_end = Carbon::createFromFormat(
                                                                'd/m/Y',
                                                                $date_end,
                                                            )->format('Y-m-d');
                                                        } else {
                                                            $date_end = 'Invalid Date';
                                                        }
                                                    @endphp
                                                    {{ $date_start }} - {{ $date_end }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_time_start }} -
                                                    {{ $new_data->activity_time_end }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_place }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_detail_en }}
                                                </td>
                                                <td align="center">
                                                    {{ $new_data->activity_detail_th }}
                                                </td>
                                            </tr>
                                        @endforeach
                                    @endif
                                </table>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>

    @include('layouts.footer')
@endsection