Acitiviti工作流实现查询待办、已办、办结、撤销等任务

最新推荐文章于 2024-05-29 17:47:53 发布
最新推荐文章于 2024-05-29 17:47:53 发布
阅读量2.4w 收藏 26
点赞数 3
分类专栏： Acitiviti工作流
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wangxueqing52/article/details/79876411
版权

1.首先需要建立几张视图

    由于数据库方言不一样，以及系统的用户角色表也有所差异，根据自己需求改动SQL文件

1.1 V_ACTLIST 任务视图表（用于查询单个审批流程的具体过程以及意见）

SELECT
	T.NAME_ AS NAME,
	T.END_TIME_ AS BLTIME,
	U.USERNAME AS USERNAME,
	T.PROC_INST_ID_ AS procInstId,
	C.MESSAGE_ AS clyj,
	T.START_TIME_,
	D.DeptName
FROM
	ASSETSMETADATA.ACT_HI_TASKINST T
LEFT OUTER JOIN 
(SELECT * FROM IPRIVILAGEMETADATA.USERS)U 
ON T.ASSIGNEE_ = U.PKID
LEFT OUTER JOIN 
(SELECT * FROM IPRIVILAGEMETADATA.DEPARTMENTS)D 
ON D.Pkid = U.DeptId
LEFT OUTER JOIN 
(SELECT * FROM ASSETSMETADATA.ACT_HI_COMMENT)C 
ON T.ID_ = C.TASK_ID_

1.2 V_TASKLIST_WSB 未上报任务视图表

SELECT
	cast('' as nvarchar2(255)) AS PROC_INST_ID_,
	cast('' as nvarchar2(255)) AS END_ACT_ID_,
	cast('未上报' as nvarchar2(255)) AS actName,
	cast('未上报' as nvarchar2(255)) AS actName_T,
	cast('' as nvarchar2(255)) AS assignee,
	cast('' as nvarchar2(255)) AS candidate,
	-1 AS taskstatus,
	cast('' as DATE) AS bltime,
	cast('' as nvarchar2(255)) AS prdekey,
	cast('' as nvarchar2(255)) AS prdename FROM ASSETSMETADATA.ACT_ID_USER

1.3 V_TASKLIST_DB 待办任务视图表

SELECT
	cast(A.PROC_INST_ID_ as nvarchar2(255)) PROC_INST_ID_,
	cast('' as nvarchar2(255)) END_ACT_ID_,
	cast(A.NAME_ as nvarchar2(255)) actName,
	cast(A.NAME_ as nvarchar2(255)) actName_T,
	cast(A.ASSIGNEE_ as nvarchar2(255)) assignee,
	cast(R.UserID as nvarchar2(255)) candidate,
	2 AS taskstatus,
	cast('' as DATE) bltime,
	cast(PRDE.KEY_ as nvarchar2(255)) prdekey,
	cast(PRDE.NAME_ as nvarchar2(255)) prdename
FROM
	ASSETSMETADATA.ACT_RU_TASK A
LEFT OUTER JOIN ASSETSMETADATA.ACT_RE_PROCDEF PRDE ON A.PROC_DEF_ID_ = PRDE.ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RU_IDENTITYLINK IDEN ON IDEN.TASK_ID_ = A.ID_
LEFT OUTER JOIN IPRIVILAGEMETADATA.ROLEUSERREF R ON IDEN.GROUP_ID_ = R.ROLEID

1.4 V_TASKLIST_YB 已办任务视图表

SELECT DISTINCT
	cast(H.PROC_INST_ID_ as nvarchar2(255)) PROC_INST_ID_,
	cast(H.END_ACT_ID_ as nvarchar2(255)) END_ACT_ID_,
	cast(A.NAME_ as nvarchar2(255)) actName,
	cast(T.NAME_ as nvarchar2(255)) actName_T,
	cast(T.ASSIGNEE_ as nvarchar2(255)) assignee,
	cast('' as nvarchar2(255)) candidate,
	2 AS taskstatus,
	T.END_TIME_  bltime,
	cast(PRDE.KEY_ as nvarchar2(255)) prdekey,
	cast(PRDE.NAME_ as nvarchar2(255)) prdename
