sql/pgsql/demande_avis_encours.form.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:32 
include('../gen/sql/pgsql/consultation.form.inc.php');

$tableSelect=DB_PREFIXE."consultation
    INNER JOIN ".DB_PREFIXE."dossier 
        ON consultation.dossier=dossier.dossier
    INNER JOIN ".DB_PREFIXE."service
        ON service.service=consultation.service
    LEFT OUTER JOIN ".DB_PREFIXE."instructeur
        ON instructeur.instructeur=dossier.instructeur
    LEFT OUTER JOIN ".DB_PREFIXE."division
        ON division.division=instructeur.division
    LEFT OUTER JOIN ".DB_PREFIXE."avis_consultation 
        ON consultation.avis_consultation=avis_consultation.avis_consultation 
    LEFT OUTER JOIN ".DB_PREFIXE."travaux
        ON travaux.travaux=dossier.travaux
    LEFT OUTER JOIN ".DB_PREFIXE."architecte
        ON architecte.architecte=dossier.architecte
        ";

$champs=array(
"consultation.consultation as \""._("Consultation")."\"",
"consultation.dossier as \""._("Dossier")."\"",
"division.libelle as \""._("Division")."\"",
"division.chef as \""._("chef_de_division")."\"",
"instructeur.nom||' tel. : '||instructeur.telephone as \""._("Instructeur")."\"",
// XXX autorite competente
// XXX comunne/quaartier (manque les criteres d'affectation auto ?)
"to_char(dossier.date_depot ,'DD/MM/YYYY') as \""._("Date de depot")."\"",
// XXX date derniere modif
"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \""._("Date d'envoi")."\"",
"to_char(consultation.date_limite ,'DD/MM/YYYY') as \""._("Date limite")."\"",
"dossier.demandeur_nom as \""._("Petitionnaire")."\"",
"dossier.demandeur_adresse||' '||dossier.demandeur_cp||' '||demandeur_ville as \""._("Adresse petitionnaire")."\"",
"architecte.nom||' '||architecte.prenom||' tel. '||architecte.telephone as \""._("Auteur du projet")."\"",
//XXX parcelle
"dossier.terrain_numero||dossier.terrain_numero_complement||' '||dossier.terrain_adresse ||' '||dossier.terrain_adresse_complement||' '||terrain_cp||' '||terrain_ville as \""._("Adresse du terrain")."\"",
"consultation.service as \""._("Service")."\"",
"to_char(date_reception ,'DD/MM/YYYY') as \""._("Date de reception")."\"",
"to_char(date_retour ,'DD/MM/YYYY') as \""._("Date de retour")."\"",
"consultation.avis_consultation as \""._("Avis")."\"",
"motivation as \""._("Motivation")."\"",
"fichier as \""._("Fichier")."\"",
"lu as \""._("Lu")."\""
);

// Action : modifier
    $portlet_actions['pdfetat'] =
        array('lien' => "../app/pdf_consultation.php?idx=",
              'id' => "&obj=consultation",
              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
                    _("Edition")."\">"._("Edition")."</span>",
              'ordre' => 30,
              'ajax' => false);
        
// Action : modifier
    $portlet_actions['modifier'] =
        array('lien' => "\" onclick=\"popupIt('consultation_retour_service','../scr/sousform.php?idx=",
              'id' => "&obj=consultation_retour_service&action=1');return false;",
              'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix edit-16\" title=\"".
                    _("Rendre un avis")."\">"._("Rendre un avis")."</span>",
              'ordre' => 10,
              'ajax' => false);
        
$sql_service="SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)) OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)))";
$sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
             
