1 line
3.4 KiB
PHP
1 line
3.4 KiB
PHP
<?php
|
||
|
||
|
||
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
|
||
|
||
|
||
if($_SESSION['id'] && $_GET['objId']) {
|
||
|
||
|
||
|
||
$get=clearInputData($_GET);
|
||
|
||
|
||
|
||
$sql3="SELECT objects.*, DATE_FORMAT(objects.date_add,'%d.%m.%Y %H:%i') as date_add
|
||
|
||
FROM objects
|
||
|
||
WHERE objects.id = $get[objId]";
|
||
|
||
$rez_obj=mysql_query($sql3);
|
||
|
||
$obj=mysql_fetch_assoc($rez_obj);
|
||
|
||
|
||
|
||
if ($obj) {
|
||
|
||
|
||
|
||
//Доп обработка
|
||
|
||
|
||
|
||
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['opis'] = str_replace("<br>", "\n", $obj['opis']);
|
||
|
||
|
||
$sqlUser="SELECT * FROM users WHERE id = $_SESSION[id]";
|
||
|
||
$rez_user=mysql_query($sqlUser);
|
||
|
||
$user=mysql_fetch_assoc($rez_user);
|
||
|
||
|
||
|
||
$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];
|
||
|
||
$metro_str = implode(", ",$mtr);
|
||
|
||
$message = " ";
|
||
|
||
if ($obj['operation_type'] == 0) {
|
||
$message = "Сдается ";
|
||
} else {
|
||
if ($obj['operation_type'] == 1) {
|
||
$message = "Продается ";
|
||
}
|
||
}
|
||
|
||
$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);
|
||
$address = $objLocationInfo['address'];
|
||
} else {
|
||
$address = $obj['adres'];
|
||
|
||
if ($obj['dom']) {
|
||
$address = $address . ", " . $obj['dom'];
|
||
}
|
||
|
||
if ($obj['korpus']) {
|
||
$address = $address . ", корпус " . $obj['korpus'];
|
||
}
|
||
|
||
if ($obj['litera']) {
|
||
$address = $address . ", литера" . $obj['litera'];
|
||
}
|
||
}
|
||
|
||
$message .= $obj['nazv']." по адресу: ".$address."\n";
|
||
|
||
if ($metro_str) {
|
||
|
||
$message .= "Станция метро: " . $metro_str . "\n";
|
||
|
||
}
|
||
|
||
if($obj['ploshad']*1 != 0) {
|
||
|
||
$obj['ploshad'] *= 1;
|
||
|
||
$message .= "Общая площадь: ".$obj['ploshad']." кв.м. \n";
|
||
|
||
}
|
||
|
||
|
||
|
||
if($obj['etazh']*1!=0) {
|
||
|
||
$message = $message.'Этаж: '.$obj['etazh'];
|
||
|
||
if($obj['etazh_iz']*1!=0) {
|
||
|
||
$message .= " из ".$obj['etazh_iz'];
|
||
|
||
}
|
||
|
||
$message .= "\n";
|
||
|
||
}
|
||
|
||
|
||
|
||
$message .= br2nl(cleanHtml($obj['opis'], true)) ."\n";
|
||
|
||
$message .= "Цена: ".$obj['stoim']." руб.\n";
|
||
|
||
$message .= "Телефон: ".$user['phone']." ";
|
||
|
||
/*if (isset($user['director'])) {
|
||
$message .= $user['director'];
|
||
} else {
|
||
$message .= $user['fio'];
|
||
}*/
|
||
|
||
$message .= trim($user['last_name'] . ' ' . $user['first_name'] . ' ' . $user['middle_name']);
|
||
|
||
echo htmlspecialchars_decode($message);
|
||
|
||
}
|
||
|
||
} |