ConstructionCost/web/building_saas/main/js/views/std_bills_lib.js

/**
 * Standard Bills Lib
 * Created by Mai on 2017/5/16.
 */

var billsLibObj = {
    stdBillsSpread: null,
    stdBillsJobSpread: null,
    stdBillsFeatureSpread: null,
    refreshSettingForHint: function () {
        TREE_SHEET_HELPER.initSetting($('#stdBillsSpread')[0], billsLibObj.stdBillsTreeSetting);
    },
    checkBillsSpread: function () {
        if (!this.stdBillsSpread) {
            this.stdBillsSpread = SheetDataHelper.createNewSpread($('#stdBillsSpread')[0]);
            // 刷新setting中记录的spread的位置
            this.refreshSettingForHint();
        }
    },
    refreshBillsSpread: function () {
        if (this.stdBillsSpread) {
            this.stdBillsSpread.refresh();
        }
    },
    checkBillsRelaSpread: function () {
        if (!this.stdBillsJobSpread) {
            this.stdBillsJobSpread = SheetDataHelper.createNewSpread($('#stdBillsJobs')[0]);
        }
        if (!this.stdBillsFeatureSpread) {
            this.stdBillsFeatureSpread = SheetDataHelper.createNewSpread($('#stdBillsFeatures')[0]);
        }
    },
    refreshBillsRelaSpread: function () {
        if (this.stdBillsJobSpread) {
            this.stdBillsJobSpread.refresh();
        }
        if (this.stdBillsFeatureSpread) {
            this.stdBillsFeatureSpread.refresh();
        }
    },
    clearHighLight: function (spread) {
        if (spread) {
            let sheet = spread.getActiveSheet();
            sheet.suspendPaint();
            sheet.getRange(0, -1, sheet.getRowCount(), -1, GC.Spread.Sheets.SheetArea.viewport).backColor(undefined);
            sheet.resumePaint();
        }
    },
    setTagForHint: function (datas) {
        let sheet = this.stdBillsSpread.getActiveSheet();
        sheet.suspendPaint();
        sheet.suspendEvent();
        for(let i = 0, len = sheet.getRowCount(); i < len; i++){
            sheet.setTag(i, 2, '');
        }
        for(let i = 0, len = datas.length; i < len; i++){
            sheet.setTag(i, 2, datas[i].ruleText ? datas[i].ruleText : '');
        }
        sheet.resumePaint();
        sheet.resumeEvent();
    },
    loadStdBillsLib: function () {
        let i, select = $('#stdBillsLibSelect');
        select.empty();

        let bills_lib = projectInfoObj.projectInfo.engineeringInfo.bill_lib;
        bills_lib.forEach(function (data) {
            var option = $('<option>').val(data.id).text(data.name);
            select.append(option);
        });
        if (select.children.length !== 0) {
            billsLibObj.loadStdBills(select.val());
        }
    },
    loadStdBills: function (stdBillsLibID) {
        var that = this;
        var stdBillsJobData, stdBillsFeatureData, stdBills;
        var stdBillsTree  = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: true});
        var stdBillsTreeController = TREE_SHEET_CONTROLLER.createNew(stdBillsTree, billsLibObj.stdBillsSpread.getActiveSheet(), billsLibObj.stdBillsTreeSetting);
        var findData = function (value, field, Array) {
            var i = 0;
            for (i = 0; i < Array.length; i++) {
                if (value[field] === Array[i][field]) {
                    return Array[i];
                }
            }
            return null;
        };
        let sortJobsAndFeatures = function (arr) {
            arr.sort(function (a, b) {
                let rst = 0;
                if(a.serialNo > b.serialNo) rst = 1;
                else if(a.serialNo < b.serialNo) rst = -1;
                return rst;
            });
        };
        var getBillsJobs = function (node) {
            var jobs = [], i, jobData = null;
            if (stdBillsJobData && node && node.data.jobs) {
                for (i = 0; i < node.data.jobs.length; i++) {
                    jobData = findData(node.data.jobs[i], 'id', stdBillsJobData);
                    if (jobData) {
                        jobData.serialNo = node.data.jobs[i].serialNo;
                        jobs.push(jobData);
                    }
                }
            }
            sortJobsAndFeatures(jobs);
            return jobs;
        };
        var getBillsFeatures = function (node) {
            var features = [], i, featureData = null;
            if (stdBillsFeatureData && node && node.data.items) {
                for (i = 0; i < node.data.items.length; i++) {
                    featureData = findData(node.data.items[i], 'id', stdBillsFeatureData);
                    if (featureData) {
                        featureData.serialNo = node.data.items[i].serialNo;
                        features.push(featureData);
                    }
                }
            }
            sortJobsAndFeatures(features);
            return features;
        };
        var showJobs = function (jobs) {
            SheetDataHelper.loadSheetHeader(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet());
            SheetDataHelper.loadSheetData(billsLibObj.jobsSetting, billsLibObj.stdBillsJobSpread.getActiveSheet(), jobs);
        };
        var showFeatures = function (features) {
            SheetDataHelper.loadSheetHeader(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet());
            SheetDataHelper.loadSheetData(billsLibObj.featuresSetting, billsLibObj.stdBillsFeatureSpread.getActiveSheet(), features);
        };
        var showJobsAndFeatures = function (node) {
            $('#stdBillsJobTab').show();
            $('#stdBillsRemarkTab').hide();
            billsLibObj.refreshBillsRelaSpread();
            billsLibObj.checkBillsRelaSpread();
            sortJobsAndFeatures(getBillsJobs(node));
            showJobs(getBillsJobs(node));
            showFeatures(getBillsFeatures(node));
        };
        var showBillsRemark = function (node) {
            $('#stdBillsJobTab').hide();
            $('#stdBillsRemarkTab').show();
            $('#stdBillsRemark').text(node && node.data.recharge ? node.data.recharge : '');
        };
        var showBillsRela = function (node) {
            if (node && node.children.length === 0) {
                showJobsAndFeatures(node);
            } else {
                showBillsRemark(node);
            }
        };

        CommonAjax.post('/stdBillsEditor/getJobContent', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
            stdBillsJobData = datas;
        }, function () {
            stdBillsJobData = [];
        });
        CommonAjax.post('/stdBillsEditor/getItemCharacter', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
            stdBillsFeatureData = datas;
        }, function () {
            stdBillsFeatureData = [];
        });
        CommonAjax.post('/stdBillsEditor/getBills', {userId: userID, billsLibId: stdBillsLibID}, function (datas) {
            stdBills = datas;
            stdBillsTree.loadDatas(stdBills);
            stdBillsTreeController.showTreeData();
            billsLibObj.setTagForHint(datas);
            showBillsRela(stdBillsTree.firstNode());

            stdBillsTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, showBillsRela);
            that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
            that.stdBillsSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (sender, args) {
                let selectNode = stdBillsTree.items[args.row];
                let name = selectNode.data.name;
                if (stdBillsTree.items[args.row].children.length === 0) {
                    //特征及内容转化
                    pageCCOprObj.setItemContentNode(stdBillsTree.items[args.row], getBillsJobs(stdBillsTree.items[args.row]), getBillsFeatures(stdBillsTree.items[args.row]), name);
                    if (/\//.test(selectNode.data.unit)) {
                        let existB = projectObj.project.Bills.sameStdCodeBillsData(selectNode.data.code);
                        if (existB) {
                            let std = JSON.parse(JSON.stringify(selectNode.data));
                            std.unit = existB.unit;
                            ProjectController.addBills(projectObj.project, projectObj.mainController, std);
                        } else {
                            ConfirmModal.stdBillsUnit.check(selectNode.data, function (std) {
                                ProjectController.addBills(projectObj.project, projectObj.mainController, std);
                            });
                        }
                    } else {
                        ProjectController.addBills(projectObj.project, projectObj.mainController, selectNode.data);
                    }
                }
            });
        }, function () {
            that.stdBillsSpread.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
        });

        $('#stdBillsSearch>span>button').click(function () {
            var keyword = $('#stdBillsSearch>input').val();

            if (!keyword || keyword === '') {return}

            var result = stdBillsTree.items.filter(function (item) {
                var codeIs = item.data.code ? item.data.code.indexOf(keyword) !== -1 : false;
                var nameIs = item.data.name ? item.data.name.indexOf(keyword) !== -1 : false;
                return codeIs || nameIs;
            });
            result.sort(function (x, y) {
                return x.serialNo() - y.serialNo();
            });
            if (result.length !== 0) {
                var sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
                stdBillsTreeController.setTreeSelected(result[0]);
                billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);

                for (let node of result) {
                    billsLibObj.stdBillsSpread.getActiveSheet().getRange(node.serialNo(), -1, 1, -1).backColor('lemonChiffon');
                }

                $('#nextStdBills').show();
                $('#nextStdBills').click(function () {
                    var cur = stdBillsTree.selected, resultIndex = result.indexOf(cur), sel = billsLibObj.stdBillsSpread.getActiveSheet().getSelections();
                    if (resultIndex === result.length - 1) {
                        stdBillsTreeController.setTreeSelected(result[0]);
                        billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[0].serialNo(), sel[0].col, 1, 1);
                    } else {
                        stdBillsTreeController.setTreeSelected(result[resultIndex + 1]);
                        billsLibObj.stdBillsSpread.getActiveSheet().setSelection(result[resultIndex + 1].serialNo(), sel[0].col, 1, 1);
                    }
                });
            } else {
                billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
                $('#nextStdBills').hide();
            }
            $('#stdBillsSearchResultCount').text('搜索结果：' + result.length);
            $('#stdBillsSearchResult').show();
        });
    },
    stdBillsTreeSetting: {
        "treeCol": 0,
        "emptyRows":0,
        "headRows":1,
        "headRowHeight":[
            40
        ],
        "defaultRowHeight": 21,
        "cols":[{
            "width":160,
            "readOnly": true,
            "head":{
                "titleNames":["项目编码"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"]
            },
            "data":{
                "field":"code",
                "vAlign":1,
                "hAlign":0,
                "font":"Arial"
            }
        }, {
            "width":220,
            "readOnly": true,
            "head":{
                "titleNames":["项目名称"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"]
            },
            "data":{
                "field":"name",
                "vAlign":1,
                "hAlign":0,
                "font":"Arial"
            }
        }, {
            "width":45,
            "readOnly": true,
            "showHint": true,
            "head":{
                "titleNames":["计量单位"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"],
                "wordWrap": true
            },
            "data":{
                "field":"unit",
                "vAlign":1,
                "hAlign":1,
                "font":"Arial"
            }
        }/*, {
            "width":100,
            "readOnly": true,
            "showHint": true,
            "head":{
                "titleNames":["工程量计算规则"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"]
            },
            "data":{
                "field":"ruleText",
                "vAlign":1,
                "hAlign":0,
                "font":"Arial"
            }
        }*/]
    },
    jobsSetting: {
        "emptyRows":0,
        "headRows":1,
        "headRowHeight":[25],
        "defaultRowHeight": 21,
        "cols":[{
            "width":160,
            "readOnly":true,
            "head":{
                "titleNames":["工作内容"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"]
            },
            "data":{
                "field":"content",
                "vAlign":0,
                "hAlign":3,
                "font":"Arial"
            }
        }]
    },
    featuresSetting: {
        "emptyRows":0,
        "headRows":1,
        "headRowHeight":[25],
        "defaultRowHeight": 21,
        "cols":[{
            "width":160,
            "readOnly":true,
            "head":{
                "titleNames":["项目特征"],
                "spanCols":[1],
                "spanRows":[1],
                "vAlign":[1],
                "hAlign":[1],
                "font":["Arial"]
            },
            "data":{
                "field":"content",
                "vAlign":0,
                "hAlign":3,
                "font":"Arial"
            }
        }]
    }
};

function addEventOnResize(fn){
    let originFn = window.onresize;
    window.onresize =function () {
        originFn && originFn();
        fn();
    }
}
addEventOnResize(billsLibObj.refreshSettingForHint);

$('#stdBillsTab').bind('click', function () {
    refreshSubSpread();//subSpread、jobSpread、itemSpread显示问题
    $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() -  $(".tools-bar-height-q").height() - 202);
    var select = $('#stdBillsLibSelect');
    billsLibObj.refreshBillsSpread();
    billsLibObj.refreshBillsRelaSpread();
    billsLibObj.checkBillsSpread();
    if (select[0].options.length === 0) {
        billsLibObj.loadStdBillsLib();
    };
});
$('#stdBillsLibSelect').change(function () {
    $('#stdBillsSearchResult').hide();
    $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() -  $(".tools-bar-height-q").height() - 202);
    billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);

    var select = $(this);
    if (this.children.length !== 0) {
        billsLibObj.loadStdBills(select.val());
    }
});

// 关闭搜索结果
$('#closeSearchStdBills').click(function () {
    $('#stdBillsSearchResult').hide();
    $(".main-data-side-q").height($(window).height() - $(".header").height() - $(".toolsbar").height() -  $(".tools-bar-height-q").height() - 202);
    billsLibObj.clearHighLight(billsLibObj.stdBillsSpread);
});