YangHuCost/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 projectType = {
    folder: 'Folder',
    tender: 'Tender',
    project: 'Project',
    engineering: 'Engineering'
};
let fileType = {
    unitPriceFile: 'UnitPriceFile',
    feeRateFile: 'FeeRateFile'
};

let taxTypeMap = {
    1:"一般计税",
    2:"简易计税"
};

/*
* 地区，同一费用定额下不同地区有不同单价，则新建单位工程时需要选择地区项
* 地区项为空的时候，前端不显示该下拉项，地区的赋值覆盖在over_write相关文件中
* */
let regions = [];

function isDef(v) {
    return typeof v !== 'undefined' && v !== null;
}

//操作状态
const STATE = {
    addingTender: 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: 'totalCost', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0'},
            {name: '项目类别', dataCode: 'valuationType', 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'}
        ],
        //选中行颜色
        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;
            default:
                return true;
        }
    },
    refreshAddMenuItems: function () {
        const items = [{
            el: $('#addFolderSub'),
            action: projectType.folder,
        }, {
            el: $('#addProjectSub'),
            action: projectType.project,
        }, {
            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');
            },
        },
        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')[0].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');
            }
        },
        saveAs: {
            name: "另存为",
            icon: 'fa-paste',
            disabled: function () {
                const node = projTreeObj.tree.selected;
                return !(node && node.data.projType === projectType.tender);
            },
            callback: function (key, opt) {
                $('#save-as-dialog').modal('show');
            }
        },
        share: {
            name: "分享",
            icon: 'fa-share',
            disabled: function () {
                let selectedItem = projTreeObj.tree.selected;
                return !selectedItem;
            },
            callback: function (key, opt) {
                const selected = projTreeObj.tree.selected;
                if (selected && selected.data.ID) {
                    SHARE_TO.initModal(selected.data.ID);
                }
            }
        },
        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);
            },
            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;
            },
            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,
                "addTender": me.contextMenuItems.addTender,
                "spr1": '--------',
                "rename": me.contextMenuItems.rename,
                "delete": me.contextMenuItems.delete,
                "copyTo": me.contextMenuItems.copyTo,
                "saveAs": me.contextMenuItems.saveAs,
                "spr2": '--------',
                "share": me.contextMenuItems.share,
                "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) {
        $.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.project;
            }
            canCopy == true?$("#copy-to-confirm").removeClass("disabled"):$("#copy-to-confirm").addClass("disabled");
            return;//如果是复制到表，不用做后面的操作
        }else if(sheet.name() == "replaceSheet"){//如果是替换文件，不用做后面的操作
            return;
        }
        me.tree.selected = 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;//记录原来的建设项目
            if(targetNode.data.projType==projectType.tender||targetNode.data.projType==projectType.project){//只能移动到这两个地方
                if(targetNode.data.projType==projectType.tender){//移动到单位工程后面
                    [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true);
                    rootProjectID = targetNode.pid();
                }else{//移动后成为建设项目的子项
                    [parent,next] =getMoveUpdateData(selected,targetNode,projectMap,false);
                    rootProjectID = targetNode.id();
                }
                if(selected.data.property.rootProjectID != rootProjectID){//如果不属于同一个建设项目，要检查是否移动或复制单价文件和费率文件
                    projectMap[selected.id()].update['property.rootProjectID'] = rootProjectID; //要改变根项目ID
                    //检查费率文件和单价文件
                    moveOrCopy(selected,rootProjectID,feeRateMap,unitPriceMap,false);
                }
            }
        }
        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;//取建设项目
            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 = 18; // 单元格默认高度
        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 == undefined) style.backColor = "white"
            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;
            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);
          /*  if (node.data.shareInfo && node.data.shareInfo.length > 0) {//分享标记在文本后
                let nowX = Math.floor(x) + w - 20;
                let nowY = Math.floor((y + (y + h)) / 2);
                ctx.drawImage(shareImg, nowX + 3, nowY - 7, shareImgWidth,shareImgHeight);
            }*/
        };
        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;
            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 textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport});
            //(图标+名字)区域
            function withingClickArea(){
                return hitinfo.x > centerX + halfBoxLength && hitinfo.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength;
            }
            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.processMouseMove = function (hitInfo) {
            let sheet = hitInfo.sheet;

            let div = sheet.getParent().getHost();
            let canvasId = div.id + "vp_vp";
            let canvas = $(`#${canvasId}`)[0];
            //改变鼠标图案
            if (sheet && hitInfo.isReservedLocation) {
                canvas.style.cursor='pointer';
                return true;
            }else{
                canvas.style.cursor='default';
            }
            return false;
        };*/
        TreeNodeCellType.prototype.processMouseEnter = function (hitinfo) {
            let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
            let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col);
            let tag = hitinfo.sheet.getTag(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) {
            let me = this;
            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();
    },
    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);
        }
    },
    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);
    },
    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.tender){
            projectNode = node.parent;
        }
        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.totalCost,2);
                tem_sum = scMathUtil.roundForObj(temP+tem_sum,2);
            }
            node.data.totalCost =  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);
    },
    checkFileName:async function (fileID,name,type) {
        let node = this.tree.selected;
    },

    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.expanded){
                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;
    },
    getUploadToken:async function () {
        let result =await ajaxGet("/pm/api/getUploadToken");
        $("#confirm-import").show();
        projTreeObj.uptoken=result.uptoken;
    }

};

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

    });

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

    // 侧滑数据
   /* $(".poj-list").on('click', ".open-sidebar", function() {
        setDataToSideBar();
        $(".slide-sidebar").animate({width:"800"}).addClass("open");
    });*/

    //单价、费率文件删除确认
    $('#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'), $('#folder-name'), $('#rename-name'));
    //绑定新建窗口显示事件
    bindModalShown($('#add-folder-dialog'), $('#add-project-dialog'), $('#add-tender-dialog'));
    //绑定新建建设项目、新建文件夹、重命名弹窗隐藏事件
    bindModalsHidden($('#add-project-dialog'), $('#add-folder-dialog'), $('#rename-dialog'));

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

    // 新增建设项目操作
    $('#addProjOk').click(function () {
        if (STATE.addingProject) {
            return;
        }
        STATE.addingProject = true;
        let suc = AddProject();
        if (suc === false) {
            STATE.addingProject = false;
        }
    });

    // 选择计价方式
    $("input[name='valuation_type']").click(function() {
        let type = $(this).val();
        let targetData = type === 'bill' ? JSON.parse(billValuation) : JSON.parse(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);
        //$("#tender-engineering").html('<option value="">请选择对应的工程专业</option>');
        let engineeringList = getEngineeringList();
        let engineeringHtml = getEngineeringHtml(engineeringList);
        $("#tender-engineering").html(engineeringHtml);
        changeEngineering();
        $('#engineering-info').hide();
    });

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

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

    //新建单位工程-建设项目提示
    $('#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 !== ''){
                replaceClass($('#poj-name-info'), 'text-danger', 'text-info');
                setDangerInfo($('#poj-name-info'), `新建“${pojName}”`);
            }
            else {
                $('#poj-name-info').hide();
            }
            //清空文件下拉
            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();
        }
    });


    //新建单位工程-单位工程提示
    $('#tender-name').keyup(function () {
        let selected = projTreeObj.tree.selected;
        let pojName = $('#poj-name').val().trim();
        let tenderName = $('#tender-name').val().trim();
        let isExist = hasTender(selected, pojName, 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);
        }
    }
    // 某些费用定额不显示费用标准
    const compilationWithoutFeeStandard = [
        // 内蒙2019
        '5d776dad620cc0000dab6b2a'
    ];
    // 新增单位工程弹层改变
    $('#add-tender-dialog').on('show.bs.modal', function() {
        if (compilationWithoutFeeStandard.includes(compilationData._id)) {
            $('#tender-feeStandard-group').hide();
        }
        //clear info
        $('#poj-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('新建费率文件');
        //获取建设项目
        let selected = projTreeObj.tree.selected;
        let projs = getProjs(selected);
        setProjOptions(projs, selected);
        //恢复成默认选中预算项目类别。
        $($("input[name='valuation_type']")[0]).prop('checked', true);
        $($("input[name='valuation_type']")[1]).prop('checked', false);
        $($("input[name='valuation_type']")[0]).click();
        //设置地区选项
        if(regions.length > 0){
            setRegionOpts(regions);
            $('#regionDiv').show();
        }
    });

    // 新增单位工程
    $("#add-tender-confirm").click(function() {
        if (STATE.addingTender) {
            return;
        }
        STATE.addingTender = true;
        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) {
            $.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-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;
        }
        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 parent = null, next = null, projectMap = {};
            if (toNode.data.projType == projectType.project) {//复制为目标的子节点
                parent = toNode;
                next = toNode.firstChild();
            } else if (toNode.data.projType == projectType.tender) {//复制为目标的后兄弟
                parent = toNode.parent;
                next = toNode.nextSibling;
                projectMap['update'] = { query: { ID: toNode.id() } };//前一节点的下一个节点更新;
            }
            let nextID = next ? next.id() : -1;
            let projectData = _.cloneDeep(originalNode.data);
            projectData['ParentID'] = parent.id();
            projectData['NextSiblingID'] = nextID;
            projectData['property'] = {};
            projectData['property']['rootProjectID'] = parent.id();
            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);
        }
    });

    // 另存为操作
    $('#save-as-dialog').on('show.bs.modal', function () {
        const selected = projTreeObj.tree.selected;
        const name = selected.data.name;
        $('#save-file').prop('checked', true);
        $('#save-as-name').val(name);
        setTimeout(() => $('#save-as-name')[0].focus(), 300);
    });
    $('#save-as-confirm').click(_.throttle(async function () {
        try {
            const name = $('#save-as-name').val().trim();
            if (!name) {
                throw new Error('名称不可为空。');
            }
            const saveAsFile = $('#save-file').prop('checked');
            const originalNode = projTreeObj.tree.selected;
            const projectMap = {
                isSaveAs: true,
                saveAsFile,
            };
            const parent = originalNode.parent;
            const next = parent.firstChild();
            const nextID = next ? next.id() : -1;
            const projectData = _.cloneDeep(originalNode.data);
            projectData['ParentID'] = parent.id();
            projectData['NextSiblingID'] = nextID;
            projectData['property'] = {};
            projectData['property']['rootProjectID'] = parent.id();
            projectData['shareInfo'] = [];
            projectData['name'] = name;
            projectMap['copy'] = { document: projectData };
            //$("#save-as-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);
                if (newProjectData) {
                    $('#save-as-dialog').modal('hide');
                }
            });
        } catch (err) {
            alert(err);
        }
    }, 2000));

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

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

    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 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();
            }
        }
        let currentEngLib = getEngineeringLib(currentEngName + $('#tender-feeStandard').val(), engineeringList);
        changeFeeRate(currentEngLib);
        setTaxGroupHtml();
        getStdCalcProgramFiles();
    }

    function changeFeeStandard() {
        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 = $("#taxType").val();
        let stdCPHtml = getStdCPFilesHtml(getTaxGroupList(taxType));
        $("#tender-calcProgram").html(stdCPHtml);
        if ($("#tender-calcProgram")[0].options.length > 1)
            $("#tender-calcProgram")[0].selectedIndex = 0;
    }

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

