package com.norteksoft.task.dao;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import org.apache.commons.lang.StringUtils;
import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;
import com.norteksoft.product.orm.Page;
import com.norteksoft.product.orm.hibernate.HibernateDao;
import com.norteksoft.product.util.ContextUtils;
import com.norteksoft.task.base.enumeration.TaskProcessingMode;
import com.norteksoft.task.base.enumeration.TaskState;
import com.norteksoft.task.base.enumeration.TaskProcessingResult;
import com.norteksoft.task.entity.WorkflowTask;
import com.norteksoft.wf.base.enumeration.ProcessState;
@Repository
public class WorkflowTaskDao extends HibernateDao<WorkflowTask, Long>{
public WorkflowTask getTask(Long taskId){
return findUniqueNoCompanyCondition("from WorkflowTask t where t.id=?", taskId);
}
public List<WorkflowTask> getWorkflowTasks(String instanceId, String taskName) {
return find("from WorkflowTask t where t.processInstanceId = ? and t.name = ? and t.paused=?", instanceId, taskName,false);
}
public WorkflowTask getFirstTaskByInstance(Long companyId, String instanceId, String transactor,Long userId) {
return findUnique("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?))",
companyId, instanceId, transactor,userId);
}
public void deleteTaskByProcessId(String processInstanceId, Long companyId) {
this.createQuery("delete from WorkflowTask t where t.processInstanceId = ? and t.companyId = ? ", processInstanceId,companyId).executeUpdate();
}
public void deleteTasksByName(Long companyId, String instanceId, String[] names){
for(String name : names){
createQuery("delete from WorkflowTask t where t.companyId=? and t.processInstanceId=? and t.name=?",
companyId, instanceId,StringUtils.trim(name)).executeUpdate();
}
}
public List<WorkflowTask> getTasksByName(Long companyId, String instanceId, String name){
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.name=? and t.effective=? and t.paused=?",
companyId, instanceId,name,true,false);
}
public List<WorkflowTask> getNotCompleteTasksByName(Long companyId, String instanceId, String name){
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.name=? and t.effective=? and (t.active<>? and t.active<>?)",
companyId, instanceId,name,true,TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex());
}
public List<WorkflowTask> getNoAssignTasksByName(Long companyId, String instanceId, String taskName,Integer groupNum) {
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.name = ? and t.active <> ? and t.effective=? and t.groupNum=?",
companyId, instanceId, taskName, TaskState.ASSIGNED.getIndex(), true,groupNum);
}
public Page<WorkflowTask> getDelegateTasks(Long companyId, String loginName,Long userId, Page<WorkflowTask> page){
Page<WorkflowTask> result = new Page<WorkflowTask>(page.getPageSize(), true);
result.setPageNo(page.getPageNo());
//result.setOrder(page.getOrder());
//result.setOrderBy(page.getOrderBy());
this.findPage(result,"from WorkflowTask t where t.companyId=? and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and t.paused=?",companyId, loginName,userId,false);
page = new Page<WorkflowTask>();
page.setResult(result.getResult());
//page.setOrder(result.getOrder());
//page.setOrderBy(result.getOrderBy());
page.setPageNo(result.getPageNo());
page.setPageSize(result.getPageSize());
page.setTotalCount(result.getTotalCount());
return page;
}
public Integer getDelegateTasksNum(Long companyId, String loginName,Long userId){
Object o = createQuery("select count(t) from WorkflowTask t where t.companyId=? and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and t.paused=?", companyId, loginName,userId,false).uniqueResult();
return Integer.valueOf(o.toString());
}
public Integer getDelegateTasksNum(Long companyId, String loginName,Long userId, Boolean isCompleted){
String hql = "select count(t) from WorkflowTask t where t.companyId=? and t.effective = true and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=?";
Object o = 0;
if(isCompleted){
o = createQuery(hql, companyId, loginName,userId, TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false).uniqueResult();
}else{
hql = "select count(t) from WorkflowTask t where t.companyId=? and t.effective = true and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? ";
o = createQuery(hql, companyId, loginName,userId, TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.DRAW_WAIT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false).uniqueResult();
}
return Integer.valueOf(o.toString());
}
public Integer getTrusteeTasksNum(Long companyId, String loginName,Long userId, Boolean isCompleted){
String hql = "select count(t) from WorkflowTask t where t.companyId=? and t.effective = true and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.trustor is not null";
Object o = 0;
if(isCompleted){
o = createQuery(hql, companyId, loginName,userId, TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false).uniqueResult();
}else{
hql = "select count(t) from WorkflowTask t where t.companyId=? and t.effective = true and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.trustor is not null";
o = createQuery(hql, companyId, loginName,userId, TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.DRAW_WAIT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false).uniqueResult();
}
return Integer.valueOf(o.toString());
}
public Page<WorkflowTask> getDelegateTasks(Long companyId, String loginName,Long userId, Page<WorkflowTask> page, boolean isEnd){
Page<WorkflowTask> result = new Page<WorkflowTask>(page.getPageSize(), true);
result.setPageNo(page.getPageNo());
//result.setOrder(page.getOrder());
//result.setOrderBy(page.getOrderBy());
String hql = "from WorkflowTask t where t.companyId=? and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and t.effective = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=?";
if(isEnd){
this.findPage(result,hql,companyId, loginName,userId, TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false);
}else{
hql = "from WorkflowTask t where t.companyId=? and ((t.trustor=? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) and t.effective = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? ";
this.findPage(result,hql,companyId, loginName,userId, TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.DRAW_WAIT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
page = new Page<WorkflowTask>();
page.setResult(result.getResult());
//page.setOrder(result.getOrder());
//page.setOrderBy(result.getOrderBy());
page.setPageNo(result.getPageNo());
page.setPageSize(result.getPageSize());
page.setTotalCount(result.getTotalCount());
return page;
}
public Page<WorkflowTask> getTaskAsTrustee(Long companyId, String loginName,Long userId, Page<WorkflowTask> page, boolean isEnd){
Page<WorkflowTask> result = new Page<WorkflowTask>(page.getPageSize(), true);
result.setPageNo(page.getPageNo());
String hql = "from WorkflowTask t where t.companyId=? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and t.effective = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.trustor is not null";
if(isEnd){
this.findPage(result,hql,companyId, loginName,userId, TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false);
}else{
hql = "from WorkflowTask t where t.companyId=? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and t.effective = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.trustor is not null";
this.findPage(result,hql,companyId, loginName,userId, TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.DRAW_WAIT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
page = new Page<WorkflowTask>();
page.setResult(result.getResult());
page.setPageNo(result.getPageNo());
page.setPageSize(result.getPageSize());
page.setTotalCount(result.getTotalCount());
return page;
}
public List<WorkflowTask> getAllTasksByInstance(Long companyId, String instanceId){
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.paused=?",
companyId, instanceId,false);
}
/**
* 活动该流程实例当前任务,当前任务为待领取或待办理且该任务不是分发给的任务也不是特事特办任务，且任务是有效的
* @param instanceId 实例id
* @param companyId 公司id
* @return 任务列表
*/
public List<WorkflowTask> getActivityTasks(String instanceId,Long companyId) {
if(companyId==null){
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? order by t.specialTask DESC",
instanceId,false,true,false);
}else{
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? order by t.specialTask DESC",
companyId, instanceId,false,true,false);
}
}
/**
* 加签或者减签时候取活动任务
* @param instanceId
* @param companyId
* @return
*/
public List<WorkflowTask> getActivitySignTasks(String instanceId,Long companyId) {
if(companyId==null){
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 查询办理人的当前任务
* @param instanceId
* @param companyId
* @return
*/
public WorkflowTask getMyTask(String instanceId,Long companyId,String loginName) {
List<WorkflowTask> tasks=this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.transactor = ? and (t.active=0 or t.active=1 or t.active=4 or t.active=6) and t.paused=?",
companyId, instanceId,loginName,false);
if(tasks.size()>0){
return tasks.get(0);
}
return null;
}
/**
* 查询办理人的当前任务
* @param instanceId
* @param companyId
* @return
*/
public WorkflowTask getMyTask(String instanceId,Long companyId,Long userId) {
List<WorkflowTask> tasks=this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and (t.transactorId is not null and t.transactorId=? ) and (t.active=0 or t.active=1 or t.active=4 or t.active=6) and t.paused=?",
companyId, instanceId,userId,false);
if(tasks.size()>0){
return tasks.get(0);
}
return null;
}
public List<String> getCountersignByProcessInstanceId(String processInstanceId,TaskProcessingMode processingMode){
return find( "select distinct t.name from WorkflowTask t where t.processInstanceId=? and t.processingMode=? and t.paused=? ", processInstanceId,processingMode,false);
}
/**
* 自定义流程中取会签环节名称
* @param processInstanceId
* @param processingMode
* @return
*/
public List<String> getSignByProcessInstanceId(String processInstanceId,TaskProcessingMode processingMode){
return find( "select t.name from WorkflowTask t where t.companyId = ? and t.processInstanceId=? and t.processingMode=? and t.paused=? group by t.name ",ContextUtils.getCompanyId(), processInstanceId,processingMode,false);
}
public List<WorkflowTask> getCountersignByProcessInstanceIdResult(String processInstanceId,String taskName,TaskProcessingResult result){
return find( "from WorkflowTask t where t.processInstanceId=? and t.name=? and t.taskProcessingResult=? and t.paused=? ", processInstanceId,taskName,result,false);
}
/**
* 获得审批任务组数
* @param processInstanceId
* @param taskName
* @param result
* @return
*/
public List<Integer> getGroupNumByTaskName(String processInstanceId,String taskName){
return find( "select t.groupNum from WorkflowTask t where t.processInstanceId=? and t.name=? and t.paused=? and t.companyId = ? group by t.groupNum", processInstanceId,taskName,false,ContextUtils.getCompanyId());
}
/**
* 流程有效的办理人
* @param companyId
* @param instanceId
* @return
*/
public List<String> getParticipantsTransactor(Long companyId,
String instanceId) {
return find("select t.transactor from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.active=? and t.effective=? and t.paused=?",
companyId, instanceId, TaskState.COMPLETED.getIndex(), true,false);
}
/**
* 流程有效的办理人
* @param companyId
* @param instanceId
* @return
*/
public List<Long> getParticipantsTransactorId(Long companyId,
String instanceId) {
return find("select t.transactorId from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and t.active=? and t.effective=? and t.paused=?",
companyId, instanceId, TaskState.COMPLETED.getIndex(), true,false);
}
public List<WorkflowTask> getCountersigns(String instanceId,String taskName){
return find( "from WorkflowTask t where t.processInstanceId=? and t.name=? and t.active=0 and t.paused=?", instanceId,taskName,false);
}
public List<WorkflowTask> getCountersigns(Long taskId,String instanceId,String taskName){
return find( "from WorkflowTask t where t.processInstanceId=? and t.name=? and t.active=0 and t.id!=? and t.paused=?", instanceId,taskName,taskId,false);
}
public List<String> getCountersignsHandler(String instanceId,String taskName,Integer activie){
return find( " select t.transactor from WorkflowTask t where t.processInstanceId=? and t.name=? and t.active=? and t.paused=?", instanceId,taskName,activie,false);
}
public void deleteCountersignHandler(String instanceId,String taskName,Collection<String> users){
StringBuilder transactorInfo = new StringBuilder();
Object[] values=new Object[4+(users.size()*2)];
String hql = "delete WorkflowTask t where t.processInstanceId=? and t.name=? and t.paused=? and t.processingMode!=? ";
if(users.size()>0){
hql =hql+" and (";
}
values[0]=instanceId;
values[1]=taskName;
values[2]=false;
values[3]=TaskProcessingMode.TYPE_READ;
int i=4;
for(String user:users){
transactorInfo.append("(t.transactor=? or t.trustor=?) or ");
values[i]=user;
int j=i+1;
values[j]=user;
i=j+1;
}
if(transactorInfo.indexOf("or")>=0)hql +=transactorInfo.toString().substring(0,transactorInfo.lastIndexOf("or"));
if(users.size()>0){
hql +=")";
}
this.batchExecute(hql, values);
}
public void deleteSignHandler(String instanceId,String taskName,Collection<Long> userIds){
StringBuilder transactorInfo = new StringBuilder();
Object[] values=new Object[4+(userIds.size()*2)];
String hql = "delete WorkflowTask t where t.processInstanceId=? and t.name=? and t.paused=? and t.processingMode!=? ";
if(userIds.size()>0){
hql =hql+" and (";
}
values[0]=instanceId;
values[1]=taskName;
values[2]=false;
values[3]=TaskProcessingMode.TYPE_READ;
int i=4;
for(Long userid:userIds){
transactorInfo.append("(t.transactorId=? or t.trustorId=?) or ");
values[i]=userid;
int j=i+1;
values[j]=userid;
i=j+1;
}
if(transactorInfo.indexOf("or")>=0){
hql +=transactorInfo.toString().substring(0,transactorInfo.lastIndexOf("or"));
}
if(userIds.size()>0){
hql +=")";
}
this.batchExecute(hql, values);
}
public List<String> getHandledTransactors(String workflowId) {
String hql = "select t.transactor from WorkflowTask t where t.processInstanceId=? and t.active=? and t.effective=? and t.paused=?";
return find(hql, workflowId,TaskState.COMPLETED.getIndex(),true,false);
}
public List<Long> getHandledTransactorIds(String workflowId) {
String hql = "select t.transactorId from WorkflowTask t where t.processInstanceId=? and t.active=? and t.effective=? and t.paused=?";
return find(hql, workflowId,TaskState.COMPLETED.getIndex(),true,false);
}
//获得流程所有办理人
public List<String> getAllHandleTransactors(String workflowId) {
String hql = "select t.transactor from WorkflowTask t where t.processInstanceId=? and t.effective=? and t.paused=?";
return find(hql, workflowId,true,false);
}
//获得流程所有办理人
public List<Long> getAllHandleTransactorIds(String workflowId) {
String hql = "select t.transactorId from WorkflowTask t where t.processInstanceId=? and t.effective=? and t.paused=?";
return find(hql, workflowId,true,false);
}
public List<WorkflowTask> getNeedReminderTasks() {
String hql = "from Task t where (t.active=? or t.active=? or t.active=?) and t.duedate<>0 and t.paused=?";
return find(hql, TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_TRANSACT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
public List<WorkflowTask> getCompletedTasks(String workflowId,
Long companyId) {
String hql = "from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.active=? and t.paused=? order by t.id";
return find(hql, workflowId,companyId,TaskState.COMPLETED.getIndex(),false);
}
public List<WorkflowTask> getNeedReminderTasks(String loginName,Long userId,
Long companyId) {
String hql = "from Task t where (t.active=? or t.active=? or t.active=?) and t.duedate<>0 and t.reminderStyle is not null and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.companyId=? and t.paused=?";
return find(hql, TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_TRANSACT.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),loginName,userId,companyId,false);
}
public List<WorkflowTask> getTasksOrderByWdfName(String definitionName,
String loginName) {
Assert.notNull(ContextUtils.getCompanyId(),"查询流程定义中某个办理人的任务时，公司id不能为null");
String hql = " from Task t where t.companyId = ? and t.transactor = ? and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.groupName=? and t.paused=? order by t.createdTime desc";
return find(hql,ContextUtils.getCompanyId(), loginName,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),definitionName,false);
}
public List<WorkflowTask> getTasksOrderByWdfName(String definitionName,
Long userId) {
Assert.notNull(ContextUtils.getCompanyId(),"查询流程定义中某个办理人的任务时，公司id不能为null");
String hql = " from Task t where t.companyId = ? and (t.transactorId is not null and t.transactorId=?) and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.groupName=? and t.paused=? order by t.createdTime desc";
return find(hql,ContextUtils.getCompanyId(), userId,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),definitionName,false);
}
public List<WorkflowTask> getCompletedTasksByTaskName(String workflowId,
Long companyId,String taskName) {
String hql = "from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.active=? and t.name=? and t.paused=? order by t.id";
return find(hql, workflowId,companyId,TaskState.COMPLETED.getIndex(),taskName,false);
}
public Integer getNotCompleteTasksNumByTransactor(Long companyId, String loginName){
return Integer.parseInt(createQuery(
"select count(t) from WorkflowTask t where t.companyId = ? and t.visible=true and t.transactor = ? and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=?",
companyId, loginName, TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false).uniqueResult().toString());
}
public Integer getNotCompleteTasksNumByTransactor(Long companyId, Long userId){
return Integer.parseInt(createQuery(
"select count(t) from WorkflowTask t where t.companyId = ? and t.visible=true and (t.transactorId is not null and t.transactorId=?) and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=?",
companyId, userId, TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false).uniqueResult().toString());
}
/**
* 查找公司中所有的超期任务
* @param companyId
* @return
*/
public List<WorkflowTask> getOverdueTasks(Long companyId) {
String hql = "from WorkflowTask t where t.companyId=? and (t.active=? or t.active=? or t.active=? or t.active=?) and t.lastReminderTime is not null and t.paused=? order by t.createdTime desc";
return find(hql, companyId,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
/**
* 查找当前办理人所有的超期任务的总数
* @param companyId
* @param transactorName
* @return
*/
public Integer getOverdueTasksNumByTransactor(Long companyId,String transactorName,Long transactorId) {
return Integer.parseInt(createQuery(
"select count(t) from WorkflowTask t where t.companyId=? and (t.active=? or t.active=? or t.active=? or t.active=?) and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.lastReminderTime is not null and t.paused=?",
companyId, TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),transactorName,transactorId,false).uniqueResult().toString());
}
/**
* 查找公司中所有的超期任务,包括已完成的任务
* @param companyId
* @return
*/
public List<WorkflowTask> getTotalOverdueTasks(Long companyId) {
String hql = "from WorkflowTask t where t.companyId=? and t.lastReminderTime is not null and t.paused=? order by t.createdTime desc";
return find(hql, companyId,false);
}
/**
* 查找当前办理人所有的超期任务的总数,包括已完成的任务
* @param companyId
* @param transactorName
* @return
*/
public Integer getTotalOverdueTasksNumByTransactor(Long companyId,String transactorName) {
return Integer.parseInt(createQuery(
"select count(t) from WorkflowTask t where t.companyId=? and t.transactor = ? and t.lastReminderTime is not null and t.paused=?",
companyId, transactorName,false).uniqueResult().toString());
}
/**
* 查找当前办理人所有的超期任务的总数,包括已完成的任务
* @param companyId
* @param transactorId
* @return
*/
public Integer getTotalOverdueTasksNumByTransactorId(Long companyId,Long transactorId) {
return Integer.parseInt(createQuery(
"select count(t) from WorkflowTask t where t.companyId=? and (t.transactorId is not null and t.transactorId=?) and t.lastReminderTime is not null and t.paused=?",
companyId, transactorId,false).uniqueResult().toString());
}
/**
* 获得“他人已领取”状态的任务
* @param companyId 公司id
* @param instanceId 流程实例id
* @param name 任务名称
* @return
*/
public List<WorkflowTask> getHasDrawOtherTasks(Long companyId, String instanceId, String name) {
String hql = "from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.name=? and t.active=? and t.paused=? order by t.id";
return find(hql, instanceId,companyId,name,TaskState.HAS_DRAW_OTHER.getIndex(),false);
}
/**
* 分页查询用户所有未完成任务
* @param page
*/
public void getAllTasksByUser(Long companyId, String loginName, Page<WorkflowTask> page){
String hql="from WorkflowTask t where t.companyId = ? and t.transactor = ? and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? order by t.createdTime desc";
this.searchPageByHql(page, hql.toString(),companyId, loginName,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
/**
* 分页查询用户所有未完成任务
* @param page
*/
public void getAllTasksByUser(Long companyId, Long userId, Page<WorkflowTask> page){
String hql="from WorkflowTask t where t.companyId = ? and (t.transactorId is not null and t.transactorId=?) and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? order by t.createdTime desc";
this.searchPageByHql(page, hql.toString(),companyId, userId,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
/**
* 分页查询用户已完成任务
* @param companyId
* @param loginName
* @param page
*/
public void getCompletedTasksByUser(Long companyId, String loginName,Long userId, Page<WorkflowTask> page) {
String hql="from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? order by t.transactDate desc";
this.searchPageByHql(page, hql.toString(),companyId, loginName,userId, TaskState.COMPLETED.getIndex(), TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false);
}
/**
* 分页查询用户已完成任务
* @param companyId
* @param loginName
* @param page
*/
public void getReadTasksByUser(Long companyId, String loginName,Long userId, Page<WorkflowTask> page) {
findPage(page, "from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=?) and t.read=true and t.paused=?",
companyId, loginName,userId, TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),false);
}
/**
* 获得所有办理人除当前任务名称的办理人
* @param task
* @return
*/
public List<String> getTransactorsExceptTask(WorkflowTask task){
String hql="select distinct t.transactor from WorkflowTask t where t.name!=? and t.companyId=? and t.processInstanceId=? and t.active=? and t.paused=?";
return this.find(hql, task.getName(),task.getCompanyId(),task.getProcessInstanceId(),TaskState.COMPLETED.getIndex(),false);
}
/**
* 获得所有办理人除当前任务名称的办理人
* @param task
* @return
*/
public List<Long> getTransactorIdsExceptTask(WorkflowTask task){
String hql="select distinct t.transactorId from WorkflowTask t where t.name!=? and t.companyId=? and t.processInstanceId=? and t.active=? and t.paused=?";
return this.find(hql, task.getName(),task.getCompanyId(),task.getProcessInstanceId(),TaskState.COMPLETED.getIndex(),false);
}
public List<String> getTransactorsByTask(String name,String transactor,Long transactorId,String processId){
String hql="select distinct t.transactor from WorkflowTask t where t.name=? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.processInstanceId=? and t.active=? and t.paused=?";
return this.find(hql, name,transactor,transactorId,processId,TaskState.WAIT_TRANSACT.getIndex(),false);
}
/**
* 根据“任务组”查询任务列表
* @param companyId
* @param instanceId
* @param taskName
* @return
*/
public List<WorkflowTask> getTaskOrderByGroupNum(Long companyId,String instanceId,String taskName){
String hql="from WorkflowTask t where t.name=? and t.companyId=? and t.processInstanceId=? and t.groupNum!=null and t.paused=? order by t.groupNum desc";
return this.find(hql,taskName,companyId,instanceId,false);
}
/**
* 活动该流程实例当前任务,当前任务为待领取或待办理且该任务不是分发给的任务也不是特事特办任务，且任务是有效的
* @param instanceId 实例id
* @param companyId 公司id
* @return 任务列表
*/
public List<WorkflowTask> getActivityTasksByName(String instanceId,Long companyId,String taskName) {
if(companyId==null){
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.name=? and t.paused=? order by t.specialTask DESC",
instanceId,false,true,taskName,false);
}else{
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.name=? and t.paused=? order by t.specialTask DESC",
companyId, instanceId,false,true,taskName,false);
}
}
/**
* 活动该流程实例当前任务的所有办理人,当前任务不是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return 办理人列表
*/
public List<String[]> getActivityTaskTransactors(String instanceId,Long companyId) {
if(companyId==null){
return this.find("select t.transactor,t.transactorName,t.name from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor=null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("select t.transactor,t.transactorName,t.name from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor=null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 活动该流程实例当前任务的所有办理人,当前任务不是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return 办理人列表
*/
public List<WorkflowTask> getActivityTaskByInstance(String instanceId,Long companyId) {
if(companyId==null){
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 活动该流程实例当前任务的所有委托人,当前任务是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return 办理人列表
*/
public List<String> getActivityTaskPrincipals(String instanceId,Long companyId) {
if(companyId==null){
return this.find("select t.trustor from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor!=null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("select t.trustor from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor!=null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 活动该流程实例当前任务的所有委托人,当前任务是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return 办理人列表
*/
public List<Long> getActivityTaskPrincipalIds(String instanceId,Long companyId) {
if(companyId==null){
return this.find("select t.trustorId from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("select t.trustorId from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 活动该流程实例当前任务的所有委托人,当前任务是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return 办理人列表[loginName,name]
*/
public List<String[]> getActivityTaskPrincipalsDetail(String instanceId,Long companyId) {
if(companyId==null){
return this.find("select t.trustor,t.trustorName from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("select t.trustor,t.trustorName from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
/**
* 活动该流程实例当前任务的所有委托人,当前任务是委托任务
* @param instanceId 实例id
* @param companyId 公司id
* @return
*/
public List<WorkflowTask> getActivityPrincipalTask(String instanceId,Long companyId) {
if(companyId==null){
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}else{
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6) and t.distributable=? and t.effective=? and t.trustor is not null and t.paused=? and t.processingMode!=? order by t.specialTask DESC",
companyId, instanceId,false,true,false,TaskProcessingMode.TYPE_READ);
}
}
public List<String> getCompletedTaskNames(String workflowId,
Long companyId) {
String hql = "select t.name from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.active=? and t.paused=? order by t.id";
return find(hql, workflowId,companyId,TaskState.COMPLETED.getIndex(),false);
}
/**
* 获得实例中暂停的任务
* @param workflowId
* @param companyId
* @return
*/
public List<WorkflowTask> getPauseTasksByInstance(String workflowId,
Long companyId){
String hql = "from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.paused=?";
return find(hql, workflowId,companyId,true);
}
/**
* 批量移除任务中根据办理人查询当前任务列表
* @param tasks
* @param transactorName
* @param typeId
* @param defCode
* @param wfdId
*/
public void getActivityTasksByTransactorName(Page<WorkflowTask> tasks,Long typeId, String defCode,Long wfdId){
StringBuilder hql = new StringBuilder("select wt ");
hql.append(" from ").append(" WorkflowTask wt,WorkflowInstance wi ").append("where wi.processInstanceId=wt.processInstanceId and wi.processInstanceId=wt.executionId and wi.processState<>? and wt.companyId = ? and ( wt.active=0 or wt.active=4 ) and wt.distributable=? and wt.effective=? ");
List<Object> objs = new ArrayList<Object>();
objs.add(ProcessState.UNSUBMIT);
objs.add(ContextUtils.getCompanyId());
objs.add(false);
objs.add(true);
if(wfdId!=null && wfdId.intValue() != 0){
hql.append("and wi.workflowDefinitionId=? ");
objs.add(wfdId);
}
if(typeId!=null && typeId.intValue() != 0){
hql.append("and wi.typeId = ? ");
objs.add(typeId);
}
if(StringUtils.isNotEmpty(defCode)){
hql.append("and wi.processCode=? ");
objs.add(defCode);
}
hql.append(" order by wt.transactDate desc ");
this.searchPageByHql(tasks, hql.toString(),objs.toArray());
}
/**
* 根据实例集合活动未办理的任务
* @param instanceIds 实例id的集合
* @param taskName 任务名称
* @param recieveUser 委托的受托人登录名
* @param consignor 委托的委托人登录名
* @return
*/
public List<WorkflowTask> getTasksByInstance(List<String> instanceIds,String taskName,String recieveUser,Long recieveId,String consignor,Long consignorId, Long companyId){
StringBuilder hql=new StringBuilder("from WorkflowTask t where t.companyId = ? and ( t.active=0 or t.active=4 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and ((t.trustor = ? and t.trustorId is null) or (t.trustorId is not null and t.trustorId=?)) ");
Object[] objs=new Object[8+instanceIds.size()] ;
if(StringUtils.isNotEmpty(taskName)&&!"0".equals(taskName)){
objs=new Object[9+instanceIds.size()];
}
int i=0;
objs[0]=companyId;
objs[1]=false;
objs[2]=true;
objs[3]=false;
objs[4]=recieveUser;
objs[5]=recieveId;
objs[6]=consignor;
objs[7]=consignorId;
i=8;
if(StringUtils.isNotEmpty(taskName)&&!"0".equals(taskName)){
hql.append("and t.name=? ");
objs[8]=taskName;
i=9;
}
if(instanceIds.size()>0){
hql.append("and (");
}
int j=0;
for(String instanceId:instanceIds){
hql.append(" t.processInstanceId=? ");
if(j<instanceIds.size()-1)hql.append("or ");
objs[i++]=instanceId;
j++;
}
if(instanceIds.size()>0){
hql.append(")");
}
return this.find(hql.toString(), objs);
}
public List<String> getActiveTaskNameWithoutSpecial(String instanceId){
return this.find("select distinct(t.name) from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=?",
instanceId,false,true,false,false);
}
/**
* 根据用户获得自己所有已完成的流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllCompleteTaskGroupNames(Long companyId,String loginName,Long userId){
String hql="select t.groupName,count(t.groupName) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and t.active=? and t.paused=? and t.groupName!=null group by t.groupName";
return find(hql, companyId, loginName,userId,TaskState.COMPLETED.getIndex(),false);
}
/**
* 根据用户获得自己所有已完成的流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllCancelTaskGroupNames(Long companyId,String loginName,Long userId){
String hql="select t.groupName,count(t.groupName) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=?) and t.paused=? and t.groupName!=null group by t.groupName";
return find(hql, companyId, loginName,userId,TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),false);
}
/**
* 根据用户获得自己所有流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllActiveTaskGroupNames(Long companyId,String loginName,Long userId){
String hql="select t.groupName,count(t.groupName) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.groupName!=null group by t.groupName";
return find(hql, companyId, loginName,userId,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
/**
* 根据用户获得自己所有已完成的流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllCompleteTaskCustomTypes(Long companyId,String loginName,Long userId){
String hql="select t.customType,count(t.customType) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and t.active=? and t.paused=? and t.customType!=null group by t.customType";
return find(hql, companyId, loginName,userId,TaskState.COMPLETED.getIndex(),false);
}
/**
* 根据用户获得自己所有已完成的流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllCancelTaskCustomTypes(Long companyId,String loginName,Long userId){
String hql="select t.customType,count(t.customType) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=?) and t.paused=? and t.customType!=null group by t.customType";
return find(hql, companyId, loginName,userId, TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),false);
}
/**
* 根据用户获得自己所有流程名称
* @param companyId
* @param loginName
* @return
*/
public List<Object[]> getAllActiveTaskCustomTypes(Long companyId,String loginName,Long userId){
String hql="select t.customType,count(t.customType) from WorkflowTask t where t.companyId = ? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.visible = true and (t.active=? or t.active=? or t.active=? or t.active=?) and t.paused=? and t.customType!=null group by t.customType";
return find(hql, companyId, loginName,userId,TaskState.DRAW_WAIT.getIndex(), TaskState.WAIT_TRANSACT.getIndex(), TaskState.WAIT_DESIGNATE_TRANSACTOR.getIndex(),TaskState.WAIT_CHOICE_TACHE.getIndex(),false);
}
/**
* 退回功能中需要得到环节名称taskName的最新完成的任务
* @param workflowId
* @param companyId
* @param taskName
* @return
*/
public WorkflowTask getLastCompletedTaskByTaskName(String workflowId,
Long companyId,String taskName) {
String hql = "from WorkflowTask t where t.processInstanceId=? and t.companyId=? and t.active=? and t.name=? and t.paused=? and t.specialTask=? order by t.id desc ";
List<WorkflowTask> tasks= find(hql, workflowId,companyId,TaskState.COMPLETED.getIndex(),taskName,false,false);
if(tasks.size()>0) return tasks.get(0);
return null;
}
/**
* 查询当前环节其它的待办理的任务集合，除当前传过来的任务
* @param workflowId 实例id
* @param taskId 任务id
* @param taskName 任务名称
* @return 任务列表
*/
public List<WorkflowTask> getActivityTasksByNameWithout(String workflowId,Long taskId,String taskName) {
return this.find("from WorkflowTask t where t.processInstanceId = ? and ( t.active=0 or t.active=4 or t.active=6 or t.active=1) and t.distributable=? and t.effective=? and t.paused=? and t.id<>? and t.name=? order by t.createdTime DESC",
workflowId,false,true,false,taskId,taskName);
}
/**
* 根据办理人查找待办理的委托任务
* @param workflowId
* @param transactor
* @return
*/
public List<WorkflowTask> getActivityTrustorTasksByTransactor(String workflowId,String transactor,Long userId,Long taskId) {
return this.find("from WorkflowTask t where t.processInstanceId = ? and t.active=? and t.visible=? and ((t.transactor = ? and t.transactorId is null) or (t.transactorId is not null and t.transactorId=?)) and t.trustor is not null and t.id<>? and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? order by t.createdTime DESC",
workflowId,TaskState.WAIT_TRANSACT.getIndex(),false,transactor,userId,taskId,false,true,false,false);
}
public List<WorkflowTask> getTaskByCode(String code){
return find("from WorkflowTask t where t.code=?", code);
}
/**
* 根据流程实例id获取task列表
* @param companyId
* @param instanceId
* @return
*/
public List<WorkflowTask> getTasksByInstanceId( String instanceId){
return this.find("from WorkflowTask t where t.companyId = ? and t.processInstanceId = ? ",
ContextUtils.getCompanyId(), instanceId);
}
/**
* 根据办理人查询当前实例中的任务
* @param transactor 办理人登录名
* @param workflowId 实例id
* @return
*/
public List<WorkflowTask> getTaskByTransactor(String transactor,String workflowId){
return this.find("from WorkflowTask t where t.processInstanceId = ? and t.visible=? and (t.transactor = ? or t.trustor = ? ) and (t.active<>? and t.active<>? and t.active<>?) and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? order by t.createdTime DESC",
workflowId,false,transactor,transactor,TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false,true,false,false);
}
/**
* 根据办理人查询当前实例中的任务
* @param userId 办理人id
* @param workflowId 实例id
* @return
*/
public List<WorkflowTask> getTaskByTransactor(Long userId,String workflowId){
return this.find("from WorkflowTask t where t.processInstanceId = ? and t.visible=? and ((t.transactorId is not null and t.transactorId=?) or (t.trustorId is not null and t.trustorId=?) ) and (t.active<>? and t.active<>? and t.active<>?) and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? order by t.createdTime DESC",
workflowId,false,userId,userId,TaskState.CANCELLED.getIndex(),TaskState.ASSIGNED.getIndex(),TaskState.HAS_DRAW_OTHER.getIndex(),false,true,false,false);
}
public List<String> getAllTaskTransactors(String workflowId){
return this.find("select t.transactor from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? order by t.createdTime DESC",
workflowId,false,true,false,false);
}
public List<String> getAllTaskTrustors(String workflowId){
return this.find("select t.trustor from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? and t.trustor is not null order by t.createdTime DESC",
workflowId,false,true,false,false);
}
/**
* 查询当前环节的办理人
* @param workflowId 实例id
* @param taskName 任务名称
* @return 办理人列表
*/
public List<String> getTransactorsByName(String workflowId,String taskName) {
return this.find("select t.transactor from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.name=?",
workflowId,false,true,false,taskName);
}
/**
* 查询当前环节的委托人登录名
* @param workflowId 实例id
* @param taskName 任务名称
* @return 委托人列表
*/
public List<String> getTrustorsByName(String workflowId,String taskName) {
return this.find("select t.trustor from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.name=? and t.trustor is not null",
workflowId,false,true,false,taskName);
}
public List<Long> getAllTaskTransactorIds(String workflowId){
return this.find("select t.transactorId from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? and t.transactorId is not null order by t.createdTime DESC",
workflowId,false,true,false,false);
}
public List<Long> getAllTaskTrustorIds(String workflowId){
return this.find("select t.trustorId from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.specialTask=? and t.trustorId is not null order by t.createdTime DESC",
workflowId,false,true,false,false);
}
/**
* 查询当前环节的办理人
* @param workflowId 实例id
* @param taskName 任务名称
* @return 办理人列表
*/
public List<Long> getTransactorIdsByName(String workflowId,String taskName) {
return this.find("select t.transactorId from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.name=? and t.transactorId is not null",
workflowId,false,true,false,taskName);
}
/**
* 查询当前环节的委托人登录名
* @param workflowId 实例id
* @param taskName 任务名称
* @return 委托人列表
*/
public List<Long> getTrustorIdsByName(String workflowId,String taskName) {
return this.find("select t.trustorId from WorkflowTask t where t.processInstanceId = ? and t.distributable=? and t.effective=? and t.paused=? and t.name=? and t.trustorId is not null",
workflowId,false,true,false,taskName);
}
public void deleteTaskByIds(List<Long> ids){
if(ids.size()>0){
StringBuilder taskIdInfo = new StringBuilder();
Object[] values=new Object[ids.size()];
String hql = "delete WorkflowTask t where ";
int i=0;
for(Long taskId:ids){
taskIdInfo.append("t.id=? or ");
values[i]=taskId;
i++;
}
if(taskIdInfo.indexOf("or")>=0)hql +=taskIdInfo.toString().substring(0,taskIdInfo.lastIndexOf("or"));
this.batchExecute(hql, values);
}
}
}