/** * Display all sections * * @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'), '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; } $entries = Section::all()->including(['categories', function ($category) { $category->select('id')->select('section_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']); } // 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('scopes', $forum->scopes())->display(); }
/** * Deletes a section and redirects to main page afterwards * * @return void */ public function deleteTask() { // Is the user logged in? if (User::isGuest()) { App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode(Route::url('index.php?option=' . $this->_option, false, true))), Lang::txt('COM_FORUM_LOGIN_NOTICE'), 'warning'); return; } $this->_authorize('section'); // Load the section $section = Section::all()->whereEquals('alias', Request::getVar('section'))->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->where('state', '!=', Section::STATE_DELETED)->row(); // Make the sure the section exist if (!$section->get('id')) { App::redirect(Route::url('index.php?option=' . $this->_option), Lang::txt('COM_FORUM_MISSING_ID'), 'error'); return; } // Check if user is authorized to delete entries $this->_authorize('section', $section->get('id')); if (!$this->config->get('access-delete-section')) { App::redirect(Route::url('index.php?option=' . $this->_option), Lang::txt('COM_FORUM_NOT_AUTHORIZED'), 'warning'); return; } // Set the section to "deleted" $section->set('state', $section::STATE_DELETED); if (!$section->save()) { Notify::error($section->getError()); } else { Notify::success(Lang::txt('COM_FORUM_SECTION_DELETED')); } // Log activity Event::trigger('system.logActivity', ['activity' => ['action' => 'deleted', 'scope' => 'forum.section', 'scope_id' => $section->get('id'), 'description' => Lang::txt('PLG_GROUPS_FORUM_ACTIVITY_SECTION_DELETED', '<a href="' . Route::url('index.php?option=' . $this->_option) . '">' . $section->get('title') . '</a>'), 'details' => array('title' => $section->get('title'), 'url' => Route::url('index.php?option=' . $this->_option))], 'recipients' => array(['forum.site', 1], ['forum.section', $section->get('id')], ['user', $section->get('created_by')])]); // Redirect to main listing App::redirect(Route::url('index.php?option=' . $this->_option)); }
/** * Displays a question response for editing * * @param object $category * @return void */ public function editTask($category = 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 $section = Section::oneOrNew(Request::getInt('section_id', 0)); if (!is_object($category)) { $id = Request::getVar('id', array(0)); if (is_array($id)) { $id = !empty($id) ? intval($id[0]) : 0; } $category = Category::oneOrNew($id); } if ($category->isNew()) { $category->set('created_by', User::get('id')); $category->set('section_id', $section->get('id')); $category->set('scope', $section->get('scope')); $category->set('scope_id', $section->get('scope_id')); } $data = Section::all()->ordered()->rows(); $sections = array(); foreach ($data as $s) { $ky = $s->scope . ' (' . $s->scope_id . ')'; if ($s->scope == 'site') { $ky = '[ site ]'; } if (!isset($sections[$ky])) { $sections[$ky] = array(); } $sections[$ky][] = $s; asort($sections[$ky]); } User::setState('com_forum.edit.category.data', array('id' => $category->get('id'), 'asset_id' => $category->get('asset_id'))); $m = new AdminCategory(); // Output the HTML $this->view->set('row', $category)->set('section', $section)->set('sections', $sections)->set('form', $m->getForm())->setLayout('edit')->display(); }
/** * Get a list of sections for a forum * * @param array $filters Filters to apply to data fetch * @return object */ public function sections($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 = Section::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']) && $filters['state'] >= 0) { $model->whereEquals('state', (int) $filters['state']); } 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(); }
/** * Remove all items associated with the gorup being deleted * * @param object $course Course being deleted * @return string Log of items removed */ public function onCourseDelete($course) { if (!$course->exists()) { return ''; } $log = Lang::txt('PLG_COURSES_FORUM') . ': '; $sections = array(); foreach ($course->offerings() as $offering) { if (!$offering->exists()) { continue; } $sec = Section::all()->whereEquals('scope', 'course')->whereEquals('scope_id', $offering->get('id'))->rows(); foreach ($sec as $s) { $sections[] = $s; } } // Do we have any IDs? if (count($sections) > 0) { // Loop through each ID foreach ($sections as $section) { // Get the categories in this section $categories = $section->categories()->rows(); if ($categories->count()) { // Build a list of category IDs foreach ($categories as $category) { $log .= 'forum.section.' . $section->get('id') . '.category.' . $category->get('id') . '.post' . "\n"; $log .= 'forum.section.' . $section->get('id') . '.category.' . $category->get('id') . "\n"; } } $log .= 'forum.section.' . $section->get('id') . ' ' . "\n"; // Set the section to "deleted" // Set all the categories to "deleted" // Set all the threads/posts in all the categories to "deleted" $section->set('state', $section::STATE_DELETED); if (!$section->save()) { $this->setError($sModel->getError()); return ''; } } } else { $log .= Lang::txt('PLG_COURSES_DISCUSSIONS_NO_RESULTS') . "\n"; } return $log; }
/** * Display categories for a section * * @apiMethod GET * @apiUri /forum/categories * @apiParameter { * "name": "limit", * "description": "Number of result to return.", * "type": "integer", * "required": false, * "default": 25 * } * @apiParameter { * "name": "limitstart", * "description": "Number of where to start returning results.", * "type": "integer", * "required": false, * "default": 0 * } * @apiParameter { * "name": "section", * "description": "Section ID", * "type": "integer", * "required": true, * "default": 0 * } * @apiParameter { * "name": "search", * "description": "A word or phrase to search for.", * "type": "string", * "required": false, * "default": "" * } * @apiParameter { * "name": "scope", * "description": "Scope (site, groups, members, etc.)", * "type": "string", * "required": false, * "default": "site" * } * @apiParameter { * "name": "scope_id", * "description": "Scope ID", * "type": "integer", * "required": false, * "default": 0 * } * @apiParameter { * "name": "closed", * "description": "If the category is marked as closed (1) or not (0). NULL to return all.", * "type": "integer", * "required": false, * "default": null * } * @return void */ public function categoriesTask() { $filters = array('limit' => Request::getInt('limit', 25), 'start' => Request::getInt('limitstart', 0), 'section_id' => Request::getInt('section', 0), 'search' => Request::getVar('search', ''), 'scope' => Request::getWord('scope', 'site'), 'scope_id' => Request::getInt('scope_id', 0), 'state' => Category::STATE_PUBLISHED, 'closed' => Request::getVar('closed', null), 'access' => User::getAuthorisedViewLevels()); if ($filters['scope'] == 'group') { $group = \Hubzero\User\Group::getInstance($filters['scope_id']); if ($group && in_array(User::get('id'), $group->get('members'))) { $filters['access'][] = 5; // Private } } $forum = new Manager($filters['scope'], $filters['scope_id']); $response = new stdClass(); $response->categories = array(); if ($filters['section_id']) { // Make sure the section exists and is available $section = Section::oneOrFail($filters['section_id']); if (!$section->get('id')) { throw new Exception(Lang::txt('COM_FORUM_ERROR_SECTION_NOT_FOUND'), 404); } if ($section->get('state') == Section::STATE_DELETED) { throw new Exception(Lang::txt('COM_FORUM_ERROR_SECTION_NOT_FOUND'), 404); } $response->section = new stdClass(); $response->section->id = $section->get('id'); $response->section->title = $section->get('title'); $response->section->alias = $section->get('alias'); $response->section->created = with(new Date($section->get('created')))->format('Y-m-d\\TH:i:s\\Z'); $response->section->scope = $section->get('scope'); $response->section->scope_id = $section->get('scope_id'); } else { $sections = Section::all()->whereEquals('scope', $filters['scope'])->whereEquals('scope_id', $filters['scope_id'])->whereEquals('state', $filters['state'])->whereIn('access', $filters['access'])->rows(); $filters['section_id'] = array(); foreach ($sections as $section) { $filters['section_id'][] = $section->get('id'); } } $entries = Category::all()->whereIn('section_id', (array) $filters['section_id'])->whereEquals('state', $filters['state'])->whereIn('access', $filters['access']); if (is_int($filters['closed'])) { $entries->whereEquals('closed', $filters['closed']); } if ($filters['search']) { $entries->whereLike('description', $filters['search'], 1)->orWhereLike('title', $filters['search'], 1)->resetDepth(); } $categories = $entries->ordered()->paginated()->rows(); $response->total = $categories->count(); if ($response->total) { $base = rtrim(Request::base(), '/'); foreach ($categories as $category) { $obj = new stdClass(); $obj->id = (int) $category->get('id'); $obj->title = $category->get('title'); $obj->alias = $category->get('alias'); $obj->description = $category->get('description'); $obj->created = with(new Date($category->get('created')))->format('Y-m-d\\TH:i:s\\Z'); $obj->closed = (int) $category->get('closed'); $obj->scope = $category->get('scope'); $obj->scope_id = (int) $category->get('scope_id'); $obj->section_id = (int) $category->get('section_id'); $obj->threads = $category->threads()->whereEquals('state', $filters['state'])->whereIn('access', $filters['access'])->total(); $obj->posts = $category->posts()->whereEquals('state', $filters['state'])->whereIn('access', $filters['access'])->total(); $obj->url = str_replace('/api', '', $base . '/' . ltrim(Route::url($category->link()), '/')); $response->categories[] = $obj; } } $response->success = true; $this->send($response); }
/** * Show a form for editing an entry * * @param object $category * @return void */ public function editTask($category = null) { if (User::isGuest()) { $return = Route::url('index.php?option=' . $this->_option, false, true); App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return))); } // Get the section $section = Section::all()->whereEquals('alias', Request::getVar('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')); } // Incoming if (!is_object($category)) { $category = Category::all()->whereEquals('alias', Request::getVar('category', ''))->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->whereEquals('section_id', $section->get('id'))->where('state', '!=', Category::STATE_DELETED)->row(); } $this->_authorize('category', $category->get('id')); if ($category->isNew()) { $category->set('created_by', User::get('id')); $category->set('section_id', $section->get('id')); } elseif ($category->get('created_by') != User::get('id') && !$this->config->get('access-create-category')) { App::redirect(Route::url('index.php?option=' . $this->_option)); } // Output the view $this->view->set('config', $this->config)->set('forum', $this->forum)->set('category', $category)->set('section', $section)->setLayout('edit')->display(); }
/** * Reorder a section * * @param integer $dir Direction * @return void */ public function reorder($dir = 1) { if (User::isGuest()) { $this->setError(Lang::txt('GROUPS_LOGIN_NOTICE')); return; } if ($this->authorized != 'manager' && $this->authorized != 'admin') { $this->setError(Lang::txt('PLG_GROUPS_FORUM_NOT_AUTHORIZED')); return $this->sections(); } // Get the section $section = Section::all()->whereEquals('alias', Request::getVar('section', ''))->whereEquals('scope', $this->forum->get('scope'))->whereEquals('scope_id', $this->forum->get('scope_id'))->row(); // Move the section if (!$section->move($dir)) { Notify::error($section->getError()); } else { // Record the activity $recipients = array(['group', $this->group->get('gidNumber')], ['forum.' . $this->forum->get('scope'), $this->forum->get('scope_id')], ['forum.section', $section->get('id')]); foreach ($this->group->get('managers') as $recipient) { $recipients[] = ['user', $recipient]; } Event::trigger('system.logActivity', ['activity' => ['action' => 'reordered', 'scope' => 'forum.section', 'scope_id' => $section->get('id'), 'description' => Lang::txt('PLG_GROUPS_FORUM_ACTIVITY_SECTION_REORDERED', '<a href="' . Route::url($this->base) . '">' . $section->get('title') . '</a>'), 'details' => array('title' => $section->get('title'), 'url' => Route::url($this->base))], 'recipients' => $recipients]); } // Redirect to main lsiting App::redirect(Route::url($this->base)); }