????????????????????
??????????????????
ÿØÿà
 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';


if(isset($_GET['idk']))
{
     $delsql = "DELETE FROM fees WHERE id=".$_GET['idk'];
     $conn->query($delsql);
      exit;
}

// Fetch MR No from mr_counter column
$mrCounterRes = $conn->query("SELECT counter FROM mr_counter WHERE id=1");
$mrCounterRow = $mrCounterRes->fetch_assoc();
$nextMrNo = str_pad($mrCounterRow['counter'] + 1, 3, '0', STR_PAD_LEFT);

// Fetch fee records
// $userId = $_SESSION['uid'];
// $sql = "SELECT * FROM fees WHERE addedby = '$userId' ORDER BY id DESC";
// $result = $conn->query($sql);
// $a = 0;



$user = 'xceljsr_db';
$password = 'xcel@123#$';
$database = 'xceljsr_db';
$servername = 'localhost';
$mysqli = new mysqli($servername, $user, 
                $password, $database);
  
// Checking for connections
if ($mysqli->connect_error) {
    die('Connect Error (' . 
    $mysqli->connect_errno . ') '. 
    $mysqli->connect_error);
}
  


// Use the userid (username) directly from session
$userId = mysqli_real_escape_string($mysqli, $_SESSION['uid']);
$sql10 = "SELECT * FROM fees WHERE addedby = '$userId' ORDER BY id DESC";
$result10 = $mysqli->query($sql10);

$a = 0;
?>

 



