????????????????????
??????????????????
ÿØÿà
 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);

$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;


if (isset($_POST['amount'])) {
    $amount = $_POST['amount'];

    function convertNumberToWords($num) {
        $num = (int)$num;
        $ones = array(
            0 => "Zero", 1 => "One", 2 => "Two", 3 => "Three", 4 => "Four",
            5 => "Five", 6 => "Six", 7 => "Seven", 8 => "Eight", 9 => "Nine",
            10 => "Ten", 11 => "Eleven", 12 => "Twelve", 13 => "Thirteen",
            14 => "Fourteen", 15 => "Fifteen", 16 => "Sixteen",
            17 => "Seventeen", 18 => "Eighteen", 19 => "Nineteen"
        );
        $tens = array(
            0 => "", 1 => "Ten", 2 => "Twenty", 3 => "Thirty", 4 => "Forty",
            5 => "Fifty", 6 => "Sixty", 7 => "Seventy", 8 => "Eighty", 9 => "Ninety"
        );
        $thousands = array("", "Thousand", "Million", "Billion");

        if ($num == 0) return "Zero";

        $words = "";
        $i = 0;

        while ($num > 0) {
            $remainder = $num % 1000;
            if ($remainder != 0) {
                $str = "";
                if ($remainder >= 100) {
                    $str .= $ones[(int)($remainder / 100)] . " Hundred ";
                    $remainder %= 100;
                }
                if ($remainder >= 20) {
                    $str .= $tens[(int)($remainder / 10)] . " ";
                    $remainder %= 10;
                }
                if ($remainder > 0) {
                    $str .= $ones[$remainder] . " ";
                }
                $words = $str . $thousands[$i] . " " . $words;
            }
            $num = (int)($num / 1000);
            $i++;
        }

        return trim($words);
    }

    echo convertNumberToWords($amount);
    exit;
}



?>

<!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_create_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-3">
                                            <label>Course Name</label>
                                            <input type="text" class="form-control" name="course_name" id="course_name" readonly>
                                        </div>
                                        <div class="col-xl-3">
                                            <label>Total Fee</label>
                                            <input type="text" class="form-control" name="total_fee" id="total_fee" readonly>
                                        </div>
                                        <div class="col-xl-3">
                                            <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-3">
                                            <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</label>
                                            <input type="text" class="form-control" name="mr_no" value="<?php echo $nextMrNo; ?>" readonly>
                                        </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">
											<h6 id="amount_in_words" style="display:block;margin-top:5px;color:#555;font-style:italic;"></h6>
                                        </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>

                                    <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>Received Amount</th>
                                                    <th>Date</th>
                                                    <th>Action</th>


                                                </tr>
                                            </thead>
                                            <tbody>
                                    <?php while($row = $result10->fetch_assoc()) { ?>
                                        <tr>
                                            <tr id="<?php echo $row['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['received_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="mr-4 check 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" target="_blank">
    <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 due amount from accounts table or set to total fee
            $.post("create_fetch_account_details.php", {admission_no: admission_no}, function(account){ // Removed JSON.parse(accountData)
                var totalFee = parseFloat($("#total_fee").val()) || 0; // Use total_fee from the form
                var initialDueAmount;

                // Check if account.due_amount is a valid number (not null, undefined, or NaN)
                // Since create_fetch_account_details.php now always returns an object, we just check the value
                if(account.due_amount !== null && !isNaN(parseFloat(account.due_amount))){
                    initialDueAmount = parseFloat(account.due_amount);
                } else {
                    initialDueAmount = totalFee; // Assign total fees if not in accounts or due_amount is invalid/null
                }

                $("#due_amount").val(initialDueAmount.toFixed(2));
                $("#original_due_amount").val(initialDueAmount.toFixed(2)); // Set original due for calculations

                // Initialize paid amount based on total fee and initial due amount
                var currentPaid = totalFee - initialDueAmount;
                $("#paid_amount").val(currentPaid.toFixed(2));

                // Clear received amount when a new student is selected
                $("#received_amount").val('');
            });
        });
    });

    // Calculate Due Amount and Paid Amount dynamically 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; // Get the original due amount

        var newDueAmount = originalDueAmount - receivedAmount;
        if (newDueAmount < 0) newDueAmount = 0; // Due amount cannot be negative

        $("#due_amount").val(newDueAmount.toFixed(2));

        var newPaidAmount = totalFee - newDueAmount;
        $("#paid_amount").val(newPaidAmount.toFixed(2));
    });

    // Auto-fill Transaction ID and Bank/UPI when Payment Mode is Cash
    $("#payment_mode").on('change', function(){
        var mode = $(this).val();
        if(mode === 'Cash'){
            $("input[name='transaction_id']").val('NA');
            $("input[name='bank_upi']").val('NA');
        }
    });
});
</script>
	
	
	<script>
document.getElementById('received_amount').addEventListener('input', function() {
    let amount = this.value.trim();

    // Only send AJAX if numeric
    if (amount !== '' && !isNaN(amount)) {
        fetch('', { // same page
            method: 'POST',
            headers: {'Content-Type': 'application/x-www-form-urlencoded'},
            body: 'amount=' + encodeURIComponent(amount)
        })
        .then(response => response.text())
        .then(words => {
            document.getElementById('amount_in_words').textContent = words;
        });
    } else {
        document.getElementById('amount_in_words').textContent = '';
    }
});


// Hide suggestions when clicking outside
    $(document).click(function(e) {
        if (!$(e.target).closest('#course, #admission_list').length) {
            $('#admission_list').hide();
        }
    });


</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>
