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

Diff of /trunk/sql/pgsql/dossier_instruction_tous_clotures.inc.php

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

revision 3730 by mbroquet, Fri Mar 18 11:50:26 2016 UTC revision 6565 by softime, Fri Apr 21 16:14:15 2017 UTC
# Line 15  $champAffiche = array_merge($champAffich Line 15  $champAffiche = array_merge($champAffich
15    
16  //  //
17  $selection = " WHERE  $selection = " WHERE
18  dossier.division = ".$_SESSION['division']."  groupe.code != 'CTX'
19    AND dossier.division = ".$_SESSION['division']."
20  AND dossier.etat IN (select etat from ".DB_PREFIXE."etat where etat.statut='cloture' )  AND dossier.etat IN (select etat from ".DB_PREFIXE."etat where etat.statut='cloture' )
21  ";  ";
22    
# Line 31  if ($_SESSION["niveau"] == "2") { Line 32  if ($_SESSION["niveau"] == "2") {
32      $selection .= " AND (dossier.om_collectivite = '".$_SESSION["collectivite"]."') ";      $selection .= " AND (dossier.om_collectivite = '".$_SESSION["collectivite"]."') ";
33  }  }
34    
35    
36  ?>  ?>
Legend:
Removed from v.3730  
changed lines
  Added in v.6565
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26