已添加4个文件
已重命名2个文件
已修改20个文件
| | |
| | | FROM mysql:8.0.19 |
| | | |
| | | MAINTAINER jeecgos@163.com |
| | | MAINTAINER bsw |
| | | |
| | | ENV TZ=Asia/Shanghai |
| | | |
| | | RUN ln -sf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone |
| | | |
| | | COPY ./tables_nacos.sql /docker-entrypoint-initdb.d |
| | | COPY ./herb.sql /docker-entrypoint-initdb.d |
| | | |
| | | COPY ./jeecgboot-mysql-5.7.sql /docker-entrypoint-initdb.d |
| | | COPY ./nacos.sql /docker-entrypoint-initdb.d |
| | | |
| | | COPY ./tables_xxl_job.sql /docker-entrypoint-initdb.d |
| | | #COPY origin/jeecgboot-mysql-5.7.sql /docker-entrypoint-initdb.d |
| | | |
| | | #COPY origin/tables_xxl_job.sql /docker-entrypoint-initdb.d |
¶Ô±ÈÐÂÎļþ |
| | |
| | | CREATE database if NOT EXISTS `nacos` default character set utf8mb4 collate utf8mb4_general_ci; |
| | | use `nacos`; |
| | | |
| | | /* |
| | | Navicat Premium Data Transfer |
| | | |
| | | Source Server : local-mysql |
| | | Source Server Type : MySQL |
| | | Source Server Version : 80029 |
| | | Source Host : localhost:3306 |
| | | Source Schema : nacos2 |
| | | |
| | | Target Server Type : MySQL |
| | | Target Server Version : 80029 |
| | | File Encoding : 65001 |
| | | |
| | | Date: 13/03/2023 10:46:26 |
| | | */ |
| | | |
| | | SET NAMES utf8mb4; |
| | | SET FOREIGN_KEY_CHECKS = 0; |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for config_info |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `config_info`; |
| | | CREATE TABLE `config_info` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', |
| | | `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', |
| | | `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'å建æ¶é´', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'ä¿®æ¹æ¶é´', |
| | | `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', |
| | | `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', |
| | | `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'ç§æ·å段', |
| | | `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL, |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of config_info |
| | | -- ---------------------------- |
| | | INSERT INTO `config_info` VALUES (1, 'jeecg-dev.yaml', 'DEFAULT_GROUP', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '18d9b011672febc0674351b137ec5904', '2021-03-03 13:01:11', '2023-03-07 03:09:43', '', '0:0:0:0:0:0:0:1', '', '', '', '', '', 'yaml', ''); |
| | | INSERT INTO `config_info` VALUES (2, 'jeecg.yaml', 'DEFAULT_GROUP', 'server:\n tomcat:\n max-swallow-size: -1\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', '2117a96ba08e8fd0f66825e87416af27', '2021-03-03 13:01:42', '2022-08-05 13:12:21', 'nacos', '0:0:0:0:0:0:0:1', '', '', '', '', '', 'yaml', ''); |
| | | INSERT INTO `config_info` VALUES (3, 'jeecg-gateway-router.json', 'DEFAULT_GROUP', '[{\n \"id\": \"jeecg-system\",\n \"order\": 0,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/sys/**\",\n \"_genkey_1\": \"/jmreport/**\",\n \"_genkey_3\": \"/online/**\",\n \"_genkey_4\": \"/generic/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo\",\n \"order\": 1,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/mock/**\",\n \"_genkey_1\": \"/test/**\",\n \"_genkey_2\": \"/bigscreen/template1/**\",\n \"_genkey_3\": \"/bigscreen/template2/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb://jeecg-demo\"\n}, {\n \"id\": \"jeecg-system-websocket\",\n \"order\": 2,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/websocket/**\",\n \"_genkey_1\": \"/newsWebsocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-system\"\n}, {\n \"id\": \"jeecg-demo-websocket\",\n \"order\": 3,\n \"predicates\": [{\n \"name\": \"Path\",\n \"args\": {\n \"_genkey_0\": \"/vxeSocket/**\"\n }\n }],\n \"filters\": [],\n \"uri\": \"lb:ws://jeecg-demo\"\n}]', 'be6548051d99309d7fa5ac4398404201', '2021-03-03 13:02:14', '2022-02-23 11:49:01', NULL, '0:0:0:0:0:0:0:1', '', '', '', '', '', 'json', ''); |
| | | INSERT INTO `config_info` VALUES (20, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n group: DEFAULT_GROUP\n data-id: jeecg-gateway-router\nspring:\n redis:\n database: 0\n host: 192.168.21.70\n port: 6379\n password:', '946f5729cef5a306694e3cf6374f96ce', '2022-08-04 16:36:11', '2023-03-08 10:47:44', NULL, '127.0.0.1', '', '', '', '', '', 'yaml', ''); |
| | | INSERT INTO `config_info` VALUES (43, 'ichd-dev.yaml', 'DEFAULT_GROUP', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/jeecg-boot2?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: 127.0.0.1\n password:\n port: 6379\n rabbitmq:\n host: 127.0.0.1\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys,/sys/api/*,\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: 127.0.0.1:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : debug\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '4954b61dcbd7c16da82b50a3c757cf77', '2023-03-07 02:17:16', '2023-03-09 10:43:57', '', '0:0:0:0:0:0:0:1', '', '', '', '', '', 'yaml', ''); |
| | | INSERT INTO `config_info` VALUES (44, 'ichd.yaml', 'DEFAULT_GROUP', 'server:\n tomcat:\n max-swallow-size: -1\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', '2117a96ba08e8fd0f66825e87416af27', '2023-03-07 02:17:16', '2023-03-07 02:17:16', NULL, '0:0:0:0:0:0:0:1', '', '', '', NULL, NULL, 'yaml', NULL); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for config_info_aggr |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `config_info_aggr`; |
| | | CREATE TABLE `config_info_aggr` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', |
| | | `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', |
| | | `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id', |
| | | `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'å
容', |
| | | `gmt_modified` datetime NOT NULL COMMENT 'ä¿®æ¹æ¶é´', |
| | | `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'ç§æ·å段', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `datum_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'å¢å ç§æ·å段' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of config_info_aggr |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for config_info_beta |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `config_info_beta`; |
| | | CREATE TABLE `config_info_beta` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', |
| | | `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', |
| | | `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', |
| | | `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', |
| | | `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps', |
| | | `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'å建æ¶é´', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'ä¿®æ¹æ¶é´', |
| | | `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', |
| | | `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'ç§æ·å段', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of config_info_beta |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for config_info_tag |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `config_info_tag`; |
| | | CREATE TABLE `config_info_tag` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', |
| | | `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', |
| | | `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id', |
| | | `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', |
| | | `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content', |
| | | `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5', |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'å建æ¶é´', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'ä¿®æ¹æ¶é´', |
| | | `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user', |
| | | `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id` ASC, `group_id` ASC, `tenant_id` ASC, `tag_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of config_info_tag |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for config_tags_relation |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `config_tags_relation`; |
| | | CREATE TABLE `config_tags_relation` ( |
| | | `id` bigint NOT NULL COMMENT 'id', |
| | | `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name', |
| | | `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type', |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id', |
| | | `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id', |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', |
| | | `nid` bigint NOT NULL AUTO_INCREMENT, |
| | | PRIMARY KEY (`nid`) USING BTREE, |
| | | UNIQUE INDEX `uk_configtagrelation_configidtag`(`id` ASC, `tag_name` ASC, `tag_type` ASC) USING BTREE, |
| | | INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of config_tags_relation |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for group_capacity |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `group_capacity`; |
| | | CREATE TABLE `group_capacity` ( |
| | | `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主é®ID', |
| | | `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group IDï¼ç©ºå符表示æ´ä¸ªé群', |
| | | `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'é
é¢ï¼0表示使ç¨é»è®¤å¼', |
| | | `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使ç¨é', |
| | | `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'å个é
置大å°ä¸éï¼åä½ä¸ºåèï¼0表示使ç¨é»è®¤å¼', |
| | | `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'èååé
ç½®æå¤§ä¸ªæ°ï¼ï¼0表示使ç¨é»è®¤å¼', |
| | | `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'å个èåæ°æ®çåé
置大å°ä¸éï¼åä½ä¸ºåèï¼0表示使ç¨é»è®¤å¼', |
| | | `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'æå¤§åæ´å岿°é', |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'å建æ¶é´', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'ä¿®æ¹æ¶é´', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_group_id`(`group_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'é群ãåGroup容éä¿¡æ¯è¡¨' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of group_capacity |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for his_config_info |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `his_config_info`; |
| | | CREATE TABLE `his_config_info` ( |
| | | `id` bigint UNSIGNED NOT NULL, |
| | | `nid` bigint UNSIGNED NOT NULL AUTO_INCREMENT, |
| | | `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, |
| | | `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, |
| | | `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name', |
| | | `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, |
| | | `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00', |
| | | `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL, |
| | | `src_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'ç§æ·å段', |
| | | PRIMARY KEY (`nid`) USING BTREE, |
| | | INDEX `idx_gmt_create`(`gmt_create` ASC) USING BTREE, |
| | | INDEX `idx_gmt_modified`(`gmt_modified` ASC) USING BTREE, |
| | | INDEX `idx_did`(`data_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'å¤ç§æ·æ¹é ' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of his_config_info |
| | | -- ---------------------------- |
| | | INSERT INTO `his_config_info` VALUES (0, 91, 'ichd-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', 'edb0e79d570edf341755caf3853f11e4', '2010-05-05 00:00:00', '2023-03-07 02:17:16', NULL, '0:0:0:0:0:0:0:1', 'I', ''); |
| | | INSERT INTO `his_config_info` VALUES (0, 92, 'ichd.yaml', 'DEFAULT_GROUP', '', 'server:\n tomcat:\n max-swallow-size: -1\n error:\n include-exception: true\n include-stacktrace: ALWAYS\n include-message: ALWAYS\n compression:\n enabled: true\n min-response-size: 1024\n mime-types: application/javascript,application/json,application/xml,text/html,text/xml,text/plain,text/css,image/*\nmanagement:\n health:\n mail:\n enabled: false\n endpoints:\n web:\n exposure:\n include: \"*\"\n health:\n sensitive: true\n endpoint:\n health:\n show-details: ALWAYS\nspring:\n servlet:\n multipart:\n max-file-size: 10MB\n max-request-size: 10MB\n mail:\n host: smtp.163.com\n username: jeecgos@163.com\n password: ??\n properties:\n mail:\n smtp:\n auth: true\n starttls:\n enable: true\n required: true\n quartz:\n job-store-type: jdbc\n initialize-schema: embedded\n auto-startup: false\n startup-delay: 1s\n overwrite-existing-jobs: true\n properties:\n org:\n quartz:\n scheduler:\n instanceName: MyScheduler\n instanceId: AUTO\n jobStore:\n class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n tablePrefix: QRTZ_\n isClustered: true\n misfireThreshold: 12000\n clusterCheckinInterval: 15000\n threadPool:\n class: org.quartz.simpl.SimpleThreadPool\n threadCount: 10\n threadPriority: 5\n threadsInheritContextClassLoaderOfInitializingThread: true\n jackson:\n date-format: yyyy-MM-dd HH:mm:ss\n time-zone: GMT+8\n aop:\n proxy-target-class: true\n activiti:\n check-process-definitions: false\n async-executor-activate: false\n job-executor-activate: false\n jpa:\n open-in-view: false\n freemarker:\n suffix: .ftl\n content-type: text/html\n charset: UTF-8\n cache: false\n prefer-file-system-access: false\n template-loader-path:\n - classpath:/templates\n mvc:\n static-path-pattern: /**\n pathmatch:\n matching-strategy: ant_path_matcher\n resource:\n static-locations: classpath:/static/,classpath:/public/\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\nmybatis-plus:\n mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml\n global-config:\n banner: false\n db-config:\n id-type: ASSIGN_ID\n table-underline: true\n configuration:\n call-setters-on-nulls: true', '2117a96ba08e8fd0f66825e87416af27', '2010-05-05 00:00:00', '2023-03-07 02:17:16', NULL, '0:0:0:0:0:0:0:1', 'I', ''); |
| | | INSERT INTO `his_config_info` VALUES (43, 93, 'ichd-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', 'edb0e79d570edf341755caf3853f11e4', '2010-05-05 00:00:00', '2023-03-07 02:18:46', '', '0:0:0:0:0:0:0:1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (1, 94, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', 'edb0e79d570edf341755caf3853f11e4', '2010-05-05 00:00:00', '2023-03-07 02:54:24', '', '0:0:0:0:0:0:0:1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (1, 95, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/jeecg-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '18d9b011672febc0674351b137ec5904', '2010-05-05 00:00:00', '2023-03-07 03:04:16', '', '0:0:0:0:0:0:0:1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (1, 96, 'jeecg-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://jeecg-boot-mysql:3306/lb-boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: jeecg-boot-redis\n password:\n port: 6379\n rabbitmq:\n host: jeecg-boot-rabbitmq\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: jeecg-boot-redis:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '8aba7f32018276099ba03d946948ae1c', '2010-05-05 00:00:00', '2023-03-07 03:09:43', '', '0:0:0:0:0:0:0:1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (20, 97, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n group: DEFAULT_GROUP\n data-id: jeecg-gateway-router\nspring:\n redis:\n database: 0\n host: jeecg-boot-redis\n port: 6379\n password:', '0fc619d2d5e304f18bc4ea8be99f68a4', '2010-05-05 00:00:00', '2023-03-08 10:47:24', NULL, '127.0.0.1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (20, 98, 'jeecg-gateway-dev.yaml', 'DEFAULT_GROUP', '', 'jeecg:\n route:\n config:\n #type:database nacos yml\n data-type: database\n group: DEFAULT_GROUP\n data-id: jeecg-gateway-router\nspring:\n redis:\n database: 0\n host: 192.168.21.49\n port: 6379\n password:', '5fb70bb748842460af7cac0c18cf3512', '2010-05-05 00:00:00', '2023-03-08 10:47:44', NULL, '127.0.0.1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (43, 99, 'ichd-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/jeecg-boot2?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: 127.0.0.1\n password:\n port: 6379\n rabbitmq:\n host: 127.0.0.1\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: 127.0.0.1:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '97761bb293beef1af19e5723e7410826', '2010-05-05 00:00:00', '2023-03-08 11:04:11', NULL, '127.0.0.1', 'U', ''); |
| | | INSERT INTO `his_config_info` VALUES (43, 100, 'ichd-dev.yaml', 'DEFAULT_GROUP', '', 'spring:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n allow:\n web-stat-filter:\n enabled: true\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,wall,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n master:\n url: jdbc:mysql://127.0.0.1:3306/jeecg-boot2?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai\n username: root\n password: 123456\n driver-class-name: com.mysql.cj.jdbc.Driver\n redis:\n database: 0\n host: 127.0.0.1\n password:\n port: 6379\n rabbitmq:\n host: 127.0.0.1\n username: guest\n password: guest\n port: 5672\n publisher-confirms: true\n publisher-returns: true\n virtual-host: /\n listener:\n simple:\n acknowledge-mode: manual\n concurrency: 1\n max-concurrency: 1\n retry:\n enabled: true\nminidao:\n base-package: org.jeecg.modules.jmreport.*,org.jeecg.modules.drag.*\njeecg:\n signatureSecret: dd05f1c54d63749eda95f9fa6d49v442a\n signUrls: /sys/dict/getDictItems/*,/sys/dict/loadDict/*,/sys/dict/loadDictOrderByValue/*,/sys/dict/loadDictItem/*,/sys/dict/loadTreeData,/sys/api/queryTableDictItemsByCode,/sys/api/queryFilterTableDictInfo,/sys/api/queryTableDictByKeys,/sys/api/translateDictFromTable,/sys/api/translateDictFromTableByKeys,/sys/api/*,\n uploadType: local\n domainUrl:\n pc: http://localhost:3100\n app: http://localhost:8051\n path:\n upload: /opt/upFiles\n webapp: /opt/webapp\n shiro:\n excludeUrls: /test/jeecgDemo/demo3,/test/jeecgDemo/redisDemo/**,/category/**,/visual/**,/map/**,/jmreport/bigscreen2/**\n oss:\n endpoint: oss-cn-beijing.aliyuncs.com\n accessKey: ??\n secretKey: ??\n bucketName: jeecgdev\n staticDomain: ??\n elasticsearch:\n cluster-name: jeecg-ES\n cluster-nodes: jeecg-boot-es:9200\n check-enabled: false\n file-view-domain: 127.0.0.1:8012\n minio:\n minio_url: http://minio.jeecg.com\n minio_name: ??\n minio_pass: ??\n bucketName: otatest\n jmreport:\n mode: dev\n is_verify_token: false\n verify_methods: remove,delete,save,add,update\n wps:\n domain: https://wwo.wps.cn/office/\n appid: ??\n appsecret: ??\n xxljob:\n enabled: false\n adminAddresses: http://jeecg-boot-xxljob:9080/xxl-job-admin\n appname: ${spring.application.name}\n accessToken: \'\'\n logPath: logs/jeecg/job/jobhandler/\n logRetentionDays: 30\n redisson:\n address: 127.0.0.1:6379\n password:\n type: STANDALONE\n enabled: true\nlogging:\n level:\n org.jeecg.modules.system.mapper : info\ncas:\n prefixUrl: http://localhost:8888/cas\nknife4j:\n production: false\n basic:\n enable: false\n username: jeecg\n password: jeecg1314\njustauth:\n enabled: true\n type:\n GITHUB:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/github/callback\n WECHAT_ENTERPRISE:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/wechat_enterprise/callback\n agent-id: ??\n DINGTALK:\n client-id: ??\n client-secret: ??\n redirect-uri: http://sso.test.com:8080/jeecg-boot/thirdLogin/dingtalk/callback\n cache:\n type: default\n prefix: \'demo::\'\n timeout: 1h\nthird-app:\n enabled: false\n type:\n WECHAT_ENTERPRISE:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??\n DINGTALK:\n enabled: false\n client-id: ??\n client-secret: ??\n agent-id: ??', '0fc50d530098cac769e562439d8af9b4', '2010-05-05 00:00:00', '2023-03-09 10:43:57', '', '0:0:0:0:0:0:0:1', 'U', ''); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for permissions |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `permissions`; |
| | | CREATE TABLE `permissions` ( |
| | | `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `resource` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | UNIQUE INDEX `uk_role_permission`(`role` ASC, `resource` ASC, `action` ASC) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of permissions |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for roles |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `roles`; |
| | | CREATE TABLE `roles` ( |
| | | `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | UNIQUE INDEX `uk_username_role`(`username` ASC, `role` ASC) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of roles |
| | | -- ---------------------------- |
| | | INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN'); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for tenant_capacity |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `tenant_capacity`; |
| | | CREATE TABLE `tenant_capacity` ( |
| | | `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主é®ID', |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID', |
| | | `quota` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'é
é¢ï¼0表示使ç¨é»è®¤å¼', |
| | | `usage` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '使ç¨é', |
| | | `max_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'å个é
置大å°ä¸éï¼åä½ä¸ºåèï¼0表示使ç¨é»è®¤å¼', |
| | | `max_aggr_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'èååé
ç½®æå¤§ä¸ªæ°', |
| | | `max_aggr_size` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'å个èåæ°æ®çåé
置大å°ä¸éï¼åä½ä¸ºåèï¼0表示使ç¨é»è®¤å¼', |
| | | `max_history_count` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'æå¤§åæ´å岿°é', |
| | | `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'å建æ¶é´', |
| | | `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT 'ä¿®æ¹æ¶é´', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_tenant_id`(`tenant_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'ç§æ·å®¹éä¿¡æ¯è¡¨' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of tenant_capacity |
| | | -- ---------------------------- |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for tenant_info |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `tenant_info`; |
| | | CREATE TABLE `tenant_info` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', |
| | | `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp', |
| | | `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id', |
| | | `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name', |
| | | `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc', |
| | | `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source', |
| | | `gmt_create` bigint NOT NULL COMMENT 'å建æ¶é´', |
| | | `gmt_modified` bigint NOT NULL COMMENT 'ä¿®æ¹æ¶é´', |
| | | PRIMARY KEY (`id`) USING BTREE, |
| | | UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp` ASC, `tenant_id` ASC) USING BTREE, |
| | | INDEX `idx_tenant_id`(`tenant_id` ASC) USING BTREE |
| | | ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of tenant_info |
| | | -- ---------------------------- |
| | | INSERT INTO `tenant_info` VALUES (1, '1', 'ac14ab82-51f8-4f0c-aa5b-25fb8384bfb6', 'jeecg', 'jeecg æµè¯å½å空é´', 'nacos', 1653291038942, 1653291038942); |
| | | |
| | | -- ---------------------------- |
| | | -- Table structure for users |
| | | -- ---------------------------- |
| | | DROP TABLE IF EXISTS `users`; |
| | | CREATE TABLE `users` ( |
| | | `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, |
| | | `enabled` tinyint(1) NOT NULL, |
| | | PRIMARY KEY (`username`) USING BTREE |
| | | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; |
| | | |
| | | -- ---------------------------- |
| | | -- Records of users |
| | | -- ---------------------------- |
| | | INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |
| | |
| | | //æµè¯æ¨¡åæé¤ |
| | | filterChainDefinitionMap.put("/test/seata/**", "anon"); |
| | | |
| | | // å¹²ç¥è®¾å¤å®æ¶æ°æ®ä¸ä¼ |
| | | filterChainDefinitionMap.put("/dry/dryOrder/sendRealTimeData", "anon"); |
| | | |
| | | // æ·»å èªå·±çè¿æ»¤å¨å¹¶ä¸åå为jwt |
| | | Map<String, Filter> filterMap = new HashMap<String, Filter>(1); |
| | | //妿cloudServer为空 åè¯´ææ¯åä½ éè¦å 载跨åé
ç½®ãå¾®æå¡è·¨å忢ã |
| | |
| | | import lombok.experimental.Accessors; |
| | | |
| | | /** |
| | | * @Description: å¹²ç¥æ¹æ¬¡ |
| | | * @Description: å¹²ç¥å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | |
| | | @TableName("dry_order") |
| | | @Accessors(chain = true) |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @ApiModel(value="dry_order对象", description="å¹²ç¥æ¹æ¬¡") |
| | | @ApiModel(value="dry_order对象", description="å¹²ç¥å·¥å") |
| | | public class DryOrder implements Serializable { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "id") |
| | | private String id; |
| | | /**æ¹æ¬¡æ¶é´*/ |
| | | @Excel(name = "æ¹æ¬¡æ¶é´", width = 15, format = "yyyy-MM-dd") |
| | | /**工忶é´*/ |
| | | @Excel(name = "工忶é´", width = 15, format = "yyyy-MM-dd") |
| | | @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd") |
| | | @DateTimeFormat(pattern="yyyy-MM-dd") |
| | | @ApiModelProperty(value = "æ¹æ¬¡æ¶é´") |
| | | @ApiModelProperty(value = "工忶é´") |
| | | private Date orderTime; |
| | | /**æ¹æ¬¡å·*/ |
| | | @Excel(name = "æ¹æ¬¡å·", width = 15) |
| | | @ApiModelProperty(value = "æ¹æ¬¡å·") |
| | | /**å·¥åå·*/ |
| | | @Excel(name = "å·¥åå·", width = 15) |
| | | @ApiModelProperty(value = "å·¥åå·") |
| | | private String code; |
| | | /**è¯æ*/ |
| | | @Excel(name = "è¯æ", width = 15, dictTable = "dry_herb", dicText = "name", dicCode = "id") |
| | |
| | | @DateTimeFormat(pattern="yyyy-MM-dd") |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | private Date updateTime; |
| | | /**æ¹æ¬¡ç¶æ*/ |
| | | @Excel(name = "æ¹æ¬¡ç¶æ", width = 15) |
| | | @ApiModelProperty(value = "æ¹æ¬¡ç¶æ") |
| | | /**å·¥åç¶æ*/ |
| | | @Excel(name = "å·¥åç¶æ", width = 15) |
| | | @ApiModelProperty(value = "å·¥åç¶æ") |
| | | private Integer orderStatus; |
| | | /**æä½äºº*/ |
| | | @Excel(name = "æä½äºº", width = 15, dictTable = "sys_user", dicText = "realname", dicCode = "id") |
| | |
| | | import lombok.experimental.Accessors; |
| | | |
| | | /** |
| | | * @Description: æ¹æ¬¡è¿ç¨è¶å¿ |
| | | * @Description: å·¥åè¿ç¨è¶å¿ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | |
| | | @TableName("dry_order_trend") |
| | | @Accessors(chain = true) |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @ApiModel(value="dry_order_trend对象", description="æ¹æ¬¡è¿ç¨è¶å¿") |
| | | @ApiModel(value="dry_order_trend对象", description="å·¥åè¿ç¨è¶å¿") |
| | | public class DryOrderTrend implements Serializable { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | |
| | | @TableId(type = IdType.ASSIGN_ID) |
| | | @ApiModelProperty(value = "id") |
| | | private String id; |
| | | /**æ¹æ¬¡*/ |
| | | @Excel(name = "æ¹æ¬¡", width = 15) |
| | | @ApiModelProperty(value = "æ¹æ¬¡") |
| | | /**å·¥å*/ |
| | | @Excel(name = "å·¥å", width = 15) |
| | | @ApiModelProperty(value = "å·¥å") |
| | | private String orderId; |
| | | /**嫿°´ç*/ |
| | | @Excel(name = "嫿°´ç", width = 15) |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package org.jeecg.modules.dry.vo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.ToString; |
| | | import org.jeecgframework.poi.excel.annotation.Excel; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | @ToString |
| | | public class DryOrderTrendVo { |
| | | |
| | | /**id*/ |
| | | @ApiModelProperty(value = "id") |
| | | private String id; |
| | | /**å·¥å*/ |
| | | @ApiModelProperty(value = "å·¥åå·") |
| | | private String orderId; |
| | | /**嫿°´ç*/ |
| | | @ApiModelProperty(value = "嫿°´ç", example = "33") |
| | | private Double moisture; |
| | | /**温度*/ |
| | | @ApiModelProperty(value = "温度", example = "70") |
| | | private Double temp; |
| | | /**æ¶é´*/ |
| | | @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") |
| | | @ApiModelProperty(value = "æ¶é´", example = "2023-03-13 12:00:00") |
| | | private Date tim; |
| | | /**ç§æ·id*/ |
| | | @ApiModelProperty(value = "ç§æ·id", example = "1000") |
| | | private Integer tenantId; |
| | | } |
| | |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | @Data |
| | | @ToString |
| | | public class DryOrderVo { |
| | | /**id*/ |
| | | @ApiModelProperty(value = "id") |
| | | private Integer id; |
| | | /**æ¹æ¬¡æ¶é´*/ |
| | | private String id; |
| | | /**工忶é´*/ |
| | | @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") |
| | | @ApiModelProperty(value = "æ¹æ¬¡æ¶é´", example = "2023-03-01 12:11:10") |
| | | @ApiModelProperty(value = "工忶é´", example = "2023-03-01 12:11:10") |
| | | private Date orderTime; |
| | | /**æ¹æ¬¡å·*/ |
| | | @ApiModelProperty(value = "æ¹æ¬¡å·", example = "202303011211") |
| | | /**å·¥åå·*/ |
| | | @ApiModelProperty(value = "å·¥åå·", example = "202303011211") |
| | | private String code; |
| | | /**è¯æ*/ |
| | | @ApiModelProperty(value = "è¯æ", example = "1085571074") |
| | | private Integer herbId; |
| | | private String herbId; |
| | | /**åå§å«æ°´ç*/ |
| | | @ApiModelProperty(value = "åå§å«æ°´ç", example = "75.51") |
| | | private Double initial; |
| | |
| | | @ApiModelProperty(value = "é¢è®¡å©ä½æ¶é´") |
| | | private Integer remain; |
| | | /**设å¤*/ |
| | | @ApiModelProperty(value = "设å¤", example = "") |
| | | private Integer equId; |
| | | @ApiModelProperty(value = "设å¤", example = "S1001") |
| | | private String equId; |
| | | /**车é´*/ |
| | | @ApiModelProperty(value = "车é´") |
| | | private Integer shopId; |
| | | @ApiModelProperty(value = "车é´", example = "S1") |
| | | private String shopId; |
| | | /**ç§æ·id*/ |
| | | @ApiModelProperty(value = "ç§æ·id") |
| | | @ApiModelProperty(value = "ç§æ·id", example = "1000") |
| | | private Integer tenantId; |
| | | /**æ¹æ¬¡ç¶æ*/ |
| | | @ApiModelProperty(value = "æ¹æ¬¡ç¶æ") |
| | | private Integer orderStatus; |
| | | /**å·¥åç¶æ*/ |
| | | @ApiModelProperty(value = "å·¥åç¶æ") |
| | | private String orderStatus; |
| | | /**æä½äºº*/ |
| | | @Dict(dictTable = "sys_user", dicText = "realname", dicCode = "id") |
| | | |
| | | @ApiModelProperty(value = "æä½äºº") |
| | | private String operator; |
| | | |
| | | |
| | | @ApiModelProperty(value = "宿¶æç»æ°æ®") |
| | | private List<DryOrderTrendVo> DetailList; |
| | | } |
| | |
| | | import lombok.extern.slf4j.Slf4j; |
| | | |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.modules.dry.vo.DryOrderVo; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | |
| | | import org.apache.shiro.authz.annotation.RequiresPermissions; |
| | | |
| | | /** |
| | | * @Description: å¹²ç¥æ¹æ¬¡ |
| | | * @Description: å¹²ç¥å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Api(tags="å¹²ç¥æ¹æ¬¡") |
| | | @Api(tags="å¹²ç¥å·¥å") |
| | | @RestController |
| | | @RequestMapping("/dry/dryOrder") |
| | | @Slf4j |
| | |
| | | * @param req |
| | | * @return |
| | | */ |
| | | //@AutoLog(value = "å¹²ç¥æ¹æ¬¡-å页å表æ¥è¯¢") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-å页å表æ¥è¯¢", notes="å¹²ç¥æ¹æ¬¡-å页å表æ¥è¯¢") |
| | | //@AutoLog(value = "å¹²ç¥å·¥å-å页å表æ¥è¯¢") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-å页å表æ¥è¯¢", notes="å¹²ç¥å·¥å-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<IPage<DryOrder>> queryPageList(DryOrder dryOrder, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | |
| | | * @param dryOrder |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å¹²ç¥æ¹æ¬¡-æ·»å ") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-æ·»å ", notes="å¹²ç¥æ¹æ¬¡-æ·»å ") |
| | | @AutoLog(value = "å¹²ç¥å·¥å-æ·»å ") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-æ·»å ", notes="å¹²ç¥å·¥å-æ·»å ") |
| | | @RequiresPermissions("dry:dry_order:add") |
| | | @PostMapping(value = "/add") |
| | | public Result<String> add(@RequestBody DryOrder dryOrder) { |
| | |
| | | * @param dryOrder |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å¹²ç¥æ¹æ¬¡-ç¼è¾") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-ç¼è¾", notes="å¹²ç¥æ¹æ¬¡-ç¼è¾") |
| | | @AutoLog(value = "å¹²ç¥å·¥å-ç¼è¾") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-ç¼è¾", notes="å¹²ç¥å·¥å-ç¼è¾") |
| | | @RequiresPermissions("dry:dry_order:edit") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<String> edit(@RequestBody DryOrder dryOrder) { |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å¹²ç¥æ¹æ¬¡-éè¿idå é¤") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-éè¿idå é¤", notes="å¹²ç¥æ¹æ¬¡-éè¿idå é¤") |
| | | @AutoLog(value = "å¹²ç¥å·¥å-éè¿idå é¤") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-éè¿idå é¤", notes="å¹²ç¥å·¥å-éè¿idå é¤") |
| | | @RequiresPermissions("dry:dry_order:delete") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<String> delete(@RequestParam(name="id",required=true) String id) { |
| | |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "å¹²ç¥æ¹æ¬¡-æ¹éå é¤") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-æ¹éå é¤", notes="å¹²ç¥æ¹æ¬¡-æ¹éå é¤") |
| | | @AutoLog(value = "å¹²ç¥å·¥å-æ¹éå é¤") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-æ¹éå é¤", notes="å¹²ç¥å·¥å-æ¹éå é¤") |
| | | @RequiresPermissions("dry:dry_order:deleteBatch") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | //@AutoLog(value = "å¹²ç¥æ¹æ¬¡-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="å¹²ç¥æ¹æ¬¡-éè¿idæ¥è¯¢", notes="å¹²ç¥æ¹æ¬¡-éè¿idæ¥è¯¢") |
| | | //@AutoLog(value = "å¹²ç¥å·¥å-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="å¹²ç¥å·¥å-éè¿idæ¥è¯¢", notes="å¹²ç¥å·¥å-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<DryOrder> queryById(@RequestParam(name="id",required=true) String id) { |
| | | DryOrder dryOrder = dryOrderService.getById(id); |
| | |
| | | @RequiresPermissions("dry:dry_order:exportXls") |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, DryOrder dryOrder) { |
| | | return super.exportXls(request, dryOrder, DryOrder.class, "å¹²ç¥æ¹æ¬¡"); |
| | | return super.exportXls(request, dryOrder, DryOrder.class, "å¹²ç¥å·¥å"); |
| | | } |
| | | |
| | | /** |
| | |
| | | return super.importExcel(request, response, DryOrder.class); |
| | | } |
| | | |
| | | |
| | | |
| | | @ApiOperation(value="æ¥æ¶å®æ¶æ°æ®", notes="设å¤å®æ¶æ°æ®ä¸ä¼ ") |
| | | @PostMapping("/sendRealTimeData") |
| | | public void realTimeData(@RequestBody DryOrderVo orderVo) { |
| | | System.out.println("æ¥æ¶å°å®æ¶æ°æ®ï¼" + orderVo.toString()); |
| | | service.saveRealTimeData(orderVo); |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | import org.apache.shiro.authz.annotation.RequiresPermissions; |
| | | |
| | | /** |
| | | * @Description: æ¹æ¬¡è¿ç¨è¶å¿ |
| | | * @Description: å·¥åè¿ç¨è¶å¿ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Api(tags="æ¹æ¬¡è¿ç¨è¶å¿") |
| | | @Api(tags="å·¥åè¿ç¨è¶å¿") |
| | | @RestController |
| | | @RequestMapping("/dry/dryOrderTrend") |
| | | @Slf4j |
| | |
| | | * @param req |
| | | * @return |
| | | */ |
| | | //@AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-å页å表æ¥è¯¢") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-å页å表æ¥è¯¢", notes="æ¹æ¬¡è¿ç¨è¶å¿-å页å表æ¥è¯¢") |
| | | //@AutoLog(value = "å·¥åè¿ç¨è¶å¿-å页å表æ¥è¯¢") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-å页å表æ¥è¯¢", notes="å·¥åè¿ç¨è¶å¿-å页å表æ¥è¯¢") |
| | | @GetMapping(value = "/list") |
| | | public Result<IPage<DryOrderTrend>> queryPageList(DryOrderTrend dryOrderTrend, |
| | | @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | |
| | | * @param dryOrderTrend |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-æ·»å ") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-æ·»å ", notes="æ¹æ¬¡è¿ç¨è¶å¿-æ·»å ") |
| | | @AutoLog(value = "å·¥åè¿ç¨è¶å¿-æ·»å ") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-æ·»å ", notes="å·¥åè¿ç¨è¶å¿-æ·»å ") |
| | | @RequiresPermissions("dry:dry_order_trend:add") |
| | | @PostMapping(value = "/add") |
| | | public Result<String> add(@RequestBody DryOrderTrend dryOrderTrend) { |
| | |
| | | * @param dryOrderTrend |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-ç¼è¾") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-ç¼è¾", notes="æ¹æ¬¡è¿ç¨è¶å¿-ç¼è¾") |
| | | @AutoLog(value = "å·¥åè¿ç¨è¶å¿-ç¼è¾") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-ç¼è¾", notes="å·¥åè¿ç¨è¶å¿-ç¼è¾") |
| | | @RequiresPermissions("dry:dry_order_trend:edit") |
| | | @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | public Result<String> edit(@RequestBody DryOrderTrend dryOrderTrend) { |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-éè¿idå é¤") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-éè¿idå é¤", notes="æ¹æ¬¡è¿ç¨è¶å¿-éè¿idå é¤") |
| | | @AutoLog(value = "å·¥åè¿ç¨è¶å¿-éè¿idå é¤") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-éè¿idå é¤", notes="å·¥åè¿ç¨è¶å¿-éè¿idå é¤") |
| | | @RequiresPermissions("dry:dry_order_trend:delete") |
| | | @DeleteMapping(value = "/delete") |
| | | public Result<String> delete(@RequestParam(name="id",required=true) String id) { |
| | |
| | | * @param ids |
| | | * @return |
| | | */ |
| | | @AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-æ¹éå é¤") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-æ¹éå é¤", notes="æ¹æ¬¡è¿ç¨è¶å¿-æ¹éå é¤") |
| | | @AutoLog(value = "å·¥åè¿ç¨è¶å¿-æ¹éå é¤") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-æ¹éå é¤", notes="å·¥åè¿ç¨è¶å¿-æ¹éå é¤") |
| | | @RequiresPermissions("dry:dry_order_trend:deleteBatch") |
| | | @DeleteMapping(value = "/deleteBatch") |
| | | public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | //@AutoLog(value = "æ¹æ¬¡è¿ç¨è¶å¿-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="æ¹æ¬¡è¿ç¨è¶å¿-éè¿idæ¥è¯¢", notes="æ¹æ¬¡è¿ç¨è¶å¿-éè¿idæ¥è¯¢") |
| | | //@AutoLog(value = "å·¥åè¿ç¨è¶å¿-éè¿idæ¥è¯¢") |
| | | @ApiOperation(value="å·¥åè¿ç¨è¶å¿-éè¿idæ¥è¯¢", notes="å·¥åè¿ç¨è¶å¿-éè¿idæ¥è¯¢") |
| | | @GetMapping(value = "/queryById") |
| | | public Result<DryOrderTrend> queryById(@RequestParam(name="id",required=true) String id) { |
| | | DryOrderTrend dryOrderTrend = dryOrderTrendService.getById(id); |
| | |
| | | @RequiresPermissions("dry:dry_order_trend:exportXls") |
| | | @RequestMapping(value = "/exportXls") |
| | | public ModelAndView exportXls(HttpServletRequest request, DryOrderTrend dryOrderTrend) { |
| | | return super.exportXls(request, dryOrderTrend, DryOrderTrend.class, "æ¹æ¬¡è¿ç¨è¶å¿"); |
| | | return super.exportXls(request, dryOrderTrend, DryOrderTrend.class, "å·¥åè¿ç¨è¶å¿"); |
| | | } |
| | | |
| | | /** |
| | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: å¹²ç¥æ¹æ¬¡ |
| | | * @Description: å¹²ç¥å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | /** |
| | | * @Description: æ¹æ¬¡è¿ç¨è¶å¿ |
| | | * @Description: å·¥åè¿ç¨è¶å¿ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | |
| | | package org.jeecg.modules.dry.service; |
| | | |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.modules.dry.entity.DryOrder; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import org.jeecg.modules.dry.vo.DryOrderVo; |
| | | |
| | | /** |
| | | * @Description: å¹²ç¥æ¹æ¬¡ |
| | | * @Description: å¹²ç¥å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | | */ |
| | | |
| | | public interface IDryOrderService extends IService<DryOrder> { |
| | | |
| | | void saveRealTimeData(DryOrderVo orderVo); |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | |
| | | /** |
| | | * @Description: æ¹æ¬¡è¿ç¨è¶å¿ |
| | | * @Description: å·¥åè¿ç¨è¶å¿ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | |
| | | package org.jeecg.modules.dry.service.impl; |
| | | |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.jeecg.modules.dry.entity.DryOrder; |
| | | import org.jeecg.modules.dry.mapper.DryOrderMapper; |
| | | import org.jeecg.modules.dry.service.IDryOrderService; |
| | | import org.jeecg.modules.dry.vo.DryOrderVo; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: å¹²ç¥æ¹æ¬¡ |
| | | * @Description: å¹²ç¥å·¥å |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class DryOrderServiceImpl extends ServiceImpl<DryOrderMapper, DryOrder> implements IDryOrderService { |
| | | |
| | | @Override |
| | | public void saveRealTimeData(DryOrderVo orderVo) { |
| | | log.info("ä¿å宿¶æ°æ®ï¼" + orderVo.toString()); |
| | | } |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | /** |
| | | * @Description: æ¹æ¬¡è¿ç¨è¶å¿ |
| | | * @Description: å·¥åè¿ç¨è¶å¿ |
| | | * @Author: jeecg-boot |
| | | * @Date: 2023-03-08 |
| | | * @Version: V1.0 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | FROM anapsix/alpine-java:8_server-jre_unlimited |
| | | |
| | | MAINTAINER bsw |
| | | |
| | | RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime |
| | | |
| | | RUN mkdir -p /jeecg-dry-cloud |
| | | |
| | | WORKDIR /jeecg-dry-cloud |
| | | |
| | | EXPOSE 7001 |
| | | |
| | | ADD ./target/jeecg-module-dry-start.jar ./ |
| | | |
| | | CMD sleep 1;java -Dfile.encoding=utf-8 -Djava.security.egd=file:/dev/./urandom -jar jeecg-module-dry-start.jar |
| | |
| | | build: |
| | | context: ../db |
| | | environment: |
| | | MYSQL_ROOT_PASSWORD: root |
| | | MYSQL_ROOT_PASSWORD: 123456 |
| | | MYSQL_ROOT_HOST: '%' |
| | | TZ: Asia/Shanghai |
| | | restart: always |
| | |
| | | restart: on-failure |
| | | environment: |
| | | - TZ=Asia/Shanghai |
| | | |
| | | jeecg-boot-demo: |
| | | jeecg-boot-dry: |
| | | depends_on: |
| | | - jeecg-boot-nacos |
| | | build: |
| | | context: ./jeecg-demo-cloud-start |
| | | container_name: jeecg-demo-start |
| | | hostname: jeecg-boot-demo |
| | | context: ../jeecg-module-dry/jeecg-module-dry-start |
| | | container_name: jeecg-module-dry-start |
| | | hostname: jeecg-boot-dry |
| | | restart: on-failure |
| | | environment: |
| | | - TZ=Asia/Shanghai |
| | | |
| | | # jeecg-boot-demo: |
| | | # depends_on: |
| | | # - jeecg-boot-nacos |
| | | # build: |
| | | # context: ./jeecg-demo-cloud-start |
| | | # container_name: jeecg-demo-start |
| | | # hostname: jeecg-boot-demo |
| | | # restart: on-failure |
| | | # environment: |
| | | # - TZ=Asia/Shanghai |
| | | |
| | | jeecg-boot-gateway: |
| | | restart: on-failure |
| | | build: |
| | |
| | | FROM anapsix/alpine-java:8_server-jre_unlimited |
| | | |
| | | MAINTAINER jeecgos@163.com |
| | | MAINTAINER bsw |
| | | |
| | | RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime |
| | | |
| | |
| | | FROM anapsix/alpine-java:8_server-jre_unlimited |
| | | |
| | | MAINTAINER jeecgos@163.com |
| | | MAINTAINER bsw |
| | | |
| | | RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime |
| | | |
| | |
| | | password: |
| | | '0': ${MYSQL-PWD:123456} |
| | | url: |
| | | '0': jdbc:mysql://${MYSQL-HOST:127.0.0.1}:${MYSQL-PORT:3306}/${MYSQL-DB:nacos2}?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true |
| | | '0': jdbc:mysql://${MYSQL-HOST:jeecg-boot-mysql}:${MYSQL-PORT:3306}/${MYSQL-DB:nacos}?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true |
| | | user: |
| | | '0': ${MYSQL-USER:root} |
| | | management: |
| | |
| | | FROM anapsix/alpine-java:8_server-jre_unlimited |
| | | |
| | | MAINTAINER jeecgos@163.com |
| | | MAINTAINER bsw |
| | | |
| | | RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime |
| | | |
| | |
| | | <!--å½åç¯å¢--> |
| | | <profile.name>dev</profile.name> |
| | | <!--Nacosæå¡å°å--> |
| | | <config.server-addr>127.0.0.1:8848</config.server-addr> |
| | | <config.server-addr>jeecg-boot-nacos:8848</config.server-addr> |
| | | </properties> |
| | | </profile> |
| | | <!-- æµè¯ --> |