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