34 |
|
|
35 |
// SELECT |
// SELECT |
36 |
$champAffiche = array( |
$champAffiche = array( |
37 |
'demande.demande as "'._("demande").'"', |
'demande.dossier_instruction as "'._("dossier").'"', |
38 |
$case_demandeur.' as "'._("petitionaire principal").'"', |
$case_demandeur.' as "'._("nom").'"', |
39 |
'TRIM(CONCAT(demande.terrain_adresse_voie_numero,\' \', |
'TRIM(CONCAT(demande.terrain_adresse_voie_numero,\' \', |
40 |
demande.complement,\' \', |
demande.complement,\' \', |
41 |
demande.terrain_adresse_lieu_dit,\' \', |
demande.terrain_adresse_lieu_dit,\' \', |
43 |
demande.terrain_adresse_localite,\' \', |
demande.terrain_adresse_localite,\' \', |
44 |
demande.terrain_adresse_bp,\' \', |
demande.terrain_adresse_bp,\' \', |
45 |
demande.terrain_adresse_cedex |
demande.terrain_adresse_cedex |
46 |
)) as "'._("adresse du terrain").'"', |
)) as "'._("terrain").'"', |
47 |
'dossier_autorisation_type_detaille.libelle as "'._("dossier_autorisation_type_detaille").'"', |
'dossier_autorisation_type_detaille.libelle as "'._("nature_dossier").'"', |
48 |
'to_char(demande.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"', |
'to_char(demande.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"', |
49 |
'arrondissement.libelle as "'._("arrondissement").'"', |
'arrondissement.libelle as "'._("arrondissement").'"', |
50 |
); |
); |
56 |
'table' => 'dossier', |
'table' => 'dossier', |
57 |
'colonne' => 'dossier', |
'colonne' => 'dossier', |
58 |
'type' => 'text', |
'type' => 'text', |
59 |
'libelle' => _('dossier_instruction')); |
'libelle' => _('dossier')); |
60 |
|
|
61 |
|
|
62 |
$champs['particulier_nom'] = |
$champs['particulier_nom'] = |