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	<?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	travaux.libelle as travaux, servitude,
18	amenagement,parcelle_lot_lotissement
19	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	to_char(date_limite,'DD/MM/YYYY') as limite,
30	avis.libelle as avis
31	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	$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	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
50	$sql_statistique= "select * from statistique where dossier='".$id."'";
51
52	?>