'use strict'; /** * 台账修订页面js * * @author Mai * @date * @version */ const ckBillsSpread = '/tender/' + window.location.pathname.split('/')[2] + '/change/revise-billsSelect'; const invalidFields = { parent: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'deal_qty', 'deal_tp', 'unit_price', 'ex_qty1', 'ex_tp1'], gcl: ['dgn_qty1', 'dgn_qty2'], posCode: ['b_code'], posCalc: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'ex_qty1', 'ex_tp1'], posXmj: ['code'], }; function getExprInfo (field, converse = false) { const exprField = [ {qty: 'sgfh_qty', expr: 'sgfh_expr'}, {qty: 'sjcl_qty', expr: 'sjcl_expr'}, {qty: 'qtcl_qty', expr: 'qtcl_expr'}, ]; return converse ? _.find(exprField, {expr: field}) : _.find(exprField, {qty: field}); } function transExpr(expr) { return $.trim(expr).replace('\t', '').replace('=', '').replace(new RegExp('%', 'gm'), '/100'); } const copyBlockTag = 'zh.calc.copyBlock'; const dskCompilation = 'zh.calc.dskCompilation'; 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'}, ], }, same_code: { enable: 1 }, same_bills: { enable: 1 }, }; $(document).ready(() => { let stdXmj, stdGcl, searchLedger; autoFlashHeight(); billsSpreadSetting.cols.unshift({ title: '变更清单', colSpan: '1', rowSpan: '2', field: 'is_change', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isChangeList', }); const billsIndex = _.findIndex(billsSpreadSetting.cols, { field: 'drawing_code' }) !== -1 ? _.findIndex(billsSpreadSetting.cols, { field: 'drawing_code' }) : (_.findIndex(billsSpreadSetting.cols, { field: 'sgfh_tp' }) !== -1 ? _.findIndex(billsSpreadSetting.cols, { field: 'sgfh_tp' }) + 1 : billsSpreadSetting.cols.length - 1); console.log(billsSpreadSetting.cols); billsSpreadSetting.cols.splice(billsIndex, 0, { title: '计价', colSpan: '1', rowSpan: '2', field: 'is_valuation', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isValuation', getValue: 'getValue.isValuation' }); billsSpreadSetting.cols.splice(billsIndex + 1, 0, {title: '申请变更增(+)减(-)|数量', colSpan: '2|1', rowSpan: '1|1', field: 'camount', hAlign: 2, width: 60, readOnly: 'readOnly.isSettle', getValue: 'getValue.camount'},); billsSpreadSetting.cols.splice(billsIndex + 2, 0, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'ca_tp', hAlign: 2, width: 60, type: 'Number', readOnly: true},); if (!billsSpreadSetting.readOnly) { for (const col of billsSpreadSetting.cols) { if (!col.readOnly || col.readOnly === false) col.readOnly = 'readOnly.isChangeAdd'; } } posSpreadSetting.cols.unshift({ title: '变更清单', colSpan: '1', rowSpan: '2', field: 'is_change', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isChangeList', getValue: 'getValue.isChange' }); const posIndex = _.findIndex(posSpreadSetting.cols, { field: 'drawing_code' }) !== -1 ? _.findIndex(posSpreadSetting.cols, { field: 'drawing_code' }) : posSpreadSetting.cols.length; posSpreadSetting.cols.splice(posIndex, 0, { title: '计价', colSpan: '1', rowSpan: '2', field: 'is_valuation', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isValuation', getValue: 'getValue.isValuation' }); posSpreadSetting.cols.splice(posIndex + 1, 0, {title: '申请变更增(+)减(-)|数量', colSpan: '1|1', rowSpan: '|1', field: 'camount', hAlign: 2, width: 120, readOnly: 'readOnly.isSettle', getValue: 'getValue.camount'},); if (!posSpreadSetting.readOnly) { for (const col of posSpreadSetting.cols) { if (!col.readOnly || col.readOnly === false) col.readOnly = 'readOnly.isChangeAdd'; } } const billsCol = { getValue: { isChange: function (data) { if (!data) return 0; if (!data.name) return 0; const cInfo = _.find(changeList, { gcl_id: data.id, mx_id: '' }); return cInfo ? 1 : 0; }, isValuation: function (data) { if (!data) return 0; if (!data.name) return 0; const cList = _.filter(changeList, { gcl_id: data.id }); if (cList.length === 0) return 0; return _.find(cList, { is_valuation: 0 }) ? 0 : 1; }, camount: function (data) { const cInfo = _.find(changeList, {gcl_id: data.id, mx_id: ''}); return cInfo ? ZhCalc.round(cInfo.camount, findDecimal(data.unit)) : ZhCalc.round(data.camount, findDecimal(data.unit)); } }, readOnly: { isChangeAdd: function (data) { return !readOnly && !data.formc; }, isChangeList: function (data) { if (!data) return true; let edit = !readOnly && !(data.is_leaf && data.b_code); if (!edit && data.id) { const lPos = pos.getLedgerPos(data.id); if (lPos && lPos.length > 0) { edit = true; } } return edit; }, isValuation: function (data) { if (!data) return true; return !readOnly && !(data && data.name && _.findIndex(changeList, { gcl_id: data.id, mx_id: '' }) !== -1); }, isSettle: function (data) { if (!data) return true; return !readOnly && !(data && data.name && _.findIndex(changeList, { gcl_id: data.id, mx_id: '' }) !== -1 && (!data.settle_status || (data.settle_status && data.settle_status !== settleStatus.finish))); } } }; const posCol = { getValue: { isChange: function (data) { if (!data) return 0; if (!data.name) return 0; const cInfo = _.find(changeList, { gcl_id: data.lid, mx_id: data.id }); return cInfo ? 1 : 0; }, isValuation: function (data) { if (!data) return 0; if (!data.name) return 0; const cInfo = _.find(changeList, { gcl_id: data.lid, mx_id: data.id }); return cInfo ? cInfo.is_valuation : 0; }, camount: function (data) { if (!data) return ''; if (!data.name) return ''; const cInfo = _.find(changeList, { gcl_id: data.lid, mx_id: data.id }); return cInfo ? ZhCalc.round(cInfo.camount, findDecimal(cInfo.unit)) : ''; } }, readOnly: { isChangeAdd: function (data) { return !readOnly && !data.formc && (!data.settle_status || (data.settle_status && data.settle_status === settleStatus.finish)); }, isChangeList: function (data) { if (!data) return true; // console.log(data.name); return !readOnly && !data.name; }, isValuation: function (data) { if (!data) return true; return !readOnly && !posCol.getValue.isChange(data); }, isSettle: function (data) { if (!data) return true; return !readOnly && !(data && data.name && _.findIndex(changeList, { gcl_id: data.lid, mx_id: data.id }) !== -1 && (!data.settle_status || (data.settle_status && data.settle_status !== settleStatus.finish))); } } }; console.log(posSpreadSetting); // 判断是否是已结算清单 function checkIsSettle(data) { const info = data.mx_id ? _.find(settlePos, { lid: data.gcl_id, pid: data.mx_id }) : _.find(settleBills, { lid: data.gcl_id }); if (info && info.settle_status && info.settle_status === settleStatus.finish) { return true; } return false; } // 初始化spread const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]); const billsSheet = billsSpread.getActiveSheet(); billsSpreadSetting.rowHeader = [ { rowHeaderType: 'circle', setting: { size: 5, indent: 16, getColor: function (index, data) { if (!data) return; if(!data.formc && !data.cid) return; return '#dc3545'; } }, }, ]; billsSpreadSetting.getColor = function (sheet, data, row, col, defaultColor) { if (data && data.settle_status && data.settle_status === settleStatus.finish) { return spreadColor.stage.settle; } if (data && data.is_change) { return '#c3e6cb'; } return defaultColor; }; billsSpreadSetting.localCache = { key: 'changes-ledger-spread', colWidth: true, }; sjsSettingObj.setFxTreeStyle(billsSpreadSetting, sjsSettingObj.FxTreeStyle.jz); if (thousandth) sjsSettingObj.setTpThousandthFormat(billsSpreadSetting); sjsSettingObj.setNodeTypeCol(billsSpreadSetting.cols, [{field: 'node_type'}]); SpreadJsObj.initSpreadSettingEvents(billsSpreadSetting, billsCol); SpreadJsObj.initSheet(billsSheet, billsSpreadSetting); const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]); const posSheet = posSpread.getActiveSheet(); posSpreadSetting.rowHeader = [ { rowHeaderType: 'circle', setting: { size: 5, indent: 16, getColor: function (index, data) { if (!data) return; if(!data.formc) return; return '#dc3545'; } }, }, ]; posSpreadSetting.getColor = function (sheet, data, row, col, defaultColor) { if (data && data.settle_status && data.settle_status === settleStatus.finish) { return spreadColor.stage.settle; } return defaultColor; }; posSpreadSetting.localCache = { key: 'changes-pos-spread', colWidth: true, }; sjsSettingObj.setGridSelectStyle(posSpreadSetting); if (thousandth) sjsSettingObj.setTpThousandthFormat(posSpreadSetting); SpreadJsObj.initSpreadSettingEvents(posSpreadSetting, posCol); 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: 'change-revise-error-' + window.location.pathname.split('/')[2], 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: 'change-revise-check-' + window.location.pathname.split('/')[2], 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: 'change-revise-slm-' + window.location.pathname.split('/')[2], 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', 'ca_tp', 'ex_tp1'], autoExpand: 3, markExpandKey: 'change-bills-expand', markExpandSubKey: window.location.pathname.split('/')[2], }; if (!isTz) { treeSetting.calcFields.push('deal_tp'); } treeSetting.calcFun = function (node) { if (node && node.b_code) { const posData = pos.getLedgerPos(node.id) || []; let camount = ZhCalc.round(node.camount, findDecimal(node.unit)) || 0; if (posData.length > 0) { let sgfh_qty = 0; let sjcl_qty = 0; let qtcl_qty = 0; let ex_qty1 = 0; camount = 0; for (const np of posData) { sgfh_qty = ZhCalc.add(sgfh_qty, np.sgfh_qty); sjcl_qty = ZhCalc.add(sjcl_qty, np.sjcl_qty); qtcl_qty = ZhCalc.add(qtcl_qty, np.qtcl_qty); ex_qty1 = ZhCalc.add(ex_qty1, np.ex_qty1); const cInfo = _.find(changeList, { gcl_id: np.lid, mx_id: np.id }); camount = cInfo ? ZhCalc.add(camount, ZhCalc.round(cInfo.camount, findDecimal(node.unit))) : camount; } if (!_.isEqual(node.sgfh_qty, sgfh_qty) || !_.isEqual(node.sjcl_qty, sjcl_qty) || !_.isEqual(node.qtcl_qty, qtcl_qty)) { node.sgfh_qty = sgfh_qty; node.sjcl_qty = sjcl_qty; node.qtcl_qty = qtcl_qty; node.ex_qty1 = ex_qty1; node.quantity = ZhCalc.sum([node.sgfh_qty, node.sjcl_qty, node.qtcl_qty]); node.sgfh_tp = ZhCalc.mul(sgfh_qty, node.unit_price, decimal.tp) || 0; node.sjcl_tp = ZhCalc.mul(sjcl_qty, node.unit_price, decimal.tp) || 0; node.qtcl_tp = ZhCalc.mul(qtcl_qty, node.unit_price, decimal.tp) || 0; node.total_price = ZhCalc.mul(node.quantity, node.unit_price, decimal.tp) || 0; } if (!_.isEqual(node.ex_qty1, ex_qty1)) { node.ex_qty1 = ex_qty1; node.ex_tp1 = ZhCalc.mul(node.ex_qty1, node.unit_price, decimal.tp) || 0; } } node.camount = camount; node.ca_tp = ZhCalc.mul(camount, node.unit_price, decimal.tp) || 0; } node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2); }; const billsTree = createNewPathTree('revise', treeSetting); console.log(billsTree, 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.field === 'camount') { const data = SpreadJsObj.getSelectObject(sheet); if (data) { const cInfo = _.find(changeList, { gcl_id: data.id, mx_id: '' }); if (!cInfo) { $('#bills-expr').val('').attr('readOnly', true); $('#bills-expr').removeAttr('data-row'); } else { const value = cInfo.camount_expr ? cInfo.camount_expr : ZhCalc.round(cInfo.camount, findDecimal(cInfo.unit)); $('#bills-expr').val(value).attr('field', col.field).attr('org', ZhCalc.round(cInfo.camount, findDecimal(cInfo.unit))) .attr('readOnly', billsCol.readOnly.isSettle(data)).attr('data-row', sel.row); } } else { $('#bills-expr').val('').attr('readOnly', true); $('#bills-expr').removeAttr('data-row'); } } else 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 !== '') || !data.formc); } 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) || !data.formc); } 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) || !data.formc); } } $('#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, settleFinish = first.settle_status === settleStatus.finish; 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; } if (!rNode.formc) { sameParent = false; break; } nodeUsed = nodeUsed || rNode.used; settleFinish = settleFinish || rNode.settle_status === settleStatus.finish; 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 siblings = tree.getChildren(tree.getParent(first)); let upPower = true; for (let order = last.order; order < siblings.length - 1; order ++) { if (!siblings[order].formc) { upPower = false; break; } } const valid = !sheet.zh_setting.readOnly; setObjEnable($('a[name=base-opr][type=add]'), valid && first && first.level > 1 && first.settle_status !== settleStatus.finish); setObjEnable($('a[name=base-opr][type=delete]'), valid && first && sameParent && first.level > 1 && !nodeUsed && first.formc && !settleFinish); setObjEnable($('a[name=base-opr][type=up-move]'), valid && first && sameParent && first.level > 1 && preNode && first.formc); setObjEnable($('a[name=base-opr][type=down-move]'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last) && first.formc); 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) || last.settle_status !== settleStatus.finish || tree.isLastSibling(last)) && upPower && first.formc); const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : []; setObjEnable($('a[name=base-opr][type=down-level]'), valid && first && sameParent && first.level > 1 && preNode && (preNode.children.length > 0 || (preNode.children.length === 0 && preNode.formc && (!preNodePosRange || preNodePosRange.length === 0))) && !preNode.used && first.formc && preNode.settle_status !== settleStatus.finish); 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 || info.newSelections[0].rowCount !== info.oldSelections[0].rowCount) { billsTreeSpreadObj.refreshOperationValid(info.sheet); billsTreeSpreadObj.refreshPosData(); } } billsTreeSpreadObj.loadExprToInput(info.sheet); }, refreshPosData: function() { SpreadJsObj.resetTopAndSelect(posSheet); posSpreadObj.loadCurPosData(); SpreadJsObj.saveTopAndSelect(billsSheet, ckBillsSpread); posSearch.search($('#pos-keyword').val()); }, /** * 新增节点 * @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; } if (child.settle_status === settleStatus.finish) { 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); const lastSelect = children[index + count - 1]; if (tree.checkNodeUsed(lastSelect, pos) && (!lastSelect.children || lastSelect.children.length === 0) && (children.length > index + count)) { toastr.warning('选中的节点已计量，不可升级'); return; } if (lastSelect.settle_status === settleStatus.finish && (children.length > index + count)) { toastr.warning('选中的节点已结算，不可升级'); return; } // 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); if (index > 0 && children[index-1].used) { toastr.warning('其前节点已计量，选中的节点不可降级'); return; } if (index > 0 && children[index-1].settle_status === settleStatus.finish) { toastr.warning('其前节点已结算，选中的节点不可降级'); return; } for (let i = index; i < count; i++) { const child = children[i+index]; if (tree.checkNodeUsed(child, pos)) { toastr.warning('选中的节点已计量，不可降级'); return; } if (tree.settle_status === settleStatus.finish) { toastr.warning('选中的节点已结算，不可降级'); return; } } } else if (type === 'add') { if (node.settle_status === settleStatus.finish) { 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) { changeList = result.changeList; 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); billsTreeSpreadObj.refreshPosData(); } self.refreshOperationValid(sheet); }); }); } else { postData(window.location.pathname + '/update', { postType: type, postData: { id: node.ledger_id, count: type === 'add' ? addCount : count, } }, function (result) { changeList = result.changeList; 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])]); billsTreeSpreadObj.refreshPosData(); } } self.refreshOperationValid(sheet); }); } }, buttonClicked: function (e, info, v) { if (info.sheet.zh_setting) { const select = SpreadJsObj.getSelectObject(info.sheet); const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'is_change') { if (billsCol.readOnly.isChangeList(select)) { return } if (info.sheet.isEditing()) { info.sheet.endEdit(true); } const is_change = info.sheet.getValue(info.row, info.col) ? 1 : 0; if (is_change) { makeGclGatherData(); const gclInfo = _.find(gclGatherData, function (item) { return item.leafXmjs && _.find(item.leafXmjs, {gcl_id: select.id }); }); const xmjInfo = gclInfo.leafXmjs.find(function (item) { return item.gcl_id === select.id; }); const oldCInfo = _.find(oldChangeList, { gcl_id: select.id, mx_id: '' }); const data = { lid: gclInfo.leafXmjs[0].gcl_id || select.id, code: gclInfo.b_code, name: gclInfo.name || '', unit: gclInfo.unit || '', unit_price: gclInfo.unit_price, oamount: xmjInfo.quantity, oamount2: oldCInfo ? oldCInfo.oamount2 : xmjInfo.quantity, bwmx: xmjInfo.bwmx || xmjInfo.jldy, xmj_code: xmjInfo.code || '', xmj_jldy: xmjInfo.jldy || '', xmj_dwgc: xmjInfo.dwgc || '', xmj_fbgc: xmjInfo.fbgc || '', xmj_fxgc: xmjInfo.fxgc || '', gcl_id: select.id, mx_id: '', }; if (oldCInfo) { data.detail = oldCInfo.detail; data.camount = oldCInfo.camount; data.camount_expr = oldCInfo.camount_expr; data.spamount = oldCInfo.spamount; data.is_valuation = oldCInfo.is_valuation; data.delimit = oldCInfo.delimit; } // 更新至服务器 postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', {type: 'add-change-list', postData: [data]}, function (result) { changeList = result.changeList; select.is_change = 1; select.is_valuation = data.is_valuation !== undefined ? data.is_valuation : 1; if (oldCInfo) { select.camount = data.camount; const refreshNode = billsTree.loadPostData({ update: [select] }); billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); } SpreadJsObj.reLoadRowData(info.sheet, info.row); }, function () { info.sheet.setValue(info.row, info.col, 0); }); } else { if (changeOrder && _.findIndex(oldChangeList, { gcl_id: select.id }) !== -1) { toastr.warning('插入台账清单功能下无法从这移除已勾选清单'); info.sheet.setValue(info.row, info.col, 1); return } const cInfo = _.find(changeList, { gcl_id: select.id }); if (_.find(changeUsedData, { cbid: cInfo.id })) { toastr.warning('该清单计量单元已被使用，无法取消勾选'); info.sheet.setValue(info.row, info.col, 1); return } else if (checkIsSettle(cInfo)) { toastr.warning('该清单计量单元已结算，无法取消勾选'); info.sheet.setValue(info.row, info.col, 1); return } else { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', {type: 'del-change-list', ids: [cInfo.id] }, function (result) { changeList = result.changeList; select.is_change = 0; select.is_valuation = 0; select.camount = null; const billsNode = select; billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); // 重算申请数量金额 // const refreshNode = billsTree.loadPostData(result); // billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); SpreadJsObj.reLoadRowData(info.sheet, info.row); }, function () { info.sheet.setValue(info.row, info.col, 1); }); } } } else if (col.field === 'is_valuation') { if (billsCol.readOnly.isChangeList(select)) { return; } if (!billsCol.getValue.isChange(select)) { toastr.warning('请先勾选变更清单才能勾选计价'); info.sheet.setValue(info.row, info.col, 0); return; } if (info.sheet.isEditing()) { info.sheet.endEdit(true); } const cInfo = _.find(changeList, { gcl_id: select.id, mx_id: '' }); if (_.findIndex(changeUsedData, { cbid: cInfo.id }) !== -1) { toastr.warning('该变更清单已被调用，无法更改计价'); info.sheet.setValue(info.row, info.col, cInfo.is_valuation); return; } const is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0; // select.is_valuation = is_valuation; cInfo.is_valuation = is_valuation; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { // SpreadJsObj.reLoadRowData(info.sheet, info.row); info.sheet.setValue(info.row, info.col, is_valuation); }, function () { select.is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0; cInfo.is_valuation = select.is_valuation; SpreadJsObj.reLoadRowData(info.sheet, info.row); }); } } }, /** * 编辑单元格响应事件 * @param {Object} e * @param {Object} info */ editEnded: function (e, info) { if (info.sheet.zh_setting) { const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'is_change' || col.field === 'is_valuation') { return; } const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data; const node = sortData[info.row]; if (col.field === 'camount') { if (!node) { toastr.error('数据错误，请选择台账节点后再试'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const cInfo = _.find(changeList, { gcl_id: node.id, mx_id: '' }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } let validText = info.editingText ? trimInvalidChar(info.editingText) : ''; const orgValue = validText && validText !== '' ? (_.toNumber(validText) ? cInfo.camount : cInfo.camount_expr) : (cInfo.camount_expr && cInfo.camount_expr !== '' ? cInfo.camount_expr : cInfo.camount); if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) { SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastr.error(msg); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } cInfo[col.field] = ZhCalc.round(validText, findDecimal(node.unit)) || 0; cInfo.spamount = ZhCalc.round(validText, findDecimal(node.unit)) || 0; cInfo.camount_expr = exprQuantity.expr; node[col.field] = cInfo[col.field]; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { SpreadJsObj.reLoadRowData(info.sheet, info.row); const billsNode = node; billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); }, function () { cInfo[col.field] = orgValue; cInfo.spamount = orgValue; node[col.field] = orgValue; SpreadJsObj.reLoadRowData(info.sheet, info.row); }); return; } const data = { id: node.id, tender_id: node.tender_id, ledger_id: node.ledger_id }; // 未改变值则不提交 const orgValue = node[col.field]; const newValue = col.wordWrap ? info.editingText : 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' || col.field === 'ex_qty1' || col.field === 'ex_tp1') { 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] = ZhCalc.mathCalcExpr(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] = ''; } } if (col.field === 'b_code' && newValue) { const ledgerData = _.filter(billsTree.nodes, function (item) { return item.b_code !== null && item.b_code !== '' && !item.formc; }); const ledgerOneData = _.find(ledgerData, { b_code: newValue }); if (ledgerOneData) { data.name = ledgerOneData.name; data.unit = ledgerOneData.unit; data.unit_price = ledgerOneData.unit_price; } } // 更新至服务器 postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) { changeList = result.changeList; const refreshNode = billsTree.loadPostData(result); for (const u of refreshNode.update) { billsTreeSpreadObj.reCalcCamount(u); } billsTreeSpreadObj.refreshTree(info.sheet, refreshNode); billsTreeSpreadObj.refreshPosData(); }); } }, 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: '仅可粘贴同层节点'}, settle: {type: 'warning', msg: '已结算节点，不可修改数量、单价、金额'}, }; const datas = [], filterNodes = [], camountData = []; 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 = colSetting.wordWrap ? pasteData[iRow-filterRow][iCol] : 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' || colSetting.field === 'camount' || colSetting.field === 'ca_tp' || colSetting.field === 'ex_qty1' || colSetting.field === 'ex_tp1') { if (isTz) { 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' && node.settle_status === settleStatus.finish) { toastMessageUniq(hint.settle); continue; } if (colSetting.field === 'camount') { bPaste = true; let validText = value; const cInfo = _.find(changeList, { gcl_id: node.id, mx_id: '' }); if (!cInfo) { bPaste = false; continue; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastMessageUniq(hint.invalidExpr); bPaste = false; continue; } if (isNaN(exprQuantity.quantity)) { toastMessageUniq(hint.invalidExpr); bPaste = false; continue; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error(curRow ? '台账第' + (curRow+1) + '行变更数值必须大于等于已调用值 ' + usedInfo.qty : '清单变更数值必须大于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error(curRow ? '台账第' + (curRow+1) + '行变更数值必须小于等于已调用值 ' + usedInfo.qty : '清单变更数值必须小于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } if (bPaste) { node.camount = ZhCalc.round(validText, findDecimal(node.unit)) || 0; filterNodes.push(node); camountData.push({id: cInfo.id, camount: node.camount, camount_expr: exprQuantity.expr, spamount: ZhCalc.round(validText, findDecimal(node.unit)) || 0 }); } else { filterNodes.push(node); SpreadJsObj.reLoadRowData(info.sheet, curRow); } continue; } if (colSetting.type === 'Number') { const num = _.toNumber(value); if (num) { data[colSetting.field] = num; } else { try { data[colSetting.field] = ZhCalc.mathCalcExpr(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; } if (colSetting.field === 'b_code' && value) { const ledgerData = _.filter(billsTree.nodes, function (item) { return item.b_code !== null && item.b_code !== '' && !item.formc; }); const ledgerOneData = _.find(ledgerData, { b_code: value }); if (ledgerOneData) { data.name = ledgerOneData.name; data.unit = ledgerOneData.unit; data.unit_price = ledgerOneData.unit_price; } } bPaste = true; } if (bPaste) { datas.push(data); } else { filterNodes.push(node); } } if (camountData.length > 0) { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'paste', updateData: camountData }, function (result) { changeList = result; const loadResult = { update: filterNodes }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); billsTreeSpreadObj.loadExprToInput(billsSheet); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; }); return; } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { changeList = result.changeList; 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 = [], camountData = []; 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 = colSetting.wordWrap ? info.sheet.getText(curRow, curCol) : 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' || colSetting.field === 'camount' || colSetting.field === 'ca_tp' || colSetting.field === 'ex_qty1' || colSetting.field === 'ex_tp1') { toastMessageUniq(hint.posQty); continue; } } if (node.used && colSetting.field === 'unit_price') { toastMessageUniq (hint.usedUp); continue; } if (colSetting.field === 'camount') { bPaste = true; let validText = value; const cInfo = _.find(changeList, { gcl_id: node.id, mx_id: '' }); if (!cInfo) { bPaste = false; continue; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastMessageUniq(hint.invalidExpr); bPaste = false; continue; } if (isNaN(exprQuantity.quantity)) { toastMessageUniq(hint.invalidExpr); bPaste = false; continue; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error(curRow ? '台账第' + (curRow+1) + '行变更数值必须大于等于已调用值 ' + usedInfo.qty : '清单变更数值必须大于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error(curRow ? '台账第' + (curRow+1) + '行变更数值必须小于等于已调用值 ' + usedInfo.qty : '清单变更数值必须小于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } if (bPaste) { node.camount = ZhCalc.round(validText, findDecimal(node.unit)) || 0; filterNodes.push(node); camountData.push({id: cInfo.id, camount: node.camount, camount_expr: exprQuantity.expr, spamount: ZhCalc.round(validText, findDecimal(node.unit)) || 0 }); } else { filterNodes.push(node); SpreadJsObj.reLoadRowData(info.sheet, curRow); } continue; } if (colSetting.type === 'Number') { const num = _.toNumber(value); if (num) { data[colSetting.field] = num; } else { try { data[colSetting.field] = ZhCalc.mathCalcExpr(transExpr(value)); } 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; } if (colSetting.field === 'b_code' && value) { const ledgerData = _.filter(billsTree.nodes, function (item) { return item.b_code !== null && item.b_code !== '' && !item.formc; }); const ledgerOneData = _.find(ledgerData, { b_code: value }); if (ledgerOneData) { data.name = ledgerOneData.name; data.unit = ledgerOneData.unit; data.unit_price = ledgerOneData.unit_price; } } bPaste = true; } if (bPaste) { datas.push(data); } else { filterNodes.push(node); } } } if (camountData.length > 0) { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'paste', updateData: camountData }, function (result) { changeList = result; const loadResult = { update: filterNodes }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); billsTreeSpreadObj.loadExprToInput(billsSheet); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; }); return; } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { changeList = result.changeList; 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 = [], camountDatas = []; 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); const cData = {}; 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 (col.type === 'Number' && node.settle_status === settleStatus.finish) continue; if (['dgn_qty1', 'dgn_qty2', 'camount'].indexOf(col.field) < 0 && sheet.zh_tree.checkNodeUsed(node, pos)) { toastr.warning('"' + (node.code || '') + (node.b_code || '') + ' ' + node.name +'"已计量，请勿修改'); return; } if (col.field === 'camount') { const cInfo = _.find(changeList, { gcl_id: node.id, mx_id: '' }); if (!cInfo) continue; cData.id = cInfo.id; cData.camount = null; cData.camount_expr = ''; cData.spamount = null; data.camount = null; } else { data[col.field] = null; const exprInfo = getExprInfo(col.field); if (exprInfo) { data[exprInfo.expr] = ''; } } bDel = true; } if (bDel) { datas.push(data); if (cData.id) camountDatas.push(cData); } } if (camountDatas.length > 0) { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'paste', updateData: camountDatas }, function (result) { changeList = result; for (const d of datas) { billsTreeSpreadObj.reCalcCamount(d); } const loadResult = { update: datas }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); billsTreeSpreadObj.loadExprToInput(billsSheet); }); return; } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) { changeList = result.changeList; 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()); if (node.settle_status === settleStatus.finish) { toastr.warning('选中的节点已结算，不可粘贴整块'); return; } postData(window.location.pathname + '/update', { postType: 'paste-block', postData: { id: tree.getNodeKey(node), tid: copyInfo.tid, block: copyInfo.block, } }, function (data) { changeList = data.changeList; 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; } if (col.field === 'camount') { const cInfo = _.find(changeList, { gcl_id: node.id, mx_id: '' }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (cInfo.camount_expr && cInfo.camount_expr !== '') { info.sheet.getCell(info.row, info.col).text(cInfo.camount_expr); } if (col.type === 'Number' && node.settle_status === settleStatus.finish) { info.cancel = true; } } else { 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 || node.settle_status === settleStatus.finish; 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': case 'ex_qty1': case 'ex_tp1': info.cancel = (node.children && node.children.length > 0) || node.settle_status === settleStatus.finish; break; case 'dgn_qty1': case 'dgn_qty2': info.cancel = !_.isEmpty(node.b_code || node.settle_status === settleStatus.finish); 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' || col.field === 'ex_qty1' || col.field === 'ex_tp1') { 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) { changeList = result.changeList; 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) { changeList = result.changeList; const refreshNode = tree.loadPostData(result); billsTreeSpreadObj.refreshTree(sheet, refreshNode); }) } }, reCalcCamount: function (node) { if (node && node.b_code) { const posData = pos.getLedgerPos(node.id) || []; let camount = node.camount || 0; let is_valuation = node.is_valuation || 0; if (posData.length > 0) { camount = 0; for (const np of posData) { const cInfo = _.find(changeList, { gcl_id: np.lid, mx_id: np.id }); camount = cInfo ? ZhCalc.add(camount, ZhCalc.round(cInfo.camount, findDecimal(cInfo.unit))) : camount; if (cInfo && cInfo.is_valuation) { is_valuation = 1; } } } node.camount = camount; node.ca_tp = ZhCalc.mul(camount, node.unit_price, decimal.tp) || 0; node.is_valuation = is_valuation; } }, _checkExprValid(expr) { if (!expr) return [true, null]; const param = []; let num = '', base = ''; for (let i = 0, iLen = expr.length; i < iLen; i++) { if (/^[\d\.%]+/.test(expr[i])) { if (base !== '') { param.push({type: 'base', value: base}); base = ''; } num = num + expr[i]; } else if (expr[i] === '(') { if (num !== '') { param.push({type: 'num', value: num}); num = ''; } if (base !== '') { param.push({type: 'base', value: base}); base = ''; } param.push({type: 'left', value: '('}); } else if (expr[i] === ')') { if (num !== '') { param.push({type: 'num', value: num}); num = ''; } if (base !== '') { param.push({type: 'base', value: base}); base = ''; } param.push({type: 'right', value: ')'}); } else if (/^[\+\-*\/]/.test(expr[i])) { if (num !== '') { param.push({type: 'num', value: num}); num = ''; } if (base !== '') { param.push({type: 'base', value: base}); base = ''; } param.push({type: 'calc', value: expr[i]}); } else { return [false, '输入的表达式含有非法字符: ' + expr[i]]; } } if (num !== '') { param.push({type: 'num', value: num}); num = ''; } if (base !== '') { param.push({type: 'base', value: base}); base = ''; } if (param.length === 0) return true; if (param.length > 1) { if (param[0].value === '-' && param[1].type === 'num') { param[1].value = '-' + param[1].value; param.shift(); } } const iLen = param.length; let iLeftCount = 0, iRightCount = 0; for (const [i, p] of param.entries()) { if (p.type === 'calc') { if (i === 0 || i === iLen - 1) return [false, '输入的表达式非法：计算符号' + p.value + '前后应有数字']; } if (p.type === 'num') { num = p.value.replace('%', ''); if (p.value.length - num.length > 1) return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字']; num = _.toNumber(num); if (num === undefined || num === null || _.isNaN(num)) return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字']; if (i > 0) { if (param[i - 1].type !== 'calc' && param[i - 1].type !== 'left') { return [false, '输入的表达式非法：' + p.value + '前应有运算符']; } else if (param[i - 1].value === '/' && num === 0) { return [false, '输入的表达式非法：请勿除0']; } } } if (p.type === 'base') { if (i > 0 && (param[i - 1].type === 'num' || param[i - 1].type === 'right')) return [false, '输入的表达式非法：' + p.value + '前应有运算符']; } if (p.type === 'left') { iLeftCount += 1; if (i !== 0 && param[i-1].type !== 'calc') return [false, '输入的表达式非法：（前应有运算符']; } if (p.type === 'right') { iRightCount += 1; if (i !== iLen - 1 && param[i+1].type !== 'calc') return [false, '输入的表达式非法：)后应有运算符']; if (iRightCount > iLeftCount) return [false, '输入的表达式非法：")"前无对应的"（"']; } } if (iLeftCount > iRightCount) return [false, '输入的表达式非法："("后无对应的"）"']; return [true, '']; }, _checkExpr: function (text, data) { if (text) { const num = _.toNumber(text); if (num) { data.quantity = num; data.expr = ''; } else { const expr = $.trim(text).replace('\t', '').replace('=', '').toLowerCase(); const [valid, msg] = this._checkExprValid(expr); if (!valid) return [valid, msg]; data.expr = expr; data.quantity = ZhCalc.calcExpr.calcExprStrRpn(expr.replace(new RegExp('%', 'gm'), '/100')); // const ce = new CalcEvalMin(); // data.quantity = ce.eval(expr); // console.log(data.quantity); } } else { data.quantity = 0; data.expr = ''; } return [true, '']; }, }; 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; } if (field === 'camount') { const cInfo = _.find(changeList, { gcl_id: select.id, mx_id: '' }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(newValue, exprQuantity); if (!valid) { toastr.error(msg); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); return; } const camount = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); return; } cInfo.camount = ZhCalc.round(camount, findDecimal(select.unit)) || 0; select.camount = ZhCalc.round(camount, findDecimal(select.unit)) || 0; cInfo.spamount = ZhCalc.round(camount, findDecimal(select.unit)) || 0; cInfo.camount_expr = exprQuantity.expr; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { SpreadJsObj.reLoadRowData(billsSheet, row); billsTreeSpreadObj.reCalcCamount(select); const loadResult = { update: [select] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); billsTreeSpreadObj.loadExprToInput(billsSheet); }, function () { cInfo.camount = orgValue; cInfo.spamount = orgValue; select.camount = orgValue; SpreadJsObj.reLoadRowData(billsSheet, row); }); 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] = ZhCalc.mathCalcExpr(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) { changeList = result.changeList; 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.ButtonClicked, billsTreeSpreadObj.buttonClicked); 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 && first.settle_status !== settleStatus.finish); } }; 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, settleFinish = first.settle_status === settleStatus.finish; 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; } if (!rNode.formc) { return true; } nodeUsed = nodeUsed || rNode.used; settleFinish = settleFinish || rNode.settle_status === settleStatus.finish; 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 && first.formc && !settleFinish); } }; 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 && first.settle_status !== settleStatus.finish); } }; billsContextMenuOptions.items.batchInsertBillsPos = { name: '批量插入清单-计量单元', icon: 'fa-sign-in', visible: function (key, opt) { return false; }, disabled: function (key, opt) { if (!isTz) return true; const select = SpreadJsObj.getSelectObject(billsSheet); if (select) { if (select.code && select.code !== '') { return !billsTree.isLeafXmj(select) || select.settle_status === settleStatus.finish; } else { const parent = billsTree.getParent(select); return !(parent && billsTree.isLeafXmj(parent)) || !(parent && parent.settle_status === settleStatus.finish); } } else { return false; } }, callback: function (key, opt) { if (!batchInsertObj) { batchInsertObj = new BatchInsertBillsPosObj($('#batch')); } else { batchInsertObj.initView(); } $('#batch').modal('show'); } }; } 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 && first.formc); setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1) && first.formc); }, 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.field === 'camount') { const data = SpreadJsObj.getSelectObject(posSheet); if (data) { const cInfo = _.find(changeList, { gcl_id: data.lid, mx_id: data.id }); if (!cInfo) { $('#pos-expr').val('').attr('readOnly', true); $('#pos-expr').removeAttr('data-row'); } else { const value = cInfo.camount_expr ? cInfo.camount_expr : cInfo.camount; $('#pos-expr').val(value).attr('field', col.field).attr('org', cInfo.camount) .attr('readOnly', posCol.readOnly.isSettle(data)).attr('data-row', sel.row); } } else { $('#pos-expr').val('').attr('readOnly', true); $('#pos-expr').removeAttr('data-row'); } } else 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 || !data.formc || data.settle_status === settleStatus.finish).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); // SpreadJsObj.initSpreadSettingEvents(posSpreadSetting, posCol); // SpreadJsObj.initSheet(posSheet, posSpreadSetting); if (node) { const posData = pos.getLedgerPos(node.id) || []; console.log(posData); SpreadJsObj.loadSheetData(posSheet, 'data', posData); posSheet.zh_setting.readOnly = readOnly || (node.used && posData.length === 0) || (node.settle_status && node.settle_status === settleStatus.finish); } else { SpreadJsObj.loadSheetData(posSheet, 'data', []); posSheet.zh_setting.readOnly = true; } SpreadJsObj.massOperationSheet(posSheet, function () { if (posSheet.zh_setting) { posSheet.zh_setting.cols.forEach(function (col, i) { for (let iRow = 0; iRow < posSheet.getRowCount(); iRow++) { if (i !== 0 && col.field !== 'camount' && col.field !== 'is_valuation') { posSheet.getCell(iRow, i).locked((posSheet.zh_data[iRow] && !posSheet.zh_data[iRow].formc) || posSheet.zh_setting.readOnly || false); } else { let lock = false; if (!posSheet.zh_data[iRow]) { lock = true; } if (col.field === 'camount' && posCol.readOnly.isSettle(posSheet.zh_data[iRow])) { lock = true; } posSheet.getCell(iRow, i).locked(lock || (posSheet.zh_data[iRow] && !posSheet.zh_data[iRow].name) || posSheet.zh_setting.readOnly || false); } } }); } }); // 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; } if (posData.settle_status) { 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); } else if (type === 'add') { const billsNode = SpreadJsObj.getSelectObject(billsSheet); if (billsNode.settle_status === settleStatus.finish) { toastr.warning('清单已结算，不可新增计量单元'); return; } } if (data.postData.length > 0) { postData(window.location.pathname + '/update', data, function (result) { changeList = result.changeList; 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 (col.field === 'camount') { const cInfo = _.find(changeList, { gcl_id: node.lid, mx_id: node.id }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (cInfo.camount_expr && cInfo.camount_expr !== '') { info.sheet.getCell(info.row, info.col).text(cInfo.camount_expr); } } else if (node && exprInfo) { if (node[exprInfo.expr] && node[exprInfo.expr] !== '') { info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]); } } if (col.type === 'Number' && node.settle_status === settleStatus.finish) { info.cancel = true; } }, buttonClicked: function (e, info) { if (info.sheet.zh_setting) { const select = SpreadJsObj.getSelectObject(info.sheet); const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'is_change') { if (posCol.readOnly.isChangeList(select)) { info.sheet.setValue(info.row, info.col, !select || !select.is_change ? 0 : 1); return } if (info.sheet.isEditing()) { info.sheet.endEdit(true); } const is_change = info.sheet.getValue(info.row, info.col) ? 1 : 0; // const valutaionCol = _.findIndex(info.sheet.zh_setting.cols, { field: 'is_valuation' }); if (is_change) { makeGclGatherData(); const gclInfo = _.find(gclGatherData, function (item) { return item.leafXmjs && _.find(item.leafXmjs, {gcl_id: select.lid, mx_id: select.id }); }); const xmjInfo = _.find(gclInfo.leafXmjs, { mx_id: select.id }); const oldCInfo = _.find(oldChangeList, { gcl_id: select.lid, mx_id: select.id }); const data = { lid: select.lid, code: gclInfo.b_code, name: gclInfo.name || '', unit: gclInfo.unit || '', unit_price: gclInfo.unit_price, oamount: xmjInfo.quantity, oamount2: oldCInfo ? oldCInfo.oamount2 : xmjInfo.quantity, bwmx: xmjInfo.bwmx || xmjInfo.jldy || '', xmj_code: xmjInfo.code || '', xmj_jldy: xmjInfo.jldy || '', xmj_dwgc: xmjInfo.dwgc || '', xmj_fbgc: xmjInfo.fbgc || '', xmj_fxgc: xmjInfo.fxgc || '', gcl_id: select.lid, mx_id: select.id, } if (oldCInfo) { data.detail = oldCInfo.detail; data.camount = oldCInfo.camount; data.camount_expr = oldCInfo.camount_expr; data.spamount = oldCInfo.spamount; data.is_valuation = oldCInfo.is_valuation; data.delimit = oldCInfo.delimit; } // 更新至服务器 postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', {type: 'add-change-list', postData: [data]}, function (result) { changeList = result.changeList; select.is_change = 1; select.is_valuation = data.is_valuation !== undefined ? data.is_valuation : 1; SpreadJsObj.reLoadRowData(info.sheet, info.row); // info.sheet.setValue(info.row, valutaionCol, data.is_valuation !== undefined ? data.is_valuation : 1); if (_.findIndex(changeList, { gcl_id: select.lid }) !== -1) { const billsNode = SpreadJsObj.getSelectObject(billsSheet); billsNode.is_change = 1; billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); } }, function () { info.sheet.setValue(info.row, info.col, 0); }); } else { if (changeOrder && _.findIndex(oldChangeList, { gcl_id: select.lid, mx_id: select.id }) !== -1) { toastr.warning('插入台账清单功能下无法从这移除已勾选清单'); info.sheet.setValue(info.row, info.col, 1); return } const cInfo = _.find(changeList, { gcl_id: select.lid, mx_id: select.id }); if (_.find(changeUsedData, { cbid: cInfo.id })) { toastr.warning('该计量单元已被使用，无法取消变更'); info.sheet.setValue(info.row, info.col, 1); return } else if (checkIsSettle(cInfo)) { toastr.warning('该计量单元已结算，无法取消变更'); info.sheet.setValue(info.row, info.col, 1); return } else { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', {type: 'del-change-list', ids: [cInfo.id] }, function (result) { changeList = result.changeList; select.is_change = 0; select.is_valuation = 0; SpreadJsObj.reLoadRowData(info.sheet, info.row); // info.sheet.setValue(info.row, valutaionCol, 0); const billsNode = SpreadJsObj.getSelectObject(billsSheet); billsTreeSpreadObj.reCalcCamount(billsNode); // 判断是否只剩一个，并同步去勾 if (_.findIndex(changeList, { gcl_id: select.lid }) === -1) { billsNode.is_change = 0; } const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); }, function () { info.sheet.setValue(info.row, info.col, 1); }); } } } else if (col.field === 'is_valuation') { if (!posCol.getValue.isChange(select)) { toastr.warning('请先勾选变更清单才能勾选计价'); info.sheet.setValue(info.row, info.col, !select || !select.is_valuation ? 0 : 1); return; } if (info.sheet.isEditing()) { info.sheet.endEdit(true); } const cInfo = _.find(changeList, { gcl_id: select.lid, mx_id: select.id }); if (_.findIndex(changeUsedData, { cbid: cInfo.id }) !== -1) { toastr.warning('该变更清单已被调用，无法更改计价'); info.sheet.setValue(info.row, info.col, cInfo.is_valuation); return; } const is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0; // select.is_valuation = is_valuation; cInfo.is_valuation = is_valuation; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { // SpreadJsObj.reLoadRowData(info.sheet, info.row); info.sheet.setValue(info.row, info.col, is_valuation); const billsNode = SpreadJsObj.getSelectObject(billsSheet); SpreadJsObj.reLoadRowData(billsSheet, billsTree.getNodeIndex(billsNode)); }, function () { select.is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0; cInfo.is_valuation = select.is_valuation; SpreadJsObj.reLoadRowData(info.sheet, info.row); }); } } }, /** * 编辑单元格响应事件 * @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 node = posSpreadObj.billsNode; const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'is_change' || col.field === 'is_valuation') { return; } if (col.field === 'camount') { if (!node) { toastr.error('数据错误，请选择台账节点后再试'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const cInfo = _.find(changeList, { gcl_id: posData.lid, mx_id: posData.id }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } let validText = info.editingText ? trimInvalidChar(info.editingText) : ''; const orgValue = validText && validText !== '' ? (_.toNumber(validText) ? cInfo.camount : cInfo.camount_expr) : (cInfo.camount_expr && cInfo.camount_expr !== '' ? cInfo.camount_expr : cInfo.camount); if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) { SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastr.error(msg); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } cInfo[col.field] = ZhCalc.round(validText, findDecimal(node.unit)) || 0; cInfo.spamount = ZhCalc.round(validText, findDecimal(node.unit)) || 0; cInfo.camount_expr = exprQuantity.expr; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { SpreadJsObj.reLoadRowData(info.sheet, info.row); const billsNode = node; billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); }, function () { cInfo[col.field] = orgValue; cInfo.spamount = orgValue; SpreadJsObj.reLoadRowData(info.sheet, info.row); }); return; } const orgText = posData ? posData[col.field] : null; const newText = col.wordWrap ? info.editingText : trimInvalidChar(info.editingText); if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) return; 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}; if (node.settle_status === settleStatus.finish) { toastr.error('已结算清单不可插入计量单元'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } else { return; } } else { data.posPostType = 'update'; data.postData = {id: posData.id, name: newText}; if (col.type === 'Number' && posData.settle_status === settleStatus.finish) { toastr.error('计量单元已结算，不可修改'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } 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] = ZhCalc.mathCalcExpr(transExpr(newText)); if (exprInfo) { data.postData[exprInfo.expr] = newText; } } catch(err) { toastr.error('输入的表达式非法'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } else if (col.field.indexOf('_expr') > 0) { const exprInfo = getExprInfo(col.field, true); if (!exprInfo) return; if (newText) { try { data.postData[exprInfo.qty] = ZhCalc.mathCalcExpr(transExpr(newText)); data.postData[exprInfo.expr] = newText; } catch(err) { toastr.error('输入的表达式非法'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } else { data.postData[exprInfo.qty] = 0; data.postData[exprInfo.expr] = ''; } } else { data.postData[col.field] = newText; } } postData(window.location.pathname + '/update', data, function (result) { changeList = result.changeList; 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); // 判断是否只剩一个，并同步去勾 const billsNode = SpreadJsObj.getSelectObject(billsSheet); // billsNode.is_change = ? 1 : 0; if (_.findIndex(changeList, { gcl_id: billsNode.id }) > -1) { billsNode.is_change = 1; } else { billsNode.is_change = 0; billsNode.is_valuation = 0; billsNode.camount = null; billsNode.ca_tp = null; } if (loadResult.update) { const r = _.find(loadResult.update, { id: billsNode.id }); r.is_change = billsNode.is_change; } else { loadResult.update = [billsNode]; } const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); 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 = [], camountDatas = []; 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}; const cData = {}; 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]; if (colSetting.field === 'camount') { const cInfo = _.find(changeList, { gcl_id: node.lid, mx_id: node.id }); if (!cInfo) continue; cData.id = cInfo.id; cData.camount = null; cData.camount_expr = ''; cData.spamount = null; } else if (colSetting.field.indexOf('_expr') > 0) { const exprInfo = getExprInfo(colSetting.field, true); if (!exprInfo) continue; data[exprInfo.expr] = ''; data[exprInfo.qty] = 0; } else { data[colSetting.field] = null; const exprInfo = getExprInfo(colSetting.field); if (exprInfo) data[exprInfo.expr] = ''; } bDel = true; } } if (bDel) { datas.push(data); if (cData.id) camountDatas.push(cData); posSelects.push(node); } } } if (camountDatas.length > 0) { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'paste', updateData: camountDatas }, function (result) { changeList = result; const billsNode = SpreadJsObj.getSelectObject(billsSheet); billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); posSpreadObj.loadCurPosData(); }, function () { posSpreadObj.loadCurPosData(); }); return; } if (datas.length > 0) { postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'update', postData: datas}, function (result) { changeList = result.changeList; 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; } if (posData.settle_status === settleStatus.finish) { 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) { changeList = result.changeList; pos.removeDatas(result.pos); sheet.deleteRows(row, count); const loadResult = billsTree.loadPostData(result.ledger); // 判断是否只剩一个，并同步去勾 const billsNode = SpreadJsObj.getSelectObject(billsSheet); // billsNode.is_change = _.findIndex(changeList, { gcl_id: billsNode.id }) > -1 ? 1 : 0; if (_.findIndex(changeList, { gcl_id: billsNode.id }) > -1) { billsNode.is_change = 1; } else { billsNode.is_change = 0; billsNode.is_valuation = 0; billsNode.camount = null; billsNode.ca_tp = null; } if (loadResult.update) { const r = _.find(loadResult.update, { id: billsNode.id }); r.is_change = billsNode.is_change; } else { loadResult.update = [billsNode]; } billsTreeSpreadObj.reCalcCamount(billsNode); const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); 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 (node.settle_status === settleStatus.finish) { toastr.error('清单已结算，请勿修改计量单元数据'); posSpread.loadCurPosData(); return; } if (!info.sheet.zh_setting) { posSpreadObj.loadCurPosData(); return; } const data = []; const camountData = []; const sortData = info.sheet.zh_data || []; const hint = { expr: {type: 'warning', msg: '粘贴了表达式非法，已过滤'}, settle: {type: 'warning', msg: '计量单元已结算，不可修改台账数据，已过滤'}, }; if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) { const nameCol = info.sheet.zh_setting.cols.findIndex(x => { return x.field === 'name'; }); if (info.cellRange.col > nameCol || info.cellRange.col + info.cellRange.colCount < nameCol) { toastr.warning('新增计量单元请先输入名称'); posSpreadObj.loadCurPosData(); return; } } let bHint = false; 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] = colSetting.wordWrap ? info.sheet.getText(curRow, curCol) : trimInvalidChar(info.sheet.getText(curRow, curCol)); if (posData.id && colSetting.type === 'Number' && sortData[curRow].settle_status === settleStatus.finish) { bPaste = false; toastMessageUniq(hint.settle); continue; } if (colSetting.field === 'camount') { bPaste = true; let validText = posData[colSetting.field]; const cInfo = _.find(changeList, { gcl_id: posData.lid, mx_id: posData.id }); if (!cInfo) { bPaste = false; continue; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastMessageUniq(hint.expr); bPaste = false; continue; } if (isNaN(exprQuantity.quantity)) { toastMessageUniq(hint.expr); bPaste = false; continue; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error(curRow ? '计量单元第' + (curRow+1) + '行变更数值必须大于等于已调用值 ' + usedInfo.qty : '清单变更数值必须大于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error(curRow ? '计量单元第' + (curRow+1) + '行变更数值必须小于等于已调用值 ' + usedInfo.qty : '清单变更数值必须小于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } if (bPaste) { camountData.push({id: cInfo.id, camount: ZhCalc.round(validText, findDecimal(node.unit)) || 0, camount_expr: exprQuantity.expr, spamount: ZhCalc.round(validText, findDecimal(node.unit)) || 0 }); } else { SpreadJsObj.reLoadRowData(info.sheet, curRow); } continue; } if (colSetting.type === 'Number') { const num = _.toNumber(posData[colSetting.field]); if (num) { posData[colSetting.field] = num; } else { try { posData[colSetting.field] = ZhCalc.mathCalcExpr(transExpr(posData[colSetting.field])); const exprInfo = getExprInfo(colSetting.field); if (exprInfo) { posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol)); } } catch (err) { if (!bHint) { toastr.warning('粘贴了非法表达式，已过滤'); bHint = true; } bPaste = false; } } } else if (colSetting.field.indexOf('_expr') > 0) { try { const exprInfo = getExprInfo(colSetting.field, true); posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol)); if (posData[exprInfo.expr] || !posData[exprInfo.qty]) { posData[exprInfo.qty] = ZhCalc.mathCalcExpr(transExpr(posData[exprInfo.expr])); } bPaste = true; } catch (err) { toastMessageUniq(hint.expr); } } else { bPaste = true; } } if (bPaste) { data.push(posData); } } if (camountData.length > 0) { postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'paste', updateData: camountData }, function (result) { changeList = result; const billsNode = SpreadJsObj.getSelectObject(billsSheet); billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); posSpreadObj.loadCurPosData(); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; }); return; } 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) { changeList = result.changeList; pos.updateDatas(result.pos); posSpreadObj.loadCurPosData(); const loadResult = result.ledger; const billsNode = SpreadJsObj.getSelectObject(billsSheet); // billsNode.is_change = _.findIndex(changeList, { gcl_id: billsNode.id }) > -1 ? 1 : 0; // billsNode.is_change = _.findIndex(changeList, { gcl_id: billsNode.id }) > -1 ? 1 : 0; if (_.findIndex(changeList, { gcl_id: billsNode.id }) > -1) { billsNode.is_change = 1; } else { billsNode.is_change = 0; billsNode.is_valuation = 0; billsNode.camount = null; billsNode.ca_tp = null; } if (loadResult.update) { const r = _.find(loadResult.update, { id: billsNode.id }); r.is_change = billsNode.is_change; } else { loadResult.update = [billsNode]; } billsTreeSpreadObj.reCalcCamount(billsNode); const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); 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) { changeList = result.changeList; pos.updateDatas(result.pos); posSpreadObj.loadCurPosData(); billsTreeSpreadObj.refreshOperationValid(billsSheet); }); } }; posSpread.bind(spreadNS.Events.SelectionChanged, posSpreadObj.selectionChanged); if (!readOnly) { $('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 billsNode = SpreadJsObj.getSelectObject(billsSheet); const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val()); if (orgValue === newValue || (!orgValue && newValue == '')) return; if (field === 'camount') { const cInfo = _.find(changeList, { gcl_id: select.lid, mx_id: select.id }); if (!cInfo) { toastr.error('未勾选变更清单，无法编辑申请数量'); return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = billsTreeSpreadObj._checkExpr(newValue, exprQuantity); if (!valid) { toastr.error(msg); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); return; } const camount = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: cInfo.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); return; } cInfo.camount = ZhCalc.round(camount, findDecimal(billsNode.unit)) || 0; cInfo.spamount = ZhCalc.round(camount, findDecimal(billsNode.unit)) || 0; cInfo.camount_expr = exprQuantity.expr; delete cInfo.waitingLoading; postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type:'update', updateData: cInfo }, function (result) { SpreadJsObj.reLoadRowData(posSheet, row); billsTreeSpreadObj.reCalcCamount(billsNode); const loadResult = { update: [billsNode] }; const refreshNode = billsTree.loadPostData(loadResult); billsTreeSpreadObj.refreshTree(billsSheet, refreshNode); posSpreadObj.loadExprToInput(posSheet); }, function () { cInfo.camount = orgValue; cInfo.spamount = orgValue; SpreadJsObj.reLoadRowData(posSheet, row); }); 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] = ZhCalc.mathCalcExpr(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) { changeList = result.changeList; 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.ButtonClicked, posSpreadObj.buttonClicked); posSpread.bind(spreadNS.Events.ClipboardPasted, posSpreadObj.clipboardPasted); SpreadJsObj.addDeleteBind(posSpread, posSpreadObj.deletePress); $.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(); const sel = selection ? selection[0] : sheet.getSelections()[0]; const row = sel ? sel.row : -1; const rowCount = sel.rowCount; let settleFinish = false; for (let i = row; i < row + rowCount; i++) { if (!posSheet.zh_data[i]) continue; settleFinish = settleFinish || posSheet.zh_data[i].settle_status === settleStatus.finish; } return (posSheet.zh_data.length < selection[0].row + selection[0].rowCount) || (posSheet.zh_data[selection[0].row] && !posSheet.zh_data[selection[0].row].formc) || settleFinish; } else { return true; } }, callback: function (key, opt) { posSpreadObj.deletePos(posSheet); } }, } }); } // 加载清单&计量单元数据 const preUrl = window.location.pathname.split('/').slice(0, 4).join('/'); let gclGatherData; postData(preUrl + '/defaultBills', { from: 'revise' }, function (result) { for (const b of result.bills) { if (!(b.is_leaf && b.b_code)) { b.is_change = 0; b.is_valutaion = 0; } else { const cInfo = _.find(changeList, { gcl_id: b.id }); b.is_change = cInfo ? 1 : 0; b.is_valuation = cInfo ? cInfo.is_valuation : 0; b.camount = cInfo ? cInfo.camount : 0; } } billsTree.loadDatas(result.bills); pos.loadDatas(result.pos); treeCalc.calculateAll(billsTree); SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree); SpreadJsObj.loadTopAndSelect(billsSheet, ckBillsSpread); checkShowLast(result.bills.length); posSpreadObj.loadCurPosData(); SpreadJsObj.resetTopAndSelect(posSheet); billsTreeSpreadObj.refreshOperationValid(billsSheet); billsTreeSpreadObj.loadExprToInput(billsSheet); checkList.loadHisCheckData(); console.log(billsTree); }, null); $.divResizer({ select: '#revise-resize', callback: function () { billsSpread.refresh(); let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0; $(".sp-wrap").height(bcontent-30); posSpread.refresh(); } }); function makeGclGatherData() { gclGatherModel.loadLedgerData(billsTree.datas); gclGatherModel.loadPosData(pos.datas); gclGatherData = gclGatherModel.gatherGclData(); gclGatherData = _.filter(gclGatherData, function (item) { return item.leafXmjs && item.leafXmjs.length !== 0; }); gclGatherData = gclGatherData.sort(sortByCode); } 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; } if (mainNode.settle_status === settleStatus.finish) { 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) { changeList = result.changeList; 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 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) { changeList = result.changeList; 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', }); class Jlzf { constructor (selector, spreadSetting) { const self = this; this.loaded = false; this.obj = $(selector); const relaSelect = { showLevel: `cb-${spreadSetting.stdType}-sl`, searchText: `cb-${spreadSetting.stdType}-st`, searchResult: `cb-${spreadSetting.stdType}-sr`, searchPre: `cb-${spreadSetting.stdType}-sp`, searchNext: `cb-${spreadSetting.stdType}-sn`, searchClose: `cb-${spreadSetting.stdType}-sc`, }; this.obj.html( '
\n' + '
\n' + '
\n' + '
\n' + '
' + ` \n` + `
结果：0
\n` + '
\n' + ` \n` + ` \n` + '
\n' + '
\n' + '
\n' + `
\n` + '
\n' + '
' + '
\n' + `
\n` ); autoFlashHeight(); const sh = `.cb-${spreadSetting.stdType}-sh`; function getObjHeight(select) { return select.length > 0 ? select.height() : 0; } const cHeader = getObjHeight($(".c-header")); $(sh).height($(window).height()-cHeader-getObjHeight($('.sjs-bar', sh.parentNode))-getObjHeight($('.sjs-bottom', sh.parentNode))-92+55-30); // this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal'; this.spreadSetting = spreadSetting; this.spread = SpreadJsObj.createNewSpread($(`#cb-${spreadSetting.stdType}-spread`)[0]); const searchSheet = this.spread.getActiveSheet(); SpreadJsObj.initSheet(searchSheet, 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; } if (mainNode.settle_status === settleStatus.finish) { 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.b_code, code: dealBills.code, name: dealBills.name, unit: dealBills.unit, unit_price: dealBills.unit_price, } }, }, function (result) { changeList = result.changeList; 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); const searchObj = { result: [], cur: 0, searchStdNode: function() { const keyword = $(`#${relaSelect.searchText}`).val(); const sortData = SpreadJsObj.getSortData(searchSheet); searchObj.result = keyword ? sortData.filter(x => { return (x.code && x.code.indexOf(keyword) >= 0) || (x.b_code && x.b_code.indexOf(keyword) >= 0) || (x.name && x.name.indexOf(keyword) >= 0); }) : []; $(`#${relaSelect.searchResult}`)[0].innerText = `结果：${searchObj.result.length}`; searchObj.cur = 0; if (searchObj.result.length > 0) { SpreadJsObj.locateData(searchSheet, searchObj.result[searchObj.cur]); } }, searchPre: function () { if (searchObj.result.length === 0) return; searchObj.cur = searchObj.cur === 0 ? searchObj.result.length - 1 : this.cur - 1; SpreadJsObj.locateData(searchSheet, searchObj.result[searchObj.cur]); }, searchNext: function () { if (searchObj.result.length === 0) return; searchObj.cur = searchObj.cur === searchObj.result.length - 1 ? 0 : searchObj.cur + 1; SpreadJsObj.locateData(searchSheet, searchObj.result[searchObj.cur]); }, clear: function () { $(`#${relaSelect.searchText}`).val(''); $(`#${relaSelect.searchResult}`)[0].innerText = `结果：${0}`; searchObj.result = []; searchObj.cur = 0; } }; $(`#${relaSelect.searchText}`).change(searchObj.searchStdNode); $(`#${relaSelect.searchPre}`).click(function (e) { searchObj.searchPre(); e.stopPropagation(); }); $(`#${relaSelect.searchNext}`).click(function (e) { searchObj.searchNext(); e.stopPropagation(); }); $(`#${relaSelect.searchClose}`).click(function (e) { searchObj.clear(); e.stopPropagation(); }); }; loadData (callback) { // if (this.loaded) { // if (callback) callback(); // return; // } const self = this; const datas = billsTree.nodes.filter(node => node.is_leaf === 1 && !node.code && node.ccid !== undefined && node.ccid !== ''); const showDatas = []; for (const d of datas) { if (_.findIndex(showDatas, { b_code: d.b_code ? d.b_code : '', name: d.name, unit: d.unit, unit_price: d.unit_price }) === -1) { showDatas.push({ code: d.code, b_code: d.b_code ? d.b_code : '', name: d.name, unit: d.unit, unit_price: d.unit_price }); } } SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', _.uniqWith(showDatas, _.isEqual).sort(sortByCode)); // self.loaded = true; if (callback) callback(); } } const jlzfBills = new Jlzf('#jlzf-spread', { cols: [ // {title: '项目节编号', field: 'code', hAlign: 0, width: 85, formatter: '@'}, {title: '清单编号', field: 'b_code', hAlign: 0, width: 100, formatter: '@'}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', readOnly: true, stdType: 'jlzf', }); class Dsk { constructor (selector, spreadSetting) { const self = this; this.loaded = false; this.obj = $(selector); const dskProjectHtml = spreadSetting.libs.map(l => { return ``; }); const relaSelect = { showLevel: `cb-${spreadSetting.stdType}-sl`, searchText: `cb-${spreadSetting.stdType}-st`, searchResult: `cb-${spreadSetting.stdType}-sr`, searchPre: `cb-${spreadSetting.stdType}-sp`, searchNext: `cb-${spreadSetting.stdType}-sn`, searchClose: `cb-${spreadSetting.stdType}-sc`, }; this.obj.html( '
\n' + '
\n' + ' \n' + '
\n' + ` 第一层\n` + ` 第二层\n` + ` 第三层\n` + ` 第四层\n` + ` 第五层\n` + ` 最底层\n` + '
\n' + '
' + `
\n` + `
\n` + '
\n' + '
\n' + ' \n' + '
\n' + '
\n' + '
\n' + '
' + ` \n` + `
结果：0
\n` + '
\n' + ` \n` + ` \n` + '
\n' + '
\n' + '
\n' + `
\n` + '
\n' + '
\n' + '
\n' + '
' + '
\n' + `
\n` ); autoFlashHeight(); const sh = `.cb-${spreadSetting.stdType}-sh`; function getObjHeight(select) { return select.length > 0 ? select.height() : 0; } const cHeader = getObjHeight($(".c-header")); $(sh).height($(window).height()-cHeader-getObjHeight($('.sjs-bar', sh.parentNode))-getObjHeight($('.sjs-bottom', sh.parentNode))-92+55-30); // this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal'; this.spreadSetting = spreadSetting; this.spread = SpreadJsObj.createNewSpread($(`#cb-${spreadSetting.stdType}-spread`)[0]); const searchSheet = this.spread.getActiveSheet(); SpreadJsObj.initSheet(searchSheet, this.spreadSetting); (function (select, sheet) { $(select).click(function () { if (!sheet.zh_tree) return; const tag = $(this).attr('tag'); const tree = sheet.zh_tree; setTimeout(() => { 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; } }, 100); }); })(`a[name=${relaSelect.showLevel}]`, searchSheet); 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; } if (mainNode.settle_status === settleStatus.finish) { toastr.warning('已结算节点下，不应添加签约清单'); return; } const is_bill = dealBills.kind === 4; const oneBills = { b_code: is_bill ? dealBills.code : null, code: !is_bill ? dealBills.code : null, name: dealBills.name, unit: dealBills.unit, unit_price: is_bill ? dealBills.unitPrice : null, quantity: is_bill ? dealBills.quantity : null, total_price: is_bill ? dealBills.totalPrice : null, sgfh_qty: is_bill ? dealBills.quantity : null, sgfh_tp: is_bill ? dealBills.totalPrice : null, }; postData(window.location.pathname + '/update', { postType: 'add-deal', postData: { id: mainNode.ledger_id, type: mainNode.code ? 'child' : 'next', dealBills: oneBills, }, }, function (result) { changeList = result.changeList; 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); const searchObj = { result: [], cur: 0, searchStdNode: function() { const keyword = $(`#${relaSelect.searchText}`).val(); searchObj.result = keyword ? dskProjectBills2Tree.tenderTree.nodes.filter(x => { return (x.code && x.code.indexOf(keyword) >= 0) || (x.name && x.name.indexOf(keyword) >= 0); }) : []; // searchObj.result = []; // for (const x of pathTree.nodes) { // if (x.code.indexOf(keyword) >= 0 || x.b_code.indexOf(keyword) >= 0 || x.name.indexOf(keyword) >= 0) { // searchObj.result.push(x); // } // } $(`#${relaSelect.searchResult}`)[0].innerText = `结果：${searchObj.result.length}`; searchObj.cur = 0; if (searchObj.result.length > 0) { SpreadJsObj.locateTreeNode(searchSheet, dskProjectBills2Tree.tenderTree.getNodeKey(searchObj.result[searchObj.cur])); } }, searchPre: function () { if (searchObj.result.length === 0) return; searchObj.cur = searchObj.cur === 0 ? searchObj.result.length - 1 : this.cur - 1; SpreadJsObj.locateTreeNode(searchSheet, dskProjectBills2Tree.tenderTree.getNodeKey(searchObj.result[searchObj.cur]), true); }, searchNext: function () { if (searchObj.result.length === 0) return; searchObj.cur = searchObj.cur === searchObj.result.length - 1 ? 0 : searchObj.cur + 1; SpreadJsObj.locateTreeNode(searchSheet, dskProjectBills2Tree.tenderTree.getNodeKey(searchObj.result[searchObj.cur]), true); }, clear: function () { $(`#${relaSelect.searchText}`).val(''); $(`#${relaSelect.searchResult}`)[0].innerText = `结果：${0}`; searchObj.result = []; searchObj.cur = 0; } }; $(`#${relaSelect.searchText}`).change(searchObj.searchStdNode); $(`#${relaSelect.searchPre}`).click(function (e) { searchObj.searchPre(); e.stopPropagation(); }); $(`#${relaSelect.searchNext}`).click(function (e) { searchObj.searchNext(); e.stopPropagation(); }); $(`#${relaSelect.searchClose}`).click(function (e) { searchObj.clear(); e.stopPropagation(); }); }; loadData (callback) { if (this.loaded) { if (callback) callback(); return; } const self = this; if (dskAccountData && dskAccountData.select_project) { self.loaded = true; changeDskProject(dskAccountData.select_project); } else { SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', []); self.loaded = true; } if (callback) callback(); } } $('body').on('change', '#change-dsk-project', function () { const pid = $(this).val(); changeDskProject(pid); }); $('body').on('change', '#change-dsk-project-tree', function () { const treeId = $(this).val(); const projectInfo = _.find(dskProjects, { pid: dskAccountData.select_project }); changeDskProjectTree(projectInfo, treeId); }); function setDskProjectTreeSelect(trees) { let html = ''; for (const tree of trees) { html += ``; } $('#change-dsk-project-tree').html(html); } function changeDskProject(pid) { const projectInfo = _.find(dskProjects, { pid }); if (!projectInfo) { dskAccountData.select_project = null; dskAccountData.select_tree = null; const tree = dskProjectBills2Tree.convert([]); SpreadJsObj.loadSheetData(dskBills.spread.getActiveSheet(), SpreadJsObj.DataType.Tree, tree); return; } postData('/profile/dsk/api', { type: 'project_tree', tid: window.location.pathname.split('/')[2], compilationId: projectInfo.compilationId, projectId: projectInfo.pid }, function (datas) { const trees = _.filter(datas, x => x.type === 4); dskAccountData.select_project = projectInfo.pid; setDskProjectTreeSelect(trees); changeDskProjectTree(projectInfo, trees.length > 0 ? trees[0].ID : null); }); } function changeDskProjectTree(projectInfo, treeId) { dskAccountData.select_tree = treeId; if (!treeId) { const tree = dskProjectBills2Tree.convert([]); SpreadJsObj.loadSheetData(dskBills.spread.getActiveSheet(), SpreadJsObj.DataType.Tree, tree); return; } postData('/profile/dsk/api', { type: 'project_bills', tid: window.location.pathname.split('/')[2], compilationId: projectInfo.compilationId, treeId }, function (result) { const tree = dskProjectBills2Tree.convert(result); SpreadJsObj.loadSheetData(dskBills.spread.getActiveSheet(), SpreadJsObj.DataType.Tree, tree); }); } const dskBills = new Dsk('#dsk-spread', { cols: [ {title: '编号', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'}, {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'}, {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'}, {title: '单价', field: 'unitPrice', hAlign: 2, width: 80, formatter: '@'}, {title: '数量', field: 'quantity', hAlign: 2, width: 80, formatter: '@'}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', readOnly: true, stdType: 'dsk', libs: dskProjects, select_lib: dskAccountData.select_project ? dskAccountData.select_project : null, }); const dskProjectBills2Tree = (function () { const treeSetting = { id: 'dpb_id', pid: 'dpb_pid', order: 'seq', level: 'level', rootId: '-1', fullPath: 'full_path', }; const tenderTree = createNewPathTree('gather', treeSetting); function setChildrenNode(node, dxs, files, tenders) { const dxchildren = _.filter(dxs, { parentID: node.bid }); const children = _.filter(files, { parentID: node.bid }); const tenderChildren = _.filter(tenders, { parentID: node.bid }); const checkChildren = _.orderBy([...dxchildren, ...children, ...tenderChildren], ['seq', 'asc']); for (const t of checkChildren) { const child = { bid: t.ID, parentID: t.parentID, name: t.name, kind: t.kind, code: t.code, quantity: t.quantity, quantity2: t.quantity2, unit: t.unit, unitPrice: t.unitPrice, totalPrice: t.totalPrice, formulaCode: t.formulaCode, flag: t.flag, remark: t.remark, }; tenderTree.addNode(child, node); setChildrenNode(child, dxs, files, tenders); } } function convert (projects) { tenderTree.clearDatas(); // 区分文件夹及项目 const topLevel = _.orderBy(_.filter(projects, { parentID: '-1' }), ['seq', 'asc']); const dxs = _.filter(projects, { kind: 1 }); const files = _.filter(projects, { kind: 4 }); const tenders = _.filter(projects, { kind: 8 }); for (const t of topLevel) { const node = { bid: t.ID, parentID: t.parentID, name: t.name, kind: t.kind, code: t.code, quantity: t.quantity, quantity2: t.quantity2, unit: t.unit, unitPrice: t.unitPrice, totalPrice: t.totalPrice, formulaCode: t.formulaCode, flag: t.flag, remark: t.remark, }; tenderTree.addNode(node, null); setChildrenNode(node, dxs, files, tenders); } tenderTree.sortTreeNode(true); return tenderTree; } return { tenderTree, convert } })(); $.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 (searchLedger) searchLedger.spread.refresh(); if (errorList) errorList.spread.refresh(); if (checkList) checkList.spread.refresh(); if (sumLoadMiss) sumLoadMiss.spread.refresh(); if (jlzfBills) jlzfBills.spread.refresh(); if (dskBills) dskBills.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 (searchLedger) searchLedger.spread.refresh(); if (errorList) errorList.spread.refresh(); if (checkList) checkList.spread.refresh(); if (sumLoadMiss) sumLoadMiss.spread.refresh(); if (jlzfBills) jlzfBills.spread.refresh(); if (dskBills) dskBills.spread.refresh(); } }); // showSideTools(true); billsSpread.refresh(); if (posSpread) posSpread.refresh(); const stdLibCellDoubleClick = function (updateData, stdNode, stdTree) { const mainSheet = billsSheet; if (!stdTree || !mainSheet.zh_tree) { return; } const mainTree = mainSheet.zh_tree; const sel = mainSheet.getSelections()[0]; const mainNode = mainTree.nodes[sel.row]; if (!stdNode) return; if (updateData.postData.stdType === 'gcl') { if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) { toastr.warning('非最底层项目下，不应添加节点'); return; } if (mainNode.settle_status === settleStatus.finish) { toastr.warning('已结算节点下，不可添加工程量清单'); return; } } else { const stdNodes = stdTree.getAllParents(stdNode); for (const node of stdNodes) { const parent = mainTree.datas.find(x => { return x.code === node.code && x.name === node.name; }); if (parent && parent.settle_status === settleStatus.finish) { toastr.warning('项目节父项已结算，不可添加节点'); return; } } } postData(window.location.pathname + '/update', { postType: 'add-std', postData: { id: mainTree.getNodeKey(mainNode), tender_id: mainNode.tender_id, stdType: updateData.postData.stdType, stdLibId: stdNode.list_id, stdNode: stdTree.getNodeKey(stdNode) } }, function (result) { changeList = result.changeList; 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', libs: stdChapters, 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', libs: stdBills, 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 = $.stdLib(stdXmjSetting); } stdXmj.spread.refresh(); } else if (tab.attr('content') === '#std-gcl') { if (!stdGcl) { stdGcl = $.stdLib(stdGclSetting); } stdGcl.spread.refresh(); } else if (tab.attr('content') === '#deal-bills') { dealBills.loadData(); dealBills.spread.refresh(); } else if (tab.attr('content') === '#search') { if (!searchLedger) { searchLedger = $.ledgerSearch({ selector: '#search', ledger: { billsTree: billsTree, pos: pos }, searchOver: true, searchEmpty: true, resultSpreadSetting: { cols: [ {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@'}, {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'}, {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@'}, {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'}, {title: '单价', field: 'unit_price', hAlign: 2, width: 50}, {title: '数量', field: 'quantity', hAlign: 2, width: 50}, {title: '部位', field: 'bw', hAlign: 2, width: 90}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', readOnly: true, }, locate: function(cur) { if (!cur.lid) return; SpreadJsObj.locateTreeNode(billsSheet, cur.lid, true); posSpreadObj.loadCurPosData(); if (cur.pid && cur.pid !== -1) { const pIndex = posSheet.zh_data.findIndex(x => { return x.id === cur.pid; }); SpreadJsObj.locateRow(posSheet, pIndex); } }, customSearch: [ { key: 'revise', title: '新增部位', valid: true, parent: true, check: function (node) { if (node.formc || node.cid) { return true; } else { return false; } } } ], }); } 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 if (tab.attr('content') === '#dsk-list') { const dskActiveTab = $('#dsk-tab a[class*="active"]').attr('href'); $(dskActiveTab).addClass('active'); if (dskActiveTab === '#jlzf-spread') { $('#get-dsk-btn').hide(); $('#get-dsk-bills-btn').hide(); jlzfBills.loadData(); jlzfBills.spread.refresh(); } else if (dskActiveTab === '#dsk-spread') { $('#get-dsk-btn').show(); $('#get-dsk-bills-btn').show(); dskBills.loadData(); dskBills.spread.refresh(); } } } else {// 收起工具栏 tab.removeClass('active'); tabPanel.removeClass('active'); showSideTools(tab.hasClass('active')); } billsSpread.refresh(); if (posSpread) posSpread.refresh(); }); // 新增清单切换tab $('#dsk-tab a[data-toggle="tab"]').on('shown.bs.tab', function (e) { e.preventDefault(); const dskActiveTab = $(this).attr('href'); if (dskActiveTab === '#jlzf-spread') { $('#get-dsk-btn').hide(); $('#get-dsk-bills-btn').hide(); jlzfBills.loadData(); jlzfBills.spread.refresh(); } else if (dskActiveTab === '#dsk-spread') { $('#get-dsk-btn').show(); $('#get-dsk-bills-btn').show(); dskBills.loadData(); dskBills.spread.refresh(); } }); // 显示层次 (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(() => { ledgerCheck2({ ledgerTree: billsTree, ledgerPos: pos, checkList: checkList, decimal: decimal, checkOption: checkOption, }).then(result => { check2Viewing({ extra: ZhCalc.div(billsTree.datas.length + pos.datas.length, 10000, 0), randomWait: true, prefix: 'check2-', checks: result, checkList: checkList, }); }); }); if (isYb) { let compilationList = []; $('#get-dsk-btn').click(function () { // 判断是否已绑定dsk用户 postData('/profile/dsk/api', {type: 'hadbind'}, function (result) { if (result === 1) { $('#error-dsk .modal-body').find('h5').eq(0).show(); $('#error-dsk .modal-body').find('h5').eq(1).hide(); $('#error-dsk').modal('show'); $('#error-dsk .modal-footer').find('a').eq(0).text('绑定手机'); } else if (result === 2) { $('#error-dsk .modal-body').find('h5').eq(1).show(); $('#error-dsk .modal-body').find('h5').eq(0).hide(); $('#error-dsk').modal('show'); $('#error-dsk .modal-footer').find('a').eq(0).text('绑定账号'); } else { postData('/profile/dsk/api', { type: 'compilation', getProject: 1, compilationId: getLocalCache(dskCompilation) }, function (result) { let html = ''; for (const data of result.compilation) { if (data.ID !== '5c66649650da2d000d8d37ba' && data.ID !== '5b52b027fd3bb0000b257cf8') { html += ``; } } dskAccountData = result.dskAccountData; compilationList = result.compilation; console.log(compilationList); $('#dsk-compilation-list').html(html); $('#add-dsk').modal('show'); setLocalCache(dskCompilation, result.select_compilation); makeDskProjectSjsHtml(result.project); }); } }) }); $('#get-dsk-bills-btn').click(function () { const projectInfo = _.find(dskProjects, {pid: dskAccountData.select_project ? dskAccountData.select_project : null}); changeDskProjectTree(projectInfo, dskAccountData.select_tree ? dskAccountData.select_tree : null); }); $('body').on('change', '#dsk-compilation-list', function () { const compilationId = $(this).val(); setLocalCache(dskCompilation, compilationId); dskProjectSpreadObj.refreshSourceTree(); }); $('.hide-dsk-modal').click(function () { $('#error-dsk').modal('hide'); }); let dp = false; let gsObj = { setting: null, gsSheet: null, grSheet: null, tenderSourceTree: null, grArray: dskProjects ? dskProjects : [], orgSelect: null, }; function makeDskProjectSjsHtml(datas) { if (!dp) { initDskProjectTree(); dp = true; } gsObj.tenderSourceTree = dskProject2Tree.convert(datas); SpreadJsObj.loadSheetData(gsObj.gsSheet, SpreadJsObj.DataType.Tree, gsObj.tenderSourceTree); SpreadJsObj.loadSheetData(gsObj.grSheet, SpreadJsObj.DataType.Data, gsObj.grArray); if (datas.length === 0) { $('#show-project-0').show(); } else { $('#show-project-0').hide(); } } const dskProjectSpreadObj = { _addTender: function (tender) { const gr = gsObj.grArray.find(function (x) { return x.pid === tender.pid; }); const c_id = getLocalCache(dskCompilation); const t = { pid: tender.pid, name: tender.name, compilationId: c_id, compilationName: _.find(compilationList, {ID: c_id}).name }; if (!gr) gsObj.grArray.push(t); return t; }, _removeTender: function (tender) { const gri = gsObj.grArray.findIndex(function (x, i, arr) { return x.pid === tender.pid; }); if (gri >= 0) gsObj.grArray.splice(gri, 1); }, reloadResultData: function () { SpreadJsObj.reLoadSheetData(gsObj.grSheet); }, refreshSourceTree: function () { const c_id = getLocalCache(dskCompilation); if (c_id) { postData('/profile/dsk/api', {type: 'project', compilationId: c_id}, function (result) { makeDskProjectSjsHtml(result); }); } }, gsButtonClicked: function (e, info) { if (!info.sheet.zh_setting) return; const col = info.sheet.zh_setting.cols[info.col]; if (col.field !== 'selected') return; const node = SpreadJsObj.getSelectObject(info.sheet); node.selected = !node.selected; if (node.children && node.children.length > 0) { const posterity = gsObj.tenderSourceTree.getPosterity(node); for (const p of posterity) { p.selected = node.selected; if ((!p.children || p.children.length === 0) && p.type === 2) { if (p.selected) { dskProjectSpreadObj._addTender(p); } else { dskProjectSpreadObj._removeTender(p); } } } SpreadJsObj.reLoadRowData(info.sheet, info.row, posterity.length + 1); } else if (node.type === 2) { if (node.selected) { dskProjectSpreadObj._addTender(node); } else { dskProjectSpreadObj._removeTender(node); } SpreadJsObj.reLoadRowData(info.sheet, info.row, 1); } dskProjectSpreadObj.reloadResultData(); }, deleteGr: function () { if (gsObj.grArray.length === 0) return; if (gsObj.grSheet.getSelections().length === 0) return; const selections = gsObj.grSheet.getSelections(); const sel = selections ? selections[0] : gsObj.grSheet.getSelections()[0]; const row = sel && sel.row !== undefined ? sel.row : -1; if (row === -1 || sel.row + sel.rowCount > gsObj.grArray.length) { return false; } const delList = []; for (let r = 0; r < sel.rowCount; r++) { const select = gsObj.grArray[row + r]; delList.push(select); } _.pullAll(gsObj.grArray, delList); dskProjectSpreadObj.reloadResultData(); dskProjectSpreadObj.refreshSourceTree(); }, }; const initDskProjectTree = function () { const gsSpread = SpreadJsObj.createNewSpread($('#dsk-project-source-spread')[0]); gsObj.gsSheet = gsSpread.getActiveSheet(); const gsSpreadSetting = { cols: [ { title: '选择', field: 'selected', hAlign: 1, width: 40, formatter: '@', cellType: 'checkbox', readOnly: true, }, { title: '名称', field: 'name', hAlign: 0, width: 400, formatter: '@', readOnly: true, folderCell: true, cellType: 'tree' }, ], emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', headColWidth: [0], selectedBackColor: '#fffacd', }; SpreadJsObj.initSheet(gsObj.gsSheet, gsSpreadSetting); gsSpread.bind(spreadNS.Events.ButtonClicked, dskProjectSpreadObj.gsButtonClicked); const grSpread = SpreadJsObj.createNewSpread($('#dsk-project-result-spread')[0]); gsObj.grSheet = grSpread.getActiveSheet(); const grSpreadSetting = { cols: [ { title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 250, formatter: '@', readOnly: true, cellType: 'ellipsisAutoTip', scrollHeightClass: '.modal-height-500' }, { title: '所属编办', colSpan: '1', rowSpan: '1', field: 'compilationName', hAlign: 0, width: 150, formatter: '@', readOnly: true }, ], emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', headColWidth: [] }; SpreadJsObj.initSheet(gsObj.grSheet, grSpreadSetting); // 右键删除已选项目 const gsContextMenuOptions = { selector: '#dsk-project-result-spread', build: function ($trigger, e) { const target = SpreadJsObj.safeRightClickSelection($trigger, e, grSpread); return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader; }, items: { delete: { name: '删除', icon: 'fa-remove', callback: function (key, opt) { dskProjectSpreadObj.deleteGr(); }, disabled: function (key, opt) { const selection = gsObj.grSheet.getSelections(); const sel = selection ? selection[0] : gsObj.grSheet.getSelections()[0]; const row = sel && sel.row !== undefined ? sel.row : -1; if (row === -1 || sel.row + sel.rowCount > gsObj.grArray.length) { return true; } return false; } }, } }; $.contextMenu(gsContextMenuOptions); $('#add-dsk').bind('shown.bs.modal', function () { if (gsSpread) gsSpread.refresh(); if (grSpread) grSpread.refresh(); }); }; const dskProject2Tree = (function () { const treeSetting = { id: 'tmt_id', pid: 'tmt_pid', order: 'seq', level: 'level', rootId: '-1', fullPath: 'full_path', }; const tenderTree = createNewPathTree('gather', treeSetting); function setChildrenNode(node, files, tenders) { const children = _.filter(files, {parentID: node.pid}); const tenderChildren = _.filter(tenders, {parentID: node.pid}); const checkChildren = _.orderBy([...children, ...tenderChildren], ['seq', 'asc']); for (const c of checkChildren) { // if (c.type === 1 && _.filter(files, { parentID: c.ID }).length === 0 && _.filter(tenders, { parentID: c.ID }).length === 0) { // // 判断文件夹下有无东西，没有就不插入 // continue; // } const child = { pid: c.ID, parentID: c.parentID, name: c.name, type: c.type, selected: _.findIndex(gsObj.grArray, {pid: c.ID}) >= 0 }; tenderTree.addNode(child, node); if (c.type === 1) setChildrenNode(child, files, tenders); } } function convert(projects) { tenderTree.clearDatas(); const result = filterFolders(projects); const topLevel = _.orderBy(_.filter(result, {parentID: '-1'}), ['seq', 'asc']); const files = _.filter(result, {type: 1}); const tenders = _.filter(result, {type: 2}); for (const t of topLevel) { const node = { pid: t.ID, parentID: t.parentID, name: t.name, type: t.type, selected: t.type === 2 ? _.findIndex(gsObj.grArray, {pid: t.ID}) >= 0 : false, }; tenderTree.addNode(node, null); if (t.type === 1) setChildrenNode(node, files, tenders); } tenderTree.sortTreeNode(true); return tenderTree; } return {tenderTree, convert} })(); function filterFolders(data) { // 构建ID到节点的映射 const idMap = data.reduce((map, node) => { map[node.ID] = node; return map; }, {}); // 建立父子关系映射 const parentMap = data.reduce((map, node) => { if (node.parentID !== '-1') { if (!map[node.parentID]) { map[node.parentID] = []; } map[node.parentID].push(node.ID); } return map; }, {}); // 检查节点及其子节点是否包含清单(type=1) const hasChecklist = (id) => { const node = idMap[id]; if (node.type === 2) { return true; } if (!parentMap[id]) { return false; } return parentMap[id].some(childID => hasChecklist(childID)); }; // 过滤节点 const filteredIDs = new Set(); data.forEach(node => { if (node.type === 2 || hasChecklist(node.ID)) { let currentID = node.ID; while (currentID !== '-1') { filteredIDs.add(currentID); currentID = idMap[currentID].parentID; } } }); // 返回过滤后的数据 return data.filter(node => filteredIDs.has(node.ID)); } $('#set-dsk-project').click(function () { postData('/profile/dsk/api', { type: 'save_projects', tid: window.location.pathname.split('/')[2], project_list: gsObj.grArray }, function (result) { // dskAccountData.select_project = result; dskProjects = gsObj.grArray; if (!dskAccountData.select_project || dskAccountData.select_project !== result) { dskAccountData.select_project = result; changeDskProject(result); dskBills.spread.refresh(); } setDskProjectSelect(gsObj.grArray); $('#add-dsk').modal('hide'); }); }); $('#add-dsk').on('hide.bs.modal', function () { $('#autoTip').hide(); }); function setDskProjectSelect(projects) { let html = ''; for (const project of projects) { html += ``; } $('#change-dsk-project').html(html); } // 选中所有新增部位/清单 $('#add-all-revise').click(function() { const this_cid = window.location.pathname.split('/')[4]; makeGclGatherData(); postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type: 'get-revise-list', }, function (result) { const addDatas = []; for (const ggd in gclGatherData) { gclGatherData[ggd].code = gclGatherData[ggd].b_code; let hadcid = 0; for (const xmj of gclGatherData[ggd].leafXmjs) { const changeLedger = _.find(result.changeLedgerList, {id: xmj.gcl_id}); const changePos = _.find(result.changePosList, {id: xmj.mx_id, lid: xmj.gcl_id}); if (changeLedger || changePos) { xmj.cid = 1; xmj.ccid = changePos ? changePos.ccid : changeLedger ? changeLedger.ccid : 0; hadcid = 1; } } if (hadcid !== 0) gclGatherData[ggd].cid = 1; } for (const gclInfo of _.filter(gclGatherData, {cid: 1})) { const leafXmjs = _.filter(gclInfo.leafXmjs, {ccid: this_cid}); if (leafXmjs.length > 0) { gclInfo.is_change = 1; for (const xmj of leafXmjs) { if (_.findIndex(changeList, function (item) { return item.gcl_id === xmj.gcl_id && item.mx_id === (xmj.mx_id || ''); }) === -1) { addDatas.push({ lid: xmj.gcl_id, code: gclInfo.code, name: gclInfo.name || '', unit: gclInfo.unit || '', unit_price: gclInfo.unit_price, oamount: xmj.quantity, oamount2: xmj.quantity, bwmx: xmj.bwmx || xmj.jldy || '', xmj_code: xmj.code || '', xmj_jldy: xmj.jldy || '', xmj_dwgc: xmj.dwgc || '', xmj_fbgc: xmj.fbgc || '', xmj_fxgc: xmj.fxgc || '', gcl_id: xmj.gcl_id, mx_id: xmj.mx_id || '', }); } } } } console.log(addDatas); if (addDatas.length > 0) { // 更新至服务器 postData('/tender/' + window.location.pathname.split('/')[2] + '/change/' + window.location.pathname.split('/')[4] + '/information/save', { type: 'add-change-list', postData: addDatas, }, function (result) { toastr.success('已新增当前变更令新增的所有部位/清单'); changeList = result.changeList; const sortData = SpreadJsObj.getSortData(billsSheet); const billsNodes = _.filter(sortData, function (item) { return _.findIndex(addDatas, {gcl_id: item.id}) !== -1; }); for (const billsNode of billsNodes) { billsNode.is_change = 1; } const loadResult = { update: billsNodes }; billsTreeSpreadObj.refreshTree(billsSheet, loadResult); posSpreadObj.loadCurPosData(); }); } else { toastr.warning('未存在当前变更令新增的部位/清单'); } }); }); } }); function findDecimal(unit) { let value = precision.other.value; const changeUnits = precision; for (const d in changeUnits) { if (changeUnits[d].unit !== undefined && changeUnits[d].unit === unit) { value = changeUnits[d].value; break; } } return value; } // 编号排序，多重判断 function sortByCode(a, b, code = 'b_code') { let code1 = a[code].split('-'); let code2 = b[code].split('-'); let code1length = code1.length; let code2length = code2.length; for (let i = 0; i < code1length; i ++) { if (i+1 <= code2length) { if (code1[i] != code2[i]) { if (/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) { return parseInt(code1[i]) - parseInt(code2[i]); } else if (!/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) { return 1; } else if (/^\d+$/.test(code1[i]) && !/^\d+$/.test(code2[i])) { return -1; } else { const str1length = code1[i].length; const str2length = code2[i].length; for (let j = 0; j < str1length; j++) { if (j+1 <= str2length) { if (code1[i].charAt(j) != code2[i].charAt(j)) { return code1[i].charAt(j).charCodeAt() - code2[i].charAt(j).charCodeAt(); } else if (j+1 == str1length && code1[i].charAt(j) == code2[i].charAt(j)) { if (str1length == str2length) { return 0; } else { return str1length - str2length; } } } else { if (j+1 >= str1length) { return 1; } else { return -1; } } } } } else if (i+1 == code1length && code1[i] == code2[i]) { if (code1length == code2length) { return 0; } else { return code1length - code2length; } } } else { if (i+1 >= code1length) { return 1; } else { return -1; } } } }