| | |
| | | * |
| | | */ |
| | | public without sharing class LexConsumableOrderManageController { |
| | | public static Consumable_order__c coc { get; set; } |
| | | public static String agencyProType { get; set; } |
| | | public static String category1 { get; set; } |
| | | public static String baseUrl { get; private set; } |
| | | private static String[] columus = new List<String>{ 'Product2__c.Name' }; |
| | | public static List<SelectOption> provinceOpts { get; set; } |
| | | public static List<CusOption> provinceCusOpts; |
| | | 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; |
| | | public static Boolean hasHop { get; set; } |
| | | public static Boolean hasSpecial { get; set; } |
| | | public LexConsumableOrderManageController() { |
| | | baseUrl = URL.getSalesforceBaseUrl().toExternalForm(); |
| | | public static Consumable_order__c coc { get; set; } |
| | | public static String agencyProType { get; set; } |
| | | public static String category1 { get; set; } |
| | | public static String baseUrl { get; private set; } |
| | | private static String[] columus = new List<String>{ 'Product2__c.Name' }; |
| | | public static List<SelectOption> provinceOpts { get; set; } |
| | | public static List<CusOption> provinceCusOpts; |
| | | 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; |
| | | public static Boolean hasHop { get; set; } |
| | | public static Boolean hasSpecial { get; set; } |
| | | public LexConsumableOrderManageController() { |
| | | baseUrl = URL.getSalesforceBaseUrl().toExternalForm(); |
| | | } |
| | | |
| | | @AuraEnabled |
| | | public static Results init1() { |
| | | Results results = new Results(); |
| | | results.isNoteStay = LexUtility.getIsNoteStay(); |
| | | try { |
| | | String userId = UserInfo.getUserId(); |
| | | // String userId = '0050l000007CAieAAG'; |
| | | List<user> Useracc = new List<user>(); |
| | | Useracc = [ |
| | | SELECT accountid, Work_Location__c, UserPro_Type__c |
| | | FROM user |
| | | WHERE id = :userId |
| | | ]; |
| | | accountid = Useracc[0].accountid; |
| | | agencyProType = Useracc[0].UserPro_Type__c; |
| | | if (String.isBlank(Useracc[0].UserPro_Type__c)) { |
| | | agencyProType = 'ET'; |
| | | } |
| | | userWorkLocation = Useracc[0].Work_Location__c; |
| | | coc = new Consumable_order__c(); |
| | | // 获得订单一览 |
| | | Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe() |
| | | .get('Consumable_order__c') |
| | | .getDescribe() |
| | | .fieldSets.getMap(); |
| | | Schema.FieldSet fs = fsMap.get('order_view'); |
| | | // 获得订单中的所有项目 |
| | | List<FieldSetMember> fsmList = fs.getFields(); |
| | | // 获得字段标签和字段名 |
| | | title = new List<String>(); |
| | | column = new List<String>(); |
| | | columns = new List<List<String>>(); |
| | | List<CusCol> cols = new List<CusCol>(); |
| | | for (FieldSetMember fsm : fsmList) { |
| | | //add by Link |
| | | if ( |
| | | fsm.getFieldPath() == 'Order_ForHospital__c' && |
| | | agencyProType == 'ET' |
| | | ) { |
| | | } else { |
| | | CusCol col = new CusCol(); |
| | | col.label = fsm.getLabel(); |
| | | col.fieldName = fsm.getFieldPath(); |
| | | col.hideDefaultActions = true; |
| | | // col.sortable = true; |
| | | col.wrapText = true; |
| | | if (fsm.getFieldPath() == 'Order_ForHospital__c') { |
| | | col.type = 'url'; |
| | | col.fieldName = 'hosUrl'; |
| | | TypeAttr typeAttributes1 = new TypeAttr(); |
| | | CusLable cusLabel = new CusLable(); |
| | | cusLabel.fieldName = 'hosName'; |
| | | typeAttributes1.label = cusLabel; |
| | | typeAttributes1.target = '_blank'; |
| | | col.typeAttributes = typeAttributes1; |
| | | } |
| | | if (fsm.getFieldPath() == 'Name') { |
| | | col.type = 'url'; |
| | | col.fieldName = 'nameUrl'; |
| | | TypeAttr typeAttributes1 = new TypeAttr(); |
| | | CusLable cusLabel = new CusLable(); |
| | | cusLabel.fieldName = 'Name'; |
| | | typeAttributes1.label = cusLabel; |
| | | typeAttributes1.target = '_blank'; |
| | | col.typeAttributes = typeAttributes1; |
| | | } |
| | | cols.add(col); |
| | | } |
| | | //update by rentx 2020-12-22 start |
| | | if ( |
| | | fsm.getLabel() == '医院' && |
| | | agencyProType != null && |
| | | agencyProType == 'ET' |
| | | ) { |
| | | } else { |
| | | title.add(fsm.getLabel()); |
| | | } |
| | | if ( |
| | | fsm.getFieldPath() == 'Order_ForHospital__c' && |
| | | agencyProType != null && |
| | | agencyProType == 'ET' |
| | | ) { |
| | | } else { |
| | | column.add(fsm.getFieldPath()); |
| | | columns.add(fsm.getFieldPath().split('\\.')); |
| | | } |
| | | } |
| | | provinceOpts = new List<SelectOption>(); |
| | | provinceOpts.add(new SelectOption('', '-无-')); |
| | | provinceOpts.add(new SelectOption('草案中', '草案中')); |
| | | provinceOpts.add(new SelectOption('已提交', '已提交')); |
| | | provinceOpts.add(new SelectOption('批准', '批准')); |
| | | provinceOpts.add(new SelectOption('驳回', '驳回')); |
| | | //针对lwc的自定义option |
| | | provinceCusOpts = new List<CusOption>(); |
| | | provinceCusOpts.add(new CusOption('-无-', '')); |
| | | provinceCusOpts.add(new CusOption('草案中', '草案中')); |
| | | provinceCusOpts.add(new CusOption('已提交', '已提交')); |
| | | provinceCusOpts.add(new CusOption('批准', '批准')); |
| | | provinceCusOpts.add(new CusOption('驳回', '驳回')); |
| | | // 获得显示数据 |
| | | raesList = new List<Consumable_order__c>(); |
| | | String soql = 'select Id'; |
| | | for (String s : column) { |
| | | soql += ',' + s; |
| | | } |
| | | soql += |
| | | ',Order_ForHospital__r.Name from Consumable_order__c where Order_type__c = \'' + |
| | | '订单' + |
| | | '\''; |
| | | soql += ' and RecordtypeId = \'' + System.Label.RT_ConOrder_Order + '\''; |
| | | soql += ' and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\''; |
| | | soql += ' and Order_ProType__c =\'' + agencyProType + '\' '; |
| | | soql += |
| | | ' and Dealer_Info__c =\'' + |
| | | accountid + |
| | | '\' order by Order_status__c '; |
| | | System.debug('====soql====' + soql); |
| | | raesList = Database.query(soql); |
| | | //add by rentx 2021-3-10 start |
| | | //为 hasHop 赋值 判断当前经销商下是否有特价医院 |
| | | List<hospitalprice__c> hopList = [ |
| | | SELECT id, hospital__c |
| | | FROM hospitalprice__c |
| | | WHERE account__c = :accountid |
| | | ]; |
| | | if (hopList == null || hopList.size() == 0) { |
| | | hasHop = false; |
| | | } else { |
| | | hasHop = true; |
| | | } |
| | | //为 hasSpecial 赋值 判断当前经销商下是否有促销商品 |
| | | //查询当前经销商下的有效合同 |
| | | List<Account> contractList = [ |
| | | SELECT Id, Name, RecordType.DeveloperName |
| | | FROM Account |
| | | WHERE |
| | | RecordType.DeveloperName = 'AgencyContract' |
| | | AND Contact_Type__c LIKE :agencyProType |
| | | AND Agent_Ref__c = :accountid |
| | | ]; |
| | | List<Id> dealIds = new List<Id>(); |
| | | if (contractList != null && contractList.size() > 0) { |
| | | for (Account acc : contractList) { |
| | | dealIds.add(acc.Id); |
| | | } |
| | | List<Dealer_Product__c> deList = [ |
| | | SELECT id |
| | | FROM Dealer_Product__c |
| | | WHERE Dealer_Contact__c IN :dealIds |
| | | ]; |
| | | if (deList == null || deList.size() == 0) { |
| | | hasSpecial = false; |
| | | } else { |
| | | hasSpecial = true; |
| | | } |
| | | } else { |
| | | hasSpecial = false; |
| | | } |
| | | results.result = 'Success'; |
| | | results.provinceOpts = provinceCusOpts; |
| | | results.raesList = raesList; |
| | | results.agencyProType = agencyProType; |
| | | results.userWorkLocation = userWorkLocation; |
| | | results.accountid = accountid; |
| | | results.hasHop = hasHop; |
| | | results.hasSpecial = hasSpecial; |
| | | results.title = title; |
| | | results.cols = cols; |
| | | } catch (Exception e) { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); |
| | | } |
| | | return results; |
| | | } |
| | | |
| | | @AuraEnabled |
| | | public static Results searchConsumableorderdetails( |
| | | String categoryStr, |
| | | Date orderDate, |
| | | String orderStatus, |
| | | String accountidStr, |
| | | String agencyProTypeStr, |
| | | String userWorkLocationStr |
| | | ) { |
| | | Results results = new Results(); |
| | | agencyProType = agencyProTypeStr; |
| | | userWorkLocation = userWorkLocationStr; |
| | | accountid = accountidStr; |
| | | if (String.isBlank(categoryStr)) { |
| | | category1 = null; |
| | | } else { |
| | | category1 = categoryStr; |
| | | } |
| | | coc = new Consumable_order__c(); |
| | | if (String.isBlank(orderStatus)) { |
| | | coc.Order_status__c = null; |
| | | } else { |
| | | coc.Order_status__c = orderStatus; |
| | | } |
| | | coc.Order_date__c = orderDate; |
| | | try { |
| | | Date cate2 = coc.Order_date__c; |
| | | String cate3 = coc.Order_status__c; |
| | | // 获得订单一览 |
| | | Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe() |
| | | .get('Consumable_order__c') |
| | | .getDescribe() |
| | | .fieldSets.getMap(); |
| | | Schema.FieldSet fs = fsMap.get('order_view'); |
| | | // 获得订单中的所有项目 |
| | | List<FieldSetMember> fsmList = fs.getFields(); |
| | | // 获得字段标签和字段名 |
| | | title = new List<String>(); |
| | | column = new List<String>(); |
| | | columns = new List<List<String>>(); |
| | | for (FieldSetMember fsm : fsmList) { |
| | | //update by rentx 2020-12-22 start |
| | | if ( |
| | | fsm.getLabel() == '医院' && |
| | | agencyProType != null && |
| | | agencyProType == 'ET' |
| | | ) { |
| | | } else { |
| | | title.add(fsm.getLabel()); |
| | | } |
| | | if ( |
| | | fsm.getFieldPath() == 'Order_ForHospital__c' && |
| | | agencyProType != null && |
| | | agencyProType == 'ET' |
| | | ) { |
| | | } else { |
| | | 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 += |
| | | ',Order_ForHospital__r.Name from Consumable_order__c where Order_type__c = \'' + |
| | | '订单' + |
| | | '\' and RecordtypeId = \'' + |
| | | System.Label.RT_ConOrder_Order + |
| | | '\' and Dealer_Info__c =\'' + |
| | | accountid + |
| | | '\' '; |
| | | soql += ' and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' '; |
| | | soql += ' and Order_ProType__c =\'' + agencyProType + '\' '; |
| | | if (!String.isBlank(category1)) { |
| | | soql += |
| | | ' and Name like \'%' + |
| | | String.escapeSingleQuotes(category1.replaceAll('%', '\\%')) + |
| | | '%\' '; |
| | | } |
| | | if (cate2 != null) { |
| | | soql += ' and Order_date__c = :cate2'; |
| | | } |
| | | if (cate3 != null) { |
| | | soql += ' and Order_status__c = :cate3 '; |
| | | } |
| | | soql += ' order by Order_status__c '; |
| | | system.debug('====soql:' + soql); |
| | | raesList = Database.query(soql); |
| | | system.debug('====raesList:' + raesList); |
| | | if (raesList.size() > 0) { |
| | | results.result = 'Success'; |
| | | results.raesList = raesList; |
| | | results.errorMsg = '共有' + raesList.size() + '个订单'; |
| | | } else { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = '没有搜索到相关订单'; |
| | | } |
| | | } catch (Exception e) { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); |
| | | } |
| | | return results; |
| | | } |
| | | |
| | | public class Results { |
| | | @AuraEnabled |
| | | public String result; |
| | | @AuraEnabled |
| | | public String errorMsg; |
| | | @AuraEnabled |
| | | public List<CusOption> provinceOpts; |
| | | @AuraEnabled |
| | | public List<String> title; |
| | | @AuraEnabled |
| | | public String accountid; |
| | | @AuraEnabled |
| | | public String agencyProType; |
| | | @AuraEnabled |
| | | public String userWorkLocation; |
| | | @AuraEnabled |
| | | public Boolean hasHop; |
| | | @AuraEnabled |
| | | public Boolean hasSpecial; |
| | | @AuraEnabled |
| | | public List<Consumable_order__c> raesList; |
| | | @AuraEnabled |
| | | public List<CusCol> cols; |
| | | @AuraEnabled |
| | | public Boolean isNoteStay; |
| | | } |
| | | |
| | | public class CusOption { |
| | | CusOption(String label, String value) { |
| | | this.label = label; |
| | | this.value = value; |
| | | } |
| | | |
| | | @AuraEnabled |
| | | public static Results init1() { |
| | | Results results = new Results(); |
| | | results.isNoteStay = LexUtility.getIsNoteStay(); |
| | | try { |
| | | String userId = UserInfo.getUserId(); |
| | | // String userId = '0050l000007CAieAAG'; |
| | | List<user> Useracc = new List<user>(); |
| | | Useracc = [ |
| | | SELECT accountid, Work_Location__c, UserPro_Type__c |
| | | FROM user |
| | | WHERE id = :userId |
| | | ]; |
| | | accountid = Useracc[0].accountid; |
| | | agencyProType = Useracc[0].UserPro_Type__c; |
| | | if (String.isBlank(Useracc[0].UserPro_Type__c)) { |
| | | agencyProType = 'ET'; |
| | | } |
| | | userWorkLocation = Useracc[0].Work_Location__c; |
| | | coc = new Consumable_order__c(); |
| | | // 获得订单一览 |
| | | Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe().get('Consumable_order__c').getDescribe().fieldSets.getMap(); |
| | | Schema.FieldSet fs = fsMap.get('order_view'); |
| | | // 获得订单中的所有项目 |
| | | List<FieldSetMember> fsmList = fs.getFields(); |
| | | // 获得字段标签和字段名 |
| | | title = new List<String>(); |
| | | column = new List<String>(); |
| | | columns = new List<List<String>>(); |
| | | List<CusCol> cols = new List<CusCol>(); |
| | | for (FieldSetMember fsm : fsmList) { |
| | | //add by Link |
| | | CusCol col = new CusCol(); |
| | | col.label = fsm.getLabel(); |
| | | col.fieldName = fsm.getFieldPath(); |
| | | col.hideDefaultActions = true; |
| | | // col.sortable = true; |
| | | col.wrapText = true; |
| | | if (fsm.getFieldPath() == 'Order_ForHospital__c') { |
| | | col.type = 'url'; |
| | | col.fieldName = 'hosUrl'; |
| | | TypeAttr typeAttributes1 = new TypeAttr(); |
| | | CusLable cusLabel = new CusLable(); |
| | | cusLabel.fieldName = 'hosName'; |
| | | typeAttributes1.label = cusLabel; |
| | | typeAttributes1.target = '_blank'; |
| | | col.typeAttributes = typeAttributes1; |
| | | } |
| | | if (fsm.getFieldPath() == 'Name') { |
| | | col.type = 'url'; |
| | | col.fieldName = 'nameUrl'; |
| | | TypeAttr typeAttributes1 = new TypeAttr(); |
| | | CusLable cusLabel = new CusLable(); |
| | | cusLabel.fieldName = 'Name'; |
| | | typeAttributes1.label = cusLabel; |
| | | typeAttributes1.target = '_blank'; |
| | | col.typeAttributes = typeAttributes1; |
| | | } |
| | | cols.add(col); |
| | | //update by rentx 2020-12-22 start |
| | | if (fsm.getLabel() == '医院' && agencyProType != null && agencyProType == 'ET') { |
| | | } else { |
| | | title.add(fsm.getLabel()); |
| | | } |
| | | if (fsm.getFieldPath() == 'Order_ForHospital__c' && agencyProType != null && agencyProType == 'ET') { |
| | | } else { |
| | | column.add(fsm.getFieldPath()); |
| | | columns.add(fsm.getFieldPath().split('\\.')); |
| | | } |
| | | } |
| | | provinceOpts = new List<SelectOption>(); |
| | | provinceOpts.add(new SelectOption('', '-无-')); |
| | | provinceOpts.add(new SelectOption('草案中', '草案中')); |
| | | provinceOpts.add(new SelectOption('已提交', '已提交')); |
| | | provinceOpts.add(new SelectOption('批准', '批准')); |
| | | provinceOpts.add(new SelectOption('驳回', '驳回')); |
| | | //针对lwc的自定义option |
| | | provinceCusOpts = new List<CusOption>(); |
| | | provinceCusOpts.add(new CusOption('-无-', '')); |
| | | provinceCusOpts.add(new CusOption('草案中', '草案中')); |
| | | provinceCusOpts.add(new CusOption('已提交', '已提交')); |
| | | provinceCusOpts.add(new CusOption('批准', '批准')); |
| | | provinceCusOpts.add(new CusOption('驳回', '驳回')); |
| | | // 获得显示数据 |
| | | raesList = new List<Consumable_order__c>(); |
| | | String soql = 'select Id'; |
| | | for (String s : column) { |
| | | soql += ',' + s; |
| | | } |
| | | soql += ',Order_ForHospital__r.Name from Consumable_order__c where Order_type__c = \'' + '订单' + '\''; |
| | | soql += ' and RecordtypeId = \'' + System.Label.RT_ConOrder_Order + '\''; |
| | | soql += ' and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\''; |
| | | soql += ' and Order_ProType__c =\'' + agencyProType + '\' '; |
| | | soql += ' and Dealer_Info__c =\'' + accountid + '\' order by Order_status__c '; |
| | | System.debug('====soql====' + soql); |
| | | raesList = Database.query(soql); |
| | | //add by rentx 2021-3-10 start |
| | | //为 hasHop 赋值 判断当前经销商下是否有特价医院 |
| | | List<hospitalprice__c> hopList = [SELECT id, hospital__c FROM hospitalprice__c WHERE account__c = :accountid]; |
| | | if (hopList == null || hopList.size() == 0) { |
| | | hasHop = false; |
| | | } else { |
| | | hasHop = true; |
| | | } |
| | | //为 hasSpecial 赋值 判断当前经销商下是否有促销商品 |
| | | //查询当前经销商下的有效合同 |
| | | List<Account> contractList = [ |
| | | SELECT Id, Name, RecordType.DeveloperName |
| | | FROM Account |
| | | WHERE RecordType.DeveloperName = 'AgencyContract' AND Contact_Type__c LIKE :agencyProType AND Agent_Ref__c = :accountid |
| | | ]; |
| | | List<Id> dealIds = new List<Id>(); |
| | | if (contractList != null && contractList.size() > 0) { |
| | | for (Account acc : contractList) { |
| | | dealIds.add(acc.Id); |
| | | } |
| | | List<Dealer_Product__c> deList = [SELECT id FROM Dealer_Product__c WHERE Dealer_Contact__c IN :dealIds]; |
| | | if (deList == null || deList.size() == 0) { |
| | | hasSpecial = false; |
| | | } else { |
| | | hasSpecial = true; |
| | | } |
| | | } else { |
| | | hasSpecial = false; |
| | | } |
| | | results.result = 'Success'; |
| | | results.provinceOpts = provinceCusOpts; |
| | | results.raesList = raesList; |
| | | results.agencyProType = agencyProType; |
| | | results.userWorkLocation = userWorkLocation; |
| | | results.accountid = accountid; |
| | | results.hasHop = hasHop; |
| | | results.hasSpecial = hasSpecial; |
| | | results.title = title; |
| | | results.cols = cols; |
| | | } catch (Exception e) { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); |
| | | } |
| | | return results; |
| | | } |
| | | |
| | | public String label; |
| | | @AuraEnabled |
| | | public static Results searchConsumableorderdetails( |
| | | String categoryStr, |
| | | Date orderDate, |
| | | String orderStatus, |
| | | String accountidStr, |
| | | String agencyProTypeStr, |
| | | String userWorkLocationStr |
| | | ) { |
| | | Results results = new Results(); |
| | | agencyProType = agencyProTypeStr; |
| | | userWorkLocation = userWorkLocationStr; |
| | | accountid = accountidStr; |
| | | if (String.isBlank(categoryStr)) { |
| | | category1 = null; |
| | | } else { |
| | | category1 = categoryStr; |
| | | } |
| | | coc = new Consumable_order__c(); |
| | | if (String.isBlank(orderStatus)) { |
| | | coc.Order_status__c = null; |
| | | } else { |
| | | coc.Order_status__c = orderStatus; |
| | | } |
| | | coc.Order_date__c = orderDate; |
| | | try { |
| | | Date cate2 = coc.Order_date__c; |
| | | String cate3 = coc.Order_status__c; |
| | | // 获得订单一览 |
| | | Map<String, Schema.FieldSet> fsMap = Schema.getGlobalDescribe().get('Consumable_order__c').getDescribe().fieldSets.getMap(); |
| | | Schema.FieldSet fs = fsMap.get('order_view'); |
| | | // 获得订单中的所有项目 |
| | | List<FieldSetMember> fsmList = fs.getFields(); |
| | | // 获得字段标签和字段名 |
| | | title = new List<String>(); |
| | | column = new List<String>(); |
| | | columns = new List<List<String>>(); |
| | | for (FieldSetMember fsm : fsmList) { |
| | | //update by rentx 2020-12-22 start |
| | | if (fsm.getLabel() == '医院' && agencyProType != null && agencyProType == 'ET') { |
| | | } else { |
| | | title.add(fsm.getLabel()); |
| | | } |
| | | if (fsm.getFieldPath() == 'Order_ForHospital__c' && agencyProType != null && agencyProType == 'ET') { |
| | | } else { |
| | | 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 += |
| | | ',Order_ForHospital__r.Name from Consumable_order__c where Order_type__c = \'' + |
| | | '订单' + |
| | | '\' and RecordtypeId = \'' + |
| | | System.Label.RT_ConOrder_Order + |
| | | '\' and Dealer_Info__c =\'' + |
| | | accountid + |
| | | '\' '; |
| | | soql += ' and Order_Owner_WorkLocal__c = \'' + userWorkLocation + '\' '; |
| | | soql += ' and Order_ProType__c =\'' + agencyProType + '\' '; |
| | | if (!String.isBlank(category1)) { |
| | | soql += ' and Name like \'%' + String.escapeSingleQuotes(category1.replaceAll('%', '\\%')) + '%\' '; |
| | | } |
| | | if (cate2 != null) { |
| | | soql += ' and Order_date__c = :cate2'; |
| | | } |
| | | if (cate3 != null) { |
| | | soql += ' and Order_status__c = :cate3 '; |
| | | } |
| | | soql += ' order by Order_status__c '; |
| | | system.debug('====soql:' + soql); |
| | | raesList = Database.query(soql); |
| | | system.debug('====raesList:' + raesList); |
| | | if (raesList.size() > 0) { |
| | | results.result = 'Success'; |
| | | results.raesList = raesList; |
| | | results.errorMsg = '共有' + raesList.size() + '个订单'; |
| | | } else { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = '没有搜索到相关订单'; |
| | | } |
| | | } catch (Exception e) { |
| | | results.result = 'Fail'; |
| | | results.raesList = new List<Consumable_order__c>(); |
| | | results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); |
| | | } |
| | | return results; |
| | | } |
| | | public String value; |
| | | } |
| | | |
| | | public class Results { |
| | | @AuraEnabled |
| | | public String result; |
| | | @AuraEnabled |
| | | public String errorMsg; |
| | | @AuraEnabled |
| | | public List<CusOption> provinceOpts; |
| | | @AuraEnabled |
| | | public List<String> title; |
| | | @AuraEnabled |
| | | public String accountid; |
| | | @AuraEnabled |
| | | public String agencyProType; |
| | | @AuraEnabled |
| | | public String userWorkLocation; |
| | | @AuraEnabled |
| | | public Boolean hasHop; |
| | | @AuraEnabled |
| | | public Boolean hasSpecial; |
| | | @AuraEnabled |
| | | public List<Consumable_order__c> raesList; |
| | | @AuraEnabled |
| | | public List<CusCol> cols; |
| | | @AuraEnabled |
| | | public Boolean isNoteStay; |
| | | } |
| | | public class CusCol { |
| | | @AuraEnabled |
| | | public String label; |
| | | @AuraEnabled |
| | | public String fieldName; |
| | | @AuraEnabled |
| | | public String type; |
| | | @AuraEnabled |
| | | public Boolean sortable; |
| | | @AuraEnabled |
| | | public Boolean wrapText; |
| | | @AuraEnabled |
| | | public Boolean hideDefaultActions; |
| | | @AuraEnabled |
| | | public TypeAttr typeAttributes; |
| | | } |
| | | |
| | | public class CusOption { |
| | | CusOption(String label, String value) { |
| | | this.label = label; |
| | | this.value = value; |
| | | } |
| | | public class TypeAttr { |
| | | @AuraEnabled |
| | | public CusLable label; |
| | | @AuraEnabled |
| | | public String target; |
| | | } |
| | | |
| | | @AuraEnabled |
| | | public String label; |
| | | @AuraEnabled |
| | | public String value; |
| | | } |
| | | |
| | | public class CusCol { |
| | | @AuraEnabled |
| | | public String label; |
| | | @AuraEnabled |
| | | public String fieldName; |
| | | @AuraEnabled |
| | | public String type; |
| | | @AuraEnabled |
| | | public Boolean sortable; |
| | | @AuraEnabled |
| | | public Boolean wrapText; |
| | | @AuraEnabled |
| | | public Boolean hideDefaultActions; |
| | | @AuraEnabled |
| | | public TypeAttr typeAttributes; |
| | | } |
| | | |
| | | public class TypeAttr { |
| | | @AuraEnabled |
| | | public CusLable label; |
| | | @AuraEnabled |
| | | public String target; |
| | | } |
| | | |
| | | public class CusLable { |
| | | @AuraEnabled |
| | | public String fieldName; |
| | | } |
| | | } |
| | | public class CusLable { |
| | | @AuraEnabled |
| | | public String fieldName; |
| | | } |
| | | } |