'use strict'; /** * 变更令详细页js * * @author EllisRan. * @date 2018/11/22 * @version */ // 编号排序，多重判断 function sortByCode(a, b) { let code1 = a.code.split('-'); let code2 = b.code.split('-'); let code1length = code1.length; let code2length = code2.length; for (let i = 0; i < code1length; i ++) { if (i+1 <= code2length) { if (code1[i] != code2[i]) { if (/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) { return parseInt(code1[i]) - parseInt(code2[i]); } else if (!/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) { return 1; } else if (/^\d+$/.test(code1[i]) && !/^\d+$/.test(code2[i])) { return -1; } else { const str1length = code1[i].length; const str2length = code2[i].length; for (let j = 0; j < str1length; j++) { if (j+1 <= str2length) { if (code1[i].charAt(j) != code2[i].charAt(j)) { return code1[i].charAt(j).charCodeAt() - code2[i].charAt(j).charCodeAt(); } else if (j+1 == str1length && code1[i].charAt(j) == code2[i].charAt(j)) { if (str1length == str2length) { return 0; } else { return str1length - str2length; } } } else { if (j+1 >= str1length) { return 1; } else { return -1; } } } } } else if (i+1 == code1length && code1[i] == code2[i]) { if (code1length == code2length) { return 0; } else { return code1length - code2length; } } } else { if (i+1 >= code1length) { return 1; } else { return -1; } } } } $.event.special.valuechange = { teardown: function (namespaces) { $(this).unbind('.valuechange'); }, handler: function (e) { $.event.special.valuechange.triggerChanged($(this)); }, add: function (obj) { $(this).on('keyup.valuechange cut.valuechange paste.valuechange input.valuechange', obj.selector, $.event.special.valuechange.handler) }, triggerChanged: function (element) { var current = element[0].contentEditable === 'true' ? element.html() : element.val() , previous = typeof element.data('previous') === 'undefined' ? element[0].defaultValue : element.data('previous'); if (current !== previous) { element.trigger('valuechange', [element.data('previous')]); element.data('previous', current); } } }; function getPasteHint (str, row = '') { let returnObj = str; if (row) { returnObj.msg = '清单第' + (row+1) + '行' + str.msg; } return returnObj; } let searchCodeList = []; $(document).ready(() => { const changeSpreadSetting = { cols: [ {title: '计价', colSpan: '1', rowSpan: '2', field: 'is_valuation', hAlign: 1, width: 50, cellType: 'checkbox', readOnly: 'readOnly.isEdit3'}, {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.isEdit2'}, {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 120, formatter: '@', readOnly: 'readOnly.isEdit2'}, {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isEdit2', cellType: 'unit', comboItems: changeUnits, comboEdit: true}, {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit2', getValue: 'getValue.unit_price'}, {title: '变更部位', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 120, formatter: '@', readOnly: 'readOnly.isEdit2'}, {title: '变更详情', colSpan: '1', rowSpan: '2', field: 'detail', hAlign: 0, width: 120, formatter: '@', readOnly: false}, {title: '计量上限（%）', colSpan: '1', rowSpan: '2', field: 'delimit', hAlign: 2, width: 60, type: 'Number', readOnly: false, visible: openChangeState}, {title: '原设计|数量', colSpan: '2|1', rowSpan: '1|1', field: 'oamount', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit', getValue: 'getValue.oamount'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'oa_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.oa_tp'}, {title: '申请变更增(+)减(-)|数量', colSpan: '2|1', rowSpan: '1|1', field: 'camount', hAlign: 2, width: 60, type: 'Number', readOnly: false, getValue: 'getValue.camount'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'ca_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.ca_tp'}, {title: '变更后|数量', colSpan: '2|1', rowSpan: '1|1', field: 'samount', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.changed_amount'}, {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'sa_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.changed_tp'}, {title: '操作', colSpan: '1', rowSpan: '2', field: 'del_list', hAlign: 1, width: 40, readOnly: true, cellType: 'mouseTouch', getValue: 'getValue.del_list'}, ], emptyRows: 0, headRows: 2, headRowHeight: [25, 25], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', readOnly: readOnly, rowHeader:[ { rowHeaderType: 'circle', setting: { size: 5, indent: 16, getColor: function (index, data) { if (!data) return; if (_.findIndex(changeLedgerList, { id: data.gcl_id }) !== -1 || _.findIndex(changePosList, { id: data.mx_id }) !== -1) { return '#dc3545'; } if(data.lid != 0) return; return '#007bff'; } }, }, ], localCache: { key: 'changes-spread', colWidth: true, } }; const changeCol = { getValue: { unit_price: function(data) { return ZhCalc.round(data.unit_price, unitPriceUnit); }, oa_tp: function (data) { return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.oamount, findDecimal(data.unit))), totalPriceUnit); }, ca_tp: function (data) { return ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.camount, findDecimal(data.unit))), totalPriceUnit); }, oamount: function (data) { return ZhCalc.round(data.oamount, findDecimal(data.unit)); }, camount: function (data) { return ZhCalc.round(data.camount, findDecimal(data.unit)); }, changed_amount: function (data) { return ZhCalc.round(ZhCalc.add(data.oamount, data.camount), findDecimal(data.unit)); }, changed_tp: function (data) { return ZhCalc.add(ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.oamount, findDecimal(data.unit))), totalPriceUnit), ZhCalc.round(ZhCalc.mul(ZhCalc.round(data.unit_price, unitPriceUnit), ZhCalc.round(data.camount, findDecimal(data.unit))), totalPriceUnit)); }, del_list: function (data) { return !_.find(changeUsedData, { cbid: data.id }) ? '移除' : ''; } }, readOnly: { isEdit: function (data) { return !readOnly && data.lid != 0; }, isEdit2: function (data) { return !readOnly && (data.lid != 0 || (data.lid == 0 && _.findIndex(changeUsedData, { cbid: data.id }) !== -1)); }, isEdit3: function (data) { return !readOnly && _.findIndex(changeUsedData, { cbid: data.id }) === -1; }, }, }; // 数字只判断几个值（unit_price, oamount, camount） const numField = ['unit_price', 'oamount']; const changeSpreadObj = { makeSjsFooter: function () { // 增加汇总行并设为锁定禁止编辑状态 changeSpreadSheet.addRows(changeSpreadSheet.getRowCount(), 1); changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 0, '合计'); const cellType1 = new GC.Spread.Sheets.CellTypes.Text(); changeSpreadSheet.getCell(changeSpreadSheet.getRowCount() - 1, 0).cellType(cellType1); changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1); changeSpreadObj.countSum(); }, countSum: function() { const rowCount = changeSpreadSheet.getRowCount(); let oSum = 0, cSum = 0, cdSum = 0; for(var i = 0; i < rowCount - 1; i++){ oSum = ZhCalc.add(oSum, changeSpreadSheet.getValue(i, startLimit)); cSum = ZhCalc.add(cSum, changeSpreadSheet.getValue(i, startLimit + 2)); cdSum = ZhCalc.add(cdSum, changeSpreadSheet.getValue(i, startLimit + 4)); } changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit, oSum !== 0 ? oSum : null); changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit + 2, cSum !== 0 ? cSum : null); changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, startLimit + 4, cdSum !== 0 ? cdSum : null); }, add: function () { let select = null; if (changeOrder) { select = SpreadJsObj.getSelectObject(changeSpreadSheet); } postData(window.location.pathname + '/save', {type: 'add', postData: select ? select.order : null}, function (result) { if (result) { if (changeOrder === 1 && select) { // 批量更新changeList的order值 _.forEach(changeList, function (item) { item.order = item.order > select.order ? item.order + 1 : item.order; }); changeList.splice(select.order, 0, result); changeSpreadSheet.addRows(select.order, 1); SpreadJsObj.reLoadRowData(changeSpreadSheet, select.order); changeSpreadSheet.setSelection(select.order, 0, 1, 1); // console.log(changeList); } else { changeList.push(result); changeSpreadSheet.addRows(changeList.length - 1, 1); SpreadJsObj.reLoadRowData(changeSpreadSheet, changeList.length - 1); changeSpreadSheet.setSelection(changeList.length - 1, 0, 1, 1); } changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1); changeSpreadObj.resetXmjSpread(); changeSpreadObj.refreshActn(); } }); }, batchAdd: function(num) { let select = null; if (changeOrder) { select = SpreadJsObj.getSelectObject(changeSpreadSheet); } postData(window.location.pathname + '/save', {type: 'batchadd', num, postData: select ? select.order : null}, function (result) { if (result) { changeList = result; SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol); SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting); SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); changeSpreadObj.makeSjsFooter(); changeSpreadObj.resetXmjSpread(); changeSpreadObj.refreshActn(); } }); }, del: function () { const selection = changeSpreadSheet.getSelections(); const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0]; const row = sel && sel.row !== undefined ? sel.row : -1; if (readOnly || row === -1 || sel.row + sel.rowCount > changeList.length) { return false; } const delList = []; let lastSelect = null; let hadTaiZhang = false; for (let r = 0; r < sel.rowCount; r++) { const select = changeList[row + r]; if(!select || _.find(changeUsedData, { cbid: select.id })) { return false; } if (r === sel.rowCount - 1 && changeOrder) { lastSelect = select; } if (select.lid != 0) { hadTaiZhang = true; } delList.push(select.id); } // console.log(lastSelect, delList); if (delList.length) { postData(window.location.pathname + '/save', {type: 'del', ids: delList, postData: lastSelect ? lastSelect.order : null}, function (result) { changeList.splice(row, delList.length); changeSpreadSheet.deleteRows(row, delList.length); const sel = changeSpreadSheet.getSelections(); changeSpreadSheet.setSelection(0, 0, 1, 1); changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); if (hadTaiZhang) { tableDataRemake(changeListData); } changeSpreadObj.countSum(); changeSpreadObj.refreshActn(); }); } // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // const index = changeList.indexOf(select); // if (index > -1 && !_.find(changeUsedData, { cbid: select.id })) { // postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) { // changeList.splice(index, 1); // changeSpreadSheet.deleteRows(index, 1); // const sel = changeSpreadSheet.getSelections(); // changeSpreadSheet.setSelection(0, 0, 1, 1); // changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); // if (select.lid != 0) { // tableDataRemake(changeListData); // } // changeSpreadObj.countSum(); // changeSpreadObj.refreshActn(); // }); // } }, upMove: function () { const data = { type: 'changeOrder', postData: [], }; const selection = changeSpreadSheet.getSelections(); const row = selection[0].row, count = selection[0].rowCount; const first = changeSpreadSheet.zh_data[row]; if (!first) { changeSpreadObj.refreshActn(); return false; } const pre = changeSpreadSheet.zh_data[row - 1], preUpdate = {id: pre.id}; for (let iRow = 0; iRow < count; iRow++) { const posData = changeSpreadSheet.zh_data[iRow + row]; if (posData) { data.postData.push({id: posData.id, order: changeSpreadSheet.zh_data[iRow + row - 1].order}); preUpdate.order = posData.order; } } data.postData.push(preUpdate); // console.log(data); if (data.postData.length > 0) { postData(window.location.pathname + '/save', data, function () { _.forEach(data.postData, function (item) { const cl = _.find(changeList, { id: item.id }); cl.order = item.order; }); changeList.sort(function (a, b) { return a.order - b.order }); SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); const sel = selection[0]; if (sel) { changeSpreadSheet.setSelection(changeSpreadSheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount); } changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); changeSpreadObj.refreshActn(); }); } }, downMove: function () { const data = { type: 'changeOrder', postData: [], }; const selection = changeSpreadSheet.getSelections(); const row = selection[0].row, count = selection[0].rowCount; const first = changeSpreadSheet.zh_data[row]; if (!first) { changeSpreadObj.refreshActn(); return false; } const next = changeSpreadSheet.zh_data[row + count], nextUpdate = {id: next.id}; for (let iRow = count - 1; iRow >= 0; iRow--) { const posData = changeSpreadSheet.zh_data[iRow + row]; if (posData) { data.postData.push({id: posData.id, order: changeSpreadSheet.zh_data[iRow + row + 1].order}); nextUpdate.order = posData.order; } } data.postData.push(nextUpdate); // console.log(data); if (data.postData.length > 0) { postData(window.location.pathname + '/save', data, function () { _.forEach(data.postData, function (item) { const cl = _.find(changeList, { id: item.id }); cl.order = item.order; }); changeList.sort(function (a, b) { return a.order - b.order }); SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); const sel = selection[0]; if (sel) { changeSpreadSheet.setSelection(changeSpreadSheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount); } changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); changeSpreadObj.refreshActn(); }); } }, resetXmjSpread: function(data = null) { const xmj = []; if (data && data.lid != 0 && data.xmj_code !== '' && data.xmj_code !== null) { const newData = JSON.parse(JSON.stringify(data)); if (newData.bwmx === newData.xmj_jldy) { newData.bwmx = ''; } xmj.push(newData); } SpreadJsObj.loadSheetData(xmjSpread.getActiveSheet(), SpreadJsObj.DataType.Data, xmj); }, editStarting: function (e, info) { const col = info.sheet.zh_setting.cols[info.col]; const select = SpreadJsObj.getSelectObject(info.sheet); if (col.field === 'camount') { if (select.camount_expr && select.camount_expr !== '') { info.sheet.getCell(info.row, info.col).text(select.camount_expr); } } }, selectionChanged: function (e, info) { const sel = info.sheet.getSelections()[0]; const col = info.sheet.zh_setting.cols[sel.col]; const data = SpreadJsObj.getSelectObject(info.sheet); if (col && col.field === 'del_list' && data && !_.find(changeUsedData, { cbid: data.id })) { changeSpreadObj.del(); } if (col && col.field === 'camount' && data) { $('#camount-expr').removeAttr('readonly').val(data.camount_expr ? data.camount_expr : data.camount); } else { $('#camount-expr').attr('readonly', true).val(''); } changeSpreadObj.resetXmjSpread(data); changeSpreadObj.refreshActn(); }, refreshActn: function (rowCount = 1) { const setObjEnable = function (obj, enable) { if (enable) { obj.removeClass('disabled'); } else { obj.addClass('disabled'); } }; // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // 还需判断是否已被调差清单调用 const selection = changeSpreadSheet.getSelections(); const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0]; const row = sel ? sel.row : -1; const first = changeList[row]; let last = first; if (sel.rowCount > 1 && first) { for (let r = 1; r < sel.rowCount; r++) { const rNode = changeList[sel.row + r]; if (!rNode) break; last = rNode; } } const preNode = changeList[row - 1]; setObjEnable($('#up-move'), !readOnly && first && preNode && changeList.indexOf(last) > 0 && sel.row + sel.rowCount <= changeList.length); setObjEnable($('#down-move'), !readOnly && first && changeList.indexOf(last) < changeList.length - 1 && sel.row + sel.rowCount <= changeList.length); // setObjEnable($('#open-list-modal'), !readOnly && select && changeList.indexOf(select) !== -1); // setObjEnable($('#add-white-btn'), !readOnly && select && changeList.indexOf(select) !== -1); }, deletePress: function (sheet) { return; }, editEnded: function (e, info) { if (info.sheet.zh_setting) { const select = SpreadJsObj.getSelectObject(info.sheet); const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'del_list' || col.field === 'is_valuation') { return; } let validText = is_numeric(info.editingText) && _.indexOf(numField, col.field) !== -1 ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : ''); let orgValue; if (col.field === 'camount') { orgValue = validText && validText !== '' ? (_.toNumber(validText) ? select.camount : select.camount_expr) : (select.camount_expr && select.camount_expr !== '' ? select.camount_expr : select.camount); } else { orgValue = select[col.field]; } if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) { SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } // // 未改变值则不提交 // let validText = is_numeric(info.editingText) && _.indexOf(numField, col.field) !== -1 ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : ''); // const orgValue = select[col.field]; // if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) { // SpreadJsObj.reLoadRowData(info.sheet, info.row); // return; // } // 判断部分值是否输入的是数字判断和数据计算 if(col.field === 'camount') { const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = changeSpreadObj._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; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: select.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } select.spamount = ZhCalc.round(validText, findDecimal(select.unit)) || 0; select.camount_expr = exprQuantity.expr; } if (col.type === 'Number') { if (isNaN(validText)) { toastr.error('不能输入其它非数字类型字符'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } if (col.field === 'unit_price') { validText = ZhCalc.round(validText, unitPriceUnit); } else { validText = ZhCalc.round(validText, findDecimal(select.unit)) || 0; } if (col.field === 'delimit') { const reg = /^(\d{1,2}|100)$/; if (!(_.isNumber(validText) && reg.test(validText))) { toastr.error('计量上限默认值只能输入0-100之间的整数'); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } // 需要判断是否已调用，已调用的则不能低于原有值大小 const usedInfo = _.find(changeUsedData, { cbid: select.id }); if (usedInfo && usedInfo.qty) { const minLimit = Math.ceil(ZhCalc.mul(ZhCalc.div(usedInfo.qty, select.camount), 100)); if (validText < minLimit) { toastr.error('计量上限值至少大于等于 ' + minLimit); SpreadJsObj.reLoadRowData(info.sheet, info.row); return; } } } } if (col.field === 'unit') { select.camount = ZhCalc.round(select.camount, findDecimal(validText)) || 0; select.oamount = ZhCalc.round(select.oamount, findDecimal(validText)) || 0; } select[col.field] = validText; // console.log(select); delete select.waitingLoading; // 更新至服务器 postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) { changeList.splice(info.row, 1, select); SpreadJsObj.reLoadRowData(info.sheet, info.row); changeSpreadObj.countSum(); }, function () { select[col.field] = orgValue; if(col.field === 'camount') { select.spamount = orgValue; } SpreadJsObj.reLoadRowData(info.sheet, info.row); }); } }, clipboardPasted(e, info) { const hint = { cellError: {type: 'error', msg: '粘贴内容超出了表格范围'}, numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'}, }; const range = info.cellRange; const sortData = info.sheet.zh_data || []; if (range.row + range.rowCount > sortData.length) { toastMessageUniq(hint.cellError); // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData); SpreadJsObj.reLoadSheetHeader(changeSpreadSheet); SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); return; } if (sortData.length > 0 && range.col + range.colCount > 14) { toastMessageUniq(hint.cellError); SpreadJsObj.reLoadSheetHeader(changeSpreadSheet); SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); return; } const data = []; // const rowData = []; let needCopyIgnore = !$('#customCheck1').is(':checked'); let needColAdd = false; for (let iRow = 0; iRow < range.rowCount; iRow++) { let bPaste = true; const curRow = range.row + iRow; // const materialData = JSON.parse(JSON.stringify(sortData[curRow])); const cLData = { id: sortData[curRow].id }; const hintRow = range.rowCount >= 1 ? curRow : ''; let sameCol = 0; for (let iCol = 0; iCol < range.colCount; iCol++) { const curCol = range.col + iCol; let colSetting = info.sheet.zh_setting.cols[curCol]; if ((needColAdd && curCol > 6) || (needCopyIgnore && curCol === 6)) { // 要判断是否已隐藏了变更详情，是则变更详情后面的curCol要+1 const newCurCol = curCol + 1; needColAdd = true; colSetting = info.sheet.zh_setting.cols[newCurCol]; } if (!colSetting) continue; let validText = info.sheet.getText(curRow, curCol); validText = is_numeric(validText) && _.indexOf(numField, colSetting.field) !== -1 ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : ''); let orgValue; if (colSetting.field === 'camount') { orgValue = validText && validText !== '' ? (_.toNumber(validText) ? sortData[curRow].camount : sortData[curRow].camount_expr) : (sortData[curRow].camount_expr && sortData[curRow].camount_expr !== '' ? sortData[curRow].camount_expr : sortData[curRow].camount); } else { orgValue = sortData[curRow][colSetting.field]; } if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) { sameCol++; if (range.colCount === sameCol) { bPaste = false; } continue; } if(colSetting.field === 'camount') { const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = changeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastMessageUniq(getPasteHint(msg, hintRow)); bPaste = false; continue; } if (isNaN(exprQuantity.quantity)) { toastMessageUniq(getPasteHint(hint.numberExpr, hintRow)); bPaste = false; continue; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: sortData[curRow].id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error(hintRow ? '清单第' + (hintRow+1) + '行变更数值必须大于等于已调用值 ' + usedInfo.qty : '清单变更数值必须大于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error(hintRow ? '清单第' + (hintRow+1) + '行变更数值必须小于等于已调用值 ' + usedInfo.qty : '清单变更数值必须小于等于已调用值 ' + usedInfo.qty); bPaste = false; continue; } cLData.camount_expr = exprQuantity.expr; sortData[curRow].camount_expr = exprQuantity.expr; } if (colSetting.type === 'Number') { if (isNaN(validText)) { toastMessageUniq(getPasteHint(hint.numberExpr, hintRow)); bPaste = false; continue; } if (colSetting.field === 'unit_price') { validText = ZhCalc.round(validText, unitPriceUnit); } else { validText = ZhCalc.round(validText, findDecimal(sortData[curRow].unit)) || 0; } if (colSetting.field === 'delimit') { const reg = /^(\d{1,2}|100)$/; if (!(_.isNumber(validText) && reg.test(validText))) { toastr.error('清单第' + (hintRow+1) + '行计量上限默认值只能粘贴0-100之间的整数'); bPaste = false; continue; } // 需要判断是否已调用，已调用的则不能低于原有值大小 const usedInfo = _.find(changeUsedData, { cbid: sortData[curRow].id }); if (usedInfo && usedInfo.qty) { const minLimit = Math.ceil(ZhCalc.mul(ZhCalc.div(usedInfo.qty, sortData[curRow].camount), 100)); if (validText < minLimit) { toastr.error('清单第' + (hintRow+1) + '行计量上限值至少大于等于 ' + minLimit); bPaste = false; continue; } } } } let unitdecimal = validText; if (colSetting.field === 'unit') { //粘贴内容要为下拉列表里所有的单位，不然为空 if (changeUnits.indexOf(validText) === -1) { unitdecimal = ''; } cLData.camount = ZhCalc.round(sortData[curRow].camount, findDecimal(unitdecimal)) || 0; cLData.oamount = ZhCalc.round(sortData[curRow].oamount, findDecimal(unitdecimal)) || 0; } if (colSetting.field !== 'oa_tp' && colSetting.field !== 'ca_tp') { cLData[colSetting.field] = validText; sortData[curRow][colSetting.field] = validText; } cLData.spamount = ZhCalc.round(sortData[curRow].camount, findDecimal(unitdecimal)) || 0; } if (bPaste) { data.push(cLData); // rowData.push(curRow); } else { SpreadJsObj.reLoadRowData(info.sheet, curRow); } } if (data.length === 0) { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; } // console.log(data); // 更新至服务器 postData(window.location.pathname + '/save', { type:'paste', updateData: data }, function (result) { changeList = result; SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); changeSpreadObj.makeSjsFooter(); changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); }, function () { SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount); return; }); }, buttonClicked: function (e, info) { if (info.sheet.zh_setting) { const select = SpreadJsObj.getSelectObject(info.sheet); const col = info.sheet.zh_setting.cols[info.col]; if (col.field === 'is_valuation') { if (info.sheet.isEditing()) { info.sheet.endEdit(true); } if (_.findIndex(changeUsedData, { cbid: select.id }) !== -1) { return; } select.is_valuation = info.sheet.getValue(info.row, info.col) ? 0 : 1; delete select.waitingLoading; // 更新至服务器 postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) { changeList.splice(info.row, 1, select); SpreadJsObj.reLoadRowData(info.sheet, info.row); }, function () { select.is_valuation = info.sheet.getValue(info.row, info.col) ? 1 : 0; SpreadJsObj.reLoadRowData(info.sheet, info.row); }); } } }, valueChanged(e, info) { // 防止ctrl+z撤销数据 SpreadJsObj.reLoadRowData(info.sheet, info.row); }, setAllValuation(is_valuation) { if (changeList.length === 0) { toastr.warning('暂无清单无法设置清单计价'); return; } const needChangeList = _.filter(changeList, { is_valuation: is_valuation ? 0 : 1 }); if (needChangeList.length === 0) { toastr.warning('全部清单已设置清单'+ (is_valuation ? '' : '不') +'计价'); return; } postData(window.location.pathname + '/save', { type:'set_all_valuation', is_valuation }, function (result) { changeList = result; SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); changeSpreadObj.makeSjsFooter(); changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); }); }, _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.replace('%', '/100')); // const ce = new CalcEvalMin(); // data.quantity = ce.eval(expr); // console.log(data.quantity); } } else { data.quantity = 0; data.expr = ''; } return [true, '']; }, }; const preUrl = window.location.pathname.split('/').slice(0, 4).join('/'); let changeListData; let gclGatherData; postData(preUrl + '/defaultBills', {}, function (result) { gclGatherModel.loadLedgerData(result.bills); gclGatherModel.loadPosData(result.pos); gclGatherData = gclGatherModel.gatherGclData(); gclGatherData = _.filter(gclGatherData, function (item) { return item.leafXmjs && item.leafXmjs.length !== 0; }); for (const ggd in gclGatherData) { if (gclGatherData[ggd].leafXmjs && gclGatherData[ggd].leafXmjs.length === 0) { gclGatherData.splice(ggd, 1); } gclGatherData[ggd].code = gclGatherData[ggd].b_code; let hadcid = 0; for (const xmj of gclGatherData[ggd].leafXmjs) { const changeLedger = _.find(changeLedgerList, { id: xmj.gcl_id }); const changePos = _.find(changePosList, { id: xmj.mx_id, lid: xmj.gcl_id }); if (changeLedger || changePos) { xmj.cid = 1; xmj.ccid = changeLedger ? changeLedger.ccid : changePos.ccid; hadcid = 1; } } if (hadcid !== 0) gclGatherData[ggd].cid = 1; } // 数组去重 const dealBillList = result.dealBills; for (const db of gclGatherData) { const exist_index = dealBillList.findIndex(function (item) { return item.code === db.code && item.name === db.name && item.unit === db.unit && item.unit_price === db.unit_price; }); if (exist_index !== -1) { dealBillList.splice(exist_index, 1); } } changeListData = gclGatherData.concat(dealBillList).sort(sortByCode); // console.log(changeListData); // 先加载台账数据 let listHtml = ''; let list_index = 1; let gcl_index = 0; for (const gcl of changeListData) { const unit = gcl.unit !== undefined && gcl.unit !== null ? gcl.unit : ''; const quantity = gcl.quantity !== 0 && gcl.quantity !== null && gcl.quantity !== undefined ? (unit !== '' ? ZhCalc.round(gcl.quantity, findDecimal(gcl.unit)) : gcl.quantity) : 0; const unit_price = gcl.unit_price !== null && gcl.unit_price !== undefined ? gcl.unit_price : 0; let gclhtml = gcl.leafXmjs !== undefined && gcl.leafXmjs !== null ? ' data-gcl="' + gcl_index + '"' : ''; gcl_index = gclhtml !== '' ? ++gcl_index : gcl_index; const lid = gcl.leafXmjs !== undefined && gcl.leafXmjs !== null ? (gcl.leafXmjs.length !== 0 ? gcl.leafXmjs[0].gcl_id : false) : gcl.id; if (lid) { listHtml += '' + '' + list_index + (gcl.cid ? '*' : '') + '' + '' + gcl.code + '' + '' + gcl.name + '' + '' + unit + '' + '' + (ZhCalc.round(unit_price, unitPriceUnit) ? ZhCalc.round(unit_price, unitPriceUnit) : 0) + '' + '' + quantity + '' + ''; list_index++; } } $('#table-list-select').html(listHtml); tableDataRemake(changeListData); SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol); SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting); SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); // changeSpreadSheet.options.protectionOptions = { // allowSort: true, // allowFilter: true // }; // var option = changeSpreadSheet.options.protectionOptions; // changeSpreadSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, changeSpreadSetting.cols.length))); // // changeSpreadSheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, 3))); // const filter = changeSpreadSheet.rowFilter(); // filter.filterButtonVisible(false); // filter.filterButtonVisible(0, true); // filter.filterButtonVisible(2, true); // filter.filterDialogVisibleInfo({ // sortByValue: true, //SortByValue item is visible. // sortByColor: false, //SortByColor item is visible. // filterByColor: false, //FilterByColor item is visible. // filterByValue: false, //FilterByValue item is visible. // listFilterArea: false //ListFilterArea item is visible. // }); // function compareList(obj1, obj2) { // console.log(obj1, obj2); // var list = ["", '204-1-b', '合计']; // var index1 = list.indexOf(obj1), index2 = list.indexOf(obj2); // if (index1 > index2) { // return 1; // } else if (index1 < index2) { // return -1; // } else { // return 0; // } // } // changeSpreadSheet.sortRange(0, 0, changeSpreadSetting.cols.length, 1, true, [{index: 0, ascending: true, compareFunction: compareList}]); // changeSpreadSheet.bind(GC.Spread.Sheets.Events.RangeSorting, function (e, info) { // info.compareFunction = compareList; // }); // filter.sortColumn(0, true); changeSpreadObj.makeSjsFooter(); changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); changeSpreadObj.refreshActn(); }); if (!readOnly) { $('#add-white-btn').click(changeSpreadObj.add); $('#up-move').click(changeSpreadObj.upMove); $('#down-move').click(changeSpreadObj.downMove); changeSpread.bind(spreadNS.Events.EditEnded, changeSpreadObj.editEnded); changeSpread.bind(spreadNS.Events.EditStarting, changeSpreadObj.editStarting); changeSpread.bind(spreadNS.Events.SelectionChanged, changeSpreadObj.selectionChanged); changeSpread.bind(spreadNS.Events.ClipboardPasted, changeSpreadObj.clipboardPasted); changeSpread.bind(spreadNS.Events.ValueChanged, changeSpreadObj.valueChanged); changeSpread.bind(spreadNS.Events.ButtonClicked, changeSpreadObj.buttonClicked); SpreadJsObj.addDeleteBind(changeSpread, changeSpreadObj.deletePress); changeSpreadSheet.getCell(-1, startLimit + 5).foreColor('#dc3545'); const delCommand = { canUndo: false, execute: function (context, options, isUndo) { const Commands = GC.Spread.Sheets.Commands; const sel = changeSpreadSheet.getSelections()[0]; const col = changeSpreadSheet.zh_setting.cols[sel.col]; if (col && col.field !== 'sa_tp') { isUndo = true; } if (isUndo) { Commands.undoTransaction(context, options); return true; } else { Commands.startTransaction(context, options); Commands.endTransaction(context, options); return true; } } }; const delCommand2 = { canUndo: false, execute: function (context, options, isUndo) { const Commands = GC.Spread.Sheets.Commands; const sel = changeSpreadSheet.getSelections()[0]; const col = changeSpreadSheet.zh_setting.cols[sel.col]; if (col && col.field !== 'del_list') { isUndo = true; } if (isUndo) { Commands.undoTransaction(context, options); return true; } else { Commands.startTransaction(context, options); Commands.endTransaction(context, options); return true; } } }; const commandManager = changeSpread.commandManager(); commandManager.register('banDel', delCommand); commandManager.register('banDel2', delCommand2); commandManager.register('banDel3', _.cloneDeep(delCommand2));// 不能共用banDel2 commandManager.setShortcutKey('banDel', 39, false, false, false, false);// 改写键盘右键，防止删除清单 commandManager.setShortcutKey('banDel2', 40, false, false, false, false);// 改写键盘下键，防止删除清单 commandManager.setShortcutKey('banDel3', 38, false, false, false, false);// 改写键盘上键，防止删除清单 let batchInsertObj; $.contextMenu.types.batchInsert = function (item, opt, root) { const self = this; if ($.isFunction(item.icon)) { item._icon = item.icon.call(this, this, $t, key, item); } else { if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') { // to enable font awesome item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon; } else { item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon; } } this.addClass(item._icon); const $obj = $('
' + item.name + '行
') .appendTo(this); const $input = $obj.find('input'); const event = () => { if (self.hasClass('context-menu-disabled')) return; item.batchInsert($input[0], root); }; $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }}); $input.click((e) => {e.stopPropagation();}) .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);}) .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');}); }; // 右键菜单 $.contextMenu({ selector: '#change-spread', build: function ($trigger, e) { const target = SpreadJsObj.safeRightClickSelection($trigger, e, changeSpread); return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader; }, items: { 'createList': { name: '添加台账清单', icon: 'fa-sign-in', visible: function () { return changeOrder === 0; }, callback: function (key, opt) { $('#addlist').modal('show'); }, }, 'createAdd': { name: '添加空白清单', icon: 'fa-sign-in', visible: function () { return changeOrder === 0 && openChangeWhiteList; }, callback: function (key, opt) { changeSpreadObj.add(changeSpreadSheet); }, }, 'batchInsert': { name: '批量添加空白清单', type: 'batchInsert', value: '2', icon: 'fa-sign-in', visible: function () { return changeOrder === 0 && openChangeWhiteList; }, batchInsert: function (obj, root) { if (_.toNumber(obj.value) > _.toNumber(obj.max)) { obj.value = obj.max; toastr.warning('批量添加不可多于' + obj.max); } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) { obj.value = obj.min; toastr.warning('批量添加不可少于' + obj.min); } else { // treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value)); changeSpreadObj.batchAdd(obj.value); root.$menu.trigger('contextmenu:hide'); } }, }, 'createList1': { name: '插入台账清单', icon: 'fa-sign-in', visible: function () { return changeOrder === 1; }, // disabled: function (key, opt) { // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // const sel = changeSpreadSheet.getSelections()[0]; // changeSpreadObj.resetXmjSpread(select); // // console.log(select, sel); // if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) { // return false; // } else { // return true; // } // }, callback: function (key, opt) { $('#addlist').modal('show'); }, }, 'createAdd1': { name: '插入空白清单', icon: 'fa-sign-in', visible: function () { return changeOrder === 1 && openChangeWhiteList; }, // disabled: function (key, opt) { // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // const sel = changeSpreadSheet.getSelections()[0]; // changeSpreadObj.resetXmjSpread(select); // // console.log(select, sel); // if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) { // return false; // } else { // return true; // } // }, callback: function (key, opt) { changeSpreadObj.add(changeSpreadSheet); }, }, 'batchInsert1': { name: '批量插入空白清单', type: 'batchInsert', value: '2', icon: 'fa-sign-in', visible: function () { return changeOrder === 1 && openChangeWhiteList; }, // disabled: function (key, opt) { // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // const sel = changeSpreadSheet.getSelections()[0]; // changeSpreadObj.resetXmjSpread(select); // // console.log(select, sel); // if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) { // return false; // } else { // return true; // } // }, batchInsert: function (obj, root) { if (_.toNumber(obj.value) > _.toNumber(obj.max)) { obj.value = obj.max; toastr.warning('批量插入不可多于' + obj.max); } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) { obj.value = obj.min; toastr.warning('批量插入不可少于' + obj.min); } else { // treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value)); changeSpreadObj.batchAdd(obj.value); root.$menu.trigger('contextmenu:hide'); } }, }, 'delete': { name: '删除', icon: 'fa-remove', callback: function (key, opt) { changeSpreadObj.del(changeSpreadSheet); }, disabled: function (key, opt) { // const select = SpreadJsObj.getSelectObject(changeSpreadSheet); // const sel = changeSpreadSheet.getSelections()[0]; // changeSpreadObj.resetXmjSpread(select); // // console.log(select, sel); // if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1 && !_.find(changeUsedData, { cbid: select.id })) { // return false; // } else { // return true; // } const selection = changeSpreadSheet.getSelections(); const sel = selection ? selection[0] : changeSpreadSheet.getSelections()[0]; const row = sel && sel.row !== undefined ? sel.row : -1; if (readOnly || row === -1 || sel.row + sel.rowCount > changeList.length) { return true; } let isUsed = false; for (let r = 0; r < sel.rowCount; r++) { const select = changeList[row + r]; if(!select || _.find(changeUsedData, { cbid: select.id })) { isUsed = true; } } return isUsed; } }, sprEdit: '----', 'allNotValuation': { name: '设置全部清单不计价', icon: 'fa-magic', callback: function (key, opt) { changeSpreadObj.setAllValuation(0); }, }, 'allValuation': { name: '设置全部清单计价', icon: 'fa-magic', callback: function (key, opt) { changeSpreadObj.setAllValuation(1); }, }, } }); // 表达式判断 $('#camount-expr').change(function () { if (this.readOnly) return; let validText = $(this).val(); const sel = changeSpreadSheet.getSelections()[0]; const row = sel ? sel.row : -1; const col = changeSpreadSheet.zh_setting.cols[sel.col]; if (row === -1 || !(col && col.field === 'camount')) return; const select = SpreadJsObj.getSelectObject(changeSpreadSheet); if (!select) return; validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : ''); let orgValue = validText && validText !== '' ? (_.toNumber(validText) ? select.camount : select.camount_expr) : (select.camount_expr && select.camount_expr !== '' ? select.camount_expr : select.camount); const orgExprValue = _.clone(select.camount_expr); if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === '' || validText === null))) { return; } const exprQuantity = { expr: '', quantity: 0, }; const [valid, msg] = changeSpreadObj._checkExpr(validText, exprQuantity); if (!valid) { toastr.error(msg); $(this).val(select.camount_expr ? select.camount_expr : select.camount); return; } if (isNaN(exprQuantity.quantity)) { toastr.error('不能输入其它非数字类型字符'); $(this).val(select.camount_expr ? select.camount_expr : select.camount); return; } validText = parseFloat(exprQuantity.quantity); // 判断是否 正数必须大于等于限制值，负数必须小于等于限制值，否则无法更改 const usedInfo = _.find(changeUsedData, { cbid: select.id }); if (usedInfo && usedInfo.qty >= 0 && validText < usedInfo.qty) { toastr.error('清单变更数值必须大于等于已调用值 ' + usedInfo.qty); $(this).val(select.camount_expr ? select.camount_expr : select.camount); return; } else if (usedInfo && usedInfo.qty < 0 && validText > usedInfo.qty) { toastr.error('清单变更数值必须小于等于已调用值 ' + usedInfo.qty); $(this).val(select.camount_expr ? select.camount_expr : select.camount); return; } select.spamount = ZhCalc.round(validText, findDecimal(select.unit)) || 0; select.camount_expr = exprQuantity.expr; select.camount = validText; // console.log(select); delete select.waitingLoading; // 更新至服务器 postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) { changeList.splice(row, 1, select); SpreadJsObj.reLoadRowData(changeSpreadSheet, row); changeSpreadObj.countSum(); }, function () { select.camount = orgValue; select.camount_expr = orgExprValue; select.spamount = orgValue; SpreadJsObj.reLoadRowData(changeSpreadSheet, row); }); }); } // 清单选中和移除 $('body').on('click', '#table-list-select tr', function () { searchCodeList = []; $('#table-list-select tr').removeClass('table-warning'); $(this).addClass('table-warning'); const isCheck = $(this).hasClass('table-success') ? true : false; const data_bwmx = $(this).attr('data-bwmx').split('$#$'); const data_charu = $(this).attr('data-charu') ? $(this).attr('data-charu').split('$#$') : []; const isDeal = $(this).data('gcl') !== undefined ? true : false; let codeHtml = '1 '; // console.log(isDeal, isCheck); if (isDeal) { const lid = $(this).data('lid'); let gcl = _.find(gclGatherData, function (item) { return item.leafXmjs && item.leafXmjs[0].gcl_id === lid; }); if (!gcl) { gcl = gclGatherData[$(this).data('gcl')]; } codeHtml = ''; for (const [index, leaf] of gcl.leafXmjs.entries()) { const quantity = leaf.quantity !== undefined && leaf.quantity !== null ? leaf.quantity : 0; const gcl_id = leaf.gcl_id ? leaf.gcl_id : ''; const mx_id = leaf.mx_id ? leaf.mx_id : ''; const bwmx = leaf.bwmx !== undefined ? leaf.bwmx : undefined; const pushMsg = leaf.code + '!_!' + (leaf.jldy ? leaf.jldy : '') + '!_!' + (leaf.dwgc ? leaf.dwgc : '') + '!_!' + (leaf.fbgc ? leaf.fbgc : '') + '!_!' + (leaf.fxgc ? leaf.fxgc : '') + '!_!' + (leaf.gcl_id ? leaf.gcl_id : '0') + '!_!' + (leaf.mx_id ? leaf.mx_id : '') + '!_!' + (bwmx !== undefined ? bwmx : leaf.jldy ? leaf.jldy : '') + '*;*' + quantity; const isChecked = data_bwmx.indexOf(pushMsg) !== -1 && isCheck ? 'checked ' : ''; const existGcl = _.find(changeList, {gcl_id: leaf.gcl_id, bwmx: (bwmx ? bwmx : leaf.jldy ? leaf.jldy : ''), oamount: leaf.quantity}); const isUsed = existGcl ? _.find(changeUsedData, { cbid: existGcl.id }) : null; const isOldChaRu = changeOrder && isChecked && data_charu.indexOf(pushMsg) === -1; const isDisabled = isUsed || isOldChaRu ? 'disabled ' : ''; codeHtml += '' + '' + (index+1) + (leaf.cid ? '*' : '') + '' + '' + leaf.code + '' + '' + (leaf.jldy ? leaf.jldy: '') + '' + '' + (leaf.dwgc ? leaf.dwgc : '') + '' + '' + (leaf.fbgc ? leaf.fbgc : '') + '' + '' + (leaf.fxgc ? leaf.fxgc : '') + '' + '' + (bwmx !== undefined ? bwmx : '') + '' + '' + (ZhCalc.round(quantity, findDecimal(gcl.unit)) ? ZhCalc.round(quantity, findDecimal(gcl.unit)) : 0) + '' + ''; searchCodeList.push(leaf.code + '|!|' + (leaf.jldy ? leaf.jldy: '') + '|!|' + (bwmx !== undefined ? bwmx : '')); } } else if (!isDeal && isCheck) { const pushMsg = '0*;*' + $(this).children('td').eq(5).text(); const isChecked = data_bwmx.indexOf(pushMsg) !== -1 && isCheck ? 'checked ' : ''; const isDisabeld = changeOrder && isChecked && data_charu.indexOf(pushMsg) === -1 ? 'disabled ' : ''; codeHtml = '1 '; } $('#code-list').attr('data-index', parseInt($(this).children('td').eq(0).text())); $('#code-input').val(''); $('#code-input').siblings('a').hide(); $('#code-list').html(codeHtml); checkSelectAll(); }); // 右边项目节选择 $('body').on('click', '#code-list input', function () { let index = $('#code-list').attr('data-index'); // 判断是否是自定义排序，是则另外保存一份到tr中，和data-bwmx不相通，最后提交再清除所有的data-charu清单 if ($(this).is(':checked')) { // 去除其它可能已选的checked // $('#code-list input').prop('checked', false); $(this).prop('checked', true); // 左边表单传值并添加class $('#table-list-select tr[data-index="' + index + '"]').addClass('table-success'); // 去除部分data-detail值 let data_bwmx = []; let data_charu = []; $('#code-list input:checked').each(function () { const tr = $(this).parents('tr'); const length = tr.children('td').length; const gcl_id = tr.attr('gcl_id'); const mx_id = tr.attr('mx_id'); const bwmx = length === 9 ? tr.children('td').eq(1).text() + '!_!' + tr.children('td').eq(2).text() + '!_!' + tr.children('td').eq(3).text() + '!_!' + tr.children('td').eq(4).text() + '!_!' + tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' + (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0'; const quantity = tr.attr('quantity'); const de_qu = bwmx + '*;*' + quantity; data_bwmx.push(de_qu); if (changeOrder && $(this).prop('disabled') !== true) { data_charu.push(de_qu); } }); data_bwmx = data_bwmx.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx); if (changeOrder) { data_charu = data_charu.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu); } } else { // 判断还有无选中项目节编号 if ($('#code-list input').is(':checked')) { // 去除部分data-detail值 let data_bwmx = []; let data_charu = []; $('#code-list input:checked').each(function () { const tr = $(this).parents('tr'); const length = tr.children('td').length; const gcl_id = tr.attr('gcl_id'); const mx_id = tr.attr('mx_id'); const bwmx = length === 9 ? tr.children('td').eq(1).text() + '!_!' + tr.children('td').eq(2).text() + '!_!' + tr.children('td').eq(3).text() + '!_!' + tr.children('td').eq(4).text() + '!_!' + tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' + (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0'; const quantity = tr.attr('quantity'); const de_qu = bwmx + '*;*' + quantity; data_bwmx.push(de_qu); if (changeOrder && $(this).prop('disabled') !== true) { data_charu.push(de_qu); } }); data_bwmx = data_bwmx.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx); if (changeOrder) { data_charu = data_charu.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu); } } else { $('#table-list-select tr[data-index="' + index + '"]').removeClass('table-success'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', ''); if (changeOrder) { $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', ''); } } } checkSelectAll(); }); // 添加空白清单or签约清单 $('.add-list-btn').on('click', function () { let select = null; if (changeOrder) { select = SpreadJsObj.getSelectObject(changeSpreadSheet); } const newLedgerList = remakeChangeSpread(); // console.log(newLedgerList, select); // 更新至服务器 postData(window.location.pathname + '/save', { type:'ledger_list', updateData: newLedgerList, postData: select ? select.order : null }, function (result) { changeList = result.changeList; changeUsedData = result.usedList; SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol); SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting); SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); // SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); const select = SpreadJsObj.getSelectObject(changeSpreadSheet); changeSpreadObj.resetXmjSpread(select); changeSpreadObj.refreshActn(); $('#table-list-select tr').attr('data-charu', ''); if(changeOrder) { $('#code-list input:checked').each(function () { $(this).attr('disabled', true); }) } $('#addlist').modal('hide'); }, function () { $('#table-list-select tr').attr('data-charu', ''); $('#addlist').modal('hide'); }); }); // 选中input所有值 $('body').on('focus', ".clist input", function() { $(this).select(); }); // 取消选中清单 $('#cancel-list-btn').click(function () { // $('#table-list-select tr').removeClass('table-success'); // $('#table-list-select tr').attr('data-bwmx', ''); // $('#code-list').html(''); tableDataRemake(changeListData); }); // 自动编号 $('.reduction-code').click(function () { const code = $(this).attr('data-code'); $('input[name="code"]').val(code); }); $('#select-list').change(function () { const select = parseInt($(this).val()); let showListData = changeListData; const value = $('#list-input').val(); if (select === 1) { if (value !== '') { $('#list-input').siblings('a').show(); showListData = _.filter(changeListData, function (c) { return ((c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1)) && c.cid; }); } else { $('#list-input').siblings('a').hide(); showListData = _.filter(changeListData, function (c) { return c.cid; }); } } else { if (value !== '') { $('#list-input').siblings('a').show(); showListData = _.filter(changeListData, function (c) { return (c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1); }); } else { $('#list-input').siblings('a').hide(); } } makeListTable(changeListData, showListData); $('#table-list-select tr').removeClass('table-warning'); $('#code-input').val(''); $('#code-input').siblings('a').hide(); $('#code-list').html(''); $('#code-select-all').prop('checked', false); }); // 回车提交 $('#list-input').on('keypress', function () { if(window.event.keyCode === 13) { $(this).blur(); } }); $('#list-input').on('blur', function () { const select = parseInt($('#select-list').val()); const value = _.trim($(this).val()); const valueList = _.slice(_.without(_.uniq(_.replace(_.replace(value, /\'|\"/g, ''), /\t/g, ' ').split(' ')), ''), 0, 10); // console.log(valueList); // 判断是否存在多个分词，以换行或空格分隔，多个则显示左侧菜单 if (value !== '' && valueList.length > 1) { if (_.without(_.uniq(value.split(' ')), '').length > 10) { toastr.warning('最多筛选以空格分割的前10个不重复关键词'); } $('#table-list').addClass('col-9').removeClass('col-12'); $('#table-list').siblings('.col-3').show(); $('#list-search-keyword').html('全部'); for (const v of valueList) { $('#list-search-keyword').append(`${v}`); } $('#list-input').val(valueList.join(' ')); } else { $('#table-list').addClass('col-12').removeClass('col-9'); $('#table-list').siblings('.col-3').hide(); $('#list-search-keyword').html('全部'); } let showListData = changeListData; if (select === 1 && value !== '') { $(this).siblings('a').show(); showListData = _.filter(changeListData, function (c) { let flag = false; if (c.cid) { for(const v of valueList) { if ((c.code && c.code.indexOf(v) !== -1) || (c.name && c.name.indexOf(v) !== -1)) { flag = true; break; } } } return flag; // return ((c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1)) && c.cid; }); } else if (select === 1 && value === '') { $(this).siblings('a').hide(); showListData = _.filter(changeListData, function (c) { return c.cid; }); } else if (value !== '') { $(this).siblings('a').show(); showListData = _.filter(changeListData, function (c) { let flag = false; for(const v of valueList) { if ((c.code && c.code.indexOf(v) !== -1) || (c.name && c.name.indexOf(v) !== -1)) { flag = true; break; } } return flag; // return (c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1); }); } else { $(this).siblings('a').hide(); } makeListTable(changeListData, showListData); $('#table-list-select tr').removeClass('table-warning'); $('#code-input').val(''); $('#code-input').siblings('a').hide(); $('#code-list').html(''); $('#code-select-all').prop('checked', false); }); // 双击编辑搜索值 $('body').on('dblclick', '#list-search-keyword tr', function () { if ($(this).attr('data-keyword') !== '') { $(this).children('td').html(``); $(this).find('input').focus(); $(this).find('input').val($(this).attr('data-keyword')); } }); // 光标离开 $('body').on('blur', '#list-search-keyword tr td input', function () { let val = $(this).val(); const oldVal = $(this).parents('tr').attr('data-keyword'); if (_.trim(val) === '') { toastr.warning('不能为空'); val = oldVal; } else if (_.trim(val) === oldVal) { val = oldVal; } else { const value = _.trim($('#list-input').val()); const valueList = _.slice(_.without(_.uniq(_.replace(value, /\t/g, ' ').split(' ')), ''), 0, 10); // console.log(_.indexOf(valueList, oldVal), valueList, val, oldVal); if (_.indexOf(valueList, val) !== -1) { toastr.warning('已存在相同的检索词'); val = oldVal; } valueList.splice(_.indexOf(valueList, oldVal), 1, val); $('#list-input').val(valueList.join(' ')); const select = parseInt($('#select-list').val()); const showListData = _.filter(changeListData, function (c) { return ((c.code && c.code.indexOf(val) !== -1) || (c.name && c.name.indexOf(val) !== -1)) && (select === 1 ? c.cid : 1); }); makeListTable(changeListData, showListData); $('#table-list-select tr').removeClass('table-warning'); $('#code-input').val(''); $('#code-input').siblings('a').hide(); $('#code-list').html(''); $('#code-select-all').prop('checked', false); } $(this).parents('tr').attr('data-keyword', val); $(this).parents('td').html(`${val}`); }); $('body').on('keypress', '#list-search-keyword tr td input', function () { if(window.event.keyCode === 13) { $(this).blur(); } }); $("#addlist").draggable({ handle: '.modal-header, .modal-footer'}); // 检索关键字切换 $('body').on('click', '#list-search-keyword tr', function () { if (!$(this).hasClass('bg-primary')) { const keyword = $(this).attr('data-keyword'); $(this).siblings().removeClass('text-white bg-primary'); $(this).siblings().children('td').removeClass('border-primary'); $(this).addClass('text-white bg-primary'); $(this).children('td').addClass('border-primary'); if (keyword === '') { $('#list-input').blur(); } else { const select = parseInt($('#select-list').val()); const showListData = _.filter(changeListData, function (c) { return ((c.code && c.code.indexOf(keyword) !== -1) || (c.name && c.name.indexOf(keyword) !== -1)) && (select === 1 ? c.cid : 1); }); makeListTable(changeListData, showListData); $('#table-list-select tr').removeClass('table-warning'); $('#code-input').val(''); $('#code-input').siblings('a').hide(); $('#code-list').html(''); $('#code-select-all').prop('checked', false); } } }); // 回车提交 $('#code-input').on('keypress', function () { if(window.event.keyCode === 13) { $(this).blur(); } }); $('#code-input').on('blur', function () { const value = $(this).val(); if (value !== '') { $(this).siblings('a').show(); } else { $(this).siblings('a').hide(); } makeCodeTable($(this).val()); checkSelectAll(); }); $('.remove-btn').on('click', function () { $(this).hide(); $(this).siblings('input').val(''); if ($(this).data('btn') === 'list') { const select = parseInt($('#select-list').val()); let showListData = changeListData; if (select === 1) { showListData = _.filter(changeListData, function (c) { return c.cid; }); } makeListTable(changeListData, showListData); $('#table-list-select tr').removeClass('table-warning'); $('#code-list').html(''); $('#table-list').addClass('col-12').removeClass('col-9'); $('#table-list').siblings('.col-3').hide(); $('#list-search-keyword').html(''); $('#list-search-keyword').siblings('a').addClass('active'); } else { makeCodeTable(); } checkSelectAll(); }); // 全选及取消 $('#code-select-all').click(function () { // 全选checkbox let index = $('#code-list').attr('data-index'); if (index) { if ($(this).is(':checked')){ $('#code-list tr').each(function () { if ($(this).css('display') !== 'none') { $(this).find('input').prop('checked', true); } }) } else { $('#code-list tr').each(function () { if ($(this).css('display') !== 'none' && $(this).find('input').prop('disabled') !== true) { $(this).find('input').prop('checked', false); } }); } // 判断还有无选中项目节编号 if ($('#code-list input').is(':checked')) { // 去除部分data-detail值 let data_bwmx = []; let data_charu = []; $('#code-list input:checked').each(function () { const tr = $(this).parents('tr'); const length = tr.children('td').length; const gcl_id = tr.attr('gcl_id'); const mx_id = tr.attr('mx_id'); const bwmx = length === 9 ? tr.children('td').eq(1).text() + '!_!' + tr.children('td').eq(2).text() + '!_!' + tr.children('td').eq(3).text() + '!_!' + tr.children('td').eq(4).text() + '!_!' + tr.children('td').eq(5).text() + '!_!' + gcl_id + '!_!' + mx_id + '!_!' + (tr.children('td').eq(6).text() !== '' ? tr.children('td').eq(6).text() : tr.children('td').eq(2).text()) : '0'; const quantity = tr.attr('quantity'); const de_qu = bwmx + '*;*' + quantity; data_bwmx.push(de_qu); if (changeOrder && $(this).prop('disabled') !== true) { data_charu.push(de_qu); } }); data_bwmx = data_bwmx.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx); if (changeOrder) { data_charu = data_charu.join('$#$'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', data_charu); } $('#table-list-select tr[data-index="' + index + '"]').addClass('table-success'); } else { $('#table-list-select tr[data-index="' + index + '"]').removeClass('table-success'); $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', ''); if (changeOrder) { $('#table-list-select tr[data-index="' + index + '"]').attr('data-charu', ''); } } } }); // 选中所有新增部位/清单 $('#select-all-revise').click(function() { const qtySpr = '*;*', infoSpr = '!_!', recSpr = '$#$'; const gclTr = $('#table-list-select tr'); for (const tr of gclTr) { const lid = $(tr).data('lid'); let gcl = _.find(gclGatherData, function (item) { return item.leafXmjs && item.leafXmjs[0].gcl_id === lid; }); if (!gcl) gcl = gclGatherData[$(this).data('gcl')]; if (!gcl || !gcl.cid) continue; let data_bwmx = []; if ($(tr).attr('data-bwmx') !== '') { data_bwmx = $(tr).attr('data-bwmx').split(recSpr); data_bwmx = data_bwmx.filter(x => { const rec = x.split(qtySpr); const info = rec[0].split(infoSpr); if (info.length < 8) return true; const leaf = gcl.leafXmjs.find(lx => { return lx.mx_id === info[6]}); return !leaf || !leaf.cid || leaf.ccid !== window.location.pathname.split('/')[4]; }); } let hasNew = false; for (const [index, leaf] of gcl.leafXmjs.entries()) { if (!leaf.cid || leaf.ccid !== window.location.pathname.split('/')[4]) continue; const bwmx = [leaf.code, leaf.jldy || '', leaf.dwgc || '', leaf.fbgc || '', leaf.fxgc || '', leaf.gcl_id, leaf.mx_id, leaf.bwmx || leaf.jldy || '']; const de_qu = bwmx.join(infoSpr) + qtySpr + (leaf.quantity || 0); if (data_bwmx.indexOf(de_qu) < 0) data_bwmx.push(de_qu); hasNew = true; } if (hasNew) $(tr).attr('data-bwmx', data_bwmx.join(recSpr)).addClass('table-success'); } // 触发点击当前清单，重载当前全部部位 const dataIndex = $('#code-list').attr('data-index'); if (dataIndex) { $(`tr[data-index=${dataIndex}]`).trigger('click'); } }); // 记录变更信息操作 $('body').on('valuechange', '#change_form input[type="text"]', function (e, previous) { changeInfo[$(this).attr('name')] = $(this).val(); judgeChange(); }); $('body').on('valuechange', '#change_form textarea', function (e, previous) { changeInfo[$(this).attr('name')] = $(this).val().replace(/[\r\n]/g, '

