????????????????????
??????????????????
ÿØÿà
 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');
?>


<!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>Update Admission || KTTC</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">
</head>

<body>
    <div id="main-wrapper" class="show">


        <?php
         include "sidebar.php";
         ?>


        <?php
         include "header1.php";
         ?>



        <!-- start section content -->
        <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">Update Admission Details</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                        <form action="" method="post" enctype="multipart/form-data">

                                            <?php

          include 'connection.php';

          $idd = $_REQUEST['idk'];
          
          $showquery = "select * from admission where id=$idd";

          $showdata = mysqli_query($conn, $showquery);


          $arrdata = mysqli_fetch_array($showdata);

         if(isset($_POST['submit'])){

        // Personal Details
        $student_name = mysqli_real_escape_string($conn, $_POST['student_name']);
        $dob = !empty($_POST['dob']) ? mysqli_real_escape_string($conn, $_POST['dob']) : NULL;
        $fathers_name = mysqli_real_escape_string($conn, $_POST['fathers_name']);
        $blood_group = mysqli_real_escape_string($conn, $_POST['blood_group']);
        $nationality = mysqli_real_escape_string($conn, $_POST['nationality']);
        $marital_status = mysqli_real_escape_string($conn, $_POST['marital_status']);
        $qualification = mysqli_real_escape_string($conn, $_POST['qualification']);
        $aadhar_no = mysqli_real_escape_string($conn, $_POST['aadhar_no']);
        $language = mysqli_real_escape_string($conn, $_POST['language']);
	    $photo = $_POST['old_photo'];
			 if(isset($_FILES['photo']) && $_FILES['photo']['error']==0){
				 $folder = "uploads/photos/";
				 if(!file_exists($folder)){
					 mkdir($folder,0777,true);
				 }
				 $ext = strtolower(pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION));
				 $newName = time().rand(1000,9999).".".$ext;
				 move_uploaded_file($_FILES['photo']['tmp_name'],$folder.$newName);
				 if(!empty($_POST['old_photo']) && file_exists($folder.$_POST['old_photo'])){
					 unlink($folder.$_POST['old_photo']);
				 }
				 $photo = $newName;
			 }

        // Contact Details
        $present_address = mysqli_real_escape_string($conn, $_POST['present_address']);
        $permanent_address = mysqli_real_escape_string($conn, $_POST['permanent_address']);
        $trade = mysqli_real_escape_string($conn, $_POST['trade']);
        $contact_personal = mysqli_real_escape_string($conn, $_POST['contact_personal']);
        $contact_home = mysqli_real_escape_string($conn, $_POST['contact_home']);
        $email_id = mysqli_real_escape_string($conn, $_POST['email_id']);

        // Course Details
        $course = mysqli_real_escape_string($conn, $_POST['course']);
        $duration = mysqli_real_escape_string($conn, $_POST['duration']);
        $course_fee_amount = !empty($_POST['course_fee_amount']) ? floatval($_POST['course_fee_amount']) : 0;
        $discount = !empty($_POST['discount']) ? floatval($_POST['discount']) : 0;
        $payable_amount = !empty($_POST['payable_amount']) ? floatval($_POST['payable_amount']) : 0;
                
        $query = "UPDATE admission SET 
                    student_name='$student_name', 
                    dob=" . ($dob ? "'$dob'" : "NULL") . ", 
                    fathers_name='$fathers_name', 
                    blood_group='$blood_group', 
                    nationality='$nationality', 
                    marital_status='$marital_status', 
                    qualification='$qualification', 
                    aadhar_no='$aadhar_no', 
                    language='$language', 
					photo='$photo',
                    present_address='$present_address', 
                    permanent_address='$permanent_address', 
                    trade='$trade', 
                    contact_personal='$contact_personal', 
                    contact_home='$contact_home', 
                    email_id='$email_id', 
                    course='$course', 
                    duration='$duration', 
                    course_fee_amount=$course_fee_amount, 
                    discount=$discount, 
                    payable_amount=$payable_amount 
                  WHERE id = $idd";

                $res = mysqli_query($conn, $query);
                
                if ($res) {
	?>
                                            <script>
                                            alert("Admission Updated Successfully...");
                                            window.location.href = "admission.php"
                                            </script>
                                            <?php
}
else {
	 echo "ERROR: Unable to execute query. " . mysqli_error($conn);
}
      }
                ?>


                                            <!-- 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">Admission No</label>
                                                        <input type="text" class="form-control"
                                                            value="<?php echo $arrdata['admission_no'];?>" readonly>
                                                    </div>
                                                </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"
                                                            value="<?php echo $arrdata['student_name'];?>" required>
                                                    </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"
                                                            value="<?php echo $arrdata['dob'];?>">
                                                    </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"
                                                            value="<?php echo $arrdata['fathers_name'];?>">
                                                    </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">
                                                            <option value="">Select Blood Group</option>
                                                            <option value="A+"
                                                                <?php echo ($arrdata['blood_group'] == 'A+') ? 'selected' : ''; ?>>
                                                                A+</option>
                                                            <option value="A-"
                                                                <?php echo ($arrdata['blood_group'] == 'A-') ? 'selected' : ''; ?>>
                                                                A-</option>
                                                            <option value="B+"
                                                                <?php echo ($arrdata['blood_group'] == 'B+') ? 'selected' : ''; ?>>
                                                                B+</option>
                                                            <option value="B-"
                                                                <?php echo ($arrdata['blood_group'] == 'B-') ? 'selected' : ''; ?>>
                                                                B-</option>
                                                            <option value="AB+"
                                                                <?php echo ($arrdata['blood_group'] == 'AB+') ? 'selected' : ''; ?>>
                                                                AB+</option>
                                                            <option value="AB-"
                                                                <?php echo ($arrdata['blood_group'] == 'AB-') ? 'selected' : ''; ?>>
                                                                AB-</option>
                                                            <option value="O+"
                                                                <?php echo ($arrdata['blood_group'] == 'O+') ? 'selected' : ''; ?>>
                                                                O+</option>
                                                            <option value="O-"
                                                                <?php echo ($arrdata['blood_group'] == 'O-') ? 'selected' : ''; ?>>
                                                                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="<?php echo $arrdata['nationality'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-2">
                                                    <div class="form-group">
                                                        <label class="form-label">Marital Status</label>
                                                        <select class="form-control" name="marital_status">
                                                            <option value="">Select Status</option>
                                                            <option value="Single"
                                                                <?php echo ($arrdata['marital_status'] == 'Single') ? 'selected' : ''; ?>>
                                                                Single</option>
                                                            <option value="Married"
                                                                <?php echo ($arrdata['marital_status'] == 'Married') ? 'selected' : ''; ?>>
                                                                Married</option>
                                                            <option value="Divorced"
                                                                <?php echo ($arrdata['marital_status'] == 'Divorced') ? 'selected' : ''; ?>>
                                                                Divorced</option>
                                                            <option value="Widowed"
                                                                <?php echo ($arrdata['marital_status'] == 'Widowed') ? 'selected' : ''; ?>>
                                                                Widowed</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Qualification</label>
                                                        <input type="text" class="form-control"
                                                            placeholder="Qualification" name="qualification"
                                                            value="<?php echo $arrdata['qualification'];?>">
                                                    </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" value="<?php echo $arrdata['aadhar_no'];?>"
                                                            maxlength="12">
                                                    </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" value="<?php echo $arrdata['language'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Student Photo</label>

                                                        <?php if(!empty($arrdata['photo'])){ ?>
                                                        <br>
                                                        <img src="uploads/photos/<?php echo $arrdata['photo']; ?>" width="120">
                                                        <br><br>
                                                        <?php } ?>

                                                        <input type="file" class="form-control" name="photo"
                                                            accept=".jpg,.jpeg,.png">

                                                        <input type="hidden" name="old_photo"
                                                            value="<?php echo $arrdata['photo']; ?>">
                                                    </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"><?php echo $arrdata['present_address'];?></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"><?php echo $arrdata['permanent_address'];?></textarea>
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Trade</label>
                                                        <input type="text" class="form-control" placeholder="Trade"
                                                            name="trade" value="<?php echo $arrdata['trade'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Contact No (Personal)</label>
                                                        <input type="text" class="form-control"
                                                            placeholder="Personal Contact" name="contact_personal"
                                                            value="<?php echo $arrdata['contact_personal'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Contact No (Home)</label>
                                                        <input type="text" class="form-control"
                                                            placeholder="Home Contact" name="contact_home"
                                                            value="<?php echo $arrdata['contact_home'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Email ID</label>
                                                        <input type="email" class="form-control" placeholder="Email ID"
                                                            name="email_id" value="<?php echo $arrdata['email_id'];?>">
                                                    </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"
                                                            value="<?php echo $arrdata['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"
                                                            value="<?php echo $arrdata['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"
                                                            value="<?php echo $arrdata['course_fee_amount'];?>">
                                                    </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="<?php echo $arrdata['discount'];?>">
                                                    </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"
                                                            value="<?php echo $arrdata['payable_amount'];?>" readonly>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-group text-right">
                                                <button type="submit" name="submit"
                                                    class="btn btn-primary float-end ">Save</button>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>







                </div>
            </div>
        </div>
        <!-- End section content -->


        <?php
   include('footer.php');
?>

    </div>


    <!-- JQuery v3.5.1 -->
    <script src="assets/plugins/jquery/jquery.min.js"></script>

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.min.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>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

    <script type="text/javascript">
    // 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();
        }
    });

    // Calculate payable amount on page load
    $(document).ready(function() {
        calculatePayableAmount();
    });
    </script>

</body>

</html>