流程提交之后在代办中看不到

Blade 未结 1 225
spring8
spring8 剑童 2023-05-25 15:35

一、该问题的重现步骤是什么?

1. 表单新增之后提交之后在指定人下看不到代办


二、你期待的结果是什么?实际看到的又是什么?

期待看到代办

实际什么也没有


三、你正在使用的是什么产品,什么版本?在什么操作系统上?

baldex-boot 2.8.2 win10


四、请提供详细的错误堆栈信息,这很重要。

2023-05-25 15:27:37.799  INFO 17792 --- [  XNIO-1 task-6] o.s.common.filter.PreviewFilter          : 拦截所有请求,过滤所有参数 防止sql注入

2023-05-25 15:27:37.806  INFO 17792 --- [  XNIO-1 task-6] o.s.core.log.aspect.RequestLogAspect     : 


================  Request Start  ================

===> POST: /zdfw/meet/submitMeet Parameters: {"bladeUser":{"clientId":"saber","userId":1461641224560775170,"account":"wangxiao","userName":"wangxiao","nickName":"王潇","tenantId":"000000","oauthId":"","deptId":"1461641112602218497","postId":"-1","roleId":"1453660091373858818,1463777559941451777,1465496837287829505,1470590212127281153","roleName":"zhccz,director,data_manager,information_m","detail":{"type":"web"}},"id":1660838304225771522}

===Headers===  sec-fetch-mode: cors

===Headers===  referer: http://localhost:1888/meet/meet

===Headers===  content-length: 0

===Headers===  sec-fetch-site: same-origin

===Headers===  blade-auth: bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJ6aGNjeixkaXJlY3RvcixkYXRhX21hbmFnZXIsaW5mb3JtYXRpb25fbSIsInVzZXJfaWQiOiIxNDYxNjQxMjI0NTYwNzc1MTcwIiwicm9sZV9pZCI6IjE0NTM2NjAwOTEzNzM4NTg4MTgsMTQ2Mzc3NzU1OTk0MTQ1MTc3NywxNDY1NDk2ODM3Mjg3ODI5NTA1LDE0NzA1OTAyMTIxMjcyODExNTMiLCJ1c2VyX25hbWUiOiJ3YW5neGlhbyIsIm5pY2tfbmFtZSI6IueOi-a9hyIsImRldGFpbCI6eyJ0eXBlIjoid2ViIn0sInRva2VuX3R5cGUiOiJhY2Nlc3NfdG9rZW4iLCJkZXB0X2lkIjoiMTQ2MTY0MTExMjYwMjIxODQ5NyIsImFjY291bnQiOiJ3YW5neGlhbyIsImNsaWVudF9pZCI6InNhYmVyIiwiZXhwIjoxNjg1MDAxMjE5LCJuYmYiOjE2ODQ5OTc2MTl9.ln90V4vIewNNP0bbV8gSDmiW1kYXiwf4CDOLkNGYQDUVyQp5tEOk9nckaWcC6DDrku9hpRj_ECCXrItynRKU5Q

