新增 queue_sequence 表操作

eight

2024-11-07 134d92dab4033035e8ebe80b5d7c03468b40db38

新增 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 SEQUENCE_NOT_EXISTS = new ErrorCode(1_010_010_000, "当天序号不存在");
}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/queue/controller/admin/sequence/SequenceController.java

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

import org.springframework.web.bind.annotation.*;
import jakarta.annotation.Resource;
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 jakarta.validation.constraints.*;
import jakarta.validation.*;
import jakarta.servlet.http.*;
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.queue.controller.admin.sequence.vo.*;
import cn.lihu.jh.module.queue.dal.dataobject.sequence.SequenceDO;
import cn.lihu.jh.module.queue.service.sequence.SequenceService;

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

    @Resource
    private SequenceService sequenceService;

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

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

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

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

    @GetMapping("/page")
    @Operation(summary = "获得当天序号分页")
    @PreAuthorize("@ss.hasPermission('queue:sequence:query')")
    public CommonResult<PageResult<SequenceRespVO>> getSequencePage(@Valid SequencePageReqVO pageReqVO) {
        PageResult<SequenceDO> pageResult = sequenceService.getSequencePage(pageReqVO);
        return success(BeanUtils.toBean(pageResult, SequenceRespVO.class));
    }

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

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/queue/controller/admin/sequence/vo/SequencePageReqVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,40 @@
package cn.lihu.jh.module.queue.controller.admin.sequence.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 SequencePageReqVO 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/queue/controller/admin/sequence/vo/SequenceRespVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,47 @@
package cn.lihu.jh.module.queue.controller.admin.sequence.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 SequenceRespVO {

    @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/queue/controller/admin/sequence/vo/SequenceSaveReqVO.java

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

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

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

    @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/queue/dal/dataobject/sequence/SequenceDO.java

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

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 SequenceDO 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/queue/dal/mysql/sequence/SequenceMapper.java

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

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.queue.dal.dataobject.sequence.SequenceDO;
import org.apache.ibatis.annotations.Mapper;
import cn.lihu.jh.module.queue.controller.admin.sequence.vo.*;

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

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

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/queue/service/sequence/SequenceService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,55 @@
package cn.lihu.jh.module.queue.service.sequence;

import java.util.*;
import jakarta.validation.*;
import cn.lihu.jh.module.queue.controller.admin.sequence.vo.*;
import cn.lihu.jh.module.queue.dal.dataobject.sequence.SequenceDO;
import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.common.pojo.PageParam;

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

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

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

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

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

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

}

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/queue/service/sequence/SequenceServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,74 @@
package cn.lihu.jh.module.queue.service.sequence;

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

import java.util.*;
import cn.lihu.jh.module.queue.controller.admin.sequence.vo.*;
import cn.lihu.jh.module.queue.dal.dataobject.sequence.SequenceDO;
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.queue.dal.mysql.sequence.SequenceMapper;

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

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

    @Resource
    private SequenceMapper sequenceMapper;

    @Override
    public Integer createSequence(SequenceSaveReqVO createReqVO) {
        // æ’å…¥
        SequenceDO sequence = BeanUtils.toBean(createReqVO, SequenceDO.class);
        sequenceMapper.insert(sequence);
        // è¿”回
        return sequence.getId();
    }

    @Override
    public void updateSequence(SequenceSaveReqVO updateReqVO) {
        // æ ¡éªŒå­˜åœ¨
        validateSequenceExists(updateReqVO.getId());
        // æ›´æ–°
        SequenceDO updateObj = BeanUtils.toBean(updateReqVO, SequenceDO.class);
        sequenceMapper.updateById(updateObj);
    }

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

    private void validateSequenceExists(Integer id) {
        if (sequenceMapper.selectById(id) == null) {
            throw exception(SEQUENCE_NOT_EXISTS);
        }
    }

    @Override
    public SequenceDO getSequence(Integer id) {
        return sequenceMapper.selectById(id);
    }

    @Override
    public PageResult<SequenceDO> getSequencePage(SequencePageReqVO pageReqVO) {
        return sequenceMapper.selectPage(pageReqVO);
    }

}

 jh-module-ecg/jh-module-ecg-biz/src/main/resources/mapper/sequence/SequenceMapper.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.queue.dal.mysql.sequence.SequenceMapper">

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

</mapper>