@extends('layouts.adminapp')
@section('content')

{{-- Day Book --}}
<x-app-flash/>

            <a href="{{route('PendingStudentFeeReport')}}" class="btn  btn-primary mb-2 btn-icon-split btn-sm">
                  <span class="icon text-white-50">
                      <i class="fas fa-arrow-left"></i>
                  </span>
                  <span class="text">{{__('lng.Back')}}</span>
               </a>
    <!-- DataTales Example -->
    <div class="card shadow mb-4">
        <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
            <h6 class="m-0 font-weight-bold text-primary">{{$Class->title}} - {{__('lng.PendingStudentFee')}}</h6>
            <div class="input-group w-25 m-2 input-search">
                <input type="text" id="SearchHouse" oninput="Search(this.value)" class="form-control bg-light border" placeholder="{{__('lng.SearchStudent')}}" aria-label="Search" aria-describedby="basic-addon2">
                <div class="input-group-append">
                  <button class="btn btn-primary" type="button">
                      <i class="fas fa-search fa-sm"></i>
                  </button>
                </div> 
              </div>
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>{{__('lng.SiNo')}}</th>
                            <th>{{__('lng.Name')}}</th>
                            <th>{{__('lng.Contact')}}</th>
                            <th>{{__('lng.HouseName')}}</th>
                            <th>{{__('lng.Gender')}}</th>
                            <th>{{__('lng.Place')}}</th>
                            <th><span style="color:red;">{{__('lng.BalanceAmount')}}</span></th>
                        </tr>
                    </thead>
                    <tbody id="result-tbl">
                        @php $i=0;@endphp
                        @foreach ($Students as $Student)
                        @php 
                        $dob =  date("m-d-Y",strtotime($Student->dob));
                        $SetAmount=App\Models\SetFee::where('class_id',$Student->class_id)
                        ->where('batch_year',$Student->batch_year)
                        ->where(function($query) {
                                    $query->where('isCancelled',0)
                                    ->orWhere('isCancelled',NULL);
                            })->sum('total_amount');
                        $PayedAmount=App\Models\PayFee::where('student_id',$Student->id)
                        ->where('batch_year',$Student->batch_year)
                        ->where(function($query) {
                                    $query->where('isCancelled',0)
                                    ->orWhere('isCancelled',NULL);
                            })->sum('amount');
                        $Balance= $SetAmount - $PayedAmount;
                        if($Student->DRorCR){
                            if($Student->DRorCR == 'Dr'){
                                $Balance +=$Student->openingbalance;
                            }
                            else{
                                $Balance -=$Student->openingbalance;
                            }
                        }
                        @endphp
                        @if($Balance>0)
                            <tr>
                                <td>{{++$i}}</td>
                                <td>{{$Student->name}}</td>
                                <td>{{$Student->mobile}}</td>
                                <td>{{$Student->housename}}</td>
                                <td>{{$Student->gender}}</td>
                                <td>{{$Student->place}}</td>
                                <td>
                                    <span style="color:red;">@currency($Balance)</span>
                                </td>
                            </tr>
                        @endif
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
        <div class="card-footer">
  
         <form method="POST" action="{{ route('StudentFeedetailsPrint') }}" enctype='multipart/form-data'>
            @csrf
            <input type="hidden" name="class_id" value="{{$Class->id}}" id="ClassID">
            <div class="d-flex  justify-content-end p-2">
               <button onclick="getPrint()" type="submit" class="btn btn-info btn-icon-split">
                  <span class="icon text-white-50">
                     <i class="fas fa-print"></i>
                  </span>
                  <span class="text">{{ __('lng.Print') }}</span>
               </button>
            </div>
         </form>
        </div>
    </div>


    <script>
        
       
    function Search(Value) {
        var ClassID=document.getElementById('ClassID').value;
        $.ajax({
            url: '{{ route('PendingStudentFeeSearch') }}',
            method: "get",
            data: {_token: '{{ csrf_token() }}',Value:Value,ClassID:ClassID},
            success: function (response){  
            // alert(response);
                document.getElementById('result-tbl').innerHTML=response; 
            }
        }); 
    }
    </script>
@endsection