@extends('adminlte::page')

@section('title', 'Dail Reports')

@section('content')
<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1>Expire Subscription Report</h1>
            </div>
            <div class="col-sm-6">
                <ol class="breadcrumb float-sm-right">
                    <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">Home</a></li>
                    <li class="breadcrumb-item active">Expire Subscription Report</li>
                </ol>
            </div>
        </div>
    </div>
</section>

<section class="content">
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header row">
                        <div class="col-6">
                            <h3 class="card-title">Expire Subscription Report</h3>
                        </div>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <div class="row p-0">
                            <div class="col-md-4 pr-2">
                                <select name="" id="plan" class="form-control ">
                                    <option value="">Select Subscription</option>
                                    @for($i = 1; $i<=5; $i++)
                                        <option value="{{$i}}">{{ getListingType($i) }}</option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-md-4 mb-2">
                                <select id="category" class="form-control">
                                    <option value="">Filter By Category</option>
                                    @foreach($categories as $category)
                                        <option value="{{$category->id}}"> {{ $category->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4 pl-2">
                                <select id="region" class="form-control w-100">
                                    <option value="">Filter By Regions</option>
                                    @foreach($regions as $region)
                                        <option value="{{$region->id}}"> {{ $region->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="form-group mb-2 row p-2">
                            <div class="input-group">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">
                                        <i class="far fa-calendar-alt"></i>
                                    </span>
                                </div>
                                <input type="text" class="form-control float-right" name="datetimes" id="datetimes">
                            </div>
                            <!-- /.input group -->
                        </div>
                        <table id="exmple" class="table table-bordered table-hover" style="width: 100%;">
                            <thead>
                                <tr>
                                    <th>Listing</th>
                                    <th>Subscription Type</th>
                                    <th>Merchant Name</th>
                                    <th>Merchant Email</th>
                                    <th>From Date</th>
                                    <th>To Date</th>
                                    <th>Expired At</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection

@section('js')

    <script>

        $('input[name="datetimes"]').daterangepicker({
            startDate: moment().startOf('day').subtract(360, 'day'),
            endDate: moment().startOf('day'),
            locale: {
                format: 'Y/M/DD'
            }
        });


        DTable = $("#exmple").DataTable({
                    ajax: {
                        url : "{{ route('ajax.expire-subscription-report') }}",
                        data: function (d) {
                            return $.extend( {}, d, {
                                "category" : $("#category").val(),
                                "region" : $("#region").val(),
                                "subscription_plan" : $("#plan").val(),
                                "date_range" : $("#datetimes").val()
                            });
                        }
                    },
                    processing: true,
                    serverSide: true,
                    bDestroy: true,
                    columns: [
                        {data: 'listing_url', name: 'listing_url'},
                        {data: 'payment_type', name: 'payment_type'},
                        {data: 'merchant_name', name: 'merchant_name'},
                        {data: 'merchant_email', name: 'merchant_email'},
                        {data: 'from_date', name: 'from_date'},
                        {data: 'to_date', name: 'to_date'},
                        {data: 'to_date', name:'to_date'},

                    ]
                });


        $(document).on("change", "select,input", function() {
            DTable.draw();
        });

        $('input[name="datetimes"]').on('apply.daterangepicker', function(ev, picker) {
            DTable.draw();
        });
    </script>
@endsection