@extends('layouts.admin.admin')

@section('title', ucwords($status?? config('custom.all')).' Guest List')

@section('content')
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-flex align-items-center justify-content-between">
            <h5 class="mb-0 font-size-18">{{ ucwords($graduate_status[0] ?? config('custom.all')) }} Guest List</h5>

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                    <li class="breadcrumb-item">Guest List</li>
                    <li class="breadcrumb-item active">{{ ucwords($graduate_status[0] ?? config('custom.all')) }} </li>
                </ol>
            </div>

        </div>
    </div>
</div>
<div class="card">
    <div class="card-body">
        <div class="row">
            <input type="hidden" class="route" value="{{ route('guest-list.index') }}">
            <div class="col-md-4">
                <div class="form-group">
                    <label for="user" class="col-form-label pt-0">Choose Instituion</label>
                    <select data-placeholder="Select Option" id="institution_id"
                        class="select2 tail-select  form-control" name="institution_id" onchange="getCeremonyList('0')" required>
                        <option value="0" selected>All</option>
                        @foreach ($institutions as $institute)
                            <option value="{{ $institute->id }}">{{$institute->name}}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="user" class="col-form-label pt-0">Ceremony Type</label>
                    <select data-placeholder="Select Option" id="ceremony_type"
                        class="select2 tail-select  form-control" name="ceremony_type" onchange="getCeremonyList('0')" required>
                        <option value="{{ \App\Constant\Constant::ACTIVE }}" selected>{{ \App\Constant\Constant::ACTIVE }} Only</option>
                        <option value="{{ \App\Constant\Constant::ALL }}" >{{ \App\Constant\Constant::ALL }}</option>
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="user" class="col-form-label pt-0">Graduation</label>
                    <select data-placeholder="Select Option" id="ceremony"
                        class="select2 tail-select  form-control ceremony" name="ceremony" required>
                        <option value="0">All</option>
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="user" class="col-form-label pt-0">Choose Status</label>
                    <select data-placeholder="Select Option" id="graduate_status"
                        class="select2 tail-select  form-control" name="graduate_status" required>
                        <option value="All">All</option>
                        @foreach (config('custom.graduate_status') as $status)
                            <option value="{{ $status }}">{{$status}}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="payment_by" class="col-form-label pt-0">Attend</label>
                    <select data-placeholder="Select Option" id="attend"
                        class="select2 tail-select  form-control" name="attend" required>
                        <option value="All">All</option>
                        @foreach (config('custom.attend_status') as $attend)
                            <option value="{{ $attend }}">{{ $attend }}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="payment_by" class="col-form-label pt-0">Paid</label>
                    <select data-placeholder="Select Option" id="paid"
                        class="select2 tail-select  form-control" name="paid" required>
                        <option value="All">All</option>
                        @foreach (config('custom.yes_no_text') as $option)
                            <option value="{{ $option }}">{{ $option }}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label for="invitation_letter_sent" class="col-form-label pt-0">Invitation Letter Sent</label>
                    <select data-placeholder="Select Option" id="invitation_letter_sent"
                        class="select2 tail-select  form-control" name="invitation_letter_sent" required>
                        <option value="All">All</option>
                        @foreach (config('custom.yes_no_text') as $option)
                            <option value="{{ $option }}">{{ $option }}</option>
                        @endforeach
                    </select>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-md-4">
                <div>
                    <div>
                        <button class="btn btn-dark btn-sm" type="button" id="get-guest-list">
                            <i class="fa fa-search"></i> Search
                        </button>
                    </div>
                </div>
            </div>
        </div>
        
    </div>
