From 50b39c4b52bf5fd61ec46ada365c51e05a16d2ae Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期四, 04 五月 2023 09:11:54 +0800
Subject: [PATCH] Backup0504

---
 force-app/main/default/classes/LexOutboundorderImportController.cls |  113 +++++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 75 insertions(+), 38 deletions(-)

diff --git a/force-app/main/default/classes/LexOutboundorderImportController.cls b/force-app/main/default/classes/LexOutboundorderImportController.cls
index 9732707..a1f00f6 100644
--- a/force-app/main/default/classes/LexOutboundorderImportController.cls
+++ b/force-app/main/default/classes/LexOutboundorderImportController.cls
@@ -54,18 +54,24 @@
     }
 
     @AuraEnabled
-    public static ResponseBodyLWC importCSVFile(String base64Data, String sqlagencyProType, String userWorkLocation, String accountName) {
+    public static ResponseBodyLWC importCSVFile(
+        String base64DataLwc,
+        String sqlagencyProTypeLwc,
+        String userWorkLocationLwc,
+        String accountNameLwc
+    ) {
         System.debug('enter importCSVFile');
         ResponseBodyLWC res = new ResponseBodyLWC();
         Map<String, object> data = new Map<String, object>();
         res.entity = data;
 
         errorMsg = '';
-        sqlagencyProType = sqlagencyProType;
-        userWorkLocation = userWorkLocation;
-        accountName = accountName;
-        base64Data = EncodingUtil.urlDecode(base64Data, 'UTF-8');
+        sqlagencyProType = sqlagencyProTypeLwc;
+        userWorkLocation = userWorkLocationLwc;
+        accountName = accountNameLwc;
+        String base64Data = EncodingUtil.urlDecode(base64DataLwc, 'UTF-8');
         csvFileBody = EncodingUtil.base64Decode(base64Data);
+        product2conMap = new Map<String, String>();
 
         messageCount = 0;
         errormessage = null;
@@ -157,21 +163,21 @@
                         // ApexPages.addmessage(
                         //     new ApexPages.message(ApexPages.severity.ERROR, 'Barcode ' + bc + ' 涓嶅瓨鍦ㄦ垨鍗曚綅閿欒锛岃纭銆�')
                         // );
-                        errorMsg += 'Barcode ' + bc + ' 涓嶅瓨鍦ㄦ垨鍗曚綅閿欒锛岃纭銆俓n';
+                        errorMsg += 'Barcode ' + bc + ' 涓嶅瓨鍦ㄦ垨鍗曚綅閿欒锛岃纭銆�<br />';
                         saveFLGbln = true;
                         messageCount++;
                     } else if (exitpieceBarcodeMap.containsKey(bc) && exitpieceBarcodeMap.get(bc) < barcodePieceMap.get(bc)) {
                         if (messageCount >= 100)
                             break;
                         // ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'Barcode ' + bc + ' 搴撳瓨涓嶈冻锛岃纭銆�'));
-                        errorMsg += 'Barcode ' + bc + ' 搴撳瓨涓嶈冻锛岃纭銆俓n';
+                        errorMsg += 'Barcode ' + bc + ' 搴撳瓨涓嶈冻锛岃纭銆�<br />';
                         saveFLGbln = true;
                         messageCount++;
                     }
                 }
             } catch (Exception e) {
                 //ApexPages.addMessages(e);
-                errorMsg += e.getMessage();
+                errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
                 //return new ResponseBodyLWC('Error', 500, e.getMessage()+e.getStackTraceString(), '');
             }
             getorderinfo();
@@ -182,8 +188,10 @@
             }
             data.put('orderRecords', orderRecords);
             data.put('saveFLGbln', saveFLGbln);
-            data.put('csvRecordStr',csvRecordStr);
-            data.put('barcodeList',barcodeList);
+            data.put('csvRecordStr', csvRecordStr);
+            data.put('barcodeList', barcodeList);
+            data.put('secondAgencyMap',secondAgencyMap);
+            data.put('hospitalSysMap',hospitalSysMap);
             res.status = 'Success';
             res.code = 200;
             res.msg = errorMsg;
