尚医通 (五) --------- 医院模块

ゝ一纸荒年。 2024-04-01 15:53 114阅读 0赞

#### 目录 ####

*  一、需求
 *  二、表结构
 *  三、医院模块开发
 *   *  1. 搭建医院模块 service-hosp
     *  2. 添加医院设置 CRUD
 *  四、医院锁定与解锁
 *  五、发送签名 key

--------------------

## 一、需求 ##

医院设置主要是用来保存开通医院的一些基本信息，每个医院一条信息，保存了医院编号 (平台分配，全局唯一) 和 接口调用相关的签名 key 等信息，是整个流程的第一步，只有开通了医院设置信息，才可以上传医院相关信息。

我们所开发的功能就是基于单表的一个 CRUD、锁定/解锁和发送签名信息这些基本功能。

## 二、表结构 ##

![在这里插入图片描述][3cd652897d2d41a5a4bb8ca23e06061c.png]

*  hosname ：医院名称
 *  hoscode ：医院编号 (平台分配，全局唯一，api接口必填信息)
 *  api\_url ：医院回调的基础 url (如：预约下单，我们要调用该地址去医院下单)
 *  sign\_key ：双方 api 接口调用的签名 key，由平台生成
 *  contacts\_name：医院联系人姓名
 *  contacts\_phone：医院联系人手机
 *  status ：状态 (锁定/解锁)

## 三、医院模块开发 ##

### 1. 搭建医院模块 service-hosp ###

**A、搭建 service-hosp**

点击 service，选择 New–>Module ，操作如下

![在这里插入图片描述][b6b3f52366d54a0c8c40a0efb9de4e41.png]

点击 create ，结构如下

![在这里插入图片描述][00effb42e10e48a69b7e016e75bbad47.png]

**B、修改配置**

修改 pom.xml

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <parent>
            <artifactId>service</artifactId>
            <groupId>com.fancy.yygh</groupId>
            <version>1.0</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <version>1.0</version>
        <artifactId>service-hosp</artifactId>
        <packaging>jar</packaging>
        <name>service-hosp</name>
        <description>service-hosp</description>
    
        <dependencies>
        </dependencies>
    
        <build>
            <finalName>service-hosp</finalName>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

添加配置文件 application.properties

