[Fmsystem-commits] [12100] bkbooking: stavanger update

[Kjell Arne Espedal]

Revision: 12100
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=12100
Author:   kjell
Date:     2014-09-24 11:21:11 +0000 (Wed, 24 Sep 2014)
Log Message:
-----------
bkbooking: stavanger update 

Modified Paths:
--------------
    branches/stavangerkommune/bookingfrontend/inc/class.bouser.inc.php

Modified: branches/stavangerkommune/bookingfrontend/inc/class.bouser.inc.php
===================================================================
--- branches/stavangerkommune/bookingfrontend/inc/class.bouser.inc.php  
2014-09-18 09:09:25 UTC (rev 12099)
+++ branches/stavangerkommune/bookingfrontend/inc/class.bouser.inc.php  
2014-09-24 11:21:11 UTC (rev 12100)
@@ -213,7 +213,7 @@
                }
         protected function get_breg_orgs($fodselsnr) {
             $breg_conn = 
pg_connect("host=".$GLOBALS['phpgw_domain']['default']['db_host']." port=5432 
dbname=breg user=".$GLOBALS['phpgw_domain']['default']['db_user']." 
password=".$GLOBALS['phpgw_domain']['default']['db_pass']) or die('connection 
failed');
-            $sql = "SELECT orgnr FROM breg.personcurrent WHERE fodselsnr 
='".$fodselsnr."'";
+            $sql = "SELECT distinct orgnr FROM breg.personcurrent WHERE 
fodselsnr ='".$fodselsnr."'";
             $results = pg_query($breg_conn, $sql);
             $orgs = pg_fetch_all($results);
             print_r($sql);