会诊

lige

2023-11-22 e5248157af311961bee52db474c2ee8abb741843

会诊

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java

@@ -882,4 +882,20 @@
        return success(deptService.selectDeptTreeList(dept));
    }


    /**
     * 获取子科室部门列表
     */
    @GetMapping("/getChildList")
    @ApiOperation(value = "获取子科室部门列表")
    public AjaxResult getChildList(String deptName) {
        LambdaQueryWrapper<SysDept> wq=new LambdaQueryWrapper<>();
        wq.ne(SysDept::getParentId,0);
        if (deptName!=null){
            wq.like(SysDept::getDeptName,deptName);
        }
        List<SysDept> depts = deptService.list(wq);
        return success(depts);
    }

}

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjHzLogController.java

New file
@@ -0,0 +1,107 @@
package com.ltkj.web.controller.system;

import java.util.Arrays;
import java.util.List;
import javax.servlet.http.HttpServletResponse;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ltkj.common.annotation.Log;
import com.ltkj.common.core.controller.BaseController;
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.BusinessType;
import com.ltkj.hosp.domain.TjHzLog;
import com.ltkj.hosp.service.ITjHzLogService;
import com.ltkj.common.utils.poi.ExcelUtil;
import com.ltkj.common.core.page.TableDataInfo;

/**
 * 会诊申请记录
 * Controller
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@RestController
@RequestMapping("/hosp/hzlog")
public class TjHzLogController extends BaseController {
    @Autowired
    private ITjHzLogService tjHzLogService;

    /**
     * 查询会诊申请记录列表
     */
    @GetMapping("/list")
    public TableDataInfo list(TjHzLog tjHzLog) {
        startPage();
        LambdaQueryWrapper<TjHzLog> wq=new LambdaQueryWrapper<>();
        if (tjHzLog.getTjNumber()!=null){
            wq.eq(TjHzLog::getTjNumber,tjHzLog.getTjNumber());
        }
        if (tjHzLog.getUserName()!=null){
            wq.like(TjHzLog::getUserName,tjHzLog.getUserName());
        }
        if (tjHzLog.getHzType()!=null){
            wq.eq(TjHzLog::getHzType,tjHzLog.getHzType());
        }
        List<TjHzLog> list = tjHzLogService.list(wq);
        return getDataTable(list);
    }

    /**
     * 导出会诊申请记录列表
     */
    @Log(title = "会诊申请记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, TjHzLog tjHzLog) {
        List<TjHzLog> list = tjHzLogService.selectTjHzLogList(tjHzLog);
        ExcelUtil<TjHzLog> util = new ExcelUtil<TjHzLog>(TjHzLog.class);
        util.exportExcel(response, list, "会诊申请记录数据");
    }

    /**
     * 获取会诊申请记录
     * 详细信息
     */
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(tjHzLogService.selectTjHzLogById(id));
    }

    /**
     * 新增会诊申请记录
     */
    @Log(title = "会诊申请记录", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody TjHzLog tjHzLog){
        return toAjax(tjHzLogService.save(tjHzLog));
    }

    /**
     * 修改会诊申请记录

     */
    @Log(title = "会诊申请记录 ", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody TjHzLog tjHzLog){
        return toAjax(tjHzLogService.saveOrUpdate(tjHzLog));
    }

    /**
     * 删除会诊申请记录
     */
    @Log(title = "会诊申请记录 ", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[]ids) {
        return toAjax(tjHzLogService.removeByIds(Arrays.asList(ids)));
    }
}

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjHzReplyLogController.java

New file
@@ -0,0 +1,93 @@
package com.ltkj.web.controller.system;

import java.util.Arrays;
import java.util.List;
import javax.servlet.http.HttpServletResponse;

import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ltkj.common.annotation.Log;
import com.ltkj.common.core.controller.BaseController;
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.BusinessType;
import com.ltkj.hosp.domain.TjHzReplyLog;
import com.ltkj.hosp.service.ITjHzReplyLogService;
import com.ltkj.common.utils.poi.ExcelUtil;
import com.ltkj.common.core.page.TableDataInfo;

/**
 * 会诊回复记录Controller
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@RestController
@RequestMapping("/hosp/replylog")
public class TjHzReplyLogController extends BaseController {
    @Autowired
    private ITjHzReplyLogService tjHzReplyLogService;

    /**
     * 查询会诊回复记录列表
     */
    @GetMapping("/list")
    public TableDataInfo list(TjHzReplyLog tjHzReplyLog) {
        startPage();
        List<TjHzReplyLog> list = tjHzReplyLogService.selectTjHzReplyLogList(tjHzReplyLog);
        return getDataTable(list);
    }

    /**
     * 导出会诊回复记录列表
     */
    @Log(title = "会诊回复记录", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, TjHzReplyLog tjHzReplyLog) {
        List<TjHzReplyLog> list = tjHzReplyLogService.selectTjHzReplyLogList(tjHzReplyLog);
        ExcelUtil<TjHzReplyLog> util = new ExcelUtil<TjHzReplyLog>(TjHzReplyLog.class);
        util.exportExcel(response, list, "会诊回复记录数据");
    }

    /**
     * 获取会诊回复记录详细信息
     */
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(tjHzReplyLogService.selectTjHzReplyLogById(id));
    }

    /**
     * 新增会诊回复记录
     */
    @Log(title = "会诊回复记录", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody TjHzReplyLog tjHzReplyLog) {
        return toAjax(tjHzReplyLogService.save(tjHzReplyLog));
    }

    /**
     * 修改会诊回复记录
     */
    @Log(title = "会诊回复记录", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody TjHzReplyLog tjHzReplyLog) {
        return toAjax(tjHzReplyLogService.saveOrUpdate(tjHzReplyLog));
    }

    /**
     * 删除会诊回复记录
     */
    @Log(title = "会诊回复记录", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(tjHzReplyLogService.removeByIds(Arrays.asList(ids)));
    }
}

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java

