@extends('layouts.web')

@section('css')
<link href="{{ asset('css/dataTables.bootstrap4.min.css') }}" rel="stylesheet" />
<link href="{{ asset('css/sweetalert2.min.css') }}" rel="stylesheet" />
<link href="{{ asset('css/bootstrap-datepicker.min.css') }}" rel="stylesheet" />
@endsection

@section('content')
<div class="container-fluid pt-3">
    <div class="row">
        <div class="col-2">
            <form action="{{ route('student.graduated_submit') }}"
            novalidate class="{{ ($errors->any()) ? 'was-validated' : 'needs-validation' }}"
            method="post"
            >
            @csrf
                <div class="form-group">
                    <label for="monthYear">นักเรียนในปี <span class="text-red">*</span></label>
                    <div class="input-group mb-3">
                        <input type="text" class="form-control datepiacker" id="year" name="year" placeholder="นักเรียนในปี" autocomplete="off" value="{{$year}}" required>
                        <div class="input-group-append">
                            <span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
                        </div>
                        <button type="submit" class="btn btn-outline-success show-outline-btn ml-2" value="add-student">แสดง</button>
                    </div>
                    @error('year')
                    <div class="text-danger">{{  $message }}</div>
                    @enderror
                </div>
            </form>
        </div>
    </div>
    <div class="row mt-3">
        <div class="col">
            <div class="card card-outline card-success">
                <div class="card-body">
                    <table class="table student-table" id="student-table">
                        <thead>
                          <tr>
                            <th scope="col" width="2%">#</th>
                            <th scope="col" width="5%">เลขที่</th>
                            <th scope="col" width="7%">วันที่สมัคร</th>
                            <th scope="col" width="12%">ชื่อ-สกุล</th>
                            <th scope="col" width="7%">เลขที่บัตรประชาชน</th>
                            <th scope="col" width="28%">หลักสูตร</th>
                            <th scope="col" width="7%">วันสอบ</th>
                            <th scope="col" width="5%">ค่าเรียน</th>
                            <th scope="col" width="5%">ส่วนลด</th>
                            <th width="9%"></th>
                          </tr>
                        </thead>
                        <tbody>
                            @foreach ($students as $indexKey => $student)
                            <tr class="hand-hover">
                                <td class="align-middle">{{ $indexKey + 1 }}.</td>
                                {{-- <td class="align-middle"><a href="{{ route('student.show',$student->sid) }}" class="course-title-link">{{ $student->code_no."/".$student->code_month."/".$student->code_branch }}</a></td> --}}
                                <td class="align-middle">{{ $student->code_no."/".$student->code_month."/".$student->code_branch }}</td>
                                <td class="align-middle">{{ formatDateFromDB($student->register_date) }}</td>
                                <td class="align-middle">
                                    <a class="course-title-link" href="{{ route('student.show_graduated',$student->sid) }}">
                                        {{ $student->firstname ." ". $student->lastname }}
                                    </a>
                                </td>
                                <td class="align-middle">{{ $student->idcard }}</td>
                                <td class="align-middle">{{ "(".$student->type .") ". $student->name }}</td>
                                <td class="align-middle">{{ ($student->exam_date != "") ? formatDateFromDB($student->exam_date) : " " }}</td>
                                <td class="align-middle">{{ number_format($student->course_cost) }}</td>
                                <td class="align-middle">{{ ($student->discount != "" || $student->discount != "0" ) ? number_format($student->discount) : "-" }}</td>                                <td class="align-middle text-center">
                                    <a href="{{ route('student.edit', $student->sid) }}" class="edit-btn" title="แก้ไขข้อมูล"><i class="far fa-edit"></i></a>
                                    {{-- <a href="{{ route('student.reactivate',$student->sid) }}" class="restore-btn ml-2" title="เปิดใช้งานอีกครั้ง"><i class="fas fa-upload"></i></a> --}}
                                    <form id="del-frm{{ $indexKey }}" class="d-inline"
                                        method="POST"
                                        action="{{ route('student.destroy_graduated') }}"
                                        onsubmit="confirmalert(event, {{ $indexKey }}, 'นักเรียน')"
                                    >
                                    @csrf

                                        <input type="hidden" name="sid" id="sidDel{{ $indexKey }}" value="{{$student->sid}}">
                                        <input type="hidden" name="logStudent" id="logStudent{{ $indexKey }}" value="{{ 'เลขที่ ' . $student->code_no.'/'.$student->code_month.'/'.$student->code_branch . ', ชื่อ ' . $student->title.strip_tags($student->firstname).' '.strip_tags($student->lastname) }}">
                                        <button type="submit" class="btn del-btn btn-sm ml-1" title="ลบข้อมูล">
                                            <i class="far fa-trash-alt"></i>
                                        </button>
                                    </form>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('footerscript')
<script src="{{ asset('js/sweetalert2.min.js') }}"></script>
<script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('js/bootstrap-datepicker.min.js') }}"></script>
<script src="{{ asset('js/bootstrap-datepicker.th.min.js') }}"></script>
<script src="{{ asset('js/custom.js') }}"></script>
<script>
    $(document).ready(function() {
        $('.student-table').DataTable({
            "lengthChange": false,
            "info": false,
            "pageLength": 20,
            "language": {
                "emptyTable":   "ไม่พบข้อมูล",
                "paginate": {
                    "first":    "หน้าแรก",
                    "last":     "หน้าสุดท้าย",
                    "next":     "ถัดไป",
                    "previous": "ก่อนหน้า"
                },
                "search":       "ค้นหา:",
                "lengthMenu":   "จำนวนนักเรียนทั้งหมด _MENU_ คน",
                "info":         "ทั้งหมด _TOTAL_ คน",
                "infoEmpty":    "ไม่พบนักเรียน",
            }
        });
        $('#student-table tr td:not(:last-child)').click(function () {
            var href = $(this).closest('tr').find('a').attr('href');
            location.href = href;
        });
        $('#year').datepicker({
            format: 'yyyy',
            autoclose: true,
            language: 'th',
            endDate: '+0m',
            orientation: 'bottom',
            startView: 'years',
            minViewMode: 'years',
        });
    });
</script>
@if (session('feedback'))
<script>
    Swal.fire({
                text: '{{ session('feedback') }}',
                icon: 'success',
                confirmButtonText: 'ตกลง',
                confirmButtonColor: '#62966C'
    })
</script>
@endif
@endsection

