// 实体类
import request from '../request'
import { REQUEST_URL } from '@/config/EnvProperties'
import { getAppEnvConfig } from '@/utils/env'

export default class DBAccess {
  public static GenerGUID() {
    return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
      const r = (Math.random() * 16) | 0,
        v = c == 'x' ? r : (r & 0x3) | 0x8
      return v.toString(16)
    })

    //  const dt= new  Date();
    //  return Math.random().toString(); // dt.toString();
    // return Math.random().toString(2); // dt.toString();
  }
  public static GenerOID(type?: string) {
    return 100
  }

  public static data: Array<any> = []

  public static async RunDBSrc(dbSrc: string, dbType: number, dbSource = '') {
    if (dbSrc == null || dbSrc === '') {
      throw new Error('执行的数据语句不能为空')
    }
    if (dbType == 0) return await this.RunSQLReturnTable(dbSrc, dbSource)
    if (dbType == 1) return this.RunUrlReturnJSON(dbSrc)
    if (dbType == 2) {
      const str = this.RunFunctionReturnStr(dbSrc)
      if (str == null || str == '') {
        return []
      }
      return JSON.parse(str)
    }
    return []
  }

  /**
   * 执行SQL语句
   * @param sql 执行的语句
   * @param dbSource 数据源类型 本地和外部数据源
   * @constructor
   */
  public static async RunSQLReturnTable(sql: string, dbSource = 'local') {
    if (sql == null || typeof sql === 'undefined' || sql == '') {
      throw new Error('数据查询为空，请求无效')
    }
    // if (sql.includes('@')==true)
    const formData = new FormData()
    formData.append('SQL', encodeURIComponent(sql))
    formData.append('DBSrc', dbSource)
    return await request.post<any, any>(REQUEST_URL, formData, {
      params: {
        DoType: 'DBAccess_RunSQLReturnTable',
        t: Date.now()
      }
    })
  }

  /**
   * 根据URl请求返回字符串数据
   * @param url
   * @constructor
   */
  public static async RunUrlReturnString(url: string) {
    if (url == null || typeof url === 'undefined') {
      throw new Error('url为空，请求无效')
    }

    if (url.match(/^http:\/\//) == null) {
      const { VITE_GLOB_API_URL } = getAppEnvConfig()
      url = VITE_GLOB_API_URL + '/' + url
    }
    const formData = new FormData()
    formData.append('urlExt', url)
    return await request.post<any, any>(REQUEST_URL, formData, {
      params: {
        DoType: 'RunUrlCrossReturnString',
        t: Date.now()
      }
    })
  }

  /**
   * 根据URl请求返回JSON格式数据
   * @param url
   * @constructor
   */
  public static async RunUrlReturnJSON(url: string) {
    const str = await this.RunUrlReturnString(url)
    if (typeof str == 'string') {
      if (str.includes('url为空') == true) {
        this.data = []
        return
      }
      if (str.includes('err@') == true) {
        this.data = []
        throw new Error(str.replace('err@', ''))
      }
      try {
        this.data = JSON.parse(str)
      } catch (e: any) {
        this.data = []
        console.log('RunUrlReturnJSON数据解析失败:' + str)
        throw new Error('值获取失败')
      }
    }
  }
  /**
   * 执行方法
   * @param funcName 方法名称
   * @constructor
   */
  public static RunFunctionReturnStr(funcName: string) {
    //可能需要动态引入js/ts文件
    try {
      funcName = funcName.replace(/~/g, "'")
      if (funcName.indexOf('(') == -1) return eval(funcName + '()')
      else return eval(funcName)
    } catch (e: any) {
      if (e.message) throw new Error('执行方法[' + funcName + ']错误:' + e.message)
    }
  }
}