public static function getImgForSlider()
{
$ownerActiveCond = '';
if (param('useUserads')) {
$ownerActiveCond = ' AND owner_active = ' . Apartment::STATUS_ACTIVE . ' ';
}
$sql = " SELECT i.id, i.id_object, i.file_name, i.file_name_modified, i.is_main, a.title_" . Yii::app()->language . " AS title\n\t\t\t\t FROM {{images}} i\n\t\t\t\t INNER JOIN {{apartment}} a ON a.id = i.id_object\n\t\t\t\t INNER JOIN {{apartment_paid}} ap ON ap.apartment_id = i.id_object\n\t\t\t\t WHERE ap.paid_id = :paid_id AND ap.status = 1 AND a.active=" . Apartment::STATUS_ACTIVE . " {$ownerActiveCond} AND i.is_main=1 GROUP BY ap.apartment_id";
$images = Yii::app()->db->createCommand($sql)->queryAll(true, array(':paid_id' => PaidServices::ID_ADD_IN_SLIDER));
$imgs = array();
if ($images) {
foreach ($images as $image) {
$imgs[$image['id_object']]['url'] = Apartment::getUrlById($image['id_object']);
$imgs[$image['id_object']]['title'] = $image['title'];
$imgs[$image['id_object']]['src'] = $class = Yii::app()->theme->name != 'classic' ? Images::getThumbUrl($image, 663, 380) : Images::getThumbUrl($image, param('slider_img_width', 500), param('slider_img_height', 280));
}
}
return $imgs;
}
if ($this->images) {
?>
<div class="images-area">
<?php
foreach ($this->images as $image) {
if ($this->withMain && $image['is_main'] || !$this->withMain && !$image['is_main'] || !$image['is_main']) {
?>
<div class="image-item" id="image_<?php
echo $image['id'];
?>
">
<div class="image-drag-area"></div>
<div class="image-link-item">
<?php
$imgTag = CHtml::image(Images::getThumbUrl($image, 150, 100), Images::getAlt($image));
echo CHtml::link($imgTag, Images::getFullSizeUrl($image), array('class' => 'fancy', 'rel' => 'gallery', 'title' => Images::getAlt($image)));
?>
<br/>
<span class="setAsMain" link-id="<?php
echo $image['id'];
?>
">
<?php
if ($image['is_main']) {
echo tc('Main photo');
} else {
echo '<a class="setAsMainLink" href="#">' . tc('Set as main photo') . '</a>';
}
?>
</span><br/>
<?php
$count = 0;
if ($this->images) {
?>
<ul class="thumbnails">
<?php
foreach ($this->images as $image) {
?>
<li>
<?php
/*$imgTag = CHtml::image(Images::getThumbUrl($image, 640, 400), Images::getAlt($image));
echo CHtml::link($imgTag, Images::getThumbUrl($image, 640, 400),
array(
'title' => Images::getAlt($image),
)
);*/
$imgTag = CHtml::image(Images::getThumbUrl($image, 100, 100), Images::getAlt($image), array());
echo CHtml::link($imgTag, '', array('title' => Images::getAlt($image), 'class' => 'thumbnail', 'id' => 'carousel-selector-' . $count));
$count++;
?>
</li>
<?php
}
?>
</ul>
<?php
}
