@extends('admin.layouts.default')
@section('content')
<link rel="stylesheet" href="{{asset('css/admin/datatable.css')}}">
<script src="{{asset('js/admin/datatable.js')}}"></script>
<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 class="welcome-text">
                <h4>All Registered Users Wallet List</h4>
            </div> -->
        </div>
        <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex">
            <ol class="breadcrumb">
                <!-- <li class="breadcrumb-item"><a href="{{route('Registerusers.view')}}">All Register Users</a></li> -->
                <li class="breadcrumb-item">Users TDS Detail</li>

            </ol>
        </div>
    </div>
    <div class="row">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header">

                    <h4>Users TDS Detail</h4>
                    {{ Form::open(['role' => 'form','id'=>'Downlode_TDSForm','route'=>[$modelName.'.downloadtdsreport_userwise'],'files' => true,'method' => 'get']) }}
                      {{csrf_field()}}
                          @php
                          $matchkey="";$start_date="";$end_date="";
                          if(isset($_GET['start_date'])){
                            $start_date = $_GET['start_date'];
                          }
                          if(isset($_GET['end_date'])){
                            $end_date = $_GET['end_date'];
                          }
                          @endphp
                              <div class="form-row">
                                  <div class="form-group col-md-6 mb-0">
                                      <label>Start Date</label>
                                      <div class="form-group col-md-6">
                                      <input type="text" required="" name="start_date" id="start_date" class="pull-left form-control datetimepickerget w-95" value="{{isset($start_date) && !empty($start_date) ? $start_date:date('Y-m-01')}}" autocomplete="off">
                                  </div>
                                  </div>

                                  <div class="form-group col-md-6 mb-0">
                                      <label>End Date</label>
                                      <div class="form-group col-md-6">
                                      <input type="text" required="" name="end_date" id="end_date" class="pull-left form-control datetimepickerget w-95" value="{{isset($end_date) && !empty($end_date) ? $end_date:date('Y-m-d')}}" autocomplete="off">
                                  </div>
                                  </div>
                               </div>
                               <br/>
                              <div class="form-row">
                                <button type="submit" class="btn btn-primary show-data">Download TDS Report</button>
                                &nbsp;
                              </div>
                    {{ Form::close() }}
                    <button class="btn btn-primary" id="usersWalletData">Get TDS Report</button>
                    <!-- <button type="submit" class="btn btn-primary btn-sm"><i class="fa fa-file-excel-o mr-2"></i> Download CSV</a></button>-->
                    <button class="btn btn-primary btn-sm" onclick="refreshUserBalance()">Refresh Data</button>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="dataList" class="display" style="min-width: 845px">
                            <thead>
                                <tr>
                                <th>S No.</th>
                                <th>
                                    User ID
                                  </th>
                                  <th>
                                      Pan Number
                                    </th>
                                  <th>
                                    TDS Amount
                                  </th>
                                  <th>
                                  Amount
                                </th>
                                <th>Actual Amount</th>
                                <th> Series ID</th>
                                <th>Created At</th>
                                <th>Action</th>
                            </tr>
                            </thead>

                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script type="text/javascript">
      var fieldname = '';
      var filtercolums = {

      }

      function refreshUserBalance(){
        window.location.href="https://admin.royal11.live/admin/users_balance_detail_cron?isButton=true";
      }

      function cancelEvent(){
        event.stopPropagation();
      }

      var input_filter_teamname = '';


      function updateURL(event , fieldname){
        var value = event.target.value;

        if(fieldname == 'filter_teamname'){
          input_filter_teamname = value;
        }


        var url = window.location.href.split('?')[0];
        history.pushState('', '', url+"?filter=1&filter_teamname="+input_filter_teamname);

      }

      function filterData(event , fieldname){

        var value = event.target.value;
         updateURL(event,fieldname);

        if(fieldname == 'filter_teamname'){
          filtercolums['filter_teamname'] = value;
        }

        //URL UPDATE

        $('#dataList').DataTable().clear().destroy(); //clear table data Table

        $('#dataList').DataTable({
             order: [0, 'desc'],
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.tdsreport_userwise')}}",
              type: "POST",
              data : {"_token": "{{ csrf_token() }}" , "filter_columns":filtercolums}
            },

            "columns": [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'userid', name: 'userid'},
              {data: 'pan_number', name: 'pan_number'},
              {data: 'tds_amount', name: 'tds_amount'},
              {data: 'amount', name: 'amount'},
              {data: 'actual_amount', name: 'actual_amount'},
              {data: 'seriesid', name: 'seriesid'},
              //{data: 'perks', name: 'perks'},
              {data: 'created_at', name: 'created_at'},
              {data: 'action', name: 'action'}
            ]
        });

        document.getElementById(fieldname).focus();
      }

</script>

<script type="text/javascript">
$(document).ready(function() {

  $('#end_date,#start_date').datetimepicker({
      timepicker: false,
      format:'Y-m-d'
  });

    usersWalletData();

    $(document).on('click','#refresh_users_wallet', function(){
        $('#dataList').DataTable().clear().destroy();
        usersWalletData();
    });

    $(document).on('click','#usersWalletData', function(){
        $('#dataList').DataTable().clear().destroy();
        usersWalletData();
    });

    function usersWalletData(){
      let filter_teamname = '';
      let filter_email = '';
      let filter_mobile = '';

      let filter_start_date = $('#start_date').val();
      let filter_end_date = $('#end_date').val();

      var filtercolums = {

      }
      // FOR SELECT Filtering
      if(filter_teamname !==''){
        filtercolums['filter_teamname'] = filter_teamname;
      }

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

        $('#dataList').DataTable({
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.tdsreport_userwise')}}",
              type: "POST",
                  data : {"_token": "{{ csrf_token() }}" , "filter_columns":filtercolums,"filter_start_date":filter_start_date,"filter_end_date":filter_end_date }
            },
            "columns": [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'userid', name: 'userid'},
              {data: 'pan_number', name: 'pan_number'},
              {data: 'tds_amount', name: 'tds_amount'},
              {data: 'amount', name: 'amount'},
              {data: 'actual_amount', name: 'actual_amount'},
              {data: 'seriesid', name: 'seriesid'},
              //{data: 'perks', name: 'perks'},
              {data: 'created_at', name: 'created_at'},
              {data: 'action', name: 'action'}
            ]
        });
        return true;
    }

  //  $( "#Downlode_TDSForm" ).submit();
});
</script>
@endsection