'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");
});
});