/**
* Build module contents
*
* @return void
*/
public function run()
{
include_once \Component::path('com_blog') . DS . 'models' . DS . 'entry.php';
$this->row = null;
$filters = array('state' => 1, 'access' => 1, 'sort' => "RAND()", 'sort_Dir' => '', 'search' => '', 'scope' => 'member', 'scope_id' => 0, 'authorized' => false);
$row = Entry::all()->whereEquals('scope', $filters['scope'])->whereEquals('state', $filters['state'])->whereEquals('access', $filters['access'])->row();
// Did we have a result to display?
if ($row->get('id')) {
$this->row = $row;
$this->cls = trim($this->params->get('moduleclass_sfx'));
$this->txt_length = trim($this->params->get('txt_length'));
require $this->getLayoutPath();
}
}
/**
* Display a list of blog entries
*
* @return void
*/
public function displayTask()
{
$filters = array('scope' => Request::getState($this->_option . '.' . $this->_controller . '.scope', 'scope', ''), 'scope_id' => Request::getState($this->_option . '.' . $this->_controller . '.scope_id', 'scope_id', 0, 'int'), 'search' => urldecode(Request::getState($this->_option . '.' . $this->_controller . '.search', 'search', '')), 'state' => Request::getState($this->_option . '.' . $this->_controller . '.state', 'state', -1, 'int'), 'access' => Request::getState($this->_option . '.' . $this->_controller . '.access', 'access', 0, 'int'), 'sort' => Request::getState($this->_option . '.' . $this->_controller . '.sort', 'filter_order', 'title'), 'sort_Dir' => Request::getState($this->_option . '.' . $this->_controller . '.sortdir', 'filter_order_Dir', 'ASC'));
$entries = Entry::all();
if ($filters['search']) {
$entries->whereLike('title', strtolower((string) $filters['search']));
}
if ($filters['scope']) {
$entries->whereEquals('scope', $filters['scope']);
}
if ($filters['scope_id']) {
$entries->whereEquals('scope_id', (int) $filters['scope_id']);
}
if ($filters['state'] >= 0) {
$entries->whereEquals('state', (int) $filters['state']);
}
if ($filters['access']) {
$entries->whereEquals('access', (int) $filters['access']);
}
// Get records
$rows = $entries->order($filters['sort'], $filters['sort_Dir'])->paginated('limitstart', 'limit')->rows();
// Output the HTML
$this->view->set('rows', $rows)->set('filters', $filters)->display();
}
/**
* Return a count of items that will be removed when group is deleted
*
* @param object $group Group to delete
* @return string
*/
public function onGroupDeleteCount($group)
{
include_once PATH_CORE . DS . 'components' . DS . 'com_blog' . DS . 'models' . DS . 'archive.php';
$entries = \Components\Blog\Models\Entry::all()->whereEquals('scope', 'group')->whereEquals('scope_id', $group->get('gidNumber'))->count();
return Lang::txt('PLG_GROUPS_BLOG_LOG') . ': ' . $entries;
}
/**
* Get a count of, model for, or list of entries
*
* @param array $filters Filters to apply to data retrieval
* @return object
*/
public function entries($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');
}
$results = Entry::all()->including(['creator', function ($creator) {
$creator->select('*');
}])->including(['comments', function ($comment) {
$comment->select('id')->select('entry_id')->whereIn('state', array(Comment::STATE_PUBLISHED, Comment::STATE_FLAGGED));
}]);
if ($filters['scope']) {
$results->whereEquals('scope', $filters['scope'])->whereEquals('scope_id', $filters['scope_id']);
}
if (isset($filters['state'])) {
$results->whereEquals('state', $filters['state']);
}
if (isset($filters['access'])) {
$results->whereIn('access', $filters['access']);
}
if (isset($filters['year']) && $filters['year'] != 0) {
if (isset($filters['month']) && $filters['month'] != 0) {
$startdate = $filters['year'] . '-' . $filters['month'] . '-01 00:00:00';
if ($filters['month'] + 1 == 13) {
$year = $filters['year'] + 1;
$month = 1;
} else {
$month = $filters['month'] + 1;
$year = $filters['year'];
}
$enddate = sprintf("%4d-%02d-%02d 00:00:00", $year, $month, 1);
} else {
$startdate = $filters['year'] . '-01-01 00:00:00';
$enddate = $filters['year'] + 1 . '-01-01 00:00:00';
}
$results->where('publish_up', '>=', $startdate)->where('publish_up', '<', $enddate);
} else {
$results->whereEquals('publish_up', '0000-00-00 00:00:00', 1)->orWhere('publish_up', '<=', Date::toSql(), 1);
}
$results->resetDepth();
if (!isset($filters['authorized']) || !$filters['authorized']) {
$results->whereEquals('publish_down', '0000-00-00 00:00:00', 1)->orWhere('publish_down', '>=', Date::toSql(), 1);
}
if (isset($filters['search']) && $filters['search']) {
$filters['search'] = '%' . strtolower(stripslashes($filters['search'])) . '%';
$results->where('title', 'LIKE', $filters['search'])->orWhere('content', 'LIKE', $filters['search']);
}
if (isset($filters['limit']) && $filters['limit']) {
$results->limit($filters['limit']);
}
return $results;
}
/**
* Get a count of, model for, or list of entries
*
* @param string $rtrn Data to return
* @param array $filters Filters to apply to data retrieval
* @param boolean $reset Clear cached data?
* @return mixed
*/
public function entries($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');
}
$results = Entry::all();
if ($filters['scope']) {
$results->whereEquals('scope', $filters['scope'])->whereEquals('scope_id', $filters['scope_id']);
}
if (isset($filters['state'])) {
$results->whereEquals('state', $filters['state']);
}
if (isset($filters['access'])) {
$results->whereIn('access', $filters['access']);
}
if (isset($filters['year']) && $filters['year'] != 0) {
if (isset($filters['month']) && $filters['month'] != 0) {
$startdate = $filters['year'] . '-' . $filters['month'] . '-01 00:00:00';
if ($filters['month'] + 1 == 13) {
$year = $filters['year'] + 1;
$month = 1;
} else {
$month = $filters['month'] + 1;
$year = $filters['year'];
}
$enddate = sprintf("%4d-%02d-%02d 00:00:00", $year, $month, 1);
} else {
$startdate = $filters['year'] . '-01-01 00:00:00';
$enddate = $filters['year'] + 1 . '-01-01 00:00:00';
}
$results->where('publish_up', '>=', $startdate)->where('publish_up', '<', $enddate);
} else {
$results->whereEquals('publish_up', '0000-00-00 00:00:00', 1)->orWhere('publish_up', '<=', Date::toSql(), 1);
}
$results->resetDepth();
$results->whereEquals('publish_down', '0000-00-00 00:00:00', 1)->orWhere('publish_down', '>=', Date::toSql(), 1);
if (isset($filters['search']) && $filters['search']) {
$filters['search'] = '%' . strtolower(stripslashes($filters['search'])) . '%';
$results->where('title', 'LIKE', $filters['search'])->orWhere('content', 'LIKE', $filters['search']);
}
return $results;
}
/**
* Get a count of all blog entries
*
* @param string $gid Group alias
* @return integer
*/
public static function getGroupBlogCount($gid)
{
if (!$gid) {
return 0;
}
include_once PATH_CORE . DS . 'components' . DS . 'com_blog' . DS . 'models' . DS . 'entry.php';
$total = \Components\Blog\Models\Entry::all()->whereEquals('scope', 'group')->whereEquals('scope_id', $gid)->where('state', '!=', \Components\Blog\Models\Entry::STATE_DELETED)->total();
return $total;
}
/**
* Get module contents
*
* @return void
*/
public function run()
{
include_once Component::path('com_resources') . DS . 'tables' . DS . 'resource.php';
include_once Component::path('com_members') . DS . 'models' . DS . 'member.php';
include_once Component::path('com_answers') . DS . 'models' . DS . 'question.php';
include_once Component::path('com_blog') . DS . 'models' . DS . 'archive.php';
$this->database = \App::get('db');
// Get the admin configured settings
$filters = array();
$filters['limit'] = 5;
$filters['start'] = 0;
// featured items
$tbls = array('resources', 'profiles');
$spots = array();
$spots[0] = trim($this->params->get('spotone'));
$spots[1] = trim($this->params->get('spottwo'));
$spots[2] = trim($this->params->get('spotthree'));
$spots[3] = trim($this->params->get('spotfour'));
$spots[4] = trim($this->params->get('spotfive'));
$spots[5] = trim($this->params->get('spotsix'));
$spots[6] = trim($this->params->get('spotseven'));
$numspots = $this->params->get('numspots', 3);
// some collectors
$activespots = array();
$rows = array();
// styling
$cls = trim($this->params->get('moduleclass_sfx'));
$txtLength = trim($this->params->get('txt_length'));
$start = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y'))) . ' 00:00:00';
$end = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y'))) . ' 23:59:59';
$this->html = '';
$k = 1;
$out = '';
for ($i = 0, $n = $numspots; $i < $numspots; $i++) {
$spot = $spots[$i];
if ($spot == '') {
continue;
}
$row = null;
$out = '';
$tbl = '';
$tbl = $spot == 'tools' || $spot == 'nontools' ? 'resources' : '';
$tbl = $spot == 'members' ? 'profiles' : $tbl;
$tbl = $spot == 'topics' ? 'topics' : $tbl;
$tbl = $spot == 'itunes' ? 'itunes' : $tbl;
$tbl = $spot == 'answers' ? 'answers' : $tbl;
$tbl = $spot == 'blog' ? 'blog' : $tbl;
$tbl = !$tbl ? array_rand($tbls, 1) : $tbl;
// we need to randomly choose one
switch ($tbl) {
case 'resources':
// Initiate a resource object
$rr = new \Components\Resources\Tables\Resource($this->database);
$filters['start'] = 0;
$filters['type'] = $spot;
$filters['sortby'] = 'random';
$filters['minranking'] = trim($this->params->get('minranking'));
$filters['tag'] = $spot == 'tools' ? trim($this->params->get('tag')) : '';
// tag is set for tools only
// Get records
$rows[$spot] = isset($rows[$spot]) ? $rows[$spot] : $rr->getRecords($filters, false);
break;
case 'profiles':
// Get records
if (!isset($rows[$spot])) {
$last = \Components\Members\Models\Member::all()->select('id')->whereEquals('block', 0)->whereEquals('activation', 1)->where('approved', '>', 0)->order('id', 'desc')->row();
$r = mt_rand(0, $last->get('id'));
$rows[$spot] = \Components\Members\Models\Member::all()->whereEquals('block', 0)->whereEquals('activation', 1)->where('approved', '>', 0)->where('id', '>=', $r)->row();
}
break;
case 'topics':
// No - so we need to randomly choose one
$topics_tag = trim($this->params->get('topics_tag'));
$query = "SELECT DISTINCT w.id, w.pagename, w.title ";
$query .= " FROM #__wiki_page AS w ";
if ($topics_tag) {
$query .= " JOIN #__tags_object AS RTA ON RTA.objectid=w.id AND RTA.tbl='wiki' ";
$query .= " INNER JOIN #__tags AS TA ON TA.id=RTA.tagid ";
} else {
$query .= ", #__wiki_version AS v ";
}
$query .= " WHERE w.access!=1 AND w.scope = '' ";
if ($topics_tag) {
$query .= " AND (TA.tag='" . $topics_tag . "' OR TA.raw_tag='" . $topics_tag . "') ";
} else {
$query .= " AND v.pageid=w.id AND v.approved = 1 AND v.pagetext != '' ";
}
$query .= " ORDER BY RAND() ";
$this->database->setQuery($query);
$rows[$spot] = isset($rows[$spot]) ? $rows[$spot] : $this->database->loadObjectList();
break;
case 'itunes':
// Initiate a resource object
$rr = new \Components\Resources\Tables\Resource($this->database);
$filters['start'] = 0;
$filters['sortby'] = 'random';
$filters['tag'] = trim($this->params->get('itunes_tag'));
// Get records
$rows[$spot] = isset($rows[$spot]) ? $rows[$spot] : $rr->getRecords($filters, false);
break;
case 'answers':
$query = "SELECT C.id, C.subject, C.question, C.created, C.created_by, C.anonymous ";
$query .= ", (SELECT COUNT(*) FROM #__answers_responses AS a WHERE a.state!=2 AND a.question_id=C.id) AS rcount ";
$query .= " FROM #__answers_questions AS C ";
$query .= " WHERE C.state=0 ";
$query .= " AND (C.reward > 0 OR C.helpful > 0) ";
$query .= " ORDER BY RAND() ";
$this->database->setQuery($query);
$rows[$spot] = isset($rows[$spot]) ? $rows[$spot] : $this->database->loadObjectList();
break;
case 'blog':
$filters = array();
$filters['limit'] = 1;
$filters['start'] = 0;
$filters['state'] = 'public';
$filters['order'] = "RAND()";
$filters['search'] = '';
$filters['scope'] = 'member';
$filters['group_id'] = 0;
$filters['authorized'] = false;
$filters['sql'] = '';
$entry = \Components\Blog\Models\Entry::all()->whereEquals('scope', 'member')->whereEquals('state', 1)->whereIn('access', User::getAuthorisedViewLevels())->row();
$rows[$spot] = isset($rows[$spot]) ? $rows[$spot] : $entry;
break;
}
if ($rows && count($rows[$spot]) > 0) {
$row = $rows[$spot][0];
}
// make sure we aren't pulling the same item
if ($k != 1 && in_array($spot, $activespots) && $rows && count($rows[$spot]) > 1) {
$row = count($rows[$spot]) < $k ? $rows[$spot][$k - 1] : $rows[$spot][1];
// get the next one
}
// pull info
if ($row) {
$out = $this->_composeEntry($row, $tbl, $txtLength);
$itemid = $this->_composeEntry($row, $tbl, 0, 1);
$activespots[] = $spot;
}
// Did we get any results?
if ($out) {
$this->html .= '<li class="spot_' . $k . '">' . $out . '</li>' . "\n";
$k++;
}
}
// Output HTML
require $this->getLayoutPath();
}
/**
* Remove all user blog entries for the given user ID
*
* Method is called after user data is deleted from the database
*
* @param array $user Holds the user data
* @param boolean $success True if user was succesfully stored in the database
* @param string $msg Message
* @return boolean
*/
public function onMemberAfterDelete($user, $success, $msg)
{
if (!$success) {
return false;
}
$userId = \Hubzero\Utility\Arr::getValue($user, 'id', 0, 'int');
if ($userId) {
try {
include_once PATH_CORE . DS . 'components' . DS . 'com_blog' . DS . 'models' . DS . 'archive.php';
$entries = \Components\Blog\Models\Entry::all()->whereEquals('created_by', $user['id'])->rows();
foreach ($entries as $entry) {
if (!$entry->destroy()) {
throw new Exception($entry->getError());
}
}
} catch (Exception $e) {
return false;
}
}
return true;
}
