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