ConstructionCost/web/building_saas/pm/js/pm_newMain.js

/**
 * 项目管理相关js
 *
 * @author CaiAoLin
 * @date 2017/8/22
 * @version
 */
let Tree = null;//
let movetoZTree = null;
let copytoZTree = null;
let engineering = [];
let feeRateData = [];
let isSaving = false;
let projectProperty = [];
let fileDelObj = null;
let curStep = 1; //当前在第几步
let infoData = null; //建设项目基本信息数据 （完整）
//需要的建设项目基本信息 （根据文件类型，因为需要切换文件类型获取不同的基本信息
//为了减少请求，infoData获取完整的基本信息数据，needfulInfoData标记当前文件类型所需基本信息数据）
let needfulInfoData = null;
let featureData = null; //工程特征数据
let projectType = {
    folder: 'Folder',
    project: 'Project',
    engineering: 'Engineering',
    tender: 'Tender'
};
let fileType = {
    unitPriceFile: 'UnitPriceFile',
    feeRateFile: 'FeeRateFile'
};

let taxTypeMap = {
    1:"一般计税",
    2:"简易计税"
};
//文件类型：招标，投标
const FileKind = {
    tender: 1, //投标
    bid: 2  //招标
};
let curTaxType = 1; //1:"一般计税",2:"简易计税"
let curValutionType = 'bill',   //计价方式默认只有清单计价
    curValuation = billValuation[0].id, //计价规则初始取第一个
    curValuationName = billValuation[0].name; //计价规则初始取第一个
/*
* 地区，同一费用定额下不同地区有不同单价，则新建单位工程时需要选择地区项
* 地区项为空的时候，前端不显示该下拉项，地区的赋值覆盖在over_write相关文件中
* */
let regions = [];

function isDef(v) {
    return typeof v !== 'undefined' && v !== null;
}
let keyupTime = 0,
    delayTime = 500;