@@ -25,6 +25,7 @@
import com.ltkj.common.core.redis.RedisCache;
import com.ltkj.common.utils.SecurityUtils;
import com.ltkj.framework.config.MatchUtils;
import com.ltkj.framework.config.UserHoder;
import com.ltkj.hosp.domain.*;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.vodomain.BingZhongVO;
@@ -432,6 +433,7 @@
                    LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
                    wq.isNotNull(TjOrder::getReportTime);
                    wq.eq(TjOrder::getUserId, customer.getCusId());
                    wq.eq(TjOrder::getHeshouStatus, 1); //核收状态为1才能打印
                    list.addAll(tjOrderService.list(wq));
                }
                List<TjOrder> collect = null;
@@ -483,6 +485,7 @@
        Page<TjOrder> page1 = new Page<>(pageNum, pageSize);
        LambdaQueryWrapper<TjOrder> wq = new LambdaQueryWrapper<>();
        wq.isNotNull(TjOrder::getReportTime);
        wq.eq(TjOrder::getHeshouStatus, 1);  //核收状态为1才能打印
        if (null != bgbeginTime && null != bgendTime) {
            wq.between(TjOrder::getCreateTime, DateUtil.beginOfDay(bgbeginTime), DateUtil.endOfDay(bgendTime));
        }
@@ -1615,4 +1618,21 @@
        System.out.println("这段代码时间" + (System.currentTimeMillis() - l));
    }


    @PostMapping("/heXiaoByIds/{orderIds}")
    @ApiOperation(value = "核收报告——————总检审核通过后可以核销，核收后才能打印")
    @Transactional
    public AjaxResult heXiaoByIds(@PathVariable String[] orderIds) {
        for (String orderId : orderIds) {
            final TjOrder byId = tjOrderService.getById(orderId);
            byId.setHeshouStatus(1);
            byId.setHeshouDoctor(UserHoder.getLoginUser().getUserId());
            byId.setHeshouTime(new DateTime());
            final boolean b = tjOrderService.updateById(byId);
            if (!b){
                return AjaxResult.error("核收失败");
            }
        }
        return AjaxResult.success("核收成功");
    }
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjHzLog.java

New file
@@ -0,0 +1,94 @@
package com.ltkj.hosp.domain;

import com.ltkj.common.annotation.Excel;
import com.ltkj.common.core.domain.BaseEntity;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;

/**
 * 会诊申请记录
 * 对象 tj_hz_log
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Data
public class TjHzLog extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * 会诊id
     */
    private Long id;

    /**
     * 会诊订单id
     */
    @Excel(name = "会诊订单id")
    private Long orderId;

    /**
     * 用户id
     */
    @Excel(name = "用户id")
    private Long userId;

    /**
     * 体检号
     */
    @Excel(name = "体检号")
    private String tjNumber;

    /**
     * 用户名
     */
    @Excel(name = "用户名")
    private String userName;

    /**
     * 会诊类型0全院会诊1科室会诊
     */
    @Excel(name = "会诊类型0全院会诊1科室会诊")
    private String hzType;

    /**
     * 会诊科室[]
     */
    @Excel(name = "会诊科室[]")
    private String hzDeptId;


    /**
     * 会诊申请人id
     */
    @Excel(name = "会诊申请人id")
    private String hzDoctorId;

    /**
     * 会诊申请人名
     */
    @Excel(name = "会诊申请人名")
    private String hzDoctorName;


    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
                .append("id", getId())
                .append("orderId", getOrderId())
                .append("userId", getUserId())
                .append("tjNumber", getTjNumber())
                .append("userName", getUserName())
                .append("hzType", getHzType())
                .append("hzDeptId", getHzDeptId())
                .append("createTime", getCreateTime())
                .append("updateTime", getUpdateTime())
                .append("createBy", getCreateBy())
                .append("updateBy", getUpdateBy())
                .append("deleted", getDeleted())
                .append("hzDoctorId", getHzDoctorId())
                .append("hzDoctorName", getHzDoctorName())
                .toString();
    }
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjHzReplyLog.java

New file
@@ -0,0 +1,135 @@
package com.ltkj.hosp.domain;

import com.ltkj.common.annotation.Excel;
import com.ltkj.common.core.domain.BaseEntity;
import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;

