query("SELECT * FROM result_avg WHERE class_name = '$className' AND session = '$session' AND term = '$term' AND position = '0' ") or die($db->error);
if ($check->num_rows) {
echo '
Student Positions in Class Not Set. Click the button below to Generate.
×
';
}else{
// overall already generated
}
?>
query("SELECT signature FROM staff WHERE staff_id = '$staffId'") or die($db->error);
$rowSign = $selectSignature->fetch_assoc();
$formSignature = $rowSign['signature'];
$UpdateSignature = $db->query("UPDATE result_avg SET form_signature = '$formSignature' WHERE class_name = '$className' AND term = '$term' AND
session = '$session'") or die("$db->error");
$check = $db->query("SELECT * FROM users WHERE CLASS = '$className'") or die($db->error);
$totalStudent = $check->num_rows;
$double = 0;
$position = 1;
$resetClassPosition= $db->query("UPDATE result_avg SET position = '' WHERE term = '$term' AND session = '$session' AND class_name='$className'") or die($db->error);
while ( $position <= $totalStudent) {
$getMax = $db->query("
SELECT avg_id, student_id, student_avg FROM result_avg
WHERE class_name = '$className' AND term = '$term' AND
session = '$session' AND position = '' AND student_avg = (SELECT MAX(student_avg) FROM result_avg
WHERE class_name = '$className' AND term = '$term' AND
session = '$session' AND position = '' )
") or die($db->error);
$dublicate = $getMax->num_rows;
if ($getMax->num_rows >= 1) {
foreach ($getMax as $record) {
$avgId = $record['avg_id'];
$studentIdAvg = $record['student_id'];
$studentAvg = $record['student_avg'];
$setPosition = $db->query("UPDATE result_avg SET position = '$position' WHERE avg_id = '$avgId' AND student_id = '$studentIdAvg' ") or die($db->error);
}
}
if ($dublicate > 1) {
$position = $position + $dublicate;
// echo $dublicate;
}
else{
$position = $position + 1;
}
}
echo '
Student Positions in Class Generated Successfuly
×
';
}
?>
############################ SUBJECT POSITIONS ################
query("SELECT * FROM results WHERE class_id = '$classId' AND subject = '$subjectName' AND session = '$session' AND term = '$term' ") or die($db->error);
if($check->num_rows){
$totalStudent = $check->num_rows;
// echo "ckkkkkdddd";
$double = 0;
$position = 1;
while ( $position <= $totalStudent) {
// echo "ckkkkk";
$getMax = $db->query("
SELECT result_id, student_id, total, class_name, term, subject, subject_position, session FROM results
WHERE class_name = '$className' AND subject = '$subjectName' AND term = '$term' AND
session = '$session' AND subject_position = '' AND total = (SELECT MAX(total) FROM results
WHERE class_name = '$className' AND subject = '$subjectName' AND term = '$term' AND
session = '$session' AND subject_position = '' )
") or die($db->error);
$dublicate = $getMax->num_rows;
if ($getMax->num_rows >= 1) {
// echo "$dublicate ";
foreach ($getMax as $record) {
$resultId = $record['result_id'];
$studentIdSub = $record['student_id'];
$studentTotal = $record['total'];
$term = $record['term'];
$session = $record['session'];
$className = $record['class_name'];
//$position = $record['subject_position'];
// echo "$resultId $studentIdSub $studentTotal $term $className $session $position ";
$setSubjectPosition = $db->query("UPDATE results SET subject_position = '$position' WHERE result_id = '$resultId' AND student_id = '$studentIdSub' ") or die($db->error);
}
}
if ($dublicate > 1) {
$position = $position + $dublicate;
// echo $dublicate;
}
else{
$position = $position + 1;
}
}
echo '
';
}else{
// NO RESULT UPLOADED FOR DAT CLASS
echo "crab";
}
}
?>
query("SELECT * FROM results WHERE class_name = '$className' AND session = '$session' AND term = '$term' AND subject_position = '0' AND subject = '$subjectName' ") or die($db->error);
if ($check->num_rows) {
echo '
Student Positions in Class Not Set. Click the button below to Generate.
×