自动签章定时任务
__WlWHDjZeVnRx021FMJG
__WlWHDjZeVnRx021FMJG
通过待签章列表头部的 自动签章配置按钮决定定时任务能不能自动选中操作
1
2024-10-28T16:43:22.000+08:00
5
34
0
200 && i<=400){
insql2 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),";
}else if(i>400 && i<=600){
insql3 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),";
}else if(i>600 && i<=800){
insql4 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),";
}else{
insql5 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),";
}
upsql += "'"+id+"'";
upsql += ",";
}
}else{
if(!boolean1){
dupsql2 += "'"+id+"'";
dupsql2 += ",";
}else if(!boolean2){
dupsql5 += "'"+id+"'";
dupsql5 += ",";
}else if(!boolean3){
dupsql3 += "'"+id+"'";
dupsql3 += ",";
}else if(!boolean4){
dupsql4 += "'"+id+"'";
dupsql4 += ",";
}else{
dupsql += "'"+id+"'";
dupsql += ",";
}
}
}
}
}else{
return "请先勾选需要签章的证书信息！"
}
if(insql != "INSERT INTO signature_queues (template_url,DATA,STATUS,business_id,createdTime,creator,certificatedate)VALUES"){
insql = insql.substring(0,insql.length-1);
insertByDSName("obpm2_security",insql);
}
if(insql2 != "INSERT INTO signature_queues (template_url,DATA,STATUS,business_id,createdTime,creator,certificatedate)VALUES"){
insql2 = insql2.substring(0,insql2.length-1);
insertByDSName("obpm2_security",insql2);
}
if(insql3 != "INSERT INTO signature_queues (template_url,DATA,STATUS,business_id,createdTime,creator,certificatedate)VALUES"){
insql3 = insql3.substring(0,insql3.length-1);
insertByDSName("obpm2_security",insql3);
}
if(insql4 != "INSERT INTO signature_queues (template_url,DATA,STATUS,business_id,createdTime,creator,certificatedate)VALUES"){
insql4 = insql4.substring(0,insql4.length-1);
insertByDSName("obpm2_security",insql4);
}
if(insql5 != "INSERT INTO signature_queues (template_url,DATA,STATUS,business_id,createdTime,creator,certificatedate)VALUES"){
insql5 = insql5.substring(0,insql5.length-1);
insertByDSName("obpm2_security",insql5);
}
if(upsql != "UPDATE tlk_certificate SET ITEM_last_signatured_processed_result = '',ITEM_signatured_processed_status = 1,ITEM_signatured_operator = '"+operator+"',ITEM_signatured_time = now(),ITEM_CERTIFICATEDATE = IFNULL(ITEM_CERTIFICATEDATE, NOW()),LASTMODIFIED = now() WHERE id in("){
upsql = upsql.substring(0,upsql.length-1);
upsql += ");"
updateByDSName("security_flow",upsql);
}
if(dupsql != "UPDATE tlk_certificate SET ITEM_signatured_processed_status = 3,ITEM_last_signatured_processed_result = '证书信息不全' WHERE id in("){
dupsql = dupsql.substring(0,dupsql.length-1);
dupsql += ");"
updateByDSName("security_flow",dupsql);
}
if(dupsql2 != "UPDATE tlk_certificate SET ITEM_signatured_processed_status = 3,ITEM_last_signatured_processed_result = '身份证信息无效' WHERE id in("){
dupsql2 = dupsql2.substring(0,dupsql2.length-1);
dupsql2 += ");"
updateByDSName("security_flow",dupsql2);
}
if(dupsql5 != "UPDATE tlk_certificate SET ITEM_signatured_processed_status = 3,ITEM_last_signatured_processed_result = '证书信息不全（身份证头像、身份证住址）' WHERE id in("){
dupsql5 = dupsql5.substring(0,dupsql5.length-1);
dupsql5 += ");"
updateByDSName("security_flow",dupsql5);
}
if(dupsql3 != "UPDATE tlk_certificate SET ITEM_signatured_processed_status = 3,ITEM_last_signatured_processed_result = '证书信息不全（身份证住址）' WHERE id in("){
dupsql3 = dupsql3.substring(0,dupsql3.length-1);
dupsql3 += ");"
updateByDSName("security_flow",dupsql3);
}
if(dupsql4 != "UPDATE tlk_certificate SET ITEM_signatured_processed_status = 3,ITEM_last_signatured_processed_result = '证书信息不全（身份证头像）' WHERE id in("){
dupsql4 = dupsql4.substring(0,dupsql4.length-1);
dupsql4 += ");"
updateByDSName("security_flow",dupsql4);
}
})()]]>
2024-10-28T16:43:22.459+08:00
Admin
__LUARuGyySDiHJ1QSx1a
0
0
1
1
0
0
0