===Headers===  cookie: Webstorm-9181177d=9b7f4c42-85d0-4783-bf6e-94c8b434db8b; saber-access-token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJ6aGNjeixkaXJlY3RvcixkYXRhX21hbmFnZXIsaW5mb3JtYXRpb25fbSIsInVzZXJfaWQiOiIxNDYxNjQxMjI0NTYwNzc1MTcwIiwicm9sZV9pZCI6IjE0NTM2NjAwOTEzNzM4NTg4MTgsMTQ2Mzc3NzU1OTk0MTQ1MTc3NywxNDY1NDk2ODM3Mjg3ODI5NTA1LDE0NzA1OTAyMTIxMjcyODExNTMiLCJ1c2VyX25hbWUiOiJ3YW5neGlhbyIsIm5pY2tfbmFtZSI6IueOi-a9hyIsImRldGFpbCI6eyJ0eXBlIjoid2ViIn0sInRva2VuX3R5cGUiOiJhY2Nlc3NfdG9rZW4iLCJkZXB0X2lkIjoiMTQ2MTY0MTExMjYwMjIxODQ5NyIsImFjY291bnQiOiJ3YW5neGlhbyIsImNsaWVudF9pZCI6InNhYmVyIiwiZXhwIjoxNjg1MDAxMjE5LCJuYmYiOjE2ODQ5OTc2MTl9.ln90V4vIewNNP0bbV8gSDmiW1kYXiwf4CDOLkNGYQDUVyQp5tEOk9nckaWcC6DDrku9hpRj_ECCXrItynRKU5Q; saber-refresh-token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ1c2VyX2lkIjoiMTQ2MTY0MTIyNDU2MDc3NTE3MCIsInJvbGVfaWQiOiIxNDUzNjYwMDkxMzczODU4ODE4LDE0NjM3Nzc1NTk5NDE0NTE3NzcsMTQ2NTQ5NjgzNzI4NzgyOTUwNSwxNDcwNTkwMjEyMTI3MjgxMTUzIiwidG9rZW5fdHlwZSI6InJlZnJlc2hfdG9rZW4iLCJkZXB0X2lkIjoiMTQ2MTY0MTExMjYwMjIxODQ5NyIsImNsaWVudF9pZCI6InNhYmVyIiwiZXhwIjoxNjg1NjAyNDE5LCJuYmYiOjE2ODQ5OTc2MTl9.lV78LPxbr3YlZaGyFbxKt3S8gsKdVyZ_yT5Nj9Slu-z4PCZb_DIrJRbabHVCqVQhgMGIUeOAjkQILSst9LWlBQ

===Headers===  accept-language: zh-CN,zh;q=0.9,zh-TW;q=0.8,en;q=0.7

===Headers===  x-forwarded-proto: http

===Headers===  origin: http://localhost:1888

===Headers===  x-forwarded-port: 1888

===Headers===  x-forwarded-for: 127.0.0.1

