@extends('layouts.admin')

@section('content')
@include('include.datatable-css')

<div class="pc-container">
    <div class="pc-content">
        <div class="page-header">
            <div class="page-block">
                <div class="row align-items-center">
                    <div class="col-md-12">
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item">Reports</li>
                        </ul>
                    </div>
                    <div class="col-md-12">
                        <div class="page-header-title">
                            <h3 class="mb-0">Expired Packages</h3>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row pt-0">
            <div class="col-sm-12">
                <div class="card">
                    <div class="card-body pt-2">
                        <div class="row">
                            <div class="col-md-12 text-end">
                                <button class="btn border-0" type="button" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                    <span data-bs-toggle="tooltip" data-bs-original-title="Choose and apply filter">
                                        <img class="filter-btn-icon img-fluid" src="{{ asset('assets/icons/filter.svg') }}" alt="icon">
                                        ADD FILTER
                                    </span>
                                </button>

                                <div class="dropdown-menu filter-dropdown">
                                    <span class="dropdown-item" onclick="toggleFilter('Account')">
                                        <i id="tick-order" class="text-white">&#10003;</i>
                                        Account ID
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('user')">
                                        <i id="tick-user" class="text-white">&#10003;</i>
                                        User
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('phone')">
                                        <i id="tick-phone" class="text-white">&#10003;</i>
                                        Phone
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('email')">
                                        <i id="tick-email" class="text-white">&#10003;</i>
                                        Email
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('order')">
                                        <i id="tick-order" class="text-white">&#10003;</i>
                                        Order
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('package')">
                                        <i id="tick-package" class="text-white">&#10003;</i>
                                        Package
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('start_date')">
                                        <i id="tick-start_date" class="text-white">&#10003;</i>
                                        Start Date
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('end_date')">
                                        <i id="tick-end_date" class="text-white">&#10003;</i>
                                        End Date
                                    </span>
                                    <span class="dropdown-item" onclick="toggleFilter('dateRange')">
                                        <i id="tick-dateRange" class="text-white">&#10003;</i>
                                        Date Range
                                    </span>
                                </div>

                                @include('include.export-button')
                            </div>
                        </div>

                        <div class="row">
                            <div class="col-md-12">
                                <div class="d-flex justify-content-end">
                                    <span id="account-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="account-filter" class="form-control filter-input" data-col="1" placeholder="account">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('account')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="user-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="user-filter" class="form-control filter-input" data-col="2" placeholder="user">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('user')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="phone-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="phone-filter" class="form-control filter-input" data-col="5" placeholder="phone">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('phone')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="email-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="email-filter" class="form-control filter-input" data-col="3" placeholder="email">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('email')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="order-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="order-filter" class="form-control filter-input" data-col="4" placeholder="order">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('order')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="package-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="package-filter" class="form-control filter-input" data-col="4" placeholder="package">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('package')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="start_date-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="start_date-filter" class="form-control filter-input" data-col="4" placeholder="start_date">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('start_date')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="end_date-filter-container" class="filter-container input-group d-none">
                                        <input type="text" id="end_date-filter" class="form-control filter-input" data-col="4" placeholder="end_date">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('end_date')">
                                            &times;
                                        </button>
                                    </span>
                                    <span id="dateRange-filter-container" class="filter-container input-group d-none">
                                        <input id="dateRangeEle" class='dateRangeEle' data-col="16" type="text" size="35" data-bs-toggle="tooltip" title="Select date range">
                                        <button class="btn btn-outline-secondary filter-close-btn px-1" onclick="toggleFilter('dateRange')">
                                            &times;
                                        </button>
                                    </span>
                                </div>
                            </div>
                        </div>

                        @include('include.flash-message')

                        <p id="custom-alert" class="alert alert-info d-none"></p>

                        <div class="dt-responsive table-responsive">
                            <table id="" class="table table-striped table-bordered nowrap data_table">
                                <thead>
                                    <tr>
                                        <th></th>
                                        <th>Account No.</th>
                                        <th>User</th>
                                        <th>Phone</th>
                                        <th>Email</th>
                                        <th>Order No.</th>
                                        <th>Package</th>
                                        <th>Start Date</th>
                                        <th>End Date</th>
                                        <th>Status</th>
                                        <th>Date Time</th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