function delayKeyup(callback) {
    let nowTime = Date.now();
    keyupTime = nowTime;
    setTimeout(function () {
        if (nowTime - keyupTime == 0) {
            callback();
        }
    }, delayTime);
}
const addPath = {p_e_t: 'p_e_t', e_t: 'e_t', t: 't'};
//操作状态
const STATE = {
    addingTender: false,
    addingEng: false,
    addingProject: false,
    addingFolder: false,
    deleting: false,
    importing: false
};
const projTreeObj = {
    tree: null,
    workBook: null,
    copyToWorkBook:null,
    replaceWorkBook:null,
    copySelected:null,
    preSelection: null,
    changeInfo:null,
    setting: {
        tree: {
            id: 'ID',
            pid: 'ParentID',
            nid: 'NextSiblingID',
            rootId: -1,
            autoUpdate: false
        },
        //0.48 0.13 0.15 0.15 0.09
        header: [
            {name: '工程列表', dataCode: 'name', width: 300, vAlign: 'center', hAlign: 'left'},
            {name: '工程造价', dataCode: 'engineeringCost', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '工程专业', dataCode: 'feeStandardName', width: 100, vAlign: 'center', hAlign: 'left'},
            {name: '单价文件', dataCode: 'unitPriceFile', width: 140, vAlign: 'center', hAlign: 'left'},
            {name: '费率文件', dataCode: 'feeRateFile', width: 140, vAlign: 'center', hAlign: 'left'},
            {name: '创建日期', dataCode: 'createDateTime', width: 100, vAlign: 'center', hAlign: 'center'},
            {name: '分部分项合计', dataCode: 'subEngineering', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '措施项目合计', dataCode: 'measure', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '其他项目合计', dataCode: 'other', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            //{name: '安全文明施工费', dataCode: 'safetyConstruction', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '规费', dataCode: 'charge', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '税金', dataCode: 'tax', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '占造价比例(%)', dataCode: 'rate', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '建筑面积', dataCode: 'buildingArea', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'},
            {name: '单方造价', dataCode: 'perCost', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}
        ],
        //选中行颜色
        style: {
            defalutBackColor: 'White',
            selectedColor: '#BBFFFF'
        },
        options: {
            tabStripVisible:  false,
            allowContextMenu: false,
            allowCopyPasteExcelStyle : false,
            allowExtendPasteRange: false,
            allowUserDragDrop : false,
            allowUserDragFill: false,
            scrollbarMaxAlign : true,
            showDragDropTip:false
        }
    },
    copyToSetting:{
        header: [
            {name: '工程列表', dataCode: 'name', width: 550, vAlign: 'center', hAlign: 'left'}
        ],
        //选中行颜色
        style: {
            defalutBackColor: 'White',
            selectedColor: '#BBFFFF'
        },
        options: {

            tabStripVisible:  false,
            allowCopyPasteExcelStyle : false,
            allowExtendPasteRange: false,
            allowUserDragDrop : false,
            allowUserDragFill: false,
            scrollbarMaxAlign : true,
            showDragDropTip:false,
            allowContextMenu: false
        }
    },
    replaceSetting:{
        header: [
            {name: '工程列表', dataCode: 'name', width: 250, vAlign: 'center', hAlign: 'left'},
            {name: '选择', dataCode: 'selected', width: 50, vAlign: 'center', cellType:'checkBox'}
        ],
        //选中行颜色
        style: {
            defalutBackColor: 'White',
            selectedColor: '#BBFFFF'
        },
        options: {
            tabStripVisible:  false,
            allowCopyPasteExcelStyle : false,
            allowExtendPasteRange: false,
            allowUserDragDrop : false,
            allowUserDragFill: false,
            scrollbarMaxAlign : true,
            showDragDropTip:false,
            allowContextMenu: false
        }
    },
    renderSheetFuc: function (sheet, fuc) {
        sheet.suspendPaint();
        sheet.suspendEvent();
        fuc();
        sheet.resumePaint();
        sheet.resumeEvent();
    },
    setOptions: function (workbook, opts) {
        for(let opt in opts){
            workbook.options[opt] = opts[opt];
        }
    },
    bindEvent: function (workBook) {
        const _events = GC.Spread.Sheets.Events;
        let sheet = workBook.getActiveSheet();
        //改变选中节点set selected
        sheet.bind(_events.SelectionChanging, this.onSelectionChanging);
        sheet.bind(_events.EditStarting, this.onCellEditing);
        sheet.bind(_events.ClipboardPasting,this.onCellEditing);
        workBook.bind(_events.DragDropBlock, this.onDragDropBlock);
        workBook.bind(GC.Spread.Sheets.Events.ButtonClicked, this.changeFileClick)
    },
    buildHeader: function (sheet, headers) {
        let me = this;
        let fuc = function () {
            //sheet.options.isProtected = true;  //为了拖动功能，这里不设置protect,输入限制在editstarting控制
            sheet.options.protectionOptions = {
                allowResizeRows: true,
                allowResizeColumns: true
            };
            sheet.setColumnCount(headers.length);
            sheet.setRowHeight(0, 40, GC.Spread.Sheets.SheetArea.colHeader);
            let workBookWidth = getWorkBookWidth();
            for(let i = 0, len = headers.length; i < len; i++){
                sheet.setValue(0, i, headers[i].name, GC.Spread.Sheets.SheetArea.colHeader);
                let width = headers[i].width;
                sheet.setColumnWidth(i, width, GC.Spread.Sheets.SheetArea.colHeader);
                if (headers[i].formatter) {
                    sheet.setFormatter(-1, i, headers[i].formatter, GC.Spread.Sheets.SheetArea.viewport);
                }
            }
        };
        me.renderSheetFuc(sheet, fuc);
    },
    buildSheet: function (workBook,spreadID,setting) {//改成和复制项目spread共用
        let newWorkBook = workBook;
        if(!workBook){
            newWorkBook = new GC.Spread.Sheets.Workbook($('#'+spreadID)[0], {sheetCount: 1});
            this.setOptions(newWorkBook, setting.options);
            this.buildHeader(newWorkBook.getActiveSheet(), setting.header);
            this.bindEvent(newWorkBook);
            this.loadContextMenu();
            this.loadStartMenu();
        }else {
            workBook.refresh();
        }
        return newWorkBook;
    },
    // 获取新建按钮是否是disabled
    getAddBtnDisabled: function (action) {
        switch (action) {
            case projectType.folder:
            case projectType.project:
            case projectType.tender:
                return false;
            case projectType.engineering:
                const node = projTreeObj.tree.selected;
                return !node || node.data.projType === projectType.folder;
            default:
                return true;
        }
    },
    refreshAddMenuItems: function () {
        const items = [{
            el: $('#addFolderSub'),
            action: projectType.folder,
        }, {
            el: $('#addProjectSub'),
            action: projectType.project,
        }, {
            el: $('#addEngSub'),
            action: projectType.engineering,
        }, {
            el: $('#addTenderSub'),
            action: projectType.tender,
        }];
        items.forEach(item => {
            const disabled = this.getAddBtnDisabled(item.action);
            if (disabled) {
                item.el.addClass('disabled');
            } else {
                item.el.removeClass('disabled');
            }
        });
    },
    //右键菜单项
    contextMenuItems: {
        addFolder: {
            name: "新建文件夹",
            icon: 'fa-folder-o',
            disabled: function () {
                return projTreeObj.getAddBtnDisabled(projectType.folder);
            },
            callback: function (key, opt) {
                $("#add-folder-dialog").modal("show");
            }
        },
        addProject: {
            name: "新建建设项目",
            icon: 'fa-cubes',
            disabled: function () {
                return projTreeObj.getAddBtnDisabled(projectType.project);
            },
            callback: function (key, opt) {
                $('#add-project-dialog').modal('show');
            },
        },
        addEngineering: {
            name: "新建单项工程",
            icon: 'fa-cube',
            disabled: function () {
                return projTreeObj.getAddBtnDisabled(projectType.engineering);
            },
            callback: function (key, opt) {
                let selectedItem = projTreeObj.tree.selected;
                try {
                    if(selectedItem !== null  && selectedItem.data.projType !== projectType.folder){
                        $("#add-engineering-dialog").modal("show");
                    }

                } catch (error) {
                    alert(error);
                }
            }
        },
        addTender: {
            name: "新建单位工程",
            icon: 'fa-sticky-note-o',
            disabled: function () {
                return projTreeObj.getAddBtnDisabled(projectType.tender);
            },
            callback: function (key, opt) {
                //弹出新建单位工程之前，判断当前使用版本，且当前使用单位工程数是否已到最大值
                let selectedItem = projTreeObj.tree.selected;
                $("#add-tender-dialog").modal("show");
            }
        },
        rename: {
            name: "重命名",
            icon: 'fa-edit',
            disabled: function () {
                return !projTreeObj.tree.selected;
            },
            callback: function (key, opt) {
                $('#rename-name').val(projTreeObj.tree.selected.data.name ? projTreeObj.tree.selected.data.name : '');
                $('#rename-dialog').modal('show');
                setTimeout(function () {
                    $('#rename-name').focus();
                }, 300);
            }
        },
        delete: {
            name: "删除",
            icon: 'fa-remove',
            disabled: function () {
                let node = projTreeObj.tree.selected;
                return !node || (node.data.projType === projectType.folder && node.children.length > 0);
            },
            callback: function (key, opt) {
                if (projTreeObj.tree && projTreeObj.tree.selected) {
                    $('#del').modal('show');
                }
            }
        },
        copyTo: {
            name: "复制到",
            icon: 'fa-copy',
            disabled: function () {
                let node = projTreeObj.tree.selected;
                return !(node && node.data.projType === projectType.tender);
            },
            callback: function (key, opt) {
                let selectedItem = projTreeObj.tree.selected;
                try {
                    let selectedType = selectedItem !== null && selectedItem.data !== undefined ?
                        selectedItem.data.projType : '';
                    if (selectedType !== projectType.tender) {
                        throw '请选择单位工程进行复制';
                    }
                } catch (error) {
                    alert(error);
                    return false;
                }
                //更新选中项目缓存
                $('#copy-to-dialog').modal('show');
            }
        },
        share: {
            name: "分享",
            icon: 'fa-share',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                return !selectedItem;
                //return !(selectedItem && selectedItem.data.projType === projectType.tender);
            },
            callback: function (key, opt) {
                let selected = projTreeObj.tree.selected;
                $('#sharePhone').val('');
                $('#share-info').hide();
                $('#shareFindDiv').hide();
                setShareToModal(selected);
                $('#share').modal('show');
                setTimeout(function () {
                    $('#sharePhone').focus();
                }, 200);
            }
        },
        importInterface: {
            name: '导入招投标接口文件',
            icon: 'fa-cloud-upload',
            visible: function () {
                const names = ['重庆定额(2018)', '广东定额(2018)'];
                return compilationData && names.includes(compilationData.name);
            },
            callback: function () {
                $('#importInterface').modal('show');
            }
        },
        manageFiles: {
            name: "管理相关文件",
            icon: 'fa-list',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                return !(selectedItem && selectedItem.data.projType !== projectType.folder);
            },
            callback: function (key, opt) {
                setDataToSideBar();
                $(".slide-sidebar").animate({width:"440"}).addClass("open");
                setTimeout(function () {
                    $("body").bind('click', function (event) {
                        var e = event || window.event; //浏览器兼容性
                        if (!$(event.target).is('a')) {
                            var elem = event.target || e.srcElement;
                            while (elem) { //循环判断至跟节点，防止点击的是div子元素
                                if (elem.className == "open-sidebar" || elem.className == 'slide-sidebar open') {
                                    return false;
                                }
                                if($(elem).attr('id') && $(elem).attr('id') === 'del-wj'){
                                    return false;
                                }
                                elem = elem.parentNode;
                            }
                            $(".slide-sidebar").animate({width: "0"}).removeClass("open")// 关闭处理
                            $('body').unbind('click');
                        }
                    });
                }, 500);
            }
        },
        refreshSummary: {
            name: "刷新项目造价",
            icon: 'fa-refresh',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                return !(selectedItem && selectedItem.data.projType !== projectType.folder);
            },
            callback: function (key, opt) {
                //获取当前节点的建设项目ID
                projTreeObj.refreshProjectData();
            }
        },
        exportProject: {
            name: "导出建设项目",
            icon: 'fa-cloud-download',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                return !(selectedItem && selectedItem.data.projType === projectType.project);
            },
            /* visible:function () {
             return false
             },*/
            callback: function (key, opt) {
                //获取当前节点的建设项目ID
                projTreeObj.exportProject(projTreeObj.tree.selected.data.ID,projTreeObj.tree.selected.data.name);
            }
        },
        importProject:{
            name: "导入建设项目",
            icon: 'fa-upload',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                if(selectedItem){
                    if(selectedItem.data.projType === projectType.project) return false;//如果是建设项目，可用
                    if(selectedItem.data.projType === projectType.folder){//如果是文件夹
                        if(selectedItem.children){
                            if(selectedItem.children.length == 0) return false;//如果文件夹没有子项，可用
                            if(selectedItem.children[0] .projType === projectType.project ) return false;//如果文件夹有子项，并且是建设项目，可用
                        }
                    }
                } else {
                    return false;
                }
                return true;
            },
            /*  visible:function () {
             return false
             },*/
            callback: function (key, opt) {

                $("#confirm-import").hide();
                $("#import").modal('show');
                projTreeObj.getUploadToken();
            }
        }
    },
    //全部-开始（新建）按钮弹出菜单（新建单位工程）
    loadStartMenu: function () {
        let me = this;
        $('#startA').click(me.contextMenuItems.addTender.callback);
    },
    //spread中鼠标右键弹出菜单
    loadContextMenu: function () {
        let me = this;
        $.contextMenu({
            selector: '#projSpread',
            build: function ($trigger, e) {
                let target = SheetDataHelper.safeRightClickSelection($trigger, e, me.workBook);
                me.initSelection({row: target.row, rowCount: 1}, me.preSelection ? me.preSelection : null, me.workBook.getActiveSheet());
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                "addFolder": me.contextMenuItems.addFolder,
                "addProject": me.contextMenuItems.addProject,
                "addEngineering": me.contextMenuItems.addEngineering,
                "addTender": me.contextMenuItems.addTender,
                "spr1": '--------',
                "rename": me.contextMenuItems.rename,
                "delete": me.contextMenuItems.delete,
                "copyTo": me.contextMenuItems.copyTo,
                "spr2": '--------',
                "share": me.contextMenuItems.share,
                "importInterface": me.contextMenuItems.importInterface,
                "spr3": '--------',
                "manageFiles": me.contextMenuItems.manageFiles,
                "refreshSummary": me.contextMenuItems.refreshSummary,
                "exportProject":me.contextMenuItems.exportProject,
                "importProject":me.contextMenuItems.importProject
            }
        });
    },
    //刷新按钮有效性（升降级、上下移）
    refreshBtn: function (selected) {
        const upLevel = $('#upLevel');
        const downLevel = $('#downLevel');
        const upMove = $('#upMove');
        const downMove = $('#downMove');
        if (!selected) {
            upLevel.addClass('disabled');
            downLevel.addClass('disabled');
            upMove.addClass('disabled');
            downMove.addClass('disabled');
            return;
        }
        /* 升级有效
         * 当前选中文件夹，且文件夹有父项，且父项是文件夹
         * 当前选中建设项目，且建设项目有父项，且父项是文件夹
         */
        if ([projectType.project, projectType.folder].includes(selected.data.projType)
            && selected.parent && selected.parent.data && selected.parent.data.projType === projectType.folder) {
            upLevel.removeClass('disabled');
        } else {
            upLevel.addClass('disabled');
        }
        /*
         * 降级有效
         * 当前选中文件夹，且文件夹有前兄弟，且前兄弟是文件夹
         * 当前选中建设项目，且建设项目有前兄弟，且前兄弟是文件夹
         * */
        if ([projectType.project, projectType.folder].includes(selected.data.projType)
            && selected.preSibling() && selected.preSibling().data.projType === projectType.folder) {
            downLevel.removeClass('disabled');
        } else {
            downLevel.addClass('disabled');
        }
        /*
         * 上移有效
         * 当前选中行有前兄弟，不论前兄弟类型
         * */
        selected.preSibling() ? upMove.removeClass('disabled') : upMove.addClass('disabled');
        /*
         * 后移有效
         * 当前选中行有后兄弟，不论后兄弟类型
         * */
        selected.nextSibling ? downMove.removeClass('disabled') : downMove.addClass('disabled');

    },
    doAfterTreeOpr: function ({selected, parent, next, projectMap}, action) {
        const me = this;
        $.bootstrapLoading.start();
        moveProjects({"user_id": userID, rootProjectID: null, projectMap: projectMap, feeRateMap: {}, unitPriceMap: {}},function (result) {
            for (let key in result) {//更新前端节点数据
                let updateData = result[key].update;
                let node = projTreeObj.tree.findNode(result[key].query.ID);
                if (node) {
                    for (let ukey in updateData) {
                        _.set(node.data,ukey,updateData[ukey]);
                    }
                }
            }
            projTreeObj.moveTo(selected, null, parent, next, null, action);
            $.bootstrapLoading.end();
        });
    },
    //升级后选中节点的后兄弟节点不成为其子节点，因为有层级类型限制(相当于选中节点移动到父项后成为其后兄弟)
    upLevel: function () {
        let selected = projTreeObj.tree.selected,
            parent = selected.parent.parent,
            next = selected.parent.nextSibling,
            projectMap = {};
        //更新父节点
        projectMap[selected.pid()] = {query: {ID: selected.pid()}, update: {NextSiblingID: selected.id()}};
        //更新选中节点前兄弟节点
        let orgPre = selected.preSibling();
        if (orgPre) {
            projectMap[orgPre.id()] = {query: {ID: orgPre.id()}, update: {NextSiblingID: selected.nid()}};
        }
        //更新选中节点
        projectMap[selected.id()] = {query: {ID: selected.id()}, update: {ParentID: selected.parent.pid(), NextSiblingID: selected.parent.nid()}};
        this.doAfterTreeOpr({selected, parent, next, projectMap});
    },
    downLevel: function () {
        let selected = projTreeObj.tree.selected,
            parent = null,
            next = null,
            projectMap = {};
        const maxFolderLevel = getMaxFolderLevel(selected);
        if (maxFolderLevel === 3) {
            return alert('文件夹不能超过3层');
        }
        //更新前兄弟节点
        let orgPre = selected.preSibling();
        parent = orgPre;
        projectMap[orgPre.id()] = {query: {ID: orgPre.id()}, update: {NextSiblingID: selected.nid()}};
        //更新前兄弟最后子节点
        if (orgPre.children.length > 0) {
            let lastChild = orgPre.lastChild();
            projectMap[lastChild.id()] = {query: {ID: lastChild.id()}, update: {NextSiblingID: selected.id()}};
        }
        //更新选中节点
        projectMap[selected.id()] = {query: {ID: selected.id()}, update: {ParentID: orgPre.id(), NextSiblingID: -1}};
        this.doAfterTreeOpr({selected, parent, next, projectMap}, 'downLevel');
    },
    upMove: function () {
        let selected = projTreeObj.tree.selected,
            parent = selected.parent,
            next = selected.preSibling(),
            projectMap = {};
        //更新前前兄弟
        let prepre = selected.preSibling().preSibling();
        if (prepre) {
            projectMap[prepre.id()] = {query: {ID: prepre.id()}, update: {NextSiblingID: selected.id()}};
        }
        //更新前兄弟
        let pre = selected.preSibling();
        projectMap[pre.id()] = {query: {ID: pre.id()}, update: {NextSiblingID: selected.nid()}};
        //更新选中节点
        projectMap[selected.id()] = {query: {ID: selected.id()}, update: {NextSiblingID: pre.id()}};
        this.doAfterTreeOpr({selected, parent, next, projectMap});
    },
    downMove: function () {
        let selected = projTreeObj.tree.selected,
            parent = selected.parent,
            next = selected.nextSibling.nextSibling,
            projectMap = {};
        //更新前兄弟
        let pre = selected.preSibling();
        if (pre) {
            projectMap[pre.id()] = {query: {ID: pre.id()}, update: {NextSiblingID: selected.nid()}};
        }
        //更新后兄弟
        projectMap[selected.nid()] = {query: {ID: selected.nid()}, update: {NextSiblingID: selected.id()}};
        //更新选中节点
        projectMap[selected.id()] = {query: {ID: selected.id()}, update: {NextSiblingID: selected.nextSibling.nid()}};
        this.doAfterTreeOpr({selected, parent, next, projectMap});
    },
    loadBtn: function () {
        $('#upLevel').click(this.upLevel.bind(this));
        $('#downLevel').click(this.downLevel.bind(this));
        $('#upMove').click(this.upMove.bind(this));
        $('#downMove').click(this.downMove.bind(this));
    },
    getSelStyle: function (backColor) {
        let style = new GC.Spread.Sheets.Style();
        style.backColor = backColor;
        style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        return style;
    },
    //设置选中行底色
    setSelStyle: function (sel, backColor,sheet) {
        let me = this;
        //let sheet = me.workBook.getSheet(0);
        sel.row = sel.row === -1 ? 0 : sel.row;
        me.renderSheetFuc(sheet, function () {
            let style = me.getSelStyle(backColor);
            for(let i = 0; i < sel.rowCount; i++){
                let row = i + sel.row;
                sheet.setStyle(row, -1, style);
            }
        });
    },
    initSelection: function (newSel, oldSel = null,sheet) {
        let me = this;
        let node = me.tree.items[newSel.row];
        node = node ? node : null;
        me.refreshBtn(node);
        //恢复底色
        if(oldSel){
            me.setSelStyle(oldSel, me.setting.style.defalutBackColor,sheet);
        }
        //设置选中行底色
        if(newSel){
            me.setSelStyle(newSel, me.setting.style.selectedColor,sheet);
        }
        if(sheet.name()=="copyToSheet"){ //复制到
            me.copySelected = node;
            let canCopy = false;
            if(node){
                canCopy = node.data.projType == projectType.tender|| node.data.projType == projectType.engineering;
            }
            canCopy == true?$("#copy-to-confirm").removeClass("disabled"):$("#copy-to-confirm").addClass("disabled");
            return;//如果是复制到表，不用做后面的操作
        }else if(sheet.name() == "replaceSheet"){//如果是替换文件，不用做后面的操作
            return;
        }
        me.tree.selected = node;
        shareSeleted = node;
        me.preSelection = newSel;
    },
    onSelectionChanging: function (sender, args) {
        let me = projTreeObj;
        me.initSelection(args.newSelections[0], args.oldSelections[0],args.sheet);
    },
    changeFileClick:async function (sender,args) {
        if(args.sheet.name() == "projectSheet"){
            await projTreeObj.initFileChangePage(projTreeObj.setting.header[args.col].dataCode);
            $("#mr_from").val(projTreeObj.setting.header[args.col].dataCode);
            $('#m_replace_file').modal('show');
        }else if(args.sheet.name() == "replaceSheet"){
            let cellType = args.sheet.getCellType(args.row, args.col);
            if(cellType instanceof GC.Spread.Sheets.CellTypes.CheckBox){
                projTreeObj.onReplaceNodeCheck(sender,args);
            }
        }
    },
    cusButtonClick:async function(info){
        projTreeObj.changeFileClick(null,info);
    },
    onDragDropBlock : function (sender,args) {//拖动移动项目位置
        let selected = projTreeObj.tree.selected;
        let targetNode = projTreeObj.tree.items[args.toRow];
        let projectMap = {},feeRateMap={},unitPriceMap = {},parent=null,next = null,oldProject=null;
        let rootProjectID = null;//记录建设项目ID
        //let updateObj = {project:[],feeRateFile:[],unitPriceFile:[]};
        args.cancel = true;//首先取消填充的动作
        if(args.sheet.name()=="copyToSheet"){ //如果是复制到表，不用做后面的操作
            return;
        }
        if(selected.preSibling()!=null&&selected.preSibling() == targetNode&&selected.data.projType == targetNode.data.projType){//如果目标节点与选中节点的前一节点一样，并且选中节点与目标节点项目类型也一样的话，不用移动
            return;
        }
        if(selected == targetNode){
            return;
        }

        if(selected.data.projType=="Tender"){//移动单位工程
            oldProject = selected.parent.parent;//记录原来的建设项目
            if(targetNode.data.projType=="Tender"||targetNode.data.projType=="Engineering"){//只能移动到这两个地方
                if(targetNode.data.projType=="Tender"){//移动到单位工程后面
                    [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true);
                    rootProjectID = targetNode.parent.pid();
                }else{//移动后成为单项工程的子项
                    [parent,next] =getMoveUpdateData(selected,targetNode,projectMap,false);
                    rootProjectID = targetNode.pid();
                }
                if(selected.data.property.rootProjectID != rootProjectID){//如果不属于同一个建设项目，要检查是否移动或复制单价文件和费率文件
                    projectMap[selected.id()].update['property.rootProjectID'] = rootProjectID; //要改变根项目ID
                    //检查费率文件和单价文件
                    moveOrCopy(selected,rootProjectID,feeRateMap,unitPriceMap,false);
                }
            }
        }
        if(selected.data.projType=="Engineering"){//移动的是单项工程
            oldProject = selected.parent;//记录原来的建设项目
            if(targetNode.data.projType=="Engineering"||targetNode.data.projType=="Project"){//目标位置是单项工程和建设项目
                if(targetNode.data.projType=="Engineering"){
                    [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true);
                    rootProjectID = targetNode.pid();
                }else {
                    [parent,next]  = getMoveUpdateData(selected,targetNode,projectMap,false);
                    rootProjectID = targetNode.id();
                }
                if(selected.pid() != rootProjectID){//跨了建设项目，更新子项目，同时要检查是否移动或复制子项的单价文件和费率文件。
                    //检查费率文件和单价文件
                    for(let c of selected.children){
                        projectMap[c.id()] = {query:{'ID':c.id()},update:{'property.rootProjectID':rootProjectID}};
                        moveOrCopy(c,rootProjectID,feeRateMap,unitPriceMap,true);
                    }
                }
            }
        }
        if(selected.data.projType=="Project"){//移动的是建设项目
            if(targetNode.data.projType=="Project"||targetNode.data.projType=="Folder") {//目标位置是建设项目和文件夹
                if(targetNode.data.projType=="Project"){
                    [parent,next]  = getMoveUpdateData(selected,targetNode,projectMap,true);
                }else {
                    [parent,next]  = getMoveUpdateData(selected,targetNode,projectMap,false);
                }
            }
        }
        if(selected.data.projType=="Folder"&&targetNode.data.projType=="Folder") {//文件夹只能移动到文件夹下
            [parent,next]  =  getMoveUpdateData(selected,targetNode,projectMap,false);//成为子项
        }
        if(_.isEmpty(projectMap)){//项目数据为空
            return;
        }
        $.bootstrapLoading.start();
        moveProjects({"user_id": userID,rootProjectID:rootProjectID,projectMap:projectMap,feeRateMap:feeRateMap,unitPriceMap:unitPriceMap},function (result) {
            for(let key in result){//更新前端节点数据
                let updateData = result[key].update;
                let node = projTreeObj.tree.findNode(result[key].query.ID);
                if(node){
                    for(let ukey in updateData){
                        _.set(node.data,ukey,updateData[ukey]);
                    }
                }
            }
            projTreeObj.moveTo(selected,targetNode,parent,next,oldProject);
            $.bootstrapLoading.end();
        });
        function getMoveUpdateData(sel,target,projectMap,sameLevel) {
            let tem_parent = null,tem_next = null;
            if(sameLevel==true){//移动后的位置的级别相同
                tem_parent = target.parent;
                tem_next = target.nextSibling;
                //移动到target的后面
                projectMap[target.id()] = {query:{'ID':target.id()},update:{'NextSiblingID':sel.id()}};
            }else {//移动后变成子项
                tem_parent = target;
                tem_next = target.firstChild();
            }
            let nextID = tem_next?tem_next.id():-1;
            if(sel.preSibling() != null){//如果原来有前项，更新下一节点
                projectMap[sel.preSibling().id()] = {query:{'ID':sel.preSibling().id()},update:{'NextSiblingID':sel.data.NextSiblingID}};
            }
            if(sel.parent.id() == tem_parent.id()){//移动前移动后的父项相同，只改变next
                if(selected.id() != nextID){//父项相同的情况下， 下一节点ID如果等于选中的ID即项目没有移动，不用做处理
                    projectMap[selected.id()] = {query:{'ID':selected.id()},update:{'NextSiblingID':nextID}};
                }
            }else {//
                let temData = {query:{'ID':selected.id()},update:{'ParentID':tem_parent.id(),'NextSiblingID':nextID}};
                let reName = projTreeObj.projectNameChecking(tem_parent,selected);//重名检查
                if(reName){
                    temData.update['name'] = reName
                }
                projectMap[selected.id()] = temData;
            }
            return [tem_parent,tem_next]
        }

        function moveOrCopy(sel,rootProjectID,feeRateMap,unitPriceMap,sameCheck) {//检查选中的项目使用的费率文件和单价文件是要移动还是复制一份
            let project = sel.parent.parent;//取建设项目
            let sameParent_f = true;
            let sameParent_u = true;
            let useFeeRateProject = getTendersByFile(fileType.feeRateFile,sel.data.property.feeFile.id,project);
            let useUnitPriceProject = getTendersByFile(fileType.unitPriceFile,sel.data.property.unitPriceFile.id,project);
            let tem_feeRate = {action:'copy',rootProjectID:rootProjectID,name:sel.data.property.feeFile.name,query:{ID:sel.data.property.feeFile.id}};
            let tem_unitPrice = {action:'copy',rootProjectID:rootProjectID,name:sel.data.property.unitPriceFile.name,query:{id:sel.data.property.unitPriceFile.id}}
            if(useFeeRateProject.length==1){//如果没有其它项目使用同一个费率文件，则移动
                tem_feeRate.action = 'move';
                tem_feeRate.update = {rootProjectID:rootProjectID};
            }
            if(useUnitPriceProject.length == 1){//如果没有其它项目使用同一个单价文件，则移动
                tem_unitPrice.action =  'move';
                tem_unitPrice.update = {root_project_id:rootProjectID};
            }
            feeRateMap[sel.id()] = tem_feeRate;
            unitPriceMap[sel.id()] = tem_unitPrice;
            if(sameCheck == true){//需要检查是否属于同一个单项工程，移动单项工程的时候用
                if(useUnitPriceProject.length > 1){
                    for(let f of useFeeRateProject){
                        if(f.pid()!=sel.pid()){//父节点不同
                            sameParent_f = false;
                            break;
                        }
                    }
                    if(sameParent_f == true){//如果使用的都是同属于一个单项工程，在移动单项工程的时候，移动费率文件和单价文件就可以了
                        feeRateMap[sel.id()].action = 'move';
                        feeRateMap[sel.id()].update = {rootProjectID:rootProjectID};
                    }
                }
                if(useUnitPriceProject.length > 1){
                    for(let u of useUnitPriceProject){
                        if(u.pid()!=sel.pid()){//父节点不同
                            sameParent_u = false;
                            break;
                        }
                    }
                    if(sameParent_u == true){
                        unitPriceMap[sel.id()].action =  'move';
                        unitPriceMap[sel.id()].update = {root_project_id:rootProjectID};
                    }
                }
            }
        }


    },
    projectNameChecking:function (parent,node,type) {
        //decDate = '（' + new Date().Format('MM-dd hh:mm:ss') + '恢复）';
        type=type?type:'移动';
        for(let c of parent.children){
           if(c.data.name == node.data.name){//如果存在同名的项目
               return  node.data.name + '（' + new Date().Format('MM-dd hh:mm:ss') + type+'）';
           }
        }
        return null;
    },
    onCellEditing:function (sender,args) {
        args.cancel = true;
    },
    getShowData: function (datas) {
        for(let data of datas){
            data.name = data.name ? data.name : '';
            if(data.projType !== projectType.tender){
                data.engineeringCost = '';
                data.unitPriceFile = '';
                data.feeRateFile = '';
                data.createDateTime = '';
            }
            else{
                data.engineeringCost = data.engineeringCost ? data.engineeringCost : 0;
                data.unitPriceFile = data.property && data.property.unitPriceFile && data.property.unitPriceFile.name ? data.property.unitPriceFile.name : '';
                data.feeRateFile = data.property && data.property.feeFile && data.property.feeFile.name ? data.property.feeFile.name : '';
                data.createDateTime = data.createDateTime ? new Date(data.createDateTime).Format('yyyy-MM-dd') : '';
            }
        }
    },
    openTender: function (ID, parent, timeoutTime) {
        setTimeout(function () {
            let newTab = window.open('about:blank');
            BeforeOpenProject(ID, {'fullFolder': GetFullFolder(parent)}, function () {
                let mainUrl = `/main?project=${ID}`;
                CommonAjax.get(mainUrl, [], function () {
                    newTab.location.replace(mainUrl); //不能后退
                });
            });
        }, timeoutTime);
    },
    getTreeNodeCell: function (tree) {
        let me = projTreeObj;
        let indent = 20;
        let levelIndent = -5;
        let halfBoxLength = 5;
        let halfExpandLength = 3;
        let imgWidth = 18;
        let imgHeight = 14;
        let shareImg = document.getElementById('share_pic'),
            shareImgWidth = 13,
            shareImgHeight = 13;
        let defaultHeight = 17; // 单元格默认高度，getAutoFitHeight返回17时，单元格高度才是20...不清楚原因
        let TreeNodeCellType = function () {
        };
        TreeNodeCellType.prototype = new GC.Spread.Sheets.CellTypes.Text();
        // 自动行高处理 此函数在每次调用autoFitRow后调用，返回的值作为新的单元格高度
        // 在单元格设置为自动行高后，单元格的内容有空格时，spreadjs会将空格认为是换行，会导致高度计算不正确，因此在setCellValue中处理空格
        TreeNodeCellType.prototype.getAutoFitHeight = function(value, text, cellStyle, zoomFactor, context){
            if (!defaultHeight) {
                defaultHeight = context.sheet.getCell(context.row, -1).height();
            }
            const node = me.tree.items[context.row];
            const nodeIndent = node ? (node.depth() + 1) * indent +  node.depth() * levelIndent + imgWidth + 5 : 0;
            const cellWidth = context.sheet.getCell(-1, context.col).width();
            const textLength = this.getAutoFitWidth(...arguments);
            const tempNum = textLength / (cellWidth - nodeIndent);
            const lineNum = tempNum % 1 > 0.92 ? Math.ceil(tempNum + 1) : Math.ceil(tempNum); // 不这么处理的话有些行高算出来不对
            //const lineNum = Math.ceil(textLength / (cellWidth - nodeIndent));
            return lineNum * defaultHeight;
        };
        TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
            if (style.backColor) {
                ctx.save();
                ctx.fillStyle = style.backColor;
                ctx.fillRect(x, y, w, h);
                ctx.restore();
            } else {
                ctx.clearRect(x, y, w, h);
            }
            let drawLine = function (canvas, x1, y1, x2, y2, color) {
                ctx.save();
                ctx.translate(0.5, 0.5);
                ctx.beginPath();
                ctx.moveTo(x1, y1);
                ctx.lineTo(x2, y2);
                ctx.strokeStyle = color;
                ctx.stroke();
                ctx.restore();
            };
            let drawExpandBox = function (ctx, x, y, w, h, centerX, centerY, expanded) {
                let rect = {}, h1, h2, offset = 1;
                rect.top = centerY - halfBoxLength;
                rect.bottom = centerY + halfBoxLength;
                rect.left = centerX - halfBoxLength;
                rect.right = centerX + halfBoxLength;

                if (rect.left < x + w) {
                    rect.right = Math.min(rect.right, x + w);

                    ctx.save();
                    ctx.translate(0.5, 0.5);
                    ctx.strokeStyle = 'black';
                    ctx.beginPath();
                    ctx.moveTo(rect.left, rect.top);
                    ctx.lineTo(rect.left, rect.bottom);
                    ctx.lineTo(rect.right, rect.bottom);
                    ctx.lineTo(rect.right, rect.top);
                    ctx.lineTo(rect.left, rect.top);
                    ctx.stroke();
                    ctx.fillStyle = 'white';
                    ctx.fill();
                    ctx.restore();

                    // Draw Horizontal Line
                    h1 = centerX - halfExpandLength;
                    h2 = Math.min(centerX + halfExpandLength, x + w);
                    if (h2 > h1) {
                        drawLine(ctx, h1, centerY, h2, centerY, 'black');
                    }
                    // Draw Vertical Line
                    if (!expanded && (centerX < x + w)) {
                        drawLine(ctx, centerX, centerY - halfExpandLength, centerX, centerY + halfExpandLength, 'black');
                    }
                }

            }
            let node = tree.items[options.row];
            let showTreeLine = true;
            if (!node) { return; }

            let centerX = Math.floor(x) + node.depth() * indent + node.depth() * levelIndent + indent / 2;
            let x1 = centerX + indent / 2;
            let centerY = Math.floor((y + (y + h)) / 2);
            let y1;
            // Draw Sibling Line
            if (showTreeLine) {
                // Draw Horizontal Line
                if (centerX < x + w) {
                    drawLine(ctx, centerX, centerY, Math.min(x1, x + w), centerY, 'gray');
                    let img;
                    if(node.data.projType === projectType.folder){
                        img = document.getElementById('folder_open_pic');
                        imgWidth = 15;
                    }
                    else if(node.data.projType === projectType.project){
                        img = document.getElementById('proj_pic');
                        imgWidth = 18;
                    }
                    else if(node.data.projType === projectType.engineering){
                        img = document.getElementById('eng_pic');
                        imgWidth = 14;
                    }
                    else if(node.data.projType === projectType.tender){
                        //如果单位工程不是实时计算结果，则显示刷新标记
                        img = node.data.changeMark && node.data.changeMark!=""? document.getElementById('refresh_pic'):document.getElementById('tender_pic');
                        imgWidth = 14;
                    }
                    ctx.drawImage(img, centerX+indent/2+3, centerY - 7, imgWidth,imgHeight);
                }
                // Draw Vertical Line
                if (centerX < x + w) {
                    y1 = node.isLast() ? centerY : y + h;
                    if (node.isFirst() && !node.parent.parent) {
                        drawLine(ctx, centerX, centerY, centerX, y1, 'gray');
                    } else {
                        drawLine(ctx, centerX, y, centerX, y1, 'gray');
                    }
                }
            }
            // Draw Expand Box
            if (node.children.length > 0) {
                drawExpandBox(ctx, x, y, w, h, centerX, centerY, node.expanded);
            }
            // Draw Parent Line
            if (showTreeLine) {
                var parent = node.parent, parentCenterX = centerX - indent - levelIndent;
                while (parent.parent) {
                    if (!parent.isLast()) {
                        if (parentCenterX < x + w) {
                            drawLine(ctx, parentCenterX, y, parentCenterX, y + h, 'gray');
                        }
                    }
                    parent = parent.parent;
                    parentCenterX -= (indent + levelIndent);
                }
            };
            //分享标记在开头
            if (node.data.shareInfo && node.data.shareInfo.length > 0) {
                let nowY = Math.floor((y + (y + h)) / 2);
                ctx.drawImage(shareImg, x + 3, nowY - 7, shareImgWidth,shareImgHeight);
            }
            // Draw Text
            x = x + (node.depth() + 1) * indent +  node.depth() * levelIndent + imgWidth + 3;
            w = w - (node.depth() + 1) * indent - node.depth() * levelIndent - imgWidth - 3;
            GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
        };
        TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
            let info = {x: x, y: y, row: context.row, col: context.col, cellStyle: cellStyle, cellRect: cellRect, sheetArea: context.sheetArea};
            let node = tree.items[info.row];
            if (node && node.data.projType === projectType.tender) {
                info.isReservedLocation = true;
            }
            return info;
        };
        TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
            let offset = -1;
            let node = tree.items[hitinfo.row];
            let centerX = hitinfo.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2;
            let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2;
            if(hitinfo.sheet.name() === "projectSheet"){//只有项目管理界面才执行
                if(node.data.projType === projectType.tender){
                    let thisClick = Date.now(),
                        open = false;
                    if (this.preNode === node && this.preClick && thisClick - this.preClick <= 300) {
                        open = true;
                        let timeoutTime = 200;
                        if($('.slide-sidebar').hasClass('open')){
                            timeoutTime = 500;
                        }
                        projTreeObj.openTender(node.data.ID, node.parent, timeoutTime);
                    }
                    this.preClick = open ? null : thisClick;
                    this.preNode = open ? null : node;
                }
                if (!node || node.children.length === 0) {
                    return;
                }
            }
            //统一改成方框外1像素内都有效
            if (hitinfo.x >= centerX - halfBoxLength - 2 && hitinfo.x <= centerX + halfBoxLength + 2 &&
                hitinfo.y >= centerY - halfBoxLength - 2 && hitinfo.y <= centerY + halfBoxLength + 2) {
                node.setExpanded(!node.expanded);
                TREE_SHEET_HELPER.massOperationSheet(hitinfo.sheet, function () {
                    let iCount = node.posterityCount(), i, child;
                    for (i = 0; i < iCount; i++) {
                        child = tree.items[hitinfo.row + i + 1];
                        hitinfo.sheet.setRowVisible(hitinfo.row + i + 1, child.visible, hitinfo.sheetArea);
                    }
                    hitinfo.sheet.invalidateLayout();
                });
                hitinfo.sheet.repaint();
            }
        };
        TreeNodeCellType.prototype.processMouseEnter = function (hitinfo) {
            let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
            let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
            let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col),
                zoom = hitinfo.sheet.zoom();
            let node = me.tree.items[hitinfo.row];
            let nodeIndent = node ? (node.depth() + 1) * indent +  node.depth() * levelIndent + imgWidth + 3 : 0;
            let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
            let cellWidth = hitinfo.sheet.getCell(-1, hitinfo.col).width();
            if(textLength > cellWidth - nodeIndent){
                TREE_SHEET_HELPER.showTipsDiv(text,{pos: {}},hitinfo);
            }
        };
        TreeNodeCellType.prototype.processMouseLeave = function (hitinfo) {
            TREE_SHEET_HELPER.tipDiv = 'hide';
            if (TREE_SHEET_HELPER._toolTipElement) {
                $(TREE_SHEET_HELPER._toolTipElement).hide();
                TREE_SHEET_HELPER._toolTipElement = null;
            };
            TREE_SHEET_HELPER.tipDivCheck();//延时检查：当tips正在show的时候，就调用了hide方法，会导致tips一直存在，所以设置一个超时处理
        }
        return new TreeNodeCellType();
    },
    setCellValue: function (cell, node,sheet,setting) {
        //const sheet = this.workBook.getActiveSheet();
        if(!setting) setting = this.setting;
        const {row, col} = cell;
        let dataCode = setting.header[col]['dataCode'];
        let value = '';
        if (dataCode === 'name') {
             // 在单元格设置为自动行高后，单元格的内容有空格时，spreadjs会将空格认为是换行，因此需要处理空格
            value = node.data.name && node.data.name.replace(new RegExp(' ', 'g'), '\t') || '';
        }
        else if(dataCode === 'unitPriceFile'){
            if(node.data.projType === projectType.tender){
                value = node.data.property && node.data.property.unitPriceFile && node.data.property.unitPriceFile.name ? node.data.property.unitPriceFile.name : '';
            }
        }
        else if(dataCode === 'feeRateFile'){
            if(node.data.projType === projectType.tender){
                value = node.data.property && node.data.property.feeFile && node.data.property.feeFile.name ? node.data.property.feeFile.name : '';
            }
        }
        else if(dataCode === 'createDateTime'){
            value = node.data.createDateTime ? new Date(node.data.createDateTime).Format('yyyy-MM-dd') : '';
        }
        else {
            value = isDef(node.data[dataCode]) ? node.data[dataCode] : '';
        }
        sheet.setValue(row, col, value);
    },
    setFileSelectButton:function (row,col,node,sheet,setting) {
        if(!setting) setting = this.setting;
        let dataCode = setting.header[col]['dataCode'];
        if(node.data.projType == "Tender" && (dataCode=="feeRateFile" || dataCode == "unitPriceFile")){
            sheet.setCellType(row, col,sheetCommonObj.getCusButtonCellType(projTreeObj.cusButtonClick,false),GC.Spread.Sheets.SheetArea.viewport);
        }
    },
    showTreeData: function (nodes, setting,sheet) {
        let headers = setting.header;
        let me = this;
        let tree = nodes.length>0?nodes[0].tree:me.tree;//sheet.name() == "copyToSheet"?me.copyTree:me.tree;
        let fuc = function(){
            sheet.setRowCount(0);
            sheet.setRowCount(nodes.length);
            let treeNodeCell = me.getTreeNodeCell(tree);
            sheet.getRange(-1, 0, -1, 1).cellType(treeNodeCell);
            const rows = [];
            for(let i = 0; i < nodes.length; i++){
                rows.push(i);
                for(let j = 0; j < headers.length; j++){
                    sheet.getRange(-1, j, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign[headers[j]['hAlign']]);
                    sheet.getRange(-1, j, -1, 1).vAlign(GC.Spread.Sheets.VerticalAlign[headers[j]['vAlign']]);
                    if(headers[j].cellType == "checkBox" && nodes[i].data.canSelect === true){
                        sheet.setCellType(i, j,new GC.Spread.Sheets.CellTypes.CheckBox(),GC.Spread.Sheets.SheetArea.viewport);
                        sheet.getCell(i, j).hAlign(GC.Spread.Sheets.HorizontalAlign.center);
                    }
                    me.setCellValue({row: i, col: j}, nodes[i],sheet,setting);
                    me.setFileSelectButton(i,j,nodes[i],sheet,setting);
                }
                sheet.getCell(i, 1,GC.Spread.Sheets.SheetArea.viewport).locked(true);
                if (typeof nodes[i].visible !== 'undefined') {
                    sheet.setRowVisible(nodes[i].serialNo(), nodes[i].visible);
                }
            }
            sheetCommonObj.setRowsAutoFit(sheet, rows, 0, true);
        };
        me.renderSheetFuc(sheet, fuc);
    },
    refreshNodeData: function (nodes) {
        let me = this;
        let sheet = me.workBook.getActiveSheet();
        let header = me.setting.header;
        me.renderSheetFuc(sheet, function () {

            if(_.isArray(nodes)){
                for(let t of nodes){
                    setSheetCellData(t,sheet);
                }
            }else {
                setSheetCellData(nodes,sheet);
            }
        });
        function setSheetCellData(n,sheet) {
            let rIdx = me.tree.items.indexOf(n);
            for(let i = 0; i < header.length; i++){
                me.setCellValue({row: rIdx, col: i}, n,sheet);
                me.setFileSelectButton(rIdx,i,n,sheet)
            }
        }

    },
    sumEngineeringCost:function(){
        let projectNodes = _.filter(projTreeObj.tree.items,function (item) {
            return item.data.projType == projectType.project;
        })
        for(let p of projectNodes){
            this.calEngineeringCost(p);
        }
    },
    calEngineeringCost:function (node) {
        let projectNode = null;//建设项目节点
        let refreshNodes = [];
        if(node.data.projType == projectType.folder){//如果是文件夹时不用计算
            return;
        }
        if(node.data.projType == projectType.project){
            projectNode = node;
        }
        if(node.data.projType == projectType.engineering){
            projectNode = node.parent;
        }
        if(node.data.projType == projectType.tender){
            projectNode = node.parent&&node.parent.parent?node.parent.parent:null;
        }
        if(projectNode){
            calNode(projectNode);
        }
        let children = projectNode.children;
        refreshNodes.push(projectNode);
        return  refreshNodes.concat(children);
        function calNode(node) {
            let tem_sum = 0;
            if(node.data.projType == projectType.tender){
                return;
            }
            for(let t of node.children){
                calNode(t);
                let temP = scMathUtil.roundForObj(t.data.engineeringCost,2);
                tem_sum = scMathUtil.roundForObj(temP+tem_sum,2);
            }
            node.data.engineeringCost =  scMathUtil.roundToString(tem_sum,2);
        }

    },
    initFileChangePage:async function (from) {
        let title = from == "unitPriceFile" ?"批量替换单价文件":"批量替换费率文件";
        $("#mr_title").text(title);
        this.initHtmlByFromRadio();
        let result = from == "unitPriceFile"?await this.setUnitFileChangeFileData():await this.setFeeRateChangeFileData();
        this.changeInfo = result;
        this.loadFileOptions(this.changeInfo,from);

    },
    setFeeRateChangeFileData:async function(){
        //userID
        let node = projTreeObj.tree.selected;
        let data={"user_id":userID, "projectID":node.data.ID, "rootProjectID":node.data.property.rootProjectID};
        let result = await ajaxPost("/feeRates/getChangeInfo",data);
        this.getFileListWithPath(result.others);
        return result;

    },
    setUnitFileChangeFileData:async function(){
        let node = projTreeObj.tree.selected;
        let data ={"project_id":node.data.ID,"rootProjectID":node.data.property.rootProjectID};
        let result = await ajaxPost("/glj/get-project-info",data);
        this.getFileListWithPath(result.other);
        //数据结构不一样，这里做一下转换
        let t_result = {
            currentProject:{
                ID:node.data.ID,
                currentOptions:result.self,
            },
            others:result.other
        }
        return t_result;
    },

    getFileListWithPath:function (list) {
        for(let n of list){
            let node = projTreeObj.tree.findNode(n.ID);
            if(node) {
                n.name = getPathName(node);
            }
            n.serialNo = node && node.serialNo() || 1;
        }
        // 按照正确的树结构排序
        list.sort((a, b) => a.serialNo - b.serialNo);

        function getPathName(node) {
            if(node.parent && node.parent.data){
                return getPathName(node.parent)+"\\"+node.data.name
            }else {
                return node.data?node.data.name:"";
            }
        }

    },
    loadFileOptions:function (data,from) {
        let idField = "ID",optionField ="optionList";
        if(from == "unitPriceFile"){
            idField = 'id';
            optionField = 'unitPriceList'
        }
        $('#currentOptions').empty();
        for(let c of data.currentProject.currentOptions){
            var option =  $("<option>").val(c[idField]).text(c.name);
            $('#currentOptions').append(option);
        }
        $('#otherProject').empty();
        for(let p of data.others){
            var option =  $("<option>").val(p.ID).text(p.name);
            $('#otherProject').append(option);
        }
        $('#otherFileOptions').empty();
        if(data.others.length>0){
            for(let f of data.others[0][optionField]){
                var option =  $("<option>").val(f[idField]).text(f.name);
                $('#otherFileOptions').append(option);
            }
        }
    },
    initHtmlByFromRadio:function () {
        var radioV= $("input[name='select_from']:checked").val();
        if(radioV == "0"){
            $("#fromProject").show();
            $("#fromOther").hide();
        } else {
            $("#fromProject").hide();
            $("#fromOther").show();
        }
    },
    initCopyToSpread:function () {
        let me = this;
        me.copyToWorkBook =  projTreeObj.buildSheet(me.copyToWorkBook,'copyToSpread',me.copyToSetting);
        let sheet = me.copyToWorkBook.getActiveSheet();
        sheet.options.isProtected = true;
        sheet.name('copyToSheet');
        let datas = [];
        for(let i of me.tree.items){
            datas.push(i.data);
        }
        me.copyTree  = pmTree.createNew(projTreeObj.setting, datas);
        initNodesVisibility(me.copyTree.items, false);
        me.showTreeData(me.copyTree.items, me.copyToSetting, sheet);
        me.copySelected = null;
        let initSel = sheet.getSelections()[0] ? sheet.getSelections()[0] : {row: 0, rowCount: 1};
        projTreeObj.initSelection(initSel,null,sheet);
    },
    initReplaceSpread:function () {
        let me = this;
        me.replaceWorkBook =  projTreeObj.buildSheet(me.replaceWorkBook,'replaceSpread',me.replaceSetting);
        let sheet = me.replaceWorkBook.getActiveSheet();
        sheet.options.isProtected = true;
        sheet.name('replaceSheet');
        let datas = [];
        for(let i of me.tree.items){//要挑出同个建设项目的节点
            if(me.isReplaceNode(i) == true){
                let tem = _.cloneDeep(i.data);
                if(tem.projType == "Tender") tem.canSelect = true;
                if(i == me.tree.selected) tem.selected = 1;
                datas.push(tem);
            }
        }
        me.replaceTree  = pmTree.createNew(projTreeObj.setting, datas);
        me.showTreeData(me.replaceTree.items, me.replaceSetting, sheet);
    },
    isReplaceNode:function (node) {//只加载本建设项目的节点
        let isReplaceNode = false;
        let selected = this.tree.selected;
        let rootProjectID = selected.data.property.rootProjectID;
        let rootNode = this.tree.findNode(rootProjectID)
        if(rootNode){
            let IDMap = this.getAllParentNodeID(selected);
            isReplaceNode = IDMap[node.data.ID]!==undefined ||node.data.ID == rootProjectID ||  node.data.ParentID == rootProjectID || (node.data.property &&node.data.property.rootProjectID == rootProjectID);
        }
        return isReplaceNode
    },
    getAllParentNodeID:function (node) {
       let IDMap = {};
       getPID(node,IDMap);
       return IDMap;
        function getPID(node,map) {
            if(node.parent && node.data.ParentID != -1){
                map[node.data.ParentID] = true;
                getPID(node.parent,map);
            }
        }
    },
    onReplaceNodeCheck:function(sender,args){
        let checkboxValue = args.sheet.getCell(args.row, args.col).value();
        let newval = checkboxValue?0:1;
        let node = projTreeObj.replaceTree.items[args.row];
        if(node.data.ID  === projTreeObj.tree.selected.data.ID) return; //如果是项目管理界面选中的节点，不给取消
        projTreeObj.setReplaceSelection(node,newval,args.row,args.col,args.sheet);
    },
    setReplaceSelection:function (node,value,row,col,sheet) {
        sheet.getCell(row, col).value(value);
        node.data.selected = value;
    },
    selectSameTypeProject:function (value) {
        let node = this.tree.selected;
        let engineering_id = node.data.property.engineering_id;
        for(let i=0 ;i< this.replaceTree.items.length ; i++){
            let tnode = this.replaceTree.items[i];
            if(tnode.data.ID == node.data.ID) continue;
            if(tnode && tnode.data.property && tnode.data.property.engineering_id == engineering_id){
                this.setReplaceSelection(tnode,value,i,1,this.replaceWorkBook.getActiveSheet());
            }
        }
    },
    confirmFileChange :async function(){
        let selectProjects =[],fileID=null,from = $("#mr_from").val(),name='',oldFileIDs = [],validate = true;
        for(let i of this.replaceTree.items) {
            if (i.data.selected === 1){
                selectProjects.push({
                    projectID: i.data.ID,
                    rootProjectID: i.data['property']['rootProjectID']
                });
                let fileField = from == "feeRateFile" ? "feeFile" : "unitPriceFile";
                oldFileIDs.push(i.data['property'][fileField]['id']);
            }
        }
        if(selectProjects.length > 0){
            let type = parseInt($("input[name='select_from']:checked").val());//0 从当前建设项目，1从其它建设项目中复制
            if(type == 0){
                fileID = $("#currentOptions").val();
                name = $("#currentOptions").find("option:selected").text()
            }else {
                fileID = $("#otherFileOptions").val();
                name = $("#otherFileOptions").find("option:selected").text();
            }
            if(fileID == null || fileID == undefined|| fileID ==""){
                alert("请选择替换文件")
            }
            //从其它项目复制才要做重名检查
            if(type == 1) validate = await projTreeObj.fileNameChecking({ name:name,rootProjectID:selectProjects[0].rootProjectID},from);
            if (validate == true){
                $('#m_replace_file').modal('hide');
                await projTreeObj.postChangeFile({projects:selectProjects,fileID:fileID,name:name,type:type,from:from},oldFileIDs);
            }else {
                alert(`当前的建设项目中已经有相同名字的${from == "feeRateFile"?"费率":"单价"}文件！`);
            }

        }
    },
    fileNameChecking:async function(data,from){
        let url =from == "feeRateFile" ? "/feeRates/checkFeeRateName" : "/glj/checkUnitFileName";
        let reuslt = await ajaxPost(url,data);
        return reuslt == false;//result 为true 则有重名的文件
    },

    postChangeFile:async function(data,oldFileIDs){
        data.user_id = userID;
        $.bootstrapLoading.start();
        let result = await ajaxPost("/pm/api/changeFile",data);
        $.bootstrapLoading.end();
        projTreeObj.refreshWhenFileDateChange(data.projects[0].projectID);
        //发送文件改变消息
        data.oldFileIDs = _.uniq(oldFileIDs);
        socket.emit('multiFileChangeNotify', data);
    },

    insert: function (data, parent, next) {
        let preNode = this.tree.items[this.preSelection.row];
        let node = this.tree.addNodeData(data, parent, next);
        this.addRow(node);
        let newSel = this.workBook.getSheet(0).getSelections()[0];
        this.initSelection(newSel,  preNode ? {row:preNode.serialNo(),rowCount:1} : null,this.workBook.getActiveSheet());//这里不能直接用this.preSelection，因为如果插入的记录在preSelection的前面时，之前old选中行已经变了，改不了old行的颜色
        return node;
    },
    addRow: function (node) {
        const me = this;
        const sheet = this.workBook.getActiveSheet();
        me.renderSheetFuc(sheet, function () {
            const items = me.tree.items;
            const rIdx = items.indexOf(node);
            const cIdx = sheet.getActiveColumnIndex();
            sheet.addRows(rIdx, 1);
            //set selection selected
            sheet.setSelection(rIdx, cIdx, 1, 1);
            me.tree.selected = node;
            //父节点收起时添加子节点,子节点添加完后隐藏
            /*if(node.parent && !node.parent.getRootExpandState()){
                sheet.setRowVisible(rIdx, false);
            }*/
            // 添加节点自动展开相关的隐藏节点
            me.tree.setNodesExpanded(node.getCollapseParents(), sheet);
            sheet.getCell(rIdx, 0).cellType(me.getTreeNodeCell(me.tree));
            me.refreshNodeData(node);
        });
    },
    remove: function (sheet, rIdx, count) {
        let me = this;
        me.renderSheetFuc(sheet, function () {
            sheet.deleteRows(rIdx, count);
            sheet.setRowCount(me.tree.items.length);
            me.initSelection({row: sheet.getActiveRowIndex(), rowCount: 1},null,sheet);
        });
    },
    move: function (orgRow, newRow) {
        this.workBook.getActiveSheet().deleteRows(orgRow, 1);
        this.addRow(this.tree.items[newRow]);
    },
    moveTo : function(select,target,parent,next,oldProject,action){
        let me = this;
        let fromRow = select.serialNo();
        let rCout = select.posterityCount() + 1;//删除的行数
        let sheet = me.workBook.getActiveSheet();
        let refreshNodes = [];
        me.tree.removeNode(select);//删除旧节点
        let newNode  = addNewNodes(select, parent, next);
        if(oldProject){
            refreshNodes = refreshNodes.concat(me.calEngineeringCost(oldProject));
            refreshNodes = refreshNodes.concat(me.calEngineeringCost(parent));
        }
        me.renderSheetFuc(sheet, function () {
            sheet.deleteRows(fromRow, rCout);
            sheet.addRows(newNode.serialNo(),rCout);
            let oldSelection = sheet.getSelections()[0];
            me.initSelection({row: newNode.serialNo(), rowCount: oldSelection.rowCount}, oldSelection,sheet);
            sheet.setSelection(newNode.serialNo(),oldSelection.col,oldSelection.rowCount,oldSelection.colCount);
            const newNodes = [newNode];
            const children = newNode.getAllChildren();
            newNodes.push(...children);
            for(let node of newNodes){
                const row = node.serialNo();
                sheet.getCell(row, 0).cellType(me.getTreeNodeCell(me.tree));
                const visible = node.visible;
                sheet.setRowVisible(row, visible);
            }
            refreshNodes = refreshNodes.concat(newNodes);
            me.refreshNodeData(refreshNodes);
        });
        if (action === 'downLevel') {
            me.tree.setNodesExpanded([parent], sheet);
        }

        function addNewNodes(node,parent,next) {
            const nodeState = {};
            if (typeof node.expanded !== 'undefined') {
                nodeState.expanded = node.expanded;
            }
            if (typeof node.visible !== 'undefined') {
                nodeState.visible = node.visible;
            }
            let newNode = me.tree.addNodeData(node.data, parent, next, nodeState);
            for(let c of node.children){
                addNewNodes(c,newNode,null);
            }
            return newNode;
        }

    },
    refreshProjectData:function (projectID) {
        //projTreeObj.tree.findNode(4578)
        //获取当前节点的建设项目ID
        let project = projectID?projTreeObj.tree.findNode(projectID):projTreeObj.tree.selected;
        while (project.data.projType !== projectType.project && project.parent){
            project = project.parent;
        }
        if(project && project.data.ID){
            $.bootstrapLoading.start();
            CommonAjax.post('/pm/api/getSummaryInfo', {user_id: userID, projectIDs: [project.data.ID]}, function (summaryInfo) {//11-06 zhang 这个接口返回值增加了项目需重新计算标记，项目图标刷新
                refreshProjSummary(project, summaryInfo);
                $.bootstrapLoading.end();
            }, function () {
                $.bootstrapLoading.start();
            });
        }
    },
    refreshProjectIcon:function (projectID) {
        let node = projTreeObj.tree.findNode(projectID);
        if(node && node.data.changeMark && node.data.changeMark!="") this.refreshProjectData(projectID);
    },
    refreshWhenFileDateChange:function(projectID){//当单价文件、费率文件被修改后，刷新页面，共用的项目提示刷新图标
        //在一次的修改中，同一个建设下，单价文件、费率文件才有共用的情况，而refreshProjectData是传入单位工程ID,刷新整个建设项目，所以，只要传入修改的单位工程ID，刷新建设项目即可
        this.refreshProjectData(projectID);
    },
    exportProject:async function(projectID,projectName){
        $.bootstrapLoading.progressStart();
        let spString = "|----|";
        try {
            let sumString = "";
            $("#progress_modal_bar").css('width','5%');
            let result = await getProjectInfo({projectID:projectID,type:"main",user_id: userID});
            $("#progress_modal_bar").css('width','10%');
            let result_arr = result.split(spString);
            sumString = result_arr[0];
            if(result_arr.length == 2){
                let tenders = JSON.parse(result_arr[1]);
                let each = 100;
                let width = 10;
                if(tenders.length > 0) each = 90/tenders.length;
                for(let t of tenders){
                    let tenderString = await getProjectInfo({projectID:t,rootProjectID:projectID,type:"sub",user_id: userID});
                    width += each;
                    $("#progress_modal_bar").css('width',width+'%');
                    await  setTimeoutSync(null,500);//设置间隔
                    sumString = sumString + spString +tenderString;
                }

            }
            //  console.log(JSON.parse(sumString));

            saveProjectFile(sumString);

        }catch (e){
            alert("导出失败！请查看log.");
            console.log(e)
        }finally {
            await  setTimeoutSync(null,500);//设置间隔
            $.bootstrapLoading.progressEnd();
        }


        async function getProjectInfo(data) {
            let result = await ajaxPost("/pm/api/exportProject",data);
            return result;
        }

        function saveProjectFile(data) {
            let blob = new Blob([data], {type: 'text/plain;charset=utf-8'});
            saveAs(blob, projectName+'.ybp');
        }
    },
    getImportProjectDate:function () {//导入建设项目时，需要在现有的树节点中插入新的节点，这里是取插入所需的项目数据
        let selectNode = projTreeObj.tree.selected;
        let parent = null,next=null;
        let updateData = {};
        if(selectNode && selectNode.data.projType == projectType.folder){
            parent = selectNode;
            next = selectNode.firstChild();
        }else if(selectNode &&  selectNode.data.projType == projectType.project){
            parent = selectNode.parent;
            next = selectNode.nextSibling;
            updateData["update"] = {query:{ID:selectNode.id()}}
        } else if (!selectNode) { // 默认在第一位
            parent = selectNode ? selectNode.parent : projTreeObj.tree._root;
            next = selectNode ? selectNode.nextSibling : projTreeObj.tree.firstNode();
        }
        updateData["self"] ={ParentID:parent.id(),NextSiblingID:next?next.id():-1};
        return updateData;
    },
    //创建建设项目的时候，根据选中位置获取所要创建建设项目的父ID、上兄弟节点ID、后兄弟节点ID
    getRelProjectID: function (selected) {
        let parent, pre, next;
        if(!selected || selected.data.projType === projectType.project){
            parent = selected ? selected.parent : projTreeObj.tree._root;
            pre = selected;
            next = selected ? selected.nextSibling : projTreeObj.tree.firstNode();
        } else if(selected.data.projType === projectType.folder){
            parent = selected ? selected : projTreeObj.tree._root;
            pre = selected ? selected.lastChild() : projTreeObj.tree.firstNode();
            next = null;
        } else if(selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender){
            let selectedProj = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent;
            parent = selectedProj ? selectedProj.parent : projTreeObj.tree._root;
            pre = selectedProj;
            next = selectedProj ? selectedProj.nextSibling : projTreeObj.tree.firstNode();
        }
        return {parentProjectID: parent && parent.data ? parent.data.ID : -1,
                preProjectID: pre && pre.data ? pre.data.ID : -1,
                nextProjectID: next && next.data ? next.data.ID : -1};
    },
    getUploadToken:async function () {
        let result =await ajaxGet("/pm/api/getUploadToken");
        $("#confirm-import").show();
        projTreeObj.uptoken=result.uptoken;
    }


};
// 新建项目必填项提示框设置“ 比如：注：为响应重庆地区指标采集标准数据要求，以上工程信息及特征必填项为必填项，请正确填写。”
function setupRequiredWarn(compilation) {
    let map = {
            '重庆定额(2018)': '<i class="fa fa-warning text-warning"></i> 注：为响应重庆地区指标采集标准数据要求，以上工程信息及特征为必填项，请正确填写。'
        },
        $warns = [
            $('#project-required-warn'),
            $('#tender-required-warn')
        ];
    for (let $warn of $warns) {
        map[compilation.name] ? $warn.html(map[compilation.name]) : $warn.html('');
    }
}

