@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.TDS 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('TDS 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('MOBILE_NUMBER', trans('player.Mobile Number')) }}
              {{ Form::text('MOBILE_NUMBER','', ['id' => 'MOBILE_NUMBER', 'class' => 'form-control','maxlength'=>10,'placeholder' => trans('player.Mobile Number')]) }}
            </div>
            <div class="form-col-1">
              {{ Form::label('INTERNAL_REFERENCE_NO', trans('reports.Reference no')) }}
              {{ Form::text('INTERNAL_REFERENCE_NO','', ['id' => 'INTERNAL_REFERENCE_NO', 'class' => 'form-control','placeholder' => trans('reports.Reference no')]) }}
            </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>
      <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">
          <thead>
            <tr>
              <th class="text-center">{{ trans('reports.Username') }}</th>
              <th class="text-center">{{ trans('reports.Reference no') }}</th>
              <th class="text-center">{{ trans('reports.Name') }}</th>
              <th class="text-center">{{ trans('reports.Email ID') }}</th>
              <th class="text-center">{{ trans('reports.Contact') }}</th>
              <th class="text-center">{{ trans('reports.Withdraw amount') }}</th>
              <th class="text-center">{{ trans('reports.TDS amount') }}</th>
              <th class="text-center">{{ trans('reports.TDS Status') }}</th>
              <th class="text-center">{{ trans('reports.Date & Time') }}</th>
            </tr>
          </thead>
        </table>
      </div>
      <!-- /.card-body -->
    </div>
  </section>

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

    $('#report_title').html("TDS Report: " + $('.daterange_span').html());
    $('#report').show();

    reportTable = $('#table').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": [5,7]
        },
        {
          "className": 'text-right',
          "targets": [5, 6]
        },
        {
          "className": 'text-center',
          "targets": [0, 1, 2, 3, 4, 7, 8]
        }
      ],
      "ajax": {
        "url": "{{ route('tdsReport.fetch') }}",
        "type": "GET",
        "data": function(d) {
          d.filter_date = $("#selected_datatime").val();
          d.filter_reference = $("#INTERNAL_REFERENCE_NO").val();
          d.filter_username = $("#USERNAME").val();
          d.filter_mobileno = $("#MOBILE_NUMBER").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();
        }
      }
    });
  });


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

    form.appendChild(hiddenField2);

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

    form.appendChild(hiddenField3);

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

    form.appendChild(hiddenField4);

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