[Fmsystem-commits] [17182] booking: more on delegate

[sigurdne]

Revision: 17182
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17182
Author:   sigurdne
Date:     2017-10-21 09:01:16 -0400 (Sat, 21 Oct 2017)
Log Message:
-----------
booking: more on delegate

Modified Paths:
--------------
    trunk/bookingfrontend/inc/custom/default/MinId2.php

Modified: trunk/bookingfrontend/inc/custom/default/MinId2.php
===================================================================
--- trunk/bookingfrontend/inc/custom/default/MinId2.php 2017-10-21 11:14:42 UTC 
(rev 17181)
+++ trunk/bookingfrontend/inc/custom/default/MinId2.php 2017-10-21 13:01:16 UTC 
(rev 17182)
@@ -109,6 +109,12 @@
                {
                        $results = array();
 
+
+                       /**
+                        * Her kaller du tjenesten som gjør spørringen mot 
Brønnøysund.
+                        *      $fodselsnr er som det skal være (ikke hash)
+                        */
+
                        if ($this->debug)
                        {
                                $results[] = array
@@ -115,8 +121,34 @@
                                (
                                        'orgnr' => 964965226
                                );
+                               $orgs_validate[] = 964965226;
+
                        }
 
+                       $hash = sha1($fodselsnr);
+                       $ssn =  '{SHA1}' . base64_encode($hash);
+
+                       $this->db->query("SELECT 
bb_organization.organization_number, bb_organization.name AS organization_name"
+                               . " FROM bb_delegate"
+                               . " JOIN  bb_organization ON 
bb_delegate.organization_id = bb_organization.id"
+                               . " WHERE bb_delegate.ssn = '{$ssn}'", 
__LINE__, __FILE__);
+
+                       while($this->db->next_record())
+                       {
+                               $organization_number = 
$this->db->f('organization_number');
+                               if(in_array($organization_number, 
$orgs_validate))
+                               {
+                                       continue;
+                               }
+                               $results[] = array
+                               (
+                                       'orgnr' => $organization_number
+                               );
+
+                               $orgs_validate[] = $organization_number;
+
+                       }
+
                        return $results;
                }
        }
\ No newline at end of file