云医疗平台_查询排班科室-【官方】百战程序员_IT在线教育培训机构

序号	接口名称	接口地址	请求类型
1	查询出所有的排班的部门列表	/doctor/registration/listDeptForScheduling	get
2	根据患者身份证号查患者信息	/doctor/registration/getPatientByIdCard/{idCard}	get
3	挂号	/doctor/registration/addRegistration	post
4	收挂号费	/doctor/registration/collectFee/{regId}	post

查询所有排班的部门列表

接口参数

参数名称	是否必须
schedulingDay	是
schedulingType	是
subsectionType	是

返回JSON数据

名称	类型	其他信息
msg	String
code	int
data	object []	item 类型: object
├─ deptId	int
├─ deptName	String
├─ regNumber	int
├─ deptNumber	String
├─ orderNum	int
├─ deptLeader	String
├─ leaderPhone	String
├─ status	String
├─ createTime	String
├─ updateTime	String
├─ createBy	String
├─ updateBy	String

接口实现

创建实体类

挂号值对象


xxxxxxxxxx
package com.bjsxt.dto;

import ...

/**
* 
*/

@ApiModel(value="com-bjsxt-dto-RegistrationDto")
@Data
@EqualsAndHashCode(callSuper=true)
@AllArgsConstructor
@NoArgsConstructor
public class RegistrationDto extends BaseDto {
    /**
     * 挂号流水
     */
    @ApiModelProperty(value="挂号流水")
    private String regId;

    /**
     * 患者ID
     */
    @NotBlank(message = "患者ID不能为空")
    @ApiModelProperty(value="患者ID")
    private String patientId;

    /**
     * 患者姓名
     */
    @NotBlank(message = "患者姓名不能为空")
    @ApiModelProperty(value="患者姓名")
    private String patientName;

    /**
     * 接诊医生ID
     */
    @ApiModelProperty(value="接诊医生ID")
    private Long userId;

    /**
     * 接诊医生姓名
     */
    @ApiModelProperty(value="接诊医生姓名")
    private String doctorName;

    /**
     * 科室ID
     */
    @NotBlank(message = "科室ID不能为空")
    @ApiModelProperty(value="科室ID")
    private Long deptId;

    /**
     * 挂号费用ID
     */
    @NotNull(message = "挂号费用ID不能为空")
    @ApiModelProperty(value="挂号费用ID")
    private Long regItemId;

    /**
     * 挂号总金额
     */
    @NotNull(message = "挂号总金额不能为空")
    @ApiModelProperty(value="挂号总金额")
    private BigDecimal regItemAmount;

    /**
     * 挂号编号
     */
    @ApiModelProperty(value="挂号编号")
    private Integer regNumber;

    /**
     * 挂号状态0未收费,1待就诊，2,就诊中，3，就诊完成，4，已退号，5 作废
     */
    @ApiModelProperty(value="挂号状态0未收费,1待就诊，2,就诊中，3，就诊完成，4，已退号，5 作废")
    private String regStatus;

    /**
     * 就诊日期
     */
    @NotBlank(message = "就诊日期不能为空")
    @ApiModelProperty(value="就诊日期")
    private String visitDate;

    /**
     * 排班类型1 门诊 2 急诊 字典表数据翻译
     */
    @NotBlank(message = "排班类型不能为空")
    @ApiModelProperty(value="排班类型1 门诊 2 急诊 字典表数据翻译")
    private String schedulingType;

    /**
     * 排班时段1上午  2下午 3晚上 字典表数据翻译
     */
    @NotBlank(message = "排班时段不能为空")
    @ApiModelProperty(value="排班时段1上午  2下午 3晚上 字典表数据翻译")
    private String subsectionType;
}


xxxxxxxxxx
package com.bjsxt.dto;

import io.swagger.annotations.ApiModel;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/**
 * 
 */
@ApiModel(value="com-bjsxt-dto-RegistrationFormDto")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class RegistrationFormDto implements Serializable {

    private PatientDto patientDto;

    private RegistrationDto registrationDto;
}


xxxxxxxxxx
package com.bjsxt.dto;

import io.swagger.annotations.ApiModel;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import javax.validation.constraints.NotBlank;
import java.io.Serializable;

/**
 * 
 */
@ApiModel(value="com-bjsxt-dto-RegistrationQueryDto")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class RegistrationQueryDto implements Serializable {
    private Long deptId;//科室ID
    @NotBlank(message = "挂号类型不能为空")
    private String schedulingType;//挂号类型
    @NotBlank(message = "挂号时段不能为空")
    private String subsectionType;//挂号时段
    @NotBlank(message = "挂号日期不能为空")
    private String schedulingDay;//排班时间
}

创建映射类


xxxxxxxxxx
package com.bjsxt.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bjsxt.domain.Registration;

/**
* 
*/

public interface RegistrationMapper extends BaseMapper<Registration> {
}


