' + item.name +)
// };
// 右键菜单
const addTag = newTag({ledgerSheet: ledgerSpread.getActiveSheet(), posSheet: posSpread.getActiveSheet(), billsTag});
const billsContextMenuOptions = {
selector: '#ledger-spread',
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
treeOperationObj.loadRelaData();
return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
},
items: {},
};
if (!readOnly) {
billsContextMenuOptions.items.create = {
name: '新增',
icon: 'fa-sign-in',
callback: function (key, opt) {
treeOperationObj.addNode(ledgerSpread.getActiveSheet());
},
disabled: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const sel = selection ? selection[0] : sheet.getSelections()[0];
const row = sel ? sel.row : -1;
const tree = sheet.zh_tree;
if (!tree) return true;
const first = sheet.zh_tree.nodes[row];
let last = first, sameParent = true;
if (sel.rowCount > 1) {
for (let r = 1; r < sel.rowCount; r++) {
const rNode = tree.nodes[sel.row + r];
if (rNode.level > first.level) continue;
if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
sameParent = false;
break;
}
last = rNode;
}
}
const valid = !sheet.zh_setting.readOnly;
return !(valid && first && first.level > 1);
},
visible: function (key, opt) {
return !readOnly;
}
};
billsContextMenuOptions.items.delete = {
name: '删除',
icon: 'fa-remove',
callback: function (key, opt) {
treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
},
disabled: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const sel = selection ? selection[0] : sheet.getSelections()[0];
const row = sel ? sel.row : -1;
const tree = sheet.zh_tree;
if (!tree) return true;
const first = sheet.zh_tree.nodes[row];
let last = first, sameParent = true;
if (sel.rowCount > 1) {
for (let r = 1; r < sel.rowCount; r++) {
const rNode = tree.nodes[sel.row + r];
if (rNode.level > first.level) continue;
if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
sameParent = false;
break;
}
last = rNode;
}
}
const valid = !sheet.zh_setting.readOnly;
return !(valid && first && sameParent && !(first.level === 1 && first.node_type));
},
visible: function (key, opt) {
return !readOnly;
}
};
billsContextMenuOptions.items.sprBase = '----';
}
if (!readOnly) {
billsContextMenuOptions.items.batchInsert = {
name: '批量插入',
type: 'batchInsert',
value: '2',
icon: 'fa-sign-in',
batchInsert: function (obj, root) {
if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
obj.value = obj.max;
toastr.warning('批量插入不可多于' + obj.max);
} else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
obj.value = obj.min;
toastr.warning('批量插入不可少于' + obj.min);
} else {
treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
root.$menu.trigger('contextmenu:hide');
}
},
disabled: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const sel = selection ? selection[0] : sheet.getSelections()[0];
const row = sel ? sel.row : -1;
const tree = sheet.zh_tree;
if (!tree) return true;
const first = sheet.zh_tree.nodes[row];
let last = first, sameParent = true;
if (sel.rowCount > 1) {
for (let r = 1; r < sel.rowCount; r++) {
const rNode = tree.nodes[sel.row + r];
if (rNode.level > first.level) continue;
if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
sameParent = false;
break;
}
last = rNode;
}
}
const valid = !sheet.zh_setting.readOnly;
return !(valid && first && first.level > 1);
},
visible: function (key, opt) {
return !readOnly;
}
};
billsContextMenuOptions.items.batchInsertBillsPos = {
name: '批量插入清单-计量单元',
icon: 'fa-sign-in',
disabled: function (key, opt) {
if (!checkTzMeasureType()) return true;
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row;
const select = ledgerTree.nodes[row];
if (select) {
if (select.code && select.code !== '') {
return !ledgerTree.isLeafXmj(select);
} else {
const parent = ledgerTree.getParent(select);
return !(parent && ledgerTree.isLeafXmj(parent));
}
} else {
return true;
}
},
callback: function (key, opt) {
if (!batchInsertObj) {
batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
} else {
batchInsertObj.initView();
}
$('#batch').modal('show');
},
visible: function (key, opt) {
return !readOnly;
}
};
billsContextMenuOptions.items.batchReplace = {
name: '批量替换清单',
icon: 'fa-sign-in',
callback: function(key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSheet);
if (!node) return;
BatchReplace.load(node.b_code, node.name, node.unit, node.unit_price, treeOperationObj.batchReplace);
},
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSheet);
return !node || !node.b_code;
},
visible: function (key, opt) {
return !readOnly;
}
};
billsContextMenuOptions.items.sprBatch = '----';
}
billsContextMenuOptions.items.copyBlock = {
name: '复制整块',
icon: 'fa-files-o',
callback: function (key, opt) {
/*ledgerSpread.commandManager().execute({
cmd:"copy",
sheetName:ledgerSpread.getActiveSheet().name()
});*/
treeOperationObj.block = [];
const copyBlockList = [];
const sheet = ledgerSpread.getActiveSheet();
const sel = sheet.getSelections()[0];
let iRow = sel.row;
const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
while (iRow < sel.row + sel.rowCount) {
const node = sheet.zh_tree.nodes[iRow];
if (node.ledger_pid !== pid) {
toastr.error('仅可同时选中同层节点');
return;
}
const posterity = sheet.zh_tree.getPosterity(node);
iRow += posterity.length + 1;
posterity.unshift(node);
copyBlockList.push(sheet.zh_tree.getDefaultData(posterity));
}
for (const cbl of copyBlockList) {
for (const b of cbl) {
const posRange = pos.getLedgerPos(b.id);
if (posRange && posRange.length > 0) b.pos = posRange;
const gclRange = ancGcl.getPartData(b.id);
if (gclRange && gclRange.length > 0) b.ancGcl = gclRange;
}
}
setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
},
visible: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row;
const select = ledgerTree.nodes[row];
return select;
},
disabled: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row;
const select = ledgerTree.nodes[row];
return select && select.level <= 1;
}
};
billsContextMenuOptions.items.copyBlockXmj = {
name: '复制整块（只复制项目节）',
icon: 'fa-files-o',
callback: function (key, opt) {
treeOperationObj.block = [];
const copyBlockList = [];
const sheet = ledgerSpread.getActiveSheet();
const sel = sheet.getSelections()[0];
let iRow = sel.row;
const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
while (iRow < sel.row + sel.rowCount) {
const node = sheet.zh_tree.nodes[iRow];
if (node.ledger_pid !== pid) {
toastr.error('仅可同时选中同层节点');
return;
}
const posterity = sheet.zh_tree.getPosterity(node);
iRow += posterity.length + 1;
const copyPosterity = posterity.filter(x => { return !x.b_code; });
copyPosterity.unshift(node);
const copyData = sheet.zh_tree.getDefaultData(copyPosterity);
for (const p of copyData) {
const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || [];
p.is_leaf = children.length === 0;
}
copyBlockList.push(copyData);
}
setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
},
visible: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row;
const select = ledgerTree.nodes[row];
return select;
},
disabled: function (key, opt) {
const sheet = ledgerSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row;
const select = ledgerTree.nodes[row];
return select && select.level <= 1;
}
};
if (!readOnly) {
billsContextMenuOptions.items.pasteBlock = {
name: '粘贴整块',
icon: 'fa-clipboard',
disabled: function (key, opt) {
//const block = treeOperationObj.block || [];
const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
return !(copyInfo && copyInfo.block && copyInfo.block.length > 0);
},
callback: function (key, opt) {
//const block = treeOperationObj.block || [];
const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
if (copyInfo.block.length > 0) {
treeOperationObj.pasteBlock(ledgerSpread, copyInfo);
} else {
document.execCommand('paste');
}
},
visible: function (key, opt) {
return !readOnly;
}
};
}
billsContextMenuOptions.items.sprBlock = '----';
if (!readOnly) {
billsContextMenuOptions.items.sortChildren = {
name: '顺序重排子项编号',
icon: 'fa-sort-numeric-asc',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return !node || !node.code || !node.children || node.children === 0 || node.code.length < 3;
},
callback: function (key, opt) {
treeOperationObj.sortCode(ledgerSpread.getActiveSheet());
},
visible: function (key, opt) {
return !readOnly;
}
};
if (!checkTzMeasureType()) {
billsContextMenuOptions.items.applyDeal2Sgfh = {
name: '填设计量',
icon: 'fa-pencil',
callback: function (key, opt) {
postData(window.location.pathname + '/deal2sgfh', null, function (result) {
ledgerTree.loadDatas(result.bills);
treeCalc.calculateAll(ledgerTree);
SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
});
}
};
}
billsContextMenuOptions.items.sprSort = '----';
}
if (!readOnly) {
const tenderSelect = TenderSelect({
type: 'ledger',
afterLoad: function (result) {
const ledgerSheet = ledgerSpread.getActiveSheet();
const refreshNode = ledgerTree.loadPostData(result);
treeOperationObj.refreshTree(ledgerSheet, refreshNode);
treeOperationObj.refreshOperationValid(ledgerSheet);
}
});
billsContextMenuOptions.items.importExcel = {
name: '导入分项清单Excel',
icon: 'fa-file-excel-o',
disabled: function (key, opt) {
return readOnly;
},
callback: function (key, opt) {
importExcel.doImport({
template: {
hint: '0号台账',
url: 'https://jl-assets.oss-cn-shenzhen.aliyuncs.com/template/A/导入分项清单EXCEL格式.xlsx',
},
filter: true,
callback: function (sheet, filter) {
postDataCompress(window.location.pathname + '/upload-excel/tz', {sheet, filter}, function (result) {
ledgerTree.loadDatas(result.bills);
treeCalc.calculateAll(ledgerTree);
SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
pos.loadDatas(result.pos);
posOperationObj.loadCurPosData();
ancGclObj.loadCurAncillaryGcl();
checkShowLast(result.bills.length);
}, null);
},
// callback: function (file, select) {
// const formData = new FormData();
// formData.append('file', file.files[0]);
// postDataWithFileProgress(window.location.pathname + '/upload-excel?ueType=tz&sheetName=' + select, formData, function (result) {
// ledgerTree.loadDatas(result.bills);
// treeCalc.calculateAll(ledgerTree);
// SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
// pos.loadDatas(result.pos);
// posOperationObj.loadCurPosData();
// }, null);
// }
//u_type: importExcel.uploadType.file,
});
}
};
billsContextMenuOptions.items.importGclBills2Xmj = {
name: '导入工程量清单至项目节',
icon: 'fa-file-excel-o',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return readOnly || !node
|| (node.children && node.children.length > 0)
|| (!_.isNil(node.b_code) && node.b_code !== '');
},
callback: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
importExcel.doImport({
template: {
hint: '工程量清单',
url: '/template/导入工程量清单EXCEL格式.xls',
},
callback: function (sheet) {
postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) {
const ledgerSheet = ledgerSpread.getActiveSheet();
const sel = ledgerSheet.getSelections();
const refreshNode = ledgerTree.loadPostData(result);
treeOperationObj.refreshTree(ledgerSheet, refreshNode);
if (refreshNode.create[0]) {
if (sel && sel[0]) {
ledgerSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
SpreadJsObj.reloadRowsBackColor(ledgerSheet, [sel[0].row, refreshNode.create[0].index]);
} else {
ledgerSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
SpreadJsObj.reloadRowsBackColor(ledgerSheet, [refreshNode.create[0].index]);
}
}
treeOperationObj.refreshOperationValid(ledgerSheet);
}, null);
}
});
}
};
billsContextMenuOptions.items.importOtherTender = {
name: '导入(其他标段)工程量清单至项目节',
icon: 'fa-link',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return readOnly || !node
|| (node.children && node.children.length > 0)
|| !ledgerTree.isLeafXmj(node);
},
callback: function (key, opt) {
tenderSelect.showSelect(SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet()));
}
};
billsContextMenuOptions.items.sprImport = '----';
}
billsContextMenuOptions.items.tag = {
name: '书签',
callback: function (key, opt, menu, e) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
addTag.do(node);
},
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return !node;
}
};
billsContextMenuOptions.items.sprTag = '----';
billsContextMenuOptions.items.showLast = {
name: '显示至最底层',
callback: function (key, opt, menu, e) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
setTimeout(() => {
showWaitingView();
ledgerTree.expandByCustom(x => {
return x.expanded ||(x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0);
});
SpreadJsObj.refreshTreeRowVisible(ledgerSpread.getActiveSheet());
closeWaitingView();
}, 100);
},
};
billsContextMenuOptions.items.exportJSON = {
name: '导出后台标准表json',
callback: function (key, opt, menu, e) {
const result = [];
for (const node of ledgerTree.nodes) {
result.push({
id: node.ledger_id, pid: node.ledger_pid, level: node.level, order: node.order,
is_leaf: !node.children || node.children.length === 0, full_path: node.full_path,
code: node.code || '', b_code: node.b_code || '', name: node.name || '', unit: node.unit || '',
node_type: node.node_type,
});
}
const blob = new Blob([JSON.stringify(result, '', '\t')], { type: 'application/text'});
saveAs(blob, "台账分解.json");
},
visible: function() {
return is_debug;
}
};
if (contractExpr && readOnly) {
billsContextMenuOptions.items.exprTag = '----';
billsContextMenuOptions.items.contractExpr = {
name: '预设本期合同计量公式',
callback: function (key, opt, menu, e) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
if (!contractExprObj) {
contractExprObj = new ContractExpr({ sourceTree: ledgerTree });
}
contractExprObj.initView(node);
$('#contract_expr').modal('show');
},
visible: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
if (node.children && node.children.length > 0) return false;
const posRange = pos.getLedgerPos(node.id);
if (posRange && posRange.length > 0) return false;
return true;
}
};
}
$.contextMenu(billsContextMenuOptions);
const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
// 台账模式加载计量单元数据
if (checkTzMeasureType()) {
$.divResizer({
select: '#main-resize',
callback: function () {
ledgerSpread.refresh();
let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
$(".sp-wrap").height(bcontent-30);
posSpread.refresh();
if (ancGclSpread) ancGclSpread.refresh();
}
});
sjsSettingObj.setGridSelectStyle(posSpreadSetting);
}
posSpreadSetting.headColWidth = [50];
posSpreadSetting.rowHeader = [
{
rowHeaderType: 'tag',
setting: {
indent: 14,
tagSize: 0.8,
tagFont: '8px 微软雅黑',
getColor: function (index, data) {
if (!data) return;
return billsTag.getPosTagsColor(data.lid, data.id);
},
getTagHtml: function (index, data) {
if (!data) return;
const getHtml = function (list) {
if (!list || list.length === 0) return '';
const html = [];
for (const l of list) {
html.push('
');
html.push(`
`, '', '
');
html.push('
');
html.push('
');
}
return html.join('');
};
return getHtml(billsTag.getPosTagsInfo(data.lid, data.id));
}
},
},
];
SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
//绑定计量单元编辑事件
const posOperationObj = {
/**
* 刷新顶部按钮是否可用
* @param sheet
* @param selections
*/
refreshOperationValid: function (sheet, selection) {
const setObjEnable = function (obj, enable) {
if (enable) {
obj.removeClass('disabled');
} else {
obj.addClass('disabled');
}
};
const invalidAll = function () {
setObjEnable($('a[name=pos-opr][type=up-move]'), false);
setObjEnable($('a[name=pos-opr][type=down-move]'), false);
};
const sel = selection ? selection[0] : sheet.getSelections()[0];
const row = sel ? sel.row : -1;
const first = sheet.zh_data[row];
if (!first) {
invalidAll();
return;
}
let last = first;
if (sel.rowCount > 1 && first) {
for (let r = 1; r < sel.rowCount; r++) {
const rNode = sheet.zh_data[sel.row + r];
if (!rNode) break;
last = rNode;
}
}
const preNode = sheet.zh_data[row - 1];
const valid = !sheet.zh_setting.readOnly;
setObjEnable($('a[name=pos-opr][type=up-move]'), valid && first && preNode);
setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1));
},
editStarting: function (e, info) {
posOperationObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
const sel = info.sheet.getSelections();
if (!sel || !sel[0]) return;
const col = info.sheet.zh_setting.cols[sel[0].col];
const node = SpreadJsObj.getSelectObject(info.sheet);
const exprInfo = getExprInfo(col.field);
if (exprInfo) {
if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
}
}
},
loadExprToInput: function () {
const sheet = posSpread.getActiveSheet();
const sel = sheet.getSelections()[0];
if (!sel || !sheet.zh_setting) return;
const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
if (col && col.type === 'Number') {
const data = SpreadJsObj.getSelectObject(sheet);
if (data) {
const exprInfo = getExprInfo(col.field);
const value = exprInfo
? (data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
: data[col.field];
$('#pos-expr').val(value).attr('field', col.field).attr('org', data[col.field])
.attr('readOnly', readOnly || cell.locked()).attr('data-row', sel.row);
} else {
$('#pos-expr').val('').attr('readOnly', true);
$('#pos-expr').removeAttr('data-row');
}
} else {
$('#pos-expr').val('').attr('readOnly', true);
$('#pos-expr').removeAttr('data-row');
}
},
/**
* 加载计量单元 根据当前台账选择节点
*/
loadCurPosData: function () {
//spreadJsObj.reinitSheet(posSpread.getActiveSheet());
const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
if (node) {
const posData = pos.ledgerPos[itemsPre + node.id] || [];
SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
getNodeList(node.id);
} else {
SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
}
posOperationObj.loadExprToInput();
posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
},
baseOpr: function (sheet, type) {
const data = {
updateType: type === 'delete' ? type : 'update',
updateData: [],
};
const selection = sheet.getSelections();
const row = selection[0].row, count = selection[0].rowCount;
const first = sheet.zh_data[row];
if (type === 'delete') {
for (let iRow = 0; iRow < count; iRow++) {
const posData = sheet.zh_data[iRow + row];
if (posData) {
data.updateData.push(sheet.zh_data[iRow + row].id);
}
}
} else if (type === 'up-move') {
const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id};
for (let iRow = 0; iRow < count; iRow++) {
const posData = sheet.zh_data[iRow + row];
if (posData) {
data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row - 1].porder});
preUpdate.porder = posData.porder;
}
}
data.updateData.push(preUpdate);
} else if (type === 'down-move') {
const next = sheet.zh_data[row + count], nextUpdate = {id: next.id};
for (let iRow = count - 1; iRow >= 0; iRow--) {
const posData = sheet.zh_data[iRow + row];
if (posData) {
data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row + 1].porder});
nextUpdate.porder = posData.porder;
}
}
data.updateData.push(nextUpdate);
}
if (data.updateData.length > 0) {
postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
if (type === 'delete') {
for (const p of result.pos) {
const posInfo = pos.getPos(p);
billsTag.afterDeletePos([posInfo]);
}
pos.removeDatas(result.pos);
sheet.deleteRows(row, count);
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
} else {
const updateRst = pos.updateDatas(result.pos);
billsTag.refreshPosTagView(updateRst.update);
const sel = selection[0];
if (sel) {
sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, sheet.zh_data.indexOf(first)]);
}
posOperationObj.loadCurPosData();
}
});
}
},
/**
* 编辑单元格响应事件
* @param {Object} e
* @param {Object} info
*/
editEnded: function (e, info) {
if (info.sheet.zh_setting) {
const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
const col = info.sheet.zh_setting.cols[info.col];
const orgText = posData ? posData[col.field] : null;
const newText = col.wordWrap ? info.editingText : trimInvalidChar(info.editingText);
if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) {
return;
}
const node = posOperationObj.ledgerTreeNode;
if (!node) {
toastr.error('数据错误，请选择台账节点后再试');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
} else if (newText && newText !== '' && node.children && node.children.length > 0) {
toastr.error('父节点不可插入计量单元');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) {
toastr.error('项目节不可插入计量单元');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const data = { updateType: posData ? 'update' : 'add' };
if (!posData) {
const sortData = info.sheet.zh_data;
const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
data.updateData = { lid: node.id, tid: tender.id, porder: order };
} else {
data.updateData = { id: posData.id };
}
if (col.type === 'Number') {
const exprInfo = getExprInfo(col.field);
const num = _.toNumber(newText);
if (_.isFinite(num)) {
data.updateData[col.field] = num;
if (exprInfo) {
data.updateData[exprInfo.expr] = '';
}
} else {
try {
data.updateData[col.field] = ZhCalc.mathCalcExpr(transExpr(newText));
if (exprInfo) {
data.updateData[exprInfo.expr] = newText;
}
} catch(err) {
toastr.error('输入的表达式非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
}
} else if (col.field.indexOf('_expr') > 0) {
const exprInfo = getExprInfo(col.field, true);
if (!exprInfo) return;
if (newText) {
try {
data.updateData[exprInfo.qty] = ZhCalc.mathCalcExpr(transExpr(newText));
data.updateData[exprInfo.expr] = newText;
} catch(err) {
toastr.error('输入的表达式非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
} else {
data.updateData[exprInfo.qty] = 0;
data.updateData[exprInfo.expr] = '';
}
} else {
data.updateData[col.field] = newText;
}
postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
const updateRst = pos.updateDatas(result.pos);
billsTag.refreshPosTagView(updateRst.update);
// 刷新当前行, 不适用于新增（在非下一空白行新增）
if (updateRst.create.length > 0) {
// info.sheet.addRows(info.row, 1);
// if (info.sheet.zh_data.length === 0) {
// info.sheet.zh_data = pos.ledgerPos[itemsPre + node.id] || [];
// }
// SpreadJsObj.reLoadRowData(info.sheet, info.sheet.zh_data.length - 1);
posOperationObj.loadCurPosData();
} else {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
}
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
}
},
/**
* 删除按钮响应事件
* @param sheet
*/
deletePress: function (sheet) {
const self = this;
if (sheet.zh_setting) {
const sortData = sheet.zh_data;
const datas = [], posSelects = [];
const sel = sheet.getSelections()[0];
for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
let bDel = false;
const node = sortData[iRow];
if (node) {
const data = {id: node.id};
for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
const colSetting = sheet.zh_setting.cols[iCol];
const style = sheet.getStyle(iRow, iCol);
if (!style.locked) {
const colSetting = sheet.zh_setting.cols[iCol];
if (colSetting.field.indexOf('_expr') > 0) {
const exprInfo = getExprInfo(colSetting.field, true);
if (!exprInfo) continue;
data[exprInfo.expr] = '';
data[exprInfo.qty] = 0;
} else {
data[colSetting.field] = null;
const exprInfo = getExprInfo(colSetting.field);
if (exprInfo) data[exprInfo.expr] = '';
}
bDel = true;
}
}
if (bDel) {
datas.push(data);
posSelects.push(node);
}
}
}
if (datas.length > 0) {
postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: datas}, function (result) {
const updateRst = pos.updateDatas(result.pos);
billsTag.refreshPosTagView(updateRst.update);
posOperationObj.loadCurPosData();
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
}, function () {
posOperationObj.loadCurPosData();
});
}
}
},
/**
* 删除 计量单元
* @param sheet
*/
deletePos: function (sheet) {
const selection = sheet.getSelections();
const data = {
updateType: 'delete',
updateData: [],
};
const row = selection[0].row, count = selection[0].rowCount;
const sortData = sheet.zh_data;
for (let iRow = 0; iRow < count; iRow++) {
if (sortData[iRow + row]) {
data.updateData.push(sortData[iRow + row].id);
}
}
if (data.updateData.length > 0) {
postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
for (const p of result.pos) {
const posInfo = pos.getPos(p);
billsTag.afterDeletePos([posInfo]);
}
pos.removeDatas(result.pos);
sheet.deleteRows(row, count);
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
});
}
},
insertPos: function (sheet) {
const selection = sheet.getSelections();
const sortData = sheet.zh_data;
const row = selection[0].row;
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
const select = SpreadJsObj.getSelectObject(sheet);
const porder = select ? select.porder : sortData.length + 1;
const data = {
updateType: 'insert',
updateData: [ { lid: node.id, tid: tender.id, porder } ],
};
postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
const updateRst = pos.updateDatas(result.pos);
posOperationObj.loadCurPosData();
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
});
},
/**
* 粘贴单元格响应事件
* @param e
* @param info
*/
clipboardPasted: function (e, info) {
if (info.sheet.getColumnCount() > info.sheet.zh_setting.cols.length) {
info.sheet.setColumnCount(info.sheet.zh_setting.cols.length);
}
const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
if (node.code && (node.code !== '')) {
toastr.error('项目节不可含有清单明细');
posOperationObj.loadCurPosData();
return;
}
if (node.children && (node.children.length > 0)) {
toastr.error('仅清单子项可以含有计量单元');
posOperationObj.loadCurPosData();
return;
}
const hint = {
expr: {type: 'warning', msg: '粘贴了表达式非法，已过滤'},
};
if (info.sheet.zh_setting) {
const data = [];
const sortData = info.sheet.zh_data || [];
if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) {
const nameCol = info.sheet.zh_setting.cols.findIndex(x => { return x.field === 'name'; });
if (info.cellRange.col > nameCol || info.cellRange.col + info.cellRange.colCount < nameCol) {
toastr.warning('新增计量单元请先输入名称');
posOperationObj.loadCurPosData();
return;
}
}
const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
let bPaste = false;
const curRow = info.cellRange.row + iRow;
const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id};
for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
const curCol = info.cellRange.col + iCol;
const colSetting = info.sheet.zh_setting.cols[curCol];
if (!colSetting) continue;
posData[colSetting.field] = colSetting.wordWrap ? info.sheet.getText(curRow, curCol) : trimInvalidChar(info.sheet.getText(curRow, curCol));
if (colSetting.type === 'Number') {
const num = _.toNumber(posData[colSetting.field]);
if (num) {
posData[colSetting.field] = num;
bPaste = true;
} else {
try {
posData[colSetting.field] = ZhCalc.mathCalcExpr(transExpr(posData[colSetting.field]));
const exprInfo = getExprInfo(colSetting.field);
if (exprInfo) {
posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
}
bPaste = true;
} catch (err) {
delete posData[colSetting.field];
toastMessageUniq(hint.expr);
}
}
} else if (colSetting.field.indexOf('_expr') > 0) {
try {
const exprInfo = getExprInfo(colSetting.field, true);
posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
if (posData[exprInfo.expr] || !posData[exprInfo.qty]) {
posData[exprInfo.qty] = ZhCalc.mathCalcExpr(transExpr(posData[exprInfo.expr]));
}
bPaste = true;
} catch (err) {
toastMessageUniq(hint.expr);
}
} else {
bPaste = true;
}
}
if (bPaste) {
data.push(posData);
}
}
if (data.length > 0) {
postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
const updateRst = pos.updateDatas(result.pos);
billsTag.refreshPosTagView(updateRst.update);
posOperationObj.loadCurPosData();
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
posOperationObj.loadCurPosData();
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
});
} else {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
}
}
},
selectionChanged: function (e, info) {
posOperationObj.loadExprToInput();
posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
},
addPegs: function (pegs) {
if (!pegs || pegs.length <= 0) return;
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
if (!node) return;
const sheet = posSpread.getActiveSheet();
const sortData = sheet.zh_data || [];
let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id});
postData('/tender/' + getTenderId() + '/pos/paste', pegs, function (result) {
pos.updateDatas(result.pos);
posOperationObj.loadCurPosData();
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
});
}
};
posSpread.bind(spreadNS.Events.SelectionChanged, posOperationObj.selectionChanged);
if (!posSpreadSetting.readOnly) {
$('a[name="pos-opr"]').click(function () {
posOperationObj.baseOpr(posSpread.getActiveSheet(), this.getAttribute('type'));
});
$('#pos-expr').bind('change onblur', function () {
const expr = $(this);
const posSheet = posSpread.getActiveSheet();
const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
const select = posSheet.zh_data ? posSheet.zh_data[row] : null;
if (!select) return;
const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = expr.val();
if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
const data = {id: select.id};
const exprInfo = getExprInfo(field);
if (newValue !== '') {
const num = _.toNumber(newValue);
if (num) {
data[field] = num;
if (exprInfo) {
data[exprInfo.expr] = '';
}
} else {
try {
data[field] = ZhCalc.mathCalcExpr(transExpr(newValue));
if (exprInfo) {
data[exprInfo.expr] = newValue;
}
} catch (err) {
toastr.error('输入的表达式非法');
return;
}
}
} else {
data[field] = null;
if (exprInfo) {
data[exprInfo.expr] = '';
}
}
// 更新至服务器
postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: data}, function (result) {
const updateRst = pos.updateDatas(result.pos);
SpreadJsObj.reLoadRowData(posSheet, _.toNumber(row));
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
});
});
SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
posSpread.bind(spreadNS.Events.EditStarting, posOperationObj.editStarting);
posSpread.bind(spreadNS.Events.EditEnded, posOperationObj.editEnded);
posSpread.bind(spreadNS.Events.ClipboardPasted, posOperationObj.clipboardPasted);
}
const mergePeg = NewMergePeg({ callback: posOperationObj.addPegs });
// 右键菜单
$.contextMenu({
selector: '#pos-spread',
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
},
items: {
'insert': {
name: '插入',
icon: 'fa-plus',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return node && node.children && node.children.length > 0;
},
callback: function (key, opt) {
posOperationObj.insertPos(posSpread.getActiveSheet());
},
visible: function(key, opt) {
return !readOnly;
}
},
'delete': {
name: '删除',
icon: 'fa-remove',
disabled: function (key, opt) {
const sheet = posSpread.getActiveSheet();
if (sheet.zh_data) {
const selection = sheet.getSelections();
return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
} else {
return true;
}
},
callback: function (key, opt) {
posOperationObj.deletePos(posSpread.getActiveSheet());
},
visible: function(key, opt) {
return !readOnly;
}
},
'merge-peg': {
name: '合并起讫桩号',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
},
callback: function (key, opt) {
mergePeg.show();
},
visible: function(key, opt) {
return !readOnly;
}
},
tag: {
name: '书签',
disabled: function(key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
const pos = SpreadJsObj.getSelectObject(posSpread.getActiveSheet());
return _.isNil(node) || _.isNil(pos);
},
callback: function(key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
const pos = SpreadJsObj.getSelectObject(posSpread.getActiveSheet());
addTag.do(node, pos);
}
}
}
});
// 附属工程量相关
const ancGclSpreadSetting = {
cols: [
{title: '辅材', colSpan: '1', rowSpan: '1', field: 'is_aux', hAlign: 1, width: 40, cellType: 'checkbox'},
{title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 120, formatter: '@'},
{title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 40, formatter: '@', cellType: 'unit'},
{title: '设计量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 60, type: 'Number'},
{title: '设计量公式', colSpan: '1', rowSpan: '1', field: 'expr', hAlign: 0, width: 80, formatter: '@'},
{title: '图册号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'},
{title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 80, formatter: '@'},
],
emptyRows: 3,
headRows: 1,
headRowHeight: [32],
headColWidth: [30],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
};
SpreadJsObj.initSheet(ancGclSheet, ancGclSpreadSetting);
const ancGclObj = {
loadCurAncillaryGcl: function () {
const node = treeOperationObj.getSelectNode(ledgerSheet);
const gclData = node ? ancGcl.getPartData(node.id) || [] : [];
SpreadJsObj.loadSheetData(ancGclSheet, SpreadJsObj.DataType.Data, gclData);
},
baseOpr: function (type) {
const data = {};
const gclRange = ancGclSheet.zh_data;
if (type !== 'insert' && (!gclRange || gclRange.length === 0)) return;
const sel = ancGclSheet.getSelections();
if (!sel[0]) return;
const row = sel[0].row, count = sel[0].rowCount;
const first = gclRange[row];
if (type === 'insert') {
const node = SpreadJsObj.getSelectObject(ledgerSheet);
data.add = [{ lid: node.id, g_order: gclRange.length + 1 }];
} else if (type === 'delete') {
data.del = [];
for (let iRow = 0; iRow < count; iRow++) {
const gclData = gclRange[row + iRow];
if (!gclData) continue;
data.del.push(gclData.id);
}
if (data.del.length === 0) return;
} else if (type === 'up-move') {
data.update = [];
const pre = gclRange[row - 1];
if (!pre) return;
const preUpdate = { id: pre.id };
for (let iRow = 0; iRow < count; iRow++) {
const gclData = gclRange[iRow + row];
if (!gclData) continue;
data.update.push({ id: gclData.id, g_order: gclRange[iRow + row - 1].g_order });
preUpdate.g_order = gclData.g_order;
}
data.update.push(preUpdate);
if (data.update <= 1) return;
} else if (type === 'down-move') {
data.update = [];
const next = gclRange[row + count];
if (!next) return;
const nextUpdate = { id: next.id };
for (let iRow = count - 1; iRow >= 0; iRow--) {
const gclData = gclRange[iRow + row];
if (!gclData) continue;
data.update.push({ id: gclData.id, g_order: gclRange[iRow + row + 1].g_order});
nextUpdate.g_order = gclData.g_order;
}
data.update.push(nextUpdate);
if (data.update <= 1) return;
}
postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function(result) {
ancGcl.updateDatas(result);
ancGclObj.loadCurAncillaryGcl();
if (type !== 'delete') SpreadJsObj.locateData(ancGclSheet, first);
});
},
editStarting: function (e, info) {
ancGclObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSheet);
},
editEnded: function (e, info) {
const setting = info.sheet.zh_setting;
if (!setting) return;
const gclData = SpreadJsObj.getSelectObject(info.sheet);
const col = setting.cols[info.col];
const orgText = gclData ? gclData[col.field] : '', newText = trimInvalidChar(info.editingText);
if (orgText === newText || (!orgText && !newText)) return;
const node = ancGclObj.ledgerTreeNode;
if (!node) {
toastr.error('数据错误，请选择台账节点后再试');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
if (!!newText && node.children && node.children.length > 0) {
toastr.error('父节点不可添加附属工程量');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
if (!!newText && (!node.b_code || node.b_code === '')) {
toastr.error('项目节不可插入附属工程量');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const data = {};
if (gclData) {
const updateData = { id: gclData.id };
if (col.type === 'Number') {
const num = _.toNumber(newText);
if (!_.isFinite(num)) {
toastr.error('输入的数字非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
updateData[col.field] = num;
if (gclData.expr) updateData.expr = '';
} else if (col.field === 'expr') {
try {
updateData.expr = newText;
updateData.quantity = ZhCalc.mathCalcExpr(transExpr(newText));
} catch(err) {
toastr.error('输入的计算式非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
} else {
updateData[col.field] = newText;
}
data.update = [ updateData ];
} else {
const sortData = info.sheet.zh_data;
const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].g_order + 1, sortData.length + 1);
const addData = { lid: node.id, g_order: order };
if (col.type === 'Number') {
const num = _.toNumber(newText);
if (!_.isFinite(num)) {
toastr.error('输入的数字非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
addData[col.field] = num;
if (gclData.expr) addData.expr = '';
} else if (col.field === 'expr') {
try {
addData.expr = newText;
addData.quantity = ZhCalc.mathCalcExpr(transExpr(newText));
} catch(err) {
toastr.error('输入的计算式非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
} else {
addData[col.field] = newText;
}
data.add = [addData];
}
postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
ancGcl.updateDatas(result);
ancGclObj.loadCurAncillaryGcl();
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
},
deletePress: function (sheet) {
const setting = sheet.zh_setting;
if (!setting) return;
const sortData = sheet.zh_data;
if (!sortData || sortData.length === 0) return;
const sel = sheet.getSelections()[0];
const data = { update: [] };
for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
let bDel = false;
const node = sortData[iRow];
if (!node) continue;
const updateData = { id: node.id };
for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
const style = sheet.getStyle(iRow, iCol);
if (style.locked) continue;
const col = setting.cols[iCol];
if (col.field === 'expr') {
updateData.expr = '';
updateData.quantity = 0;
} else {
updateData[col.field] = col.type === 'Number' ? 0 : '';
if (col.field === 'quantity') updateDataexpr = '';
}
bDel = true;
}
if (bDel) data.update.push(updateData);
}
if (data.update.length === 0) return;
postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
ancGcl.updateDatas(result);
ancGclObj.loadCurAncillaryGcl();
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
},
clipboardPasting: function(e, info) {
info.cancel = true;
const node = SpreadJsObj.getSelectObject(ledgerSheet);
if (!node) {
toastr.error('数据错误，请选择台账节点后再试');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
if (node.children && node.children.length > 0) {
toastr.error('父节点不可添加附属工程量');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
if ((!node.b_code || node.b_code === '')) {
toastr.error('项目节不可插入附属工程量');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const hint = {
expr: {type: 'warning', msg: '输入的 计算式 非法，已过滤'},
num: {type: 'warning', msg: '输入的 数字 非法，已过滤'},
};
const setting = info.sheet.zh_setting;
const sortData = info.sheet.zh_data || [];
const pasteData = SpreadJsObj.analysisPasteText(info.pasteData.text);
const data = {};
const analysisData = function(pasteRow, targetData) {
pasteRow.forEach((value, iCol) => {
const col = setting.cols[info.cellRange.col + iCol];
if (col.field === 'expr') {
try {
targetData.expr = trimInvalidChar(value);
targetData.quantity = ZhCalc.mathCalcExpr(transExpr(targetData.expr));
} catch(err) {
toastMessageUniq(hint.expr);
targetData.expr = '';
return;
}
} else if (col.type === 'Number') {
const num = _.toNumber(value);
if (!_.isFinite(num)) {
toastMessageUniq(hint.num);
return;
}
targetData[col.field] = num;
if (col.field === 'quantity') targetData.expr = '';
} else {
targetData[col.field] = value;
}
});
};
for (let iRow = 0; iRow < pasteData.length; iRow++) {
const curRow = iRow + info.cellRange.row;
const gclData = sortData[curRow];
if (gclData) {
if (!data.update) data.update = [];
const updateData = { id: gclData.id };
analysisData(pasteData[iRow], updateData);
data.update.push(updateData);
} else {
if (!data.add) data.add = [];
const addData = { lid: node.id, g_order: curRow + 1};
analysisData(pasteData[iRow], addData);
data.add.push(addData);
}
}
if ((!data.update || data.update.length === 0) && (!data.add || data.add.length === 0)) return;
postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
ancGcl.updateDatas(result);
ancGclObj.loadCurAncillaryGcl();
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
},
buttonClicked: function (e, info) {
const setting = info.sheet.zh_setting;
if (!setting) return;
const node = SpreadJsObj.getSelectObject(info.sheet);
if (!node) {
toastr.warning('请先添加附属工程量再设置辅材');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const col = setting.cols[info.col];
const updateData = { id: node.id };
updateData[col.field] = node[col.field] ? 0 : 1;
postData('/tender/' + getTenderId() + '/anc-gcl/update', { update: [updateData]}, function (result) {
ancGcl.updateDatas(result);
ancGclObj.loadCurAncillaryGcl();
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
},
};
SpreadJsObj.addDeleteBind(ancGclSpread, ancGclObj.deletePress);
ancGclSpread.bind(spreadNS.Events.EditStarting, ancGclObj.editStarting);
ancGclSpread.bind(spreadNS.Events.EditEnded, ancGclObj.editEnded);
ancGclSpread.bind(spreadNS.Events.ClipboardPasting, ancGclObj.clipboardPasting);
ancGclSpread.bind(spreadNS.Events.ButtonClicked, ancGclObj.buttonClicked);
$.contextMenu({
selector: '#anc-gcl-spread',
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, ancGclSpread);
return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
},
items: {
'insert': {
name: '插入',
icon: 'fa-plus',
disabled: function (key, opt) {
const node = SpreadJsObj.getSelectObject(ledgerSheet);
return !node || !node.b_code || (node.children && node.children.length > 0);
},
callback: function (key, opt) {
ancGclObj.baseOpr('insert');
}
},
'delete': {
name: '删除',
icon: 'fa-remove',
disabled: function (key, opt) {
const gclData = SpreadJsObj.getSelectObject(ancGclSheet);
return !gclData;
},
callback: function (key, opt) {
ancGclObj.baseOpr('delete');
}
},
'down-move': {
name: '下移',
icon: 'fa-arrow-down',
disabled: function(key, opt) {
const sel = ancGclSheet.getSelections()[0];
const row = sel ? sel.row : -1;
const first = ancGclSheet.zh_data[row];
const next = ancGclSheet.zh_data[sel.row + sel.rowCount];
return !first || !next;
},
callback: function(key, opt) {
ancGclObj.baseOpr('down-move');
}
},
'up-move': {
name: '上移',
icon: 'fa-arrow-up',
disabled: function(key, opt) {
const sel = ancGclSheet.getSelections()[0];
const row = sel ? sel.row : -1;
const first = ancGclSheet.zh_data[row];
const preNode = ancGclSheet.zh_data[row - 1];
return !first || !preNode;
},
callback: function(key, opt) {
ancGclObj.baseOpr('up-move');
}
},
}
});
$('#filter-anc-gcl').change(function() {
if (this.checked) {
const condition = {};
condition[this.getAttribute('name')] = parseInt(this.value);
ancGcl.filter = condition;
} else {
ancGcl.filter = null;
}
ancGclObj.loadCurAncillaryGcl();
});
postData(window.location.pathname + '/load', {}, function (data) {
ledgerTree.loadDatas(data.bills);
treeCalc.calculateAll(ledgerTree);
checkShowLast(data.bills.length);
pos.loadDatas(data.pos);
ancGcl.loadDatas(data.ancGcl);
for (const t of data.tags) {
t.node = ledgerTree.datas.find(x => { return x.id === t.lid; });
if (t.pos_id) {
const posRange = pos.getLedgerPos(t.lid) || [];
t.pos = posRange.find(x => { return x.id === t.pos_id; });
}
}
billsTag.loadDatas(data.tags);
SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
posOperationObj.loadCurPosData();
SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
ancGclObj.loadCurAncillaryGcl();
SpreadJsObj.resetTopAndSelect(ancGclSheet);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
checkList.loadHisCheckData();
}, null, true);
$.divResizer({
select: '#right-spr',
callback: function () {
ledgerSpread.refresh();
if (posSpread) posSpread.refresh();
if (ancGclSpread) ancGclSpread.refresh();
if (stdXmj) stdXmj.spread.refresh();
if (stdGcl) stdGcl.spread.refresh();
if (dealBills) dealBills.spread.refresh();
if (searchLedger) searchLedger.spread.refresh();
if (errorList) errorList.spread.refresh();
if (checkList) checkList.spread.refresh();
if (gclGather) gclGather.spread.refresh();
}
});
const stdLibCellDoubleClick = function (updateData, stdNode) {
if (!stdNode) return;
const mainNode = SpreadJsObj.getSelectObject(ledgerSheet);
if (!mainNode) return;
if (updateData.postData.stdType === 'gcl') {
if (!!mainNode.code && !ledgerTree.isLeafXmj(mainNode)) {
toastr.warning('非最底层项目下，不应添加清单');
return;
}
}
updateData.postData.id = ledgerTree.getNodeKey(mainNode);
updateData.postData.tender_id = mainNode.tender_id;
postData(window.location.pathname + '/update', updateData, function (result) {
const sel = ledgerSheet.getSelections()[0];
const refreshNode = ledgerTree.loadPostData(result);
treeOperationObj.refreshTree(ledgerSheet, refreshNode);
if (refreshNode.create && refreshNode.create.length > 0) {
ledgerSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
const refreshRow = [sel.row, refreshNode.create[refreshNode.create.length - 1].index];
const curIndex = ledgerTree.nodes.indexOf(mainNode);
if (sel.row !== curIndex && curIndex >= 0) refreshRow.push(curIndex);
SpreadJsObj.reloadRowsBackColor(ledgerSheet, refreshRow);
} else {
const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
if (node) {
ledgerSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
SpreadJsObj.reloadRowsBackColor(ledgerSheet, [sel.row, ledgerTree.nodes.indexOf(node)]);
}
}
treeOperationObj.refreshOperationValid(ledgerSheet);
ledgerSpread.focus();
treeOperationObj.loadRelaData();
});
};
const stdXmjSetting = {
selector: '#std-xmj',
stdType: 'xmj',
libs: stdChapters,
treeSetting: {
id: 'chapter_id',
pid: 'pid',
order: 'order',
level: 'level',
rootId: -1,
keys: ['id', 'list_id', 'chapter_id'],
},
spreadSetting: {
cols: [
{title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
{title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
{title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
],
treeCol: 0,
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
headColWidth: [30],
selectedBackColor: '#fffacd',
},
cellDoubleClick: stdLibCellDoubleClick,
page: 'ledger',
tid: getTenderId(),
};
const stdGclSetting = {
selector: '#std-gcl',
stdType: 'gcl',
libs: stdBills,
treeSetting: {
id: 'bill_id',
pid: 'pid',
order: 'order',
level: 'level',
rootId: -1,
keys: ['id', 'list_id', 'bill_id']
},
spreadSetting: {
cols: [
{title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
{title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
{title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
],
treeCol: 0,
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
headColWidth: [30],
selectedBackColor: '#fffacd',
},
cellDoubleClick: stdLibCellDoubleClick,
page: 'ledger',
tid: getTenderId(),
showAddType: 1,
};
// 展开收起标准清单
$('a', '#side-menu').bind('click', function (e) {
e.preventDefault();
const tab = $(this), tabPanel = $(tab.attr('content'));
// 展开工具栏、切换标签
if (!tab.hasClass('active')) {
// const close = $('.active', '#side-menu').length === 0;
$('a', '#side-menu').removeClass('active');
$('.tab-content .tab-select-show.tab-pane.active').removeClass('active');
tab.addClass('active');
tabPanel.addClass('active');
// $('.tab-content .tab-pane').removeClass('active');
showSideTools(tab.hasClass('active'));
if (tab.attr('content') === '#std-xmj') {
if (!stdXmj) {
stdXmj = $.stdLib(stdXmjSetting);
}
stdXmj.spread.refresh();
} else if (tab.attr('content') === '#std-gcl') {
if (!stdGcl) {
stdGcl = $.stdLib(stdGclSetting);
}
stdGcl.spread.refresh();
} else if (tab.attr('content') === '#deal-bills') {
if (!dealBills) {
dealBills = new DealBills('#deal-bills-spread', {
cols: [
{title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@'},
{title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'},
{title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
{title: '单价', field: 'unit_price', hAlign: 2, width: 50},
{title: '数量', field: 'quantity', hAlign: 2, width: 50},
{title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
],
emptyRows: 3,
headRows: 1,
headRowHeight: [32],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
headColWidth: [30],
selectedBackColor: '#fffacd',
readOnly: true,
});
dealBills.loadData();
}
dealBills.spread.refresh();
} else if (tab.attr('content') === '#search') {
if (!searchLedger) {
searchLedger = $.billsSearch({
selector: '#search',
searchSpread: ledgerSpread,
resultSpreadSetting: {
cols: [
{title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@'},
{title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
{title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@'},
{title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'},
{title: '单价', field: 'unit_price', hAlign: 2, width: 50},
{title: '数量', field: 'quantity', hAlign: 2, width: 50},
{title: '部位', field: 'bw', hAlign: 2, width: 90},
],
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
headColWidth: [30],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
selectedBackColor: '#fffacd',
readOnly: true,
},
afterLocated: function () {
posOperationObj.loadCurPosData();
ancGclObj.loadCurAncillaryGcl();
},
calcSum: function (result) {
const sum = { name: '合计' };
for (const r of result) {
sum.quantity = ZhCalc.add(r.quantity, sum.quantity);
}
return sum;
}
});
}
searchLedger.spread.refresh();
} else if (tab.attr('content') === '#bills-tag') {
// do something
} else if (tab.attr('content') === '#error-list') {
errorList.spread.refresh();
} else if (tab.attr('content') === '#check-list') {
checkList.spread.refresh();
} else if (tab.attr('content') === '#fujian') {
$('#showAttachment').hide();
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
getNodeList(node.id);
getAllList();
} else if (tab.attr('content') === '#gcl-gather') {
gclGather.spread.refresh();
}
} else { // 收起工具栏
tab.removeClass('active');
tabPanel.removeClass('active');
showSideTools(tab.hasClass('active'));
}
ledgerSpread.refresh();
if (posSpread) {
posSpread.refresh();
}
if (ancGclSpread) ancGclSpread.refresh();
});
class DealBills {
constructor (selector, spreadSetting) {
const self = this;
this.obj = $(selector)[0];
this.url = '/tender/' + getTenderId() + '/deal';
this.spreadSetting = spreadSetting;
this.spread = SpreadJsObj.createNewSpread(this.obj);
this.sheet = this.spread.getActiveSheet();
SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
this.OprObj = {
/**
* 删除按钮响应事件
* @param sheet
*/
deletePress: function (sheet) {
if (!sheet.zh_setting || sheet.zh_setting.readOnly) return;
const sortData = sheet.zh_data;
const datas = [];
const sels = sheet.getSelections();
if (!sels || !sels[0]) return;
for (let iRow = sels[0].row; iRow < sels[0].row + sels[0].rowCount; iRow++) {
let bDel = false;
const node = sortData[iRow];
if (node) {
const data = {id: node.id};
for (let iCol = sels[0].col; iCol < sels[0].col + sels[0].colCount; iCol++) {
const colSetting = sheet.zh_setting.cols[iCol];
if (colSetting.field === 'code') {
toastr.error('清单编号不能为空，如需删除签约清单请使用右键删除');
return;
}
const style = sheet.getStyle(iRow, iCol);
if (!style.locked) {
const colSetting = sheet.zh_setting.cols[iCol];
data[colSetting.field] = null;
bDel = true;
}
}
if (bDel) {
datas.push(data);
}
}
}
if (datas.length > 0) {
postData(self.url + '/update', {update: datas}, function (result) {
self.loadUpdateData(result);
SpreadJsObj.reLoadSheetData(sheet);
}, function () {
SpreadJsObj.reLoadSheetData(sheet);
});
}
},
delete: function (sheet) {
if (!sheet.zh_setting || sheet.zh_setting.readOnly) return;
const sortData = sheet.zh_data;
const datas = [];
const sels = sheet.getSelections();
if (!sels || !sels[0]) return;
for (let iRow = sels[0].row, iLen = sels[0].row + sels[0].rowCount; iRow < iLen; iRow++) {
const node = sortData[iRow];
datas.push(node.id);
}
if (datas.length > 0) {
postData(self.url + '/update', {del: datas}, function (result) {
self.loadUpdateData(result);
SpreadJsObj.reLoadSheetData(sheet);
}, function () {
SpreadJsObj.reLoadSheetData(sheet);
});
}
},
editEnded: function (e, info) {
if (!info.sheet.zh_setting || !info.sheet.zh_data || info.sheet.zh_setting.readOnly) return;
const node = info.sheet.zh_data[info.row];
const col = info.sheet.zh_setting.cols[info.col];
const data = {};
if (node) {
data.update = {};
data.update.id = node.id;
const oldValue = node ? node[col.field] : null;
const newValue = trimInvalidChar(info.editingText);
if (oldValue == info.editingText || ((!oldValue || oldValue === '') && (newValue === ''))) {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
data.update[col.field] = newValue;
} else {
if (col.field !== 'code') {
toastr.warning('新增签约清单，请先输入清单编号');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
data.add = {};
data.add.order = info.row + 1;
data.add.code = trimInvalidChar(info.editingText);
}
postData(self.url + '/update', data, function (result) {
self.loadUpdateData(result);
SpreadJsObj.reLoadSheetData(info.sheet);
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
},
clipboardPasting(e, info) {
const setting = info.sheet.zh_setting, sortData = info.sheet.zh_data;
info.cancel = true;
if (!setting || !sortData || setting.readOnly) return;
const pasteData = info.pasteData.html
? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
: (info.pasteData.text === ''
? SpreadJsObj.Clipboard.getAnalysisPasteText()
: SpreadJsObj.analysisPasteText(info.pasteData.text));
const hint = {
code: {type: 'warning', msg: '签约清单编号不可为空，已过滤'},
unit_price: {type: 'warning', msg: '输入的 单价 非法，已过滤'},
quantity: {type: 'warning', msg: '输入的 数量 非法，已过滤'},
};
const uDatas = [], iDatas = [];
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
const curRow = info.cellRange.row + iRow;
const node = sortData[curRow];
let bPaste = false;
const data = {};
for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
const curCol = info.cellRange.col + iCol;
const colSetting = setting.cols[curCol];
const value = trimInvalidChar(pasteData[iRow][iCol]);
if (colSetting.field === 'code' && (!value || value === '')) {
toastMessageUniq(hint.code);
break;
}
if (colSetting.type === 'Number') {
const num = _.toNumber(value);
if (num) {
data[colSetting.field] = num;
bPaste = true;
} else if (colSetting.field === 'unit_price') {
toastMessageUniq(hint.unit_price);
} else if (colSetting.field === 'quantity') {
toastMessageUniq(hint.quantity);
}
} else {
data[colSetting.field] = value;
bPaste = true;
}
}
if (bPaste) {
if (node) {
data.id = node.id;
uDatas.push(data);
} else {
data.order = curRow + 1;
iDatas.push(data);
}
}
}
const updateData = {};
if (uDatas.length > 0) updateData.update = uDatas;
if (iDatas.length > 0) updateData.add = iDatas;
if (uDatas.length > 0 || iDatas.length > 0) {
postData(self.url + '/update', updateData, function (result) {
self.loadUpdateData(result);
SpreadJsObj.reLoadSheetData(info.sheet);
});
} else {
SpreadJsObj.reLoadSheetData(info.sheet);
}
},
};
if (!readOnly) {
this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
const dealSheet = info.sheet;
if (!dealSheet.zh_setting.readOnly) return;
const mainSheet = ledgerSpread.getActiveSheet();
const dealBills = SpreadJsObj.getSelectObject(dealSheet);
if (!dealBills) { return; }
const mainTree = mainSheet.zh_tree;
const mainNode = SpreadJsObj.getSelectObject(mainSheet);
if (!mainNode || !mainTree) { return; }
if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
toastr.error('非最底层项目下，不应添加清单');
return;
}
postData(window.location.pathname + '/update', {
postType: 'add-deal',
postData: {
id: mainNode.ledger_id,
type: mainNode.code ? 'child' : 'next',
dealBills: {
b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
unit_price: dealBills.unit_price,
}
},
}, function (result) {
const refreshData = mainTree.loadPostData(result);
treeOperationObj.refreshTree(mainSheet, refreshData);
const sel = mainSheet.getSelections()[0];
mainSheet.setSelection(refreshData.create[0].index, sel.col, sel.rowCount, sel.colCount);
SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshData.create[0].index]);
treeOperationObj.refreshOperationValid(mainSheet);
ledgerSpread.focus();
posOperationObj.loadCurPosData();
ancGclObj.loadCurAncillaryGcl();
});
});
}
const dealBillsPermission = $('[href="#upload-deal"]').length > 0;
if (!readOnly || dealBillsPermission) {
this.spread.bind(spreadNS.Events.EditEnded, this.OprObj.editEnded);
this.spread.bind(spreadNS.Events.ClipboardPasting, this.OprObj.clipboardPasting);
SpreadJsObj.addDeleteBind(this.spread, this.OprObj.deletePress);
$.contextMenu({
selector: selector,
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.spread);
return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
},
items: {
edit: {
name: '进入编辑模式',
icon: 'fa-edit',
visible: function (key, opt) {
return self.sheet.zh_setting.readOnly;
},
callback: function (key, opt) {
self.sheet.zh_setting.readOnly = false;
SpreadJsObj.refreshSheetReadOnly(self.sheet);
},
},
read: {
name: '退出编辑模式',
icon: 'fa-sign-out',
visible: function (key, opt) {
return !self.sheet.zh_setting.readOnly;
},
callback: function (key, opt) {
self.sheet.zh_setting.readOnly = true;
SpreadJsObj.refreshSheetReadOnly(self.sheet);
},
},
del: {
name: '删除',
icon: 'fa-times',
visible: function (key, opt) {
return !self.sheet.zh_setting.readOnly;
},
disabled: function (key, opt) {
const select = SpreadJsObj.getSelectObject(self.sheet);
return !select;
},
callback: function (key, opt) {
self.OprObj.delete(self.sheet);
},
},
sprEdit: '----',
apply: {
name: '应用全部清单单价至台账',
icon: 'fa-magic',
disabled: function (key, opt) {
const sheet = self.spread.getActiveSheet();
return sheet.getRowCount() === 0 || readOnly;
},
callback: function (key, opt) {
const datas = [], sourceData = self.spread.getActiveSheet().zh_data;
for (const db of sourceData) {
const targets = ledgerTree.nodes.filter(function (x) {
return x.b_code === db.code && x.name === db.name && x.unit === db.unit;
});
for (const t of targets) {
if (t.children && t.children.length > 0) continue;
const data = ledgerTree.getNodeKeyData(t);
data.unit_price = db.unit_price;
datas.push(data);
}
}
if (datas.length > 0) {
doAfterHint({
fun: function() {
postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
const refreshNode = ledgerTree.loadPostData(result);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
});
},
hint: '此操作会替换台账里所有同编号、名称、单位的清单，请谨慎操作',
});
} else {
toastr.warning('没有可应用的清单。');
}
},
}
}
});
}
$('#upload-deal-bills').click(function () {
const file = $('#deal-bills-file')[0];
const formData = new FormData();
formData.append('file', file.files[0]);
postDataWithFile(self.url+'/upload-excel', formData, function (data) {
self.data = data;
SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
$('#upload-deal').modal('hide');
}, function () {
$('#upload-deal').modal('hide');
});
});
this.initDealBillsSearch();
}
search(keyword) {
this.searchResult = [];
this.searchCur = 0;
if (keyword) {
for (const [i, d] of this.data.entries()) {
if (d.code.indexOf(keyword) >= 0 || d.name.indexOf(keyword) >= 0) this.searchResult.push(d);
}
}
$('#dbs-count').html(`结果：${this.searchResult.length}`);
if (this.searchResult.length > 0) SpreadJsObj.locateData(this.sheet, this.searchResult[0]);
}
searchPre() {
this.searchCur = this.searchCur - 1;
if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
SpreadJsObj.locateData(this.sheet, this.searchResult[this.searchCur]);
}
searchNext() {
this.searchCur = this.searchCur + 1;
if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
SpreadJsObj.locateData(this.sheet, this.searchResult[this.searchCur]);
}
searchClear() {
$('#dbs-keyword').val('');
this.searchResult = [];
this.searchCur = 0;
$('#dbs-count').html(`结果：${this.searchResult.length}`);
}
initDealBillsSearch() {
const self = this;
$('#dbs-keyword').change(function () { self.search(this.value); });
$('#dbs-pre').click(function (e) {
self.searchPre();
e.stopPropagation();
});
$('#dbs-next').click(function (e) {
self.searchNext();
e.stopPropagation();
});
$('#dbs-clear').click(function (e) {
self.searchClear();
e.stopPropagation();
});
}
loadData () {
const self = this;
postData(this.url+'/get-data', {}, function (data) {
self.data = data;
SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
if (data.length > 0) self.spread.getActiveSheet().setSelection(0, 0, 1, 1);
});
}
calculateData () {
if (this.data) {
for (const d of this.data) {
d.total_price = _.multiply(d.quantity, d.unit_price);
}
}
}
loadUpdateData(updateData) {
if (updateData.add) {
for (const a of updateData.add) {
this.data.push(a);
}
}
if (updateData.update) {
for (const u of updateData.update) {
const d = this.data.find(function (x) {
return u.id === x.id;
});
if (d) {
_.assign(d, u);
} else {
this.data.push(d);
}
}
}
if (updateData.del) {
_.remove(this.data, function (d) {
return updateData.del.indexOf(d.id) >= 0;
});
}
}
}
class BatchInsertBillsPosObj {
constructor (obj) {
const self = this;
this.obj = obj;
this.billsCount = 6;
this.posCount = 1000;
this.filter = getLocalCache('zh-calc-batch-filter');
if (!this.filter) {
this.filter = '1';
}
$('input[name=batch-filter]')[0].checked = this.filter && this.filter != '0';
// 初始化 清单编号窗口 参数
this.qdSpreadSetting = {
cols: [
{title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
{title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
{title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
{title: '单价', field: 'unit_price', hAlign: 2, width: 50},
{title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
],
emptyRows: this.billsCount,
headRows: 1,
headRowHeight: [32],
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
};
this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
// 初始化 部位数量复核表 参数
this.posSpreadSetting = {
cols: [
{title: '计量单元', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
{title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
],
emptyRows: this.posCount,
headRows: 1,
headRowHeight: [32],
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
};
for (let iNum = 1; iNum <= this.billsCount; iNum++) {
this.posSpreadSetting.cols.push(
{title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
)
}
this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
// 初始化 签约清单 参数
this.dealSpreadSetting = {
cols: [
{title: '清单编号', field: 'code', width: 80, hAlign: 0, formatter: '@', readOnly: true},
{title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@', readOnly: true},
{title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
{title: '单价', field: 'unit_price', hAlign: 2, width: 60, readOnly: true},
],
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
};
this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
this.dealSheet = this.dealSpread.getActiveSheet();
// 初始化 清单编号、部位数量复核表 表格
this.initView();
SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
$.contextMenu({
selector: '.batch-l-t',
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread);
return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
},
items: {
'create': {
name: '新增行',
icon: 'fa-sign-in',
callback: function (key, opt) {
const qdSheet = self.qdSpread.getActiveSheet();
const posSheet = self.posSpread.getActiveSheet();
qdSheet.addRows(qdSheet.getRowCount(), 1);
const index = qdSheet.getRowCount();
qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index);
posSheet.addColumns(posSheet.getColumnCount(), 1);
posSheet.getCell(0, index + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + index);
},
},
'delete': {
name: '删除行',
icon: 'fa-remove',
callback: function (key, opt) {
const qdSheet = self.qdSpread.getActiveSheet();
const posSheet = self.posSpread.getActiveSheet();
const sel = qdSheet.getSelections()[0];
qdSheet.deleteRows(sel.row, sel.rowCount);
posSheet.deleteColumns(sel.row + 2, sel.rowCount);
for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) {
qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1));
}
for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) {
posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1));
}
qdSheet.setSelection(sel.row, sel.col, 1, 1);
},
}
}
});
// 拉取签约清单数据
if (dealBills) {
SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
} else {
postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);
});
}
// 双击签约清单，自动添加到清单编号窗口
this.dealSpread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
const deal = info.sheet.zh_data[info.row];
const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
const sel = qdSheet.getSelections()[0];
qdSheet.getCell(sel.row, 0).value(deal.code);
qdSheet.getCell(sel.row, 1).value(deal.name);
qdSheet.getCell(sel.row, 2).value(deal.unit);
qdSheet.getCell(sel.row, 3).value(deal.unit_price);
if (sel.row + 1 === qdSheet.getRowCount()) {
const count = sel.row + 2;
qdSheet.setRowCount(count);
qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
const colCount = posSheet.getColumnCount() + 1
posSheet.setColumnCount(colCount);
posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('清单' + count);
}
qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
});
this.qdSpread.bind(spreadNS.Events.ClipboardPasting, function (e, info) {
info.cancel = true;
const transpose = $('[name=batch-transpose]')[0].checked;
const pasteData = SpreadJsObj.analysisPasteText(info.pasteData.text, transpose);
const billsSheet = info.sheet, posSheet = self.posSpread.getActiveSheet();
const billsCount = info.sheet.getRowCount(), finalCount = info.cellRange.row + pasteData.length + 1;
SpreadJsObj.beginMassOperation(billsSheet);
if (finalCount > billsCount) {
billsSheet.setRowCount(finalCount);
posSheet.setColumnCount(finalCount + 2);
for (let i = billsCount - 1; i <= finalCount; i++) {
billsSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
posSheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
}
}
for (let iRow = 0; iRow < pasteData.length; iRow++) {
const curRow = iRow + info.cellRange.row;
pasteData[iRow].forEach((value, iCol) => {
billsSheet.getCell(curRow, iCol + info.cellRange.col).value(value);
});
if ([0, 1].indexOf(info.cellRange.col) >= 0) {
const dealBills = self.dealSpread.getActiveSheet().zh_data;
const bills = _.find(dealBills, {code: billsSheet.getText(curRow, 0)});
if (bills) {
billsSheet.getCell(curRow, 1).value(bills.name);
billsSheet.getCell(curRow, 2).value(bills.unit);
billsSheet.getCell(curRow, 3).value(bills.unit_price);
}
}
}
SpreadJsObj.endMassOperation(billsSheet);
});
this.posSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
const billsCount = info.sheet.getColumnCount() - 2, qdSheet = self.qdSpread.getActiveSheet();
const count = qdSheet.getRowCount();
if (billsCount > count) {
qdSheet.setRowCount(billsCount);
for (let i = count + 1; i <= billsCount; i++) {
qdSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
info.sheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
}
}
});
this.qdSpread.bind(spreadNS.Events.EditEnded, function (e, info) {
if (info.col === 0) {
const dealBills = self.dealSpread.getActiveSheet().zh_data;
if (dealBills && dealBills.length > 0) {
const bills = _.find(dealBills, {code: info.editingText});
if (bills) {
info.sheet.getCell(info.row, 1).value(bills.name);
info.sheet.getCell(info.row, 2).value(bills.unit);
info.sheet.getCell(info.row, 3).value(bills.unit_price);
}
}
}
});
this.obj.bind('shown.bs.modal', function () {
self.qdSpread.refresh();
self.posSpread.refresh();
self.dealSpread.refresh();
});
$('#batch-ok').click(function () {
const sheet = ledgerSpread.getActiveSheet();
const sel = sheet.getSelections()[0];
const row = sel.row;
const select = ledgerTree.nodes[row];
if (select) {
const insertData = {};
insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
insertData.id = ledgerTree.getNodeKey(select);
insertData.batchData = self.getBatchData();
if (insertData.batchData.length > 0) {
postData(window.location.pathname + '/update', {postType: 'batch-insert', postData: insertData}, function (data) {
pos.updateDatas(data.pos);
const result = ledgerTree.loadPostData(data.ledger);
treeOperationObj.refreshTree(sheet, result);
sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, result.create[0].index]);
treeOperationObj.refreshOperationValid(sheet);
posOperationObj.loadCurPosData();
ancGclObj.loadCurAncillaryGcl();
self.obj.modal('hide');
}, null, true);
} else {
self.obj.modal('hide');
}
}
});
$('input[name=batch-filter]').change(function () {
setLocalCache('zh-calc-batch-filter', this.checked ? 1 : 0);
});
this.initDealBillsSearch();
}
search(keyword) {
this.searchResult = [];
this.searchCur = 0;
if (keyword) {
for (const [i, d] of this.dealSheet.zh_data.entries()) {
if (d.code.indexOf(keyword) >= 0 || d.name.indexOf(keyword) >= 0) this.searchResult.push(d);
}
}
$('#batch-dbs-count').html(`结果：${this.searchResult.length}`);
if (this.searchResult.length > 0) SpreadJsObj.locateData(this.dealSheet, this.searchResult[0]);
}
searchPre() {
this.searchCur = this.searchCur - 1;
if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
SpreadJsObj.locateData(this.dealSheet, this.searchResult[this.searchCur]);
}
searchNext() {
this.searchCur = this.searchCur + 1;
if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
SpreadJsObj.locateData(this.dealSheet, this.searchResult[this.searchCur]);
}
initDealBillsSearch() {
const self = this;
$('#batch-dbs-keyword').change(function () { self.search(this.value); });
$('#batch-dbs-pre').click(function (e) {
self.searchPre();
e.stopPropagation();
});
$('#batch-dbs-next').click(function (e) {
self.searchNext();
e.stopPropagation();
});
}
// 初始化左侧表格
initView () {
// 初始化 清单编号
const qdSheet = this.qdSpread.getActiveSheet();
qdSheet.setColumnWidth(0, 45, spreadNS.SheetArea.rowHeader);
SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
SpreadJsObj.refreshColumnAlign(qdSheet);
// 清理原有数据
SpreadJsObj.beginMassOperation(qdSheet);
qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
for (let iRow = 1; iRow <= this.billsCount; iRow++) {
qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
}
qdSheet.setSelection(0, 0, 1 ,1);
SpreadJsObj.endMassOperation(qdSheet);
// 初始化 部位数量复核表
const posSheet = this.posSpread.getActiveSheet();
SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
SpreadJsObj.refreshColumnAlign(posSheet);
// 清理原有数据
SpreadJsObj.beginMassOperation(posSheet);
posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
posSheet.setSelection(0, 0, 1 ,1);
SpreadJsObj.endMassOperation(posSheet);
this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
}
// 获取界面数据
getBatchData () {
const result = [];
const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
if (qdSheet.getText(iRow, 0) === '') { continue; }
const qd = {
b_code: qdSheet.getText(iRow, 0),
name: qdSheet.getText(iRow, 1),
unit: qdSheet.getText(iRow, 2),
price: _.toNumber(qdSheet.getText(iRow, 3)),
pos: [],
};
for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
if (value !== 0 && !isNaN(value)) {
qd.pos.push({
name: posSheet.getText(iPosRow, 0),
drawing_code: posSheet.getText(iPosRow, 1),
quantity: value, porder: qd.pos.length + 1,
});
}
}
if (!$('input[name=batch-filter]')[0].checked || qd.pos.length > 0) result.push(qd);
}
return result;
}
}
class ContractExpr {
constructor(setting) {
const self = this;
this.obj = $('#contract_expr');
this.exprObj = $('#ce-expr');
this.exprSpread = SpreadJsObj.createNewSpread($('#expr_spread')[0]);
this.exprSheet = this.exprSpread.getActiveSheet();
const exprSpreadSetting = {
cols: [
{ title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 180, formatter: '@', cellType: 'tree' },
{ title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 100, 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' },
],
emptyRows: 0,
headRows: 2,
headRowHeight: [25, 25],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
readOnly: true,
getColor: function (sheet, data, row, col, defaultColor) {
if (self.targetNode && data && data.id === self.targetNode.id) {
return spreadColor.pay.expr_err;
} if (self.invalidRows && self.invalidRows.indexOf(row + 1) >= 0) {
return spreadColor.pay.yf_without;
} else {
return defaultColor;
}
}
};
sjsSettingObj.setFxTreeStyle(exprSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
SpreadJsObj.initSheet(this.exprSheet, exprSpreadSetting);
this.exprTree = createNewPathTree('ledger', {
id: 'ledger_id',
pid: 'ledger_pid',
order: 'order',
level: 'level',
rootId: -1,
keys: ['id', 'tender_id', 'ledger_id'],
});
this.exprTree.loadDatas(setting.sourceTree.datas);
SpreadJsObj.loadSheetData(this.exprSheet, SpreadJsObj.DataType.Tree, this.exprTree);
// this.exprSpread.bind(spreadNS.Events.SelectionChanged, function(e, info) {
// const select = SpreadJsObj.getSelectObject(info.sheet);
// if (select && self.targetNode && select.id === self.targetNode.id) {
// $('#select-row').html('');
// } else {
// $('#select-row').html(`(${select.code || ''}${select.b_code || ''})`);
// }
// });
this.obj.bind('shown.bs.modal', function () {
self.exprSpread.refresh();
});
$('td[exprValue]').dblclick(function() {
const name = this.getAttribute('name');
let row;
if (name === 'tr') {
row = self.targetRow;
} else {
const node = SpreadJsObj.getSelectObject(self.exprSheet);
if (node.id === self.targetNode.id) return;
row = self.exprTree.nodes.indexOf(node) + 1;
}
if (self.invalidRows.indexOf(row) >= 0) return;
self.exprObj.val(self.exprObj.val() + `<
>`);
});
$('#contract-expr-ok').click(function() {
const exprStr = $('#ce-expr').val().toLowerCase();
if ((!exprStr && !self.orgExpr) || (exprStr === self.orgExpr)) {
self.obj.modal('hide');
return;
}
const [valid, msg] = TreeExprCalc.checkExprValid(exprStr, self.invalidRows);
if (!valid) {
toastr.error(msg);
return;
}
const expr = TreeExprCalc.exprStr2Expr(exprStr);
if (expr.length > 500) {
toastr.error('输入表达式过长');
return;
}
// $('#ce-expr-org').val(expr + ' ' + TreeExprCalc.expr2ExprStr(expr));
postData('expr/save', { calc_module: 'stage', calc_tag: 'contract', calc_id: self.targetNode.id, expr }, function() {
self.targetNode.contract_expr = expr;
self.obj.modal('hide');
});
});
this.initLedgerSearch();
this.initShowLevel();
TreeExprCalc.init({ tree: this.exprTree });
}
search(keyword) {
this.searchResult = [];
this.searchCur = 0;
if (keyword) {
for (const [i, d] of this.exprSheet.zh_tree.nodes.entries()) {
if (d.code && d.code.indexOf(keyword) >= 0) {
this.searchResult.push(d);
continue;
}
if (d.b_code && d.b_code.indexOf(keyword) >= 0) {
this.searchResult.push(d);
continue;
}
if (d.name && d.name.indexOf(keyword) >= 0) {
this.searchResult.push(d);
continue;
}
}
}
$('#expr_search_count').html(`结果：${this.searchResult.length}`);
if (this.searchResult.length > 0) SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[0].ledger_id);
}
searchPre() {
this.searchCur = this.searchCur - 1;
if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[this.searchCur].ledger_id);
}
searchNext() {
this.searchCur = this.searchCur + 1;
if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[this.searchCur].ledger_id);
}
initLedgerSearch() {
const self = this;
this.searchResult = [];
this.searchCur = 0;
$('#expr_search_count').html(`结果：${this.searchResult.length}`);
$('#expr_search_keyword').change(function () { self.search(this.value); });
$('#expr_search_pre').click(function (e) {
self.searchPre();
e.stopPropagation();
});
$('#expr_search_next').click(function (e) {
self.searchNext();
e.stopPropagation();
});
}
initShowLevel(){
// 显示层次
(function (select, sheet) {
$(select).click(function () {
const tag = $(this).attr('tag');
const tree = sheet.zh_tree;
if (!tree) return;
setTimeout(() => {
showWaitingView();
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;
}
closeWaitingView();
}, 100);
});
})('a[name=ce-showLevel]', this.exprSheet);
}
async setTargetNode(node) {
const self = this;
this.targetNode = node;
const relaNode = this.exprTree.getItems(node.ledger_id);
this.invalidNode = this.exprTree.getAllParents(relaNode);
this.invalidRows = this.invalidNode.map(x => {
return self.exprTree.nodes.indexOf(x) + 1;
});
this.targetRow = this.exprTree.nodes.indexOf(relaNode) + 1;
if (node.contract_expr === undefined) {
node.contract_expr = await postDataAsync('expr/load', {calc_module: 'stage', calc_tag: 'contract', calc_id: node.id});
}
this.orgExpr = node.contract_expr;
$('#ce-expr').val(TreeExprCalc.expr2ExprStr(this.orgExpr));
}
initView(node) {
this.orgExpr = '';
this.setTargetNode(node);
$('#expr-hint').html(`${node.code || ''}${node.b_code || ''} ${node.name || ''}`);
$('#target-row').html(`(${node.code || ''}${node.b_code || ''})`);
SpreadJsObj.locateTreeNode(this.exprSheet, node.ledger_id);
SpreadJsObj.reloadRowBackColor(this.exprSheet, 0, this.exprSheet.getRowCount());
this.exprSpread.refresh();
}
}
$('a', '#anc-gcl-nav').bind('click', function(e) {
e.preventDefault();
const tab = $(this);
const showSideTab = function (show) {
const left = $('#pos-spread'), right = $('#pos-right'), 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
*
*/
const percent = 100 - right.outerWidth() /parent.width() * 100;
left.css('width', percent + '%');
} else {
left.width(parent.width());
right.hide();
}
};
if (!tab.hasClass('active')) {
tab.addClass('active');
showSideTab(tab.hasClass('active'));
} else {
tab.removeClass('active');
showSideTab(tab.hasClass('active'));
}
if (posSpread) posSpread.refresh();
if (ancGclSpread) ancGclSpread.refresh();
});
$.divResizer({
select: '#pos-right-spr',
callback: function () {
if (posSpread) posSpread.refresh();
if (ancGclSpread) ancGclSpread.refresh();
}
});
// $('#searchAccount').click(() => {
// const data = {
// keyword: $('#searchName').val(),
// };
// postData('/search/user', data, (data) => {
// const resultDiv = $('#searchResult');
// if (data) {
// $('h5>span', resultDiv).text(data.name);
// $('#addAuditor').attr('auditorId', data.id);
// $('h6', resultDiv).text(data.role);
// $('p', resultDiv).text(data.company);
// resultDiv.show();
// } else {
// toastr.info('未查询到该审核人');
// resultDiv.hide();
// }
// }, () => {
// $('#searchResult').hide();
// });
// });
// // 审批人分组选择
// $('#account_group').change(function () {
// let account_html = '';
// for (const account of accountList) {
// if (parseInt($(this).val()) === 0 || parseInt($(this).val()) === account.account_group) {
// const role = account.role !== '' ? '（' + account.role + '）' : '';
// const company = account.company !== '' ? ' -' + account.company : '';
// account_html += '';
// }
// }
// $('#account_list').html(account_html);
// });
let timer = null;
let oldSearchVal = null;
$('#gr-search').bind('input propertychange', function(e) {
oldSearchVal = e.target.value
timer && clearTimeout(timer)
timer = setTimeout(() => {
const newVal = $('#gr-search').val()
let html = ''
if (newVal && newVal === oldSearchVal) {
accountList.filter(item => item && (item.name.indexOf(newVal) !== -1 || (item.mobile && item.mobile.indexOf(newVal) !== -1))).forEach(item => {
html += `
${item.name}${item.mobile || ''}
${item.role || ''}
`
})
$('.book-list').empty()
$('.book-list').append(html)
} else {
if (!$('.acc-btn').length) {
accountGroup.forEach((group, idx) => {
if (!group) return
html += `
${group.groupName}
`
group.groupList.forEach(item => {
html += `
${item.name}${item.mobile || ''}
${item.role || ''}
`
});
html += '
${index}
`);
html.push('');
for (const auditor of data) {
html.push(`
${auditor.name} ${auditor.role}
`);
}
html.push('
');
if (data[0].audit_type !== auditType.key.common) {
html.push(`
${auditType.info[data[0].audit_type].long}`);
}
if (shenpi_status === shenpiConst.sp_status.sqspr || (shenpi_status === shenpiConst.sp_status.gdzs && index+1 !== datas.length)) {
html.push('
移除');
}
html.push('
${item.name}${item.mobile || ''}
${item.role || ''}
`
});
$('#' + code + '_dropdownMenu .book-list').empty();
$('#' + code + '_dropdownMenu .book-list').append(html);
} else {
if (!$('#' + code + '_dropdownMenu .acc-btn').length) {
accountGroup.forEach((group, idx) => {
if (!group) return;
html += `
${group.groupName}
`;
group.groupList.forEach(item => {
html += `
${item.name}${item.mobile || ''}
${item.role || ''}
`;
});
html += '
');
if (j === 0) {
const auditTypeHtml = auditor.type === auditType.key.common ? '' : `${auditType.info[auditor.audit_type].short}`;
html.push(`| ${i + '审'}${auditTypeHtml} | `);
} else {
html.push(` | `);
}
html.push(` ${auditor.name} ${auditor.role} | `);
html.push(`${ auditor.status !== auditConst.status.uncheck ? auditConst.auditString[auditor.status] : '待审批' } | `);
html.push('');
if (auditor.status === auditConst.status.checking && j === group.length - 1) {
html.push('',
``,
makeSelectAudit(auditor.audit_id+'_add', auditor.audit_id, 'add'),'', '');
}
if (auditor.status === auditConst.status.uncheck) {
if (j === group.length - 1) {
html.push('',
``,
makeSelectAudit(auditor.audit_id+'_add', auditor.audit_id, 'add'),'', '');
if (auditor.audit_type !== auditType.key.common) {
html.push('',
``,
makeSelectAudit(auditor.audit_id+'_add-sibling', auditor.audit_id, 'add-sibling'),'', '');
}
}
html.push('',
``,
makeSelectAudit(auditor.audit_id+'_change', auditor.audit_id, 'change'),'', '');
html.push(`
移除
`);
}
html.push(' | ');
html.push('
');
}
}
return html.join('');
};
$('body').on('click', '#admin-edit-shenpi dl dd', function () {
const id = parseInt($(this).attr('data-id'));
if (!id) return;
let this_aid = parseInt($(this).parents('.book-list').attr('data-aid'));
let this_operate = $(this).parents('.book-list').attr('data-operate');
const user = _.find(accountList, function (item) {
return item.id === id;
});
const auditorIndex = _.findIndex(auditorList, { audit_id: id });
if (auditorIndex !== -1) {
toastr.warning('该审核人已存在，请勿重复添加');
return;
}
const prop = {
operate: this_operate,
old_aid: this_aid,
new_aid: user.id,
};
postData('/tender/' + getTenderId() + '/ledger/audit/save', prop, (datas) => {
auditorList = datas.auditors;
$('#admin-edit-shenpi-list').html(getAdminEditShenpiListHtml(datas.auditorUniqs));
changeLiucheng(datas.auditorUniqs);
});
});
// 移除审批人
$('body').on('click', '.remove-audit', function () {
const id = parseInt($(this).attr('data-id'));
const prop = {
operate: 'del',
old_aid: id,
};
postData('/tender/' + getTenderId() + '/ledger/audit/save', prop, (datas) => {
auditorList = datas.auditors;
$('#admin-edit-shenpi-list').html(getAdminEditShenpiListHtml(datas.auditorUniqs));
changeLiucheng(datas.auditorUniqs);
});
});
const getAuditTypeText = function (type) {
if (type === auditType.key.common) return '';
return `${auditType.info[type].long}`;
};
function changeLiucheng(datas) {
const auditorshtml = [];
let lastAuditorHtml = [];
for (const [index,data] of datas.entries()) {
auditorshtml.push('');
if (index === 0) {
auditorshtml.push('');
} else if (index+1 === datas.length) {
auditorshtml.push('');
} else {
auditorshtml.push('');
}
auditorshtml.push('');
for (const u of data) {
auditorshtml.push(`${u.name}`);
}
auditorshtml.push('');
auditorshtml.push('');
if (data[0].audit_type !== auditType.key.common) auditorshtml.push(`${auditType.info[data[0].audit_type].short}`);
if (index === 0) {
auditorshtml.push('原报');
} else if (index+1 === datas.length) {
auditorshtml.push('终审');
} else {
auditorshtml.push(''+ transFormToChinese(index) +'审');
}
auditorshtml.push('
');
auditorshtml.push('');
if (data[0].status === auditConst.status.uncheck) {
lastAuditorHtml.push('');
if (index < datas.length - 1) {
lastAuditorHtml.push('');
}
lastAuditorHtml.push('');
lastAuditorHtml.push('');
lastAuditorHtml.push(`
${ index !== datas.length - 1 ? data[0].audit_order + '' : '终' }审 ${getAuditTypeText(data[0].audit_type)}
`);
lastAuditorHtml.push('
');
for (const [i, auditor] of data.entries()) {
lastAuditorHtml.push(`
`);
lastAuditorHtml.push(`
${auditor.name}${auditor.role}
`);
lastAuditorHtml.push('
');
lastAuditorHtml.push('
');
lastAuditorHtml.push('
');
}
lastAuditorHtml.push('
');
lastAuditorHtml.push('
' + item.name + '' + item.mobile + '
\n' +
' ' + item.role + '\n' +
' \n';
});
divhtml += ' ' + group.groupName + '\n' +
' \n' + didivhtml +
'
\n';
}
});
let html = '\n' +
'