public function actionMainsearch($rss = null)
{
$countAjax = Yii::app()->request->getParam('countAjax');
$href = Yii::app()->getBaseUrl(true) . '/' . Yii::app()->request->getPathInfo();
Yii::app()->clientScript->registerLinkTag('canonical', null, $href);
unset($href);
if (Yii::app()->request->getParam('currency')) {
setCurrency();
$this->redirect(array('mainsearch'));
}
$criteria = new CDbCriteria();
$criteria->addCondition('active = ' . Apartment::STATUS_ACTIVE);
if (param('useUserads')) {
$criteria->addCondition('owner_active = ' . Apartment::STATUS_ACTIVE);
}
$criteria->addInCondition('type', Apartment::availableApTypesIds());
$this->sApId = (int) Yii::app()->request->getParam('sApId');
if ($this->sApId) {
$criteria->addCondition('id = :sApId');
$criteria->params[':sApId'] = $this->sApId;
$apCount = Apartment::model()->count($criteria);
if ($countAjax && Yii::app()->request->isAjaxRequest) {
$this->echoAjaxCount($apCount);
}
if ($apCount) {
$apartmentModel = Apartment::model()->findByPk($this->sApId);
Yii::app()->controller->redirect($apartmentModel->getUrl());
Yii::app()->end();
}
}
// rooms
if (issetModule('selecttoslider') && param('useRoomSlider') == 1) {
$roomsMin = Yii::app()->request->getParam('room_min');
$roomsMax = Yii::app()->request->getParam('room_max');
if ($roomsMin || $roomsMax) {
$criteria->addCondition('num_of_rooms >= :roomsMin AND num_of_rooms <= :roomsMax');
$criteria->params[':roomsMin'] = $roomsMin;
$criteria->params[':roomsMax'] = $roomsMax;
$this->roomsCountMin = $roomsMin;
$this->roomsCountMax = $roomsMax;
}
} else {
$rooms = Yii::app()->request->getParam('rooms');
if ($rooms) {
if ($rooms == 4) {
$criteria->addCondition('num_of_rooms >= :rooms');
} else {
$criteria->addCondition('num_of_rooms = :rooms');
}
$criteria->params[':rooms'] = $rooms;
$this->roomsCount = $rooms;
}
}
// floor
if (issetModule('selecttoslider') && param('useFloorSlider') == 1) {
$floorMin = Yii::app()->request->getParam('floor_min');
$floorMax = Yii::app()->request->getParam('floor_max');
if ($floorMin || $floorMax) {
$criteria->addCondition('floor >= :floorMin AND floor <= :floorMax');
$criteria->params[':floorMin'] = $floorMin;
$criteria->params[':floorMax'] = $floorMax;
$this->floorCountMin = $floorMin;
$this->floorCountMax = $floorMax;
}
} else {
$floor = Yii::app()->request->getParam('floor');
if ($floor) {
$criteria->addCondition('floor = :floor');
$criteria->params[':floor'] = $floor;
$this->floorCount = $floor;
}
}
// square
if (issetModule('selecttoslider') && param('useSquareSlider') == 1) {
$squareMin = Yii::app()->request->getParam('square_min');
$squareMax = Yii::app()->request->getParam('square_max');
if ($squareMin || $squareMax) {
$criteria->addCondition('square >= :squareMin AND square <= :squareMax');
$criteria->params[':squareMin'] = $squareMin;
$criteria->params[':squareMax'] = $squareMax;
$this->squareCountMin = $squareMin;
$this->squareCountMax = $squareMax;
}
} else {
$square = Yii::app()->request->getParam('square');
if ($square) {
$criteria->addCondition('square <= :square');
$criteria->params[':square'] = $square;
$this->squareCount = $square;
}
}
$location = (int) Yii::app()->request->getParam('location_id');
$subLocation = (int) Yii::app()->request->getParam('sublocation_id');
$region = (int) Yii::app()->request->getParam('region_id');
if ($subLocation) {
if (empty($region)) {
$criteria->addCondition('sublocation_id = :sublocation_id AND location_id = :location_id');
$criteria->params[':sublocation_id'] = $subLocation;
$criteria->params[':location_id'] = $location;
} else {
$criteria->addCondition('sublocation_id = :sublocation_id AND region_id = :region_id');
$criteria->params[':sublocation_id'] = $subLocation;
$criteria->params[':region_id'] = $region;
}
} elseif ($location) {
$criteria->addCondition('location_id = :location_id');
$criteria->params[':location_id'] = $location;
}
$landSquare = Yii::app()->request->getParam('land_square');
if ($landSquare) {
$criteria->addCondition('land_square <= :land_square');
$criteria->params[':land_square'] = $landSquare;
$this->landSquare = $landSquare;
}
if (issetModule('location') && param('useLocation', 1)) {
$country = Yii::app()->request->getParam('country');
if ($country) {
$this->selectedCountry = $country;
$criteria->compare('loc_country', $country);
}
$region = Yii::app()->request->getParam('region');
if ($region) {
$this->selectedRegion = $region;
$criteria->compare('loc_region', $region);
}
$city = Yii::app()->request->getParam('city');
if ($city) {
$this->selectedCity = $city;
$criteria->addInCondition('t.loc_city', $city);
}
} else {
$city = Yii::app()->request->getParam('city');
if ($city) {
$this->selectedCity = $city;
$criteria->addInCondition('t.city_id', $city);
}
}
$this->objType = Yii::app()->request->getParam('objType');
if ($this->objType) {
$criteria->addCondition('obj_type_id = :objType');
$criteria->params[':objType'] = $this->objType;
}
// type
$this->apType = Yii::app()->request->getParam('apType');
if ($this->apType) {
$criteria->addCondition('price_type = :apType');
$criteria->params[':apType'] = $this->apType;
}
$type = Yii::app()->request->getParam('type');
if ($type) {
$criteria->addCondition('type = :type');
$criteria->params[':type'] = $type;
}
// price
if (issetModule('selecttoslider') && param('usePriceSlider') == 1) {
$priceMin = Yii::app()->request->getParam("price_min");
$priceMax = Yii::app()->request->getParam("price_max");
if ($priceMin || $priceMax) {
$criteria->addCondition('(price >= :priceMin AND price <= :priceMax) OR (is_price_poa = 1)');
if (issetModule('currency')) {
$criteria->params[':priceMin'] = floor(Currency::convertToDefault($priceMin));
$criteria->params[':priceMax'] = ceil(Currency::convertToDefault($priceMax));
} else {
$criteria->params[':priceMin'] = $priceMin;
$criteria->params[':priceMax'] = $priceMax;
}
$this->priceSlider["min"] = $priceMin;
$this->priceSlider["max"] = $priceMax;
}
} else {
$price = Yii::app()->request->getParam('price');
if (issetModule('currency')) {
$priceDefault = ceil(Currency::convertToDefault($price));
} else {
$priceDefault = $price;
}
if ($priceDefault) {
$criteria->addCondition('(price <= :price) OR (is_price_poa = 1)');
$criteria->params[':price'] = $priceDefault;
$this->price = $price;
}
}
// ключевые слова
$term = Yii::app()->request->getParam('term');
$doTermSearch = Yii::app()->request->getParam('do-term-search');
if ($term && $doTermSearch == 1) {
$term = utf8_substr($term, 0, 50);
$term = cleanPostData($term);
if ($term && utf8_strlen($term) >= $this->minLengthSearch) {
$this->term = $term;
$words = explode(' ', $term);
if (count($words) > 1) {
$searchString = '+' . implode('* +', $words) . '* ';
# https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html
$sql = 'SELECT id
FROM {{apartment}}
WHERE MATCH
(title_' . Yii::app()->language . ', description_' . Yii::app()->language . ', description_near_' . Yii::app()->language . ', address_' . Yii::app()->language . ')
AGAINST ("' . $searchString . '" IN BOOLEAN MODE)';
} else {
$sql = 'SELECT id
FROM {{apartment}}
WHERE MATCH
(title_' . Yii::app()->language . ', description_' . Yii::app()->language . ', description_near_' . Yii::app()->language . ', address_' . Yii::app()->language . ')
AGAINST ("*' . $term . '*" IN BOOLEAN MODE)';
}
$resTerm = Yii::app()->db->createCommand($sql)->queryAll();
if (is_array($resTerm) && count($resTerm) > 0) {
$resTerm = CHtml::listData($resTerm, 'id', 'relevance');
$criteria->addInCondition('t.id', array_keys($resTerm));
} else {
$criteria->addInCondition('t.id', array(0));
# ничего не найдено
}
}
}
// поиск объявлений владельца
$this->userListingId = Yii::app()->request->getParam('userListingId');
if ($this->userListingId) {
$criteria->addCondition('owner_id = :userListingId');
$criteria->params[':userListingId'] = $this->userListingId;
}
$filterName = null;
// Поиск по справочникам - клик в просмотре профиля анкеты
if (param('useReferenceLinkInView')) {
if (Yii::app()->request->getQuery('serviceId', false)) {
$serviceId = Yii::app()->request->getQuery('serviceId', false);
if ($serviceId) {
$serviceIdArray = explode('-', $serviceId);
if (is_array($serviceIdArray) && count($serviceIdArray) > 0) {
$value = (int) $serviceIdArray[0];
$sql = 'SELECT DISTINCT apartment_id FROM {{apartment_reference}} WHERE reference_value_id = ' . $value;
$apartmentIds = Yii::app()->db->cache(param('cachingTime', 1209600), Apartment::getDependency())->createCommand($sql)->queryColumn();
//$apartmentIds = Yii::app()->db->createCommand($sql)->queryColumn();
$criteria->addInCondition('t.id', $apartmentIds);
Yii::app()->getModule('referencevalues');
$sql = 'SELECT title_' . Yii::app()->language . ' FROM {{apartment_reference_values}} WHERE id = ' . $value;
$filterName = Yii::app()->db->cache(param('cachingTime', 1209600), ReferenceValues::getDependency())->createCommand($sql)->queryScalar();
if ($filterName) {
$filterName = CHtml::encode($filterName);
}
}
}
}
}
if (issetModule('formeditor')) {
$newFieldsAll = FormDesigner::getNewFields();
foreach ($newFieldsAll as $field) {
$value = CHtml::encode(Yii::app()->request->getParam($field->field));
if (!$value) {
continue;
}
$fieldString = $field->field;
$this->newFields[$fieldString] = $value;
switch ($field->compare_type) {
case FormDesigner::COMPARE_EQUAL:
$criteria->compare($fieldString, $value);
break;
case FormDesigner::COMPARE_LIKE:
$criteria->compare($fieldString, $value, true);
break;
case FormDesigner::COMPARE_FROM:
$value = intval($value);
$criteria->compare($fieldString, ">={$value}");
break;
case FormDesigner::COMPARE_TO:
$value = intval($value);
$criteria->compare($fieldString, "<={$value}");
break;
}
}
}
if ($rss && issetModule('rss')) {
$this->widget('application.modules.rss.components.RssWidget', array('criteria' => $criteria));
}
// find count
$apCount = Apartment::model()->count($criteria);
if ($countAjax && Yii::app()->request->isAjaxRequest) {
$this->echoAjaxCount($apCount);
}
$searchParams = $_GET;
if (isset($searchParams['is_ajax'])) {
unset($searchParams['is_ajax']);
}
Yii::app()->user->setState('searchUrl', Yii::app()->createUrl('/search', $searchParams));
unset($searchParams);
if (isset($_GET['is_ajax'])) {
// $modeListShow = User::getModeListShow();
// if ($modeListShow == 'table') {
// # нужны скрипты и стили, поэтому processOutput установлен в true только для table
// $this->renderPartial('index', array(
// 'criteria' => $criteria,
// 'apCount' => $apCount,
// 'filterName' => $filterName,
// ), false, true);
// }
// else {
$this->renderPartial('index', array('criteria' => $criteria, 'apCount' => $apCount, 'filterName' => $filterName));
// }
} else {
$this->render('index', array('criteria' => $criteria, 'apCount' => $apCount, 'filterName' => $filterName));
}
}
public static function getCurrentCurrencyModel()
{
if (!isset(self::$_currentCurrencyModel)) {
setCurrency();
$charCode = '';
if (isset(Yii::app()->request->cookies['_currency'])) {
$charCode = Yii::app()->request->cookies['_currency']->value;
}
if ($charCode) {
self::$_currentCurrencyModel = Currency::model()->findByAttributes(array('char_code' => $charCode));
if (!self::$_currentCurrencyModel) {
// Если $charCode был не валидный, получаем модель валюты согласно языку сайта
self::$_currentCurrencyModel = self::getModelByLang(Yii::app()->language);
// Удаляем его из куков
unset(Yii::app()->request->cookies['_currency']);
}
} else {
self::$_currentCurrencyModel = self::getModelByLang(Yii::app()->language);
}
if (!self::$_currentCurrencyModel) {
self::$_currentCurrencyModel = self::getDefaultCurrencyModel();
}
}
return self::$_currentCurrencyModel;
}
function currency()
{
$g = setCurrency($_POST['currency_select']);
redirect($_SERVER['HTTP_REFERER']);
}
function getRate($amount)
{
$ci =& get_instance();
if ($ci->session->userdata('currency') && $ci->session->userdata('rate')) {
$amt = $ci->session->userdata('prefix') . $ci->session->userdata('symbol');
$amt .= number_format($amount * $ci->session->userdata('rate'), 2);
$amt .= $ci->session->userdata('suffix');
return $amt;
} else {
setCurrency('CAD');
/*
$country = ip2Country();
$eu = array('AT','BE','BG','CY','CZ','DK','EE',
'FI','FR','DE','EL','HU','IE','IT',
'LV','LT','LU','MT','NL','PL','PT',
'RO','SK','SI','ES','SE');
if($country=='US') { setCurrency('USD'); }
elseif($country=='UK') { setCurrency('GBP'); }
elseif($country=='AU') { setCurrency('AUD'); }
elseif($country=='NZ') { setCurrency('NZD'); }
elseif(in_array($country,$eu)) { setCurrency('EUR'); }
else { setCurrency('CAD'); }
*/
return $ci->session->userdata('prefix') . $ci->session->userdata('symbol') . number_format($amount, 2) . $ci->session->userdata('suffix');
}
}
