'use strict'; /** * 材料调差 - 调差清单设置 * * @author EllisRan * @date 2022/1/7 * @version */ function getStageId() { return window.location.pathname.split('/')[5]; } function findNotJoinLeafXmj(x, type = '') { if (type === 'index') { return notJoinList.findIndex(function (item) { return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id)); }); } return notJoinList.find(function (item) { return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id)); }); } function findNotChangeLeafXmj(x, type = '') { if (type === 'index') { return notChangeList.findIndex(function (item) { return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id)); }); } return notChangeList.find(function (item) { return item.gcl_id === x.gcl_id && item.xmj_id === x.id && (x.mx_id === undefined || (x.mx_id !== undefined && x.mx_id === item.mx_id)); }); } function getPasteHint (str, row = '') { let returnObj = str; if (row) { returnObj.msg = '清单第' + (row+1) + '行' + (str.msg ? str.msg : str); } return returnObj; } function makeChecklistData(lists, checklists) { let html = ''; if (lists.length > 0) { for(const [i,l] of lists.entries()) { const checklistInfo = _.find(checklists, { b_code: l.b_code, name: l.name, unit: l.unit, unit_price: l.unit_price }); const isChecked = checklistInfo ? ' checked' : ''; const isDisabled = checklistInfo && checklistInfo.had_bills === 1 ? ' disabled' : ''; html += '\n' + '
\n' + ' \n' + ' \n' + '
\n' + ' '+ (i+1) +'\n' + ' '+ l.b_code +'\n' + ' '+ l.name +'\n' + ' '+ (l.unit ? l.unit : '') +'\n' + ' '+ (l.unit_price ? l.unit_price : '') +'\n' + ' '+ (l.quantity ? l.quantity : '') +'\n' + ' '+ (l.total_price ? l.total_price : '') +'\n' + ' '; } } $('#lists_data').html(html); } // 清单搜索隐藏清单table部分值 function remakeChecklistData(lists, showListData = lists) { // 先加载台账数据 if (lists.length > 0) { for (const [index,gcl] of lists.entries()) { const isShow = _.find(showListData, gcl); $('#lists_data tr').eq(index).css('display', (isShow ? 'table-row' : 'none')); } } } $(document).ready(() => { function TipCellType() { } TipCellType.prototype = new GC.Spread.Sheets.CellTypes.ColumnHeader(); TipCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) { return { x: x, y: y, row: context.row, col: context.col, cellRect: cellRect, sheetArea: context.sheetArea, sheet: context.sheet }; }; TipCellType.prototype.processMouseEnter = function (hitInfo){ if (!this._toolTipElement) { var div = document.createElement("div"); $(div).css("position", "absolute") .css("border", "1px #C0C0C0 solid") .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)") .css("font", "9pt Arial") .css("background", "#fff") // .css("color", "#fff") .css("z-index", "1000") .css("padding", 5); this._toolTipElement = div; } $(this._toolTipElement).text("单位数量:每一单位清单下所需工料消耗量。") .css("top", hitInfo.y + 15) .css("left", hitInfo.x - 15); $(this._toolTipElement).hide(); // document.body.insertBefore(this._toolTipElement, null); $('#material-spread-div').append(this._toolTipElement, null); $(this._toolTipElement).show("fast"); }; TipCellType.prototype.processMouseLeave = function (hitInfo) { if (this._toolTipElement) { this._toolTipElement.remove(); this._toolTipElement = null; } }; autoFlashHeight(); // 清单table const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]); const ledgerSpreadSetting = { cols: [ {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@'}, {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 220, formatter: '@'}, {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@'}, {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 70, type: 'Number'}, {title: '工程量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 90, type: 'Number'}, {title: '台账金额', colSpan: '1', rowSpan: '2', field: 'total_price', hAlign: 2, width: 110, type: 'Number'}, ], emptyRows: 0, headRows: 1, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: true, }; SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting); // 加载清单数据 - 暂时统一加载,如有需要,切换成动态加载并缓存 postData(window.location.pathname + '/load', { sid: isStageSelf ? materialStageData[0].sid : null }, function (result) { ledger = result.ledger; curLedgerData = result.curLedgerData; pos = result.pos; curPosData = result.curPosData; // materialListData = result.materialListData; notJoinList = result.materialNotJoinListData; notChangeList = result.materialNotChangeListData; materialChecklistData = result.materialChecklistData; gclList = result.gclList; if (isStageSelf) { // updateBillsData(ms_id); 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(ledger, curLedgerData); gclGatherModel.loadPosData(pos, curPosData); // gclGatherData = gclGatherModel.gatherGclData().filter(function (item) { // return item.unit_price || item.quantity; // }); gclGatherData = gclGatherModel.gatherGclData(); console.log(gclGatherData); const hadBillsidList = _.uniq(_.map(gclList, 'gcl_id')); console.log(hadBillsidList, materialChecklistData); // 对比清单设置和调差清单,还要和台账对比,显示已选清单列表 不同则更新到清单设置页中 const pushData = []; const updateData = []; for (const hb of hadBillsidList) { const gcl = _.find(gclGatherData, function (item) { return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, { gcl_id : hb }) !== -1; }); if (gcl) { const mc = _.find(materialChecklistData, { b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price }); // const newOrder = _.indexOf(gclGatherData, gcl); // console.log(newOrder); if (!mc && _.findIndex(pushData, { b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price }) === -1) { pushData.push({ b_code: gcl.b_code, name: gcl.name, unit: gcl.unit, unit_price: gcl.unit_price, quantity: (gcl.quantity ? gcl.quantity : null), total_price: (gcl.total_price ? gcl.total_price : null), had_bills: 1 }); } } } const removeData = []; for (const mc of materialChecklistData) { const gcl = _.find(gclGatherData, { b_code: mc.b_code, name: mc.name, unit: mc.unit, unit_price: mc.unit_price }); // 判断是否已不存在工料清单,台账修改过后删除之 if (!gcl) { removeData.push(mc.id); } else { const gcl_ids = gcl.leafXmjs ? _.uniq(_.map(gcl.leafXmjs, 'gcl_id')) : []; const jiaoji = _.intersection(gcl_ids, hadBillsidList); // const leafXmjs = gcl.leafXmjs ? gcl.leafXmjs.filter(item => item.gather_qty) : []; // 更新had_bills值 const updateObj = { id: mc.id }; if (mc.had_bills === 1) { if (jiaoji.length === 0) { updateObj.mid = materialID; updateObj.had_bills = 0; // updateData.push({ id: mc.id, mid: materialID, had_bills: 0 }); } } else if (mc.had_bills === 0) { if (jiaoji.length !== 0) { updateObj.had_bills = 1; } } // 更新工程量及台账金额 if (mc.quantity !== (gcl.quantity ? gcl.quantity : null)) { updateObj.quantity = gcl.quantity ? gcl.quantity : null; updateObj.total_price = gcl.total_price ? gcl.total_price : null; } if(!_.isEqual(updateObj,{ id: mc.id })) updateData.push(updateObj); } } console.log(pushData, removeData, updateData); setChecklistData(pushData, removeData, updateData, true); }); function setChecklistData(pushData, removeData, updateData = [], sendmsg = false) { if (pushData.length > 0 || removeData.length > 0 || updateData.length > 0) { postData(window.location.pathname + '/save', { type: 'resetChecklist', pushData, removeData, updateData }, function (result2) { if (sendmsg && pushData.length > 0) { toastr.success('已同步历史调差清单数据至本页中'); } if (sendmsg && removeData.length > 0) { toastr.warning('已删除部分与台账清单不匹配的清单数据'); } materialChecklistData = result2; showSjsData(); }) } else { showSjsData(); } } function showSjsData() { SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialChecklistData); SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet()); if (materialChecklistData.length > 0) { const index = _.findIndex(gclGatherData, { b_code: materialChecklistData[0].b_code, name: materialChecklistData[0].name, unit: materialChecklistData[0].unit, unit_price: materialChecklistData[0].unit_price }); loadMaterialData(index, 0); } else { loadMaterialData(-1, 0); } const sheet = materialSpread.getActiveSheet(); sheet.suspendPaint(); sheet.setCellType(1, 3, new TipCellType(), spreadNS.SheetArea.colHeader); sheet.resumePaint(); } // 调差清单工料table const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]); const materialSpreadSetting = { cols: [ {title: '清单工料含量|编号', colSpan: '5|1', rowSpan: '1|1', field: 'code', hAlign: 0, width: 80, formatter: '@', readOnly: true}, {title: '|名称', colSpan: '|1', rowSpan: '|1', field: 'name', hAlign: 0, width: 100, formatter: '@', readOnly: true}, {title: '|单位', colSpan: '|1', rowSpan: '|1', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: true}, {title: '|数量 �', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number', readOnly: 'readOnly.isEdit'}, {title: '|计算式', colSpan: '1', rowSpan: '|1', field: 'expr', hAlign: 2, width: 120, formatter: '@', readOnly: 'readOnly.isEdit'}, ], emptyRows: 0, headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', }; const materialBase = { isEdit: function (data) { // 是否本期添加的工料 return data.order === stage_order; } }; const materialCol = { readOnly: { isEdit: function (data) { // return !(!readOnly && materialBase.isEdit(data)); return readOnly; }, }, }; SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol); // 获取项目节数据 let materialList = []; function loadMaterialData(iGclRow, iLXmjRow) { const gcl = gclGatherData[iGclRow]; // const leafXmjs = gcl && gcl.leafXmjs ? gcl.leafXmjs.filter(item => { // return item.qc_qty || item.contract_qty // }) : null; if (gcl && gcl.leafXmjs) { const gcl_ids = gcl.leafXmjs ? _.uniq(_.map(gcl.leafXmjs, 'gcl_id')) : []; // const xmj2 = gcl.leafXmjs[iLXmjRow]; materialList = []; const newMaterialList = _.uniqBy(_.filter(gclList, function (m) { return _.indexOf(gcl_ids, m.gcl_id) !== -1; }), 'mb_id'); for(const m of newMaterialList) { const bills = _.find(materialBillsData, { id: m.mb_id }); if(bills) { m.code = bills.code; m.name = bills.name; m.unit = bills.unit; } } console.log(newMaterialList); materialList = newMaterialList; // const leafXmjs = gcl.leafXmjs.filter(item => { // return item.qc_qty || item.contract_qty // }); // const xmj = leafXmjs[iLXmjRow]; // materialList = _.filter(materialListData, function (m) { // return xmj && m.gcl_id === xmj.gcl_id && m.xmj_id === xmj.id && ((xmj.mx_id !==undefined && m.mx_id === xmj.mx_id) || xmj.mx_id === undefined); // }); // 对清单调差工料table的单位数量进行改变 materialSpreadSetting.cols[materialSpreadSetting.cols.length - 2].title = '|' + '每' + gcl.unit + '数量 �'; SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting); SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialList); } else { materialSpreadSetting.cols[materialSpreadSetting.cols.length - 2].title = '数量 �'; SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting); SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []); } SpreadJsObj.resetTopAndSelect(materialSpread.getActiveSheet()); } // 对添加工料表格赋值 function changeMaterialTable() { $('#materialBills tr').removeClass('table-secondary'); $('#materialBills').find('input').removeAttr('disabled'); $('#materialBills').find('input').prop('checked', false); for (const ml of materialList) { const mbIndex = _.findIndex(materialBillsData, {id : ml.mb_id }); if (mbIndex !== -1) { $('#materialBills tr').eq(mbIndex).addClass('table-secondary'); $('#materialBills').find('input').eq(mbIndex).attr('disabled', true); $('#materialBills').find('input').eq(mbIndex).prop('checked', true); } } } // 选中清单并添加 $('#set_checklist_btn').click(function () { const select_checklist = $('#lists_data').find('input:checked:not(:disabled)'); const pushData = []; for (const sc of select_checklist) { const order = parseInt($(sc).val()); const checklistInfo = _.find(materialChecklistData, { b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price }); if (!checklistInfo) { pushData.push({ b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price, quantity: gclGatherData[order].quantity ? gclGatherData[order].quantity : null, total_price: gclGatherData[order].total_price ? gclGatherData[order].total_price : null, had_bills: 0, }) } } const notSelect_checklist = $('#lists_data').find('input:not(:checked):not(:disabled)'); const removeData = []; for (const nsc of notSelect_checklist) { const order = parseInt($(nsc).val()); // const order = parseInt($(nsc).attr('data-index')); const checklistInfo = _.find(materialChecklistData, { b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price }); if (checklistInfo) { removeData.push(checklistInfo.id); } } setChecklistData(pushData, removeData); $('#addtclist').modal('hide'); }); // 筛选无调差工料清单 $('#notBills_checkList').click(function () { const isCheck = $(this).is(':checked'); let newMaterialChecklistData = materialChecklistData; if (isCheck) { $('#bills0_checkList').prop('checked', false); newMaterialChecklistData = _.filter(materialChecklistData, { had_bills: 0 }); } SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialChecklistData); SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet()); if (newMaterialChecklistData.length > 0) { const index = _.findIndex(gclGatherData, { b_code: newMaterialChecklistData[0].b_code, name: newMaterialChecklistData[0].name, unit: newMaterialChecklistData[0].unit, unit_price: newMaterialChecklistData[0].unit_price }); loadMaterialData(index, 0); } else { loadMaterialData(-1, 0); } }); // 筛选调差工料清单为0 $('#bills0_checkList').click(function () { const isCheck = $(this).is(':checked'); let newMaterialChecklistData = materialChecklistData; if (isCheck) { newMaterialChecklistData = []; $('#notBills_checkList').prop('checked', false); const materialList0 = _.uniq(_.map(_.filter(gclList, { quantity: 0 }), 'gcl_id')); if (materialList0.length > 0) { const hadMaterialChecklistData = _.filter(materialChecklistData, { had_bills: 1 }); for (const h of hadMaterialChecklistData) { const gcl = _.find(gclGatherData, { b_code: h.b_code, name: h.name, unit: h.unit, unit_price: h.unit_price }); if (gcl && gcl.leafXmjs.length > 0 && _.indexOf(materialList0, gcl.leafXmjs[0].gcl_id) !== -1) { newMaterialChecklistData.push(h); } } } } SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialChecklistData); SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet()); if (newMaterialChecklistData.length > 0) { const index = _.findIndex(gclGatherData, { b_code: newMaterialChecklistData[0].b_code, name: newMaterialChecklistData[0].name, unit: newMaterialChecklistData[0].unit, unit_price: newMaterialChecklistData[0].unit_price }); loadMaterialData(index, 0); } else { loadMaterialData(-1, 0); } }); // 添加调差工料 $('#add_material_bill').click(function () { // 获取已选工料 $('#materialBills').find('input:disabled').prop('checked', false); const selectList = $('#materialBills').find('input:checked'); if (selectList.length === 0) { toastr.warning('请选择调差工料'); $('#materialBills').find('input:disabled').prop('checked', true); return false; } const mb_id = []; for (let s = 0; s < selectList.length; s++) { mb_id.push($('#materialBills').find('input:checked').eq(s).val()); } // 获取当前项目节或部位明细id const sheet = ledgerSpread.getActiveSheet(); const select = SpreadJsObj.getSelectObject(sheet); const gclIndex = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price }); const gcl = gclGatherData[gclIndex].leafXmjs; const ms_id = isStageSelf ? materialStageData[0].id : null; const index = materialChecklistData.indexOf(select); const datas = []; for (const xmj of gcl) { const notx = findNotJoinLeafXmj(xmj); const notx2 = findNotChangeLeafXmj(xmj); const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '', contract_qty: xmj.contract_qty, qc_qty: xmj.qc_qty, qc_minus_qty: xmj.qc_minus_qty, gather_qty: xmj.gather_qty, is_join: notx !== undefined ? 0 : notx2 !== undefined ? 2 : 1, }; if (ms_id) data.ms_id = ms_id; datas.push(data); } if (isStageSelf) { // 取所有的gclGatherData才行,然后获取下的值 const gclData = gclGatherData[gclIndex]; for (const [index, ms] of materialStageData.entries()) { if (ms.id !== ms_id) { const gclOther = _.find(gclGatherListData[index], { b_code: gclData.b_code, name: gclData.name, unit: gclData.unit, unit_price: gclData.unit_price }); if (gclOther) { const leafXmjs = gclOther.leafXmjs.filter(item => { return item.qc_qty || item.contract_qty || item.qc_minus_qty }); for (const xmj of leafXmjs) { const notx = findNotJoinLeafXmj(xmj); const notx2 = findNotChangeLeafXmj(xmj); const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id ? xmj.mx_id : '', contract_qty: xmj.contract_qty, qc_qty: xmj.qc_qty, qc_minus_qty: xmj.qc_minus_qty, gather_qty: xmj.gather_qty, is_join: notx !== undefined ? 0 : notx2 !== undefined ? 2 : 1, ms_id: ms.id, }; datas.push(data); } } } } } // 上传到数据库 console.log(datas, gcl); postData(window.location.pathname + '/save', {type: 'adds', checklist: { id: select.id, had_bills: 1 }, postData: {xmjs: datas, mbIds: mb_id}}, function (result) { // materialListData = result; gclList = result; materialChecklistData[index].had_bills = 1; loadMaterialData(gclIndex, 0); // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index); $('#addgl').modal('hide'); }); $('#materialBills').find('input:disabled').prop('checked', true); }); if (!readOnly) { // material-spread右键功能 const materialSpreadObj = { del: function () { const materialSheet = materialSpread.getActiveSheet(); const materialSelect = SpreadJsObj.getSelectObject(materialSheet); const sheet = ledgerSpread.getActiveSheet(); const select = SpreadJsObj.getSelectObject(sheet); const index = materialChecklistData.indexOf(select); const gclIndex = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price }); const gcl = gclGatherData[gclIndex].leafXmjs; const datas = []; const ms_id = isStageSelf ? materialStageData[0].id : null; for (const xmj of gcl) { const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '', }; if (ms_id) data.ms_id = ms_id; datas.push(data); } if (isStageSelf) { // 取所有的gclGatherData才行,然后获取下的值 const gclData = gclGatherData[gclIndex]; for (const [index, ms] of materialStageData.entries()) { if (ms.id !== ms_id) { const gclOther = _.find(gclGatherListData[index], { b_code: gclData.b_code, name: gclData.name, unit: gclData.unit, unit_price: gclData.unit_price }); if (gclOther) { const leafXmjs = gclOther.leafXmjs.filter(item => { return item.qc_qty || item.contract_qty || item.qc_minus_qty }); for (const xmj of leafXmjs) { const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id ? xmj.mx_id : '', }; if (_.indexOf(datas, data) === -1) { datas.push(data); } } } } } } const xmj = gcl[0]; const materialCount = _.size(_.filter(gclList, function (m) { return m.gcl_id === xmj.gcl_id; })); // const materialCount = _.size(_.filter(materialListData, function (m) { // return m.gcl_id === xmj.gcl_id && m.xmj_id === xmj.id && ((xmj.mx_id !==undefined && m.mx_id === xmj.mx_id) || xmj.mx_id === undefined); // })); let checklist = false; if (materialCount === 1) { checklist = { id: select.id, had_bills: 0, } } console.log(datas, materialSelect.mb_id, checklist); postData(window.location.pathname + '/save', {type: 'dels', checklist, postData: { xmjs: datas, mb_id: materialSelect.mb_id }, ms_id: isStageSelf ? materialStageData[0].id : null }, function (result) { // materialListData = result; gclList = result; if (checklist) materialChecklistData[index].had_bills = checklist.had_bills; loadMaterialData(gclIndex, 0); // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index); }); }, deletePress: function (sheet) { return; }, editStarting: function (e, info) { const col = info.sheet.zh_setting.cols[info.col]; const select = SpreadJsObj.getSelectObject(info.sheet); if (col.field === 'quantity') { if (select.expr && select.expr !== '') { info.sheet.getCell(info.row, info.col).text(select.expr); } } }, editEnded: function (e, info) { if (info.sheet.zh_setting) { const select = SpreadJsObj.getSelectObject(info.sheet); const col = info.sheet.zh_setting.cols[info.col]; const validText = info.editingText ? info.editingText.replace('\n', '') : null; let orgValue; if (col.field === 'quantity') { orgValue = validText && validText !== '' ? _.toNumber(validText) ? select.quantity : select.expr : (select.expr && select.expr !== '') ? select.expr : select.quantity; } else { orgValue = select[col.field]; } if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) { SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = materialSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastr.error(msg); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } const num = parseFloat(exprQuantity.quantity); if (num < 0 || !/^\d+(\.\d{1,6})?$/.test(num)) { toastr.warning('已保留6位小数'); exprQuantity.quantity = ZhCalc.round(num, 6); } // 更新至服务器 const ledgerSheet = ledgerSpread.getActiveSheet(); const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet); const gclIndex = _.findIndex(gclGatherData, { b_code: ledgerSelect.b_code, name: ledgerSelect.name, unit: ledgerSelect.unit, unit_price: ledgerSelect.unit_price }); const gcl = gclGatherData[gclIndex].leafXmjs; const datas = []; const ms_id = isStageSelf ? materialStageData[0].id : null; for (const xmj of gcl) { const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '', }; if (ms_id) data.ms_id = ms_id; datas.push(data); } if (isStageSelf) { // 取所有的gclGatherData才行,然后获取下的值 const gclData = gclGatherData[gclIndex]; for (const [index, ms] of materialStageData.entries()) { if (ms.id !== ms_id) { const gclOther = _.find(gclGatherListData[index], { b_code: gclData.b_code, name: gclData.name, unit: gclData.unit, unit_price: gclData.unit_price }); if (gclOther) { const leafXmjs = gclOther.leafXmjs.filter(item => { return item.qc_qty || item.contract_qty || item.qc_minus_qty }); for (const xmj of leafXmjs) { const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id ? xmj.mx_id : '', }; if (_.indexOf(datas, data) === -1) { datas.push(data); } } } } } } console.log(exprQuantity, datas, select.mb_id); postData(window.location.pathname + '/save', { type:'updates', updateData: { xmjs: datas, expr: exprQuantity.expr, quantity: exprQuantity.quantity, mb_id: select.mb_id }, ms_id: isStageSelf ? materialStageData[0].id : null }, function (result) { // materialListData = result; gclList = result; loadMaterialData(gclIndex, 0); materialSpread.getActiveSheet().setSelection(info.row + 1, info.col, 1, 1); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.row); }); } }, clipboardPasted(e, info) { const hint = { cellError: {type: 'error', msg: '粘贴内容超出了表格范围'}, numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'}, numberCan: {type: 'warning', msg: '已保留6位小数'}, }; const range = info.cellRange; const sortData = info.sheet.zh_data || []; if (range.row + range.rowCount > sortData.length) { toastMessageUniq(hint.cellError); SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet()); SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet()); return; } if (sortData.length > 0 && range.col + range.colCount > 5) { toastMessageUniq(hint.cellError); SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet()); SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet()); return; } const data = []; for (let iRow = 0; iRow < range.rowCount; iRow++) { let bPaste = true; const curRow = range.row + iRow; const materialData = { id: sortData[curRow].id, mb_id: sortData[curRow].mb_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; const validText = info.sheet.getText(curRow, curCol).replace('\n', ''); const orgValue = sortData[curRow][colSetting.field]; if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) { sameCol++; if (range.colCount === sameCol) { bPaste = false; } continue; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = materialSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastMessageUniq(getPasteHint(msg, hintRow)); bPaste = false; continue; } if (isNaN(exprQuantity.quantity)) { toastMessageUniq(getPasteHint(hint.numberExpr, hintRow)); bPaste = false; continue; } const num = parseFloat(exprQuantity.quantity); if (num < 0 || !/^\d+(\.\d{1,6})?$/.test(num)) { toastMessageUniq(getPasteHint(hint.numberCan, hintRow)); exprQuantity.quantity = ZhCalc.round(num, 6); } materialData.expr = exprQuantity.expr; materialData.quantity = exprQuantity.quantity; } if (bPaste) { data.push(materialData); } else { SpreadJsObj.reLoadRowData(info.sheet, curRow); } } if (data.length === 0) { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; } const ledgerSheet = ledgerSpread.getActiveSheet(); const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet); const gclIndex = _.findIndex(gclGatherData, { b_code: ledgerSelect.b_code, name: ledgerSelect.name, unit: ledgerSelect.unit, unit_price: ledgerSelect.unit_price }); const gcl = gclGatherData[gclIndex].leafXmjs; const datas = []; const ms_id = isStageSelf ? materialStageData[0].id : null; for (const xmj of gcl) { const data2 = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '', }; if (ms_id) data2.ms_id = ms_id; datas.push(data2); } if (isStageSelf) { // 取所有的gclGatherData才行,然后获取下的值 const gclData = gclGatherData[gclIndex]; for (const [index, ms] of materialStageData.entries()) { if (ms.id !== ms_id) { const gclOther = _.find(gclGatherListData[index], { b_code: gclData.b_code, name: gclData.name, unit: gclData.unit, unit_price: gclData.unit_price }); if (gclOther) { const leafXmjs = gclOther.leafXmjs.filter(item => { return item.qc_qty || item.contract_qty || item.qc_minus_qty }); for (const xmj of leafXmjs) { const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id ? xmj.mx_id : '', }; if (_.indexOf(datas, data) === -1) { datas.push(data); } } } } } } console.log(data, datas); // 更新至服务器 postData(window.location.pathname + '/save', { type:'pastes', updateData: { xmjs: datas, pasteData: data }, ms_id: isStageSelf ? materialStageData[0].id : null }, function (result) { // materialListData = result; gclList = result; loadMaterialData(gclIndex, 0); materialSpread.getActiveSheet().setSelection(info.cellRange.row, info.cellRange.col, info.cellRange.rowCount, info.cellRange.colCount); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.row); }); }, _checkExprValid(expr) { 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 (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') { 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, data) { if (text) { const num = _.toNumber(text); if (num) { data.quantity = num; data.expr = ''; } else { const expr = $.trim(text).replace('\t', '').replace('=', '').toLowerCase(); const [valid, msg] = this._checkExprValid(expr); if (!valid) return [valid, msg]; data.expr = expr; data.quantity = ZhCalc.calcExpr.calcExprStrRpn(expr.replace(new RegExp('%', 'gm'), '/100')); } } else { data.quantity = 0; data.expr = ''; } return [true, '']; }, }; materialSpread.bind(spreadNS.Events.EditStarting, materialSpreadObj.editStarting); materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded); materialSpread.bind(spreadNS.Events.ClipboardPasted, materialSpreadObj.clipboardPasted); SpreadJsObj.addDeleteBind(materialSpread, materialSpreadObj.deletePress); $.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) { // 获取已选清单 changeMaterialTable(); $('#addgl').modal('show'); }, disabled: function (key, opt) { const sheet = ledgerSpread.getActiveSheet(); const select = SpreadJsObj.getSelectObject(sheet); if (!select) { return true; } return readOnly; } }, 'delete': { name: '删除工料', icon: 'fa-remove', callback: function (key, opt) { materialSpreadObj.del(materialSpread.getActiveSheet()); }, disabled: function (key, opt) { const sheet = materialSpread.getActiveSheet(); const selection = sheet.getSelections(); const sel = selection ? selection[0] : sheet.getSelections()[0]; const select = SpreadJsObj.getSelectObject(sheet); if (!select) { return true; } if (!readOnly && sel.rowCount === 1 && select && materialBase.isEdit(select)) { return false; } else { return true; } } }, } }); } // 切换清单行,读取所属项目节数据 ledgerSpread.getActiveSheet().bind(spreadNS.Events.SelectionChanged, function (e, info) { if (info.oldSelections !== undefined) { const iOldRow = info.oldSelections[0].row, iNewRow = info.newSelections[0].row; if (iNewRow !== iOldRow) { const sheet = ledgerSpread.getActiveSheet(); const select = SpreadJsObj.getSelectObject(sheet); const index = _.findIndex(gclGatherData, { b_code: select.b_code, name: select.name, unit: select.unit, unit_price: select.unit_price }); loadMaterialData(index, 0); } } }); $('#open_addtclist').click(function () { $('#tclist_search').val(''); $('#tclist_search').siblings('a').hide(); makeChecklistData(gclGatherData, materialChecklistData); $('#addtclist').modal('show'); }); // 回车提交 $('#tclist_search').on('keypress', function () { if(window.event.keyCode === 13) { $(this).blur(); } }); $('#tclist_search').on('blur', function () { const value = _.trim($(this).val()); let showListData = gclGatherData; if (value !== '') { $(this).siblings('a').show(); showListData = _.filter(gclGatherData, function (c) { return (c.b_code && c.b_code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1); }) } else { $(this).siblings('a').hide(); } remakeChecklistData(gclGatherData, showListData); }); $('.remove-btn').on('click', function () { $(this).hide(); $(this).siblings('input').val(''); remakeChecklistData(gclGatherData); }); // 显示有调差工料清单 // $('#show_material_gcl').click(function () { // if ($(this).is(':checked')) { // const hadMaterialGclGatherData = []; // const hadGclIdList = []; // for (const ml of materialListData) { // if (hadGclIdList.indexOf(ml.gcl_id) === -1) { // hadGclIdList.push(ml.gcl_id); // } // } // for (const gcl of gclGatherData) { // for (const index in gcl.leafXmjs) { // const gcl_id = gcl.leafXmjs[index].gcl_id; // if (hadGclIdList.indexOf(gcl_id) !== -1) { // hadMaterialGclGatherData.push(gcl); // break; // } // } // } // gclGatherData = hadMaterialGclGatherData; // } else { // gclGatherModel.loadLedgerData(ledger, curLedgerData); // gclGatherModel.loadPosData(pos, curPosData); // gclGatherData = gclGatherModel.gatherGclData().filter(item => { // return item.qc_qty || item.contract_qty // }); // } // SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, gclGatherData); // loadLeafXmjData(0); // loadMaterialData(0, 0); // SpreadJsObj.resetTopAndSelect(ledgerSpread.getActiveSheet()); // SpreadJsObj.resetTopAndSelect(leafXmjSpread.getActiveSheet()); // SpreadJsObj.resetTopAndSelect(materialSpread.getActiveSheet()); // }); $.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(); ledgerSpread.refresh(); materialSpread.refresh(); } }); $.divResizer({ select: '#right-spr', callback: function () { ledgerSpread.refresh(); materialSpread.refresh(); const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed(); setLocalCache('material_checklist_' + materialID, width); } }); // 展开收起工料并浏览器记住本期展开收起 $('a', '.right-nav').bind('click', function () { const tab = $(this), tabPanel = $(tab.attr('content')); if (!tab.hasClass('active')) { $('a', '.side-menu').removeClass('active'); $('.tab-content .tab-select-show').removeClass('active'); tab.addClass('active'); tabPanel.addClass('active'); showSideTools(tab.hasClass('active')); if (tab.attr('content') === '#material-tab') { const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed(); setLocalCache('material_checklist_' + materialID, width); } } else { removeLocalCache('material_checklist_' + materialID); tab.removeClass('active'); tabPanel.removeClass('active'); showSideTools(tab.hasClass('active')); } ledgerSpread.refresh(); materialSpread.refresh(); }); // 根据浏览器记录展开收起 if (getLocalCache('material_checklist_' + materialID)) { const tab = $('.right-nav a[content="#material-tab"]'), tabPanel = $(tab.attr('content')); $('a', '.side-menu').removeClass('active'); $('.tab-content .tab-select-show').removeClass('active'); tab.addClass('active'); tabPanel.addClass('active'); $('#right-view').width(getLocalCache('material_checklist_' + materialID) + '%'); showSideTools(tab.hasClass('active')); ledgerSpread.refresh(); materialSpread.refresh(); } // 导入功能 // 上传图片 let importFile = null; $('#upload-list').click(function () { if (materialBillsData.length === 0) { toastr.error('请添加工料再导入。'); return } $("#import").modal('show'); // $(this).siblings('input').trigger('click'); }); $('#upload-list-file').change(function () { const file = this.files[0]; importFile = file; }); $('#import_btn').click(function() { if (!importFile) { toastr.error('请选择json或excel文件再确定'); return; } $('#import').modal('hide'); const ext = importFile.name.toLowerCase().split('.').splice(-1)[0]; const imgStr = /(xls|xlsx|json|XLS|XLSX|JSON)$/; if (!imgStr.test(ext)) { toastr.error('请导入正确格式的json或excel文件。'); return } const fileReader = new FileReader(); fileReader.onload = async function(ev) { try{ const data = ev.target.result; let tree = []; const ignoreUnitPrice = $('#ignore').is(':checked'); resetExport(); $('#okedit').modal('show'); setProgress($('#export-progress'), 30); 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 })); if (!(jsonData[0] && jsonData[0].b_code !== undefined && jsonData[0].b_code !== null && jsonData[0].gljcode !== undefined && jsonData[0].name !== undefined && jsonData[0].name !== undefined && jsonData[0].unit !== undefined && jsonData[0].unit_price !== undefined)) { throw 'excel必须按指定格式内容上传'; } tree = _.filter(jsonData, function (item) { return item.b_code !== null; }); let lastIndex = 0;// 防止导入相同的清单导致导入的含量数量增多 for (const [i,t] of tree.entries()) { const jIndex1 = _.findIndex(jsonData, { b_code: t.b_code, name: t.name, unit: t.unit, unit_price: t.unit_price }, lastIndex); lastIndex = jIndex1; if (i + 1 < tree.length) { const jIndex2 = _.findIndex(jsonData, { b_code: tree[i+1].b_code, name: tree[i+1].name, unit: tree[i+1].unit, unit_price: tree[i+1].unit_price }, lastIndex); t.children = jsonData.slice(jIndex1 + 1, jIndex2); lastIndex = jIndex2; } else { t.children = jsonData.slice(jIndex1 + 1); } } } else { const ascii = jschardet.detect(data.substring(0, 10000)); iconv.skipDecodeWarning = true tree = JSON.parse(iconv.decode(data, ascii.encoding));// 需要转码,否则前端处理中文会出现乱码 if (!(tree[0] && tree[0].b_code !== undefined && tree[0].b_code !== null && tree[0].gljcode !== undefined && tree[0].name !== undefined && tree[0].name !== undefined && tree[0].unit !== undefined && tree[0].unit_price !== undefined)) { throw 'json必须按指定格式内容上传'; } } stopProgress($('#export-progress')); $('#bill-detail').show(); setProgress($('#bill-progress'), 30); // 导入先生成materialCheckList,再生成materialBillsData,最后生成materialListData console.log(tree, gclGatherData, materialChecklistData, materialBillsData); const pushChecklist = []; const pushBillsData = []; const needPushTree = []; // 分析materialCheckList和tree,找出相同的清单并插入对应不存在的工料 for (const t of tree) { if(t.children.length === 0) continue; const findObject = { b_code: t.b_code ? t.b_code.toString() : t.b_code, name: t.name ? t.name.toString() : t.name, unit: t.unit ? t.unit.toString() : t.unit, }; if (!ignoreUnitPrice) findObject.unit_price = t.unit_price ? parseFloat(t.unit_price) : null; const order = _.findIndex(gclGatherData, findObject); const mlOrder = _.findIndex(materialChecklistData, findObject); const haveQuantity = _.find(t.children, function (item) { return item.quantity && item.quantity !== 0 }) ? 1 : 0; if (mlOrder === -1 && order !== -1 && haveQuantity && _.findIndex(pushChecklist, findObject) === -1) { pushChecklist.push({ b_code: gclGatherData[order].b_code, name: gclGatherData[order].name, unit: gclGatherData[order].unit, unit_price: gclGatherData[order].unit_price, quantity: gclGatherData[order].quantity ? gclGatherData[order].quantity : null, total_price: gclGatherData[order].total_price ? gclGatherData[order].total_price : null, had_bills: 0, }); } else if (mlOrder === -1 && order === -1) { continue; } else if (!haveQuantity) { continue; } needPushTree.push(t); // for (const c of t.children) { // const mbOrder = _.findIndex(materialBillsData, { code: c.gljcode, name: c.name, unit: c.unit }); // if (c.b_code !== null && mbOrder === -1 && _.findIndex(pushBillsData, { code: c.gljcode, name: c.name, unit: c.unit }) === -1) { // pushBillsData.push({ // code: c.gljcode, // name: c.name, // unit: c.unit, // spec: c.specs, // }) // } // } } if (needPushTree.length === 0) { throw '不存在需要导入的工料清单含量'; } // 先上传需要生成的清单及工料 if (pushChecklist.length > 0 || pushBillsData.length > 0) { postData(window.location.pathname + '/save', { type:'exportCB', addChecklist: pushChecklist, addBillsList: pushBillsData }, async function (result) { // materialListData = result; materialChecklistData = result.materialChecklistData; materialBillsData = result.materialBillsData; materialStageBillsData = result.materialStageBillsData; stopProgress($('#bill-progress')); await pushListData(needPushTree); }, function () { stop = true; clearInterval(interval); setTimeout(function () { $('#okedit').modal('hide'); }, 1000); }); } else { stopProgress($('#bill-progress')); await pushListData(needPushTree); } } catch (error) { console.log(error); toastr.error(error); stop = true; clearInterval(interval); setTimeout(function () { $('#okedit').modal('hide'); $('#import').modal('show'); }, 1000); return } // 分析jsondata,得出每个清单间工料数量,生成新的树结构数组 // let persons = []; // 存储获取到的数据 // // 表格的表格范围,可用于判断表头是否数量是否正确 // let fromTo = ''; // // 遍历每张表读取 // for (const sheet in workbook.Sheets) { // if (workbook.Sheets.hasOwnProperty(sheet)) { // fromTo = workbook.Sheets[sheet]['!ref']; // console.log(fromTo); // persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet])); // // break; // 如果只取第一张表,就取消注释这行 // } // } // console.log(persons); }; // 以二进制方式打开文件 fileReader.readAsBinaryString(importFile); $('#upload-list-file').val(''); importFile = null; }); function sleep(millisecond) { return new Promise(resolve => { setTimeout(() => { resolve() }, millisecond) }) } let value = 0; let interval; let stop = false; function setProgress(_this, time = 50) { interval = setInterval(function () { if (value < 100) { value = parseInt(value) + 1; _this.css("width", value + "%").text(value + "%"); } else if (value === 100) { value = parseInt(value) + 1; value = 30; } }, time); } function resetExport() { resetProgress($('#export-progress')); $('#bill-detail').hide(); resetProgress($('#bill-progress')); $('#list-detail').hide(); resetProgress($('#list-progress')); } function resetProgress(_this) { _this.removeClass('bg-success'); _this.css("width", "0%").text("0%").attr('aria-valuenow', '0'); } function stopProgress(_this) { if (interval) { _this.addClass('bg-success'); _this.css("width", "100%").text("100%"); value = 0; stop = true; clearInterval(interval); interval = 0; } } async function pushListData(tree = []) { if (tree.length > 0) { const ignoreUnitPrice = $('#ignore').is(':checked'); for (const [i,t] of tree.entries()) { $('#list-detail').find('b').text(t.b_code); resetProgress($('#list-progress')); if (!interval) { $('#list-detail').show(); setProgress($('#list-progress'), 30); } const mbList = []; for (const mb of t.children) { if (mb.quantity) { const mbInfo = _.find(materialBillsData, { code: mb.gljcode+'', name: mb.name+'', unit: mb.unit+'' }); if (mbInfo) { const num = parseFloat(mb.quantity); if (num < 0 || !/^\d+(\.\d{1,6})?$/.test(num)) { // toastr.warning('已保留6位小数'); mb.quantity = ZhCalc.round(num, 6); } mbList.push({ id: mbInfo.id, quantity: mb.quantity }); } } } if (mbList.length === 0 && i+1 === tree.length) { stopProgress($('#list-progress')); toastr.success('导入成功'); setTimeout(function () { $('#okedit').modal('hide') }, 2000); showSjsData(); return; } if (mbList.length === 0) { continue; } const findObject = { b_code: t.b_code ? t.b_code.toString() : t.b_code, name: t.name ? t.name.toString() : t.name, unit: t.unit ? t.unit.toString() : t.unit, }; if (!ignoreUnitPrice) findObject.unit_price = t.unit_price ? parseFloat(t.unit_price) : null; const gclIndex = _.findIndex(gclGatherData, findObject); const gcl = gclGatherData[gclIndex].leafXmjs; const ms_id = isStageSelf ? materialStageData[0].id : null; // const index = materialChecklistData.indexOf(select); const datas = []; for (const xmj of gcl) { const notx = findNotJoinLeafXmj(xmj); const notx2 = findNotChangeLeafXmj(xmj); const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '', contract_qty: xmj.contract_qty, qc_qty: xmj.qc_qty, qc_minus_qty: xmj.qc_minus_qty, gather_qty: xmj.gather_qty, is_join: notx !== undefined ? 0 : notx2 !== undefined ? 2 : 1, }; if (ms_id) data.ms_id = ms_id; datas.push(data); } if (isStageSelf) { // 取所有的gclGatherData才行,然后获取下的值 const gclData = gclGatherData[gclIndex]; for (const [index, ms] of materialStageData.entries()) { if (ms.id !== ms_id) { const gclFindObject = { b_code: gclData.b_code ? gclData.b_code.toString() : gclData.b_code, name: gclData.name ? gclData.name.toString() : gclData.name, unit: gclData.unit ? gclData.unit.toString() : gclData.unit }; if (!ignoreUnitPrice) gclFindObject.unit_price = gclData.unit_price; const gclOther = _.find(gclGatherListData[index], gclFindObject); if (gclOther) { const leafXmjs = gclOther.leafXmjs.filter(item => { return item.qc_qty || item.contract_qty || item.qc_minus_qty }); for (const xmj of leafXmjs) { const notx = findNotJoinLeafXmj(xmj); const notx2 = findNotChangeLeafXmj(xmj); const data = { xmj_id: xmj.id, gcl_id: xmj.gcl_id, mx_id: xmj.mx_id ? xmj.mx_id : '', contract_qty: xmj.contract_qty, qc_qty: xmj.qc_qty, qc_minus_qty: xmj.qc_minus_qty, gather_qty: xmj.gather_qty, is_join: notx !== undefined ? 0 : notx2 !== undefined ? 2 : 1, ms_id: ms.id, }; datas.push(data); } } } } } // 上传到数据库 const select = _.find(materialChecklistData, findObject); console.log(select, datas, mbList); if (select) { const result = await postDataAsync(window.location.pathname + '/save', {type: 'adds', checklist: { id: select.id, had_bills: 1 }, postData: {xmjs: datas, mbIds: mbList, export: true}}); // materialListData = result; select.had_bills = 1; gclList = result; stopProgress($('#list-progress')); if (i+1 === tree.length) { toastr.success('导入成功'); setTimeout(function () { $('#okedit').modal('hide') }, 2000); showSjsData(); } // }, function () { // stop = true; // clearInterval(interval); // setTimeout(function () { $('#okedit').modal('hide') }, 1000); // }); } else { stopProgress($('#list-progress')); } } } } function transExcel(results) { const mapInfo = { '清单编号': 'b_code', '工料编号': 'gljcode', '名称': 'name', '单位': 'unit', '规格': 'specs', '单价': 'unit_price', '单位耗量': 'quantity', }; 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 }) } $('#exportExcel').click(function () { const data = []; const setting = { cols: [ {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 80, formatter: '@'}, {title: '工料编号', colSpan: '1', rowSpan: '2', field: 'gljcode', hAlign: 0, width: 80, formatter: '@'}, {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 220, formatter: '@'}, {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, type: 'Number'}, {title: '规格', colSpan: '1', rowSpan: '2', field: 'specs', hAlign: 0, width: 100, formatter: '@'}, {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 90, formatter: '@'}, {title: '单位耗量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 90, formatter: '@'}, ], headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: 'bold 10px 微软雅黑', font: '10px 微软雅黑' }; if (!materialChecklistData || materialChecklistData.length === 0) return; for (const ml of materialChecklistData) { data.push({ b_code: ml.b_code, name: ml.name, unit: ml.unit, unit_price: ml.unit_price, }); const index = _.findIndex(gclGatherData, { b_code: ml.b_code, name: ml.name, unit: ml.unit, unit_price: ml.unit_price }); if (index === -1) continue; const gcl = gclGatherData[index]; if (gcl && gcl.leafXmjs) { const gcl_ids = gcl.leafXmjs ? _.uniq(_.map(gcl.leafXmjs, 'gcl_id')) : []; const newMaterialList = _.uniqBy(_.filter(gclList, function (m) { return _.indexOf(gcl_ids, m.gcl_id) !== -1; }), 'mb_id'); for(const m of newMaterialList) { const bills = _.find(materialBillsData, { id: m.mb_id }); if(bills) { m.code = bills.code; m.name = bills.name; m.unit = bills.unit; } } if (newMaterialList.length > 0) { for (const nm of newMaterialList) { data.push({ gljcode: nm.code, name: nm.name, unit: nm.unit, quantity: nm.quantity, }); } } } } SpreadExcelObj.exportSimpleXlsxSheet(setting, data, $('.sidebar-title').attr('data-original-title') + "-清单材料单位消耗量.xlsx"); }); });