@extends('layouts.master')
@section('title', 'Monthly List')

@section('style')
    <style>

    </style>
@endsection

@section('script')
    <script>
        function PDF() {
            // var year = $('#year').val();
            var startDate = $('#startDate').val();
            var endDate = $('#endDate').val();


            // ตรวจสอบว่ามีการเลือกวันที่เริ่มต้นและสิ้นสุดหรือไม่
            if (!startDate || !endDate) {
                alert("กรุณาเลือกช่วงวันที่");
                return;
            }

            // เปิด URL ในแท็บใหม่
            window.open("/public/monthlyreportpdf/" + startDate + "/" + endDate, "_blank");
        }

        function search() {
            // var year = $('#year').val();
            var startDate = $('#startDate').val();
            var endDate = $('#endDate').val();

            if (!startDate || !endDate) {
                alert("กรุณาเลือกช่วงวันที่");
                return;
            }

            // แปลงวันที่เป็น format ที่ต้องการ
            startDate = new Date(startDate).toISOString().split('T')[0]; // รูปแบบ YYYY-MM-DD
            endDate = new Date(endDate).toISOString().split('T')[0];

            // ส่งข้อมูลปีและช่วงวันที่ไปยัง URL
            window.location = "/public/monthlylist/" + startDate + "/" + endDate;
        }

        $(document).ready(function() {

        });
    </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">Monthly Report</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">
            <div>
                <span class="text-dark fs-30">Monthly Report</span>
            </div>
        </div>
        <br>
        <div class="card p-4">
            {{-- <div class="row d-flex">
                <div class="col-md-4">
                    <div class="form-select-wrapper mb-4">
                        <select class="form-select" name="academic_year" id="year">
                            <option value="" disabled>All Year</option>
                            @foreach ($academicyear as $i => $academic)
                                <option value="{{ $academic->academic_year }}"
                                    {{ $academic->academic_year == date('Y') ? 'selected' : '' }}>
                                    {{ $academic->academic_year }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
            </div> --}}
            <div class="row d-flex">
                <div class="row">
                    <div class="col-md-4">
                        <div class="form-group mb-4">
                            <input type="date" id="startDate" class="form-control" placeholder="Select Start Date">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group mb-4">
                            <input type="date" id="endDate" class="form-control" placeholder="Select End Date">
                        </div>
                    </div>
                    <div class="col-md-4 d-flex align-items-center">
                        <button class="btn btn-danger rounded-pill w-50 text-light" onClick="PDF();">PDF</button>
                        <button class="btn btn-primary rounded-pill w-50 text-light ms-1"
                            onClick="search();">Search</button>
                    </div>
                </div>
                {{-- <div class="row"> --}}

                {{-- </div> --}}

                <br>

                {{-- </form> --}}
                <div class="container py-10">
                    @if (
                        (isset($monthly_student_unofficial) &&
                            isset($monthly_student_official) &&
                            $monthly_student_unofficial->isNotEmpty()) ||
                            $monthly_student_official->isNotEmpty())
                        <div>
                            <div>
                                <h1 align="center">Performance Report: 1 {{ $monthName }} {{ $year }}</h1>
                            </div>
                            <br><br>
                            <div>
                                <h2>Performance on {{ $monthName }} {{ $year }}</h2>
                            </div>
                            <div style="width:100%; padding-top: 10px">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="width: 40%">Type of Activity Transcript</th>
                                            <th style="width: 60%">Number of issue generated by The system</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td style="padding-left: 0.5cm;border-bottom:white">Unofficial</td>
                                            <td style="padding-left: 0.5cm;border-bottom:white">{{ $unofficialCount }}</td>
                                        </tr>
                                        <tr>
                                            <td style="padding-left: 0.5cm;border-top:white">Official</td>
                                            <td style="padding-left: 0.5cm;border-top:white">{{ $officialCount }}</td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                            <div>
                                <h2>Detail of Activity Transcript ({{ $monthName }} {{ $year }})</h2>
                            </div>
                            <div style="width:100%; padding-top: 10px">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="width: 5%">No</th>
                                            <th style="width: 15%">Student ID</th>
                                            <th style="width: 35%">Name</th>
                                            <th style="width: 15%">AT Type</th>
                                            <th style="width: 15%">AT-U</th>
                                            <th style="width: 15%">Date of issue</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($monthly_student_unofficial as $key => $monthlyunof)
                                            <tr>
                                                <td>{{ ++$key }}</td>
                                                <td>{{ $monthlyunof->student_code }}</td>
                                                <td>{{ $monthlyunof->student_name }}</td>
                                                <td>{{ $monthlyunof->payment_status_un_of }}</td>
                                                {{-- <td>{{ substr(date('Y'), 2) }} / {{ $monthlyunof->participant_number_at }}</td> --}}
                                                <td>{{ substr(date('Y'), 2) }} / {{ $monthlyunof->payment_code }}</td>
                                                <td>{{ $monthlyunof->created_at }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>

                            <br><br>

                            <div style="width:100%; padding-top: 10px">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th style="width: 5%">No</th>
                                            <th style="width: 15%">Student ID</th>
                                            <th style="width: 35%">Name</th>
                                            <th style="width: 15%">AT Type</th>
                                            <th style="width: 15%">AT No</th>
                                            <th style="width: 15%">Date of issue</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($monthly_student_official as $key => $monthlyof)
                                            <tr>
                                                <td>{{ ++$key }}</td>
                                                <td>{{ $monthlyof->student_code }}</td>
                                                <td>{{ $monthlyof->student_name }}</td>
                                                <td>{{ $monthlyof->payment_status_un_of }}</td>
                                                <td>{{ substr(date('Y'), 2) }} / {{ $monthlyof->payment_code }}</td>
                                                <td>{{ $monthlyof->created_at }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    @else
                        <div>
                            <h1 align="center">Performance Report: 1 {{ $monthName }} {{ $year }}</h1>
                        </div>
                        <br><br>
                        <div>
                            <h2>Performance on {{ $monthName }} {{ $year }}</h2>
                        </div>
                        <div style="width:100%; padding-top: 10px">
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th style="width: 40%">Type of Activity Transcript</th>
                                        <th style="width: 60%">Number of issue generated by The system</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr>
                                        <td style="padding-left: 0.5cm;border-bottom:white">Unofficial</td>
                                        <td style="padding-left: 0.5cm;border-bottom:white">0</td>
                                    </tr>
                                    <tr>
                                        <td style="padding-left: 0.5cm;border-top:white">Official</td>
                                        <td style="padding-left: 0.5cm;border-top:white">0</td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <br>
                        <div>
                            <h2>Detail of Activity Transcript ({{ $monthName }} {{ $year }})</h2>
                        </div>
                        <div style="width:100%; padding-top: 10px">
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th style="width: 5%">No</th>
                                        <th style="width: 15%">Student ID</th>
                                        <th style="width: 35%">Name</th>
                                        <th style="width: 15%">AT Type</th>
                                        <th style="width: 15%">AT-U</th>
                                        <th style="width: 15%">Date of issue</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <!-- Table will be empty if no data is found -->
                                    <tr>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>

                        <div style="width:100%; padding-top: 10px">
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th style="width: 5%">No</th>
                                        <th style="width: 15%">Student ID</th>
                                        <th style="width: 35%">Name</th>
                                        <th style="width: 15%">AT Type</th>
                                        <th style="width: 15%">AT No</th>
                                        <th style="width: 15%">Date of issue</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <!-- Table will be empty if no data is found -->
                                    <tr>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                        <td>0</td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    @include('layouts.footer')
@endsection