具体过程参考:
worker—super—manager三个用户 依次 提交表单后,APPLICATION表 内容的变化
MariaDB [wf_workflow]> select * from APPLICATION;
| APP_UID | APP_NUMBER | APP_PARENT | APP_STATUS | PRO_UID | APP_PROC_STATUS | APP_PROC_CODE | APP_PARALLEL | APP_INIT_USER | APP_CUR_USER | APP_CREATE_DATE | APP_INIT_DATE | APP_FINISH_DATE | APP_UPDATE_DATE | APP_DATA | APP_PIN | APP_DURATION | APP_DELAY_DURATION |
+++++++++++++++++++++++++++++++++++++ worker send form
| 93475636556555453e9b002098496690 | 3 | | TO_DO | 213429322565435601bc989031784482 | | | N | 91874122656547a1fb68927096584688 | 91874122656547a1fb68927096584688 | 2015-11-25 01:25:23 | 2015-11-25 01:25:23 | NULL | 2015-11-25 01:26:40 | a:20:{s:8:"SYS_LANG";s:2:"en";s:8:"SYS_SKIN";s:10:"neoclassic";s:7:"SYS_SYS";s:8:"workflow";s:11:"APPLICATION";s:32:"93475636556555453e9b002098496690";s:7:"PROCESS";s:32:"213429322565435601bc989031784482";s:4:"TASK";s:32:"970776078565436c90f7146052215225";s:5:"INDEX";s:1:"1";s:11:"USER_LOGGED";s:32:"91874122656547a1fb68927096584688";s:12:"USR_USERNAME";s:6:"worker";s:12:"employeeName";s:14:"zhangtongguang";s:18:"employeeName_label";s:14:"zhangtongguang";s:15:"employeeAddress";s:12:"gggggggggggg";s:21:"employeeAddress_label";s:12:"gggggggggggg";s:13:"employeeEmail";s:11:"ztg@163.com";s:19:"employeeEmail_label";s:11:"ztg@163.com";s:17:"requestDate_label";s:10:"2015-11-25";s:11:"requestDate";s:19:"2015-11-25 14:26:11";s:8:"itemGrid";a:1:{i:1;a:6:{s:14:"text0000000001";s:12:"aaaaaaaaaaaa";s:20:"text0000000001_label";s:12:"aaaaaaaaaaaa";s:14:"text0000000002";s:12:"11111111aaaa";s:20:"text0000000002_label";s:12:"11111111aaaa";s:14:"text0000000003";s:15:"bbbbbbbbbbbbbbb";s:20:"text0000000003_label";s:15:"bbbbbbbbbbbbbbb";}}s:16:"submit0000000001";s:0:"";s:3:"PIN";s:4:"YZ89";} | bbdd5e673e53b3c48209305d6023bd7e | 0 | 0 |
+++++++++++++++++++++++++++++++++++++ super send form
| 93475636556555453e9b002098496690 | 3 | | TO_DO | 213429322565435601bc989031784482 | | | N | 91874122656547a1fb68927096584688 | 91874122656547a1fb68927096584688 | 2015-11-25 01:25:23 | 2015-11-25 01:25:23 | NULL | 2015-11-25 01:28:59 | a:23:{s:8:"SYS_LANG";s:2:"en";s:8:"SYS_SKIN";s:10:"neoclassic";s:7:"SYS_SYS";s:8:"workflow";s:11:"APPLICATION";s:32:"93475636556555453e9b002098496690";s:7:"PROCESS";s:32:"213429322565435601bc989031784482";s:4:"TASK";s:32:"818490047565436f11b1645015163379";s:5:"INDEX";s:1:"2";s:11:"USER_LOGGED";s:32:"91734245156547a42b18193086945222";s:12:"USR_USERNAME";s:5:"super";s:12:"employeeName";s:14:"zhangtongguang";s:18:"employeeName_label";s:14:"zhangtongguang";s:15:"employeeAddress";s:12:"gggggggggggg";s:21:"employeeAddress_label";s:12:"gggggggggggg";s:13:"employeeEmail";s:11:"ztg@163.com";s:19:"employeeEmail_label";s:11:"ztg@163.com";s:11:"requestDate";s:19:"2015-11-25 14:26:11";s:17:"requestDate_label";s:10:"2015-11-25";s:10:"itemGrid_1";a:1:{i:1;a:6:{s:14:"text0000000001";s:12:"aaaaaaaaaaaa";s:20:"text0000000001_label";s:12:"aaaaaaaaaaaa";s:14:"text0000000002";s:12:"11111111aaaa";s:20:"text0000000002_label";s:12:"11111111aaaa";s:14:"text0000000003";s:15:"bbbbbbbbbbbbbbb";s:20:"text0000000003_label";s:15:"bbbbbbbbbbbbbbb";}}s:15:"requestApproved";s:1:"1";s:21:"requestApproved_label";s:3:"Yes";s:16:"submit0000000001";s:0:"";s:8:"itemGrid";a:1:{i:1;a:6:{s:14:"text0000000001";s:12:"aaaaaaaaaaaa";s:20:"text0000000001_label";s:12:"aaaaaaaaaaaa";s:14:"text0000000002";s:12:"11111111aaaa";s:20:"text0000000002_label";s:12:"11111111aaaa";s:14:"text0000000003";s:15:"bbbbbbbbbbbbbbb";s:20:"text0000000003_label";s:15:"bbbbbbbbbbbbbbb";}}s:3:"PIN";s:4:"YZ89";} | bbdd5e673e53b3c48209305d6023bd7e | 0 | 0 |
+++++++++++++++++++++++++++++++++++++ manager send form
| 93475636556555453e9b002098496690 | 3 | | COMPLETED | 213429322565435601bc989031784482 | | | N | 91874122656547a1fb68927096584688 | 91874122656547a1fb68927096584688 | 2015-11-25 01:25:23 | 2015-11-25 01:25:23 | 2015-11-25 01:31:36 | 2015-11-25 01:31:37 | a:23:{s:8:"SYS_LANG";s:2:"en";s:8:"SYS_SKIN";s:10:"neoclassic";s:7:"SYS_SYS";s:8:"workflow";s:11:"APPLICATION";s:32:"93475636556555453e9b002098496690";s:7:"PROCESS";s:32:"213429322565435601bc989031784482";s:4:"TASK";s:32:"870766574565455b93dd4a3008017615";s:5:"INDEX";s:1:"3";s:11:"USER_LOGGED";s:32:"88587693856547a5daece88057576561";s:12:"USR_USERNAME";s:7:"manager";s:12:"employeeName";s:14:"zhangtongguang";s:18:"employeeName_label";s:14:"zhangtongguang";s:15:"employeeAddress";s:12:"gggggggggggg";s:21:"employeeAddress_label";s:12:"gggggggggggg";s:13:"employeeEmail";s:11:"ztg@163.com";s:19:"employeeEmail_label";s:11:"ztg@163.com";s:11:"requestDate";s:19:"2015-11-25 14:26:11";s:17:"requestDate_label";s:10:"2015-11-25";s:8:"itemGrid";a:1:{i:1;a:6:{s:14:"text0000000001";s:12:"aaaaaaaaaaaa";s:20:"text0000000001_label";s:12:"aaaaaaaaaaaa";s:14:"text0000000002";s:12:"11111111aaaa";s:20:"text0000000002_label";s:12:"11111111aaaa";s:14:"text0000000003";s:15:"bbbbbbbbbbbbbbb";s:20:"text0000000003_label";s:15:"bbbbbbbbbbbbbbb";}}s:15:"requestApproved";s:1:"1";s:21:"requestApproved_label";s:3:"Yes";s:16:"submit0000000001";s:0:"";s:10:"itemGrid_1";a:1:{i:1;a:6:{s:14:"text0000000001";s:12:"aaaaaaaaaaaa";s:20:"text0000000001_label";s:12:"aaaaaaaaaaaa";s:14:"text0000000002";s:12:"11111111aaaa";s:20:"text0000000002_label";s:12:"11111111aaaa";s:14:"text0000000003";s:15:"bbbbbbbbbbbbbbb";s:20:"text0000000003_label";s:15:"bbbbbbbbbbbbbbb";}}s:3:"PIN";s:4:"YZ89";} | bbdd5e673e53b3c48209305d6023bd7e | 0 | 0 |
阅读(1681) | 评论(0) | 转发(0) |