@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">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header">
                  <div class="d-flex justify-content-between align-items-center mb-3">
                      <h4 class="mb-0">Yearly Session Report</h4>
                      <form action="{{route('Analytics.download_account_report_session')}}" method="get" class="mb-0">
                        <button type="submit" class="btn btn-primary btn-circle raised rounded-circle d-flex gap-2 wh-48"><i class="material-icons-outlined">download</i> CSV File</button>
                      </form>
                  </div>

                  <div class="d-flex align-items-right" data-aos="fade-up" style="float: right;">
                      <div class="btn-group" role="group">
                        <button type="button" id="sessionDropdownBtn" class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false">
                          Select Session
                        </button>
                        <ul class="dropdown-menu">
                          <li><a class="dropdown-item session-filter" data-value="2025-2026" href="#">2025-2026</a></li>
                          <!-- <li><a class="dropdown-item session-filter" data-value="2025-2026" href="#">2025-2026</a></li> -->
                        </ul>
                      </div>
                      <input type="hidden" id="filter_session" name="filter_session" value="2024-2025"> <!-- stores selected value -->
                  </div>
                  
              </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>Mobile</th>
                                <th>Email</th>
                                <th>Team</th>
                                <th> Pan Number </th>
                                <th>Session Year</th>
                                <th>Opening Balance </th>
                                <th>Total Deposit</th>
                                <th>Total Commission</th>
                                <th>Total Withdraw </th>
                                <th>Total TDS Deducted</th>
                                <th>Clossing Balance </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 = {
      'filter_user_id':'',
      'filter_mobile':'',
      'filter_email':'',
      'filter_team':'',
      'filter_session_year':'',
      'filter_live_match_investment':'',
      'filter_total_withdraw':'',
      'filter_total_tds_dedcuted':'',
      'filter_balance':'',
      'filter_winning':'',
      'filter_tds_liability':'',
      'filter_tds_deducted_liability':'',
      'filter_status':''
    }
    function cancelEvent(){
      event.stopPropagation();
    }
      function filterData(event , fieldname){
      let users_type = $('#filter_users').val().trim();

        var value = event.target.value;
      //  updateURL(event,fieldname);
      if(fieldname == 'filter_user_id'){
        filtercolums['filter_user_id'] = value;
      }
      if(fieldname == 'filter_mobile'){
        filtercolums['filter_mobile'] = value;
      }
      if(fieldname == 'filter_email'){
        filtercolums['filter_email'] = value;
      }
      if(fieldname == 'filter_team'){
        filtercolums['filter_team'] = value;
      }
      if(fieldname == 'filter_session_year'){
        filtercolums['filter_session_year'] = value;
      }
      if(fieldname == 'filter_live_match_investment'){
        filtercolums['filter_live_match_investment'] = value;
      }
      if(fieldname == 'filter_total_withdraw'){
        filtercolums['filter_total_withdraw'] = value;
      }
      if(fieldname == 'filter_total_tds_dedcuted'){
        filtercolums['filter_total_tds_dedcuted'] = value;
      }
      if(fieldname == 'filter_balance'){
        filtercolums['filter_balance'] = value;
      }
      if(fieldname == 'filter_winning'){
        filtercolums['filter_winning'] = value;
      }
      if(fieldname == 'filter_tds_liability'){
        filtercolums['filter_tds_liability'] = value;
      }
      if(fieldname == 'filter_tds_deducted_liability'){
        filtercolums['filter_tds_deducted_liability'] = value;
      }
      if(fieldname == 'filter_status'){
        filtercolums['filter_status'] = value;
      }
      //URL UPDATE
      var url = window.location.href.split('?')[0];
      history.pushState('', '', url+"?filter=1&filter_user_id="+filtercolums['filter_user_id']
      +"&filter_mobile="+filtercolums['filter_mobile']+"&filter_email="+filtercolums['filter_email']
      +"&filter_team="+filtercolums['filter_team']+"&filter_session_year="+filtercolums['filter_session_year']
      +"&filter_live_match_investment="
      +filtercolums['filter_live_match_investment']+"&filter_total_withdraw="+filtercolums['filter_total_withdraw']
      +"&filter_total_tds_dedcuted="+filtercolums['filter_total_tds_dedcuted']
      +"&filter_balance="+filtercolums['filter_balance']+"&filter_winning="
      +filtercolums['filter_winning']+"&filter_tds_liability="+filtercolums['filter_tds_liability']
      +"&filter_tds_deducted_liability="+filtercolums['filter_tds_deducted_liability']+"&filter_status="+filtercolums['filter_status']);
      $('#dataList').DataTable().clear().destroy(); //clear table data Table

      $('#dataList').DataTable({
          "orderable":true,
          "searchable": false,
          "iDisplayLength" : 100,
          "aLengthMenu": [200, 400, 800, "All"],
          order: [0, 'desc'],
          "processing": true,
          "serverSide": true,
          "ajax":{
            url:"{{route('Registerusers.get_account_report_session')}}",
            type: "POST",
            data : {"_token": "{{ csrf_token() }}" ,"filter_columns":filtercolums}
          },
          "columns": [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'user_id', name: 'user_id'},
              {data: 'mobile', name: 'mobile'},
              {data: 'email', name: 'email'},
              {data: 'team', name: 'team'},
              {data: 'pan_number', name: 'pan_number'},
              {data: 'session_year', name: 'session_year'},
              {data: 'oppening_balance', name: 'oppening_balance'},
              {data: 'total_deposit', name: 'total_deposit'},
              {data: 'total_commission', name: 'total_commission'},
              {data: 'total_withdraw', name: 'total_withdraw'},
              {data: 'tds_deducted', name: 'tds_deducted'},
              {data: 'clossing_balance', name: 'clossing_balance'},
              // {data: 'action', name: 'action', orderable: false, searchable: false},
          ],


      });

      document.getElementById(fieldname).focus();

    }










