1#@!#!123s

: / home / schoolcampuserp / isadhi.alphaips.co.in / application / views / studentfee /
Filename : getcollectfee_yuvi.php
back
<?php
$currency_symbol = $this->customlib->getSchoolCurrencyFormat();
$disabled = '';
if (!$this->rbac->hasPrivilege('fees_discount', 'can_edit')) {
    $disabled = 'disabled'; // Set the disabled attribute if the user does not have permission
}
?>

<!--<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@5.15.4/css/all.min.css">-->
 <style>
        /*.table th, .table td {*/
        /*    text-align: center;*/
        /*}*/
        /*.table thead th {*/
        /*    background-color: #00CFFF;*/
        /*    color: white;*/
        /*}*/
        /*.table tfoot td {*/
        /*    background-color: #00CFFF;*/
        /*    font-weight: bold;*/
        /*    color: white;*/
        /*}*/
        /*input[type="number"] {*/
        /*    width: 100%;*/
        /*    text-align: center;*/
        /*}*/
        /*input[type="checkbox"] {
            transform: scale(1.3); /* make checkboxes larger */
        /*}*/
       
       .container {
    max-width: none; /* Adjust this value based on your preferred width */
    margin: 0;
    overflow-x: auto;
    border: 1px solid #ddd;
    background-color: #fff;
        max-height: none !important; /* Remove any max-height restrictions */

}
.modal-dialog, .modal-content {
    max-width: 800px; /* Adjust to match the width in your second image */
    margin: 0 auto;
    width: auto !important; /* Override any fixed widths */
     padding-top: 0 !important; /* Remove top padding */
    padding-bottom: 0 !important; /* Remove bottom padding */
}

/* Eye-catching colors for modal */
.modal-content {
  border: none;
  overflow:hidden;
  padding:0 !important;
  margin:0 !important;
  
}

