sql/pgsql/dossier.scr.inc.php

<?php
//$Id: dossier.scr.inc,v 1.3 2010-08-22 21:40:12 fraynaud Exp $
$sql_dossier="select
dossier,nature.libelle as nature,
demandeur_civilite,demandeur_nom,demandeur_societe,
demandeur_adresse,demandeur_cp,demandeur_ville,
terrain_numero, terrain_adresse, terrain_cp, terrain_ville, rivoli,parcelle,
terrain_surface,  hauteur, shon, shob, batiment_nombre, logement_nombre, delai,
to_char(date_depot,'DD/MM/YYYY') as date_depot,
to_char(date_validite,'DD/MM/YYYY') as date_validite,
to_char(date_chantier,'DD/MM/YYYY') as date_chantier,
to_char(date_achevement,'DD/MM/YYYY') as date_achevement,
to_char(date_conformite,'DD/MM/YYYY') as date_conformite,
to_char(date_complet,'DD/MM/YYYY') as date_complet,
to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
to_char(date_limite,'DD/MM/YYYY') as date_limite,
travaux.libelle as travaux, servitude,
amenagement,parcelle_lot_lotissement
from dossier inner join nature on nature.nature = dossier.nature
left join travaux on dossier.travaux=travaux.travaux
where dossier =  '".$id."'";

$sql_instruction="SELECT  instruction,evenement.libelle as evenement,  instruction.lettretype,
to_char(datecourrier,'DD/MM/YYYY') as datecourrier  from instruction inner join evenement on evenement.evenement = instruction.evenement
where dossier = '".$id."'";

$sql_consultation="select consultation,(service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')) as envoi,
to_char(date_retour,'DD/MM/YYYY') as retour,
to_char(date_limite,'DD/MM/YYYY') as limite,
avis.libelle as avis
from consultation inner join service on service.service = consultation.service
left join avis on avis.avis=consultation.avis
where consultation.dossier = '".$id."'";

$sql_terrain ="SELECT   terrain.parcelle, (proprietaire.nom|| ' '||  proprietaire.prenom) as proprietaire,
parcelle.surface  from terrain inner join parcelle on terrain.parcelle = parcelle.parcelle left join proprietaire on proprietaire.proprietaire = parcelle.proprietaire
where dossier = '".$id."'";

$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 destination_shon inner join destination on destination_shon.destination=destination.destination
where dossier = '".$id."'";

$sql_modificatif="select dossier,
(dossier||' '||types||' du '||to_char(date_demande,'DD/MM/YYYY')) as demande,
demandeur_nom,etat from dossier
where substring(dossier,1,9) like substring('".$id."',1,9)";

$sql_statistique= "select * from statistique where dossier='".$id."'";

?>
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	25	from dossier inner join nature on nature.nature = dossier.nature
20			left join travaux on dossier.travaux=travaux.travaux
21			where dossier = '".$id."'";
22
23			$sql_instruction="SELECT instruction,evenement.libelle as evenement, instruction.lettretype,
24			to_char(datecourrier,'DD/MM/YYYY') as datecourrier from instruction inner join evenement on evenement.evenement = instruction.evenement
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	25	from consultation inner join service on service.service = consultation.service
32			left join avis on avis.avis=consultation.avis
33			where consultation.dossier = '".$id."'";
34
35			$sql_terrain ="SELECT terrain.parcelle, (proprietaire.nom\|\| ' '\|\| proprietaire.prenom) as proprietaire,
36			parcelle.surface from terrain inner join parcelle on terrain.parcelle = parcelle.parcelle left join proprietaire on proprietaire.proprietaire = parcelle.proprietaire
37			where dossier = '".$id."'";
38
39	fraynaud	197	$sql_destination_shon="SELECT destination_shon as no,destination.libelle, shon,
40			shon_anterieure, shon_demolie, shon_anterieure_supprimee,
41			shon_nouvelle, shon_nouvelle_transformee, shon_shob_transformee
42			from destination_shon inner join destination on destination_shon.destination=destination.destination
43	fraynaud	25	where dossier = '".$id."'";
44
45			$sql_modificatif="select dossier,
46			(dossier\|\|' '\|\|types\|\|' du '\|\|to_char(date_demande,'DD/MM/YYYY')) as demande,
47			demandeur_nom,etat from dossier
48			where substring(dossier,1,9) like substring('".$id."',1,9)";
49	fraynaud	197
50			$sql_statistique= "select * from statistique where dossier='".$id."'";
51
52	fraynaud	25	?>