static function getImagesFromDJImageSlider(&$params) { if(!is_numeric($max = $params->get('max_images'))) $max = 20; $catid = $params->get('category',0); // build query to get slides $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('a.*'); $query->from('#__djimageslider AS a'); if (is_numeric($catid)) { $query->where('a.catid = ' . (int) $catid); } $query->where('a.published = 1'); if($params->get('sort_by',1)) { $query->order('a.ordering ASC'); } else { $query->order('RAND()'); } $db->setQuery($query, 0 , $max); $slides = $db->loadObjectList(); foreach($slides as $slide){ $slide->link = modDJImageSliderHelper::getSlideLink($slide); $slide->description = modDJImageSliderHelper::getSlideDescription($slide, $params->get('limit_desc')); $slide->alt = $slide->title; $slide->target = modDJImageSliderHelper::getSlideTarget($slide->link); } return $slides; }
static function getImagesFromDJImageSlider(&$params) { if (!is_numeric($max = $params->get('max_images'))) { $max = 20; } $catid = $params->get('category', 0); // build query to get slides $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('a.*'); $query->from('#__djimageslider AS a'); if (is_numeric($catid)) { $query->where('a.catid = ' . (int) $catid); } // Filter by start and end dates. $nullDate = $db->Quote($db->getNullDate()); $nowDate = $db->Quote(JFactory::getDate()->format($db->getDateFormat())); $query->where('a.published = 1'); $query->where('(a.publish_up = ' . $nullDate . ' OR a.publish_up <= ' . $nowDate . ')'); $query->where('(a.publish_down = ' . $nullDate . ' OR a.publish_down >= ' . $nowDate . ')'); if ($params->get('sort_by', 1)) { $query->order('a.ordering ASC'); } else { $query->order('RAND()'); } $db->setQuery($query, 0, $max); $slides = $db->loadObjectList(); foreach ($slides as $slide) { $slide->params = new JRegistry($slide->params); $slide->link = modDJImageSliderHelper::getSlideLink($slide); $slide->description = modDJImageSliderHelper::getSlideDescription($slide, $params->get('limit_desc')); $slide->alt = $slide->title; $slide->target = $slide->params->get('link_target', ''); if (empty($slide->target)) { $slide->target = modDJImageSliderHelper::getSlideTarget($slide->link); } } return $slides; }