MAINHACK

Viewing / Editing File: main.php

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

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

function ordinal($num) {
  $ends = ['th','st','nd','rd','th','th','th','th','th','th'];
  if (($num % 100) >= 11 && ($num % 100) <= 13)
      return $num.'th';
  else
      return $num.$ends[$num % 10];
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (!empty($_POST['semesterSelect'])) {
        // Get the raw value from POST
        $value = $_POST['semesterSelect'];

// Split it back into form, semester, and term
        list($form, $semester, $term) = explode('-', $value);

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

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

// Class name 
$studentD = mysqli_query($new,"
    SELECT 
        CASE 
            WHEN TRIM(enrol_details.classname) = '' OR enrol_details.classname IS NULL 
            THEN class.class_name 
            ELSE enrol_details.classname 
        END AS class_name
    FROM enrol_details
    LEFT JOIN class ON enrol_details.class_id = class.cid
    WHERE enrol_details.schoolID = '$school_ID'
");

$getinfo = mysqli_fetch_assoc($studentD);
$c_name = $getinfo['class_name'];

// House name
$getHow = mysqli_query($new,"
    SELECT 
        CASE 
            WHEN TRIM(enrol_details.housename) = '' OR enrol_details.housename IS NULL 
            THEN house.house_name 
            ELSE enrol_details.housename 
        END AS house_name
    FROM enrol_details
    LEFT JOIN house ON enrol_details.house_id = house.hid
    WHERE enrol_details.schoolID = '$school_ID'
");

$hname = mysqli_fetch_assoc($getHow);
$house_name = $hname['house_name'];

$stuname = mysqli_query($new,"SELECT student_name FROM enrol_details WHERE schoolID = '$school_ID'");
$getthisname = mysqli_fetch_array($stuname);
$stname = $getthisname['student_name'];

// Step 1: Get total score per student
$sql = "SELECT index_number, SUM(total_score) AS total_score
        FROM student_result WHERE  form = '$form' AND term = '$term' AND academicyear = '$semester'
        GROUP BY index_number
        ORDER BY total_score DESC";

$result = mysqli_query($new, $sql);

$students = [];
while ($row = mysqli_fetch_assoc($result)) {
    $students[] = $row;
}

// Step 2: Assign positions (handling ties)
$rank = 0;
$prevScore = null;
$skip = 0;

foreach ($students as $index => $student) {
    if ($prevScore !== $student['total_score']) {
        $rank = $index + 1;
        $rank += $skip;
        $skip = 0;
    } else {
        $skip++;
    }
    $students[$index]['position'] = $rank;
    $prevScore = $student['total_score'];
}

// Step 3: Find logged-in student's record
$studentData = null;
foreach ($students as $student) {
    if ($student['index_number'] == $school_ID) {
        $studentData = $student;
        break;
    }
}

$getprogram = mysqli_query($new,"SELECT DISTINCT programme,date_vacated,next_term_date FROM student_result 
             WHERE s_code = '$myschoolcode' AND form = '$form' AND term = '$term' AND academicyear = '$semester'
             AND index_number = '$school_ID'");

$thisprogram = mysqli_fetch_array($getprogram);
$myprogram = $thisprogram['programme'];
$date_vacated = $thisprogram['date_vacated'];
$next_term_date = $thisprogram['next_term_date'];

$core_sql = "
SELECT 
    sr.subject,
    sr.class_score,
    sr.exams_score,
    sr.total_score,
    sr.grading,
    sr.remarks,
    sr.teacher,

-- class average for this subject
    ROUND((
        SELECT AVG(sr2.class_score * 0.3 + sr2.exams_score * 0.7)
        FROM student_result sr2
        WHERE sr2.s_code = sr.s_code
          AND sr2.form = '$form'
          AND sr2.term = '$term'
          AND sr2.academicyear = '$semester'
          AND sr2.subject = sr.subject
          AND sr2.publish = 'publish'
    ), 2) AS class_average,

-- subject-based position
    (
        SELECT COUNT(*) + 1
        FROM student_result r2
        WHERE r2.s_code = sr.s_code
          AND r2.form = '$form'
          AND r2.term = '$term'
          AND r2.academicyear = '$semester'
          AND r2.subject = sr.subject
        AND r2.publish = 'publish'
          AND (r2.class_score * 0.3 + r2.exams_score * 0.7) > (sr.class_score * 0.3 + sr.exams_score * 0.7)
    ) AS subject_position

FROM student_result sr
WHERE sr.s_code = '$myschoolcode'
  AND sr.form = '$form'
  AND sr.term = '$term'
  AND sr.academicyear = '$semester'
  AND sr.index_number = '$school_ID'
  AND sr.r_status = 'c'
AND sr.publish = 'publish'
ORDER BY sr.subject ASC;
";

$core_subjects = mysqli_query($new, $core_sql);

// --- ELECTIVE SUBJECTS ---
$elective_sql = "
SELECT 
    sr.subject,
    sr.class_score,
    sr.total_score,
    sr.exams_score,
    sr.grading,
    sr.remarks,
    sr.teacher,

-- subject-based position
    (
        SELECT COUNT(*) + 1
        FROM student_result r2
        WHERE r2.s_code = sr.s_code
          AND r2.form = '$form'
          AND r2.term = '$term'
          AND r2.academicyear = '$semester'
          AND r2.subject = sr.subject
         AND r2.publish = 'publish'
          AND (r2.class_score * 0.3 + r2.exams_score * 0.7) > (sr.class_score * 0.3 + sr.exams_score * 0.7)
    ) AS subject_position

FROM student_result sr
WHERE sr.s_code = '$myschoolcode'
  AND sr.form = '$form'
  AND sr.term = '$term'
  AND sr.academicyear = '$semester'
  AND sr.index_number = '$school_ID'
  AND sr.r_status = 'e'
   AND sr.publish = 'publish'
ORDER BY sr.subject ASC;
";

$elective_subjects = mysqli_query($new, $elective_sql);

$total_avg_sql = "
SELECT ROUND(AVG(class_score * 0.3 + exams_score * 0.7), 2) AS total_average
FROM student_result
WHERE s_code = '$myschoolcode'
  AND form = '$form'
  AND term = '$term'
  AND academicyear = '$semester'
   AND publish = 'publish'
  AND index_number = '$school_ID';
";

$total_avg_result = mysqli_query($new, $total_avg_sql);
$total_avg = mysqli_fetch_assoc($total_avg_result)['total_average'] ?? 0;

$student_average = isset($student_average) ? floatval($student_average) : 0.0;

// Prepared SQL: counts how many students have a higher avg than this student
$position_sql = "
SELECT COUNT(*) + 1 AS position
FROM (
    SELECT index_number, ROUND(AVG(class_score * 0.3 + exams_score * 0.7), 2) AS avg_score
    FROM student_result
    WHERE s_code = ?
      AND form = ?
      AND term = ?
      AND academicyear = ?
    GROUP BY index_number
) AS ranked
WHERE ranked.avg_score > ?
";

try {
    $stmt = $new->prepare($position_sql);
    // types: s=string, d=double (float)
    $stmt->bind_param('ssssd', $myschoolcode, $form, $term, $semester, $student_average);
    $stmt->execute();
    $result = $stmt->get_result();
    $position_row = $result->fetch_assoc();
    $student_position = isset($position_row['position']) ? intval($position_row['position']) : 1;
    $stmt->close();
} catch (Exception $e) {
    // If there's an error, display it (for debugging). Remove or log in production.
    echo "Error computing position: " . htmlspecialchars($e->getMessage());
    // fallback
    $student_position = 1;
}

// Optional: get total students for "X out of Y"
$count_sql = "
SELECT COUNT(DISTINCT index_number) AS total_students
FROM student_result
WHERE s_code = ?
  AND form = ?
  AND term = ?
  AND academicyear = ?
";
try {
    $stmt2 = $new->prepare($count_sql);
    $stmt2->bind_param('ssss', $myschoolcode, $form, $term, $semester);
    $stmt2->execute();
    $res2 = $stmt2->get_result();
    $cnt_row = $res2->fetch_assoc();
    $total_students = isset($cnt_row['total_students']) ? intval($cnt_row['total_students']) : 0;
    $stmt2->close();
} catch (Exception $e) {
    echo "Error counting students: " . htmlspecialchars($e->getMessage());
    $total_students = 0;
}

$sql = "SELECT subject, total_score, grading 
        FROM student_result 
        WHERE s_code = '$myschoolcode' AND form = '$form' AND term = '$term' AND academicyear = '$semester'
        AND index_number = '$school_ID'";
$result = mysqli_query($new, $sql);

// Grade → Point mapping
$grade_points = [
    "A1" => 1, "B2" => 2, "B3" => 3,
    "C4" => 4, "C5" => 5, "C6" => 6,
    "D7" => 7, "E8" => 8, "F9" => 9
];

$subjects = []; // will store [points, score]

// Loop through database rows
while ($row = mysqli_fetch_assoc($result)) {
    $grade = strtoupper(trim($row['grading']));
    $score = floatval($row['total_score']); // make sure it’s numeric

if (!empty($grade) && isset($grade_points[$grade])) {
        $points = $grade_points[$grade];
        $subjects[] = [
            'subject' => $row['subject'],
            'points'  => $points,
            'score'   => $score
        ];
    }
}

// Sort by points (best first)
usort($subjects, function($a, $b) {
    return $a['points'] <=> $b['points']; // lower points = better grade
});

// Pick best 6
$best6 = array_slice($subjects, 0, 6);
// Calculate total points for aggregate
// Calculate average mark
$total_points = array_sum(array_column($best6, 'points'));
$total_score_sum = array_sum(array_column($best6, 'score'));
$average_mark = $total_score_sum / count($best6);

}
}
}

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

</style>
      <style>
    .report-card {
      border: 2px solid #555;
      border-radius: 12px;
      padding: 2rem;
      box-shadow: 0 0 10px rgba(0,0,0,0.05);
    }
    .record-badge {
      background-color: #dc3545;
      color: white;
      font-weight: bold;
    }
    .btn-generate {
      font-size: 1.2rem;
      padding: 0.75rem 1.5rem;
    }
    .dropdown-select {
      font-size: 1.1rem;
      padding: 0.75rem;
    }
  </style>

/* Responsive adjustments */
    @media (max-width: 768px) {
        .container {
            padding: 10px;
        }
        table {
            font-size: 11px;
        }
        th, td {
            padding: 3px;
        }
    }
    @media (max-width: 600px) {
        .header img {
            width: 60px;
        }
        .header h2 {
            font-size: 14px;
        }
        .header p {
            font-size: 11px;
        }
        .table-responsive {
            overflow-x: auto;
        }
    }
</style>
</head>

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

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

<?php 
$code = $_SESSION['index_no78897498'];

$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="container">
    <div class="header">
     <img src="<?php echo $logo; ?>" class="rounded-circle shadow" style="width: 100px; height: 100px;" alt="Student Photo">
        <h2><?php echo htmlspecialchars($school_name);?> - <?php echo htmlspecialchars($school_region);?></h2>
        <p><?php echo htmlspecialchars($school_location);?> - <?php echo htmlspecialchars($school_region);?></p>
        <p>Telephone: <?php echo htmlspecialchars($phone_num);?> | E-mail: <?php echo htmlspecialchars($school_email);?></p>
        <h3>STUDENT'S REPORT</h3>
    </div>

<div class="table-responsive">
        <table>
            <tr>
                <td><b>Student Name:</b> <?php echo htmlspecialchars($stname);?></td>
                <td><b>Gender:</b> <?php

$myschoolcode = $_SESSION['myschoolcode'];
$myindexNo = $_SESSION['index_no78897498'];

$getgender = mysqli_query($new,"SELECT gender FROM enrol_generic  WHERE indexNo = '$myindexNo' and s_code = '$myschoolcode'");
$getthis = mysqli_fetch_array($getgender);
echo $genderD = empty($getthis['gender']) ? 'None' : $getthis['gender'];

;?>
</td>
            </tr>
            <tr>
                <td><b>Student ID:</b> <?php echo htmlspecialchars($school_ID);?></td>
                <td><b>Academic Year:</b> <?php echo htmlspecialchars($semester);?> <?php echo $term;?>: <?php echo htmlspecialchars($form);?></td>
            </tr>
            <tr>
                <td><b>Class:</b> <?php echo htmlspecialchars($c_name);?></td>
                <td><b>Date Vacated:</b> <?php echo $date_vacated;?></td>
            </tr>
            <tr>
                <td><b>Programme:</b> <?php echo htmlspecialchars($myprogram);?></td>
                <td><b>Next Term Begins:</b> <?php echo $next_term_date;?></td>
            </tr>
            <tr>
                <td><b>Student's Average Mark:</b> <?php echo $total_avg;?></td>
                
            </tr>
        </table>
    </div>

<div class="table-responsive">
       <table border="1" cellspacing="0" cellpadding="5" width="100%">
    <tr>
        <th>S/N</th>
        <th>Subjects</th>
        <th>Class (30%)</th>
        <th>Exam (70%)</th>
        <th>Total (100%)</th>
        <th>Class Average</th>
        
        <th>Grade</th>
        <th>Remarks</th>
        <th>Subject Teacher</th>
    </tr>

<tr><td colspan="9" class="section-title">[CORE SUBJECTS]</td></tr>
    <?php $sn = 1; while($row = mysqli_fetch_assoc($core_subjects)): ?>
    <tr>
        <td><?= $sn++ ?></td>
                      <td style="text-align: justify;">
  <?= htmlspecialchars($row['subject']) ?>
</td>
        <td><?= number_format($row['class_score'], 2) ?></td>
        <td><?= number_format($row['exams_score'], 2) ?></td>
        <td><?= number_format($row['total_score'], 2) ?></td>
        <td><?= number_format($row['class_average'], 2) ?></td>
       
        <td><?= htmlspecialchars($row['grading']) ?></td>
        <td><?= htmlspecialchars($row['remarks']) ?></td>
      <td style="text-align: justify;">
  <?= htmlspecialchars($row['teacher']) ?>
</td>

</tr>
    <?php endwhile; ?>

<tr><td colspan="9" class="section-title">[ELECTIVE SUBJECTS]</td></tr>
    <?php while($row = mysqli_fetch_assoc($elective_subjects)): ?>
    <tr>
        <td><?= $sn++ ?></td>
              <td style="text-align: justify;">
  <?= htmlspecialchars($row['subject']) ?>
</td>
        <td><?= number_format($row['class_score'], 2) ?></td>
        <td><?= number_format($row['exams_score'], 2) ?></td>
        <td><?= number_format($row['total_score'], 2) ?></td>
        <td><?= number_format($row['class_average'], 2) ?></td>
        
        <td><?= htmlspecialchars($row['grading']) ?></td>
        <td><?= htmlspecialchars($row['remarks']) ?></td>
              <td style="text-align: justify;">
  <?= htmlspecialchars($row['teacher']) ?>
</td>
    </tr>
    <?php endwhile; ?>
</table>
    </div>

<div class="remarks">
        
        <p><b>AGGREGATE OF BEST SIX RESULTS:</b> <?php echo $total_points;?></p>

    </div>

<div class="footer">
        <p><b>Disclaimer:</b> This is NOT a Certified Terminal Report...</p>
    </div>

<div class="grade-interpretation">
        <p>80 to 100 = A+ EXCELLENT; 75 to 79 = B2 VERY GOOD; 70 to 74 = B3 GOOD; 65 to 69 = C4 CREDIT; 60 to 64 = C5 CREDIT; 55 to 59 = C6 CREDIT; 50 to 54 = D7 PASS; 40 to 49 = E8 WEAK PASS; 0 to 39 = F9 FAIL</p>
    </div>
</div>

<div style="margin-top: 20px; text-align: center;">
    <button onclick="printReport()">Print Report</button>
    
</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/js/pages/dashboard.init.js"></script>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: main.php

Server Info

System Features

User Info