任务反馈-查询任务回访 __qmtw40pukMZGOuCte1x __qmtw40pukMZGOuCte1x published UTF-8 post /task/select/return 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,"+//任务状态 "p.item_name as item_type, "+//任务类型 "t.item_description, "+//任务说明 "t.item_name, "+//任务名称 "r.item_return_user_name, "+//回访人 "r.item_satisfaction, "+//满意度 "r.item_remake "+//备注 "from tlk_task_return r inner join tlk_patrol_tasks t on t.id = r.item_task_id "+ "left join tlk_point_types p on p.id = t.item_type "+ " where (t.author='"+userid+"' or r.author='"+userid+"') "+whereStr+ " order by r.created desc " var datas = queryByDSName("duty",sql); result.put("data",datas); //result.put("sql",sql); result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; })()]]>