| {{ __('lng.Name') }} |
{{ __('lng.DOB') }} |
{{ __('lng.Gender') }} |
{{ __('lng.HouseName') }} |
{{ __('lng.PaidAmount') }} |
{{ __('lng.Pending') }} / {{ __('lng.Advance') }}
{{ __('lng.Amount') }}
|
{{ __('lng.Passed') }} |
@foreach ($Class->Student->where('isCancelled', 0) as $Student)
@php
$VehicleBalance = $SetVehicleFeeAmounts = $PayedVehicleAmounts = 0;
$DOB = date('F-d-Y', strtotime($Student->dob));
//STUDENT FEE CALCULATION
$SetFeeAmount = 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('amount');
$SetFeeAdditional = 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('additional_charge');
$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');
//STUDENT VEHICLE FEE CALCULATION
$StudentVehicleRouteAssign = App\Models\StudentVehicleRouteAssign::where(
'student_id',
$Student->id,
)
->where(function ($query) {
$query
->where('isCancelled', 0)
->orWhere('isCancelled', null);
})
->first();
if ($StudentVehicleRouteAssign) {
$SetVehicleFeeAmounts = App\Models\StudentVehicleSetFee::where(
'student_vehicle_route_id',
$StudentVehicleRouteAssign->id,
)
->where('batch_year', $Student->batch_year)
->where(function ($query) {
$query
->where('isCancelled', 0)
->orWhere('isCancelled', null);
})
->sum('total_amount');
$PayedVehicleAmounts = 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');
$VehicleBalance =
$SetVehicleFeeAmounts - $PayedVehicleAmounts;
}
$Balance =
$SetFeeAmount +
$SetFeeAdditional -
$PayedAmount +
$VehicleBalance;
if ($Student->DRorCR) {
if ($Student->DRorCR == 'Dr') {
$Balance += $Student->openingbalance;
} else {
$Balance -= $Student->openingbalance;
}
}
@endphp
| {{ $Student->name }} |
{{ $DOB }} |
{{ $Student->gender }} |
{{ $Student->housename }} |
@amount($PayedAmount + $PayedVehicleAmounts) |
@if ($Balance < 0)
@amount(abs($Balance))
@else
@amount(abs($Balance))
@endif
|
|
@endforeach
|
@endforeach