超时未打卡异常
__qmtw40pukMZGOuCte1x
__qmtw40pukMZGOuCte1x
任务结束人员存在未打卡点位异常
1
2025-07-06T12:45:39.000+08:00
1
546
0
= t.ITEM_STARTDATE and a.created_time <= t.ITEM_ENDDATE " +
" where t.ITEM_ENDDATE >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 1 HOUR) and t.ITEM_ENDDATE < CURRENT_TIMESTAMP " +
" and a.tenant_employee_id is null) x join duty.tlk_patrol_points y on x.pid = y.id"
var webUser = getWebUser();
var employeeIdArr = [];
var datas = queryByDSName("duty",sql);
if(datas!=null){
/**var docProc = getDocumentProcess();
var formProc = getFormProcess();
var form = formProc.doView("__vqCb7Gk5VYRtDCTlKaO");
var docArr = new Packages.java.util.ArrayList();*/
var insertSql = "insert into duty.tlk_task_employee_abnormal_records(LASTMODIFIED,CREATED,FORMID,APPLICATIONID,ITEM_TASKID,ITEM_EMPLOYEEID,ITEM_TYPE,ITEM_DETAIL,ITEM_OCCUPATIONTYPE,ITEM_LATITUDE,ITEM_LONGITUDE,id) values ";
for(var iterator = datas.iterator();iterator.hasNext();){
var did = Packages.cn.myapps.common.util.SequenceGenerator.getSequence() + "--__vqCb7Gk5VYRtDCTlKaO";
insertSql += "("
var map1 = iterator.next();//取值
var empId= map1.get("ITEM_EMPLOYEEID");
var taskId= map1.get("tid");
var pointName= map1.get("pointName");
var occuType= map1.get("ITEM_OCCUPATIONTYPE");
var lat= map1.get("ITEM_ATTENDANCESITELATITUDE");
var lon= map1.get("ITEM_ATTENDANCESITELONGITUDE");
/**var doc = docProc.doNew(form,webUser,createParamsTable());
doc.findItem("taskId").setValue(taskId);
doc.findItem("employeeId").setValue(empId);
doc.findItem("type").setValue("超时未打卡");
doc.findItem("detail").setValue(pointName);
doc.findItem("occupationType").setValue(occuType);
doc.findItem("latitude").setValue(lat);
doc.findItem("longitude").setValue(lon);
docArr.add(doc);*/
insertSql += "CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'__vqCb7Gk5VYRtDCTlKaO','__qmtw40pukMZGOuCte1x','" + taskId + "','" + empId + "','超时未打卡','" +
pointName + "','" + occuType + "','" + lat + "','" + lon + "','" + did + "'"
insertSql += ")";
if(iterator.hasNext()){
insertSql += ",";
}
}
insertByDSName("duty",insertSql);
/**if(docArr.size() > 0){
docProc.doCreate(docArr);
}*/
}
})()]]>
2025-07-06T12:45:39.000+08:00
admin
Ai6hllhNjS2ull9TKGb
0
0
1
1
0
0
0