/* Header styling with gradient */
.modal-header {
  background: linear-gradient(135deg, #3a7bd5 0%, #00d2ff 100%); /* Vibrant blue gradient */
  color: white;
  display: flex;
  justify-content: space-between;
  align-items: center;
  position: relative;
margin-bottom: 0 !important; /* No bottom margin */
}

.modal-title {
  color: white;
}

/* Close button styling */
.modal-header .close {
  color: white !important;
  opacity: 0.9 !important;
  text-shadow: none !important;
  display: block !important;
  position: absolute !important;
  right: 15px !important;
  top: 15px !important;
  background: transparent !important;
  border: 0 !important;
  cursor: pointer !important;
}

.modal-header .close:hover {
  opacity: 1 !important;
}

/* Table styling */
.table thead th {
  background-color: #e9f2ff; /* Light blue for table headers */
  color: #2c3e50; /* Dark blue text */
  border-bottom: 2px solid #3a7bd5;
}

/* Main table styling */
.demo {
    width: 100%;
    border-collapse: collapse;
    font-family: Arial, sans-serif;
        table-layout: auto; /* Allows table to expand naturally */

}

.demo th, .demo td input,.demo td {
    width: 100px;
    padding: 2px;
    text-align: center;
    border: 1px solid #ddd;
}

/* Enhanced colors for month headers */
.demo th {
    position: sticky;
    top: 0;
    background-color: #3a7bd5; /* Matching header blue */
    color: white;
    z-index: 1;
}

/* Enhanced colors for fees head */
.demo th.fees-head, .demo td.fees-head {
    width: 200px;
    text-align: left;
    position: sticky;
    left: 0;
    background-color: #e9f2ff; /* Light blue background */
    color: #2c3e50; /* Dark blue text */
    z-index: 2;
}

/* Alternating row colors */
.demo tr:nth-child(even) td {
    background-color: #f9fcff; /* Very light blue */
}

.demo tr:nth-child(odd) td {
    background-color: #ffffff;
}

.fees-list {
    list-style: none;
   margin-top: 0 !important; /* Remove top margin */
    padding-top: 0 !important; /* Remove top padding */
}

.fees-list>.item {
    border-radius: 3px;
    -webkit-box-shadow: 0 1px 1px rgba(0, 0, 0, 0.1);
    box-shadow: 0 1px 1px rgba(0, 0, 0, 0.1);
    padding: 5px 0;
    background: #fff;
    border-left: 4px solid #3a7bd5; /* Left border accent matching header */
}

.fees-list>.item:before, .fees-list>.item:after {
    content: " ";
    display: table;
}

.fees-list>.item:after {
    clear: both;
}

.fees-list .product-img {
    float: left;
}

.fees-list .product-img img {
    width: 50px;
    height: 50px;
}

.fees-list .product-info {
    margin-left: 0px;
}

.fees-list .product-title {
    font-weight: 600;
    font-size: 15px;
    display: inline;
    color: #2c3e50; /* Dark blue text */
}

.fees-list .product-title span {
    font-size: 15px;
    display: inline;
    font-weight: 100 !important;
}

.fees-list .product-description {
    display: block;
    color: #999;
    overflow: hidden;
    white-space: nowrap;
    text-overflow: ellipsis;
}

.fees-list-in-box>.item {
    -webkit-box-shadow: none;
    box-shadow: none;
    border-radius: 0;
    border-bottom: 1px solid #f4f4f4;
}

.fees-list-in-box>.item:last-of-type {
    border-bottom-width: 0;
}

.fees-footer {
    border-top-color: #f4f4f4;
}

.fees-footer {
    padding: 5px 0px 0px 0px;
    text-align: right;
    border-top: 1px solid #e5e5e5;
}

.collect_grp_fees {
    font-size: 15px;
   
}

/* Whatsapp button (commented out as in original) */
/*.whatsapp-button {*/
/*     position: fixed;*/
/*     bottom: 20px;*/
/*     right: 20px;*/
/*     background-color: #25D366;*/
/*     color: #fff;*/
/*     font-size: 16px;*/
/*     padding: 10px 20px;*/
/*     border: none;*/
/*     border-radius: 5px;*/
/*     cursor: pointer;*/
/*     box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);*/
/*   }*/
textarea.form-control {
    padding-top: 8px; /* Adjust this value to center the text vertically */
    line-height: 14px; /* Match this with your font size */
    vertical-align: middle;
}
.modal-body {
    padding-top: 0 !important; /* Remove top padding */
    padding-bottom: 0 !important; /* Remove bottom padding */
}
/* Remove padding from box-body */
.box-body {
    padding: 0 !important;
}
/* Remove space around the table */
.row {
     margin-top: 0 !important;
    margin-bottom: 0 !important;
    padding:0 !important;
}
.col-lg-12 {
    padding: 0 !important;
    margin:0 !important;
}
.row + ul.fees-list {
    margin-top: -5px !important; /* Negative margin to pull content up */
}
.form-control, textarea.form-control {
    height: 28px !important;
    min-height: 0 !important;
}
</style>


<div class="box-body">
<div class="row">
  <div class="col-lg-12">
     <div class="row">
        <table class="table">
    <thead>
        <tr>
            <th><?php echo $this->lang->line('date'); ?> <small class="req"> *</small></th>
            <th><?php echo $this->lang->line('payment') . " " . $this->lang->line('mode'); ?></th>
            <th><?php echo $this->lang->line('note'); ?></th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <!-- Date Input -->
            <td>
                <?php $date=date($this->customlib->getSchoolDateFormat()); ?>
                
                <?php if($disabled == 'disabled'){ ?>
        
                
                <input type="text" name="collected_date" value="<?php echo set_value('date', $date); ?>" class="form-control date"  <?php echo $disabled; ?>>
                       
   
                
               <input type="hidden" name="collected_date" value="<?php echo set_value('date', $date); ?>" class="form-control date" autocomplete="off"> 
                       
                <span id="form_collection_collected_date_error" class="text text-danger"></span>
                
                <?php } else { ?>
                <input type="text" name="collected_date" value="<?php echo set_value('date', $date); ?>" class="form-control date" autocomplete="off">
                
   
                       
                <?php } ?>
            </td>
            
            <!-- Payment Mode Inputs -->
            <td>
                <label class="radio-inline">
                    <input type="radio" name="payment_mode_fee" value="Cash" checked="checked"> <?php echo $this->lang->line('cash'); ?>
                </label>
                <label class="radio-inline">
                    <input type="radio" name="payment_mode_fee" value="Cheque"> <?php echo $this->lang->line('cheque'); ?>
                </label>
               
                <label class="radio-inline">
                    <input type="radio" name="payment_mode_fee" value="bank_transfer"><?php echo $this->lang->line('bank_transfer'); ?>
                </label>
                <label class="radio-inline">
                    <input type="radio" name="payment_mode_fee" value="upi"><?php echo $this->lang->line('upi'); ?>
                </label>
              
                <span id="form_collection_payment_mode_fee_error" class="text text-danger"></span>
            </td>
            <td>
                <textarea class="form-control" rows="1.9" cols="25" style="height: 30px; resize: none;" name="fee_gupcollected_note" id="description" placeholder="">
                </textarea>
                <span id="form_collection_fee_gupcollected_note_error" class="text text-danger"></span>
                
            </td>
        </tr>
    </tbody>
</table>

     </div> 


<ul class="fees-list fees-list-in-box">
    <?php
 //new code 
 
 // Master array to hold multiple categories
$masterArray = [];

// Master array to hold multiple categories
$masterArray2 = [];

// Recursive function to merge nested arrays and sum numeric values for 'amount'
function customNestedMerge(&$array1, $array2) {
       foreach ($array2 as $key => $value) {
        // If the key exists in the first array
        if (isset($array1[$key])) {
            // If both values are arrays, merge recursively
            if (is_array($array1[$key]) && is_array($value)) {
                customNestedMerge($array1[$key], $value);
            }
            // If both values are numeric (for 'amount'), sum them
            elseif (is_numeric($array1[$key]) && is_numeric($value)) {
                $array1[$key] += $value;

            }
        } else {
            
            // If key doesn't exist, just add the new value
            $array1[$key] = $value;
            
        }
        
    }
    
}

// Function to add or update the nested fee structure in the master array
function addToMasterFeeStructure(&$masterArray, $month, $feeType, $amount) {
    // Define the structure to be added without nesting 'amount'
    $newData = [
        $month => [
            $feeType => [
                'amount' => $amount // Set 'amount' directly to the numeric value
            ]
        ]
    ];
    

    // Merge the new data into the master array
    customNestedMerge($masterArray, $newData);
}

// Function to add or update the nested fee structure in the master array
function addToMasterFeeStructure2(&$masterArray2, $month, $feeType, $amount) {
    // Define the structure to be added without nesting 'amount'
    $newData = [
        $month => [
            $feeType => [
                'value' => intval($amount) // Set 'amount' directly to the numeric value
            ]
        ]
    ];

    // Merge the new data into the master array
    customNestedMerge($masterArray2, $newData);
}


 //end new code

    //print_r($discount_not_applied);
    // echo '<pre>';
    // print_r($feearray);
    // echo '</pre>';
    $MFfare=0;
    $frn=0;
foreach ($miscellaneousfees as $mf_key => $mf_value) {
    //echo $mf_key."=>".$mf_value."<br>";
    $cmm=explode("=",$mf_value['concatenated_miscellaneous_months']);
    $cmf=explode("=",$mf_value['concatenated_miscellaneous_fees']);
    
     $MFfare=$mf_value['MFfare'];
}
    if(!empty($discount_not_applied)){
        $discount_totalAmount = 0;

// Loop through the array and add up the 'amount' values
foreach ($discount_not_applied as $item) {
    $discount_totalAmount += $item->amount;
}
//echo $discount_totalAmount."<br>";
    }
    $row_counter = 1;
    $total_amount = 0;
    //print_r($feearray);
    //$months_count=1;
    
    foreach ($feearray as $fee_key => $fee_value) {
        if($fee_value->fee_group_count>=3 && !empty($miscellaneousfees_2)){
foreach ($miscellaneousfees_2 as $index => $object) {
    // print_r($object);
    // echo "<br>";
    //foreach ($feearray as $fee_key => $fee_value) {
        // if($fee_value->fee_group_count>=3 && !empty($miscellaneousfees)){
            $fv_name=explode(" ",$fee_value->code);
        //print_r($fv_name);
        $monthMapping =[ 1 => 'JAN', 2 => 'FEB', 3 => 'MARCH', 4 => 'APRIL', 5 => 'MAY',6 => 'JUNE',7 => 'JULY',8 => 'AUG',9 => 'SEP',10 => 'OCT',11 => 'NOV',12 => 'DEC'];
        //$months_count = array_search($fv_name[0], $monthMapping);
//$object->miscellaneous_months

  $cmm=explode("=",$object->concatenated_miscellaneous_months);//,//miscellaneous_months
  $miscellaneous_title=explode("=",$object->concatenated_main_miscellaneous_titles);//concatenated_miscellaneous_titles
  $miscellaneous_fees=explode("=",$object->concatenated_miscellaneous_fees);
  //concatenated_miscellaneous_fees
   //print_r($cmm);
   
//   echo "<br>".$months_count."<br>";
    //$cmf=explode("=",$object->miscellaneous_months);
     //$f_months=0;
     //$temp=0;
     //echo count($cmm)."<br>";
        for($i=0;$i<count($cmm);$i++){
            //$jtemp=0;
            $new_cmm=explode(",",$cmm[$i]);
            // echo "<br>$fv_name[0]<br>";
            // print_r($new_cmm);
            
           // echo $months_count.'=>'.$new_cmm.'=>'.in_array($months_count,$new_cmm)."<br>";
            if(in_array($fv_name[0],$new_cmm)){//&& $feeList->thf==1
                //$f_months=1;//$f_months+$cmf[$i];
                $miscellaneous_title_variable = "miscellaneous_title_" . ($i + 1);//$index
    $MFfare_variable = "MFfare_" . ($i + 1);//$index
    //$MFfare_variable_count = "array_" . $miscellaneous_title[$i].'_'.$i;//$object->miscellaneous_title;//count($cmm);
    
     //${$MFfare_variable_count.$object->miscellaneous_title};
    //  if(isset(${$MFfare_variable_count})){
    //  ${$MFfare_variable_count}= ${$MFfare_variable_count}+1;
    //  }else{
    //      ${$MFfare_variable_count}=${$MFfare_variable_count}+1;
    //  }
  
    // Assign values to variables
    ${$miscellaneous_title_variable} = $miscellaneous_title[$i];//$object->miscellaneous_title;
   ${$MFfare_variable} =$miscellaneous_fees[$i] ;//*  ${$MFfare_variable_count};
    //echo ${$MFfare_variable_count}."<br>";
                
            }
        }
        }
   
    
}

        //echo $fee_value->name.'==>'.$fee_value->code.'==>'.$fee_value->type."<br>";
        //echo $fee_value->thf."<br>";
        $amount_prev_paid = 0;
        $fees_fine_amount = 0;
        $fine_amount_paid = 0;
        $fine_amount_status = false;
        $amount_to_be_pay = $fee_value->amount;
        $fee_discount     = 0;
        //echo $fee_value->fee_receipt_no_id."<br>";
        if($fee_value->fee_receipt_no_id==0 || empty($fee_value->fee_receipt_no_id)){
            $frn=1;
        }
        
//        echo $fee_value->fine_amount."<br>";

        if ($fee_value->is_system) {
            $amount_to_be_pay = $fee_value->student_fees_master_amount;
        }

    
        if (is_string(($fee_value->amount_detail)) && is_array(json_decode(($fee_value->amount_detail), true))) {

            $amount_data = json_decode($fee_value->amount_detail);
            if($fee_value->fee_group_count>=3){
             //echo '<pre>';
             
            // Loop through the main object
foreach ($amount_data as $key => $value) {
    // echo "main Key: $key\n";
    
    // Check if the value is an object or array
    if (is_object($value) || is_array($value)) {
        
        // Inner loop through nested objects/arrays
        foreach ($value as $subKey => $subValue) {
            // Check if the nested value is also an object or array
            if (is_object($subValue) || is_array($subValue)) {
                
                // Inner loop for deeper level nested objects/arrays
                //echo "if  $subKey:\n";
                $total_sub_value=0;
                foreach ($subValue as $innerKey => $innerValue) {
                    //echo "if loop    $innerKey: $innerValue\n";
                    if($innerKey!="total_amount"){
                    $total_sub_value+=intval($innerValue);
                    //echo "totalAmount= $total_sub_value\n";
                    }
                }
                //echo "totalAmount= $total_sub_value\n";
               
                
           
            addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], $subKey,-abs($total_sub_value));
            
                
            } else {
                // Print the value directly if it’s not an object/array
              // echo "if else  $subKey: $subValue\n";
            }
            

        }
    } else {
        // Print the value if it’s not an object/array
      // echo " main Value: $value\n";
    }
    
}
           
 //print_r($amount_data);
// print_r($masterArray);
  //echo '</pre>';
             }

            foreach ($amount_data as $amount_data_key => $amount_data_value) {
                
                      $fine_amount_paid+=$amount_data_value->amount_fine;
                      
                      if(!empty($amount_data_value->amount_discount)){
                          //if($fee_value->fee_group_count>=3){
                              $amount_prev_paid = $amount_prev_paid + (intval($amount_data_value->amount) + intval($amount_data_value->amount_discount));
                     
                        //   }else{
                        //       $amount_prev_paid = $amount_prev_paid + (intval($amount_data_value->amount) + intval($amount_data_value->amount_discount));
                     
                        //   }
                          $fee_discount+=intval($amount_data_value->amount_discount);
                           }else{
                $amount_prev_paid = $amount_prev_paid + (intval($amount_data_value->amount)); //+ intval($amount_data_value->amount_discount));
                      }
                      
            }
//echo $fee_value->thf."<br>";
            if ($fee_value->is_system) {
                $amount_to_be_pay = $fee_value->student_fees_master_amount - $amount_prev_paid;
            } else {

                $amount_to_be_pay = $fee_value->amount - $amount_prev_paid;
            }
            
        }
        if (!empty($fee_value->amount_detail)){ //$fee_discount>=0 || 
            $discount_totalAmount=0;
        }

    //fine 
    if(($fee_value->due_date != "0000-00-00" && $fee_value->due_date != NULL) && (strtotime($fee_value->due_date) < strtotime(date('Y-m-d'))))
    {
        if (!empty($fee_value->amount_detail)) {
            //paid and partial
        //     if($fine_amount_paid>0){
        //     $fees_fine_amount=$fee_value->fine_amount-$fine_amount_paid;
        //  $total_amount=$total_amount+$fees_fine_amount;
        //     }else{
        //         $fees_fine_amount=$fine_amount_paid;
        //  $total_amount=$total_amount+$fine_amount_paid;
        //     }
        //  if($fees_fine_amount>0){
        //  $fine_amount_status=true;
        //  }
        }
        else{
            //unpaid
            $fees_fine_amount=$fee_value->fine_amount;
         $total_amount=$total_amount+$fees_fine_amount;
         if($fees_fine_amount>0){
         $fine_amount_status=true;
         }
        }
    }
    
    //echo $fine_amount_status."<br>";
    if($fee_value->name=="Balance Master"){ //&& $fee_value->fee_groups_id==$fee_value->ss_fee_groups_id
        $amount_to_be_pay=$amount_to_be_pay;
        addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], $fee_value->name, $amount_to_be_pay);

    }elseif($fee_value->fee_group_count>=3){
        $fv_name=explode(" ",$fee_value->code);
        //print_r($fv_name);
        $monthMapping =[ 1 => 'JAN', 2 => 'FEB', 3 => 'MARCH', 4 => 'APRIL', 5 => 'MAY',6 => 'JUNE',7 => 'JULY',8 => 'AUG',9 => 'SEP',10 => 'OCT',11 => 'NOV',12 => 'DEC'];
        //$months_count = array_search($fv_name[0], $monthMapping);
//echo $months_count."<br>";
        $f_months=0;
        if(!empty($cmm)){
        for($i=0;$i<count($cmm);$i++){
            
            $new_cmm=explode(",",$cmm[$i]);
            if(in_array(explode(' ', $fee_value->code)[0],$new_cmm)){
                $f_months=$f_months+$cmf[$i];
            
            
            $miscellaneous_title_variable = "miscellaneous_title_" . ($i + 1);
$MFfare_variable = "MFfare_" . ($i + 1);//$index
    
if(${$MFfare_variable}>0){
    addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], ${$miscellaneous_title_variable},  ${$MFfare_variable});
        
}
}
            
        }
        addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], $fee_value->name,  $f_months);
        
addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], "Discount",  $discount_totalAmount);
       
        
        }
       
        
        if(!empty($newArray)){
            $new_t_f=0;
         for($i=0;$i<count($newArray);$i++){
             if(in_array(explode(' ', $fee_value->code)[0], $newArray[$i])){
                 $f_months+=$route_fees[$i]['fare'];
                 $new_t_f+=$route_fees[$i]['fare'];
             }
         }
         if($new_t_f>0){
         addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], "Transport Fee", $new_t_f);
         }

        }
        if(!empty($newArray_hostel)){
            $new_h_t=0;
         for($i=0;$i<count($newArray_hostel);$i++){
             if(in_array(explode(' ', $fee_value->code)[0], $newArray_hostel[$i])){
                 $f_months+=$hostel_fees[$i]['cost_per_bed'];
                 $new_h_t+=$hostel_fees[$i]['cost_per_bed'];
             }
         }
         if($new_h_t>0){
         addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], "Hostel Fee", $new_h_t);
         }

        }
        
        //$amount_to_be_pay=$amount_to_be_pay+$fee_value->fare+$fee_value->cost_per_bed;
         //if($fee_paid+$fee_discount==$feeList->amount){
         //$fee_value->amount
         if($amount_prev_paid==$fee_value->amount){ //$f_months
       $amount_to_be_pay=$amount_to_be_pay;
        
    }else{
        
       

$amount_to_be_pay=$amount_to_be_pay+$f_months;
//$months_count=$months_count+1;
    }

    }else{
        $amount_to_be_pay=$amount_to_be_pay;
        //echo explode(' ', $fee_value->type)[0].'=='.$fee_value->name;
        addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], $fee_value->name, $amount_to_be_pay);

    }
   
// if($fee_value->name!="Balance Master"){
//     $total_amount = $total_amount + $amount_to_be_pay+$fee_value->transport_fees;
// }else{
//     $total_amount = $total_amount + $amount_to_be_pay;
// }
// if($fee_value->name=="Balance Master" ){

// }else{
//echo $amount_to_be_pay.'-'.$discount_totalAmount;
$amount_to_be_pay = ($fee_value->name!="Balance Master" && $fee_value->fee_group_count>=3)? $amount_to_be_pay-$discount_totalAmount: $amount_to_be_pay; //$fee_value->amount_detail==0 && 
//}
 if($fee_value->thf==1){
                    $amount_to_be_pay=$amount_to_be_pay-1;
                    
                }
$total_amount = $total_amount + $amount_to_be_pay;
// echo $feetype_balance == 0 && !empty($fee_value->amount_detail) && !empty($fine_amount_paid) ? $fine_amount_paid : ($feetype_balance == 0 || !empty($fee_value->amount_detail) && $fine_amount_paid==0 ? $fee_value->fine_amount - $fine_amount_paid : ($feetype_balance == 0 && empty($fee_value->amount_detail) && $fine_amount_paid==0 ? 0 :($fine_amount_paid!=0?0:$fee_value->fine_amount) ));
//echo !empty($fee_value->amount_detail) && !empty($fine_amount_paid) ? $fine_amount_paid : (!empty($fee_value->amount_detail) && $fine_amount_paid==0 ? $fee_value->fine_amount - $fine_amount_paid : (empty($fee_value->amount_detail) && $fine_amount_paid==0 ? 0 :($fine_amount_paid!=0?0:$fee_value->fine_amount) ))."<br>";
               
        if ($amount_to_be_pay >= 0) {
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "fee_group_count", $fee_value->fee_group_count);
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "fee_receipt_no_id", (empty($fee_value->fee_receipt_no_id) || $fee_value->fee_receipt_no_id == 0) ? 0 : $fee_value->fee_receipt_no_id);
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "student_fees_master_id", $fee_value->id);
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "fee_groups_feetype_id", $fee_value->fee_groups_feetype_id);
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "fee_session_groups_id", $fee_value->fee_session_group_id);
 addToMasterFeeStructure2($masterArray2, explode(' ', $fee_value->type)[0], "thf", $fee_value->thf);
 if($fine_amount_status && $fees_fine_amount>0){
     addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], "Fine",  $fees_fine_amount);
     
 }
 
 addToMasterFeeStructure($masterArray, explode(' ', $fee_value->type)[0], "Totals",  0);
     

            ?>


            <?php
        }

        $row_counter++;
    }
    // Print the master array to see the result
