'use strict'; /** * * * @author Mai * @date * @version */ $(document).ready(function () { autoFlashHeight(); // 根据设置整理Spread设置 const ledgerSpreadSetting = { cols: [ { title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree' }, { title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@' }, { title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@' }, { title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', cellType: 'unit' }, { title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number' }, { title: '标段1|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_1', hAlign: 2, width: 60, type: 'Number' }, { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_1', hAlign: 2, width: 60, type: 'Number' }, { title: '标段2|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_2', hAlign: 2, width: 60, type: 'Number' }, { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_2', hAlign: 2, width: 60, type: 'Number' }, { title: '标段1-标段2|数量', colSpan: '2|1', rowSpan: '1|1', field: 'qty_differ', hAlign: 2, width: 60, type: 'Number' }, { title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'tp_differ', hAlign: 2, width: 60, type: 'Number' }, ], emptyRows: 2, headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, getColor: function (sheet, data, row, col, defaultColor) { function checkDiffer(data) { return !checkZero(data.qty_differ) && !checkZero(data.tp_differ); } return data && checkDiffer(data) ? '#F2DEDE' : defaultColor; } }; const posSpreadSetting = { cols: [ { title: '计量单元', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@' }, { title: '数量|标段1', colSpan: '3|1', rowSpan: '1|1', field: 'qty_1', hAlign: 2, width: 80, type: 'Number' }, { title: '|标段2', colSpan: '|1', rowSpan: '|1', field: 'qty_2', hAlign: 2, width: 80, type: 'Number' }, { title: '|标段1-标段2', colSpan: '|1', rowSpan: '|1', field: 'qty_differ', hAlign: 2, width: 80, type: 'Number' }, ], emptyRows: 3, headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, getColor: function (sheet, data, row, col, defaultColor) { function checkDiffer(data) { const fieldSufs = sheet.zh_setting.fieldSufs; if (fieldSufs.length <= 1) return false; const base = data['gather_qty' + fieldSufs[0]]; for (let i = 1; i < fieldSufs.length; i++) { const compare = data['gather_qty' + fieldSufs[i]]; if ((base || compare) && (compare !== base)) return true; } } return checkDiffer(data) ? '#F2DEDE' : defaultColor; } }; // 初始化台账 const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]); const billsSheet = billsSpread.getActiveSheet(); SpreadJsObj.initSheet(billsSheet, ledgerSpreadSetting); // 初始化部位 const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]); const posSheet = posSpread.getActiveSheet(); SpreadJsObj.initSheet(posSheet, posSpreadSetting); // const billsTree = new CompareTree({ // id: 'id', // pid: 'pid', // order: 'order', // level: 'level', // rootId: -1, // loadInfo1: function (node, source) { // node.qty_1 = source.quantity; // node.tp_1 = source.total_price; // }, // loadInfo2: function (node, source) { // node.qty_2 = source.quantity; // node.tp_2 = source.total_price; // }, // calcDiffer: function (node) { // node.qty_differ = ZhCalc.sub(node.qty_1, node.qty_2); // node.tp_differ = ZhCalc.sub(node.tp_1, node.tp_2); // }, // }); const billsTree = createNewPathTree('compare', { id: 'id', pid: 'pid', order: 'order', level: 'level', rootId: -1, loadInfo1: function (node, source) { node.qty_1 = source.quantity; node.tp_1 = source.total_price; }, loadInfo2: function (node, source) { node.qty_2 = source.quantity; node.tp_2 = source.total_price; }, calcDiffer: function (node) { node.qty_differ = ZhCalc.sub(node.qty_1, node.qty_2); node.tp_differ = ZhCalc.sub(node.tp_1, node.tp_2); }, }); // // 获取部位明细数据 // function loadPosData(iRow) { // const node = billsSheet.zh_tree.nodes[iRow]; // if (node) { // SpreadJsObj.loadSheetData(posSheet, SpreadJsObj.DataType.Data, node.pos); // } else { // SpreadJsObj.loadSheetData(posSheet, SpreadJsObj.DataType.Data, []); // } // SpreadJsObj.resetTopAndSelect(posSheet); // } // // 切换清单行,读取所属项目节数据 // billsSheet.bind(spreadNS.Events.SelectionChanged, function (e, info) { // if (info.newSelections) { // const iNewRow = info.newSelections[0].row; // if (info.oldSelections) { // const iOldRow = info.oldSelections[0].row; // if (iNewRow !== iOldRow) { // loadPosData(iNewRow); // } // } else { // loadPosData(iNewRow); // } // } // }); // 选择 $('#select-ok').click(function () { let id1, id2; try { id1 = parseInt($('input[name=id1]').val()); id2 = parseInt($('input[name=id2]').val()); if (id1 > 0 && id2 > 0) { postData(window.location.pathname + '/load', { tid1: id1, tid2: id2 }, function (result) { // 初始化基础数据分析 const tenderTreeSetting = { id: 'ledger_id', pid: 'ledger_pid', order: 'order', level: 'level', rootId: -1, keys: ['id', 'tender_id', 'ledger_id'], calcFields: ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'], }; const tender1 = { billsTree: createNewPathTree('ledger', tenderTreeSetting), }; tender1.billsTree.loadDatas(result.tender1.bills); treeCalc.calculateAll(tender1.billsTree); const col1 = ledgerSpreadSetting.cols.find(function (x) { return x.field === 'qty_1'; }); col1.title = result.tender1.name + '|数量'; const tender2 = { billsTree: createNewPathTree('ledger', tenderTreeSetting), }; tender2.billsTree.loadDatas(result.tender2.bills); treeCalc.calculateAll(tender2.billsTree); const col2 = ledgerSpreadSetting.cols.find(function (x) { return x.field === 'qty_2'; }); col2.title = result.tender2.name + '|数量'; SpreadJsObj.initSheet(billsSheet, ledgerSpreadSetting); billsTree.loadCompareData(tender1, tender2); SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree); $('#data-select').modal('hide'); }); } } catch (err) { toastr.error('输入的标段ID非法'); } }); // 显示层次 (function (select, sheet) { $(select).click(function () { if (!sheet.zh_tree) return; const tag = $(this).attr('tag'); const tree = sheet.zh_tree; 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; case "curMeasure": tree.expandByCalcFields(); SpreadJsObj.refreshTreeRowVisible(sheet); break; } }); })('a[name=showLevel]', billsSheet); // 导航栏 $.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(); posSpread.refresh(); } }); // 上下窗口resizer $.divResizer({ select: '#main-resize', callback: function () { billsSpread.refresh(); let bcontent = $(".bcontent-wrap").length > 0 ? $(".bcontent-wrap").height() : 0; $(".sp-wrap").height(bcontent - 30); posSpread.refresh(); } }); });