public with sharing class lexPCLLostReportLwcController { public static Product2 pro2 { get; set; } public static string oppId { get; set; } public static string lostReportId { get; set; } // 当前页面状态 Create,View and Edit, MarketEdit public static string pageStatus { get; set; } // 失单,部分失单 public static string lostType {get; set;} public static Set deleteBrandIDSet = new Set(); public static string submitFlag {get; set;} public static LostReport LostReport {get; set;} public static integer brandNo {get; set;} public static integer RemoveBrandNo {get; set;} public static integer setBrandNo {get; set;} public static integer brandCount {get; set;} // add tcm 20211122 start public static integer topNum {get; set;} public static integer secondNum {get; set;} // add tcm 20211122 end @AuraEnabled public static String getPickList(String objectName, String fieldName) { List> lstPickvals = new List>(); List results = Schema.describeSObjects(new List{objectName}); for(Schema.DescribeSobjectResult res : results) { for (Schema.PicklistEntry entry : res.fields.getMap().get(fieldName).getDescribe().getPicklistValues()) { if (entry.isActive()) { lstPickvals.add(new Map{'label' => entry.getValue(), 'value' => entry.getValue()}); } } } Map>> pickList = new Map>>(); List> zhuji = new List>(); List> jingzi = new List>(); List> xiaojingzhong = new List>(); List> nengliang = new List>(); List> qita = new List>(); Map empty = new Map{'label' => '--无--', 'value' => ''}; zhuji.add(empty); jingzi.add(empty); xiaojingzhong.add(empty); nengliang.add(empty); qita.add(empty); for (Integer i = 0; i < lstPickvals.size(); i++) { if ((i >= 0 && i <= 6) || i == 36) { zhuji.add(lstPickvals[i]); } if ((i >= 7 && i <= 23) || i == 36) { jingzi.add(lstPickvals[i]); } if ((i >= 24 && i <= 29) || i == 35) { xiaojingzhong.add(lstPickvals[i]); } if ((i >= 30 && i <= 34) || i == 36) { nengliang.add(lstPickvals[i]); } if (i == 36) { qita.add(lstPickvals[i]); } } pickList.put('主机', zhuji); pickList.put('镜子', jingzi); pickList.put('小镜种', xiaojingzhong); pickList.put('能量', nengliang); pickList.put('其他', qita); return JSON.serialize(pickList); } @AuraEnabled public static Map init (string oppId1,string lostReportId1,string pageStatus1,string lostType1,string submitFlag1){ try { oppId = oppId1; lostReportId = lostReportId1; pageStatus = pageStatus1; lostType = lostType1; submitFlag = submitFlag1; return init1(); } catch (Exception e) { throw new AuraHandledException(e.getMessage()); } } // 初始化 public static Map init1(){ Map maps = new Map(); if(string.isblank(pageStatus)) { // 这里需要报错没有传参数 maps.put('message', '页面出错,请刷新后重试!'); return maps; } else if(pageStatus.equals('Create')) { if(string.isBlank(oppId)) { // 这里报错创建时候必须有询价 maps.put('message', '创建失单报告时,请重询价页面创建'); return maps; } list opplist = [select id,Name, Sales_assistant_ID__c, Sales_manager_departmentID__c,Sales_owner_buchangID__c from opportunity where id =: oppId limit 1]; if( opplist.size() == 0) { pageStatus = null; maps.put('message', '您没有询价的查看权限,无法创建失单报告!'); return maps; } Schema.DescribeSObjectResult s = Lost_cancel_report__c.sObjectType.getDescribe(); if( !s.isCreateable()) { maps.put('message', '您不能创建失单/部分失单报告!'); return maps; } Lost_cancel_report__c tempLostReport = new Lost_cancel_report__c(LostType__c= lostType, Opportunity__c = oppId, Sales_assistant__c = opplist[0].Sales_assistant_ID__c, Manager_sales__c = opplist[0].Sales_manager_departmentID__c, Buchang_sales__c = opplist[0].Sales_owner_buchangID__c, Submit_Day__c = date.today(), Report_Status__c = '草案'); LostReport = new LostReport(tempLostReport); brandCount = 1; } else if(pageStatus.equals('View') || pageStatus.equals('Edit')) { system.debug('edit1'); if(string.isBlank(lostReportId)) { pageStatus = null; maps.put('message', '您没有查看这个失单/部分失单报告的权限!'); return maps; } system.debug('edit2'); list lostReportList = [select id,of_lost_system_processor__c, Lost_reason_main__c, Lost_Reason_Sub__c,Lost_By_Company__c, LostTotalAmount__c,LostType__c, Report_Status__c,Sales_assistant__c, InclusionUltrasound__c, //20230506 lt DB202304618804 包含超声 Opportunity__c, Opportunity__r.Sales_assistant_ID__c, Opportunity__r.Sales_manager_departmentID__c, Manager_sales__c,recordtypeid,recordtype.DeveloperName from Lost_cancel_report__c where id =: lostReportId limit 1]; if(lostReportList.size() == 0) { pageStatus = null; maps.put('message', '您没有查看这个失单/部分失单报告的权限!'); return maps; } lostReportList[0].Sales_assistant__c = lostReportList[0].Opportunity__r.Sales_assistant_ID__c; lostReportList[0].Manager_sales__c = lostReportList[0].Opportunity__r.Sales_manager_departmentID__c; if(lostReportList[0].recordtype.DeveloperName.equals('PCL_Lost_report')) { lostReportList[0].LostType__c ='失单'; }else if(lostReportList[0].recordtype.DeveloperName.equals('PCL_PartLost_report')) { lostReportList[0].LostType__c ='部分失单'; } // 权限,如果当前状态不是草案中,那么需要跳转到只读页面 //原:!'草案'.equals(lostReportList[0].Report_Status__c) && userinfo.getProfileId() != (ID) '00e10000000Y3o5AAC' // 20230814 lt DB202308068183 失单报告审批节点增加助理审批节点 end 改if条件 if( !('草案'.equals(lostReportList[0].Report_Status__c) || userinfo.getProfileId() == (ID) '00e10000000Y3o5AAC' ||('批准'.equals(lostReportList[0].Report_Status__c) && (userinfo.getProfileId() == (ID) '00e10000000xnp2AAA' || userinfo.getProfileId() == (ID) '00e10000000xnpRAAQ' || userinfo.getProfileId() == (ID) '00e10000000xnpHAAQ')) ) ){ pageStatus = 'View'; } oppId = lostReportList[0].Opportunity__c; system.debug('edit3'); list selectlostBrandList = [ select id, LostPrice__c, Lost_By_Company__c, Lost_reason_main__c,Lost_Reason_Sub__c,Name,Agency__c, AgencyMannual__c, // ProductCategory__c,ProductClass__c, Lost_cancel_report__c,Lost_By_Company_Mannual__c, ( select id,PCLLostBrand__c,LostProduct__c, LostProductMannual__c, //SWAG-C6P9PX lt 20210913 add ProductCategory__c,ProductClass__c, //add tcm 20211123 Quantity__c,Name, LostBrandName__c from PCLLostBrand__c.PCLLostBrandProduct__r) from PCLLostBrand__c where Lost_cancel_report__c =: lostReportId ]; if(selectlostBrandList.size() == 0 ) { LostReport = new LostReport(lostReportList[0]); brandCount = 1; }else{ system.debug('edit4:'+selectlostBrandList[0]); brandCount = 0; list LostBrandList = new list(); for(PCLLostBrand__c templostBrand : selectlostBrandList) { list tempProductList = new list(); integer productCount = 0; system.debug('check products:'+ (templostBrand.PCLLostBrandProduct__r != null) + '|' + (templostBrand.PCLLostBrandProduct__r.size() > 0)); if (templostBrand.PCLLostBrandProduct__r != null && templostBrand.PCLLostBrandProduct__r.size() > 0) { for( PCLLostProduct__c tempProduct: templostBrand.PCLLostBrandProduct__r) { tempProductList.add(new PCLLostProducts(productCount,tempProduct)); productCount++; } } else { PCLLostProducts newProduct = new PCLLostProducts(); if ('其他'.equals(templostBrand.Lost_By_Company__c) && templostBrand.Lost_By_Company_Mannual__c != null && !''.equals(templostBrand.Lost_By_Company_Mannual__c)) { newProduct.LostProductss.LostBrandName__c = templostBrand.Lost_By_Company_Mannual__c; } else { newProduct.LostProductss.LostBrandName__c = templostBrand.Lost_By_Company__c; } system.debug('aaa4+++'+templostBrand.Lost_By_Company_Mannual__c); tempProductList.add(newProduct); productCount++; } LostBrandList.add( new LostBrand(brandCount,tempProductList, templostBrand)); brandCount++; } LostReport = new LostReport(lostReportList[0],LostBrandList); system.debug('LostReport.LostBrands:'+LostReport.LostBrands); } } brandNo = 0; // 读取竞争对手品牌 // BrandmapSet(); if (LostReport.lostReport.Report_Status__c != '草案' && lostReportId != null) { ProcessInstance pro = [ SELECT ProcessDefinition.Name, ( SELECT Id, StepStatus, IsPending, Comments, CreatedDate, Actor.Name, OriginalActor.Name, ProcessNode.Name FROM StepsAndWorkitems order by IsPending DESC, CreatedDate DESC ) FROM ProcessInstance where TargetObjectId =:LostReport.lostReport.id order by CreatedDate DESC ]; List items = new List(); items.addall(pro.StepsAndWorkitems); LostReport.approvalHistorys = items; } if(string.isNotEmpty(submitFlag)) { maps.put('message', '提交成功!'); maps.put('LostReport', LostReport); return maps; } // List> col = new List>(); // Map ele = new Map(); // LostReport.LostBrands[0].columns.add(); maps.put('LostReport', LostReport); return maps; } @AuraEnabled public static String searchBrands(){ String ObjectApi_name = 'PCLLostBrand__c'; String Field_name = 'Lost_By_Company__c'; //From the Object Api name retrieving the SObject Schema.SObjectType targetType = Schema.getGlobalDescribe().get(ObjectApi_name); Sobject Object_name = targetType.newSObject(); //grab the sobject that was passed Schema.sObjectType sobject_type = Object_name.getSObjectType(); //describe the sobject Schema.DescribeSObjectResult sobject_describe = sobject_type.getDescribe(); //get a map of fields for the passed sobject Map field_map = sobject_describe.fields.getMap(); //grab the list of picklist values for the passed field on the sobject List pick_list_values = field_map.get(Field_name).getDescribe().getPickListValues(); List> lstPickvals = new List>(); for (Schema.PicklistEntry a : pick_list_values) { //for all values in the picklist list lstPickvals.add(new Map{'label' => a.getValue(), 'value' => a.getValue()}); } String jsonStr = JSON.serialize(lstPickvals); return jsonStr; } @AuraEnabled public static string searchBatchIfForProduct(String productName){ try { List transfer = [select Internal_value__c from BatchIF_Transfer__c where Dropped_Flag__c = false and Table__c = 'PCLLostBrand__c' and Column__c = 'Lost_By_Company__c' and External_value__c =: productName]; return transfer[0].Internal_value__c; } catch (Exception e) { throw new AuraHandledException(e.getMessage()); } } // 数据录入 @AuraEnabled public static Map dataEntry(String report1,List deleteBrandIdList,List deleteProductIdList){ LostReport report = (LostReport)JSON.deserialize(report1, LostReport.class); Map messageMap = new Map (); system.debug('save---start:'); Savepoint sp = Database.setSavepoint(); try{ // 待完成,这里需要把第一个品牌的信息赋值到这个失单报告上去,还有需要把各个品牌金额汇总加起来; //system.debug('LostReport.LostBrands:'+LostReport.LostBrands); // 设置记录类型 report.lostReport.recordTypeID = report.lostReport.LostType__c== '失单'?Schema.SObjectType.Lost_cancel_report__c.getRecordTypeInfosByDeveloperName().get('PCL_Lost_report').getRecordTypeId() : Schema.SObjectType.Lost_cancel_report__c.getRecordTypeInfosByDeveloperName().get('PCL_PartLost_report').getRecordTypeId(); report.lostReport.LostTotalAmount__c = 0; report.lostReport.of_lost_system_processor__c = 0; report.lostReport.Lost_reason_main__c = null; report.lostReport.Lost_Reason_Sub__c = null; report.lostReport.Lost_By_Company__c = null; for(LostBrand tempLostBrand : report.LostBrands) { if(string.isNotBlank(tempLostBrand.lostBrand.Lost_By_Company__c)) { report.lostReport.LostTotalAmount__c += tempLostBrand.lostBrand.LostPrice__c; report.lostReport.Lost_reason_main__c = report.lostReport.Lost_reason_main__c == null ? tempLostBrand.lostBrand.Lost_reason_main__c : report.lostReport.Lost_reason_main__c; report.lostReport.Lost_Reason_Sub__c = report.lostReport.Lost_Reason_Sub__c == null ? tempLostBrand.lostBrand.Lost_Reason_Sub__c : report.lostReport.Lost_Reason_Sub__c; report.lostReport.Lost_By_Company__c = report.lostReport.Lost_By_Company__c == null ? tempLostBrand.lostBrand.Lost_By_Company__c : report.lostReport.Lost_By_Company__c; for( PCLLostProducts tempLostProduct : tempLostBrand.LostProducts) { if(tempLostProduct.LostProductss.Quantity__c !=null && tempLostProduct.LostProductss.Quantity__c >0) { report.lostReport.of_lost_system_processor__c += tempLostProduct.LostProductss.Quantity__c; } } } } upsert report.lostReport; String reportId = report.lostReport.Id; messageMap.put('reportId', reportId); // 需要插入更新的失单品牌 map upsertLostBrandMap = new map(); // 需要删掉的失单品牌 map deleteLostBrandMap = new map(); // 需要插入更新的失单型号,key是品牌编号+型号编号,value是需要更新的失单型号 map upsertLostProductMap = new map(); // 需要删掉的失单品牌 list deleteLostProductList = new list(); Integer lineNo = 0; for(LostBrand tempLostBrand : report.LostBrands ) { // 如果有失单品牌,那么就要插入更新; system.debug('tempLostBrand.lostBrand.Lost_By_Company__c:'+tempLostBrand.lostBrand.Lost_By_Company__c); if(string.isNotBlank(tempLostBrand.lostBrand.Lost_By_Company__c)) { upsertLostBrandMap.put(lineNo,tempLostBrand.lostBrand); tempLostBrand.lostBrand.Lost_cancel_report__c = report.lostReport.Id; tempLostBrand.lostBrand.Name = tempLostBrand.lostBrand.Lost_By_Company__c; integer tempNo = 0; for( PCLLostProducts tempLostProduct : tempLostBrand.LostProducts) { system.debug('Name:'+ tempLostProduct.LostProductss.Name ); if(tempLostProduct.LostProductss.Quantity__c !=null && tempLostProduct.LostProductss.Quantity__c >0) { tempLostProduct.LostProductss.Name = tempLostBrand.lostBrand.Name + tempLostProduct.LostProductss.Quantity__c; upsertLostProductMap.put(lineNo +':'+ tempNo,tempLostProduct.LostProductss); }else if(string.isNotBlank(tempLostProduct.LostProductss.Id)) { deleteLostProductList.add(tempLostProduct.LostProductss); } tempNo++; } } // 如果没有品牌,但是有id, 这样数据需要删除 else if(string.isNotBlank(tempLostBrand.lostBrand.Id )) { deleteLostBrandMap.put(lineNo,tempLostBrand.lostBrand); // 这里可能需要也判断一下失单型号有没有需要删掉 } lineNo++; } if(upsertLostBrandMap.size()>0) { upsert upsertLostBrandMap.values(); } for( string productNo :upsertLostProductMap.keyset()) { PCLLostProduct__c tempLostProduct = upsertLostProductMap.get(productNo); integer brandNo = integer.valueof(productNo.split(':')[0]); tempLostProduct.PCLLostBrand__c = upsertLostBrandMap.get(brandNo).Id; } if(upsertLostProductMap.size()>0) { upsert upsertLostProductMap.values(); } if(deleteLostBrandMap.size()>0) { delete deleteLostBrandMap.values(); for(PCLLostBrand__c pcl: deleteLostBrandMap.values()) { pcl.Id = null; } } if (deleteProductIdList.size()>0) { database.delete(deleteProductIdList); } if (deleteBrandIdList.size()>0) { database.delete(deleteBrandIdList); } if(deleteLostProductList.size()>0) { delete deleteLostProductList; for(PCLLostProduct__c pclp: deleteLostProductList) { pclp.Id = null; } } if(deleteBrandIDSet.size() > 0) { list tempdeleteIDlist = new list(); tempdeleteIDlist.addall(deleteBrandIDSet); database.delete(tempdeleteIDlist); } for(integer brandNumber =0; brandNumber< report.LostBrands.size(); brandNumber++) { LostBrand tempLostBrand = report.LostBrands.get(brandNumber); if(tempLostBrand.lostBrand.Id == null) { report.LostBrands.remove(brandNumber); brandNumber--; continue; } for(integer productNumber = 0; productNumber< tempLostBrand.LostProducts.size(); productNumber++) { PCLLostProducts tempLostProduct = tempLostBrand.LostProducts.get(productNumber); if(tempLostProduct.LostProductss.Id == null) { tempLostBrand.LostProducts.remove(productNumber); productNumber--; continue; } } } if (report.lostReport.Report_Status__c != '草案') { ProcessInstance pro = [ SELECT ProcessDefinition.Name, ( SELECT Id, StepStatus, IsPending, Comments, CreatedDate, Actor.Name, OriginalActor.Name, ProcessNode.Name FROM StepsAndWorkitems order by IsPending DESC, CreatedDate DESC ) FROM ProcessInstance where TargetObjectId =:reportId order by CreatedDate DESC ]; List items = new List(); items.addall(pro.StepsAndWorkitems); report.approvalHistorys = items; } // lostReportId = report.lostReport.id; system.debug('save---end:'); messageMap.put('LostReport',JSON.serialize(report)); }catch (Exception ex) { Database.rollback(sp); // 这里需要写一些报错信息 messageMap.put('error', ex.getMessage()); return messageMap; } return messageMap; } // 提交 @AuraEnabled public static Map submit(String report1,String reportId){ LostReport report = (LostReport)JSON.deserialize(report1, LostReport.class); Map messages = new Map(); if(!'草案'.equals(report.lostReport.Report_Status__c) ) { messages.put('error', '只有在草案中才能提交申请!'); return messages; } Map objs = new Map(); Savepoint sp = Database.setSavepoint(); try{ report.lostReport.Id = reportId; report.lostReport.Report_Status__c = '提交'; update report.lostReport; // Approval.ProcessSubmitRequest psr = new Approval.ProcessSubmitRequest(); // psr.setObjectId(reportId); // Approval.ProcessResult submitResult = Approval.process(psr); objs.put('uri', '/apex/PCLLostReportPage'); objs.put('Id', reportId); objs.put('pageStatus', 'View'); objs.put('submitFlag', '1'); ProcessInstance pro = [ SELECT ProcessDefinition.Name, ( SELECT Id, StepStatus, IsPending, Comments, CreatedDate, Actor.Name, OriginalActor.Name, ProcessNode.Name FROM StepsAndWorkitems order by IsPending DESC, CreatedDate DESC ) FROM ProcessInstance where TargetObjectId =:reportId order by CreatedDate DESC ]; List items = new List(); items.addall(pro.StepsAndWorkitems); objs.put('approvalHistorys',items); return objs; }catch(exception ex) { Database.rollback(sp); messages.put('error', ex.getMessage()); return messages; } } // +++++++++++++++++++++++++++++++++++++++++++++++++++++++ @AuraEnabled public static LostBrand getNewLostBrand(Integer lineNo){ LostBrand lostBrand = null; try { //report.LostBrands.add(new LostBrand(report.LostBrands.size())); lostBrand = new LostBrand(lineNo); } catch (Exception e) { System.debug(e.getMessage()); } return lostBrand; } @AuraEnabled public static PCLLostProducts getNewLostProduct(Integer lineNo2){ PCLLostProducts pro = null; try { pro = new PCLLostProducts(lineNo2); } catch (Exception e) { System.debug(e.getMessage()); } return pro; } // update tcm 20211125 添加型号时自动带出品牌 end // 页面的数据结构 public class LostReport { @AuraEnabled public Lost_cancel_report__c lostReport { get; set; } @AuraEnabled public list LostBrands { get; set; } @AuraEnabled public list approvalHistorys { get; set; } public LostReport(){ lostReport = new Lost_cancel_report__c(); LostBrands = new list {new LostBrand(0)}; approvalHistorys = new list(); } public LostReport(Lost_cancel_report__c lostReport){ this.lostReport = lostReport; LostBrands = new list {new LostBrand(0)}; approvalHistorys = new list(); } public LostReport(Lost_cancel_report__c lostReport, list LostBrands){ this.lostReport = lostReport; this.LostBrands = LostBrands; approvalHistorys = new list(); } } public class LostBrand { @AuraEnabled public PCLLostBrand__c lostBrand; @AuraEnabled public Integer lineNo; @AuraEnabled public list LostProducts; @AuraEnabled public Integer ProductSize; public LostBrand( integer lineNo ){ lostBrand = new PCLLostBrand__c(); this.lineNo = lineNo; LostProducts = new list {new PCLLostProducts()}; ProductSize = 1; lostBrand = new PCLLostBrand__c(); } public LostBrand( integer lineNo, list LostProducts ){ lostBrand = new PCLLostBrand__c(); this.lineNo = lineNo; this.LostProducts = LostProducts; ProductSize = LostProducts.size(); } public LostBrand( integer lineNo, list LostProducts, PCLLostBrand__c lostBrand){ this.lostBrand = lostBrand; this.lineNo = lineNo; this.LostProducts = LostProducts; ProductSize = LostProducts.size(); } } // add tcm 20211119 start public class PCLLostProducts { @AuraEnabled public Integer lineNo2; @AuraEnabled public PCLLostProduct__c LostProductss; @AuraEnabled public Boolean bool; @AuraEnabled public String productName; @AuraEnabled public List> productOptions = new List>(); public PCLLostProducts() { this.lineNo2 = 0; this.LostProductss=new PCLLostProduct__c(); } public PCLLostProducts(Integer lineNo2) { this.lineNo2 = lineNo2; this.LostProductss=new PCLLostProduct__c(); } public PCLLostProducts(Integer lineNo2,PCLLostProduct__c LostProductss) { this.lineNo2 = lineNo2; this.LostProductss=LostProductss; if (LostProductss.LostProduct__c != null) { this.bool = true; } } } // add tcm 20211119 end // add tcm 20211118 start public static void search() { if (LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.LostProduct__c==null) { LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductClass__c=null; LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductCategory__c=null; LostReport.LostBrands[topNum].LostProducts[secondNum].bool=false; }else { Product2 prd = [select Id,ProductClass__c, ProductCategory__c from Product2 where Id =:LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.LostProduct__c]; if (prd.ProductCategory__c!=null) { LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductClass__c=prd.ProductClass__c; LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductCategory__c=prd.ProductCategory__c; LostReport.LostBrands[topNum].LostProducts[secondNum].bool=true; }else { LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductClass__c=null; LostReport.LostBrands[topNum].LostProducts[secondNum].LostProductss.ProductCategory__c=null; LostReport.LostBrands[topNum].LostProducts[secondNum].bool=false; } } } @AuraEnabled public static string searchProduct(String lostProduct){ Product2 prd = null; try { prd = [select Id,ProductClass__c, ProductCategory__c from Product2 where Id =:lostProduct]; } catch (Exception e) { throw new AuraHandledException(e.getMessage()); } return JSON.serialize(prd); } // add tcm 20211118 end }