MAINHACK

Viewing / Editing File: personalrecords.php

<?php 
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
 include("functions.php");
 if(!isset($_SESSION['index_no78897498'])){
     header("location:index");
 } else {

$myindex_id   = $_SESSION['index_no78897498'] ?? '';
$myschoolcode = $_SESSION['myschoolcode'] ?? '';
$schoolID     = $_SESSION['student_id0023894'] ?? '';

// 1. Get enrol_generic
$indexx = mysqli_query($new, "SELECT * FROM enrol_generic WHERE indexNo = '$myindex_id'");
$fetchsch = mysqli_fetch_array($indexx);
$school_code = $fetchsch['s_code'] ?? '';

// 2. Get school shortcode
$getschool = mysqli_query($new, "SELECT short_code FROM schools WHERE school_code = '$myschoolcode'");
$fetchschcode = mysqli_fetch_array($getschool);
$shortcode = $fetchschcode['short_code'] ?? '';

$academicyr = mysqli_query($new, "SELECT academic_year FROM admission_info WHERE s_code = '$myschoolcode'");
$getacadeic = mysqli_fetch_array($academicyr);
$myacademicyr = $getacadeic['academic_year'] ?? '';

// 3. Check payment
$select_pay = mysqli_query($new, "SELECT * FROM stud_payment WHERE indexNumber = '$myindex_id' AND s_code = '$myschoolcode'");
$getpay = mysqli_fetch_array($select_pay);
$pstatus = $getpay['pstatus'] ?? '';
$access_code = $getpay['access_code'];
$checkmyrecordsexist = mysqli_num_rows($select_pay);

// 4. Check enrol_details
$queryy = mysqli_query($new, "SELECT schoolID FROM enrol_details WHERE s_code = '$myschoolcode' AND schoolID = '$schoolID'");
$checkrecords = mysqli_num_rows($queryy);

// 5. Logic
if ($checkmyrecordsexist < 1 && $checkrecords > 0 && !isset($_GET['stay'])) {
    header("Location: " . $_SERVER['REQUEST_URI'] . "?stay=1");
    exit();
}

elseif ($checkmyrecordsexist < 1 && $checkrecords < 1) {
    header("Location: makepayment");
    exit();
}
elseif ($checkmyrecordsexist > 0 && $pstatus == 'pending' && $checkrecords < 1) {
    header("Location: payment-pending");
    exit();
}

else {

$enroll_de = mysqli_query($new,"SELECT * FROM enrol_details WHERE index_no  = '$myindex_id'");
$enroll_info = mysqli_fetch_array($enroll_de);
$class_id1 = $enroll_info['class_id'];

$rawscore1 = $enroll_info['raw_score'];
$enrol_code1 = $enroll_info['enrol_code'];
$enrol_form1 = $enroll_info['enrol_form'];
$jhs_attended1 = $enroll_info['jhs_attended'];
$jhs_type1 = $enroll_info['jhs_type'];
$dob1 = $enroll_info['date_of_birth'];
$place1 = $enroll_info['place_of_birth'];
$nationality1 = $enroll_info['nationality'];
$religion1 = $enroll_info['religion'];
$denomination1 = $enroll_info['religion_denomination'];
$address1 = $enroll_info['address'];
$town1 = $enroll_info['town'];
$region1 = $enroll_info['region'];
$district1 = $enroll_info['district'];
$interest1 = $enroll_info['interest'];
$ghana_card1 = $enroll_info['ghana_card'];
$house_residence1 = $enroll_info['house_residence'];
$mobile_num1 = $enroll_info['mobile_num'];
$photo1 = $enroll_info['photo'];
$father_name1 = $enroll_info['father_name'];
$father_occupation1 = $enroll_info['father_occupation'];
$mother_name1 = $enroll_info['mother_name'];
$mother_number = $enroll_info['mother_number'];

$mother_occupation1 = $enroll_info['mother_occupation'];
$guadian1 = $enroll_info['guadian'];
$guadian_address1 = $enroll_info['guadian_address'];
$house_select1 = $enroll_info['house_id'];
$telephone = $enroll_info['telephone'];
$enrol_form1 = "";
$photo1 = "";

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) {
    if (!csrf_token_is_valid() || !csrf_token_is_recent()) {
        $message = "<p class='alert alert-danger text-center' role='alert'>Token Authentication Failed</p>";
    } else {
        // Handle enrolment form upload
        $newFilePath = $enrol_form1; // Default to existing if any
        if (isset($_FILES['enrolfile']) && $_FILES['enrolfile']['error'] === UPLOAD_ERR_OK) {
            $enrolfile = $_FILES['enrolfile'];
            $originalFileName = $enrolfile['name'];
            $fileTmpName = $enrolfile['tmp_name'];

// Generate random name
            $randomName = bin2hex(random_bytes(8));
            $fileExtension = pathinfo($originalFileName, PATHINFO_EXTENSION);
            $newFileName = $randomName . '.' . $fileExtension;

// Upload path (ensure '../admin/uploads/' exists and is writable)
            $uploadFolder = '../admin/uploads/';
            $destination = $uploadFolder . $newFileName;

if (move_uploaded_file($fileTmpName, $destination)) {
                $newFilePath = $destination;
                // Delete old file if exists and different
                if (!empty($enrol_form1) && file_exists($enrol_form1) && $enrol_form1 !== $newFilePath) {
                    unlink($enrol_form1);
                }
            }
        }

// Handle profile photo upload (similar logic)
        $newFilePath1 = $photo1; // Default to existing if any
        if (isset($_FILES['profile']) && $_FILES['profile']['error'] === UPLOAD_ERR_OK) {
            $profile = $_FILES['profile'];
            $originalFileName = $profile['name'];
            $fileTmpName1 = $profile['tmp_name'];

// Generate random name
            $randomName1 = bin2hex(random_bytes(8));
            $fileExtension1 = pathinfo($originalFileName, PATHINFO_EXTENSION);
            $newFileName1 = $randomName1 . '.' . $fileExtension1;

$uploadFolder = '../admin/uploads/';
            $destination1 = $uploadFolder . $newFileName1;

if (move_uploaded_file($fileTmpName1, $destination1)) {
                $newFilePath1 = $destination1;
                if (!empty($photo1) && file_exists($photo1) && $photo1 !== $newFilePath1) {
                    unlink($photo1);
                }
            }
        }

// Sanitize inputs
        $rawscore = test_input($_POST['rawscore'] ?? '');
        $enrolcode = test_input($_POST['enrolcode'] ?? '');
        $jhs = test_input($_POST['jhs'] ?? '');
        $jhs_type = test_input($_POST['jhs_type'] ?? '');
        $dob = test_input($_POST['dob'] ?? '');
        $placeofbirth = test_input($_POST['placeofbirth'] ?? '');
        $nationality = test_input($_POST['nationality'] ?? '');
        $religion = test_input($_POST['religion'] ?? '');
        $denomination = test_input($_POST['denomination'] ?? '');
        $address = test_input($_POST['address'] ?? '');
        $town = test_input($_POST['town'] ?? '');
        $region = test_input($_POST['region'] ?? '');
        $district = test_input($_POST['district'] ?? '');
        $interest = test_input($_POST['interest'] ?? '');
        $ghanacard = test_input($_POST['ghanacard'] ?? '');
        $classselect = test_input($_POST['classselect'] ?? '');
        $house_select = test_input($_POST['house_select'] ?? '');
        $father = test_input($_POST['father'] ?? '');
        $foccupy = test_input($_POST['foccupy'] ?? '');
        $mother = test_input($_POST['mother'] ?? '');
        $moccupy = test_input($_POST['moccupy'] ?? '');
        $guardian = test_input($_POST['guardian'] ?? '');
        $telephone = test_input($_POST['telephone'] ?? '');
        $gaddress = test_input($_POST['gaddress'] ?? '');
        $schoolcode = test_input($_POST['schoolcode'] ?? '');
        $mobile_num = test_input($_POST['mobile_num'] ?? '');
        $myname = test_input($_POST['thismyname'] ?? '');
        $accessCode = test_input($_POST['accessCode']);
        $thisacademictear = test_input($_POST['thisacademictear']);
        $studentdorm = "FORM1";
        $mother_number = test_input($_POST['mother_number']);

$created_at = date("Y-m-d H:i:s");

try {
    // Begin transaction for row-level locking
    $year_suffix = date('y'); 
     $con->beginTransaction();

// Step 1: Get the school's short code
    $school_query = $new->prepare("SELECT short_code FROM schools WHERE school_code = ?");
    $school_query->bind_param("s", $schoolcode);
    $school_query->execute();
    $school_result = $school_query->get_result();
    $school_row = $school_result->fetch_assoc();

if (!$school_row) {
        throw new Exception("Invalid school code selected.");
    }

$short_code = $school_row['short_code'];
    
$maxStmt = $con->prepare("
    SELECT COALESCE(MAX(CAST(codenumber AS UNSIGNED)), 0) AS last_code
    FROM enrol_details
    WHERE s_code = ?
      AND enrol_code IS NOT NULL
    FOR UPDATE
");
$maxStmt->execute([$schoolcode]);
$last_code = (int)($maxStmt->fetch(PDO::FETCH_ASSOC)['last_code'] ?? 0);

// 3) Next number and ID
$next_number = $last_code + 1;

// Step 3: Build new student ID
      $new_id = $short_code . '' . $year_suffix . '' . str_pad($next_number, 5, '0', STR_PAD_LEFT);

// Fetch class name
        $getclass = mysqli_query($new, "SELECT class_name FROM class WHERE s_code = '$schoolcode' AND cid = '$classselect'");
        $getclassvauename = mysqli_fetch_array($getclass, MYSQLI_ASSOC);
        $classname = $getclassvauename['class_name'] ?? '';

if (empty($classname)) {
            $getnyclass = mysqli_query($new, "SELECT classname FROM enrol_details WHERE s_code = '$myschoolcode' AND schoolID = '$schoolID'");
            $getnewclass = mysqli_fetch_array($getnyclass, MYSQLI_ASSOC);
            $thismyclass = $getnewclass['classname'] ?? 'N/A';
        } else {
            $thismyclass = $classname;
        }

// Fetch house name
        $dbprogram = mysqli_query($new, "SELECT house_name FROM house WHERE school_code = '$myschoolcode' AND hid = '$house_select'");
        $getproidname = mysqli_fetch_array($dbprogram, MYSQLI_ASSOC);
        $myhousename = $getproidname['house_name'] ?? '';

if (empty($myhousename)) {
            $getnyhouse = mysqli_query($new, "SELECT housename FROM enrol_details WHERE s_code = '$myschoolcode' AND schoolID = '$schoolID'");
            $getnewhouse = mysqli_fetch_array($getnyhouse, MYSQLI_ASSOC);
            $thismyhouse = $getnewhouse['housename'] ?? 'N/A';
        } else {
            $thismyhouse = $myhousename;
        }

// Key fix: Check if record exists for THIS student (by index_no)
        $selectme = mysqli_query($new, "SELECT * FROM enrol_details WHERE index_no = '$myindex_id' AND s_code = '$myschoolcode'");
        
        $classselect = ($classselect === 'N/A' || empty($classselect)) ? null : $classselect;
        $house_select = empty($house_select) ? null : $house_select;

if (mysqli_num_rows($selectme) < 1) {

$stmt = $con->prepare("
            INSERT INTO enrol_details (
                s_code, index_no, student_name, raw_score, enrol_code, enrol_form, jhs_attended, jhs_type, date_of_birth, place_of_birth, 
                nationality, religion, religion_denomination, address, town, region, district, ghana_card, house_residence, interest, 
                class_id, photo, mobile_num, telephone, father_name, father_occupation, mother_name, mother_occupation, guadian, 
                guadian_address, house_id, schoolID, classname, housename, access_code, academic_year, student_form, mother_number, created_at,codenumber,unique_student_code
            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?)
            ");
            
            $stmt->execute(array(
            $myschoolcode, $myindex_id, $myname, $rawscore, $enrolcode, $newFilePath, $jhs, $jhs_type, $dob, $placeofbirth,
            $nationality, $religion, $denomination, $address, $town, $region, $district, $ghanacard, $address, $interest,
            $classselect, $newFilePath1, $mobile_num, $telephone, $father, $foccupy, $mother, $moccupy, $guardian, $gaddress,
            $house_select, $new_id, $thismyclass, $thismyhouse, $accessCode, $thisacademictear, $studentdorm, $mother_number, $created_at,$next_number,$new_id
            ));

$con->commit();

header("Location: dashboard");
            exit();
        } 
    } catch (Exception $e) {
    $con->rollBack();  
   // echo "<h3>❌ Error: " . $e->getMessage() . "</h3>";
}
}
}
}

}
?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Dashboard | Online Admission Portal</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
<meta content="Themesbrand" name="author" />

<link href="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" href="assets/css/preloader.min.css" type="text/css" />

<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />

<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />

<link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />

/* Apply a red border for required fields that are not filled */
        input:invalid, select:invalid, textarea:invalid {
            border: 2px solid red;
        }

</style>
</head>
<body>
<div id="layout-wrapper">

<?php include("includes/header.php");?> 

<?php include("includes/sidebar.php");?>
<div class="main-content">

<div class="page-content">
<div class="container-fluid">
<?php 
$studentID = mysqli_query($new,"SELECT * FROM enrol_generic WHERE indexNo  = '$myindex_id'");
$stud = mysqli_fetch_array($studentID, MYSQLI_ASSOC); // safer to use associative array

if ($stud) {
    $myname    = $stud['stud_name'];
    $programme = $stud['programme'];
    $myindex   = $stud['indexNo'];
    $mygrade   = $stud['grade'];
    $mygender  = $stud['gender'];
    $resident  = $stud['status'];
} else {
    // No record found
    $myname = $programme = $myindex = $mygrade = $mygender = $resident = null;
}

// Fallback if missing important fields
if (empty($programme) || empty($myname) || empty($myindex)) {
    $getprogram = mysqli_query($new,"SELECT programe, student_name, schoolID FROM enrol_details WHERE schoolID = '$schoolID'");
    $myprogram = mysqli_fetch_array($getprogram, MYSQLI_ASSOC);

if ($myprogram) {
        $program_name = $myprogram['programe'];
        $myschoolid   = $myprogram['schoolID'];
        $thisname     = $myprogram['student_name'];
    } else {
        $program_name = $myschoolid = $thisname = null;
    }
}

if(empty($mygrade)){
    $thisgrade = 0;
} else {
    $thisgrade = $mygrade;
}

if(empty($mygender)){
    $thisgender = "N/A";
} else {
    $thisgender = $mygender;
}

if(empty($resident)){
    $residentstatus = "N/A";
} else {
    $residentstatus = $resident;
}

$stmt = $con->prepare("Select * from schools where school_code = ?");
$stmt->execute(array($myschoolcode));
$row = $stmt->fetch();
$logo = $row['logo'];
$school_name = $row['school_name'];

<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
  <h4 class="card-title">Admission form</h4>
  <p class="card-title-desc" style="font-sixe:22px;color: red;">NOTE: The information you provide here MUST be EXACTLY the same as the Information provided on your Placement Form. Any attempt to do otherwise may result in the CANCELATION OF YOUR ADMISSION. Thank you</p>
</div>

<div class="card-body">
  <h4>ENROLMENT DATA PART 1. No action Required
</h4>
  <div>

<?php echo $message;?>
      <form method="POST"  enctype="multipart/form-data" class="needs-validation" novalidate>
        <?php echo csrf_token_tag(); ?>
    <input type="hidden"/>
          <div class="row">
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Index number</label>
                      <input type="text" name="index_no" readonly  data-pristine-required-message="" class="form-control" value="<?php echo !empty($myindex) ? $myindex : $myschoolid; ?>" />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Gender</label>
            <input type="text" readonly data-pristine-required-message="" class="form-control" value="<?php echo $thisgender ;?>" />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Programme</label>
                      <input type="text" readonly data-pristine-min-message="" required class="form-control" value="<?php echo !empty($programme) ? $programme : $program_name; ?>">
                  </div>
              </div>

<input type="hidden" name="bossid" value="<?php echo $myindex_id;?>">
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Residential status</label>
                      <input type="text" readonly data-pristine-required-message="" class="form-control" value="<?php echo $residentstatus ;?>">
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Surname</label>
                      <input type="text" readonly name="thismyname" class="form-control" value="<?php echo !empty($myname) ? $myname : $thisname; ?>">
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Grade</label>
                      <input type="text"  readonly class="form-control" value="<?php echo $thisgrade;?>">
                  </div>
              </div>

</div>
          <div class="card-body">
  <h4 style="font-size:13px">ENROLMENT DATA PART 2. <span style="color:red">(Enter exactly what is on the ENROLMENT FORM you printed from the CSSPS Website)</span></h4>

<div class="row">
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Raw Score *</label>
                      <input type="text" name="rawscore" value="<?php echo $rawscore1;?>"  data-pristine-required-message=" raw score is required" class="form-control" required  />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Enrolment Code *</label>
                      <input type="text" name="enrolcode" value="<?php echo $enrol_code1;?>" data-pristine-required-message="Entrolment code is requres" required class="form-control" />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">

<label>ENROLMENT FORM UPLOAD(PNG,JPG,JPEG)</label>
     <?php if (empty($enrol_form1)) { ?>
    <input type="file" name="enrolfile" accept=".png,.jpg,.jpeg" 
           data-pristine-min-message="Upload your enrolment form" class="form-control"/>
<?php } else { ?>
    <div class="image-preview">
        <img src="<?php echo htmlspecialchars($enrol_form1); ?>" alt="Enrolment Form" style="max-width: 80px; max-height: 80px;"/>
        <p>Current enrolment form. Upload a new file to replace it (optional).</p>
        <input type="file" name="enrolfile"  accept=".png,.jpg,.jpeg" 
               data-pristine-min-message="Upload new enrolment form" class="form-control"/>
    </div>
<?php } ?>

<input type="hidden" name="accessCode" value="<?php echo $access_code;?>">
                     
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Name of JHS Attended *</label>
                      <input type="text"  name="jhs" value="<?php echo $jhs_attended1;?>" data-pristine-required-message="Type your JHS name is required" class="form-control">
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>JHS Type *(<?php echo $jhs_type1;?>)</label>
               <select class="form-control" name="jhs_type" required>
                  <option value="<?php echo $jhs_type1;?>"> Select type</option>
                  <option value="PRIVATE"> PRIVATE</option>
                  <option value="PUBLIC"> PUBLIC</option>
                  </select>
                
                  </div>
              </div>

</div>

</div>
                <div class="card-body">
  <h4>PERSONAL DATA. Some fields are mandatory</h4>

<div class="row">
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Date of Birth *</label>
                      <input type="date" name="dob" value="<?php echo $dob1;?>"  data-pristine-required-message="Date of birth is required" class="form-control" required  />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Place of Birth *</label>
                      <input type="text" name="placeofbirth" value="<?php echo $place1;?>" data-pristine-required-message="Place of birth is requres" required class="form-control" />
                  </div>
              </div>
            <div class="col-xl-4 col-md-6">
            <div class="form-group mb-3">
            <label>Nationality* <?php echo $nationality1;?></label>
            <select class="form-control" id="nationality" name="nationality" required>
            <option value="<?php echo $nationality1;?>"> Select type</option>
            <?php 
            $studentID = mysqli_query($new,"SELECT * FROM country ");
            while($stud = mysqli_fetch_array($studentID)){
            ?>
            <option value="<?php echo $stud['name'];?>"> <?php echo $stud['name'];?></option>
            <?php }?>
            </select>
            </div>
            </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Religion *<?php echo $religion1;?></label>

<select class="form-control" id="religion" name="religion" required>
                          <option value="<?php echo $religion1;?>"> Select</option>
                        <option value="CHRISTIANITY"> CHRISTIANITY </option>
                        <option value="Atheism/Agnosticism"> Atheism/Agnosticism</option>
                        <option value="Buddhism"> Buddhism</option>
                        <option value="Christianity"> Christianity</option>
                        <option value="Confucianism"> Confucianism</option>
                        <option value="Druze"> Druze</option>
                        <option value="Hinduism"> Hinduism</option>
                        <option value="Islam"> Islam</option>
                        <option value="Judaism"> Judaism</option>
                        <option value="Shinto"> Shinto</option>
                        <option value="Traditional African Religions"> Traditional African Religions
                        </option>
                      </select>
               
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Religious Denomination *<?php echo $denomination1;?></label>
              <select class="form-control" id="denomination" name="denomination">
                <option value="<?php echo $denomination1;?>">Select</option>
              <option value="PENTECOSTAL"> PENTECOSTAL </option>
              <option value="Catholic"> Catholic</option>
              <option value="Methodist"> Methodist</option>
              <option value="Anglican"> Anglican</option>
              <option value="Presbyterian"> Presbyterian</option>
              <option value="Pentecostal"> Pentecostal</option>
              <option value="Baptist"> Baptist</option>
              <option value="Lutheran"> Lutheran</option>
              <option value="Seventh-Day Adventist"> Seventh-Day Adventist</option>
              <option value="Evangelical Charismatic"> Evangelical Charismatic</option>
              <option value="Latter-day Saint"> Latter-day Saint</option>
              <option value="Saviour Church"> Saviour Church</option>
              <option value="Church of Christ"> Church of Christ</option>
              <option value="Other"> Others</option>
              </select>
                
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Permanent Address *</label>
                      <input type="text" name="address" value="<?php echo $address1;?>" required class="form-control" >
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Town  *</label>
                      <input type="text" name="town" value="<?php echo $town1;?>" required class="form-control" >
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Region *<?php echo $region1;?></label>
              <select class="form-control" id="region" class="district" name="region" required>
                <option value="<?php echo $region1;?>">Select</option>
              <option value="GREATER ACCRA" selected> GREATER ACCRA </option>
              <option value="Ahafo"> Ahafo</option>
              <option value="Ashanti"> Ashanti</option>
              <option value="Bono"> Bono</option>
              <option value="Bono East"> Bono East</option>
              <option value="Central"> Central</option>
              <option value="Eastern"> Eastern</option>
              <option value="Greater Accra"> Greater Accra</option>
              <option value="North East"> North East</option>
              <option value="Northern"> Northern</option>
              <option value="Oti"> Oti</option>
              <option value="Savannah"> Savannah</option>
              <option value="Upper East"> Upper East</option>
              <option value="Upper West"> Upper West</option>
              <option value="Volta"> Volta</option>
              <option value="Western"> Western</option>
              <option value="Western North"> Western North</option>
              </select>
                  </div>
              </div>

<?php
// Define districts array (complete list, deduplicated)
$districts = array_unique([
    'ACCRA METROPOLITAN',
    'ABLEKUMA CENTRAL MUNICIPAL',
    'ABLEKUMA NORTH MUNICIPAL',
    'ABLEKUMA WEST MUNICIPAL',
    'ABUAKWA NORTH MUNICIPAL',
    'ABUAKWA SOUTH MUNICIPAL',
    'ABURA-ASEBU-KWAMANKESE',
    'ACHIASE DISTRICT',
    'ADA EAST',
    'ADA WEST',
    'ADAKLU',
    'ADANSI ASOKWA',
    'ADANSI NORTH',
    'ADANSI SOUTH',
    'ADENTAN MUNICIPAL',
    'AFADZATO SOUTH',
    'AFIGYA KWABRE NORTH',
    'AFIGYA KWABRE SOUTH',
    'AGONA EAST',
    'AGONA WEST MUNICIPAL',
    'AGOTIME ZIOPE',
    'AHAFO ANO NORTH MUNICIPAL',
    'AHAFO ANO SOUTH EAST',
    'AHAFO ANO SOUTH WEST',
    'AHANTA WEST MUNICIPAL',
    'AJUMAKO-ENYAN-ESSIAM',
    'AKATSI NORTH',
    'AKATSI SOUTH',
    'AKROFUOM DISTRICT',
    'AKUAPIM NORTH MUNICIPAL',
    'AKUAPIM SOUTH',
    'AKYEMANSA',
    'AMANSIE CENTRAL',
    'AMANSIE SOUTH',
    'AMANSIE WEST',
    'ANLOGA',
    'AOWIN MUNICIPAL',
    'ASANTE AKIM CENTRAL MUNICIPAL',
    'ASANTE AKIM NORTH',
    'ASANTE AKIM SOUTH MUNICIPAL',
    'ASENE MANSO AKROSO',
    'ASHAIMAN MUNICIPAL',
    'ASIKUMA-ODOBEN-BRAKWA',
    'ASOKORE MAMPONG MUNICIPAL',
    'ASOKWA MUNICIPAL',
    'ASSIN CENTRAL MUNICIPAL',
    'ASSIN NORTH',
    'ASSIN SOUTH',
    'ASUNAFO NORTH MUNICIPAL',
    'ASUNAFO SOUTH',
    'ASUOGYAMAN',
    'ASUTIFI NORTH',
    'ASUTIFI SOUTH',
    'ATEBUBU-AMANTIN MUNICIPAL',
    'ATIWA EAST',
    'ATIWA WEST',
    'ATWIMA KWANWOMA',
    'ATWIMA MPONUA',
    'ATWIMA NWABIAGYA NORTH MUNICIPAL',
    'ATWIMA NWABIAGYA SOUTH',
    'AWUTU SENYA EAST',
    'AWUTU SENYA WEST',
    'AYAWASO CENTRAL MUNICIPAL DISTRICT',
    'AYAWASO EAST MUNICIPAL',
    'AYAWASO NORTH MUNICIPAL',
    'AYAWASO WEST MUNICIPAL',
    'AYENSUANO',
    'BANDA',
    'BAWKU MUNICIPAL',
    'BAWKU WEST',
    'BEKWAI MUNICIPAL',
    'BEREKUM EAST MUNICIPAL',
    'BEREKUM WEST',
    'BIA EAST',
    'BIA WEST',
    'BIAKOYE',
    'BIBIANI-ANHWIASO-BEKWAI MUNICIPAL',
    'BINDURI',
    'BIRIM CENTRAL MUNICIPAL',
    'BIRIM NORTH',
    'BIRIM SOUTH',
    'BODI',
    'BOLE',
    'BOLGATANGA EAST',
    'BOLGATANGA MUNICIPAL',
    'BONGO',
    'BOSOME FREHO',
    'BOSOMTWE',
    'BUILSA NORTH',
    'BUILSA SOUTH',
    'BUNKPURUGU NAKPANDURI',
    'CAPE COAST METROPOLITAN',
    'CENTRAL GONJA',
    'CENTRAL TONGU',
    'CHEREPONI',
    'DAFFIAMA BUSSIE ISSA',
    'DENKYEMBOUR',
    'DORMAA CENTRAL MUNICIPAL',
    'DORMAA EAST',
    'DORMAA WEST',
    'EAST GONJA MUNICIPAL',
    'EAST MAMPRUSI MUNICIPAL',
    'EFFIA KWESIMINTSIM MUNICIPAL',
    'EFFUTU MUNICIPAL',
    'EJISU MUNICIPAL',
    'EJURA-SEKYEDUMASE',
    'EKUMFI',
    'ELLEMBELE',
    'FANTEAKWA NORTH',
    'FANTEAKWA SOUTH',
    'GA CENTRAL',
    'GA EAST MUNICIPAL',
    'GA NORTH MUNICIPAL',
    'GA SOUTH MUNICIPAL',
    'GA WEST MUNICIPAL',
    'GARU',
    'GOMOA EAST',
    'GOMOA WEST',
    'GUSHEGU MUNICIPAL',
    'HO MUNICIPAL',
    'HO WEST',
    'HOHOE MUNICIPAL',
    'JAMAN NORTH',
    'JAMAN SOUTH MUNICIPAL',
    'JASIKAN',
    'JIRAPA MUNICIPAL',
    'JOMORO MUNICIPAL',
    'JUABEN MUNICIPAL',
    'JUABOSO',
    'KADJEBI',
    'KARAGA',
    'KASSENA NANKANA EAST',
    'KASSENA NANKANA WEST',
    'KETA MUNICIPAL',
    'KETU NORTH MUNICIPAL',
    'KETU SOUTH MUNICIPAL',
    'KINTAMPO NORTH MUNICIPAL',
    'KINTAMPO SOUTH',
    'KOMENDA-EDINA-EGUAFO-ABIREM MUNICIPAL',
    'KORLE KLOTTEY MUNICIPAL DISTRICT',
    'KPANDAI',
    'KPANDO MUNICIPAL',
    'KPONE KATAMANSO MUNICIPAL',
    'KRACHI EAST MUNICIPAL',
    'KRACHI NCHUMURU',
    'KRACHI WEST',
    'KROWOR MUNICIPAL',
    'KUMASI METROPOLITAN',
    'KUMBUNGU',
    'KWABRE EAST MUNICIPAL',
    'KWADASO MUNICIPAL',
    'KWAEBIBIREM MUNICIPAL',
    'KWAHU AFRAM PLAINS NORTH',
    'KWAHU AFRAM PLAINS SOUTH',
    'KWAHU EAST',
    'KWAHU SOUTH',
    'KWAHU WEST MUNICIPAL',
    'LA-DADE-KOTOPON MUNICIPAL',
    'LA-NKWANTANANG-MADINA',
    'LAMBUSSIE KARNI',
    'LAWRA MUNICIPAL',
    'LEDZOKUKU MUNICIPAL',
    'LOWER MANYA KROBO',
    'MAMPONG MUNICIPAL',
    'MAMPRUGO MOAGDURI',
    'MFANTSEMAN MUNICIPAL',
    'MION',
    'MPOHOR',
    'NABDAM',
    'NADOWLI-KALEO',
    'NANDOM',
    'NANTON',
    'NANUMBA NORTH MUNICIPAL',
    'NANUMBA SOUTH',
    'NEW JUABEN NORTH MUNICIPAL',
    'NEW JUABEN SOUTH MUNICIPAL',
    'NINGO-PRAMPRAM',
    'NKORANZA NORTH',
    'NKORANZA SOUTH',
    'NKWANTA NORTH',
    'NKWANTA SOUTH MUNICIPAL',
    'NORTH DAYI',
    'NORTH EAST GONJA',
    'NORTH GONJA',
    'NORTH TONGU',
    'NSAWAM ADOAGYIRI MUNICIPAL',
    'NZEMA EAST MUNICIPAL',
    'OBUASI EAST',
    'OBUASI MUNICIPAL',
    'OFFINSO NORTH',
    'OFFINSO SOUTH MUNICIPAL',
    'OFORIKROM MUNICIPAL',
    'OKAIKWEI NORTH MUNICIPAL',
    'OKERE',
    'OLD TAFO MUNICIPAL',
    'PRESTEA-HUNI VALLEY MUNICIPAL',
    'PRU EAST',
    'PRU WEST',
    'PUSIGA',
    'SABOBA',
    'SAGNARIGU MUNICIPAL',
    'SAVELUGU MUNICIPAL',
    'SAWLA-TUNA-KALBA',
    'SEFWI AKONTOMBRA',
    'SEFWI WIAWSO',
    'SEKONDI TAKORADI METROPOLITAN',
    'SEKYERE AFRAM PLAINS',
    'SEKYERE CENTRAL',
    'SEKYERE EAST',
    'SEKYERE KUMAWU',
    'SEKYERE SOUTH',
    'SENE EAST',
    'SENE WEST',
    'SHAI-OSUDOKU DISTRICT',
    'SHAMA',
    'SISSALA EAST MUNICIPAL',
    'SISSALA WEST',
    'SOUTH DAYI',
    'SOUTH TONGU',
    'SUAMAN',
    'SUAME MUNICIPAL',
    'SUHUM',
    'SUNYANI MUNICIPAL',
    'SUNYANI WEST',
    'TAIN',
    'TALENSI',
    'TAMALE METROPOLITAN',
    'TANO NORTH MUNICIPAL',
    'TANO SOUTH MUNICIPAL',
    'TARKWA NSUAEM MUNICIPAL',
    'TATALE-SANGULE',
    'TECHIMAN MUNICIPAL',
    'TECHIMAN NORTH',
    'TEMA METROPOLITAN',
    'TEMA WEST MUNICIPAL',
    'TEMPANE',
    'TOLON',
    'TWIFO ATTI MORKWA',
    'TWIFO HEMANG LOWER DENKYIRA',
    'UPPER DENKYIRA EAST MUNICIPAL',
    'UPPER DENKYIRA WEST',
    'UPPER MANYA KROBO',
    'UPPER WEST AKIM',
    'WA EAST',
    'WA MUNICIPAL',
    'WA WEST',
    'WASSA AMENFI CENTRAL',
    'WASSA AMENFI EAST MUNICIPAL',
    'WASSA AMENFI WEST MUNICIPAL',
    'WASSA EAST',
    'WEIJA GBAWE MUNICIPAL',
    'WENCHI MUNICIPAL',
    'WEST AKIM MUNICIPAL',
    'WEST GONJA',
    'WEST MAMPRUSI MUNICIPAL',
    'YENDI MUNICIPAL',
    'YILO KROBO MUNICIPAL',
    'YUNYOO-NASUAN',
    'ZABZUGU'
]);
sort($districts); // Sort alphabetically

// Default district value (ensure it exists in the array or is empty)
$district1 = isset($district1) && in_array($district1, $districts) ? $district1 : '';
?>
<div class="col-xl-4 col-md-6">
    <div class="form-group mb-3">
        <label for="district" class="form-label">District <span class="text-danger">*</span></label>
        <select class="form-select" id="district" class="district" name="district" required>
            <option value="" <?php echo $district1 === '' ? 'selected' : ''; ?>>Select District</option>
            <?php foreach ($districts as $district): ?>
                <option value="<?php echo htmlspecialchars($district); ?>" <?php echo $district === $district1 ? 'selected' : ''; ?>>
                    <?php echo htmlspecialchars($district); ?>
                </option>
            <?php endforeach; ?>
        </select>
        <div class="invalid-feedback">Please select a district.</div>
    </div>
</div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Interest(s) *<?php echo $interest1;?></label>
                <select class="form-control" id="interest" name="interest" required>
                  <option value="<?php echo $interest1;?>"></option>
                <option value="OTHERS"> OTHERS </option>
                <option value="Athletics"> Athletics</option>
                <option value="Football"> Football</option>
                <option value="Debating Club"> Debating Club</option>
                <option value="Others"> Others</option>
                </select>
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Ghana Card/NHIS No  *</label>
                      <input type="text" name="ghanacard" value="<?php echo $ghana_card1;?>" required class="form-control" >
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
    <div class="form-group mb-3">
        <label>Passport picture *</label>
<?php if (empty($photo1)) { ?>
    <input type="file" name="profile" id="profile" accept=".png,.jpg,.jpeg" class="form-control" >
<?php } else { ?>
    <div class="image-preview">
        <img src="<?php echo htmlspecialchars($photo1); ?>" alt="Profile Image" style="max-width: 80px; max-height: 80px;"/>
    <input type="file" name="profile" id="profile" accept=".png,.jpg,.jpeg" class="form-control" >
    </div>
<?php } ?>
    </div>
</div>

<div class="col-xl-4 col-md-6">
    <div class="form-group mb-3">
        <label>Phone number *</label>
        <input type="text" name="mobile_num" value="<?php echo $mobile_num1;?>"  data-pristine-required-message="Phone number is requres" required class="form-control" />
    </div>
</div>

</div>

<div class="card-body">
  <h4>CLASS SELECTION.</h4>

<div class="row">
              <div class="col-xl-6 col-md-6">
<div class="table-responsive">
    <table class="table table-striped table-hover align-middle">
        <thead class="table-dark">
            <tr>
                <th>Select</th>
                <th>Class</th>
                <th>Subject Combination</th>
            </tr>
        </thead>
        <tbody>
<?php
$gethousestataus = "";
$getproid = null;

// 1. Fetch enrol_generic record
$stmt = $new->prepare("SELECT status, programme FROM enrol_generic WHERE s_code = ?");
$stmt->bind_param("s", $myschoolcode);
$stmt->execute();
$result = $stmt->get_result();
$getgenericprogram = $result->fetch_assoc();

$stmt2 = $new->prepare("SELECT progid FROM programme WHERE s_code = ? AND LOWER(program_name) = LOWER(?)");
$stmt2->bind_param("ss", $myschoolcode, $programme);
$stmt2->execute();
$result2 = $stmt2->get_result();
$getproid = $result2->fetch_assoc();

if ($getproid) {
    $getproID = $getproid['progid'];

// 3. Fetch classes for this programme including capacity
    $stmt3 = $new->prepare("SELECT cid, class_name, subject_com, class_capacity 
                            FROM class 
                            WHERE s_code = ? AND program_id = ?");
    $stmt3->bind_param("si", $myschoolcode, $getproID);
    $stmt3->execute();
    $result3 = $stmt3->get_result();

if ($result3->num_rows > 0) {
        while ($getclassvaue = $result3->fetch_assoc()) {
            $cid          = $getclassvaue['cid'];
            $capacity     = (int)$getclassvaue['class_capacity'];
            $class_name   = $getclassvaue['class_name'];
            $subject_com  = $getclassvaue['subject_com'];

// Check current enrolment
            $countQuery = $new->prepare("SELECT COUNT(*) AS total 
                                         FROM enrol_details 
                                         WHERE class_id = ? AND s_code = ?");
            $countQuery->bind_param("is", $cid, $myschoolcode);
            $countQuery->execute();
            $countResult = $countQuery->get_result()->fetch_assoc();
            $totalStudents = (int)$countResult['total'];

// Only show class if not full
            if ($totalStudents < $capacity) {
                $isChecked = ($cid == $class_id1) ? 'checked' : '';
?>
                <tr>
                    <td>
                        <input type="radio" 
                               name="classselect" 
                               id="class_<?php echo htmlspecialchars($cid); ?>" 
                               value="<?php echo htmlspecialchars($cid); ?>" 
                               <?php echo $isChecked; ?> required>
                    </td>
                    <td><?php echo htmlspecialchars($class_name); ?></td>
                    <td><?php echo html_entity_decode($subject_com, ENT_QUOTES | ENT_HTML5); ?></td>
                </tr>
<?php
            } 
            // else skip class (don’t show if full)
        }
    } else {
        echo "<tr>
                <td><input type='radio' name='classselect' value='N/A' required></td>
                <td colspan='2' class='text-danger'>No classes available</td>
              </tr>";
    }
} else {
    echo "<tr>
            <td><input type='radio' name='classselect' value='N/A' required></td>
            <td colspan='2' class='text-danger'>No programme or enrolment found</td>
          </tr>";
}
?>

</tbody>
    </table>
</div>

</div>

<?php
// Get all houses for the school
$gethouse = mysqli_query($new, "SELECT * FROM house WHERE school_code = '$myschoolcode'");
if (mysqli_num_rows($gethouse) > 0) {
    $availableHouses = [];

// Normalize resident type and gender
    $residentTypeRaw = strtolower(trim($residentstatus));
    $residentType = ($residentTypeRaw === 'boarder') ? 'boarding' : $residentTypeRaw;
    $studentGender = strtolower(trim($thisgender));

while ($getrow = mysqli_fetch_assoc($gethouse)) {
        $hid       = $getrow['hid'];
        $capacity  = (int)$getrow['capacity'];

// Normalize house type and gender
        $houseTypeRaw = strtolower(trim($getrow['type']));
        $houseType = ($houseTypeRaw === 'boarder') ? 'boarding' : $houseTypeRaw;
        $houseGender = strtolower(trim($getrow['gender']));

// Skip incompatible houses
        if ($houseType !== $residentType) continue;
        if ($houseGender !== 'mixed' && $houseGender !== $studentGender) continue;

// Count students per house (per school)
        $countQuery = mysqli_query(
            $new,
            "SELECT COUNT(*) AS total 
             FROM enrol_details 
             WHERE house_id = '$hid' 
               AND s_code = '$myschoolcode'"
        );
        $countResult = mysqli_fetch_assoc($countQuery);
        $totalStudents = (int)$countResult['total'];

// Only include houses with free slots
        if ($totalStudents < $capacity) {
            $availableHouses[] = [
                'hid' => $hid,
                'house_name' => $getrow['house_name'],
                'capacity' => $capacity,
                'total_students' => $totalStudents,
                'slots_left' => $capacity - $totalStudents
            ];
        }
    }

if (!empty($availableHouses)) {
        // Build weighted pool by available slots
        $pool = [];
        foreach ($availableHouses as $house) {
            for ($i = 0; $i < $house['slots_left']; $i++) {
                $pool[] = $house;
            }
        }

shuffle($pool);
        $assignedHouse = $pool[array_rand($pool)];
        $assignedHouseId = $assignedHouse['hid'];
        $assignedHouseName = $assignedHouse['house_name'];

if ($stmt->affected_rows > 0) {
            ?>
            <div class="col-xl-6 col-md-6">
                <h4 class="mb-3">HOUSE ASSIGNED</h4>
                <div class="alert alert-success shadow-sm">
                    <strong><?php echo htmlspecialchars($assignedHouseName); ?></strong> 
                    (<?php echo $assignedHouse['total_students'] + 1; ?> / <?php echo $assignedHouse['capacity']; ?>).
                </div>
                <input type="hidden" name="house_select" value="<?php echo htmlspecialchars($assignedHouseId); ?>">
            </div>
            <?php
        } else {
            echo "<div class='alert alert-danger text-center'>Sorry, the selected house just became full. Please try again.</div>";
        }

} else {
        echo "<div class='alert alert-danger text-center'>No available {$residentstatus} house found for your gender or all are full. Please contact school administrator.</div>";
    }
} else {
    echo "<div class='alert alert-danger text-center'>No houses found for this school</div>";
}
?>

</div>

<div class="card-body">
  <h4>PARENTAL DATA. Some fields are mandatory</h4>

<div class="row">
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Father's Name*</label>
                      <input type="text" name="father" value="<?php echo $father_name1;?>"  data-pristine-required-message="Date of birth is required" class="form-control" required  />
                  </div>
              </div>
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Father's Occupation  *</label>
                      <input type="text" name="foccupy" value="<?php echo $father_occupation1;?>" data-pristine-required-message=" is requres" required class="form-control" />
                  </div>
              </div>
        
              <div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Mother's Name *</label>
                      <input type="text"  name="mother_name" value="<?php echo $mother_name1;?>" required data-pristine-required-message="Religion" class="form-control">
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Mother's phone number </label>
                      <input type="text"  name="mother_number" value="<?php echo $mother_number;?>"class="form-control">
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Mother's Occupation *</label>
                      <input type="text" name="moccupy" value="<?php echo $mother_occupation1;?>" data-pristine-required-message=" is requres" required class="form-control" />
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Name of Guardian</label>
                      <input type="text" name="guardian" value="<?php echo $guadian1;?>" class="form-control" >
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Residential Telephone  *</label>
                      <input type="text" name="telephone"  value="<?php echo $telephone;?>"  class="form-control" >
                  </div>
              </div>

<div class="col-xl-4 col-md-6">
                  <div class="form-group mb-3">
                      <label>Guardian Address</label>
                      <input type="text" name="gaddress" value="<?php echo $guadian_address1;?>"  class="form-control" >
                  </div>
              </div>

</div>

</div>
<input type="hidden" name="schoolcode" value="<?php echo $myschoolcode;?>">

<div class="form-group">
              <button  type="submit" name="submit" id="submitBtn" class="btn btn-primary">Submit</button>
          </div>
      </form>
  </div>

// Loop through radio buttons to see if any is checked
        for (var i = 0; i < radios.length; i++) {
            if (radios[i].checked) {
                isChecked = true;
                break;
            }
        }
        // If no radio button is checked, show an alert
        if (!isChecked) {
            alert("Please select your class combination.");
        }
    });
  </script>
</div>
</div>

</div>

</div>

</div>

</div>

<?php include("../admin/includes/footer.php");?>
</div>

</div>

<div class="right-bar">
<div data-simplebar class="h-100">
<!-- <div class="rightbar-title d-flex align-items-center p-3">

<h5 class="m-0 me-2">Theme Customizer</h5>

<hr class="m-0" />
<div class="p-4">
<h6 class="mb-3">Layout</h6>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-vertical" value="vertical">
<label class="form-check-label" for="layout-vertical">Vertical</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout"
id="layout-horizontal" value="horizontal">
<label class="form-check-label" for="layout-horizontal">Horizontal</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Mode</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-light" value="light">
<label class="form-check-label" for="layout-mode-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-mode"
id="layout-mode-dark" value="dark">
<label class="form-check-label" for="layout-mode-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Width</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-fuild" value="fuild" onchange="document.body.setAttribute('data-layout-size', 'fluid')">
<label class="form-check-label" for="layout-width-fuild">Fluid</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-width"
id="layout-width-boxed" value="boxed" onchange="document.body.setAttribute('data-layout-size', 'boxed')">
<label class="form-check-label" for="layout-width-boxed">Boxed</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Layout Position</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-fixed" value="fixed" onchange="document.body.setAttribute('data-layout-scrollable', 'false')">
<label class="form-check-label" for="layout-position-fixed">Fixed</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="layout-position"
id="layout-position-scrollable" value="scrollable" onchange="document.body.setAttribute('data-layout-scrollable', 'true')">
<label class="form-check-label" for="layout-position-scrollable">Scrollable</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Topbar Color</h6>

<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-light" value="light" onchange="document.body.setAttribute('data-topbar', 'light')">
<label class="form-check-label" for="topbar-color-light">Light</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="topbar-color"
id="topbar-color-dark" value="dark" onchange="document.body.setAttribute('data-topbar', 'dark')">
<label class="form-check-label" for="topbar-color-dark">Dark</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Size</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-default" value="default" onchange="document.body.setAttribute('data-sidebar-size', 'lg')">
<label class="form-check-label" for="sidebar-size-default">Default</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-compact" value="compact" onchange="document.body.setAttribute('data-sidebar-size', 'md')">
<label class="form-check-label" for="sidebar-size-compact">Compact</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-size"
id="sidebar-size-small" value="small" onchange="document.body.setAttribute('data-sidebar-size', 'sm')">
<label class="form-check-label" for="sidebar-size-small">Small (Icon View)</label>
</div>

<h6 class="mt-4 mb-3 pt-2 sidebar-setting">Sidebar Color</h6>

<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-light" value="light" onchange="document.body.setAttribute('data-sidebar', 'light')">
<label class="form-check-label" for="sidebar-color-light">Light</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-dark" value="dark" onchange="document.body.setAttribute('data-sidebar', 'dark')">
<label class="form-check-label" for="sidebar-color-dark">Dark</label>
</div>
<div class="form-check sidebar-setting">
<input class="form-check-input" type="radio" name="sidebar-color"
id="sidebar-color-brand" value="brand" onchange="document.body.setAttribute('data-sidebar', 'brand')">
<label class="form-check-label" for="sidebar-color-brand">Brand</label>
</div>

<h6 class="mt-4 mb-3 pt-2">Direction</h6>

</div>

</div> 
</div>

<div class="rightbar-overlay"></div>

<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/libs/feather-icons/feather.min.js"></script>

<script src="assets/libs/pace-js/pace.min.js"></script>

<script src="assets/libs/apexcharts/apexcharts.min.js"></script>

<script src="assets/libs/admin-resources/jquery.vectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="assets/libs/admin-resources/jquery.vectormap/maps/jquery-jvectormap-world-mill-en.js"></script>

     
       <script src="assets/libs/pristinejs/pristine.min.js"></script>
        
       <script src="assets/js/pages/form-validation.init.js"></script>

init() {
        // Ensure jQuery is available and the element exists
        if (typeof jQuery === 'undefined' || !$(this.selector).length) {
            console.error('jQuery or element not found for DistrictSelector:', this.selector);
            return;
        }

// Initialize Select2 with the provided options
        $(this.selector).select2(this.options);
    }
}

// Instantiate the class when the document is ready
$(document).ready(function() {
    const districtSelector = new DistrictSelector('#district');
});
</script>

select2FocusFix();
    });
</script>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: personalrecords.php

Server Info

System Features

User Info