// 显示最近分享信息
function showRecentShareInfo() {
    function getBookListHtml(users) {
        return users.reduce((acc, user) => {
            const mobile = user.mobile || '';
            const realName = user.real_name || '';
            const company = user.company || '';
            // 手机最后一位
            const lastMobileNumer = mobile.substring(mobile.length - 1);
            // 显示名称为真实名称后两位
            const nickName = realName.substring(realName.length - 2);
            return acc +
            `<li>
                <span class="avatar bg-${lastMobileNumer}">${nickName}</span>
                <div class="book-body">
                    <h5 class="mt-0" title="${company}">${realName}</h5>
                    <span class="mobile-info">${mobile}</span>
                </div>
            </li>`;
        }, '');
        
    }
    $.bootstrapLoading.start();
    CommonAjax.post('/pm/api/getRecentShareInfo', {user_id: userID, count: 5}, (data) => {
        const recentHtml = getBookListHtml(data.recentUsers);
        // 联系人按拼英首字母降序排序
        data.contacts.sort((a, b) => {
            const realNameA = a.real_name || '';
            const realNameB = b.real_name || '';
            return realNameA.localeCompare(realNameB, 'zh-Hans-CN', {sensitivity: 'accent'})
        });
        const contactsHtml = getBookListHtml(data.contacts);
        $('#recentList').html(recentHtml);
        $('#contactsList').html(contactsHtml);
        $('#myTabContent ul li').click(function () {
            const mobile = $(this).find('.mobile-info')[0].textContent;
            $('#sharePhone').val(mobile);
            shareTender();
            const $subMenu = $('#shareSubMenu');
            const subMenu = $subMenu[0];
            $(subMenu.parentElement).removeClass('show');
            $subMenu.removeClass('show');
        });
        $.bootstrapLoading.end();
    }, () => {
        $.bootstrapLoading.end();
    });
}

