@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.Game 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('Game 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">
                                {{ Form::label('GAME', trans('player.Game')) }}
                                {{ Form::select('GAME', $game, '', ['class' => 'form-control', 'id' => 'GAME']) }}
                            </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">
                            </div>
                            <div class="form-col-1 poker_filters">
                                {{ 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 poker_filters">
                                <label for="GAME_TYPE">Game Type</label>
                                {{ Form::select('GAME_TYPE', $miniGameTypes, '', ['class' => 'form-control select2', 'placeholder' => 'Game Type', 'id' => 'GAME_TYPE']) }}
                            </div>
                            <!--  <div class="form-col-1">
                                {{ Form::label('STAKE', trans('Stake')) }}
                                {{ Form::text('STAKE', '', ['id' => 'STAKE', 'class' => 'form-control', 'placeholder' => trans('Stake 50.00/100.00')]) }}
                            </div> -->
                            <div class="form-col-1 poker_filters">
                                <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="0.10/0.20">0.10/0.20</option>
                                    <option value="1/2">1/2</option>
                                    <option value="2/4">2/4</option>
                                    <option value="3/6">3/6</option>
                                    <option value="5/10">5/10</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</option>
                                    <option value="100/200">100/200</option>
                                    <option value="200/400">200/400</option>


                                </select>
                            </div>
                            <br> <br>
                            <div class="button_sec">
                                <button class="btn btn-primary" id="getReport">{{ trans('layout.Submit') }}</button>
                                <button class="btn btn-default" id="reloadPage">{{ 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 class="row total_base_ment">
                        <div class="total_base_flex">
                            <!--  <div class="total_base"> <div>Game turnover details</div></div> -->
                        </div>
                        <div class="dt-buttons" onClick="post()"><button class="dt-button buttons-excel buttons-html5"
                                tabindex="0" type="button" title="Excel"><span><i
                                        class="fa fa-file-excel-o"></i></span></button> </div>
                    </div>
                </div>
                <div class="card-body">

                    <table id="game" class="table table-bordered table-striped" style="display:none;">
                        <thead>
                            <tr>
                                <th class="text-center">{{ trans('reports.Game Name') }}</th>
                                <th class="text-center">{{ trans('reports.Total Game') }}</th>
                                <th class="text-center">{{ trans('reports.Total Bet') . '(' . env('INR_ICON') . ')' }} 
                                </th>
                                <th class="text-center">{{ trans('reports.Total Win') . '(' . env('INR_ICON') . ')' }} 
                                </th>
                                <th class="text-center">{{ trans('reports.Rake') . '(' . env('INR_ICON') . ')' }}</th>
                                <th class="text-center">{{ trans('reports.Rake %') }}</th>
                            </tr>
                        </thead>
                    </table>


                    <table id="fantasygame" class="table table-bordered table-striped" style="display:none;">
                        <thead>
                            <tr>
                                <th class="text-center">UserName</th>
                                <th class="text-center">Match Name</th>
                                <th class="text-center">Contest Name</th>
                                <th class="text-center">Match Format</th>
                                <th class="text-center">Game Schedule Date</th>
                                <th class="text-center">Transaction Amount</th>
                                <th class="text-center">Transaction Date</th>                                
                            </tr>
                        </thead>
                    </table>


                </div>
                <!-- /.card-body -->
            </div>
        </section>

    </div>
@endsection
@section('javascript')
    @include('datatablejs')
    <script type="text/javascript">
        $("#GAME").change(function() {
            var type = $(this).val();
            if (type == 1) {
                $('.poker_filters').hide();
            } else if(type == 2) {
                $('.poker_filters').hide();
            } else {
                $('.poker_filters').show();
            }
        });



            var gameTable;
            $("#getReport").click(function() {

                var GAME = $("#GAME").val();
                if(GAME != 2) {
                        $('#fantasygame').hide();
                        $('#game').show();
                        $('#fantasygame_wrapper').hide();
                        $('#game_wrapper').show();
                        $("#selected_datatime").val($("#selected_date").val());

                        $('#report_title').html("Game Turnover Report: " + $('.daterange_span').html());
                        $('#report').show();
                        jQuery.fn.DataTable.Api.register('buttons.exportData()', function(options) {
                            if (this.context.length) {
                                // make columns for sorting
                                var columns = [];
                                $.each(this.context[0].aoColumns, function(key, value) {
                                    columns.push({
                                        'data': value.data,
                                        'name': value.name,
                                        'searchable': value.bSearchable,
                                        'orderable': value.bSortable
                                    });
                                });
                                // make option for sorting
                                var order = [];
                                $.each(this.context[0].aaSorting, function(key, value) {
                                    order.push({
                                        'column': value[0],
                                        'dir': value[1]
                                    });
                                });
                                var jsonResult = $.ajax({
                                    "url": "{{ route('gameTurnoverReport.fetch') }}",
                                    "type": "GET",
                                    "data": {
                                        columns: columns,
                                        order: order,
                                        filter_date: $("#selected_datatime").val(),
                                        filter_game: $("#GAME").val(),
                                        filter_game_name: $("#GAME_NAME").val(),
                                        filter_stake: $("#STAKE").val(),
                                        filter_type: $("#GAME_TYPE").val(),
                                        length: -1,
                                        draw: 1,
                                    },
                                    dataType: "json",
                                    success: function(result) {
                                        //Do nothing
                                        // console.log(result)
                                    },
                                    async: false
                                });

                                var result = jsonResult.responseJSON.data;
                                /* $.each(result,function(index,element){  
                                     element.splice(3)
                                 });*/
                                return {
                                    body: result,
                                    header: $("#table thead tr th").map(function() {
                                        return this.innerText;
                                    }).get()
                                };
                            }
                        });

                        gameTable = $('#game').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]
                                },
                                {
                                    "className": 'text-center',
                                    "targets": [0]
                                },
                                {
                                    "targets": [2, 3],
                                    "visible": false,
                                    "searchable": false
                                }
                            ],
                            dom: 'Bfrtip',
                            buttons: [],
                            "ajax": {
                                "url": "{{ route('gameTurnoverReport.fetch') }}",
                                "type": "GET",
                                "data": function(d) {
                                    d.filter_date = $("#selected_datatime").val();
                                    d.filter_game = $("#GAME").val();
                                    d.filter_game_name = $("#GAME_NAME").val();
                                    d.filter_stake = $("#STAKE").val();
                                    d.filter_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();
                                }
                                $('#game tbody tr:last').addClass('lastRowColor');
                            }
                        });
                } else {

                        $('#fantasygame').show();
                        $('#game').hide();
                        $('#game_wrapper').hide();
                        $('#fantasygame_wrapper').show();

                        $("#selected_datatime").val($("#selected_date").val());

                        $('#report_title').html("Game Turnover Report: " + $('.daterange_span').html());
                        $('#report').show();
                        jQuery.fn.DataTable.Api.register('buttons.exportData()', function(options) {
                            if (this.context.length) {
                                // make columns for sorting
                                var columns = [];
                                $.each(this.context[0].aoColumns, function(key, value) {
                                    columns.push({
                                        'data': value.data,
                                        'name': value.name,
                                        'searchable': value.bSearchable,
                                        'orderable': value.bSortable
                                    });
                                });
                                // make option for sorting
                                var order = [];
                                $.each(this.context[0].aaSorting, function(key, value) {
                                    order.push({
                                        'column': value[0],
                                        'dir': value[1]
                                    });
                                });
                                var jsonResult = $.ajax({
                                    "url": "{{ route('gameTurnoverReport.fantasyfetch') }}",
                                    "type": "GET",
                                    "data": {
                                        columns: columns,
                                        order: order,
                                        filter_date: $("#selected_datatime").val(),
                                        filter_game: $("#GAME").val(),
                                        filter_game_name: $("#GAME_NAME").val(),
                                        filter_stake: $("#STAKE").val(),
                                        filter_type: $("#GAME_TYPE").val(),
                                        length: -1,
                                        draw: 1,
                                    },
                                    dataType: "json",
                                    success: function(result) {
                                        //Do nothing
                                        // console.log(result)
                                    },
                                    async: false
                                });

                                var result = jsonResult.responseJSON.data;
                                /* $.each(result,function(index,element){  
                                     element.splice(3)
                                 });*/
                                return {
                                    body: result,
                                    header: $("#table thead tr th").map(function() {
                                        return this.innerText;
                                    }).get()
                                };
                            }
                        });

                        gameTable = $('#fantasygame').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-center',
                                    "targets": [1, 2, 3, 4, 5, 6]
                                },
                                {
                                    "className": 'text-center',
                                    "targets": [0]
                                }
                            ],
                            dom: 'Bfrtip',
                            buttons: [],
                            "ajax": {
                                "url": "{{ route('gameTurnoverReport.fantasyfetch') }}",
                                "type": "GET",
                                "data": function(d) {
                                    d.filter_date = $("#selected_datatime").val();
                                    d.filter_game = $("#GAME").val();
                                    d.filter_game_name = $("#GAME_NAME").val();
                                    d.filter_stake = $("#STAKE").val();
                                    d.filter_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').hide();
                                } else {
                                    $('.dt-buttons').hide();
                                }
                                // $('#fantasygame tbody tr:last').addClass('lastRowColor');
                            }
                        });

                }
            });
        


        function post() {
            const form = document.createElement('form');
            form.method = 'get';
            form.action = "{{ route('gameTurnoverReport.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 = 'filter_game_name';
            hiddenField2.value = $("#GAME_NAME").val();

            form.appendChild(hiddenField2);

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

            form.appendChild(hiddenField3);

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

            form.appendChild(hiddenField4);


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

            form.appendChild(hiddenField5);



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