[Fmsystem-commits] [8721] property: update loc1 for missing values

[Sigurd Nes]

Revision: 8721
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8721
Author:   sigurdne
Date:     2012-01-30 15:38:37 +0000 (Mon, 30 Jan 2012)
Log Message:
-----------
property: update loc1 for missing values

Modified Paths:
--------------
    trunk/property/setup/tables_update.inc.php

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2012-01-30 14:44:36 UTC (rev 
8720)
+++ trunk/property/setup/tables_update.inc.php  2012-01-30 15:38:37 UTC (rev 
8721)
@@ -5882,6 +5882,25 @@
                        }
                }
 
+               $sql = 'SELECT DISTINCT pmwrkord_code from fm_ecobilagoverf 
WHERE loc1 IS NULL AND pmwrkord_code IS NOT NULL';
+               $GLOBALS['phpgw_setup']->oProc->query($sql,__LINE__,__FILE__);
+               $orders = array();
+               while ($GLOBALS['phpgw_setup']->oProc->next_record())
+               {
+                       $orders[] = 
$GLOBALS['phpgw_setup']->oProc->f('pmwrkord_code');
+               }
+               
+               foreach($orders as $order)
+               {
+                       $sql = "SELECT loc1 FROM fm_project JOIN fm_workorder 
ON fm_project.id = fm_workorder.project_id WHERE fm_workorder.id = '{$order}'";
+                       
$GLOBALS['phpgw_setup']->oProc->query($sql,__LINE__,__FILE__);
+                       $GLOBALS['phpgw_setup']->oProc->next_record();
+                       if($loc1 = $GLOBALS['phpgw_setup']->oProc->f('loc1'))
+                       {
+                               $GLOBALS['phpgw_setup']->oProc->query("UPDATE 
fm_ecobilagoverf SET loc1 = '{$loc1}' WHERE pmwrkord_code = 
'{$order}'",__LINE__,__FILE__);
+                       }
+               }
+                       
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
                {
                        $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.634';