自动生成提示

 

CREATE TABLE `ftb_data_analysis_target` (

`F_Id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',

`F_ConfigId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '年度目标指标配置id',

`F_Type` tinyint(0) NOT NULL COMMENT '类型(1-月目标 2-周目标 3-日目标)',

`F_Name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '目标名称(xx月/xx周/xx日)',

`F_DateTitle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '时间标题',

`F_TargetId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '目标id(当为月目标时为空)',

`F_Amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '目标金额(两位小数)',

`F_Status` tinyint(0) NULL DEFAULT 0 COMMENT '月目标是否生效(0-否 1-是)',

`F_CreatorUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建用户',

`F_CreatorTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`F_LastModifyUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改用户',

`F_LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

`F_DeleteUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除用户',

`F_DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

`F_TenantId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',

`F_EnabledMark` int(0) NULL DEFAULT 0 COMMENT '有效标志',

PRIMARY KEY (`F_Id`) USING BTREE,

UNIQUE INDEX `unIndex`(`F_ConfigId`, `F_Type`, `F_Name`) USING BTREE COMMENT '年度-目标类型-目标名称唯一索引'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据分析-目标管理' ROW_FORMAT = Dynamic;

CREATE TABLE `ftb_data_analysis_target_config` (

`F_Id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',

`F_Year` int(0) NOT NULL COMMENT '年份(2025)',

`F_Indicator` json NOT NULL COMMENT '配置指标Json数组(枚举)',

`F_Dimension` tinyint(0) NOT NULL COMMENT '目标拆解维度(1-月 2-周 3-日)',

`F_Approval` tinyint(0) NOT NULL COMMENT '月目标是否需要审批(0-否 1-是)',

`F_Status` tinyint(0) NOT NULL COMMENT '状态(0-停用 1-是)',

`F_CreatorUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建用户',

`F_CreatorTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`F_LastModifyUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改用户',

`F_LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

`F_DeleteUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除用户',

`F_DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

`F_TenantId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',

`F_EnabledMark` int(0) NULL DEFAULT 0 COMMENT '有效标志',

PRIMARY KEY (`F_Id`) USING BTREE,

UNIQUE INDEX `unIndex`(`F_Year`) USING BTREE COMMENT '年度目标配置唯一索引'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据分析-目标指标配置' ROW_FORMAT = Dynamic;

CREATE TABLE `ftb_data_analysis_target_config_user` (

`F_Id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',

`F_ConfigId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '年度目标指标配置id',

`F_Type` tinyint(0) NULL DEFAULT NULL COMMENT '类型(1-月目标 2-周/日目标)',

`F_UserScope` tinyint(0) NULL DEFAULT NULL COMMENT '月人员范围(1-人员 2-岗位)',

`F_UserScopeJson` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位ID/人员ID',

`F_CreatorUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建用户',

`F_CreatorTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`F_LastModifyUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改用户',

`F_LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

`F_DeleteUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除用户',

`F_DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

`F_TenantId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',

`F_EnabledMark` int(0) NULL DEFAULT 0 COMMENT '有效标志',

PRIMARY KEY (`F_Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据分析-目标提交人员配置' ROW_FORMAT = Dynamic;

CREATE TABLE `ftb_data_analysis_target_work_config` (

`F_Id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',

`F_IncomeItem` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收入分析所用指标项',

`F_ProductItem` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品分析所用指标项',

`F_CreatorUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建用户',

`F_CreatorTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`F_LastModifyUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改用户',

`F_LastModifyTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

`F_DeleteUserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除用户',

`F_DeleteTime` datetime(0) NULL DEFAULT NULL COMMENT '删除时间',

`F_TenantId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',

`F_EnabledMark` int(0) NULL DEFAULT 0 COMMENT '有效标志',

PRIMARY KEY (`F_Id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据分析-工作台-目标配置' ROW_FORMAT = Dynamic;

生成：Controller、Service、ServiceImpl、Mapper以及Mapper.xml，规则如下

二.生成实体要求：

1：类添加@Data、@Builder、@NoArgsConstructor、@AllArgsConstructor、@TableName("数据库表名")注解，并且extends SuperBaseEntity.SuperCUDBaseEntity<String> 和实现Serializable

2：字段说明采用多行文本注释，字段添加 @TableField注解( @TableField("F_UserName"))，类字段名排除掉F_前缀，采用驼峰命名

三.service要求：继承SuperService

四.serviceImpl要求：继承SuperServiceImpl

五.Controller要求：

1：方法说明采用@Operation(summary = "方法描述")

2：返回公共相应类ActionResult，如ActionResult.success(ratingItemsService.addData(dto))；

六.Mapper要求：继承BaseMapper，添加@Mapper、@Component注解

七：请求参数实体命名采用Dto的后缀(字段增加validation字段类型校验)，响应实体采用Vo的后缀

p.MsoNormal{ mso-style-name: 正文; mso-style-parent: ""; margin: 0pt; margin-bottom: .0001pt; mso-pagination: none; text-justify: inter-ideograph; mso-font-kerning: 1.0000pt; font-size: 10.5pt; }p.paragraph{ mso-style-noshow: yes; margin-top: 5.0000pt; margin-right: 0.0000pt; margin-bottom: 5.0000pt; margin-left: 0.0000pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; text-align: left; font-family: 等线; mso-bidi-font-family: 'Times New Roman'; font-size: 12.0000pt; }