@extends('admin.layouts.default')
@section('content')
<!-- DATATABLE GLOBAL SCRIPTS -->
  {{ HTML::style('css/admin/datatable.css') }}
  {{ HTML::script("js/admin/datatable.js") }}
<!-- DATATABLE GLOBAL SCRIPTS -->
<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>Bank Withdraw Requests</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="javascript:void(0)">Bank Withdraw Requests</a></li>
            </ol> -->
        </div>
    </div>
    <div class="row">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header">
                <div class="card-body p-0">
                    <div class="basic-form">
                      {{ Form::open(['role' => 'form','id'=>'panUpdateDetailForm','route'=>[$modelName.'.upload_withdrawl_excel'],'files' => true]) }}
                    {{csrf_field()}}
                            <div class="form-row">
                                <div class="col-md-8">
                                    <div class="form-group">
                                        <h4>Bank Withdraw Requests</h4>
                                    </div>
                                </div>
                                <div class="col-md-4 d-flex justify-content-between">
                                    <div class="form-group flex-fill pr-3 mb-0">
                                        <!-- <input type="file" required="" name="file" class="pull-left form-control" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel"> -->
                                    </div>
                                    <!-- <button type="submit" class="btn btn-primary"><i class="fa fa-file-excel-o mr-2"></i>Upload CSV</button> -->
                                </div>

                                <!-- <div class="form-group col-md-4">
                                    <input type="file" required="" name="file" class="pull-left form-control" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel">
                                </div>
                                <button type="submit" class="btn btn-primary"><i class="fa fa-file-excel-o"></i>Upload CSV</button>
                            </div> -->
                            </div>
                        {{ Form::close() }}
                    </div>
                </div>
                </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>Baneficiary</th>
                                <th>Acc Number</th>
                                <th>
                                  <input type="text" id="filter_mobile" name="filter_mobile" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_mobile')">
                                  Mobile Number</th>
                                <th>
                                  <input type="text" id="filter_withdraw_amount" name="filter_withdraw_amount" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_withdraw_amount')">
                                  Withdrawl Amount</th>
                                <th>User Name</th>
                                <th>
                                  <input type="text" id="filter_withdraw_request_id" name="filter_withdraw_request_id" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_withdraw_request_id')">
                                  Withdraw Request ID</th>
                                <th>Bank IFSC Code</th>
                                <th>
                                  <input type="text" id="filter_bankname" name="filter_bankname" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_bankname')">
                                  Bank Name</th>
                                <th>
                                  <input type="text" id="filter_bankbranch" name="filter_bankbranch" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_bankbranch')">
                                  Bank Branch</th>
                                <th>
                                  <input type="text" id="filter_email" name="filter_email" value="" onclick="cancelEvent()" onkeyup="filterData(event , 'filter_email')">
                                  User Email</th>
                                <!-- <th>Approve Manual</th> -->
                                <th>Requested Date</th>
                                <th>Approved Date</th>
                                <th>
                                  <select  id="filter_withdraw_status" name="filter_withdraw_status" onclick="cancelEvent()" onchange="filterData(event , 'filter_withdraw_status')">
                                    <option selected value="">All</option>
                                    <option  value="0" >Pending</option>
                                    <option  value="1">Approved</option>
                                    <option  value="-1">Rejected</option>
                                  </select>
                                  Admin Comment
                                </th>
                                <th>Action</th>
                            </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                <th>S No.</th>
                                <th>Baneficiary</th>
                                <th>Acc Number</th>
                                <th>Mobile Number</th>
                                <th>Withdrawl Amount</th>
                                <th>User Name</th>
                                <th>Withdraw RequestId</th>
                                <th>Bank IFSC Code</th>
                                <th>Bank Name</th>
                                <th>Bank Branch</th>
                                <th>User Email</th>
                                <!-- <th>Approve Manual</th> -->
                                <th>Requested Date</th>
                                <th>Approved Date</th>
                                <th>Admin Comment</th>
                                <th>Action</th>
                            </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript">


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

