ConstructionOperation/web/maintain/ration_repository/js/ration.js

/**
 * Created by Tony on 2017/4/28.
 */

$(document).ready(function () {
    //定额表与下方子表上下拖动
    let rationSubResize = getRationSubResize();
    SlideResize.verticalSlide(rationSubResize.eleObj, rationSubResize.limit, function () {
        if (rationOprObj.workBook) {
            rationOprObj.workBook.refresh();
        }
        if (rationGLJOprObj.sheet && rationGLJOprObj.sheet.getParent()) {
            rationGLJOprObj.sheet.getParent().refresh();
        }
    });
    SlideResize.loadVerticalHeight(rationSubResize.eleObj.module, rationSubResize.eleObj, rationSubResize.limit, function () {
        if (rationOprObj.workBook) {
            rationOprObj.workBook.refresh();
        }
        if (rationGLJOprObj.sheet && rationGLJOprObj.sheet.getParent()) {
            rationGLJOprObj.sheet.getParent().refresh();
        }
    });
});
function getRationSubResize() {
    let rationSubResize = {};
    rationSubResize.eleObj = {
        module: moduleName,
        resize: $('#rationSubResize'),
        top: $('#rationItemsSheet'),
        topSpread: $('#rationItemsSheet'),
        bottom: $('#subContent'),
        bottomSpread: $('#rdSpread')
    };
    rationSubResize.limit = {
        min: 150,
        max: `$(window).height()-$('.header').height()-$('.tools-bar').height()-150-verticalResize`,
        totalHeight: `$(window).height()-$('.header').height()-$('.tools-bar').height()-verticalResize`,
        notTopSpread: 0,
        notBottomSpread: $('#subContent ul').height(),
    };
    return rationSubResize;
}
function loadRationSubSize(resizeObj) {
    if (!resizeObj) {
        resizeObj = getRationSubResize();
    }
    SlideResize.loadVerticalHeight(resizeObj.eleObj.module, resizeObj.eleObj, resizeObj.limit, function () {
        if (rationOprObj.workBook) {
            rationOprObj.workBook.refresh();
        }
        if (rationGLJOprObj.sheet && rationGLJOprObj.sheet.getParent()) {
            rationGLJOprObj.sheet.getParent().refresh();
        }
    });
}

