import React, {Component} from 'react'
|
import PropTypes from 'prop-types'
|
import { Form, Row, Col, Button, notification, Tooltip, Radio, Select, Switch } from 'antd'
|
import { QuestionCircleOutlined } from '@ant-design/icons'
|
|
import { checkSQL } from '@/utils/utils-custom.js'
|
import CodeMirror from '@/templates/zshare/codemirror'
|
import './index.scss'
|
|
class CustomForm extends Component {
|
static propTpyes = {
|
type: PropTypes.any,
|
btn: PropTypes.object,
|
formfields: PropTypes.string,
|
colfields: PropTypes.string,
|
getSysDefSql: PropTypes.func,
|
systemScripts: PropTypes.array,
|
scriptsChange: PropTypes.func
|
}
|
|
state = {
|
editItem: null,
|
loading: false,
|
skip: false
|
}
|
|
edit = (record) => {
|
this.setState({
|
editItem: record
|
})
|
|
if (this.props.type) {
|
this.props.form.setFieldsValue({
|
sql: record.sql
|
})
|
} else {
|
this.props.form.setFieldsValue({
|
sql: record.sql,
|
position: record.position || 'back'
|
})
|
}
|
}
|
|
handleConfirm = () => {
|
const { type } = this.props
|
const { editItem, skip } = this.state
|
// 表单提交时检查输入值是否正确
|
this.props.form.validateFieldsAndScroll((err, values) => {
|
if (err) return
|
|
if (!values.sql || /^[\s\n]+$/.test(values.sql)) {
|
notification.warning({
|
top: 92,
|
message: '请输入sql!',
|
duration: 5
|
})
|
return
|
}
|
|
values.uuid = editItem ? editItem.uuid : ''
|
values.position = values.position || (editItem ? editItem.position : 'front')
|
|
if (type === 'fullscreen' && editItem) {
|
values.status = editItem.status || 'true'
|
}
|
|
let pass = checkSQL(values.sql, 'customscript')
|
|
if (!pass && !skip) return
|
|
if (skip) {
|
this.setState({
|
skip: false,
|
editItem: null
|
})
|
this.props.form.setFieldsValue({
|
sql: ''
|
})
|
this.props.scriptsChange(values)
|
} else {
|
this.setState({loading: true})
|
|
this.props.scriptsChange(values, () => {
|
this.setState({
|
loading: false,
|
editItem: null
|
})
|
this.props.form.setFieldsValue({
|
sql: ''
|
})
|
}, () => {
|
this.setState({
|
loading: false
|
})
|
})
|
}
|
})
|
}
|
|
handleCancel = () => {
|
this.setState({
|
editItem: null
|
})
|
|
this.props.form.setFieldsValue({
|
sql: ''
|
})
|
}
|
|
selectScript = (value, option) => {
|
const { flowType, flowRemark, getSysDefSql } = this.props
|
|
if (!value || !option) return
|
|
let _sql = this.props.form.getFieldValue('sql')
|
if (/^\s+$/.test(_sql)) {
|
_sql = ''
|
}
|
if (_sql) {
|
_sql = _sql + `
|
|
`
|
}
|
|
if (value === 'flowSql') {
|
if (flowType === 'start') {
|
value = `insert into s_my_works_flow (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,work_group,works_flow_detail_id,work_grade,bid,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_name@,@works_flow_param@,@status@,@statusname@,@work_group@,@works_flow_detail_id@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@
|
insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,bid,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@
|
insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_detail_id@,@userid@,@start_type@,@userid@,@UserName,@FullName,@time_id@
|
insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid,typecharone)
|
select @ID@,@works_flow_code@,@userid@,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@,'begin'`
|
} else {
|
value = `set @retmsg =''
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and userid =@userid@ and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg =''
|
begin
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and userid=@userid@ and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg !=''
|
begin
|
select @ErrorCode='E', @retmsg='当前单据已审核，请刷新后重试'
|
goto aaa
|
end
|
|
if @dataM@ !=''
|
begin
|
set @retmsg =''
|
select @retmsg='X' from s_my_works_flow_role where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0 and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg != ''
|
begin
|
goto goto_mk
|
end
|
end
|
else
|
begin
|
set @retmsg =''
|
select @retmsg=userid from s_my_works_flow_role where works_flow_id=@id@ and works_flow_code=@works_flow_code@ and deleted=0 and works_flow_detail_id =@works_flow_detail_id
|
|
if @retmsg !=''
|
begin
|
select @retmsg=workerCode+workerName from BD_workers where id=@retmsg
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限，请联系'+@retmsg+'操作'
|
goto aaa
|
end
|
end
|
|
select @retmsg='页面数据已更新，或没有当前单据的审批权限'
|
goto aaa
|
end
|
|
goto_mk:
|
|
set @retmsg=''
|
|
update s_my_works_flow set status=@status@,statusname=@statusname@,works_flow_param=@works_flow_param@,works_flow_detail_id=@works_flow_detail_id@,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname${flowRemark ? ',remark=@' + flowRemark : ''}
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
|
insert into s_my_works_flow_log (works_flow_id,works_flow_code,works_flow_name,works_flow_param,status,statusname,works_flow_detail_id,work_group,work_grade,bid,createuserid,CreateUser,CreateStaff,upid${flowRemark ? ',remark' : ''})
|
select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@bid@,@UserID@,@UserName,@FullName,@time_id@${flowRemark ? ',@' + flowRemark : ''}
|
|
update s_my_works_flow_role set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0
|
|
if @check_userids@ != ''
|
begin
|
insert into s_my_works_flow_role (works_flow_id,works_flow_code,userid,works_flow_detail_id,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,ID,@works_flow_detail_id@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@check_userids@)
|
insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_detail_id@,ID,@check_type@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@check_userids@)
|
end
|
if @notice_userids@ != ''
|
begin
|
update n
|
set deleted=10,modifydate=getdate(),upid=@time_id@,modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname
|
from (select * from s_my_works_flow_notice where works_flow_id=@ID@ and works_flow_code=@works_flow_code@ and deleted=0) n
|
inner join (select ID from dbo.SplitComma(@notice_userids@)) s
|
on n.userid = s.id
|
insert into s_my_works_flow_notice (works_flow_id,works_flow_code,works_flow_detail_id,userid,notice_type,createuserid,CreateUser,CreateStaff,upid)
|
select @ID@,@works_flow_code@,@works_flow_detail_id@,ID,@notice_type@,@userid@,@UserName,@FullName,@time_id@ from dbo.SplitComma(@notice_userids@)
|
end`
|
}
|
|
value = value.replace(/\n\s{8}/g, '\n')
|
} else if (value === 'defaultsql') {
|
value = ''
|
if (getSysDefSql) {
|
value = getSysDefSql()
|
}
|
}
|
|
_sql = _sql.replace(/\s{6}$/, '')
|
_sql = _sql + `/*${option.props.children}*/
|
`
|
_sql = _sql.replace(/\s{4}$/, '')
|
_sql = _sql + value
|
|
this.props.form.setFieldsValue({
|
sql: _sql
|
})
|
}
|
|
render() {
|
const { formfields, colfields, systemScripts, btn, type, workFlow, flowType } = this.props
|
const { getFieldDecorator } = this.props.form
|
const { editItem, skip } = this.state
|
const formItemLayout = {
|
labelCol: {
|
xs: { span: 24 },
|
sm: { span: 8 }
|
},
|
wrapperCol: {
|
xs: { span: 24 },
|
sm: { span: 16 }
|
}
|
}
|
|
let _type = type || ''
|
|
return (
|
<Form {...formItemLayout} className="verify-form verify-custom-scripts" id={'verify-custom-scripts' + _type}>
|
<Row gutter={24}>
|
{!_type ? <Col span={8}>
|
<Form.Item label={'表名'} style={{whiteSpace: 'nowrap', margin: 0}}>
|
{btn.sql || ''}
|
</Form.Item>
|
</Col> : null}
|
{!_type ? <Col span={10}>
|
<Form.Item label={'报错字段'} style={{margin: 0, whiteSpace: 'nowrap'}}>
|
errorcode（增加后缀NT表示数据不回滚，如ENT、NNT、FNT、NMNT、CNT、-2NT）, retmsg
|
</Form.Item>
|
</Col> : null}
|
{!_type ? <Col span={24} className="sqlfield">
|
<Form.Item label={'可用字段'}>
|
<Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="公共值，请按照@xxx@格式使用。"><span style={{color: '#1890ff'}}>BID, ID, LoginUID, SessionUid, UserID, Appkey, lang, time_id, typename, datam</span></Tooltip>,
|
{window.GLOB.process && workFlow === 'true' ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title={`工作流变量，请按照@xxx@格式使用${flowType !== 'start' ? '，works_flow_sign 为分支启用高级设置时的标记值' : ''}。`}><span style={{color: '#26C281'}}>works_flow_code, works_flow_name, works_flow_param, works_flow_detail_id, status, statusname, work_group, work_grade, {flowType === 'start' ? 'start_type,' : 'check_type, notice_type, check_userids, notice_userids, works_flow_sign,'} </span></Tooltip> : null}
|
<Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="系统变量，系统会定义变量并赋值。"><span style={{color: '#fa8c16'}}>UserName, FullName, RoleID, mk_departmentcode, mk_organization, mk_user_type, mk_nation, mk_province, mk_city, mk_district, mk_address, mk_deleted, mk_submit_type</span></Tooltip>,
|
<Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="系统变量，系统会定义变量并在单号生成或创建凭证时使用。"><span style={{color: '#13c2c2'}}>BillCode, BVoucher, FIBVoucherDate, FiYear, ModularDetailCode</span></Tooltip>
|
{formfields ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="表单变量，系统会定义变量并赋值。">, <span style={{color: '#8E44AD'}}>{formfields}</span></Tooltip> : ''}
|
{colfields ? <Tooltip mouseLeaveDelay={0.3} mouseEnterDelay={0.3} placement="top" title="字段集变量，系统会定义变量并赋值。">, {colfields}</Tooltip> : ''}
|
</Form.Item>
|
</Col> : null}
|
{!_type ? <Col span={8} style={{whiteSpace: 'nowrap'}}>
|
<Form.Item style={{marginBottom: 0}} label={
|
<Tooltip placement="bottomLeft" title={'自定义脚本与默认sql位置关系。'}>
|
<QuestionCircleOutlined className="mk-form-tip" />
|
执行位置
|
</Tooltip>
|
}>
|
{getFieldDecorator('position', {
|
initialValue: 'front'
|
})(
|
<Radio.Group>
|
<Radio value="init">初始化</Radio>
|
<Radio value="front">sql前</Radio>
|
<Radio value="back">sql后</Radio>
|
</Radio.Group>
|
)}
|
</Form.Item>
|
</Col> : null}
|
{!_type ? <Col span={8}>
|
<Form.Item label={'快捷添加'} style={{marginBottom: 0}}>
|
<Select
|
showSearch
|
filterOption={(input, option) => option.props.children.toLowerCase().indexOf(input.toLowerCase()) >= 0}
|
onSelect={this.selectScript}
|
getPopupContainer={() => document.getElementById('verify-custom-scripts' + _type)}
|
>
|
<Select.Option key="default" value="defaultsql">默认sql</Select.Option>
|
{window.GLOB.process && workFlow === 'true' ? <Select.Option key="flow" value="flowSql">默认sql（工作流）</Select.Option> : null}
|
<Select.Option key="debugger" value={`z_debug: select @ErrorCode='E',@retmsg='测试断点' goto aaa`}>
|
测试断点
|
</Select.Option>
|
{systemScripts.map((option, i) =>
|
<Select.Option key={i} value={option.value}>{option.name}</Select.Option>
|
)}
|
</Select>
|
</Form.Item>
|
</Col> : null}
|
<Col span={5} className="add" style={{whiteSpace: 'nowrap'}}>
|
<Button onClick={this.handleConfirm} loading={this.state.loading} className="mk-green" style={{marginBottom: 15, marginLeft: 30}}>
|
{_type === 'fullscreen' && !editItem ? '添加' : '保存'}
|
</Button>
|
<Button onClick={this.handleCancel} style={{marginBottom: 15, marginLeft: 10}}>
|
取消
|
</Button>
|
</Col>
|
<Col span={3} className="forced" style={{paddingTop: '12px', fontSize: '12px', whiteSpace: 'nowrap'}}>
|
强制保存：
|
<Switch checked={skip} size="small" onChange={() => this.setState({skip: !skip})}/>
|
</Col>
|
<Col span={24} className="sql">
|
<Form.Item label={
|
<Tooltip placement="topLeft" overlayStyle={{width: '520px', maxWidth: '520px'}} title={<><div>{`调试替换符 /*$breakpoint_begin_xxxx@ 、@breakpoint_end_xxxx$*/，在控制台中输入 window.debug = 'xxxx' 会启用对应的调试语句，快捷键 ctrl+c 或在控制台中输入 window.debug = false 关闭调试。注：调试时字符 $breakpoint_proc@ 将被替换。`}</div><div style={{height: '5px'}}></div><div>{`数据检查替换符 $check@ -> ''、 @check$ -> ''，ErrorCode等于C时会询问是否继续执行，确定时 $check@ -> /*、 @check$ -> */。注：1、需使用系统接口 2、行设置为“选择多行”时无效。`}</div><div style={{height: '5px'}}></div><div>{`数据权限替换符 $@ -> /* 或 ''、 @$ -> */ 或 ''`}</div></>}>
|
<QuestionCircleOutlined className="mk-form-tip" />
|
sql
|
</Tooltip>
|
} required>
|
{getFieldDecorator('sql', {
|
initialValue: '',
|
})(<CodeMirror />)}
|
</Form.Item>
|
</Col>
|
</Row>
|
</Form>
|
)
|
}
|
}
|
|
export default Form.create()(CustomForm)
|
