public static function getHouseList($where, $order, $direction, $per_page = 10, $current_page = 1, $action = 'sales', $user_id = NULL)
{
$start_pos = ($current_page - 1) * $per_page;
$limit = " LIMIT {$start_pos},{$per_page}";
$sort = $order == '' ? "f.updated_on" : $order;
$where_param = $where . " GROUP BY f.id ORDER BY " . $sort . " " . $direction . $limit;
$params = '';
$price_min = 0;
$price_max = 0;
if (isset($_REQUEST['f_price'])) {
$f_price = intval($_REQUEST['f_price']);
$params .= '&f_price=' . $f_price;
switch ($f_price) {
case 1:
$price_max = 1000000;
break;
case 2:
$price_min = 1000000;
$price_max = 1500000;
break;
case 3:
$price_min = 1500000;
$price_max = 2000000;
break;
case 4:
$price_min = 2000000;
$price_max = 3000000;
break;
case 5:
$price_min = 3000000;
break;
}
} else {
if (isset($_REQUEST['price_min']) && $_REQUEST['price_min'] > 0) {
$price_min = intval($_REQUEST['price_min']);
} else {
$price_min = 0;
}
if (isset($_REQUEST['price_max']) && $_REQUEST['price_max'] > 0) {
$price_max = intval($_REQUEST['price_max']);
} else {
$price_max = 0;
}
if ($price_min > 0) {
$params .= '&price_min=' . $price_min;
}
if ($price_max > 0) {
$params .= '&price_max=' . $price_max;
}
}
if (isset($_REQUEST['f_price_sq'])) {
$params .= '&f_price_sq=' . intval($_REQUEST['f_price_sq']);
}
if (isset($_REQUEST['f_radius'])) {
$params .= '&f_radius=' . intval($_REQUEST['f_radius']);
}
if (isset($_REQUEST['f_house'])) {
$params .= '&f_house=' . intval($_REQUEST['f_house']);
}
if (isset($_REQUEST['f_total_area'])) {
$params .= '&f_total_area=' . intval($_REQUEST['f_total_area']);
}
if (isset($_REQUEST['f_city']) && isset($_REQUEST['f_city_id'])) {
$params .= '&f_city=' . clearTextData($_REQUEST['f_city']);
$params .= '&f_city_id=' . intval($_REQUEST['f_city_id']);
}
if (isset($_REQUEST['f_photo'])) {
$params .= '&f_photo=' . intval($_REQUEST['f_photo']);
}
if (isset($_SESSION['direction'])) {
$direction = $_SESSION['direction'] == 'ASC' ? 'ASC' : 'DESC';
$arrow = $direction == 'ASC' ? '↓' : '↑';
$direction = 'direction=' . $direction;
} else {
$direction = '';
$arrow = '';
}
$arrow_date = '';
$arrow_price = '';
if ($sort == 'updated_on') {
$arrow_date = $arrow;
} else {
if ($sort == 'price') {
$arrow_price = $arrow;
}
}
$amount = House::getAmountInList($where . " GROUP BY f.id");
$paginator = self::paginator("house.html?action={$action}" . $params, $amount, $per_page, $current_page);
$html = "\n\t\tНайдено {$amount} объявлений:\n\t\t<br>\t\t\t\t\t\t\n\t\t<table class='table table-striped table-bordered table-condensed'>\n\t\t<thead>\n\t\t <tr>\n\t\t <th>Адрес</th>\n\t\t <th><a href='/house.html?action={$action}&sort=price" . $params . "'><b>Цена(руб.)</b></a>{$arrow_price}<br>руб./м<sup>2</sup></th>\n\t\t <th>Этажей</th>\t\t \t\t \t\t \t\t \n\t\t <th>Фото</th>\t\t \t\t \n\t\t <th>Общая м<sup>2</sup></th>\n\t\t <th>Удаленность</th>\t\t \t\t \n\t\t <th>Описание</th>\n\t\t <th><a href='/house.html?action={$action}&sort=updated_on" . $params . "'><b>Дата</b></a>{$arrow_date}</th>\t\t \n\t\t <th></th>\n\t\t </tr>\n\t\t</thead>\n\t\t<tbody>\n\t\t";
$ids = array();
$db_res = House::getFullListLink($where_param);
$tenement_icons = array('derevo', 'kirpich', 'monolit', 'block');
while ($row = $db_res->fetchRow()) {
$ids[] = $row['id'];
$type_name = House::$TYPE[$row['type_id']];
$type = $tenement_icons[$row['type_id']];
$type = "<img src='/images/icon_{$type}.png' title='{$type_name}'>";
$price = number_format($row['price'], 0);
$price_m = number_format($row['price_m'], 0);
//$city = ($row['city_id']==0) ? '' : $row['city'].',';
//$addr = "{$row['city']} {$row['street']}";
$addr = "{$row['city']}";
//$hr = ($desc_all!='') ? '<hr>' : '';
//$description = $desc_all.$hr.$row['contacts'];
$is_owner = $row['is_owner'] ? '<br><b>Собственник</b>' : '';
$description = textReduce($row['description']) . $is_owner;
$flat_url = "/house.html?action=view&id={$row['id']}";
$photo_html = $row['photo'] != '' ? "<a href='{$flat_url}'><img src='/" . PHOTOS_WEBPATH . HOUSE . "/" . $row['id'] . "/" . $row['photo'] . "_prev'></a>" : 'Нет фото';
$date = explode(' ', $row['updated_on']);
$dates = explode('-', $date[0]);
$date = $dates[2] . '.' . $dates[1];
//.'.'.$dates[0]
$url_del = !isset($_SESSION['admin']) ? '' : '<br><br><a href="javascript:delObject(' . $row['id'] . ');">Удалить</a>';
if ($user_id) {
$url_del .= ' <a href="javascript:update(' . $row['id'] . ');" title="Обновить дату на текущую"><img src="/images/icon_update.png" title="Обновить дату на сегодняшнюю"></a>';
$url_del .= ' <a href="house.html?action=edit&id=' . $row['id'] . '"><img src="/images/icon_edit.png" title="Редактировать"></a>';
$url_del .= ' <a href="javascript:remove(' . $row['id'] . ');"><img src="/images/icon_delete.png" title="Снять"></a>';
$url_del .= ' <a href="javascript:sold(' . $row['id'] . ');"><img src="/images/icon_sold.png" title="Продано"></a>';
}
$dist = $row['dist'] > 0 ? $row['dist'] . ' км' : '';
$html .= "<tr>\n\t\t\t<td><a href='{$flat_url}'>{$addr}</a></td>\t\t\t\t\t\t\n\t\t\t<td><b>{$price}</b><br><br>{$price_m}</td>\n\t\t\t<td>{$row['storeys']}<br>{$type}</td>\t\t\t\n\t\t\t<td>{$photo_html}</td>\t\t\t\n\t\t\t<td>{$row['total_area']}</td>\n\t\t\t<td>{$dist}</td>\t\t\t\t\n\t\t\t<td>{$description}</td>\n\t\t\t<td>{$date}</td>\n\t\t\t<td><a href='{$flat_url}'><img src='/images/icon_view.png' title='Смотреть'></a>{$url_del}</td>\n\t\t\t</tr>\t\t\t\n\t\t\t";
}
$html .= "</tbody></table>\n\t\t<div>{$paginator}</div>\t\t\n\t\t";
return array('html' => $html, 'ids' => $ids);
}
function getLandListByCity($param)
{
global $config;
$id = intval($param['id']);
if (isset($_SESSION['user_id']) && in_array($_SESSION['user_id'], $config['user_workers'])) {
$is_editor = true;
$h = '<th></th>';
} else {
$is_editor = false;
$h = '';
}
if (!$is_editor) {
$limit = 3;
} else {
$limit = 30;
}
$html = '
История продаж в этом населенном пункте:<br><br>
<table class="table table-striped table-bordered table-condensed"><thead>
<tr>
<th>Дата</th><th>Цена (руб.)</th></th><th>Площадь (соток)</th><th>Описание</th>' . $h . '
</tr></thead>';
$db_res = Land::getFullListLink("f.city_id={$id} AND f.status=" . REALTY_STATUS_SALE . " GROUP BY f.id ORDER BY updated_on DESC LIMIT {$limit}");
while ($row = $db_res->fetchRow()) {
$html .= '<tr>';
$date = formatDate($row['updated_on']);
$t = $is_editor ? '<td><a href="/land.html?action=updateDate&id=' . $row['id'] . '" title="Обновить дату"><img src="/images/icon_update.png"></a></td>' : '';
$price = number_format($row['price'], 0);
$description = textReduce($row['description']);
$html .= "<td><a href='/land.html?action=view&id={$row['id']}' title='смотреть'>{$date}</a></td><td>{$price}</td><td>{$row['area']}</td><td>{$description}</td>{$t}";
$html .= '</tr>';
}
$html .= '</table>';
if (isset($date)) {
echo $html;
} else {
echo '';
}
}
