' + item.name +)
// };
// 右键菜单
const addTag = newTag({ledgerSheet: ledgerSpread.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 = '----';
}
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;
}
}
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) {
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.sprBatch = '----';
}
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();
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);
},
};
$.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();
}
});
sjsSettingObj.setGridSelectStyle(posSpreadSetting);
}
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') {
pos.removeDatas(result.pos);
sheet.deleteRows(row, count);
const loadResult = ledgerTree.loadPostData(result.ledger);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
} else {
pos.updateDatas(result.pos);
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 = 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] = math.evaluate(transExpr(newText));
if (exprInfo) {
data.updateData[exprInfo.expr] = newText;
}
} catch(err) {
toastr.error('输入的表达式非法');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
}
} else {
data.updateData[col.field] = newText;
}
postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
const updateRst = pos.updateDatas(result.pos);
// 刷新当前行, 不适用于新增（在非下一空白行新增）
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];
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) {
pos.updateDatas(result.pos);
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) {
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) {
if (info.cellRange.col !== 0) {
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] = 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] = math.evaluate(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 {
bPaste = true;
}
}
if (bPaste) {
data.push(posData);
}
}
if (data.length > 0) {
postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
pos.updateDatas(result.pos);
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] = math.evaluate(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());
}
},
'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());
}
},
'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();
}
}
}
});
}
postData(window.location.pathname + '/load', {}, function (data) {
ledgerTree.loadDatas(data.bills);
console.log(data.bills.find(x => { return x.b_code === '102-4'}));
treeCalc.calculateAll(ledgerTree);
for (const t of data.tags) {
t.node = ledgerTree.datas.find(x => {return x.id === t.lid});
}
billsTag.loadDatas(data.tags);
SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
checkShowLast(data.bills.length);
pos.loadDatas(data.pos);
posOperationObj.loadCurPosData();
SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
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 (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 (e, info) {
const stdSheet = info.sheet;
const mainSheet = ledgerSpread.getActiveSheet();
if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
const stdTree = stdSheet.zh_tree;
const stdNode = stdTree.nodes[info.row];
const mainTree = mainSheet.zh_tree;
const sel = mainSheet.getSelections()[0];
const mainNode = mainTree.nodes[sel.row];
if (!stdNode) { return; }
if (info.sheet.zh_setting.stdType === 'gcl') {
if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
toastr.warning('非最底层项目下，不应添加清单');
return;
}
}
postData(window.location.pathname + '/update', {
postType: 'add-std',
postData: {
id: ledgerTree.getNodeKey(mainNode),
tender_id: mainNode.tender_id,
stdType: info.sheet.zh_setting.stdType,
stdLibId: stdNode.list_id,
stdNode: stdTree.getNodeKey(stdNode)
}
}, function (result) {
const refreshNode = mainTree.loadPostData(result);
treeOperationObj.refreshTree(mainSheet, refreshNode);
if (refreshNode.create && refreshNode.create.length > 0) {
mainSheet.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 = mainTree.nodes.indexOf(mainNode);
if (sel.row !== curIndex && curIndex >= 0) refreshRow.push(curIndex);
SpreadJsObj.reloadRowsBackColor(mainSheet, refreshRow);
} else {
const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
if (node) {
mainSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, ledgerTree.nodes.indexOf(node)]);
}
}
treeOperationObj.refreshOperationValid(mainSheet);
ledgerSpread.focus();
posOperationObj.loadCurPosData();
});
};
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(),
};
// 展开收起标准清单
$('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: '@', readOnly: true},
{title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
{title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
{title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
{title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
{title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
],
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
headColWidth: [30],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
selectedBackColor: '#fffacd',
},
afterLocated: function () {
posOperationObj.loadCurPosData();
}
});
}
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();
}
});
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 || readOnly || 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 || readOnly || 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();
});
});
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);
}
$('#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');
});
});
if (!readOnly) {
$.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;
},
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) {
postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
const refreshNode = ledgerTree.loadPostData(result);
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
});
} else {
toastr.warning('没有可应用的清单。');
}
}
}
}
});
}
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();
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;
}
}
// $('#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 += '
'
})
$('.book-list').empty()
$('.book-list').append(html)
}
}
}, 400);
});
// 添加审批流程按钮逻辑
$('.book-list').on('click', 'dt', function () {
const idx = $(this).find('.acc-btn').attr('data-groupid')
const type = $(this).find('.acc-btn').attr('data-type')
if (type === 'hide') {
$(this).parent().find(`div[data-toggleid="${idx}"]`).show(() => {
$(this).children().find('i').removeClass('fa-plus-square').addClass('fa-minus-square-o')
$(this).find('.acc-btn').attr('data-type', 'show')
})
} else {
$(this).parent().find(`div[data-toggleid="${idx}"]`).hide(() => {
$(this).children().find('i').removeClass('fa-minus-square-o').addClass('fa-plus-square')
$(this).find('.acc-btn').attr('data-type', 'hide')
})
}
return false
});
// 添加到审批流程中
$('dl').on('click', 'dd', function () {
const auditorId = parseInt($(this).data('id'))
if (auditorId) {
postData('/tender/' + getTenderId() + '/ledger/audit/add', { auditorId }, (datas) => {
const html = [];
// 如果是重新上报，添加到重新上报列表中
const auditorshtml = [];
for (const [index,data] of datas.entries()) {
if (index !== 0) {
html.push('
');
if (shenpi_status === shenpiConst.sp_status.sqspr || (shenpi_status === shenpiConst.sp_status.gdzs && index+1 !== datas.length)) {
html.push('移除');
}
html.push('');
html.push(data.audit_order + ' ');
html.push(data.name + ' ');
html.push('');
html.push('');
html.push(data.role);
html.push('');
}
auditorshtml.push('
');
auditorshtml.push(' ');
auditorshtml.push(data.name + ' ' + data.role + '');
if (index === 0) {
auditorshtml.push('原报');
} else if (index+1 === datas.length) {
auditorshtml.push('终审');
} else {
auditorshtml.push(''+ transFormToChinese(index) +'审');
}
auditorshtml.push('');
}
$('#auditors').html(html.join(''));
$('#auditors-list').html(auditorshtml.join(''));
});
}
});
$('body').on('click', '#auditors li>a', function () {
const li = $(this).parent();
const data = {
auditorId: parseInt(li.attr('auditorId')),
};
postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data2) => {
li.remove();
for (const a of data2) {
const aLi = $('li[auditorId=' + a.audit_id + ']');
$('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
}
// 如果是重新上报
// 令最后一个图标转换
$('#auditors-list li[data-auditorid="' + data.auditorId + '"]').remove();
if ($('#auditors-list li').length !== 0 && !$('#auditors-list li i').hasClass('fa-stop-circle')) {
$('#auditors-list li').eq($('#auditors-list li').length-1).children('i')
.removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
}
// $('#auditors-list2 li[data-auditid="' + data.auditorId + '"]').remove();
// if ($('#auditors-list2 li').length !== 0 && !$('#auditors-list2 li i').hasClass('fa-stop-circle')) {
// $('#auditors-list2 li').eq($('#auditors-list2 li').length-1).children('i')
// .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
// }
for (let i = 0; i < $('#auditors-list li').length; i++) {
$('#auditors-list li').eq(i).find('.pull-right').text(i === 0 ? '原报' : (i+1 === $('#auditors-list li').length ? '终' : transFormToChinese(i)) + '审')
// $('#auditors-list2 li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list2 li').length ? '终' : transFormToChinese(i+1)) + '审')
}
});
});
$('#hideSp').click(function () {
$('#sp-list').modal('hide');
});
// 多层modal关闭后的滚动bug修复
$('#sp-list').on('hidden.bs.modal', function (e) {
$(document.body).addClass('modal-open');
});
// 显示层次
(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=showLevel]', ledgerSpread.getActiveSheet());
// $('#exportLedger').click(function () {
// const data = [];
// const setting = {
// header: ['项目节编号', '清单子目号', '部位明细', '名称', '单位', '清单数量', '设计数量1', '设计数量2', '单价', '合价', '图号', '备注'],
// width: [100, 70, 70, 300, 60, 80, 80, 80, 80, 80, 100, 100],
// hAlign: ['left', 'left', 'left', 'left','center', 'right', 'right', 'right', 'right', 'right', 'left', 'left'],
// };
// for (const node of ledgerTree.nodes) {
// data.push([node.code, node.b_code, '', node.name, node.unit,
// node.quantity, node.dgn_qty1, node.dgn_qty2, node.unit_price, node.total_price,
// node.drawing_code, node.memo
// ]);
// const posRange = pos.getLedgerPos(node.id);
// if (posRange && posRange.length > 0) {
// for (const [i, p] of posRange.entries()) {
// data.push(['', '', (i + 1) + '', p.name, '',
// p.quantity, '', '', '', '',
// p.drawing_code, p.memo
// ]);
// }
// }
// }
//
// XLSXObj.exportXlsxSheet(setting, data, "台账分解.xlsx");
// });
$('#exportLedger').click(function () {
const data = [];
const setting = {
cols: [
{title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 100, formatter: '@'},
{title: '清单子目号', colSpan: '1', rowSpan: '1', field: 'b_code', hAlign: 0, width: 70, formatter: '@'},
{title: '计量单元', colSpan: '1', rowSpan: '1', field: 'pos_code', hAlign: 1, width: 70, formatter: '@'},
{title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 300, formatter: '@'},
{title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
{title: '签约数量', colSpan: '1', rowSpan: '1', field: 'deal_qty', hAlign: 2, width: 80, type: 'Number'},
{title: '签约金额', colSpan: '1', rowSpan: '1', field: 'deal_tp', hAlign: 2, width: 80, type: 'Number'},
{title: '清单数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
{title: '设计数量1', colSpan: '1', rowSpan: '1', field: 'dgn_qty1', hAlign: 2, width: 80, type: 'Number'},
{title: '设计数量2', colSpan: '1', rowSpan: '1', field: 'dgn_qty2', hAlign: 2, width: 80, type: 'Number'},
{title: '单价', colSpan: '1', rowSpan: '1', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
{title: '合价', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
{title: '图号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 100, formatter: '@'},
{title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 100, formatter: '@'},
],
headRows: 1,
headRowHeight: [32],
defaultRowHeight: 21,
headerFont: 'bold 10px 微软雅黑',
font: '10px 微软雅黑'
};
const hasCl = ledgerSpreadSetting.cols.find(x => { return x.field === 'sjcl_qty'});
const qtyF = hasCl ? 'quantity' : 'sgfh_qty';
const tpF = hasCl ? 'total_price' : 'sgfh_tp';
for (const node of ledgerTree.nodes) {
data.push({
code: node.code, b_code: node.b_code, name: node.name, unit: node.unit,
unit_price: node.unit_price, quantity: node[qtyF], total_price: node[tpF],
deal_qty: node.deal_qty, deal_tp: node.deal_tp,
dgn_qty1: node.dgn_qty1, dgn_qty2: node.dgn_qty2,
drawing_code: node.drawing_code, memo: node.memo
});
const posRange = pos.getLedgerPos(node.id);
if (posRange && posRange.length > 0) {
for (const [i, p] of posRange.entries()) {
data.push({
pos_code: (i + 1) + '', name: p.name,
quantity: p[qtyF], drawing_code: p.drawing_code, memo: p.memo
});
}
}
}
SpreadExcelObj.exportSimpleXlsxSheet(setting, data, "台账分解.xlsx");
});
$('#sync-ledger').click(function () {
postData(syncLedgerUrl, {}, function (result) {
ledgerTree.loadDatas(result.bills);
treeCalc.calculateAll(ledgerTree);
SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
pos.loadDatas(result.pos);
posOperationObj.loadCurPosData();
checkShowLast(result.bills.length);
});
});
const dataChecker = DataChecker({
checkUrl: window.location.pathname + '/check',
completeData: function (data) {
pos.updateDatas({update: data.source.pos});
const loadResult = ledgerTree.loadPostData({update: data.source.bills});
treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
posOperationObj.loadCurPosData();
for (const e of data.error) {
e.serialNo = ledgerTree.getNodeIndex(ledgerTree.getItems(e.ledger_id)) + 1;
}
},
errorList: errorList,
});
$('[name=audit-start]').submit(function (e) {
if (checkAuditorFrom()) {
$(this).parent().parent().parent().modal('hide');
dataChecker.checkAndPost(this.action, {});
$('#hide-all').hide();
}
return false;
});
$('#ledger-check2').click(() => {
ledgerCheck2({
ledgerTree: ledgerTree,
ledgerPos: pos,
checkList: checkList,
decimal: tenderInfo.decimal,
checkOption: checkOption,
}).then(result => {
check2Viewing({
extra: ZhCalc.div(ledgerTree.datas.length + pos.datas.length, 10000, 0),
randomWait: true,
prefix: 'check2-',
checks: result,
checkList: checkList,
});
});
});
// 切换附件里节点和所有附件
$('#fujian .nav-link').on('click', function () {
const tabPanel = $(this).attr('fujian-content');
if (tabPanel !== 'syfujian') {
$('#showPage').hide();
$('#bach-download').prop('type', 'curr');
} else {
$('#showPage').show();
$('#bach-download').prop('type', 'all');
}
$('#showAttachment').hide();
});
// 上传附件
$('#upload-file-btn').click(function () {
// if (curAuditor && curAuditor.aid !== cur_uid) {
// return toastr.error('当前操作没有权限！');
// }
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
if (!node) return;
const files = $('#upload-file')[0].files;
const formData = new FormData();
formData.append('lid', node.id);
for (const file of files) {
if (file === undefined) {
toastr.error('未选择上传文件！');
return false;
}
const filesize = file.size;
if (filesize > 30 * 1024 * 1024) {
toastr.error('存在上传文件大小过大！');
return false;
}
const fileext = '.' + file.name.toLowerCase().split('.').splice(-1)[0];
if (whiteList && !whiteList.includes(fileext)) {
toastr.error('只能上传指定格式的附件！');
return false;
}
formData.append('size', filesize);
formData.append('file[]', file);
}
postDataWithFile('/tender/' + tender.id + '/ledger/upload/file', formData, function (data) {
$('#upload').modal('hide');
// 插入到attData中
attData = data.concat(attData);
// 重新生成List
getAllList();
getNodeList(node.id);
}, function () {
toastr.error('附件上传失败');
});
$('#upload-file').val('');
});
// 获取附件信息
$('.list-table').on('click', '.att-file-name', function () {
const fid = $(this).attr('file-id');
if ($('#showAttachment').attr('file-id') === fid && !$('#showAttachment').is(":hidden")) {
return;
}
const att = attData.find(function (item) {
return item.id === parseInt(fid);
});
$('#edit-att').hide();
$('#show-att').show();
if (att !== undefined) {
// 进来先把编辑功能隐藏
$('#btn-att a').eq(3).hide()
$('#show-att tr').eq(0).children('td').text(att.filename + att.fileext);
const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
$('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + att.lname));
// $('#show-att tr').eq(2).find('a').attr('href', '/tender/' + tender.id + '/measure/stage/' + stage.order + '/download/file/' + att.id);
// $('#show-att tr').eq(2).find('a').attr('href', att.filepath);
$('#show-att tr').eq(2).children('td').eq(0).text(att.username);
$('#show-att tr').eq(2).children('td').eq(1).text(att.in_time);
$('#show-att tr').eq(3).children('td').text(att.remark);
// 附件uid等于当前用户id, 附件上传本人
if (parseInt(cur_uid) === att.uid) {
$('#btn-att').show();
const showDel = tender.ledger_status === auditConst.status.checked ? Boolean(att.extra_upload) : true;
if (showDel) $('#btn-att a').eq(3).show();
// $('#btn-att a').eq(3).show();
$('#btn-att a').eq(2).hide();
$('#btn-att a').eq(4).hide();
$('#btn-att a').eq(5).hide();
} else {
$('#btn-att').hide();
$('#btn-att a').eq(3).hide();
$('#btn-att a').eq(2).hide();
$('#btn-att a').eq(4).hide();
$('#btn-att a').eq(5).hide();
}
$('#showAttachment').attr('file-id', fid);
$('#showAttachment').show();
} else {
$('#showAttachment').hide();
$('#showAttachment').attr('file-id', '');
toastr.error('附件信息获取失败');
}
});
// $('body').on('click', '.alllist-table a', handleFileList);
$('body').on('click', '#btn-att a', function () {
const content = $(this).attr('content');
const fid = $('#showAttachment').attr('file-id');
const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
if (content === 'edit') {
$('#btn-att a').eq(3).hide();
$('#btn-att a').eq(2).show();
$('#btn-att a').eq(4).show();
$('#btn-att a').eq(5).show();
$('#show-att').hide();
$('#edit-att').show();
const att = attData.find(function (item) {
return item.id === parseInt(fid);
});
$('#edit-att .form-group').eq(0).find('input').val(att.filename);
$('#edit-att .form-group').eq(0).find('span').eq(1).text(att.fileext);
const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
$('#edit-att .form-group').eq(1).find('input').val($.trim(name + ' ' + att.lname));
$('#edit-att .form-group').eq(2).find('input').val(att.in_time);
$('#edit-att .form-group').eq(3).find('input').val(att.remark);
} else if (content === 'cancel') {
$('#show-att').show();
$('#edit-att').hide();
$('#btn-att a').eq(3).show();
$('#btn-att a').eq(2).hide();
$('#btn-att a').eq(4).hide();
$('#btn-att a').eq(5).hide();
} else if (content === 'save') {
const formData = new FormData();
formData.append('id', fid);
formData.append('filename', $('#edit-att .form-group').eq(0).find('input').val());
formData.append('fileext', $('#edit-att .form-group').eq(0).find('span').eq(1).text());
formData.append('remark', $('#edit-att .form-group').eq(3).find('input').val());
const file = $('#change-att-btn')[0];
if (file.files[0] !== undefined) {
const filesize = file.files[0].size;
formData.append('size', filesize);
formData.append('file', file.files[0]);
}
postDataWithFile('/tender/' + tender.id + '/ledger/save/file', formData, function (data) {
// 替换到attData中
const att_index = attData.findIndex(function (item) {
return item.id === parseInt(fid);
});
attData.splice(att_index, 1, data);
// 重新生成List
getAllList(parseInt($('#currentPage').text()));
getNodeList(node.id);
$('#show-att').show();
$('#edit-att').hide();
$('#show-att tr').eq(0).children('td').text(data.filename + data.fileext);
const name = data.code !== null && data.code !== '' ? data.code : (data.b_code !== null ? data.b_code : '');
$('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + data.lname));
$('#show-att tr').eq(2).children('td').eq(0).text(data.username);
$('#show-att tr').eq(2).children('td').eq(1).text(data.in_time);
$('#show-att tr').eq(3).children('td').text(data.remark);
$('#btn-att a').eq(3).show();
$('#btn-att a').eq(2).hide();
$('#btn-att a').eq(4).hide();
$('#btn-att a').eq(5).hide();
}, function () {
toastr.error('附件上传失败');
});
$('#change-att-btn').val('');
} else if (content === 'del') {
const data = {id: fid};
postData('/tender/' + tender.id + '/ledger/delete/file', data, function (result) {
// 删除到attData中
const att_index = attData.findIndex(function (item) {
return item.id === parseInt(fid);
});
attData.splice(att_index, 1);
// 重新生成List
if ($('#alllist-table tr').length === 1) {
getAllList(parseInt($('#currentPage').text()) - 1);
} else {
getAllList(parseInt($('#currentPage').text()));
}
getNodeList(node.id);
$('#showAttachment').hide();
$('#showAttachment').attr('file-id', '');
});
} else if (content === 'view') {
const data = {id: fid};
postData('/tender/' + tender.id + '/ledger/check/file', data, function (result) {
const { filepath } = result
$('#load-file').attr('href', filepath);
$('#load-file')[0].click();
});
} else if (content === 'location') {
const att = attData.find(item => item.id === parseInt(fid));
if (Object.keys(att).length) {
SpreadJsObj.locateTreeNode(ledgerSpread.getActiveSheet(), att.ledger_id, true);
posOperationObj.loadCurPosData();
}
}
});
// 替换附件
$('#change-att-btn').on('change', function () {
const file = $('#change-att-btn')[0].files[0];
const name = file.name;
const filename = name.substring(0, name.lastIndexOf("."));
const fileext = name.substr(name.indexOf("."));
const filesize = file.size;
if (filesize > 30 * 1024 * 1024) {
toastr.error('文件大小过大！');
$('#change-att-btn').val('');
return false;
}
if (whiteList && !whiteList.includes(fileext)) {
toastr.error('只能上传指定格式的附件！');
$('#change-att-btn').val('');
return false;
}
$('#edit-att .form-group').eq(0).find('input').val(filename);
$('#edit-att .form-group').eq(0).find('span').eq(1).text(fileext);
});
// 切换页数
$('.page-select').on('click', function () {
const totalPageNum = parseInt($('#totalPage').text());
const lastPageNum = parseInt($('#currentPage').text());
const status = $(this).attr('content');
if (status === 'pre' && lastPageNum > 1) {
getAllList(lastPageNum-1);
$('#showAttachment').hide();
$('#syfujian .check-all-file').prop('checked', false)
} else if (status === 'next' && lastPageNum < totalPageNum) {
getAllList(lastPageNum+1);
$('#showAttachment').hide();
$('#syfujian .check-all-file').prop('checked', false)
}
});
// 批量下载
$('#bach-download').click(function() {
const fileIds = [];
const type = $(this).attr('type');
let node = ''
if (type === 'curr') {
node = '#nodelist-table .check-file:checked'
} else {
node = '#alllist-table .check-file:checked'
}
$(node).each(function() {
const fileId = $(this).attr('file-id');
fileId && fileIds.push(fileId);
});
if (fileIds.length) {
if (fileIds.length > 20) {
return toastr.warning(`最大允许20个文件(当前${fileIds.length}个)`)
}
toastr.success('正在进行压缩文件...', '', { timeOut: 0, extendedTimeOut: 0})
$(this).attr('disabled', "true")
const btn = $(this);
const fileArr = [];
for (const id of fileIds) {
const fileInfo = _.find(currPageFileData, { id: parseInt(id) });
fileArr.push({
url: fileInfo.orginpath, //文件的oss存储路径 (必填)
name: fileInfo.filename, // 文件名 (可选, 不需要填扩展名)
foldPath: '' // (可选, 文件在压缩包中的存储路径)
});
}
const packageName = `${tender.name}-台账分解-附件.zip`;
try {
zipOss.downloadFromAliOss(fileArr, packageName, btn);
} catch (e) {
btn.removeAttr('disabled');
toastr.clear();
toastr.error('批量下载失败');
}
// postCompressFile(`/tender/${tender.id}/ledger/compresse/file`, {fileIds}, function(result) {
// toastr.clear()
// toastr.success('压缩文件成功')
// btn.removeAttr('disabled')
// const href = window.URL.createObjectURL(result)
// $('#zipDown').attr('href', href);
// $('#zipDown').attr('download', `${tender.name}-台账分解-附件.zip`);
// $("#zipDown")[0].click();
// }, () => {
// btn.removeAttr('disabled')
// toastr.clear()
// toastr.error('批量下载失败')
// });
// const url = `/tender/${tender.id}/ledger/compresse/file?fileIds=${JSON.stringify(fileIds)}`;
}
});
// 监听附件check是否选中
$('.list-table').on('click', '.check-file', function() {
const checkedList = $(this).parents('.list-table').children().find('input:checked');
const childs = $(this).parents('.list-table').children().length;
const checkBox = $(this).parents('.list-table').parent().find('.check-all-file');
if (checkedList.length === childs) {
checkBox.prop("checked", true);
} else {
checkBox.prop("checked", false);
}
});
$('.check-all-file').click(function() {
const isCheck = $(this).is(':checked');
$(this).parents('table').find('.list-table').each(function() {
$(this).find('input:checkbox').prop("checked", isCheck);
})
});
});
// 生成当前节点列表
function getNodeList(node) {
let html = '';
for(const att of attData) {
if (node === att.lid) {
// html += '
| '+ att.filename + att.fileext +' | '+ att.username +' |
';
html += `
|
| ${att.username} |
`
}
}
$('#nodelist-table').html(html);
$('#nodelist-table').on('click', 'tr', function() {
$('#nodelist-table tr').removeClass('bg-light')
$(this).addClass('bg-light')
})
}
// 生成所有附件列表
function getAllList(currPageNum = 1) {
// 每页最多几个附件
const pageCount = 20;
// 附件总数
const total = attData.length;
// 总页数
const pageNum = Math.ceil(total/pageCount);
$('#totalPage').text(pageNum);
$('#currentPage').text(total === 0 ? 0 : currPageNum);
// 当前页附件内容
const currPageAttData = attData.slice((currPageNum-1)*pageCount, currPageNum*pageCount);
currPageFileData = currPageAttData;
let html = '';
for(const att of currPageAttData) {
html += `
|
| ${att.username} |
`
}
$('#alllist-table').html(html);
$('#alllist-table').on('click', 'tr', function() {
$('#alllist-table tr').removeClass('bg-light')
$(this).addClass('bg-light')
})
}
// 检查上报情况
function checkAuditorFrom () {
if ($('#auditors li').length === 0) {
if(shenpi_status === shenpiConst.sp_status.gdspl) {
toastr.error('请联系管理员添加审批人');
} else {
toastr.error('请先选择审批人，再上报数据');
}
return false;
} else {
$('#hide-all').show();
return true;
}
}