From 58826d6f4eab9f8c9acf9fa8696f60039c645cfe Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 20 八月 2024 18:18:00 +0800 Subject: [PATCH] 2024-08-20 --- src/templates/zshare/verifycard/index.jsx | 111 ++++++++++++++++++++++++++++++++----------------------- 1 files changed, 64 insertions(+), 47 deletions(-) diff --git a/src/templates/zshare/verifycard/index.jsx b/src/templates/zshare/verifycard/index.jsx index 4617c6c..9113732 100644 --- a/src/templates/zshare/verifycard/index.jsx +++ b/src/templates/zshare/verifycard/index.jsx @@ -86,7 +86,7 @@ title: '楠岃瘉绫诲瀷', dataIndex: 'verifyType', width: '14%', - render: (text, record) => record.verifyType === 'logic' ? '閫昏緫楠岃瘉' : '鐗╃悊楠岃瘉', + render: (text) => text === 'logic' ? '閫昏緫楠岃瘉' : '鐗╃悊楠岃瘉', inputType: 'select', editable: true, options: [ @@ -124,7 +124,7 @@ record.field.split(',').forEach((_field, index) => { let _key = _field.toLowerCase() - _fieldValue.push(`${_key}=${_key === 'bid' ? '@BID@' : ''}`) + _fieldValue.push(`${_key}=${_key === 'bid' ? '@BID@' : `''`}`) _value.push(`${_labels[index] || ''}锛歺xx`) }) @@ -641,20 +641,19 @@ _verify.uniques = _verify.uniques || [] _verify.contrasts = _verify.contrasts || [] _verify.accountdate = _verify.accountdate || 'false' - _verify.accountfield = _verify.accountfield || '' - _verify.voucherdate = _verify.voucherdate || '' _verify.customverifys = _verify.customverifys || [] _verify.billcodes = _verify.billcodes || [] _verify.voucher = _verify.voucher || {enabled: false} _verify.scripts = _verify.scripts || [] _verify.cbScripts = _verify.cbScripts || [] - if (window.GLOB.process) { + if (window.GLOB.process && card.intertype !== 'inner') { _verify.workFlow = _verify.workFlow || 'false' _verify.flowType = _verify.flowType || (card.sqlType === 'insert' ? 'start' : 'approval') _verify.flowSql = _verify.flowSql || 'true' } else { delete _verify.workFlow + delete _verify.flowRemark delete _verify.flowType delete _verify.flowSql } @@ -664,20 +663,20 @@ _verify.printTempId = '' } - if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { - window.GLOB.funcs.forEach(m => { - let reg = new RegExp(`\\/\\*\\$ex@${m.func_code}-begin\\*\\/[\\s\\S]+\\/\\*@ex\\$-end\\*\\/`, 'ig') - _verify.customverifys.forEach(item => { - item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) - }) - _verify.scripts.forEach(item => { - item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) - }) - _verify.cbScripts.forEach(item => { - item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) - }) - }) - } + // if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { + // window.GLOB.funcs.forEach(m => { + // let reg = new RegExp(`\\/\\*\\$ex@${m.func_code}-begin\\*\\/[\\s\\S]+\\/\\*@ex\\$-end\\*\\/`, 'ig') + // _verify.customverifys.forEach(item => { + // item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) + // }) + // _verify.scripts.forEach(item => { + // item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) + // }) + // _verify.cbScripts.forEach(item => { + // item.sql = item.sql.replace(reg, `$ex@${m.func_code}@ex$`) + // }) + // }) + // } _verify.customverifys.forEach((item, i) => { item.$index = i + 1 @@ -696,11 +695,19 @@ activeKey = 'cbScripts' } + let oriVerify = fromJS(_verify).toJS() + + if (_verify.wxAppId) { + if (!window.GLOB.WXApps || window.GLOB.WXApps.filter(app => app.appType === 'public').length === 0) { + delete _verify.wxAppId + } + } + this.setState({ activeKey: activeKey, verifyInter: verifyInter, verify: _verify, - oriVerify: fromJS(_verify).toJS() + oriVerify: oriVerify }) if (card.intertype === 'inner') return @@ -774,13 +781,13 @@ _select.push(`@${_f.field}='1949-10-01'`) } else if (_f.type === 'number') { _type = `decimal(18,${_fieldlen})` - _select.push(`@${_f.field}=0`) + _select.push(`@${_f.field}=1`) } else if (_f.declare === 'decimal') { _type = `decimal(18,${_f.decimal || 0})` - _select.push(`@${_f.field}=0`) + _select.push(`@${_f.field}=1`) } else if (_f.type === 'rate') { _type = `decimal(18,2)` - _select.push(`@${_f.field}=0`) + _select.push(`@${_f.field}=1`) } else { _select.push(`@${_f.field}=''`) } @@ -816,8 +823,10 @@ colfields.push(_f.field) if (_f.datatype) { // 鑷畾涔夊瓧娈� - if (/decimal/ig.test(_f.datatype)) { - _select.push(`@${_f.field}=0`) + if (/decimal|int/ig.test(_f.datatype)) { + _select.push(`@${_f.field}=1`) + } else if (/date/ig.test(_f.datatype)) { + _select.push(`@${_f.field}='1949-10-01'`) } else { _select.push(`@${_f.field}=''`) } @@ -841,7 +850,7 @@ } if (_f.type === 'number') { - _select.push(`@${_f.field}=0`) + _select.push(`@${_f.field}=1`) } else { _select.push(`@${_f.field}=''`) } @@ -1158,7 +1167,6 @@ } orderSql = (record) => { - let _ModularDetailCode = '' let _lpline = '' if (record.TypeCharOne === 'Lp') { if (record.linkField.toLowerCase() === 'bid') { @@ -1166,17 +1174,20 @@ } else { _lpline = `set @ModularDetailCode= 'Lp'+ right('${record.mark || this.props.card.uuid}'+@${record.linkField.toLowerCase()},48)` } - _ModularDetailCode = '@ModularDetailCode' } else if (record.TypeCharOne === 'BN') { - _ModularDetailCode = `'${record.TypeCharOne}'` + if (record.linkField.toLowerCase() === 'bid') { + _lpline = `set @ModularDetailCode= 'BN'+ right(@BID@,48)` + } else { + _lpline = `set @ModularDetailCode= 'BN'+ right(@${record.linkField.toLowerCase()},48)` + } } else { - _ModularDetailCode = `'${record.ModularDetailCode}'` + _lpline = `set @ModularDetailCode= right('${record.ModularDetailCode}',50)` } let sql = `select @BillCode='', @${record.field}='', @ModularDetailCode='' ${_lpline} exec s_get_BillCode - @ModularDetailCode=${_ModularDetailCode}, + @ModularDetailCode=@ModularDetailCode, @Type=${record.Type}, @TypeCharOne='${record.TypeCharOne}', @TypeCharTwo ='${record.TypeCharTwo}', @@ -1562,7 +1573,7 @@ // 琛ㄥ崟鎻愪氦鏃舵鏌ヨ緭鍏ュ�兼槸鍚︽纭� return new Promise((resolve, reject) => { - if ((card.sqlType === 'custom' || verify.default === 'false') && verify.scripts.length === 0) { + if ((card.sqlType === 'custom' || verify.default === 'false') && !(verify.workFlow === 'true' && verify.flowSql === 'true') && verify.scripts.length === 0) { notification.warning({ top: 92, message: '涓嶆墽琛岄粯璁ql鏃讹紝蹇呴』璁剧疆鑷畾涔夎剼鏈紒', @@ -1584,20 +1595,20 @@ msg = '鑷畾涔夎剼鏈�' } - if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { - window.GLOB.funcs.forEach(m => { - let reg = new RegExp('\\$ex@' + m.func_code + '@ex\\$', 'ig') - verify.customverifys.forEach(item => { - item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) - }) - verify.scripts.forEach(item => { - item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) - }) - verify.cbScripts.forEach(item => { - item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) - }) - }) - } + // if (window.GLOB.funcs && window.GLOB.funcs.length > 0) { + // window.GLOB.funcs.forEach(m => { + // let reg = new RegExp('\\$ex@' + m.func_code + '@ex\\$', 'ig') + // verify.customverifys.forEach(item => { + // item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) + // }) + // verify.scripts.forEach(item => { + // item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) + // }) + // verify.cbScripts.forEach(item => { + // item.sql = item.sql.replace(reg, `/*$ex@${m.func_code}-begin*/\n${m.key_sql}\n/*@ex$-end*/`) + // }) + // }) + // } delete verify.limitInvalid delete verify.limitText @@ -1687,7 +1698,7 @@ {verify.default === 'false' ? <span className="count-tip"><ExclamationOutlined style={{color: 'orange'}}/></span> : null} </span> } key="base"> - <BaseForm card={card} appType={appType} columns={columns} unionFields={unionFields} verify={verify} notes={notes} emailCodes={emailCodes} onChange={(verify) => this.setState({verify})} wrappedComponentRef={(inst) => this.baseForm = inst}/> + <BaseForm card={card} appType={appType} fields={fields} columns={columns} unionFields={unionFields} verify={verify} notes={notes} emailCodes={emailCodes} onChange={(verify) => this.setState({verify})} wrappedComponentRef={(inst) => this.baseForm = inst}/> </TabPane> : null} {verifyInter === 'system' ? <TabPane tab={ <span> @@ -1777,6 +1788,10 @@ type="fullscreen" btn={this.props.card} initsql={this.state.initsql} + workFlow={verify.workFlow} + flowRemark={verify.flowRemark} + flowType={verify.flowType} + flowSql={verify.flowSql} customScripts={verify.scripts} useDefaultSql={verify.default !== 'false'} defaultsql={this.state.defaultsql} @@ -1791,7 +1806,9 @@ btn={this.props.card} initsql={this.state.initsql} workFlow={verify.workFlow} + flowRemark={verify.flowRemark} flowType={verify.flowType} + flowSql={verify.flowSql} customScripts={verify.scripts} useDefaultSql={verify.default !== 'false'} defaultsql={this.state.defaultsql} -- Gitblit v1.8.0