$(document).ready(function() {
    // 最近分享、联系人列表相关
    $('body').click(function (e) {
        const body = $(this)[0];
        const $subMenu = $('#shareSubMenu');
        const subMenu = $subMenu[0];
        const menuBook = $('#dropdownMenuBook')[0]
        if (!$subMenu.is(':visible')) {
            return;
        }
        let target = e.target;
        while (target !== body) {
            if ([subMenu, menuBook].includes(target)) {
                return;
            }
            target = target.parentElement;
        }
        $(subMenu.parentElement).removeClass('show');
        $subMenu.removeClass('show');
    });
    // 最近分享、联系人列表相关
    $('#dropdownMenuBook').click(function () {
        const $subMenu = $('#shareSubMenu');
        const visible = $subMenu.is(':visible');
        if (visible) {
            $(this).parent().removeClass('show');
            $subMenu.removeClass('show');
        } else {
            $(this).parent().addClass('show');
            $subMenu.addClass('show');
            showRecentShareInfo();
        }
    });

    // 单位工程超限提示后，弹出客服列表
    $('#hintBox_form').on('hide.bs.modal', function () {
        const text = $('#hintBox_caption').text();
        if (text === '您创建的项目个数超限，请联系我们的客服人员，或者导出建设项目保存到本地备份，删除云上数据。') {
            $('#customerService').click();
        } 
    });
    setupRequiredWarn(compilationData);
    $('#add-project-dialog').find('.modal-body').append();
    //绑定项目管理的升降级、上下移按钮事件
    projTreeObj.loadBtn();
    $('#sideTab').find('li').click(function () {
       //消除tooltip
        $('[data-toggle="tooltip"]').tooltip('hide');
    });
    //列宽随着屏幕改变
    $(window).resize(function () {
        sheetCommonObj.setColumnWidthByRate(getWorkBookWidth(), gcTreeObj.workBook, gcTreeObj.setting.header);

    });

    init();
    $('#tab_pm_all').on('show.bs.tab', function () {
        if(gcTreeObj.workBook){
            gcTreeObj.workBook.destroy();
            gcTreeObj.workBook = null;
        }
        gcTreeObj.tree = null;
        init();
    });

    //单价、费率文件删除确认
    $('#fileDelConfirm').click(function () {
        if(fileDelObj && fileDelObj.id){
            let updateObj = Object.create(null);
            updateObj.updateType = 'delete';
            updateObj.updateData = Object.create(null);
            if(fileDelObj.fileType === fileType.unitPriceFile){
                updateObj.updateData.id = fileDelObj.id;
            }
            else if(fileDelObj.fileType === fileType.feeRateFile){
                updateObj.updateData.ID = fileDelObj.id;
            }
            updateObj.fileType = fileDelObj.fileType;
            a_updateFiles([updateObj], function () {
                fileDelObj = null;
                $('#fileDelCancel').click();
                setDataToSideBar();
                //refresh front?
            });
        }
    });

    //绑定新建建设项目、新建单项工程、新建文件夹、重命名Enter键事件
    bindInputs($('#project-name'), $('#engineering-name'), $('#folder-name'), $('#rename-name'));
    //绑定新建窗口显示事件
    bindModalShown($('#add-folder-dialog'), $('#add-project-dialog'), $('#add-engineering-dialog'), $('#add-tender-dialog'));
    //绑定新建建设项目、新建单项工程、新建文件夹、重命名弹窗隐藏事件
    bindModalsHidden($('#add-project-dialog'), $('#add-engineering-dialog'), $('#add-folder-dialog'), $('#rename-dialog'));

    // 新建子菜单有效性刷新
    $('#addMenuBtn').click(function () {
        const menuDisplay = !$('#addMenu').is(':visible');
        if (!menuDisplay) {
            return;
        }
        projTreeObj.refreshAddMenuItems();
    });

    // 新增建设项目操作
    $('#addProjOk').click(function () {
        if (!validRequiredData($('#projInfoStep'))) {
            return;
        }
        if (STATE.addingProject) {
            return;
        }
        STATE.addingProject = true;
        if (needfulInfoData && Array.isArray(needfulInfoData)) {
            updateRequiredData($('#projInfoStep'), needfulInfoData);
        }
        let suc = AddProject();
        if (suc === false) {
            STATE.addingProject = false;
        }
    });
    //新建建设项目-下一步
    $('#add-proj-next').click(function () {
        let name = $('#project-name').val().trim();
        if (!name) {
            setDangerInfo($('#project-name-info'), '请填写建设项目名称');
            return false;
        }
        if (!validProjectName(name)) {
            setDangerInfo($('#project-name-info'), `已存在“${name}”`);
            return false;
        }
        //建设项目基本信息
        showProjInfoStep();
    });
    //新建建设项目-上一步
    $('#add-proj-prev').click(function () {
        setDangerInfo($('#project-name-info'), '', false);
        showProjFirstStep();
    });
    //显示新建建设项目第一步内容
    async function showProjFirstStep() {
        $('#add-project-dialog').find('.modal-title').html('<i class="fa fa-cubes"></i> 新建建设项目');
        $('#projInfoStep').hide();
        $('#addProjOk').hide();
        $('#project-required-warn').hide();
        $('#add-proj-prev').hide();
        $('#projFirstStep').show();
        let requiredData = null;
        if (!infoData) {
            try {
                let fileKind = $('input[name="fileKind"]:checked').val();
                infoData = await ajaxPost('/pm/api/getBasicInfo', {user_id: userID});
                //第一次默认是投标
                needfulInfoData = getNeedfulBasicInfo(infoData, fileKind);
            } catch (err) {
                $('#add-project-dialog').modal('hide');
            }
        }
        requiredData = getRequired([], needfulInfoData);
        if (requiredData.length > 0) {
            $('#add-proj-next').show();
        } else {
            $('#addProjOk').show();
        }
    }
    //显示新建建设项目-建设项目基本信息内容
    async function showProjInfoStep() {
        $('#add-project-dialog').find('.modal-title').html('建设项目基本信息');
        $('#projFirstStep').hide();
        $('#add-proj-next').hide();
        $('#add-proj-prev').show();
        $('#addProjOk').show();
        $('#projInfoStep').show();
        $('#project-required-warn').show();
        showRequiredInfo($('#projInfoStep'), needfulInfoData);
    }
    //新建建设项目-文件类型选择 (影响到基本信息数据)
    $('input[name="fileKind"]').click(function () {
        if (infoData && infoData.length) {
            let fileKind = $(this).val();
            needfulInfoData = getNeedfulBasicInfo(infoData, fileKind);
        }
        let requiredData = getRequired([], needfulInfoData);
        if (requiredData.length > 0) {
            $('#addProjOk').hide();
            $('#add-proj-next').show();
        } else {
            $('#projInfoStep').empty();
            $('#add-proj-next').hide();
            $('#addProjOk').show();
        }
    });

    function bindModalShown(folderDialog, projDialog, engDialog, tenderDialog) {
        folderDialog.on('shown.bs.modal', function () {
            $('#folder-name').focus();
        });
        projDialog.on('show.bs.modal', function () {
            // 内蒙古费用定额，新建建设项目页面隐藏“文件类型：投标、招标”
            const filterCompilationNames = ['内蒙古定额(2017)'];
            if (filterCompilationNames.includes(compilationData.name)) {
                $('#project-dialog-fileKind').hide();
            }
        });
        projDialog.on('shown.bs.modal', function () {
            $('#project-name').focus();
        });
        engDialog.on('shown.bs.modal', function () {
            $('#engineering-name').focus();
        });
        tenderDialog.on('show.bs.modal', function () {
            $('#tender-name').focus();
            const filterCompilationNames = ['内蒙古定额(2017)'];
            if (filterCompilationNames.includes(compilationData.name)) {
                $('#tender-dialog-fileKind').hide();
            }
        });
        tenderDialog.on('shown.bs.modal', function () {
            $('#tender-name').focus();
        });
    }

    //新建建设项目、新建单项工程、新建文件夹、重命名弹窗隐藏事件
    function bindModalsHidden(projDialog, engDialog, folderDialog, renameDialog){
        projDialog.on('hidden.bs.modal', function () {
            setDangerInfo($('#project-name-info'), '', false);
            $('#project-name').val('');
            //文件类型、计税方法恢复默认选项
            $('input[name="fileKind"]:eq(0)').prop('checked', true);
            $('input[name="taxType"]:eq(0)').prop('checked', true);
        });
        projDialog.on('show.bs.modal', function () {
            // 计价规则恢复默认选项
            setValuationSels($('#proj-valuation'), billValuation);
            infoData = null;
            needfulInfoData = null;
            $('#add-proj-prev').hide();
            $('#add-proj-next').hide();
            showProjFirstStep();
        });
        engDialog.on('hidden.bs.modal', function () {
            setDangerInfo($('#engineering-name-info'), '', false);
            $('#engineering-name').val('');
        });
        folderDialog.on('hidden.bs.modal', function () {
            setDangerInfo($('#folder-name-info'), '', false);
            $('#folder-name').val('');
        });
        renameDialog.on('hidden.bs.modal', function () {
            setDangerInfo($('#rename-name-info'), '', false);
            $('#rename-name').val('');
        });
    }

    //绑定新建建设项目、新建单项工程、新建文件夹、重命名回车键功能
    function bindInputs(projInput, engInput, foldInput, renameInput){
        projInput.bind('keypress', function (event) {
            if(event.keyCode === 13){
                $('#add-proj-next').is(':visible')
                    ? $('#add-proj-next').click()
                    : $('#addProjOk').click();
                return false;
            }
        });
        engInput.bind('keypress', function (event) {
            if(event.keyCode === 13){
                $('#add-engineering-confirm').click();
                return false;
            }
        });
        foldInput.bind('keypress', function (event) {
            if(event.keyCode === 13){
                $('#add-folder-confirm').click();
                return false;
            }
        });
        renameInput.bind('keypress', function (event) {
            if(event.keyCode === 13){
                $('#rename-confirm').click();
                return false;
            }
        });
    }
    //单位工程-新建建设项目-选择计税方法
    $('input[name="taxType-tender"]').click(function () {
        curTaxType = parseInt($(this).val());
        getStdCalcProgramFiles();
    });
    // 选择计价方式
    $("input[name='valuation_type']").click(function() {
        let type = $(this).val();
        let targetData = type === 'bill' ? billValuation : rationValuation;
        let html = '';
        for(let i = targetData.length - 1; i >=0; i--){
            let valuation = targetData[i];
            if (valuation === null) {
                continue;
            }
            html += `<option ${i === targetData.length -1 ? 'selected' : ''} value="${valuation.id}">${valuation.name}</option>`;
        }
        $("#valuation").html(html);
        let engineeringList = getEngineeringList();
        let engineeringHtml = getEngineeringHtml(engineeringList);
        $("#tender-engineering").html(engineeringHtml);
        changeEngineering();
    });

    //选择计价规则
    $("#valuation").change(function () {
        curValuation = $(this).val();
        curValuationName = $(this).text();
        let engineeringList = getEngineeringList();
        let engineeringHtml = getEngineeringHtml(engineeringList);
        $("#tender-engineering").html(engineeringHtml);
        $('#valuation-info').hide();
        changeEngineering();
    });

    //选择计税方式
    $("#taxType").change(function () {
        $('#valuation-info').hide();
        getStdCalcProgramFiles();
    });


    // 新增单项工程操作
    $("#add-engineering-confirm").click(function() {
        if (STATE.addingEng) {
            return;
        }
        STATE.addingEng = true;
        let suc = AddEngineering();
        if (suc === false) {
            STATE.addingEng = false;
        }
    });

    //新建单位工程-建设项目提示
    $('#poj-name').keyup(function () {
        let pojName = $('#poj-name').val().trim();
        let nameList = getNameList($('#poj-name-list').children());
        let isExist = hasListName(nameList, pojName);
        if(!isExist){
            if(pojName !== ''){
                console.log(curValuation);
                //新建建设项目，显示计价规则、文件类型、计税方法选项
                $('#newProjectSet').show();
                $('input[name="fileKind-tender"]:eq(0)').prop('checked', true);
                $('input[name="taxType-tender"]:eq(0)').prop('checked', true);
                curTaxType = 1;
                getStdCalcProgramFiles();
                replaceClass($('#poj-name-info'), 'text-danger', 'text-info');
                setDangerInfo($('#poj-name-info'), `新建“${pojName}”`);
            }
            else {
                $('#newProjectSet').hide();//隐藏文件类型、计税方法选项
                $('#poj-name-info').hide();
            }
            //清空单项工程下拉和文件下拉
            setEngOptions(null);
            setFileOptions(null);
        }
        else {
            //触发选项
            let curName = $(this).val().trim();
            function getProjOpt(opts){
                for(let opt of opts){
                    if($(opt).text().trim() === curName){
                        return $(opt);
                    }
                }
                return null;
            }
            let matchOpt = getProjOpt($('#poj-name-list').find('a'));
            if(matchOpt){
                matchOpt.click();
            }
            $('#poj-name-info').hide();
        }
    });

    //新建单位工程-单项工程提示
    $('#eng-name').keyup(function () {
        let engName = $('#eng-name').val().trim();
        let nameList = getNameList($('#eng-name-list').children());
        let isExist = hasListName(nameList, engName);
        if(!isExist && engName !== ''){
            replaceClass($('#eng-name-info'), 'text-danger', 'text-info');
            setDangerInfo($('#eng-name-info'), `新建“${engName}”`);
        }
        else {
            $('#eng-name-info').hide();
        }
    });

    //新建单位工程-单位工程提示
    $('#tender-name').keyup(function () {
        let selected = projTreeObj.tree.selected;
        let pojName = $('#poj-name').val().trim();
        let engName = $('#eng-name').val().trim();
        let tenderName = $('#tender-name').val().trim();
        let isExist = hasTender(selected, pojName, engName, tenderName);
        $('#unit-price').find('option:first-child').text(tenderName);
        $('#tender-fee-rate').find('option:first-child').text(tenderName);
        if(isExist){
            if(tenderName !== '')
                setDangerInfo($('#tender-name-info'), `已存在“${tenderName}”`);
        }
        else {
            $('#tender-name-info').hide();
        }
    });

    //下拉是否含有输入的名字
    function hasListName(nameList, name){
        for(let i = 0, len = nameList.length; i < len; i++){
            if(nameList[i] === name){
                return true;
            }
        }
        return false;
    }

    function getNameList(list){
        let rst = [];
        for(let i = 0, len = list.length; i < len; i++){
            rst.push($(list[i]).text());
        }
        return rst;
    }

    //设置地区选项
    function setRegionOpts (regions) {
        $('#regionDiv').find('select').empty();
        for(let region of regions){
            let $opt = $(`<option value = "${region}">${region}</option>`);
            $('#regionDiv').find('select').append($opt);
        }
    }
    // 新增单位工程弹层改变
    $('#add-tender-dialog').on('show.bs.modal', function() {
        // 恢复计价规则
        setValuationSels($('#valuation'), billValuation);
        //clear info
        curStep = 1; //当前在第几步
        infoData = null; //建设项目基本信息数据
        needfulInfoData = null;
        featureData = null; //工程特征数据
        $('#poj-name-info').hide();
        $('#eng-name-info').hide();
        $('#tender-name-info').hide();
        $('#tender-name').val('');
        $('#valuation-info').hide();
        $('#engineering-info').hide();
        $('#unit-price').find('option:first-child').text('新建单价文件');
        $('#tender-fee-rate').find('option:first-child').text('新建费率文件');
        $('#newProjectSet').hide(); //隐藏文件类型、计税方法选项
        $('input[name="fileKind-tender"]:eq(0)').prop('checked', true);
        $('input[name="taxType-tender"]:eq(0)').prop('checked', true);
        curTaxType = 1;
        //获取建设项目
        let selected = projTreeObj.tree.selected;
        let projs = getProjs(selected);
        setProjOptions(projs, selected);
        //$($("input[name='valuation_type']")[0]).click();
        initEngineering();
        //设置地区选项
        if(regions.length > 0){
            setRegionOpts(regions);
            $('#regionDiv').show();
        }
        //恢复到第一步状态
        if (!$('#firstStep').is(':visible')) {
            showFirstStep();
        }
    });
    //新建单位工程-文件类型选择变换（影响到基本信息数据）
    $('input[name="fileKind-tender"]').click(function () {
        if (infoData && infoData.length) {
            let fileKind = $(this).val();
            needfulInfoData = getNeedfulBasicInfo(infoData, fileKind);
            $('#infoStep').empty(); //清空设置的基本信息必填数据
        }
    });
    //新建单位工程-下一步
    $('#add-tender-next').click(async function() {
        if (curStep === 1) {
            let projName = $("#poj-name").val().trim();
            if(projName === ''){
                replaceClass($('#poj-name-info'), 'text-info', 'text-danger');
                setDangerInfo($('#poj-name-info'), '请填写建设项目名称');
                return false;
            }
            let engName = $("#eng-name").val().trim();
            if(engName === ''){
                replaceClass($('#eng-name-info'), 'text-info', 'text-danger');
                setDangerInfo($('#eng-name-info'), '请填写单项工程名称');
                return false;
            }

            let tenderName = $('#tender-name').val();
            if (tenderName === '') {
                setDangerInfo($('#tender-name-info'), '请填写单位工程名称');
                return false;
            }
            let selected = projTreeObj.tree.selected;
            let isExist = hasTender(selected, projName, engName, tenderName);
            if (isExist) {
                return false;
            }
            showSecondStep();
        } else if (curStep === 2) {
            let valuation = $("#valuation").val();
            if(!valuation || valuation === ''){
                setDangerInfo($('#valuation-info'), '请选择计价规则');
                return false;
            }

            let engineeringName = $("#tender-engineering").val();
            if (!engineeringName || engineeringName === '') {
                setDangerInfo($('#engineering-info'), '请选择工程专业');
                return false;
            }
            let feeName = $('#tender-feeStandard').val();
            if(!feeName || feeName === ''){
                setDangerInfo($('#feeStandard-info'), '请选择费用标准');
                return false;
            }

            let taxType = $("#taxType").val();
            let IDGroup = $("#tender-calcProgram").val();
            if (!IDGroup || IDGroup === '') {
                setDangerInfo($('#calcProgram-info'), '请选择计算程序');
                return false;
            }
            let path = getAddPath();
            let infoRequired = getRequired([], needfulInfoData);
            let featureRequired = getRequired([], featureData);
            if (path === addPath.p_e_t && infoRequired.length > 0) {
                showInfoStep();
            } else if (featureRequired.length > 0) {
                showFeatureStep();
            }
        } else if (curStep === 3) {
            if (!validRequiredData($('#infoStep'))) {
                return;
            }
            showFeatureStep();
        }
        curStep++;
    });
    //新建单位工程-上一步
    $('#add-tender-prev').click(function () {
        if (curStep === 2) {
            showFirstStep();
        } else if (curStep === 3) { //建设项目基本信息或工程特征
            showSecondStep();
        } else if (curStep === 4) { //工程特征
            $('#featureStep').hide();
            $('#add-tender-confirm').hide();
            $('#add-tender-next').show();
            $('#infoStep').show();
        }
        curStep--;
    });
    //显示第一步的内容
    function showFirstStep() {
        $('#add-tender-title').html(`<i class="fa fa-sticky-note-o"></i>新建单位工程`);
        $('#featureStep').hide();
        $('#infoStep').hide();
        $('#secondStep').hide();
        $('#tender-required-warn').hide();
        $('#firstStep').show();
        $('#add-tender-prev').hide();
        $('#add-tender-next').show();
        $('#add-tender-confirm').hide();
        $('#add-tender-cancel').hide();
    }
    //显示第二步内容
    async function showSecondStep() {
        $('#add-tender-title').html(`<i class="fa fa-sticky-note-o"></i>新建单位工程`);
        $('#add-tender-confirm').hide();
        $('#featureStep').hide();
        $('#infoStep').hide();
        $('#firstStep').hide();
        $('#tender-required-warn').hide();
        $('#secondStep').show();
        $('#add-tender-prev').show();
        $('#add-tender-next').hide();
        $('#add-tender-confirm').hide();
        $('#add-tender-cancel').show();
        if (!infoData) {
            try {
                let fileKind = $('input[name="fileKind-tender"]:checked').val();
                infoData = await ajaxPost('/pm/api/getBasicInfo', {user_id: userID});
                needfulInfoData = getNeedfulBasicInfo(infoData, fileKind);
            } catch (err) {
                $('#add-tender-dialog').modal('hide');
            }
        }
        if (!featureData) {
            try{
                let valuation = curValuation;
                let engineeringName = $("#tender-engineering").val();
                let feeName = $('#tender-feeStandard').val();
                featureData = await ajaxPost('/pm/api/getProjectFeature',
                    {user_id: userID, valuationID: valuation, engineeringName: engineeringName, feeName: feeName});
            } catch (err) {
                $('#add-tender-dialog').modal('hide');
            }
        }
        let infoRequired = getRequired([], needfulInfoData),
            featureRequired = getRequired([], featureData),
            path = getAddPath();
        if (path === addPath.p_e_t && infoRequired.length > 0 || featureRequired.length > 0) {
            $('#add-tender-next').show();
        } else {
            $('#add-tender-confirm').show();
        }
    }
    //显示新建单位工程-建设项目基本信息内容
    function showInfoStep() {
        $('#add-tender-title').html('建设项目基本信息');
        $('#secondStep').hide();
        $('#infoStep').show();
        $('#tender-required-warn').show();
        let featureRequired = getRequired([], featureData);
        if (featureRequired.length > 0) {
            $('#add-tender-next').show();
            $('#add-tender-confirm').hide();
        } else {
            $('#add-tender-next').hide();
            $('#add-tender-confirm').show();
        }
        showRequiredInfo($('#infoStep'), needfulInfoData);
    }
    //显示新建单位工程-工厂特征内容
    function showFeatureStep() {
        $('#add-tender-next').hide();
        $('#add-tender-confirm').show();
        $('#add-tender-title').html('工程特征');
        $('#secondStep').hide();
        $('#infoStep').hide();
        $('#featureStep').show();
        $('#tender-required-warn').show();
        showRequiredInfo($('#featureStep'), featureData);
    }
    //显示必填信息(建设项目基本信息、单位工程工程特征)
    //必填信息：标记了必填required且不只读!readOnly
    function showRequiredInfo($form, datas) {
        $form.empty();
        let requiredDatas = getRequired([], datas);
        for (let data of requiredDatas) {
            $form.append(getFormRow(data));
        }
    }
    //根据基本信息、工程特征数据获取对应节点
    function getFormRow(data) {
        let dateReg = /([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})-(((0[13578]|1[02])-(0[1-9]|[12][0-9]|3[01]))|((0[469]|11)-(0[1-9]|[12][0-9]|30))|(02-(0[1-9]|[1][0-9]|2[0-8])))/;
        let cellType = data.cellType ? data.cellType : 'text';
        let $label = $(`<label for="staticEmail" class="col-3 col-form-label col-form-label-sm">${data.dispName}</label>`),
            $cell;
        if (cellType === 'comboBox') {
            let opts = data.options.split('@');
            $cell = $(`<select name="${data.key}" class="form-control form-control-sm"><option>请选择</option></select>`);
            for (let opt of opts) {
                $cell.append($(`<option ${data.value === opt ? 'selected' : ''} value="${opt}">${opt}</option>`));
            }
        } else if (cellType === 'date') {   //不用原生的日期控件
            $cell = $(`<input type="pm-${cellType}" name="${data.key}"
                       value="${data.value}" class="form-control form-control-sm" placeholder="请输入">`);
            $cell.datepicker({dateFormat: 'yy-mm-dd'});
            $cell.change(function () {
                if (!dateReg.test($($cell).val())) {
                    $($cell).val('');
                }
            });
        } else {
            $cell = $(`<input type="${cellType}" ${cellType === 'number' ? 'min="0"' : ''} name="${data.key}"
                       value="${data.value}" class="form-control form-control-sm" placeholder="请输入">`);
        }
        let $row = $(`<div class="form-group row"></div>`),
            $col = $(`<div class="col"></div>`);
        $col.append($cell);
        $row.append($label);
        $row.append($col);
        return $row;
    }

    //验证必填信息.
    function validRequiredData($form) {
        let eles = $form.find('input, select');
        for (let ele of eles) {
            $(ele).removeClass('shake-input');
            let v = $(ele).val().trim();
            if (!v || v === '请选择') {
                $(ele).focus();
                $(ele).addClass('shake-input');
                return false;
            }
        }
        return true;
    }

    //根据用户填的值，更新基本信息、工程特征数据
    function updateRequiredData($form, fullData) {
        let eles = $form.find('input, select');
        for (let ele of eles) {
            let key = $(ele).attr('name');
            if (!key) {
                continue;
            }
            let data = findRequiredByKey(key, fullData);
            if (data) {
                data.value = $(ele).val();
                if (data.cellType === 'date') {
                    data.value = data.value.replace('/\//g', '-');
                }
            }
        }
    }
    //根据key获取基本信息/工程特征数据
    function findRequiredByKey(key, data) {
        function findItem(k, data) {
            for (let d of data) {
                if (d.key === k) {
                    return d;
                }
                if (d.items && d.items.length > 0) {
                    let target = findItem(k, d.items);
                    if (target) {
                        return target;
                    }
                }
            }
            return null;
        }
        return findItem(key, data);
    }

    // 新增单位工程
    $("#add-tender-confirm").click(function() {
        if (STATE.addingTender) {
            return;
        }
        if (getAddPath() === addPath.p_e_t && !validRequiredData($('#infoStep'))) {
            return;
        }
        if (!validRequiredData($('#featureStep'))) {
            return false;
        }
        STATE.addingTender = true;
        if (needfulInfoData && Array.isArray(needfulInfoData)) {
            updateRequiredData($('#infoStep'), needfulInfoData);
        }
        if (featureData && Array.isArray(featureData)) {
            updateRequiredData($('#featureStep'), featureData);
        }
        let suc = AddTender();
        if(suc === false){
            STATE.addingTender = false;
        }
    });

    // 新增文件夹操作
    $("#add-folder-confirm").click(function() {
        if (STATE.addingFolder) {
            return;
        }
        STATE.addingFolder = true;
        let suc = AddFolder();
        if (suc === false) {
            STATE.addingFolder = false;
        }
    });

    // 删除时文字替换
    $('#del').on('show.bs.modal', function() {
        let hasTenderChild = function (children) {
            for (let i = 0; i < children.length; i++) {
                if (children[i].children.length === 0) {
                    if (children[i].data.projType === 'Tender') {
                        return true;
                    }
                } else if (hasTenderChild(children[i].children)) {
                    return true;
                }
            }
            return false;
        };
        // 显示内容
        let tenderHintElement = $('#tenderHint');
        let folderHintElement = $('#folderHint');
        if (projTreeObj.tree.selected.children.length === 0) {
            tenderHintElement.show();
            tenderHintElement.text('删除 "' + projTreeObj.tree.selected.data.name +'" ？');
            folderHintElement.hide();
        } else {
            tenderHintElement.hide();
            folderHintElement.show();
            folderHintElement.text('删除 "'+ projTreeObj.tree.selected.data.name +'" 以及它包含的子项？');
        }
        // 显示是否可以找回
        if (hasTenderChild([projTreeObj.tree.selected])) {
            $('#restoreHint').show();
        } else {
            $('#restoreHint').hide();
        }
    });

    // 删除操作
    $('#delete-confirm').click(function () {
        if (STATE.deleting) {
            return;
        }
        STATE.deleting = true;
        let updateData = null;
        let dialog = $('#del');
        if (projTreeObj.tree && projTreeObj.tree.selected) {
            $.bootstrapLoading.start();
            updateData = GetDeleteUpdateData(projTreeObj.tree.selected);
            UpdateProjectData(updateData, function () {
                dialog.modal('hide');
                let selected = projTreeObj.tree.selected;
                //删除行号
                let rIdx = projTreeObj.tree.items.indexOf(selected);
                //删除行数
                let rCout = selected.posterityCount() + 1;
                projTreeObj.tree.removeNode(selected);
                let refreshNodes = projTreeObj.calEngineeringCost(selected);
                //delete view
                let sheet = projTreeObj.workBook.getActiveSheet();
                projTreeObj.remove(sheet, rIdx, rCout);
                if(selected.data.projType == projectType.tender||selected.data.projType == projectType.engineering){
                    projTreeObj.refreshNodeData(refreshNodes);//刷新工程造价信息
                }
                $.bootstrapLoading.end();
                //快速点击时，第一个项目删除成功了，可能会删除多项目
                setTimeout(function () {
                    STATE.deleting = false;
                }, 500);
            }, function () {
                $.bootstrapLoading.end();
                setTimeout(function () {
                    STATE.deleting = false;
                }, 500);
            });
        }
    });

    // 重命名按钮点击
    /*$('#rename-btn').click(function() {
        if (!projTreeObj.tree) {
            return false;
        }
        if (!projTreeObj.tree.selected) {
            alert('请选择需要重命名的数据');
            return false;
        }
        $('#rename-name').val(projTreeObj.tree.selected.data.name ? projTreeObj.tree.selected.data.name : '');
        $('#rename-dialog').modal('show');
        setTimeout(function () {
            $('#rename-name')[0].focus();
        }, 300);
    });*/

    // 重命名操作
    $("#rename-confirm").click(function() {
        let select = projTreeObj.tree.selected;
        let parent = select ? select.parent : Tree._root;
        let newName = $('#rename-name').val().trim();
        let dialog = $('#rename-dialog');
        if (newName === '') {
            setDangerInfo($('#rename-name-info'), '请输入重命名');
            return false;
        }

        if (newName === select.data.name) {
            dialog.modal('hide');
            return false;
        }
        if(existName(newName, parent.children, select.data.projType)){
            setDangerInfo($('#rename-name-info'), `已存在“${newName}”`);
            return;
        }
        newName = whiteSpaceCollapse(newName);
        RenameProject(select.id(), newName, select.data.ParentID, function () {
            setDangerInfo($('#rename-name-info'), '', false);
            dialog.modal('hide');
            select.data.name = newName;
            let sheet = projTreeObj.workBook.getActiveSheet();
            projTreeObj.setCellValue({ row: sheet.getActiveRowIndex(), col: 0 }, select, sheet, projTreeObj.setting);
        });
    });


    // 复制到按钮点击
    /*$('#copy-to-btn').click(function () {
        let selectedItem = projTreeObj.tree.selected;
        try {
            let selectedType = selectedItem !== null && selectedItem.data !== undefined ?
                selectedItem.data.projType : '';
            if (selectedType !== projectType.tender) {
                throw '请选择单位工程进行复制';
            }
        } catch (error) {
            alert(error);
            return false;
        }
        $('#copy-to-dialog').modal('show');
    });*/
    // 复制到弹层替换
  /*  $('#copy-to-dialog').on('show.bs.modal', function () {
        copytoZTree = ConvertTreeToZtree(projTreeObj.tree, $('#treeDemo2'), null);
    });*/

    $('#copy-to-dialog').on('shown.bs.modal', function () {
        projTreeObj.initCopyToSpread();
       // copytoZTree = ConvertTreeToZtree(projTreeObj.tree, $('#treeDemo2'), null);
    });

    $('#m_replace_file').on('shown.bs.modal', function () {
        // projTreeObj.tree.selected
        projTreeObj.initReplaceSpread();
    });
    $("input[name='select_from']").each(function(){
        $(this).click(function(){
            projTreeObj.initHtmlByFromRadio();
        });
    });
    // 复制到操作
    $("#copy-to-confirm").click(async function() {
        try {
            let originalNode = projTreeObj.tree.selected;
            let toNode = projTreeObj.copySelected;
            let projectNode;    //建设项目节点
        let parent = null,next = null,projectMap={};
            if(toNode.data.projType == projectType.engineering){//复制为目标的子节点
                projectNode = toNode.parent;
                parent = toNode;
                next = toNode.firstChild();
            }else if(toNode.data.projType == projectType.tender){//复制为目标的后兄弟
                projectNode = toNode.parent.parent;
                parent = toNode.parent;
                next = toNode.nextSibling;
                projectMap['update'] = {query:{ID:toNode.id()}};//前一节点的下一个节点更新;
            }
            //目标建设项目的计税方法与单位工程的一致时，才可复制到，否则提示“当前单位工程计税方法与目标建设项目不一致，不可复制。 确定”。
            if (projectNode.data.property.taxType != originalNode.data.property.taxType) {
                alert('当前单位工程计税方法与目标建设项目不一致，不可复制。');
                return false;
            }
            let nextID = next?next.id():-1;
            let projectData = _.cloneDeep(originalNode.data);
            projectData['ParentID'] = parent.id();
            projectData['NextSiblingID'] = nextID;
            projectData['property'] ={};
            projectData['property']['rootProjectID'] = parent.pid();
            projectData['shareInfo'] = [];
            let rename = projTreeObj.projectNameChecking(parent,originalNode,"复制");//重名检查
            rename? projectData['name'] = rename:'';
            projectMap['copy'] = {document:projectData};
            $("#copy-to-dialog").modal('hide');
            $.bootstrapLoading.progressStart('拷贝项目', true);
            $("#progress_modal_body").text('正在拷贝项目，请稍候……');
            await ajaxPost('/pm/api/copyProjects', {projectMap:projectMap,user_id: userID, tenderCount: 1});
            await importProcessChecking(null, null, (newProjectData) => handleTenderAfterChecking(newProjectData, projectData));
        } catch (err) {
            alert(err);
        }

    });
    $('#selectSameTypeProject').click(function(){
        let value = $(this).prop('checked') == true?1:0;
            projTreeObj.selectSameTypeProject(value);
    });

    $('#changeFileConfirm').click(function(){
        projTreeObj.confirmFileChange();
    });

    // 选择工程专业后动态更改费率文件等数据
    $("#tender-engineering").change(function() {
        changeEngineering()
    });
    $('#tender-feeStandard').change(function () {
       changeFeeStandard();
    });
    //导入相关
    importView.eventListen();
});

