Joywork/object.php

1284 lines
76 KiB
PHP
Raw Permalink Normal View History

2026-05-22 20:21:54 +02:00
<?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 "&nbsp;(".$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."&nbsp;&nbsp;".$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 '&nbsp;</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 '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['bath_type']){
echo '<div class="info-label">Тип ванны:</div>';
echo '<div class="info-value">'.$obj['bath_type'];
echo '&nbsp;</div><div class="clear"></div>';
}
if($obj['window_view']){
echo '<div class="info-label">Вид из окон:</div>';
echo '<div class="info-value">'.$obj['window_view'];
echo '&nbsp;</div><div class="clear"></div>';
}
if($obj['balcony']){
echo '<div class="info-label">Кол-во балконов:</div>';
echo '<div class="info-value">'.$obj['balcony'];
echo '&nbsp;</div><div class="clear"></div>';
}
if($obj['loggias']){
echo '<div class="info-label">Кол-во лоджий:
</div>';
echo '<div class="info-value">'.$obj['loggias'];
echo '&nbsp;</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 '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['electricity_power']){
echo '<div class="info-label">Электрическая мощность:
</div>';
echo '<div class="info-value">'.$obj['electricity_power']. ' кВТ ';
echo '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['isFurniture']){
echo '<div class="info-label">Мебель:
</div>';
echo '<div class="info-value"> есть';
echo '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['parking_price']){
echo '<div class="info-label">Стоимость парковки:
</div>';
echo '<div class="info-value">'.$obj['parking_price'];
echo '&nbsp;</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 '&nbsp;</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 '&nbsp;</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 '&nbsp;</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 '&nbsp;'.$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">&nbsp;'.$obj['building_nazv'];
echo '</div><div class="clear"></div>';
}
if($obj['commerc_year'])
{
echo '<div class="info-label">Год постройки:</div>';
echo '<div class="info-value">&nbsp;'.$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 '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['building_area'])
{
echo '<div class="info-label">Площадь здания:</div>';
echo '<div class="info-value">&nbsp;'.$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 '&nbsp;</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 '&nbsp;</div><div class="clear"></div>';
}
if($obj['building_developer'])
{
echo '<div class="info-label">Девелопер:</div>';
echo '<div class="info-value">&nbsp;'.$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">&nbsp;'.$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 '&nbsp;</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">&nbsp;'.$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">&nbsp;'.$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">&nbsp;'.$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">&nbsp;'.$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 '&nbsp;'.$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">&nbsp;'.$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">&nbsp;'.$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">&nbsp;'.$obj['build_year'];
echo '</div><div class="clear"></div>';
}
if($obj['hot_water'])
{
echo '<div class="info-label">Обеспечение горячей водой:</div>';
echo '<div class="info-value">&nbsp;'.$obj['hot_water'];
echo '</div><div class="clear"></div>';
}
if($obj['separate_wcs'])
{
echo '<div class="info-label">Кол-во раздельных санузлов:
</div>';
echo '<div class="info-value">&nbsp;'.$obj['separate_wcs'];
echo '</div><div class="clear"></div>';
}
if($obj['combined_wcs'])
{
echo '<div class="info-label">Кол-во совместных санузлов:
</div>';
echo '<div class="info-value">&nbsp;'.$obj['combined_wcs'];
echo '</div><div class="clear"></div>';
}
if($obj['passenger_lifts'])
{
echo '<div class="info-label">Кол-во пассажирских лифтов:
</div>';
echo '<div class="info-value">&nbsp;'.$obj['passenger_lifts'];
echo '</div><div class="clear"></div>';
}
if($obj['cargo_lifts'])
{
echo '<div class="info-label">Кол-во грузовых лифтов:
</div>';
echo '<div class="info-value">&nbsp;'.$obj['cargo_lifts'];
echo '</div><div class="clear"></div>';
}
if($obj['parking_type'])
{
echo '<div class="info-label">Тип парковки:
</div>';
echo '<div class="info-value">&nbsp;'.$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"); ?>