public with sharing class SetProductTargetController {
    // 当前期
    public String currentPeriod { get; private set; }
    public String currentPeriodOld;//20210225 WLIG-BV8CHF ljh add 财年
    // 上年度按钮制御
    public boolean previousRendered { get; private set; }
    // 下年度按钮制御
    public boolean nextRendered { get; private set; }
    // 数据集
    public List<DataBean> dataBeans { get; set; }
    // 金额分类
    public List<String> opportunity_category { get; private set; }
    // 是否是过去年度
    public Boolean isPast { get; private set; }
    // 年度変化時セーブかどうか
    public Boolean saveFlg { get; set; }
    // 本部の選択値
    public String salesDpt { get; set; }
    // 目标区分
    public String target_category { get; set; }
    // 製品プルダウン用
    public Opportunity opp { get; set; }
    public Integer titleSize { get; set; } 
        
    public SetProductTargetController() {
           //Apexpages.currentPage().getHeaders().put('X-UA-Compatible', 'IE=8');
    }

    
    
    // 本部プルダウン
    public static List<SelectOption> salesDptOpts { get; private set; }
    static {
        salesDptOpts = new List<SelectOption>();
        salesDptOpts.add(new SelectOption('0.无','--无--'));
        salesDptOpts.add(new SelectOption('1.华北','1.华北'));
        salesDptOpts.add(new SelectOption('2.东北','2.东北'));
        salesDptOpts.add(new SelectOption('3.西北','3.西北'));
        salesDptOpts.add(new SelectOption('4.西南','4.西南'));
        salesDptOpts.add(new SelectOption('5.华东','5.华东'));
        salesDptOpts.add(new SelectOption('6.华南','6.华南'));
        //CHAN-BDQBLX  20210204 ljh update start
        /*salesDptOpts.add(new SelectOption('7.能量-1.华北','7.能量-1.华北'));
        salesDptOpts.add(new SelectOption('7.能量-2.东北','7.能量-2.东北'));
        salesDptOpts.add(new SelectOption('7.能量-3.西北','7.能量-3.西北'));
        salesDptOpts.add(new SelectOption('7.能量-4.西南','7.能量-4.西南'));
        salesDptOpts.add(new SelectOption('7.能量-5.华东','7.能量-5.华东'));
        salesDptOpts.add(new SelectOption('7.能量-6.华南','7.能量-6.华南'));*/
        //CHAN-BDQBLX  20210204 ljh update end
    }
    // 重点目标分类
    public static List<SelectOption> targetOpts { get; private set; }
    static {
        targetOpts = new List<SelectOption>();
        targetOpts.add(new SelectOption('重点产品目标(数量)','重点产品目标(数量)'));
        targetOpts.add(new SelectOption('重点产品目标(金额)','重点产品目标(金额)'));
    }
    
    //  现在年度
    private Integer currentYear;
    //  当前年度
    private Integer iYear;

    public User loginUser { get; set; }          // 登陆用户
    private RecordType rt;           // 目标的数据类型
    private Map<String, List<Double>> proportion;    // 比重
    
    private List<String> provinces;
    private Map<String,List<String>> salesDptMap;  //本部-省对应关系
    private Map<String,String> provinceMap;        //省-本部对应关系

    private boolean isEng;
    
    //更新用条件
    //private String old_target_category;
    //private String old_important_Key_product_category;
    
    // 既存目标数据
    private Map<String, Opportunity> oppsMap;
    private Map<String, AggregateResult> oliMap;
    //2020/07/08 中间表寄存数据 by ld
    private Map<String,Key_Product_Goals__c> Key_Product_GoalsMap;
    public Key_Product_Goals__c[] Existed_Key_Product_Goals;
    // 金额分类 xiongyl
   // private static String[] amountCategory = new String[] {'GI','ET','BF','GS','URO','GYN','ENT','OTH'};
    public static List<String> amountCategory { get; private set; }
    public static List<ImportantProductCategory__c> pcList { get; private set; }
    public static Map<String, boolean> isCntMap = new Map<String, boolean>();
    public static Map<String,String> NkeyMap= new Map<String,String>();//20210204 CHAN-BDQBLX  ljh add
    static {
        amountCategory = new List<String>();
        pcList = [select depName__c,importantProductGoaIName__c,commodityCode__c,commodityName__c,if_Quantity__c,sort__c from ImportantProductCategory__c order by sort__c];
        for (ImportantProductCategory__c pc : pcList) {
            isCntMap.put(pc.importantProductGoaIName__c + '_' + pc.depName__c, pc.if_Quantity__c);
            if (pc.depName__c != null) {
                amountCategory.add(pc.commodityName__c + '(' + pc.depName__c + ')' + (pc.if_Quantity__c ? '' : '金额'));
                NkeyMap.put(pc.commodityName__c + '(' + pc.depName__c + ')' + (pc.if_Quantity__c ? '' : '金额'),pc.importantProductGoaIName__c + '_' + pc.depName__c);//CHAN-BDQBLX  20210204 ljh add
            }else {
                amountCategory.add(pc.commodityName__c + (pc.if_Quantity__c ? '' : '金额'));
                NkeyMap.put(pc.commodityName__c + (pc.if_Quantity__c ? '' : '金额'),pc.importantProductGoaIName__c + '_' + pc.depName__c);//CHAN-BDQBLX  20210204 ljh add
            }
        }
    }
    
    // 重点製品API名マップ
    public static Map<String, String> impProductApiMap = new Map<String, String> {
        '重点产品01' => 'Important_product1__c',
        '重点产品02' => 'Important_product2__c',
        '重点产品03' => 'Important_product3__c',
        '重点产品04' => 'Important_product4__c',
        '重点产品05' => 'Important_product5__c',
        '重点产品06' => 'Important_product6__c',
        '重点产品07' => 'Important_product7__c',
        '重点产品08' => 'Important_product8__c',
        '重点产品09' => 'Important_product9__c',
        '重点产品10' => 'Important_product10__c',
        '重点产品11' => 'Important_product11__c',
        '重点产品12' => 'Important_product12__c',
        '重点产品13' => 'Important_product13__c',
        '重点产品14' => 'Important_product14__c',
        '重点产品15' => 'Important_product15__c',
        '重点产品16' => 'Important_product16__c',
        '重点产品17' => 'Important_product17__c',
        '重点产品18' => 'Important_product18__c',
        '重点产品19' => 'Important_product19__c',
        '重点产品20' => 'Important_product20__c',
        '重点产品21' => 'Important_product21__c',
        '重点产品22' => 'Important_product22__c',
        '重点产品23' => 'Important_product23__c',
        '重点产品24' => 'Important_product24__c',
        '重点产品25' => 'Important_product25__c',
        '重点产品26' => 'Important_product26__c',
        '重点产品27' => 'Important_product27__c',
        '重点产品28' => 'Important_product28__c',
        '重点产品29' => 'Important_product29__c',
        '重点产品30' => 'Important_product30__c',
        '重点产品31' => 'Important_product31__c'
    };
    public static List<SelectOption> impProductOptions { get; private set; }
    static {
        impProductOptions = new List<SelectOption>();
        impProductOptions.add(new SelectOption('重点产品01', Product2.Important_product1__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品02', Product2.Important_product2__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品03', Product2.Important_product3__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品04', Product2.Important_product4__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品05', Product2.Important_product5__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品06', Product2.Important_product6__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品07', Product2.Important_product7__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品08', Product2.Important_product8__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品09', Product2.Important_product9__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品10', Product2.Important_product10__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品11', Product2.Important_product11__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品12', Product2.Important_product12__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品13', Product2.Important_product13__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品14', Product2.Important_product14__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品15', Product2.Important_product15__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品16', Product2.Important_product16__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品17', Product2.Important_product17__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品18', Product2.Important_product18__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品19', Product2.Important_product19__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品20', Product2.Important_product20__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品21', Product2.Important_product21__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品22', Product2.Important_product22__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品23', Product2.Important_product23__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品24', Product2.Important_product24__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品25', Product2.Important_product25__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品26', Product2.Important_product26__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品27', Product2.Important_product27__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品28', Product2.Important_product28__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品29', Product2.Important_product29__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品30', Product2.Important_product30__c.getDescribe().getlabel()));
        impProductOptions.add(new SelectOption('重点产品31', Product2.Important_product31__c.getDescribe().getlabel()));
    }
    //CHAN-BDQBLX  20210204 ljh start
    private List<Key_Product_Goals__c> upsertKPGList;
    private Map<String, Key_Product_Goals__c> Key_Product_GoalsMap1;
    public string csvAsString {get; set;}
    public String[] csvFileLines {get; set;}
    private static List<String> titlepage = new List<String>{'销售本部', '省', '担当'};
    public Integer detailCountLimit{get;private set;}
    //CHAN-BDQBLX  20210204 ljh end
    // 画面初始化
    public Pagereference init() {
        // 现在时间
        Date dateNow = Date.today();
        Integer year = dateNow.year();
        Integer month = dateNow.month();
        //CHAN-BDQBLX  20210204 LJH start
        Key_Product_GoalsMap1 = new Map<String, Key_Product_Goals__c>();
        upsertKPGList = new List<Key_Product_Goals__c>();
        detailCountLimit = 10000;
        //CHAN-BDQBLX  20210204 LJH end
        if (month < 4) {
            year -= 1;
        }
        // 初始化
        opp = new Opportunity();
        // xiongyl 修改后初始化的时候取得的是22种产品对应的数据
        //opp.Important_Key_product_category__c = '重点产品01';
        
        currentYear = year;
        iYear = year;
        isPast = false;
        // 20200304 开放管理员权限 Start
        //if (month == 3) isPast = true;
        if (month == 3 && UserInfo.getProfileId() != System.Label.ProfileId_SystemAdmin) isPast = true;
        // 20200304 开放管理员权限 End
        //20210225 ljh WLIG-BV8CHF update  财年 start
        //currentPeriod = String.valueOf(iYear - 1867 + 'P');
        currentPeriodOld = String.valueOf(iYear - 1867 + 'P');
        Integer tempiYear = iYear+1;
        currentPeriod = String.valueOf('FY'+tempiYear);
        //20210225 ljh WLIG-BV8CHF update  财年 end
        previousRendered = true;
        nextRendered = true;
        saveFlg = false;
        target_category = '省重点产品目标';
        titleSize = pcList.size();
        
        //old_target_category = target_category;
        //old_important_Key_product_category = opp.Important_Key_product_category__c;
        
        // 金额分类
        opportunity_category = amountCategory;
        // 每月比重
        if (proportion == null) {
            proportion = new Map<String, List<Double>>();
            String strObjectiveProportionGI = System.Label.ObjectiveProportionGI;
            List<String> objectiveProportionGI = strObjectiveProportionGI.split(',');
            List<Double> doubleGI = new List<Double>();
            for (String strGI : objectiveProportionGI) {
                doubleGI.add(Double.valueOf(strGI));
            }
            proportion.put('GI', doubleGI);

            String strObjectiveProportionET = System.Label.ObjectiveProportionET;
            List<String> objectiveProportionET = strObjectiveProportionET.split(',');
            List<Double> doubleET = new List<Double>();
            for (String strET : objectiveProportionET) {
                doubleET.add(Double.valueOf(strET));
            }
            proportion.put('ET', doubleET);

            String strObjectiveProportionBF = System.Label.ObjectiveProportionBF;
            List<String> objectiveProportionBF = strObjectiveProportionBF.split(',');
            List<Double> doubleBF = new List<Double>();
            for (String strBF : objectiveProportionBF) {
                doubleBF.add(Double.valueOf(strBF));
            }
            proportion.put('BF', doubleBF);

            String strObjectiveProportionGS = System.Label.ObjectiveProportionGS;
            List<String> objectiveProportionGS = strObjectiveProportionGS.split(',');
            List<Double> doubleGS = new List<Double>();
            for (String strGS : objectiveProportionGS) {
                doubleGS.add(Double.valueOf(strGS));
            }
            proportion.put('GS', doubleGS);

            String strObjectiveProportionURO = System.Label.ObjectiveProportionURO;
            List<String> objectiveProportionURO = strObjectiveProportionURO.split(',');
            List<Double> doubleURO = new List<Double>();
            for (String strURO : objectiveProportionURO) {
                doubleURO.add(Double.valueOf(strURO));
            }
            proportion.put('URO', doubleURO);

            String strObjectiveProportionGYN = System.Label.ObjectiveProportionGYN;
            List<String> objectiveProportionGYN = strObjectiveProportionGYN.split(',');
            List<Double> doubleGYN = new List<Double>();
            for (String strGYN : objectiveProportionGYN) {
                doubleGYN.add(Double.valueOf(strGYN));
            }
            proportion.put('GYN', doubleGYN);

            String strObjectiveProportionENT = System.Label.ObjectiveProportionENT;
            List<String> objectiveProportionENT = strObjectiveProportionENT.split(',');
            List<Double> doubleENT = new List<Double>();
            for (String strENT : objectiveProportionENT) {
                doubleENT.add(Double.valueOf(strENT));
            }
            proportion.put('ENT', doubleENT);

            String strObjectiveProportionOTH = System.Label.ObjectiveProportionOTH;
            List<String> objectiveProportionOTH = strObjectiveProportionOTH.split(',');
            List<Double> doubleOTH = new List<Double>();
            for (String strOTH : objectiveProportionOTH) {
                doubleOTH.add(Double.valueOf(strOTH));
            }
            proportion.put('OTH', doubleOTH);

            String strObjectiveProportionENG = System.Label.ObjectiveProportionENG;
            List<String> objectiveProportionENG = strObjectiveProportionENG.split(',');
            List<Double> doubleENG = new List<Double>();
            for (String strENG : objectiveProportionENG) {
                doubleENG.add(Double.valueOf(strENG));
            }
            proportion.put('ENG', doubleENG);
        }
        // 当前用户信息
        if (loginUser == null) {
            loginUser = [Select Id, Salesdepartment__c, ProfileId From User where Id = :Userinfo.getUserId()];
        }
        
        getsalesDptMap();
        //salesDpt = '0.无';
        salesDpt = '1.华北';
        provinces = new List<String>();
        provinces = salesDptMap.get(salesDpt);

        isEng = false;
        
        // 目标的数据类型
        if (rt == null) {
            rt = [select Id from RecordType where SobjectType = 'Opportunity' and IsActive = true and DeveloperName = 'Target'];
        }
        // 数据赋值
        setBean(iYear);

        return null;
    }
    
    //SWAG-BB48QB 判断当前时间是否是4月15日之后 start
    private boolean checkCurrentDate(){
        boolean dateResult = true;
        Date today = Date.today();
        Date date415 = Date.newInstance(today.year(), 4, 
            Integer.valueOf(System.Label.SetPersonalTarget_buffer_day));

        if(iYear >= currentYear -1 && today <= date415 )
            dateResult = false;
        return dateResult;
    }
    //SWAG-BB48QB 判断当前时间是否是4月15日之后 end
    
    // 点击上年度
    public void previous() {
        if (saveFlg) {
            this.saveLogic();
        }
        
        iYear -= 1;
        //20210225 ljh WLIG-BV8CHF update  财年 start
        //currentPeriod = String.valueOf(iYear - 1867 + 'P');
        currentPeriodOld = String.valueOf(iYear - 1867 + 'P');
        Integer tempiYear = iYear+1;
        currentPeriod = String.valueOf('FY'+tempiYear);
        //20210225 ljh WLIG-BV8CHF update  财年 end
        // 是否是过去数据
        isPast = false;
         //SWAG-BB48QB 判断当前时间是否是4月15日之后 start
        if (iYear < currentYear && checkCurrentDate()) {
            isPast = true;
        }

        // else if (iYear == currentYear) {
        //    if (Date.today().month() == 3) {
        //        isPast = true;
        //    }
        //}
         //SWAG-BB48QB 判断当前时间是否是4月15日之后 end
        previousRendered = true;
        nextRendered = true;
        // 数据赋值
        setBean(iYear);
    }
    
    // 点击下年度
    public void next() {
        if (saveFlg) {
            this.saveLogic();
        }
        
        iYear += 1;
        //20210225 ljh WLIG-BV8CHF update  财年 start
        //currentPeriod = String.valueOf(iYear - 1867 + 'P');
        currentPeriodOld = String.valueOf(iYear - 1867 + 'P');
        Integer tempiYear = iYear+1;
        currentPeriod = String.valueOf('FY'+tempiYear);
        //20210225 ljh WLIG-BV8CHF update  财年 end
        // 是否是过去数据
        isPast = false;
         //SWAG-BB48QB 判断当前时间是否是4月15日之后 start
        if (iYear < currentYear && checkCurrentDate()) {
            isPast = true;
        }  
        //else if (iYear == currentYear) {
        //    if (Date.today().month() == 3) {
        //        isPast = true;
        //    }
        //}
         //SWAG-BB48QB 判断当前时间是否是4月15日之后 end
        previousRendered = true;
        nextRendered = true;
        // 只显示到现在时间的下一年数据
        if (iYear > currentYear) {
            nextRendered = false;
        }
        // 数据赋值
        setBean(iYear);
    }
    
    // 本部プルダウン変更時の処理
    public void searchByDpt() {
        if (saveFlg) {
            this.saveLogic();
        }
        //CHAN-BDQBLX  20210220 ljh update start
        /*Map<String, String> engMap = new Map<String, String>();
        engMap.put('7.能量-1.华北','7.能量-1.华北');
        engMap.put('7.能量-2.东北','7.能量-2.东北');
        engMap.put('7.能量-3.西北','7.能量-3.西北');
        engMap.put('7.能量-4.西南','7.能量-4.西南');
        engMap.put('7.能量-5.华东','7.能量-5.华东');
        engMap.put('7.能量-6.华南','7.能量-6.华南');
        if (engMap.containsKey(salesDpt)) {
            isEng = true;
        } else {
            isEng = false;
        }*/
        //CHAN-BDQBLX  20210220 ljh update end
        provinces = new List<String>();
        provinces = salesDptMap.get(salesDpt);
        opp.SAP_Province__c = null;
        //CHAN-BDQBLX  20210207 ljh update start
        //if (salesDpt != '0.无') {
            // 数据赋值
            setBean(iYear);
        //}
        //CHAN-BDQBLX  20210207 ljh update end
    }
    
    // 省プルダウン変更時の処理
    public void searchByProvince() {
        if (saveFlg) {
            this.saveLogic();
        }

        provinces = new List<String>();
        salesDpt = '0.无';
        if (opp.SAP_Province__c == null) {
            provinces = salesDptMap.get(salesDpt);
        } else {
            provinces.add(opp.SAP_Province__c);
        }

        isEng = false;

        // 数据赋值
        setBean(iYear);
    }
    
    // 重点目標分類変更時の処理
    public void searchByCategory() {
        if (saveFlg) {
            this.saveLogic();
        }
        //old_target_category = target_category;
        // 数据赋值
        setBean(iYear);
    }
    
    // 重点製品変更時の処理
    public void searchByImpKey() {
        if (saveFlg) {
            this.saveLogic();
        }
        //old_important_Key_product_category = opp.Important_Key_product_category__c;
        // 数据赋值
        setBean(iYear);
    }
    //CHAN-BDQBLX  20210204 ljh start 导入出方法 start
    //导出方法
    public Pagereference exportBycsv() {
        setBean(iYear);
        return page.SetProductTargetcvs;                 
    }
    //导入方法
    public PageReference importCSVFile() {
        try {
            String csvData = ApexPages.currentPage().getParameters().get('csvData');
            // 将内容转换成为中文
            if(!Test.isRunningTest()){
                //csvAsString = bitToString(csvFileBody, 'gb2312');
                csvAsString = csvData;
            }            
            // 拆成每一行
            csvFileLines = csvAsString.split('\n');
            Boolean ValFlag = false;
            String exportByVal = '';
            ApexPages.Message successMsg = new ApexPages.Message(ApexPages.severity.INFO, '');
            // 需要根据情况来解析,查看表头是否一致
            if(opportunity_category !=null && opportunity_category.size()>0){
                titlepage.addAll(opportunity_category);
            }
            String target_Source1 = 'SalesTarget';
            String salesDpt1;
            if (csvFileLines.size() > 0) {
                string[] titlecsv = csvFileLines[0].trim().split(',');
                System.debug('==titlepage=='+titlepage);
                System.debug('==titlecsv=='+titlecsv);
                if(titlecsv[0].split(':').size()>=2){
                    if (titlecsv[0].split(':')[1].contains('能量')) {
                        target_Source1 = 'EngTarget';
                    }
                    /**
                    salesDpt = titlecsv[0].split(':')[1];
                    if(titlecsv[0].split(':').size()==3){
                        opp.SAP_Province__c = titlecsv[0].split(':')[2];
                    }else{
                        opp.SAP_Province__c = null;
                    }
                    **/
                    titlecsv[0] = titlecsv[0].split(':')[0];                    
                }                
                for (integer j = 0; j < titlecsv.size(); j++) {
                    if (!titlepage.contains(titlecsv[j])) {
                        system.debug('表头不一致得列===' + titlecsv[j]);
                        ValFlag = true;
                        exportByVal = '表头不一致，请严格按照导出模板填写';
                        break;
                    }
                }
            }
            if (ValFlag) {
                successMsg = new ApexPages.Message(ApexPages.severity.INFO, exportByVal);
                ApexPages.addMessage(successMsg);
            } else {
                List<String> UserInfoList = new List<String>();
                Map<String, List<String>> szMap = new Map<String, List<String>>();
                Set<String> sfs = new Set<String>();//省份
                for (Integer i = 1; i < csvFileLines.size(); i++) {
                    string[] csvRecordData = csvFileLines[i].split(',');
                    if (csvRecordData.size() > 0) {
                        String bu = csvRecordData[0].replace(' ', '');
                        String sf = csvRecordData[1].replace(' ', '');
                        String dandang = csvRecordData[2].replace(' ', '');
                        if(String.isNotBlank(dandang)){
                            UserInfoList.add(dandang);//根据 担当查user     
                        }
                        szMap.put(bu+'_'+ sf + '_'+dandang, csvRecordData);
                        sfs.add(sf);//把省份放进去 
                    }
                }
                if (null != sfs && sfs.size() > 0) {
                    this.getKey_Product_Goals(sfs);//根据省份年份，获取当前系统中已经存在得数据 放到map中 
                }
                List<User> userList  = new List<User>();
                if (null != UserInfoList && UserInfoList.size() > 0) {
                    userList = this.getUserList(UserInfoList);//返回用户得一些信息
                }
                Map<String, User> userMap = new Map<String, User>();
                for (User userl : userList) {
                    userMap.put(userl.Alias, userl);
                }                
                upsertKPGList = new List<Key_Product_Goals__c>();//初始化，解决重复导入数据 id重复得问题
                for (String key : szMap.keySet()) {
                    //取用户的Id
                    String userid = '';
                    String key_shengfen=key.split('_')[1];//省份
                    String key_dandang= '';
                    if(key.split('_').size()>=3){
                         key_dandang=key.split('_')[2];//把担当取出来
                    }
                    if (userMap.containskey(key_dandang)) {
                        userid = userMap.get(key_dandang).Id;
                    } else {
                        System.debug('==key==='+key);
                        //用户不存在要提醒
                        continue;
                    }
                    System.debug('==userid:'+userid);
                    //String key = dataBean.Opportunity.SAP_Province__c + '_' + target_category + '_' +
                                // pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + target_Source;
                   //--------
                    List<String> csvRecordData = szMap.get(key);
                    Key_Product_Goals__c upsertKPG = new Key_Product_Goals__c();
                    Integer tI = amountCategory.size()+3;//数字3取决于导入的cvs重点产品前的个数
                    System.debug('amountCategory.size():'+amountCategory.size());
                    for(Integer i = 3;i<tI;i++){
                        Integer  Num_Of_OPD;
                        if(String.isNotBlank(csvRecordData[i])){
                            if(i==(tI-1)){
                                Num_Of_OPD = Integer.valueOf(csvRecordData[i].trim());
                            }else{
                                Num_Of_OPD = Integer.valueOf(csvRecordData[i]);
                            }
                        }

                        String nkey = csvRecordData[1] + '_' + target_category + '_' +NkeyMap.get(amountCategory[i-3])+'_'+target_Source1;
                        DataSplicing(Num_Of_OPD,nkey,target_Source1,csvRecordData,Key_Product_GoalsMap1,userid);
                    }
                }
                if(null!=upsertKPGList && upsertKPGList.size()>0){
                    upsert upsertKPGList;
                }
                /**
                provinces = new List<String>();
                if (salesDpt != null && opp.SAP_Province__c != null && salesDpt == '0.无' && opp.SAP_Province__c != '0.无') {
                    provinces.add(opp.SAP_Province__c);
                } else {
                    provinces = salesDptMap.get(salesDpt);
                }
                **/
                // 数据赋值
                setBean(iYear);
                successMsg = new ApexPages.Message(ApexPages.severity.INFO, '导入成功');
                ApexPages.addMessage(successMsg);
            }
        } catch (Exception e) {
             ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR, e.getMessage());
             ApexPages.addMessage(errorMessage);
        }
        return null;
    }
    // 最终得数据处理，
    private void DataSplicing(Integer NumOfOPD, String key,String target_Source,List<String> csvRecordData, Map<String, Key_Product_Goals__c> nmpMap,String userId) {//去进行最终数据得插入，更新或删除操作
        Key_Product_Goals__c upsertKPG = new Key_Product_Goals__c();
        Key_Product_Goals__c Key_Product_Goals = Key_Product_GoalsMap.get(key);  
        if (nmpMap.containskey(key)) {
            upsertKPG = nmpMap.get(key);
            if (NumOfOPD > 0) {
                if(NumOfOPD != upsertKPG.Num_Of_OPD__c){
                    upsertKPG.Num_Of_OPD__c = NumOfOPD;
                    upsertKPG.Owner_System__c = userId;
                    upsertKPG.Is_Processing__c = true;
                    upsertKPGList.add(upsertKPG);
                    //更新
                }
                
            } else {
                //不用删除了，允许 数据是空的存在
                upsertKPG.Num_Of_OPD__c = null;
                upsertKPG.Is_Processing__c = true;
                upsertKPG.Owner_System__c = userId;
                upsertKPGList.add(upsertKPG);
            }
        } else {
            if (NumOfOPD > 0) {
                upsertKPG.Num_Of_OPD__c = NumOfOPD;
                upsertKPG.key__c = key;
                upsertKPG.Owner_System__c = userId;
                upsertKPG.SAP_Province__c = csvRecordData[1];
                upsertKPG.Department__c = csvRecordData[0];
                upsertKPG.iYear__c = iYear;
                upsertKPG.Is_Processing__c = true;
                upsertKPG.Target_Source__c = target_Source;
                upsertKPGList.add(upsertKPG);
            } else {
                //允许 数据是空的存在
                upsertKPG.Num_Of_OPD__c = null;
                upsertKPG.key__c = key;
                upsertKPG.Owner_System__c = userId;
                upsertKPG.SAP_Province__c = csvRecordData[1];
                upsertKPG.Department__c = csvRecordData[0];
                upsertKPG.iYear__c = iYear;
                upsertKPG.Is_Processing__c = true;
                upsertKPG.Target_Source__c = target_Source;
                upsertKPGList.add(upsertKPG);
            }
        }
    }
    private void getKey_Product_Goals(Set<String> sfs) {//根据省份年份，获取当前系统中已经存在得数据
        Key_Product_GoalsMap1 = new Map<String, Key_Product_Goals__c>();

        list<Key_Product_Goals__c> Existed_Key_Product_Goals = [select key__c, Num_Of_OPD__c, Owner_System__c,
                                      Is_Processing__c, iYear__c from Key_Product_Goals__c where iYear__c = : iYear and SAP_Province__c in :sfs];
        for (Key_Product_Goals__c Key_Product_Goals : Existed_Key_Product_Goals ) {
            if (String.isBlank(Key_Product_Goals.key__c)) {
                continue;
            }
            Key_Product_GoalsMap1.put(Key_Product_Goals.key__c, Key_Product_Goals);
        }
    }
    private List<User> getUserList(List<String> UserInfoList) {
        String soql = 'select Id,Alias from User where IsActive = true'
                      + ' and (Alias IN :UserInfoList'+' OR Id IN :UserInfoList '
                      +') order by Salesdepartment__c, Province__c';
        System.debug('==soql==' + soql);
        return Database.query(soql);
    }
    //CHAN-BDQBLX  20210204 ljh start 导入出方法 end
    // 点击保存按钮
    public Pagereference saveBtn() {
        boolean rs = saveLogic();
        setBean(iYear);
        if (rs) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.INFO, '保存成功'));
        }
        return null;
    }
    
    // 点击返回按钮
    public Pagereference backBtn() {
        // HOMEに戻る
        PageReference ref = new Pagereference('/home/home.jsp');
        ref.setRedirect(true);
        return ref;
    }

    // 2020/07/08 从中间表获取既有数据
    private boolean getKey_Product_Goalsmap() {
        Key_Product_GoalsMap = new Map<String,Key_Product_Goals__c>();
        Existed_Key_Product_Goals = [select id, key__c,Num_Of_OPD__c,Department__c,SAP_Province__c,Owner_System__c,iYear__c
                                                                FROM Key_Product_Goals__c where iYear__c = : iYear ];
        
        if (Existed_Key_Product_Goals.size() <= 0) {
            return false;
        }

        // 将所数据存入map中
        for ( Key_Product_Goals__c Key_Product_Goal : Existed_Key_Product_Goals ){
            if (String.isBlank(Key_Product_Goal.key__c)) {
                continue;
            }
            Key_Product_GoalsMap.put(Key_Product_Goal.key__c,Key_Product_Goal);
        }

        return true;
    }
    
    //获取本部-省对应关系
    private void getsalesDptMap() {
        salesDptMap = new Map<String,List<String>>();
        
        List<String> provinceList = new List<String>();
        provinceList.add('北京市');
        provinceList.add('天津市');
        provinceList.add('河南省');
        provinceList.add('河北省');
        provinceList.add('山西省');
        provinceList.add('内蒙古');
        provinceList.add('山东省');
        provinceList.add('陕西省');
        provinceList.add('青海省');
        provinceList.add('宁夏自治区');
        provinceList.add('甘肃省');
        provinceList.add('新疆自治区');
        provinceList.add('辽宁省');
        provinceList.add('黑龙江省');
        provinceList.add('吉林省');
        provinceList.add('上海市');
        provinceList.add('江苏省');
        provinceList.add('浙江省');
        provinceList.add('福建省');
        provinceList.add('安徽省');
        provinceList.add('江西省');
        provinceList.add('广东省');
        provinceList.add('广西自治区');
        provinceList.add('海南省');
        provinceList.add('四川省');
        provinceList.add('重庆市');
        provinceList.add('云南省');
        provinceList.add('贵州省');
        provinceList.add('西藏自治区');
        provinceList.add('湖北省');
        provinceList.add('湖南省');
        provinceList.add('深圳市');
        provinceList.add('大连市');
        provinceList.add('青岛市');
        salesDptMap.put('0.无',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('北京市');
        provinceList.add('天津市');
        provinceList.add('河北省');
        provinceList.add('内蒙古');
        provinceList.add('山东省');
        provinceList.add('青岛市');
        salesDptMap.put('1.华北',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('辽宁省');
        provinceList.add('黑龙江省');
        provinceList.add('吉林省');
        provinceList.add('大连市');
        salesDptMap.put('2.东北',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('河南省');
        provinceList.add('山西省');
        provinceList.add('陕西省');
        provinceList.add('青海省');
        provinceList.add('宁夏自治区');
        provinceList.add('甘肃省');
        provinceList.add('新疆自治区');
        salesDptMap.put('3.西北',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('上海市');
        provinceList.add('江苏省');
        provinceList.add('浙江省');
        provinceList.add('福建省');
        provinceList.add('安徽省');
        provinceList.add('江西省');
        salesDptMap.put('5.华东',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('广东省');
        provinceList.add('广西自治区');
        provinceList.add('海南省');
        provinceList.add('湖北省');
        provinceList.add('湖南省');
        provinceList.add('深圳市');
        salesDptMap.put('6.华南',provinceList);
        
        provinceList = new List<String>();
        provinceList.add('四川省');
        provinceList.add('重庆市');
        provinceList.add('云南省');
        provinceList.add('贵州省');
        provinceList.add('西藏自治区');
        salesDptMap.put('4.西南',provinceList);
        //CHAN-BDQBLX  20210204 ljh update start
        /*provinceList = new List<String>();
        provinceList.add('北京市');
        provinceList.add('天津市');
        provinceList.add('河北省');
        provinceList.add('山东省');
        provinceList.add('河南省');
        salesDptMap.put('7.能量-1.华北',provinceList);

        provinceList = new List<String>();
        provinceList.add('黑龙江省');
        provinceList.add('吉林省');
        provinceList.add('辽宁省');
        provinceList.add('大连市');
        provinceList.add('内蒙古');
        salesDptMap.put('7.能量-2.东北',provinceList);

        provinceList = new List<String>();
        provinceList.add('山西省');
        provinceList.add('陕西省');
        provinceList.add('青海省');
        provinceList.add('宁夏自治区');
        provinceList.add('新疆自治区');
        provinceList.add('甘肃省');
        salesDptMap.put('7.能量-3.西北',provinceList);

        provinceList = new List<String>();
        provinceList.add('四川省');
        provinceList.add('重庆市');
        provinceList.add('云南省');
        provinceList.add('贵州省');
        provinceList.add('西藏自治区');
        salesDptMap.put('7.能量-4.西南',provinceList);

        provinceList = new List<String>();
        provinceList.add('上海市');
        provinceList.add('江苏省');
        provinceList.add('江西省');
        provinceList.add('安徽省');
        provinceList.add('浙江省');
        provinceList.add('福建省');
        salesDptMap.put('7.能量-5.华东',provinceList);

        provinceList = new List<String>();
        provinceList.add('广东省');
        provinceList.add('深圳市');
        provinceList.add('海南省');
        provinceList.add('广西自治区');
        provinceList.add('湖北省');
        provinceList.add('湖南省');
        salesDptMap.put('7.能量-6.华南',provinceList);*/
        //CHAN-BDQBLX  20210204 ljh update end
        provinceMap = new Map<string,string>();
        
        provinceMap.put('北京市','1.华北');
        provinceMap.put('天津市','1.华北');
        provinceMap.put('河北省','1.华北');
        provinceMap.put('内蒙古','1.华北');
        provinceMap.put('山东省','1.华北');
        provinceMap.put('青岛市','1.华北');
        
        provinceMap.put('辽宁省','2.东北');
        provinceMap.put('黑龙江省','2.东北');
        provinceMap.put('吉林省','2.东北');
        provinceMap.put('大连市','2.东北');
        
        provinceMap.put('河南省','3.西北');
        provinceMap.put('山西省','3.西北');
        provinceMap.put('陕西省','3.西北');
        provinceMap.put('青海省','3.西北');
        provinceMap.put('宁夏自治区','3.西北');
        provinceMap.put('甘肃省','3.西北');
        provinceMap.put('新疆自治区','3.西北');
        
        provinceMap.put('上海市','5.华东');
        provinceMap.put('江苏省','5.华东');
        provinceMap.put('浙江省','5.华东');
        provinceMap.put('福建省','5.华东');
        provinceMap.put('安徽省','5.华东');
        provinceMap.put('江西省','5.华东');
        
        provinceMap.put('广东省','6.华南');
        provinceMap.put('广西自治区','6.华南');
        provinceMap.put('海南省','6.华南');
        provinceMap.put('湖北省','6.华南');
        provinceMap.put('湖南省','6.华南');
        provinceMap.put('深圳市','6.华南');
        
        provinceMap.put('四川省','4.西南');
        provinceMap.put('重庆市','4.西南');
        provinceMap.put('云南省','4.西南');
        provinceMap.put('贵州省','4.西南');
        provinceMap.put('西藏自治区','4.西南');
    }
    
    // 数据赋值
    private void setBean(Integer year) {
        String target_Source = 'SalesTarget';
        if (isEng == true) {
            target_Source = 'EngTarget';
        }



        // 取得当前年度目标数据
        Opportunity[] opportunitys = [select
                        Id, OwnerId, Proportion__c, Opportunity_Category__c, CloseDate,
                        Target_category__c, Important_Key_product_category__c,
                        SAP_Province__c, Owner_System__c,Owner_System__r.Name, Target_Source__c
                 from Opportunity
                where Target_category__c = :target_category
                  // xionyl去掉重点产品名称的查询条件
                 // and Important_Key_product_category__c = :opp.Important_Key_product_category__c
                  and RecordTypeId = :rt.Id
                  //20210225 ljh WLIG-BV8CHF update  财年 start
                  //and OCM_Target_period__c = :currentPeriod
                  and OCM_Target_period__c = :currentPeriodOld
                  //20210225 ljh WLIG-BV8CHF update  财年 end
                  and SAP_Province__c in :provinces
                  and Target_Source__c = :target_Source];
        // 当前年度没有数据时，显示信息
        if (opportunitys.size() <= 0 && isPast && iYear < currentYear) {
            ApexPages.Message msg = new ApexPages.Message(ApexPages.Severity.INFO, '没有上年度的数据。');
            ApexPages.addMessage(msg);
            previousRendered = false;
            iYear += 1;
            //20210225 ljh WLIG-BV8CHF update  财年 start
            //currentPeriod = String.valueOf(iYear - 1867 + 'P');
            currentPeriodOld = String.valueOf(iYear - 1867 + 'P');
            Integer tempiYear = iYear+1;
            currentPeriod = String.valueOf('FY'+tempiYear);
            //20210225 ljh WLIG-BV8CHF update  财年 end
            isPast = false;
            if (iYear < currentYear) {
                isPast = true;
            } else if (iYear == currentYear) {
                if (Date.today().month() == 3) {
                    isPast = true;
                }
            }
            // 今表示しているデータを再取得
            setBean(iYear);
            return;
        }
        oppsMap = new Map<String, Opportunity>();
        for (Opportunity opp : opportunitys) {
            if (opp.OwnerId != null && opp.CloseDate != null){
                String key = opp.SAP_Province__c + '_' + opp.Target_category__c + '_' + opp.Important_Key_product_category__c
                           + '_' + opp.Opportunity_Category__c + '_' + String.valueOf(opp.CloseDate);
                oppsMap.put(key, opp);
            }
        }

        // 2020/07/08 读取中间寄存表 by ld
        getKey_Product_Goalsmap();
        
        AggregateResult[] opportunityLineItems = [select OpportunityId,SUM(NumberOfObjective__c) sum_n,SUM(Objective__c) sum_o from OpportunityLineItem where OpportunityId in :opportunitys group by OpportunityId];
        oliMap = new Map<String, AggregateResult>();
        for (AggregateResult oli : opportunityLineItems) {
            oliMap.put((String) oli.get('OpportunityId'), oli);
        }
        
        List<String> UserId = new List<String>();//CHAN-BDQBLX 20210205 ljh add
        //建立数据集
        dataBeans = new List<DataBean>();
        for (String pro : provinces) {
            DataBean dataBean = new DataBean(provinceMap.get(pro), pro, oppsMap, iYear, target_category, oliMap, pcList);

            Integer i=0;
            // 2020/07/10 与既有中间表数据进行对比 by ld start
            for (Integer j = 0; j < pcList.size(); j++) {
                ImportantProductCategory__c pc = pcList[j];
                String key = dataBean.Opportunity.SAP_Province__c + '_' + target_category + '_' +
                                 pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + target_Source;
                // String key = dataBean.opportunity.SAP_Province__c + '_' + amountCategory[j];


                if (Key_Product_GoalsMap.containsKey(key)){
                    i++;

                    Key_Product_Goals__c Key_Product_Goal = Key_Product_GoalsMap.get(key);

                    dataBean.opportunity.Owner_System__c = Key_Product_Goal.Owner_System__c;
                    dataBean.amount[j].Num_Of_OPD__c = Key_Product_Goal.Num_Of_OPD__c;
                    //CHAN-BDQBLX  20210204 ljh start 
                    UserId.add(Key_Product_Goal.Owner_System__c);
                    //CHAN-BDQBLX  20210204 ljh end
                }
            }
            // 2020/07/10 与既有中间表数据进行对比 by ld end


            dataBeans.add(dataBean);
        }
        //CHAN-BDQBLX  20210204 ljh start
        List<User> userList  = new List<User>();
        Map<String,String> userIdAMap  = new Map<String,String>();
        if (null != UserId && UserId.size() > 0) {
            userList = this.getUserList(UserId);//返回用户得一些信息
        }
        for(User u:userList){
            userIdAMap.put(u.Id,u.Alias);
        }

        
        for(dataBean db:dataBeans){
            //System.debug('==='+db);

            if(userIdAMap.containsKey(db.opportunity.Owner_System__c)){
                db.ownername = userIdAMap.get(db.opportunity.Owner_System__c);
            }
        }
        //CHAN-BDQBLX  20210204 ljh end
    }
    
    // 是否删除整行数据
    private boolean isDelete(DataBean db) {
        if (db.opportunity.Owner_System__c == null) {
            for (Integer i = 0; i < 12; i++) {
                Integer y = iYear;
                Integer m = 4 + i;
                if (m > 12) {
                    y += 1;
                    m -= 12;
                }
                String syear = String.valueOf(y);
                String smonth = String.valueOf(m);
                if (m < 10) {
                    smonth = '0' + smonth;
                }
                String sTagetDay = syear + '-' + smonth + '-01';
                Date tagetDay = Date.valueOf(sTagetDay);
                // 按金额分类顺序处理
                for (Integer j = 0; j < pcList.size(); j++) {
                    ImportantProductCategory__c pc = pcList[j];
                    // 数据检索Key
                    String key = db.opportunity.SAP_Province__c + '_' + target_category + '_' + opp.Important_Key_product_category__c + '_' + pc.depName__c + '_' + sTagetDay;
                    if (oppsMap.containskey(key)) {
                        return true;
                    }
                }
            }
        }
        return false;
    }
    
    // 実際の保存ロジック
    /*private boolean saveLogic() {
        List<Opportunity> insertList = new List<Opportunity>();
        List<Opportunity> updateList = new List<Opportunity>();
        List<Opportunity> deleteList = new List<Opportunity>();

        List<Key_Product_Goals__c> InsertKey_Product_Goals = new list<Key_Product_Goals__c>();
        List<Key_Product_Goals__c> UpdateKey_Product_Goals = new list<Key_Product_Goals__c>();

        String target_Source = 'SalesTarget';
        if (isEng == true) {
            target_Source = 'EngTarget';
        }

        Savepoint sp = Database.setSavepoint();
        try {
            Map<String, Decimal> oppAmount = new Map<String, Decimal>();
            Map<String,String> saveAmountCategoryMap = new Map<String,String>();

            System.debug(dataBeans+'6666');
            
            for (Integer d = 0; d < dataBeans.size(); d++) {
                DataBean db = dataBeans[d];
                System.debug(db+'7777');
                // 寄存数据比例值是否变化
                Boolean proportionChanged = false;
                for (Integer i = 0; i < 12; i++) {
                    Integer y = iYear;
                    Integer m = 4 + i;
                    if (m > 12) {
                        y += 1;
                        m -= 12;
                    }
                    String syear = String.valueOf(y);
                    String smonth = String.valueOf(m);
                    if (m < 10) {
                        smonth = '0' + smonth;
                    }
                    String sTargetDay = syear + '-' + smonth + '-01';
                    
                    // 按金额分类顺序处理
                    for (ImportantProductCategory__c pc : pcList){
                        // 数据检索Key
                        String key = db.opportunity.SAP_Province__c + '_' + target_category + '_' + pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + sTargetDay;
                        
                        Opportunity opp = new Opportunity();
                        // 每月数据赋值                       
                        if (oppsMap.containskey(key)) {
                            opp = oppsMap.get(key);
                            String depName = (pc.depName__c == null || pc.depName__c == '') ? 'GI' : pc.depName__c;
                            if (opp.Proportion__c != proportion.get(depName)[i]) {
                                proportionChanged = true;
                                break;
                             }
                        }
                    }
                    if (proportionChanged) {
                        break;
                    }
                }
                if (db.isChanged == '0' && !proportionChanged) {
                    continue;
                }
                User u = new User();
                if (db.opportunity.Owner_System__c == null) {
                    if (isDelete(db) == false) {
                        continue;
                    }
                }
                // 一年分成12条数据
                for (Integer i = 0; i < 12; i++) {
                    Integer y = iYear;
                    Integer m = 4 + i;
                    if (m > 12) {
                        y += 1;
                        m -= 12;
                    }
                    String syear = String.valueOf(y);
                    String smonth = String.valueOf(m);
                    if (m < 10) {
                        smonth = '0' + smonth;
                    }
                    String sTagetDay = syear + '-' + smonth + '-01';
                    Date tagetDay = Date.valueOf(sTagetDay);
                    // 按金额分类顺序处理
                    for (Integer j = 0; j < pcList.size(); j++){
                        ImportantProductCategory__c pc = pcList[j];
                        // 数据检索Key
                        String key = db.opportunity.SAP_Province__c + '_' + target_category + '_' + pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + sTagetDay;
                        
                        Opportunity newopp = new Opportunity();
                        // 每月数据赋值                        
                        if (oppsMap.containskey(key)) {
                            newopp = oppsMap.get(key);
                            if (db.opportunity.Owner_System__c == null || db.amount[j].Num_Of_OPD__c == null || db.amount[j].Num_Of_OPD__c == 0) {
                                deleteList.add(newopp);
                                continue;
                            }
                            newopp.OwnerId = db.opportunity.Owner_System__c;
                            newopp.Owner_System__c = db.opportunity.Owner_System__c;
                            String depName = (pc.depName__c == null || pc.depName__c == '') ? 'GI' : pc.depName__c;
                            newopp.Proportion__c = proportion.get(depName)[i];
                            newopp.Num_Of_OPD__c = db.amount[j].Num_Of_OPD__c;
                            oppAmount.put(newopp.Id, db.amount[j].Num_Of_OPD__c);
                            updateList.add(newopp);

                            if (!saveAmountCategoryMap.containskey(pc.importantProductGoaIName__c + '_' + pc.depName__c)) {
                                saveAmountCategoryMap.put(pc.importantProductGoaIName__c + '_' + pc.depName__c, pc.importantProductGoaIName__c + '_' + pc.depName__c);
                            }
                        } else {
                            if (db.amount[j].Num_Of_OPD__c == null || db.amount[j].Num_Of_OPD__c == 0) {
                                continue;
                            }
                            newopp.Name = db.opportunity.SAP_Province__c + ' ' + pc.importantProductGoaIName__c;
                            
                            newopp.StageName = '目標';
                            newopp.OwnerId = db.opportunity.Owner_System__c;
                            // トリガをスルーのため、ここでやります
                            newopp.Owner_System__c = db.opportunity.Owner_System__c;
                            
                            newopp.Opportunity_Category__c = pc.depName__c;
                            String depName = (pc.depName__c == null || pc.depName__c == '') ? 'GI' : pc.depName__c;
                            newopp.Proportion__c = proportion.get(depName)[i];
                            newopp.CloseDate = tagetDay;
                            newopp.Num_Of_OPD__c = db.amount[j].Num_Of_OPD__c;
                            newopp.Target_category__c = target_category;
                            newopp.Important_Key_product_category__c = pc.importantProductGoaIName__c;
                            newopp.SAP_Province__c = db.opportunity.SAP_Province__c;
                            newopp.RecordTypeId = rt.Id;
                            newopp.OCM_Target_period__c = currentPeriod;
                            newopp.Target_Source__c = target_Source;
                            
                            insertList.add(newopp);
                            
                            if (!saveAmountCategoryMap.containskey(pc.importantProductGoaIName__c + '_' + pc.depName__c)) {
                                saveAmountCategoryMap.put(pc.importantProductGoaIName__c + '_' + pc.depName__c, pc.importantProductGoaIName__c + '_' + pc.depName__c);
                            }
                        }
                    }
                }
                // 数据库限制小于10000条
                if (insertList.size() + updateList.size() + deleteList.size() >= 4000) {
                    ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.INFO, '操作数据量过大，截止至' + db.opportunity.SAP_Province__c + '的数据操作完成，之后的数据请再次输入并保存。'));
                    break;
                }
            }
            // トリガをスルー
            StaticParameter.EscapeOpportunityBefUpdTrigger = true;
            StaticParameter.EscapeOpportunityHpDeptUpdTrigger = true;
            StaticParameter.EscapeSyncOpportunityTrigger = true;
            StaticParameter.EscapeNFM001Trigger = true;
            StaticParameter.EscapeNFM001AgencyContractTrigger = true;
            StaticParameter.EscapeNFM007Trigger = true;
    
            // 更新数据库
            if (insertList.size() > 0) {
                insert insertList;
                
                Map<String,PricebookEntry> pricebookEntryMap = new Map<String,PricebookEntry>();
                // 製品を検索
                for (ImportantProductCategory__c pc : pcList){
                    String dep = pc.depName__c;
                    Map<String, String> impmap = getImpProductMap(dep);
                    String soql = 'select Id from PricebookEntry' + 
                                  ' where IsActive = true ' + 
                                  '   and Product2.' + impProductApiMap.get(pc.importantProductGoaIName__c) + ' = true';
                    if (dep != null && dep.length() > 0) {
                          soql += '   and Product2.' + impmap.get(pc.importantProductGoaIName__c) + ' = true';
                    }
                          soql += '   and CurrencyIsoCode = \'CNY\' limit 1';
                    System.debug(soql);
                    
                    List<PricebookEntry> pbes = Database.query(soql);
                    if (pbes.size() < 1) {
                        Database.rollback(sp);
                        ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, '在产品（价格表）里找不到' + pc.importantProductGoaIName__c + '-' + dep));
                        return false;
                    }
                    
                    pricebookEntryMap.put(pc.importantProductGoaIName__c + '_' + pc.depName__c, pbes[0]);  
                }
                // 商談新規後、商談商品作成
                List<OpportunityLineItem> oli = new List<OpportunityLineItem>();
                for (Opportunity insOpp : [select Id, Amount,Num_Of_OPD__c,Important_Key_product_category__c,Opportunity_Category__c,Objective__c from Opportunity where Id in :insertList]) {
                    oli.add(new OpportunityLineItem(
                        OpportunityId = insOpp.Id,
                        PricebookEntryId = pricebookEntryMap.get(insOpp.Important_Key_product_category__c + '_' + insOpp.Opportunity_Category__c).Id,
                        Quantity = isCntMap.get(insOpp.Important_Key_product_category__c + '_' + insOpp.Opportunity_Category__c) == false ? 1 : insOpp.Num_Of_OPD__c,
                        UnitPrice = isCntMap.get(insOpp.Important_Key_product_category__c + '_' + insOpp.Opportunity_Category__c) == false ? insOpp.Num_Of_OPD__c : 0
                    ));
                }
                insert oli;
            }
            
            if (updateList.size() > 0) {
                update updateList;
                
                List<OpportunityLineItem> oli = new List<OpportunityLineItem>();
                for (OpportunityLineItem updOli : [select Id, OpportunityId, Opportunity.Important_Key_product_category__c, Opportunity.Opportunity_Category__c from OpportunityLineItem where OpportunityId in : updateList]) {
                    updOli.UnitPrice = isCntMap.get(updOli.Opportunity.Important_Key_product_category__c + '_' + updOli.Opportunity.Opportunity_Category__c) == false ? oppAmount.get(updOli.OpportunityId) : 0;
                    updOli.Quantity = isCntMap.get(updOli.Opportunity.Important_Key_product_category__c + '_' + updOli.Opportunity.Opportunity_Category__c) == false ? 1 : oppAmount.get(updOli.OpportunityId);
                    oli.add(updOli);
                }
                update oli;
            }
            
            if (deleteList.size() > 0) delete deleteList;
            
            return true;
            
        } catch (Exception e) {
            Database.rollback(sp);
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, e.getMessage() + '|' + e.getLineNumber()));
            return false;
        }
    }*/

    public Pagereference UpdateBtn() {
        system.debug('=====UpdateBtn-1');
        boolean rs = saveLogic();
        setBean(iYear);
        Database.executeBatch(new SetProductTargetBatch(), 10);
        if (rs) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.INFO, '反映到目标成功'));
        }
        return null;
    }

    private Boolean saveLogic() {
        List<Opportunity> insertList = new List<Opportunity>();
        List<Opportunity> updateList = new List<Opportunity>();
        List<Opportunity> deleteList = new List<Opportunity>();
        Savepoint sp = Database.setSavepoint();
        try {
            List<Key_Product_Goals__c> InsertKey_Product_Goals = new list<Key_Product_Goals__c>();
            List<Key_Product_Goals__c> UpdateKey_Product_Goals = new list<Key_Product_Goals__c>();
            // 只处理当前本部数据
            
            String target_Source = 'SalesTarget';
            if (isEng == true) {
                target_Source = 'EngTarget';
            }
            for (Integer d = 0; d < dataBeans.size(); d++){
                DataBean db = dataBeans[d];
                system.debug('db+++++++ ' + db);
                if(String.isBlank(db.Opportunity.Owner_System__c))continue;
                for (Integer j = 0; j < amountCategory.size(); j++) {
                    ImportantProductCategory__c pc = pcList[j];
                        // 数据检索Key
                    String key = db.Opportunity.SAP_Province__c + '_' + target_category + '_' +
                                 pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + target_Source;
                    //     // String key = db.Opportunity.SAP_Province__c + '_' + amountCategory[j];
                    // if(String.isNotBlank(db.Opportunity.Owner_System__c)){
                    if(Key_Product_GoalsMap.containsKey(key)) {
                        //临时表已经有了
                        Key_Product_Goals__c Key_Product_Goal = Key_Product_GoalsMap.get(key);
                        if(Key_Product_Goal.Num_Of_OPD__c == db.amount[j].Num_Of_OPD__c) {
                            continue;
                        }else {
                            Key_Product_Goal.Num_Of_OPD__c = db.amount[j].Num_Of_OPD__c;
                            Key_Product_Goal.Department__c = db.department;
                            Key_Product_Goal.SAP_Province__c = db.Opportunity.SAP_Province__c;
                            Key_Product_Goal.Owner_System__c = db.Opportunity.Owner_System__c;
                            Key_Product_Goal.iYear__c = iYear;
                            Key_Product_Goal.Is_Processing__c = true;
                            Key_Product_Goal.Target_Source__c = target_Source;
                            UpdateKey_Product_Goals.add(Key_Product_Goal);
                        }
                    }else {
                        if (db.amount[j].Num_Of_OPD__c == null || db.amount[j].Num_Of_OPD__c == 0) {
                            continue;
                        }
                        Key_Product_Goals__c Key_Product_Goal = new Key_Product_Goals__c();
                        Key_Product_Goal.key__c = key;
                        Key_Product_Goal.Num_Of_OPD__c = db.amount[j].Num_Of_OPD__c;
                        Key_Product_Goal.Department__c = db.department;
                        Key_Product_Goal.SAP_Province__c = db.Opportunity.SAP_Province__c;
                        Key_Product_Goal.Owner_System__c = db.Opportunity.Owner_System__c;
                        Key_Product_Goal.iYear__c = iYear;
                        Key_Product_Goal.Is_Processing__c = true;
                        Key_Product_Goal.Target_Source__c = target_Source;
                        InsertKey_Product_Goals.add(Key_Product_Goal);
                    }

                    // }else {
                    //     if(Key_Product_GoalsMap.containsKey(key)) {
                    //         //临时表已经有了
                    //         Key_Product_Goals__c Key_Product_Goal = Key_Product_GoalsMap.get(key);
                    //         if(Key_Product_Goal.Num_Of_OPD__c == db.amount[j].Num_Of_OPD__c) {
                    //             continue;
                    //         }else {  
                    //             Key_Product_Goal.Num_Of_OPD__c = 0;
                    //             Key_Product_Goal.Department__c = db.department;
                    //             Key_Product_Goal.SAP_Province__c = db.Opportunity.SAP_Province__c;
                    //             Key_Product_Goal.Owner_System__c = db.Opportunity.Owner_System__c;
                    //             Key_Product_Goal.iYear__c = iYear;
                    //             Key_Product_Goal.Is_Processing__c = true;
                    //             UpdateKey_Product_Goals.add(Key_Product_Goal);
                    //         }
                    //     }
                    //     continue;
                    // }
                }
            }

            if(InsertKey_Product_Goals.size() > 0) {
                insert InsertKey_Product_Goals;
            }
            if(UpdateKey_Product_Goals.size() > 0) {
                update UpdateKey_Product_Goals;
            }
            return true;
        } catch (Exception e) {
            system.debug('=====saveLogic-e' + e.getMessage());
            Database.rollback(sp);
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, e.getLineNumber() + ':' + e.getMessage()));
            return false;
        }
    }
    
    private Map<String, String> getImpProductMap(String ac) {
        Map<String, String> impmap = new Map<String, String> {
            '重点产品01' => 'Important_Rroduct_1' + ac +'__c',
            '重点产品02' => 'Important_Rroduct_2' + ac +'__c',
            '重点产品03' => 'Important_Rroduct_3' + ac +'__c',
            '重点产品04' => 'Important_Rroduct_4' + ac +'__c',
            '重点产品05' => 'Important_Rroduct_5' + ac +'__c',
            '重点产品06' => 'Important_Rroduct_6' + ac +'__c',
            '重点产品07' => 'Important_Rroduct_7' + ac +'__c',
            '重点产品08' => 'Important_Rroduct_8' + ac +'__c',
            '重点产品09' => 'Important_Rroduct_9' + ac +'__c',
            '重点产品10' => 'Important_Rroduct_10' + ac +'__c',
            '重点产品11' => 'Important_Rroduct_11' + ac +'__c',
            '重点产品12' => 'Important_Rroduct_12' + ac +'__c',
            '重点产品13' => 'Important_Rroduct_13' + ac +'__c',
            '重点产品14' => 'Important_Rroduct_14' + ac +'__c',
            '重点产品15' => 'Important_Rroduct_15' + ac +'__c',
            '重点产品16' => 'Important_Rroduct_16' + ac +'__c',
            '重点产品17' => 'Important_Rroduct_17' + ac +'__c',
            '重点产品18' => 'Important_Rroduct_18' + ac +'__c',
            '重点产品19' => 'Important_Rroduct_19' + ac +'__c',
            '重点产品20' => 'Important_Rroduct_20' + ac +'__c',
            '重点产品21' => 'Important_Rroduct_21' + ac +'__c',
            '重点产品22' => 'Important_Rroduct_22' + ac +'__c',
            '重点产品23' => 'Important_Rroduct_23' + ac +'__c',
            '重点产品24' => 'Important_Rroduct_24' + ac +'__c',
            '重点产品25' => 'Important_Rroduct_25' + ac +'__c',
            '重点产品26' => 'Important_Rroduct_26' + ac +'__c',
            '重点产品27' => 'Important_Rroduct_27' + ac +'__c',
            '重点产品28' => 'Important_Rroduct_28' + ac +'__c',
            '重点产品29' => 'Important_Rroduct_29' + ac +'__c',
            '重点产品30' => 'Important_Rroduct_30' + ac +'__c',
            '重点产品31' => 'Important_Rroduct_31' + ac +'__c'
        };
        return impmap;
    }
    
    // 数据类
    class DataBean {
        // 担当者信息
        public Opportunity opportunity { get; set; }
        // 总金额，画面用
        public Opportunity[] amount { get; set; }
        // 本部表示用
        public String department { get; private set; }
        // 是否变化 0：无 1：有
        public String isChanged { get; set; }
        //CHAN-BDQBLX  20210204 ljh start  导出用name
        public String ownername { get; private set; }
        //CHAN-BDQBLX  20210204 ljh end
        // 构造方法
        DataBean(String salesDpt, String province, Map<String, Opportunity> oppMap, Integer iYear, String category, Map<String, AggregateResult> oliMap, List<ImportantProductCategory__c> pcList2) {
            this.opportunity = new Opportunity();
            this.amount = new List<Opportunity>();
            this.opportunity.SAP_Province__c = province;
            this.department = salesDpt;
            this.isChanged = '0';

            // 按金额分类，查找数据，并设值
            //List<ImportantProductCategory__c> pcList2 = [select depName__c,importantProductGoaIName__c,commodityCode__c,commodityName__c,if_Quantity__c,sort__c from ImportantProductCategory__c order by sort__c];

            for (Integer i = 0; i < pcList2.size(); i++) {
                ImportantProductCategory__c pc = pcList2[i];  
                Opportunity a = new Opportunity();
                a.Opportunity_Category__c = pc.depName__c;
                Decimal amountSum = 0.0;
                for (Integer j = 0; j < 12; j++) {
                    Integer y = iYear;
                    Integer m = 4 + j;
                    if (m > 12) {
                        y += 1;
                        m -= 12;
                    }
                    String strY = String.valueOf(y);
                    String strM = String.valueOf(m);
                    if (strM.length() < 2) {
                        strM = '0' + strM;
                    }
                    String key = this.opportunity.SAP_Province__c + '_' + category + '_' + pc.importantProductGoaIName__c + '_' + pc.depName__c + '_' + strY + '-' + strM + '-01';
                    if (oppMap.containskey(key)) {
                        if (oppMap.get(key).Owner_System__c != null) {
                            this.opportunity.Owner_System__c = oppMap.get(key).Owner_System__c;
                        }
                        //a.Amount = oppMap.get(key).Amount;
                        if (isCntMap.get(pc.importantProductGoaIName__c + '_' + pc.depName__c) == false) {
                            amountSum += oliMap.get(oppMap.get(key).Id).get('sum_o') == null ? 0 : (Decimal) oliMap.get(oppMap.get(key).Id).get('sum_o');
                        } else {
                            amountSum += oliMap.get(oppMap.get(key).Id).get('sum_n') == null ? 0 : (Decimal) oliMap.get(oppMap.get(key).Id).get('sum_n');
                        }
                    }
                }
                
                if (amountSum > 0) {
                    if (category == '重点产品目标(金额)') {
                        amountSum = amountSum.setScale(2);
                        a.Amount = amountSum;
                    } else {
                        amountSum = amountSum.round();
                        a.Num_Of_OPD__c = amountSum;
                    }
                }  
                  
                this.amount.add(a);
            }
        }
    }
}