1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249 |
- 'use strict';
- /**
- * 材料调差 - 调差清单
- *
- * @author EllisRan
- * @date 2019/10/25
- * @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 getMpSpreadByMBData(id) {
- const info = materialBillsData.find(function (item) {
- return item.id === parseInt(id);
- });
- return info ? info.m_spread : 0;
- }
- function getMaterialListByLeafXmj(gcl_id, xmj_id, mx_id = null) {
- const list = [];
- for (const ml of materialListData) {
- if (gcl_id === ml.gcl_id && xmj_id === ml.xmj_id && (mx_id === null || mx_id === ml.mx_id)) {
- list.push(ml);
- }
- }
- return list;
- }
- function calcOneBQJC(xmj) {
- let jiacha = 0;
- const notx = findNotJoinLeafXmj(xmj);
- if (notx === undefined) {
- const list = xmj.mx_id !== undefined ? getMaterialListByLeafXmj(xmj.gcl_id, xmj.id, xmj.mx_id) : getMaterialListByLeafXmj(xmj.gcl_id, xmj.id);
- for (const l of list) {
- jiacha = ZhCalc.add(jiacha, ZhCalc.mul(ZhCalc.mul(xmj.gather_qty, l.quantity), getMpSpreadByMBData(l.mb_id)));
- }
- }
- return ZhCalc.round(jiacha, materialDecimal.tp);
- }
- function getPasteHint (str, row = '') {
- let returnObj = str;
- if (row) {
- returnObj.msg = '清单第' + (row+1) + '行' + (str.msg ? str.msg : str);
- }
- return returnObj;
- }
- // 重新计算列表的价差
- function calculateJiaCha(data, index) {
- // 计算单条的
- if (index) {
- const gcld = data[index]
- let total_jiacha = 0;
- for (const [index, xmj] of gcld.leafXmjs.entries()) {
- const jiacha = calcOneBQJC(xmj);
- gcld.leafXmjs[index].jiacha = jiacha !== 0 ? jiacha : null;
- total_jiacha += jiacha;
- }
- gcld.total_jiacha = ZhCalc.round(total_jiacha, materialDecimal.tp)
- } else {
- for(const gcld of data) {
- let total_jiacha = 0;
- for (const [index, xmj] of gcld.leafXmjs.entries()) {
- const jiacha = calcOneBQJC(xmj);
- gcld.leafXmjs[index].jiacha = jiacha !== 0 ? jiacha : null;
- total_jiacha += jiacha;
- }
- gcld.total_jiacha = ZhCalc.round(total_jiacha, materialDecimal.tp)
- }
- }
- }
- const is_numeric = (value) => {
- if (typeof(value) === 'object') {
- return false;
- } else {
- return !Number.isNaN(Number(value)) && value.toString().trim() !== '';
- }
- };
- $(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) {
- // document.body.removeChild(this._toolTipElement);
- // $('#material-spread-div').removeChild(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: 90, formatter: '@'},
- {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 220, formatter: '@'},
- {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 80, formatter: '@'},
- {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 110, type: 'Number'},
- {title: '本期计量数量|合同', colSpan: '3|1', rowSpan: '1|1', field: 'contract_qty', hAlign: 2, width: 110, type: 'Number'},
- {title: '|数量变更', colSpan: '|1', rowSpan: '|1', field: 'qc_qty', hAlign: 2, width: 110, type: 'Number'},
- {title: '|小计', colSpan: '|1', rowSpan: '|1', field: 'gather_qty', hAlign: 2, width: 110, type: 'Number'},
- {title: '本期完成金额', colSpan: '1', rowSpan: '2', field: 'gather_tp', hAlign: 2, width: 110, type: 'Number'},
- {title: '本期价差', colSpan: '1', rowSpan: '2', field: 'total_jiacha', hAlign:3, width: 110, type: 'Number'}
- ],
- emptyRows: 0,
- headRows: 2,
- headRowHeight: [25, 25],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- readOnly: true,
- };
- // let gclGatherData = gclGatherModel.gatherGclData()
- // 获取项目节数据
- function loadLeafXmjData(iGclRow) {
- const gcl = gclGatherData[iGclRow];
- if (gcl) {
- for (const [index, xmj] of gcl.leafXmjs.entries()) {
- const jiacha = calcOneBQJC(xmj);
- gcl.leafXmjs[index].jiacha = jiacha !== 0 ? ZhCalc.round(jiacha, materialDecimal.tp) : null;
- }
- const leafXmjs = gcl.leafXmjs.filter(item => {
- return item.qc_qty || item.contract_qty
- });
- console.log(leafXmjs);
- SpreadJsObj.loadSheetData(leafXmjSpread.getActiveSheet(), SpreadJsObj.DataType.Data, leafXmjs);
- // 对清单调差工料table的单位数量进行改变
- materialSpreadSetting.cols[materialSpreadSetting.cols.length - 2].title = '|' + gcl.unit + '数量 �';
- // SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
- } else {
- SpreadJsObj.loadSheetData(leafXmjSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
- }
- SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
- }
- SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
- // 项目明细table
- const leafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-spread')[0]);
- const leafXmjSpreadSetting = {
- cols: [
- {title: '项目节|编号', colSpan: '2|1', rowSpan: '1|1', field: 'code', hAlign: 0, width: 80, formatter: '@'},
- {title: '|项目节名称', colSpan: '|1', rowSpan: '|1', field: 'jldy', hAlign: 0, width: 100, formatter: '@'},
- {title: '计量单元|计量单元', colSpan: '2|1', rowSpan: '1|1', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'},
- {title: '|复核数量', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 0, width: 80, type: 'Number'},
- {title: '部位信息|单位工程', colSpan: '3|1', rowSpan: '1|1', field: 'dwgc', hAlign: 0, width: 100, formatter: '@'},
- {title: '|分部工程', colSpan: '|1', rowSpan: '|1', field: 'fbgc', hAlign: 0, width: 100, formatter: '@'},
- {title: '|分项工程', colSpan: '|1', rowSpan: '|1', field: 'fxgc', hAlign: 0, width: 180, formatter: '@'},
- {title: '本期计量数量|合同', colSpan: '3|1', rowSpan: '1|1', field: 'contract_qty', hAlign: 2, width: 60, type: 'Number'},
- {title: '|数量变更', colSpan: '|1', rowSpan: '|1', field: 'qc_qty', hAlign: 2, width: 80, type: 'Number'},
- {title: '|小计', colSpan: '|1', rowSpan: '|1', field: 'gather_qty', hAlign: 2, width: 60, type: 'Number'},
- {title: '本期价差', colSpan: '1', rowSpan: '2', field: 'jiacha', hAlign: 2, width: 80, type: 'Number'},
- ],
- emptyRows: 0,
- headRows: 2,
- headRowHeight: [25, 25],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- readOnly: true,
- };
- // 加载清单数据 - 暂时统一加载,如有需要,切换成动态加载并缓存
- postData(window.location.pathname + '/load', {}, async function (result) {
- ledger = result.ledger;
- curLedgerData = result.curLedgerData;
- pos = result.pos;
- curPosData = result.curPosData;
- materialListData = result.materialListData;
- const gclList = result.gclList;
- notJoinList = result.materialNotJoinListData;
- materialChecklistData = result.materialChecklistData;
- // 解析清单汇总数据
- gclGatherModel.loadLedgerData(ledger, curLedgerData);
- gclGatherModel.loadPosData(pos, curPosData);
- gclGatherData = gclGatherModel.gatherGclData();
- console.log(gclGatherData);
- if (openMaterialChecklist) {
- const hadBillsidList = _.uniq(_.map(gclList, 'gcl_id'));
- console.log(hadBillsidList);
- // 判断是否有修订影响到本次数据,并有几率修改清单设置页的值
- 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 {
- // 更新had_bills值
- const updateObj = { id: mc.id };
- const gcl_ids = gcl.leafXmjs ? _.uniq(_.map(gcl.leafXmjs, 'gcl_id')) : [];
- const jiaoji = _.intersection(gcl_ids, hadBillsidList);
- 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);
- if (pushData.length > 0 || removeData.length > 0 || updateData.length > 0) {
- // materialChecklistData = await postDataAsync('/tender/'+ tenderID +'/measure/material/'+ stage_order +'/checklist/save', { type: 'resetChecklist', pushData, removeData, updateData })
- }
- gclGatherData = gclGatherData.filter(item => {
- return item.qc_qty || item.contract_qty
- });
- // 取交集
- gclGatherData = _.filter(gclGatherData, function (item) {
- return _.find(materialChecklistData, { b_code: item.b_code, name: item.name, unit: item.unit, unit_price: item.unit_price });
- });
- } else {
- gclGatherData = gclGatherData.filter(item => {
- return item.qc_qty || item.contract_qty
- });
- }
- calculateJiaCha(gclGatherData);
- SpreadJsObj.initSheet(leafXmjSpread.getActiveSheet(), leafXmjSpreadSetting);
- // 加载清单数据
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), SpreadJsObj.DataType.Data, gclGatherData);
- loadLeafXmjData(0);
- loadMaterialData(0, 0);
- const sheet = materialSpread.getActiveSheet();
- sheet.suspendPaint();
- sheet.setCellType(1, 3, new TipCellType(), spreadNS.SheetArea.colHeader);
- sheet.resumePaint();
- checkNotJoinMaterialData();
- });
- // const leafXmjCol = {
- // getValue: {
- // jiacha: function (data) {
- // let sum = 0;
- // const sheet = leafXmjSpread.getActiveSheet();
- // const select = SpreadJsObj.getSelectObject(sheet);
- // const notx = findNotJoinLeafXmj(select);
- // if (notx === undefined) {
- // for(const ml of materialList) {
- // sum = ZhCalc.round(ZhCalc.add(sum, ZhCalc.mul(ZhCalc.mul(data.gather_qty, ml.quantity), getMpSpreadByMBData(ml.mb_id))), 2);
- // }
- // }
- // return sum !== 0 ? sum : null;
- // }
- // }
- // };
- // SpreadJsObj.initSpreadSettingEvents(leafXmjSpreadSetting, leafXmjCol);
- // 调差清单工料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, type = 'normal') {
- // 是否本期添加的工料
- // return data.order === stage_order && !openMaterialChecklist;
- let flag = true;
- if (type === 'del') {
- flag = data.order === stage_order;
- }
- return flag && !openMaterialChecklist;
- }
- };
- const materialCol = {
- readOnly: {
- isEdit: function (data) {
- // const sheet = leafXmjSpread.getActiveSheet();
- // const select = SpreadJsObj.getSelectObject(sheet);
- // const notx = findNotJoinLeafXmj(select);
- // return !(!readOnly && notx === undefined && materialBase.isEdit(data));
- return !(!readOnly && materialBase.isEdit(data));
- },
- },
- };
- 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;
- console.log(gcl, leafXmjs);
- if (leafXmjs) {
- const xmj = leafXmjs[iLXmjRow];
- console.log(xmj, iLXmjRow);
- materialList = [];
- for (const m of materialListData) {
- if (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)) {
- materialList.push(m);
- }
- }
- console.log(xmj, materialList);
- SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialList);
- } else {
- SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
- }
- // SpreadJsObj.reLoadSheetData(leafXmjSpread.getActiveSheet());
- }
- // SpreadJsObj.locateTreeNode(ledgerSpread.getActiveSheet(), )
- // loadLeafXmjData(0);
- // loadMaterialData(0, 0);
- // const sheet = materialSpread.getActiveSheet();
- // sheet.suspendPaint();
- // sheet.setCellType(1, 3, new TipCellType(), spreadNS.SheetArea.colHeader);
- // sheet.resumePaint();
- // 不参与调差数据值变灰
- function checkNotJoinMaterialData() {
- const sheet = ledgerSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- const index = gclGatherData.indexOf(select);
- if (index !== -1) {
- const xmj = gclGatherData[index].leafXmjs.filter(item => {
- return item.qc_qty || item.contract_qty
- });
- const leafXmjSheet = leafXmjSpread.getActiveSheet();
- for (const [iRow,x] of xmj.entries()) {
- const notx = findNotJoinLeafXmj(x);
- const color = notx === undefined ? '' : '#d6d8db';
- leafXmjSheet.getRange(iRow, -1, 1, -1).backColor(color);
- }
- }
- }
- // checkNotJoinMaterialData();
- // 对添加工料表格赋值
- function changeMaterialTable() {
- $('#materialBills tr').removeClass('table-secondary');
- $('#materialBills').find('input').removeAttr('disabled');
- $('#materialBills').find('input').prop('checked', false);
- for (const [index, ml] of materialList.entries()) {
- const mbIndex = materialBillsData.findIndex(function (item) {
- return item.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);
- }
- }
- }
- // 添加调差工料
- $('#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 index = gclGatherData.indexOf(select);
- const leafXmjSheet = leafXmjSpread.getActiveSheet();
- const leafXmjSelect = SpreadJsObj.getSelectObject(leafXmjSheet);
- const gcl = gclGatherData[index].leafXmjs.filter(item => item.gather_qty !== null && item.gather_qty !== undefined);
- const leafXmjIndex = gcl.indexOf(leafXmjSelect);
- // const xmj = gcl[leafXmjIndex];
- // const data = {
- // xmj_id: xmj.id,
- // gcl_id: xmj.gcl_id,
- // mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
- // mb_id: mb_id,
- // gather_qty: xmj.gather_qty,
- // };
- const datas = [];
- for (const xmj of gcl) {
- const notx = findNotJoinLeafXmj(xmj);
- const data = {
- xmj_id: xmj.id,
- gcl_id: xmj.gcl_id,
- mx_id: xmj.mx_id !== undefined ? xmj.mx_id : '',
- gather_qty: xmj.gather_qty,
- is_join: notx === undefined ? 1 : 0,
- };
- datas.push(data);
- }
- // 上传到数据库
- console.log(datas, gcl, mb_id);
- postData(window.location.pathname + '/save', {type: 'adds', postData: {xmjs: datas, mbIds: mb_id}}, function (result) {
- materialListData = result;
- // toastr.success('已成功应用');
- calculateJiaCha(gclGatherData);
- // const index = gclGatherData.indexOf(ledgerSelect);
- loadLeafXmjData(index);
- // const xmjSheet = leafXmjSpread.getActiveSheet();
- // const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- // const xmjIndex = gclGatherData[index].leafXmjs.indexOf(xmjSelect);
- loadMaterialData(index, leafXmjIndex);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
- $('#addgl').modal('hide');
- });
- // postData(window.location.pathname + '/save', {type: 'add', postData: data}, function (result) {
- // // 添加到materialList里
- // materialListData = result;
- // loadMaterialData(index, leafXmjIndex);
- // $('#addgl').modal('hide');
- // });
- $('#materialBills').find('input:disabled').prop('checked', true);
- });
- if (!readOnly) {
- const leafXmjSpreadObj = {
- getSelect : function () {
- const sheet = ledgerSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- const index = gclGatherData.indexOf(select);
- const leafXmjSheet = leafXmjSpread.getActiveSheet();
- const leafXmjSelect = SpreadJsObj.getSelectObject(leafXmjSheet);
- const iRow = gclGatherData[index].leafXmjs.indexOf(leafXmjSelect);
- const leafXmjs = gclGatherData[index].leafXmjs.filter(item => {
- return item.qc_qty || item.contract_qty
- });
- const nRow = leafXmjs.indexOf(leafXmjSelect);
- return [index, iRow, nRow, leafXmjSheet, leafXmjSelect];
- },
- checkJoinMaterial: function (type) {
- const [iGclRow, iRow, nRow, sheet, select] = leafXmjSpreadObj.getSelect();
- const color = type === 'join' ? '' : '#d6d8db';
- const data = {
- type: type,
- select: type === 'join' ? findNotJoinLeafXmj(select) : select,
- };
- console.log(iGclRow, iRow, nRow, select);
- console.log(materialList);
- // 添加到
- postData(window.location.pathname + '/save', data, function (result) {
- if (type === 'join') {
- const index = findNotJoinLeafXmj(select, 'index');
- notJoinList.splice(index, 1);
- } else {
- notJoinList.push(result);
- }
- gclGatherData[iGclRow].leafXmjs[iRow].jiacha = calcOneBQJC(select);
- calculateJiaCha(gclGatherData, iGclRow);
- SpreadJsObj.reLoadRowData(sheet, nRow);
- sheet.getRange(nRow, -1, 1, -1).backColor(color);
- loadMaterialData(iGclRow, 0);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), iGclRow);
- });
- },
- }
- // leafXmj右键功能
- $.contextMenu({
- selector: '#leaf-xmj-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, leafXmjSpread);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- 'stop': {
- name: '不参与调差',
- icon: 'fa-remove',
- callback: function (key, opt) {
- leafXmjSpreadObj.checkJoinMaterial('notjoin');
- },
- visible: function (key, opt) {
- const sheet = leafXmjSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- const sel = sheet.getSelections()[0];
- const notx = findNotJoinLeafXmj(select);
- if (!select || sel.rowCount !== 1) {
- return false;
- }
- if (!readOnly && select && notx === undefined) {
- return true;
- } else {
- return false;
- }
- }
- },
- 'start': {
- name: '参与调差',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- leafXmjSpreadObj.checkJoinMaterial('join');
- },
- visible: function (key, opt) {
- const sheet = leafXmjSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- const sel = sheet.getSelections()[0];
- const notx = findNotJoinLeafXmj(select);
- if (!select || sel.rowCount !== 1) {
- return false;
- }
- if (!readOnly && select && notx === undefined) {
- return false;
- } else {
- return true;
- }
- },
- }
- }
- });
- // 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 = gclGatherData.indexOf(select);
- const leafXmjSheet = leafXmjSpread.getActiveSheet();
- const leafXmjSelect = SpreadJsObj.getSelectObject(leafXmjSheet);
- const gcl = gclGatherData[index].leafXmjs.filter(item => item.gather_qty !== null && item.gather_qty !== undefined);
- const leafXmjIndex = gcl.indexOf(leafXmjSelect);
- const datas = [];
- 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 : '',
- };
- datas.push(data);
- }
- console.log(datas, materialSelect.mb_id);
- postData(window.location.pathname + '/save', {type: 'dels', postData: { xmjs: datas, mb_id: materialSelect.mb_id }}, function (result) {
- materialListData = result;
- calculateJiaCha(gclGatherData);
- // const index = gclGatherData.indexOf(ledgerSelect);
- loadLeafXmjData(index);
- // const xmjSheet = leafXmjSpread.getActiveSheet();
- // const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- // const xmjIndex = gclGatherData[index].leafXmjs.indexOf(xmjSelect);
- loadMaterialData(index, leafXmjIndex);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
- });
- // postData(window.location.pathname + '/save', {type: 'del', id: select.id, mb_id: select.mb_id}, function (result) {
- // const index = materialList.indexOf(select);
- // materialList.splice(index, 1);
- // sheet.deleteRows(index, 1);
- // SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
- // const sel = sheet.getSelections();
- // sheet.setSelection(index > 0 ? index - 1 : 0, sel.length > 0 ? sel[0].col : 0, 1, 1);
- // const materialListIndex = materialListData.indexOf(select);
- // materialListData.splice(materialListIndex, 1);
- // const [iGclRow, iRow, lsheet, lselect] = leafXmjSpreadObj.getSelect();
- // gclGatherData[iGclRow].leafXmjs[iRow].jiacha = calcOneBQJC(lselect);
- // calculateJiaCha(gclGatherData, iGclRow);
- // SpreadJsObj.reLoadRowData(lsheet, iRow);
- // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), iGclRow);
- // });
- },
- 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 ? (typeof(info.editingText) === 'String' ? info.editingText.replace('\n', '') : info.editingText) : null;
- // const validText = is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
- // let orgValue = select[col.field];
- 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.error('数量值必须大于0并且小于6位小数的浮点数');
- // SpreadJsObj.reLoadRowData(info.sheet, info.row);
- // return;
- toastr.warning('已保留6位小数');
- exprQuantity.quantity = ZhCalc.round(num, 6);
- }
- // 更新至服务器
- const ledgerSheet = ledgerSpread.getActiveSheet();
- const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet);
- const index = gclGatherData.indexOf(ledgerSelect);
- const gcl = gclGatherData[index].leafXmjs.filter(item => item.gather_qty !== null && item.gather_qty !== undefined);
- const xmjSheet = leafXmjSpread.getActiveSheet();
- const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- const xmjIndex = gcl.indexOf(xmjSelect);
- const datas = [];
- 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 : '',
- };
- 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 } }, function (result) {
- materialListData = result;
- calculateJiaCha(gclGatherData);
- // const index = gclGatherData.indexOf(ledgerSelect);
- loadLeafXmjData(index);
- // const xmjSheet = leafXmjSpread.getActiveSheet();
- // const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- // const xmjIndex = gclGatherData[index].leafXmjs.indexOf(xmjSelect);
- loadMaterialData(index, xmjIndex);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
- materialSpread.getActiveSheet().setSelection(info.row + 1, info.col, 1, 1);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- // postData(window.location.pathname + '/save', { type:'update', updateData: { id:select.id, quantity: validText, mb_id: select.mb_id } }, function (result) {
- // const materialListIndex = materialListData.indexOf(select);
- // const index = materialList.indexOf(select);
- // select[col.field] = validText;
- // materialListData.splice(materialListIndex, 1, select);
- // materialList.indexOf(index, 1, select);
- // SpreadJsObj.reLoadRowData(info.sheet, info.row);
- // const [iGclRow, iRow, sheet, lselect] = leafXmjSpreadObj.getSelect();
- // gclGatherData[iGclRow].leafXmjs[iRow].jiacha = calcOneBQJC(lselect);
- // calculateJiaCha(gclGatherData, iGclRow)
- // SpreadJsObj.reLoadRowData(sheet, iRow);
- // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), iGclRow);
- // }, 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;
- // let validText = info.sheet.getText(curRow, curCol);
- // validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
- 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));
- // bPaste = false;
- // continue;
- exprQuantity.quantity = ZhCalc.round(num, 6);
- }
- // materialData[colSetting.field] = validText;
- materialData.expr = exprQuantity.expr;
- materialData.quantity = exprQuantity.quantity;
- }
- if (bPaste) {
- 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;
- }
- const ledgerSheet = ledgerSpread.getActiveSheet();
- const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet);
- const index = gclGatherData.indexOf(ledgerSelect);
- const gcl = gclGatherData[index].leafXmjs.filter(item => item.gather_qty !== null && item.gather_qty !== undefined);
- const xmjSheet = leafXmjSpread.getActiveSheet();
- const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- const xmjIndex = gcl.indexOf(xmjSelect);
- const datas = [];
- 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 : '',
- };
- datas.push(data2);
- }
- console.log(data, datas);
- // 更新至服务器
- postData(window.location.pathname + '/save', { type:'pastes', updateData: { xmjs: datas, pasteData: data } }, function (result) {
- materialListData = result;
- calculateJiaCha(gclGatherData);
- // const index = gclGatherData.indexOf(ledgerSelect);
- loadLeafXmjData(index);
- // const xmjSheet = leafXmjSpread.getActiveSheet();
- // const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- // const xmjIndex = gclGatherData[index].leafXmjs.indexOf(xmjSelect);
- loadMaterialData(index, xmjIndex);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
- materialSpread.getActiveSheet().setSelection(info.cellRange.row, info.cellRange.col, info.cellRange.rowCount, info.cellRange.colCount);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- // postData(window.location.pathname + '/save', { type:'paste', updateData: data }, function (result) {
- // materialListData = result;
- // const [iGclRow, iRow, sheet, lselect] = leafXmjSpreadObj.getSelect();
- // gclGatherData[iGclRow].leafXmjs[iRow].jiacha = calcOneBQJC(lselect);
- // calculateJiaCha(gclGatherData, iGclRow);
- // SpreadJsObj.reLoadRowData(sheet, iRow);
- // SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), iGclRow);
- // }, function () {
- // SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- // });
- },
- _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].value = '-' + param[1];
- }
- param.unshift();
- }
- 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);
- // const ce = new CalcEvalMin();
- // data.quantity = ce.eval(expr);
- // console.log(data.quantity);
- }
- } 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);
- if (!openMaterialChecklist) {
- $.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 = leafXmjSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- // const notx = findNotJoinLeafXmj(select);
- if (!select) {
- return true;
- }
- // if (!readOnly && notx === undefined) {
- // return false;
- // } else {
- // 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 select = SpreadJsObj.getSelectObject(sheet);
- if (!select) {
- return true;
- }
- if (!readOnly && select && materialBase.isEdit(select, 'del')) {
- return false;
- } else {
- return true;
- }
- }
- },
- }
- });
- }
- }
- // 应用调差工料至其他清单明细
- $('#user_all_material').click(function () {
- const ledgerSheet = ledgerSpread.getActiveSheet();
- const ledgerSelect = SpreadJsObj.getSelectObject(ledgerSheet);
- if (ledgerSelect.leafXmjs.length < 2) {
- toastr.warning('没有需要应用调差工料的其它清单明细');
- return false;
- }
- const xmjSheet = leafXmjSpread.getActiveSheet();
- const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- console.log(ledgerSelect.leafXmjs);
- // 判断需要应用调差工料的清单明细
- const needAddList = [];
- for (const xmj of ledgerSelect.leafXmjs) {
- const notx = findNotJoinLeafXmj(xmj);
- if (notx === undefined && xmjSelect !== xmj && xmj.gather_qty && xmj.jiacha === null && xmjSelect.jiacha !== null) {
- needAddList.push(xmj);
- }
- }
- // if (needAddList.length === 0) {
- // toastr.warning('没有需要应用调差工料的其它清单明细');
- // return false;
- // }
- console.log(needAddList, materialList);
- // 更新至服务器
- postData(window.location.pathname + '/save', { type:'useOther', postData: { addXmj: needAddList, materialBills: materialList } }, function (result) {
- materialListData = result;
- toastr.success('已成功应用');
- calculateJiaCha(gclGatherData);
- const index = gclGatherData.indexOf(ledgerSelect);
- loadLeafXmjData(index);
- const xmjSheet = leafXmjSpread.getActiveSheet();
- const xmjSelect = SpreadJsObj.getSelectObject(xmjSheet);
- const xmjIndex = gclGatherData[index].leafXmjs.indexOf(xmjSelect);
- loadMaterialData(index, xmjIndex);
- SpreadJsObj.reLoadRowData(ledgerSpread.getActiveSheet(), index);
- });
- });
- // 切换清单行,读取所属项目节数据
- 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) {
- loadLeafXmjData(iNewRow);
- SpreadJsObj.resetTopAndSelect(leafXmjSpread.getActiveSheet());
- loadMaterialData(iNewRow, 0);
- checkNotJoinMaterialData();
- }
- }
- });
- // 切换项目节数据清单明细行,读取已调用的清单工料数据
- leafXmjSpread.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 = gclGatherData.indexOf(select);
- loadMaterialData(index, iNewRow);
- SpreadJsObj.resetTopAndSelect(materialSpread.getActiveSheet());
- }
- }
- });
- // 显示有调差工料清单
- $('#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
- });
- if (openMaterialChecklist) {
- // 取交集
- gclGatherData = _.filter(gclGatherData, function (item) {
- return _.find(materialChecklistData, { b_code: item.b_code, name: item.name, unit: item.unit, unit_price: item.unit_price });
- });
- }
- }
- calculateJiaCha(gclGatherData);
- 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());
- checkNotJoinMaterialData();
- });
- $.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();
- leafXmjSpread.refresh();
- materialSpread.refresh();
- }
- });
- $.divResizer({
- select: '#right-spr',
- callback: function () {
- ledgerSpread.refresh();
- // leafXmjSpread.refresh();
- materialSpread.refresh();
- const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
- setLocalCache('material_list_' + materialID, width);
- }
- });
- $.divResizer({
- select: '#main-resize',
- callback: function () {
- materialSpread.refresh();
- ledgerSpread.refresh();
- let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
- $(".sp-wrap").height(bcontent-30);
- leafXmjSpread.refresh();
- const height = $('.bcontent-wrap').height();
- setLocalCache('material_list2_' + 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');
- $('.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_list_' + materialID, width);
- }
- } else {
- removeLocalCache('material_list_' + materialID);
- tab.removeClass('active');
- tabPanel.removeClass('active');
- showSideTools(tab.hasClass('active'));
- }
- ledgerSpread.refresh();
- // leafXmjSpread.refresh();
- materialSpread.refresh();
- });
- // 根据浏览器记录展开收起
- if (getLocalCache('material_list_' + 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_list_' + materialID) + '%');
- showSideTools(tab.hasClass('active'));
- ledgerSpread.refresh();
- // leafXmjSpread.refresh();
- materialSpread.refresh();
- }
- if (getLocalCache('material_list2_' + materialID)) {
- $('.bcontent-wrap').height(getLocalCache('material_list2_' + 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);
- materialSpread.refresh();
- ledgerSpread.refresh();
- leafXmjSpread.refresh();
- }
- function getObjHeight(select) {
- return select.length > 0 ? select.height() : 0;
- }
- });
|