????????????????????
??????????????????
ÿØÿà
 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';

// Fetch all fee records for admin view
$fees_sql = "SELECT * FROM fees ORDER BY id DESC";
$fees_res = $conn->query($fees_sql);
$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>Admin Fee |Xcel Training Institute</title>
    <link rel="icon" type="image/png" href="../images/logo-wide.png">
    <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" crossorigin="anonymous"></script>
    <style>
        .btn{ background-color:#007bff; border:none; color:#fff; padding:8px 12px; font-size:14px; border-radius:4px; cursor:pointer; }
        .btn-danger{ background-color:#dc3545; }
        .btn-secondary{ background-color:#6c757d; }
        .btn-primary{ background-color:#007bff; }
        .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; }
        .table-responsive { overflow-x:auto; }
        /* Make the grid look like a proper table */
        #adminFeesTable { width:100%; border-collapse: collapse; background:#fff; }
        #adminFeesTable th { background:#e9ecef; color:#090909; font-weight:600; padding:12px 8px; text-align:left; border:1px solid #adb0b3; font-size:14px; }
        #adminFeesTable td { padding:10px 8px; border:1px solid #dee2e6; vertical-align:middle; font-size:13px; }
        #adminFeesTable tbody tr:nth-child(even) { background:#f8f9fa; }
        #adminFeesTable tbody tr:hover { background:#e3f2fd; }
    </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 (Admin)</h4>
                            </div>
                            <div class="card-body">
                                <div class="basic-form">
                                    <form action="insert_fee.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" required>
                                            <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">
                                            </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>Receipt No (Manual)</label>
                                                <input type="text" class="form-control" name="mr_no" required>
                                            </div>

        
                                            <div class="col-xl-4">
                                                <label>Payment Mode</label>
                                                <select class="form-control" name="payment_mode" id="payment_mode">
                                                    <option value="">Select</option>
                                                    <option value="Cash">Cash</option>
                                                    <option value="Online">Online</option>
                                                    <option value="Check">Check</option>
                                                </select>
                                            </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>Transaction ID</label>
                                                <input type="text" class="form-control" name="transaction_id">
                                            </div>
                                            <div class="col-xl-4">
                                                <label>Bank/UPI</label>
                                                <input type="text" class="form-control" name="bank_upi">
                                            </div>
                                            <div class="col-xl-4">
                                                <label>Added By (Admin Name)</label>
                                                <input type="text" class="form-control" name="addedby" placeholder="Enter admin name" required>
                                            </div>
                                        </div>

                                        <div id="mr_no_error" style="color:#dc3545; display:none; margin-bottom:8px;">Receipt No already exists. Please use a different number.</div>
                                        <div class="form-group text-right mt-3">
                                            <button type="submit" class="btn btn-primary" id="saveBtn">Save Fee</button>
                                            <a href="fee.php" class="btn btn-secondary">Clear</a>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-12">
                        <div class="card shadow">
                            <div class="card-header">
                                <h4 class="card-title">All Fees</h4>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="adminFeesTable" class="display nowrap">
                                        <thead>
                                        <tr>
                                            <th>S.No.</th>
                                            <th>MR No</th>
                                            <th>Admission No</th>
                                            <th>Student Name</th>
                                            <th>Received Amount</th>
                                            <th>Date</th>
                                            <th>Payment Mode</th>
                                            <th>Added By</th>
                                            <th>Action</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        <?php if ($fees_res && $fees_res->num_rows > 0) { while($row = $fees_res->fetch_assoc()) { ?>
                                            <tr id="row_<?php echo (int)$row['id']; ?>">
                                                <td><?php echo ++$a; ?></td>
                                                <td><?php echo htmlspecialchars($row['mr_no'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['admission_no'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['student_name'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['received_amount'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['payment_date'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['payment_mode'] ?? ''); ?></td>
                                                <td><?php echo htmlspecialchars($row['addedby'] ?? ''); ?></td>
                                                <td>
                                                    <a class="mr-4 check" href="update-fee.php?id=<?php echo $row['id']; ?>" title="UPDATE">
    <span class="fas fa-edit"></span>
</a>
                                                    <a href="javascript:void(0);" class="mr-4 check remove" data-id="<?php echo (int)$row['id']; ?>">
                                                        <span class="fas fa-trash-alt" style="color:#dc3545;"></span>
                                                    </a>
                                                    <a class="mr-4 check" href="../fee-receipt.php?id=<?php echo (int)$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>

    <?php include('footer.php'); ?>
</div>

<script>
// Delete with account adjustments (admin)
$(document).on("click", ".remove", function(){
    var id = $(this).data("id");
    var row = $(this).closest("tr");
    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(400, function(){ $(this).remove(); });
            },
            error: function(){
                alert("Error deleting record. Please try again.");
            }
        });
    }
});

// Admission No autocomplete (reuse existing endpoint)
$(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.mobile_no);
            $("#course_name").val(student.course_name);
            $("#total_fee").val(student.total_fee);
            $("#due_amount").val(student.due_amount);
            $("#original_due_amount").val(student.due_amount);
            $("#paid_amount").val(student.paid_amount);
            $("#admission_list").fadeOut();
        });
    });

    // Client-side MR No uniqueness check
    var mrTimer = null;
    $(document).on('input', 'input[name="mr_no"]', function(){
        clearTimeout(mrTimer);
        var val = $(this).val().trim();
        if (!val) { $('#mr_no_error').hide(); $('#saveBtn').prop('disabled', false); return; }
        mrTimer = setTimeout(function(){
            $.get('check_mr_no.php', { mr_no: val }, function(resp){
                try { resp = (typeof resp === 'object') ? resp : JSON.parse(resp); } catch(e) { resp = { exists:false }; }
                if (resp.exists) {
                    $('#mr_no_error').show();
                    $('#saveBtn').prop('disabled', true);
                } else {
                    $('#mr_no_error').hide();
                    $('#saveBtn').prop('disabled', false);
                }
            }).fail(function(){
                // On failure, do not block submission
                $('#mr_no_error').hide();
                $('#saveBtn').prop('disabled', false);
            });
        }, 300);
    });
});
</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>