考试管理

xiangpei

2024-06-11 74b520065c267999e6a4cd61c8f7b0d516931f07

考试管理

 src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java

@@ -85,4 +85,11 @@
    public Result list() {
        return classesService.all();
    }

    @GetMapping("/my")
    @PreAuthorize("hasAuthority('classes:my')")
    @ApiOperation(value = "我的班级", notes = "我的班级")
    public Result myClassList() {
        return classesService.myClassList();
    }
}

 src/main/java/com/ycl/jxkg/controller/admin/ExamController.java

New file
@@ -0,0 +1,83 @@
package com.ycl.jxkg.controller.admin;

import com.ycl.jxkg.group.Update;
import com.ycl.jxkg.group.Add;
import org.springframework.validation.annotation.Validated;
import org.springframework.security.access.prepost.PreAuthorize;
import lombok.RequiredArgsConstructor;
import java.util.List;
import org.springframework.validation.annotation.Validated;
import javax.validation.constraints.NotEmpty;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import com.ycl.jxkg.service.ExamService;
import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.form.ExamForm;
import com.ycl.jxkg.domain.query.ExamQuery;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.*;

/**
 * 考试 前端控制器
 *
 * @author xp
 * @since 2024-06-11
 */
@Validated
@RequiredArgsConstructor
@Api(value = "考试", tags = "考试管理")
@RestController
@RequestMapping("/api/exam")
public class ExamController {

    private final ExamService examService;

    @PostMapping
    @ApiOperation(value = "添加", notes = "添加")
    @PreAuthorize("hasAuthority('exam:add')")
    public Result add(@RequestBody @Validated(Add.class) ExamForm form) {
        return examService.add(form);
    }

    @PutMapping
    @ApiOperation(value = "修改", notes = "修改")
    @PreAuthorize("hasAuthority('exam:edit')")
    public Result update(@RequestBody @Validated(Update.class) ExamForm form) {
        return examService.update(form);
    }

    @DeleteMapping("/{id}")
    @ApiOperation(value = "ID删除", notes = "ID删除")
    @PreAuthorize("hasAuthority('exam:del')")
    public Result removeById(@PathVariable("id") String id) {
        return examService.removeById(id);
    }

    @DeleteMapping("/batch")
    @ApiOperation(value = "批量删除", notes = "批量删除")
    @PreAuthorize("hasAuthority('exam:del:batch')")
    public Result remove(@RequestBody @NotEmpty(message = "请选择数据") List<String> ids) {
        return examService.remove(ids);
    }

    @GetMapping("/page")
    @ApiOperation(value = "分页", notes = "分页")
    @PreAuthorize("hasAuthority('exam:page')")
    public Result page(ExamQuery query) {
        return examService.page(query);
    }

    @GetMapping("/{id}")
    @ApiOperation(value = "详情", notes = "详情")
    @PreAuthorize("hasAuthority('exam:detail')")
    public Result detail(@PathVariable("id") Integer id) {
        return examService.detail(id);
    }

    @GetMapping("/list")
    @PreAuthorize("hasAuthority('exam:list')")
    @ApiOperation(value = "列表", notes = "列表")
    public Result list() {
        return examService.all();
    }
}

 src/main/java/com/ycl/jxkg/controller/admin/ExamPaperController.java

@@ -23,6 +23,8 @@

import javax.validation.Valid;
import java.util.Date;
import java.util.List;

@Validated
@RequiredArgsConstructor
@RestController("AdminExamPaperController")
@@ -81,4 +83,10 @@
        baseMapper.deleteById(id);
        return Result.ok();
    }

    @GetMapping("/my")
    public Result myExamPaper(Integer paperType) {
        List<ExamPaper> list = examPaperService.myExamPaper(paperType);
        return Result.ok(list);
    }
}

 src/main/java/com/ycl/jxkg/domain/entity/Exam.java

New file
@@ -0,0 +1,59 @@
package com.ycl.jxkg.domain.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import java.time.LocalDateTime;

import com.ycl.jxkg.domain.base.AbsEntity;
import lombok.Data;

/**
 * 考试
 *
 * @author xp
 * @since 2024-06-11
 */
@Data
@TableName("t_exam")
public class Exam extends AbsEntity {

    private static final long serialVersionUID = 1L;

    @TableField("exam_name")
    /** 考试名称 */
    private String examName;