===Headers===  accept: application/json, text/plain, */*

===Headers===  authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers===  sec-ch-ua: "Chromium";v="92", " Not A;Brand";v="99", "Google Chrome";v="92"

===Headers===  sec-ch-ua-mobile: ?0

===Headers===  x-forwarded-host: localhost:1888

===Headers===  host: localhost

===Headers===  connection: close

===Headers===  accept-encoding: gzip, deflate, br

===Headers===  user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36

===Headers===  sec-fetch-dest: empty

================   Request End   ================


2023-05-25 15:27:37.810  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select RES.* from ACT_RE_PROCDEF RES where RES.KEY_ = 'meetRecevie' and RES.VERSION_ = ( select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = RES.KEY_ and ((TENANT_ID_ is not null and TENANT_ID_ = RES.TENANT_ID_) or (TENANT_ID_ is null and RES.TENANT_ID_ is null)) ) order by RES.KEY_ asc limit 0, 100

Execute Time: 1.717ms

==============  Sql  End   ==============


2023-05-25 15:27:37.815  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select RES.* from ACT_RE_DEPLOYMENT RES where RES.ID_ = 'b8b92d64-fac8-11ed-8edf-00ff35f6a0d0' order by RES.ID_ asc

Execute Time: 0.870ms

==============  Sql  End   ==============


2023-05-25 15:27:37.821  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, status, company_phone, room, shakedown_time , convene_time, name, type, password, notes , state, create_user, create_dept, create_time, update_user , update_time, is_deleted, flow_instance_id from zd_meet where id = 1660838304225771522

Execute Time: 0.600ms

==============  Sql  End   ==============


2023-05-25 15:27:37.824  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, status, company_phone, room, shakedown_time , convene_time, name, type, password, notes , state, create_user, create_dept, create_time, update_user , update_time, is_deleted, flow_instance_id from zd_meet where id = 1660838304225771522

Execute Time: 0.780ms

==============  Sql  End   ==============


2023-05-25 15:27:37.830  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, MDMZGZD_NM, MDMZGZD_ZGBH, MDMZGZD_ZGXM, MDMZGZD_ZGXB , MDMZGZD_CSRQ, MDMZGZD_GJ, MDMZGZD_ZGMZ, MDMZGZD_ZJLX, MDMZGZD_SFZH , USERPREDEF_2, MDMZGZD_GWRQ, MDMZGZD_ZGLB, MDMZGZD_ZH, MDMZGZD_MOBILE , MDMZGZD_EMAIL, MDMZGZD_HRDWNM, MDMZGZD_HRBMNM, MDMZGZD_YIJBM, MDMZGZD_DWNM , MDMZGZD_BMNM, MDMZGZD_TYBZ, createuser, createtime, Lastmodifieduser , Lastmodifiedtime, Mdmzgzd_gwmc, MDMZGZD_STATE, USERPREDEF_3, USERPREDEF_4 , USERPREDEF_5, sync_time, USERPREDEF_6, MDMZGZD_TEL from zd_mdmzgzd where id = '1461641224560775170'

Execute Time: 1.536ms

==============  Sql  End   ==============


2023-05-25 15:27:37.839  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from blade_user where account = 'wangxiao'

Execute Time: 2.798ms

==============  Sql  End   ==============


2023-05-25 15:27:37.849  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select count(*) from zd_mdmorginfo where NM = '79298'

Execute Time: 0.967ms

==============  Sql  End   ==============


2023-05-25 15:27:37.852  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, NM, Orderno, ORGCODE, OrgName , Dimensiontype, MDMBZDW_GSXZ, MDMBZDW_GSLB, OrgType, FJM , JS, MX, validdate, SetDate, OrgUnitNM , createuser, createtime, lastmodifieduser, lastmodifiedtime, PNodeCode , PNodeID, isHistory, sync_time from zd_mdmorginfo where NM = '79298' limit 1

Execute Time: 0.833ms

==============  Sql  End   ==============


2023-05-25 15:27:37.860  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, role_name, sort , role_alias, is_deleted from blade_role where is_deleted = 0 and (role_alias in ('flow_apply_role') and is_deleted = '0')

Execute Time: 0.750ms

==============  Sql  End   ==============


2023-05-25 15:27:37.873  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from blade_user where is_deleted = 0 and id in ( select user_id from blade_user_dept where dept_id in ( select id from blade_dept where (ancestors like concat('%', 1461641092461170690, '%') or id = 1461641092461170690) and is_deleted = 0 ) ) and role_id like concat('%', 1465978981869146113, '%')

Execute Time: 6.402ms

==============  Sql  End   ==============


2023-05-25 15:27:37.878  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, full_name, dept_name , ancestors, dept_category, sort, remark, is_deleted from blade_dept where id = '1461641112602218497' and is_deleted = 0

Execute Time: 0.570ms

==============  Sql  End   ==============


2023-05-25 15:27:37.882  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, full_name, dept_name , ancestors, dept_category, sort, remark, is_deleted from blade_dept where id = '1461641112602218497' and is_deleted = 0

Execute Time: 0.534ms

==============  Sql  End   ==============


2023-05-25 15:27:37.886  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, full_name, dept_name , ancestors, dept_category, sort, remark, is_deleted from blade_dept where id = 1461641092461170690 and is_deleted = 0

Execute Time: 0.677ms

==============  Sql  End   ==============


2023-05-25 15:27:37.889  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, full_name, dept_name , ancestors, dept_category, sort, remark, is_deleted from blade_dept where id = 1461641091035107330 and is_deleted = 0

Execute Time: 0.479ms

==============  Sql  End   ==============


2023-05-25 15:27:37.894  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, full_name, dept_name , ancestors, dept_category, sort, remark, is_deleted from blade_dept where id = 0 and is_deleted = 0

Execute Time: 1.234ms

==============  Sql  End   ==============


2023-05-25 15:27:37.898  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, code, user_type, account, password , name, real_name, avatar, email, phone , birthday, sex, role_id, dept_id, post_id , room_number, company_phone, second, tenant_id, create_user , create_dept, create_time, update_user, update_time, status , is_deleted from blade_user where id = '1461641224560775170' and is_deleted = 0

Execute Time: 0.669ms

==============  Sql  End   ==============


2023-05-25 15:27:43.966  WARN 17792 --- [uire-timer-jobs] c.a.druid.pool.DruidAbstractDataSource   : discard long time none received connection. , jdbcUrl : jdbc:mysql://127.0.0.1:3306/zz_yw?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.5, lastPacketReceivedIdleMillis : 196241

2023-05-25 15:27:43.970  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, flow_template_key, flag_id, flag_name, is_deleted , create_user, create_dept, create_time, update_user, update_time from zd_flow_step_flag where flow_template_key = 'meetRecevie' and is_deleted = 0

Execute Time: 0.868ms

==============  Sql  End   ==============


2023-05-25 15:27:43.970  WARN 17792 --- [uire-timer-jobs] c.a.druid.pool.DruidAbstractDataSource   : discard long time none received connection. , jdbcUrl : jdbc:mysql://127.0.0.1:3306/zz_yw?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.5, lastPacketReceivedIdleMillis : 1583298

2023-05-25 15:27:43.975  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, flag_name, role_id, role_alias, pub_field , data_type, remark, is_deleted, create_user, create_dept , create_time, update_user, update_time from zd_flow_flag where id = 12131451001

Execute Time: 1.037ms

==============  Sql  End   ==============


2023-05-25 15:27:43.982  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, MDMZGZD_NM, MDMZGZD_ZGBH, MDMZGZD_ZGXM, MDMZGZD_ZGXB , MDMZGZD_CSRQ, MDMZGZD_GJ, MDMZGZD_ZGMZ, MDMZGZD_ZJLX, MDMZGZD_SFZH , USERPREDEF_2, MDMZGZD_GWRQ, MDMZGZD_ZGLB, MDMZGZD_ZH, MDMZGZD_MOBILE , MDMZGZD_EMAIL, MDMZGZD_HRDWNM, MDMZGZD_HRBMNM, MDMZGZD_YIJBM, MDMZGZD_DWNM , MDMZGZD_BMNM, MDMZGZD_TYBZ, createuser, createtime, Lastmodifieduser , Lastmodifiedtime, Mdmzgzd_gwmc, MDMZGZD_STATE, USERPREDEF_3, USERPREDEF_4 , USERPREDEF_5, sync_time, USERPREDEF_6, MDMZGZD_TEL from zd_mdmzgzd where id = 1461641224560775170

Execute Time: 1.267ms

==============  Sql  End   ==============


2023-05-25 15:27:43.991  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from blade_user where account = 'wangxiao'

Execute Time: 6.015ms

==============  Sql  End   ==============


2023-05-25 15:27:43.998  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select count(*) from zd_mdmorginfo where NM = '79298'

Execute Time: 0.782ms

==============  Sql  End   ==============


2023-05-25 15:27:44.001  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, NM, Orderno, ORGCODE, OrgName , Dimensiontype, MDMBZDW_GSXZ, MDMBZDW_GSLB, OrgType, FJM , JS, MX, validdate, SetDate, OrgUnitNM , createuser, createtime, lastmodifieduser, lastmodifiedtime, PNodeCode , PNodeID, isHistory, sync_time from zd_mdmorginfo where NM = '79298' limit 1

Execute Time: 0.646ms

==============  Sql  End   ==============


2023-05-25 15:27:44.008  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, role_name, sort , role_alias, is_deleted from blade_role where is_deleted = 0 and (role_alias in ('dept_manager', 'Deputy') and is_deleted = '0')

Execute Time: 0.961ms

==============  Sql  End   ==============


2023-05-25 15:27:44.017  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, dept_id, user_id, role_id, is_deleted , create_user, create_dept, create_time, update_user, update_time from zd_dept_user_role where dept_id = 1461641092461170690 and role_id = 1461499780069777410 and is_deleted = 0 order by create_time desc

Execute Time: 1.113ms

==============  Sql  End   ==============


2023-05-25 15:27:44.023  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, code, user_type, account, password , name, real_name, avatar, email, phone , birthday, sex, role_id, dept_id, post_id , room_number, company_phone, second, tenant_id, create_user , create_dept, create_time, update_user, update_time, status , is_deleted from blade_user where is_deleted = 0 and (id = 1461641188414263298 and is_deleted = 0)

Execute Time: 0.762ms

==============  Sql  End   ==============


2023-05-25 15:27:44.038  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from blade_user where is_deleted = 0 and id in ( select user_id from blade_user_dept where dept_id in ( select id from blade_dept where (ancestors like concat('%', 1461641092461170690, '%') or id = 1461641092461170690) and is_deleted = 0 ) ) and role_id like concat('%', 1461499780069777410, '%')

Execute Time: 7.744ms

==============  Sql  End   ==============


2023-05-25 15:27:44.046  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, dept_id, user_id, role_id, is_deleted , create_user, create_dept, create_time, update_user, update_time from zd_dept_user_role where dept_id = 1461641092461170690 and role_id = 1465847832668762113 and is_deleted = 0 order by create_time desc

Execute Time: 0.659ms

==============  Sql  End   ==============


2023-05-25 15:27:44.059  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from blade_user where is_deleted = 0 and id in ( select user_id from blade_user_dept where dept_id in ( select id from blade_dept where (ancestors like concat('%', 1461641092461170690, '%') or id = 1461641092461170690) and is_deleted = 0 ) ) and role_id like concat('%', 1465847832668762113, '%')

Execute Time: 8.291ms

==============  Sql  End   ==============


2023-05-25 15:27:44.068  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, role_name, sort , role_alias, is_deleted from blade_role where is_deleted = 0 and (role_alias in ('flow_apply_role') and is_deleted = '0')

Execute Time: 0.702ms

==============  Sql  End   ==============


2023-05-25 15:27:44.073  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, flag_name, role_id, role_alias, pub_field , data_type, remark, is_deleted, create_user, create_dept , create_time, update_user, update_time from zd_flow_flag where id = 12131451002

Execute Time: 1.591ms

==============  Sql  End   ==============


2023-05-25 15:27:44.080  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, role_name, sort , role_alias, is_deleted from blade_role where is_deleted = 0 and (role_alias in ('info_manager') and is_deleted = '0')

Execute Time: 0.698ms

==============  Sql  End   ==============


2023-05-25 15:27:44.092  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, code, user_type, account, password , name, real_name, avatar, email, phone , birthday, sex, role_id, dept_id, post_id , room_number, company_phone, second, tenant_id, create_user , create_dept, create_time, update_user, update_time, status , is_deleted from blade_user where is_deleted = 0 and role_id like '%1461499721865420802%' order by update_time desc

Execute Time: 4.048ms

==============  Sql  End   ==============


2023-05-25 15:27:44.099  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select id, tenant_id, parent_id, role_name, sort , role_alias, is_deleted from blade_role where is_deleted = 0 and (role_alias in ('flow_apply_role') and is_deleted = '0')

Execute Time: 0.743ms

==============  Sql  End   ==============


2023-05-25 15:27:44.102  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : select * from ACT_RE_PROCDEF where ID_ = 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0'

Execute Time: 1.060ms

==============  Sql  End   ==============


2023-05-25 15:27:44.127  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_ , REV_, VAR_TYPE_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_ , BYTEARRAY_ID_, DOUBLE_, LONG_, TEXT_, TEXT2_ , CREATE_TIME_, LAST_UPDATED_TIME_) values ('a3c2901e-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'createUser' , 0, 'string', null, null, null , null, null, null, 'wangxiao', null , TIMESTAMP '2023-05-25 15:27:44.103', TIMESTAMP '2023-05-25 15:27:44.103'), ('a3c2901f-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'taskUser' , 0, 'string', null, null, null , null, null, null, 'taskUser_1461641224560775170', null , TIMESTAMP '2023-05-25 15:27:44.103', TIMESTAMP '2023-05-25 15:27:44.103'), ('a3c2b731-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'dept_manager' , 0, 'serializable', null, null, null , 'a3c2b732-facd-11ed-afea-00ff35f6a0d0', null, null, null, null , TIMESTAMP '2023-05-25 15:27:44.104', TIMESTAMP '2023-05-25 15:27:44.104'), ('a3c2b734-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'info_manager' , 0, 'serializable', null, null, null , 'a3c2b735-facd-11ed-afea-00ff35f6a0d0', null, null, null, null , TIMESTAMP '2023-05-25 15:27:44.104', TIMESTAMP '2023-05-25 15:27:44.104')

Execute Time: 3.112ms

==============  Sql  End   ==============


2023-05-25 15:27:44.131  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_TASKINST (ID_, REV_, TASK_DEF_ID_, PROC_DEF_ID_, PROC_INST_ID_ , EXECUTION_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_ , NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_ , START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_ , TENANT_ID_, LAST_UPDATED_TIME_) values ('a3c37a8a-facd-11ed-afea-00ff35f6a0d0', 1, null, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0' , 'a3c2b736-facd-11ed-afea-00ff35f6a0d0', null, null, null, null , '部门负责人审批', null, null, null, '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]' , TIMESTAMP '2023-05-25 15:27:44.109', null, null, null, null , 'dept_manager', null, 50, null, null , '', TIMESTAMP '2023-05-25 15:27:44.110')

Execute Time: 1.928ms

==============  Sql  End   ==============


2023-05-25 15:27:44.134  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_PROCINST (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_ , START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_ , END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_, DELETE_REASON_, TENANT_ID_, NAME_ , CALLBACK_ID_, CALLBACK_TYPE_) values ('a3c2901c-facd-11ed-afea-00ff35f6a0d0', 1, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'zd_meet:1660838304225771522', 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0' , TIMESTAMP '2023-05-25 15:27:44.103', null, null, 'taskUser_1461641224560775170', 'startEvent1' , null, null, null, '', null , null, null)

Execute Time: 1.274ms

==============  Sql  End   ==============


2023-05-25 15:27:44.137  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c2de47-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'startEvent1', null, null, null, 'startEvent' , null, TIMESTAMP '2023-05-25 15:27:44.105', TIMESTAMP '2023-05-25 15:27:44.107', 2, null , '')

Execute Time: 1.595ms

==============  Sql  End   ==============


2023-05-25 15:27:44.139  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c35378-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'sid-6730BFD3-7161-418D-8606-5E64CEBE6445', null, null, null, 'sequenceFlow' , null, TIMESTAMP '2023-05-25 15:27:44.108', TIMESTAMP '2023-05-25 15:27:44.108', 0, null , '')

Execute Time: 1.051ms

==============  Sql  End   ==============


2023-05-25 15:27:44.141  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c37a89-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'dept_manager', 'a3c37a8a-facd-11ed-afea-00ff35f6a0d0', null, '部门负责人审批', 'userTask' , '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', TIMESTAMP '2023-05-25 15:27:44.109', null, null, null , '')

Execute Time: 1.046ms

==============  Sql  End   ==============


2023-05-25 15:27:44.195  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_ , PROC_INST_ID_, SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_, CREATE_TIME_) values ('a3c2901d-facd-11ed-afea-00ff35f6a0d0', 'starter', 'taskUser_1461641224560775170', null, null , 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, null, null, TIMESTAMP '2023-05-25 15:27:44.103'), ('a3c3a19b-facd-11ed-afea-00ff35f6a0d0', 'assignee', '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', null, 'a3c37a8a-facd-11ed-afea-00ff35f6a0d0' , null, null, null, null, TIMESTAMP '2023-05-25 15:27:44.110'), ('a3c3a19c-facd-11ed-afea-00ff35f6a0d0', 'participant', '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', null, null , 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, null, null, TIMESTAMP '2023-05-25 15:27:44.111')

Execute Time: 51.145ms

==============  Sql  End   ==============


2023-05-25 15:27:44.199  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_ , ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_, IS_EVENT_SCOPE_ , IS_MI_ROOT_, PARENT_ID_, SUPER_EXEC_, ROOT_PROC_INST_ID_, SUSPENSION_STATE_ , TENANT_ID_, NAME_, START_ACT_ID_, START_TIME_, START_USER_ID_ , IS_COUNT_ENABLED_, EVT_SUBSCR_COUNT_, TASK_COUNT_, JOB_COUNT_, TIMER_JOB_COUNT_ , SUSP_JOB_COUNT_, DEADLETTER_JOB_COUNT_, VAR_COUNT_, ID_LINK_COUNT_, CALLBACK_ID_ , CALLBACK_TYPE_) values ('a3c2901c-facd-11ed-afea-00ff35f6a0d0', 1, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'zd_meet:1660838304225771522', 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0' , null, true, false, true, false , false, null, null, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 1 , '', null, 'startEvent1', TIMESTAMP '2023-05-25 15:27:44.103', 'taskUser_1461641224560775170' , true, 0, 0, 0, 0 , 0, 0, 0, 0, null , null)

Execute Time: 1.768ms

==============  Sql  End   ==============


2023-05-25 15:27:44.202  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_ , ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_, IS_EVENT_SCOPE_ , IS_MI_ROOT_, PARENT_ID_, SUPER_EXEC_, ROOT_PROC_INST_ID_, SUSPENSION_STATE_ , TENANT_ID_, NAME_, START_ACT_ID_, START_TIME_, START_USER_ID_ , IS_COUNT_ENABLED_, EVT_SUBSCR_COUNT_, TASK_COUNT_, JOB_COUNT_, TIMER_JOB_COUNT_ , SUSP_JOB_COUNT_, DEADLETTER_JOB_COUNT_, VAR_COUNT_, ID_LINK_COUNT_, CALLBACK_ID_ , CALLBACK_TYPE_) values ('a3c2b736-facd-11ed-afea-00ff35f6a0d0', 1, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0' , 'dept_manager', true, false, false, false , false, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 1 , '', null, null, TIMESTAMP '2023-05-25 15:27:44.104', null , true, 0, 1, 0, 0 , 0, 0, 0, 0, null , null)

Execute Time: 1.618ms

==============  Sql  End   ==============


2023-05-25 15:27:44.205  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c2de47-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'startEvent1', null, null, null, 'startEvent' , null, TIMESTAMP '2023-05-25 15:27:44.105', TIMESTAMP '2023-05-25 15:27:44.107', 2, null , '')

Execute Time: 1.797ms

==============  Sql  End   ==============


2023-05-25 15:27:44.208  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c35378-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'sid-6730BFD3-7161-418D-8606-5E64CEBE6445', null, null, null, 'sequenceFlow' , null, TIMESTAMP '2023-05-25 15:27:44.108', TIMESTAMP '2023-05-25 15:27:44.108', 0, null , '')

Execute Time: 1.003ms

==============  Sql  End   ==============


2023-05-25 15:27:44.210  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_ACTINST (ID_, REV_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_ , ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_ , ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_ , TENANT_ID_) values ('a3c37a89-facd-11ed-afea-00ff35f6a0d0', 1, 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'a3c2b736-facd-11ed-afea-00ff35f6a0d0' , 'dept_manager', 'a3c37a8a-facd-11ed-afea-00ff35f6a0d0', null, '部门负责人审批', 'userTask' , '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', TIMESTAMP '2023-05-25 15:27:44.109', null, null, null , '')

Execute Time: 0.944ms

==============  Sql  End   ==============


2023-05-25 15:27:44.213  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_ , PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_ , EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_ID_, SCOPE_ID_ , SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_, TASK_DEF_KEY_, DUE_DATE_ , CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_, CLAIM_TIME_ , IS_COUNT_ENABLED_, VAR_COUNT_, ID_LINK_COUNT_, SUB_TASK_COUNT_) values ('a3c37a8a-facd-11ed-afea-00ff35f6a0d0', 1, '部门负责人审批', null, null , 50, TIMESTAMP '2023-05-25 15:27:44.109', null, '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', null , 'a3c2b736-facd-11ed-afea-00ff35f6a0d0', 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', 'meetRecevie:1:b92dc127-fac8-11ed-8edf-00ff35f6a0d0', null, null , null, null, null, 'dept_manager', null , null, 1, '', null, null , true, 0, 0, 0)

Execute Time: 1.470ms

==============  Sql  End   ==============


2023-05-25 15:27:44.216  INFO 17792 --- [  XNIO-1 task-6] o.s.core.mp.plugins.SqlLogInterceptor    : 


==============  Sql Start  ==============

Execute SQL : insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_ , TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_, SCOPE_ID_, SCOPE_TYPE_ , SCOPE_DEFINITION_ID_) values ('a3c2901d-facd-11ed-afea-00ff35f6a0d0', 1, 'starter', 'taskUser_1461641224560775170', null , null, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, null, null , null), ('a3c3a19c-facd-11ed-afea-00ff35f6a0d0', 1, 'participant', '[taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]', null , null, 'a3c2901c-facd-11ed-afea-00ff35f6a0d0', null, null, null , null)

Execute Time: 1.788ms

============== 

1条回答
  • 2023-05-25 15:42

    流程图

    image.png


    为什么入库的时候是这样的形式?

    [taskUser_1461641188414263298, taskUser_1461641229015126018, taskUser_1461641233280733186]'


    0 讨论(0)
提交回复