| | |
| | | String query = 'SELECT id,status__c,NotBidApprovalStatus__c,ViewWaitConfirm__c,ViewRelatedOpp__c,ViewBidConfirm__c '; |
| | | query += 'FROM Tender_information__c '; |
| | | //待确认 |
| | | query += 'WHERE ( status__c = \'01.待确认\' AND ViewWaitConfirm__c = true ) '; |
| | | // 20221013 ljh SWAG-CK28WT update start |
| | | // query += 'WHERE ( status__c = \'01.待确认\' AND ViewWaitConfirm__c = true ) '; |
| | | query += 'WHERE (( status__c = \'01.待确认\' AND ViewWaitConfirm__c = true ) '; |
| | | //待关联询价 |
| | | query += 'OR ( status__c =\'04.待关联询价\' AND ViewRelatedOpp__c = true ) '; |
| | | //待应标 zys 20210709 应标确认 变为 待应标确认 |
| | | query += 'OR ( status__c = \'03.是否应标\' AND NotBidApprovalStatus__c != \'申请中\' AND ViewBidConfirm__c = true) '; |
| | | |
| | | // query += 'OR ( status__c = \'03.是否应标\' AND NotBidApprovalStatus__c != \'申请中\' ) '; |
| | | query += 'OR ( status__c = \'03.是否应标\' AND NotBidApprovalStatus__c != \'申请中\' )) '; |
| | | // 20221013 ljh SWAG-CK28WT update end |
| | | |
| | | // 20221013 ljh SWAG-CK28WT add start |
| | | String proId = UserInfo.getProfileId(); |
| | | String p_2M4 = System.Label.ProfileId_2M4; |
| | | if(proId.substring(0,15) == p_2M4.substring(0,15)){ |
| | | query += ' AND OwnerId =\''+UserInfo.getUserId()+'\''; |
| | | } |
| | | System.debug('query:'+query); |
| | | // 20221013 ljh SWAG-CK28WT add end |
| | | AllTender = Database.query(query); |
| | | |
| | | return AllTender; |