| | |
| | | textOpts.add(new SelectOption('S:Owner.Province__c','省')); |
| | | textOpts.add(new SelectOption('S:Owner.Group__c','组')); |
| | | textOpts.add(new SelectOption('S:StageName__c','状态1')); |
| | | //DB202211286315 【周会-询价管理表】筛选项增加“状态2” xxf 20221115 start |
| | | textOpts.add(new SelectOption('S:Status_Formula__c','状态2')); |
| | | //DB202211286315 【周会-询价管理表】筛选项增加“状态2” xxf 20221115 end |
| | | textOpts.add(new SelectOption('S:Owner.Name','担当人')); |
| | | textOpts.add(new SelectOption('S:OCM__c','OCSM分类')); |
| | | textOpts.add(new SelectOption('S:Department_Name__c','科室名')); |
| | |
| | | textOpts.add(new SelectOption('S:Competitor__c','询价等级')); |
| | | //textOpts.add(new SelectOption('S:OPD_SIS_collect_evaluation_sight__r.Name',Schema.SObjectType.Opportunity.fields.OPD_SIS_collect_evaluation_sight__c.label)); |
| | | textOpts.add(new SelectOption('S:Forecast_this_month__c','本月预测')); |
| | | //DB202211121149 【周会-询价管理】周会询价表把“资金来源”添加到“数据字段”中进行筛选 xxf 20221109 start |
| | | textOpts.add(new SelectOption('S:Fund_Basis__c','资金来源')); |
| | | //DB202211121149 【周会-询价管理】周会询价表把“资金来源”添加到“数据字段”中进行筛选 xxf 20221109 end |
| | | //进口论证 fy start |
| | | textOpts.add(new SelectOption('t:if_NeedImportDemonstration__c','需要进口论证')); |
| | | //进口论证 fy end |
| | |
| | | private String makeTextSqlStr(String txt1, String con, String val) { |
| | | String soql = ''; |
| | | if (!String.isBlank(txt1)) { |
| | | //DB202211121149 【周会-询价管理】周会询价表把“资金来源”添加到“数据字段”中进行筛选 xxf 20221109 start |
| | | if (txt1 == 'S:Fund_Basis__c') { |
| | | if(val == '医院资金'){ |
| | | val = val.replaceAll('医院资金', '病院資金'); |
| | | } |
| | | if(val == '政府拨款'){ |
| | | val = val.replaceAll('政府拨款', '政府資金'); |
| | | } |
| | | if(val == '国际资金'){ |
| | | val = val.replaceAll('国际资金', '国際資金'); |
| | | } |
| | | if(val == '银行资金'){ |
| | | val = val.replaceAll('银行资金', '銀行資金'); |
| | | } |
| | | if(val == '公司/个人投资'){ |
| | | val = val.replaceAll('公司/个人投资', '会社/個人資金'); |
| | | } |
| | | if(val == '融资租赁'){ |
| | | val = val.replaceAll('融资租赁', '融资租赁(リース)'); |
| | | } |
| | | } |
| | | //DB202211121149 【周会-询价管理】周会询价表把“资金来源”添加到“数据字段”中进行筛选 xxf 20221109 end |
| | | String txt = txt1.substring(2); |
| | | String colType = txt1.substring(0, 2); |
| | | String tmpVal = val; |