云医疗平台_查询退费列表-【官方】百战程序员_IT在线教育培训机构

名称	类型	其他信息
msg	String
total	int
code	int
data	object []	item 类型: object
├─ backId	String
├─ backAmount	int
├─ chId	String
├─ regId	String
├─ patientName	String
├─ backStatus	String
├─ backType	String
├─ orderId	String
├─ backPlatformId	String
├─ backTime	String
├─ createTime	String
├─ updateTime	String
├─ createBy	String
├─ updateBy	String

接口实现

创建实体类

创建OrderBackfeeDto、OrderBackfee


xxxxxxxxxx
package com.bjsxt.dto;

import ...

@ApiModel(value="com-bjsxt-dto-OrderBackfeeDto")
@Data
@EqualsAndHashCode(callSuper=true)
@AllArgsConstructor
@NoArgsConstructor
public class OrderBackfeeDto extends BaseDto {
    /**
     * 退费ID
     */
    @ApiModelProperty(value="退费ID")
    private String backId;

    /**
     * 总费用
     */
    @NotNull(message = "退费的费用不能为空")
    @ApiModelProperty(value="总费用")
    private BigDecimal backAmount;

    /**
     * 病历ID
     */
    @NotBlank(message = "病历ID不能为空")
    @ApiModelProperty(value="病历ID")
    private String chId;

    /**
     * 挂号单
     */
    @NotBlank(message = "挂号单不能为空")
    @ApiModelProperty(value="挂号单")
    private String regId;

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

    /**
     * 订单状态0未退费  1 退费成功 2退费失败  字典表his_backfee_status
     */
    @ApiModelProperty(value="订单状态0未退费  1 退费成功 2退费失败  字典表his_backfee_status")
    private String backStatus;

    /**
     * 退费类型0现金1支付宝  字典表his_pay_type_status
     */
    @ApiModelProperty(value="退费类型0现金1支付宝  字典表his_pay_type_status")
    private String backType;

    /**
     * 关联订单ID his_order_charge
     */
    @ApiModelProperty(value="关联订单ID his_order_charge")
    private String orderId;

    /**
     * 退费交易ID
     */
    @ApiModelProperty(value="退费交易ID")
    private String backPlatformId;

    /**
     * 退费交易时间
     */
    @ApiModelProperty(value="退费交易时间")
    private Date backTime;
}

创建映射类


xxxxxxxxxx
package com.bjsxt.mapper;

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

public interface OrderBackfeeMapper extends BaseMapper<OrderBackfee> {
}

创建OrderBackfeeMapper.xml


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.OrderBackfeeMapper">
  <resultMap id="BaseResultMap" type="com.bjsxt.domain.OrderBackfee">
    <!--@mbg.generated-->
    <!--@Table his_order_backfee-->
    <id column="back_id" jdbcType="VARCHAR" property="backId" />
    <result column="back_amount" jdbcType="DECIMAL" property="backAmount" />
    <result column="ch_id" jdbcType="VARCHAR" property="chId" />
    <result column="reg_id" jdbcType="VARCHAR" property="regId" />
    <result column="patient_name" jdbcType="VARCHAR" property="patientName" />
    <result column="back_status" jdbcType="CHAR" property="backStatus" />
    <result column="back_type" jdbcType="CHAR" property="backType" />
    <result column="order_id" jdbcType="VARCHAR" property="orderId" />
    <result column="back_platform_id" jdbcType="VARCHAR" property="backPlatformId" />
    <result column="back_time" jdbcType="TIMESTAMP" property="backTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
    <result column="create_by" jdbcType="VARCHAR" property="createBy" />
    <result column="update_by" jdbcType="VARCHAR" property="updateBy" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--@mbg.generated-->
    back_id, back_amount, ch_id, reg_id, patient_name, back_status, back_type, order_id, 
    back_platform_id, back_time, create_time, update_time, create_by, update_by
  </sql>
</mapper>

修改service

在OrderBackfeeService中增加方法


xxxxxxxxxx
@Override
public DataGridView queryAllOrderBackfeeForPage(OrderBackfeeDto orderBackfeeDto) {
    Page<OrderBackfee> page=new Page<>(orderBackfeeDto.getPageNum(),orderBackfeeDto.getPageSize());
    QueryWrapper<OrderBackfee> qw=new QueryWrapper<>();
    qw.like(StringUtils.isNotBlank(orderBackfeeDto.getPatientName()),
            OrderBackfee.COL_PATIENT_NAME,orderBackfeeDto.getPatientName());
    qw.like(StringUtils.isNotBlank(orderBackfeeDto.getRegId()),
            OrderBackfee.COL_REG_ID,orderBackfeeDto.getRegId());
    qw.orderByDesc(OrderBackfee.COL_CREATE_TIME);
    this.orderBackfeeMapper.selectPage(page,qw);
    return new DataGridView(page.getTotal(),page.getRecords());
}

修改Controller

在OrderBackfeeController中增加方法


xxxxxxxxxx
/**
 * 分页查询所有退费单
 */
@GetMapping("queryAllOrderBackfeeForPage")
public AjaxResult queryAllOrderChargeForPage(OrderBackfeeDto orderBackfeeDto){
    DataGridView dataGridView=this.orderBackfeeService.queryAllOrderBackfeeForPage(orderBackfeeDto);
    return AjaxResult.success("查询成功",dataGridView.getData(),dataGridView.getTotal());
}

接口测试

分页查询退费单/doctor/backfee/queryAllOrderBackfeeForPage

云医疗平台_RocketMQ在支付中的应用_2 云医疗平台_发药_查询已支付的处方信息

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