From 5b5c1e16deaa3a9d6d0ed1ffca390655ed103df7 Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期五, 14 七月 2023 14:56:14 +0800
Subject: [PATCH] lex community
---
force-app/main/default/classes/LexArriveGoodsMainController.cls | 443 ++++++++++++++++++++++++++++---------------------------
1 files changed, 226 insertions(+), 217 deletions(-)
diff --git a/force-app/main/default/classes/LexArriveGoodsMainController.cls b/force-app/main/default/classes/LexArriveGoodsMainController.cls
index 3e7d7cf..b5652b6 100644
--- a/force-app/main/default/classes/LexArriveGoodsMainController.cls
+++ b/force-app/main/default/classes/LexArriveGoodsMainController.cls
@@ -1,224 +1,233 @@
public without sharing class LexArriveGoodsMainController {
- /*****************妞滅储鐢�******************/
- //缁忛攢鍟嗕骇鍝佸垎绫�
- public static String agencyProType { get; set; }
- // public static Consumable_order__c coc { get; set; }
- public static String category1 { get; set; }
- private static String cate1ForSort = null;
- private static Date cate2ForSort = Date.today();
- private static Date cate2 = Date.today();
- private static String[] columus = new List<String>{ 'Product2__c.Name' };
- // 浜у搧 ID
- private static String ESetId = '';
- private static String accountid = null;
- // 璁㈠崟 瀛楁鏍囩
- public static List<String> title { get; private set; }
- // 璁㈠崟 瀛楁鍚�
- public static List<String> column;
- public static List<List<String>> columns { get; private set; }
- // 鐢婚潰鏄剧ず鏁版嵁
- public static List<Consumable_order__c> raesList { get; private set; }
- // 鐧诲綍鑰呭伐浣滃湴
- private static String userWorkLocation;
- // 20200904 ljh 姹囨�讳娇鐢� start
- public static Integer Total_num { get; set; }
- public static Integer OrderNumber_arrived { get; set; }
- public static Integer Delivery_detail_count { get; set; }
- public static Integer OrderNumber_notarrive { get; set; }
- public static Integer More_than_seven_days { get; set; }
+ /*****************妞滅储鐢�******************/
+ //缁忛攢鍟嗕骇鍝佸垎绫�
+ public static String agencyProType { get; set; }
+ // public static Consumable_order__c coc { get; set; }
+ public static String category1 { get; set; }
+ private static String cate1ForSort = null;
+ private static Date cate2ForSort = Date.today();
+ private static Date cate2 = Date.today();
+ private static String[] columus = new List<String>{ 'Product2__c.Name' };
+ // 浜у搧 ID
+ private static String ESetId = '';
+ private static String accountid = null;
+ // 璁㈠崟 瀛楁鏍囩
+ public static List<String> title { get; private set; }
+ // 璁㈠崟 瀛楁鍚�
+ public static List<String> column;
+ public static List<List<String>> columns { get; private set; }
+ // 鐢婚潰鏄剧ず鏁版嵁
+ public static List<Consumable_order__c> raesList { get; private set; }
+ // 鐧诲綍鑰呭伐浣滃湴
+ private static String userWorkLocation;
+ // 20200904 ljh 姹囨�讳娇鐢� start
+ public static Integer Total_num { get; set; }
+ public static Integer OrderNumber_arrived { get; set; }
+ public static Integer Delivery_detail_count { get; set; }
+ public static Integer OrderNumber_notarrive { get; set; }
+ public static Integer More_than_seven_days { get; set; }
- @AuraEnabled
- public static Results init() {
- Results results = new Results();
- results.isNoteStay = LexUtility.getIsNoteStay();
- try {
- // coc = new Consumable_order__c();
- String userId = UserInfo.getUserId();
- List<user> Useracc = new List<user>();
- Useracc = [
- SELECT accountid, Work_Location__c, UserPro_Type__c
- FROM user
- WHERE id = :userId
- ];
- accountid = Useracc[0].accountid;
- userWorkLocation = Useracc[0].Work_Location__c;
- agencyProType = Useracc[0].UserPro_Type__c;
- if (String.isBlank(Useracc[0].UserPro_Type__c)) {
- agencyProType = 'ET';
- }
- // 鑾峰緱璁㈠崟涓�瑙�
- Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe().get('Consumable_order__c').getDescribe().fieldSets.getMap();
- Schema.FieldSet fs = fsMap.get('arrive_view');
- // 鑾峰緱璁㈠崟涓殑鎵�鏈夐」鐩�
- List<FieldSetMember> fsmList = fs.getFields();
- // 鑾峰緱瀛楁鏍囩鍜屽瓧娈靛悕
- title = new List<String>();
- column = new List<String>();
- columns = new List<List<String>>();
- for (FieldSetMember fsm : fsmList) {
- title.add(fsm.getLabel());
- column.add(fsm.getFieldPath());
- columns.add(fsm.getFieldPath().split('\\.'));
- }
- // 鑾峰緱鏄剧ず鏁版嵁
- raesList = new List<Consumable_order__c>();
- String soql = 'select Id';
- for (String s : column) {
- soql += ',' + s;
- }
- soql +=
- ' from Consumable_order__c where Order_type__c = \'' +
- '璁㈠崟' +
- '\' and recordtypeid =\'' +
- System.Label.RT_ConOrder_Delivery +
- '\' and Dealer_Info__c =\'' +
- accountid +
- '\' and Order_ProType__c =\'' +
- agencyProType +
- '\' and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_Owner_WorkLocal__c = \'' +
- userWorkLocation +
- '\' and showFalseNotshowTrue__c = false order by Deliver_date__c'; //
- // soql = 'select id,name,ContractNo__c,Total_num__c,OrderNumber_arrived__c,Delivery_detail_count__c,OrderNumber_notarrive__c,More_than_seven_days__c,Shipment_date__c,First_Delivery__c from Consumable_order__c where id in :idList';
- raesList = Database.query(soql);
- //20200904 ljh add start
- Total_num = 0;
- OrderNumber_arrived = 0;
- Delivery_detail_count = 0;
- OrderNumber_notarrive = 0;
- More_than_seven_days = 0;
- System.debug('-----1------' + raesList);
- for (Consumable_order__c conorder : raesList) {
- if (conorder.Total_num__c != null) {
- Total_num += (Integer) conorder.Total_num__c;
- }
- if (conorder.OrderNumber_arrived__c != null) {
- OrderNumber_arrived += (Integer) conorder.OrderNumber_arrived__c;
- }
- if (conorder.Delivery_detail_count__c != null) {
- Delivery_detail_count += (Integer) conorder.Delivery_detail_count__c;
- }
- if (conorder.OrderNumber_notarrive__c != null) {
- OrderNumber_notarrive += (Integer) conorder.OrderNumber_notarrive__c;
- }
- if (conorder.More_than_seven_days__c != null) {
- More_than_seven_days += (Integer) conorder.More_than_seven_days__c;
- }
- }
- results.agencyProType = agencyProType;
- results.accountId = accountid;
- results.title = title;
- results.raesList = raesList;
- results.userWorkLocation = userWorkLocation;
- results.totalNum = Total_num;
- results.orderNumberArrived = OrderNumber_arrived;
- results.deliveryDetailCount = Delivery_detail_count;
- results.orderNumberNotarrive = OrderNumber_notarrive;
- results.moreThanSevenDays = More_than_seven_days;
- results.result = 'Success';
- } catch (Exception e) {
- results.result = 'Fail';
- results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ @AuraEnabled
+ public static Results init() {
+ Results results = new Results();
+ results.isNoteStay = LexUtility.getIsNoteStay();
+ try {
+ // coc = new Consumable_order__c();
+ String userId = UserInfo.getUserId();
+ List<user> Useracc = new List<user>();
+ Useracc = [
+ SELECT accountid, Work_Location__c, UserPro_Type__c
+ FROM user
+ WHERE id = :userId
+ ];
+ accountid = Useracc[0].accountid;
+ userWorkLocation = Useracc[0].Work_Location__c;
+ agencyProType = Useracc[0].UserPro_Type__c;
+ if (String.isBlank(Useracc[0].UserPro_Type__c)) {
+ agencyProType = 'ET';
+ }
+ // 鑾峰緱璁㈠崟涓�瑙�
+ Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe()
+ .get('Consumable_order__c')
+ .getDescribe()
+ .fieldSets.getMap();
+ Schema.FieldSet fs = fsMap.get('arrive_view');
+ // 鑾峰緱璁㈠崟涓殑鎵�鏈夐」鐩�
+ List<FieldSetMember> fsmList = fs.getFields();
+ // 鑾峰緱瀛楁鏍囩鍜屽瓧娈靛悕
+ title = new List<String>();
+ column = new List<String>();
+ columns = new List<List<String>>();
+ for (FieldSetMember fsm : fsmList) {
+ title.add(fsm.getLabel());
+ column.add(fsm.getFieldPath());
+ columns.add(fsm.getFieldPath().split('\\.'));
+ }
+ // 鑾峰緱鏄剧ず鏁版嵁
+ raesList = new List<Consumable_order__c>();
+ String soql = 'select Id';
+ for (String s : column) {
+ soql += ',' + s;
+ }
+ soql +=
+ ' from Consumable_order__c where Order_type__c = \'' +
+ '璁㈠崟' +
+ '\' and recordtypeid =\'' +
+ System.Label.RT_ConOrder_Delivery +
+ '\' and Dealer_Info__c =\'' +
+ accountid +
+ '\' and Order_ProType__c =\'' +
+ agencyProType +
+ '\' and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) and Order_Owner_WorkLocal__c = \'' +
+ userWorkLocation +
+ '\' and showFalseNotshowTrue__c = false order by Deliver_date__c'; //
+ // soql = 'select id,name,ContractNo__c,Total_num__c,OrderNumber_arrived__c,Delivery_detail_count__c,OrderNumber_notarrive__c,More_than_seven_days__c,Shipment_date__c,First_Delivery__c from Consumable_order__c where id in :idList';
+ raesList = Database.query(soql);
+ //20200904 ljh add start
+ Total_num = 0;
+ OrderNumber_arrived = 0;
+ Delivery_detail_count = 0;
+ OrderNumber_notarrive = 0;
+ More_than_seven_days = 0;
+ System.debug('-----1------' + raesList);
+ for (Consumable_order__c conorder : raesList) {
+ if (conorder.Total_num__c != null) {
+ Total_num += (Integer) conorder.Total_num__c;
}
- return results;
- }
-
- @AuraEnabled
- public static Results searchConsumableorderdetails(
- String category1Str,
- Date cate2Str,
- String accountidStr,
- String userWorkLocationStr,
- String agencyProTypeStr
- ) {
- Results results = new Results();
- category1 = category1Str;
- cate2 = cate2Str;
- accountid = accountidStr;
- userWorkLocation = userWorkLocationStr;
- agencyProType = agencyProTypeStr;
- try {
- // cate2 = coc.Shipment_date__c;
- // 鑾峰緱璁㈠崟涓�瑙�
- Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe().get('Consumable_order__c').getDescribe().fieldSets.getMap();
- Schema.FieldSet fs = fsMap.get('arrive_view');
- // 鑾峰緱璁㈠崟涓殑鎵�鏈夐」鐩�
- List<FieldSetMember> fsmList = fs.getFields();
- // 鑾峰緱瀛楁鏍囩鍜屽瓧娈靛悕
- title = new List<String>();
- column = new List<String>();
- columns = new List<List<String>>();
- for (FieldSetMember fsm : fsmList) {
- title.add(fsm.getLabel());
- column.add(fsm.getFieldPath());
- columns.add(fsm.getFieldPath().split('\\.'));
- }
- // 鑾峰緱鏄剧ず鏁版嵁
- raesList = new List<Consumable_order__c>();
- String soql = 'select Id';
- for (String s : column) {
- soql += ',' + s;
- }
- soql +=
- ' from Consumable_order__c where Order_type__c = \'' +
- '璁㈠崟' +
- '\' and recordtypeid =\'' +
- System.Label.RT_ConOrder_Delivery +
- '\' and Dealer_Info__c =\'' +
- accountid +
- '\' and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) ';
- soql += 'and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' ';
- soql += 'and showFalseNotshowTrue__c = false';
- if (!String.isBlank(category1)) {
- soql += ' and Name like \'%' + String.escapeSingleQuotes(category1.replaceAll('%', '\\%')) + '%\' ';
- }
- if (cate2 != null) {
- soql += ' and Shipment_date__c = :cate2 ';
- }
- soql += ' and Order_ProType__c =\'' + agencyProType + '\'';
- soql += ' order by Deliver_date__c';
- system.debug('====soql:' + soql);
- raesList = Database.query(soql);
- results.raesList = raesList;
- results.result = 'Success';
- } catch (Exception e) {
- results.result = 'Fail';
- results.errorMsg = e.getLineNumber() + '---' + e.getMessage();
+ if (conorder.OrderNumber_arrived__c != null) {
+ OrderNumber_arrived += (Integer) conorder.OrderNumber_arrived__c;
}
- return results;
+ if (conorder.Delivery_detail_count__c != null) {
+ Delivery_detail_count += (Integer) conorder.Delivery_detail_count__c;
+ }
+ if (conorder.OrderNumber_notarrive__c != null) {
+ OrderNumber_notarrive += (Integer) conorder.OrderNumber_notarrive__c;
+ }
+ if (conorder.More_than_seven_days__c != null) {
+ More_than_seven_days += (Integer) conorder.More_than_seven_days__c;
+ }
+ }
+ results.agencyProType = agencyProType;
+ results.accountId = accountid;
+ results.title = title;
+ results.raesList = raesList;
+ results.userWorkLocation = userWorkLocation;
+ results.totalNum = Total_num;
+ results.orderNumberArrived = OrderNumber_arrived;
+ results.deliveryDetailCount = Delivery_detail_count;
+ results.orderNumberNotarrive = OrderNumber_notarrive;
+ results.moreThanSevenDays = More_than_seven_days;
+ 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 String agencyProType;
- @AuraEnabled
- public String category1;
- @AuraEnabled
- public Date cate2;
- @AuraEnabled
- public String eSetId;
- @AuraEnabled
- public String accountId;
- @AuraEnabled
- public List<String> title;
- @AuraEnabled
- public List<Consumable_order__c> raesList;
- @AuraEnabled
- public String userWorkLocation;
- @AuraEnabled
- public Integer totalNum;
- @AuraEnabled
- public Integer orderNumberArrived;
- @AuraEnabled
- public Integer deliveryDetailCount;
- @AuraEnabled
- public Integer orderNumberNotarrive;
- @AuraEnabled
- public Integer moreThanSevenDays;
- @AuraEnabled
- public Boolean isNoteStay;
+ @AuraEnabled
+ public static Results searchConsumableorderdetails(
+ String category1Str,
+ Date cate2Str,
+ String accountidStr,
+ String userWorkLocationStr,
+ String agencyProTypeStr
+ ) {
+ Results results = new Results();
+ category1 = category1Str;
+ cate2 = cate2Str;
+ accountid = accountidStr;
+ userWorkLocation = userWorkLocationStr;
+ agencyProType = agencyProTypeStr;
+ try {
+ // cate2 = coc.Shipment_date__c;
+ // 鑾峰緱璁㈠崟涓�瑙�
+ Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe()
+ .get('Consumable_order__c')
+ .getDescribe()
+ .fieldSets.getMap();
+ Schema.FieldSet fs = fsMap.get('arrive_view');
+ // 鑾峰緱璁㈠崟涓殑鎵�鏈夐」鐩�
+ List<FieldSetMember> fsmList = fs.getFields();
+ // 鑾峰緱瀛楁鏍囩鍜屽瓧娈靛悕
+ title = new List<String>();
+ column = new List<String>();
+ columns = new List<List<String>>();
+ for (FieldSetMember fsm : fsmList) {
+ title.add(fsm.getLabel());
+ column.add(fsm.getFieldPath());
+ columns.add(fsm.getFieldPath().split('\\.'));
+ }
+ // 鑾峰緱鏄剧ず鏁版嵁
+ raesList = new List<Consumable_order__c>();
+ String soql = 'select Id';
+ for (String s : column) {
+ soql += ',' + s;
+ }
+ soql +=
+ ' from Consumable_order__c where Order_type__c = \'' +
+ '璁㈠崟' +
+ '\' and recordtypeid =\'' +
+ System.Label.RT_ConOrder_Delivery +
+ '\' and Dealer_Info__c =\'' +
+ accountid +
+ '\' and (OrderNumber_notarrive__c > 0 or Delivery_detail_count__c >0) ';
+ soql += 'and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' ';
+ soql += 'and showFalseNotshowTrue__c = false';
+ if (!String.isBlank(category1)) {
+ soql +=
+ ' and Name like \'%' +
+ String.escapeSingleQuotes(category1.replaceAll('%', '\\%')) +
+ '%\' ';
+ }
+ if (cate2 != null) {
+ soql += ' and Shipment_date__c = :cate2 ';
+ }
+ soql += ' and Order_ProType__c =\'' + agencyProType + '\'';
+ soql += ' order by Deliver_date__c';
+ system.debug('====soql:' + soql);
+ raesList = Database.query(soql);
+ results.raesList = raesList;
+ 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 String agencyProType;
+ @AuraEnabled
+ public String category1;
+ @AuraEnabled
+ public Date cate2;
+ @AuraEnabled
+ public String eSetId;
+ @AuraEnabled
+ public String accountId;
+ @AuraEnabled
+ public List<String> title;
+ @AuraEnabled
+ public List<Consumable_order__c> raesList;
+ @AuraEnabled
+ public String userWorkLocation;
+ @AuraEnabled
+ public Integer totalNum;
+ @AuraEnabled
+ public Integer orderNumberArrived;
+ @AuraEnabled
+ public Integer deliveryDetailCount;
+ @AuraEnabled
+ public Integer orderNumberNotarrive;
+ @AuraEnabled
+ public Integer moreThanSevenDays;
+ @AuraEnabled
+ public Boolean isNoteStay;
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.1