From b5c5eb130ca0848124f9d136af4be142ad5aac07 Mon Sep 17 00:00:00 2001
From: binxie <137736985@qq.com>
Date: 星期一, 26 六月 2023 14:42:02 +0800
Subject: [PATCH] backup0626
---
force-app/main/default/classes/lexSearchAgencyHospitalController.cls | 42 +++++++++++++++++-------------------------
1 files changed, 17 insertions(+), 25 deletions(-)
diff --git a/force-app/main/default/classes/lexSearchAgencyHospitalController.cls b/force-app/main/default/classes/lexSearchAgencyHospitalController.cls
index f47d1c1..b244fc7 100644
--- a/force-app/main/default/classes/lexSearchAgencyHospitalController.cls
+++ b/force-app/main/default/classes/lexSearchAgencyHospitalController.cls
@@ -1,32 +1,28 @@
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);
@@ -34,29 +30,25 @@
}
@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