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

/**
 * 项目管理相关js
 *
 * @author CaiAoLin
 * @date 2017/8/22
 * @version
 */
let Tree = null;//
let movetoZTree = null;
let copytoZTree = null;
let engineering = [];
let feeRateData = [];
let isSaving = false;
let projectProperty = [];
let fileDelObj = null;
let projectType = {
    folder: 'Folder',
    tender: 'Tender',
    project: 'Project',
    engineering: 'Engineering'
};
let fileType = {
    unitPriceFile: 'UnitPriceFile',
    feeRateFile: 'FeeRateFile'
};

const projTreeObj = {
    tree: null,
    workBook: null,
    copyToWorkBook:null,
    copySelected:null,
    preSelection: null,
    setting: {
        tree: {
            id: 'ID',
            pid: 'ParentID',
            nid: 'NextSiblingID',
            rootId: -1,
            autoUpdate: false
        },
        header: [
            {name: '工程列表', dataCode: 'name', width: 800, vAlign: 'center', hAlign: 'left'},
            {name: '工程造价', dataCode: 'engineeringCost', width: 170, vAlign: 'center', hAlign: 'right'},
            {name: '单价文件', dataCode: 'unitPriceFile', width: 250, vAlign: 'center', hAlign: 'left'},
            {name: '费率文件', dataCode: 'feeRateFile', width: 250, vAlign: 'center', hAlign: 'left'},
            {name: '创建日期', dataCode: 'createDateTime', width: 170, vAlign: 'center', hAlign: 'left'}
        ],
        //选中行颜色
        style: {
            defalutBackColor: 'White',
            selectedColor: '#BBFFFF'
        },
        options: {
            tabStripVisible:  false,
            allowCopyPasteExcelStyle : false,
            allowExtendPasteRange: false,
            allowUserDragDrop : true,
            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
        }},
    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);
    },
    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);
            for(let i = 0, len = headers.length; i < len; i++){
                sheet.setValue(0, i, headers[i].name, GC.Spread.Sheets.SheetArea.colHeader);
                sheet.setColumnWidth(i, headers[i].width, GC.Spread.Sheets.SheetArea.colHeader);
            }
        };
        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);
        }
        return newWorkBook;
    },
    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);
        me.renderSheetFuc(sheet, function () {
            let style = me.getSelStyle(backColor);
            /*sel.row = sel.row === -1 ? 0 : sel.row;*/
            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];
        //恢复底色
        if(oldSel){
            me.setSelStyle(oldSel, me.setting.style.defalutBackColor,sheet);
        }
        //设置选中行底色
        if(newSel){
            me.setSelStyle(newSel, me.setting.style.selectedColor,sheet);
        }
        if(sheet.name()=="copyToSheet"){ //复制到
            me.copySelected = node;
            let canCopy = false;
            if(node){
                canCopy = node.data.projType == projectType.tender|| node.data.projType == projectType.engineering;
            }
            canCopy == true?$("#copy-to-confirm").removeClass("disabled"):$("#copy-to-confirm").addClass("disabled");
            return;//如果是复制到表，不用做后面的操作
        }
        me.tree.selected = node;
        me.preSelection = newSel;
        console.log("set main tree selected");
        console.log(me.tree.selected);
        $(".tools-btn > a").not(".disabled").addClass("disabled");
        $("#add-engineering-btn").addClass("disabled");
        $('#add-tender-btn').removeClass('disabled');
        if(node){
            switch(node.data.projType) {
                case projectType.project:
                    $("#del-btn").removeClass("disabled");
                    $("#add-engineering-btn").removeClass("disabled");
                    break;
                case projectType.folder:
                    if(!node.children || node.children.length === 0){
                        $("#del-btn").removeClass("disabled");
                    }
                    break;
                case projectType.engineering:
                    $("#del-btn").removeClass("disabled");
                    $("#add-engineering-btn").removeClass("disabled");
                    break;
                case projectType.tender:
                    $("#add-engineering-btn").removeClass("disabled");
                    $("#move-to-btn").removeClass("disabled");
                    $("#copy-to-btn").removeClass("disabled");
                    $("#share-btn").removeClass("disabled");
                    $("#cooperate-btn").removeClass("disabled");
                    $("#del-btn").removeClass("disabled");
                    break;
            }
            $("#rename-btn").removeClass("disabled");
        }
    },
    onSelectionChanging: function (sender, args) {
        let me = projTreeObj;
        me.initSelection(args.newSelections[0], args.oldSelections[0],args.sheet);
    },
    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){
            return;
        }

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

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


    },
    projectNameChecking:function (parent,node) {
        //decDate = '（' + new Date().Format('MM-dd hh:mm:ss') + '恢复）';
        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') + '移动）';
           }
        }
        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') : '';
            }
        }
    },
    getTreeNodeCell: function (tree) {
        let indent = 20;
        let levelIndent = -5;
        let halfBoxLength = 5;
        let halfExpandLength = 3;
        let imgWidth = 18;
        let imgHeight = 14;
        let TreeNodeCellType = function () {
        };
        TreeNodeCellType.prototype = new GC.Spread.Sheets.CellTypes.Text();
        TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
            if (style.backColor) {
                ctx.save();
                ctx.fillStyle = style.backColor;
                ctx.fillRect(x, y, w, h);
                ctx.restore();
            } else {
                ctx.clearRect(x, y, w, h);
            }
            let drawLine = function (canvas, x1, y1, x2, y2, color) {
                ctx.save();
                ctx.translate(0.5, 0.5);
                ctx.beginPath();
                ctx.moveTo(x1, y1);
                ctx.lineTo(x2, y2);
                ctx.strokeStyle = color;
                ctx.stroke();
                ctx.restore();
            };
            let drawExpandBox = function (ctx, x, y, w, h, centerX, centerY, expanded) {
                let rect = {}, h1, h2, offset = 1;
                rect.top = centerY - halfBoxLength;
                rect.bottom = centerY + halfBoxLength;
                rect.left = centerX - halfBoxLength;
                rect.right = centerX + halfBoxLength;

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

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

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

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

            let centerX = Math.floor(x) + node.depth() * indent + node.depth() * levelIndent + indent / 2;
            let x1 = centerX + indent / 2;
            let centerY = Math.floor((y + (y + h)) / 2);
            let y1;
            // Draw Sibling Line
            if (showTreeLine) {
                // Draw Horizontal Line
                if (centerX < x + w) {
                    drawLine(ctx, centerX, centerY, Math.min(x1, x + w), centerY, 'gray');
                    let img;
                    if(node.data.projType === projectType.folder){
                        img = document.getElementById('folder_open_pic');
                        imgWidth = 15;
                    }
                    else if(node.data.projType === projectType.project){
                        img = document.getElementById('proj_pic');
                        imgWidth = 18;
                    }
                    else if(node.data.projType === projectType.engineering){
                        img = document.getElementById('eng_pic');
                        imgWidth = 14;
                    }
                    else if(node.data.projType === projectType.tender){
                        img = 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);
                }
            };
            // Draw Text
            //x = x + (node.depth() + 1) * indent +  node.depth() * levelIndent;
            x = x + (node.depth() + 1) * indent +  node.depth() * levelIndent + imgWidth + 3;
            GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
        };
        TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
            return {
                x: x,
                y: y,
                row: context.row,
                col: context.col,
                cellStyle: cellStyle,
                cellRect: cellRect,
                sheetArea: context.sheetArea,
                isReservedLocation: true
            };
        };
        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() != "copyToSheet"){//如果是复制到sheet，不用执行
                //建设项目，侧滑汇总
                if(node.data.projType === projectType.project && withingClickArea()){
                    setDataToSideBar();
                    $(".slide-sidebar").animate({width:"800"}).addClass("open");
                    $('body').unbind('click');
                    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;
                                    }
                                    elem = elem.parentNode;
                                }
                                $(".slide-sidebar").animate({width: "0"}).removeClass("open")// 关闭处理
                            }
                        });
                    }, 500);
                }
                //单项文件，进入造价书界面
                else if(node.data.projType === projectType.tender && withingClickArea()){
                    let newTab = window.open('about:blank');
                    BeforeOpenProject(node.data.ID, {'fullFolder': GetFullFolder(node.parent)}, function () {
                        let mainUrl = `/main?project=${node.data.ID}`;
                        CommonAjax.get(mainUrl, [], function () {
                            newTab.location.href = mainUrl;
                        });
                    });
                    return;
                }
                if (!node || node.children.length === 0) { return; }
            }
            if (hitinfo.x > centerX - halfBoxLength && hitinfo.x < centerX + halfBoxLength && hitinfo.y > centerY - halfBoxLength && hitinfo.y < centerY + halfBoxLength) {
                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];
            //改变鼠标图案
            let node = tree.items[hitInfo.row];
            let offset = -1;
            let centerX = hitInfo.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 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});
            if (sheet && hitInfo.x > centerX + halfBoxLength && hitInfo.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength) {
                canvas.style.cursor='pointer';
                return true;
            }else{
                canvas.style.cursor='default';
            }
            return false;
        };
        return new TreeNodeCellType();
    },
    setCellValue: function (cell, node,sheet) {
        //const sheet = this.workBook.getActiveSheet();
        const {row, col} = cell;
        let dataCode = this.setting.header[col]['dataCode'];
        let value = '';
        if(dataCode === 'engineeringCost'){
            if(node.data.projType !== projectType.folder){//显示除了文件夹节点的工程造价结果 -- vincent
                value =  node.data.engineeringCost ? node.data.engineeringCost : '0.00';
            }
        }
        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 = node.data[dataCode] ? node.data[dataCode] : '';
        }
        sheet.setValue(row, col, value);
    },
    showTreeData: function (nodes, headers,sheet) {
        let me = this;
       // let sheet = me.workBook.getActiveSheet(); 为了共用
        let fuc = function(){
            sheet.setRowCount(0);
            sheet.setRowCount(nodes.length);
            for(let i = 0; i < nodes.length; i++){
                let treeNodeCell = me.getTreeNodeCell(me.tree);
                sheet.getCell(i, 0).cellType(treeNodeCell);
                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']]);
                    me.setCellValue({row: i, col: j}, nodes[i],sheet);
                    let dataCode = headers[j].dataCode;
                    //sheet.setValue(i, j, nodes[i]['data'][dataCode]);
                }
                sheet.getCell(i, 1,GC.Spread.Sheets.SheetArea.viewport).locked(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);
            }
        }

    },
    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.project){
            projectNode = node;
        }
        if(node.data.projType == projectType.engineering){
            projectNode = node.parent;
        }
        if(node.data.projType == projectType.tender){
            projectNode = node.parent&&node.parent.parent?node.parent.parent:null;
        }
        if(projectNode){
            calNode(projectNode);
        }
        let children = projectNode.children;
        refreshNodes.push(projectNode);
        return  refreshNodes.concat(children);
        function calNode(node) {
            let tem_sum = 0;
            if(node.data.projType == projectType.tender){
                return;
            }
            for(let t of node.children){
                calNode(t);
                let temP = scMathUtil.roundForObj(t.data.engineeringCost,2);
                tem_sum = scMathUtil.roundForObj(temP+tem_sum,2);
            }
            node.data.engineeringCost =  scMathUtil.roundToString(tem_sum,2);
        }

    },
    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');
        me.showTreeData(me.tree.items, me.copyToSetting.header, sheet);
        me.copySelected = null;
        let initSel = sheet.getSelections()[0] ? sheet.getSelections()[0] : {row: 0, rowCount: 1};
        projTreeObj.initSelection(initSel,null,sheet);
    },
    insert: function (data, parent, next) {
        let node = this.tree.addNodeData(data, parent, next);
        this.addRow(node);
        let newSel = this.workBook.getSheet(0).getSelections()[0];
        this.initSelection(newSel, this.preSelection,this.workBook.getActiveSheet());
        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);
            }
            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){
        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));
        }
       // projTreeObj.remove(sheet, fromRow, rCout);

        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);
            let children = newNode.getAllChildren();
            children.push(newNode);
            for(let c of children){
                sheet.getCell(c.serialNo(), 0).cellType(me.getTreeNodeCell(me.tree));
               // me.refreshNodeData(c);
            }
            refreshNodes = refreshNodes.concat(children);
            me.refreshNodeData(refreshNodes);
        });

        function addNewNodes(node,parent,next) {
            let newNode = me.tree.addNodeData(node.data, parent, next);
            for(let c of node.children){
                addNewNodes(c,newNode,null);
            }
            return newNode;
        }

    }
};

