@extends('layouts.master')

@section('content')
<style type="text/css">
    div#table_length {
        display: none;
    }
    button.dt-button.buttons-pdf.buttons-html5 {
        display: none;
    }
</style>

<!-- 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.Main to Game Wallet 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('Main to Game Wallet 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('USERNAME',  trans('reports.Username'))}}
                            {{ Form::text('USERNAME','', ['id' => 'USERNAME', 'class' => 'form-control', 'placeholder' => trans('reports.Username')]) }}
                        </div>
                        <div class="form-col-1">
                            {{ Form::label('INTERNAL_REFERENCE_NO', trans('reports.Internal Reference No')) }}
                            {{ Form::text('INTERNAL_REFERENCE_NO','', ['id' => 'INTERNAL_REFERENCE_NO', 'class' => 'form-control', 'placeholder' => trans('reports.Internal Reference No')]) }}
                        </div>
                        <div class="form-col-1">
                            {{ Form::label('GAME_TYPE', trans('reports.Game Type')) }}
                            {{ Form::select('GAME_TYPE', $gameType, '', ['class' => 'form-control select2','id' => 'GAME_TYPE']) }}
                        </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>
                        <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>Total Amount: <b>Rs.<span class="form-col-1" id="total_amount">0</span></b></div></div>
                    </div>
                     <div class="dt-buttons" onclick="post()" style="display: none;"><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">
                <!-- <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> -->

                <table id="table" class="table table-bordered table-striped" style="width: 1600px;">
                    <thead>
                        <tr>
                            <th class="text-center">{{ trans('reports.Username') }}</th>
                            <th class="text-center">{{ trans('reports.Internal Reference No') }}</th>
                            <th class="text-center">{{ trans('reports.Amount') }}</th>
                            <th class="text-center">{{ trans('reports.Current Total Balance') }}</th>
                            <th class="text-center">{{ trans('reports.Closing Total Balance') }}</th>
                            <th class="text-center">{{ trans('reports.Created Date') }}</th>
                        </tr>
                    </thead>
                </table>
            </div>
            <!-- /.card-body -->
            {{ Form::close() }}
        </div>
    </section>

</div>

@endsection
@section('javascript')
@include('datatablejs')
<script>
    $('#downloadExcel').hide();

    var reportTable;
    $("#getReport").click(function() {
        $("#selected_datatime").val($("#selected_date").val());

        $('#report_title').html("Main to Game Wallet Conversion Reports: " + $('.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('maintoGameWallet.fetch') }}",
        "type": "GET",
          "data": {
            columns: columns, order: order,
                    filter_date : $("#selected_datatime").val(),
                    filter_username : $("#USERNAME").val(),
                    filter_internal_ref_no : $("#INTERNAL_REFERENCE_NO").val(),
                    filter_game_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;
             console.log(result);
               /* $.each(result,function(index,element){  
                    element.splice(3)
                });*/
                return {body: result, header: $("#table thead tr th").map(function() {
                 return this.innerText;
                  }
                 ).get()};
            }
        } );
       

        reportTable = $('#table').DataTable({
            "responsive": true,
            //"scrollX": 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": [2,3,4]
                },
                {
                    "orderable": false,
                    "targets": []
                },
                {
                    "className": 'text-center',
                    "targets": [0, 1, 2, 5]
                }
            ],
             dom: 'lBfrtip',
        buttons: [
            {
                extend : 'pdfHtml5',
                title : function() {
                    return "maintoGameWalletConversionReport";
                },
                orientation : 'landscape',
                pageSize : 'LEGAL',
                text : '<i class="fa fa-file-pdf-o"> PDF</i>',
                titleAttr : 'PDF'
            } 
        ],
            "ajax": {
                "url": "{{ route('maintoGameWallet.fetch') }}",
                "type": "GET",
                "data": function(d) {
                    d.filter_date = $("#selected_datatime").val();
                    d.filter_username = $("#USERNAME").val();
                    d.filter_internal_ref_no = $("#INTERNAL_REFERENCE_NO").val();
                    d.filter_game_type = $("#GAME_TYPE").val();
                },
                "error": function(e) {
                    swal("{{ trans('layout.Something went wrong') }}", {
                        icon: "warning",
                    });
                },
                /*"success": function(response) {
                    console.log(response);
                    document.getElementById('total_amount').html(10);
                },*/
            },
            "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();
                }
                
                // get total amount in response
                var totalAmount = response.json.totalAmount;
                document.getElementById('total_amount').innerText = parseFloat(totalAmount);
            }
        });

       
    });

    



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

        form.appendChild(hiddenField2);

        const hiddenField3 = document.createElement('input');
        hiddenField3.type = 'hidden';
        hiddenField3.name = 'filter_internal_ref_no';
        hiddenField3.value = $("#INTERNAL_REFERENCE_NO").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);

        
        document.body.appendChild(form);
        form.submit();
    }


    
</script>

@stop