我的计划
__UD3ubj9EqXgAg9w3fxn
__UD3ubj9EqXgAg9w3fxn
published
UTF-8
post
/bkt/myLearnPlan
json
= now() and process.process = 1) then '已完成' else '未完成' end "+
" end "+
" when '2' then '已取消' end item_release_status "+
"FROM tms.tlk_learnPlan plan LEFT JOIN tms.tlk_company_plan p ON p.item_planid = plan.id LEFT JOIN tms.tlk_learnPlan_test_examinee person ON person.item_learnplan_id = plan.id and person.item_isDelete = '0' and person.item_examinee_id = '"+employeeId+"' "+
"LEFT JOIN (SELECT "+
"ITEM_learnplan_id,"+
"ITEM_examinee_id,"+
"sum(ITEM_process)/count(1) process "+
"FROM tms.tlk_learnPlan_mission_process "+
"WHERE ITEM_ISDELETE = '0' "+
"GROUP BY ITEM_learnplan_id,ITEM_examinee_id) process ON (process.ITEM_learnplan_id = plan.id AND process.ITEM_examinee_id = person.ITEM_examinee_id)"+
"WHERE plan.item_isDelete = '0' AND plan.ITEM_RELEASE_STATUS <> '0' " + whereStr + limitStr;
var data = queryByDSName("tms",sql);
var iter = data.iterator();
var totalSql = "SELECT "+
"count(1) total "+
"FROM tms.tlk_learnPlan plan LEFT JOIN tms.tlk_company_plan p ON p.item_planid = plan.id LEFT JOIN tms.tlk_learnPlan_test_examinee person ON person.item_learnplan_id = plan.id and person.item_isDelete = '0' and person.item_examinee_id = '"+employeeId+"' LEFT JOIN (SELECT ITEM_learnplan_id,ITEM_examinee_id,sum(ITEM_process)/count(1) process FROM tms.tlk_learnPlan_mission_process WHERE ITEM_ISDELETE = '0' GROUP BY ITEM_learnplan_id,ITEM_examinee_id) process ON (process.ITEM_learnplan_id = plan.id AND process.ITEM_examinee_id = person.ITEM_examinee_id) "+
"WHERE plan.item_isDelete = '0' AND plan.ITEM_RELEASE_STATUS <> '0' " + whereStr;
var totalData = queryByDSName("tms",totalSql);
var totalIter = totalData.iterator();
var result = new Packages.java.util.HashMap();
if(iter.hasNext()){
result.put("msg","success");
result.put("code","1");
result.put("data",data);
result.put("pageNo",parseInt(pageIndex));
result.put("pageSize",parseInt(pageSize));
result.put("total",totalIter.next().get("total"));
}else{
result.put("msg","计划不存在");
result.put("code","-1");
}
return result;
})()]]>