任务反馈-查询任务反馈 __qmtw40pukMZGOuCte1x __qmtw40pukMZGOuCte1x published UTF-8 post /task/select/feedback 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, "+//任务类型 "case t.item_isPatrol when '1' then '是' else '否' end as item_isPatrol, "+//是否巡逻 "t.item_description, "+//任务说明 "r.item_feedback_content, "+//反馈内容 "t.item_name, "+//任务名称 "DATE_FORMAT(r.item_patrol_start_time, '%Y-%m-%d %H:%i:%s') as item_patrol_start_time,"+//巡逻开始时间 "DATE_FORMAT(r.item_patrol_end_time, '%Y-%m-%d %H:%i:%s') as item_patrol_end_time,"+//巡逻结束时间 "r.item_patrol_duration, "+//巡逻时长 "r.item_patrol_route, "+//巡逻路线 "r.item_patrol_location, "+//巡逻点位 "r.item_patrol_photo "+//点位拍照 "from tlk_task_feedback 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.item_user_id='"+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; })()]]>