Changeset 2872

Timestamp:

05/27/10 15:02:03 (14 years ago)

Author:

fabianok

Message:

Ticket #1089 - Substituição na consulta que cria nova instância.

File:

• sandbox/workflow/branches/1089/inc/engine/src/API/Instance.php (modified) (1 diff)

sandbox/workflow/branches/1089/inc/engine/src/API/Instance.php

@@ -510 +510 @@
     $this->setStarted($now);
     $this->setOwner($user);
-    
+
+    //Get the id of new instance, before insert values in table and use this value from main table and relationship tables.
+    $this->instanceId = $this->getOne("SELECT nextval('seq_egw_wf_instances')");
+    $iid=$this->instanceId;
+
     $query = 'insert into '.GALAXIA_TABLE_PREFIX.'instances
-      (wf_started,wf_ended,wf_status,wf_p_id,wf_owner,wf_properties) 
-      values(?,?,?,?,?,?)';
-    $this->query($query,array($now,0,'active',$pid,$user,$this->security_cleanup(Array(),false)));
-    $this->instanceId = $this->getOne('select max(wf_instance_id) from '.GALAXIA_TABLE_PREFIX.'instances 
-                      where wf_started=? and wf_owner=?',array((int)$now,$user));
-    $iid=$this->instanceId;
-    
+      (wf_instance_id, wf_started,wf_ended,wf_status,wf_p_id,wf_owner,wf_properties) 
+      values(?,?,?,?,?,?,?)';
+
+   $this->query($query,array((int)$iid, $now,0,'active',$pid,$user,$this->security_cleanup(Array(),false)));
+ 
     // Then add in ".GALAXIA_TABLE_PREFIX."instance_activities an entry for the
     // activity the user and status running and started now