PHP get_module_course_tbl函数代码示例

 public function __construct($courseId)
 {
     $tbl_cdb_names = get_module_course_tbl(array('qwz_exercise', 'qwz_tracking', 'qwz_tracking_questions', 'qwz_tracking_answers'), $courseId);
     $this->tbl_qwz_tracking = $tbl_cdb_names['qwz_tracking'];
     $this->tbl_qwz_tracking_questions = $tbl_cdb_names['qwz_tracking_questions'];
     $this->tbl_qwz_tracking_answers = $tbl_cdb_names['qwz_tracking_answers'];
 }

 public function __construct($userId = null, $courseId = null, $database = null)
 {
     $this->userId = $userId ? $userId : claro_get_current_user_id();
     $this->courseId = $courseId ? $courseId : claro_get_current_course_id();
     $this->database = $database ? $database : Claroline::getDatabase();
     $this->tbl = array_merge(get_module_main_tbl(array('rel_course_user')), get_module_course_tbl(array('group_team', 'group_rel_team_user')));
 }

 protected function isDocumentDownloadableInCourse($requestedUrl)
 {
     if (claro_is_in_a_group()) {
         $groupContext = true;
         $courseContext = false;
         $is_allowedToEdit = claro_is_group_member() || claro_is_group_tutor() || claro_is_course_manager();
     } else {
         $groupContext = false;
         $courseContext = true;
         $courseUserData = claro_get_course_user_privilege($this->cid, $this->uid);
         $is_allowedToEdit = $courseUserData['is_courseAdmin'];
     }
     if ($courseContext) {
         $courseTblList = get_module_course_tbl(array('document'), $this->cid);
         $tbl_document = $courseTblList['document'];
         if (strtoupper(substr(PHP_OS, 0, 3)) == "WIN") {
             $modifier = '';
         } else {
             $modifier = 'BINARY ';
         }
         $sql = "SELECT visibility\n\t\t\tFROM `{$tbl_document}`\n\t\t\tWHERE {$modifier} path = '" . claro_sql_escape($requestedUrl) . "'";
         $docVisibilityStatus = claro_sql_query_get_single_value($sql);
         if (!is_null($docVisibilityStatus) && $docVisibilityStatus == 'i' && !$is_allowedToEdit) {
             return false;
         } else {
             return true;
         }
     } else {
         // ????
     }
 }

 public function __construct($courseId, $database = null)
 {
     $this->database = $database ? $database : Claroline::getDatabase();
     $tbl_cdb_names = get_module_course_tbl(array('qwz_exercise', 'qwz_tracking', 'qwz_tracking_questions', 'qwz_tracking_answers'), $courseId);
     $this->tbl_qwz_tracking = $tbl_cdb_names['qwz_tracking'];
     $this->tbl_qwz_tracking_questions = $tbl_cdb_names['qwz_tracking_questions'];
     $this->tbl_qwz_tracking_answers = $tbl_cdb_names['qwz_tracking_answers'];
 }

 public function __construct($courseId, $userId)
 {
     $this->courseId = $courseId;
     $this->userId = (int) $userId;
     $tbl_cdb_names = get_module_course_tbl(array('qwz_exercise', 'qwz_tracking'), $courseId);
     $this->tbl_qwz_exercise = $tbl_cdb_names['qwz_exercise'];
     $this->tbl_qwz_tracking = $tbl_cdb_names['qwz_tracking'];
 }

 public function __construct($assignement, $courseId = null, $database = null)
 {
     $this->database = $database ? $database : Claroline::getDatabase();
     $this->assignement = $assignement;
     $this->courseId = $courseId ? $courseId : claro_get_current_course_id();
     $this->tbl = array_merge(get_module_main_tbl(array('rel_course_user', 'user')), get_module_course_tbl(array('wrk_submission', 'group_team'), $this->courseId));
     $this->submissionTitleList = array();
 }

 /**
  * constructor
  *
  * @author Sebastien Piraux <pir@cerdecam.be>
  * @param $questionId integer question that use this answer
  * @param $course_id to use the class when not in course context
  * @return string
  */
 public function answerMatching($questionId, $course_id = null)
 {
     $this->questionId = $questionId;
     $this->leftList = array();
     $this->rightList = array();
     $this->errorList = array();
     $tbl_cdb_names = get_module_course_tbl(array('qwz_answer_matching'), $course_id);
     $this->tblAnswer = $tbl_cdb_names['qwz_answer_matching'];
 }

 public function __construct($courseId, $groupId = null)
 {
     $this->courseId = $courseId;
     $this->groupId = $groupId;
     $tblNameList = array('chat');
     $tbl_chat_names = get_module_course_tbl($tblNameList, $this->courseId);
     $this->tblChatMsg = $tbl_chat_names['chat'];
     $tbl_mdb_names = claro_sql_get_main_tbl();
     $this->tblUser = $tbl_mdb_names['user'];
 }

 public function mergeCourseUsers($uidToRemove, $uidToKeep, $courseId)
 {
     $moduleCourseTbl = get_module_course_tbl(array('wrk_submission'), $courseId);
     $sql = "UPDATE `{$moduleCourseTbl['wrk_submission']}`\n                SET   user_id = " . (int) $uidToKeep . "\n                WHERE user_id = " . (int) $uidToRemove;
     if (!claro_sql_query($sql)) {
         Console::error("Cannot update wrk_submission from -{$uidToRemove} to +{$uidToKeep} in {$courseId}");
         return false;
     } else {
         return true;
     }
 }

 public function getResourceList(ResourceLocator $locator)
 {
     $tbl = get_module_course_tbl(array('announcement'), $locator->getCourseId());
     $sql = "SELECT `id`, `title`, `visibility`\n" . "FROM `{$tbl['announcement']}`";
     $res = Claroline::getDatabase()->query($sql);
     $resourceList = new LinkerResourceIterator();
     foreach ($res as $annoucement) {
         $annoucementLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLANN', (int) $annoucement['id']);
         $annoucementResource = new LinkerResource(empty($annoucement['title']) ? get_lang('Untitled') : $annoucement['title'], $annoucementLoc, true, $annoucement['visibility'] == 'HIDE' ? false : true, false);
         $resourceList->addResource($annoucementResource);
     }
     return $resourceList;
 }

 public function getResourceList(ResourceLocator $locator)
 {
     $tbl = get_module_course_tbl(array('calendar_event'), $locator->getCourseId());
     $sql = "SELECT `id`, `titre`, `day`, `visibility`\n" . "FROM `{$tbl['calendar_event']}`";
     $res = Claroline::getDatabase()->query($sql);
     $resourceList = new LinkerResourceIterator();
     foreach ($res as $event) {
         $eventLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLCAL', (int) $event['id']);
         $eventResource = new LinkerResource(empty($event['titre']) ? $event['day'] : $event['titre'], $eventLoc, true, $event['visibility'] == 'HIDE' ? false : true, false);
         $resourceList->addResource($eventResource);
     }
     return $resourceList;
 }

 /**
  * constructor
  *
  * @author Sebastien Piraux <pir@cerdecam.be>
  * @param $questionId integer question that use this answer
  * @param $multipleAnswer boolean true if several answer can be checked by user
  * @param $course_id to use the class when not in course context
  * @return string
  */
 public function __construct($questionId, $multipleAnswer = false, $course_id = null)
 {
     $this->questionId = (int) $questionId;
     $this->multipleAnswer = (bool) $multipleAnswer;
     $this->answerList = array();
     // add 2 empty answers as minimum requested number of answers
     $this->addAnswer();
     $this->addAnswer();
     $this->response = array();
     $this->errorList = array();
     $tbl_cdb_names = get_module_course_tbl(array('qwz_answer_multiple_choice'), $course_id);
     $this->tblAnswer = $tbl_cdb_names['qwz_answer_multiple_choice'];
 }

 /**
  * constructor
  *
  * @author Sebastien Piraux <pir@cerdecam.be>
  * @param $questionId integer question that use this answer
  * @param $course_id to use the class when not in course context
  * @return string
  */
 public function __construct($questionId, $course_id = null)
 {
     $this->questionId = (int) $questionId;
     $this->id = -1;
     $this->trueFeedback = '';
     $this->trueGrade = 0;
     $this->falseFeedback = '';
     $this->falseGrade = 0;
     $this->correctAnswer = '';
     $this->response = '';
     $this->errorList = array();
     $tbl_cdb_names = get_module_course_tbl(array('qwz_answer_truefalse'), $course_id);
     $this->tblAnswer = $tbl_cdb_names['qwz_answer_truefalse'];
 }

 public function getResourceList(ResourceLocator $locator)
 {
     $tbl = get_module_course_tbl(array('wrk_assignment'), $locator->getCourseId());
     $resourceList = new LinkerResourceIterator();
     if (!$locator->hasResourceId()) {
         $sql = "SELECT `title`, `visibility`, `id`\n" . "FROM `{$tbl['wrk_assignment']}`\n";
         $res = Claroline::getDatabase()->query($sql);
         foreach ($res as $assig) {
             $loc = new ClarolineResourceLocator($locator->getCourseId(), 'CLWRK', (int) $assig['id']);
             $resource = new LinkerResource($assig['title'], $loc, true, $assig['visibility'] == 'VISIBLE', false);
             $resourceList->addResource($resource);
         }
     }
     return $resourceList;
 }

 public function mergeCourseUsers($uidToRemove, $uidToKeep, $courseId)
 {
     $tblList[] = 'lp_module';
     $tblList[] = 'lp_learnPath';
     $tblList[] = 'lp_rel_learnPath_module';
     $tblList[] = 'lp_asset';
     $tblList[] = 'lp_user_module_progress';
     $moduleCourseTbl = get_module_course_tbl($tblList, $courseId);
     // Update lp_user_module_progress
     $sql = "UPDATE `{$moduleCourseTbl['lp_user_module_progress']}`\n                SET   user_id = " . (int) $uidToKeep . "\n                WHERE user_id = " . (int) $uidToRemove;
     if (!claro_sql_query($sql)) {
         Console::error("Cannot update lp_user_module_progress from -{$uidToRemove} to +{$uidToKeep} in {$courseId}");
         return false;
     }
     return true;
 }