public static function findBusiness($strLink, $strSQL)
{
$curPage = 1;
if (isset($_REQUEST['page'])) {
$curPage = $_REQUEST['page'];
}
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
$strCountSQL = str_replace("*", " count(*) ", $strSQL);
$totalItems = DichVuBUS::countAllBySQL($strCountSQL);
$strSQL .= " limit {$offset},{$maxItems}";
$business = DichVuBUS::getAllBySQL($strSQL);
if (isset($_REQUEST['cbbGia']) && $_REQUEST['cbbGia'] != -1) {
$array = null;
switch ($_REQUEST['cbbGia']) {
case 1:
$array = BusinessProcessor::findPrice($business, 0, 5000000);
break;
case 2:
$array = BusinessProcessor::findPrice($business, 5000000, 50000000);
break;
case 3:
$array = BusinessProcessor::findPrice($business, 50000000, 500000000);
break;
case 4:
$array = BusinessProcessor::findPrice($business, 500000000, 1000000000);
break;
case 5:
$array = BusinessProcessor::findPrice($business, 1000000000, 1500000000);
break;
case 6:
$array = BusinessProcessor::findPrice($business, 1500000000, 3000000000.0);
break;
case 7:
$array = BusinessProcessor::findPrice($business, 3000000000.0, 10000000000.0);
break;
case 8:
$array = BusinessProcessor::findPrice($business, 10000000000.0, 999999999999999.0);
break;
}
$business = $array;
$totalItems = count($business);
}
return BusinessProcessor::display($strLink, $business, $totalItems, $curPage, $maxPages, $maxItems);
}
public static function loadByType($curPage, $type)
{
$totalItems = null;
$business = null;
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
if ($type > 0) {
$business = DichVuBUS::getAllBySQL("select * from dichvu where loaidv={$type} limit {$offset},{$maxItems}");
$totalItems = DichVuBUS::countAllBySQL("select count(*) from dichvu where loaidv={$type}");
} else {
$business = DichVuBUS::getAllBySQL("select * from dichvu limit {$offset},{$maxItems}");
$totalItems = DichVuBUS::countAllBySQL("select count(*) from dichvu");
}
$display = HouseProcessor::displayHeader($totalItems);
$display .= HouseProcessor::display($business);
$display .= HouseProcessor::displayFooter();
$strPaging = Utils::paging('', $totalItems, $curPage, $maxPages, $maxItems);
return $display . $strPaging;
}
echo "<br>phuong=" . $_COOKIE["ccbPhuongXa"];
if ($quan == -1) {
$quan = 25;
$phuong = 23;
}
if ($phuong == -1) {
//$quan = 25;
$phuong = 23;
}
//add or update into dichvu
if (isset($_GET['update']) && $_GET['update'] != null) {
$rank_Update = DichVuBUS::select($_GET['update']);
$rs = DichVuBUS::Update($_GET['update'], $tieude, $mota, $chusohuu, $phuong, $quan, $tinh, $time, $timeupdate, $duong, $dai, $rong, $tang, $phongngu, $phongtam, $giaban, $donvitien, $rank_Update['status'], $thoihandangtin, $loainha, $phaply, $huongnha, $khuyenmai, $loaiDV, $donviDV, $X, $Y, $khanang, $rank_Update['rank'], $sonha);
echo "<br>rs in update=" . $rs;
} else {
$rs = DichVuBUS::Add($tieude, $mota, $chusohuu, $phuong, $quan, $tinh, $time, $timeupdate, $duong, $dai, $rong, $tang, $phongngu, $phongtam, $giaban, $donvitien, $status, $thoihandangtin, $loainha, $phaply, $huongnha, $khuyenmai, $loaiDV, $donviDV, $X, $Y, $khanang, $rank, $sonha);
echo "<br>rs in add=" . $rs;
}
if ($rs == false) {
$flagInsert = false;
echo "Can't insert or update into database.Please check again!";
}
//check and update or add into dichvu_tienich table
if (isset($_GET['update']) && $_GET['update'] != null) {
$dv_tienich = DichVu_TienIchBUS::getAllByIDDichVu($_GET['update']);
for ($i = 0; $i < count($dv_tienich); $i++) {
$kqDelete = DichVu_TienIchBUS::Delete($dv_tienich[$i][0]);
}
$rs = $_GET['update'];
}
if (isset($_POST["cbId"]) && count($_POST["cbId"]) > 0) {
public static function loadByType($curPage, $loaidv, $ngayfrom, $ngayto)
{
$totalItems = null;
$business = null;
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
$condition = VipProcessor::getCondition($loaidv, $ngayfrom, $ngayto);
$business = DichVuBUS::getAllBySQL("select * from dichvu where status=2 " . $condition . " limit {$offset},{$maxItems}");
$totalItems = DichVuBUS::countAllBySQL("select count(*) from dichvu where status=2 " . $condition);
$display = VipProcessor::displayHeader($totalItems);
$display .= VipProcessor::display($business);
$display .= VipProcessor::displayFooter();
$strPaging = Utils::paging('', $totalItems, $curPage, $maxPages, $maxItems);
return $display . $strPaging;
}
<p class="menu_item">
<a href="thongtinkhachhang.php">Thông tin thành viên</a></p>
<p class="menu_item">
<a href="doimatkhau.php">Thay đổi mật khẩu</a></p>
<p class="menu_item">
<a href="noiquidangtin.php">Đăng tin nhà đất</a></p>
<p class="menu_item">
<a href="tindadang.php?type=1">Nâng cấp tin VIP</a></p>
<p class="menu_item">
<?php
include_once "../BUS/DichVuBUS.php";
if (isset($curUserId)) {
$vip = (int) DichVuBUS::countStatusType(2, $curUserId);
$daduyet = (int) DichVuBUS::countStatusType(1, $curUserId);
$choduyet = (int) DichVuBUS::countStatusType(0, $curUserId);
$hethan = (int) DichVuBUS::countStatusType(3, $curUserId);
$tongcong = $vip + $daduyet + $choduyet + $hethan;
echo "<a href='tindadang.php'>Các tin đã đăng (" . $tongcong . ")</a><br>";
echo "<span><a href='tindadang.php?type=2'>- Tin VIP (" . $vip . ")</a><br>";
echo "<a href='tindadang.php?type=1'>- Tin đã duyệt (" . $daduyet . ")</a><br>";
echo "<a href='tindadang.php?type=0'>- Tin chờ duyệt (" . $choduyet . ")</a><br>";
echo "<a href='tindadang.php?type=3' style='color:red;'>- Tin hết hạn (" . $hethan . ")</a><br></span>";
} else {
header("Location:dichvu.php");
}
?>
</p>
</td>
</tr>
</table>
<?php
if (isset($_REQUEST["idtin"]) && $_REQUEST["idtin"] != null) {
$PATH_BASE = str_replace('//', '/', dirname(__FILE__) . '/');
include_once $PATH_BASE . '../../BUS/DichVuBUS.php';
$user = DichVuBUS::UpdateStatus($_REQUEST["idtin"], -1);
if ($user == true) {
echo "abc";
}
}
<?php
}
}
?>
</div>
<hr width="680" size="1" style="color: rgb(211, 232, 248);">
<div style="padding:20px 0;">
<center>
<table class="table" border="0">
<tr>
<td align="right">Mã số tin rao:</td>
<td align="left">
<b><?php
if (isset($_GET['iddv'])) {
include_once "../BUS/DichVuBUS.php";
$process = DichVuBUS::select($_GET['iddv']);
echo $_GET['iddv'];
}
?>
</b>
</td>
</tr>
<tr>
<td align="right">Tiêu đề tin rao:</td>
<td align="left">
<b><?php
if (isset($_GET['iddv'])) {
echo $process['tieude'];
}
?>
</b>
<div style="width: 686px;float:left;" >
<div style="margin-left: 10px; margin-top: 10px; font-family: tahoma; font-size: 18px;
font-weight: bold; color:#890C29;">
CĂN HỘ NỔI BẬT
</div>
<hr width="680" size="1" style="color: rgb(211, 232, 248);">
<?php
include_once "../BUS/DichVuBUS.php";
include_once "../BUS/HinhAnhBUS.php";
$canho = DichVuBUS::getCanHoNoiBat();
?>
<div class="mid_content">
<?php
for ($i = 0; $i < count($canho); $i++) {
if ($i < 4) {
$hinhanh = HinhAnhBUS::getAllHinhAnhByDichVuID($canho[$i]['id']);
echo "<div style='width:170px;float:left;'>";
echo "<a class='chnoibat' href='chitietdiaoc.php?iddichvu=" . $canho[$i]['id'] . "'>";
echo "<img src='../" . $hinhanh[0]['path'] . "' style='height:100px; width:160px;'/><br>";
echo "<b style='color: #006DB9;'>" . $canho[$i]['tieude'] . "</b>";
echo "</a></div>";
} else {
break;
}
}
?>
</div>
<div style="clear:both;">
<table bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="986;">
<tr>
<td style="border-right: 1px solid rgb(180, 215, 232); background-repeat: repeat-y;"
background="1_files/menubg_all.jpg" valign="top" width="270">
<?php
include "../include/box_left_thanhvien.php";
?>
</td>
<td style="padding: 10px;" valign="top">
<div style="width: 686px;">
<div id="messLoaiDangTin" name="messLoaiDangTin" style="margin-left: 10px; margin-top: 10px; font-family: tahoma; font-size: 18px;font-weight: bold; color:#890C29;">
<?php
$ltdv = $_GET['loaidvcandang'];
if (isset($_GET['update']) && $_GET['update'] != null) {
echo "Cập Nhật ";
$capnhatDV = DichVuBUS::select($_GET['update']);
}
if ($ltdv == 1) {
echo "Đăng Tin Cần Bán";
} else {
if ($ltdv == 2) {
echo "Đăng Tin Cần Mua";
} else {
if ($ltdv == 3) {
echo "Đăng Tin Cho Thuê";
} else {
echo "Đăng Tin Cần Thuê";
}
}
}
?>
<div class="br"></div>
<div class="bm"></div>
</div>
<?php
include_once "../BUS/DichVuBUS.php";
include_once "../BUS/LoaiDVBUS.php";
include_once "../BUS/TinhBUS.php";
include_once "../BUS/QuanBUS.php";
include_once "../BUS/PhuongBUS.php";
include_once "../BUS/DonViTienBUS.php";
include_once "../BUS/LoaiNhaBUS.php";
include_once "../module/Utils/Utils.php";
include_once "../BUS/HuongNhaBUS.php";
include_once "../BUS/PhapLyBUS.php";
include_once "../BUS/HinhAnhBUS.php";
$objCanHo = DichVuBUS::select($_REQUEST["aid"]);
$loaidv = LoaiDVBUS::GetLoaiDVByID($objCanHo["loaidv"]);
$tinh = TinhBUS::getTinhById($objCanHo["tinh"]);
$quan = QuanBUS::getQuanById($objCanHo["quan"]);
$phuong = PhuongBUS::getPhuongById($objCanHo["phuong"]);
$donvitien = DonViTienBUS::selectId($objCanHo["donvitien"]);
$loainha = LoaiNhaBUS::getById($objCanHo["loainha"]);
$huongnha = HuongNhaBUS::GetHuongNhaById($objCanHo["huongnha"]);
$phaply = PhapLyBUS::GetPhapLyById($objCanHo["phaply"]);
$hinhanh = HinhAnhBUS::getAllHinhAnhByDichVuID($objCanHo['id']);
?>
<div style="margin:10px">
<div class="tl"></div>
<div class="tr"></div>
<div class="tm"></div>
<div class="mid">
echo "upload picture finish!";
}
}
}
$length = strlen($_COOKIE["url"]);
$url = $_COOKIE["url"];
$url[$length - 1] = 3;
header("Location:" . $url);
}
if (isset($_GET["action"])) {
$action = $_GET["action"];
switch ($action) {
case "delete":
$uid = explode(',', $_GET["uid"]);
for ($i = 0; $i < count($uid); $i++) {
DichVuBUS::delete($uid[$i]);
}
break;
case "noibat1":
include "../../../BUS/TinDangBUS.php";
$aid = $_GET["idtin"];
TinDangBUS::setTinDangNoiBat($aid, 1);
break;
case "noibat0":
include "../../../BUS/TinDangBUS.php";
$aid = $_GET["idtin"];
TinDangBUS::setTinDangNoiBat($aid, 0);
break;
case "status":
include "../../../BUS/TinDangBUS.php";
include "../../../BUS/DichVuVIPBUS.php";
<?php
$business = null;
if (isset($_REQUEST['iddichvu'])) {
include_once "../BUS/DichVuBUS.php";
include_once "../BUS/HinhAnhBUS.php";
include_once "../BUS/DonviDichVuBUS.php";
include_once "../BUS/DonViTienBUS.php";
include_once "../BUS/TinhBUS.php";
include_once "../BUS/QuanBUS.php";
include_once "../BUS/PhuongBUS.php";
include_once "Utils/Utils.php";
include_once "../BUS/LoaiDVBUS.php";
include_once "../BUS/LoaiNhaBUS.php";
include_once "../BUS/PhapLyBUS.php";
include_once "../BUS/HuongNhaBUS.php";
$business = DichVuBUS::select($_REQUEST['iddichvu']);
$quan = QuanBUS::getQuanById($business['quan']);
$phuong = PhuongBUS::getPhuongById($business['phuong']);
$tinh = TinhBUS::getTinhById($business['tinh']);
$loaidichvu = LoaiDVBUS::GetLoaiDVByID($business['loaidv']);
$loainha = LoaiNhaBUS::getById($business['loainha']);
$phaply = PhapLyBUS::GetPhapLyById($business['phaply']);
$huongnha = HuongNhaBUS::GetHuongNhaById($business['huongnha']);
$donvitien = DonViTienBUS::selectId($business['donvitien']);
$hinhanh = HinhAnhBUS::getAllHinhAnhByDichVuID($business['id']);
// echo count($hinhanh);
// echo "<br>aaaaaaaaa=".$hinhanh[0]['path'];
}
?>
<div style="width: 686px; padding-top:20px;float:left;">
<div style="margin-left: 10px; margin-top: 10px; font-family: tahoma; font-size: 18px;
public static function findSearchContext2($strLink, $strSQL)
{
$curPage = 1;
$totalItems = null;
$business = null;
if (isset($_REQUEST['page'])) {
$curPage = $_REQUEST['page'];
}
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
$strCountSQL = str_replace("*", " count(*) ", $strSQL);
$totalItems = DichVuBUS::countAllBySQL($strCountSQL);
$strSQL .= " limit {$offset},{$maxItems}";
$business = DichVuBUS::getAllBySQL($strSQL);
return MessageTypeProcessor::display($strLink, $business, $totalItems, $curPage, $maxPages, $maxItems);
}
