phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] property/inc/custom oppdater_utgaatt_objekt.php, 1.3


From: sigurdne
Subject: [Phpgroupware-cvs] property/inc/custom oppdater_utgaatt_objekt.php, 1.3
Date: Thu, 24 Feb 2005 15:29:11 -0000

Update of property/inc/custom

Modified Files:
     Branch: MAIN
            oppdater_utgaatt_objekt.php lines: +8 -4

Log Message:
no message

====================================================
Index: property/inc/custom/oppdater_utgaatt_objekt.php
diff -u property/inc/custom/oppdater_utgaatt_objekt.php:1.2 
property/inc/custom/oppdater_utgaatt_objekt.php:1.3
--- property/inc/custom/oppdater_utgaatt_objekt.php:1.2 Thu Jan 13 17:00:04 2005
+++ property/inc/custom/oppdater_utgaatt_objekt.php     Tue Feb  1 15:08:10 2005
@@ -160,15 +160,19 @@
                                for ($i=0; $i<count($update); $i++)
                                {

-                                       $sql = "SELECT status  FROM 
$parent_table WHERE location_code= '" . $update[$i]['location_code'] ."'";
+                                       $sql = "SELECT category FROM 
$parent_table WHERE location_code= '" . $update[$i]['location_code'] ."'";

                                        
$this->db->query($sql,__LINE__,__FILE__);
                                        $this->db->next_record();

-                                       if($this->db->f('status')!=2)
+                                       if($this->db->f('category')!=99)
                                        {
                                                $j++;
-                                               $this->db->query("UPDATE 
fm_location" . ($type_id-1). " set     status= 2  WHERE location_code= '" . 
$update[$i]['location_code'] ."'",__LINE__,__FILE__);
+                                               $this->db->query("UPDATE 
fm_location" . ($type_id-1). " set     status= 2, category=99  WHERE 
location_code= '" . $update[$i]['location_code'] ."'",__LINE__,__FILE__);
+                                               if($type_id == 2)
+                                               {
+                                                       
$this->db->query("UPDATE fm_location1 set kostra_id = NULL  WHERE 
location_code= '" . $update[$i]['location_code'] ."'",__LINE__,__FILE__);
+                                               }
                                        }
                                }







reply via email to

[Prev in Thread] Current Thread [Next in Thread]