| | |
|---|
| | | duration: 5 |
|---|
| | | }) |
|---|
| | | return |
|---|
| | | } else if (/\son\s+[a-z0-9_]+\.[a-z0-9_]+\s*=\s*[a-z0-9_]+\.[a-z0-9_]+/ig.test(values.sql)) { |
|---|
| | | let list = values.sql.match(/\son\s+[a-z0-9_]+\.[a-z0-9_]+\s*=\s*[a-z0-9_]+\.[a-z0-9_]+/ig) |
|---|
| | | let errors = [] |
|---|
| | | list.forEach(str => { |
|---|
| | | str = str.replace(/^\s/, '') |
|---|
| | | let strs = str.match(/(\s|=)[a-z0-9_]+\./ig) |
|---|
| | | if (strs.length === 2 && (strs[0].replace(/\s|\./g, '') === strs[1].replace(/\s|\./g, ''))) { |
|---|
| | | errors.push(str) |
|---|
| | | } |
|---|
| | | }) |
|---|
| | | |
|---|
| | | if (errors.length > 0) { |
|---|
| | | notification.warning({ |
|---|
| | | top: 92, |
|---|
| | | message: '不可使用同一个表字段进行关联：' + errors.join('、'), |
|---|
| | | duration: 5 |
|---|
| | | }) |
|---|
| | | return |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | let error = Utils.verifySql(values.sql, 'customscript') |
|---|
| | |
|---|
| | | 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@` |
|---|
| | | } else { |
|---|
| | | value = `update s_my_works_flow set status=@status@,statusname=@statusname@,modifydate=getdate(),modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname |
|---|
| | | value = `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(),modifyuserid=@userid@,modifyuser=@username,modifystaff=@fullname |
|---|
| | | 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,upid) |
|---|
| | | select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@time_id@ |
|---|
