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