application-pro.yml

#生产环境
server:
  port: 8083
  servlet:
    # context-path: /YoulinghrApiV100
    session: 
      timeout: 2592000   # session会话过期时间
spring:
  servlet: 
    multipart: 
      max-file-size: 500MB  
      max-request-size: 500MB
  jpa:
    # 配置生成表 存储引擎InnoDB
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
      # database: 
    open-in-view: false
      # naming: 
      # spring boot jpa hibernate 根据实体类生成表以及字段的命名策略
      # 无修改命名 org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
      # 遇到大写字母 加”_”的命名 org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
      # physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
    hibernate: 
      ddl-auto: update
    show-sql: true
  datasource:
    # username: root
    # password: youlingHR73!
    username: root
    password: huiYi12345678huaiQiao@*
    # username: tang
    # password: Tang123456!
    # url: jdbc:mysql://120.24.172.51:3306/youlingrc_tang?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&zeroDateTimeBehavior=CONVERT_TO_NULL
    url: jdbc:mysql://8.134.55.197:3306/timer?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&zeroDateTimeBehavior=CONVERT_TO_NULL
    # url: jdbc:mysql://192.168.172.200:3306/youlingrc_8timer201?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&zeroDateTimeBehavior=CONVERT_TO_NULL
    # url: jdbc:mysql://db.hhlsz.com:3306/youlingrc_8timer201?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&zeroDateTimeBehavior=CONVERT_TO_NULL
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    # 下面为连接池的补充设置，应用到上面所有数据源中
    # 初始化大小，最小，最大
    initial-size: 5
    min-idle: 5
    max-active: 50
    maximum-pool-size: 80
    max-wait: 60000 # 配置获取连接等待超时的时间
    time-between-eviction-runs-millis: 300000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    min-evictable-idle-time-millis: 1800000   # 配置一个连接在池中最小生存的时间，单位是毫秒
    validation-query: SELECT 1 FROM DUAL
    test-while-idle: true # 当连接空闲时，是否执行连接测试
    test-on-borrow: false # 当从连接池借用连接时，是否测试该连接
    test-on-return: false # 在连接归还到连接池时是否测试该连接
    # 打开PSCache，并且指定每个连接上PSCache的大小
    pool-prepared-statements: true
    # 要启用PSCache，必须配置大于0，当大于0时，poolPreparedStatements自动触发修改为true。在Druid中，不会存在Oracle下PSCache占用内存过多的问题，可以把这个数值配置大一些，比如说100
    #max-pool-prepared-statement-per-connection-size: 20
    # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
    #connect-properties:  druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
    druid:   
      # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙 ,不能用log4j，不然报错：Failed to bind properties under 'spring.datasource.druid' to javax.sql.DataSource:
      filters:  stat,slf4j
      # 配置监控服务器
      stat-view-servlet:
        login-username: Tang
        login-password: 123
        reset-enable: false
        url-pattern: /druid/*
        # 添加IP白名单
        #allow:
        # 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
        #deny:
      web-stat-filter:
        # 添加过滤规则
        url-pattern: /*
        # 忽略过滤格式
        exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
  # 时间戳统一转换
  jackson:
     date-format: yyyy-MM-dd HH:mm:ss
  # spring boot启动打印横幅 配置
  banner:
      charset: UTF-8 # Banner file encoding.    
      location: banner.txt # Banner text resource location.
      image: 
         location: banner.gif # Banner image file location (jpg or png can also be used).
         width: 76 # Width of the banner image in chars.
         height: 76 # Height of the banner image in chars (default based on image height).
         margin: 2 # Left hand image margin in chars.
         invert: false # Whether images should be inverted for dark terminal themes.
  mail: 
     port: 465
     protocol: smtp
     host: smtp.youlingrc.com
     username: postmaster@youlingrc.com
     password: YoulingRC2020
     default-encoding: utf-8
     properties:
        mail: 
           smtp:
              auth: true
              starttls: 
                 enable: true
                 required: true
              ssl: # SSL Config
                 enable: true
              socketFactory: 
                 port: 465
                 class: javax.net.ssl.SSLSocketFactory
  redis:
    database: 5 # Redis数据库索引（默认为0）,如果设置为1，那么存入的key-value都存放在select 1中
    host: 8.134.55.197
    port: 6379
    password: huayi20220222
    max-wait: 30000    # 连接池最大阻塞等待时间（使用负值表示没有限制）
    max-active: 100   # 连接池最大连接数（使用负值表示没有限制）
    max-idle: 20     # 连接池中的最大空闲连接
    min-idle: 0     # 连接池中的最小空闲连接
    timeout: 5000   # 连接超时
      #password: 123456 # 密码,默认密码为空
      #cluster:       # 集群配置
    #nodes: 127.0.0.1:6381,127.0.0.1:6382,127.0.0.1:6383,127.0.0.1:6384,127.0.0.1:6385,127.0.0.1:6386
    #max-redirects: 2  # 最大重定向次数
  devtools:
    restart:
      poll-interval: 3000ms
      quiet-period: 2999ms

 # mybatis-plus
mybatis-plus:
  mapper-locations: classpath:mapping/**/*Mapper.xml   # dao到xml文件映射
  type-aliases-package: cn.timer.api.bean           # xml中#全局类名别名
  configuration:
    #log-impl: org.apache.ibatis.logging.stdout.StdOutImpl   # sql日志打印
    call-setters-on-nulls: true                     # Map做返回体时  字段值为null依然返回
    cache-enabled: true
  global-config:
    db-config:
      #主键类型  0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
      #id-type: uuid
      id-type: auto
      #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
      # field-strategy: not_null
      #驼峰下划线转换
      table-underline: true
      #逻辑删除配置
      #logic-delete-value: 0
      #logic-not-delete-value: 1
 # 分页插件
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql
 
