@extends("agentportal.layouts.layout")

@section("title", trans("message_lang.LBL_LOCATION_TRANSACTIONS"))

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.css') }}">
@endsection

<div id="loading"  style="display:none;">
    <div id="image-loader">
        <img  src="{{ url('img/loading.gif')}}" alt="Loading..." />
    </div>
</div>
@section("content")
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
    <!--begin::Subheader-->
    <!--end::Subheader-->
    <!--begin::Entry-->
    <div class="d-flex flex-column-fluid">
        <!--begin::Container-->
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <!--begin::Card-->
                    <div class="card card-custom gutter-b example1 example1-compact">
                        <div class="card-header">
                            <h3 class="card-title">
                                {!! trans("message_lang.LBL_LOCATION_TRANSACTIONS") !!}
                            </h3>
                            <div class="card-toolbar">
                                <!--begin::Button-->
                                <a href="{{ url('agentportal/dashboard') }}" class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                <!--end::Button-->
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <div class="example1">
                                <div class="example1-preview">
                                    @if (session('notValidCodes'))
                                    <h5 class="">{!! trans("message_lang.LBL_INVALID_PICKUP_CODE") !!}: <span class="badge badge-danger">{{ implode(', ', session('notValidCodes')) }}</span>
                                    </h5>
                                    @endif

                                    @if (session('duplicateCodes'))
                                    <h5 class="">{!! trans("message_lang.LBL_ALREADY_IMPORTED_PICKUP_CODE") !!}: <span class="badge badge-warning">{{ implode(', ', session('duplicateCodes')) }}</span>
                                    </h5>
                                    @endif

                                    <ul class="nav nav-tabs" id="myTab" role="tablist">
                                        <li class="nav-item">
                                            <a class="nav-link active" id="paid-tab" data-toggle="tab" href="#paid" role="tab" aria-controls="paid" aria-selected="true">
                                                {!! trans("message_lang.BTN_PAID") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="imported-tab" data-toggle="tab" href="#imported" role="tab" aria-controls="imported" aria-selected="false">
                                                {!! trans("message_lang.BTN_IMPORTED") !!}
                                            </a>
                                        </li>
                                    </ul>
                                    <div class="tab-content" id="myTabContent">
                                        <div role="tabpanel" aria-labelledby="paid-tab" id="paid" class="tab-pane fade active show">
                                            <!--begin::Card-->
                                            <div class="card card-custom">
                                                <div class="card-header">
                                                    <div class="card-title">
                                                        <h3 class="card-label">{!! trans("message_lang.LBL_PAID") !!}</h3>
                                                    </div>
                                                    <div class="card-toolbar">

                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    <form method="POST" action="{{ url('agentportal/payments/reconcile/csvExport') }}" name="form">
                                                        @csrf
                                                        <div class="form-group row justify-content-end">
                                                            <div class="col-md-3">
                                                                <input type="hidden" name="has_paid" value="1" id="has_paid" class="form-control custom-field" required />
                                                            </div>
                                                            <div class="col-md-3">
                                                                <button type="submit" name="export" class="btn btn-primary font-weight-bolder float-right">{!! trans("message_lang.LBL_EXPORT_TO_CSV") !!}</button>
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <div class="col-md-3" style="display: @hasanyrole('administrator') block @else none @endhasanyrole;">
                                                                <label class="" for="agent_country_id">{!! trans("message_lang.LBL_COUNTRY") !!} <span style="color:red;"></span></label>
                                                                <select name="agent_country_id" id="agent_country_id" class="form-control custom-field">
                                                                    <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                                                    @foreach ($agentCountries as $key => $agentCountry)
                                                                    <option value="{{ $key }}" @hasanyrole('operation|finance back office') @if (auth()->guard('agentportal')->user()->country_id == $key) selected @endif @endhasanyrole>{{ $agentCountry }}</option>
                                                                    @endforeach
                                                                </select>
                                                            </div>
                                                            <div class="col-md-3">
                                                                <label class="" for="agent_company_id">{!! trans("message_lang.LBL_COMPANY") !!} <span style="color:red;"></span></label>
                                                                <select name="agent_company_id" id="agent_company_id" class="form-control custom-field">
                                                                    <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                                                    @foreach ($agentCompanies as $key => $agentCompany)
                                                                    <option value="{{ $agentCompany->id }}">{{ $agentCompany->name }}</option>
                                                                    @endforeach
                                                                </select>
                                                            </div>
                                                            <div class="col-md-3">
                                                                <label class="" for="status">{!! trans("message_lang.LBL_STATUS") !!} <span style="color:red;"></span></label>
                                                                <select name="status" id="status" class="form-control custom-field">
                                                                    <option value="">All</option>
                                                                    <option value="0">Unmatched</option>
                                                                    <option value="1">Matched</option>
                                                                </select>
                                                            </div>
                                                            <div class="col-md-3">
                                                                <label class="" for="source">{!! trans("message_lang.LBL_SOURCE") !!} <span style="color:red;"></span></label>
                                                                <select name="source[]" id="source" class="form-control custom-field" multiple>
                                                                    <option value="">{!! trans("message_lang.STATUS_OPTION_ALL") !!}</option>
                                                                    @foreach (config('constants.SOURCES') as $key => $source)
                                                                    <option value="{{ $key }}">{{ ucfirst($source) }}</option>
                                                                    @endforeach
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <div class="col-md-4">
                                                                <label for="from_date">{{ trans('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                                                <input type="text" name="from_date" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" id="from_date" class="form-control custom-field">
                                                            </div>
                                                            <div class="col-md-4">
                                                                <label for="to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                                                <input type="text" name="to_date" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" id="to_date" class="form-control custom-field">
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <button type="button" class="btn btn-primary" id="apply-filter-paid" data-count=0>{!! trans("message_lang.BTN_SEARCH") !!}</button> &nbsp; &nbsp;
                                                            <button type="button" class="btn btn-secondary" id="apply-filter-clear-paid">{!! trans("message_lang.BTN_CLEAR_SEARCH") !!}</button>
                                                        </div>
                                                    </form>
                                                    <!--begin: Datatable-->
                                                    <table id="datatable" class="table table-bordered grid-table nowrap">
                                                        <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>{!! trans('message_lang.LBL_PICKUP_CODE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_LOCATION') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_USER') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_COMPANY') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_TXN_DATE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_AMOUNT_BY_USER') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_PAID_DATE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_SOURCE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_NOTES') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_ACTION') !!}</th>
                                                            </tr>
                                                        </thead>
                                                    </table>
                                                    <!--end: Datatable-->
                                                </div>
                                            </div>
                                            <!--end::Card-->
                                        </div>
                                        <div role="tabpanel" aria-labelledby="imported-tab" id="imported" class="tab-pane fade">
                                            <!--begin::Card-->
                                            <div class="card card-custom">
                                                <div class="card-header">
                                                    <div class="card-title">
                                                        <h3 class="card-label">{!! trans("message_lang.LBL_IMPORTED") !!}</h3>
                                                    </div>
                                                    <div class="card-toolbar">

                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    <form method="POST" action="{{ url('agentportal/payments/reconcile/csvExport') }}" name="form">
                                                        @csrf
                                                        <div class="form-group row justify-content-end">
                                                            <div class="col-md-3">
                                                                <input type="hidden" name="has_paid" value="0" id="has_paid2" class="form-control custom-field" required />
                                                            </div>
                                                            <div class="col-md-3">
                                                                <button type="submit" name="export" class="btn btn-primary font-weight-bolder float-right">{!! trans("message_lang.LBL_EXPORT_TO_CSV") !!}</button>
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <div class="col-md-4" style="display: @hasanyrole('administrator') block @else none @endhasanyrole;">
                                                                <label class="" for="agent_country_id2">{!! trans("message_lang.LBL_COUNTRY") !!} <span style="color:red;"></span></label>
                                                                <select name="agent_country_id" id="agent_country_id2" class="form-control custom-field">
                                                                    <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                                                    @foreach ($agentCountries as $key => $agentCountry)
                                                                    <option value="{{ $key }}" @hasanyrole('operation|finance back office') @if (auth()->guard('agentportal')->user()->country_id == $key) selected @endif @endhasanyrole>{{ $agentCountry }}</option>
                                                                    @endforeach
                                                                </select>
                                                            </div>
                                                            <div class="col-md-4">
                                                                <label class="" for="agent_company_id2">{!! trans("message_lang.LBL_COMPANY") !!} <span style="color:red;"></span></label>
                                                                <select name="agent_company_id" id="agent_company_id2" class="form-control custom-field">
                                                                    <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                                                    @foreach ($agentCompanies as $key => $agentCompany)
                                                                    <option value="{{ $agentCompany->id }}">{{ $agentCompany->name }}</option>
                                                                    @endforeach
                                                                </select>
                                                            </div>
                                                            <div class="col-md-4">
                                                                <label class="" for="status2">{!! trans("message_lang.LBL_STATUS") !!} <span style="color:red;"></span></label>
                                                                <select name="status" id="status2" class="form-control custom-field">
                                                                    <option value="">All</option>
                                                                    <option value="0">Unmatched</option>
                                                                    <option value="1">Matched</option>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <div class="col-md-4">
                                                                <label for="from_date2">{{ trans('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                                                <input type="text" name="from_date" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" id="from_date2"
                                                                    class="form-control custom-field">
                                                            </div>
                                                            <div class="col-md-4">
                                                                <label for="to_date2">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                                                <input type="text" name="to_date" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" id="to_date2"
                                                                    class="form-control custom-field">
                                                            </div>
                                                        </div>
                                                        <div class="form-group row justify-content-md-center">
                                                            <button type="button" class="btn btn-primary" id="apply-filter-imported" data-count=0>{!! trans("message_lang.BTN_SEARCH") !!}</button> &nbsp; &nbsp;
                                                            <button type="button" class="btn btn-secondary" id="apply-filter-clear-imported">{!! trans("message_lang.BTN_CLEAR_SEARCH") !!}</button>
                                                        </div>
                                                    </form>
                                                    <!--begin: Datatable-->
                                                    <table id="datatable2" class="table table-bordered grid-table nowrap">
                                                        <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>{!! trans('message_lang.LBL_PICKUP_CODE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_LOCATION') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_USER') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_COMPANY') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_TXN_DATE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_AMOUNT_BY_USER') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_PAID_DATE') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_NOTES') !!}</th>
                                                                <th>{!! trans('message_lang.LBL_ACTION') !!}</th>
                                                            </tr>
                                                        </thead>
                                                    </table>
                                                    <!--end: Datatable-->
                                                </div>
                                            </div>
                                            <!--end::Card-->
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <!--begin: Modal-->
                            <div class="modal fade" id="exampleModalCenter" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle"
                                aria-hidden="true">
                                <div class="modal-dialog modal-dialog-centered" role="document">
                                    <form method="post" name="form" action="{{ url('agentportal/payments/reconcile/update') }}" id="form" class="modal-content" enctype="multipart/form-data" autocomplete="off">
                                        @csrf
                                        <input type="hidden" name="agent_paid_transaction_id" value="" id="agent_paid_transaction_id">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="exampleModalCenterTitle">{!! trans("message_lang.LBL_EDIT_RECONCILE") !!}</h5>
                                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body">
                                            <div class="form-group row">
                                                <div class="col-md-12">
                                                    <label class="" for="pickup_code">{!! trans("message_lang.LBL_PICKUP_CODE") !!} <span style="color:red;">*</span></label>
                                                    <input onKeypress="return event.charCode != 32" type="text" pattern="[0-9a-zA-Z_.-]*"
                                                        name="pickup_code" placeholder="Pickup Code" value="{{ old('pickup_code') }}"
                                                        id="pickup_code"
                                                        class="form-control @error('pickup_code') is-invalid @enderror custom-field" />
                                                    @error('pickup_code')
                                                    <span class="invalid-feedback" role="alert">
                                                        <strong>{{ $message }}</strong>
                                                    </span>
                                                    @enderror
                                                </div>
                                            </div>
                                        </div>
                                        <div class="modal-footer">
                                            <button type="reset" class="btn btn-secondary"
                                                data-dismiss="modal">{{ trans('message_lang.BUTTON_CANCEL') }}</button>
                                            <button type="submit" class="btn btn-primary">{!! trans("message_lang.BTN_RECONCILE") !!}</button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                            <!--end: Modal-->
                        </div>

                        <div class="card-footer">

                        </div>
                        <!--end::Form-->
                    </div>
                    <!--end::Card-->
                </div>
            </div>
        </div>
        <!--end::Container-->
    </div>
    <!--end::Entry-->
</div>
@endsection

@section("page_vendors")
<script src="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.js') }}"></script>
@endsection

@section("page_script")
<script type="text/javascript">
    var datatable;
    var datatable2;
    $(document).ready(function () {
        $('#from_date, #to_date, #from_date2, #to_date2').datepicker({
            "format": "yyyy-mm-dd",
            "keyboardNavigation": false,
            "autoclose": true,
            "startDate": '-2y -1m',
            "endDate": new Date()
        });

        $('#from_date, #from_date2').datepicker().on('changeDate', function (selected) {
            {{-- datatable.draw(); // Refilter the table
            datatable2.draw(); // Refilter the table --}}
            $('#to_date, #to_date2').datepicker('setStartDate', new Date(selected.date.valueOf()));
        });

        $('#to_date, #to_date2').datepicker().on('changeDate', function (selected) {
            {{-- datatable.draw(); // Refilter the table
            datatable2.draw(); // Refilter the table --}}
        });

        $('#status, #status2, #agent_company_id, #agent_company_id2, #agent_country_id, #agent_country_id2').on('change', function() {
            {{-- datatable.draw(); // Refilter the table
            datatable2.draw(); // Refilter the table --}}
        });

        $('#source').select2({
            placeholder: "{{ trans('message_lang.LBL_ALL') }}",
        });

        $(document).on("click", "#apply-filter-paid", function() {
            var count = $(this).data("count") || 0;
            if(count > 0) {
                datatable.draw();
            } else {
                datatable = $('#datatable').DataTable({
                    language: {
                        lengthMenu: "{!! trans('message_lang.DATATABLE_LBL_SHOW') !!} _MENU_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        search: "{!! trans('message_lang.DATATABLE_LBL_SEARCH') !!}",
                        emptyTable: "{!! trans('message_lang.DATATABLE_LBL_NO_DATA_AVAILABLE') !!}",
                        info: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} _START_ {!! trans('message_lang.DATATABLE_LBL_TO') !!} _END_ {!! trans('message_lang.DATATABLE_LBL_OF') !!} _TOTAL_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoEmpty: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_TO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_OF') !!} 0 {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoFiltered:   "({!! trans('message_lang.DATATABLE_FILTERED_FROM') !!} _MAX_ {!! trans('message_lang.DATATABLE_TOTAL_ENTRIES') !!})",
                        zeroRecords: "{!! trans('message_lang.DATATABLE_NO_MATCHING_RECORD_FOUND') !!}",
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                    pageLength: 50,
                    aaSorting: [10, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/payments/reconcile/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: function(data) {
                            data.has_paid = $('#has_paid').val() || 1;
                            data.from_date = $('#from_date').val();
                            data.to_date = $('#to_date').val();
                            data.status = $('#status').val();
                            data.source = $('#source').val();
                            data.agent_company_id = $('#agent_company_id').val();
                            data.agent_country_id = $('#agent_country_id').val();
                        },
                        error: function (xhr, error, code) {
                            $("#loading").hide();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0, 10], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        // {
                        //     targets: [3, 5, 8], // column index
                        //     searchable: false,
                        // },
                        {
                            targets: [11], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'pickup_code',
                            name: 'pickup_code',
                            render: function(data, type, row) {
                                return '<a href="' + row.data.url + '">' + data + '</a>';
                            }
                        },
                        {
                            data: 'location',
                            name: 'location'
                        },
                        {
                            data: 'user',
                            name: 'user'
                        },
                        {
                            data: 'company',
                            name: 'company'
                        },
                        {
                            data: 'transaction_date',
                            name: 'transaction_date'
                        },
                        {
                            data: 'mamount',
                            name: 'mamount'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'source',
                            name: 'source'
                        },
                        {
                            data: 'notes',
                            name: 'notes'
                        },
                        {
                            data: 'action',
                            name: 'action'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                    // dom: 'lBfrtip',
                    // dom: '<"row"<"col-sm-3"l><"col-sm-6"B><"col-sm-3"f>>' +
                    //     '<"row"<"col-sm-12"tr>>' +
                    //     '<"row"<"col-sm-5"i><"col-sm-7"p>>',
                    // buttons: [
                    //     {
                    //         extend: 'csv',
                    //         text: 'Export to CSV',
                    //         filename: 'Location Paid Transactions',
                    //         className: 'datatableBtn',
                    //         exportOptions: {
                    //             columns: ':visible:not(:last-child)'
                    //         }
                    //     }
                    // ]
                }).on( 'preDraw', function () {
                    $("#loading").show();
                } ).on("draw", function() {
                    $("#loading").hide();
                });
            }
            $(this).data("count", ++count);
        });

        $(document).on("click", "#apply-filter-clear-paid, #apply-filter-clear-imported", function() {
            window.location.reload();
        });

        $(document).on("click", "#apply-filter-imported", function() {
            var count1 = $(this).data("count") || 0;
            if(count1 > 0) {
                datatable2.draw();
            } else {
                datatable2 = $('#datatable2').DataTable({
                    language: {
                        lengthMenu: "{!! trans('message_lang.DATATABLE_LBL_SHOW') !!} _MENU_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        search: "{!! trans('message_lang.DATATABLE_LBL_SEARCH') !!}",
                        mptyTable: "{!! trans('message_lang.DATATABLE_LBL_NO_DATA_AVAILABLE') !!}",
                        info: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} _START_ {!! trans('message_lang.DATATABLE_LBL_TO') !!} _END_ {!! trans('message_lang.DATATABLE_LBL_OF') !!} _TOTAL_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoEmpty: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_TO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_OF') !!} 0 {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoFiltered:"({!! trans('message_lang.DATATABLE_FILTERED_FROM') !!} _MAX_ {!! trans('message_lang.DATATABLE_TOTAL_ENTRIES') !!})",
                        zeroRecords: "{!! trans('message_lang.DATATABLE_NO_MATCHING_RECORD_FOUND') !!}",
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                    pageLength: 50,
                    aaSorting: [10, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/payments/reconcile/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: function(data) {
                            data.has_paid = $('#has_paid2').val() || 0;
                            data.from_date = $('#from_date2').val();
                            data.to_date = $('#to_date2').val();
                            data.status = $('#status2').val();
                            data.agent_company_id = $('#agent_company_id2').val();
                            data.agent_country_id = $('#agent_country_id2').val();
                        },
                        error: function (xhr, error, code) {
                            $("#loading").hide();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0, 9], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        // {
                        //     targets: [3, 5, 8], // column index
                        //     searchable: false,
                        // },
                        {
                            targets: [10], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'pickup_code',
                            name: 'pickup_code',
                            render: function(data, type, row) {
                                return '<a href="' + row.data.url + '">' + data + '</a>';
                            }
                        },
                        {
                            data: 'location',
                            name: 'location'
                        },
                        {
                            data: 'user',
                            name: 'user'
                        },
                        {
                            data: 'company',
                            name: 'company'
                        },
                        {
                            data: 'transaction_date',
                            name: 'transaction_date'
                        },
                        {
                            data: 'mamount',
                            name: 'mamount'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'notes',
                            name: 'notes'
                        },
                        {
                            data: 'action',
                            name: 'action'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                    // dom: 'lBfrtip',
                    // dom: '<"row"<"col-sm-3"l><"col-sm-6"B><"col-sm-3"f>>' +
                    //     '<"row"<"col-sm-12"tr>>' +
                    //     '<"row"<"col-sm-5"i><"col-sm-7"p>>',
                    // buttons: [
                    //     {
                    //         extend: 'csv',
                    //         text: 'Export to CSV',
                    //         filename: 'Location Imported Transactions',
                    //         className: 'datatableBtn',
                    //         exportOptions: {
                    //             columns: ':visible:not(:last-child)'
                    //         }
                    //     }
                    // ]
                }).on( 'preDraw', function () {
                    $("#loading").show();
                } ).on("draw", function() {
                    $("#loading").hide();
                });
            }
            $(this).data("count", ++count1);
        });

        $(document).on('click', '.edit', function() {
            $('#agent_paid_transaction_id').val($(this).data('id'));
            $('#pickup_code').val($(this).data('value'));
        });
    });
</script>
@endsection