//初始化工程专业库
function initEngineering() {
    let engineeringList = getEngineeringList();
    let engineeringHtml = getEngineeringHtml(engineeringList);
    $("#tender-engineering").html(engineeringHtml);
    changeEngineering();
}

async function changeEngineering(){
    $('#engineering-info').hide();
    initFeeStandardSel();
}

function changeFeeRate(engLib) {
    if(engLib){
        /*
         if (engLib.fee_lib !== undefined && engLib.fee_lib.length > 0) {
         $("#tender-fee-rate").children("option").first().val("newFeeRate-"+engLib.fee_lib[0].id);
         }*/
        //2018-08-29  费率改为和计税方式绑定在一起 所以在这里还不能确定标准费率库ID
        $("#tender-fee-rate").children("option").first().val("newFeeRate@@");
        $("#tender-engineering").parent().siblings('.hidden-area').slideDown('fast');
    }
    else {
        $("#tender-fee-rate").children("option").first().val($('#tender-name').val());
    }
}

//根据文件类型筛选新的基本信息数据
function getNeedfulBasicInfo(info, fileKind) {
    debugger;
    /* let strMap = {
        1: 'tender',    //投标
        2: 'bid',       //招标
        3: 'control'    //控制价
    }; */
    const strMap = {
        1: '投标',    //投标
        2: '招标',       //招标
        3: '控制价'    //控制价
    };
    return filterItems(info);

    // 递归过滤
    function filterItems(items) {
        const filterdItems = items.filter(item => !item.fileKind || item.fileKind === strMap[fileKind]);
        filterdItems.forEach(item => {
            if (item.items && item.items.length) {
                item.items = filterItems(item.items);
            }
        });
        return filterdItems;
    }

    /* let needfulData = info.filter(data => !data.fileKind || data.fileKind === strMap[fileKind]);
    needfulData.forEach(nData => {
        let needfulSub = nData.items.filter(sData => !sData.fileKind || sData.fileKind === strMap[fileKind]);
        nData.items = needfulSub;
    });
    return needfulData; */
}

function getRequired(rst, datas) {
    // 暂时不填必填项了
    return [];
    if (!datas) {
        return rst;
    }
    for (let data of datas) {
        let required = typeof data.required === 'string' ? JSON.parse(data.required) : data.required,
            readOnly = typeof data.readOnly === 'string' ? JSON.parse(data.readOnly) : data.readOnly;
        if (required && !readOnly) {
            rst.push(data);
        }
        if (data.items && data.items.length > 0) {
            getRequired(rst, data.items);
        }
    }
    return rst;
}
//变换专业工程、变换费用标准，重新获取工程库数据...
async function changeFeature() {
    let valuation = curValuation;
    let engineeringName = $("#tender-engineering").val();
    let feeName = $('#tender-feeStandard').val();
    featureData = await ajaxPost('/pm/api/getProjectFeature',
        {user_id: userID, valuationID: valuation, engineeringName: engineeringName, feeName: feeName});
    updateAddState(needfulInfoData, featureData);
}

//更新当前新建单位工程是否需要下一步
function updateAddState(needfulInfoData, featureData) {
    let infoRequired = getRequired([], needfulInfoData),
        featureRequired = getRequired([], featureData),
        path = getAddPath();
    if (path === addPath.p_e_t && infoRequired.length > 0 || featureRequired.length > 0) {
        $('#add-tender-next').show();
        $('#add-tender-confirm').hide();
    } else {
        $('#add-tender-next').hide();
        $('#add-tender-confirm').show();
    }
}

async function initFeeStandardSel() {
    $('#tender-feeStandard').empty();
    let feeStandards = [];
    let engineeringList = getEngineeringList();
    let currentEngName = $('#tender-engineering').val();
    for(let eng of engineeringList){
        if(eng.lib.name && eng.lib.name === currentEngName && eng.lib.feeName && eng.lib.feeName !== ''){
            feeStandards.push(eng.lib.feeName);
        }
    }
    for(let feeName of feeStandards){
        let $opt = $(`<option value="${feeName}">${feeName}</option>`);
        $('#tender-feeStandard').append($opt);
    }
    if(feeStandards.length > 0){
        if($('#feeStandard-info').is(':visible')){
            $('#feeStandard-info').hide();
        }
    }
    //变换专业工程、变换费用标准，重新获取工程库数据...
    if (curStep === 2) {
        await changeFeature();
    }
    let currentEngLib = getEngineeringLib(currentEngName + $('#tender-feeStandard').val(), engineeringList);
    changeFeeRate(currentEngLib);
    //setTaxGroupHtml();
    getStdCalcProgramFiles();
}

async function changeFeeStandard() {
    //变换专业工程、变换费用标准，重新获取工程库数据...
    if (curStep === 2) {
        await changeFeature();
    }
    let currentEngLib = getEngineeringLib($('#tender-engineering').val() + $('#tender-feeStandard').val(), getEngineeringList());
    changeFeeRate(currentEngLib);
    //setTaxGroupHtml();
    getStdCalcProgramFiles();
}

function setTaxGroupHtml() {
    let groups = getTaxGroupList();
    let taxTypeArray = [];
    let htmlString = "";
    if(groups && groups.length > 0){
        taxTypeArray = _.uniq(_.map(groups,'taxType'));
    }
    for(let t of taxTypeArray){
        htmlString += "<option value='"+t+"'>"+taxTypeMap[t]+"</option>"
    }
    $('#taxType').html(htmlString);
    if(taxTypeArray.length <2){
        $('#taxType_div').hide();
    }else {
        $('#taxType_div').show();
    }
}

function getStdCalcProgramFiles(){
    function getStdCPFilesHtml(taxGroups) {
        let result = '';
        if (taxGroups.length <= 0) {
            return result;
        };

        for (let group of taxGroups){
            let groupString = ""; //把计算程序、清单模板、列设置的ID生成一个组合的值
            let p_id = group.program_lib?group.program_lib.id:"";
            let t_id = group.template_lib?group.template_lib.id:"";
            let c_id = group.col_lib?group.col_lib.id:"";
            let f_id = group.fee_lib?group.fee_lib.id:"";
            groupString = p_id + "|-|" +t_id+"|-|"+c_id+"|-|"+f_id;
            result += '<option value='+ groupString +'>'+ group.program_lib.name +'</option>';
        };
        return result;
    };
    let taxType = curTaxType; //计税方法取建设项目的
    let stdCPHtml = getStdCPFilesHtml(getTaxGroupList(taxType));
    $("#tender-calcProgram").html(stdCPHtml);
    if ($("#tender-calcProgram")[0].options.length > 1)
        $("#tender-calcProgram")[0].selectedIndex = 0;
}
//获取工作表总宽度
function getWorkBookWidth(){
    return workBookWidth = $(window).width() - $('.pm-side').width() - 90;
}

// 初始化节点可见性，默认收起至建设项目层
function initNodesVisibility(nodes, visible) {
    function recurSetVisible(nodes, visible) {
        nodes.forEach(node => {
            node.visible = visible;
            if (node.children) {
                recurSetVisible(node.children, visible);
            }
        });
    }
    nodes.forEach(node => {
        const isProject = node.data.projType === projectType.project;
        if (isProject) {
            node.expanded = visible;
            recurSetVisible(node.children, visible);
        }
    });
}

function initProjects(callback) {
    GetAllProjectData(function (datas) {
        //设置工程专业
        for (let data of datas) {
            if (data.projType === projectType.tender) {
                data.feeStandardName = data.property.feeStandardName || '';
            }
        }
        CommonAjax.post('/options/getOptions', [], function (rstData) {
            projTreeObj.setting.style.selectedColor = rstData.COLOROPTS.SELECTED.backColor;
            projTreeObj.tree = pmTree.createNew(projTreeObj.setting, datas);
            projTreeObj.tree.selected = projTreeObj.tree.items[0];
            projTreeObj.workBook = projTreeObj.buildSheet(projTreeObj.workBook,'projSpread',projTreeObj.setting);
            const sheet = projTreeObj.workBook.getSheet(0);
            sheet.options.frozenlineColor = '#ababab';
            sheet.frozenColumnCount(2);
            sheet.name('projectSheet');
            sheetCommonObj.spreadDefaultStyle(projTreeObj.workBook);
            projTreeObj.sumEngineeringCost();
            initNodesVisibility(projTreeObj.tree.items, false);
            projTreeObj.showTreeData(projTreeObj.tree.items, projTreeObj.setting, sheet);
            const rows = projTreeObj.tree.items.map((item, index) => index);
            //初始选择
            const initSel = sheet.getSelections()[0] ? sheet.getSelections()[0] : { row: 0, rowCount: 1 };
            projTreeObj.initSelection(initSel, null, sheet);
            autoFlashHeight();
            projTreeObj.workBook.refresh();
            if (callback) {
                callback();
            }
        }, function () {
            $.bootstrapLoading.end();
        });
    });
}

/**
 * 初始化数据
 */
async function init(refresh = false) {
    console.log('init');
    //init spread and pmTree
    try {
        if(refresh == false) socketObject.connect('pm');//socket 连接;
        if (isFirst) {
            isFirst = false;
            $.bootstrapLoading.progressStart('欢迎使用大司空计价', true);
            $("#progress_modal_body").text('首次加载例题，请稍候……');
            await ajaxPost('/pm/api/prepareInitialData', {user_id: userID});
            await importProcessChecking(null, null, () => {
                initProjects(() => $.bootstrapLoading.progressEnd());
            }, true);
        } else {
            await importProcessChecking(null, ({ content }) => {
                $.bootstrapLoading.progressStart('欢迎使用大司空计价', true);
                $("#progress_modal_body").text(content);
            }, () => {
                $.bootstrapLoading.start();
                initProjects(() => $.bootstrapLoading.end());
            }, true);
        }
        engineering = engineeringList !== null && engineeringList !== undefined ? JSON.parse(engineeringList) : [];
    } catch (error) {
        alert(error)
    }
}

function refreshAllPage(){
    if(gcTreeObj.workBook){
        gcTreeObj.workBook.destroy();
        gcTreeObj.workBook = null;
    }
    gcTreeObj.tree = null;
    init(true);
}


function whiteSpaceCollapse(v) {
    v = v.replace(/[\r\n\t]/g, ' ');
    v = v.trim();
    return v.replace(/\s{1,}/g, ' ');
}

/**
 * 新增建设项目
 *
 * @return {boolean}
 */
