[Phpgroupware-cvs] property/class.sodrawing.php, 1.1.1.7

[nomail]

Update of /property
Modified Files:
        Branch: 
          class.sodrawing.php

date: 2004/05/09 13:42:22;  author: sigurdne;  state: Exp;  lines: +9 -3

Log Message:
no message
=====================================================================
Index: property/class.sodrawing.php
diff -u property/class.sodrawing.php:1.1.1.6 
property/class.sodrawing.php:1.1.1.7
--- property/class.sodrawing.php:1.1.1.6        Fri Apr 30 17:35:56 2004
+++ property/class.sodrawing.php        Sun May  9 13:42:22 2004
@@ -294,9 +294,13 @@
                        $drawing['name'] = 
$this->functions->db_addslashes($drawing['name']);
                        $drawing['title'] = 
$this->functions->db_addslashes($drawing['title']);
 //html_print_r($drawing);
-                       $GLOBALS['phpgw']->db->Execute("INSERT INTO fm_drawing 
(drawing_name,title,access,category,entry_date,drawing_date,version,coordinator,status,"
+                       $GLOBALS['phpgw']->db->begintrans();
+                       $id = $GLOBALS['phpgw']->db->genid('fm_drawing_id_seq');
+
+                       $GLOBALS['phpgw']->db->Execute("INSERT INTO fm_drawing 
(id,drawing_name,title,access,category,entry_date,drawing_date,version,coordinator,status,"
                                . 
"descr,location_code,floor_id,address,branch_id,vendor_id,user_id $cols) "
-                               . "VALUES ('"
+                               . "VALUES ("
+                               . $id. ",'"
                                . $drawing['drawing_name']. "','"
                                . $drawing['title']. "','"
                                . "public','"
@@ -314,11 +318,13 @@
                                . $drawing['vendor_id']. "','"
                                . $this->account. "' $vals)");
 
-                       $receipt['drawing_id'] = 
$this->db->get_last_insert_id('fm_drawing','id');
+//                     $receipt['drawing_id'] = 
$this->db->get_last_insert_id('fm_drawing','id');
+                       $receipt['drawing_id'] = $id;
 
                        
$this->historylog->add('SO',$receipt['drawing_id'],$drawing['status']);
                        
$this->historylog->add('TO',$receipt['drawing_id'],$drawing['cat_id']);
                        
$this->historylog->add('CO',$receipt['drawing_id'],$drawing['coordinator']);
+                       $GLOBALS['phpgw']->db->committrans();
 
                        $receipt['message'][] = array('msg'=>lang('drawing %1 
has been saved',"'".$drawing['drawing_name']."'"));
                        return $receipt;