[Fmsystem-commits] [11202] Fixed fellesdata-query

[Erik Holm-Larsen]

Revision: 11202
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11202
Author:   erikhl
Date:     2013-06-25 08:54:54 +0000 (Tue, 25 Jun 2013)
Log Message:
-----------
Fixed fellesdata-query

Modified Paths:
--------------
    trunk/rental/inc/class.soparty.inc.php

Modified: trunk/rental/inc/class.soparty.inc.php
===================================================================
--- trunk/rental/inc/class.soparty.inc.php      2013-06-25 08:03:06 UTC (rev 
11201)
+++ trunk/rental/inc/class.soparty.inc.php      2013-06-25 08:54:54 UTC (rev 
11202)
@@ -340,16 +340,27 @@
 
        function get_org_unit_ids_from_top($org_unit_id){
                $unit_ids = array();
-               $q="select * from v_org_knytning where 
org_enhet_id_knytning=$org_unit_id";
+               $q="SELECT * FROM V_ORG_KNYTNING WHERE 
V_ORG_KNYTNING.ORG_ENHET_ID_KNYTNING=$org_unit_id";
 
                if(!$external_db = $this->get_external_db())
                {
                        return;
                }
+               if($external_db->Type == "postgres")
+               {
+                       $q = strtolower($q);
+               }
                $result = $this->external_db->query($q);
 
                while($this->external_db->next_record()){
-                       $unit_id = $this->external_db->f('org_enhet_id');
+                       if($external_db->Type == "postgres")
+                       {
+                               $unit_id = 
$this->external_db->f('org_enhet_id');
+                       }
+                       else
+                       {
+                               $unit_id = 
$this->external_db->f('ORG_ENHET_ID');
+                       }
                        $unit_ids[] = $unit_id;
                }
                return $unit_ids;