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;
}
