123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972 |
- '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 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 += '<tr>\n' +
- ' <td><div class="text-center custom-control custom-checkbox mb-2">\n' +
- ' <input type="checkbox" id="lists_'+ i +'" value="'+ i +'" name="customCheckbox" class="custom-control-input"'+ isChecked + isDisabled +'>\n' +
- ' <label class="custom-control-label" for="lists_'+ i +'"></label>\n' +
- ' </div></td>\n' +
- ' <td class="text-center">'+ (i+1) +'</td>\n' +
- ' <td>'+ l.b_code +'</td>\n' +
- ' <td>'+ l.name +'</td>\n' +
- ' <td class="text-center">'+ (l.unit ? l.unit : '') +'</td>\n' +
- ' <td class="text-right">'+ (l.unit_price ? l.unit_price : '') +'</td>\n' +
- ' <td class="text-right">'+ (l.quantity ? l.quantity : '') +'</td>\n' +
- ' <td class="text-right">'+ (l.total_price ? l.total_price : '') +'</td>\n' +
- ' </tr>';
- }
- }
- $('#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', {}, function (result) {
- ledger = result.ledger;
- curLedgerData = result.curLedgerData;
- pos = result.pos;
- curPosData = result.curPosData;
- // materialListData = result.materialListData;
- notJoinList = result.materialNotJoinListData;
- materialChecklistData = result.materialChecklistData;
- gclList = result.gclList;
- // 解析清单汇总数据
- gclGatherModel.loadLedgerData(ledger, curLedgerData);
- gclGatherModel.loadPosData(pos, curPosData);
- 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 });
- console.log(gcl);
- // 判断是否已不存在工料清单,台账修改过后删除之
- 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 index = materialChecklistData.indexOf(select);
- 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);
- 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 = [];
- 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);
- }
- 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 }}, 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 = [];
- 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;
- 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 = [];
- 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;
- 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].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);
- }
- } 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();
- }
- });
|