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'];

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 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'];

$core_sql = "SELECT * FROM student_result 
             WHERE s_code = '$myschoolcode' AND form = '$form' AND term = '$term' AND academicyear = '$semester'
             AND index_number = '$school_ID' 
             AND r_status = 'c'";
$core_subjects = mysqli_query($new, $core_sql);

// Fetch Elective Subjects
$elective_sql = "SELECT * FROM student_result 
                 WHERE s_code = '$myschoolcode' AND form = '$form' AND term = '$term' AND academicyear = '$semester'
                 AND index_number = '$school_ID' 
                 AND r_status = 'e'";
$elective_subjects = mysqli_query($new, $elective_sql);

$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);

}
} else {
    header("location: veiwmyreport");
}
}

<!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'];
// $studentID = mysqli_query($new,"SELECT * FROM enrol_generic WHERE indexNo  = '$code'");
// $stud = mysqli_fetch_array($studentID);
// $getschol = $stud['s_code'];
// $name  = $stud['stud_name'];
// $programme = $stud['programme'];

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

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

<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> MALE</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> N/A</td>
            </tr>
            <tr>
                <td><b>Programme:</b> <?php echo htmlspecialchars($myprogram);?></td>
                <td><b>Next Term Begins:</b> N/A</td>
            </tr>
            <tr>
                <td><b>Student's Average Mark:</b> <?php echo $average_mark;?></td>
                <td><b>Position in Class:</b> <?php echo $studentData['position'];?></td>
            </tr>
        </table>
    </div>

<div class="table-responsive">
        <table>
            <tr>
                <th>S/N</th>
                <th>Subjects</th>
                <th>Class Score (30%)</th>
                <th>Exam Score (70%)</th>
                <th>Total Score (100%)</th>
                <th>Class Average</th>
                <th>Position in Subject</th>
                <th>Grade</th>
                <th>Remarks</th>
                <th>Subject Teacher</th>
            </tr>
            
         <tr><td colspan="10" class="section-title">[CORE SUBJECTS]</td></tr>
        <?php $sn = 1; while($row = $core_subjects->fetch_assoc()): ?>
        <tr>
            <td><?= $sn++ ?></td>
            <td><?= $row['subject'] ?></td>
            <td><?= $row['class_score'] ?></td>
            <td><?= $row['exams_score'] ?></td>
            <td><?= $row['total_score'] ?></td>
            <td><?= $row['class_average'] ?></td>
            <td><?= $row['position'] ?></td>
            <td><?= $row['grading'] ?></td>
            <td><?= $row['remarks'] ?></td>
            <td><?= $row['teacher'] ?></td>
        </tr>
        <?php endwhile; ?>
            
       
        <tr><td colspan="10" class="section-title">[ELECTIVE SUBJECTS]</td></tr>
        <?php while($row = $elective_subjects->fetch_assoc()): ?>
          <tr>
            <td><?= $sn++ ?></td>
            <td><?= $row['subject'] ?></td>
            <td><?= $row['class_score'] ?></td>
            <td><?= $row['exams_score'] ?></td>
            <td><?= $row['total_score'] ?></td>
            <td><?= $row['class_average'] ?></td>
            <td><?= $row['position'] ?></td>
            <td><?= $row['grading'] ?></td>
            <td><?= $row['remarks'] ?></td>
            <td><?= $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