/**
20201106 you
SWAG-BSC5WP
可能存在的问题 3月份创建的 opd计划是 4月份这时候还没有目标客户，所以没值
以实施日期 为标准 计算当财年 \上财年 的 目标客户
opd计划上 字段 “是否营业目标客户”来源（1/0）：：---计划出借备品信息字段 上显示 借出得哪个产品  就去对应得  对象“目标客户”（当年）上匹配对应得字段
（目标客户：）如果有 则显示1 ，没有显示0
                “是否有询价 ”    同上      去目标客户上  找 询价数：  如果有值就显示1 否则显示0
                “是否已有设备”   同上      去目标客户上  找 保有设备数：  如果有值就显示1 否则显示0
                “本期OPD次数”        同上     去目标客户上  找 opd数  累计相加
                出借次数
                是否产品OPD目标客户   看opd对象
**/
public without sharing class OPDPlanHandler extends Oly_TriggerHandler {
    /**
     *   Enum representing each of before/after CRUD events on Sobjects
     */
    private Map<Id, OPDPlan__c> newMap;
    private Map<Id, OPDPlan__c> oldMap;
    private List<OPDPlan__c> newList;
    private List<OPDPlan__c> oldList;

    public OPDPlanHandler() {
        this.newMap = (Map<Id, OPDPlan__c>) Trigger.newMap;
        this.oldMap = (Map<Id, OPDPlan__c>) Trigger.oldMap;
        this.newList = (List<OPDPlan__c>) Trigger.new;
        this.oldList = (List<OPDPlan__c>) Trigger.old;
    }

    protected override void afterUpdate() {
        //计划延期后，在延期日新规日报时间
        newEventIns();
        //计划取消后，删除日报
        //cancelEventApply();

        //2021-9-16 yjk 当opd计划完成时，更新任务和事件完成
        updateTaskAndEvent();

    }
    protected override void beforeUpdate() {

        // 20201022  mzy SFDC-BUF6LN    add
        //新建时,OPD状态为提交时,OPD无报告申请时  给推广经理赋值
        updateMng();
        // 20201022  mzy SFDC-BUF6LN    end
        //start SWAG-BSC5WP 20201106 you
        NewOppPlan();
        updateOppPlan();
        //end SWAG-BSC5WP 20201106 you
    }
    //start SWAG-BSC5WP 20201106 you
    protected override void afterInsert() {
       //start SWAG-BSC5WP 20201106 you
        NewOppPlan();
        //end SWAG-BSC5WP 20201106 you
        
    }

    // ***SWAG-BZCAHL***XHL***20210331***START*********
    protected override void beforeInsert() {
       
        beforeOpdPlan();
    }

    private void beforeOpdPlan() {
        //  OPD计划点击"再申请"按钮 创建生成的新OPD计划 的 再申请 复选框 赋值 
        List<String> originalOpdPlanIdList = new List<String>();
        Map<String,OPDPlan__c> originalOpdPlanIdMap = new Map<String,OPDPlan__c>();

        List<String> originalOpdPlanApplicationIdList = new List<String>();
        Map<String,OPDPlan__c> originalOpdPlanApplicationIdMap = new Map<String,OPDPlan__c>();

        for (OPDPlan__c nObj : newList) {
            if (String.isNotBlank(nObj.OriginalOpdPlan__c) && String.isNotBlank(nObj.OriginalOpdPlanApplication__c)) {
                // 报错
                nObj.OriginalOpdPlan__c.addError('原OPD计划(再申请) 与 原OPD计划(补充申请) 只能一个有值');
            }
            if (String.isNotBlank(nObj.OriginalOpdPlan__c)) {
                originalOpdPlanIdList.add(nObj.OriginalOpdPlan__c);
            }
            if (String.isNotBlank(nObj.OriginalOpdPlanApplication__c)) {
                originalOpdPlanApplicationIdList.add(nObj.OriginalOpdPlanApplication__c);
            }
            //20210422 ljh add SWAG-BZK68V start
            if (String.isNotBlank(nObj.OriginalOpdPlanRental__c)) {
                originalOpdPlanApplicationIdList.add(nObj.OriginalOpdPlanRental__c);
            }
            //20210422 ljh add SWAG-BZK68V end

        }
        system.debug('originalOpdPlanApplicationIdList:'+originalOpdPlanApplicationIdList.size());
        //根据模型出借配套 更新 模型出借产品 精琢技术 wql 2021/04/13 start
        updateModelLending(newList);
        //根据模型出借配套 更新 模型出借产品 精琢技术 wql 2021/04/13 end
        // OPD计划 补充申请
        system.debug('originalOpdPlanApplicationIdList:'+originalOpdPlanApplicationIdList.size());
        if (originalOpdPlanApplicationIdList.size() > 0) {

            // 获取 原OPD计划(补充申请) 的值，验证必填字段规则
            List<OPDPlan__c> getOPDPlanList = [SELECT Id,Name,
                    OwnerId, //所有人
                    Status__c, //状态
                    OPDPlan_ImplementDate__c, //OPD计划实施日期
                    OPDPlan_ImplementDate_temp__c, // OPD计划实施日期(Temp)
                    Activity_Type2__c, //拜访区分
                    Account_Laboratory__c, //科室
                    OPDPlan_Report__c, //报告书
                    Campaign__c, //学会
                    Related_Opportunity1_ID__c, //跟进询价ID1
                    Related_Opportunity2_ID__c, //跟进询价ID2
                    NoOpp_Reason__c,//无询价申请理由
                    OPDType__c, //OPD计划来源
                    SalesManager__c, //推广经理
                    SalesManager_Txt__c,
                    PlanProdDetail__c,
                    DelayCancel_Reason__c,
                    Rental_Apply2__c,
                    Rental_Apply2__r.Name,
                    RentalReson__c, //出借目的
                    noReportStatus__c, //无报告状态
                    ModelLendingProduct__c, //模型出借产品
                    CorrespondingRepairNo__c, //对应修理维修NO
                    AttachmentCertificate__c, //附件证明
                    AdditionalSupport__c //原OPD计划（追加配套用）
                      FROM OPDPlan__c WHERE Id IN:originalOpdPlanApplicationIdList]; 
            system.debug('getOPDPlanList:'+getOPDPlanList.size());
            String opdplanNameSql = '';
            String soql = 'Select Id,Name From OPDPlan__c where Id != \'\'';
            for(OPDPlan__c opdplan:getOPDPlanList){
                originalOpdPlanApplicationIdMap.put(opdplan.Id, opdplan); 

                String opdplanName = opdplan.Name.indexOf('-') >= 0 ? opdplan.Name.split('-')[0]+'%':opdplan.Name+'%';

                if (String.isNotBlank(opdplanNameSql)) {
                    opdplanNameSql +=  ' OR Name Like \'' + opdplanName +'\'';
                } else {
                    opdplanNameSql = ' AND ( Name Like \'' + opdplanName +'\'';
                }
            }
            system.debug('opdplanNameSql:'+opdplanNameSql);
            Map<String,Integer> opdplanQuantityMap = new Map<String,Integer>(); 
            if (String.isNotBlank(opdplanNameSql)) {
                soql += opdplanNameSql + ' )';
                List<OPDPlan__c> getOPDPlanList01 = Database.query(soql); 
                for (OPDPlan__c opdplan :getOPDPlanList01) {
                    String opdplanName = opdplan.Name.indexOf('-') >= 0 ? opdplan.Name.split('-')[0]:opdplan.Name;
                    Integer quantity = 1;
                    if (opdplanQuantityMap.containsKey(opdplanName)) {
                        quantity = opdplanQuantityMap.get(opdplanName) + 1;
                    }
                    opdplanQuantityMap.put(opdplanName,quantity);
                }   
            }

            for (OPDPlan__c nObj : newList) {
                //20210422 ljh update SWAG-BZK68V  start
                //String opdPlanId = nObj.OriginalOpdPlanApplication__c;
                String opdPlanId = nObj.OriginalOpdPlanApplication__c;
                String opdPlanIdR = nObj.OriginalOpdPlanRental__c;
                //if (String.isNotBlank(opdPlanId)) {
                if (String.isNotBlank(opdPlanId)||String.isNotBlank(opdPlanIdR) ) {
                    if (originalOpdPlanApplicationIdMap.containsKey(opdPlanId) || originalOpdPlanApplicationIdMap.containsKey(opdPlanIdR)) {
                        OPDPlan__c originalOpdPlanApplication = originalOpdPlanApplicationIdMap.get(opdPlanId);
                        //20210422 ljh update SWAG-BZK68V start
                        if(originalOpdPlanApplication == null){
                            originalOpdPlanApplication = originalOpdPlanApplicationIdMap.get(opdPlanIdR);
                        }
                        //20210422 ljh update SWAG-BZK68V end
                        // 验证
                        //20210422 ljh update SWAG-BZK68V 
                        //if (!nObj.RentalSplit__c) {
                        if (String.isBlank(nObj.OriginalOpdPlanRental__c)) {
                            
                            nobj.SkipValidationRulesAndWorkflows__c = true;//跳过验证规则或工作流
                            nObj.supplementaryApplication__c = true;
                            nobj.originalOpdRentalApply__c = originalOpdPlanApplication.Rental_Apply2__c;
                            //nobj.originalOpdRentalApplyName__c = originalOpdPlanApplication.Rental_Apply2__r.Name;
                            if (nObj.Account_Laboratory__c != originalOpdPlanApplication.Account_Laboratory__c) {
                                nObj.Account_Laboratory__c.addError('补充申请的OPD计划,不可修改科室的值');

                            }  
                            if ((String.isNotBlank(nObj.RentalReson__c) && !'追加配套'.equals(nObj.RentalReson__c)) || nObj.OPDPlan_ImplementDate__c != originalOpdPlanApplication.OPDPlan_ImplementDate__c) {
                                nObj.addError('出借目的必须是追加配套，且不可修改OPD计划实施日期');
                            }
                            if (originalOpdPlanApplication.Status__c != '计划中') {
                                nObj.OriginalOpdPlanApplication__c.addError('只有OPD计划状态为计划中，才能进行补充申请');
                            }
                        } 
                        // else {
                        //    nObj.PlanProdDetail__c = originalOpdPlanApplication.PlanProdDetail__c; 
                        // }
                        
                        nObj.SalesManager__c = originalOpdPlanApplication.SalesManager__c;
                        nobj.SalesManager_Txt__c = originalOpdPlanApplication.SalesManager_Txt__c;
                        nObj.Campaign__c  =  originalOpdPlanApplication.Campaign__c;
                        String opdplanName = originalOpdPlanApplication.Name;
                        if (opdplanName.indexOf('-') >=0) {
                            opdplanName = opdplanName.split('-')[0];
                        }
                        nObj.Name = opdplanName + '-' + opdplanQuantityMap.get(opdplanName);
                        system.debug('nObj---->'+nObj);
                    }   
                } 
            }   
        }

        // OPD计划 再申请
        if (originalOpdPlanIdList.size() > 0) {
           List<OPDPlan__c> getOPDPlanList = [SELECT Id,Name,PlanProdDetail__c,Campaign__c,Account_Laboratory__c,Status__c,DelayCancel_Reason__c,RentalApplyId__c,RentalApplyName__c,Rental_Apply2__r.Id,Rental_Apply2__r.Name from OPDPlan__c WHERE Id IN:originalOpdPlanIdList];
            for(OPDPlan__c opdplan:getOPDPlanList){
                originalOpdPlanIdMap.put(opdplan.Id, opdplan); 
            }

            for (OPDPlan__c nObj : newList) {
                String opdPlanId = nObj.OriginalOpdPlan__c;
                if (String.isNotBlank(opdPlanId)) {
                    if (originalOpdPlanIdMap.containsKey(opdPlanId)) {
                        
                        nObj.PlanProdDetail__c = originalOpdPlanIdMap.get(opdPlanId).PlanProdDetail__c;
                        nObj.Campaign__c  =  originalOpdPlanIdMap.get(opdPlanId).Campaign__c;
                        nObj.RentalApplyId__c = originalOpdPlanIdMap.get(opdPlanId).Rental_Apply2__r.Id;
                        nObj.RentalApplyName__c = originalOpdPlanIdMap.get(opdPlanId).Rental_Apply2__r.Name;
                        
                        if (nObj.Account_Laboratory__c != originalOpdPlanIdMap.get(opdPlanId).Account_Laboratory__c) {
                            nObj.Account_Laboratory__c.addError('再申请的OPD计划,不可修改科室的值');

                        }
                        //2021-06-28  mzy  update  备品不足 对应的API名为  无备品
                        //if (originalOpdPlanIdMap.get(opdPlanId).Status__c != '取消' || originalOpdPlanIdMap.get(opdPlanId).DelayCancel_Reason__c != '备品不足' ) {
                        if (originalOpdPlanIdMap.get(opdPlanId).Status__c != '取消' || (originalOpdPlanIdMap.get(opdPlanId).DelayCancel_Reason__c != '无备品' && originalOpdPlanIdMap.get(opdPlanId).DelayCancel_Reason__c != '备品不足')) {
                        //if (originalOpdPlanIdMap.get(opdPlanId).Status__c != '取消' || originalOpdPlanIdMap.get(opdPlanId).DelayCancel_Reason__c != '无备品') {
                            nObj.OriginalOpdPlan__c.addError('只有OPD计划状态为取消，并且延期取消理由为备品不足才可再申请');
                        }
                    }
                    
                    nObj.Reapply__c = true;
                    
                }
            
            }
        }
    }
    // ***SWAG-BZCAHL***XHL***20210331***END*********
    //end SWAG-BSC5WP 20201106 you
    private void newEventIns() {
        Set<Id> oSetIdSet = new Set<Id>();
        Map<Id,OPDPlan__c> opdMap = new Map<Id,OPDPlan__c>();
        for (OPDPlan__c nObj : newList) {
            OPDPlan__c oObj = oldMap.get(nObj.Id);
            if (oObj.OPDPlan_ImplementDate__c != null && nObj.OPDPlan_ImplementDate__c != null
                  //  && oObj.OPDPlan_ImplementDate__c < nObj.OPDPlan_ImplementDate__c) {
                && oObj.OPDPlan_ImplementDate__c !=  nObj.OPDPlan_ImplementDate__c ) {
                oSetIdSet.add(oObj.Id);
                opdMap.put(oObj.Id,oObj);
            }
        }
        system.debug('oSetIdSet+++++' + oSetIdSet);
        List<Event> eventList = new List<Event>();
        List<Event> eveCloneList = new List<Event>();
        List<Task__c> taskList = new List<Task__c>();
        if (oSetIdSet.size() > 0) {
            eventList = [select Id, StartDateTime, DurationInMinutes, EventStatus__c,Task_ID__c,
                         OPDPlan_Flag__c, Location, whatid__c, Related_Opportunity1_ID__c,
                         Activity_Type2__c, Related_Opportunity1__c, Purpose_Type__c,
                         Related_Service1__c, Related_Service1_ID__c, Activity_Purpose__c,
                         Purpose_TypeFSE__c, Purpose_TypeEscFSE__c, Activity_PurposeFSE__c,
                         Activity_PurposeEscFSE__c, Opd_Plan__c, Opd_Plan_ImplementDate__c,
                         //2021-08-13  mzy   SWAG-C5RAZV  事件——计划 延期 调查  start
                         delayReason__c,
                         //2021-08-13  mzy   SWAG-C5RAZV  事件——计划 延期 调查  end
                         Subject from Event where Opd_Plan__c in: oSetIdSet];
        }

        if (eventList.size() > 0) {
            list<Id> dailyReportOPDIdList = new list<Id>();
            //Map<String,String> tskOpdMap = new Map<String,String>();
            //Map<String,event> tskeventMap = new Map<String,event>();
            for (Event evn : eventList) {
                System.debug('new时间:'+newMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c +'旧时间'+OldMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c);
                if(newMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c < OldMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c){
                    //提前
                    Datetime startD = evn.StartDateTime;
                    Date startDateTime = Date.newInstance(startD.year(), startD.month(), startD.day());
                    Integer betweenDay = startDateTime.daysBetween(evn.Opd_Plan_ImplementDate__c);
                    evn.StartDateTime = evn.StartDateTime.addDays(betweenDay);

                    Task__c tempTask = new Task__c();
                    tempTask.Id = newMap.get(evn.Opd_Plan__c).Task_ID__c;
                    temptask.Activity_Date__c = newMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c;
                    taskList.add(tempTask);
                }else{
                    if(!(newMap.get(opdMap.get(evn.Opd_Plan__c).id)).isDailyReportDelay__c){
                        //延期
                        Event eveClone = evn.clone();
                        Datetime startD = eveClone.StartDateTime;
                        Date startDateTime = Date.newInstance(startD.year(), startD.month(), startD.day());
                        Integer betweenDay = startDateTime.daysBetween(evn.Opd_Plan_ImplementDate__c);
                        eveClone.StartDateTime = eveClone.StartDateTime.addDays(betweenDay);
                        eveClone.delayReason__c = null;
                        //20210527 zh 任务框架修改 start
                        eveClone.EventStatus__c = '02 接受';
                        if (opdMap.containsKey(evn.Opd_Plan__c)) {
                        eveClone.Task_ID__c = opdMap.get(evn.Opd_Plan__c).Task_ID__c;
                        eveClone.PlanProdDetail__c = opdMap.get(evn.Opd_Plan__c).PlanProdDetail__c;
                        }
                        //20210527 zh 任务框架修改 end

                        //2021-08-13  mzy   SWAG-C5RAZV  事件——计划 延期 调查  start
                        if(newMap.get(evn.Opd_Plan__c).DelayCancel_Reason__c!=null && evn.delayReason__c == null){
                            String DelayReason =  newMap.get(evn.Opd_Plan__c).DelayCancel_Reason__c;
                            System.debug('延期理由:'+DelayReason);
                            if('医院试用改期'.equals(DelayReason)){
                                evn.delayReason__c = '客户时间变更或冲突';
                                evn.delayReasonSelect__c = '客户时间变更或冲突';
                            }else if('工作计划变化'.equals(DelayReason)){
                                evn.delayReason__c = '与其他突发事件冲突';
                                evn.delayReasonSelect__c = '与其他突发事件冲突';
                            }else if('备品到货推迟'.equals(DelayReason)){
                                evn.delayReason__c = '备品未到';
                                evn.delayReasonSelect__c = '备品未到';
                            }else if('手术改期'.equals(DelayReason)){
                                evn.delayReason__c = '无合适病例(适合病例流失)OPD延期';
                                evn.delayReasonSelect__c = '无合适病例(适合病例流失)OPD延期';
                            }else if('日期填写错误'.equals(DelayReason)){
                                evn.delayReason__c = '日期填写错误';
                                evn.delayReasonSelect__c = '日期填写错误';
                            }else if('医院设备不到位'.equals(DelayReason)){
                                evn.delayReason__c = '医院设备不到位';
                                evn.delayReasonSelect__c = '医院设备不到位';
                            }else if('其他'.equals(DelayReason)){
                                evn.delayReason__c = '其他';
                                evn.delayReasonSelect__c = '其他';
                            }else if('系统自动延期'.equals(DelayReason)){
                                evn.delayReason__c = '其他';
                                evn.delayReasonSelect__c = '其他';
                                evn.delayReasonOther__c = DelayReason;
                            }
                            evn.delayToDate__c = newMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c;
                        }
                        evn.isDelay__c = true;
                        //2021-08-13  mzy   SWAG-C5RAZV  事件——计划 延期 调查  end
                        
                        evn.OPDPlan_Flag__c = false;                    
                        //2021-066-25 mzy OPD延期 
                        if(evn.task_ID__c == eveClone.Task_ID__c){
                            String subjectName = evn.Subject;
                            if(String.isNotBlank(subjectName)&&subjectName.contains('【')){
                                evn.Subject = subjectName.split('【')[0] + '【已延期】';
                            }else {
                                evn.Subject = subjectName +'【已延期】';
                            }
                            evn.task_ID__c = null; 
                            evn.EventStatus__c = '05 延期';
                            Task__c tempTask = new Task__c();
                            tempTask.Id = newMap.get(evn.Opd_Plan__c).Task_ID__c;
                            temptask.Activity_Date__c = newMap.get(evn.Opd_Plan__c).OPDPlan_ImplementDate__c;
                            taskList.add(tempTask);
                        }
                        evn.Opd_Plan__c = null;
                        //2021-066-25 mzy OPD延期 
                        //2022-1-7 yjk opd延期新建事件
                        if(eveClone.Subject!=null&&String.isNotBlank(eveClone.Subject)){
                            eveClone.Subject = eveClone.Subject.Split('【')[0]; 
                        }
                        eveCloneList.add(eveClone);
                    }else{
                        dailyReportOPDIdList.add(evn.Opd_Plan__c);
                        //tskOpdMap.put(opdMap.get(evn.Opd_Plan__c).Task_ID__c,evn.Opd_Plan__c);
                    }
                }
                
            }
            if(dailyReportOPDIdList.size() > 0){
                List<OPDPlan__c> opdList = [select id,Task_ID__c,Task_ID__r.delayTask__c from OPDPlan__c where id in :dailyReportOPDIdList];
                for(OPDPlan__c opdPlan : opdList){
                    opdPlan.Task_ID__c = opdPlan.Task_ID__r.delayTask__c;
                }
                update opdList;
            }

            //system.debug('eveCloneList+++++' + eveCloneList);
            //system.debug('eventList+++++' + eventList);
            update eventList;
            insert eveCloneList;
            update taskList;
        }
    }


    private void updateMng() {

        Boolean userFlg = false;

        for (OPDPlan__c n : newList) {
            if ((String.isNotBlank(n.Status__c) && n.Status__c.equals('提交')
                    && (String.isBlank(oldMap.get(n.Id).Status__c) || oldMap.get(n.Id).Status__c.equals('草案中')))) {

                // 设置是否取User的FLG
                userFlg = True;
            }
            //2022-01-05  mzy  无报告申请报错  start
            if((String.isNotBlank(n.noReportStatus__c) && n.noReportStatus__c.equals('提交')
            && (String.isBlank(oldMap.get(n.Id).noReportStatus__c) || oldMap.get(n.Id).noReportStatus__c.equals('已保存')))){
                // 设置是否取User的FLG
                userFlg = True;
            }
            //2021-01-05  mzy  无报告申请报错  end
        }
        // 取得User审批人
        List<User> uList = new List<User>();
        if (userFlg) {
            uList = [select Id, SalesManager__c, SalesManager__r.Name from user where SalesManager__r.IsActive = true And id = :UserInfo.getUserId()];
        }

        // 设置审批人
        for (OPDPlan__c n : newList) {
            if ((String.isNotBlank(n.Status__c) && n.Status__c.equals('提交')
                    && (String.isBlank(oldMap.get(n.Id).Status__c) || oldMap.get(n.Id).Status__c.equals('草案中')))                  
                || ((String.isNotBlank(n.noReportStatus__c) && n.noReportStatus__c.equals('提交')
                && (String.isBlank(oldMap.get(n.Id).noReportStatus__c) || oldMap.get(n.Id).noReportStatus__c.equals('已保存'))))) {
                
                if (uList.size() > 0) {
                    String MId = uList[0].SalesManager__c;
                    if (String.isBlank(MId)) {
                        n.addError('经理无效，请联系管理员。');
                    } else {
                        n.SalesManager__c = MId;
                        // SWAG-BZNBKZ 审批人文本化 LHJ Start
                        n.SalesManager_Txt__c = uList[0].SalesManager__r.Name;
                        // SWAG-BZNBKZ 审批人文本化 LHJ End
                    }
                }else {
                    n.addError('经理无效/离职，请联系管理员。');
                }
            }else 
            //推广经理发生变化赋值文本字段
            if(oldMap.get(n.Id).SalesManager__c != n.SalesManager__c){
                //推广经理 等于空
                if(String.isBlank(n.SalesManager__c)){
                    n.SalesManager_Txt__c = '';
                }else {
                    List<User> tempUList = new List<User>();
                    tempUList = [select Id, Name from user where IsActive = true And id = :n.SalesManager__c];
                    if(tempUList.size() > 0){
                        n.SalesManager_Txt__c = tempUList[0].Name;
                    }else {
                        n.addError('经理无效/离职，请联系管理员。');
                    }
                }
                
            }
        }
    }

    private void NewOppPlan() {
        //opd创建时把符合条件的目标客户带过来

        //将OPD计划的战略科室id放到List 当做客户-目标客户的检索条件
        Map<string, string> accsMap = new Map<string, string>();
        // 将OPD计划的战略科室id作为key ，本财年作为value 用于下面判断
        Map<string, string> opdMap = new Map<string, string>();
        List<OPDPlan__c> opdPlanList  = new List<OPDPlan__c>();
        //上一财年
        Map<string, string> opdLastMap = new Map<string, string>();
        map<id, OPDPlan__c> opplansmap = new map<id, OPDPlan__c>();
        //set<String> OpdTargetAcc = new set<String>(); //opp计划上的本财年的目标客户
       // set<String> OpdTargetLastAcc = new set<String>(); //opp计划上的上财年的目标客户
        Map<id, String> OpdTargetAcc = new Map<id, String>();
        Map<id, String> OpdTargetLastAcc = new Map<id,String>();
        Integer buffer = Integer.valueOf(System.Label.opd_oldDate_update);//为了刷新prod上的老数据
        Map<String,String> reapplyopdMap = new Map<String,String>();
        Map<String,String> sApplicationopdMap = new Map<String,String>();
        for (OPDPlan__c t : newList) {
            // Trigger.new[0].addError('=t.OCM_category_ID__c=='+t.OCM_category_ID__c); 
            if (Trigger.isInsert || (Trigger.isUpdate && (oldMap.get(t.id).Account_Laboratory__c != t.Account_Laboratory__c || buffer==1))) {
                if (t.OCM_category_ID__c  != null && t.OPDPlan_ImplementDate__c != null) {
                    accsMap.put(t.OCM_category_ID__c, t.Id);
                    Date dateToday = t.OPDPlan_ImplementDate__c;
                    // Date yesterday = dateToday.addDays(-1);
                    Integer year = dateToday.year();
                    Integer month = dateToday.month();
                    if (month < 4) {
                        year -= 1;
                    }
                    // String ocmYear = year + '年度';  本财年
                    String annual = year - 1867 + 'P';
                    opdMap.put(t.OCM_category_ID__c, annual);
                    //上财年
                    String annual1 = year - 1868 + 'P';
                    opdLastMap.put(t.OCM_category_ID__c, annual1);
                }
            }

            if (Trigger.isInsert && String.isNotBlank(t.OriginalOpdPlan__c)) {
                
                reapplyopdMap.put(t.OriginalOpdPlan__c, t.Id);
                               
            }
            //20210422 ljh update SWAG-BZK68V 
            //if (Trigger.isInsert && String.isNotBlank(t.OriginalOpdPlanApplication__c) && t.RentalSplit__c ) {
            if (Trigger.isInsert && String.isNotBlank(t.OriginalOpdPlanRental__c)) {  
                sApplicationopdMap.put(t.OriginalOpdPlanRental__c, t.Id);               
            }
        }
        // ***SWAG-BZCAHL***XHL***20210331***START*********
        // 原OPD计划下的 计划出借备品 和 附件
        if (reapplyopdMap != null && reapplyopdMap.size() > 0) {
            insertCloneData(reapplyopdMap);
        }
        // ***SWAG-BZCAHL***XHL***20210331***END*********

        // ***SWAG-BZK68V***XHL***20210420***START*********
        // 备品拆单 携带 原OPD计划下的 计划出借备品 和 附件
        if (sApplicationopdMap != null && sApplicationopdMap.size() >0) {
            insertCloneData(sApplicationopdMap);
        }
        // ***SWAG-BZK68V***XHL***20210420***END*********
        //检索OPD计划的战略科室的所有客户-目标客户
        // 20210624 SQL优化 Start
        //if (accsMap != null) {
        if (accsMap.size() > 0) {
        // 20210624 SQL优化 End
            List<Account_Number_of_target__c> anotList = [select Id, OCM_Period__c, Submit_Customer_target_new__c, Account__c
                    from Account_Number_of_target__c
                    where Account__c IN :accsMap.keySet()];
            for (OPDPlan__c t : newList) {
                OPDPlan__c opdplan = new OPDPlan__c();
                for (Account_Number_of_target__c an : anotList) {
                    //判断是否为同一战略科室
                    String subStr = an.Account__c;
                    //Trigger.new[0].addError(subStr.SubString(0,15)+'==='+t.OCM_category_ID__c);
                    if (subStr.SubString(0, 15) == t.OCM_category_ID__c) {

                        //判断本年度财年是否相同     当期的客户-目标客户

                        opdplan.Id = accsMap.get(subStr.SubString(0, 15));
                        if (opdMap.get(subStr.SubString(0, 15)) == an.OCM_Period__c) {
                            if (Trigger.isInsert) {
                                opdplan.OPD_Customers_Target__c = an.Id;
                                opdPlanList.add(opdplan);
                            }
                            if (Trigger.isUpdate && (oldMap.get(t.id).Account_Laboratory__c != t.Account_Laboratory__c || buffer==1)) {
                                t.OPD_Customers_Target__c = an.Id;
                            }
                            if(t.OPDType__c=='学会'){
                              OpdTargetAcc.put(t.id,an.Id+''); //本财年
                            }
                

                        }
                        system.debug('上财年' + opdLastMap.get(subStr.SubString(0, 15)) + '==' + an.OCM_Period__c);
                        //判断上年度财年是否相同   上期的客户-目标客户
                        if (opdLastMap.get(subStr.SubString(0, 15)) == an.OCM_Period__c) {
                            if (Trigger.isInsert) {
                                opdplan.OPD_Customers_Target_Last__c = an.Id;
                                opdPlanList.add(opdplan);
                            }
                            if (Trigger.isUpdate && (oldMap.get(t.id).Account_Laboratory__c != t.Account_Laboratory__c || buffer==1)) {
                                t.OPD_Customers_Target_Last__c = an.Id;
                            }
                            if(t.OPDType__c=='学会'){
                             OpdTargetLastAcc.put(t.id,an.Id+'');//上财年  dcListMap.keySet()  dcListMap.values()
                             }
                        }
                       
                    }
                }
            }
        }
        system.debug('==opdPlanList==' + opdPlanList);
        if(opdPlanList!=null){
            opplansmap.putall(opdPlanList);
        }
        if (Trigger.isInsert && opplansmap.size() > 0) {
            update opplansmap.values();
        }
        if (!OpdTargetAcc.isEmpty() || !OpdTargetLastAcc.isEmpty()){
            upsertOppPlan(OpdTargetAcc,OpdTargetLastAcc);
        }
        //Trigger.new[0].addError('==anotList =='+anotList+'更新的数据：'+opdPlanList);
        //更新OPD计划对象上的客户-目标客户的查找字段
        // if (Trigger.isInsert &&opdPlanList.size() > 0) update opdPlanList;
    }
    // 创建 克隆数据
    private void insertCloneData(Map<String,String> reapplyopdMap){
        // 查找原OPD计划下 计划出借备品
        List<Plan_Rental_Equipment__c> getPREList = [select Id,Name,Event_ID__c,OPD_Plan__c,Campaign__c,Rental_Quantity__c,Rental_Equipment__c from Plan_Rental_Equipment__c WHERE OPD_Plan__c  In:reapplyopdMap.keySet()];
            if (getPREList.size() > 0) {
                List<Plan_Rental_Equipment__c> insertCloneList = new List<Plan_Rental_Equipment__c>();
                for (Plan_Rental_Equipment__c pre:getPREList){
                    Plan_Rental_Equipment__c preClone = new Plan_Rental_Equipment__c();
                    preClone = pre.clone();
                    preClone.Id = null;
                    preClone.Event_ID__c = null;
                    preClone.Campaign__c = null; 
                    preClone.OPD_Plan__c = reapplyopdMap.get(pre.OPD_Plan__c);
                    insertCloneList.add(preClone);

                }

                if (insertCloneList.size() > 0) {
                    insert insertCloneList;
                }
            }
            List<Attachment> getAttachmentList = [SELECT Id, Body, Name, ParentId
                                        FROM Attachment
                                        WHERE ParentId In:reapplyopdMap.keySet()];
            List<Attachment> insertAttachmentCloneList = new List<Attachment>();
            if (getAttachmentList.size() > 0 ) {
                for(Attachment att :getAttachmentList){
                    Attachment attClone = new Attachment();
                    attClone = att.clone();
                    attClone.Id = null;
                    attClone.Body = att.Body;
                    attClone.Name = att.Name;
                    attClone.ParentId = reapplyopdMap.get(att.ParentId);
                    insertAttachmentCloneList.add(attClone);
                }

                if (insertAttachmentCloneList.size() > 0) {
                    insert insertAttachmentCloneList;
                }
            }
    }

    private void updateOppPlan() {
        
        //set<String> OpdTargetAcc = new set<String>(); //opp计划上的本财年的目标客户
        //set<String> OpdTargetLastAcc = new set<String>(); //opp计划上的上财年的目标客户
        Map<id, String> OpdTargetAcc = new Map<id, String>();
        Map<id, String> OpdTargetLastAcc = new Map<id, String>();
        Integer buffer = Integer.valueOf(System.Label.opd_oldDate_update);//为了刷新prod上的老数据
        //存放模型出借配套的id
        List<OPDPlan__c>  opdModelLendList = new  List<OPDPlan__c> ();
        for (OPDPlan__c t : newList) {

            if (Trigger.isUpdate && (oldMap.get(t.id).Status__c != t.Status__c && t.Status__c == '审批中' || buffer==1)) { 
               // OpdTargetAcc.add(t.OPD_Customers_Target__c); //本财年
               // OpdTargetLastAcc.add(t.OPD_Customers_Target_Last__c);//上财年
                OpdTargetAcc.put(t.id,t.OPD_Customers_Target__c);
                OpdTargetLastAcc.put(t.id,t.OPD_Customers_Target_Last__c);
            }

            if (Trigger.isUpdate && oldMap.get(t.id).Name != t.Name && !t.NoNSupplementaryApplication__c) {
                t.Name = oldMap.get(t.id).Name;
            }
            t.NoNSupplementaryApplication__c = false;

            //更新 模型出借产品 精琢技术 wql 2021/04/13 start
            if(Trigger.isUpdate && (oldMap.get(t.id).ModelLending__c != t.ModelLending__c)){
                opdModelLendList.add(t);
            }
            // SWAG-BUF6J5 20201112 you
            // SWAG-BXW4AH  XHL 20210312 因OPD计划 系统自动延期  后 会清空 备品出借优先度与排序日期
            // 因此 注掉 Start
            
            // if(Trigger.isUpdate && oldMap.get(t.id).OPDPlan_ImplementDate__c!= t.OPDPlan_ImplementDate__c){
            //     Date olddate=oldMap.get(t.id).OPDPlan_ImplementDate__c;
            //     Date newdate=t.OPDPlan_ImplementDate__c;
            //     System.debug('尝试反引用空对象 : '+ olddate +'*****'+newdate +'(((((' + t);
            //     if((null==olddate && newdate!=null )|| (olddate.month() != newdate.month())){
            //        Integer a;
            //        t.OPDLendSort__c=a;
            //        t.SortDate__c = null;
            //     }
            // }
            
            // SWAG-BXW4AH  XHL 20210312 因OPD计划 系统自动延期  后 会清空 备品出借优先度与排序日期
            // 因此 注掉 End
            
        }
        if(opdModelLendList.size()>0){
            updateModelLending(opdModelLendList);
        }
        
        if (!OpdTargetAcc.isEmpty() || !OpdTargetLastAcc.isEmpty()) {
            upsertOppPlan(OpdTargetAcc,OpdTargetLastAcc);
        }
    }

    //2021-9-16 yjk 当opd任务完成时，将对应的任务和事件也完成 ----start-----
    private void updateTaskAndEvent(){
        
        List<Id> taskIdList = new List<Id>();
        for (OPDPlan__c opdP: newList) {
            if('完毕'.equals(opdP.Status__c) && !'完毕'.equals(oldMap.get(opdP.Id).Status__c)&&opdP.Task_ID__c != null){
                taskIdList.add(opdP.Task_ID__c);
            }
        }
        if(taskIdList == null || taskIdList.size() == 0 ){
            return;
        }
        //2022-1-5 yjk opd任务的才能完成
        List<Id> tskupdIdList = new List<Id>();
        List<Task__c> taskList = [select id,taskStatus__c from task__c where NeedActivity__c = false and id in :taskIdList];
        for(Task__c tsk : taskList){
            tskupdIdList.add(tsk.id);
            tsk.taskStatus__c = '03 完成';
        }
        if(taskList != null && taskList.size()>0){
           update taskList; 
        }
        
        List<Event> eventList = [select id,EventStatus__c from event where Task_ID__c in :tskupdIdList];
        for(Event evt : eventList){
            evt.EventStatus__c = '03 完成';
        }
        if(eventList != null &&eventList.size()>0){
            update eventList;            
        }
    }
    //2021-9-16 yjk 当opd任务完成时，将对应的任务和事件也完成 ----end-----

    private void upsertOppPlan(Map<id, String> OpdTargetAcc,Map<id, String> OpdTargetLastAcc){
            List<OPDPlan__c> opdPlanList  = new List<OPDPlan__c>();
            map<id, OPDPlan__c> opplansmap = new map<id, OPDPlan__c>();
            set<String> OpdPlanDetail = new set<String>(); //计划出借备品信息.
            Integer FIELDMAX = 200;
            //去mapping表中找到名字为targetKeyProduct的一条数据
            SS_Batch_Column_Mapping__c mpdMapping = SS_Batch_Column_Mapping__c.getValues('targetKeyProduct');

            //对应目标客户中的一系列 opd对象   用来判断“是否产品OPD目标客户”
            List<String> column = new List<String>();
            Map<String, List<String>> tempImportantProduct = new Map<String, List<String>>();
            //对应目标客户中的一系列 目标客户字段  用来判断“是否营业目标客户”
            List<String> columnSalesTar = new List<String>();
            Map<String, List<String>> tempImportantSalesTar = new Map<String, List<String>>();
            //对应目标客户中的一系列 询价数  用来判断“是否有询价”
            List<String> columnOppCnt = new List<String>();
            Map<String, String> tempImportantOppCnt = new Map<String, String>();
            //对应目标客户中的一系列 设备数  用来判断“是否已有设备”
            List<String> columnAsset = new List<String>();
            Map<String, String> tempImportantAsset = new Map<String, String>();
            //对应目标客户中的一系列 OPD数（今年）  用来计算本期OPD次数
            List<String> columnOPDAmount = new List<String>();
            Map<String, String> tempImportantOPDAmount = new Map<String, String>();
            //对应目标客户中的一系列 借出次数  用来统计借出次数
            List<String> columnRental = new List<String>();
            Map<String, String> tempImportantRental = new Map<String, String>();

            for (Integer i = 1; i <= FIELDMAX; i++) {
                String lpadI = ('00' + i).right(3);
                String fromColumn = 'From_Column_' + lpadI + '__c';//假设执行此时 值是 From_Column_115__c
                String apiStr = String.valueOf(mpdMapping.get(fromColumn)); //取字段fromColumn上存储的数据为Rental_Cnt_USG400__c

                if (String.isBlank(apiStr) == false) {
                    String ssColumn = 'SS_Column_' + lpadI + '__c';//SS_Column_115__c
                    String ssApiStr = String.valueOf(mpdMapping.get(ssColumn));//取得是 字段SS_Column_115__c 上的存储的数据 USG-400
                    //Trigger.new[0].addError('=apiStr=='+apiStr+'==ssColumn =='+ssColumn+'==ssApiStr =='+ssApiStr );
                    //打印的值 Rental_Cnt_USG400__c==ssColumn ==SS_Column_115__c==ssApiStr ==USG-400

                    if (i < 101) { //opd对象
                        column.add(apiStr);
                        List<String> ssApiStrList = new List<String>(ssApiStr.Split(','));
                        tempImportantProduct.put(apiStr, ssApiStrList);
                    }
                    if (i >= 118 && i < 127) { //目标客户
                        columnSalesTar.add(apiStr);
                        List<String> ssApiStrList1 = new List<String>(ssApiStr.Split(','));
                        tempImportantSalesTar.put(apiStr, ssApiStrList1);

                    }
                    if (i >= 129 && i < 144) { //询价数 1，0
                        columnOppCnt.add(apiStr);
                        tempImportantOppCnt.put(apiStr, ssApiStr);

                    }
                    if (i >= 146 && i < 161) { //设备数 1，0
                        columnAsset.add(apiStr);
                        tempImportantAsset.put(apiStr, ssApiStr);

                    }

                    if (i >= 163 && i < 178) { //OPD数  本期/上期  累计数
                        columnOPDAmount.add(apiStr);
                        tempImportantOPDAmount.put(apiStr, ssApiStr);

                    }
                    if (i >= 101 && i < 116) { //出借次数  累计数
                        columnRental.add(apiStr);
                        tempImportantRental.put(apiStr, ssApiStr);

                    }

                }
            }

            // Trigger.new[0].addError('=columnAsset='+columnAsset+'--columnOppCnt--'+columnOppCnt+'--columnSalesTar--'+columnSalesTar+'--column--'+column);

            // Trigger.new[0].addError('=column=='+column+'==tempImportantProduct=='+tempImportantProduct );
            Map<id, Account_Number_of_target__c> acctarList = new Map<id, Account_Number_of_target__c>([select id, OPD_CV290__c, OPD_EUME2__c, OPD_290Miro__c, OPD_GFUCT260__c, OPD_OTVS300S400__c, OPD_CV170__c, OPD_190Main__c, OPD_ENG__c, OPD_TB__c,
                    Sales_target_CV290__c,
                    Sales_target_290Miro__c,
                    Sales_target_EUME2__c,
                    Sales_target_GFUCT260__c,
                    Sales_target_OTVS300S400__c,
                    Sales_target_CV170__c,
                    Sales_target_190Main__c,
                    Sales_target_ENG__c,
                    Sales_target_TB__c,
                    Opp_cnt_290MiroBF__c,
                    Opp_cnt_290MiroGI__c,
                    Opp_cnt_290MiroGI_CF__c,
                    Opp_cnt_290MiroGI_Plus__c,
                    Opp_cnt_CV170__c,
                    Opp_cnt_CV190__c,
                    Opp_cnt_CV290__c,
                    Opp_cnt_ESG400__c,
                    Opp_cnt_EUME2__c,
                    Opp_cnt_GFUCT260__c,
                    Opp_cnt_OTVS190__c,
                    Opp_cnt_OTVS300__c,
                    Opp_cnt_OTVS400__c,
                    Opp_cnt_TB__c,
                    Opp_cnt_USG400__c,
                    Opp_cnt_190Main__c,
                    Asset_Cnt_290MiroBF__c,
                    Asset_Cnt_290MiroGI__c,
                    Asset_Cnt_290MiroGI_CF__c,
                    Asset_Cnt_290MiroGI_Plus__c,
                    Asset_Cnt_CV170__c,
                    Asset_Cnt_CV190__c,
                    Asset_Cnt_CV290__c,
                    Asset_Cnt_ESG400__c,
                    Asset_Cnt_EUME2__c,
                    Asset_Cnt_GFUCT260__c,
                    Asset_Cnt_OTVS190__c,
                    Asset_Cnt_OTVS300__c,
                    Asset_Cnt_OTVS400__c,
                    Asset_Cnt_TB__c,
                    Asset_Cnt_USG400__c,
                    Asset_Cnt_190Main__c,
                    OPD_amount_290MiroBF__c,
                    OPD_amount_290MiroGI__c,
                    OPD_amount_290MiroGI_CF__c,
                    OPD_amount_290MiroGI_Plus__c,
                    OPD_amount_CV170__c,
                    OPD_amount_CV190__c,
                    OPD_amount_CV290__c,
                    OPD_amount_ESG400__c,
                    OPD_amount_EUME2__c,
                    OPD_amount_GFUCT260__c,
                    OPD_amount_OTVS190__c,
                    OPD_amount_OTVS300__c,
                    OPD_amount_OTVS400__c,
                    OPD_amount_TB__c,
                    OPD_amount_USG400__c,
                    OPD_amount_190Main__c,
                    Rental_Cnt_290MiroBF__c,
                    Rental_Cnt_290MiroGI__c,
                    Rental_Cnt_290MiroGI_CF__c,
                    Rental_Cnt_290MiroGI_Plus__c,
                    Rental_Cnt_CV170__c,
                    Rental_Cnt_CV190__c,
                    Rental_Cnt_CV290__c,
                    Rental_Cnt_ESG400__c,
                    Rental_Cnt_EUME2__c,
                    Rental_Cnt_GFUCT260__c,
                    Rental_Cnt_OTVS190__c,
                    Rental_Cnt_OTVS300__c,
                    Rental_Cnt_OTVS400__c,
                    Rental_Cnt_TB__c,
                    Rental_Cnt_USG400__c,
                    Rental_Cnt_190Main__c

                    from Account_Number_of_target__c
                    where id in :OpdTargetAcc.values()]);//查询目标客户 本财年的 
            system.debug('==本财年' + acctarList.size());
            Map<id, Account_Number_of_target__c> acctarlastList = new Map<id, Account_Number_of_target__c>([select id,
                    OPD_amount_290MiroBF__c,
                    OPD_amount_290MiroGI__c,
                    OPD_amount_290MiroGI_CF__c,
                    OPD_amount_290MiroGI_Plus__c,
                    OPD_amount_CV170__c,
                    OPD_amount_CV190__c,
                    OPD_amount_CV290__c,
                    OPD_amount_ESG400__c,
                    OPD_amount_EUME2__c,
                    OPD_amount_GFUCT260__c,
                    OPD_amount_OTVS190__c,
                    OPD_amount_OTVS300__c,
                    OPD_amount_OTVS400__c,
                    OPD_amount_TB__c,
                    OPD_amount_USG400__c,
                    OPD_amount_190Main__c
                    from Account_Number_of_target__c
                    where id = :OpdTargetLastAcc.values()]);//查询目标客户 上财年的
            system.debug('==上财年' + acctarlastList);
            for (OPDPlan__c t : newList) {
                if(Trigger.isUpdate){
                    Integer intes;
                    t.if_OPDTarget__c = intes;
                    t.if_HaveSalestarget__c = intes;
                    t.if_HaveOpportunity__c = intes;
                    t.if_HaveEquipment__c = intes;

                    t.Cnt_OPD_ThisYear__c = 0;
                    t.Cnt_OPD_LastYear__c = 0;
                    t.Cnt_Rentals__c = 0;
                }
               String opdct = OpdTargetAcc.get(t.id);
               String opdla = OpdTargetLastAcc.get(t.id);

                if (acctarList.containskey(opdct) || acctarlastList.containskey(opdla)) { // ||
                    if(t.PlanProdDetail__c!=null){
                        String ppd = t.PlanProdDetail__c;//不能去掉所有空格，因为有一个特殊得（OTV-S400 4K主机）.replaceAll(' ', ''); //GI-290镜子*3; GI-290镜子CF*1; OTV-S400 4K主机*3; OTV-S190*2; TB*8
                        String[] strs = ppd.split(';');//(GI-290镜子*3, GI-290镜子CF*1, OTV-S400 4K主机*3, OTV-S190*2, TB*8)
                        for (Integer i = 0; i < strs.size(); i++) { 
                           OpdPlanDetail.add(strs[i].split('\\*')[0].trim());//{ GI-290镜子CF, OTV-S190, OTV-S400 4K主机, TB, GI-290镜子}
                        }
                    }
                    
                    system.debug('上财年是否有符合条件得数据==' + acctarlastList.containskey(opdla));
                    //Trigger.new[0].addError('==tempImportantProduct=='+tempImportantProduct+'==OpdPlanDetail=='+OpdPlanDetail);
                    Decimal bqopdsum = 0;//计算 本期OPD次数
                    Decimal cntrensum = 0;//计算 出借次数
                    Decimal bqopdlastsum = 0;//计算 上期OPD次数
                    //20210701 SWAG-C4A4RJ you  为了不重复累计数据
                    Integer cv_190_In=0; //出街次数
                    Boolean cv_190_flag =false;//出借次数判断
                    Integer this_cv_190_In=0; //今年opd计划数
                    Boolean this_cv_190_flag =false;//今年opd计划数判断
                    Integer last_cv_190_In=0; //去年opd计划数
                    Boolean last_cv_190_flag =false;//去年opd计划数判断
                    OPDPlan__c opdplan = new OPDPlan__c();
                    for (String opd : OpdPlanDetail) {
                        opdplan.id = t.id;
                        if(acctarList !=null && acctarList.size() >0){
                        if (column != null) {
                            for (Integer i = 0; i < column.size(); i++) { //是否产品OPD目标客户
                                List<String>  titleAccout = tempImportantProduct.get(column[i]);
                                system.debug(titleAccout + '===opd===' + opd);
                                if (titleAccout.contains(opd)) {
                                    // system.debug(column[i] + '==anotList ==' + acctarList.get(opdct).get(column[i]) + '====' + acctarList.get(opdct).get(column[i]));
                                    //Trigger.new[0].addError(column[i]+'==anotList =='+acctarList.get(opdct).get(column[i]));
                                    if (acctarList.get(opdct).get(column[i]) != null && acctarList.get(opdct).get(column[i]) != 0) {

                                        
                                        if (Trigger.isInsert && t.OPDType__c=='学会') {
                                            opdplan.if_OPDTarget__c = 1;
                                            opdPlanList.add(opdplan);
                                        }else{
                                            t.if_OPDTarget__c = 1;
                                        }
                                        break;
                                    }
                                }
                            }
                        }
                        if (acctarList.containskey(opdct)) {
                            if (columnSalesTar != null) {
                                for (Integer i = 0; i < columnSalesTar.size(); i++) { //是否有营业目标客户
                                    List<String>  titleAccout1 = tempImportantSalesTar.get(columnSalesTar[i]);
                                    if (titleAccout1.contains(opd)) {
                                        system.debug(columnSalesTar[i] + '==是否有营业目标客户==' + acctarList.get(opdct).get(columnSalesTar[i]));
                                        if (acctarList.get(opdct).get(columnSalesTar[i]) != null && acctarList.get(opdct).get(columnSalesTar[i]) != 0) {
                                            
                                            if (Trigger.isInsert && t.OPDType__c=='学会') {
                                                opdplan.if_HaveSalestarget__c = 1;
                                                opdPlanList.add(opdplan);
                                             }else{
                                                t.if_HaveSalestarget__c = 1;
                                             }
                                            break;
                                        }
                                    }
                                }
                            }
                            if (columnOppCnt != null) {
                                for (Integer i = 0; i < columnOppCnt.size(); i++) { //是否有询价数
                                    String  titleAccout2 = tempImportantOppCnt.get(columnOppCnt[i]);
                                    if (opd.indexOf(titleAccout2) != -1) {
                                        if (acctarList.get(opdct).get(columnOppCnt[i]) != null && acctarList.get(opdct).get(columnOppCnt[i]) != 0) {
                                            
                                            if (Trigger.isInsert && t.OPDType__c=='学会') {
                                                opdplan.if_HaveOpportunity__c = 1;
                                                opdPlanList.add(opdplan);
                                             }else{
                                                t.if_HaveOpportunity__c = 1;
                                             }
                                            break;
                                        }
                                    }
                                }
                            }
                            if (columnAsset != null) {
                                for (Integer i = 0; i < columnAsset.size(); i++) { //是否已有设备
                                    String  titleAccout3 = tempImportantAsset.get(columnAsset[i]);
                                    if (opd.indexOf(titleAccout3) != -1) {
                                        system.debug('==opd==' + opd + '==titleAccout3==' + titleAccout3 + '==columnAsset[i]==' + columnAsset[i]);
                                        system.debug('==' + opdct + '==opd==' + acctarList.get(opdct).get(columnAsset[i]));
                                        if (acctarList.get(opdct).get(columnAsset[i]) != null && acctarList.get(opdct).get(columnAsset[i]) != 0) {
                                            
                                            if (Trigger.isInsert && t.OPDType__c=='学会') {
                                                opdplan.if_HaveEquipment__c = 1;
                                                opdPlanList.add(opdplan);
                                             }else{
                                                t.if_HaveEquipment__c = 1;
                                             }
                                            break;
                                        }
                                    }
                                }
                            }

                            if (columnRental != null) {//目标客户上得api字段
                                
                                for (Integer i = 0; i < columnRental.size(); i++) { //出借次数
                                    String  titleAccout4 = tempImportantRental.get(columnRental[i]); //取出来得是CV-190或者是OTV-S190
                                    if (opd == titleAccout4) {
                                        system.debug('出借次数' + opd + '==titleAccout4==' + titleAccout4 + '==columnRental[i]==' + columnRental[i]);
                                        if (acctarList.get(opdct).get(columnRental[i]) != null && acctarList.get(opdct).get(columnRental[i]) != 0) {
                                            Decimal aa = acctarList.get(opdct).get(columnRental[i]) == null ? 0 : Decimal.valueOf(String.valueOf(acctarList.get(opdct).get(columnRental[i])));
                                            system.debug('===出借次数' + aa);
                                            //20210701 SWAG-C4A4RJ you  为了不重复累计数据
                                            if(opd=='CV-190' || opd=='OTV-S190'){
                                               cv_190_In ++;
                                               cv_190_flag = true;
                                            }else{
                                                cv_190_flag = false;
                                            }
                                            system.debug('zheli=='+cv_190_In+'==false=='+cv_190_flag);
                                            if(cv_190_In < 2 || !cv_190_flag){
                                                cntrensum += aa;
                                            }

                                        }
                                    }
                                }
                                
                                if (Trigger.isInsert && t.OPDType__c=='学会') {
                                    opdplan.Cnt_Rentals__c = cntrensum;
                                    opdPlanList.add(opdplan);
                                }else{
                                    t.Cnt_Rentals__c = cntrensum;
                                }
                            }
                        }
                        }
                        if (columnOPDAmount != null) {

                            for (Integer i = 0; i < columnOPDAmount.size(); i++) { //本期OPD次数
                                String  titleAccout5 = tempImportantOPDAmount.get(columnOPDAmount[i]);
                                if (opd == titleAccout5) {
                                    if(acctarList !=null && acctarList.size()>0){
                                        if (acctarList.containskey(opdct) && acctarList.get(opdct).get(columnOPDAmount[i]) != null && acctarList.get(opdct).get(columnOPDAmount[i]) != 0) {
                                            system.debug('=columnOPDAmount[i]==' + columnOPDAmount[i] + '=本期OPD次数=' + acctarList.get(opdct).get(columnOPDAmount[i]));
                                            Decimal aa = acctarList.get(opdct).get(columnOPDAmount[i]) == null ? 0 : Decimal.valueOf(String.valueOf(acctarList.get(opdct).get(columnOPDAmount[i])));
                                            system.debug('===aa' + aa); 
                                             //20210701 SWAG-C4A4RJ you  为了不重复累计数据
                                            if(opd=='CV-190' || opd=='OTV-S190'){
                                               this_cv_190_In ++;
                                               this_cv_190_flag = true;
                                            }else{
                                                this_cv_190_flag = false;
                                            }
                                            if(this_cv_190_In < 2 || !this_cv_190_flag){
                                                bqopdsum += aa;
                                            }
                                        }
                                    }
                                    if(acctarlastList !=null && acctarlastList.size()>0){
                                        if (acctarlastList.containskey(opdla) && acctarlastList.get(opdla).get(columnOPDAmount[i]) != null && acctarlastList.get(opdla).get(columnOPDAmount[i]) != 0) {
                                            system.debug('=columnOPDAmount[i]==' + columnOPDAmount[i] + '=上期OPD次数=' + acctarlastList.get(opdla).get(columnOPDAmount[i]));
                                            Decimal bb = acctarlastList.get(opdla).get(columnOPDAmount[i]) == null ? 0 : Decimal.valueOf(String.valueOf(acctarlastList.get(opdla).get(columnOPDAmount[i])));
                                            system.debug('===bb' + bb);
                                            
                                             //20210701 SWAG-C4A4RJ you  为了不重复累计数据
                                            if(opd=='CV-190' || opd=='OTV-S190'){
                                               last_cv_190_In ++;
                                               last_cv_190_flag = true;
                                            }else{
                                                last_cv_190_flag = false;
                                            }
                                            if(last_cv_190_In < 2 || !last_cv_190_flag){
                                                bqopdlastsum += bb;
                                            }
                                        }
                                    }


                                }
                            }
                            
                            if (Trigger.isInsert && t.OPDType__c=='学会') {
                                    opdplan.Cnt_OPD_ThisYear__c = bqopdsum;
                                    opdplan.Cnt_OPD_LastYear__c = bqopdlastsum;
                                    opdPlanList.add(opdplan);
                                }else{
                                    t.Cnt_OPD_ThisYear__c = bqopdsum;
                                    t.Cnt_OPD_LastYear__c = bqopdlastsum;
                                }
                        } //

                    }



                }
            }

        system.debug('=来源直接是学会得=opdPlanList==' + opdPlanList);
        opplansmap.putall(opdPlanList);
        if (Trigger.isInsert && opplansmap.size() > 0) {
            update opplansmap.values();
        }

    }
    //更新 模型出借产品  精琢技术 wql 2021/04/13 start
    private void updateModelLending(List<OPDPlan__c> oplanList){

        Map<Id,Id> ModelLendMap = new Map<Id,Id> ();
        //查询 模型出借配套表 获取模型出借产品
        List<ModelLendingProduct__c>  ModelLendList= [select id,Name,Product__c,productName__c,ModelAndProductName__c from ModelLendingProduct__c ];
        //将所有的数据都检索处理 目前<100条  未来再考虑传参缩小数据范围
        if(ModelLendList.size()>0){
            for(ModelLendingProduct__c ml :ModelLendList){
                ModelLendMap.put(ml.id,ml.Product__c);
            }
            
        }
        //①新增 ②更新 同步赋值即可
        if(oplanList.size() >0){
            for(OPDPlan__c opd :oplanList){
                    if(opd.ModelLending__c == null){
                        opd.ModelLendingProduct__c = null;
                    }else{
                        opd.ModelLendingProduct__c = ModelLendMap.get(opd.ModelLending__c);
                    }
            }
        }
        


    }

}