ConstructionCost/web/maintain/ration_repository/js/ration_coe.js

/**
 * Created by CSL on 2017-06-08.
 */
var rationCoeOprObj = {
    workBook: null,
    libID: -1,
    currentRationItem: null,
    cache: {},
    setting: {
        header:[
            {headerName:"编号",headerWidth:120,dataCode:"ID", dataType: "Number"},
            {headerName:"名称",headerWidth:400,dataCode:"name", dataType: "String"},
            {headerName:"内容",headerWidth:300,dataCode:"content", dataType: "String"}
        ],
        view:{
            comboBox:[],
            lockColumns:[1,2]
        }
    },
    buildSheet: function(container) {
        var me = this;
        me.libID = storageUtil.getSessionCache("RationGrp","repositoryID");
        me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
        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.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 = rationCoeOprObj, updateArr = [], removeArr = [];
            if (args.col == 0) {
                if (me.cache["_Coe_" + me.currentRationItem.ID]) {
                    var cacheArr = me.cache["_Coe_" + me.currentRationItem.ID];
                    for (var i = args.rowCount - 1; i >= 0; i--) {
                        if (args.row + i < cacheArr.length) {
                            cacheArr.splice(args.row + i, 1);
                        }
                    }
                    me.updateRationItem();
                    sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
                    me.showCoeItems(me.currentRationItem.ID);
                }
            }

        }
    },
/*    onClipboardPasting: function(sender, args) {
        var me = rationCoeOprObj;
        if (args.cellRange.colCount != 1 || args.cellRange.col != 0 || !(me.currentRationItem)) {
            args.cancel = true;
        }
    },
    onClipboardPasted: function(e, info) {
        var me = rationCoeOprObj;
        if (me.libID) {
            if (info.cellRange.col == 0) {
                var tmpCoeIDs = sheetCommonObj.analyzePasteData({header:[{dataCode: "ID"}] }, info);
                var IDs = [];
                for (var i = 0; i < tmpCoeIDs.length; i++) {
                    IDs.push(tmpCoeIDs[i]);
                }
                me.addCoeItems(IDs);
            } else {
                //修改用量
            }
        }
    },*/
    onCellEditEnd: function(sender, args){
        var me = rationCoeOprObj;
        if (args.col == 0) {   // 编号列
            if (args.editingText == null || args.editingText.trim() == "") {  //delete
                var cacheArr = me.cache["_Coe_" + me.currentRationItem.ID];
                if (cacheArr) {
                    if (args.row < cacheArr.length) {
                        cacheArr.splice(args.row, 1);
                        me.updateRationItem();
                        sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
                        me.showCoeItems(me.currentRationItem.ID);
                    }
                }
            } else {
                if (me.libID) {
                    var coeIDs = [];
                    coeIDs.push(args.editingText.trim());
                    me.addCoeItems(coeIDs, me.libID);
                }
            }
        }
    },

    addCoeItems: function(coeIDs) {
        var me = this;
        $.ajax({
            type:"POST",
            url:"api/getCoeItemsByIDs",
            data: {"data": JSON.stringify({"libID": me.libID, "coeIDs": coeIDs})},
            dataType:"json",
            cache:false,
            timeout:5000,
            success:function(result){
                sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
                if (result) {
                    var rstArr = [], newAddArr = [];
                    for (var i = 0; i < result.data.length; i++) {
                        rstArr.push(result.data[i]);
                    };
                    if (me.cache["_Coe_" + me.currentRationItem.ID]) {
                        var cacheArr = me.cache["_Coe_" + me.currentRationItem.ID];
                        for (var i = 0; i < rstArr.length; i++) {
                            var hasDup = false;
                            for (var j = 0; j < cacheArr.length; j++) {
                                if (cacheArr[j] == rstArr[i]) {
                                    hasDup = true;
                                    break;
                                }
                            }
                            if (!hasDup) {
                                newAddArr.push(rstArr[i]);
                            }
                        }
                        cacheArr.sort(function(a, b) {
                            var rst = 0;
                            if (a > b) rst = 1
                            else if (a < b) rst = -1;
                            return rst;
                        });
                        me.cache["_Coe_" + me.currentRationItem.ID] = cacheArr.concat(newAddArr);
                    }
                    me.showCoeItems(me.currentRationItem.ID);
                    if (newAddArr.length > 0) {
                        me.updateRationItem();
                    }
                }
                sheetCommonObj.lockCells(me.workBook.getSheet(0), me.setting);
            },
            error:function(err){
                alert(err);
            }
        })
    },

    updateRationItem: function() {
        var me = this, updateArr = [];
        if (me.currentRationItem) {
            me.currentRationItem.rationCoeList = me.getCoeIDsArr();
            updateArr.push(me.currentRationItem);
            rationOprObj.mixUpdateRequest(updateArr, [], []);
        }
    },

    getCoeIDsArr: function(){
        var me = this, rst = [];
        if (me.currentRationItem && me.cache["_Coe_" + me.currentRationItem.ID]) {
            var cacheArr = me.cache["_Coe_" + me.currentRationItem.ID];
            for (var i = 0; i < cacheArr.length; i++) {
                rst.push(cacheArr[i].ID);
            }
        }
        return rst;
    },

    getCoeItems: function(rationItem) {
        var me = this, rationID = rationItem.ID, rationCoeList = rationItem.rationCoeList;
        if (rationCoeList == undefined){return;};

        me.currentRationItem = rationItem;
        if (me.cache["_Coe_" + rationID]) {
            me.showCoeItems(rationID);
            sheetCommonObj.lockCells(me.workBook.getSheet(0), me.setting);
        } else {
            $.ajax({
                type:"POST",
                url:"api/getCoeItemsByIDs",
                data: {"data": JSON.stringify({"libID": me.libID, "coeIDs": rationCoeList})},
                dataType:"json",
                cache:false,
                timeout:5000,
                success:function(result){
                    sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);

                    if (result.data) {
                        var cacheArr = [];
                        for (var i = 0; i < result.data.length; i++) {
                            for (var j = 0; j < rationCoeList.length; j++) {
                                if (rationCoeList[j] == result.data[i].ID) {
                                    cacheArr.push(result.data[i]);
                                    break;
                                }
                            }
                        };
                        me.cache["_Coe_" + rationID] = cacheArr;
                        me.showCoeItems(rationID);
                    }
                    sheetCommonObj.lockCells(me.workBook.getSheet(0), me.setting);
                },
                error:function(err){
                    alert(err);
                }
            })
        }
    },
    showCoeItems: function(rationID) {
        var me = this;
        if (me.cache["_Coe_" + rationID]) {
            sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, me.cache["_Coe_" + rationID]);
        }
    }
}