function AddProject() {
    let name = $('#project-name').val().trim();
    if (name === '') {
        setDangerInfo($('#project-name-info'), '请填写建设项目名称');
        return false;
    }
    name = whiteSpaceCollapse(name);
    let fileKind = $('input[name="fileKind"]:checked').val();
    if (!fileKind) {
        setDangerInfo($('#fileKind-info'));
        return false;
    }
    let valuation = $('#proj-valuation').val();
    if (!valuation) {
        setDangerInfo($('#proj-valuation-info'));
        return false;
    }
    let valuationName = $('#proj-valuation').text().trim();
    let taxType = $('input[name="taxType"]:checked').val();
    if (!taxType) {
        setDangerInfo($('#taxType-info'));
        return false;
    }
    $.bootstrapLoading.start();
    let existCallback = function () {
        setDangerInfo($('#project-name-info'), `已存在“${$("#project-name").val()}”`);
        STATE.addingProject = false;
        $.bootstrapLoading.end();
    };
    let sucCallback = function () {
        $('#addProjOk').removeClass('disabled');
        $('#add-project-dialog').modal('hide');
        $('#project-name').val('');
        setDangerInfo($('#project-name-info'), '', false);
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingProject = false;
        }, 500);
    };
    let errCB = function () {
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingProject = false;
        }, 500);
    };
    let selectedItem = projTreeObj.tree.selected;

    /*
     * （1）、当前没有焦点行，新建建设项目为第一个节点。
     （2）、当前定位在文件夹，新建建设项目为文件夹的最后一个子节点。
     （3）、当前定位在建设项目，新建建设项目为其后兄弟。
     （4）、当前定位在单项工程或单位工程，新建项目为当前所属建设项目的后兄弟。
     * */
    let property = {basicInformation: needfulInfoData ? needfulInfoData : [],
        fileKind: fileKind,
        taxType: taxType,
        valuation: valuation,
        valuationName: valuationName,
        valuationType: curValutionType
    };
    if(!selectedItem){
        AddSiblingsItem(selectedItem, name, property, projectType.project, existCallback, sucCallback, errCB);
    }
    else {
        if(selectedItem.data.projType === projectType.project){
            AddSiblingsItem(selectedItem, name, property, projectType.project, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.engineering || selectedItem.data.projType === projectType.tender){
            let proj = selectedItem.parent.data.projType === projectType.project ? selectedItem.parent : selectedItem.parent.parent;
            AddSiblingsItem(proj, name, property, projectType.project, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.folder){
            AddChildrenItem(selectedItem, name, property, projectType.project, existCallback, sucCallback, errCB);
        }
    }
}

//新建建设项目、单项工程、文件夹、重命名提示(文本改变，暂时不需要)
function getChangedFunc(input, nameInfo){
    return function () {
        let selected = Tree.selected();
        let parent = selected ? selected.parent : Tree._root;
        let name = input.val();
        if(existName(name, parent.children)){
            nameInfo.text(`已存在“${name}”`);
            nameInfo.show();
        }
        else {
            nameInfo.text('');
            nameInfo.hide();
        }
    }
}

//新增节点，初始化汇总数值
function setInitSummaryData(data) {
    if(data.projType === projectType.folder){
        return;
    }
    //just for View
    data.engineeringCost = 0;
    data.subEngineering = 0;
    data.measure = 0;
    data.safetyConstruction = 0;
    data.other = 0;
    data.charge = 0;
    data.tax = 0;
    data.rate = data.projType === projectType.project ? 100 : 0;
    data.buildingArea = '';
    data.perCost = '';
}

function getAddPath() {
    let projName = $("#poj-name").val().trim(),
        engName = $("#eng-name").val().trim(),
        selected = projTreeObj.tree.selected;
    let tempProjs = getProjs(selected);
    let tempProj = getNodeByName(projName, tempProjs);
    let tempEng;
    if(tempProj){
        tempEng = getNodeByName(engName, tempProj.children);
        if(tempEng){
           return addPath.t;
        } else {
            return addPath.e_t
        }
    } else {
        return addPath.p_e_t;
    }
}

function AddTenderItems(selected, projName, engName, tenderName, property, callback, errCB){
    let path, updateDatas = [];
    let tempProjs = getProjs(selected);
    let tempProj = getNodeByName(projName, tempProjs);
    let tempEng;
    if(tempProj){
        tempEng = getNodeByName(engName, tempProj.children);
        if(tempEng){
            path = addPath.t;
        }
        else {
            path = addPath.e_t
        }
    }
    else {
        path = addPath.p_e_t;
    }
    if(path === addPath.p_e_t){
        let parent, pre, next;
        GetNewProjectId(3, function (IDs) {
            let projID = IDs.lowID, engID = IDs.lowID + 1, tenderID = IDs.lowID + 2;
            if(!selected || selected.data.projType === projectType.project){
                parent = selected ? selected.parent : projTreeObj.tree._root;
                pre = selected;
                next = selected ? selected.nextSibling : projTreeObj.tree.firstNode();
            }
            else if(selected.data.projType === projectType.folder){
                parent = selected ? selected : projTreeObj.tree._root;
                pre = selected ? selected.lastChild() : projTreeObj.tree.firstNode();
                next = null;
            }
            else if(selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender){
                let selectedProj = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent;
                parent = selectedProj ? selectedProj.parent : projTreeObj.tree._root;
                pre = selectedProj;
                next = selectedProj ? selectedProj.nextSibling : projTreeObj.tree.firstNode();
            }
            let fileKind = $('input[name="fileKind-tender"]:checked').val();
            let updateProjs = GetUpdateData(pre, parent, next, projName, {
                basicInformation: needfulInfoData ? needfulInfoData : [],
                fileKind: parseInt(fileKind), taxType: curTaxType, valuationType: curValutionType, valuation: curValuation, valuationName: curValuationName},
                projID, {updateType: 'new', projectType: projectType.project});
            let updateEng = {updateType: 'new', updateData: {ID: engID, ParentID: projID, NextSiblingID: -1, name: engName, projType: projectType.engineering}};
            property.rootProjectID = projID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: engID, NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            updateDatas = updateDatas.concat(updateProjs);
            updateDatas.push(updateEng);
            updateDatas.push(updateTender);
            UpdateProjectData(updateDatas, function(datas){
                let projData, engData, tenderData;
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        data.updateData.shareInfo = [];
                        setInitSummaryData(data.updateData);
                        if(data.updateData.projType === projectType.project){
                            projData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.engineering){
                            engData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.tender){
                            tenderData = data.updateData;
                            tenderData.feeStandardName = tenderData.property.feeStandardName || '';
                        }
                    }
                });
                let pojNode = projTreeObj.insert(projData, parent, next);
                let engNode = projTreeObj.insert(engData, pojNode, null);
                let tenderNode = projTreeObj.insert(tenderData, engNode, null);
                const rows = [pojNode.serialNo(), engNode.serialNo(), tenderNode.serialNo()];
                sheetCommonObj.setRowsAutoFit(projTreeObj.workBook.getSheet(0), rows, 0, true)
                callback();
            }, errCB);
        }, errCB);
    }
    else if(path === addPath.e_t){
        GetNewProjectId(2, function (IDs) {
            let engID = IDs.lowID, tenderID = IDs.lowID + 1;
            let pre = tempProj.lastChild();
            let next = null;
            let updateEng = {updateType: 'new', updateData: {ID: engID, ParentID: tempProj.data.ID, NextSiblingID: -1, name: engName, projType: projectType.engineering}};
            property.rootProjectID = tempProj.data.ID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: engID, NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            if(selected && selected.data.projType === projectType.engineering && selected.parent === tempProj){
                pre = selected;
                next = selected.nextSibling;
                updateEng.updateData.NextSiblingID = pre.data.NextSiblingID;
            }
            updateDatas.push(updateEng);
            updateDatas.push(updateTender);
            if(pre){
                updateDatas.push({updateType: 'update', updateData: {ID: pre.id(), NextSiblingID: engID}});
            }
            UpdateProjectData(updateDatas, function (datas) {
                let engData, tenderData;
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        data.updateData.shareInfo = [];
                        setInitSummaryData(data.updateData);
                        if(data.updateData.projType === projectType.engineering){
                            engData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.tender){
                            tenderData = data.updateData;
                            tenderData.feeStandardName = tenderData.property.feeStandardName || '';
                        }
                    }
                });
                let engNode = projTreeObj.insert(engData, tempProj, next);
                let tenderNode = projTreeObj.insert(tenderData, engNode, null);
                const rows = [engNode.serialNo(), tenderNode.serialNo()];
                sheetCommonObj.setRowsAutoFit(projTreeObj.workBook.getSheet(0), rows, 0, true);
                callback();
            }, errCB);
        }, errCB);
    }
    else if(path === addPath.t){
        GetNewProjectId(1, function (IDs) {
            let tenderID = IDs.lowID;
            let pre = tempEng.lastChild();
            property.rootProjectID = tempProj.data.ID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: tempEng.id(), NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            updateDatas.push(updateTender);
            if(pre){
                updateDatas.push({updateType: 'update', updateData: {ID: pre.id(), NextSiblingID: tenderID}});
            }
            UpdateProjectData(updateDatas, function (datas) {
                datas.forEach(function (data) {
                    if(data.updateType === 'new') {
                        data.updateData.shareInfo = [];
                        setInitSummaryData(data.updateData);
                        data.updateData.feeStandardName = data.updateData.property.feeStandardName || '';
                        let tenderNode = projTreeObj.insert(data.updateData, tempEng, null);
                        const rows = [tenderNode.serialNo()];
                        sheetCommonObj.setRowsAutoFit(projTreeObj.workBook.getSheet(0), rows, 0, true);
                    }
                });
                callback();
            }, errCB);
        }, errCB);
    }
}

/**
 * 新增子元素
 *
 * @param {String} name
 * @param {String} type
 * @param {function} callback
 * @return {void}
 */
function AddChildrenItem(selected, name, property, type, existCallback, sucCallback, errCB) {
    if(!selected){
        selected = projTreeObj.tree.selected;
    }
    let parent = selected ? selected : projTreeObj.tree._root;
    let pre = selected ? selected.lastChild() : projTreeObj.tree.firstNode();
    if(existName(name, parent.children)){
        //alert('同级目录已存在相同名称数据.');
        existCallback();
    }
    else {
        GetNewProjectId(1, function(IDs) {
            let typeInfo = {
                updateType: 'new',
                projectType: type
            };
            let updateData = GetUpdateData(pre, parent, null, name, property, IDs.lowID, typeInfo);
            projTreeObj.tree.maxNodeId(IDs.lowID - 1);
            UpdateProjectData(updateData, function(datas){
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        data.updateData.shareInfo = [];
                        setInitSummaryData(data.updateData);
                        let node = projTreeObj.insert(data.updateData, parent, null);
                        sheetCommonObj.setRowsAutoFit(projTreeObj.workBook.getSheet(0), [node.serialNo()], 0, true);
                    }
                });
                sucCallback();
            }, errCB);
        }, errCB);
    }
}

/**
 * 新增同级元素
 *
 * @param {String} name
 * @param {String} type
 * @param {function} callback
 * @return {void}
 */
function AddSiblingsItem(selected, name, property, type, existCallback, sucCallback, errCB) {
    if(!selected){
        selected = projTreeObj.tree.selected;
    }
    let parent = selected ? selected.parent : projTreeObj.tree._root;
    let next = selected ? selected.nextSibling : projTreeObj.tree.firstNode();
    if(existName(name, parent.children, type)){
        existCallback();
    }
    else {
        GetNewProjectId(1, function(IDs) {
            let typeInfo = {
                updateType: 'new',
                projectType: type
            };
            let updateData = GetUpdateData(selected, parent, next, name, property, IDs.lowID, typeInfo);
            projTreeObj.tree.maxNodeId(IDs.lowID - 1);
            UpdateProjectData(updateData, function(datas){
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        data.updateData.shareInfo = [];
                        setInitSummaryData(data.updateData);
                        const node = projTreeObj.insert(data.updateData, parent, next);
                        sheetCommonObj.setRowsAutoFit(projTreeObj.workBook.getSheet(0), [node.serialNo()], 0, true)
                    }
                });
                sucCallback();
            }, errCB);
        }, errCB);
    }
}

// 设置计价规则下拉
function setValuationSels($sel, valuationData) {
    let reducer = (acc, cur) => acc + `<option value="${cur.id}">${cur.name}</option>`;
    let html = valuationData.reduce(reducer, '');
    $sel.html(html);
    curValuation = valuationData[0].id;
    curValuationName = valuationData[0].name;
}

//根据工程专业名称+费用标准名称获取工程专业库
function getEngineeringLib(cascadeName, engineeringList) {
    for(let eng of engineeringList){
        let engName = eng.lib.name ? eng.lib.name : '';
        let engFeeName = eng.lib.feeName ? eng.lib.feeName : '';
        if(cascadeName === engName + engFeeName){
            return eng.lib;
        }
    }
    return null;
}

function getEngineeringList(){
    let valuation = curValuation;
    let valuationType = curValutionType;
    let valuationData = valuationType === 'bill' ? billValuation : rationValuation;
    let engineeringList = [];
    for(let tmp of valuationData) {
        if (tmp.id === valuation) {
            engineeringList = tmp.engineering_list;
            break;
        }
    }
    return engineeringList;
}



function getTaxGroupList(type){//getcalcProgramList
    let egrs = getEngineeringList();
    let groupList = [];
    //let egrID = $("#tender-engineering").val();
    let engLib = getEngineeringLib($('#tender-engineering').val() + $('#tender-feeStandard').val(), egrs);
    if(engLib){
        if(type){//是否要过滤，如果这个参数不传，则返回整个数组;
            for(let group of engLib.tax_group){
                if(group.taxType == type && group.program_lib){
                    groupList.push(group);
                }
            }
        }else {
            groupList = engLib.tax_group;
        }
    }
    /*for(let egr of egrs) {
        if (egr.engineering_id == egrID && egr.lib) {
            if(type){//是否要过滤，如果这个参数不传，则返回整个数组;
                for(let group of egr.lib.tax_group){
                    if(group.taxType == type && group.program_lib){
                        groupList.push(group);
                    }
                }
            }else {
                groupList = egr.lib.tax_group;
            }
        }
    }*/
    return groupList;
}

function getNodeByName(name, nodes){
    for(let i = 0, len = nodes.length; i < len; i++){
        if(name === nodes[i].data.name){
            return nodes[i];
        }
    }
    return null;
}

//建设项目名称是否有效的
function validProjectName(name) {
    let selected = projTreeObj.tree.selected,
        parent = null;
    if (selected && selected.data.projType === projectType.folder) {
        parent = selected ? selected : projTreeObj.tree._root;
    } else {
        if (selected && [projectType.tender, projectType.engineering].includes(selected.data.projType)) {
            selected = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent;
        }
        parent = selected ? selected.parent : projTreeObj.tree._root;
    }
    return !existName(name, parent.children);
}

//同级是否重名,文件夹与建设项目可以同名
function existName(name , nodes, projType = null){
    for(let i = 0, len = nodes.length; i < len; i++){
        if(name === nodes[i].data.name){
            if(projType && projType === projectType.folder && nodes[i].data.projType === projectType.project){
                continue;
            }
            return true;
        }
    }
    return false;
}

//获取新建单位工程时的建设项目数据
function getProjs(selected){
    let rst = [];
    let temp;
    let firstNode;
    if(!selected){
        temp = projTreeObj.tree._root;
        firstNode = temp.children[0];
    }
    else if(selected.data.projType === projectType.folder){
        temp = selected;
        firstNode = temp.children[0];
    }
    else if(selected.data.projType === projectType.project){
        temp = selected.parent;
        firstNode = temp.children[0];
    }
    else if(selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender){
        let proj = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent;
        temp = proj.parent;
        firstNode = proj;
    }
    for(let childNode of temp.children){
        if(childNode.data.projType === projectType.project){
            rst.push(childNode);
        }
    }
    if(firstNode){
        //firstNode to first place
        let index = null;
        for(let i = 0, len = rst.length; i < len; i++){
            if(rst[i].data.ID === firstNode.data.ID){
                index = i;
                break;
            }
        }
        if(index){
            rst.splice(index, 1);
            rst.splice(0, 0, firstNode);
        }
    }
    return rst;
}

function setFileOptions(projID){
    // 获取单价文件数据
    if(!projID){
        $("#unit-price").children("option:not(':first')").remove();
        let first = $("#tender-fee-rate").children("option").first();
        $("#tender-fee-rate").empty();
        $("#tender-fee-rate").append(first);

    }
    else {
        getUnitFile(projID, function (response) {
            $("#unit-price").children("option:not(':first')").remove();
            if (response.data.length <= 0) {
                return false;
            }
            let unitFileHtml = '';
            for(let tmp of response.data) {
                unitFileHtml += '<option value="'+ tmp.id +'">'+ tmp.name +'</option>';
            }
            $("#unit-price").children("option").first().after(unitFileHtml);
        });
        // 获取费率文件数据
        getFeeRateFile(projID, function (response) {
            let first = $("#tender-fee-rate").children("option").first();
            $("#tender-fee-rate").empty();
            $("#tender-fee-rate").append(first);
            if (response.data.length <= 0) {
                return false;
            }
            for(let tmp of response.data) {
                let option =  $("<option>").val(tmp.ID).text(tmp.name);
                $("#tender-fee-rate").append(option);
            }
        });
    }
}

//建设项目下拉框
function setProjOptions(projs, selected){
    $("#poj-name-list").empty();
    $("#poj-name").val("");
    if(projs.length > 0){
        let firstProj = selected && selected.data.projType === projectType.project ? selected: projs[0];
        curTaxType = firstProj.data.property.taxType || 1;
        if (firstProj.data.property.valuationType) {
            curValutionType = firstProj.data.property.valuationType;
        }
        if (firstProj.data.property.valuation) {
            curValuation = firstProj.data.property.valuation;
        }
        if (firstProj.data.property.valuationName) {
            curValuationName = firstProj.data.property.valuationName;
        }
        if (firstProj.data.property.valuation)
        getStdCalcProgramFiles();
        $("#poj-name").val(firstProj.data.name);
        setFileOptions(firstProj.data.ID);
        setEngOptions(firstProj.data.ID);
        for(let i = 0, len = projs.length; i < len; i++){
            let $proj = $(`<a class='text-ellipsis' title="${projs[i].data.name}">`).val(projs[i].data.ID).text(projs[i].data.name);
            $proj.addClass("dropdown-item");
            $proj.attr("href", "javascript:void(0);");
            $proj.click(function () {
                curTaxType = projs[i].data.property.taxType || 1;
                if (projs[i].data.property.valuationType) {
                    curValutionType = projs[i].data.property.valuationType;
                }
                if (projs[i].data.property.valuation) {
                    curValuation = projs[i].data.property.valuation;
                }
                if (projs[i].data.property.valuationName) {
                    curValuationName = projs[i].data.property.valuationName;
                }
                getStdCalcProgramFiles();
                $('#newProjectSet').hide();//隐藏文件类型、计税方法选项
                $("#poj-name").val(projs[i].data.name);
                setFileOptions(projs[i].data.ID);
                setEngOptions(projs[i].data.ID);
                $('#poj-name-info').hide();
            });
            $("#poj-name-list").append($proj);
        }
    }
    else {
        setFileOptions(null);
        setEngOptions(null);
    }
}
//单项工程下拉框
function setEngOptions(projID){
    let proj = projTreeObj.tree.findNode(projID) || null;
    $("#eng-name-list").empty();
    $("#eng-name").val("");
    if(proj){
        let engineerings = [].concat(proj.children);
        //set selected engineering to first place
        let selected = projTreeObj.tree.selected;
        let firstNode = null;
        if(selected && (selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender)){
            firstNode = selected.data.projType === projectType.engineering ? selected : selected.parent;
        }
        if(firstNode){
            let index = null;
            for(let i = 0, len = engineerings.length; i < len; i++){
                if(firstNode.data.ID === engineerings[i].data.ID){
                    index = i;
                }
            }
            if(index){
                engineerings.splice(index, 1);
                engineerings.splice(0, 0, firstNode);
            }
        }
        if(engineerings.length > 0){
            $("#eng-name").val(engineerings[0].data.name);
            for(let i = 0, len = engineerings.length; i < len; i++){
                //let eng = $("<button>").val(engineerings[i].data.ID).text(engineerings[i].data.name);
                let $eng = $('<a>').val(engineerings[i].data.ID).text(engineerings[i].data.name);
                $eng.prop('href', 'javascript:void(0);');
                $eng.addClass("dropdown-item");
                //eng.attr("type", "button");
                $eng.click(function () {
                    $("#eng-name").val(engineerings[i].data.name);
                    $('#eng-name-info').hide();
                });
                $("#eng-name-list").append($eng);
            }
        }
        /*if(engineerings.length > 0){
            $("#eng-name").val(engineerings[0].data.name);
            for(let i = 0, len = engineerings.length; i < len; i++){
                let eng = $("<button>").val(engineerings[i].data.ID).text(engineerings[i].data.name);
                eng.addClass("dropdown-item");
                eng.attr("type", "button");
                eng.click(function () {
                    $("#eng-name").val(engineerings[i].data.name);
                    $('#eng-name-info').hide();
                });
                $("#eng-name-list").append(eng);
            }
        }*/
    }
}

function hasTender(selected, pojName, engName, tenderName){
    let isExist = false;
    let tempProjs = getProjs(selected);
    if(pojName !== ''){
        let tempProj = getNodeByName(pojName, tempProjs);
        if(tempProj){
            if(engName !== ''){
                let tempEng = getNodeByName(engName, tempProj.children);
                if(tempEng){
                    let tempTender = getNodeByName(tenderName, tempEng.children);
                    if(tempTender){
                        isExist = true;
                    }
                }
            }
        }
    }
    return isExist;
}

//替换class
function replaceClass(selector, orgClass, newClass){
    selector.removeClass(orgClass);
    selector.addClass(newClass);
}
//设置提示信息
function setDangerInfo(area, info, show = true){
    if (info) {
        area.text(info);
    }
    if(show)
        area.show();
    else
        area.hide();
}

/**
 * 新增单项工程
 *
 * @return {boolean}
 */
