'use strict'; /** * * * @author Mai * @date 2020/10/28 * @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(() => { let compareTag = $('input[name=compareTag]:checked').val(); 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: 'new_quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'new_total_price', hAlign: 2, width: 80, type: 'Number'}, {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'org_quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'org_total_price', 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) { if (!data) return '#ffffff'; // if ((col.field === 'deal_bills_qty' || col.field === 'deal_bills_tp') && data.deal_differ_qty) // return '#f8d7da'; // if ((col.field === 'org_quantity' || col.field === 'org_total_price') && data.differ_qty) // return '#f8d7da'; if (compareTag === 'deal' && data.deal_differ_qty) return '#f8d7da'; if (compareTag === 'org' && data.differ_qty) return '#f8d7da'; return data.differ ? '#FFE699' : '#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: '2', field: 'code', hAlign: 0, width: 120, formatter: '@'}, {title: '修订台账|数量', colSpan: '1', rowSpan: '1|1', field: 'new_quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '原台账|数量', colSpan: '1', rowSpan: '1|1', field: 'org_quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '单位工程', colSpan: '1', rowSpan: '2', field: 'dwgc', hAlign: 0, width: 100, formatter: '@'}, {title: '分部工程', colSpan: '1', rowSpan: '2', field: 'fbgc', hAlign: 0, width: 100, formatter: '@'}, {title: '分项工程', colSpan: '1', rowSpan: '2', field: 'fxgc', hAlign: 0, width: 100, formatter: '@'}, {title: '细目', colSpan: '1', rowSpan: '2', field: 'jldy', hAlign: 0, width: 100, formatter: '@'}, {title: '计量单元', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'}, {title: '图册号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 120, formatter: '@'}, ], emptyRows: 0, headRows: 1, headRowHeight: [25, 25], headColWidth: [30], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, localCache: { key: 'ledger-gather-leafXmj', colWidth: true, }, }; if (!isTz) leafXmjSpreadSetting.cols.splice(1, 2); if (thousandth) sjsSettingObj.setTpThousandthFormat(leafXmjSpreadSetting); SpreadJsObj.initSheet(leafXmjSpread.getActiveSheet(), leafXmjSpreadSetting); const leafXmjSheet = leafXmjSpread.getActiveSheet(); const gatherLeafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-gather-spread')[0]); const gatherLeafXmjSpreadSetting = { cols: [ {title: '单位工程', colSpan: '1', rowSpan: '1', field: 'dwgc', hAlign: 0, width: 100, formatter: '@', visible: false}, {title: '分部工程', colSpan: '1', rowSpan: '1', field: 'fbgc', hAlign: 0, width: 100, formatter: '@', visible: false}, {title: '分项工程', colSpan: '1', rowSpan: '1', field: 'fxgc', hAlign: 0, width: 100, formatter: '@', visible: false}, {title: '细目', colSpan: '1', rowSpan: '1', field: 'jldy', hAlign: 0, width: 100, formatter: '@', visible: false}, {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'}, {title: '修订台账', colSpan: '1', rowSpan: '1', field: 'new_quantity', hAlign: 2, width: 80, type: 'Number'}, {title: '原台账', colSpan: '1', rowSpan: '1', field: 'org_quantity', hAlign: 2, width: 80, type: 'Number'}, ], 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(gatherLeafXmjSpreadSetting); const gatherLeafXmjSheet = gatherLeafXmjSpread.getActiveSheet(); SpreadJsObj.initSheet(gatherLeafXmjSheet, gatherLeafXmjSpreadSetting); let gclData = []; // 获取项目节数据 function loadLeafXmjData(iGclRow) { const gcl = gclData[iGclRow]; SpreadJsObj.resetTopAndSelect(leafXmjSheet); if (gcl) { SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, gcl.leafXmjs); } else { SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, []); } } function loadGatherLeafXmjData(iGclRow) { const gcl = iGclRow ? gclData[iGclRow] : SpreadJsObj.getSelectObject(gclSheet); SpreadJsObj.resetTopAndSelect(gatherLeafXmjSheet); if (gcl) { SpreadJsObj.loadSheetData(gatherLeafXmjSheet, SpreadJsObj.DataType.Data, gcl.gatherLeafXmjs); } else { SpreadJsObj.loadSheetData(gatherLeafXmjSheet, SpreadJsObj.DataType.Data, []); } } // 切换清单行,读取所属项目节数据 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); loadGatherLeafXmjData(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.new_total_price) && checkZero(d.org_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.new_total_price ? d.new_total_price : '', ''); html.push('', d.org_total_price ? d.org_total_price : '', ''); html.push(''); } } $('#chapter-list').html(html.join('')); } postData('load', {filter: 'bills;pos;reviseBills;revisePos;dealBills;spec;price'}, function (data) { const setting = { tree: { id: 'ledger_id', pid: 'ledger_pid', order: 'order', level: 'level', rootId: -1, keys: ['id', 'tender_id', 'ledger_id'], stageId: 'id', }, pos: { id: 'id', ledgerId: 'lid' }, billsFields: ['quantity', 'total_price'], posFields: ['quantity'], chapterFields: ['total_price'], }; gclCompareModel.init(gclData, chapter, data.spec); setting.prefix = 'new_'; gclCompareModel.gatherReviseLedgerData(data.reviseBills, data.revisePos, setting, data.price, decimal); setting.prefix = 'org_'; gclCompareModel.gatherLedgerData(data.bills, data.pos, setting); gclCompareModel.gatherDealBills(data.dealBills); gclCompareModel.checkDiffer(); gclCompareModel.reGatherLeafXmj(); SpreadJsObj.loadSheetData(gclSheet, SpreadJsObj.DataType.Data, gclData); loadLeafXmjData(0); loadGatherLeafXmjData(0); const chapterData = gclCompareModel.chapterData(); generateChapterHtml(chapterData); }, null, true); // 展开收起附件 $('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(); gatherLeafXmjSpread.refresh(); }); // 下部设置显示相关 $('a', '[name=pos-tab]').click(function() { const relaTab = this.getAttribute('href'); const optionTab = $('#optionTab').children(); for (const ot of optionTab) { if (ot.getAttribute('rela-tab') === relaTab) { $(ot).show(); } else { $(ot).hide(); } } }); $('[name=gather-xmj]').change(function() { const checkOption = $('[name=gather-xmj]:checked'); if (checkOption.length === 0) { toastr.warning('请至少选择一个汇总条件'); return; } const fields = []; for (const co of checkOption) { fields.push(co.value); } for (const col of gatherLeafXmjSpreadSetting.cols) { if (col.formatter !== '@') continue; col.visible = col.type === 'Number' || fields.indexOf(col.field) >= 0; } gclCompareModel.reGatherLeafXmj(fields); SpreadJsObj.refreshColumnVisible(gatherLeafXmjSheet); loadGatherLeafXmjData(); }); $.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(); gatherLeafXmjSpread.refresh(); } }); $.divResizer({ select: '#main-resize', callback: function () { gclSpread.refresh(); let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0; $(".sp-wrap").height(bcontent-30); leafXmjSpread.refresh(); gatherLeafXmjSpread.refresh(); } }); $('input[name=compareTag]').change(() => { compareTag = $('input[name=compareTag]:checked').val(); SpreadJsObj.reLoadSheetData(gclSheet); }); });