|
|
|
 |
 |
|
|
|
 |
 |
 |
 |
|
|
|
 |
 |
|
|
|
 |
 |
 |
 |
|
|
|
 |
 |
|
|
|
 |
 |
 |
 |
$select = "COUNT(*)";
$from = "immo_tblProperties
INNER JOIN immo_tblTYPCATPRT ON IMM_TYPCATPRT_PRT_ID = IMM_PRT_ID
INNER JOIN immo_tblTypes ON IMM_TYP_ID = IMM_TYPCATPRT_TYP_ID AND IMM_TYP_SystemDataId=2
";
$where = "
IMM_PRT_Active=1 AND IMM_PRT_ZichtbaarInWebsite=1
AND (IMM_PRT_ZichtbaarVanDatum IS NULL OR IMM_PRT_ZichtbaarVanDatum <= getdate())
AND (IMM_PRT_ZichtbaarTotDatum IS NULL OR IMM_PRT_ZichtbaarTotDatum >= getdate())
";
$records = getXMLData($select, $from, $where, "", "", $order, $user, $pass, $code, $projectURL);
$showTeHuur = false;
if($records){
foreach($records->getElementsByTagName('Record') as $record){
if(getValueFromXMLNode($record, "NUM_Tehuur") > 0)
{
$showTeHuur = true;
break;
}
}
}
if($showTeHuur)
{
?>
|
|
|
 |
 |
|
|
|
 |
 |
 |
 |
}
?>
|
|
|
 |
 |
|
|
|
 |
 |
 |
 |
|
|
|
 |
 |
|
|
|
 |
  |
 |
|
|
|
|
|
 |
|