var filtercolums = {

};

var input_filter_mobile = '';
var input_filter_withdraw_amount = '';
var input_filter_bankname = '';
var input_filter_withdraw_request_id = '';
var input_filter_email = '';
var input_filter_bankbranch = '';
var input_filter_withdraw_status = '';

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


  if(fieldname == 'filter_mobile'){
    input_filter_mobile = value;
  }
  if(fieldname == 'filter_withdraw_amount'){
    input_filter_withdraw_amount = value;
  }
  if(fieldname == 'filter_bankname'){
    input_filter_bankname = value;
  }
  if(fieldname == 'filter_withdraw_request_id'){
    input_filter_withdraw_request_id = value;
  }
  if(fieldname == 'filter_email'){
    input_filter_email = value;
  }
  if(fieldname == 'filter_bankbranch'){
    input_filter_bankbranch = value;
  }
  if(fieldname == 'filter_withdraw_status'){
    input_filter_withdraw_status = value;
  }

  var url = window.location.href.split('?')[0];
  history.pushState('', '', url+"?filter=1&filter_mobile="+input_filter_mobile+"&filter_withdraw_amount="+input_filter_withdraw_amount+"&filter_bankname="+input_filter_bankname+"&filter_withdraw_request_id="+input_filter_withdraw_request_id+"&filter_bankbranch="+input_filter_bankbranch+"&filter_email="+input_filter_email+"&filter_withdraw_status="+input_filter_withdraw_status);

}
function filterData(event , fieldname){

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

if(fieldname == 'filter_mobile'){
  filtercolums['filter_mobile'] = value;
}
if(fieldname == 'filter_withdraw_amount'){
  filtercolums['filter_withdraw_amount'] = value;
}
if(fieldname == 'filter_bankname'){
  filtercolums['filter_bankname'] = value;
}
if(fieldname == 'filter_withdraw_request_id'){
  filtercolums['filter_withdraw_request_id'] = value;
}
if(fieldname == 'filter_email'){
  filtercolums['filter_email'] = value;
}
if(fieldname == 'filter_bankbranch'){
  filtercolums['filter_bankbranch'] = value;
}
if(fieldname == 'filter_withdraw_status'){
  filtercolums['filter_withdraw_status'] = value;
}

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

  $('#dataList').DataTable({
    order: [0, 'desc'],
      "processing": true,
      "serverSide": true,
      "ajax":{
        url:"{{route($modelName.'.withdraw_amount_bank')}}",
        type: "POST",
        data : {"_token": "{{ csrf_token() }}","filter_columns":filtercolums}
      },
      "columns": [
          {data: 'DT_RowIndex', name: 'DT_RowIndex'},
          {data: 'banid', name: 'banid'},
          {data: 'accno', name: 'accno'},
          {data: 'mobile', name: 'mobile'},
          {data: 'withdraw_amount', name: 'withdraw_amount'},
          {data: 'username', name: 'username'},
          {data: 'withdraw_request_id', name: 'withdraw_request_id'},
          {data: 'ifsc', name: 'ifsc'},
          {data: 'bankname', name: 'bankname'},
          {data: 'bankbranch', name: 'bankbranch'},
          {data: 'email', name: 'email'},
          // {data: 'approve_bank_manual', name: 'approve_bank_manual'},
          {data: 'withdraw_request', name: 'withdraw_request'},
          {data: 'approved_date', name: 'approved_date'},
          {data: 'withdraw_status', name: 'withdraw_status'},
          {data: 'action', name: 'action',orderable: false, searchable: false},
      ]
      });

      document.getElementById(fieldname).focus();

}
$(document).ready(function() {
  let filter_mobile = '';
  let filter_withdraw_amount = '';
  let filter_bankname = '';
  let filter_withdraw_request_id = '';
  let filter_email = '';
  let filter_bankbranch = '';
  let filter_withdraw_status = '';


    if(filter_mobile!==''){
      filtercolums['filter_mobile'] = filter_mobile;
    }
    if(filter_withdraw_amount!==''){
      filtercolums['filter_withdraw_amount'] = filter_withdraw_amount;
    }
    if(filter_bankname!==''){
      filtercolums['filter_bankname'] = filter_bankname;
    }
    if(filter_withdraw_request_id!==''){
      filtercolums['filter_withdraw_request_id'] = filter_withdraw_request_id;
    }
    if(filter_bankbranch!==''){
      filtercolums['filter_bankbranch'] = filter_bankbranch;
    }
    if(filter_email!==''){
      filtercolums['filter_email'] = filter_email;
    }
    if(filter_withdraw_status!==''){
      filtercolums['filter_withdraw_status'] = filter_withdraw_status;
    }


    $('#dataList').DataTable({
      order: [0, 'desc'],
        "processing": true,
        "serverSide": true,
        "ajax":{
          url:"{{route($modelName.'.withdraw_amount_bank')}}",
          type: "POST",
          data : {"_token": "{{ csrf_token() }}","filter_columns":filtercolums}
        },
        "columns": [
            {data: 'DT_RowIndex', name: 'DT_RowIndex'},
            {data: 'banid', name: 'banid'},
            {data: 'accno', name: 'accno'},
            {data: 'mobile', name: 'mobile'},
            {data: 'withdraw_amount', name: 'withdraw_amount'},
            {data: 'username', name: 'username'},
            {data: 'withdraw_request_id', name: 'withdraw_request_id'},
            {data: 'ifsc', name: 'ifsc'},
            {data: 'bankname', name: 'bankname'},
            {data: 'bankbranch', name: 'bankbranch'},
            {data: 'email', name: 'email'},
            // {data: 'approve_bank_manual', name: 'approve_bank_manual'},
            {data: 'withdraw_request', name: 'withdraw_request'},
            {data: 'approved_date', name: 'approved_date'},
            {data: 'withdraw_status', name: 'withdraw_status'},
            {data: 'action', name: 'action',orderable: false, searchable: false},
        ]
        });

//
// $(document).ready(function() {
//     $('#dataList').DataTable({
//       order: [1, 'desc'],
//         "processing": true,
//         "serverSide": true,
//         "ajax":{
//           url:"{{route($modelName.'.withdraw_amount_bank')}}",
//           type: "POST",
//           data : {"_token": "{{ csrf_token() }}"}
//         },
//         "columns": [
//             {data: 'DT_RowIndex', name: 'DT_RowIndex'},
//             {data: 'banid', name: 'banid'},
//             {data: 'accno', name: 'accno'},
//             {data: 'mobile', name: 'mobile'},
//             {data: 'withdraw_amount', name: 'withdraw_amount'},
//             {data: 'username', name: 'username'},
//             {data: 'withdraw_request_id', name: 'withdraw_request_id'},
//             {data: 'ifsc', name: 'ifsc'},
//             {data: 'bankname', name: 'bankname'},
//             {data: 'bankbranch', name: 'bankbranch'},
//             {data: 'email', name: 'email'},
//             // {data: 'approve_bank_manual', name: 'approve_bank_manual'},
//             {data: 'withdraw_request', name: 'withdraw_request'},
//             {data: 'approved_date', name: 'approved_date'},
//             {data: 'withdraw_status', name: 'withdraw_status'},
//             {data: 'action', name: 'action',orderable: false, searchable: false},
//         ]
//     });

    $(document).on('click','.admin-comment',function(){
        let form_type = $(this).data("type").trim();
        let text_comment = $(this).closest(".text-comment").val();
        if(text_comment == ''){
            alert("please fill input field.");
            return false;
        }
        else {
            let input = jQuery('<input type="hidden"  name="type" value="'+form_type+'">');
            $(this).closest('form').append(input);
            $(this).form[0].submit();
        }
    });

});
</script>
@endsection