| 1 |
fraynaud |
25 |
<?php |
| 2 |
|
|
//$Id: dossier.scr.inc,v 1.3 2010-08-22 21:40:12 fraynaud Exp $ |
| 3 |
|
|
$sql_dossier="select |
| 4 |
|
|
dossier,nature.libelle as nature, |
| 5 |
|
|
demandeur_civilite,demandeur_nom,demandeur_societe, |
| 6 |
|
|
demandeur_adresse,demandeur_cp,demandeur_ville, |
| 7 |
|
|
terrain_numero, terrain_adresse, terrain_cp, terrain_ville, rivoli,parcelle, |
| 8 |
|
|
terrain_surface, hauteur, shon, shob, batiment_nombre, logement_nombre, delai, |
| 9 |
|
|
to_char(date_depot,'DD/MM/YYYY') as date_depot, |
| 10 |
|
|
to_char(date_validite,'DD/MM/YYYY') as date_validite, |
| 11 |
|
|
to_char(date_chantier,'DD/MM/YYYY') as date_chantier, |
| 12 |
|
|
to_char(date_achevement,'DD/MM/YYYY') as date_achevement, |
| 13 |
|
|
to_char(date_conformite,'DD/MM/YYYY') as date_conformite, |
| 14 |
|
|
to_char(date_complet,'DD/MM/YYYY') as date_complet, |
| 15 |
|
|
to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai, |
| 16 |
|
|
to_char(date_limite,'DD/MM/YYYY') as date_limite, |
| 17 |
fraynaud |
152 |
travaux.libelle as travaux, servitude, |
| 18 |
|
|
amenagement,parcelle_lot_lotissement |
| 19 |
fraynaud |
242 |
from ".DB_PREFIXE."dossier inner join ".DB_PREFIXE."nature on nature.nature = dossier.nature |
| 20 |
|
|
left join ".DB_PREFIXE."travaux on dossier.travaux=travaux.travaux |
| 21 |
fraynaud |
25 |
where dossier = '".$id."'"; |
| 22 |
|
|
|
| 23 |
|
|
$sql_instruction="SELECT instruction,evenement.libelle as evenement, instruction.lettretype, |
| 24 |
fraynaud |
242 |
to_char(datecourrier,'DD/MM/YYYY') as datecourrier from ".DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on evenement.evenement = instruction.evenement |
| 25 |
fraynaud |
25 |
where dossier = '".$id."'"; |
| 26 |
|
|
|
| 27 |
|
|
$sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi, |
| 28 |
|
|
to_char(date_retour,'DD/MM/YYYY') as retour, |
| 29 |
fraynaud |
197 |
to_char(date_limite,'DD/MM/YYYY') as limite, |
| 30 |
|
|
avis.libelle as avis |
| 31 |
fraynaud |
242 |
from ".DB_PREFIXE."consultation inner join ".DB_PREFIXE."service on service.service = consultation.service |
| 32 |
|
|
left join ".DB_PREFIXE."avis on avis.avis=consultation.avis |
| 33 |
fraynaud |
25 |
where consultation.dossier = '".$id."'"; |
| 34 |
|
|
|
| 35 |
fraynaud |
252 |
//$sql_terrain ="SELECT terrain.parcelle, (proprietaire.nom|| ' '|| proprietaire.prenom) as proprietaire, |
| 36 |
|
|
//parcelle.surface from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle left join ". |
| 37 |
|
|
//DB_PREFIXE."proprietaire on proprietaire.proprietaire = parcelle.proprietaire |
| 38 |
|
|
//where dossier = '".$id."'"; |
| 39 |
fraynaud |
25 |
|
| 40 |
fraynaud |
252 |
$sql_terrain ="SELECT terrain.parcelle, ' ' as proprietaire, parcelle.surface from ".DB_PREFIXE."terrain inner join ".DB_PREFIXE."parcelle on terrain.parcelle = parcelle.parcelle ". |
| 41 |
|
|
"where dossier = '".$id."'"; |
| 42 |
|
|
|
| 43 |
|
|
|
| 44 |
fraynaud |
197 |
$sql_destination_shon="SELECT destination_shon as no,destination.libelle, shon, |
| 45 |
|
|
shon_anterieure, shon_demolie, shon_anterieure_supprimee, |
| 46 |
|
|
shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee |
| 47 |
fraynaud |
242 |
from ".DB_PREFIXE."destination_shon inner join ". |
| 48 |
|
|
DB_PREFIXE."destination on destination_shon.destination=destination.destination |
| 49 |
|
|
where dossier = '".$id."'"; |
| 50 |
fraynaud |
25 |
|
| 51 |
|
|
$sql_modificatif="select dossier, |
| 52 |
|
|
(dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande, |
| 53 |
fraynaud |
242 |
demandeur_nom,etat from ".DB_PREFIXE."dossier |
| 54 |
fraynaud |
25 |
where substring(dossier,1,9) like substring('".$id."',1,9)"; |
| 55 |
fraynaud |
197 |
|
| 56 |
fraynaud |
242 |
$sql_statistique= "select * from ".DB_PREFIXE."statistique where dossier='".$id."'"; |
| 57 |
fraynaud |
197 |
|
| 58 |
fraynaud |
25 |
?> |
Parent Directory
| 
Revision Log