| | |
|---|
| | | if (!_arr.includes('submituserid')) { |
|---|
| | | _form.push('submituserid=@userid@') |
|---|
| | | } |
|---|
| | | if (!_arr.includes('submituser')) { |
|---|
| | | _form.push('submituser=@username') |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | if (!_arr.includes('modifydate')) { |
|---|
| | | _form.push('modifydate=getdate()') |
|---|
| | | } |
|---|
| | | if (!_arr.includes('modifyuser')) { |
|---|
| | | _form.push('modifyuser=@username') |
|---|
| | | } |
|---|
| | | if (!_arr.includes('modifyuserid')) { |
|---|
| | | _form.push('modifyuserid=@userid@') |
|---|
| | |
|---|
| | | if (_verify.voucher && _verify.voucher.enabled) { |
|---|
| | | _voucher = ',BVoucher=@BVoucher,FIBVoucherDate=@FIBVoucherDate,FiYear=@FiYear' |
|---|
| | | } |
|---|
| | | _defaultsql = `update ${card.sql} set deleted=1,modifydate=getdate(),modifyuserid=@userid@${_voucher} where ${config.setting.primaryKey || 'id'}${card.Ot !== 'requiredOnce' ? '=@ID@' : ' in (select ID from dbo.SplitComma(@ID@))'};` |
|---|
| | | _defaultsql = `update ${card.sql} set deleted=1,modifydate=getdate(),modifyuser=@username,modifyuserid=@userid@${_voucher} where ${config.setting.primaryKey || 'id'}${card.Ot !== 'requiredOnce' ? '=@ID@' : ' in (select ID from dbo.SplitComma(@ID@))'};` |
|---|
| | | } else if (card.sqlType === 'delete') { |
|---|
| | | let _msg = '' |
|---|
| | | if (columns && columns.length > 0 && card.Ot !== 'notRequired' && card.Ot !== 'requiredOnce') { |
|---|
