@extends('backend.layouts.app')

@section('title', 'Ledger History')
@section('page-title', 'Ledger History')
@section('page-breadcrumb', 'Ledger History')


@section('content')

<div class="content mt-3">

<div class="animated fadeIn">


                <div class="row">
                    <div class="col-lg-12">



                      <div class="row">
                          <div class="col-lg-12">


                          <div class="card">
                    <h5 class="card-header">
                    <strong><i class="fa fa-user-plus fa-lg"></i> Ledger List</strong>

                    </h5>
                    <!--Card content-->


                    <form class="card" id="form_id" name="SearchForm" action="LedgerListDataNew" method="POST" enctype="multipart/form-data" >

                      @csrf
                    <div class="card-body">
                    <!-- Form -->

                    <div class="form-body">
                    <!-- User Details -->



                    <hr>


                    <div class="row">


                    <!--/span-->
                    @if(Auth::user()->user_type>4)
                    <div class="col-md-12">
                    <div class="form-group row">
                    <label class="form-label col-md-3" for="UserDetails_LastName">Channel ID</label>
                    <div class="col-md-3">
                    <select class="form-control select" required="" style="width:100%" id="channel_id" name="channel_id"  tabindex="-1" aria-hidden="true">
                    <option  value="">Select</option>
                    
                    </select>

                    </div>
                    </div>
                    </div>
                    @else
                    <input type="hidden" id="channel_id" name="channel_id" value="{{config('app.channel_id')}}">
                    @endif



                    <div class="col-md-12">
                    <div class="form-group row">
                    <label class="form-label col-md-3" for="UserDetails_FirstName">User Type<span class="text-danger"> *</span></label>
                    <div class="col-md-3">
                    <select onchange="get_user_list()" class="form-control select " required="" style="width:100%" id="user_type" name="user_type" tabindex="-1" aria-hidden="true">

                    @if(Auth::user()->user_type>4)
                    <option value="4" >Channel User</option>
                    @endif
                    @if(Auth::user()->user_type>2)
                    <option value="2">Master</option>
                    @endif
                    @if(Auth::user()->user_type>1)
                    <option  value="1" value="1">Distributer</option>
                    @endif
                    @if(Auth::user()->user_type>0)
                    <option  value="0" value="0">Retailer</option>
                    @endif
                    @if(Auth::user()->user_type==0)
                    <option  value="0" value="0">Retailer</option>
                    @endif

                    </select>

                    </div>
                    </div>
                    </div>

                    <div class="col-md-12">
                    <div class="form-group row">
                    <label class="form-label col-md-3" for="UserDetails_LastName">User ID</label>
                    <div class="col-md-3">
                    <select  class="form-control select standardSelect" required="" style="width:100%" id="user_id" name="user_id"  tabindex="-1" aria-hidden="true">
                      @if(Auth::user()->user_type==0)
                      <option  value="{{Auth::user()->id}}">{{Auth::user()->first_name}}</option>
                      @endif
                      
                      <option  value="">All</option>
                    </select>

                    </div>
                    </div>
                    </div>

                    <!--/span-->
                    <div class="col-md-12">
                    <div class="form-group row">
                    <label class="form-label col-md-3" for="UserDetails_LastName">Ledger Type</label>
                    <div class="col-md-3">
                    <select class="form-control select " required="" style="width:100%" id="credit_type" name="credit_type" tabindex="-1" aria-hidden="true">
                        
                        @php
                                        if($qdata['t_type']=="CR"){
                                            echo "<option value='CR'>Wallet</option>";
                                        }
                                        else{
                                           echo "<option value='DR'>Loan</option>";
                                        }

                                        @endphp
                        <option value="CR">Wallet</option>
                
                      <option value="DR">Loan</option>
                        </select>

                    </div>
                    </div>
                    </div>
                    <!--/span-->
                    
                        <div class="col-md-12">
                    <div class="form-group row">
                    <label class="form-label col-md-3" for="UserDetails_LastName">Transaction Type</label>
                    <div class="col-md-3">
                    <select class="form-control select " required="" style="width:100%" id="transaction_type" name="transaction_type" tabindex="-1" aria-hidden="true">
                       <option value="all">all</option>
                       <option value="CR">CR</option>
                
                      <option value="DR">DR</option>
                         </select>

                    </div>
                    </div>
                    </div>
                    
                    

                    <div class="col-md-12">
                        <div class="form-group row">
                            <label class="form-label col-md-3" for="UserDetails_DOB">Start Date<span class="text-danger"> *</span></label>
                            <div class="col-md-3">
                                <input class="form-control Date"  required="" type="text" id="start_date" name="start_date" value="{{ date('Y-m-d') }}">

                            </div>
                        </div>
                    </div>

                    <div class="col-md-12">
                        <div class="form-group row">
                            <label class="form-label col-md-3" for="UserDetails_DOB">End Date<span class="text-danger"> *</span></label>
                            <div class="col-md-3">
                                <input class="form-control Date"  required="" type="text" id="end_date" name="end_date" value="{{ date('Y-m-d') }}">

                            </div>
                        </div>
                    </div>


                    </div>

                    </div>
                    </div>
                    <div class="card-footer">
                     <button type="button" onclick="get_data();"  class="btn btn-primary btn-sm waves-effect waves-light">
                    Search <i class="fa fa-arrow-circle-right fa-lg"></i>
                    </button>

                    </div>





                    </form>
                    <!-- Form -->

                    </div>



                    <!-- ============================================================== -->

                    </div>

                   
                    <div class="col-lg-12" id="ajax_loader">
                  
                    
                    <div class="card">
    <div class="card-header card-header-color">
        <span class="h4"><i class="fa fa-list-alt"></i> Ledger History -  @php
                                        if($qdata['t_type']=="CR"){
                                            echo "Wallet";
                                        }
                                        else{
                                           echo "Loan";
                                        }

                                        @endphp
                                        </span>

    </div>


    <!--Card content-->
    <div class="card-body">
                                <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                  @php
                                  $i = 0;
                                  $j = 0;
                                  @endphp
                                  <thead>
                                        <tr>
                                            <th>Id</th>
                                            <th>User Name</th>
                                            <th>UserID</th>
                                            
                                            <th>Amount</th>
                                            <th>Amount Edit</th>
                                            <th>Remark</th>
                                            <th>Remark Edit</th>
                                            <th>T Type</th>
                                            <th>F Type</th>
                                            
                                            <th>ServiceType</th>
                                            <th>ServiceType Edit</th>
                                            <th>Student Details</th>
                                            <th>Service ID</th>
                                            <th>Service ID Edit</th>
                                            
                                            <th>Created At</th>

                                        </tr>
                                    </thead>
                                    <tbody>
                                      @foreach($fund_list as $row)
                                      <tr>

                                        <td>{{$row->userID}}</td>
                                        <td>{{$row->first_name}} {{$row->last_name}}</td>
                                         <td>{{$row->user_id}}</td>
                                       
                                        <td>{{$row->amount}}</td>
                                        <td><input type="text" value="{{$row->amount}}" onblur="reset_service('amount',this.value,{{$row->id}})"></td>
                                        
                                        <td>{{$row->remark}}</td>
                                        <td><textarea onblur="reset_service('remark',this.value,{{$row->id}})"> {{$row->remark}}</textarea></td>
                                         
                                        
                                        
                                         
                                         
                                        @php
                                        if($row->t_type=="CR"){
                                            $i = $i+$row->amount;
                                        }
                                        else{
                                          $j = $j+$row->amount;
                                        }

                                        @endphp

                                        
                                        <td>{{$row->t_type}}</td>
                                         <td>{{$row->credit_type}}</td>
                                       
                                        <td>{{$row->service_cat}}</td>
                                        
                                         
                                             <td><select onchange="reset_service('service_cat',this.value,this.id)" class="form-control select chosen " required="" style="width:100%" id="{{$row->id}}" name="servicecat_id" tabindex="-1" aria-hidden="true">
                                    
                                   
                                <option value="{{$row->service_cat}}"  selected >{{$row->service_cat}}</option>
                                <option value="1" >1</option>
                                <option value="2" >2</option>
                        
                                      
                                  </select></td>
                                  
                                        
                                       
                                         @php
                                        if(strlen($row->std_id)>1){
                                            echo'<td><a target="_blank" href="https://www.asdigital.us/bbose-panel/student-form-display.php?unique_id='.$row->std_id.'">Student Details</a></td>';
                                        }
                                        else{
                                          echo'<td></td>';
                                        }

                                        @endphp
                                        
                                       <td>{{$row->service_id}}</td>
                                       
                                             <td><select onchange="reset_service('service_id',this.value,this.id)" class="form-control select chosen " required="" style="width:100%" id="{{$row->id}}" name="service_id" tabindex="-1" aria-hidden="true">
                                    <option  value="">Please Select Service</option>
                                    @foreach($service_operator_list as $service)
                                              <option  value="{{$service->id}}" @if($row->service_id==$service->id) selected  @endif >{{$service->service_name}} ({{$service->operator_name}})</option>
                        
                                      @endforeach
                                  </select></td>
                                  
                                        
                                        
                                        <td>{{$row->created_at}}</td>
                                      </tr>
                                      @endforeach

                                      <tfoot>
                                      <tr>
                                        <td>Total Transactions during this period</td>
                                        <td><b>CR {{$i}}</b></td>
                                        <td><b>DR {{$j}}</b></td>
                                        <td colspan="3"></td>
                                      </tr>
                                    </tfoot>



                                    </tbody>
                                </table>
                            </div>
