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;
}
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;
}
/**
* Provide the list of available resources for a resource
*
* @para ResourceLocator $locator The resource locator.
* @return LinkerResourceIterator Resource list as an iterator
*/
public function getResourceList(ResourceLocator $locator)
{
$tbl_cdb_names = get_module_course_tbl(array('lp_learnPath'), $locator->getCourseId());
$tblPath = $tbl_cdb_names['lp_learnPath'];
$resourceList = new LinkerResourceIterator();
$sql = "SELECT `learnPath_id` AS `id`, `name`, `visibility`\n FROM `" . $tblPath . "`\n ORDER BY `name` ASC";
$pathList = claro_sql_query_fetch_all_rows($sql);
foreach ($pathList as $path) {
$fileLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLLNP', $path['id']);
$fileResource = new LinkerResource($path['name'], $fileLoc, true, $path['visibility'] == 'SHOW' ? true : false, false);
$resourceList->addResource($fileResource);
}
return $resourceList;
}
public function getResourceList(ResourceLocator $locator)
{
$groupId = null;
if ($locator->inGroup()) {
$groupData = claro_get_group_data(array(CLARO_CONTEXT_COURSE => $locator->getCourseId(), CLARO_CONTEXT_GROUP => $locator->getGroupId()));
$groupId = $locator->getGroupId();
}
$path = $this->getPath($locator);
if (!$this->isPathNavigable($path)) {
throw new Exception("{$path} does not exists or is not a directory");
} else {
$tbl = get_module_course_tbl(array('document'), $locator->getCourseId());
$fileProperties = array();
if (!$locator->inGroup()) {
$sql = "SELECT `path`, `visibility`, `comment`\n" . "FROM `{$tbl['document']}`\n" . "WHERE 1";
$res = Claroline::getDatabase()->query($sql);
foreach ($res as $row) {
$fileProperties[$row['path']] = $row;
}
}
$it = new DirectoryIterator($path);
$dirList = array();
$fileList = array();
foreach ($it as $file) {
if ($file->isDir() && $file->isDot()) {
continue;
}
$relativePath = str_replace('\\', '/', str_replace($file->getPath(), '', $file->getPathname()));
if ($locator->hasResourceId()) {
$relativePath = '/' . ltrim(ltrim($locator->getResourceId(), '/') . '/' . ltrim($relativePath, '/'), '/');
}
if ($file->isDir()) {
$dirList[] = $relativePath;
} elseif ($file->isFile()) {
$fileList[] = $relativePath;
}
}
natcasesort($dirList);
natcasesort($fileList);
$resourceList = new LinkerResourceIterator();
foreach ($dirList as $relativePath) {
$isVisible = true;
if (array_key_exists($relativePath, $fileProperties)) {
$isVisible = $fileProperties[$relativePath]['visibility'] != 'i' ? true : false;
}
$resourceList->addResource($this->createResourceLocator($locator->getCourseId(), $relativePath, $isVisible, true, $groupId));
}
foreach ($fileList as $relativePath) {
$isVisible = true;
if (array_key_exists($relativePath, $fileProperties)) {
$isVisible = $fileProperties[$relativePath]['visibility'] != 'i' ? true : false;
}
$resourceList->addResource($this->createResourceLocator($locator->getCourseId(), $relativePath, $isVisible, false, $groupId));
}
return $resourceList;
}
}
public function getResourceList(ResourceLocator $locator)
{
$tbl = get_module_course_tbl(array('wiki_properties', 'wiki_pages'), $locator->getCourseId());
if ($locator->inGroup()) {
$groupSql = "WHERE group_id = " . Claroline::getDatabase()->escape($locator->getGroupId());
} else {
$groupSql = "WHERE group_id = 0";
}
$resourceList = new LinkerResourceIterator();
if ($locator->hasResourceId()) {
$parts = explode('/', ltrim($locator->getResourceId(), '/'));
if (count($parts) == 1) {
$sql = "SELECT `title`\n" . "FROM `{$tbl['wiki_pages']}`\n" . "WHERE wiki_id = " . Claroline::getDatabase()->escape($parts[0]);
$res = Claroline::getDatabase()->query($sql);
foreach ($res as $page) {
$pageLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLWIKI', (int) $parts[0] . '/' . rawurlencode($page['title']));
$pageResource = new LinkerResource($page['title'] == '__MainPage__' ? get_lang('Main page') : $page['title'], $pageLoc, true, true, false);
$resourceList->addResource($pageResource);
}
}
} else {
$sql = "SELECT `id`, `title`\n" . "FROM `{$tbl['wiki_properties']}`\n" . $groupSql;
$res = Claroline::getDatabase()->query($sql);
foreach ($res as $wiki) {
$wikiLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLWIKI', (int) $wiki['id']);
$wikiResource = new LinkerResource($wiki['title'], $wikiLoc, true, true, true);
$resourceList->addResource($wikiResource);
}
}
return $resourceList;
}
public function getResourceList(ResourceLocator $locator)
{
$resourceList = new LinkerResourceIterator();
$tbl = get_module_course_tbl(array('bb_topics', 'bb_forums'), $locator->getCourseId());
if (!$locator->hasResourceId()) {
if (!$locator->inGroup()) {
$sql = "SELECT `forum_id`, `forum_name`, `group_id`\n" . "FROM `{$tbl['bb_forums']}`\n";
$forumList = Claroline::getDatabase()->query($sql);
foreach ($forumList as $forum) {
$forumLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLFRM', empty($forum['group_id']) ? (int) $forum['forum_id'] : null, empty($forum['group_id']) ? null : $forum['group_id']);
$topicResource = new LinkerResource(empty($forum['forum_name']) ? get_lang('Untitled') : $forum['forum_name'], $forumLoc, true, true, true);
$resourceList->addResource($topicResource);
}
} else {
$sql = "SELECT `forum_id` AS `id`, `forum_name` AS `name`\n" . "FROM `{$tbl['bb_forums']}`\n" . "WHERE `group_id` = " . Claroline::getDatabase()->escape($locator->getGroupId());
$res = Claroline::getDatabase()->query($sql);
if (count($res)) {
$groupForum = $res->fetch(Database_ResultSet::FETCH_OBJECT);
$sql = "SELECT `topic_id`, `topic_title`, `forum_id`\n" . "FROM `{$tbl['bb_topics']}`\n" . "WHERE `forum_id` = " . Claroline::getDatabase()->escape($groupForum->id);
$topicList = Claroline::getDatabase()->query($sql);
foreach ($topicList as $topic) {
$topicLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLFRM', (int) $topic['topic_id'], $locator->getGroupId());
$topicResource = new LinkerResource(empty($topic['topic_title']) ? get_lang('Untitled') : $topic['topic_title'], $topicLoc, true, true, false);
$resourceList->addResource($topicResource);
}
}
}
} else {
if ($locator->inGroup()) {
} else {
$elems = explode('/', ltrim($locator->getResourceId(), '/'));
if (count($elems) == 1) {
$sql = "SELECT `topic_id`, `topic_title`, `forum_id`\n" . "FROM `{$tbl['bb_topics']}`\n" . "WHERE `forum_id` = " . Claroline::getDatabase()->escape($elems[0]);
$topicList = Claroline::getDatabase()->query($sql);
foreach ($topicList as $topic) {
$topicLoc = new ClarolineResourceLocator($locator->getCourseId(), 'CLFRM', (int) $topic['forum_id'] . '/' . (int) $topic['topic_id']);
$topicResource = new LinkerResource(empty($topic['topic_title']) ? get_lang('Untitled') : $topic['topic_title'], $topicLoc, true, true, false);
$resourceList->addResource($topicResource);
}
} else {
// not navigable
}
}
}
return $resourceList;
}
public function getResourceName(ResourceLocator $locator)
{
$path = $locator->getResourceId();
return str_replace('/', ' > ', $path);
}
public static function getLocatorIdAndAddIfMissing(ResourceLocator $locator)
{
$tbl = claro_sql_get_course_tbl();
$sql = "SELECT `id` FROM `{$tbl['resources']}`\n" . "WHERE BINARY `crl` = " . Claroline::getDatabase()->quote($locator->__toString());
$res = Claroline::getDatabase()->query($sql);
if ($res->numRows()) {
return (int) $res->fetch(Database_ResultSet::FETCH_VALUE);
} else {
$sql = "INSERT INTO `{$tbl['resources']}`\n" . "SET\n" . "`crl` = " . Claroline::getDatabase()->quote($locator->__toString()) . "\n" . ",`title` = ''";
Claroline::getDatabase()->exec($sql);
return (int) Claroline::getDatabase()->insertId();
}
}
