[openelec-Commits] r1161 - trunk/sql/pgsql

[nh...@adullact.net]

Author: nhaye
Date: 2016-11-30 16:52:06 +0100 (Wed, 30 Nov 2016)
New Revision: 1161

Modified:
trunk/sql/pgsql/decoupage.pdf.inc
Log:
Correction du filtre des voies sur la collectivit?\195?\169 de l'utilisateur connect?\195?\169


Modified: trunk/sql/pgsql/decoupage.pdf.inc
===================================================================
--- trunk/sql/pgsql/decoupage.pdf.inc 2016-10-28 14:12:21 UTC (rev 1160)
+++ trunk/sql/pgsql/decoupage.pdf.inc 2016-11-30 15:52:06 UTC (rev 1161)
@@ -104,11 +104,12 @@
premier_impair as \"impair >\",
dernier_impair as \"< impair\"
FROM
- decoupage
- LEFT JOIN voie ON decoupage.code_voie=voie.code
- LEFT JOIN bureau ON decoupage.code_bureau=bureau.code
+".DB_PREFIXE."decoupage
+JOIN ".DB_PREFIXE."voie ON decoupage.code_voie=voie.code
+JOIN ".DB_PREFIXE."bureau ON decoupage.code_bureau=bureau.code
WHERE
- code_collectivite = '".$_SESSION['collectivite']."'
+ voie.code_collectivite = '".$_SESSION['collectivite']."' AND
+ bureau.collectivite = '".$_SESSION['collectivite']."'
ORDER BY
libelle_voie, code_bureau
";