// echo '<pre>';
// //print_r($miscellaneousfees);
//  print_r($masterArray);
//   echo '</pre>';
//   echo '<pre>';
//print_r($miscellaneousfees_2);
// print_r($masterArray);
 // Custom sort function based on count of fee types

 // Loop through each month's fee array
// foreach ($masterArray as $month => $details) {
//     echo "Month: $month ".count($details)."\n";
    
//     // Loop through each fee type inside the month
    // foreach ($details as $feeType => $feeDetails) {
    //     echo "Fee Type: $feeType, Amount: " . $feeDetails['amount'] . "\n";
    // }
//     echo "\n"; // Newline for clarity
// }

// Initialize an empty array to store unique fee types
$unique_fee_type_all_fee = array();

// Initialize an empty array to store unique fee types
$unique_fee_type_all_fee = array();

// Loop through the $masterArray to collect all unique fee types
foreach ($masterArray as $month => $details) {
    foreach ($details as $feeType => $feeDetails) {
        // Add fee type to the array if it isn't already present
        if (!in_array($feeType, $unique_fee_type_all_fee)) {
            $unique_fee_type_all_fee[] = $feeType;
        }
    }
}

// Remove "TUITION FEE"
if (($key = array_search('TUITION FEE', $unique_fee_type_all_fee)) !== false) {
    unset($unique_fee_type_all_fee[$key]);
}


if (($key = array_search('Discount', $unique_fee_type_all_fee)) !== false) {
    unset($unique_fee_type_all_fee[$key]);
}

if (($key = array_search('Totals', $unique_fee_type_all_fee)) !== false) {
    unset($unique_fee_type_all_fee[$key]);
}

// Remove "Fine" and "Discount" to manually add them at the end
if (($key = array_search('Fine', $unique_fee_type_all_fee)) !== false) {
    unset($unique_fee_type_all_fee[$key]);
}

// Add "Discount" as the last item
$unique_fee_type_all_fee[] = 'Discount';

// Add "Totals" as the last item
$unique_fee_type_all_fee[] = 'Totals';

// Add "Fine" as the second last item
$unique_fee_type_all_fee[] = 'Fine';

$unique_fee_type_all_fee=array_values($unique_fee_type_all_fee);
// Output the unique fee types array
// echo "Unique Fee Types:\n";
// print_r($unique_fee_type_all_fee);
  // echo '</pre>';
//   echo '<pre>';
//   print_r($masterArray);
//   echo '</pre>';
    ?>
</ul>
</div>

</div>
</div>

<input name="frn" type="hidden" value="<?php echo $frn; ?>">
                
