public static function AddExtraAttempts($STUDENT_ID, $TEST_ID, $COUNT = 1)
{
global $DB;
$STUDENT_ID = intval($STUDENT_ID);
$TEST_ID = intval($TEST_ID);
$COUNT = intval($COUNT);
$strSql = "SELECT ID, EXTRA_ATTEMPTS FROM b_learn_gradebook WHERE STUDENT_ID = ".$STUDENT_ID." AND TEST_ID = ".$TEST_ID."";
$rs = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
if (!ar == $rs->Fetch())
{
$ID = CGradeBook::Add(Array(
"STUDENT_ID" => $STUDENT_ID,
"TEST_ID" => $TEST_ID,
"RESULT" => "0",
"MAX_RESULT" => "0",
"COMPLETED" => "N",
"EXTRA_ATTEMPTS" => $COUNT
));
return ($ID > 0);
}
else
{
$strSql = "UPDATE b_learn_gradebook SET EXTRA_ATTEMPTS = ".($ar["EXTRA_ATTEMPTS"] + $COUNT)." WHERE ID = ".$ar["ID"];
if (!$DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__))
return false;
}
}
function OnAttemptChange($ATTEMPT_ID, $bCOMPLETED = false)
{
global $DB;
$ATTEMPT_ID = intval($ATTEMPT_ID);
if ($ATTEMPT_ID < 1) {
return false;
}
$strSql = "SELECT A.*, T.APPROVED, T.COMPLETED_SCORE, T.COURSE_ID " . "FROM b_learn_attempt A " . "INNER JOIN b_learn_test T ON A.TEST_ID = T.ID " . "WHERE A.ID = '" . $ATTEMPT_ID . "' AND A.STATUS = 'F' ";
$res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
if (!($arAttempt = $res->Fetch())) {
return false;
}
$COMPLETED = "N";
if ($arAttempt["APPROVED"] == "Y" && intval($arAttempt["COMPLETED_SCORE"]) > 0 && CTestAttempt::IsTestCompleted($ATTEMPT_ID, $arAttempt["COMPLETED_SCORE"])) {
$COMPLETED = "Y";
}
if ($bCOMPLETED) {
$COMPLETED = "Y";
}
$strSql = "UPDATE b_learn_attempt SET COMPLETED = '" . $COMPLETED . "' " . "WHERE ID = '" . $ATTEMPT_ID . "'";
if (!($res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__))) {
return false;
}
$strSql = "SELECT * FROM b_learn_gradebook WHERE STUDENT_ID='" . $arAttempt["STUDENT_ID"] . "' AND TEST_ID='" . $arAttempt["TEST_ID"] . "'";
$res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
if (!($arGradeBook = $res->Fetch())) {
$arFields = array("STUDENT_ID" => $arAttempt["STUDENT_ID"], "TEST_ID" => $arAttempt["TEST_ID"], "RESULT" => $arAttempt["SCORE"], "MAX_RESULT" => intval($arAttempt["MAX_SCORE"]), "COMPLETED" => $COMPLETED);
$at = new CGradeBook();
if (!($res = $at->Add($arFields))) {
return false;
}
CCertification::Certificate($arAttempt["STUDENT_ID"], $arAttempt["COURSE_ID"]);
} else {
$strSql = "SELECT A.SCORE, A.MAX_SCORE FROM b_learn_attempt A " . "WHERE A.STUDENT_ID = '" . $arAttempt["STUDENT_ID"] . "' AND A.TEST_ID = '" . $arAttempt["TEST_ID"] . "' ORDER BY COMPLETED DESC, SCORE DESC";
//AND A.COMPLETED = 'Y'
$res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
if (!($arMaxScore = $res->Fetch())) {
return false;
}
if ($arGradeBook["COMPLETED"] == "Y") {
$COMPLETED = "Y";
}
$strSql = "UPDATE b_learn_gradebook SET RESULT = '" . intval($arMaxScore["SCORE"]) . "', MAX_RESULT = '" . intval($arMaxScore["MAX_SCORE"]) . "',COMPLETED = '" . $COMPLETED . "' " . "WHERE ID = '" . $arGradeBook["ID"] . "'";
if (!($res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__))) {
return false;
}
CCertification::Certificate($arAttempt["STUDENT_ID"], $arAttempt["COURSE_ID"]);
}
return true;
}
