public function display($tpl = null)
{
$doc = JFactory::getDocument();
$my = JFactory::getUser();
EDC::setPageTitle(JText::_('COM_EASYDISCUSS_PAGETITLE_ASSIGNED'));
$this->setPathway(JText::_('COM_EASYDISCUSS_BREADCRUMB_ASSIGNED'));
if (!EDC::isModerator()) {
return JError::raiseError(404, JText::_('COM_EASYDISCUSS_YOU_ARE_NOT_ALLOWED_HERE'));
}
$subs = array();
// [Model:Assigned]
$model = EDC::getModel('Assigned');
$posts = $model->getPosts();
$posts = EDC::formatPost($posts);
$posts = Discusshelper::getPostStatusAndTypes($posts);
// Get total number of posts assigned to the current user.
$totalAssigned = $model->getTotalAssigned($my->id);
// Get total number of posts that is assigned to this user and resolved.
// [Model:Assigned]
$totalResolved = $model->getTotalSolved($my->id);
// Calculate percentage
$percentage = 0;
if ($posts) {
$percentage = round($totalResolved / $totalAssigned * 100, 2);
}
$theme = new DiscussThemes();
$theme->set('totalAssigned', $totalAssigned);
$theme->set('totalResolved', $totalResolved);
$theme->set('percentage', $percentage);
$theme->set('posts', $posts);
echo $theme->fetch('assigned.php');
}
public static function getUnansweredCount($categoryId = '0', $excludeFeatured = false)
{
$db = DiscussHelper::getDBO();
$excludeCats = DiscussHelper::getPrivateCategories();
$catModel = DiscussHelper::getModel('Categories');
if (!is_array($categoryId) && !empty($categoryId)) {
$categoryId = array($categoryId);
}
$childs = array();
if ($categoryId) {
foreach ($categoryId as $id) {
$data = $catModel->getChildIds($id);
if ($data) {
foreach ($data as $childCategory) {
$childs[] = $childCategory;
}
}
$childs[] = $id;
}
}
if (!$categoryId) {
$categoryIds = false;
} else {
$categoryIds = array_diff($childs, $excludeCats);
}
$query = 'SELECT COUNT(a.`id`) FROM `#__discuss_posts` AS a';
$query .= ' LEFT JOIN `#__discuss_posts` AS b';
$query .= ' ON a.`id`=b.`parent_id`';
$query .= ' AND b.`published`=' . $db->Quote('1');
$query .= ' WHERE a.`parent_id` = ' . $db->Quote('0');
$query .= ' AND a.`published`=' . $db->Quote('1');
$query .= ' AND a.`answered` = 0';
$query .= ' AND a.`isresolve`=' . $db->Quote('0');
$query .= ' AND b.`id` IS NULL';
if ($categoryIds) {
if (count($categoryIds) == 1) {
$categoryIds = array_shift($categoryIds);
$query .= ' AND a.`category_id` = ' . $db->Quote($categoryIds);
} else {
$query .= ' AND a.`category_id` IN (' . implode(',', $categoryIds) . ')';
}
}
if ($excludeFeatured) {
$query .= ' AND a.`featured`=' . $db->Quote('0');
}
if (!EDC::isSiteAdmin() && !EDC::isModerator()) {
$query .= ' AND a.`private`=' . $db->Quote(0);
}
$db->setQuery($query);
return $db->loadResult();
}
public function display($tpl = null)
{
// Initialise variables
$doc = JFactory::getDocument();
$my = JFactory::getUser();
$config = DiscussHelper::getConfig();
$app = JFactory::getApplication();
$registry = DiscussHelper::getRegistry();
$categoryId = JRequest::getInt('category_id', 0);
// Perform redirection if there is a category_id in the index view.
if (!empty($categoryId)) {
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=categories&layout=listings&category_id=' . $categoryId, false));
$app->close();
}
// Try to detect if there's any category id being set in the menu parameter.
$activeMenu = $app->getMenu()->getActive();
if ($activeMenu && !$categoryId) {
// Load menu params to the registry.
$registry->loadString($activeMenu->params);
if ($registry->get('category_id')) {
$categoryId = $registry->get('category_id');
}
}
// Get the current logged in user's access.
$acl = DiscussHelper::getHelper('ACL');
// Todo: Perhaps we should fix the confused naming of filter and sort to type and sort
$filter = JRequest::getString('filter', $registry->get('filter'));
$sort = JRequest::getString('sort', $registry->get('sort'));
// Get the pagination limit
$limit = $registry->get('limit');
$limit = $limit == '-2' ? DiscussHelper::getListLimit() : $limit;
$limit = $limit == '-1' ? DiscussHelper::getJConfig()->get('list_limit') : $limit;
// Add view to this page.
$this->logView();
// set page title.
DiscussHelper::setPageTitle();
// Set the meta of the page.
DiscussHelper::setMeta();
// Add rss feed into headers
DiscussHelper::getHelper('Feeds')->addHeaders('index.php?option=com_easydiscuss&view=index');
// Get list of categories on the site.
$catModel = $this->getModel('Categories');
// Pagination is by default disabled.
$pagination = false;
// Get the model.
$postModel = DiscussHelper::getModel('Posts');
// Get a list of accessible categories
$cats = $this->getAccessibleCategories($categoryId);
// Get featured posts from this particular category.
$featured = array();
if ($config->get('layout_featuredpost_frontpage')) {
$options = array('pagination' => false, 'category' => $cats, 'sort' => $sort, 'filter' => $filter, 'limit' => $config->get('layout_featuredpost_limit', $limit), 'featured' => true);
$featured = $postModel->getDiscussions($options);
if (is_null($featured)) {
$featured = array();
}
}
// Get normal discussion posts.
$options = array('sort' => $sort, 'category' => $cats, 'filter' => $filter, 'limit' => $limit, 'featured' => false);
$posts = $postModel->getDiscussions($options);
if (is_null($posts)) {
$posts = array();
}
$authorIds = array();
$topicIds = array();
$tmpPostsArr = array_merge($featured, $posts);
if (count($tmpPostsArr) > 0) {
foreach ($tmpPostsArr as $tmpArr) {
$authorIds[] = $tmpArr->user_id;
$topicIds[] = $tmpArr->id;
}
}
$pagination = $postModel->getPagination(0, 'latest', '', $cats, false);
$postLoader = EDC::getTable('Posts');
$postLoader->loadBatch($topicIds);
$postTagsModel = EDC::getModel('PostsTags');
$postTagsModel->setPostTagsBatch($topicIds);
$model = EDC::getModel('Posts');
$lastReplyUser = $model->setLastReplyBatch($topicIds);
// Reduce SQL queries by pre-loading all author object.
$authorIds = array_merge($lastReplyUser, $authorIds);
$authorIds = array_unique($authorIds);
// Initialize the list of user's so we run lesser sql queries.
$profile = EDC::getTable('Profile');
$profile->init($authorIds);
// Format featured entries.
$featured = EDC::formatPost($featured, false, true);
// Format normal entries
$posts = EDC::formatPost($posts, false, true);
// Get unread count
$unreadCount = $model->getUnreadCount($cats, false);
// Get unresolved count
// Change the "all" to TRUE or FALSE to include/exclude featured post count
$unresolvedCount = $model->getUnresolvedCount('', $cats, '', 'all');
// Get resolved count
$resolvedCount = $model->getTotalResolved();
// Get unanswered count
$unansweredCount = EDC::getUnansweredCount($cats, true);
// Get assigned post count that isn't answered yet.
$assignedCount = 0;
if (EDC::isSiteAdmin() || EDC::isModerator()) {
$assignedModel = EDC::getModel('Assigned');
$assignedCount = $assignedModel->getTotalUnresolved();
}
$activeFilter = $config->get('layout_frontpage_sorting');
// Let's render the layout now.
$theme = new DiscussThemes();
$theme->set('assignedCount', $assignedCount);
$theme->set('activeFilter', $activeFilter);
$theme->set('activeSort', $sort);
$theme->set('categories', $categoryId);
$theme->set('unreadCount', $unreadCount);
$theme->set('unansweredCount', $unansweredCount);
$theme->set('resolvedCount', $resolvedCount);
$theme->set('unresolvedCount', $unresolvedCount);
$theme->set('posts', $posts);
$theme->set('featured', $featured);
$theme->set('pagination', $pagination);
echo $theme->fetch('frontpage.index.php');
}
public function getUnreadCount($category = 0, $excludeFeatured = false)
{
$db = DiscussHelper::getDBO();
$my = JFactory::getUser();
$excludeCats = DiscussHelper::getPrivateCategories();
if (!is_array($category)) {
$category = array($category);
}
$catModel = DiscussHelper::getModel('Categories');
$childs = array();
foreach ($category as $categoryId) {
$data = $catModel->getChildIds($categoryId);
if ($data) {
foreach ($data as $childCategory) {
$childs[] = $childCategory;
}
}
$childs[] = $categoryId;
}
if (empty($category)) {
$categoryIds = false;
} else {
$categoryIds = array_diff($childs, $excludeCats);
if (empty($categoryIds)) {
return '0';
}
}
$profile = DiscussHelper::getTable('Profile');
$profile->load($my->id);
$readPosts = $profile->posts_read;
$extraSQL = '';
if ($readPosts) {
$readPosts = unserialize($readPosts);
if (count($readPosts) > 1) {
$extraSQL = implode(',', $readPosts);
$extraSQL = ' AND `id` NOT IN (' . $extraSQL . ')';
} else {
$extraSQL = ' AND `id` != ' . $db->Quote($readPosts[0]);
}
}
$query = 'SELECT COUNT(1) FROM `#__discuss_posts`';
$query .= ' WHERE `published` = ' . $db->Quote('1');
$query .= ' AND `parent_id` = ' . $db->Quote('0');
if ($categoryIds && !(count($categoryIds) == 1 && empty($categoryIds[0]))) {
if (count($categoryIds) == 1) {
$query .= ' AND `category_id` = ' . $db->Quote($categoryIds[0]);
} else {
$query .= ' AND `category_id` IN (' . implode(',', $categoryIds) . ')';
}
}
$query .= ' AND `answered` = ' . $db->Quote('0');
if ($excludeFeatured) {
$query .= ' AND `featured` = ' . $db->Quote('0');
}
if (!EDC::isSiteAdmin() && !EDC::isModerator()) {
$query .= ' AND `private`=' . $db->Quote(0);
}
$query .= ' AND `legacy` = ' . $db->Quote('0');
$query .= $extraSQL;
$db->setQuery($query);
$result = $db->loadResult();
return empty($result) ? '0' : $result;
}
/**
* Displays al ist of moderators on the site.
*
* @since 3.2
* @access public
* @param string
* @return
*/
public function getModerators()
{
$ajax = DiscussHelper::getHelper('Ajax');
if (!EDC::isSiteAdmin() && !EDC::isModerator()) {
return;
}
$postId = JRequest::getString('id');
$categoryId = JRequest::getString('category_id');
$moderators = DiscussHelper::getHelper('Moderator')->getModeratorsDropdown($categoryId);
$html = '';
if (!empty($moderators)) {
$theme = new DiscussThemes();
$theme->set('moderators', $moderators);
$theme->set('postId', $postId);
$html = $theme->fetch('post.assignment.item.php');
} else {
$html = '<li class="pa-10">' . JText::_('COM_EASYDISCUSS_NO_MODERATOR_FOUND') . '</li>';
}
$ajax->success($html);
}
<li class="filterItem<?php
echo $activeFilter == 'mine' ? ' active' : '';
?>
" data-filter-tab data-filter-type="mine">
<a class="mineFilter" href="javascript:void(0);">
<?php
echo JText::_('COM_EASYDISCUSS_MY_POSTS');
?>
</a>
</li>
<?php
}
?>
<?php
if (EDC::isSiteAdmin() || EDC::isModerator()) {
?>
<li class="filterItem<?php
echo $activeFilter == 'assigned' ? ' active' : '';
?>
" data-filter-tab data-filter-type="assigned">
<a class="mineFilter" href="javascript:void(0);">
<?php
echo JText::_('COM_EASYDISCUSS_ASSIGNED_POSTS');
?>
<span class="label label-important label-notification"><?php
echo $assignedCount;
?>
</span>
</a>
</li>
/**
* Handles POST request for new discussions
*
* @since 3.0
* @access public
*/
public function submit()
{
JRequest::checkToken('request') or jexit('Invalid Token');
$config = DiscussHelper::getConfig();
$my = JFactory::getUser();
$app = JFactory::getApplication();
$acl = DiscussHelper::getHelper('ACL');
// If guest posting is disallowed in the settings, they shouldn't be able to create a discussion at all.
if (!$my->id && !$acl->allowed('add_question', '0')) {
DiscussHelper::setMessageQueue(JText::_('COM_EASYDISCUSS_POST_PLEASE_LOGIN'), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss', false));
return $app->close();
}
// If user is disallowed in the acl, they shouldn't be able to create a discussion at all.
if ($my->id && !$acl->allowed('add_question', '0')) {
DiscussHelper::setMessageQueue(JText::_('COM_EASYDISCUSS_SYSTEM_INSUFFICIENT_PERMISSIONS'), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss', false));
return $app->close();
}
// Get values from the posted form.
$data = JRequest::get('post');
if (isset($data['mod_post_topic_category_id'])) {
$data['category_id'] = $data['mod_post_topic_category_id'];
unset($data['mod_post_topic_category_id']);
}
// Run validation on the posted data.
if (!$this->_fieldValidate($data)) {
$files = JRequest::getVar('filedata', array(), 'FILES');
$data['attachments'] = $files;
DiscussHelper::storeSession($data, 'NEW_POST_TOKEN');
$app->redirect(DiscussRouter::getAskRoute(null, false));
}
// get id if available
$id = JRequest::getInt('id', 0);
// bind the table
$post = DiscussHelper::getTable('Post');
$post->load($id);
// set is new value
$isNew = !$post->id ? true : false;
// If the post is edited and it doesn't have private the user might be switching from private -> non private
if (!$isNew && !isset($data['private'])) {
$post->private = false;
}
// Perform captcha validation
$state = EDC::validateCaptcha($data);
if (!$state) {
// Store the data into the session
EDC::storeSession($data, 'NEW_POST_TOKEN');
// Set error message
EDC::setMessageQueue(JText::_('COM_EASYDISCUSS_INVALID_CAPTCHA'), DISCUSS_QUEUE_ERROR);
if ($isNew) {
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=ask', false));
} else {
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=ask&id=' . $post->id, false));
}
}
$previousTags = array();
if (!$isNew) {
//check if admin or is owner before allowing edit.
$isMine = DiscussHelper::isMine($post->user_id);
$isAdmin = DiscussHelper::isSiteAdmin();
$isEditor = $acl->allowed('edit_question');
if (!$my->id && !$isMine && !$isAdmin && !$isEditor) {
DiscussHelper::setMessageQueue(JText::_('COM_EASYDISCUSS_NO_PERMISSION_TO_PERFORM_THE_REQUESTED_ACTION'), DISCUSS_QUEUE_ERROR);
$this->setRedirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=post&id=' . $id, false));
return;
}
// If this is an edited post, we need to remove existing tags and add them back again.
$postsTagsModel = $this->getModel('PostsTags');
$tmppreviousTags = $postsTagsModel->getPostTags($id);
if (!empty($tmppreviousTags)) {
foreach ($tmppreviousTags as $previoustag) {
$previousTags[] = $previoustag->id;
}
}
if ($acl->allowed('add_tag', '0')) {
$postsTagsModel->deletePostTag($id);
}
}
// Get raw content from request as we may need to respect the html codes.
$content = JRequest::getVar('dc_reply_content', '', 'post', 'none', JREQUEST_ALLOWRAW);
if (empty($content)) {
// if there is no content from component, get from module quick question
$content = JRequest::getVar('quick_question_reply_content', '', 'post', 'none', JREQUEST_ALLOWRAW);
}
// some joomla editor htmlentity the content before it send to server. so we need
// to do the god job to fix the content.
$content = DiscussHelper::getHelper('String ')->unhtmlentities($content);
// Ensure that the posted content is respecting the correct values.
$data['dc_reply_content'] = $content;
// Cleanup alias.
$alias = DiscussHelper::wordFilter($data['title']);
$data['alias'] = DiscussHelper::getAlias($alias, 'post', $post->id);
// Detect the poster type.
$data['user_type'] = empty($my->id) ? 'guest' : 'member';
// Akismet configurations.
if ($config->get('antispam_akismet') && $config->get('antispam_akismet_key')) {
require_once DISCUSS_CLASSES . '/akismet.php';
$params = array($data['title'], $data['dc_reply_content']);
foreach ($params as $param) {
$akismet = new Akismet(DISCUSS_JURIROOT, $config->get('antispam_akismet_key'), array('author' => $my->name, 'email' => $my->email, 'website' => DISCUSS_JURIROOT, 'body' => urlencode($param), 'alias' => ''));
// Detect if there's any errors in Akismet.
if (!$akismet->errorsExist() && $akismet->isSpam()) {
DiscussHelper::setMessageQueue(JText::_('COM_EASYDISCUSS_AKISMET_SPAM_DETECTED'), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=ask', false));
return $app->close();
}
}
}
// Get previous status before binding.
$prevPostStatus = $post->published;
// If post is being edited, do not change the owner of the item.
if (!$post->id) {
$data['user_id'] = !$post->user_id ? $my->id : $post->user_id;
}
// Check permission to modify assignee
$category = DiscussHelper::getTable('Category');
$access = $post->getAccess($category);
if ($access->canAssign()) {
$assignment = DiscussHelper::getTable('PostAssignment');
$assignment->load($post->id);
// Add new record if assignee was changed
if (array_key_exists('assignee_id', $data) && $assignment->assignee_id != $data['assignee_id']) {
$newAssignment = DiscussHelper::getTable('PostAssignment');
$newAssignment->post_id = $post->id;
$newAssignment->assignee_id = (int) $data['assignee_id'];
$newAssignment->assigner_id = (int) JFactory::getUser()->id;
if (!$newAssignment->store()) {
$ajax->fail('Storing failed');
return $ajax->send();
}
}
}
$data['content_type'] = DiscussHelper::getEditorType('question');
// Bind posted data against the table.
$post->bind($data, true);
// Set all post to be published by default.
$post->published = DISCUSS_ID_PUBLISHED;
// Detect if post should be moderated.
if ($config->get('main_moderatepost') && !DiscussHelper::isSiteAdmin($post->user_id) && !DiscussHelper::isModerateThreshold($post->user_id)) {
$post->published = DISCUSS_ID_PENDING;
}
// Bind posted parameters such as custom tab contents.
$post->bindParams($data);
// Check for maximum length of content if category has specific settings.
$category = DiscussHelper::getTable('Category');
$category->load($post->category_id);
// If there's a maximum content length specified per category base, then we need to check against the content.
if ($category->getParam('maxlength')) {
$length = JString::strlen($post->content);
if ($length > $category->getParam('maxlength_size', 1000)) {
DiscussHelper::storeSession($data, 'NEW_POST_TOKEN');
DiscussHelper::setMessageQueue(JText::sprintf('COM_EASYDISCUSS_MAXIMUM_LENGTH_EXCEEDED', $category->getParam('maxlength_size', 1000)), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=ask', false));
return $app->close();
}
}
// If user tries to submit in a container, throw an error.
if ($category->container) {
DiscussHelper::storeSession($data, 'NEW_POST_TOKEN');
DiscussHelper::setMessageQueue(JText::_('COM_EASYDISCUSS_NOT_ALLOWED_TO_POST_INTO_CONTAINER'), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::_('index.php?option=com_easydiscuss&view=ask', false));
return $app->close();
}
// @trigger: onBeforeSave
DiscussEventsHelper::importPlugin('content');
DiscussEventsHelper::onContentBeforeSave('post', $post, $isNew);
// If password is disabled, do not allow users to set password.
if (!$config->get('main_password_protection')) {
$post->password = '';
}
// Detect user's ip address.
$ip = JRequest::getVar('REMOTE_ADDR', '', 'SERVER');
$post->ip = $ip;
// Try to store the post object.
if (!$post->store()) {
DiscussHelper::setMessageQueue($post->getError(), DISCUSS_QUEUE_ERROR);
$app->redirect(DiscussRouter::getAskRoute($category->id, false));
return $app->close();
}
// API: References.
$reference = JRequest::getWord('reference', '');
$referenceId = JRequest::getInt('reference_id', 0);
if (!empty($reference) && !empty($referenceId)) {
$referenceTable = DiscussHelper::getTable('PostsReference');
$referenceTable->extension = $reference;
$referenceTable->post_id = $post->id;
$referenceTable->reference_id = $referenceId;
$referenceTable->store();
}
//Clear off previous records before storing
$ruleModel = DiscussHelper::getModel('CustomFields');
$ruleModel->deleteCustomFieldsValue($post->id, 'update');
// Process custom fields.
$fieldIds = JRequest::getVar('customFields');
if (!empty($fieldIds)) {
foreach ($fieldIds as $fieldId) {
$fields = JRequest::getVar('customFieldValue_' . $fieldId);
if (!empty($fields)) {
// Cater for custom fields select list
// To detect if there is no value selected for the select list custom fields
if (in_array('defaultList', $fields)) {
$tempKey = array_search('defaultList', $fields);
$fields[$tempKey] = '';
}
}
$post->bindCustomFields($fields, $fieldId);
}
}
// @trigger: onAfterSave
DiscussEventsHelper::onContentAfterSave('post', $post, $isNew);
// The category_id for the replies should change too
$post->moveChilds($post->id, $post->category_id);
// Process poll items.
if ($config->get('main_polls')) {
$polls = JRequest::getVar('pollitems');
if (!is_array($polls)) {
$polls = array($polls);
}
// If the post is being edited and
// there is only 1 poll item which is also empty,
// we need to delete existing polls tied to this post.
if (count($polls) == 1 && empty($polls[0]) && !$isNew) {
$post->removePoll();
}
if (count($polls) > 0) {
$hasPolls = false;
foreach ($polls as $poll) {
// As long as there is 1 valid poll, we need to store them.
if (!empty($poll)) {
$hasPolls = true;
break;
}
}
if ($hasPolls) {
// Check if the multiple polls checkbox is it checked?
$multiplePolls = JRequest::getVar('multiplePolls', '0');
// Get the poll question here.
$pollQuestion = JRequest::getVar('poll_question', '');
// Try to detect which poll items needs to be removed.
$removePolls = JRequest::getVar('pollsremove');
// Get the poll items.
$pollItems = JRequest::getVar('pollitems');
$pollItemsOri = JRequest::getVar('pollitemsOri');
// Store the polls now.
$post->bindPolls($isNew, $pollItems, $removePolls, $multiplePolls, $pollQuestion, $pollItemsOri);
}
}
}
// Bind file attachments
if ($acl->allowed('add_attachment') && $config->get('attachment_questions')) {
$post->bindAttachments();
}
// Detect if the current post should be moderated or not.
$isModerate = $post->published == DISCUSS_ID_PENDING ? true : false;
// Process auto posting for posts that are really published and is in a public category.
if ($post->published == DISCUSS_ID_PUBLISHED && $category->canPublicAccess()) {
$post->autopost();
}
// Detect known names in the post.
$names = DiscussHelper::getHelper('String')->detectNames($post->content);
if ($names) {
foreach ($names as $name) {
$name = JString::str_ireplace('@', '', $name);
$id = DiscussHelper::getUserId($name);
if (!$id || $id == $post->get('user_id')) {
continue;
}
$notification = DiscussHelper::getTable('Notifications');
$notification->bind(array('title' => JText::sprintf('COM_EASYDISCUSS_MENTIONED_QUESTION_NOTIFICATION_TITLE', $post->get('title')), 'cid' => $post->get('id'), 'type' => DISCUSS_NOTIFICATIONS_MENTIONED, 'target' => $id, 'author' => $post->get('user_id'), 'permalink' => 'index.php?option=com_easydiscuss&view=post&id=' . $post->get('id')));
$notification->store();
}
}
if (($isNew || $prevPostStatus == DISCUSS_ID_PENDING) && $post->published == DISCUSS_ID_PUBLISHED) {
$post->ping();
}
$notify = DiscussHelper::getNotification();
// badwords filtering for email data.
$post->title = DiscussHelper::wordFilter($post->title);
$post->content = DiscussHelper::wordFilter($post->content);
if ($acl->allowed('add_tag', '0')) {
//@task: Save tags
$postTagModel = $this->getModel('PostsTags');
$tags = JRequest::getVar('tags', '', 'POST');
if (!empty($tags)) {
$tagModel = $this->getModel('Tags');
foreach ($tags as $tag) {
if (!empty($tag)) {
$tagTable = DiscussHelper::getTable('Tags');
//@task: Only add tags if it doesn't exist.
if (!$tagTable->exists($tag)) {
$tagTable->set('title', JString::trim($tag));
$tagTable->set('alias', DiscussHelper::getAlias($tag, 'tag'));
$tagTable->set('created', DiscussHelper::getDate()->toMySQL());
$tagTable->set('published', 1);
$tagTable->set('user_id', $my->id);
$tagTable->store();
} else {
$tagTable->load($tag, true);
}
$postTagInfo = array();
//@task: Store in the post tag
$postTagTable = DiscussHelper::getTable('PostsTags');
$postTagInfo['post_id'] = $post->id;
$postTagInfo['tag_id'] = $tagTable->id;
$postTagTable->bind($postTagInfo);
$postTagTable->store();
}
}
}
}
// prepare email content and information.
$profile = DiscussHelper::getTable('Profile');
$profile->load($my->id);
// For use within the emails.
$emailData = array();
$emailData['postTitle'] = $post->title;
$emailData['postAuthor'] = $profile->id ? $profile->getName() : $post->poster_name;
$emailData['postAuthorAvatar'] = $profile->getAvatar();
$emailData['postLink'] = DiscussRouter::getRoutedURL('index.php?option=com_easydiscuss&view=post&id=' . $post->id, false, true);
$emailContent = $post->content;
if ($post->content_type != 'html') {
// the content is bbcode. we need to parse it.
$emailContent = EasyDiscussParser::bbcode($emailContent);
$emailContent = EasyDiscussParser::removeBrTag($emailContent);
}
// If post is html type we need to strip off html codes.
if ($post->content_type == 'html') {
$emailContent = strip_tags($post->content);
}
$emailContent = $post->trimEmail($emailContent);
$attachments = $post->getAttachments();
$emailData['attachments'] = $attachments;
$emailData['postContent'] = $emailContent;
$emailData['post_id'] = $post->id;
$emailData['cat_id'] = $post->category_id;
$emailData['emailTemplate'] = 'email.subscription.site.new.php';
$emailData['emailSubject'] = JText::sprintf('COM_EASYDISCUSS_NEW_QUESTION_ASKED', $post->id, $post->title);
if ($isModerate) {
// Generate hashkeys to map this current request
$hashkey = DiscussHelper::getTable('HashKeys');
$hashkey->uid = $post->id;
$hashkey->type = DISCUSS_QUESTION_TYPE;
$hashkey->store();
require_once DISCUSS_HELPERS . '/router.php';
$approveURL = DiscussHelper::getExternalLink('index.php?option=com_easydiscuss&controller=posts&task=approvePost&key=' . $hashkey->key);
$rejectURL = DiscussHelper::getExternalLink('index.php?option=com_easydiscuss&controller=posts&task=rejectPost&key=' . $hashkey->key);
$emailData['moderation'] = '<div style="display:inline-block;width:100%;padding:20px;border-top:1px solid #ccc;padding:20px 0 10px;margin-top:20px;line-height:19px;color:#555;font-family:\'Lucida Grande\',Tahoma,Arial;font-size:12px;text-align:left">';
$emailData['moderation'] .= '<a href="' . $approveURL . '" style="display:inline-block;padding:5px 15px;background:#fc0;border:1px solid #caa200;border-bottom-color:#977900;color:#534200;text-shadow:0 1px 0 #ffe684;font-weight:bold;box-shadow:inset 0 1px 0 #ffe064;-moz-box-shadow:inset 0 1px 0 #ffe064;-webkit-box-shadow:inset 0 1px 0 #ffe064;border-radius:2px;moz-border-radius:2px;-webkit-border-radius:2px;text-decoration:none!important">' . JText::_('COM_EASYDISCUSS_EMAIL_APPROVE_POST') . '</a>';
$emailData['moderation'] .= ' ' . JText::_('COM_EASYDISCUSS_OR') . ' <a href="' . $rejectURL . '" style="color:#477fda">' . JText::_('COM_EASYDISCUSS_REJECT') . '</a>';
$emailData['moderation'] .= '</div>';
$emailData['emailTemplate'] = 'email.subscription.site.moderate.php';
$emailData['emailSubject'] = JText::sprintf('COM_EASYDISCUSS_NEW_QUESTION_MODERATE', $post->id, $post->title);
} else {
// If this is a private post, do not notify anyone
if (!$post->private && $category->canPublicAccess()) {
// Notify site subscribers
if ($config->get('main_sitesubscription') && ($isNew || $prevPostStatus == DISCUSS_ID_PENDING) && $post->published == DISCUSS_ID_PUBLISHED && !$config->get('notify_all')) {
DiscussHelper::getHelper('Mailer')->notifySubscribers($emailData, array($my->email));
}
// Notify category subscribers
if ($config->get('main_ed_categorysubscription') && ($isNew || $prevPostStatus == DISCUSS_ID_PENDING) && $post->published == DISCUSS_ID_PUBLISHED && !$config->get('notify_all')) {
DiscussHelper::getHelper('Mailer')->notifySubscribers($emailData, array($my->email));
}
// Notify EVERYBODY
if ($config->get('notify_all') && !$isModerate) {
DiscussHelper::getHelper('Mailer')->notifyAllMembers($emailData, array($my->email));
}
}
}
// Notify admins and category moderators
if ($isNew || $prevPostStatus == DISCUSS_ID_PENDING) {
DiscussHelper::getHelper('Mailer')->notifyAdministrators($emailData, array($my->email), $config->get('notify_admin'), $config->get('notify_moderator'));
}
// @rule: Jomsocial activity integrations & points & ranking
if (($isNew || $prevPostStatus == DISCUSS_ID_PENDING) && $post->published == DISCUSS_ID_PUBLISHED && !$post->private) {
DiscussHelper::getHelper('jomsocial')->addActivityQuestion($post);
DiscussHelper::getHelper('easysocial')->createDiscussionStream($post);
// Add notification to subscribers
DiscussHelper::getHelper('easysocial')->notify('new.discussion', $post);
// Add logging for user.
DiscussHelper::getHelper('History')->log('easydiscuss.new.discussion', $my->id, JText::sprintf('COM_EASYDISCUSS_BADGES_HISTORY_NEW_POST', $post->title), $post->id);
DiscussHelper::getHelper('Badges')->assign('easydiscuss.new.discussion', $my->id);
DiscussHelper::getHelper('Points')->assign('easydiscuss.new.discussion', $my->id);
// Assign badge for EasySocial
DiscussHelper::getHelper('EasySocial')->assignBadge('create.question', $my->id, JText::sprintf('COM_EASYDISCUSS_BADGES_HISTORY_NEW_POST', $post->title));
// assign new ranks.
DiscussHelper::getHelper('ranks')->assignRank($my->id, $config->get('main_ranking_calc_type'));
// aup
DiscussHelper::getHelper('Aup')->assign(DISCUSS_POINTS_NEW_DISCUSSION, $my->id, $post->title);
}
$message = $isNew ? JText::_('COM_EASYDISCUSS_POST_STORED') : JText::_('COM_EASYDISCUSS_EDIT_SUCCESS');
$state = 'success';
// Let's set our custom message here.
if (!$post->isPending()) {
DiscussHelper::setMessageQueue($message, $state);
}
$redirect = JRequest::getVar('redirect', '');
if (!empty($redirect)) {
$redirect = base64_decode($redirect);
return $this->setRedirect($redirect);
}
$redirectionOption = $config->get('main_post_redirection');
switch ($redirectionOption) {
case 'default':
$redirect = DiscussRouter::getPostRoute($post->id, false);
break;
case 'home':
$redirect = DiscussRouter::_('index.php?option=com_easydiscuss&view=index', false);
break;
case 'mainCategory':
$redirect = DiscussRouter::_('index.php?option=com_easydiscuss&view=categories', false);
break;
case 'currentCategory':
$redirect = DiscussRouter::getCategoryRoute($post->category_id, false);
break;
default:
$redirect = DiscussRouter::getPostRoute($post->id, false);
break;
}
$this->setRedirect($redirect);
}