?>
1	nhaye	544	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 20:32
4			include('../gen/sql/pgsql/consultation.form.inc.php');
5
6			$tableSelect=DB_PREFIXE."consultation
7			INNER JOIN ".DB_PREFIXE."dossier
8			ON consultation.dossier=dossier.dossier
9			INNER JOIN ".DB_PREFIXE."service
10			ON service.service=consultation.service
11			LEFT OUTER JOIN ".DB_PREFIXE."instructeur
12			ON instructeur.instructeur=dossier.instructeur
13			LEFT OUTER JOIN ".DB_PREFIXE."division
14			ON division.division=instructeur.division
15			LEFT OUTER JOIN ".DB_PREFIXE."avis_consultation
16			ON consultation.avis_consultation=avis_consultation.avis_consultation
17			LEFT OUTER JOIN ".DB_PREFIXE."travaux
18			ON travaux.travaux=dossier.travaux
19			LEFT OUTER JOIN ".DB_PREFIXE."architecte
20			ON architecte.architecte=dossier.architecte
21			";
22
23			$champs=array(
24			"consultation.consultation as \""._("Consultation")."\"",
25			"consultation.dossier as \""._("Dossier")."\"",
26			"division.libelle as \""._("Division")."\"",
27			"division.chef as \""._("chef_de_division")."\"",
28			"instructeur.nom\|\|' tel. : '\|\|instructeur.telephone as \""._("Instructeur")."\"",
29			// XXX autorite competente
30			// XXX comunne/quaartier (manque les criteres d'affectation auto ?)
31			"to_char(dossier.date_depot ,'DD/MM/YYYY') as \""._("Date de depot")."\"",
32			// XXX date derniere modif
33			"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \""._("Date d'envoi")."\"",
34			"to_char(consultation.date_limite ,'DD/MM/YYYY') as \""._("Date limite")."\"",
35			"dossier.demandeur_nom as \""._("Petitionnaire")."\"",
36			"dossier.demandeur_adresse\|\|' '\|\|dossier.demandeur_cp\|\|' '\|\|demandeur_ville as \""._("Adresse petitionnaire")."\"",
37			"architecte.nom\|\|' '\|\|architecte.prenom\|\|' tel. '\|\|architecte.telephone as \""._("Auteur du projet")."\"",
38			//XXX parcelle
39			"dossier.terrain_numero\|\|dossier.terrain_numero_complement\|\|' '\|\|dossier.terrain_adresse \|\|' '\|\|dossier.terrain_adresse_complement\|\|' '\|\|terrain_cp\|\|' '\|\|terrain_ville as \""._("Adresse du terrain")."\"",
40			"consultation.service as \""._("Service")."\"",
41			"to_char(date_reception ,'DD/MM/YYYY') as \""._("Date de reception")."\"",
42			"to_char(date_retour ,'DD/MM/YYYY') as \""._("Date de retour")."\"",
43			"consultation.avis_consultation as \""._("Avis")."\"",
44			"motivation as \""._("Motivation")."\"",
45			"fichier as \""._("Fichier")."\"",
46			"lu as \""._("Lu")."\""
47			);
48
49			// Action : modifier
50			$portlet_actions['pdfetat'] =
51			array('lien' => "../app/pdf_consultation.php?idx=",
52			'id' => "&obj=consultation",
53			'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix pdf-16\" title=\"".
54			_("Edition")."\">"._("Edition")."</span>",
55			'ordre' => 30,
56			'ajax' => false);
57
58			// Action : modifier
59			$portlet_actions['modifier'] =
60			array('lien' => "\" onclick=\"popupIt('consultation_retour_service','../scr/sousform.php?idx=",
61			'id' => "&obj=consultation_retour_service&action=1');return false;",
62			'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix edit-16\" title=\"".
63			_("Rendre un avis")."\">"._("Rendre un avis")."</span>",
64			'ordre' => 10,
65			'ajax' => false);
66
67			$sql_service="SELECT service.service, service.abrege\|\|' '\|\|service.libelle FROM ".DB_PREFIXE."service WHERE ((service.om_validite_debut IS NULL AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)) OR (service.om_validite_debut <= CURRENT_DATE AND (service.om_validite_fin IS NULL OR service.om_validite_fin > CURRENT_DATE)))";
68			$sql_service_by_id = "SELECT service.service, service.abrege\|\|' '\|\|service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>";
69
70			?>