Joywork/cabinet.php

1751 lines
131 KiB
PHP
Raw Permalink Normal View History

2026-05-22 20:21:54 +02:00
<?php
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
//ini_set('display_errors', 1);
//error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
$pdo = new MysqlPdo(hst, ndb, user, pass);
$sql = "SET NAMES 'utf8'";
$pdo->query($sql);
$get=clearInputData($_GET);
$cabinet = null;
$user = null;
$obj = null;
if ($get['token']) {
$cabinetSql = "SELECT * FROM object_cabinet WHERE MD5(id)='$get[token]'";
$rezCabinet = mysql_query($cabinetSql);
$cabinet = mysql_fetch_assoc($rezCabinet);
}
$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, 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,
object_prices.currency as currency
FROM objects objects
LEFT JOIN sale_objects sale_objects on objects.id = sale_objects.object_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 object_prices on object_prices.object_id = objects.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 = $cabinet[object_id]";
$rez_obj = mysql_query($sql3);
$obj = mysql_fetch_assoc($rez_obj);
$user = new User;
$user->get($obj['id_add_user']);
$gmtmsk = get_time_zone_user($obj['id_add_user']);
$time_zone = '';
if($gmtmsk >= 0){
$time_zone = '+'.$gmtmsk.' hour';
} else {
$time_zone = '-'.$gmtmsk.' hour';
}
if (!isset($user->agencyId)) {
$user->agencyId = $user->id;
$user->agencyName = $user->agency_name;
$user->fio = trim($user->last_name . ' ' . $user->first_name . ' ' . $user->middle_name);
}
if ($user->agency == 1) {
$user->agencyName = $user->agency_name;
$user->fio = trim($user->last_name . ' ' . $user->first_name . ' ' . $user->middle_name);
}
/** GET PLAN */
$plan = '';
$sqlP = "SELECT * FROM objects_plan WHERE object_id = $cabinet[object_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'];
}
}
/** Get video */
$video = ''; $obj_video = [];
$sqlV = "SELECT video_url, video_url_vk FROM objects_additional_information WHERE object_id = $cabinet[object_id]";
$rez_video = mysql_query($sqlV);
if(mysql_num_rows($rez_video) > 0){
$obj_video = mysql_fetch_assoc($rez_video);
$video_url = explode('/', $obj_video["video_url"]);
$video = $video_url[count($video_url) - 1];
}
/** Get correct video links for 'Rutube' and m.b. etc. */
$video_link = $obj_video["video_url"]; $vhost_name = 'undef';
$video_link_vk = $obj_video["video_url_vk"];
function get_vhost_name($video_link = '') { // : string
$vhost_list = [
'youtube.com',
'youtu.be',
'rutube.ru',
// 'ok.ru',
'vk.com',
'vkvideo.ru',
'.', // must be for another undef video hosting
];
for ($loft = 0; $loft <= count($vhost_list) - 1; $loft++) {
$vh_needle = $vhost_list[$loft];
$host_pos = strpos($video_link, $vh_needle);
if ( ( ($host_pos) && ($host_pos > 0) ) || ( $host_pos === 0 ) ) { break; }
}
switch ($vh_needle) {
case 'youtu.be':
case 'youtube.com' : $vhost_name = 'youtube'; break;
case 'rutube.ru' : $vhost_name = 'rutube'; break;
// case 'ok.ru' : $vhost_name = 'classmates'; break;
case 'vkvideo.ru' :
case 'vk.com' : $vhost_name = 'vkontakte'; break;
// case '.' : $vhost_name = 'vhost'; break; // is another undef video hosting
default: $vhost_name = 'undef';
}
return $vhost_name;
}
$video_hash = '';
function get_video_hash($video_link = '') { // : string
$embed_pos = strpos($video_link, 'video/') ?: strpos($video_link, 'embed/');
return $embed_pos ? substr($video_link, $embed_pos + 6) : '';
}
function get_vk_video_hash($video_link_vk = '') { // : string
$pattern = '/video(-?\d+)_(\d+)/i';
if (preg_match($pattern, $video_link_vk, $matches)) {
$owner_id = $matches[1]; // содержит -140502045
$video_id = $matches[2]; // содержит 456239096
return [$owner_id, $video_id];
} else {
return[null, null];
}
}
$vhost_name = get_vhost_name($video_link);
if ($vhost_name === 'undef') {
$vhost_name = get_vhost_name($video_link_vk);
}
if ( ($vhost_name == 'youtube') || ($vhost_name == 'rutube') ) { $video_hash = get_video_hash($video_link); }
$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 = $cabinet[object_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'];
}
}
//Доп обработка
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']);
$currency = 'p';
if(isset($obj['currency'])){
if((int)$obj['currency'] == 1) {
$currency = '$';
}
else if((int)$obj['currency'] == 2){
$currency = '€';
}
else if((int)$obj['currency'] == 3){
$currency = '₼';
}
}
$site = $user->site == 'http://' ? $user->sitename : $user->site;
if (strpos($site, "http") === false) {
$site = 'http://'.$site;
}
function showProperty($name, $value) {
echo '<div class="about__info-section-field"><span class="cmn__text cmn__light">' . $name . ':</span><span class="cmn__text cmn__main">' . $value .'</span></div>';
}
?>
<!DOCTYPE html>
<html lang="ru">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="description" content="Cabinet page">
<link rel="shortcut icon" type="image/x-icon" href="/images/favicon.ico" />
<meta name="keywords" content="">
<title>JoyWork.ru</title>
<link rel="preload" href="cabinet/fonts/latoregular.woff" as="font" type="font/woff" crossorigin="crossorigin">
<link rel="stylesheet" href="cabinet/css/styles.min.css">
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
</head>
<body class="cmn">
<div style="display:none"><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><defs>
<clipPath id="clip0_146_842">
<rect width="18" height="18" fill="white"></rect>
</clipPath>
</defs><symbol id="icon-calendar" viewBox="0 0 18 18">
<path d="M14.5248 1.38619H13.8534V0.706821C13.8534 0.318658 13.5387 0.00400925 13.1506 0.00400925C12.7624 0.00400925 12.4477 0.318658 12.4477 0.706821V1.38619H5.55221V0.706821C5.55221 0.318658 5.23757 0.00400925 4.8494 0.00400925C4.46124 0.00400925 4.14659 0.318658 4.14659 0.706821V1.38619H3.47523C1.55898 1.38619 0 2.94517 0 4.86139V14.5208C0 16.437 1.55898 17.996 3.47523 17.996H14.5248C16.441 17.996 18 16.437 18 14.5208V4.86139C18 2.94517 16.441 1.38619 14.5248 1.38619ZM3.47523 2.79182H4.14659V4.1623C4.14659 4.55046 4.46124 4.86511 4.8494 4.86511C5.23757 4.86511 5.55221 4.55046 5.55221 4.1623V2.79182H12.4478V4.1623C12.4478 4.55046 12.7624 4.86511 13.1506 4.86511C13.5388 4.86511 13.8534 4.55046 13.8534 4.1623V2.79182H14.5248C15.666 2.79182 16.5944 3.72023 16.5944 4.86139V5.53278H1.40562V4.86139C1.40562 3.72023 2.33404 2.79182 3.47523 2.79182ZM14.5248 16.5904H3.47523C2.33404 16.5904 1.40562 15.6619 1.40562 14.5208V6.93841H16.5944V14.5208C16.5944 15.6619 15.666 16.5904 14.5248 16.5904ZM6.24333 9.70281C6.24333 10.091 5.92868 10.4056 5.54051 10.4056H4.15833C3.77016 10.4056 3.45552 10.091 3.45552 9.70281C3.45552 9.31465 3.77016 9 4.15833 9H5.54051C5.92864 9 6.24333 9.31465 6.24333 9.70281ZM14.5445 9.70281C14.5445 10.091 14.2299 10.4056 13.8417 10.4056H12.4595C12.0714 10.4056 11.7567 10.091 11.7567 9.70281C11.7567 9.31465 12.0714 9 12.4595 9H13.8417C14.2298 9 14.5445 9.31465 14.5445 9.70281ZM10.3899 9.70281C10.3899 10.091 10.0753 10.4056 9.6871 10.4056H8.30492C7.91676 10.4056 7.60211 10.091 7.60211 9.70281C7.60211 9.31465 7.91676 9 8.30492 9H9.6871C10.0752 9 10.3899 9.31465 10.3899 9.70281ZM6.24333 13.8494C6.24333 14.2376 5.92868 14.5522 5.54051 14.5522H4.15833C3.77016 14.5522 3.45552 14.2376 3.45552 13.8494C3.45552 13.4612 3.77016 13.1466 4.15833 13.1466H5.54051C5.92864 13.1466 6.24333 13.4612 6.24333 13.8494ZM14.5445 13.8494C14.5445 14.2376 14.2299 14.5522 13.8417 14.5522H12.4595C12.0714 14.5522 11.7567 14.2376 11.7567 13.8494C11.7567 13.4612 12.0714 13.1466 12.4595 13.1466H13.8417C14.2298 13.1466 14.5445 13.4612 14.5445 13.8494ZM10.3899 13.8494C10.3899 14.2376 10.0753 14.5522 9.6871 14.5522H8.30492C7.91676 14.5522 7.60211 14.2376 7.60211 13.8494C7.60211 13.4612 7.91676 13.1466 8.30492 13.1466H9.6871C10.0752 13.1466 10.3899 13.4612 10.3899 13.8494Z" fill="#757575"></path>
</symbol><symbol id="icon-coins" viewBox="0 0 14 14">
<path d="M4.95866 13.4167C5.65876 13.4209 6.35272 13.286 7.00033 13.02C7.64725 13.2883 8.34168 13.4232 9.042 13.4167C11.1682 13.4167 12.8337 12.2821 12.8337 10.8331V8.41694C12.8337 6.96793 11.1682 5.83335 9.042 5.83335C8.94341 5.83335 8.84658 5.83802 8.75033 5.84327V3.11093C8.75033 1.69168 7.08491 0.583344 4.95866 0.583344C2.83241 0.583344 1.16699 1.69168 1.16699 3.11093V10.8891C1.16699 12.3084 2.83241 13.4167 4.95866 13.4167ZM11.667 10.8331C11.667 11.5034 10.589 12.25 9.042 12.25C7.495 12.25 6.41699 11.5034 6.41699 10.8331V10.2935C7.20696 10.774 8.1176 11.019 9.042 10.9999C9.96639 11.019 10.877 10.774 11.667 10.2935V10.8331ZM9.042 7.00002C10.589 7.00002 11.667 7.74668 11.667 8.41694C11.667 9.08719 10.589 9.83327 9.042 9.83327C7.495 9.83327 6.41699 9.0866 6.41699 8.41694C6.41699 7.74727 7.495 7.00002 9.042 7.00002ZM4.95866 1.75001C6.50566 1.75001 7.58366 2.46751 7.58366 3.11093C7.58366 3.75435 6.50566 4.47243 4.95866 4.47243C3.41166 4.47243 2.33366 3.75493 2.33366 3.11093C2.33366 2.46693 3.41166 1.75001 4.95866 1.75001ZM2.33366 4.94785C3.12691 5.41894 4.03627 5.6584 4.95866 5.6391C5.88105 5.6584 6.79041 5.41894 7.58366 4.94785V6.02585C6.94792 6.18609 6.36489 6.50917 5.89199 6.96327C5.58529 7.02964 5.27246 7.06366 4.95866 7.06477C3.41166 7.06477 2.33366 6.34727 2.33366 5.70385V4.94785ZM2.33366 7.54077C3.12708 8.01139 4.03636 8.25063 4.95866 8.23144C5.06249 8.23144 5.16283 8.2186 5.26491 8.21335C5.25622 8.28088 5.25135 8.34885 5.25033 8.41694V9.63319C5.15233 9.63902 5.05783 9.65769 4.95866 9.65769C3.41166 9.65769 2.33366 8.94019 2.33366 8.29619V7.54077ZM2.33366 10.1331C3.12691 10.6042 4.03627 10.8437 4.95866 10.8244C5.05666 10.8244 5.15291 10.8168 5.25033 10.8121V10.8331C5.25868 11.3297 5.4495 11.8058 5.78641 12.1707C5.51348 12.2222 5.23641 12.2488 4.95866 12.25C3.41166 12.25 2.33366 11.5325 2.33366 10.8891V10.1331Z" fill="white"></path>
</symbol><symbol id="icon-metro" viewBox="0 0 20 20">
<path d="M13.242 2.24766L9.99989 12.4689L6.75798 2.24766C2.90144 3.57323 0 7.16914 0 11.2916C0 13.7746 1.01298 16.0644 2.65178 17.752H7.35212L7.84488 15.6151C2.22957 13.4149 3.29134 6.59717 5.32701 5.48429C5.56864 5.55695 9.10942 17.7017 9.10942 17.7017C9.15779 17.7017 9.31493 17.7017 9.50692 17.7017C9.54747 17.7017 9.70018 17.7017 9.89048 17.7017C9.95934 17.7017 10.0337 17.7017 10.1091 17.7017C10.2384 17.7017 10.3725 17.7017 10.4924 17.7017C10.6846 17.7017 10.8416 17.7017 10.8902 17.7017C10.8902 17.7017 14.4311 5.55695 14.6726 5.48429C16.7085 6.59717 17.7698 13.4149 12.1545 15.6151L12.6475 17.752H17.3478C18.9868 16.0644 19.9998 13.7746 19.9998 11.2916C19.9998 7.16914 17.0983 3.57323 13.242 2.24766Z" fill="#8EB3F5"></path>
</symbol><symbol id="icon-view" viewBox="0 0 18 18">
<g clip-path="url(#clip0_146_842)">
<path d="M17.8969 8.69829C16.3916 5.52928 12.9688 2.67188 8.96485 2.67188C4.45963 2.67188 1.22127 6.19616 0.0328217 8.69829C-0.0578156 8.88918 -0.0578156 9.11083 0.0328217 9.30172C1.53809 12.4707 4.96088 15.3281 8.96485 15.3281C13.4701 15.3281 16.7084 11.8037 17.8969 9.30172C17.9875 9.11083 17.9875 8.88918 17.8969 8.69829ZM8.96485 13.9219C5.72553 13.9219 3.03978 11.7871 1.46434 9.00001C3.03319 6.22431 5.71729 4.07813 8.96485 4.07813C12.2039 4.07813 14.8899 6.21263 16.4654 9.00001C14.8965 11.7756 12.2124 13.9219 8.96485 13.9219ZM8.96485 5.48438C7.02631 5.48438 5.44922 7.06147 5.44922 9.00001C5.44922 10.9385 7.02631 12.5156 8.96485 12.5156C10.9034 12.5156 12.4805 10.9385 12.4805 9.00001C12.4805 7.06147 10.9034 5.48438 8.96485 5.48438ZM8.96485 11.1094C7.80181 11.1094 6.85548 10.163 6.85548 9.00001C6.85548 7.83683 7.80181 6.89063 8.96485 6.89063C10.128 6.89063 11.0742 7.83683 11.0742 9.00001C11.0742 10.163 10.128 11.1094 8.96485 11.1094Z"></path>
</g>
</symbol></svg>
</div>
<header class="header">
<div class="cmn__container header__container">
<div class="header__info">
<?php if ($user->photo) {?>
<img class="header__logo" src="<?php if ($user->photo) { echo "/photos/agency/" . $user->photo; } else { echo ""; }?>" alt="логотип" width="117" height="100">
<?php } ?>
<div class="contacts">
<span class="cmn__text cmn__text--small cmn__main">Агентство недвижимости<br><?php echo $user->agencyName;?></span>
<?php if($user->site && $user->sitename) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="<?php echo $site;?>"><?php echo $user->sitename;?></a>
<?php } ?>
<?php if($user->email) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="mailto:<?php echo $user->email; ?>"><?php echo $user->email; ?></a>
<?php } ?>
<a class="cmn__text cmn__text--info cmn__main" href="tel:<?php echo $user->phoneAgency; ?>"><?php echo $user->phoneAgency; ?></a>
</div>
</div>
<div class="header__user">
<div class="user">
<?php if ($user->user_logo) {?>
<img src="<?php echo "/photos/agency/" . $user->user_logo; ?>" alt="аватар" width="100" height="100">
<?php } ?>
<div class="user__info"><span class="cmn__text cmn__text--small cmn__gray">Ваш агент</span>
<span class="cmn__text cmn__text--small cmn__main"><?php echo $user->fio; ?></span>
<?php if($user->email) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="mailto:<?php echo $user->email; ?>"><?php echo $user->email; ?></a>
<? } ?>
<?php if($user->phone) {?>
<a class="cmn__text cmn__text--info cmn__main" href="tel:<?php echo $user->phone;?>"><?php echo $user->phone;?></a></div>
<?php } ?>
</div>
</div>
</div>
</header>
<main>
<section class="cabinet">
<div class="cmn__container">
<div class="cabinet__container">
<h1 class="visually-hidden">Агентство недвижимости <?php echo $user->agencyName;?>. Презентация объекта</h1>
<div class="cabinet__header">
<div class="cabinet__section cabinet__section--slider">
<div class="slider">
<div class="swiper-container apartment-slider">
<div class="swiper-wrapper">
<?php
for ($num = 1; $num <= 40; $num++) {
if ($num == 2) {
if($plan != '') {
echo '<div class="swiper-slide"><img src="'.$plan.'" alt="планировка объекта"></div>';
}
if ($vhost_name == 'youtube') {
?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://www.youtube.com/embed/<?php echo $video; ?>"
title="YouTube video player"
frameborder="0"
allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share"
referrerpolicy="strict-origin-when-cross-origin"
allowfullscreen
></iframe>
</div>
<?php } ?>
<?php if ($vhost_name == 'rutube') { ?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://rutube.ru/play/embed/<?php echo $video_hash; ?>"
frameBorder="0"
allow="clipboard-write; autoplay"
webkitAllowFullScreen
mozallowfullscreen
allowFullScreen
></iframe>
</div>
<?php } ?>
<?php if ($vhost_name == 'vkontakte') {
$vk_video_params = get_vk_video_hash($video_link_vk);
if ($vk_video_params[0] != null) {
?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://vkvideo.ru/video_ext.php?oid=<?php echo $vk_video_params[0]; ?>&id=<?php echo $vk_video_params[1]; ?>"
frameBorder="0"
allow="autoplay; encrypted-media; fullscreen; picture-in-picture; screen-wake-lock;"
webkitAllowFullScreen
mozallowfullscreen
allowFullScreen
></iframe>
</div>
<?php
}
}
}
if ($obj['photo' . $num]) {
if (stripos($obj['photo' . $num], "http") === false && stripos($obj['photo' . $num], "https://") === false) {
$obj['photo' . $num] = "/photos/" . $obj['photo' . $num];
}
echo '<div class="swiper-slide"><a href="' . $obj['photo' . $num] . '" target="_blank"><img src="' . $obj['photo' . $num] . '" alt="фото объекта"></a></div>';
}
}
?>
</div>
<div class="swiper-button-prev apartment-slider-button-prev"> </div>
<div class="swiper-button-next apartment-slider-button-next"></div>
</div>
<div class="swiper-container apartment-slider-thumbs">
<div class="swiper-wrapper">
<?php
for ($num = 1; $num <= 40; $num++) {
if ($num == 2) {
if($plan != '') {
echo '<div class="swiper-slide"><img src="'.$plan.'" alt="планировка объекта"></div>';
}
if ($vhost_name == 'youtube') { ?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://www.youtube.com/embed/<?php echo $video; ?>"
title="YouTube video player"
frameborder="0"
allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share"
referrerpolicy="strict-origin-when-cross-origin"
allowfullscreen
></iframe>
</div>
<?php } ?>
<?php if ($vhost_name == 'rutube') { ?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://rutube.ru/play/embed/<?php echo $video_hash; ?>"
frameBorder="0"
allow="clipboard-write; autoplay"
webkitAllowFullScreen
mozallowfullscreen
allowFullScreen
></iframe>
</div>
<?php } ?>
<?php if ($vhost_name == 'vkontakte') {
$vk_video_params = get_vk_video_hash($video_link_vk);
if ($vk_video_params[0] != null) {
?>
<div class="swiper-slide">
<iframe
width="100%" height="100%"
src="https://vkvideo.ru/video_ext.php?oid=<?php echo $vk_video_params[0]; ?>&id=<?php echo $vk_video_params[1]; ?>"
frameBorder="0"
allow="autoplay; encrypted-media; fullscreen; picture-in-picture; screen-wake-lock;"
webkitAllowFullScreen
mozallowfullscreen
allowFullScreen
></iframe>
</div>
<?php }
}
}
if ($obj['photo' . $num]) {
echo '<div class="swiper-slide"><img src="' . $obj['photo' . $num] . '" alt="фото объекта"></div>';
}
}
?>
</div>
</div>
</div>
</div>
<div class="cabinet__section cabinet__section--about">
<div class="about">
<div class="about__header">
<h2 class="cmn__title"><?php echo Filter::name($obj['nazv']); ?></h2>
<div class="about__header-section">
<div class="about__header-date">
<svg width="18" height="18">
<use xlink:href="#icon-calendar"></use>
</svg><span class="cmn__text cmn__text--small cmn__light"><?php
list($dateAdd, $timeAdd) = explode(" ", date('d.m.Y H:i', strtotime($time_zone, strtotime($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><span class="cmn__text cmn__text--small cmn__light"><?php
if ($obj['operation_type'] == 0) {
echo "Сдается" . $SROK_ARENDY["$obj[srok]"];
if ($obj['prim_srok']) echo "&nbsp;(".$obj['prim_srok'].")";
} else {
if ($obj['operation_type'] == 1) {
echo "Продается";
}
}
?></span>
</div>
<div class="about__header-section">
<address class="cmn__text cmn__text--med cmn__main"><?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 $objLocationInfo['address'];
} else {
$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 ($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'].' округ,';
}
}
?>
<?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'];
}
} ?></address>
</div>
<?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];
?>
<div class="about__header-section about__header-section--position">
<div class="about__header-position">
<?php if (count($mtr) > 0) { ?>
<svg width="20" height="20">
<use xlink:href="#icon-metro"></use>
</svg><?php } ?><span class="cmn__text cmn__text--small cmn__extra"><?php
echo implode(", ",$mtr);
?></span>
</div><span class="cmn__text cmn__text--small cmn__light"><?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="about__content">
<div class="about__content-section"><span class="cmn__text cmn__text--info cmn__light">Цена:</span><span class="cmn__text cmn__text--info-large cmn__main"><?php echo number_format($obj['stoim'], 0, ',', ' '); ?> <?=$currency?></span>
<?php if ($obj['stoim_prim']) { ?>
<div class="about__content-badge">
<svg width="14" height="14">
<use xlink:href="#icon-coins"></use>
</svg><span class="cmn__text cmn__text--small"><?php echo $obj['stoim_prim']; ?></span>
</div>
<?php } ?>
</div>
<div class="about__content-section"><span class="cmn__text cmn__text--info cmn__light">Телефон:</span><a class="cmn__text cmn__text--info-large cmn__main" href="tel:<?php if ($user != null) { echo $user->phone;} else { echo $obj['phone'];} ?>"><?php if ($user != null) { echo $user->phone;} else { echo $obj['phone'];} ?></a><span class="cmn__text cmn__text--small cmn__light"><?php if ($user != null) { echo trim($user->last_name . ' ' . $user->first_name . ' ' . $user->middle_name); } else { echo $obj['sobstv']; } ?></span></div>
</div>
<div class="about__info">
<div class="about__info-section">
<div class="about__info-section-top"><span class="cmn__text cmn__text--med cmn__main">Общая информация:</span></div>
<?php
if($obj['type']==4 && isset($arrTypeCommerc[$obj['type_category']])){
showProperty('Категория помещения',$arrTypeCommerc[$obj['type_category']]);
}
if ($obj['type'] == 7) {
showProperty('Общая площадь', $obj['land_area'] * 1 . ' соток');
if ($obj['land_usage_name']) {
showProperty('Использование земли', $obj['land_usage_name']);
}
if ($obj['land_purpose']) {
showProperty('Назначение земли', $obj['land_purpose']);
}
if ($obj['electricity_type']) {
showProperty('Электроснабжение', $obj['electricity_type']);
}
if ($obj['gas_type']) {
showProperty('Газификация', $obj['gas_type']);
}
if ($obj['plumbing_type']) {
showProperty('Водоснабжение', $obj['plumbing_type']);
}
if ($obj['sewerage_type']) {
showProperty('Канализация', $obj['sewerage_type']);
}
if ($obj['relief_type']) {
showProperty('Рельеф', $obj['relief_type']);
}
if ($obj['shape_type']) {
showProperty('Форма участка', $obj['shape_type']);
}
if ($obj['land_distance'] * 1 != 0) {
showProperty('Удаленность от города, райцентра (км)', $obj['land_distance'] * 1);
}
showProperty('Есть обременения', $obj['land_burden'] ? "Да" : "Нет");
} else {
if ($obj['ploshad'] * 1 != 0) {
showProperty('Общая площадь', $obj['ploshad'] * 1 . ' м2');
}
if ($obj['ploshad_komn']) {
showProperty('Площадь комнат', $obj['ploshad_komn']. ' м2');
}
if ($obj['ploshad_k'] * 1 != 0) {
showProperty('Площадь кухни', $obj['ploshad_k'] * 1 . ' м2');
}
if ($obj['type_category'] == 6) {
if ($obj['etazh_iz'] * 1 != 0) {
showProperty('Всего этажей', $obj['etazh_iz']);
}
} else {
if ($obj['etazh'] * 1 != 0) {
?>
<div class="about__info-section-field"><span class="cmn__text cmn__light">Этаж:</span><span class="cmn__text cmn__main">
<?php
if ((int)$obj['etazh'] == 1 && $obj['etaz_first_type'] > 0) {
echo $etaz_first_types[$obj['etaz_first_type']];
} else {
echo $obj['etazh'];
}
if ($obj['etazh_iz'] * 1 != 0) echo " из " . $obj['etazh_iz'];
?>
</span></div>
<?php
}
if ($obj['prepay'] != 0) {
showProperty('Предоплата', $obj['prepay'] . ' месяц(ев)');
}
}
if ($obj['type'] == 3 || $obj['type'] == 5) {
if ($obj['land_area']) {
showProperty('Площадь участка', $obj['land_area'] * 1 . ' соток');
}
if ($obj['land_usage_name']) {
showProperty('Использование земли', $obj['land_usage_name']);
}
if ($obj['land_purpose']) {
showProperty('Назначение земли', $obj['land_purpose']);
}
if ($obj['electricity_type']) {
showProperty('Электроснабжение', $obj['electricity_type']);
}
if ($obj['gas_type']) {
showProperty('Газификация', $obj['gas_type']);
}
if ($obj['plumbing_type']) {
showProperty('Водоснабжение', $obj['plumbing_type']);
}
if ($obj['sewerage_type']) {
showProperty('Канализация', $obj['sewerage_type']);
}
if ($obj['relief_type']) {
showProperty('Рельеф', $obj['relief_type']);
}
if ($obj['shape_type']) {
showProperty('Форма участка', $obj['shape_type']);
}
if ($obj['land_distance'] * 1 != 0) {
showProperty('Удаленность от города, райцентра (км)', $obj['land_distance'] * 1);
}
showProperty('Есть обременения', $obj['land_burden'] ? "Да" : "Нет");
}
}
if ($obj['operation_type'] == 1 && $obj['deal_type']) {
showProperty('Тип сделки', $obj['deal_type_name']);
}
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;
}
showProperty('Тип продажи', $sale_type);
}
if($obj['ceiling_height'] && $obj['ceiling_height'] != 0) {
showProperty('Высота потолков', $obj['ceiling_height'] . " м.");
}
if($obj['bath_type']) {
showProperty('Тип ванны', $obj['bath_type']);
}
if($obj['window_view']) {
showProperty('Вид из окон', $obj['window_view']);
}
if($obj['balcony']) {
showProperty('Кол-во балконов', $obj['balcony']);
}
if($obj['loggias']) {
showProperty('Кол-во лоджий', $obj['loggias']);
}
if($obj['type'] == 4) {
if ($obj['layout_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `layout_object` WHERE id = " . $obj['layout_id']))['name'];
showProperty('Планировка', $name);
}
if ($obj['number_wet_spots']) {
showProperty('Кол-во мокрых точек', ($obj['number_wet_spots'] > 4 ? "Нет" : $obj['number_wet_spots']));
}
if ($obj['electricity_power']) {
showProperty('Электрическая мощность', $obj['electricity_power'] . ' кВТ ');
}
if ($obj['commer_condition']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commer_condition` WHERE id = " . $obj['commer_condition']))['name'];
showProperty('Состояние', $name);
}
if ($obj['isFurniture']) {
showProperty('Мебель', "есть");
}
if($obj['parking_type_id']){
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `parking_type` WHERE id = ".$obj['parking_type_id']))['name'];
showProperty('Тип парковки', $name);
}
if ($obj['parking_price']) {
showProperty('Стоимость парковки', $obj['parking_price']);
}
if ($obj['vat_type_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `vat_type` WHERE id = " . $obj['vat_type_id']))['name'];
showProperty('Налог', $name);
}
if ($obj['floor_material_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `floor_material` WHERE id = " . $obj['floor_material_id']))['name'];
showProperty('Материал пола', $name);
}
if ($obj['commerc_portal_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_portal` WHERE id = " . $obj['commerc_portal_id']))['name'];
showProperty('Ворота', $name);
}
if ($obj['commerc_purpose']) {
$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;
$purpose = '';
while ($r = mysql_fetch_assoc($q)) {
if ($i > 0) {
$purpose .= ",";
}
if ($i % 2 == 0) {
$purpose .= "<br>";
}
$purpose .= '&nbsp;' . $r['name'];
$i++;
}
}
showProperty('Назначение', $purpose);
}
}
?>
<?php
$agency_id = $user->agencyId;
$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)) {
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)) {
showProperty($row['title'], $values_str);
}
}
} else if ($row['type'] == 4) {
showProperty($row['title'], ((boolval($row['value'])) ? 'Да' : 'Нет'));
} else {
showProperty($row['title'], $row['value']);
}
}
}
}
?>
</div>
<?php if ($obj['type'] == 4) { ?>
<div class="about__info-section">
<div class="about__info-section-top"><span class="cmn__text cmn__text--med cmn__main">Информация о здании:</span></div>
<?php
if ($obj['building_nazv']) {
showProperty('Название', $obj['building_nazv']);
}
if ($obj['commerc_year']) {
showProperty('Год постройки', $obj['commerc_year']);
}
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'];
showProperty('Тип', $name);
}
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'];
showProperty('Класс', $name);
}
if ($obj['building_area']) {
showProperty('Площадь', $obj['building_area'] . ' м. кв');
}
if ($obj['commerc_houseLineType_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_houselinetype` WHERE id = " . $obj['commerc_houseLineType_id']))['name'];
showProperty('Линия домов', $name);
}
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'];
showProperty('Категория', $name);
}
if ($obj['building_developer']) {
showProperty('Девелопер', $obj['building_developer']);
}
if ($obj['building_management_company']) {
showProperty('Управляющая компания', $obj['building_management_company']);
}
if ($obj['commerc_opened_id']) {
$name = mysql_fetch_assoc(mysql_query("SELECT * FROM `commerc_opened` WHERE id = " . $obj['commerc_opened_id']))['name'];
showProperty('Вход', $name);
}
if ($obj['commerc_building_ventilation']) {
$arr = array(1 => 'Естественная', 2 => 'Приточная');
showProperty('Вентиляция', $arr[$obj['commerc_building_ventilation']]);
}
if ($obj['commerc_building_conditioning']) {
$arr = array(1 => 'Местное', 2 => 'Центральное');
showProperty('Кондиционирование', $arr[$obj['commerc_building_conditioning']]);
}
if ($obj['commerc_building_heating']) {
$arr = array(1 => 'Автономное', 2 => 'Центральное');
showProperty('Отопление', $arr[$obj['commerc_building_heating']]);
}
if ($obj['commerc_building_fire']) {
$arr = array(1 => 'Гидрантная', 2 => 'Спринклерная', 3 => 'Порошковая', 4 => 'Газовая', 5 => 'Сигнализация');
showProperty('Система пожаротушения', $arr[$obj['commerc_building_fire']]);
}
if ($obj['commerc_infrastructure']) {
$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;
$infrastructure = '';
while ($r = mysql_fetch_assoc($q)) {
if ($i > 0) {
$infrastructure .= ",";
}
if ($i % 2 == 0) {
$infrastructure .= "<br>";
}
$infrastructure .= '&nbsp;' . $r['name'];
$i++;
}
}
showProperty('Инфраструктура', $infrastructure);
}
?>
</div>
<?php }?>
<?php if ($obj['operation_type'] == 1 && $obj['type'] != 7 && $obj['type'] != 4) { ?>
<div class="about__info-section">
<div class="about__info-section-top"><span class="cmn__text cmn__text--med cmn__main">Информация о доме:</span></div>
<?php if ($obj['house_material'] && $obj['house_material'] > 0) {
showProperty('Материал', $obj['house_material_name']);
}
if ($obj['house_type'] && $obj['house_type'] > 0) {
showProperty('Тип', $obj['house_type_name']);
}
if ($obj['build_year']) {
showProperty('Год постройки', $obj['build_year']);
}
if($obj['hot_water']) {
showProperty('Обеспечение горячей водой', $obj['hot_water']);
}
if($obj['separate_wcs']) {
showProperty('Кол-во раздельных санузлов', $obj['separate_wcs']);
}
if($obj['combined_wcs']) {
showProperty('Кол-во совместных санузлов', $obj['combined_wcs']);
}
if($obj['passenger_lifts']) {
showProperty('Кол-во пассажирских лифтов', $obj['passenger_lifts']);
}
if($obj['cargo_lifts']) {
showProperty('Кол-во грузовых лифтов', $obj['cargo_lifts']);
}
if($obj['parking_type']) {
showProperty('Тип парковки', $obj['parking_type']);
}
?>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="cabinet__content">
<div class="cabinet__section cabinet__section--description">
<div class="description">
<div class="description__header"><span class="cmn__text cmn__text--med">Описание</span></div>
<div class="description__content">
<?php echo $obj['opis']; ?>
</div>
<div class="description__report"><span class="cmn__text cmn__text--med cmn__main cmn__f-semi">Отчет для клиента:</span>
<?php if ($cabinet['comment']) {?>
<div class="description__report-content">
<script type="text/javascript">
function onLoadIframe(frame) {
let doc = frame.contentDocument;
doc.head.innerHTML = doc.head.innerHTML + '<link type="text/css" rel="stylesheet" href="https://joywork.ru/js/tinymce/skins/lightgray/content-cabinet.min.css?v=4"><link type="text/css" rel="stylesheet" href="https://joywork.ru/css/cabinet-base.css?v=4">';
}
</script>
<iframe id="comment_ifr" class="description__report-content js-report-field" onload="onLoadIframe(this)" src="https://joywork.ru/ajax/getCabinetIframeContent.php?id=<?php echo $cabinet['id']; ?>" frameborder="0" allowtransparency="true" style="width: 100%; display: block;">
</iframe>
</div>
<?php }
$total_req = 0;
$total_show = 0;
$array_show = array();
$sqlRequest = "SELECT id FROM requisitions WHERE (type_id = 4 or type_id in (SELECT id FROM requisitions_type WHERE heir = 4 AND agency_id = {$user->agencyId})) and object_id = {$obj['id']} and cancel=0";
$qRequest = $pdo->query($sqlRequest);
if($pdo->num_rows($qRequest) > 0){
$total_req = $pdo->num_rows($qRequest);
}
$sqlShow = "SELECT e.*,
IF(
IFNULL(s.sub_comment, '') = '',
NULL,
s.sub_comment
) AS sub_comment,
IF(s.created_by <> 0, (
SELECT CONCAT(u.last_name, ' ', u.first_name, ' ', u.middle_name)
FROM users as u WHERE u.id = s.created_by
), NULL
) as sub_comment_author,
If(e.from_id <> 0,
(
SELECT u.user_logo FROM users as u WHERE u.id = e.from_id
), (
SELECT u.user_logo FROM users as u WHERE u.id = e.user_id
)
) as user_logo,
If(
e.from_id <> 0,
(
SELECT CONCAT(u.last_name, ' ', u.first_name, ' ', u.middle_name)
FROM users as u WHERE u.id = e.from_id
), (
SELECT CONCAT(u.last_name, ' ', u.first_name, ' ', u.middle_name)
FROM users as u WHERE u.id = e.user_id
)
) as user_fio
FROM user_object_events as e
LEFT JOIN user_sub_comments AS s ON s.event_id = e.id AND s.section_id = 1
WHERE e.object_id = {$obj['id']} AND
e.type = 'show' AND
e.calendar_view = 1
GROUP BY e.id
ORDER BY e.create_date ASC";
$qShow = $pdo->query($sqlShow);
if($pdo->num_rows($qShow) > 0){
$total_show = $pdo->num_rows($qShow);
while($rShow = $pdo->fetch_assoc($qShow)){
$array_show[] = $rShow;
}
}
?>
<div class="description__info">
<div class="description__info-section">
<div class="description__info-box">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<g clip-path="url(#clip0_404_47)">
<path d="M23.6625 12.8775L22.44 12.06C22.0073 11.7702 21.4874 11.6394 20.9691 11.69C20.4507 11.7406 19.966 11.9694 19.5975 12.3375L16.5 15.465C16.4303 14.919 16.1628 14.4174 15.7481 14.0553C15.3335 13.6931 14.8005 13.4956 14.25 13.5C13.6093 13.5885 12.9577 13.4534 12.405 13.1175C11.2595 12.3561 9.90664 11.9676 8.53171 12.0052C7.15679 12.0428 5.82713 12.5047 4.725 13.3275L4.5 13.5V12.75C4.5 12.5511 4.42098 12.3604 4.28033 12.2197C4.13968 12.0791 3.94891 12 3.75 12H0.75C0.551088 12 0.360322 12.0791 0.21967 12.2197C0.0790176 12.3604 0 12.5511 0 12.75L0 23.25C0 23.449 0.0790176 23.6397 0.21967 23.7804C0.360322 23.921 0.551088 24 0.75 24H3.75C3.94891 24 4.13968 23.921 4.28033 23.7804C4.42098 23.6397 4.5 23.449 4.5 23.25V15.375L5.625 14.5275C6.48326 13.9016 7.51123 13.5506 8.57312 13.5212C9.63501 13.4917 10.6809 13.7851 11.5725 14.3625C12.3671 14.8719 13.3111 15.0967 14.25 15C14.4489 15 14.6397 15.0791 14.7803 15.2197C14.921 15.3604 15 15.5511 15 15.75V16.5H9.75C9.55109 16.5 9.36032 16.5791 9.21967 16.7197C9.07902 16.8604 9 17.0511 9 17.25C9 17.449 9.07902 17.6397 9.21967 17.7804C9.36032 17.921 9.55109 18 9.75 18H15.75C15.9486 17.9973 16.1388 17.9196 16.2825 17.7825L20.6625 13.4025C20.7845 13.2797 20.9453 13.2029 21.1176 13.1851C21.2898 13.1673 21.4629 13.2097 21.6075 13.305L22.1775 13.6875L16.35 21.45C16.2801 21.5432 16.1896 21.6188 16.0854 21.6709C15.9813 21.7229 15.8664 21.75 15.75 21.75H6.75C6.55109 21.75 6.36032 21.8291 6.21967 21.9697C6.07902 22.1104 6 22.3011 6 22.5C6 22.699 6.07902 22.8897 6.21967 23.0304C6.36032 23.171 6.55109 23.25 6.75 23.25H15.75C16.0993 23.25 16.4438 23.1687 16.7562 23.0125C17.0687 22.8563 17.3404 22.6295 17.55 22.35L23.85 13.95C23.9108 13.8683 23.9543 13.775 23.9778 13.6758C24.0013 13.5767 24.0044 13.4738 23.9869 13.3735C23.9693 13.2731 23.9315 13.1774 23.8757 13.0921C23.82 13.0068 23.7474 12.9338 23.6625 12.8775ZM3 22.5H1.5V13.5H3V22.5Z" fill="#757575"/>
<path d="M21.4875 4.68005L16.2375 0.180049C16.1017 0.0638523 15.9288 0 15.75 0C15.5713 0 15.3984 0.0638523 15.2625 0.180049L12.75 2.33255V0.750049C12.75 0.551137 12.671 0.360372 12.5304 0.219719C12.3897 0.079067 12.199 4.93442e-05 12 4.93442e-05C11.8011 4.93442e-05 11.6104 0.079067 11.4697 0.219719C11.3291 0.360372 11.25 0.551137 11.25 0.750049V3.62255L10.0125 4.68005C9.86137 4.80934 9.76775 4.99339 9.75227 5.19171C9.7368 5.39003 9.80075 5.58638 9.93004 5.73755C10.0593 5.88872 10.2434 5.98234 10.4417 5.99782C10.64 6.01329 10.8364 5.94934 10.9875 5.82005L11.25 5.59505V9.00005C11.25 9.39787 11.4081 9.7794 11.6894 10.0607C11.9707 10.342 12.3522 10.5 12.75 10.5H18.75C19.1479 10.5 19.5294 10.342 19.8107 10.0607C20.092 9.7794 20.25 9.39787 20.25 9.00005V5.59505L20.5125 5.82005C20.6637 5.94934 20.8601 6.01329 21.0584 5.99782C21.2567 5.98234 21.4407 5.88872 21.57 5.73755C21.6993 5.58638 21.7633 5.39003 21.7478 5.19171C21.7323 4.99339 21.6387 4.80934 21.4875 4.68005ZM18.75 9.00005H16.5V7.50005C16.5 7.30114 16.421 7.11037 16.2804 6.96972C16.1397 6.82907 15.949 6.75005 15.75 6.75005C15.5511 6.75005 15.3604 6.82907 15.2197 6.96972C15.0791 7.11037 15 7.30114 15 7.50005V9.00005H12.75V4.31255L15.75 1.74005L18.75 4.31255V9.00005Z" fill="#4CAF50"/>
</g>
<defs>
<clipPath id="clip0_404_47">
<rect width="24" height="24" fill="white"/>
</clipPath>
</defs>
</svg>
</div>
<p class="cmn__text cmn__gray"><a onclick="toggleShow();" style="color: #666;" href="javascript:{}">Количество показов объекта: <span class="cmn__text cmn__black cmn__f-semi"><?=$total_show?></span></a></p>
</div>
<div class="description__info-section">
<div class="description__info-box">
<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
<g clip-path="url(#clip0_404_34)">
<path d="M16.9121 10.6275L12.4121 7.6275C12.2897 7.54685 12.1463 7.50387 11.9996 7.50387C11.853 7.50387 11.7096 7.54685 11.5871 7.6275L9.74964 8.85V7.5C9.74964 7.30109 9.67062 7.11032 9.52997 6.96967C9.38932 6.82902 9.19855 6.75 8.99964 6.75C8.80073 6.75 8.60996 6.82902 8.46931 6.96967C8.32866 7.11032 8.24964 7.30109 8.24964 7.5V9.8475L7.08714 10.5975C6.94161 10.7147 6.84508 10.8821 6.81647 11.0667C6.78785 11.2514 6.8292 11.4401 6.93243 11.5959C7.03565 11.7516 7.19331 11.8633 7.37453 11.9089C7.55574 11.9545 7.74747 11.9308 7.91214 11.8425L8.24964 11.625V15C8.24964 15.1989 8.32866 15.3897 8.46931 15.5303C8.60996 15.671 8.80073 15.75 8.99964 15.75H14.9996C15.1986 15.75 15.3893 15.671 15.53 15.5303C15.6706 15.3897 15.7496 15.1989 15.7496 15V11.655C15.958 11.8447 16.22 11.9652 16.4996 12C16.6599 11.9988 16.8155 11.9462 16.9437 11.8501C17.0719 11.754 17.166 11.6194 17.2121 11.4659C17.2582 11.3124 17.254 11.1482 17.2 10.9974C17.146 10.8465 17.0451 10.7169 16.9121 10.6275ZM14.2496 14.25H12.7496V13.5C12.7496 13.3011 12.6706 13.1103 12.53 12.9697C12.3893 12.829 12.1986 12.75 11.9996 12.75C11.8007 12.75 11.61 12.829 11.4693 12.9697C11.3287 13.1103 11.2496 13.3011 11.2496 13.5V14.25H9.74964V10.65L11.9996 9.15L14.2496 10.65V14.25Z" fill="#4CAF50"/>
<path d="M19.5 15.75C19.6989 15.75 19.8897 15.671 20.0303 15.5303C20.171 15.3897 20.25 15.1989 20.25 15V3.75C20.25 2.75544 19.8549 1.80161 19.1517 1.09835C18.4484 0.395088 17.4946 0 16.5 0L7.5 0C6.50544 0 5.55161 0.395088 4.84835 1.09835C4.14509 1.80161 3.75 2.75544 3.75 3.75V20.25C3.75 21.2446 4.14509 22.1984 4.84835 22.9016C5.55161 23.6049 6.50544 24 7.5 24H16.5C17.4946 24 18.4484 23.6049 19.1517 22.9016C19.8549 22.1984 20.25 21.2446 20.25 20.25V18C20.25 17.8011 20.171 17.6103 20.0303 17.4697C19.8897 17.329 19.6989 17.25 19.5 17.25C19.3011 17.25 19.1103 17.329 18.9697 17.4697C18.829 17.6103 18.75 17.8011 18.75 18V20.25C18.75 20.8467 18.5129 21.419 18.091 21.841C17.669 22.2629 17.0967 22.5 16.5 22.5H7.5C6.90326 22.5 6.33097 22.2629 5.90901 21.841C5.48705 21.419 5.25 20.8467 5.25 20.25V3.75C5.25 3.15326 5.48705 2.58097 5.90901 2.15901C6.33097 1.73705 6.90326 1.5 7.5 1.5V2.25C7.5 2.84674 7.73705 3.41903 8.15901 3.84099C8.58097 4.26295 9.15326 4.5 9.75 4.5H14.25C14.8467 4.5 15.419 4.26295 15.841 3.84099C16.2629 3.41903 16.5 2.84674 16.5 2.25V1.5C17.0967 1.5 17.669 1.73705 18.091 2.15901C18.5129 2.58097 18.75 3.15326 18.75 3.75V15C18.75 15.1989 18.829 15.3897 18.9697 15.5303C19.1103 15.671 19.3011 15.75 19.5 15.75ZM15 2.25C15 2.44891 14.921 2.63968 14.7803 2.78033C14.6397 2.92098 14.4489 3 14.25 3H9.75C9.55109 3 9.36032 2.92098 9.21967 2.78033C9.07902 2.63968 9 2.44891 9 2.25V1.5H15V2.25Z" fill="#757575"/>
<path d="M15.75 21H8.25C8.05109 21 7.86032 20.921 7.71967 20.7803C7.57902 20.6397 7.5 20.4489 7.5 20.25C7.5 20.0511 7.57902 19.8603 7.71967 19.7197C7.86032 19.579 8.05109 19.5 8.25 19.5H15.75C15.9489 19.5 16.1397 19.579 16.2803 19.7197C16.421 19.8603 16.5 20.0511 16.5 20.25C16.5 20.4489 16.421 20.6397 16.2803 20.7803C16.1397 20.921 15.9489 21 15.75 21Z" fill="#757575"/>
</g>
<defs>
<clipPath id="clip0_404_34">
<rect width="24" height="24" fill="white"/>
</clipPath>
</defs>
</svg>
</div>
<p class="cmn__text cmn__gray">Количество звонков по объекту: <span class="cmn__text cmn__black cmn__f-semi"><?=$total_req?></span></p>
</div>
<div style="width: 100%"></div>
<?php
if(!empty($array_show)) { ?>
<div id="showsCabinet" class="description__content" style="font-size: 14px; display:none;">
<?php
foreach($array_show as $event){
$date = date("d.m.Y", strtotime($event['schedule_date']));
list($d, $m, $y) = explode(".", $date);
if($event['req_id'] > 0){
$req_s = $pdo->fetch_assoc($pdo->query("SELECT name, client_id FROM requisitions WHERE id = {$event['req_id']}"));
$name_req = $req_s['name'];
$name_client = $pdo->result($pdo->query("SELECT fio FROM clients WHERE id = {$req_s['client_id']}"));
}
?>
<p>
<div class="message">Показ <?=$d?> <?=getRusMonth($m)?> <?=$y?> в <?=date("H:i", strtotime($event['schedule_date']))?></div>
<?php if ($event['address']) { ?>
<div class="message">Адрес: <?=$event['address']?></div>
<?php } if($event['req_id'] > 0 && isset($name_req)){ ?>
<div class="message">Заявка: <?=$name_req?></div>
<div class="message">Клиент: <?=$name_client?></div>
<?php }
if ($event['comment']) { ?>
<div class="message">Комментарий: <?=$event['comment']?></div>
<?php }
if ($event['sub_comment']) { ?>
<div class="message">Комментарий Менеджера Объекта: <?= $event['sub_comment'] ?> <span class="author">(<?= $event['sub_comment_author'] ?>)</span></div>
<?php }
?>
</p>
<?php
}
?>
</div>
<?php } ?>
</div>
</div>
<?php
if ($cabinet['show_same'] == 1) {
$db = new MysqlPdo(hstsph, null, null, null, true, '9306');
$cabinetObjCompetitors = [];
if (isset($cabinet) && isset($cabinet['id'])) {
$cabinetObjCompetitors = ObjectCabinet::getCabinetObjCompetitorsAsObjectIds($mdb, $cabinet['object_id']);
}
if (count($cabinetObjCompetitors) <= 0) {
$parentRegion = '2';
$parentRegionName = '';
$sqlRegion = "SELECT parent, name FROM rf_regions WHERE id=$obj[id_rf_region] or parent=$obj[id_rf_region]";
$resRegion = mysql_query($sqlRegion);
if (mysql_num_rows($resRegion) > 0) {
while ($row = mysql_fetch_assoc($resRegion)) {
if ($row['parent']) {
$parentRegion = $row['parent'];
}
}
}
$sqlParentRegion = "SELECT name FROM rf_regions WHERE id=$parentRegion";
$resParentRegion = mysql_query($sqlParentRegion);
if (mysql_num_rows($resParentRegion)) {
$parentReg = mysql_fetch_assoc($resParentRegion);
$parentRegionName = $parentReg['name'];
}
$komnSql = "";
$commTypeSql = "";
if ($obj['komnat']) {
$komnSql = "AND komnat=$obj[komnat]";
}
if ($obj['type'] == 4) {
$commTypeSql = "AND type_category=$obj[type_category]";
}
if (!preg_match('~\d~', $obj['adres']) && $obj['dom']) {
$obj['adres'] = $obj['adres'] . " " . $obj['dom'];
}
$adres_search = getAdresSearch($obj['adres']);
$adres_mas = explode(" ", $adres_search);
$ausl_mas = array();
for ($a = 0; $a < count($adres_mas); $a++) {
if ($adres_mas[$a]) {
$ausl_mas[] = trim($adres_mas[$a]);
}
}
$latitude = null;
$longitude = null;
if (isset($objLocationInfo)) {
$latitude = $objLocationInfo['latitude'];
$longitude = $objLocationInfo['longitude'];
$latitude = str_replace(",", ".", $latitude);
$longitude = str_replace(",", ".", $longitude);
}
$coordinatesSql = "";
if ($latitude != null && $longitude != null) {
$coordinatesSql = " | (@(id_rf_region,parent) $parentRegion @latitude $latitude @longitude $longitude)";
}
$strSph = '';
for ($a = 0; $a < count($ausl_mas); $a++) {
if (strlen($strSph) > 1) {
$strSph = $strSph . ' ';
}
$strSph = $strSph . '@adres ' . trim(str_replace("/", "-", $ausl_mas[$a]));
}
$adres_usl = "MATCH ('(@(id_rf_region,parent) $parentRegion $strSph) $coordinatesSql')";
$foundIds = array();
if ($latitude != null && $longitude != null) {
$coordinatesSql = "MATCH ('@(id_rf_region,parent) $parentRegion') AND latitude = " . $latitude . " AND longitude = " . $longitude;
$sqlCountCoords = "SELECT id FROM objects, objects_delta WHERE archive = 0 AND black = 0 AND moder = 0 AND id <> $obj[id] AND operation_type = $obj[operation_type] AND type=$obj[type] $commTypeSql $komnSql AND $coordinatesSql LIMIT 0, 10000 OPTION max_matches=1000000";
$rezCoordsSearch = $db->query($sqlCountCoords, true);
if ($db->num_rows($rezCoordsSearch) > 0) {
while ($objCoords = $db->fetch_assoc($rezCoordsSearch)) {
$foundIds[] = $objCoords['id'];
}
}
}
$strSph = '';
for ($a = 0; $a < count($ausl_mas); $a++) {
if (strlen($strSph) > 1) {
$strSph = $strSph . ' ';
}
$strSph = $strSph . '@adres ' . trim(str_replace("/", "-", $ausl_mas[$a]));
}
$adres_usl = "MATCH ('@(id_rf_region,parent) $parentRegion $strSph')";
$sqlCount = "SELECT id FROM objects, objects_delta WHERE archive = 0 AND black = 0 AND moder = 0 AND id <> $obj[id] AND operation_type = $obj[operation_type] AND type=$obj[type] $commTypeSql $komnSql AND $adres_usl LIMIT 0, 10000 OPTION max_matches=1000000";
$rezAddressSearch = $db->query($sqlCount, true);
if ($db->num_rows($rezAddressSearch) > 0) {
while ($objAddr = $db->fetch_assoc($rezAddressSearch)) {
if (!in_array($objAddr['id'], $foundIds)) {
$foundIds[] = $objAddr['id'];
}
}
}
} else {
$foundIds = $cabinetObjCompetitors;
}
$vsego = count($foundIds);
if ($vsego > 0) {
$sqlSearch = "SELECT * FROM objects, objects_delta WHERE id in (" . implode(",", $foundIds) . ") ORDER BY stoim ASC LIMIT 0, 100 OPTION max_matches=1000000";
$rezSearch = $db->query($sqlSearch);
if ($db->num_rows($rezSearch) > 0) {
?>
<div class="cabinet__section cabinet__section--info" style="margin-top: 15px;">
<div class="info">
<h2 class="cmn__title">Похожие объекты - конкуренты</h2>
<?php if (count($cabinetObjCompetitors) > 0) {?>
<div style="padding-bottom: 3px;" class="tab__controls-bottom" id="averagePriceButtonCabinetContainer">
<div class="tab__controls-bottom" id="avaragePriceButtonContainer">
<button class="tab__controls-average-btn btn-default inner-modal-opener" type="button" onclick="showAveragePrices();" data-modal-name="average-modal" style="border: 0; background: transparent;display: flex;align-items: flex-end;">
<svg width="18" height="18" style="margin-right: 10px;">
<use xlink:href="#icon-chart"></use>
</svg><span style="border-bottom: 1px solid;padding-bottom: 1px;">Показать средние цены</span>&nbsp;&nbsp;&nbsp;<span style="font-size: 16px; border-bottom: none;" id="averageCountNumber">Объектов в сравнении: <?php echo count($cabinetObjCompetitors);?></span>
</button>
</div>
</div>
<?php } ?>
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" style="height: 1px;">
<symbol id="icon-close" viewBox="0 0 18 18">
<g clip-path="url(#clip0_3_47)">
<path d="M0.93511 18.0001C0.698006 18.0001 0.460901 17.9099 0.280756 17.7284C-0.0808901 17.3667 -0.0808901 16.7804 0.280756 16.4188L16.4283 0.271239C16.7899 -0.0904078 17.3762 -0.0904078 17.7379 0.271239C18.0995 0.632885 18.0995 1.2192 17.7379 1.58108L1.59059 17.7284C1.40909 17.9087 1.17199 18.0001 0.93511 18.0001Z" fill="#757579"></path>
<path d="M17.0838 18.0001C16.8466 18.0001 16.6098 17.9099 16.4294 17.7284L0.280756 1.58108C-0.0808901 1.2192 -0.0808901 0.632885 0.280756 0.271239C0.642403 -0.0904078 1.22872 -0.0904078 1.59059 0.271239L17.7379 16.4188C18.0995 16.7804 18.0995 17.3667 17.7379 17.7284C17.5564 17.9087 17.3195 18.0001 17.0838 18.0001Z" fill="#757579"></path>
</g>
</symbol><symbol id="icon-chart" viewBox="0 0 18 18">
<path d="M17.25 16.5H1.5V0.75C1.5 0.551088 1.42098 0.360322 1.28033 0.21967C1.13968 0.0790176 0.948912 0 0.75 0C0.551088 0 0.360322 0.0790176 0.21967 0.21967C0.0790176 0.360322 0 0.551088 0 0.75L0 17.25C0 17.4489 0.0790176 17.6397 0.21967 17.7803C0.360322 17.921 0.551088 18 0.75 18H17.25C17.4489 18 17.6397 17.921 17.7803 17.7803C17.921 17.6397 18 17.4489 18 17.25C18 17.0511 17.921 16.8603 17.7803 16.7197C17.6397 16.579 17.4489 16.5 17.25 16.5Z" fill="#4CAF50"></path>
<path d="M3 12.75V15C3 15.1989 3.07902 15.3897 3.21967 15.5303C3.36032 15.671 3.55109 15.75 3.75 15.75C3.94891 15.75 4.13967 15.671 4.28033 15.5303C4.42098 15.3897 4.5 15.1989 4.5 15V12.75C4.5 12.5511 4.42098 12.3603 4.28033 12.2197C4.13967 12.079 3.94891 12 3.75 12C3.55109 12 3.36032 12.079 3.21967 12.2197C3.07902 12.3603 3 12.5511 3 12.75V12.75Z" fill="#4CAF50"></path>
<path d="M6.75 7.5V15C6.75 15.1989 6.82902 15.3897 6.96967 15.5303C7.11032 15.671 7.30109 15.75 7.5 15.75C7.69891 15.75 7.88967 15.671 8.03033 15.5303C8.17098 15.3897 8.25 15.1989 8.25 15V7.5C8.25 7.30109 8.17098 7.11032 8.03033 6.96967C7.88967 6.82902 7.69891 6.75 7.5 6.75C7.30109 6.75 7.11032 6.82902 6.96967 6.96967C6.82902 7.11032 6.75 7.30109 6.75 7.5Z" fill="#4CAF50"></path>
<path d="M11.25 15.75C11.4489 15.75 11.6397 15.671 11.7803 15.5303C11.921 15.3897 12 15.1989 12 15V9C12 8.80109 11.921 8.61032 11.7803 8.46967C11.6397 8.32902 11.4489 8.25 11.25 8.25C11.0511 8.25 10.8603 8.32902 10.7197 8.46967C10.579 8.61032 10.5 8.80109 10.5 9V15C10.5 15.1989 10.579 15.3897 10.7197 15.5303C10.8603 15.671 11.0511 15.75 11.25 15.75Z" fill="#4CAF50"></path>
<path d="M15.75 15V4.5C15.75 4.30109 15.671 4.11032 15.5303 3.96967C15.3897 3.82902 15.1989 3.75 15 3.75C14.8011 3.75 14.6103 3.82902 14.4697 3.96967C14.329 4.11032 14.25 4.30109 14.25 4.5V15C14.25 15.1989 14.329 15.3897 14.4697 15.5303C14.6103 15.671 14.8011 15.75 15 15.75C15.1989 15.75 15.3897 15.671 15.5303 15.5303C15.671 15.3897 15.75 15.1989 15.75 15Z" fill="#4CAF50"></path>
</symbol>
</svg>
<div class="cabinet__section cabinet__section--average" id="averagePricesBlock" style="display: none;padding: 30px;background-color: rgb(255, 255, 255);box-shadow: rgba(0, 0, 0, 0.25) -3px 0px 24px;animation: 0.7s ease 0s 1 normal forwards running showInnerModal;">
<div class="average">
<div class="inner-modal__header" style="display: flex;align-items: flex-start;">
<h2 class="inner-modal__title">Средние цены</h2>
<button class="inner-modal__close btn-default" onclick="showAveragePrices();" type="button" style="border: 0;padding: 0;background-color: transparent;display: flex; align-items: center; justify-content: center; margin-left: auto; width: 40px; height: 40px; border-radius: 50%; transition: background-color .3s .1s linear;">
<svg width="18" height="18">
<use xlink:href="#icon-close"></use>
</svg>
</button>
</div>
<div class="average-table"><span class="cmn__text cmn__text--med cmn__main cmn__f-semi average-table__title">Среднерыночная стоимость «Квадратного метра»</span>
<div class="average-table__content">
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Демпинговые цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__danger" id="analyticsDempMeters">2 000 000 3 000 000 р</span></div>
</div>
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Средние цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__warning" id="analyticsAvarageMeters">3 000 000 5 000 000 р</span></div>
</div>
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Высокие цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__positive" id="analyticsHighMeters">5 000 000 8 000 000 р</span></div>
</div>
</div>
</div>
<div class="average-table"><span class="cmn__text cmn__text--med cmn__main cmn__f-semi average-table__title">Среднерыночная стоимость «Объекта»</span>
<div class="average-table__content">
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Демпинговые цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__danger" id="analyticsDempAllPrice">2 000 000 3 000 000 р</span></div>
</div>
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Средние цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__warning" id="analyticsAvarageAllPrice">3 000 000 5 000 000 р</span></div>
</div>
<div class="average-table__row">
<div class="average-table__row-pricelist"><span class="cmn__text cmn__text--small cmn__gray average-table__name">Высокие цены от:</span><span class="cmn__text cmn__text--small cmn__gray average-table__value cmn__positive" id="analyticsHighAllPrice">155 000 000 р 300 000 000 р</span></div>
</div>
</div>
</div>
<div class="average__recomendation"><span class="cmn__text cmn__text--small cmn__main cmn__f-semi">Рекомендованная цена продажи</span>
<ul>
<li><span class="cmn__text cmn__text--small cmn__gray">За 12 месяцев:</span><span class="cmn__text cmn__text--info cmn__main cmn__f-semi" id="analyticsTwelveMonthPrice">300 000 000 р</span></li>
<li><span class="cmn__text cmn__text--small cmn__gray">За 3 месяца:</span><span class="cmn__text cmn__text--info cmn__main cmn__f-semi" id="analyticsThreeMonthPrice">300 200 000 р</span></li>
<li><span class="cmn__text cmn__text--small cmn__gray">Сделка завтра:</span><span class="cmn__text cmn__text--info cmn__main cmn__f-semi" id="analyticsNowPrice">300 150 000 р</span></li>
</ul>
</div>
</div>
</div>
<ul class="info__objects-list">
<?php
while ($concurrentObject = $db->fetch_assoc($rezSearch)) {
include($_SERVER['DOCUMENT_ROOT'] . "/templates/object_analytics_cabinet_template.php");
} ?>
</ul>
</div>
</div>
<?php
}
}
?>
<?php
if (count($cabinetObjCompetitors) > 0) {
$foundIds = ObjectCabinet::getCabinetObjCompetitorsAsObjectIds($mdb, $cabinet['object_id']);
$vsego = count($foundIds);
$asScript = true;
$objectId = $cabinet['object_id'];
include($_SERVER['DOCUMENT_ROOT'] . "/ajax/analytics/getAnalyticsPriceStats.php");
}
}
$agency_id = $user->agencyId;
$advrStat = [];
$services = [];
$obj_id = $obj['id'];
$period = [
'date_from' => date('Y-m-d', strtotime($obj['date_add'])),
'date_to' => date('Y-m-d'),
];
$api = new AdvertStats();
$available = [];
if ($obj['add_to_avito_feed'] == 1)
$available[1] = 'avito';
if ($obj['add_to_cian_feed'] == 1)
$available[2] = 'cian';
if ($obj['add_to_yandex_feed'] == 1)
$available[3] = 'yandex';
if ($obj['add_to_domclick_feed'] == 1)
$available[4] = 'domclick';
$services = [];
$settings = $api->getApiSettings($agency_id, true);
if (count($settings)) {
foreach ($settings as $setting) {
$service_id = $setting['service_id'];
$service = $api->getServiceName($service_id);
$services[] = $service;
}
$reports = $api->getReports(null, $agency_id, $obj_id);
foreach ($reports as $service => $report) {
if (!is_null($report)) {
$advrStat['stats'][$service] = $report;
}
}
/*foreach ($settings as $setting) {
$service_id = $setting['service_id'];
if ($service = $available[$service_id]) {
if ($service == 'avito')
continue;
if (!isset($advrStat['stats'][$service])) {
$client_id = $setting['client_id'];
$secret_key = $setting['secret_key'];
$ext_user_id = $setting['ext_user_id'];
if ($service == 'yandex' && strtotime($period['date_from']) < strtotime('-120 days')) {
$period['date_from'] = date('Y-m-d', strtotime('-120 days'));
}
if ($stats = $api->getStats($service_id, $period, $client_id, $secret_key, $ext_user_id, $obj_id, true))
$advrStat['stats'][$service] = $stats;
else
$advrStat['stats'][$service] = null;
if (count($api->errors))
$advrStat['errors'][$service] = array_merge($advrStat['stats'][$service]['errors'], array_unique($api->errors));
if (count($advrStat['errors'][$service]))
$advrStat['errors'][$service] = array_unique($advrStat['errors'][$service]);
}
}
}*/
}
$sqlCabinetFeeds = "SELECT * FROM object_cabinet_feeds WHERE object_cabinet_id=$cabinet[id]";
$rezCabinetFeeds = mysql_query($sqlCabinetFeeds);
$sqlCabinetFeedsSumStat = "SELECT sum(view_count) as sum_view_count from object_cabinet_feeds where object_cabinet_id = $cabinet[id]";
$rezCabinetFeedsSumStat = mysql_query($sqlCabinetFeedsSumStat);
$rezCabinetFeedsSumStatRes = mysql_fetch_assoc($rezCabinetFeedsSumStat);
$whereSqlPack = "zipal_id in (select pp.zipal_id from advertising_package_object_publish pp where pp.object_id = $obj[id] and pp.active=1)";
$whereSqlBut = "";
if ($obj['add_to_zipal'] == 1) {
$whereSqlBut = "or zipal_id in (select zo.zipal_id from zipal_objects zo where zo.object_id = $obj[id])";
}
$whereSqlJcat = "or jcat_id in (select zo.jcat_id from jcat_feed_report_objects zo where zo.object_id = $obj[id] and zo.active = 1)";
$sqlStat = "SELECT * from object_feed_stat where object_id = $obj[id] and deleted = 0 and ($whereSqlPack $whereSqlBut $whereSqlJcat)";
$rezStat = mysql_query($sqlStat);
$sqlSumStat = "SELECT sum(view_count) as sum_view_count from object_feed_stat where object_id = $obj[id] and deleted = 0 and ($whereSqlPack $whereSqlBut $whereSqlJcat)";
$rezSumStat = mysql_query($sqlSumStat);
$rezSumStatRes = mysql_fetch_assoc($rezSumStat);
$sum = $rezSumStatRes['sum_view_count'] + $rezCabinetFeedsSumStatRes['sum_view_count'];
$resultArray = [];
while ($stat = mysql_fetch_assoc($rezCabinetFeeds)) {
$result = [];
$result['url'] = $stat['url'];
$result['name'] = $stat['name'];
$result['view'] = $stat['view_count'];
$resultArray[] = $result;
}
while ($stat = mysql_fetch_assoc($rezStat)) {
if (strpos($stat['link'], 'http://') !== false || strpos($stat['link'], 'https://') !== false) {
$result = [];
$result['url'] = $stat['link'];
$result['name'] = $stat['feed_name'];
$result['view'] = $stat['view_count'];
$resultArray[] = $result;
}
}
if (count($advrStat) > 0 || count($resultArray) > 0 || $cabinet['show_empty_links'] == 1) {
$views = 0;
?>
<div class="cabinet__section cabinet__section--adds" style="margin-top: 15px;">
<div class="adds">
<div class="adds__header">
<h2 class="cmn__title">Реклама вашего объекта</h2>
<p class="cmn__text cmn__main">Мы рекламируем Ваш объект на следующих источниках, нажмите на название сайта, чтобы проверить, как выглядит ваше объявление.</p>
</div>
<div class="adds__stat">
<div class="advert-stat">
<?php
if (count($advrStat) > 0) {
?>
<div class="advert-stat__field"><b class="cmn__title cmn__title--med">Основные сайты</b>
<div class="advert-stat__field-info">
<svg width="18" height="18">
<use xlink:href="#icon-view"></use>
</svg>
<p class="cmn__text cmn__gray">Общее количество просмотров: <span class="cmn__main" id="viewsSpan">256</span></p>
</div>
<div class="advert-stat__field-content">
<div class="advert-table">
<table>
<thead>
<tr>
<th class="cmn__text cmn__text--small cmn__gray">Площадка</th>
<th class="cmn__text cmn__text--small cmn__gray">Просмотров объявления</th>
<th class="cmn__text cmn__text--small cmn__gray">Просмотров контактов</th>
<th class="cmn__text cmn__text--small cmn__gray">Добавили в&nbsp;избранное</th>
<th class="cmn__text cmn__text--small cmn__gray">Звонков с сайта</th>
</tr>
</thead>
<tbody>
<?php if (in_array('avito', $services)) : ?>
<?php if (!is_null($advrStat['stats']['avito']) && is_null($advrStat['avito']['error'])) :
$stats = $advrStat['stats']['avito'];
if (
!is_null($stats['views']) ||
!is_null($stats['contacts']) ||
!is_null($stats['favorites']) ||
!is_null($stats['calls'])) :
if ((!is_null($stats['views']))) {
$views += $stats['views'];
}
?>
<tr>
<td>
<?= (!is_null($stats['url'])) ? '<a class="cmn__text cmn__f-semi cmn__main cmn__underline" href="'.$stats['url'].'" title="'.$stats['url'].'" target="_blank">Авито</a>' : "Авито" ?>
</td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['views'])) ? $stats['views'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['contacts'])) ? $stats['contacts'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['favorites'])) ? $stats['favorites'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['calls'])) ? $stats['calls'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
</tr>
<?php endif; ?>
<?php endif; ?>
<?php endif; ?>
<?php if (in_array('cian', $services) && is_null($advrStat['cian']['error'])) : ?>
<?php if (!is_null($advrStat['stats']['cian'])) :
$stats = $advrStat['stats']['cian'];
if (
!is_null($stats['views']) ||
!is_null($stats['contacts']) ||
!is_null($stats['favorites']) ||
!is_null($stats['calls'])) :
if ((!is_null($stats['views']))) {
$views += $stats['views'];
}
?>
<tr>
<td>
<?= (!is_null($stats['url'])) ? '<a class="cmn__text cmn__f-semi cmn__main cmn__underline" href="'.$stats['url'].'" title="'.$stats['url'].'" target="_blank">ЦИАН</a>' : "ЦИАН" ?>
</td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['views'])) ? $stats['views'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['contacts'])) ? $stats['contacts'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['favorites'])) ? $stats['favorites'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['calls'])) ? $stats['calls'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
</tr>
<?php endif; ?>
<?php endif; ?>
<?php endif; ?>
<?php if (in_array('yandex', $services) && is_null($advrStat['yandex']['error'])) : ?>
<?php if (!is_null($advrStat['stats']['yandex'])) :
$stats = $advrStat['stats']['yandex'];
if (
!is_null($stats['views']) ||
!is_null($stats['contacts']) ||
!is_null($stats['favorites']) ||
!is_null($stats['calls'])) :
if ((!is_null($stats['views']))) {
$views += $stats['views'];
}
?>
<tr>
<td>
<?= (!is_null($stats['url'])) ? '<a class="cmn__text cmn__f-semi cmn__main cmn__underline" href="'.$stats['url'].'" title="'.$stats['url'].'" target="_blank">Я.Недвижимость</a>' : "Яндекс.Недвижимость" ?>
</td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['views'])) ? $stats['views'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['contacts'])) ? $stats['contacts'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['favorites'])) ? $stats['favorites'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['calls'])) ? $stats['calls'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
</tr>
<?php endif; ?>
<?php endif; ?>
<?php endif; ?>
<?php if (in_array('domclick', $services) && is_null($advrStat['domclick']['error'])) : ?>
<?php if (!is_null($advrStat['stats']['domclick'])) :
$stats = $advrStat['stats']['domclick'];
if (
!is_null($stats['views']) ||
!is_null($stats['contacts']) ||
!is_null($stats['favorites']) ||
!is_null($stats['calls'])) :
if ((!is_null($stats['views']))) {
$views += $stats['views'];
}
?>
<tr>
<td>
<?= (!is_null($stats['url'])) ? '<a class="cmn__text cmn__f-semi cmn__main cmn__underline" href="'.$stats['url'].'" title="'.$stats['url'].'" target="_blank">ДомКлик</a>' : "ДомКлик" ?>
</td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['views'])) ? $stats['views'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['contacts'])) ? $stats['contacts'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['favorites'])) ? $stats['favorites'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
<td class="cmn__text cmn__main"><?= (!is_null($stats['calls'])) ? $stats['calls'] : '<span style="color:#a1a1a1;">n/a</span>'; ?></td>
</tr>
<?php endif; ?>
<?php endif; ?>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
<?php
}
if (count($resultArray) > 0 || $cabinet['show_empty_links'] == 1) {
?>
<div class="advert-stat__field"><b class="cmn__title cmn__title--med">Дополнительные сайты</b>
<div class="advert-stat__field-content">
<ul class="advert-list">
<?php
foreach ($resultArray as $res) {
if (!is_null($res['view'])) {
$views += $res['view'];
}
?>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="<?php echo $res['url']?>"><?php echo $res['name']?></a>
<div class="advert-list__views">
<svg width="18" height="18">
<use xlink:href="#icon-view"></use>
</svg><span class="cmn__text cmn__main"><?php echo $res['view']?></span>
</div>
</li>
<?php
}
if ($cabinet['show_empty_links'] == 1) {
?>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://www.egent.ru">Egent.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://fotomakler.ru">Fotomakler.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://chastnik.ru">Chastnik.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://qp.ru">QP.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://www.realtymag.ru">Realtymag.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://rentzilla.ru">Rentzilla.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://kvmeter.ru">Kvmeter.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://rucountry.ru">Rucountry.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://www.bestru.ru">Bestru.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://gde.ru">Gde.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://nedvrf.ru">Nedvrf.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://kvartiri-domiki.ru">Квартиры-домики.рф</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="http://realtyport.su">Realtyport.su</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://www.restate.ru">Restate.ru</a></li>
<li><a class="cmn__text cmn__underline cmn__main" target="_blank" href="https://www.akula.com">Akula.com</a></li>
<?php
}
?>
</ul>
</div>
</div>
<?php
}
echo '<script type="text/javascript">document.getElementById("viewsSpan").innerText = ' . $views . ';</script>';
?>
</div>
</div>
</div>
</div>
<? } ?>
</div>
</div>
</div>
</section>
</main>
<footer class="footer">
<div class="cmn__container footer__container">
<div class="footer__info">
<?php if ($user->photo) {?>
<img src="<?php if ($user->photo) { echo "/photos/agency/" . $user->photo; } else { echo ""; }?>" alt="логотип" width="90" height="77">
<?php } ?>
<div class="contacts">
<span class="cmn__text cmn__text--small cmn__main">Агентство недвижимости<br><?php echo $user->agencyName;?></span>
<?php if($user->site && $user->sitename) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="<?php echo $site;?>"><?php echo $user->sitename;?></a>
<?php } ?>
<?php if($user->email) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="mailto:<?php echo $user->email; ?>"><?php echo $user->email; ?></a>
<?php } ?>
<a class="cmn__text cmn__text--info cmn__main" href="tel:<?php echo $user->phoneAgency; ?>"><?php echo $user->phoneAgency; ?></a>
</div>
<div class="footer__user">
<div class="user">
<?php if ($user->user_logo) {?>
<img src="<?php if ($user->user_logo) { echo "/photos/agency/" . $user->user_logo; } else { echo "";}?>" alt="аватар" width="100" height="100">
<?php } ?>
<div class="user__info"><span class="cmn__text cmn__text--small cmn__gray">Ваш агент</span>
<span class="cmn__text cmn__text--small cmn__main"><?php echo $user->fio; ?></span>
<?php if($user->email) {?>
<a class="cmn__text cmn__text--small cmn__gray cmn__underline" href="mailto:<?php echo $user->email; ?>"><?php echo $user->email; ?></a>
<? } ?>
<?php if($user->phone) {?>
<a class="cmn__text cmn__text--info cmn__main" href="tel:<?php echo $user->phone;?>"><?php echo $user->phone;?></a></div>
<?php } ?>
</div>
</div>
</div>
</footer>
<!-- include ./modals/info-modal-->
<script src="/cabinet/js/bundle.js"></script>
<script>
function toggleShow() {
var el = document.getElementById('showsCabinet');
el.style.display = (el.style.display == 'none') ? '' : 'none';
}
function showAveragePrices() {
var el = document.getElementById('averagePricesBlock');
el.style.display = (el.style.display == 'none') ? '' : 'none';
}
</script>
</body>
</html>