"._("travaux_archive"); 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."travaux_archive LEFT JOIN ".DB_PREFIXE."travaux_nature ON travaux_archive.naturetravaux=travaux_nature.travaux_nature "; // SELECT $champAffiche = array( 'travaux_archive.travaux as "'._("travaux").'"', 'travaux_archive.entreprise as "'._("entreprise").'"', 'to_char(travaux_archive.datedebinter ,\'DD/MM/YYYY\') as "'._("datedebinter").'"', 'to_char(travaux_archive.datefininter ,\'DD/MM/YYYY\') as "'._("datefininter").'"', 'travaux_archive.naturedemandeur as "'._("naturedemandeur").'"', 'travaux_nature.libelle as "'._("naturetravaux").'"', ); // $champNonAffiche = array( 'travaux_archive.emplacement as "'._("emplacement").'"', 'travaux_archive.observation as "'._("observation").'"', ); // $champRecherche = array( 'travaux_archive.travaux as "'._("travaux").'"', 'travaux_archive.entreprise as "'._("entreprise").'"', 'travaux_archive.naturedemandeur as "'._("naturedemandeur").'"', 'travaux_nature.libelle as "'._("naturetravaux").'"', ); $tri="ORDER BY travaux_archive.entreprise ASC NULLS LAST"; $edition="travaux_archive"; $selection=''; if ($retourformulaire== 'travaux_nature') { $selection=" WHERE (travaux_archive.naturetravaux ='".$idx."')"; } ?>