Parent Directory
| 
Revision Log
| 
Patch
| revision 489 by vpihour, Thu Oct 11 08:27:21 2012 UTC | revision 1138 by nhaye, Thu Jan 3 15:18:21 2013 UTC | |
|---|---|---|
| # | Line 3 | Line 3 |
| 3 | //gen openMairie le 10/02/2011 20:39 | //gen openMairie le 10/02/2011 20:39 |
| 4 | $reqmo['libelle']=' public.dossier'; | $reqmo['libelle']=' public.dossier'; |
| 5 | $reqmo['reqmo_libelle']=' public.dossier'; | $reqmo['reqmo_libelle']=' public.dossier'; |
| 6 | $reqmo['sql']="select [dossier], [nature], [annee], [types], [objet_dossier], [instructeur], [date_demande], [date_depot], [date_complet], [date_rejet], [date_notification_delai], [delai], [date_limite], [accord_tacite], [date_decision], [avis_decision], [date_validite], [date_chantier], [date_achevement], [date_conformite], [demandeur_civilite], [demandeur_nom], [demandeur_societe], [demandeur_adresse], [demandeur_cp], [demandeur_ville], [demandeur_pays], [demandeur_telephone], [demandeur_email], [demandeur_categorie], [delegataire], [delegataire_civilite], [delegataire_nom], [delegataire_societe], [delegataire_adresse], [delegataire_cp], [delegataire_ville], [delegataire_pays], [delegataire_telephone], [delegataire_email], [terrain_numero], [terrain_numero_complement], [terrain_adresse], [terrain_adresse_complement], [terrain_cp], [terrain_ville], [architecte], [terrain_surface], [terrain_surface_calcul], [rivoli], [travaux], [parcelle], [pos], [sig], [batiment_nombre], [logement_nombre], [shon], [shon_calcul], [shob], [lot], [hauteur], [piece_nombre], [amenagement], [temp1], [temp2], [temp3], [temp4], [temp5], [geom] from ".DB_PREFIXE."dossier where etat = '[etat]' order by [tri]"; | $reqmo['sql']="select |
| 7 | [dossier], | |
| 8 | [dossier_autorisation_type_detaille.code as nature], | |
| 9 | [annee], | |
| 10 | [types], | |
| 11 | [objet_dossier], | |
| 12 | [instructeur], | |
| 13 | [date_demande], | |
| 14 | [date_depot], | |
| 15 | [date_complet], | |
| 16 | [date_rejet], | |
| 17 | [date_notification_delai], | |
| 18 | [delai], [date_limite], | |
| 19 | [accord_tacite], | |
| 20 | [date_decision], | |
| 21 | [avis_decision], | |
| 22 | [date_validite], | |
| 23 | [date_chantier], | |
| 24 | [date_achevement], | |
| 25 | [date_conformite], | |
| 26 | [demandeur_civilite], | |
| 27 | [demandeur_nom], | |
| 28 | [demandeur_societe], | |
| 29 | [demandeur_adresse], | |
| 30 | [demandeur_cp], | |
| 31 | [demandeur_ville], | |
| 32 | [demandeur_pays], | |
| 33 | [demandeur_telephone], | |
| 34 | [demandeur_email], | |
| 35 | [demandeur_categorie], | |
| 36 | [delegataire], | |
| 37 | [delegataire_civilite], | |
| 38 | [delegataire_nom], | |
| 39 | [delegataire_societe], | |
| 40 | [delegataire_adresse], | |
| 41 | [delegataire_cp], | |
| 42 | [delegataire_ville], | |
| 43 | [delegataire_pays], | |
| 44 | [delegataire_telephone], | |
| 45 | [delegataire_email], | |
| 46 | [terrain_numero], | |
| 47 | [terrain_numero_complement], | |
| 48 | [terrain_adresse], | |
| 49 | [terrain_adresse_complement], | |
| 50 | [terrain_cp], | |
| 51 | [terrain_ville], | |
| 52 | [architecte], | |
| 53 | [terrain_surface], | |
| 54 | [terrain_surface_calcul], | |
| 55 | [rivoli], | |
| 56 | [travaux], | |
| 57 | [parcelle], | |
| 58 | [pos], | |
| 59 | [sig], | |
| 60 | [batiment_nombre], | |
| 61 | [logement_nombre], | |
| 62 | [shon], | |
| 63 | [shon_calcul], | |
| 64 | [shob], | |
| 65 | [lot], | |
| 66 | [hauteur], | |
| 67 | [piece_nombre], | |
| 68 | [amenagement], | |
| 69 | [temp1], | |
| 70 | [temp2], | |
| 71 | [temp3], | |
| 72 | [temp4], | |
| 73 | [temp5], | |
| 74 | [geom] | |
| 75 | from ".DB_PREFIXE."dossier | |
| 76 | INNER JOIN ".DB_PREFIXE."dossier_autorisation | |
| 77 | ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation | |
| 78 | INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille | |
| 79 | ON dossier_autorisation.dossier_autorisation_type_detaille | |
| 80 | = dossier_autorisation_type_detaille.dossier_autorisation_type_detaille | |
| 81 | where dossier.etat = '[etat]' order by [tri]"; | |
| 82 | $reqmo['dossier']='checked'; | $reqmo['dossier']='checked'; |
| 83 | $reqmo['nature']='checked'; | $reqmo['nature']='checked'; |
| 84 | $reqmo['annee']='checked'; | $reqmo['annee']='checked'; |
|
||||||||
| [email protected] | ViewVC Help |
| Powered by ViewVC 1.1.26 |