@@ -210,7 +218,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗� ' + csvRecordData[0] + '鍑鸿揣鐩殑涓虹┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '鍑鸿揣鐩殑涓虹┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '鍑鸿揣鐩殑涓虹┖锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 }
@@ -224,7 +232,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗� ' + cocObj.Name + '鐨勪骇鍝佷腑锛屽瓨鍦ㄥ嚭搴撴棩鏈熶负绌猴紝璇风‘璁ゃ��')
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + cocObj.Name + '鐨勪骇鍝佷腑锛屽瓨鍦ㄥ嚭搴撴棩鏈熶负绌猴紝璇风‘璁ゃ�俓n';
+                    errorMsg += '鍑哄簱鍗� ' + cocObj.Name + '鐨勪骇鍝佷腑锛屽瓨鍦ㄥ嚭搴撴棩鏈熶负绌猴紝璇风‘璁ゃ��<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else {
@@ -238,7 +246,7 @@
             }
         } catch (Exception e) {
             //return new ResponseBodyLWC('Error', 500, e.getMessage(), '');
-            errorMsg += e.getMessage();
+            errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
         }
     }
 
@@ -260,7 +268,7 @@
                 // ApexPages.addmessage(
                 //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗�' + ass.order.Name + '鍖婚櫌鐩稿叧淇℃伅涓嶈兘绌猴紝璇风‘璁ゃ��')
                 // );
-                errorMsg += '鍑哄簱鍗�' + ass.order.Name + '鍖婚櫌鐩稿叧淇℃伅涓嶈兘绌猴紝璇风‘璁ゃ�俓n';
+                errorMsg += '鍑哄簱鍗�' + ass.order.Name + '鍖婚櫌鐩稿叧淇℃伅涓嶈兘绌猴紝璇风‘璁ゃ��<br />';
                 messageCount++;
                 saveFLGbln = true;
                 //return null;
@@ -272,7 +280,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆�<br />';
                     messageCount++;
                     saveFLGbln = true;
                 }
@@ -284,7 +292,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佷簩绾х粡閿�鍟嗭紝璇风‘璁ゃ��')
                     // );
-                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佷簩绾х粡閿�鍟嗭紝璇风‘璁ゃ�俓n';
+                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佷簩绾х粡閿�鍟嗭紝璇风‘璁ゃ��<br />';
                     messageCount++;
                     saveFLGbln = true;
                 }
@@ -296,7 +304,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '缁忛攢鍟嗕俊鎭笉鑳界┖锛岃纭銆�<br />';
                     messageCount++;
                     saveFLGbln = true;
                 }
@@ -310,12 +318,13 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佸尰闄㈢浉鍏充俊鎭紝璇风‘璁ゃ��')
                     // );
-                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佸尰闄㈢浉鍏充俊鎭紝璇风‘璁ゃ�俓n';
+                    errorMsg += '鍑哄簱鍗�' + ass.order.Name + '涓嶉渶瑕佸尰闄㈢浉鍏充俊鎭紝璇风‘璁ゃ��<br />';
                     messageCount++;
                     saveFLGbln = true;
                 }
             }
         }
+        System.debug('accountName = ' + accountName);
         List<Agency_Hospital_Link__c> hospitalInfo = [
             SELECT Hospital__c, Hospital__r.Management_Code__c, Hospital__r.Name
             FROM Agency_Hospital_Link__c
@@ -333,6 +342,8 @@
             secondAgencyMap.put(safo.Dealer_subordinate__r.Name, safo.Dealer_subordinate__c);
         }
         //鍑哄簱鍗曚俊鎭獙璇�
+        System.debug('hospitalconMap = ' + hospitalconMap);
+        System.debug('hospitalSysMap = ' + hospitalSysMap);
         for (String widget : hospitalconMap.keySet()) {
             if (!hospitalSysMap.containsKey(widget)) {
                 if (messageCount >= 100)
@@ -352,7 +363,7 @@
                     hospitalconMap.get(widget) +
                     ' 鐨勫尰闄㈢紪鐮�' +
                     widget +
-                    ' 涓嶅瓨鍦ㄦ垨鑰呬笉鏄湰缁忛攢鍟嗚礋璐g殑鍖婚櫌锛岃纭銆俓n';
+                    ' 涓嶅瓨鍦ㄦ垨鑰呬笉鏄湰缁忛攢鍟嗚礋璐g殑鍖婚櫌锛岃纭銆�<br />';
                 saveFLGbln = true;
             }
         }
