{{ __('lng.StudentDetails') }}

@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) @endif @endforeach

{{__('lng.SiNo')}}	{{__('lng.Name')}}	{{__('lng.Contact')}}	{{__('lng.HouseName')}}	{{__('lng.Gender')}}	{{__('lng.Place')}}	{{__('lng.BalanceAmount')}}
{{++$i}}	{{$Student->name}}	{{$Student->mobile}}	{{$Student->housename}}	{{$Student->gender}}	{{$Student->place}}	@currency($Balance)