@extends("agentportal.layouts.layout")

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

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.css') }}">
<link rel="stylesheet" type="text/css" href="{{ url('css/select2.min.css') }}">
<style type="text/css">
    .select2-container--default .select2-selection--single {
        min-height: 38px;
        max-height: 38px;
    }
</style>
@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_NETWORK_COMMISSION_REPORT") !!}
                            </h3>
                            <div class="card-toolbar">
                                @hasanyrole('administrator|operation|finance back office|tresorerie')
                                    <a href="{{ url('agentportal/summary') }}"class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                @endhasanyrole
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <form method="POST" action="{{ url('agentportal/networkCommissionReport/csvExport') }}" name="form">
                                @csrf
                                <div class="form-group row justify-content-end">
                                    <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="form-group col-md-3">
                                        <label class="" for="agent_country_id">{!! trans("message_lang.LBL_COUNTRY") !!} <span style="color:red;"></span></label><br/>
                                        <select name="agent_country_id" id="agent_country_id" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT_COUNTRY") !!}</option>
                                            @foreach ($agentCountries as $key => $country)
                                            <option value="{{ $country->id }}" {!! request()->has('country') && request()->get('country') == $country->id ? 'selected' : '' !!}>{{ $country->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                                <div class="form-group row justify-content-md-center">
                                    <div class="col-md-3">
                                        <label class="" for="agent_network_id">{!! trans("message_lang.LBL_NETWORK") !!} <span style="color:red;"></span></label><br/>
                                        <select name="agent_network_id" id="agent_network_id" class="form-control custom-field agent_network_id">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                        </select>
                                    </div>
                                    @if(request()->has('date'))
                                        <div class="col-md-3">
                                            <label for="from_date">{{ trans('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                            <input type="text" name="from_date" value="{{ app()->getLocale() == "fr" ? Carbon\Carbon::parse(request()->get('date'))->format('d-m-Y') : Carbon\Carbon::parse(request()->get('date'))->format('Y-m-d') }}" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" id="from_date" class="form-control custom-field">
                                        </div>
                                        <div class="col-md-3">
                                            <label for="to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                            <input type="text" name="to_date" value="{{ app()->getLocale() == "fr" ? Carbon\Carbon::parse(request()->get('date'))->format('d-m-Y') : Carbon\Carbon::parse(request()->get('date'))->format('Y-m-d') }}" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" id="to_date" class="form-control custom-field">
                                        </div>
                                    @else
                                        <div class="col-md-3">
                                            <label for="from_date">{{ trans('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                            <input type="text" name="from_date" value="{{ app()->getLocale() == "fr" ? Carbon\Carbon::now()->startOfMonth()->format('d-m-Y') : Carbon\Carbon::now()->startOfMonth()->format('Y-m-d') }}" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" id="from_date" class="form-control custom-field">
                                        </div>
                                        <div class="col-md-3">
                                            <label for="to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                            <input type="text" name="to_date" value="{{ app()->getLocale() == "fr" ? Carbon\Carbon::now()->format('d-m-Y') : Carbon\Carbon::now()->format('Y-m-d') }}" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" id="to_date" class="form-control custom-field">
                                        </div>
                                    @endif
                                    <div class="col-md-3">
                                        <label class="" for="commission_type">{!! trans("message_lang.LBL_COMMISSION_TYPE") !!} <span style="color:red;"></span></label><br/>
                                        <select name="commission_type" id="commission_type" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                            <option value="paid">{!! trans("message_lang.LBL_PAID") !!}</option>
                                            <option value="sent">{!! trans("message_lang.LBL_SENT") !!}</option>
                                        </select>
                                    </div>
                                </div>
                            </form>
                            <!--begin: Datatable-->
                            <table id="datatable" class="table table-bordered grid-table nowrap">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>{!! trans("message_lang.LBL_DATE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_REFERENCE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_COMMISSION_TYPE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_NETWORK") !!}</th>
                                        <th>{!! trans("message_lang.LBL_LOCATION") !!}</th>
                                        <th>{!! trans("message_lang.LBL_AMOUNT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_SENDING_FEES") !!}</th>
                                        <th>{!! trans("message_lang.LBL_NETWORK_COMMISSION") !!}</th>
                                        <th>{!! trans("message_lang.LBL_LOCATION_COMMISSION") !!}</th>
                                        <th>{!! trans("message_lang.LBL_NET_DUE") !!}</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>
                            <!--end: Datatable-->
                        </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>
<script src="{{ url('js/select2.min.js') }}"></script>
@endsection

@section("page_script")
    <script>

        $(document).ready(function() {
            // initialize the datatable
            var datatable;

            // set the date time picker on the date from and to input fields
            $('#from_date, #to_date').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
                "startDate": '-2y -1m',
                "endDate": new Date()
            });

            // filtering the data table on changing the filters
            $('#from_date').datepicker().on('change', function (selected) {
                GenerateTable(); // Refilter the table
            });

            $('#to_date').datepicker().on('change', function (selected) {
                GenerateTable(); // Refilter the table
            });

            $('#agent_network_id').on('change', function(){
                GenerateTable();
            });

            $('#commission_type').on('change', function(){
                GenerateTable();
            })

            $('#agent_country_id').on('change', function() {
                $.ajax({
                    url: "{{ url('agentportal/networkCommissionReport/ajaxNetwork') }}",
                    type: "POST",
                    headers: {
                        'X-CSRF-TOKEN': "{{ csrf_token() }}"
                    },
                    data: {agent_country_id: $('#agent_country_id').val() },
                    success: function(result)
                    {
                        $("#agent_network_id").html(result);
                        GenerateTable();
                    }
                });
            });

            // updating the table data
            function GenerateTable()
            {
                if($.fn.dataTable.isDataTable(datatable)) {
                    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') !!}",
                            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,
                        pageLength: 50,
                        bPaginate: true,
                        ajax: {
                            url: "{{ url('agentportal/networkCommissionReport/ajaxDatatable') }}",
                            type: "POST",
                            dataType: "json",
                            headers: {
                                'X-CSRF-TOKEN': "{{ csrf_token() }}"
                            },
                            data: function(data) {
                                data.from_date = $('#from_date').val();
                                data.to_date = $('#to_date').val();
                                data.agent_country_id = $("#agent_country_id").val();
                                data.agent_network_id = $("#agent_network_id").val();
                                data.commission_type = $("#commission_type").val();
                            },
                        },
                        columnDefs: [
                            {
                                targets: [0], // first column & numbering column
                                orderable: false, // set not orderable
                            },

                        ],
                        columns: [
                            {
                                data: 'DT_RowIndex',
                                name: 'DT_RowIndex'
                            },
                            {
                                data: 'date',
                                name: 'date'
                            },
                            {
                                data: 'reference',
                                name: 'reference'
                            },
                            {
                                data: 'type',
                                name: 'type'
                            },
                            {
                                data: 'agent_network_name',
                                name: 'agent_network_name'
                            },
                            {
                                data: 'agent_location_name',
                                name: 'agent_location_name'
                            },
                            {
                                data: 'amount',
                                name: 'amount'
                            },
                            {
                                data: 'sending_fee',
                                name: 'sending_fee'
                            },
                            {
                                data: 'network_commission',
                                name: 'network_commission'
                            },
                            {
                                data: 'credit_amount',
                                name: 'credit_amount'
                            },
                            {
                                data: 'net_due',
                                name: 'net_due'
                            }
                        ],
                    });
                }
            }
        })
        /*



        */
    </script>
@endsection