'); judgeChange(); }); $('body').on('change', '#change_form select', function (e, previous) { changeInfo[$(this).attr('name')] = $(this).val(); judgeChange(); }); $('body').on('click', '#change_form input[type="radio"]', function (e, previous) { changeInfo[$(this).attr('name')] = $(this).val(); judgeChange(); }); $('body').on('click', '#change_form input[type="checkbox"]', function (e, previous) { const typecheck = []; $.each($('#change_form input[name="type[]"]:checked'), function () { typecheck.push($(this).val()); }); changeInfo.type = typecheck.join(','); judgeChange(); }); // 保存修改ajax提交（不刷新页面） $('.save_change_btn').on('click', function () { // 保存修改modal if ($('input[name="code"]').val() === '') { toastr.error('申请编号不能为空！'); return; } if ($('input[name="name"]').val() === '') { toastr.error('变更工程名称不能为空！'); return; } // 换行更改并提交 changeInfo.content = changeInfo.content.replace(/

/g, '\r\n'); changeInfo.basis = changeInfo.basis.replace(/

/g, '\r\n'); changeInfo.expr = changeInfo.expr.replace(/

/g, '\r\n'); changeInfo.memo = changeInfo.memo.replace(/

/g, '\r\n'); // 后改为br // 更新至服务器 postData(window.location.pathname + '/save', { type:'info', updateData: changeInfo }, function (result) { $('.reduction-code').attr('data-code', $('input[name="code"]').val()); toastr.success(result ? result.msg : ''); $('#show-save-btn').hide(); $('#sp-btn').show(); $('.title-main').removeClass('bg-warning'); changeInfo.content = changeInfo.content.replace(/[\r\n]/g, '
'); changeInfo.basis = changeInfo.basis.replace(/[\r\n]/g, '
'); changeInfo.expr = changeInfo.expr.replace(/[\r\n]/g, '
'); changeInfo.memo = changeInfo.memo.replace(/[\r\n]/g, '
'); back_changeInfo = Object.assign({}, changeInfo); if (result.changeList) { deLimit = result.deLimit; changeList = result.changeList; SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol); SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting); SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); // SpreadJsObj.reLoadSheetData(changeSpreadSheet); changeSpreadObj.makeSjsFooter(); const select = SpreadJsObj.getSelectObject(changeSpreadSheet); changeSpreadObj.resetXmjSpread(select); changeSpreadObj.refreshActn(); } }); return false; }); $('#cancel_change').on('click', function () { $('#show-save-btn').hide(); $('#sp-btn').show(); $('.title-main').removeClass('bg-warning'); if (!isObjEqual(changeInfo, back_changeInfo)) { changeFormRemake(); } toastr.success('已还原到上次保存状态'); }); $('.dropdown-menu input[name="paixu"]').on('click', function () { const newChangeOrder = parseInt($(this).val()); if (newChangeOrder !== changeOrder) { const newLedgerList = changeOrder ? remakeChangeSpread(0) : []; // 更新至服务器 postData(window.location.pathname + '/save', { type:'order_by', updateData: newChangeOrder, newLedgerList }, function (result) { if (newChangeOrder === 0) { $('#bpaixu').text('清单排序：清单编号'); $('#upAndMoveBtn').attr('style', 'display: none !important'); $('.order_text').text('添加'); changeOrder = newChangeOrder; } else if (newChangeOrder === 1) { $('#bpaixu').text('清单排序：添加顺序'); $('#upAndMoveBtn').show(); $('.order_text').text('插入'); changeOrder = newChangeOrder; } changeList = result.changeList; changeUsedData = result.usedList; SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol); SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting); SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList); changeSpreadObj.makeSjsFooter(); changeSpreadObj.resetXmjSpread(SpreadJsObj.getSelectObject(changeSpreadSheet)); }); } }); }); function checkSelectAll() { let check = $('#code-list tr').length > 0 ? true : false; const codeNum = $('#code-list tr').length; let i = 0; $('#code-list tr').each(function () { if ($(this).css('display') !== 'none' && !$(this).find('input').is(':checked')) { check = false; return; } else if ($(this).css('display') === 'none') { i++; } }); if (check && i === codeNum) { check = false; } $('#code-select-all').prop('checked', check); } function checkChangeFrom() { let returnFlag = false; // 表单判断 if ($('input[name="code"]').val() === '') { toastr.error('申请编号不能为空！'); returnFlag = true; } if ($('input[name="name"]').val() === '') { toastr.error('变更工程名称不能为空！'); returnFlag = true; } if ($('textarea[name="content"]').val() === '') { toastr.error('工程变更理由及内容不能为空！'); returnFlag = true; } if (changeList.length === 0) { toastr.error('请添加变更清单！'); returnFlag = true; } else { for (const [i,cl] of changeList.entries()) { if (cl.name === '') { toastr.error('变更清单第' + (i+1) + '行未完整填写数据（名称不可为空）'); returnFlag = true; } } } if(!checkAuditorFrom ()) { returnFlag = true; } // 判断非空白变更清单是否有重复值（gcl_id及mx_id），如果存在完全相同则需要提示并删除，上报失败，这功能主要是因为清单数据过多服务器处理不过来偶然出现 const doubleList = findDuplicates(_.filter(changeList, item => item.lid != 0)); if (doubleList.length > 0) { for (const double of doubleList) { const msgIndex = []; for (const one of double) { const index = _.findIndex(changeList, { id: one.id }); if (index !== -1) msgIndex.push(index+1); } if (msgIndex.length > 0) { toastr.error('第 ' + msgIndex.splice(',') + ' 行变更清单 ' + double[0].code + ' 重复，请只保留一条数据'); } } returnFlag = true; } if (returnFlag) { return false; } } // 检查上报情况 function checkAuditorFrom () { if ($('#auditList li').length === 0) { if(shenpi_status === shenpiConst.sp_status.gdspl) { toastr.error('请联系管理员添加审批人'); } else { toastr.error('请先选择审批人，再上报数据'); } return false; } return true; } // 找出数组中相同的清单 function findDuplicates(arr, keys = ['gcl_id', 'mx_id']) { const groupedData = _.groupBy(arr, item => JSON.stringify(_.pick(item, keys))); const duplicates = _.filter(groupedData, group => group.length > 1); return _.values(duplicates); } function tableDataRemake(changeListData) { $('#table-list-select tr').removeClass('table-warning'); $('#table-list-select tr').removeClass('table-success'); $('#table-list-select tr').attr('data-bwmx', ''); $('#table-list-select tr').attr('data-charu', ''); $('#code-list').html(''); $('#code-list').attr('data-index', ''); $('#code-input').val(''); $('#code-select-all').prop('checked', false); $('#code-input').siblings('a').hide(); // 根据已添加的清单显示 if (changeList.length > 0 && changeList[0]) { const removeList = []; const updateList = []; const updateGclIdList = []; for (const [index,clinfo] of changeList.entries()) { if (clinfo.lid != 0) { let listinfo = changeListData.find(function (item) { return (item.id !== undefined && item.id == clinfo.lid) || (item.id === undefined && item.leafXmjs !== undefined && item.leafXmjs.length !== 0 && item.leafXmjs[0].gcl_id == clinfo.lid); }); let info = ''; if (listinfo === undefined || (clinfo.lid && clinfo.gcl_id && clinfo.lid !== clinfo.gcl_id)) { // 有可能这部分台账发生变化，此时要更新清单lid信息，防止数据丢失 const newlistinfo = changeListData.find(function (item) { return (item.id !== undefined && item.id == clinfo.gcl_id) || (item.id === undefined && item.leafXmjs !== undefined && item.leafXmjs.length !== 0 && _.find(item.leafXmjs, {gcl_id: clinfo.gcl_id })); }); if (listinfo === undefined && newlistinfo || (listinfo && newlistinfo && !isObjEqual(listinfo, newlistinfo))) { listinfo = newlistinfo; updateList.push({id: clinfo.id, lid: newlistinfo.leafXmjs[0].gcl_id}); // 更新lid changeList[index].lid = newlistinfo.leafXmjs[0].gcl_id; } } if (listinfo === undefined) { // 针对旧数据获取清单信息 listinfo = changeListData[clinfo.lid - 1]; if (listinfo === undefined) { toastr.warning('台账清单列表已不存在'+ clinfo.code +'，已更新变更清单列表'); if (changeStatus !== auditConst.status.revise) { removeList.push(clinfo); } else { updateList.push(makeWhiteList(clinfo)); } continue; } let pushbwmx = '0*;*0'; if (listinfo.leafXmjs !== undefined) { const leafInfo = listinfo.leafXmjs.find(function (item) { const flag = (item.bwmx === undefined || item.bwmx === clinfo.bwmx || item.jldy === clinfo.bwmx) && item.gcl_id === clinfo.gcl_id && (item.quantity !== null ? item.quantity === parseFloat(clinfo.oamount) : 0 === parseFloat(clinfo.oamount)); if (flag && item.code === clinfo.xmj_code) { return flag && item.code === clinfo.xmj_code; } return flag; }); if (leafInfo) { info = leafInfo; pushbwmx = leafInfo.code + '!_!' + (leafInfo.jldy !== undefined ? leafInfo.jldy : '') + '!_!' + (leafInfo.dwgc ? leafInfo.dwgc : '') + '!_!' + (leafInfo.fbgc ? leafInfo.fbgc : '') + '!_!' + (leafInfo.fxgc ? leafInfo.fxgc : '') + '!_!' + (leafInfo.gcl_id ? leafInfo.gcl_id : '') + '!_!' + (leafInfo.mx_id ? leafInfo.mx_id : '') + '!_!' + (leafInfo.bwmx !== undefined ? leafInfo.bwmx : (leafInfo.jldy !== undefined ? leafInfo.jldy : '')) + '*;*' + (leafInfo.quantity !== null ? leafInfo.quantity : 0); } else { toastr.warning('台账清单列表已不存在'+ clinfo.code +'，已更新变更清单列表'); if (changeStatus !== auditConst.status.revise) { removeList.push(clinfo); } else { updateList.push(makeWhiteList(clinfo)); } continue; } } else { pushbwmx = '0*;*' + (listinfo.quantity !== null ? listinfo.quantity : 0); } const bwmx = $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx'); if (bwmx) { const bwmxArray = bwmx.split('$#$'); bwmxArray.push(pushbwmx); $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$')); } else { $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx); } $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').addClass('table-success'); } else { let pushbwmx = '0*;*0'; if (listinfo.leafXmjs !== undefined) { const leafInfo = listinfo.leafXmjs.find(function (item) { const flag = (item.bwmx === undefined || item.bwmx === clinfo.bwmx || item.jldy === clinfo.bwmx) && item.gcl_id === clinfo.gcl_id && (item.quantity !== null ? item.quantity === parseFloat(clinfo.oamount) : 0 === parseFloat(clinfo.oamount)); if (flag && item.code === clinfo.xmj_code) { return flag && item.code === clinfo.xmj_code; } return flag; }); if (leafInfo) { info = leafInfo; pushbwmx = leafInfo.code + '!_!' + (leafInfo.jldy !== undefined ? leafInfo.jldy : '') + '!_!' + (leafInfo.dwgc ? leafInfo.dwgc : '') + '!_!' + (leafInfo.fbgc ? leafInfo.fbgc : '') + '!_!' + (leafInfo.fxgc ? leafInfo.fxgc : '') + '!_!' + (leafInfo.gcl_id ? leafInfo.gcl_id : '') + '!_!' + (leafInfo.mx_id ? leafInfo.mx_id : '') + '!_!' + (leafInfo.bwmx !== undefined ? leafInfo.bwmx : (leafInfo.jldy !== undefined ? leafInfo.jldy : '')) + '*;*' + (leafInfo.quantity !== null ? leafInfo.quantity : 0); } else { // console.log(clinfo, listinfo.leafXmjs); // changeList.splice(index, 1); toastr.warning('台账清单列表已不存在'+ clinfo.code +'，已更新变更清单列表'); if (changeStatus !== auditConst.status.revise) { removeList.push(clinfo); } else { updateList.push(makeWhiteList(clinfo)); } continue; } } else { pushbwmx = '0*;*' + (listinfo.quantity !== null ? listinfo.quantity : 0); } const bwmx = $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx'); if (bwmx) { const bwmxArray = bwmx.split('$#$'); bwmxArray.push(pushbwmx); $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$')); } else { $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx); } $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').addClass('table-success'); } if (info && _.findIndex(changeLedgerList, { id: clinfo.gcl_id }) !== -1) { // 可能因为升降级关系：细目，分部分项等会发生变化，更新清单 const updateInfo = {}; if (info.code !== clinfo.xmj_code) { updateInfo.xmj_code = info.code; changeList[index].xmj_code = info.code; } if (info.jldy !== clinfo.xmj_jldy) { updateInfo.xmj_jldy = info.jldy; changeList[index].xmj_jldy = info.jldy; } if (info.dwgc !== clinfo.xmj_dwgc) { updateInfo.xmj_dwgc = info.dwgc; changeList[index].xmj_dwgc = info.dwgc; } if (info.fbgc !== clinfo.xmj_fbgc) { updateInfo.xmj_fbgc = info.fbgc; changeList[index].xmj_fbgc = info.fbgc; } if (info.fxgc !== clinfo.xmj_fxgc) { updateInfo.xmj_fxgc = info.fxgc; changeList[index].xmj_fxgc = info.fxgc; } if (!_.isEmpty(updateInfo) && _.indexOf(updateGclIdList, clinfo.gcl_id) === -1) { updateGclIdList.push(clinfo.gcl_id); // updateInfo.gcl_id = info.id; updateList.push({ row: updateInfo, where: { tid: tenderId, gcl_id: clinfo.gcl_id } }); } } } } if(updateList.length > 0) { // console.log(updateList); postData(window.location.pathname + '/save', { type:'update_list', updateData: updateList }, function (result) { }, function () { }); } if(removeList.length > 0) { _.pullAll(changeList, removeList); postData(window.location.pathname + '/save', { type:'remove_list', updateData: removeList }, function (result) { }, function () { }); } } } function makeWhiteList(clinfo) { clinfo.lid = 0; clinfo.xmj_code = null; clinfo.xmj_jldy = null; clinfo.xmj_dwgc = null; clinfo.xmj_fbgc = null; clinfo.xmj_fxgc = null; clinfo.gcl_id = ''; clinfo.mx_id = null; return clinfo; } // 清单搜索隐藏清单table部分值 function makeListTable(changeListData, showListData = changeListData) { // 先加载台账数据 let listHtml = ''; let list_index = 1; let gcl_index = 0; for (const [index,gcl] of changeListData.entries()) { const isShow = _.find(showListData, gcl); $('#table-list-select tr').eq(index).css('display', (isShow ? 'table-row' : 'none')); } } // 项目节搜索隐藏code-table部分值 function makeCodeTable(search = '') { if (search === '') { $('#code-list tr').css('display', 'table-row'); return; } $('#code-list tr').css('display', 'none'); if (searchCodeList.length > 0) { for (const [index,list] of searchCodeList.entries()) { if (list.indexOf(search) !== -1) { $('#code-list tr').eq(index).css('display', 'table-row'); } } } else { for(let i = 0; i < $('#code-list tr').length; i++) { const length = $('#code-list tr').eq(i).children('td').length; if (length === 9) { const code = $('#code-list tr').eq(i).children('td').eq(1).text(); const name = $('#code-list tr').eq(i).children('td').eq(2).text(); const jldy = $('#code-list tr').eq(i).children('td').eq(6).text(); const isShow = code.indexOf(search) !== -1 || name.indexOf(search) !== -1 || jldy.indexOf(search) !== -1; if (isShow) { $('#code-list tr').eq(i).css('display', 'table-row'); } // $('#code-list tr').eq(i).css('display', (isShow ? 'table-row' : 'none')); } else { return; } } } } function remakeChangeSpread(cOrder = changeOrder) { const newTableList = []; // 获取选中的签约清单判断并插入到原有清单中 $('#table-list-select .table-success').each(function(){ let code = $(this).children('td').eq(1).text(); let name = $(this).children('td').eq(2).text(); let unit = $(this).children('td').eq(3).text(); let price = $(this).children('td').eq(4).text(); // let oamount = $(this).children('td').eq(5).text(); // 根据单位获取数量的位数，并得出 // let numdecimal = findDecimal(unit); // let scnum = makedecimalzero(numdecimal); let scnum = 0; // let detail = $(this).attr('data-detail') != 0 ? $(this).attr('data-detail').split('_')[1] : ''; let lid = $(this).data('lid'); let lindex = $(this).data('index'); // 原清单和数量改变 let data_bwmx = cOrder ? ($(this).attr('data-charu') ? $(this).attr('data-charu').split('$#$') : []) : $(this).attr('data-bwmx').split('$#$'); for (const b of data_bwmx) { const oamount = b.split('*;*')[1] != '' ? b.split('*;*')[1] : 0; let bwmx = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[7] : ''; let xmj_code = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[0] : ''; let xmj_jldy = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[1] : ''; let xmj_dwgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[2] : ''; let xmj_fbgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[3] : ''; let xmj_fxgc = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[4] : ''; let gcl_id = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[5] : ''; let mx_id = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[6] : ''; let trlist = { code, name, bwmx, unit, unit_price: price, oamount, camount: scnum, camount_expr: '', detail: '', lid, xmj_code, xmj_jldy, xmj_dwgc, xmj_fbgc, xmj_fxgc, gcl_id, mx_id, is_valuation: 1, delimit: deLimit, }; const radionInfo = changeList.find(function (info) { //return info.code === code && (info.lid == lid || parseInt(info.lid) === parseInt(lindex)) && gcl_id == info.gcl_id && (info.bwmx === bwmx || (info.bwmx === xmj_jldy && info.mx_id && info.mx_id === mx_id)) && parseInt(info.oamount) === parseInt(oamount); return (info.lid == lid || parseInt(info.lid) === parseInt(lindex)) && gcl_id == info.gcl_id && (info.bwmx === bwmx || (info.bwmx === xmj_jldy && info.mx_id && info.mx_id === mx_id)); }); if (radionInfo) { trlist.camount = radionInfo.camount; trlist.camount_expr = radionInfo.camount_expr; trlist.detail = radionInfo.detail; trlist.is_valuation = radionInfo.is_valuation; trlist.delimit = radionInfo.delimit; } newTableList.push(trlist); } }); // const changeWhiteList = _.filter(changeList, function (item) { // return item.lid == 0; // }); // console.log(newTableList); // changeList = newTableList.concat(changeWhiteList); return newTableList; } //判断元素是否在数组中，相当于php的in_array(); function in_array(arr, obj) { let i = arr.length; while (i--) { if (arr[i] == obj) { return true; } } return false; } function isObjEqual(o1,o2){ var props1 = Object.getOwnPropertyNames(o1); var props2 = Object.getOwnPropertyNames(o2); if (props1.length != props2.length) { return false; } for (var i = 0,max = props1.length; i < max; i++) { var propName = props1[i]; if (o1[propName] !== o2[propName]) { return false; } } return true; } // 判断是否有更改过 function judgeChange() { let change = false; if (!isObjEqual(changeInfo, back_changeInfo)) { change = true; } if (change) { $('#show-save-btn').show(); $('#sp-btn').hide(); $('.title-main').addClass('bg-warning'); } else { $('#show-save-btn').hide(); $('#sp-btn').show(); $('.title-main').removeClass('bg-warning'); } } function changeFormRemake() { changeInfo = Object.assign({}, back_changeInfo); $('#change_form input[name="code"]').val(changeInfo.code); $('#change_form input[name="name"]').val(changeInfo.name); $('#change_form input[name="peg"]').val(changeInfo.peg); $('#change_form input[name="org_name"]').val(changeInfo.org_name); $('#change_form input[name="org_code"]').val(changeInfo.org_code); $('#change_form input[name="new_name"]').val(changeInfo.new_name); $('#change_form input[name="new_code"]').val(changeInfo.new_code); $('#change_form textarea[name="content"]').val(changeInfo.content.replace(/

/g, '\r\n')); $('#change_form textarea[name="basis"]').val(changeInfo.basis.replace(/

/g, '\r\n')); $('#change_form textarea[name="expr"]').val(changeInfo.expr.replace(/

/g, '\r\n')); $('#change_form textarea[name="memo"]').val(changeInfo.memo.replace(/

/g, '\r\n')); $('#change_form select[name="type"]').val(changeInfo.type); $('#change_form select[name="class"]').val(changeInfo.class); $('#change_form select[name="quality"]').val(changeInfo.quality); $('#change_form select[name="company"]').val(changeInfo.company); $('#change_form input[name="charge"][value="'+ changeInfo.charge +'"]').prop('checked', true); $('#change_form input[name="state"][value="'+ changeInfo.state +'"]').prop('checked', true); $('#change_form input[name="type[]"]').prop('checked', false); const typecheck = changeInfo.type.split(','); for (const type of typecheck) { $('#change_form input[name="type[]"][value="'+ type +'"]').prop('checked', true); } }