/** * Insert city if not found and has correct district, otherwise return id. Return -1 for incorrect district */ public static function insertIfNotFound($cityName, $province_id, $district_id = null) { if (!$cityName) { return false; } if ($district_id) { // verify district is in correct province require_once 'models/table/LocationDistrict.php'; if (LocationDistrict::validateDistrict($district_id, $province_id) !== true) { return -1; } } $cityTable = new LocationCity(); $select = $cityTable->select()->from($cityTable->_name, "id")->where("city_name = '{$cityName}' AND parent_province_id = {$province_id}"); if ($district_id) { $select->where("parent_district_id = {$district_id}"); } $row = $cityTable->fetchRow($select); if ($row) { return $row->id; } else { // insert $data = array(); $data['city_name'] = $cityName; $data['parent_district_id'] = $district_id; $data['parent_province_id'] = $province_id; return $cityTable->insert($data); } }
public function actionPlaceorder() { $country = Yii::app()->request->getParam('country'); $region = Yii::app()->request->getParam('region'); $objType = Yii::app()->request->getParam('objType'); $city = Yii::app()->request->getParam('city'); $price = !is_null(Yii::app()->request->getParam('price')) ? Yii::app()->request->getParam('price') : 0; $pricePoa = $price == 0 ? 1 : 0; $numOfRooms = !is_null(Yii::app()->request->getParam('numOfRooms')) ? Yii::app()->request->getParam('numOfRooms') : 1; $square = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('square') : Yii::app()->request->getParam('squareOther'); $squareLive = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('squareLive') : Yii::app()->request->getParam('squareLiveOther'); $squareKitchen = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('squareKitchen') : Yii::app()->request->getParam('squareKitchenOther'); $floorTotal = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('numOfFloors') : Yii::app()->request->getParam('numOfFloorsOther'); $floor = Yii::app()->request->getParam('floor'); $roomFormula = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('roomFormula') : Yii::app()->request->getParam('roomFormulaOther'); $windowTo = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('window') : Yii::app()->request->getParam('windowOther'); $apType = Yii::app()->request->getParam('renttype') ? Yii::app()->request->getParam('renttype') : 1; $moneyType = Yii::app()->request->getParam('moneyType'); if (Yii::app()->request->getParam('renttype') == 2) { $apType = 2; } $streetName = Yii::app()->request->getParam('street'); $metro = Yii::app()->request->getParam('metro'); $date = new \DateTime(); $createDate = $date->format('Y-m-d H:i:s'); $howLong = Yii::app()->request->getParam('rentlimit') ? Yii::app()->request->getParam('rentlimit') : 3; $limitDate = $date->add(new \DateInterval('P' . $howLong . 'D'))->format('Y-m-d'); $objectDescription = Yii::app()->request->getParam('additional'); $agentbonus = Yii::app()->request->getParam('agentbonus'); $clientbonus = Yii::app()->request->getParam('clientbonus'); $conditions = Yii::app()->request->getParam('condition'); $elevatorPass = Yii::app()->request->getParam('elevatorPass'); $elevatorCargo = Yii::app()->request->getParam('elevatorCargo'); $buildingType = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('buildingType') : Yii::app()->request->getParam('buildingTypeOther'); $floorType = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('floorType') : Yii::app()->request->getParam('floorTypeOther'); $facingType = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('facingtype') : Yii::app()->request->getParam('facingtypeOther'); $balcony = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('balcony') : Yii::app()->request->getParam('balconyOther'); $closet = !($objType == 4 || $objType == 19) ? Yii::app()->request->getParam('closet') : Yii::app()->request->getParam('closetOther'); $floorsHeight = Yii::app()->request->getParam('floorsHeight'); $bedrooms = Yii::app()->request->getParam('bedrooms'); $bathrooms = Yii::app()->request->getParam('bathrooms'); $pools = Yii::app()->request->getParam('pools'); $water = Yii::app()->request->getParam('water'); $center = Yii::app()->request->getParam('citycenter'); $mountains = Yii::app()->request->getParam('mountains'); $address = LocationCountry::getAllCountries()[$country] . "," . LocationRegion::getAllRegions()[$region] . "," . LocationCity::getCities()[$city]; if (!is_null($metro)) { $address .= $metro; } if (!is_null($streetName)) { $address .= $streetName; } $lat = Apartment::model()->getCoordinates($address)[0]; $lng = Apartment::model()->getCoordinates($address)[1]; $command = Yii::app()->db->createCommand(); $params = ['type' => $apType, 'obj_type_id' => $objType, 'loc_country' => $country, 'loc_region' => $region, 'loc_city' => $city, 'city_id' => 0, 'visits' => 0, 'date_updated' => $createDate, 'date_created' => $createDate, 'date_end_activity' => $limitDate, 'activity_always' => 1, 'is_price_poa' => $pricePoa, 'price' => $price, 'price_to' => 0, 'num_of_rooms' => $numOfRooms, 'floor' => $floor, 'floor_total' => $floorTotal, 'square' => $square, 'live_square' => $squareLive, 'land_square' => 0, 'ci_square' => $squareKitchen, 'squareFormula' => $roomFormula, 'window_to' => $windowTo, 'title_ru' => LocationCity::getCities()[$city] . ',' . $streetName, 'description_ru' => $objectDescription, 'description_near_ru' => $objectDescription, 'living_conditions' => 0, 'services' => 0, 'address_ru' => $streetName, 'berths' => 0, 'active' => 1, 'lat' => $lat, 'lng' => $lng, 'rating' => 0, 'date_up_search' => $createDate, 'is_special_offer' => 0, 'is_free_to' => $limitDate, 'price_type' => 1, 'sorter' => 1, 'owner_active' => 1, 'owner_id' => Yii::app()->user->id, 'exchange_to_ru' => 'exchange_not_available', 'note' => 'just note', 'phone' => Yii::app()->user->phone, 'autoVKPostId' => 'no', 'autoFBPostId' => 'no', 'autoTwitterPostId' => 'no', 'count_img' => 0, 'deleted' => 0, 'metro' => $metro, 'agentbonus' => $agentbonus, 'clientbonus' => $clientbonus, 'elevatorPass' => $elevatorPass, 'elevatorCargo' => $elevatorCargo, 'buildingType' => $buildingType, 'floorType' => $floorsHeight, 'floors' => $floorType, 'facingType' => $facingType, 'balcony' => $balcony, 'closet' => $closet, 'bedrooms' => $bedrooms, 'bathrooms' => $bathrooms, 'pools' => $pools, 'waterNear' => $water, 'centerNear' => $center, 'mountainsNear' => $mountains, 'moneyType' => $moneyType]; $command->insert('bt_apartment', $params); $apartmentId = Yii::app()->db->getLastInsertID(); foreach ($conditions as $key => $value) { $paramsList = ['apartment_id' => $apartmentId, 'conditionname' => $key]; $command->insert('bt_apartments_conditions', $paramsList); } $this->redirect('/usercpanel/main/rentorders'); }
public static function generateLists() { return array('types' => array('покупка' => Apartment::TYPE_BUY, 'обмен' => Apartment::TYPE_CHANGE, 'съем' => Apartment::TYPE_RENT, 'сдача' => Apartment::TYPE_RENTING, 'продажа' => Apartment::TYPE_SALE), 'category' => CHtml::listData(ApartmentObjType::model()->findAll(), 'name_ru', 'id'), 'location_city' => CHtml::listData(LocationCity::model()->findAll(), 'name_ru', 'id'), 'window_view' => CHtml::listData(WindowTo::model()->findAll(), 'title_ru', 'id')); }
echo Yii::app()->theme->baseUrl . '/images/content/col_1_addres.png'; ?> "> </div> <div class="col-2"> <?php $selectedCountryIndex = LocationCountry::getAllCountries()[0]; echo CHtml::dropDownList('country', $select, LocationCountry::getAllCountries(), ['class' => 'long-select', 'options' => [$selectedCoutryIndex => ['selected' => 'selected']]]); ?> <?php $selectedRegionIndex = LocationRegion::getAllRegions()[0]; echo CHtml::dropDownList('region', $select, LocationRegion::getAllRegions(), ['class' => 'long-select', 'options' => [$selectedRegionIndex => ['selected' => 'selected']]]); ?> <?php $selectedCityIndex = LocationCity::getCities()[0]; echo CHtml::dropDownList('city', $select, LocationCity::getCities(), ['class' => 'long-select', 'options' => [$selectedCityIndex => ['selected' => 'selected']]]); ?> <select class="long-select" name="streetname"> <option>Авиамоторная улица</option> </select> <select class="long-select"> <option>12</option> </select> </div> <div class="col-3"> <div class="map-search"></div> </div> </div> <div class="block-3"> <div class="col-1"> <img src="<?php
Смотреть фото<br> <a href="#" class="objectPhoto lookPhoto"> <?php echo $negative->count_img; ?> фото</a> <?php } else { ?> <div class="objectPhoto noPhoto"></div> <?php } ?> </div></td> <td><?php echo LocationCity::getCities()[$negative->loc_city] . '.' . $negative->address_ru; ?> </td> <td><?php echo 'Общая:' . $negative->square . 'м2 Кухня:' . $negative->ci_square . 'м2'; ?> </td> <td>До 30 000 р. Предоплата 1 месяц Аренда от года</td> <td>100% агенту</td> <td><?php echo $negative->floor . '/' . $negative->floor_total; ?> </td> <td>мебель холодильник стир. машина балкон евроремонт</td> <td><div > <a href="#" class="lookContact"></a> показать </div></td> <td><table width="100%" border="0" cellspacing="0">
</tr> <?php foreach ($rentorders as $rentorder) { ?> <tr> <td><img class="star-mark" src="<?php echo Yii::app()->theme->baseUrl . '/views/modules/usercpanel/images/content/star-mark.png'; ?> " width="15" height="15" alt=""/></td> <td><div class="tableObject"> <?php echo $rentorder->numOfRooms . '-к ' . ApartmentObjType::getApartmentObjects()[$rentorder->objTypeId]; ?> </td> <td><?php echo LocationCity::getCities()[$rentorder->loc_city_id] . ',' . $rentorder->stationName; ?> </td> <td><?php echo 'Общая:' . $rentorder->square . 'м2 Кухня:' . $rentorder->squareKitchen . 'м2'; ?> </td> <td> <?php echo $rentorder->price . ($rentorder->moneyType == 1 ? 'р.' : '$') . "<br>" . ApartmentsRents::getStrLabels($rentorder->searchRequirements); ?> </td> <td>Не важно</td> <td><?php echo !($rentorder->objTypeId == 4 || $rentorder->objTypeId == 19) ? $rentorder->floor . '/' . $rentorder->numOfFloors : $rentorder->numOfFloors; ?>
<a href="#" class="objectPhoto lookPhoto"> <?php echo $rentorder->count_img; ?> фото</a> <?php } else { ?> <div class="objectPhoto noPhoto"></div> <?php } ?> </div> </td> <td><?php echo LocationCity::getCities()[$rentorder->loc_city] . '.' . $rentorder->address_ru; ?> </td> <td>Общая:<?php echo $rentorder->square; ?> м2 Кухня: <?php echo $rentorder->ci_square; ?> м2 </td> <td><?php echo $rentorder->price . ($rentorder->moneyType == 1 ? 'р.' : '$'); ?> р. Предоплата 1 месяц Аренда от года</td> <td><?php