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

Diff of /trunk/sql/pgsql/om_sousetat.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 393 by nhaye, Wed Sep 19 16:23:00 2012 UTC
# Line 2  Line 2 
2  //$Id$  //$Id$
3  //gen openMairie le 04/11/2010 17:45  //gen openMairie le 04/11/2010 17:45
4  include('../gen/sql/pgsql/om_sousetat.inc.php');  include('../gen/sql/pgsql/om_sousetat.inc.php');
5  $table=DB_PREFIXE."om_sousetat inner join ".DB_PREFIXE."om_collectivite on  
6          om_collectivite.om_collectivite=om_sousetat.om_collectivite";  //
7  $champAffiche=array('om_sousetat','om_collectivite.libelle as collectivite',  $champAffiche = array(
8                      'id','om_sousetat.libelle as libelle','actif');      'om_sousetat.om_sousetat as "'._("om_sousetat").'"',
9  $champRecherche=array('id','om_collectivite.libelle','om_sousetat.libelle','actif','niveau');      'om_sousetat.id as "'._("id").'"',
10  $href[3] = array(      'om_sousetat.libelle as "'._("libelle").'"',
11      "lien" => "../scr/valid_copie.php?obj=".$obj."&idx=",      "case om_sousetat.actif when 't' then 'Oui' else 'Non' end as \""._("actif")."\"",
12      "id" => "",      'om_collectivite.niveau as "'._("niveau").'"',
     "lib" => "<span class=\"om-icon om-icon-16 om-icon-fix copy-16\" title=\""._("Copier")."\">"._("Copier")."</span>",  
13  );  );
14    //
15    if ($_SESSION['niveau'] == '2') {
16        array_push($champAffiche, "om_collectivite.libelle as \""._("collectivite")."\"");
17    }
18    //
19    $champRecherche = array(
20        'om_sousetat.om_sousetat as "'._("om_sousetat").'"',
21        'om_sousetat.id as "'._("id").'"',
22        'om_sousetat.libelle as "'._("libelle").'"',
23        'om_collectivite.niveau as "'._("niveau").'"',
24    );
25    //
26    if ($_SESSION['niveau'] == '2') {
27        array_push($champRecherche, "om_collectivite.libelle as \""._("collectivite")."\"");
28    }
29    //
30    if (isset($f) && $f->isAccredited(array($obj, $obj."_copier"), "OR")) {
31        //
32        $href_copie = array(
33            "lien" => "../scr/valid_copie.php?obj=".$obj."&amp;idx=",
34            "id" => "",
35            "lib" => "<span class=\"om-icon om-icon-16 om-icon-fix copy-16\" title=\""._("Copier")."\">"._("Copier")."</span>",
36        );
37        //
38        $href[3] = $href_copie;
39    } else {
40        //
41        $href_copie = array("lien" => "", "id" => "", "lib" => "");
42    }
43    
44  /**  /**
45   * Options   * Options
46   */   */
47  if ($_SESSION['niveau']== '2')  if ($_SESSION['niveau'] == '2') {
48          $selection='';      $selection = "";
49  else{  } else {
50          $selection=" where om_sousetat.om_collectivite = '".$_SESSION['collectivite']."' or niveau ='2'";      $selection = " where (".$obj.".om_collectivite='".$_SESSION['collectivite']."' or niveau='2')";
51      $options = array();      $options = array();
52      $option = array(      $option = array(
53          "type" => "condition",          "type" => "condition",
54          "field" => "niveau",          "field" => "om_collectivite.niveau",
55          "case" => array(          "case" => array(
56              "0" => array(              "0" => array(
57                  "values" => array('2', ),                  "values" => array('2', ),
# Line 31  else{ Line 60  else{
60                      0 => array("lien" => "", "id" => "", "lib" => ""),                      0 => array("lien" => "", "id" => "", "lib" => ""),
61                      1 => array("lien" => "", "id" => "", "lib" => ""),                      1 => array("lien" => "", "id" => "", "lib" => ""),
62                      2 => array("lien" => "", "id" => "", "lib" => ""),                      2 => array("lien" => "", "id" => "", "lib" => ""),
63                      3 => array("lien" => "../scr/valid_copie.php?obj=".$obj."&amp;idx=",                      3 => $href_copie,
                                "id" => "",  
                                "lib" => "<span class=\"om-icon om-icon-16 om-icon-fix copy-16\" title=\""._("Copier")."\">"._("Copier")."</span>"),  
64                  ),                  ),
65              ),              ),
66          ),          ),
67      );      );
68      array_push($options, $option);      array_push($options, $option);
69  }  }
 ?>  
70    
71    ?>
Legend:
Removed from v.312  
changed lines
  Added in v.393
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26