'use strict'; /** * 台账修订页面js * * @author Mai * @date * @version */ const ckBillsSpread = window.location.pathname + '-billsSelect'; const invalidFields = { parent: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'deal_qty', 'deal_tp', 'unit_price'], gcl: ['dgn_qty1', 'dgn_qty2'], posCode: ['b_code'], posCalc: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp'], posXmj: ['code'], }; function getExprInfo (field) { const exprField = [ {qty: 'sgfh_qty', expr: 'sgfh_expr'}, {qty: 'sjcl_qty', expr: 'sjcl_expr'}, {qty: 'qtcl_qty', expr: 'qtcl_expr'}, ]; return _.find(exprField, {qty: field}); } function transExpr(expr) { return $.trim(expr).replace('\t', '').replace('=', '').replace('%', '/100'); } const copyBlockTag = 'zh.calc.copyBlock'; const checkOption = { sibling: { enable: 1 }, empty_code: { enable: 1 }, calc: { enable: 1, fields: ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity'], }, zero: { enable: 1 }, zeroPos: { enable: 1 }, tp: { enable: 1, fields: [ {qty: 'sgfh_qty', tp: 'sgfh_tp'}, {qty: 'sjcl_qty', tp: 'sjcl_tp'}, {qty: 'qtcl_qty', tp: 'qtcl_tp'}, {qty: 'quantity', tp: 'total_price'}, {qty: 'deal_qty', tp: 'deal_tp'}, ], }, }; $(document).ready(() => { let stdXmj, stdGcl, searchLedger; autoFlashHeight(); // 初始化spread const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]); const billsSheet = billsSpread.getActiveSheet(); sjsSettingObj.setFxTreeStyle(billsSpreadSetting, sjsSettingObj.FxTreeStyle.jz); if (thousandth) sjsSettingObj.setTpThousandthFormat(billsSpreadSetting); SpreadJsObj.initSheet(billsSheet, billsSpreadSetting); const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]); const posSheet = posSpread.getActiveSheet(); sjsSettingObj.setGridSelectStyle(posSpreadSetting); if (thousandth) sjsSettingObj.setTpThousandthFormat(posSpreadSetting); SpreadJsObj.initSheet(posSheet, posSpreadSetting); const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread}); const errorList = $.cs_errorList({ tabSelector: '#error-list-tab', selector: '#error-list', relaSpread: billsSpread, storeKey: 'revise-error-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4], afterLocated: function () { posSpreadObj.loadCurPosData(); }, afterShow: function () { billsSpread.refresh(); if (posSpread) posSpread.refresh(); }, }); const checkList = $.ledger_checkList({ id: 'check-list', tabSelector: '#check-list-tab', selector: '#check-list', relaSpread: billsSpread, storeKey: 'revise-check-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4], checkType: getCheckType(checkOption), afterLocated: function () { posSpreadObj.loadCurPosData(); }, afterShow: function () { billsSpread.refresh(); if (posSpread) posSpread.refresh(); }, }); const sumLoadMiss = $.sumLoadMiss({ tabSelector: '#sum-load-miss-tab', selector: '#sum-load-miss', relaSpread: billsSpread, storeKey: 'revise-slm-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4], id: 'revise-slm', afterLocated: function () { posSpreadObj.loadCurPosData(); }, afterShow: function () { billsSpread.refresh(); if (posSpread) posSpread.refresh(); }, }); // 初始化 节点树结构 const treeSetting = { id: 'ledger_id', pid: 'ledger_pid', order: 'order', level: 'level', rootId: -1, keys: ['id', 'tender_id', 'ledger_id'], calcFields: ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'], autoExpand: 3, }; if (!isTz) { treeSetting.calcFields.push('deal_tp'); } treeSetting.calcFun = function (node) { node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2); }; const billsTree = createNewPathTree('revise', treeSetting); // 初始化 计量单元 const pos = new PosData({ id: 'id', ledgerId: 'lid' }); // 清单 相关方法&绑定spreadjs事件 const billsTreeSpreadObj = { loadExprToInput(sheet) { const sel = sheet.getSelections()[0]; const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col); if (col && col.type === 'Number') { const data = SpreadJsObj.getSelectObject(sheet); if (data) { const exprInfo = getExprInfo(col.field); if (exprInfo) { $('#bills-expr').val(data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field]) .attr('field', col.field).attr('org', data[col.field]); } else { $('#bills-expr').val(data[col.field]).attr('field', col.field).attr('org', data[col.field]); } if (col.field.indexOf('dgn') >= 0) { $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (_.isString(data.b_code) && data.b_code !== '')); } else if (col.field === 'unit_price') { $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0) || (_.isBoolean(data.used) && data.used === true)); } else { const nodePos = pos.getLedgerPos(data.id); if (nodePos && nodePos.length > 0) { $('#bills-expr').val('').attr('readOnly', true); $('#bills-expr').removeAttr('data-row'); } else { $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0)); } } $('#bills-expr').attr('data-row', sel.row); } else { $('#bills-expr').val('').attr('readOnly', true); $('#bills-expr').removeAttr('data-row'); } } else { $('#bills-expr').val('').attr('readOnly', true); $('#bills-expr').removeAttr('data-row'); } }, getDefaultSelectInfo: function (sheet) { const tree = sheet.zh_tree; if (!tree) return; const sel = sheet.getSelections()[0]; const node = sheet.zh_tree.nodes[sel.row]; if (!node) return; let count = 1; if (sel.rowCount > 1) { for (let r = 1; r < sel.rowCount; r++) { const rNode = sheet.zh_tree.nodes[sel.row + r]; if (rNode.level > node.level) continue; if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) { toastr.warning('请选择同一节点下的节点，进行该操作'); return; } count += 1; } } return [tree, node, count]; }, /** * 刷新顶部按钮是否可用 * @param sheet * @param selections */ refreshOperationValid: function (sheet, selection) { const setObjEnable = function (obj, enable) { if (enable) { obj.removeClass('disabled'); } else { obj.addClass('disabled'); } }; const invalidAll = function () { setObjEnable($('a[name=base-opr][type=add]'), false); setObjEnable($('a[name=base-opr][type=delete]'), false); setObjEnable($('a[name=base-opr][type=up-move]'), false); setObjEnable($('a[name=base-opr][type=down-move]'), false); setObjEnable($('a[name=base-opr][type=up-level]'), false); setObjEnable($('a[name=base-opr][type=down-level]'), false); }; const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const tree = sheet.zh_tree; if (!tree) { invalidAll(); return; } const first = sheet.zh_tree.nodes[row]; if (!first) { invalidAll(); return; } let last = first, sameParent = true, nodeUsed = first.used; if (sel.rowCount > 1 && first) { for (let r = 1; r < sel.rowCount; r++) { const rNode = tree.nodes[sel.row + r]; if (!rNode) { sameParent = false; break; } nodeUsed = nodeUsed || rNode.used; if (rNode.level > first.level) continue; if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) { sameParent = false; break; } last = rNode; } } const preNode = tree.getPreSiblingNode(first); const valid = !sheet.zh_setting.readOnly; setObjEnable($('a[name=base-opr][type=add]'), valid && first && first.level > 1); setObjEnable($('a[name=base-opr][type=delete]'), valid && first && sameParent && first.level > 1 && !nodeUsed); setObjEnable($('a[name=base-opr][type=up-move]'), valid && first && sameParent && first.level > 1 && preNode); setObjEnable($('a[name=base-opr][type=down-move]'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last)); const posRange = last ? pos.getLedgerPos(last.id) : []; setObjEnable($('a[name=base-opr][type=up-level]'), valid && first && sameParent && tree.getParent(first) && !nodeUsed && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last))); const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : []; setObjEnable($('a[name=base-opr][type=down-level]'), valid && first && sameParent && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0) && !preNode.used); setObjEnable($('#cut'), valid); setObjEnable($('#paste'), valid); }, /** * * @param sheet * @param data */ refreshTree: function (sheet, data) { SpreadJsObj.massOperationSheet(sheet, function () { const tree = sheet.zh_tree; // 处理删除 if (data.delete) { data.delete.sort(function (a, b) { return b.deleteIndex - a.deleteIndex; }); for (const d of data.delete) { sheet.deleteRows(d.deleteIndex, 1); } } // 处理新增 if (data.create) { const newNodes = data.create; if (newNodes) { newNodes.sort(function (a, b) { return a.index - b.index; }); for (const node of newNodes) { sheet.addRows(node.index, 1); SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1); } } } // 处理更新 if (data.update) { const rows = []; for (const u of data.update) { rows.push(tree.nodes.indexOf(u)); } SpreadJsObj.reLoadRowsData(sheet, rows); } // 处理展开 if (data.expand) { const expanded = []; for (const e of data.expand) { if (expanded.indexOf(e) === -1) { const posterity = tree.getPosterity(e); for (const p of posterity) { sheet.setRowVisible(tree.nodes.indexOf(p), p.visible); expanded.push(p); } } } } }); }, selectionChanged: function (e, info) { if (info.newSelections) { if (!info.oldSelections || info.newSelections[0].row !== info.oldSelections[0].row) { billsTreeSpreadObj.refreshOperationValid(info.sheet); SpreadJsObj.resetTopAndSelect(posSheet); posSpreadObj.loadCurPosData(); SpreadJsObj.saveTopAndSelect(billsSheet, ckBillsSpread); posSearch.search($('#pos-keyword').val()); } } billsTreeSpreadObj.loadExprToInput(info.sheet); }, /** * 新增节点 * @param spread */ baseOpr: function (sheet, type, addCount = 1) { const self = this; const [tree, node, count] = this.getDefaultSelectInfo(sheet); if (!tree || !node || !count) return; if (type === 'delete') { const parent = tree.getParent(node); const children = parent ? parent.children : tree.children; const index = children.indexOf(node); for (let i = 0; i < count; i++) { const child = children[i+index]; if (tree.checkNodeUsed(child, pos)) { toastr.warning('选中的节点已计量，不可删除'); return; } } } else if (type === 'up-level') { const parent = tree.getParent(node); const children = parent ? parent.children : tree.children; const index = children.indexOf(node); for (let i = index; i < children.length; i++) { const child = children[index]; if (tree.checkNodeUsed(child, pos)) { if (i >= index + count) { toastr.warning('其后节点已计量，选中的节点不可升级'); } else { toastr.warning('选中的节点已计量，不可升级'); } return; } } } else if (type === 'down-level') { const parent = tree.getParent(node); const children = parent ? parent.children : tree.children; const index = children.indexOf(node); for (let i = 0; i < count; i++) { const child = children[i+index]; if (tree.checkNodeUsed(child, pos)) { toastr.warning('选中的节点已计量，不可降级'); return; } } } if (type === 'delete') { deleteAfterHint(function () { postData(window.location.pathname + '/update', { postType: type, postData: { id: node.ledger_id, count: type === 'add' ? addCount : count, } }, function (result) { const refreshData = tree.loadPostData(result); self.refreshTree(sheet, refreshData); const sel = sheet.getSelections()[0]; if (sel) { sheet.setSelection(sel.row, sel.col, 1, sel.colCount); } self.refreshOperationValid(sheet); }); }); } else { postData(window.location.pathname + '/update', { postType: type, postData: { id: node.ledger_id, count: type === 'add' ? addCount : count, } }, function (result) { const refreshData = tree.loadPostData(result); self.refreshTree(sheet, refreshData); if (['up-move', 'down-move'].indexOf(type) > -1) { const sel = sheet.getSelections()[0]; if (sel) { sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]); } } else if (type === 'add') { const sel = sheet.getSelections()[0]; if (sel) { sheet.setSelection(tree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(refreshData.create[0])]); } } self.refreshOperationValid(sheet); }); } }, /** * 编辑单元格响应事件 * @param {Object} e * @param {Object} info */ editEnded: function (e, info) { if (info.sheet.zh_setting) { const col = info.sheet.zh_setting.cols[info.col]; const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data; const node = sortData[info.row]; const data = { id: node.id, tender_id: node.tender_id, ledger_id: node.ledger_id }; // 未改变值则不提交 const orgValue = node[col.field]; const newValue = trimInvalidChar(info.editingText); if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) { return; } // 台账模式，检查计量单元相关 if (isTz) { if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' || col.field === 'sjcl_qty' || col.field === 'sjcl_tp' || col.field === 'qtcl_qty' || col.field === 'qtcl_tp') { if (!node.children || node.children.length ===0) { const lPos = pos.getLedgerPos(node.id); if (lPos && lPos.length > 0) { toastr.error('清单含有计量单元，不可修改施工图复核数量'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } if (col.field === 'b_code' && (newValue === '' || !newValue)) { const lPos = pos.getLedgerPos(node.id); if (lPos && lPos.length > 0) { toastr.error('清单含有计量单元，请先删除计量单元，再删除清单编号'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } // 获取更新数据 const exprInfo = getExprInfo(col.field); if (info.editingText) { const text = newValue; if (node.used && (col.field === 'code' || col.field ==='b_code') && orgValue !== '' && text === '') { toastr.error('节点已计量，请勿删除编号'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (col.type === 'Number') { const num = _.toNumber(text); if (_.isFinite(num)) { data[col.field] = num; if (exprInfo) { data[exprInfo.expr] = ''; } } else { try { data[col.field] = math.evaluate(transExpr(text)); if (exprInfo) { data[exprInfo.expr] = newValue; } } catch(err) { toastr.error('输入的表达式非法'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } else { data[col.field] = text; } } else { if (node.used && (col.field === 'code' || col.field ==='b_code') && orgValue !== '') { toastr.error('节点已计量，请勿删除编号'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } data[col.field] = null; if (exprInfo) { data[exprInfo.expr] = ''; } } // 更新至服务器 postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) { const refreshNode = billsTree.loadPostData(result); billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); }); } }, clipboardPasting: function (e, info) { const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting; info.cancel = true; if (!setting || !tree) return; // const range = info.cellRange; // for (let iRow = range.row; iRow < range.row + range.rowCount; iRow++) { // const node = tree.nodes[iRow]; // if (tree.checkNodeUsed(node, pos)) { // toastr.warning('"' + node.code + node.b_code + ' ' + node.name +'"已计量，请勿修改'); // return; // } // } const pasteData = info.pasteData.html ? SpreadJsObj.analysisPasteHtml(info.pasteData.html) : (info.pasteData.text === '' ? SpreadJsObj.Clipboard.getAnalysisPasteText() : SpreadJsObj.analysisPasteText(info.pasteData.text)); const hint = { usedUp: {type: 'warning', msg: '节点已计量，不可修改单价'}, usedCode: {type: 'warning', msg: '节点已计量，编号不可修改为空值'}, invalidExpr: {type: 'warning', msg: '粘贴的表达式非法'}, posCode: {type: 'warning', msg: '清单含有计量单元，不可粘贴清单编号为空'}, posQty: {type: 'warning', msg: '清单含有计量单元，数量金额根据计量单元汇总计算所得，不可粘贴'}, parent: {type: 'warning', msg: '含有子项的清单，不可粘贴数量、单价、金额'}, gcl: {type: 'warning', msg: '工程量清单，不可粘贴项目节数量'}, posXmj: {type: 'warning', msg: '清单含有计量单元，不可粘贴项目节编号'}, sameParent: {type: 'warning', msg: '仅可粘贴同层节点'}, }; const datas = [], filterNodes = []; let pid, level, filterRow = 0; for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) { const curRow = info.cellRange.row + iRow; const node = tree.nodes[curRow]; if (!node) continue; if (!pid) pid = node.ledger_pid; if (!level) level = node.level; if (node.ledger_pid !== pid) { toastMessageUniq(hint.sameParent); filterRow+=1; continue; } if (node.level < level) break; let bPaste = false; const data = info.sheet.zh_tree.getNodeKeyData(node); for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) { const curCol = info.cellRange.col + iCol; const colSetting = info.sheet.zh_setting.cols[curCol]; const value = trimInvalidChar(pasteData[iRow-filterRow][iCol]); if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) { toastMessageUniq(hint.parent); continue; } if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) { toastMessageUniq(hint.gcl); continue; } const lPos = pos.getLedgerPos(node.id); if (lPos && lPos.length > 0) { if (value === '' && colSetting.field === 'b_code') { toastMessageUniq(hint.posCode); continue; } if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' || colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' || colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') { toastMessageUniq(hint.posQty); continue; } if (value !== '' && invalidFields.posXmj.indexOf(colSetting.field) >= 0) { toastMessageUniq(hint.posXmj); continue; } } if (tree.checkNodeUsed(node, pos) && colSetting.field === 'unit_price') { toastMessageUniq (hint.usedUp); continue; } if (colSetting.type === 'Number') { const num = _.toNumber(value); if (num) { data[colSetting.field] = num; } else { try { data[colSetting.field] = math.evaluate(transExpr(value)); const exprInfo = getExprInfo(colSetting.field); if (exprInfo) { data[exprInfo.expr] = value; } bPaste = true; } catch (err) { toastMessageUniq(hint.invalidExpr); continue; } } } else { if (node.used && (colSetting.field === 'code' || colSetting.field ==='b_code') && data[colSetting.field] !== '' && value === '') { toastMessageUniq(hint.usedCode); continue; } data[colSetting.field] = value; } bPaste = true; } if (bPaste) { datas.push(data); } else { filterNodes.push(node); } } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { const refreshNode = tree.loadPostData(result); if (refreshNode.update) { refreshNode.update = refreshNode.update.concat(filterNodes); } billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); }); } else { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); } }, clipboardPasted: function (e, info) { const hint = { usedUp: {type: 'error', msg: '节点已计量，不可修改单价'}, usedCode: {type: 'error', msg: '节点已计量，编号不可修改为空值'}, invalidExpr: {type: 'error', msg: '粘贴的表达式非法'}, posCode: {type: 'error', msg: '清单含有计量单元，请先删除计量单元，再修改清单编号为空'}, posQty: {type: 'error', msg: '清单含有计量单元，数量金额根据计量单元汇总计算所得，不可修改'}, }; const tree = info.sheet.zh_tree; if (!tree) { return; } const sortData = info.sheet.zh_tree.nodes; const datas = [], filterNodes = []; for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) { let bPaste = false; const curRow = info.cellRange.row + iRow; const node = sortData[curRow]; if (node) { const data = info.sheet.zh_tree.getNodeKeyData(node); for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) { const curCol = info.cellRange.col + iCol; const colSetting = info.sheet.zh_setting.cols[curCol]; const value = trimInvalidChar(info.sheet.getText(curRow, curCol)); const lPos = pos.getLedgerPos(node.id); if (lPos && lPos.length > 0) { if (value === '' && colSetting.field === 'b_code') { toastMessageUniq(hint.posCode); continue; } if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' || colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' || colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') { toastMessageUniq(hint.posQty); continue; } } if (node.used && col.field === 'unit_price') { toastMessageUniq (hint.usedUp); continue; } if (colSetting.type === 'Number') { const num = _.toNumber(value); if (num) { data[colSetting.field] = num; } else { try { data[colSetting.field] = math.evaluate(transExpr(value)); } catch (err) { toastMessageUniq(hint.invalidExpr); continue; } } } else { if (node.used && (col.field === 'code' || col.field ==='b_code') && data[colSetting.field] !== '' && value === '') { toastMessageUniq(hint.usedCode); continue; } data[colSetting.field] = value; } bPaste = true; } if (bPaste) { datas.push(data); } else { filterNodes.push(node); } } } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { const refreshNode = tree.loadPostData(result); if (refreshNode.update) { refreshNode.update = refreshNode.update.concat(filterNodes); } billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); }); } else { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); } }, deletePress: function (sheet) { if (!sheet.zh_setting) return; const sel = sheet.getSelections()[0], datas = []; for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) { let bDel = false; const node = sheet.zh_tree.nodes[iRow]; const data = sheet.zh_tree.getNodeKeyData(node); for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) { const col = sheet.zh_setting.cols[iCol]; const style = sheet.getStyle(iRow, iCol); if (style.locked || (['dgn_qty1', 'dgn_qty2'].indexOf(col.field) >= 0 && node.b_code)) continue; if (['dgn_qty1', 'dgn_qty2'].indexOf(col.field) < 0 && sheet.zh_tree.checkNodeUsed(node, pos)) { toastr.warning('"' + (node.code || '') + (node.b_code || '') + ' ' + node.name +'"已计量，请勿修改'); return; } data[col.field] = null; const exprInfo = getExprInfo(col.field); if (exprInfo) { data[exprInfo.expr] = ''; } bDel = true; } if (bDel) datas.push(data); } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { const refreshNode = sheet.zh_tree.loadPostData(result); billsTreeSpreadObj.refreshTree(sheet, refreshNode); billsTreeSpreadObj.loadExprToInput(sheet); }); } }, pasteBlock: function (spread, copyInfo) { const self = this; const sheet = spread.getActiveSheet(); const [tree, node] = this.getDefaultSelectInfo(spread.getActiveSheet()); postData(window.location.pathname + '/update', { postType: 'paste-block', postData: { id: tree.getNodeKey(node), tid: copyInfo.tid, block: copyInfo.block, } }, function (data) { pos.updateDatas(data.pos); const result = tree.loadPostData(data.ledger); self.refreshTree(sheet, result); const sel = sheet.getSelections()[0]; if (sel) { sheet.setSelection(tree.nodes.indexOf(result.create[0]), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(result.create[0])]); } self.refreshOperationValid(sheet); removeLocalCache(copyBlockTag); }, null, true); }, topRowChanged: function (e, info) { SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread); }, editStarting(e, info) { if (!info.sheet.zh_setting || !info.sheet.zh_tree) return; const col = info.sheet.zh_setting.cols[info.col]; const node = info.sheet.zh_tree.nodes[info.row]; if (!node) { info.cancel = true; return; } const exprInfo = getExprInfo(col.field); if (exprInfo) { if (node[exprInfo.expr] && node[exprInfo.expr] !== '') { info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]); } } switch (col.field) { case 'code': const posRange = pos.getLedgerPos(node.id); info.cancel = posRange && posRange.length > 0; break; case 'unit_price': info.cancel = (node.children && node.children.length > 0) || node.used; break; case 'sgfh_qty': case 'sgfh_tp': case 'sjcl_qty': case 'sjcl_tp': case 'qtcl_qty': case 'qtcl_tp': case 'deal_qty': case 'deal_tp': info.cancel = (node.children && node.children.length > 0); break; case 'dgn_qty1': case 'dgn_qty2': info.cancel = !_.isEmpty(node.b_code); break; } }, cut: function (sheet, sel, callback) { if (!sheet || !sel) return; if (sel.colCount >= sheet.zh_setting.cols.length) { toastr.warning('请勿选中整行剪切'); return; } const sortData = SpreadJsObj.getSortData(sheet), datas = []; for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) { const node = sortData[iRow]; if (node) { const data = sheet.zh_tree.getNodeKeyData(node); for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) { const col = sheet.zh_setting.cols[iCol]; if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' || col.field === 'sjcl_qty' || col.field === 'sjcl_tp' || col.field === 'qtcl_qty' || col.field === 'qtcl_tp') { const lPos = pos.getLedgerPos(node.id); if (lPos && lPos.length > 0) { toastr.error('不可剪切'); return; } } const style = sheet.getStyle(iRow, iCol); if (style.locked) { toastr.error('不可剪切'); return; } const colSetting = sheet.zh_setting.cols[iCol]; data[colSetting.field] = null; const exprInfo = getExprInfo(colSetting.field); if (exprInfo) { data[exprInfo.expr] = ''; } } datas.push(data); } } if (datas.length > 0) { callback(); postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { const refreshNode = sheet.zh_tree.loadPostData(result); billsTreeSpreadObj.refreshTree(sheet, refreshNode); }); } }, sortCode: function (sheet) { const tree = sheet.zh_tree; if (!tree) return; const select = SpreadJsObj.getSelectObject(sheet); if (!select || !select.code || select.code === '') return; const recursiveSortCode = function (data, parentCode, children) { if (!children || children.length === 0) return; for (const [i, child] of children.entries()) { if (!child.b_code || child.b_code === '') { const code = parentCode + '-' + (i + 1); const cData = tree.getNodeKeyData(child); cData.code = code; data.push(cData); if (!tree.isLeafXmj(child)) { recursiveSortCode(data, code, child.children); } } } }; const data = []; recursiveSortCode(data, select.code, select.children); if (data.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) { const refreshNode = tree.loadPostData(result); billsTreeSpreadObj.refreshTree(sheet, refreshNode); }) } } }; billsTreeSpreadObj.refreshOperationValid(billsSheet); billsTreeSpreadObj.loadExprToInput(billsSheet); billsSpread.bind(spreadNS.Events.SelectionChanged, billsTreeSpreadObj.selectionChanged); billsSpread.bind(spreadNS.Events.topRowChanged, billsTreeSpreadObj.topRowChanged); if (!readOnly) { // 增删上下移升降级 $('a[name="base-opr"]').click(function () { billsTreeSpreadObj.baseOpr(billsSheet, this.getAttribute('type')); }); $('a[name=cpc]').click(function () { billsSpread.commandManager().execute({ cmd: this.getAttribute('type'), sheetName: billsSheet.name() }); }); $('#bills-expr').bind('change onblur', function () { if (this.readOnly) return; const expr = $(this); const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1; const select = billsTree.getItemsByIndex(row); if (!select) return; const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val()); if (orgValue === newValue || (!orgValue && newValue == '')) { return; } const data = { id: select.id, tender_id: select.tender_id, ledger_id: select.ledger_id }; const exprInfo = getExprInfo(field); if (newValue !== '') { const num = _.toNumber(newValue); if (num) { data[field] = num; if (exprInfo) { data[exprInfo.expr] = ''; } } else { try { data[field] = math.evaluate(transExpr(newValue)); if (exprInfo) { data[exprInfo.expr] = newValue; } } catch (err) { toastr.error('输入的表达式非法'); return; } } } else { data[field] = null; if (exprInfo) { data[exprInfo.expr] = ''; } } // 更新至服务器 postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) { const refreshNode = billsTree.loadPostData(result); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); }); }); billsSpread.bind(spreadNS.Events.EditStarting, billsTreeSpreadObj.editStarting); billsSpread.bind(spreadNS.Events.EditEnded, billsTreeSpreadObj.editEnded); billsSpread.bind(spreadNS.Events.ClipboardPasting, billsTreeSpreadObj.clipboardPasting); billsSpread.bind(spreadNS.Events.ClipboardChanging, function (e, info) { const copyText = SpreadJsObj.getFilterCopyText(info.sheet); SpreadJsObj.Clipboard.setCopyData(copyText); }); SpreadJsObj.addDeleteBind(billsSpread, billsTreeSpreadObj.deletePress); SpreadJsObj.addCutEvents(billsSpread, billsTreeSpreadObj.cut); } // 右键菜单 let batchInsertObj; $.contextMenu.types.batchInsert = function (item, opt, root) { const self = this; if ($.isFunction(item.icon)) { item._icon = item.icon.call(this, this, $t, key, item); } else { if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') { // to enable font awesome item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon; } else { item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon; } } this.addClass(item._icon); const $obj = $('
' + item.name + '行
') .appendTo(this); const $input = $obj.find('input'); const event = () => { if (self.hasClass('context-menu-disabled')) return; item.batchInsert($input[0], root); }; $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }}); $input.click((e) => {e.stopPropagation();}) .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);}) .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');}); }; const billsContextMenuOptions = { selector: '#bills-spread', build: function ($trigger, e) { const target = SpreadJsObj.safeRightClickSelection($trigger, e, billsSpread); return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader; }, items: {} }; if (!readOnly) { billsContextMenuOptions.items.create = { name: '新增', icon: 'fa-sign-in', callback: function (key, opt) { billsTreeSpreadObj.baseOpr(billsSheet, 'add'); }, disabled: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const tree = sheet.zh_tree; if (!tree) return true; const first = sheet.zh_tree.nodes[row]; const valid = !sheet.zh_setting.readOnly; return !(valid && first && first.level > 1); } }; billsContextMenuOptions.items.delete = { name: '删除', icon: 'fa-remove', callback: function (key, opt) { billsTreeSpreadObj.baseOpr(billsSheet, 'delete'); }, disabled: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const tree = sheet.zh_tree; if (!tree) return true; const first = sheet.zh_tree.nodes[row]; let last = first, sameParent = true, nodeUsed = first.used; if (sel.rowCount > 1 && first) { for (let r = 1; r < sel.rowCount; r++) { const rNode = tree.nodes[sel.row + r]; if (!rNode) { sameParent = false; break; } nodeUsed = nodeUsed || rNode.used; if (rNode.level > first.level) continue; if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) { sameParent = false; break; } last = rNode; } } const valid = !sheet.zh_setting.readOnly; return !(valid && first && sameParent && !(first.level === 1 && first.node_type) && !nodeUsed); } }; billsContextMenuOptions.items.sprBase = '----'; } billsContextMenuOptions.items.copyBlock = { name: '复制整块', icon: 'fa-files-o', callback: function (key, opt) { const copyBlockList = []; const sheet = billsSheet; const sel = sheet.getSelections()[0]; let iRow = sel.row; const pid = sheet.zh_tree.nodes[iRow].ledger_pid; while (iRow < sel.row + sel.rowCount) { const node = sheet.zh_tree.nodes[iRow]; if (node.ledger_pid !== pid) { toastr.error('仅可同时选中同层节点'); return; } const posterity = sheet.zh_tree.getPosterity(node); iRow += posterity.length + 1; posterity.unshift(node); copyBlockList.push(sheet.zh_tree.getDefaultData(posterity)); } for (const cbl of copyBlockList) { for (const b of cbl) { const posRange = pos.getLedgerPos(b.id); if (posRange && posRange.length > 0) b.pos = posRange; } } setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList })); }, visible: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const row = selection[0].row; const select = billsTree.nodes[row]; return select; }, disabled: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const row = selection[0].row; const select = billsTree.nodes[row]; return select && select.level <= 1; } }; billsContextMenuOptions.items.copyBlockXmj = { name: '复制整块（只复制项目节）', icon: 'fa-files-o', callback: function (key, opt) { const copyBlockList = []; const sheet = billsSheet; const sel = sheet.getSelections()[0]; let iRow = sel.row; const pid = sheet.zh_tree.nodes[iRow].ledger_pid; while (iRow < sel.row + sel.rowCount) { const node = sheet.zh_tree.nodes[iRow]; if (node.ledger_pid !== pid) { toastr.error('仅可同时选中同层节点'); return; } const posterity = sheet.zh_tree.getPosterity(node); iRow += posterity.length + 1; const copyPosterity = posterity.filter(x => { return !x.b_code; }); copyPosterity.unshift(node); const copyData = sheet.zh_tree.getDefaultData(copyPosterity); for (const p of copyData) { const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || []; p.is_leaf = children.length === 0; } copyBlockList.push(copyData); } setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList })); }, visible: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const row = selection[0].row; const select = billsTree.nodes[row]; return select; }, disabled: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const row = selection[0].row; const select = billsTree.nodes[row]; return select && select.level <= 1; } }; if (!readOnly) { billsContextMenuOptions.items.pasteBlock = { name: '粘贴整块', icon: 'fa-clipboard', disabled: function (key, opt) { //const block = treeOperationObj.block || []; const copyInfo = JSON.parse(getLocalCache(copyBlockTag)); return !(copyInfo && copyInfo.block && copyInfo.block.length > 0); }, callback: function (key, opt) { //const block = treeOperationObj.block || []; const copyInfo = JSON.parse(getLocalCache(copyBlockTag)); if (copyInfo.block.length > 0) { billsTreeSpreadObj.pasteBlock(billsSpread, copyInfo); } else { document.execCommand('paste'); } }, visible: function (key, opt) { return !readOnly; } }; billsContextMenuOptions.items.sprBlock = '----'; } if (!readOnly) { billsContextMenuOptions.items.batchInsert = { name: '批量插入', type: 'batchInsert', value: '2', icon: 'fa-sign-in', batchInsert: function (obj, root) { if (_.toNumber(obj.value) > _.toNumber(obj.max)) { obj.value = obj.max; toastr.warning('批量插入不可多于' + obj.max); } else if (_.toNumber(obj.value) < _.toNumber(obj.min)) { obj.value = obj.min; toastr.warning('批量插入不可少于' + obj.min); } else { billsTreeSpreadObj.baseOpr(billsSheet, 'add', parseInt(obj.value)); root.$menu.trigger('contextmenu:hide'); } }, disabled: function (key, opt) { const sheet = billsSheet; const selection = sheet.getSelections(); const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const tree = sheet.zh_tree; if (!tree) return true; const first = sheet.zh_tree.nodes[row]; const valid = !sheet.zh_setting.readOnly; return !(valid && first && first.level > 1); } }; billsContextMenuOptions.items.batchInsertBillsPos = { name: '批量插入清单-计量单元', icon: 'fa-sign-in', disabled: function (key, opt) { if (!isTz) return true; const select = SpreadJsObj.getSelectObject(billsSheet); if (select) { if (select.code && select.code !== '') { return !billsTree.isLeafXmj(select); } else { const parent = billsTree.getParent(select); return !(parent && billsTree.isLeafXmj(parent)); } } else { return false; } }, callback: function (key, opt) { if (!batchInsertObj) { batchInsertObj = new BatchInsertBillsPosObj($('#batch')); } else { batchInsertObj.initView(); } $('#batch').modal('show'); } }; billsContextMenuOptions.items.sprBatch = '----'; billsContextMenuOptions.items.importGclBills2Xmj = { name: '导入工程量清单至项目节', icon: 'fa-file-excel-o', disabled: function (key, opt) { const node = SpreadJsObj.getSelectObject(billsSheet); return readOnly || (node.children && node.children.length > 0) || (!_.isNil(node.b_code) && node.b_code !== '') || billsTree.checkNodeUsed(node, pos); }, callback: function (key, opt) { const node = SpreadJsObj.getSelectObject(billsSheet); importExcel.doImport({ template: { hint: '工程量清单', url: '/template/导入工程量清单EXCEL格式.xls', }, callback: function (sheet) { postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) { const sel = billsSheet.getSelections(); const refreshNode = billsTree.loadPostData(result); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); if (refreshNode.create[0]) { if (sel && sel[0]) { billsSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount); SpreadJsObj.reloadRowsBackColor(billsSheet, [sel[0].row, refreshNode.create[0].index]); } else { billsSheet.setSelection(refreshNode.create[0].index, 0, 1, 1); SpreadJsObj.reloadRowsBackColor(billsSheet, [refreshNode.create[0].index]); } } billsTreeSpreadObj.refreshOperationValid(billsSheet); }, null); } }); } }; const tenderSelect = TenderSelect({ type: 'revise', afterLoad: function (result) { const refreshNode = billsTree.loadPostData(result); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); billsTreeSpreadObj.refreshOperationValid(billsSheet); if (result.sumLoadHis.errors.length > 0) { sumLoadMiss.loadMissData(result.sumLoadHis.errors); sumLoadMiss.show(); } else { sumLoadMiss.clearMissData(); } } }); billsContextMenuOptions.items.importOtherTender = { name: '更新(其他标段)工程量清单至项目节', icon: 'fa-link', disabled: function (key, opt) { const node = SpreadJsObj.getSelectObject(billsSheet); return readOnly || !node || !billsTree.isLeafXmj(node); }, callback: function (key, opt) { tenderSelect.showSelect(SpreadJsObj.getSelectObject(billsSheet)); } }; } billsContextMenuOptions.items.sprTag = '----'; billsContextMenuOptions.items.showLast = { name: '显示至最底层', callback: function (key, opt, menu, e) { const node = SpreadJsObj.getSelectObject(billsSheet); setTimeout(() => { showWaitingView(); billsTree.expandByCustom(x => { return x.expanded || (x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0); }); SpreadJsObj.refreshTreeRowVisible(billsSheet); closeWaitingView(); }, 100); }, }; $.contextMenu(billsContextMenuOptions); // 计量单元 相关方法&绑定spreadjs事件 const posSpreadObj = { refreshOperationValid: function (sheet, selection) { const setObjEnable = function (obj, enable) { if (enable) { obj.removeClass('disabled'); } else { obj.addClass('disabled'); } }; const invalidAll = function () { setObjEnable($('a[name=pos-opr][type=up-move]'), false); setObjEnable($('a[name=pos-opr][type=down-move]'), false); }; const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const first = sheet.zh_data[row]; if (!first) { invalidAll(); return; } let last = first; if (sel.rowCount > 1 && first) { for (let r = 1; r < sel.rowCount; r++) { const rNode = sheet.zh_data[sel.row + r]; if (!rNode) break; last = rNode; } } const preNode = sheet.zh_data[row - 1]; const valid = !sheet.zh_setting.readOnly; setObjEnable($('a[name=pos-opr][type=up-move]'), valid && first && preNode); setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1)); }, loadExprToInput: function () { const sel = posSheet.getSelections()[0]; if (!sel) return; const col = posSheet.zh_setting.cols[sel.col]; const cell = posSheet.getCell(sel.col, sel.col); if (col && col.type === 'Number') { const data = SpreadJsObj.getSelectObject(posSheet); if (data) { const exprInfo = getExprInfo(col.field); const value = exprInfo ? (data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field]) : data[col.field]; $('#pos-expr').val(value).attr('field', col.field).attr('org', data[col.field]) .attr('readOnly', readOnly || cell.locked()).attr('data-row', sel.row); } else { $('#pos-expr').val('').attr('readOnly', true); $('#pos-expr').removeAttr('data-row'); } } else { $('#pos-expr').val('').attr('readOnly', true); $('#pos-expr').removeAttr('data-row'); } }, /** * 加载计量单元 根据当前台账选择节点 */ loadCurPosData: function () { const node = SpreadJsObj.getSelectObject(billsSheet); if (node) { const posData = pos.getLedgerPos(node.id) || []; SpreadJsObj.loadSheetData(posSheet, 'data', posData); posSheet.zh_setting.readOnly = readOnly || (node.used && posData.length === 0); } else { SpreadJsObj.loadSheetData(posSheet, 'data', []); posSheet.zh_setting.readOnly = true; } SpreadJsObj.refreshSheetReadOnly(posSheet); posSpreadObj.loadExprToInput(); posSpreadObj.refreshOperationValid(posSheet); }, baseOpr: function (sheet, type) { const data = { postType: 'pos', posPostType: type === 'delete' ? type : 'update', postData: [], }; const selection = sheet.getSelections(); const row = selection[0].row, count = selection[0].rowCount; const first = sheet.zh_data[row]; if (type === 'delete') { for (let iRow = 0; iRow < count; iRow++) { const posData = sheet.zh_data[iRow + row]; if (posData) { if (posData.used) { toastr.error('"' + posData.name + '"已计量，请勿删除'); return; } data.postData.push(sheet.zh_data[iRow + row].id); } } } else if (type === 'up-move') { const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id}; for (let iRow = 0; iRow < count; iRow++) { const posData = sheet.zh_data[iRow + row]; if (posData) { data.postData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row - 1].porder}); preUpdate.porder = posData.porder; } } data.postData.push(preUpdate); } else if (type === 'down-move') { const next = sheet.zh_data[row + count], nextUpdate = {id: next.id}; for (let iRow = count - 1; iRow >= 0; iRow--) { const posData = sheet.zh_data[iRow + row]; if (posData) { data.postData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row + 1].porder}); nextUpdate.porder = posData.porder; } } data.postData.push(nextUpdate); } if (data.postData.length > 0) { postData(window.location.pathname + '/update', data, function (result) { if (type === 'delete') { pos.removeDatas(result.pos); sheet.deleteRows(row, count); const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); billsTreeSpreadObj.refreshOperationValid(billsSheet); posSpreadObj.refreshOperationValid(posSheet); } else { pos.updateDatas(result.pos); const sel = selection[0]; if (sel) { sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, sheet.zh_data.indexOf(first)]); } posSpreadObj.loadCurPosData(); } }); } }, editStarting: function (e, info) { posSpreadObj.billsNode = SpreadJsObj.getSelectObject(billsSheet); const sel = info.sheet.getSelections(); if (!sel || !sel[0]) return; const col = info.sheet.zh_setting.cols[sel[0].col]; const node = SpreadJsObj.getSelectObject(info.sheet); const exprInfo = getExprInfo(col.field); if (exprInfo) { if (node[exprInfo.expr] && node[exprInfo.expr] !== '') { info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]); } } }, /** * 编辑单元格响应事件 * @param {Object} e * @param {Object} info */ editEnded: function (e, info) { if (!info.sheet.zh_setting) { SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null; const col = info.sheet.zh_setting.cols[info.col]; const orgText = posData ? posData[col.field] : null; const newText = trimInvalidChar(info.editingText); if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) return; const node = posSpreadObj.billsNode; if (!node) { toastr.error('数据错误，请选择台账节点后再试'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (newText && newText !== '' && node.children && node.children.length > 0) { toastr.error('父节点不可插入计量单元'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) { toastr.error('项目节不可插入计量单元'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const data = {postType: 'pos'}; if (col.field === 'name') { if (newText === '' && posData) { toastr.error('部位名称不可为空', 'error'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (!posData) { if (newText && newText !== '') { data.posPostType = 'add'; const sortData = info.sheet.zh_data; const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1); data.postData = { name: newText, lid: node.id, porder: order}; } else { return; } } else { data.posPostType = 'update'; data.postData = {id: posData.id, name: newText}; } } else if (!posData) { toastr.warning('新增计量单元请先输入名称'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else { data.posPostType = 'update'; data.postData = {id: posData.id}; if (col.type === 'Number') { const exprInfo = getExprInfo(col.field); const num = _.toNumber(newText); if (_.isFinite(num)) { data.postData[col.field] = num; if (exprInfo) { data.postData[exprInfo.expr] = ''; } } else { try { data.postData[col.field] = math.evaluate(transExpr(newText)); if (exprInfo) { data.postData[exprInfo.expr] = newText; } } catch(err) { toastr.error('输入的表达式非法'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } else { data.postData[col.field] = newText; } } postData(window.location.pathname + '/update', data, function (result) { const updateRst = pos.updateDatas(result.pos); // 刷新当前行, 不适用于新增（在非下一空白行新增） if (updateRst.create.length > 0) { posSpreadObj.loadCurPosData(); } else { SpreadJsObj.reLoadRowData(info.sheet, info.row); } const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); billsTreeSpreadObj.refreshOperationValid(billsSheet); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.row); }); }, /** * 删除按钮响应事件 * @param sheet */ deletePress: function (sheet) { if (!sheet.zh_setting) return; const sortData = sheet.zh_data; const datas = [], posSelects = []; const sel = sheet.getSelections()[0]; for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) { let bDel = false; const node = sortData[iRow]; if (node) { const data = {id: node.id}; for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) { const colSetting = sheet.zh_setting.cols[iCol]; if (colSetting.field === 'name') { toastr.error('部位名称不能为空'); return; } const style = sheet.getStyle(iRow, iCol); if (!style.locked) { const colSetting = sheet.zh_setting.cols[iCol]; data[colSetting.field] = null; const exprInfo = getExprInfo(colSetting.field); if (exprInfo) { data[exprInfo.expr] = ''; } bDel = true; } } if (bDel) { datas.push(data); posSelects.push(node); } } } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'update', postData: datas}, function (result) { pos.updateDatas(result.pos); posSpreadObj.loadCurPosData(); const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); billsTreeSpreadObj.refreshOperationValid(billsSheet); }, function () { posSpreadObj.loadCurPosData(); }); } }, /** * 删除 计量单元 * @param sheet */ deletePos: function (sheet) { const selection = sheet.getSelections(); const data = { postType: 'pos', posPostType: 'delete', postData: [], }; const row = selection[0].row, count = selection[0].rowCount; const sortData = sheet.zh_data; for (let iRow = 0; iRow < count; iRow++) { const posData = sortData[iRow + row]; if (posData) { if (posData.used) { toastr.error('"' + posData.name + '"已计量，请勿删除'); return; } data.postData.push(sortData[iRow + row].id); } } if (data.postData.length > 0) { postData(window.location.pathname + '/update', data, function (result) { pos.removeDatas(result.pos); sheet.deleteRows(row, count); const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); billsTreeSpreadObj.refreshOperationValid(billsSheet); }); } }, /** * 粘贴单元格响应事件 * @param e * @param info */ clipboardPasted: function (e, info) { if (info.sheet.getColumnCount() > info.sheet.zh_setting.cols.length) { info.sheet.setColumnCount(info.sheet.zh_setting.cols.length); } const node = SpreadJsObj.getSelectObject(billsSheet); if (node.code && (node.code !== '')) { toastr.error('项目节不可含有节点明细'); posSpreadObj.loadCurPosData(); return; } if (node.children && (node.children.length > 0)) { toastr.error('仅节点子项可以含有计量单元'); posSpreadObj.loadCurPosData(); return; } if (!info.sheet.zh_setting) { posSpreadObj.loadCurPosData(); return; } const data = []; const sortData = info.sheet.zh_data || []; if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) { if (info.cellRange.col !== 0) { toastr.warning('新增计量单元请先输入名称'); posSpreadObj.loadCurPosData(); return; } } const hint = { name: {type: 'warning', msg: '计量单元名称不可为空，已过滤'}, expr: {type: 'warning', msg: '粘贴了表达式非法，已过滤'}, }; const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1; for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) { let bPaste = true; const curRow = info.cellRange.row + iRow; const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id}; for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) { const curCol = info.cellRange.col + iCol; const colSetting = info.sheet.zh_setting.cols[curCol]; if (!colSetting) continue; posData[colSetting.field] = trimInvalidChar(info.sheet.getText(curRow, curCol)); if (colSetting.type === 'Number') { const num = _.toNumber(posData[colSetting.field]); if (num) { posData[colSetting.field] = num; } else { try { posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field])); const exprInfo = getExprInfo(colSetting.field); if (exprInfo) { posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol)); } } catch (err) { toastMessageUniq(hint.expr); bPaste = false; } } } else if (colSetting.field === 'name') { if (!posData[colSetting.field]) { toastMessageUniq(hint.name); bPaste = false; } } } if (bPaste) { data.push(posData); } } if (data.length === 0) { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; } postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'paste', postData: data}, function (result) { pos.updateDatas(result.pos); posSpreadObj.loadCurPosData(); const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); posSpreadObj.loadCurPosData(); billsTreeSpreadObj.refreshOperationValid(billsSheet); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); }); }, selectionChanged: function (e, info) { posSpreadObj.loadExprToInput(); posSpreadObj.refreshOperationValid(posSheet); }, addPegs: function (pegs) { if (!pegs || pegs.length <= 0) return; const node = SpreadJsObj.getSelectObject(billsSheet); if (!node) return; const sheet = posSpread.getActiveSheet(); const sortData = sheet.zh_data || []; let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1; pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id}); postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'paste', postData: pegs}, function (result) { pos.updateDatas(result.pos); posSpreadObj.loadCurPosData(); billsTreeSpreadObj.refreshOperationValid(billsSheet); }); } }; posSpread.bind(spreadNS.Events.SelectionChanged, posSpreadObj.selectionChanged); if (!readOnly && isTz) { $('a[name="pos-opr"]').click(function () { posSpreadObj.baseOpr(posSheet, this.getAttribute('type')); }); $('#pos-expr').bind('change onblur', function () { if (this.readOnly) return; const expr = $(this); const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1; const select = posSheet.zh_data ? posSheet.zh_data[row] : null; if (!select) return; const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val()); if (orgValue === newValue || (!orgValue && newValue == '')) return; const data = {id: select.id}; const exprInfo = getExprInfo(field); if (newValue !== '') { const num = _.toNumber(newValue); if (num) { data[field] = num; if (exprInfo) data[exprInfo.expr] = ''; } else { try { data[field] = math.evaluate(transExpr(newValue)); if (exprInfo) data[exprInfo.expr] = newValue; } catch (err) { toastr.error('输入的表达式非法'); return; } } } else { data[field] = null; if (exprInfo) data[exprInfo.expr] = ''; } // 更新至服务器 postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'update', postData: data}, function (result) { const updateRst = pos.updateDatas(result.pos); // 刷新当前行, 不适用于新增（在非下一空白行新增） SpreadJsObj.reLoadRowData(posSheet, row); const loadResult = billsTree.loadPostData(result.ledger); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); billsTreeSpreadObj.refreshOperationValid(billsSheet); }); }); posSpread.bind(spreadNS.Events.EditStarting, posSpreadObj.editStarting); posSpread.bind(spreadNS.Events.EditEnded, posSpreadObj.editEnded); posSpread.bind(spreadNS.Events.ClipboardPasted, posSpreadObj.clipboardPasted); SpreadJsObj.addDeleteBind(posSpread, posSpreadObj.deletePress); const mergePeg = NewMergePeg({ callback: posSpreadObj.addPegs }); $.contextMenu({ selector: '#pos-spread', build: function ($trigger, e) { const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread); return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader; }, items: { 'delete': { name: '删除', icon: 'fa-remove', disabled: function (key, opt) { if (posSheet.zh_data) { const selection = posSheet.getSelections(); return posSheet.zh_data.length < selection[0].row + selection[0].rowCount; } else { return true; } }, callback: function (key, opt) { posSpreadObj.deletePos(posSheet); } }, 'merge-peg': { name: '合并起讫桩号', disabled: function (key, opt) { const node = SpreadJsObj.getSelectObject(billsSheet); return _.isNil(node) || _.isNil(node.b_code) || node.b_code === ''; }, callback: function (key, opt) { mergePeg.show(); }, visible: function (key, opt) { return isTz; } } } }); } // 加载清单&计量单元数据 postData(window.location.pathname + '/load', {}, function (result) { billsTree.loadDatas(result.bills); treeCalc.calculateAll(billsTree); SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree); SpreadJsObj.loadTopAndSelect(billsSheet, ckBillsSpread); checkShowLast(result.bills.length); pos.loadDatas(result.pos); posSpreadObj.loadCurPosData(); SpreadJsObj.resetTopAndSelect(posSheet); checkList.loadHisCheckData(); }, null); $.divResizer({ select: '#revise-resize', callback: function () { billsSpread.refresh(); let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0; $(".sp-wrap").height(bcontent-30); posSpread.refresh(); } }); class DealBills { constructor (selector, spreadSetting) { const self = this; this.loaded = false; this.obj = $(selector)[0]; this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal'; this.spreadSetting = spreadSetting; this.spread = SpreadJsObj.createNewSpread(this.obj); SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting); if (!readOnly) { this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) { const dealSheet = info.sheet; const mainSheet = billsSheet; const dealBills = SpreadJsObj.getSelectObject(dealSheet); if (!dealBills) { return; } const mainTree = mainSheet.zh_tree; const mainNode = SpreadJsObj.getSelectObject(mainSheet); if (!mainNode || !mainTree) { return; } if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) { toastr.warning('非最底层项目下，不应添加节点'); return; } postData(window.location.pathname + '/update', { postType: 'add-deal', postData: { id: mainNode.ledger_id, type: mainNode.code ? 'child' : 'next', dealBills: { b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit, unit_price: dealBills.unit_price, } }, }, function (result) { const refreshData = mainTree.loadPostData(result); billsTreeSpreadObj.refreshTree(mainSheet, refreshData); const sel = mainSheet.getSelections()[0]; if (sel && refreshData.create[0]) { mainSheet.setSelection(mainTree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(refreshData.create[0])]); } billsTreeSpreadObj.refreshOperationValid(mainSheet); billsSpread.focus(); posSpreadObj.loadCurPosData(); }); }); } SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread); } loadData (callback) { if (this.loaded) { if (callback) callback(); return; } const self = this; postData(this.url+'/get-data', {}, function (data) { self.data = data; SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data); self.loaded = true; if (callback) callback(); }); } calculateData () { if (this.data) { for (const d of this.data) { d.total_price = _.multiply(d.quantity, d.unit_price); } } } } class BgBills { constructor (selector, spreadSetting) { this.loaded = false; this.obj = $(selector)[0]; this.spreadSetting = spreadSetting; this.spread = SpreadJsObj.createNewSpread(this.obj); this.sheet = this.spread.getActiveSheet(); SpreadJsObj.initSheet(this.sheet, this.spreadSetting); if (!readOnly) { this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) { const dealSheet = info.sheet; const mainSheet = billsSheet; const bgBills = SpreadJsObj.getSelectObject(dealSheet); if (!bgBills) { return; } const mainTree = mainSheet.zh_tree; const mainNode = SpreadJsObj.getSelectObject(mainSheet); if (!mainNode || !mainTree) { return; } if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) { toastr.warning('非最底层项目下，不应添加变更清单'); return; } postData(window.location.pathname + '/update', { postType: 'add-bg', postData: { id: mainNode.ledger_id, type: mainNode.code ? 'child' : 'next', dealBills: { b_code: bgBills.code, name: bgBills.name, unit: bgBills.unit, unit_price: bgBills.unit_price, } }, }, function (result) { const refreshData = mainTree.loadPostData(result); billsTreeSpreadObj.refreshTree(mainSheet, refreshData); const sel = mainSheet.getSelections()[0]; if (sel && refreshData.create[0]) { mainSheet.setSelection(mainTree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(refreshData.create[0])]); } billsTreeSpreadObj.refreshOperationValid(mainSheet); billsSpread.focus(); posSpreadObj.loadCurPosData(); }); }); } SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread); } loadData () { if (this.loaded) return; const self = this; postData('/tender/' + window.location.pathname.split('/')[2] +'/change/bills', {type: 'gather'}, function (data) { self.data = data; SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data); self.loaded = true; }); } } class BatchInsertBillsPosObj { constructor (obj) { const self = this; this.obj = obj; this.billsCount = 6; this.posCount = 1000; this.filter = getLocalCache('zh-calc-batch-filter'); if (!this.filter) { this.filter = '1'; } $('input[name=batch-filter]')[0].checked = this.filter && this.filter != '0'; // 初始化 清单编号窗口 参数 this.qdSpreadSetting = { cols: [ {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'}, {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50}, {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'}, ], emptyRows: this.billsCount, headRows: 1, headRowHeight: [32], headerFont: '12px 微软雅黑', font: '12px 微软雅黑', }; this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]); // 初始化 部位数量复核表 参数 this.posSpreadSetting = { cols: [ {title: '名称', field: 'bw', hAlign: 0, width: 80, formatter: '@'}, {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60}, ], emptyRows: this.posCount, headRows: 1, headRowHeight: [32], headerFont: '12px 微软雅黑', font: '12px 微软雅黑', }; for (let iNum = 1; iNum <= this.billsCount; iNum++) { this.posSpreadSetting.cols.push( {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50} ) } this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]); // 初始化 签约节点 参数 this.dealSpreadSetting = { cols: [ {title: '清单编号', field: 'code', width: 80, hAlign: 0, formatter: '@', readOnly: true}, {title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}, {title: '单价', field: 'unit_price', hAlign: 2, width: 60, readOnly: true}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headerFont: '12px 微软雅黑', font: '12px 微软雅黑', }; this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]); // 初始化 清单编号、部位数量复核表 表格 this.initView(); SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting); SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet()); // 拉取签约节点数据 dealBills.loadData(() => { SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data); }); // 双击签约节点，自动添加到清单编号窗口 this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) { const deal = info.sheet.zh_data[info.row]; const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet(); const sel = qdSheet.getSelections()[0]; qdSheet.getCell(sel.row, 0).value(deal.code); qdSheet.getCell(sel.row, 1).value(deal.name); qdSheet.getCell(sel.row, 2).value(deal.unit); qdSheet.getCell(sel.row, 3).value(deal.unit_price); if (sel.row + 1 === qdSheet.getRowCount()) { const count = sel.row + 2; qdSheet.setRowCount(count); qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count); const colCount = posSheet.getColumnCount() + 1; posSheet.setColumnCount(colCount); posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('清单' + count); } qdSheet.setSelection(sel.row + 1, sel.col, 1, 1); qdSheet.getParent().focus(); }); this.qdSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) { const billsCount = info.sheet.getRowCount(), posSheet = self.posSpread.getActiveSheet(); const count = posSheet.getColumnCount() - 2; if (billsCount > count) { posSheet.setColumnCount(billsCount + 2); for (let i = count + 1; i <= billsCount; i++) { info.sheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i); posSheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i); } } if (info.cellRange.col === 0 && info.cellRange.colCount === 1) { const dealBills = self.dealSpread.getActiveSheet().zh_data; if (dealBills && dealBills.length > 0) { for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) { const curRow = iRow + info.cellRange.row; const bills = _.find(dealBills, {code: info.sheet.getText(curRow, 0)}); if (bills) { info.sheet.getCell(curRow, 1).value(bills.name); info.sheet.getCell(curRow, 2).value(bills.unit); info.sheet.getCell(curRow, 3).value(bills.unit_price); } } } } }); this.posSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) { const billsCount = info.sheet.getColumnCount() - 2, qdSheet = self.qdSpread.getActiveSheet(); const count = qdSheet.getRowCount(); if (billsCount > count) { qdSheet.setRowCount(billsCount); for (let i = count + 1; i <= billsCount; i++) { qdSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i); info.sheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i); } } }); this.qdSpread.bind(spreadNS.Events.EditEnded, function (e, info) { if (info.col === 0) { const dealBills = self.dealSpread.getActiveSheet().zh_data; if (dealBills && dealBills.length > 0) { const bills = _.find(dealBills, {code: info.editingText}); if (bills) { info.sheet.getCell(info.row, 1).value(bills.name); info.sheet.getCell(info.row, 2).value(bills.unit); info.sheet.getCell(info.row, 3).value(bills.unit_price); } } } }); this.obj.bind('shown.bs.modal', function () { self.qdSpread.refresh(); self.posSpread.refresh(); self.dealSpread.refresh(); }); $('#batch-ok').click(function () { const selection = billsSheet.getSelections(); const sel = selection[0]; const row = selection[0].row; const select = billsTree.nodes[row]; if (select) { const insertData = {}; insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next'; insertData.id = select[billsTree.setting.id]; insertData.batchData = self.getBatchData(); if (insertData.batchData.length > 0) { postData(window.location.pathname + '/update', { postType: 'batch-insert', postData: insertData }, function (data) { pos.updateDatas(data.pos); const result = billsTree.loadPostData(data.ledger); billsTreeSpreadObj.refreshTree(billsSheet, result); billsSheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(billsSheet, [sel.row, result.create[0].index]); billsTreeSpreadObj.refreshOperationValid(billsSheet, selection); posSpreadObj.loadCurPosData(); self.obj.modal('hide'); }, null, true); } else { self.obj.modal('hide'); } } }); $('input[name=batch-filter]').change(function () { setLocalCache('zh-calc-batch-filter', this.checked ? 1 : 0); }); $.contextMenu({ selector: '.batch-l-t', build: function ($trigger, e) { const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread); return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader; }, items: { 'create': { name: '新增行', icon: 'fa-sign-in', callback: function (key, opt) { const qdSheet = self.qdSpread.getActiveSheet(); const posSheet = self.posSpread.getActiveSheet(); qdSheet.addRows(qdSheet.getRowCount(), 1); const index = qdSheet.getRowCount(); qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index); posSheet.addColumns(posSheet.getColumnCount(), 1); posSheet.getCell(0, index + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + index); }, }, 'delete': { name: '删除行', icon: 'fa-remove', callback: function (key, opt) { const qdSheet = self.qdSpread.getActiveSheet(); const posSheet = self.posSpread.getActiveSheet(); const sel = qdSheet.getSelections()[0]; qdSheet.deleteRows(sel.row, sel.rowCount); posSheet.deleteColumns(sel.row + 2, sel.rowCount); for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) { qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1)); } for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) { posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1)); } qdSheet.setSelection(sel.row, sel.col, 1, 1); }, }, } }); } // 初始化左侧表格 initView () { // 初始化 清单编号 const qdSheet = this.qdSpread.getActiveSheet(); SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting); SpreadJsObj.refreshColumnAlign(qdSheet); // 清理原有数据 SpreadJsObj.beginMassOperation(qdSheet); qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data); for (let iRow = 1; iRow <= this.billsCount; iRow++) { qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow); } qdSheet.setSelection(0, 0, 1 ,1); SpreadJsObj.endMassOperation(qdSheet); // 初始化 部位数量复核表 const posSheet = this.posSpread.getActiveSheet(); SpreadJsObj.initSheet(posSheet, this.posSpreadSetting); SpreadJsObj.refreshColumnAlign(posSheet); // 清理原有数据 SpreadJsObj.beginMassOperation(posSheet); posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader); posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data); posSheet.setSelection(0, 0, 1 ,1); SpreadJsObj.endMassOperation(posSheet); // 检查签约节点数据，以工具栏数据为准 if (dealBills) { SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data); } this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1); } // 获取界面数据 getBatchData () { const result = []; const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet(); for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) { if (qdSheet.getText(iRow, 0) === '') { continue; } const qd = { b_code: qdSheet.getText(iRow, 0), name: qdSheet.getText(iRow, 1), unit: qdSheet.getText(iRow, 2), price: _.toNumber(qdSheet.getText(iRow, 3)), pos: [], }; for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) { const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2)); if (value !== 0 && !isNaN(value)) { qd.pos.push({ name: posSheet.getText(iPosRow, 0), drawing_code: posSheet.getText(iPosRow, 1), quantity: value, porder: qd.pos.length + 1, }); } } if (!$('input[name=batch-filter]')[0].checked || qd.pos.length > 0) result.push(qd); } return result; } } const dealBills = new DealBills('#deal-bills-spread', { cols: [ {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@', readOnly: true}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true}, {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true}, {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', }); const bgBills = new BgBills('#bg-bills-spread', { cols: [ {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@', readOnly: true}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true}, {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true}, {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', }); $.divResizer({ select: '#revise-right-spr', callback: function () { billsSpread.refresh(); if (posSpread) posSpread.refresh(); if (stdXmj) stdXmj.spread.refresh(); if (stdGcl) stdGcl.spread.refresh(); if (dealBills) dealBills.spread.refresh(); if (bgBills) bgBills.spread.refresh(); if (searchLedger) searchLedger.spread.refresh(); if (errorList) errorList.spread.refresh(); if (checkList) checkList.spread.refresh(); if (sumLoadMiss) sumLoadMiss.spread.refresh(); } }); $.subMenu({ menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list', toMenu: '#to-menu', toMiniMenu: '#to-mini-menu', key: 'menu.1.0.0', miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1', callback: function (info) { if (info.mini) { $('.panel-title').addClass('fluid'); $('#sub-menu').removeClass('panel-sidebar'); } else { $('.panel-title').removeClass('fluid'); $('#sub-menu').addClass('panel-sidebar'); } autoFlashHeight(); billsSpread.refresh(); if (posSpread) posSpread.refresh(); if (stdXmj) stdXmj.spread.refresh(); if (stdGcl) stdGcl.spread.refresh(); if (dealBills) dealBills.spread.refresh(); if (bgBills) bgBills.spread.refresh(); if (searchLedger) searchLedger.spread.refresh(); if (errorList) errorList.spread.refresh(); if (checkList) checkList.spread.refresh(); if (sumLoadMiss) sumLoadMiss.spread.refresh(); } }); $('#content-tab').addClass('active'); $('#xd-content').addClass('active'); showSideTools(true); billsSpread.refresh(); if (posSpread) posSpread.refresh(); const stdLibCellDoubleClick = function (e, info) { const stdSheet = info.sheet; const mainSheet = billsSheet; if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; } const stdTree = stdSheet.zh_tree; const stdNode = stdTree.nodes[info.row]; const mainTree = mainSheet.zh_tree; const sel = mainSheet.getSelections()[0]; const mainNode = mainTree.nodes[sel.row]; if (!stdNode) return; if (info.sheet.zh_setting.stdType === 'gcl') { if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) { toastr.warning('非最底层项目下，不应添加节点'); return; } } postData(window.location.pathname + '/update', { postType: 'add-std', postData: { id: mainTree.getNodeKey(mainNode), tender_id: mainNode.tender_id, stdType: info.sheet.zh_setting.stdType, stdLibId: stdNode.list_id, stdNode: stdTree.getNodeKey(stdNode) } }, function (result) { const refreshNode = mainTree.loadPostData(result); billsTreeSpreadObj.refreshTree(mainSheet, refreshNode); if (sel) { if (refreshNode.create && refreshNode.create.length > 0) { mainSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshNode.create[refreshNode.create.length - 1].index]); } else { const node = _.find(mainTree.nodes, {code: stdNode.code, name: stdNode.name}); if (node) { mainSheet.setSelection(mainTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount); SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(node)]); } } } billsTreeSpreadObj.refreshOperationValid(mainSheet); billsSpread.focus(); posSpreadObj.loadCurPosData(); }); }; const stdXmjSetting = { selector: '#std-xmj', stdType: 'xmj', treeSetting: { id: 'chapter_id', pid: 'pid', order: 'order', level: 'level', rootId: -1, keys: ['id', 'list_id', 'chapter_id'], }, spreadSetting: { cols: [ {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true} ], treeCol: 0, emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', headColWidth: [30], selectedBackColor: '#fffacd', }, cellDoubleClick: stdLibCellDoubleClick, page: 'revise', tid: window.location.pathname.split('/')[2], }; const stdGclSetting = { selector: '#std-gcl', stdType: 'gcl', treeSetting: { id: 'bill_id', pid: 'pid', order: 'order', level: 'level', rootId: -1, keys: ['id', 'list_id', 'bill_id'] }, spreadSetting: { cols: [ {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true} ], treeCol: 0, emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', headColWidth: [30], selectedBackColor: '#fffacd', }, cellDoubleClick: stdLibCellDoubleClick, page: 'revise', tid: window.location.pathname.split('/')[2], }; // 展开收起标准节点 $('a', '#side-menu').bind('click', function (e) { e.preventDefault(); const tab = $(this), tabPanel = $(tab.attr('content')); // 展开工具栏、切换标签 if (!tab.hasClass('active')) { const close = $('.active', '#side-menu').length === 0; $('a', '#side-menu').removeClass('active'); tab.addClass('active'); $('.tab-content .tab-pane').removeClass('active'); tabPanel.addClass('active'); showSideTools(tab.hasClass('active')); if (tab.attr('content') === '#std-xmj') { if (!stdXmj) { stdXmj = new stdLib(stdXmjSetting); } stdXmj.spread.refresh(); } else if (tab.attr('content') === '#std-gcl') { if (!stdGcl) { stdGcl = new stdLib(stdGclSetting); } stdGcl.spread.refresh(); } else if (tab.attr('content') === '#deal-bills') { dealBills.loadData(); dealBills.spread.refresh(); } else if (tab.attr('content') === '#bg-bills') { bgBills.loadData(); bgBills.spread.refresh(); } else if (tab.attr('content') === '#search') { if (!searchLedger) { searchLedger = $.billsSearch({ selector: '#search', searchSpread: billsSpread, resultSpreadSetting: { cols: [ {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@', readOnly: true}, {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true}, {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true}, {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true}, {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', }, afterLocated: function () { posSpreadObj.loadCurPosData(); } }); } searchLedger.spread.refresh(); } else if (tab.attr('content') === '#error-list') { errorList.spread.refresh(); } else if (tab.attr('content') === '#check-list') { checkList.spread.refresh(); } else if (tab.attr('content') === '#sum-load-miss') { sumLoadMiss.spread.refresh(); } } else {// 收起工具栏 tab.removeClass('active'); tabPanel.removeClass('active'); showSideTools(tab.hasClass('active')); } billsSpread.refresh(); if (posSpread) posSpread.refresh(); }); if (!readOnly) { // 修订详情 保存 $('#save').click(function () { const content = $('#content').val(); postData('save', { content: content }, function () { $('#content').attr('org-value', content); }); }); } // 显示层次 (function (select, sheet) { $(select).click(function () { if (!sheet.zh_tree) return; const tag = $(this).attr('tag'); const tree = sheet.zh_tree; setTimeout(() => { showWaitingView(); switch (tag) { case "1": case "2": case "3": case "4": case "5": tree.expandByLevel(parseInt(tag)); SpreadJsObj.refreshTreeRowVisible(sheet); break; case "last": tree.expandByCustom(() => { return true; }); SpreadJsObj.refreshTreeRowVisible(sheet); break; case "leafXmj": tree.expandToLeafXmj(); SpreadJsObj.refreshTreeRowVisible(sheet); break; } closeWaitingView(); }, 100); }); })('a[name=showLevel]', billsSheet); const dataChecker = DataChecker({ checkUrl: window.location.pathname + '/check', completeData: function (data) { pos.updateDatas({update: data.source.pos}); const loadResult = billsTree.loadPostData({update: data.source.bills}); billsTreeSpreadObj.refreshTree(billsSheet, loadResult); posSpreadObj.loadCurPosData(); for (const e of data.error) { e.serialNo = billsTree.getNodeIndex(billsTree.getItems(e.ledger_id)) + 1; } }, errorList: errorList, }); $('#ledger-check2').click(() => { const result = ledgerCheck2({ ledgerTree: billsTree, ledgerPos: pos, checkList: checkList, decimal: decimal, checkOption: checkOption, }); check2Viewing({ extra: ZhCalc.div(billsTree.datas.length + pos.datas.length, 10000, 0), randomWait: true, prefix: 'check2-', checks: result, checkList: checkList, }) }); $('[name=revise-start]').submit(function (e) { if (checkAuditorFrom()) { $(this).parent().parent().parent().modal('hide'); dataChecker.checkAndPost(this.action, {}); $('#hide-all').hide(); } return false; }); });