| 1 |
nhaye |
652 |
<?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\"", |
| 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_depot\"", |
| 32 |
|
|
// XXX date derniere modif |
| 33 |
|
|
"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_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 \"architecte\"", |
| 38 |
|
|
//XXX parcelle |
| 39 |
|
|
"dossier.terrain_numero||dossier.terrain_numero_complement||' '||dossier.terrain_adresse ||' '||dossier.terrain_adresse_complement||' '||terrain_cp||' '||terrain_ville as \"terrain\"", |
| 40 |
|
|
"consultation.service as \"service\"", |
| 41 |
|
|
"to_char(date_reception ,'DD/MM/YYYY') as \"date_reception\"", |
| 42 |
|
|
"to_char(date_retour ,'DD/MM/YYYY') as \"date_retour\"", |
| 43 |
|
|
"consultation.avis_consultation as \"avis_consultation\"", |
| 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','../scr/sousform.php?idx=", |
| 61 |
|
|
'id' => "&obj=consultation&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 |
|
|
// Action : supprimer |
| 68 |
|
|
$portlet_actions['supprimer'] = NULL; |
| 69 |
|
|
|
| 70 |
|
|
$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)))"; |
| 71 |
|
|
$sql_service_by_id = "SELECT service.service, service.abrege||' '||service.libelle FROM ".DB_PREFIXE."service WHERE service = <idx>"; |
| 72 |
|
|
|
| 73 |
|
|
?> |
Parent Directory
| 
Revision Log