@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