| 1 |
vpihour |
688 |
<?php |
| 2 |
|
|
//$Id$ |
| 3 |
|
|
//gen openMairie le 14/11/2012 12:54 |
| 4 |
|
|
|
| 5 |
|
|
include('../gen/sql/pgsql/dossier_autorisation.inc.php'); |
| 6 |
vpihour |
1058 |
|
| 7 |
|
|
/*Tables sur lesquels la requête va s'effectuer*/ |
| 8 |
nhaye |
722 |
$table = DB_PREFIXE."dossier_autorisation |
| 9 |
|
|
INNER JOIN ".DB_PREFIXE."lien_dossier_autorisation_demandeur |
| 10 |
|
|
ON lien_dossier_autorisation_demandeur.dossier_autorisation=dossier_autorisation.dossier_autorisation |
| 11 |
|
|
AND lien_dossier_autorisation_demandeur.petitionnaire_principal IS TRUE |
| 12 |
|
|
INNER JOIN ".DB_PREFIXE."demandeur |
| 13 |
|
|
ON lien_dossier_autorisation_demandeur.demandeur=demandeur.demandeur |
| 14 |
|
|
LEFT JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille |
| 15 |
|
|
ON dossier_autorisation.dossier_autorisation_type_detaille=dossier_autorisation_type_detaille.dossier_autorisation_type_detaille |
| 16 |
|
|
LEFT OUTER JOIN ".DB_PREFIXE."arrondissement |
| 17 |
|
|
ON arrondissement.arrondissement=dossier_autorisation.arrondissement"; |
| 18 |
vpihour |
1058 |
|
| 19 |
|
|
/*Liste des champs affichés dans le tableau de résultat*/ |
| 20 |
nhaye |
722 |
$champAffiche = array( |
| 21 |
|
|
'dossier_autorisation.dossier_autorisation as "'._("dossier_autorisation").'"', |
| 22 |
|
|
'demandeur.particulier_nom as "'._("petitionaire").'"', |
| 23 |
|
|
'TRIM(CONCAT(dossier_autorisation.terrain_adresse_voie_numero,\' \', |
| 24 |
|
|
dossier_autorisation.complement,\' \', |
| 25 |
|
|
dossier_autorisation.terrain_adresse_lieu_dit,\' \', |
| 26 |
|
|
dossier_autorisation.terrain_adresse_code_postal,\' \', |
| 27 |
|
|
dossier_autorisation.terrain_adresse_localite,\' \', |
| 28 |
|
|
dossier_autorisation.terrain_adresse_bp,\' \', |
| 29 |
|
|
dossier_autorisation.terrain_adresse_cedex |
| 30 |
|
|
)) as "'._("adresse du terrain").'"', |
| 31 |
|
|
'to_char(dossier_autorisation.depot_initial ,\'YYYY\') as "'._("depot_initial").'"', |
| 32 |
|
|
'arrondissement.libelle as "'._("arrondissement").'"' |
| 33 |
|
|
); |
| 34 |
vpihour |
1058 |
|
| 35 |
|
|
/*Tri*/ |
| 36 |
vpihour |
1272 |
$tri="ORDER BY dossier_autorisation.dossier_autorisation ASC NULLS LAST"; |
| 37 |
vpihour |
1058 |
|
| 38 |
|
|
/*Ordre*/ |
| 39 |
nhaye |
722 |
$edition="dossier_autorisation"; |
| 40 |
|
|
|
| 41 |
vpihour |
1272 |
//Cas du dossier d'autorisation en sous-formulaire du dossier d'instruction |
| 42 |
|
|
if ( in_array("dossier", $sousformulaire) OR $sousformulaire == "dossier_instruction" OR |
| 43 |
|
|
$sousformulaire == "dossier_instruction_mes_encours" OR |
| 44 |
|
|
$sousformulaire == "dossier_instruction_mes_clotures" OR |
| 45 |
|
|
$sousformulaire == "dossier_instruction_tous_encours" OR |
| 46 |
|
|
$sousformulaire == "dossie_instruction_tous_cloturer" ){ |
| 47 |
|
|
|
| 48 |
|
|
$champAffiche = array('dossier_autorisation.dossier_autorisation as "dossier"', |
| 49 |
|
|
'\'Autorisation\' as "type"', |
| 50 |
|
|
'depot_initial as "date"', |
| 51 |
|
|
'dossier_autorisation.etat as "etat"'); |
| 52 |
|
|
|
| 53 |
|
|
$table = DB_PREFIXE.'dossier_autorisation |
| 54 |
|
|
LEFT JOIN '.DB_PREFIXE.'dossier |
| 55 |
|
|
ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation'; |
| 56 |
|
|
|
| 57 |
|
|
$selection = 'WHERE dossier.dossier=\''.$idx.'\' |
| 58 |
|
|
UNION |
| 59 |
|
|
SELECT |
| 60 |
|
|
dossier as "dossier", |
| 61 |
|
|
dossier_instruction_type.libelle as "type", |
| 62 |
|
|
date_depot as "date", |
| 63 |
|
|
dossier.etat as "etat" |
| 64 |
|
|
FROM '.DB_PREFIXE.'dossier |
| 65 |
|
|
JOIN '.DB_PREFIXE.'dossier_instruction_type |
| 66 |
|
|
ON dossier_instruction_type.dossier_instruction_type = dossier.dossier_instruction_type |
| 67 |
|
|
WHERE dossier.dossier=\''.$idx.'\''; |
| 68 |
|
|
|
| 69 |
|
|
$tri = ""; |
| 70 |
|
|
|
| 71 |
|
|
// On met la ligne en couleur selon le type de condition |
| 72 |
|
|
$options[] = array( |
| 73 |
|
|
"type" => "condition", |
| 74 |
|
|
"field" => "'Autorisation'", |
| 75 |
|
|
"case" => array( |
| 76 |
|
|
array( |
| 77 |
|
|
"values" => array(_("Autorisation"), ), |
| 78 |
|
|
"style" => "tabDADI", |
| 79 |
|
|
), |
| 80 |
|
|
array( |
| 81 |
|
|
"values" => array(_("Initial"),_("Modificatif"),_("transfert"), ), |
| 82 |
|
|
"href" => array( |
| 83 |
|
|
"consulter" => array( |
| 84 |
|
|
'lien' => "../scr/sousform.php?obj=dossier_instruction&action=3&idx_dossier=", |
| 85 |
|
|
'id' => "&premier=&advs_id=&recherche=&tricol=&selectioncol=&valide=", |
| 86 |
|
|
'lib' => '<span class="om-icon om-icon-16 om-icon-fix consult-16" title="'._('Consulter').'">'._('Consulter').'</span>', |
| 87 |
|
|
), |
| 88 |
|
|
), |
| 89 |
|
|
"target"=>"_blank", |
| 90 |
|
|
|
| 91 |
|
|
), |
| 92 |
|
|
), |
| 93 |
|
|
); |
| 94 |
|
|
|
| 95 |
|
|
//Suppression du bouton d'ajout |
| 96 |
|
|
$tab_actions['corner']['ajouter'] = NULL; |
| 97 |
|
|
|
| 98 |
|
|
//Suppression du bouton d'ajout |
| 99 |
|
|
$tab_actions['corner']['left']["consulter"] = NULL; |
| 100 |
|
|
|
| 101 |
|
|
//Suppression de l'affichage |
| 102 |
|
|
$options[] = array( |
| 103 |
|
|
"type"=>"pagination", |
| 104 |
|
|
"display"=>false, |
| 105 |
|
|
); |
| 106 |
|
|
} |
| 107 |
vpihour |
688 |
?> |
Parent Directory
| 
Revision Log