2024-05-07

king

2024-05-07 2aa5ab63b4bbce5c36dbb3511b205b3b5f6af9bd

 src/menu/debug/index.jsx

@@ -74,13 +74,7 @@
      { reg: /@\$/ig, value: '' },
      { reg: /@datam@/ig, value: `''` },
    ]
    
    if (window.GLOB.externalDatabase !== null) {
      regs.push({
        reg: /@db@/ig,
        value: window.GLOB.externalDatabase
      })
    }

    if (config.urlFields) {
      config.urlFields.forEach(field => {
        regs.push({
@@ -423,12 +417,6 @@
              aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg`
          }

          backSql = backSql.replace(/@ID@/ig, `'id'`)
          backSql = backSql.replace(/@BID@/ig, `'bid'`)
          backSql = backSql.replace(/@LoginUID@/ig, `'LoginUID'`)
          backSql = backSql.replace(/@SessionUid@/ig, `'SessionUid'`)
          backSql = backSql.replace(/@UserID@/ig, `'UserID'`)
          backSql = backSql.replace(/@Appkey@/ig, `'appkey'`)
          backSql = backSql.replace(/@typename@/ig, `'typename'`)
          backSql = backSql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)
        }
@@ -462,13 +450,6 @@
          { reg: /@\$/ig, value: '' },
          { reg: /@datam@/ig, value: `''` },
        ]
        
        if (window.GLOB.externalDatabase !== null) {
          regs.push({
            reg: /@db@/ig,
            value: window.GLOB.externalDatabase
          })
        }
    
        if (process) {
          regs.push({ reg: /@works_flow_code@/ig, value: `'1949-10-01 15:00:00'` })
@@ -566,8 +547,8 @@
  }

  getSysDefaultSql = (btn, component, process, group, retmsg) => {
    let primaryId = 'id'
    let BID = 'bid'
    let primaryId = Utils.getuuid()
    let BID = Utils.getuuid()
    let verify = btn.verify || {}
    let _actionType = null
    let setting = component.setting
@@ -789,7 +770,7 @@
    }
    _sql = `Declare @tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50),@ModularDetailCode nvarchar(50), @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@mk_deleted int,@bid nvarchar(50)${_declarefields}
      `
  

    let userName = 'User_Name'
    let fullName = 'Full_Name'
    let RoleID = 'role_id'
@@ -1300,15 +1281,46 @@
      let detailId = '0'
  
      if (verify.flowSql === 'true') {
        _sql += `
        /* 工作流默认sql */
        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,upid)
        select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@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@
        `
        if (verify.flowType === 'start') {
          _sql += `
            /* 工作流默认sql */
            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,upid)
            select @ID@,@works_flow_code@,@works_flow_name@ ,@works_flow_param@,@status@,@statusname@,@works_flow_detail_id@,@work_group@,@work_grade@,@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@
          `
        } else {
          _sql += `
            /* 工作流默认sql */
            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
            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@
            
            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
          `
        }
      }
  
      _sql = _sql.replace(/@start_type@/ig, `'开始'`)
@@ -1344,10 +1356,6 @@
  
    _sql = _sql.replace(/@ID@/ig, `'${primaryId || ''}'`)
    _sql = _sql.replace(/@BID@/ig, `'${BID}'`)
    _sql = _sql.replace(/@LoginUID@/ig, `'LoginUID'`)
    _sql = _sql.replace(/@SessionUid@/ig, `'SessionUid'`)
    _sql = _sql.replace(/@UserID@/ig, `'UserID'`)
    _sql = _sql.replace(/@Appkey@/ig, `'appkey'`)
    _sql = _sql.replace(/@typename@/ig, `'typename'`)
    _sql = _sql.replace(/@\$|\$@/ig, '').replace(/@datam@/ig, `''`)
  
@@ -1377,19 +1385,8 @@
    let sheet = _sheet.replace(/(.*)\.(.*)\./ig, '')
    
    database = database ? (database[0] || '') : ''
  
    let getuuid = () => {
      let uuid = []
      let timestamp = new Date().getTime()
      let _options = '0123456789abcdefghigklmnopqrstuv'
      for (let i = 0; i < 19; i++) {
        uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
      }
      uuid = timestamp + uuid.join('')
      return uuid
    }

    let upId = getuuid()
    let upId = Utils.getuuid()
  
    let vals = []
    btn.columns.forEach(col => {
@@ -1433,21 +1430,11 @@
      {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
      {reg: /@ID@/ig, value: `'id'`},
      {reg: /@BID@/ig, value: `'bid'`},
      {reg: /@LoginUID@/ig, value: `'LoginUID'`},
      {reg: /@SessionUid@/ig, value: `'SessionUid'`},
      {reg: /@UserID@/ig, value: `'UserID'`},
      {reg: /@Appkey@/ig, value: `'appkey'`},
      {reg: /@typename@/ig, value: `'admin'`},
      {reg: /\$@/ig, value: ''},
      {reg: /@\$/ig, value: ''},
      {reg: /@datam@/ig, value: `''`},
    ]

    if (window.GLOB.externalDatabase !== null) {
      regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
    }

    btn.scripts && btn.scripts.forEach(script => {
      if (script.status === 'false') return
@@ -1538,7 +1525,7 @@
      `
    }

    sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50) )
    sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50))
      Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512)
      
      Select  @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}'