</div>
<div class="card mt-2 p-4">
    <div class="card-header">
        <a href="javascript:void(0)" class="btn btn-primary btn-sm mr-3" onclick="exportGuestList()">
            <i class="fa fa-file-export"></i> Export
        </a>
    </div>
    <div class="table-responsive">

        <table id="datatable" class="table table-bordered">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Institution</th>
                    <th>Graduate</th>
                    <th>Student ID</th>
                    <th>Course</th>
                    <th>Invoice Number</th>
                    <th>Guest First Name</th>
                    <th>Guest Last Name</th>
                    <th>Guest Email</th>
                    <th>Guest Mobile</th>
                    <th>Required Visa Letter</th>
                    <th>Passport Number</th>
                    <th>Relationship</th>
                    <th>Dietary Preferences</th>
                    <th>Paid</th>
                    <th>Status</th>
                    <th>Invitation Letter Sent</th>
                    <th>Seat Number</th>
                </tr>
            </thead>
            <tbody></tbody>
        </table>
    </div>
</div>
@endsection
@section('page-specific-scripts')
    <script>
        $(document).ready( function () {
            var table = $('#datatable').DataTable({
                "language": {
                    "searchPlaceholder": "By Student Id",
                },
                "processing": true,
                "serverSide": true,
                "ajax":{
                    "url":  $('.route').val(),
                    data: function (d) {
                        d.institution_id = $('#institution_id').val(),
                        d.status = $('#graduate_status').val();
                        d.ceremony_id = $('#ceremony').val();
                        d.ceremony_type = $('#ceremony_type').val();
                        d.attend = $('#attend').val();
                        d.paid = $('#paid').val();
                        d.invitation_letter_sent = $('#invitation_letter_sent').val();
                        d.archive = "0";
                    }
                }, 
                // dom: 'Bfrtip',
                // buttons: [
                //     'copy', 'csv', 'excel', 'pdf', 'print',
                //     // exportOptions: {
                //     //     columns: 'th:not(:last-child)'
                //     // }
                // ],
                // dom: 'Bfrtip',
                // buttons: [
                //     {
                //         extend: 'excel',
                //         text: 'Export Search Results',
                //         className: 'btn btn-default',
                //         exportOptions: {
                //             columns: 'th:not(:last-child)'
                //         }
                //     }
                // ],
                "columns": [
                    { "data": "id", 'visible': false },
                    { "data": "institution", orderable: false,  searchable: false },
                    { "data": "graduate", orderable: false },
                    { "data": "student_id", orderable: false },
                    { "data": "course", orderable: false },
                    { "data": "invoice_number", orderable: false,  searchable: false },
                    { "data": "first_name" },
                    { "data": "last_name" },
                    { "data": "email" },
                    { "data": "mobile" },
                    { "data": "requires_visa_letter" },
                    { "data": "passport_number" },
                    { "data": "relationship" },
                    { "data": "dietary_preferences" },
                    { "data": "paid" },
                    { "data": "status_formatted" },
                    { "data": "invitation_letter_sent", orderable: false,  searchable: false },
                    { "data": "seat_number", orderable: false,  searchable: false },
                    // { "data": "actions", orderable: false, searchable: false },
                ],
                order: [ [0, 'desc'] ]
            });
            // $('#institution_id').change(function(){
            //     table.draw();
            // });
            // $('#graduate_status').change(function(){
            //     table.draw();
            // });
            $("#get-guest-list").click(function(){
                table.draw();
            });
        });
        

        function exportGuestList()
        {
            const baseURL = "{{ url('guest-list/export-data') }}";
            const institution_id = $('#institution_id').val();
            // if (institution_id == 0) {
            //     alert('Choose An Institute to EXPORT.')
            // } else {
                const params = {
                    institution_id: $('#institution_id').val(),
                    status: $('#graduate_status').val(),
                    ceremony_id: $('#ceremony').val(),
                    ceremony_type: $('#ceremony_type').val(),
                    attend: $('#attend').val(),
                    paid: $('#paid').val(),
                    invitation_letter_sent: $('#invitation_letter_sent').val(),
                };
                
                const paramString = new URLSearchParams(params).toString();
                let url = `${baseURL}?${paramString}`;
                window.open(url , "_blank");
            // }
        }
    </script>
@endsection