/**
* Export to HTML.
*
*/
function exportHTML()
{
global $lng, $tpl, $ilUser, $ilAccess, $ilias;
if (!$ilAccess->checkAccess('read,visible', '', $_GET['ref_id'])) {
$ilias->raiseError($lng->txt('permission_denied'), $ilias->error_obj->MESSAGE);
}
$tplEx = new ilTemplate('tpl.forums_export_html.html', true, true, 'Modules/Forum');
// threads
//for ($j = 0; $j < count($_POST['forum_id']); $j++)
for ($j = 0; $j < count($_POST['thread_ids']); $j++) {
//$objCurrentTopic = new ilForumTopic(addslashes($_POST['forum_id'][$j]), $ilAccess->checkAccess('moderate_frm', '', $_GET['ref_id']));
$objCurrentTopic = new ilForumTopic(addslashes($_POST['thread_ids'][$j]), $ilAccess->checkAccess('moderate_frm', '', $_GET['ref_id']));
// get forum- and thread-data
$this->frm->setMDB2WhereCondition('top_pk = %s ', array('integer'), array($objCurrentTopic->getForumId()));
if (is_array($frmData = $this->frm->getOneTopic())) {
$objFirstPostNode = $objCurrentTopic->getFirstPostNode();
$objCurrentTopic->setOrderField('frm_posts_tree.rgt');
$postTree = $objCurrentTopic->getPostTree($objFirstPostNode);
$posNum = count($postTree);
$z = 0;
foreach ($postTree as $post) {
$tplEx->setCurrentBlock('posts_row');
$rowCol = ilUtil::switchColor($z++, 'tblrow2', 'tblrow1');
$tplEx->setVariable('ROWCOL', $rowCol);
$authorinfo = new ilForumAuthorInformation($post->getUserId(), $post->getUserAlias(), $post->getImportName());
$tplEx->setVariable('AUTHOR', $authorinfo->getAuthorName());
if ($post->getUserId()) {
// get create- and update-dates
if ($post->getUpdateUserId()) {
$authorinfo = new ilForumAuthorInformation($post->getUpdateUserId(), '', '');
$tplEx->setVariable('POST_UPDATE', "<br />[" . $lng->txt('edited_on') . ": " . $this->frm->convertDate($post->getChangeDate()) . " - " . strtolower($lng->txt('from')) . " " . $authorinfo->getAuthorName() . "]");
}
if ($authorinfo->getAuthor()->getPref('public_profile') != 'n') {
$tplEx->setVariable('TXT_REGISTERED', $lng->txt('registered_since'));
$tplEx->setVariable('REGISTERED_SINCE', $this->frm->convertDate($authorinfo->getAuthor()->getCreateDate()));
}
if ($ilAccess->checkAccess('moderate_frm', '', $_GET['ref_id'])) {
$numPosts = $this->frm->countUserArticles($post->getUserId());
} else {
$numPosts = $this->frm->countActiveUserArticles($post->getUserId());
}
$tplEx->setVariable('TXT_NUM_POSTS', $lng->txt('forums_posts'));
$tplEx->setVariable('NUM_POSTS', $numPosts);
}
$tplEx->setVariable('SUBJECT', $post->getSubject());
$tplEx->setVariable('TXT_CREATE_DATE', $lng->txt('forums_thread_create_date'));
$tplEx->setVariable('POST_DATE', $this->frm->convertDate($post->getCreateDate()));
$tplEx->setVariable('SPACER', "<hr noshade width=\"100%\" size=\"1\" align=\"center\" />");
if ($post->isCensored()) {
$tplEx->setVariable('POST', nl2br(stripslashes($post->getCensorshipComment())));
} else {
/** @todo mjansen: possible bugfix for mantis #8223 */
if ($post->getMessage() == strip_tags($post->getMessage())) {
// We can be sure, that there are not html tags
$post->setMessage(nl2br($post->getMessage()));
}
$tplEx->setVariable('POST', ilRTE::_replaceMediaObjectImageSrc($this->frm->prepareText($post->getMessage(), 0, '', 'export'), 1));
}
$tplEx->parseCurrentBlock('posts_row');
unset($author);
}
// foreach ($postTree as $post)
$tplEx->setCurrentBlock('posttable');
$tplEx->setVariable('TXT_AUTHOR', $lng->txt('author'));
$tplEx->setVariable('TXT_POST', $lng->txt('forums_thread') . ': ' . $objCurrentTopic->getSubject());
$tplEx->parseCurrentBlock('posttable');
// Thread Headline
$tplEx->setCurrentBlock('thread_headline');
$tplEx->setVariable('T_TITLE', $objCurrentTopic->getSubject());
if ($ilAccess->checkAccess('moderate_frm', '', $_GET['ref_id'])) {
$tplEx->setVariable('T_NUM_POSTS', $objCurrentTopic->countPosts());
} else {
$tplEx->setVariable('T_NUM_POSTS', $objCurrentTopic->countActivePosts());
}
$tplEx->setVariable('T_NUM_VISITS', $objCurrentTopic->getVisits());
$tplEx->setVariable('T_FORUM', $frmData['top_name']);
$authorinfo = new ilForumAuthorInformation($objCurrentTopic->getUserId(), $objCurrentTopic->getUserAlias(), $objCurrentTopic->getImportName());
$tplEx->setVariable('T_AUTHOR', $authorinfo->getAuthorName());
$tplEx->setVariable('T_TXT_FORUM', $lng->txt('forum') . ': ');
$tplEx->setVariable('T_TXT_TOPIC', $lng->txt('forums_thread') . ': ');
$tplEx->setVariable('T_TXT_AUTHOR', $lng->txt('forums_thread_create_from') . ': ');
$tplEx->setVariable('T_TXT_NUM_POSTS', $lng->txt('forums_articles') . ': ');
$tplEx->setVariable('T_TXT_NUM_VISITS', $lng->txt('visits') . ': ');
$tplEx->parseCurrentBlock('thread_headline');
$tplEx->setCurrentBlock('thread_block');
$tplEx->parseCurrentBlock('thread_block');
$tplEx->setCurrentBlock('forum_block');
$tplEx->parseCurrentBlock('forum_block');
}
// if (is_array($frmData = $this->frm->getOneTopic()))
}
// for ($j = 0; $j < count($_POST["forum_id"]); $j++)
ilUtil::deliverData($tplEx->get(), 'forum_html_export_' . $_GET['ref_id'] . '.html');
exit;
}
/**
* Moves all chosen threads and their posts to a new forum
*
* @param array chosen thread pks
* @param integer object id of src forum
* @param integer object id of dest forum
* @access public
*/
public function moveThreads($thread_ids = array(), $src_ref_id = 0, $dest_top_frm_fk = 0)
{
global $ilDB;
$src_top_frm_fk = ilObject::_lookupObjectId($src_ref_id);
if (is_numeric($src_top_frm_fk) && $src_top_frm_fk > 0 && is_numeric($dest_top_frm_fk) && $dest_top_frm_fk > 0) {
$this->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($src_top_frm_fk));
$oldFrmData = $this->getOneTopic();
$this->setMDB2WhereCondition('top_frm_fk = %s ', array('integer'), array($dest_top_frm_fk));
$newFrmData = $this->getOneTopic();
if ($oldFrmData['top_pk'] && $newFrmData['top_pk']) {
$moved_posts = 0;
$moved_threads = 0;
$visits = 0;
foreach ($thread_ids as $id) {
$objTmpThread = new ilForumTopic($id);
$numPosts = $objTmpThread->movePosts($src_top_frm_fk, $oldFrmData['top_pk'], $dest_top_frm_fk, $newFrmData['top_pk']);
if (($last_post_string = $objTmpThread->getLastPostString()) != '') {
$last_post_string = explode('#', $last_post_string);
$last_post_string[0] = $newFrmData['top_pk'];
$last_post_string = implode('#', $last_post_string);
$objTmpThread->setLastPostString($last_post_string);
}
$visits += $objTmpThread->getVisits();
$moved_posts += $numPosts;
++$moved_threads;
$objTmpThread->setForumId($newFrmData['top_pk']);
$objTmpThread->update();
unset($objTmpThread);
}
// update frm_data source forum
$ilDB->setLimit(1);
$res = $ilDB->queryf('
SELECT pos_thr_fk, pos_pk
FROM frm_posts
WHERE pos_top_fk = %s
ORDER BY pos_date DESC', array('integer'), array($oldFrmData['top_pk']));
$row = $ilDB->fetchObject($res);
$last_post_src = $oldFrmData['top_pk'] . '#' . $row->pos_thr_fk . '#' . $row->pos_pk;
$statement = $ilDB->manipulateF('
UPDATE frm_data
SET top_num_posts = top_num_posts - %s,
top_num_threads = top_num_threads - %s,
visits = visits - %s,
top_last_post = %s
WHERE top_pk = %s', array('integer', 'integer', 'integer', 'text', 'integer'), array($moved_posts, $moved_threads, $visits, $last_post_src, $oldFrmData['top_pk']));
// update frm_data destination forum
$ilDB->setLimit(1);
$res = $ilDB->queryf('
SELECT pos_thr_fk, pos_pk
FROM frm_posts
WHERE pos_top_fk = %s
ORDER BY pos_date DESC', array('integer'), array($newFrmData['top_kp']));
$row = $ilDB->fetchObject($res);
$last_post_dest = $newFrmData['top_pk'] . '#' . $row->pos_thr_fk . '#' . $row->pos_pk;
$statement = $ilDB->manipulateF('
UPDATE frm_data
SET top_num_posts = top_num_posts + %s,
top_num_threads = top_num_threads + %s,
visits = visits + %s,
top_last_post = %s
WHERE top_pk = %s', array('integer', 'integer', 'integer', 'text', 'integer'), array($moved_posts, $moved_threads, $visits, $last_post_dest, $newFrmData['top_pk']));
/*
// update news items
include_once("./Services/News/classes/class.ilNewsItem.php");
$objNewsItem = new ilNewsItem();
$news_items = $objNewsItem->getNewsForRefId($src_ref_id);
foreach ($news_items as $news_item)
{
$tmpObjNewsItem = new ilNewsItem($news_item['id']);
if ($tmpObjNewsItem->getContextObjId() == $src_top_frm_fk)
{
$tmpObjNewsItem->setContextObjId($dest_top_frm_fk);
$tmpObjNewsItem->update();
}
unset($tmpObjNewsItem);
}
*/
}
}
}
/**
* @param ilForumTopic $thread
*/
public function fillRow(ilForumTopic $thread)
{
/**
* @var $ilUser ilObjUser
*/
global $ilUser;
$this->ctrl->setParameter($this->getParentObject(), 'thr_pk', $thread->getId());
if ('mergeThreads' == $this->parent_cmd) {
$checked = $this->max_count == 1 || isset($_POST['thread_ids']) && in_array($thread->getId(), $_POST['thread_ids']);
$this->tpl->setVariable('VAL_CHECK', ilUtil::formRadioButton($checked, 'thread_ids[]', $thread->getId()));
} else {
if ('showThreads' == $this->parent_cmd) {
$this->tpl->setVariable('VAL_CHECK', ilUtil::formCheckbox(isset($_POST['thread_ids']) && in_array($thread->getId(), $_POST['thread_ids']) ? true : false, 'thread_ids[]', $thread->getId()));
} else {
if ($thread->isSticky()) {
$this->tpl->setVariable('VAL_SORTING_NAME', 'thread_sorting[' . $thread->getId() . ']');
$this->tpl->setVariable('VAL_SORTING', (int) $this->position * 10);
} else {
$this->tpl->setVariable('VAL_CHECK', '');
}
$this->position++;
}
}
$subject = '';
if ($thread->isSticky()) {
$subject .= '<span class="light">[' . $this->lng->txt('sticky') . ']</span> ';
}
if ($thread->isClosed()) {
$subject .= '<span class="light">[' . $this->lng->txt('topic_close') . ']</span> ';
}
if (!$ilUser->isAnonymous() && $this->ilias->getSetting('forum_notification') != 0 && $thread->getUserNotificationEnabled()) {
$subject .= '<span class="light">[' . $this->lng->txt('forums_notification_enabled') . ']</span> ';
}
$num_posts = $thread->getNumPosts();
$num_unread = $thread->getNumUnreadPosts();
$num_new = $thread->getNumNewPosts();
if ($num_posts > 0) {
$subject = '<div><a href="' . $this->ctrl->getLinkTarget($this->getParentObject(), 'viewThread') . '">' . $thread->getSubject() . '</a></div>' . $subject;
} else {
$subject = $thread->getSubject() . $subject;
}
$this->tpl->setVariable('VAL_SUBJECT', $subject);
// Author
$this->ctrl->setParameter($this->getParentObject(), 'backurl', urlencode($this->ctrl->getLinkTargetByClass("ilrepositorygui", "")));
$this->ctrl->setParameter($this->getParentObject(), 'user', $thread->getUserId());
$authorinfo = new ilForumAuthorInformation($thread->getUserId(), $thread->getUserAlias(), $thread->getImportName(), array('class' => 'il_ItemProperty', 'href' => $this->ctrl->getLinkTarget($this->getParentObject(), 'showUser')));
$this->tpl->setVariable('VAL_AUTHOR', $authorinfo->getLinkedAuthorName());
$topicStats = $num_posts;
if (!$ilUser->isAnonymous()) {
if ($num_unread > 0) {
$topicStats .= '<br /><span class="alert ilWhiteSpaceNowrap">' . $this->lng->txt('unread') . ': ' . $num_unread . '</span>';
}
if ($num_new > 0 && $this->getOverviewSetting() == 0) {
$topicStats .= '<br /><span class="alert ilWhiteSpaceNowrap">' . $this->lng->txt('new') . ': ' . $num_new . '</span>';
}
}
$this->tpl->setVariable('VAL_ARTICLE_STATS', $topicStats);
$this->tpl->setVariable('VAL_NUM_VISIT', $thread->getVisits());
// Last posting
if ($num_posts > 0) {
if ($this->getIsModerator()) {
$objLastPost = $thread->getLastPost();
} else {
$objLastPost = $thread->getLastActivePost();
}
if (is_object($objLastPost)) {
$authorinfo = new ilForumAuthorInformation($objLastPost->getUserId(), $objLastPost->getUserAlias(), $objLastPost->getImportName(), array('href' => $this->ctrl->getLinkTarget($this->getParentObject(), 'viewThread') . '#' . $objLastPost->getId()));
$this->tpl->setVariable('VAL_LP_DATE', '<div class="ilWhiteSpaceNowrap">' . ilDatePresentation::formatDate(new ilDateTime($objLastPost->getCreateDate(), IL_CAL_DATETIME)) . '</div>' . '<div class="ilWhiteSpaceNowrap">' . $this->lng->txt('from') . ' ' . $authorinfo->getLinkedAuthorName() . '</div>');
}
}
// Row style
$css_row = $this->css_row;
if ($thread->isSticky()) {
$css_row = $css_row == 'tblrow1' ? 'tblstickyrow1' : 'tblstickyrow2';
}
$this->tpl->setVariable('CSS_ROW', $css_row);
$this->ctrl->setParameter($this->getParentObject(), 'thr_pk', '');
$this->ctrl->setParameter($this->getParentObject(), 'user', '');
$this->ctrl->setParameter($this->getParentObject(), 'backurl', '');
}
/**
*
*/
public function exportHTML()
{
/**
* @var $tpl ilTemplate
* @var $lng ilLanguage
* @var $ilAccess ilAccessHandler
* @var $ilias ILIAS
*/
global $lng, $tpl, $ilAccess, $ilias;
if (!$ilAccess->checkAccess('read,visible', '', $_GET['ref_id'])) {
$ilias->raiseError($lng->txt('permission_denied'), $ilias->error_obj->MESSAGE);
}
ilDatePresentation::setUseRelativeDates(false);
$tpl = new ilTemplate('tpl.forums_export_html.html', true, true, 'Modules/Forum');
$location_stylesheet = ilUtil::getStyleSheetLocation();
$tpl->setVariable('LOCATION_STYLESHEET', $location_stylesheet);
$tpl->setVariable('BASE', substr(ILIAS_HTTP_PATH, -1) == '/' ? ILIAS_HTTP_PATH : ILIAS_HTTP_PATH . '/');
$num_threads = count((array) $_POST['thread_ids']);
for ($j = 0; $j < $num_threads; $j++) {
$topic = new ilForumTopic((int) $_POST['thread_ids'][$j], $this->is_moderator);
$this->frm->setMDB2WhereCondition('top_pk = %s ', array('integer'), array($topic->getForumId()));
if (is_array($thread_data = $this->frm->getOneTopic())) {
if (0 == $j) {
$tpl->setVariable('TITLE', $thread_data['top_name']);
}
$first_post = $topic->getFirstPostNode();
$topic->setOrderField('frm_posts_tree.rgt');
$post_collection = $topic->getPostTree($first_post);
$z = 0;
foreach ($post_collection as $post) {
$this->renderPostHtml($tpl, $post, $z++, self::MODE_EXPORT_CLIENT);
}
$tpl->setCurrentBlock('thread_headline');
$tpl->setVariable('T_TITLE', $topic->getSubject());
if ($this->is_moderator) {
$tpl->setVariable('T_NUM_POSTS', $topic->countPosts());
} else {
$tpl->setVariable('T_NUM_POSTS', $topic->countActivePosts());
}
$tpl->setVariable('T_NUM_VISITS', $topic->getVisits());
$tpl->setVariable('T_FORUM', $thread_data['top_name']);
$authorinfo = new ilForumAuthorInformation($topic->getThrAuthorId(), $topic->getDisplayUserId(), $topic->getUserAlias(), $topic->getImportName());
$tpl->setVariable('T_AUTHOR', $authorinfo->getAuthorName());
$tpl->setVariable('T_TXT_FORUM', $lng->txt('forum') . ': ');
$tpl->setVariable('T_TXT_TOPIC', $lng->txt('forums_thread') . ': ');
$tpl->setVariable('T_TXT_AUTHOR', $lng->txt('forums_thread_create_from') . ': ');
$tpl->setVariable('T_TXT_NUM_POSTS', $lng->txt('forums_articles') . ': ');
$tpl->setVariable('T_TXT_NUM_VISITS', $lng->txt('visits') . ': ');
$tpl->parseCurrentBlock();
}
$tpl->setCurrentBlock('thread_block');
$tpl->parseCurrentBlock();
}
ilUtil::deliverData($tpl->get('DEFAULT', false, false, false, true, false, false), 'forum_html_export_' . $_GET['ref_id'] . '.html');
}
