@extends('admin.layouts.masterlayout')
@section('styles')

<link href="{{asset('new_theme/assets/plugins/datatable/css/dataTables.bootstrap5.min.css')}}" rel="stylesheet" />
@endsection
@section('content')
<div class="main-content">
    <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 d-flex align-items-end gap-3">

                                <div class="form-group mr-3">
                                    <label for="start_date">Start Date</label>
                                    <input type="text" required name="start_date" id="start_date"
                                          class="form-control datetimepickerget"
                                          value="{{ isset($start_date) && !empty($start_date) ? $start_date : date('Y-m-01 H:i:s') }}"
                                          autocomplete="off">
                                </div>

                                <div class="form-group mr-3">
                                    <label for="end_date">End Date</label>
                                    <input type="text" required name="end_date" id="end_date"
                                          class="form-control datetimepickerget"
                                          value="{{ isset($end_date) && !empty($end_date) ? $end_date : date('Y-m-d H:i:s') }}"
                                          autocomplete="off">
                                </div>

                                <div class="form-group mr-3">
                                    <button type="submit" class="btn btn-primary" id="download-button">Download TDS Report</button>
                                </div>

                          
                    {{ Form::close() }}
                            <div class="form-group mr-3">
                              
                              <button class="btn btn-primary mr-3" id="usersWalletData">Get TDS Report</button>
                            </div>
                              </div>
                    <!-- <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="table table-striped table-bordered"  style="width:100%">
                            <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>
@endsection
@section('scripts')
<script src="{{asset('new_theme/assets/plugins/datatable/js/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('new_theme/assets/plugins/datatable/js/dataTables.bootstrap5.min.js')}}"></script>
<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: true,
      format:'Y-m-d h:i:s'
  });

    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();

        let filtercolums = {};
        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: function(d) {
                d._token = "{{ csrf_token() }}";
                d.filter_columns = filtercolums;
                d.filter_start_date = filter_start_date;
                d.filter_end_date = filter_end_date;
            },
            dataSrc: function (json) {
                if (json.data.length === 0) {
                $('#download-button').hide(); // ✅ Hide button
                } else {
                $('#download-button').show(); // ✅ Show button
                }
                return json.data;
            }
            },
            "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: 'created_at', name: 'created_at'},
            {data: 'action', name: 'action'}
            ]
        });
        }

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