/**
* Display all categories in a section
*
* @return void
*/
public function displayTask()
{
// Filters
$filters = array('state' => Request::getState($this->_option . '.' . $this->_controller . '.state', 'state', -1, 'int'), 'access' => Request::getState($this->_option . '.' . $this->_controller . '.access', 'access', -1, 'int'), 'section_id' => Request::getState($this->_option . '.' . $this->_controller . '.section_id', 'section_id', -1, 'int'), 'sort' => Request::getState($this->_option . '.' . $this->_controller . '.sort', 'filter_order', 'id'), 'sort_Dir' => Request::getState($this->_option . '.' . $this->_controller . '.sortdir', 'filter_order_Dir', 'DESC'), 'search' => Request::getState($this->_option . '.' . $this->_controller . '.search', 'search', ''), 'scopeinfo' => Request::getState($this->_option . '.' . $this->_controller . '.scopeinfo', 'scopeinfo', ''));
if (strstr($filters['scopeinfo'], ':')) {
$bits = explode(':', $filters['scopeinfo']);
$filters['scope'] = $bits[0];
$filters['scope_id'] = intval(end($bits));
} else {
$filters['scope'] = '';
$filters['scope_id'] = -1;
}
$filters['admin'] = true;
// Load the current section
if (!$filters['section_id'] || $filters['section_id'] <= 0) {
// No section? Load a default blank section
$section = Section::blank();
} else {
$section = Section::oneOrFail($filters['section_id']);
$filters['scope'] = $section->get('scope');
$filters['scope_id'] = $section->get('scope_id');
$filters['scopeinfo'] = $filters['scope'] . ':' . $filters['scope_id'];
}
$sections = array();
if ($filters['scope_id'] >= 0) {
$sections = Section::all()->whereEquals('scope', $filters['scope'])->whereEquals('scope_id', $filters['scope_id'])->ordered('title', 'ASC')->rows();
}
$entries = Category::all()->including(['posts', function ($post) {
$post->select('id')->select('category_id');
}]);
if ($filters['search']) {
$entries->whereLike('title', strtolower((string) $filters['search']));
}
if ($filters['scope']) {
$entries->whereEquals('scope', $filters['scope']);
}
if ($filters['scope_id'] >= 0) {
$entries->whereEquals('scope_id', (int) $filters['scope_id']);
}
if ($filters['state'] >= 0) {
$entries->whereEquals('state', (int) $filters['state']);
}
if ($filters['access'] >= 0) {
$entries->whereEquals('access', (int) $filters['access']);
}
if ($filters['section_id'] > 0) {
$entries->whereEquals('section_id', (int) $filters['section_id']);
}
// Get records
$rows = $entries->ordered('filter_order', 'filter_order_Dir')->paginated('limitstart', 'limit')->rows();
$forum = new Manager($filters['scope'], $filters['scope_id']);
// Output the HTML
$this->view->set('rows', $rows)->set('filters', $filters)->set('section', $section)->set('sections', $sections)->set('scopes', $forum->scopes())->display();
}
/**
* Get categories for this forum
*
* @param array $filters Filters to apply to the query
* @return object
*/
public function categories($filters = array())
{
if (!isset($filters['scope'])) {
$filters['scope'] = (string) $this->get('scope');
}
if (!isset($filters['scope_id'])) {
$filters['scope_id'] = (int) $this->get('scope_id');
}
$model = Category::all();
if ($filters['scope']) {
$model->whereEquals('scope', $filters['scope']);
}
if ($filters['scope_id'] >= 0) {
$model->whereEquals('scope_id', $filters['scope_id']);
}
if (isset($filters['state'])) {
$model->whereEquals('state', $filters['state']);
}
if (isset($filters['access'])) {
if (!is_array($filters['access'])) {
$filters['access'] = array($filters['access']);
}
$model->whereIn('access', $filters['access']);
}
return $model;
}
/**
* Displays a question response for editing
*
* @param mixed $post
* @return void
*/
public function editTask($post = null)
{
Request::setVar('hidemainmenu', 1);
if (!User::authorise('core.edit', $this->_option) && !User::authorise('core.create', $this->_option)) {
App::abort(403, Lang::txt('JERROR_ALERTNOAUTHOR'));
}
// Incoming
$parent = Request::getInt('parent', 0);
if (!is_object($post)) {
$id = Request::getVar('id', array(0));
if (is_array($id)) {
$id = intval($id[0]);
}
$post = Post::oneOrNew($id);
}
if ($post->isNew()) {
$post->set('parent', $parent);
$post->set('created_by', User::get('id'));
}
if ($post->get('parent')) {
$threads = Post::all()->whereEquals('category_id', $post->get('category_id'))->whereEquals('parent', 0)->ordered()->rows();
}
// Get the category
$category = Category::oneOrNew($post->get('category_id'));
$categories = array();
foreach (Category::all()->rows() as $c) {
if (!isset($categories[$c->section_id])) {
$categories[$c->section_id] = array();
}
$categories[$c->section_id][] = $c;
asort($categories[$c->section_id]);
}
// Get the section
$section = Section::oneOrNew($category->get('section_id'));
// Get the sections for this group
$sections = array();
foreach (Section::all()->rows() as $s) {
$ky = $s->scope . ' (' . $s->scope_id . ')';
if ($s->scope == 'site') {
$ky = '[ site ]';
}
if (!isset($sections[$ky])) {
$sections[$ky] = array();
}
$s->categories = isset($categories[$s->id]) ? $categories[$s->id] : array();
$sections[$ky][] = $s;
asort($sections[$ky]);
}
User::setState('com_forum.edit.thread.data', array('id' => $post->get('id'), 'asset_id' => $post->get('asset_id')));
$m = new AdminThread();
$form = $m->getForm();
// Get tags on this article
$this->view->set('row', $post)->set('sections', $sections)->set('categories', $categories)->set('form', $form)->setLayout('edit')->display();
}
/**
* Show a form for editing an entry
*
* @param mixed $post
* @return void
*/
public function editTask($post = null)
{
$id = Request::getInt('thread', 0);
$category = Request::getCmd('category', '');
$section = Request::getCmd('section', '');
if (User::isGuest()) {
$return = Route::url('index.php?option=' . $this->_option . '§ion=' . $section . '&category=' . $category . '&task=new');
if ($id) {
$return = Route::url('index.php?option=' . $this->_option . '§ion=' . $section . '&category=' . $category . '&thread=' . $id . '&task=edit');
}
App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return)) . Lang::txt('COM_FORUM_LOGIN_NOTICE'), 'warning');
}
// Section
$section = Section::all()->whereEquals('alias', $section)->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->where('state', '!=', Section::STATE_DELETED)->row();
if (!$section->get('id')) {
App::abort(404, Lang::txt('COM_FORUM_SECTION_NOT_FOUND'));
}
// Get the category
$category = Category::all()->whereEquals('alias', $category)->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->where('state', '!=', Category::STATE_DELETED)->row();
if (!$category->get('id')) {
App::abort(404, Lang::txt('COM_FORUM_CATEGORY_NOT_FOUND'));
}
// Incoming
if (!is_object($post)) {
$post = Post::oneOrNew($id);
}
$this->_authorize('thread', $id);
if ($post->isNew()) {
$post->set('scope', $this->forum->get('scope'));
$post->set('created_by', User::get('id'));
} elseif ($post->get('created_by') != User::get('id') && !$this->config->get('access-edit-thread')) {
App::redirect(Route::url('index.php?option=' . $this->_option . '§ion=' . $section . '&category=' . $category), Lang::txt('COM_FORUM_NOT_AUTHORIZED'), 'warning');
}
// Set the page title
$this->buildTitle($section, $category, $post);
// Set the pathway
$this->buildPathway($section, $category, $post);
$this->view->set('config', $this->config)->set('forum', $this->forum)->set('section', $section)->set('category', $category)->set('post', $post)->setErrors($this->getErrors())->setLayout('edit')->display();
}
/**
* Show a form for editing a post
*
* @param object $post
* @return string
*/
public function editthread($post = null)
{
$id = Request::getInt('post', 0);
$category = Request::getVar('category', '');
$section = Request::getVar('section', '');
if (User::isGuest()) {
$return = Route::url($this->offering->link() . '&active=' . $this->_name . '&unit=' . $section . '&b=' . $category . '&c=new');
if ($id) {
$return = Route::url($this->offering->link() . '&active=' . $this->_name . '&unit=' . $section . '&b=' . $category . '&c=' . $id . '/edit');
}
App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return)));
return;
}
// Get the category
$category = Category::all()->whereEquals('alias', $category)->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->row();
if (!$category->get('id')) {
App::abort(404, Lang::txt('PLG_GROUPS_FORUM_ERROR_CATEGORY_NOT_FOUND'));
}
// Incoming
if (!is_object($post)) {
$post = Post::oneOrNew($id);
}
// Get authorization
$this->_authorize('thread', $id);
if ($post->isNew()) {
$post->set('scope', $this->forum->get('scope'));
$post->set('created_by', User::get('id'));
} elseif ($post->get('created_by') != User::get('id') && !$this->params->get('access-edit-thread')) {
App::redirect(Route::url($this->base . '&unit=manage&b=' . $section . '&c=' . $category));
}
return $this->view('edit', 'threads')->set('option', $this->option)->set('course', $this->course)->set('offering', $this->offering)->set('config', $this->params)->set('forum', $this->forum)->set('section', $section)->set('category', $category)->set('post', $post)->set('name', $this->_name)->setErrors($this->getErrors())->loadTemplate();
}
/**
* Create a thread or post in a thread
*
* @apiMethod POST
* @apiUri /forum
* @apiParameter {
* "name": "category_id",
* "description": "Category ID",
* "type": "integer",
* "required": true,
* "default": 0
* }
* @apiParameter {
* "name": "scope",
* "description": "Scope type (site, group, etc.)",
* "type": "string",
* "required": true,
* "default": "site"
* }
* @apiParameter {
* "name": "scope_id",
* "description": "Scope object ID",
* "type": "integer",
* "required": true,
* "default": "0"
* }
* @apiParameter {
* "name": "title",
* "description": "Entry title",
* "type": "string",
* "required": false,
* "default": null
* }
* @apiParameter {
* "name": "comment",
* "description": "Entry content",
* "type": "string",
* "required": true,
* "default": null
* }
* @apiParameter {
* "name": "created",
* "description": "Created timestamp (YYYY-MM-DD HH:mm:ss)",
* "type": "string",
* "required": false,
* "default": "now"
* }
* @apiParameter {
* "name": "created_by",
* "description": "User ID of entry creator",
* "type": "integer",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "state",
* "description": "Published state (0 = unpublished, 1 = published)",
* "type": "integer",
* "required": false,
* "default": 1
* }
* @apiParameter {
* "name": "access",
* "description": "Access level (1 = public, 2 = registered users, 5 = private)",
* "type": "integer",
* "required": false,
* "default": 1
* }
* @apiParameter {
* "name": "anonymous",
* "description": "Commentor is anonymous?",
* "type": "integer",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "parent",
* "description": "ID of the parent post this post is in reply to.",
* "type": "integer",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "thread",
* "description": "ID of the forum thread the post belongs to. 0 if new thread.",
* "type": "string",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "sticky",
* "description": "If the thread is sticky or not. Only applies to thread starter posts.",
* "type": "integer",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "closed",
* "description": "If the thread is closed (no more new posts) or not. Only applies to thread starter posts.",
* "type": "integer",
* "required": false,
* "default": 0
* }
* @apiParameter {
* "name": "tags",
* "description": "Comma-separated list of tags",
* "type": "string",
* "required": false,
* "default": null
* }
* @return void
*/
public function createTask()
{
$this->requiresAuthentication();
$fields = array('category_id' => Request::getInt('category_id', 0, 'post'), 'title' => Request::getVar('title', null, 'post', 'none', 2), 'comment' => Request::getVar('comment', null, 'post', 'none', 2), 'created' => Request::getVar('created', new Date('now'), 'post'), 'created_by' => Request::getInt('created_by', 0, 'post'), 'state' => Request::getInt('state', Post::STATE_PUBLISHED, 'post'), 'sticky' => Request::getInt('sticky', 0, 'post'), 'parent' => Request::getInt('parent', 0, 'post'), 'scope' => Request::getVar('scope', 'site', 'post'), 'scope_id' => Request::getInt('scope_id', 0, 'post'), 'access' => Request::getInt('access', Post::ACCESS_PUBLIC, 'post'), 'anonymous' => Request::getInt('anonymous', 0, 'post'), 'thread' => Request::getInt('thread', 0, 'post'), 'closed' => Request::getInt('closed', 0, 'post'), 'hits' => Request::getInt('hits', 0, 'post'));
if (!$fields['category_id']) {
throw new Exception(Lang::txt('COM_FORUM_ERROR_CATEGORY_ID_MISSING'), 400);
}
$row = Post::blank();
if (!$row->set($fields)) {
throw new Exception(Lang::txt('COM_FORUM_ERROR_BINDING_DATA'), 500);
}
$row->set('anonymous', $fields['anonymous'] ? 1 : 0);
$category = Category::all()->whereEquals('id', $row->get('category_id'))->whereEquals('scope', $row->get('scope'))->whereEquals('scope_id', $row->get('scope_id'))->where('state', '!=', Category::STATE_DELETED)->row();
if (!$category->get('id')) {
throw new Exception(Lang::txt('COM_FORUM_ERROR_CATEGORY_NOT_FOUND'), 400);
}
if (!$row->save()) {
throw new Exception(Lang::txt('COM_FORUM_ERROR_SAVING_DATA'), 500);
}
if ($fields['created_by']) {
$row->set('created_by', (int) $fields['created_by']);
$row->save();
}
if ($tags = Request::getVar('tags', null, 'post')) {
if (!$row->tag($tags, User::get('id'))) {
throw new Exception(Lang::txt('COM_FORUM_ERROR_SAVING_TAGS'), 500);
}
}
// Record the activity
$base = rtrim(Request::base(), '/');
$url = str_replace('/api', '', $base . '/' . ltrim(Route::url($row->link()), '/'));
$recipients = array(['forum.site', 1], ['forum.section', $category->get('section_id')], ['user', $row->get('created_by')]);
$type = 'thread';
$desc = Lang::txt('COM_FORUM_ACTIVITY_' . strtoupper($type) . '_CREATED', '<a href="' . $url . '">' . $row->get('title') . '</a>');
// If this is a post in a thread and not the thread starter...
if ($row->get('parent')) {
$thread = Post::oneOrFail($row->get('thread'));
$thread->set('last_activity', $fields['id'] ? $row->get('modified') : $row->get('created'));
$thread->save();
$type = 'post';
$desc = Lang::txt('COM_FORUM_ACTIVITY_' . strtoupper($type) . '_CREATED', $row->get('id'), '<a href="' . $url . '">' . $thread->get('title') . '</a>');
// If the parent post is not the same as the
// thread starter (i.e., this is a reply)
if ($row->get('parent') != $row->get('thread')) {
$parent = Post::oneOrFail($row->get('parent'));
$recipients[] = ['user', $parent->get('created_by')];
}
}
Event::trigger('system.logActivity', ['activity' => ['action' => 'created', 'scope' => 'forum.' . $type, 'scope_id' => $row->get('id'), 'anonymous' => $row->get('anonymous', 0), 'description' => $desc, 'details' => array('thread' => $row->get('thread'), 'url' => $url)], 'recipients' => $recipients]);
$obj = $row->toObject();
$obj->creator = new stdClass();
$obj->creator->id = 0;
$obj->creator->name = Lang::txt('COM_FORUM_ANONYMOUS');
if (!$row->get('anonymous')) {
$obj->creator->id = $row->get('created_by');
$obj->creator->name = $row->creator->get('name');
}
$this->send($obj);
}
/**
* Delete a category
*
* @return void
*/
public function deleteTask()
{
$url = 'index.php?option=' . $this->_option;
// Is the user logged in?
if (User::isGuest()) {
App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode(Route::url($url, false, true))), Lang::txt('COM_FORUM_LOGIN_NOTICE'), 'warning');
}
// Load the category
$category = Category::all()->whereEquals('alias', Request::getVar('category', ''))->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->where('state', '!=', Category::STATE_DELETED)->row();
// Make the sure the category exist
if (!$category->get('id')) {
App::redirect(Route::url($url), Lang::txt('COM_FORUM_MISSING_ID'), 'error');
}
// Check if user is authorized to delete entries
$this->_authorize('category', $category->get('id'));
if (!$this->config->get('access-delete-category')) {
App::redirect(Route::url($url), Lang::txt('COM_FORUM_NOT_AUTHORIZED'), 'warning');
}
// Set the category to "deleted"
$category->set('state', $category::STATE_DELETED);
if (!$category->save()) {
App::redirect(Route::url($url), $category->getError(), 'error');
}
// Log activity
Event::trigger('system.logActivity', ['activity' => ['action' => 'deleted', 'scope' => 'forum.category', 'scope_id' => $category->get('id'), 'description' => Lang::txt('COM_FORUM_ACTIVITY_CATEGORY_DELETED', '<a href="' . Route::url($url) . '">' . $category->get('title') . '</a>'), 'details' => array('title' => $category->get('title'), 'url' => Route::url($url))], 'recipients' => array(['forum.site', 1], ['forum.section', $category->get('section_id')], ['user', $category->get('created_by')])]);
// Redirect to main listing
App::redirect(Route::url($url), Lang::txt('COM_FORUM_CATEGORY_DELETED'), 'message');
}
/**
* Show a form for editing a post
*
* @param object $post
* @return string
*/
public function editthread($post = null)
{
$id = Request::getInt('thread', 0);
$category = Request::getVar('category', '');
$section = Request::getVar('section', '');
// Login check is handled in the onGroup() method
/*if (User::isGuest())
{
$return = Route::url($this->base . '&scope=' . $sectionAlias . '/' . $category . '/new', false, true);
if ($id)
{
$return = Route::url($this->base . '&scope=' . $sectionAlias . '/' . $category . '/' . $id . '/edit', false, true);
}
App::redirect(
Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return))
);
return;
}*/
// Section
$section = Section::all()->whereEquals('alias', $section)->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->row();
if (!$section->get('id')) {
App::abort(404, Lang::txt('PLG_GROUPS_FORUM_ERROR_SECTION_NOT_FOUND'));
}
// Get the category
$category = Category::all()->whereEquals('alias', $category)->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->row();
if (!$category->get('id')) {
App::abort(404, Lang::txt('PLG_GROUPS_FORUM_ERROR_CATEGORY_NOT_FOUND'));
}
// Incoming
if (!is_object($post)) {
$post = Post::oneOrNew($id);
}
// Get authorization
$this->_authorize('thread', $id);
if ($post->isNew()) {
$post->set('scope', $this->forum->get('scope'));
$post->set('created_by', User::get('id'));
} elseif ($post->get('created_by') != User::get('id') && !$this->params->get('access-edit-thread')) {
App::redirect(Route::url($this->base . '&scope=' . $section . '/' . $category));
}
return $this->view('edit', 'threads')->set('option', $this->option)->set('group', $this->group)->set('config', $this->params)->set('forum', $this->forum)->set('section', $section)->set('category', $category)->set('post', $post)->setErrors($this->getErrors())->loadTemplate();
}
