4 IKL M N OP QR ST UV WX YZ S[a bcde Kf g hi j kl(m K no p q r s t uv wx yz { %|} ~  / / / /    O n  J O OK  SK UK WK YK [K ]  Ir  K K S S S S S S S S S S S S S S S S S S S S   S S ] S S S S S S S S S S S S S S S U U U U U U U U U U U U U  W W W W W W W W W W Y Y Y Y Y Y Y Y Y  Y + ,20.4  k  Z   logLorg/slf4j/Logger; jdbcTemplate,Lorg/springframework/jdbc/core/JdbcTemplate;RuntimeVisibleAnnotations8Lorg/springframework/beans/factory/annotation/Autowired;8Lorg/springframework/beans/factory/annotation/Qualifier;valuegovernmentJdbcTemplateDNLjava/lang/String;4Lorg/springframework/beans/factory/annotation/Value;${myapps.nxgjApi.DN}gjUrl${myapps.nxgjApi.gjurl}tokenUrl${myapps.nxgjApi.tokenUrl} NX_CLIENTID${myapps.nxgjApi.NX_CLIENTID} NX_SECRETID${myapps.nxgjApi.NX_SECRETID}()VCodeLineNumberTableLocalVariableTablethis;Lcom/bcxin/backend/service/impl/SecuritySevicekServiceimpl;getSql()Ljava/lang/String;sqlexecuteSecuritySeviceK collectionLjava/util/Collection;LocalVariableTypeTableMLjava/util/Collection;>; StackMapTablegetToken jsonObject1!Lcom/alibaba/fastjson/JSONObject;tokenjsonret jsonObjectegjPostV(Lcom/alibaba/fastjson/JSONObject;Ljava/lang/String;)Lcom/alibaba/fastjson/JSONObject; jsonObjectTwoMethodParameters upDateById'(Ljava/lang/String;Ljava/lang/String;)VidmoduleformNamegetPoliceNameById6(Ljava/lang/String;)Lcom/bcxin/backend/pojo/PoliceDto; policeDto"Lcom/bcxin/backend/pojo/PoliceDto;eLjava/lang/Exception;lambda$executeSecuritySeviceK$0(Ljava/util/Map;)VgjJsonmapLjava/util/Map;json2list1Ljava/util/List;list2list3 timestamptimeLjava/lang/Long;sign upProAccept$Lcom/bcxin/backend/pojo/UpProAccept; upProProcess%Lcom/bcxin/backend/pojo/UpProProcess; upProResult$Lcom/bcxin/backend/pojo/UpProResult; upProMaterial&Lcom/bcxin/backend/pojo/UpProMaterial;upProSpecialProcedure.Lcom/bcxin/backend/pojo/UpProSpecialProcedure;simpleDateFormatLjava/text/SimpleDateFormat; policeName departName7Ljava/util/List;@Ljava/util/List;8Ljava/util/List; SourceFileSecuritySevicekServiceimpl.java(Lorg/springframework/stereotype/Service;  select * from ( select id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON ,'保安服务许可申请' as Type, '无' as item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_TEMPLATERARFILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_securitysevicek where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' union SELECT id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON,'许可证项目法人变更' as Type ,'无' as item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_FILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_legalchangek where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' UNION SELECT id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON,'自行招用保安员单位备案' as Type,item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_FILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_recruitment where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' union SELECT id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON,'保安公司设立分公司备案' as Type,item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_TEMPLATERARFILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_establish where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' union SELECT id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON,'外省保安跨区服务设立分公司备案' as Type,item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_TEMPLATERARFILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_crossr where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' union SELECT id,FORMID,created,lastmodified,AUDITUSER,ITEM_COMPANYNAME,ITEM_AUDITSTATUS,ITEM_REJECTREASON,'保安培训单位备案' as Type ,'无' as item_creditCode,TimeStampDiff(DAY,CREATED,LASTMODIFIED)+2 as timeL,replace(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(ITEM_TEMPLATERARFILE,",\"path\":\"",-1),'\"',1),'\\',''),'/obpm/api/runtime','') as file from tlk_securitytrainings where ITEM_AUDITSTATUS in('0','1') and item_SyncStatus is null and created >'2021-01-01' ) b limit 20   ! 3查询数据库securityFlow，符合条件人数:{} "#$ %&' ()* +, -.BootstrapMethods/01 234 56com/alibaba/fastjson/JSONObjectclientId 78secretId 9 :;java/lang/StringBuilder< => ?@ ?A B CD EF GHsucc I;java/lang/Boolean JK LMdata NH EO Authorization PQcn/hutool/http/HttpRequest RO STU R V#保安服务许可申请 W,许可证项目法人变更!自行招用保安员单位备案!保安公司设立分公司备案-外省保安跨区服务设立分公司备案保安培训单位备案tlk_securitysevicektlk_legalchangektlk_recruitment tlk_establish tlk_crossrtlk_securitytrainings formName-->{} update % set item_SyncStatus = 1 where ID= '' XYSELECT u.name as policeName,u.id as policeId,d.name as departName from obpm2_security.t_user u join obpm2_security.t_department d on u.DEFAULTDEPARTMENT=d.id where u.id= ? Z[\ ]^java/lang/Object3org/springframework/jdbc/core/BeanPropertyRowMapper com/bcxin/backend/pojo/PoliceDto _ `ajava/lang/Exceptionjava/util/ArrayList %b|"com/bcxin/backend/pojo/UpProAccept#com/bcxin/backend/pojo/UpProProcess"com/bcxin/backend/pojo/UpProResult$com/bcxin/backend/pojo/UpProMaterial,com/bcxin/backend/pojo/UpProSpecialProcedurejava/text/SimpleDateFormatyyyy-MM-dd HH:mm:ss ^ AUDITUSER cd  e f无 g^ h^ i^ j^1 k^640000 l^ m^0 n^I o^ p^ nxjgjg_bagl q^ r^timeL s^ t^5 u^ v^ w^许可备案管理 x^ y^item_creditCode z^createdjava/time/LocalDateTime{ |} ~ ^ ^ ~ ^ITEM_COMPANYNAME ^ ^ ^ LASTMODIFIED ^ ^ ^ ^Type ^FORMID ^ ^ ^ ^ ^ ^ ^办结 ^ ^ ^ ^ ^ ^ , ^ ^ITEM_REJECTREASON ^ITEM_AUDITSTATUS ^2 ^ ^ 材料归集 ^ ^file ^tskId body参数:{}resbody ; 数据token:{}  gjJson接口参数:{} 操作成功msg 9com/bcxin/backend/service/impl/SecuritySevicekServiceimpl 0com/bcxin/backend/service/SecuritySevicekServicejava/util/Collectionjava/lang/String java/util/Mapjava/util/Listjava/lang/Long*org/springframework/jdbc/core/JdbcTemplate queryForList$(Ljava/lang/String;)Ljava/util/List;size()Ijava/lang/IntegervalueOf(I)Ljava/lang/Integer;org/slf4j/Loggererror'(Ljava/lang/String;Ljava/lang/Object;)V$org/springframework/util/ObjectUtilsisEmpty(Ljava/lang/Object;)Zstream()Ljava/util/stream/Stream; (Ljava/lang/Object;)V acceptZ(Lcom/bcxin/backend/service/impl/SecuritySevicekServiceimpl;)Ljava/util/function/Consumer;java/util/stream/StreamforEach (Ljava/util/function/Consumer;)Vput8(Ljava/lang/String;Ljava/lang/Object;)Ljava/lang/Object;%com/bcxin/backend/utils/SMEncryptUtil sm3Encrypt&(Ljava/lang/String;)Ljava/lang/String;java/lang/SystemcurrentTimeMillis()Jappend(J)Ljava/lang/StringBuilder;-(Ljava/lang/String;)Ljava/lang/StringBuilder;toString toJSONStringcn/hutool/http/HttpUtilpost8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; parseObject5(Ljava/lang/String;)Lcom/alibaba/fastjson/JSONObject; getString getObject7(Ljava/lang/String;Ljava/lang/Class;)Ljava/lang/Object; booleanValue()Z getJSONObject0(Ljava/lang/String;)Lcn/hutool/http/HttpRequest;header8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;bodyexecute()Lcn/hutool/http/HttpResponse;cn/hutool/http/HttpResponsehashCodeequalsupdate(Ljava/lang/String;)IoutLjava/io/PrintStream;java/io/PrintStreamprintln(Ljava/lang/String;)V(Ljava/lang/Class;)VqueryForObjectb(Ljava/lang/String;[Ljava/lang/Object;Lorg/springframework/jdbc/core/RowMapper;)Ljava/lang/Object;(J)Ljava/lang/Long;get&(Ljava/lang/Object;)Ljava/lang/Object; getPoliceName getDepartName setApplyTypesetApplyerNamesetApplyerPageCodesetApplyerPageTypesetApplyerType setAreaIdsetCatalogCode setIsItemBasesetCdOperationsetContractMobile setDataSourcesetProjectTypesetPromiseTimesetTaskVersionsetPcc setOrgName setSys_lev setSys_namesetHandleUserName setOrgCode"java/time/format/DateTimeFormatter ofPattern8(Ljava/lang/String;)Ljava/time/format/DateTimeFormatter;format8(Ljava/time/format/DateTimeFormatter;)Ljava/lang/String; setAcceptDate setApplyDate&(Ljava/lang/Object;)Ljava/lang/String; setCdTimesetEnterpriseNamesetLocalProjectNo setProjectNosetPromiseDate setRowGuidsetCompanyCodesetHandleUserId setTaskName setTaskCodesetTaskHandleItem setFileId setModel_idsetLocalItemCodesetLocalTaskCodesetHandleExplainsetProcessNamesetIsNeedServicesetEventEndTime setEventNamesetEventStartTime setProcessIdaddsetIsDeliveryResults setResultDatesetResultExplain setResultType setGetTypesetMaterialAttachNamesetMaterialName setRemarksetUrl sm4Encrypt$org/springframework/util/StringUtilsorg/slf4j/LoggerFactory getLogger%(Ljava/lang/Class;)Lorg/slf4j/Logger;  "java/lang/invoke/LambdaMetafactory metafactoryLookup InnerClasses(Ljava/lang/invoke/MethodHandles$Lookup;Ljava/lang/String;Ljava/lang/invoke/MethodType;Ljava/lang/invoke/MethodType;Ljava/lang/invoke/MethodHandle;Ljava/lang/invoke/MethodType;)Ljava/lang/invoke/CallSite;%java/lang/invoke/MethodHandles$Lookupjava/lang/invoke/MethodHandles!Is s s s s s /* =L+ 5BA**L+ + ++ * K LP/Q@A 5  5@%LYM,*W,*W,YW*, !N-":#$W#%&%'():*$L+2   $ @ L R Zlu}>u| tL3R- }      '*+,-,./+ 012N-":$4'' ' $  )N,:63`JW)z6YZ |:C.jFfW45V6P65F6@7566085&6 956:56I%+17=C;N!N?N @NA- YB-C+D:*EWJ%&()+,./124578<=>(@4)))& H   & 0FNG-H*-IY+SJYKLMKM:M, '*NIJ L'O*M,N.P>',00.-)*      W;YMYNOYP:OYP:OYP:Y:Q:Y*R*R: SYT: UYV: WYX: YYZ: [Y\:]Y^_:::+`a'*+`abc:d:e: fg fh fi fj kl mn mo pq rs ft uv kw +xa+xabfy kz {| f} k~  f +a+abf +a+a^ +a+a^  +a+abf +a+ab +a+ab +a+a^ +a+ab +a+abf +`a+`abf +ab +a+ab +a+ab +a+ab +a+ab +a+ab +a+ab r  u f  p +a+a^ k +a+a^ f +a+ab +a+ab +a+ab W r  u p f +a+ab +a+a^ +a+abf +a+abf +a+ab r Q u  f  +a+ab f +a+ab +Źa%Y*ƶ+Źabf W,*W, W,W,+a+abW, W,W, W,W,W, -, ѶW*: ԚV*-: #%&%',ض$5*+ab+abٱpSTUV"W+ZB[J\v_acegimnopqrsxyz{|} ~")07W^ev}/Nm"A`ARq 1Qq<FQZc :J ;;!"3+#"$%"&%+'%B(J)*v+ ,- ./ 01 23 456789h "$:"&;+'< BH =  >>> ? @ABCDE  n@ =  >>> ? @ABCDE  @ \@ =  >>> ? @ABCDE  @ \@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ e@ =  >>> ? @ABCDE  @ e@ =  >>> ? @ABCDE  @ i@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ e@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ m@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ ]@ =  >>> ? @ABCDE  @ TA =  >>> ? @ABCDE  A lA =  >>> ? @ABCDE  A NA =  >>> ? @ABCDE  A ]A =  >>> ? @ABCDE  A ]A =  >>> ? @ABCDE  A ]A =  >>> ? @ABCDE  A yB =  >>> ? @ABCDE  B ]B =  >>> ? @ABCDE  B eB =  >>> ? @ABCDE  B ]B =  >>> ? @ABCDE  B ]B =  >>> ? @ABCDE  B ]B =  >>> ? @ABCDE  B PC =  >>> ? @ABCDE  C dC =  >>> ? @ABCDE  C qC =  >>> ? @ABCDE  C E =  >>> ? @ABCDE     =  >>> ? @ABCDE    F !G! ڸ۳HIJ \ ]^_`