activiti6-视图

1. 待办视图

SELECT A.ID_ AS TASK_ID,

       A.PROC_INST_ID_ PROC_INST_ID,

       A.TASK_DEF_KEY_ AS ACT_ID,

       A.NAME_ AS ACT_NAME,

       A.ASSIGNEE_ AS ASSIGNEE,

       A.DELEGATION_ AS DELEGATION_ID,

       A.DESCRIPTION_ AS DESCRIPTION,

A.CREATE_TIME_ AS CREATE_TIME,

A.DUE_DATE_ AS DUE_DATE,

       I.USER_ID AS CANDIDATE 

  FROM ACT_RU_TASK A

  LEFT JOIN (SELECT DISTINCT * FROM 

(SELECT I.TASK_ID_, I.USER_ID_ AS USER_ID

                    FROM ACT_RU_IDENTITYLINK I, ACT_RU_TASK T

                      WHERE TASK_ID_ IS NOT NULL

                        AND USER_ID_ IS NOT NULL

                        AND I.TASK_ID_ = T.ID_

                        AND T.ASSIGNEE_ IS NULL

                        AND TYPE_ = 'candidate'

                     UNION

                     SELECT TASK_ID_, R.USER_ID_ AS USER_ID

                       FROM ACT_RU_IDENTITYLINK I,act_id_membership R,ACT_RU_TASK T

                      WHERE I.TASK_ID_ IS NOT NULL

                        AND I.GROUP_ID_ IS NOT NULL

                        AND I.TASK_ID_ = T.ID_

                        AND T.ASSIGNEE_ IS NULL

                        AND I.TYPE_ = 'candidate'

                        AND I.GROUP_ID_ = R.GROUP_ID_)U) I

    ON A.ID_ = I.TASK_ID_

2.发起

SELECT
	`ins`.`ID_` AS `instanceId`,
	`ins`.`BUSINESS_KEY_` AS `businessKey`,
	`ins`.`START_TIME_` AS `startTime`,
	`ins`.`END_TIME_` AS `endTime`,
	`ins`.`START_USER_ID_` AS `startUserId`,
	`re`.`KEY_` AS `module`,
	`re`.`NAME_` AS `moduleName`
FROM
	(
		`act_hi_procinst` `ins`
		JOIN `act_re_procdef` `re` ON (
			(
				`ins`.`PROC_DEF_ID_` = `re`.`ID_`
			)
		)
	)

3.已办

SELECT
	`hts`.`PROC_INST_ID_` AS `instanceId`,
	`hts`.`NAME_` AS `taskName`,
	`hts`.`START_TIME_` AS `startTime`,
	`hts`.`END_TIME_` AS `endTime`,
	`hts`.`ASSIGNEE_` AS `doneUserId`
FROM
	`act_hi_taskinst` `hts`
WHERE
	(
		(`hts`.`ASSIGNEE_` IS NOT NULL)
		AND (`hts`.`END_TIME_` IS NOT NULL)
	)