From 08db4a5f53e17f3224e4f0caa66f1b76e3971aaf Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 04 八月 2021 19:03:25 +0800
Subject: [PATCH] update 更改所有业务excel导出

---
 ruoyi-admin/src/main/resources/application-dev.yml |  256 ++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 181 insertions(+), 75 deletions(-)

diff --git a/ruoyi-admin/src/main/resources/application-dev.yml b/ruoyi-admin/src/main/resources/application-dev.yml
index 37d4e89..6491c85 100644
--- a/ruoyi-admin/src/main/resources/application-dev.yml
+++ b/ruoyi-admin/src/main/resources/application-dev.yml
@@ -1,77 +1,183 @@
 # 鏁版嵁婧愰厤缃�
 spring:
-    datasource:
-        type: com.alibaba.druid.pool.DruidDataSource
-        driverClassName: com.mysql.cj.jdbc.Driver
-        druid:
-            # 涓诲簱鏁版嵁婧�
-            master:
-                url: jdbc:mysql://192.168.0.222:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true
-                username: root
-                password: root
-            # 浠庡簱鏁版嵁婧�
-            slave:
-                # 浠庢暟鎹簮寮�鍏�/榛樿鍏抽棴
-                enabled: false
-                url: 
-                username: 
-                password: 
-            # 鍒濆杩炴帴鏁�
-            initialSize: 5
-            # 鏈�灏忚繛鎺ユ睜鏁伴噺
-            minIdle: 10
-            # 鏈�澶ц繛鎺ユ睜鏁伴噺
-            maxActive: 20
-            # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂�
-            maxWait: 60000
-            # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣
-            timeBetweenEvictionRunsMillis: 60000
-            # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
-            minEvictableIdleTimeMillis: 300000
-            # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
-            maxEvictableIdleTimeMillis: 900000
-            # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁�
-            validationQuery: SELECT 1 FROM DUAL
-            testWhileIdle: true
-            testOnBorrow: false
-            testOnReturn: false
-            webStatFilter: 
-                enabled: true
-            statViewServlet:
-                enabled: true
-                # 璁剧疆鐧藉悕鍗曪紝涓嶅~鍒欏厑璁告墍鏈夎闂�
-                allow:
-                url-pattern: /druid/*
-                # 鎺у埗鍙扮鐞嗙敤鎴峰悕鍜屽瘑鐮�
-                login-username: 
-                login-password: 
-            filter:
-                stat:
-                    enabled: true
-                    # 鎱QL璁板綍
-                    log-slow-sql: true
-                    slow-sql-millis: 1000
-                    merge-sql: true
-                wall:
-                    config:
-                        multi-statement-allow: true
-    # redis 閰嶇疆
-    redis:
-        # 鍦板潃
-        host: 192.168.0.222
-        # 绔彛锛岄粯璁や负6379
-        port: 6379
-        # 瀵嗙爜
-        password:
-        # 杩炴帴瓒呮椂鏃堕棿
-        timeout: 10s
-        lettuce:
-            pool:
-                # 杩炴帴姹犱腑鐨勬渶灏忕┖闂茶繛鎺�
-                min-idle: 0
-                # 杩炴帴姹犱腑鐨勬渶澶х┖闂茶繛鎺�
-                max-idle: 8
-                # 杩炴帴姹犵殑鏈�澶ф暟鎹簱杩炴帴鏁�
-                max-active: 8
-                # #杩炴帴姹犳渶澶ч樆濉炵瓑寰呮椂闂达紙浣跨敤璐熷�艰〃绀烘病鏈夐檺鍒讹級
-                max-wait: -1ms
\ No newline at end of file
+  datasource:
+    type: com.alibaba.druid.pool.DruidDataSource
+    # 鍔ㄦ�佹暟鎹簮鏂囨。 https://www.kancloud.cn/tracy5546/dynamic-datasource/content
+    dynamic:
+      #璁剧疆榛樿鐨勬暟鎹簮鎴栬�呮暟鎹簮缁�,榛樿鍊煎嵆涓� master
+      primary: master
+      datasource:
+        # 涓诲簱鏁版嵁婧�
+        master:
+          driverClassName: com.mysql.cj.jdbc.Driver
+          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true
+          username: root
+          password: root
+        # 浠庡簱鏁版嵁婧�
+        slave:
+          lazy: true
+          driverClassName: com.mysql.cj.jdbc.Driver
+          url:
+          username:
+          password:
+      druid:
+        # 鍒濆杩炴帴鏁�
+        initialSize: 5
+        # 鏈�灏忚繛鎺ユ睜鏁伴噺
+        minIdle: 10
+        # 鏈�澶ц繛鎺ユ睜鏁伴噺
+        maxActive: 20
+        # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂�
+        maxWait: 60000
+        # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣
+        timeBetweenEvictionRunsMillis: 60000
+        # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
+        minEvictableIdleTimeMillis: 300000
+        # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
+        maxEvictableIdleTimeMillis: 900000
+        # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁�
+        validationQuery: SELECT 1 FROM DUAL
+        testWhileIdle: true
+        testOnBorrow: false
+        testOnReturn: false
+        # 娉ㄦ剰杩欎釜鍊煎拰druid鍘熺敓涓嶄竴鑷达紝榛樿鍚姩浜唖tat
+        filters: stat
+
+--- # druid 閰嶇疆
+spring:
+  datasource:
+    druid:
+      webStatFilter:
+        enabled: true
+      statViewServlet:
+        enabled: true
+        # 璁剧疆鐧藉悕鍗曪紝涓嶅~鍒欏厑璁告墍鏈夎闂�
+        allow:
+        url-pattern: /druid/*
+        # 鎺у埗鍙扮鐞嗙敤鎴峰悕鍜屽瘑鐮�
+        login-username: ruoyi
+        login-password: 123456
+      filter:
+        stat:
+          enabled: true
+          # 鎱QL璁板綍
+          log-slow-sql: true
+          slow-sql-millis: 1000
+          merge-sql: true
+        wall:
+          config:
+            multi-statement-allow: true
+
+--- # redis 閰嶇疆
+spring:
+  redis:
+    # 鍦板潃
+    host: localhost
+    # 绔彛锛岄粯璁や负6379
+    port: 6379
+    # 鏁版嵁搴撶储寮�
+    database: 0
+    # 瀵嗙爜
+    password:
+    # 杩炴帴瓒呮椂鏃堕棿
+    timeout: 10s
+    # 鏄惁寮�鍚痵sl
+    ssl: false
+
+redisson:
+  # 绾跨▼姹犳暟閲�
+  threads: 16
+  # Netty绾跨▼姹犳暟閲�
+  nettyThreads: 32
+  # 浼犺緭妯″紡
+  transportMode: "NIO"
+  # 鍗曡妭鐐归厤缃�
+  singleServerConfig:
+    # 瀹㈡埛绔悕绉�
+    clientName: ${ruoyi.name}
+    # 鏈�灏忕┖闂茶繛鎺ユ暟
+    connectionMinimumIdleSize: 32
+    # 杩炴帴姹犲ぇ灏�
+    connectionPoolSize: 64
+    # 杩炴帴绌洪棽瓒呮椂锛屽崟浣嶏細姣
+    idleConnectionTimeout: 10000
+    # 鍛戒护绛夊緟瓒呮椂锛屽崟浣嶏細姣
+    timeout: 3000
+    # 濡傛灉灏濊瘯鍦ㄦ闄愬埗涔嬪唴鍙戦�佹垚鍔燂紝鍒欏紑濮嬪惎鐢� timeout 璁℃椂銆�
+    retryAttempts: 3
+    # 鍛戒护閲嶈瘯鍙戦�佹椂闂撮棿闅旓紝鍗曚綅锛氭绉�
+    retryInterval: 1500
+    # 鍙戝竷鍜岃闃呰繛鎺ョ殑鏈�灏忕┖闂茶繛鎺ユ暟
+    subscriptionConnectionMinimumIdleSize: 1
+    # 鍙戝竷鍜岃闃呰繛鎺ユ睜澶у皬
+    subscriptionConnectionPoolSize: 50
+    # 鍗曚釜杩炴帴鏈�澶ц闃呮暟閲�
+    subscriptionsPerConnection: 5
+    # DNS鐩戞祴鏃堕棿闂撮殧锛屽崟浣嶏細姣
+    dnsMonitoringInterval: 5000
+
+--- # 鐩戞帶閰嶇疆
+spring:
+  boot:
+    admin:
+      # Spring Boot Admin Client 瀹㈡埛绔殑鐩稿叧閰嶇疆
+      client:
+        # 璁剧疆 Spring Boot Admin Server 鍦板潃
+        url: http://localhost:9090/admin
+        instance:
+          prefer-ip: true # 娉ㄥ唽瀹炰緥鏃讹紝浼樺厛浣跨敤 IP
+        username: ruoyi
+        password: 123456
+
+# Actuator 鐩戞帶绔偣鐨勯厤缃」
+management:
+  endpoints:
+    web:
+      # Actuator 鎻愪緵鐨� API 鎺ュ彛鐨勬牴鐩綍銆傞粯璁や负 /actuator
+      base-path: /actuator
+      exposure:
+        # 闇�瑕佸紑鏀剧殑绔偣銆傞粯璁ゅ�煎彧鎵撳紑 health 鍜� info 涓や釜绔偣銆傞�氳繃璁剧疆 * 锛屽彲浠ュ紑鏀炬墍鏈夌鐐广��
+        # 鐢熶骇鐜涓嶅缓璁斁寮�鎵�鏈� 鏍规嵁椤圭洰闇�姹傛斁寮�鍗冲彲
+        include: '*'
+  endpoint:
+    logfile:
+      external-file: ./logs/sys-console.log
+
+--- # OSS 浜戝瓨鍌�(鐣岄潰 <鍙傛暟璁剧疆> 鍙垏鎹�)
+cloud-storage:
+  # minio閰嶇疆
+  minio:
+    endpoint: http://localhost:9000
+    accessKey: ruoyi
+    secretKey: ruoyi123
+    bucketName: ruoyi
+  # 涓冪墰浜戦厤缃�
+  qiniu:
+    domain: http://XXX.XXXX.com
+    prefix:
+    accessKey: XXXXXXXXXXXXXXX
+    secretKey: XXXXXXXXXXXXXXX
+    bucketName: ruoyi
+    isHttps: false
+    # z0 鍗庝笢  z1 鍗庡寳  z2 鍗庡崡  na0 鍖楃編  as0 涓滃崡浜�
+    # 涓嶅~涓鸿嚜鍔ㄨ幏鍙�(鎬ц兘浣� 鏄撳嚭闂)
+    region: z0
+  # 闃块噷浜戦厤缃�
+  aliyun:
+    endpoint: http://oss-cn-beijing.aliyuncs.com
+    prefix:
+    accessKeyId: XXXXXXXXXXXXXXX
+    accessKeySecret: XXXXXXXXXXXXXXX
+    bucketName: ruoyi
+  # 鑵捐浜戦厤缃�
+  qcloud:
+    endpoint: http://cos.ap-beijing.myqcloud.com
+    prefix:
+    secretId: XXXXXXXXXXXXXXX
+    secretKey: XXXXXXXXXXXXXXX
+    # 鑵捐浜慴ucket鍚嶈鍒� 鏍煎紡涓� BucketName-APPID 姝ゅ濉啓鐨勫瓨鍌ㄦ《鍚嶇О蹇呴』涓烘鏍煎紡
+    bucketName: ruoyi-1250000000
+    isHttps: false
+    # 鍦板煙鍚嶅弬鑰冨畼鏂规枃妗�
+    # https://cloud.tencent.com/document/product/436/6224
+    region: ap-beijing

--
Gitblit v1.9.3