'use strict'; /** * cs_errorList:错误列表 * 使用范围: * 台账分解(原报)、台账修订(原报)、计量台账(所有角色) * * posSearch & billsSearch:台账搜索相关 * 使用范围: * 0号台账:台账分解、台账审批、台账修订、部位台账; * 期计量:计量台账、部位台账 * * 所有工具均基于spreadjs,请放在gc.spread.sheets.all.10.0.1.min.js/spreadjs_zh.js之后 * * @author Mai * @date * @version */ const showSideTools = function (show) { const left = $('#left-view'), right = $('#right-view'), parent = left.parent(); if (show) { right.show(); autoFlashHeight(); /** * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px * 故需要通过最终的parent.width再计算一次left.width * * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width? * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width * */ //left.css('width', parent.width() - right.outerWidth()); //left.css('width', parent.width() - right.outerWidth()); const percent = 100 - right.outerWidth() /parent.width() * 100; left.css('width', percent + '%'); } else { left.width(parent.width()); right.hide(); } }; (function($){ /** * 错误列表 * @param setting * { * tabSelector: 'a[content=#error-list]', * selector: '#error-list', * relaSpread: ledgerSpread, * storeKey: 'ledger-error-' + tenderId, * } * @returns {{spread: *}} */ $.cs_errorList = function (setting) { if (!setting.spreadSetting) { setting.spreadSetting = { cols: [ {title: '行号', field: 'serialNo', width: 50, formatter: '@'}, { title: '错误类型', field: 'errorType', width: 60, formatter: '@', getValue: function (x) { switch (x.errorType) { case 'qty': return '数量'; case 'tp': return '金额'; default: return ''; } } }, {title: '清单编号', field: 'b_code', width: 135, formatter: '@'}, {title: '清单名称', field: 'name', width: 215, formatter: '@'}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', readOnly: true, }; } const clearErrorData = function () { if (setting.storeKey) removeLocalCache(setting.storeKey); }; const autoShowHistory = function (show) { if (setting.storeKey) { setLocalCache(setting.storeKey + '-showHis', show.toString()); } }; if (setting.selector && setting.relaSpread) { const resultId = setting.id + '-spread'; const obj = $(setting.selector); obj.html( '
\n' + '
' ); autoFlashHeight(); const spread = SpreadJsObj.createNewSpread($('#' + resultId)[0]); const sheet = spread.getActiveSheet(); SpreadJsObj.initSheet(sheet, setting.spreadSetting); SpreadJsObj.forbiddenSpreadContextMenu('#' + resultId, spread); spread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) { const sheet = info.sheet; const data = sheet.zh_data; if (!data) { return } const curBills = data[info.row]; if (!curBills) { return } SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), curBills.ledger_id, true); if (setting.afterLocated) { setting.afterLocated(); } }); const loadErrorData = function (data, his = false) { const sourceTree = setting.relaSpread.getActiveSheet().zh_tree; if (!sourceTree) return; for (const d of data) { d.serialNo = sourceTree.getNodeIndex(sourceTree.getItems(d.ledger_id)) + 1; } data.sort(function (a, b) { return a.serialNo - b.serialNo; }); SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, data); if (!his && setting.storeKey) { setLocalCache(setting.storeKey, JSON.stringify(data)); } $(setting.tabSelector).show(); }; const showErrorList = function () { const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content')); $('a', '#side-menu').removeClass('active'); tab.addClass('active'); $('.tab-content .tab-pane').removeClass('active'); tabPanel.addClass('active'); showSideTools(true); spread.refresh(); if (setting.afterShow) setting.afterShow(); }; const loadHisErrorData = function () { if (setting.storeKey) { const storeStr = getLocalCache(setting.storeKey); const storeData = storeStr ? JSON.parse(storeStr) : []; if (storeData.length > 0) { loadErrorData(storeData, true); const showHis = getLocalCache(setting.storeKey + '-showHis'); if (showHis === 'true') { showErrorList(); removeLocalCache(setting.storeKey + '-showHis'); } } } }; return { spread: spread, loadErrorData: loadErrorData, clearErrorData: clearErrorData, loadHisErrorData: loadHisErrorData, show: showErrorList, autoShowHistory: autoShowHistory, }; } else { const loadErrorData = function (data) { if (setting.storeKey) { setLocalCache(setting.storeKey, JSON.stringify(data)); } }; return { loadErrorData: loadErrorData, clearErrorData: clearErrorData, autoShowHistory: autoShowHistory, }; } }; $.ledger_checkList = function (setting) { const checkTypeText = []; for (const ct in setting.checkType) { checkTypeText[setting.checkType[ct].value] = setting.checkType[ct].text; } if (!setting.spreadSetting) { setting.spreadSetting = { cols: [ { title: '类型', field: 'type', width: 150, formatter: '@', getValue: function (data){ if (setting.checkType) { return checkTypeText[data.type] || ''; } else { return ''; } } }, {title: '行号', field: 'serialNo', hAlign: 1, width: 40, formatter: '@'}, {title: '项目节编号', field: 'code', width: 80, formatter: '@'}, {title: '清单编号', field: 'b_code', width: 80, formatter: '@'}, {title: '名称', field: 'name', width: 150, formatter: '@'}, ], emptyRows: 0, headRows: 1, headRowHeight: [32], defaultRowHeight: 21, headerFont: '12px 微软雅黑', font: '12px 微软雅黑', selectedBackColor: '#fffacd', readOnly: true, }; } const clearCheckData = function () { if (setting.storeKey) removeLocalCache(setting.storeKey); }; const autoShowHistory = function (show) { if (setting.storeKey) { setLocalCache(setting.storeKey + '-showHis', show.toString()); } }; if (setting.selector && setting.relaSpread) { const resultId = setting.id + '-spread'; const obj = $(setting.selector); const dropdown = []; if (setting.checkType) { dropdown.push(''); } obj.html( '
\n' + '
\n' + dropdown.join('') + ' 检查时间:2020-08-01 13:20:25\n' + '
\n' + '
' + '
\n' + '
' ); autoFlashHeight(); const spread = SpreadJsObj.createNewSpread($('#' + resultId)[0]); const sheet = spread.getActiveSheet(); SpreadJsObj.initSheet(sheet, setting.spreadSetting); SpreadJsObj.forbiddenSpreadContextMenu('#' + resultId, spread); spread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) { const sheet = info.sheet; const data = sheet.zh_data; if (!data) { return } const curBills = data[info.row]; if (!curBills) { return } SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), curBills.ledger_id, true); if (setting.afterLocated) { setting.afterLocated(); } }); const filterCheckData = function () { const filter = $(this).attr('check-type'); $('#' + setting.id + 'drop').html(this.innerHTML); for (const d of sheet.zh_data) { if (filter === 'all') { d.visible = true; } else { d.visible = d.type == filter; } } SpreadJsObj.refreshTreeRowVisible(sheet); }; $('a[check-type]').bind('click', filterCheckData); const hideCheckData = function () { const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content')); if (tab.hasClass('active')) { $('a', '#side-menu').removeClass('active'); tab.addClass('active'); $('.tab-content .tab-pane').removeClass('active'); tabPanel.addClass('active'); showSideTools(false); if (spread) spread.refresh(); if (setting.afterShow) setting.afterShow(); tab.hide(); } }; const loadCheckData = function (data, his = false) { const sourceTree = setting.relaSpread.getActiveSheet().zh_tree; if (!sourceTree) return; for (const d of data.warning_data) { d.serialNo = sourceTree.getNodeIndex(sourceTree.getItems(d.ledger_id)) + 1; } $('#' + setting.id + '-time').html('检查时间:' + moment(data.check_time).format('YYYY-MM-DD hh:mm:ss')); SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, data.warning_data); if (!his && setting.storeKey) { setLocalCache(setting.storeKey, JSON.stringify(data)); } $(setting.tabSelector).show(); }; const showCheckList = function () { const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content')); $('a', '#side-menu').removeClass('active'); tab.addClass('active'); $('.tab-content .tab-pane').removeClass('active'); tabPanel.addClass('active'); showSideTools(true); spread.refresh(); if (setting.afterShow) setting.afterShow(); }; const loadHisCheckData = function () { if (setting.storeKey) { const storeStr = getLocalCache(setting.storeKey); const storeData = storeStr ? JSON.parse(storeStr) : null; if (storeData) { loadCheckData(storeData, true); const showHis = getLocalCache(setting.storeKey + '-showHis'); if (showHis === 'true') { showCheckList(); removeLocalCache(setting.storeKey + '-showHis'); } } } }; return { spread: spread, loadCheckData: loadCheckData, clearCheckData: clearCheckData, loadHisCheckData: loadHisCheckData, show: showCheckList, hide: hideCheckData, autoShowHistory: autoShowHistory, }; } else { const loadCheckData = function (data) { if (setting.storeKey) { setLocalCache(setting.storeKey, JSON.stringify(data)); } }; return { loadCheckData: loadCheckData, clearCheckData: clearCheckData, autoShowHistory: autoShowHistory, }; } }; $.posSearch = function (setting) { if (!setting.selector || !setting.searchSpread) return; const searchHtml = '
\n' + '
\n' + ' \n' + '
\n' + ' 结果:0\n' + '
\n' + '
\n' + ' \n' + ' \n' + '
\n' + '
\n' + '
\n'; $(setting.selector).html(searchHtml); const sheet = setting.searchSpread.getActiveSheet(); const searchObj = (function () { let resultArr = []; const search = function (keyword) { if (keyword && keyword !== '') { resultArr = []; const sortData = sheet.zh_data; if (sortData) { for (let i = 0, iLength = sortData.length; i < iLength; i++) { const sd = sortData[i]; if (sd.name && sd.name.indexOf(keyword) > -1) { resultArr.push({index: i, data: sd}); } } } } else { resultArr = []; } $('#pos-search-hint').html('结果:' + resultArr.length); }; const searchAndLocate = function (keyword) { search(keyword); if (resultArr.length > 0) { const sel = sheet.getSelections()[0]; const curRow = sel ? sel.row : 0; const pos = resultArr[0]; if (pos.index !== curRow) { sheet.setSelection(pos.index, sel ? sel.col : 0, 1, 1); sheet.getParent().focus(); sheet.showRow(pos.index, spreadNS.VerticalPosition.center); SpreadJsObj.reloadRowsBackColor(sheet, [pos.index, curRow]); } } }; const locateNext = function () { if (resultArr.length > 0) { const sel = sheet.getSelections()[0]; const curRow = sel ? sel.row : 0; let next = _.find(resultArr, function (d) { return d.index > curRow; }); if (!next) next = resultArr[0]; if (next.index !== curRow) { sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1); sheet.getParent().focus(); sheet.showRow(next.index, spreadNS.VerticalPosition.center); SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]); } } }; const locatePre = function () { if (resultArr.length > 0) { const sel = sheet.getSelections()[0]; const curRow = sel ? sel.row : 0; let next = _.findLast(resultArr, function (d) { return d.index < curRow; }); if (!next) next = resultArr[resultArr.length - 1]; if (next.index !== curRow) { sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1); sheet.getParent().focus(); sheet.showRow(next.index, spreadNS.VerticalPosition.center); SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]); } } }; return {search, searchAndLocate, locateNext, locatePre}; })(); // $('#pos-keyword').bind('input propertychange', function () { // posSearch.search(this.value); // }); $('#pos-keyword').bind('keydown', function(e){ if (e.keyCode == 13) searchObj.searchAndLocate(this.value); }); $('#search-pre-pos').click(function () { searchObj.locatePre(); }); $('#search-next-pos').click(function () { searchObj.locateNext(); }); return searchObj; }; $.billsSearch = function (setting) { if (!setting.selector || !setting.searchSpread || !setting.resultSpreadSetting) return; if (!setting.searchRangeStr) setting.searchRangeStr = '项目节编号/清单编号/名称'; const resultId = setting.id + '-search-result'; const obj = $(setting.selector); let filter = []; if (setting.searchOver || setting.searchEmpty) { filter.push(''); // filter.push('
'); // filter.push(''); // filter.push(''); // filter.push('
'); } obj.html( '
\n' + '
\n' + '
\n' + filter.join('') + '
' + ' \n' + '
\n' + ' \n' + '
\n' + '
\n' + '
\n' + '
\n' + '
' ); autoFlashHeight(); const resultSpread = SpreadJsObj.createNewSpread($('#' + resultId)[0]); SpreadJsObj.initSheet(resultSpread.getActiveSheet(), setting.resultSpreadSetting); SpreadJsObj.forbiddenSpreadContextMenu('#' + resultId, resultSpread); const searchSheet = setting.searchSpread.getActiveSheet(); let searchResult = []; const search = function () { const filter = $('#search-filter').val(); if (filter) { searchCustom(filter); } else { searchBills(); } }; const searchBills = function () { const keyword = $('#searchKeyword', obj).val(); searchResult = []; const sortData = SpreadJsObj.getSortData(searchSheet); for (const node of sortData) { if ((node.code && node.code.indexOf(keyword) > -1) || node.b_code && node.b_code.indexOf(keyword) > -1 || node.name && node.name.indexOf(keyword) > -1) { const data = JSON.parse(JSON.stringify(node)); data.visible = true; searchResult.push(data); } } SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult); }; const getCheckFun = function (key) { const cs = setting.customSearch.find(function (x) {return x.key === key}); return cs ? cs.check : null; }; const searchCustom = function (key) { const keyword = $('#searchKeyword', obj).val(); const checkFun = getCheckFun(key); searchResult = []; const sortData = SpreadJsObj.getSortData(searchSheet); for (const node of sortData) { if (node.children && node.children.length > 0) continue; if (checkFun && checkFun(node)) { if (!keyword || (node.code && node.code.indexOf(keyword) > -1) || (node.b_code && node.b_code.indexOf(keyword) > -1) || (node.name && node.name.indexOf(keyword) > -1)) { const data = JSON.parse(JSON.stringify(node)); data.visible = true; searchResult.push(data); } } } calculateCompletePercent(searchResult); SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult); }; const calculateCompletePercent = function (searchResult) { if (!searchResult) return; for (const sr of searchResult) { const base = ZhCalc.add(sr.total_price, sr.end_qc_tp); sr.complete_percent = base !== 0 ? ZhCalc.mul(ZhCalc.div(sr.end_gather_tp, base), 100, 2) : 0; } }; $('input', obj).bind('keydown', function (e) { if (e.keyCode == 13) search(); }); $('button', obj).bind('click', () => {search()}); resultSpread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) { const sheet = info.sheet; const data = sheet.zh_data; if (!data) { return } const curBills = data[info.row]; if (!curBills) { return } SpreadJsObj.locateTreeNode(searchSheet, curBills.ledger_id, true); if (setting.afterLocated) { setting.afterLocated(); } }); return {spread: resultSpread}; }; })(jQuery);