根据职员id查询关联驻勤点 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G published UTF-8 post /attendancesite/detail/employee json CURRENT_DATE,'未生效',if(date(b.ITEM_attendanceEndDate) >= CURRENT_DATE,'生效','终止'))) as item_state," //驻勤点状态 + "b.ITEM_serveObjectName,b.ITEM_serveObjectType,b.ITEM_isSignificanceUnit," //服务对象 + "b.ITEM_principal,b.ITEM_principalName,b.ITEM_principalCardType,b.ITEM_principalIdCardNo,b.ITEM_principalPhoneNo,b.ITEM_principalIsCertified," //负责人 + "b.ITEM_contractId,b.ITEM_contractName,b.ITEM_contractState,b.ITEM_contractStartDate,b.ITEM_contractEndDate," //合同 + "b.ITEM_ISAFFILIATION,b.ITEM_REALITYNAME,b.ITEM_REALITYCARDNO,b.ITEM_REALITYPHONE "//实际经营人 + " from tlk_attendance_site_base_info b join tlk_attendance_site_person_info p on b.id = p.ITEM_attendanceSiteId where p.ITEM_securityId = '" + employeeId + "' order by p.CREATED desc limit 1"; var data = queryByDSName("baibaodunFlow",sql); var result = new Packages.java.util.HashMap(); //result.put("sql",sql); result.put("data",data); return result; })()]]>