新增 queue_sequence 表操作代码

eight

2024-11-07 28e699e3e1886ff4f08590857aaf08a62567c3f3

新增 queue_sequence 表操作代码

 jh-module-ecg/jh-module-ecg-api/src/main/java/cn/lihu/jh/module/ecg/enums/ErrorCodeConstants.java

@@ -54,4 +54,6 @@
    ErrorCode CALL_NOT_EXISTS = new ErrorCode(1_010_008_000, "叫号不存在");

    ErrorCode CHECK_TYPE_NOT_EXISTS = new ErrorCode(1_010_009_000, "检查类型不存在");

    ErrorCode QUEUE_SEQUENCE_NOT_EXISTS = new ErrorCode(1_010_010_000, "当天序号不存在");
}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/queuesequence/QueueSequenceController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,95 @@
package cn.lihu.jh.module.ecg.controller.admin.queuesequence;

import org.springframework.web.bind.annotation.*;
import org.springframework.validation.annotation.Validated;
import org.springframework.security.access.prepost.PreAuthorize;
import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Parameter;
import io.swagger.v3.oas.annotations.Operation;

import java.util.*;
import java.io.IOException;

import cn.lihu.jh.framework.common.pojo.PageParam;
import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.common.pojo.CommonResult;
import cn.lihu.jh.framework.common.util.object.BeanUtils;
import static cn.lihu.jh.framework.common.pojo.CommonResult.success;

import cn.lihu.jh.framework.excel.core.util.ExcelUtils;

import cn.lihu.jh.framework.apilog.core.annotation.ApiAccessLog;
import static cn.lihu.jh.framework.apilog.core.enums.OperateTypeEnum.*;

import cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo.*;
import cn.lihu.jh.module.ecg.dal.dataobject.queuesequence.QueueSequenceDO;
import cn.lihu.jh.module.ecg.service.queuesequence.QueueSequenceService;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
import javax.validation.Valid;

@Tag(name = "管理后台 - å½“天序号")
@RestController
@RequestMapping("/ecg/queue-sequence")
@Validated
public class QueueSequenceController {

    @Resource
    private QueueSequenceService queueSequenceService;

    @PostMapping("/create")
    @Operation(summary = "创建当天序号")
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:create')")
    public CommonResult<Integer> createQueueSequence(@Valid @RequestBody QueueSequenceSaveReqVO createReqVO) {
        return success(queueSequenceService.createQueueSequence(createReqVO));
    }

    @PutMapping("/update")
    @Operation(summary = "更新当天序号")
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:update')")
    public CommonResult<Boolean> updateQueueSequence(@Valid @RequestBody QueueSequenceSaveReqVO updateReqVO) {
        queueSequenceService.updateQueueSequence(updateReqVO);
        return success(true);
    }

    @DeleteMapping("/delete")
    @Operation(summary = "删除当天序号")
    @Parameter(name = "id", description = "编号", required = true)
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:delete')")
    public CommonResult<Boolean> deleteQueueSequence(@RequestParam("id") Integer id) {
        queueSequenceService.deleteQueueSequence(id);
        return success(true);
    }

    @GetMapping("/get")
    @Operation(summary = "获得当天序号")
    @Parameter(name = "id", description = "编号", required = true, example = "1024")
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:query')")
    public CommonResult<QueueSequenceRespVO> getQueueSequence(@RequestParam("id") Integer id) {
        QueueSequenceDO queueSequence = queueSequenceService.getQueueSequence(id);
        return success(BeanUtils.toBean(queueSequence, QueueSequenceRespVO.class));
    }

    @GetMapping("/page")
    @Operation(summary = "获得当天序号分页")
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:query')")
    public CommonResult<PageResult<QueueSequenceRespVO>> getQueueSequencePage(@Valid QueueSequencePageReqVO pageReqVO) {
        PageResult<QueueSequenceDO> pageResult = queueSequenceService.getQueueSequencePage(pageReqVO);
        return success(BeanUtils.toBean(pageResult, QueueSequenceRespVO.class));
    }