xxxxxxxxxx
<?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.bjsxt.mapper.RegistrationMapper">
  <resultMap id="BaseResultMap" type="com.bjsxt.domain.Registration">
    <!--@mbg.generated-->
    <!--@Table his_registration-->
    <id column="reg_id" jdbcType="VARCHAR" property="regId" />
    <result column="patient_id" jdbcType="VARCHAR" property="patientId" />
    <result column="patient_name" jdbcType="VARCHAR" property="patientName" />
    <result column="user_id" jdbcType="BIGINT" property="userId" />
    <result column="doctor_name" jdbcType="VARCHAR" property="doctorName" />
    <result column="dept_id" jdbcType="BIGINT" property="deptId" />
    <result column="registration_item_id" jdbcType="BIGINT" property="regItemId" />
    <result column="registration_item_amount" jdbcType="DECIMAL" property="regItemAmount" />
    <result column="registration_number" jdbcType="INTEGER" property="regNumber" />
    <result column="registration_status" jdbcType="CHAR" property="regStatus" />
    <result column="visit_date" jdbcType="VARCHAR" property="visitDate" />
    <result column="scheduling_type" jdbcType="CHAR" property="schedulingType" />
    <result column="subsection_type" jdbcType="CHAR" property="subsectionType" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
    <result column="create_by" jdbcType="VARCHAR" property="createBy" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--@mbg.generated-->
    reg_id, patient_id, patient_name, user_id, doctor_name, dept_id, reg_item_id, reg_item_amount, 
    reg_number, reg_status, visit_date, scheduling_type, subsection_type, create_time, 
    update_time, create_by
  </sql>
</mapper>


xxxxxxxxxx
package com.bjsxt.service.impl;

import ...

/**
* 
*/

@Service
public class RegistrationServiceImpl implements RegistrationService{

    @Autowired
    private RegistrationMapper registrationMapper;

    @Override
    public void addRegistration(RegistrationDto registrationDto) {
        Registration registration=new Registration();
        BeanUtil.copyProperties(registrationDto,registration);
        registration.setRegStatus(Constants.REG_STATUS_0);//挂号添加为未收费
        registration.setCreateBy(registrationDto.getSimpleUser().getUserName());
        registration.setCreateTime(DateUtil.date());
        this.registrationMapper.insert(registration);
    }

    @Override
    public Registration queryRegistrationByRegId(String regId) {
        return this.registrationMapper.selectById(regId);
    }

    @Override
    public int updateRegistrationByRegId(Registration registration) {
        return this.registrationMapper.updateById(registration);
    }

    @Override
    public DataGridView queryRegistrationForPage(RegistrationDto registrationDto) {
        Page<Registration> page=new Page<>(registrationDto.getPageNum(),registrationDto.getPageSize());
        QueryWrapper<Registration> qw=new QueryWrapper<>();
        qw.eq(registrationDto.getDeptId()!=null,Registration.COL_DEPT_ID,
              registrationDto.getDeptId());
        qw.like(StringUtils.isNotBlank(registrationDto.getPatientName()),
                Registration.COL_PATIENT_NAME,registrationDto.getPatientName());
        qw.eq(StringUtils.isNotBlank(registrationDto.getSchedulingType()),
              Registration.COL_SCHEDULING_TYPE,registrationDto.getSchedulingType());
        qw.eq(StringUtils.isNotBlank(registrationDto.getSubsectionType()),
              Registration.COL_SUBSECTION_TYPE,registrationDto.getSubsectionType());
        qw.eq(StringUtils.isNotBlank(registrationDto.getRegStatus()),
              Registration.COL_REG_STATUS,registrationDto.getRegStatus());
        qw.eq(StringUtils.isNotBlank(registrationDto.getVisitDate()),
              Registration.COL_VISIT_DATE,registrationDto.getVisitDate());
        qw.orderByDesc(Registration.COL_CREATE_TIME);
        this.registrationMapper.selectPage(page,qw);
        return new DataGridView(page.getTotal(),page.getRecords());
    }

    /**
     * 根据条件查询挂号信息
     * @param deptId 部门
     * @param subsectionType  时段
     * @param scheudlingType  类型  门诊 急诊
     * @param regStatus    挂号单状态
     * @param userId   医生ID
     * @return
     */
    @Override
    public List<Registration> queryRegistration(Long deptId, String subsectionType, String scheudlingType, String regStatus, Long userId) {
        QueryWrapper<Registration> qw=new QueryWrapper<>();
        qw.eq(Registration.COL_DEPT_ID,deptId);
        qw.eq(StringUtils.isNotBlank(subsectionType),
              Registration.COL_SUBSECTION_TYPE,subsectionType);
        qw.eq(Registration.COL_SCHEDULING_TYPE,scheudlingType);
        qw.eq(Registration.COL_REG_STATUS,regStatus);
        qw.eq(Registration.COL_VISIT_DATE,DateUtil.format(DateUtil.date(),"yyyy-MM-dd"));
        qw.eq(null!=userId,Registration.COL_USER_ID,userId);
        qw.orderByAsc(Registration.COL_REG_NUMBER);
        return this.registrationMapper.selectList(qw);
    }
}

排班相关修改

