给成绩相同的学生分配相同的等级

Question

我根据学生的分数分配排名，但我遇到了一个问题，如果两个或两个以上的学生有相同的分数，他们被给予不同的排名。

E。约翰、丽塔和玛丽得了76分。约翰第一，丽塔第二，玛丽第三。

约翰

1. = =比;76
2. 丽塔= =比;76
3. 玛丽= =比;76
4. Bukky = =在74年

我想要其中三个的排名是第一。

约翰

1. = =比;76
2. 丽塔= =比;76
3. 玛丽= =比;76
4. Bukky = =在74年

public function getStudentpositionOnlyClass($student_id, $class_id, $terms)
{
$array_product = array();
if ($class_id == 22 || $class_id == 23) {
if ($terms == 'f') {
$totField = 'ft_tot_score';
$table = 'ftscores_rn';
} elseif ($terms == 'm') {
$totField = 'mt_tot_score';
$table = 'mtscores_rn';
} elseif ($terms == 's') {
$totField = 'tot_score';
$table = 'scores_rn';
} elseif ($terms == 'h') {
$totField = 'h_tot_score';
$table = 'hscores_rn';
}
} else {
if ($terms == 'f') {
$totField = 'ft_tot_score';
$table = 'ftscores_primary';
} elseif ($terms == 'm') {
$totField = 'mt_tot_score';
$table = 'mtscores_primary';
} elseif ($terms == 's') {
$totField = 'tot_score';
$table = 'scores_primary';
} elseif ($terms == 'h') {
$totField = 'h_tot_score';
$table = 'hscores_primary';
}
}
$fail = 0;
$pass = 0;
$resultlist = $this->student_model->fullSearchByClass($class_id);
foreach ($resultlist->result_array() as $key => $stdName) {
$idd = $key + 1;
$mId[$idd] = $stdName['pstudent_id'];
$totalSubMarks = $this->db->query(
"SELECT  mts.subject_id
FROM " . $table . " mts
LEFT JOIN subjects sub ON(sub.id=mts.subject_id)
WHERE class_id=" . $class_id .
" AND mts.subject_id IS NOT NULL
GROUP BY mts.subject_id ORDER BY sub.name");
$gtotal = 0;
$totSubjects = 0;
foreach ($totalSubMarks->result_array() as $tmrow) {
$totalMarks = $this->student_model->getTotalMarksForStudnets($tmrow['subject_id'],
$stdName['pstudent_id'], $table, $totField);
// //// set mtotalmark
$gtotal = $gtotal + $totalMarks;
// //// set mgtotal
$mGTotal[$idd] = $gtotal;
if ($totalMarks != 0) {
$totSubjects = $totSubjects + 1;
}
// //// set mAvg
if ($totSubjects != 0) {
$mAvg[$idd] = round($gtotal / $totSubjects, 1);
} else {
$mAvg[$idd] = 0;
}
}
// /////////
if ($totSubjects != 0) {
$percentage = ($gtotal / $totSubjects);
}
if ($percentage >= 0 && $percentage <= 39.99) {
$fail = $fail + 1;
} else {
$pass = $pass + 1;
}
}
foreach ($mAvg as $dd => $val) {
// if pure numbers store in nums array
if (! is_nan($val)) {
$nums[$dd] = $val;
}
}
arsort($nums);
$id = 1;
foreach ($nums as $kk => $av) {
foreach ($totalSubMarks->result_array() as $tmrow) {
$totalMarks = $this->student_model->getTotalMarksForStudnets($tmrow['subject_id'], $mId[$kk], $table,
$totField);
}
if ($student_id == $mId[$kk]) {
return $id;
}
// $array_product['student'.$mId[$kk]]= $id;
$id += 1;
}
}

Answer 1

正如mickmackusa在他的评论中所说，你必须记住以前的分数，只有在分数发生变化时才增加排名。由于您已经排序了您的结果，我们可以假设两次迭代之间的分数变化总是减少的。

你的变量名非常不直观。所以也许我的代码改变在错误的地方，但你应该理解这个概念。我假设$totSubjects就是这个分数。

尽量不要太缩短变量名，因为没有任何好处，只是松散了关于它是什么的重要信息。如果不清楚变量所持有的内容，至少要注释一个变量赋值。

---

像这样修改你的循环:

$previousScore = null;    // added THIS
foreach ($totalSubMarks->result_array() as $tmrow) {
$totalMarks = $this->student_model->getTotalMarksForStudnets($tmrow['subject_id'],
$stdName['pstudent_id'], $table, $totField);
// set mtotalmark
$gtotal = $gtotal + $totalMarks;
// set mgtotal
$mGTotal[$idd] = $gtotal;
if ($totalMarks != 0) {
if($previousScore != $totalMarks) {    // added THIS
$totSubjects = $totSubjects + 1;
} else {                               // added THIS
$totSubjects = $totSubjects;       // keep rank without incrementing
}
}
$previousScore = $totalMarks;       // added THIS
// set mAvg
if ($totSubjects != 0) {
$mAvg[$idd] = round($gtotal / $totSubjects, 1);
} else {
$mAvg[$idd] = 0;
}
}

如果$gtotal或任何其他神秘变量;)持有分数，然后尝试修改我给定的代码更改到$gtotal。应该不会太难。在这种情况下，只需添加注释，这样我就可以更改我的答案，使其实际上是正确的。

希望有帮助!