spring:
  application:
    name: iot-scheduler
  main:
    banner-mode: off
  data:
    redis:
      cluster:
        nodes: # 集群节点列表
          - 10.9.1.252:16380
          - 10.9.1.252:16381
          - 10.9.1.252:16382
        max-redirects: 3  # 最大重定向次数
      password: "Qixiao@redis20240410.com"  # 如果有密码

server:
  port: 33221

logging:
  level:
    root: INFO
    com.iot.scheduler: DEBUG

# Scheduler Configuration (Cron Expressions)
# Format: sec min hour day month day-of-week
scheduler:
  huaining:
    pull: "0 0/5 * * * ?"   # Every 5 minutes
    push: "0 0/10 * * * ?"  # Every 10 minutes
  chizhou:
    pull: "0 0/1 * * * ?"
    push: "0 0/1 * * * ?"
  panji:
    pull: "0 0/5 * * * ?"
    push: "0 0/10 * * * ?"
  hsq:
    push: "0 0 0/1 * * ?"
  pj:
    push: "0 0/10 * * * ?"

hn:
  third:
    domain: "http://220.180.204.38:1803/report-property"
    jdbcUrl: "jdbc:postgresql://106.15.73.210:5433/thingskit"
    jdbcUserName: "postgres"
    jdbcPassword: "postgres"
    selectSql: "SELECT
                  de.sn,
                  tkl1.str_v,
                  tkl2.dbl_v
                FROM
                  device de
                  LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
                  AND tkl1.key = 61
                  LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
                  AND tkl2.key = 175
                  WHERE
                  de.organization_id IN(
                  'f82530a0-93e4-4aeb-9339-f5b6d1127840',
                  '752a7621-b59b-477c-b15e-e06d412e02d5',
                  '3304ebd5-71ae-448a-91a2-e3b4d6ae258a',
                  '875a4841-c7f2-4e2c-88a2-ea62d4642132'
                  );"
hnhsq:
  third:
    reportUrl: "http://58.243.79.51:31357/mainApi/formEngine/formData/batchAddOrUpate"
    tokenUrl: "http://58.243.79.51:32210/auth/oauth/token"
    tokenUser: "hnsq"
    tokenPwd: "abc@1234"
    jdbcUrl: "jdbc:postgresql://106.15.73.210:5433/thingskit"
    jdbcUserName: "postgres"
    jdbcPassword: "postgres"
    selectSql: "SELECT d.name,d.sn,kv.ts,kv.long_v as value
        from ts_kv kv
        INNER JOIN device d on d.id = kv.entity_id and kv.key=61
        where tenant_id='5b6a05a0-f020-11f0-9cb8-e3376d1e7978'"
pj:
  third:
    reportUrl: "http://111.39.171.168:12280/mainApi/formEngine/formData/batchAddOrUpate"
    tokenUrl: "http://111.39.171.168:15555/auth/oauth/token"
    username: "adminhnjt"
    password: "admin@1234"
    formId: "t6937bc62e4332f00072a0849"
    uniqueKeys: "entName,deviceCode"
    jdbcUrl: "jdbc:postgresql://106.15.73.210:5433/thingskit"
    jdbcUserName: "postgres"
    jdbcPassword: "postgres"
    selectSql: "SELECT
                  tko.name AS entName,
                  de.name AS deviceName,
                  dc.credentials_id AS deviceCode,
                  tkl.long_v AS status
                FROM
                  device de
                  LEFT JOIN tk_organization tko ON de.organization_id = tko.id
                  LEFT JOIN ts_kv_latest tkl ON de.id = tkl.entity_id AND tkl.KEY = 61
                  LEFT JOIN device_credentials dc on de.id = dc.device_id
                WHERE
                  de.tenant_id = '0414df80-f01d-11f0-9cb8-e3376d1e7978'
                  AND de.device_profile_id = '0418b010-f01d-11f0-9cb8-e3376d1e7978';"

sh:
  iot:
    organizeId: "f82530a0-93e4-4aeb-9339-f5b6d1127840"
    profileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    deviceProfileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    userName: "shzh"
    password: "123456"
    tokenUrl: "https://iot.hzzlyun.com/api/auth/login"
    infoUrl: "https://iot.hzzlyun.com/api/yt/device"
    detailUrl: "https://iot.hzzlyun.com/api/v1/"

sl:
  iot:
    organizeId: "752a7621-b59b-477c-b15e-e06d412e02d5"
    profileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    deviceProfileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    userName: "slzy"
    password: "123456"
    tokenUrl: "https://iot.hzzlyun.com/api/auth/login"
    infoUrl: "https://iot.hzzlyun.com/api/yt/device"
    detailUrl: "https://iot.hzzlyun.com/api/v1/"

gh:
  iot:
    organizeId: "875a4841-c7f2-4e2c-88a2-ea62d4642132"
    profileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    deviceProfileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    userName: "ghxcl"
    password: "123456"
    tokenUrl: "https://iot.hzzlyun.com/api/auth/login"
    infoUrl: "https://iot.hzzlyun.com/api/yt/device"
    detailUrl: "https://iot.hzzlyun.com/api/v1/"

shzz:
  iot:
    organizeId: "3304ebd5-71ae-448a-91a2-e3b4d6ae258a"
    profileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    deviceProfileId: "f2292f60-f738-11f0-9cb8-e3376d1e7978"
    userName: "shzz"
    password: "123456"
    tokenUrl: "https://iot.hzzlyun.com/api/auth/login"
    infoUrl: "https://iot.hzzlyun.com/api/yt/device"
    detailUrl: "https://iot.hzzlyun.com/api/v1/"

device:
  token:
    url: "https://iotgc.cniot.vip/auth/token"
    userName: "chuzhoult"
    password: "111111"
  info:
    url: "https://iotgc.cniot.vip/triColorLamp/userGroupDtuSns"
  detail:
    url: "https://iotgc.cniot.vip/triColorLamp/dtuSnState"