????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................<?php
include('session.php');
include 'connection.php';

$admission_no = mysqli_real_escape_string($conn, $_POST['admission_no']);
$student_name = mysqli_real_escape_string($conn, $_POST['student_name']);
$fathers_name = mysqli_real_escape_string($conn, $_POST['fathers_name']);
$mobile_no = mysqli_real_escape_string($conn, $_POST['mobile_no']);
$course_name = mysqli_real_escape_string($conn, $_POST['course_name']);
$total_fee = floatval($_POST['total_fee']);
$due_amount = floatval($_POST['due_amount']); // This is the calculated due amount from frontend
$paid_amount = floatval($_POST['paid_amount']);
$mr_no = mysqli_real_escape_string($conn, $_POST['mr_no']);
$transaction_id = mysqli_real_escape_string($conn, $_POST['transaction_id']);
$payment_date = mysqli_real_escape_string($conn, $_POST['payment_date']);
$received_amount = floatval($_POST['received_amount']);
$bank_upi = mysqli_real_escape_string($conn, $_POST['bank_upi']);
$addedby = $_SESSION['uid'];

// Insert fee record
$sql = "INSERT INTO fees (
    admission_no, student_name, fathers_name, mobile_no, course_name, total_fee, due_amount, paid_amount, mr_no, transaction_id, payment_date, received_amount, bank_upi, addedby
) VALUES (
    '$admission_no','$student_name','$fathers_name','$mobile_no','$course_name','$total_fee','$due_amount','$paid_amount','$mr_no','$transaction_id','$payment_date','$received_amount','$bank_upi','$addedby'
)";

if ($conn->query($sql) === TRUE) {
    // Update MR counter
    $update_counter_sql = "UPDATE mr_counter SET counter = counter + 1 WHERE id = 1";
    if (mysqli_query($conn, $update_counter_sql)) {
        echo "<script>
            alert('Fee record added successfully.');
            window.location.href = 'fee.php';
        </script>";
    } else {
        echo "<script>
            alert('Fee added, but failed to update MR counter.');
            window.location.href = 'fee.php';
        </script>";
    }
} else {
    echo "<script>
        alert('Error adding fee record: " . addslashes($conn->error) . "');
        window.history.back();
    </script>";
}
?>