From dd004276162a2bf9d042ff0aaa569dc30a95d827 Mon Sep 17 00:00:00 2001 From: binxie <137736985@qq.com> Date: 星期一, 26 六月 2023 14:23:26 +0800 Subject: [PATCH] newbackup0626 --- force-app/main/default/classes/lexSearchAgencyHospitalController.cls | 42 +++++++++++++++++++++++++----------------- 1 files changed, 25 insertions(+), 17 deletions(-) diff --git a/force-app/main/default/classes/lexSearchAgencyHospitalController.cls b/force-app/main/default/classes/lexSearchAgencyHospitalController.cls index b244fc7..f47d1c1 100644 --- a/force-app/main/default/classes/lexSearchAgencyHospitalController.cls +++ b/force-app/main/default/classes/lexSearchAgencyHospitalController.cls @@ -1,28 +1,32 @@ public without sharing class lexSearchAgencyHospitalController { //缁忛攢鍟嗙敤鎴蜂骇鍝佸垎绫伙紙ET銆丒NG锛� - public static String agencyProType {get;set;} - public static String searchName {get;set;} + public static String agencyProType { get; set; } + public static String searchName { get; set; } private static String accountid = null; @AuraEnabled - public static List<Account> at {get;set;} - + public static List<Account> at { get; set; } @AuraEnabled - public static ResponseBodyLWC init(String ctype){ + public static ResponseBodyLWC init(String ctype) { ResponseBodyLWC res = new ResponseBodyLWC(); Map<String, object> data = new Map<String, object>(); res.entity = data; - User useracc = [SELECT accountid,UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId() ]; + User useracc = [SELECT accountid, UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId()]; accountid = Useracc.accountid; agencyProType = Useracc.UserPro_Type__c; - if(String.isBlank(Useracc.UserPro_Type__c)){ + if (String.isBlank(Useracc.UserPro_Type__c)) { agencyProType = 'ET'; } String soql = 'SELECT id,Name,State_Master__c,State_Master__r.Name FROM Account'; - soql += ' where id in (SELECT Hospital__c FROM Agency_Hospital_Link__c WHERE Agency__c = \'' + accountid + '\' AND Hosptial_Type__c like \'%' + String.escapeSingleQuotes(ctype.replaceAll('%', '\\%')) + '%\')' ; + soql += + ' where id in (SELECT Hospital__c FROM Agency_Hospital_Link__c WHERE Agency__c = \'' + + accountid + + '\' AND Hosptial_Type__c like \'%' + + String.escapeSingleQuotes(ctype.replaceAll('%', '\\%')) + + '%\')'; soql += ' order by Name desc limit 100'; at = Database.query(soql); - data.put('at',at); + data.put('at', at); res.status = 'Success'; res.code = 200; System.debug('res = ' + res); @@ -30,25 +34,29 @@ } @AuraEnabled - public static ResponseBodyLWC serContact(String searchName,String ctype){ + public static ResponseBodyLWC serContact(String searchName, String ctype) { ResponseBodyLWC res = new ResponseBodyLWC(); Map<String, object> data = new Map<String, object>(); res.entity = data; - User useracc = [SELECT accountid,UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId() ]; + User useracc = [SELECT accountid, UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId()]; accountid = Useracc.accountid; - at = Database.query(makeSoql(searchName,accountid,ctype)); - data.put('at',at); + at = Database.query(makeSoql(searchName, accountid, ctype)); + data.put('at', at); res.status = 'Success'; res.code = 200; System.debug('res = ' + res); return res; } - private static String makeSoql(String searchName,String accountid,String ctype){ - + private static String makeSoql(String searchName, String accountid, String ctype) { String soql = 'SELECT id,Name,State_Master__c,State_Master__r.Name FROM Account'; - soql += ' where id in (SELECT Hospital__c FROM Agency_Hospital_Link__c WHERE Agency__c = \'' + accountid + '\' AND Hosptial_Type__c like \'%' + String.escapeSingleQuotes(ctype.replaceAll('%', '\\%')) + '%\')' ; - if(String.isNotBlank(searchName)){ + soql += + ' where id in (SELECT Hospital__c FROM Agency_Hospital_Link__c WHERE Agency__c = \'' + + accountid + + '\' AND Hosptial_Type__c like \'%' + + String.escapeSingleQuotes(ctype.replaceAll('%', '\\%')) + + '%\')'; + if (String.isNotBlank(searchName)) { soql += ' AND Name like \'%' + String.escapeSingleQuotes(searchName.replaceAll('%', '\\%')) + '%\''; } soql += ' order by Name desc limit 100'; -- Gitblit v1.9.1