    @TableField("exam_paper_id")
    /** 试卷ID */
    private Integer examPaperId;

    @TableField("classes_id")
    /** 班级ID */
    private Integer classesId;

    @TableField("exam_paper_type")
    /** 试卷类型 */
    private String examPaperType;

    @TableField("exam_place")
    /** 考试地点 */
    private String examPlace;

    @TableField("status")
    /** 考试状态 */
    private String status;

    @TableField("start_time")
    /** 开始时间 */
    private LocalDateTime startTime;

    @TableField("end_time")
    /** 结束时间 */
    private LocalDateTime endTime;

    @TableField("teacher_id")
    /** 创建老师 */
    private Integer teacherId;


}

 src/main/java/com/ycl/jxkg/domain/form/ExamForm.java

New file
@@ -0,0 +1,62 @@
package com.ycl.jxkg.domain.form;

import com.ycl.jxkg.group.Update;
import com.ycl.jxkg.group.Add;
import com.ycl.jxkg.domain.base.AbsForm;
import com.ycl.jxkg.domain.entity.Exam;
import org.springframework.beans.BeanUtils;
import javax.validation.constraints.NotBlank;
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-06-11
 */
@Data
@ApiModel(value = "Exam表单", description = "考试表单")
public class ExamForm extends AbsForm {

