@extends('layouts.admin')

@section('ext_css')
    <link rel="stylesheet" href="{{ asset('/NepaliDatepicker/nepali.datepicker.v2.2.min.css') }}"/>
    <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/1.1.1/css/bootstrap-multiselect.css" />
    <style type="text/css">
        .btn-group {
            width: 100%;
        }
        button.multiselect.dropdown-toggle.custom-select.text-center {
            width: 100%;
            padding: 5px;
        }
        button.dropdown-item.multiselect-all {
            width: 100%;
        }
        button.multiselect-option.dropdown-item {
            width: 100%;
        }
        span.form-check {
            float: left;
        }
    </style>
@endsection

@section('content')

    <div class="row">
        <ol class="breadcrumb">
            <li><a href="{{ route('admin.dashboard') }}"><i class="fa fa-dashboard"></i> Dashboard</a></li>
            <li class="active"> Billing Inquiry </li>
        </ol>
    </div>

    @if(session('success'))
        <div class="alert alert-success alert-dismissable">
            <button class="close" data-dismiss="alert"><i class="fa fa-times-circle"></i></button>
            <strong>Success !</strong>
            {!! Session::get('success') !!}
        </div>
    @elseif(session('failure'))
        <div class="alert alert-danger alert-dismissable">
            <button class="close" data-dismiss="alert"><i class="fa fa-times-circle"></i></button>
            <strong>Failed !</strong> {{ Session::get('failure') }}
        </div>
    @endif

    <div class="panel panel-default">
        <div class="panel-heading">
            <h3 class="panel-title"> Billing Inquiry </h3>
        </div>
        <div class="panel-body">
            <div class="row">
                <form method="get" class="form-horizontal form-padding">
                    <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                        <div class="form-group">
                            <div class="col-md-3">
                                <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                    Category
                                </label>
                                <select name="category[]" id="category" class="form-control" multiple>
                                    @foreach($categories as $category)
                                        <option value="{{$category->id}}" @if(in_array($category->id, request()->category ?? [])) selected @endif>{{$category->name}}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                    Sub-category
                                </label>
                                <select name="sub_category[]" id="sub_category" class="form-control">
                                    <option disabled="true" selected="true" value="">--All--</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                    Merchant
                                </label>
                                <select name="merchant[]" id="merchant" class="form-control">
                                    <option disabled="true" selected="true" value="">--All--</option>
                                </select>
                            </div>

                            <div class="col-md-3">
                                <label class="control-label" for="apis" style="margin-bottom: 10px;">API</label>
                                <select id="apis" name="apis[]" class="form-control" multiple>
                                    @foreach($apis as $api)
                                        <option value="{{$api->id}}" @if(request()->apis && in_array($api->id, request()->apis)) selected @endif>
                                            {{$api->name}}
                                        </option>
                                    @endforeach
                                </select>
                                <small class="help-block text-danger">{{ $errors->first('apis')}}</small>
                            </div>
                            
                            <div class="col-md-12">
                                <div class="row">
                                    <div class="col-md-6 geo_filter">
                                        <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                            From Date (B.S.)
                                        </label><strong class="text-danger">*</strong>
                                        <input type="text" class="form-control readonly" name="nep_from_date"
                                               value="{{request()->nep_from_date}}"
                                               placeholder="Date From" id="nepFromDate" autocomplete="off"
                                               required/>
                                        <small class="help-block text-danger">{{ $errors->first('nep_from_date')}}</small>
                                    </div>
                                    <div class="col-md-6 geo_filter">
                                        <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                            To Date (B.S.)
                                        </label><strong class="text-danger">*</strong>
                                        <input type="text" class="form-control readonly" name="nep_to_date"
                                               value="{{request()->nep_to_date}}"
                                               placeholder="To Date" id="nepToDate" autocomplete="off" required/>
                                        <small class="help-block text-danger">{{ $errors->first('nep_to_date')}}</small>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-12">
                                <div class="row">
                                    <div class="col-md-6 geo_filter">
                                        <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                            From Date (A.D.)
                                        </label><strong class="text-danger">*</strong>
                                        <input type="text" class="form-control readonly" name="eng_from_date"
                                               value="{{request()->eng_from_date}}"
                                               placeholder="Date From" id="engFromDate" autocomplete="off"
                                               required/>
                                        <small class="help-block text-danger">{{ $errors->first('eng_from_date')}}</small>
                                    </div>
                                    <div class="col-md-6 geo_filter">
                                        <label class="control-label" for="demo-address-input" style="margin-bottom: 10px;">
                                            To Date (A.D.)
                                        </label><strong class="text-danger">*</strong>
                                        <input type="text" class="form-control readonly" name="eng_to_date"
                                               value="{{request()->eng_to_date}}"
                                               placeholder="To Date" id="engToDate" autocomplete="off" required/>
                                        <small class="help-block text-danger">{{ $errors->first('eng_to_date')}}</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="form-group">
                            <div class="col-md-12 text-center">
                                <button class="btn btn-primary">Generate</button>
                                @if (request()->eng_from_date && request()->eng_to_date)
                                    @php
                                        $export = '';
                                        foreach (request()->category ?? [] as $key => $category) {
                                            $export.='category['.$key.']='.$category.'&';
                                        }
                                    @endphp
                                    @php
                                        foreach (request()->sub_category ?? [] as $key => $sub_category) {
                                            $export.='sub_category['.$key.']='.$sub_category.'&';
                                        }
                                    @endphp
                                    @php
                                        foreach (request()->merchant ?? [] as $key => $merchant) {
                                            $export.='merchant['.$key.']='.$merchant.'&';
                                        }
                                    @endphp
                                    @php
                                        foreach (request()->apis ?? [] as $key => $merchant) {
                                            $export.='apis['.$key.']='.$merchant.'&';
                                        }
                                    @endphp
                                    <button class="btn btn-primary reset">Reset</button>
                                    <a href="{{ route('admin.billing.inquiry.export') }}?{{$export}}eng_from_date={{request()->eng_from_date}}&eng_to_date={{request()->eng_to_date}}&nep_from_date={{request()->nep_from_date}}&nep_to_date={{request()->nep_to_date}}" class="btn btn-primary">Export</a>
                                @else
                                    <button class="btn btn-primary reset" style="display: none;">Reset</button>
                                @endif
                            </div>
                        </div>
                    </div>
                </form>
            </div>
            @if(isset($merchants))
                <div class="table-responsive">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th>Bank Code</th>
                                <th>Institution Name</th>
                                <th>API</th>
                                <th>From Date</th>
                                <th>To Date</th>
                                <th>Total Count</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($merchants as $merchant)
                                @foreach($apis as $api)
                                    @if(request()->apis)
                                        @if(count(request()->apis) > 0 && in_array($api->id, request()->apis))
                                            <tr>
                                                <td>{{$merchant->bank_code}}</td>
                                                <td>{{$merchant->name}}</td>
                                                <td>{{$api->name}}</td>
                                                <td>{{$nep_from_date}}</td>
                                                <td>{{$nep_to_date}}</td>
                                                <td>{{$merchant->subjectCount($eng_from_date, $eng_to_date, $api->key)}}</td>
                                            </tr>
                                        @endif
                                    @else
                                        <tr>
                                            <td>{{$merchant->bank_code}}</td>
                                            <td>{{$merchant->name}}</td>
                                            <td>{{$api->name}}</td>
                                            <td>{{$nep_from_date}}</td>
                                            <td>{{$nep_to_date}}</td>
                                            <td>{{$merchant->subjectCount($eng_from_date, $eng_to_date, $api->key)}}</td>
                                        </tr>
                                    @endif
                                @endforeach
                            @endforeach
                        </tbody>
                    </table>
                </div>
            @endif
        </div>
    </div>
