Changeset 8140 for trunk

Timestamp:

05/06/13 14:23:21 (10 years ago)

Author:

rafaelgobara

Message:

Ticket #3422 - Adicionado método que busca instância pelo wf_instance_id

File:

• trunk/workflow/inc/local/classes/class.wf_instance.php (modified) (1 diff)

trunk/workflow/inc/local/classes/class.wf_instance.php

@@ -440 +440 @@
                 /* fetch and return the results */
                 return $resultSet->GetArray(-1);
+        }
+
+        /**
+        * Busca uma instância pelo id
+        * @param int $wf_instance_id O id da instância
+        * @return array As instâncias que satisfazem o critério de seleção.
+        * @access public
+        */
+        public function getById($wf_instance_id)
+        {
+                /* build the SQL query */
+                $query = 'SELECT i.wf_instance_id AS wf_instance_id, ia.wf_activity_id AS wf_activity_id, ia.wf_started AS wf_started, i.wf_name AS wf_name, i.wf_status AS wf_status, ia.wf_user AS wf_user, i.wf_priority AS wf_priority ';
+                $query .= 'FROM egw_wf_instances i LEFT JOIN egw_wf_instance_activities ia ON (ia.wf_instance_id = i.wf_instance_id)';
+                $query .= 'WHERE (i.wf_p_id = ?) AND i.wf_instance_id = ?';
+
+                $resultSet = $this->db->query($query, array($this->processID, intval($wf_instance_id)));
+                
+                return $resultSet->GetArray();
         }