MAINHACK

Viewing / Editing File: dashboard-23.php

<?php 
 include("functions.php");
 if(!isset($_SESSION['index_no78897498'])){
     header("location:index");
 } else {

$s_code = $_SESSION['index_no78897498'];
$myschoolcode = $_SESSION['myschoolcode'];
$student_idd = $_SESSION['student_id0023894'];

$select_pay = mysqli_query($new,"SELECT * FROM stud_payment WHERE indexNumber = '$s_code' and s_code = '$myschoolcode'");
  $getpay = mysqli_fetch_array($select_pay);
$pstatus = $getpay['pstatus'] ?? '';
$checkmyrecordsexist = mysqli_num_rows($select_pay);

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

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 {

// Build the query dynamically based on whether $schoID is null
$query = "SELECT * FROM enrol_details WHERE index_no = '$s_code'";
if ($student_idd !== null) {
    $query .= " OR schoolID = '$student_idd'";
} else {
    $query .= " OR schoolID IS NULL";
}

$indexx = mysqli_query($new, $query);

// Check if query was successful
if ($indexx === false) {
    die("Query failed: " . mysqli_error($new)); // Handle query error
}

// Check if any rows were returned
if (mysqli_num_rows($indexx) < 1) {
    header("Location: personalrecords"); // Redirect if no records found
    exit(); // Stop script execution after redirect
}
}
}

<!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" />

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

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

<?php 
$studentID = mysqli_query($new,"SELECT * FROM enrol_generic WHERE indexNo  = '$s_code'");
$stud = mysqli_fetch_array($studentID);
$name  = $stud['stud_name'];
$resident_status = $stud['status'];
$gender_status = $stud['gender'];

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

if(empty($gender_status)){
  $gender = "N/A";
} else {
  $gender = $gender_status;
}

if(empty($name)){
$studentDD = mysqli_query($new,"SELECT * FROM enrol_details WHERE schoolID = '$student_idd' and s_code = '$myschoolcode'");
 $getname  = mysqli_fetch_array($studentDD);
 $myname = $getname['student_name'];
}

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

$studentD = mysqli_query($new,"SELECT * FROM enrol_details,class WHERE enrol_details.schoolID = '$student_idd' and enrol_details.class_id = class.cid");
$getinfo = mysqli_fetch_array($studentD);
$c_name = $getinfo['class_name'];
$classID   = $getinfo['cid'];
$pic = $getinfo['photo'];

if (empty($c_name)) {

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

$getpic = mysqli_query($new,"SELECT photo FROM enrol_details WHERE schoolID = '$student_idd' and s_code = '$myschoolcode'");
$myphoto  = mysqli_fetch_array($getpic);
$thispic = $myphoto['photo'];

$classprog = mysqli_query($new,"SELECT * FROM programme,class WHERE class.program_id = programme.progid and  class.cid = '$classID'");
$getclassprogg = mysqli_fetch_array($classprog);
$programmee = $getclassprogg['program_name'];

if (empty($programmee)) {
    $getprogram = mysqli_query($new,"SELECT programe, student_name, schoolID FROM enrol_details WHERE schoolID = '$student_idd'");
    $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;
    }
}

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$myschoolcode' and file_name = 'PROSPECTUS'");
$PROS = mysqli_fetch_array($file_download);
$pros = $PROS['file'];

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$myschoolcode' and file_name = 'UNDERTAKEN'");
$PROS = mysqli_fetch_array($file_download);
$undertaken = $PROS['file'];

$file_download = mysqli_query($new,"SELECT * FROM school_file WHERE s_code = '$myschoolcode' and file_name = 'PROGRAMME'");
$PROS = mysqli_fetch_array($file_download);
$proGram = $PROS['file'];

$getHow = mysqli_query($new,"SELECT * FROM enrol_details,house WHERE enrol_details.house_id = house.hid and  enrol_details.index_no = '$s_code'");
$hname = mysqli_fetch_array($getHow);
$house_name = $hname['house_name'];
$mobile_num = $hname['mobile_num'];

?>
<center><h4><?php echo $school_name;?></h4></center>

<div class="card-body text-center bg-light p-5">
            <img src="<?php echo !empty($pic) ? $pic : $thispic; ?>" 
                 class="rounded-circle shadow-sm border border-3 border-primary" 
                 style="width: 120px; height: 120px; object-fit: cover;" 
                 alt="Student Photo">

<h3 class="mt-3 fw-bold text-dark text-uppercase">
              <?php echo !empty($myname) ? $myname : $name; ?>
            </h3>
            <h6 class="text-muted">SCHOOL ID NUMBER: 
              <span class="fw-semibold"><?php echo !empty($schoolID) ? $schoolID : $student_idd; ?></span>
            </h6>
          </div>

<div class="card-body">
            <div class="row g-4">

<div class="col-12 col-md-4 text-center">
                <h5 class="text-primary"><?php echo !empty($programme) ? $programme : $programmee; ?></h5>
                <p class="text-muted small">Programme</p>
              </div>