@@ -382,7 +393,7 @@
                     //         ' 涓嶅瓨鍦ㄥ嚭搴撳崟浣嶏紝璇风‘璁ゃ��'
                     //     )
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '鐨刡arcode ' + cod2Obj.Bar_Code__c + ' 涓嶅瓨鍦ㄥ嚭搴撳崟浣嶏紝璇风‘璁ゃ�俓n';
+                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '鐨刡arcode ' + cod2Obj.Bar_Code__c + ' 涓嶅瓨鍦ㄥ嚭搴撳崟浣嶏紝璇风‘璁ゃ��<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else if (String.valueOf(csvRecordData[9]) != '鐩�' && String.valueOf(csvRecordData[9]) != '涓�') {
@@ -410,7 +421,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else if (String.isNotBlank(csvRecordData[8])) {
@@ -429,7 +440,7 @@
                         //         '浜у搧鍑鸿揣鍗曚环涓嶈兘涓�0锛岃纭銆�'
                         //     )
                         // );
-                        errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '浜у搧鍑鸿揣鍗曚环涓嶈兘涓�0锛岃纭銆俓n';
+                        errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '浜у搧鍑鸿揣鍗曚环涓嶈兘涓�0锛岃纭銆�<br />';
                         saveFLGbln = true;
                         messageCount++;
                     } else {
@@ -447,7 +458,7 @@
                     //         '鐨勪骇鍝佷腑锛屽瓨鍦╞arcode涓虹┖锛岃纭銆�'
                     //     )
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '鐨勪骇鍝佷腑锛屽瓨鍦╞arcode涓虹┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + cod2Obj.TracingCode__c + '鐨勪骇鍝佷腑锛屽瓨鍦╞arcode涓虹┖锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else if (String.isBlank(csvRecordData[12])) {
@@ -488,7 +499,7 @@
             }
         } catch (Exception e) {
             //return new ResponseBodyLWC('Error', 500, e.getMessage(), '');
-            errorMsg += e.getMessage();
+            errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
         }
     }
 
@@ -507,7 +518,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鏁伴噺涓虹┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鏁伴噺涓虹┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鏁伴噺涓虹┖锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else if (Decimal.valueOf(csvRecordData[7]) > 1 && String.valueOf(csvRecordData[9]) == '鐩�') {
@@ -521,7 +532,7 @@
                     //         '瀛樺湪鍗曚綅鏄洅锛屼骇鍝佸嚭璐ф暟閲忓ぇ浜�1锛岃纭銆�'
                     //     )
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '瀛樺湪鍗曚綅鏄洅锛屼骇鍝佸嚭璐ф暟閲忓ぇ浜�1锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '瀛樺湪鍗曚綅鏄洅锛屼骇鍝佸嚭璐ф暟閲忓ぇ浜�1锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 } else {
@@ -536,7 +547,7 @@
                     // ApexPages.addmessage(
                     //     new ApexPages.message(ApexPages.severity.ERROR, '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆�')
                     // );
-                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆俓n';
+                    errorMsg += '鍑哄簱鍗� ' + csvRecordData[0] + '鍑哄簱鍗� ' + csvRecordData[0] + '浜у搧鍑鸿揣鍗曚环涓虹┖锛岃纭銆�<br />';
                     saveFLGbln = true;
                     messageCount++;
                 }
@@ -551,28 +562,50 @@
             }
         } catch (Exception e) {
             //return new ResponseBodyLWC('Error', 500, e.getMessage(), '');
-            errorMsg += e.getMessage();
+            errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
         }
     }
 
     @AuraEnabled