FROM
	ASSETSMETADATA.ACT_HI_PROCINST H
LEFT OUTER JOIN ASSETSMETADATA.ACT_HI_TASKINST T ON H.PROC_INST_ID_ = T.PROC_INST_ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RE_PROCDEF PRDE ON H .PROC_DEF_ID_ = PRDE.ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RU_TASK A ON H.PROC_INST_ID_ = A.PROC_INST_ID_
WHERE
	(H.END_TIME_ IS NULL)
AND (T.END_TIME_ IS NOT NULL)

1.5 V_TASKLIST_SYYB 所有已办任务视图表

SELECT DISTINCT
	cast(H.PROC_INST_ID_ as nvarchar2(255)) PROC_INST_ID_,
	cast(H.END_ACT_ID_ as nvarchar2(255)) END_ACT_ID_,
	cast(NVL(A.NAME_,NVL2(H.END_ACT_ID_, '任务完结','撤销完结')) as nvarchar2(255))  AS actName,
	cast(T.NAME_ as nvarchar2(255)) AS actName_T,
	cast(T.ASSIGNEE_ as nvarchar2(255)) AS assignee,
	cast('' as nvarchar2(255)) AS candidate,
	2 AS taskstatus,
	T.END_TIME_ AS bltime,
	cast(PRDE.KEY_ as nvarchar2(255)) AS prdekey,
	cast(PRDE.NAME_  as nvarchar2(255)) AS prdename
FROM
	ASSETSMETADATA.ACT_HI_PROCINST H
LEFT OUTER JOIN ASSETSMETADATA.ACT_HI_TASKINST T ON H.PROC_INST_ID_ = T.PROC_INST_ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RE_PROCDEF PRDE ON H.PROC_DEF_ID_ = PRDE.ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RU_TASK A ON H.PROC_INST_ID_ = A.PROC_INST_ID_
WHERE
	(T.END_TIME_ IS NOT NULL)
AND (
	NOT EXISTS (
		SELECT
			PROC_INST_ID_
		FROM
			ASSETSMETADATA.V_TASKLIST_DB D
		WHERE
		(PROC_INST_ID_ = H.PROC_INST_ID_)
		AND (candidate = T.ASSIGNEE_)
		AND (actName_T = T.NAME_)
		OR (
			PROC_INST_ID_ = H.PROC_INST_ID_
		)
		AND (actName_T = T.NAME_)
		AND (assignee = T.ASSIGNEE_)
		OR (PROC_INST_ID_ = H.PROC_INST_ID_)
		AND (candidate = T.ASSIGNEE_)
		AND (actName LIKE '%上报%')
		AND (T.NAME_ LIKE '%上报%')
		OR (PROC_INST_ID_ = H.PROC_INST_ID_)
		AND (assignee = T.ASSIGNEE_)
		AND (actName LIKE '%上报%')
		AND (T.NAME_ LIKE '%上报%')
	)
)
ORDER BY
	bltime DESC

1.5 V_TASKLIST_BJ 办结任务视图表

SELECT DISTINCT
	cast(H.PROC_INST_ID_ as nvarchar2(255)) PROC_INST_ID_,
	cast(H.END_ACT_ID_ as nvarchar2(255)) END_ACT_ID_,
	cast('结束' as nvarchar2(255)) actName,
	cast('结束' as nvarchar2(255)) actName_T,
	cast(T.ASSIGNEE_ as nvarchar2(255))  assignee,
	cast('' as nvarchar2(255))  candidate,
	3 taskstatus,
	T.END_TIME_  bltime,
	cast(PRDE.KEY_ as nvarchar2(255))  prdekey,
	cast(PRDE.NAME_ as nvarchar2(255))  prdename
FROM
	ASSETSMETADATA.ACT_HI_PROCINST H
LEFT OUTER JOIN 
	(SELECT * FROM ASSETSMETADATA.ACT_HI_TASKINST)T
ON H.PROC_INST_ID_ = T.PROC_INST_ID_
LEFT OUTER JOIN 
  (SELECT * FROM ASSETSMETADATA.ACT_RE_PROCDEF)PRDE 