    @GetMapping("/export-excel")
    @Operation(summary = "导出当天序号 Excel")
    @PreAuthorize("@ss.hasPermission('ecg:queue-sequence:export')")
    @ApiAccessLog(operateType = EXPORT)
    public void exportQueueSequenceExcel(@Valid QueueSequencePageReqVO pageReqVO,
              HttpServletResponse response) throws IOException {
        pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
        List<QueueSequenceDO> list = queueSequenceService.getQueueSequencePage(pageReqVO).getList();
        // å¯¼å‡º Excel
        ExcelUtils.write(response, "当天序号.xls", "数据", QueueSequenceRespVO.class,
                        BeanUtils.toBean(list, QueueSequenceRespVO.class));
    }

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/queuesequence/vo/QueueSequencePageReqVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,40 @@
package cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo;

import lombok.*;
import java.util.*;
import io.swagger.v3.oas.annotations.media.Schema;
import cn.lihu.jh.framework.common.pojo.PageParam;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDateTime;

import static cn.lihu.jh.framework.common.util.date.DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND;

@Schema(description = "管理后台 - å½“天序号分页 Request VO")
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
public class QueueSequencePageReqVO extends PageParam {

    @Schema(description = "检查类型", example = "2")
    private Integer checkType;

    @Schema(description = "时段")
    private Integer timeSlot;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·")
    private Integer queueNo;

    @Schema(description = "该时段 vip åºå·")
    private Integer queueVipNo;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·æ»¡")
    private Integer queueFull;

    @Schema(description = "该时段 vip åºå·æ»¡")
    private Integer queueVipFull;

    @Schema(description = "创建时间")
    @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)
    private LocalDateTime[] createTime;

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/queuesequence/vo/QueueSequenceRespVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,47 @@
package cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo;

import io.swagger.v3.oas.annotations.media.Schema;
import lombok.*;
import java.util.*;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDateTime;
import com.alibaba.excel.annotation.*;

@Schema(description = "管理后台 - å½“天序号 Response VO")
@Data
@ExcelIgnoreUnannotated
public class QueueSequenceRespVO {

    @Schema(description = "DB ä¸»é”®", requiredMode = Schema.RequiredMode.REQUIRED, example = "11958")
    @ExcelProperty("DB ä¸»é”®")
    private Integer id;

    @Schema(description = "检查类型", example = "2")
    @ExcelProperty("检查类型")
    private Integer checkType;

    @Schema(description = "时段")
    @ExcelProperty("时段")
    private Integer timeSlot;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·")
    @ExcelProperty("该时段 æ™®é€šæ‚£è€… åºå·")
    private Integer queueNo;

    @Schema(description = "该时段 vip åºå·")
    @ExcelProperty("该时段 vip åºå·")
    private Integer queueVipNo;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·æ»¡")
    @ExcelProperty("该时段 æ™®é€šæ‚£è€… åºå·æ»¡")
    private Integer queueFull;

    @Schema(description = "该时段 vip åºå·æ»¡")
    @ExcelProperty("该时段 vip åºå·æ»¡")
    private Integer queueVipFull;

    @Schema(description = "创建时间", requiredMode = Schema.RequiredMode.REQUIRED)
    @ExcelProperty("创建时间")
    private LocalDateTime createTime;

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/queuesequence/vo/QueueSequenceSaveReqVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,32 @@
package cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo;

import io.swagger.v3.oas.annotations.media.Schema;
import lombok.*;
import java.util.*;

@Schema(description = "管理后台 - å½“天序号新增/修改 Request VO")
@Data
public class QueueSequenceSaveReqVO {

    @Schema(description = "DB ä¸»é”®", requiredMode = Schema.RequiredMode.REQUIRED, example = "11958")
    private Integer id;

    @Schema(description = "检查类型", example = "2")
    private Integer checkType;

    @Schema(description = "时段")
    private Integer timeSlot;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·")
    private Integer queueNo;

    @Schema(description = "该时段 vip åºå·")
    private Integer queueVipNo;

    @Schema(description = "该时段 æ™®é€šæ‚£è€… åºå·æ»¡")
    private Integer queueFull;

