[Phpgroupware-cvs] property/inc class.sorequest.inc.php,1.11

[sigurdne]

Update of property/inc

Modified Files:
     Branch: MAIN
            class.sorequest.inc.php lines: +20 -9

Log Message:
no message

====================================================
Index: property/inc/class.sorequest.inc.php
diff -u property/inc/class.sorequest.inc.php:1.10 
property/inc/class.sorequest.inc.php:1.11
--- property/inc/class.sorequest.inc.php:1.10   Wed Sep 21 14:18:20 2005
+++ property/inc/class.sorequest.inc.php        Thu Sep 22 08:35:53 2005
@@ -82,12 +82,6 @@

                function update_score($request_id='')
                {
-                       if(!$priority_key)
-                       {
-//                             $priority_key = $this->read_priority_key();
-                       }
-
-
                        if($request_id)
                        {
                                $request[] = $request_id;
@@ -104,8 +98,25 @@

                        while (is_array($request) && list(,$id) = 
each($request))
                        {
-                               $this->db->query("UPDATE fm_request SET score = 
(SELECT sum (priority_key*(degree*probability*(consequence+1))) from 
fm_request_condition"
-                                . " $this->join  fm_request_condition_type ON 
(fm_request_condition.condition_type = fm_request_condition_type.id) WHERE 
request_id = $id) WHERE fm_request.id = $id",__LINE__,__FILE__);
+
+                               
if($GLOBALS['phpgw_info']['server']['db_type']=='pgsql')
+                               {
+                                       $sql = "UPDATE fm_request SET score = 
(SELECT sum(priority_key * ( degree * probability * ( consequence +1 )))  FROM 
fm_request_condition"
+                                        . " $this->join  
fm_request_condition_type ON (fm_request_condition.condition_type = 
fm_request_condition_type.id) WHERE request_id = $id) WHERE fm_request.id = 
$id";
+
+                                       
$this->db->query($sql,__LINE__,__FILE__);
+                               }
+                               else
+                               {
+                                       $sql = "SELECT sum(priority_key * ( 
degree * probability * ( consequence +1 ))) AS score FROM fm_request_condition"
+                                        . " $this->join  
fm_request_condition_type ON (fm_request_condition.condition_type = 
fm_request_condition_type.id) WHERE request_id = $id";
+
+                                       
$this->db->query($sql,__LINE__,__FILE__);
+
+                                       $this->db->next_record();
+                                       $score = $this->db->f('score');
+                                       $this->db->query("UPDATE fm_request SET 
score = $score WHERE id = $id",__LINE__,__FILE__);
+                               }
                        }
                }