2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:33 |
//gen openMairie le 10/02/2011 20:33 |
4 |
include('../gen/sql/pgsql/evenement.form.inc.php'); |
include('../gen/sql/pgsql/evenement.form.inc.php'); |
5 |
$sql_om_lettretype="select id,(id||' '||libelle) as libelle from ". |
$sql_om_lettretype="select id,(id||' '||libelle) as lib from ". |
6 |
DB_PREFIXE."om_lettretype"; |
DB_PREFIXE."om_lettretype ORDER BY lib"; |
7 |
|
|
8 |
$sep = (isset($_GET['action']) && |
$sep = (isset($_GET['action']) && |
9 |
($_GET['action'] == 1 || $_GET['action'] == 0 )) ? ';' : ',' ; |
($_GET['action'] == 1 || $_GET['action'] == 0 )) ? ';' : ',' ; |
59 |
dossier_instruction_type IN (<idx>) |
dossier_instruction_type IN (<idx>) |
60 |
ORDER BY |
ORDER BY |
61 |
dossier_autorisation_type_detaille.code"; |
dossier_autorisation_type_detaille.code"; |
62 |
|
|
63 |
|
$sql_action="SELECT action.action, action.libelle as lib FROM ".DB_PREFIXE."action ORDER BY lib"; |
64 |
|
$sql_etat="SELECT etat.etat, etat.libelle as lib FROM ".DB_PREFIXE."etat ORDER BY lib"; |
65 |
|
$sql_avis_decision="SELECT avis_decision.avis_decision, avis_decision.libelle as lib FROM ".DB_PREFIXE."avis_decision ORDER BY lib"; |
66 |
|
$sql_evenement_retour_ar="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib"; |
67 |
|
$sql_evenement_suivant_tacite="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib"; |
68 |
|
|
69 |
?> |
?> |