From 11ccd4dad13a0b41c916b22b9db79495b79f0aea Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 06 十二月 2024 17:49:48 +0800
Subject: [PATCH] 1

---
 docker-compose/mysql/initdb/se_cloud_20241119.sql                                     |    6 ++
 se-modules/se-system/src/main/java/com/se/system/controller/SysCtrlLogController.java |   14 +++---
 说明.txt                                                                                |    3 +
 docker-compose/mysql/initdb/se_cloud_20240629.sql                                     |    1 
 docker-compose/mysql/initdb/se_cloud_20241204.sql                                     |   58 +++++++++++++++++++++++++++++
 5 files changed, 74 insertions(+), 8 deletions(-)

diff --git a/docker-compose/mysql/initdb/se_cloud_20240629.sql b/docker-compose/mysql/initdb/se_cloud_20240629.sql
index 5aac501..797fb83 100644
--- a/docker-compose/mysql/initdb/se_cloud_20240629.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20240629.sql
@@ -288,6 +288,7 @@
 alter table sys_menu add column mark varchar(20) comment '鑿滃崟鏍囪瘑';
 update sys_menu set mark = 'sys' where menu_id < 1070;
 -- select * from sys_menu order by menu_id;
+insert into sys_menu values('1076',  '绯荤粺鎺ュ彛',       '1',   '7', 'http://localhost:8080/swagger-ui/index.html', '', '', '', 0, 0, 'C', '0', '0', 'tool:swagger:list',       'swagger',       'admin', sysdate(), '', null, '绯荤粺鎺ュ彛鑿滃崟','');
 
 
 -- ----------------------------
diff --git a/docker-compose/mysql/initdb/se_cloud_20241119.sql b/docker-compose/mysql/initdb/se_cloud_20241119.sql
index 38dc72e..3ffedee 100644
--- a/docker-compose/mysql/initdb/se_cloud_20241119.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20241119.sql
@@ -14,7 +14,7 @@
 create table sys_soft (
   soft_id           bigint(20)      not null auto_increment    comment '杞欢ID',
   name              varchar(200)    not null                   comment '鍚嶇О',
-  type              char(1)         default '0'                comment '绫诲瀷锛�0-搴旂敤杞欢锛�1-鏁版嵁搴擄紝2-涓棿浠讹紝3-鎿嶄綔绯荤粺锛�',
+  type              char(1)         default '0'                comment '绫诲瀷锛�0-搴旂敤杞欢锛�1-鏁版嵁搴擄紝2-涓棿浠讹紝3-鎿嶄綔绯荤粺锛�4-Docker瀹瑰櫒锛�',
   lic               varchar(500)                               comment '璁稿彲',
   descr             varchar(500)                               comment '鎻忚堪',
   args              varchar(8000)                              comment '鍙傛暟',
@@ -28,6 +28,10 @@
 ) engine=innodb auto_increment=1 comment = '杞欢琛�';
 select * from sys_soft order by soft_id;
 
+insert into sys_soft (name, type, args) values ('se-mysql', 4, 'se-mysql');
+insert into sys_soft (name, type, args) values ('se-redis', 4, 'se-redis');
+insert into sys_soft (name, type, args) values ('se-system', 4, 'se-system');
+insert into sys_soft (name, type, args) values ('se-wgcloud', 4, 'se-wgcloud');
 
 -- ----------------------------
 -- 02銆佺‖浠惰〃
diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
new file mode 100644
index 0000000..7f2b926
--- /dev/null
+++ b/docker-compose/mysql/initdb/se_cloud_20241204.sql
@@ -0,0 +1,58 @@
+-- DROP DATABASE IF EXISTS `se-cloud`;
+
+CREATE DATABASE IF NOT EXISTS  `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+USE `se-cloud`;
+
+-- ----------------------------
+-- 01銆佸垎绯荤粺浠诲姟鎺у埗琛�
+-- ----------------------------
+drop table if exists sys_task_ctrl;
+create table sys_task_ctrl (
+  task_id           bigint(20)      not null auto_increment    comment '浠诲姟ID',
+  prj_id            varchar(50)                                comment '浠诲姟ID',
+  prj_name          varchar(200)                               comment '浠诲姟鍚嶇О',
+  think_id          varchar(50)                                comment '鎯冲畾ID',
+  think_name        varchar(200)                               comment '鎯冲畾鍚嶇О',
+  is_save           char(1)         default 0                  comment '鏄惁淇濆瓨锛�0姝e父 1鍋滅敤锛�',
+  node              varchar(2000)                              comment '鑺傜偣',  
+  status            char(1)         default 0                  comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�',
+  create_by         varchar(64)     default ''                 comment '鍒涘缓鑰�',
+  create_time       datetime                                   comment '鍒涘缓鏃堕棿',
+  update_by         varchar(64)     default ''                 comment '鏇存柊鑰�',
+  update_time       datetime                                   comment '鏇存柊鏃堕棿',
+  remark            varchar(500)    default ''                 comment '澶囨敞',
+  primary key (task_id)
+) engine=innodb auto_increment=1 comment = '鍒嗙郴缁熶换鍔℃帶鍒惰〃';
+select * from sys_task_ctrl order by task_id;
+
+
+-- ----------------------------
+-- 02銆佺郴缁熺姸鎬佺洃鎺ц〃
+-- ----------------------------
+drop table if exists sys_status_ctrl;
+create table sys_status_ctrl (
+  status_id         bigint(20)      not null auto_increment    comment '鐘舵�両D',
+  sys_name          varchar(200)                               comment '鍚嶇О',
+  ip                varchar(50)                                comment 'IP',
+  url               varchar(4000)                              comment 'URL',
+  method            varchar(20)                                comment '璇锋眰鏂规硶',
+  order_num         int             default 0                  comment '鏄剧ず椤哄簭',
+  status            char(1)         default 0                  comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�',
+  create_by         varchar(64)     default ''                 comment '鍒涘缓鑰�',
+  create_time       datetime                                   comment '鍒涘缓鏃堕棿',
+  update_by         varchar(64)     default ''                 comment '鏇存柊鑰�',
+  update_time       datetime                                   comment '鏇存柊鏃堕棿',
+  remark            varchar(500)    default ''                 comment '澶囨敞',
+  primary key (status_id)
+) engine=innodb auto_increment=1 comment = '绯荤粺鐘舵�佺洃鎺ц〃';
+select * from sys_status_ctrl order by status_id;
+
+insert into sys_status_ctrl (sys_name, ip, url, method, order_num) values ('鍒嗙郴缁�01', '127.0.0.1', 'http://localhost:8080/system/health', 'GET', 1);
+
+
+-- ----------------------------
+
diff --git a/se-modules/se-system/src/main/java/com/se/system/controller/SysCtrlLogController.java b/se-modules/se-system/src/main/java/com/se/system/controller/SysCtrlLogController.java
index f6aca96..c64e33d 100644
--- a/se-modules/se-system/src/main/java/com/se/system/controller/SysCtrlLogController.java
+++ b/se-modules/se-system/src/main/java/com/se/system/controller/SysCtrlLogController.java
@@ -28,7 +28,7 @@
  * @date 2024-11-22
  */
 @RestController
-@RequestMapping("/log")
+@RequestMapping("/ctrlLog")
 public class SysCtrlLogController extends BaseController
 {
     @Autowired
@@ -37,7 +37,7 @@
     /**
      * 鏌ヨ鎺у埗鏃ュ織鍒楄〃
      */
-    @RequiresPermissions("system:log:list")
+    @RequiresPermissions("system:ctrlLog:list")
     @GetMapping("/list")
     public TableDataInfo list(SysCtrlLog sysCtrlLog)
     {
@@ -49,7 +49,7 @@
     /**
      * 瀵煎嚭鎺у埗鏃ュ織鍒楄〃
      */
-    @RequiresPermissions("system:log:export")
+    @RequiresPermissions("system:ctrlLog:export")
     @Log(title = "鎺у埗鏃ュ織", businessType = BusinessType.EXPORT)
     @PostMapping("/export")
     public void export(HttpServletResponse response, SysCtrlLog sysCtrlLog)
@@ -62,7 +62,7 @@
     /**
      * 鑾峰彇鎺у埗鏃ュ織璇︾粏淇℃伅
      */
-    @RequiresPermissions("system:log:query")
+    @RequiresPermissions("system:ctrlLog:query")
     @GetMapping(value = "/{logId}")
     public AjaxResult getInfo(@PathVariable("logId") Long logId)
     {
@@ -72,7 +72,7 @@
     /**
      * 鏂板鎺у埗鏃ュ織
      */
-    @RequiresPermissions("system:log:add")
+    @RequiresPermissions("system:ctrlLog:add")
     @Log(title = "鎺у埗鏃ュ織", businessType = BusinessType.INSERT)
     @PostMapping
     public AjaxResult add(@RequestBody SysCtrlLog sysCtrlLog)
@@ -83,7 +83,7 @@
     /**
      * 淇敼鎺у埗鏃ュ織
      */
-    @RequiresPermissions("system:log:edit")
+    @RequiresPermissions("system:ctrlLog:edit")
     @Log(title = "鎺у埗鏃ュ織", businessType = BusinessType.UPDATE)
     @PutMapping
     public AjaxResult edit(@RequestBody SysCtrlLog sysCtrlLog)
@@ -94,7 +94,7 @@
     /**
      * 鍒犻櫎鎺у埗鏃ュ織
      */
-    @RequiresPermissions("system:log:remove")
+    @RequiresPermissions("system:ctrlLog:remove")
     @Log(title = "鎺у埗鏃ュ織", businessType = BusinessType.DELETE)
 	@DeleteMapping("/{logIds}")
     public AjaxResult remove(@PathVariable Long[] logIds)
diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt"
index 922a5b0..8bb00c4 100644
--- "a/\350\257\264\346\230\216.txt"
+++ "b/\350\257\264\346\230\216.txt"
@@ -2,7 +2,10 @@
 1.docker杞欢鍚仠 鈫� se-mysql,se-system,se-redis,se-wgcloud
 2.鍒嗙郴缁熷畾鏃朵换鍔�  鈫� http://loclahost:8080/system/health    鈫� ConnectUtils
 3.杞欢鎺堟潈       鈫� wgcloud,se-system
+4.娉ㄥ唽椤甸潰       鈫�
 
+java 鑷畾涔夎蒋浠惰鍙�
+https://blog.csdn.net/a1374469523/article/details/138667196
 --------------------------------------------------------
 http://192.168.11.203:8090/sso/login锛宎dmin锛宎dmin123
 http://192.168.11.203:8848/nacos锛宯Acos_!9#_admIn

--
Gitblit v1.9.3