function AddEngineering() {
    let name = $('#engineering-name').val().trim();
    if (name === '') {
        setDangerInfo($('#engineering-name-info'), '请填写单项工程名称');
        return false;
    }
    name = whiteSpaceCollapse(name);
    $.bootstrapLoading.start();
    let existCallback = function () {
        setDangerInfo($('#engineering-name-info'), `已存在“${$("#engineering-name").val()}”`);
        STATE.addingEng = false;
        $.bootstrapLoading.end();
    };
    let sucCallback = function () {
        $('#add-engineering-dialog').modal('hide');
        $('#engineering-name').val('');
        setDangerInfo($('#engineering-name-info'), '', false);
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingEng = false;
        }, 500);
    };
    let errCB = function () {
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingEng = false;
        }, 500);
    };
    let selectedItem = projTreeObj.tree.selected;
    // 如果选择的是单项工程则新增同级数据
    if(selectedItem){
        if(selectedItem.data.projType === projectType.project){
            AddChildrenItem(selectedItem, name, null, projectType.engineering, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.engineering){
            AddSiblingsItem(selectedItem, name, null, projectType.engineering, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.tender){
            let proj = selectedItem.parent;
            AddSiblingsItem(proj, name, null, projectType.engineering, existCallback, sucCallback, errCB);
        }
    }
}

/**
 * 新增单位工程
 *
 * @return {boolean}
 */
function AddTender() {
    try {
        let projName = $("#poj-name").val().trim();
        if(projName === ''){
            replaceClass($('#poj-name-info'), 'text-info', 'text-danger');
            setDangerInfo($('#poj-name-info'), '请填写建设项目名称');
            return false;
        }
        projName = whiteSpaceCollapse(projName);
        let engName = $("#eng-name").val().trim();
        if(engName === ''){
            replaceClass($('#eng-name-info'), 'text-info', 'text-danger');
            setDangerInfo($('#eng-name-info'), '请填写单项工程名称');
            return false;
        }
        engName = whiteSpaceCollapse(engName);
        let tenderName = $('#tender-name').val();
        if (tenderName === '') {
            setDangerInfo($('#tender-name-info'), '请填写单位工程名称');
            return false;
        }
        tenderName = whiteSpaceCollapse(tenderName);
        if(hasTender(projTreeObj.tree.selected, projName, engName, tenderName)){
            return false;
        }

        let unitPriceFileObj = getAddTenderFile(tenderName, $('#unit-price'), $("#unit-price").children());
        let feeFileObj = getAddTenderFile(tenderName, $('#tender-fee-rate'), $("#tender-fee-rate").children());

        //let valuation = $("#valuation").val();
        let valuation = curValuation;   //跟建设项目一样的计价规则

        let engineeringName = $("#tender-engineering").val();
        if (!engineeringName || engineeringName === '') {
            setDangerInfo($('#engineering-info'), '请选择工程专业');
            return false;
        }
        let feeName = $('#tender-feeStandard').val();
        if(!feeName || feeName === ''){
            setDangerInfo($('#feeStandard-info'), '请选择费用标准');
            return false;
        }
        //
        //计税方法由原本的跟单位工程绑定，改成跟建设项目绑定，为了减少项目出错几率，新建时保留单位工程的计税方法，值为建设项目的计税方法值
        let taxTypeTender = curTaxType;
        let IDGroup = $("#tender-calcProgram").val();
        if (!IDGroup || IDGroup === '') {
            setDangerInfo($('#calcProgram-info'), '请选择计算程序');
            return false;
        }
        IDGroup = IDGroup.split("|-|");

        let calcProgram = isNaN(parseInt(IDGroup[0]))?IDGroup[0]:parseInt(IDGroup[0]);//转换成整数
        let templateLibID = IDGroup[1];
        let colLibID = IDGroup[2];
        let feeLibID = IDGroup[3];
        if(templateLibID == ''|| colLibID ==''||feeLibID==''){
            alert("工程专业配置有误！");
            return false;
        }
        //如果是新建费率的情况
        if(feeFileObj.id.indexOf("newFeeRate")!=-1) feeFileObj.id +=feeLibID;
        let valuationName = curValuationName;   //跟建设项目一样的计价方式
        let valuationType = curValutionType;    //跟建设项目一样的计价方式

        let engineering = undefined;
        let valuationData = valuationType === 'bill' ? billValuation : rationValuation;
        let engineeringList = [];
        for(let tmp of valuationData) {
            if (tmp.id === valuation) {
                engineeringList = tmp.engineering_list;
                break;
            }
        }
        let libs = getEngineeringLib(engineeringName + feeName, engineeringList);
        if(!libs){
            alert('数据错误，无法确定工程专业库!');
            return false;
        }
        // 一个项目里面，这两个文件必须得有，而界面又没有像费率、单价文件那样给出可选项。所以这里给出提示。
        if (!libs.artificial_lib)  throw '编办没有绑定人工系数标准文件';

        let featureLibID = "";
        if(libs.feature_lib && libs.feature_lib.length > 0) featureLibID = libs.feature_lib[0].id;


        let calcProgramName = $('#tender-calcProgram').children("option:selected").text();
        $.bootstrapLoading.start();
        let callback = function() {
                $("#add-tender-dialog").modal("hide");
                $('#tender-name').val('');
                $("#tender-fee-rate").children("option").removeAttr("selected");
                $("#tender-engineering").children("option").removeAttr("selected");
                $("#tender-calcProgram").children("option").removeAttr("selected");
                $("#poj-name").val('');
                $("#poj-name-info").hide();
                $("#eng-name").val('');
                $("#eng-name-info").hide();
                $.bootstrapLoading.end();
                setTimeout(function () {
                    STATE.addingTender = false;
                }, 500);
            },
            errCB = function () {
                $.bootstrapLoading.end();
                setTimeout(function () {
                    STATE.addingTender = false;
                }, 500);
            };
        let selectedItem = projTreeObj.tree.selected;
        //地区
        let region = $('#regionDiv').find('select').val() || '全省';
        let tenderInfo = {
            gljAdjustType: 'priceInfo', //默认为造价信息差额调整法
            valuation: valuation,
            valuationType: valuationType,
            valuationName: valuationName,
            isInstall: libs.isInstall !== undefined ? libs.isInstall : false,
            isItemIncrease: !!libs.isItemIncrease,
            isAreaIncrease: !!libs.isAreaIncrease,
            engineering: libs.engineering,//定额默认取费专业
            projectEngineering:libs.projectEngineering,//单位工程默认取费专业（造价书中插入量价、工料机时用）
            engineering_id: libs._id,
            engineeringName: engineeringName,
            feeStandardName: feeName,
            unitPriceFile: {name: unitPriceFileObj.name, id: unitPriceFileObj.id},
            feeFile: {name: feeFileObj.name, id: feeFileObj.id},
            calcProgram: {name: calcProgramName, id: calcProgram},
            taxType:taxTypeTender,
            templateLibID:templateLibID,
            colLibID:colLibID,
            featureLibID:featureLibID,
            region: region,
            projectFeature: featureData ? featureData : []
        };
        //导出指标信息
        if(libs.indexName) tenderInfo.indexName = libs.indexName;
        if(libs.engineer_info_lib && libs.engineer_info_lib.length > 0) tenderInfo.engineerInfoLibID = libs.engineer_info_lib[0].id;
        if(libs.engineer_feature_lib && libs.engineer_feature_lib.length > 0) tenderInfo.engineerFeatureLibID = libs.engineer_feature_lib[0].id;
        if(libs.economic_lib && libs.economic_lib.length > 0) tenderInfo.economicLibID = libs.economic_lib[0].id;
        if(libs.main_quantity_lib && libs.main_quantity_lib.length > 0) tenderInfo.mainQuantityLibID = libs.main_quantity_lib[0].id;
        if(libs.material_lib && libs.material_lib.length > 0) tenderInfo.materialLibID = libs.material_lib[0].id;

        AddTenderItems(selectedItem, projName, engName, tenderName, tenderInfo, callback, errCB);

    } catch (error) {
        $('#add-tender-confirm').removeClass('disabled');
        alert(error);
    }
}
/*
* 新增单位工程时选择的文件
* @tenderName {String}
* @selValue {String}
* @options {Array}
* */
function getAddTenderFile(tenderName, selected, options){
    let rst = {name: '', id: ''};
    let selValue = selected.val();
    //选择的是新建单价/费率文件
    if(selValue === ''){
        //若新建的单位工程名称与建设项目下文件重名，则引用该文件
        for(let i = 0; i < options.length; i++){
            if(i === 0){
                continue;
            }
            let option = options[i];
            if($(option).text() === tenderName){
                rst.id = $(option).val();
                break;
            }
        }
        rst.name = tenderName;
    }
    //非新建
    else{
        rst.id = selected.val();
        rst.name =  selected.children("option:selected").text();
    }
    return rst;
}


/**
 * 新增文件夹
 *
 * @return {boolean}
 */
function AddFolder() {
    let name = $('#folder-name').val().trim();
    if (name === '') {
        setDangerInfo($('#folder-name-info'), '请填写文件夹名称');
        return false;
    }

    let selectedItem = projTreeObj.tree.selected;
    let existCallback = function () {
        setDangerInfo($('#folder-name-info'), `已存在“${$("#folder-name").val()}”`);
        STATE.addingFolder = false;
        $.bootstrapLoading.end();
    };
    $.bootstrapLoading.start();
    let sucCallback = function () {
        $('#add-folder-dialog').modal('hide');
        $('#folder-name').val('');
        setDangerInfo($('#folder-name-info'), '', false);
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingFolder = false;
        }, 500);
    };
    let errCB = function () {
        $.bootstrapLoading.end();
        setTimeout(function () {
            STATE.addingFolder = false;
        }, 500);
    };
    if (selectedItem) {
        // 判断是否超过3层
        if(!withinTreble(selectedItem)){
            alert("文件夹不能超过3层");
            return false;
        }
        if(selectedItem.data.projType === projectType.folder || selectedItem.data.projType === projectType.project){
            AddSiblingsItem(null, name, null, projectType.folder, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.engineering || selectedItem.data.projType === projectType.tender){
            let proj = selectedItem.parent.data.projType === projectType.project ? selectedItem.parent : selectedItem.parent.parent;
            AddSiblingsItem(proj, name, null, projectType.folder, existCallback, sucCallback, errCB);
        }
    } else {
        AddSiblingsItem(null, name, null, projectType.folder, existCallback, sucCallback, errCB);
    }
}

function getFolderLevel(selected) {
    let level = 0;
    while(selected && selected.data) {
        if (selected.data.projType === projectType.folder) {
            level++;
        }
        selected = selected.parent;
    }
    return level;
}

// 选中节点及其子项最大文件夹层数
function getMaxFolderLevel(selected) {
    const nodes = [selected, ...selected.getAllChildren()];
    const levels = nodes.map(node => getFolderLevel(node));
    return Math.max(...levels);
}

//判断是否是三层文件夹以内
function withinTreble(selectedItem){
    let rst;
    if(selectedItem.data.projType === projectType.engineering || selectedItem.data.projType === projectType.tender){
        selectedItem = selectedItem.parent.data.projType === projectType.project ? selectedItem.parent : selectedItem.parent.parent;
    }
    if(selectedItem.parent.parent && hasFolder(selectedItem.parent.parent.children) && selectedItem.parent.parent.parent && hasFolder(selectedItem.parent.parent.parent.children)
        && selectedItem.parent.parent.parent.parent && hasFolder(selectedItem.parent.parent.parent.parent.children)){
        return false;
    }
    return true;
    function hasFolder(items){
        for(let i = 0, len = items.length; i < len; i++){
            if(items[i].data.projType === projectType.folder){
                return true;
            }
        }
        return false;
    }
}

/**
 * 组织更新数据
 *
 * @param {Object} parent
 * @param {Object} next
 * @param {String} name
 * @param {Object} type
 * @return {Object}
 */
function GetUpdateData(pre, parent, next, name, property, newId, type) {
    let data = [];
    let updateData = {};

    let rootProjectID = -1;
    if(type.projectType === projectType.tender){
        let rootProject = parent ? parent.parent : projTreeObj.tree._root;
        rootProjectID = rootProject ? rootProject.id() : -1;
        if(property){
            property.rootProjectID=rootProjectID;
        }
    }

    updateData['updateType'] = type.updateType === undefined ? 'new' : type.updateType;
    updateData['updateData'] = {};
    if (newId !== '') {
        updateData['updateData'][projTreeObj.tree.setting.tree.id] = newId;
    }
    updateData['updateData'][projTreeObj.tree.setting.tree.pid] = parent ? parent.id() : -1;
    updateData['updateData'][projTreeObj.tree.setting.tree.nid] = next ? next.id() : -1;
    if (name !== '') {
        updateData['updateData']['name'] = name;
    }
    if (property !== null && property !== undefined) {
        updateData['updateData']['property'] = property;
    }
    if (type !== null && type.projectType !== null) {
        updateData['updateData']['projType'] = type.projectType !== undefined ? type.projectType : 'Tender';
    }
    if(pre){//维护preNode
        let updateObj = Object.create(null);
        updateObj.updateData = Object.create(null);
        updateObj.updateType = 'update';
        updateObj.updateData.ID = pre.id();
        updateObj.updateData.NextSiblingID = newId;
        data.push(updateObj);
    }
    data.push(updateData);
    return data;
}

/**
 * 获取删除数据
 *
 * @return {Object} node
 * @return {Object}
 */
function GetDeleteUpdateData(node) {
    let datas = [], updateData,
        pre = node.preSibling(),
        deleteNodeData = function (node) {
            var data = Object.create(null);
            data['updateType'] = 'delete';
            //data['NextSiblingID'] = node.data.NextSiblingID;
            data['updateData'] = Object.create(null);
            data['updateData'][projTreeObj.tree.setting.tree.id] = node.id();
            data['updateData']['projType'] = node.data.projType;
            if (node.data.projType === 'Tender') {
                data['updateData']['FullFolder'] = GetFullFolder(node.parent);
            }
            return data;
        },
        addDeleteChildren = function (children) {
            children.forEach(function(child){
                datas.push(deleteNodeData(child));
                addDeleteChildren(child.children);
            });
        };
    if (pre && pre.id() !== -1) {
        updateData = {};
        updateData['updateType'] = 'update';
        updateData['updateData'] = {};
        updateData['updateData'][projTreeObj.tree.setting.tree.id] = pre.id();
        updateData['updateData'][projTreeObj.tree.setting.tree.nid] = node ? node.nid() : -1;
        datas.push(updateData);
    }
    datas.push(deleteNodeData(node));
    addDeleteChildren(node.children);
    return datas;
};

/**
 * 获取父级所有名称
 *
 * @return {Array}
 */
function GetFullFolder (node) {
    let fullFolder = [];
    let cur = node;
    while (cur && cur.data) {
        fullFolder.unshift(cur.data.name);
        cur = cur.parent;
    }
    return fullFolder;
}

/**
 * 获取需要更新的前节点
 *
 * @param {Object} parent
 * @param {Object} next
 * @return {Object}
 */
function GetNeedUpdatePreNode(parent, next) {
    if (next) {
        return next.preSibling();
    } else if (parent) {
        return parent.firstChild();
    } else {
        return null;
    }
}

/**
 * 获取最新id
 *
 * @param {function} callback
 * @return {void}
 */
function GetNewProjectId(count, callback, errCB) {
    CommonAjax.post('/pm/api/getNewProjectID', {count: count}, function(data) {
        callback(data);
    }, errCB);
}

/**
 * 重命名项目
 *
 * @param {Number} projectId
 * @param {String} newName
 * @param {Number} parentID
 * @param {function} callback
 * @return {void}
 */
function RenameProject(projectId, newName, parentID, callback) {
    $.ajax({
        type: "POST",
        url: '/pm/api/renameProject',
        data: {'data': JSON.stringify({"user_id": userID, "id": projectId, "newName": newName, "parentID": parentID})},
        dataType: 'json',
        cache: false,
        timeout: 5000,
        success: function(result){
            if (result.error === 0) {
                callback();
            } else {
                if(result.message === '同级目录已存在相同名称数据'){
                    setDangerInfo($('#rename-name-info'), `已存在“${newName}”`);
                }
            }
        },
        error: function(iqXHR, textStatus, errorThrown){
            alert('error ' + textStatus + " " + errorThrown)
        }
    });
}

/**
 * 转换当前树结构为zTree结构
 *
 * @param {Object} Tree
 * @param {Object} zTreeObj
 * @param {Object} filterNode
 * @return {Mixed}
 */
function ConvertTreeToZtree(Tree, zTreeObj, filterNode) {
    let setting = {
        data: {
            simpleData: {
                enable:true,
                idKey: "id",
                pIdKey: "pId",
                rootPId: "-1"
            }
        }};
    let zTreeData = [],
        exportNodesData = function (nodes) {
            nodes.forEach(function (node) {
                if (node !== filterNode) {
                    var data = {};
                    data['id'] = node.data[Tree.setting.tree.id];
                    data['pId'] = node.pid();
                    data['name'] = node.data['name'];
                    data['isParent'] = node.data.projType === 'Folder';//(node.data.projType === 'Folder' && node.children.length === 0);
                    data['open'] = node.data.projType === 'Folder';//node.children.length !== 0;
                    zTreeData.push(data);
                    exportNodesData(node.children);
                }
            })
        };
    exportNodesData(Tree._root.children);
    return $.fn.zTree.init(zTreeObj, setting, zTreeData);
}

/**
 * 获取指定zTree节点
 *
 * @param {Object} zTreeObj
 * @return {object}
 */
function GetTargetTreeNode(zTreeObj) {
    if (!zTreeObj || !projTreeObj.tree) {
        return null;
    }

    let ztree_selected = zTreeObj.getSelectedNodes().length === 0 ? null : zTreeObj.getSelectedNodes()[0];
    return ztree_selected ? projTreeObj.tree.findNode(ztree_selected.id) : null;
}

/**
 * 根据指定id获取对应的工程专业
 *
 * @param {Array} engineeringList
 * @return {String}
 */
function getEngineeringHtml(engineeringList) {
    let result = '';
    if (engineeringList.length <= 0) {
        return result;
    }
    let engLibNames = [];
    for(let i = 0; i < engineeringList.length; i++){
        let tmp = engineeringList[i];
        if(engLibNames.includes(tmp.lib.name)){
           continue;
        }
        result += `<option ${i === 0 ? 'selected' : ''} value="${tmp.lib.name}">${tmp.lib.name}</option>`;
        engLibNames.push(tmp.lib.name);
    }
    return result;
}

/**
 * 远程获取项目属性数据
 *
 * @param {Object} projectInfo
 * @return {void}
 */
function getProperty(projectInfo) {
    if (projectInfo.property === undefined) {
        return;
    }
    projectProperty = projectInfo.property;
    // 写入专业工程相关
    let engineeringHtml = getEngineeringHtml(projectProperty.engineeringList);
    $("#tender-engineering").html(engineeringHtml);

    // 填入计价规则
    let valuationHtml = '<option value="'+ projectProperty.valuation +'">'+ projectProperty.valuationName +'</option>';
    $("#tender-valuation").html(valuationHtml);

    // 选中计价方式
    $("input[name='tender_valuation_type']").attr('disabled', 'disabled').removeAttr('checked', 'checked');
    $("input[name='tender_valuation_type'][value='"+ projectProperty.valuationType +"']")
        .attr("checked", "checked").removeAttr('disabled', 'disabled');
}

/**
 * 获取单价文件
 *
 * @param {Number} parentID
 * @return {void}
 */
function getUnitFile(parentID, callback) {
    parentID = parseInt(parentID);
    if (isNaN(parentID) && parentID <= 0) {
        return;
    }

    $.ajax({
        url: '/pm/api/getUnitFile',
        type: 'post',
        data: {'data': JSON.stringify({"user_id": userID, "parentID": parentID})},
        dataType: 'json',
        error: function() {
            alert('数据传输错误!');
        },
        beforeSend: function() {

        },
        success: function(response) {
            if (response.error === 1) {
                alert('获取失败!');
            } else {
                if(callback){
                    callback(response);
                }
            }
        }
    });

}
/**
 * 获取费率文件
 *
 * @param {Number} parentID
 * @return {void}
 */
function getFeeRateFile(parentID, callback) {
    parentID = parseInt(parentID);
    if (isNaN(parentID) && parentID <= 0) {
        return;
    }

    $.ajax({
        url: '/pm/api/getFeeRateFile',
        type: 'post',
        data: {'data': JSON.stringify({"user_id": userID, "parentID": parentID})},
        dataType: 'json',
        error: function() {
            alert('数据传输错误!');
        },
        beforeSend: function() {

        },
        success: function(response) {
            if (response.error === 1) {
                alert('获取失败!');
            } else {
                if(callback){
                    callback(response);
                }
            }
        }
    });

}


/**
 * 加载数据到侧边栏
 *
 * @return {void}
 */
function setDataToSideBar() {
    // 获取当前点击的数据
    let that = projTreeObj;
    let selectedItem = that.tree.selected;
    while ([projectType.tender, projectType.engineering].includes(selectedItem.data.projType) && selectedItem.parent){
        selectedItem = selectedItem.parent;
    }
    let name = selectedItem.data.name;
    let target = selectedItem.data.projType === projectType.project ? '#summary-project' : '#summary-engineering';
    $(".side-content .p-3").hide();
    $(target).show();

    // 加载单价文件与费率文件
    if (selectedItem.data.projType === projectType.project) {
        let engineeringData = selectedItem.children !== null && selectedItem.children.children !== null ?
            selectedItem.children : [];
        /*if (engineeringData.length <= 0) {
         return;
         }*/
        let unitPriceFileList = [];
        let feeFileList = [];
        let poj_tenders = getProjTenders(selectedItem);
        getUnitFile(selectedItem.data.ID, function (response) {
            unitPriceFileList = unitPriceFileList.concat(response.data);
            $(target + '-unit-price-table tbody').empty();
            set_file_table(target, poj_tenders, unitPriceFileList, fileType.unitPriceFile);
        });
        getFeeRateFile(selectedItem.data.ID, function (response) {
            feeFileList = feeFileList.concat(response.data);
            $(target + '-fee-table tbody').empty();
            set_file_table(target, poj_tenders, feeFileList, fileType.feeRateFile);
        });
    }
}

//获取建设项目的全部单位工程
function getProjTenders(proj) {
    if(proj.data.projType === projectType.tender){
        proj = proj.parent.parent;
    }
    else if(proj.data.projType === projectType.engineering){
        proj = proj.parent;
    }
    let rst = [];
    let engineerings = proj.children || null;
    if (engineerings) {
        for (let i = 0, len = engineerings.length; i < len; i++) {
            let e_tenders = engineerings[i].children || null;
            if (e_tenders && e_tenders.length > 0) {
                rst = rst.concat(e_tenders);
            }
        }
    }
    return rst;
}
//单价、费率文件汇总信息的使用次数、使用该文件的单位工程
function getUsedObj(tenders, fileId, type){
    let rst = Object.create(null), usedCount = 0, usedInfo = '';
    rst.usedCount = 0;
    rst.usedInfo = null;
    for(let i = 0, len = tenders.length; i < len; i++){
        if(tenders[i].data.property){
            let theFile = type === fileType.unitPriceFile ? tenders[i].data.property.unitPriceFile || null : tenders[i].data.property.feeFile || null;
            if(theFile && theFile.id == fileId){
                usedCount ++;
                usedInfo += tenders[i].data.name + '<br>';
            }
        }
    }
    if(usedCount > 0){
        usedInfo = usedInfo.slice(0, usedInfo.length - 4);
        rst.usedCount = usedCount;
        rst.usedInfo = usedInfo;
    }
    return rst;
}

