*/
$app->before('GET|POST', '/fgrade/(\\d+)/', function () {
if (!hasPermission('submit_final_grades')) {
redirect(get_base_url() . 'dashboard' . '/');
}
});
$app->match('GET|POST', '/fgrade/(\\d+)/', function ($id) use($app, $css, $js, $flashNow) {
if ($app->req->isPost()) {
$size = count($_POST['stuID']);
$i = 0;
while ($i < $size) {
$grade = $app->db->stu_acad_cred();
$grade->grade = $_POST['grade'][$i];
$grade->gradePoints = acadCredGradePoints($_POST['grade'][$i], $_POST['attCredit']);
$grade->where('stuID = ?', $_POST['stuID'][$i])->_and_()->where('courseSecID = ?', $id)->update();
if (acadCredGradePoints($_POST['grade'][$i], $_POST['attCredit']) > 0) {
$compCred = $_POST['attCredit'];
} else {
$compCred = '0';
}
$grade = $app->db->stu_acad_cred();
$grade->compCred = $compCred;
$grade->where('stuID = ?', $_POST['stuID'][$i])->_and_()->where('courseSecID = ?', $id)->update();
etsis_logger_activity_log_write('Update Record', 'Final Grade', get_name($_POST['stuID'][$i]) . ' (' . $_POST['termCode'] . '-' . $_POST['courseSecCode'] . ')', get_persondata('uname'));
++$i;
}
redirect($app->req->server['HTTP_REFERER']);
}
$sect = get_course_sec($id);
$fgrade = $app->db->course_sec()->select('course_sec.courseSecID,course_sec.secShortTitle,course_sec.minCredit,course_sec.courseSection,course_sec.facID')->select('b.stuID,b.courseSecCode,b.courseSection,b.termCode,b.grade')->_join('stu_acad_cred', 'course_sec.courseSecID = b.courseSecID', 'b')->where('course_sec.courseSecID = ?', $id);
$q = $fgrade->find(function ($data) {
$detail->compCred = '0.0';
$detail->gradePoints = acadCredGradePoints($_POST['grade'], '0.0');
$detail->statusTime = $time;
if (empty($_POST['grade'])) {
$detail->grade = "W";
} else {
$detail->grade = $_POST['grade'];
}
} else {
if (acadCredGradePoints($_POST['grade'], $_POST['attCred']) > 0) {
$compCred = $_POST['attCred'];
} else {
$compCred = '0';
}
$detail->compCred = $compCred;
$detail->gradePoints = acadCredGradePoints($_POST['grade'], $_POST['attCred']);
$detail->grade = $_POST['grade'];
}
$detail->where('stuAcadCredID = ?', $id);
/**
* If the posted status is 'W' or 'D' and today's date is less than the
* primary term start date, then delete all student course sec as well as
* student acad cred records.
*/
if (($_POST['status'] == 'W' || $_POST['status'] == 'D') && $date < $term[0]['termStartDate']) {
$q = $app->db->stu_course_sec()->where('stuID = ?', $decode[0]['stuID'])->_and_()->where('courseSection = ?', $decode[0]['courseSection'])->delete();
$q = $app->db->stu_acad_cred()->where('stuAcadCredID = ?', $id)->delete();
if (function_exists('financial_module')) {
$q = $app->db->stu_acct_fee()->where('stuID = ?', $decode[0]['stuID'])->_and_()->where('description = ?', $decode[0]['courseSection'])->delete();
/**
* Begin Updating tuition totals.
