202 lines
7.2 KiB
PHP
202 lines
7.2 KiB
PHP
|
<?php
|
|||
|
|
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
|||
|
|
|
|||
|
|
ini_set('display_errors', 1);
|
|||
|
|
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
|||
|
|
?>
|
|||
|
|
<!DOCTYPE HTML>
|
|||
|
|
<html>
|
|||
|
|
<head>
|
|||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|||
|
|
<title>Предложения JoyWork.ru - Версия для печати</title>
|
|||
|
|
<link rel="shortcut icon" type="image/x-icon" href="/images/favicon.ico" />
|
|||
|
|
</head>
|
|||
|
|
<body>
|
|||
|
|
<h2>Выбранные предложения JoyWork.ru. <?php echo date("d.m.Y H:i:s"); ?></h2>
|
|||
|
|
<table width="100%" border="1" cellpadding="1" cellspacing="0">
|
|||
|
|
<tr>
|
|||
|
|
<th>№</th>
|
|||
|
|
<th>№ в базе</th>
|
|||
|
|
<th>Тип сделки</th>
|
|||
|
|
<th>Район, адрес</th>
|
|||
|
|
<th>Метро</th>
|
|||
|
|
<th>S</th>
|
|||
|
|
<th>Эт</th>
|
|||
|
|
<th>Цена</th>
|
|||
|
|
<th>Примечания</th>
|
|||
|
|
<th>Фото</th>
|
|||
|
|
</tr>
|
|||
|
|
<?php if (isset($_SESSION['checked']) && count($_SESSION['checked']) > 0) {
|
|||
|
|
|
|||
|
|
$sql = "SELECT objects.*, DATE_FORMAT(objects.date_add,'%d.%m.%Y %H:%i') as date_add FROM objects objects WHERE objects.id in (".implode(",", $_SESSION['checked']).")";
|
|||
|
|
$rez=mysql_query($sql,$mdb);
|
|||
|
|
$i = 0;
|
|||
|
|
while($obj=mysql_fetch_assoc($rez)) {
|
|||
|
|
|
|||
|
|
if ($obj['rayon']) {
|
|||
|
|
$sqlRayonInfo = "SELECT rayon FROM rayon WHERE id=$obj[rayon]";
|
|||
|
|
$rezRayonInfo = mysql_query($sqlRayonInfo);
|
|||
|
|
|
|||
|
|
if (mysql_num_rows($rezRayonInfo) > 0) {
|
|||
|
|
$objRayonInfo = mysql_fetch_assoc($rezRayonInfo);
|
|||
|
|
$object['rayon'] = $objRayonInfo['rayon'];
|
|||
|
|
} else {
|
|||
|
|
$object['rayon'] = null;
|
|||
|
|
}
|
|||
|
|
} else {
|
|||
|
|
$object['rayon'] = null;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
//Доп обработка
|
|||
|
|
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']);
|
|||
|
|
$obj['sobstv'] = Filter::replaceSobstv($obj['sobstv']);
|
|||
|
|
|
|||
|
|
$i++;
|
|||
|
|
?>
|
|||
|
|
<tr>
|
|||
|
|
<td style="text-align: center;"><?php echo $i; ?></td>
|
|||
|
|
<td style="text-align: center;">
|
|||
|
|
<?php
|
|||
|
|
if($obj['id_add_user']) {
|
|||
|
|
echo 'Агент';
|
|||
|
|
} else {
|
|||
|
|
echo 'Собственник';
|
|||
|
|
}
|
|||
|
|
echo "<br/>".$obj['id'];
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td style="text-align: center;">
|
|||
|
|
<?php
|
|||
|
|
echo $obj['nazv'];
|
|||
|
|
$date = $obj['date_add'];
|
|||
|
|
if (!$obj['archive']) {
|
|||
|
|
echo '<br/><span>'.$date.'</span>';
|
|||
|
|
}
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td>
|
|||
|
|
<?php
|
|||
|
|
if($object['rayon']) {
|
|||
|
|
echo $obj['rayon'];
|
|||
|
|
?>
|
|||
|
|
район <br/>
|
|||
|
|
<?php
|
|||
|
|
}
|
|||
|
|
echo $obj['adres'];
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td>
|
|||
|
|
<?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)."<br/>";
|
|||
|
|
|
|||
|
|
if($obj['peshkom']) echo $obj['peshkom']." минут пешком";
|
|||
|
|
if($obj['peshkom'] and $obj['transport']) echo " или ";
|
|||
|
|
if($obj['transport']) echo $obj['transport']." минут на транспорте";
|
|||
|
|
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td>
|
|||
|
|
<?php
|
|||
|
|
|
|||
|
|
if($obj['ploshad']*1!=0) {
|
|||
|
|
|
|||
|
|
echo '<p class="sq"><b class="big">';
|
|||
|
|
echo $obj['ploshad']*1;
|
|||
|
|
echo " кв. м</b></p>";
|
|||
|
|
}
|
|||
|
|
if($obj['ploshad_k']*1!=0) {
|
|||
|
|
echo '<p class="sq small">кухня ';
|
|||
|
|
echo $obj['ploshad_k']*1;
|
|||
|
|
echo " кв. м</p>";
|
|||
|
|
}
|
|||
|
|
if($obj['ploshad_komn']) {
|
|||
|
|
echo '<p class="sq small">жилая ';
|
|||
|
|
echo $obj['ploshad_komn'];
|
|||
|
|
echo " кв. м</p>";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td>
|
|||
|
|
<?php
|
|||
|
|
echo $obj['etazh'];
|
|||
|
|
if($obj['etazh_iz']*1!=0) {
|
|||
|
|
echo " из ".$obj['etazh_iz'];
|
|||
|
|
}
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td>
|
|||
|
|
<span><?php echo $obj['stoim'].'<span class="rub">p</span> '.$obj['stoim_prim']; ?></span>
|
|||
|
|
</td>
|
|||
|
|
<td style="width: 60%;">
|
|||
|
|
<?php
|
|||
|
|
|
|||
|
|
if($obj['holod']) {
|
|||
|
|
echo "Хол + ";
|
|||
|
|
}
|
|||
|
|
if($obj['stirka']) {
|
|||
|
|
echo "СтМ + ";
|
|||
|
|
}
|
|||
|
|
if($obj['tv']) {
|
|||
|
|
echo "Тв + ";
|
|||
|
|
}
|
|||
|
|
if($obj['mebel']) {
|
|||
|
|
echo "Меб + ";
|
|||
|
|
}
|
|||
|
|
echo "<br/><br/>";
|
|||
|
|
if ($obj['opis']) {
|
|||
|
|
if (strlen($obj['opis']) > 0 && strlen($obj['opis']) <= 100) {
|
|||
|
|
echo cleanHtml($obj['opis']);
|
|||
|
|
} else {
|
|||
|
|
echo html_entity_decode(mb_substr($obj['opis'], 0, 100))."...";
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
echo "<br/><br/>";
|
|||
|
|
echo "<b>".$obj['sobstv']."</b>";
|
|||
|
|
echo "<br/>";
|
|||
|
|
echo $obj['phone'];
|
|||
|
|
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
<td style="text-align: center;">
|
|||
|
|
<?php
|
|||
|
|
|
|||
|
|
$sqlPhotoInfo = "SELECT id FROM objects_object_photo oop WHERE oop.object_id = $obj[id] LIMIT 1";
|
|||
|
|
$rezPhotoInfo = mysql_query($sqlPhotoInfo);
|
|||
|
|
|
|||
|
|
if (mysql_num_rows($rezPhotoInfo) > 0) {
|
|||
|
|
echo "есть фото";
|
|||
|
|
} else {
|
|||
|
|
echo "нет фото";
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
?>
|
|||
|
|
</td>
|
|||
|
|
</tr>
|
|||
|
|
<?php
|
|||
|
|
}
|
|||
|
|
} else { ?>
|
|||
|
|
<tr>
|
|||
|
|
<td colspan="10" style="text-align: center;">Нет выбранных предложений</td>
|
|||
|
|
</tr>
|
|||
|
|
<?php }?>
|
|||
|
|
</table>
|
|||
|
|
</body>
|
|||
|
|
</html>
|