</div>
<!-- Form -->

  </div>

<style>
textarea{width:250px;
height:150px;
}
</style>


   </div>





    <!-- ============================================================== -->

</div>



</div>
</div>


</div>

@endsection

@section('self_script')
<script src="{{ asset('assets/vendor/datatables.net/js/jquery.dataTables.min.js') }}"></script>

   <script src="{{ asset('assets/vendor/datatables.net-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
   <script src="{{ asset('assets/vendor/datatables.net-buttons/js/dataTables.buttons.min.js') }}"></script>
   <script src="{{ asset('assets/vendor/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js') }}"></script>



   <script src="{{ asset('assets/js/init-scripts/data-table/datatables-init.js') }}"></script>

<script type="text/javascript">

function get_user_list(){

  user_type=document.getElementById('user_type').value;
  parent_id=document.getElementById('channel_id').value;

  var xmlhttp = new XMLHttpRequest();
   xmlhttp.onreadystatechange = function() {
       if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
         document.getElementById('user_id').innerHTML=xmlhttp.responseText;
         update_chosen('user_id');
       }
   }
   xmlhttp.open("GET", "UserLevelCommissionUser?parent_id="+parent_id+"&user_type="+user_type, true);
   xmlhttp.send();

}

function reset_service(col_name,col_data,tran_id){

  credit_type=document.getElementById('credit_type').value;
  
  
  var xmlhttp = new XMLHttpRequest();
   xmlhttp.onreadystatechange = function() {
       if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
        // document.getElementById('user_id').innerHTML=xmlhttp.responseText;
         
       }
   }
   xmlhttp.open("GET", "LedgerListUpdateNew?"+col_name+"="+col_data+"&id="+tran_id+"&credit_type="+credit_type, true);
   xmlhttp.send();

}



function update_chosen(id)
   {
     $("#"+id).trigger("chosen:updated");

   }

   function get_data() {
       document.getElementById("form_id").submit();
    //   var fd = new FormData(document.forms["SearchForm"]);
    //   var xhr = new XMLHttpRequest();
    //   xhr.onreadystatechange = function() {
    //       if (xhr.readyState == 4 && xhr.status == 200) {
    //          document.getElementById('ajax_notify').innerHTML=xhr.responseText;
    //       }
    //   }
    //   xhr.open('POST', 'LedgerListDataNew', true);
    //   xhr.send(fd);
   }

</script>


<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script>
$( function() {
$( "#start_date" ).datepicker({
  changeMonth: true,
  changeYear: true,
  dateFormat:"yy-mm-dd",});

  $( "#end_date" ).datepicker({
    changeMonth: true,
    changeYear: true,
    dateFormat:"yy-mm-dd",});


} );
</script>


<script>
  jQuery(document).ready(function() {
      jQuery(".standardSelect").chosen({
          disable_search_threshold: 10,
          no_results_text: "Oops, nothing found!",
          width: "100%"
      });
  });
</script>


@endsection