/**
 * 会诊回复记录对象 tj_hz_reply_log
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Data
public class TjHzReplyLog extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * 会诊id
     */
    private Long id;

    /**
     * 会诊订单id
     */
    @Excel(name = "会诊订单id")
    private Long orderId;

    /**
     * 体检号
     */
    @Excel(name = "体检号")
    private String tjNumber;

    /**
     * 用户id
     */
    @Excel(name = "用户id")
    private Long userId;

    /**
     * 用户名
     */
    @Excel(name = "用户名")
    private String userName;

    /**
     * 会诊类型0全院会诊1科室会诊
     */
    @Excel(name = "会诊类型0全院会诊1科室会诊")
    private String hzType;

    /**
     * 回复医生
     */
    @Excel(name = "回复医生")
    private Long replyDoctorId;

    /**
     * 回复医生名
     */
    @Excel(name = "回复医生名")
    private String replyDoctorName;

    /**
     * 回复部门
     */
    @Excel(name = "回复部门")
    private Long replyDeptId;

    /**
     * 回复部门名
     */
    @Excel(name = "回复部门名")
    private String replyDeptName;

    /**
     * 回复内容
     */
    @Excel(name = "回复内容")
    private String replyContent;

    /**
     *
     */
    @Excel(name = "")
    private String status;


    /**
     * 会诊申请id
     */
    @Excel(name = "会诊申请id")
    private Long hzId;

    /**
     * 会诊申请人
     */
    private String hzDoctorId;

    /**
     *会诊申请人
     */
    private String hzDoctorName;



    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
                .append("id", getId())
                .append("orderId", getOrderId())
                .append("tjNumber", getTjNumber())
                .append("userId", getUserId())
                .append("userName", getUserName())
                .append("hzType", getHzType())
                .append("replyDoctorId", getReplyDoctorId())
                .append("replyDoctorName", getReplyDoctorName())
                .append("replyDeptId", getReplyDeptId())
                .append("replyDeptName", getReplyDeptName())
                .append("replyContent", getReplyContent())
                .append("status", getStatus())
                .append("remark", getRemark())
                .append("createTime", getCreateTime())
                .append("updateTime", getUpdateTime())
                .append("createBy", getCreateBy())
                .append("updateBy", getUpdateBy())
                .append("deleted", getDeleted())
                .append("hzId", getHzId())
                .append("hzDoctorId", getHzDoctorId())
                .append("hzDoctorName", getHzDoctorName())
                .toString();
    }
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjOrder.java

@@ -55,9 +55,9 @@
     * 客户对象
     */
    @Excels({
            @Excel(name = "客户名称", targetAttr = "cusName", type = Excel.Type.EXPORT,defaultValue = "无"),
            @Excel(name = "客户性别", targetAttr = "cusSex", type = Excel.Type.EXPORT,readConverterExp="0=男,1=女",defaultValue = "无"),
            @Excel(name = "客户电话", targetAttr = "cusPhone", type = Excel.Type.EXPORT,defaultValue = "无"),
            @Excel(name = "客户名称", targetAttr = "cusName", type = Excel.Type.EXPORT, defaultValue = "无"),
            @Excel(name = "客户性别", targetAttr = "cusSex", type = Excel.Type.EXPORT, readConverterExp = "0=男,1=女", defaultValue = "无"),
            @Excel(name = "客户电话", targetAttr = "cusPhone", type = Excel.Type.EXPORT, defaultValue = "无"),
    })
    @TableField(exist = false)
    @ApiModelProperty(value = "客户对象")
@@ -66,7 +66,7 @@
    /**
     * 体检类型
     */
    @Excel(name = "体检类型",readConverterExp="2=个人,1=团队")
    @Excel(name = "体检类型", readConverterExp = "2=个人,1=团队")
    @ApiModelProperty(value = "体检类型")
    private String tjType;

@@ -80,7 +80,7 @@
    /**
     * 流水号（时间戳生成）
     */
    @Excel(name = "流水号",defaultValue = "无")
    @Excel(name = "流水号", defaultValue = "无")
    @ApiModelProperty(value = "流水号")
    @JsonSerialize(using = ToStringSerializer.class)
    private String tjSerialNumber;
@@ -88,7 +88,7 @@
    /**
     * 所选套餐（绑定套餐表）
     */
    @Excel(name = "所选套餐",defaultValue = "无")
    @Excel(name = "所选套餐", defaultValue = "无")
    @ApiModelProperty(value = "所选套餐")
    @JsonSerialize(using = ToStringSerializer.class)
    private String pacId;
@@ -100,16 +100,16 @@
     * 体检完成时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "体检完成时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss",defaultValue = "暂未完成")
    @Excel(name = "体检完成时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", defaultValue = "暂未完成")
    @ApiModelProperty(value = "体检完成时间")
    @TableField(fill = FieldFill.INSERT_UPDATE,updateStrategy = FieldStrategy.IGNORED)
    @TableField(fill = FieldFill.INSERT_UPDATE, updateStrategy = FieldStrategy.IGNORED)
    private Date finishTime;

    /**
     * 出报告时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "出报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss",defaultValue = "暂无报告")
    @Excel(name = "出报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", defaultValue = "暂无报告")
    @ApiModelProperty(value = "出报告时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date reportTime;
@@ -118,21 +118,21 @@
     * 单位ID（外键）
     */
    @ApiModelProperty(value = "单位ID")
    @Excel(name = "单位ID",defaultValue = "无")
    @Excel(name = "单位ID", defaultValue = "无")
    @JsonSerialize(using = ToStringSerializer.class)
    private String firmId;

    /**
     * 部门名
     */
    @Excel(name = "部门名",defaultValue = "无")
    @Excel(name = "部门名", defaultValue = "无")
    @ApiModelProperty(value = "部门名")
    private String firmDeptName;

    /**
     * 在单位工号
     */
    @Excel(name = "在单位工号",defaultValue = "无")
    @Excel(name = "在单位工号", defaultValue = "无")
    @ApiModelProperty(value = "在单位工号")
    @JsonSerialize(using = ToStringSerializer.class)
    private String firmWorkId;