ON H.PROC_DEF_ID_ = PRDE.ID_
WHERE
	(H.END_TIME_ IS NOT NULL) AND (H.END_ACT_ID_ IS NOT NULL)

1.6 V_TASKLIST_CX 撤销任务视图表

SELECT DISTINCT
	cast(H.PROC_INST_ID_ as nvarchar2(255)) PROC_INST_ID_,
	cast(H.END_ACT_ID_ as nvarchar2(255)) END_ACT_ID_,
	cast('结束' as nvarchar2(255)) AS actName,
	cast('结束' as nvarchar2(255)) AS actName_T,
	cast(T.ASSIGNEE_ as nvarchar2(255)) AS assignee,
	cast('' as nvarchar2(255)) AS candidate,
	5 AS taskstatus,
	T.END_TIME_ AS bltime,
	cast(PRDE.KEY_ as nvarchar2(255)) AS prdekey,
	cast(PRDE.NAME_ as nvarchar2(255)) AS prdename
FROM
	ASSETSMETADATA.ACT_HI_PROCINST H
LEFT OUTER JOIN ASSETSMETADATA.ACT_HI_TASKINST  T ON H.PROC_INST_ID_ = T.PROC_INST_ID_
LEFT OUTER JOIN ASSETSMETADATA.ACT_RE_PROCDEF  PRDE ON H.PROC_DEF_ID_ = PRDE.ID_
WHERE
	(H.END_TIME_ IS NOT NULL)
