public with sharing class otherLookUp {
|
|
@AuraEnabled(cacheable=true)
|
public static List<Record> lookUp(String searchTerm, String objName, String filter,String visitPlaceId) {
|
system.debug('lookUp');
|
system.debug('objName:'+objName);
|
system.debug('searchTerm:'+searchTerm);
|
system.debug('filter:'+filter);
|
system.debug('visitPlaceId:'+visitPlaceId);
|
User loginUser = [Select Id, State_Hospital__c, Job_Category__c from User where Id =: UserInfo.getUserId()];
|
String reporterState = loginUser.State_Hospital__c;
|
|
List<Record> recordList = new List<Record>();
|
String qureyObjName = 'Account';
|
if(objName == 'SearchVisitorPlace_Campaign') {
|
qureyObjName = 'Campaign';
|
}
|
if(objName == 'Opportunity') {
|
qureyObjName = 'Opportunity';
|
}
|
|
if(objName == 'MaintenanceContract') {
|
qureyObjName = 'Maintenance_Contract__c';
|
}
|
if(objName == 'InfrastructureProject') {
|
qureyObjName = 'Infrastructure_Project__c';
|
}
|
|
String searchQuery = 'select Id,name from '+qureyObjName+' where Id <> null ';
|
//zzm 2023-11-24 日报询价加科室和状态 start
|
if(objName == 'Opportunity') {
|
searchQuery = 'Select Id, Opportunity_No__c, name, Department_Name__c,Field1__c,Close_Forecasted_Date__c, Competitor__c, Wholesale_Price__c from '+qureyObjName+' where Id <> null ';
|
}
|
//zzm 2023-11-24 日报询价加科室和状态 end
|
|
|
searchQuery += nameCondition(searchTerm,qureyObjName);
|
// if(String.isNotBlank(searchTerm)){
|
// if(qureyObjName=='Account'){
|
// searchQuery += 'and Name_for_Daily_Report_text__c like \'%'+ searchTerm + '%\'';
|
|
// } else{
|
// searchQuery += 'and Name LIKE \'%' + searchTerm + '%\'';
|
// }
|
// }
|
//访问场所
|
if(objName=='SearchVisitorPlace') {
|
searchQuery += ' and Hospital__r.RecordType.DeveloperName = \'HP\' and Is_Active__c <> \'無効\' order by Name ';
|
}
|
// String queryString = 'select Id, Name from Account where' + nameCondition + ' Is_Active_Formula__c = \'有效\' and RecordType.DeveloperName = \'Agency\' order by Name limit 51';
|
if(objName=='SearchVisitorPlace_Sales') {
|
searchQuery += ' and RecordType.DeveloperName = \'Agency\' and Is_Active_Formula__c = \'有效\' order by Name ';
|
}
|
// [select Id, Name from Account where Is_Active__c != '無効' and Name like :nameCondition and RecordType.DeveloperName = 'Training' order by Name limit 30]
|
if(objName=='SearchVisitorPlace_Training') {
|
searchQuery += ' and RecordType.DeveloperName = \'Training\' and Is_Active__c <> \'無効\' order by Name ';
|
}
|
// if(objName=='SearchVisitorPlace_Campaign' || objName == 'InfrastructureProject') {
|
// searchQuery += ' id !=null ';
|
// }
|
if(objName == 'InfrastructureProject') {
|
Account a = null;
|
try {
|
a = [select Id, Hospital__c from Account where Id=:visitPlaceId];
|
}
|
catch ( System.QueryException qe) {
|
return recordList;
|
}
|
|
|
searchQuery += ' and OCSM_Hospital__c=\'' + a.Hospital__c + '\' ';
|
}
|
|
//新建联系人，只能选择该医院下的所有的三级科室--没做出来
|
// if(objName == 'ContactDepartment') {
|
// List<RecordType> recordTypes= [select Id from RecordType where SobjectType = 'Account' and DeveloperName in ('Department_GYN','Department_OTH','Department_BF','Department_GI','Department_GS','Department_URO','Department_ENT','Department')];
|
// List<String> recordTypeIds = new List<String>();
|
// for(RecordType rt : recordTypes) {
|
// recordTypeIds.add(rt.Id);
|
// }
|
// Account a = null;
|
// a = [select Id, Hospital__c from Account where Id=:visitPlaceId];
|
// searchQuery += ' and OCSM_Hospital__c=\'' + a.Hospital__c + '\' and RecordTypeId in :recordTypeIds';
|
// }
|
Date toDate = Date.today();
|
Date lastDate = toDate.addYears(-1);
|
// String today = String.valueOf(Date.newInstance(toDate.year(), toDate.month(), toDate.day())).substring(0,10);
|
// String lastDate = String.valueOf(Date.newInstance(toDate.year()-1, toDate.month(), toDate.day())).substring(0,10);
|
// Date lastDate = Date.newInstance(toDate.year()-1, toDate.month(), toDate.day());
|
|
//询价单独处理
|
|
if(objName=='Opportunity') {
|
if(String.isNotBlank(visitPlaceId)){
|
searchQuery += ControllerUtil.getOppSearchSQOLforLwc(visitPlaceId,toDate,lastDate);
|
|
// searchQuery = ControllerUtil.getOppSearchSQOL(visitPlaceId,' Id <> null ' +nameCondition(searchTerm,qureyObjName));
|
}
|
}
|
searchQuery += ' limit 31';
|
|
|
system.debug('searchQuery:'+searchQuery);
|
List<Sobject> queryResult = new List<sObject>();
|
//维修合同单独处理
|
if(objName == 'MaintenanceContract') {
|
queryResult = searchMc(searchTerm,visitPlaceId);
|
} else if(objName == 'Opportunity') {
|
queryResult = ControllerUtil.getOpportunitys(searchQuery);
|
}else{
|
queryResult = Database.query(searchQuery);
|
}
|
|
Map<Id, Account> accMap = new Map<Id, Account>();
|
if(queryResult.size()>0){
|
for(Sobject sobj : queryResult){
|
Record r = new Record();
|
r.Id = sobj.id;
|
r.Name = (String)sobj.get('name');
|
//zzm 2023-11-24 日报询价加科室和状态 start
|
if(objName=='Opportunity') {
|
// r.Department_Name = (String)sobj.get('Department_Name__c');
|
// r.Competitor = (String)sobj.get('Competitor__c');
|
r.Name += '(' +(String)sobj.get('Department_Name__c') +')' +(String)sobj.get('Competitor__c');
|
|
}
|
//zzm 2023-11-24 日报询价加科室和状态 end
|
recordList.add(r);
|
accMap.put(sobj.id,null);
|
}
|
}
|
if(objName=='SearchVisitorPlace'){
|
if(recordList.size()<=50){
|
// さらに省単位のデータを検索
|
String nameCondition = nameCondition(searchTerm,'Account');
|
// Map<Id, Account> stateDepartmentMap = selectDepartByHospitalState(' and Name_for_Daily_Report_text__c like \'%'+ searchTerm + '%\' ', 31 - recordList.size());
|
Map<Id, Account> stateDepartmentMap = ControllerUtil.selectDepartByHospitalState(' Id<>null ' +nameCondition + ' and ',reporterState, 51 - recordList.size());
|
if (stateDepartmentMap.size() > 0) {
|
for (Id accId : stateDepartmentMap.keySet()) {
|
if (!accMap.containsKey(accId)) {
|
Record r = new Record();
|
r.Id = accId;
|
r.Name = stateDepartmentMap.get(accId).Name;
|
recordList.add(r);
|
}
|
}
|
}
|
}
|
}
|
system.debug(recordList);
|
return recordList;
|
}
|
public static String nameCondition(String searchTerm,String qureyObjName) {
|
String nameCondition = '';
|
List<String> qwords = new List<String>();
|
List<String> qwordstmp = searchTerm.split(' ');
|
for (String qword : qwordstmp) {
|
if (String.isBlank(qword) == false) {
|
qwords.add('%' + String.escapeSingleQuotes(qword.replaceAll('%', '')) + '%');
|
if(qureyObjName=='Account'){
|
nameCondition += ' and Name_for_Daily_Report_text__c like \'' + qwords[qwords.size() - 1] + '\' ';
|
|
} else{
|
nameCondition += ' and Name like \'' + qwords[qwords.size() - 1] + '\' ';
|
}
|
}
|
}
|
return nameCondition;
|
}
|
|
public class Record {
|
@AuraEnabled public String Id;
|
@AuraEnabled public String Name;
|
}
|
/*public static Map<Id, Account> selectDepartByHospitalState(String nameCondition, Integer limitCnt) {
|
User loginUser = [Select Id, State_Hospital__c, Job_Category__c from User where Id =: UserInfo.getUserId()];
|
String reporterState = loginUser.State_Hospital__c;
|
String queryString = 'select Id, Name, Department_Class__c, Department_Class__r.Name, Hospital__c, Hospital__r.Name from Account where Id<>null ' + nameCondition + 'and Hospital__r.RecordType.DeveloperName = \'HP\' and Is_Active__c <> \'無効\'';
|
if (loginUser.Job_Category__c == 'GI市场'
|
|| loginUser.Job_Category__c == 'SP市场'
|
|| loginUser.Job_Category__c == '服务本部'
|
|| loginUser.Job_Category__c == '培训'
|
) {
|
// 全国範囲、なにもしない
|
} else {
|
// 省単位の条件追加
|
system.debug('selectDepartByHospitalState reporterState=' + reporterState);
|
queryString += ' and Parent.Parent.State_Master__r.Name = :reporterState';
|
}
|
queryString += ' order by Name limit '+limitCnt;
|
system.debug('selectDepartByHospitalState queryString=' + queryString);
|
return new Map<Id, Account>((List<Account>) Database.query(queryString));
|
}*/
|
|
//检索询价
|
/*public static String getOppSearchSQOL(String visitorPlaceId,Date today,Date lastDate) {
|
Account a = new Account();
|
List<Account> accountList = [select Id, Hospital__c, Agent_Ref__c, Parent.Parent.RecordType.DeveloperName, Parent.RecordType.DeveloperName, RecordType.DeveloperName from Account where Id=:visitorPlaceId];
|
if(accountList.size()>0) {
|
a = accountList[0];
|
}
|
|
|
// 検索
|
String queryString = ' ';
|
// String temptoday = Date.today().format().replace('/', '-');
|
// String tempLastDate = Date.today().addDays(-365).format().replace('/', '-');
|
// Date today = Datetime.now().date();
|
// Date lastDate = Datetime.now().date().addyears(-1);
|
|
// 病院
|
if (a.Parent.Parent.RecordType.DeveloperName == 'HP') {
|
|
|
|
// queryString = 'Select Id, Opportunity_No__c, Name, toLabel(StageName), Department_Name__c,Field1__c,Close_Forecasted_Date__c, Competitor__c, Wholesale_Price__c from Opportunity where' + nameCondition
|
// + ' Account.Hospital__c=\'' + a.Hospital__c + '\' and ( StageName IN (\'引合\',\'注残\') or ( StageName = \'出荷\' and Shipping_Finished_Day__c > '+tempLastDate+' and Shipping_Finished_Day__c <= '+temptoday+' and CALENDAR_YEAR(Created_Day__c) != 2012 )) and RecordTypeId in (\'01210000000QekK\',\'012100000006KMeAAM\') order by Name, Opportunity_No__c, Department_Name__c limit 31';
|
|
|
queryString += ' and Account.Hospital__c=\'' + a.Hospital__c + '\' and ( StageName IN (\'引合\',\'注残\') or ( StageName = \'出荷\' and Shipping_Finished_Day__c > :lastDate and Shipping_Finished_Day__c <= :today and CALENDAR_YEAR(Created_Day__c) != 2012 )) and RecordTypeId in (\'01210000000QekK\',\'012100000006KMeAAM\') order by Name, Opportunity_No__c, Department_Name__c ';
|
// queryString += ' and Account.Hospital__c=\'' + a.Hospital__c + '\' and ( StageName IN (\'引合\',\'注残\') or ( StageName = \'出荷\' and CALENDAR_YEAR(Created_Day__c) <> 2012 )) and RecordTypeId in (\'01210000000QekK\',\'012100000006KMeAAM\') order by Name, Opportunity_No__c, Department_Name__c ';
|
}
|
// 販売店
|
else if (a.RecordType.DeveloperName == 'Agency') {
|
queryString += ' and Account.Hospital__c=\'' + a.Hospital__c + '\' and ( StageName IN (\'引合\',\'注残\') or ( StageName = \'出荷\' and Shipping_Finished_Day__c > :lastDate and Shipping_Finished_Day__c <= :today and CALENDAR_YEAR(Created_Day__c) != 2012 )) and RecordTypeId in (\'01210000000QekK\',\'012100000006KMeAAM\') order by Name, Opportunity_No__c, Department_Name__c';
|
// queryString += ' and Account.Hospital__c=\'' + a.Hospital__c + '\' and ( StageName IN (\'引合\',\'注残\') or ( StageName = \'出荷\' CALENDAR_YEAR(Created_Day__c) <> 2012 )) and RecordTypeId in (\'01210000000QekK\',\'012100000006KMeAAM\') order by Name, Opportunity_No__c, Department_Name__c ';
|
|
}
|
return queryString;
|
}*/
|
|
|
|
//检索合同
|
|
public static List<Maintenance_Contract__c> searchMc(String query, String visitorPlaceId) {
|
// Xin_SearchOpportunityと同じにする
|
List<String> qwords = new List<String>();
|
List<String> qwordstmp = query.split(' ');
|
String nameCondition = '';
|
for (String qword : qwordstmp) {
|
if (String.isBlank(qword) == false) {
|
qwords.add('%' + String.escapeSingleQuotes(qword.replaceAll('%', '')) + '%');
|
nameCondition += ' and Name like \'' + qwords[qwords.size() - 1] + '\' ';
|
}
|
}
|
|
Account a = null;
|
try {
|
a = [select Hospital__c from Account where Id=:visitorPlaceId];
|
}
|
catch ( System.QueryException qe) {
|
return new List<Maintenance_Contract__c>();
|
}
|
|
system.debug('cond=' + nameCondition);
|
|
String queryString = 'select Id, Name,Management_Code__c,Status__c from Maintenance_Contract__c where Id<>null ' + nameCondition + ' and Hospital__c=\'' + a.Hospital__c + '\' AND Status__c in (\'契約\',\'契約満了\') order by Status__c ASC limit 31';
|
System.debug(queryString);
|
return (List<Maintenance_Contract__c>) Database.query(queryString);
|
}
|
|
|
|
}
|
