From 0f44cb1a0b7b36860e9ce81c1eac9e395d87f0b4 Mon Sep 17 00:00:00 2001 From: buli <137736985@qq.com> Date: 星期一, 05 六月 2023 13:53:18 +0800 Subject: [PATCH] mergecode into lex dtt --- force-app/main/default/classes/LexConsumableController.cls | 495 ++++++++++++++++++------------------------------------ 1 files changed, 163 insertions(+), 332 deletions(-) diff --git a/force-app/main/default/classes/LexConsumableController.cls b/force-app/main/default/classes/LexConsumableController.cls index 4e69309..ae8b99b 100644 --- a/force-app/main/default/classes/LexConsumableController.cls +++ b/force-app/main/default/classes/LexConsumableController.cls @@ -105,6 +105,8 @@ // 鐧诲綍鑰呭伐浣滃湴 private static String userWorkLocation; public static String agencyProType { get; set; } + public static String agencyProType1 {get;set;} //lt 20230526 瀹夊窘涓ょエ鍒� add + private static Boolean OSHFLG;//lt 20230517 瀹夊窘涓ょエ鍒� add public static String methodType { get; set; } public static String hospitalName { get; set; } public static String hospitalId { get; set; } @@ -165,9 +167,11 @@ if (selectedIdMap.containsKey(consumableorderdetailsRecords[i].Prod.Id)) { addNo++; //continue; - } else if (consumableorderdetailsRecordsview.size() >= pageLimit + size) { - break; - } else { + } + // else if (consumableorderdetailsRecordsview.size() >= pageLimit + size) { + // break; + // } + else { if (consumableorderdetailsRecords[i].check == false) { consumableorderdetailsRecords[i].esd = orderdetails1; } @@ -175,8 +179,8 @@ consumableorderdetailsRecordsview.add(consumableorderdetailsRecords[i]); addNo++; } - if (addNo >= size) - break; + // if (addNo >= size) + // break; } return consumableorderdetailsRecordsview; } @@ -184,6 +188,7 @@ @AuraEnabled public static Results init(String type, String esetId, String keywordStr) { Results results = new Results(); + results.isNoteStay = LexUtility.getIsNoteStay(); errorMsgList = new List<String>(); warningMsgList = new List<String>(); baseUrl = URL.getSalesforceBaseUrl().toExternalForm(); @@ -226,10 +231,21 @@ } userId = UserInfo.getUserId(); List<user> Useracc = new List<user>(); - Useracc = [SELECT accountid, Work_Location__c, UserPro_Type__c FROM user WHERE id = :userId]; + //lt 20230517 瀹夊窘涓ょエ鍒� add ,OSHFLG__c + Useracc = [SELECT accountid, Work_Location__c,UserPro_Type__c,OSHFLG__c FROM user WHERE id = :userId ]; accountid = Useracc[0].accountid; userWorkLocation = Useracc[0].Work_Location__c; agencyProType = Useracc[0].UserPro_Type__c; + agencyProType1 = Useracc[0].UserPro_Type__c; //lt 20230526 瀹夊窘涓ょエ鍒� add + //lt 20230526 瀹夊窘涓ょエ鍒� start + OSHFLG = Useracc[0].OSHFLG__c; //lt 20230517 瀹夊窘涓ょエ鍒� add + if(OSHFLG){ + agencyProType1 = 'OSH'; + } + else if(String.isBlank(Useracc[0].UserPro_Type__c)){ + agencyProType1 = 'ET'; + } + //lt 20230526 瀹夊窘涓ょエ鍒� end if (String.isBlank(Useracc[0].UserPro_Type__c)) { agencyProType = 'ET'; } @@ -248,8 +264,9 @@ RecordType.DeveloperName = 'AgencyContract' AND Contract_Decide_Start_Date__c <= :dateToday AND Contract_Decide_End_Date__c >= :dateToday - AND Contact_Type__c LIKE :agencyProType - AND Agent_Ref__c = :accountid + and Contact_Type__c like :agencyProType1//lt 20230517 瀹夊窘涓ょエ鍒� add 1 + and Agent_Ref__c =:accountid + and OSH_Dealer__c =: OSHFLG //lt 20230517 瀹夊窘涓ょエ鍒� add ]; for (Account contract : contractList) { contactDealer.add(contract.Id); @@ -313,9 +330,10 @@ FROM Account WHERE ParentId = :accountid - AND Contact_Type__c LIKE :agencyProType + AND Contact_Type__c like :agencyProType1 //lt 20230517 瀹夊窘涓ょエ鍒� add 1 AND Contract_Decide_Start_Date__c <= :Date.Today() AND Contract_Decide_End_Date__c >= :Date.Today() + AND OSH_Dealer__c =: OSHFLG //lt 20230517 瀹夊窘涓ょエ鍒� add ]; if (contract.size() == 1) { contractName = contract[0].Name; @@ -440,9 +458,12 @@ AND Consumable_order__r.Dealer_Info__c = :accountid ]; for (Consumable_Orderdetails__c cdc1 : ConsumableorderdetailsSelected) { - orderzaikuId.add(cdc1.Consumable_Product__c); + if(cdc1.Consumable_Product__c != null){ + orderzaikuId.add(cdc1.Consumable_Product__c); + } } soql = makeSoqlorderdet(); + System.debug('soql:'+soql); size = orderzaikuId.size(); initStandardController(); product2Selected = Database.query(soql); @@ -516,12 +537,19 @@ } } //闄勪欢 - attachmentinfo = [SELECT Id, Name, OwnerId, Owner.Name FROM Attachment WHERE parentid = :ESetId]; - if (attachmentinfo.size() > 0) { - for (Integer i = 0; i < attachmentinfo.size(); i++) { - attachmentRecoeds.add(new ConsumableorderdetailsInfo(attachmentinfo[i])); + // attachmentinfo = [SELECT Id, Name, OwnerId, Owner.Name FROM Attachment WHERE parentid = :ESetId]; + // if (attachmentinfo.size() > 0) { + // for (Integer i = 0; i < attachmentinfo.size(); i++) { + // attachmentRecoeds.add(new ConsumableorderdetailsInfo(attachmentinfo[i])); + // } + // } + List<ContentVersion> cvInfo = [SELECT Id, Title, OwnerId,Owner.Name, CreatedDate,ContentDocumentId FROM ContentVersion WHERE FirstPublishLocationId = :ESetId]; + if (cvInfo.size() > 0) { + for (Integer i = 0; i < cvInfo.size(); i++) { + attachmentRecoeds.add(new ConsumableorderdetailsInfo(cvInfo[i])); } } + // consumableorderdetailsRecords.sort(); getPageInfo(); } @@ -532,8 +560,10 @@ List<String> upper = new List<String>(); if (String.isNotBlank(ESetid)) { for (ConsumableorderdetailsInfo bss : consumableorderdetailsRecords) { - if (bss.esd.Consumable_count__c + bss.allnumber > bss.upperlimit) { - upper.add(bss.esd.Consumable_Product__r.Name__c); + if(bss.esd.Consumable_count__c != null && bss.allnumber != null && bss.upperlimit != null){ + if (bss.esd.Consumable_count__c + bss.allnumber > bss.upperlimit) { + upper.add(bss.esd.Consumable_Product__r.Name__c); + } } } } @@ -583,6 +613,8 @@ // category5OptionList.add(new SelectOption('', '-鏃�-')); category5Option.add(new CusOption('-鏃�-','')); //return msg + consumableorderdetailsRecordsview = consumableorderdetailsRecords; + getConsumableShowTableFieldValue(); results.result = 'Success'; results.coc = coc; results.editAble = editAble; @@ -597,6 +629,8 @@ results.attachmentRecoeds = attachmentRecoeds; results.cansee = cansee; results.agencyProType = agencyProType; + results.agencyProType1 = agencyProType1; + results.OSHFLG = OSHFLG; results.userWorkLocation = userWorkLocation; results.accountName = accountName; results.category_Goods = category_Goods; @@ -828,300 +862,6 @@ } } - //搴撳瓨鎺掑簭 - public static void SortStore() { - if (sortKey == preSortKey) { - // 鏂瑰悜銇屽銈忋倠銇伩 - sortOrderAsc = !sortOrderAsc; - sortOrder[Integer.valueOf(sortKey)] = (sortOrderAsc == true ? '鈫�' : '鈫�'); - } else { - sortOrderAsc = true; - sortOrder[Integer.valueOf(preSortKey)] = ' '; - sortOrder[Integer.valueOf(sortKey)] = (sortOrderAsc == true ? '鈫�' : '鈫�'); - } - preSortKey = sortKey; - List<ConsumableorderdetailsInfo> selectedSort = new List<ConsumableorderdetailsInfo>(); - List<ConsumableorderdetailsInfo> noselectedSort = new List<ConsumableorderdetailsInfo>(); - for (ConsumableorderdetailsInfo ass : consumableorderdetailsRecordsview) { - ass.sortBy = sortOrderAsc; - if (ass.check == true) { - selectedSort.add(ass); - } else { - noselectedSort.add(ass); - } - } - consumableorderdetailsRecordsview = new List<ConsumableorderdetailsInfo>(); - if (selectedSort.size() > 0) { - if (searchDone != 'searchDone') { - selectedSort.sort(); - } - consumableorderdetailsRecordsview.addAll(selectedSort); - } - if (noselectedSort.size() > 0) { - noselectedSort.sort(); - consumableorderdetailsRecordsview.addAll(noselectedSort); - } - } - - //闄愬埗鎬ф帓搴� - public static void SortLimited() { - List<ConsumableorderdetailsInfo> reSet = new List<ConsumableorderdetailsInfo>(); - Map<String, ConsumableorderdetailsInfo> MidMap = new Map<String, ConsumableorderdetailsInfo>(); - List<Consumable_order_details2__c> countDel = [ - SELECT - Id, - Bar_Code__c, - Name, - Inventory_date__c, - Consumable_Product__c, - Consumable_Product__r.Asset_Model_No__c, - Recordtypeid, - Box_Piece__c, - hospitalSpecialOffer__c, - promotionorder__c - FROM Consumable_order_details2__c - WHERE - Dealer_Arrive__c = TRUE - AND Dealer_Shipment__c = FALSE - AND Dealer_Saled__c = FALSE - AND Dealer_Returned__c = FALSE - AND Lose_Flag__c = FALSE - AND Bar_Code__c != NULL - AND Arrive_Owner_Work_Location__c = :userWorkLocation - //AND Consumable_order_minor__r.Dealer_Info__c = :accountid - AND Dealer_Info_text__c = :accountName - ]; - if (sortKey == preSortKey) { - // 鏂瑰悜銇屽銈忋倠銇伩 - sortOrderAsc = !sortOrderAsc; - sortOrder[Integer.valueOf(sortKey)] = (sortOrderAsc == true ? '鈫�' : '鈫�'); - } else { - sortOrderAsc = true; - sortOrder[Integer.valueOf(preSortKey)] = ' '; - sortOrder[Integer.valueOf(sortKey)] = (sortOrderAsc == true ? '鈫�' : '鈫�'); - } - preSortKey = sortKey; - // 鎵�鏈変骇鍝佸彇寰� - if ( - (EsetId == null || ESetId == '') || (EsetId != null && ESetId != '' && statusEdit == 'Redirect' && searchDone == 'searchDone') - ) { - String strProd = null; - for (ConsumableorderdetailsInfo ass : consumableorderdetailsRecordsview) { - if (strProd == null || strProd.length() == 0) { - strProd = '\'' + String.valueOf(ass.prod.Id) + '\''; - } else { - strProd += ',\'' + String.valueOf(ass.prod.Id) + '\''; - } - } - String soqll = 'SELECT Id, Name,Name__c,Intra_Trade_List_RMB__c,Asset_Model_No__c,SFDA_Status__c,Product2__r.SFDA_Approbation_No__c,Product2__r.SFDA_Expiration_Date__c,Product2__r.Packing_list_manual__c,Category3__c,Category4__c,Category5__c FROM Product2__c WHERE Estimation_Entry_Possibility__c = \'鈼媆' '; - //update by rentx 2020-12-31 start - if (agencyProType == 'ET') { - soqll += ' AND Pro2_Dealer_Object__c = true'; - } - if (agencyProType == 'ENG') { - soqll += ' AND Pro2_Dealer_ENG__c = true'; - } - soqll += ' AND Intra_Trade_List_RMB__c > 0 '; - //update by rentx 2020-12-31 end - soqll += ' AND Id IN (' + strProd + ')'; - soqll += - ' order by ' + - columus_no[Integer.valueOf(sortKey)] + - ' ' + - (sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last'); - List<Product2__c> queryList = Database.query(soqll); - // 閬告姙娓堛伩銇槑缁嗐倰鍙栧緱 - Map<String, String> selectedIdMap = new Map<String, String>(); - for (ConsumableorderdetailsInfo ass : consumableorderdetailsRecordsview) { - if (ass.check == true) { - selectedIdMap.put(ass.Prod.id, ass.Prod.id); - reSet.add(ass); - } - } - for (Integer i = 0; i < queryList.size(); i++) { - if (selectedIdMap.containsKey(queryList[i].Id)) { - // 璺宠繃宸茬粡閫夋嫨鐨勬秷鑰楀搧鏄庣粏 - continue; - } else { - // 鏈�夋嫨鐨勬秷鑰楀搧鏄庣粏 - MidMap.put(queryList[i].Id, new ConsumableorderdetailsInfo(queryList[i])); - } - } - consumableorderdetailsRecordsview = new List<ConsumableorderdetailsInfo>(); - consumableorderdetailsRecordsview = reSet; - for (Integer i = 0; i < countDel.size(); i++) { - if (String.isNotBlank(methodType) && methodType.equals('hospitalorder')) { - if (countDel[i].hospitalSpecialOffer__c == true) { - //鐒跺悗寰幆CountDel鍘讳慨鏀筸ap閲岀殑allnumber - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } else if (String.isBlank(methodType) || methodType.equals('promotionorder')) { - if (countDel[i].promotionorder__c == true) { - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } else if (String.isBlank(methodType) || (!methodType.equals('promotionorder') && !methodType.equals('hospitalorder'))) { - if (countDel[i].promotionorder__c == false && countDel[i].hospitalSpecialOffer__c == false) { - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } - } - //鎶妋ap閲岀殑鍊间粠鏂拌祴缁機onsumableorderdetailsRecords - for (ConsumableorderdetailsInfo bss : MidMap.values()) { - if (selectedIdMap.containsKey(bss.Prod.Id)) { - continue; - } else { - if (DealerProductMap.containsKey(bss.Prod.Id)) { - bss.SpecialCampaignPrice = DealerProductMap.get(bss.Prod.Id).Special_Campaign_Price__c; - bss.Campaign_EndDate = DealerProductMap.get(bss.Prod.Id).Campaign_EndDate__c; - bss.orderGoods_Limit = DealerProductMap.get(bss.Prod.Id).OrderGoods_Limit__c; - } - bss.packing_list = Integer.valueOf(bss.Prod.Product2__r.Packing_list_manual__c); - bss.approbation_No = bss.Prod.Product2__r.SFDA_Approbation_No__c; - bss.expiration_Date = bss.Prod.Product2__r.SFDA_Expiration_Date__c; - - consumableorderdetailsRecordsview.add(bss); - } - } - } else if (searchDone != 'searchDone') { - String strProd = null; - for (ConsumableorderdetailsInfo ass : consumableorderdetailsRecordsview) { - if (strProd == null || strProd.length() == 0) { - strProd = '\'' + String.valueOf(ass.prod.Id) + '\''; - } else { - strProd += ',\'' + String.valueOf(ass.prod.Id) + '\''; - } - } - String SqlOrder = 'SELECT Id, Name, Consumable_order__c, Consumable_Product__r.Name__c,'; - SqlOrder += ' Consumable_Product__c,Consumable_Product__r.Name,'; - SqlOrder += 'Consumable_Count__c,Consumable_Product__r.Intra_Trade_List_RMB__c,'; - SqlOrder += 'Consumable_Product__r.Asset_Model_No__c,Sum_of_money__c, '; - SqlOrder += 'Consumable_Product__r.SFDA_Status__c,Consumable_Product__r.Product2__r.Packing_list_manual__c,Consumable_Product__r.Product2__r.SFDA_Approbation_No__c,'; - SqlOrder += 'Consumable_Product__r.Product2__r.SFDA_Expiration_Date__c,Consumable_Product__r.Category3__c,Consumable_Product__r.Category4__c,Consumable_Product__r.Category5__c '; - SqlOrder += - 'FROM Consumable_orderdetails__c WHERE recordtypeid != \'' + - System.Label.RT_ConOrderDetail1_Sale + - '\' AND Consumable_order__c = \'' + - ESetId + - '\''; - SqlOrder += ' AND Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' '; - SqlOrder += ' AND Consumable_Product__c IN (' + strProd + ')'; - SqlOrder += - ' order by ' + - columus[Integer.valueOf(sortKey)] + - ' ' + - (sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last'); - List<Consumable_Orderdetails__c> queryList = Database.query(SqlOrder); - // 閬告姙娓堛伩銇槑缁嗐倰鍙栧緱 - Map<String, String> selectedIdMap = new Map<String, String>(); - for (Integer i = 0; i < queryList.size(); i++) { - // 鏈�夋嫨鐨勬秷鑰楀搧鏄庣粏 - MidMap.put(queryList[i].Consumable_Product__c, new ConsumableorderdetailsInfo(queryList[i])); - } - for (Integer i = 0; i < countDel.size(); i++) { - if (String.isNotBlank(methodType) && methodType.equals('hospitalorder')) { - if (countDel[i].hospitalSpecialOffer__c == true) { - //鐒跺悗寰幆CountDel鍘讳慨鏀筸ap閲岀殑allnumber - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } else if (String.isBlank(methodType) || methodType.equals('promotionorder')) { - if (countDel[i].promotionorder__c == true) { - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } else if (String.isBlank(methodType) || (!methodType.equals('promotionorder') && !methodType.equals('hospitalorder'))) { - if (countDel[i].promotionorder__c == false && countDel[i].hospitalSpecialOffer__c == false) { - if (MidMap.containsKey(countDel[i].Consumable_Product__c)) { - ConsumableorderdetailsInfo Jstage = MidMap.get(countDel[i].Consumable_Product__c); - if (countDel[i].Box_Piece__c == '鐩�') { - Jstage.allnumber = Jstage.allnumber + 1; - } else { - Jstage.allnumber_piece = Jstage.allnumber_piece + 1; - } - MidMap.put(countDel[i].Consumable_Product__c, Jstage); - } - } - } - } - consumableorderdetailsRecordsview = new List<ConsumableorderdetailsInfo>(); - //鎶妋ap閲岀殑鍊间粠鏂拌祴缁機onsumableorderdetailsRecords - for (ConsumableorderdetailsInfo bss : MidMap.values()) { - if (DealerProductMap.containsKey(bss.Prod.Id)) { - bss.SpecialCampaignPrice = DealerProductMap.get(bss.Prod.Id).Special_Campaign_Price__c; - bss.Campaign_EndDate = DealerProductMap.get(bss.Prod.Id).Campaign_EndDate__c; - bss.orderGoods_Limit = DealerProductMap.get(bss.Prod.Id).OrderGoods_Limit__c; - } - bss.packing_list = Integer.valueOf(bss.Prod.Product2__r.Packing_list_manual__c); - bss.approbation_No = bss.Prod.Product2__r.SFDA_Approbation_No__c; - bss.expiration_Date = bss.Prod.Product2__r.SFDA_Expiration_Date__c; - consumableorderdetailsRecordsview.add(bss); - } - } - productLimtAndDateView(); - } - - //搴撳瓨涓婁笅闄� - public static void productLimtAndDateView() { - String nowName = null, nowRightAsstModelNo = null; - Map<String, String> productLimt = new Map<String, String>(); - for (Integer i = 0; i < proLimitAndDate.size(); i++) { - nowName = proLimitAndDate[i]; - if (nowName.indexOf('|') >= 0) { - nowRightAsstModelNo = nowName.subString(0, nowName.indexOf('|')); - nowName = nowName.subString(nowName.indexOf('|') + 1); - } - productLimt.put(nowRightAsstModelNo, nowName); - } - for (ConsumableorderdetailsInfo ass : consumableorderdetailsRecordsview) { - if (productLimt.containsKey(ass.Prod.Asset_Model_No__c)) { - ass.lowerlimit = decimal.valueOf( - productLimt.get(ass.Prod.Asset_Model_No__c).subString(0, productLimt.get(ass.Prod.Asset_Model_No__c).indexOf('|')) - ); - ass.upperlimit = decimal.valueOf( - productLimt.get(ass.Prod.Asset_Model_No__c).subString(productLimt.get(ass.Prod.Asset_Model_No__c).indexOf('|') + 1) - ); - } - } - } - //搴撳瓨涓婁笅闄� public static void productLimtAndDate() { String nowName = null, nowRightAsstModelNo = null; @@ -1187,7 +927,8 @@ String dealerProductIdStr, String methodTypeStr, String consumableorderdetailsRecordsviewStr, - Boolean editAbleStr + Boolean editAbleStr, + List<String> proLimitAndDateList ){ Results results = new Results(); errorMsgList = new List<String>(); @@ -1206,6 +947,7 @@ specialCampaign = specialCampaignStr; methodType = methodTypeStr; editAble = editAbleStr; + proLimitAndDate = proLimitAndDateList; dealerProductId = (List<String>)JSON.deserialize(dealerProductIdStr, List<String>.class); consumableorderdetailsRecordsview = (List<ConsumableorderdetailsInfo>)JSON.deserialize(consumableorderdetailsRecordsviewStr, List<ConsumableorderdetailsInfo>.class); size = Integer.valueOf(System.Label.orderdetLimitsize); @@ -1326,11 +1068,13 @@ // makeMessage(); results.errorMsgList = errorMsgList; results.warningMsgList = warningMsgList; - if(consumableorderdetailsRecordsview.size() > 0){ + if(consumableorderdetailsRecords.size() > 0){ + getConsumableShowTableFieldValue(); results.result = 'Success'; results.consumableorderdetailsRecordsview = consumableorderdetailsRecordsview; - results.errorMsg = '鎼滅储鍒�' + consumableorderdetailsRecordsview.size() + '浠朵骇鍝�'; + results.errorMsg = '鎼滅储鍒�' + consumableorderdetailsRecords.size() + '浠朵骇鍝�'; }else { + getConsumableShowTableFieldValue(); results.result = 'Fail'; results.consumableorderdetailsRecordsview = consumableorderdetailsRecordsview; results.errorMsg = '娌℃湁鎼滅储鍒扮浉鍏虫暟鎹�'; @@ -1502,6 +1246,7 @@ cate1ForSort = category1; // 鏄剧ず鏁版嵁鏉℃暟淇℃伅 noOfRecords = consumableorderdetailsRecords.size(); + getConsumableShowTableFieldValue(); results.consumableorderdetailsRecordsview = consumableorderdetailsRecordsview; if(consumableorderdetailsRecordsview.size() > 0){ results.result = 'Success'; @@ -1533,18 +1278,20 @@ if (selectedIdMap.containsKey(consumableorderdetailsRecords[i].Prod.Id)) { addNo++; //continue; - } else if (consumableorderdetailsRecordsview.size() >= pageLimit + size) { - break; - } else { + } + // else if (consumableorderdetailsRecordsview.size() >= pageLimit + size) { + // break; + // } + else { if (consumableorderdetailsRecords[i].check == false) { consumableorderdetailsRecords[i].esd = orderdetails1; } consumableorderdetailsRecordsview.add(consumableorderdetailsRecords[i]); addNo++; } - if (addNo >= size){ - break; - } + // if (addNo >= size){ + // break; + // } } return consumableorderdetailsRecordsview; } @@ -1695,6 +1442,8 @@ } } String soql = 'SELECT Id, Name,Name__c,Intra_Trade_List_RMB__c,Asset_Model_No__c,SFDA_Status__c,Product2__r.SFDA_Approbation_No__c,Product2__r.SFDA_Expiration_Date__c,Product2__r.Packing_list_manual__c,Category3__c,Category4__c,Category5__c FROM Product2__c WHERE Estimation_Entry_Possibility__c = \'鈼媆' '; + System.debug('sqlTail:'+sqlTail); + System.debug('orderzaikuId:'+orderzaikuId); if (orderzaikuId.size() > 0) { soql += ' AND Id in' + sqlTail; } @@ -1745,12 +1494,16 @@ Results results = new Results(); try { base64Data = EncodingUtil.urlDecode(base64Data, 'UTF-8'); - Blob contentBlob = EncodingUtil.base64Decode(base64Data); - Attachment att = new Attachment(); - att.ParentId = pId; - att.Name = fileName; - att.Body = contentBlob; - insert att; + ContentVersion cv = new ContentVersion(); + cv.Title = fileName; + cv.PathOnClient = '/' + fileName; + cv.FirstPublishLocationId = pId; + cv.VersionData = EncodingUtil.base64Decode(base64Data); + cv.IsMajorVersion = true; + insert cv; + Consumable_order__c c = [SELECT Id FROM Consumable_order__c WHERE Id =:pId]; + c.Consumable_pdf_insert_day__c = Date.today(); + update c; results.result = 'Success'; } catch (Exception e) { results.result = 'Fail'; @@ -1859,10 +1612,13 @@ String consumableorderdetailsRecordsviewStr, String contactDealerStr, String methodTypeStr, - String hospitalIdStr + String hospitalIdStr, + String contractIdStr, + String agencyProType1Str, + Boolean OSHFLGStr ) { ESetId = ''; - return save(contractNameStr,cocStr,agencyProTypeStr,accountidStr,consumableorderdetailsRecordsviewStr,contactDealerStr,methodType,ESetId,hospitalIdStr); + return save(contractNameStr,cocStr,agencyProTypeStr,accountidStr,consumableorderdetailsRecordsviewStr,contactDealerStr,methodTypeStr,ESetId,hospitalIdStr,contractIdStr,agencyProType1Str,OSHFLGStr); } //淇濆瓨鎸夐挳 @@ -1876,7 +1632,10 @@ String contactDealerStr, String methodTypeStr, String eSetIdStr, - String hospitalIdStr + String hospitalIdStr, + String contractIdStr, + String agencyProType1Str, + Boolean OSHFLGStr ){ Results results = new Results(); errorMsgList = new List<String>(); @@ -1887,6 +1646,9 @@ methodType = methodTypeStr; ESetId = eSetIdStr; hospitalId = hospitalIdStr; + contractId = contractIdStr; + agencyProType1 = agencyProType1Str; + OSHFLG = OSHFLGStr; coc = (Consumable_order__c)JSON.deserialize(cocStr, Consumable_order__c.class); contactDealer = (List<String>)JSON.deserialize(contactDealerStr, List<String>.class); consumableorderdetailsRecordsview = (List<ConsumableorderdetailsInfo>)JSON.deserialize(consumableorderdetailsRecordsviewStr, List<ConsumableorderdetailsInfo>.class); @@ -1907,10 +1669,12 @@ FROM account WHERE Name = :contractName + AND Id =: contractId //lt 20230517 瀹夊窘涓ょエ鍒� add AND Contract_Decide_Start_Date__c <= :Date.Today() AND Contract_Decide_End_Date__c >= :Date.Today() - AND Contact_Type__c LIKE :agencyProType - AND Agent_Ref__c = :accountid + AND Contact_Type__c like :agencyProType1 //lt 20230517 瀹夊窘涓ょエ鍒� add 1 + AND Agent_Ref__c =:accountid + AND OSH_Dealer__c =: OSHFLG //lt 20230517 瀹夊窘涓ょエ鍒� add ]; if (contract.size() <= 0) { // coc.Order_effective_contact__c.addError('涓嶅瓨鍦ㄧ殑鍚堝悓锛岃閲嶆柊纭銆�'); @@ -2051,9 +1815,13 @@ FROM Account WHERE Name = :contractName + AND Id =: contractId //lt 20230517 瀹夊窘涓ょエ鍒� add + AND Contact_Type__c like :agencyProType1 //lt 20230517 瀹夊窘涓ょエ鍒� add 1 AND Contact_Type__c LIKE :agencyProType AND Contract_Decide_Start_Date__c <= :Date.Today() AND Contract_Decide_End_Date__c >= :Date.Today() + AND Contract_Decide_End_Date__c >= :Date.Today() + AND OSH_Dealer__c =: OSHFLG //lt 20230517 瀹夊窘涓ょエ鍒� add ]; if (at.size() > 0 && at[0].Dealer_discount__c != null) { disCount = at[0].Dealer_discount__c; @@ -2248,6 +2016,46 @@ return results; } + //鍒犻櫎闄勪欢 + @AuraEnabled + public static Results deleteAtt(String contentVersionId){ + Results results = new Results(); + try { + ContentVersion conVersion = [SELECT ContentDocumentId FROM ContentVersion WHERE Id = :contentVersionId]; + String contentDocumentId = conVersion.ContentDocumentId; + ContentDocument conDocument = [SELECT Id FROM ContentDocument where Id = :contentDocumentId]; + delete conDocument; + results.result = 'Success'; + } catch (Exception e) { + results.result = 'Fail'; + results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); + } + return results; + } + + public static void getConsumableShowTableFieldValue(){ + for(ConsumableorderdetailsInfo con :consumableorderdetailsRecordsview){ + if(con.Prod != null){ + con.recordId = con.Prod.Id; + if(!con.oldCheck){ + con.prodName = con.Prod.Name__c; + // System.debug('ProdName:'+con.Prod.Id+'---'+con.Prod.Name__c); + } + con.prodSFDAStatus = con.Prod.SFDA_Status__c; + con.prodCategory3 = con.Prod.Category3__c; + con.prodCategory4 = con.Prod.Category4__c; + con.prodCategory5 = con.Prod.Category5__c; + con.prodIntraTradeList = con.Prod.Intra_Trade_List_RMB__c; + } + if(con.esd != null){ + // if(con.oldCheck){ + // con.prodName = con.esd.Consumable_Product__r.Name__c; + // } + con.consumableCount = con.esd.Consumable_count__c; + } + } + } + class ConsumableorderdetailsInfo implements Comparable { @AuraEnabled public Boolean check { get; set; } @@ -2272,7 +2080,7 @@ @AuraEnabled public Boolean canSelect { get; set; } @AuraEnabled - public Attachment Concc { get; set; } + public ContentVersion Concc { get; set; } @AuraEnabled public Boolean sortBy { get; set; } @AuraEnabled @@ -2285,6 +2093,23 @@ public Decimal orderGoods_Limit { get; set; } @AuraEnabled public Date Campaign_EndDate { get; set; } + @AuraEnabled + public String recordId { get; set; } + @AuraEnabled + public String prodName { get; set; } + @AuraEnabled + public String prodSFDAStatus { get; set; } + @AuraEnabled + public String prodCategory3 { get; set; } + @AuraEnabled + public String prodCategory4 { get; set; } + @AuraEnabled + public String prodCategory5 { get; set; } + @AuraEnabled + public Decimal prodIntraTradeList { get; set; } + @AuraEnabled + public Decimal consumableCount { get; set; } + // 宸插瓨浜у搧鏄庣粏 public ConsumableorderdetailsInfo(Consumable_Orderdetails__c e) { @@ -2309,7 +2134,7 @@ allnumber_piece = 0; } //闄勪欢 - public ConsumableorderdetailsInfo(Attachment e) { + public ConsumableorderdetailsInfo(ContentVersion e) { Concc = e; } // 鎺掑簭Consumable_order__c @@ -2417,6 +2242,12 @@ public String methodType; @AuraEnabled public List<String> proLimitAndDate; + @AuraEnabled + public Boolean isNoteStay; + @AuraEnabled + public Boolean OSHFLG; + @AuraEnabled + public String agencyProType1; } public class CusOption { -- Gitblit v1.9.1