global with sharing class TransferApplySelectDetailController extends CreateRelationListPagingCtrlBase {
    public override Integer getSearchNumMax() {
        //各ページに制御あれば、最大件数を指定する
        // searchNumMax = Integer.valueOf(Label.Product_Select_Limit);
        // searchNumMax = 20;
        pagesize = '1000'; // 一页实际显示的行数受SHOW_SIZE控制
        return searchNumMax;
    }
    //20210814 ljh 管理编码 start
    public transient static Map<String,String> locationMap;
    static {
        locationMap = new Map<String, String> {
            '北京 备品中心' => 'BJ',
            '上海 备品中心' => 'SH',
            '广州 备品中心' => 'GZ'
        };
    }
    //20210814 ljh 管理编码 end
    /* 選択されたデータ取得用Soql　Fromから*/
    public override String getSelectedDataSql() {
        // オブジェクトAPI名
        selectedDataSql = ' From TransferApplyDetail__c';
        selectedDataSql += ' where TransferApply__c = \'' + String.escapeSingleQuotes(parentId) + '\'';
        selectedDataSql += ' and Cancel_Select__c = false';
        selectedDataSql += ' order by TransferApplySummary__c, Main_OneToOne__c desc, Asset__c, IndexFromUniqueKey__c';
        for(String field:FIELD_NAME_MAP.keySet()) {
            myComponentController.columnRightRW.put(field, 'r');
        }
        myComponentController.columnRightRW.put('OneToOneAccessory__c', 'r');
        myComponentController.columnRightRW.put('VF_TransferCount__c', 'w');
        myComponentController.columnRightRW.put('VF_TransferCount_Abandoned__c', 'w');
        myComponentController.columnRightRW.put('VF_TransferCount_Repair__c', 'w');
        myComponentController.columnRightRW.put('VF_TransferCount_Lost__c', 'w');
        myComponentController.columnRightRW.put('SalesProvince_After__c', 'w');
        myComponentController.columnRightRW.put('Salesdepartment_After__c', 'w');
        myComponentController.columnRightRW.put('EquipmentSet_Managment_Code_After__c', 'w');
        myComponentController.columnRightRW.put('Equipment_Type_After__c', 'w');
        myComponentController.columnRightRW.put('WH_location__c', 'w');
        // 20210814 ljh 管理编码        
        myComponentController.columnRightRW.put('CodeKey__c', 'r');
        myComponentController.columnRightRW.put('CreatedDate', 'r');
        // 20210814 ljh 管理编码
        return selectedDataSql;
    }

    public override String getOriginObjName() {
        // オブジェクトAPI名
        originObjName = 'Asset';
        return originObjName;
    }
    public override String getOriginObjColumns() {
        // 項目セット
        List<String> cols = FIELD_NAME_MAP.values();
        originObjColumns = String.join(cols, ', ') ;
        return originObjColumns;
    }

    public override String getObjName() {
        // オブジェクトAPI名
        objName = 'TransferApplyDetail__c';
        return objName;
    }
    public override String getColumnLeftFieldSetName() {
        // 左の項目セット
        columnLeftFieldSetName = '';
        return columnLeftFieldSetName;
    }
    public override String getColumnRightFieldSetName() {
        // 右の項目セット
        columnRightFieldSetName = '';
        switch on (parentObj.RecordType.DeveloperName) {
            when 'AgencyToCenter' {
                columnRightFieldSetName = 'TransferApplySelectDetailAgency';
            }
            when 'InsideCenter' {
                columnRightFieldSetName = 'TransferApplySelectDetailInside';
            }
            when 'CenterToOther' {
                columnRightFieldSetName = 'TransferApplySelectDetailOther';
            }
            when else {
                columnRightFieldSetName = 'TransferApplySelectDetailCenter';
            }
        }

        return columnRightFieldSetName;
    }
    public override Boolean getShowRecordCountMSG() {
        return false;
    }
    public override List<String> getColumnFieldList() {
        // strColumus 里加 field
        // FixtureUtil#raesdGroupByAssetId()の項目も必要
        List<String> cols = new List<String>{'TransferApplySummary__c'
                                , 'Approved_F__c'
                                , 'StockDown__c'
                                , 'OneToOneAccessory__c'
                                , 'TransferType__c'
                                , 'Cancel_Select__c'
                                , 'DeliverySlip__c'
                                , 'Fixture_OneToOne_Link__c'
                                , 'Request_time__c'
                                , 'Add_Request_demo_time__c'
                                , 'Fixture_OneToOne_Link__r.In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c'
                                , 'Fixture_OneToOne_Link__r.Abandoned_RealThing__c'
                                , 'Fixture_OneToOne_Link__r.CountForRepair__c'
                                , 'FSD_SortInt__c'
                                , 'IndexFromUniqueKey__c'
                                , 'Salesdepartment_After__c'
                                , 'VF_TransferCount_Repair__c' //20210814 ljh add  SFDC-C5K393
                                , 'VF_TransferCount_Lost__c' //20210814 ljh add SFDC-C5K393
                                , 'VF_TransferCount_Abandoned__c' //20210814 ljh add SFDC-C5K393
                                , 'VF_TransferCount__c' //20210814 ljh add SFDC-C5K393
                                , 'Equipment_Type_After__c' //20210818 ljh add SFDC-C5K393
                                , 'SalesProvince_After__c' //20210818 ljh add SFDC-C5K393
                                , 'EquipmentSet_Managment_Code_After__c' //20210818 ljh add SFDC-C5K393
                                , 'WH_location__c' //20210818 ljh add SFDC-C5K393
                                , 'CodeKey__c' // 20210814 ljh 管理编码
                                , 'CreatedDate' // 20210814 ljh 管理编码
                            };
        for(String field:FIELD_NAME_MAP.keySet()) {
            cols.add('Asset__r.' + FIELD_NAME_MAP.get(field));
            cols.add(field);
        }
        return cols;
    }

    public override String getFKColumnField() {
        // getObjName 连 getOriginObjName 的 FK
        return '';
    }

    public override String getRecordTypeId() {
        //ページレイアウトを収得するのレコードタイプ
        recordTypeId = '';
        return recordTypeId;
    }

    // ページコントローラに検索処理は、WhereSoql作成のみ、パラメータとして、コンポーネントに渡される
    public override String getSqlWhereStr() {
        sqlWhereStr = '';

        if (getIsNeedRunSearch()) {
            sqlWhereStr = this.makeSoql(keyword, assetnumber);
        }
        //20201215 ljh add start
        if(raAssetId != null && raAssetId.size() > 0){
            List<String> raAssetIdList = new List<String>(raAssetId);
            //System.debug('raAssetIdList:'+raAssetIdList);
            String sqlTail = '(\'';
            for(Integer i = 0 ; i< raAssetIdList.size();i++){
                if(i<raAssetIdList.size()-1){
                    sqlTail += raAssetIdList[i]+'\',\'';
                }else{
                    sqlTail += raAssetIdList[i]+'\')';
                }
            }
            sqlWhereStr += ' and Id IN '+sqlTail;
        }
        //20201215 ljh add end
        return sqlWhereStr;

    }

    public override String getOrderbyStr() {
        String ordStr = 'order by Fixture_Model_No_F__c';
        return ordStr;
    }

    public override Boolean getIsNeedRunSearch() {
        return this.searchAsset;
    }

    /*****************検索用******************/


    /*****************ソート時再検索条件（画面からの入力条件を無視するため）******************/
    public String keyword { get; set; }
    public String assetnumber {get; set;}
    public TransferApply__c parentObj { get; private set; }
    private List<TransferApplySummaryBean> tasBeanList{get;set;} // 全部的，包括申请单下已有的、导入的和检索出的
    private List<TransferApplySummaryBean> filteredTasBeanList {get;set;} // tasBeanList的子集，需要在画面上显示的，

    public Boolean isCenter {get;set;}
    public Boolean readonly {get;set;}
    public Integer detailCountLimit{get;private set;}
    private Boolean searchAsset {get;set;}
    public String fieldName {get;set;}
    public String fieldValue {get;set;}
    public String operator {get;set;}
    public static Integer SHOW_SIZE = 20 ; // 一页实际显示多少个行

    public String raId { get; private set; }//20201215 ljh /// start
    public String newid { get; private set; }//20201215 ljh add start
    public Boolean isComeFromRa { get; private set; } //20201215 ljh add start
    public Set<String> raAssetId; //20201215 ljh add start
    public Map<Id, Map<String, Integer>> raAssetCountMap; // 从借出申请创建，记录设备数量，设备Id->调拨分类->数量
    public TransferApplySelectDetailController() {
        parentId = ApexPages.currentPage().getParameters().get('id');
        tasBeanList = new List<TransferApplySummaryBean>();
        filteredTasBeanList  = new List<TransferApplySummaryBean>();
        raAssetCountMap = new Map<Id, Map<String, Integer>>();
        detailCountLimit = 10000;
        searchAsset = false;
        isComeFromRa = false;
        isCenter = true;
        readonly = false;
        if (String.isBlank(this.parentId)) {
            raId = ApexPages.currentPage().getParameters().get('raid');
            if(!String.isBlank(this.raId)){
                this.parentId = ApexPages.currentPage().getParameters().get('newid');
                //isCenter 这个是判断是否是备品中心操作，虽然此时一定是办事处但是isCenter是false不一定从备品出借过来的
                isComeFromRa = true;
            }
        }
        parentObj = getParentObj(false);
    }
    /**
    @description 获取最新的申请数据，并做检查，要放到try里
    @param needCheck 是否做检查
    @return 最新的申请
    */
    private TransferApply__c getParentObj(Boolean needCheck) {
        TransferApply__c ta = null;
        if (!String.isBlank(this.parentId)) {
            List<TransferApply__c> taList = [
                SELECT Id
                     , Add_Approval_Status__c
                     , Status__c
                     , RecordType.DeveloperName
                     , From_Location__c
                     , Rental_Apply__c //20200105 ljh add
                     , LastModifiedDate
                     , LastModifiedBy.Name
                     , Request_approval_time__c
                     , Yi_loaner_arranged__c
                     , DeliverySlip__c
                     , TA_Status__c
                     , Destination_location__c // 20210826 ljh 管理编码
                  FROM TransferApply__c
                 WHERE Id=:parentId
            ];
            if(taList.isEmpty()) {
                throw new ControllerUtil.myException('参数错误：请指定Id。');
            }
            else{
                ta = taList[0];
                if(needCheck) {
                    if(parentObj != null && parentObj.LastModifiedDate != ta.LastModifiedDate) {
                        throw new ControllerUtil.myException('后台数据被 ' + ta.LastModifiedBy.Name + ' 修改，请刷新画面！');
                    }
                    if(ta.RecordType.DeveloperName == 'InsideCenter' && ta.Status__c != '草案中') {
                        throw new ControllerUtil.myException('同备品中心调拨类型，提交审批后不可修改！');
                    }
                    else if(ta.DeliverySlip__c != null) {
                        throw new ControllerUtil.myException('申请单已出库，不可修改明细！');
                    }
                }
                isCenter = ta.RecordType.DeveloperName != 'AgencyToCenter';
                if (String.isNotBlank(ta.Rental_Apply__c)) {
                    raId = ta.Rental_Apply__c;
                    //从备品出借过来的
                    isComeFromRa = true;
                }
                if(ta.Yi_loaner_arranged__c > 0 || ta.Status__c == '申请中' || ta.Add_Approval_Status__c == '申请中') {
                    readonly = true;
                }
                else if(ta.RecordType.DeveloperName == 'InsideCenter' && ta.TA_Status__c == '已更新') {
                    readonly = true;
                }
                else {
                    readonly = false;
                }
            }
        } else {
            throw new ControllerUtil.myException('参数错误：请指定Id。');
        }
        return ta;
    }
    private void loadAssetMap(Id assId, String transferType) {
        if(raAssetCountMap == null) {
            raAssetCountMap = new Map<Id, Map<String, Integer>>();
        }
        Map<String, Integer> cntMap = null;
        if(raAssetCountMap.containsKey(assId)) {
            cntMap = raAssetCountMap.get(assId);
        }
        else {
            cntMap = new Map<String, Integer>{'待修理'=>0,'待废弃'=>0,'有效库存'=>0,'丢失找回'=>0};
        }
        cntMap.put(transferType, cntMap.get(transferType) + 1);
        raAssetCountMap.put(assId, cntMap);
    }
    public void init() {
        //20201215 ljh add start
        if(isComeFromRa){
            //查找符合要求的保有设备
            raAssetId = new Set<String>();
            List<Rental_Apply_Equipment_Set_Detail__c> raesdList = [SELECT Id,Name,Lost_item_giveup__c,Arrival_in_wh__c,Arrival_wh_Result_Agency__c
            ,Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_in_wh__c
            ,Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_Result_Agency__c
            ,Rental_Apply_Equipment_Set__r.First_RAESD__r.Lost_item_giveup__c
            ,Rental_Apply_Equipment_Set__r.First_RAESD__r.Asset__c
            ,Is_Body__c,Asset__c,Rental_Apply__c,Lost_Item_return__c,OneToOne_Flag__c
            ,Check_lost_Item__c,Check_lost_Item_Final__c,Rental_Apply_Equipment_Set__r.First_You_Xiao_Ku_Cun__c
            ,Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_time__c,Arrival_wh_time__c
            FROM Rental_Apply_Equipment_Set_Detail__c WHERE Rental_Apply__c = :raId AND Cancel_Select__c = false];
            for(Rental_Apply_Equipment_Set_Detail__c raesd:raesdList){
                if(raesd.Asset__c != null){
                    //画面默认且仅显示符合调拨要求的数据（①欠品断念后找回的主体 ②（主体上架ok）欠品断念后找回的附属品 ③主体待修理的整个配套 ④（主体上架ok）待修理的附属品）⑤主体断念后单独的附属品
                    if(raesd.Is_Body__c){
                        //①欠品断念后主体
                        if(raesd.Lost_item_giveup__c ){
                            raAssetId.add(raesd.Asset__c);
                        }
                        //②主体待修理/移至报废区
                        if(raesd.Arrival_wh_Result_Agency__c != null && (raesd.Arrival_wh_Result_Agency__c == '待修理' || raesd.Arrival_wh_Result_Agency__c == '移至报废区' )){
                            raAssetId.add(raesd.Asset__c);
                        }
                    }else{
                        //①主体欠品断念后的整个配套(不是欠品的附属品)
                        //有主体得是一对一附属品
                        if(raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Lost_item_giveup__c  &&
                        raesd.OneToOne_Flag__c  &&
                        raesd.Arrival_wh_Result_Agency__c != null) {
                            raAssetId.add(raesd.Asset__c);
                            if(raesd.Arrival_wh_Result_Agency__c == '待修理') {
                                loadAssetMap(raesd.Asset__c, '待修理');
                            }
                            else if(raesd.Arrival_wh_Result_Agency__c == '移至报废区') {
                                loadAssetMap(raesd.Asset__c, '待废弃');
                            }
                            else {
                                loadAssetMap(raesd.Asset__c, '有效库存');
                            }
                        }
                        //②（主体上架ok）待修理的附属品
                        if(raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_Result_Agency__c !=null &&
                        raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_Result_Agency__c == 'OK'  &&
                        raesd.OneToOne_Flag__c  &&
                        raesd.Arrival_wh_Result_Agency__c != null && (raesd.Arrival_wh_Result_Agency__c == '待修理' || raesd.Arrival_wh_Result_Agency__c == '移至报废区')){
                            raAssetId.add(raesd.Asset__c);
                            if(raesd.Arrival_wh_Result_Agency__c == '待修理') {
                                loadAssetMap(raesd.Asset__c, '待修理');
                            }
                            else if(raesd.Arrival_wh_Result_Agency__c == '移至报废区') {
                                loadAssetMap(raesd.Asset__c, '待废弃');
                            }
                        }
                        //⑤ （主体上架ok）断念后的附属品
                        if(raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_Result_Agency__c !=null &&
                        raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_Result_Agency__c == 'OK'  &&
                        raesd.OneToOne_Flag__c  &&
                        raesd.Lost_item_giveup__c ){
                            raAssetId.add(raesd.Asset__c);
                            loadAssetMap(raesd.Asset__c, '丢失找回');
                        }
                        //20210120  add start
                        if(raesd.Rental_Apply_Equipment_Set__r.First_You_Xiao_Ku_Cun__c <= 0
                        && raesd.OneToOne_Flag__c  && String.isNotBlank(raesd.Check_lost_Item__c) && String.isNotBlank(raesd.Check_lost_Item_Final__c) && raesd.Check_lost_Item__c == '欠品' && raesd.Check_lost_Item_Final__c == 'OK'
                        && raesd.Arrival_in_wh__c && raesd.Arrival_wh_time__c != raesd.Rental_Apply_Equipment_Set__r.First_RAESD__r.Arrival_wh_time__c){
                            raAssetId.add(raesd.Asset__c);
                            if(raesd.Arrival_wh_Result_Agency__c == '待修理') {
                                loadAssetMap(raesd.Asset__c, '待修理');
                            }
                            else if(raesd.Arrival_wh_Result_Agency__c == '移至报废区') {
                                loadAssetMap(raesd.Asset__c, '待废弃');
                            }
                            else {
                                loadAssetMap(raesd.Asset__c, '有效库存');
                            }
                        }
                        //20210120  add end
                    }
                }
            }
            //System.debug('000111raAssetId:'+raAssetId);
            if(raAssetId.size() > 0){
                isNeedSearchFirst=true;
                this.searchAsset=true;
                getSqlWhereStr();
            }else{
                ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.ERROR, '该申请没有符合条件的一览明细!'));
            }
        }else{
            isNeedSearchFirst = false;
        }
        //20201215 ljh add end
    }

    // 所在地区(本部)
    public List<SelectOption> salesdepartmentOpts {
        get {
            if (salesdepartmentOpts == null) {
                salesdepartmentOpts = getPickList('TransferApplyDetail__c', 'Salesdepartment__c');
            }
            return salesdepartmentOpts;
        }
        set;
    }
    // 所在地区(省)
    public List<SelectOption> salesProvinceOpts {
        get {
            if (salesProvinceOpts == null) {
                salesProvinceOpts = getPickList('TransferApplyDetail__c', 'SalesProvince__c');
            }
            return salesProvinceOpts;
        }
        set;
    }
    // 备品分类
    public List<SelectOption> equipmentTypeOpts {
        get {
            if (equipmentTypeOpts == null) {
                equipmentTypeOpts = getPickList('TransferApplyDetail__c', 'Equipment_Type__c');
            }
            return equipmentTypeOpts;
        }
        set;
    }
    public List<SelectOption> fieldNameOpts {
        get{
            List<SelectOption> selectOptions = new List<SelectOption> { new SelectOption('', '') };
            selectOptions.add(new SelectOption('Internal_asset_location__c' , '备品存放地'));
            selectOptions.add(new SelectOption('Salesdepartment__c' , '所在地区(本部)'));
            selectOptions.add(new SelectOption('Fixture_Model_No__c' , '型号'));
            selectOptions.add(new SelectOption('Internal_Asset_number_key__c' , '固定资产编号(Key)'));
            selectOptions.add(new SelectOption('Manage_type__c' , '管理种类'));
            selectOptions.add(new SelectOption('SerialNumber__c' , '机身编号'));
            selectOptions.add(new SelectOption('Main_OneToOne__c' , '是否一对一主体'));

            return selectOptions;
        }
    }
    public List<SelectOption> operatorOpts {
        get{
            List<SelectOption> selectOptions = new List<SelectOption> { new SelectOption('', '') };
            selectOptions.add(new SelectOption('==','等于'));
            selectOptions.add(new SelectOption('!=','不等于'));
            selectOptions.add(new SelectOption('<','<'));
            selectOptions.add(new SelectOption('>','>'));
            selectOptions.add(new SelectOption('<=','<='));
            selectOptions.add(new SelectOption('>=','>='));
            selectOptions.add(new SelectOption('contains','包含'));
            selectOptions.add(new SelectOption('notcontains','不包含'));
            selectOptions.add(new SelectOption('startswith','起始字符'));
            return selectOptions;
        }
    }
    public void clear() {
        fieldName = '';
        operator = '';
        fieldValue = '';
        myComponentController.page = 1;
        refreshViewList(tasBeanList);
    }
    public void filter() {
        if (String.isNotBlank(fieldName) && String.isNotBlank(operator)) {
            filteredTasBeanList.clear();
            for (TransferApplySummaryBean info : tasBeanList) {
                TransferApplyDetail__c tad = (TransferApplyDetail__c) info.wpinfoList[0].sObj;
                String fieldValueInRecord = tad.get(fieldName) == null ? '' :String.valueOf(tad.get(fieldName));
                if(fieldValue == null) {
                    fieldValue = '';
                }
                Boolean meet = false;
                if (operator == '==' && fieldValueInRecord == String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == '!=' && fieldValueInRecord != String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == '<' && fieldValueInRecord < String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == '<=' && fieldValueInRecord <= String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == '>' && fieldValueInRecord > String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == '>=' && fieldValueInRecord >= String.valueOf(fieldValue)) {
                    meet = true;
                }
                else if (operator == 'contains' && fieldValueInRecord.contains(String.valueOf(fieldValue))) {
                    meet = true;
                }
                else if (operator == 'notcontains' && !fieldValueInRecord.contains(String.valueOf(fieldValue))) {
                    meet = true;
                }
                else if (operator == 'startswith' && fieldValueInRecord.startsWith(String.valueOf(fieldValue))) {
                    meet = true;
                }
                if (meet) {
                    filteredTasBeanList.add(info);
                }
            }
            Integer filterLimit = SHOW_SIZE;
            if (filteredTasBeanList.size() > filterLimit) {
                while (filteredTasBeanList.size() > filterLimit) {
                    filteredTasBeanList.remove(filterLimit);
                }
                ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.WARNING, '满足条件的超过' + filterLimit + '条，此处只显示前' + filterLimit + '，请更换筛选条件'));
            }
        }
        else {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.ERROR, '请填写筛选条件'));
        }
        myComponentController.page = 1;
        refreshViewList(filteredTasBeanList);
    }
    // 检索按钮
    public PageReference searchOpp() {
        return searchOpp(true);
    }

    private PageReference searchOpp(Boolean searchAsset) {

        this.searchAsset = searchAsset;
        // 選択済みの製品を取得
        myComponentController.getSelectedDataInfo();

        getSqlWhereStr();

        // コンポーネントにSoqlを発行して、ページングする
        myComponentController.searchAndPaging();
        return null;
    }
    // 取消明细按钮
    public void cancelDetail() {
        Map<Id, TransferApplyDetail__c> delTadMap = new Map<Id, TransferApplyDetail__c>();
        Map<Id, TransferApplySummary__c> updateTasMap = new Map<Id, TransferApplySummary__c>();
        Map<Id, TransferApplyDetail__c> updateTadMap = new Map<Id, TransferApplyDetail__c>();
        Set<Id> assIdSet = new Set<Id>();
        Savepoint sp = Database.setSavepoint();
        try {
            parentObj = getParentObj(true);
            for(TransferApplySummaryBean tasBean : tasBeanList) {
                if(tasBean.wpinfoList[0].check) {
                    for(WrapperInfo wi: tasBean.wpinfoList) {
                        TransferApplyDetail__c tad = (TransferApplyDetail__c) wi.sobj;
                        if(parentObj.Status__c == '已批准' || parentObj.Yi_loaner_arranged__c == 0) { // 出库前可以做取消
                            if(tad.Approved_F__c) {
                                tad.Cancel_Select__c = true;
                                tad.Cancel_Reason__c = '主动取消';
                                assIdSet.add(tad.Asset__c);
                                updateTadMap.put(tad.Id, tad);
                            }
                            else if (tad.Id == null) {
                                throw new ControllerUtil.myException('未保存过的明细不可取消');
                            }
                            else { // 追加未审批的明细要删除
                                delTadMap.put(tad.Id, tad);
                            }
                        }
                        else {
                            throw new ControllerUtil.myException('不可以取消明细');
                        }
                    }
                }
            }
            for(Id tadId:delTadMap.keySet()) {
                if(updateTadMap.containsKey(tadId)) {
                    updateTadMap.remove(tadId);
                }
            }
            if(!delTadMap.isEmpty()) {
                delete delTadMap.values();
            }
            if(!updateTadMap.isEmpty()) {
                update updateTadMap.values();
            }
            // 追加批准状态处理
            updateAddApproval();
            // 取消成功时，把勾都去掉
            for(TransferApplySummaryBean tasBean : tasBeanList) {
                tasBean.wpinfoList[0].check = false;
            }
            searchOpp(false);
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Info, '取消成功'));
            parentObj = getParentObj(false);
            //print('更新后Asset',[SELECT Name,You_Xiao_Ku_Cun__c,TransferFrozenQuantity__c FROM Asset WHERE Id =: assIdSet]);
            //print('更新后link',[SELECT Name,In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c,TransferFrozenQuantity__c FROM Fixture_OneToOne_Link__c WHERE Main_Asset__c =: assIdSet]);
            //Database.rollback(sp);
        }
        catch (Exception ex) {
            System.debug(ex.getStackTraceString());
            ApexPages.addMessages(ex);
            Database.rollback(sp);
        }
    }
    // 调试用
    private void print(String title, Map<Id, Object> m) {
        ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Info, title));
        for(Id a:m.keyset()) {
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Info, '' + m.get(a)));
        }
    }
    // 调试用
    private void print(String title, List<Object> l) {
        ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Info, title));
        for(Object o:l) {
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.Info, '' + o));
        }
    }
    public void importCSVFile() {
        String csvData = ApexPages.currentPage().getParameters().get('csvData');
        List<List<String>> tempCsvBody = CSVReader.readIETFRFC4180CSVFile(Blob.valueof(csvData));  // 全部CSV数据
        List<String> importLabelList = tempCsvBody[0];  // CSV读入的标题行
        Set<Id> assetIdSet = new Set<Id>();
        List<TransferApplyDetail__c> tadList = new List<TransferApplyDetail__c>();
        Integer importLine = 0;
        List<String> warningList = new List<String>();

        removeUncheckedTasBean();
        Set<Id> hideAssetIdSet = new Set<Id>(); // 个体管理的保有设备如果已经在明细中，则检索时不再显示
        removeUncheckedTasBean();
        for(TransferApplySummaryBean tasBean:tasBeanList) {
            for(WrapperInfo wf:tasBean.wpinfoList) {
                TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sObj;
                if(tad.Manage_type__c == '个体管理') {
                    hideAssetIdSet.add(tad.Asset__c);
                }
                else if(!tad.OnetoOneAccessory__c) { // 数量管理非一对一附属品，如果导入中已存在则不再在检索结果中显示
                    hideAssetIdSet.add(tad.Asset__c);
                }
            }
        }

        Map<String, String> labelToApiMap = createLabelApiMap();
        Map<String, SObjectField> queryAssetFieldMap = TransferApplyDetail__c.getSObjectType().getDescribe().fields.getMap();
        for (Integer i = 1; i < tempCsvBody.size(); i++) {
            TransferApplyDetail__c tempTad = new TransferApplyDetail__c();
            for (Integer j = 0; j < importLabelList.size(); j++) {
                String api = labelToApiMap.get(importLabelList[j]);
                if (queryAssetFieldMap.containsKey(api) == false) {
                    throw new ControllerUtil.myException('字段:【' + importLabelList[j] + '】在' + TransferApplyDetail__c.getSObjectType().getDescribe().getLabel() + '里不存在, 请确认。');
                }
                DescribeFieldResult queryAssetFieldResult = queryAssetFieldMap.get(api).getDescribe();
                if (String.isNotBlank(tempCsvBody[i][j])){
                    String value = String.valueOf(tempCsvBody[i][j]).trim();
                    if (queryAssetFieldResult.getType() == Schema.DisplayType.Date) {
                        tempTad.put(api, Date.valueOf(value));
                    } else if (queryAssetFieldResult.getType() == Schema.DisplayType.Boolean) {
                        tempTad.put(api, Boolean.valueOf(value));
                    } else if (queryAssetFieldResult.getType() == Schema.DisplayType.Double) {
                        tempTad.put(api, Decimal.valueOf(value));
                    } else {
                        tempTad.put(api, value);
                    }
                }
            }

            Id assetId = tempTad.Asset__c;
            if(String.isBlank(assetId)){
                throw new ControllerUtil.myException('【' + queryAssetFieldMap.get('Asset__c').getDescribe().getLabel() + '】不可为空' + tempTad);
            }
            else if(!hideAssetIdSet.contains(assetId)) {
                // 已导过的或申请下已存在的设备不重复显示
                assetIdSet.add(assetId);
                tadList.add(tempTad);
            }
        }
        if(assetIdSet.isEmpty()) {
            return;
        }

        String assSql = 'SELECT '
                      + String.join(FIELD_NAME_MAP.values(), ', ')
                      + ' FROM Asset ';
        assSql += this.makeSoql('','');
        assSql += ' and Id IN :assetIdSet';
        Map<Id, Asset> assetMap = new Map<Id, Asset>((List<Asset>)Database.query(assSql));
        Map<Id, TransferApplySummaryBean> mainTasBeanMap = new Map<Id, TransferApplySummaryBean> (); //主体保有设备Id->一览bean
        for(Integer i = 0; i < tadList.size(); i++) {
            TransferApplyDetail__c tad = tadList[i];
            Asset ass = null;
            if(assetMap.containsKey(tad.Asset__c)){
                ass = assetMap.get(tad.Asset__c);
            }
            else {
                warningList.add(tad.Asset__c+'不存在');
                continue;
            }
            for(String field:FIELD_NAME_MAP.keySet()) {
                tad.put(field, ass.get(FIELD_NAME_MAP.get(field)));
            }

            if(tad.VF_TransferCount_Abandoned__c > 0) {
                tad.TransferType__c = '待废弃';
            }
            else if(tad.VF_TransferCount_Repair__c > 0) {
                tad.TransferType__c = '待修理';
            }
            else if(tad.VF_TransferCount_Lost__c > 0) {
                tad.TransferType__c = '丢失找回';
            }
            else {
                tad.TransferType__c = '有效库存';
            }
            TransferApplySummaryBean tasBean = new TransferApplySummaryBean();
            if(ass.Main_OneToOne__c) {
                tad.Main_OneToOne__c = true;
                mainTasBeanMap.put(ass.Id, tasBean);
            }
            WrapperInfo wf = new WrapperInfo(tad, myComponentController);
            wf.check = true;
            tasBean.wpinfoList.add(wf);
            tasBeanList.add(tasBean);
            importLine++;
        }
        for(Integer i = 0; i < Math.min(5, warningList.size()); i++){
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.WARNING, warningList[i]));
        }
        if (warningList.size() > 0) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.WARNING, warningList.size() + '条记录不存在或不可调拨'));
        }
        if(importLine == 0) {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.WARNING, '未导入任何数据，请检查CSV文件'));
        }
        else {
            String importSuccessfulMsg = '导入CSV文件完成，成功导入' + importLine + '条数据。';
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.INFO, importSuccessfulMsg));
            if(parentObj.RecordType.DeveloperName != 'InsideCenter') {
                addOnetoOneAccessories(mainTasBeanMap);
            }
            myComponentController.page = 1;
            refreshViewList(tasBeanList);
        }
    }

    private Map<String, String> createLabelApiMap(){
        Map<String,String> apiMap = new Map<String,String>();
        Map<String,Schema.SObjectField> mfields = TransferApplyDetail__c.sObjectType.getDescribe().fields.getMap();
        for(String strField:mfields.keySet()) {
            SObjectField fl = mfields.get(strField);
            apiMap.put(fl.getDescribe().getlabel(), strField);
        }
        return apiMap;
    }
    public PageReference savePage() {
        if(save()){
            searchOpp(isComeFromRa);
            ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.INFO, '保存完了'));
        }
        return null;
    }
    public Boolean save() {

        Boolean done = false;
        List<TransferApplyDetail__c> upsertTadList = new List<TransferApplyDetail__c>();
        List<TransferApplyDetail__c> upsertTadMList = new List<TransferApplyDetail__c>();
        List<TransferApplyDetail__c> deleteTadList = new List<TransferApplyDetail__c>();
        List<TransferApplySummary__c> newTasList= new List<TransferApplySummary__c>();
        Savepoint sp = Database.setSavepoint();
        try {
            parentObj = getParentObj(true);
            // 找出现有型号->一览
            List<TransferApplySummary__c> tasList = [
                    SELECT First_TAD__r.Fixture_Model_No_F__c
                        , First_TAD__r.SerialNumber_F__c
                        , First_TAD__r.Main_OneToOne__c
                        , IndexFromUniqueKey__c
                        , TransferDetail_Cnt__c
                    FROM TransferApplySummary__c
                    WHERE TransferApply__c =:parentId AND Cancel_Select__c = false
            ];
            Map<String, TransferApplySummary__c> tasMap = new Map<String, TransferApplySummary__c>();
            Map<String, Integer> tasIndexMap = new Map<String, Integer>();
            List<TransferApplySummaryBean> beansForCheck = new List<TransferApplySummaryBean>();
            for(TransferApplySummary__c tas: tasList) {
                // 型号相同的数量附属品都放到一个一览里
                String tasKey = tas.First_TAD__r.Fixture_Model_No_F__c;
                // 型号相同的主体要分别构造一览（用序列号区分）
                if(tas.First_TAD__r.Main_OneToOne__c) {
                    tasKey += ':' + tas.First_TAD__r.SerialNumber_F__c;
                }
                tasMap.put(tasKey, tas);
            }
            Boolean FirstOnlyMain = false; //20210511 ljh 1832 add

            for(TransferApplySummaryBean tasBean:tasBeanList) {
                if(tasBean.wpinfoList[0].check) {
                    beansForCheck.add(tasBean);
                    TransferApplyDetail__c tad = (TransferApplyDetail__c) tasBean.wpinfoList[0].sObj;
                    String tasKey = tad.Fixture_Model_No__c;
                    if(tad.Main_OneToOne__c) {
                        tasKey += ':' + tad.SerialNumber__c;
                    }
                    TransferApplySummary__c tas = null;
                    if(!tasMap.containsKey(tasKey)) {
                        tas = new TransferApplySummary__c();
                        tas.TransferApply__c = parentId;
                        tas.Fixture_Set__c = tasBean.tas.Fixture_Set__c;
                        tasMap.put(tasKey, tas);
                    }
                    else {
                        tas = tasMap.get(tasKey);
                    }
                    if(tasIndexMap.containsKey(tad.Fixture_Model_No__c)) {
                        //20210511 ljh update 1832 start
                        //tas.IndexFromUniqueKey__c = tasIndexMap.get(tad.Fixture_Model_No__c);
                        if(tad.Main_OneToOne__c
                            ||
                            (tad.Main_OneToOne__c == false
                            && tad.Loaner_accsessary__c == false
                            && tad.OneToOneAccessory__c == false
                            && !FirstOnlyMain)
                        ) {
                            if(tad.Main_OneToOne__c == false && tad.Loaner_accsessary__c == false && tad.OneToOneAccessory__c == false){
                                FirstOnlyMain = true;
                            }
                            tas.IndexFromUniqueKey__c = tasIndexMap.get(tad.Fixture_Model_No__c)+1;
                        }
                        //20210511 ljh update 1832 end
                    }
                    else {
                        tas.IndexFromUniqueKey__c = 1;
                        //20210511 ljh add 1832 start
                        if(tad.Main_OneToOne__c == false && tad.Loaner_accsessary__c == false && tad.OneToOneAccessory__c == false){
                            FirstOnlyMain = true;
                        }
                        //20210511 ljh add 1832 end
                    }
                    //20210511 ljh update 1832 start
                    //if(tad.Main_OneToOne__c) {
                    //     tasIndexMap.put(tad.Fixture_Model_No__c, intValueOf(tas.IndexFromUniqueKey__c + 1));
                    // }
                    tasIndexMap.put(tad.Fixture_Model_No__c, intValueOf(tas.IndexFromUniqueKey__c));
                    //20210511 ljh update 1832 end
                }
            }
            // 检查待保存的明细
            List<String> errorList = checkDetails(beansForCheck);
            if(!errorList.isEmpty()) {
                for (String errMsg:errorList) {
                    ApexPages.addMessage(new ApexPages.Message(ApexPages.severity.ERROR, errMsg));
                }
                return false;
            }
            if(!tasMap.isEmpty()) {
                upsert tasMap.values();
            }
            Integer tadIndex = 1;
            Map<Id, Integer> tasMaxIndex  = new Map<Id, Integer> ();
            Id lastTasId = null;
            String lastModel = '';
            String lastDep = '';
            // 20210814 ljh 管理编码 add start
            Set<Id> tadClearId = new Set<Id>();
            Map<Id, TransferApplyDetail__c> codMap = new Map<Id, TransferApplyDetail__c>();
            Map<String, List<TransferApplyDetail__c>> codeNewMap = new Map<String, List<TransferApplyDetail__c>>();
            Map<String, List<TransferApplyDetail__c>> fmnMap = new Map<String, List<TransferApplyDetail__c>>();
            List<Asset_EquipmentSet_Managment_Code__c> aesmUList = new List<Asset_EquipmentSet_Managment_Code__c>();
            Set<Id> xl0TadId = new Set<Id>();
            List<TransferApplyDetail__c> tadBMList = new List<TransferApplyDetail__c>();
            List<TransferApplyDetail__c> tadBMNewList = new List<TransferApplyDetail__c>();// 20211122 ljh SFDC-C8W3HW
            String xl0 = System.Label.xl0String;
            List<String> xl0List = xl0.split(';');
            // 20210814 ljh 管理编码 add end
            for(TransferApplySummaryBean tasBean:tasBeanList) {
                if(tasBean.wpinfoList[0].check){
                    TransferApplyDetail__c mainTad = (TransferApplyDetail__c) tasBean.wpinfoList[0].sobj;
                    if(!mainTad.Main_OneToOne__c && !mainTad.OneToOneAccessory__c) {
                        List<TransferApplyDetail__c> upsertTadSubList = new List<TransferApplyDetail__c>();
                        prepareDetails(tasBean.wpinfoList, '有效库存', intValueOf(mainTad.VF_TransferCount__c), upsertTadSubList, deleteTadList);
                        prepareDetails(tasBean.wpinfoList, '待废弃', intValueOf(mainTad.VF_TransferCount_Abandoned__c), upsertTadSubList, deleteTadList);
                        prepareDetails(tasBean.wpinfoList, '待修理', intValueOf(mainTad.VF_TransferCount_Repair__c), upsertTadSubList, deleteTadList);
                        prepareDetails(tasBean.wpinfoList, '丢失找回', intValueOf(mainTad.VF_TransferCount_Lost__c), upsertTadSubList, deleteTadList);
                        for(TransferApplyDetail__c tad: upsertTadSubList) {
                            if(tad.Cancel_Select__c) {
                                continue;
                            }
                            if(tad.Id == null) {
                                tad.TransferApply__c = parentId;
                                tad.TransferApplySummary__c = tasMap.get(tad.Fixture_Model_No__c).Id;
                            }
                            if(tad.IndexFromUniqueKey__c != null) {
                                if(!tasMaxIndex.containsKey(tad.TransferApplySummary__c)){
                                    tasMaxIndex.put(tad.TransferApplySummary__c, intValueOf(tad.IndexFromUniqueKey__c));
                                }
                                else if(tad.IndexFromUniqueKey__c > tasMaxIndex.get(tad.TransferApplySummary__c)) {
                                    tasMaxIndex.put(tad.TransferApplySummary__c, intValueOf(tad.IndexFromUniqueKey__c));
                                }
                            }
                            tad.FSD_SortInt__c = 1;
                            tad.Salesdepartment_After__c = mainTad.Salesdepartment_After__c;
                            lastTasId = tad.TransferApplySummary__c;
                            lastModel = tad.Fixture_Model_No__c;
                        }
                        upsertTadList.addAll(upsertTadSubList);
                    }
                    else {
                        tadIndex = 1;
                        lastModel = '';
                        lastDep = '';
                        for(WrapperInfo wf : tasBean.wpinfoList) {
                            TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sobj;
                            if(tad.TransferApplySummary__c == null) {
                                tad.TransferApplySummary__c = tasMap.get(mainTad.Fixture_Model_No__c + ':' + mainTad.SerialNumber__c).Id;
                            }
                            tad.TransferApply__c = parentId;
                            if(lastModel != tad.Fixture_Model_No__c) {
                                tadIndex = 1;
                                lastDep = tad.Salesdepartment_After__c;
                            }
                            if(tad.FSD_SortInt__c == null) {
                                tad.FSD_SortInt__c = 1;
                            }
                            tad.IndexFromUniqueKey__c = tadIndex++;
                            tad.Salesdepartment_After__c = lastDep;
                            upsertTadList.add(tad);
                            lastModel = tad.Fixture_Model_No__c;
                        }
                    }
                }
            }
            if(!upsertTadList.isEmpty()) {
                for(TransferApplyDetail__c tad:upsertTadList) {
                    if(tad.IndexFromUniqueKey__c == null) {
                        Integer max = tasMaxIndex.containsKey(tad.TransferApplySummary__c)?tasMaxIndex.get(tad.TransferApplySummary__c):0;
                        tad.IndexFromUniqueKey__c = max + 1;
                        tasMaxIndex.put(tad.TransferApplySummary__c, max + 1);
                    }
                    // 20210814 管理编码  start
                    // 调拨到非集中的 不修改编码
                    /*
                    20211122 ljh SFDC-C8W3HW 
                    编码规则总结 备品分类 只存在非集中到集中或者非集中到非集中
                    1.备品分类 改变重新编码
                    2.备品分类 不改变（非检测）本部改变 重新编码
                    3.备品分类 不改变（非检测）本部不改变  0系改变重新编码
                    4.备品分类 不改变（非检测）本部不改变  0系不改变(0系) 0本部 存放地改变 重新编码
                    --- 因为产品分类GISP 调拨 不发生改变 故0本部和7-11本部 存放地改变才编码 场景6不存在--- 
                    5.备品分类 不改变（非检测）本部不改变  0系不改变(!0系) 0本部 存放地改变/GISP改变 重新编码
                    6.备品分类 不改变（非检测）本部不改变  0系不改变(!0系) 1-6本部 GISP改变 重新编码
                    7.备品分类 不改变（非检测）本部不改变  0系不改变(!0系) 7-11本部 存放地改变/GISP改变 重新编码
                    */
                    if(tad.Loaner_accsessary__c == false && parentObj.RecordType.DeveloperName != 'CenterToOther'){
                        // 20211122 ljh SFDC-C8W3HW update start

                        /*if((String.isNotBlank(tad.Equipment_Type_After__c)  
                            && ((tad.Equipment_Type__c == '检测用备品' && tad.Equipment_Type_After__c != '检测用备品') || (tad.Equipment_Type__c != '检测用备品' && tad.Equipment_Type_After__c == '检测用备品'))
                         )
                            ||(String.isNotBlank(tad.Salesdepartment_After__c) && tad.Salesdepartment_After__c != tad.Salesdepartment__c)
                        ){*/
                            List<TransferApplyDetail__c> tadFsList = new List<TransferApplyDetail__c>();
                            if(fmnMap.containsKey(tad.Fixture_Model_No__c)){
                                tadFsList = fmnMap.get(tad.Fixture_Model_No__c);
                                tadFsList.add(tad);
                                fmnMap.put(tad.Fixture_Model_No__c,tadFsList);
                            }else{
                                tadFsList = new List<TransferApplyDetail__c>();
                                tadFsList.add(tad);
                                fmnMap.put(tad.Fixture_Model_No__c,tadFsList);
                            }
                        /*}else if(String.isNotBlank(tad.CodeKey__c)){
                            tadClearId.add(tad.Id);
                        }*/
                        // 20211122 ljh SFDC-C8W3HW update end
                    }
                    // 20210814 管理编码  start
                }
                // System.debug('zheli11:'+fmnMap.size());
                if(fmnMap.size() > 0){
                    List<Fixture_Set__c> fsList =  [SELECT Id, Name, Loaner_categoryII__c 
                     FROM Fixture_Set__c WHERE Name IN:fmnMap.keySet()];
                    for(Fixture_Set__c fs:fsList){
                        if(xl0List.contains(fs.Loaner_categoryII__c)){
                            for(TransferApplyDetail__c tadfs:fmnMap.get(fs.Name)){
                                xl0TadId.add(tadfs.Id);
                            }
                        }
                    }
                    for(String fmn:fmnMap.keySet()){
                        tadBMList.addAll(fmnMap.get(fmn));
                    }
                    // 20211122 ljh SFDC-C8W3HW  add start
                    // 重新设计需要编码的tadBMNewList
                    for(TransferApplyDetail__c tad:tadBMList){

                        String SalesdepartmentS = String.isNotBlank(tad.Salesdepartment_After__c)?tad.Salesdepartment_After__c:tad.Salesdepartment__c;
                        Integer SalesdepartmentI;
                        if(String.isNotBlank(SalesdepartmentS)){
                            String[] SalesdepartmentArr = SalesdepartmentS.split('\\.');
                            if(SalesdepartmentArr.size() > 0){
                                String Salesdepartment = SalesdepartmentArr[0];
                                SalesdepartmentI = Integer.valueOf(Salesdepartment);
                            }
                        }
                        // 1.备品分类 改变重新编码
                        if(String.isNotBlank(tad.Equipment_Type_After__c)   &&  tad.Equipment_Type__c != '检测用备品' && tad.Equipment_Type_After__c == '检测用备品'  
                        ){
                            tadBMNewList.add(tad);
                        // 2.备品分类 不改变（非检测）本部改变 重新编码
                        }else if( String.isNotBlank(tad.Salesdepartment_After__c) && tad.Salesdepartment_After__c != tad.Salesdepartment__c){
                            tadBMNewList.add(tad);
                        }else {
                            // 3.备品分类 不改变（非检测）本部不改变  0系改变重新编码
                            // 原来系列 第三位 是否是0
                            String IsCode0 = ''; 
                            if(String.isNotBlank(tad.EquipmentSet_Managment_Code__c)){
                                IsCode0 = tad.EquipmentSet_Managment_Code__c.substring(2,3);
                            }
                            Boolean IsCode0B  = xl0TadId.contains(tad.Id);
                            if(String.isNotBlank(IsCode0)&& ((IsCode0 == '0' && IsCode0B == false)||(IsCode0 != '0' && IsCode0B == true))
                                ){
                                tadBMNewList.add(tad);
                            }else{
                                // 4.备品分类 不改变（非检测）本部不改变  0系不改变(0系) 0本部 存放地改变 重新编码
                                // 存放地改变 暂时认为 只有备品中心调拨到备品中心才发生改变。  
                                if(IsCode0B){
                                    if(SalesdepartmentI != null && SalesdepartmentI == 0  && parentObj.RecordType.DeveloperName == 'CenterToCenter'){
                                        tadBMNewList.add(tad);
                                    }
                                }else{
                                    // 5\6\7.备品分类 不改变（非检测）本部不改变  0系不改变(！0系) 0本部和7-11本部和16本部 存放地改变 重新编码
                                    if(parentObj.RecordType.DeveloperName == 'CenterToCenter' && SalesdepartmentI != null && (SalesdepartmentI == 0 || (SalesdepartmentI > 6 && SalesdepartmentI < 12) || SalesdepartmentI == 16)){
                                        tadBMNewList.add(tad);
                                    }else if(String.isNotBlank(tad.CodeKey__c)){
                                        tadClearId.add(tad.Id);
                                    }
                                }
                            }
                            
                        } 
                    }
                    // 20211122 ljh SFDC-C8W3HW  add start end
                    // for(TransferApplyDetail__c tad:tadBMList){
                    for(TransferApplyDetail__c tad:tadBMNewList){
                        String SalesdepartmentS = String.isNotBlank(tad.Salesdepartment_After__c)?tad.Salesdepartment_After__c:tad.Salesdepartment__c;
                        if(String.isNotBlank(SalesdepartmentS)){
                            String[] SalesdepartmentArr = SalesdepartmentS.split('\\.');
                            if(SalesdepartmentArr.size() > 0){
                                String Salesdepartment = SalesdepartmentArr[0];
                                Integer SalesdepartmentI = Integer.valueOf(Salesdepartment);
                                if(SalesdepartmentI < 12 || SalesdepartmentI == 16){
                                    String key = '';
                                    // key一览明细本次  key1一览明细上次
                                    // 备品分类、本部、是否0系列、产品分类(GI/SP)、存放地
                                    List<TransferApplyDetail__c> tadTempList = new List<TransferApplyDetail__c>();
                                    // 1. 备品分类
                                    String EquipmentType = String.isNotBlank(tad.Equipment_Type_After__c)?tad.Equipment_Type_After__c:tad.Equipment_Type__c;
                                    String DestinationLocation = parentObj.RecordType.DeveloperName == 'CenterToAgency'?parentObj.From_Location__c:parentObj.Destination_location__c;
                                    if(EquipmentType == '检测用备品'){
                                        key += 'JC;'+locationMap.get(DestinationLocation);    
                                    }else{
                                        key += 'NJC;';
                                        //2.本部 
                                        key += Salesdepartment+';';
                                        //3.是否0系列
                                        // 原管理编码的第三可知是否是0系列
                                        // 0系列 还是看 型号
                                        // String IsCode0 = tad.EquipmentSet_Managment_Code__c.substring(2,3);
                                        Boolean IsCode0  = xl0TadId.contains(tad.Id);
                                        // System.debug('zheli~IsCode0:'+IsCode0+'~'+tad.EquipmentSet_Managment_Code__c+'~'+DestinationLocation);
                                        // if(IsCode0 == '0'){
                                        if(IsCode0){
                                            if(SalesdepartmentI == 0 || SalesdepartmentI == 10){
                                                key += '0;'+locationMap.get(DestinationLocation);
                                            }else {
                                                key += '0';
                                            }
                                        }else{
                                            key += 'N0;';
                                            if(SalesdepartmentI == 0 || SalesdepartmentI > 6 ){
                                                key += tad.Product_category__c+';'+locationMap.get(DestinationLocation);
                                            }else if(SalesdepartmentI < 7){
                                                key += tad.Product_category__c;
                                            }
                                        }
                                    }
                                    // System.debug('zheli~key:'+key);
                                    // key
                                    if(String.isBlank(tad.CodeKey__c) || (!String.isBlank(tad.CodeKey__c)&& !String.isBlank(key) && tad.CodeKey__c != key)){
                                        if(codeNewMap.containsKey(key)){
                                            tadTempList = codeNewMap.get(key);
                                            tadTempList.add(tad);
                                            codeNewMap.put(key,tadTempList);
                                        }else{
                                            tadTempList = new List<TransferApplyDetail__c>();
                                            tadTempList.add(tad);
                                            codeNewMap.put(key,tadTempList);
                                        }
                                    }
                                }else if(String.isNotBlank(tad.CodeKey__c)){
                                    // 本部大于等于 12清空管理编码
                                    tadClearId.add(tad.Id);
                                }
                            }
                        }
                    }
                }
                // 20210814 ljh 管理编码 add start
                if(codeNewMap.size() > 0){
                    List<Asset_EquipmentSet_Managment_Code__c> aemCodeList = [SELECT Id, key__c, code__c,   
                             LastNo__c, keyName__c, isSpecial__c, MaxLastNo__c FROM Asset_EquipmentSet_Managment_Code__c
                            WHERE key__c IN :codeNewMap.keySet() for update];
                    for(Asset_EquipmentSet_Managment_Code__c aem:aemCodeList){
                        Integer code = Integer.valueOf(aem.LastNo__c);
                        String codeManange;
                        // String codeString = 
                        if(aem.LastNo__c == aem.MaxLastNo__c){
                            // 无法编码 抛出异常
                            throw new ControllerUtil.myException('编码已满，暂时无法编码。');
                        }else if(Integer.valueOf(aem.MaxLastNo__c)-Integer.valueOf(aem.LastNo__c) < codeNewMap.get(aem.key__c).size()){
                            // 不足 抛出异常
                            throw new ControllerUtil.myException('编码内存不足，暂时无法编码。');
                        }else{
                            //正常编码
                            for(TransferApplyDetail__c tad2:codeNewMap.get(aem.key__c)){
                               if(code == 19999 || code == 29999 || code == 39999
                                   || code == 39999 || code == 49999 || code == 59999
                                    ){
                                    code = code + 2;
                                }else{
                                    code = code + 1;
                                }
                                if(aem.isSpecial__c){
                                    codeManange = aem.code__c + String.valueOf(code).leftpad(5, '0').subString(0,1)+'-'+String.valueOf(code).leftpad(5, '0').substring(1,5);
                                }else{
                                    codeManange = aem.code__c +'-'+String.valueOf(code).leftpad(5, '0').substring(1,5);
                                }
                                TransferApplyDetail__c tad3 = new TransferApplyDetail__c();
                                tad3.Asset__c = tad2.Asset__c;
                                tad3.EquipmentSet_Managment_Code_After__c= codeManange;
                                tad3.CodeKey__c = aem.key__c;
                                codMap.put(tad2.Asset__c,tad3); 
                            }
                            Asset_EquipmentSet_Managment_Code__c aesm = new Asset_EquipmentSet_Managment_Code__c();
                            aesm.Id = aem.Id;
                            aesm.LastNo__c = code;
                            aesm.EquipmentSet_Managment_Code__c = codeManange;
                            aesm.Edit_staff__c = UserInfo.getUserId();
                            aesmUList.add(aesm);
                        }
                    }
                }
                // System.debug('zheli:'+tadClearId+'~'+codMap);
                for(TransferApplyDetail__c utad:upsertTadList){
                    // System.debug('zheli:'+utad.Id);
                    if(tadClearId.contains(utad.Id)){
                       utad.EquipmentSet_Managment_Code_After__c = ''; //有值才拷贝到保有设备
                       utad.CodeKey__c = '';
                    }
                    if(codMap.containsKey(utad.Asset__c)){
                       utad.EquipmentSet_Managment_Code_After__c = codMap.get(utad.Asset__c).EquipmentSet_Managment_Code_After__c; 
                       utad.CodeKey__c = codMap.get(utad.Asset__c).CodeKey__c; 
                    }
                    // System.debug('zheli22:'+utad);
                }
                // 20210814 ljh 管理编码 add end
                //20210818 ljh 管理编码 update start
                upsert upsertTadList;
                // upsert upsertTadMList;
                update aesmUList; 
                //20210818 ljh 管理编码 update end
            }
            if(!deleteTadList.isEmpty()) {
                delete deleteTadList;
            }
            // 追加批准状态处理
            updateAddApproval();
            done = true;
            parentObj = getParentObj(false);
        }
        catch (Exception ex) {
            System.debug(ex.getStackTraceString());
            ApexPages.addMessages(ex);
            Database.rollback(sp);
            done = false;
        }
        return done;
    }
    /**
    @description 单独调拨的附属品，根据画面上输入，重新整理出更新和删除的明细列表
    @param tasBean 画面上一行
    @param transferType 调拨分类：空，待废弃，待修理，丢失找回
    @param count 实际需要的数量
    @param upsertTadList 需要更新或新建的明细
    @param deleteTadList 需要删除的明细
    */
    private void prepareDetails(List<WrapperInfo> wpinfoList, String transferType, Integer count,
                                List<TransferApplyDetail__c> upsertTadList, List<TransferApplyDetail__c> deleteTadList ) {
        List<Integer> removeIndexes = new List<Integer> ();
        for(Integer i = 0; i < wpinfoList.size(); i++) {
            TransferApplyDetail__c tad = (TransferApplyDetail__c) wpinfoList[i].sobj;
            if(tad.TransferType__c == transferType) {
                if(count > 0) {
                    upsertTadList.add(tad);
                    count--;
                }
                // 现有的明细数超过实际需要的数量，则去掉多余的
                else {
                    removeIndexes.add(i);
                }
            }
        }
        for(Integer i = removeIndexes.size() - 1; i >= 0 && wpinfoList.size() > 1; i--) {
            TransferApplyDetail__c tad = (TransferApplyDetail__c) wpinfoList[removeIndexes[i]].sobj;
            if(tad.Id != null) {
                // 批准的要做取消
                if(tad.Approved_F__c) {
                    tad.Cancel_Select__c = true;
                    tad.Cancel_Reason__c = '主动取消';
                    upsertTadList.add(tad);
                }
                else {
                    // 未批准的直接删除
                    deleteTadList.add(tad);
                }
            }
            wpinfoList.remove(removeIndexes[i]);
        }
        // 实际需要的数量超过现有的，则做追加
        if(count > 0) {
            TransferApplyDetail__c mainTad = (TransferApplyDetail__c) wpinfoList[0].sobj;
            for(Integer i = 0; i < count;i++) {
                TransferApplyDetail__c tad = new TransferApplyDetail__c();
                tad.TransferType__c = transferType;
                for(String field: FIELD_NAME_MAP.keySet()){
                    tad.put(field, mainTad.get(field));
                }
                upsertTadList.add(tad);
                WrapperInfo wf = new WrapperInfo(tad, myComponentController);
                wpinfoList.add(wf);
            }
        }
    }

    /**
    @description 检查待保存的一览，只对未保存和未审批的做检查
    @param beanList 待保存的beanList
    @return 错误信息列表
    */
    private List<String> checkDetails(List<TransferApplySummaryBean> beanList) {
        List<String> errorList = new List<String>();
        Map<Id, Integer> assetCntMap = new Map<Id, Integer>(); // 非一对一附属品的数量统计，保有设备Id->调拨数量
        Map<Id, Integer> assetAbanCntMap = new Map<Id, Integer>(); // 非一对一附属品待废弃数统计，保有设备Id->待废弃调拨数量
        Map<Id, Integer> assetRepairCntMap = new Map<Id, Integer>(); // 非一对一附属品待废弃数统计，保有设备Id->待修理调拨数量
        Map<Id, Integer> assetLostCntMap = new Map<Id, Integer>(); // 非一对一附属品丢失找回数统计，保有设备Id->丢失找回调拨数量
        Map<String, Integer> linkCntMap = new Map<String, Integer>(); // 一对一附属品link数统计，主体Id:附属品Id->调拨数量
        Map<String, Integer> linkAbandonCntMap = new Map<String, Integer>(); // 一对一附属品link数统计，主体Id:附属品Id->待废弃调拨数量
        Map<String, Integer> linkRepairCntMap = new Map<String, Integer>(); // 一对一附属品link数统计，主体Id:附属品Id->待修理调拨数量
        Map<String, String> assetModelMap = new Map<String, String>(); // assetId->型号 用于错误提醒
        for(TransferApplySummaryBean tasBean:beanList) {
            
            TransferApplyDetail__c mainTad = (TransferApplyDetail__c) tasBean.wpinfoList[0].sObj;
            if(mainTad.Main_OneToOne__c) {
                if(mainTad.Approved_F__c) {
                    continue;
                }
                if(intValueOf(mainTad.VF_TransferCount__c) > 0) {
                    Integer cnt = 0;
                    if(assetCntMap.containsKey(mainTad.Asset__c)) {
                        cnt = assetCntMap.get(mainTad.Asset__c);
                    }
                    assetCntMap.put(mainTad.Asset__c, cnt + 1);
                }
                for(WrapperInfo wf:tasBean.wpinfoList) {
                    TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sObj;
                    assetModelMap.put(tad.Asset__c, tad.Fixture_Model_No__c);
                    // bean里，wrapinfo和明细一一对应
                    if(mainTad.Main_OneToOne__c && tad.OnetoOneAccessory__c) {
                        String key = mainTad.Asset__c + ':' + tad.Asset__c;
                        Integer cnt = 0;
                        switch on tad.TransferType__c {
                            when '待废弃' {
                                if(linkAbandonCntMap.containsKey(key)) {
                                    cnt = linkAbandonCntMap.get(key);
                                }
                                linkAbandonCntMap.put(key, cnt + 1);
                            }
                            when '待修理' {
                                if(linkRepairCntMap.containsKey(key)) {
                                    cnt = linkRepairCntMap.get(key);
                                }
                                linkRepairCntMap.put(key, cnt + 1);
                            }
                            when else {
                                if(linkCntMap.containsKey(key)) {
                                    cnt = linkCntMap.get(key);
                                }
                                linkCntMap.put(key, cnt + 1);
                            }
                        }
                    }
                }
            }

            if(intValueOf(mainTad.VF_TransferCount__c)
                + intValueOf(mainTad.VF_TransferCount_Abandoned__c)
                + intValueOf(mainTad.VF_TransferCount_Repair__c)
                + intValueOf(mainTad.VF_TransferCount_Lost__c) == 0) {
                errorList.add(mainTad.Fixture_Model_No__c + '：调拨总数量不可为0!');
            }
            else if(!mainTad.Main_OneToOne__c) {
                Integer cnt = intValueOf(mainTad.VF_TransferCount__c);
                Integer abandon = intValueOf(mainTad.VF_TransferCount_Abandoned__c);
                Integer repair = intValueOf(mainTad.VF_TransferCount_Repair__c);
                Integer lost = intValueOf(mainTad.VF_TransferCount_Lost__c);
                // 用 调拨数-已审批数 来和现有可调拨数做比较
                for(WrapperInfo wf:tasBean.wpinfoList) {
                    TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sObj;
                    if(tad.Id != null && tad.Approved_F__c) {
                        switch on tad.TransferType__c {
                            when '待废弃' {
                                abandon--;
                            }
                            when '待修理' {
                                repair--;
                            }
                            when '丢失找回' {
                                lost--;
                            }
                            when else {
                                cnt--;
                            }
                        }
                    }
                }
                if(cnt > 0) {
                    assetCntMap.put(mainTad.Asset__c, cnt);
                }
                if(abandon > 0) {
                    assetAbanCntMap.put(mainTad.Asset__c, abandon);
                }
                if(repair > 0) {
                    assetRepairCntMap.put(mainTad.Asset__c, repair);
                }
                if(lost > 0) {
                    assetLostCntMap.put(mainTad.Asset__c, lost);
                }
            }
        }

        Map<Id, Asset> assetMap = new Map<Id, Asset>();
        Map<String, Fixture_OneToOne_Link__c> linkMap = new Map<String, Fixture_OneToOne_Link__c>();
        // 保有设备检查
        if(assetCntMap.size() + assetAbanCntMap.size() + assetRepairCntMap.size() + assetLostCntMap.size() > 0) {
            Set<Id> assIdSet = assetCntMap.keySet().clone();
            assIdSet.addAll(assetAbanCntMap.keySet());
            assIdSet.addAll(assetRepairCntMap.keySet());
            assIdSet.addAll(assetLostCntMap.keySet());
            String assSql = 'SELECT Id'
                          + ', Ji_Zhong_Guan_Li_Ku_Cun__c'
                          + ', Fixture_Model_No_F__c'
                          + ', TransferableAbandon_F__c'
                          + ', TransferableRepair_F__c'
                          + ', TransferableLost_F__c'
                          + ' FROM Asset ';
            assSql += this.makeSoql('','');
            assSql += ' and Id IN :assIdSet FOR UPDATE';
            assetMap = new Map<Id, Asset>((List<Asset>)Database.query(assSql));
            for(Id assetId: assIdSet) {
                if(!assetMap.containsKey(assetId)) {
                    errorList.add(assetId + '不存在或不可调拨!');
                    continue;
                }
                if(assetCntMap.containsKey(assetId)){
                    if(assetCntMap.get(assetId) > assetMap.get(assetId).Ji_Zhong_Guan_Li_Ku_Cun__c){
                        //errorList.add(assetMap.get(assetId).Fixture_Model_No_F__c + '：数量超过集中管理库存!');
                        errorList.add(assetMap.get(assetId).Fixture_Model_No_F__c + '：调拨数量不能超过有效库存!');
                    }
                }
                if(assetAbanCntMap.containsKey(assetId)){
                    if(assetAbanCntMap.get(assetId) > assetMap.get(assetId).TransferableAbandon_F__c){
                        errorList.add(assetMap.get(assetId).Fixture_Model_No_F__c + '：数量超过待废弃数(实物)!');
                    }
                }
                if(assetRepairCntMap.containsKey(assetId)){
                    if(assetRepairCntMap.get(assetId) > assetMap.get(assetId).TransferableRepair_F__c){
                        errorList.add(assetMap.get(assetId).Fixture_Model_No_F__c + '：数量超过待修理数!');
                    }
                }
                if(assetLostCntMap.containsKey(assetId)){
                    if(assetLostCntMap.get(assetId) > assetMap.get(assetId).TransferableLost_F__c){
                        errorList.add(assetMap.get(assetId).Fixture_Model_No_F__c + '：数量超过丢失盘亏数!');
                    }
                }
            }
        }
        // link里的各个数量检查
        if(linkCntMap.size() + linkAbandonCntMap.size() + linkRepairCntMap.size() > 0) {
            Set<String> linkIdSet = linkCntMap.keySet().clone();
            linkIdSet.addAll(linkAbandonCntMap.keySet());
            linkIdSet.addAll(linkRepairCntMap.keySet());
            String linkSql = 'SELECT Quantity__c, Abandoned_RealThing__c, CountForRepair__c,  Main_Asset__c'
                           + ', In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c, Accessory_Asset__c FROM Fixture_OneToOne_Link__c WHERE ';
            for(String key: linkIdSet) {
                List<String> ids = key.split(':');
                linkSql += '(Main_Asset__c = \'' + ids[0] + '\' AND Accessory_Asset__c = \'' + ids[1] + '\') OR';
            }
            linkSql = linkSql.removeEnd('OR');
            linkSql += ' FOR UPDATE';
            List<Fixture_OneToOne_Link__c> links = Database.query(linkSql);
            for(Fixture_OneToOne_Link__c link:links) {
                String key = link.Main_Asset__c + ':' + link.Accessory_Asset__c;
                linkMap.put(key, link);
            }
            for(String key:linkCntMap.keySet()) {
                List<String> ids = key.split(':');
                if(!linkMap.containsKey(key)) {
                    errorList.add(assetModelMap.get(ids[0])+':'+assetModelMap.get(ids[1]) + ' link不存在!');
                }
                else if(linkCntMap.get(key) > linkMap.get(key).In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c) {
                    errorList.add(assetModelMap.get(ids[0])+':'+assetModelMap.get(ids[1]) + ' 调拨数量超过一对一的有效库存!');
                }
                else if(linkAbandonCntMap.get(key) > linkMap.get(key).Abandoned_RealThing__c) {
                    errorList.add(assetModelMap.get(ids[0])+':'+assetModelMap.get(ids[1]) + ' 待废弃调拨数超过一对一的待废弃数!');
                }
                else if(linkRepairCntMap.get(key) > linkMap.get(key).CountForRepair__c) {
                    errorList.add(assetModelMap.get(ids[0])+':'+assetModelMap.get(ids[1]) + ' 待修理调拨数超过一对一的待修理数!');
                }
            }
        }

        return errorList;
    }
    private void removeUncheckedTasBean() {
        for(Integer i = tasBeanList.size() - 1; i >= 0; i--) {
            if(!tasBeanList[i].wpinfoList[0].check) {
                tasBeanList.remove(i);
            }
        }
    }
    private Integer intValueOf(Decimal d) {
        if(d == null) {
            return 0;
        }
        return Integer.valueOf(d);
    }
    private void updateAddApproval(){
        List<AggregateResult> add_Approvals = [
            Select Count(Id) cnt, SUM(Draft_Appended__c) Draft_Appended__c
            From TransferApplyDetail__c
           Where TransferApply__c = :parentId
             AND Cancel_Select__c = false
             AND ApplyPersonAppended_F__c = true
           Group by TransferApply__c
        ];
        Integer Draft_Appended = 0;
        Integer add_ApprovalCount = 0;
        if (!add_Approvals.isEmpty()) {
            Draft_Appended = add_Approvals[0].get('Draft_Appended__c') == null ? 0 : Integer.valueOf(add_Approvals[0].get('Draft_Appended__c'));
            add_ApprovalCount = add_Approvals[0].get('cnt') == null ? 0 : Integer.valueOf(add_Approvals[0].get('cnt'));
        }

        List<TransferApply__c> taList = new List<TransferApply__c>();

        // 有草案中的追加附属品并且申请书的状态不是草案中，&& 不是分配代替品 的需要改变状态为草案中
        if (Draft_Appended > 0 && parentObj.Add_Approval_Status__c != '草案中' && parentObj.Request_approval_time__c != null) {
            parentObj.Add_Approval_Status__c = '草案中';
            taList.add(parentObj);
        }
        // 申请书单位已经没有草案中的附属品
        else if (Draft_Appended == 0) {
            //没有追加附属品状态为空
            if (add_ApprovalCount == 0 && String.isNotBlank(parentObj.Add_Approval_Status__c)) {
                parentObj.Add_Approval_Status__c = '';
            }
            // 有追加附属品状态为草案中
            else if (add_ApprovalCount > 0  && parentObj.Add_Approval_Status__c != '草案中' && parentObj.Add_Approval_Status__c != '申请中') {
                parentObj.Add_Approval_Status__c = FixtureUtil.raStatusMap.get(FixtureUtil.RaStatus.Yi_Pi_Zhun.ordinal());
            }
            taList.add(parentObj);
        }
        if (!taList.isEmpty()) {
            FixtureUtil.withoutUpdate(taList);
        }
    }

    public PageReference turnback() {
        PageReference ret = null;
        if (!String.isBlank(this.parentId)) {
            ret = new PageReference('/' + this.parentId);
        }
        return ret;
    }

    private String makeSoql(String keyword, String assetnumber) {
        // 検索条件
        String dateToday = String.valueOf(Date.today());

        // 先检出主体和集中管理数大于0的
        String soql ='';
        soql += 'where Asset_Owner__c = \'Olympus\' AND ' + FixtureUtil.getAssetSoqlBase();
        soql += '  and RecordTypeId = \'01210000000kOPR\'';
        soql += '  and Quantity > 0';
        soql += '  and Delete_Flag__c = False ';
        soql += '  and Equipment_Type__c != \'检测用备品\'';
        soql += '  and Freeze_sign__c = False';
        soql += '  and Internal_asset_location__c = \'' + parentObj.From_Location__c + '\'';
        soql += '  and Asset_loaner_category__c != \'耗材\'';
        soql += ' and Salesdepartment__c != \'13.CTEC教育本部\'';
        soql += ' and Salesdepartment__c != \'14.医疗人才教育培训本部\'';
        soql += ' and Salesdepartment__c != \'15.医疗法规事务和质量管理本部\'';
        if(parentObj.RecordType.DeveloperName == 'InsideCenter') {
            soql += ' and Manage_type__c = \'个体管理\' and You_Xiao_Ku_Cun__c > 0 and Loaner_accsessary__c = false';
        }
        else {
            soql += '  and (Ji_Zhong_Guan_Li_Ku_Cun__c > 0 or TransferableAbandon_F__c > 0';
            if(parentObj.RecordType.DeveloperName == 'AgencyToCenter') {
                soql += ' or TransferableLost_F__c > 0 or TransferableRepair_F__c > 0 )';
            }
            else {
                //20210507 ljh update 1834 start
                //soql += ') and ((Loaner_accsessary__c = false and Main_OneToOne__c = true) or (Loaner_accsessary__c = true and Main_OneToOne__c = false)) ';
                soql += ') and ((Loaner_accsessary__c = false and Main_OneToOne__c = true) or (Loaner_accsessary__c = true and Main_OneToOne__c = false) or (Loaner_accsessary__c = false and Main_OneToOne__c = false)) ';
                //20210507 ljh update 1834 end
            }
            soql +=' and Fixture_OneToOne_Link__c = null'; // 不是一对一个体附属品
        }

        if (!String.isBlank(keyword)) {
            String[] vals = keyword.split(' ');
             soql += ' and (';
             String fmodelno = '';
            for (String v : vals) {
                v = String.escapeSingleQuotes(v.replace('%', '\\%').replace('*', '%'));
                fmodelno += ' Product2.Fixture_Model_No_T__c like \'' + v + '\' ';
                fmodelno += ' or Product2.Name like \'' + v + '\' ';
                fmodelno += 'or';
            }
            fmodelno = fmodelno.removeEnd('or');
            soql += fmodelno + ' )';
        }

        if (!String.isBlank(assetnumber)) {
            String num = String.escapeSingleQuotes(assetnumber.replace('%', '\\%').replace('*', '%'));
            soql += ' and Internal_Asset_number_key__c like\'' + num + '\' ';
        }
        return soql;
    }

    public override void setViewList(List<sObject> queryList) {
        List<TransferApplySummaryBean> oldTasBeanList = new List<TransferApplySummaryBean>(); // 存一下勾选的保有设备
        for(TransferApplySummaryBean tasBean:tasBeanList) {
            if(tasBean.wpinfoList[0].check) {
                oldTasBeanList.add(tasBean);
            }
        }
        tasBeanList.clear();
        Set<Id> hideAssetIdSet = new Set<Id>(); // 个体管理的保有设备如果已经在明细中，则检索时不再显示
        Id lastAssetId = null;
        Id lastTasId = null;
        // 自己的数据打勾，被检索出来的数据不打勾
        if (selectedData.size() > 0) {
            List<TransferApplyDetail__c> otoTadList = new List<TransferApplyDetail__c>();
            for (Integer i = 0; i < selectedData.size(); i++) {
                TransferApplyDetail__c tad = (TransferApplyDetail__c) selectedData[i];
                // 下架前打开画面时，明细里的调拨前字段要取最新
                if(tad.DeliverySlip__c == null ) {
                    if(tad.OnetoOneAccessory__c) {
                        // 一对一的各数要从link取
                        tad.VF_You_Xiao_Ku_Cun__c = tad.Fixture_OneToOne_Link__r.In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c;
                        tad.VF_CountForRepair__c = tad.Fixture_OneToOne_Link__r.CountForRepair__c;
                        tad.VF_Abandoned_RealThing__c = tad.Fixture_OneToOne_Link__r.Abandoned_RealThing__c;
                        tad.VF_Abandoned_Inventory__c = 0;
                    }
                    else {
                        // 其它的直接从保有设备取
                        Asset ass = tad.Asset__r;
                        tad.VF_Abandoned_RealThing__c = ass.TransferableAbandon_F__c;
                        tad.VF_You_Xiao_Ku_Cun__c     = ass.Ji_Zhong_Guan_Li_Ku_Cun__c;
                        tad.VF_CountForRepair__c      = ass.TransferableRepair_F__c;
                        tad.VF_Abandoned_Inventory__c = ass.TransferableLost_F__c;
                    }
                }

                if(tad.Manage_type__c == '个体管理') {
                    hideAssetIdSet.add(tad.Asset__c);
                }
                else if(!tad.OnetoOneAccessory__c) { // 数量管理非一对一附属品，如果申请中已存在则不再在检索结果中显示
                    hideAssetIdSet.add(tad.Asset__c);
                }
                WrapperInfo wf = new WrapperInfo(tad, myComponentController);
                wf.check = true;
                wf.oldCheck = true;
                // 对已保存的明细，一对一附属品和主体装到一个bean，非一对一的按保有设备装到一个bean里
                if(tad.TransferApplySummary__c != lastTasId) {
                    // 一览变化时，新建一个bean
                    TransferApplySummaryBean tasBean = new TransferApplySummaryBean();
                    tasBean.tas.Id = tad.TransferApplySummary__c;
                    tasBeanList.add(tasBean);
                    wf.canEdit = true;
                }
                else if(tad.Asset__c != lastAssetId && !tad.OnetoOneAccessory__c) {
                    // 同一个一览内，保有设备变化时且不是一对一附属品，新建一个bean
                    TransferApplySummaryBean tasBean = new TransferApplySummaryBean();
                    tasBean.tas.Id = tad.TransferApplySummary__c;
                    tasBeanList.add(tasBean);
                    wf.canEdit = true;
                }
                else {
                    wf.check = false;
                    wf.oldCheck = false;
                    wf.canEdit = true;
                }
                lastAssetId = tad.Asset__c;
                lastTasId = tad.TransferApplySummary__c;
                tasBeanList[tasBeanList.size()-1].wpinfoList.add(wf);
            }
        }
        for(TransferApplySummaryBean tasBean: oldTasBeanList) {
            TransferApplyDetail__c tad = (TransferApplyDetail__c) tasBean.wpinfoList[0].sObj;
            if(!hideAssetIdSet.contains(tad.Asset__c) && !tad.OnetoOneAccessory__c) {
                // 打了勾但不是已保存的明细，再次显示
                tasBeanList.add(tasBean);
                hideAssetIdSet.add(tad.Asset__c);
            }
        }

        Map<Id, TransferApplySummaryBean> mainTasBeanMap = new Map<Id, TransferApplySummaryBean> (); //主体Id->一览bean
        Map<Id, Asset> availableAsset = new Map<Id, Asset> ([SELECT Id FROM Asset WHERE Id IN:queryList]); // 确认哪些设备有访问权限
        for (Integer i = 0; i < queryList.size(); i++) {
            Asset ass = (Asset)queryList[i];
            if(hideAssetIdSet.contains(ass.Id) || !availableAsset.containsKey(ass.Id)) {
                // 个体管理保有设备如果已出现在明细中，则不需要再显示
                // 没权限查看的设备也要跳过
                continue;
            }
            TransferApplySummaryBean tasBean = new TransferApplySummaryBean();

            if(ass.Main_OneToOne__c) {
                mainTasBeanMap.put(ass.Id, tasBean);
            }
            TransferApplyDetail__c tad = new TransferApplyDetail__c();
            for(String field:FIELD_NAME_MAP.keySet()) {
                tad.put(field, ass.get(FIELD_NAME_MAP.get(field)));
                //if(ass.Loaner_accsessary__c){
                //    tad.VF_You_Xiao_Ku_Cun__c = intValueOf(ass.Ji_Zhong_Guan_Li_Ku_Cun__c);
                //}
                //else {
                //    tad.VF_You_Xiao_Ku_Cun__c = ass.You_Xiao_Ku_Cun__c;
                //}
            } 
            if(tad.Manage_type__c == '个体管理') {
                if(tad.VF_CountForRepair__c > 0) {
                    tad.TransferType__c = '待修理';
                }
                else if(tad.VF_Abandoned_RealThing__c > 0 ) {
                    tad.TransferType__c = '待废弃';
                }
                else if(tad.VF_Abandoned_Inventory__c > 0) {
                    tad.TransferType__c = '丢失找回';
                }
                else {
                    tad.TransferType__c = '有效库存';
                }
            }
            WrapperInfo wf= new WrapperInfo(tad, myComponentController);
            tasBean.wpinfoList.add(wf);
            tasBeanList.add(tasBean);
        }
        if(parentObj.RecordType.DeveloperName != 'InsideCenter') {
            addOnetoOneAccessories(mainTasBeanMap);
        }
        myComponentController.page = 1;
        refreshViewList(tasBeanList);
    }

    public void saveAndSearch() {
        if(save()) {
            searchOpp();
        }
    }

    public void saveAndSearchNext() {
        if(save()) {
            searchNextCtrl();
        }
    }
    public void saveAndsearchPrevious() {
        if(save()) {
            searchPreviousCtrl();
        }
    }
    public void saveAndsearchGoPage() {
        if(save()) {
            searchGoPageCtrl();
        }
    }
    public void searchNextCtrl() {
        myComponentController.page = Math.min(myComponentController.maxPage, myComponentController.page + 1);
        refreshViewList(tasBeanList);
    }
    public void searchPreviousCtrl() {
        myComponentController.page = Math.max(1, myComponentController.page - 1);
        refreshViewList(tasBeanList);
    }
    public void searchGoPageCtrl() {
        myComponentController.page = myComponentController.goPageInt;
        refreshViewList(tasBeanList);
    }
    /**
    @description 显示beanlist
    @param beanList 要放到viewlist里的beanList
    @param k 页号
    */
    private void refreshViewList(List<TransferApplySummaryBean> beanList) {
        viewList = new List<WrapperInfo>();
        if(beanList.isEmpty()) {
            myComponentController.isDisplayPaging = false;
            return ;
        }
        Integer k = myComponentController.page;
        myComponentController.maxPage = (beanList.size() / SHOW_SIZE) + (Math.mod(beanList.size(), SHOW_SIZE) > 0 ? 1 : 0);
        myComponentController.isDisplayPaging = myComponentController.maxPage > 0;
        myComponentController.hasPrevious = (k > 1 && k <= myComponentController.maxPage);
        myComponentController.hasNext = (k < myComponentController.maxPage && myComponentController.maxPage > 0);

        Integer a = (k - 1) * Integer.valueOf(SHOW_SIZE);
        Integer b = Math.min(k * Integer.valueOf(SHOW_SIZE), beanList.size());
        Integer lineNo = 0;
        for (Integer i = a ; i < b ; i++) {
            TransferApplySummaryBean tasBean = beanList[i];
            Id lastAssetId = null;
            Id lastTasId = null;
            TransferApplyDetail__c lastTad = null;
            Integer index = 1;
            for(WrapperInfo wf: tasBean.wpinfoList) {
                TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sObj;
                if(tad.Asset__c != lastAssetId || tad.TransferApplySummary__c != lastTasId) {
                    if(tad.Id == null && tad.Manage_type__c == '数量管理' && !tad.OnetoOneAccessory__c) {
                        // 未保存的数量管理附属品
                        if(!wf.check) {
                            tad.VF_TransferCount__c = null;
                            tad.VF_TransferCount_Abandoned__c = null;
                            tad.VF_TransferCount_Repair__c = null;
                            tad.VF_TransferCount_Lost__c = null;
                            if(raAssetCountMap.containsKey(tad.Asset__c)) {
                                tad.VF_TransferCount__c = raAssetCountMap.get(tad.Asset__c).get('有效库存');
                                tad.VF_TransferCount_Abandoned__c = raAssetCountMap.get(tad.Asset__c).get('待废弃');
                                tad.VF_TransferCount_Repair__c = raAssetCountMap.get(tad.Asset__c).get('待修理');
                                tad.VF_TransferCount_Lost__c = raAssetCountMap.get(tad.Asset__c).get('丢失找回');
                            }
                        }
                    }
                    else {
                        // 已保存的明细
                        tad.VF_TransferCount__c = 0;
                        tad.VF_TransferCount_Abandoned__c = 0;
                        tad.VF_TransferCount_Repair__c = 0;
                        tad.VF_TransferCount_Lost__c = 0;
                        switch on tad.TransferType__c {
                            when '待废弃' {
                                tad.VF_TransferCount_Abandoned__c = 1;
                            }
                            when '待修理' {
                                tad.VF_TransferCount_Repair__c = 1;
                            }
                            when '丢失找回' {
                                tad.VF_TransferCount_Lost__c = 1;
                            }
                            when else {
                                tad.VF_TransferCount__c = 1;
                            }
                        }
                    }
                    lastTad = tad;
                    wf.lineNo = lineNo++;
                    viewList.add(wf);
                }
                else {
                    switch on tad.TransferType__c {
                        when '待废弃' {
                            lastTad.VF_TransferCount_Abandoned__c += 1;
                        }
                        when '待修理' {
                            lastTad.VF_TransferCount_Repair__c += 1;
                        }
                        when '丢失找回' {
                            lastTad.VF_TransferCount_Lost__c += 1;
                        }
                        when else {
                            lastTad.VF_TransferCount__c += 1;
                        }
                    }
                }
                lastAssetId = tad.Asset__c;
                lastTasId = tad.TransferApplySummary__c;
            }
        }
    }

    /**
    @description 主体关联的一对一附属品，并匹配备品配套和配套明细
    @param mainTasBeanMap 主体对应的一览bean
    */
    private void addOnetoOneAccessories(Map<Id, TransferApplySummaryBean> mainTasBeanMap) {
        if(mainTasBeanMap.isEmpty()) {
            return ;
        }
        // 获取link
        List<Fixture_OneToOne_Link__c> allLinks = [
                SELECT Id
                     , Main_Asset__c
                     , Main_Asset__r.Fixture_Model_No_F__c
                     , Accessory_Asset__c
                     , Accessory_Asset__r.Fixture_Model_No_F__c
                     , Quantity__c
                     , In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c
                     , Abandoned_RealThing__c
                     , CountForRepair__c
                  FROM Fixture_OneToOne_Link__c
                 WHERE Main_Asset__c IN: mainTasBeanMap.keySet()
            ];
        Map<Id, List<Fixture_OneToOne_Link__c>> main2LinksMap = new Map<Id, List<Fixture_OneToOne_Link__c>>(); //主体->所有link
        Set<Id> acsIdSet = new Set<Id>(); // 附属品保有设备Id
        Set<String> productModelSet = new Set<String>(); // 产品名称

        for(Fixture_OneToOne_Link__c link:allLinks) {
            if(!main2LinksMap.containsKey(link.Main_Asset__c)){
                main2LinksMap.put(link.Main_Asset__c, new List<Fixture_OneToOne_Link__c>());
            }
            List<Fixture_OneToOne_Link__c> templinks = main2LinksMap.get(link.Main_Asset__c);
            templinks.add(link);
            acsIdSet.add(link.Accessory_Asset__c);
            productModelSet.add(link.Main_Asset__r.Fixture_Model_No_F__c);
            productModelSet.add(link.Accessory_Asset__r.Fixture_Model_No_F__c);
        }
        if(acsIdSet.isEmpty()) {
            return;
        }
        // 通过产品找配套明细，并按配套分组
        List<Fixture_Set_Detail__c> fsdList = [SELECT Id
                                                    , Product2__c
                                                    , Fixture_Set__c
                                                    , Is_Body__c
                                                    , Fixture_Model_No_F__c
                                                    , SortInt__c
                                                 FROM Fixture_Set_Detail__c
                                                WHERE Fixture_Model_No_F__c IN: productModelSet
                                             ORDER BY Fixture_Set__r.LastModifiedDate DESC
                                            ];
        Map<Id, Map<String, Fixture_Set_Detail__c>> fsMap = new Map<Id, Map<String, Fixture_Set_Detail__c>>(); // 配套Id->产品型号->配套明细
        Set<String> bodyProModelSet = new Set<String>();
        for(Fixture_Set_Detail__c fsd:fsdList) {
            if(!fsMap.containsKey(fsd.Fixture_Set__c)){
                fsMap.put(fsd.Fixture_Set__c, new Map<String, Fixture_Set_Detail__c>());
            }
            Map<String, Fixture_Set_Detail__c> pro2FsdMap = fsMap.get(fsd.Fixture_Set__c);
            // 如果一个主体产品出现在多个备品配套中，那么只用最新的配套
            // fsMap变量中，旧配套中会少主体的产品Id，所以不会和一览匹配上
            if(fsd.Is_Body__c && bodyProModelSet.contains(fsd.Fixture_Model_No_F__c)) {
                continue;
            }
            pro2FsdMap.put(fsd.Fixture_Model_No_F__c, fsd);
            if(fsd.Is_Body__c) {
                bodyProModelSet.add(fsd.Fixture_Model_No_F__c);
            }

        }
        // 获取所有一对一附属品asset
        String acsSql = 'SELECT '+ String.join(FIELD_NAME_MAP.values(), ', ') + ' FROM Asset WHERE Id IN :acsIdSet';

        Map<Id, Asset> acsMap = new Map<Id, Asset>((List<Asset>)Database.query(acsSql));

        for(Id mainId:mainTasBeanMap.keySet()) {
            if(main2LinksMap.containsKey(mainId)) {
                Set<String> proInSummaryModelSet = new Set<String>(); // 用于存放一览下所有的产品型号
                for(Fixture_OneToOne_Link__c link: main2LinksMap.get(mainId)) {
                    if(acsMap.containsKey(link.Accessory_Asset__c)) {
                        // 用一对一附属品构造wrapperinfo
                        Asset acs = acsMap.get(link.Accessory_Asset__c);
                        Integer repair = intValueOf(link.CountForRepair__c);
                        Integer abandon = intValueOf(link.Abandoned_RealThing__c);
                        for(Integer i = 0; i < link.Quantity__c; i++) {
                            TransferApplyDetail__c tad = new TransferApplyDetail__c();
                            for(String field:FIELD_NAME_MAP.keySet()) {
                                tad.put(field, acs.get(FIELD_NAME_MAP.get(field)));
                            }
                            tad.VF_CountForRepair__c = intValueOf(link.CountForRepair__c);
                            tad.VF_Abandoned_RealThing__c = intValueOf(link.Abandoned_RealThing__c);
                            tad.VF_You_Xiao_Ku_Cun__c = intValueOf(link.In_wh_Fu_Shu_Pin_You_Xiao_Ku_Cun_F__c);
                            tad.VF_Abandoned_Inventory__c = 0;
                            tad.Fixture_OneToOne_Link__c = link.Id;
                            if(repair > 0) {
                                tad.TransferType__c = '待修理';
                                repair--;
                            }
                            else if(abandon > 0) {
                                tad.TransferType__c = '待废弃';
                                abandon--;
                            }
                            else {
                                tad.TransferType__c = '有效库存';
                            }
                            tad.OnetoOneAccessory__c = true;
                            TransferApplySummaryBean tasBean = mainTasBeanMap.get(mainId);
                            WrapperInfo wf = new WrapperInfo(tad, myComponentController);
                            wf.check = false;
                            wf.oldCheck = false;
                            wf.canEdit = true;
                            tasBean.wpinfoList.add(wf);
                            proInSummaryModelSet.add(link.Accessory_Asset__r.Fixture_Model_No_F__c);
                            proInSummaryModelSet.add(link.Main_Asset__r.Fixture_Model_No_F__c);
                        }
                    }
                }
                // 找出所有产品型号都匹配的配套
                Id fsId = findFS(proInSummaryModelSet, fsMap);
                if( fsId != null) {
                    TransferApplySummaryBean tasBean = mainTasBeanMap.get(mainId);
                    tasBean.tas.Fixture_Set__c = fsId;
                    for(WrapperInfo wf:tasBean.wpinfoList) {
                        TransferApplyDetail__c tad = (TransferApplyDetail__c) wf.sobj;
                        if(fsMap.get(fsId).containsKey(tad.Fixture_Model_No__c)) {
                            tad.Fixture_Set_Detail__c = fsMap.get(fsId).get(tad.Fixture_Model_No__c).Id;
                            tad.FSD_SortInt__c = fsMap.get(fsId).get(tad.Fixture_Model_No__c).SortInt__c;
                        }
                    }
                }
            }
        }
    }
    /**
    @description 根据产品Id去匹配配套
    @param proModelSet 一个一览下的产品型号Set
    @param fsMap 配套Id->产品型号->配套明细
    */
    private Id findFS(Set<String> proModelSet, Map<Id, Map<String, Fixture_Set_Detail__c>> fsMap) {
        for(Id fsId:fsMap.keySet()) {
            Boolean find = true;
            for(String proModel: proModelSet) {
                if(!fsMap.get(fsId).containsKey(proModel)) {
                    find = false;
                }
            }
            if(find && !proModelSet.isEmpty()) {
                return fsId;
            }
        }
        return null;
    }

    public List<SelectOption> getPickList(String objApi, String fieldApi) {
        Schema.DescribeFieldResult fieldResult = Schema.getGlobalDescribe().get(objApi).getDescribe().fields.getMap().get(fieldApi).getDescribe();
        List<SelectOption> pickListValuesList= new List<SelectOption>();
        List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
        pickListValuesList.add(new SelectOption('', ''));
        pickListValuesList.add(new SelectOption('--无--', '--无--'));
        for( Schema.PicklistEntry pickListVal : ple){
            pickListValuesList.add(new SelectOption(pickListVal.getValue(), pickListVal.getLabel()));
        }
        return pickListValuesList;
    }
    private static Map<String, String> FIELD_NAME_MAP = new Map<String, String> {
        // 明细字段->asset字段
        'Asset__c'                       => 'Id',
        'Fixture_Model_No__c'            => 'Fixture_Model_No_F__c',
        'SerialNumber__c'                => 'SerialNumber',
        'Internal_Asset_number_key__c'   => 'Internal_Asset_number_key__c',
        'Internal_asset_location__c'     => 'Internal_asset_location__c',
        'Salesdepartment__c'             => 'Salesdepartment__c',
        'SalesProvince__c'               => 'SalesProvince__c',
        'Equipment_Type__c'              => 'Equipment_Type__c',
        'EquipmentSet_Managment_Code__c' => 'EquipmentSet_Managment_Code__c',
        'Main_OneToOne__c'               => 'Main_OneToOne__c',
        'Manage_type__c'                 => 'Manage_type__c',
        'Loaner_accsessary__c'           => 'Loaner_accsessary__c',
        'VF_Abandoned_RealThing__c'      => 'TransferableAbandon_F__c',
        'VF_You_Xiao_Ku_Cun__c'          => 'Ji_Zhong_Guan_Li_Ku_Cun__c',
        'VF_CountForRepair__c'           => 'TransferableRepair_F__c',
        'VF_Abandoned_Inventory__c'      => 'TransferableLost_F__c',
        'Product_category__c'            => 'Product_category__c'
    };
    public class TransferApplySummaryBean {
        public TransferApplySummary__c tas;
        public List<WrapperInfo> wpinfoList;
        public TransferApplySummaryBean() {
            tas = new TransferApplySummary__c();
            wpinfoList = new List<WrapperInfo>();
        }
    }
}