<?php if ($total_amount > 0) { ?>

<!--new code-->
 <!--container-->
 <?php
 // Loop through each month's fee array
// foreach ($masterArray as $month => &$details) {
//   // echo "Month: $month ".count($details)."\n";
    
//     // Loop through each fee type inside the month
//     foreach ($details as $feeType => &$feeDetails) {
//         //echo "Fee Type: $feeType, Amount: " . $feeDetails['amount'] . "\n";
//         if($feeType!="Fine" && $feeType!="Discount" && $feeType!="Totals" && $feeType!="TUITION FEE")
//         {
//             $details["Totals"]['amount']+=intval($feeDetails['amount']);
                            
//         }
        
        
//     }
//     //echo "\n"; // Newline for clarity
// }
 
 ?>
 
<div class="container col-lg-12">
        <table class="demo table-striped table-bordered table-hover">
            <thead>
                <tr>
                    <!--<th>Tick Fees</th>-->
                    <th class="fees-head">Fees Head</th>
                    
                    <?php
                    
                    foreach ($masterArray as $month => $details) {
                       
                        echo "<th>$month</th>";
                    }
                    
                    ?>
                </tr>
            </thead>
            <tbody>
                <?php 
                //$temp=0;
               //$total_month_amount=0;
                foreach ($unique_fee_type_all_fee as $feeType => $unique_fee_type) {
                    //echo $feeType.'=='.count($unique_fee_type_all_fee)."<br>";
                     
                 
                    echo "<tr>";
                    // Show the fee type in the first column
                echo "<td class='fees-head'>$unique_fee_type</td>";
               
                // Loop through all months and check if the fee type exists
                foreach ($masterArray as $month => $details) {
                   // echo $unique_fee_type.'==>'.$month.'==>'.$details[$unique_fee_type].'==>'.$details[$unique_fee_type]['amount']."<br>";
                // Loop through all months and check if the fee type exists
                
                            
                    // Check if the fee type exists in this month
                    if (isset($details[$unique_fee_type])) {
                        
                        if($unique_fee_type=="Fine"){
                            //echo "<td id='fine-".$month."'>" . $details[$unique_fee_type]['amount'] . "</td>";
                            //$details["Totals"]['amount']+=$details[$unique_fee_type]['amount'];
                           // echo "<td id='td_fine-{$month}'><input type='number' value='{$details[$unique_fee_type]['amount']}' id='fine-{$month}' onchange='updateTotalByFineDiscount(\"$month\",\"Fine\")'></td>";
                echo "<td id='td_fine-{$month}'><input type='number' class='form-control' value='{$details[$unique_fee_type]['amount']}' id='fine-{$month}' onchange='updatevalue()'></td>";
               
                        }else if($unique_fee_type=="Discount"){
                           // $details["Totals"]['amount']=$details["Totals"]['amount']-$details[$unique_fee_type]['amount'];
                            //echo "<td id='discount-".$month."'>" . $details[$unique_fee_type]['amount'] . "</td>";
                            //echo "<td id='td_discount-{$month}'><input type='number' value='{$details[$unique_fee_type]['amount']}' id='discount-{$month}' onchange='updateTotalByFineDiscount(\"$month\",\"Discount\")'></td>";
               echo "<td id='td_discount-{$month}'><input type='number' class='form-control' value='{$details[$unique_fee_type]['amount']}' id='discount-{$month}' onchange='updateTotalByDiscount(\"$month\")' $disabled></td>";
               
                        }else if($unique_fee_type=="Totals"){
                            //echo $details[$unique_fee_type]['amount']."<br>";
                           // echo "IF ".$unique_fee_type.'==>'.$month.'== t a '.$details["Totals"]['amount']."<br>";
                            echo "<td id='total-{$month}'><strong>{$details[$unique_fee_type]['amount']}</strong></td>";

                            
                        }
                        else
                        {
                            //$details["Totals"]['amount']+=$details[$unique_fee_type]['amount'];
                            // echo "IF else ".$feeType.'=='.$unique_fee_type.'==>'.$month.'== t a '.$masterArray[$month][$unique_fee_type]['amount']."<br>";
                           
                        //echo "<td id='{$unique_fee_type}-{$month}'>{$details[$unique_fee_type]['amount']}</td>";
                        echo "<td><input type='number' class='form-control' value='{$details[$unique_fee_type]['amount']}' id='{$unique_fee_type}-{$month}' min='0' max='{$details[$unique_fee_type]['amount']}' onchange='updateTotalByFeesHead(\"$unique_fee_type\", \"$month\")'></td>";
                        echo "<td hidden><input type='number' class='form-control' value='{$details[$unique_fee_type]['amount']}' id='{$unique_fee_type}-{$month}-hidden' min='0' max='{$details[$unique_fee_type]['amount']}'></td>";

                        }
                    } else {
                       // echo "<td>0</td>"; // Fee type doesn't exist in this month
                        if($unique_fee_type=="Fine"){
                            //echo "<td id='fine-".$month."'>" . $details[$unique_fee_type]['amount'] . "</td>";
                            //echo "<td id='td_fine-{$month}'><input type='number' value='0' id='fine-{$month}' onchange='updateTotalByFineDiscount(\"$month\",\"Fine\")'></td>";
               echo "<td id='td_fine-{$month}'><input type='number' class='form-control' value='0' id='fine-{$month}' onchange='updatevalue()'></td>";
               
                        }else if($unique_fee_type=="Discount"){
                            //echo "<td id='discount-".$month."'>" . $details[$unique_fee_type]['amount'] . "</td>";
                            //echo "<td id='td_discount-{$month}'><input type='number' value='0' id='discount-{$month}' onchange='updateTotalByFineDiscount(\"$month\",\"Discount\")'></td>";
               echo "<td id='td_discount-{$month}'><input type='number' class='form-control' value='0' id='discount-{$month}' onchange='updateTotalByDiscount(\"$month\")' $disabled></td>";
               
                        }else if($unique_fee_type=="Totals"){
                            //echo 'ELSE '.$unique_fee_type.'==>'.$month.'== t a '.$details["Totals"]['amount']."<br>";
                            echo "<td id='total-{$month}'>0</td>";
                            //$details[$unique_fee_type]['amount']=0;
                            //echo "<td id='total-".$month."'>" . $details[$unique_fee_type]['amount'] . "</td>";
                            
                            
                        }
                        else
                        {
                            //$details["Totals"]['amount']+=0;//$details[$unique_fee_type]['amount'];
                             //echo "IF else ".$unique_fee_type.'==>'.$month.'== t a '.$details["Totals"]['amount']."<br>";
                           //echo "ELSE else ".$feeType.'=='.$unique_fee_type.'==>'.$month.'== t a '.$masterArray[$month][$unique_fee_type]['amount']."<br>";
                           
                        //echo "<td id='{$unique_fee_type}-{$month}'>0</td>";
                        echo "<td><input type='number' value='0' class='form-control' id='{$unique_fee_type}-{$month}' min='0' max='0' onchange='updateTotalByFeesHead(\"$unique_fee_type\", \"$month\")'></td>";
                        echo "<td hidden><input type='number' value='0' id='{$unique_fee_type}-{$month}-hidden' min='0' max='0'></td>";


                        }
                    }
                    
                
                
                
                }
                echo "</tr>";
                
                if($feeType==(count($unique_fee_type_all_fee)-1)){ //3
                // console.log("details: ", $details);
                
                    echo "<tr><td class='fees-head'><b> Received</b> </td>";
                    // Loop through all months and check if the fee type exists
                foreach ($masterArray as $month => $details) {
                //  echo "<td><input type='number' class='form-control' value='0' id='received-{$month}' onchange='updateBalanceByReceived(\"$month\")' readonly></td>";
                 echo "<td><input type='number' class='form-control' value='0' id='received-{$month}' readonly></td>";
                }
                echo "</tr>";
                }
                // if($feeType==(count($unique_fee_type_all_fee)-1)){
                //     echo "<tr><td>Balance</td>";
                //     // Loop through all months and check if the fee type exists
                // foreach ($masterArray as $month => $details) {
                // echo "<td id='balance-{$month}'>0</td>";
                // }
                // echo "</tr>";
                
                // }
               
               
                }
                
                ?>
                

               
            </tbody>
        
        </table>
        
    </div>
    <?php 
//      echo '<pre>';
//   print_r($masterArray);
//   echo '</pre>';
  ?>
   
 <script>
function distributeCommonDiscount() {
    let totalDiscount = parseFloat(document.getElementById('common_discount_input').value) || 0;
    let months = [];
    let totalReceived = 0;

    // First: Reset all discounts to 0 and restore received amounts
    document.querySelectorAll("input[id^='discount-']").forEach(input => {
        const parts = input.id.split('-');
        const month = parts[1];

        const discountInput = document.getElementById(`discount-${month}`);
        const receivedInput = document.getElementById(`received-${month}`);
        const originalReceived = parseFloat(receivedInput?.dataset.original) || parseFloat(receivedInput?.value) || 0;
       

        // Store original if not already done
        if (!receivedInput.dataset.original) {
            receivedInput.dataset.original = originalReceived;
        }

        // Reset discount
        discountInput.value = 0;
        discountInput.dispatchEvent(new Event('change'));

        // Restore received amount
        receivedInput.value = receivedInput.dataset.original;
    });

    // Now: Recalculate total received from original values
    document.querySelectorAll("input[id^='received-']").forEach(receivedInput => {
        const month = receivedInput.id.split('-')[1];
        const receivedAmount = parseFloat(receivedInput?.value) || 0;
        totalReceived += receivedAmount;
        if (!months.includes(month)) months.push(month);
    });

    if (totalDiscount > totalReceived) {
        alert(`Common discount cannot exceed the total received amount (₹${totalReceived}).`);
        return;
    }

    // Sort months in reverse (latest month first)
    months.sort((a, b) => new Date("1 " + a) - new Date("1 " + b));

    // Apply discount
    for (let month of months) {
        if (totalDiscount <= 0) break;

        const discountInput = document.getElementById(`discount-${month}`);
        const receivedInput = document.getElementById(`received-${month}`);

        const maxDiscountAllowed = parseFloat(receivedInput?.value) || 0;

        const discountToApply = Math.min(maxDiscountAllowed, totalDiscount);

        discountInput.value = discountToApply;
        discountInput.dispatchEvent(new Event('change'));

        // Update received value
    
        receivedInput.value = maxDiscountAllowed -  discountToApply;
        <!--receivedInput.value =  receivedInput.value -  discountToApply;-->

        totalDiscount -= discountToApply;
    }
}




function distributePartialAmount() {
    <!--let totalAmount = parseFloat(document.getElementById('partially_paid_amount').value) || 0;-->
    
    let partiallAmount = parseFloat(document.getElementById('partially_paid_amount').value) || 0;
    let discountAmount =  parseFloat(document.getElementById('common_discount_input').value) || 0;
     let totalAmount = partiallAmount + discountAmount;
     console.log("partiall Amount: " , partiallAmount);
      console.log("discount Amount: " , discountAmount);
       console.log("total Amount: " , totalAmount);
    
    let months = [];
    let totalReceived = 0;
    let feeData = {};
    let feeInfo = [];
    let monthNames = ["jan", "feb", "march", "april", "may", "june",
        "july", "aug", "sep", "oct", "nov", "dec", "id", "annual", "previous", "admission", "re-admission", "book"];


    function isMonth(str) {
        return monthNames.includes(str.toLowerCase());
    }
    // Call fetchMonthNames() and use .then() to wait for it to complete
    
        
        document.querySelectorAll("input[id*='-']:not([id^='fine-']):not([id^='discount-']):not([id^='received-'])").forEach(input => {
            const fullId = input.id;
          
            const parts = fullId.split('-');
            let month = parts[parts.length - 1];
            let combinedFeeName = "";
            let feeType = "";
            
              if (parts.length == 2 && !isMonth(month)) {
            // If it's a month, add it to monthNames if it's not already there
            if (!monthNames.includes(month.toLowerCase())) {
                monthNames.push(month.toLowerCase());
               
            }
        }
        


            if (parts.length > 1 && isMonth(parts[parts.length - 1])) {
                month = parts[parts.length - 1];
                combinedFeeName = parts.slice(0, parts.length - 1).join('-');
                feeType = parts.slice(0, parts.length - 1).join('-');
            } else if (parts.length < 3 && !isMonth(parts[parts.length - 1])) {
                // One-time fee
                combinedFeeName = parts.slice(0, parts.length - 1).join('-');
                feeType = parts.slice(0, parts.length - 1).join('-');
                month = parts[parts.length - 1];
            } else {
                return;
            }

            const AmountInput = document.getElementById(`${fullId}`);
            let receivedInput;
            if (isMonth(month)) {
                receivedInput = document.getElementById(`received-${month}`);
            } else {
                receivedInput = document.getElementById(`received-${feeType}`);
            }
          
            if (!AmountInput || !receivedInput) return;

            const originalReceived = parseFloat(receivedInput.dataset.original) || parseFloat(receivedInput.value) || 0;
            const originalAmount = parseFloat(AmountInput.dataset.original) || parseFloat(AmountInput.value) || 0;
            
            
            if (originalAmount === 0) {
            
                return;
            }
            if (!receivedInput.dataset.original) {
                receivedInput.dataset.original = originalReceived;
            }
            // Store original if not already done
            if (!AmountInput.dataset.original) {
                AmountInput.dataset.original = originalAmount;
            }


            if (isMonth(month)) {
                if (!feeData[month]) {
                    feeData[month] = [];
                }
                feeData[month].push({ combinedFeeName, feeType, fullId, originalAmount });
            } 
            // else {
                // oneTimeFees.push({ combinedFeeName, feeType, fullId, originalAmount });
            // }


            AmountInput.value = 0;
            AmountInput.dispatchEvent(new Event('change'));


        });

        document.querySelectorAll("input[id^='received-']").forEach(receivedInput => {
            const parts = receivedInput.id.split('-');
          
            let month;
            if (parts.length === 2) {
                month = parts[1];
            } else {
                month = parts[1];
            } const receivedAmount = parseFloat(receivedInput.value) || 0;
            totalReceived += receivedAmount;
            if (!months.includes(month) && isMonth(month)) months.push(month);
        });
     
        // if (totalAmount > totalReceived) {
        //     alert(`Common discount cannot exceed the total received amount (₹${totalReceived}).`);
        //     return;
        // }

        // Sort months in reverse (latest month first)
        months.sort((a, b) => new Date("1 " + a) - new Date("1 " + b));

        // Apply discount to monthly fees

        for (let month of months) {

            for (let feeInfo of feeData[month]) {

               
                const { combinedFeeName, feeType, fullId, originalAmount } = feeInfo;
               
                const AmountInput = document.getElementById(`${fullId}`);
                const receivedInput = document.getElementById(`received-${month}`);
                

               

                if (!AmountInput || !receivedInput) continue;
               


                //   const maxAmountAllowed = parseFloat(AmountInput.value);

                const maxAmountAllowed = originalAmount;
                const amountToApply = Math.min(maxAmountAllowed, totalAmount);
               
                AmountInput.value = amountToApply;
                AmountInput.dispatchEvent(new Event('change'));
                //receivedInput.value += amountToApply;
                totalAmount -= amountToApply;
                
                
                
                
            }

        }

        updatevalue();

}


 function updatevalue(){
        let total_amount=0;
        let total_discount_amount=0;
        let total_fine_amount=0;
        let jsArray = <?php echo json_encode($masterArray); ?>;
         // Loop through `jsArray` to access each month and gather its data
    for (let month in jsArray) {
        if (jsArray.hasOwnProperty(month)) {
             // Add additional data fields for each month
            total_fine_amount += parseFloat(document.getElementById(`fine-${month}`)?.value) || 0;
            total_discount_amount += parseFloat(document.getElementById(`discount-${month}`)?.value) || 0;
            total_amount += parseFloat(document.getElementById(`received-${month}`)?.value) || 0;
            //  total_amount = parseFloat(document.getElementById(`received-${month}`)?.value) || 0;
            
        }
        
    }
    //console.log(total_fine_amount);
    document.getElementById('total-discount-pay').innerText = (total_discount_amount).toFixed(2);
    document.getElementById('total-amount-pay').innerText = (total_amount).toFixed(2);
    document.getElementById('total-fine-pay').innerText = (total_fine_amount).toFixed(2);
    document.getElementById('grant-total-amount').innerText = (total_amount + total_fine_amount).toFixed(2);
    
    
    }
 // Object to store the previous values of each fee head for each month
    prevValues = {};
jsArray={};
 baseTotals = {};
     currentTotals = {};
  prevDiscount = {};
   //prevFine = {};  // New variable for previous fine
 jsArray = <?php echo json_encode($masterArray); ?>;
    //console.log(jsArray);
    // Initialize base totals and current totals
    // let baseTotals = {};
    // let currentTotals = {};
    // let prevDiscount = {};
    // let prevFine = {};  // New variable for previous fine

    // Populate base totals, current totals, and prevDiscount
    for (let month in jsArray) {
        if (jsArray.hasOwnProperty(month)) {
        let details = jsArray[month];
        
        // Initialize or reset total for the month
        let totalAmount = 0;
// Initialize prevValues for each feeType and month with initial values
            prevValues[month] = prevValues[month] || {};
        // Iterate over each fee type in the month
        for (let feeType in details) {
            if (details.hasOwnProperty(feeType) && feeType !== "Fine" && feeType !== "Discount" && feeType !== "Totals" && feeType !== "TUITION FEE") {
                
                // Add the amount of this fee type to the total amount
                totalAmount += parseFloat(details[feeType].amount) || 0;//parseFloat(details?.[feeType]?.amount || 0);
                
                 prevValues[month][feeType] = parseFloat(details[feeType].amount) || 0;
            
            }
        }

        // Update the Totals amount for the month
        details["Totals"].amount = totalAmount.toFixed(2);
    }
        // baseTotals[month] = parseFloat(jsArray[month]['Totals']['amount']) || 0;
        // currentTotals[month] = baseTotals[month];  // Set initial current totals as base totals
        if (jsArray[month] && jsArray[month]['Totals'] && jsArray[month]['Totals']['amount']) {
        baseTotals[month] = parseFloat(jsArray[month]['Totals']['amount']) || 0;
        currentTotals[month] = baseTotals[month];
    } else {
        //console.warn(`Warning: Base total is missing or undefined for month "${month}".`);
        baseTotals[month] = 0;  // Set a default to avoid undefined issues
        currentTotals[month] = 0;
    }
        
        prevDiscount[month] = 0;                   // Initialize previous discount as 0 for each month
        //prevFine[month] = 0;                       // Initialize previous fine as 0 for each month
   
    }


// Unified function to update totals when Fine or Discount is changed
// function updateTotalByFineDiscount(month, type) {
//     // Check if base total is defined for the given month
//     if (typeof baseTotals[month] === 'undefined') {
//         console.error(`Error: Base total is undefined for month "${month}". Cannot update total.`);
//         return false;
//     }
//     // Get the current input value based on type
//     let value = parseFloat(document.getElementById(`${type.toLowerCase()}-${month}`).value) || 0;

//     // Adjust current total based on the type (Fine or Discount)
//     if (type === "Fine") {
//         // Validation to ensure the balance doesn't go negative
//         //     if (((baseTotals[month] - prevDiscount[month]) + value) < 0) {
//         //         // alert(`Fine amount for ${month.toUpperCase()} cannot exceed the total amount (${baseTotals[month]}).`);
//         //         // return;
//         // alert(`Fine amount for ${month.toUpperCase()} cannot exceed the total amount (${baseTotals[month].toFixed(2)}).`);
//         // return false;

                
//         //     }
//         // Adjust total by subtracting the previous discount and adding the new fine
//         currentTotals[month] = (baseTotals[month] - prevDiscount[month]) + value; 
//         // Update stored previous fine value
//         prevFine[month] = value; 
//     } else if (type === "Discount") {
//         // Validation to ensure the balance doesn't go negative
//             if (((baseTotals[month] + prevFine[month]) - value) < 0) {
//                 // alert(`Discount amount for ${month.toUpperCase()} cannot exceed the total amount (${baseTotals[month]}).`);
//                 // return;
//                 alert(`Discount amount for ${month.toUpperCase()} cannot exceed the total amount (${baseTotals[month].toFixed(2)}).`);
//         return false;

                
//             }
//         // Adjust total by adding the previous fine and subtracting the new discount
//         currentTotals[month] = (baseTotals[month] + prevFine[month]) - value; 
        
//         // Update stored previous discount value
//         prevDiscount[month] = value; 
//     }

//     // Update displayed total
//     document.getElementById(`total-${month}`).innerText = currentTotals[month].toFixed(2);

//     // Debugging logs
//     // console.log(`Base Total for ${month}:`, baseTotals[month]);
//     // console.log(`Previous ${type}:`, type === "Fine" ? prevFine[month] : prevDiscount[month]);
//     // console.log(`Current ${type} Input:`, value);
//     // console.log(`Updated Total for ${month}:`, currentTotals[month]);
// }

// Function to update totals when the fee head value is changed
    function updateTotalByFeesHead(uniqueFeeType, month) {//,temp=0
        let inputElement = document.getElementById(`${uniqueFeeType}-${month}`);
        let value = parseFloat(inputElement.value);
        let min = parseFloat(inputElement.min);
        let max = parseFloat(inputElement.max);
let temp=0;
        // Ensure value is within min and max bounds
        if (value < min) {
            alert(`Value is too low! Setting to minimum (${min}).`);
            inputElement.value = min;
            value = min;
            temp=1;
        } else if (value > max) {
            alert(`Value is too high! Setting to maximum (${max}).`);
            inputElement.value = max;
            value = max;
            temp=1;
        }
if(temp==0){
        calculateReceivedAmount(uniqueFeeType, month);//, value
}


    }

   // Function to adjust the "Received" amount based on the new value
function calculateReceivedAmount(uniqueFeeType, month) {
    // Retrieve the previous value from prevValues
    let previousValue = prevValues[month][uniqueFeeType] || 0;

    // Get the new value entered by the user
    let newValue = parseFloat(document.getElementById(`${uniqueFeeType}-${month}`).value) || 0;

    // Calculate the difference between the new and previous values
    let difference = previousValue-newValue;

    // Update the "Received" amount by adjusting it with the calculated difference
    let receivedElement = document.getElementById(`received-${month}`);
    let receivedValue = parseFloat(receivedElement.value) || 0;
    if(difference!=0){
         // Adjust the received value and update it in the DOM
    receivedElement.value = ((receivedValue-previousValue) + newValue).toFixed(2);
    
    }else{
         // Adjust the received value and update it in the DOM
    receivedElement.value = (receivedValue + newValue).toFixed(2);
    }

   

    // Update the previous value in prevValues to the new value
    prevValues[month][uniqueFeeType] = newValue;
    
    updatevalue();
}


    // Function to calculate totals if needed for other calculations
    function calculateTotals(uniqueFeeType, month) {
        let inputElement = document.getElementById(`${uniqueFeeType}-${month}`);
        let value = parseFloat(inputElement.value);
        let total = parseFloat(document.getElementById(`total-${month}`).innerText) || 0;
        document.getElementById(`total-${month}`).innerText = (value + total).toFixed(2);
    }
function updateTotalByDiscount(month) {
    // console.log(prevValues);
    // console.log(prevValues[month]);
    // let total=0;
//     Object.entries(prevValues[month]).forEach(([feeType, amount]) => {
//     //console.log(`Fee Head: ${feeType}, Amount: ${amount}`);
//     total+=amount;
//     // Here, `feeType` is the key, and `amount` is the value
// });
    // Check if base total is defined for the given month
    // if (typeof baseTotals[month] === 'undefined') {
    //     console.error(`Error: Base total is undefined for month "${month}". Cannot update total.`);
    //     return false;
    // }
    // Get the current input value based on type
    let total = parseFloat(document.getElementById(`received-${month}`).value) || 0;
    let value = parseFloat(document.getElementById(`discount-${month}`).value) || 0;
    

    
        // Validation to ensure the balance doesn't go negative
            if ((total - value) < 0) {
                // alert(`Discount amount for ${month.toUpperCase()} cannot exceed the total amount (${baseTotals[month]}).`);
                // return;
                alert(`Discount amount for ${month.toUpperCase()} cannot exceed the Received amount (${total.toFixed(2)}).`);
                document.getElementById(`discount-${month}`).value=0;
        return false;

                
            }
            if(value!=0){
            document.getElementById(`received-${month}`).value = (total-value).toFixed(2);
            }else{
               document.getElementById(`received-${month}`).value = (total+prevDiscount[month]).toFixed(2);
             
            }
        // Update stored previous discount value
        prevDiscount[month] = value; 
    

  updatevalue();


    // Debugging logs
    // console.log(`Base Total for ${month}:`, baseTotals[month]);
    // console.log(`Previous ${type}:`, type === "Fine" ? prevFine[month] : prevDiscount[month]);
    // console.log(`Current ${type} Input:`, value);
    // console.log(`Updated Total for ${month}:`, currentTotals[month]);
}

// Update Balance when Received is changed
function updateBalanceByReceived(month) {
    let total = parseFloat(document.getElementById(`total-${month}`).innerText) || 0;
    let received = parseFloat(document.getElementById(`received-${month}`).value) || 0;

    // Calculate new balance and update display
    let newBalance = total - received;
     // Validation to ensure the balance doesn't go negative
            if (newBalance < 0) {
                // alert(`Received amount for ${month.toUpperCase()} cannot exceed the total amount (${total}).`);
                // return;
                alert(`Received amount for ${month.toUpperCase()} cannot exceed the total amount (${total.toFixed(2)}).`);
        return false;

                
            }
    document.getElementById(`balance-${month}`).innerText = newBalance.toFixed(2);
}


// Initial calculations for all months
<?php //foreach ($masterArray as $month => $details) { ?>
    // updateTotalByFine('<?= $month ?>');
    
    // updateTotalByDiscount('<?= $month ?>');
    
    //updateTotalByFineDiscount('<?= $month ?>', 'Fine');
    //updateTotalByFineDiscount('<?= $month ?>', 'Discount');
   
   // updateBalanceByReceived('<?= $month ?>');
    
<?php //} ?>
for (let month in jsArray) {
    //  updateTotalByDiscount(month);
    // updateBalanceByReceived(month);
    
     let jsArray_unique_fee_type = <?php echo json_encode($unique_fee_type_all_fee); ?>;
     // Loop through each fee type and add its data to the month
            jsArray_unique_fee_type.forEach((feeType) => {
                // Only add to totals if the fee type is not one of the excluded types
    if (feeType != "Fine" && feeType != "Discount" && feeType != "Totals" && feeType != "TUITION FEE") {
     
                //updateTotalByFeesHead(feeType,month);//,1
                calculateTotals(feeType,month);
                calculateReceivedAmount(feeType,month);
    }
            });
            
             updateTotalByDiscount(month);
    
}
</script>
<!--end new code-->
<!-- Hidden input to store JSON data -->
    <input type="hidden" name="tableData" id="tableData" value="">
    
    <div class="container col-lg-12 collect_grp_fees" style="">
        <table class="table table-striped table-bordered table-hover">
    <thead>
        <tr>
            <th><?php echo $this->lang->line('description'); ?></th>
            <th class=""><?php echo $this->lang->line('amount'); ?></th>
        </tr>
    </thead>
    <tbody> 
       <tr style="background-color: #f0f7ff; border-left: 3px solid #3a7bd5;">
  <?php if ($this->rbac->hasPrivilege('fees_discount_assign', 'can_view')) { ?>
<tr>
  <td style="padding: 10px;">
    <label style="font-weight: 600; color: #2c3e50; margin-bottom: 0;"><strong>Common Discount Amount:</strong></label>
  </td>
  <td style="padding: 10px;">
    <div style="display: flex; justify-content: space-between;">
      <input type="number" id="common_discount_input" class="form-control" style="max-width: 200px; background-color: #fff8e1; border: 1px solid #e0e0e0; border-radius: 4px; box-shadow: inset 0 1px 2px rgba(0,0,0,0.05);">
      <button type="button" class="btn btn-primary btn-sm" onclick="distributeCommonDiscount()" style="background-color: #3a7bd5; border-color: #3a7bd5; box-shadow: 0 2px 4px rgba(0,0,0,0.1);">Distribute</button>
    </div>
  </td>
</tr>
<?php } ?>


<tr style="background-color: #f7fdff; border-left: 3px solid #00d2ff;">
  <td style="padding: 10px;">
    <label style="font-weight: 600; color: #2c3e50; margin-bottom: 0;"><strong>Partially Paid Amount:</strong></label>
  </td>
  <td class="" style="padding: 10px;">
    <div style="display: flex; justify-content: space-between;">
      <input type="number" id="partially_paid_amount" class="form-control" style="max-width: 200px; background-color: #e8f5e9; border: 1px solid #e0e0e0; border-radius: 4px; box-shadow: inset 0 1px 2px rgba(0,0,0,0.05);">
      <button type="button" class="btn btn-primary btn-sm" onclick="distributePartialAmount()" style="background-color: #3a7bd5; border-color: #3a7bd5; box-shadow: 0 2px 4px rgba(0,0,0,0.1);">Distribute</button>
    </div>
  </td>
</tr>

       <tr>
    <td colspan="2">
        <div style="display: flex; justify-content: space-between; flex-wrap: wrap;">
            <div style="flex: 1; min-width: 200px;">
                <b><?php echo $this->lang->line('total') . ' Discount '; ?>:</b>  
                <span id="total-discount-pay">
                    <?php echo $currency_symbol . number_format((float) 0, 2, '.', ''); ?>
                </span>
            </div>
            <div style="flex: 1; min-width: 200px;">
                <b><?php echo $this->lang->line('total') . ' Fine '; ?>:</b>  
                <span id="total-fine-pay">
                    <?php echo $currency_symbol . number_format((float) 0, 2, '.', ''); ?>
                </span>
            </div>
        </div>
    </td>
</tr>

<tr>
    <td colspan="2">
        <div style="display: flex; justify-content: space-between; flex-wrap: wrap;">
            <div style="flex: 1; min-width: 200px;">
                <b><?php echo $this->lang->line('total') . ' Amount ' . $this->lang->line('pay'); ?>:</b>  
                <span id="total-amount-pay">
                    <?php echo $currency_symbol . number_format((float) 0, 2, '.', ''); ?>
                </span>
            </div>
            <div style="flex: 1; min-width: 200px; margin-left:50px;">
                <b><?php echo $this->lang->line('Grant') . ' Grand Total ' . $this->lang->line('Amount'); ?>:</b>  
                <span id="grant-total-amount">
                    <?php echo $currency_symbol . number_format((float) 0, 2, '.', ''); ?>
                </span>
            </div>
            <div style="text-align: right;">
    <button type="submit" class="btn btn-primary payment_collect" data-loading-text="<i class='fa fa-spinner fa-spin '></i><?php echo $this->lang->line('processing')?>"><i class="fa fa-money"></i> <?php echo $this->lang->line('pay')." & ".$this->lang->line('print'); ?></button>
  </div>
</div>
        </div>
    </td>
</tr>

        
        
    </tbody>
</table>

</div>

<div class="row fees-footer">
    <div class="col-md-12">
  <!--     <button type="submit" class="btn btn-primary pull-right payment_collect" data-loading-text="<i class='fab fa-whatsapp '></i><?php echo $this->lang->line('processing')?>"><i class="fa fa-money"></i> <?php echo $this->lang->line('pay')." & ".$this->lang->line('print'); ?></button>-->
     
  <!--    <br><br>-->
  <!--    <button class="whatsapp-button" onclick="window.location.href='https://wa.me/your-phonenumber';">-->
  <!--  <i class="fab fa-whatsapp"></i> Open in WhatsApp-->
  <!--</button>-->
    </div>
    <!--<div class="col-md-12">-->
       
    <!--</div>-->
    
</div>
<?php }else{
    ?>
    <div class="row">
    <div class="col-md-12">
<div class="alert alert-info">
    <?php echo $this->lang->line('no_fees_found'); ?>
</div>
</div>
    <?php
}

 ?>
 
 <script>
     
    
    
   
