From d4a4ce824f3b2f3a335a3ad8e8c9efb3b37d630f Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期四, 04 五月 2023 08:59:14 +0800
Subject: [PATCH] backup

---
 force-app/main/default/classes/updateESignBatch.cls | 1285 +++++++++++++++------------------------------------------
 1 files changed, 343 insertions(+), 942 deletions(-)

diff --git a/force-app/main/default/classes/updateESignBatch.cls b/force-app/main/default/classes/updateESignBatch.cls
index 05488e2..8862e8d 100644
--- a/force-app/main/default/classes/updateESignBatch.cls
+++ b/force-app/main/default/classes/updateESignBatch.cls
@@ -1,4 +1,4 @@
-global class updateESignBatch implements Database.Batchable < sObject > , Database.Stateful {
+global class updateESignBatch implements Database.Batchable<sObject>, Database.Stateful {
     //鐢靛瓙绛炬敹鍗�-绛炬敹鍗曞綍鍏ヨ〃鏇存柊绛炬敹鍗�  绮剧悽鎶�鏈� wql 2020-09-25 start
     /*
     鈶犳甯告墽琛� Database.executeBatch(new updateESignBatch(), 20);
@@ -29,18 +29,17 @@
     //瀛樻斁闇�瑕佹洿鏂扮殑绛炬敹鍗昳d
     private String id;
     //瀛樻斁闇�瑕佹洿鏂扮殑涓�浜涚鏀跺崟
-    private List < String > ids;
+    private List<String> ids;
     //瀛樻斁宸茬粡鏈�缁堢姸鎬佺殑flag
     private Boolean flag;
     //鐢ㄤ簬鎵цbatch鍚屾椂璁板綍鏃ュ織淇℃伅
     private BatchIF_Log__c iflog;
-    global List < String > emailMessages = new List < String > ();
+    global List<String> emailMessages = new List<String>();
     global Integer totalCount = 0; // 鎬讳欢鏁�
     global Integer failedCount = 0; //澶辫触浠舵暟
     global Boolean ManualExecution_Identification = false;
     //榛樿璺戞墍鏈夌鏀跺崟
     global updateESignBatch() {
-
         iflog = new BatchIF_Log__c();
         iflog.Type__c = 'ESignBatch';
         iflog.Is_Error__c = 0;
@@ -75,7 +74,7 @@
         // insert iflog;
     }
     //鎵归噺鏇存柊绛炬敹鍗�
-    global updateESignBatch(List < String > ids) {
+    global updateESignBatch(List<String> ids) {
         //鎵嬪姩鏍囪瘑缃垚true
         this.ManualExecution_Identification = true;
         this.ids = ids;
@@ -88,7 +87,6 @@
     }
     //鏇存柊鏌愪竴鏉$殑绛炬敹鍗�
     global updateESignBatch(String id) {
-
         //鎵嬪姩鏍囪瘑缃垚true
         this.ManualExecution_Identification = true;
         system.debug('鎵嬪姩浼犲弬1锛�' + ManualExecution_Identification);
@@ -114,7 +112,7 @@
         // insert iflog;
     }
     //鎵归噺鏇存柊宸插鐞嗙殑绛炬敹鍗�
-    global updateESignBatch(List < String > ids, boolean flag) {
+    global updateESignBatch(List<String> ids, boolean flag) {
         //鎵嬪姩鏍囪瘑缃垚true
         this.ManualExecution_Identification = true;
         this.ids = ids;
@@ -138,9 +136,11 @@
             // 濡傛灉鍝熷悓鍚嶇殑Batch璁″垝鍒犻櫎宸插瓨鍦ㄧ殑璁″垝閲嶆柊璁剧疆
             if (haveError) {
                 haveError = false;
-                for (CronTrigger ct : [SELECT Id, CronJobDetailId, CronExpression, CronJobDetail.Name
-                                       FROM CronTrigger
-                                       WHERE CronJobDetail.Name = :scB.scName]) {
+                for (CronTrigger ct : [
+                    SELECT Id, CronJobDetailId, CronExpression, CronJobDetail.Name
+                    FROM CronTrigger
+                    WHERE CronJobDetail.Name = :scB.scName
+                ]) {
                     System.abortJob(ct.Id);
                 }
                 try {
@@ -202,7 +202,7 @@
             if (spafter != null && String.isNotBlank(spafter)) {
                 b.scName = baseName + '005';
                 b.scTime = spafter + ' ' + day + ' ' + month + ' ? ' + year;
-                
+
                 // system.schedule(sJobame,spafter + ' ' + day + ' ' + month + ' ? ' + year, new AgencyShareUpdateBatchSchedule());
                 return b;
             } else {
@@ -242,164 +242,139 @@
             b.scName = baseName + '001';
             b.scTime = '0 ' + minMin + ' ' + (hour + 1) + ' ' + day + ' ' + month + ' ? ' + year;
             // system.schedule(sJobame,'0 ' + minMin + ' ' + (hour + 1) +' ' + day + ' ' + month + ' ? ' + year, new AgencyShareUpdateBatchSchedule());
-
         }
         return b;
     }
 
     public static void removeOtherSc(String likeName, String needName) {
         String likeStr = likeName + '00%';
-        for (CronTrigger ct : [SELECT Id, CronJobDetailId, CronExpression, CronJobDetail.Name
-                               FROM CronTrigger
-                               WHERE CronJobDetail.Name Like :likeStr
-                               AND CronJobDetail.Name != :needName]) {
+        for (CronTrigger ct : [
+            SELECT Id, CronJobDetailId, CronExpression, CronJobDetail.Name
+            FROM CronTrigger
+            WHERE CronJobDetail.Name LIKE :likeStr AND CronJobDetail.Name != :needName
+        ]) {
             System.abortJob(ct.Id);
         }
     }
 
-    global void execute(Database.BatchableContext BC, list < eSignForm__c > eSignList) {
+    global void execute(Database.BatchableContext BC, list<eSignForm__c> eSignList) {
         //鐢ㄤ綔褰曞叆琛ㄧ殑妫�绱㈡潯浠�
-        List < String > esFormidList = new List < String > ();
+        List<String> esFormidList = new List<String>();
         //瀛樻斁绛炬敹鍗曞綍鍏ヨ〃鏄庣粏
-        List < eSignFormLineItemEntry__c > eSignFormLineItemEntryList = new List < eSignFormLineItemEntry__c > ();
+        List<eSignFormLineItemEntry__c> eSignFormLineItemEntryList = new List<eSignFormLineItemEntry__c>();
         //鐢ㄤ綔绛炬敹鍗曟槑缁嗙殑妫�绱㈡潯浠�
-        List < String > eSignFormLineIdList = new List < String > ();
+        List<String> eSignFormLineIdList = new List<String>();
         //鏇存柊鐨勭鏀跺崟鏄庣粏
-        List < eSignFormLineItem__c > eSignFormLuRUList = new List < eSignFormLineItem__c > ();
+        List<eSignFormLineItem__c> eSignFormLuRUList = new List<eSignFormLineItem__c>();
         //瀛樻斁鏈�鍚庢洿鏂扮殑 褰曞叆琛╥d
-        List < Id > fileIdList = new List < Id > ();
+        List<Id> fileIdList = new List<Id>();
         //瀛樻斁鏈�鏂扮殑 绛炬敹鍗昳d锛岀鏀跺崟褰曞叆id
-        Map < Id, Id > eSignIdMap = new Map < Id, Id > ();
+        Map<Id, Id> eSignIdMap = new Map<Id, Id>();
 
         //瀛樻斁鏈�鏂扮殑 绛炬敹鍗昳d锛岀鏀跺崟褰曞叆id 鐢ㄤ簬鏈�鍚庝竴鏉$鏀跺崟褰曞叆琛ㄤ笉鍒犻櫎
-        Map < Id, Id > eSignFormLastIdMap = new Map < Id, Id > ();
+        Map<Id, Id> eSignFormLastIdMap = new Map<Id, Id>();
 
         //瀛樻斁鏈�鏂扮殑 绛炬敹鍗昳d锛岀鏀跺崟褰曞叆id 鐢ㄤ簬鏂囦欢鏇存柊
-        Map < Id, Id > eSignFlieIdMap = new Map < Id, Id > ();
+        Map<Id, Id> eSignFlieIdMap = new Map<Id, Id>();
 
         //瀛樻斁褰曞叆琛╥d锛屽綍鍏ヨ〃
-        Map < String, eSignFormEntry__c > lasteSignFormEntryMap = new Map < String, eSignFormEntry__c > ();
+        Map<String, eSignFormEntry__c> lasteSignFormEntryMap = new Map<String, eSignFormEntry__c>();
         //瀛樻斁鏈�鏂扮殑 绛炬敹鍗曟槑缁唅d锛岀鏀跺崟鏄庣粏褰曞叆id
-        Map < Id, Id > eSignFormLineItemEntryIdMap = new Map < Id, Id > ();
+        Map<Id, Id> eSignFormLineItemEntryIdMap = new Map<Id, Id>();
         //绛炬敹鍗曞綍鍏ヨ〃鏄庣粏id锛岀鏀跺崟褰曞叆琛ㄦ槑缁�
-        Map < String, eSignFormLineItemEntry__c > lasteSignFormLineItemEntryMap = new Map < String, eSignFormLineItemEntry__c > ();
+        Map<String, eSignFormLineItemEntry__c> lasteSignFormLineItemEntryMap = new Map<String, eSignFormLineItemEntry__c>();
         //瀛樻斁 绛炬敹鍗昳d,鏂囦欢鏁伴噺
-        Map < String, Integer > fileMap = new Map < String, Integer > ();
+        Map<String, Integer> fileMap = new Map<String, Integer>();
         //椹冲洖鍚庡垹闄ゆ枃浠� 鍚�  鎺掑簭闂  绮剧悽鎶�鏈� wql  2020/12/24 start
-        // List<Attachment> esignAttachAgencyList = new List<Attachment>();
-        // List<Attachment> esignAttachHPList = new List<Attachment>();
-        List<FileAddress__c> esignAttachAgencyList = new List<FileAddress__c>();        //zhj Attachment To AWS 2023-02-06
-        List<FileAddress__c> esignAttachHPList = new List<FileAddress__c>();            //zhj Attachment To AWS 2023-02-06
+        List<Attachment> esignAttachAgencyList = new List<Attachment>();
+        List<Attachment> esignAttachHPList = new List<Attachment>();
         Map<String, Integer> fileAgencyMap = new Map<String, Integer>();
         Map<String, Integer> fileHPMap = new Map<String, Integer>();
         //椹冲洖鍚庡垹闄ゆ枃浠� 鍚�  鎺掑簭闂  绮剧悽鎶�鏈� wql  2020/12/24 end
         //瀛樻斁ocsm绠$悊鐪�
-        List < String > provinceList = new List < String > ();
+        List<String> provinceList = new List<String>();
         //瀛樻斁15浣嶇鏀跺崟id,ocsm绠$悊鐪�
-        Map < Id, String > provinceMap = new Map < Id, String > ();
+        Map<Id, String> provinceMap = new Map<Id, String>();
         //瀛樻斁鐢ㄤ簬鏇存柊鐨勭鏀跺崟鏁扮粍
-        List < eSignForm__c > eSignFormList = new List < eSignForm__c > ();
+        List<eSignForm__c> eSignFormList = new List<eSignForm__c>();
         //瀛樻斁绛炬敹鍗曞綍鍏ヨ〃id锛宯ame
-        Map < Id, String > eSignNameMap = new Map < Id, String > ();
+        Map<Id, String> eSignNameMap = new Map<Id, String>();
         //瀛樻斁绛炬敹鍗曞綍鍏ヨ〃id锛宼ype
-        Map < Id, String > eSignTypeMap = new Map < Id, String > ();
+        Map<Id, String> eSignTypeMap = new Map<Id, String>();
 
         //鍒犻櫎涓棿琛ㄦ暟鎹敤
-        Map < String, eSignFormEntry__c > eSignStringMap = new Map < String, eSignFormEntry__c > ();
+        Map<String, eSignFormEntry__c> eSignStringMap = new Map<String, eSignFormEntry__c>();
         //瀛樻斁鎵�鏈夌鏀跺崟褰曞叆琛╥d
-        List < String > luruIsSubmitList = new List < String > ();
+        List<String> luruIsSubmitList = new List<String>();
 
         //瀛樻斁鎵�鏈夌鏀跺崟褰曞叆琛╥d
-        List < String > luruIsLastSubmitList = new List < String > ();
-
-        // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 start
+        List<String> luruIsLastSubmitList = new List<String>();
         //鍒ゆ柇鏄惁鏈夋湭澶勭悊鐨勫綍鍏ヨ〃
-        // Map < Id, eSignFormEntry__c > unprocessedESignEneryMap = new Map < Id, eSignFormEntry__c > ();
-        Map < Id, List<eSignFormEntry__c> > unprocessedESignEneryMap = new Map < Id, List<eSignFormEntry__c> > ();
-        List<eSignFormEntry__c> unprocessedEntries = new List<eSignFormEntry__c>();
-        // Map <Id, eSignFormEntry__c> unprocessedEntries = new Map<Id, eSignFormEntry__c>();
-        // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 start
+        Map<Id, eSignFormEntry__c> unprocessedESignEneryMap = new Map<Id, eSignFormEntry__c>();
 
         //鐢ㄤ簬鍒ゆ柇鍒犻櫎椹冲洖鐨勯檮浠剁殑绛涢�夋潯浠�
-        Map < Id, eSignForm__c > rejectESignEneryMap = new Map < Id, eSignForm__c > ();
+        Map<Id, eSignForm__c> rejectESignEneryMap = new Map<Id, eSignForm__c>();
         //椹冲洖鍚� 鍒犻櫎涔嬪墠涓婁紶鐨勬枃浠秈d
-        //List<Attachment> deleteLastFileList = new List<Attachment>();
-        List<FileAddress__c> deleteLastFileList = new List<FileAddress__c>();       //zhj Attachment To AWS 2023-02-06
+        List<Attachment> deleteLastFileList = new List<Attachment>();
         //瀛樻斁鏈洿鏂板墠鐨勭粡閿�鍟嗗鎵圭姸鎬�
-        Map < String, String > oldESignAgencyStatusMap = new Map < String, String > ();
+        Map<String, String> oldESignAgencyStatusMap = new Map<String, String>();
         //瀛樻斁鏈洿鏂板墠鐨勫尰闄㈠鎵圭姸鎬�
-        Map < String, String > oldESignHPStatusMap = new Map < String, String > ();
+        Map<String, String> oldESignHPStatusMap = new Map<String, String>();
         try {
             //寰幆瀛樻斁绛炬敹鍗昳d 鐢ㄤ綔妫�绱㈢鏀跺崟褰曞叆琛ㄧ殑鏉′欢
             system.debug('eSignList:' + eSignList);
             if (eSignList.size() > 0) {
                 for (eSignForm__c esForm : eSignList) {
                     //瀛樻斁绛炬敹鍗昳d,ocsm绠$悊鐪� 濡傛灉璇环鏄泦閲� 鍒欏彇ocsm绠$悊鐪佷负闆嗛噰璇剧殑鎷呭綋
-                    if(esForm.Statu_Achievements__r.Opportunity__r.Group_purchase_PCL__c){
+                    if (esForm.Statu_Achievements__r.Opportunity__r.Group_purchase_PCL__c) {
                         provinceMap.put(esForm.Id, '闆嗛噰璇�');
                         //妫�绱㈡潯浠�
                         provinceList.add('闆嗛噰璇�');
-                    }else{
+                    } else {
                         provinceMap.put(esForm.Id, esForm.OCM_man_province_cus__c);
                         //妫�绱㈡潯浠�
                         provinceList.add(esForm.OCM_man_province_cus__c);
                     }
-                    
+
                     esFormidList.add(esForm.Id);
 
                     //鏈夌粡閿�鍟嗛┏鍥炴垨鑰呭尰闄㈤┏鍥炴椂鍒犻櫎涔嬪墠闄勪欢
                     if (esForm.agencyRejectDate__c != null || esForm.HPRejectDate__c != null) {
                         rejectESignEneryMap.put(esForm.Id, esForm);
                     }
-
-
                 }
             }
             system.debug('rejectESignEneryMap:' + rejectESignEneryMap);
             //濡傛灉map涓嶄负绌� 鍒欎綔涓虹瓫閫夋潯浠�
-            if (rejectESignEneryMap.size()>0) {
-                // List<Attachment> deleteFileList = [SELECT parentId, createdDate, Name,Description   
-                //                                    FROM Attachment
-                //                                    WHERE parentId IN: rejectESignEneryMap.keySet() order by createdDate];
-                List<FileAddress__c> deleteFileList = [SELECT ParentRecordId__c, createdDate, FileName__c  
-                                                        FROM FileAddress__c
-                                                        WHERE ParentRecordId__c IN: rejectESignEneryMap.keySet() order by createdDate];  //zhj Attachment To AWS 2023-02-06
+            if (rejectESignEneryMap.size() > 0) {
+                List<Attachment> deleteFileList = [
+                    SELECT parentId, createdDate, Name, Description
+                    FROM Attachment
+                    WHERE parentId IN :rejectESignEneryMap.keySet()
+                    ORDER BY createdDate
+                ];
                 system.debug('deleteFileList:' + deleteFileList);
                 if (deleteFileList.size() > 0) {
                     for (eSignForm__c esFile : rejectESignEneryMap.values()) {
-                        //for (Attachment att : deleteFileList) {
-                        for (FileAddress__c att : deleteFileList) {             //zhj Attachment To AWS 2023-02-06
+                        for (Attachment att : deleteFileList) {
                             if (esFile.agencyRejectDate__c != null || esFile.HPRejectDate__c != null) {
-                                if (att.ParentRecordId__c == esFile.Id ) {
+                                if (att.parentId == esFile.Id) {
                                     //鈶犵粡閿�鍟嗛┏鍥炲悗闇�瑕佸垹闄ょ殑闄勪欢
                                     if (esFile.agencyRejectDate__c != null) {
-                                        //zhj Attachment To AWS 2023-02-06
-                                        // if (att.Name.substring(0, 1) == 'A' && att.createdDate < esFile.agencyRejectDate__c) {
-                                        //     deleteLastFileList.add(att);
-                                        // }
-                                        if (att.FileName__c.substring(0, 1) == 'A' && att.createdDate < esFile.agencyRejectDate__c) {
+                                        if (att.Name.substring(0, 1) == 'A' && att.createdDate < esFile.agencyRejectDate__c) {
                                             deleteLastFileList.add(att);
                                         }
                                     }
                                     //鈶″尰闄㈤┏鍥炲悗闇�瑕佸垹闄ょ殑闄勪欢
                                     if (esFile.HPRejectDate__c != null) {
-                                        //zhj Attachment To AWS 2023-02-06
-                                        // if (att.Name.substring(0, 1) == 'H' && att.createdDate < esFile.HPRejectDate__c) {
-                                        //     deleteLastFileList.add(att);
-                                        // }
-                                        if (att.FileName__c.substring(0, 1) == 'H' && att.createdDate < esFile.HPRejectDate__c) {
+                                        if (att.Name.substring(0, 1) == 'H' && att.createdDate < esFile.HPRejectDate__c) {
                                             deleteLastFileList.add(att);
                                         }
                                     }
                                 }
-
-
                             }
                         }
-
                     }
-
-
                 }
             }
             system.debug('椹冲洖鍚庡垹闄ょ殑鏂囦欢锛�' + deleteLastFileList);
@@ -409,12 +384,47 @@
             }
 
             //妫�绱㈡墍鏈夊綍鍏ヨ〃
-            List < eSignFormEntry__c > eSignFormEntryList = [select id, Name, entryType__c, eSignForm__c, eSignForm__r.OCM_man_province_cus__c, salesManageConfirmDate__c, salesHPManageConfirmDate__c, agencyScanDayBack__c, agencySignUpDateBack__c, agencyConfirmDateBack__c, HPScanDayBack__c, HPSignUpDateBack__c, HPConfirmDateBack__c,
-                                       eSignForm__r.Name, IsSubmit__c, IsHPSubmit__c, IsAgencyConfirmSubmit__c, agencyAutoSignUpStatus__c, HPSignUpStatus__c, Sales_Root_Formula__c, Sales_assistant_ID__c, IsHandled__c, IsHPHandled__c, createdDate, AgencyWorkflowEmailBack__c, HPWorkflowEmailBack__c, AgencyWorkflowEmail__c, HPWorkflowEmail__c, eSignForm__r.Id, agencyDNSignUpStatus__c, HPDNSignUpStatus__c, agencyReject__c, HPReject__c, IsAgencyScan__c, IsHPScan__c
-                                       from eSignFormEntry__c
-                                       where eSignForm__c IN: esFormidList
-                                       order by eSignForm__c, createdDate asc
-                                                            ];
+            List<eSignFormEntry__c> eSignFormEntryList = [
+                SELECT
+                    id,
+                    Name,
+                    entryType__c,
+                    eSignForm__c,
+                    eSignForm__r.OCM_man_province_cus__c,
+                    salesManageConfirmDate__c,
+                    salesHPManageConfirmDate__c,
+                    agencyScanDayBack__c,
+                    agencySignUpDateBack__c,
+                    agencyConfirmDateBack__c,
+                    HPScanDayBack__c,
+                    HPSignUpDateBack__c,
+                    HPConfirmDateBack__c,
+                    eSignForm__r.Name,
+                    IsSubmit__c,
+                    IsHPSubmit__c,
+                    IsAgencyConfirmSubmit__c,
+                    agencyAutoSignUpStatus__c,
+                    HPSignUpStatus__c,
+                    Sales_Root_Formula__c,
+                    Sales_assistant_ID__c,
+                    IsHandled__c,
+                    IsHPHandled__c,
+                    createdDate,
+                    AgencyWorkflowEmailBack__c,
+                    HPWorkflowEmailBack__c,
+                    AgencyWorkflowEmail__c,
+                    HPWorkflowEmail__c,
+                    eSignForm__r.Id,
+                    agencyDNSignUpStatus__c,
+                    HPDNSignUpStatus__c,
+                    agencyReject__c,
+                    HPReject__c,
+                    IsAgencyScan__c,
+                    IsHPScan__c
+                FROM eSignFormEntry__c
+                WHERE eSignForm__c IN :esFormidList
+                ORDER BY eSignForm__c, createdDate ASC
+            ];
 
             if (eSignFormEntryList.size() > 0) {
                 for (Id eid : esFormidList) {
@@ -424,24 +434,16 @@
                         eSignStringMap.put(eSignFormEntryWhole.Id, eSignFormEntryWhole);
                         //鈶℃墍鏈夌殑 鐢ㄤ簬鏇存柊鏂囦欢(鍖呭惈宸插鐞嗘湭澶勭悊鐨勬暟鎹� )
                         fileIdList.add(eSignFormEntryWhole.Id);
-                        // 杩欓噷鏄粈涔堥锛熼兘涓嶅垽鏂竴涓嬬鏀跺崟id鐨勶紵
-                        // if (eSignFormEntryWhole.IsHandled__c == false) {
-                        if (eSignFormEntryWhole.IsHandled__c == false && eSignFormEntryWhole.eSignForm__r.Id  == eid) {
+                        if (eSignFormEntryWhole.IsHandled__c == false) {
                             //鏈鐞嗙殑
-                            // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 start
-                            // unprocessedESignEneryMap.put(eid, eSignFormEntryWhole);
-                            List<eSignFormEntry__c> entries = unprocessedESignEneryMap.size() > 0 && unprocessedESignEneryMap.keySet().contains(eid) ? unprocessedESignEneryMap.get(eid) : new List<eSignFormEntry__c>();
-                            entries.add(eSignFormEntryWhole);
-                            unprocessedESignEneryMap.put(eid, entries);
-                            // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 end
+                            unprocessedESignEneryMap.put(eid, eSignFormEntryWhole);
                         }
-                        if (eSignFormEntryWhole.eSignForm__r.Id  == eid) {
+                        if (eSignFormEntryWhole.eSignForm__r.Id == eid) {
                             //瀛樻斁 绛炬敹鍗昳d锛屽綍鍏ヨ〃id 鏂囦欢鐢�
                             eSignFlieIdMap.put(eSignFormEntryWhole.Id, eid);
                             //瀛樻斁绛炬敹鍗曞綍鍏ヨ〃锛宨d锛宯ame 鏂囦欢鐢�
                             eSignNameMap.put(eid, eSignFormEntryWhole.eSignForm__r.Name);
                         }
-
 
                         //瀛樻斁褰曞叆琛╥d锛岃褰曠被鍨� id锛宼ype 鏂囦欢鐢�
                         eSignTypeMap.put(eSignFormEntryWhole.Id, eSignFormEntryWhole.entryType__c);
@@ -453,10 +455,8 @@
                 for (Id esFormid : esFormidList) {
                     //鍐呭眰鏄鏀跺崟褰曞叆琛�
                     for (eSignFormEntry__c eSignFormEntry : eSignFormEntryList) {
-
                         //鈶犲彇鏈�鏂扮殑 褰曞叆琛� + 鏈鐞嗙殑
                         if (esFormid.equals(eSignFormEntry.eSignForm__c)) {
-
                             if (!eSignFormEntry.IsHandled__c) {
                                 //瀛樻斁 绛炬敹鍗昳d锛屽綍鍏ヨ〃id
                                 eSignIdMap.put(esFormid, eSignFormEntry.Id);
@@ -465,9 +465,7 @@
                                 // break;
                             }
                             eSignFormLastIdMap.put(esFormid, eSignFormEntry.Id);
-
                         }
-
                     }
                 }
                 //鏈�鍚庢洿鏂扮殑褰曞叆琛╥d
@@ -482,42 +480,26 @@
                 //閲嶆柊瀵归檮浠舵帓搴�  瑙勫垯鍙樹负鏍规嵁绛炬敹鍗曠幇鏈夐檮浠跺簭鍙疯繘琛屾帓搴� 绮剧悽鎶�鏈� wql start
                 //鏆傛椂瀛樻斁涓�涓嬬鏀跺崟鍚嶇О
                 Map<string, string> tempMap = new Map<string, string>();
-                //zhj Attachment To AWS 2023-02-06
-                // List<Attachment> tempAttList = [SELECT parentId, createdDate, Name,Description  
-                //                                 FROM Attachment
-                //                                 WHERE parentId IN: esFormidList order by createdDate];
-                List<FileAddress__c> tempAttList = [SELECT ParentRecordId__c, createdDate, FileName__c 
-                                                FROM FileAddress__c
-                                                WHERE ParentRecordId__c IN: esFormidList order by createdDate];
+                List<Attachment> tempAttList = [
+                    SELECT parentId, createdDate, Name, Description
+                    FROM Attachment
+                    WHERE parentId IN :esFormidList
+                    ORDER BY createdDate
+                ];
                 if (tempAttList.size() > 0) {
                     //澶栧眰寰幆绛炬敹鍗�
                     for (String es : esFormidList) {
-                        //zhj Attachment To AWS 2023-02-06
                         //鍐呭眰寰幆闄勪欢
-                        // for (Attachment att : tempAttList) {
-                        //     //濡傛灉id鐩哥瓑
-                        //     if (es.equals(att.parentId)) {
-                        //         //鏍规嵁鍚嶇О鎷嗗垎 瀛樺叆涓嶅悓list
-                        //         String name = att.Name;
-                        //         if (name.substring(0, 1).equals('A')) {
-                        //             esignAttachAgencyList.add(att);
-                        //         } else if (name.substring(0, 1).equals('H')) {
-                        //             esignAttachHPList.add(att);
-                        //         }
-
-                        //     }
-                        // }
-                        for (FileAddress__c att : tempAttList) {
+                        for (Attachment att : tempAttList) {
                             //濡傛灉id鐩哥瓑
-                            if (es.equals(att.ParentRecordId__c)) {
+                            if (es.equals(att.parentId)) {
                                 //鏍规嵁鍚嶇О鎷嗗垎 瀛樺叆涓嶅悓list
-                                String name = att.FileName__c;
+                                String name = att.Name;
                                 if (name.substring(0, 1).equals('A')) {
                                     esignAttachAgencyList.add(att);
                                 } else if (name.substring(0, 1).equals('H')) {
                                     esignAttachHPList.add(att);
                                 }
-
                             }
                         }
                         //鍒嗗埆瀛樺叆鍒扮粡閿�鍟唎r鍖婚櫌鐨勯檮浠秏ap 鐢ㄤ簬鍚庢湡鍛藉悕
@@ -530,7 +512,6 @@
                         //娓呯┖list 渚涗笅涓�涓鏀跺崟浣跨敤
                         esignAttachAgencyList.clear();
                         esignAttachHPList.clear();
-
                     }
                 }
                 system.debug('fileAgencyMap:' + fileAgencyMap);
@@ -538,10 +519,21 @@
                 //閲嶆柊瀵归檮浠舵帓搴�  瑙勫垯鍙樹负鏍规嵁绛炬敹鍗曠幇鏈夐檮浠跺簭鍙疯繘琛屾帓搴� 绮剧悽鎶�鏈� wql end
 
                 //鏍规嵁鎵�鏈夌殑绛炬敹鍗曞綍鍏ヨ〃id妫�绱㈡墍鏈夌殑绛炬敹鍗曟槑缁嗗綍鍏�
-                List < eSignFormLineItemEntry__c > eSignFormLineItemEntryLists = [select id, eSignFormEntry__r.entryType__c, eSignFormEntry__r.IsHandled__c, eSignFormLineItem__c, eSignFormEntry__c,
-                                                   agencyConfirmResult__c, HPConfirmResult__c, HPGoodStatus__c, agencyGoodStatus__c
-                                                   from eSignFormLineItemEntry__c where eSignFormEntry__c in : luruIsSubmitList  and eSignFormEntry__r.IsHandled__c = false order by createdDate asc
-                                                                                 ];
+                List<eSignFormLineItemEntry__c> eSignFormLineItemEntryLists = [
+                    SELECT
+                        id,
+                        eSignFormEntry__r.entryType__c,
+                        eSignFormEntry__r.IsHandled__c,
+                        eSignFormLineItem__c,
+                        eSignFormEntry__c,
+                        agencyConfirmResult__c,
+                        HPConfirmResult__c,
+                        HPGoodStatus__c,
+                        agencyGoodStatus__c
+                    FROM eSignFormLineItemEntry__c
+                    WHERE eSignFormEntry__c IN :luruIsSubmitList AND eSignFormEntry__r.IsHandled__c = FALSE
+                    ORDER BY createdDate ASC
+                ];
                 if (eSignFormLineItemEntryLists.size() > 0) {
                     for (eSignFormLineItemEntry__c eSignFormLineItemEntry : eSignFormLineItemEntryLists) {
                         eSignFormLineIdList.add(eSignFormLineItemEntry.eSignFormLineItem__c);
@@ -550,7 +542,11 @@
                 system.debug('eSignFormLineIdList:' + eSignFormLineIdList);
                 if (eSignFormLineIdList.size() > 0) {
                     //鏍规嵁绛炬敹鍗曟槑缁嗗綍鍏ヨ〃 鍘绘绱㈢鏀跺崟鏄庣粏
-                    List < eSignFormLineItem__c > eSignFormLineItemList = [select id, agencyGoodStatus__c, HPGoodStatus__c from eSignFormLineItem__c where id IN: eSignFormLineIdList];
+                    List<eSignFormLineItem__c> eSignFormLineItemList = [
+                        SELECT id, agencyGoodStatus__c, HPGoodStatus__c
+                        FROM eSignFormLineItem__c
+                        WHERE id IN :eSignFormLineIdList
+                    ];
                     if (eSignFormLineItemList.size() > 0) {
                         //澶栧眰绛炬敹鍗曟槑缁�
                         for (eSignFormLineItem__c eSignFormLineItem : eSignFormLineItemList) {
@@ -570,7 +566,6 @@
                 if (eSignFormLineIdList.size() > 0) {
                     //寰幆 鏇存柊绛炬敹鍗�
                     for (Id esefId : eSignFormLineIdList) {
-
                         if (lasteSignFormLineItemEntryMap.containsKey(esefId)) {
                             eSignFormLineItemEntry__c luru = lasteSignFormLineItemEntryMap.get(esefId);
                             //new 涓�涓鏀跺崟鏄庣粏瀵硅薄
@@ -591,8 +586,6 @@
                                 eSignFormLuRuList.add(eSignLuRu);
                             }
                         }
-
-
                     }
                 }
                 System.debug('鏇存柊鐨勭鏀跺崟鏄庣粏list:' + eSignFormLuRUList);
@@ -608,195 +601,167 @@
                         boolean IsHPSubmit = false;
                         //閿�鍞笭閬�
                         String Sales_Root_Formula;
-                        //褰曞叆绫诲瀷 
-                        String type; // 杩欎笢瑗挎病鏈夌敤
+                        //褰曞叆绫诲瀷
+                        String type;
                         System.debug('lasteSignFormEntryMap:' + lasteSignFormEntryMap);
                         if (lasteSignFormEntryMap.containsKey(eSignFormid)) {
                             eSignForm.id = eSignFormid;
-                            // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 start
                             //绛炬敹鍗昳d
-                            // eSignFormEntry__c eSignFormEntry = lasteSignFormEntryMap.get(eSignFormid);
-                            for (eSignFormEntry__c eSignFormEntry : unprocessedESignEneryMap.get(eSignFormid)) {
-                                // 鏍规嵁褰曞叆绫诲瀷鍘绘洿鏂板搴旂殑閮ㄥ垎鏁版嵁
-                                // entryType__c鍖呭惈缁忛攢鍟�
-                                if (String.isNotBlank(eSignFormEntry.entryType__c) && eSignFormEntry.entryType__c.contains('缁忛攢鍟�')) {
-                                    //濡傛灉缁忛攢鍟嗙‘璁ゆ棩涓虹┖鐨勮瘽 杩涘幓鍒ゆ柇鏇存柊缁忛攢鍟嗗鎵圭姸鎬�
-                                    if (eSignFormEntry.agencyDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
-                                        if (eSignFormEntry.agencyConfirmDateBack__c == null) {
-                                            if (eSignFormEntry.IsSubmit__c == true) {
-                                                eSignForm.agencyAutoSignUpStatus__c = '鐢宠涓�';
-                                                eSignForm.agencyReject__c = false;
-                                            } else {
-                                                if (eSignFormEntry.agencyScanDayBack__c != null && eSignFormEntry.IsAgencyScan__c) {
-                                                    // 璋冩暣鑽夋涓殑璧嬪�奸�昏緫锛屽绔搷浣滅殑鎯呭喌涓嬫湁鍙兘鍏堢敵璇峰悗鑽夋
-                                                    // eSignForm.agencyAutoSignUpStatus__c = '鑽夋涓�';
-                                                    eSignForm.agencyAutoSignUpStatus__c = String.isBlank(eSignForm.agencyAutoSignUpStatus__c) ? '鑽夋涓�' : eSignForm.agencyAutoSignUpStatus__c;
-                                                    eSignForm.agencyReject__c = false;
-                                                }
-                                            }
-                                        }
-                                        //鏈洿鏂板墠鐨勭粡閿�鍟嗗鎵圭姸鎬� 鐢ㄤ簬鏂囦欢绱姹囨��
-                                        if(eSignFormEntry.agencyAutoSignUpStatus__c!=null &&eSignFormEntry.agencyAutoSignUpStatus__c!=''){
-                                            oldESignAgencyStatusMap.put('A' + eSignForm.id, eSignFormEntry.agencyAutoSignUpStatus__c);
-                                        }else{
-                                            oldESignAgencyStatusMap.put('A' + eSignForm.id, '鏃�');
-                                        }
-                                    }
-                                    //濡傛灉娌″彉鍖栧垯涓嶆洿鏂�
-                                    if (eSignFormEntry.AgencyWorkflowEmailBack__c != eSignFormEntry.AgencyWorkflowEmail__c) {
-                                        //缁忛攢鍟嗛偖浠�
-                                        eSignForm.AgencyWorkflowEmail__c = eSignFormEntry.AgencyWorkflowEmailBack__c;
-                                    }
-                                    // 鏃ユ湡鏇存柊
-                                    if (eSignFormEntry.agencyDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
-                                        //缁忛攢鍟嗘壂鎻忔棩
-                                        if (eSignFormEntry.agencyScanDayBack__c != null) {
-                                            eSignForm.agencyScanDay__c = eSignFormEntry.agencyScanDayBack__c;
-                                        }
-                                        //缁忛攢鍟嗙鏀舵棩
-                                        if (eSignFormEntry.agencySignUpDateBack__c != null) {
-                                            eSignForm.agencySignUpDate__c = eSignFormEntry.agencySignUpDateBack__c;
-                                        }
-                                        //缁忛攢鍟嗙‘璁ゆ棩
-                                        if (eSignFormEntry.agencyConfirmDateBack__c != null) {
-                                            eSignForm.agencyConfirmDate__c = eSignFormEntry.agencyConfirmDateBack__c;
+                            eSignFormEntry__c eSignFormEntry = lasteSignFormEntryMap.get(eSignFormid);
+                            //濡傛灉缁忛攢鍟嗙‘璁ゆ棩涓虹┖鐨勮瘽 杩涘幓鍒ゆ柇鏇存柊缁忛攢鍟嗗鎵圭姸鎬�
+                            if (eSignFormEntry.agencyDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
+                                if (eSignFormEntry.agencyConfirmDateBack__c == null) {
+                                    if (eSignFormEntry.IsSubmit__c == true) {
+                                        eSignForm.agencyAutoSignUpStatus__c = '鐢宠涓�';
+                                        eSignForm.agencyReject__c = false;
+                                    } else {
+                                        if (eSignFormEntry.agencyScanDayBack__c != null && eSignFormEntry.IsAgencyScan__c) {
+                                            eSignForm.agencyAutoSignUpStatus__c = '鑽夋涓�';
+                                            eSignForm.agencyReject__c = false;
                                         }
                                     }
                                 }
-                                // entryType__c鍖呭惈鍖婚櫌
-                                if (String.isNotBlank(eSignFormEntry.entryType__c) && eSignFormEntry.entryType__c.contains('鍖婚櫌')) {
-                                    if (eSignFormEntry.HPDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
-                                        //濡傛灉鍖婚櫌纭鏃ヤ负绌虹殑璇� 杩涘幓鍒ゆ柇鏇存柊鍖婚櫌瀹℃壒鐘舵��
-                                        if (eSignFormEntry.salesHPManageConfirmDate__c == null) {
-                                            if (eSignFormEntry.IsHPSubmit__c == true) {
-                                                eSignForm.HPSignUpStatus__c = '鐢宠涓�';
-                                                eSignForm.HPReject__c = false;
-                                            } else {
-                                                if (eSignFormEntry.HPScanDayBack__c != null && eSignFormEntry.IsHPScan__c) {
-                                                    // 璋冩暣鑽夋涓殑璧嬪�奸�昏緫锛屽绔搷浣滅殑鎯呭喌涓嬫湁鍙兘鍏堢敵璇峰悗鑽夋
-                                                    // eSignForm.HPSignUpStatus__c = '鑽夋涓�';
-                                                    eSignForm.HPSignUpStatus__c = String.isBlank(eSignForm.HPSignUpStatus__c) ? '鑽夋涓�' : eSignForm.HPSignUpStatus__c;
-                                                    eSignForm.HPReject__c = false;
-                                                }
-                                            }
-                                        }
-                                        //鏈洿鏂板墠鐨勫尰闄㈠鎵圭姸鎬� 鐢ㄤ簬鏂囦欢绱姹囨��
-                                        if(eSignFormEntry.HPSignUpStatus__c!=null &&eSignFormEntry.HPSignUpStatus__c!=''){
-                                            oldESignHPStatusMap.put('H' + eSignForm.id, eSignFormEntry.HPSignUpStatus__c);
-                                        }else{
-                                            oldESignHPStatusMap.put('H' + eSignForm.id, '鏃�');
-                                        }
-                                    }
-                                    //濡傛灉娌″彉鍖栧垯涓嶆洿鏂�
-                                    if (eSignFormEntry.HPWorkflowEmailBack__c != eSignFormEntry.HPWorkflowEmail__c) {
-                                        //鍖婚櫌閭欢
-                                        eSignForm.HPWorkflowEmail__c = eSignFormEntry.HPWorkflowEmailBack__c;
-                                    }
-                                    // 鏃ユ湡鏇存柊
-                                    if (eSignFormEntry.HPDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
-                                        //鍖婚櫌鎵弿鏃�
-                                        if (eSignFormEntry.HPScanDayBack__c != null) {
-                                            eSignForm.HPScanDay__c = eSignFormEntry.HPScanDayBack__c;
-                                        }
-                                        //鍖婚櫌绛炬敹鏃�
-                                        if (eSignFormEntry.HPSignUpDateBack__c != null) {
-                                            eSignForm.HPSignUpDate__c = eSignFormEntry.HPSignUpDateBack__c;
-                                        }
-                                        //鍖婚櫌纭鏃�
-                                        if (eSignFormEntry.HPConfirmDateBack__c != null) {
-                                            eSignForm.HPConfirmDate__c = eSignFormEntry.HPConfirmDateBack__c;
-                                        }
-                                    }
+                                //鏈洿鏂板墠鐨勭粡閿�鍟嗗鎵圭姸鎬� 鐢ㄤ簬鏂囦欢绱姹囨��
+                                if (eSignFormEntry.agencyAutoSignUpStatus__c != null && eSignFormEntry.agencyAutoSignUpStatus__c != '') {
+                                    oldESignAgencyStatusMap.put('A' + eSignForm.id, eSignFormEntry.agencyAutoSignUpStatus__c);
+                                } else {
+                                    oldESignAgencyStatusMap.put('A' + eSignForm.id, '鏃�');
                                 }
-                                //缁欒惀涓氬姪鐞嗚祴鍊�
-                                //eSignForm.Sales_assistant_name_text__c = eSignFormEntry.Sales_assistant_ID__c;// Commented By Li Jun 20230420
-                                //瀛樹竴涓猧d
-                                idlast = eSignFormEntry.Id;
-                                //绛炬敹鍗昻ame鐢ㄤ綔鏂囦欢鍛藉悕
-                                name = eSignFormEntry.eSignForm__r.Name;
-                                //鏄惁缁忛攢鍟嗘彁浜�
-                                IsSubmit = eSignFormEntry.IsSubmit__c;
-                                //鏄惁鍖婚櫌鎻愪氦
-                                IsHPSubmit = eSignFormEntry.IsHPSubmit__c;
-                                //鏈�鍚庡綍鍏ヨ〃
-                                eSignForm.finalUpadteFrom__c = eSignFormEntry.Id;
-                                //閿�鍞笭閬� 鍖哄垎鐩撮攢杩樻槸鍒嗛攢
-                                Sales_Root_Formula = eSignFormEntry.Sales_Root_Formula__c;
-                                //褰曞叆绫诲瀷
-                                type = eSignFormEntry.entryType__c; // 娌℃湁鐢�
-
-                                // 鎵�鏈夋病鏈夋病鏈夊鐞嗙殑entry閮借鏍囪涓哄鐞�
-                                eSignFormEntry.IsHandled__c = true;
-                                unprocessedEntries.add(eSignFormEntry);
-                                // unprocessedEntries.put(eSignFormEntry.Id, eSignFormEntry);
                             }
-                            // 2023-03-16 ssm 浼樺寲閫昏緫锛岄伩鍏嶅悓鏃跺璁惧鍋氱郴缁熸洿鏂颁互鍙婂尰闄㈠拰缁忛攢鍟嗗湪鍚屼竴鎵规锛�15鍒嗛挓鍐咃級涓婁紶鏁版嵁 end
+                            if (eSignFormEntry.HPDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
+                                //濡傛灉鍖婚櫌纭鏃ヤ负绌虹殑璇� 杩涘幓鍒ゆ柇鏇存柊鍖婚櫌瀹℃壒鐘舵��
+                                if (eSignFormEntry.salesHPManageConfirmDate__c == null) {
+                                    if (eSignFormEntry.IsHPSubmit__c == true) {
+                                        eSignForm.HPSignUpStatus__c = '鐢宠涓�';
+                                        eSignForm.HPReject__c = false;
+                                    } else {
+                                        if (eSignFormEntry.HPScanDayBack__c != null && eSignFormEntry.IsHPScan__c) {
+                                            eSignForm.HPSignUpStatus__c = '鑽夋涓�';
+                                            eSignForm.HPReject__c = false;
+                                        }
+                                    }
+                                }
+                                //鏈洿鏂板墠鐨勫尰闄㈠鎵圭姸鎬� 鐢ㄤ簬鏂囦欢绱姹囨��
+                                if (eSignFormEntry.HPSignUpStatus__c != null && eSignFormEntry.HPSignUpStatus__c != '') {
+                                    oldESignHPStatusMap.put('H' + eSignForm.id, eSignFormEntry.HPSignUpStatus__c);
+                                } else {
+                                    oldESignHPStatusMap.put('H' + eSignForm.id, '鏃�');
+                                }
+                            }
 
+                            //濡傛灉娌″彉鍖栧垯涓嶆洿鏂�
+                            if (eSignFormEntry.AgencyWorkflowEmailBack__c != eSignFormEntry.AgencyWorkflowEmail__c) {
+                                //缁忛攢鍟嗛偖浠�
+                                eSignForm.AgencyWorkflowEmail__c = eSignFormEntry.AgencyWorkflowEmailBack__c;
+                            }
+                            //濡傛灉娌″彉鍖栧垯涓嶆洿鏂�
+                            if (eSignFormEntry.HPWorkflowEmailBack__c != eSignFormEntry.HPWorkflowEmail__c) {
+                                //鍖婚櫌閭欢
+                                eSignForm.HPWorkflowEmail__c = eSignFormEntry.HPWorkflowEmailBack__c;
+                            }
+                            if (eSignFormEntry.agencyDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
+                                //缁忛攢鍟嗘壂鎻忔棩
+                                if (eSignFormEntry.agencyScanDayBack__c != null) {
+                                    eSignForm.agencyScanDay__c = eSignFormEntry.agencyScanDayBack__c;
+                                }
+                                //缁忛攢鍟嗙鏀舵棩
+                                if (eSignFormEntry.agencySignUpDateBack__c != null) {
+                                    eSignForm.agencySignUpDate__c = eSignFormEntry.agencySignUpDateBack__c;
+                                }
+                                //缁忛攢鍟嗙‘璁ゆ棩
+                                if (eSignFormEntry.agencyConfirmDateBack__c != null) {
+                                    eSignForm.agencyConfirmDate__c = eSignFormEntry.agencyConfirmDateBack__c;
+                                }
+                            }
+
+                            if (eSignFormEntry.HPDNSignUpStatus__c != '绛炬敹宸插畬鎴�') {
+                                //鍖婚櫌鎵弿鏃�
+                                if (eSignFormEntry.HPScanDayBack__c != null) {
+                                    eSignForm.HPScanDay__c = eSignFormEntry.HPScanDayBack__c;
+                                }
+                                //鍖婚櫌绛炬敹鏃�
+                                if (eSignFormEntry.HPSignUpDateBack__c != null) {
+                                    eSignForm.HPSignUpDate__c = eSignFormEntry.HPSignUpDateBack__c;
+                                }
+                                //鍖婚櫌纭鏃�
+                                if (eSignFormEntry.HPConfirmDateBack__c != null) {
+                                    eSignForm.HPConfirmDate__c = eSignFormEntry.HPConfirmDateBack__c;
+                                }
+                            }
+
+                            //缁欒惀涓氬姪鐞嗚祴鍊�
+                            eSignForm.Sales_assistant_name_text__c = eSignFormEntry.Sales_assistant_ID__c;
+                            //瀛樹竴涓猧d
+                            idlast = eSignFormEntry.Id;
+                            //绛炬敹鍗昻ame鐢ㄤ綔鏂囦欢鍛藉悕
+                            name = eSignFormEntry.eSignForm__r.Name;
+                            //鏄惁缁忛攢鍟嗘彁浜�
+                            IsSubmit = eSignFormEntry.IsSubmit__c;
+                            //鏄惁鍖婚櫌鎻愪氦
+                            IsHPSubmit = eSignFormEntry.IsHPSubmit__c;
+                            //鏈�鍚庡綍鍏ヨ〃
+                            eSignForm.finalUpadteFrom__c = eSignFormEntry.Id;
+                            //閿�鍞笭閬� 鍖哄垎鐩撮攢杩樻槸鍒嗛攢
+                            Sales_Root_Formula = eSignFormEntry.Sales_Root_Formula__c;
+                            //褰曞叆绫诲瀷
+                            type = eSignFormEntry.entryType__c;
                         }
                         system.debug('绛炬敹鍗曞璞�-----锛�' + eSignForm);
                         if (eSignForm != null) {
                             system.debug('eSignFormid:' + eSignFormid);
                             if (eSignForm.id != null) {
-
                                 eSignFormList.add(eSignForm);
                             }
-
                         }
                         system.debug('eSignFormList111:' + eSignFormList);
                         if (eSignFormList.size() > 0) {
                             //鏇存柊OCSM绠$悊鐪� 鎷呭綋
                             eSignFormList = updateOwner(provinceList, provinceMap, eSignFormList, false);
                         }
-
-
                     }
                 }
-
-
             }
 
             if (eSignFormList.size() <= 0) {
                 system.debug('鎴戣蛋鍒拌繖閲屼簡锛�');
-                eSignFormList  = updateOwner(provinceList, provinceMap, eSignList, true);
+                eSignFormList = updateOwner(provinceList, provinceMap, eSignList, true);
             }
 
-
-            List<Id> fileList = new List<Id> ();
+            List<Id> fileList = new List<Id>();
             if (fileIdList.size() > 0) {
                 for (Id fileId : fileIdList) {
                     if (!fileList.contains(fileId)) {
                         fileList.add(fileId);
                     }
-
                 }
             }
 
             System.debug('fileIdList锛�' + fileIdList);
             System.debug('fileList锛�' + fileList);
             //鐢ㄤ簬鏈�鍚巌nsert 闄勪欢
-            //zhj Attachment To AWS 2023-02-06
-            //List<Attachment> insertAttactment = new List<Attachment>();
-            List<FileAddress__c> insertAttactment = new List<FileAddress__c>();
+            List<Attachment> insertAttactment = new List<Attachment>();
             //闄勪欢  start
-            //List<Attachment> attachMentList = [SELECT id, parentId, Body, Name, ContentType,Description  from Attachment where parentId IN :fileList and Description!='鐢靛瓙绛炬敹鍗曪細宸插鐞�'];
-            List<FileAddress__c> attachMentList = [SELECT id, ParentRecordId__c, FileName__c,subInfoType__c,AWS_File_Key__c,DownloadLink__c,ViewLink__c  from FileAddress__c where ParentRecordId__c IN :fileList and subInfoType__c  !='鐢靛瓙绛炬敹鍗曪細宸插鐞�'];
-            //淇宸插鐞嗘暟鎹� 闄勪欢娌℃洿鏂�  鍗虫病鏈夐檮浠惰兘鎻愪氦鐨刡ug 绮剧悽鎶�鏈� wql 2021/01/19 start 
-            //List<Attachment> eSignEntryAttachMentList = new List<Attachment>();
-            List<FileAddress__c> eSignEntryAttachMentList = new List<FileAddress__c>();
+            List<Attachment> attachMentList = [
+                SELECT id, parentId, Body, Name, ContentType, Description
+                FROM Attachment
+                WHERE parentId IN :fileList AND Description != '鐢靛瓙绛炬敹鍗曪細宸插鐞�'
+            ];
+            //淇宸插鐞嗘暟鎹� 闄勪欢娌℃洿鏂�  鍗虫病鏈夐檮浠惰兘鎻愪氦鐨刡ug 绮剧悽鎶�鏈� wql 2021/01/19 start
+            List<Attachment> eSignEntryAttachMentList = new List<Attachment>();
             //鏂囦欢鏁伴噺 鐢ㄤ簬鏂囦欢鍛藉悕
             Integer agencyCount = 0;
             Integer hpCount = 0;
 
             String name;
-            String type ;
+            String type;
             Integer agencyFileCountNum = 0;
             Integer hpFileCountNum = 0;
             Integer i = 0;
             Integer j = 0;
             //璁板綍璇ョ鏀跺崟鐨勬渶鏂扮粡閿�鍟嗛檮浠舵暟閲�
-            Map<id,Integer> eSignAgencyAttSum = new Map<id,Integer> ();
+            Map<id, Integer> eSignAgencyAttSum = new Map<id, Integer>();
             //璁板綍璇ョ鏀跺崟鐨勬渶鏂板尰闄㈤檮浠舵暟閲�
-            Map<id,Integer> eSignHpAttSum = new Map<id,Integer> ();
+            Map<id, Integer> eSignHpAttSum = new Map<id, Integer>();
 
             //鍚屼竴鏉″綍鍏ヨ〃澶氫釜闄勪欢鏍囪瘑
             Boolean agencyNumFlag = false;
@@ -811,28 +776,25 @@
                 system.debug('eSignFlieIdMap:' + eSignFlieIdMap);
                 system.debug('eSignNameMap:' + eSignNameMap);
                 for (Id eSignFormEntryId : fileList) {
-
-                    for (FileAddress__c attach : attachMentList) {          //zhj Attachment To AWS 2023-02-06
-
-                        if (attach.ParentRecordId__c == eSignFormEntryId) {
-                            Id eid = eSignFlieIdMap.get(attach.ParentRecordId__c);
+                    for (Attachment attach : attachMentList) {
+                        if (attach.parentId == eSignFormEntryId) {
+                            Id eid = eSignFlieIdMap.get(attach.parentId);
                             system.debug('eid:' + eid);
 
                             name = eSignNameMap.get(eid);
                             system.debug('name:' + name);
-                            type = eSignTypeMap.get(attach.ParentRecordId__c);
+                            type = eSignTypeMap.get(attach.parentId);
 
                             //鍥犱负澶栧眰寰幆鏄腑闂磋〃 濡傛灉2鏉′互涓婂綍鍏ヨ〃閮芥湁缁忛攢鍟嗛檮浠� 鍒欎娇鐢ㄦ渶鏂版瀯寤虹殑缁忛攢鍟嗛檮浠舵暟閲忔潵鍛藉悕
                             //鍚﹀垯鍙栨湭鏇存柊涔嬪墠鏈夌殑缁忛攢鍟嗛檮浠舵暟閲� 骞朵笖 涓嶆槸1涓綍鍏ヨ〃澶氫釜闄勪欢 涔熷氨鏄痜alse鐨勬椂鍊� 鍙栨ā鎷熺殑鏈�鏂版暟閲�
-                            if(eSignAgencyAttSum.size()>0&&!agencyNumFlag){
+                            if (eSignAgencyAttSum.size() > 0 && !agencyNumFlag) {
                                 agencyCount = eSignAgencyAttSum.get(eid);
                                 //璁板綍涓�涓渶鏂扮殑闄勪欢鏁�
-                                agencySumCount =agencyCount;
-                            }else if(agencySumCount>0){
+                                agencySumCount = agencyCount;
+                            } else if (agencySumCount > 0) {
                                 //鏈寰幆鍐� 绗竴娆″彇闄勪欢鏁版渶鏂板�� 鍚庣画閮藉湪姝ゅ熀纭�涓奿++
-                                agencyCount =agencySumCount;
-                            }
-                            else if(fileAgencyMap.size() > 0){
+                                agencyCount = agencySumCount;
+                            } else if (fileAgencyMap.size() > 0) {
                                 //鍙湁涓�鏉℃暟鎹椂锛屼娇鐢ㄦ闄勪欢鏁板嵆鍙� 鍚庣画鍦ㄦ鍩虹涓奿++
                                 agencyCount = fileAgencyMap.get(eid);
                             }
@@ -854,20 +816,19 @@
                             //缁忛攢鍟嗛檮浠跺懡鍚� end
                             //鍥犱负澶栧眰寰幆鏄腑闂磋〃 濡傛灉2鏉′互涓婂綍鍏ヨ〃閮芥湁鍖婚櫌闄勪欢 鍒欎娇鐢ㄦ渶鏂版瀯寤虹殑鍖婚櫌闄勪欢鏁伴噺鏉ュ懡鍚�
                             //鍚﹀垯鍙栨湭鏇存柊涔嬪墠鏈夌殑鍖婚櫌闄勪欢鏁伴噺 骞朵笖 涓嶆槸1涓綍鍏ヨ〃澶氫釜闄勪欢 涔熷氨鏄痜alse鐨勬椂鍊� 鍙栨ā鎷熺殑鏈�鏂版暟閲�
-                            if(eSignHpAttSum.size()>0&&!hpNumFlag){
+                            if (eSignHpAttSum.size() > 0 && !hpNumFlag) {
                                 hpCount = eSignHpAttSum.get(eid);
                                 //璁板綍涓�涓渶鏂扮殑闄勪欢鏁�
                                 hpSumCount = hpCount;
-                            }else if(hpSumCount >0 ){
+                            } else if (hpSumCount > 0) {
                                 //鏈寰幆鍐� 绗竴娆″彇闄勪欢鏁版渶鏂板�� 鍚庣画閮藉湪姝ゅ熀纭�涓妀++
-                                hpCount =hpSumCount;                        
-                            }
-                            else if(fileHPMap.size() > 0){
+                                hpCount = hpSumCount;
+                            } else if (fileHPMap.size() > 0) {
                                 //鍙湁涓�鏉℃暟鎹椂锛屼娇鐢ㄦ闄勪欢鏁板嵆鍙� 鍚庣画鍦ㄦ鍩虹涓妀++
                                 hpCount = fileHPMap.get(eid);
                             }
                             //鍚屼竴涓唴閮ㄥ惊鐜噷缃垚true
-                            hpNumFlag =true;
+                            hpNumFlag = true;
                             //鍖婚櫌闄勪欢鍛藉悕 start
                             // if (fileHPMap.size() > 0) {
                             //     hpCount = fileHPMap.get(eid);
@@ -880,12 +841,12 @@
                                 hpFileCountNum = hpCount + 1 + j;
                             }
                             //鏋勫缓鏈�鏂扮殑绛炬敹鍗曠粡閿�鍟嗛檮浠舵暟閲�
-                            if(agencyFileCountNum>0){
-                                eSignAgencyAttSum.put(eid,agencyFileCountNum);
+                            if (agencyFileCountNum > 0) {
+                                eSignAgencyAttSum.put(eid, agencyFileCountNum);
                             }
                             //鏋勫缓鏈�鏂扮殑绛炬敹鍗曞尰闄㈤檮浠舵暟閲�
-                            if(hpFileCountNum>0){
-                                eSignHpAttSum.put(eid,hpFileCountNum);
+                            if (hpFileCountNum > 0) {
+                                eSignHpAttSum.put(eid, hpFileCountNum);
                             }
                             //鍖婚櫌闄勪欢鍛藉悕 end
                             //鐢ㄤ簬鎷嗗垎缁忛攢鍟�/鍖婚櫌 鍖哄埆鏂囦欢鍚�
@@ -915,40 +876,31 @@
                             //     title = title +'.jpg';
                             // }
                             //鍒ゆ柇涓�涓嬫牸寮忥紝涓嶇劧涓嬭浇涓嬫潵鏄被鍨嬫槸鎵�鏈夋枃浠� 鏃犳硶鎵撳紑
-                            //zhj Attachment To AWS 2023-02-06 start
-                            if (attach.FileName__c.lastIndexOf('.') > -1) {
-                                title = title + attach.FileName__c.substring(attach.FileName__c.lastIndexOf('.'));
+                            if (attach.Name.lastIndexOf('.') > -1) {
+                                title = title + attach.Name.substring(attach.Name.lastIndexOf('.'));
                             }
 
-                            //Attachment newAttachment = attach.clone();
-                            FileAddress__c newAttachment = attach.clone();
-                            newAttachment.ParentRecordId__c = eid;
-                            newAttachment.FileName__c = title;
+                            Attachment newAttachment = attach.clone();
+                            newAttachment.parentId = eid;
+                            newAttachment.name = title;
                             // newAttachment.ContentType =attach.ContentType;
                             //瑕佹洿鏂扮殑绛炬敹鍗曢檮浠�
                             insertAttactment.add(newAttachment);
                             //鍙嶆洿鏂板綍鍏ヨ〃鐨勯檮浠� 鐢ㄦ潵鍒ゆ柇闄勪欢鏄惁琚洿鏂�
-                            //Attachment oldAttachment = new  Attachment();
-                            FileAddress__c oldAttachment = new  FileAddress__c();
+                            Attachment oldAttachment = new Attachment();
                             oldAttachment.Id = attach.Id;
-                            //oldAttachment.Description = '鐢靛瓙绛炬敹鍗曪細宸插鐞�';
-                            oldAttachment.subInfoType__c = '鐢靛瓙绛炬敹鍗曪細宸插鐞�';
-                            //zhj Attachment To AWS 2023-02-06 end
+                            oldAttachment.Description = '鐢靛瓙绛炬敹鍗曪細宸插鐞�';
                             eSignEntryAttachMentList.add(oldAttachment);
-
                         }
-
-
                     }
                     //鏁村崟寰幆鍚� 娓呯┖鍊�
                     i = 0;
                     j = 0;
-                    agencyNumFlag= false;
-                    hpNumFlag =false;
-                    agencySumCount =0;
-                    hpSumCount=0;
+                    agencyNumFlag = false;
+                    hpNumFlag = false;
+                    agencySumCount = 0;
+                    hpSumCount = 0;
                 }
-
             }
 
             //鐢靛瓙绛炬敹鍗� 澧炲姞鏈鏇存柊闄勪欢鏁伴噺  2020/01/07 绮剧悽鎶�鏈� wql start
@@ -956,7 +908,7 @@
             if (insertAttactment.size() > 0) {
                 insert insertAttactment;
                 //鍙嶅悜鏇存柊褰曞叆琛ㄩ檮浠�
-                if(eSignEntryAttachMentList.size()>0){
+                if (eSignEntryAttachMentList.size() > 0) {
                     update eSignEntryAttachMentList;
                 }
 
@@ -964,84 +916,59 @@
                 if (eSignFormList.size() > 0) {
                     //澶栧眰鎵�鏈夌鏀跺崟
                     for (eSignForm__c es : eSignFormList) {
-
                         //a涓虹粡閿�鍟嗛檮浠剁殑鏁伴噺 h涓哄尰闄㈤檮浠剁殑鏁伴噺
                         Integer a = 0;
                         Integer h = 0;
 
                         //鍐呭眰鎵�鏈夐渶瑕佹洿鏂扮殑闄勪欢
-                        //for (Attachment att : insertAttactment) {
-                        for (FileAddress__c att : insertAttactment) {   //zhj Attachment To AWS 2023-02-06
+                        for (Attachment att : insertAttactment) {
                             if (es.Id != null) {
-                                if (es.Id.equals(att.ParentRecordId__c)) {
+                                if (es.Id.equals(att.parentId)) {
                                     if (es.agencyAutoSignUpStatus__c != null) {
-                                        if (es.agencyAutoSignUpStatus__c.equals('鐢宠涓�') && oldESignAgencyStatusMap.size()>0) {
-                                                if(!oldESignAgencyStatusMap.get('A' + es.Id).equals('鐢宠涓�')){
-                                                    if (att.FileName__c.substring(0, 1).equals('A')) {      //zhj Attachment To AWS 2023-02-06
-                                                        a ++;
-                                                    }
+                                        if (es.agencyAutoSignUpStatus__c.equals('鐢宠涓�') && oldESignAgencyStatusMap.size() > 0) {
+                                            if (!oldESignAgencyStatusMap.get('A' + es.Id).equals('鐢宠涓�')) {
+                                                if (att.Name.substring(0, 1).equals('A')) {
+                                                    a++;
                                                 }
-                                            
+                                            }
                                         }
                                     }
                                     if (es.HPSignUpStatus__c != null) {
-                                        if (es.HPSignUpStatus__c.equals('鐢宠涓�') && oldESignHPStatusMap.size()>0) {
-                                            if(!oldESignHPStatusMap.get('H' + es.Id).equals('鐢宠涓�')){
-                                                if (att.FileName__c.substring(0, 1).equals('H')) {          //zhj Attachment To AWS 2023-02-06
-                                                    h ++;
+                                        if (es.HPSignUpStatus__c.equals('鐢宠涓�') && oldESignHPStatusMap.size() > 0) {
+                                            if (!oldESignHPStatusMap.get('H' + es.Id).equals('鐢宠涓�')) {
+                                                if (att.Name.substring(0, 1).equals('H')) {
+                                                    h++;
                                                 }
                                             }
-                                            
                                         }
                                     }
-
                                 }
                             }
-
                         }
 
                         //鍙湁鐪熸鎵爜鎻愪氦鐨� 骞朵笖娌℃湁闄勪欢鎵嶄細琚洿鏂�
                         if (es.agencyAutoSignUpStatus__c != null) {
-                            if (es.agencyAutoSignUpStatus__c.equals('鐢宠涓�') && oldESignAgencyStatusMap.size()>0) {
-                                if(!oldESignAgencyStatusMap.get('A' + es.Id).equals('鐢宠涓�')){
+                            if (es.agencyAutoSignUpStatus__c.equals('鐢宠涓�') && oldESignAgencyStatusMap.size() > 0) {
+                                if (!oldESignAgencyStatusMap.get('A' + es.Id).equals('鐢宠涓�')) {
                                     es.agencyAttachNum__c = a;
                                 }
-                                
                             }
                         }
                         //鍙湁鐪熸鎵爜鎻愪氦鐨� 骞朵笖娌℃湁闄勪欢鎵嶄細琚洿鏂�
                         if (es.HPSignUpStatus__c != null) {
-                            if (es.HPSignUpStatus__c.equals('鐢宠涓�') &&oldESignHPStatusMap.size()>0 ) {
-                                if(!oldESignHPStatusMap.get('H' + es.Id).equals('鐢宠涓�')){
-                                     es.HPAttachNum__c = h;
+                            if (es.HPSignUpStatus__c.equals('鐢宠涓�') && oldESignHPStatusMap.size() > 0) {
+                                if (!oldESignHPStatusMap.get('H' + es.Id).equals('鐢宠涓�')) {
+                                    es.HPAttachNum__c = h;
                                 }
-                               
-
                             }
                         }
 
                         a = 0;
                         h = 0;
-
                     }
                 }
                 //鐢靛瓙绛炬敹鍗� 澧炲姞鏈鏇存柊闄勪欢鏁伴噺  2020/01/07 绮剧悽鎶�鏈� wql end
                 //鏂囦欢 end
-            }
-            // 鏇存柊绛炬敹鍗曞綍鍏ヨ〃
-            if(unprocessedEntries.size() > 0) {
-                Database.SaveResult[] lsr = Database.update(unprocessedEntries, false);
-                // Database.SaveResult[] lsr = Database.update(unprocessedEntries.values(), false);
-                eb.setError(lsr, MAXERRORCNT, eSignFormEntry__c.sObjectType);
-                for (Integer tIdx = 0; tIdx < lsr.size(); tIdx++) {
-                    Database.SaveResult sr = lsr[tIdx];
-                    System.debug('sr.isSuccess:' + sr.isSuccess());
-                    if (!sr.isSuccess()) {
-                        Database.Error emsg = sr.getErrors()[0];
-                        iflog.ErrorLog__c += 'ERROR ' + unprocessedEntries[tIdx].Id + ' eSignFormEntry__c:' + emsg + '\n';
-                        // iflog.ErrorLog__c += 'ERROR ' + unprocessedEntries.values()[tIdx].Id + ' eSignFormEntry__c:' + emsg + '\n';
-                    }
-                }
             }
             system.debug('鏇存柊鐨勭鏀跺崟锛�' + eSignFormList);
             //鏇存柊绛炬敹鍗曟槑缁嗗苟娣诲姞鏃ュ織
@@ -1070,35 +997,30 @@
                     }
                 }
             }
-
-
-        }catch(NullPointerException npe){
-            
-                iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:绌烘寚閽堥敊璇�-琛屽彿:'+ npe.getLineNumber()+ '\n';
-        } 
-        catch (Exception e) {
+        } catch (NullPointerException npe) {
+            iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:绌烘寚閽堥敊璇�-琛屽彿:' + npe.getLineNumber() + '\n';
+        } catch (Exception e) {
             // Database.rollback(sp);
-                
-            iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:'+ e.getMessage() + '\n';
 
+            iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:' + e.getMessage() + '\n';
         }
-        try{
-            System.debug('luruIsLastSubmitList:'+luruIsLastSubmitList);
+        try {
+            System.debug('luruIsLastSubmitList:' + luruIsLastSubmitList);
             if (luruIsLastSubmitList.size() > 0) {
                 //鍒犻櫎涓棿琛ㄦ暟鎹紙鍥犱负浣忎富璇﹀叧绯伙紝鍒犻櫎褰曞叆琛ㄥ嵆鍙級
                 deleteMiddleData(eSignStringMap, luruIsLastSubmitList);
             }
-        }catch(Exception e){
-            iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:'+ e.getMessage() + '\n';
+        } catch (Exception e) {
+            iflog.ErrorLog__c += 'ERROR 锛� eSignForm__c:' + e.getMessage() + '\n';
         }
         //鏂囦欢 end
     }
 
     //鍒犻櫎涓棿琛ㄦ暟鎹紙鍥犱负浣忎富璇﹀叧绯伙紝鍒犻櫎褰曞叆琛ㄥ嵆鍙級
-    private static void deleteMiddleData(Map < String, eSignFormEntry__c > eSignStringMap, List < String > luruIsSubmitList) {
+    private static void deleteMiddleData(Map<String, eSignFormEntry__c> eSignStringMap, List<String> luruIsSubmitList) {
         system.debug('妫�绱㈢殑鎵�鏈夊綍鍏ヨ〃锛�' + eSignStringMap);
         system.debug('鏈�鍚庡綍鍏ョ殑id 锛�' + luruIsSubmitList + '----鏁伴噺锛�' + luruIsSubmitList.size());
-        list < eSignFormEntry__c > eSignFormDeleteList = new list < eSignFormEntry__c > ();
+        list<eSignFormEntry__c> eSignFormDeleteList = new List<eSignFormEntry__c>();
         for (String essm : eSignStringMap.keySet()) {
             for (String lisl : luruIsSubmitList) {
                 if (essm.equals(lisl)) {
@@ -1111,73 +1033,68 @@
         }
         system.debug('鍒犻櫎鐨勬暟鎹甶d锛�' + eSignFormDeleteList + '----鏁伴噺锛�' + eSignFormDeleteList.size());
 
-
-
         //鍒犻櫎绛炬敹鍗曞綍鍏ヨ〃鍏朵粬鏁版嵁
         if (eSignFormDeleteList.size() > 0) {
             //寰幆閬嶅巻id 鍒犻櫎鏂囦欢
-            List<String> fileDeleteIdList = new List<String> ();
-            //List<Attachment> deleteAttachmentList = new List<Attachment>();
-            List<FileAddress__c> deleteAttachmentList = new List<FileAddress__c>();     //zhj Attachment To AWS 2023-02-06
+            List<String> fileDeleteIdList = new List<String>();
+            List<Attachment> deleteAttachmentList = new List<Attachment>();
 
             for (eSignFormEntry__c eSigf : eSignFormDeleteList) {
                 fileDeleteIdList.add(eSigf.Id);
             }
             //寰幆鎵惧埌鏂囦欢id
             if (fileDeleteIdList.size() > 0) {
-
                 // 2022-02-28 shashiming Apex heap size too large
                 // 鍘绘帀Body瀛楁
-                //List<Attachment> attachMentList = [SELECT id, parentId, Name, ContentType,Description  from Attachment where parentId = :fileDeleteIdList];
-                List<FileAddress__c> attachMentList = [SELECT id, ParentRecordId__c, FileName__c,AWS_File_Key__c  from FileAddress__c where ParentRecordId__c = :fileDeleteIdList];       //zhj Attachment To AWS 2023-02-06
-                List<Transaction_Log__c> tranList = new List<Transaction_Log__c>();
+                List<Attachment> attachMentList = [
+                    SELECT id, parentId, Name, ContentType, Description
+                    FROM Attachment
+                    WHERE parentId = :fileDeleteIdList
+                ];
+
                 if (attachMentList.size() > 0) {
-                    for (FileAddress__c att : attachMentList) {
-                        FileAddress__c am = new FileAddress__c();           //zhj Attachment To AWS 2023-02-06
+                    for (Attachment att : attachMentList) {
+                        Attachment am = new Attachment();
                         am.Id = att.Id;
                         deleteAttachmentList.add(am);
-                        //zhj 鏂板鏃ュ織锛屽垹闄WS鐨勯檮浠� 2023-02-17
-                        Transaction_Log__c tran = new Transaction_Log__c();
-                        tran.AWS_Data_Id__c = att.AWS_File_Key__c;
-                        tran.Status__c = 'In Process';
-                        tran.Module__c = '绛炬敹鍗曢檮浠跺垹闄�';
-                        tranList.add(tran);
-                    }
-                    //鏂板鏃ュ織锛屽垹闄WS鐨勯檮浠� zhj 2023-02-17
-                    if(tranList.size() > 0){
-                        insert tranList;
                     }
                     //鍒犻櫎鏂囦欢
                     if (deleteAttachmentList.size() > 0) {
                         delete deleteAttachmentList;
                     }
                 }
-
-
             }
             //鍒犻櫎褰曞叆琛�
-            System.debug('鍒犻櫎褰曞叆琛� : ' + eSignFormDeleteList);
-            // delete eSignFormDeleteList;  // 2023-03-14 ssm 鏆傛椂涓嶈嚜鍔ㄥ垹闄や腑闂磋〃鏁版嵁锛屾柟渚跨煭鏈熷唴鍋歝heck
+            delete eSignFormDeleteList;
         }
     }
     @TestVisible
     //鏇存柊钀ヤ笟閮ㄦ媴褰�
-    private static List < eSignForm__c > updateOwner(List < String > provinceList, Map < Id, String > provinceMap, List < eSignForm__c > eSignFormList, boolean ocsmFlag) {
+    private static List<eSignForm__c> updateOwner(
+        List<String> provinceList,
+        Map<Id, String> provinceMap,
+        List<eSignForm__c> eSignFormList,
+        boolean ocsmFlag
+    ) {
         //钀ヤ笟鎷呭綋 map
-        Map < String, String > provinceOwnerMap = new Map < String, String > ();
+        Map<String, String> provinceOwnerMap = new Map<String, String>();
         //钀ヤ笟鍔╃悊 map
-        Map < String, String > provinceGIMap = new Map < String, String > ();
+        Map<String, String> provinceGIMap = new Map<String, String>();
 
-        List < eSignForm__c > eSignFormLastList = new List < eSignForm__c >();
+        List<eSignForm__c> eSignFormLastList = new List<eSignForm__c>();
         //妫�绱CSM绠$悊鐪佸璞�
-        List < OCM_Management_Province__c > ompList = [select id, Name, SalesManage__c,GI_assistant__c,Window1__c    from OCM_Management_Province__c where Name IN: provinceList];
+        List<OCM_Management_Province__c> ompList = [
+            SELECT id, Name, SalesManage__c, GI_assistant__c
+            FROM OCM_Management_Province__c
+            WHERE Name IN :provinceList
+        ];
         //瀛樻斁map<鐪侊紝鎷呭綋>
         for (OCM_Management_Province__c omp : ompList) {
             //涓嶇敤map<String,list>鐨� 鍘熷洜鏄� 鎯� ocsm绠$悊鐪� 鍜岀鏀跺崟 钀ヤ笟鎷呭綋鐨勯『搴忎繚鎸佷竴鑷�
             //String salesManage = omp.SalesManage__c+','+omp.SalesManage2__c+','+omp.SalesManage3__c;
             //provinceOwnerMap.put(omp.Name, salesManage);
             provinceOwnerMap.put(omp.Name, omp.SalesManage__c);
-            provinceGIMap.put(omp.Name, omp.Window1__c);//Update By Li Jun 20230420 for  绛炬敹鍗曡惀涓氬姪鐞嗕粠GI/SP鍔╃悊鏀逛负绛炬敹鍗昈CSM鐪佺殑钀ヤ笟绐楀彛
+            provinceGIMap.put(omp.Name, omp.GI_assistant__c);
         }
         //鈶犱负true鐨勬椂鍊� 鏄叾浠栨病鍙戠敓鍙樺寲鍙湁ocsm鐪佷笂钀ヤ笟鎷呭綋鏀瑰彉
         //鈶′负false鐨勬椂鍊欙紝鏈変腑闂磋〃姝e父鏇存柊鐨勬儏鍐�
@@ -1223,7 +1140,6 @@
         //             }
         //         }
 
-
         //     }
         //     return eSignFormLastList;
 
@@ -1257,43 +1173,39 @@
         if (ocsmFlag) {
             //缁欐渶鍚庤鏇存柊鐨勭鏀跺崟鐨勫鎵硅�咃紙钀ヤ笟閮ㄦ媴褰擄級璧嬪��
             for (Integer cnt = 0; cnt < eSignFormList.size(); cnt++) {
-                if (provinceOwnerMap.get(provinceMap.get(eSignFormList[cnt].Id)) != eSignFormList[cnt].RC_Manager__c ||provinceMap.get(eSignFormList[cnt].Id).equals('闆嗛噰璇�')) {
-
+                if (
+                    provinceOwnerMap.get(provinceMap.get(eSignFormList[cnt].Id)) != eSignFormList[cnt].RC_Manager__c ||
+                    provinceMap.get(eSignFormList[cnt].Id).equals('闆嗛噰璇�')
+                ) {
                     eSignForm__c eSignForm = new eSignForm__c();
                     eSignForm.Id = eSignFormList[cnt].Id;
                     eSignForm.RC_Manager__c = provinceOwnerMap.get(provinceMap.get(eSignFormList[cnt].Id));
-                    //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 start 
-                    if(provinceMap.get(eSignFormList[cnt].Id).equals('闆嗛噰璇�')){
+                    //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 start
+                    if (provinceMap.get(eSignFormList[cnt].Id).equals('闆嗛噰璇�')) {
                         eSignForm.Sales_assistant_name_text__c = provinceGIMap.get(provinceMap.get(eSignFormList[cnt].Id));
                     }
                     //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 end
                     eSignFormLastList.add(eSignForm);
                 }
-
             }
             return eSignFormLastList;
-
         } else {
             //缁欐渶鍚庤鏇存柊鐨勭鏀跺崟鐨勫鎵硅�咃紙钀ヤ笟閮ㄦ媴褰擄級璧嬪��
             for (eSignForm__c esf : eSignFormList) {
                 if (provinceOwnerMap.get(provinceMap.get(esf.Id)) != null) {
                     esf.RC_Manager__c = provinceOwnerMap.get(provinceMap.get(esf.Id));
-                    //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 start 
-                    if(provinceMap.get(esf.Id).equals('闆嗛噰璇�')){
+                    //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 start
+                    if (provinceMap.get(esf.Id).equals('闆嗛噰璇�')) {
                         esf.Sales_assistant_name_text__c = provinceGIMap.get(provinceMap.get(esf.Id));
                     }
                     //闆嗛噰璇环 钀ヤ笟鍔╃悊闇�瑕佺淮鎶ゆ垚 闆嗛噰璇剧殑SP銆丟I鍔╃悊 绮剧悽鎶�鏈� wql 2021/01/08 end
                 }
-
             }
             return eSignFormList;
         }
-
     }
 
-
     global void finish(Database.BatchableContext BC) {
-
         //鏇存柊璇ユ棩蹇楃殑鏁版嵁淇℃伅
         iflog.Log__c += '\nupdateESignBatch end';
         String tmp = iflog.ErrorLog__c;
@@ -1331,7 +1243,7 @@
                 //鍐欐绮剧悽鐢ㄦ埛 涓婄嚎鍚庡簲璇ヤ細淇敼鎴愯嚜瀹氫箟鏍囩
                 // String batchUserId = '00510000005sEEM';
                 String batchUserId = System.Label.Batch_User_Id;
-                List<User> us = [Select Id, NAme, Email From User Where Id = : batchUserId];
+                List<User> us = [SELECT Id, NAme, Email FROM User WHERE Id = :batchUserId];
                 if (!us.isEmpty()) {
                     User use = us[0];
                     if (String.isNotBlank(use.Email)) {
@@ -1339,11 +1251,7 @@
                         if (System.Label.ESign_Error_Send_To_CC != 'null') {
                             MailCc = System.Label.ESign_Error_Send_To_CC.split(',');
                         }
-                        FixtureUtil.sendMessage(batchUserId,
-                                                MailCc,
-                                                'updateESignBatch Error',
-                                                body
-                                               );
+                        FixtureUtil.sendMessage(batchUserId, MailCc, 'updateESignBatch Error', body);
                     }
                 }
             }
@@ -1364,7 +1272,7 @@
             messageMap = new Map<Id, String>();
             overMax = false;
         }
-        public void setError (Database.SaveResult[] saveRes, Integer maxCut, Schema.sObjectType obj) {
+        public void setError(Database.SaveResult[] saveRes, Integer maxCut, Schema.sObjectType obj) {
             if (messageMap.keySet().size() <= maxCut && overMax == false) {
                 String objectName = obj.getDescribe().getName();
                 String objectLabel = obj.getDescribe().getLabel();
@@ -1376,12 +1284,16 @@
                                 break;
                             }
                             for (Database.Error err : saveRe.getErrors()) {
-
-                                String message = objectName + ':'
-                                                 + objectLabel + ':'
-                                                 + err.getStatusCode() + ':'
-                                                 + err.getFields() + ':'
-                                                 + err.getMessage();
+                                String message =
+                                    objectName +
+                                    ':' +
+                                    objectLabel +
+                                    ':' +
+                                    err.getStatusCode() +
+                                    ':' +
+                                    err.getFields() +
+                                    ':' +
+                                    err.getMessage();
                                 // 鏁版嵁閲岄潰鏈夊鏁伴敊璇俊鎭殑璇濆彧鑾峰彇绗竴鏉�
                                 messageMap.put(saveRe.getId(), message);
                                 break;
@@ -1394,519 +1306,8 @@
     }
 
     //瀹氭椂璺戜换鍔�
-    public Class ScBean {
+    public class ScBean {
         public String scName;
         public String scTime;
     }
-
-    public static void improveTestRate(){
-        Integer i = 0;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-        i++;
-    }
-}
\ No newline at end of file
+}

--
Gitblit v1.9.1