<div class="col-12 col-md-4 text-center">
                <h5 class="text-primary"><?php echo $resident; ?></h5>
                <p class="text-muted small">Residential Status</p>
              </div>

<div class="col-12 col-md-4 text-center">
                <a href="personalrecords.php" class="btn btn-outline-primary w-100 mb-2">
                  <i class="fas fa-edit me-2"></i> Edit Your Form
                </a>
                <p class="text-muted small mb-0">
                  Personal Records Status: <strong class="text-success">COMPLETED</strong>
                </p>
              </div>

<div class="col-6 col-md-4 text-center">
                <h5 class="text-primary"><?php echo $gender; ?></h5>
                <p class="text-muted small">Gender</p>
              </div>

<div class="col-6 col-md-4 text-center">
                <h5 class="text-primary"><?php echo  !empty($c_name) ? $c_name : $thismyclass; ?></h5>
                <p class="text-muted small">Class Assigned</p>
              </div>

<div class="col-6 col-md-4 text-center">
                <h5 class="text-primary"><?php echo $house_name; ?></h5>
                <p class="text-muted small">House Assigned</p>
              </div>

<div class="col-6 col-md-4 text-center">
                <h5 class="text-primary"><?php echo  !empty($s_code) ? $s_code : $student_idd; ?></h5>
                <p class="text-muted small">Student ID</p>
              </div>

<div class="col-6 col-md-4 text-center">
                <h5 class="text-primary"><?php echo $mobile_num; ?></h5>
                <p class="text-muted small">Contact Number</p>
              </div>

<div class="col-12 col-md-4 text-center">
                <a href="logout" class="btn btn-outline-danger w-100 mb-2">
                  <i class="fas fa-sign-out-alt me-2"></i> Log Out
                </a>
                <p class="text-muted small mb-0">Logout</p>
              </div>

</div>
          </div>

<div class="text-center my-4">
            <button class="btn btn-success btn-lg px-4" type="button" 
                    data-bs-toggle="collapse" data-bs-target="#downloadSection" 
                    aria-expanded="false" aria-controls="downloadSection">
              📂 Show Admission Documents
            </button>
          </div>

<div class="collapse" id="downloadSection">
            <div class="card-body border-top">
              <h4 class="text-center mb-4 fw-bold">📄 Documents for Download</h4>

<div class="row g-3">
                <div class="col-12 col-md-6">
                  <?php if(empty($pros)){ ?>
                    <a class="btn btn-secondary w-100 disabled">
                      <i class="fa fa-download me-2"></i> Prospectus not uploaded
                    </a>
                  <?php } else { ?>
                    <a href="../admin/<?php echo $pros; ?>" target="_blank" class="btn btn-primary w-100">
                      <i class="fa fa-download me-2"></i> Prospectus
                    </a>
                  <?php } ?>
                </div>

<div class="col-12 col-md-6">
                  <a href="adminssion-letter" target="_blank" class="btn btn-primary w-100">
                    <i class="fa fa-download me-2"></i> Admission Letter
                  </a>
                </div>

<div class="col-12 col-md-6">
                  <?php if(empty($undertaken)){ ?>
                    <a class="btn btn-secondary w-100 disabled">
                      <i class="fa fa-download me-2"></i> Undertaking not uploaded
                    </a>
                  <?php } else { ?>
                    <a href="../admin/<?php echo $undertaken; ?>" target="_blank" class="btn btn-primary w-100">
                      <i class="fa fa-download me-2"></i> Undertaking / Medical Form
                    </a>
                  <?php } ?>
                </div>

<div class="col-12 col-md-6">
                  <?php if(empty($proGram)){ ?>
                    <a class="btn btn-secondary w-100 disabled">
                      <i class="fa fa-download me-2"></i> Programme / Subject not uploaded
                    </a>
                  <?php } else { ?>
                    <a href="../admin/<?php echo $proGram; ?>" target="_blank" class="btn btn-primary w-100">
                      <i class="fa fa-download me-2"></i> Programme / Subject
                    </a>
                  <?php } ?>
                </div>
              </div>

<div class="alert alert-warning text-center shadow-sm">
                <h5 class="text-danger fw-bold">⚠ IMPORTANT!</h5>
                <p>You are expected to come along with the following on the reporting date:</p>
                <ul class="text-start text-success small d-inline-block">
                  <li>Printed copy of the personal records & declaration forms</li>
                  <li>Fully filled placement forms</li>
                  <li>A copy of your BECE results slip</li>
                  <li>Photocopy of Birth Certificate</li>
                </ul>
                <p class="text-danger fw-bold mt-3">Your admission is NOT complete without these documents.</p>
                <p class="text-muted small mt-3">
                  Note: School administration may reassign students to different houses/beds to maintain balance and diversity.
                </p>
              </div>
            </div>
          </div>

</div>
      </div>
    </div>
  </div>
</section>

<?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/js/pages/dashboard.init.js"></script>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: dashboard-23.php

Server Info

System Features

User Info