﻿﻿??????????????
﻿﻿??????????????
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include('session.php');
?>

<?php

include 'connection.php';

if (isset($_GET['idk'])) {
    $delsql = "DELETE FROM admission WHERE id=" . $_GET['idk'];
    $conn->query($delsql);
    exit;
}

?>

<?php
// Username is root
$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['userid']);
$sql10 = "SELECT * FROM admission WHERE addedby = '$userId' ORDER BY id DESC";
$result10 = $mysqli->query($sql10);


// $mysqli->close(); 
$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>Admission Form | XCEL</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;
        }
    </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">Admission Form</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                        <form action="insert_admission.php" method="post" enctype="multipart/form-data">

                                            <!-- Personal Details Section -->
                                            <div class="row">
                                                <div class="col-12">
                                                    <h5 class="card-title text-primary mb-3">Personal Details</h5>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Student Name *</label>
                                                        <input type="text" class="form-control" placeholder="Student Name"                                                                          name="student_name" id="student_name" required>
                                                        <div id="student-suggestions" class="list-group position-absolute" style="z-                                                                  index: 1000; display: none;"></div>
                                                    </div>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Date of Birth</label>
                                                        <input type="date" class="form-control" name="dob" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Father's Name</label>
                                                        <input type="text" class="form-control" placeholder="Father's Name"                                                                        name="fathers_name" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Blood Group</label>
                                                        <select class="form-control" name="blood_group" required>
                                                            <option value="">Select Blood Group</option>
                                                            <option value="A+">A+</option>
                                                            <option value="A-">A-</option>
                                                            <option value="B+">B+</option>
                                                            <option value="B-">B-</option>
                                                            <option value="AB+">AB+</option>
                                                            <option value="AB-">AB-</option>
                                                            <option value="O+">O+</option>
                                                            <option value="O-">O-</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Nationality</label>
                                                        <input type="text" class="form-control" placeholder="Nationality"                                                                          name="nationality" value="Indian" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Marital Status</label>
                                                        <select class="form-control" name="marital_status" required>
                                                            <option value="">Select Status</option>
                                                            <option value="Single">Single</option>
                                                            <option value="Married">Married</option>
                                                            <option value="Divorced">Divorced</option>
                                                            <option value="Widowed">Widowed</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Qualification</label>
                                                        <input type="text" class="form-control" placeholder="Qualification"                                                                        name="qualification" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Aadhar No</label>
                                                        <input type="text" class="form-control" placeholder="Aadhar No"                                                                            name="aadhar_no" maxlength="12" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Language</label>
                                                        <input type="text" class="form-control" placeholder="Language"                                                                              name="language" required>
                                                    </div>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Student Photo:</label>
                                                        <input type="file" class="form-control" name="photo"                                                                                        accept=".jpg,.jpeg,.png" required>
                                                    </div>
                                                </div>


                                            </div>

                                            <!-- Contact Details Section -->
                                            <div class="row mt-4">
                                                <div class="col-12">
                                                    <h5 class="card-title text-primary mb-3">Contact Details</h5>
                                                </div>

                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Present Address</label>
                                                        <textarea class="form-control" placeholder="Present Address"                                                                                   name="present_address" rows="3" required></textarea>
                                                    </div>
                                                </div>
                                                <div class="col-xl-6">
                                                    <div class="form-group">
                                                        <label class="form-label">Permanent Address</label>
                                                        <textarea class="form-control" placeholder="Permanent Address"                                                                                 name="permanent_address" rows="3" required></textarea>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Roll No</label>
                                                        <input type="text" class="form-control" placeholder="Roll No" name="trade"                                                                  required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Mobile No (Personal)</label>
                                                        <input type="text" class="form-control" placeholder="Personal Contact"                                                                      name="contact_personal" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Contact No (Home)</label>
                                                        <input type="text" class="form-control" placeholder="Home Contact"                                                                          name="contact_home" required>
                                                    </div>
                                                </div>
                                                <div class="col-xl-3">
                                                    <div class="form-group">
                                                        <label class="form-label">Email ID</label>
                                                        <input type="email" class="form-control" placeholder="Email ID"                                                                            name="email_id" required>
                                                    </div>
                                                </div>
                                            </div>

                                            <!-- Course Details Section -->
                                            <div class="row mt-4">
                                                <div class="col-12">
                                                    <h5 class="card-title text-primary mb-3">Course Details</h5>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Course *</label>
                                                        <input type="text" class="form-control" placeholder="Course" name="course"                                                                  id="course" required>
                                                        <div id="course-suggestions" class="list-group position-absolute" style="z-                                                              index: 1000; display: none;"></div>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Duration</label>
                                                        <input type="text" class="form-control" placeholder="Duration"                                                                              name="duration" id="duration">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Course Fee Amount</label>
                                                        <input type="number" class="form-control" placeholder="Course Fee Amount"                                                                  name="course_fee_amount" id="course_fee_amount" step="0.01">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Discount</label>
                                                        <input type="number" class="form-control" placeholder="Discount"                                                                            name="discount" id="discount" step="0.01" value="0">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Payable Amount</label>
                                                        <input type="number" class="form-control" placeholder="Payable Amount"                                                                      name="payable_amount" id="payable_amount" step="0.01" readonly>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-group text-right">
                                                <button type="submit" class="float-end "><img src="assets/save1.png" title="Save"                                                           style="height: 30px; width: 30px;"></button>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>




                        <div class="col-md-12">
                            <div class="card shadow">
                                <div class="card-header">
                                    <h4 class="card-title">Admission Records</h4>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table id="example1" class="display nowrap">
                                            <thead>
                                                <tr>
                                                    <th>SL No</th>
                                                    <th>Admission No</th>
                                                    <th>Student Name</th>
                                                    <th>Course</th>
                                                    <th>Duration</th>
                                                    <th>Course Fee</th>
                                                    <th>Payable Amount</th>
                                                    <th>Contact</th>
                                                    <th>Action</th>

                                                </tr>
                                            </thead>
                                            <tbody>

                                                <?php   // LOOP TILL END OF DATA 
                                                while ($rows10 = $result10->fetch_assoc()) {
                                                ?>
                                                    <tr id="<?php echo $rows10['id']; ?>">
                                                        <td><?php echo ++$a ?></td>
                                                        <td><?php echo $rows10['admission_no']; ?></td>
                                                        <td><?php echo $rows10['student_name']; ?></td>
                                                        <td><?php echo $rows10['course']; ?></td>
                                                        <td><?php echo $rows10['duration']; ?></td>
                                                        <td><?php echo number_format($rows10['course_fee_amount'], 2); ?></td>
                                                        <td><?php echo number_format($rows10['payable_amount'], 2); ?></td>
                                                        <td><?php echo $rows10['contact_personal']; ?></td>
                                                        <td>
                                                            <a class="mr-4 check" href="update-admission.php?idk=<?php echo                                                                        $rows10['id']; ?>" title="UPDATE">
                                                                <span class="fas fa-edit"></span>
                                                            </a>

                                                            <a class="mr-4 check" href="admission-receipt.php?admission_no=<?php                                                                    echo urlencode($rows10['admission_no']); ?>" target="_blank"                                                                        title="View">
                                                                <span class='fas fa-eye'></span>
                                                            </a>



                                                            <a class='remove'>
                                                                <span class='fas fa-trash-alt'></span>
                                                            </a>
                                                        </td>
                                                    </tr>

                                                <?php } ?>


                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>




                    </div>

                </div>
            </div>
        </div>
        <!-- End section content -->

        <?php
        include('footer.php');
        ?>


    </div>


    <script type="text/javascript">
        $(".remove").click(function() {
            var idk = $(this).parents("tr").attr("id");
            console.log(idk);

            if (confirm('Are you sure to remove this record ?')) {
                $.get("admission.php?idk=" + idk, function(data, status) {
                    $("#" + idk).remove();
                    alert("Record removed successfully");
                });

            }
        });

        // Course autocomplete functionality
        $('#course').on('input', function() {
            var query = $(this).val();
            if (query.length > 1) {
                $.ajax({
                    url: 'get_courses.php',
                    method: 'POST',
                    data: {
                        query: query
                    },
                    success: function(data) {
                        $('#course-suggestions').html(data).show();
                    }
                });
            } else {
                $('#course-suggestions').hide();
            }
        });

        // Handle course selection
        $(document).on('click', '.course-suggestion', function() {
            var courseName = $(this).data('course');
            var duration = $(this).data('duration');
            var amount = $(this).data('amount');

            $('#course').val(courseName);
            $('#duration').val(duration);
            $('#course_fee_amount').val(amount);
            $('#course-suggestions').hide();

            // Calculate payable amount
            calculatePayableAmount();
        });

        // Calculate payable amount when discount changes
        $('#discount, #course_fee_amount').on('input', function() {
            calculatePayableAmount();
        });

        function calculatePayableAmount() {
            var courseFee = parseFloat($('#course_fee_amount').val()) || 0;
            var discount = parseFloat($('#discount').val()) || 0;
            var payableAmount = courseFee - discount;

            if (payableAmount < 0) {
                payableAmount = 0;
            }

            $('#payable_amount').val(payableAmount.toFixed(2));
        }

        // Hide suggestions when clicking outside
        $(document).click(function(e) {
            if (!$(e.target).closest('#course, #course-suggestions').length) {
                $('#course-suggestions').hide();
            }
        });
    </script>


    <script>
        // Add this JavaScript after your existing scripts
        $('#student_name').on('input', function() {
            var query = $(this).val();
            if (query.length > 2) {
                $.ajax({
                    url: 'get_enquiry.php',
                    method: 'POST',
                    data: {
                        query: query
                    },
                    success: function(data) {
                        $('#student-suggestions').html(data).show();
                    }
                });
            } else {
                $('#student-suggestions').hide();
            }
        });

        $(document).on('click', '.student-suggestion', function() {
            var data = $(this).data();

            // Fill in all the fields with proper selectors
            $('#student_name').val(data.name);
            $('input[name="dob"]').val(data.dob);
            $('input[name="fathers_name"]').val(data.fathers_name);
            $('select[name="blood_group"]').val(data.blood_group);
            $('select[name="marital_status"]').val(data.marital_status);
            $('input[name="qualification"]').val(data.qualification);
            $('input[name="aadhar_no"]').val(data.aadhar_no);
            $('textarea[name="present_address"]').val(data.address);
            $('input[name="contact_personal"]').val(data.mobile);
            $('input[name="email_id"]').val(data.email);
            $('#course').val(data.course);

            // Handle the photo field
            $('input[name="photo"]').prop('required', true);
			
            // Trigger course selection to update related fields
            if (data.course) {
                $('#course').trigger('input');
            }

            $('#student-suggestions').hide();
        });


        // Hide suggestions when clicking outside
        $(document).click(function(e) {
            if (!$(e.target).closest('#course, #student-suggestions').length) {
                $('#student-suggestions').hide();
            }
        });

        // Hide suggestions when clicking outside
        $(document).click(function(e) {
            if (!$(e.target).closest('#course, #course-suggestions').length) {
                $('#course-suggestions').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>