| | |
| | | * @return {Object} setting 页面设置 |
| | | * @return {Array} columns 显示字段 |
| | | */ |
| | | static getDebugSql (setting, scripts, columns, searches = [], type) { |
| | | static getDebugSql (setting, scripts, columns, searches = [], type, hasExtend) { |
| | | let sql = '' |
| | | let error = '' |
| | | let _dataresource = '' |
| | |
| | | {reg: /@sum\$|\$sum@/ig, value: ''}, |
| | | ] |
| | | |
| | | if (window.GLOB.process) { |
| | | if (window.GLOB.process && type !== 'invoice') { |
| | | regs.push({reg: /@works_flow_code@/ig, value: `'${getuuid()}'`}) |
| | | } |
| | | |
| | | if (hasExtend) { |
| | | regs.push({reg: /@mk_time@/ig, value: '2024-04-29 17:20:00'}) |
| | | } |
| | | if (type === 'calendar') { |
| | | regs.push({reg: /@mk_year@/ig, value: '2024'}) |
| | | } |
| | |
| | | ` |
| | | } |
| | | |
| | | if (window.GLOB.urlFields) { |
| | | if (window.GLOB.urlFields && type !== 'invoice') { |
| | | window.GLOB.urlFields.forEach(field => { |
| | | let reg = new RegExp('@' + field + '@', 'ig') |
| | | _dataresource = _dataresource.replace(reg, `'0'`) |