/** * 项目管理相关js * * @author CaiAoLin * @date 2017/8/22 * @version */ //todo: 全部、分享、回收站树统一 let Tree = null;// let movetoZTree = null; let copytoZTree = null; let engineering = []; let feeRateData = []; let isSaving = false; let projectProperty = []; let fileDelObj = null; let projectType = { folder: 'Folder', tender: 'Tender', project: 'Project', engineering: 'Engineering' }; let fileType = { unitPriceFile: 'UnitPriceFile', feeRateFile: 'FeeRateFile' }; let taxTypeMap = { 1:"一般计税", 2:"简易计税" }; function isDef(v) { return typeof v !== 'undefined' && v !== null; } const projTreeObj = { tree: null, workBook: null, copyToWorkBook:null, copySelected:null, preSelection: null, setting: { tree: { id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: false }, //0.48 0.13 0.15 0.15 0.09 header: [ {name: '工程列表', dataCode: 'name', width: 300, vAlign: 'center', hAlign: 'left'}, {name: '工程造价', dataCode: 'engineeringCost', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '分部分项合计', dataCode: 'subEngineering', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '措施项目合计', dataCode: 'measure', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '其他项目合计', dataCode: 'other', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, //{name: '安全文明施工费', dataCode: 'safetyConstruction', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '规费', dataCode: 'charge', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '税金', dataCode: 'tax', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '占造价比例(%)', dataCode: 'rate', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '建筑面积', dataCode: 'buildingArea', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '单方造价', dataCode: 'perCost', width: 100, vAlign: 'center', hAlign: 'right', formatter: '0.00'}, {name: '单价文件', dataCode: 'unitPriceFile', width: 140, vAlign: 'center', hAlign: 'left'}, {name: '费率文件', dataCode: 'feeRateFile', width: 140, vAlign: 'center', hAlign: 'left'}, {name: '创建日期', dataCode: 'createDateTime', width: 100, vAlign: 'center', hAlign: 'center'} ], //选中行颜色 style: { defalutBackColor: 'White', selectedColor: '#BBFFFF' }, options: { tabStripVisible: false, allowContextMenu: false, allowCopyPasteExcelStyle : false, allowExtendPasteRange: false, allowUserDragDrop : 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); let workBookWidth = getWorkBookWidth(); for(let i = 0, len = headers.length; i < len; i++){ sheet.setValue(0, i, headers[i].name, GC.Spread.Sheets.SheetArea.colHeader); let width = headers[i].width; sheet.setColumnWidth(i, width, GC.Spread.Sheets.SheetArea.colHeader); if (headers[i].formatter) { sheet.setFormatter(-1, i, headers[i].formatter, GC.Spread.Sheets.SheetArea.viewport); } } }; me.renderSheetFuc(sheet, fuc); }, buildSheet: function (workBook,spreadID,setting) {//改成和复制项目spread共用 let newWorkBook = workBook; if(!workBook){ newWorkBook = new GC.Spread.Sheets.Workbook($('#'+spreadID)[0], {sheetCount: 1}); this.setOptions(newWorkBook, setting.options); this.buildHeader(newWorkBook.getActiveSheet(), setting.header); this.bindEvent(newWorkBook); this.loadContextMenu() } return newWorkBook; }, loadContextMenu: function () { let me = this; $.contextMenu({ selector: '#projSpread', build: function ($trigger, e) { let target = SheetDataHelper.safeRightClickSelection($trigger, e, me.workBook); me.initSelection({row: target.row, rowCount: 1}, me.preSelection ? me.preSelection : null, me.workBook.getActiveSheet()); return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader; }, items: { "addFolder": { name: "新建文件夹", icon: 'fa-folder-o', disabled: function () { return false; }, callback: function (key, opt) { $("#add-folder-dialog").modal("show"); setTimeout(function () { $('#folder-name')[0].focus(); }, 300); } }, "addProject": { name: "新建建设项目", icon: 'fa-cubes', disabled: function () { return false; }, callback: function (key, opt) { $('#add-project-dialog').modal('show'); setTimeout(function () { $('#project-name')[0].focus(); }, 300); } }, "addEngineering": { name: "新建单项工程", icon: 'fa-cube', disabled: function () { let node = me.tree.selected; if(node && node.data.projType !== projectType.folder){ return false; } return true; }, callback: function (key, opt) { let selectedItem = me.tree.selected; try { if(selectedItem !== null && selectedItem.data.projType !== projectType.folder){ $("#add-engineering-dialog").modal("show"); setTimeout(function () { $('#engineering-name')[0].focus(); }, 300); } } catch (error) { alert(error); } } }, "addTender": { name: "新建单位工程", icon: 'fa-sticky-note-o', disabled: function () { return false; }, callback: function (key, opt) { //弹出新建单位工程之前,判断当前使用版本,且当前使用单位工程数是否已到最大值 let selectedItem = me.tree.selected; $("#add-tender-dialog").modal("show"); } }, "spr1": '--------', "rename": { name: "重命名", icon: 'fa-edit', disabled: function () { return !me.tree.selected; }, callback: function (key, opt) { $('#rename-name').val(projTreeObj.tree.selected.data.name ? projTreeObj.tree.selected.data.name : ''); $('#rename-dialog').modal('show'); setTimeout(function () { $('#rename-name')[0].focus(); }, 300); } }, "delete": { name: "删除", icon: 'fa-remove', disabled: function () { let node = me.tree.selected; return !node || (node.data.projType === projectType.folder && node.children.length > 0); }, callback: function (key, opt) { if (projTreeObj.tree && projTreeObj.tree.selected) { $('#del').modal('show'); } } }, "copyTo": { name: "复制到", icon: 'fa-copy', disabled: function () { let node = me.tree.selected; return !(node && node.data.projType === projectType.tender); }, callback: function (key, opt) { let selectedItem = projTreeObj.tree.selected; try { let selectedType = selectedItem !== null && selectedItem.data !== undefined ? selectedItem.data.projType : ''; if (selectedType !== projectType.tender) { throw '请选择单位工程进行复制'; } } catch (error) { alert(error); return false; } //更新选中项目缓存 $('#copy-to-dialog').modal('show'); } }, "spr2": '--------', "share": { name: "分享", icon: 'fa-share', disabled: function () { let selectedItem = projTreeObj.tree.selected; return !(selectedItem && selectedItem.data.projType === projectType.tender); }, callback: function (key, opt) { $('#sharePhone').val(''); $('#share-info').hide(); $('#share').find('.card').hide(); $('#share').modal('show'); $('#allowCopy').prop('checked', false); $('#allowCopyHint').hide(); } }, "spr3": '--------', "manageFiles": { name: "管理相关文件", icon: 'fa-list', disabled: function () { let selectedItem = projTreeObj.tree.selected; return !(selectedItem && selectedItem.data.projType !== projectType.folder); }, callback: function (key, opt) { setDataToSideBar(); $(".slide-sidebar").animate({width:"440"}).addClass("open"); setTimeout(function () { $("body").bind('click', function (event) { var e = event || window.event; //浏览器兼容性 if (!$(event.target).is('a')) { var elem = event.target || e.srcElement; while (elem) { //循环判断至跟节点,防止点击的是div子元素 if (elem.className == "open-sidebar" || elem.className == 'slide-sidebar open') { return false; } if($(elem).attr('id') && $(elem).attr('id') === 'del-wj'){ return false; } elem = elem.parentNode; } $(".slide-sidebar").animate({width: "0"}).removeClass("open")// 关闭处理 $('body').unbind('click'); } }); }, 500); } }, "refreshSummary": { name: "刷新当前项目造价", icon: 'fa-refresh', disabled: function () { let selectedItem = projTreeObj.tree.selected; return !(selectedItem && selectedItem.data.projType !== projectType.folder); }, callback: function (key, opt) { //获取当前节点的建设项目ID let project = projTreeObj.tree.selected; while (project.data.projType !== projectType.project && project.parent){ project = project.parent; } if(project && project.data.ID){ $.bootstrapLoading.start(); CommonAjax.post('/pm/api/getSummaryInfo', {user_id: userID, projectIDs: [project.data.ID]}, function (summaryInfo) { refreshProjSummary(project, summaryInfo); $.bootstrapLoading.end(); }, function () { $.bootstrapLoading.start(); }); } } } } }); }, getSelStyle: function (backColor) { let style = new GC.Spread.Sheets.Style(); style.backColor = backColor; style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin); style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin); style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin); style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin); return style; }, //设置选中行底色 setSelStyle: function (sel, backColor,sheet) { let me = this; //let sheet = me.workBook.getSheet(0); sel.row = sel.row === -1 ? 0 : sel.row; me.renderSheetFuc(sheet, function () { let style = me.getSelStyle(backColor); for(let i = 0; i < sel.rowCount; i++){ let row = i + sel.row; sheet.setStyle(row, -1, style); } }); }, initSelection: function (newSel, oldSel = null,sheet) { let me = this; let node = me.tree.items[newSel.row]; node = node ? node : null; //恢复底色 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; shareSeleted = node; me.preSelection = newSel; /* $(".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&&selected.data.projType == targetNode.data.projType){//如果目标节点与选中节点的前一节点一样,并且选中节点与目标节点项目类型也一样的话,不用移动 return; } if(selected == targetNode){ return; } if(selected.data.projType=="Tender"){//移动单位工程 oldProject = selected.parent.parent;//记录原来的建设项目 if(targetNode.data.projType=="Tender"||targetNode.data.projType=="Engineering"){//只能移动到这两个地方 if(targetNode.data.projType=="Tender"){//移动到单位工程后面 [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true); rootProjectID = targetNode.parent.pid(); }else{//移动后成为单项工程的子项 [parent,next] =getMoveUpdateData(selected,targetNode,projectMap,false); rootProjectID = targetNode.pid(); } if(selected.data.property.rootProjectID != rootProjectID){//如果不属于同一个建设项目,要检查是否移动或复制单价文件和费率文件 projectMap[selected.id()].update['property.rootProjectID'] = rootProjectID; //要改变根项目ID //检查费率文件和单价文件 moveOrCopy(selected,rootProjectID,feeRateMap,unitPriceMap,false); } } } if(selected.data.projType=="Engineering"){//移动的是单项工程 oldProject = selected.parent;//记录原来的建设项目 if(targetNode.data.projType=="Engineering"||targetNode.data.projType=="Project"){//目标位置是单项工程和建设项目 if(targetNode.data.projType=="Engineering"){ [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true); rootProjectID = targetNode.pid(); }else { [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,false); rootProjectID = targetNode.id(); } if(selected.pid() != rootProjectID){//跨了建设项目,更新子项目,同时要检查是否移动或复制子项的单价文件和费率文件。 //检查费率文件和单价文件 for(let c of selected.children){ projectMap[c.id()] = {query:{'ID':c.id()},update:{'property.rootProjectID':rootProjectID}}; moveOrCopy(c,rootProjectID,feeRateMap,unitPriceMap,true); } } } } if(selected.data.projType=="Project"){//移动的是建设项目 if(targetNode.data.projType=="Project"||targetNode.data.projType=="Folder") {//目标位置是建设项目和文件夹 if(targetNode.data.projType=="Project"){ [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,true); }else { [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,false); } } } if(selected.data.projType=="Folder"&&targetNode.data.projType=="Folder") {//文件夹只能移动到文件夹下 [parent,next] = getMoveUpdateData(selected,targetNode,projectMap,false);//成为子项 } if(_.isEmpty(projectMap)){//项目数据为空 return; } $.bootstrapLoading.start(); moveProjects({"user_id": userID,rootProjectID:rootProjectID,projectMap:projectMap,feeRateMap:feeRateMap,unitPriceMap:unitPriceMap},function (result) { for(let key in result){//更新前端节点数据 let updateData = result[key].update; let node = projTreeObj.tree.findNode(result[key].query.ID); if(node){ for(let ukey in updateData){ _.set(node.data,ukey,updateData[ukey]); } } } projTreeObj.moveTo(selected,targetNode,parent,next,oldProject); $.bootstrapLoading.end(); }); function getMoveUpdateData(sel,target,projectMap,sameLevel) { let tem_parent = null,tem_next = null; if(sameLevel==true){//移动后的位置的级别相同 tem_parent = target.parent; tem_next = target.nextSibling; //移动到target的后面 projectMap[target.id()] = {query:{'ID':target.id()},update:{'NextSiblingID':sel.id()}}; }else {//移动后变成子项 tem_parent = target; tem_next = target.firstChild(); } let nextID = tem_next?tem_next.id():-1; if(sel.preSibling() != null){//如果原来有前项,更新下一节点 projectMap[sel.preSibling().id()] = {query:{'ID':sel.preSibling().id()},update:{'NextSiblingID':sel.data.NextSiblingID}}; } if(sel.parent.id() == tem_parent.id()){//移动前移动后的父项相同,只改变next if(selected.id() != nextID){//父项相同的情况下, 下一节点ID如果等于选中的ID即项目没有移动,不用做处理 projectMap[selected.id()] = {query:{'ID':selected.id()},update:{'NextSiblingID':nextID}}; } }else {// let temData = {query:{'ID':selected.id()},update:{'ParentID':tem_parent.id(),'NextSiblingID':nextID}}; let reName = projTreeObj.projectNameChecking(tem_parent,selected);//重名检查 if(reName){ temData.update['name'] = reName } projectMap[selected.id()] = temData; } return [tem_parent,tem_next] } function moveOrCopy(sel,rootProjectID,feeRateMap,unitPriceMap,sameCheck) {//检查选中的项目使用的费率文件和单价文件是要移动还是复制一份 let project = sel.parent.parent;//取建设项目 let sameParent_f = true; let sameParent_u = true; let useFeeRateProject = getTendersByFile(fileType.feeRateFile,sel.data.property.feeFile.id,project); let useUnitPriceProject = getTendersByFile(fileType.unitPriceFile,sel.data.property.unitPriceFile.id,project); let tem_feeRate = {action:'copy',rootProjectID:rootProjectID,name:sel.data.property.feeFile.name,query:{ID:sel.data.property.feeFile.id}}; let tem_unitPrice = {action:'copy',rootProjectID:rootProjectID,name:sel.data.property.unitPriceFile.name,query:{id:sel.data.property.unitPriceFile.id}} if(useFeeRateProject.length==1){//如果没有其它项目使用同一个费率文件,则移动 tem_feeRate.action = 'move'; tem_feeRate.update = {rootProjectID:rootProjectID}; } if(useUnitPriceProject.length == 1){//如果没有其它项目使用同一个单价文件,则移动 tem_unitPrice.action = 'move'; tem_unitPrice.update = {root_project_id:rootProjectID}; } feeRateMap[sel.id()] = tem_feeRate; unitPriceMap[sel.id()] = tem_unitPrice; if(sameCheck == true){//需要检查是否属于同一个单项工程,移动单项工程的时候用 if(useUnitPriceProject.length > 1){ for(let f of useFeeRateProject){ if(f.pid()!=sel.pid()){//父节点不同 sameParent_f = false; break; } } if(sameParent_f == true){//如果使用的都是同属于一个单项工程,在移动单项工程的时候,移动费率文件和单价文件就可以了 feeRateMap[sel.id()].action = 'move'; feeRateMap[sel.id()].update = {rootProjectID:rootProjectID}; } } if(useUnitPriceProject.length > 1){ for(let u of useUnitPriceProject){ if(u.pid()!=sel.pid()){//父节点不同 sameParent_u = false; break; } } if(sameParent_u == true){ unitPriceMap[sel.id()].action = 'move'; unitPriceMap[sel.id()].update = {root_project_id:rootProjectID}; } } } } }, projectNameChecking:function (parent,node,type) { //decDate = '(' + new Date().Format('MM-dd hh:mm:ss') + '恢复)'; type=type?type:'移动'; for(let c of parent.children){ if(c.data.name == node.data.name){//如果存在同名的项目 return node.data.name + '(' + new Date().Format('MM-dd hh:mm:ss') + type+')'; } } return null; }, onCellEditing:function (sender,args) { args.cancel = true; }, getShowData: function (datas) { for(let data of datas){ data.name = data.name ? data.name : ''; if(data.projType !== projectType.tender){ data.engineeringCost = ''; data.unitPriceFile = ''; data.feeRateFile = ''; data.createDateTime = ''; } else{ data.engineeringCost = data.engineeringCost ? data.engineeringCost : 0; data.unitPriceFile = data.property && data.property.unitPriceFile && data.property.unitPriceFile.name ? data.property.unitPriceFile.name : ''; data.feeRateFile = data.property && data.property.feeFile && data.property.feeFile.name ? data.property.feeFile.name : ''; data.createDateTime = data.createDateTime ? new Date(data.createDateTime).Format('yyyy-MM-dd') : ''; } } }, getTreeNodeCell: function (tree) { let me = projTreeObj; let indent = 20; let levelIndent = -5; let halfBoxLength = 5; let halfExpandLength = 3; let imgWidth = 18; let imgHeight = 14; let 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; w = w - (node.depth() + 1) * indent - node.depth() * levelIndent - imgWidth - 3; GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments); }; TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) { let info = {x: x, y: y, row: context.row, col: context.col, cellStyle: cellStyle, cellRect: cellRect, sheetArea: context.sheetArea}; let node = tree.items[info.row]; let offset = -1; let centerX = info.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2; let text = context.sheet.getText(info.row, info.col); let value = context.sheet.getValue(info.row, info.col); let acStyle = context.sheet.getActualStyle(info.row, info.col), zoom = context.sheet.zoom(); let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: context.sheet, row: info.row, col: info.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport}); if(info.x > centerX + halfBoxLength && info.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength){ info.isReservedLocation = true; } return info; }; TreeNodeCellType.prototype.processMouseDown = function (hitinfo) { let offset = -1; let node = tree.items[hitinfo.row]; let centerX = hitinfo.cellRect.x + offset + node.depth() * indent + node.depth() * levelIndent + indent / 2; let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2; let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col); let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col); let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col), zoom = hitinfo.sheet.zoom(); let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport}); //(图标+名字)区域 function withingClickArea(){ return hitinfo.x > centerX + halfBoxLength && hitinfo.x < centerX + halfBoxLength + imgWidth + indent/2+3 + textLength; } if(hitinfo.sheet.name() != "copyToSheet"){//如果是复制到sheet,不用执行 //建设项目,侧滑汇总 /*if(node.data.projType === projectType.project && withingClickArea() && !$('.slide-sidebar').hasClass('open')){ setDataToSideBar(); $(".slide-sidebar").animate({width:"440"}).addClass("open"); setTimeout(function () { $("body").bind('click', function (event) { var e = event || window.event; //浏览器兼容性 if (!$(event.target).is('a')) { var elem = event.target || e.srcElement; while (elem) { //循环判断至跟节点,防止点击的是div子元素 if (elem.className == "open-sidebar" || elem.className == 'slide-sidebar open') { return false; } if($(elem).attr('id') && $(elem).attr('id') === 'del-wj'){ return false; } elem = elem.parentNode; } $(".slide-sidebar").animate({width: "0"}).removeClass("open")// 关闭处理 $('body').unbind('click'); } }); }, 500); }*/ //单项文件,进入造价书界面 if(node.data.projType === projectType.tender && withingClickArea()){ let timeoutTime = 200; if($('.slide-sidebar').hasClass('open')){ timeoutTime = 500; } setTimeout(function () { 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; }, timeoutTime); } 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]; //改变鼠标图案 if (sheet && hitInfo.isReservedLocation) { canvas.style.cursor='pointer'; return true; }else{ canvas.style.cursor='default'; } return false; }; TreeNodeCellType.prototype.processMouseEnter = function (hitinfo) { let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col); let value = hitinfo.sheet.getValue(hitinfo.row, hitinfo.col); let tag = hitinfo.sheet.getTag(hitinfo.row, hitinfo.col); let acStyle = hitinfo.sheet.getActualStyle(hitinfo.row, hitinfo.col), zoom = hitinfo.sheet.zoom(); let node = me.tree.items[hitinfo.row]; let nodeIndent = node ? (node.depth() + 1) * indent + node.depth() * levelIndent + imgWidth + 3 : 0; let textLength = this.getAutoFitWidth(value, text, acStyle, zoom, {sheet: hitinfo.sheet, row: hitinfo.row, col: hitinfo.col, sheetArea: GC.Spread.Sheets.SheetArea.viewport}); let cellWidth = hitinfo.sheet.getCell(-1, hitinfo.col).width(); if(textLength > cellWidth - nodeIndent){ TREE_SHEET_HELPER.showTipsDiv(text,{pos: {}},hitinfo); } }; TreeNodeCellType.prototype.processMouseLeave = function (hitinfo) { let me = this; TREE_SHEET_HELPER.tipDiv = 'hide'; if (TREE_SHEET_HELPER._toolTipElement) { $(TREE_SHEET_HELPER._toolTipElement).hide(); TREE_SHEET_HELPER._toolTipElement = null; }; TREE_SHEET_HELPER.tipDivCheck();//延时检查:当tips正在show的时候,就调用了hide方法,会导致tips一直存在,所以设置一个超时处理 } return new TreeNodeCellType(); }, 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 === 'unitPriceFile'){ if(node.data.projType === projectType.tender){ value = node.data.property && node.data.property.unitPriceFile && node.data.property.unitPriceFile.name ? node.data.property.unitPriceFile.name : ''; } } else if(dataCode === 'feeRateFile'){ if(node.data.projType === projectType.tender){ value = node.data.property && node.data.property.feeFile && node.data.property.feeFile.name ? node.data.property.feeFile.name : ''; } } else if(dataCode === 'createDateTime'){ value = node.data.createDateTime ? new Date(node.data.createDateTime).Format('yyyy-MM-dd') : ''; } else { value = isDef(node.data[dataCode]) ? node.data[dataCode] : ''; } sheet.setValue(row, col, value); }, showTreeData: function (nodes, headers,sheet) { let me = this; let tree = sheet.name() == "copyToSheet"?me.copyTree:me.tree; let fuc = function(){ sheet.setRowCount(0); sheet.setRowCount(nodes.length); let treeNodeCell = me.getTreeNodeCell(tree); sheet.getRange(-1, 0, -1, 1).cellType(treeNodeCell); for(let i = 0; i < nodes.length; i++){ for(let j = 0; j < headers.length; j++){ sheet.getRange(-1, j, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign[headers[j]['hAlign']]); sheet.getRange(-1, j, -1, 1).vAlign(GC.Spread.Sheets.VerticalAlign[headers[j]['vAlign']]); 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.folder){//如果是文件夹时不用计算 return; } if(node.data.projType == projectType.project){ projectNode = node; } if(node.data.projType == projectType.engineering){ projectNode = node.parent; } if(node.data.projType == projectType.tender){ projectNode = node.parent&&node.parent.parent?node.parent.parent:null; } if(projectNode){ calNode(projectNode); } let children = projectNode.children; refreshNodes.push(projectNode); return refreshNodes.concat(children); function calNode(node) { let tem_sum = 0; if(node.data.projType == projectType.tender){ return; } for(let t of node.children){ calNode(t); let temP = scMathUtil.roundForObj(t.data.engineeringCost,2); tem_sum = scMathUtil.roundForObj(temP+tem_sum,2); } node.data.engineeringCost = scMathUtil.roundToString(tem_sum,2); } }, initCopyToSpread:function () { let me = this; me.copyToWorkBook = projTreeObj.buildSheet(me.copyToWorkBook,'copyToSpread',me.copyToSetting); let sheet = me.copyToWorkBook.getActiveSheet(); sheet.options.isProtected = true; sheet.name('copyToSheet'); let datas = []; for(let i of me.tree.items){ datas.push(i.data); } me.copyTree = pmTree.createNew(projTreeObj.setting, datas); me.showTreeData(me.copyTree.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 preNode = this.tree.items[this.preSelection.row]; let node = this.tree.addNodeData(data, parent, next); this.addRow(node); let newSel = this.workBook.getSheet(0).getSelections()[0]; this.initSelection(newSel, preNode ? {row:preNode.serialNo(),rowCount:1} : null,this.workBook.getActiveSheet());//这里不能直接用this.preSelection,因为如果插入的记录在preSelection的前面时,之前old选中行已经变了,改不了old行的颜色 return node; }, addRow: function (node) { const me = this; const sheet = this.workBook.getActiveSheet(); me.renderSheetFuc(sheet, function () { const items = me.tree.items; const rIdx = items.indexOf(node); const cIdx = sheet.getActiveColumnIndex(); sheet.addRows(rIdx, 1); //set selection selected sheet.setSelection(rIdx, cIdx, 1, 1); me.tree.selected = node; //父节点收起时添加子节点,子节点添加完后隐藏 if(node.parent && !node.parent.expanded){ sheet.setRowVisible(rIdx, false); } 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() { $('#sideTab').find('li').click(function () { //消除tooltip $('[data-toggle="tooltip"]').tooltip('hide'); }); //列宽随着屏幕改变 $(window).resize(function () { sheetCommonObj.setColumnWidthByRate(getWorkBookWidth(), gcTreeObj.workBook, gcTreeObj.setting.header); sheetCommonObj.setColumnWidthByRate(getWorkBookWidth(), pmShare.spreadObj.workBook, pmShare.headers); }); init(); $('#tab_pm_all').on('show.bs.tab', function () { if(gcTreeObj.workBook){ gcTreeObj.workBook.destroy(); gcTreeObj.workBook = null; } gcTreeObj.tree = null; init(); }); // 侧滑数据 /* $(".poj-list").on('click', ".open-sidebar", function() { setDataToSideBar(); $(".slide-sidebar").animate({width:"800"}).addClass("open"); });*/ //单价、费率文件删除确认 $('#fileDelConfirm').click(function () { if(fileDelObj && fileDelObj.id){ let updateObj = Object.create(null); updateObj.updateType = 'delete'; updateObj.updateData = Object.create(null); if(fileDelObj.fileType === fileType.unitPriceFile){ updateObj.updateData.id = fileDelObj.id; } else if(fileDelObj.fileType === fileType.feeRateFile){ updateObj.updateData.ID = fileDelObj.id; } updateObj.fileType = fileDelObj.fileType; a_updateFiles([updateObj], function () { fileDelObj = null; $('#fileDelCancel').click(); setDataToSideBar(); //refresh front? }); } }); //绑定新建建设项目、新建单项工程、新建文件夹、重命名Enter键事件 bindInputs($('#project-name'), $('#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'); setTimeout(function () { $('#project-name')[0].focus(); }, 300); });*/ // 新增建设项目操作 $('#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 = ''; for(let i = targetData.length - 1; i >=0; i--){ let valuation = targetData[i]; if (valuation === null) { continue; } html += ``; } $("#valuation").html(html); //$("#tender-engineering").html(''); let engineeringList = getEngineeringList(); let engineeringHtml = getEngineeringHtml(engineeringList); $("#tender-engineering").html(engineeringHtml); changeEngineering(); }); //选择计价规则 $("#valuation").change(function () { let engineeringList = getEngineeringList(); console.log(engineeringList); let engineeringHtml = getEngineeringHtml(engineeringList); $("#tender-engineering").html(engineeringHtml); $('#valuation-info').hide(); changeEngineering(); }); //选择计税方式 $("#taxType").change(function () { $('#valuation-info').hide(); getStdCalcProgramFiles(); }); // 新增单项项目点击 /* $("#add-engineering-btn").click(function() { let selectedItem = projTreeObj.tree.selected; try { if(selectedItem !== null && selectedItem.data.projType !== projectType.folder){ $("#add-engineering-dialog").modal("show"); setTimeout(function () { $('#engineering-name')[0].focus(); }, 300); } } 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').keyup(function () { let pojName = $('#poj-name').val().trim(); let nameList = getNameList($('#poj-name-list').children()); let isExist = hasListName(nameList, pojName); if(!isExist){ if(pojName !== ''){ replaceClass($('#poj-name-info'), 'text-danger', 'text-info'); setDangerInfo($('#poj-name-info'), `新建“${pojName}”`); } else { $('#poj-name-info').hide(); } //清空单项工程下拉和文件下拉 setEngOptions(null); setFileOptions(null); } else { //触发选项 let curName = $(this).val().trim(); function getProjOpt(opts){ for(let opt of opts){ if($(opt).text().trim() === curName){ return $(opt); } } return null; } let matchOpt = getProjOpt($('#poj-name-list').find('a')); if(matchOpt){ matchOpt.click(); } $('#poj-name-info').hide(); } }); //新建单位工程-单项工程提示 $('#eng-name').keyup(function () { let engName = $('#eng-name').val().trim(); let nameList = getNameList($('#eng-name-list').children()); let isExist = hasListName(nameList, engName); if(!isExist && engName !== ''){ replaceClass($('#eng-name-info'), 'text-danger', 'text-info'); setDangerInfo($('#eng-name-info'), `新建“${engName}”`); } else { $('#eng-name-info').hide(); } }); //新建单位工程-单位工程提示 $('#tender-name').keyup(function () { let selected = projTreeObj.tree.selected; let pojName = $('#poj-name').val().trim(); let engName = $('#eng-name').val().trim(); let tenderName = $('#tender-name').val().trim(); let isExist = hasTender(selected, pojName, engName, tenderName); $('#unit-price').find('option:first-child').text(tenderName); $('#tender-fee-rate').find('option:first-child').text(tenderName); if(isExist){ if(tenderName !== '') setDangerInfo($('#tender-name-info'), `已存在“${tenderName}”`); } else { $('#tender-name-info').hide(); } }); //下拉是否含有输入的名字 function hasListName(nameList, name){ for(let i = 0, len = nameList.length; i < len; i++){ if(nameList[i] === name){ return true; } } return false; } function getNameList(list){ let rst = []; for(let i = 0, len = list.length; i < len; i++){ rst.push($(list[i]).text()); } return rst; } // 新增单位工程弹层改变 $('#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(); $('#unit-price').find('option:first-child').text('新建单价文件'); $('#tender-fee-rate').find('option:first-child').text('新建费率文件'); //获取建设项目 let selected = projTreeObj.tree.selected; let projs = getProjs(selected); setProjOptions(projs, selected); $($("input[name='valuation_type']")[0]).click(); setTimeout(function () { $('#tender-name')[0].focus(); }, 300); }); // 新增单位工程 $("#add-tender-confirm").click(function() { let suc = AddTender(); if(suc === false){ $('#add-tender-confirm').removeClass('disabled'); } }); // 新增文件夹按钮点击 /*$("#add-folder-btn").click(function() { $("#add-folder-dialog").modal("show"); setTimeout(function () { $('#folder-name')[0].focus(); }, 300); });*/ // 新增文件夹操作 $("#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-name').val(projTreeObj.tree.selected.data.name ? projTreeObj.tree.selected.data.name : ''); $('#rename-dialog').modal('show'); setTimeout(function () { $('#rename-name')[0].focus(); }, 300); });*/ // 重命名操作 $("#rename-confirm").click(function() { let select = projTreeObj.tree.selected; let parent = select ? select.parent : Tree._root; let newName = $('#rename-name').val().trim(); let dialog = $('#rename-dialog'); if (newName === '') { setDangerInfo($('#rename-name-info'), '请输入重命名'); return false; } if (newName === select.data.name) { dialog.modal('hide'); return false; } if(existName(newName, parent.children, select.data.projType)){ setDangerInfo($('#rename-name-info'), `已存在“${newName}”`); return; } 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,projectMap={}; if(toNode.data.projType == projectType.engineering){//复制为目标的子节点 parent = toNode; next = toNode.firstChild(); }else if(toNode.data.projType == projectType.tender){//复制为目标的后兄弟 parent = toNode.parent; next = toNode.nextSibling; projectMap['update'] = {query:{ID:toNode.id()}};//前一节点的下一个节点更新; } let nextID = next?next.id():-1; let projectData = _.cloneDeep(originalNode.data); projectData['ParentID'] = parent.id(); projectData['NextSiblingID'] = nextID; projectData['property'] ={}; projectData['property']['rootProjectID'] = parent.pid(); projectData['shareInfo'] = []; let rename = projTreeObj.projectNameChecking(parent,originalNode,"复制");//重名检查 rename? projectData['name'] = rename:''; projectMap['copy'] = {document:projectData}; $("#copy-to-dialog").modal('hide'); $.bootstrapLoading.start(); CommonAjax.post('/pm/api/copyProjects',{projectMap:projectMap,user_id: userID},function (result) { console.log(result); let newNode = projTreeObj.insert(result['copy'].document,parent,next); let refreshNodes = projTreeObj.calEngineeringCost(newNode); projTreeObj.refreshNodeData(refreshNodes); $.bootstrapLoading.end(); }) }); function changeEngineering(){ $('#engineering-info').hide(); initFeeStandardSel(); } function changeFeeRate(engLib) { if(engLib){ /* if (engLib.fee_lib !== undefined && engLib.fee_lib.length > 0) { $("#tender-fee-rate").children("option").first().val("newFeeRate-"+engLib.fee_lib[0].id); }*/ //2018-08-29 费率改为和计税方式绑定在一起 所以在这里还不能确定标准费率库ID $("#tender-fee-rate").children("option").first().val("newFeeRate@@"); $("#tender-engineering").parent().siblings('.hidden-area').slideDown('fast'); } else { $("#tender-fee-rate").children("option").first().val($('#tender-name').val()); } } function initFeeStandardSel() { $('#tender-feeStandard').empty(); let feeStandards = []; let engineeringList = getEngineeringList(); let currentEngName = $('#tender-engineering').val(); for(let eng of engineeringList){ if(eng.lib.name && eng.lib.name === currentEngName && eng.lib.feeName && eng.lib.feeName !== ''){ feeStandards.push(eng.lib.feeName); } } for(let feeName of feeStandards){ let $opt = $(``); $('#tender-feeStandard').append($opt); } if(feeStandards.length > 0){ if($('#feeStandard-info').is(':visible')){ $('#feeStandard-info').hide(); } } let currentEngLib = getEngineeringLib(currentEngName + $('#tender-feeStandard').val(), engineeringList); changeFeeRate(currentEngLib); setTaxGroupHtml(); getStdCalcProgramFiles(); } function changeFeeStandard() { let currentEngLib = getEngineeringLib($('#tender-engineering').val() + $('#tender-feeStandard').val(), getEngineeringList()); changeFeeRate(currentEngLib); setTaxGroupHtml(); getStdCalcProgramFiles(); } function setTaxGroupHtml() { let groups = getTaxGroupList(); let taxTypeArray = []; let htmlString = ""; if(groups && groups.length > 0){ taxTypeArray = _.uniq(_.map(groups,'taxType')); } for(let t of taxTypeArray){ htmlString += "" } $('#taxType').html(htmlString); if(taxTypeArray.length <2){ $('#taxType_div').hide(); }else { $('#taxType_div').show(); } console.log(taxTypeArray); } function getStdCalcProgramFiles(){ function getStdCPFilesHtml(taxGroups) { let result = ''; if (taxGroups.length <= 0) { return result; }; for (let group of taxGroups){ let groupString = ""; //把计算程序、清单模板、列设置的ID生成一个组合的值 let p_id = group.program_lib?group.program_lib.id:""; let t_id = group.template_lib?group.template_lib.id:""; let c_id = group.col_lib?group.col_lib.id:""; let f_id = group.fee_lib?group.fee_lib.id:""; groupString = p_id + "|-|" +t_id+"|-|"+c_id+"|-|"+f_id; result += ''; }; return result; }; let taxType = $("#taxType").val(); let stdCPHtml = getStdCPFilesHtml(getTaxGroupList(taxType)); $("#tender-calcProgram").html(stdCPHtml); if ($("#tender-calcProgram")[0].options.length > 1) $("#tender-calcProgram")[0].selectedIndex = 0; } // 选择工程专业后动态更改费率文件等数据 $("#tender-engineering").change(function() { changeEngineering() }); $('#tender-feeStandard').change(function () { changeFeeStandard(); }); }); //获取工作表总宽度 function getWorkBookWidth(){ return workBookWidth = $(window).width() - $('.pm-side').width() - 90; } /** * 初始化数据 * * @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) { CommonAjax.post('/options/getOptions', [], function (rstData) { projTreeObj.setting.style.selectedColor = rstData.COLOROPTS.SELECTED.backColor; projTreeObj.tree = pmTree.createNew(projTreeObj.setting, datas); projTreeObj.tree.selected = projTreeObj.tree.items[0]; projTreeObj.workBook = projTreeObj.buildSheet(projTreeObj.workBook,'projSpread',projTreeObj.setting); projTreeObj.workBook.getSheet(0).frozenColumnCount(2); sheetCommonObj.spreadDefaultStyle(projTreeObj.workBook); 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(); autoFlashHeight(); projTreeObj.workBook.refresh(); }); }); 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 setInitSummaryData(data) { if(data.projType === projectType.folder){ return; } //just for View data.engineeringCost = 0; data.subEngineering = 0; data.measure = 0; data.safetyConstruction = 0; data.other = 0; data.charge = 0; data.tax = 0; data.rate = data.projType === projectType.project ? 100 : 0; data.buildingArea = ''; data.perCost = ''; } function 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') { setInitSummaryData(data.updateData); if(data.updateData.projType === projectType.project){ projData = data.updateData; } else if(data.updateData.projType === projectType.engineering){ engData = data.updateData; } else if(data.updateData.projType === projectType.tender){ tenderData = data.updateData; } } }); 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') { setInitSummaryData(data.updateData); 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') { setInitSummaryData(data.updateData); 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') { setInitSummaryData(data.updateData); 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, type)){ //alert('同级目录已存在相同名称数据.'); existCallback(); } else { GetNewProjectId(1, function(IDs) { let typeInfo = { updateType: 'new', projectType: type }; let updateData = GetUpdateData(selected, parent, next, name, property, IDs.lowID, typeInfo); projTreeObj.tree.maxNodeId(IDs.lowID - 1); UpdateProjectData(updateData, function(datas){ datas.forEach(function (data) { if (data.updateType === 'new') { setInitSummaryData(data.updateData); projTreeObj.insert(data.updateData, parent, next); } }); sucCallback(); }); }); } } //根据工程专业名称+费用标准名称获取工程专业库 function getEngineeringLib(cascadeName, engineeringList) { for(let eng of engineeringList){ let engName = eng.lib.name ? eng.lib.name : ''; let engFeeName = eng.lib.feeName ? eng.lib.feeName : ''; if(cascadeName === engName + engFeeName){ return eng.lib; } } return null; } function getEngineeringList(){ let valuation = $("#valuation").val(); let valuationType = $("input[name='valuation_type']:checked").val(); let valuationData = valuationType === 'bill' ? JSON.parse(billValuation) : JSON.parse(rationValuation); let engineeringList = []; for(let tmp of valuationData) { if (tmp.id === valuation) { engineeringList = tmp.engineering_list; break; } } return engineeringList; } function getTaxGroupList(type){//getcalcProgramList let egrs = getEngineeringList(); let groupList = []; //let egrID = $("#tender-engineering").val(); let engLib = getEngineeringLib($('#tender-engineering').val() + $('#tender-feeStandard').val(), egrs); if(engLib){ if(type){//是否要过滤,如果这个参数不传,则返回整个数组; for(let group of engLib.tax_group){ if(group.taxType == type && group.program_lib){ groupList.push(group); } } }else { groupList = engLib.tax_group; } } /*for(let egr of egrs) { if (egr.engineering_id == egrID && egr.lib) { if(type){//是否要过滤,如果这个参数不传,则返回整个数组; for(let group of egr.lib.tax_group){ if(group.taxType == type && group.program_lib){ groupList.push(group); } } }else { groupList = egr.lib.tax_group; } } }*/ return groupList; } function getNodeByName(name, nodes){ for(let i = 0, len = nodes.length; i < len; i++){ if(name === nodes[i].data.name){ return nodes[i]; } } return null; } //同级是否重名,文件夹与建设项目可以同名 function existName(name , nodes, projType = null){ for(let i = 0, len = nodes.length; i < len; i++){ if(name === nodes[i].data.name){ if(projType && projType === projectType.folder && nodes[i].data.projType === projectType.project){ continue; } return true; } } return false; } //获取新建单位工程时的建设项目数据 function getProjs(selected){ let rst = []; let temp; let firstNode; if(!selected){ temp = projTreeObj.tree._root; firstNode = temp.children[0]; } else if(selected.data.projType === projectType.folder){ temp = selected; firstNode = temp.children[0]; } else if(selected.data.projType === projectType.project){ temp = selected.parent; firstNode = temp.children[0]; } else if(selected.data.projType === projectType.engineering || selected.data.projType === projectType.tender){ let proj = selected.parent.data.projType === projectType.project ? selected.parent : selected.parent.parent; temp = proj.parent; firstNode = proj; } for(let childNode of temp.children){ if(childNode.data.projType === projectType.project){ rst.push(childNode); } } if(firstNode){ //firstNode to first place let index = null; for(let i = 0, len = rst.length; i < len; i++){ if(rst[i].data.ID === firstNode.data.ID){ index = i; break; } } if(index){ rst.splice(index, 1); rst.splice(0, 0, firstNode); } } return rst; } function setFileOptions(projID){ // 获取单价文件数据 if(!projID){ $("#unit-price").children("option:not(':first')").remove(); let first = $("#tender-fee-rate").children("option").first(); $("#tender-fee-rate").empty(); $("#tender-fee-rate").append(first); } else { getUnitFile(projID, function (response) { $("#unit-price").children("option:not(':first')").remove(); if (response.data.length <= 0) { return false; } let unitFileHtml = ''; for(let tmp of response.data) { unitFileHtml += ''; } $("#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 = $("