@extends('layouts.adminapp')

@section('content')

<div class="card mb-4" style="text-align: center;">
           
    <div id="printableArea" style="height: 100%;" >
        <style>
            body
            {
                font-size:15px;
                font-family: 'Roboto', sans-serif;
            }
            .table1 {
              border-collapse: collapse;
            }
            
            .table1, .th1, .td1 {
              border: 1px solid black;
            }
        
            h1,h2,h3,h4,h5,h6,p {
                margin: 5;
            }
        
            .result-table {
                width: 100%;
                margin-top: 10px;
            }
        
            .result-table th {
                height: 50px;
                border-bottom: 1px solid #ddd;
                border-left: 1px solid #ddd;
            }
        
             .result-table td {
                border-bottom: 1px solid #ddd;
                border-left: 1px solid #ddd;
                padding: 5px;
            }
            
            .btn-part {
                
            }
        
            .btn-print{
               padding:18px 30px;
               border-color:black;
               background-color:inherit;
               border-radius:40px;
               margin-top: 10px;
           }
           .btn-print:hover{
               padding:18px 30px;
               color:white;
               background-color:black;
               border-radius:40px;
               cursor: pointer;
           }
            
            
           @page {
        }
        </style>
        <script>
        function printDiv(divName) {
         var printContents = document.getElementById(divName).innerHTML;
         var originalContents = document.body.innerHTML;
        
         document.body.innerHTML = printContents;
        
         window.print();
        
         document.body.innerHTML = originalContents;
         
        }
        </script> 
        <div style="padding:5px;" >
   
            <!-------------------  HEAD  -------------------------------------->
            <div style="border:double; padding: 10px; width: 100%; float: left;">
                
                @include('PrintHeader.header')

                <div style="padding:20px 0; text-align:center;"><h4>{{$Class->title}} - {{__('lng.PendingStudentVehicleFees')}}</h4></div>
                <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.Vehicle')}}</th>
                        <th>{{__('lng.Route')}}</th>
                        <th><span style="color:red;">{{__('lng.BalanceAmount')}}</span></th>
                     </tr>
                  </thead>
                  <tbody id="result-tbl">
                    @php $i=0;@endphp
                    @foreach ($Students as $Student)
                    @if ($Student->VehicleFee->Route?? '')
                    @php 
                    $SetFeeAmounts=App\Models\StudentVehicleSetFee::where('student_vehicle_route_id',$Student->VehicleFee->id)
                        ->where('batch_year',$Student->batch_year)
                        ->where(function($query) {
                                    $query->where('isCancelled',0)
                                    ->orWhere('isCancelled',NULL);
                            })->sum('total_amount');
                    $PayedAmounts=App\Models\StudentVehiclePayFee::where('student_id',$Student->id)
                        ->where('batch_year',$Student->batch_year)
                        ->where(function($query) {
                                    $query->where('isCancelled',0)
                                    ->orWhere('isCancelled',NULL);
                            })->sum('amount');
                    $Balance=$SetFeeAmounts - $PayedAmounts;
                    @endphp
                    @if($Balance>0)
                        <tr>
                            <td>{{++$i}}</td>
                            <td>{{$Student->name}}</td>
                            <td>{{$Student->mobile}}</td>
                            <td>{{$Student->VehicleFee->Vehicle->name ?? ''}}</td>
                            <td>{{$Student->VehicleFee->Route->title ?? ''}}</td>
                            <td>
                                <span style="color:red;">@currency($Balance)</span>
                            </td>
                        </tr>
                    @endif
                    @endif
                    @endforeach
                  </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="btn-part">
        <a  onclick="history.back()" class="btn  btn-primary m-3 btn-icon-split" >
            <span class="icon text-white-50">
                <i class="fas fa-arrow-left"></i>
            </span>
            <span class="text">{{__('lng.Back')}}</span>
         </a>
        <button type="button" onclick="printDiv('printableArea')" class="btn  btn-info m-3 btn-icon-split" >
            <span class="icon text-white-50">
                <i class="fas fa-print"></i>
            </span>
            <span class="text">{{__('lng.PrintForm')}}</span>
        </button>
    </div>
</div>
@endsection