"._("instruction"); 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."instruction LEFT JOIN ".DB_PREFIXE."action ON instruction.action=action.action LEFT JOIN ".DB_PREFIXE."avis ON instruction.avis=avis.avis LEFT JOIN ".DB_PREFIXE."dossier ON instruction.dossier=dossier.dossier LEFT JOIN ".DB_PREFIXE."etat ON instruction.etat=etat.etat LEFT JOIN ".DB_PREFIXE."evenement ON instruction.evenement=evenement.evenement "; // SELECT $champAffiche = array( 'instruction.instruction as "'._("instruction").'"', 'instruction.destinataire as "'._("destinataire").'"', 'to_char(instruction.datecourrier ,\'DD/MM/YYYY\') as "'._("datecourrier").'"', 'evenement.libelle as "'._("evenement").'"', 'instruction.lettretype as "'._("lettretype").'"', 'dossier.nature as "'._("dossier").'"', 'action.libelle as "'._("action").'"', 'instruction.delai as "'._("delai").'"', 'etat.libelle as "'._("etat").'"', 'instruction.accord_tacite as "'._("accord_tacite").'"', 'instruction.delai_notification as "'._("delai_notification").'"', 'avis.libelle as "'._("avis").'"', 'instruction.archive_delai as "'._("archive_delai").'"', 'to_char(instruction.archive_date_complet ,\'DD/MM/YYYY\') as "'._("archive_date_complet").'"', 'to_char(instruction.archive_date_rejet ,\'DD/MM/YYYY\') as "'._("archive_date_rejet").'"', 'to_char(instruction.archive_date_limite ,\'DD/MM/YYYY\') as "'._("archive_date_limite").'"', 'to_char(instruction.archive_date_notification_delai ,\'DD/MM/YYYY\') as "'._("archive_date_notification_delai").'"', 'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"', 'instruction.archive_etat as "'._("archive_etat").'"', 'to_char(instruction.archive_date_decision ,\'DD/MM/YYYY\') as "'._("archive_date_decision").'"', 'instruction.archive_avis as "'._("archive_avis").'"', 'to_char(instruction.archive_date_validite ,\'DD/MM/YYYY\') as "'._("archive_date_validite").'"', 'to_char(instruction.archive_date_achevement ,\'DD/MM/YYYY\') as "'._("archive_date_achevement").'"', 'to_char(instruction.archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"', 'to_char(instruction.archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"', ); // $champNonAffiche = array( 'instruction.complement as "'._("complement").'"', 'instruction.complement2 as "'._("complement2").'"', 'instruction.complement3 as "'._("complement3").'"', 'instruction.complement4 as "'._("complement4").'"', 'instruction.complement5 as "'._("complement5").'"', 'instruction.complement6 as "'._("complement6").'"', 'instruction.complement7 as "'._("complement7").'"', 'instruction.complement8 as "'._("complement8").'"', 'instruction.complement9 as "'._("complement9").'"', 'instruction.complement10 as "'._("complement10").'"', 'instruction.complement11 as "'._("complement11").'"', 'instruction.complement12 as "'._("complement12").'"', 'instruction.complement13 as "'._("complement13").'"', 'instruction.complement14 as "'._("complement14").'"', 'instruction.complement15 as "'._("complement15").'"', ); // $champRecherche = array( 'instruction.instruction as "'._("instruction").'"', 'instruction.destinataire as "'._("destinataire").'"', 'evenement.libelle as "'._("evenement").'"', 'instruction.lettretype as "'._("lettretype").'"', 'dossier.libelle as "'._("dossier").'"', 'action.libelle as "'._("action").'"', 'instruction.delai as "'._("delai").'"', 'etat.libelle as "'._("etat").'"', 'instruction.accord_tacite as "'._("accord_tacite").'"', 'instruction.delai_notification as "'._("delai_notification").'"', 'avis.libelle as "'._("avis").'"', 'instruction.archive_delai as "'._("archive_delai").'"', 'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"', 'instruction.archive_etat as "'._("archive_etat").'"', 'instruction.archive_avis as "'._("archive_avis").'"', ); $tri="ORDER BY instruction.destinataire ASC NULLS LAST"; $edition="instruction"; $selection=''; if ($retourformulaire== 'action') { $selection=" WHERE (instruction.action ='".$idx."')"; } if ($retourformulaire== 'avis') { $selection=" WHERE (instruction.avis ='".$idx."')"; } if ($retourformulaire== 'dossier') { $selection=" WHERE (instruction.dossier ='".$idx."')"; } if ($retourformulaire== 'etat') { $selection=" WHERE (instruction.etat ='".$idx."')"; } if ($retourformulaire== 'evenement') { $selection=" WHERE (instruction.evenement ='".$idx."')"; } ?>