'use strict';
/**
* 期计量 - 本期计量台账页面 js
*
* @author Mai
* @date 2018/12/7
* @version
*/
function checkTzMeasureType () {
return tender.measure_type === measureType.tz.value;
}
/**
* 从cookie中读取缓存的列显示设置，没有则取默认
* @returns {*[]}
*/
function customColDisplay () {
const defaultSetting = [
{ title: '签约合同', fields: ['deal_qty', 'deal_tp'], visible: true },
{ title: '本期计量合同', fields: ['contract_qty', 'contract_tp'], visible: true },
{ title: '本期数量变更', fields: ['qc_qty', 'qc_tp', 'qc_bgl'], visible: true },
{ title: '本期完成计量', fields: ['gather_qty', 'gather_tp'], visible: true },
{ title: '截止本期计量合同', fields: ['end_contract_qty', 'end_contract_tp'], visible: true },
{ title: '截止本期数量变更', fields: ['end_qc_qty', 'end_qc_tp', 'end_qc_bgl'], visible: true },
{ title: '截止本期完成计量', fields: ['end_gather_qty', 'end_gather_tp'], visible: true },
{ title: '图册号', fields: ['drawing_code'], visible: true },
{ title: '累计完成率(%)', fields: ['percent'], visible: true },
{ title: '备注', fields: ['memo'], visible: true },
];
const settingStr = Cookies.get('stage-col-visible-1.0.0');
return settingStr ? JSON.parse(settingStr) : defaultSetting;
}
/**
* 根据列显示设置，调整setting中的列是否显示
* @param setting
* @param customDisplay
*/
function customizeStageTreeSetting(setting, customDisplay) {
for (const cd of customDisplay) {
for (const c of setting.cols) {
if (cd.fields.indexOf(c.field) !== -1) {
c.visible = cd.visible;
}
}
}
}
/**
* 初始化 树结构 列事件
* @param setting
*/
function initTreeColSettingEvents(setting) {
const Events = {
readOnly: {
measureData: function (node) {
return node.children && node.children.length > 0;
},
},
};
const getEvent = function (eventName) {
const names = eventName.split('.');
let event = Events;
for (let name of names) {
if (event[name]) {
event = event[name];
} else {
return null;
}
}
if (event && Object.prototype.toString.apply(event) !== "[object Function]") {
return null;
} else {
return event;
}
};
for (const col of setting.cols) {
if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
col.readOnly = getEvent(col.readOnly);
}
}
}
function needCheckDetail() {
stage.check_detail = true;
$('#check_point').show();
}
$(document).ready(() => {
// 界面布局
autoFlashHeight();
// 初始化 台账树结构 数据结构
const stageTreeSetting = {
id: 'ledger_id',
pid: 'ledger_pid',
order: 'order',
level: 'level',
rootId: -1,
keys: ['id', 'tender_id', 'ledger_id'],
stageId: 'id',
};
// 台账树结构计算相关设置
stageTreeSetting.updateFields = ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp', 'postil'];
stageTreeSetting.calcFields = ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp',
'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp', 'end_contract_tp', 'end_qc_tp', 'end_gather_tp'];
stageTreeSetting.calcFun = function (node) {
if (node.children && node.children.length === 0) {
node.pre_gather_qty = ZhCalc.add(node.pre_contract_qty, node.pre_qc_qty);
node.gather_qty = ZhCalc.add(node.contract_qty, node.qc_qty);
node.end_contract_qty = ZhCalc.add(node.pre_contract_qty, node.contract_qty);
node.end_qc_qty = ZhCalc.add(node.pre_qc_qty, node.qc_qty);
node.end_gather_qty = ZhCalc.add(node.pre_gather_qty, node.gather_qty);
}
node.pre_gather_tp = ZhCalc.add(node.pre_contract_tp, node.pre_qc_tp);
node.gather_tp = ZhCalc.add(node.contract_tp, node.qc_tp);
node.end_contract_tp = ZhCalc.add(node.pre_contract_tp, node.contract_tp);
node.end_qc_tp = ZhCalc.add(node.pre_qc_tp, node.qc_tp);
node.end_gather_tp = ZhCalc.add(node.pre_gather_tp, node.gather_tp);
node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), tenderInfo.decimal.up);
};
const stageTree = createNewPathTree('stage', stageTreeSetting);
// 初始化 部位明细 数据结构
const stagePosSetting = {
id: 'id', ledgerId: 'lid',
updateFields: ['contract_qty', 'qc_qty', 'postil'],
};
stagePosSetting.calcFun = function (pos) {
pos.pre_gather_qty = ZhCalc.add(pos.pre_contract_qty, pos.pre_qc_qty);
pos.gather_qty = ZhCalc.add(pos.contract_qty, pos.qc_qty);
pos.end_contract_qty = ZhCalc.add(pos.pre_contract_qty, pos.contract_qty);
pos.end_qc_qty = ZhCalc.add(pos.pre_qc_qty, pos.qc_qty);
pos.end_gather_qty = ZhCalc.add(pos.pre_gather_qty, pos.gather_qty);
};
const stagePos = new StagePosData(stagePosSetting);
class Changes {
constructor(obj) {
const self = this;
this.obj = obj;
// 初始化 清单编号窗口 参数
this.spreadSetting = {
cols: [
{title: '已用', field: '', width: 45, formatter: '@', cellType: 'image', readOnly: true, hAlign: 1, indent: 14, img: function (data) {
if (data.uamount && !checkZero(data.uamount)) {
return $('#icon-ok')[0];
} else {
return null;
}
}},
{title: '变更令号', field: 'code', width: 100, formatter: '@', readOnly: true, hAlign: 0, },
{title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true, hAlign: 0,},
{title: '总数量', field: 'b_amount', width: 60, formatter: '@', readOnly: true, hAlign: 2, },
{title: '可变更数量', field: 'vamount', width: 60, readOnly: true, hAlign: 2, },
{title: '本期计量', field: 'uamount', width: 60, formatter: '@', hAlign: 2, type: 'Number', },
],
emptyRows: 0,
headRows: 1,
headRowHeight: [40],
getColor: function (data, col, defaultColor) {
if (col.field === 'uamount') {
if (!data.vamount) {
return data.uamount ? '#ff6f5c' : defaultColor;
} else if (data.uamount) {
return data.uamount > data.vamount ? '#ff6f5c' : defaultColor;
} else {
return defaultColor;
}
} else {
return defaultColor;
}
}
};
this.curChangeId = '';
this.spread = SpreadJsObj.createNewSpread($('#change-spread')[0]);
this.firstView = true;
SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
// 初次显示，需刷新spread界面，保证界面绘制正确
this.obj.bind('shown.bs.modal', function () {
if (self.firstView) {
self.firstView = false;
self.spread.refresh();
}
});
// 切换变更令，加载右侧明细数据
this.spread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
const change = SpreadJsObj.getSelectObject(info.sheet);
self._loadChangeDetail(change);
});
// 填写本期计量
this.spread.bind(spreadNS.Events.EditEnded, function (e, info) {
if (info.sheet.zh_setting) {
const col = info.sheet.zh_setting.cols[info.col];
const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
const node = sortData[info.row];
node[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
// 刷新界面
SpreadJsObj.reLoadRowData(info.sheet, info.row, 1);
}
});
this.spread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
if (info.sheet.zh_setting) {
const sortData = SpreadJsObj.getSortData(info.sheet);
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
const curRow = iRow + info.cellRange.row;
const curCol = info.cellRange.col;
const col = info.sheet.zh_setting.cols[info.cellRange.col];
sortData[curRow][col.field] = col.type === 'Number' ? _.toNumber(info.sheet.getText(curRow, curCol)) : info.sheet.getText(curRow, curCol);
}
SpreadJsObj.reLoadRowData(sheet, info.cellRange.row, sel.cellRange.rowCount);
}
});
SpreadJsObj.addDeleteBind(this.spread, function (sheet) {
if (sheet.zh_setting) {
const sel = sheet.getSelections()[0];
const sortData = SpreadJsObj.getSortData(sheet);
// 仅本期计量可删除
if (sel.col === 5 || sel.colCount === 1) {
const col = sheet.zh_setting.cols[sel.col];
for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
const data = sortData[iRow];
data[col.field] = null;
}
SpreadJsObj.reLoadRowData(sheet, sel.row, sel.rowCount);
}
}
});
// 过滤可变更数量为0
$('#filterEmpty').click(function () {
self._filterChange(!this.checked, $('#matchPos')[0].checked);
});
// 匹配编号
$('#matchPos').click(function () {
self._filterChange(!$('#filterEmpty')[0].checked, this.checked);
});
// 展开收起 变更令详细信息
$('#show-bgl-detail').bind('click', function () {
const detail = $('#bgl-detail'), bgl=$('#bgl'), obj=$(this);
if (detail.hasClass('col-4')) {
detail.attr('class', 'col').hide();
bgl.attr('class', 'col-12');
$('a', obj).attr('title', '展开侧栏');
$('i', obj).attr('class', 'fa fa-chevron-left');
self.spread.refresh();
} else {
detail.attr('class', 'col-4').show();
bgl.attr('class', 'col-8');
$('a', obj).attr('title', '收起侧栏');
$('i', obj).attr('class', 'fa fa-chevron-right');
self.spread.refresh();
}
});
// 添加调用变更令
$('#usg-bg-ok').click(function () {
const data = { target: self.callData, change: [] };
for (const c of self.changes) {
if (c.uamount) {
if (!c.vamount || checkZero(c.vamount)) {
toast('变更令：' + c.code + ' 当前不可使用', 'error');
return;
} else {
if (c.uamount > c.vamount) {
toast('变更令：' + c.code + ' 超计，请修改本期计量后，再提交', 'error');
return;
}
}
data.change.push({ cid: c.cid, cbid: c.cbid, qty: c.uamount });
}
}
// 提交数据到后端
postData(window.location.pathname + '/use-change', data, function(result) {
if (result.pos) {
stagePos.loadCurStageData(result.pos.curStageData);
}
const nodes = stageTree.loadPostStageData(result.bills);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
stagePosSpreadObj.loadCurPosData();
needCheckDetail();
self.obj.modal('hide');
});
})
}
_calculateAmount() {
for (const c of this.changes) {
c.bamount = _.toNumber(c.b_amount);
c.vamount = ZhCalc.sub(c.bamount, c.used_amount);
const uc = _.find(this.useChanges, {cid: c.cid, cbid: c.cbid});
if (uc) {
c.uamount = uc.qty;
c.vamount = ZhCalc.add(c.vamount, c.uamount);
}
}
}
_loadChangeDetail(change) {
if (change) {
if (change.cid === this.curChangeId) { return; }
this.curChangeId = change.cid;
const inputs = $('input[type!=checkbox]', this.obj);
for (const i of inputs) {
const field = $(i).attr('name');
const text = (field && change[field]) ? change[field] : '';
$(i).val(text);
}
const textareas = $('textarea', this.obj);
for (const ta of textareas) {
const field = $(ta).attr('name');
const text = (field && change[field]) ? change[field] : '';
ta.innerText = text;
}
const html = [];
for (const a of change.attachments) {
html.push('');
html.push('| ', '', a.filename + a.fileext, '', ' | ');
html.push('', a.u_name, ' | ');
html.push('
');
}
// 变更类型
if (change.type) {
const cType = change.type.split(',');
$('input[name="type"]').prop("checked", false);
for (const c of cType) {
$('input[name="type"][value='+ c +']').prop("checked", true);
}
}
// 变更类别
$('select[name=class]').val(change.class);
// 变更性质
$('select[name=quality]').val(change.quality);
// 变更单位
$('select[name=company]').html('');
// 费用承担方
$('input[name=charge][value=' + change.charge + ']').prop('checked', true);
// 附件
$('#attachment').html(html.join(''));
} else {
const inputs = $('input', this.obj);
for (const i of inputs) {
$(i).val('');
}
const textareas = $('textarea', this.obj);
for (const ta of textareas) {
ta.innerText = '';
}
$('#attachment').html('');
}
}
_viewChanges() {
const sheet = this.spread.getActiveSheet();
if (this.changes) {
SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, this.changes);
sheet.setSelection(0, 0, 1, 1);
this._loadChangeDetail(this.changes[0]);
this._filterChange(!$('#filterEmpty')[0].checked, $('#matchPos')[0].checked);
} else {
toast('查询变更令有误，请刷新页面后重试', 'warning');
}
}
_filterChange(filterEmpty, matchPosName) {
for (const c of this.changes) {
const filterVisible = filterEmpty ? (c.vamount ? !checkZero(c.vamount) : false) : true;
const matchVisible = matchPosName && this.callData.pos ? c.b_detail === this.callData.pos.name : true;
c.visible = filterVisible && matchVisible;
}
SpreadJsObj.refreshTreeRowVisible(this.spread.getActiveSheet());
}
loadChanges(data) {
this.callData = data;
if (this.callData.pos) {
$('#matchPos').parent().show();
} else {
$('#matchPos').parent().hide();
}
const self = this;
$('#b-code-hint').text('当前变更清单：' + data.bills.b_code);
postData(window.location.pathname + '/valid-change', data, function (result) {
self.changes = result.changes;
self.useChanges = result.useChanges;
self._calculateAmount();
self._viewChanges();
self.obj.modal('show');
});
}
}
const changesObj = new Changes($('#use-bg'));
// 初始化 台账 spread
const slSpread = SpreadJsObj.createNewSpread($('#stage-ledger')[0]);
customizeStageTreeSetting(ledgerSpreadSetting, customColDisplay());
// 数量变更列，添加按钮
const col = _.find(ledgerSpreadSetting.cols, {field: 'qc_qty'});
col.readOnly = true;
col.cellType = 'imageBtn';
col.hoverImg = '#ellipsis-icon';
col.indent = 5;
col.showImage = function (data) {
if (!data || (data.children && data.children.length > 0)) {
return false;
} else {
const nodePos = stagePos.getLedgerPos(data.id);
return !(nodePos && nodePos.length > 0);
}
};
ledgerSpreadSetting.imageClick = function (data) {
changesObj.loadChanges({bills: data});
};
//
SpreadJsObj.initSheet(slSpread.getActiveSheet(), ledgerSpreadSetting);
stageTree.loadDatas(ledgerData);
stageTree.loadCurStageData(curStageData);
stageTree.loadPreStageData(preStageData);
// 根据设置 计算 台账树结构
treeCalc.calculateAll(stageTree);
// 绘制界面
SpreadJsObj.loadSheetData(slSpread.getActiveSheet(), 'tree', stageTree);
// 初始化 部位明细 Spread
const spSpread = SpreadJsObj.createNewSpread($('#stage-pos')[0]);
const spCol = _.find(posSpreadSetting.cols, {field: 'qc_qty'});
spCol.readOnly = true;
spCol.cellType = 'imageBtn';
spCol.hoverImg = '#ellipsis-icon';
spCol.indent = 5;
spCol.showImage = function (data) {
return data;
};
posSpreadSetting.imageClick = function (data) {
const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
changesObj.loadChanges({bills: node, pos: data});
};
SpreadJsObj.initSheet(spSpread.getActiveSheet(), posSpreadSetting);
const stageTreeSpreadObj = {
refreshTreeNodes: function (sheet, nodes) {
const tree = sheet.zh_tree;
if (!tree) { return }
const rows = [];
for (const node of nodes) {
rows.push(tree.nodes.indexOf(node));
}
SpreadJsObj.reLoadRowsData(sheet, rows);
},
editEnded: function (e, info) {
if (info.sheet.zh_setting) {
const col = info.sheet.zh_setting.cols[info.col];
const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
const node = sortData[info.row];
if (col.field !== 'postil') {
if (node.children && node.children.length > 0) {
toast('清单父项不可计量', 'error');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
} else {
const nodePos = stagePos.getLedgerPos(node.id);
if (nodePos && nodePos.length > 0) {
toast('该清单有部位明细，请在部位明细处计量', 'error');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
}
}
const billsData = {
lid: node.id
};
billsData[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
postData(window.location.href + '/update', { bills: billsData }, function (data) {
const nodes = stageTree.loadPostStageData(data);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
needCheckDetail();
});
}
},
selectionChanged: function (e, info) {
stagePosSpreadObj.loadCurPosData();
},
deletePress(sheet) {
if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
const tree = sheet.zh_tree;
if (!tree) { return; }
const sel = sheet.getSelections()[0];
const validCols = [];
for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
if (!sheet.zh_setting.cols[iCol].readOnly) {
validCols.push(iCol);
}
}
if (validCols.length === 0) { return; }
const sortData = sheet.zh_tree.nodes;
const datas = [];
for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
const node = sortData[iRow];
if (node) {
const data = { lid: node.id };
let filter = true;
for (const iCol of validCols) {
const colSetting = sheet.zh_setting.cols[iCol];
if (colSetting.field !== 'postil') {
if (node.children && node.children.length > 0) { continue; }
const nodePos = stagePos.getLedgerPos(node.id);
if (nodePos && nodePos.length > 0) { continue; }
}
data[colSetting.field] = null;
filter = false;
}
if (!filter) {
datas.push(data);
}
}
}
if (datas.length > 0) {
postData(window.location.href + '/update', {bills: datas}, function (result) {
const nodes = stageTree.loadPostStageData(result);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
needCheckDetail();
});
}
}
},
clipboardPasting(e, info) {
if (info.sheet.zh_setting) {
const sortData = info.sheet.zh_data;
const range = info.cellRange;
const validField = ['contract_qty', 'contract_tp', 'qc_qty', 'postil'];
for (let iCol = range.col; iCol < range.col + range.colCount; iCol++) {
const col = info.sheet.zh_setting.cols[iCol];
if (validField.indexOf(col.field) === -1) {
toast('不可修改此数据', 'error');
info.cancel = true;
return;
}
}
}
},
clipboardPasted(e, info) {
if (info.sheet.zh_setting && info.sheet.zh_tree) {
const sheet = info.sheet;
const filterNodes = [], datas = [];
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
const curRow = iRow + info.cellRange.row;
const node = sheet.zh_tree.getItemsByIndex(curRow);
const data = {lid: node.id};
let filter = true;
for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
const curCol = info.cellRange.col + iCol;
const col = info.sheet.zh_setting.cols[curCol];
if (col.field !== 'postil') {
if (node.children && node.children.length > 0) {
continue;
}
const nodePos = stagePos.getLedgerPos(node.id);
if (nodePos && nodePos.length > 0) {
continue;
}
}
data[col.field] = col.type === 'Number' ? _.toNumber(info.sheet.getText(curRow, curCol)) : info.sheet.getText(curRow, curCol);
filter = false;
}
if (filter) {
filterNodes.push(node);
} else {
datas.push(data);
}
}
if (datas.length > 0) {
postData(window.location.href + '/update', { bills: datas }, function (data) {
const nodes = stageTree.loadPostStageData(data);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes.concat(filterNodes));
needCheckDetail();
});
} else {
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), filterNodes);
}
}
}
};
slSpread.bind(spreadNS.Events.EditEnded, stageTreeSpreadObj.editEnded);
slSpread.bind(spreadNS.Events.SelectionChanged, stageTreeSpreadObj.selectionChanged);
slSpread.bind(spreadNS.Events.ClipboardPasting, stageTreeSpreadObj.clipboardPasting);
slSpread.bind(spreadNS.Events.ClipboardPasted, stageTreeSpreadObj.clipboardPasted);
SpreadJsObj.addDeleteBind(slSpread, stageTreeSpreadObj.deletePress);
const stagePosSpreadObj = {
/**
* 加载部位明细 根据当前台账选择节点
*/
loadCurPosData: function () {
const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
if (node) {
const posData = stagePos.ledgerPos[itemsPre + node.id] || [];
SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', posData);
} else {
SpreadJsObj.loadSheetData(spSpread.getActiveSheet(), 'data', []);
}
},
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;
if (orgText === info.editingText || ((!orgText || orgText === '') && (info.editingText === ''))) {
return;
}
// 台账模式下，不可新增
if (checkTzMeasureType() && !posData) {
toast('台账模式不可新增部位明细数据', 'error');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
info.cancel = true;
return ;
}
// 不同节点下，部位明细检查输入
//const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
const node = stagePosSpreadObj.stageTreeNode;
if (!node) {
toast('数据错误, 请刷新页面后再试', 'warning');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
} else if (info.editingText !== '' && node.children && node.children > 0) {
toast('父节点不可插入部位明细', 'error');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
} else if (info.editingText !== '' && !node.b_code || node.b_code === '') {
toast('项目节不可插入部位明细', 'error');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
// 生成提交数据
const data = {};
if (col.field === 'name') {
if (info.editingText === '' && pos) {
toast('部位名称不可为空', 'error', 'exclamation-circle');
info.cancel = true;
return;
} else if (!posData) {
if (info.editingText !== '') {
data.updateType = 'add';
data.updateData = {name: info.editingText, lid: node.id, tid: tender.id};
} else {
return;
}
} else {
data.updateType = 'update';
data.updateData = {pid: posData.id, lid: posData.lid, name: info.editingText};
}
} else if (!posData) {
toast('新增部位请先输入名称', 'warning');
} else {
data.updateType = 'update';
data.updateData = {pid: posData.id, lid: posData.lid};
data.updateData[col.field] = col.type === 'Number' ? parseFloat(info.editingText) : info.editingText;
}
// 提交数据到服务器
postData(window.location.pathname + '/update', {pos: data}, function (result) {
if (result.pos) {
stagePos.updateDatas(result.pos.pos);
stagePos.loadCurStageData(result.pos.curStageData);
}
const refreshData = stageTree.loadPostStageData(result.ledger);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), refreshData);
stagePosSpreadObj.loadCurPosData();
needCheckDetail();
}, function () {
stagePosSpreadObj.loadCurPosData();
});
}
},
editStarting: function (e, info) {
stagePosSpreadObj.stageTreeNode = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
},
clipboardPasting: function (e, info) {
if (info.sheet.zh_setting) {
const sortData = info.sheet.zh_data;
const range = info.cellRange;
const validField = ['contract_qty', 'qc_qty', 'postil'];
if (!checkTzMeasureType()) {
validField.push('name', 'sgfh_qty', 'sjcl_qty', 'qtcl_qty');
}
for (let iCol = range.col; iCol < range.col + range.colCount; iCol++) {
const col = info.sheet.zh_setting.cols[iCol];
if (validField.indexOf(col.field) === -1) {
if (checkTzMeasureType()) {
toast('不可修改此数据', 'error');
info.cancel = true;
return;
} else {
for (let iRow = range.row; iRow < range.row + range.rowCount; iRow) {
const pos = sortData(iRow);
if (pos.add_stage !== stage.id || pos.add_times !== stage.times) {
toast('不可修改此数据', 'error');
info.cancel = true;
return;
}
}
}
}
}
}
},
clipboardPasted: function (e, info) {
const self = this;
if (info.sheet.zh_setting) {
const data = { updateType: '', updateData: [], };
const sortData = info.sheet.zh_data;
const node = SpreadJsObj.getSelectObject(slSpread.getActiveSheet());
if (sortData && (info.cellRange.row >= sortData.length)) {
data.updateType = 'add';
if (info.cellRange.col !== 0) {
toast('新增部位请先输入名称', 'warning');
self.loadCurPosData();
return;
}
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
const curRow = info.cellRange.row + iRow;
const newData = {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];
newData[colSetting.field] = info.sheet.getText(curRow, curCol);
if (colSetting.type === 'Number') {
newData[colSetting.field] = _.toNumber(newData[colSetting.field]);
}
}
data.updateData.push(newData);
}
} else {
data.updateType = 'update';
for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
const curRow = info.cellRange.row + iRow;
const curPos = sortData[curRow];
if (curPos) {
const newData = {pid: curPos.id, lid: curPos.lid};
for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
const curCol = info.cellRange.col + iCol;
const colSetting = info.sheet.zh_setting.cols[curCol];
newData[colSetting.field] = info.sheet.getText(curRow, curCol);
if (colSetting.type === 'Number') {
newData[colSetting.field] = _.toNumber(newData[colSetting.field]);
}
}
data.updateData.push(newData);
}
}
}
console.log(data);
postData(window.location.pathname + '/update', {pos: data}, function (result) {
if (result.pos) {
stagePos.updateDatas(result.pos.pos);
stagePos.loadCurStageData(result.pos.curStageData);
}
const nodes = stageTree.loadPostStageData(result.ledger);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
stagePosSpreadObj.loadCurPosData();
needCheckDetail();
}, function () {
stagePosSpreadObj.loadCurPosData();
});
}
},
deletePress: function (sheet) {
if (sheet.zh_setting && sheet.zh_data) {
const sortData = sheet.zh_data;
if (!sortData || sortData.length === 0) { return; }
const sel = sheet.getSelections()[0];
const validCols = [];
for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
if (!sheet.zh_setting.cols[iCol].readOnly) {
validCols.push(iCol);
}
}
if (validCols.length === 0) { return; }
const datas = [], posSelects = [];
for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
const node = sortData[iRow];
if (node) {
const data = {pid: node.id, lid: node.lid};
for (const iCol of validCols) {
const colSetting = sheet.zh_setting.cols[iCol];
if (colSetting.field === 'name') {
toast('部位名称不能为空', 'error');
return;
}
data[colSetting.field] = null;
}
datas.push(data);
posSelects.push(node);
}
}
if (datas.length > 0) {
postData(window.location.pathname + '/update', {pos: {updateType: 'update', updateData: datas} }, function (result) {
if (result.pos) {
stagePos.updateDatas(result.pos.pos);
stagePos.loadCurStageData(result.pos.curStageData);
}
const nodes = stageTree.loadPostStageData(result.ledger);
stageTreeSpreadObj.refreshTreeNodes(slSpread.getActiveSheet(), nodes);
needCheckDetail();
// todo 只加载改变项
stagePosSpreadObj.loadCurPosData();
});
}
}
},
leaveCell: function (e, info) {
console.log(1);
},
};
// 加载上下窗口resizer
$.divResizer({
select: '#main-resize',
callback: function () {
slSpread.refresh();
let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
$(".sp-wrap").height(bcontent-40);
spSpread.refresh();
}
});
// 加载部位明细数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
postData(window.location.pathname + '/pos', null, function (result) {
stagePos.loadDatas(result.pos);
if (result.curStageData) {
stagePos.loadCurStageData(result.curStageData);
}
if (result.preStageData) {
stagePos.loadPreStageData(result.preStageData);
}
stagePos.calculateAll();
stagePosSpreadObj.loadCurPosData();
});
spSpread.bind(spreadNS.Events.EditEnded, stagePosSpreadObj.editEnded);
spSpread.bind(spreadNS.Events.ClipboardPasting, stagePosSpreadObj.clipboardPasting);
spSpread.bind(spreadNS.Events.ClipboardPasted, stagePosSpreadObj.clipboardPasted);
spSpread.bind(spreadNS.Events.EditStarting, stagePosSpreadObj.editStarting);
SpreadJsObj.addDeleteBind(spSpread, stagePosSpreadObj.deletePress);
if (!checkTzMeasureType()) {
}
$('#row-view').on('show.bs.modal', function () {
const html = [], customDisplay = customColDisplay();
for (const cd of customDisplay) {
html.push('');
html.push('| ', cd.title, ' | ');
html.push('', '', ' | ');
html.push('
');
}
$('#row-view-list').html(html.join(''));
});
$('#row-view-ok').click(function () {
const customDisplay = customColDisplay();
const cvl = $('#row-view-list').children();
for (const cv of cvl) {
const title = $(cv).children()[0].innerHTML;
const check = $('input', cv)[0].checked;
const cd = customDisplay.find(function (c) {
return c.title === title;
});
cd.visible = check;
}
customizeStageTreeSetting(ledgerSpreadSetting, customDisplay);
SpreadJsObj.refreshColumnVisible(slSpread.getActiveSheet());
Cookies.set('stage-col-visible', JSON.stringify(customDisplay), 7*24*60*60*1000);
$('#row-view').modal('hide');
});
class SearchLedger {
constructor(obj, mainSpread) {
const self = this;
this.obj = obj;
this.mainSpread = mainSpread;
this.spreadSetting = {
cols: [
{title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@'},
{title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
{title: '名称', field: 'name', width: 230, 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: 'complete_percent', hAlign: 2, width: 70},
],
emptyRows: 3,
headRows: 1,
headRowHeight: [40],
defaultRowHeight: 21,
readOnly: true
};
this.spread = SpreadJsObj.createNewSpread($('#search-result', this.obj)[0]);
SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
$('#searchLedger', this.obj).bind('click', function () {
const keyword = $('#keyword', self.obj).val();
if (keyword !== '') {
$('#over', obj)[0].checked = false;
$('#empty', obj)[0].checked = false;
this.searchResult = [];
const sortData = SpreadJsObj.getSortData(self.mainSpread.getActiveSheet());
for (const node of sortData) {
if ((node.code && node.code.indexOf(keyword) > -1) ||
node.b_code && node.b_code.indexOf(keyword) > -1 ||
node.name && node.name.indexOf(keyword) > -1) {
this.searchResult.push(node);
}
}
SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', this.searchResult);
}
});
$('#over', this.obj).bind('change', function () {
this.searchResult = [];
const sortData = SpreadJsObj.getSortData(self.mainSpread.getActiveSheet());
for (const node of sortData) {
if (node.children && node.children.length > 0) continue;
if (node.end_gather_qty) {
if (!node.quantity || Math.abs(node.end_gather_qty) > Math.abs(node.quantity)) {
this.searchResult.push(node);
}
} else if (node.end_gather_tp) {
if (!node.total_price || Math.abs(node.end_gather_tp) > Math.abs(node.total_price)) {
this.searchResult.push(node);
}
}
}
SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', this.searchResult);
});
$('#empty', this.obj).bind('change', function () {
this.searchResult = [];
const sortData = SpreadJsObj.getSortData(self.mainSpread.getActiveSheet());
for (const node of sortData) {
if (node.children && node.children.length > 0) continue;
if (node.quantity) {
if (!node.end_gather_qty || checkZero(node.end_gather_qty)) {
this.searchResult.push(node);
}
} else if (node.total_price) {
if (!node.end_gather_tp || checkZero(node.end_gather_tp)) {
this.searchResult.push(node);
}
}
}
SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', this.searchResult);
});
this.spread.getActiveSheet().bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
const sheet = info.sheet;
const data = sheet.zh_data;
if (!data) { return }
const curBills = data[info.row];
if (!curBills) { return }
SpreadJsObj.locateTreeNode(self.mainSpread.getActiveSheet(), curBills.ledger_id);
});
}
}
let searchLedger;
$.divResizer({
select: '#right-spr',
callback: function () {
slSpread.refresh();
spSpread.refresh();
if (searchLedger) {
searchLedger.spread.refresh();
}
}
});
// 展开收起附件
$('a', '.side-menu').bind('click', function () {
//const main = $('#main-view'), tool = $('#tools-view');
const tab = $(this), tabPanel = $(tab.attr('content'));
const showTools = function (show) {
const left = $('#main-view'), right = $('#tools-view'), parent = left.parent();
if (show) {
right.show();
autoFlashHeight();
/**
* right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
* 第一次left.width调整后，parent的缩回left.height, 此时parent.width又增加了10px
* 故需要通过最终的parent.width再计算一次left.width
*
* Q: 为什么不通过先计算left.width的宽度，以避免计算两次left.width?
* A: 右侧工具栏不一定显示，当右侧工具栏显示过一次后，就必须使用parent和right来计算left.width
*
*/
//left.css('width', parent.width() - right.outerWidth());
//left.css('width', parent.width() - right.outerWidth());
const percent = 100 - right.outerWidth() /parent.width() * 100;
left.css('width', percent + '%');
} else {
right.hide();
left.css('width', '100%');
}
};
if (!tab.hasClass('active')) {
$('a', '.side-menu').removeClass('active');
$('.tab-content .tab-pane').removeClass('active');
tab.addClass('active');
tabPanel.addClass('active');
showTools(tab.hasClass('active'));
if (tab.attr('content') === '#search' && !searchLedger) {
searchLedger = new SearchLedger($('#search'), slSpread);
searchLedger.spread.refresh();
}
} else {
tab.removeClass('active');
tabPanel.removeClass('active');
showTools(tab.hasClass('active'));
}
slSpread.refresh();
spSpread.refresh();
});
});