-    public static ResponseBodyLWC dataImport(List<String[]> csvRecordStr,List<ConsumableorderdetailsInfo> orderRecords,String sqlagencyProType, String userWorkLocation, String accountName) {
+    public static ResponseBodyLWC dataImport(
+        List<String[]> csvRecordStrLwc,
+        String orderRecordsLwc,
+        String sqlagencyProTypeLwc,
+        String userWorkLocationLwc,
+        String accountNameLwc,
+        String accountidLwc,
+        String agencyProTypeLwc,
+        Map<String, String> secondAgencyMapLwc,
+        Map<String, String> hospitalSysMapLwc
+    ) {
         List<ConsumableorderdetailsInfo> orderdetRecords = new List<ConsumableorderdetailsInfo>();
         List<ConsumableorderdetailsInfo> orderdet2BoxRecords = new List<ConsumableorderdetailsInfo>();
         List<ConsumableorderdetailsInfo> orderdet2PieceRecords = new List<ConsumableorderdetailsInfo>();
+        product2conMap = new Map<String, String>();
         ResponseBodyLWC res = new ResponseBodyLWC();
         Map<String, object> data = new Map<String, object>();
         res.entity = data;
 
-        csvRecordStr = csvRecordStr;
-        orderRecords = orderRecords;
-        sqlagencyProType = sqlagencyProType;
-        userWorkLocation = userWorkLocation;
-        accountName = accountName;
-        errorMessage = '';
+        csvRecordStr = csvRecordStrLwc;
+        orderRecords = (List<ConsumableorderdetailsInfo>)JSON.deserialize(orderRecordsLwc, List<ConsumableorderdetailsInfo>.class);
+        System.debug('orderRecords = ' + orderRecords);
+        sqlagencyProType = sqlagencyProTypeLwc;
+        userWorkLocation = userWorkLocationLwc;
+        accountName = accountNameLwc;
+        secondAgencyMap = secondAgencyMapLwc;
+        hospitalSysMap = hospitalSysMapLwc;
+        accountid = accountidLwc;
+        agencyProType = agencyProTypeLwc;
+        System.debug('agencyProType = ' + agencyProType);
+
+        errorMsg = '';
+        System.debug('csvRecordStr = ' + csvRecordStr);
         orderdetRecords = getorderdetList(csvRecordStr);
         orderdet2BoxRecords = getorderdet2BoxList(csvRecordStr);
         orderdet2PieceRecords = getorderdet2pieceList(csvRecordStr);
+        System.debug('orderdetRecords = ' + orderdetRecords);
+        System.debug('orderdet2BoxRecords = ' + orderdet2BoxRecords);
+        System.debug('orderdet2PieceRecords = ' + orderdet2PieceRecords);
         Savepoint sp = Database.setSavepoint();
         try {
             Map<String, String> orderInfoMap = new Map<String, String>();
@@ -591,6 +624,7 @@
                 ass.order.RecordTypeId = System.Label.RT_ConOrder_Sale;
                 coc.add(ass.order);
             }
+            System.debug('coc = ' + coc);
             if (coc.size() > 0) {
                 insert coc;
             }
@@ -615,6 +649,7 @@
                     }
                 }
             }
+            System.debug('cod = ' + cod);
             if (cod.size() > 0) {
                 insert cod;
             }
@@ -705,7 +740,7 @@
             Database.rollback(sp);
             // ApexPages.addMessages(e);
             // return null;
-            return new ResponseBodyLWC('Error', 500, e.getMessage()+e.getStackTraceString(), '');
+            return new ResponseBodyLWC('Error', 500, e.getMessage() + e.getStackTraceString(), '');
         }
     }
 
@@ -745,11 +780,13 @@
                     ass.orderdetails1.Shipment_Count__c = orderdetMap.get(ass.orderName + ass.productName + ass.orderdetails1.Box_Piece__c);
                 }
             }
+            System.debug('orderdetRecords = ' + orderdetRecords);
             return orderdetRecords;
         } catch (Exception e) {
             // ApexPages.addMessages(e);
             // return null;
-            errorMsg += e.getMessage();
+            errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
+            System.debug('orderdetRecords = null '  + e.getLineNumber());
             return null;
         }
     }
@@ -787,7 +824,7 @@
         } catch (Exception e) {
             // ApexPages.addMessages(e);
             // return null;
-            errorMsg += e.getMessage();
+            errorMsg += e.getMessage() + ' ' + e.getLineNumber() + ';';
             return null;
         }
     }

--
Gitblit v1.9.1