@extends('adminlte::page')

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

@section('content')
<style>
    .dataTables_length{
        display: inline-flex;
        width:55%;
    }

    .dataTables_filter{
        display: inline-flex;
        width:25%;
    }
    .dt-buttons {
        display: inline-flex;
        width:20%;
    }
    .dataTables_scroll {
    overflow: auto;
    position: relative;
    border: 0px;
    width: 100%;
}

.dataTables_scrollHead {
    overflow: visible !important;
}

.dataTables_scrollBody {
    overflow: visible !important;
}
</style>
<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1>Income 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">Income 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">Income Report</h3>
                        </div>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <div class="row p-0">
                            <div class="col-md-3 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>
                            <select id="category" class="form-control col-md-3 mb-2">
                                <option value="">Filter By Category</option>
                                @foreach($categories as $category)
                                    <option value="{{$category->id}}"> {{ $category->name }}</option>
                                @endforeach
                            </select>
                            <div class="col-md-3 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 class="col-md-3 pl-2">
                                <select id="paymentType" class="form-control w-100">
                                    <option value="">Filter By Payment Type</option>
                                    <option value="1">By Bank</option>
                                    <option value="2">By Cheque</option>
                                    <option value="3">By Card</option>
                                </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>Amount</th>
                                    <th>Subsciption Type</th>
                                    <th>Merchant Name</th>
                                    <th>Merchant Email</th>
                                    <th>Payment ID</th>
                                    <th>Payment Type</th>
                                    <th>From Date</th>
                                    <th>To Date</th>
                                    <th>Create 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 hh:mm A'
            },
            maxDate: moment(),
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
                'Quarterly': [moment().subtract(3, 'month').startOf('month'),moment().endOf('month')],
            },
        });

        DTable = $("#exmple").DataTable({
                    ajax: {
                        url : "{{ route('ajax.report') }}",
                        data: function (d) {
                            return $.extend( {}, d, {
                                "category" : $("#category").val(),
                                "region" : $("#region").val(),
                                "subscription_plan" : $("#plan").val(),
                                "date_range" : $("#datetimes").val(),
                                "date_range" : $("#datetimes").val(),
                                "paymentType" : $("#paymentType").val()
                            });
                        }
                    },
                    dom :"lfBtipr",
                    processing: true,
                    serverSide: true,
                    bDestroy: true,
                    buttons: [
                        {
                            extend: 'pdfHtml5',
                            title: 'Income Report',
                            customize : function(doc){
                                // doc.content[1].table.widths = '10%',
                                doc.styles.tableBodyEven.alignment = 'center',
                                doc.styles.tableBodyOdd.alignment = 'center',
                                doc.styles['td:nth-child(5)'] = { 
                                width: '100px',
                                'max-width': '100px'
                                }
                            },
                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9],
                            orientation: 'landscape',
                            pageSize: 'LEGAL'
                        },
                        {
                            extend: 'excel',
                            title: 'Income Report',
                            exportOptions: {
                                columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
                            }

                        }
                    ],
                    scrollY:        150,
                    deferRender:    true,
                    scroller:       true,
                    columns: [
                        {data: 'listing_url', name: 'listing_url'},
                        {data: 'amount', name: 'amount'},
                        {data: 'payment_type', name: 'payment_type'},
                        {data: 'merchant_name', name: 'merchant_name'},
                        {data: 'merchant_email', name: 'merchant_email'},
                        {data: 'invoice_id', name: 'invoice_id'},
                        {data: 'payment_method', name: 'payment_method'},
                        {data: 'from_date', name:'from_date'},
                        {data: 'to_date', name:'to_date'},
                        {data: 'created_at', name:'created_at'},

                    ]
                });


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

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