|
修改提交或待办显示记录数
提交和待办任务中平台默认显示的是8条记录,可以根据需求修改为所需的记录条数,需要修改/BIZ/SA/task/logic/code/dsrc/TaskViewProcedure.java中相关方法的KSQL语句中的limit的值,如下红色字体
提交:
public static Document querySubmitTask(){
String condition = TaskUtils.getCreatorCondition("t", ContextHelper.getPerson().getPersonMembers(), true);
String query = "select t, t.sName, t.sCURL, t.sProcess, t.sActivity, t.sCreateTime, t.sExecutorFName, t.sExecutorNames, t.sEURL, t.sCreatorFName, t.sShortcut, t.sHints, t.sCreatorFID, t.sExecutorFID, t.sKindID " +
" from SA_Task t " +
" where " + condition +
" and (t.sKindID='tkTask' or t.sKindID='tkNotice') " +
" and (t.sTypeID IS NULL or t.sTypeID <> 'WORKREMIND')" +
" and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting') " + //or t.sStatusID='tesTransmited' hcr: 将转发的认为已经完成
" order by t.sCreateTime desc " +
" limit 0,8 ";
return toDOM(KSQL.select(query, null, DATA_MODEL, null));
}
待办:
public static Document queryWaitTask(){
String condition = TaskUtils.getExecutorCondition("t", ContextHelper.getPerson().getPersonMembers(), true);
String query = "select t, t.sName, t.sCURL, t.sProcess, t.sActivity, t.sCreateTime, t.sExecutorFName, t.sExecutorNames, t.sEURL, t.sCreatorFName, t.sShortcut, t.sHints, t.sCreatorFID, t.sExecutorFID, t.sKindID " +
" from SA_Task t " +
" where (t.sKindID='tkTask' or t.sKindID='tkExecutor' or t.sKindID='tkNotice' or t.sKindID IS NULL) " +
" and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting') " +
" and (t.sTypeID IS NULL or t.sTypeID <> 'WORKREMIND')" +
" and " + condition +
" order by t.sCreateTime desc " +
" limit 0,8 ";
return toDOM(KSQL.select(query, null, DATA_MODEL, null));
}
|
|