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

Diff of /trunk/sql/pgsql/etat.form.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 312 by atreal, Wed Mar 28 17:19:49 2012 UTC revision 1130 by vpihour, Mon Dec 31 13:49:36 2012 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 10/02/2011 22:10  //gen openMairie le 10/02/2011 22:10
4  include('../gen/sql/pgsql/etat.form.inc.php');  include('../gen/sql/pgsql/etat.form.inc.php');
5    
6    $sep = (isset($_GET['action']) &&
7            ($_GET['action'] == 1 || $_GET['action'] == 0 )) ? ';' : ',' ;
8    
9    $champs = array (
10            "etat.etat as etat",
11            "libelle",
12            "statut",
13            "array_to_string(array_agg(evenement ORDER BY evenement), '$sep') as evenement"
14        );
15    
16    $tableSelect = DB_PREFIXE."etat LEFT JOIN ".DB_PREFIXE."transition ON transition.etat=etat.etat";
17    
18    $selection = " GROUP BY etat.etat,libelle,statut";
19    
20    $sql_evenement="SELECT evenement.evenement, evenement.libelle FROM ".DB_PREFIXE."evenement ORDER BY evenement.libelle";
21    $sql_evenement_by_id = "SELECT evenement.evenement, evenement.libelle FROM ".DB_PREFIXE."evenement WHERE evenement IN (<idx>) ORDER BY evenement.libelle";
22  ?>  ?>
Legend:
Removed from v.312  
changed lines
  Added in v.1130
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26