|

楼主 |
发表于 2016-11-24 16:57:50
|
显示全部楼层
public static Document submit(){
Map<String, Object> variables = new HashMap<String, Object>();
String condition = TaskUtils.getExecutorCondition("t", ContextHelper
.getPerson().getPersonMembers(), true, variables);
//System.out.println(condition);
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.sExecutorFID like '/%'" +
" and (t.sStatusID='tesReady' or t.sStatusID='tesExecuting') " +
" order by t.sCreateTime desc " +
" limit 0,8 ";
System.out.println(query);
//System.out.println(query);
//System.out.println("222222222222");
return toDOM(KSQL.select(query, variables, DATA_MODEL, null));
} |
|