#showSql
logging:
  level:
    root: ERROR
    cn.timer.api.dao: error
  pattern:
    console: '--%p--%m%n'
    
#swagger:
#  ui-config:
#    operations-sorter: method   # 它提供了两个配置项：alpha和method，分别代表了按字母表排序以及按方法定义顺序排序

config-8timer:
  environmental-science: pro
  expiration_time: 2 #扫码登录过期时长
  machine8timerUrl: 'http://oa-record.jidahuayi.com'
  #machine8timerUrl: 'http://8.134.55.197:8088'
  authentication-code: ''
  prescription: 8 #一天工作8小时
  register-free-time: 90   #系统赠送时间
  register-company-max-num: 100
  register-childAccount-max-num: 10
  Aliyun:    # 阿里云
    PROJECT_NAME: 8小时协同办公 #8小时人事管家
    REGION_ID: cn-shenzhen
    ACCESSKEY_ID: LTAI4FuaShJWQ1dggsFWG5CC
    SECRET: EJ6qToT4T4u0B5Rb6qrta9WkyGHvGR
    endpoint: http://oss-cn-shenzhen.aliyuncs.com
    bucketName: 8time-v2
    bucketName_pri: 8time-v2-private
    project_package: 8timer2.0/
    expirationTime: 3153600000000L
    expirationTime_pri: 600000L
  esign: # e签宝
     callbackUrl: 'https://client.8timer.cn/callback/esign/dev'
     redirectUrl: 'http://client.8timer.cn/#/ElecCon/index'
   # host: https://openapi.esign.cn
   # PROJECT_ID: 4438775940
   # PROJECT_SECRET: 7b100813cca2746081c57837855ac5af
  remind:   #合同提醒时间 默认小于等于1天会提醒+三个配置项
    one: 3
    two: 7
    three: 30
  init-password: 123456
  
  # 创建企业默认添加讯息
  qyxx:
     title: '欢迎来到8小时'
     cover: 'https://8time-v2.oss-cn-shenzhen.aliyuncs.com/8timer2.0/common/qyxx/welcome/%E6%AC%A2%E8%BF%8E%E5%9B%BE.png'
     summary: '<h1>欢迎来到8小时！可先前往组织管理-组织架构添加公司架构及岗位，再前往员工管理-员工名册添加企业员工。</h1>'
     author: 'System'
  
  # 客户管理导入服务器保存路径
  crm-excel:
     realPath: '/data/crm-excel/'

#导出zip临时地址
zip:
  path: '/data/crm-zip/'

#sftp 配置
sftp:
  client:
    protocol: 'sftp'
    host: '8.134.55.197'
    port: '22'
    username: 'root'
    password: 'Huayi98765432Huaqiao@*'
    root: '/data'
    sessionStrictHostKeyChecking: 'no'
    sessionConnectTimeout: '1500'
    channelConnectedTimeout: '1500'
    serverUrl: 'https://oa-img.jidahuayi.com'
    #serverUrl: 'http://8.134.55.197:8080'
    targetPath: '/disk'
    reservedName: false