    @Schema(description = "该时段 vip åºå·æ»¡")
    private Integer queueVipFull;

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/dataobject/queuesequence/QueueSequenceDO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,55 @@
package cn.lihu.jh.module.ecg.dal.dataobject.queuesequence;

import lombok.*;
import java.util.*;
import java.time.LocalDateTime;
import java.time.LocalDateTime;
import com.baomidou.mybatisplus.annotation.*;
import cn.lihu.jh.framework.mybatis.core.dataobject.BaseDO;

/**
 * å½“天序号 DO
 *
 * @author é‡‘华医院
 */
@TableName("queue_sequence")
@KeySequence("queue_sequence_seq") // ç”¨äºŽ Oracle、PostgreSQL、Kingbase、DB2、H2 æ•°æ®åº“的主键自增。如果是 MySQL ç­‰æ•°æ®åº“，可不写。
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class QueueSequenceDO extends BaseDO {

    /**
     * DB ä¸»é”®
     */
    @TableId
    private Integer id;
    /**
     * æ£€æŸ¥ç±»åž‹
     */
    private Integer checkType;
    /**
     * æ—¶æ®µ
     */
    private Integer timeSlot;
    /**
     * è¯¥æ—¶æ®µ æ™®é€šæ‚£è€… åºå·
     */
    private Integer queueNo;
    /**
     * è¯¥æ—¶æ®µ vip åºå·
     */
    private Integer queueVipNo;
    /**
     * è¯¥æ—¶æ®µ æ™®é€šæ‚£è€… åºå·æ»¡
     */
    private Integer queueFull;
    /**
     * è¯¥æ—¶æ®µ vip åºå·æ»¡
     */
    private Integer queueVipFull;

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queuesequence/QueueSequenceMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,32 @@
package cn.lihu.jh.module.ecg.dal.mysql.queuesequence;

import java.util.*;

import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.lihu.jh.framework.mybatis.core.mapper.BaseMapperX;
import cn.lihu.jh.module.ecg.dal.dataobject.queuesequence.QueueSequenceDO;
import org.apache.ibatis.annotations.Mapper;
import cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo.*;

/**
 * å½“天序号 Mapper
 *
 * @author é‡‘华医院
 */
@Mapper
public interface QueueSequenceMapper extends BaseMapperX<QueueSequenceDO> {

    default PageResult<QueueSequenceDO> selectPage(QueueSequencePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<QueueSequenceDO>()
                .eqIfPresent(QueueSequenceDO::getCheckType, reqVO.getCheckType())
                .eqIfPresent(QueueSequenceDO::getTimeSlot, reqVO.getTimeSlot())
                .eqIfPresent(QueueSequenceDO::getQueueNo, reqVO.getQueueNo())
                .eqIfPresent(QueueSequenceDO::getQueueVipNo, reqVO.getQueueVipNo())
                .eqIfPresent(QueueSequenceDO::getQueueFull, reqVO.getQueueFull())
                .eqIfPresent(QueueSequenceDO::getQueueVipFull, reqVO.getQueueVipFull())
                .betweenIfPresent(QueueSequenceDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(QueueSequenceDO::getId));
    }

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queuesequence/QueueSequenceService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,56 @@
package cn.lihu.jh.module.ecg.service.queuesequence;

import java.util.*;
import cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo.*;
import cn.lihu.jh.module.ecg.dal.dataobject.queuesequence.QueueSequenceDO;
import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.common.pojo.PageParam;

import javax.validation.Valid;

/**
 * å½“天序号 Service æŽ¥å£
 *
 * @author é‡‘华医院
 */
public interface QueueSequenceService {

    /**
     * åˆ›å»ºå½“天序号
     *
     * @param createReqVO åˆ›å»ºä¿¡æ¯
     * @return ç¼–号
     */
    Integer createQueueSequence(@Valid QueueSequenceSaveReqVO createReqVO);

    /**
     * æ›´æ–°å½“天序号
     *
     * @param updateReqVO æ›´æ–°ä¿¡æ¯
     */
    void updateQueueSequence(@Valid QueueSequenceSaveReqVO updateReqVO);

    /**
     * åˆ é™¤å½“天序号
     *
     * @param id ç¼–号
     */
    void deleteQueueSequence(Integer id);

    /**
     * èŽ·å¾—当天序号
     *
     * @param id ç¼–号
     * @return å½“天序号
     */
    QueueSequenceDO getQueueSequence(Integer id);

    /**
     * èŽ·å¾—当天序号分页
     *
     * @param pageReqVO åˆ†é¡µæŸ¥è¯¢
     * @return å½“天序号分页
     */
    PageResult<QueueSequenceDO> getQueueSequencePage(QueueSequencePageReqVO pageReqVO);

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/service/queuesequence/QueueSequenceServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,75 @@
package cn.lihu.jh.module.ecg.service.queuesequence;

import org.springframework.stereotype.Service;
import org.springframework.validation.annotation.Validated;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;
import cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo.*;
import cn.lihu.jh.module.ecg.dal.dataobject.queuesequence.QueueSequenceDO;
import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.common.pojo.PageParam;
import cn.lihu.jh.framework.common.util.object.BeanUtils;

import cn.lihu.jh.module.ecg.dal.mysql.queuesequence.QueueSequenceMapper;

import javax.annotation.Resource;

import static cn.lihu.jh.framework.common.exception.util.ServiceExceptionUtil.exception;
import static cn.lihu.jh.module.ecg.enums.ErrorCodeConstants.*;

/**
 * å½“天序号 Service å®žçŽ°ç±»
 *
 * @author é‡‘华医院
 */
@Service
@Validated
public class QueueSequenceServiceImpl implements QueueSequenceService {

    @Resource
    private QueueSequenceMapper queueSequenceMapper;

    @Override
    public Integer createQueueSequence(QueueSequenceSaveReqVO createReqVO) {
        // æ’å…¥
        QueueSequenceDO queueSequence = BeanUtils.toBean(createReqVO, QueueSequenceDO.class);
        queueSequenceMapper.insert(queueSequence);
        // è¿”回
        return queueSequence.getId();
    }

    @Override
    public void updateQueueSequence(QueueSequenceSaveReqVO updateReqVO) {
        // æ ¡éªŒå­˜åœ¨
        validateQueueSequenceExists(updateReqVO.getId());
        // æ›´æ–°
        QueueSequenceDO updateObj = BeanUtils.toBean(updateReqVO, QueueSequenceDO.class);
        queueSequenceMapper.updateById(updateObj);
    }

    @Override
    public void deleteQueueSequence(Integer id) {
        // æ ¡éªŒå­˜åœ¨
        validateQueueSequenceExists(id);
        // åˆ é™¤
        queueSequenceMapper.deleteById(id);
    }

    private void validateQueueSequenceExists(Integer id) {
        if (queueSequenceMapper.selectById(id) == null) {
            throw exception(QUEUE_SEQUENCE_NOT_EXISTS);
        }
    }

    @Override
    public QueueSequenceDO getQueueSequence(Integer id) {
        return queueSequenceMapper.selectById(id);
    }

    @Override
    public PageResult<QueueSequenceDO> getQueueSequencePage(QueueSequencePageReqVO pageReqVO) {
        return queueSequenceMapper.selectPage(pageReqVO);
    }

}

 jh-module-ecg/jh-module-ecg-biz/src/main/resources/mapper/queuesequence/QueueSequenceMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
<?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="cn.lihu.jh.module.ecg.dal.mysql.queuesequence.QueueSequenceMapper">

    <!--
        ä¸€èˆ¬æƒ…况下，尽可能使用 Mapper è¿›è¡Œ CRUD å¢žåˆ æ”¹æŸ¥å³å¯ã€‚
        æ— æ³•æ»¡è¶³çš„场景，例如说多表关联查询，才使用 XML ç¼–写 SQL。
        ä»£ç ç”Ÿæˆå™¨æš‚时只生成 Mapper XML æ–‡ä»¶æœ¬èº«ï¼Œæ›´å¤šæŽ¨è MybatisX å¿«é€Ÿå¼€å‘插件来生成查询。
        æ–‡æ¡£å¯è§ï¼šhttps://www.iocoder.cn/MyBatis/x-plugins/
     -->

</mapper>