'use strict';
/**
* 材料调差 - 调差工料
*
* @author Mai
* @date 2019/1/16
* @version
*/
// 编号排序，多重判断
function sortByCode(a, b) {
let code1 = a.code.split('-');
let code2 = b.code.split('-');
let code1length = code1.length;
let code2length = code2.length;
for (let i = 0; i < code1length; i ++) {
if (i+1 <= code2length) {
if (code1[i] != code2[i]) {
if (/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
return parseInt(code1[i]) - parseInt(code2[i]);
} else if (!/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
return 1;
} else if (/^\d+$/.test(code1[i]) && !/^\d+$/.test(code2[i])) {
return -1;
} else {
const str1length = code1[i].length;
const str2length = code2[i].length;
for (let j = 0; j < str1length; j++) {
if (j+1 <= str2length) {
if (code1[i].charAt(j) != code2[i].charAt(j)) {
return code1[i].charAt(j).charCodeAt() - code2[i].charAt(j).charCodeAt();
} else if (j+1 == str1length && code1[i].charAt(j) == code2[i].charAt(j)) {
if (str1length == str2length) {
return 0;
} else {
return str1length - str2length;
}
}
} else {
if (j+1 >= str1length) {
return 1;
} else {
return -1;
}
}
}
}
} else if (i+1 == code1length && code1[i] == code2[i]) {
if (code1length == code2length) {
return 0;
} else {
return code1length - code2length;
}
}
} else {
if (i+1 >= code1length) {
return 1;
} else {
return -1;
}
}
}
}
function loadUpdateMaterials(newMaterial, fields) {
const newMaterials = newMaterial instanceof Array ? newMaterial : [newMaterial];
for (const nm of newMaterials) {
const om = _.find(materialBillsData, {id: nm.id});
for (const prop in nm) {
if (!fields || fields.indexOf(prop) >= 0) {
om[prop] = nm[prop];
}
}
}
}
function DatePickerCellType() {
}
DatePickerCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();
DatePickerCellType.prototype.createEditorElement = function () {
//Create input presenter.
var input = document.createElement("input");
return input;
};
DatePickerCellType.prototype.activateEditor = function (editorContext, cellStyle, cellRect) {
//Initialize input editor.
if (editorContext) {
const $editor = $(editorContext);
GC.Spread.Sheets.CellTypes.Base.prototype.activateEditor.apply(this, arguments);
$editor.datepicker({});
$editor.css("position", "absolute");
$editor.attr("gcUIElement", "gcEditingInput");
$(".ui-datepicker").attr("gcUIElement", "gcEditingInput");
}
}
DatePickerCellType.prototype.deactivateEditor = function (editorContext) {
//Remove input editor when end editor status.
if (editorContext) {
var element = editorContext;
// $(element).datepicker().data('datepicker').hide();
// $(element).datepicker().data('datepicker').destroy();
$(element).datepicker("hide");
$(element).datepicker("destroy");
}
GC.Spread.Sheets.CellTypes.Base.prototype.deactivateEditor.apply(this, arguments)
};
DatePickerCellType.prototype.setEditorValue = function (editor, value) {
//Sync value from Cell value to editor value.
// console.log($(editor), value);
$(editor).datepicker("setDate", value);
// $(editor).datepicker().data('datepicker').selectDate(value ? new Date(value) : new Date());
};
DatePickerCellType.prototype.getEditorValue = function (editor, context) {
// console.log($(editor).datepicker().data('datepicker'), context);
//Sync value from editor value to cell value.
// console.log($(editor).datepicker("getDate"));
// return $(editor).datepicker("getDate");
return $(editor).val();
};
DatePickerCellType.prototype.updateEditor = function (editorContext, cellStyle, cellRect) {
if (editorContext) {
const $editor = $(editorContext);
$editor.css("width", cellRect.width - 1);
$editor.css("height", cellRect.height - 3);
}
};
function resetTpTable() {
$('#tp_set').find('td').eq(1).text(ZhCalc.round(m_tp, materialDecimal.tp));
$('#tp_set').find('td').eq(2).text(ZhCalc.add(pre_tp, ZhCalc.round(m_tp, materialDecimal.tp)));
let sum = 0;
if (isStageSelf) {
let html = '';
const rate = $('#rateInput').val();
for (const ms of materialStageData) {
if (!materialTax) {
sum = ZhCalc.add(sum, ZhCalc.round(ZhCalc.mul(ms.m_tp, 1+rate/100), materialDecimal.tp));
}
const taxHtml = ' | ' + (materialTax ? (ms.m_tax_tp !== null ? ms.m_tax_tp : '') : ZhCalc.round(ZhCalc.mul(ms.m_tp, 1+rate/100), materialDecimal.tp) ) + ' | \n';
html += '| 第' + ms.order + '期 | ' + (ms.m_tp !== null ? ms.m_tp : '') + ' | \n' +
taxHtml +
'
';
}
const allTaxHtml = ' ' + (materialTax ? m_tax_tp : sum) + ' | \n';
html += '| 合计 | ' + m_tp + ' | \n' +
allTaxHtml +
'
';
$('#materialStageTable').html(html);
}
if (materialTax) {
$('#tax_rate_set').find('td').eq(1).text(ZhCalc.round(m_tax_tp, materialDecimal.tp));
$('#tax_rate_set').find('td').eq(2).text(ZhCalc.add(m_tax_pre_tp, ZhCalc.round(m_tax_tp, materialDecimal.tp)));
} else {
const rate = $('#rateInput').val();
const bqhs = isStageSelf ? sum : ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
const jzbqhs = ZhCalc.add(pre_tp_hs, bqhs);
$('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
$('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
}
}
function getPasteHint (str, row = '') {
let returnObj = str;
if (row) {
returnObj.msg = '工料第' + (row+1) + '行' + str.msg;
}
return returnObj;
}
const is_numeric = (value) => {
if (typeof(value) === 'object') {
return false;
} else {
return !Number.isNaN(Number(value)) && value.toString().trim() !== '';
}
};
$(document).ready(() => {
autoFlashHeight();
const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]);
const materialSpreadSetting = {
emptyRows: 0,
headRows: 2,
headRowHeight: [25, 32],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
readOnly: readOnly,
};
let materialSpreadSettingCols = [
{title: '调差类型', colSpan: '1', rowSpan: '2', field: 't_type', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isUsed', cellType: 'customizeCombo', comboItems: materialType.t_type, cellTypeKey: 1},
{title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isUsed'},
{title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: 'readOnly.isEdit'},
{title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: 'readOnly.isEdit'},
{title: '规格', colSpan: '1', rowSpan: '2', field: 'spec', hAlign: 0, width: 150, formatter: '@', readOnly: 'readOnly.isEdit'},
{title: '工料分类', colSpan: '1', rowSpan: '2', field: 'm_type', hAlign: 1, width: 60, readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.m_type, cellTypeKey: 2},
];
if (materialTax) {
materialSpreadSettingCols.push({title: '税率(%)', colSpan: '1', rowSpan: '2', field: 'm_tax', hAlign: 2, width: 50, type: 'Number', readOnly: editTaxPermission ? 'readOnly.remark' : 'readOnly.isEdit'});
}
materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
{title: '上涨 幅度(%)', colSpan: '1', rowSpan: '2', field: 'm_up_risk', hAlign: 2, width: 50, type: 'Number', readOnly: 'readOnly.isEdit'},
{title: '下跌 幅度(%)', colSpan: '1', rowSpan: '2', field: 'm_down_risk', hAlign: 2, width: 50, type: 'Number', readOnly: 'readOnly.isEdit'},
{title: '基准价', colSpan: '1', rowSpan: '2', field: 'basic_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
{title: '基准时间', colSpan: '1', rowSpan: '2', field: 'basic_times', hAlign: 0, width: 70, formatter: '@', readOnly: 'readOnly.remark'},
{title: '本期信息价|单价', colSpan: '3|1', rowSpan: '1|1', field: 'msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.msg_tp'},
{title: '|时间', colSpan: '|1', rowSpan: '|1', field: 'msg_times', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.remark'},
{title: '|单价差', colSpan: '|1', rowSpan: '|1', field: 'msg_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.msg_spread'},]
);
if (materialTax) {
materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
{title: '本期材料调差|有效价差', colSpan: '4|1', rowSpan: '1|1', field: 'm_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
{title: '|本期应耗数量', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 90, type: 'Number', readOnly: true},
{title: '|调差金额', colSpan: '|1', rowSpan: '|1', field: 'm_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
{title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'm_tax_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tax_tp'},
{title: '截止上期|调差金额', colSpan: '2|1', rowSpan: '1|1', field: 'pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
{title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'tax_pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
{title: '截止本期|调差金额', colSpan: '2|1', rowSpan: '1|1', field: 'end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.end_tp'},
{title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'tax_end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.tax_end_tp'},
{title: '备注', colSpan: '1', rowSpan: '2', field: 'remark', hAlign: 0, width: 50, formatter: '@', cellType: 'ellipsisAutoTip', readOnly: 'readOnly.remark'},
{title: '是否汇总', colSpan: '1', rowSpan: '2', field: 'is_summary', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isEdit'}
])
} else {
materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
{title: '本期材料调差|有效价差', colSpan: '3|1', rowSpan: '1|1', field: 'm_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
{title: '|本期应耗数量', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 90, type: 'Number', readOnly: true},
{title: '|调差金额', colSpan: '|1', rowSpan: '|1', field: 'm_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
{title: '截止上期|调差金额', colSpan: '1|1', rowSpan: '1|1', field: 'pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
{title: '截止本期|调差金额', colSpan: '1|1', rowSpan: '1|1', field: 'end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.end_tp'},
{title: '备注', colSpan: '1', rowSpan: '2', field: 'remark', hAlign: 0, width: 50, formatter: '@', cellType: 'ellipsisAutoTip', readOnly: 'readOnly.remark'},
{title: '是否汇总', colSpan: '1', rowSpan: '2', field: 'is_summary', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isEdit'}
])
}
materialSpreadSetting.cols = materialSpreadSettingCols;
const spCol = _.find(materialSpreadSetting.cols, {field: 'quantity'});
spCol.readOnly = true;
spCol.cellType = 'activeImageBtn';
spCol.normalImg = '#ellipsis-icon';
spCol.indent = 5;
spCol.showImage = function (data) {
// return !readOnly && data.t_type === 2 && data.mid === materialID;
return data && data.t_type === 2;
};
materialSpreadSetting.imageClick = function (data) {
if (data.t_type === 2) {
$('#bcyy').modal('show');
$('#materialbillsId').val(data.id);
$('#expr').val(data.expr);
if (!readOnly) {
$('#expr').attr('readOnly', false);
$('#expr_btn').show();
$('#expr_select').show();
} else {
$('#expr').attr('readOnly', true);
$('#expr_btn').hide();
$('#expr_select').hide();
}
}
};
const materialBase = {
isUsed: function (data) {
if (data.t_type === 2) {
return data.mid === materialID;
} else {
const mlInfo = _.find(materialListData, { mb_id: data.id });
return data.mid === materialID && mlInfo === undefined;
}
},
isEdit: function (data) {
// if (data.t_type === 2) {
// return data.mid === materialID;
// } else {
// const mlInfo = _.find(materialListData, { mb_id: data.id });
// return data.mid === materialID && mlInfo === undefined;
// }
return data.mid === materialID;
},
// isStage: function (data) {
// return data.mid === materialID;
// }
}
const materialCol = {
getValue: {
msg_spread: function (data) {
return ZhCalc.round(ZhCalc.sub(data.msg_tp, data.basic_price), materialDecimal.up);
},
m_spread : function (data) {
const msg_spread = materialCol.getValue.msg_spread(data);
const cor = msg_spread >= 0 ? ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_up_risk, 100)) : ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_down_risk, 100));
return Math.abs(msg_spread) > Math.abs(cor) ? (msg_spread > 0 ? ZhCalc.round(ZhCalc.sub(msg_spread, cor), materialDecimal.up) : ZhCalc.round(ZhCalc.add(msg_spread, cor), materialDecimal.up)) : 0;
},
m_tp: function (data) {
return ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), materialDecimal.tp);
},
m_tax_tp: function (data) {
const m_tp = ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), materialDecimal.tp);
return data.m_tax ? ZhCalc.round(ZhCalc.mul(m_tp, (1+ZhCalc.div(data.m_tax, 100))), materialDecimal.tp) : m_tp;
},
end_tp: function (data) {
return ZhCalc.add(data.m_tp, data.pre_tp);
},
tax_end_tp: function (data) {
return ZhCalc.add(data.m_tax_tp, data.tax_pre_tp);
}
},
readOnly: {
isEdit: function (data) {
return !(!readOnly && materialBase.isEdit(data));
},
isUsed: function (data) {
return !(!readOnly && materialBase.isUsed(data));
},
remark: function () {
return readOnly;
},
msg_tp: function () {
return !(!readOnly && months.length === 0);
}
},
};
const needUpdateArray = ['quantity', 'expr', 'msg_tp', 'msg_times', 'msg_spread', 'm_spread', 'm_tp', 'm_tax_tp', 'is_summary', 'remark'];
const materialSpreadObj = {
getMaterialBillsData: function () {
if (isStageSelf) {
// 当前选中nav id
const ms_id = $('#myTab').find('.active').data('msid');
const msbList = _.filter(materialStageBillsData, { ms_id });
for (const mb of materialBillsData) {
mb.ms_id = ms_id;
const msbInfo = _.find(msbList, { mb_id: mb.mb_id ? mb.mb_id : mb.id });
if (msbInfo) {
for (const nu of needUpdateArray) {
mb[nu] = msbInfo[nu];
}
}
}
}
return materialBillsData;
},
updateOneMaterialBill: function (data) {
const ms_id = $('#myTab').find('.active').data('msid');
const msbInfo = _.find(materialStageBillsData, { ms_id, mb_id: data.id });
console.log(msbInfo);
data.ms_id = ms_id;
for (const nu of needUpdateArray) {
data[nu] = msbInfo[nu];
}
return data;
},
updateMaterialData: function (datas) {
if (datas.stageData && datas.stageData.length > 0) {
if (datas.stageData.length === materialStageData.length) {
// 全体替换
materialStageData = datas.stageData;
} else {
// 替换对应的stage数据
for (const s of datas.stageData) {
const index = _.findIndex(materialStageData, { id: s.id });
materialStageData.splice(index, 1, s);
}
}
}
if (datas.pushStageBillsData && datas.pushStageBillsData.length > 0) {
materialStageBillsData = _.concat(materialStageBillsData, datas.pushStageBillsData);
}
if (datas.removeStageBillsData && datas.removeStageBillsData.length > 0) {
materialStageBillsData = _.remove(materialStageBillsData, function (item) {
return _.findIndex(datas.removeStageBillsData, { id: item.mb_id }) === -1
})
}
if (datas.stageBillsData && datas.stageBillsData.length > 0) {
if (datas.stageBillsData.length === materialStageBillsData.length) {
// 全体替换
materialStageBillsData = datas.stageBillsData;
} else {
// 替换对应的stage数据
for (const s of datas.stageBillsData) {
const index = _.findIndex(materialStageBillsData, { id: s.id });
materialStageBillsData.splice(index, 1, s);
}
}
}
if (datas.billsData && datas.billsData.length > 0) {
if (datas.billsData.length === materialBillsData.length) {
// 全体替换
materialBillsData = datas.billsData;
materialSpreadObj.getMaterialBillsData();
} else {
for (const b of datas.billsData) {
const index = _.findIndex(materialBillsData, {id: b.id});
materialBillsData.splice(index, 1, b);
materialSpreadObj.updateOneMaterialBill(materialBillsData[index]);
}
}
}
},
materialSheetReset: function (redo = false) {
let newMaterialBillsData = _.cloneDeep(materialBillsData);
if($('#bills0_list').is(':checked')) {
newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
}
if (redo) {
materialSpread.getActiveSheet().reset();
SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
}
console.log(newMaterialBillsData);
SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
materialSpreadObj.refreshActn();
},
refreshActn: function (rowCount = 1) {
const setObjEnable = function (obj, enable) {
if (enable) {
obj.removeClass('disabled');
} else {
obj.addClass('disabled');
}
};
const sheet = materialSpread.getActiveSheet();
const select = SpreadJsObj.getSelectObject(sheet);
const selection = sheet.getSelections();
const sel = selection ? selection[0] : sheet.getSelections()[0];
const row = sel ? sel.row : -1;
const first = materialBillsData[row];
let last = first;
if (sel.rowCount > 1 && first) {
for (let r = 1; r < sel.rowCount; r++) {
const rNode = materialBillsData[sel.row + r];
if (!rNode) break;
last = rNode;
}
}
const preNode = materialBillsData[row - 1];
// 还需判断是否已被调差清单调用
setObjEnable($('#del'), !readOnly && select && materialBase.isUsed(select) && rowCount === 1);
setObjEnable($('#up-move'), !readOnly && first && preNode && materialBillsData.indexOf(last) > 0 && sel.row + sel.rowCount <= materialBillsData.length && !$('#bills0_list').is(':checked'));
setObjEnable($('#down-move'), !readOnly && first && materialBillsData.indexOf(last) < materialBillsData.length - 1 && sel.row + sel.rowCount <= materialBillsData.length && !$('#bills0_list').is(':checked'));
},
add: function () {
const sheet = materialSpread.getActiveSheet();
postData(window.location.pathname + '/save', {type: 'add'}, function (result) {
if (result) {
materialBillsData.push(result.info);
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
materialSpreadObj.getMaterialBillsData();
}
// sheet.addRows(materialBillsData.length - 1, 1);
// SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
let newMaterialBillsData = materialBillsData;
if($('#bills0_list').is(':checked')) {
newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
}
SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
// materialSpreadObj.materialSheetReset();
sheet.setSelection(newMaterialBillsData.length - 1, 0, 1, 1);
console.log(sheet);
materialSpreadObj.refreshActn();
// 月信息价需要同时添加空白的list
if (months.length > 0) {
const one_month ={ mb_id: result.info.id, code: '', name: null, origin: null, unit: null, order: result.info.order };
for (const m of months) {
one_month[m] = null;
}
monthsList.push(one_month);
// const newMonthsList = _.filter(monthsList, function (item) {
// return _.findIndex(newMaterialBillsData, { code: item.code }) !== -1;
// });
// materialMonthSpread.getActiveSheet().addRows(newMonthsList.length - 1, 1);
// SpreadJsObj.reLoadRowData(materialMonthSpread.getActiveSheet(), newMonthsList.length - 1);
monthFunGather.monthsListSet();
// materialMonthSpreadObj.monthsListSet();
}
}
});
},
del: function () {
const sheet = materialSpread.getActiveSheet();
const select = SpreadJsObj.getSelectObject(sheet);
const sel = sheet.getSelections();
postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
const index = _.findIndex(materialBillsData, { id: select.id });
materialBillsData.splice(index, 1);
if (isStageSelf) {
result.removeStageBillsData = [{ id: select.id }];
materialSpreadObj.updateMaterialData(result);
materialSpreadObj.getMaterialBillsData();
}
let newMaterialBillsData = materialBillsData;
let newIndex = index;
if($('#bills0_list').is(':checked')) {
newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
newIndex = _.findIndex(newMaterialBillsData, { id: select.id });
}
// sheet.deleteRows(newIndex, 1);
// sheet.zh_data.splice(newIndex, 1);
materialSpreadObj.materialSheetReset(true);
resetTpTable();
// SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
sheet.setSelection(newIndex > 0 ? newIndex - 1 : 0, sel.length > 0 ? sel[0].col : 0, 1, 1);
materialSpreadObj.refreshActn();
// 月信息价需要同时删除
if (months.length > 0) {
monthsList.splice(index, 1);
materialMonthSpread.getActiveSheet().deleteRows(newIndex, 1);
// SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
}
});
},
upMove: function () {
if($('#bills0_list').is(':checked')) {
return;
}
const data = {
type: 'changeOrder',
postData: [],
};
const sheet = materialSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row, count = selection[0].rowCount;
const first = sheet.zh_data[row];
if (!first) {
materialSpreadObj.refreshActn();
return false;
}
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.postData.push({id: posData.id, order: sheet.zh_data[iRow + row - 1].order});
preUpdate.order = posData.order;
}
}
console.log(monthsList);
data.postData.push(preUpdate);
console.log(data);
if (data.postData.length > 0) {
postData(window.location.pathname + '/save', data, function () {
_.forEach(data.postData, function (item) {
const cl = _.find(materialBillsData, { id: item.id });
cl.order = item.order;
});
materialBillsData.sort(function (a, b) {
return a.order - b.order
});
SpreadJsObj.reLoadSheetData(sheet);
const sel = selection[0];
if (sel) {
sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
}
if (months.length > 0) {
_.forEach(data.postData, function (item) {
const cl = _.find(monthsList, { mb_id: item.id });
cl.order = item.order;
});
monthsList.sort(function (a, b) {
return a.order - b.order
});
const materialMonthSheet = materialMonthSpread.getActiveSheet();
SpreadJsObj.reLoadSheetData(materialMonthSheet);
}
materialSpreadObj.refreshActn();
});
}
},
downMove: function () {
if($('#bills0_list').is(':checked')) {
return;
}
const data = {
type: 'changeOrder',
postData: [],
};
const sheet = materialSpread.getActiveSheet();
const selection = sheet.getSelections();
const row = selection[0].row, count = selection[0].rowCount;
const first = sheet.zh_data[row];
if (!first) {
materialSpreadObj.refreshActn();
return false;
}
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.postData.push({id: posData.id, order: sheet.zh_data[iRow + row + 1].order});
nextUpdate.order = posData.order;
}
}
data.postData.push(nextUpdate);
console.log(data);
if (data.postData.length > 0) {
postData(window.location.pathname + '/save', data, function () {
_.forEach(data.postData, function (item) {
const cl = _.find(materialBillsData, { id: item.id });
cl.order = item.order;
});
materialBillsData.sort(function (a, b) {
return a.order - b.order
});
SpreadJsObj.reLoadSheetData(sheet);
const sel = selection[0];
if (sel) {
sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
}
if (months.length > 0) {
_.forEach(data.postData, function (item) {
const cl = _.find(monthsList, { mb_id: item.id });
cl.order = item.order;
});
monthsList.sort(function (a, b) {
return a.order - b.order
});
const materialMonthSheet = materialMonthSpread.getActiveSheet();
SpreadJsObj.reLoadSheetData(materialMonthSheet);
}
materialSpreadObj.refreshActn();
});
}
},
selectionChanged: function (e, info) {
const sel = info.sheet.getSelections()[0];
const col = info.sheet.zh_setting.cols[sel.col];
materialSpreadObj.refreshActn(sel.rowCount);
const data = SpreadJsObj.getSelectObject(info.sheet);
materialSpreadObj.setReadOnly(true);
// console.log(data);
setCurBillSourceList(data ? (data.mb_id || data.id) : null, $('#myTab').find('.active').data('msid') || null);
},
editEnded: function (e, info) {
if (info.sheet.zh_setting) {
const select = SpreadJsObj.getSelectObject(info.sheet);
const col = info.sheet.zh_setting.cols[info.col];
if (col.field === 'is_summary') {
return;
}
// 未改变值则不提交
let validText = (col.type === 'Number' || col.field === 'm_type' || col.field === 't_type') && is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
const orgValue = select[col.field];
if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
// 判断部分值是否输入的是数字判断和数据计算
if (col.field === 'basic_price') {
if (isNaN(validText)) {
toastr.error('不能输入其它非数字类型字符');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
let num = parseFloat(validText);
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (validText !== null && (num < 0 || !reg.test(num))) {
toastr.warning('已保留'+ materialDecimal.up +'位小数');
validText = ZhCalc.round(num, materialDecimal.up);
}
}
if (col.field === 'msg_tp') {
if (isNaN(validText)) {
toastr.error('不能输入其它非数字类型字符');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const num = parseFloat(validText);
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (validText !== null && (num < 0 || !reg.test(num))) {
toastr.warning('已保留'+ materialDecimal.up +'位小数');
validText = ZhCalc.round(num, materialDecimal.up);
}
}
if (col.field === 'm_up_risk' || col.field === 'm_down_risk' || col.field === 'm_tax') {
// 只能输入正整数
if (isNaN(validText)) {
toastr.error('不能输入其它非数字类型字符');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const num = parseFloat(validText);
if (validText !== null && (num < 0 || num > 100 || !/^\d+$/.test(num))) {
toastr.error('只能输入0-100的正整数');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
}
if (col.field === 't_type') {
if (validText === 1) {
select.quantity = null;
select.expr = null;
select.m_tp = null;
}
}
select[col.field] = validText;
select.msg_spread = materialCol.getValue.msg_spread(select);
select.m_spread = materialCol.getValue.m_spread(select);
select.m_tp = materialCol.getValue.m_tp(select);
select.m_tax_tp = materialCol.getValue.m_tax_tp(select);
delete select.waitingLoading;
// console.log(select);
// 更新至服务器
postData(window.location.pathname + '/save', { type:'update', updateData: select, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
}
resetTpTable();
SpreadJsObj.reLoadRowData(info.sheet, info.row);
// 判断如果是更改了编号，名称，单位，月信息价需要跟着改变值
if (months.length > 0 && (col.field === 'code' || col.field === 'name' || col.field === 'unit')) {
const index = _.findIndex(materialBillsData, { id: select.id });
monthsList[index][col.field] = validText;
monthFunGather.monthsListSet();
}
}, function () {
select[col.field] = orgValue;
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
}
},
buttonClicked: function (e, info) {
if (info.sheet.zh_setting) {
const select = SpreadJsObj.getSelectObject(info.sheet);
const col = info.sheet.zh_setting.cols[info.col];
if (materialCol.readOnly.isEdit(select)) {
return;
}
if (col.field === 'is_summary') {
if (info.sheet.isEditing()) {
info.sheet.endEdit(true);
}
select.is_summary = info.sheet.getValue(info.row, info.col) ? 1 : 0;
delete select.waitingLoading;
// 更新至服务器
postData(window.location.pathname + '/save', { type:'update', updateData: select, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
}
resetTpTable();
SpreadJsObj.reLoadRowData(info.sheet, info.row);
}, function () {
select.is_summary = info.sheet.getValue(info.row, info.col) ? 0 : 1;
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
}
}
},
deletePress: function (sheet) {
return;
},
clipboardPasted(e, info) {
const hint = {
cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
codeEmpty: {type: 'error', msg: '请先输入编号,并且不超过15个字符'},
codeUsed: {type: 'error', msg: '该编号已存在，请重新输入。'},
codeError: {type: 'error', msg: '编号为纯数字时，不能为小数'},
numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
riskCan: {type: 'error', msg: '只能粘贴0-100的正整数'},
numberCan: {type: 'warning', msg: '已保留'+ materialDecimal.up +'位小数'},
};
const range = info.cellRange;
const sortData = info.sheet.zh_data || [];
if (info.cellRange.row + info.cellRange.rowCount > sortData.length) {
toastMessageUniq(hint.cellError);
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
return;
}
if (sortData.length > 0 && range.col + range.colCount > 18) {
toastMessageUniq(hint.cellError);
SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
return;
}
const data = [];
// const rowData = [];
for (let iRow = 0; iRow < range.rowCount; iRow++) {
let bPaste = true;
const curRow = range.row + iRow;
// const materialData = JSON.parse(JSON.stringify(sortData[curRow]));
const materialData = { id: sortData[curRow].id };
const hintRow = range.rowCount > 1 ? curRow : '';
let sameCol = 0;
for (let iCol = 0; iCol < range.colCount; iCol++) {
const curCol = range.col + iCol;
const colSetting = info.sheet.zh_setting.cols[curCol];
if (!colSetting) continue;
let validText = info.sheet.getText(curRow, curCol);
validText = (colSetting.type === 'Number' || colSetting.field === 'm_type' || colSetting.field === 't_type') && is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
const orgValue = sortData[curRow][colSetting.field];
if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
sameCol++;
if (range.colCount === sameCol) {
bPaste = false;
}
continue;
}
if (colSetting.field === 'code' && (validText === '' || validText.length > 15)) {
toastMessageUniq(getPasteHint(hint.codeEmpty, hintRow));
bPaste = false;
continue;
}
if (colSetting.field === 'code' && validText.toString().indexOf('.') !== -1) {
toastMessageUniq(getPasteHint(hint.codeError, hintRow));
bPaste = false;
continue;
}
if (colSetting.field === 'code' && _.find(sortData, { code: validText.toString() })) {
toastMessageUniq(getPasteHint(hint.codeUsed, hintRow));
bPaste = false;
continue;
}
if (colSetting.field === 't_type' || colSetting.field === 'm_type') {
continue;
}
if (colSetting.field === 'basic_price' || colSetting.field === 'msg_tp'
|| colSetting.field === 'm_up_risk' || colSetting.field === 'm_down_risk') {
if (isNaN(validText)) {
toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
bPaste = false;
continue;
}
const num = parseFloat(validText);
if (colSetting.field === 'basic_price' || colSetting.field === 'msg_tp') {
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (validText !== null && (num < 0 || !reg.test(num))) {
toastMessageUniq(getPasteHint(hint.numberCan, hintRow));
validText = ZhCalc.round(num, materialDecimal.up);
}
} else if (colSetting.field === 'm_up_risk' || colSetting.field === 'm_down_risk' || colSetting.field === 'm_tax') {
if (validText !== null && (num < 0 || num > 100 || !/^\d+$/.test(num))) {
toastMessageUniq(getPasteHint(hint.riskCan, hintRow));
bPaste = false;
continue;
}
}
}
materialData[colSetting.field] = validText;
sortData[curRow][colSetting.field] = validText;
}
if (materialData.code === '' || materialData.code === null) {
toastMessageUniq(getPasteHint(hint.codeEmpty, hintRow));
bPaste = false;
}
if (bPaste) {
materialData.msg_spread = materialCol.getValue.msg_spread(sortData[curRow]);
materialData.m_spread = materialCol.getValue.m_spread(sortData[curRow]);
materialData.m_tp = materialCol.getValue.m_tp(sortData[curRow]);
materialData.m_tax_tp = materialCol.getValue.m_tax_tp(sortData[curRow]);
data.push(materialData);
// rowData.push(curRow);
} else {
SpreadJsObj.reLoadRowData(info.sheet, curRow);
}
}
if (data.length === 0) {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
return;
}
// console.log(data);
// 更新至服务器
postData(window.location.pathname + '/save', { type:'paste', updateData: data, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
materialBillsData = result.info;
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
materialSpreadObj.getMaterialBillsData();
}
// SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
// for (const row in rowData) {
// materialBillsData.splice(index, 1, result.info[row]);
// SpreadJsObj.reLoadRowData(info.sheet, row);
// }
if (months.length > 0) {
for (const [i,m] of monthsList.entries()) {
m.code = materialBillsData[i].code;
m.name = materialBillsData[i].name;
m.unit = materialBillsData[i].unit;
m.origin = materialBillsData[i].origin;
}
// SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, monthsList);
monthFunGather.monthsListSet();
// SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
}
resetTpTable();
// materialSpreadObj.refreshActn();
}, function () {
// materialSpreadObj.refreshActn();
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
return;
});
},
setReadOnly: function(readOnly) {
// SpreadJsObj.resetFieldReadOnly(materialSpread.getActiveSheet(), 'msg_spread', 'm_spread', 'm_tp', 'pre_tp', readOnly);
}
};
materialSpread.bind(spreadNS.Events.SelectionChanged, materialSpreadObj.selectionChanged);
materialSpread.bind(spreadNS.Events.ClipboardPasted, materialSpreadObj.clipboardPasted);
SpreadJsObj.addDeleteBind(materialSpread, materialSpreadObj.deletePress);
materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded);
materialSpread.bind(spreadNS.Events.ButtonClicked, materialSpreadObj.buttonClicked);
const sheet = materialSpread.getActiveSheet();
sheet.suspendPaint();
// materialSpreadObj.refreshActn();
// const basic_range = sheet.getRange(-1, 8, -1, 1);
// basic_range.cellType(new DatePickerCellType());
// basic_range.formatter("yyyy-MM-dd");
// const msg_range = sheet.getRange(-1, 10, -1, 1);
// msg_range.cellType(new DatePickerCellType());
// msg_range.formatter("yyyy-MM-dd");
sheet.resumePaint();
const static_cols = [
{title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
{title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 100, formatter: '@', readOnly: true},
{title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
{title: '来源地', colSpan: '1', rowSpan: '2', field: 'origin', hAlign: 0, width: 70, formatter: '@', readOnly: 'readOnly.isEdit'},
{title: '平均单价', colSpan: '1', rowSpan: '2', field: 'average_msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue:'getValue.average_msg_tp'},
];
// 月信息价方法集合
const monthFunGather = {
_setMonthHtml: function() {
let html = '';
let qihtml = '';
for (const m of months) {
html += '\n' +
' \n' +
' \n' +
'
';
qihtml += parseInt(m.split('-')[1]) + '月，';
}
if (months.length > 0) {
qihtml = '/本期月信息价：' + qihtml;
qihtml = qihtml.substring(0, qihtml.length-1);
}
$('#show_month').html(html);
$('#qi-month').html(qihtml);
},
_monthHeaderSet: function() {
const newMonths = [];
for (const m of months) {
const year = m.split('-')[0];
const month = parseInt(m.split('-')[1]);
let one = _.find(newMonths, { 'year': year });
let oneIndex = _.findIndex(newMonths, { 'year': year });
if (one) {
one.month.push(month);
newMonths.splice(oneIndex, 1, one);
} else {
one = {
year: year,
month: [ month ],
};
newMonths.push(one);
}
}
const pushMonth = [];
for(const mo of newMonths) {
for (let i in mo.month) {
i = parseInt(i);
const newCols = {
title: (i === 0 ? mo.year: '') + '|' + mo.month[i] + '月',
colSpan: (i === 0 ? (mo.month.length === 1 ? '0' : mo.month.length) : '') + '|1',
rowSpan: i === 0 ? '1|1' : '|1',
field: mo.year + '-' + (mo.month[i] < 10 ? '0' + mo.month[i] : mo.month[i]),
hAlign: 2, width: 60, type: '@', readOnly: 'readOnly.isEdit'};
pushMonth.push(newCols);
}
}
return pushMonth;
},
monthSheetReset: function (ml = monthsList) {
const monthCols = monthFunGather._monthHeaderSet();
const newMonthSpreadHeaderCols = static_cols.concat(monthCols);
materialMonthSpreadSetting.cols = newMonthSpreadHeaderCols;
// 表头变化需要重新绘制，不然报错;
materialMonthSpread.getActiveSheet().reset();
SpreadJsObj.initSpreadSettingEvents(materialMonthSpreadSetting, materialMonthCol);
SpreadJsObj.initSheet(materialMonthSpread.getActiveSheet(), materialMonthSpreadSetting);
SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, ml);
monthFunGather._setMonthHtml();
},
monthsListSet: function (ml = materialBillsData, checked = true) {
if($('#bills0_list').is(':checked') && checked) {
ml = _.filter(materialBillsData, function (item) {
return item.quantity === null || item.quantity === 0;
});
}
const newMonthsList = _.filter(monthsList, function (item) {
return _.findIndex(ml, { code: item.code }) !== -1;
});
monthFunGather.monthSheetReset(newMonthsList);
}
};
const materialMonthSpread = SpreadJsObj.createNewSpread($('#material-month-spread')[0]);
const materialMonthSpreadSetting = {
cols: static_cols,
emptyRows: 0,
headRows: 2,
headRowHeight: [25, 25],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
readOnly: readOnly,
};
if (months.length > 0) {
const monthCols = monthFunGather._monthHeaderSet();
const monthSpreadHeaderCols = static_cols.concat(monthCols);
materialMonthSpreadSetting.cols = monthSpreadHeaderCols;
}
const materialMonthCol = {
getValue: {
average_msg_tp: function (data) {
let msg_tp = 0;
let hadnum = 0;
for (const m of months) {
msg_tp += data[m];
if (data[m] !== null && data[m] !== '' && data[m] !== 0) {
hadnum++;
}
}
const average_tp = hadnum !== 0 ? ZhCalc.round(ZhCalc.div(msg_tp, hadnum), materialDecimal.up) : ZhCalc.round(ZhCalc.div(msg_tp, months.length), materialDecimal.up);
return average_tp;
},
},
readOnly: {
isEdit: function (data) {
return readOnly;
},
},
};
materialMonthSpread.getActiveSheet().frozenColumnCount(5);
materialMonthSpread.getActiveSheet().options.frozenlineColor = '#f1f1f1';
SpreadJsObj.initSpreadSettingEvents(materialMonthSpreadSetting, materialMonthCol);
SpreadJsObj.initSheet(materialMonthSpread.getActiveSheet(), materialMonthSpreadSetting);
SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, monthsList);
const materialMonthSpreadObj = {
editEnded: function (e, info) {
if (info.sheet.zh_setting) {
const select = SpreadJsObj.getSelectObject(info.sheet);
const col = info.sheet.zh_setting.cols[info.col];
// 未改变值则不提交
let validText = is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
const orgValue = select[col.field];
if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
if (col.field === 'origin') {
select[col.field] = validText;
postData(window.location.pathname + '/month/save', { type:'updateOrigin', updateData: { mb_id: select.mb_id, value: validText } }, function (result) {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
materialBillsData = result.materialBillsData;
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
}, function () {
select[col.field] = orgValue;
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
} else {
// 判断部分值是否输入的是数字判断和数据计算
if (isNaN(validText)) {
toastr.error('不能输入其它非数字类型字符');
SpreadJsObj.reLoadRowData(info.sheet, info.row);
return;
}
const num = parseFloat(validText);
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (validText !== null && (num < 0 || !reg.test(num))) {
toastr.warning('已保留'+ materialDecimal.up +'位小数');
validText = ZhCalc.round(num, materialDecimal.up);
}
select[col.field] = validText;
// 更新至服务器
postData(window.location.pathname + '/month/save', { type:'update', updateData: { mb_id: select.mb_id, yearmonth: col.field, value: validText } }, function (result) {
SpreadJsObj.reLoadRowData(info.sheet, info.row);
materialBillsData = result.materialBillsData;
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
resetTpTable();
}, function () {
select[col.field] = orgValue;
SpreadJsObj.reLoadRowData(info.sheet, info.row);
});
}
}
},
deletePress: function (sheet) {
// if (sheet.zh_setting && sheet.zh_data) {
// const sel = sheet.getSelections()[0];
// if (!sel) return;
//
// const col = sheet.zh_setting.cols[sel.col];
// const select = SpreadJsObj.getSelectObject(sheet);
// const orgValue = select[col.field];
// if (sel.colCount > 1 || sel.rowCount > 1) {
// toastr.warning('请勿同时删除多行或多列数据');
// }
// console.log(sel, select, col);
// if (orgValue === null || col.field === 'type' || col.field === 'is_summary') {
// return;
// }
// select[col.field] = null;
// select.calc_num = materialExponentCol.getValue.calc_num(select);
// console.log(select);
// 更新至服务器
// postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
// ex_tp = result.ex_tp;
// ex_expr = result.ex_expr;
// resetExTpTable();
// SpreadJsObj.reLoadRowData(sheet, sel.row);
// materialExponentData.splice(sel.row, 1, select);
// }, function () {
// select[col.field] = orgValue;
// SpreadJsObj.reLoadRowData(sheet, sel.row);
// });
// }
return;
},
clipboardPasted(e, info) {
const hint = {
cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
numberCan: {type: 'warning', msg: '已保留'+ materialDecimal.up +'位小数'},
};
const range = info.cellRange;
const sortData = info.sheet.zh_data || [];
if (info.cellRange.row + info.cellRange.rowCount > sortData.length) {
toastMessageUniq(hint.cellError);
SpreadJsObj.reLoadSheetHeader(materialMonthSpread.getActiveSheet());
SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
return;
}
if (sortData.length > 0 && range.col + range.colCount > 5 + months.length) {
toastMessageUniq(hint.cellError);
SpreadJsObj.reLoadSheetHeader(materialMonthSpread.getActiveSheet());
SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
return;
}
const data = [];
let pasteOrigin = false;
for (let iRow = 0; iRow < range.rowCount; iRow++) {
let bPaste = true;
const curRow = range.row + iRow;
const materialMonthData = sortData[curRow];
const hintRow = range.rowCount > 1 ? curRow : '';
let sameCol = 0;
for (let iCol = 0; iCol < range.colCount; iCol++) {
const curCol = range.col + iCol;
const colSetting = info.sheet.zh_setting.cols[curCol];
if (!colSetting) continue;
let validText = info.sheet.getText(curRow, curCol);
validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
const orgValue = sortData[curRow][colSetting.field];
if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
sameCol++;
if (range.colCount === sameCol) {
bPaste = false;
}
continue;
}
if (colSetting.field === 'origin') {
pasteOrigin = true;
} else {
const num = parseFloat(validText);
if (isNaN(validText)) {
toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
bPaste = false;
continue;
}
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (validText !== null && (num < 0 || !reg.test(num))) {
toastMessageUniq(getPasteHint(hint.numberCan, hintRow));
validText = ZhCalc.round(num, materialDecimal.up);
}
}
materialMonthData[colSetting.field] = validText;
sortData[curRow][colSetting.field] = validText;
}
if (bPaste) {
data.push(materialMonthData);
} else {
SpreadJsObj.reLoadRowData(info.sheet, curRow);
}
}
if (data.length === 0) {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
return;
}
// console.log(data);
if (pasteOrigin) {
// 更新至服务器
postData(window.location.pathname + '/month/save', { type:'pasteOrigin', updateData: data }, function (result) {
SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
materialBillsData = result.materialBillsData;
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
return;
});
} else {
// 更新至服务器
postData(window.location.pathname + '/month/save', { type:'paste', updateData: data }, function (result) {
SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
materialBillsData = result.materialBillsData;
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
resetTpTable();
}, function () {
SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
return;
});
}
},
};
// 应耗来源sjs
const material_source_cols = [
{title: '清单编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 100, formatter: '@'},
{title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 150, formatter: '@'},
{title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 70, formatter: '@'},
{title: '本期应耗', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 100, formatter: '@'},
];
const materialSourceSpread = SpreadJsObj.createNewSpread($('#material-source-spread')[0]);
const materialSourceSpreadSetting = {
cols: material_source_cols,
emptyRows: 0,
headRows: 1,
headRowHeight: [32],
defaultRowHeight: 21,
headerFont: '12px 微软雅黑',
font: '12px 微软雅黑',
readOnly: true,
};
SpreadJsObj.initSheet(materialSourceSpread.getActiveSheet(), materialSourceSpreadSetting);
SpreadJsObj.loadSheetData(materialSourceSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
let first = true;
function setListsData(sid = null, ms_id = null) {
if (first) {
// 加载清单数据 - 暂时统一加载，如有需要，切换成动态加载并缓存
postData(window.location.pathname + '/list/load', {sid}, async function (result) {
ledger = result.ledger;
curLedgerData = result.curLedgerData;
pos = result.pos;
curPosData = result.curPosData;
materialListData2 = result.materialListData;
gclList = result.gclList;
notJoinList = result.materialNotJoinListData;
selfList = result.materialSelfListData;
materialChecklistData = result.materialChecklistData;
if (isStageSelf) {
const newGclGatherListData = [];
for (const [index, s] of result.ledgerListData.entries()) {
gclGatherModel.loadLedgerData(_.cloneDeep(ledger), s);
gclGatherModel.loadPosData(_.cloneDeep(pos), result.posListData[index]);
const oneGclGatherData = gclGatherModel.gatherGclData().filter(item => {
return item.qc_qty || item.contract_qty || item.qc_minus_qty
});
newGclGatherListData.push(oneGclGatherData);
}
gclGatherListData = newGclGatherListData;
}
// 解析清单汇总数据
gclGatherModel.loadLedgerData(_.cloneDeep(ledger), curLedgerData);
gclGatherModel.loadPosData(_.cloneDeep(pos), curPosData);
gclGatherData = gclGatherModel.gatherGclData();
gclGatherData = gclGatherData.filter(item => {
return item.qc_qty || item.contract_qty || item.qc_minus_qty
});
if (openMaterialChecklist) {
// 取交集
const selfListGcl = _.uniq(_.map(selfList, 'gcl_id'));
gclGatherData = _.filter(gclGatherData, function (item) {
if (_.find(materialChecklistData, {
b_code: item.b_code,
name: item.name,
unit: item.unit,
unit_price: item.unit_price
})) {
return true;
} else {
const gcl_ids = item.leafXmjs ? _.uniq(_.map(item.leafXmjs, 'gcl_id')) : [];
const jiaoji = _.intersection(gcl_ids, selfListGcl);
if (jiaoji.length > 0) {
return true;
}
}
});
}
// calculateJiaCha(gclGatherData);
console.log(gclGatherData);
setCurBillSourceList(materialBillsData[0] ? materialBillsData[0].mb_id || materialBillsData[0].id : null, ms_id);
first = false;
// 判断是否需要更新contract_qty、qc_qty和qc_minus_qty
if (!materialIsNewQty && !readOnly && !editForAudit) {
let needUpdateList = [];
if (materialListData2.length > 0) {
if (isStageSelf) {
for (const msIndex in materialStageData) {
const materialStageList = _.filter(materialListData2, { ms_id: materialStageData[msIndex].id });
const gclIdList = _.uniq(_.map(materialListData2, 'gcl_id'));
let leafXmjList = [];
for (const id of gclIdList) {
const gcl = _.find(gclGatherListData[msIndex], function (item) {
return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, {gcl_id: id}) !== -1;
});
if (gcl) leafXmjList = [...leafXmjList, ...gcl.leafXmjs];
}
for (const ml of materialStageList) {
const leafXmjInfo = _.find(leafXmjList, function (item) {
return item.gcl_id === ml.gcl_id && item.id === ml.xmj_id && (item.mx_id === undefined || (item.mx_id !== undefined && item.mx_id === ml.mx_id));
});
if (leafXmjInfo) {
needUpdateList.push({ id: ml.id, contract_qty: leafXmjInfo.contract_qty, qc_qty: leafXmjInfo.qc_qty, qc_minus_qty: leafXmjInfo.qc_minus_qty });
}
}
}
} else {
// 找出所有gcl相同的，方便搜索gclGatherData值
const gclIdList = _.uniq(_.map(materialListData2, 'gcl_id'));
let leafXmjList = [];
for (const id of gclIdList) {
const gcl = _.find(gclGatherData, function (item) {
return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, {gcl_id: id}) !== -1;
});
if (gcl) leafXmjList = [...leafXmjList, ...gcl.leafXmjs];
}
for (const ml of materialListData2) {
const leafXmjInfo = _.find(leafXmjList, function (item) {
return item.gcl_id === ml.gcl_id && item.id === ml.xmj_id && (item.mx_id === undefined || (item.mx_id !== undefined && item.mx_id === ml.mx_id));
});
if (leafXmjInfo) {
needUpdateList.push({ id: ml.id, contract_qty: leafXmjInfo.contract_qty, qc_qty: leafXmjInfo.qc_qty, qc_minus_qty: leafXmjInfo.qc_minus_qty });
}
}
}
}
console.log(needUpdateList);
postData(window.location.pathname + '/save', { type: 'qty_update', needUpdateList }, function (result) {
materialListData2 = result.materialListData;
});
}
});
} else {
const i = _.findIndex(materialStageData, { sid });
gclGatherData = gclGatherListData[i];
gclGatherData = gclGatherData.filter(item => {
return item.qc_qty || item.contract_qty || item.qc_minus_qty
});
if (openMaterialChecklist) {
// 取交集
const selfListGcl = _.uniq(_.map(selfList, 'gcl_id'));
gclGatherData = _.filter(gclGatherData, function (item) {
if (_.find(materialChecklistData, {
b_code: item.b_code,
name: item.name,
unit: item.unit,
unit_price: item.unit_price
})) {
return true;
} else {
const gcl_ids = item.leafXmjs ? _.uniq(_.map(item.leafXmjs, 'gcl_id')) : [];
const jiaoji = _.intersection(gcl_ids, selfListGcl);
if (jiaoji.length > 0) {
return true;
}
}
});
}
// calculateJiaCha(gclGatherData);
console.log(gclGatherData);
}
}
setListsData(isStageSelf ? materialStageData[0].sid : null, isStageSelf ? materialStageData[0].id : null);
SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
materialSpreadObj.getMaterialBillsData();
SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
materialSpreadObj.refreshActn();
materialMonthSpread.bind(spreadNS.Events.ClipboardPasted, materialMonthSpreadObj.clipboardPasted);
SpreadJsObj.addDeleteBind(materialMonthSpread, materialMonthSpreadObj.deletePress);
materialMonthSpread.bind(spreadNS.Events.EditEnded, materialMonthSpreadObj.editEnded);
// 期切换
$('#myTab a[data-toggle="tab"]').on('shown.bs.tab', function (e) {
e.preventDefault();
showWaitingView();
setTimeout(function () {
materialSpreadObj.getMaterialBillsData();
materialSpreadObj.materialSheetReset(true);
// SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
// 消耗量表格更新
let html = '';
calcBase = _.find(calcBaseList, { ms_id: $('#myTab').find('.active').data('msid') }).calcBase;
for (let iBase = 0; iBase < calcBase.length; iBase++) {
if (!calcBase[iBase].cType || (calcBase[iBase].cType && calcBase[iBase].cType === 1 && calcBase[iBase].value)) {
html += '| ' + calcBase[iBase].name + ' | ' + calcBase[iBase].code + ' | ' + calcBase[iBase].value + ' |
';
}
}
$('#calcBase').html(html);
const ms_id = parseInt($('#myTab').find('.active').data('msid'));
const msInfo = _.find(materialStageData, { id: ms_id });
setListsData(msInfo.sid, ms_id);
const data = SpreadJsObj.getSelectObject(materialSpread.getActiveSheet());
setCurBillSourceList(data ? (data.mb_id || data.id) : null, ms_id);
closeWaitingView();
}, 1000);
});
// 本条工料应耗来源数据信息
function setCurBillSourceList(mb_id, ms_id = null) {
const showSourceList = [];
if (mb_id) {
const list = _.filter(materialListData2, function (item) {
return item.mb_id === mb_id && item.ms_id === ms_id && (item.is_join === 1 || item.is_join === 2);
});
console.log(list);
if (list.length > 0) {
for (const l of list) {
const gcl = _.find(gclGatherData, function (item) {
return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, { gcl_id: l.gcl_id }) !== -1;
});
if (gcl) {
const index = _.findIndex(showSourceList, { code: gcl.b_code, name: gcl.name, unit: gcl.unit });
if (index === -1) {
showSourceList.push({
code: gcl.b_code,
name: gcl.name,
unit: gcl.unit,
quantity: ZhCalc.mul(calcQty(l), l.quantity),
});
} else {
showSourceList[index].quantity = ZhCalc.add(showSourceList[index].quantity, ZhCalc.mul(calcQty(l), l.quantity));
}
}
}
}
}
// 按清单编号排序
SpreadJsObj.loadSheetData(materialSourceSpread.getActiveSheet(), SpreadJsObj.DataType.Data, showSourceList.sort(sortByCode));
}
function calcQty(info) {
let qty = '';
switch (qtySource) {
case qtySourceValueConst.gather_qty: qty = info.gather_qty; break;
case qtySourceValueConst.contract_qty: qty = info.contract_qty; break;
case qtySourceValueConst.gather_minus_qty: qty = ZhCalc.add(info.gather_qty, info.qc_minus_qty); break;
default: throw '未配置计量来源出错';
}
if (qtySource !== qtySourceValueConst.contract_qty && info.is_join === 2) {
qty = info.contract_qty;
}
return qty;
}
if (!readOnly || editForAudit) {
$('#expr_select button').on('click', function () {
const code = $(this).text();
// $('#expr').val($('#expr').val() + code);
$('#expr').insertAtCaret(code);
});
const ExprObj = {
_checkExprValid(expr, invalidParam) {
if (!expr) return [true, null];
const param = [];
let num = '', base = '';
for (let i = 0, iLen = expr.length; i < iLen; i++) {
if (/^[\d\.%]+/.test(expr[i])) {
if (base !== '') {
param.push({type: 'base', value: base});
base = '';
}
num = num + expr[i];
} else if (/^[a-z]/.test(expr[i])) {
if (num !== '') {
param.push({type: 'num', value: num});
num = '';
}
base = base + expr[i];
} else if (expr[i] === '(') {
if (num !== '') {
param.push({type: 'num', value: num});
num = '';
}
if (base !== '') {
param.push({type: 'base', value: base});
base = '';
}
param.push({type: 'left', value: '('});
} else if (expr[i] === ')') {
if (num !== '') {
param.push({type: 'num', value: num});
num = '';
}
if (base !== '') {
param.push({type: 'base', value: base});
base = '';
}
param.push({type: 'right', value: ')'});
} else if (/^[\+\-*\/]/.test(expr[i])) {
if (num !== '') {
param.push({type: 'num', value: num});
num = '';
}
if (base !== '') {
param.push({type: 'base', value: base});
base = '';
}
param.push({type: 'calc', value: expr[i]});
} else {
return [false, '输入的表达式含有非法字符: ' + expr[i]];
}
}
if (num !== '') {
param.push({type: 'num', value: num});
num = '';
}
if (base !== '') {
param.push({type: 'base', value: base});
base = '';
}
if (param.length === 0) return true;
if (param.length > 1) {
if (param[0].value === '-' && param[1].type === 'num') {
param[1].value = '-' + param[1].value;
param.shift();
}
}
const iLen = param.length;
let iLeftCount = 0, iRightCount = 0;
for (const [i, p] of param.entries()) {
if (p.type === 'calc') {
if (i === 0 || i === iLen - 1)
return [false, '输入的表达式非法：计算符号' + p.value + '前后应有数字或计算基数'];
}
if (p.type === 'num') {
num = p.value.replace('%', '');
if (p.value.length - num.length > 1)
return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字'];
num = _.toNumber(num);
if (num === undefined || num === null || _.isNaN(num))
return [false, '输入的表达式非法：' + p.value + '不是一个有效的数字'];
if (i > 0) {
if (param[i - 1].type !== 'calc' && param[i - 1].type !== 'left') {
return [false, '输入的表达式非法：' + p.value + '前应有运算符'];
} else if (param[i - 1].value === '/' && num === 0) {
return [false, '输入的表达式非法：请勿除0'];
}
}
}
if (p.type === 'base') {
const baseParam = _.find(calcBase, {code: p.value});
if (!baseParam)
return [false, '输入的表达式非法：不存在计算基数' + p.value];
if (invalidParam && invalidParam.indexOf(p.value) >= 0)
return [false, '不可使用计算基数' + p.value];
if (i > 0 && (param[i - 1].type === 'num' || param[i - 1].type === 'right'))
return [false, '输入的表达式非法：' + p.value + '前应有运算符'];
}
if (p.type === 'left') {
iLeftCount += 1;
if (i !== 0 && param[i-1].type !== 'calc')
return [false, '输入的表达式非法：（前应有运算符'];
}
if (p.type === 'right') {
iRightCount += 1;
if (i !== iLen - 1 && param[i+1].type !== 'calc')
return [false, '输入的表达式非法：)后应有运算符'];
if (iRightCount > iLeftCount)
return [false, '输入的表达式非法：")"前无对应的"（"'];
}
}
if (iLeftCount > iRightCount)
return [false, '输入的表达式非法："("后无对应的"）"'];
return [true, ''];
},
_checkExpr: function (text) {
if (text) {
const num = _.toNumber(text);
if (num) {
console.log(num);
} else {
const expr = text.replace('=', '').toLowerCase();
const [valid, msg] = this._checkExprValid(expr);
if (!valid) return [valid, msg];
}
}
return [true, ''];
},
};
$('#expr_btn').click(function () {
const expr = $('#expr').val();
// 判断表达式格式
const [valid, msg] = ExprObj._checkExpr(expr);
if (!valid) {
toastr.error(msg);
return false;
}
postData(window.location.pathname + '/save', { type:'expr', id: $('#materialbillsId').val(), expr: expr, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
const sheet = materialSpread.getActiveSheet();
const select = SpreadJsObj.getSelectObject(sheet);
const index = _.findIndex(materialBillsData, { id: select.id });
let newIndex = index;
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
result.info = materialSpreadObj.updateOneMaterialBill(result.info);
}
if($('#bills0_list').is(':checked')) {
const newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
newIndex = _.findIndex(newMaterialBillsData, { id: select.id });
// newIndex = newMaterialBillsData.indexOf(select);
newMaterialBillsData.splice(newIndex, 1, result.info);
sheet.zh_data[newIndex] = result.info;
}
materialBillsData.splice(index, 1, result.info);
sheet.zh_data.splice(newIndex, 1, result.info);
SpreadJsObj.reLoadRowData(sheet, newIndex);
resetTpTable();
$('#bcyy').modal('hide');
});
});
}
if (!readOnly && !editForAudit) {
$('#add').click(materialSpreadObj.add);
$('#del').click(materialSpreadObj.del);
$('#up-move').click(materialSpreadObj.upMove);
$('#down-move').click(materialSpreadObj.downMove);
// 右键菜单
$.contextMenu({
selector: '#material-spread',
build: function ($trigger, e) {
const target = SpreadJsObj.safeRightClickSelection($trigger, e, materialSpread);
return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
},
items: {
'create': {
name: '新增材料',
icon: 'fa-sign-in',
callback: function (key, opt) {
materialSpreadObj.add(materialSpread.getActiveSheet());
},
},
'delete': {
name: '删除材料',
icon: 'fa-remove',
callback: function (key, opt) {
materialSpreadObj.del(materialSpread.getActiveSheet());
},
disabled: function (key, opt) {
const sheet = materialSpread.getActiveSheet();
const select = SpreadJsObj.getSelectObject(sheet);
const sel = sheet.getSelections()[0];
materialSpreadObj.refreshActn(sel.rowCount);
if (!readOnly && select && materialBase.isUsed(select) && sel.rowCount === 1) {
return false;
} else {
return true;
}
}
},
}
});
$('.changeRate').click(function () {
$('#rateInput').val(parseInt($(this).data('value')));
$('#rateInput').siblings('.dropdown-menu').hide();
});
$('#rateInput').click(function () {
$(this).siblings('.dropdown-menu').show();
})
// 回车提交
$('#rateInput').on('keypress', function () {
if(window.event.keyCode === 13) {
$(this).blur();
}
});
$('#rateInput').blur(function () {
const _self = $(this);
setTimeout(function () {
let rate = parseFloat(_self.val());
if (_.isNaN(rate)) {
toastr.error('请输入0-100之前的整数值');
$('#rateInput').val(materialRate);
return;
}
rate = _.round(rate);
if(rate < 0 || rate > 100) {
toastr.error('请输入0-100之前的整数值');
$('#rateInput').val(materialRate);
return;
}
$('#rateInput').siblings('.dropdown-menu').hide();
console.log(rate, materialRate);
if (rate !== materialRate) {
postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
// const exbqhs = ZhCalc.round(ZhCalc.mul(ex_tp, 1+rate/100), materialDecimal.tp);
const jzbqhs = ZhCalc.round(ZhCalc.add(pre_tp_hs, bqhs), materialDecimal.tp);
// const exjzbqhs = ZhCalc.round(ZhCalc.add(ex_pre_tp_hs, exbqhs), materialDecimal.tp);
$('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
$('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
// $('#rate_set').find('td').eq(3).text(exbqhs !== 0 ? exbqhs : '');
// $('#rate_set').find('td').eq(4).text(exjzbqhs !== 0 ? exjzbqhs : '');
materialRate = rate;
$('#rateInput').val(rate);
});
} else {
$('#rateInput').val(rate);
}
}, 500);
});
// $('#changeRate').change(function () {
// const rate = parseInt($(this).val());
// postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
// const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
// const exbqhs = ZhCalc.round(ZhCalc.mul(ex_tp, 1+rate/100), materialDecimal.tp);
// const jzbqhs = ZhCalc.round(ZhCalc.add(pre_tp_hs, bqhs), materialDecimal.tp);
// const exjzbqhs = ZhCalc.round(ZhCalc.add(ex_pre_tp_hs, exbqhs), materialDecimal.tp);
// $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
// $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
// $('#rate_set').find('td').eq(3).text(exbqhs !== 0 ? exbqhs : '');
// $('#rate_set').find('td').eq(4).text(exjzbqhs !== 0 ? exjzbqhs : '');
// });
// });
// 创建月信息价
$('#make-month').click(function() {
const yearmonth = $('#months').val();
const result = yearmonth.match(/^(\d{1,4})(-|\/)(\d{1,2})$/);
if (result === null) {
toastr.error('请选择正确的信息价月份');
return false;
}
//判断是否已存在当前月份
if (months.indexOf(yearmonth) !== -1) {
toastr.error('调差期已创建过本月的信息价');
return false;
}
postData(window.location.pathname + '/month/save', { type: 'add', updateData: { yearmonth: yearmonth } }, function (data) {
months.push(yearmonth);
months.sort();
monthsList = data.monthsList;
monthFunGather.monthsListSet();
// 工料表单价显示也要更新
materialBillsData = data.materialBillsData;
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
m_tp = data.m_tp;
if (materialTax) {
m_tax_tp = data.m_tax_tp;
}
resetTpTable();
$('#add-month').modal('hide');
});
});
// 删除月信息价
$('#del-month').click(function () {
const del_month_array = [];
$("input[name='del_month']:checked").each(function () {
del_month_array.push($(this).val());
});
if (del_month_array.length === 0) {
toastr.error('请选择要移除的月信息价');
return false;
}
postData(window.location.pathname + '/month/save', { type: 'del', updateData: { del_yearmonth: del_month_array } }, function (data) {
for (const dm of del_month_array) {
// _.remove(materialMonthSpreadSetting.cols, function (n) {
// return n.field === dm;
// });
_.remove(months, function (n) {
return n === dm;
});
}
monthsList = data.monthsList;
monthFunGather.monthsListSet();
// 工料表单价显示也要更新
materialBillsData = data.materialBillsData;
materialSpreadObj.materialSheetReset();
// SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
m_tp = data.m_tp;
if (materialTax) {
m_tax_tp = data.m_tax_tp;
}
resetTpTable();
$('#remove-month').modal('hide');
});
});
// 导入功能
let importFile = null;
$('#upload-xls-file').change(function () {
const file = this.files[0];
importFile = file;
});
$('#import-bills-btn').click(function() {
if (!importFile) {
toastr.error('请选择excel文件再确定');
return;
}
const ext = importFile.name.toLowerCase().split('.').splice(-1)[0];
const imgStr = /(xls|xlsx|XLS|XLSX)$/;
if (!imgStr.test(ext)) {
toastr.error('请导入正确格式的excel文件。');
return
}
const fileReader = new FileReader();
fileReader.onload = async function(ev) {
try{
const data = ev.target.result;
let tree = [];
const includeSpec = $('#xls-spec').is(':checked');
if (/(xls|xlsx|XLS|XLSX)$/.test(ext)) {
const workbook = XLSX.read(data, {type: 'binary'}); // 以二进制流方式读取得到整份excel表格对象
const jsonData = transExcel(XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[0]], { defval: null }));
console.log(jsonData);
if (!(jsonData[0] && jsonData[0].code !== undefined && jsonData[0].code !== null && jsonData[0].unit !== undefined && jsonData[0].name !== undefined &&
jsonData[0].spec !== undefined && jsonData[0].msg_tp !== undefined && jsonData[0].msg_times !== undefined)) {
throw 'excel必须按指定格式内容上传';
}
// 去重
tree = _.unionWith(jsonData, function (item1, item2) {
return item1.code === item2.code && item1.name === item2.name && item1.unit === item2.unit && (!includeSpec || (includeSpec && item1.spec === item2.spec));
});
}
if (tree.length === 0) {
throw '该excel不存在导入的数据';
}
// 判断msg_tp格式，不符合则无法导入,还有excel日期转换问题
for (const t of tree) {
t.code = t.code.toString();
if (t.msg_tp) {
if (_.isNumber(t.msg_tp)) {
const num = parseFloat(t.msg_tp);
const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
if (num < 0 || !reg.test(num)) {
t.msg_tp = ZhCalc.round(num, materialDecimal.up);
}
} else {
throw '信息价数据存在非数字字符，无法导入';
}
}
if (_.isNumber(t.msg_times)) {
t.msg_times = formatDate(t.msg_times, '/');
}
t.spec = t.spec === null ? '' : t.spec;
}
console.log(tree);
postData(window.location.pathname + '/save', { type:'export', postData: tree, includeSpec, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
m_tp = result.m_tp;
if (materialTax) {
m_tax_tp = result.m_tax_tp;
}
materialBillsData = result.billsData;
if (isStageSelf) {
materialStageData = result.stageData;
materialStageBillsData = result.stageBillsData;
}
materialSpreadObj.getMaterialBillsData();
materialSpreadObj.materialSheetReset(true);
if (months.length > 0) {
monthsList = result.monthsList;
monthFunGather.monthsListSet();
}
resetTpTable();
if (result.addNum || result.updateNum) {
let msg = [];
if (result.addNum !== undefined && result.addNum !== 0) {
msg.push('成功导入工料 ' + result.addNum + ' 条');
}
if (result.updateNum !== undefined && result.updateNum !== 0) {
msg.push('成功更新工料 ' + result.updateNum + ' 条');
}
toastr.success(msg.length > 1 ? msg.join('，并') : msg[0]);
} else {
toastr.warning('不存在可导入的信息价数据');
}
$('#import-info').modal('hide');
});
} catch (error) {
console.log(error);
toastr.error(error);
return
}
};
// 以二进制方式打开文件
fileReader.readAsBinaryString(importFile);
$('#upload-xls-file').val('');
importFile = null;
});
} else {
// SpreadJsObj.forbiddenSpreadContextMenu('#material-spread', materialSpread);
}
// 筛选调差工料本期应耗数量为0
$('#bills0_list').click(function () {
const isCheck = $(this).is(':checked');
let newMaterialBillsData = materialBillsData;
if (isCheck) {
newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
}
SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
monthFunGather.monthsListSet(newMaterialBillsData, false);
materialSpreadObj.refreshActn();
});
let gljLib;
const gljLibCellDoubleClick = function (e, info) {
if (readOnly || editForAudit) return;
const gljSheet = info.sheet;
if (!gljSheet.zh_setting || !gljSheet.zh_tree) { return; }
const gljTree = gljSheet.zh_tree;
const gljNode = gljTree.nodes[info.row];
const sheet = materialSpread.getActiveSheet();
const select = SpreadJsObj.getSelectObject(sheet);
if (!gljNode) return;
if (gljNode && gljNode.is_leaf === 0) {
toastr.warning('非最底层项目下，不应添加');
return;
}
postData(window.location.pathname + '/save', { type:'add-glj', postData: gljNode, order: select ? select.order : null }, function (result) {
if (result) {
// 比order大的+1
const maxData = select ? _.filter(materialBillsData, (item) => { return item.order > select.order }) : [];
_.forEach(maxData, function (item) {
const cl = _.find(materialBillsData, { id: item.id });
cl.order = item.order + 1;
});
materialBillsData.push(result.info);
materialBillsData.sort(function (a, b) {
return a.order - b.order
});
console.log(materialBillsData);
if (isStageSelf) {
materialSpreadObj.updateMaterialData(result);
materialSpreadObj.getMaterialBillsData();
}
// sheet.addRows(materialBillsData.length - 1, 1);
// SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
let newMaterialBillsData = materialBillsData;
if($('#bills0_list').is(':checked')) {
newMaterialBillsData = _.filter(materialBillsData, function (item) {
return item.quantity !== null && item.quantity !== 0;
});
}
SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
// materialSpreadObj.materialSheetReset();
sheet.setSelection(sheet.zh_data.indexOf(select) + 1, 0, 1, 1);
materialSpreadObj.refreshActn();
// 月信息价需要同时添加空白的list
if (months.length > 0) {
const one_month ={ mb_id: result.info.id, code: result.info.code, name: result.info.name, origin: result.info.origin, unit: result.info.unit, order: result.info.order };
for (const m of months) {
one_month[m] = null;
}
_.forEach(maxData, function (item) {
const cl = _.find(monthsList, { mb_id: item.id });
cl.order = item.order + 1;
});
monthsList.push(one_month);
monthsList.sort(function (a, b) {
return a.order - b.order
});
console.log(monthsList);
// const newMonthsList = _.filter(monthsList, function (item) {
// return _.findIndex(newMaterialBillsData, { code: item.code }) !== -1;
// });
// materialMonthSpread.getActiveSheet().addRows(newMonthsList.length - 1, 1);
// SpreadJsObj.reLoadRowData(materialMonthSpread.getActiveSheet(), newMonthsList.length - 1);
monthFunGather.monthsListSet();
// materialMonthSpreadObj.monthsListSet();
}
}
});
};
const gljLibSetting = {
selector: '#material-tab',
stdType: 'glj',
libs: gljLists,
treeSetting: {
id: 'glj_id',
pid: 'glj_pid',
order: 'order',
level: 'level',
rootId: -1,
keys: ['id', 'list_id', 'glj_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},
{title: '参考上涨幅度', field: 'rise_range', hAlign: 1, width: 50, formatter: '@', readOnly: true},
{title: '参考下跌幅度', field: 'fall_range', 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',
},
spreadClassCss: 'sjs-material',
cellDoubleClick: gljLibCellDoubleClick,
page: 'material',
tid: window.location.pathname.split('/')[2],
};
$.subMenu({
menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
key: 'menu.1.0.0',
miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
callback: function (info) {
if (info.mini) {
$('.panel-title').addClass('fluid');
$('#sub-menu').removeClass('panel-sidebar');
} else {
$('.panel-title').removeClass('fluid');
$('#sub-menu').addClass('panel-sidebar');
}
autoFlashHeight();
materialSpread.refresh();
}
});
$.divResizer({
select: '#right-spr',
callback: function () {
materialSpread.refresh();
materialMonthSpread.refresh();
if (gljLib) gljLib.spread.refresh();
const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
setLocalCache('material_month_' + materialID, width);
}
});
$.divResizer({
select: '#main-resize',
callback: function () {
let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
$(".sp-wrap").height(bcontent-30);
const height = $('.bcontent-wrap').height();
const cutHeight = isStageSelf ? getObjHeight($('#myTab')) : 0;
$('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
updateSjsHeight();
materialSpread.refresh();
materialMonthSpread.refresh();
if (gljLib) gljLib.spread.refresh();
setLocalCache('material_bills_' + materialID, height);
}
});
// 展开收起月信息价并浏览器记住本期展开收起
$('a', '.right-nav').bind('click', function () {
//const main = $('#main-view'), tool = $('#tools-view');
const tab = $(this), tabPanel = $(tab.attr('content'));
if (!tab.hasClass('active')) {
$('a', '.side-menu').removeClass('active');
$('#right-view .tab-content .tab-pane').removeClass('active');
tab.addClass('active');
tabPanel.addClass('active');
showSideTools(tab.hasClass('active'));
if (tab.attr('content') === '#month-tab') {
const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
setLocalCache('material_month_' + materialID, width);
materialMonthSpread.refresh();
} else if (tab.attr('content') === '#material-tab') {
if (!gljLib) {
gljLib = $.gljLib(gljLibSetting);
}
updateSjsHeight();
gljLib.spread.refresh();
}
} else {
removeLocalCache('material_month_' + materialID);
tab.removeClass('active');
tabPanel.removeClass('active');
showSideTools(tab.hasClass('active'));
}
materialSpread.refresh();
// materialMonthSpread.refresh();
});
// 根据浏览器记录展开收起
if (getLocalCache('material_month_' + materialID) && !isStageSelf) {
const tab = $('.right-nav a[content="#month-tab"]'), tabPanel = $(tab.attr('content'));
$('a', '.side-menu').removeClass('active');
$('#right-view .tab-content .tab-pane').removeClass('active');
tab.addClass('active');
tabPanel.addClass('active');
$('#right-view').width(getLocalCache('material_month_' + materialID) + '%');
showSideTools(tab.hasClass('active'));
materialSpread.refresh();
materialMonthSpread.refresh();
}
const cutHeight = isStageSelf ? getObjHeight($('#myTab')) : 0;
if (getLocalCache('material_bills_' + materialID)) {
$('.bcontent-wrap').height(getLocalCache('material_bills_' + materialID));
const cHeader = getObjHeight($(".c-header"));
const bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
$(".sp-wrap").height(bcontent-30);
$('.sjs-height-1').height($(window).height()-cHeader-bcontent-90+53);
$('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
updateSjsHeight();
materialSpread.refresh();
materialMonthSpread.refresh();
if (gljLib) gljLib.spread.refresh();
} else {
$('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
updateSjsHeight();
materialSpread.refresh();
materialMonthSpread.refresh();
if (gljLib) gljLib.spread.refresh();
}
function updateSjsHeight() {
$('.sjs-height-material-month').height($('.sjs-height-1').height() - getObjHeight($('.sjs-bar-1')));
$('.material-table-height').height($('.bcontent-wrap').height() - getObjHeight($('.bc-bar')));
$('.sjs-material').height($('.sjs-height-1').height() - getObjHeight($('.sjs-bar')));
}
function getObjHeight(select) {
return select.length > 0 ? select.outerHeight() : 0;
}
function formatDate(numb, format) {
const old = numb - 1;
const t = Math.round((old - Math.floor(old)) * 24 * 60 * 60);
const time = new Date(1900, 0, old, 0, 0, t);
const year = time.getFullYear();
const month = time.getMonth() + 1;
const date = time.getDate();
return year + format + (month < 10 ? '0' + month : month) + format + (date < 10 ? '0' + date : date);
}
function transExcel(results) {
const mapInfo = {
'编号': 'code',
'名称': 'name',
'单位': 'unit',
'规格': 'spec',
'信息价': 'msg_tp',
'时间': 'msg_times',
};
return results.map(zhObj => {
const enObj = {}
const zhKeys = Object.keys(zhObj);
zhKeys.forEach(zhKey => {
const enKey = mapInfo[zhKey];
enObj[enKey] = zhObj[zhKey] && _.isString(zhObj[zhKey]) ? _.trim(zhObj[zhKey]) : zhObj[zhKey];
});
return enObj
})
}
});