'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' : '#ffffff') : '#ffffff'; } }; 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 (!isTz) leafXmjSpreadSetting.cols.splice(1, 1); 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(''); if (d.code) { html.push('', d.code, ''); html.push('', d.name, ''); } else { html.push('', d.name, ''); } html.push('', d.deal_bills_tp ? d.deal_bills_tp : '', ''); html.push('', d.total_price ? d.total_price : '', ''); html.push('', d.compare_tp ? d.compare_tp : '', ''); html.push(''); } } $('#chapter-list').html(html.join('')); } postData(window.location.pathname + '/load', {}, function (data) { gclGatherModel.loadLedgerData(data.bills); gclGatherModel.loadPosData(data.pos); gclGatherModel.loadDealBillsData(data.dealBills); gclGatherData = gclGatherModel.gatherGclData(); gclGatherModel.checkDiffer(gclGatherData); for (const gcl of gclGatherData) { gcl.compare_qty = ZhCalc.sub(gcl.quantity, gcl.deal_bills_qty); gcl.compare_tp = ZhCalc.sub(gcl.total_price, gcl.deal_bills_tp); gcl.compare_differ = !checkZero(gcl.compare_qty) || !checkZero(gcl.compare_tp); } SpreadJsObj.loadSheetData(gclSheet, SpreadJsObj.DataType.Data, gclGatherData); checkCompareData(); loadLeafXmjData(0); const chapterData = gclGatherModel.gatherChapterData(chapter, data.spec, ['total_price']); for (const c of chapterData) { c.compare_tp = ZhCalc.sub(c.total_price, c.deal_bills_tp); } generateChapterHtml(chapterData); }, null, true); $('#compare-tag').click(() => { // const rows = []; // for (let i = 0; i< gclSheet.getRowCount(); ++i) { // rows.push(i); // } // SpreadJsObj.reloadRowsBackColor(gclSheet, rows); SpreadJsObj.reLoadSheetData(gclSheet); }); // 展开收起附件 $('a', '.right-nav').bind('click', function () { const tab = $(this), tabPanel = $(tab.attr('content')); if (!tab.hasClass('active')) { $('a', '.side-menu').removeClass('active'); $('.tab-content .tab-select-show').removeClass('active'); tab.addClass('active'); tabPanel.addClass('active'); showTools(tab.hasClass('active')); } else { tab.removeClass('active'); tabPanel.removeClass('active'); showTools(tab.hasClass('active')); } gclSpread.refresh(); leafXmjSpread.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(); gclSpread.refresh(); leafXmjSpread.refresh(); } }); $.divResizer({ select: '#main-resize', callback: function () { gclSpread.refresh(); let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0; $(".sp-wrap").height(bcontent-30); leafXmjSpread.refresh(); } }); $.divResizer({ select: '#right-spr', callback: function () { gclSpread.refresh(); leafXmjSpread.refresh(); } }); $('#exportExcel').click(function () { const data = []; const setting = { cols: [ {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 70, formatter: '@'}, {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 300, formatter: '@'}, {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@'}, {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'}, {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 100, formatter: '@'}, {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'}, {title: '单位工程', colSpan: '1', rowSpan: '2', field: 'dwgc', hAlign: 0, width: 80, formatter: '@'}, {title: '分部工程', colSpan: '1', rowSpan: '2', field: 'fbgc', hAlign: 0, width: 80, formatter: '@'}, {title: '分项工程', colSpan: '1', rowSpan: '2', field: 'fxgc', hAlign: 0, width: 80, formatter: '@'}, {title: '细目', colSpan: '1', rowSpan: '2', field: 'jldy', hAlign: 0, width: 80, formatter: '@'}, {title: '计量单元', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 80, formatter: '@'}, {title: '图册号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'}, ], headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: 'bold 10px 微软雅黑', font: '10px 微软雅黑' }; if (!gclSheet.zh_data || gclSheet.zh_data.length === 0) return; for (const gcl of gclSheet.zh_data) { data.push({ b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price, deal_bills_qty: gcl.deal_bills_qty, deal_bills_tp: gcl.deal_bills_tp, quantity: gcl.quantity, total_price: gcl.total_price, compare_qty: gcl.compare_qty, compare_tp: gcl.compare_tp, }); if (gcl.leafXmjs && gcl.leafXmjs.length > 0) { for (const xmj of gcl.leafXmjs) { data.push({ code: xmj.code, quantity: xmj.quantity, dwgc: xmj.dwgc, fbgc: xmj.fbgc, fxgc: xmj.fxgc, jldy: xmj.jldy, bwmx: xmj.bwmx, drawing_code: xmj.drawing_code, }); } } } SpreadExcelObj.exportSimpleXlsxSheet(setting, data, $('.sidebar-title').attr('data-original-title') + "-清单对比.xlsx"); }); });