//获取工作表总宽度
function getWorkBookWidth(){
    return workBookWidth = $(window).width() - $('.pm-side').width() - 90;
}

function prepareInitialTimer() {
    $('#progressBar').css('width', `0%`);
    let outer = setInterval(function () {
        let curWidth = parseInt($('#progressBar')[0].style.width.replace('%', ''));
        curWidth = parseInt(curWidth + 2);
        $('#progressBar').css('width', `${curWidth}%`);
        if (curWidth >= 80) {
            clearInterval(outer);
        }
    }, 100);
    let inner = setInterval(function () {
        let curWidth = parseFloat($('#progressBar')[0].style.width.replace('%', ''));
        if (curWidth >= 80) {
            curWidth = parseFloat(curWidth + 0.1);
            $('#progressBar').css('width', `${curWidth}%`);
            if (curWidth >= 95) {
                clearInterval(inner);
            }
        }
    }, 500);
    return {outer, inner};
}

// 初始化节点可见性，默认收起至建设项目层
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.property.valuationType) {
                data.valuationType = data.property.valuationType === 'bill' ? '预算' : '工程量清单';
            }
        }
        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 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();
        });
    });
}

/**
 * 初始化数据
 * @return {void} */
async function init(refresh = false) {//refresh是刷新页面时才使用的
    try {
        billValuation = billValuation.replace(/\n/g, '\\n');
        rationValuation = rationValuation.replace(/\n/g, '\\n');
        //init spread and pmTree
        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 (err) {
        alert(err);
    }
}

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


/**
 * 新增建设项目
 *
 * @return {boolean}
 */
function AddProject() {
    let name = $('#project-name').val().trim();
    if (name === '') {
        setDangerInfo($('#project-name-info'), '请填写建设项目名称');
        return false;
    }
    $.bootstrapLoading.start();
    let existCallback = function () {
        setDangerInfo($('#project-name-info'), `已存在“${$("#project-name").val()}”`);
        STATE.addingProject = false;
        $.bootstrapLoading.end();
    };
    let sucCallback = function () {
        $('#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）、当前定位在单项工程或单位工程，新建项目为当前所属建设项目的后兄弟。
     * */
    if(!selectedItem){
        AddSiblingsItem(selectedItem, name, null, projectType.project, existCallback, sucCallback, errCB);
    }
    else {
        if(selectedItem.data.projType === projectType.project){
            AddSiblingsItem(selectedItem, name, null, projectType.project, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.tender){
            let proj = selectedItem.parent;
            AddSiblingsItem(proj, name, null, projectType.project, existCallback, sucCallback, errCB);
        }
        else if(selectedItem.data.projType === projectType.folder){
            AddChildrenItem(selectedItem, name, null, projectType.project, existCallback, sucCallback, errCB);
        }
    }
}

function bindModalShown(folderDialog, projDialog, tenderDialog) {
    folderDialog.on('shown.bs.modal', function () {
        $('#folder-name').focus();
    });
    projDialog.on('shown.bs.modal', function () {
        $('#project-name').focus();
    });
    tenderDialog.on('shown.bs.modal', function () {
        $('#tender-name').focus();
    });
}

//新建建设项目、新建单项工程、新建文件夹、重命名弹窗隐藏事件
function bindModalsHidden(projDialog, folderDialog, renameDialog){
    projDialog.on('hidden.bs.modal', function () {
        setDangerInfo($('#project-name-info'), '', false);
        $('#project-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, foldInput, renameInput){
    projInput.bind('keypress', function (event) {
        if(event.keyCode === 13){
            $('#addProjOk').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;
        }
    });
}
//新建建设项目、单项工程、文件夹、重命名提示(文本改变，暂时不需要)
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.totalCost = 0;
}

function AddTenderItems(selected, projName, tenderName, property, callback, errCB){
    const addPath = {p_t: 'p_t', t: 't'};
    let path, updateDatas = [];
    let tempProjs = getProjs(selected);
    let tempProj = getNodeByName(projName, tempProjs);
    if(tempProj){
        path = addPath.t;
    } else {
        path = addPath.p_t;
    }
    if(path === addPath.p_t){
        let parent, pre, next;
        GetNewProjectId(2, function (IDs) {
            let projID = IDs.lowID,
                tenderID = IDs.lowID + 1;
            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.tender){
                let selectedProj = selected.parent;
                parent = selectedProj ? selectedProj.parent : projTreeObj.tree._root;
                pre = selectedProj;
                next = selectedProj ? selectedProj.nextSibling : projTreeObj.tree.firstNode();
            }
            let updateProjs = GetUpdateData(pre, parent, next, projName, null, projID, {updateType: 'new', projectType: projectType.project});
            property.rootProjectID = projID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: projID, NextSiblingID: -1,
                name: tenderName, projType: projectType.tender, property: property}};
            updateDatas = updateDatas.concat(updateProjs);
            updateDatas.push(updateTender);
            UpdateProjectData(updateDatas, function(datas){
                let projData,
                    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.tender){
                            tenderData = data.updateData;
                            tenderData.feeStandardName = tenderData.property.feeStandardName || '';
                            tenderData.valuationType = tenderData.property.valuationType === 'bill' ? '预算' : '工程量清单';
                        }
                    }
                });
                let pojNode = projTreeObj.insert(projData, parent, next);
                let tenderNode = projTreeObj.insert(tenderData, pojNode, null);
                const rows = [pojNode.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 = tempProj.lastChild();
            property.rootProjectID = tempProj.data.ID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: tempProj.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 || '';
                        data.updateData.valuationType = data.updateData.property.valuationType === 'bill' ? '预算' : '工程量清单';
                        const tenderNode = projTreeObj.insert(data.updateData, tempProj, 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);
                        const 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)){
        //alert('同级目录已存在相同名称数据.');
        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 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 = $("#valuation").val();
    let valuationType = $("input[name='valuation_type']:checked").val();
    let valuationData = valuationType === 'bill' ? JSON.parse(billValuation) : JSON.parse(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;
        }
    }
    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 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.tender){
        let proj = selected.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];
        $("#poj-name").val(firstProj.data.name);
        setFileOptions(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 () {
                $("#poj-name").val(projs[i].data.name);
                setFileOptions(projs[i].data.ID);
                $('#poj-name-info').hide();
            });
            $("#poj-name-list").append($proj);
        }
    }
    else {
        setFileOptions(null);
    }
}

