@extends('layouts.master')

@section('content')
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="m-0 text-dark">{{ trans('breadcrumbs.Turnover Report') }}</h1>
                    </div>
                    <!-- /.col -->
                    <div class="col-sm-3"></div>
                    <div class="col-sm-3">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item">{{ Breadcrumbs::render('Turnover Report') }}</li>
                        </ol>
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->

        <section class="content">
            <div class="card" id="filterDiv">
                <div class="card-header">
                    <h3 class="card-title">{{ trans('layout.Filter') }}</h3>
                    <div class="col-md-6 card-primary card-form-1">
                        <div class="card-body">
                            <div class="form-col-1 gameTypeFilter">
                                {{ Form::label('GAME_TYPE', trans('player.Game Type')) }}
                                {{ Form::select('GAME_TYPE', $gameType, '', ['class' => 'form-control', 'id' => 'GAME_TYPE']) }}
                            </div>
                            <div style="display:none" class="form-col-1 usernamefilter">
                                {{ Form::label('USERNAME', trans('player.Username')) }}
                                {{ Form::text('USERNAME', '', ['id' => 'USERNAME', 'class' => 'form-control', 'placeholder' => trans('player.Username')]) }}
                            </div>
                            <div class="form-col-1">
                                {{ Form::label('DATE_RANGE', trans('layout.Select Date Range')) }}<br>
                                <button type="button" style="width: 100%;" class="btn btn-default" id="daterange-btn">
                                    <span class="daterange_span pull-left">{{ trans('layout.Select Date Range') }}</span>
                                </button>
                                <input type="hidden" name="selected_date" id="selected_date">
                                <input type="hidden" name="selected_datatime" id="selected_datatime">
                                <input type="hidden" name="partner_id" id="partner_id">
                                <input type="hidden" name="partner_name" id="partner_name">
                            </div>
                            <div class="form-col-1 gameNameFilter">
                                {{ Form::label('GAME_NAME', trans('reports.Game Name')) }}
                                {{ Form::select('GAME_NAME', $gameName, '', ['class' => 'form-control select2', 'placeholder' => trans('reports.Game Name'), 'id' => 'GAME_NAME']) }}
                            </div>
                            <div class="form-col-1 stakeFilter">
                                <label for="STAKE">Stake</label>
                                <select class="form-control select2 select2-hidden-accessible" id="STAKE" name="STAKE"
                                    tabindex="-1" aria-hidden="true">
                                    <option selected="selected" value="">Select Stake</option>
                                    <option value="5/10">5 / 10 & Below</option>
                                    <option value="10/20">10/20</option>
                                    <option value="20/40">20/40</option>
                                    <option value="25/50">25/50</option>
                                    <option value="50/100">50/100 & Above</option>
                                </select>
                            </div>
                            <br> <br>
                            <div class="button_sec">
                                <button class="btn btn-primary" id="getReport">{{ trans('layout.Submit') }}</button>
                                <button onClick="playerReport()" style="display:none" class="btn btn-primary"
                                    id="getPlayerReport">{{ trans('layout.Submit') }}</button>
                                <button class="btn btn-default" id="reloadPage">{{ trans('layout.Clear') }}</button>
                                <button class="btn btn-default" style="display:none"
                                    id="clearFilters">{{ trans('layout.Clear') }}</button>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- /.card-body -->
            </div>

            <div class="card" id="report" style="display:none">
                <div class="card-header">
                    <h3 class="card-title" id="report_title"></h3>
                </div>
                <div class="card-body">
                    <h4 class="card-title">{{ trans('reports.Company Turnover') }}</h4>
                    <table id="company" class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="text-center">{{ trans('reports.Partner') }}</th>
                                <th class="text-center">{{ trans('reports.Total Bets') . '(' . env('INR_ICON') . ')' }}</th>
                                <th class="text-center">{{ trans('reports.Total Wins') . '(' . env('INR_ICON') . ')' }}</th>
                                <th class="text-center">{{ trans('reports.Gross Rake') . '(' . env('INR_ICON') . ')' }}</th>
                                <!-- <th class="text-center">{{ trans('reports.Bonus Rake') . '(' . env('INR_ICON') . ')' }}</th>
                                <th class="text-center">{{ trans('reports.GST') . '(' . env('INR_ICON') . ')' }}</th>
                                <th class="text-center">{{ trans('reports.Net Rake') . '(' . env('INR_ICON') . ')' }}</th> -->
                            </tr>
                        </thead>
                    </table><br>
                    <!-- <h4 class="card-title">{{ trans('reports.Partners Turnover') }}</h4>
                    <table id="partner" class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="text-center">{{ trans('reports.Partner') }}</th>
                                <th class="text-center">{{ trans('reports.Total Bets') }}</th>
                                <th class="text-center">{{ trans('reports.Total Wins') }}</th>
                                <th class="text-center">{{ trans('reports.Gross Rake') }}</th>
                                <th class="text-center">{{ trans('reports.Bonus Rake') }}</th>
                                <th class="text-center">{{ trans('reports.GST') }}</th>
                                <th class="text-center">{{ trans('reports.Net Rake') }}</th>
                            </tr>
                        </thead>
                    </table> -->
                </div>
                <!-- /.card-body -->
            </div>

            <div class="card" id="playerReport" style="display:none">
                <div class="card-header">
                    <h3 class="card-title" id="playerReport_title"></h3>
                </div>
                <div class="card-body">
                    <div class="dt-buttons" onClick="post()"><button class="dt-button buttons-excel buttons-html5"
                            tabindex="0" aria-controls="player" type="button" title="Excel"><span><i
                                    class="fa fa-file-excel-o"></i></span></button> </div>
                    <table id="player" class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="text-center">{{ trans('reports.Player Name') }}</th>
                                <th class="text-center">{{ trans('reports.Total Bets') }}</th>
                                <th class="text-center">{{ trans('reports.Total Wins') }}</th>
                                <th class="text-center">{{ trans('reports.Gross Rake') }}</th>
                                <th class="text-center">{{ trans('reports.Bonus Rake') }}</th>
                                <th class="text-center">{{ trans('reports.GST') }}</th>
                                <th class="text-center">{{ trans('reports.Net Rake') }}</th>
                            </tr>
                        </thead>
                    </table>
                </div>
                <!-- /.card-body -->
            </div>
        </section>

    </div>
