function Delete($ID)
{
global $DB;
$ID = intval($ID);
if ($ID < 1) {
return false;
}
CLearnHelper::FireEvent('OnBeforeCertificateDelete', $ID);
$strSql = "SELECT G.ID FROM b_learn_certification C\n\t\t\t\t\tINNER JOIN b_learn_test T ON C.COURSE_ID = T.COURSE_ID\n\t\t\t\t\tINNER JOIN b_learn_gradebook G ON (G.TEST_ID = T.ID AND G.STUDENT_ID = C.STUDENT_ID)\n\t\t\t\t\tWHERE C.ID = " . $ID;
$res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
//Gradebook
while ($arRecord = $res->Fetch()) {
if (!CGradeBook::Delete($arRecord["ID"])) {
return false;
}
}
$strSql = "DELETE FROM b_learn_certification WHERE ID = " . $ID;
if (!$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__)) {
return false;
}
CLearnHelper::FireEvent('OnAfterCertificateDelete', $ID);
return true;
}
/**
* <p>Метод удаляет учётную запись студента с кодом пользователя USER_ID.</p>
*
*
* @param int $USER_ID Код пользователя. </h
*
* @return bool <p>Метод возвращает <i>true</i> в случае успешного удаления учётной
* записи студента, в противном случае возвращает <i>false</i>.</p>
*
* <h4>Example</h4>
* <pre>
* <?
* if (CModule::IncludeModule("learning"))
* {
* $USER_ID = 3;
* if ($USER->IsAdmin())
* {
* @set_time_limit(0);
* $DB->StartTransaction();
* if (!CStudent::Delete($USER_ID))
* {
* echo "Error!";
* $DB->Rollback();
* }
* else
* $DB->Commit();
* }
* }
* ?>
* </pre>
*
*
* <h4>See Also</h4>
* <ul><li> <a href="http://dev.1c-bitrix.ru/api_help/learning/classes/cstudent/index.php">CStudent</a>::<a
* href="http://dev.1c-bitrix.ru/api_help/learning/classes/cstudent/add.php">Add</a> </li></ul><a name="examples"></a>
*
*
* @static
* @link http://dev.1c-bitrix.ru/api_help/learning/classes/cstudent/delete.php
* @author Bitrix
*/
public static function Delete($ID)
{
global $DB;
$ID = intval($ID);
if ($ID < 1) {
return false;
}
CLearnHelper::FireEvent('OnBeforeStudentDelete', $ID);
//Certification
$records = CCertification::GetList(array(), array("STUDENT_ID" => $ID));
while ($arRecord = $records->Fetch()) {
if (!CCertification::Delete($arRecord["ID"])) {
return false;
}
}
$strSql = "DELETE FROM b_learn_student WHERE USER_ID = " . $ID;
if (!$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__)) {
return false;
}
CLearnHelper::FireEvent('OnAfterStudentDelete', $ID);
return true;
}
function Delete($ID)
{
global $DB;
$ID = intval($ID);
if ($ID < 1) {
return false;
}
CLearnHelper::FireEvent('OnBeforeTestDelete', $ID);
//Gradebook
$records = CGradeBook::GetList(array(), array("TEST_ID" => $ID));
while ($arRecord = $records->Fetch()) {
if (!CGradeBook::Delete($arRecord["ID"])) {
return false;
}
}
//Attempts
$attempts = CTestAttempt::GetList(array(), array("TEST_ID" => $ID));
while ($arAttempt = $attempts->Fetch()) {
if (!CTestAttempt::Delete($arAttempt["ID"])) {
return false;
}
}
//Marks
$marks = CLTestMark::GetList(array(), array("TEST_ID" => $ID));
while ($arMark = $marks->Fetch()) {
if (!CLTestMark::Delete($arMark["ID"])) {
return false;
}
}
$strSql = "DELETE FROM b_learn_test WHERE ID = " . $ID;
if (!$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__)) {
return false;
}
CEventLog::add(array('AUDIT_TYPE_ID' => 'LEARNING_REMOVE_ITEM', 'MODULE_ID' => 'learning', 'ITEM_ID' => 'T #' . $ID, 'DESCRIPTION' => 'test removed'));
CLearnHelper::FireEvent('OnAfterTestDelete', $ID);
return true;
}
public static final function Delete($lesson_id)
{
list($lesson_id, $simulate, $check_permissions, $user_id) = self::_funcDelete_ParseOptions($lesson_id);
if ($check_permissions) {
$oAccess = CLearnAccess::GetInstance($user_id);
if (!$oAccess->IsLessonAccessible($lesson_id, CLearnAccess::OP_LESSON_REMOVE)) {
throw new LearnException('EA_ACCESS_DENIED', LearnException::EXC_ERR_ALL_ACCESS_DENIED);
}
}
// Parents and childs of the lesson
$arNeighboursEdges = self::ListImmediateNeighbours($lesson_id);
// precache rights for lesson
if ($check_permissions) {
$IsLessonAccessibleFor_OP_LESSON_UNLINK_DESCENDANTS = $oAccess->IsLessonAccessible($lesson_id, CLearnAccess::OP_LESSON_UNLINK_DESCENDANTS);
$IsLessonAccessibleFor_OP_LESSON_UNLINK_FROM_PARENTS = $oAccess->IsLessonAccessible($lesson_id, CLearnAccess::OP_LESSON_UNLINK_FROM_PARENTS);
}
if ($simulate === false) {
CLearnHelper::FireEvent('OnBeforeLessonDelete', $lesson_id);
}
foreach ($arNeighboursEdges as $arEdge) {
$child_lesson_id = (int) $arEdge['CHILD_LESSON'];
$parent_lesson_id = (int) $arEdge['PARENT_LESSON'];
if ($check_permissions) {
$IsLessonAccessible = false;
if ($child_lesson_id === $lesson_id) {
// if we will be remove edge to parent - use precached rights for OP_LESSON_UNLINK_FROM_PARENTS
$IsLessonAccessible = $IsLessonAccessibleFor_OP_LESSON_UNLINK_FROM_PARENTS && $oAccess->IsLessonAccessible($parent_lesson_id, CLearnAccess::OP_LESSON_UNLINK_DESCENDANTS);
} elseif ($parent_lesson_id === $lesson_id) {
// if we will be remove edge to child - use precached rights for OP_LESSON_UNLINK_DESCENDANTS
$IsLessonAccessible = $IsLessonAccessibleFor_OP_LESSON_UNLINK_DESCENDANTS && $oAccess->IsLessonAccessible($child_lesson_id, CLearnAccess::OP_LESSON_UNLINK_FROM_PARENTS);
} else {
throw new LearnException('EA_FATAL: $lesson_id (' . $lesson_id . ') not equal to one of: $child_lesson_id (' . $child_lesson_id . '), $parent_lesson_id (' . $parent_lesson_id . ')', LearnException::EXC_ERR_ALL_LOGIC | LearnException::EXC_ERR_ALL_GIVEUP);
}
if (!$IsLessonAccessible) {
throw new LearnException('EA_ACCESS_DENIED', LearnException::EXC_ERR_ALL_ACCESS_DENIED);
}
if ($simulate === false) {
self::RelationRemove($parent_lesson_id, $child_lesson_id);
}
}
}
$linkedCourseId = self::GetLinkedCourse($lesson_id);
// If lesson is course, remove course
if ($linkedCourseId !== false) {
global $DB;
if ($simulate === false) {
if (!$DB->Query("DELETE FROM b_learn_course_site WHERE COURSE_ID = " . (int) $linkedCourseId, true)) {
throw new LearnException('EA_SQLERROR', LearnException::EXC_ERR_ALL_GIVEUP);
}
$rc = self::CourseBecomeLesson($linkedCourseId);
// if course cannot be converted to lesson - don't remove lesson
if ($rc === false) {
throw new LearnException('EA_OTHER: lesson is unremovable because linked course is in use.', LearnException::EXC_ERR_LL_UNREMOVABLE_CL);
}
// reload cache of LINKED_LESSON_ID -> COURSE_ID
self::GetCourseToLessonMap_ReloadCache();
if (CModule::IncludeModule("search")) {
CSearch::DeleteIndex("learning", false, "C" . $linkedCourseId);
CSearch::DeleteIndex("learning", "C" . $linkedCourseId);
}
}
}
// And remove lesson
if ($simulate === false) {
global $DB;
$r = $DB->Query("SELECT PREVIEW_PICTURE, DETAIL_PICTURE \n\t\t\t\tFROM b_learn_lesson \n\t\t\t\tWHERE ID = " . (int) $lesson_id, true);
if ($r === false) {
throw new LearnException('EA_SQLERROR', LearnException::EXC_ERR_ALL_GIVEUP);
}
$arRes = $r->Fetch();
if (!$arRes) {
throw new LearnException('EA_SQLERROR', LearnException::EXC_ERR_ALL_GIVEUP);
}
CFile::Delete($arRes['PREVIEW_PICTURE']);
CFile::Delete($arRes['DETAIL_PICTURE']);
// Remove questions
$q = CLQuestion::GetList(array(), array('LESSON_ID' => $lesson_id));
while ($arQ = $q->Fetch()) {
if (!CLQuestion::Delete($arQ['ID'])) {
throw new LearnException('EA_QUESTION_NOT_REMOVED', LearnException::EXC_ERR_ALL_GIVEUP);
}
}
CLearnGraphNode::Remove($lesson_id);
CLearnCacheOfLessonTreeComponent::MarkAsDirty();
if (CModule::IncludeModule('search')) {
CSearch::DeleteIndex('learning', false, 'L' . $lesson_id);
CSearch::DeleteIndex('learning', 'L' . $lesson_id);
}
}
if ($simulate === false) {
CLearnHelper::FireEvent('OnAfterLessonDelete', $lesson_id);
}
}
/**
* <p>Метод удаляет тест с идентификатором ID.</p>
*
*
*
*
* @param int $ID Идентификатор теста.
*
*
*
* @return bool <p>Метод возвращает <i>true</i> в случае успешного удаления теста, в
* противном случае возвращает <i>false</i>.</p><a name="examples"></a>
*
*
* <h4>Example</h4>
* <pre>
* <?
* if (CModule::IncludeModule("learning"))
* {
*
* $TEST_ID = 99;
* $COURSE_ID = 97;
*
* if (CCourse::GetPermission($COURSE_ID) >= 'W')
* {
* @set_time_limit(0);
* $DB->StartTransaction();
* if (!CTest::Delete($TEST_ID))
* {
* echo "Error!";
* $DB->Rollback();
* }
* else
* $DB->Commit();
* }
* }
* ?>
* </pre>
*
*
* @static
* @link http://dev.1c-bitrix.ru/api_help/learning/classes/ctest/delete.php
* @author Bitrix
*/
public static function Delete($ID)
{
global $DB;
$ID = intval($ID);
if ($ID < 1) return false;
CLearnHelper::FireEvent('OnBeforeTestDelete', $ID);
//Gradebook
$records = CGradeBook::GetList(Array(), Array("TEST_ID" => $ID));
while($arRecord = $records->Fetch())
{
if(!CGradeBook::Delete($arRecord["ID"]))
return false;
}
//Attempts
$attempts = CTestAttempt::GetList(Array(), Array("TEST_ID" => $ID));
while($arAttempt = $attempts->Fetch())
{
if(!CTestAttempt::Delete($arAttempt["ID"]))
return false;
}
//Marks
$marks = CLTestMark::GetList(Array(), Array("TEST_ID" => $ID));
while($arMark = $marks->Fetch())
{
if(!CLTestMark::Delete($arMark["ID"]))
return false;
}
$strSql = "DELETE FROM b_learn_test WHERE ID = ".$ID;
if (!$DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__))
return false;
CLearnHelper::FireEvent('OnAfterTestDelete', $ID);
return true;
}
