/**
*  2021-05-19 mzy 
* 页面提醒当前用户招标信息
*/
public with sharing class TenderManageController {

    public TenderManageController() {
        
    }

    //获取当前用户招投标项目信息
    public static TenderInformation getCurrentTenderInformation(){
        //1.根据当前用户信息进行查找
        List<Tender_information__c> AllTender = goSelectByCurrentUser();
        //2.分组
           // 1) 待确认的招投标项目
           List<Tender_information__c> MyTBCTender = new List<Tender_information__c>();
           // 2) 待关联询价的招投标项目
           List<Tender_information__c> MyTBRTender = new List<Tender_information__c>();
           // 3) 待应标的招投标项目
           List<Tender_information__c> MyTBBTender = new List<Tender_information__c>();
           // 4) 分组
           if(AllTender.size()>0){
                for(Tender_information__c tempT : AllTender){
                    //待确认
                    if( tempT.ViewWaitConfirm__c && '01.待确认'.equals(tempT.status__c)){
                        MyTBCTender.add(tempT);
                    }
                    //DB202306372336 you 20230714 start
                    //待关联询价
                    //if(tempT.ViewRelatedOpp__c && '04.待关联询价'.equals(tempT.status__c)){
                    //  MyTBRTender.add(tempT);
                    //}
                    if(tempT.ViewRelatedOpp__c) {
                      MyTBRTender.add(tempT);
                    }

                    //DB202306372336 you 20230714 end 

                    //待应标 zys 20210709 应标确认 变为 待应标确认
                    //20210716  mzy 添加 ViewBidConfirm__c 判断 排除2s6-2s9的助理的提醒
                    if(tempT.ViewBidConfirm__c&&'03.是否应标'.equals(tempT.status__c)&&tempT.NotBidApprovalStatus__c != '申请中'){
                        MyTBBTender.add(tempT);
                    }
                }
           }

        //3.封装
        // zq 20231029 千里马任务修改 start
        // TenderInformation MyTenderInformation= new TenderInformation(MyTBCTender,MyTBRTender,MyTBBTender);
        TenderInformation MyTenderInformation= new TenderInformation(MyTBCTender,MyTBRTender,MyTBBTender,new List<Tender_information__c>(),new List<Integer>());
        // zq 千里马任务修改 end
        return MyTenderInformation;
    }
    //kk 20231207 DB202309519775 start
     public static TenderTansforSubmmit getCurrentTenderTransfInformation(){
         List<TenderTansforSubmmit__c> AllTenderTransf = goSelectTransfByCurrentUser();
         List<TenderTansforSubmmit__c> MyTDPTenderTransf = new List<TenderTansforSubmmit__c>();
         if(AllTenderTransf.size()>0){
             for( TenderTansforSubmmit__c tts : AllTenderTransf){
                 MyTDPTenderTransf.add(tts);
             }
         }
         TenderTansforSubmmit MyTenderTransfInformation= new TenderTansforSubmmit(MyTDPTenderTransf);
         return MyTenderTransfInformation;
            
     }
    //kk 20231207 DB202309519775 end  

    //lwt  20231212 DB202311717846 start
    public static Integer goModifyOwnerAgreementInfomation(){
        return goModifyOwnerAgreementByCurrentUser();
    }
    //lwt  20231212 DB202311717846 end 
    //获取当前用户招投标项目信息 2023-10-16 千里马六大区显示 zq start
    public static TenderInformation getOBSATenderInformation(){
        //1.根据当前用户信息进行查找
        List<Tender_information__c> AllMyOBSATender = goSelectByOBSA();

        //2.分组
           // 1) OBSA待确认的招投标项目
           List<Tender_information__c> MyOBSATBCTender = new List<Tender_information__c>();
            // 1) 千里马六大区 OBSA待确认的招投标项目
           List<Integer> MyOBSASixAreasTender = new List<Integer>();

           // 4) 分组
           if(AllMyOBSATender.size()>0){
                    Integer MyOBSAFirstAreaNumber = 0;
                    Integer MyOBSASecondAreaNumber = 0;
                    Integer MyOBSAThirdAreaNumber = 0;
                    Integer MyOBSAFourthAreaNumber = 0;
                    Integer MyOBSAFifthAreaNumber = 0;
                    Integer MyOBSASixthAreaNumber = 0;
                for(Tender_information__c tempT : AllMyOBSATender){
                    //待确认
                    if( tempT.ViewWaitConfirm__c && '01.待确认'.equals(tempT.status__c)){
                        MyOBSATBCTender.add(tempT);
                    }
                    if('1.华北'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSAFirstAreaNumber = MyOBSAFirstAreaNumber + 1;
                    }
                    if('2.东北'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSASecondAreaNumber = MyOBSASecondAreaNumber + 1;
                    }
                    if('3.西北'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSAThirdAreaNumber = MyOBSAThirdAreaNumber + 1;
                    }
                    if('4.西南'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSAFourthAreaNumber = MyOBSAFourthAreaNumber + 1;
                    }
                    if('5.华东'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSAFifthAreaNumber = MyOBSAFifthAreaNumber + 1;
                    }
                    if('6.华南'.equals(tempT.Salesdepartment_SAP__c)){
                        MyOBSASixthAreaNumber = MyOBSASixthAreaNumber + 1;
                    }
                }
                // String OBSANum = MyOBSAFirstAreaNumber + ';' + MyOBSASecondAreaNumber +';'+ MyOBSAThirdAreaNumber +';'+ MyOBSAFourthAreaNumber +';'+MyOBSAFifthAreaNumber+';'+MyOBSASixthAreaNumber;
                MyOBSASixAreasTender.add(MyOBSAFirstAreaNumber);
                MyOBSASixAreasTender.add(MyOBSASecondAreaNumber);
                MyOBSASixAreasTender.add(MyOBSAThirdAreaNumber);
                MyOBSASixAreasTender.add(MyOBSAFourthAreaNumber);
                MyOBSASixAreasTender.add(MyOBSAFifthAreaNumber);
                MyOBSASixAreasTender.add(MyOBSASixthAreaNumber);
                // MyOBSASixAreasTender = [MyOBSAFirstAreaNumber,MyOBSASecondAreaNumber,MyOBSAThirdAreaNumber,MyOBSAFourthAreaNumber,MyOBSAFifthAreaNumber,MyOBSASixthAreaNumber];
           }

        //3.封装
        TenderInformation MyTenderInformation= new TenderInformation(new List<Tender_information__c>(),new List<Tender_information__c>(),new List<Tender_information__c>(),MyOBSATBCTender,MyOBSASixAreasTender);

        return MyTenderInformation;
    }
    //2023-10-16 千里马六大区显示 zq end

    //根据当前用户查找招标项目
    public static List<Tender_information__c> goSelectByCurrentUser(){
        //定义List封装查询结果
        List<Tender_information__c> AllTender = new List<Tender_information__c>();
        //查询
        String query = 'SELECT id,ViewRelatedOppAlert__c,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 ) ';
               //DB202306372336 you 20230714 start
               // 20231230 ssm 跳过众成补充数据，待确认数据通用改造，增加自定义标签补充soql start
               query += 'WHERE (( status__c = \'01.待确认\' AND  ViewWaitConfirm__c = true ';
               String more_query = System.Label.HomePage_NormalTen1_More;
               query += String.isNotBlank(more_query) && more_query != '无' ? more_query : '';
               query += ') ';
               // 20231230 ssm 跳过众成补充数据，待确认数据通用改造，增加自定义标签补充soql end
               //待关联询价 
               //query += 'OR ( status__c =\'04.待关联询价\' AND ViewRelatedOpp__c = true ) ';
                 query += 'OR ( ViewRelatedOpp__c = true ) ';
               //DB202306372336 you 20230714 end
               //待应标 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;
    }

    // kk 20231207 DB202309519775 start  根据当前用户查找待审批的招标转科室
    //根据当前用户查找招标项目
     public static List<TenderTansforSubmmit__c> goSelectTransfByCurrentUser(){
         //定义List封装查询结果
         List<TenderTansforSubmmit__c> AllTenderTransf = new List<TenderTansforSubmmit__c>();
         //查询
         AllTenderTransf = [SELECT id FROM TenderTansforSubmmit__c WHERE status__c='审批中'];

         return AllTenderTransf;
     }
    // kk 20231207 DB202309519775 end 

    // lwt  20231212 DB202311717846 start  根据当前用户查找待审批的招标转科室
    //根据当前用户查找需要修改拥有者的契约
    public static Integer goModifyOwnerAgreementByCurrentUser(){
        String uId=Userinfo.getUserId();
        List<Account> aL=[SELECT id  from Account where Is_Active_Formula__c='有效' and Acc_Record_Type__c = '契約' and Business_Assistant__c!=null and Business_Assistant__c=:uId and  OwnerId =:uId and  (ENG_Dealer__c=true OR ET_SP_Dealer__c=true OR SP_DealerContact__c=true)];

        return aL.size();
    }
    // lwt  20231212 DB202311717846 end 

    //根据OBSA查找招标项目  2023-10-16 千里马六大区显示 zq start
    public static List<Tender_information__c> goSelectByOBSA(){
        //定义List封装查询结果
        List<Tender_information__c> AllTender = new List<Tender_information__c>();
        //查询
        String query = 'SELECT id,ViewRelatedOppAlert__c,status__c,NotBidApprovalStatus__c,ViewWaitConfirm__c,ViewRelatedOpp__c,ViewBidConfirm__c,Salesdepartment_SAP__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 )) ';
        // 20231230 ssm 跳过众成补充数据，待确认数据通用改造，增加自定义标签补充soql start
        String more_query = System.Label.HomePage_NormalTen1_More;
        query += String.isNotBlank(more_query) && more_query != '无' ? more_query : '';
        // 20231230 ssm 跳过众成补充数据，待确认数据通用改造，增加自定义标签补充soql 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;
    }
    // 2023-10-16 千里马六大区显示 zq end

    public class TenderInformation {
        //待确认的招投标项目 : GI / SP AND 01.待确认
        public List<Tender_information__c> MyTBCTender;

        //待关联询价的招投标项目 : GI / SP AND 04.确认应标
        public List<Tender_information__c> MyTBRTender;

        //待应标的招投标项目 : AccountOwner
        public List<Tender_information__c> MyTBBTender;
    
        // 2023-10-16千里马六大区显示 zq start
        //待确认的OBSA全国招投标项目 : GI / SP AND 01.待确认
        public List<Tender_information__c> MyOBSATender;
        //待确认的OBSA 千里马六大区 
        public List<Integer> MyOBSASixAreasTender;
        // 2023-10-16千里马六大区显示 zq end

        public TenderInformation(list<Tender_information__c> MyTBCTender, list<Tender_information__c> MyTBRTender, list<Tender_information__c> MyTBBTender, list<Tender_information__c> MyOBSATender,list<Integer> MyOBSASixAreasTender) {
            this.MyTBCTender = MyTBCTender;
            this.MyTBRTender = MyTBRTender;
            this.MyTBBTender = MyTBBTender;
            // 2023-10-16千里马六大区显示 zq start
            this.MyOBSATender = MyOBSATender;
            this.MyOBSASixAreasTender = MyOBSASixAreasTender;
            // 2023-10-16千里马六大区显示 zq end
        }
    }   
    // kk 20231207 DB202309519775 start 
     public class TenderTansforSubmmit {
         //待审批的招标转科室申请
         public List<TenderTansforSubmmit__c> MyTDPTenderTransf;

         public TenderTansforSubmmit(list<TenderTansforSubmmit__c> MyTDPTenderTransf) {
             this.MyTDPTenderTransf = MyTDPTenderTransf; 
         }
     }
    // kk 20231207 DB202309519775 end
    
    

}