AND (H.END_ACT_ID_ IS NULL)
2.后台代码逻辑 
	@Override
	public ArrayList findActList(Integer rows,Integer page, HashMap paramMap) {
		String sql = "";
		if(paramMap.get("checkmessage")!=null&&StringUtils.isNotEmpty(paramMap.get("checkmessage").toString())){
//			sql = "select * from ASSETSMETADATA.V_ACTLIST V where PROCINSTID= ? and clyj is not null and clyj <> '完成' ORDER BY START_TIME_";
			sql = "select * from ASSETSMETADATA.V_ACTLIST V where PROCINSTID= ? and clyj is not null ORDER BY START_TIME_";
		}else{
			sql = "SELECT V.*" + " FROM ASSETSMETADATA.V_ACTLIST V WHERE procInstId = ? ORDER BY V.START_TIME_";
		}
		List<Object> paramList = new ArrayList<Object>();
		paramList.add(paramMap.get("procInstId").toString());

		Session session = sessionFactory.getCurrentSession();
		SQLQuery query = session.createSQLQuery(sql);
		query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

		int firstNum = (page - 1) * rows;
		int lastNum = firstNum + rows;
		query.setFirstResult(firstNum);
		query.setMaxResults(lastNum);

		for (int i = 0; i < paramList.size(); i++) {
			query.setParameter(i, paramList.get(i));
		}
		return (ArrayList) query.list();
	}

	@Override
	public int findActListCount(HashMap paramMap) {
		String sql = "";
		if(paramMap.get("checkmessage")!=null&&StringUtils.isNotEmpty(paramMap.get("checkmessage").toString())){
			sql = "select count(*) from ASSETSMETADATA.V_ACTLIST V where PROCINSTID= ? and clyj is not null and clyj <> '完成' ORDER BY START_TIME_";
		}else{
			sql = "SELECT count(*)" + " FROM ASSETSMETADATA.V_ACTLIST V WHERE procInstId = ? ORDER BY V.START_TIME_";
		}
		List<Object> paramList = new ArrayList<Object>();
		paramList.add(paramMap.get("procInstId").toString());
		Session session = sessionFactory.getCurrentSession();
		SQLQuery query = session.createSQLQuery(sql);
		for (int i = 0; i < paramList.size(); i++) {
			query.setParameter(i, paramList.get(i));
		}
		List result = query.list();
		if (result.size() > 0) {
			return Integer.parseInt(result.get(0) == null ? "" : result.get(0).toString());
		}
		return 0;
	}

	@Override
	public ArrayList findList(HashMap<String, Object> paramMap, String tableName, String userid, String taskstatus,
			Integer rows,Integer page) {
		// sql 参数
		List<Object> paramList = new ArrayList<Object>();
		String sql = "";
		// 0.查询全部的任务
		if ("0".equals(taskstatus)) {
			sql = "SELECT * FROM (" + "SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_DB V ON tb.procInstId = v.PROC_INST_ID_ WHERE (v.ASSIGNEE = '" + userid
					+ "' OR v.CANDIDATE = '" + userid + "') ";

			sql += " UNION SELECT tb.*,V.* FROM " + tableName;


//			sql += " SELECT * FROM( SELECT tb.*,V.* FROM " + tableName
			sql 	+= " tb left join ASSETSMETADATA.V_TASKLIST_YB V ON tb.procInstId = v.PROC_INST_ID_ WHERE  V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ )  AND (v.ASSIGNEE = '" + userid + "' OR v.CANDIDATE = '"
					+ userid + "') ";


			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_BJ V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "' AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_WSB V ON tb.procInstId = v.PROC_INST_ID_ WHERE tb.reportStatus = 0 and tb.applyuser='"+userid+"'";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_CX V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "'";
			sql += ") t WHERE 1=1 ";

		}
		// 查询代办的任务
		if ("1".equals(taskstatus)) {
			sql = "SELECT * FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_DB V ON t.procInstId = v.PROC_INST_ID_  WHERE (v.ASSIGNEE = ? OR v.CANDIDATE = ?) ";
			paramList.add(userid);
			paramList.add(userid);
		}
		// 查询已办
		if ("2".equals(taskstatus)) {
			sql = "SELECT * FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_YB V ON t.procInstId = v.PROC_INST_ID_ WHERE (v.ASSIGNEE = ? OR v.CANDIDATE = ?) AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ ) ";
			paramList.add(userid);
			paramList.add(userid);
		}
		// 查询办结的
		if ("3".equals(taskstatus)) {
			sql = "SELECT * FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_BJ V ON t.procInstId = v.PROC_INST_ID_ WHERE V.ASSIGNEE = ? AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ ) ";
			paramList.add(userid);
		}
		// 查询办结的
		if ("4".equals(taskstatus)) {
			sql = "SELECT * FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_WSB V ON t.procInstId = v.PROC_INST_ID_ WHERE t.reportStatus = 0 ";
		}
		// 查询撤销的
		if ("5".equals(taskstatus)) {
			sql = "SELECT * FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_CX V ON t.procInstId = v.PROC_INST_ID_ WHERE V.ASSIGNEE = ? ";
			paramList.add(userid);
		}

		// 购置查询
		if ("6".equals(taskstatus)) {
			sql = "SELECT * FROM (";
			sql += " SELECT tb.*,V.* FROM " + tableName
					+ " tb left join  ASSETSMETADATA.V_TASKLIST_YB V ON tb.procInstId = v.PROC_INST_ID_ WHERE  (v.ASSIGNEE = '" + userid
					+ "' OR v.CANDIDATE = '" + userid + "') AND "
					+ " v.PROC_INST_ID_ Not IN(SELECT V.PROC_INST_ID_ FROM  ASSETSMETADATA.V_TASKLIST_DB V WHERE (V.ASSIGNEE = '"
					+ userid + "' OR V.CANDIDATE = '" + userid
					+ "') ) AND V.BLTIME in ( SELECT max(bltime) from  ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join  ASSETSMETADATA.V_TASKLIST_BJ V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "' AND V.BLTIME in ( SELECT max(bltime) from  ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += ") t WHERE 1=1 ";

		}

		// 便利前台查询条件的paramMap
		for (Map.Entry<String, Object> entry : paramMap.entrySet()) {
			if (entry!=null&&entry.getValue() != null && !entry.getValue().equals("")&& !entry.getValue().equals("null")&& !entry.getKey().equals("null")) {
				sql += " AND  t." + entry.getKey() + " like ? ";
				paramList.add(entry.getValue());
			}
		}

		sql += " ORDER BY t.createTime DESC";

		Session session = sessionFactory.getCurrentSession();
		SQLQuery query = session.createSQLQuery(sql);
		query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
		int firstNum = (page - 1) * rows;
		int lastNum = firstNum + rows;
		query.setFirstResult(firstNum);
		query.setMaxResults(lastNum);

		for (int i = 0; i < paramList.size(); i++) {
			query.setParameter(i, paramList.get(i));
		}
		return (ArrayList) query.list();
	}

	@Override
	public int findListCount(HashMap<String, Object> paramMap, String tableName, String userid, String taskstatus) {
		// sql 参数
		List<Object> paramList = new ArrayList<Object>();
		String sql = "";
		// 0.查询全部的任务
		if ("0".equals(taskstatus)) {
			sql = "SELECT count(*) FROM (" + "SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_DB V ON tb.procInstId = v.PROC_INST_ID_ WHERE (v.ASSIGNEE = '" + userid
					+ "' OR v.CANDIDATE = '" + userid + "') ";

			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_YB V ON tb.procInstId = v.PROC_INST_ID_ WHERE  V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ )  AND (v.ASSIGNEE = '" + userid + "' OR v.CANDIDATE = '"
					+ userid + "') ";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_BJ V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "' AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_WSB V ON tb.procInstId = v.PROC_INST_ID_ WHERE tb.reportStatus = 0";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join ASSETSMETADATA.V_TASKLIST_CX V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "'";
			sql += ") t WHERE 1=1 ";

		}
		// 查询代办的任务
		if ("1".equals(taskstatus)) {
			sql = "SELECT count(*) FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_DB V ON t.procInstId = v.PROC_INST_ID_  WHERE (v.ASSIGNEE = ? OR v.CANDIDATE = ?) ";
			paramList.add(userid);
			paramList.add(userid);
		}
		// 查询已办
		if ("2".equals(taskstatus)) {
			sql = "SELECT count(*) FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_YB V ON t.procInstId = v.PROC_INST_ID_ WHERE (v.ASSIGNEE = ? OR v.CANDIDATE = ?) AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ ) ";
			paramList.add(userid);
			paramList.add(userid);
		}
		// 查询办结的
		if ("3".equals(taskstatus)) {
			sql = "SELECT count(*) FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_BJ V ON t.procInstId = v.PROC_INST_ID_ WHERE V.ASSIGNEE = ? AND V.BLTIME in ( SELECT max(bltime) from ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '"
					+ userid + "' group by b.PROC_INST_ID_ ) ";
			paramList.add(userid);
		}
		// 查询办结的
		if ("4".equals(taskstatus)) {
			sql = "SELECT count(*) FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_WSB V ON t.procInstId = v.PROC_INST_ID_ WHERE t.reportStatus = 0 ";
		}
		// 查询撤销的
		if ("5".equals(taskstatus)) {
			sql = "SELECT count(*) FROM " + tableName
					+ " t left join ASSETSMETADATA.V_TASKLIST_CX V ON t.procInstId = v.PROC_INST_ID_ WHERE V.ASSIGNEE = ? ";
			paramList.add(userid);
		}

		// 购置查询
		if ("6".equals(taskstatus)) {
			sql = "SELECT count(*) FROM (";
			sql += " SELECT tb.*,V.* FROM " + tableName
					+ " tb left join  ASSETSMETADATA.V_TASKLIST_YB V ON tb.procInstId = v.PROC_INST_ID_ WHERE  (v.ASSIGNEE = '" + userid
					+ "' OR v.CANDIDATE = '" + userid + "') AND "
					+ " v.PROC_INST_ID_ Not IN(SELECT V.PROC_INST_ID_ FROM  ASSETSMETADATA.V_TASKLIST_DB V WHERE (V.ASSIGNEE = '"
					+ userid + "' OR V.CANDIDATE = '" + userid
					+ "') ) AND V.BLTIME in ( SELECT max(bltime) from  ASSETSMETADATA.V_TASKLIST_YB B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += " UNION SELECT tb.*,V.* FROM " + tableName
					+ " tb left join  ASSETSMETADATA.V_TASKLIST_BJ V ON tb.procInstId = v.PROC_INST_ID_ WHERE v.ASSIGNEE = '" + userid
					+ "' AND V.BLTIME in ( SELECT max(bltime) from  ASSETSMETADATA.V_TASKLIST_BJ B where B.ASSIGNEE = '" + userid
					+ "' group by b.PROC_INST_ID_ ) ";
			sql += ") t WHERE 1=1 ";

		}
		// 便利前台查询条件的paramMap
		for (Map.Entry<String, Object> entry : paramMap.entrySet()) {
			if (entry!=null&&entry.getValue() != null && !entry.getValue().equals("")&& !entry.getValue().equals("null")&& !entry.getKey().equals("null")) {
				sql += " AND  t." + entry.getKey() + " like ? ";
				paramList.add(entry.getValue());
			}
		}

		Session session = sessionFactory.getCurrentSession();
		SQLQuery query = session.createSQLQuery(sql);
		for (int i = 0; i < paramList.size(); i++) {
			query.setParameter(i, paramList.get(i));
		}
		Object obj = query.uniqueResult();
		return  Integer.parseInt(obj.toString());
	}







