@php
  // use DateTime;
@endphp
<script type="text/javascript">
  $('#loadingModal').hide();
</script>

<style media="screen">
.table > thead > tr > th,
.table > tbody > tr > th,
.table > tfoot > tr > th,
.table > thead > tr > td,
.table > tbody > tr > td,
.table > tfoot > tr > td  {

  line-height:1;
  font-size: 10px !important;
}

.table thead tr th {
  position: relative;
  word-break: normal;
  text-transform: capitalize !important;
}

.left{
  float: left;
}
.right{
  float: right;
}
.center{
  text-align:left;
  margin:0 auto !important;
  display:inline-block
}
.left{
  text-align: left;
  margin-left: 80px !important;
  display: inline-block;
}

th, td {
  padding: 2px !important;
}
</style>

<div class="container-fluid">
 <div class="row" style="color: black;">
   <div class="row" style="padding-bottom: 0px; text-align: center; vertical-align: middle; color: black; font-weight: bold; "> {{-- div for Company --}}
     @php
       $company = DB::table('gnr_company')->where('id', Auth::user()->company_id_fk)->select('name','address')->first();
     @endphp

       <span style="font-size:14px;">{{$company->name}}</span><br/>
       <span style="font-size:11px;">{{$company->address}}</span><br/>
       <span style="font-size:14px;">Daily Recoverable and Collection Register</span>
   </div>
   {{-- <div class="col-md-12">
     <h3><center> <strong>Ambala Foundation</strong> </center></h3>
     <h4> <center> <strong>House # 67, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka- 1207</strong> </center> </h4>
   </div> --}}
   {{-- <div class="row">
     <div class="col-md-12">
       <h3> <center> <strong>Member Ledger Report</strong> </center> </h3>
     </div>
   </div> --}}
   <div class="row">
     <div class="col-md-8" style="float: left">

       <strong>
         <table style="font-size:11px;">
           @foreach ($BranchInfo as $key => $Branch)
             <tr>
               <td>Branch Name & Code </td>
               <td>:</td>
               <td>
                 {{$Branch->name}}({{$Branch->branchCode}})
               </td>
             </tr>
             <tr>
               <td>Branch Address </td>
               <td>:</td>
               <td>
                 {{$Branch->address}}
               </td>
             </tr>
           @endforeach
         </table>
       </strong>
     </div>
     <div class="col-md-4" style="float: right">
       <table style="font-size:11px;">
         <tr>
           <td><strong>Reporting Date </strong><br></td>
           <td>:</td>
           <td>
             <strong>
               {{$RequestedDate}}
             </strong>
           </td>
         </tr>
         <tr>
           <td><strong>Print Date </strong><br></td>
           <td>:</td>
           <td> <strong>2026-07-21</strong> </td>
         </tr>
       </table>

     </div>
   </div>
   </div>
   <br>

   @php
     $SizeOfSavingsAmount = sizeof($SavingsProduct);
     // echo $SizeOfSavingsAmount;
   @endphp

   <div class="row">
     {{-- <div class="table-responsive"> --}}

     <table class="table table-bordered" border="1pt solid ash" style=" text-align: center; font-family: arial; color:black; border-collapse: collapse; font-size: 10px !important;" width="100%">
       <thead style="font-size:11px;">

         <tr>

           <th colspan="1" rowspan="3">
             <div align="center">Field Worker
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Samity
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Product
             </div>
           </th>
           <th colspan="2" rowspan="1">
             <div align="center">Disbursement Amount
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Actual Recoverable Loan Amount
             </div>
           </th>
           <th colspan="4" rowspan="1">
             <div align="center">Recoverable Loan Amount
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+1}}" rowspan="1">
             <div align="center">Recoverable Savings Amount
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+12}}" rowspan="1">
             <div align="center">Recovery Amount
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Total Recovery
             </div>
           </th>
           <th colspan="4" rowspan="1">
             <div align="center">Due Information
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Signature of CO
             </div>
           </th>

         </tr>

         <tr>
           <th colspan="1" rowspan="2">
             <div align="center">Regular Loan Amount
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Expired Overdue Loan
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Expired Overdue
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Regular Loan
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
           @foreach ($SavingsProduct as $key => $SavingsProducts)
             <th colspan="1" rowspan="2">
               <div align="center">
                 {{$SavingsProducts->shortName}}
               </div>
             </th>
           @endforeach
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
           <th colspan="5" rowspan="1">
             <div align="center">Loan Collection
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+1}}" rowspan="1">
             <div align="center">Savings Collection
             </div>
           </th>
           <th colspan="6" rowspan="1">
             <div align="center">Others Collection
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Over Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">New Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
         </tr>

         <tr>
           <th colspan="1" rowspan="1">
             <div align="center">Regular
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Over Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Advance
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>
           @foreach ($SavingsProduct as $key => $SavingsProducts)
             <th colspan="1" rowspan="1">
               <div align="center">
                 {{$SavingsProducts->shortName}}
               </div>
             </th>
           @endforeach
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Loan Apl. Fee
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Mem. Welfare Fund Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Pass Book/Reg.
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Savings Cheque Book
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Others Income
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>

         </tr>
       </thead>

       @php
       $Day = date_format(date_create($RequestedDate), "D");

       if ($Day == "Sat") {
         $SamityDay = 1;
       }
       elseif ($Day == "Sun") {
         $SamityDay = 2;
       }
       elseif ($Day == "Mon") {
         $SamityDay = 3;
       }
       elseif ($Day == "Tue") {
         $SamityDay = 4;
       }
       elseif ($Day == "Wed") {
         $SamityDay = 5;
       }
       elseif ($Day == "Thu") {
         $SamityDay = 6;
       }


       $SizeOfFieldOfficers = 0;
       $Signature_Of_CO = 0;
       $Signature_Of_COo = 0;

         $NumberOfFieldOffiecers = DB::select("SELECT DISTINCT(fieldOfficerId) FROM mfn_samity WHERE branchId='$RequestedBranchInfos'");
         $NumberOfSamity = DB::select("SELECT DISTINCT(id) FROM mfn_samity WHERE branchId='$RequestedBranchInfos'");
         $SizeOfFieldOfficers = sizeof($NumberOfFieldOffiecers);

         if ($RequestedLoanOptions == 1) {
           foreach ($NumberOfSamity as $key => $NumberOfSamitys) {
             $NumberOfProducts = DB::select("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk='$NumberOfSamitys->id'");
             $SizeOfFieldOfficers = $SizeOfFieldOfficers + sizeof($NumberOfProducts);
           }
         }
         elseif ($RequestedLoanOptions == 2) {
           foreach ($NumberOfSamity as $key => $NumberOfSamitys) {
             $NumberOfProducts = DB::select("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk='$NumberOfSamitys->id'");
             $SizeOfFieldOfficers = $SizeOfFieldOfficers + sizeof($NumberOfProducts);
           }
         }
         // echo $SizeOfFieldOfficers;
       @endphp

       @php
         $gg = '';
         $AA = 0;
         $BB = 0;
         $TTRow = 0;
         $TRow = 0;
         $Large = 0;
         $Total = 0;
         $PTR = '';
         $LoopCounter = 0;
         $EXPIRED_OVERDUE_LOAN = 0;
         $EXPIRED_OVERDUE = 0;
         $Recoverable_Loan_Amount_Current_Due = 0;
         $Recoverable_Loan_Amount_REGULAR_LOAN = 0;
         $Recoverable_Loan_Amount_TOTAL = 0;
         $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = 0;
         $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = 0;
         $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = 0;
         $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = 0;
         $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = 0;
         $RECOVERY_SAVINGS_AMOUNT_TOTAL = 0;
         $TOTAL_RECOVERY = 0;
         $DUE_INFORMATION_TOTAL = 0;
         $SamityPC = array();

         $TOTAL_LOAN1 = 0;
         $TOTAL_LOAN2 = 0;
         $TOTAL_LOAN3 = 0;
         $TOTAL_LOAN4 = 0;
         $TOTAL_LOAN5 = 0;
         $TOTAL_LOAN6 = 0;
         $TOTAL_LOAN7 = 0;
         $TOTAL_LOAN8 = 0;
         $TOTAL_LOAN9 = 0;
         $TOTAL_LOAN10 = 0;
         $TOTAL_LOAN11 = 0;
         $TOTAL_LOAN12 = 0;
         $TOTAL_LOAN13 = 0;
         $TOTAL_LOAN14 = 0;
         $TOTAL_LOAN15 = 0;
         $TOTAL_LOAN16 = 0;
         $TOTAL_LOAN17 = 0;
         $TOTAL_LOAN18 = 0;
         $XX = 0;
         $YY = 0;
         $KK = 0;
         $XX1 = 0;
         $YY1 = 0;
         $KK1= 0;
         $TOTAL_SAVINGS_RECOVERABLE = 0;
         $TOTAL_SAVINGS_COLLECTION = 0;

         $SUB_TOTAL1 = 0;
         $SUB_TOTAL2 = 0;
         $SUB_TOTAL3 = 0;
         $SUB_TOTAL4 = 0;
         $SUB_TOTAL5 = 0;
         $SUB_TOTAL6 = 0;
         $SUB_TOTAL7 = 0;
         $SUB_TOTAL8 = 0;
         $SUB_TOTAL9 = 0;
         $SUB_TOTAL10 = 0;
         $SUB_TOTAL11 = 0;
         $SUB_TOTAL12 = 0;
         $SUB_TOTAL13 = 0;
         $SUB_TOTAL14 = 0;
         $SUB_TOTAL15 = 0;
         $SUB_TOTAL16 = 0;
         $SUB_TOTAL17 = 0;
         $SUB_TOTAL18 = 0;
         $SUB_TOTAL19 = 0;
         $SUB_TOTAL20 = 0;
         $SUB_TOTAL21 = 0;
         $SUB_TOTAL22 = 0;
         $SUB_TOTAL23 = 0;
         $SUB_TOTAL24 = 0;
         $SUB_TOTAL25 = 0;
         $SUB_TOTAL26 = 0;
         $SUB_TOTAL27 = 0;
         $SUB_TOTAL28 = 0;
         $SUB_TOTAL29 = 0;
         $SUB_TOTAL30 = 0;

         $TABLE1_TOTAL1 = 0;
         $TABLE1_TOTAL2 = 0;
         $TABLE1_TOTAL3 = 0;
         $TABLE1_TOTAL4 = 0;
         $TABLE1_TOTAL5 = 0;
         $TABLE1_TOTAL6 = 0;
         $TABLE1_TOTAL7 = 0;
         $TABLE1_TOTAL8 = 0;
         $TABLE1_TOTAL9 = 0;
         $TABLE1_TOTAL10 = 0;
         $TABLE1_TOTAL11 = 0;
         $TABLE1_TOTAL12 = 0;
         $TABLE1_TOTAL13 = 0;
         $TABLE1_TOTAL14 = 0;
         $TABLE1_TOTAL15 = 0;
         $TABLE1_TOTAL16 = 0;
         $TABLE1_TOTAL17 = 0;
         $TABLE1_TOTAL18 = 0;
         $TABLE1_TOTAL19 = 0;
         $TABLE1_TOTAL20 = 0;
         $TABLE1_TOTAL21 = 0;
         $TABLE1_TOTAL22 = 0;
         $TABLE1_TOTAL23 = 0;
         $TABLE1_TOTAL24 = 0;
         $TABLE1_TOTAL25 = 0;
         $TABLE1_TOTAL26 = 0;
         $TABLE1_TOTAL27 = 0;
         $TABLE1_TOTAL28 = 0;
         $TABLE1_TOTAL29 = 0;
         $TABLE1_TOTAL30 = 0;

         $SamityID = 0;
         $SamityIDA = 0;
         $SamityID1 = 0;
         $SamityID1A = 0;
         $SamityIDcount = 0;
         $SavingsProduct_Total = array();
         $SavingsProduct_Total_Collections = array();
         $SavingsProduct_subTotal_ALL_Total = 0;
         $SavingsProduct_subTotal_ALL_Collections_Total = 0;
       @endphp

       <tbody style="font-size: 10px !important;">
         @php
           $TRow = sizeof($RequiredTableInfos);
           // echo $TRow;
         @endphp
         @foreach ($RequiredTableInfos as $key1 => $RequiredTableInfos1)
           @php
           $Comp = explode('/', $key1);
           list($first, $second, $third) = $Comp;
           $AA = 1;
           $Row = sizeof($RequiredTableInfos1);
           // if ($TTRow > $Large) {
             $Large = $Row;
           // }
           // echo '='.$Large.'=';
           @endphp

           @foreach ($RequiredTableInfos1 as $key2 => $RequiredTableInfos2)
             @php
             $TTRow = sizeof($RequiredTableInfos2);
             $Comp1 = explode('/', $key2);
             list($fourth, $fifth, $sixth) = $Comp1;
             $BB = 1;
             $TTRow = sizeof($RequiredTableInfos2);
             if ($RequestedLoanOptions == 1) {
               $SamityRowSpan = DB::select( DB::raw("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk = '$fourth' AND branchIdFk='$RequestedBranchInfos' AND disbursementDate <= '$RequestedDate'") );

             }
             elseif ($RequestedLoanOptions == 2) {
               $SamityRowSpan = DB::table('mfn_loan')
                                ->select(DB::raw('DISTINCT(mfn_loans_product.productCategoryId)'))
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                ->groupBy('mfn_loans_product.productCategoryId')
                                ->get();
             }
             $SamitySize = sizeof($SamityRowSpan);
             if ($RequestedProduct != 'all') {
               $SamitySize = 1;
             }
             $Total = $Total + $SamitySize;
             // echo 'TOTAL : '.$Total.' Size : '.$SamitySize;
             @endphp
           @endforeach
           @foreach ($RequiredTableInfos1 as $key2 => $RequiredTableInfos2)
             @php
             $Comp1 = explode('/', $key2);
             list($fourth, $fifth, $sixth) = $Comp1;
             $BB = 1;
             $TTRow = sizeof($RequiredTableInfos2);

             if ($RequestedLoanOptions == 1) {
               $SamityRowSpan = DB::select( DB::raw("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk = '$fourth' AND branchIdFk='$RequestedBranchInfos' AND disbursementDate <= '$RequestedDate'") );

             }
             elseif ($RequestedLoanOptions == 2) {
               $SamityRowSpan = DB::table('mfn_loan')
                                ->select(DB::raw('DISTINCT(mfn_loans_product.productCategoryId)'))
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                ->groupBy('mfn_loans_product.productCategoryId')
                                ->get();
             }
             $SamitySize = sizeof($SamityRowSpan);
             if ($RequestedProduct != 'all') {
               $SamitySize = 1;
             }
             // echo '()'.$SamitySize.'()';
             @endphp

             @foreach ($RequiredTableInfos2 as $key3 => $RequiredTableInfos3)
               @php
                 $LoopCounter = $LoopCounter + 1;
               @endphp
               @php
               @endphp
                 @if ($PTR != $RequiredTableInfos3['PName'])
                   @php
                     $PTR = $RequiredTableInfos3['PName'];
                     $PTRid = $RequiredTableInfos3['PId'];
                     if ($RequestedLoanOptions == 1) {
                       // REGULAR LOAN AMOUNT
                       $QUERY1 = DB::table('mfn_loan')
                                 // ->select('mfn_loans_product.shortname', 'mfn_loans_product.id')
                                 ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                 ->where('mfn_loan.samityIdFk', $fourth)
                                 ->where('mfn_loans_product.id', $PTRid)
                                 ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                 ->where('mfn_loan.isloanCompleted', '=', 0)
                                 ->sum('mfn_loan.loanAmount');

                      // EXPIRED OVERDUE LOAN
                      $QUERY2A = DB::table('mfn_loan')
                                ->where('samityIdFk', $fourth)
                                ->where('productIdFk', $PTRid)
                                ->where('lastInstallmentDate', '<', $RequestedDate)
                                ->where('isloanCompleted', '=', 0)
                                ->sum('loanAmount');

                      // $QUERY2B = DB::table('mfn_loan')
                      //           // ->select('mfn_loans_product.shortname', 'mfn_loans_product.id')
                      //           ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                      //           ->where('mfn_loan.samityIdFk', $fourth)
                      //           ->where('mfn_loan.productIdFk', $PTRid)
                      //           ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                      //           ->where('mfn_loan.isloanCompleted', '=', 0)
                      //           ->sum('mfn_loan_collection.amount');

                      if ($QUERY2A > 0) {
                        $EXPIRED_OVERDUE_LOAN = $QUERY2A;
                      }

                      // ACTUAL RECOVERABLE LOAN AMOUNT
                      $QUERY3 = DB::table('mfn_loan')
                                // ->select('mfn_loans_product.shortname', 'mfn_loans_product.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      // Recoverable Loan Amount : EXPIRED OVERDUE
                      $Day = date_format(date_create($RequestedDate), "D");

                      if ($Day == "Sat") {
                        $SamityDay = 1;
                      }
                      elseif ($Day == "Sun") {
                        $SamityDay = 2;
                      }
                      elseif ($Day == "Mon") {
                        $SamityDay = 3;
                      }
                      elseif ($Day == "Tue") {
                        $SamityDay = 4;
                      }
                      elseif ($Day == "Wed") {
                        $SamityDay = 5;
                      }
                      elseif ($Day == "Thu") {
                        $SamityDay = 6;
                      }

                      $QUERY4A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan.totalRepayAmount');

                      $QUERY4B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY4A > 0) {
                        $EXPIRED_OVERDUE = $QUERY4A - $QUERY4B;
                        $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $EXPIRED_OVERDUE;
                      }

                      // Recoverable Loan Amount : Current Due
                      $QUERY5A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $QUERY5B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY5A > $QUERY5B) {
                        $Recoverable_Loan_Amount_Current_Due = $QUERY5A - $QUERY5B;
                        $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $Recoverable_Loan_Amount_Current_Due;
                      }
                      elseif ($QUERY5A < $QUERY5B) {
                        $Recoverable_Loan_Amount_Current_Due = 0;
                      }

                      // RECOVERABLE LOAN AMOUNT : REGULAR LOAN
                      $QUERY6A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $QUERY6A;

                      // RECOVERABLE SAVINGS AMOUNT
                      foreach ($SavingsProduct as $key => $SavingsProducts) {
                        $SId = $SavingsProducts->id;
                        // $QUERY7[$SId] = DB::table('mfn_savings_account')
                        //           ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                        //           ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                        //           ->where('mfn_savings_account.samityIdFk', $fourth)
                        //           ->where('mfn_saving_product.id', $SId)
                        //           // ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                        //           ->where('mfn_samity.samityDayId', $SamityDay)
                        //           // ->where('mfn_loan.isloanCompleted', '=', 0)
                        //           ->sum('mfn_savings_account.autoProcessAmount');
                        $QUERY7[$SId] = DB::table('mfn_savings_account')
                                  ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                  ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                                  ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_savings_account.samityIdFk', $fourth)
                                  ->where('mfn_saving_product.id', $SId)
                                  ->where('mfn_loan.productIdFk', $PTRid)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                                  ->sum('mfn_savings_account.autoProcessAmount');
                      }

                      // RECOVERY AMOUNT : REGULAR LOAN COLLECTION
                      $QUERY8 = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $QUERY8;

                      // RECOVERY AMOUNT : OVER DUE LOAN COLLECTION
                      $QUERY9A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan.totalRepayAmount');

                      $QUERY9B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY9A > $QUERY9B) {
                        $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = $QUERY9A - $QUERY9B;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : CURRENT DUE LOAN COLLECTION
                      $QUERY10A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $QUERY10B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loan.productIdFk', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY10A > $QUERY10B) {
                        $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = $QUERY10A - $QUERY10B;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : ADVANCE LOAN COLLECTION
                      if ($QUERY10A < $QUERY10B) {
                        $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = $QUERY10B - $QUERY10A;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : SAVINGS COLLECTION
                      foreach ($SavingsProduct as $key => $SavingsProducts) {
                        $SId = $SavingsProducts->id;
                        // $QUERY11[$SId] = DB::table('mfn_savings_account')
                        //           ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                        //           ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                        //           ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                        //           ->where('mfn_savings_account.samityIdFk', $fourth)
                        //           ->where('mfn_saving_product.id', $SId)
                        //           ->where('mfn_samity.samityDayId', $SamityDay)
                        //           ->sum('mfn_savings_deposit.amount');
                        $QUERY11[$SId] = DB::table('mfn_savings_account')
                                  ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                  ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                  ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                                  ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_savings_account.samityIdFk', $fourth)
                                  ->where('mfn_saving_product.id', $SId)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loan.productIdFk', $PTRid)
                                  ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                                  ->sum('mfn_savings_deposit.amount');
                      }

                     }
                     // IF REQUESTED LOAN OPTION IS LOAN PRODUCT CATEGORY
                     elseif ($RequestedLoanOptions == 2) {
                       // REGULAR LOAN AMOUNT
                       $QUERY1 = DB::table('mfn_loan')
                                 ->select('mfn_loans_product_category.name', 'mfn_loans_product_category.id')
                                 ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                 ->join('mfn_loans_product_category', 'mfn_loans_product.productCategoryId', 'mfn_loans_product_category.id')
                                 ->where('mfn_loan.samityIdFk', $fourth)
                                 ->where('mfn_loans_product.productCategoryId', $PTRid)
                                 ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                 ->where('mfn_loan.isloanCompleted', '=', 0)
                                 // ->distinct()
                                 // ->get();
                                 ->sum('mfn_loan.loanAmount');

                      // EXPIRED OVERDUE LOAN
                       $QUERY2A = DB::table('mfn_loan')
                                 ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                 ->where('mfn_loan.samityIdFk', $fourth)
                                 ->where('mfn_loans_product.productCategoryId', $PTRid)
                                 ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                 ->where('mfn_loan.isloanCompleted', '=', 0)
                                 ->sum('mfn_loan.loanAmount');

                       // $QUERY2B = DB::table('mfn_loan')
                       //           ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                       //           ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                       //           ->where('mfn_loan.samityIdFk', $fourth)
                       //           ->where('mfn_loans_product.productCategoryId', $PTRid)
                       //           ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                       //           ->where('mfn_loan.isloanCompleted', '=', 0)
                       //           ->sum('mfn_loan_collection.amount');

                       if ($QUERY2A > 0) {
                         $EXPIRED_OVERDUE_LOAN = $QUERY2A;
                       }

                       // ACTUAL RECOVERABLE LOAN AMOUNT
                       $QUERY3 = DB::table('mfn_loan')
                                 ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                 ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                 ->where('mfn_loan.samityIdFk', $fourth)
                                 ->where('mfn_loans_product.productCategoryId', $PTRid)
                                 ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                 ->where('mfn_loan.isloanCompleted', '=', 0)
                                 ->sum('mfn_loan_schedule.installmentAmount');

                      // Recoverable Loan Amount : EXPIRED OVERDUE
                      $Day = date_format(date_create($RequestedDate), "D");

                      if ($Day == "Sat") {
                        $SamityDay = 1;
                      }
                      elseif ($Day == "Sun") {
                        $SamityDay = 2;
                      }
                      elseif ($Day == "Mon") {
                        $SamityDay = 3;
                      }
                      elseif ($Day == "Tue") {
                        $SamityDay = 4;
                      }
                      elseif ($Day == "Wed") {
                        $SamityDay = 5;
                      }
                      elseif ($Day == "Thu") {
                        $SamityDay = 6;
                      }

                      $QUERY4A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan.totalRepayAmount');

                      $QUERY4B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY4A > 0) {
                        $EXPIRED_OVERDUE = $QUERY4A - $QUERY4B;
                        $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $EXPIRED_OVERDUE;
                      }

                      // Recoverable Loan Amount : Current Due
                      $QUERY5A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $QUERY5B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY5A > $QUERY5B) {
                        $Recoverable_Loan_Amount_Current_Due = $QUERY5A - $QUERY5B;
                        $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $Recoverable_Loan_Amount_Current_Due;
                      }
                      elseif ($QUERY5A < $QUERY5B) {
                        $Recoverable_Loan_Amount_Current_Due = 0;
                      }

                      // Recoverable Loan Amount : REGULAR LOAN
                      $QUERY6A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $QUERY6A;

                      // RECOVERABLE SAVINGS AMOUNT
                      foreach ($SavingsProduct as $key => $SavingsProducts) {
                        $SId = $SavingsProducts->id;
                        $QUERY7[$SId] = DB::table('mfn_savings_account')
                                  ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                  ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                                  ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_savings_account.samityIdFk', $fourth)
                                  ->where('mfn_saving_product.id', $SId)
                                  ->where('mfn_loans_product.productCategoryId', $PTRid)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                                  ->sum('mfn_savings_account.autoProcessAmount');
                      }

                      // RECOVERY AMOUNT : LOAN COLLECTION
                      $QUERY8 = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $QUERY8;

                      // RECOVERY AMOUNT : OVER DUE LOAN COLLECTION
                      $QUERY9A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan.totalRepayAmount');

                      $QUERY9B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY9A > $QUERY9B) {
                        $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = $QUERY9A - $QUERY9B;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : CURRENT DUE LOAN COLLECTION
                      $QUERY10A = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_schedule.installmentAmount');

                      $QUERY10B = DB::table('mfn_loan')
                                ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                ->where('mfn_loan.samityIdFk', $fourth)
                                ->where('mfn_loans_product.productCategoryId', $PTRid)
                                ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                ->where('mfn_samity.samityDayId', $SamityDay)
                                ->where('mfn_loan.isloanCompleted', '=', 0)
                                ->sum('mfn_loan_collection.amount');

                      if ($QUERY10A > $QUERY10B) {
                        $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = $QUERY10A - $QUERY10B;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : ADVANCE LOAN COLLECTION
                      if ($QUERY10A < $QUERY10B) {
                        $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = $QUERY10B - $QUERY10A;
                        $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                      }

                      // RECOVERY AMOUNT : SAVINGS COLLECTION
                      foreach ($SavingsProduct as $key => $SavingsProducts) {
                        $SId = $SavingsProducts->id;
                        $QUERY11[$SId] = DB::table('mfn_savings_account')
                                  ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                  ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                  ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                                  ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_savings_account.samityIdFk', $fourth)
                                  ->where('mfn_saving_product.id', $SId)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loans_product.productCategoryId', $PTRid)
                                  ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                                  ->sum('mfn_savings_deposit.amount');
                      }

                     }
                   @endphp
                   <tr>
                     @if ($AA == 1)
                       <td rowspan="{{$Total}}" style="text-align: left !important;">{{$second}} <br> ({{$third}})</td>
                       @php
                         $AA = $AA + 1;
                       @endphp
                     @endif
                     @if ($BB == 1)
                       <td rowspan="{{$SamitySize}}" style="text-align: left !important;">{{$fifth}} <br> ({{$sixth}})</td>
                       @php
                         $BB = $BB + 1;
                       @endphp
                     @endif
                   <td>{{$RequiredTableInfos3['PName']}}</td>
                   <td class="amount">{{number_format($QUERY1,2)}}</td>
                   <td class="amount">{{number_format($EXPIRED_OVERDUE_LOAN,2)}}</td>
                   <td class="amount">{{number_format($QUERY3,2)}}</td>
                   <td class="amount">{{number_format($EXPIRED_OVERDUE,2)}}</td>
                   <td class="amount">{{number_format($Recoverable_Loan_Amount_Current_Due,2)}} </td>
                   <td class="amount">{{number_format($QUERY6A,2)}}</td>
                   {{-- @php
                     $SUB_TOTAL6 = $SUB_TOTAL6 + $QUERY6A;
                   @endphp --}}
                   <td class="amount">{{number_format($Recoverable_Loan_Amount_TOTAL,2)}}</td>
                   {{-- @if ($SamityID != $fourth) --}}
                     {{-- @foreach ($QUERY7 as $key => $QUERY7s) --}}
                       {{-- @if ($SamityID != $fourth) --}}
                       {{-- <td class="amount">{{number_format($QUERY7s,2)}}</td> --}}
                       {{-- @php
                         $SamityID = $fourth;
                         $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = $RECOVERABLE_SAVINGS_AMOUNT_TOTAL + $QUERY7s;
                       @endphp --}}
                     {{-- @endforeach --}}
                   {{-- @elseif ($SamityID == $fourth)
                     @foreach ($QUERY7 as $key => $QUERY7s)
                       <td class="amount">0.00</td>
                     @endforeach
                   @endif --}}
                   @foreach ($QUERY7 as $key => $QUERY7s)
                     <td class="amount">{{number_format($QUERY7s,2)}}</td>
                     @php
                       $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = $RECOVERABLE_SAVINGS_AMOUNT_TOTAL + $QUERY7s;
                     @endphp
                   @endforeach
                   {{-- @if ($SamityIDA != $fourth) --}}
                     <td class="amount">{{number_format($RECOVERABLE_SAVINGS_AMOUNT_TOTAL,2)}}</td>
                     {{-- @php
                       $SamityIDA = $fourth;
                     @endphp --}}
                   {{-- @elseif ($SamityIDA == $fourth)
                     <td class="amount">0.00</td>
                   @endif --}}
                   {{-- <td class="amount">{{number_format($RECOVERABLE_SAVINGS_AMOUNT_TOTAL,2)}}</td> --}}
                   <td class="amount">{{number_format($QUERY8,2)}}</td>
                   {{-- @php
                     $SUB_TOTAL8 = $SUB_TOTAL8 + $QUERY8;
                   @endphp --}}
                   <td class="amount">{{number_format($RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION,2)}}</td>
                   <td class="amount">{{number_format($RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION,2)}}</td>
                   <td class="amount">{{number_format($RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION,2)}}</td>
                   <td class="amount">{{number_format($RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL,2)}}</td>
                   {{-- @if ($SamityID1 != $fourth)
                     @foreach ($QUERY11 as $key => $QUERY11s)
                       <td class="amount">{{number_format($QUERY11s,2)}}</td> --}}
                       {{-- @php
                         $SamityID1 = $fourth;
                         $RECOVERY_SAVINGS_AMOUNT_TOTAL = $RECOVERY_SAVINGS_AMOUNT_TOTAL + $QUERY11s;
                       @endphp --}}
                     {{-- @endforeach
                   @elseif ($SamityID1 == $fourth)
                     @foreach ($QUERY11 as $key => $QUERY11s)
                       <td class="amount">0.00</td>
                     @endforeach
                   @endif --}}
                   @foreach ($QUERY11 as $key => $QUERY11s)
                     <td class="amount">{{number_format($QUERY11s,2)}}</td>
                     @php
                       $RECOVERY_SAVINGS_AMOUNT_TOTAL = $RECOVERY_SAVINGS_AMOUNT_TOTAL + $QUERY11s;
                       $SUB_TOTAL24 = $SUB_TOTAL24 + $QUERY11s;
                     @endphp
                   @endforeach
                   {{-- @if ($SamityID1A != $fourth)
                     <td class="amount">{{number_format($RECOVERY_SAVINGS_AMOUNT_TOTAL,2)}}</td>
                     @php
                       $SamityID1A = $fourth;
                     @endphp
                   @elseif ($SamityID1A == $fourth)
                     <td class="amount">0.00</td>
                   @endif --}}
                   <td class="amount">{{number_format($RECOVERY_SAVINGS_AMOUNT_TOTAL,2)}}</td>
                   <td></td>
                   <td></td>
                   <td></td>
                   <td></td>
                   <td></td>
                   <td></td>
                   @php
                     $TOTAL_RECOVERY = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_SAVINGS_AMOUNT_TOTAL;
                   @endphp
                   <td class="amount">{{number_format($TOTAL_RECOVERY,2)}}</td>
                   <td class="amount">{{number_format($EXPIRED_OVERDUE,2)}}</td>
                   @php
                     $NEW_DUE = $QUERY6A - $QUERY8;
                     if ($NEW_DUE > 0) {
                       // code...
                     }
                     else {
                       $NEW_DUE = 0;
                     }
                   @endphp
                   <td class="amount">{{number_format($RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION,2)}}</td>
                   @if ($NEW_DUE > 0)
                     <td class="amount">{{number_format($NEW_DUE,2)}}</td>
                   @else
                     <td class="amount">0.00</td>
                   @endif
                   @php
                     $DUE_INFORMATION_TOTAL = $EXPIRED_OVERDUE + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                   @endphp
                   <td class="amount">{{number_format($DUE_INFORMATION_TOTAL,2)}}</td>
                   @if ($Signature_Of_CO == 0)
                     <td rowspan="{{$SizeOfFieldOfficers}}"></td>
                     @php
                       $Signature_Of_CO = $Signature_Of_CO + 1;
                     @endphp
                   @endif
                 </tr>

                 @php
                   $savingsProductsA = DB::select(DB::raw("SELECT * FROM mfn_saving_product"));
                   foreach ($savingsProductsA as $key => $savingsProductsAs) {
                     $SIds = $savingsProductsAs->id;
                     $SavingsProduct_subTotal[$SIds] = DB::table('mfn_savings_account')
                               ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                               ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                               ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                               ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                               ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                               ->where('mfn_saving_product.id', $SIds)
                               ->where('mfn_samity.samityDayId', $SamityDay)
                               ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                               ->where('mfn_samity.fieldOfficerId', $first)
                               ->sum('mfn_savings_account.autoProcessAmount');

                     $SavingsProduct_Total[$SIds] = DB::table('mfn_savings_account')
                               ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                               ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                               ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                               ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                               ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                               ->where('mfn_saving_product.id', $SIds)
                               ->where('mfn_samity.samityDayId', $SamityDay)
                               ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                               ->where('mfn_samity.branchId', $RequestedBranchInfos)
                               ->sum('mfn_savings_account.autoProcessAmount');

                     $SavingsProduct_subTotal_Collections[$SIds] = DB::table('mfn_savings_account')
                               ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                               ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                               ->join('mfn_savings_deposit', 'mfn_savings_account.id', 'mfn_savings_deposit.accountIdFk')
                               ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                               ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                               ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                               ->where('mfn_saving_product.id', $SIds)
                               ->where('mfn_samity.samityDayId', $SamityDay)
                               ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                               ->where('mfn_samity.fieldOfficerId', $first)
                               ->sum('mfn_savings_deposit.amount');

                     $SavingsProduct_Total_Collections[$SIds] = DB::table('mfn_savings_account')
                               ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                               ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                               ->join('mfn_savings_deposit', 'mfn_savings_account.id', 'mfn_savings_deposit.accountIdFk')
                               ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                               ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                               ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                               ->where('mfn_saving_product.id', $SIds)
                               ->where('mfn_samity.samityDayId', $SamityDay)
                               ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                               ->where('mfn_samity.branchId', $RequestedBranchInfos)
                               ->sum('mfn_savings_deposit.amount');
                   }

                   $SavingsProduct_subTotal_Total = DB::table('mfn_savings_account')
                             ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                             ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                             ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                             ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                             ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                             ->where('mfn_samity.samityDayId', $SamityDay)
                             ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                             ->where('mfn_samity.fieldOfficerId', $first)
                             ->sum('mfn_savings_account.autoProcessAmount');

                   $SavingsProduct_subTotal_ALL_Total = DB::table('mfn_savings_account')
                             ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                             ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                             ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                             ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                             ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                             ->where('mfn_samity.samityDayId', $SamityDay)
                             ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                             ->where('mfn_samity.branchId', $RequestedBranchInfos)
                             ->sum('mfn_savings_account.autoProcessAmount');

                   $SavingsProduct_subTotal_Collections_Total = DB::table('mfn_savings_account')
                             ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                             ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                             ->join('mfn_savings_deposit', 'mfn_savings_account.id', 'mfn_savings_deposit.accountIdFk')
                             ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                             ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                             ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                             ->where('mfn_samity.samityDayId', $SamityDay)
                             ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                             ->where('mfn_samity.fieldOfficerId', $first)
                             ->sum('mfn_savings_deposit.amount');

                   $SavingsProduct_subTotal_ALL_Collections_Total = DB::table('mfn_savings_account')
                             ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                             ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                             ->join('mfn_savings_deposit', 'mfn_savings_account.id', 'mfn_savings_deposit.accountIdFk')
                             ->join('mfn_loan', 'mfn_samity.id', '=', 'mfn_loan.samityIdFk')
                             ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                             ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                             ->where('mfn_samity.samityDayId', $SamityDay)
                             ->where('mfn_loan_schedule.scheduleDate', $RequestedDate)
                             ->where('mfn_samity.branchId', $RequestedBranchInfos)
                             ->sum('mfn_savings_deposit.amount');
                 @endphp

                 @php
                   $SUB_TOTAL1 = $SUB_TOTAL1 + $QUERY1;
                   $SUB_TOTAL2 = $SUB_TOTAL2 + $EXPIRED_OVERDUE_LOAN;
                   $SUB_TOTAL3 = $SUB_TOTAL3 + $QUERY3;
                   $SUB_TOTAL4 = $SUB_TOTAL4 + $EXPIRED_OVERDUE;
                   $SUB_TOTAL5 = $SUB_TOTAL5 + $Recoverable_Loan_Amount_Current_Due;
                   $SUB_TOTAL6 = $SUB_TOTAL6 + $QUERY6A;
                   $SUB_TOTAL7 = $SUB_TOTAL7 + $Recoverable_Loan_Amount_TOTAL;
                   $SUB_TOTAL8 = $SUB_TOTAL8 + $QUERY8;
                   $SUB_TOTAL9 = $SUB_TOTAL9 + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                   $SUB_TOTAL10 = $SUB_TOTAL10 + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                   $SUB_TOTAL11 = $SUB_TOTAL11 + $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                   $SUB_TOTAL12 = $SUB_TOTAL12 + $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL;
                   // $SUB_TOTAL13 = $SUB_TOTAL13 +
                   $SUB_TOTAL14 = $SUB_TOTAL14 + $EXPIRED_OVERDUE;
                   $SUB_TOTAL15 = $SUB_TOTAL15 + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                   $SUB_TOTAL16 = $SUB_TOTAL16 + $NEW_DUE;
                   $SUB_TOTAL17 = $SUB_TOTAL17 + $DUE_INFORMATION_TOTAL;
                 @endphp
                 @endif
                 @php
                   $Total = 0;

                   $EXPIRED_OVERDUE_LOAN = 0;
                   $Recoverable_Loan_Amount_Current_Due = 0;
                   $Recoverable_Loan_Amount_TOTAL = 0;
                   $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = 0;
                   $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = 0;
                   $RECOVERY_SAVINGS_AMOUNT_TOTAL = 0;
                   $TOTAL_RECOVERY = 0;
                 @endphp
               {{-- </tr> --}}
             @endforeach

             @php
               $PTR = '';
               // $EXPIRED_OVERDUE_LOAN = 0;
               // $Recoverable_Loan_Amount_Current_Due = 0;
               // $Recoverable_Loan_Amount_TOTAL = 0;
               // $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = 0;
               // $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = 0;
               // $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = 0;
               // $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = 0;
               // $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = 0;
               // $RECOVERY_SAVINGS_AMOUNT_TOTAL = 0;
               // $TOTAL_RECOVERY = 0;
             @endphp
           @endforeach
           <tr >
             <td colspan="3" style="background-color: #9cb1d3"><strong>SubTotal</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL1,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL2,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL3,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL4,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL5,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL6,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL7,2)}}</strong></td>
             @foreach ($SavingsProduct_subTotal as $key => $SavingsProduct_subTotals)
               <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SavingsProduct_subTotals,2)}}</strong></td>
             @endforeach
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SavingsProduct_subTotal_Total,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL8,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL9,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL10,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL11,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL12,2)}}</strong></td>
             @php
               $SUB_TOTAL20 = $SUB_TOTAL20 + $SUB_TOTAL12;
             @endphp
             @foreach ($SavingsProduct_subTotal_Collections as $key => $SavingsProduct_subTotal_Collection)
               <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SavingsProduct_subTotal_Collection,2)}}</strong></td>
               @php
                 $SUB_TOTAL20 = $SUB_TOTAL20 + $SavingsProduct_subTotal_Collection;
               @endphp
             @endforeach
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SavingsProduct_subTotal_Collections_Total,2)}}</strong></td>

             <td class="amount" style="background-color: #9cb1d3"></td>
             <td class="amount" style="background-color: #9cb1d3"></td>
             <td class="amount" style="background-color: #9cb1d3"></td>
             <td class="amount" style="background-color: #9cb1d3"></td>
             <td class="amount" style="background-color: #9cb1d3"></td>
             <td class="amount" style="background-color: #9cb1d3"></td>

             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL20,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL14,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL15,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL16,2)}}</strong></td>
             <td class="amount" style="background-color: #9cb1d3"><strong>{{number_format($SUB_TOTAL17,2)}}</strong></td>

           </tr>

           @php
             $TABLE1_TOTAL1 = $TABLE1_TOTAL1 + $SUB_TOTAL1;
             $TABLE1_TOTAL2 = $TABLE1_TOTAL2 + $SUB_TOTAL2;
             $TABLE1_TOTAL3 = $TABLE1_TOTAL3 + $SUB_TOTAL3;
             $TABLE1_TOTAL4 = $TABLE1_TOTAL4 + $SUB_TOTAL4;
             $TABLE1_TOTAL5 = $TABLE1_TOTAL5 + $SUB_TOTAL5;
             $TABLE1_TOTAL6 = $TABLE1_TOTAL6 + $SUB_TOTAL6;
             $TABLE1_TOTAL7 = $TABLE1_TOTAL7 + $SUB_TOTAL7;
             $TABLE1_TOTAL8 = $TABLE1_TOTAL8 + $SUB_TOTAL8;
             $TABLE1_TOTAL9 = $TABLE1_TOTAL9 + $SUB_TOTAL9;
             $TABLE1_TOTAL10 = $TABLE1_TOTAL10 + $SUB_TOTAL10;
             $TABLE1_TOTAL11 = $TABLE1_TOTAL11 + $SUB_TOTAL11;
             $TABLE1_TOTAL12 = $TABLE1_TOTAL12 + $SUB_TOTAL12;
             // $TABLE1_TOTAL13 = $TABLE1_TOTAL13 + $SUB_TOTAL13;
             $TABLE1_TOTAL14 = $TABLE1_TOTAL14 + $SUB_TOTAL14;
             $TABLE1_TOTAL15 = $TABLE1_TOTAL15 + $SUB_TOTAL15;
             $TABLE1_TOTAL16 = $TABLE1_TOTAL16 + $SUB_TOTAL16;
             $TABLE1_TOTAL17 = $TABLE1_TOTAL17 + $SUB_TOTAL17;
             $TABLE1_TOTAL20 = $TABLE1_TOTAL20 + $SUB_TOTAL20;
           @endphp

           @php
           $SUB_TOTAL1 = 0;
           $SUB_TOTAL2 = 0;
           $SUB_TOTAL3 = 0;
           $SUB_TOTAL4 = 0;
           $SUB_TOTAL5 = 0;
           $SUB_TOTAL6 = 0;
           $SUB_TOTAL7 = 0;
           $SUB_TOTAL8 = 0;
           $SUB_TOTAL9 = 0;
           $SUB_TOTAL10 = 0;
           $SUB_TOTAL11 = 0;
           $SUB_TOTAL12 = 0;
           $SUB_TOTAL13 = 0;
           $SUB_TOTAL14 = 0;
           $SUB_TOTAL15 = 0;
           $SUB_TOTAL16 = 0;
           $SUB_TOTAL17 = 0;
           $SUB_TOTAL18 = 0;
           $SUB_TOTAL19 = 0;
           $SUB_TOTAL20 = 0;
           $SUB_TOTAL21 = 0;
           $SUB_TOTAL22 = 0;
           $SUB_TOTAL23 = 0;
           $SUB_TOTAL24 = 0;
           $SUB_TOTAL25 = 0;
           $SUB_TOTAL26 = 0;
           $SUB_TOTAL27 = 0;
           $SUB_TOTAL28 = 0;
           $SUB_TOTAL29 = 0;
           $SUB_TOTAL30 = 0;
           @endphp

         @endforeach
         <tr>
           <td colspan="3" style="background-color: #7291C9"> <strong>Toal</strong> </td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL1,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL2,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL3,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL4,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL5,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL6,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL7,2)}}</strong></td>
           @foreach ($SavingsProduct_Total as $key => $SavingsProduct_Totals)
             <td class="amount" style="background-color: #7291C9"><strong>{{number_format($SavingsProduct_Totals,2)}}</strong></td>
           @endforeach

           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($SavingsProduct_subTotal_ALL_Total,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL8,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL9,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL10,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL11,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL12,2)}}</strong></td>

           @foreach ($SavingsProduct_Total_Collections as $key => $SavingsProduct_Total_Collection)
             <td class="amount" style="background-color: #7291C9"><strong>{{number_format($SavingsProduct_Total_Collection,2)}}</strong></td>
           @endforeach
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($SavingsProduct_subTotal_ALL_Collections_Total,2)}}</strong></td>

           <td class="amount" style="background-color: #7291C9"></td>
           <td class="amount" style="background-color: #7291C9"></td>
           <td class="amount" style="background-color: #7291C9"></td>
           <td class="amount" style="background-color: #7291C9"></td>
           <td class="amount" style="background-color: #7291C9"></td>
           <td class="amount" style="background-color: #7291C9"></td>

           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL20,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL14,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL15,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL16,2)}}</strong></td>
           <td class="amount" style="background-color: #7291C9"><strong>{{number_format($TABLE1_TOTAL17,2)}}</strong></td>
         </tr>
       </tbody>

     </table>
   </div>

   <br>
   <br>

   <div class="row">

     <table class="table table-bordered" border="1pt solid ash" style=" text-align: center; font-family: arial; color:black; border-collapse: collapse;" width="100%">
       <thead>

         <tr>

           <th colspan="1" rowspan="3">
             <div align="center">Name of component
             </div>
           </th>
           <th colspan="2" rowspan="1">
             <div align="center">Disbursement Amount
             </div>
           </th>

           <th colspan="4" rowspan="1">
             <div align="center">Recoverable Loan Amount
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+1}}" rowspan="1">
             <div align="center">Recoverable Savings Amount
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+12}}" rowspan="1">
             <div align="center">Recovery Amount
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Total Recovery
             </div>
           </th>
           <th colspan="4" rowspan="1">
             <div align="center">Due Information
             </div>
           </th>
           <th colspan="1" rowspan="3">
             <div align="center">Signature of CO
             </div>
           </th>

         </tr>

         <tr>
           <th colspan="1" rowspan="2">
             <div align="center">Regular Loan Amount
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Expired Overdue Loan
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Expired Overdue
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Regular Loan
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
           @foreach ($SavingsProduct as $key => $SavingsProducts)
             <th colspan="1" rowspan="2">
               <div align="center">
                 {{$SavingsProducts->shortName}}
               </div>
             </th>
           @endforeach
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
           <th colspan="5" rowspan="1">
             <div align="center">Loan Collection
             </div>
           </th>
           <th colspan="{{$SizeOfSavingsAmount+1}}" rowspan="1">
             <div align="center">Savings Collection
             </div>
           </th>
           <th colspan="6" rowspan="1">
             <div align="center">Others Collection
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Over Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">New Due
             </div>
           </th>
           <th colspan="1" rowspan="2">
             <div align="center">Total
             </div>
           </th>
         </tr>

         <tr>
           <th colspan="1" rowspan="1">
             <div align="center">Regular
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Over Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Current Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Advance
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>
           @foreach ($SavingsProduct as $key => $SavingsProducts)
             <th colspan="1" rowspan="1">
               <div align="center">
                 {{$SavingsProducts->shortName}}
               </div>
             </th>
           @endforeach
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Loan Apl. Fee
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Mem. Welfare Fund Due
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Pass Book/Reg.
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Savings Cheque Book
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Others Income
             </div>
           </th>
           <th colspan="1" rowspan="1">
             <div align="center">Total
             </div>
           </th>

         </tr>
       </thead>

       @php
       $TABLE2_TOTAL1 = 0;
       $TABLE2_TOTAL2 = 0;
       $TABLE2_TOTAL3 = 0;
       $TABLE2_TOTAL4 = 0;
       $TABLE2_TOTAL5 = 0;
       $TABLE2_TOTAL6 = 0;
       $TABLE2_TOTAL7 = 0;
       $TABLE2_TOTAL8 = 0;
       $TABLE2_TOTAL9 = 0;
       $TABLE2_TOTAL10 = 0;
       $TABLE2_TOTAL11 = 0;
       $TABLE2_TOTAL12 = 0;
       $TABLE2_TOTAL13 = 0;
       $TABLE2_TOTAL14 = 0;
       $TABLE2_TOTAL15 = 0;
       $TABLE2_TOTAL16 = 0;
       $TABLE2_TOTAL17 = 0;
       $TABLE2_TOTAL18 = 0;
       $TABLE2_TOTAL19 = 0;
       $TABLE2_TOTAL20 = 0;
       $TABLE2_TOTAL21 = 0;
       $TABLE2_TOTAL22 = 0;
       $TABLE2_TOTAL23 = 0;
       $TABLE2_TOTAL24 = 0;
       $TABLE2_TOTAL25 = 0;
       $TABLE2_TOTAL26 = 0;
       $TABLE2_TOTAL27 = 0;
       $TABLE2_TOTAL28 = 0;
       $TABLE2_TOTAL29 = 0;
       $TABLE2_TOTAL29A = 0;
       $TABLE2_TOTAL29B = 0;
       $TABLE2_TOTAL29C = 0;
       $TABLE2_TOTAL29D = 0;
       $TABLE2_TOTAL30 = 0;

       $pp2 = array();
       @endphp

       <tbody style="font-size:11px;">
         @php
           $ProductIDs = array();

           if ($RequestedLoanOptions == 1) {
             $ProductIDs = DB::select(DB::raw("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE branchIdFk='$RequestedBranchInfos' AND disbursementDate <= '$RequestedDate'"));

           }
           elseif ($RequestedLoanOptions == 2) {
             $ProductIDs = DB::table('mfn_loan')
                              ->select(DB::raw('DISTINCT(mfn_loans_product.productCategoryId)'))
                              ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                              ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                              ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                              ->groupBy('mfn_loans_product.productCategoryId')
                              ->get();

           }
         @endphp

         @foreach ($ProductIDs as $key => $ProductID)
           @php
             // $XX = $XX + 1;
           @endphp
           {{-- Previous Calculation --}}

           {{-- End of Previous Calculation --}}

           <tr>
             @if ($RequestedLoanOptions == 1)
               @php
                 // $pp2[] = $ProductID->productIdFk;
                 $SECOND_TABLE1 = DB::select(DB::raw("SELECT name, id FROM mfn_loans_product WHERE id='$ProductID->productIdFk'"));
               @endphp
               <td>{{$SECOND_TABLE1[0]->name}} kk</td>
             @elseif ($RequestedLoanOptions == 2)
               @php
                 $SECOND_TABLE1 = DB::select(DB::raw("SELECT name, id FROM mfn_loans_product_category WHERE id='$ProductID->productCategoryId'"));
                 // dd($SECOND_TABLE1);
               @endphp

               <td>{{$SECOND_TABLE1[0]->name}} </td>
             @endif

             {{-- Previous Calculation --}}
             @php
               $TRow = sizeof($RequiredTableInfos);
               // echo $TRow;
             @endphp
             @foreach ($RequiredTableInfos as $key1 => $RequiredTableInfos1)
               @php
               $Comp = explode('/', $key1);
               list($first, $second, $third) = $Comp;
               $AA = 1;
               $Row = sizeof($RequiredTableInfos1);
               // if ($TTRow > $Large) {
                 $Large = $Row;
               // }
               // echo '='.$Large.'=';
               @endphp

               @foreach ($RequiredTableInfos1 as $key2 => $RequiredTableInfos2)
                 @php
                 $TTRow = sizeof($RequiredTableInfos2);
                 $Comp1 = explode('/', $key2);
                 list($fourth, $fifth, $sixth) = $Comp1;
                 $BB = 1;
                 $TTRow = sizeof($RequiredTableInfos2);
                 if ($RequestedLoanOptions == 1) {
                   $SamityRowSpan = DB::select( DB::raw("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk = '$fourth' AND branchIdFk='$RequestedBranchInfos' AND disbursementDate <= '$RequestedDate'") );

                 }
                 elseif ($RequestedLoanOptions == 2) {
                   $SamityRowSpan = DB::table('mfn_loan')
                                    ->select(DB::raw('DISTINCT(mfn_loans_product.productCategoryId)'))
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                    ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                    ->groupBy('mfn_loans_product.productCategoryId')
                                    ->get();
                 }
                 $SamitySize = sizeof($SamityRowSpan);
                 if ($RequestedProduct != 'all') {
                   $SamitySize = 1;
                 }
                 $Total = $Total + $SamitySize;
                 // echo 'TOTAL : '.$Total.' Size : '.$SamitySize;
                 @endphp
               @endforeach
               @foreach ($RequiredTableInfos1 as $key2 => $RequiredTableInfos2)
                 @php
                 $Comp1 = explode('/', $key2);
                 list($fourth, $fifth, $sixth) = $Comp1;
                 $BB = 1;
                 $TTRow = sizeof($RequiredTableInfos2);

                 if ($RequestedLoanOptions == 1) {
                   $SamityRowSpan = DB::select( DB::raw("SELECT DISTINCT(productIdFk) FROM mfn_loan WHERE samityIdFk = '$fourth' AND branchIdFk='$RequestedBranchInfos' AND disbursementDate <= '$RequestedDate'") );

                 }
                 elseif ($RequestedLoanOptions == 2) {
                   $SamityRowSpan = DB::table('mfn_loan')
                                    ->select(DB::raw('DISTINCT(mfn_loans_product.productCategoryId)'))
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                    ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                    ->groupBy('mfn_loans_product.productCategoryId')
                                    ->get();
                 }
                 $SamitySize = sizeof($SamityRowSpan);
                 if ($RequestedProduct != 'all') {
                   $SamitySize = 1;
                 }
                 // echo '()'.$SamitySize.'()';
                 @endphp

                 @foreach ($RequiredTableInfos2 as $key3 => $RequiredTableInfos3)
                   @php
                     $LoopCounter = $LoopCounter + 1;
                   @endphp
                   @php
                   @endphp
                     @if ($PTR != $RequiredTableInfos3['PName'])
                       @php
                         $PTR = $RequiredTableInfos3['PName'];
                         $PTRid = $RequiredTableInfos3['PId'];
                         $pp[] = $RequiredTableInfos3['PName'];
                         // echo $PTRid;
                         if ($RequestedLoanOptions == 1) {
                           // REGULAR LOAN AMOUNT
                           $pp1[] = $RequiredTableInfos3['PName'];
                           $QUERY1 = DB::table('mfn_loan')
                                     // ->select('mfn_loans_product.shortname', 'mfn_loans_product.id')
                                     ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                     ->where('mfn_loan.samityIdFk', $fourth)
                                     ->where('mfn_loans_product.id', $PTRid)
                                     ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                     ->where('mfn_loan.isloanCompleted', '=', 0)
                                     ->sum('mfn_loan.loanAmount');

                          // EXPIRED OVERDUE LOAN
                          $QUERY2A = DB::table('mfn_loan')
                                    ->where('samityIdFk', $fourth)
                                    ->where('productIdFk', $PTRid)
                                    ->where('lastInstallmentDate', '<', $RequestedDate)
                                    ->where('isloanCompleted', '=', 0)
                                    ->sum('loanAmount');

                          if ($QUERY2A > 0) {
                            $EXPIRED_OVERDUE_LOAN = $QUERY2A;
                          }

                          // ACTUAL RECOVERABLE LOAN AMOUNT
                          $QUERY3 = DB::table('mfn_loan')
                                    // ->select('mfn_loans_product.shortname', 'mfn_loans_product.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');
                                    $pp2[$PTRid] = $QUERY3;
                          // Recoverable Loan Amount : EXPIRED OVERDUE
                          $Day = date_format(date_create($RequestedDate), "D");

                          if ($Day == "Sat") {
                            $SamityDay = 1;
                          }
                          elseif ($Day == "Sun") {
                            $SamityDay = 2;
                          }
                          elseif ($Day == "Mon") {
                            $SamityDay = 3;
                          }
                          elseif ($Day == "Tue") {
                            $SamityDay = 4;
                          }
                          elseif ($Day == "Wed") {
                            $SamityDay = 5;
                          }
                          elseif ($Day == "Thu") {
                            $SamityDay = 6;
                          }

                          $QUERY4A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan.totalRepayAmount');

                          $QUERY4B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY4A > 0) {
                            $EXPIRED_OVERDUE = $QUERY4A - $QUERY4B;
                            $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $EXPIRED_OVERDUE;
                          }

                          // Recoverable Loan Amount : Current Due
                          $QUERY5A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');

                          $QUERY5B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY5A > $QUERY5B) {
                            $Recoverable_Loan_Amount_Current_Due = $QUERY5A - $QUERY5B;
                            $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $Recoverable_Loan_Amount_Current_Due;
                          }
                          elseif ($QUERY5A < $QUERY5B) {
                            $Recoverable_Loan_Amount_Current_Due = 0;
                          }

                          // RECOVERABLE LOAN AMOUNT : REGULAR LOAN
                          $QUERY6A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');

                          $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $QUERY6A;

                          // RECOVERABLE SAVINGS AMOUNT
                          foreach ($SavingsProduct as $key => $SavingsProducts) {
                            $SId = $SavingsProducts->id;
                            $QUERY7[$SId] = DB::table('mfn_savings_account')
                                      ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                      ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                      ->where('mfn_savings_account.samityIdFk', $fourth)
                                      ->where('mfn_saving_product.id', $SId)
                                      // ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                      ->where('mfn_samity.samityDayId', $SamityDay)
                                      // ->where('mfn_loan.isloanCompleted', '=', 0)
                                      ->sum('mfn_savings_account.autoProcessAmount');
                          }

                          // RECOVERY AMOUNT : REGULAR LOAN COLLECTION
                          $QUERY8 = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $QUERY8;

                          // RECOVERY AMOUNT : OVER DUE LOAN COLLECTION
                          $QUERY9A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan.totalRepayAmount');

                          $QUERY9B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY9A > $QUERY9B) {
                            $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = $QUERY9A - $QUERY9B;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : CURRENT DUE LOAN COLLECTION
                          $QUERY10A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');
                                    // echo '...$QUERY10A...'.$QUERY10A.'...';

                          $QUERY10B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loan.productIdFk', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');
                                    // echo '>>$QUERY10B>>'.$QUERY10B.'<<';

                          if ($QUERY10A > $QUERY10B) {
                            $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = $QUERY10A - $QUERY10B;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : ADVANCE LOAN COLLECTION
                          // $Recoverable_Loan_Amount_TOTAL - $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL
                          if ($QUERY10A < $QUERY10B) {
                            $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = $QUERY10B - $QUERY10A;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : SAVINGS COLLECTION
                          foreach ($SavingsProduct as $key => $SavingsProducts) {
                            $SId = $SavingsProducts->id;
                            $QUERY11[$SId] = DB::table('mfn_savings_account')
                                      ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                      ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                      ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                      ->where('mfn_savings_account.samityIdFk', $fourth)
                                      ->where('mfn_saving_product.id', $SId)
                                      ->where('mfn_samity.samityDayId', $SamityDay)
                                      ->sum('mfn_savings_deposit.amount');
                          }

                         }
                         // IF REQUESTED LOAN OPTION IS LOAN PRODUCT CATEGORY
                         elseif ($RequestedLoanOptions == 2) {
                           // REGULAR LOAN AMOUNT
                           $QUERY1 = DB::table('mfn_loan')
                                     ->select('mfn_loans_product_category.name', 'mfn_loans_product_category.id')
                                     ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                     ->join('mfn_loans_product_category', 'mfn_loans_product.productCategoryId', 'mfn_loans_product_category.id')
                                     ->where('mfn_loan.samityIdFk', $fourth)
                                     ->where('mfn_loans_product.productCategoryId', $PTRid)
                                     ->where('mfn_loan.disbursementDate', '<=', $RequestedDate)
                                     ->where('mfn_loan.isloanCompleted', '=', 0)
                                     // ->distinct()
                                     // ->get();
                                     ->sum('mfn_loan.loanAmount');

                          // EXPIRED OVERDUE LOAN
                           $QUERY2A = DB::table('mfn_loan')
                                     ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                     ->where('mfn_loan.samityIdFk', $fourth)
                                     ->where('mfn_loans_product.productCategoryId', $PTRid)
                                     ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                     ->where('mfn_loan.isloanCompleted', '=', 0)
                                     ->sum('mfn_loan.loanAmount');

                           if ($QUERY2A > 0) {
                             $EXPIRED_OVERDUE_LOAN = $QUERY2A;
                           }

                           // ACTUAL RECOVERABLE LOAN AMOUNT
                           $QUERY3 = DB::table('mfn_loan')
                                     ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                     ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                     ->where('mfn_loan.samityIdFk', $fourth)
                                     ->where('mfn_loans_product.productCategoryId', $PTRid)
                                     ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                     ->where('mfn_loan.isloanCompleted', '=', 0)
                                     ->sum('mfn_loan_schedule.installmentAmount');

                          // Recoverable Loan Amount : EXPIRED OVERDUE
                          $Day = date_format(date_create($RequestedDate), "D");

                          if ($Day == "Sat") {
                            $SamityDay = 1;
                          }
                          elseif ($Day == "Sun") {
                            $SamityDay = 2;
                          }
                          elseif ($Day == "Mon") {
                            $SamityDay = 3;
                          }
                          elseif ($Day == "Tue") {
                            $SamityDay = 4;
                          }
                          elseif ($Day == "Wed") {
                            $SamityDay = 5;
                          }
                          elseif ($Day == "Thu") {
                            $SamityDay = 6;
                          }

                          $QUERY4A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan.totalRepayAmount');

                          $QUERY4B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY4A > 0) {
                            $EXPIRED_OVERDUE = $QUERY4A - $QUERY4B;
                            $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $EXPIRED_OVERDUE;
                          }

                          // Recoverable Loan Amount : Current Due
                          $QUERY5A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');

                          $QUERY5B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY5A > $QUERY5B) {
                            $Recoverable_Loan_Amount_Current_Due = $QUERY5A - $QUERY5B;
                            $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $Recoverable_Loan_Amount_Current_Due;
                            $pp2[$PTRid] = $Recoverable_Loan_Amount_Current_Due;
                          }
                          elseif ($QUERY5A < $QUERY5B) {
                            $Recoverable_Loan_Amount_Current_Due = 0;
                            $pp2[$PTRid] = $Recoverable_Loan_Amount_Current_Due;
                          }



                          // Recoverable Loan Amount : REGULAR LOAN
                          $QUERY6A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');

                          $Recoverable_Loan_Amount_TOTAL = $Recoverable_Loan_Amount_TOTAL + $QUERY6A;

                          // RECOVERABLE SAVINGS AMOUNT
                          foreach ($SavingsProduct as $key => $SavingsProducts) {
                            $SId = $SavingsProducts->id;
                            $QUERY7[$SId] = DB::table('mfn_savings_account')
                                      ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                      ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                      ->where('mfn_savings_account.samityIdFk', $fourth)
                                      ->where('mfn_saving_product.id', $SId)
                                      // ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                      ->where('mfn_samity.samityDayId', $SamityDay)
                                      // ->where('mfn_loan.isloanCompleted', '=', 0)
                                      ->sum('mfn_savings_account.autoProcessAmount');
                          }

                          // RECOVERY AMOUNT : LOAN COLLECTION
                          $QUERY8 = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $QUERY8;

                          // RECOVERY AMOUNT : OVER DUE LOAN COLLECTION
                          $QUERY9A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan.lastInstallmentDate', '<', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan.totalRepayAmount');

                          $QUERY9B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY9A > $QUERY9B) {
                            $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = $QUERY9A - $QUERY9B;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : CURRENT DUE LOAN COLLECTION
                          $QUERY10A = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_schedule.scheduleDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_schedule.installmentAmount');

                          $QUERY10B = DB::table('mfn_loan')
                                    ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                    ->join('mfn_loan_collection', 'mfn_loan.id', '=', 'mfn_loan_collection.loanIdFk')
                                    ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                    ->where('mfn_loan.samityIdFk', $fourth)
                                    ->where('mfn_loans_product.productCategoryId', $PTRid)
                                    ->where('mfn_loan_collection.collectionDate', '<=', $RequestedDate)
                                    ->where('mfn_samity.samityDayId', $SamityDay)
                                    ->where('mfn_loan.isloanCompleted', '=', 0)
                                    ->sum('mfn_loan_collection.amount');

                          if ($QUERY10A > $QUERY10B) {
                            $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = $QUERY10A - $QUERY10B;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : ADVANCE LOAN COLLECTION
                          if ($QUERY10A < $QUERY10B) {
                            $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = $QUERY10B - $QUERY10A;
                            $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL + $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                          }

                          // RECOVERY AMOUNT : SAVINGS COLLECTION
                          foreach ($SavingsProduct as $key => $SavingsProducts) {
                            $SId = $SavingsProducts->id;
                            $QUERY11[$SId] = DB::table('mfn_savings_account')
                                      ->join('mfn_samity', 'mfn_savings_account.samityIdFk', '=', 'mfn_samity.id')
                                      ->join('mfn_saving_product', 'mfn_savings_account.savingsProductIdFk', '=', 'mfn_saving_product.id')
                                      ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                      ->where('mfn_savings_account.samityIdFk', $fourth)
                                      ->where('mfn_saving_product.id', $SId)
                                      ->where('mfn_samity.samityDayId', $SamityDay)
                                      ->sum('mfn_savings_deposit.amount');
                          }

                         }

                       @endphp
                       @if ($RequiredTableInfos3['PName'] == $SECOND_TABLE1[0]->name)
                         @php
                           $TOTAL_LOAN1 = $TOTAL_LOAN1 + $QUERY1;
                           $TOTAL_LOAN2 = $TOTAL_LOAN2 + $EXPIRED_OVERDUE_LOAN;
                           $TOTAL_LOAN3 = $TOTAL_LOAN3 + $EXPIRED_OVERDUE;
                           $TOTAL_LOAN4 = $TOTAL_LOAN4 + $Recoverable_Loan_Amount_Current_Due;
                           $TOTAL_LOAN5 = $TOTAL_LOAN5 + $QUERY6A;
                           $TOTAL_LOAN7 = $TOTAL_LOAN7 + $QUERY8;
                           $TOTAL_LOAN8 = $TOTAL_LOAN8 + $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION;
                           $TOTAL_LOAN9 = $TOTAL_LOAN9 + $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION;
                           $TOTAL_LOAN10 = ($TOTAL_LOAN7 - $TOTAL_LOAN5);   //Problem
                           $NEW_DUE = $QUERY6A - $QUERY8;
                           $TOTAL_LOAN13 = $NEW_DUE;
                           // echo $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION;
                           // echo $TOTAL_LOAN4.'=>'.$RequiredTableInfos3['PName'].'=>'.$Recoverable_Loan_Amount_Current_Due.'=>'.$SECOND_TABLE1[0]->id.'=>'.$fourth.'/';
                         @endphp
                       @endif
                     @endif
                     @php
                       $Total = 0;
                     @endphp
                   {{-- </tr> --}}
                 @endforeach
                 @php
                   $PTR = '';
                   $EXPIRED_OVERDUE_LOAN = 0;
                   $Recoverable_Loan_Amount_Current_Due = 0;
                   $Recoverable_Loan_Amount_TOTAL = 0;
                   $RECOVERABLE_SAVINGS_AMOUNT_TOTAL = 0;
                   $RECOVERY_AMOUNT_OVER_DUE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_CURRENT_DUE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_CURRENT_ADVENCE_LOAN_COLLECTION = 0;
                   $RECOVERY_AMOUNT_LOAN_COLLECTION_TOTAL = 0;
                   $RECOVERY_SAVINGS_AMOUNT_TOTAL = 0;
                   $TOTAL_RECOVERY = 0;
                 @endphp
               @endforeach
             @endforeach
             {{-- End of Previous Calculation --}}

             <td class="amount">{{number_format($TOTAL_LOAN1,2)}} </td>
             <td class="amount">{{number_format($TOTAL_LOAN2,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN3,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN4,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN5,2)}} </td>
             @php
               $TOTAL_LOAN6 = $TOTAL_LOAN3 + $TOTAL_LOAN4 + $TOTAL_LOAN5;

               if ($RequestedLoanOptions == 1) {
                 $savingsProducts = DB::select(DB::raw("SELECT * FROM mfn_saving_product"));

                 foreach ($savingsProducts as $key => $savingsProduct) {
                   $SavingsPIDs[] = DB::table('mfn_loan')
                                  ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                  ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                                  ->where('mfn_loan.productIdFk', $SECOND_TABLE1[0]->id)
                                  ->where('mfn_loan.isloanCompleted', '=', 0)
                                  ->sum('mfn_savings_account.autoProcessAmount');

                  $SavingsCollections[] = DB::table('mfn_loan')
                                 ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                 ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                                 ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                 ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                 ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                 ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                                 ->where('mfn_samity.samityDayId', $SamityDay)
                                 ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                                 ->where('mfn_loan.productIdFk', $SECOND_TABLE1[0]->id)
                                 ->where('mfn_loan.isloanCompleted', '=', 0)
                                 ->sum('mfn_savings_deposit.amount');
                 }
               }
               elseif ($RequestedLoanOptions == 2) {
                 $savingsProducts = DB::select(DB::raw("SELECT * FROM mfn_saving_product"));

                 foreach ($savingsProducts as $key => $savingsProduct) {
                   $SavingsPIDs[] = DB::table('mfn_loan')
                                  ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                  ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                                  ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                  ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                  ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                  ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                                  ->where('mfn_samity.samityDayId', $SamityDay)
                                  ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                                  ->where('mfn_loans_product.productCategoryId', $SECOND_TABLE1[0]->id)
                                  ->sum('mfn_savings_account.autoProcessAmount');

                  $SavingsCollections[] = DB::table('mfn_loan')
                                 ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                                 ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                                 ->join('mfn_loans_product', 'mfn_loan.productIdFk', '=', 'mfn_loans_product.id')
                                 ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                                 ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                                 ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                                 ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                                 ->where('mfn_samity.samityDayId', $SamityDay)
                                 ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                                 ->where('mfn_loans_product.productCategoryId', $SECOND_TABLE1[0]->id)
                                 ->sum('mfn_savings_deposit.amount');
                 }
               }
             @endphp
             <td class="amount">{{number_format($TOTAL_LOAN6,2)}}</td>
             @foreach ($SavingsPIDs as $key => $SavingsPID)
               @php
                 $zz = sizeof($ProductIDs);
                 $zzz = sizeof($savingsProducts);
                 $ZZ = $XX * $zzz;
                 // echo '...'.$ZZ.'...';
               @endphp
               @if ($YY >= $ZZ and $KK < $zzz)
                 <td class="amount">{{number_format($SavingsPID,2)}}</td>
                 @php
                   $KK = $KK + 1;
                   $TOTAL_SAVINGS_RECOVERABLE = $TOTAL_SAVINGS_RECOVERABLE + $SavingsPID;
                 @endphp
               @endif
               @php
                 $YY = $YY + 1;
                 // $KK = $KK + 1;
                 // echo '('.$YY.')';
               @endphp

             @endforeach
             @php
               $YY = 0;
             @endphp
             <td class="amount">{{number_format($TOTAL_SAVINGS_RECOVERABLE,2)}}</td>

             <td class="amount">{{number_format($TOTAL_LOAN7,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN8,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN9,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN10,2)}}</td>
             @php
               $TOTAL11 = $TOTAL_LOAN7 + $TOTAL_LOAN8 + $TOTAL_LOAN9 + $TOTAL_LOAN10;
             @endphp
             <td class="amount">{{number_format($TOTAL11,2)}}</td>
             @foreach ($SavingsCollections as $key => $SavingsCollection)
               @php
                 $zz = sizeof($ProductIDs);
                 $zzz = sizeof($savingsProducts);
                 $ZZ1 = $XX1 * $zzz;
                 // echo '...'.$ZZ1.'...';
               @endphp
               @if ($YY1 >= $ZZ1 and $KK1 < $zzz)
                 <td class="amount">{{number_format($SavingsCollection,2)}}</td>
                 @php
                   $KK1 = $KK1 + 1;
                   $TOTAL_SAVINGS_COLLECTION = $TOTAL_SAVINGS_COLLECTION + $SavingsCollection;
                 @endphp
               @endif
               @php
                 $YY1 = $YY1 + 1;
                 // $KK = $KK + 1;
                 // echo '('.$YY1.')';
               @endphp

             @endforeach
             @php
               $YY1 = 0;
             @endphp
             <td class="amount">{{number_format($TOTAL_SAVINGS_COLLECTION,2)}}</td>

             <td></td>
             <td></td>
             <td></td>
             <td></td>
             <td></td>
             <td></td>
             @php
               //Savings Recovery needed
               $TOTAL_LOAN12 = $TOTAL11 + $TOTAL_SAVINGS_COLLECTION;
             @endphp
             <td class="amount">{{number_format($TOTAL_LOAN12,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN3,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN9,2)}}</td>
             <td class="amount">{{number_format($TOTAL_LOAN13,2)}}</td>
             @php
               $TOTAL_LOAN14 = $TOTAL_LOAN3 + $TOTAL_LOAN9;
               $TABLE2_TOTAL29A = $TABLE2_TOTAL29A + $TOTAL_LOAN3;
               $TABLE2_TOTAL29B = $TABLE2_TOTAL29B + $TOTAL_LOAN9;
               $TABLE2_TOTAL29 = $TABLE2_TOTAL29 + $TOTAL_LOAN13;
               // $TABLE2_TOTAL29C = $TABLE2_TOTAL29C + $TOTAL_LOAN14;
             @endphp
             <td class="amount">{{number_format($TOTAL_LOAN14,2)}}</td>
             @php
               $TABLE2_TOTAL29C = $TABLE2_TOTAL29C + $TOTAL_LOAN14;
               // $TABLE2_TOTAL29D = $TABLE2_TOTAL29D +
             @endphp
             @if ($Signature_Of_COo == 0)
                <td rowspan="{{sizeof($ProductIDs) + 1}}"></td>
                @php
                  $Signature_Of_COo = $Signature_Of_COo + 1;
                @endphp
             @endif
             {{-- <td rowspan="{{sizeof($ProductIDs) + 1}}"></td> --}}
           </tr>
           @php

             // dd($SavingsPIDs);
             // echo $SECOND_TABLE1[0]->id;
             $XX = $XX + 1;
             $XX1 = $XX1 + 1;
             $KK = 0;
             $KK1 = 0;
             $TOTAL_SAVINGS_RECOVERABLE = 0;
             $TOTAL_SAVINGS_COLLECTION = 0;
           @endphp
           <br>
           @php
             $TABLE2_
           @endphp
           <br>

           @php
             $TABLE2_TOTAL1 = $TABLE2_TOTAL1 + $TOTAL_LOAN1;
             $TABLE2_TOTAL2 = $TABLE2_TOTAL2 + $TOTAL_LOAN2;
             $TABLE2_TOTAL3 = $TABLE2_TOTAL3 + $TOTAL_LOAN3;
             $TABLE2_TOTAL4 = $TABLE2_TOTAL4 + $TOTAL_LOAN4;
             $TABLE2_TOTAL5 = $TABLE2_TOTAL5 + $TOTAL_LOAN5;
             $TABLE2_TOTAL6 = $TABLE2_TOTAL6 + $TOTAL_LOAN6;

             $TABLE2_TOTAL7 = $TABLE2_TOTAL7 + $TOTAL_LOAN7;
             $TABLE2_TOTAL8 = $TABLE2_TOTAL8 + $TOTAL_LOAN8;
             $TABLE2_TOTAL9 = $TABLE2_TOTAL9 + $TOTAL_LOAN9;
             $TABLE2_TOTAL10 = $TABLE2_TOTAL10 + $TOTAL_LOAN10;
             $TABLE2_TOTAL11 = $TABLE2_TOTAL11 + $TOTAL11;
           @endphp

           @php
           $TOTAL_LOAN1 = 0;
           $TOTAL_LOAN2 = 0;
           $TOTAL_LOAN3 = 0;
           $TOTAL_LOAN4 = 0;
           $TOTAL_LOAN5 = 0;
           $TOTAL_LOAN6 = 0;
           $TOTAL_LOAN7 = 0;
           $TOTAL_LOAN8 = 0;
           $TOTAL_LOAN9 = 0;
           $TOTAL_LOAN10 = 0;
           $TOTAL_LOAN11 = 0;
           $TOTAL_LOAN12 = 0;
           $TOTAL_LOAN13 = 0;
           $TOTAL_LOAN14 = 0;
           $TOTAL_LOAN15 = 0;
           $TOTAL_LOAN16 = 0;
           $TOTAL_LOAN17 = 0;
           $TOTAL_LOAN18 = 0;
           @endphp

         @endforeach
         <tr>
           <td colspan="1"  style="background-color: #7291C9"> <strong>Total</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL1,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL2,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL3,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL4,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL5,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL6,2)}}</strong> </td>
           {{-- @php --}}
           {{-- @if ($RequestedLoanOptions == 1) --}}
             @php
             $savingsProducts = DB::select(DB::raw("SELECT * FROM mfn_saving_product"));
             @endphp
             @foreach ($savingsProducts as $key => $savingsProduct)
               @php
               $SavingsPID_Totals = DB::table('mfn_loan')
                              ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                              ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                              ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                              ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                              ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                              ->where('mfn_samity.samityDayId', $SamityDay)
                              ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                              // ->where('mfn_loan.productIdFk', $SECOND_TABLE1[0]->id)
                              ->where('mfn_loan.isloanCompleted', '=', 0)
                              ->sum('mfn_savings_account.autoProcessAmount');
                              $TABLE2_TOTAL25 = $TABLE2_TOTAL25 + $SavingsPID_Totals;
             @endphp
             {{-- {{$SavingsPID_Totals}} --}}
             <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($SavingsPID_Totals,2)}}</strong> </td>
             @endforeach
           {{-- @endif --}}
           {{-- @endphp --}}
           {{-- @foreach ($SavingsPID_Totals as $key => $SavingsPID_Total)
             {{$SavingsPID_Total}}
           @endforeach --}}
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL25,2)}}</strong> </td>

           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL7,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL8,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL9,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL10,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL11,2)}}</strong> </td>
           @php
             $savingsProducts = DB::select(DB::raw("SELECT * FROM mfn_saving_product"));
           @endphp
           @foreach ($savingsProducts as $key => $savingsProduct)
             @php
             $SavingsCollectionTotals = DB::table('mfn_loan')
                            ->join('mfn_samity', 'mfn_loan.samityIdFk', '=', 'mfn_samity.id')
                            ->join('mfn_savings_account', 'mfn_loan.samityIdFk', '=', 'mfn_savings_account.samityIdFk')
                            ->join('mfn_savings_deposit', 'mfn_savings_account.id', '=', 'mfn_savings_deposit.accountIdFk')
                            ->join('mfn_loan_schedule', 'mfn_loan.id', '=', 'mfn_loan_schedule.loanIdFk')
                            ->where('mfn_loan.branchIdFk', $RequestedBranchInfos)
                            ->where('mfn_savings_account.savingsProductIdFk', $savingsProduct->id)
                            ->where('mfn_samity.samityDayId', $SamityDay)
                            ->where('mfn_loan_schedule.scheduleDate', '=', $RequestedDate)
                            // ->where('mfn_loan.productIdFk', $SECOND_TABLE1[0]->id)
                            ->where('mfn_loan.isloanCompleted', '=', 0)
                            ->sum('mfn_savings_deposit.amount');

                            $TABLE2_TOTAL26 = $TABLE2_TOTAL26 + $SavingsCollectionTotals;
             @endphp
             <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($SavingsCollectionTotals,2)}}</strong> </td>
           @endforeach
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL26,2)}}</strong> </td>
           @php
             $TABLE2_TOTAL27 = $TABLE2_TOTAL11 + $TABLE2_TOTAL26;
           @endphp

           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong></strong> </td>

           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL27,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL29A,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL29B,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL29,2)}}</strong> </td>
           <td class="amount" style="background-color: #7291C9"> <strong>{{number_format($TABLE2_TOTAL29C,2)}}</strong> </td>
         </tr>
       </tbody>

     </table>

   </div>
   @php
     $w = 0;
     // echo $SamityDay;
     // print_r($pp2);
   @endphp
   <br>
   {{-- @foreach ($SavingsCollections as $key => $SavingsCollection)
     @php
       $w = $w + 1;
     @endphp
     {{$w}}.{{$SavingsCollection}}
     <br>
   @endforeach --}}

   </div>



   <div class="row" style="text-align: center; padding-top: 25px;">
     <div class="col-md-4" style="float: left;">
       <table style="font-size:11px;">
         <tr>
           <td>Prepared By</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Signature</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Designation</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
       </table>
     </div>

     <div class="col-md-4" style="text-align:left; margin:0 auto !important; display:inline-block;">
       <table style="font-size:11px;">
         <tr>
           <td>Verified By</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Signature</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Designation</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
       </table>
     </div>

     <div class="col-md-4" style="float: right; padding-right: 400px;">
       <table style="font-size:11px;">
         <tr>
           <td>Approved By</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Signature</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
         <tr>
           <td>Designation:</td>
           <td><strong>:</strong></td>
           <td></td>
         </tr>
       </table>
     </div>
   </div>


 </div>