function CCoursePackage($COURSE_ID)
{
global $DB;
$this->ID = intval($COURSE_ID);
//Course exists?
$res = CCourse::GetByID($this->ID);
if (!($this->arCourse = $res->Fetch())) {
$this->LAST_ERROR = GetMessage("LEARNING_BAD_COURSE_ID_EX");
return false;
}
$res = CCourse::GetSite($this->ID);
if ($arSite = $res->GetNext()) {
$charset = $arSite["CHARSET"];
} else {
$this->LAST_ERROR = GetMessage("LEARNING_BAD_SITE_ID_EX");
return false;
}
//Define charset
if (strlen($charset) <= 0) {
if (defined("SITE_CHARSET") && strlen(SITE_CHARSET) > 0) {
$charset = SITE_CHARSET;
} else {
$charset = "windows-1251";
}
}
$this->charset = $charset;
//Get chapters, lessons, questions
$this->_GetCourseContent($this->arCourse['LESSON_ID']);
//Get tests
$strSql = "SELECT T.*, " . $DB->DateToCharFunction("T.TIMESTAMP_X") . " as TIMESTAMP_X " . "FROM b_learn_test T " . "WHERE T.COURSE_ID = " . intval($this->ID) . " " . "ORDER BY SORT ASC ";
$res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
while ($arRes = $res->Fetch()) {
$r = ++$this->RefID;
$this->arItems[$r] = $this->_CreateContent("TES", $arRes, $r);
$this->strItems .= '<item identifier="TES' . $r . '" identifierref="RES' . $r . '"><title>' . htmlspecialcharsbx($arRes["NAME"]) . '</title>';
$marksRes = $DB->Query("SELECT * FROM b_learn_test_mark WHERE TEST_ID = '" . (string) (int) $arRes['ID'] . "'", false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
while ($arMarksRes = $marksRes->Fetch()) {
$r = ++$this->RefID;
$this->arItems[$r] = $this->CreateTMK($arMarksRes, $r);
$this->strItems .= '<item identifier="TMK' . $r . '" identifierref="RES' . $r . '">' . '<title>' . htmlspecialcharsbx($arMarksRes['MARK'] . ' (' . $arMarksRes['DESCRIPTION'] . ')') . '</title>' . '</item>';
}
$this->strItems .= '</item>';
$this->strResourses .= '<resource identifier="RES' . $r . '" type="webcontent" href="res' . $r . '.xml">' . $this->_GetResourceFiles($r) . '</resource>';
}
}
} else {
$APPLICATION->SetTitle(GetMessage('LEARNING_ACCESS_D'));
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_after.php";
$aContext = array(array("ICON" => "btn_list", "TEXT" => GetMessage("LEARNING_BACK_TO_ADMIN"), "LINK" => "learn_unilesson_admin.php?lang=" . LANG . '&PARENT_LESSON_ID=-1' . GetFilterParams("filter_"), "TITLE" => GetMessage("LEARNING_BACK_TO_ADMIN")));
$context = new CAdminContextMenu($aContext);
$context->Show();
CAdminMessage::ShowMessage(GetMessage("LEARNING_BAD_COURSE"));
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/epilog_admin.php";
die;
}
}
if ($res === false || !$res->ExtractFields("str_")) {
$COURSE_ID = 0;
} else {
$str_SITE_ID = array();
$db_SITE_ID = CCourse::GetSite($COURSE_ID);
while ($ar_SITE_ID = $db_SITE_ID->Fetch()) {
$str_SITE_ID[] = $ar_SITE_ID["LID"];
}
}
require $_SERVER["DOCUMENT_ROOT"] . BX_ROOT . "/modules/main/include/prolog_admin_after.php";
if ($bVarsFromForm) {
$str_SITE_ID = $SITE_ID;
$ACTIVE = $ACTIVE != "Y" ? "N" : "Y";
/**
* Resolving dependencies for new data structure
* was:
* $DB->InitTableVarsForEdit("b_learn_course", "", "str_");
*/
$arVarsOnForm = array('COURSE_ID', 'TIMESTAMP_X', 'ACTIVE_FROM', 'ACTIVE_TO', 'ACTIVE', 'CODE', 'NAME', 'SORT', 'RATING', 'RATING_TYPE', 'PREVIEW_TEXT', 'PREVIEW_TEXT_TYPE', 'PREVIEW_PICTURE', 'DETAIL_TEXT', 'DETAIL_TEXT_TYPE', 'DETAIL_PICTURE', 'DESCRIPTION', 'SCORM', 'LAUNCH');
foreach ($arVarsOnForm as $k => $varName) {
public function BuildList()
{
global $USER;
$filterParams = GetFilterParams('filter_');
// list's footer
$this->oList->AddFooter(array(array('title' => GetMessage('MAIN_ADMIN_LIST_SELECTED'), 'value' => $this->rsData->SelectedRowsCount()), array('counter' => true, 'title' => GetMessage('MAIN_ADMIN_LIST_CHECKED'), 'value' => '0')));
$oParentPath = new CLearnPath();
if (isset($_GET['LESSON_PATH'])) {
$oParentPath->ImportUrlencoded($_GET['LESSON_PATH']);
}
$arParentPath = $oParentPath->GetPathAsArray();
// building list
while ($arRes = $this->rsData->NavNext(false)) {
$oCurPath = new CLearnPath();
$oCurPath->SetPathFromArray(array_merge($arParentPath, array($arRes['LESSON_ID'])));
$urlCurPath = $oCurPath->ExportUrlencoded();
unset($oCurPath);
// PUBLISH_PROHIBITED available in context of most parent course only
if ($this->contextCourseLessonId !== false) {
$arRes['PUBLISH_PROHIBITED'] = 'N';
if (CLearnLesson::IsPublishProhibited($arRes['LESSON_ID'], $this->contextCourseLessonId)) {
$arRes['PUBLISH_PROHIBITED'] = 'Y';
}
}
$arRes['SITE_ID'] = '';
$courseId = CLearnLesson::GetLinkedCourse($arRes['LESSON_ID']);
if ($courseId !== false) {
$hrefPrefix = 'learn_course_edit.php?COURSE_ID=' . $courseId;
$resCourseSites = CCourse::GetSite($courseId);
while ($arCourseSites = $resCourseSites->Fetch()) {
if ($arRes['SITE_ID'] != '') {
$arRes['SITE_ID'] .= ' / ';
}
$arRes['SITE_ID'] .= htmlspecialcharsbx($arCourseSites['LID']);
}
} else {
$hrefPrefix = 'learn_unilesson_edit.php?LESSON_ID=' . $arRes['LESSON_ID'] . '&LESSON_PATH=' . urlencode($urlCurPath);
}
$actionEditLesson = $hrefPrefix . '&lang=' . LANG . $filterParams;
$rowAction = false;
$rowTitle = '';
if (!$this->IsSearchMode()) {
$rowAction = 'learn_unilesson_admin.php?lang=' . LANG . '&set_filter=Y' . '&PARENT_LESSON_ID=' . ($arRes['LESSON_ID'] + 0) . '&LESSON_PATH=' . $urlCurPath . '&' . $this->hrefSearchRetPoint;
$rowTitle = GetMessage('LEARNING_TRAVERSE');
// "Traverse list of immediate childs"
if (!$arRes['IS_CHILDS']) {
$rowAction = $actionEditLesson;
$rowTitle = GetMessage('LEARNING_EDIT_TITLE');
}
}
$row =& $this->oList->AddRow($arRes['LESSON_ID'], $arRes, $rowAction, $rowTitle);
$arParents = $arChilds = array();
$htmlParents = $htmlChilds = '';
$rsParents = CLearnLesson::GetListOfImmediateParents($arRes['LESSON_ID'], array(), array('CHECK_PERMISSIONS' => 'N'));
while ($arParent = $rsParents->Fetch()) {
$arParents[] = $arParent['NAME'];
}
$arParents = array_map('htmlspecialcharsbx', $arParents);
if (count($arParents) > 0) {
$htmlParents = implode('<hr width="100%" size="1">', $arParents);
} else {
$htmlParents = ' ';
}
$rsChilds = CLearnLesson::GetListOfImmediateChilds($arRes['LESSON_ID'], array(), array('CHECK_PERMISSIONS' => 'N'));
while ($arChild = $rsChilds->Fetch()) {
$arChilds[] = $arChild['NAME'];
}
$arChilds = array_map('htmlspecialcharsbx', $arChilds);
if (count($arChilds) > 0) {
$htmlChilds = implode('<hr width="100%" size="1">', $arChilds);
} else {
$htmlChilds = ' ';
}
if (isset($arRes['LINKED_LESSON_ID']) && $arRes['LINKED_LESSON_ID'] > 0) {
$icon = 'learning_icon_courses';
} elseif (count($arChilds) > 0) {
$icon = 'learning_icon_chapters';
} else {
$icon = 'learning_icon_lessons';
}
if (!$this->IsSearchMode()) {
$row->AddViewField('NAME', '<span class="adm-list-table-icon-link"><span class="adm-submenu-item-link-icon adm-list-table-icon ' . $icon . '"></span>' . ($rowAction === false ? '<span class="adm-list-table-link">' . htmlspecialcharsbx($arRes['NAME']) . '</span>' : '<a href="' . $rowAction . '" class="adm-list-table-link">' . htmlspecialcharsbx($arRes['NAME']) . '</a>') . '</span>');
} else {
$actionUseLesson = "(function()\n\t\t\t\t\t{\n\t\t\t\t\t\tvar fnName = '" . str_replace(array("'", ';', ',', "\n", "\r"), '', htmlspecialcharsbx($this->search_retpoint)) . "';\n\t\t\t\t\t\tif ( ! (window.opener && window.opener[fnName]) )\n\t\t\t\t\t\t\treturn;\n\n\t\t\t\t\t\twindow.opener[fnName]('" . (int) $arRes['LESSON_ID'] . "', '" . CUtil::JSEscape(htmlspecialcharsbx($arRes['NAME'])) . "');\n\t\t\t\t\t\twindow.close();\n\t\t\t\t\t})();\n\t\t\t\t\t";
$row->AddViewField('NAME', '<a href="javascript:void(0);" class="adm-list-table-icon-link" onclick="' . $actionUseLesson . '"><span class="adm-submenu-item-link-icon adm-list-table-icon ' . $icon . '"></span><span class="adm-list-table-link">' . htmlspecialcharsbx($arRes['NAME']) . '</span></a>');
}
$row->AddViewField('PARENTS', $htmlParents);
$row->AddEditField('PARENTS', ' ');
$row->AddViewField('CHILDS', $htmlChilds);
$row->AddEditField('CHILDS', ' ');
// this is very heavy statistic, so will be a good idea to add settings to the module, which turn off this statistics
$oLearnTree = CLearnLesson::GetTree($arRes['LESSON_ID']);
$arTree = $oLearnTree->GetTreeAsList();
$depth = -1;
$chapterCount = 0;
$lessonsCount = 0;
$questionsCount = CLQuestion::GetCount(array('LESSON_ID' => (int) $arRes['LESSON_ID']));
foreach ($arTree as $arLessonData) {
if ($arLessonData['IS_CHILDS']) {
++$chapterCount;
} else {
++$lessonsCount;
}
if ((int) $arLessonData['#DEPTH_IN_TREE'] > $depth) {
$depth = (int) $arLessonData['#DEPTH_IN_TREE'];
}
$questionsCount += CLQuestion::GetCount(array('LESSON_ID' => (int) $arLessonData['LESSON_ID']));
}
// PUBLISH_PROHIBITED available in context of most parent course only
if ($this->contextCourseLessonId !== false) {
if ($this->IsLessonUpdateAccess($arRes['LESSON_ID']) === true) {
$row->AddInputField('PUBLISH_PROHIBITED', array('size' => '35'));
$row->AddCheckField('PUBLISH_PROHIBITED');
} else {
$row->AddCheckField('PUBLISH_PROHIBITED', true);
}
}
// Render CARDINALITY fields
$htmlDepth = (int) ($depth + 1);
$htmlChapters = (string) (int) $chapterCount . ' [<a href="learn_unilesson_edit.php?lang=' . LANG . '&PROPOSE_RETURN_LESSON_PATH=' . $urlCurPath . '" title="' . GetMessage('LEARNING_UNILESSON_ADD') . '"' . '>+</a>]';
$htmlLessons = (string) (int) $lessonsCount . ' [<a href="learn_unilesson_edit.php?lang=' . LANG . '&PROPOSE_RETURN_LESSON_PATH=' . $urlCurPath . '" title="' . GetMessage('LEARNING_UNILESSON_ADD') . '"' . '>+</a>]';
$htmlQuestions = '<a href="learn_question_admin.php?lang=' . LANG . '&filter=Y&set_filter=Y' . '&PARENT_LESSON_ID=' . ($arRes['LESSON_ID'] + 0) . '&LESSON_PATH=' . $urlCurPath . '" title="' . GetMessage('LEARNING_QUESTION_ALT') . '">' . (int) $questionsCount . '</a>' . ' [' . '<a href="learn_question_edit.php?lang=' . LANG . '&LESSON_PATH=' . $urlCurPath . '&QUESTION_TYPE=S' . '&filter=Y&set_filter=Y' . '&from=learn_menu"' . ' title="' . GetMessage('LEARNING_QUESTION_ADD') . '">+</a>' . ']';
$row->AddViewField('CARDINALITY_DEPTH', $htmlDepth);
$row->AddViewField('CARDINALITY_CHAPTERS', $htmlChapters);
$row->AddViewField('CARDINALITY_LESSONS', $htmlLessons);
$row->AddViewField('CARDINALITY_QUESTIONS', $htmlQuestions);
if ($courseId !== false) {
$testsCount = (int) CTest::GetCount(array('COURSE_ID' => $courseId));
$htmlTests = '<a href="learn_test_admin.php?lang=' . LANG . '&COURSE_ID=' . $courseId . '&PARENT_LESSON_ID=' . (int) $arRes['LESSON_ID'] . '&LESSON_PATH=' . $urlCurPath . '&filter=Y&set_filter=Y"' . '>' . $testsCount . '</a>' . ' [<a href="learn_test_edit.php?lang=' . LANG . '&COURSE_ID=' . $courseId . '&PARENT_LESSON_ID=' . (int) $arRes['LESSON_ID'] . '&LESSON_PATH=' . $urlCurPath . '&filter=Y&set_filter=Y"
title="' . GetMessage('LEARNING_QUESTION_ADD') . '"' . '>+</a>]';
$row->AddViewField('CARDINALITY_TESTS', $htmlTests);
}
if (!$this->IsSearchMode() && $this->IsLessonUpdateAccess($arRes['LESSON_ID']) === true) {
$row->AddInputField('NAME', array('size' => '35'));
// SORT field editing possibly only for courses and for lessons in relation to parent lesson
if ($this->IsListChildLessonsMode() || $this->IsListAnyCoursesMode()) {
$row->AddInputField('SORT', array('size' => '3'));
}
$row->AddCheckField('ACTIVE');
$row->AddInputField('CODE');
} else {
$row->AddCheckField('ACTIVE', false);
}
$row->AddViewField('CREATED_USER_NAME', $arRes['CREATED_USER_NAME']);
$arActions = array();
if (!$this->IsSearchMode()) {
if ($this->IsLessonUpdateAccess($arRes['LESSON_ID']) === true) {
$editTxt = GetMessage('MAIN_ADMIN_MENU_EDIT');
} else {
$editTxt = GetMessage('MAIN_ADMIN_MENU_OPEN');
}
// Actions
$arActions[] = array('ICON' => 'edit', 'TEXT' => $editTxt, 'ACTION' => $this->oList->ActionRedirect($actionEditLesson));
$arActions[] = array("SEPARATOR" => true);
$arActions[] = array('ICON' => 'list', 'TEXT' => GetMessage('LEARNING_QUESTION_ALT') . ' (' . ($questionsCount + 0) . ')', 'ACTION' => $this->oList->ActionRedirect('learn_question_admin.php?lang=' . LANG . '&filter=Y&set_filter=Y' . '&PARENT_LESSON_ID=' . ($arRes['LESSON_ID'] + 0) . '&LESSON_PATH=' . urlencode($urlCurPath)));
/*
$arActions[] = array(
"ICON"=>"copy",
"TEXT"=>GetMessage("MAIN_ADMIN_ADD_COPY"),
"ACTION"=>$this->oList->ActionRedirect("learn_course_edit.php?COPY_ID=".$f_ID));
*/
$isDeleteCmdDisabled = true;
$isDisbandCmdDisabled = true;
$deleteMSG = '';
$disbandMSG = '';
$actionDisband = '';
$action = '';
if ($arRes['CHILDS_CNT'] > 0) {
$deleteMSG = GetMessage('LEARNING_ADMIN_MENU_DELETE_RECURSIVE') . ' (' . (string) (int) $arRes['CHILDS_CNT'] . ')';
} else {
$deleteMSG = GetMessage("MAIN_ADMIN_MENU_DELETE");
}
$disbandMSG = GetMessage('LEARNING_ADMIN_MENU_DISBAND');
$isEnoughRightsForDisbandLesson = false;
try {
$this->EnsureLessonDisbandAccess($arRes['LESSON_ID']);
$isEnoughRightsForDisbandLesson = true;
} catch (CLearnRenderAdminUnilessonListException $e) {
if ($e->GetCode() & CLearnRenderAdminUnilessonListException::C_ACCESS_DENIED) {
} else {
// bubble exception
throw new CLearnRenderAdminUnilessonListException($e->GetMessage(), $e->GetCode());
}
}
// If we can unlink all neighbours and remove lesson
if ($isEnoughRightsForDisbandLesson) {
$arOPathes = CLearnLesson::GetListOfParentPathes($arRes['LESSON_ID']);
$parentPathesCnt = count($arOPathes);
// prepare "Disband" command
$isDisbandCmdDisabled = false;
$actionDisband = $this->oList->ActionDoGroup($arRes['LESSON_ID'], 'disband', 'PARENT_LESSON_ID=' . ($this->requestedParentLessonId + 0));
if ($parentPathesCnt >= 1) {
$actionDisband = "if(confirm('" . str_replace('#CNT#', $parentPathesCnt, GetMessageJS('LEARNING_CONFIRM_DISBAND_LESSON_WITH_PARENT_PATHES')) . "')) " . '{ ' . $actionDisband . ' }';
}
$actionDisband = "if(confirm('" . GetMessageJS('LEARNING_ADMIN_MENU_DISBAND_QUESTION') . "')) " . '{ ' . $actionDisband . ' }';
// prepare "Remove" command
$isDeleteCmdDisabled = false;
if ($arRes['CHILDS_CNT'] > 0) {
$action = $this->oList->ActionDoGroup($arRes['LESSON_ID'], 'recursive_delete', 'PARENT_LESSON_ID=' . ($this->requestedParentLessonId + 0));
} else {
// If no childs => "delete" is equal to "disband"
$action = $this->oList->ActionDoGroup($arRes['LESSON_ID'], 'disband', 'PARENT_LESSON_ID=' . ($this->requestedParentLessonId + 0));
}
if ($parentPathesCnt >= 1) {
$deleteMSG .= ' [' . $parentPathesCnt . ']';
$action = "if(confirm('" . str_replace('#CNT#', $parentPathesCnt, GetMessageJS("LEARNING_CONFIRM_DEL_LESSON_WITH_PARENT_PATHES")) . "')) " . $action;
} else {
$action = "if(confirm('" . GetMessageJS('LEARNING_CONFIRM_DEL_MESSAGE') . "')) " . $action;
}
}
// We can "disband" only lessons, that contains childs
$arActions[] = array("SEPARATOR" => true);
if ($arRes['CHILDS_CNT'] > 0) {
$arActions[] = array('ICON' => 'delete', 'TEXT' => $disbandMSG, 'ACTION' => $actionDisband, 'DISABLED' => $isDisbandCmdDisabled, 'TITLE' => GetMessage('LEARNING_ADMIN_MENU_DISBAND_TITLE'));
}
$arActions[] = array('ICON' => 'delete', 'TEXT' => $deleteMSG, 'ACTION' => $action, 'DISABLED' => $isDeleteCmdDisabled);
} else {
$arActions[] = array('ICON' => 'list', 'TEXT' => GetMessage('LEARNING_SELECT'), 'ACTION' => $actionUseLesson);
}
$row->AddActions($arActions);
}
return $this;
}
