$sql = " date BETWEEN '" . (!empty($date_debut) ? $date_debut : "0000-00-00") . "' AND '" . (!empty($date_fin) ? $date_fin : "2027-01-01") . "'";
return $sql;
}
}
if ($filtreDateDebut != '') {
$filtre_date_debut = $filtreDateDebut;
$filtre_date_fin = $filtreDateFin;
}
//CSql::between($filtre_date_debut, $filtre_date_fin);
if ($_GET['recherche'] == '') $filtre = "etat like '" . $filtre_etat . "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin);
else $filtre = "nom_ent like '".$_GET['recherche']."%'";
//print_r($filtre);
$r_rdv = CTablContact::select("*", $filtre, $order);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Rdv<!-- InstanceEndEditable --></div>
</div>
</div>
<div id="contentarea">
<div id="left"><?php include("../nav/menu_g.php"); ?></div>
<div id="center">
<div id="page"><!-- InstanceBeginEditable name="page" --><?php echo CHtml::get_toolbar(array('add'=>0, 'cancel'=>0)) ?><!-- InstanceEndEditable --></div>
