@extends('admin.layouts.default')
@section('content')
<!-- DATATABLE GLOBAL SCRIPTS -->
  {{ HTML::style('css/admin/datatable.css') }}
  {{ HTML::script("js/admin/datatable.js") }}
<!-- DATATABLE GLOBAL SCRIPTS -->
<style type="text/css">
    #seriesId,#matchId {
        width: 300px;
        margin: 0 10px;
    }
</style>
<script>
  $(document).ready(function(){
    $('[data-toggle="tooltip"]').tooltip();
  });
</script>
<!-- <div class="container-fluid">
    <div class="row page-titles mx-0" data-aos="fade-up">
        <div class="col-sm-6 p-md-0">

        </div>
    </div> -->

    <!-- <div class="row">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header"><h4>Find Report</h4></div>
                <div class="card-body">
                    <div class="basic-form">
                     {{ Form::open(['role' => 'form','id'=>'Downlode_GSTForm','route'=>[$modelName.'.download_gst_report'],'files' => true,'method' => 'get']) }}
                    {{csrf_field()}}
                            <div class="form-row">
                                <div class="form-group col-md-4 mb-0">
                                    <label>Start Date</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="start_date" id="start_date" class="pull-left form-control datetimepickerget w-95" autocomplete="off">
                                    </div>
                                </div>

                                <div class="form-group col-md-4 mb-0">
                                    <label>End Date</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="end_date" id="end_date" class="pull-left form-control datetimepickerget w-95" autocomplete="off">
                                    </div>
                                </div>
                                <div class="form-group col-md-4 mb-0">
                                    <label>Matchkey</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="matchkey" id="matchkey" class="pull-left form-control w-95" placeholder="Search By Match key" autocomplete="off">
                                    </div>
                                </div>
                             </div>
                         {{ Form::close() }}
                    </div>
                </div>
                <div class="card-footer py-4">
                    <button type="submit" class="btn btn-primary show-data">Generate Report</button>
                    <button type="submit" class="btn btn-danger reset_table">Reset</button>
                </div>
            </div>
        </div>
    </div>
    <div class="row result_data">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header"><h4>Profit and loss Report</h4></div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="dataList" class="display dataTable" style="min-width: 845px">
                            <thead>
                                <tr>
                                <th>S No.</th>
                                <th>Match Key</th>
                                <th>Challenge Id</th>
                                <th>No of users</th>
                                <th>Bonus (Total)</th>
                                <th>Unutilized (Total)</th>
                                <th>Winnings (Total)</th>
                                <th>Total Amount</th>
                                <th>Winnings</th>
                                <th>Percentage GM</th>
                                <th>Bonus %</th>
                                <th>Paid By S2W</th>
                            </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                <th>S No.</th>
                                <th>Match Key</th>
                                <th>Challenge Id</th>
                                <th>No of users</th>
                                <th>Bonus(Total)</th>
                                <th>Un Utilized(Total)</th>
                                <th>Winnings(Total)</th>
                                <th>Total Amount</th>
                                <th>Winnings</th>
                                <th>%age GM</th>
                                <th>Bonus %age</th>
                                <th>Paid By S2W</th>
                            </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div> -->

    <div class="row">
          <!-- Here goes total Profit and loss -->
        <div class="col-12">
            <div class="card">
                <div class="card-header"><h4>Total Profit/Loss</h4></div>
                <div class="card-body">
                    <div class="basic-form">
                    <row class="welcome-text">
                    <div class="welcome-text col-3">
                        <button class="form-control bg-info totalButton" id="totalButton">Get Total</button>
                    </div>
                    <div class="welcome-text col-3">
                  {{ Form::open(['role' => 'form','id'=>'Downlode_TOTALPROFITLOSSForm','route'=>[$modelName.'.download_total_profit_and_loss_report'],'files' => true,'method' => 'get']) }}
                                              {{csrf_field()}}

                  <button class="form-control bg-success" type="submit" >Generate Total  CSV Report</button>
                  {{ Form::close() }}
                </div>
                    <div class="welcome-text">
                        <h4 class="result_data_total" id="totalAmount"></h4>
                    </div>
                    </row>
                    </div>
                </div>
                <div class="card-footer py-4">
                </div>
            </div>
        </div>
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header"><h4>Find Report</h4></div>
                <div class="card-body">
                    <div class="basic-form">
                   <!--  {{ Form::open(['role' => 'form','id'=>'Downlode_GSTForm','route'=>[$modelName.'.download_gst_report'],'files' => true,'method' => 'get']) }}
                    {{csrf_field()}} -->
                            <div class="form-row">
                                <!-- <div class="form-group col-md-4 mb-0">
                                    <label>Start Date</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="start_date" id="start_date" class="pull-left form-control datetimepickerget w-95" autocomplete="off">
                                    </div>
                                </div>

                                <div class="form-group col-md-4 mb-0">
                                    <label>End Date</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="end_date" id="end_date" class="pull-left form-control datetimepickerget w-95" autocomplete="off">
                                    </div>
                                </div>
                                <div class="form-group col-md-4 mb-0">
                                    <label>Matchkey</label>
                                    <div class="form-group">
                                        <input type="text" required="" name="matchkey" id="matchkey" class="pull-left form-control w-95" placeholder="Search By Match key" autocomplete="off">
                                    </div>
                                </div> -->
                    {{ Form::open(['role' => 'form','id'=>'Downlode_PROFITLOSSForm','route'=>[$modelName.'.download_profit_and_loss_report'],'files' => true,'method' => 'get']) }}
                                  {{csrf_field()}}

                                    <select class="form-control in_text bor-input js-example-basic-single" required name="seriesId" id="seriesId">
                                        <option value="">Select Series</option>
                                        @if(!empty($allSeries))
                                        @foreach($allSeries as $series)
                                        <option value="Tjs=" >{{ucwords($series->series_name)}}</option>
                                        @endforeach
                                        @endif
                                    </select>

                                    <select class="form-control in_text bor-input js-example-basic-single" name="matchId" id="matchId">
                                    </select>

                                    <button type="reset" class="btn btn-danger reset_table">Reset</button>

                                    <button type="submit" class="btn btn-success download_report" style="margin-left:4px;">Generate CSV Report</button>
                    {{ Form::close() }}
                            </div>
                        <!-- {{ Form::close() }}   -->
                    </div>
                </div>
                <div class="card-footer py-4">
                    <!-- <button type="submit" class="btn btn-primary show-data">Generate Report</button>
                    <button type="submit" class="btn btn-danger reset_table">Reset</button> -->
                </div>
            </div>
        </div>
    </div>
    <div class="row result_data">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header"><h4>Profit and loss Report</h4></div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="dataList" class="display dataTable" style="min-width: 845px">
                            <thead>
                                <tr>
                                    <th>S No.</th>
                                    <!-- <th>Match Key</th> -->
                                    <th>Winning</th>
                                    <th>Balance</th>
                                    <th>bonus</th>
                                    <th>Amount</th>
                                    <th>Total Wining</th>
                                    <th>Total Distributed</th>
                                    <th>Profit</th>
                                    <th>Loss</th>
                                </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                    <th>S No.</th>
                                    <!-- <th>Match Key</th> -->
                                    <th>Winning</th>
                                    <th>Balance</th>
                                    <th>bonus</th>
                                    <th>Amount</th>
                                    <th>Total Wining</th>
                                    <th>Total Distributed</th>
                                    <th>Profit</th>
                                    <th>Loss</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>


