techhero-business-track-dev.yml

spring:
  redis:
    database: 15
    host: dev-env
    port: 6379
    password: techhero
    timeout: 0
    pool:
      max-active: 8
      max-wait: -1
      max-idle: 8
      min-idle: 0
  datasource:
    druid:
      stat-view-servlet:
        loginUsername: root
        loginPassword: root
      initial-size: 1
      max-active: 20
      min-idle: 3
      max-wait: 60000
      time-between-eviction-runs-millis: 60000
      validation-query: select 1 from dual
      filters: stat,slf4j
    dynamic:
      primary: trackv1
      datasource:
        #        track:
        #          url: jdbc:mysql://dev-env:33060/track_pro?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
        #          username: root
        #          password: techhero
        #          driver-class-name: com.mysql.cj.jdbc.Driver
        trackv1:
          type: com.alibaba.druid.pool.DruidDataSource
          url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
          username: sjgzv1_dev
          password: sjgzv1_dev
        track:
          type: com.alibaba.druid.pool.DruidDataSource
          url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
          username: sjgz_dev
          password: sjgz_dev
        exam:
          type: com.alibaba.druid.pool.DruidDataSource
          url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
          username: jcsjv2_dev
          password: jcsjv2_dev
        command:
          type: com.alibaba.druid.pool.DruidDataSource
          url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
          username: yjzh_dev
          password: yjzh_dev

  rabbitmq:
    host: dev-env
    port: 5672
    username: rabbit
    password: rabbit-techhero
    virtual-host: /product
    listener:
      simple:
        acknowledge-mode: manual  # 消息确认方式，其有三种配置方式，分别是none、manual(手动ack) 和auto(自动ack) 默认auto
    publisher-confirms: true #确认消息已发送到交换机(Exchange)
    publisher-returns: true #确认消息已发送到队列(Queue)
    # 交换机
    exchanges:
      # GPS终端MQ配置
      - name: send.gps.terminal.exchange
        type: TOPIC

      # 检测终端MQ配置
      - name: send.check.terminal.exchange
        type: TOPIC

      # 更新设备驱动模式
      - name: update.use.terminal.model.exchange
        type: TOPIC

      # 应急指挥发送事件处理状态到试卷跟踪
      - name: notify_event_status_exchange
        type: TOPIC
    # 队列
    queues:
      # GPS终端MQ配置
      - name: queue.two
        routing-key: send.gps.terminal.key
        exchange-name: send.gps.terminal.exchange

      # 检测终端MQ配置
      - name: send.check.terminal.queue
        routing-key: send.check.terminal.key
        exchange-name: send.check.terminal.exchange

      # 更新设备驱动模式
      - name: update.use.terminal.model.queue
        routing-key: update.use.terminal.model.key
        exchange-name: update.use.terminal.model.exchange

      # 应急指挥发送事件处理状态到试卷跟踪
      - name: notify_event_status_queue
        routing-key: notify_event_status_key
        exchange-name: notify_event_status_exchange

  influx:
    openurl: http://119.96.99.9:18087 # 链接地址
    password: ""   # 密码
    username: ""  # 用户名
    dataBaseName: device_report  # 数据库名称

oss:
  bucketName: jyksy-gjjybzh
  httpEndpoint: ctyoss.chutianyun.gov.cn:8060
  httpsEndpoint: https://ctyoss.chutianyun.gov.cn:10443
  accessKey: L3B7SA05OXT0V9WKD02N
  secretKey: D0O4yTDqBCteH0p5dAgRibxZ8rNSLg0PShFF94IL

file:
  extraFile:
    tempFilePath: /temp/
template:
  download:
    smartLabelTemplatePath: /Users/cnnoter/Data/TempData/smartLabelTemplate.xlsx
    handTerminalTemplatePath: /Users/cnnoter/Data/TempData/handTerminalTemplate.xlsx

getByTerNoAndPlanCode: SELECT * FROM TB_GPS WHERE "terminalNumber" = {0} AND "planCode" = {1}  AND "terminalType" = {2}  ORDER BY "time" DESC  LIMIT 1

selevtTerminalHistory: SELECT * FROM TB_GPS WHERE "terminalNumber" = {0} AND "planCode" = {1} AND "terminalType" = {2} ORDER BY "time" ASC LIMIT 1000