# 服务端口
    server.port=8201
    # 服务名
    spring.application.name=service-hosp
    
    # 环境设置：dev、test、prod
    spring.profiles.active=dev
    
    # mysql数据库连接
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://192.168.38.130:3306/yygh_hosp?characterEncoding=utf-8&useSSL=false
    spring.datasource.username=root
    spring.datasource.password=aszhuo123
    
    #返回json的全局时间格式
    spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
    spring.jackson.time-zone=GMT+8
    
    #配置mapper xml文件的路径
    #mybatis-plus.mapper-locations=classpath:com/fancy/yygh/mapper/xml/*.xml
    mybatis-plus.mapper-locations=classpath:com/fancy/yygh/mapper/xml/*.xml
    # nacos服务地址
    spring.cloud.nacos.discovery.server-addr=127.0.0.1:8848
    
    #开启sentinel
    feign.sentinel.enabled=true
    #设置sentinel地址
    spring.cloud.sentinel.transport.dashboard=http://127.0.0.1:8858
    
    #mongodb地址
    spring.data.mongodb.host=192.168.38.131
    spring.data.mongodb.port=27017
    spring.data.mongodb.database=yygh_hosp
    
    #rabbitmq地址
    spring.rabbitmq.host=127.0.0.1
    spring.rabbitmq.port=5672
    spring.rabbitmq.username=guest
    spring.rabbitmq.password=guest

**C、添加启动类**

package com.fancy.yygh;
    
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class ServiceHospitalApplication {
        
        public static void main(String[] args) {
        
            SpringApplication.run(ServiceHospitalApplication.class, args);
        }
    }

### 2. 添加医院设置 CRUD ###

**A、添加 model**

说明：由于实体对象没有逻辑，我们已经统一导入`com.fancy.yygh.model.hosp.HospitalSet`

**B、添加 Mapper**

添加 `com.fancy.yygh.hosp.mapper.HospitalSetMapper`

package com.fancy.yygh.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.fancy.yygh.model.hosp.HospitalSet;
    import org.apache.ibatis.annotations.Mapper;
    import org.mybatis.spring.annotation.MapperScan;
    
    @Mapper
    public interface HospitalSetMapper extends BaseMapper<HospitalSet> {
        
    }

**C、在 resoucre/mapper 下添加 HospitalSetMapper.xml**

<?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.fancy.yygh.hosp.mapper.HospitalSetMapper">
    </mapper>

**C、添加 service 接口及实现类**

添加com.fancy.yygh.hosp.service.HospitalSetService 接口

package com.fancy.yygh.hosp.service;
    
    import com.baomidou.mybatisplus.extension.service.IService;
    
    public interface HospitalSetService extends IService<HospitalSet> {
        
    }

添加 com.fancy.yygh.hosp.service.impl.HospitalSetServiceImpl 接口实现

package com.fancy.yygh.hosp.service.impl;
    
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import com.fancy.yygh.hosp.mapper.HospitalSetMapper;
    import com.fancy.yygh.hosp.service.HospitalSetService;
    import com.fancy.yygh.model.hosp.HospitalSet;
    import org.springframework.beans.factory.annotation.Autowired;
    
    public class HospitalSetServiceImpl extends ServiceImpl<HospitalSetMapper, HospitalSet> implements HospitalSetService {
        
        @Autowired
        private HospitalSetMapper hospitalSetMapper;
    }

**D、添加 controller**

package com.fancy.yygh.hosp.controller;
    
    
    import com.fancy.yygh.hosp.service.HospitalSetService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    @RequestMapping("/admin/hosp/hospitalSet")
    public class HospitalSetController {
        
        @Autowired
        HospitalSetService hospitalSetService;
    }

**F、医院设置 CRUD**

由于com.baomidou.mybatisplus.extension.service.impl.ServiceImpl类已经默认实现了单表的CRUD，分页查询也有默认实现，能够更加灵活和代码简洁把分页查询功能实现。、

**G、添加 controller 方法**

package com.fancy.yygh.hosp.controller;
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.fancy.yygh.common.result.Result;
    import com.fancy.yygh.common.util.MD5;
    import com.fancy.yygh.hosp.service.HospitalSetService;
    import com.fancy.yygh.model.hosp.HospitalSet;
    import com.fancy.yygh.vo.hosp.HospitalSetQueryVo;
    import io.swagger.annotations.Api;
    import io.swagger.annotations.ApiOperation;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.util.StringUtils;
    import org.springframework.web.bind.annotation.*;
    
    import java.util.List;
    import java.util.Random;
    
    @Api(tags = "医院设置管理")
    @RestController
    @RequestMapping("/admin/hosp/hospitalSet")
    public class HospitalSetController {
        
        @Autowired
        HospitalSetService hospitalSetService;
    
        // 1. 查询医院设置表的所有信息
        @ApiOperation(value = "获取所有医院设置")
        @GetMapping("findAll")
        public Result findAllHostpitalSet() {
        
            // 调用 service 方法
            List<HospitalSet> list = hospitalSetService.list();
            return Result.ok(list);
        }
    
        //2 逻辑删除医院设置
        @ApiOperation(value = "逻辑删除医院设置")
        @DeleteMapping("{id}")
        public Result removeHospSet(@PathVariable Long id) {
        
            boolean flag = hospitalSetService.removeById(id);
            if(flag) {
        
                return Result.ok();
            } else {
        
                return Result.fail();
            }
        }
    
        //3 条件查询带分页
        @PostMapping("findPageHospSet/{current}/{limit}")
        public Result findPageHospSet(@PathVariable long current,
                                      @PathVariable long limit,
                                      @RequestBody
                                              (required = false)HospitalSetQueryVo hospitalSetQueryVo) {
        
            //创建page对象，传递当前页，每页记录数
            Page<HospitalSet> page = new Page<>(current,limit);
            //构建条件
            QueryWrapper<HospitalSet> wrapper = new QueryWrapper<>();
            String hosname = hospitalSetQueryVo.getHosname();//医院名称
            String hoscode = hospitalSetQueryVo.getHoscode();//医院编号
            if(!StringUtils.isEmpty(hosname)) {
        
                wrapper.like("hosname",hospitalSetQueryVo.getHosname());
            }
            if(!StringUtils.isEmpty(hoscode)) {
        
                wrapper.eq("hoscode",hospitalSetQueryVo.getHoscode());
            }
            //调用方法实现分页查询
            Page<HospitalSet> pageHospitalSet = hospitalSetService.page(page, wrapper);
            //返回结果
            return Result.ok(pageHospitalSet);
        }
    
        //4 添加医院设置
        @PostMapping("saveHospitalSet")
        public Result saveHospitalSet(@RequestBody HospitalSet hospitalSet) {
        
            //设置状态 1 使用 0 不能使用
            hospitalSet.setStatus(1);
            //签名秘钥
            Random random = new Random();
            hospitalSet.setSignKey(MD5.encrypt(System.currentTimeMillis()+""+random.nextInt(1000)));
            //调用service
            boolean save = hospitalSetService.save(hospitalSet);
            if(save) {
        
                return Result.ok();
            } else {
        
                return Result.fail();
            }
        }
    
        //5 根据id获取医院设置
        @GetMapping("getHospSet/{id}")
        public Result getHospSet(@PathVariable Long id) {
        
            HospitalSet hospitalSet = hospitalSetService.getById(id);
            return Result.ok(hospitalSet);
        }
    
        //6 修改医院设置
        @PostMapping("updateHospitalSet")
        public Result updateHospitalSet(@RequestBody HospitalSet hospitalSet) {
        
            boolean flag = hospitalSetService.updateById(hospitalSet);
            if(flag) {
        
                return Result.ok();
            } else {
        
                return Result.fail();
            }
        }
    
        //7 批量删除医院设置
        @DeleteMapping("batchRemove")
        public Result batchRemoveHospitalSet(@RequestBody List<Long> idList) {
        
            hospitalSetService.removeByIds(idList);
            return Result.ok();
        }
    
    }

这里用到了统一返回结果，定义如下：

package com.fancy.yygh.common.result;
    
    import io.swagger.annotations.ApiModel;
    import io.swagger.annotations.ApiModelProperty;
    import lombok.Data;
    
    /**
     * 全局统一返回结果类
     */
    @Data
    @ApiModel(value = "全局统一返回结果")
    public class Result<T> {
        
    
        @ApiModelProperty(value = "返回码")
        private Integer code;
    
        @ApiModelProperty(value = "返回消息")
        private String message;
    
        @ApiModelProperty(value = "返回数据")
        private T data;
    
        public Result(){
        }
    
        protected static <T> Result<T> build(T data) {
        
            Result<T> result = new Result<T>();
            if (data != null)
                result.setData(data);
            return result;
        }
    
        public static <T> Result<T> build(T body, ResultCodeEnum resultCodeEnum) {
        
            Result<T> result = build(body);
            result.setCode(resultCodeEnum.getCode());
            result.setMessage(resultCodeEnum.getMessage());
            return result;
        }
    
        public static <T> Result<T> build(Integer code, String message) {
        
            Result<T> result = build(null);
            result.setCode(code);
            result.setMessage(message);
            return result;
        }
    
        public static<T> Result<T> ok(){
        
            return Result.ok(null);
        }
    
        /**
         * 操作成功
         * @param data
         * @param <T>
         * @return
         */
        public static<T> Result<T> ok(T data){
        
            Result<T> result = build(data);
            return build(data, ResultCodeEnum.SUCCESS);
        }
    
        public static<T> Result<T> fail(){
        
            return Result.fail(null);
        }
    
        /**
         * 操作失败
         * @param data
         * @param <T>
         * @return
         */
        public static<T> Result<T> fail(T data){
        
            Result<T> result = build(data);
            return build(data, ResultCodeEnum.FAIL);
        }
    
        public Result<T> message(String msg){
        
            this.setMessage(msg);
            return this;
        }
    
        public Result<T> code(Integer code){
        
            this.setCode(code);
            return this;
        }
    
        public boolean isOk() {
        
            if(this.getCode().intValue() == ResultCodeEnum.SUCCESS.getCode().intValue()) {
        
                return true;
            }
            return false;
        }
    }