const digital = {
    gljPrc: -3,//计算定额基价时单个工料机价格取三位
    rationBasePrc: -2,
    consumeAmt: -3
};
let rationOprObj = {
    workBook: null,
    currentRations: {},
    currentEditingRation: null,
    currentSectionId: -1,
    rationsCodes: [],
    setting: {
        header: [
            { headerName: "编码", headerWidth: 70, dataCode: "code", dataType: "String", formatter: "@" },
            { headerName: "名称", headerWidth: 240, dataCode: "name", dataType: "String" },
            { headerName: "计量单位", headerWidth: 70, dataCode: "unit", dataType: "String", hAlign: "center" },
            { headerName: "人工费", headerWidth: 80, dataCode: "labourPrice", dataType: "Number", formatter: "0.00", hAlign: "right" },
            { headerName: "材料费", headerWidth: 80, dataCode: "materialPrice", dataType: "Number", formatter: "0.00", hAlign: "right" },
            { headerName: "机械费", headerWidth: 80, dataCode: "machinePrice", dataType: "Number", formatter: "0.00", hAlign: "right" },
            { headerName: "基价", headerWidth: 80, dataCode: "basePrice", dataType: "Number", formatter: "0.00", hAlign: "right" },
            { headerName: "显示名称（以%s表示参数）", headerWidth: 240, dataCode: "caption", dataType: "String" },
            { headerName: "取费专业", headerWidth: 70, dataCode: "feeType", dataType: "String", hAlign: "center" },
            { headerName: "管理费费率(%)", headerWidth: 100, dataCode: "manageFeeRate", dataType: "String", hAlign: "center" },
            { headerName: "一类地区管理费", headerWidth: 100, dataCode: "manageFee1", dataType: "Number", hAlign: "right" },
            { headerName: "二类地区管理费", headerWidth: 100, dataCode: "manageFee2", dataType: "Number", hAlign: "right" },
            { headerName: "三类地区管理费", headerWidth: 100, dataCode: "manageFee3", dataType: "Number", hAlign: "right" },
            { headerName: "四类地区管理费", headerWidth: 100, dataCode: "manageFee4", dataType: "Number", hAlign: "right" },
            { headerName: "工作内容", headerWidth: 130, dataCode: "jobContentText", dataType: "String" },
        ],
        view: {
            comboBox: [
                { row: -1, col: 2, rowCount: -1, colCount: 1 }
            ],
            lockedCells: [
                { row: -1, col: 3, rowCount: -1, colCount: 1 }
            ],
            lockColumns: [
                3, 4, 5, 6
            ]
        }
    },
    buildSheet: function (container) {
        let rationRepId = getQueryString("repository");
        let me = rationOprObj;
        me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
        sheetCommonObj.bindEscKey(me.workBook, [{ sheet: me.workBook.getSheet(0), editStarting: me.onCellEditStart, editEnded: me.onCellEditEnd }]);
        me.onContextmenuOpr();
        me.rationDelOpr();
        me.setCombo(me.workBook.getSheet(0), 'dynamic');
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.LeaveCell, me.onLeaveCell);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.SelectionChanged, me.onSelectionChanged);
    },
    setCombo: function (sheet, combo) {
        let me = rationOprObj;
        sheet.suspendPaint();
        sheet.suspendEvent();
        if (combo) {
            combo = sheetCommonObj.getDynamicCombo();
            combo.items(rationAndGljUnits).itemHeight(10).editable(true);
        }
        sheet.getRange(-1, me.setting.view.comboBox[0].col, -1, 1).cellType(combo);
        sheet.resumePaint();
        sheet.resumeEvent();
    },
    // TODO info.oldSelections is null
    onSelectionChanged: function (sender, info) {
        console.log(info);
        if (info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row) {
            let row = info.newSelections[0].row;
            let me = rationOprObj;
            me.rationSelInit(row);
        }
    },
    //focusOnSection将工作簿焦点移到章节表上
    rationSelInit: function (row, focusOnSection = null) {
        let me = rationOprObj,
            sheetGLJ = rationGLJOprObj.sheet, settingGLJ = rationGLJOprObj.setting,
            sheetCoe = rationCoeOprObj.sheet, settingCoe = rationCoeOprObj.setting,
            sheetAss = rationAssistOprObj.sheet, settingAss = rationAssistOprObj.setting,
            sheetInst = rationInstObj.sheet, settingInst = rationInstObj.setting;
        sheetCommonObj.cleanData(sheetGLJ, settingGLJ, -1);
        sheetCommonObj.cleanData(sheetCoe, settingCoe, -1);
        sheetCommonObj.cleanData(sheetAss, settingAss, -1);
        sheetCommonObj.cleanData(sheetInst, settingInst, -1);
        let cacheSection = me.getCache();
        RationTemplate.rationInitSel(cacheSection[row]);
        if (cacheSection && row < cacheSection.length) {
            rationGLJOprObj.getGljItems(cacheSection[row], function () {
                if (focusOnSection) {
                    sectionTreeObj.workBook.focus(true);
                } else {
                    me.workBook.focus(true);
                }
            });
            rationCoeOprObj.getCoeItems(cacheSection[row], function () {
                if (focusOnSection) {
                    sectionTreeObj.workBook.focus(true);
                } else {
                    me.workBook.focus(true);
                }
            });
            rationAssistOprObj.getAssItems(cacheSection[row]);
            rationInstObj.getInstItems(cacheSection[row], function () {
                if (focusOnSection) {
                    sectionTreeObj.workBook.focus(true);
                } else {
                    me.workBook.focus(true);
                }
            });
        }
        else {
            rationGLJOprObj.currentRationItem = null;
        }
        if (!focusOnSection) {
            me.workBook.focus(true);
        }
    },

    isInt: function (num) {
        return !isNaN(num) && num % 1 === 0;
    },
    getCache: function () {
        let me = this, rst = me.currentRations["_SEC_ID_" + me.currentSectionId];
        if (!(rst)) {
            me.currentRations["_SEC_ID_" + me.currentSectionId] = [];
            rst = me.currentRations["_SEC_ID_" + me.currentSectionId];
        }
        return rst;
    },
    updateCache: function (addArr, updateArr, removeIds, result) {
        let me = this, cacheSection = me.getCache();
        if (addArr.length > 0) {
            me.currentRations["_SEC_ID_" + me.currentSectionId] = cacheSection.concat(addArr);
            cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
        }
        for (let i = removeIds.length - 1; i >= 0; i--) {
            for (let j = cacheSection.length - 1; j >= 0; j--) {
                if (cacheSection[j].rationTemplateList) {
                    //清除模板关联
                    _.remove(cacheSection[j].rationTemplateList, function (data) {
                        return removeIds.includes(data.rationID);
                    });
                }
                if (cacheSection[j]["ID"] == removeIds[i]) {
                    cacheSection.splice(j, 1);
                }
            }
        }
        if (result && result.data.ops && result.data.ops.length > 0) {
            for (let i = 0; i < result.data.ops.length; i++) {
                for (let j = 0; j < cacheSection.length; j++) {
                    if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
                        cacheSection[j]["ID"] = result.data.ops[i]["ID"];
                        cacheSection[j]["rationGljList"] = result.data.ops[i]["rationGljList"];
                        cacheSection[j]["rationCoeList"] = result.data.ops[i]["rationCoeList"];
                        cacheSection[j]["rationAssList"] = result.data.ops[i]["rationAssList"];
                        cacheSection[j]["rationInstList"] = result.data.ops[i]["rationInstList"];
                    }
                }
            }
        }
        for (let i = 0; i < updateArr.length; i++) {
            for (let j = 0; j < cacheSection.length; j++) {
                if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
                    if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
                        updateArr[i]['rationGljList'] = rationGLJOprObj.cache['_GLJ_' + cacheSection[j]['ID']] ?
                            rationGLJOprObj.cache['_GLJ_' + cacheSection[j]['ID']] :
                            cacheSection[j]['rationGljList'] ?
                                cacheSection[j]['rationGljList'] : [];
                        updateArr[i]['rationCoeList'] = cacheSection[j]['rationCoeList'] ? cacheSection[j]['rationCoeList'] : [];
                        updateArr[i]['rationAssList'] = cacheSection[j]['rationAssList'];
                        updateArr[i]['rationInstList'] = cacheSection[j]['rationInstList'];
                        updateArr[i]['rationTemplateList'] = cacheSection[j]['rationTemplateList'];
                        cacheSection[j] = updateArr[i];
                    }
                } else {
                    if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
                        updateArr[i]['rationGljList'] = rationGLJOprObj.cache['_GLJ_' + cacheSection[j]['ID']] ?
                            rationGLJOprObj.cache['_GLJ_' + cacheSection[j]['ID']] :
                            cacheSection[j]['rationGljList'] ?
                                cacheSection[j]['rationGljList'] : [];
                        updateArr[i]['rationCoeList'] = cacheSection[j]['rationCoeList'] ? cacheSection[j]['rationCoeList'] : [];
                        updateArr[i]['rationAssList'] = cacheSection[j]['rationAssList'];
                        updateArr[i]['rationInstList'] = cacheSection[j]['rationInstList'];
                        updateArr[i]['rationTemplateList'] = cacheSection[j]['rationTemplateList'];
                        cacheSection[j] = updateArr[i];
                    }
                }
            }
        }
        return cacheSection;
    },
    onContextmenuOpr: function () {//右键菜单
        let me = this;
        $.contextMenu({
            selector: '#rationItemsSheet',
            build: function ($triggerElement, e) {
                //控制允许右键菜单在哪个位置出现
                let target = SheetDataHelper.safeRightClickSelection($triggerElement, e, me.workBook);
                let sheet = me.workBook.getSheet(0);
                let cacheSection = me.getCache();
                let ration = cacheSection[target.row];
                if (target.hitTestType === 3) {//在表格内&& typeof target.row !== 'undefined' && typeof target.col !== 'undefined'
                    if (typeof target.row !== 'undefined') {
                        //控制按钮是否可用
                        sheet.setActiveCell(target.row, target.col);
                    }
                    return {
                        callback: function () { },
                        items: {
                            "delete": {
                                name: "删除",
                                disabled: function () {
                                    const inValidCell = !commonUtil.isDef(target.row) || !commonUtil.isDef(target.col);
                                    const inValidData = !cacheSection || target.row >= cacheSection.length;
                                    return locked || inValidCell || inValidData;
                                },
                                icon: "fa-remove",
                                callback: function (key, opt) {
                                    let removeInfo = `确定要删除定额 “${ration.code}” 及其下的所有数据吗？`;
                                    $('#delRationAlert').find('.modal-body h5').text(removeInfo);
                                    $('#delRationAlert').modal('show');
                                    $('#delRationConfirm').bind('click', function () {
                                        me.rationsCodes.splice(me.rationsCodes.indexOf(ration.code.toString()), 1);
                                        me.mixDel = 1;
                                        me.mixUpdateRequest([], [], [ration.ID]);
                                        $('#delRationConfirm').unbind('click');
                                        $('#delRationAlert').modal('hide');
                                    });
                                }
                            }
                        }
                    };
                }
                else {
                    return false;
                }
            }
        });
    },
    rationDelOpr: function () {
        if (locked) {
            return;
        }
        let me = rationOprObj;
        me.workBook.commandManager().register('rationDelete', function () {
            let rationSheet = me.workBook.getActiveSheet();
            let sels = rationSheet.getSelections(), updateArr = [], removeArr = [], lockCols = me.setting.view.lockColumns;
            let removeCodes = [];
            let cacheSection = me.getCache();
            if (sels.length > 0) {
                for (let sel = 0; sel < sels.length; sel++) {
                    if (sels[sel].colCount === me.setting.header.length) {
                        if (cacheSection) {
                            for (let i = 0; i < sels[sel].rowCount; i++) {
                                if (sels[sel].row + i < cacheSection.length) {
                                    removeArr.push(cacheSection[sels[sel].row + i].ID);
                                    removeCodes.push(cacheSection[sels[sel].row + i].code);
                                    me.rationsCodes.splice(me.rationsCodes.indexOf(cacheSection[sels[sel].row + i].code.toString()), 1);
                                }
                            }
                        }
                    }
                    else {
                        if (sels[sel].col === 0) {
                            $('#alertText').text("编号不能为空，修改失败！");
                            $('#alertModalBtn').click();
                            $('#alertModalCls').click(function () {
                            });
                            $('#alertModalCof').click(function () {
                            })
                        }
                        else if (sels[sel].col !== 0 && !(sels[sel].col === 3 && sels.col + sels[sel].colCount - 1 === 6)) {
                            if (cacheSection) {
                                for (let i = sels[sel].row === -1 ? 1 : 0; i < sels[sel].rowCount; i++) {
                                    if (sels[sel].row + i < cacheSection.length) {
                                        for (let col = sels[sel].col; col <= sels[sel].col + sels[sel].colCount - 1; col++) {
                                            if (lockCols.indexOf(col) === -1) {
                                                cacheSection[sels[sel].row + i][me.setting.header[col].dataCode] = '';
                                            }
                                        }
                                    }
                                    if (cacheSection[sels[sel].row + i] && typeof cacheSection[sels[sel].row + i] !== 'undefined') {
                                        updateArr.push(cacheSection[sels[sel].row + i]);
                                    }
                                }
                            }
                        }
                    }
                }
            }
            /*  if(updateArr.length > 0 || removeArr.length > 0){
                  me.mixUpdate = 1;
                  me.mixDel = removeArr.length > 0 ? 1 : 0;
                  me.mixUpdateRequest(updateArr, [], removeArr);
              }*/
            if (updateArr.length > 0) {
                me.mixUpdate = 1;
                me.mixUpdateRequest(updateArr, [], []);
            }
            if (removeArr.length > 0) {
                let removeInfo = `确定要删除定额 “${removeCodes.join('，')}” 及其下的所有数据吗？`;
                $('#delRationAlert').find('.modal-body h5').text(removeInfo);
                $('#delRationAlert').modal('show');
                $('#delRationConfirm').bind('click', function () {
                    me.mixDel = 1;
                    me.mixUpdateRequest([], [], removeArr);
                    $('#delRationConfirm').unbind('click');
                    $('#delRationAlert').modal('hide');
                });
            }

        });
        me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
        me.workBook.commandManager().setShortcutKey('rationDelete', GC.Spread.Commands.Key.del, false, false, false, false);
    },
    isDef: function (v) {
        return v !== undefined && v !== null;
    },
    onLeaveCell: function (sender, args) {
        let me = rationOprObj;
        me.lastCol = me.setting.header[args.col];
    },
    onEnterCell: function (sender, args) {
        let me = rationOprObj;
        if (me.setting.header[args.col]['dataCode'] === 'unit' || me.lastCol.dataCode === 'unit') {
            args.sheet.repaint();
        }
        me.cellRowIdx = args.row;
        let isHasData = false;
        if (me.addRationItem) {
            for (let i = 0; i < me.setting.header.length; i++) {
                if (me.addRationItem[me.setting.header[i].dataCode]) {
                    isHasData = true;
                    break;
                }
            }
        }
        if (isHasData) {
            if (me.editingRowIdx !== me.cellRowIdx) {
                let focusToCol = !me.addRationItem.code ? 0 : -1;
                if (focusToCol !== -1) {
                    $('#rationAlertBtn').click();
                    $('#rationAlertCac').click(function () {
                        me.addRationItem = null;
                        for (let col = 0; col < me.setting.header.length; col++) {
                            me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value('');
                        }
                    });
                    $('#rationAlertCls').click(function () {
                        me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
                    });
                    $('#rationAlertCof').click(function () {
                        me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
                    });
                }
            }
        }
    },
    onCellEditStart: function (sender, args) {
        let me = rationOprObj;
        if (!me.canRations || me.setting.view.lockColumns.indexOf(args.col) !== -1) {
            args.cancel = true;
        }
        else {
            let rObj = sheetsOprObj.combineRationRowData(me.workBook.getSheet(0), me.setting, args.row);
            me.currentEditingRation = rObj;
            let cacheSection = me.getCache();
            if (cacheSection) {
                for (let j = 0; j < cacheSection.length; j++) {
                    if (cacheSection[j][me.setting.header[0].dataCode] == rObj[me.setting.header[0].dataCode]) {
                        rObj["ID"] = cacheSection[j]["ID"];
                        break;
                    }
                }
            }
        }
    },
    onCellEditEnd: function (sender, args) {
        let me = rationOprObj;
        // 输入编号、名称、单位时，如果输入回车符或粘贴回车符，提交时应转换为空格。
        let dataCode = me.setting.header[args.col].dataCode;
        let deESCFields = ['code', 'name', 'unit'];
        if (deESCFields.includes(dataCode)) {
            args.editingText = me.isDef(args.editingText) ? args.editingText.toString().replace(/[\r\n]/g, ' ') : '';
            args.sheet.setValue(args.row, args.col, args.editingText);
        }
        let rObj = sheetsOprObj.combineRationRowData(me.workBook.getSheet(0), me.setting, args.row),
            updateArr = [],
            addArr = [];
        me.editingRowIdx = args.row;
        if (me.currentEditingRation["ID"]) {
            if ((!args.editingText || args.editingText.toString().trim().length === 0) && args.col === 0) {
                args.sheet.setValue(args.row, args.col, me.currentEditingRation[dataCode] + '');
            }
            else {
                rObj["ID"] = me.currentEditingRation["ID"];
                if (me.currentEditingRation[dataCode] !== rObj[dataCode]) {
                    me.addRationItem = rObj;
                    if (dataCode === 'code') {
                        if (me.rationsCodes.indexOf(rObj.code.toString()) === -1) {
                            me.rationsCodes.splice(me.rationsCodes.indexOf(rObj.code.toString()), 1);
                            me.rationsCodes.push(rObj.code.toString());
                            updateArr.push(rObj);
                        }
                        else {
                            alert("编码已存在!");
                            args.sheet.setValue(args.row, args.col, me.currentEditingRation[dataCode]);

                        }
                    }
                    else if (dataCode === 'feeType') {
                        updateArr.push(rObj);
                        /* if (me.isInt(rObj[dataCode])) {
                            updateArr.push(rObj);
                        }
                        else {
                            rObj[dataCode] = '';
                            args.sheet.setValue(args.row, args.col, typeof me.currentEditingRation[dataCode] !== 'undefined' && me.currentEditingRation[dataCode] ? me.currentEditingRation[dataCode] : '');
                        } */
                    }
                    else {
                        updateArr.push(rObj);
                    }
                }
            }
        }
        else if (!me.currentEditingRation["ID"]) {
            if (!sheetCommonObj.chkIfEmpty(rObj, me.setting)) {
                //addArr.push(rObj);
                me.addRationItem = rObj;
                if (rObj.code && rObj.code.toString().trim().length > 0) {
                    if (me.rationsCodes.indexOf(rObj.code.toString()) === -1) {
                        //jobContent
                        if (jobContentOprObj && jobContentOprObj.currentSituation === jobContentOprObj.situations.ALL) {
                            rObj.jobContent = jobContentOprObj.currentJobContent ? jobContentOprObj.currentJobContent : '';
                        }
                        if (annotationOprObj && annotationOprObj.currentSituation === annotationOprObj.situations.ALL) {
                            rObj.annotation = annotationOprObj.currentAnnotation ? annotationOprObj.currentAnnotation : '';
                        }
                        me.setInitPrc(rObj);
                        addArr.push(rObj);
                        me.rationsCodes.push(rObj.code.toString());
                        me.addRationItem = null;
                    }
                    else {
                        alert('编码已存在！');
                        me.workBook.getSheet(0).setValue(args.row, args.col, '');
                    }
                }
                else if (rObj.code && rObj.code.toString.trim().length === 0) {
                    me.workBook.getSheet(0).setValue(args.row, args.col, '');
                }
            }
        }
        if (updateArr.length > 0 || addArr.length > 0) {
            me.currentEditingRation = null;
            me.mixUpdate = 1;
            me.mixUpdateRequest(updateArr, addArr, []);
        }
    },
    canPasted: function (beginCol, maxCol) {
        let rst = false;
        if (maxCol < 3 || beginCol > 6) {
            rst = true;
        }
        return rst;
    },
    onClipboardPasting: function (sender, args) {
        let me = rationOprObj;
        let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
        if (!me.canRations || !me.canPasted(args.cellRange.col, maxCol) || maxCol > me.setting.header.length - 1) {
            args.cancel = true;
        }
    },
    //todo: overwrite?
    onClipboardPasted: function (e, info) {
        console.log('cp');
        let me = rationOprObj;
        let cacheSection = me.getCache();
        let updateArr = [], addArr = [];
        let items = sheetCommonObj.analyzePasteData(me.setting, info);
        for (let i = 0; i < items.length; i++) {
            let rowIdx = info.cellRange.row + i;
            if (cacheSection) {
                /*  if(!me.isValidUnit(items[i], rationUnits)){//无效单位
                      items[i].unit = rowIdx < cacheSection.length  && typeof cacheSection[rowIdx].unit !== 'undefined' ? cacheSection[rowIdx].unit : '';
                  }*/
                if (!cacheSection[rowIdx] && info.cellRange.col === 0) {
                    if (me.rationsCodes.indexOf(items[i].code.toString()) === -1) {
                        //jobConten
                        if (jobContentOprObj && jobContentOprObj.currentSituation === jobContentOprObj.situations.ALL) {
                            items[i].jobContent = jobContentOprObj.currentJobContent ? jobContentOprObj.currentJobContent : '';
                        }
                        if (annotationOprObj && annotationOprObj.currentSituation === annotationOprObj.situations.ALL) {
                            items[i].annotation = annotationOprObj.currentAnnotation ? annotationOprObj.currentAnnotation : '';
                        }
                        me.setInitPrc(items[i]);
                        addArr.push(items[i]);
                        me.rationsCodes.push(items[i].code.toString());
                    }
                    else {
                        me.workBook.getSheet(0).setValue(rowIdx, 0, '');
                    }
                }
                else if (cacheSection[rowIdx]) {
                    for (let col = 0; col < me.setting.header.length; col++) {
                        if (!items[i][me.setting.header[col].dataCode] && typeof cacheSection[rowIdx][me.setting.header[col].dataCode] !== 'undefined') {
                            items[i][me.setting.header[col].dataCode] = cacheSection[rowIdx][me.setting.header[col].dataCode];
                        }
                    }
                    if (items[i].feeType && !me.isInt(items[i].feeType)) {
                        items[i].feeType = '';
                        me.workBook.getSheet(0).setValue(rowIdx, 8, '');
                    }
                    if (info.cellRange.col === 0) {
                        if (me.rationsCodes.indexOf(items[i].code.toString()) === -1) {
                            items[i].ID = cacheSection[rowIdx].ID;
                            updateArr.push(items[i]);
                        }
                        else {
                            me.workBook.getSheet(0).setValue(rowIdx, 0, cacheSection[rowIdx].code);
                        }
                    }
                    else {
                        items[i].ID = cacheSection[rowIdx].ID;
                        updateArr.push(items[i]);
                    }
                }

            } else {
                /* if(!me.isValidUnit(items[i], rationUnits)){//无效单位
                     items[i].unit = '';
                 }*/
                //add
                if (info.cellRange.col === 0) {
                    //是否含有已存在的编号
                    if (me.rationsCodes.indexOf(items[i].code.toString()) === -1) {
                        //jobConten
                        if (jobContentOprObj && jobContentOprObj.currentSituation === jobContentOprObj.situations.ALL) {
                            items[i].jobContent = jobContentOprObj.currentJobContent ? jobContentOprObj.currentJobContent : '';
                        }
                        if (annotationOprObj && annotationOprObj.currentSituation === annotationOprObj.situations.ALL) {
                            items[i].annotation = annotationOprObj.currentAnnotation ? annotationOprObj.currentAnnotation : '';
                        }
                        me.setInitPrc(items[i]);
                        addArr.push(items[i]);
                    }
                }
            }
        };
        if (updateArr.length > 0 || addArr.length > 0) {
            console.log(updateArr);
            me.mixUpdate = 1;
            me.mixUpdateRequest(updateArr, addArr, []);
        }
        else {
            me.getRationItems(me.currentSectionId);
        }
    },
    setInitPrc: function (obj) {
        obj.labourPrice = 0;
        obj.materialPrice = 0;
        obj.machinePrice = 0;
        obj.basePrice = 0;
    },
    isValidUnit: function (rationObj, validUnits) {
        let rst = true;
        if (typeof rationObj.unit !== 'undefined' && rationObj.unit && validUnits.indexOf(rationObj.unit) === -1) {//无效
            rst = false;
        }
        return rst;
    },
    mixUpdateRequest: function (updateArr, addArr, removeIds, callback) {
        let me = rationOprObj;
        me.saveInString(updateArr);
        $.ajax({
            type: "POST",
            url: "api/mixUpdateRationItems",
            data: { "rationLibId": getQueryString("repository"), "lastOpr": userAccount, "sectionID": me.currentSectionId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds) },
            dataType: "json",
            cache: false,
            timeout: 20000,
            success: function (result) {
                if (result.error) {
                    alert('error');
                    me.getRationItems(me.currentSectionId);
                } else {
                    let cacheSection = me.updateCache(addArr, updateArr, removeIds, result);
                    me.sortByCode(cacheSection);
                    /*cacheSection.sort(function(a, b){
                        let rst = 0;
                        if (a.code > b.code) rst = 1
                        else if (a.code < b.code) rst = -1;
                        return rst;
                    });*/
                    //add
                    let curRow = me.workBook.getActiveSheet().getActiveRowIndex();
                    me.rationSelInit(curRow);
                    //add
                    //jobContent
                    if (jobContentOprObj) {
                        jobContentOprObj.currentRationItems = cacheSection;
                        jobContentOprObj.setRadiosDisabled(cacheSection.length > 0 ? false : true, jobContentOprObj.radios);
                        if (cacheSection.length === 0) {
                            jobContentOprObj.updateSituation(pageOprObj.rationLibId, me.currentSectionId, 'NONE');
                        }
                        jobContentOprObj.setRadiosChecked(jobContentOprObj.currentSituation, jobContentOprObj.radios);
                        if (jobContentOprObj.currentSituation === jobContentOprObj.situations.PARTIAL) {
                            jobContentOprObj.buildTablePartial(jobContentOprObj.tablePartial, jobContentOprObj.getGroup(cacheSection));
                        }
                    }
                    if (annotationOprObj) {
                        annotationOprObj.setRadiosDisabled(cacheSection.length > 0 ? false : true, annotationOprObj.radios);
                        if (cacheSection.length === 0) {
                            annotationOprObj.updateAnnoSituation(pageOprObj.rationLibId, me.currentSectionId, 'NONE');
                        }
                        annotationOprObj.setRadiosChecked(annotationOprObj.currentSituation, annotationOprObj.radios);
                        if (annotationOprObj.currentSituation === annotationOprObj.situations.PARTIAL) {
                            annotationOprObj.buildTablePartial(annotationOprObj.fzTablePartial, annotationOprObj.getGroup(cacheSection));
                        }
                    }
                    me.showRationItems(me.currentSectionId);
                    me.mixUpdate = 0;
                    me.mixDel = 0;
                }
                me.workBook.focus(true);
                if (callback) callback();
            },
            error: function () {
            }
        });
    },
    doAfterGetRation: null,
    getRationItems: function (sectionID, callback = null) {
        if (sectionID != -1) {
            let me = rationOprObj;
            me.mixUpdate = 0;
            me.currentSectionId = sectionID;
            /*if (me.currentRations["_SEC_ID_" + sectionID]) {
                //jobContent--
                jobContentOprObj.currentRationItems = me.currentRations["_SEC_ID_" + sectionID];
                jobContentOprObj.rationJobContentOpr(me.currentRations["_SEC_ID_" + sectionID]);
                //annotation
                annotationOprObj.rationAnnotationOpr(me.currentRations["_SEC_ID_" + sectionID]);
                me.showRationItems(sectionID);
                sectionTreeObj.removeBtn.removeClass('disabled');
                if(callback){
                    callback();
                }
            } else */{
                $.ajax({
                    type: "POST",
                    url: "api/getRationItems",
                    data: { "rationRepId": pageOprObj.rationLibId, "sectionID": sectionID },
                    dataType: "json",
                    cache: false,
                    timeout: 10000,
                    success: function (result) {
                        if (result) {
                            me.currentRations["_SEC_ID_" + sectionID] = result.data;
                            me.sortByCode(me.currentRations["_SEC_ID_" + sectionID]);
                            //job--
                            jobContentOprObj.currentRationItems = me.currentRations["_SEC_ID_" + sectionID];
                            jobContentOprObj.rationJobContentOpr(me.currentRations["_SEC_ID_" + sectionID]);
                            //annotation
                            annotationOprObj.rationAnnotationOpr(me.currentRations["_SEC_ID_" + sectionID]);
                            me.showRationItems(sectionID);
                        }
                        if (!locked) {
                            sectionTreeObj.removeBtn.removeClass('disabled');
                        }
                        if (callback) {
                            callback(result.data);
                        }
                    },
                    error: function (err) {
                        sectionTreeObj.removeBtn.removeClass('disabled');
                        alert(err);
                    }
                })
            }
        }
    },
    showRationItems: function (sectionID) {
        let me = rationOprObj,
            sheetGLJ = rationGLJOprObj.sheet, settingGLJ = rationGLJOprObj.setting,
            sheetCoe = rationCoeOprObj.sheet, settingCoe = rationCoeOprObj.setting,
            sheetAss = rationAssistOprObj.sheet, settingAss = rationAssistOprObj.setting,
            sheetInst = rationInstObj.sheet, settingInst = rationInstObj.setting;
        if (me.workBook) {
            sheetCommonObj.cleanData(me.workBook.getSheet(0), me.setting, -1);
            if (me.currentRations && me.currentRations["_SEC_ID_" + sectionID]) {
                let cacheSection = me.currentRations["_SEC_ID_" + sectionID];
                sheetsOprObj.showData(me.workBook.getSheet(0), me.setting, cacheSection);
                if (me.mixDel === 1) {
                    let row = me.workBook.getSheet(0).getSelections()[0].row;
                    if (cacheSection && row < cacheSection.length) {
                        sheetCommonObj.cleanData(sheetGLJ, settingGLJ, -1);
                        sheetCommonObj.cleanData(sheetCoe, settingCoe, -1);
                        sheetCommonObj.cleanData(sheetAss, settingAss, -1);
                        sheetCommonObj.cleanData(sheetInst, settingInst, -1);
                        rationGLJOprObj.getGljItems(cacheSection[row]);
                        rationCoeOprObj.getCoeItems(cacheSection[row]);
                        rationAssistOprObj.getAssItems(cacheSection[row]);
                        rationInstObj.getInstItems(cacheSection[row]);
                    }
                    else {
                        rationGLJOprObj.currentRationItem = null;
                        sheetCommonObj.cleanData(sheetGLJ, settingGLJ, -1);
                        sheetCommonObj.cleanData(sheetCoe, settingCoe, -1);
                        sheetCommonObj.cleanData(sheetAss, settingAss, -1);
                        sheetCommonObj.cleanData(sheetInst, settingInst, -1);
                        sheetCommonObj.setDynamicCombo(sheetAss, 0, 5, sheetAss.getRowCount(), rationAssistOprObj.setting.comboItems, false, false);
                    }
                }

            } else {
                sheetCommonObj.setDynamicCombo(sheetAss, 0, 5, sheetAss.getRowCount(), rationAssistOprObj.setting.comboItems, false, false);
                //清除ration数据及工料机数据
                rationGLJOprObj.currentRationItem = null;
                sheetCommonObj.cleanSheet(sheetGLJ, settingGLJ, -1);
                sheetCommonObj.cleanSheet(sheetCoe, settingCoe, -1);
                sheetCommonObj.cleanSheet(sheetAss, settingAss, -1);
                sheetCommonObj.cleanSheet(sheetInst, settingInst, -1);
            }
            //--- me.workBook.focus(true);
        }
        sectionTreeObj.workBook.focus(true);
    },
    sortByCode: function (arr) {
        function recurCompare(a, b, index) {
            if (a[index] && !b[index]) {
                return 1;
            } else if (!a[index] && b[index]) {
                return -1;
            } else if (a[index] && b[index]) {
                let aV = a[index],
                    bV = b[index];
                if (!isNaN(aV) && !isNaN(bV)) {
                    aV = parseFloat(a[index]);
                    bV = parseFloat(b[index]);
                }
                if (aV > bV) {
                    return 1;
                } else if (aV < bV) {
                    return -1;
                } else {
                    return recurCompare(a, b, index + 1);
                }
            }
            return 0;
        }
        arr.sort(function (a, b) {
            if (!commonUtil.isDef(a.code) || !commonUtil.isDef(b.code)) {
                return 0;
            }
            let aArr = a.code.split('-'),
                bArr = b.code.split('-');
            return recurCompare(aArr, bArr, 0);
        });
    },
    saveInString(datas) {
        for (let i = 0, len = datas.length; i < len; i++) {
            let data = datas[i];
            if (data.labourPrice !== undefined && data.labourPrice) {
                data.labourPrice = data.labourPrice.toString();
            }
            if (data.materialPrice !== undefined && data.materialPrice) {
                data.materialPrice = data.materialPrice.toString();
            }
            if (data.machinePrice !== undefined && data.machinePrice) {
                data.machinePrice = data.machinePrice.toString();
            }
            if (data.basePrice !== undefined && data.basePrice) {
                data.basePrice = data.basePrice.toString();
            }
            if (data.rationGljList !== undefined && data.rationGljList && data.rationGljList.length > 0) {
                for (let j = 0, jLen = data.rationGljList.length; j < jLen; j++) {
                    let raGljObj = data.rationGljList[j];
                    if (raGljObj.consumeAmt !== undefined && raGljObj.consumeAmt) {
                        raGljObj.consumeAmt = raGljObj.consumeAmt.toString();
                    }
                }
            }
        }
    }
}