<?xml version="1.0" encoding="UTF-8"?>
|
<!DOCTYPE sql PUBLIC "sql" "../config/sql.dtd" >
|
|
<sqls>
|
|
<dataSpace name="activiti">
|
<sql name="getfrommodelmapping">
|
<![CDATA[
|
select * from modelmapping where @{field} = '@{value}'
|
]]>
|
</sql>
|
<sql name="fromTaskIdgetTableName">
|
<![CDATA[
|
SELECT formname from modelmapping WHERE modelid = (
|
SELECT ID_ FROM act_re_model WHERE CATEGORY_ = (
|
SELECT DEPLOYMENT_ID_ FROM act_re_procdef WHERE ID_ = (
|
SELECT PROC_DEF_ID_ from act_ru_task WHERE ID_ = '@{taskid}')))
|
]]>
|
</sql>
|
|
<sql name="getTaskDetail">
|
<![CDATA[
|
select p_leave.* ,act_ru_task.TASK_DEF_KEY_ from p_leave
|
LEFT JOIN act_hi_procinst on p_leave.id = act_hi_procinst.BUSINESS_KEY_
|
LEFT JOIN act_ru_task on act_ru_task.PROC_INST_ID_= act_hi_procinst.ID_
|
WHERE act_ru_task.ID_ = '@{taskid}'
|
]]>
|
</sql>
|
|
<sql name="updateActinstUser">
|
<![CDATA[
|
update act_hi_actinst set ASSIGNEE_ = '@{userid}' where PROC_INST_ID_ = '@{id}' and ACT_TYPE_ = 'startEvent'
|
]]>
|
</sql>
|
|
<sql name="getModelName">
|
<![CDATA[
|
SELECT
|
act_re_model.ID_ AS id,
|
act_re_model.NAME_ AS name,
|
act_re_model.VERSION_ AS version,
|
act_re_model.LAST_UPDATE_TIME_ AS updatetime
|
FROM
|
(
|
SELECT
|
KEY_,
|
MAX (VERSION_) AS VERSION_
|
FROM
|
act_re_model
|
GROUP BY
|
KEY_
|
) group_model
|
LEFT JOIN act_re_model ON act_re_model.KEY_ = group_model.KEY_
|
AND act_re_model.VERSION_ = group_model.VERSION_
|
]]>
|
</sql>
|
|
<sql name="getDeletedWorkflowItem">
|
<![CDATA[
|
SELECT * FROM @{tablename}
|
LEFT JOIN act_hi_procinst on @{tablename}.id = act_hi_procinst.BUSINESS_KEY_
|
LEFT JOIN act_re_procdef on act_hi_procinst.PROC_DEF_ID_ = act_re_procdef.ID_
|
LEFT JOIN act_re_deployment on act_re_deployment.ID_ = act_re_procdef.DEPLOYMENT_ID_
|
WHERE act_re_deployment.ID_ = '@{deploymentid}'
|
]]>
|
</sql>
|
|
<sql name="getHistoryAction" >
|
<![CDATA[
|
SELECT act.*, v_hierarchy.name as assigneename,
|
passflag.TEXT_ as passflag,
|
reason.TEXT_ as reason
|
|
FROM act_hi_actinst act
|
|
LEFT JOIN v_hierarchy
|
on act.ASSIGNEE_ = v_hierarchy.id
|
|
LEFT JOIN
|
(SELECT a.*, d.TEXT_
|
FROM act_hi_actinst a
|
LEFT JOIN act_hi_detail d ON d.ACT_INST_ID_ = a.ID_ and d.NAME_ = 'passflag') passflag
|
on passflag.ID_ = act.ID_
|
|
LEFT JOIN
|
(SELECT a.*, d.TEXT_
|
FROM act_hi_actinst a
|
LEFT JOIN act_hi_detail d ON d.ACT_INST_ID_ = a.ID_ and d.NAME_ = 'reason') reason
|
on reason.ID_ = act.ID_
|
|
WHERE act.PROC_INST_ID_ = '@{workflowid}' and act.ACT_TYPE_ <> 'exclusiveGateway'
|
]]>
|
</sql>
|
|
</dataSpace>
|
|
</sqls>
|
