static function getList(&$params)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.*')->from('#__hp_albums a')->where('a.state = 1')->order('a.id DESC');
$db->setQuery($query, 0, 12);
$rs = $db->loadObjectList();
$thumb = true;
if ($thumb) {
foreach ($rs as &$item) {
$tmp = explode('/', $item->images);
$image_name = end($tmp);
$imagePath = JPATH_ROOT . DS . 'images' . DS . 'albums' . DS . $item->id;
// shift an el (image folder) in $tmp
array_shift($tmp);
// remove last el (file name) in $tmp
array_pop($tmp);
$image_path = $imagePath;
$thumb_path = $imagePath . '/thumbs/';
$thumb_image_path = $thumb_path . DS . $image_name;
@unlink($thumb_path);
@JFolder::create($thumb_path);
$thumbW = 100;
$thumbH = 100;
// create thumb if not exist
//if (!file_exists($thumb_image_path) && file_exists($image_path . DS . $image_name))
JEUtil::thumbnail($image_path, $thumb_path, $image_name, $thumbW, $thumbH);
$item->thumb = JURI::root() . 'images/albums/' . $item->id . '/thumbs/' . 't-' . $thumbW . 'x' . $thumbH . '-' . $image_name;
}
}
// var_dump($rs);
return $rs;
}
static function getList(&$params)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.*')->from('#__hp_albums a')->where('a.state = 1')->order('a.id DESC');
$arrViews = array('services', 'service');
$userId = JRequest::getInt('user', 0);
$view = JRequest::getString('view');
if ($userId && in_array($view, $arrViews)) {
$query->where('a.created_by = ' . (int) $userId);
} else {
return false;
}
$db->setQuery($query, 0, 15);
$rs = $db->loadObjectList();
$thumb = true;
if ($thumb) {
foreach ($rs as &$item) {
$tmp = explode('/', $item->images);
$image_name = end($tmp);
$imagePath = JPATH_ROOT . DS . 'images' . DS . 'albums' . DS . $item->id;
// shift an el (image folder) in $tmp
array_shift($tmp);
// remove last el (file name) in $tmp
array_pop($tmp);
$image_path = $imagePath;
$thumb_path = $imagePath . '/thumbs/';
$thumb_image_path = $thumb_path . DS . $image_name;
@JFolder::create($thumb_path);
$thumbW = CFG_THUMBNAIL_WIDTH;
$thumbH = CFG_THUMBNAIL_HEIGHT;
// create thumb if not exist
if (!file_exists($thumb_image_path) && file_exists($image_path . DS . $image_name)) {
JEUtil::thumbnail($image_path, $thumb_path, $image_name, $thumbW, $thumbH);
}
$item->thumb = JURI::root() . 'images/albums/' . $item->id . '/thumbs/' . 't-' . $thumbW . 'x' . $thumbH . '-' . $image_name;
}
}
// var_dump($rs);
return $rs;
}
public function getOtherImages($type = 'albums')
{
if (!$type) {
$type = $this->itemType;
}
$item = $this->getItem($type, false);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('*')->from('#__hp_images')->where('item_type = "' . $type . '"')->where('item_id = ' . (int) $item->id)->order('id ASC');
$db->setQuery($query);
$rs = $db->loadObjectList();
if ($db->getErrorMsg()) {
die($db->getErrorMsg());
}
$thumb = true;
if ($thumb) {
foreach ($rs as &$item) {
//$tmp = explode('/', $item->images);
$image_name = $item->images;
$imagePath = JPATH_ROOT . DS . 'images' . DS . 'albums' . DS . $item->item_id;
// shift an el (image folder) in $tmp
// array_shift($tmp);
// remove last el (file name) in $tmp
// array_pop($tmp);
$image_path = $imagePath;
$thumb_path = $imagePath . '/thumbs/';
$thumb_image_path = $thumb_path . DS . $image_name;
@JFolder::create($thumb_path);
$thumbW = CFG_THUMBNAIL_WIDTH;
$thumbH = CFG_THUMBNAIL_HEIGHT;
// create thumb if not exist
if (!file_exists($thumb_image_path) && file_exists($image_path . DS . $image_name)) {
JEUtil::thumbnail($image_path, $thumb_path, $image_name, $thumbW, $thumbH);
}
$item->thumb = JURI::root() . 'images/albums/' . $item->item_id . '/thumbs/' . 't-' . $thumbW . 'x' . $thumbH . '-' . $image_name;
}
}
return $rs;
}
