ConstructionCost/web/rationLibEditor/js/ration.js

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

$("#gongliao").click(function(){
    $(this).attr('href', "/rationRepository/lmm" + "?repository=" + getQueryString("repository"))
});

var rationOprObj = {
    workBook: null,
    currentRations: {},
    currentEditingRation: null,
    currentSectionId: -1,
    setting: {
        header:[
            {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@"},
            {headerName:"名称",headerWidth:300,dataCode:"name", dataType: "String"},
            {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center"},
            {headerName:"基价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right"},
            {headerName:"显示名称（以%s表示参数）",headerWidth:350,dataCode:"caption", dataType: "String"},
            {headerName:"取费专业",headerWidth:120,dataCode:"feeType", dataType: "Number", hAlign: "center"}
        ],
        view:{
            comboBox:[
                {row:-1,col:2,rowCount:-1,colCount:1}
            ],
            lockedCells:[
                {row:-1,col:3,rowCount:-1, colCount:1}
            ]
        }
    },
    buildSheet: function(container) {
        var me = this;
        me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
        me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
        me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
        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.RangeChanged, me.onRangeChanged);
    },
    onRangeChanged: function(sender, args) {
        if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
            var me = rationOprObj, updateArr = [], addArr = [];
            var cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
            if (cacheSection) {
                for (var i = 0; i < args.rowCount; i++) {
                    var hasUpdate = false, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row + i);
                    for (var 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"];
                            hasUpdate = true;
                            break;
                        }
                    }
                    if (hasUpdate) {
                        updateArr.push(rObj);
                    }
                }
                //me.mixUpdateRequest(updateArr, addArr);
                //removeRationItems
            }
        }
    },
    onCellEditStart: function(sender, args) {
        var me = rationOprObj;
        var rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
        me.currentEditingRation = rObj;
        var cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
        if (cacheSection) {
            for (var 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) {
        var me = rationOprObj, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row),
            updateArr = [], addArr = [];
        if (me.currentEditingRation["ID"]) {
            rObj["ID"] = me.currentEditingRation["ID"];
            updateArr.push(rObj);
        } else {
            addArr.push(rObj);
        }
        me.currentEditingRation = null;
        me.mixUpdateRequest(updateArr, addArr);
    },
    onClipboardPasting: function(sender, args) {
        var me = rationOprObj;
        if (args.cellRange.colCount != me.setting.header.length) {
            args.cancel = true;
        }
    },
    onClipboardPasted: function(e, info) {
        var me = rationOprObj;
        var cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
        var updateArr = [], addArr = [];
        var items = sheetCommonObj.analyzePasteData(me.setting, info);
        for (var i = 0; i < items.length; i++) {
            if (cacheSection) {
                var hasCacheItem = false;
                for (var j = 0; j < cacheSection.length; j++) {
                    if (cacheSection[j][me.setting.header[0].dataCode] == items[i][me.setting.header[0].dataCode]) {
                        hasCacheItem = true;
                        items[i]["ID"] = cacheSection[j]["ID"];
                        break;
                    }
                }
                if (!hasCacheItem) {
                    addArr.push(items[i]);
                } else {
                    updateArr.push(items[i]);
                }
            } else {
                addArr.push(items[i])
            }
        };
        if (updateArr.length > 0 || addArr.length > 0) {
            me.mixUpdateRequest(updateArr, addArr);
        }
    },
    mixUpdateRequest: function(updateArr, addArr) {
        var me = rationOprObj;
        $.ajax({
            type:"POST",
            url:"api/mixUpdateRationItems",
            data:{"sectionID": me.currentSectionId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr)},
            dataType:"json",
            cache:false,
            timeout:5000,
            success:function(result){
                if (result.err) {
                    alert(err);
                    me.getRationItems(me.currentSectionId);
                } else {
                    var cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
                    if (!(me.currentRations["_SEC_ID_" + me.currentSectionId])) {
                        me.currentRations["_SEC_ID_" + me.currentSectionId] = [];
                        cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
                    }
                    if (addArr.length > 0) {
                        me.currentRations["_SEC_ID_" + me.currentSectionId] = cacheSection.concat(addArr);
                        cacheSection = me.currentRations["_SEC_ID_" + me.currentSectionId];
                    }
                    if (result.data.ops && result.data.ops.length > 0) {
                        for (var i = 0; i < result.data.ops.length; i++) {
                            for (var 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"];
                                }
                            }
                        }
                    }
                    for (var i = 0; i < updateArr.length; i++) {
                        for (var j = 0; j < cacheSection.length; j++) {
                            if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
                                cacheSection[j] = updateArr[i];
                            }
                        }
                    }
                    me.showRationItems(me.currentSectionId);
                }
            },
            error:function(){
            }
        });
    },
    getRationItems: function(sectionID){
        if (sectionID != -1) {
            var me = rationOprObj;
            me.currentSectionId = sectionID;
            if (me.currentRations["_SEC_ID_" + sectionID]) {
                me.showRationItems(sectionID);
            } else {
                $.ajax({
                    type:"POST",
                    url:"api/getRationItems",
                    data:{"sectionID": sectionID},
                    dataType:"json",
                    cache:false,
                    timeout:1000,
                    success:function(result){
                        if (result) {
                            me.currentRations["_SEC_ID_" + sectionID] = result.data;
                            me.showRationItems(sectionID);
                            sheetCommonObj.unShieldAllCells(me.workBook.getSheet(0));
                        } else {
                            sheetCommonObj.shieldAllCells(me.workBook.getSheet(0), me.setting);
                        }
                    },
                    error:function(err){
                        alert(err);
                    }
                })
            }
        }
    },
    showRationItems: function(sectionID){
        var me = rationOprObj;
        if (me.workBook) {
            if (me.currentRations && me.currentRations["_SEC_ID_" + sectionID] && me.currentRations["_SEC_ID_" + sectionID].length > 0) {
                var cacheSection = me.currentRations["_SEC_ID_" + sectionID];
                sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
                sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, cacheSection);
            } else {
                //清除ration数据及工料机数据
                sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
            }
        }
    }
}