| | |
| | | public PageReference init() { |
| | | system.debug('test:12345'); |
| | | onlyOpp = false; |
| | | String uidParam = System.currentPageReference().getParameters().get('uid'); |
| | | // String uidParam = System.currentPageReference().getParameters().get('uid'); |
| | | //首页产品咨询单数量修改 thh 20220406 start |
| | | String uidParam = UserInfo.getUserId(); |
| | | //首页产品咨询单数量修改 thh 20220406 end |
| | | if (uidParam != null){ |
| | | User u = [select Id, FirstName, LastName from User where Id = :uidParam]; |
| | | ownerSearch = u.LastName + ' ' + u.FirstName; |
| | |
| | | text, condition, value, text2, condition2, value2, text3, condition3, value3); |
| | | String soqlForMoney = soqlForMoneyWithoutSort + ' order by CreatedDate desc limit ' + Integer.valueOf(System.Label.TotalLimit); |
| | | System.debug('soqlWithoutSort:' + soqlWithoutSort); |
| | | system.debug('aaaaaaaaaa'+soql); |
| | | system.debug('aaaaaaaaaa:'+soql); |
| | | system.debug('bbbbbbb:'+soqlForMoney); |
| | | List<Inquiry_form__c> queryList = Database.query(soql); |
| | | List<Inquiry_form__c> queryListForMoney = Database.query(soqlForMoney); |
| | |
| | | |
| | | String soql = soqlWithoutSort |
| | | + ' order by ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last') + ' limit ' + Integer.valueOf(limits); |
| | | system.debug('sort:::::'+ soql); |
| | | List<Inquiry_form__c> queryList = Database.query(soql); |
| | | String soqlForMoney = soqlForMoneyWithoutSort |
| | | + ' order by ' + this.columus[Integer.valueOf(this.sortKey)] + ' ' + (this.sortOrderAsc == true ? 'asc nulls first' : 'desc nulls last')+ ' limit ' + Integer.valueOf(System.Label.TotalLimit) ; |
| | | system.debug('sort:::::'+ soqlForMoney); |
| | | List<Inquiry_form__c> queryListForMoney = Database.query(soqlForMoney); |
| | | |
| | | |
| | |
| | | soql += ' and Hospital_Name__r.Name like \'%' + v + '%\''; |
| | | } |
| | | } |
| | | //首页产品咨询单数量修改 thh 20220406 start |
| | | if (!String.isBlank(ownerStr)) { |
| | | String[] vals = ownerStr.split(' '); |
| | | for (String v : vals) { |
| | | soql += ' and Name like \'%' + v + '%\''; |
| | | // String[] vals = ownerStr.split(' '); |
| | | // for (String v : vals) { |
| | | soql += ' and owner.Name like \'%' + ownerStr + '%\''; |
| | | // } |
| | | } |
| | | } |
| | | |
| | | //首页产品咨询单数量修改 thh 20220406 end |
| | | soql += this.makeTextSql(txt, con, val); |
| | | soql += this.makeTextSql(txt2, con2, val2); |
| | | soql += this.makeTextSql(txt3, con3, val3); |