别等时光染了梦想
关注
  • 3
    点赞
  • 踩
  • 26
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Activiti目录（四）查询代办/已办、审核
weixin_45067120的博客
05-23 4740
把Activiti打入你的脑袋，通过查询代办/已办、审核快速打入一、审核代办/已办二、签收代办（审核）三、实例代码 一、审核代办/已办 功能 思路 1.查询当前用户 代办 2.根据当前用户ID获取待审核任务 3.返回待审核任务信息 – – 1.查询当前用户 已办 2.根据当前用户ID获取历史审核任务 3.返回历史审核任务信息 /** * 审核列表 * TODO 1：查询用户及权限 * TODO 2：查询用户审核状态
Vue案例之实现ToDolist
2401_84091628的博客
04-08 839
核心竞争力，怎么才能提高呢？成年人想要改变生活，逆转状态？那就开始学习吧~万事开头难，但是程序员这一条路坚持几年后发展空间还是非常大的，一切重在坚持。为了帮助大家更好更高效的准备面试，特别整理了《前端工程师面试手册》电子稿文件。
【vue2+Flowable工作流，审批流前端展示组件】
最新发布
demotang的博客
05-29 1368
自己使用过程中遇到的场景，可自己修改样式在ColumnTip使用。vue2+Flowable工作流，审批流前端展示组件。
Activiti应用实践(三)-查询待办和已办任务
热门推荐
Neo.Yang的专栏
08-18 2万+
一、概述 在开发作业管理功能时，查询某个用户的待办和已办任务是基本需求。activiti也提供了接口用于查询待办和已办任务。承接上两篇博客的介绍，这里的待办和已办是指审批人待审批的电子流和已审批完成的电子流。 activitid的28张表中的act_ru_task记录了待办任务；act_hi_taskinst记录了历史的已办任务。 二、实现逻辑 /** * 查询用户待办任务列表。 * * @...
Activiti工作流查询待办和已办
沉淀的博客
09-24 9581
1.act_ru_execution 执行对象表 2.act_ru_task 用户任务表 3.act_hi_actinst 活动节点历史表 4.act_hi_procinst 流程实例历史表 5.act_hi_taskinst 历史任务表 查询待办的任务，查任务列表，当前任务走到哪个步骤节点 TaskQuery query = taskService.createTaskQuery() .taskCandidateOrAssigned(assignee) .orderBy.
工作流待办事项桌面消息提醒器
12-31
工作流待办事项桌面消息提醒器，开机自动启动、自动提醒、点击消息在浏览器中打开待办.zip
关于Activiti工作流中自定义查询和分页
昊谦粑粑
10-09 3636
自定义SQL查询： List<HistoricTaskInstance> histList = historyService.createNativeHistoricTaskInstanceQuery().sql("select * from " + managementService.getTableName(HistoricTaskInstance.class)+" H " ...
Activiti工作流之任务的运行/查询/完成
C8WATER
11-02 1万+
8张表: SELECT * FROM act_re_deployment; -- 一 流程部署表 SELECT * FROM act_ge_bytearray; -- 二 流程二进制表 SELECT * FROM act_re_procdef; -- 三 流程定义表 SELECT * FROM act_ru_execution; -- 四 流程正在运行表 SE...
泛微统一待办中心文档-泛微统一待办中心文档
05-23
- **isremark**: 流程处理状态，0 表示待办，2 表示已办，4 表示办结，8 表示抄送（待阅），类型为 String。 - **viewtype**: 流程查看状态，0 表示未读，1 表示已读，类型为 String。 - **creator**: 创建人...
JBPM工作流演示系统使用说明.docx
10-14
6. **我的已办结任务**：显示已全部完成的审批流程。 7. **职务管理**：包括职务查看、添加和批量删除，系统中"经理"和"老板"职务必不可少。 8. **用户注册**：创建新用户时需要设置职务，密码设置后不可更改。 9. *...
jBPM请假工作流，很全的任务列表
12-31
5. **我的待办任务**: 这是审批人的视角，显示了等待审批的请假请求。审批人可以查看申请详情，决定是否批准，并给出理由。 6. **我的经办任务**: 这些是已经处理过的任务，记录了审批历史，可作为审计和追溯的依据...
21.集成开发需求方案附件二：OA系统工作流WebService接口使用说明.doc
03-11
泛微OA系统是一款广泛应用于企业办公自动化的工作流管理系统，它提供了强大的WebService接口，使得外部系统可以方便地与其进行数据交互和流程控制。本说明文档详细介绍了如何使用这些接口，包括检查部署状态、调用...
2021办税服务厅工作总结范文五篇.docx
10-22
3. 优化创新服务：推行AB岗制度，提升新进员工的工作能力，改进工作模式，如在纳税人高峰期合理调配任务，利用叫号机与科所长轮班制减少排队冲突，提升办税效率和纳税人满意度。此外，制定《票证审核管理办法》，...
ACTIVITI sql查询待办、已办业务
cxy_jzli的博客
10-26 1081
activit
接入门户统一待办运维经验小结——更新待办为已办
肖永威的专栏
02-27 5994
在用户门户统一待办界面上，如果打开本系统待办提示如下信息“当前待办已处理请勿重复操作”，则出现不能进一步处理业务的问题。
Activiti工作流学习（二）流程实例、执行对象、任务
xjanting的博客
04-12 1285
一.前言   前面说明了基本的流程部署、定义，启动流程实例等基本操作，下面我们继续来学习流程实例、执行对象、任务。二.流程实例、执行对象说明   整个Activiti的生命周期经过了如下的几个步骤： 1.流程部署 ---&gt;  2.启动流程实例 --- &gt; 3.执行流程对象(一个流程实例包含多执行对象) ---&gt; 4.完成整个流程   说明：三.例子演示  1.完成我的任务   2...
Activiti7学习四之任务查询、任务处理、流程定义的查询
枣泥馅的博客
06-12 4881
任务查询 任务启动后，任务负责人就能查询自己当前能够处理的任务了，查询出来的任务都是当前用户的代办任务。 任务处理任务负责人查询出来的待办的人，选择任务处理，完成任务。 当前任务张三已经通过，任务流向到了经理李四哪儿。该李四查询任务并处理任务。 流程定义的信息查询 查询流程相关的信息，包括流程的定义，流程的部署，流程定义的版本。 输出结果： 流程定义的id: evection:1:12504 定义流程是起的id 流程定义的name： 是定义流程的时候给流程起的名字 流程定义的key：evection
让用友OA的“已办/待办事项”刷新后保留查询条件
编程手札
01-22 2983
还是这个OA，问题挺多的，这是前段时间应急用的临时修改（到现在还没有官方的补丁），此修改可让“已办/待办事项”在刷新后仍然保留最后查询条件而且生效。修改文件：yyoa/infoMgr/processInfo/toolBar.jsp修改内容：第659开始的两个TD的内容改为：        td>String __condition__ = "";if (session.getAtt
Activiti 生成流程图和已审批、待审批节点高亮
佛系写BUG的博客
05-31 4179
Activiti 查看流程图和已执行节点高亮 如图: 图中绿色为已经执行的节点,红色为当前正在执行的节点。 html <div class="approve_content" v-if="active==2"> <div class="approve_div"> <el-alert size="large" type="info"
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值