    @NotBlank(message = "考试名称不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("考试名称")
    private String examName;

    @NotNull(message = "考试试卷不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("试卷ID")
    private Integer examPaperId;

    @NotNull(message = "参考班级不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("班级ID")
    private Integer classesId;

    @NotBlank(message = "试卷类型不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("试卷类型")
    private String examPaperType;

    @NotBlank(message = "考试地点不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("考试地点")
    private String examPlace;

    @NotNull(message = "开始时间不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("开始时间")
    private Date startTime;

    @NotNull(message = "结束时间不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("结束时间")
    private Date endTime;

    public static Exam getEntityByForm(@NonNull ExamForm form, Exam entity) {
        if(entity == null) {
          entity = new Exam();
        }
        BeanUtils.copyProperties(form, entity);
        return entity;
    }

}

 src/main/java/com/ycl/jxkg/domain/query/ExamQuery.java

New file
@@ -0,0 +1,22 @@
package com.ycl.jxkg.domain.query;

import com.ycl.jxkg.domain.base.AbsQuery;
import java.util.List;
import org.springframework.lang.NonNull;
import javax.validation.constraints.NotBlank;
import javax.validation.constraints.NotNull;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * 考试查询
 *
 * @author xp
 * @since 2024-06-11
 */
@Data
@ApiModel(value = "Exam查询", description = "考试查询")
public class ExamQuery extends AbsQuery {
}


 src/main/java/com/ycl/jxkg/domain/vo/ExamVO.java

New file
@@ -0,0 +1,60 @@
package com.ycl.jxkg.domain.vo;

import com.ycl.jxkg.domain.base.AbsVo;
import com.ycl.jxkg.domain.entity.Exam;
import java.util.List;
import org.springframework.lang.NonNull;
import org.springframework.beans.BeanUtils;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.util.Date;

/**
 * 考试展示
 *
 * @author xp
 * @since 2024-06-11
 */
@Data
public class ExamVO extends AbsVo {

    /** 考试名称 */
    private String examName;

    /** 试卷ID */
    private Integer examPaperId;

    /** 班级ID */
    private Integer classesId;

    /** 试卷类型 */
    private String examPaperType;

    /** 考试地点 */
    private String examPlace;

    /** 考试状态 */
    private String status;

    /** 开始时间 */
    private Date startTime;

    /** 结束时间 */
    private Date endTime;

    /** 创建时间 */
    private Date createTime;

    /** 创建老师 */
    private Integer teacherId;

    public static ExamVO getVoByEntity(@NonNull Exam entity, ExamVO vo) {
        if(vo == null) {
            vo = new ExamVO();
        }
        BeanUtils.copyProperties(entity, vo);
        return vo;
    }

}

 src/main/java/com/ycl/jxkg/mapper/ExamMapper.java

New file
@@ -0,0 +1,34 @@
package com.ycl.jxkg.mapper;

import com.ycl.jxkg.domain.entity.Exam;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.jxkg.domain.query.ExamQuery;
import com.ycl.jxkg.domain.vo.ExamVO;
import com.ycl.jxkg.domain.form.ExamForm;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 考试 Mapper 接口
 *
 * @author xp
 * @since 2024-06-11
 */
@Mapper
public interface ExamMapper extends BaseMapper<Exam> {

    /**
     * id查找考试
     * @param id
     * @return
     */
    ExamVO getById(Integer id);

    /**
    *  分页
    */
    IPage getPage(IPage page, @Param("query") ExamQuery query);

}

 src/main/java/com/ycl/jxkg/service/ClassesService.java

@@ -78,4 +78,12 @@
     * @return
     */
    Result dissolution(Integer id);

    /**
     *
     * 我的班级
     *
     * @return
     */
    Result myClassList();
}

 src/main/java/com/ycl/jxkg/service/ExamPaperService.java

@@ -29,4 +29,13 @@
    Integer selectAllCount();

    List<Integer> selectMothCount();

    /**
     *
     * 我的试卷
     *
     * @param paperType
     * @return
     */
    List<ExamPaper> myExamPaper(Integer paperType);
}

 src/main/java/com/ycl/jxkg/service/ExamService.java

New file
@@ -0,0 +1,65 @@
package com.ycl.jxkg.service;

import com.ycl.jxkg.domain.entity.Exam;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.form.ExamForm;
import com.ycl.jxkg.domain.query.ExamQuery;
import java.util.List;

/**
 * 考试 服务类
 *
 * @author xp
 * @since 2024-06-11
 */
public interface ExamService extends IService<Exam> {

    /**
     * 添加
     * @param form
     * @return
     */
    Result add(ExamForm form);

    /**
     * 修改
     * @param form
     * @return
     */
    Result update(ExamForm form);

    /**
     * 批量删除
     * @param ids
     * @return
     */
    Result remove(List<String> ids);

    /**
     * id删除
     * @param id
     * @return
     */
    Result removeById(String id);

    /**
     * 分页查询
     * @param query
     * @return
     */
    Result page(ExamQuery query);

    /**
     * 根据id查找
     * @param id
     * @return
     */
    Result detail(Integer id);

    /**
     * 列表
     * @return
     */
    Result all();
}

 src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java

@@ -1,7 +1,9 @@
package com.ycl.jxkg.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
import com.ycl.jxkg.context.WebContext;
import com.ycl.jxkg.domain.entity.Classes;
import com.ycl.jxkg.enums.general.ClassesStatusEnum;
import com.ycl.jxkg.mapper.ClassesMapper;
@@ -31,6 +33,7 @@
public class ClassesServiceImpl extends ServiceImpl<ClassesMapper, Classes> implements ClassesService {

    private final ClassesMapper classesMapper;
    private final WebContext webContext;

    /**
     * 添加
@@ -127,4 +130,15 @@
                .update();
        return Result.ok("解散成功");
    }


    @Override
    public Result myClassList() {
        Integer userId = webContext.getCurrentUser().getId();
        List<Classes> list = new LambdaQueryChainWrapper<>(baseMapper)
                .select(Classes::getId, Classes::getClassName)
                .eq(Classes::getCreateUser, userId)
                .list();
        return Result.ok(list);
    }
}

 src/main/java/com/ycl/jxkg/service/impl/ExamPaperServiceImpl.java

@@ -1,11 +1,14 @@
package com.ycl.jxkg.service.impl;

import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.jxkg.context.WebContext;
import com.ycl.jxkg.domain.entity.TextContent;
import com.ycl.jxkg.enums.ExamPaperTypeEnum;
import com.ycl.jxkg.domain.exam.ExamPaperQuestionItemObject;
import com.ycl.jxkg.domain.exam.ExamPaperTitleItemObject;
import com.ycl.jxkg.domain.other.KeyValue;
import com.ycl.jxkg.enums.VisibilityEnum;
import com.ycl.jxkg.mapper.ExamPaperMapper;
import com.ycl.jxkg.mapper.QuestionMapper;
import com.ycl.jxkg.service.ExamPaperService;
@@ -32,6 +35,7 @@

import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.stream.Collectors;

@@ -44,6 +48,7 @@
    private final TextContentService textContentService;
    private final QuestionService questionService;
    private final SubjectService subjectService;
    private final WebContext webContext;


    @Override
@@ -191,5 +196,22 @@
        }).collect(Collectors.toList());
    }


    @Override
    public List<ExamPaper> myExamPaper(Integer paperType) {
        Integer userId = webContext.getCurrentUser().getId();
        List<ExamPaper> list = new LambdaQueryChainWrapper<>(baseMapper)
                .select(ExamPaper::getId, ExamPaper::getName, ExamPaper::getVisibility)
                .eq(ExamPaper::getCreateUser, userId)
                .eq(Objects.nonNull(paperType), ExamPaper::getPaperType, paperType)
                .or()
                .eq(ExamPaper::getVisibility, VisibilityEnum.Public.getName())
                .eq(Objects.nonNull(paperType), ExamPaper::getPaperType, paperType)
                .list();
        list.stream().forEach(item -> {
            if (VisibilityEnum.Public.getName().equals(item.getVisibility())) {
                item.setName(item.getName() + " (公开)");
            }
        });
        return list;
    }
}

 src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java

New file
@@ -0,0 +1,119 @@
package com.ycl.jxkg.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.jxkg.domain.entity.Exam;
import com.ycl.jxkg.mapper.ExamMapper;
import com.ycl.jxkg.service.ExamService;
import com.ycl.jxkg.base.Result;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.jxkg.domain.form.ExamForm;
import com.ycl.jxkg.domain.vo.ExamVO;
import com.ycl.jxkg.domain.query.ExamQuery;
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 xp
 * @since 2024-06-11
 */
@Service
@RequiredArgsConstructor
public class ExamServiceImpl extends ServiceImpl<ExamMapper, Exam> implements ExamService {

    private final ExamMapper examMapper;

    /**
     * 添加
     * @param form
     * @return
     */
    @Override
    public Result add(ExamForm form) {
        Exam entity = ExamForm.getEntityByForm(form, null);
        baseMapper.insert(entity);
        return Result.ok("添加成功");
    }

    /**
     * 修改
     * @param form
     * @return
     */
    @Override
    public Result update(ExamForm form) {
        Exam entity = baseMapper.selectById(form.getId());

        // 为空抛IllegalArgumentException，做全局异常处理
        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(ExamQuery query) {
        IPage<ExamVO> page = PageUtil.getPage(query, ExamVO.class);
        baseMapper.getPage(page, query);
        return Result.ok().data(page.getRecords()).total(page.getTotal());
    }

    /**
     * 根据id查找
     * @param id
     * @return
     */
    @Override
    public Result detail(Integer id) {
        ExamVO vo = baseMapper.getById(id);
        Assert.notNull(vo, "记录不存在");
        return Result.ok().data(vo);
    }

    /**
     * 列表
     * @return
     */
    @Override
    public Result all() {
        List<Exam> entities = baseMapper.selectList(null);
        List<ExamVO> vos = entities.stream()
                .map(entity -> ExamVO.getVoByEntity(entity, null))
                .collect(Collectors.toList());
        return Result.ok().data(vos);
    }
}

 src/main/resources/mapper/ExamMapper.xml

New file
@@ -0,0 +1,64 @@
<?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.ExamMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ycl.jxkg.domain.vo.ExamVO">
        <result column="exam_name" property="examName" />
        <result column="exam_paper_id" property="examPaperId" />
        <result column="classes_id" property="classesId" />
        <result column="exam_paper_type" property="examPaperType" />
        <result column="exam_place" property="examPlace" />
        <result column="status" property="status" />
        <result column="start_time" property="startTime" />
        <result column="end_time" property="endTime" />
        <result column="create_time" property="createTime" />
        <result column="teacher_id" property="teacherId" />
    </resultMap>







    <select id="getById" resultMap="BaseResultMap">
        SELECT
            TE.exam_name,
            TE.exam_paper_id,
            TE.classes_id,
            TE.exam_paper_type,
            TE.exam_place,
            TE.status,
            TE.start_time,
            TE.end_time,
            TE.create_time,
            TE.teacher_id,
            TE.id
        FROM
            t_exam TE
        WHERE
            TE.id = #{id} AND TE.deleted = 0
    </select>


    <select id="getPage" resultMap="BaseResultMap">
        SELECT
            TE.exam_name,
            TE.exam_paper_id,
            TE.classes_id,
            TE.exam_paper_type,
            TE.exam_place,
            TE.status,
            TE.start_time,
            TE.end_time,
            TE.create_time,
            TE.teacher_id,
            TE.id
        FROM
            t_exam TE
        WHERE
            TE.deleted = 0
    </select>

</mapper>