@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.Tournament -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('Tournament -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('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">
              <input type="hidden" name="tournament_id" id="tournament_id">
              <input type="hidden" name="tournament_name" id="tournament_name">
            </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>
      <div class="card-body">
        <h4 class="card-title">{{ trans('reports.Admin') }}</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('tournament.Total Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Buy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total ReBuy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total Rebuy-In-Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Addon') }}</th>
              <th class="text-center">{{ trans('tournament.Total Addon Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Wins') }}</th>
              <th class="text-center">{{ trans('tournament.Net') }}</th>
            </tr>
          </thead>
        </table><br>
        <h4 class="card-title">{{ trans('reports.Partner') }}</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('tournament.Total Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Buy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total ReBuy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total Rebuy-In-Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Addon') }}</th>
              <th class="text-center">{{ trans('tournament.Total Addon Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Wins') }}</th>
              <th class="text-center">{{ trans('tournament.Net') }}</th>

            </tr>
          </thead>
        </table>
      </div>
      <!-- /.card-body -->
    </div>

    <div class="card" id="tournamentReport" 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="tournament" class="table table-bordered table-striped">
          <thead>
            <tr>
              <th class="text-center">{{ trans('tournament.Tournament Name') }}</th>
              <th class="text-center">{{ trans('tournament.Total Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Buy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total Wins') }}</th>
              <th class="text-center">{{ trans('tournament.Net')}}</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('tournament.Player Name') }}</th>
              <th class="text-center">{{ trans('tournament.Total Entry Fee') }}</th>
              <th class="text-center">{{ trans('tournament.Total Buy-In') }}</th>
              <th class="text-center">{{ trans('tournament.Total Wins') }}</th>
              <th class="text-center">{{ trans('tournament.Net')}}</th>
              
            </tr>
          </thead>
        </table>
      </div>
      <!-- /.card-body -->
    </div>


    
  </section>

</div>
@endsection
@section('javascript')
@include('datatablejs')
<script type="text/javascript">
  var companyTable;
  var partnerTable;
  var playerTable;
  var tournamentTable;
  $("#getReport").click(function() {
    $("#selected_datatime").val($("#selected_date").val());

    $('#report_title').html("Turnover Report: " + $('.daterange_span').html());
    $('#report').show();
    $('#tournamentReport').hide();
    $('#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, 4, 5, 6, 7]
        },
        {
          "className": 'text-center',
          "targets": [0]
        }
      ],
      "ajax": {
        "url": "{{ route('turnover.fetchCompany') }}",
        "type": "GET",
        "data": function(d) {
          d.filter_date = $("#selected_datatime").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": [{
            "orderable": false,
            "targets": [0,8]
        },
        {
          "className": 'text-right',
          "targets": [1, 2, 3, 4, 5, 6, 7]
        },
        {
          "className": 'text-center',
          "targets": [0]
        }
      ],
      "ajax": {
        "url": "{{ route('turnover.fetchPartner') }}",
        "type": "GET",
        "data": function(d) {
          d.filter_date = $("#selected_datatime").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, 1, 2, 3, 4, 5, 6]
        },
        title: $('#report_title').html(),

      }]
    });

 
  });
  function tournamentReport(partnerID, name) {

$('#playerReport_title').html(name + " - Tournament Turnover Report: " + $('.daterange_span').html());
$('#report').hide();
$('#playerReport').hide();
$('#tournamentReport').show();

$("#partner_id").val(partnerID);
$("#partner_name").val(name);

tournamentTable = $('#tournament').DataTable({
  "responsive": true,
  "pagingType": "numbers",
  "processing": true,
  "bDestroy": true,
  "serverSide": true,
  "searching": false,
  "ordering": false,
  "aaSorting": [],
  "lengthMenu": [
    [20, 50, 100, 200],
    [20, 50, 100, 200]
  ],
  "columnDefs": [{
      "className": 'text-right',
      "targets": [1, 2, 3, 4]
    },
    {
      "className": 'text-center',
      "targets": [0]
    }
  ],
  "ajax": {
    "url": "{{ route('turnover.fetchTournament') }}",
    "type": "GET",
    "data": function(d) {
      d.filter_date = $("#selected_datatime").val();
      d.partner_id = partnerID;
    },
    "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');
  },
  // "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 playerReport(tournamentID, name) {

$('#playerReport_title').html(name + " - Tournament Turnover Report: " + $('.daterange_span').html());
$('#report').hide();
$('#tournamentReport').hide();

$('#playerReport').show();
$("#tournament_id").val(tournamentID);
$("#tournament_name").val(name);

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]
    },
    {
      "className": 'text-center',
      "targets": [0]
    }
  ],
  "ajax": {
    "url": "{{ route('turnover.fetchPlayer') }}",
    "type": "GET",
    "data": function(d) {
      d.filter_date = $("#selected_datatime").val();
      d.tournament_id = tournamentID;
    },
    "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');
  },
  // "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() {
    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);

    form.appendChild(hiddenField);

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

    form.appendChild(hiddenField4);

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

form.appendChild(hiddenField5);

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