打卡
__yXF3gCR1rLDkGP9l3Vm
__yXF3gCR1rLDkGP9l3Vm
打卡
detail
{"icon":"/uploads/lib/icon_menu_default.png","icontype":"img"}
07
= DATE(att.ITEM_attendanceStartDate) and CURRENT_DATE <= DATE(att.ITEM_attendanceEndDate) " +
" UNION all " +
"select p.ITEM_PROJECT_END_TIME,att.domainid as item_domain_id " +
" from tlk_event_project p INNER JOIN tlk_attendance_site_base_info att on p.id=att.item_project_id INNER JOIN tlk_attendance_site_person_info u on u.ITEM_attendanceSiteId=att.id " +
" where u.item_securityId= '" + userId + "' and CURRENT_DATE <= DATE(p.ITEM_PROJECT_end_TIME) and att.ITEM_attendanceSiteState != '待完善' and CURRENT_DATE >= DATE(att.ITEM_attendanceStartDate) and CURRENT_DATE <= DATE(att.ITEM_attendanceEndDate) " +
") t order by ITEM_PROJECT_END_TIME limit 1";
println("打卡查询临保项目sql======" + sql);
var datas = queryByDSName("baibaodunflow",sql);
var linbaoOrgId="";
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();
linbaoOrgId= map1.get("item_domain_id");
}
}
var accessToken = getWebUser().getPC_ACCESS_TOKEN(); //获取accessToken
var serverAndPort=getSettingValueByCategoryAndKeyWithExpired("陀螺匠", "tljUrl", 60);
var redirect="/pages/attendance/index";
var url = serverAndPort+"/api/tlj/h5/not/password/login/url?Accesstoken="+accessToken+"&redirect="+redirect ;
if(isNotNull(linbaoOrgId)){
url += "&linbaoOrgId=" + linbaoOrgId;
}
println("url" + url);
return url ;
})()
]]>
public
0
1
false
false
0
false