function setSubItem($item)
{
$list = new cs_list();
$list->add($item);
$this->setSubItemList($list);
$this->_sub_item_title_description = $this->_translator->getMessage('COMMON_READABLE_ONLY_USER', $item->getFullName());
}
function getPathItemList()
{
$link_manager = $this->_environment->getLinkItemManager();
$link_manager->setLinkedItemLimit($this);
$link_manager->setSortingPlaceLimit();
$link_manager->sortbySortingPlace();
$link_manager->select();
$link_item_list = $link_manager->get();
include_once 'classes/cs_list.php';
$retour = new cs_list();
if (!$link_item_list->isEmpty()) {
$item = $link_item_list->getFirst();
while ($item) {
$retour->add($item->getLinkedItem($this));
$item = $link_item_list->getNext();
}
}
return $retour;
}
// only access display config, if user is not root
if( !$current_user->isRoot() and $environment->inPrivateRoom() ) {
$myentries_array = $current_context->getMyCalendarDisplayConfig();
if(in_array("mycalendar_dates_assigned_to_me", $myentries_array)){
$temp_list = new cs_list();
$current_user = $environment->getCurrentUserItem();
$current_user_list = $current_user->getRelatedUserList();
$temp_element = $list->getFirst();
while($temp_element){
$temp_user = $current_user_list->getFirst();
while($temp_user){
if($temp_element->isParticipant($temp_user)){
$temp_list->add($temp_element);
}
$temp_user = $current_user_list->getNext();
}
$temp_element = $list->getNext();
}
$list = $temp_list;
}
$list->sortby('date');
}
}
if (($seldisplay_mode=='calendar' or $seldisplay_mode == 'calendar_month') and !($mode == 'formattach' or $mode == 'detailattach') ){
$count_all_shown = $list->getCount();
}
public function getSortedItemList($id_array, $sortBy)
{
if (empty($id_array)) {
return new cs_list();
} else {
$query = 'SELECT * FROM ' . $this->addDatabasePrefix($this->_db_table) . ' WHERE ' . $this->addDatabasePrefix($this->_db_table) . '.item_id IN ("' . implode('", "', encode(AS_DB, $id_array)) . '") AND ' . $this->addDatabasePrefix($this->_db_table) . '.type LIKE "grouproom"';
$query .= " ORDER BY " . $sortBy;
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting list of ' . $this->_room_type . ' items from query: "' . $query . '"', E_USER_WARNING);
} else {
$list = new cs_list();
foreach ($result as $rs) {
$list->add($this->_buildItem($rs));
}
}
return $list;
}
}
$rooms->addList($private_rooms);
$rooms->addList($group_rooms);
// Termine des Gemeinschaftsraumes
$checkedDateIds = array();
$new_date_list = new cs_list();
if (!empty($date_id_array)) {
foreach($date_id_array as $date_id) {
$date_item = $date_list->getFirst();
while($date_item) {
//include_once('functions/error_functions.php');trigger_error('n i y',E_USER_ERROR);
if($date_item->getItemID() == $date_id and $date_item->getContextID() === 0) {
$date_item = $date_manager->getItem($date_item->getItemId());
$new_date_list->add($date_item);
$current_context = $environment->getCurrentContextID();
if ($date_item->getContextID() != $current_context){
$checkedDateIds[] = $date_item->getItemID();
}
break;
} else {
$date_item = $date_list->getNext();
}
}
}
}
// Termine anderer Räume
$room_sort = $rooms->getFirst();
while ($room_sort) {
function getAllRoomUsersFromCache($context_id)
{
$user_list = new cs_list();
if (!empty($context_id) and !empty($this->_cache)) {
foreach ($this->_cache as $user) {
$user_list->add($user);
}
} else {
$this->resetLimits();
$this->setContextLimit($this->_environment->getCurrentContextID());
$this->setUserLimit();
$this->select();
$user_list = $this->get();
}
return $user_list;
}
if (!isset($environment) and isset($this->_environment)) {
$environment = $this->_environment;
}
if (!isset($translator) and isset($this->_translator)) {
$translator = $this->_translator;
}
if (!$environment->inServer() and !$environment->inPrivateRoom()) {
$link_item = new cs_link();
$link_item->setDescription($translator->getMessage('ROOM_MEMBER_ADMIN_DESC'));
$link_item->setIconPath('images/cs_config/ROOM_MEMBER_ADMIN.gif');
$link_item->setTitle($translator->getMessage('ROOM_MEMBER_ADMIN'));
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('account');
$link_item->setFunction('index');
$link_item->setParameter(array());
$admin_link_list->add($link_item);
}
if (!$environment->inServer() and !$environment->inPrivateRoom()) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('PREFERENCES_MAIL_LINK'));
$link_item->setDescription($translator->getMessage('PREFERENCES_MAIL_DESC'));
$link_item->setIconPath('images/cs_config/PREFERENCES_MAIL.gif');
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('mail');
$link_item->setParameter(array());
$admin_link_list->add($link_item);
}
if (!$environment->inServer() and !$environment->inPrivateRoom()) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('PREFERENCES_AGB'));
/**
* Returns all existing task for an item
*/
function getTaskListForItem($item)
{
$item_id = $item->getItemID();
$query = 'SELECT * FROM ' . $this->addDatabasePrefix('tasks') . ' WHERE linked_item_id="' . encode(AS_DB, $item_id) . '"';
$result = $this->_db_connector->performQuery($query);
$task_list = new cs_list();
foreach ($result as $query_result) {
$task_item = $this->_buildItem($query_result);
$task_list->add($task_item);
unset($task_item);
}
unset($item);
return $task_list;
}
if ($c_html_textarea) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_TEXTAREA_TITLE'));
$link_item->setDescription($translator->getMessage('CONFIGURATION_TEXTAREA_TITLE_DESC'));
if ($environment->getCurrentBrowser() == 'MSIE' && mb_substr($environment->getCurrentBrowserVersion(), 0, 1) == '6') {
$link_item->setIconPath('images/commsyicons_msie6/48x48/config/htmltextarea.gif');
$link_item->setIconPathForNavigation('images/commsyicons_msie6/22x22/config/htmltextarea.gif');
} else {
$link_item->setIconPath('images/commsyicons/48x48/config/htmltextarea.png');
$link_item->setIconPathForNavigation('images/commsyicons/22x22/config/htmltextarea.png');
}
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('htmltextarea');
$link_item->setParameter(array());
$configuration_rubric_extras_link_list->add($link_item);
}
#########################################
# Wiki - Raum-Wiki
#########################################
$context_item = $environment->getCurrentContextItem();
if ($context_item->withWikiFunctions() and !$context_item->isServer()) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('WIKI_CONFIGURATION_LINK'));
if ($environment->getCurrentBrowser() == 'MSIE' && mb_substr($environment->getCurrentBrowserVersion(), 0, 1) == '6') {
$link_item->setIconPath('images/commsyicons_msie6/48x48/config/pmwiki.gif');
$link_item->setIconPathForNavigation('images/commsyicons_msie6/22x22/config/pmwiki.gif');
} else {
$link_item->setIconPath('images/commsyicons/48x48/config/pmwiki.png');
$link_item->setIconPathForNavigation('images/commsyicons/22x22/config/pmwiki.png');
}
$item_list = $item_manager->get(); // returns a cs_list of items
#$ids = $item_manager->getIDs();
$item = $item_list->getFirst();
$new_item_list = new cs_list();
while($item){
$type = $item->getItemType();
# $item_manager = $environment->getManager();
# $new_item = $labelmanager->getItem($item->getItemID());
# $new_item_list->add($new_item);
switch ($type){
case 'label':
$labelmanager = $environment->getLabelmanager();
$new_item = $labelmanager->getItem($item->getItemID());
$new_item_list->add($new_item);
break;
case 'materials':
$materialmanager = $environment->getMaterialmanager();
$new_item = $materialmanager->getItem($item->getItemID());
$new_item_list->add($new_item);
break;
case CS_MATERIAL_TYPE:
$materialmanager = $environment->getMaterialmanager();
$new_item = $materialmanager->getItem($item->getItemID());
$new_item_list->add($new_item);
break;
}
$item = $item_list->getNext();
}
function getTempItemListBySessionID($session_id)
{
$file_list = new cs_list();
$query = 'SELECT * FROM ' . $this->addDatabasePrefix('files');
$query .= ' WHERE 1';
$query .= ' AND ' . $this->addDatabasePrefix('files') . '.temp_upload_session_id="' . encode(AS_DB, $session_id) . '"';
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems getting temp files with session id [' . $session_id . '].', E_USER_WARNING);
$file = array();
} elseif (!empty($result[0])) {
foreach ($result as $file_results) {
$temp_file = $this->_buildItem($file_results);
$file_list->add($temp_file);
}
}
return $file_list;
}
private function _actionPerformRequest($archive_toggle = false)
{
// archive
if ($archive_toggle) {
$this->_environment->toggleArchiveMode();
}
// archive
$return = array();
$current_context = $this->_environment->getCurrentContextItem();
$current_user = $this->_environment->getCurrentUser();
$session = $this->_environment->getSessionItem();
$project_manager = $this->_environment->getProjectManager();
$community_manager = $this->_environment->getCommunityManager();
$private_room_manager = $this->_environment->getPrivateRoomManager();
$group_room_manager = $this->_environment->getGroupRoomManager();
$link_manager = $this->_environment->getLinkManager();
$noticed_manager = $this->_environment->getNoticedManager();
$room_manager = $this->_environment->getProjectManager();
$current_context = $this->_environment->getCurrentContextItem();
$session = $this->_environment->getSession();
$translator = $this->_environment->getTranslationObject();
// get current room modules
$current_room_modules = $current_context->getHomeConf();
$room_moduls = array();
if (!empty($current_room_modules)) {
$room_modules = explode(",", $current_room_modules);
}
$modules = array();
foreach ($room_modules as $module) {
list($name, $display) = explode("_", $module);
if ($display !== "none") {
$modules[] = $name;
}
}
$rubric_copy_array = $this->getUtils()->getCopyRubrics();
$item_room_ids = array();
$tmp_id_array = array();
$item_list = new cs_list();
// collect room and item ids
foreach ($rubric_copy_array as $rubric) {
$item_manager = $this->_environment->getManager($rubric);
$item_id_array = $session->getValue($rubric . "_clipboard");
$item_list->addList($item_manager->getItemList($item_id_array));
$item = $item_list->getFirst();
while ($item) {
$item_room_ids[] = $item->getContextID();
$item = $item_list->getNext();
}
if (is_array($item_id_array)) {
$tmp_id_array = array_merge($tmp_id_array, $item_id_array);
}
}
$item_id_array = $tmp_id_array;
// create a list of rooms
$rooms = new cs_list();
$rooms->addList($project_manager->getSortedItemList($item_room_ids, "title"));
$rooms->addList($community_manager->getSortedItemList($item_room_ids, "title"));
$rooms->addList($private_room_manager->getSortedItemList($item_room_ids, "title"));
$rooms->addList($group_room_manager->getSortedItemList($item_room_ids, "title"));
// get item information
$new_item_list = new cs_list();
$checked_ids = array();
if (!empty($item_id_array)) {
foreach ($item_id_array as $item_id) {
$item = $item_list->getFirst();
while ($item) {
if ($item->getItemID() == $item_id && $item->getContextID() === 0) {
$item_manager = $this->_environment->getManager($item->getItemType());
$item = $item_manager->getItem($item->getItemId());
$new_item_list->add($item);
if ($item->getContextID() !== $current_context->getItemID()) {
$checked_ids[] = $item->getItemID();
}
break;
} else {
$item = $item_list->getNext();
}
}
}
}
$room_sort = $rooms->getFirst();
while ($room_sort) {
if (!empty($item_id_array)) {
foreach ($item_id_array as $item_id) {
$item = $item_list->getFirst();
while ($item) {
if ($item->getItemID() == $item_id && $item->getContextID() == $room_sort->getItemId()) {
$item_manager = $this->_environment->getManager($item->getItemType());
$item = $item_manager->getItem($item->getItemId());
$new_item_list->add($item);
if (isset($item) && $item->getContextID() !== $current_context->getItemID()) {
$checked_ids[] = $item->getItemID();
}
break;
} else {
$item = $item_list->getNext();
}
}
}
}
$room_sort = $rooms->getNext();
}
$item_list = $new_item_list;
// prepare return
$data = array();
$entry = $item_list->getFirst();
if ($entry) {
$last_room_id = $entry->getContextID();
}
$index = 0;
while ($entry) {
if ($entry->isDeleted()) {
$entry = $item_list->getNext();
continue;
}
$room_id = $entry->getContextID();
if ($last_room_id != $room_id) {
$index++;
}
$last_room_id = $room_id;
// room data
if (!isset($data[$index])) {
$data[$index]["room_id"] = $last_room_id;
$room = $room_manager->getItem($last_room_id);
// if $room is null, try to get a private room
if ($room === null) {
$room = $private_room_manager->getItem($last_room_id);
}
$headline = "";
if (empty($room)) {
$community_manager->getItem($room_id);
$room = $community_manager->getItem($room_id);
$headline = $translator->getMessage("COPY_FROM") . " " . $translator->getMessage("COMMON_COMMUNITY_ROOM_TITLE") . " \"" . $room->getTitle() . "\"";
} elseif ($room->isPrivateRoom()) {
$headline = $translator->getMessage("COPY_FROM_PRIVATEROOM") . " \"" . $current_user->getFullname() . "\"";
} elseif ($room->isGroupRoom()) {
$headline = $translator->getMessage("COPY_FROM_GROUPROOM") . " \"" . $room->getTitle() . "\"";
} else {
$headline = $translator->getMessage("COPY_FROM_PROJECTROOM") . " \"" . $room->getTitle() . "\"";
}
$data[$index]["headline"] = $headline;
}
// process title
$title = $entry->getTitle();
if ($entry->isNotActivated()) {
$activating_date = $entry->getActivatingDate();
if (mb_strstr($activating_date, "9999-00-00")) {
$title .= BR . $translator->getMessage('COMMON_NOT_ACTIVATED');
} else {
$title .= BR . $translator->getMessage('COMMON_NOT_ACTIVATED') . " " . getDateInLang($entry->getActivatingDate());
}
}
$disabled = false;
if ($entry->isNotActivated() && !($entry->getCreatorID() == $current_user->getItemID() || $current_user->isModerator())) {
$disabled = true;
}
// item data
$data[$index]["items"][] = array("disabled" => $disabled, "item_id" => $entry->getItemID(), "title" => $title, "rubric" => $this->getUtils()->getLogoInformationForType($entry->getItemType()), "modifier" => $entry->getModificatorItem()->getFullName(), "modification_date" => getDateInLang($entry->getModificationDate()));
$entry = $item_list->getNext();
}
// archive
if ($archive_toggle) {
$this->_environment->toggleArchiveMode();
}
// archive
return $data;
}
public function getFatherItemList($item_id)
{
$homepagelink_manager = $this->_environment->getHomepageLinkManager();
$father_item_id_array = $homepagelink_manager->getFatherItemIDArray($item_id);
unset($homepagelink_manager);
$father_list = new cs_list();
foreach ($father_item_id_array as $father_item_id) {
$father_item = $this->getItem($father_item_id);
$father_list->add($father_item);
unset($father_item);
}
return $father_list;
}
$rooms->addList($private_rooms);
$rooms->addList($group_rooms);
// Termine des Gemeinschaftsraumes
$checkedDiscussionIds = array();
$new_discussion_list = new cs_list();
if (!empty($discussion_id_array)) {
foreach($discussion_id_array as $discussion_id) {
$discussion_item = $discussion_list->getFirst();
while($discussion_item) {
//include_once('functions/error_functions.php');trigger_error('n i y',E_USER_ERROR);
if($discussion_item->getItemID() == $discussion_id and $discussion_item->getContextID() === 0) {
$discussion_item = $discussion_manager->getItem($discussion_item->getItemId());
$new_discussion_list->add($discussion_item);
$current_context = $environment->getCurrentContextID();
if ($discussion_item->getContextID() != $current_context){
$checkedDiscussionIds[] = $discussion_item->getItemID();
}
break;
} else {
$discussion_item = $discussion_list->getNext();
}
}
}
}
// Termine anderer Räume
$room_sort = $rooms->getFirst();
while ($room_sort) {
function getRelatedContextListForUser($user_id, $auth_source, $context_id, $mode = 'select')
{
$list = new cs_list();
$query = 'SELECT DISTINCT';
if ($mode == 'count') {
$query .= ' count(DISTINCT ' . $this->addDatabasePrefix($this->_db_table) . '.item_id) as count';
} elseif ($mode == 'id_array') {
$query .= ' ' . $this->addDatabasePrefix($this->_db_table) . '.item_id';
} else {
$query .= ' ' . $this->addDatabasePrefix($this->_db_table) . '.*';
}
$query .= ' FROM ' . $this->addDatabasePrefix('room');
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('user') . ' ON ' . $this->addDatabasePrefix('user') . '.context_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id
AND ' . $this->addDatabasePrefix('user') . '.deletion_date IS NULL
AND ' . $this->addDatabasePrefix('user') . '.user_id="' . encode(AS_DB, $user_id) . '"
AND ' . $this->addDatabasePrefix('user') . '.auth_source="' . encode(AS_DB, $auth_source) . '"';
if (!$this->_all_room_limit) {
$query .= ' AND ' . $this->addDatabasePrefix('user') . '.status >= "2"';
} else {
$query .= ' AND ' . $this->addDatabasePrefix('user') . '.status >= "1"';
}
if (!empty($this->_search_array)) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('user') . ' AS user2 ON user2.context_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id AND user2.deletion_date IS NULL AND user2.is_contact="1"';
}
if (isset($this->_topic_limit)) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l41 ON ( l41.deletion_date IS NULL AND ((l41.first_item_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id AND l41.second_item_type="' . CS_TOPIC_TYPE . '"))) ';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l42 ON ( l42.deletion_date IS NULL AND ((l42.second_item_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id AND l42.first_item_type="' . CS_TOPIC_TYPE . '"))) ';
}
// time (clock pulses)
if (isset($this->_time_limit)) {
if ($this->_time_limit != -1) {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('links') . ' AS room_time ON room_time.from_item_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id AND room_time.link_type="in_time"';
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('labels') . ' AS time_label ON room_time.to_item_id=time_label.item_id AND time_label.type="time"';
} else {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('links') . ' AS room_time ON room_time.from_item_id=' . $this->addDatabasePrefix($this->_db_table) . '.item_id AND room_time.link_type="in_time"';
}
}
$query .= ' WHERE 1';
if (isset($this->_topic_limit)) {
if ($this->_topic_limit == -1) {
$query .= ' AND (l41.first_item_id IS NULL AND l41.second_item_id IS NULL)';
$query .= ' AND (l42.first_item_id IS NULL AND l42.second_item_id IS NULL)';
} else {
$query .= ' AND ((l41.first_item_id = "' . encode(AS_DB, $this->_topic_limit) . '" OR l41.second_item_id = "' . encode(AS_DB, $this->_topic_limit) . '")';
$query .= ' OR (l42.first_item_id = "' . encode(AS_DB, $this->_topic_limit) . '" OR l42.second_item_id = "' . encode(AS_DB, $this->_topic_limit) . '"))';
}
}
if (isset($this->_status_limit)) {
if ($this->_status_limit != 5) {
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.status = "' . encode(AS_DB, $this->_status_limit) . '"';
} elseif ($this->_status_limit == 5) {
$query .= ' AND (' . $this->addDatabasePrefix($this->_db_table) . '.status = "1" OR ' . $this->addDatabasePrefix($this->_db_table) . '.status = "2")';
}
} else {
$query .= ' AND (' . $this->addDatabasePrefix($this->_db_table) . '.status = "' . CS_ROOM_OPEN . '" OR ' . $this->addDatabasePrefix($this->_db_table) . '.status = "' . CS_ROOM_CLOSED . '" OR ' . $this->addDatabasePrefix($this->_db_table) . '.status = "' . CS_ROOM_LOCK . '")';
}
if (isset($this->_search_array) and !empty($this->_search_array)) {
$query .= ' AND (';
$field_array = array('TRIM(CONCAT(user2.firstname," ",user2.lastname))', '' . $this->addDatabasePrefix($this->_db_table) . '.title');
$search_limit_query_code = $this->_generateSearchLimitCode($field_array);
$query .= $search_limit_query_code;
$query .= ' )';
}
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.context_id="' . encode(AS_DB, $context_id) . '"';
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.type !="privateroom"';
if (isset($this->_room_type) and $this->_room_type != CS_PRIVATEROOM_TYPE) {
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.type = "' . encode(AS_DB, $this->_room_type) . '"';
}
if ($this->_delete_limit == true) {
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.deleter_id IS NULL';
}
// time (clock pulses)
if (isset($this->_time_limit)) {
if ($this->_time_limit != -1) {
$query .= ' AND time_label.item_id = "' . encode(AS_DB, $this->_time_limit) . '"';
} else {
$query .= ' AND room_time.to_item_id IS NULL';
}
}
if (isset($this->_sort_order)) {
if ($this->_sort_order == 'title_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.title DESC';
} elseif ($this->_sort_order == 'activity') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.activity ASC,' . $this->addDatabasePrefix($this->_db_table) . '.title';
} elseif ($this->_sort_order == 'activity_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.activity DESC,' . $this->addDatabasePrefix($this->_db_table) . '.title';
} else {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
}
} elseif (isset($this->_order)) {
if ($this->_order == 'date') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.modification_date DESC, ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
} elseif ($this->_order == 'creation_date') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.creation_date ASC, ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
} elseif ($this->_order == 'creator') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('user') . '.lastname, ' . $this->addDatabasePrefix($this->_db_table) . '.modification_date DESC';
} elseif ($this->_order == 'activity') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.activity ASC, ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
} elseif ($this->_order == 'activity_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.activity DESC, ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
} else {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.title, ' . $this->addDatabasePrefix($this->_db_table) . '.modification_date ASC';
}
} else {
$query .= ' ORDER BY ' . $this->addDatabasePrefix($this->_db_table) . '.title ASC';
}
if ($mode == 'select') {
if (isset($this->_interval_limit) and isset($this->_from_limit)) {
$query .= ' LIMIT ' . encode(AS_DB, $this->_from_limit) . ', ' . encode(AS_DB, $this->_interval_limit);
}
}
// perform query
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting ' . $this->_db_table . ' items from query: "' . $query . '"', E_USER_WARNING);
} else {
if ($mode == 'select') {
foreach ($result as $query_result) {
$item = $this->_buildItem($query_result);
$list->add($item);
unset($item);
}
$retour = $list;
unset($list);
} else {
$id_array = array();
foreach ($result as $query_result) {
$id_array[] = $query_result['item_id'];
}
$retour = $id_array;
}
unset($result);
}
return $retour;
}
function getActiveTypeRooms($type, $start, $end)
{
$list = $this->getUsedTypeRooms($type, $start, $end);
// delete rooms that are not really active
$retour_list = new cs_list();
if (!$list->isEmpty()) {
$item = $list->getFirst();
while ($item) {
if ($item->isActive($start, $end)) {
$retour_list->add($item);
}
$item = $list->getNext();
}
}
return $retour_list;
}
function getSectionForCurrentVersion($material_item)
{
$item_id = $material_item->getItemID();
$version_id = $material_item->getVersionID();
if (in_array($item_id, $this->_cached_material_item_ids)) {
$list = new cs_list();
$section_list = $this->_all_section_list;
$section_item = $section_list->getFirst();
while ($section_item) {
if ($item_id == $section_item->getLinkedItemID() and $version_id == $section_item->getVersionID()) {
$list->add($section_item);
}
$section_item = $section_list->getNext();
}
unset($section_list);
unset($section_item);
return $list;
} else {
$this->reset();
$this->setContextLimit($material_item->getContextID());
$this->setMaterialItemIDLimit($material_item->getItemID());
$this->setVersionIDLimit($material_item->getVersionID());
$this->select();
return $this->get();
}
}
$translator = $environment->getTranslationObject();
$configuration_important_link_list = new cs_list();
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_ROOM_OPTIONS_TITLE'));
$current_context = $environment->getCurrentContextItem();
if ($environment->getCurrentBrowser() == 'MSIE' && mb_substr($environment->getCurrentBrowserVersion(), 0, 1) == '6') {
$link_item->setIconPath('images/commsyicons_msie6/48x48/config/room_options.gif');
} else {
$link_item->setIconPath('images/commsyicons/48x48/config/room_options.png');
}
$link_item->setDescription($translator->getMessage('CONFIGURATION_ROOM_OPTIONS_DESC'));
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('room_options');
$link_item->setParameter(array());
$configuration_important_link_list->add($link_item);
if ($environment->inPrivateRoom()) {
$new_private_room = $environment->inConfigArray('c_use_new_private_room', $environment->getCurrentContextID());
$current_context_id = $environment->getCurrentContextID();
$current_portal_id = $environment->getCurrentPortalID();
if ($new_private_room) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_PRIVATEROOM_HOME_OPTIONS_TITLE'));
$current_context = $environment->getCurrentContextItem();
if ($environment->getCurrentBrowser() == 'MSIE' && mb_substr($environment->getCurrentBrowserVersion(), 0, 1) == '6') {
$link_item->setIconPath('images/commsyicons_msie6/48x48/config/privateroom_home_options.gif');
} else {
$link_item->setIconPath('images/commsyicons/48x48/config/privateroom_home_options.png');
}
$link_item->setDescription($translator->getMessage('CONFIGURATION_PRIVATEROOM_HOME_OPTIONS_DESC'));
$link_item->setContextID($environment->getCurrentContextID());
function moveRoom(cs_environment $environment, cs_list $afterList, cs_room_item $roomItem, $exec = false, $newPortalId) {
$linkedProjectedRoomItems = new cs_list();
if ($exec) {
if ($roomItem) {
global $environment;
$oldPortalId = $roomItem->getContextID();
$portalManager = $environment->getPortalManager();
$oldPortal = $portalManager->getItem($oldPortalId);
$userManager = $environment->getUserManager();
$roomList = new cs_list();
$roomList->add($roomItem);
// search for associated project rooms in list after this entry
if ($roomItem->isCommunityRoom()) {
$projectRoomList = $roomItem->getProjectRoomList();
$afterListItem = $afterList->getFirst();
while ($afterListItem) {
if ($projectRoomList->inList($afterListItem)) {
$linkedProjectedRoomItems->add($afterListItem);
}
$afterListItem = $afterList->getNext();
}
$roomList->addList($linkedProjectedRoomItems);
} else if ($roomItem->isGrouproomActive()) {
$groupManager = $environment->getGroupManager();
$groupManager->setContextLimit($roomItem->getItemID());
$groupManager->select();
$groupList = $groupManager->get();
if ($groupList->isNotEmpty()) {
$groupItem = $groupList->getFirst();
while($groupItem) {
if ($groupItem->isGroupRoomActivated()) {
$groupRoomItem = $groupItem->getGroupRoomItem();
if (isset($groupRoomItem) && !empty($groupRoomItem)) {
$roomList->add($groupRoomItem);
}
}
$groupItem = $groupList->getNext();
}
}
}
$roomNameArray = array();
$userArray = array();
$authSourceArray = array();
$roomListItem = $roomList->getFirst();
while ($roomListItem) {
$roomNameArray[$roomListItem->getItemID()] = $roomListItem->getTitle();
$userManager->resetLimits();
$userManager->setContextLimit($roomListItem->getItemID());
$userManager->select();
$userList = $userManager->get();
if ($userList->isNotEmpty()) {
$userItem = $userList->getFirst();
while($userItem) {
$authSourceArray[$userItem->getAuthSource()] = $userItem->getAuthSource();
$userIdTest = $userItem->getUserID();
if (!empty($userIdTest)) {
$userRoomArray[$userItem->getUserID() . "__CS__" . $userItem->getAuthSource()] = $roomListItem->getItemID();
if (empty($userArray[$userItem->getUserID()])) {
$portalUserItem = $userItem->getRelatedCommSyUserItem();
if (isset($portalUserItem)) {
$userArray[$userItem->getUserID() . "__CS__" . $userItem->getAuthSource()] = $portalUserItem;
}
}
$userIdTest = $userItem->getUserID();
}
$userItem = $userList->getNext();
}
}
$roomListItem = $roomList->getNext();
}
$authSourceTranslationArray = array();
$authSourceFindArray = array();
$authSourceItemArray = array();
$newPortal = $portalManager->getItem($newPortalId);
$authSourceListNew = $newPortal->getAuthSourceList();
foreach ($authSourceArray as $authSourceId) {
$authSourceManager = $environment->getAuthSourceManager();
$authSourceItemOld = $authSourceManager->getItem($authSourceId);
$authSourceItemArray[$authSourceItemOld->getItemID()] = $authSourceItemOld;
if (!$authSourceListNew->isEmpty()) {
$authSourceItemNew = $authSourceListNew->getFirst();
while ($authSourceItemNew) {
$authSourceItemArray[$authSourceItemNew->getItemID()] = $authSourceItemNew;
if ($authSourceItemOld->isCommSyDefault() && $authSourceItemNew->isCommSyDefault()) {
$authSourceTranslationArray[$authSourceItemOld->getItemID()] = $authSourceItemNew->getItemID();
}
$authSourceItemNew = $authSourceListNew->getNext();
}
}
}
$authSourceNotTranslationArray = array();
foreach ($authSourceArray as $authSourceId) {
if (!array_key_exists($authSourceId, $authSourceTranslationArray)) {
$authSourceNotTranslationArray[] = $authSourceId;
}
}
$authSourceManager = $environment->getAuthSourceManager();
foreach ($authSourceNotTranslationArray as $authSourceId) {
$authSourceItemOld = $authSourceManager->getItem($authSourceId);
$authSourceItemNew = clone $authSourceItemOld;
$authSourceItemNew->setItemID('');
$authSourceItemNew->setContextID($newPortalId);
$authSourceItemNew->save();
$authSourceTranslationArray[$authSourceItemOld->getItemID()] = $authSourceItemNew->getItemID();
$authSourceItemArray[$authSourceItemNew->getItemID()] = $authSourceItemNew;
}
$userArrayAll = $userArray;
$userArrayNew = array();
$failure = false;
$userChangeArray = array();
foreach ($userArrayAll as $key => $userItem) {
// does the user exist on current portal?
$authentication = $environment->getAuthenticationObject();
$userId = $userItem->getUserID();
$authSource = $userItem->getAuthSource();
$first = true;
$go = true;
while ($go) {
$userManager->resetLimits();
$userManager->setContextLimit($newPortalId);
$userManager->setAuthSourceLimit($authSourceTranslationArray[$authSource]);
$userManager->setUserIDLimit($userId);
$userManager->select();
$userList = $userManager->get();
// commsy auth source, user id already exists
if ($userList->isNotEmpty() && $userList->getCount() == 1) {
$userItem2 = $userList->getFirst();
// email is equal
if ($userItem2->getEmail() == $userItem->getEmail()) {
unset($userArray[$userItem->getUserID() . "__CS__" . $userItem->getAuthSource()]);
if ($userItem->getUserID() != $userId) {
$userChangeArray[$userItem->getUserID() . "__CS__" . $authSourceTranslationArray[$authSource]] = $userId;
} else {
$userArrayNoChange[$userItem->getUserID() . "__CS__" . $authSourceTranslationArray[$authSource]] = $userItem;
}
$go = false;
} else {
// generate new user id
if ($first) {
$first = false;
$userId .= '1';
} else {
$count = $userId{mb_strlen($userId) - 1};
$count = (int) $count;
$count++;
$userId = mb_substr($userId, 0, mb_strlen($userId) - 1);
$userId .= $count;
}
}
} elseif ($userList->isNotEmpty() && $userList->getCount() > 1) {
include_once('functions/error_functions.php');
trigger_error('ERROR: multiple user id ' . $userId . ' for one portal',E_USER_WARNING);
$go = false;
$failure = true;
} else {
// find free user id
if ($userItem->getUserID() != $userId) {
$userChangeArray[$userItem->getUserID() . "__CS__" . $authSourceTranslationArray[$authSource]] = $userId;
} else {
$userArrayNoChange[$userItem->getUserID() . "__CS__" . $authSourceTranslationArray[$authSource]] = $userItem;
}
$go = false;
}
}
}
if ($failure) {
die("ERROR");
}
// commsy auth source
// copy auth (user_id and password) and user (normal information) items
foreach ($userArray as $key => $userItem) {
$keyArray = explode("__CS__", $key);
$userIdKey = $keyArray[0];
$authSourceKey = $keyArray[1]; // old auth source
$authManager = $authentication->getAuthManager($userItem->getAuthSource());
$authManager->setContextLimit($oldPortalId);
$authItemOld = $authManager->getItem($userItem->getUserID());
if (!empty($authItemOld)) {
$authItemNew = clone $authItemOld;
$authItemNew->setPortalID($newPortalId);
$authItemNew->setAuthSourceID($authSourceTranslationArray[$authSourceKey]);
if (!empty($userChangeArray[$userIdKey . "__CS__" . $authSourceTranslationArray[$authSourceKey]])) {
$authItemNew->setUserID($userChangeArray[$userIdKey . "__CS__" . $authSourceTranslationArray[$authSourceKey]]);
}
$authManager = $authentication->getAuthManager($authSourceTranslationArray[$authSourceKey]);
$authManager->setContextLimit($newPortalId);
$userIdAuthNew = $authItemNew->getUserID();
if (!empty($userIdAuthNew)) {
$authManager->save($authItemNew);
}
}
unset ($userIdAuthNew);
$userItemNew = $userItem->cloneData();
$userItemNew->setContextID($newPortalId);
$tempUser = $userManager->getItem($userItem->getCreatorID());
$userItemNew->setCreatorItem($tempUser);
if (!empty($userChangeArray[$userIdKey . "__CS__" . $authSourceTranslationArray[$authSourceKey]])) {
$userItemNew->setUserID($userChangeArray[$userIdKey . "__CS__" . $authSourceTranslationArray[$authSourceKey]]);
}
$userIdUserNew = $userItemNew->getUserID();
$userItemNew->setAuthSource($authSourceTranslationArray[$authSourceKey]);
if (!empty($userIdUserNew)) {
$userItemNew->save();
$userItemNew->setCreatorID2ItemID();
}
}
// external auth sources
foreach ($userArrayNew as $key => $userItem) {
$keyArray = explode("__CS__", $key);
$userIdKey = $keyArray[0];
$authSourceKey = $keyArray[1];
$userItemnew = $userItem->cloneData();
$userItemNew->setContextID($newPortalId);
$tempUser = $userManager->getItem($userItem->getCreatorID());
$userItemNew->setCreatorItem($tempUser);
$userIdUserNew = $userItemNew->getUserID();
$userItemNew->setAuthSource($authSourceKey);
if (!empty($userIdUserNew)) {
$userItemNew->save();
$userItemNew->setCreatorID2ItemID();
}
}
// change user ids of user in rooms to move
// and cahnge auth source of user in rooms to move
$roomListItem = $roomList->getFirst();
while ($roomListItem) {
$userManager = $environment->getUserManager();
$userManager->resetLimits();
$userManager->setContextLimit($roomListItem->getItemID());
$userManager->select();
$userList = $userManager->get();
if ($userList->isNotEmpty()) {
$userItem = $userList->getFirst();
while ($userItem) {
$userIdTest = $userItem->getUserID();
if (!empty($userIdTest) && !empty($userChangeArray[$userIdTest . "__CS__" . $authSourceTranslationArray[$userItem->getAuthSource()]])) {
$userItem->setUserID($userChangeArray[$userIdTest . "__CS__" . $authSourceTranslationArray[$userItem->getAuthSource()]]);
}
$newAuthSourceForUser = $authSourceTranslationArray[$userItem->getAuthSource()];
$userItem->setAuthSource($newAuthSourceForUser);
$userItem->setChangeModificationOnSave(false);
$userItem->setSaveWithoutLinkModifier();
$userItem->save();
$userItem = $userList->getNext();
}
}
// delete old links from community room to project rooms
// before saving on new potal
if ($linkedProjectedRoomItems->isEmpty() && $roomListItem->isCommunityRoom()) {
$roomListItem->setProjectListByID(array());
$roomListItem->save();
}
// move files from old portal folder to new portal folder
$oldContext = $roomListItem->getContextID();
$newContext = $newPortalId;
if ($oldContext != $newContext) {
$discManager = $environment->getDiscManager();
$discManager->moveFiles($roomListItem->getItemID(), $oldContext, $newContext);
}
$roomListItem->setContextID($newPortalId);
// set link between project and community room
if ($linkedProjectedRoomItems->isNotEmpty() && $roomListItem->isProjectRoom()) {
$tempArray = array();
$tempArray[] = $roomItem->getItemID();
$roomListItem->setCommunityListByID($tempArray);
}
// save room with new context id
$roomListItem->save();
echo ProgressBar::next();
$roomListItem = $roomList->getNext();
}
}
} else {
usleep(1000);
echo ProgressBar::next();
}
return $linkedProjectedRoomItems;
}
}
// agree movement of room
elseif ( $modus == 'agree' ) {
$old_portal_id = $item->getContextID();
$portal_manager = $environment->getPortalManager();
$old_portal = $portal_manager->getItem($old_portal_id);
$user_manager = $environment->getUserManager();
$copy_links_between_rooms = false;
// init room list and room array
include_once('classes/cs_list.php');
$room_list = new cs_list();
$room_list->add($item);
if ($item->moveWithLinkedRooms()) {
$room_list->addList($item->getProjectRoomList());
$copy_links_between_rooms = true;
// add group rooms from project room
$projectRoomList = $item->getProjectRoomList();
$projectRoom = $projectRoomList->getFirst();
while($projectRoom) {
$room_list->addList($projectRoom->getGroupRoomList());
$projectRoom = $projectRoomList->getNext();
}
}
############################################
# FLAG: group rooms
/** select items limited by limits
* this method returns a list (cs_list) of items within the database limited by the limits.
* depends on _performQuery(), which must be overwritten
*/
function select2($with_linked_items = true)
{
if (isset($this->_id_array_limit)) {
$result = $this->_performQuery2('select', $with_linked_items);
$this->_data = new cs_list();
$this->_id_array = NULL;
if (!$with_linked_items) {
foreach ($result as $query_result) {
$item = $this->_buildItem($query_result);
$this->_data->add($item);
}
} else {
$link_list = new cs_list();
$item_id_array = array();
foreach ($result as $query_result) {
if ($this->_linked_item->getItemID() == $query_result['first_item_id']) {
$item_id_array[] = $query_result['second_item_id'];
} else {
$item_id_array[] = $query_result['first_item_id'];
}
$item = $this->_buildItem($query_result);
$link_list->add($item);
}
$this->_data = $link_list;
}
if (isset($this->_order) and !empty($this->_order) and $this->_order == 'sorting_place') {
$item = $this->_data->getFirst();
$link_list1 = new cs_list();
$link_list2 = new cs_list();
while ($item) {
if ($item->getSortingPlace()) {
$link_list1->add($item);
} else {
$link_list2->add($item);
}
$item = $this->_data->getNext();
}
$link_list1->addList($link_list2);
$this->_data = $link_list1;
unset($link_list1);
unset($link_list2);
}
} else {
parent::select();
}
}
function getSubList($position, $length)
{
$sub_list = new cs_list();
$sub_data_array = array_slice($this->_data, $position, $length);
foreach ($sub_data_array as $sub_data_item) {
$sub_list->add($sub_data_item);
}
return $sub_list;
}
include_once 'classes/cs_list.php';
if (!isset($environment) and isset($this->_environment)) {
$environment = $this->_environment;
}
$translator = $environment->getTranslationObject();
$room_link_list = new cs_list();
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('COMMON_ROOM_META'));
$current_context = $environment->getCurrentContextItem();
$link_item->setIconPath('images/cs_config/COMMON_ROOM_META.gif');
$link_item->setDescription($translator->getMessage('COMMON_ROOM_META_DESC'));
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('preferences');
$link_item->setParameter(array());
$room_link_list->add($link_item);
if ($environment->inPortal()) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_PORTAL_HOME'));
$link_item->setDescription($translator->getMessage('CONFIGURATION_PORTAL_HOME_DESC'));
$link_item->setIconPath('images/cs_config/CONFIGURATION_ROOM_HOME.gif');
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('portalhome');
$link_item->setParameter(array());
$room_link_list->add($link_item);
unset($link_item);
}
if ($environment->inProjectRoom() or $environment->inCommunityRoom() or $environment->inPrivateRoom() or $environment->inGroupRoom()) {
/* $link_item = new cs_link();
$link_item->setTitle($translator->getMessage('RUBRIC_ADMIN'));
// Materialien des Gemeinschaftsraumes
$checkedMaterialIds = array();
$new_material_list = new cs_list();
if (!empty($material_id_array)) {
foreach($material_id_array as $material_id) {
$material_item = $material_list->getFirst();
while($material_item) {
//include_once('functions/error_functions.php');trigger_error('n i y',E_USER_ERROR);
if($material_item->getItemID() == $material_id and $material_item->getContextID() === 0) {
//Get latest Version
$latest_version = $material_manager->getLatestVersionID($material_item->getItemId());
$material_item = $material_manager->getItemByVersion($material_item->getItemId(),$latest_version);
$new_material_list->add($material_item);
$current_context = $environment->getCurrentContextID();
if ($material_item->getContextID() != $current_context){
$checkedMaterialIds[] = $material_item->getItemID();
}
break;
} else {
$material_item = $material_list->getNext();
}
}
}
}
// Materialien anderer Räume
$room_sort = $rooms->getFirst();
while ($room_sort) {
/** select all versions of a material
* this method returns a list (cs_list) of materials in specific versions
*
* @param integer material_id item-id of material
*
* @return cs_list version_list of versions of the material
*/
function getVersionList($material_id)
{
$version_list = new cs_list();
$query = 'SELECT * FROM ' . $this->addDatabasePrefix('materials');
$query .= ' WHERE ' . $this->addDatabasePrefix('materials') . '.item_id="' . encode(AS_DB, $material_id) . '"';
if ($this->_delete_limit == true) {
$query .= ' AND ' . $this->addDatabasePrefix('materials') . '.deleter_id IS NULL';
}
$query .= " ORDER BY " . $this->addDatabasePrefix("materials") . ".version_id DESC";
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting versions of a material from query: "' . $query . '"', E_USER_WARNING);
} else {
foreach ($result as $query_result) {
$material_item = $this->_buildItem($query_result);
$version_list->add($material_item);
}
}
return $version_list;
}
private function _getAllOpenContexts($user_item)
{
$own_room_item = $user_item->getOwnRoom();
if (isset($own_room_item)) {
$customized_room_array = $own_room_item->getCustomizedRoomIDArray();
}
if (isset($customized_room_array[0])) {
return $this->_getCustomizedRoomList($user_item);
} else {
$this->translatorChangeToPortal();
$selected = false;
$selected_future = 0;
$selected_future_pos = -1;
$retour = array();
$temp_array = array();
$temp_array['item_id'] = -1;
$temp_array['title'] = '';
$retour[] = $temp_array;
unset($temp_array);
$temp_array = array();
$community_list = $user_item->getRelatedCommunityList();
if ($community_list->isNotEmpty()) {
$temp_array['item_id'] = -1;
$temp_array['title'] = $this->_translator->getMessage('MYAREA_COMMUNITY_INDEX') . '';
$retour[] = $temp_array;
unset($temp_array);
$community_item = $community_list->getFirst();
while ($community_item) {
$temp_array = array();
$temp_array['item_id'] = $community_item->getItemID();
$title = $community_item->getTitle();
$temp_array['title'] = $title;
if ($community_item->getItemID() == $this->_environment->getCurrentContextID() and !$selected) {
$temp_array['selected'] = true;
$selected = true;
}
$retour[] = $temp_array;
unset($temp_array);
unset($community_item);
$community_item = $community_list->getNext();
}
$temp_array = array();
$temp_array['item_id'] = -1;
$temp_array['title'] = '';
$retour[] = $temp_array;
unset($community_list);
}
$portal_item = $this->_environment->getCurrentPortalItem();
if ($portal_item->showTime()) {
$project_list = $user_item->getRelatedProjectListSortByTimeForMyArea();
include_once 'classes/cs_list.php';
$new_project_list = new cs_list();
$grouproom_array = array();
$project_grouproom_array = array();
if ($project_list->isNotEmpty()) {
$room_item = $project_list->getFirst();
while ($room_item) {
if ($room_item->isA(CS_GROUPROOM_TYPE)) {
$grouproom_array[$room_item->getItemID()] = $room_item->getTitle();
$linked_project_item_id = $room_item->getLinkedProjectItemID();
$project_grouproom_array[$linked_project_item_id][] = $room_item->getItemID();
} else {
$new_project_list->add($room_item);
}
unset($room_item);
$room_item = $project_list->getNext();
}
unset($project_list);
$project_list = $new_project_list;
unset($new_project_list);
}
$future = true;
$future_array = array();
$no_time = false;
$no_time_array = array();
$current_time = $portal_item->getTitleOfCurrentTime();
$with_title = false;
} else {
$project_list = $user_item->getRelatedProjectListForMyArea();
include_once 'classes/cs_list.php';
$new_project_list = new cs_list();
$grouproom_array = array();
$project_grouproom_array = array();
if ($project_list->isNotEmpty()) {
$room_item = $project_list->getFirst();
while ($room_item) {
if ($room_item->isA(CS_GROUPROOM_TYPE)) {
$grouproom_array[$room_item->getItemID()] = $room_item->getTitle();
$linked_project_item_id = $room_item->getLinkedProjectItemID();
$project_grouproom_array[$linked_project_item_id][] = $room_item->getItemID();
} else {
$new_project_list->add($room_item);
}
unset($room_item);
$room_item = $project_list->getNext();
}
unset($project_list);
$project_list = $new_project_list;
unset($new_project_list);
}
}
unset($user_item);
if ($project_list->isNotEmpty()) {
$temp_array['item_id'] = -1;
$temp_array['title'] = $this->_translator->getMessage('MYAREA_PROJECT_INDEX') . '';
$retour[] = $temp_array;
unset($temp_array);
$project_item = $project_list->getFirst();
while ($project_item) {
$temp_array = array();
if ($project_item->isA(CS_PROJECT_TYPE)) {
$temp_array['item_id'] = $project_item->getItemID();
$title = $project_item->getTitle();
$temp_array['title'] = $title;
if ($project_item->getItemID() == $this->_environment->getCurrentContextID() and (!$selected or $selected_future == $project_item->getItemID())) {
$temp_array['selected'] = true;
if (!empty($selected_future) and $selected_future != 0 and $selected_future_pos != -1) {
$selected_future = 0;
unset($future_array[$selected_future_pos]['selected']);
}
$selected = true;
}
// grouprooms
if (isset($project_grouproom_array[$project_item->getItemID()]) and !empty($project_grouproom_array[$project_item->getItemID()]) and $project_item->isGrouproomActive()) {
$group_result_array = array();
$project_grouproom_array[$project_item->getItemID()] = array_unique($project_grouproom_array[$project_item->getItemID()]);
foreach ($project_grouproom_array[$project_item->getItemID()] as $value) {
$group_temp_array = array();
$group_temp_array['item_id'] = $value;
$group_temp_array['title'] = '- ' . $grouproom_array[$value];
if ($value == $this->_environment->getCurrentContextID() and (!$selected or $selected_future == $value)) {
$group_temp_array['selected'] = true;
$selected = true;
if (!empty($selected_future) and $selected_future != 0 and $selected_future_pos != -1) {
$selected_future = 0;
unset($future_array[$selected_future_pos]['selected']);
}
}
$group_result_array[] = $group_temp_array;
unset($group_temp_array);
}
}
} else {
$with_title = true;
$temp_array['item_id'] = -2;
$title = $project_item->getTitle();
if (!empty($title) and $title != 'COMMON_NOT_LINKED') {
$temp_array['title'] = $this->_translator->getTimeMessage($title);
} else {
$temp_array['title'] = $this->_translator->getMessage('COMMON_NOT_LINKED');
$no_time = true;
}
if (!empty($title) and $title == $current_time) {
$future = false;
}
}
if ($portal_item->showTime()) {
if ($no_time) {
$no_time_array[] = $temp_array;
if (isset($group_result_array) and !empty($group_result_array)) {
$no_time_array = array_merge($no_time_array, $group_result_array);
unset($group_result_array);
}
} elseif ($future) {
if ($temp_array['item_id'] != -2) {
$future_array[] = $temp_array;
if (!empty($temp_array['selected']) and $temp_array['selected']) {
$selected_future = $temp_array['item_id'];
$selected_future_pos = count($future_array) - 1;
}
if (isset($group_result_array) and !empty($group_result_array)) {
$future_array = array_merge($future_array, $group_result_array);
unset($group_result_array);
}
}
} else {
$retour[] = $temp_array;
if (isset($group_result_array) and !empty($group_result_array)) {
$retour = array_merge($retour, $group_result_array);
unset($group_result_array);
}
}
} else {
$retour[] = $temp_array;
if (isset($group_result_array) and !empty($group_result_array)) {
$retour = array_merge($retour, $group_result_array);
unset($group_result_array);
}
}
unset($temp_array);
unset($project_item);
$project_item = $project_list->getNext();
}
unset($project_list);
if ($portal_item->showTime()) {
// special case, if no room is linked to a time pulse
if (isset($with_title) and !$with_title) {
$temp_array = array();
$temp_array['item_id'] = -2;
$temp_array['title'] = $this->_translator->getMessage('COMMON_NOT_LINKED');
$retour[] = $temp_array;
unset($temp_array);
$retour = array_merge($retour, $future_array);
$future_array = array();
}
if (!empty($future_array)) {
$future_array2 = array();
$future_array3 = array();
foreach ($future_array as $element) {
if (!in_array($element['item_id'], $future_array3)) {
$future_array3[] = $element['item_id'];
$future_array2[] = $element;
}
}
$future_array = $future_array2;
unset($future_array2);
unset($future_array3);
$temp_array = array();
$temp_array['title'] = $this->_translator->getMessage('COMMON_IN_FUTURE');
$temp_array['item_id'] = -2;
$future_array_begin = array();
$future_array_begin[] = $temp_array;
$future_array = array_merge($future_array_begin, $future_array);
unset($temp_array);
$retour = array_merge($retour, $future_array);
}
if (!empty($no_time_array)) {
$retour = array_merge($retour, $no_time_array);
}
}
}
unset($portal_item);
$this->translatorChangeToCurrentContext();
return $retour;
}
}
function getSortedItemList($id_array, $sortBy)
{
if (empty($id_array)) {
return new cs_list();
} else {
$query = 'SELECT * FROM ' . $this->addDatabasePrefix($this->_db_table) . ' WHERE ' . $this->addDatabasePrefix($this->_db_table) . '.item_id IN ("' . implode('", "', encode(AS_DB, $id_array)) . '") AND ' . $this->addDatabasePrefix($this->_db_table) . '.type LIKE "community"';
$query .= " ORDER BY " . $sortBy;
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting list of ' . $this->_room_type . ' items.', E_USER_WARNING);
} else {
$list = new cs_list();
// filter items with highest version_id, doing this in MySQL would be too expensive
foreach ($result as $rs) {
$list->add($this->_buildItem($rs));
}
}
return $list;
}
}
$rooms->addList($private_rooms);
$rooms->addList($group_rooms);
// Termine des Gemeinschaftsraumes
$checkedAnnouncementIds = array();
$new_announcement_list = new cs_list();
if (!empty($announcement_id_array)) {
foreach($announcement_id_array as $announcement_id) {
$announcement_item = $announcement_list->getFirst();
while($announcement_item) {
//include_once('functions/error_functions.php');trigger_error('n i y',E_USER_ERROR);
if($announcement_item->getItemID() == $announcement_id and $announcement_item->getContextID() === 0) {
$announcement_item = $announcement_manager->getItem($announcement_item->getItemId());
$new_announcement_list->add($announcement_item);
$current_context = $environment->getCurrentContextID();
if ($announcement_item->getContextID() != $current_context){
$checkedAnnouncementIds[] = $announcement_item->getItemID();
}
break;
} else {
$announcement_item = $announcement_list->getNext();
}
}
}
}
// Termine anderer Räume
$room_sort = $rooms->getFirst();
while ($room_sort) {
}
$user = $environment->getCurrentUserItem();
$manager = $environment->getPrivateRoomManager();
$current_context_item = $environment->getCurrentContextItem();
$list2 = $current_context_item->getCustomizedRoomList();
if ( !isset($list2) ) {
// old style (CommSy6)
$list2 = $manager->getRelatedContextListForUserOnPrivateRoomHome($user);
} else {
// remove separators
$list_temp = new cs_list();
$list_item = $list2->getFirst();
while($list_item){
if ( $list_item->getItemID() > 0 ) {
$list_temp->add($list_item);
}
$list_item = $list2->getNext();
}
$list2 = $list_temp;
}
if ( isset($_GET['from']) ) {
$from = $_GET['from'];
} else {
$from = 1;
}
$i=1;
$end = $from+5;
$list3 = new cs_list();
}
if (!isset($translator) and isset($this->_translator)) {
$translator = $this->_translator;
}
$addon_link_list = new cs_list();
global $c_html_textarea;
if ($c_html_textarea) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_TEXTAREA_TITLE'));
$link_item->setDescription($translator->getMessage('CONFIGURATION_TEXTAREA_TITLE_DESC'));
$link_item->setIconPath('images/cs_config/CONFIGURATION_TEXTAREA_TITLE.gif');
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('htmltextarea');
$link_item->setParameter(array());
$addon_link_list->add($link_item);
}
$context_item = $environment->getCurrentContextItem();
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_SERVICE_LINK'));
$link_item->setIconPath('images/cs_config/CONFIGURATION_SERVICE.gif');
$link_item->setDescription($translator->getMessage('CONFIGURATION_SERVICE_DESC'));
$link_item->setContextID($environment->getCurrentContextID());
$link_item->setModule('configuration');
$link_item->setFunction('service');
#$link_item->setParameter(array('iid' => $environment->getCurrentContextID()));
$addon_link_list->add($link_item);
if ($environment->inServer() && $environment->isCurlForPHPAvailable()) {
$link_item = new cs_link();
$link_item->setTitle($translator->getMessage('CONFIGURATION_SCRIBD_LINK'));
$link_item->setIconPath('images/cs_config/CONFIGURATION_SCRIBD_IMAGE.gif');
