/[openfoncier]/trunk/sql/pgsql/dossier.scr.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/dossier.scr.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1127 by vpihour, Thu Dec 27 15:07:37 2012 UTC revision 1367 by nhaye, Mon Mar 11 17:57:35 2013 UTC
# Line 1  Line 1 
1  <?php  <?php
2  //$Id: dossier.scr.inc,v 1.3 2010-08-22 21:40:12 fraynaud Exp $  //$Id: dossier.scr.inc,v 1.3 2010-08-22 21:40:12 fraynaud Exp $
3  $sql_dossier="select  $sql_dossier="
4  dossier,nature.libelle as nature,  SELECT
5  demandeur_civilite,demandeur_nom,demandeur_societe,  dossier,
6  demandeur_adresse,demandeur_cp,demandeur_ville,  dossier_autorisation_type_detaille.libelle as nature,
7  terrain_numero, terrain_adresse, terrain_cp, terrain_ville, rivoli,parcelle,  parcelle,
8  terrain_surface,  hauteur, shon, shob, batiment_nombre, logement_nombre, delai,  hauteur, shon, shob, batiment_nombre, logement_nombre, delai,
9  to_char(date_depot,'DD/MM/YYYY') as date_depot,  to_char(date_depot,'DD/MM/YYYY') as date_depot,
10  to_char(date_validite,'DD/MM/YYYY') as date_validite,  to_char(date_validite,'DD/MM/YYYY') as date_validite,
11  to_char(date_chantier,'DD/MM/YYYY') as date_chantier,  to_char(date_chantier,'DD/MM/YYYY') as date_chantier,
# Line 13  to_char(date_achevement,'DD/MM/YYYY') as Line 13  to_char(date_achevement,'DD/MM/YYYY') as
13  to_char(date_conformite,'DD/MM/YYYY') as date_conformite,  to_char(date_conformite,'DD/MM/YYYY') as date_conformite,
14  to_char(date_complet,'DD/MM/YYYY') as date_complet,  to_char(date_complet,'DD/MM/YYYY') as date_complet,
15  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,  to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
16  to_char(date_limite,'DD/MM/YYYY') as date_limite,  to_char(date_limite,'DD/MM/YYYY') as date_limite, servitude,
 travaux.libelle as travaux, travaux_complement, servitude,  
17  amenagement,parcelle_lot_lotissement  amenagement,parcelle_lot_lotissement
18  from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature  FROM ".DB_PREFIXE."dossier
19  left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux  INNER JOIN ".DB_PREFIXE."dossier_autorisation
20    ON dossier_autorisation.dossier_autorisation = dossier.dossier_autorisation
21    INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
22    ON dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
23    =dossier_autorisation.dossier_autorisation_type_detaille
24  where dossier =  '".$id."'";  where dossier =  '".$id."'";
25    
26  $sql_instruction="SELECT  instruction,evenement.libelle as evenement,  instruction.lettretype,  $sql_instruction="SELECT  instruction,evenement.libelle as evenement,  instruction.lettretype,
# Line 27  where dossier = '".$id."'"; Line 30  where dossier = '".$id."'";
30  $sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi,  $sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi,
31  to_char(date_retour,'DD/MM/YYYY') as retour,  to_char(date_retour,'DD/MM/YYYY') as retour,
32  to_char(date_limite,'DD/MM/YYYY') as limite,  to_char(date_limite,'DD/MM/YYYY') as limite,
33  avis_decision.libelle as avis_decision  avis_consultation.libelle as avis_decision
34  from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service  from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service
35  left join ".DB_PREFIXE."avis_decision on avis_decision.avis_decision=consultation.avis_decision  left join ".DB_PREFIXE."avis_consultation on avis_consultation.avis_consultation=consultation.avis_consultation
36  where consultation.dossier = '".$id."'";  where consultation.dossier = '".$id."'";
37    
38  //$sql_terrain ="SELECT   terrain.parcelle, (proprietaire.nom|| ' '||  proprietaire.prenom) as proprietaire,  //$sql_terrain ="SELECT   terrain.parcelle, (proprietaire.nom|| ' '||  proprietaire.prenom) as proprietaire,
# Line 40  where consultation.dossier = '".$id."'"; Line 43  where consultation.dossier = '".$id."'";
43  $sql_terrain ="SELECT   terrain.parcelle, ' ' as proprietaire, parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ".  $sql_terrain ="SELECT   terrain.parcelle, ' ' as proprietaire, parcelle.surface  from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ".
44          "where dossier = '".$id."'";          "where dossier = '".$id."'";
45    
   
 $sql_destination_shon="SELECT   destination_shon as no,destination.libelle, shon,  
                         shon_anterieure, shon_demolie, shon_anterieure_supprimee,  
                         shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee  
                         from ".DB_PREFIXE."destination_shon inner join ".  
                         DB_PREFIXE."destination on destination_shon.destination=destination.destination  
                         where dossier = '".$id."'";  
   
46  $sql_modificatif="select dossier,  $sql_modificatif="select dossier,
47  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,  (dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,
48  demandeur_nom,etat from ".DB_PREFIXE."dossier  etat from ".DB_PREFIXE."dossier
49  where substring(dossier,1,9) like substring('".$id."',1,9)";  where substring(dossier,1,9) like substring('".$id."',1,9)";
   
 $sql_statistique= "select * from ".DB_PREFIXE."statistique where dossier='".$id."'";  
   
50  ?>  ?>
Legend:
Removed from v.1127  
changed lines
  Added in v.1367
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26