$(document).ready(function() {
    init();
    $('#tab_pm_all').on('show.bs.tab', function () {
        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();
                //refresh front?
            });
        }
    });
    //绑定新建建设项目、新建单项工程、新建文件夹、重命名Enter键事件
    bindInputs($('#project-name'), $('#engineering-name'), $('#folder-name'), $('#rename-name'));

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

    // 新增建设项目点击
    $('#add-project-btn').click(function () {
        let selectedItem = projTreeObj.tree.selected;
        $('#add-project-dialog').modal('show');
    });

    // 新增建设项目操作
    $('#addProjOk').click(function () {
        AddProject();
    });

    // 选择计价方式
    $("input[name='valuation_type']").click(function() {
        let type = $(this).val();
        let targetData = type === 'bill' ? JSON.parse(billValuation) : JSON.parse(rationValuation);
        let html = '<option value="">请选择计价规则</option>';
        for(let valuation of targetData) {
            if (valuation === null) {
                continue;
            }
            html += '<option value="'+ valuation._id +'">'+ valuation.name +'</option>';
        }
        $("#valuation").html(html);
        $("#tender-engineering").html('<option value="">请选择对应的工程专业</option>');
    });

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

    // 新增单项项目点击
    $("#add-engineering-btn").click(function() {
        let selectedItem = projTreeObj.tree.selected;
        try {
            if(selectedItem !== null  && selectedItem.data.projType !== projectType.folder){
                $("#add-engineering-dialog").modal("show");
            }

        } catch (error) {
            alert(error);
        }
    });

    // 新增单项工程操作
    $("#add-engineering-confirm").click(function() {
        AddEngineering();
    });

    // 新增单位工程点击
    $("#add-tender-btn").click(function() {
        let selectedItem = projTreeObj.tree.selected;
        $("#add-tender-dialog").modal("show");
    });

    //新建单位工程-建设项目提示
    $('#poj-name').change(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}”`);
            }
            //清空单项工程下拉和文件下拉
            setEngOptions(null);
            setFileOptions(null);
        }
        else {
            $('#poj-name-info').hide();
        }
    });

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

    //新建单位工程-单位工程提示
    $('#tender-name').change(function () {
        let selected = projTreeObj.tree.selected;
        let pojName = $('#poj-name').val().trim();
        let engName = $('#eng-name').val().trim();
        let tenderName = $('#tender-name').val().trim();
        let isExist = hasTender(selected, pojName, engName, tenderName);
        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;
    }

    // 新增单位工程弹层改变
    $('#add-tender-dialog').on('show.bs.modal', function() {
        //clear info
        $('#poj-name-info').hide();
        $('#eng-name-info').hide();
        $('#tender-name-info').hide();
        $('#tender-name').val('');
        $('#valuation-info').hide();
        $('#engineering-info').hide();
        //获取建设项目
        let selected = projTreeObj.tree.selected;
        let projs = getProjs(selected);
        setProjOptions(projs, selected);
        $($("input[name='valuation_type']")[0]).click();
    });

    // 新增单位工程
    $("#add-tender-confirm").click(function() {
        AddTender();
    });

    // 新增文件夹按钮点击
    $("#add-folder-btn").click(function() {
        $("#add-folder-dialog").modal("show");
    });

    // 新增文件夹操作
    $("#add-folder-confirm").click(function() {
        AddFolder();
    });

    // 删除按钮点击
    $('#del-btn').click(function() {
        if (projTreeObj.tree && projTreeObj.tree.selected) {
            $('#del').modal('show');
        }
    });

    // 删除时文字替换
    $('#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 () {
        let updateData = null;
        let dialog = $('#del');
        if (projTreeObj.tree) {
            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);//刷新工程造价信息
                }
            });
        }
    });

    // 重命名按钮点击
    $('#rename-btn').click(function() {
        if (!projTreeObj.tree) {
            return false;
        }
        if (!projTreeObj.tree.selected) {
            alert('请选择需要重命名的数据');
            return false;
        }
        $('#rename-dialog').modal('show');
    });

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

        if (newName === select.data.name) {
            dialog.modal('hide');
            return false;
        }
        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();
            sheet.setValue(sheet.getActiveRowIndex(), 0, newName);
        });
    });


    // 复制到按钮点击
    $('#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 () {
        console.log('shown copy to ');
        projTreeObj.initCopyToSpread();
       // copytoZTree = ConvertTreeToZtree(projTreeObj.tree, $('#treeDemo2'), null);
    });

    // 复制到操作
    $("#copy-to-confirm").click(function() {
        let originalNode = projTreeObj.tree.selected;
        let toNode = projTreeObj.copySelected;
        let parent = null,next = null;
        if(toNode.data.projType == projectType.engineering){//复制为目标的子节点
            parent = toNode;
            next = toNode.nextSibling;
        }else if(toNode.data.projType == projectType.tender){//复制为目标的后兄弟
            
        }

/*        tem_parent = target;
        tem_next = target.firstChild();
        tem_parent = target.parent;
        tem_next = target.nextSibling;*/


        console.log(originalNode);
        console.log(toNode);
        CommonAjax.post('/pm/api/copyProjects',{ID:'test',user_id: userID},function () {
            
        })
        
     /*   let dialog = $('#copy-to-dialog');
         let target = GetTargetTreeNode($.fn.zTree.getZTreeObj('treeDemo2'));
         let parent = null;
         let next = null;
         let pre = null;
         let cur = projTreeObj.tree.selected;
         if (!target) {
         return false;
         }
         if (target.data.projType !== projectType.engineering) {
         alert("请移动到单项工程中!");
         return false;
         }
         if (target.data.projType !== projectType.tender && target.children.length !== 0 &&
         target.firstChild().data.projType !== projectType.tender) {
         dialog.modal('hide');
         }

         // 判断同级是否有同名
         if (target.children.length > 0) {
         for (let tmp in target.children) {
         if (tmp === 0) {
         continue;
         }
         if (target.children[tmp].data.name === cur.data.name) {
         alert("对应单项工程中存在同名数据!");
         return false;
         }
         }
         }

         if (target.data.projType === projectType.tender) {
         parent = target.parent;
         next = target.nextSibling;
         } else {
         parent = target;
         next = target.firstChild();
         }

         if (parent !== cur.parent || (next !== cur && next !== cur.nextSibling)){
         CommonAjax.post('/pm/api/getNewProjectID', {count: 1, user_id: userID}, function (IDs) {
         let typeInfo = {
         updateType: 'copy',
         projType: cur.data.projectType
         };
         let updateData = GetUpdateData(null, parent, next, cur.data.name, cur.data.property, IDs.lowID, typeInfo);
         updateData.forEach(function (data) {
         if (data.updateType === 'copy') {
         data['srcProjectId'] = cur.id();
         }
         });
         pre = GetNeedUpdatePreNode(parent, next);
         if (pre) {
         updateData = {};
         updateData['updateType'] = 'update';
         updateData['updateData'] = {};
         updateData['updateData'][projTreeObj.tree.setting.tree.id] = pre.id();
         updateData['updateData'][projTreeObj.tree.setting.tree.nid] = projTreeObj.tree.maxNodeId() + 1;
         }
         projTreeObj.tree.maxNodeId(IDs.lowID - 1);
         CommonAjax.post('/pm/api/copyProjects', {updateData: updateData, user_id: userID}, function (data) {
         dialog.modal('hide');
         data.forEach(function (nodeData) {
         if (nodeData.updateType === 'copy') {
         projTreeObj.insert(nodeData.updateData, parent, next);
         }
         });
         }, function () {
         dialog.modal('hide');
         });
         });
         }*/

    });

    // 选择工程专业后动态更改费率文件等数据
    $("#tender-engineering").change(function() {
        $('#engineering-info').hide();
        let engineeringList = getEngineeringList();
        if(engineeringList.length === 0){
            return false;
        }
        let selectedEngineering = $(this).val();
        selectedEngineering = parseInt(selectedEngineering);
        let currentLib = {};
        for(let engineering of engineeringList) {
            if (engineering.engineering === selectedEngineering) {
                currentLib = engineering.lib;
            }
        }

        if (Object.keys(currentLib).length <= 0) {
            return false;
        }
        // 输出数据到页面
        if (currentLib.fee_lib !== undefined && currentLib.fee_lib.length > 0) {
            $("#tender-fee-rate").children("option").first().val("newFeeRate-"+currentLib.fee_lib[0].id);
        }
        $(this).parent().siblings('.hidden-area').slideDown('fast');
    });
});

/**
 * 初始化数据
 *
 * @return {void}
 */
function init() {
    billValuation = billValuation.replace(/\n/g, '\\n');
    rationValuation = rationValuation.replace(/\n/g, '\\n');
    //init spread and pmTree
    $.bootstrapLoading.start();
    GetAllProjectData(function (datas) {
       // projTreeObj.getShowData(datas);
        projTreeObj.tree = pmTree.createNew(projTreeObj.setting, datas);
        projTreeObj.tree.selected = projTreeObj.tree.items[0];
        projTreeObj.workBook = projTreeObj.buildSheet(projTreeObj.workBook,'projSpread',projTreeObj.setting);
        projTreeObj.sumEngineeringCost();
        projTreeObj.showTreeData(projTreeObj.tree.items, projTreeObj.setting.header, projTreeObj.workBook.getActiveSheet());
        //初始选择
        let initSel = projTreeObj.workBook.getSheet(0).getSelections()[0] ? projTreeObj.workBook.getSheet(0).getSelections()[0] : {row: 0, rowCount: 1};
        projTreeObj.initSelection(initSel,null,projTreeObj.workBook.getActiveSheet());
        $.bootstrapLoading.end();
    });
    engineering = engineeringList !== null && engineeringList !== undefined ? JSON.parse(engineeringList) : [];
}

/**
 * 新增建设项目
 *
 * @return {boolean}
 */
function AddProject() {
    let name = $('#project-name').val().trim();
    if (name === '') {
        setDangerInfo($('#project-name-info'), '请填写建设项目名称');
        return false;
    }
    let existCallback = function () {
        setDangerInfo($('#project-name-info'), `已存在“${$("#project-name").val()}”`);
    };
    let sucCallback = function () {
        $('#add-project-dialog').modal('hide');
        $('#project-name').val('');
        setDangerInfo($('#project-name-info'), '', false);
    };
    let selectedItem = projTreeObj.tree.selected;

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

//新建建设项目、新建单项工程、新建文件夹、重命名弹窗隐藏事件
function bindModalsHidden(projDialog, engDialog, folderDialog, renameDialog){
    projDialog.on('hidden.bs.modal', function () {
        setDangerInfo($('#project-name-info'), '', false);
        $('#project-name').val('');
    });
    engDialog.on('hidden.bs.modal', function () {
        setDangerInfo($('#engineering-name-info'), '', false);
        $('#engineering-name').val('');
    });
    folderDialog.on('hidden.bs.modal', function () {
        setDangerInfo($('#folder-name-info'), '', false);
        $('#folder-name').val('');
    });
    renameDialog.on('hidden.bs.modal', function () {
        setDangerInfo($('#rename-name-info'), '', false);
        $('#rename-name').val('');
    });
}

//绑定新建建设项目、新建单项工程、新建文件夹、重命名回车键功能
function bindInputs(projInput, engInput, foldInput, renameInput){
    projInput.bind('keypress', function (event) {
        if(event.keyCode === 13){
            $('#addProjOk').click();
            return false;
        }
    });
    engInput.bind('keypress', function (event) {
        if(event.keyCode === 13){
            $('#add-engineering-confirm').click();
            return false;
        }
    });
    foldInput.bind('keypress', function (event) {
        if(event.keyCode === 13){
            $('#add-folder-confirm').click();
            return false;
        }
    });
    renameInput.bind('keypress', function (event) {
        if(event.keyCode === 13){
            $('#rename-confirm').click();
            return false;
        }
    });
}
//新建建设项目、单项工程、文件夹、重命名提示(文本改变，暂时不需要)
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 AddTenderItems(selected, projName, engName, tenderName, property, callback){
    const addPath = {p_e_t: 'p_e_t', e_t: 'e_t', t: 't'};
    let path, updateDatas = [];
    let tempProjs = getProjs(selected);
    let tempProj = getNodeByName(projName, tempProjs);
    let tempEng;
    if(tempProj){
        tempEng = getNodeByName(engName, tempProj.children);
        if(tempEng){
            path = addPath.t;
        }
        else {
            path = addPath.e_t
        }
    }
    else {
        path = addPath.p_e_t;
    }
    if(path === addPath.p_e_t){
        let parent, pre, next;
        GetNewProjectId(3, function (IDs) {
            let projID = IDs.lowID, engID = IDs.lowID + 1, tenderID = IDs.lowID + 2;
            if(!selected || selected.data.projType === projectType.project){
                parent = selected ? selected.parent : projTreeObj.tree._root;
                pre = selected;
                next = selected ? selected.nextSibling : projTreeObj.tree.firstNode();
            }
            else if(selected.data.projType === projectType.folder){
                parent = selected ? selected : projTreeObj.tree._root;
                pre = selected ? selected.lastChild() : projTreeObj.tree.firstNode();
                next = null;
            }
            else if(selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender){
                let selectedProj = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent;
                parent = selectedProj ? selectedProj.parent : projTreeObj.tree._root;
                pre = selectedProj;
                next = selectedProj ? selectedProj.nextSibling : projTreeObj.tree.firstNode();
            }
            let updateProjs = GetUpdateData(pre, parent, next, projName, null, projID, {updateType: 'new', projectType: projectType.project});
            let updateEng = {updateType: 'new', updateData: {ID: engID, ParentID: projID, NextSiblingID: -1, name: engName, projType: projectType.engineering}};
            property.rootProjectID = projID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: engID, NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            updateDatas = updateDatas.concat(updateProjs);
            updateDatas.push(updateEng);
            updateDatas.push(updateTender);
            UpdateProjectData(updateDatas, function(datas){
                let projData, engData, tenderData;
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        if(data.updateData.projType === projectType.project){
                            projData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.engineering){
                            engData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.tender){
                            tenderData = data.updateData;
                        }
                    }
                });
                let pojNode = projTreeObj.insert(projData, parent, next);
                let engNode = projTreeObj.insert(engData, pojNode, null);
                projTreeObj.insert(tenderData, engNode, null);
                callback();
            });
        });
    }
    else if(path === addPath.e_t){
        GetNewProjectId(2, function (IDs) {
            let engID = IDs.lowID, tenderID = IDs.lowID + 1;
            let pre = tempProj.lastChild();
            let next = null;
            let updateEng = {updateType: 'new', updateData: {ID: engID, ParentID: tempProj.data.ID, NextSiblingID: -1, name: engName, projType: projectType.engineering}};
            property.rootProjectID = tempProj.data.ID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: engID, NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            if(selected && selected.data.projType === projectType.engineering && selected.parent === tempProj){
                pre = selected;
                next = selected.nextSibling;
                updateEng.updateData.NextSiblingID = pre.data.NextSiblingID;
            }
            updateDatas.push(updateEng);
            updateDatas.push(updateTender);
            if(pre){
                updateDatas.push({updateType: 'update', updateData: {ID: pre.id(), NextSiblingID: engID}});
            }
            UpdateProjectData(updateDatas, function (datas) {
                let engData, tenderData;
                datas.forEach(function (data) {
                    if (data.updateType === 'new') {
                        if(data.updateData.projType === projectType.engineering){
                            engData = data.updateData;
                        }
                        else if(data.updateData.projType === projectType.tender){
                            tenderData = data.updateData;
                        }
                    }
                });
                let engNode = projTreeObj.insert(engData, tempProj, next);
                projTreeObj.insert(tenderData, engNode, null);
                callback();
            });
        });
    }
    else if(path === addPath.t){
        GetNewProjectId(1, function (IDs) {
            let tenderID = IDs.lowID;
            let pre = tempEng.lastChild();
            property.rootProjectID = tempProj.data.ID;
            let updateTender = {updateType: 'new', updateData: {ID: tenderID, ParentID: tempEng.id(), NextSiblingID: -1, name: tenderName, projType: projectType.tender, property: property}};
            updateDatas.push(updateTender);
            if(pre){
                updateDatas.push({updateType: 'update', updateData: {ID: pre.id(), NextSiblingID: tenderID}});
            }
            UpdateProjectData(updateDatas, function (datas) {
                datas.forEach(function (data) {
                    if(data.updateType === 'new') {
                        projTreeObj.insert(data.updateData, tempEng, null);
                    }
                });
                callback();
            })
        });
    }
}

/**
 * 新增子元素
 *
 * @param {String} name
 * @param {String} type
 * @param {function} callback
 * @return {void}
 */
function AddChildrenItem(selected, name, property, type, existCallback, sucCallback) {
    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') {
                        projTreeObj.insert(data.updateData, parent, null);
                    }
                });
                sucCallback();
            });
        });
    }
}

/**
 * 新增同级元素
 *
 * @param {String} name
 * @param {String} type
 * @param {function} callback
 * @return {void}
 */
function AddSiblingsItem(selected, name, property, type, existCallback, sucCallback) {
    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)){
        //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') {
                        projTreeObj.insert(data.updateData, parent, next);
                    }
                });
                sucCallback();
            });
        });
    }
}

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 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){
    for(let i = 0, len = nodes.length; i < len; i++){
        if(name === nodes[i].data.name){
            return true;
        }
    }
    return false;
}

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

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

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

//建设项目下拉框
function setProjOptions(projs, selected){
    $("#poj-name-list").empty();
    $("#poj-name").val("");
    if(projs.length > 0){
        let firstProj = selected && selected.data.projType === projectType.project ? selected: projs[0];
        $("#poj-name").val(firstProj.data.name);
        setFileOptions(firstProj.data.ID);
        setEngOptions(firstProj.data.ID);
        for(let i = 0, len = projs.length; i < len; i++){
            let proj = $("<button>").val(projs[i].data.ID).text(projs[i].data.name);
            proj.addClass("dropdown-item");
            proj.attr("type", "button");
            proj.click(function () {
                $("#poj-name").val(projs[i].data.name);
                setFileOptions(projs[i].data.ID);
                setEngOptions(projs[i].data.ID);
            });
            $("#poj-name-list").append(proj);
        }
    }
    else {
        setFileOptions(null);
        setEngOptions(null);
    }
}
//单项工程下拉框
function setEngOptions(projID){
    let proj = projTreeObj.tree.findNode(projID) || null;
    $("#eng-name-list").empty();
    $("#eng-name").val("");
    if(proj){
        let engineerings = [].concat(proj.children);
        //set selected engineering to first place
        let selected = projTreeObj.tree.selected;
        let firstNode = null;
        if(selected && (selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender)){
            firstNode = selected.data.projType === projectType.engineering ? selected : selected.parent;
        }
        if(firstNode){
            let index = null;
            for(let i = 0, len = engineerings.length; i < len; i++){
                if(firstNode.data.ID === engineerings[i].data.ID){
                    index = i;
                }
            }
            if(index){
                engineerings.splice(index, 1);
                engineerings.splice(0, 0, firstNode);
            }
        }
        if(engineerings.length > 0){
            $("#eng-name").val(engineerings[0].data.name);
            for(let i = 0, len = engineerings.length; i < len; i++){
                let eng = $("<button>").val(engineerings[i].data.ID).text(engineerings[i].data.name);
                eng.addClass("dropdown-item");
                eng.attr("type", "button");
                eng.click(function () {
                    $("#eng-name").val(engineerings[i].data.name);
                });
                $("#eng-name-list").append(eng);
            }
        }
    }
}

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

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

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

/**
 * 新增单位工程
 *
 * @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 engName = $("#eng-name").val().trim();
        if(engName === ''){
            replaceClass($('#eng-name-info'), 'text-info', 'text-danger');
            setDangerInfo($('#eng-name-info'), '请填写单项工程名称');
            return false;
        }

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

        if(hasTender(projTreeObj.tree.selected, projName, engName, tenderName)){
            return false;
        }

        let unitPriceFile = $("#unit-price").val();
        let unitPriceName = unitPriceFile !== '' ? $("#unit-price").children("option:selected").text() : tenderName;

        let feeFile = $("#tender-fee-rate").val();
        let feeFileName = $("#tender-fee-rate").children("option:selected").text();

        let valuation = $("#valuation").val();
        if(valuation === ''){
            setDangerInfo($('#valuation-info'), '请选择计价规则');
            return false;
        }

        let engineering = $("#tender-engineering").val();
        if (engineering === '') {
            setDangerInfo($('#engineering-info'), '请选择工程专业');
            return false;
        }

        let valuationName = $("#valuation").children("option:selected").text();
        let valuationType = $("input[name='valuation_type']:checked").val();

        let engineering_id = 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 = null;
        for(let tmp of engineeringList) {
            if (tmp.engineering == engineering) {
                engineering_id = tmp.engineering_id;
                libs = tmp.lib;
                break;
            }
        }
        // 一个项目里面，这两个文件必须得有，而界面又没有像费率、单价文件那样给出可选项。所以这里给出提示。
        if (!libs.artificial_lib)  throw '编办没有绑定人工系数标准文件';
        if (!libs.program_lib)  throw '编办没有绑定计算程序标准文件';

        let engineeringName = $('#tender-engineering').children("option:selected").text();

        let callback = function() {
            $("#add-tender-dialog").modal("hide");
            $('#tender-name').val('');
            $("#tender-fee-rate").children("option").removeAttr("selected");
            $("#tender-engineering").children("option").removeAttr("selected");
            $("#poj-name").val('');
            $("#poj-name-info").hide();
            $("#eng-name").val('');
            $("#eng-name-info").hide();

        };
        let selectedItem = projTreeObj.tree.selected;
        let tenderInfo = {
            valuation: valuation,
            valuationType: valuationType,
            valuationName: valuationName,
            engineering: engineering,
            engineering_id: engineering_id,
            engineeringName: engineeringName,
            unitPriceFile: {name: unitPriceName, id: unitPriceFile},
            feeFile: {name: feeFileName, id: feeFile}
        };
        AddTenderItems(selectedItem, projName, engName, tenderName, tenderInfo, callback);

    } catch (error) {
        alert(error);
    }
}

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

    let selectedItem = projTreeObj.tree.selected;
    let existCallback = function () {
        setDangerInfo($('#folder-name-info'), `已存在“${$("#folder-name").val()}”`);
    };
    let sucCallback = function () {
        $('#add-folder-dialog').modal('hide');
        $('#folder-name').val('');
        setDangerInfo($('#folder-name-info'), '', false);
    };
    if (selectedItem !== null) {
        // 判断是否超过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);
        }
        else if(selectedItem.data.projType === projectType.engineering || selectedItem.data.projType === projectType.tender){
            let proj = selectedItem.parent.data.projType === projectType.project ? selectedItem.parent : selectedItem.parent.parent;
            AddSiblingsItem(proj, name, null, projectType.folder, existCallback, sucCallback);
        }
    } else {
        AddSiblingsItem(null, name, null, projectType.folder, existCallback, sucCallback);
    }
}

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

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

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

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

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

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

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

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

/**
 * 重命名项目
 *
 * @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 = '<option value="">请选择对应的工程专业</option>';
    if (engineeringList.length <= 0) {
        return result;
    }
    let engineeringObject = {};
    for(let tmp of engineering) {
        engineeringObject[tmp.value] = tmp.name;
    }

    for(let tmp of engineeringList) {
        if (engineeringObject[tmp.engineering] !== undefined) {
            result += '<option value="'+ tmp.engineering +'">'+ engineeringObject[tmp.engineering] +'</option>';
        }
    }

    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;
    let name = selectedItem.data.name;
    let target = selectedItem.data.projType === projectType.project ? '#summary-project' : '#summary-engineering';
    $(".side-content .p-3").hide();
    $(target).show();

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

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

//单价、费率文件汇总界面交互
function bindEvents_file_table(jqS, usedObj, targetBody, type){
    //悬浮显示删除和重命名按钮
    $(jqS).hover(function(){
        $('p',this).show();
    },function(){
        $('p', this).hide();
    });
    //删除
    if(usedObj.usedCount > 0){//不可删除
        $(jqS + ' p a:eq(0)').addClass('disabled');
        $(jqS + ' p a:eq(0)').removeAttr('data-target');
    }
    else {
        $(jqS + ' p a:eq(0)').on('click', function () {
            let dispName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
            //刷新删除弹出框内容
            let delData = '删除"' + dispName + '"？';
            $('#del-wj .modal-body h5').text(delData);
            let attrId = $(jqS).attr('id');
            let id = attrId.slice(5, attrId.length);
            if(type === fileType.unitPriceFile){
                id = parseInt(id);
            }
            let obj = Object.create(null);
            obj.fileType = type;
            obj.id = id;
            fileDelObj = obj;
        });
    }
    //重命名
    $(jqS + ' p a:eq(1)').on('click', function () {
        let fileObjs = getFileObj(targetBody, type);
        let orgDispName = $(jqS + ' div:eq(0)')[0].childNodes[0].textContent;
        let postFix = '';
        let orgName = orgDispName;
        $(jqS + ' input').val(orgName);
        $(jqS + ' div:eq(0)').hide();
        $(jqS + ' div:eq(1)').show();
        //确认重命名
        $(jqS + ' .btn-success').on('click', function () {
            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)){
                    alert('本建设项目已存在该文件名，请重新输入！');
                    $(jqS + ' input').val(orgName);
                    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);
                    //updateObj.updateData.id = id;
                }
                else if(type === fileType.feeRateFile){
                    updateObj.updateData.ID = id;
                }
                updateObj.updateData.name = newName;
                a_updateFiles([updateObj], function () {
                    let newDispName = newName + postFix;
                    $(jqS + ' div:eq(0)')[0].childNodes[0].textContent = newDispName;
                    $(jqS + ' div:eq(0)').show();
                    $(jqS + ' div:eq(1)').hide();
                    //refresh tender
                    refreshTenderFile(getTendersByFile(type, id, projTreeObj.tree.selected), type, newName);
                });
            }
            let newDispName = newName + postFix;
            $(jqS + ' div:eq(0)')[0].childNodes[0].textContent = newDispName;
            $(jqS + ' div:eq(0)').show();
            $(jqS + ' div:eq(1)').hide();
        });
        //取消重命名
        $(jqS + ' .btn-secondary').on('click', function () {
            $(jqS + ' div:eq(0)').show();
            $(jqS + ' div:eq(1)').hide();
        });
    });
    //悬浮框显示使用该文件的单位工程
    $($(jqS)[0].nextSibling).popover({
            placement:"bottom",
            html:true,
            trigger:"hover", //| focus.
            content: usedObj.usedInfo ? usedObj.usedInfo : ''
        }
    );
}

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

function set_file_table(target, poj_tenders, fileList, type){
    let fileCounter = 1;
    for(let i = 0, len = fileList.length; i < len; i++){
        let fileId = type === fileType.unitPriceFile ? fileList[i].id : fileList[i].ID;
        let usedObj = getUsedObj(poj_tenders, fileId, type);
        let usedHtml = usedObj.usedCount > 0 ?  '<td class="text-center"><a href="javascript:void(0);">' + usedObj.usedCount + '</a></td>' : '<td class="text-center">' + usedObj.usedCount + '</td>';
        let hoverHtml = '<p style="display: none"><a class="btn btn-sm" href="javascript:void(0);" data-toggle="modal" data-target="#del-wj">删除</a><a class="btn btn-sm" href="javascript:void(0);">重命名</a></p></div>';
        let renHtml = '<div class="input-group" style="display: none;">'
            + '<input class="form-control form-control-sm" value="">'
            + '<span class="input-group-btn">'
            + '<button class="btn btn-success btn-sm" type="button"><i class="fa fa-check"></i></button>'
            + '</span>'
            + '<span class="input-group-btn">'
            + '<button class="btn btn-secondary btn-sm" type="button"><i class="fa fa-remove"></i></button>'
            + '</span>'
            + '</div></td>';
        let fileTypeStr = type === fileType.unitPriceFile ? '单价文件' : '费率文件';
        let fileHtml = '<tr><td>' + fileCounter + '</td><td id="file_' + fileId + '"><div>' + fileList[i].name + hoverHtml + renHtml + usedHtml + '</tr>';
        fileCounter++;
        let targetBody = type === fileType.unitPriceFile ? target + '-unit-price-table tbody' : target + '-fee-table tbody';
        $(targetBody).append(fileHtml);
        let jqS = '#file_' + fileId;
        bindEvents_file_table(jqS, usedObj, targetBody, type);
    }
}

function getFileObj(jqS, type){
    let rst = [];
    let trs = $('tr', jqS);
    for(let i = 0, len = trs.length; i < len; i++){
        let td = $('td:eq(1)', trs[i])[0];
        let dispName = td.childNodes[0].childNodes[0].textContent;
        let name = dispName.slice(0, dispName.length - 4);
        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);
       }
   });
}