// Function to gather all table data
function gatherTableData() {
    let tableData = {};
    let jsArray_unique_fee_type = <?php echo json_encode($unique_fee_type_all_fee); ?>;
    let jsArray = <?php echo json_encode($masterArray); ?>;
    let jsArray2 = <?php echo json_encode($masterArray2); ?>;

    // Loop through `jsArray` to access each month and gather its data
    for (let month in jsArray) {
        if (jsArray.hasOwnProperty(month)) {
            tableData[month] = {};

            // Loop through additional data from `jsArray2`
            if (jsArray2[month]) {
                tableData[month]['fee_group_count'] = jsArray2[month]['fee_group_count'] || '';//Number(jsArray2[month]['fee_group_count']['value']) || '';
                tableData[month]['fee_receipt_no_id'] = jsArray2[month]['fee_receipt_no_id'] || '';//Number(jsArray2[month]['fee_receipt_no_id']['value']) || '';
                tableData[month]['student_fees_master_id'] = jsArray2[month]['student_fees_master_id'] || '';//Number(jsArray2[month]['student_fees_master_id']['value']) || '';
                tableData[month]['fee_groups_feetype_id'] = jsArray2[month]['fee_groups_feetype_id'] || '';//Number(jsArray2[month]['fee_groups_feetype_id']['value']) || '';
                tableData[month]['fee_session_groups_id'] = jsArray2[month]['fee_session_groups_id'] || '';//Number(jsArray2[month]['fee_session_groups_id']['value']) || '';
                tableData[month]['thf'] = jsArray2[month]['thf'] || '';//Number(jsArray2[month]['thf']['value']) || '';
            }

            // Loop through each fee type and add its data to the month
            jsArray_unique_fee_type.forEach((feeType) => {
                // Only add to totals if the fee type is not one of the excluded types
    if (feeType != "Fine" && feeType != "Discount" && feeType != "Totals" && feeType != "TUITION FEE") {
     // Initialize fee type as an object
                    tableData[month][feeType] = {};
                // Get the element by ID
                let element = document.getElementById(`${feeType}-${month}`);
                
                // Check if the element exists; if it doesn't, set to 0
                tableData[month][feeType]['amount'] = element ? parseFloat(element.value) || 0 : 0; //innerText
                
                // Get the element by ID
                let element2 = document.getElementById(`${feeType}-${month}-hidden`);
                
                // Check if the element exists; if it doesn't, set to 0
                tableData[month][feeType]['total_amount'] = element2 ? parseFloat(element2.value) || 0 : 0; //innerText
    }
            });

            // Add additional data fields for each month
            tableData[month]['fine'] = parseFloat(document.getElementById(`fine-${month}`)?.value) || 0;
            tableData[month]['discount'] = parseFloat(document.getElementById(`discount-${month}`)?.value) || 0;
            tableData[month]['received'] = parseFloat(document.getElementById(`received-${month}`)?.value) || 0;
            tableData[month]['total'] = parseFloat(document.getElementById(`total-${month}`)?.innerText) || 0;
            //tableData[month]['balance'] = parseFloat(document.getElementById(`balance-${month}`)?.innerText) || 0;
        }
    }

    // Store the JSON data in the hidden input before form submission
    document.getElementById('tableData').value = JSON.stringify(tableData);
}



// Attach event to form submission
// document.getElementById('collect_fee_group').onsubmit = function() {
//     gatherTableData(); // Gather data and store in hidden input before submitting the form
// };

</script>
 
 <script>
$(document).ready(function() {
    // Function to convert PHP date format to jQuery UI datepicker format
    function convertToJQueryDateFormat(format) {
        return format.replace('d', 'dd')
                     .replace('m', 'mm')
                     .replace('Y', 'yy')
                     .replace('M', 'M');  // Converts month to abbreviated name if needed
    }

    // Get the initial date format from the select dropdown
    var initialFormat = '<?php echo $this->customlib->getSchoolDateFormat(); ?>';//$('#date_format').val();
    
    // Initialize datepicker with the initial format
    $("#date_1").datepicker({
        dateFormat: convertToJQueryDateFormat(initialFormat)
    });

    // Change the date format when the dropdown selection changes
    // $('#date_format').change(function() {
    //     var selectedFormat = $(this).val();
    //     $("#date_1").datepicker('option', 'dateFormat', convertToJQueryDateFormat(selectedFormat));
        
    //     // Optionally, you could clear the date to prompt a new selection in the new format
    //     $("#date_1").val('');
    // });
});
</script>