From 11dda318d00aea0ca51133d3dd397ee8a3cfaa1e Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期三, 26 六月 2024 11:18:53 +0800
Subject: [PATCH] feat:作弊记录
---
src/main/java/com/ycl/jxkg/domain/vo/ExamCheatVO.java | 60 ++++++
src/main/java/com/ycl/jxkg/controller/admin/ExamCheatController.java | 82 +++++++++
src/main/java/com/ycl/jxkg/domain/entity/ExamCheat.java | 46 +++++
src/main/java/com/ycl/jxkg/mapper/ExamCheatMapper.java | 32 +++
src/main/java/com/ycl/jxkg/domain/form/ExamCheatForm.java | 50 +++++
src/main/java/com/ycl/jxkg/service/impl/ExamCheatServiceImpl.java | 119 +++++++++++++
src/main/java/com/ycl/jxkg/service/ExamCheatService.java | 65 +++++++
src/main/java/com/ycl/jxkg/domain/query/ExamCheatQuery.java | 20 ++
src/main/resources/mapper/ExamCheatMapper.xml | 46 +++++
9 files changed, 520 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ycl/jxkg/controller/admin/ExamCheatController.java b/src/main/java/com/ycl/jxkg/controller/admin/ExamCheatController.java
new file mode 100644
index 0000000..0ef7482
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/controller/admin/ExamCheatController.java
@@ -0,0 +1,82 @@
+package com.ycl.jxkg.controller.admin;
+
+import com.ycl.jxkg.base.Result;
+import com.ycl.jxkg.domain.form.ExamCheatForm;
+import com.ycl.jxkg.domain.query.ExamCheatQuery;
+import com.ycl.jxkg.group.Add;
+import com.ycl.jxkg.group.Update;
+import com.ycl.jxkg.service.ExamCheatService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.RequiredArgsConstructor;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import javax.validation.constraints.NotEmpty;
+import java.util.List;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍 鍓嶇鎺у埗鍣�
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Validated
+@RequiredArgsConstructor
+@Api(value = "鑰冭瘯浣滃紛璁板綍", tags = "鑰冭瘯浣滃紛璁板綍绠＄悊")
+@RestController
+@RequestMapping("/api/admin/cheat")
+public class ExamCheatController {
+
+ private final ExamCheatService examCheatService;
+
+ @PostMapping
+ @ApiOperation(value = "娣诲姞", notes = "娣诲姞")
+ @PreAuthorize("hasAuthority('examCheat:add')")
+ public Result add(@RequestBody @Validated(Add.class) ExamCheatForm form) {
+ return examCheatService.add(form);
+ }
+
+ @PutMapping
+ @ApiOperation(value = "淇敼", notes = "淇敼")
+ @PreAuthorize("hasAuthority('examCheat:edit')")
+ public Result update(@RequestBody @Validated(Update.class) ExamCheatForm form) {
+ return examCheatService.update(form);
+ }
+
+ @DeleteMapping("/{id}")
+ @ApiOperation(value = "ID鍒犻櫎", notes = "ID鍒犻櫎")
+ @PreAuthorize("hasAuthority('examCheat:del')")
+ public Result removeById(@PathVariable("id") String id) {
+ return examCheatService.removeById(id);
+ }
+
+ @DeleteMapping("/batch")
+ @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎")
+ @PreAuthorize("hasAuthority('examCheat:del:batch')")
+ public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) {
+ return examCheatService.remove(ids);
+ }
+
+ @GetMapping("/page")
+ @ApiOperation(value = "鍒嗛〉", notes = "鍒嗛〉")
+ @PreAuthorize("hasAuthority('examCheat:page')")
+ public Result page(ExamCheatQuery query) {
+ return examCheatService.page(query);
+ }
+
+ @GetMapping("/{id}")
+ @ApiOperation(value = "璇︽儏", notes = "璇︽儏")
+ @PreAuthorize("hasAuthority('examCheat:detail')")
+ public Result detail(@PathVariable("id") Integer id) {
+ return examCheatService.detail(id);
+ }
+
+ @GetMapping("/list")
+ @PreAuthorize("hasAuthority('examCheat:list')")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result list() {
+ return examCheatService.all();
+ }
+}
diff --git a/src/main/java/com/ycl/jxkg/domain/entity/ExamCheat.java b/src/main/java/com/ycl/jxkg/domain/entity/ExamCheat.java
new file mode 100644
index 0000000..bcbcb22
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/domain/entity/ExamCheat.java
@@ -0,0 +1,46 @@
+package com.ycl.jxkg.domain.entity;
+
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.ycl.jxkg.domain.base.AbsEntity;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+
+import java.io.Serializable;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Data
+@Accessors(chain = true)
+@TableName("t_exam_cheat")
+@EqualsAndHashCode(callSuper = true)
+public class ExamCheat extends AbsEntity implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 鑰冭瘯id
+ */
+ @TableField("exam_id")
+ private Integer examId;
+
+ /**
+ * 浣滃紛浜�
+ */
+ @TableField("cheat_user")
+ private Integer cheatUser;
+
+ /**
+ * 鍒涘缓浜�
+ */
+ @TableField(value = "create_user", fill = FieldFill.INSERT)
+ private Integer createUser;
+
+}
+
diff --git a/src/main/java/com/ycl/jxkg/domain/form/ExamCheatForm.java b/src/main/java/com/ycl/jxkg/domain/form/ExamCheatForm.java
new file mode 100644
index 0000000..9cbfa52
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/domain/form/ExamCheatForm.java
@@ -0,0 +1,50 @@
+package com.ycl.jxkg.domain.form;
+
+import com.ycl.jxkg.domain.base.AbsForm;
+import com.ycl.jxkg.domain.entity.ExamCheat;
+import com.ycl.jxkg.group.Add;
+import com.ycl.jxkg.group.Update;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.beans.BeanUtils;
+import org.springframework.lang.NonNull;
+
+import javax.validation.constraints.NotNull;
+import java.util.Date;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍琛ㄥ崟
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Data
+@ApiModel(value = "ExamCheat琛ㄥ崟", description = "鑰冭瘯浣滃紛璁板綍琛ㄥ崟")
+public class ExamCheatForm extends AbsForm {
+
+ @NotNull(message = "鑰冭瘯id涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鑰冭瘯id")
+ private Integer examId;
+
+ @NotNull(message = "鍒涘缓鏃堕棿涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍒涘缓鏃堕棿")
+ private Date createTime;
+
+ @NotNull(message = "浣滃紛浜轰笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("浣滃紛浜�")
+ private Integer cheatUser;
+
+ @NotNull(message = "鍒涘缓浜轰笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍒涘缓浜�")
+ private Integer createUser;
+
+ public static ExamCheat getEntityByForm(@NonNull ExamCheatForm form, ExamCheat entity) {
+ if(entity == null) {
+ entity = new ExamCheat();
+ }
+ BeanUtils.copyProperties(form, entity);
+ return entity;
+ }
+
+}
diff --git a/src/main/java/com/ycl/jxkg/domain/query/ExamCheatQuery.java b/src/main/java/com/ycl/jxkg/domain/query/ExamCheatQuery.java
new file mode 100644
index 0000000..09f1b68
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/domain/query/ExamCheatQuery.java
@@ -0,0 +1,20 @@
+package com.ycl.jxkg.domain.query;
+
+import com.ycl.jxkg.domain.base.AbsQuery;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍鏌ヨ
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Data
+@ApiModel(value = "ExamCheat鏌ヨ", description = "鑰冭瘯浣滃紛璁板綍鏌ヨ")
+public class ExamCheatQuery extends AbsQuery {
+
+ private String keyword;
+
+}
+
diff --git a/src/main/java/com/ycl/jxkg/domain/vo/ExamCheatVO.java b/src/main/java/com/ycl/jxkg/domain/vo/ExamCheatVO.java
new file mode 100644
index 0000000..d01d867
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/domain/vo/ExamCheatVO.java
@@ -0,0 +1,60 @@
+package com.ycl.jxkg.domain.vo;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ycl.jxkg.domain.base.AbsVo;
+import com.ycl.jxkg.domain.entity.ExamCheat;
+import lombok.Data;
+import org.springframework.beans.BeanUtils;
+import org.springframework.lang.NonNull;
+
+import java.util.Date;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍灞曠ず
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Data
+public class ExamCheatVO extends AbsVo {
+
+ /**
+ * 鑰冭瘯id
+ */
+ private Integer examId;
+
+ /**
+ * 鑰冭瘯鍚嶇О
+ */
+ private String examName;
+
+ /**
+ * 鍒涘缓鏃堕棿
+ */
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date createTime;
+
+ /**
+ * 浣滃紛浜�
+ */
+ private Integer cheatUser;
+
+ /**
+ * 浣滃紛浜�
+ */
+ private String cheatUserName;
+
+ /**
+ * 鍒涘缓浜�
+ */
+ private Integer createUser;
+
+ public static ExamCheatVO getVoByEntity(@NonNull ExamCheat entity, ExamCheatVO vo) {
+ if (vo == null) {
+ vo = new ExamCheatVO();
+ }
+ BeanUtils.copyProperties(entity, vo);
+ return vo;
+ }
+
+}
diff --git a/src/main/java/com/ycl/jxkg/mapper/ExamCheatMapper.java b/src/main/java/com/ycl/jxkg/mapper/ExamCheatMapper.java
new file mode 100644
index 0000000..04f4e1a
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/mapper/ExamCheatMapper.java
@@ -0,0 +1,32 @@
+package com.ycl.jxkg.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ycl.jxkg.domain.entity.ExamCheat;
+import com.ycl.jxkg.domain.query.ExamCheatQuery;
+import com.ycl.jxkg.domain.vo.ExamCheatVO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍 Mapper 鎺ュ彛
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Mapper
+public interface ExamCheatMapper extends BaseMapper<ExamCheat> {
+
+ /**
+ * id鏌ユ壘鑰冭瘯浣滃紛璁板綍
+ * @param id
+ * @return
+ */
+ ExamCheatVO getById(Integer id);
+
+ /**
+ * 鍒嗛〉
+ */
+ IPage getPage(IPage page, @Param("query") ExamCheatQuery query);
+
+}
diff --git a/src/main/java/com/ycl/jxkg/service/ExamCheatService.java b/src/main/java/com/ycl/jxkg/service/ExamCheatService.java
new file mode 100644
index 0000000..11edefa
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/service/ExamCheatService.java
@@ -0,0 +1,65 @@
+package com.ycl.jxkg.service;
+
+import com.ycl.jxkg.domain.entity.ExamCheat;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ycl.jxkg.base.Result;
+import com.ycl.jxkg.domain.form.ExamCheatForm;
+import com.ycl.jxkg.domain.query.ExamCheatQuery;
+import java.util.List;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍 鏈嶅姟绫�
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+public interface ExamCheatService extends IService<ExamCheat> {
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ Result add(ExamCheatForm form);
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ Result update(ExamCheatForm form);
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ Result remove(List<String> ids);
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ Result removeById(String id);
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ Result page(ExamCheatQuery query);
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ Result detail(Integer id);
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ Result all();
+}
diff --git a/src/main/java/com/ycl/jxkg/service/impl/ExamCheatServiceImpl.java b/src/main/java/com/ycl/jxkg/service/impl/ExamCheatServiceImpl.java
new file mode 100644
index 0000000..e9ec637
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/service/impl/ExamCheatServiceImpl.java
@@ -0,0 +1,119 @@
+package com.ycl.jxkg.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.ycl.jxkg.domain.entity.ExamCheat;
+import com.ycl.jxkg.mapper.ExamCheatMapper;
+import com.ycl.jxkg.service.ExamCheatService;
+import com.ycl.jxkg.base.Result;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ycl.jxkg.domain.form.ExamCheatForm;
+import com.ycl.jxkg.domain.vo.ExamCheatVO;
+import com.ycl.jxkg.domain.query.ExamCheatQuery;
+import org.springframework.stereotype.Service;
+import lombok.RequiredArgsConstructor;
+import com.ycl.jxkg.utils.PageUtil;
+import org.springframework.beans.BeanUtils;
+import org.springframework.util.Assert;
+
+import java.util.List;
+import java.util.stream.Collectors;
+
+/**
+ * 鑰冭瘯浣滃紛璁板綍 鏈嶅姟瀹炵幇绫�
+ *
+ * @author gonghl
+ * @since 2024-06-26
+ */
+@Service
+@RequiredArgsConstructor
+public class ExamCheatServiceImpl extends ServiceImpl<ExamCheatMapper, ExamCheat> implements ExamCheatService {
+
+ private final ExamCheatMapper examCheatMapper;
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ @Override
+ public Result add(ExamCheatForm form) {
+ ExamCheat entity = ExamCheatForm.getEntityByForm(form, null);
+ baseMapper.insert(entity);
+ return Result.ok("娣诲姞鎴愬姛");
+ }
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ @Override
+ public Result update(ExamCheatForm form) {
+ ExamCheat 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(ExamCheatQuery query) {
+ IPage<ExamCheatVO> page = PageUtil.getPage(query, ExamCheatVO.class);
+ baseMapper.getPage(page, query);
+ return Result.ok().data(page);
+ }
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ @Override
+ public Result detail(Integer id) {
+ ExamCheatVO vo = baseMapper.getById(id);
+ Assert.notNull(vo, "璁板綍涓嶅瓨鍦�");
+ return Result.ok().data(vo);
+ }
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ @Override
+ public Result all() {
+ List<ExamCheat> entities = baseMapper.selectList(null);
+ List<ExamCheatVO> vos = entities.stream()
+ .map(entity -> ExamCheatVO.getVoByEntity(entity, null))
+ .collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+}
diff --git a/src/main/resources/mapper/ExamCheatMapper.xml b/src/main/resources/mapper/ExamCheatMapper.xml
new file mode 100644
index 0000000..e30857a
--- /dev/null
+++ b/src/main/resources/mapper/ExamCheatMapper.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.jxkg.mapper.ExamCheatMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.jxkg.domain.vo.ExamCheatVO">
+ <result column="exam_id" property="examId" />
+ <result column="create_time" property="createTime" />
+ <result column="cheat_user" property="cheatUser" />
+ <result column="create_user" property="createUser" />
+ </resultMap>
+
+ <select id="getById" resultMap="BaseResultMap">
+ SELECT
+ TEC.exam_id,
+ TEC.create_time,
+ TEC.cheat_user,
+ TEC.create_user,
+ TEC.id
+ FROM
+ t_exam_cheat TEC
+ WHERE
+ TEC.id = #{id} AND TEC.deleted = 0
+ </select>
+
+ <select id="getPage" resultMap="BaseResultMap">
+ SELECT
+ TEC.exam_id,
+ TEC.create_time,
+ TEC.cheat_user,
+ TEC.create_user,
+ TEC.id,
+ TU.real_name as cheatUserName,
+ TE.exam_name as examName
+ FROM
+ t_exam_cheat TEC
+ INNER JOIN t_exam TE ON TE.id = TEC.exam_id AND TE.deleted = 0
+ INNER JOIN t_user TU ON TU.id = TEC.cheat_user AND TU.deleted = 0
+ WHERE
+ TEC.deleted = 0
+ <if test="query.keyword != null and query.keyword != ''">
+ AND (INSTR(TE.exam_name, #{query.keyword}) OR INSTR(TU.real_name, #{query.keyword}))
+ </if>
+ </select>
+
+</mapper>
--
Gitblit v1.8.0