[Phpgroupware-cvs] property/class.sotts.php, 1.1.1.10

[nomail]

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

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

Log Message:
no message
=====================================================================
Index: property/class.sotts.php
diff -u property/class.sotts.php:1.1.1.9 property/class.sotts.php:1.1.1.10
--- property/class.sotts.php:1.1.1.9    Sun May  2 12:47:37 2004
+++ property/class.sotts.php    Sun May  9 13:42:34 2004
@@ -452,12 +452,14 @@
                        $values = $this->bocommon->validate_db_insert($values);
                        $GLOBALS['phpgw']->db->begintrans();
 
-                       $GLOBALS['phpgw']->db->Execute("INSERT into 
fm_tts_tickets (priority,user_id,"
+                       $id = 
$GLOBALS['phpgw']->db->genid('fm_tts_tickets_id_seq');
+
+                       $GLOBALS['phpgw']->db->Execute("INSERT into 
fm_tts_tickets (id,priority,user_id,"
                                . 
"assignedto,group_id,subject,cat_id,status,details,location_code,"
                                . "address,entry_date,finnish_date $cols)"
-                               . "VALUES ($values $vals )");
+                               . "VALUES ($id,$values $vals )");
 
-                       $id = 
$this->db->get_last_insert_id('fm_tts_tickets','id');
+//                     $id = 
$this->db->get_last_insert_id('fm_tts_tickets','id');
                        if($ticket['extra']['contact_phone'])
                        {
                                $GLOBALS['phpgw']->db->Execute("UPDATE 
fm_tenant set contact_phone='". $ticket['extra']['contact_phone']. "' where 
tenant_id='". $ticket['extra']['tenant_id']. "'");