????????????????????
??????????????????
ÿØÿà
 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.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>
                                        </div>
                                        <div class="col-xl-4">
                                            <label>Paid Amount</label>
                                            <input type="text" class="form-control" name="paid_amount" id="paid_amount">
                                        </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 and set due amount
            fetchDueAmount(student.admission_no);
        });
    });
    
    // Also fetch due amount when admission no is typed directly
    $("#admission_no").blur(function(){
        var admission_no = $(this).val();
        if(admission_no != ''){
            fetchDueAmount(admission_no);
        }
    });
    
    // Calculate due amount when received amount changes
    $("#received_amount").on('input', function(){
        calculateDueAmount();
    });
    
    function fetchDueAmount(admission_no) {
        $.post("get_due_amount.php", {admission_no: admission_no}, function(response){
            var data = JSON.parse(response);
            $("#due_amount").val(data.due_amount);
            // Store original due amount for calculation
            $("#due_amount").data('original-due', data.due_amount);
            calculateDueAmount();
        });
    }
    
    function calculateDueAmount() {
        var originalDue = parseFloat($("#due_amount").data('original-due')) || 0;
        var receivedAmount = parseFloat($("#received_amount").val()) || 0;
        
        var newDueAmount = originalDue - receivedAmount;
        
        // Ensure due amount doesn't go below 0
        if (newDueAmount < 0) {
            newDueAmount = 0;
        }
        
        $("#due_amount").val(newDueAmount.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>