</div>

<script type="text/javascript">

//datepicket without time
$(document).ready(function(){
    /*$('#end_date,#start_date').datetimepicker({
        timepicker: false,
        format:'Y-m-d'
    });
    $(".result_data").hide();
    $(document).on('click','.reset_table', function() {
        $('#start_date').val('');
        $('#end_date').val('');
        $('#matchkey').val('');
        $('#dataList').DataTable().clear().destroy();
        $(".result_data").hide();
    });*/

    $(".result_data,#matchId,.reset_table").hide();
    $(document).on('click','.reset_table', function() {
        $('#dataList').DataTable().clear().destroy();
        $('#seriesId').prop('selectedIndex',0);
        document.getElementById("matchId").options.length = 0;
        $(".result_data,#matchId,.reset_table").hide();
    });

     $(document).on('change','#seriesId', function() {
        seriesId = $( "#seriesId" ).val();
        getAllMatches(seriesId);
        $(".result_data,#matchId,.reset_table").show();
    });


     $(document).on('click','#totalButton', function() {
        $(".result_data").show();
        $('#dataList').DataTable().clear().destroy();
        // var matchkey=$(this).val().trim();
        $('#dataList').DataTable({
          order: [0, 'desc'],
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.totalProfitLoss')}}",
              type: "POST",
              data : {"_token": "{{ csrf_token() }}"}
            },
            "columns": [
                {data: 'DT_RowIndex', name: 'DT_RowIndex'},
                // {data: 'matchkey', name: 'matchkey'},
                {data: 'winning', name: 'winning'},
                {data: 'balance', name: 'balance'},
                {data: 'bonus', name: 'bonus'},
                {data: 'amount', name: 'amount'},
                {data: 'totalwinning', name: 'totalwinning'},
                {data: 'totaldistributed', name: 'totaldistributed'},
                {data: 'profit', name: 'profit'},
                {data: 'loss', name: 'loss'},
            ]
        });
    });




});




    function getAllMatches(seriesId){
        $.ajax({
            url:"{{route($modelName.'.getAllSeriesMatches')}}",
            type: "POST",
            data : {"_token": "{{ csrf_token() }}","seriesId":seriesId},
            success: function(result){
                data = $.parseJSON(result);
                console.log(data);
                var output = [];
                output.push('<option value="">Select Match</option>');
                $.each(data.AllMatch, function(key, value)
                {
                    output.push('<option value="'+ value.matchkey +'">'+ value.name +'</option>');
                });
                $('#matchId').html(output.join(''));
            },
            error: function(error){
                console.log(error);
            }
        });



            $('#dataList').DataTable().clear().destroy();

            $('#dataList').DataTable({
              order: [0, 'desc'],
                "processing": true,
                "serverSide": true,
                "ajax":{
                  url:"{{route($modelName.'.totalSeriesProfitLoss')}}",
                  type: "POST",
                  data : {"_token": "{{ csrf_token() }}","seriesId":seriesId},
                },
                "columns": [
                    {data: 'DT_RowIndex', name: 'DT_RowIndex'},
                    // {data: 'matchkey', name: 'matchkey'},
                    {data: 'winning', name: 'winning'},
                    {data: 'balance', name: 'balance'},
                    {data: 'bonus', name: 'bonus'},
                    {data: 'amount', name: 'amount'},
                    {data: 'totalwinning', name: 'totalwinning'},
                    {data: 'totaldistributed', name: 'totaldistributed'},
                    {data: 'profit', name: 'profit'},
                    {data: 'loss', name: 'loss'},
                ]
            });


    }

    // $(document).on('change', '#matchId', function(){
    //     $(".result_data").show();
    //     $('#dataList').DataTable().clear().destroy();
    //     var matchkey=$(this).val().trim();
    //     $('#dataList').DataTable({
    //       order: [0, 'desc'],
    //         "processing": true,
    //         "serverSide": true,
    //         "ajax":{
    //           url:"{{route($modelName.'.profit_loss')}}",
    //           type: "POST",
    //           data : {"_token": "{{ csrf_token() }}","matchkey":matchkey}
    //         },
    //         "columns": [
    //             {data: 'totalAmount', name: 'totalAmount'}
    //         ]
    //     });
    // });



    $(document).on('change', '#matchId', function(){
        $(".result_data").show();
        $('#dataList').DataTable().clear().destroy();
        var matchkey=$(this).val().trim();
        $('#dataList').DataTable({
          order: [0, 'desc'],
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.profit_loss')}}",
              type: "POST",
              data : {"_token": "{{ csrf_token() }}","matchkey":matchkey}
            },
            "columns": [
                {data: 'DT_RowIndex', name: 'DT_RowIndex'},
                // {data: 'matchkey', name: 'matchkey'},
                {data: 'winning', name: 'winning'},
                {data: 'balance', name: 'balance'},
                {data: 'bonus', name: 'bonus'},
                {data: 'amount', name: 'amount'},
                {data: 'totalwinning', name: 'totalwinning'},
                {data: 'totaldistributed', name: 'totaldistributed'},
                {data: 'profit', name: 'profit'},
                {data: 'loss', name: 'loss'},
            ]
        });
    });