在SchedulingService中增加相关方法


xxxxxxxxxx
/**
     * 根据条件查询有号的部门编号
     * @param deptId
     * @param schedulingDay
     * @param schedulingType
     * @param subsectionType
     * @return
     */
    List<Long> queryHasSchedulingDeptIds(Long deptId, String schedulingDay, String schedulingType, String subsectionType);

修改SchedulingServiceImple，调用下面的方法


xxxxxxxxxx
package com.bjsxt.service.impl;

import cn.hutool.core.date.DateTime;
import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.bjsxt.domain.Scheduling;
import com.bjsxt.dto.SchedulingFormDto;
import com.bjsxt.dto.SchedulingQueryDto;
import com.bjsxt.mapper.SchedulingMapper;
import com.bjsxt.service.SchedulingService;
import org.apache.commons.lang3.StringUtils;
import org.apache.dubbo.config.annotation.Service;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.ArrayList;
import java.util.List;

@Service
public class SchedulingServiceImpl implements SchedulingService{

    @Autowired
    private SchedulingMapper schedulingMapper;

    /**
     * 根据条件查询有号的部门编号
     * @param deptId
     * @param schedulingDay
     * @param schedulingType
     * @param subsectionType
     * @return
     */
    @Override
    public List<Long> queryHasSchedulingDeptIds(Long deptId, String schedulingDay, String schedulingType, String subsectionType) {
        return this.schedulingMapper.queryHasSchedulingDeptIds(deptId,schedulingDay,schedulingType,subsectionType);
    }
}

修改SchedulingMapper


xxxxxxxxxx
/**
     * 根据条件查询有号的部门编号
     *
     * @param deptId
     * @param schedulingDay
     * @param schedulingType
     * @param subsectionType
     * @return
     */
    List<Long> queryHasSchedulingDeptIds(@Param("deptId") Long deptId, @Param("schedulingDay") String schedulingDay, @Param("schedulingType") String schedulingType, @Param("subsectionType") String subsectionType);

修改SchedulingMapper.xml，增加相关查询


xxxxxxxxxx
<select id="queryHasSchedulingDeptIds" resultType="java.lang.Long">
    select dept_id from his_scheduling
        <where>
            <if test="deptId != null">
                 dept_id=#{deptId}
            </if>
            <if test="schedulingDay != null">
                and scheduling_day=#{schedulingDay}
            </if>
            <if test="schedulingType != null">
              and scheduling_type=#{schedulingType}
            </if>
            <if test="subsectionType != null">
              and subsection_type=#{subsectionType}
            </if>
        </where>
    </select>

部门查询相关修改

修改DeptService


xxxxxxxxxx
/**
* 根据部门 ID 查询部门信息
* @param deptIds
* @return
*/
List<Dept> listDeptByDeptIds(List<Long> deptIds);

修改DeptServiceImpl


xxxxxxxxxx
@Override
public List<Dept> listDeptByDeptIds(List<Long> deptIds) {
    QueryWrapper<Dept> qw=new QueryWrapper<>();
    qw.in(Dept.COL_DEPT_ID,deptIds);
    return this.deptMapper.selectList(qw);
}
@Override
public void updateDeptRegNumber(Long deptId, Integer regNumber) {
    Dept dept=new Dept();
    dept.setDeptId(deptId);
    dept.setRegNumber(regNumber);
    this.deptMapper.updateById(dept);
}

创建controller


xxxxxxxxxx
package com.bjsxt.controller.doctor;

import ...

/**
 * 
 */
@RestController
@RequestMapping("doctor/registration")
public class RegistrationController {


    @Reference
    private SchedulingService schedulingService;

    @Autowired
    private DeptService deptService;

    @Reference
    private PatientService patientService;

    @Reference
    private RegistrationService registrationService;
    /**
     * 查询出所有的排班的部门列表
     * 1.从排班表里面查询有排班的部门编号集合
     * 2.根据查询出来的部门编号集合再去查询部门
     */
    @GetMapping("listDeptForScheduling")
    public AjaxResult listDeptForScheduling(@Validated RegistrationQueryDto registrationQueryDto){
        Long deptId = registrationQueryDto.getDeptId();
        String subsectionType = registrationQueryDto.getSubsectionType();
        String schedulingType = registrationQueryDto.getSchedulingType();//挂号类型
        String schedulingDay = registrationQueryDto.getSchedulingDay().substring(0,10);//时间
        List<Long> deptIds=schedulingService.
            queryHasSchedulingDeptIds(deptId,schedulingDay,                             schedulingType,subsectionType);
        if(null==deptIds||deptIds.size()==0){
            return AjaxResult.success(Collections.EMPTY_LIST);
        }else{
            List<Dept> list=this.deptService.listDeptByDeptIds(deptIds);
            return AjaxResult.success(list);
        }
    }
}

接口测试

查询出所有的排班的部门列表/doctor/registration/listDeptForScheduling

云医疗平台_库存查询云医疗平台_根据身份证号查询患者信息

北京市昌平区回龙观镇南店村综合商业楼2楼226室