"._("travaux"); 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 LEFT JOIN ".DB_PREFIXE."nature ON travaux.nature=nature.nature "; // SELECT $champAffiche = array( 'travaux.travaux as "'._("travaux").'"', 'travaux.libelle as "'._("libelle").'"', 'nature.libelle as "'._("nature").'"', 'travaux.codelascot as "'._("codelascot").'"', 'travaux.solde as "'._("solde").'"', ); // $champNonAffiche = array( ); // $champRecherche = array( 'travaux.travaux as "'._("travaux").'"', 'travaux.libelle as "'._("libelle").'"', 'nature.libelle as "'._("nature").'"', 'travaux.codelascot as "'._("codelascot").'"', 'travaux.solde as "'._("solde").'"', ); $tri="ORDER BY travaux.libelle ASC NULLS LAST"; $edition="travaux"; $selection=''; if ($retourformulaire== 'nature') { $selection=" WHERE (travaux.nature ='".$idx."')"; } $sousformulaire = array( 'dossier',); ?>