function hasTender(selected, pojName, tenderName){
    let isExist = false;
    let tempProjs = getProjs(selected);
    if(pojName !== ''){
        let tempProj = getNodeByName(pojName, tempProjs);
        if(tempProj){
            let tempTender = getNodeByName(tenderName, tempProj.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){
    area.text(info);
    if(show)
        area.show();
    else
        area.hide();
}

/**
 * 新增分段
 *
 * @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;
        }

        let tenderName = $('#tender-name').val();
        if (tenderName === '') {
            setDangerInfo($('#tender-name-info'), '请填写单位工程名称');
            return false;
        }

        if(hasTender(projTreeObj.tree.selected, projName, 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();
        /*
        * 计价规则只是隐藏显示了，工程专业id还是要通过养护类别、费用标准确定，因为后台结构没有变化
        * */
        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();
        /*if(!taxType || taxType ===""){
            return false;
        }*/

        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 = $("#valuation").children("option:selected").text();
        let valuationType = $("input[name='valuation_type']:checked").val();

        let engineering = undefined;
        let valuationData = valuationType === 'bill' ? JSON.parse(billValuation) : JSON.parse(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 = "",
            progressiveLibID = "";
        if(libs.feature_lib && libs.feature_lib.length > 0) {
            featureLibID = libs.feature_lib[0].id;
        }
        if(libs.progressive_lib && libs.progressive_lib.length > 0) {
            progressiveLibID = libs.progressive_lib[0].id;
        }


        let calcProgramName = $('#tender-calcProgram').children("option:selected").text();
        //let newTab = window.open('about:blank');
        $.bootstrapLoading.start();
        let callback = function(tenderNode) {
            $("#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();
            $.bootstrapLoading.end();
            setTimeout(function () {
                STATE.addingTender = false;
            }, 500);
        };
        let errCB = function () {
            $.bootstrapLoading.end();
            setTimeout(function () {
                STATE.addingTender = false;
            }, 500);
        };
        let selectedItem = projTreeObj.tree.selected;
        //地区
        let region = $('#regionDiv').find('select').val() || '全省';
        let tenderInfo = {
            valuation: valuation,
            valuationType: valuationType,
            valuationName: valuationName,
            isInstall: libs.isInstall !== undefined ? libs.isInstall : false,
            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:taxType,
            templateLibID:templateLibID,
            colLibID:colLibID,
            featureLibID:featureLibID,
            progressiveLibID:progressiveLibID,
            region: region
        };
        AddTenderItems(selectedItem, projName, tenderName, tenderInfo, callback, errCB);

    } catch (error) {
        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;
    $.bootstrapLoading.start();
    let existCallback = function () {
        setDangerInfo($('#folder-name-info'), `已存在“${$("#folder-name").val()}”`);
        STATE.addingFolder = false;
        $.bootstrapLoading.end();
    };
    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.tender){
            let proj = selectedItem.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){
    if(selectedItem.data.projType === projectType.tender){
        selectedItem = selectedItem.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 engineeringObject = {};
    for(let tmp of engineering) {
        engineeringObject[tmp.value] = tmp.name;
    }
    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 : [];
        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
    }
    return proj.children;
}
//单价、费率文件汇总信息的使用次数、使用该文件的单位工程
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 unitPriceEditHtml = type === fileType.unitPriceFile? `<a class="btn btn-sm" href="/unitPrice/index/${fileId}" target="_">编辑</a>`:"";
        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>${unitPriceEditHtml}</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 class="text-center">' + 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);
       }
   });
}

