From e3f95b136c8600b689bd2c569a12a41f2d4ce74e Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期五, 16 八月 2024 10:44:39 +0800
Subject: [PATCH] 动态字段表代码生成
---
ycl-server/src/main/java/com/ycl/platform/controller/DynamicColumnController.java | 81 +++++++++
ycl-server/src/main/resources/mapper/zgyw/DynamicColumnMapper.xml | 46 +++++
ycl-pojo/src/main/java/com/ycl/platform/domain/form/DynamicColumnForm.java | 50 +++++
ycl-pojo/src/main/java/com/ycl/platform/domain/query/DynamicColumnQuery.java | 17 +
ycl-server/src/main/java/com/ycl/platform/mapper/DynamicColumnMapper.java | 34 +++
ycl-server/src/main/java/com/ycl/platform/service/impl/DynamicColumnServiceImpl.java | 119 +++++++++++++
ycl-pojo/src/main/java/com/ycl/platform/domain/vo/DynamicColumnVO.java | 38 ++++
ycl-pojo/src/main/java/com/ycl/platform/domain/entity/DynamicColumn.java | 38 ++++
ycl-server/src/main/java/com/ycl/platform/service/DynamicColumnService.java | 66 +++++++
9 files changed, 489 insertions(+), 0 deletions(-)
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/DynamicColumn.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/DynamicColumn.java
new file mode 100644
index 0000000..f47c0f1
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/DynamicColumn.java
@@ -0,0 +1,38 @@
+package com.ycl.platform.domain.entity;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+
+import com.ycl.platform.base.AbsEntity;
+import lombok.Data;
+
+/**
+ * 鍔ㄦ�佸垪
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Data
+@TableName("t_dynamic_column")
+public class DynamicColumn extends AbsEntity {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableField("ref_id")
+ /** 鍏宠仈涓�鏈轰竴妗d */
+ private Integer refId;
+
+ @TableField("prop_name")
+ /** elementui table prop */
+ private String propName;
+
+ @TableField("label_value")
+ /** elementui table label */
+ private String labelValue;
+
+ @TableField("field_value")
+ /** 鍊� */
+ private String fieldValue;
+
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/form/DynamicColumnForm.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/DynamicColumnForm.java
new file mode 100644
index 0000000..79e1e5d
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/form/DynamicColumnForm.java
@@ -0,0 +1,50 @@
+package com.ycl.platform.domain.form;
+
+import com.ycl.platform.base.AbsForm;
+import com.ycl.platform.domain.entity.DynamicColumn;
+import com.ycl.system.domain.group.Add;
+import com.ycl.system.domain.group.Update;
+import jakarta.validation.constraints.NotBlank;
+import org.springframework.beans.BeanUtils;
+import javax.validation.constraints.NotNull;
+import org.springframework.lang.NonNull;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import java.util.Date;
+
+/**
+ * 鍔ㄦ�佸垪琛ㄥ崟
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Data
+@ApiModel(value = "DynamicColumn琛ㄥ崟", description = "鍔ㄦ�佸垪琛ㄥ崟")
+public class DynamicColumnForm extends AbsForm {
+
+ @NotNull(message = "鍏宠仈涓�鏈轰竴妗d涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍏宠仈涓�鏈轰竴妗d")
+ private Integer refId;
+
+ @NotBlank(message = "elementui table prop涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("elementui table prop")
+ private String propName;
+
+ @NotBlank(message = "elementui table label涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("elementui table label")
+ private String labelValue;
+
+ @NotBlank(message = "鍊间笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍊�")
+ private String fieldValue;
+
+ public static DynamicColumn getEntityByForm(@NonNull DynamicColumnForm form, DynamicColumn entity) {
+ if(entity == null) {
+ entity = new DynamicColumn();
+ }
+ BeanUtils.copyProperties(form, entity);
+ return entity;
+ }
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/DynamicColumnQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/DynamicColumnQuery.java
new file mode 100644
index 0000000..495c3ca
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/DynamicColumnQuery.java
@@ -0,0 +1,17 @@
+package com.ycl.platform.domain.query;
+
+import com.ycl.platform.base.AbsQuery;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+/**
+ * 鍔ㄦ�佸垪鏌ヨ
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Data
+@ApiModel(value = "DynamicColumn鏌ヨ", description = "鍔ㄦ�佸垪鏌ヨ")
+public class DynamicColumnQuery extends AbsQuery {
+}
+
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/DynamicColumnVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/DynamicColumnVO.java
new file mode 100644
index 0000000..0836853
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/DynamicColumnVO.java
@@ -0,0 +1,38 @@
+package com.ycl.platform.domain.vo;
+
+import com.ycl.platform.base.AbsVo;
+import com.ycl.platform.domain.entity.DynamicColumn;
+import org.springframework.lang.NonNull;
+import org.springframework.beans.BeanUtils;
+import lombok.Data;
+
+/**
+ * 鍔ㄦ�佸垪灞曠ず
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Data
+public class DynamicColumnVO extends AbsVo {
+
+ /** 鍏宠仈涓�鏈轰竴妗d */
+ private Integer refId;
+
+ /** elementui table prop */
+ private String propName;
+
+ /** elementui table label */
+ private String labelValue;
+
+ /** 鍊� */
+ private String fieldValue;
+
+ public static DynamicColumnVO getVoByEntity(@NonNull DynamicColumn entity, DynamicColumnVO vo) {
+ if(vo == null) {
+ vo = new DynamicColumnVO();
+ }
+ BeanUtils.copyProperties(entity, vo);
+ return vo;
+ }
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/DynamicColumnController.java b/ycl-server/src/main/java/com/ycl/platform/controller/DynamicColumnController.java
new file mode 100644
index 0000000..f96abd4
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/DynamicColumnController.java
@@ -0,0 +1,81 @@
+package com.ycl.platform.controller;
+
+import com.ycl.system.Result;
+import com.ycl.system.domain.group.Add;
+import com.ycl.system.domain.group.Update;
+import jakarta.validation.constraints.NotEmpty;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.security.access.prepost.PreAuthorize;
+import lombok.RequiredArgsConstructor;
+import java.util.List;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import com.ycl.platform.service.DynamicColumnService;
+import com.ycl.platform.domain.form.DynamicColumnForm;
+import com.ycl.platform.domain.query.DynamicColumnQuery;
+import org.springframework.web.bind.annotation.*;
+
+/**
+ * 鍔ㄦ�佸垪 鍓嶇鎺у埗鍣�
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Validated
+@RequiredArgsConstructor
+@Api(value = "鍔ㄦ�佸垪", tags = "鍔ㄦ�佸垪绠＄悊")
+@RestController
+@RequestMapping("/api/dynamic-column")
+public class DynamicColumnController {
+
+ private final DynamicColumnService dynamicColumnService;
+
+ @PostMapping
+ @ApiOperation(value = "娣诲姞", notes = "娣诲姞")
+ @PreAuthorize("hasAuthority('dynamicColumn:add')")
+ public Result add(@RequestBody @Validated(Add.class) DynamicColumnForm form) {
+ return dynamicColumnService.add(form);
+ }
+
+ @PutMapping
+ @ApiOperation(value = "淇敼", notes = "淇敼")
+ @PreAuthorize("hasAuthority('dynamicColumn:edit')")
+ public Result update(@RequestBody @Validated(Update.class) DynamicColumnForm form) {
+ return dynamicColumnService.update(form);
+ }
+
+ @DeleteMapping("/{id}")
+ @ApiOperation(value = "ID鍒犻櫎", notes = "ID鍒犻櫎")
+ @PreAuthorize("hasAuthority('dynamicColumn:del')")
+ public Result removeById(@PathVariable("id") String id) {
+ return dynamicColumnService.removeById(id);
+ }
+
+ @DeleteMapping("/batch")
+ @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎")
+ @PreAuthorize("hasAuthority('dynamicColumn:del:batch')")
+ public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) {
+ return dynamicColumnService.remove(ids);
+ }
+
+ @GetMapping("/page")
+ @ApiOperation(value = "鍒嗛〉", notes = "鍒嗛〉")
+ @PreAuthorize("hasAuthority('dynamicColumn:page')")
+ public Result page(DynamicColumnQuery query) {
+ return dynamicColumnService.page(query);
+ }
+
+ @GetMapping("/{id}")
+ @ApiOperation(value = "璇︽儏", notes = "璇︽儏")
+ @PreAuthorize("hasAuthority('dynamicColumn:detail')")
+ public Result detail(@PathVariable("id") Integer id) {
+ return dynamicColumnService.detail(id);
+ }
+
+ @GetMapping("/list")
+ @PreAuthorize("hasAuthority('dynamicColumn:list')")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result list() {
+ return dynamicColumnService.all();
+ }
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/DynamicColumnMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/DynamicColumnMapper.java
new file mode 100644
index 0000000..e7e3a8d
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/DynamicColumnMapper.java
@@ -0,0 +1,34 @@
+package com.ycl.platform.mapper;
+
+import com.ycl.platform.domain.entity.DynamicColumn;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ycl.platform.domain.query.DynamicColumnQuery;
+import com.ycl.platform.domain.vo.DynamicColumnVO;
+import com.ycl.platform.domain.form.DynamicColumnForm;
+import java.util.List;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * 鍔ㄦ�佸垪 Mapper 鎺ュ彛
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Mapper
+public interface DynamicColumnMapper extends BaseMapper<DynamicColumn> {
+
+ /**
+ * id鏌ユ壘鍔ㄦ�佸垪
+ * @param id
+ * @return
+ */
+ DynamicColumnVO getById(Integer id);
+
+ /**
+ * 鍒嗛〉
+ */
+ IPage getPage(IPage page, @Param("query") DynamicColumnQuery query);
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/DynamicColumnService.java b/ycl-server/src/main/java/com/ycl/platform/service/DynamicColumnService.java
new file mode 100644
index 0000000..56976d9
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/DynamicColumnService.java
@@ -0,0 +1,66 @@
+package com.ycl.platform.service;
+
+import com.ycl.platform.domain.entity.DynamicColumn;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ycl.platform.domain.form.DynamicColumnForm;
+import com.ycl.platform.domain.query.DynamicColumnQuery;
+import com.ycl.system.Result;
+
+import java.util.List;
+
+/**
+ * 鍔ㄦ�佸垪 鏈嶅姟绫�
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+public interface DynamicColumnService extends IService<DynamicColumn> {
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ Result add(DynamicColumnForm form);
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ Result update(DynamicColumnForm form);
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ Result remove(List<String> ids);
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ Result removeById(String id);
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ Result page(DynamicColumnQuery query);
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ Result detail(Integer id);
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ Result all();
+}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/DynamicColumnServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/DynamicColumnServiceImpl.java
new file mode 100644
index 0000000..14047f0
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/DynamicColumnServiceImpl.java
@@ -0,0 +1,119 @@
+package com.ycl.platform.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ycl.platform.domain.entity.DynamicColumn;
+import com.ycl.platform.mapper.DynamicColumnMapper;
+import com.ycl.platform.service.DynamicColumnService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ycl.platform.domain.form.DynamicColumnForm;
+import com.ycl.platform.domain.vo.DynamicColumnVO;
+import com.ycl.platform.domain.query.DynamicColumnQuery;
+import com.ycl.system.Result;
+import com.ycl.system.page.PageUtil;
+import org.springframework.stereotype.Service;
+import lombok.RequiredArgsConstructor;
+import org.springframework.beans.BeanUtils;
+import org.springframework.util.Assert;
+
+import java.util.List;
+import java.util.stream.Collectors;
+
+/**
+ * 鍔ㄦ�佸垪 鏈嶅姟瀹炵幇绫�
+ *
+ * @author xp
+ * @since 2024-08-16
+ */
+@Service
+@RequiredArgsConstructor
+public class DynamicColumnServiceImpl extends ServiceImpl<DynamicColumnMapper, DynamicColumn> implements DynamicColumnService {
+
+ private final DynamicColumnMapper dynamicColumnMapper;
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ @Override
+ public Result add(DynamicColumnForm form) {
+ DynamicColumn entity = DynamicColumnForm.getEntityByForm(form, null);
+ baseMapper.insert(entity);
+ return Result.ok("娣诲姞鎴愬姛");
+ }
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ @Override
+ public Result update(DynamicColumnForm form) {
+ DynamicColumn entity = baseMapper.selectById(form.getId());
+
+ // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
+ Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+ BeanUtils.copyProperties(form, entity);
+ baseMapper.updateById(entity);
+ return Result.ok("淇敼鎴愬姛");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @Override
+ public Result remove(List<String> ids) {
+ baseMapper.deleteBatchIds(ids);
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @Override
+ public Result removeById(String id) {
+ baseMapper.deleteById(id);
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ @Override
+ public Result page(DynamicColumnQuery query) {
+ IPage<DynamicColumnVO> page = PageUtil.getPage(query, DynamicColumnVO.class);
+ baseMapper.getPage(page, query);
+ return Result.ok().data(page.getRecords()).total(page.getTotal());
+ }
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ @Override
+ public Result detail(Integer id) {
+ DynamicColumnVO vo = baseMapper.getById(id);
+ Assert.notNull(vo, "璁板綍涓嶅瓨鍦�");
+ return Result.ok().data(vo);
+ }
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ @Override
+ public Result all() {
+ List<DynamicColumn> entities = baseMapper.selectList(null);
+ List<DynamicColumnVO> vos = entities.stream()
+ .map(entity -> DynamicColumnVO.getVoByEntity(entity, null))
+ .collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+}
diff --git a/ycl-server/src/main/resources/mapper/zgyw/DynamicColumnMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/DynamicColumnMapper.xml
new file mode 100644
index 0000000..7a27cf7
--- /dev/null
+++ b/ycl-server/src/main/resources/mapper/zgyw/DynamicColumnMapper.xml
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.platform.mapper.DynamicColumnMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.platform.domain.vo.DynamicColumnVO">
+ <result column="ref_id" property="refId" />
+ <result column="prop_name" property="propName" />
+ <result column="label_value" property="labelValue" />
+ <result column="field_value" property="fieldValue" />
+ </resultMap>
+
+
+
+
+
+
+
+ <select id="getById" resultMap="BaseResultMap">
+ SELECT
+ TDC.ref_id,
+ TDC.prop_name,
+ TDC.label_value,
+ TDC.field_value,
+ TDC.id
+ FROM
+ t_dynamic_column TDC
+ WHERE
+ TDC.id = #{id} AND TDC.deleted = 0
+ </select>
+
+
+ <select id="getPage" resultMap="BaseResultMap">
+ SELECT
+ TDC.ref_id,
+ TDC.prop_name,
+ TDC.label_value,
+ TDC.field_value,
+ TDC.id
+ FROM
+ t_dynamic_column TDC
+ WHERE
+ TDC.deleted = 0
+ </select>
+
+</mapper>
--
Gitblit v1.8.0