From 36305d06f22db8e81a73dd6bcccb57311ea80e51 Mon Sep 17 00:00:00 2001
From: chenjingwu <chenjingwu@prec-tech.com>
Date: 星期三, 24 四月 2024 11:35:17 +0800
Subject: [PATCH] 123

---
 force-app/main/default/classes/MaintenanceProductDataController.cls |   21 ++++++++++++---------
 1 files changed, 12 insertions(+), 9 deletions(-)

diff --git a/force-app/main/default/classes/MaintenanceProductDataController.cls b/force-app/main/default/classes/MaintenanceProductDataController.cls
index 829bd23..061b119 100644
--- a/force-app/main/default/classes/MaintenanceProductDataController.cls
+++ b/force-app/main/default/classes/MaintenanceProductDataController.cls
@@ -437,7 +437,7 @@
             for (Integer i=0;i<column_Old.size();i++) {
                 mpdsoql += ',' + column_Old[i];
             }
-            mpdsoql += ' from Maintenance_Product_Data_Details__c  where Maintenance_Product_Data__c = \''+id+'\'';
+            mpdsoql += ' from Maintenance_Product_Data_Details__c  where RecordTypeId != \'012C50000000jefIAA\' and Maintenance_Product_Data__c = \''+id+'\'';
             // 閬告姙娓堛伩銇槑缁嗐倰鍙栧緱
             mpdDetailsSelected = Database.query(mpdsoql);      
             for (Maintenance_Product_Data_Details__c mpdd1 : mpdDetailsSelected) {
@@ -539,7 +539,7 @@
                 // chenjingwu 3+2澶氬勾淇濅慨 20240417 start
                 exmpdDetailsRecordsMap = new Map<String,List<ExMpdDetailsInfo>>(); 
                 muCountMap = new Map<String,Integer>();
-                List<Maintenance_Product_Data_Details__c> exDetailList = [select Id,MultiYearWarranty__c,AgeLimit__c,AgeLimit_Old__c,MultiOneYearWarrantyPrice__c,MultiOneYearWarrantyPrice_Old__c,AmountWithheld__c,AmountWithheld_Old__c,ProductsID__c from Maintenance_Product_Data_Details__c where ProductsID__c in:idList and RecordTypeId = '012C50000000jefIAA'];
+                List<Maintenance_Product_Data_Details__c> exDetailList = [select Id,MultiYearWarranty__c,MultiYearWarranty__r.AgeLimit__c,MultiYearWarranty__r.MultiOneYearWarrantyPrice__c,MultiYearWarranty__r.AmountWithheld__c,AgeLimit__c,AgeLimit_Old__c,MultiOneYearWarrantyPrice__c,MultiOneYearWarrantyPrice_Old__c,AmountWithheld__c,AmountWithheld_Old__c,ProductsID__c,ProductsID__r.Name from Maintenance_Product_Data_Details__c where ProductsID__c in:idList and RecordTypeId = '012C50000000jefIAA'];
                 if(exDetailList.size() > 0){
                     for(String id: idList){
                         List<ExMpdDetailsInfo> exList = new List<ExMpdDetailsInfo>();
@@ -553,8 +553,10 @@
                         exmpdDetailsRecordsMap.put(id,exList);
                     }
                 }
+                System.debug('chenjingwu=>' + idList);
                 System.debug('chenjingwu=>' + muCountMap);
                 System.debug('chenjingwu=>' + exmpdDetailsRecordsMap);
+                System.debug('chenjingwu=>' + mpdDetailsRecords);
                 // chenjingwu 3+2澶氬勾淇濅慨   20240417 end
             } 
         }    
@@ -905,15 +907,16 @@
                         // chenjingwu 3+2澶氬勾淇濅慨 20240417 end
                         // chenjingwu 3+2澶氬勾淇濅慨 20240417 start 
                         muList = [select Id,AgeLimit__c,MultiOneYearWarrantyPrice__c,AmountWithheld__c,ProductName__r.Name,ProductName__c from MultiYearWarranty__c where ProductName__c in: idList order By ProductName__c];
-                        Integer i = 0;
+                        Integer str = 0;
                         for(MultiYearWarranty__c mu: muList){
                             Maintenance_Product_Data_Details__c insmpdd = new Maintenance_Product_Data_Details__c();
                             insmpdd.Maintenance_Product_Data__c = mpd_Name[0].id;
-                            insmpdd.Name = mpd_Name[0].Name + '-ex'+ i;
+                            insmpdd.Name = mpd_Name[0].Name + '-ex'+ str;
                             insmpdd.AgeLimit__c = mu.AgeLimit__c;
                             insmpdd.MultiYearWarranty__c = mu.Id;
                             insmpdd.MultiOneYearWarrantyPrice__c = mu.MultiOneYearWarrantyPrice__c;
                             insmpdd.AmountWithheld__c = mu.AmountWithheld__c;
+                            insmpdd.ProductsID__c = mu.ProductName__c;
 
 
                             insmpdd.AgeLimit_Old__c = mu.AgeLimit__c;
@@ -921,27 +924,27 @@
                             insmpdd.AmountWithheld_Old__c = mu.AmountWithheld__c;
                             insmpdd.RecordTypeId = '012C50000000jefIAA';
                             exIntList.add(insmpdd);
-                            i++;
+                            str++;
                         }
                     } else{
-                        Integer i = 0;
+                        Integer str = 0;
                         for(List<ExMpdDetailsInfo> li: exmpdDetailsRecordsMap.values()){
                             for(ExMpdDetailsInfo ex: li){
                                 Maintenance_Product_Data_Details__c InsAfterDel = new Maintenance_Product_Data_Details__c();
                                 InsAfterDel.Maintenance_Product_Data__c = mpd_Name[0].id;
-                                InsAfterDel.Name = mpd_Name[0].Name + '-ex'+ i;
+                                InsAfterDel.Name = mpd_Name[0].Name + '-ex'+ str;
                                 InsAfterDel.AgeLimit__c = ex.mpdrdd.AgeLimit__c;
                                 InsAfterDel.MultiYearWarranty__c = ex.mpdrdd.MultiYearWarranty__c;
                                 InsAfterDel.MultiOneYearWarrantyPrice__c = ex.mpdrdd.MultiOneYearWarrantyPrice__c;
                                 InsAfterDel.AmountWithheld__c = ex.mpdrdd.AmountWithheld__c;
-
+                                InsAfterDel.ProductsID__c = ex.mpdrdd.ProductsID__c;
 
                                 InsAfterDel.AgeLimit_Old__c = ex.Prod.AgeLimit__c;
                                 InsAfterDel.MultiOneYearWarrantyPrice_Old__c = ex.Prod.MultiOneYearWarrantyPrice__c;
                                 InsAfterDel.AmountWithheld_Old__c = ex.Prod.AmountWithheld__c;
                                 InsAfterDel.RecordTypeId = '012C50000000jefIAA';
                                 exIntList.add(InsAfterDel);
-                                i++;
+                                str++;
                             }
                         }
                     }

--
Gitblit v1.9.1