[Phpgroupware-cvs] property/inc/class.soproject.inc.php, 1.6

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.soproject.inc.php

date: 2004/09/13 07:19:10;  author: sigurdne;  state: Exp;  lines: +20 -0

Log Message:
no message
=====================================================================
Index: property/inc/class.soproject.inc.php
diff -u property/inc/class.soproject.inc.php:1.5 
property/inc/class.soproject.inc.php:1.6
--- property/inc/class.soproject.inc.php:1.5    Sun Jul  4 17:24:39 2004
+++ property/inc/class.soproject.inc.php        Mon Sep 13 07:19:10 2004
@@ -842,6 +842,17 @@
                                $request_id[]   = $this->db->f('origin_id');
                        }
 
+
+                       $sql = "SELECT id as workorder_id FROM fm_workorder 
WHERE project_id='$project_id'";
+                       $this->db->query($sql,__LINE__,__FILE__);
+
+                       while ($this->db->next_record())
+                       {
+                               $workorder_id[] = $this->db->f('workorder_id');
+                       }
+
+                       $this->db->transaction_begin();
+
                        for ($i=0;$i<count($request_id);$i++)
                        {
 
@@ -852,6 +863,15 @@
                        $this->db->query("DELETE FROM fm_project_history  WHERE 
 history_record_id='" . $project_id   . "'",__LINE__,__FILE__);
                        $this->db->query("DELETE FROM fm_projectbranch  WHERE  
project_id='" . $project_id   . "'",__LINE__,__FILE__);
                        $this->db->query("DELETE FROM fm_project_origin WHERE 
project_id='" . $project_id . "'",__LINE__,__FILE__);
+                       $this->db->query("DELETE FROM fm_workorder WHERE 
project_id='" . $project_id . "'",__LINE__,__FILE__);
+
+                       for ($i=0;$i<count($workorder_id);$i++)
+                       {
+                               $this->db->query("DELETE FROM fm_wo_hours WHERE 
workorder_id='" . $workorder_id[$i] . "'",__LINE__,__FILE__);
+                               $this->db->query("DELETE FROM 
fm_workorder_history  WHERE  history_record_id='" . $workorder_id[$i]   . 
"'",__LINE__,__FILE__);
+                       }
+
+                       $this->db->transaction_commit();
 
                }
        }