在线签章 __iKPqh0URJxxxLC6f9vY __WlWHDjZeVnRx021FMJG 1 __iKPqh0URJxxxLC6f9vY default 200 && i<=400){ insql2 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),"; println("insq2---------------"+insq2); }else if(i>400 && i<=600){ insql3 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),"; println("insq3---------------"+insq3); }else if(i>600 && i<=800){ insql4 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),"; println("insql4---------------"+insql4); }else{ insql5 += "('"+moban+"','"+json+"',0,'"+id+"',NOW(),'"+operator+"','"+certificatedate+"'),"; println("insql5---------------"+insql5); } upsql += "'"+id+"'"; upsql += ","; println("upsql---------------"+upsql); } }else{ if(!boolean1){ dupsql2 += "'"+id+"'"; dupsql2 += ","; println("dupsql2---------------"+dupsql2); }else if(!boolean2){ dupsql5 += "'"+id+"'"; dupsql5 += ","; println("dupsql5---------------"+dupsql5); }else if(!boolean3){ dupsql3 += "'"+id+"'"; dupsql3 += ","; println("dupsql3---------------"+dupsql3); }else if(!boolean4){ dupsql4 += "'"+id+"'"; dupsql4 += ","; println("dupsql4---------------"+dupsql4); }else{ dupsql += "'"+id+"'"; dupsql += ","; println("dupsql---------------"+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); println("insql---------------"+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); println("insql2---------------"+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); println("insql3---------------"+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); println("insql4---------------"+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); println("insql5---------------"+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); println("upsql---------------"+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); println("dupsql---------------"+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); println("dupsql2---------------"+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); println("dupsql5---------------"+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); println("dupsql3---------------"+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); println("dupsql4---------------"+dupsql4); } })()]]> 0 0 __iKPqh0URJxxxLC6f9vY 0 false false false false 0 0 0 false 0 0 0 true true