@include('include.datatable')
@include('include.filters-common-js-part')
@include('include.datatable-date-range-selector-js', ['url' => 'expired-packages-report'])
@endsection
{{-- Page specific JS --}}
@push('scripts')

<script>
    var startDate = '';
    var endDate = '';
    listing();

    // listing the record
    function listing() {
        $(function() {
            if ($('.data_table').DataTable()) {
                $('.data_table').DataTable().destroy();
            }

            var table = $('.data_table').DataTable({
                ajax: {
                    url: "{{ route('expired-packages-report') }}",
                    data: function(d) {
                        d.startDate = startDate;
                        d.endDate = endDate;
                    }
                },
                fixedHeader: true,
                fixedColumns: {
                    leftColumns: 1,
                    rightColumns: 1,
                },
                order: [
                    [0, 'desc']
                ],
                columns: [{
                        data: 'id',
                        name: 'id',
                        searchable: true,
                        visible: false
                    },
                    {
                        data: 'account',
                        name: 'account'
                    },
                    {
                        data: 'user',
                        name: 'user'
                    },
                    {
                        data: 'phone',
                        name: 'phone'
                    },
                    {
                        data: 'email',
                        name: 'email'
                    },
                    {
                        data: 'order',
                        name: 'order'
                    },
                    {
                        data: 'package',
                        name: 'package'
                    },
                    {
                        data: 'start_date',
                        name: 'start_date'
                    },
                    {
                        data: 'end_date',
                        name: 'end_date'
                    },
                    {
                        data: 'status',
                        name: 'status'
                    },
                    {
                        data: 'datetime',
                        name: 'datetime'
                    },
                ],
            });
            // Manually create and place the buttons
            new $.fn.dataTable.Buttons(table, {
                buttons: [{
                        extend: 'copyHtml5',
                        text: 'Copy'
                    },
                    {
                        extend: 'csvHtml5',
                        text: 'CSV'
                    },
                    {
                        extend: 'excelHtml5',
                        text: 'Excel'
                    },
                    {
                        extend: 'pdfHtml5',
                        text: 'PDF'
                    }
                ]
            });

            // Place the buttons manually (for example, before the table)
            table.buttons().container().appendTo('.buttons-container');
            $('.buttons-html5').hide();
        });
    }

    $(document).on('click', '.deleteSelSingle', function(e) {
        e.preventDefault();
        text = 'you want to delete ?';
        const swalWithBootstrapButtons = Swal.mixin({
            customClass: {
                confirmButton: 'btn btn-success',
                cancelButton: 'btn btn-danger'
            },
            buttonsStyling: false
        });
        swalWithBootstrapButtons
            .fire({
                title: 'Are you sure?',
                text: text,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: 'Yes',
                cancelButtonText: 'No',
                reverseButtons: true
            })
            .then((result) => {
                if (result.isConfirmed) {
                    url = $(this).attr('data-url');
                    var favorite = [];
                    favorite.push($(this).attr('data-val'));
                    var ids = favorite.join(",");
                    $.ajax({
                        url: url,
                        type: 'POST',
                        data: {
                            "ids": ids
                        },
                        success: function(res) {
                            if (res.status == true) {
                                window.location.reload();
                            }
                        }
                    });
                } else if (result.dismiss === Swal.DismissReason.cancel) {
                    swalWithBootstrapButtons.fire('Cancelled', '', 'error');
                }
            });
    });

    $(document).ready(function() {
        $("#join-date").datepicker();
    });

    $(document).on('keyup', '.filter-input', function() {
        val = $(this).val();
        col = $(this).attr('data-col');
        filter(val, col);
    })

    function filter(val, col) {
        $('.data_table').DataTable().column(col).search(val, true, false).draw();
    }
</script>

@endpush