public function myDateValidator($param) { $dateStart = CDateTimeParser::parse($this->date_start, Booking::getYiiDateFormat()); // format to unix timestamp $dateEnd = CDateTimeParser::parse($this->date_end, Booking::getYiiDateFormat()); // format to unix timestamp if ($param == 'date_start' && $dateStart < CDateTimeParser::parse(date('Y-m-d'), 'yyyy-MM-dd')) { $this->addError('date_start', tt('Wrong check-in date', 'booking')); } if ($param == 'date_end' && $dateEnd <= $dateStart) { $this->addError('date_end', tt('Wrong check-out date', 'booking')); } }
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('t.active = ' . Apartment::STATUS_ACTIVE); $criteria->addCondition('t.deleted = 0'); if (param('useUserads')) { $criteria->addCondition('t.owner_active = ' . Apartment::STATUS_ACTIVE); } $criteria->addInCondition('t.type', Apartment::availableApTypesIds()); $criteria->addInCondition('t.price_type', array_keys(Apartment::getPriceArray(Apartment::PRICE_SALE, true))); $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; } } $this->bStart = Yii::app()->request->getParam('b_start'); $this->bEnd = Yii::app()->request->getParam('b_end'); if ($this->bStart) { $dateStart = Yii::app()->dateFormatter->format('yyyy-MM-dd', CDateTimeParser::parse($this->bStart, Booking::getYiiDateFormat())); if ($this->bEnd) { $dateEnd = Yii::app()->dateFormatter->format('yyyy-MM-dd', CDateTimeParser::parse($this->bEnd, Booking::getYiiDateFormat())); } else { $dateEnd = $dateStart; } if ($dateStart && $dateEnd) { $criteria->addCondition('t.id NOT IN ( SELECT DISTINCT b.apartment_id FROM {{booking_calendar}} AS b WHERE b.date_start BETWEEN :b_start AND :b_end OR :b_start BETWEEN b.date_start AND b.date_end )'); $criteria->params['b_start'] = $dateStart; $criteria->params['b_end'] = $dateEnd; } } // 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; } } $landSquare = Yii::app()->request->getParam('land_square'); if ($landSquare) { $criteria->addCondition('land_square <= :land_square'); $criteria->params[':land_square'] = $landSquare; $this->landSquare = $landSquare; } $ci_Square = Yii::app()->request->getParam('ci_square'); if ($ci_Square) { $criteria->addCondition('ci_square <= :ci_square'); $criteria->params[':ci_square'] = $ci_Square; $this->ci_Square = $ci_Square; } $this->selectedCity = Yii::app()->request->getParam('city', array()); if (isset($this->selectedCity[0]) && $this->selectedCity[0] == 0) { $this->selectedCity = array(); } $this->wp = Yii::app()->request->getParam('wp'); if ($this->wp) { $criteria->addCondition('count_img > 0'); } $this->ot = Yii::app()->request->getParam('ot'); if ($this->ot) { $criteria->join = 'INNER JOIN {{users}} AS u ON u.id = t.owner_id'; if ($this->ot == User::TYPE_PRIVATE_PERSON) { $ownerTypes = array(User::TYPE_PRIVATE_PERSON, User::TYPE_ADMIN); } if ($this->ot == User::TYPE_AGENCY) { $ownerTypes = array(User::TYPE_AGENT, User::TYPE_AGENCY); } if (isset($ownerTypes) && $ownerTypes) { $criteria->compare('u.type', $ownerTypes); } } if (issetModule('location')) { $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); } if ($this->selectedCity) { $criteria->compare('t.loc_city', $this->selectedCity); } } else { if ($this->selectedCity) { $criteria->compare('t.city_id', $this->selectedCity); } } $this->objType = Yii::app()->request->getParam('objectType'); if ($this->objType) { $criteria->compare('obj_type_id', $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); foreach ($words as $key => $value) { if (mb_strlen($value, "UTF-8") < $this->minLengthSearch) { unset($words[$key]); } } if (count($words) > 1) { $cleanWords = array(); foreach ($words as $word) { if (utf8_strlen($word) >= $this->minLengthSearch) { $cleanWords[] = $word; } } $searchString = '+' . implode('* +', $cleanWords) . '* '; # 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 (Yii::app()->request->isAjaxRequest) { // $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 addRecord(Booking $booking) { $dateStart = Yii::app()->dateFormatter->format('yyyy-MM-dd', CDateTimeParser::parse($booking->date_start, Booking::getYiiDateFormat())); $dateEnd = Yii::app()->dateFormatter->format('yyyy-MM-dd', CDateTimeParser::parse($booking->date_end, Booking::getYiiDateFormat())); $model = new Bookingtable(); $model->active = self::STATUS_NEW; $model->apartment_id = $booking->apartment_id; $model->username = $booking->username; $model->email = $booking->useremail; $model->phone = $booking->phone; $model->date_start = $dateStart; $model->date_end = $dateEnd; $model->time_in = $booking->time_in; $model->time_out = $booking->time_out; $model->comment = $booking->comment; $model->user_ip = $booking->user_ip; $model->user_ip_ip2_long = $booking->user_ip_ip2_long; $model->save(false); }