/*$(document).on('click', '.show-data', function(){
    $(".result_data").show();
    $('#dataList').DataTable().clear().destroy();
    var start_date=$('#start_date').val();
    var end_date=$('#end_date').val();
    var matchkey=$('#matchkey').val();
    $('#dataList').DataTable({
      order: [2, 'desc'],
        "processing": true,
        "serverSide": true,
        "ajax":{
          url:"{{route($modelName.'.profit_loss')}}",
          type: "POST",
          data : {"_token": "{{ csrf_token() }}",start_date:start_date,end_date:end_date,matchkey:matchkey}
        },
        "columns": [
            {data: 'DT_RowIndex', name: 'DT_RowIndex'},
            {data: 'matchkey', name: 'matchkey'},
            {data: 'challengeid', name: 'challengeid'},
            {data: 'joinedusers', name: 'joinedusers'},
            {data: 'totalbonus', name: 'totalbonus'},
            {data: 'totalwining', name: 'totalwining'},
            {data: 'totalbalance', name: 'totalbalance'},
            {data: 'totbal', name: 'totbal'},
            {data: 'win_amount', name: 'win_amount'},
            {data: 'age', name: 'age'},
            {data: 'bonus', name: 'bonus'},
            {data: 'paid_by', name: 'paid_by'},
        ]
    });
});*/
</script>
@endsection