set_file("page", "accueil.html");
$date = mktime();
$date = $date - ((60 * 60 * 24) * 180);
$dejaAffiche = array();
//les 5 premieres maison doivent avoir une photo
$proprietesPhoto = array();
$result = $CP["sql"]->Execute("SELECT * FROM proprietes WHERE proprieteDate >= '$date' AND proprieteActif=1 AND proprietePhotoType <> '' ORDER BY proprieteDate DESC LIMIT 0,5");
while (!$result->EOF) {
//on stock le ID pour ne pas l'afficher 2 fois
/* */
// Nom associé au ID Type de propriété, si n'a pas, alors
// prend la valeur de la variable ProprieteTypeAutre
$result2 = $CP["sql"]->Execute("SELECT * FROM propriete_types WHERE typeID='" . $result->fields["proprieteType"] . "'");
$result->fields["proprieteType"] = $result2->fields["typeNom"];
if ($result->fields["proprieteType"] == "") $result->fields["proprieteType"] = $result->fields["proprieteTypeAutre"];
// ville ... si pas de ville associé au ID alors afficher proprieteVilleAutre
$result2 = $CP["sql"]->Execute("SELECT * FROM propriete_villes WHERE villeID='" . $result->fields["proprieteVille"] . "'");
$sVille = $result2->fields["villeNom"];
if ($sVille == "") $sVille = $result->fields["proprieteVilleAutre"];
$oRegion = $CP["sql"]->Execute("SELECT * FROM propriete_regions WHERE regionID='" . $result->fields["proprieteRegion"] . "'");
$sRegion = $oRegion->fields["regionNom"];
if ($result->fields['proprieteVendu'] == 0 ) {
$result->fields['proprieteImage'] = "fields['proprieteID']}\">![](\"showimg.php?Z=1&A={$result-)
fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\">";
$result->fields['proprietePrix'] = str_replace(",", " ", number_format(str_replace(" ", "", $result->fields['proprietePrix']))) . "$";
if($result->fields['proprieteOptionsPrix'] != 0){
$oOptionPrix = $CP["sql"]->Execute("SELECT optionNom FROM options_prix WHERE optionID = '" . $result->fields['proprieteOptionsPrix']. "'");
$result->fields['proprieteOptionsPrix'] = ", " . $oOptionPrix->fields['optionNom'];
} else {
$result->fields['proprieteOptionsPrix'] = "";
}
$result->fields['proprieteNum'] = "#" . $result->fields['proprieteID'];
$result->fields['proprieteAdresse'] = stripslashes($sVille). ", ".stripslashes($sRegion);
$result->fields['boutonDetails'] = "fields['proprieteID']}\">![\"details\"](\"images/boutons/bt_details.gif\")
fields['proprieteID']}\" border=\"0\">";
} else {
$result->fields['proprieteImage'] = "fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\">";
$result->fields['proprieteNum'] = "VENDU! ";
$result->fields['proprietePrix'] = "";
$result->fields['proprieteAdresse'] = "$sVille, $sRegion";
$result->fields['boutonDetails'] = " ";
}
/* */
$dejaAffiche[] = $result->fields["proprieteID"];
$proprietesPhoto[] = $result->fields;
$result->MoveNext();
}
// !PUBLICITE HERE!
//5 autres propriete ... avec ou sans photo
$proprietesAutre = array();
$count = 0;
$result = $CP["sql"]->Execute("SELECT * FROM proprietes WHERE proprieteDate >= '$date' AND proprieteActif=1 ORDER BY proprieteDate DESC");
while ((!$result->EOF) && $count < 5) {
//il faut verifier si il est deja afficher, sinon on passe par dessus
//echo array_search($result->fields["proprieteID"], $dejaAffiche);
if ( in_array($result->fields["proprieteID"], $dejaAffiche)) {
$result->MoveNext();
continue;
}
//ok
$count++;
//------- debut cut&paste de la setion plus haut------///
// Nom associé au ID Type de propriété, si n'a pas, alors
// prend la valeur de la variable ProprieteTypeAutre
$result2 = $CP["sql"]->Execute("SELECT * FROM propriete_types WHERE typeID='" . $result->fields["proprieteType"] . "'");
$result->fields["proprieteType"] = $result2->fields["typeNom"];
if ($result->fields["proprieteType"] == "") $result->fields["proprieteType"] = $result->fields["proprieteTypeAutre"];
// ville ... si pas de ville associé au ID alors afficher proprieteVilleAutre
$result2 = $CP["sql"]->Execute("SELECT * FROM propriete_villes WHERE villeID='" . $result->fields["proprieteVille"] . "'");
$sVille = $result2->fields["villeNom"];
if ($sVille == "") $sVille = $result->fields["proprieteVilleAutre"];
$oRegion = $CP["sql"]->Execute("SELECT * FROM propriete_regions WHERE regionID='" . $result->fields["proprieteRegion"] . "'");
$sRegion = $oRegion->fields["regionNom"];
if ($result->fields['proprieteVendu'] == 0 ) {
$result->fields['proprieteImage'] = "fields['proprieteID']}\">fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\">";
$result->fields['proprietePrix'] = str_replace(",", " ", number_format(str_replace(" ", "", $result->fields['proprietePrix']))) . "$";
if($result->fields['proprieteOptionsPrix'] != 0){
$oOptionPrix = $CP["sql"]->Execute("SELECT optionNom FROM options_prix WHERE optionID = '" . $result->fields['proprieteOptionsPrix']. "'");
$result->fields['proprieteOptionsPrix'] = ", " . $oOptionPrix->fields['optionNom'];
} else {
$result->fields['proprieteOptionsPrix'] = "";
}
$result->fields['proprieteNum'] = "#" . $result->fields['proprieteID'];
$result->fields['proprieteAdresse'] = "$sVille, $sRegion";
$result->fields['boutonDetails'] = "fields['proprieteID']}\">fields['proprieteID']}\" border=\"0\">";
} else {
$result->fields['proprieteImage'] = "fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\">";
$result->fields['proprieteNum'] = "VENDU! ";
$result->fields['proprietePrix'] = "";
$result->fields['proprieteAdresse'] = stripslashes($sVille). ", ".stripslashes($sRegion);
$result->fields['boutonDetails'] = " ";
}
//------- fin cut&paste------///
$proprietesAutre[] = $result->fields;
$result->MoveNext();
}
$CP["tpl"]->set_loop("proprietesPhoto", $proprietesPhoto);
$CP["tpl"]->set_loop("proprietesAutre", $proprietesAutre);
// affichage du rendu
print $CP["tpl"]->process("", "page", 2);
?>