根据任务名称查询任务列表 __qmtw40pukMZGOuCte1x __qmtw40pukMZGOuCte1x published UTF-8 post /duty/task/list json DATE_FORMAT(now(),'%Y-%m-%d %H:%i'), '待执行',if(DATE_FORMAT(t.ITEM_ENDDATE,'%Y-%m-%d %H:%i') < DATE_FORMAT(now(),'%Y-%m-%d %H:%i'),'已完成','进行中')) as item_taskStatus "; }else if(status == "0"){ //待执行 sql += " '待执行' as item_taskStatus "; }else if(status == "1"){ sql += " '执行中' as item_taskStatus "; }else if(status == "2"){ sql += " '已完成' as item_taskStatus "; }else{ sql += " '' as item_taskStatus "; } sql += " from duty.tlk_patrol_tasks t left join duty.tlk_task_types y on t.ITEM_TYPE = y.ID " + "left join duty.tlk_security_zone_plan z on t.ITEM_PLANID = z.id left join duty.tlk_security_action_plan a on t.ITEM_PLANID = a.id " + " where t.item_superviseDepId in " + subGroup + " and t.item_name like '%" + name + "%'" ; if(status == "0"){ //待执行 sql += " and DATE_FORMAT(t.ITEM_STARTDATE,'%Y-%m-%d %H:%i')> DATE_FORMAT(now(),'%Y-%m-%d %H:%i') "; }else if(status == "1"){ sql += " and DATE_FORMAT(t.ITEM_STARTDATE,'%Y-%m-%d %H:%i') <= DATE_FORMAT(now(),'%Y-%m-%d %H:%i') and DATE_FORMAT(t.ITEM_ENDDATE,'%Y-%m-%d %H:%i') >= DATE_FORMAT(now(),'%Y-%m-%d %H:%i') "; }else if(status == "2"){ sql += " and DATE_FORMAT(t.ITEM_ENDDATE,'%Y-%m-%d %H:%i') < DATE_FORMAT(now(),'%Y-%m-%d %H:%i') "; } sql += " limit " + limitFrom + "," + pageSize; var data = queryByDSName("duty",sql); //result.put("sql", sql); result.put("data", data); return result; })()]]>