@endsection

@section('ext_js')
    <script src="{{ asset('/NepaliDatepicker/nepali.datepicker.v2.2.min.js') }}"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/1.1.1/js/bootstrap-multiselect.min.js" ></script>
    <script>
        $('#apis').multiselect({
            includeSelectAllOption: true
        })
        $('#category').multiselect({
            includeSelectAllOption: true
        })
        $("#weekStartDate, #weekEndDate").datepicker({
            dateFormat: 'yy-mm-dd',
            defaultDate: "+1w",
            maxDate: 0,
            changeMonth: true,
            onSelect: function (selectedDate) {
                var curr = new Date(selectedDate);
                var firstday = new Date(curr.setDate(curr.getDate() - curr.getDay()));
                var new_firstday = $.datepicker.formatDate('yy-mm-dd', firstday);
                var lastday = new Date(curr.setDate(curr.getDate() - curr.getDay() + 6));
                var new_lastday = $.datepicker.formatDate('yy-mm-dd', lastday);
                $("#weekStartDate").val(new_firstday);
                $("#weekEndDate").val(new_lastday);
            }
        });

        $("#engFromDate, #engToDate").datepicker({
            dateFormat: 'yy-mm-dd',
            defaultDate: "+1w",
            maxDate: 0,
            changeMonth: true,
            onSelect: function (selectedDate) {
                if (this.id == 'engFromDate') {
                    var dateMin = $('#engFromDate').datepicker("getDate");
                    var rMin = new Date(dateMin.getFullYear(), dateMin.getMonth(), dateMin.getDate());
                    $('#engToDate').datepicker("option", "minDate", rMin);
                    $.ajax({
                        headers: {
                            'X-CSRF-Token': $('meta[name="csrf_token"]').attr('content')
                        },
                        type: 'post',
                        url: '