//批量替换文件，切换建设项目
$('#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);
    }
});

$("#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) {
        let config = {
            useCdnDomain: true,
            disableStatisticsReport: false,
            retryCount: 6,
            region: qiniu.region.z2
        };
        let putExtra = {
            fname: "",
            params: {"x:name":key.split(".")[0]},
            mimeType: null
        };
        // 添加上传dom面板
        let observable = qiniu.upload(file, key, token, putExtra, config);
         observable.subscribe({
             next:function (reponse) {
                 console.log(reponse);
             },
             error:function (err) {
                 console.log(err);
             },
             complete:function(res){
                 console.log("complete")
                 $("#progress_modal_body").text("正在导入建设项目");
                 startImportProject(key);
                 projTreeObj.uptoken = null;
             }
         });
    }
});

async function startImportProject(key) {
    try {
        console.log("start Import");
        let result = await ajaxPost("/pm/api/importProject", { key: key, updateData: projTreeObj.getImportProjectDate() });
        importProcessChecking(key, null, (projectData) => handleProjectAfterChecking(projectData));
    } catch (error) {
        alert(error);
        $.bootstrapLoading.end();
    } 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);
    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();
            }
        }
    }
}

$("#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(`请选择建设项目文件`);
});

//刷新建设项目汇总金额信息
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.totalCost = nodeInfo.totalCost;
            node.data.changeMark = nodeInfo.changeMark;
            if(nodeInfo.property) node.data.property = nodeInfo.property;
        }
    }
    projTreeObj.refreshNodeData(refreshNodes);
}

//projectDatas在后端已经按照顺序排过了： project eng1 tender1-1 tender1-2 eng2 tender2-1 tender2-2
function doAfterImport(projectDatas) {
    //插入节点
    let lastNode;
    for (let data of projectDatas) {
        data.feeStandardName = data.property && data.property.feeStandardName || ''; //工程专业列显示用
        let parent = projTreeObj.tree.items.find(node => node.data.ID === data.ParentID),
            next = projTreeObj.tree.items.find(node => node.data.ID === data.NextSiblingID);
        lastNode = projTreeObj.insert(data, parent, next);
    }
    if (lastNode) {
        projTreeObj.workBook.getSheet(0).showRow(lastNode.serialNo(), GC.Spread.Sheets.VerticalPosition.center);
    }
}

$(function () {
   if(isShow)  $('#welcomePage').modal('show');//是否显示欢迎页
});