static function getImagesFromBookSlideShow($params)
{
if (!is_numeric($max = $params->get('count_book'))) {
$max = 20;
}
if (!is_numeric($limit_title = $params->get('limit_title'))) {
$limit_title = 15;
}
$cat_id = trim($params->get('cat_id'));
if ($cat_id != "") {
$cat_id = " and c.id in ( " . $cat_id . " ) ";
}
$book_id = trim($params->get('book_id'));
if ($book_id != "") {
$book_id = " and b.id in ( " . $book_id . " ) ";
}
// build query to get slides
$db = JFactory::getDBO();
$s = modBOOKSlideShowHelper::GetWhereUserGroupsString("c");
$temp_sort = $params->get('sort_by');
switch ($temp_sort) {
case 4:
$sql_sort_top = ' CAST( b.hits AS SIGNED) ASC ';
break;
case 3:
$sql_sort_top = ' b.title ASC ';
break;
case 2:
$sql_sort_top = ' CAST( b.price AS SIGNED) ASC ';
break;
case 1:
$sql_sort_top = ' b.date DESC ';
break;
case 0:
$sql_sort_top = ' RAND() ';
break;
}
$selectstring = "SELECT b.title AS title,b.id,b.imageURL as src,b.hits,b.price,b.priceunit,b.authors,b.date,bc.catid \n \nFROM #__booklibrary AS b \n \nLEFT JOIN #__booklibrary_categories AS bc ON bc.bookid=b.id \n \nLEFT JOIN #__booklibrary_main_categories AS c ON c.id=bc.catid \n \n WHERE ({$s}) and b.published=1 and b.approved=1 " . $cat_id . $book_id . "GROUP BY b.id ORDER BY " . $sql_sort_top . " LIMIT 0, {$max};";
$db->setQuery($selectstring);
$slides = $db->loadObjectList();
foreach ($slides as $slide) {
$slide->price = $slide->price . $slide->priceunit;
$slide->src = modBOOKSlideShowHelper::getSlideImage($slide, $params);
$slide->link = modBOOKSlideShowHelper::getSlideLink($slide, $params);
//$slide->description = modBOOKSlideShowHelper::getSlideDescription($slide, $params->get('limit_desc'));
if (strlen($slide->title) > $limit_title) {
$slide->title = substr($slide->title, 0, $limit_title) . "..";
}
$slide->alt = $slide->title;
$slide->target = modBOOKSlideShowHelper::getSlideTarget($slide->link);
}
return $slides;
}
