"._("consultation"); if(!isset($premier)) $premier=''; if(!isset($recherche1)) $recherche1=''; if(!isset($tricolsf)) $tricolsf=''; if(!isset($premiersf)) $premiersf=''; if(!isset($selection)) $selection=''; if(!isset($retourformulaire)) $retourformulaire=''; if (isset($idx) && $idx != ']' && trim($idx) != '') { $ent .= "-> ".$idx." "; } if (isset($idz) && trim($idz) != '') { $ent .= " ".strtoupper($idz)." "; } // FROM $table = DB_PREFIXE."consultation LEFT JOIN ".DB_PREFIXE."avis ON consultation.avis=avis.avis LEFT JOIN ".DB_PREFIXE."dossier ON consultation.dossier=dossier.dossier LEFT JOIN ".DB_PREFIXE."service ON consultation.service=service.service "; // SELECT $champAffiche = array( 'consultation.consultation as "'._("consultation").'"', 'dossier.nature as "'._("dossier").'"', 'service.libelle as "'._("service").'"', 'to_char(consultation.date_envoi ,\'DD/MM/YYYY\') as "'._("date_envoi").'"', 'to_char(consultation.date_retour ,\'DD/MM/YYYY\') as "'._("date_retour").'"', 'avis.libelle as "'._("avis").'"', 'to_char(consultation.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', ); // $champNonAffiche = array( ); // $champRecherche = array( 'consultation.consultation as "'._("consultation").'"', 'dossier.libelle as "'._("dossier").'"', 'service.libelle as "'._("service").'"', 'avis.libelle as "'._("avis").'"', ); $tri="ORDER BY dossier.nature ASC NULLS LAST"; $edition="consultation"; $selection=''; if ($retourformulaire== 'avis') { $selection=" WHERE (consultation.avis ='".$idx."')"; } if ($retourformulaire== 'dossier') { $selection=" WHERE (consultation.dossier ='".$idx."')"; } if ($retourformulaire== 'service') { $selection=" WHERE (consultation.service ='".$idx."')"; } ?>