'use strict'; /** * * * @author Mai * @date * @version */ const showTools = function (show) { const left = $('#left-view'), right = $('#right-view'), parent = left.parent(); if (show) { right.show(); autoFlashHeight(); /** * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px * 故需要通过最终的parent.width再计算一次left.width * * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width? * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width * */ //left.css('width', parent.width() - right.outerWidth()); //left.css('width', parent.width() - right.outerWidth()); const percent = 100 - right.outerWidth() /parent.width() * 100; left.css('width', percent + '%'); } else { right.hide(); left.css('width', '100%'); } }; $(document).ready(() => { showTools(true); autoFlashHeight(); const gclSpread = SpreadJsObj.createNewSpread($('#gcl-spread')[0]); const gclSpreadSetting = { cols: [ {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 120, formatter: '@'}, {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@'}, {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', cellType: 'unit'}, {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'}, {title: '签约清单|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_bills_qty', hAlign: 2, width: 80, type: 'Number'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_bills_tp', hAlign: 2, width: 80, type: 'Number'}, {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'}, {title: '签约-台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'compare_qty', hAlign: 2, width: 80, type: 'Number'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'compare_tp', hAlign: 2, width: 80, type: 'Number'}, ], emptyRows: 0, headRows: 2, headRowHeight: [25, 25], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, localCache: { key: 'ledger-gather-gcl', colWidth: true, }, getColor: function (sheet, data, row, col, defaultColor) { return data ? $('#compare-tag')[0].checked && data.compare_differ ? '#f8d7da' : (data.differ ? '#FFE699' : defaultColor) : defaultColor; //return data && data.differ ? '#FFE699' : defaultColor; } }; if (thousandth) sjsSettingObj.setTpThousandthFormat(gclSpreadSetting); SpreadJsObj.initSheet(gclSpread.getActiveSheet(), gclSpreadSetting); const gclSheet = gclSpread.getActiveSheet(); const leafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-spread')[0]); const leafXmjSpreadSetting = { cols: [ {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 120, formatter: '@'}, {title: '台账数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '单位工程', colSpan: '1', rowSpan: '1', field: 'dwgc', hAlign: 0, width: 100, formatter: '@'}, {title: '分部工程', colSpan: '1', rowSpan: '1', field: 'fbgc', hAlign: 0, width: 100, formatter: '@'}, {title: '分项工程', colSpan: '1', rowSpan: '1', field: 'fxgc', hAlign: 0, width: 100, formatter: '@'}, {title: '细目', colSpan: '1', rowSpan: '1', field: 'jldy', hAlign: 0, width: 100, formatter: '@'}, {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'}, {title: '图册号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 120, formatter: '@'}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, localCache: { key: 'ledger-gather-leafXmj', colWidth: true, }, }; if (thousandth) sjsSettingObj.setTpThousandthFormat(leafXmjSpreadSetting); SpreadJsObj.initSheet(leafXmjSpread.getActiveSheet(), leafXmjSpreadSetting); const leafXmjSheet = leafXmjSpread.getActiveSheet(); let gclGatherData; // 获取项目节数据 function loadLeafXmjData(iGclRow) { const gcl = gclGatherData[iGclRow]; SpreadJsObj.resetTopAndSelect(leafXmjSheet); if (gcl) { SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, gcl.leafXmjs); } else { SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, []); } } // 标红显示 签约-台账≠0 function checkCompareData() { const sheet = gclSheet; const bCompare = $('#compare-tag')[0].checked; SpreadJsObj.beginMassOperation(gclSheet); for (let iRow = 0, iLength = gclSheet.getRowCount(); iRow < iLength; iRow++) { const node = gclSheet.zh_data[iRow]; if (node) { const bDiffer = node.compare_qty ? !checkZero(Math.abs(node.compare_qty)) : !checkZero(Math.abs(node.compare_tp)); const color = bCompare && bDiffer ? '#f8d7da' : ''; sheet.getRange(iRow, -1, 1, -1).backColor(color); } } SpreadJsObj.endMassOperation(gclSheet); } // 切换清单行,读取所属项目节数据 gclSpread.getActiveSheet().bind(spreadNS.Events.SelectionChanged, function (e, info) { const iNewRow = info.newSelections[0].row; if (!info.oldSelections || iNewRow !== info.oldSelections[0].row) { loadLeafXmjData(iNewRow); } }); function generateChapterHtml(data) { const html = []; if (data) { for (const d of data) { if (['1000', '1100', '1200', '1300'].indexOf(d.code) >= 0) { if (checkZero(d.total_price) && checkZero(d.deal_bills_tp)) { continue; } } html.push('