这样一个完整的 CRUD 就完成了。。。

## 四、医院锁定与解锁 ##

医院锁定后不能再上传数据。。。

**添加 controller 方法**

在 HospitalSetController 类添加方法

//8 医院设置锁定和解锁
    @PutMapping("lockHospitalSet/{id}/{status}")
    public Result lockHospitalSet(@PathVariable Long id,
                                  @PathVariable Integer status) {
        
        //根据id查询医院设置信息
        HospitalSet hospitalSet = hospitalSetService.getById(id);
        //设置状态
        hospitalSet.setStatus(status);
        //调用方法
        hospitalSetService.updateById(hospitalSet);
        return Result.ok();
    }

## 五、发送签名 key ##

医院信息配置后，可以通过短信的形式发送医院编号与签名 key 给联系人，联系人拿到该信息就可以参考《尚医通 API 接口文档.docx》对接接口了。

**添加 controller 方法**

在 HospitalSetController 类添加方法

//9 发送签名秘钥
    @PutMapping("sendKey/{id}")
    public Result lockHospitalSet(@PathVariable Long id) {
        
        HospitalSet hospitalSet = hospitalSetService.getById(id);
        String signKey = hospitalSet.getSignKey();
        String hoscode = hospitalSet.getHoscode();
        //TODO 发送短信
        return Result.ok();
    }

[3cd652897d2d41a5a4bb8ca23e06061c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/3b0a454a674344898e98a3c2e5975a0d.png
[b6b3f52366d54a0c8c40a0efb9de4e41.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/9ecc451948124c989a15d68417d92c3e.png
[00effb42e10e48a69b7e016e75bbad47.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/6eb1808844f54080af5a658e44b3fe87.png