/** * 2021-05-19 mzy * 页面提醒当前用户招标信息 */ public with sharing class TenderManageController { public TenderManageController() { } //获取当前用户招投标项目信息 public static TenderInformation getCurrentTenderInformation(){ //1.根据当前用户信息进行查找 List AllTender = goSelectByCurrentUser(); //2.分组 // 1) 待确认的招投标项目 List MyTBCTender = new List(); // 2) 待关联询价的招投标项目 List MyTBRTender = new List(); // 3) 待应标的招投标项目 List MyTBBTender = new List(); // 4) 分组 if(AllTender.size()>0){ for(Tender_information__c tempT : AllTender){ //待确认 if( tempT.ViewWaitConfirm__c && '01.待确认'.equals(tempT.status__c)){ MyTBCTender.add(tempT); } //待关联询价 if(tempT.ViewRelatedOpp__c && '04.待关联询价'.equals(tempT.status__c)){ MyTBRTender.add(tempT); } //待应标 zys 20210709 应标确认 变为 待应标确认 //20210716 mzy 添加 ViewBidConfirm__c 判断 排除2s6-2s9的助理的提醒 if(tempT.ViewBidConfirm__c&&'03.是否应标'.equals(tempT.status__c)&&tempT.NotBidApprovalStatus__c != '申请中'){ MyTBBTender.add(tempT); } } } //3.封装 TenderInformation MyTenderInformation= new TenderInformation(MyTBCTender,MyTBRTender,MyTBBTender); return MyTenderInformation; } //根据当前用户查找招标项目 public static List goSelectByCurrentUser(){ //定义List封装查询结果 List AllTender = new List(); //查询 String query = 'SELECT id,status__c,NotBidApprovalStatus__c,ViewWaitConfirm__c,ViewRelatedOpp__c,ViewBidConfirm__c '; query += 'FROM Tender_information__c '; //待确认 // 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 != \'申请中\' ) '; 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; } public class TenderInformation { //待确认的招投标项目 : GI / SP AND 01.待确认 public List MyTBCTender; //待关联询价的招投标项目 : GI / SP AND 04.确认应标 public List MyTBRTender; //待应标的招投标项目 : AccountOwner public List MyTBBTender; public TenderInformation(list MyTBCTender, list MyTBRTender, list MyTBBTender) { this.MyTBCTender = MyTBCTender; this.MyTBRTender = MyTBRTender; this.MyTBBTender = MyTBBTender; } } }