ConstructionOperation/web/maintain/ration_repository/js/ration_glj.js

/**
 * Created by Tony on 2017/4/28.
 */
var rationGLJOprObj = {
    sheet: null,
    currentRationItem: null,
    distTypeTree: null,
    activeCell: null,
    cache: {},
    setting: {
        header:[
            {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@"},
            {headerName:"名称",headerWidth:400,dataCode:"name", dataType: "String"},
            {headerName:"单位",headerWidth:160,dataCode:"unit", dataType: "String"},
            {headerName:"基价单位",headerWidth:160, dataCode:"basePrice", dataType: "Number", formatter:"0.00",  precision: 2},
            {headerName:"定额消耗",headerWidth:160, dataCode:"consumeAmt", dataType: "Number", formatter: "0.000", precision: 3},
            {headerName:"类型",headerWidth:160,dataCode:"gljType", dataType: "String"}
        ],
        view:{
            comboBox:[],
            lockColumns:[1,2,3,5]
        }
    },
    getDistTypeTree: function (gljDistType) {
        let me = this;
        let distType;
        let distTypeTree = {
            prefix : 'gljDistType',
            distTypes: {},
            comboDatas: [],
            distTypesArr: []
        };
        gljDistType.forEach(function (typeData) {
            let typeObj = {
                data: typeData,
                children: [],
                parent: null
            }
            distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
            distTypeTree.distTypesArr.push(typeObj);
        });
        gljDistType.forEach(function (typeData) {
            distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
            let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
            if(parent){
                distType.parent = parent;
                parent.children.push(distType);
            }
        });
        distTypeTree.distTypesArr.forEach(function (distTypeObj) {
            if(distTypeObj.children.length === 0 && distTypeObj.data.fullName !== '普通机械' &&distTypeObj.data.fullName !== '机械组成物'
                && distTypeObj.data.fullName !== '机上人工'){
                distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
            }
            if(distTypeObj.data.fullName === '机械'){
                distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
            }
        });
        //me.distTypeTree = distTypeTree;
        return distTypeTree;
        //return distTypeTree.comboDatas;
    },
    getGljDistType: function (callback) {
        let me = this;
        $.ajax({
            type: 'post',
            url: "api/getGljDistType",
            dataType: 'json',
            success: function (result) {
                if(!result.error && callback){
                    me.distTypeTree = me.getDistTypeTree(result.data);
                    console.log(`me.distTypeTree`);
                    console.log(me.distTypeTree);
                    callback();
                }
            }
        })
    },
    buildSheet: function(sheet) {
        var me = this;
        me.sheet = sheet;
        me.getGljDistType(function () {
            me.onContextmenuOpr();
            sheetCommonObj.initSheet(me.sheet, me.setting, 30);
            me.rationGljDelOpr();
            me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
            me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
            me.sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
            //me.sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
        });
    },
    rationGljDelOpr: function () {
        let me = rationGLJOprObj, spreadBook = me.sheet.getParent();
        spreadBook.commandManager().register('rationGljDelete', function () {
            console.log(me.cache["_GLJ_" + me.currentRationItem.ID]);
            let sels = me.sheet.getSelections(), updateArr = [], removeArr = [], lockCols = me.setting.view.lockColumns;
            let cacheSection = me.cache["_GLJ_" + me.currentRationItem.ID], isUpdate = false;
            console.log(`sels`);
            console.log(sels);
            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);
                                    isUpdate = true;
                                    cacheSection.splice(sels[sel].row + i, 1);
                                    me.updateRationItem();
                                    //me.rationsCodes.splice(me.rationsCodes.indexOf(cacheSection[sels[sel].row + i].code), 1);
                                }
                            }
                        }
                    }
                    else{
                        if(sels[sel].col === 0){
                            $('#alertText').text("编号不能为空，修改失败！");
                            $('#alertModalBtn').click();
                            me.sheet.options.isProtected = true;
                            $('#alertModalCls').click(function () {
                                me.sheet.options.isProtected = false;
                            });
                            $('#alertModalCof').click(function () {
                                me.sheet.options.isProtected = false;
                            });
                        }
                        else if(sels[sel].col !== 0 && sels[sel].col !== 5 && !(sels[sel].col === 1 && sels.col + sels[sel].colCount -1 === 3)){
                            console.log(`enter`);
                            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){
                                                isUpdate = true;
                                                cacheSection[sels[sel].row + i][me.setting.header[col].dataCode] = 0;
                                                me.sheet.setValue(sels[sel].row + i, col, 0.00);
                                            }
                                        }
                                    }
                                    //updateArr.push(cacheSection[sels[sel].row + i]);
                                }
                            }
                        }
                    }
                }
            }
            if(isUpdate){
                me.updateRationItem();
                sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
                me.showGljItems(me.currentRationItem.ID);
            }
           /* if(updateArr.length > 0 || removeArr.length > 0){
                me.mixUpdateRequest(updateArr, [], removeArr);
            }*/

        });
        spreadBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
        spreadBook.commandManager().setShortcutKey('rationGljDelete', GC.Spread.Commands.Key.del, false, false, false, false);
    },
    onRangeChanged: function(sender, args) {
        if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
            var me = rationGLJOprObj, updateArr = [], removeArr = [];
            if (args.col == 0) {
                if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
                    var cacheArr = me.cache["_GLJ_" + 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.sheet, me.setting, -1);
                    me.showGljItems(me.currentRationItem.ID);
                }
            }

        }
    },
    onClipboardPasting: function(sender, args) {
        var me = rationGLJOprObj;
        /*if (args.cellRange.colCount != 1 || args.cellRange.col != 0 || !(me.currentRationItem)) {
            args.cancel = true;
        }*/
    },
    onClipboardPasted: function(e, info) {
        var me = rationGLJOprObj, repId = storageUtil.getSessionCache("RationGrp","repositoryID");
        if (repId) {
            if (info.cellRange.col == 0) {
                var tmpCodes = sheetCommonObj.analyzePasteData({header:[{dataCode: "code"}] }, info);
                var codes = [];
                for (var i = 0; i < tmpCodes.length; i++) {
                    codes.push(tmpCodes[i].code);
                }
                me.addGljItems(codes, repId);
            } else {
                //修改用量
                if(me.cache["_GLJ_" + me.currentRationItem.ID] && info.cellRange.row < me.cache["_GLJ_" + me.currentRationItem.ID].length){
                    let tempConsumes = sheetCommonObj.analyzePasteData(me.setting, info);
                    let maxCount = info.cellRange.row + info.cellRange.rowCount -1 > me.cache["_GLJ_" + me.currentRationItem.ID].length -1 ?
                        me.cache["_GLJ_" + me.currentRationItem.ID].length - info.cellRange.row : info.cellRange.rowCount;
                    for(let i = 0; i < maxCount; i++){
                        me.cache["_GLJ_" + me.currentRationItem.ID][info.cellRange.row + i].consumeAmt = tempConsumes[i].consumeAmt;
                    }
                    me.updateRationItem();
                    if(info.cellRange.row + info.cellRange.rowCount -1 >= me.cache["_GLJ_" + me.currentRationItem.ID].length -1){
                        me.sheet.suspendPaint();
                        for(let rowIdx = me.cache["_GLJ_" + me.currentRationItem.ID].length; rowIdx <= info.cellRange.row + info.cellRange.rowCount -1; rowIdx++){
                            me.sheet.setValue(rowIdx, info.cellRange.col, '');
                        }
                        me.sheet.resumePaint();
                    }
                }
                else if(info.cellRange.row >= me.cache["_GLJ_" + me.currentRationItem.ID].length){
                    me.sheet.suspendPaint();
                    for(let rowIdx = info.cellRange.row; rowIdx <= info.cellRange.row + info.cellRange.rowCount -1; rowIdx ++){
                        me.sheet.setValue(rowIdx, info.cellRange.col, '');
                    }
                    me.sheet.resumePaint();
                }
            }
        }
    },
    onCellEditEnd: function(sender, args){
        var me = rationGLJOprObj;
        if (args.col != 0) {
            var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
            if (args.row < cacheArr.length) {
                var editGlj = cacheArr[args.row];
                if (editGlj["consumeAmt"] != args.editingText) {
                    let parseNum = parseFloat(args.editingText);
                    if(isNaN(parseFloat(args.editingText))){
                        $('#alertModalBtn').click();
                        $('#alertText').text("定额消耗只能输入数值！");
                        args.sheet.options.isProtected = true;
                        $('#alertModalCls').click(function () {
                            args.sheet.options.isProtected = false;
                            args.sheet.setValue(args.row, args.col, editGlj['consumeAmt']);
                        });
                        $('#alertModalCof').click(function () {
                            args.sheet.options.isProtected = false;
                            args.sheet.setValue(args.row, args.col, editGlj['consumeAmt']);
                        })
                    }
                    else{
                        args.sheet.setValue(args.row, args.col, parseNum);
                        editGlj["consumeAmt"] = parseNum;
                        me.updateRationItem();
                    }
                }
            }
        } else {
            //重新更新工料机
            if (args.editingText == null || args.editingText.trim() == "") {
                //delete
                if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
                    var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
                    if (args.row < cacheArr.length) {
                        cacheArr.splice(args.row, 1);
                        me.updateRationItem();
                        sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
                        me.showGljItems(me.currentRationItem.ID);
                    }
                }
            } else {
                var repId = storageUtil.getSessionCache("RationGrp","repositoryID");
                if (repId) {
                    var codes = [];
                    codes.push(args.editingText.trim());
                    me.addGljItems(codes, repId);
                }
            }
        }
    },
    onContextmenuOpr: function () {
        $.contextMenu({
            selector: '#rdSpread',
            callback: function(key, options) {
                var m = "clicked: " + key;
                window.console && console.log(m) || alert(m);
            },
            items: {
                "insert": {name: "插入", callback: function (key, opt) {
                }},
                "delete": {name: "删除"}
            }
        });
    },

    addGljItems: function(codes, repId) {
        var me = this;
        $.ajax({
            type:"POST",
            url:"api/getGljItemsByCodes",
            data:{"gljCodes": JSON.stringify(codes), repId: repId},
            dataType:"json",
            cache:false,
            timeout:5000,
            success:function(result){
                sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
                if (result) {
                    var rstArr = [], dummyR = {gljId: 0, consumeAmt:0}, newAddArr = [];
                    for (var i = 0; i < result.data.length; i++) {
                        dummyR.gljId = result.data[i].ID;
                        rstArr.push(me.createRationGljDisplayItem(dummyR, result.data[i]));
                    }
                    if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
                        var cacheArr = me.cache["_GLJ_" + 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].gljId == rstArr[i].gljId) {
                                    hasDup = true;
                                    break;
                                }
                            }
                            if (!hasDup) {
                                newAddArr.push(rstArr[i]);
                            }
                        }
                        cacheArr.sort(function(a, b) {
                            var rst = 0;
                            if (a.code > b.code) rst = 1
                            else if (a.code < b.code) rst = -1;
                            return rst;
                        });
                        me.cache["_GLJ_" + me.currentRationItem.ID] = cacheArr.concat(newAddArr);
                    }
                    me.showGljItems(me.currentRationItem.ID);
                    if (newAddArr.length > 0) {
                        me.updateRationItem();
                    }
                }
                sheetCommonObj.lockCells(me.sheet, me.setting);
            },
            error:function(err){
                alert(err);
            }
        })
    },

    rationCal: function () {
        let me = this;
        let price = {gljType1: [], gljType2: [], gljType3: []}, rst = {labourPrice: 0, materialPrice: 0, machinePrice: 0}, rationBasePrc = 0;
        function round(v,e){
            var t=1;
            for(;e>0;t*=10,e--);
            for(;e<0;t/=10,e++);
            return Math.round(v*t)/t;
        }
        if(me.currentRationItem && me.cache['_GLJ_' + me.currentRationItem.ID]){
            let cacheArr = me.cache['_GLJ_' + me.currentRationItem.ID];
            cacheArr.forEach(function (gljData) {
                if(gljData.gljType && gljData.basePrice && gljData.consumeAmt){
                    let parent = me.distTypeTree.distTypes[me.distTypeTree.prefix + gljData.gljType].parent;
                    if(parent && parent.data.ID <= 3){
                        price['gljType' + parent.data.ID].push(round( gljData.basePrice * gljData.consumeAmt, 3));//取三位
                    }
                    if(!parent && gljData.gljType <= 3){
                        price['gljType' + gljData.gljType].push(round( gljData.basePrice * gljData.consumeAmt, 3));//取三位
                    }
                }
            });
            if(price.gljType1.length > 0){
                let labourPrice = 0;
                price.gljType1.forEach(function (singlePrc) {
                    labourPrice += singlePrc;
                });
                let roundPrice = round(labourPrice, 2);
                rst.labourPrice = roundPrice;
                rationBasePrc += roundPrice;
            }
            if(price.gljType2.length > 0){
                let materialPrice = 0;
                price.gljType2.forEach(function (singlePrc) {
                    materialPrice += singlePrc;
                });
                let roundPrice = round(materialPrice, 2);
                rst.materialPrice = roundPrice;
                rationBasePrc += roundPrice;
            }
            if(price.gljType3.length > 0){
                let machinePrice = 0;
                price.gljType3.forEach(function (singlePrc) {
                    machinePrice += singlePrc;
                });
                let roundPrice = round(machinePrice, 2);
                rst.machinePrice = roundPrice;
                rationBasePrc += roundPrice;
            }
            rst.rationBasePrc = rationBasePrc;
        }
        return rst;
    },
    updateRationItem: function() {
        var me = this, updateArr = [];
        if (me.currentRationItem) {
            me.currentRationItem.rationGljList = me.buildRationItemGlj();
            //recalculate ration basePrice
            let price = me.rationCal();
            me.currentRationItem.labourPrice = price.labourPrice;
            me.currentRationItem.materialPrice = price.materialPrice;
            me.currentRationItem.machinePrice = price.machinePrice;
            me.currentRationItem.basePrice = price.rationBasePrc;
            updateArr.push(me.currentRationItem);
            rationOprObj.mixUpdateRequest(updateArr, [], []);
        }
    },

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

    createRationGljDisplayItem: function(rItem, repGlj) {
        var rst = {};
        rst.gljId = rItem.gljId;
        rst.consumeAmt = rItem.consumeAmt;
        rst.code = repGlj.code;
        rst.name = repGlj.name;
        rst.specs = repGlj.specs;
        rst.unit = repGlj.unit;
        rst.basePrice = repGlj.basePrice;
        rst.gljType = repGlj.gljType;
        return rst;
    },
    getGljItems: function(rationItem, callback) {
        var me = this, rationID = rationItem.ID, rationGljList = rationItem.rationGljList;
        me.currentRationItem = rationItem;
        if (me.cache["_GLJ_" + rationID]) {
            me.showGljItems(rationID);
            sheetCommonObj.lockCells(me.sheet, me.setting);
        } else {
            var gljIds = [];
            for (var i = 0; i < rationGljList.length; i++) {
                gljIds.push(rationGljList[i].gljId);
            }
            $.ajax({
                type:"POST",
                url:"api/getGljItemsByIds",
                data:{"gljIds": JSON.stringify(gljIds)},
                dataType:"json",
                cache:false,
                timeout:5000,
                success:function(result){
                    sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
                    if (result) {
                        var cacheArr = [];
                        for (var i = 0; i < result.data.length; i++) {
                            for (var j = 0; j < rationGljList.length; j++) {
                                if (rationGljList[j].gljId == result.data[i].ID) {
                                    cacheArr.push(me.createRationGljDisplayItem(rationGljList[j], result.data[i]));
                                    break;
                                }
                            }
                        }
                        function compare(){
                            return function (a, b) {
                                let rst = 0;
                                if (a.code > b.code) {
                                    rst = 1;
                                }
                                else if (a.code < b.code) {
                                    rst = -1;
                                }
                                return rst;
                            }
                        }
                        cacheArr.sort(compare());
                        me.cache["_GLJ_" + rationID] = cacheArr;
                        me.showGljItems(rationID);
                    }
                    sheetCommonObj.lockCells(me.sheet, me.setting);
                    callback();
                },
                error:function(err){
                    alert(err);
                }
            })
        }
    },
    showGljItems: function(rationID) {
        var me = this;
        if (me.cache["_GLJ_" + rationID]) {
            sheetCommonObj.showData(me.sheet, me.setting, me.cache["_GLJ_" + rationID], me.distTypeTree);
        }
    }
}