From 41ad0c0840a6135b7acf2280f0eebdc29bf6479b Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期二, 30 五月 2023 14:25:11 +0800
Subject: [PATCH] backup0530
---
force-app/main/default/classes/LexInventoryViewController.cls | 132 +++++++++++++++++++++++++------------------
1 files changed, 77 insertions(+), 55 deletions(-)
diff --git a/force-app/main/default/classes/LexInventoryViewController.cls b/force-app/main/default/classes/LexInventoryViewController.cls
index 71b43cb..de38e52 100644
--- a/force-app/main/default/classes/LexInventoryViewController.cls
+++ b/force-app/main/default/classes/LexInventoryViewController.cls
@@ -7,9 +7,8 @@
public static Integer pagesize { get; set; }
public static Integer pageToken { get; set; }
public static String sortField { get; set; }
- public static String sortOrder{ get; set; }
+ public static String sortOrder { get; set; }
-
public static Integer totalcount { get; set; }
// public static Integer pagecount { get; set; }
// public static Integer currentpage { get; set; }
@@ -86,19 +85,16 @@
}
@AuraEnabled
- public static ResponseBodyLWC init2(Integer pageSizeLWC,Integer pageTokenLWC,String sortFieldLWC,String sortOrderLWC) {
+ public static ResponseBodyLWC init2(Integer pageSizeLWC, Integer pageTokenLWC, String sortFieldLWC, String sortOrderLWC) {
return new ResponseBodyLWC('Error', 500, '娴嬭瘯 init2', '');
}
@AuraEnabled
public static ResponseBodyLWC init(Integer pageSizeLWC, Integer pageTokenLWC, String sortFieldLWC, String sortOrderLWC) {
- pageSize =pageSizeLWC;
+ pageSize = pageSizeLWC;
pageToken = pageTokenLWC;
sortField = sortFieldLWC;
sortOrder = sortOrderLWC;
-
-
-
ResponseBodyLWC res = new ResponseBodyLWC();
Map<String, object> data = new Map<String, object>();
@@ -108,11 +104,6 @@
category4OptionMap = new Map<String, String>();
category5OptionMap = new Map<String, String>();
- // sortKey = '2';
- // preSortKey = '2';
- // sortOrderAsc = false;
- // sortOrder = new List<String>(8);
- // sortOrder = new List<String>{ ' ', '', ' ', ' ', '', '', '', '鈫�' };
// 鍙栫敤鎴稩D
String userId = UserInfo.getUserId();
@@ -400,12 +391,10 @@
PaginatedAccounts paginatedAccounts = new PaginatedAccounts();
paginatedAccounts.nextPageToken = (pageToken + pageSize < totalCount) ? pageToken + pageSize : null;
paginatedAccounts.recordStart = pageToken + 1;
- paginatedAccounts.pageNumber = pageToken/pageSize + 1;
+ paginatedAccounts.pageNumber = pageToken / pageSize + 1;
Integer recordEnd = pageSize * paginatedAccounts.pageNumber;
paginatedAccounts.recordEnd = totalCount >= recordEnd ? recordEnd : totalCount;
paginatedAccounts.totalRecords = totalCount;
-
-
data.put('paginatedAccounts', paginatedAccounts);
@@ -421,17 +410,25 @@
data.put('userWorkLocation', userWorkLocation);
data.put('agencyProType', agencyProType);
data.put('pageRecords', pageRecords);
+ data.put('consumableorderdetailsRecords', consumableorderdetailsRecords);
+ data.put('hasHos', hasHos);
+ data.put('productLimtAndDate',proLimitAndDate);
res.status = 'Success';
res.code = 200;
System.debug('res = ' + res);
return res;
}
-
- public static void categoryAllload() {
+ @AuraEnabled
+ public static ResponseBodyLWC categoryAllload(String category3LWC,String agencyProTypeLWC) {
ResponseBodyLWC res = new ResponseBodyLWC();
- // Map<String, object> data = new Map<String, object>();
- // dataselect = new List<SelectOption>();
- // res.entity = dataselect;
+ Map<String, object> data = new Map<String, object>();
+ res.entity = data;
+ category3 = category3LWC;
+ agencyProType = '%' + agencyProTypeLWC + '%';
+
+ System.debug('category3LWC===>'+category3LWC);
+ System.debug('agencyProType===>'+agencyProType);
+
AggregateResult[] category4List = [
SELECT Count(id), Category4_text__c c4c
FROM Product2__c
@@ -445,9 +442,13 @@
];
category4OptionList = new List<SelectOption>();
category4OptionList.add(new SelectOption('', '-鏃�-'));
+ category4OptionMap = new Map<String, String>();
+ category4OptionMap.put('', '-鏃�-');
+
for (AggregateResult category4Search : category4List) {
String deliverycnt4 = String.valueOf(category4Search.get('c4c'));
category4OptionList.add(new SelectOption(deliverycnt4, deliverycnt4));
+ category4OptionMap.put(deliverycnt4, deliverycnt4);
}
AggregateResult[] category5List = [
@@ -464,16 +465,21 @@
category5OptionList = new List<SelectOption>();
category5OptionList.add(new SelectOption('', '-鏃�-'));
+ category5OptionMap = new Map<String, String>();
+ category5OptionMap.put('', '-鏃�-');
for (AggregateResult category5Search : category5List) {
String deliverycnt5 = String.valueOf(category5Search.get('c5c'));
category5OptionList.add(new SelectOption(deliverycnt5, deliverycnt5));
+ category5OptionMap.put(deliverycnt5, deliverycnt5);
}
-
- // data.put('category4OptionList'+category4OptionList);
- // data.put('category5OptionList'+category5OptionList);
- // res.status = 'Success';
- // res.code = '200';
- // return res;
+ System.debug('绫诲埆4'+category4OptionList);
+ System.debug('绫诲埆5'+category5OptionList);
+ data.put('category4OptionMap', category4OptionMap);
+ data.put('category5OptionMap', category5OptionMap);
+ res.status = 'Success';
+ res.code = 200;
+ System.debug('res = ' + res);
+ return res;
}
public static void categoryload() {
@@ -525,13 +531,16 @@
String accountName,
string agencyProType,
string userWorkLocation,
- Integer pageSizeLWC, Integer pageTokenLWC, String sortFieldLWC, String sortOrderLWC
+ Integer pageSizeLWC,
+ Integer pageTokenLWC,
+ String sortFieldLWC,
+ String sortOrderLWC
) {
try {
- pageSize =pageSizeLWC;
- pageToken = pageTokenLWC;
- sortField = sortFieldLWC;
- sortOrder = sortOrderLWC;
+ pageSize = pageSizeLWC;
+ pageToken = pageTokenLWC;
+ sortField = sortFieldLWC;
+ sortOrder = sortOrderLWC;
orderDetZaikuList = orderDetZaikuListLWC;
sqlagencyProType = '%' + agencyProType + '%';
@@ -590,13 +599,18 @@
System.debug('orderDetZaikuList = ' + orderDetZaikuList);
System.debug('accountName = ' + accountName);
System.debug('soql====>' + soql);
- if(String.isNotBlank(sortField) && String.isNotBlank(sortOrder)){
- soql += ' ORDER BY ' + sortField + ' ' + sortOrder;
- }
+ //鎺掑簭
+ // if (String.isNotBlank(sortField) && String.isNotBlank(sortOrder)) {
+ // if(sortFieldLWC != 'limitCount'){
+ // soql += ' ORDER BY ' + sortField + ' ' + sortOrder;
+
+ // }
+ // }
System.debug('soql = ' + soql);
//soql += ' ORDER BY ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last');
List<Product2__c> queryList = Database.query(soql);
System.debug('queryList = ' + queryList);
+
for (Integer i = 0; i < queryList.size(); i++) {
MidMap.put(queryList[i].Id, queryList[i]);
}
@@ -758,19 +772,29 @@
PaginatedAccounts paginatedAccounts = new PaginatedAccounts();
paginatedAccounts.nextPageToken = (pageToken + pageSize < totalCount) ? pageToken + pageSize : null;
paginatedAccounts.recordStart = pageToken + 1;
- paginatedAccounts.pageNumber = pageToken/pageSize + 1;
+ paginatedAccounts.pageNumber = pageToken / pageSize + 1;
Integer recordEnd = pageSize * paginatedAccounts.pageNumber;
paginatedAccounts.recordEnd = totalCount >= recordEnd ? recordEnd : totalCount;
paginatedAccounts.totalRecords = totalCount;
-
-
+ List<ConsumableorderdetailsInfo> pageRecordsCompare = new List<ConsumableorderdetailsInfo>();
+ System.debug('queryList = ' + JSON.serialize(queryList));
+ for (Integer i = 0; i < queryList.size(); i++) {
+ for(ConsumableorderdetailsInfo ci : pageRecords){
+ if(queryList[i].Id == ci.Prod.Id){
+ System.debug('queryList[i].Id =' + queryList[i].Id);
+ System.debug('ci.Prod.Id =' + queryList[i].Id);
+ pageRecordsCompare.add(ci);
+ }
+ }
+ }
data.put('paginatedAccounts', paginatedAccounts);
data.put('accountid', accountid);
data.put('userWorkLocation', userWorkLocation);
data.put('agencyProType', agencyProType);
- data.put('pageRecords', pageRecords);
- system.debug('===========>pageRecords' + pageRecords);
+ data.put('pageRecords', pageRecordsCompare);
+ data.put('hasHos', hasHos);
+ system.debug('===========>pageRecords' + pageRecordsCompare);
system.debug('===========>data' + data);
if (pageRecords.isEmpty()) {
res.msg = '鏈悳绱㈠埌鐩稿叧娑堣�楀搧璁㈠崟锛�';
@@ -897,7 +921,7 @@
// public static void SortStore() {
// if (sortKey == preSortKey) {
// // 鏂瑰悜銇屽銈忋倠銇伩
- // sortOrderAsc = !sortOrderAsc;
+ // sortOrder = !sortOrder;
// sortOrder[Integer.valueOf(sortKey)] = (sortOrderAsc == true ? '鈫�' : '鈫�');
// } else {
// sortOrderAsc = true;
@@ -911,6 +935,7 @@
// }
// pageRecords.sort();
// }
+
//妫�绱ql鏂囧仛鎴�
private static String makeSoql(String CateName, String CateCode, String Category3, String Category4, String Category5) {
@@ -988,10 +1013,10 @@
// }
//鍒锋柊褰撳墠椤�
- public static PageReference refreshPageSize() {
- makeCurrentPageRecords();
- return null;
- }
+ // public static PageReference refreshPageSize() {
+ // makeCurrentPageRecords();
+ // return null;
+ // }
//缂栬緫褰撳墠椤靛唴瀹�
public static void makeCurrentPageRecords() {
@@ -1005,30 +1030,27 @@
Integer endIdx;
pageRecords = new List<ConsumableorderdetailsInfo>();
startIdx = pageToken;
- endIdx = pageToken+pageSize;
- if (endIdx > consumableorderdetailsRecords.size()){
+ endIdx = pageToken + pageSize;
+ if (endIdx > consumableorderdetailsRecords.size()) {
endIdx = consumableorderdetailsRecords.size();
- }
- for(Integer i=startIdx; i < endIdx ; i++){
+ }
+ for (Integer i = startIdx; i < endIdx; i++) {
pageRecords.add(consumableorderdetailsRecords.get(i));
}
}
-
//鍒嗛〉Bean
public class PaginatedAccounts {
@AuraEnabled
- public List<Account> records;
- @AuraEnabled
public Integer nextPageToken;
@AuraEnabled
- public Integer pageNumber {get;set;}
+ public Integer pageNumber { get; set; }
@AuraEnabled
- public Integer totalRecords {get;set;}
+ public Integer totalRecords { get; set; }
@AuraEnabled
- public Integer recordStart {get;set;}
+ public Integer recordStart { get; set; }
@AuraEnabled
- public Integer recordEnd {get;set;}
+ public Integer recordEnd { get; set; }
}
// Data Bean
--
Gitblit v1.9.1