我执勤的-我的驻勤点 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G published UTF-8 post /zhuqin/wo json '"+now+"')"; }else if("未开始".equals(state)){ whereStr += "AND (ITEM_ATTENDANCESTARTDATE <= '"+now+"' and ITEM_ATTENDANCEENDDATE >= '"+now+"')"; }else if("已结束".equals(state)){ whereStr += "AND (ITEM_ATTENDANCEENDDATE < '"+now+"')"; } } } var sql=" select '" + getDomainid() + "' as domainid,att.id," + "att.id as item_attendid,"+//驻勤点id "att.ITEM_ATTENDANCESITENAME,"+//驻勤点名称 "att.ITEM_ATTENDANCESITETYPE,"+//驻勤点类型 "IF(p.item_reporting_time is null,'未报到','已报到') as item_report_state,"+//报到状态 "case att.item_att_type when '0' then '驻勤点' when '1' then '社区警务' when '2' then '内保单位' when '3' then '临保岗点' when '4' then '赛演岗点' end as item_att_type,"+//执勤点类型 "item_project_name,"+//项目名称 "item_project_id,"+//项目id "att.ITEM_ATTENDANCESITEFULLADDRESS,"+//驻勤点详细地址 "att.ITEM_ATTENDANCESTARTDATE,"+//驻勤开始日期 "att.ITEM_ATTENDANCEENDDATE,"+//驻勤结束日期 "att.ITEM_PRINCIPAL,"+//负责人 //"(select item_securityName from att_employee where item_userID=att.ITEM_PRINCIPAL) as ITEM_PRINCIPALNAME,"+//负责人姓名 //"(select item_phone from att_employee where item_userID=att.ITEM_PRINCIPAL) as ITEM_PRINCIPALPHONENO "+//负责人手机号 "ITEM_PRINCIPALNAME,"+//负责人姓名 "ITEM_PRINCIPALPHONENO "+//负责人手机号 " from tlk_attendance_site_base_info att "+ " join tlk_attendance_site_person_info p on p.item_attendanceSiteId=att.id "+ " where p.item_securityId='"+userid+"' "+whereStr+" ORDER BY ITEM_ATTENDANCESTARTDATE desc " ; println("sql===="+sql) var datas = queryByDSName("baibaodunFlow",sql); result.put("data",datas); result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; })()]]>