static function getList($params, $count) { $mainframe = JFactory::getApplication(); $catids = $params->get('k2catids', array()); $ordering = $params->get('ordering', 'a.ordering'); $ordering_direction = $params->get('ordering_direction', 'ASC'); $user_id = $params->get('user_id'); $show_featured = $params->get('show_featured'); $user = JFactory::getUser(); $aid = $user->get('aid'); $db = JFactory::getDBO(); $jnow = JFactory::getDate(); if (version_compare(JVERSION, '3.0', '<') == 1) { $now = $jnow->toMySQL(); } else { $now = $jnow->toSql(); } $nullDate = $db->getNullDate(); $query = "SELECT a.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams" . " FROM #__k2_items as a" . " LEFT JOIN #__k2_categories c ON c.id = a.catid"; if (version_compare(JVERSION, '3.0', '<') == 1) { $query .= " WHERE a.published = 1 AND a.access IN(" . implode(',', $user->authorisedLevels()) . ") AND a.trash = 0 AND c.published = 1 AND c.access IN(" . implode(',', $user->authorisedLevels()) . ") AND c.trash = 0"; } else { $query .= " WHERE a.published = 1 AND a.access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") AND a.trash = 0 AND c.published = 1 AND c.access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") AND c.trash = 0"; } // User filter $userId = JFactory::getUser()->get('id'); switch ($params->get('user_id')) { case 'by_me': $query .= ' AND (a.created_by = ' . (int) $userId . ' OR a.modified_by = ' . (int) $userId . ')'; break; case 'not_me': $query .= ' AND (a.created_by <> ' . (int) $userId . ' AND a.modified_by <> ' . (int) $userId . ')'; break; case '0': break; default: $query .= ' AND (a.created_by = ' . (int) $userId . ' OR a.modified_by = ' . (int) $userId . ')'; break; } //Added Category if (!is_null($catids)) { if (is_array($catids)) { JArrayHelper::toInteger($catids); $query .= " AND a.catid IN(" . implode(',', $catids) . ")"; } else { $query .= " AND a.catid=" . (int) $catids; } } // Featured items filter if ($show_featured == '0') { $query .= " AND a.featured != 1"; } if ($show_featured == '1') { $query .= " AND a.featured = 1"; } // ensure should be published $query .= " AND ( a.publish_up = " . $db->Quote($nullDate) . " OR a.publish_up <= " . $db->Quote($now) . " )"; $query .= " AND ( a.publish_down = " . $db->Quote($nullDate) . " OR a.publish_down >= " . $db->Quote($now) . " )"; if (K2_JVERSION != '15') { if ($mainframe->getLanguageFilter()) { $languageTag = JFactory::getLanguage()->getTag(); $query .= " AND c.language IN (" . $db->Quote($languageTag) . ", " . $db->Quote('*') . ") AND i.language IN (" . $db->Quote($languageTag) . ", " . $db->Quote('*') . ")"; } } //Ordering $orderby = $ordering . ' ' . $ordering_direction; //ordering $query .= " ORDER BY " . $orderby; $db->setQuery($query, 0, $count); $items = $db->loadObjectList(); $model = K2Model::getInstance('Item', 'K2Model'); if (count($items)) { foreach ($items as $item) { if (!empty($item->created_by_alias)) { $item->author = $item->created_by_alias; } else { $author = JFactory::getUser($item->created_by); $item->author = $author->name; } $item->created = $item->created; $item->hits = $item->hits; $item->category = $item->categoryname; $item->cat_link = urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($item->catid . ':' . urlencode($item->categoryalias)))); $item->image = modTzContentSliderK2Helper::getImage($item->id, $item->introtext); $item->title = htmlspecialchars($item->title); $item->introtext = $item->introtext; $item->link = urldecode(JRoute::_(K2HelperRoute::getItemRoute($item->id . ':' . urlencode($item->alias), $item->catid . ':' . urlencode($item->categoryalias)))); $item->comment = '<a class="tzcontentslider-comments" href="' . $item->link . '#itemCommentsAnchor">' . JText::_('COMMENTS_TEXT') . ' (' . $model->countItemComments($item->id) . ')</a>'; $item->rating = $model->getVotesPercentage($item->id); if ($params->get('article_extra_fields')) { $item->extra_fields = $model->getItemExtraFields($item->extra_fields, $item); } $rows[] = $item; } return $rows; } }
$c_count = $c_article_count + $c_links_count; if (!class_exists("modTzContentSliderCommonHelper")) { require_once 'common.php'; } if ($content_source == "joomla") { require_once dirname(__FILE__) . DS . 'helper.php'; $list = modTzContentSliderJHelper::getList($params, $c_count); } elseif ($content_source == "vm") { if (!class_exists('VmModel')) { require JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_virtuemart' . DS . 'helpers' . DS . 'vmmodel.php'; } require_once dirname(__FILE__) . DS . 'vmhelper.php'; $list = modTzContentSliderVMHelper::getList($params, $c_count); } else { require_once dirname(__FILE__) . DS . 'k2helper.php'; $list = modTzContentSliderK2Helper::getList($params, $c_count); } $a_count = count($list); //actual count if ($c_count > $a_count) { $c_count = $a_count; if ($c_article_count >= $c_count) { $c_article_count = $c_count; $c_links_count = 0; } else { if ($c_links_count > $c_count - $c_article_count) { $c_links_count = $c_count - $c_article_count; } } } if ($content_source == "vm" && ($art_show_cart_button || $links_show_cart_button)) {