public String LcdpResourceResourceImpl.callScript(RestJsonWrapperBean wrapper)
[params]
wrapper : {"authorityList":[],"bodyList":[],"extFilter":{},"paramMap":{"f":"{"orderid_IN":"Lab241231004-001","nodeName":"dataReview"}"},"requestJson":"{"p":{"f":{"orderid_IN":"Lab241231004-001","nodeName":"dataRe...
2025-01-03 17:56:38 INFO LcdpResourceServiceImpl user=HZ80853 traceId=1553889676731264 脚本调用 ==>CABusinessProcess.CASampleInspection.server.LcdpCaSampleFolderService.validateEntryMA
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT DELETEFLAG
FROM T_LCDP_RESOURCE_HISTORY WHERE PATH
IN ( ? )
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 DaoMapper.selectByOneColumnValues > Parameters: CABusinessProcess.CASampleInspection.server.LcdpCaSampleFolderService(String)
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 DaoMapper.selectByOneColumnValues < Total: 87
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 LimsOrderTaskResultMapper.selectByCondition ==> Preparing: SELECT T.* FROM (SELECT B.ID ORDERID1, B.SAMPLETIME, B.RESULTSTATUS, B.SAMPLEDOTID, B.MTLID, B.DEVICEID, CASE WHEN B.SAMPLENAME IS NOT NULL THEN B.SAMPLENAME ELSE M.MTLNAME END MTLSAMPLENAME, B.SAMPLENAME, B.PRODUCTTYPE, B.SPEC, C.TESTNAME, D.METHODNAME, E.SAMPLEDOTNAME, M.MTLNAME, A., A.MIDDLEINDEXA AS INDEXSET, F.BATCHNO, F.ISORDERFORM, OT.STATUS, TMI.HISTORICALTRENDMAP, TMI.ERRORTYPE, TMI.ERRORHIGHLIMIT, TMI.MINVALUE, TMI.ACCOUNTSHOW TMIACCOUNTSHOW, TMI.LOWLIMITA TESTLOWLIMITA, TMI.LOWLIMITB TESTLOWLIMITB, TMI.HIGHLIMITA TESTHIGHLIMITA, TMI.HIGHLIMITB TESTHIGHLIMITB, OT.CUPNO, OT.SUBMITTEDTIME, OT.LABORGID, OT.POSTID, OT.POSTAUDITUSERID, INFO.CREATEDBYORGID ENTRUSTORG, INFO.DELIVERPEOPLE, INFO.TESTCATEGORY, INFO.COMPANYID FROM T_LIMS_ORDERTASKRESULT A LEFT JOIN T_LIMS_ORDERTASK OT ON OT.ID = A.ORDERTASKID LEFT JOIN T_LIMS_ORDER B ON A.ORDERID = B.ID LEFT JOIN T_LIMS_TEST C ON A.TESTID = C.ID LEFT JOIN T_LIMS_METHOD D ON A.METHODID = D.ID LEFT JOIN T_LIMS_SAMPLEDOT E ON B.SAMPLEDOTID = E.ID LEFT JOIN T_LIMS_MTL M ON B.MTLID = M.ID LEFT JOIN T_LIMS_TESTMETHODITEM TMI ON TMI.ID = A.TESTMETHODITEMID LEFT JOIN T_LIMS_FOLDER F ON F.ID = A.FOLDERID LEFT JOIN T_LIMS_ORDERFORMINFO INFO ON F.ID = INFO.ID) T WHERE ( ORDERID
= ? ) ORDER BY T.ORDERID1 DESC,T.TESTNAME ASC, T.SORTER ASC, T.ITEMORDERNO ASC, T.REPEATNO ASC
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 LimsOrderTaskResultMapper.selectByCondition > Parameters: Lab241231004-001(String)
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889676731264 LimsOrderTaskResultMapper.selectByCondition < Total: 1
public LcdpResourceDTO LcdpResourceResourceImpl.selectContentByPath(RestJsonWrapperBean wrapper)
[params]
wrapper : {"authorityList":[],"bodyList":[],"extFilter":{},"paramMap":{"resourcePath":"CABusinessProcess.CASampleInspection.page.CommonBusinessAuditPassCAOpinion"},"requestJson":"{"p":{"resourcePath":"CABusinessProcess.CASampl...
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst ==> Preparing: SELECT * FROM ( SELECT ID
, EFFECTVERSION
FROM T_LCDP_RESOURCE WHERE DELETEFLAG
= ? AND PATH
= ? ORDER BY RESOURCENAME
ASC ) T LIMIT 1
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst > Parameters: 0(String), CABusinessProcess.CASampleInspection.page.CommonBusinessAuditPassCAOpinion(String)
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst < Total: 1
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst ==> Preparing: SELECT * FROM ( SELECT ID
, RESOURCEID
, RESOURCENAME
, RESOURCECATEGORY
, CONTENT
, PATH
FROM T_LCDP_RESOURCE_HISTORY WHERE EFFECTFLAG
= ? AND RESOURCEID
= ? ) T LIMIT 1
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst > Parameters: yes(String), 1238888251636001(Long)
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.selectFirst < Total: 1
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageCompMapper.selectByCondition ==> Preparing: SELECT T. FROM T_LCDP_MODULE_PAGE_COMP T WHERE ( MODULEPAGEHISTORYID
= ? ) ORDER BY T.ID DESC
2025-01-03 17:56:38 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageCompMapper.selectByCondition > Parameters: 1553859103537952(Long)
2025-01-03 17:56:39 INFO DynamicThreadPoolExecutor user=system Pool:(size:15 range:15~15 queueSize:0) Config:(min:5 max:20) cpuRatio:0
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageCompMapper.selectByCondition < Total: 5
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageI18nMapper.selectByCondition ==> Preparing: SELECT T.* FROM T_LCDP_MODULE_PAGE_I18N T WHERE ( `MODULEPAGEHISTORYID` = ? ) ORDER BY T.ID DESC
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageI18nMapper.selectByCondition > Parameters: 1553859103537952(Long)
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpModulePageI18nMapper.selectByCondition < Total: 2
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.select ==> Preparing: SELECT `ID` , `LOCALENAME` FROM T_CORE_I18N_CONFIG
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.select > Parameters:
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 DaoMapper.select < Total: 2
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpPageI18nCodeMapper.selectByCondition ==> Preparing: SELECT T.* FROM (SELECT C., R.PATH FROM T_LCDP_PAGE_I18N_CODE C,T_LCDP_RESOURCE R WHERE C.MODULEPAGEID = R.ID) T WHERE ( `MODULEPAGEHISTORYID` = ? ) ORDER BY T.ID DESC
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpPageI18nCodeMapper.selectByCondition > Parameters: 1553859103537952(Long)
2025-01-03 17:56:39 INFO user=HZ80853 traceId=1553889677550464 LcdpPageI18nCodeMapper.selectByCondition < Total: 0
public String LcdpResourceResourceImpl.callScript(RestJsonWrapperBean wrapper)
[params]
wrapper : {"authorityList":[],"bodyList":[["{"id":"1551753664254944"}"]],"extFilter":{},"paramMap":{"nodeName":"dataReview","taskcategory":"MA"},"requestJson":"{"p":{"nodeName":"dataReview","taskcategory":"MA"},"b":...
2025-01-03 17:56:40 INFO LcdpResourceServiceImpl user=HZ80853 traceId=1553889696097152 脚本调用 ==>CABusinessProcess.CASampleInspection.server.LcdpCaSampleFolderService.completeMATask
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT `DELETEFLAG` FROM T_LCDP_RESOURCE_HISTORY WHERE `PATH` IN ( ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues > Parameters: CABusinessProcess.CASampleInspection.server.LcdpCaSampleFolderService(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues < Total: 87
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds ==> Preparing: SELECT `ID` , `ACCEPTEDHOURS` , `ANALYSISAIMS` , `ANALYSISTOOLS` , `AUDITOPINION` , `BACKPUR` , `CARDNAME` , `CASEACCEPT` , `CASEADVICE` , `CONDITIONS` , `CONDITIONWAYS` , `CONTRACTNO` , `CORROSIONCONDITIONS` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CUPNO` , `CUTDIRECTION` , `CUTPOSITION` , `EQUIPTCATEGORY` , `EQUIPTID` , `EXPERIMENTER` , `EXPORTPDFURL` , `FIBEXPERIMENTER` , `FOLDERID` , `GRIDLOCAT` , `GRIDNUMB` , `HASEXPIRED` , `LABORGID` , `LABORGNAME` , `LOTID` , `METHODID` , `METHODVERSIONID` , `METHODVERSIONNO` , `ORDERID` , `ORDERNO` , `ORDERTESTER` , `PARENTID` , `POSTAUDITUSERID` , `POSTAUDITUSERNAME` , `POSTID` , `PREORDER` , `PRETESTER` , `PROFILE` , `QCCATEGORYID` , `QCFLAG` , `REJECTFLAG` , `REMARK` , `REPORTREMARK` , `RESULTSTATUS` , `RETESTFLAG` , `REVIEWENDTIME` , `RUNID` , `SAMPLE` , `SAMPLENUMBER` , `SCHEMEID` , `SCHEMENAME` , `SEPARATE_BATCH` , `SEQNO` , `SHOOTTESTER` , `SHOOTWAYS` , `SOURCETYPE` , `SPEC` , `SPECIALREQ` , `STARTCHECKTIME` , `STATUS` , `SUBCONTRACTITEM` , `SUBMITNODE` , `SUBMITTEDBYID` , `SUBMITTEDBYNAME` , `SUBMITTEDTIME` , `TASKREQUESTNO` , `TESTCONDITIONS` , `TESTCOST` , `TESTFINISHTIME` , `TESTID` , `TESTMETHODELNTMPL` , `TESTMETHODID` , `TESTUSERID` , `TESTUSERNAME` , `TMUNCERTAINTYID` , `UNCERTAINTYVALUE` , `VERSION` , `WAFERID` FROM T_LIMS_ORDERTASK WHERE ID IN ( 1551753664254944 )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds > Parameters:
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds < Total: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds ==> Preparing: SELECT `ID` , `ACCEPTEDHOURS` , `ACCEPTEDTIME` , `ACCUMCYCLE` , `ADDLOTID` , `ADDWAFERID` , `AIMDEC` , `ANALYSISAIMS` , `ANALYSISITEMSPEC` , `ANALYSISTOOLS` , `ANALYSISTYPE` , `ANALYSISTYPEID` , `ANALYZEDSAMPLENUM` , `APPLYER` , `APPLYERNAME` , `APPLYERPHONE` , `APPLYORG` , `APPLYORGID` , `ASSEMBLYSITE` , `ASSIGNUSERID` , `ASSIGNUSERNAME` , `BACKPUR` , `BATCHNO` , `BUDGETCODE` , `CASEACCEPT` , `CASEADVICE` , `CASETYPE` , `CCLISTIDS` , `CCLISTS` , `CCRECORDS` , `CLOSETIME` , `COEXPERIMENTER` , `COMPLETESAMPLE` , `CONFIRM` , `CONFIRMINFO1` , `CONFIRMINFO2` , `CONFIRMINFO3` , `CONFIRMINFO4` , `CONFIRMINFOFOUR` , `CONFORMONE` , `CONFORMTHREE` , `CONFORMTWO` , `CONTRACTSTATUS` , `CORROSIONCONDITIONS` , `COSTOPINON` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CURRENTLEVEL` , `CUSTOMERID` , `CUTDIRECTION` , `DATAINSPECT` , `DATAREVIEWREOPINION` , `DIESIZE` , `DIRECTORUSERS` , `DUTYPHONE` , `ECTOCYST` , `EITHERRELATESPC` , `ENTRUSTADDR` , `ENTRUSTOU` , `ENTRUSTSAMPLENO` , `FAILUREITEM` , `FAILUREMODE` , `FAILURERATE` , `FAILURESPEC` , `FAILUREVALUE` , `FAPALANID` , `FAPLAN` , `FIBFROM` , `FORWARDRECORD` , `FSTATUS` , `HASEXPIRED` , `HASFINDEX` , `HASSENSITIVE` , `INCOMINGCONDIT` , `ISADDITION` , `ISINNERFIB` , `ISINSCYCLEPLUS` , `ISOOSWAFER` , `ISORDERFORM` , `ISPACKAGE` , `ISPASSIVATED` , `ISRELATEFA` , `ISRETENTIONSAMPLE` , `ISSAMPLENO` , `ISSENDEXT` , `ISSTOP` , `LABORGID` , `LABORGNAME` , `LASTPROCESS` , `LIVECUT` , `LOCATESTRUCTINFO` , `LOGINCATEGORY` , `LOOPS` , `LOTID` , `MINISTORUSERS` , `MONITORUSERS` , `MTLID` , `NEEDFIBNODE` , `OOSFOLDERID` , `ORDERNO` , `ORDERTMPLID` , `OTHERDEC` , `OTHERREQUESTLINK` , `OUTDEPARTMENT` , `OUTFOLDERID` , `OUTSOURCE` , `PACKAGETYPE` , `PRIORITYGRADE` , `PROBACKPUR` , `PROCASETYPE` , `PROCESSSTATUS` , `PRODUCTID` , `PRODUCTTYPE` , `PROJECTCODE` , `PRORELIABILITYITEM` , `PSM` , `PUSHOAFLOWUSERLIST` , `PUSHOAMENUID` , `QUALITYCATEGORY` , `QUALITYPROPERTY` , `RAREQUESTNO` (more)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds > Parameters:
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByIds < Total: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT `ID` , `ACCEPTEDHOURS` , `ANALYSISAIMS` , `ANALYSISTOOLS` , `AUDITOPINION` , `BACKPUR` , `CARDNAME` , `CASEACCEPT` , `CASEADVICE` , `CONDITIONS` , `CONDITIONWAYS` , `CONTRACTNO` , `CORROSIONCONDITIONS` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CUPNO` , `CUTDIRECTION` , `CUTPOSITION` , `EQUIPTCATEGORY` , `EQUIPTID` , `EXPERIMENTER` , `EXPORTPDFURL` , `FIBEXPERIMENTER` , `FOLDERID` , `GRIDLOCAT` , `GRIDNUMB` , `HASEXPIRED` , `LABORGID` , `LABORGNAME` , `LOTID` , `METHODID` , `METHODVERSIONID` , `METHODVERSIONNO` , `ORDERID` , `ORDERNO` , `ORDERTESTER` , `PARENTID` , `POSTAUDITUSERID` , `POSTAUDITUSERNAME` , `POSTID` , `PREORDER` , `PRETESTER` , `PROFILE` , `QCCATEGORYID` , `QCFLAG` , `REJECTFLAG` , `REMARK` , `REPORTREMARK` , `RESULTSTATUS` , `RETESTFLAG` , `REVIEWENDTIME` , `RUNID` , `SAMPLE` , `SAMPLENUMBER` , `SCHEMEID` , `SCHEMENAME` , `SEPARATE_BATCH` , `SEQNO` , `SHOOTTESTER` , `SHOOTWAYS` , `SOURCETYPE` , `SPEC` , `SPECIALREQ` , `STARTCHECKTIME` , `STATUS` , `SUBCONTRACTITEM` , `SUBMITNODE` , `SUBMITTEDBYID` , `SUBMITTEDBYNAME` , `SUBMITTEDTIME` , `TASKREQUESTNO` , `TESTCONDITIONS` , `TESTCOST` , `TESTFINISHTIME` , `TESTID` , `TESTMETHODELNTMPL` , `TESTMETHODID` , `TESTUSERID` , `TESTUSERNAME` , `TMUNCERTAINTYID` , `UNCERTAINTYVALUE` , `VERSION` , `WAFERID` FROM T_LIMS_ORDERTASK WHERE `FOLDERID` IN ( ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues > Parameters: Lab241231004(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues < Total: 2
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 LimsProxyApproveConfigMapper.selectByCondition ==> Preparing: SELECT T. FROM T_LIMS_PROXY_APPROVE_CONFIG T WHERE ( `PROXYER` = ? ) AND ( `STATUS` = ? ) ORDER BY T.ID DESC
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 LimsProxyApproveConfigMapper.selectByCondition > Parameters: HZ80853(String), begin(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 LimsProxyApproveConfigMapper.selectByCondition < Total: 0
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds ==> Preparing: UPDATE T_LIMS_FOLDER SET `PROCESSSTATUS` = CASE ID WHEN 'Lab241231004' THEN ? END , `REVIEWENDTIME` = CASE ID WHEN 'Lab241231004' THEN ? END WHERE ID IN ( 'Lab241231004' )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds > Parameters: completed(String), 2025-01-03 17:43:09.0(Timestamp)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds < Updates: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds ==> Preparing: UPDATE T_LIMS_ORDERTASK SET `STATUS` = CASE ID WHEN 1551753664254944 THEN ? END , `SUBMITNODE` = CASE ID WHEN 1551753664254944 THEN ? END , `ACCEPTEDHOURS` = CASE ID WHEN 1551753664254944 THEN ? END , `REVIEWENDTIME` = CASE ID WHEN 1551753664254944 THEN ? END WHERE ID IN ( 1551753664254944 )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds > Parameters: completed(String), postTodo(String), 1.3(String), 2025-01-03 17:56:40.832(Timestamp)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchUpdateByIds < Updates: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert ==> Preparing: INSERT INTO T_LIMS_FOLDER_PROCESS_LOG ( `ID` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `FOLDERID` , `NEXTNODE` , `OPERATOR` , `OPERATORDESC` , `OPERATORID` , `OPERATORNAME` , `PROXYAPPROVER` ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , NULL , NULL , ? , NULL )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert > Parameters: 1553889696416640(Long), HZ80853(String), Zhiming(String), 80000085(String), 分析技术部(String), 2025-01-03 17:56:40.84(Timestamp), Lab241231004$1551753664254944(String), completed(String), dataReview(String), pass(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert < Updates: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT `ID` , `ACCOUNTSHOW` , `ALTERTIME` , `ALTERUSERID` , `ALTERUSERNAME` , `ANLYSAMPLENUM` , `BEGINTIME` , `BR` , `CALCULATE` , `CARBON` , `CH3COOH` , `CONTROLTYPE` , `COST` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CUTDIRECTION` , `CXF` , `D10` , `D25` , `D50` , `D75` , `D90` , `D98` , `D99` , `ENDTIME` , `ENGLISHNAME` , `ERRORSTATUS` , `ERRORVALUE` , `FAILEDREASON` , `FOLDERID` , `GRID` , `H2O2` , `H2SO4` , `H3PO4` , `HASFAILED` , `HCL` , `HCOOH` , `HF` , `HIGHLIMITA` , `HIGHLIMITB` , `HIGHLIMITC` , `HIGHLIMITD` , `HIGHLIMITE` , `HNO3` , `INDEXID` , `ISLOCK` , `ITEMALIASNAME` , `ITEMNAME` , `ITEMORDERNO` , `ITEMTYPE` , `JUDGEMENT` , `KOH` , `LOWLIMITA` , `LOWLIMITB` , `LOWLIMITC` , `LOWLIMITD` , `LOWLIMITE` , `MAEQUIPTID` , `MAEQUIPTNAME` , `METHODID` , `METHODNO` , `MIDDLEINDEXA` , `MIDDLEINDEXB` , `MIDDLEINDEXC` , `MIDDLEINDEXD` , `MIDDLEINDEXE` , `NAOH` , `NH4OH` , `NO2` , `OPERATORGROUP` , `OPERATORID` , `OPERATORNAME` , `ORDERID` , `ORDERTASKID` , `ORDERTMPLID` , `ORIGINALRESULT` , `P100UM` , `P10UM` , `P15UM` , `P20UM` , `P30UM` , `P3UM` , `P40UM` , `P4UM` , `P50UM` , `P5UM` , `P60UM` , `P6UM` , `P70UM` , `P7UM` , `P80UM` , `P8UM` , `P90UM` , `P9UM` , `PARENTID` , `PARENTORDERID` , `QCCATEGORYID` , `R01` , `R02` , `R03` , `R04` , `R05` , `R06` , `R07` , `R08` , `R09` , `R10` , `R11` , `R12` , `R13` , `R14` , `R15` , `R16` , `R17` , `R18` , `R19` , `R20` , `R21` , `R22` , `R23` , `R24` , `R25` , `R26` , `R27` , `R28` , `R29` , `R30` , `R31` , `R32` , `R33` , `R34` , `R35` , `R36` , `R37` , `R38` , `R39` , `R40` , `R41` , `R42` , `R43` , `R44` , `R45` , `R46` , `R47` , `R48` , `R49` , `R50` , `RC` , `REMARK` , `REPEATNO` , `REPEATQTY` , `REPORTRESULT` , `REPORTRESULTSTATUS` , `REPORTSHOW` , `RESULTCATEGORY` , `RESULTINPUTCATEGORY` , `RESULTTIME` , `REVISIONRESULT` , `REVISIONRESULTSTATUS` , `REVISIONRULE` , `RUNID` , `SAMPLEJUDGMENT` , `SCIENTIFICNOTATION` , `SCIENTIFICREPORTRESULT` , `SORTE (more)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues > Parameters: Lab241231004-001(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues < Total: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert ==> Preparing: INSERT INTO T_LIMS_EQUIPTOPERATION ( `ID` , `BEGINTIME` , `CONSUMERTIME` , `CONTENT` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `ENDTIME` , `EQUIPTID` , `OPERATER` , `OPERATIONTYPE` , `ORDERID` , `PROCESSSTATUS` , `PROJECTDEC` , `REMARK` , `STATUS` ) VALUES ( ? , ? , NULL , ? , ? , ? , ? , ? , ? , ? , ? , ? , NULL , ? , ? , ? , NULL , ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert > Parameters: 1553889696588672(Long), 2025-01-03 16:38:57.0(Timestamp), TEM(String), HZ80853(String), Zhiming(String), 80000085(String), 分析技术部(String), 2025-01-03 17:56:40.854(Timestamp), 2025-01-04 16:38:59.0(Timestamp), MA-EQID(String), Zhiming(String), Lab241231004-001(String), draft(String), test(String), Up(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert < Updates: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT `ID` , `CODE` , `CODECATEGORYID` , `CODENAME` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDTIME` , `I18NCODE` , `LASTSUSPENDEDBYID` , `LASTSUSPENDEDBYNAME` , `LASTSUSPENDEDFLAG` , `LASTSUSPENDEDTIME` , `ORDERNO` , `REMARK` , `VERSION` FROM T_CORE_CODE WHERE `CODECATEGORYID` IN ( ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues > Parameters: customSurveyItem(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.selectByOneColumnValues < Total: 4
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert ==> Preparing: INSERT INTO T_CORE_CUSTOM_SURVEY ( `ID` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CUSTOMERADVICE` , `CUSTOMERNAME` , `CUSTOMERORGNAME` , `FOLDERNO` , `PROCESSSTATUS` , `SURVEYDATE` ) VALUES ( ? , ? , ? , ? , ? , ? , NULL , ? , ? , ? , ? , ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert > Parameters: 1553889696637824(Long), HZ80853(String), Zhiming(String), 80000085(String), 分析技术部(String), 2025-01-03 17:56:40.86(Timestamp), Zhiming(String), 分析技术部(String), Lab241231004-001(String), done(String), 2025-01-03(Date)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert < Updates: 1
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert ==> Preparing: INSERT INTO T_CORE_CUSTOM_SURVEY_ITEM ( `ID` , `EVALUATE` , `EVALUATEDATE` , `SURVEYCONTENT` , `SURVEYID` ) VALUES ( ? , NULL , NULL , ? , ? ) , ( ? , NULL , NULL , ? , ? ) , ( ? , NULL , NULL , ? , ? ) , ( ? , NULL , NULL , ? , ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert > Parameters: 1553889696637825(Long), 对LAB服务的满意度(String), 1553889696637824(Long), 1553889696637826(Long), 对LAB测试结果的满意度(String), 1553889696637824(Long), 1553889696637827(Long), 对LIMS系统的满意度(String), 1553889696637824(Long), 1553889696637828(Long), 满意度(String), 1553889696637824(Long)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696097152 DaoMapper.batchInsert < Updates: 4
2025-01-03 17:56:40 INFO LimsPxxFolderServiceImpl user=HZ80853 traceId=1553889696752512 开始发送MA邮件-----------------2025-01-03T17:56:40.874
2025-01-03 17:56:40 INFO LimsPxxFolderServiceImpl user=HZ80853 traceId=1553889696760704 发送给sendFibFiles数据为[]
2025-01-03 17:56:40 INFO LimsPxxFolderServiceImpl user=HZ80853 traceId=1553889696760704 YTE-FIB类型下未找到文件夹附件!
2025-01-03 17:56:40 INFO OaClient user=HZ80853 traceId=1553889696752513 发送给OA数据为{"createdatetime":"2025-01-03 17:56:40","creator":"HZ80853","flowid":"Lab241231004","isremark":"8","nodename":"报检单分析完成提醒","pcurl":"http://lims-uat.pengxinxu.com/module/index/workspaces?loginType=auth2&activeMenuId=20230905003&detail=Lab241231004","receivedatetime":"2025-01-03 17:56:40","receiver":"HZ80853","receivets":"1735898200875","requestname":"【LIMS】MA报检单Lab241231004分析完成提醒 Lab241231004单据已经完成(PC端)","syscode":"lims","viewtype":"0","workflowname":"报检单分析完成提醒"}
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696752512 DaoMapper.selectByIds ==> Preparing: SELECT `ID` , `ACCEPTEDHOURS` , `ACCEPTEDTIME` , `ACCUMCYCLE` , `ADDLOTID` , `ADDWAFERID` , `AIMDEC` , `ANALYSISAIMS` , `ANALYSISITEMSPEC` , `ANALYSISTOOLS` , `ANALYSISTYPE` , `ANALYSISTYPEID` , `ANALYZEDSAMPLENUM` , `APPLYER` , `APPLYERNAME` , `APPLYERPHONE` , `APPLYORG` , `APPLYORGID` , `ASSEMBLYSITE` , `ASSIGNUSERID` , `ASSIGNUSERNAME` , `BACKPUR` , `BATCHNO` , `BUDGETCODE` , `CASEACCEPT` , `CASEADVICE` , `CASETYPE` , `CCLISTIDS` , `CCLISTS` , `CCRECORDS` , `CLOSETIME` , `COEXPERIMENTER` , `COMPLETESAMPLE` , `CONFIRM` , `CONFIRMINFO1` , `CONFIRMINFO2` , `CONFIRMINFO3` , `CONFIRMINFO4` , `CONFIRMINFOFOUR` , `CONFORMONE` , `CONFORMTHREE` , `CONFORMTWO` , `CONTRACTSTATUS` , `CORROSIONCONDITIONS` , `COSTOPINON` , `CREATEDBYID` , `CREATEDBYNAME` , `CREATEDBYORGID` , `CREATEDBYORGNAME` , `CREATEDTIME` , `CURRENTLEVEL` , `CUSTOMERID` , `CUTDIRECTION` , `DATAINSPECT` , `DATAREVIEWREOPINION` , `DIESIZE` , `DIRECTORUSERS` , `DUTYPHONE` , `ECTOCYST` , `EITHERRELATESPC` , `ENTRUSTADDR` , `ENTRUSTOU` , `ENTRUSTSAMPLENO` , `FAILUREITEM` , `FAILUREMODE` , `FAILURERATE` , `FAILURESPEC` , `FAILUREVALUE` , `FAPALANID` , `FAPLAN` , `FIBFROM` , `FORWARDRECORD` , `FSTATUS` , `HASEXPIRED` , `HASFINDEX` , `HASSENSITIVE` , `INCOMINGCONDIT` , `ISADDITION` , `ISINNERFIB` , `ISINSCYCLEPLUS` , `ISOOSWAFER` , `ISORDERFORM` , `ISPACKAGE` , `ISPASSIVATED` , `ISRELATEFA` , `ISRETENTIONSAMPLE` , `ISSAMPLENO` , `ISSENDEXT` , `ISSTOP` , `LABORGID` , `LABORGNAME` , `LASTPROCESS` , `LIVECUT` , `LOCATESTRUCTINFO` , `LOGINCATEGORY` , `LOOPS` , `LOTID` , `MINISTORUSERS` , `MONITORUSERS` , `MTLID` , `NEEDFIBNODE` , `OOSFOLDERID` , `ORDERNO` , `ORDERTMPLID` , `OTHERDEC` , `OTHERREQUESTLINK` , `OUTDEPARTMENT` , `OUTFOLDERID` , `OUTSOURCE` , `PACKAGETYPE` , `PRIORITYGRADE` , `PROBACKPUR` , `PROCASETYPE` , `PROCESSSTATUS` , `PRODUCTID` , `PRODUCTTYPE` , `PROJECTCODE` , `PRORELIABILITYITEM` , `PSM` , `PUSHOAFLOWUSERLIST` , `PUSHOAMENUID` , `QUALITYCATEGORY` , `QUALITYPROPERTY` , `RAREQUESTNO` (more)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696752512 DaoMapper.selectByIds > Parameters:
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696752512 DaoMapper.selectByIds < Total: 1
public String LcdpResourceResourceImpl.callScript(RestJsonWrapperBean wrapper)
[params]
wrapper : {"authorityList":[],"bodyList":[],"extFilter":{},"paramMap":{"s":"50","qf":"{"orderid_CISC":"Lab241231004"}","f":"{"TASKCATEGORY_SEQ":"MA","status_SEQ":"dataReview"}","n":"1","o":"[]"},"requestJson":"{"p":{...
2025-01-03 17:56:40 INFO LcdpResourceServiceImpl user=HZ80853 traceId=1553889696883584 脚本调用 ==>CABusinessProcess.CASampleInspection.server.LcdpCaSampleOrderTaskService.selectPaginationData
Exception in thread "dynamic-pool-thread-435" java.lang.NullPointerException
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:769)
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:728)
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:705)
at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:733)
at org.springframework.mail.javamail.MimeMessageHelper.setTo(MimeMessageHelper.java:619)
at com.sunwayworld.lims.framework.mail.LimsMailHelper.sendHtmlMail(LimsMailHelper.java:44)
at com.sunwayworld.pxx.lims.module.sp.folder.service.impl.LimsPxxFolderServiceImpl.sendMAEmail(LimsPxxFolderServiceImpl.java:2597)
at com.sunwayworld.pxx.lims.module.sp.folder.service.impl.LimsPxxFolderServiceImpl.lambda$completeMATask$150(LimsPxxFolderServiceImpl.java:1803)
at com.sunwayworld.framework.executor.core.TraceRunnable$1.run(TraceRunnable.java:91)
at com.sunwayworld.lims.framework.log.LogUtils.lambda$decorate$0(LogUtils.java:29)
at com.sunwayworld.framework.executor.core.TraceRunnable$1.run(TraceRunnable.java:91)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 DaoMapper.selectByOneColumnValues ==> Preparing: SELECT `DELETEFLAG` FROM T_LCDP_RESOURCE_HISTORY WHERE `PATH` IN ( ? )
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 DaoMapper.selectByOneColumnValues > Parameters: CABusinessProcess.CASampleInspection.server.LcdpCaSampleOrderTaskService(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 DaoMapper.selectByOneColumnValues < Total: 87
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 LcdpCaSampleOrderTaskMapper.selectByCondition ==> Preparing: SELECT COUNT(1) QTY_ FROM ( SELECT T.* FROM (SELECT A., B.SAMPLENAME, B.STATUS as FSTATUS, D.TESTNAME, C.ACCEPTEDTIME, C.ASSIGNUSERID, C.ASSIGNUSERNAME, C.REQUESTNO, C.APPLYER, C.APPLYERNAME, C.APPLYORG, C.NEEDFIBNODE, C.PRIORITYGRADE, C.TASKCATEGORY, C.ANALYSISTYPE, C.PROCESSSTATUS, C.TESTGROUP, C.TECHNOLOGY, C.LASTPROCESS, C.HASSENSITIVE, C.TESTSAMPLENO, C.CREATEDBYID FOLDERCREATEDBYID, C.CREATEDTIME FOLDERCREATEDTIME, C.LotID as FOLDERLOT, C.PRODUCTID, (case when c.TESTGROUP = 'MA-SEM' then C.waferid else a.waferid end) MAWAFER, C.backpur as FOLDERBACKPUR , C.LASTPROCESS as FOLDERLAST , C.CCLISTIDS, C.ISSENDEXT, C.MONITORUSERS, C.MINISTORUSERS, C.DIRECTORUSERS, C.APPLYORGID, concat(A.sample,concat('-' , A.seqno)) as sampleseqno FROM T_LIMS_ORDERTASK A LEFT JOIN T_LIMS_TEST D ON A.TESTID = D.ID LEFT JOIN T_LIMS_ORDER B ON A.ORDERID = B.ID LEFT JOIN T_LIMS_FOLDER C ON A.FOLDERID = C.ID ) T WHERE ( `STATUS` = ? ) AND ( `TASKCATEGORY` = ? ) AND ( UPPER(`ORDERID`) LIKE CONCAT('%', ?, '%') ) ) T
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 LcdpCaSampleOrderTaskMapper.selectByCondition ==> Parameters: dataReview(String), MA(String), LAB241231004(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 LcdpCaSampleOrderTaskMapper.selectByCondition ==> Preparing: SELECT * FROM ( SELECT S_. FROM ( SELECT T.* FROM (SELECT A., B.SAMPLENAME, B.STATUS as FSTATUS, D.TESTNAME, C.ACCEPTEDTIME, C.ASSIGNUSERID, C.ASSIGNUSERNAME, C.REQUESTNO, C.APPLYER, C.APPLYERNAME, C.APPLYORG, C.NEEDFIBNODE, C.PRIORITYGRADE, C.TASKCATEGORY, C.ANALYSISTYPE, C.PROCESSSTATUS, C.TESTGROUP, C.TECHNOLOGY, C.LASTPROCESS, C.HASSENSITIVE, C.TESTSAMPLENO, C.CREATEDBYID FOLDERCREATEDBYID, C.CREATEDTIME FOLDERCREATEDTIME, C.LotID as FOLDERLOT, C.PRODUCTID, (case when c.TESTGROUP = 'MA-SEM' then C.waferid else a.waferid end) MAWAFER, C.backpur as FOLDERBACKPUR , C.LASTPROCESS as FOLDERLAST , C.CCLISTIDS, C.ISSENDEXT, C.MONITORUSERS, C.MINISTORUSERS, C.DIRECTORUSERS, C.APPLYORGID, concat(A.sample,concat('-' , A.seqno)) as sampleseqno FROM T_LIMS_ORDERTASK A LEFT JOIN T_LIMS_TEST D ON A.TESTID = D.ID LEFT JOIN T_LIMS_ORDER B ON A.ORDERID = B.ID LEFT JOIN T_LIMS_FOLDER C ON A.FOLDERID = C.ID ) T WHERE ( `STATUS` = ? ) AND ( `TASKCATEGORY` = ? ) AND ( UPPER(`ORDERID`) LIKE CONCAT('%', ?, '%') ) ORDER BY T.ID ) S_ LIMIT 0,50) R_
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 LcdpCaSampleOrderTaskMapper.selectByCondition > Parameters: dataReview(String), MA(String), LAB241231004(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889696883584 LcdpCaSampleOrderTaskMapper.selectByCondition < Total: 0
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889697219456 CoreFileMapper.selectByCondition ==> Preparing: SELECT T. FROM T_CORE_FILE T WHERE TARGETID = ? AND ( `PARENTID` IS NULL ) ORDER BY T.ID
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889697219456 CoreFileMapper.selectByCondition > Parameters: T_LIMS_ORDERTASK$null(String)
2025-01-03 17:56:40 INFO user=HZ80853 traceId=1553889697219456 CoreFileMapper.selectByCondition < Total: 0
2025-01-03 17:56:40 INFO OaClient user=HZ80853 traceId=1553889696752513 发送给OA返回数据为{"syscode":"lims","operResult":"1","dataType":"WfData","operType":"Check","message":"接收流程数据【【LIMS】MA报检单Lab241231004分析完成提醒 Lab241231004单据已经完成(PC端)】,【HZ80853】——接收人存在,接收待阅成功"}