setFlag("htmlonly");
$f->display();
$f->displayStartContent();
// *** get
$formatDate="AAAA-MM-JJ";
$idx=$_GET['idx'];
$evenement=$_GET['ev'];
$DEBUG=0;
// *** extraction consultation
$consultation=$f->db->getOne("select consultation from ".DB_PREFIXE."evenement where evenement=".$evenement);
$f->isDatabaseError($res);
if($consultation=='Oui'){
$sql="select date_retour,avis.libelle as avis,
service.libelle as service
from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service
on consultation.service =service.service
left join ".DB_PREFIXE."avis on consultation.avis = avis.avis
where dossier ='".$idx."'";
if ($DEBUG==1)
echo $sql;
$res = $f->db->query($sql);
$f->isDatabaseError($res);
if ($DEBUG == 1)
echo "La requete ".$sql." est executee";
$temp="";
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
// date retour
if ($row['date_retour']<>""){
if ($formatDate=="AAAA-MM-JJ"){
$date = explode("-", $row['date_retour']);
// controle de date
if (sizeof($date) == 3 and (checkdate($date[1],$date[2],$date[0]))) {
$date_retour_f= $date[2]."/".$date[1]."/".$date[0];
$correct=true;
}else{
$msg= $msg."
La date ".$row['date_retour']." n'est pas une date.";
$correct=false;
}
}
}
$temp="Vu l'avis ".$row['avis']." du service ".$row['service'];
if($correct==true)
$temp=$temp." du ".$date_retour_f;
?>
db->query($sql);
$f->isDatabaseError($res);
if ($DEBUG == 1)
echo "La requete ".$sql." est executee";
$temp="";
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
$temp=$row['contenu'];
$temp0=str_replace("\r\n","|",$temp);
$temp0=str_replace("\r","|",$temp0);
$temp0=str_replace("\n","|",$temp0);
$temp1=explode("|",$temp0);
for($i=0;$i
db->query($sql);
$f->isDatabaseError($res);
if ($DEBUG == 1)
echo "La requete ".$sql." est executee";
$temp="";
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
$temp=$row['contenu'] ;
$temp0=str_replace("\r\n","|",$temp);
$temp0=str_replace("\r","|",$temp0);
$temp0=str_replace("\n","|",$temp0);
//echo "***".$temp0."***
";
$temp1=explode("|",$temp0);
for($i=0;$i