$(document).ready(function() {
  var users_type = '';
  allRegisterUsers(users_type);

  $(document).on('change','#filter_users', function(){
    let option_value = $(this).val().trim();
    $('#dataList').DataTable().clear().destroy();
    // allRegisterUsers(option_value);

  });

});

  function allRegisterUsers(users_type){

    var filtercolums = {
      'filter_teamname':'',
      'filter_key_search':'',
      'filter_email':'',
      'filter_mobile':'',
      'filter_mobile_request':'',
      'filter_email_request':'',
      'filter_pan_request':'',
      'filter_bank_request':'',
      'filter_adhar_request':''
    }

    let filter_key_search = '';
    let filter_teamname = '';
    let filter_email = '';
    let filter_mobile= '';
    //new filtered
    let filter_mobile_request= '';
    // alert(filter_mobile_request);
    let filter_email_request= '';
    let filter_pan_request= '';
    let filter_bank_request= '';
    let filter_adhar_request= '';

          // for Filtering
      if(filter_teamname !==''){
        filtercolums['filter_teamname'] = filter_teamname;
      }
      if(filter_key_search !==''){
        filtercolums['filter_key_search'] = filter_key_search;
      }
      if(filter_email !==''){
        filtercolums['filter_email'] = filter_email;
      }
      if(filter_mobile !==''){
        filtercolums['filter_mobile'] = filter_mobile;
      }
      //new filtered column
      if(filter_mobile_request !==''){
        filtercolums['filter_mobile_request'] = filter_mobile_request;
      }
      if(filter_email_request !==''){
        filtercolums['filter_email_request'] = filter_email_request;
      }
      if(filter_pan_request !==''){
        filtercolums['filter_pan_request'] = filter_pan_request;
      }
      if(filter_bank_request !==''){
        filtercolums['filter_bank_request'] = filter_bank_request;
      }
      if(filter_adhar_request !==''){
        filtercolums['filter_adhar_request'] = filter_adhar_request;
      }


    $('#dataList').DataTable({
      //order: [1, 'DESC'],
      // dom: 'lrt',
      "orderable":true,
      "searchable": false,
      "iDisplayLength" : 100,
      "aLengthMenu": [200, 400, 800, "All"],
        "processing": true,
        "serverSide": true,
        "ajax":{
          url:"{{route('Registerusers.get_account_report_session')}}",
          type: "POST",
          data : {"_token": "{{ csrf_token() }}","users_type":users_type,"filter_columns":filtercolums}
        },
        "columns": [
            {data: 'DT_RowIndex', name: 'DT_RowIndex'},
           {data: 'user_id', name: 'user_id'},
           {data: 'mobile', name: 'mobile'},
           {data: 'email', name: 'email'},
           {data: 'team', name: 'team'},
           {data: 'pan_number', name: 'pan_number'},
           {data: 'session_year', name: 'session_year'},
           {data: 'oppening_balance', name: 'oppening_balance'},
           {data: 'total_deposit', name: 'total_deposit'},
           {data: 'total_commission', name: 'total_commission'},
           {data: 'total_withdraw', name: 'total_withdraw'},
           {data: 'tds_deducted', name: 'tds_deducted'},
           {data: 'clossing_balance', name: 'clossing_balance'},
            // {data: 'action', name: 'action', orderable: false, searchable: false},
          ],

    });
  }

  $("#filter_session").change(function(){
    var filter_session  = $('#filter_session').val();
    var filtercolums = {
      'filter_teamname':'',
      'filter_key_search':'',
      'filter_email':'',
      'filter_mobile':'',
      'filter_mobile_request':'',
      'filter_email_request':''
    }

    let filter_key_search = '';
    let filter_teamname = '';
    let filter_email = '';
    let filter_mobile= '';
    let filter_mobile_request= '';
    let filter_email_request= '';

      // for Filtering
      if(filter_teamname !==''){
        filtercolums['filter_teamname'] = filter_teamname;
      }
      if(filter_key_search !==''){
        filtercolums['filter_key_search'] = filter_key_search;
      }
      if(filter_email !==''){
        filtercolums['filter_email'] = filter_email;
      }
      if(filter_mobile !==''){
        filtercolums['filter_mobile'] = filter_mobile;
      }
      //new filtered column
      if(filter_mobile_request !==''){
        filtercolums['filter_mobile_request'] = filter_mobile_request;
      }
      if(filter_email_request !==''){
        filtercolums['filter_email_request'] = filter_email_request;
      }



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


    $('#dataList').DataTable({
      "orderable":true,
      "searchable": false,
        "iDisplayLength" : 100,
      "aLengthMenu": [200, 400, 800, "All"],
        "processing": true,
        "serverSide": true,
        "ajax":{
          url:"{{route('Registerusers.get_account_report_session')}}",
          type: "POST",
          data : {"_token": "{{ csrf_token() }}" ,"filter_columns":filtercolums,"filter_session":filter_session}
        },
        "columns": [
            {data: 'DT_RowIndex', name: 'DT_RowIndex'},
           {data: 'user_id', name: 'user_id'},
           {data: 'mobile', name: 'mobile'},
           {data: 'email', name: 'email'},
           {data: 'team', name: 'team'},
           {data: 'pan_number', name: 'pan_number'},
           {data: 'session_year', name: 'session_year'},
           {data: 'oppening_balance', name: 'oppening_balance'},
           {data: 'total_deposit', name: 'total_deposit'},
           {data: 'total_commission', name: 'total_commission'},
           {data: 'total_withdraw', name: 'total_withdraw'},
           {data: 'tds_deducted', name: 'tds_deducted'},
           {data: 'clossing_balance', name: 'clossing_balance'},
            // {data: 'action', name: 'action', orderable: false, searchable: false},
        ],

    });
  });

