/[openfoncier]/trunk/sql/pgsql/instruction.inc.php
ViewVC logotype

Contents of /trunk/sql/pgsql/instruction.inc.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1227 - (show annotations)
Wed Jan 16 11:17:06 2013 UTC (12 years ago) by vpihour
File size: 1026 byte(s)
Ajout de la valeur par défaut, s'il y en a une, pour le signataire_arete dans l'instruciton

1 <?php
2 //$Id$
3 //gen openMairie le 10/02/2011 20:34
4 include('../gen/sql/pgsql/instruction.inc.php');
5 // =======================================================
6 // href special edition instruction
7 // =======================================================
8 $table=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement
9 LEFT JOIN ".DB_PREFIXE."signataire_arrete
10 ON instruction.signataire_arrete=signataire_arrete.signataire_arrete";
11 $champAffiche=array("instruction as no",
12 "instruction.lettretype",
13 "signataire_arrete.nom as \""._("signataire_arrete")."\"",
14 "libelle",
15 "to_char(date_evenement ,'DD/MM/YYYY') as date_evenement",
16 "instruction.etat",
17 "dossier"
18 );
19 $champRecherche=array("libelle");
20 $tri= " order by instruction ";
21 if(isset($idx)){
22 $selection=" where dossier like '".$idx."'";
23 }else{
24 $selection="";
25 }
26 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26