dbConnect);
$DB2 = new UsrDbClass($SYS->dbConnect2);
//新着物件
$tmp = NULL;
$sql = "SELECT * FROM estate WHERE `disable`='0' AND cday!='0000-00-00 00:00:00' AND `newOrUsed`='1' ORDER BY num LIMIT 20 ";
$tmp = $DB->select($sql);
if(is_array($tmp)){
$c = 0;
foreach($tmp as $key => $val){
if($key == "0"){
$lastDay = date("Y/m/d", strtotime($val["cday"]));
}
$c++;
if($val["price1Unit"] == 1){
$dataPrice1 = "万円";
}else{
$dataPrice1 = "円";
}
//$dataPrice1 = number_format($DB->priceUnitDe($val["price1"],$val["price1Unit"])).$dataPrice1;
if($val["price1"]){
$dataPrice1 = " ".number_format($DB->priceUnitDe($val["price1"],$val["price1Unit"])).$dataPrice1;
}else{
$dataPrice1 = " ";
}
if($val["price1"]){
if($val["price1"] == $val["price2"] AND $val["price1Unit"] == $val["price2Unit"]){
$dataPrice2 = "";
}elseif($val["price2"]){
if($val["price2Unit"] == 1){
$dataPrice2 = "万円";
}else{
$dataPrice2 = "円";
}
$dataPrice2 = "～".number_format($DB->priceUnitDe($val["price2"],$val["price2Unit"])).$dataPrice2;
}else{
$dataPrice2 = "";
}
}
/*
if($val["price2"]!=0){
if($val["price2Unit"] == 1){
$dataPrice2 = "万円";
}else{
$dataPrice2 = "円";
}
$dataPrice2 = "～".number_format($DB->priceUnitDe($val["price2"],$val["price2Unit"])).$dataPrice2;
}else{
$dataPrice2 = "";
}
*/
if($c == 3 ){
$recommend .= '
';
$c=1;
}
$Space = $DB->dbView($val["Space"]) ? $val["Space"]." ㎡ " : $none;
$Space .= ($DB->dbView($val["Space"]) AND $DB->dbView($val["Space2"])) ? $FORM->buildSpace($val["Space2"]) : false;
$newEstate .= '
- '.$val['address'].'
- '.$val['stationName1'].'
';
}
}
?>
<?PHP print $SYS->siteTitle;?>
siteAnalytics;?>