iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
@@ -200,13 +200,13 @@ `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称', `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL', `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '方法', `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方法', `param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数', `descp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述', `status` int NULL DEFAULT NULL COMMENT '状态', `creator` VARCHAR(255) COMMENT '创建人' , `creator` VARCHAR(64) COMMENT '创建人' , `create_time` DATETIME COMMENT '创建时间' , `updater` VARCHAR(255) COMMENT '修改人' , `updater` VARCHAR(64) COMMENT '修改人' , `update_time` DATETIME COMMENT '修改时间' , PRIMARY KEY (`ID`) USING BTREE, UNIQUE KEY `uk_code` (`code`) USING BTREE iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java
@@ -7,6 +7,7 @@ import com.iailab.module.data.channel.http.service.HttpApiService; import com.iailab.module.data.channel.http.vo.HttpApiPageReqVO; import com.iailab.module.data.channel.http.vo.HttpApiRespVO; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @@ -28,58 +29,44 @@ @Resource private HttpApiService httpApiService; @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("page") public CommonResult<PageResult<HttpApiRespVO>> page(@Valid HttpApiPageReqVO reqVO) { PageResult<HttpApiEntity> page = httpApiService.queryPage(reqVO); return success(BeanUtils.toBean(page, HttpApiRespVO.class)); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("list") public CommonResult<List<HttpApiEntity>> list() { List<HttpApiEntity> list = httpApiService.list(); return success(list); } /** * 根据id查询详情 * * @param id */ @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("/info/{id}") public CommonResult<HttpApiEntity> info(@PathVariable("id") String id){ HttpApiEntity info= httpApiService.info(id); return success(info); } /** * 添加API * * @param httpApiEntity */ @PostMapping("/add") public CommonResult<Boolean> add(@RequestBody HttpApiEntity httpApiEntity){ @PreAuthorize("@ss.hasPermission('data:channel-http:create')") @PostMapping("/create") public CommonResult<Boolean> create(@RequestBody HttpApiEntity httpApiEntity){ String id = UUID.randomUUID().toString(); httpApiEntity.setId(id); httpApiService.add(httpApiEntity); return success(true); } /** * 修改API * * @param httpApiEntity */ @PreAuthorize("@ss.hasPermission('data:channel-http:update')") @PutMapping("/update") public CommonResult<Boolean> update(@RequestBody HttpApiEntity httpApiEntity) { httpApiService.update(httpApiEntity); return success(true); } /** * 删除API * * @param id * */ @PreAuthorize("@ss.hasPermission('data:channel-http:delete')") @DeleteMapping("/delete") public CommonResult<Boolean> delete(@RequestParam("id") String id) { httpApiService.delete(id); iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java
@@ -7,6 +7,7 @@ import com.iailab.module.data.channel.http.service.HttpTagService; import com.iailab.module.data.channel.http.vo.HttpTagPageReqVO; import com.iailab.module.data.channel.http.vo.HttpTagRespVO; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @@ -23,31 +24,35 @@ * @createTime 2024年08月27日 */ @RestController @RequestMapping("/data/http/tag") @RequestMapping("/data/channel/http/tag") public class HttpTagController { @Resource private HttpTagService tagService; @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("page") public CommonResult<PageResult<HttpTagRespVO>> page(@Valid HttpTagPageReqVO reqVO) { PageResult<HttpTagEntity> page = tagService.queryPage(reqVO); return success(BeanUtils.toBean(page, HttpTagRespVO.class)); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("list") public CommonResult<List<HttpTagEntity>> list(){ List<HttpTagEntity> list = tagService.list(); return new CommonResult<List<HttpTagEntity>>().setData(list); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("/info/{id}") public CommonResult<HttpTagEntity> info(@PathVariable("id") String id){ HttpTagEntity info= tagService.info(id); return success(info); } @PostMapping("/add") @PreAuthorize("@ss.hasPermission('data:channel-http:create')") @PostMapping("/create") public CommonResult<Boolean> add(@RequestBody HttpTagEntity httpTagEntity){ String id = UUID.randomUUID().toString(); httpTagEntity.setId(id); @@ -55,12 +60,14 @@ return success(true); } @PreAuthorize("@ss.hasPermission('data:channel-http:update')") @PutMapping("/update") public CommonResult<Boolean> update(@RequestBody HttpTagEntity httpTagEntity) { tagService.update(httpTagEntity); return success(true); } @PreAuthorize("@ss.hasPermission('data:channel-http:delete')") @DeleteMapping("/delete") public CommonResult<Boolean> delete(@RequestParam("id") String id) { tagService.delete(id); iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTokenController.java
@@ -7,6 +7,7 @@ import com.iailab.module.data.channel.http.service.HttpTokenService; import com.iailab.module.data.channel.http.vo.HttpTokenPageReqVO; import com.iailab.module.data.channel.http.vo.HttpTokenRespVO; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @@ -22,52 +23,59 @@ * @createTime 2024年08月27日 */ @RestController @RequestMapping("/data/http/token") @RequestMapping("/data/channel/http/token") public class HttpTokenController { @Resource private HttpTokenService httpTokenService; @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("page") public CommonResult<PageResult<HttpTokenRespVO>> page(@Valid HttpTokenPageReqVO reqVO) { PageResult<HttpTokenEntity> page = httpTokenService.queryPage(reqVO); return success(BeanUtils.toBean(page, HttpTokenRespVO.class)); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("list") public CommonResult<List<HttpTokenEntity>> list(){ List<HttpTokenEntity> list = httpTokenService.list(); return new CommonResult<List<HttpTokenEntity>>().setData(list); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("/info/{id}") public CommonResult<HttpTokenEntity> info(@PathVariable("id") String id){ HttpTokenEntity info= httpTokenService.info(id); return success(info); } @PostMapping("/add") public CommonResult<Boolean> add(@RequestBody HttpTokenEntity HttpTokenEntity){ @PreAuthorize("@ss.hasPermission('data:channel-http:create')") @PostMapping("/create") public CommonResult<Boolean> create(@RequestBody HttpTokenEntity HttpTokenEntity){ String id = UUID.randomUUID().toString(); HttpTokenEntity.setId(id); httpTokenService.add(HttpTokenEntity); return success(true); } @PreAuthorize("@ss.hasPermission('data:channel-http:update')") @PutMapping("/update") public CommonResult<Boolean> update(@RequestBody HttpTokenEntity HttpTokenEntity) { httpTokenService.update(HttpTokenEntity); return success(true); } @PreAuthorize("@ss.hasPermission('data:channel-http:delete')") @DeleteMapping("/delete") public CommonResult<Boolean> delete(@RequestParam("id") String id) { httpTokenService.delete(id); return success(true); } @GetMapping("/api-id/{apiId}") public CommonResult<HttpTokenEntity> apiId(@PathVariable("apiId") String apiId) { @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("/api-id") public CommonResult<HttpTokenEntity> apiId(@RequestParam("apiId") String apiId) { HttpTokenEntity info = httpTokenService.getByApiId(apiId); return success(info); } iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/entity/HttpApiEntity.java
@@ -20,14 +20,59 @@ @Schema(description = "主键") @TableId(value = "id", type = IdType.INPUT) private String id; private String name; /** * 编码 */ private String code; /** * 名称 */ private String name; /** * URL */ private String url; /** * 请求方法 */ private String method; private String collectType; /** * 参数 */ private String param; /** * 描述 */ private String descp; /** * 状态 */ private Integer status; /** * 创建人 */ private String creator; /** * 创建时间 */ private Date createTime; /** * 修改人 */ private String updater; /** * 修改时间 */ private Date updateTime; } iailab-module-system/iailab-module-system-biz/db/增量SQL/202409.sql
对比新文件 @@ -0,0 +1,6 @@ alter table system_menu add column `app_id` int DEFAULT NULL; alter table system_menu add column `tenant_id` int DEFAULT NULL; alter table system_app add column `type` int DEFAULT NULL; alter table system_app add column `tenant_id` int DEFAULT NULL; alter table system_app add column `group_id` int DEFAULT NULL;