@@ -1635,20 +1622,11 @@
      {reg: new RegExp('(^|\\s)@' + sheet + '(\\s|$)', 'ig'), value: ` #${sheet} `},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\(', 'ig'), value: ` #${sheet}(`},
      {reg: new RegExp('(^|\\s)@' + sheet + '\\)', 'ig'), value: ` #${sheet})`},
      {reg: /@BID@/ig, value: `'${BID}'`},
      {reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`},
      {reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`},
      {reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`},
      {reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`},
      {reg: /@typename@/ig, value: `'admin'`},
      {reg: /\$@/ig, value: isDM ? '/*' : ''},
      {reg: /@\$/ig, value: isDM ? '*/' : ''},
      {reg: /@datam@/ig, value: isDM ? `'Y'` : `''`},
    ]

    if (window.GLOB.externalDatabase !== null) {
      regs.push({reg: /@db@/ig, value: window.GLOB.externalDatabase})
    }

    btn.scripts && btn.scripts.forEach(script => {
      if (script.status === 'false') return
@@ -1736,7 +1714,7 @@
      `
    }

    sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(50) )
    sql = `create table #${sheet} (${declarefields.join(',')},jskey nvarchar(50),data_type nvarchar(50),BID nvarchar(256))
      Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512)
      
      Select  @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}', @RoleID='${RoleID}', @mk_departmentcode='${departmentcode}', @mk_organization='${organization}', @mk_user_type='${mk_user_type}', @mk_nation='${nation}', @mk_province='${province}', @mk_city='${city}', @mk_district='${district}', @mk_address='${address}'
@@ -1762,11 +1740,10 @@
    let item = {setting: {}, columns: [], search: []}

    btn.verify.columns.forEach(col => {
      if (col.Column && col.Column !== '$Index') {
        item.columns.push({
          field: col.Column
        })
      }
      if (col.output === 'false' || !col.Column || col.Column === '$Index') return
      item.columns.push({
        field: col.Column
      })
    })

    if (btn.verify.useSearch !== 'false') {
@@ -1792,13 +1769,6 @@
      { reg: /@\$/ig, value: '' },
      { reg: /@datam@/ig, value: `''` },
    ]
    
    if (window.GLOB.externalDatabase !== null) {
      regs.push({
        reg: /@db@/ig,
        value: window.GLOB.externalDatabase
      })
    }

    let sql = this.formatDataSource(item, regs)

@@ -1914,17 +1884,14 @@
      { reg: /@orderBy@/ig, value: item.setting.order || '' },
      { reg: /@pageSize@/ig, value: 9999 },
      { reg: /@pageIndex@/ig, value: 1},
      { reg: /@ID@/ig, value: `''`},
      { reg: /@BID@/ig, value: `''`},
      { reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`},
      { reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`},
      { reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`},
      { reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`},
      { reg: /@typename@/ig, value: `'admin'`},
    )

    if (item.hasExtend) {
      regs.push({reg: /@mk_time@/ig, value: '2024-04-29 17:20:00'})
    }
    if (item.type === 'calendar') {
      regoptions.push({ reg: /@mk_year@/ig, value: '2023' })
      regoptions.push({ reg: /@mk_year@/ig, value: '2024' })
    }

    regoptions.forEach(cell => {