@@ -143,7 +143,7 @@
    /**
     * 总检医生名字
     */
    @Excel(name = "总检医生",defaultValue = "无")
    @Excel(name = "总检医生", defaultValue = "无")
    @ApiModelProperty(value = "总检医生")
    private String checkDoctor;

@@ -151,7 +151,7 @@
     * 总检时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "总检时间",defaultValue = "无", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "总检时间", defaultValue = "无", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "总检时间")
    @TableField(fill = FieldFill.UPDATE)
    private Date checkTime;
@@ -159,7 +159,7 @@
    /**
     * 总体建议
     */
    @Excel(name = "总体建议",defaultValue = "无")
    @Excel(name = "总体建议", defaultValue = "无")
    @ApiModelProperty(value = "总体建议")
    private String checkAdvice;

@@ -167,7 +167,7 @@
     * 发布时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "发布时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss",defaultValue = "暂未发布")
    @Excel(name = "发布时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", defaultValue = "暂未发布")
    @ApiModelProperty(value = "发布时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date releaseTime;
@@ -175,19 +175,19 @@
    /**
     * 是否发送邮件
     */
    @Excel(name = "是否发送邮件",readConverterExp="1=已发送,0=未发送")
    @Excel(name = "是否发送邮件", readConverterExp = "1=已发送,0=未发送")
    @ApiModelProperty(value = "是否发送邮件")
    private String sendEmail;

    /**
     * 是否发送短信
     */
    @Excel(name = "是否发送短信",readConverterExp="1=已发送,0=未发送")
    @Excel(name = "是否发送短信", readConverterExp = "1=已发送,0=未发送")
    @ApiModelProperty(value = "是否发送短信")
    private String sendMessage;


    @Excel(name = "总检审核状态",readConverterExp="1=已审核,0=未审核")
    @Excel(name = "总检审核状态", readConverterExp = "1=已审核,0=未审核")
    @ApiModelProperty(value = "总检审核状态")
    private Integer checkStatus;

@@ -195,7 +195,7 @@
    /**
     * 是否复检
     */
    @Excel(name = "是否复检",readConverterExp="1=否,0=是")
    @Excel(name = "是否复检", readConverterExp = "1=否,0=是")
    @ApiModelProperty(value = "是否复检")
    private Integer isReturn;

@@ -203,7 +203,7 @@
     * 报告最后打印时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = " pc最后打印报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss",defaultValue = "无")
    @Excel(name = " pc最后打印报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", defaultValue = "无")
    @ApiModelProperty(value = "报告最后打印时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date printLastTime;
@@ -212,11 +212,10 @@
     * 报告最后下载时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "web最后下载报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss",defaultValue = "无")
    @Excel(name = "web最后下载报告时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", defaultValue = "无")
    @ApiModelProperty(value = "报告最后下载时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date downloadLastTime;



    /**
@@ -352,7 +351,7 @@

    @ApiModelProperty("已打印未打印")
    @TableField(exist = false)
    private Integer type=0;
    private Integer type = 0;

    @ApiModelProperty("个人模板id")
    @TableField(exist = false)
@@ -366,15 +365,12 @@
    @ApiModelProperty("微信支付订单主键id")
    @TableField(updateStrategy = FieldStrategy.IGNORED)
    private String mallOrderId;


    /**
     * 体检状态
     */
    @Excel(name = "体检状态",defaultValue = "无")
    @Excel(name = "体检状态", defaultValue = "无")
    @ApiModelProperty(value = "体检状态")
    private Integer status;

    /**
     * 初审
     */
@@ -394,6 +390,30 @@
    private String firmDeptId;


    /**
     * 核收状态
     */
    @ApiModelProperty(value = "核收状态")
    private Integer heshouStatus;
    /**
     * 核收人
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "核收时间")
    private Date heshouTime;
    /**
     * 核收人
     */
    @ApiModelProperty(value = "核收人")
    private String heshouDoctor;

    /**
     * 有无会诊
     */
    @ApiModelProperty(value = "有无会诊")
    private Integer isHz;


    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjHzLogMapper.java

New file
@@ -0,0 +1,70 @@
package com.ltkj.hosp.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjGroupingPro;
import com.ltkj.hosp.domain.TjHzLog;
import org.apache.ibatis.annotations.Mapper;

/**
 * 会诊申请记录
 * Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Mapper
public interface TjHzLogMapper extends BaseMapper<TjHzLog> {
    /**
     * 查询会诊申请记录
     *
     * @param id 会诊申请记录
     *           主键
     * @return 会诊申请记录
     */
    public TjHzLog selectTjHzLogById(Long id);

    /**
     * 查询会诊申请记录
     * 列表
     *
     * @param tjHzLog 会诊申请记录
     * @return 会诊申请记录
     * 集合
     */
    public List<TjHzLog> selectTjHzLogList(TjHzLog tjHzLog);

    /**
     * 新增会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    public int insertTjHzLog(TjHzLog tjHzLog);

    /**
     * 修改会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    public int updateTjHzLog(TjHzLog tjHzLog);

    /**
     * 删除会诊申请记录
     *
     * @param id 会诊申请记录
     *           主键
     * @return 结果
     */
    public int deleteTjHzLogById(Long id);

    /**
     * 批量删除会诊申请记录
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjHzLogByIds(Long[] ids);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjHzReplyLogMapper.java

New file
@@ -0,0 +1,65 @@
package com.ltkj.hosp.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjHzReplyLog;
import com.ltkj.hosp.domain.TjOrderDetail;
import org.apache.ibatis.annotations.Mapper;

/**
 * 会诊回复记录Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Mapper
public interface TjHzReplyLogMapper extends BaseMapper<TjHzReplyLog> {
    /**
     * 查询会诊回复记录
     *
     * @param id 会诊回复记录主键
     * @return 会诊回复记录
     */
    public TjHzReplyLog selectTjHzReplyLogById(Long id);

    /**
     * 查询会诊回复记录列表
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 会诊回复记录集合
     */
    public List<TjHzReplyLog> selectTjHzReplyLogList(TjHzReplyLog tjHzReplyLog);

    /**
     * 新增会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    public int insertTjHzReplyLog(TjHzReplyLog tjHzReplyLog);

    /**
     * 修改会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    public int updateTjHzReplyLog(TjHzReplyLog tjHzReplyLog);

    /**
     * 删除会诊回复记录
     *
     * @param id 会诊回复记录主键
     * @return 结果
     */
    public int deleteTjHzReplyLogById(Long id);

    /**
     * 批量删除会诊回复记录
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjHzReplyLogByIds(Long[] ids);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjHzLogService.java

New file
@@ -0,0 +1,70 @@
package com.ltkj.hosp.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.domain.TjGroupingPro;
import com.ltkj.hosp.domain.TjHzLog;

/**
 * 会诊申请记录
 * Service接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
public interface ITjHzLogService extends IService<TjHzLog> {
    /**
     * 查询会诊申请记录
     *
     * @param id 会诊申请记录
     *           主键
     * @return 会诊申请记录
     */
    public TjHzLog selectTjHzLogById(Long id);

    /**
     * 查询会诊申请记录
     * 列表
     *
     * @param tjHzLog 会诊申请记录
     * @return 会诊申请记录
     * 集合
     */
    public List<TjHzLog> selectTjHzLogList(TjHzLog tjHzLog);

    /**
     * 新增会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    public int insertTjHzLog(TjHzLog tjHzLog);

    /**
     * 修改会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    public int updateTjHzLog(TjHzLog tjHzLog);

    /**
     * 批量删除会诊申请记录
     *
     * @param ids 需要删除的会诊申请记录
     *            主键集合
     * @return 结果
     */
    public int deleteTjHzLogByIds(Long[] ids);

    /**
     * 删除会诊申请记录
     * 信息
     *
     * @param id 会诊申请记录
     *           主键
     * @return 结果
     */
    public int deleteTjHzLogById(Long id);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjHzReplyLogService.java

New file
@@ -0,0 +1,63 @@
package com.ltkj.hosp.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.domain.TjHzLog;
import com.ltkj.hosp.domain.TjHzReplyLog;

/**
 * 会诊回复记录Service接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
public interface ITjHzReplyLogService extends IService<TjHzReplyLog> {
    /**
     * 查询会诊回复记录
     *
     * @param id 会诊回复记录主键
     * @return 会诊回复记录
     */
    public TjHzReplyLog selectTjHzReplyLogById(Long id);

    /**
     * 查询会诊回复记录列表
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 会诊回复记录集合
     */
    public List<TjHzReplyLog> selectTjHzReplyLogList(TjHzReplyLog tjHzReplyLog);

    /**
     * 新增会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    public int insertTjHzReplyLog(TjHzReplyLog tjHzReplyLog);

    /**
     * 修改会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    public int updateTjHzReplyLog(TjHzReplyLog tjHzReplyLog);

    /**
     * 批量删除会诊回复记录
     *
     * @param ids 需要删除的会诊回复记录主键集合
     * @return 结果
     */
    public int deleteTjHzReplyLogByIds(Long[] ids);

    /**
     * 删除会诊回复记录信息
     *
     * @param id 会诊回复记录主键
     * @return 结果
     */
    public int deleteTjHzReplyLogById(Long id);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjHzLogServiceImpl.java

New file
@@ -0,0 +1,99 @@
package com.ltkj.hosp.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.common.utils.DateUtils;
import com.ltkj.hosp.domain.TjGroupingPro;
import com.ltkj.hosp.mapper.TjGroupingProMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ltkj.hosp.mapper.TjHzLogMapper;
import com.ltkj.hosp.domain.TjHzLog;
import com.ltkj.hosp.service.ITjHzLogService;

/**
 * 会诊申请记录
 * Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Service
public class TjHzLogServiceImpl extends ServiceImpl<TjHzLogMapper, TjHzLog> implements ITjHzLogService {
    @Autowired
    private TjHzLogMapper tjHzLogMapper;

    /**
     * 查询会诊申请记录
     *
     * @param id 会诊申请记录
     *           主键
     * @return 会诊申请记录
     */
    @Override
    public TjHzLog selectTjHzLogById(Long id) {
        return tjHzLogMapper.selectTjHzLogById(id);
    }

    /**
     * 查询会诊申请记录
     * 列表
     *
     * @param tjHzLog 会诊申请记录
     * @return 会诊申请记录
     */
    @Override
    public List<TjHzLog> selectTjHzLogList(TjHzLog tjHzLog) {
        return tjHzLogMapper.selectTjHzLogList(tjHzLog);
    }

    /**
     * 新增会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    @Override
    public int insertTjHzLog(TjHzLog tjHzLog) {
        tjHzLog.setCreateTime(DateUtils.getNowDate());
        return tjHzLogMapper.insertTjHzLog(tjHzLog);
    }

    /**
     * 修改会诊申请记录
     *
     * @param tjHzLog 会诊申请记录
     * @return 结果
     */
    @Override
    public int updateTjHzLog(TjHzLog tjHzLog) {
        tjHzLog.setUpdateTime(DateUtils.getNowDate());
        return tjHzLogMapper.updateTjHzLog(tjHzLog);
    }

    /**
     * 批量删除会诊申请记录
     *
     * @param ids 需要删除的会诊申请记录
     *            主键
     * @return 结果
     */
    @Override
    public int deleteTjHzLogByIds(Long[] ids) {
        return tjHzLogMapper.deleteTjHzLogByIds(ids);
    }

    /**
     * 删除会诊申请记录
     * 信息
     *
     * @param id 会诊申请记录
     *           主键
     * @return 结果
     */
    @Override
    public int deleteTjHzLogById(Long id) {
        return tjHzLogMapper.deleteTjHzLogById(id);
    }
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjHzReplyLogServiceImpl.java

New file
@@ -0,0 +1,93 @@
package com.ltkj.hosp.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.common.utils.DateUtils;
import com.ltkj.hosp.domain.TjGroupingPro;
import com.ltkj.hosp.mapper.TjGroupingProMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ltkj.hosp.mapper.TjHzReplyLogMapper;
import com.ltkj.hosp.domain.TjHzReplyLog;
import com.ltkj.hosp.service.ITjHzReplyLogService;

/**
 * 会诊回复记录Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-11-22
 */
@Service
public class TjHzReplyLogServiceImpl extends ServiceImpl<TjHzReplyLogMapper, TjHzReplyLog> implements ITjHzReplyLogService {
    @Autowired
    private TjHzReplyLogMapper tjHzReplyLogMapper;

    /**
     * 查询会诊回复记录
     *
     * @param id 会诊回复记录主键
     * @return 会诊回复记录
     */
    @Override
    public TjHzReplyLog selectTjHzReplyLogById(Long id) {
        return tjHzReplyLogMapper.selectTjHzReplyLogById(id);
    }

    /**
     * 查询会诊回复记录列表
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 会诊回复记录
     */
    @Override
    public List<TjHzReplyLog> selectTjHzReplyLogList(TjHzReplyLog tjHzReplyLog) {
        return tjHzReplyLogMapper.selectTjHzReplyLogList(tjHzReplyLog);
    }

    /**
     * 新增会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    @Override
    public int insertTjHzReplyLog(TjHzReplyLog tjHzReplyLog) {
        tjHzReplyLog.setCreateTime(DateUtils.getNowDate());
        return tjHzReplyLogMapper.insertTjHzReplyLog(tjHzReplyLog);
    }

    /**
     * 修改会诊回复记录
     *
     * @param tjHzReplyLog 会诊回复记录
     * @return 结果
     */
    @Override
    public int updateTjHzReplyLog(TjHzReplyLog tjHzReplyLog) {
        tjHzReplyLog.setUpdateTime(DateUtils.getNowDate());
        return tjHzReplyLogMapper.updateTjHzReplyLog(tjHzReplyLog);
    }

    /**
     * 批量删除会诊回复记录
     *
     * @param ids 需要删除的会诊回复记录主键
     * @return 结果
     */
    @Override
    public int deleteTjHzReplyLogByIds(Long[] ids) {
        return tjHzReplyLogMapper.deleteTjHzReplyLogByIds(ids);
    }

    /**
     * 删除会诊回复记录信息
     *
     * @param id 会诊回复记录主键
     * @return 结果
     */
    @Override
    public int deleteTjHzReplyLogById(Long id) {
        return tjHzReplyLogMapper.deleteTjHzReplyLogById(id);
    }
}

 ltkj-hosp/src/main/resources/mapper/hosp/TjHzLogMapper.xml

New file
@@ -0,0 +1,182 @@
<?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.ltkj.hosp.mapper.TjHzLogMapper">

    <resultMap type="TjHzLog" id="TjHzLogResult">
        <result property="id" column="id"/>
        <result property="orderId" column="order_id"/>
        <result property="userId" column="user_id"/>
        <result property="tjNumber" column="tj_number"/>
        <result property="userName" column="user_name"/>
        <result property="hzType" column="hz_type"/>
        <result property="hzDeptId" column="hz_dept_id"/>
        <result property="createTime" column="create_time"/>
        <result property="updateTime" column="update_time"/>
        <result property="createBy" column="create_by"/>
        <result property="updateBy" column="update_by"/>
        <result property="deleted" column="deleted"/>
        <result property="hzDoctorId" column="hz_doctor_id"/>
        <result property="hzDoctorName" column="hz_doctor_name"/>
    </resultMap>

    <sql id="selectTjHzLogVo">
        select id,
               order_id,
               user_id,
               tj_number,
               user_name,
               hz_type,
               hz_dept_id,
               create_time,
               update_time,
               create_by,
               update_by,
               deleted,
               hz_doctor_id,
               hz_doctor_name
        from tj_hz_log
    </sql>

    <select id="selectTjHzLogList" parameterType="TjHzLog" resultMap="TjHzLogResult">
        <include refid="selectTjHzLogVo"/>
        <where>
            <if test="tjNumber != null  and tjNumber != ''">
                and tj_number = #{tjNumber}
            </if>
            <if test="userName != null  and userName != ''">
                and user_name like concat('%', #{userName}, '%')
            </if>
            <if test="hzType != null  and hzType != ''">
                and hz_type = #{hzType}
            </if>
        </where>
    </select>

    <select id="selectTjHzLogById" parameterType="Long"
            resultMap="TjHzLogResult">
        <include refid="selectTjHzLogVo"/>
        where id = #{id}
    </select>

    <insert id="insertTjHzLog" parameterType="TjHzLog" useGeneratedKeys="true"
            keyProperty="id">
        insert into tj_hz_log
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="orderId != null">order_id,
            </if>
            <if test="userId != null">user_id,
            </if>
            <if test="tjNumber != null">tj_number,
            </if>
            <if test="userName != null">user_name,
            </if>
            <if test="hzType != null">hz_type,
            </if>
            <if test="hzDeptId != null">hz_dept_id,
            </if>
            <if test="createTime != null">create_time,
            </if>
            <if test="updateTime != null">update_time,
            </if>
            <if test="createBy != null">create_by,
            </if>
            <if test="updateBy != null">update_by,
            </if>
            <if test="deleted != null">deleted,
            </if>
            <if test="hzDoctorId != null">hz_doctor_id,
            </if>
            <if test="hzDoctorName != null">hz_doctor_name,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="orderId != null">#{orderId},
            </if>
            <if test="userId != null">#{userId},
            </if>
            <if test="tjNumber != null">#{tjNumber},
            </if>
            <if test="userName != null">#{userName},
            </if>
            <if test="hzType != null">#{hzType},
            </if>
            <if test="hzDeptId != null">#{hzDeptId},
            </if>
            <if test="createTime != null">#{createTime},
            </if>
            <if test="updateTime != null">#{updateTime},
            </if>
            <if test="createBy != null">#{createBy},
            </if>
            <if test="updateBy != null">#{updateBy},
            </if>
            <if test="deleted != null">#{deleted},
            </if>
            <if test="hzDoctorId != null">#{hzDoctorId},
            </if>
            <if test="hzDoctorName != null">#{hzDoctorName},
            </if>
        </trim>
    </insert>

    <update id="updateTjHzLog" parameterType="TjHzLog">
        update tj_hz_log
        <trim prefix="SET" suffixOverrides=",">
            <if test="orderId != null">order_id =
                #{orderId},
            </if>
            <if test="userId != null">user_id =
                #{userId},
            </if>
            <if test="tjNumber != null">tj_number =
                #{tjNumber},
            </if>
            <if test="userName != null">user_name =
                #{userName},
            </if>
            <if test="hzType != null">hz_type =
                #{hzType},
            </if>
            <if test="hzDeptId != null">hz_dept_id =
                #{hzDeptId},
            </if>
            <if test="createTime != null">create_time =
                #{createTime},
            </if>
            <if test="updateTime != null">update_time =
                #{updateTime},
            </if>
            <if test="createBy != null">create_by =
                #{createBy},
            </if>
            <if test="updateBy != null">update_by =
                #{updateBy},
            </if>
            <if test="deleted != null">deleted =
                #{deleted},
            </if>
            <if test="hzDoctorId != null">hz_doctor_id =
                #{hzDoctorId},
            </if>
            <if test="hzDoctorName != null">hz_doctor_name =
                #{hzDoctorName},
            </if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteTjHzLogById" parameterType="Long">
        delete
        from tj_hz_log
        where id = #{id}
    </delete>

    <delete id="deleteTjHzLogByIds" parameterType="String">
        delete from tj_hz_log where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 ltkj-hosp/src/main/resources/mapper/hosp/TjHzReplyLogMapper.xml

New file
@@ -0,0 +1,227 @@
<?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.ltkj.hosp.mapper.TjHzReplyLogMapper">

    <resultMap type="TjHzReplyLog" id="TjHzReplyLogResult">
            <result property="id" column="id"/>
            <result property="orderId" column="order_id"/>
            <result property="tjNumber" column="tj_number"/>
            <result property="userId" column="user_id"/>
            <result property="userName" column="user_name"/>
            <result property="hzType" column="hz_type"/>
            <result property="replyDoctorId" column="reply_doctor_id"/>
            <result property="replyDoctorName" column="reply_doctor_name"/>
            <result property="replyDeptId" column="reply_dept_id"/>
            <result property="replyDeptName" column="reply_dept_name"/>
            <result property="replyContent" column="reply_content"/>
            <result property="status" column="status"/>
            <result property="remark" column="remark"/>
            <result property="createTime" column="create_time"/>
            <result property="updateTime" column="update_time"/>
            <result property="createBy" column="create_by"/>
            <result property="updateBy" column="update_by"/>
            <result property="deleted" column="deleted"/>
            <result property="hzId" column="hz_id"/>
            <result property="hzDoctorId" column="hz_doctor_id"/>
            <result property="hzDoctorName" column="hz_doctor_name"/>
    </resultMap>

    <sql id="selectTjHzReplyLogVo">
        select id, order_id, tj_number, user_id, user_name, hz_type, reply_doctor_id, reply_doctor_name, reply_dept_id, reply_dept_name, reply_content, status, remark, create_time, update_time, create_by, update_by, deleted, hz_id, hz_doctor_id, hz_doctor_name
        from tj_hz_reply_log
    </sql>

    <select id="selectTjHzReplyLogList" parameterType="TjHzReplyLog" resultMap="TjHzReplyLogResult">
        <include refid="selectTjHzReplyLogVo"/>
        <where>
                        <if test="tjNumber != null  and tjNumber != ''">
                            and tj_number = #{tjNumber}
                        </if>
                        <if test="userName != null  and userName != ''">
                            and user_name like concat('%', #{userName}, '%')
                        </if>
                        <if test="hzType != null  and hzType != ''">
                            and hz_type = #{hzType}
                        </if>
                        <if test="hzDoctorName != null  and hzDoctorName != ''">
                            and hz_doctor_name like concat('%', #{hzDoctorName}, '%')
                        </if>
        </where>
    </select>

    <select id="selectTjHzReplyLogById" parameterType="Long"
            resultMap="TjHzReplyLogResult">
            <include refid="selectTjHzReplyLogVo"/>
            where id = #{id}
    </select>

    <insert id="insertTjHzReplyLog" parameterType="TjHzReplyLog" useGeneratedKeys="true"
            keyProperty="id">
        insert into tj_hz_reply_log
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test="orderId != null">order_id,
                    </if>
                    <if test="tjNumber != null">tj_number,
                    </if>
                    <if test="userId != null">user_id,
                    </if>
                    <if test="userName != null">user_name,
                    </if>
                    <if test="hzType != null">hz_type,
                    </if>
                    <if test="replyDoctorId != null">reply_doctor_id,
                    </if>
                    <if test="replyDoctorName != null">reply_doctor_name,
                    </if>
                    <if test="replyDeptId != null">reply_dept_id,
                    </if>
                    <if test="replyDeptName != null">reply_dept_name,
                    </if>
                    <if test="replyContent != null">reply_content,
                    </if>
                    <if test="status != null">status,
                    </if>
                    <if test="remark != null">remark,
                    </if>
                    <if test="createTime != null">create_time,
                    </if>
                    <if test="updateTime != null">update_time,
                    </if>
                    <if test="createBy != null">create_by,
                    </if>
                    <if test="updateBy != null">update_by,
                    </if>
                    <if test="deleted != null">deleted,
                    </if>
                    <if test="hzId != null">hz_id,
                    </if>
                    <if test="hzDoctorId != null">hz_doctor_id,
                    </if>
                    <if test="hzDoctorName != null">hz_doctor_name,
                    </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                    <if test="orderId != null">#{orderId},
                    </if>
                    <if test="tjNumber != null">#{tjNumber},
                    </if>
                    <if test="userId != null">#{userId},
                    </if>
                    <if test="userName != null">#{userName},
                    </if>
                    <if test="hzType != null">#{hzType},
                    </if>
                    <if test="replyDoctorId != null">#{replyDoctorId},
                    </if>
                    <if test="replyDoctorName != null">#{replyDoctorName},
                    </if>
                    <if test="replyDeptId != null">#{replyDeptId},
                    </if>
                    <if test="replyDeptName != null">#{replyDeptName},
                    </if>
                    <if test="replyContent != null">#{replyContent},
                    </if>
                    <if test="status != null">#{status},
                    </if>
                    <if test="remark != null">#{remark},
                    </if>
                    <if test="createTime != null">#{createTime},
                    </if>
                    <if test="updateTime != null">#{updateTime},
                    </if>
                    <if test="createBy != null">#{createBy},
                    </if>
                    <if test="updateBy != null">#{updateBy},
                    </if>
                    <if test="deleted != null">#{deleted},
                    </if>
                    <if test="hzId != null">#{hzId},
                    </if>
                    <if test="hzDoctorId != null">#{hzDoctorId},
                    </if>
                    <if test="hzDoctorName != null">#{hzDoctorName},
                    </if>
        </trim>
    </insert>

    <update id="updateTjHzReplyLog" parameterType="TjHzReplyLog">
        update tj_hz_reply_log
        <trim prefix="SET" suffixOverrides=",">
                    <if test="orderId != null">order_id =
                        #{orderId},
                    </if>
                    <if test="tjNumber != null">tj_number =
                        #{tjNumber},
                    </if>
                    <if test="userId != null">user_id =
                        #{userId},
                    </if>
                    <if test="userName != null">user_name =
                        #{userName},
                    </if>
                    <if test="hzType != null">hz_type =
                        #{hzType},
                    </if>
                    <if test="replyDoctorId != null">reply_doctor_id =
                        #{replyDoctorId},
                    </if>
                    <if test="replyDoctorName != null">reply_doctor_name =
                        #{replyDoctorName},
                    </if>
                    <if test="replyDeptId != null">reply_dept_id =
                        #{replyDeptId},
                    </if>
                    <if test="replyDeptName != null">reply_dept_name =
                        #{replyDeptName},
                    </if>
                    <if test="replyContent != null">reply_content =
                        #{replyContent},
                    </if>
                    <if test="status != null">status =
                        #{status},
                    </if>
                    <if test="remark != null">remark =
                        #{remark},
                    </if>
                    <if test="createTime != null">create_time =
                        #{createTime},
                    </if>
                    <if test="updateTime != null">update_time =
                        #{updateTime},
                    </if>
                    <if test="createBy != null">create_by =
                        #{createBy},
                    </if>
                    <if test="updateBy != null">update_by =
                        #{updateBy},
                    </if>
                    <if test="deleted != null">deleted =
                        #{deleted},
                    </if>
                    <if test="hzId != null">hz_id =
                        #{hzId},
                    </if>
                    <if test="hzDoctorId != null">hz_doctor_id =
                        #{hzDoctorId},
                    </if>
                    <if test="hzDoctorName != null">hz_doctor_name =
                        #{hzDoctorName},
                    </if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteTjHzReplyLogById" parameterType="Long">
        delete
        from tj_hz_reply_log where id = #{id}
    </delete>

    <delete id="deleteTjHzReplyLogByIds" parameterType="String">
        delete from tj_hz_reply_log where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>