@endsection
@section('javascript')
    @include('datatablejs')
    <script type="text/javascript">
        $("#GAME_TYPE").change(function() {
            var type = $(this).val();
            // var type = $('#GAME_TYPE').find(":selected").val();
            if (type == 1) {
                $('.gameNameFilter').hide();
                $('.stakeFilter').hide(); 
            } else {
                $('.gameNameFilter').show();
                 $('.stakeFilter').show(); 
            }
        });

        var companyTable;
        // var partnerTable;
        var playerTable;
        $("#getReport").click(function() {
            $("#selected_datatime").val($("#selected_date").val());
            $('#report_title').html("Turnover Report: " + $('.daterange_span').html());
            $('#report').show();
            $('#playerReport').hide();

            companyTable = $('#company').DataTable({
                "responsive": true,
                "paging": false,
                "info": false,
                "searching": false,
                "lengthChange": false,
                "processing": true,
                "bDestroy": true,
                "serverSide": true,
                "ordering": false,
                "aaSorting": [],
                "columnDefs": [{
                        "className": 'text-right',
                        "targets": [1, 2, 3]
                    },
                    {
                        "className": 'text-center',
                        "targets": [0]
                    },
                    // {
                    //     "targets": [1,2],
                    //     "visible": false,
                    //     "searchable": false
                    // }
                ],
                "ajax": {
                    "url": "{{ route('turnoverReport.fetchCompany') }}",
                    "type": "GET",
                    "data": function(d) {
                        d.filter_date = $("#selected_datatime").val();
                        d.filter_game = $("#GAME_NAME").val();
                        d.filter_stake = $("#STAKE").val();
                        d.filter_game_type = $("#GAME_TYPE").val();
                    },
                    "error": function(e) {
                        swal("{{ trans('layout.Something went wrong') }}", {
                            icon: "warning",
                        });
                    }
                }
            });

            /*partnerTable = $('#partner').DataTable({
                "responsive": true,
                "pagingType": "numbers",
                "processing": true,
                "bDestroy": true,
                "serverSide": true,
                "searching": false,
                "aaSorting": [],
                "lengthMenu": [
                    [20, 50, 100, 200],
                    [20, 50, 100, 200]
                ],
                "columnDefs": [{
                        "className": 'text-right',
                        "targets": [1, 2, 3, 4, 5, 6]
                    },
                    {
                        "className": 'text-center',
                        "targets": [0]
                    },
                    {
                        "targets": [1,2],
                        "visible": false,
                        "searchable": false
                    }
                ],
                "ajax": {
                    "url": "{{ route('turnoverReport.fetchPartner') }}",
                    "type": "GET",
                    "data": function(d) {
                        d.filter_date = $("#selected_datatime").val();
                        d.filter_game_type = $("#GAME_TYPE").val();
                        d.filter_game = $("#GAME_NAME").val();
                        d.filter_stake = $("#STAKE").val();
                    },
                    "error": function(e) {
                        swal("{{ trans('layout.Something went wrong') }}", {
                            icon: "warning",
                        });
                    },
                },
                "drawCallback": function(response, settings) {
                    var api = this.api();
                    var rows = api.rows({
                        page: 'current'
                    }).nodes();
                    if (rows.length > 0) {
                        $('.dt-buttons').show();
                    } else {
                        $('.dt-buttons').hide();
                    }
                    $('#partner tbody tr:last').addClass('lastRowColor');
                },
                "dom": 'lBfrtip',
                "buttons": [{
                    "extend": 'excel',
                    text: '<i class="fa fa-file-excel-o"></i>',
                    titleAttr: 'Excel',
                    exportOptions: {
                        columns: [0, 3, 4, 5, 6]
                    },
                    title: $('#report_title').html(),

                }]
            });*/
        });

        function playerReport(partnerID, name) {
            $("#selected_datatime").val($("#selected_date").val());
            $('#playerReport_title').html(name + " - Player Turnover Report: " + $('.daterange_span').html());
            $('#report').hide();
            $('#getReport').hide();
            $('#reloadPage').hide();
            $('#clearFilters').show();
            $('#getPlayerReport').show();
            $('.usernamefilter').show();
            $('#playerReport').show();
            $("#partner_id").val(partnerID);
            $("#partner_name").val(name);
            $('#clearFilters').click(function() {
                $('#USERNAME').val('');
                $("#GAME_NAME").val(null).trigger("change");
                $("#STAKE").val(null).trigger("change");
                $('#playerReport').hide();
            });

            playerTable = $('#player').DataTable({
                "responsive": true,
                "pagingType": "numbers",
                "processing": true,
                "bDestroy": true,
                "serverSide": true,
                "searching": false,
                "aaSorting": [],
                "lengthMenu": [
                    [20, 50, 100, 200],
                    [20, 50, 100, 200]
                ],
                "columnDefs": [{
                        "className": 'text-right',
                        "targets": [1, 2, 3, 4, 5, 6]
                    },
                    {
                        "className": 'text-center',
                        "targets": [0]
                    },
                    {
                        "targets": [1,2],
                        "visible": false,
                        "searchable": false
                    }
                ],
                "ajax": {
                    "url": "{{ route('turnoverReport.fetchPlayer') }}",
                    "type": "GET",
                    "data": function(d) {
                        d.filter_username = $("#USERNAME").val();
                        d.filter_date = $("#selected_datatime").val();
                        d.filter_game = $("#GAME_NAME").val();
                        d.filter_stake = $("#STAKE").val();
                        d.partner_id = partnerID;
                        d.filter_game_type = $("#GAME_TYPE").val();

                    },
                    "error": function(e) {
                        swal("{{ trans('layout.Something went wrong') }}", {
                            icon: "warning",
                        });
                    },
                },
                "drawCallback": function(response, settings) {
                    var api = this.api();
                    var rows = api.rows({
                        page: 'current'
                    }).nodes();
                    if (rows.length > 0) {
                        $('.dt-buttons').show();
                    } else {
                        $('.dt-buttons').hide();
                    }
                    $('#player tbody tr:last').addClass('lastRowColor');

                    var totalCount = response.json.recordsTotal;
                    if (totalCount == 0) {
                        $('#player_info').hide();
                    } else {
                        $('#player_info').show();
                    }
                },
                // "dom": 'lBfrtip',
                // "buttons": [
                //   {
                //     "extend": 'excel',
                //     text:      '<i class="fa fa-file-excel-o"></i>',
                //     titleAttr: 'Excel',
                //     exportOptions: {
                //       columns: [ 0, 1, 2, 3, 4, 5, 6 ]
                //     },
                //     title: $('#playerReport_title').html(),

                //   }
                // ]
            });
        }

        function post() {

            var type = $('#GAME_TYPE').find(":selected").val();

            const form = document.createElement('form');
            form.method = 'get';
            form.action = "{{ route('turnoverReport.download') }}";

            const hiddenField = document.createElement('input');
            hiddenField.type = 'hidden';
            hiddenField.name = 'filter_date';
            hiddenField.value = $("#selected_datatime").val();

            form.appendChild(hiddenField);

            const hiddenField2 = document.createElement('input');
            hiddenField2.type = 'hidden';
            hiddenField2.name = 'partner_id';
            hiddenField2.value = $("#partner_id").val();

            form.appendChild(hiddenField2);

            const hiddenField3 = document.createElement('input');
            hiddenField3.type = 'hidden';
            hiddenField3.name = 'partner_name';
            hiddenField3.value = $("#partner_name").val();

            form.appendChild(hiddenField3);

            const hiddenField4 = document.createElement('input');
            hiddenField4.type = 'hidden';
            hiddenField4.name = 'filter_game_type';
            hiddenField4.value = $("#GAME_TYPE").val();

            form.appendChild(hiddenField4);

            const hiddenField5 = document.createElement('input');
            hiddenField5.type = 'hidden';
            hiddenField5.name = 'filter_stake';
            hiddenField5.value = $("#STAKE").val();

            form.appendChild(hiddenField5);

            if (type == 0) {
                const hiddenField6 = document.createElement('input');
                hiddenField6.type = 'hidden';
                hiddenField6.name = 'filter_game';
                hiddenField6.value = $("#GAME_NAME").val();

                form.appendChild(hiddenField6);
            }

            document.body.appendChild(form);
            form.submit();
        }
    </script>
@stop