From 3962c2bb0435484b60a3e408e4738d792e249a53 Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期一, 05 六月 2023 11:09:55 +0800
Subject: [PATCH] LEX CommunityNewCmp
---
force-app/main/default/classes/LexConsumableGoodsInfo.cls | 642 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 642 insertions(+), 0 deletions(-)
diff --git a/force-app/main/default/classes/LexConsumableGoodsInfo.cls b/force-app/main/default/classes/LexConsumableGoodsInfo.cls
new file mode 100644
index 0000000..e60bfdd
--- /dev/null
+++ b/force-app/main/default/classes/LexConsumableGoodsInfo.cls
@@ -0,0 +1,642 @@
+public without sharing class LexConsumableGoodsInfo {
+
+ //鎵�鏈変骇鍝佷竴瑙�
+ @AuraEnabled
+ public static Results initTotalNum(String ordId, String type){
+ Results results = new Results();
+ List<ShowRecords> allOtherDetIifo = new List<ShowRecords>();
+ Set<String> orderId = new Set<String>();
+ if(ordId != '1'){
+ orderId.add(ordId);
+ }
+ try {
+ if(!(orderId.size() > 0)){
+ String userId = UserInfo.getUserId();
+ List<User> userList = [SELECT accountid, Work_Location__c,UserPro_Type__c
+ FROM user
+ WHERE id = :userId ];
+ String accountid = userList[0].accountid;
+ String userPro_Type = userList[0].UserPro_Type__c;
+ String userWorklocation = userList[0].Work_Location__c;
+ String rtTypeDelivery = System.Label.RT_ConOrder_Delivery;
+ List<Consumable_order__c> conorderlist = new List<Consumable_order__c>();
+ //20200916 ljh update start
+ if(Test.isRunningTest()){
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c >= 0 or Delivery_detail_count__c >=0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+
+ }else{
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+ }
+ for(Consumable_order__c conorder : conorderlist){
+ String temp = (String)conorder.Id;
+ orderId.add(temp);
+ }
+ System.debug('ANY o'+orderId);
+ }
+ List<Consumable_Orderdetails__c> conOrderList1 = new List<Consumable_Orderdetails__c>();
+ if(Test.isRunningTest()){
+ conOrderList1 = [SELECT Asset_Model_No__c ,Consumable_count__c FROM Consumable_Orderdetails__c];
+ }else{
+ conOrderList1 = [SELECT Asset_Model_No__c ,Consumable_count__c FROM Consumable_Orderdetails__c WHERE Consumable_order__c =:orderId];
+ }
+
+ Map<String,Decimal> allConOrderMap = new Map<String,Decimal>();
+ for(Consumable_Orderdetails__c con : conOrderList1){
+ if(con.Consumable_count__c == null){
+ con.Consumable_count__c = 0;
+ }
+ if(allConOrderMap.containsKey(con.Asset_Model_No__c)){
+ allConOrderMap.put(con.Asset_Model_No__c,allConOrderMap.get(con.Asset_Model_No__c)+con.Consumable_count__c);
+ }else{
+ allConOrderMap.put(con.Asset_Model_No__c, con.Consumable_count__c);
+ }
+ }
+ for(String pmodel : allConOrderMap.keySet()){
+ if(allConOrderMap.get(pmodel) > 0){
+ ShowRecords showrecord2 = new ShowRecords();
+ showrecord2.recordCount = allConOrderMap.get(pmodel);
+ showrecord2.prodModel = pmodel;
+ allOtherDetIifo.add(showrecord2);
+ }
+ }
+ results.result = 'Success';
+ results.recordList = allOtherDetIifo;
+ } catch (Exception e) {
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //宸插埌璐т骇鍝佷竴瑙�
+ @AuraEnabled
+ public static Results initArrDet(String orderId){
+ Results results = new Results();
+ List<ShowRecords> arrDetIifo = new List<ShowRecords>();
+ try{
+ List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = true AND Consumable_order_minor__c = :orderId];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> arrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str
+ GROUP BY Asset_Model_No__c];
+ for(Integer i = 0 ; i< arrDetList.size();i++){
+ arrDetIifo.add(new showRecords(arrDetList[i]));
+ }
+ results.recordList = arrDetIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //宸插埌璐т骇鍝佷竴瑙圓ll
+ @AuraEnabled
+ public static Results initArrDetAll(String type){
+ Results results = new Results();
+ List<ShowRecords> allArrDetIifo = new List<ShowRecords>();
+ try{
+ String userId = UserInfo.getUserId();
+ List<User> userList = [SELECT accountid, Work_Location__c,UserPro_Type__c
+ FROM user
+ WHERE id = :userId ];
+ String accountid = userList[0].accountid;
+ String userPro_Type = userList[0].UserPro_Type__c;
+ String userWorklocation = userList[0].Work_Location__c;
+ Date orderdate = Date.today().addDays(-7);
+ String rtTypeDelivery = System.Label.RT_ConOrder_Delivery;
+ List<Consumable_order__c> conorderlist = new List<Consumable_order__c>();
+ //20200916 ljh update start
+ if(Test.isRunningTest()){
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c >= 0 or Delivery_detail_count__c >=0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+
+ }else{
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+ }
+ //20200916 ljh update end
+ // List<Consumable_order__c> conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c > 0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ System.debug('======'+conorderlist+'daxiao:'+conorderlist.size());
+ for(Consumable_order__c conorder : conorderlist){
+ System.debug('======'+conorder.Owner.Name+'======');
+ }
+ Set<String> orderId = new Set<String>();
+ for(Consumable_order__c conorder : conorderlist){
+ orderId.add(conorder.Id);
+ }
+ System.debug('ANY o'+orderId);
+ List<Consumable_order_details2__c> conList = new List<Consumable_order_details2__c>();
+ if(Test.isRunningTest()){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c ];
+ }else{
+ //20200916 ljh update start
+ //conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = true AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ if(type !=null && type.equals('all')){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = true AND Consumable_order_minor__c = :orderId AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }else{
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = true AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }
+ //20200916 ljh update end
+ }
+ // List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> arrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str
+ GROUP BY Asset_Model_No__c];
+ // List<showRecords> allArrDetIifo = new List<showRecords>();
+ for(Integer i = 0 ; i< arrDetList.size();i++){
+ allArrDetIifo.add(new showRecords(arrDetList[i]));
+ }
+ results.recordList = allArrDetIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //鏈埌璐т骇鍝佷竴瑙�
+ @AuraEnabled
+ public static Results initDeliveryDet(String orderId){
+ Results results = new Results();
+ List<ShowRecords> notArrDetIifo = new List<ShowRecords>();
+ try{
+ List<AggregateResult> notArrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Dealer_Arrive__c = false
+ AND Consumable_order_minor__c = :orderId
+ GROUP BY Asset_Model_No__c];
+ for(Integer i = 0 ; i< notArrDetList.size();i++){
+ notArrDetIifo.add(new showRecords(notArrDetList[i]));
+ }
+ results.recordList = notArrDetIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //鏈埌璐т骇鍝佷竴瑙圓ll
+ @AuraEnabled
+ public static Results initDeliveryDetAll(String type){
+ Results results = new Results();
+ List<ShowRecords> allNotArrDetIifo = new List<ShowRecords>();
+ try{
+ String userId = UserInfo.getUserId();
+ List<User> userList = [SELECT accountid, Work_Location__c,UserPro_Type__c
+ FROM user
+ WHERE id = :userId ];
+ String accountid = userList[0].accountid;
+ String userPro_Type = userList[0].UserPro_Type__c;
+ String userWorklocation = userList[0].Work_Location__c;
+ Date orderdate = Date.today().addDays(-7);
+ String rtTypeDelivery = System.Label.RT_ConOrder_Delivery;
+ List<Consumable_order__c> conorderlist = new List<Consumable_order__c>();
+ //20200916 ljh update start
+ if(Test.isRunningTest()){
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c >= 0 or Delivery_detail_count__c >=0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+
+ }else{
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+ }
+ //20200916 ljh update end
+ // List<Consumable_order__c> conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c > 0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ System.debug('======'+conorderlist+'daxiao:'+conorderlist.size());
+ for(Consumable_order__c conorder : conorderlist){
+ System.debug('======'+conorder.Owner.Name+'======');
+ }
+ Set<String> orderId = new Set<String>();
+ for(Consumable_order__c conorder : conorderlist){
+ orderId.add(conorder.Id);
+ }
+ System.debug('ANY o'+orderId);
+ List<Consumable_order_details2__c> conList = new List<Consumable_order_details2__c>();
+ if(Test.isRunningTest()){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c ];
+ }else{
+ //20200916 ljh update start
+ //conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ if(type !=null && type.equals('all')){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }else{
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }
+ //20200916 ljh update end
+ }
+ // List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> arrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str and Cancellation_Flag__c = false
+ GROUP BY Asset_Model_No__c];
+ // List<showRecords> allArrDetIifo = new List<showRecords>();
+ for(Integer i = 0 ; i< arrDetList.size();i++){
+ allNotArrDetIifo.add(new showRecords(arrDetList[i]));
+ }
+ results.recordList = allNotArrDetIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //杩樻病鍙戣揣鏁伴噺
+ @AuraEnabled
+ public static Results initNotArrDet(String orderId){
+ Results results = new Results();
+ List<Consumable_Orderdetails__c> otherArrDetIifo = new List<Consumable_Orderdetails__c>();
+ List<ShowRecords> otherArrList = new List<ShowRecords>();
+ try{
+ List<showRecords> arrDetIifo = new List<showRecords>();
+ List<showRecords> notArrDetIifo = new List<showRecords>();
+ List<showRecords> allArrDetIifo = new List<showRecords>();
+ // List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = true AND Consumable_order_minor__c = :orderId];
+ List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Consumable_order_minor__c = :orderId];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> arrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str AND Dealer_Arrive__c = true
+ GROUP BY Asset_Model_No__c];
+ for(Integer i = 0 ; i< arrDetList.size();i++){
+ arrDetIifo.add(new showRecords(arrDetList[i]));
+ }
+
+ List<AggregateResult> notArrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Dealer_Arrive__c = false
+ AND Consumable_order_minor__c = :orderId
+ GROUP BY Asset_Model_No__c];
+ for(Integer i = 0 ; i< notArrDetList.size();i++){
+ notArrDetIifo.add(new showRecords(notArrDetList[i]));
+ }
+
+ // List<AggregateResult> allArrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ // WHERE Id =: str
+ // GROUP BY Asset_Model_No__c];
+ List<Consumable_Orderdetails__c> allArrDetList = [SELECT Asset_Model_No__c,Consumable_count__c FROM Consumable_Orderdetails__c
+ WHERE Consumable_order__c =: orderId];
+ // for(Integer i = 0 ; i< allArrDetList.size();i++){
+ // allArrDetIifo.add(new showRecords(notArrDetList[i]));
+ // }
+ Map<String,Decimal> arrDetMap = new Map<String,Decimal>();
+ for(showRecords arr : arrDetIifo){
+ arrDetMap.put(arr.prodModel, arr.recordCount);
+ }
+ for(showRecords notarr : notArrDetIifo){
+ if(arrDetMap.containsKey(notarr.prodModel)){
+ arrDetMap.put(notarr.prodModel, arrDetMap.get(notarr.prodModel)+notarr.recordCount);
+ }else{
+ arrDetMap.put(notarr.prodModel, notarr.recordCount);
+ }
+ }
+ List<String> AssetModelNoEdList = new List<String>();//20200904 ljh add
+ for(Consumable_Orderdetails__c allarr : allArrDetList){
+ for(String promodel : arrDetMap.keySet()){
+ if(allarr.Asset_Model_No__c == promodel){
+ if((allarr.Consumable_count__c - arrDetMap.get(promodel)) > 0){
+ allarr.Consumable_count__c = (allarr.Consumable_count__c - arrDetMap.get(promodel));
+ otherArrDetIifo.add(allarr);
+ }
+ AssetModelNoEdList.add(promodel);//20200904 ljh add
+ }
+ }
+ }
+ //20200904 ljh add start
+ for(Consumable_Orderdetails__c allarr1 : allArrDetList){
+ if(!AssetModelNoEdList.contains(allarr1.Asset_Model_No__c)){
+ otherArrDetIifo.add(allarr1);
+ }
+ }
+ for(Consumable_Orderdetails__c conOrderDetail : otherArrDetIifo){
+ ShowRecords record = new ShowRecords();
+ record.prodModel = conOrderDetail.Asset_Model_No__c;
+ record.recordCount = conOrderDetail.Consumable_count__c;
+ otherArrList.add(record);
+ }
+ results.recordList = otherArrList;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //杩樻病鍙戣揣鏁伴噺All
+ @AuraEnabled
+ public static Results initNotArrDetAll(String type){
+ Results results = new Results();
+ List<ShowRecords> allOtherDetIifo = new List<ShowRecords>();
+ try{
+ String userId = UserInfo.getUserId();
+ List<User> userList = [SELECT accountid, Work_Location__c,UserPro_Type__c
+ FROM user
+ WHERE id = :userId ];
+ String accountid = userList[0].accountid;
+ String userPro_Type = userList[0].UserPro_Type__c;
+ String userWorklocation = userList[0].Work_Location__c;
+ Date orderdate = Date.today().addDays(-7);
+ String rtTypeDelivery = System.Label.RT_ConOrder_Delivery;
+ List<Consumable_order__c> conorderlist = new List<Consumable_order__c>();
+ //20200916 ljh update start
+ if(Test.isRunningTest()){
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c >= 0 or Delivery_detail_count__c >=0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+
+ }else{
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+ }
+ //20200916 ljh update end
+ // List<Consumable_order__c> conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c > 0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ System.debug('======'+conorderlist+'daxiao:'+conorderlist.size());
+ for(Consumable_order__c conorder : conorderlist){
+ System.debug('======'+conorder.Owner.Name+'======');
+ }
+ Set<String> orderId = new Set<String>();
+ for(Consumable_order__c conorder : conorderlist){
+ orderId.add(conorder.Id);
+ }
+ System.debug('ANY o'+orderId);
+ List<Consumable_order_details2__c> conList = new List<Consumable_order_details2__c>();
+ if(Test.isRunningTest()){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c ];
+ }else{
+ //20200916 ljh update start
+ //conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ if(type !=null && type.equals('all')){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Consumable_order_minor__c = :orderId AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }else{
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ }
+ //20200916 ljh update end
+ }
+ // List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> arrDetList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str and Cancellation_Flag__c = false
+ GROUP BY Asset_Model_No__c];
+ Map<String,Decimal> conOrderMap = new Map<String,Decimal>();
+ for(AggregateResult agg : arrDetList){
+ conOrderMap.put(String.valueOf(agg.get('prodModel')), Integer.valueOf(agg.get('recordCount')));
+ }
+
+ List<Consumable_Orderdetails__c> conOrderList1 = [SELECT Asset_Model_No__c ,Consumable_count__c FROM Consumable_Orderdetails__c WHERE Consumable_order__c =: orderId ];
+ Map<String,Decimal> allConOrderMap = new Map<String,Decimal>();
+ for(Consumable_Orderdetails__c con : conOrderList1){
+ if(con.Consumable_count__c == null){
+ con.Consumable_count__c = 0;
+ }
+ if(allConOrderMap.containsKey(con.Asset_Model_No__c)){
+ allConOrderMap.put(con.Asset_Model_No__c,allConOrderMap.get(con.Asset_Model_No__c)+con.Consumable_count__c);
+ }else{
+ allConOrderMap.put(con.Asset_Model_No__c, con.Consumable_count__c);
+ }
+ }
+ for(String pmodel : allConOrderMap.keySet()){
+ if(conOrderMap.containsKey(pmodel)){
+ if(allConOrderMap.get(pmodel) - conOrderMap.get(pmodel) > 0){
+ showRecords showrecord1 = new showRecords();
+ showrecord1.recordCount = allConOrderMap.get(pmodel) - conOrderMap.get(pmodel);
+ showrecord1.prodModel = pmodel;
+ allOtherDetIifo.add(showrecord1);
+ }
+ }else{
+ showRecords showrecord2 = new showRecords();
+ showrecord2.recordCount = allConOrderMap.get(pmodel);
+ showrecord2.prodModel = pmodel;
+ allOtherDetIifo.add(showrecord2);
+ }
+ }
+ results.recordList = allOtherDetIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //鍙戣揣涓冨ぉ杩樻湭鍒拌揣鏁�
+ @AuraEnabled
+ public static Results initMoreThan7(String orderId){
+ Results results = new Results();
+ List<ShowRecords> morethansevendaysIifo = new List<ShowRecords>();
+ try{
+ List<AggregateResult> morethan7daysList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Consumable_order_minor__c != null
+ AND Dealer_Shipment__c = false
+ AND Dealer_Arrive__c = false
+ AND Dealer_Saled__c = false
+ AND Consumable_order_minor__r.showFalseNotshowTrue__c = false
+ AND Deliver_date__c < LAST_N_DAYS:7
+ AND Consumable_order_minor__c = :orderId
+ GROUP BY Asset_Model_No__c];
+
+ for(Integer i = 0 ; i< morethan7daysList.size() ; i++){
+ morethansevendaysIifo.add(new showRecords(morethan7daysList[i]));
+ }
+ results.recordList = morethansevendaysIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ //鍙戣揣涓冨ぉ杩樻湭鍒拌揣鏁癆ll
+ @AuraEnabled
+ public static Results initMoreThan7All(String type){
+ Results results = new Results();
+ List<ShowRecords> morethansevendaysIifo = new List<ShowRecords>();
+ try{
+ String userId = UserInfo.getUserId();
+ List<User> userList = [SELECT accountid, Work_Location__c,UserPro_Type__c
+ FROM user
+ WHERE id = :userId ];
+ String accountid = userList[0].accountid;
+ String userPro_Type = userList[0].UserPro_Type__c;
+ String userWorklocation = userList[0].Work_Location__c;
+ Date orderdate = Date.today().addDays(-7);
+ String rtTypeDelivery = System.Label.RT_ConOrder_Delivery;
+ List<Consumable_order__c> conorderlist = new List<Consumable_order__c>();
+ //20200916 ljh update start
+ if(Test.isRunningTest()){
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c >= 0 or Delivery_detail_count__c >=0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >=0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+
+ }else{
+ //conorderlist = [select id,name,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ if(type !=null && type.equals('all')){
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }else{
+ conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c >0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation and showFalseNotshowTrue__c = false];
+ }
+ }
+ system.debug('==============>conorderlist'+conorderlist);
+ system.debug('==============>conorderlist'+conorderlist.size());
+ //20200916 ljh update end
+ // List<Consumable_order__c> conorderlist = [select id,Owner.Name from Consumable_order__c where Order_type__c = '璁㈠崟' and recordtypeid = :rtTypeDelivery and Dealer_Info__c = :accountid and Delivery_detail_count__c > 0 and Order_ProType__c = :userPro_Type and Order_Owner_WorkLocal__c = :userWorklocation];
+ System.debug('======'+conorderlist+'daxiao:'+conorderlist.size());
+ for(Consumable_order__c conorder : conorderlist){
+ System.debug('======'+conorder.Owner.Name+'======');
+ }
+ Set<String> orderId = new Set<String>();
+ for(Consumable_order__c conorder : conorderlist){
+ orderId.add(conorder.Id);
+ }
+ System.debug('ANY o'+orderId);
+ List<Consumable_order_details2__c> conList = new List<Consumable_order_details2__c>();
+ if(Test.isRunningTest()){
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c ];
+ }else{
+ //20200916 ljh update start
+ //conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ if(type !=null && type.equals('all')){
+ system.debug('all============');
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ system.debug('allconList==========='+conList.size());
+ }else{
+ system.debug('notall=============');
+ conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ system.debug('notallconList==========='+conList.size());
+ }
+ //20200916 ljh update end
+ }
+ // List<Consumable_order_details2__c> conList = [SELECT id,Bar_Code__c FROM Consumable_order_details2__c WHERE Dealer_Arrive__c = false AND Consumable_order_minor__c = :orderId AND Deliver_date__c < :orderdate AND recordtypeid = :System.Label.RT_ConOrderDetail2_Delivery];
+ Map<String,String> srtMap = new Map<String,String>();
+ for(Consumable_order_details2__c con : conList){
+ srtMap.put(con.Bar_Code__c, con.Id);
+ }
+ List<String> str = new List<String>();
+ for(String s : srtMap.keySet()){
+ str.add(srtMap.get(s));
+ }
+ List<AggregateResult> morethan7daysList = [SELECT Asset_Model_No__c prodModel,count(Id) recordCount FROM Consumable_order_details2__c
+ WHERE Id =: str and Cancellation_Flag__c = false
+ AND Consumable_order_minor__c != null
+ AND Dealer_Shipment__c = false
+ AND Dealer_Arrive__c = false
+ AND Dealer_Saled__c = false
+ AND Consumable_order_minor__r.showFalseNotshowTrue__c = false
+ AND Deliver_date__c < LAST_N_DAYS:7
+ GROUP BY Asset_Model_No__c];
+ system.debug('Morethan7daysList================>'+morethan7daysList.size());
+ for(Integer i = 0 ; i< morethan7daysList.size() ; i++){
+ morethansevendaysIifo.add(new showRecords(morethan7daysList[i]));
+ system.debug('MorethansevendaysIifo+++++++'+morethansevendaysIifo);
+ }
+ results.recordList = morethansevendaysIifo;
+ results.result = 'Success';
+ }catch (Exception e){
+ results.result = 'Fail';
+ results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ }
+ return results;
+ }
+
+ public class Results {
+ @AuraEnabled
+ public String result;
+ @AuraEnabled
+ public String errorMsg;
+ @AuraEnabled
+ public List<ShowRecords> recordList;
+ }
+
+
+ public class ShowRecords implements Comparable {
+ @AuraEnabled
+ public Decimal recordCount { get; set; }
+ @AuraEnabled
+ public String prodModel { get; set; }
+
+ public ShowRecords() {}
+
+ public ShowRecords(AggregateResult e) {
+ recordCount =Integer.valueOf(e.get('recordCount'));
+ prodModel = String.valueOf(e.get('prodModel'));
+ }
+ // 鎺掑簭
+ public Integer compareTo(Object compareTo) {
+ return null;
+ }
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.1