<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Add Customers | Xcel Training Institute</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../images/logo-wide.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
    <script src="https://code.jquery.com/jquery-3.6.4.min.js" integrity="sha256-oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl+cbzUq8=" crossorigin="anonymous"></script>
    <style>
    .btn{
            background-color: red;
            border: none;
            color: white;
            padding: 5px 5px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            font-size: 20px;
            margin: 4px 2px;
            cursor: pointer;
            border-radius: 20px;
        }
        .green{
            background-color: #199319;
        }
        .red{
            background-color: red;
        }

        .suggestion-list { border:1px solid #ccc; background:#fff; position:absolute; z-index:1000; width:100%; display:none; }
        .suggestion-item { padding:5px; cursor:pointer; }
        .suggestion-item:hover { background:#f0f0f0; }
        </style>
</head>

<body>
    <div id="main-wrapper" class="show">


      <?php
         include "sidebar.php";
         ?>


         <?php
         include "header.php";
         ?>


          <div class="content-body">
            <div class="warper container-fluid">
                <div class="new-patients main_container">
                    
       <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">Create Fee Receipt</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                       
                                    <form action="insert_fee_new.php" method="post">

                                    <!-- Admission No -->
                                    <div class="form-group position-relative col-xl-4">
                                        <label class="form-label">Admission No</label>
                                        <input type="text" class="form-control" id="admission_no" name="admission_no" autocomplete="off">
                                        <div id="admission_list" class="suggestion-list"></div>
                                    </div>

                                    <h5>Student Details</h5>
                                    <div class="row">
                                        <div class="col-xl-4">
                                            <label>Student Name</label>
                                            <input type="text" class="form-control" name="student_name" id="student_name" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Father's Name</label>
                                            <input type="text" class="form-control" name="fathers_name" id="fathers_name" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Mobile No</label>
                                            <input type="text" class="form-control" name="mobile_no" id="mobile_no" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Course Name</label>
                                            <input type="text" class="form-control" name="course_name" id="course_name" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Total Fee</label>
                                            <input type="text" class="form-control" name="total_fee" id="total_fee" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Due Amount</label>
                                            <input type="text" class="form-control" name="due_amount" id="due_amount" readonly>
                                            <input type="hidden" id="original_due_amount"> <!-- Hidden field to store original due -->
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Paid Amount</label>
                                            <input type="text" class="form-control" name="paid_amount" id="paid_amount" readonly>
                                        </div>
                                    </div>

                                    <h5 class="mt-3">Payment Details</h5>
                                    <div class="row">
                                        <div class="col-xl-4">
                                            <label>MR No</label>
                                            <input type="text" class="form-control" name="mr_no" value="<?php echo $nextMrNo; ?>" readonly>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Transaction ID</label>
                                            <input type="text" class="form-control" name="transaction_id">
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Date</label>
                                            <input type="date" class="form-control" name="payment_date" value="<?php echo date('Y-m-d'); ?>">
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Received Amount</label>
                                            <input type="text" class="form-control" name="received_amount" id="received_amount">
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Bank/UPI</label>
                                            <input type="text" class="form-control" name="bank_upi">
                                        </div>
                                    </div>

                                    <div class="form-group text-right mt-3">
                                        <button type="submit" class="btn btn-primary">Save Fee</button>
                                    </div>
                                </form>
                                    </div>
                                </div>
                            </div>
                        </div>


                      

                         <div class="col-md-12">
                            <div class="card shadow">
                                <div class="card-header">
                                    <h4 class="card-title">Customers </h4>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table id="example1" class="display nowrap">
                                            <thead>
                                                <tr>
                                                    <th>S.No.</th>
													<th>MR No</th>
                                                    <th>Admission No</th>
                                                    <th>Student Name</th>
                                                    <th>Paid Amount</th>
                                                    <th>Date</th>
                                                    <th>Action</th>
                                                     
													
                                                </tr>
                                            </thead>
                                            <tbody>
                                    <?php while($row = $result10->fetch_assoc()) { ?>
                                        <tr>
                                            <tr id="<?php echo $rows['id'];?>">
                                                <td><?php echo ++$a ?></td>
                                            <td><?php echo $row['mr_no']; ?></td>
                                            <td><?php echo $row['admission_no']; ?></td>
                                            <td><?php echo $row['student_name']; ?></td>
                                            <td><?php echo $row['paid_amount']; ?></td>
                                            <td><?php echo $row['payment_date']; ?></td>
                                            <td>
                                                            <a class="mr-4 check" href="edit-fee.php?id=<?php echo $row['id']; ?>" title="UPDATE">
    <span class="fas fa-edit"></span>
</a>

                                                       
                                                       <a href="javascript:void(0);" 
   class="remove" 
   data-id="<?php echo $row['id']; ?>">
    <span class="fas fa-trash-alt"></span>
</a>


<a class="mr-4 check" href="fee-receipt.php?id=<?php echo $row['id']; ?>" title="View Receipt">
    <span class="fas fa-receipt"></span>
</a>


                                                    </td>
                                        </tr>
                                    <?php } ?>
                                    </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>




                    </div>
                    
                </div>
            </div>
        </div>
        <!-- End section content -->

        <?php
   include('footer.php');
?>


    </div>
  

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).on("click", ".remove", function(){
    var id = $(this).data("id");
    var row = $(this).closest("tr"); // Assuming your fees are in a table row

    if(confirm("Are you sure you want to delete this fee record?")){
        $.ajax({
            url: "delete-fee.php",
            type: "POST",
            data: { id: id },
            success: function(response){
                alert(response);
                row.fadeOut(500, function(){
                    $(this).remove();
                });
            },
            error: function(){
                alert("Error deleting record. Please try again.");
            }
        });
    }
});
</script>




 <script>
$(document).ready(function(){
    $("#admission_no").keyup(function(){
        var query = $(this).val();
        if(query != ''){
            $.post("search_admission.php", {query:query}, function(data){
                $("#admission_list").html(data).fadeIn();
            });
        } else {
            $("#admission_list").fadeOut();
        }
    });

    $(document).on('click', '.admission_item', function(){
        var admission_no = $(this).data('no');
        $.post("search_admission.php", {admission_no:admission_no}, function(data){
            var student = JSON.parse(data);
            $("#admission_no").val(student.admission_no);
            $("#student_name").val(student.student_name);
            $("#fathers_name").val(student.fathers_name);
            $("#mobile_no").val(student.contact_personal);
            $("#course_name").val(student.course);
            $("#total_fee").val(student.payable_amount);
            $("#admission_list").fadeOut();
            
            // Fetch account details for this admission
            fetchAccountDetails(admission_no, student);
        });
    });

    // Handle when user types admission number directly
    $("#admission_no").blur(function(){
        var admission_no = $(this).val().trim();
        if(admission_no != '' && !$("#student_name").val()){
            // Only fetch if admission_no is entered but student details are not already loaded
            $.post("search_admission.php", {admission_no: admission_no}, function(data){
                try {
                    var student = JSON.parse(data);
                    if(student && student.admission_no){
                        $("#student_name").val(student.student_name);
                        $("#fathers_name").val(student.fathers_name);
                        $("#mobile_no").val(student.contact_personal);
                        $("#course_name").val(student.course);
                        $("#total_fee").val(student.payable_amount);
                        
                        // Fetch account details
                        fetchAccountDetails(admission_no, student);
                    } else {
                        alert('No student found with this admission number.');
                        clearStudentDetails();
                    }
                } catch (e) {
                    alert('Error fetching student details.');
                    clearStudentDetails();
                }
            }).fail(function() {
                alert('Error fetching student details.');
                clearStudentDetails();
            });
        }
    });

    // Function to fetch account details
    function fetchAccountDetails(admission_no, student) {
        console.log('=== FETCH ACCOUNT DETAILS DEBUG ===');
        console.log('Admission No:', admission_no);
        console.log('Student payable_amount:', student.payable_amount);
        
        var totalFee = parseFloat(student.payable_amount) || 0;
        console.log('Parsed total fee:', totalFee);
        
        $.post("fetch_account_details.php", {admission_no: admission_no}, function(response){
            console.log('=== RAW AJAX RESPONSE ===');
            console.log('Response:', response);
            console.log('Response type:', typeof response);
            
            var result;
            
            // Check if response is already an object (jQuery auto-parsed JSON)
            if (typeof response === 'object') {
                console.log('Response is already an object (auto-parsed by jQuery)');
                result = response;
            } else {
                // Try to parse as JSON
                try {
                    result = JSON.parse(response);
                } catch (e) {
                    console.error('=== JSON PARSE ERROR ===');
                    console.error('Error:', e);
                    console.error('Raw response that caused error:', response);
                    
                    // Fallback: use total fee
                    $("#due_amount").val(totalFee.toFixed(2));
                    $("#original_due_amount").val(totalFee.toFixed(2));
                    $("#paid_amount").val('0.00');
                    $("#received_amount").val('');
                    return;
                }
            }
            
            console.log('=== PARSED JSON RESPONSE ===');
            console.log('Full result:', result);
            console.log('result.found:', result.found);
            console.log('result.data:', result.data);
            
            var initialDueAmount;
            var currentPaid = 0;

                if(result.found === true && result.data) {
                    console.log('=== ACCOUNT DATA FOUND ===');
                    console.log('result.data.due_amount:', result.data.due_amount);
                    console.log('result.data.paid_amount:', result.data.paid_amount);
                    
                    // Account data found - use from accounts table
                    initialDueAmount = parseFloat(result.data.due_amount) || 0;
                    currentPaid = parseFloat(result.data.paid_amount) || 0;
                    console.log('Parsed due amount:', initialDueAmount);
                    console.log('Parsed paid amount:', currentPaid);
                    
                } else {
                    console.log('=== NO ACCOUNT DATA - USING TOTAL FEE ===');
                    console.log('Why no account data? found:', result.found, 'data:', result.data);
                    
                    // No account data - use total fee as due amount
                    initialDueAmount = totalFee;
                    currentPaid = 0;
                    console.log('Using total fee as due amount:', initialDueAmount);
                }

                console.log('=== SETTING FORM VALUES ===');
                console.log('Setting due_amount to:', initialDueAmount.toFixed(2));
                console.log('Setting paid_amount to:', currentPaid.toFixed(2));

                $("#due_amount").val(initialDueAmount.toFixed(2));
                $("#original_due_amount").val(initialDueAmount.toFixed(2));
                $("#paid_amount").val(currentPaid.toFixed(2));
                $("#received_amount").val('');
                
                console.log('=== FORM VALUES AFTER SETTING ===');
                console.log('due_amount field value:', $("#due_amount").val());
                console.log('paid_amount field value:', $("#paid_amount").val());
        }).fail(function(xhr, status, error) {
            console.error('=== AJAX REQUEST FAILED ===');
            console.error('Status:', status);
            console.error('Error:', error);
            console.error('Response text:', xhr.responseText);
            
            // Fallback: use total fee
            $("#due_amount").val(totalFee.toFixed(2));
            $("#original_due_amount").val(totalFee.toFixed(2));
            $("#paid_amount").val('0.00');
            $("#received_amount").val('');
        });
    }

    // Function to clear student details
    function clearStudentDetails() {
        $("#student_name").val('');
        $("#fathers_name").val('');
        $("#mobile_no").val('');
        $("#course_name").val('');
        $("#total_fee").val('');
        $("#due_amount").val('');
        $("#paid_amount").val('');
        $("#received_amount").val('');
        $("#original_due_amount").val('');
    }

    // Calculate amounts when received amount changes
    $("#received_amount").on('input', function(){
        var receivedAmount = parseFloat($(this).val()) || 0;
        var totalFee = parseFloat($("#total_fee").val()) || 0;
        var originalDueAmount = parseFloat($("#original_due_amount").val()) || 0;

        // Calculate new due amount: Original Due - Received Amount
        var newDueAmount = originalDueAmount - receivedAmount;
        if (newDueAmount < 0) newDueAmount = 0; // Due amount cannot be negative

        $("#due_amount").val(newDueAmount.toFixed(2));

        // Calculate paid amount: Total Fee - New Due Amount
        var newPaidAmount = totalFee - newDueAmount;
        $("#paid_amount").val(newPaidAmount.toFixed(2));
    });
});
</script>

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Chart js -->
    <script src="assets/plugins/chart/chart/Chart.min.js"></script>
    <script src="assets/js/charts-custom.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>
</html>