@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.PendingStudentFee')}}</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.HouseName')}}</th>
                        <th>{{__('lng.Gender')}}</th>
                        <th>{{__('lng.Place')}}</th>
                        <th><span style="color:red;">{{__('lng.BalanceAmount')}}</span></th>
                     </tr>
                  </thead>
                  <tbody id="result-tbl">
                     @php $si=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)
                         <tr>
                             <td>{{++$si}}</td>
                             <td>{{$Student->name}}</td>
                             <td>{{$Student->mobile}}</td>
                             <td>{{$Student->housename}}</td>
                             <td>{{$Student->gender}}</td>
                             <td>{{$Student->place}}</td>
                             <td>
                                 <span style="color:red;">@currency($Balance)</span>
                             </td>
                         </tr>
                     @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