1 | <?php |
---|
2 | require_once(GALAXIA_LIBRARY.SEP.'src'.SEP.'common'.SEP.'Base.php'); |
---|
3 | |
---|
4 | /** |
---|
5 | * Provides methods for use in typical monitoring scripts, where the first part are methods for cleaning up instances and workitems associated with a process |
---|
6 | * and the second, methods to obtains information about the actual state or histroy of the process |
---|
7 | * |
---|
8 | * @package Galaxia |
---|
9 | * @license http://www.gnu.org/copyleft/gpl.html GPL |
---|
10 | */ |
---|
11 | class ProcessMonitor extends Base |
---|
12 | { |
---|
13 | /** |
---|
14 | * Constructor |
---|
15 | * |
---|
16 | * @param object &$db ADOdb |
---|
17 | * @return object ProcessMonitor |
---|
18 | * @access public |
---|
19 | */ |
---|
20 | function ProcessMonitor(&$db) |
---|
21 | { |
---|
22 | $this->child_name = 'ProcessMonitor'; |
---|
23 | parent::Base($db); |
---|
24 | // check the the actual user can really do this |
---|
25 | if ( !(galaxia_user_can_monitor())) |
---|
26 | { |
---|
27 | unset($this); |
---|
28 | galaxia_show_error('forbidden access to ProcessMonitor object'); |
---|
29 | } |
---|
30 | } |
---|
31 | |
---|
32 | /** |
---|
33 | * Gets statistics about all processes handled by the engine |
---|
34 | * |
---|
35 | * @return array Resulting array has the following pairs of keys and values: |
---|
36 | * [active_processes] => number, [processes] => number (total number of processes), [running_processes] => number, |
---|
37 | * [active_instances] => number, [completed_instances] => number, [exception_instances] => number, [aborted_instances] => number |
---|
38 | * @access public |
---|
39 | */ |
---|
40 | function monitor_stats() { |
---|
41 | $res = Array(); |
---|
42 | $res['active_processes'] = $this->getOne("select count(*) from `".GALAXIA_TABLE_PREFIX."processes` where `wf_is_active`=?",array('y')); |
---|
43 | $res['processes'] = $this->getOne("select count(*) from `".GALAXIA_TABLE_PREFIX."processes`"); |
---|
44 | $result = $this->query("select distinct(`wf_p_id`) from `".GALAXIA_TABLE_PREFIX."instances` where `wf_status`=?",array('active')); |
---|
45 | $res['running_processes'] = $result->numRows(); |
---|
46 | // get the number of instances per status |
---|
47 | $query = "select wf_status, count(*) as num_instances from ".GALAXIA_TABLE_PREFIX."instances group by wf_status"; |
---|
48 | $result = $this->query($query); |
---|
49 | $status = array(); |
---|
50 | while($info = $result->fetchRow()) { |
---|
51 | $status[$info['wf_status']] = $info['num_instances']; |
---|
52 | } |
---|
53 | $res['active_instances'] = isset($status['active']) ? $status['active'] : 0; |
---|
54 | $res['completed_instances'] = isset($status['completed']) ? $status['completed'] : 0; |
---|
55 | $res['exception_instances'] = isset($status['exception']) ? $status['exception'] : 0; |
---|
56 | $res['aborted_instances'] = isset($status['aborted']) ? $status['aborted'] : 0; |
---|
57 | return $res; |
---|
58 | } |
---|
59 | |
---|
60 | /** |
---|
61 | * @deprecated |
---|
62 | */ |
---|
63 | function update_instance_status($iid,$status) { |
---|
64 | return; |
---|
65 | $query = "update `".GALAXIA_TABLE_PREFIX."instances` set `wf_status`=? where `wf_instance_id`=?"; |
---|
66 | $this->query($query,array($status,$iid)); |
---|
67 | } |
---|
68 | |
---|
69 | |
---|
70 | /** |
---|
71 | * @deprecated |
---|
72 | */ |
---|
73 | function update_instance_activity_status($iid,$activityId,$status) { |
---|
74 | return; |
---|
75 | $query = "update `".GALAXIA_TABLE_PREFIX."instance_activities` set `wf_status`=? where `wf_instance_id`=? and `wf_activity_id`=?"; |
---|
76 | $this->query($query,array($status,$iid,$activityId)); |
---|
77 | } |
---|
78 | |
---|
79 | /** |
---|
80 | * Removes instance along with its workitems (history), current activities and properties altogether |
---|
81 | * |
---|
82 | * @param int $iid Instance id |
---|
83 | * @return bool |
---|
84 | * @access public |
---|
85 | */ |
---|
86 | function remove_instance($iid) |
---|
87 | { |
---|
88 | // start a transaction |
---|
89 | $this->db->StartTrans(); |
---|
90 | $query = "delete from `".GALAXIA_TABLE_PREFIX."workitems` where `wf_instance_id`=?"; |
---|
91 | $this->query($query,array($iid)); |
---|
92 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instance_activities` where `wf_instance_id`=?"; |
---|
93 | $this->query($query,array($iid)); |
---|
94 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instances` where `wf_instance_id`=?"; |
---|
95 | $this->query($query,array($iid)); |
---|
96 | // perform commit (return true) or Rollback (return false) |
---|
97 | return $this->db->CompleteTrans(); |
---|
98 | |
---|
99 | } |
---|
100 | |
---|
101 | /** |
---|
102 | * Removes aborted instances along with workitems (history), |
---|
103 | * you can limit this behaviour to a single process by specifying its process id |
---|
104 | * |
---|
105 | * @param int $process_id Providable process id to limit this function range to only one process |
---|
106 | * @return bool |
---|
107 | * @access public |
---|
108 | */ |
---|
109 | function remove_aborted($pId=0) |
---|
110 | { |
---|
111 | // check the the actual user can really do this |
---|
112 | if ( !((galaxia_user_can_clean_instances()) || (galaxia_user_can_clean_aborted_instances())) ) |
---|
113 | { |
---|
114 | $this->error[] = tra('user is not authorized to delete aborted instances'); |
---|
115 | return false; |
---|
116 | } |
---|
117 | if (!($pId)) |
---|
118 | { |
---|
119 | $whereand = ''; |
---|
120 | $bindvars = array('aborted'); |
---|
121 | } |
---|
122 | else |
---|
123 | { |
---|
124 | $whereand = 'and wf_p_id = ?'; |
---|
125 | $bindvars = array('aborted', $pId); |
---|
126 | } |
---|
127 | $query="select `wf_instance_id` from `".GALAXIA_TABLE_PREFIX."instances` where `wf_status`=?".$whereand; |
---|
128 | // start a transaction |
---|
129 | $this->db->StartTrans(); |
---|
130 | $result = $this->query($query,$bindvars); |
---|
131 | while($res = $result->fetchRow()) |
---|
132 | { |
---|
133 | $iid = $res['wf_instance_id']; |
---|
134 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instance_activities` where `wf_instance_id`=?"; |
---|
135 | $this->query($query,array($iid)); |
---|
136 | $query = "delete from `".GALAXIA_TABLE_PREFIX."workitems` where `wf_instance_id`=?"; |
---|
137 | $this->query($query,array($iid)); |
---|
138 | } |
---|
139 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instances` where `wf_status`=?".$whereand; |
---|
140 | $this->query($query,$bindvars); |
---|
141 | // perform commit (return true) or Rollback (return false) |
---|
142 | return $this->db->CompleteTrans(); |
---|
143 | } |
---|
144 | |
---|
145 | /** |
---|
146 | * Provided a process, it removes instances, workitems (history) and activities current running associated with these instances |
---|
147 | * |
---|
148 | * @param int $pId Process id whose contents will be erased |
---|
149 | * @return bool |
---|
150 | * @access public |
---|
151 | */ |
---|
152 | function remove_all($pId) { |
---|
153 | // check the the actual user can really do this |
---|
154 | if ( !(galaxia_user_can_clean_instances()) ) |
---|
155 | { |
---|
156 | $this->error[] = tra('user is not authorized to delete instances'); |
---|
157 | return false; |
---|
158 | } |
---|
159 | $query="select `wf_instance_id` from `".GALAXIA_TABLE_PREFIX."instances` where `wf_p_id`=?"; |
---|
160 | // start a transaction |
---|
161 | $this->db->StartTrans(); |
---|
162 | $result = $this->query($query,array($pId)); |
---|
163 | while($res = $result->fetchRow()) { |
---|
164 | $iid = $res['wf_instance_id']; |
---|
165 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instance_activities` where `wf_instance_id`=?"; |
---|
166 | $this->query($query,array($iid)); |
---|
167 | $query = "delete from `".GALAXIA_TABLE_PREFIX."workitems` where `wf_instance_id`=?"; |
---|
168 | $this->query($query,array($iid)); |
---|
169 | } |
---|
170 | $query = "delete from `".GALAXIA_TABLE_PREFIX."instances` where `wf_p_id`=?"; |
---|
171 | $this->query($query,array($pId)); |
---|
172 | // perform commit (return true) or Rollback (return false) |
---|
173 | return $this->db->CompleteTrans(); |
---|
174 | } |
---|
175 | |
---|
176 | /** |
---|
177 | * Lists all processes and return stats |
---|
178 | * |
---|
179 | * @param int $offset Starting row number to return |
---|
180 | * @param int $maxRecords Max number of records to return |
---|
181 | * @param string $sort_mode Sort order |
---|
182 | * @param string $find Search for in process name or process description |
---|
183 | * @param string $where Condition query, be carefull with this string, read the query before |
---|
184 | * @param bool $add_stats True by default, by setting it to false you wont get the statistics associated with |
---|
185 | * the processes, this could be helpfull for gui listing on selects, to avoid (a big number of) unnecessary queries |
---|
186 | * @return array Associative, with the number of records for the 'cant' key and an array of process stats for the |
---|
187 | * 'data' key. each row follows this form: key : process_id, value : an array of infos: |
---|
188 | * keys are : wf_p_id, wf_name, wf_is_valid, wf_is_active, wf_version, wf_description, wf_last_modif, |
---|
189 | * and wf_normalized_name for the 'classical part' and for the 'stats part' whe have: active_instances, |
---|
190 | * exception_instances, completed_instances, aborted_instances, all_instances, activities |
---|
191 | * @access public |
---|
192 | */ |
---|
193 | function monitor_list_processes($offset,$maxRecords,$sort_mode,$find,$where='', $add_stats=true) |
---|
194 | { |
---|
195 | |
---|
196 | $sort_mode = $this->convert_sortmode($sort_mode); |
---|
197 | if($find) { |
---|
198 | $findesc = '%'.$find.'%'; |
---|
199 | $mid=" where ((wf_name like ?) or (wf_description like ?))"; |
---|
200 | $bindvars = array($findesc,$findesc); |
---|
201 | } else { |
---|
202 | $mid=""; |
---|
203 | $bindvars = array(); |
---|
204 | } |
---|
205 | if($where) { |
---|
206 | if($mid) { |
---|
207 | $mid.= " and ($where) "; |
---|
208 | } else { |
---|
209 | $mid.= " where ($where) "; |
---|
210 | } |
---|
211 | } |
---|
212 | // get the requested processes |
---|
213 | $query = "select * from ".GALAXIA_TABLE_PREFIX."processes $mid order by $sort_mode"; |
---|
214 | $query_cant = "select count(*) from ".GALAXIA_TABLE_PREFIX."processes $mid"; |
---|
215 | $result = $this->query($query,$bindvars,$maxRecords,$offset); |
---|
216 | $cant = $this->getOne($query_cant,$bindvars); |
---|
217 | $ret = Array(); |
---|
218 | while($res = $result->fetchRow()) { |
---|
219 | $pId = $res['wf_p_id']; |
---|
220 | // Number of active instances |
---|
221 | $res['active_instances'] = 0; |
---|
222 | // Number of exception instances |
---|
223 | $res['exception_instances'] = 0; |
---|
224 | // Number of completed instances |
---|
225 | $res['completed_instances'] = 0; |
---|
226 | // Number of aborted instances |
---|
227 | $res['aborted_instances'] = 0; |
---|
228 | $res['all_instances'] = 0; |
---|
229 | // Number of activities |
---|
230 | $res['activities'] = 0; |
---|
231 | $ret[$pId] = $res; |
---|
232 | } |
---|
233 | if (count($ret) < 1) { |
---|
234 | $retval = Array(); |
---|
235 | $retval["data"] = $ret; |
---|
236 | $retval["cant"] = $cant; |
---|
237 | return $retval; |
---|
238 | } |
---|
239 | if ($add_stats) |
---|
240 | { |
---|
241 | // get number of instances and timing statistics per process and status |
---|
242 | $query = "select wf_p_id, wf_status, count(*) as num_instances, |
---|
243 | min(wf_ended - wf_started) as min_time, avg(wf_ended - wf_started) as avg_time, max(wf_ended - wf_started) as max_time |
---|
244 | from ".GALAXIA_TABLE_PREFIX."instances where wf_p_id in (" . join(', ', array_keys($ret)) . ") group by wf_p_id, wf_status"; |
---|
245 | $result = $this->query($query); |
---|
246 | while($res = $result->fetchRow()) { |
---|
247 | $pId = $res['wf_p_id']; |
---|
248 | if (!isset($ret[$pId])) continue; |
---|
249 | switch ($res['wf_status']) { |
---|
250 | case 'active': |
---|
251 | $ret[$pId]['active_instances'] = $res['num_instances']; |
---|
252 | $ret[$pId]['all_instances'] += $res['num_instances']; |
---|
253 | break; |
---|
254 | case 'completed': |
---|
255 | $ret[$pId]['completed_instances'] = $res['num_instances']; |
---|
256 | $ret[$pId]['all_instances'] += $res['num_instances']; |
---|
257 | $ret[$pId]['duration'] = array('min' => $res['min_time'], 'avg' => $res['avg_time'], 'max' => $res['max_time']); |
---|
258 | break; |
---|
259 | case 'exception': |
---|
260 | $ret[$pId]['exception_instances'] = $res['num_instances']; |
---|
261 | $ret[$pId]['all_instances'] += $res['num_instances']; |
---|
262 | break; |
---|
263 | case 'aborted': |
---|
264 | $ret[$pId]['aborted_instances'] = $res['num_instances']; |
---|
265 | $ret[$pId]['all_instances'] += $res['num_instances']; |
---|
266 | break; |
---|
267 | } |
---|
268 | } |
---|
269 | // get number of activities per process |
---|
270 | $query = "select wf_p_id, count(*) as num_activities |
---|
271 | from ".GALAXIA_TABLE_PREFIX."activities |
---|
272 | where wf_p_id in (" . join(', ', array_keys($ret)) . ") |
---|
273 | group by wf_p_id"; |
---|
274 | $result = $this->query($query); |
---|
275 | while($res = $result->fetchRow()) { |
---|
276 | $pId = $res['wf_p_id']; |
---|
277 | if (!isset($ret[$pId])) continue; |
---|
278 | $ret[$pId]['activities'] = $res['num_activities']; |
---|
279 | } |
---|
280 | } |
---|
281 | $retval = Array(); |
---|
282 | $retval["data"] = $ret; |
---|
283 | $retval["cant"] = $cant; |
---|
284 | return $retval; |
---|
285 | } |
---|
286 | |
---|
287 | /** |
---|
288 | * Lists all activities and return stats |
---|
289 | * |
---|
290 | * @param int $offset First row number to return |
---|
291 | * @param int $maxRecords Maximum number of records to return |
---|
292 | * @param string $sort_mode Sort order |
---|
293 | * @param string $find Search for in activity name or activity description |
---|
294 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
295 | * @param bool $add_stats True by default, by setting it to false you wont get the statistics associated with |
---|
296 | * the activities, this could be helpfull for gui listing on selects, to avoid (a big number of) unnecessary queries |
---|
297 | * @return array Associative, with the number of records for the 'cant' key and an array of process stats for the |
---|
298 | * 'data' key. each row is of this form: key : activity_id, value : an array of infos: keys are : wf_procname, wf_version, |
---|
299 | * wf_proc_normalized_name, wf_activity_id, wf_name, wf_normalized_name, wf_p_id, wf_type, wf_is_autorouted, wf_flow_num, |
---|
300 | * wf_is_interactive, wf_last_modif, wf_description, wf_default_user and for the stats part: active_instances, completed_instances, |
---|
301 | * aborted_instances, exception_instances, act_running_instances, act_completed_instances |
---|
302 | * @access public |
---|
303 | */ |
---|
304 | function monitor_list_activities($offset,$maxRecords,$sort_mode,$find,$where='', $add_stats=true) |
---|
305 | { |
---|
306 | |
---|
307 | $sort_mode = $this->convert_sortmode($sort_mode); |
---|
308 | if($find) { |
---|
309 | $findesc = '%'.$find.'%'; |
---|
310 | $mid=" where ((ga.wf_name like ?) or (ga.wf_description like ?))"; |
---|
311 | $bindvars = array($findesc,$findesc); |
---|
312 | } else { |
---|
313 | $mid=""; |
---|
314 | $bindvars = array(); |
---|
315 | } |
---|
316 | if($where) { |
---|
317 | $where = preg_replace('/pId/', 'ga.wf_p_id', $where); |
---|
318 | if($mid) { |
---|
319 | $mid.= " and ($where) "; |
---|
320 | } else { |
---|
321 | $mid.= " where ($where) "; |
---|
322 | } |
---|
323 | } |
---|
324 | $query = "select gp.`wf_name` as `wf_procname`, gp.`wf_version`, gp.wf_normalized_name as wf_proc_normalized_name, ga.* |
---|
325 | from ".GALAXIA_TABLE_PREFIX."activities ga |
---|
326 | left join ".GALAXIA_TABLE_PREFIX."processes gp on gp.wf_p_id=ga.wf_p_id |
---|
327 | $mid order by $sort_mode"; |
---|
328 | $query_cant = "select count(*) from ".GALAXIA_TABLE_PREFIX."activities ga $mid"; |
---|
329 | $result = $this->query($query,$bindvars,$maxRecords,$offset); |
---|
330 | $cant = $this->getOne($query_cant,$bindvars); |
---|
331 | $ret = Array(); |
---|
332 | while($res = $result->fetchRow()) { |
---|
333 | // Number of active instances |
---|
334 | $aid = $res['wf_activity_id']; |
---|
335 | if ($add_stats) |
---|
336 | { |
---|
337 | $res['active_instances']=$this->getOne("select count(gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."instance_activities gia where gi.wf_instance_id=gia.wf_instance_id and gia.wf_activity_id=$aid and gi.wf_status='active' and wf_p_id=".$res['wf_p_id']); |
---|
338 | // activities of completed instances are all removed from the instance_activities table for some reason, so we need to look at workitems |
---|
339 | $res['completed_instances']=$this->getOne("select count(distinct gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."workitems gw where gi.wf_instance_id=gw.wf_instance_id and gw.wf_activity_id=$aid and gi.wf_status='completed' and wf_p_id=".$res['wf_p_id']); |
---|
340 | // activities of aborted instances are all removed from the instance_activities table for some reason, so we need to look at workitems |
---|
341 | $res['aborted_instances']=$this->getOne("select count(distinct gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."workitems gw where gi.wf_instance_id=gw.wf_instance_id and gw.wf_activity_id=$aid and gi.wf_status='aborted' and wf_p_id=".$res['wf_p_id']); |
---|
342 | $res['exception_instances']=$this->getOne("select count(gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."instance_activities gia where gi.wf_instance_id=gia.wf_instance_id and gia.wf_activity_id=$aid and gi.wf_status='exception' and wf_p_id=".$res['wf_p_id']); |
---|
343 | $res['act_running_instances']=$this->getOne("select count(gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."instance_activities gia where gi.wf_instance_id=gia.wf_instance_id and gia.wf_activity_id=$aid and gia.wf_status='running' and wf_p_id=".$res['wf_p_id']); |
---|
344 | // completed activities are removed from the instance_activities table unless they're part of a split for some reason, so this won't work |
---|
345 | // $res['act_completed_instances']=$this->getOne("select count(gi.wf_instance_id) from ".GALAXIA_TABLE_PREFIX."instances gi,".GALAXIA_TABLE_PREFIX."instance_activities gia where gi.wf_instance_id=gia.wf_instance_id and gia.activityId=$aid and gia.status='completed' and pId=".$res['pId']); |
---|
346 | $res['act_completed_instances'] = 0; |
---|
347 | } |
---|
348 | $ret[$aid] = $res; |
---|
349 | } |
---|
350 | if (count($ret) < 1) { |
---|
351 | $retval = Array(); |
---|
352 | $retval["data"] = $ret; |
---|
353 | $retval["cant"] = $cant; |
---|
354 | return $retval; |
---|
355 | } |
---|
356 | if ($add_stats) |
---|
357 | { |
---|
358 | $query = "select wf_activity_id, count(distinct wf_instance_id) as num_instances, min(wf_ended - wf_started) as min_time, avg(wf_ended - wf_started) as avg_time, max(wf_ended - wf_started) as max_time |
---|
359 | from ".GALAXIA_TABLE_PREFIX."workitems |
---|
360 | where wf_activity_id in (" . join(', ', array_keys($ret)) . ") |
---|
361 | group by wf_activity_id"; |
---|
362 | $result = $this->query($query); |
---|
363 | while($res = $result->fetchRow()) { |
---|
364 | // Number of active instances |
---|
365 | $aid = $res['wf_activity_id']; |
---|
366 | if (!isset($ret[$aid])) continue; |
---|
367 | $ret[$aid]['act_completed_instances'] = $res['num_instances'] - $ret[$aid]['aborted_instances']; |
---|
368 | $ret[$aid]['duration'] = array('min' => $res['min_time'], 'avg' => $res['avg_time'], 'max' => $res['max_time']); |
---|
369 | } |
---|
370 | } |
---|
371 | $retval = Array(); |
---|
372 | $retval["data"] = $ret; |
---|
373 | $retval["cant"] = $cant; |
---|
374 | return $retval; |
---|
375 | } |
---|
376 | |
---|
377 | /** |
---|
378 | * Lists all instances and return stats |
---|
379 | * |
---|
380 | * @param int $offset First row number to return |
---|
381 | * @param int $maxRecords Maximum number of records to return |
---|
382 | * @param string $sort_mode Sort order |
---|
383 | * @param string $find Search for in instance name or instance description |
---|
384 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
385 | * @return array Associative |
---|
386 | * @access public |
---|
387 | */ |
---|
388 | function monitor_list_instances($offset,$maxRecords,$sort_mode,$find,$where='') |
---|
389 | { |
---|
390 | $wherevars = array(); |
---|
391 | if($find) { |
---|
392 | $findesc = $this->qstr('%'.$find.'%'); |
---|
393 | $mid=' where ((`wf_properties` like ?) or (gi.`wf_name` like ?) |
---|
394 | or (ga.`wf_name` like ?) or (gp.`wf_name` like ?))'; |
---|
395 | $wherevars[] = $findesc; |
---|
396 | $wherevars[] = $findesc; |
---|
397 | $wherevars[] = $findesc; |
---|
398 | $wherevars[] = $findesc; |
---|
399 | } else { |
---|
400 | $mid=''; |
---|
401 | } |
---|
402 | if($where) { |
---|
403 | if($mid) { |
---|
404 | $mid.= " and ($where) "; |
---|
405 | } else { |
---|
406 | $mid.= " where ($where) "; |
---|
407 | } |
---|
408 | } |
---|
409 | |
---|
410 | $query = 'select gp.wf_p_id, ga.wf_is_interactive,gp.wf_normalized_name as wf_proc_normalized_name, gi.wf_owner, gp.wf_name as wf_procname, gp.wf_version, ga.wf_type,'; |
---|
411 | $query.= ' ga.wf_activity_id, ga.wf_name as wf_activity_name, gi.wf_instance_id, gi.wf_name as wf_instance_name, gi.wf_priority, gi.wf_status, gia.wf_activity_id, gia.wf_user, gia.wf_started as wf_act_started, gi.wf_started, gi.wf_ended, gia.wf_status as wf_act_status '; |
---|
412 | $query.= ' from `'.GALAXIA_TABLE_PREFIX.'instances` gi LEFT JOIN `'.GALAXIA_TABLE_PREFIX.'instance_activities` gia ON gi.`wf_instance_id`=gia.`wf_instance_id` '; |
---|
413 | $query.= 'LEFT JOIN `'.GALAXIA_TABLE_PREFIX.'activities` ga ON gia.`wf_activity_id` = ga.`wf_activity_id` '; |
---|
414 | $query.= 'LEFT JOIN `'.GALAXIA_TABLE_PREFIX."processes` gp ON gp.`wf_p_id`=gi.`wf_p_id` $mid"; |
---|
415 | |
---|
416 | $query_cant = 'select count(*) from `'.GALAXIA_TABLE_PREFIX.'instances` gi LEFT JOIN `'.GALAXIA_TABLE_PREFIX.'instance_activities` gia ON gi.`wf_instance_id`=gia.`wf_instance_id` '; |
---|
417 | $query_cant.= 'LEFT JOIN `'.GALAXIA_TABLE_PREFIX.'activities` ga ON gia.`wf_activity_id` = ga.`wf_activity_id` LEFT JOIN `'.GALAXIA_TABLE_PREFIX."processes` gp ON gp.`wf_p_id`=gi.`wf_p_id` $mid"; |
---|
418 | $result = $this->query($query,$wherevars,$maxRecords,$offset,true,$this->convert_sortmode($sort_mode)); |
---|
419 | $cant = $this->getOne($query_cant,$wherevars); |
---|
420 | |
---|
421 | $ret = Array(); |
---|
422 | while($res = $result->fetchRow()) |
---|
423 | $ret[] = $res; |
---|
424 | |
---|
425 | $retval = Array(); |
---|
426 | $retval['data'] = $ret; |
---|
427 | $retval['cant'] = $cant; |
---|
428 | return $retval; |
---|
429 | } |
---|
430 | |
---|
431 | /** |
---|
432 | * Lists completed instances and return stats |
---|
433 | * |
---|
434 | * @param int $offset First row number to return |
---|
435 | * @param int $maxRecords Maximum number of records to return |
---|
436 | * @param string $sort_mode Sort order |
---|
437 | * @param string $find Search for in instance name or instance description |
---|
438 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
439 | * @return array Associative |
---|
440 | * @access public |
---|
441 | */ |
---|
442 | function monitor_list_completed_instances($offset,$maxRecords,$sort_mode,$find,$where='') |
---|
443 | { |
---|
444 | $wherevars = array(); |
---|
445 | $mid = " where (gi.wf_status IN ('completed', 'aborted'))"; |
---|
446 | if($find) |
---|
447 | { |
---|
448 | $findesc = $this->qstr('%'.$find.'%'); |
---|
449 | $mid=' AND ((gi.`wf_name` LIKE ?) |
---|
450 | OR (gp.`wf_name` LIKE ?))'; |
---|
451 | $wherevars[] = $findesc; |
---|
452 | $wherevars[] = $findesc; |
---|
453 | $wherevars[] = $findesc; |
---|
454 | } |
---|
455 | |
---|
456 | if($where) |
---|
457 | { |
---|
458 | if($mid) |
---|
459 | $mid.= " and ($where) "; |
---|
460 | else |
---|
461 | $mid.= " where ($where) "; |
---|
462 | } |
---|
463 | |
---|
464 | $query = 'select gp.wf_p_id, gp.wf_normalized_name as wf_proc_normalized_name, gi.wf_owner, gp.wf_name as wf_procname, gp.wf_version,'; |
---|
465 | $query.= ' gi.wf_instance_id, gi.wf_name as wf_instance_name, gi.wf_priority, gi.wf_status, gi.wf_started, gi.wf_ended '; |
---|
466 | $query.= ' from `'.GALAXIA_TABLE_PREFIX.'instances` gi LEFT JOIN `'.GALAXIA_TABLE_PREFIX."processes` gp ON gp.`wf_p_id`=gi.`wf_p_id` $mid"; |
---|
467 | |
---|
468 | $query_cant = 'select count(*) from `'.GALAXIA_TABLE_PREFIX.'instances` gi LEFT JOIN `'.GALAXIA_TABLE_PREFIX."processes` gp ON gp.`wf_p_id`=gi.`wf_p_id` $mid"; |
---|
469 | $result = $this->query($query,$wherevars,$maxRecords,$offset,true,$this->convert_sortmode($sort_mode)); |
---|
470 | $cant = $this->getOne($query_cant,$wherevars); |
---|
471 | |
---|
472 | $ret = Array(); |
---|
473 | while($res = $result->fetchRow()) |
---|
474 | $ret[] = $res; |
---|
475 | |
---|
476 | $retval = Array(); |
---|
477 | $retval['data'] = $ret; |
---|
478 | $retval['cant'] = $cant; |
---|
479 | return $retval; |
---|
480 | } |
---|
481 | |
---|
482 | /** |
---|
483 | * Lists all processes |
---|
484 | * |
---|
485 | * @param string $sort_mode Sort order |
---|
486 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
487 | * @return array Associative |
---|
488 | * @access public |
---|
489 | */ |
---|
490 | function monitor_list_all_processes($sort_mode = 'wf_name_asc', $where = '') { |
---|
491 | if (!empty($where)) { |
---|
492 | $where = " where ($where) "; |
---|
493 | } |
---|
494 | $query = "select `wf_name`,`wf_version`,`wf_p_id` from `".GALAXIA_TABLE_PREFIX."processes` $where order by ".$this->convert_sortmode($sort_mode); |
---|
495 | $result = $this->query($query); |
---|
496 | $ret = Array(); |
---|
497 | while($res = $result->fetchRow()) { |
---|
498 | $pId = $res['wf_p_id']; |
---|
499 | $ret[$pId] = $res; |
---|
500 | } |
---|
501 | return $ret; |
---|
502 | } |
---|
503 | |
---|
504 | /** |
---|
505 | * Lists all activities |
---|
506 | * |
---|
507 | * @param string $sort_mode Sort order |
---|
508 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
509 | * @return array Associative |
---|
510 | * @access public |
---|
511 | */ |
---|
512 | function monitor_list_all_activities($sort_mode = 'wf_name_asc', $where = '') { |
---|
513 | if (!empty($where)) { |
---|
514 | $where = " where ($where) "; |
---|
515 | } |
---|
516 | $query = "select `wf_name`,`wf_activity_id` from `".GALAXIA_TABLE_PREFIX."activities` $where order by ".$this->convert_sortmode($sort_mode); |
---|
517 | $result = $this->query($query); |
---|
518 | $ret = Array(); |
---|
519 | while($res = $result->fetchRow()) { |
---|
520 | $aid = $res['wf_activity_id']; |
---|
521 | $ret[$aid] = $res; |
---|
522 | } |
---|
523 | return $ret; |
---|
524 | } |
---|
525 | |
---|
526 | /** |
---|
527 | * Lists instances status types in the database |
---|
528 | * |
---|
529 | * @return array Associative |
---|
530 | * @access public |
---|
531 | */ |
---|
532 | function monitor_list_statuses() { |
---|
533 | $query = "select distinct(`wf_status`) from `".GALAXIA_TABLE_PREFIX."instances`"; |
---|
534 | $result = $this->query($query); |
---|
535 | $ret = Array(); |
---|
536 | while($res = $result->fetchRow()) { |
---|
537 | $ret[] = $res['wf_status']; |
---|
538 | } |
---|
539 | return $ret; |
---|
540 | } |
---|
541 | |
---|
542 | /** |
---|
543 | * List users associated with instances available in the current database |
---|
544 | * |
---|
545 | * @return array Associative |
---|
546 | * @access public |
---|
547 | */ |
---|
548 | function monitor_list_users($where = null, $bindVars = null) |
---|
549 | { |
---|
550 | $query = "select distinct(`wf_user`) from `".GALAXIA_TABLE_PREFIX."instance_activities`"; |
---|
551 | if (!is_null($where)) |
---|
552 | $query .= ' WHERE ' . $where; |
---|
553 | if (!is_null($bindVars) && is_array($bindVars)) |
---|
554 | $result = $this->query($query); |
---|
555 | else |
---|
556 | $result = $this->query($query, $bindVars); |
---|
557 | $ret = Array(); |
---|
558 | while($res = $result->fetchRow()) { |
---|
559 | $ret[] = $res['wf_user']; |
---|
560 | } |
---|
561 | return $ret; |
---|
562 | } |
---|
563 | |
---|
564 | /** |
---|
565 | * List users associated with workitems available in the current database |
---|
566 | * |
---|
567 | * @return array Associative |
---|
568 | * @access public |
---|
569 | */ |
---|
570 | function monitor_list_wi_users() { |
---|
571 | $query = "select distinct(`wf_user`) from `".GALAXIA_TABLE_PREFIX."workitems`"; |
---|
572 | $result = $this->query($query); |
---|
573 | $ret = Array(); |
---|
574 | while($res = $result->fetchRow()) { |
---|
575 | $ret[] = $res['wf_user']; |
---|
576 | } |
---|
577 | return $ret; |
---|
578 | } |
---|
579 | |
---|
580 | /** |
---|
581 | * List instance owners available in the current database |
---|
582 | * |
---|
583 | * @return array Associative |
---|
584 | * @access public |
---|
585 | */ |
---|
586 | function monitor_list_owners() { |
---|
587 | $query = "select distinct(`wf_owner`) from `".GALAXIA_TABLE_PREFIX."instances`"; |
---|
588 | $result = $this->query($query); |
---|
589 | $ret = Array(); |
---|
590 | while($res = $result->fetchRow()) { |
---|
591 | $ret[] = $res['wf_owner']; |
---|
592 | } |
---|
593 | return $ret; |
---|
594 | } |
---|
595 | |
---|
596 | /** |
---|
597 | * List activity types available in the current database |
---|
598 | * |
---|
599 | * @return array Associative |
---|
600 | * @access public |
---|
601 | */ |
---|
602 | function monitor_list_activity_types() { |
---|
603 | $query = "select distinct(`wf_type`) from `".GALAXIA_TABLE_PREFIX."activities`"; |
---|
604 | $result = $this->query($query); |
---|
605 | $ret = Array(); |
---|
606 | while($res = $result->fetchRow()) { |
---|
607 | $ret[] = $res['wf_type']; |
---|
608 | } |
---|
609 | return $ret; |
---|
610 | } |
---|
611 | |
---|
612 | /** |
---|
613 | * Gets workitem information |
---|
614 | * |
---|
615 | * @param int $itemId Workitem id |
---|
616 | * @return array Associative |
---|
617 | * @access public |
---|
618 | */ |
---|
619 | function monitor_get_workitem($itemId) { |
---|
620 | $query = "select gw.`wf_order_id`,ga.`wf_name`,ga.`wf_type`,ga.`wf_is_interactive`,gp.`wf_name` as `wf_wf_procname`,gp.`wf_version`,"; |
---|
621 | $query.= "gw.`wf_item_id`,gw.`wf_properties`,gw.`wf_user`,`wf_started`,`wf_ended`-`wf_started` as wf_duration "; |
---|
622 | $query.= "from `".GALAXIA_TABLE_PREFIX."workitems` gw,`".GALAXIA_TABLE_PREFIX."activities` ga,`".GALAXIA_TABLE_PREFIX."processes` gp where ga.`wf_activity_id`=gw.`wf_activity_id` and ga.`wf_p_id`=gp.`wf_p_id` and `wf_item_id`=?"; |
---|
623 | $result = $this->query($query, array($itemId)); |
---|
624 | $res = $result->fetchRow(); |
---|
625 | $res['wf_properties'] = unserialize($res['wf_properties']); |
---|
626 | return $res; |
---|
627 | } |
---|
628 | |
---|
629 | /** |
---|
630 | * Gets workitems per instance |
---|
631 | * |
---|
632 | * @param int $offset First row number to return |
---|
633 | * @param int $maxRecords Maximum number of records to return |
---|
634 | * @param string $sort_mode Sort order |
---|
635 | * @param string $find Search for in instance name or instance description |
---|
636 | * @param string $where Ads to the query, be carefull with this string, read the query before |
---|
637 | * @param array $wherevars Set of vars used in where clause |
---|
638 | * @access public |
---|
639 | * @return array |
---|
640 | */ |
---|
641 | function monitor_list_workitems($offset,$maxRecords,$sort_mode,$find,$where='',$wherevars=array()) { |
---|
642 | $mid = ''; |
---|
643 | if ($where) { |
---|
644 | $mid.= " and ($where) "; |
---|
645 | } |
---|
646 | if($find) { |
---|
647 | $findesc = $this->qstr('%'.$find.'%'); |
---|
648 | $mid.=" and ((`wf_properties` like $findesc) or (gp.wf_name like $findesc) or (ga.wf_name like $findesc))"; |
---|
649 | } |
---|
650 | // TODO: retrieve instance status as well |
---|
651 | $query = 'select wf_item_id,wf_ended-wf_started as wf_duration,ga.wf_is_interactive, ga.wf_type,gp.wf_name as wf_procname,gp.wf_version,gp.wf_normalized_name as wf_proc_normalized_name,ga.wf_name as wf_act_name,'; |
---|
652 | $query.= 'ga.wf_activity_id,wf_instance_id,wf_order_id,wf_properties,wf_started,wf_ended,wf_user'; |
---|
653 | $query.= ' from '.GALAXIA_TABLE_PREFIX.'workitems gw,'.GALAXIA_TABLE_PREFIX.'activities ga,'.GALAXIA_TABLE_PREFIX.'processes gp'; |
---|
654 | $query.= ' where gw.wf_activity_id=ga.wf_activity_id and ga.wf_p_id=gp.wf_p_id '.$mid.' order by '.$this->convert_sortmode($sort_mode); |
---|
655 | $query_cant = "select count(*) from `".GALAXIA_TABLE_PREFIX."workitems` gw,`".GALAXIA_TABLE_PREFIX."activities` ga,`".GALAXIA_TABLE_PREFIX."processes` gp where gw.`wf_activity_id`=ga.`wf_activity_id` and ga.`wf_p_id`=gp.`wf_p_id` $mid"; |
---|
656 | $result = $this->query($query,$wherevars,$maxRecords,$offset); |
---|
657 | $cant = $this->getOne($query_cant,$wherevars); |
---|
658 | $ret = Array(); |
---|
659 | while($res = $result->fetchRow()) { |
---|
660 | $itemId = $res['wf_item_id']; |
---|
661 | $ret[$itemId] = $res; |
---|
662 | } |
---|
663 | $retval = Array(); |
---|
664 | $retval["data"] = $ret; |
---|
665 | $retval["cant"] = $cant; |
---|
666 | return $retval; |
---|
667 | } |
---|
668 | |
---|
669 | /** |
---|
670 | * Stats Instances per month |
---|
671 | * |
---|
672 | * @param integer $pid pid |
---|
673 | * @param integer $months number of months |
---|
674 | * @access public |
---|
675 | * @return array |
---|
676 | */ |
---|
677 | function stats_instances_per_month($pid, $months = 12) |
---|
678 | { |
---|
679 | list($year, $month) = explode('-', date('Y-m')); |
---|
680 | $output = array(); |
---|
681 | for ($i = $months - 1; $i >= 0; $i--) |
---|
682 | $output[date('Y-m', mktime(0, 0, 0, $month - $i, 1, $year))] = 0; |
---|
683 | $query = "SELECT wf_started FROM " . GALAXIA_TABLE_PREFIX . "instances WHERE (wf_started > ?) AND (wf_p_id = ?)"; |
---|
684 | $result = $this->query($query, array(mktime(0, 0, 0, $month - ($months - 1), 1, $year), $pid)); |
---|
685 | while($res = $result->fetchRow()) |
---|
686 | $output[date('Y-m', $res['wf_started'])]++; |
---|
687 | |
---|
688 | return $output; |
---|
689 | } |
---|
690 | |
---|
691 | /** |
---|
692 | * Stats activities instances |
---|
693 | * |
---|
694 | * @param integer $pid pid |
---|
695 | * @access public |
---|
696 | * @return array |
---|
697 | */ |
---|
698 | function stats_instances_activities($pid) |
---|
699 | { |
---|
700 | $output = array(); |
---|
701 | $query = "SELECT ga.wf_name, COUNT(*) AS count FROM " . GALAXIA_TABLE_PREFIX . "instance_activities gia, " . GALAXIA_TABLE_PREFIX . "activities ga WHERE (gia.wf_activity_id = ga.wf_activity_id) AND (ga.wf_p_id = ?) GROUP BY ga.wf_name ORDER BY ga.wf_name"; |
---|
702 | $result = $this->query($query, array($pid)); |
---|
703 | while($res = $result->fetchRow()) |
---|
704 | $output[] = $res; |
---|
705 | |
---|
706 | return $output; |
---|
707 | } |
---|
708 | |
---|
709 | /** |
---|
710 | * Stats instances per user |
---|
711 | * |
---|
712 | * @param integer $pid pid |
---|
713 | * @param integer $users |
---|
714 | * @access public |
---|
715 | * @return array |
---|
716 | */ |
---|
717 | function stats_instances_per_user($pid, $users = 10) |
---|
718 | { |
---|
719 | $output = array(); |
---|
720 | $query = "SELECT gia.wf_user, COUNT(*) AS count FROM egw_wf_instance_activities gia, egw_wf_activities ga WHERE (ga.wf_activity_id = gia.wf_activity_id) AND (gia.wf_user <> '*') AND (ga.wf_p_id = ?) GROUP BY gia.wf_user ORDER BY count DESC"; |
---|
721 | $result = $this->query($query, array($pid), $users); |
---|
722 | while($res = $result->fetchRow()) |
---|
723 | $output[$res['wf_user']] = $res['count']; |
---|
724 | |
---|
725 | return $output; |
---|
726 | } |
---|
727 | /** |
---|
728 | * Stats instances per status |
---|
729 | * |
---|
730 | * @param integer $pid pid |
---|
731 | * @access public |
---|
732 | * @return array |
---|
733 | */ |
---|
734 | function stats_instances_per_status($pid) |
---|
735 | { |
---|
736 | $output = array(); |
---|
737 | $query = "SELECT wf_status, COUNT(*) AS count FROM egw_wf_instances WHERE (wf_p_id = ?) AND (wf_status <> 'completed') GROUP BY wf_status"; |
---|
738 | $result = $this->query($query, array($pid)); |
---|
739 | while($res = $result->fetchRow()) |
---|
740 | $output[$res['wf_status']] = $res['count']; |
---|
741 | |
---|
742 | return $output; |
---|
743 | } |
---|
744 | } |
---|
745 | ?> |
---|