</script>

<script type="text/javascript">
  $(document).on('click', '.deleteProduct', function () {
    if(!confirm("Are You Sure to delete this"))
    event.preventDefault();
  });

 $(document).on('click', '.submitper', function () {
    $('#getplayer_id').val($(this).data('id'));
    $('#is_yoububer').val($(this).data('status'));
    $('#myModal').modal('show');
  });

  $(document).on('click', '.edit-userbalance', function () {
    var userbalance_id=$(this).attr('data-id');
    var tranasation_id=$(this).attr('data-tranasation-id');
    $('#user_balance_id').val(userbalance_id);
    $('#user_tranasation_id').val(tranasation_id);
    $('#edit_userbalance').modal('show');
  });

  $(document).on('click', '.user-deactivate-button', function () {
    var user_id=$(this).attr('data-user-id');
    $('#deactivate_user_id').val(user_id);
    $('#userDeactivateModal').modal('show');
  });

  $(document).on('click', '.action-users', function () {
    if(!confirm("Are You Sure update this status?"))
    event.preventDefault();
  });

</script>
<script>
$(document).ready(function () {
    $('.session-filter').on('click', function (e) {
        e.preventDefault();
        var sessionText = $(this).text();
        var sessionValue = $(this).data('value');

        $('#sessionDropdownBtn').text(sessionText);
        $('#filter_session').val(sessionValue).change();
    });
});
</script>

@endsection