@extends('layouts.adminapp')

@section('content')
<style>
    .hiddenRow {
    padding: 0 !important;
}
</style>

{{-- Company --}}
<x-app-flash/>
{{-- <h1 class="h3 mb-2 text-gray-800">{{__('lng.ClassUpgrade')}}</h1> --}}
    
    <!-- DataTales Example -->
<form action="{{route('ClassUpgraded')}}" method="POST" >
    @csrf
    <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">{{__('lng.ClassUpgrade')}}</h6>
        </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.Class')}}</th>
                            <th>{{__('lng.Upgrade')}}</th>
                            <th class="text-center" colspan="2">{{__('lng.Action')}}</th>
                        </tr>
                    </thead>
                    <tbody>
                     @php $sl=0; @endphp
                     @foreach ($Classes as $Class)
                     <tr  >
                        <input type="hidden" name="class_id" value="{{$Class->id}}">
                         <td>{{ ++$sl }}</td>
                        <td>{{ $Class->title }}</td>
                        <td>
                           <select class="form-control @error('upgrade_id') is-invalid @enderror"  id="cbStudentClass" name="class_ids[{{$Class->id}}]" required>
                               @php
                               echo (new App\Http\Controllers\StudentClassController())->StudentClassListForCombo(0);
                               @endphp
                               <option value="0">{{__('lng.PassOut')}}</option>
                           </select>
                        </td>
                        <td>
                         <button type="button" data-toggle="collapse" id="Detailbtn{{$Class->id}}" data-target="#PayDetail{{$Class->id}}" class="accordion-toggle btn btn-info btn-icon-split" >
                           <span class="icon text-white-50" id="spanicon{{$Class->id}}">
                              <i class="fas fa-angle-down"></i>
                          </span>
                          <span class="text" id="spantext{{$Class->id}}">{{__('lng.Students')}}</span>
                         </button>
                         </td>
                     </tr>
                     <tr>
                        <td colspan="12" class="hiddenRow m-0">
                           <div class="accordian-body collapse" id="PayDetail{{$Class->id}}">
                              <table class="table table-striped">
                                 <thead>
                                    <tr class="info">
                                       <th>{{ __('lng.Name') }}</th>
                                       <th>{{ __('lng.DOB') }}</th>
                                       <th>{{ __('lng.Gender') }}</th>
                                       <th>{{ __('lng.HouseName') }}</th>
                                       <th>{{ __('lng.PaidAmount') }}</th>
                                       <th>
                                        <span style="color:red;">{{__('lng.Pending')}}</span> / <span style="color:blue;">{{__('lng.Advance')}}</span> {{__('lng.Amount')}}
                                       </th>
                                       <th>{{ __('lng.Passed') }}</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                                    @foreach ($Class->Student->where('isCancelled',0) as $Student)
                                    <input type="hidden" name="student_id[]" value="{{$Student->id}}">
                                    @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
                                     <tr data-toggle="collapse" class="accordion-toggle" data-target="#demo10">
                                         <td>{{$Student->name}}</td>
                                         <td>{{$DOB}}</td>
                                         <td>{{$Student->gender}}</td>
                                         <td>{{$Student->housename}}</td>
                                         <td>@amount($PayedAmount+$PayedVehicleAmounts)</td>
                                         <td>
                                            @if ($Balance < 0)
                                            <span style="color:blue;">@amount(abs($Balance)) </span>
                                            @else
                                            <span style="color:red;">@amount(abs($Balance)) </span>
                                            @endif
                                        </td>
                                         <td>
                                            <div class="form-check">
                                            <input class="form-check-input" type="checkbox" name="Student_Ids[{{$Student->id}}]"  id="flexCheckDefault" checked>
                                            </label>
                                          </div>
                                         </td>
                                     </tr>
                                    @endforeach
                                 </tbody>
                              </table>
                           </div>
                        </td>
                     </tr>
                     @endforeach
                    </tbody>
                </table>
            </div>
         </div>
         <div class="card-footer">
            <div class="d-flex  justify-content-start p-2" style="width:50%;float:left;">
                <input type="text" class="form-control  w-50" required name="batch_year" placeholder="{{__('lng.BatchYear')}}">
            </div>
            <div class="d-flex  justify-content-end p-2">
                <button type="reset" class="btn btn-secondary btn-icon-split mr-2" name="btnSave">
                    <span class="icon text-white-50">
                        <i class="fas fa-trash"></i>
                    </span>
                    <span class="text">{{__('lng.Clear')}}</span>
                </button>
                <button type="submit" class="btn btn-success btn-icon-split">
                    <span class="icon text-white-50">
                        <i class="fas fa-check"></i>
                    </span>
                    <span class="text">{{__('lng.ClassUpgrade')}}</span>
                </button>
            </div>
         </div>
    </div>
</form>

@endsection