"._("evenement"); 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."evenement LEFT JOIN ".DB_PREFIXE."action ON evenement.action=action.action LEFT JOIN ".DB_PREFIXE."avis ON evenement.avis=avis.avis LEFT JOIN ".DB_PREFIXE."etat ON evenement.etat=etat.etat LEFT JOIN ".DB_PREFIXE."nature ON evenement.nature=nature.nature "; // SELECT $champAffiche = array( 'evenement.evenement as "'._("evenement").'"', 'evenement.libelle as "'._("libelle").'"', 'nature.libelle as "'._("nature").'"', 'action.libelle as "'._("action").'"', 'etat.libelle as "'._("etat").'"', 'evenement.delai as "'._("delai").'"', 'evenement.accord_tacite as "'._("accord_tacite").'"', 'evenement.delai_notification as "'._("delai_notification").'"', 'avis.libelle as "'._("avis").'"', 'evenement.lettretype as "'._("lettretype").'"', 'evenement.consultation as "'._("consultation").'"', ); // $champNonAffiche = array( ); // $champRecherche = array( 'evenement.evenement as "'._("evenement").'"', 'evenement.libelle as "'._("libelle").'"', 'nature.libelle as "'._("nature").'"', 'action.libelle as "'._("action").'"', 'etat.libelle as "'._("etat").'"', 'evenement.delai as "'._("delai").'"', 'evenement.accord_tacite as "'._("accord_tacite").'"', 'evenement.delai_notification as "'._("delai_notification").'"', 'avis.libelle as "'._("avis").'"', 'evenement.lettretype as "'._("lettretype").'"', 'evenement.consultation as "'._("consultation").'"', ); $tri="ORDER BY evenement.libelle ASC NULLS LAST"; $edition="evenement"; $selection=''; if ($retourformulaire== 'action') { $selection=" WHERE (evenement.action ='".$idx."')"; } if ($retourformulaire== 'avis') { $selection=" WHERE (evenement.avis ='".$idx."')"; } if ($retourformulaire== 'etat') { $selection=" WHERE (evenement.etat ='".$idx."')"; } if ($retourformulaire== 'nature') { $selection=" WHERE (evenement.nature ='".$idx."')"; } $sousformulaire = array( 'bible', 'instruction',); ?>