1284 lines
76 KiB
PHP
1284 lines
76 KiB
PHP
<?php
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
if(!$_SESSION['id']) { header("location:index.php"); die("Доступ запрещён!");}
|
||
$get=clearInputData($_GET);
|
||
|
||
$sql3="SELECT objects_additional_information.*,
|
||
bath_type.name as bath_type,
|
||
window_view.name as window_view,
|
||
objects.*,
|
||
renovation.name as renovation,
|
||
hot_water.name as hot_water,
|
||
parking_type.name as parking_type,
|
||
rayon.rayon,
|
||
sale_objects.house_material,
|
||
house_material.name as house_material_name,
|
||
sale_objects.house_type, house_type.name as house_type_name,
|
||
sale_objects.deal_type, sale_objects.sale_type, deal_type.name as deal_type_name,
|
||
sale_objects.build_year, DATE_FORMAT(objects.date_add,'%d.%m.%Y %H:%i') as date_add,
|
||
lu.name as land_usage_name,
|
||
lp.name as land_purpose,
|
||
el.name as electricity_type,
|
||
gt.name as gas_type,
|
||
pt.name as plumbing_type,
|
||
st.name as sewerage_type,
|
||
rt.name as relief_type,
|
||
sht.name as shape_type,
|
||
ads_objects.ads_source as ads_source,
|
||
ads_objects.ads_url as ads_url
|
||
FROM objects objects
|
||
LEFT JOIN sale_objects sale_objects on objects.id = sale_objects.object_id
|
||
LEFT JOIN ads_objects ads_objects ON objects.id = ads_objects.obj_id
|
||
LEFT JOIN house_material house_material on sale_objects.house_material = house_material.id
|
||
LEFT JOIN house_type house_type on house_type.id = sale_objects.house_type
|
||
LEFT JOIN deal_type deal_type on deal_type.id = sale_objects.deal_type
|
||
LEFT JOIN rayon rayon on objects.rayon = rayon.id
|
||
LEFT JOIN land_usage_type lu on objects.land_usage_type_id = lu.id
|
||
LEFT JOIN land_purpose lp on objects.land_purpose_id = lp.id
|
||
LEFT JOIN electricity_type el on objects.electricity_type_id = el.id
|
||
LEFT JOIN gas_type gt on objects.gas_type_id = gt.id
|
||
LEFT JOIN plumbing_type pt on objects.plumbing_type_id = pt.id
|
||
LEFT JOIN sewerage_type st on objects.sewerage_type_id = st.id
|
||
LEFT JOIN relief_type rt on objects.relief_type_id = rt.id
|
||
LEFT JOIN shape_type sht on objects.shape_type_id = sht.id
|
||
LEFT JOIN objects_additional_information on objects_additional_information.object_id = objects.id
|
||
LEFT JOIN bath_type on bath_type.id = objects.bath_type_id
|
||
LEFT JOIN window_view on window_view.id = objects_additional_information.window_view
|
||
LEFT JOIN renovation on renovation.id = objects_additional_information.renovation
|
||
LEFT JOIN hot_water on hot_water.id = objects.hot_water_id
|
||
LEFT JOIN parking_type on parking_type.id = objects.parking_type_id
|
||
WHERE objects.id = $get[id]";
|
||
|
||
$rez_obj = mysql_query($sql3);
|
||
$obj = mysql_fetch_assoc($rez_obj);
|
||
|
||
$content['title'] = "Аренда без комиссии - ".$obj['nazv']." по адресу: г. Санкт-Петербург, ".$obj['rayon']." район, ".$obj['adres'];
|
||
|
||
require($_SERVER['DOCUMENT_ROOT']."/templates/new-header.php");
|
||
|
||
$user = new User;
|
||
$user->get($_SESSION['id']);
|
||
|
||
$favor = array();
|
||
$sql = "SELECT id FROM objects WHERE id in (SELECT id_obj FROM favor WHERE id_user = $_SESSION[id])";
|
||
$rez = mysql_query($sql);
|
||
while ($f = mysql_fetch_assoc($rez)) {
|
||
$favor[] = $f['id'];
|
||
}
|
||
|
||
if (isset($_SESSION['notes_bd_usl'])) {
|
||
$notes_bd_usl = $_SESSION['notes_bd_usl'];
|
||
} else {
|
||
$agencyId = User::getAgencyIdForUser($_SESSION['id']);
|
||
|
||
$usersIds = User::getAllAgencyUsers($agencyId);
|
||
$usersIds[] = $_SESSION['id'];
|
||
$usersIds = array_unique($usersIds);
|
||
$notes_bd_usl = "created_by IN (" . implode(",", $usersIds) . ")";
|
||
$_SESSION['notes_bd_usl'] = $notes_bd_usl;
|
||
}
|
||
|
||
$sqlAddInfo = "SELECT activity_id FROM objects_activities WHERE object_id=$obj[id]";
|
||
$rezAddInfo = mysql_query($sqlAddInfo);
|
||
if (mysql_num_rows($rezAddInfo) > 0) {
|
||
$obj['activities'] = array();
|
||
while($row = mysql_fetch_array($rezAddInfo)) {
|
||
$obj['activities'][] = $row['activity_id'];
|
||
}
|
||
} else {
|
||
$obj['activities'] = null;
|
||
}
|
||
|
||
/** GET PLAN */
|
||
$plan = '';
|
||
$sqlP = "SELECT * FROM objects_plan WHERE object_id = $get[id]";
|
||
$rez_plan = mysql_query($sqlP);
|
||
if(mysql_num_rows($rez_plan) > 0){
|
||
$obj_plan = mysql_fetch_assoc($rez_plan);
|
||
if($obj_plan['img_plan'] != ''){
|
||
if (stripos($obj_plan['img_plan'], "http://") === false && stripos($obj_plan['img_plan'], "https://") === false) {
|
||
$obj_plan['img_plan'] = "https://joywork.ru/photos/" . $obj_plan['img_plan'];
|
||
}
|
||
|
||
$plan = $obj_plan['img_plan'];
|
||
}
|
||
}
|
||
|
||
$sqlPhotoInfo = "SELECT oop.sort_order, p.photo FROM objects_object_photo oop, object_photo p WHERE p.id = oop.object_photo_id AND oop.object_id = $get[id] ORDER BY oop.sort_order";
|
||
$rezPhotoInfo = mysql_query($sqlPhotoInfo);
|
||
|
||
if (mysql_num_rows($rezPhotoInfo) > 0) {
|
||
while ($photoInfo = mysql_fetch_assoc($rezPhotoInfo)) {
|
||
$obj['photo' . $photoInfo['sort_order']] = $photoInfo['photo'];
|
||
}
|
||
}
|
||
|
||
|
||
?>
|
||
<script type="text/javascript" src="/js/core.js"></script>
|
||
<script type="text/javascript" src="/js/popup.js"></script>
|
||
<script type="text/javascript" src="/js/likely.js"></script>
|
||
<script type="text/javascript" src="/js/ajax-form.js"></script>
|
||
<script type="text/javascript" src="/js/show-phone.js"></script>
|
||
<script type="text/javascript" src="/js/fotorama.js"></script>
|
||
<script type="text/javascript">
|
||
setTimeout(function(){
|
||
var elem = document.createElement('script');
|
||
elem.type = 'text/javascript';
|
||
elem.src = 'https://api-maps.yandex.ru/2.1/?load=package.standard&apikey=692f0a05-cb88-4158-88b9-06bc0dc93004&lang=ru_RU&onload=getYaMap';
|
||
document.getElementsByTagName('body')[0].appendChild(elem);
|
||
}, 500);
|
||
|
||
function getYaMap(){
|
||
// Создание карты.
|
||
var myMap = new ymaps.Map("map_canvas", {
|
||
center: [59.9174455,30.3250575],
|
||
zoom: 19,
|
||
controls: ['fullscreenControl', 'zoomControl']
|
||
});
|
||
|
||
var address = $('#shortAddress').text();
|
||
|
||
if (address.indexOf('Санкт-Петербург') < 0) {
|
||
address = 'Санкт-Петербург, ' +address;
|
||
}
|
||
|
||
ymaps.geocode(address, {results: 1})
|
||
.then(function (res) {
|
||
var firstGeoObject = res.geoObjects.get(0),
|
||
// Координаты геообъекта.
|
||
coords = firstGeoObject.geometry.getCoordinates(),
|
||
// Область видимости геообъекта.
|
||
bounds = firstGeoObject.properties.get('boundedBy');
|
||
|
||
firstGeoObject.options.set('preset', 'islands#darkBlueDotIconWithCaption');
|
||
// Получаем строку с адресом и выводим в иконке геообъекта.
|
||
firstGeoObject.properties.set('iconCaption', firstGeoObject.getAddressLine());
|
||
|
||
// Добавляем первый найденный геообъект на карту.
|
||
myMap.geoObjects.add(firstGeoObject);
|
||
// Масштабируем карту на область видимости геообъекта.
|
||
myMap.setBounds(bounds, {
|
||
// Проверяем наличие тайлов на данном масштабе.
|
||
checkZoomRange: true
|
||
});
|
||
});
|
||
}
|
||
|
||
</script>
|
||
<div class="content-right">
|
||
<div class="inner">
|
||
<?php
|
||
//Доп обработка
|
||
|
||
if(!$obj['etazh']) $obj['etazh']=Filter::getFloorFromName($obj['nazv'],true);
|
||
else Filter::getFloorFromName($obj['nazv'],true);
|
||
|
||
if(!$obj['etazh_iz']) $obj['etazh_iz']=Filter::getMaxFloorFromName($obj['nazv'],true);
|
||
else Filter::getMaxFloorFromName($obj['nazv'],true);
|
||
|
||
Filter::getSpaceFromName($obj['nazv'],true);
|
||
$obj['nazv']=Filter::name($obj['nazv']);
|
||
Filter::getSpaceFromName($obj['nazv'],true);
|
||
|
||
|
||
|
||
$obj['sobstv'] = Filter::replaceSobstv($obj['sobstv']);
|
||
|
||
$photo = "";
|
||
for($num=1;$num<=20;$num++) if($obj['photo'.$num]) { $photo = $obj['photo'.$num]; break; } // and is_file($_SERVER['DOCUMENT_ROOT']."/photos/".$obj['photo'.$num]) and filesize($_SERVER['DOCUMENT_ROOT']."/photos/".$obj['photo'.$num]) > 0
|
||
?>
|
||
<div class="main-title">
|
||
<h1>Объект <?php echo $obj['id']; ?></h1>
|
||
</div>
|
||
<?php
|
||
|
||
$showForManagerOrBoss = false;
|
||
// проверяем, нуждно ли показывать объект начальству
|
||
if ($obj['id_add_user'] > 0 && ($_SESSION['agency'] == 1 || $_SESSION['manager'] == 1)) {
|
||
$agentsOfAgency = User::getAllAgents($_SESSION['id']);
|
||
|
||
$found = false;
|
||
|
||
foreach ($agentsOfAgency as $agent) {
|
||
if ($agent['id'] == $obj['id_add_user']) {
|
||
$found = true;
|
||
}
|
||
}
|
||
|
||
if (!$found) {
|
||
$agentsOfManager = User::getAllManagers($_SESSION['id']);
|
||
foreach ($agentsOfManager as $agent) {
|
||
if ($agent['id'] == $obj['id_add_user']) {
|
||
$found = true;
|
||
}
|
||
}
|
||
}
|
||
|
||
if ($found) {
|
||
$showForManagerOrBoss = true;
|
||
}
|
||
}
|
||
|
||
if ($obj['archive'] || ($obj['id_add_user'] > 0 && $obj['id_add_user'] == $_SESSION['id']) || $showForManagerOrBoss) {
|
||
?>
|
||
<div class="jw__page__tabs">
|
||
<a href="javascript:{}" data-id="<?php echo $obj['id']; ?>" class="tab pseudo-link add-event-full">
|
||
<span>Задачи</span>
|
||
</a>
|
||
<a href="javascript:{}" data-id="<?php echo $obj['id']; ?>" class="tab pseudo-link add-note">
|
||
<span>Примечания</span>
|
||
</a>
|
||
|
||
<?php if (!$obj['archive'] && $obj['use_in_advert'] == 0) { ?>
|
||
<!--<a href="javascript:{}" data-id="<?php /*echo $obj['id']; */?>" class="tab pseudo-link refreshMyObject">
|
||
<span>Обновить</span>
|
||
</a>-->
|
||
<?php } ?>
|
||
<a href="javascript:{}" data-adduser="<?=$obj['id_add_user']?>" data-object="<?php echo $obj['id']; ?>" class="tab pseudo-link add_client_new">
|
||
<span>Создать заявку</span>
|
||
</a>
|
||
</div>
|
||
<?php } ?>
|
||
<div class="f-object">
|
||
<div class="f-object_row fr_fotorama">
|
||
<div class="photos">
|
||
<?php
|
||
if($photo =="")
|
||
echo '';
|
||
else {
|
||
?>
|
||
<div class="f-fotorama backgrounded">
|
||
<div class="fotorama" data-width="100%" data-height="450px" data-allowfullscreen="true" data-nav="thumbs" data-thumb-height="32">
|
||
<?php
|
||
for($num=1;$num<=40;$num++)
|
||
if(isset($obj['photo'.$num]) && $obj['photo'.$num])
|
||
{
|
||
if(stripos($obj['photo'.$num],"http://") === false && stripos($obj['photo'.$num],"https://") === false) {
|
||
$obj['photo'.$num] = "/photos/".$obj['photo'.$num];
|
||
}
|
||
|
||
echo '<img src="'.$obj['photo'.$num].'" height="450px">';
|
||
|
||
}
|
||
?>
|
||
<? if($plan != '') echo '<img src="'.$plan.'" height="450px">';?>
|
||
</div>
|
||
</div>
|
||
<? } ?>
|
||
</div>
|
||
</div>
|
||
<div class="f-object_row fr__room" style="overflow: visible;">
|
||
<div class="object-info top">
|
||
<?php
|
||
$sqlCommetc = "SELECT * FROM commercial_object";
|
||
$qCommerc = mysql_query($sqlCommetc);
|
||
$arrTypeCommerc = array();
|
||
while($rCommerc = mysql_fetch_assoc($qCommerc)){
|
||
$arrTypeCommerc[$rCommerc['id']] = $rCommerc['name'];
|
||
}
|
||
?>
|
||
<h2><?php echo Filter::name($obj['nazv']); ?>
|
||
<?php
|
||
if($obj['type']==4 && isset($arrTypeCommerc[$obj['type_category']])){
|
||
echo '<br>Категория помещения – '.$arrTypeCommerc[$obj['type_category']];
|
||
}
|
||
?>
|
||
<label>
|
||
<input type="checkbox" onclick="to_favor(<?php echo $obj['id']; ?>);" id="favorite<?php echo $obj['id']; ?>" class="favorite-input" <?php if($favor) if(in_array($obj['id'],$favor)) echo 'checked'; ?>>
|
||
<span class="ti-heart <?php if($favor) if(in_array($obj['id'],$favor)) echo 'active'; ?>" id="favorite-star<?php echo $obj['id']; ?>"></span>
|
||
</label>
|
||
|
||
<span class="tooltip tooltip-effect">
|
||
|
||
<label>
|
||
|
||
<input type="checkbox" class="form-control to_send_input" id="to_send<?php echo $obj['id']; ?>">
|
||
|
||
<span class="fr-btn edit-btn steel i-btn to_send <?php if(@in_array($obj['id'],$_SESSION['to_send'])) echo "active"; ?> tooltip-item" id="to_send_button<?php echo $obj['id']; ?>" data-id="<?php echo $obj['id']; ?>"><i class="get_pdf" title="К отправке">.pdf</i></span>
|
||
|
||
</label>
|
||
|
||
<span class="tooltip-content tt-pdf clear"><b class="tooltip-text">В презентации</b></span>
|
||
|
||
</span>
|
||
|
||
<span class="tooltip tooltip-effect">
|
||
|
||
|
||
|
||
</span>
|
||
|
||
<?php if(!$obj['id_add_user']) { ?>
|
||
<span class="tooltip tooltip-effect ">
|
||
<label class="fl-right label-view">
|
||
<span data-id="<?php echo $obj['id']; ?>" class="fr-btn edit-btn steel i-btn tooltip-item addComplaint">
|
||
<i class="ti-announcement"></i>
|
||
</span>
|
||
<span class="tooltip-content tt-hide clear"><b class="tooltip-text">Жалоба</b></span>
|
||
</label>
|
||
</span>
|
||
|
||
<?php if(!empty($user->vk_token)) { ?>
|
||
<span class="tooltip tooltip-effect ">
|
||
<label class="fl-right label-view">
|
||
<span data-id="<?php echo $obj['id']; ?>" class="fr-btn edit-btn steel i-btn tooltip-item addVkPost">
|
||
<i class="get_pdf">Вк</i>
|
||
</span>
|
||
<span class="tooltip-content clear"><b class="tooltip-text">Пост в ВК</b></span>
|
||
</label>
|
||
</span>
|
||
<?php } ?>
|
||
<?php } ?>
|
||
|
||
<?php if (!empty($photo) && !$obj['id_add_user']) { ?>
|
||
|
||
<span class="tooltip tooltip-effect">
|
||
|
||
<label class="fl-right label-view">
|
||
|
||
<span class="fr-btn edit-btn steel i-btn download-photo tooltip-item" <?php echo "' data-id='$obj[id]'"; ?>>
|
||
|
||
<i class="ti-download"></i>
|
||
|
||
</span>
|
||
|
||
<span class="tooltip-content tt-pdf clear"><b class="tooltip-text">Скачать фотографии</b></span>
|
||
|
||
</label>
|
||
|
||
</span>
|
||
|
||
<?php }
|
||
|
||
if (empty($notes_bd_usl))
|
||
$notes_bd_usl = ' true';
|
||
|
||
$sql_count_notes = "SELECT COUNT(*) FROM object_notes WHERE object_id = $obj[id] AND $notes_bd_usl";
|
||
$obj['notes'] = mysql_result(mysql_query($sql_count_notes),0);
|
||
|
||
?>
|
||
<span class="tooltip tooltip-effect ">
|
||
<label class="fl-right label-view">
|
||
<span class="fr-btn edit-btn steel i-btn tooltip-item addEditNote<?= (($obj['notes']) ? ' haveNotes' : ''); ?>" data-id="<?php echo $obj['id']; ?>">
|
||
<i class="ti-pencil-alt"></i>
|
||
</span>
|
||
<span class="tooltip-content clear"><b class="tooltip-text">Примечания по объекту</b></span>
|
||
</label>
|
||
</span>
|
||
<span class="tooltip tooltip-effect ">
|
||
<label class="fl-right label-view">
|
||
<span class="fr-btn edit-btn steel i-btn tooltip-item actionJW tasks add-event" data-id="<?php echo $obj['id']; ?>">
|
||
<i class="get_pdf">Задачи</i>
|
||
</span>
|
||
<span class="tooltip-content clear"><b class="tooltip-text">Задачи по объекту</b></span>
|
||
</label>
|
||
</span>
|
||
<?php if (isset($user)) {
|
||
if ($user->can('autosearch')) { ?>
|
||
<span class="tooltip tooltip-effect ">
|
||
<label class="fl-right label-view">
|
||
<div class="fr-btn edit-btn steel i-btn tooltip-item actionJW tasks fltr-req-list" title="Заявки типа «Подбор объекта»" data-id="<?php echo $obj['id']; ?>">
|
||
Автопоиск
|
||
<?php
|
||
$autosearch = new AutoSearch();
|
||
$requisitions = $autosearch->reverseSearch($obj['id'], 0, 100, false, true, true, true);
|
||
if ($requisitions['total'] > 0) : ?>
|
||
<span class="counter"><?= $requisitions['total']; ?></span>
|
||
<?php endif; ?>
|
||
</div>
|
||
</label>
|
||
</span>
|
||
<?php }
|
||
} ?>
|
||
<?php
|
||
|
||
$sql_count_objects = "SELECT COUNT(*) FROM favor WHERE id_obj = $obj[id] AND id_user = $_SESSION[id]";
|
||
$obj_my_count = mysql_result(mysql_query($sql_count_objects),0);
|
||
|
||
if ($obj_my_count) : ?>
|
||
<span class="tooltip tooltip-effect">
|
||
<label class="fl-right label-view">
|
||
<span class="fr-btn edit-btn steel i-btn tooltip-item actionJW add_from_archive" data-id="<?php echo $obj['id']; ?>">
|
||
<i class="get_pdf">В мои объекты</i>
|
||
</span>
|
||
<span class="tooltip-content clear"><b class="tooltip-text">Добавить в мои объекты</b></span>
|
||
</label>
|
||
</span>
|
||
<?php endif; ?>
|
||
|
||
<?php if ($obj['ads_url'] && $obj['ads_source'] && !$obj['archive']) {
|
||
$sourceLink = $obj['ads_url'];
|
||
$sourceName = "";
|
||
if ($obj['ads_source'] == 3)
|
||
$sourceName = "Яндекс";
|
||
|
||
if ($obj['ads_source'] == 1)
|
||
$sourceName = "Авито";
|
||
|
||
if ($obj['ads_source'] == 4)
|
||
$sourceName = "Циан";
|
||
|
||
if ($obj['ads_source'] == 6)
|
||
$sourceName = "Юла";
|
||
|
||
if ($obj['ads_source'] == 2)
|
||
$sourceName = "Из рук в руки";
|
||
|
||
if ($obj['ads_source'] == 5)
|
||
$sourceName = "SOB.RU";
|
||
|
||
if ($obj['ads_source'] == 7)
|
||
$sourceName = "N1.RU";
|
||
|
||
if ($obj['ads_source'] == 10)
|
||
$sourceName = "Моя реклама";
|
||
|
||
if ($sourceLink && $sourceName) {
|
||
?>
|
||
<span style="padding-left: 6px;font-size: 18px !important;">
|
||
<a href="<?= $sourceLink; ?>" target="_blank" title="Источник добавления: <?= $sourceName; ?>"><?= $sourceName; ?></a>
|
||
</span>
|
||
<?php
|
||
}
|
||
} ?>
|
||
|
||
<div class="preloader" style="right: 200px;"></div>
|
||
</h2>
|
||
<div class="top-info">
|
||
<?php if ($obj['operation_type'] == 0) {?>
|
||
<div class="period">
|
||
<i class="ti-time"></i>Сдается <?php echo $SROK_ARENDY["$obj[srok]"]; ?><?php if ($obj['prim_srok']) echo " (".$obj['prim_srok'].")"; ?>
|
||
</div>
|
||
<?php
|
||
} else {
|
||
if ($obj['operation_type'] == 1) { ?>
|
||
<div class="period">
|
||
<i class="ti-time"></i>Продается
|
||
</div>
|
||
<?php
|
||
}
|
||
}
|
||
|
||
if ($obj['activities']) {
|
||
$tags = [];
|
||
$sql_adv = "SELECT * FROM `activities` WHERE `user_id` = '".$user->id."' OR `manager_id` = '".$user->id."'";
|
||
if ($user->id_manager)
|
||
$sql_adv .= " OR `manager_id` = '".$user->id_manager."' or `user_id` = '".$user->id_manager."'";
|
||
|
||
if ($user->agencyId)
|
||
$sql_adv .= " OR `manager_id` = '".$user->agencyId."' or `user_id` = '".$user->agencyId."'";
|
||
|
||
$sql_adv .= ' ORDER BY `name`';
|
||
$q_adv = mysql_query($sql_adv);
|
||
$rows_adv = mysql_num_rows($q_adv);
|
||
if ($rows_adv > 0) {
|
||
while ($r_adv = mysql_fetch_assoc($q_adv)) {
|
||
if (in_array($r_adv['id'], $obj['activities']))
|
||
$tags[] = '<span data-id="' . $r_adv['id'] . '">' . $r_adv['name'] . '</span>';
|
||
|
||
}
|
||
|
||
if (!empty($tags)) { ?>
|
||
<div class="tags" title="Теги: <?= strip_tags(implode(', ', $tags)); ?>">
|
||
<i class="ti-tag"></i> <?= implode(', ', $tags); ?>
|
||
</div>
|
||
<?php }
|
||
}
|
||
}
|
||
|
||
if (!$obj['archive']) {
|
||
?>
|
||
|
||
<div class="date" style="padding-top: 0;">
|
||
<i class="ti-calendar"></i><span>
|
||
<?php
|
||
list($dateAdd, $timeAdd) = explode(" ", $obj['date_add']);
|
||
list($d, $m, $y) = explode(".", $dateAdd);
|
||
|
||
$date_add = $d." ".getRusMonth($m)." ".$y;
|
||
$date = $date_add." ".$timeAdd;
|
||
echo $date;
|
||
?></span>
|
||
</div>
|
||
|
||
<?php } ?>
|
||
</div>
|
||
<div class="middle-info">
|
||
<div class="f-map">
|
||
<div class="bg-map"></div>
|
||
<div class="address">
|
||
<i class="ti-location-pin"></i>
|
||
<?php
|
||
$sqlLocationInfo = "SELECT * FROM object_location WHERE object_id=".$obj[id];
|
||
$rezLocationInfo = mysql_query($sqlLocationInfo);
|
||
|
||
if (mysql_num_rows($rezLocationInfo) > 0) {
|
||
$objLocationInfo = mysql_fetch_assoc($rezLocationInfo);
|
||
echo '<span class="adress_map">' . $objLocationInfo['address'] . "</span>\r\n";
|
||
} else {
|
||
?>
|
||
<span class="adress_map">
|
||
<?php
|
||
|
||
$sql = "SELECT * FROM rayon WHERE id in (select rayon from objects where id = $obj[id])";
|
||
$result = mysql_query($sql);
|
||
if ($result) {
|
||
$rayon = mysql_fetch_assoc($result);
|
||
}
|
||
|
||
// if ((isset($rayon) && $rayon['is_lo'] == 1) ||
|
||
// (isset($obj['lo_city_id']) && $obj['lo_city_id'] > 0)) {
|
||
// echo "Ленинградская область";
|
||
// } else {
|
||
// echo "Санкт-Петербург";
|
||
// }
|
||
|
||
if ($obj['id_rf_region'] == 50) {
|
||
if(is_bool(strpos($obj['adres'], "Ленинградская область"))){
|
||
echo "Ленинградская область,";
|
||
}
|
||
}else if($obj['id_rf_region'] == 81){
|
||
echo "Санкт Петербург,";
|
||
} else if($obj['id_rf_region'] == 77) {
|
||
$sqlRegion = "SELECT parent.name as parent,rf_regions.name FROM rf_regions as parent
|
||
LEFT JOIN rf_regions on rf_regions.parent = parent.id
|
||
LEFT JOIN rf_region_rayons ON rf_region_rayons.rf_region_id = rf_regions.id
|
||
WHERE rayon_id in (select rayon from objects where id = $obj[id])";
|
||
$rezRegion = mysql_query($sqlRegion);
|
||
if($rezRegion){
|
||
$region = mysql_fetch_assoc($rezRegion);
|
||
echo $region['parent'].','.$region['name'].' округ,';
|
||
}
|
||
}/*else{
|
||
$sqlRegion = "SELECT rf_regions.name FROM rf_regions
|
||
LEFT JOIN rf_region_rayons ON rf_region_rayons.rf_region_id = rf_regions.id
|
||
WHERE rayon_id in (select rayon from objects where id = $obj[id])";
|
||
$rezRegion = mysql_query($sqlRegion);
|
||
if($rezRegion){
|
||
$region = mysql_fetch_assoc($rezRegion);
|
||
echo $region['name'];
|
||
}
|
||
}*/
|
||
|
||
|
||
?>
|
||
<?php
|
||
if($obj['rayon'] && $obj['id_rf_region'] == 81){
|
||
if (strpos($obj['rayon'], "район") or strpos($obj['adres'], "район") or strpos($obj['adres'], "р-н")) {
|
||
echo $obj['rayon'].',';
|
||
} else {
|
||
echo $obj['rayon'] . " район,";
|
||
}
|
||
}
|
||
?>
|
||
<?php
|
||
echo str_replace('г. Санкт-Петербург, ', '', $obj['adres']);
|
||
if ($obj['dom']) {
|
||
echo ", " . $obj['dom'];
|
||
}
|
||
if ($obj['korpus']) {
|
||
echo ", корпус " . $obj['korpus'];
|
||
}
|
||
if ($obj['litera']) {
|
||
echo ", литера " . $obj['litera'];
|
||
} ?>
|
||
|
||
</span>
|
||
<?php } ?>
|
||
<span id="scrollMap" style="display: none"><i class="ti-map-alt"></i><span>на карте</span></span>
|
||
<span id="shortAddress" style="display: none"><?php echo $obj['adres']; if ($obj['dom']) {echo ", " . $obj['dom'];} if ($obj['korpus']) {echo ", корпус " . $obj['korpus'];} if ($obj['litera']) {echo ", литера " . $obj['litera'];} ?></span>
|
||
</div>
|
||
<div class="object-subway">
|
||
<span><?php
|
||
$mtr = array();
|
||
$sql = "SELECT metro.metro FROM metro, sp_metro
|
||
WHERE sp_metro.id_metro = metro.id AND sp_metro.id_obj = $obj[id]";
|
||
$result = mysql_query($sql);
|
||
while($m = mysql_fetch_row($result)) $mtr[] = $m[0];
|
||
echo implode(", ",$mtr);
|
||
?></span>
|
||
<span><?php
|
||
if($obj['peshkom']) echo $obj['peshkom']." минут пешком";
|
||
if($obj['peshkom'] and $obj['transport']) echo " или ";
|
||
if($obj['transport']) echo $obj['transport']." минут на транспорте";
|
||
?>
|
||
</span>
|
||
</div>
|
||
</div>
|
||
<div class="price">
|
||
<p class="biglin">Цена:</p>
|
||
<h1><?php echo number_format($obj['stoim'], 0, ',', ' ').'<span class="rub">p</span>'.($obj['operation_type'] == 1 ? "<br/>": "").'<span'.($obj['operation_type'] == 0 && $obj['type'] == 7 ? " style='display:none;'": "").($obj['operation_type'] == 1 ? " style='font-size:24px;'": "").'>'.$obj['stoim_prim']; ?></span></h1>
|
||
</div>
|
||
<div class="number">
|
||
<div class="inner" style="float:left;">
|
||
<p class="biglin">Телефон:</p>
|
||
<h1><?php
|
||
if(stripos($obj['phone'],"*")) echo "<a href='javascript:void();' class='getArchPhone' data-id='$obj[id]' style='text-decoration:underline;'>$obj[phone]</a>";
|
||
else echo "$obj[phone]"; ?>
|
||
</h1>
|
||
<div class='name' style="width:200px;"><?php echo $obj['sobstv']; ?></div>
|
||
</div>
|
||
<?php if(strlen($obj['fbn_id'])>0){?>
|
||
<div>
|
||
<img src="/images/logo_arsp.PNG" width="100" style="margin:40px;">
|
||
</div>
|
||
<?php } ?>
|
||
</div>
|
||
<div class="clear"></div>
|
||
<div class="square">
|
||
<p class="biglin">Общая информация:</p>
|
||
<div class="columns">
|
||
<?php
|
||
if ($obj['type'] == 7) {
|
||
if ($obj['land_area'] * 1 != 0) {
|
||
echo '<div class="info-label">Площадь:</div>';
|
||
echo '<div class="info-value">' . $obj['land_area'] * 1;
|
||
echo ' соток</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['land_usage_name']) {
|
||
echo '<div class="info-label">Использование земли:</div>';
|
||
echo '<div class="info-value">' . $obj['land_usage_name'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['land_purpose']) {
|
||
echo '<div class="info-label">Назначение земли:</div>';
|
||
echo '<div class="info-value">' . $obj['land_purpose'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['electricity_type']) {
|
||
echo '<div class="info-label">Электроснабжение:</div>';
|
||
echo '<div class="info-value">' . $obj['electricity_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['gas_type']) {
|
||
echo '<div class="info-label">Газификация:</div>';
|
||
echo '<div class="info-value">' . $obj['gas_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['plumbing_type']) {
|
||
echo '<div class="info-label">Водоснабжение:</div>';
|
||
echo '<div class="info-value">' . $obj['plumbing_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['sewerage_type']) {
|
||
echo '<div class="info-label">Канализация:</div>';
|
||
echo '<div class="info-value">' . $obj['sewerage_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['relief_type']) {
|
||
echo '<div class="info-label">Рельеф:</div>';
|
||
echo '<div class="info-value">' . $obj['relief_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['shape_type']) {
|
||
echo '<div class="info-label">Форма участка:</div>';
|
||
echo '<div class="info-value">' . $obj['shape_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['land_distance'] * 1 != 0) {
|
||
echo '<div class="info-label">Удаленность от города, райцентра (км):</div>';
|
||
echo '<div class="info-value">' . $obj['land_distance'] * 1;
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
echo '<div class="info-label">Есть обременения:</div>';
|
||
echo '<div class="info-value">' . ($obj['land_burden'] ? "Да" : "Нет");
|
||
echo '</div><div class="clear"></div>';
|
||
|
||
} else {
|
||
if ($obj['type'] == 3 || $obj['type'] == 5) {
|
||
if ($obj['land_usage_name']) {
|
||
echo '<div class="info-label">Использование земли:</div>';
|
||
echo '<div class="info-value">' . $obj['land_usage_name'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['land_purpose']) {
|
||
echo '<div class="info-label">Назначение земли:</div>';
|
||
echo '<div class="info-value">' . $obj['land_purpose'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['electricity_type']) {
|
||
echo '<div class="info-label">Электроснабжение:</div>';
|
||
echo '<div class="info-value">' . $obj['electricity_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['gas_type']) {
|
||
echo '<div class="info-label">Газификация:</div>';
|
||
echo '<div class="info-value">' . $obj['gas_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['plumbing_type']) {
|
||
echo '<div class="info-label">Водоснабжение:</div>';
|
||
echo '<div class="info-value">' . $obj['plumbing_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['sewerage_type']) {
|
||
echo '<div class="info-label">Канализация:</div>';
|
||
echo '<div class="info-value">' . $obj['sewerage_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['relief_type']) {
|
||
echo '<div class="info-label">Рельеф:</div>';
|
||
echo '<div class="info-value">' . $obj['relief_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['shape_type']) {
|
||
echo '<div class="info-label">Форма участка:</div>';
|
||
echo '<div class="info-value">' . $obj['shape_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if ($obj['land_distance'] * 1 != 0) {
|
||
echo '<div class="info-label">Удаленность от города, райцентра (км):</div>';
|
||
echo '<div class="info-value">' . $obj['land_distance'] * 1;
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
echo '<div class="info-label">Есть обременения:</div>';
|
||
echo '<div class="info-value">' . ($obj['land_burden'] ? "Да" : "Нет");
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if ($obj['ploshad'] * 1 != 0) {
|
||
echo '<div class="info-label">Общая площадь:</div>';
|
||
echo '<div class="info-value">' . $obj['ploshad'] * 1;
|
||
echo 'м<sup>2</sup></div><div class="clear"></div>';
|
||
}
|
||
if ($obj['ploshad_komn'] * 1 != 0) {
|
||
echo '<div class="info-label">Площадь комнат:</div>';
|
||
echo '<div class="info-value">' . $obj['ploshad_komn'];
|
||
echo 'м<sup>2</sup></div><div class="clear"></div>';
|
||
}
|
||
if ($obj['ploshad_k'] * 1 != 0) {
|
||
echo '<div class="info-label">Площадь кухни:</div>';
|
||
echo '<div class="info-value">' . $obj['ploshad_k'] * 1;
|
||
echo 'м<sup>2</sup></div><div class="clear"></div>';
|
||
}
|
||
if ($obj['type_category'] == 6) {
|
||
echo '<div class="info-label">Всего этажей:</div>';
|
||
if ($obj['etazh_iz'] * 1 != 0) {
|
||
echo '<div class="info-value">' . $obj['etazh_iz'];
|
||
|
||
}
|
||
echo '</div>';
|
||
} else {
|
||
if ($obj['etazh'] * 1 != 0) {
|
||
echo '<div class="info-label">Этаж:</div>';
|
||
if ((int)$obj['etazh'] == 1 && $obj['etaz_first_type'] > 0) {
|
||
echo '<div class="info-value">' . $etaz_first_types[$obj['etaz_first_type']];
|
||
} else {
|
||
echo '<div class="info-value">' . $obj['etazh'];
|
||
}
|
||
if ($obj['etazh_iz'] * 1 != 0) echo " из " . $obj['etazh_iz'];
|
||
echo '</div>';
|
||
}
|
||
if ($obj['prepay'] != 0) {
|
||
echo '<div class="info-label">Предоплата:</div>';
|
||
echo '<div class="info-value">' . $obj['prepay'] . ' месяц(ев)</div>';
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
}
|
||
}
|
||
if($obj['operation_type'] == 1 && $obj['deal_type'])
|
||
{
|
||
echo '<div class="info-label">Тип сделки:</div>';
|
||
echo '<div class="info-value">'.$obj['deal_type_name'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['operation_type'] == 1 && $obj['deal_type'] == 6 && $obj['sale_type']) // 6 - Новостройка
|
||
{
|
||
$sale_type = "Не указан";
|
||
switch ($obj['sale_type']) {
|
||
case "dupt" :
|
||
$sale_type = "Договор уступки права требования";
|
||
break;
|
||
|
||
case "dzhsk" :
|
||
$sale_type = "Договор ЖСК";
|
||
break;
|
||
|
||
case "free" :
|
||
$sale_type = "Свободная продажа";
|
||
break;
|
||
|
||
case "fz214" :
|
||
$sale_type = "214-ФЗ";
|
||
break;
|
||
|
||
case "investment" :
|
||
$sale_type = "Договор инвестирования";
|
||
break;
|
||
|
||
case "pdkp" :
|
||
$sale_type = "Предварительный договор купли-продажи";
|
||
break;
|
||
|
||
}
|
||
echo '<div class="info-label">Тип продажи:</div>';
|
||
echo '<div class="info-value">'.$sale_type;
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['operation_type'] == 1 && $obj['commission'])
|
||
{
|
||
echo '<div class="info-label">Комиссия встречному агенту:</div>';
|
||
echo '<div class="info-value">'.$obj['commission'].'% - '.(floatval($obj['commission'])*intval($obj['stoim'])/100)." руб.";
|
||
echo ' </div><div class="clear"></div>';
|
||
|
||
}else if($obj['operation_type'] == 1 && $obj['lease']){
|
||
echo '<div class="info-label">Комиссия встречному агенту:</div>';
|
||
echo '<div class="info-value">'.round((intval($obj['lease'])*100/intval($obj['stoim'])),2).'% - '.$obj['lease']." руб.";
|
||
echo ' </div><div class="clear"></div>';
|
||
|
||
|
||
}
|
||
if($obj['ceiling_height'] && $obj['ceiling_height'] != 0){
|
||
echo '<div class="info-label">Высота потолков:</div>';
|
||
echo '<div class="info-value">'.$obj['ceiling_height']." м.";
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['bath_type']){
|
||
echo '<div class="info-label">Тип ванны:</div>';
|
||
echo '<div class="info-value">'.$obj['bath_type'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['window_view']){
|
||
echo '<div class="info-label">Вид из окон:</div>';
|
||
echo '<div class="info-value">'.$obj['window_view'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['balcony']){
|
||
echo '<div class="info-label">Кол-во балконов:</div>';
|
||
echo '<div class="info-value">'.$obj['balcony'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['loggias']){
|
||
echo '<div class="info-label">Кол-во лоджий:
|
||
</div>';
|
||
echo '<div class="info-value">'.$obj['loggias'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['type'] == 4){
|
||
if($obj['layout_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `layout_object` WHERE id = ".$obj['layout_id']))['name'];
|
||
echo '<div class="info-label">Планировка:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['number_wet_spots']){
|
||
|
||
echo '<div class="info-label">Кол-во мокрых точек:
|
||
</div>';
|
||
echo '<div class="info-value">'.$obj['number_wet_spots'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['electricity_power']){
|
||
echo '<div class="info-label">Электрическая мощность:
|
||
</div>';
|
||
echo '<div class="info-value">'.$obj['electricity_power']. ' кВТ ';
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commer_condition']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commer_condition` WHERE id = ".$obj['commer_condition']))['name'];
|
||
echo '<div class="info-label">Состояние:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['isFurniture']){
|
||
echo '<div class="info-label">Мебель:
|
||
</div>';
|
||
echo '<div class="info-value"> есть';
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['parking_type_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `parking_type` WHERE id = ".$obj['parking_type_id']))['name'];
|
||
echo '<div class="info-label">Тип парковки:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['parking_price']){
|
||
echo '<div class="info-label">Стоимость парковки:
|
||
</div>';
|
||
echo '<div class="info-value">'.$obj['parking_price'];
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['vat_type_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `vat_type` WHERE id = ".$obj['vat_type_id']))['name'];
|
||
echo '<div class="info-label">Налог:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['floor_material_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `floor_material` WHERE id = ".$obj['floor_material_id']))['name'];
|
||
echo '<div class="info-label">Материал пола:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_portal_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_portal` WHERE id = ".$obj['commerc_portal_id']))['name'];
|
||
echo '<div class="info-label">Ворота:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_purpose']){
|
||
|
||
echo '<div class="info-label">Назначение:</div>';
|
||
$commerc_purpose = json_decode($obj['commerc_purpose']);
|
||
if(!empty($commerc_purpose)){
|
||
$sql = "SELECT * FROM commerc_purpose WHERE id in (".implode(',',$commerc_purpose).")";
|
||
$q = mysql_query($sql);
|
||
$i=0;
|
||
echo '<div class="info-value">';
|
||
while($r = mysql_fetch_assoc($q)){
|
||
|
||
if($i>0) echo ",";
|
||
if($i % 2 == 0) echo "<br>";
|
||
echo ' '.$r['name'];
|
||
|
||
$i++;
|
||
}
|
||
}
|
||
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
}
|
||
?>
|
||
</div>
|
||
</div>
|
||
<?php if ($obj['type'] == 4) {?>
|
||
<div class="square">
|
||
<p class="biglin">О Здании :</p>
|
||
<div class="columns">
|
||
<?php
|
||
if($obj['building_nazv'])
|
||
{
|
||
echo '<div class="info-label">Название:</div>';
|
||
echo '<div class="info-value"> '.$obj['building_nazv'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_year'])
|
||
{
|
||
echo '<div class="info-label">Год постройки:</div>';
|
||
echo '<div class="info-value"> '.$obj['commerc_year'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_building_type_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_building_type` WHERE id = ".$obj['commerc_building_type_id']))['name'];
|
||
echo '<div class="info-label">Тип здания:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_building_class_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_building_class` WHERE id = ".$obj['commerc_building_class_id']))['name'];
|
||
echo '<div class="info-label">Класс здания:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['building_area'])
|
||
{
|
||
echo '<div class="info-label">Площадь здания:</div>';
|
||
echo '<div class="info-value"> '.$obj['building_area']. ' м. кв';
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_houseLineType_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_houselinetype` WHERE id = ".$obj['commerc_houseLineType_id']))['name'];
|
||
echo '<div class="info-label">Линия домов:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_building_category_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_building_category` WHERE id = ".$obj['commerc_building_category_id']))['name'];
|
||
echo '<div class="info-label">Категория:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['building_developer'])
|
||
{
|
||
echo '<div class="info-label">Девелопер:</div>';
|
||
echo '<div class="info-value"> '.$obj['building_developer'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['building_management_company'])
|
||
{
|
||
echo '<div class="info-label">Управляющая компания:</div>';
|
||
echo '<div class="info-value"> '.$obj['building_management_company'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
|
||
if($obj['commerc_opened_id']){
|
||
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_opened` WHERE id = ".$obj['commerc_opened_id']))['name'];
|
||
echo '<div class="info-label">Вход:
|
||
</div>';
|
||
echo '<div class="info-value">'.$name;
|
||
echo ' </div><div class="clear"></div>';
|
||
}
|
||
if($obj['commerc_building_ventilation'])
|
||
{
|
||
$arr = array(1=>'Естественная', 2=>'Приточная');
|
||
echo '<div class="info-label">Вентиляция:</div>';
|
||
echo '<div class="info-value"> '.$arr[$obj['commerc_building_ventilation']];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['commerc_building_conditioning'])
|
||
{
|
||
$arr = array(1=>'Местное', 2=>'Центральное');
|
||
echo '<div class="info-label">Кондиционирование:</div>';
|
||
echo '<div class="info-value"> '.$arr[$obj['commerc_building_conditioning']];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['commerc_building_heating'])
|
||
{
|
||
$arr = array(1=>'Автономное', 2=>'Центральное');
|
||
echo '<div class="info-label">Отопление:</div>';
|
||
echo '<div class="info-value"> '.$arr[$obj['commerc_building_heating']];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['commerc_building_fire'])
|
||
{
|
||
$arr = array(1=>'Гидрантная', 2=>'Спринклерная', 3=>'Порошковая', 4=>'Газовая', 5=>'Сигнализация');
|
||
echo '<div class="info-label">Система пожаротушения:</div>';
|
||
echo '<div class="info-value"> '.$arr[$obj['commerc_building_fire']];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['commerc_infrastructure']){
|
||
echo '<div>';
|
||
echo '<div class="info-label">Инфраструктура:</div>';
|
||
$commerc_infrastructure = json_decode($obj['commerc_infrastructure']);
|
||
if(!empty($commerc_infrastructure)){
|
||
$sql = "SELECT * FROM commerc_infrastructure WHERE id in (".implode(',',$commerc_infrastructure).")";
|
||
$q = mysql_query($sql);
|
||
$i=0;
|
||
echo '<div class="info-value">';
|
||
while($r = mysql_fetch_assoc($q)){
|
||
|
||
if($i>0) echo ",";
|
||
if($i % 2 == 0) echo "<br>";
|
||
echo ' '.$r['name'];
|
||
|
||
$i++;
|
||
}
|
||
}
|
||
|
||
echo '</div><div class="clear"></div>';
|
||
echo '</div>';
|
||
}
|
||
?>
|
||
</div>
|
||
</div>
|
||
<?php } ?>
|
||
<?php if ($obj['operation_type'] == 1 && $obj['type'] != 7 && $obj['type'] != 4) {?>
|
||
<div class="square">
|
||
<p class="biglin">Информация о доме:</p>
|
||
<div class="columns">
|
||
<?php
|
||
if($obj['house_material'])
|
||
{
|
||
echo '<div class="info-label">Материал:</div>';
|
||
echo '<div class="info-value"> '.$obj['house_material_name'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['house_type'])
|
||
{
|
||
echo '<div class="info-label">Тип:</div>';
|
||
echo '<div class="info-value"> '.$obj['house_type_name'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['build_year'])
|
||
{
|
||
echo '<div class="info-label">Год постройки:</div>';
|
||
echo '<div class="info-value"> '.$obj['build_year'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['hot_water'])
|
||
{
|
||
echo '<div class="info-label">Обеспечение горячей водой:</div>';
|
||
echo '<div class="info-value"> '.$obj['hot_water'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['separate_wcs'])
|
||
{
|
||
echo '<div class="info-label">Кол-во раздельных санузлов:
|
||
</div>';
|
||
echo '<div class="info-value"> '.$obj['separate_wcs'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['combined_wcs'])
|
||
{
|
||
echo '<div class="info-label">Кол-во совместных санузлов:
|
||
</div>';
|
||
echo '<div class="info-value"> '.$obj['combined_wcs'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['passenger_lifts'])
|
||
{
|
||
echo '<div class="info-label">Кол-во пассажирских лифтов:
|
||
|
||
</div>';
|
||
echo '<div class="info-value"> '.$obj['passenger_lifts'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['cargo_lifts'])
|
||
{
|
||
echo '<div class="info-label">Кол-во грузовых лифтов:
|
||
|
||
</div>';
|
||
echo '<div class="info-value"> '.$obj['cargo_lifts'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
if($obj['parking_type'])
|
||
{
|
||
echo '<div class="info-label">Тип парковки:
|
||
|
||
</div>';
|
||
echo '<div class="info-value"> '.$obj['parking_type'];
|
||
echo '</div><div class="clear"></div>';
|
||
}
|
||
?>
|
||
</div>
|
||
</div>
|
||
<?php } ?>
|
||
<?php if ($obj['operation_type'] == 0 && $obj['type'] != 7 && $obj['type'] != 4) {?>
|
||
<div class="have">
|
||
<div class="inner">
|
||
<p class="biglin">Удобства:</p>
|
||
<ul>
|
||
<?php
|
||
if($obj['stirka']) echo '<li><span class="tooltip tooltip-effect"><div class="icon"><img src="/images/washing-click.png" class="icon" height="36px"></div>стиральная машина<span class="tooltip-content" style="width:auto;"><b class="tooltip-text">стиральная машина</b></span></span></li>';
|
||
if($obj['holod']) echo '<li><span class="tooltip tooltip-effect"><div class="icon"><img src="/images/refregerator-click.png" class="icon" height="36px"></div><b>холодильник</b><span class="tooltip-content" style="width:auto;"><b class="tooltip-text">холодильник</b></span></span></li>';
|
||
if($obj['tv']) echo '<li class="tv"><span class="tooltip tooltip-effect"><div class="icon"><img src="/images/television-click.png" class="icon" height="36px"></div>телевизор<span class="tooltip-content" style="width:auto;"><b class="tooltip-text">телевизор</b></span></span></li>';
|
||
if($obj['mebel']) echo '<li><span class="tooltip tooltip-effect"><div class="icon"><img src="/images/furniture-click.png" class="icon" height="36px"></div>мебель<span class="tooltip-content" style="width:auto;"><b class="tooltip-text">мебель</b></span></span></li>';
|
||
?>
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
<?php } ?>
|
||
<?php
|
||
$user = new User;
|
||
if ($agency_id = User::getUserAgencyID()) {
|
||
$sql = "SELECT `fields`.`id` AS `id`,
|
||
`fields`.`name` AS `name`,
|
||
`fields`.`type` AS `type`,
|
||
`fields`.`title` AS `title`,
|
||
`fields`.`params` AS `params`,
|
||
`data`.`value` AS `value`
|
||
FROM `object_data` AS `data`
|
||
LEFT JOIN `object_fields` AS `fields` ON `data`.`field_id` = `fields`.`id`
|
||
WHERE `data`.`object_id`='$obj[id]' AND
|
||
`fields`.`agency_id`='$agency_id' AND
|
||
`fields`.`is_active`='1'
|
||
ORDER BY `fields`.`order`";
|
||
|
||
$query = mysql_query($sql);
|
||
if (mysql_num_rows($query)) { ?>
|
||
<div class="square description">
|
||
<p class="biglin">Дополнительная информация:</p>
|
||
<div class="columns">
|
||
<?php while ($row = mysql_fetch_assoc($query)) {
|
||
if (isset($row['value'])) {
|
||
$field_name = $row['name'];
|
||
$field_title = $row['title'];
|
||
if ($row['type'] == 2 || $row['type'] == 3) {
|
||
$values = json_decode($row['value']);
|
||
$params = json_decode($row['params'], true);
|
||
|
||
if (count($values) > 0) {
|
||
$values_str = '';
|
||
foreach ($values as $value) {
|
||
foreach ($params['items'] as $item) {
|
||
if ($item['value'] == $value) {
|
||
if (!empty($values_str))
|
||
$values_str .= ", " . $item['name'];
|
||
else
|
||
$values_str .= $item['name'];
|
||
}
|
||
}
|
||
}
|
||
|
||
if (!empty($values_str)) {
|
||
echo '<div class="info-label">'. $row['title'].':</div>';
|
||
echo '<div class="info-value">'. $values_str .'</div>';
|
||
echo '<div class="clear"></div>';
|
||
}
|
||
}
|
||
} else if ($row['type'] == 4) {
|
||
echo '<div class="info-label">'. $row['title'].':</div>';
|
||
echo '<div class="info-value">'. ((boolval($row['value'])) ? 'Да' : 'Нет') .'</div>';
|
||
echo '<div class="clear"></div>';
|
||
} else {
|
||
echo '<div class="info-label">'. $row['title'].':</div>';
|
||
echo '<div class="info-value">'. $row['value'] .'</div>';
|
||
echo '<div class="clear"></div>';
|
||
}
|
||
}
|
||
} ?>
|
||
</div>
|
||
</div>
|
||
<?php }
|
||
} ?>
|
||
<div class="clear"></div>
|
||
<div class="description">
|
||
<p class="biglin">Описание:</p>
|
||
<p style="overflow-x: auto;"><?php echo cleanHtml($obj['opis']); ?></p>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<div class="f_object-row">
|
||
<div class="f-object_left">
|
||
<div class="on-map" style="">
|
||
<?php echo '<div id="map_canvas" style="width:100%; height:440px"></div>'; ?>
|
||
</div>
|
||
</div>
|
||
<div class="f-object_right">
|
||
</div>
|
||
<div class="clear"></div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<div class="f__modal-bg" id="modalArch_bg" style="display: none; ">
|
||
|
||
<div class="f__modal login" id="modalArch" style="display: none; width:1170px;">
|
||
|
||
<span class="pseudo-link closer">×</span>
|
||
|
||
<h3>Найденные соответствия в архиве</h3>
|
||
|
||
<div id="objectsArch"></div>
|
||
|
||
<div class="clear"></div>
|
||
|
||
</div>
|
||
|
||
</div>
|
||
<?php include($_SERVER['DOCUMENT_ROOT']."/templates/footer.php"); ?>
|