//单价、费率文件汇总界面交互
function bindEvents_file_table(jqS, usedObj, targetBody, type){
    //悬浮显示删除和重命名按钮
    $(jqS).hover(function(){
        $('p',this).show();
    },function(){
        $('p', this).hide();
    });
    //删除
    if(usedObj.usedCount > 0){//不可删除
        $(jqS + ' p a:eq(0)').addClass('disabled');
        $(jqS + ' p a:eq(0)').removeAttr('data-target');
    }
    else {
        $(jqS + ' p a:eq(0)').on('click', function () {
            let dispName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
            //刷新删除弹出框内容
            let delData = '删除"' + dispName + '"？';
            $('#del-wj .modal-body h5').text(delData);
            let attrId = $(jqS).attr('id');
            let id = attrId.slice(5, attrId.length);
            if(type === fileType.unitPriceFile){
                id = parseInt(id);
            }
            let obj = Object.create(null);
            obj.fileType = type;
            obj.id = id;
            fileDelObj = obj;
        });
    }
    //重命名
    let fileObjs = getFileObj(targetBody, type),
        fileDiv = $(jqS + ' div:eq(0)'),
        renameDiv = $(jqS + ' div:eq(1)'),
        hintText = $(jqS).find('span'),
        postFix = '';
    $(jqS + ' p a:eq(1)').on('click', function () {
        let orgDispName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
        let orgName = orgDispName;
        $(jqS + ' input').val(orgName);
        fileDiv.hide();
        renameDiv.show();
        $(jqS).find('input:eq(0)').focus();
        $(jqS).find('input:eq(0)').blur(function () {
            fileDiv.show();
            renameDiv.hide();
            hintText.hide();
        });
    });
    //回车键确认重命名
    $(jqS).find('input:eq(0)').keypress(function (e) {
        if(e.keyCode === 13){
            let orgName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
            let attrId = $(jqS).attr('id');
            let id = attrId.slice(5, attrId.length);
            let newName = $(jqS + ' input').val().trim();
            if(newName !== orgName){
                if(hasThisFileName(fileObjs, newName)){
                    hintText.show();
                    return;
                }
                if(newName.trim().length === 0){
                    alert('文件名不可为空！');
                    $(jqS + ' input').val(orgName);
                    return;
                }
                //ajax
                let updateObj = Object.create(null);
                updateObj.fileType = type;
                updateObj.updateType = 'update';
                updateObj.updateData = Object.create(null);
                if(type === fileType.unitPriceFile){
                    updateObj.updateData.id = parseInt(id);
                }
                else if(type === fileType.feeRateFile){
                    updateObj.updateData.ID = id;
                }
                updateObj.updateData.name = newName;
                a_updateFiles([updateObj], function () {
                    let newDispName = newName + postFix;
                    fileDiv[0].childNodes[0].textContent = newDispName;
                    fileDiv.show();
                    renameDiv.hide();
                    //refresh tender
                    refreshTenderFile(getTendersByFile(type, id, projTreeObj.tree.selected), type, newName);
                });
            }
            let newDispName = newName + postFix;
            fileDiv[0].childNodes[0].textContent = newDispName;
            fileDiv.show();
            renameDiv.hide();
            hintText.hide();
        }
    });
    //悬浮框显示使用该文件的单位工程
    $($(jqS)[0].nextSibling).popover({
            placement:"bottom",
            html:true,
            trigger:"hover", //| focus.
            content: usedObj.usedInfo ? usedObj.usedInfo : ''
        }
    );
}

//更新单价、费率文件（删除、重命名）
function a_updateFiles(updateDatas, callback){
    $.ajax({
        type: 'post',
        url: '/pm/api/updateFiles',
        data: {data: JSON.stringify({user_id: userID, updateDatas: updateDatas})},
        dataType: 'json',
        success: function (result){
            if(!result.error && callback){
                callback();
            }
        }
    })
}

function set_file_table(target, poj_tenders, fileList, type){
    let fileCounter = 1;
    for(let i = 0, len = fileList.length; i < len; i++){
        let fileId = type === fileType.unitPriceFile ? fileList[i].id : fileList[i].ID;
        let usedObj = getUsedObj(poj_tenders, fileId, type);
        let usedHtml = usedObj.usedCount > 0 ?  '<td class="text-center"><a href="javascript:void(0);">' + usedObj.usedCount + '</a></td>' : '<td class="text-center">' + usedObj.usedCount + '</td>';
        let hoverHtml = '<p style="display: none; height: 14px;"><a class="btn btn-sm" href="javascript:void(0);" data-toggle="modal" data-target="#del-wj">删除</a><a class="btn btn-sm" href="javascript:void(0);">重命名</a></p></div>';
        let renHtml = '<div class="input-group" style="display: none;">'
            + '<input class="form-control form-control-sm" value="">'

            + '</div>'
            + '<span class="form-text text-danger" style="display: none">本建设项目已存在该文件名，请重新输入！' +
            '</span></td>';
        let fileTypeStr = type === fileType.unitPriceFile ? '单价文件' : '费率文件';
        let fileHtml = '<tr><td>' + fileCounter + '</td><td id="file_' + fileId + '"><div>' + fileList[i].name + hoverHtml + renHtml + usedHtml + '</tr>';
        fileCounter++;
        let targetBody = type === fileType.unitPriceFile ? target + '-unit-price-table tbody' : target + '-fee-table tbody';
        $(targetBody).append(fileHtml);
        let jqS = '#file_' + fileId;
        bindEvents_file_table(jqS, usedObj, targetBody, type);
    }
}

function getFileObj(jqS, type){
    let rst = [];
    let trs = $('tr', jqS);
    for(let i = 0, len = trs.length; i < len; i++){
        let td = $('td:eq(1)', trs[i])[0];
        let name = td.childNodes[0].childNodes[0].textContent;
        let attrId = $(td).attr('id');
        let id = attrId.slice(5, attrId.length);
        if(type === fileType.unitPriceFile){
            id = parseInt(id);
        }
        let obj = Object.create(null);
        obj.id = id;
        obj.name = name;
        rst.push(obj);
    }
    return rst;
    //let orgDispName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
}

function hasThisFileName(fileObjs, name){
    for(let i = 0, len = fileObjs.length; i < len; i++){
        if(fileObjs[i].name === name){
            return true;
        }
    }
    return false;
}

//获得使用此单价、费率文件的项目节点
function getTendersByFile(type, fileId, project){
    let rst = [];
    let tenders = getProjTenders(project);
    for(let tender of tenders){
        if(type === fileType.unitPriceFile && tender.data.property && tender.data.property.unitPriceFile){
            if(fileId == tender.data.property.unitPriceFile.id){
                rst.push(tender);
            }
        }
        else if(type === fileType.feeRateFile && tender.data.property && tender.data.property.feeFile){
            if(fileId == tender.data.property.feeFile.id){
                rst.push(tender);
            }
        }
    }
    return rst;
}

//重命名单价、费率文件后，刷新使用此文件的节点
function refreshTenderFile(tenders, type, newName){
   projTreeObj.renderSheetFuc(projTreeObj.workBook.getActiveSheet(), function () {
       for(let tender of tenders){
           if(type === fileType.unitPriceFile){
               tender.data.property.unitPriceFile.name = newName;
           }
           else if(type === fileType.feeRateFile){
               tender.data.property.feeFile.name = newName;
           }
           projTreeObj.refreshNodeData(tender);
       }
   });
}
//添加分享 pm share共用
const shareType = {create: 'create', cancel: 'cancel'};
let shareSeleted = null;
let shareUserID = null;
let canShare = false;
$('#sharePhone').bind('keypress', function (e) {
    if(e.keyCode === 13){
        $(this).blur();
    }
});
function shareTender(){
    canShare = false;
    let phone = $('#sharePhone').val();
    const hintInfo = $('#share-info');
    const userInfo = $('#shareFindDiv');
    const addUser = $('#addShareUser');
    const copyInput = $('#allowCopy');
    const coopInput = $('#allowCooperate');
    const shareConfirm = $('#share-confirm');
    shareConfirm.addClass('disabled');
    //可分享才可添加用户
    addUser.addClass('disabled');
    if (hintInfo.is(':visible')) {
        hintInfo.hide();
    }
    if(!phone || phone.trim() === ''){
        setDangerInfo(hintInfo, '请输入手机号码。', true);
        if(userInfo.is(':visible')){
            userInfo.hide();
        }
        return;
    }
    //根据手机号获取用户
    CommonAjax.post('/user/getUserByMobile', {mobile: phone}, function (userData) {
        if(!userData){
            setDangerInfo(hintInfo, '账号不存在。', true);
            if(userInfo.is(':visible')){
                userInfo.hide();
            }
            return;
        }
        else{
            if(userData._id === userID){
                setDangerInfo(hintInfo, '不可分享给自己。', true);
                return;
            }
            shareUserID = userData._id;
            setDangerInfo(hintInfo, '', false);
            $('#user_name').text(userData.real_name ? userData.real_name : '');
            $('#user_company').text(userData.company ? userData.company : '');
            $('#user_mobile').text(userData.mobile ? userData.mobile : '');
            $('#user_email').text(userData.email ? userData.email : '');
            //默认可拷贝
            copyInput.prop('checked', true);
            //默认不可协作
            coopInput.prop('checked', false);
            userInfo.show();
            //判断项目是否已经分享
            CommonAjax.post('/pm/api/getProjectShareInfo', {user_id: userID, projectID: shareSeleted.data.ID}, function (shareInfo) {
                for(let shareData of shareInfo){
                    if(shareData.userID === userData._id){
                        setDangerInfo(hintInfo, '已与该用户分享。', true);
                        return;
                    }
                }
                addUser.removeClass('disabled');
                shareConfirm.removeClass('disabled');
                canShare = true;
            });
        }
    });
}
$('#sharePhone').on('keyup',function () {
    delayKeyup(function () {
        shareTender();
    });
});

//确认分享
$('#share-confirm').click(function(){
    const hintInfo = $('#share-info');
    $.bootstrapLoading.start();
    const perHeight = 30;
    let allowCopy = $('#allowCopy').prop('checked'),
        allowCoop = $('#allowCooperate').prop('checked');
        userName = $('#user_name').text() || '',
        userCompany = $('#user_company').text() || '',
        userMobile = $('#user_mobile').text() || '',
        userEmail = $('#user_email').text() || '';
    let shareData = [{userID: shareUserID, allowCopy: allowCopy, allowCooperate: allowCoop}];
    //分享
    CommonAjax.post('/pm/api/share', {user_id: userID, type: shareType.create,  projectID: shareSeleted.data.ID, shareData: shareData}, function (rstData) {
        //更新已分享table
        let $tr = $(`<tr>
                        <td style="width: 112px">${userName}</td>
                        <td style="width: 165px">${userCompany}</td>
                        <td style="width: 136px">${userMobile}</td>
                        <td style="width: 136px">${userEmail}</td>
                        <td style="width: 90px;"><input value="allowCopy" ${allowCopy ? 'checked' : ''} type="checkbox"></td>
                        <td style="width: 90px;"><input value="allowCooperate" ${allowCoop ? 'checked' : ''} type="checkbox"></td>
                        <td style="width: 90px;"><input value="cancelShare" type="checkbox"></td>
                    </tr>`);
        let tbodyTotalHeight = $('#shareToInfo').height() + perHeight > 200 ? 200 : $('#shareToInfo').height() + perHeight;
        $('#shareToInfo').height(tbodyTotalHeight);
        $('#shareToInfo').append($tr);
        //更新缓存
        shareSeleted.data.shareInfo = shareSeleted.data.shareInfo.concat(shareData);
        let sheet = projTreeObj.workBook.getSheet(0);
        projTreeObj.renderSheetFuc(sheet, function () {
            sheet.invalidateLayout();
            sheet.repaint();
        });
        bindCancelShareCheck(shareSeleted);
        $.bootstrapLoading.end();
        $('#shareFindDiv').hide();
        $('#share-confirm').addClass('disabled');
    }, function () {
        $.bootstrapLoading.end();
        $('#share-confirm').removeClass('disabled');
    });
});

//批量替换文件，切换建设项目
$('#otherProject').change(function(){
    let optionList = [],idField = 'ID';
    var newVal = $(this).val();
    var projects = projTreeObj.changeInfo.others;
    var selected = _.find(projects,{ID:parseInt(newVal)});
    if($("#mr_from").val() =="unitPriceFile"){
        idField = 'id';
        optionList = selected.unitPriceList;
    }else {
        optionList =  selected.optionList;
    }
    $('#otherFileOptions').empty();
    for(let f of optionList){
        let option =  $("<option>").val(f[idField]).text(f.name);
        $('#otherFileOptions').append(option);
    }
});

//分享给...界面确认
$('#shareToConfirm').click(function () {
    let selected = projTreeObj.tree.selected;
    if (!selected) {
        return;
    }
    updateShareInfo(selected);
});



$("#confirm-import").click(function() {
    //$.bootstrapLoading.start();
    if (STATE.importing) {
        return;
    }
    STATE.importing = true;

    let input = $("input[name='import_project_data']")[0];
    if (input.files.length <= 0) {
        throw '请选择文件!';
    }
    let token = projTreeObj.uptoken;
    $('#import').modal("hide");
    $.bootstrapLoading.progressStart("上传文件中",true);
    let file = input.files[0];
    let key = uuid.v1() + ".ybp"; //file.name;
    if (file) {
        const callback = () => {
            $("#progress_modal_body").text("正在导入建设项目");
            startImportProject(key);
            projTreeObj.uptoken = null;
        };
        UPLOAD_CDN.upload(file, key, token, callback);
    }

    async function  startImportProject(key) {
        try {
            let result = await ajaxPost("/pm/api/importProject",{key:key,updateData:projTreeObj.getImportProjectDate()});
            importProcessChecking(key, null, (projectData) => handleProjectAfterChecking(projectData));
        }catch (error){
            alert(error);
        }finally {
            STATE.importing = false;
        }
    }
});

$("#import_project_data").change(function(){
    let file = $(this)[0];
    let projectFile = file.files[0];
    if(projectFile) {
        let ybpReg = /ybp$/g;
        if(projectFile.name && ybpReg.test(projectFile.name)){
            $('#import_project_label').text(`${projectFile.name}`);
            $('#confirm-import').removeAttr("disabled");
        }else {
            alert("请选择ybp项目文件");
            $(this).val('');
            $('#confirm-import').attr("disabled","disabled");
        }
    }
});

//清空导入清单选择文件
$('#import').on('show.bs.modal', function(){
    $('#import_project_data').val('');
    $('.custom-file-label').text(`请选择建设项目文件`);
});


//设置分享给界面数据
//@param {Object}selected @return {void}
function setShareToModal(selected){
    $.bootstrapLoading.start();
    const perHeight = 30; //每条分享给数据的高度
    $('#shareToInfo').empty();
    if(!selected){
        return;
    }
    let userIDs = [];
    for(let user of selected.data.shareInfo){
        userIDs.push(user.userID);
    }
    CommonAjax.post('/user/getUsers', {userIDs: userIDs}, function (rstData) {
        for(let userInfo of rstData){
            for(let user of selected.data.shareInfo){
                if(user.userID === userInfo._id){
                    user.exist = true;
                    user.name = userInfo.real_name;
                    user.company = userInfo.company;
                    user.mobile = userInfo.mobile;
                    user.email = userInfo.email;
                }
            }
        }
        let infoArr = [];
        //居中style="width: 90px;text-align: center"
        let theadHtml = `<tr>
                            <th style="width: 112px;">姓名</th>
                            <th style="width: 165px;">公司</th>
                            <th style="width: 136px;">手机</th>
                            <th style="width: 136px;">邮箱</th>
                            <th style="width: 90px;">允许拷贝</th>
                            <th style="width: 90px;">允许编辑</th>
                            <th style="width: 90px;">取消分享</th>
                        </tr>`;
        infoArr.push(theadHtml);
        for(let user of selected.data.shareInfo){
            if (!user.exist) {
                continue;
            }
            let infoHtml = `<tr>
                                <td style="width: 112px;">${user.name}</td>
                                <td style="width: 165px;">${user.company}</td>
                                <td style="width: 136px;">${user.mobile}</td>
                                <td style="width: 160px;">${user.email}</td>
                                <td style="width: 90px;"><input value="allowCopy" ${user.allowCopy ? 'checked' : ''} type="checkbox"></td>
                                <td style="width: 90px;"><input value="allowCooperate" ${user.allowCooperate ? 'checked' : ''} type="checkbox"></td>
                                <td style="width: 90px;"><input value="cancelShare" type="checkbox"></td>
                            </tr>`;
            infoArr.push(infoHtml);
        }
        let tbodyTotalHeight = infoArr.length * perHeight + 5 > 200 ? 200 : infoArr.length * perHeight + 5;
        $('#shareToInfo').height(tbodyTotalHeight);
        let infoHtml = infoArr.join('');
        $('#shareToInfo').html(infoHtml);
        bindCancelShareCheck(selected);
        $.bootstrapLoading.end();
    });
}
//取消分享的勾选操作
//@param {Object}selected(选中项目节点) @return {void}
function bindCancelShareCheck(selected) {
    $('#shareToInfo input[value="cancelShare"]').unbind('click');
    $('#shareToInfo input[value="cancelShare"]').click(function () {
        let index = $(this).parent().parent().index() - 1,
            $coo = $(this).parent().prev().children(),
            $copy = $(this).parent().prev().prev().children();
        let isCancel = $(this).prop('checked');
        if (isCancel) {//取消分享，取消拷贝、协作勾选
            $coo.prop('checked', false);
            $copy.prop('checked', false);
        } else {//取消取消分享，恢复原本的拷贝、协作勾选状态
            let shareData = selected.data.shareInfo[index];
            if (shareData) {
                $coo.prop('checked', shareData.allowCooperate);
                $copy.prop('checked', shareData.allowCopy);
            }
        }
    });
}
//更新项目分享信息
//@param {Object}selected
function updateShareInfo(selected){
    if(!selected){
        return;
    }
    let usersTr = $('#shareToInfo').find('tr');
    if (usersTr && usersTr.length > 0) {
        usersTr = usersTr.slice(1);
    }
    let newShareInfo = [],
        orgShareInfo = [];
    const postData = [];
    //数据不同才提交
    for (let shareData of selected.data.shareInfo) {
        orgShareInfo.push({userID: shareData.userID, allowCopy: shareData.allowCopy, allowCooperate: shareData.allowCooperate})
    }
    for(let i = 0; i < usersTr.length; i++){
        let userTr = usersTr[i];
        let allowCopy = $(userTr).find('input:eq(0)').prop('checked');
        let allowCoop = $(userTr).find('input:eq(1)').prop('checked');
        let cancelShare = $(userTr).find('input:eq(2)').prop('checked');
        selected.data.shareInfo[i].allowCopy = allowCopy;
        selected.data.shareInfo[i].allowCooperate = allowCoop;
        let shareItem;
        if(cancelShare){
            shareItem = {userID: selected.data.shareInfo[i].userID, isCancel: true};
        } else {
            shareItem = {userID: selected.data.shareInfo[i].userID, allowCopy: allowCopy, allowCooperate: allowCoop};
            newShareInfo.push(shareItem);
        }
        postData.push(shareItem);
    }
    if (_.isEqual(newShareInfo, orgShareInfo)) {
        return;
    }
    CommonAjax.post('/pm/api/share', {user_id: userID, type: 'update', projectID: selected.data.ID, shareData: postData}, function (shareData) {
        selected.data.shareInfo = shareData;
        let sheet = projTreeObj.workBook.getSheet(0);
        projTreeObj.renderSheetFuc(sheet, function () {
            sheet.invalidateLayout();
            sheet.repaint();
        });
    });
}

//刷新建设项目汇总金额信息
function refreshProjSummary(project, summaryInfo) {
    let refreshNodes = [];
    refreshNodes.push(project);
    getNodes(project);
    function getNodes(node) {
        if(node.children.length > 0){
            refreshNodes = refreshNodes.concat(node.children);
            for(let cNode of node.children){
                getNodes(cNode);
            }
        }
    }
    for(let node of refreshNodes){
        let nodeInfo = summaryInfo[node.data.ID];
        if(nodeInfo){
            node.data.engineeringCost = nodeInfo.engineeringCost;
            node.data.subEngineering = nodeInfo.subEngineering;
            node.data.measure = nodeInfo.measure;
            node.data.safetyConstruction = nodeInfo.safetyConstruction;
            node.data.other = nodeInfo.other;
            node.data.charge = nodeInfo.charge;
            node.data.tax = nodeInfo.tax;
            node.data.rate = nodeInfo.rate;
            node.data.buildingArea = nodeInfo.buildingArea;
            node.data.perCost = nodeInfo.perCost;
            node.data.changeMark = nodeInfo.changeMark;
            if(nodeInfo.property) node.data.property = nodeInfo.property;
        }
    }
    projTreeObj.refreshNodeData(refreshNodes);
}



$(function () {
    if(isShow)  $('#welcomePage').modal('show');//是否显示欢迎页
    $('#importChongqing').click(async function () {
        if (STATE.importing) {
            return;
        }
        STATE.importing = true;
        $('#welcomePage').modal('hide');
        try {
            let key = uuid.v1();
            $.bootstrapLoading.progressStart("欢迎使用大司空云计价",true);
            $("#progress_modal_body").text("正在导入测评项目，请稍候……");
            let result = await ajaxPost("/pm/api/importChongqingProject",{user_id: userID,key:key});
            importProcessChecking(key, null, (projectData) => handleProjectAfterChecking(projectData));
        }catch (error){
            alert(error);
        }finally {
            STATE.importing = false;
        }
    })
});

// 导入检查完成时，对新增建设项目的处理
function handleProjectAfterChecking(projectData) {
    if (!projectData) {
        return;
    }
    const rootData = projectData.find(item => item.projType === projectType.project);
    const sorted = commonUtil.getSortedTreeData(rootData.ParentID, projectData);
    importView.doAfterImport(sorted);
}
// 导入检查完成时，对新增单位工程的处理
function handleTenderAfterChecking(projectData, orgTender) {
    if (!projectData) {
        return;
    }
    const tenderData = {...orgTender, ...projectData[0]};
    const parent = projTreeObj.tree.findNode(tenderData.ParentID);
    const next = projTreeObj.tree.findNode(tenderData.NextSiblingID);
    const newNode = projTreeObj.insert(tenderData, parent, next);
    const refreshNodes = projTreeObj.calEngineeringCost(newNode);
    projTreeObj.refreshNodeData(refreshNodes);
}

async function importProcessChecking(key, processingFunc = null, completeFunc = null, immediately = false) {
    let count = 0;
    immediately ? checking() : setTimeout(checking, 2000);
    async function checking() {
        let result = await ajaxPost("/pm/api/importProcessChecking", { key: key, user_id: userID });
        if (result.error == 1) {
            let message = result.msg ? result.msg : result.message;
            setTimeout(function () {
                $.bootstrapLoading.progressEnd();//不做这个的话太快，页面不会自动关闭
            }, 500);
            alert(message);
            if (completeFunc) {
                completeFunc(result.data);
            }
        } else if (result.error == 0) {
            if (result.status == "processing") {
                // 只调用一次
                if (processingFunc && count === 0) {
                    processingFunc(result);
                }
                count++;
                setTimeout(checking, 2000);
            } else if (result.status == "complete") {
                if (completeFunc) {
                    completeFunc(result.data);
                }
                $.bootstrapLoading.progressEnd();
                //refreshAllPage();
            }
        }
    }
}