@extends("AgentNetwork.layouts.layout")

@section("title", trans('message_lang.LBL_DAILY_COMPANY_SUMMARY'))

@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

@section("content")
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
    <!--begin::Entry-->
    <div class="d-flex flex-column-fluid">
        <!--begin::Container-->
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="card card-custom gutter-b">
                        <div class="card-header">
                            <div class="card-title">
                                <h3 class="card-label">
                                    {{ trans('message_lang.LBL_DAILY_COMPANY_SUMMARY') }}
                                </h3>
                            </div>
                            <div style="float: right; padding:10px;">
                                <a href="{{ route('AgentNetwork.reports.index') }}"class="btn btn-light btn-lg btn-block">{{ trans('message_lang.BTN_BACK') }}</a>
                            </div>
                        </div>
                        <div class="card-body">
                            <form method="POST" action="{{ route('AgentNetwork.reports.company_transactions-csvExport') }}" enctype="multipart/form-data" >
                            {{ csrf_field() }}
                            <div class="row">
                                <div class="form-group col-md-3">
                                    <select name="agent_location_id" id="agent_location_id" class="form-control custom-field">
                                        <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                        @if(isset(auth()->guard('AgentNetwork')->user()->agentNetwork->agent_locations))
                                        @foreach (auth()->guard('AgentNetwork')->user()->agentNetwork->agent_locations as $key => $agentLocation)
                                            <option value="{{ $agentLocation->id }}">{{ $agentLocation->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <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="{{ $key }}">{{ $agentCompany }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="form-group col-md-3">
                                    <select class="form-control" name="duration" id="duration">
                                        <option value="1">This Week</option>
                                        <option value="2" selected>This Month</option>
                                        <option value="3">Previous Week</option>
                                        <option value="4">Previous Month</option>
                                        <option value="5">Custom Date</option>
                                    </select>
                                </div>
                                <div class="form-group col-md-3">
                                        <button type="submit" class="btn btn-info font-weight-bolder w-100">
                                            {{ trans('message_lang.LBL_EXPORT_TRANSACTIONS') }}
                                        </button>
                                </div>
                                <div class="form-group col-md-3">
                                    <input class="form-control custom_filter_date @error('from_date') is-invalid @enderror custom-field" id="from_date" readonly type="text" name="fromDate" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" autocomplete="off">
                                </div>

                                <div class="form-group col-md-3">
                                    <input class="form-control custom_filter_date @error('to_date') is-invalid @enderror custom-field" id="to_date" type="text" readonly name="toDate" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" autocomplete="off">
                                </div>
                            </div>
                        </form>

                            <div class="row">
                                <div class="col-md-12">
                                    <!--begin: Datatable-->
                                    <table id="bal_sn_table" class="table table-bordered grid-table nowrap">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>{!! trans("message_lang.LBL_DATE") !!}</th>
                                                <th>{!! trans("message_lang.LBL_AGENT_LOCATION") !!}</th>
                                                <th>{!! trans("message_lang.LBL_COMPANY") !!}</th>
                                                <th>{!! trans("message_lang.LBL_PAYOUT_AMOUNT") !!}</th>
                                                <th>{!! trans("message_lang.LBL_TRANSACTIONS") !!}</th>
                                                <th>{!! trans("message_lang.LBL_ID") !!}</th>
                                            </tr>
                                        </thead>
                                        <tfoot>
                                            <tr>
                                                <th colspan="4" style="text-align:right">{!! trans("message_lang.LBL_TOTAL") !!}:</th>
                                                <th></th>
                                                <th></th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                    <!--end: Datatable-->
                                </div>
                            </div>
                        </div>
                    </div>
                </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>
    var list_sn_table;
    $(document).ready(function() {

        jQuery("#agent_location_id,#agent_company_id").on('change',function(){
            list_sn_table.draw();
        });

        $('#agent_location_id').select2({
            allowClear: true,
            width: '100%',
            placeholder: "{!! trans('message_lang.PLACEHOLDER_SELECT_LOCATION') !!}",
        });

        $('#agent_company_id').select2({
            allowClear: true,
            width: '100%',
            placeholder: "{!! trans('message_lang.PLACEHOLDER_SELECT_COMPANY') !!}",
        });

        $(document).on('change', "#duration", function() {
            if($("#duration").val() == 5)
            {
                $(".custom_filter_date").show();
                $('#from_date').datepicker({
                    "format": "yyyy-mm-dd",
                    "keyboardNavigation": false,
                    "autoclose": true,
                    "todayBtn": true,
                    "todayHighlight": true,
                    "orientation": "bottom",
                })
                .on('change', function(e) {
                    list_sn_table.draw();
                    $('#to_date').datepicker('setStartDate', new Date($(this).val()));
                });

                $('#to_date').datepicker({
                    "format": "yyyy-mm-dd",
                    "keyboardNavigation": false,
                    "autoclose": true,
                    "todayBtn": true,
                    "todayHighlight": true,
                    "orientation": "bottom",
                }).on('change', function(e) {
                    list_sn_table.draw();
                });
            }
            else
            {
                $(".custom_filter_date").hide();
                list_sn_table.draw();
            }
        });

        if ($('#bal_sn_table').length > 0)
        {
            list_sn_table = $('#bal_sn_table').DataTable(
            {
                "lengthMenu": [[-1, 10, 25, 50, 100], ["All", 10, 25, 50, 100]],
                footerCallback: function (row, data, start, end, display) {
                    var api = this.api(), data;

                    // Remove the formatting to get integer data for summation
                    var decimal = i => i.toString().replace(/[\$,]/g, '');

                    // Total over all pages
                    total = api.column(4).data().reduce( function (a, b) {
                        a = (parseFloat(decimal(a)) || 0).toFixed(2);
                        b = (parseFloat(decimal(b)) || 0).toFixed(2);
                        return parseFloat(a) + parseFloat(b);
                    }, 0).toLocaleString();

                    // Count over all pages
                    count = api.column(5).data().reduce( function (a, b) {
                        a = (parseFloat(decimal(a)) || 0).toFixed(2);
                        b = (parseFloat(decimal(b)) || 0).toFixed(2);
                        return parseFloat(a) + parseFloat(b);
                    }, 0).toLocaleString();

                    // Update footer
                    $(api.column(4).footer()).html(total);
                    $(api.column(5).footer()).html(count);
                },
                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") !!}']],
                aaSorting: [6, 'DESC'],
                ajax: {
                    url: "{{ route('AgentNetwork.reports.company_transactions-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.duration = $('#duration').val();
                        data.agent_location_id = $('#agent_location_id').val();
                        data.agent_company_id = $('#agent_company_id').val();
                    },
                },
                columnDefs: [
                    {
                        targets: [0], // first column & numbering column
                        orderable: false, // set not orderable
                    },
                    // {
                    //     targets: [3, 5, 8], // column index
                    //     searchable: false,
                    // },
                    {
                        targets: [6], // column index
                        visible: false,
                    }
                ],
                columns: [
                    {
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex'
                    },
                    {
                        data: 'paid_at',
                        name: 'paid_at'
                    },
                    {
                        data: 'agent_location',
                        name: 'agent_location'
                    },
                    {
                        data: 'company',
                        name: 'company',
                        render: function(data, type, row) {
                            return '<a href="' + row.data.url + '">' + data + '</a>';
                        }
                    },
                    {
                        data: 'amount',
                        name: 'amount'
                    },
                    {
                        data: 'transactions',
                        name: 'transactions'
                    },
                    {
                        data: 'id',
                        name: 'id'
                    }
                ],
            });
        }
    });

</script>
@endsection