BCDL 流程表应用

select * from cmcs3_process_user_group;
select * from cmcs3_process p where p.processid = 1001;

select * from cmcs3_process_task_user u where u.usergroupid = 1020;
select * from cmcs3_process_task ;

select u.actors,ug.id from cmcs3_process p,cmcs3_process_user_group ug,cmcs3_process_task_user u,cmcs3_process_task t
where p.processid = ug.processid and ug.id = u.usergroupid and u.processtaskid = t.processtaskid
and t.taskname = '复核' and p.uniquecode = 'ExternalPayments' and ug.id = ?;

commit;
select * from cmcs3_process_instance_info

select * from jbpm_pooledactor
select * from jbpm_taskinstance
select * from jbpm_moduleinstance

--先通过流程id 找到对应的TaskInstance表，然后关联到 cmcs3_process_task，然后再通过processid关联cmcs3_process_user_group表
--这样就通过流程ID找到流程组了

--ProcessInstanceInfo id 是在JbpmProcessDaoImpl  startProcess方法中 processInfor.setProcessInstanceId(id);
--同时又将 transferBill.setProcessInstanceID(processInstanceID)，所以这两张表可以通过这个字段管理

 

 

=====角色表=====

select * from cmcs3_user u
where u.username = 'lhj2';

select ru.roleid from cmcs3_role_user ru
where ru.userid = 1580;

select * from cmcs3_role r
where r.roleid in (1000 ,1001 ,1003);

select * from cmcs3_role_history rh
where rh.roleid in (1000 ,1001 ,1003);

 

--JBPM相关表

select * from CMCS3_PROCESS_TASK;

select * from jbpm_TASK;

select * from CMCS3_PROCESS_USER_GROUP;

select * from CMCS3_PROCESS_TASK_USER;