zjh20250715

zjh

10 小时以前 42f852823e744a81525558b7523edde601c0b057

zjh20250715

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

@@ -1,6 +1,7 @@
package com.ltkj.web.controller.system;


import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.utils.SecurityUtils;
@@ -8,10 +9,13 @@
import com.ltkj.hosp.domain.*;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.vodomain.TeamTjPeopleVo;
import com.mysql.cj.util.StringUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import jodd.util.StringUtil;
import org.aspectj.weaver.AjAttribute;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import com.ltkj.common.core.controller.BaseController;
import oshi.hardware.platform.mac.MacUsbDevice;
@@ -19,8 +23,10 @@
import javax.annotation.Resource;
import java.lang.annotation.ElementType;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
import java.util.*;
import java.util.stream.Collectors;

import static com.ltkj.framework.datasource.DynamicDataSourceContextHolder.log;

/**
 * 体检单位缴费主Controller
@@ -39,8 +45,6 @@
    @Resource
    private ITjTeamSelectRecordService selectRecordService;
    @Resource
    private ITjPackageService packageService;
    @Resource
    private IDictCompService compService;
    @Resource
    private ITjReservationService reservationService;
@@ -49,25 +53,62 @@
    @Resource
    private ITjCustomerService customerService;
    @Resource
    private ITjDwDeptService dwDeptService;
    private ITjDwGroupingService dwGroupingService;
    @Resource
    private ITjOrderRemarkService remarkService;
    @Resource
    private ITjFlowingWaterService tjFlowingWaterService;
    @Resource
    private ITbTransitionService transitionService;
    /**
     * 团体体检收费接口
     */
    @PostMapping
    @ApiOperation(value = "团体体检收费接口")
    public AjaxResult add(@RequestBody TjCompPayInfo compPayInfo) {
        if (null==compPayInfo) {
            return AjaxResult.error();
    @Transactional
    public AjaxResult add(@RequestBody TjCompPay compPay) {
        try {
            if (null==compPay.getTjhs() || compPay.getTjhs().isEmpty()) {
                return AjaxResult.error("请选择结账人员!");
            }
            Date date = DateUtil.date();
            String s = String.valueOf(SecurityUtils.getLoginUser().getUser().getNickName());
            compPay.setPayee(s);
            compPay.setSerialNumber("TT"+SecurityUtils.getUsername() + DateUtil.format(date, "yyMMddHHmmssSSS"));
            compPay.setInvoiceNo("FP" + DateUtil.format(date, "yyMMddHHmmssSSS"));
            if(compPayService.save(compPay)){
                for (String tjh : compPay.getTjhs()) {
                    TjOrder tjOrder = orderService.getOrderByTjNum(tjh);
                    if(null != tjOrder){
                        TjFlowingWater water = tjFlowingWaterService.getOne(new LambdaQueryWrapper<TjFlowingWater>()
                                .eq(TjFlowingWater::getOrderId, tjOrder.getOrderId()).eq(TjFlowingWater::getIsAddition, "N"));
                        if(null != water){
                            TjCompPayInfo payInfo =  new TjCompPayInfo();
                            payInfo.setTjh(tjh);
                            payInfo.setTjCompPayId(compPay.getId());
                            payInfo.setTransactionAmount(water.getPaidIn());
                            payInfo.setPaymentMethod(compPay.getPaymentMethod());
                            payInfo.setCardNo(compPay.getCardNo());
                            payInfo.setPayer(compPay.getPayer());
                            payInfo.setPayee(compPay.getPayee());
                            payInfoService.save(payInfo);
                            water.setSfjs("1");
                            water.setJsdh(compPay.getSerialNumber());
                            water.setJsrq(DateUtil.date());
                            water.setJsrxm(s);
                            water.setJsrdm(SecurityUtils.getLoginUser().getUser().getUserId().toString());
                            tjFlowingWaterService.updateById(water);
                        }
                    }

                }
                return AjaxResult.success("收费成功");
            }
            return AjaxResult.error("操作失败");
        } catch (Exception e) {
            log.error("收费异常", e);
            throw new RuntimeException(e);
        }
        compPayInfo.setPayee(String.valueOf(SecurityUtils.getLoginUser().getUser().getNickName()));
        TjCompPay tjCompPay =compPayService.getById(compPayInfo.getTjCompPayId());
        BigDecimal paidIn = tjCompPay.getPaidIn();
                   paidIn =paidIn.add(compPayInfo.getTransactionAmount());
        if(paidIn.compareTo(tjCompPay.getCopeWith())>0 || tjCompPay.getDifference().compareTo(BigDecimal.valueOf(0))==0){
            return AjaxResult.error("暂无收费需求");
        }
        if (getAjaxResult(compPayInfo, tjCompPay)) return AjaxResult.success("收费成功");
        return AjaxResult.error("操作失败");
    }

    /**
@@ -75,52 +116,35 @@
     */
    @PostMapping("/refund")
    @ApiOperation(value = "团体体检退费接口")
    public AjaxResult refund(@RequestBody TjCompPayInfo compPayInfo) {
        if (null==compPayInfo) {
            return AjaxResult.error();
        }
        compPayInfo.setPayee(String.valueOf(SecurityUtils.getLoginUser().getUser().getNickName()));
        TjCompPay tjCompPay =compPayService.getById(compPayInfo.getTjCompPayId());
        BigDecimal paidIn = tjCompPay.getPaidIn();
        paidIn =paidIn.add(compPayInfo.getTransactionAmount());
        //判断实付金额和交易金额的数值
        if(paidIn.compareTo(BigDecimal.valueOf(0.00))==0 || compPayInfo.getTransactionAmount().compareTo(tjCompPay.getPaidIn())>0 ){
            return AjaxResult.error("暂无退费需求");
        }
        compPayInfo.setTransactionAmount(BigDecimal.valueOf(0.00).subtract(compPayInfo.getTransactionAmount()));
        compPayInfo.setPaymentMethod(3L);
        if (getAjaxResult(compPayInfo, tjCompPay)) return AjaxResult.success("退费成功");
        return AjaxResult.error("操作失败");
    }

    private boolean getAjaxResult(@RequestBody TjCompPayInfo compPayInfo, TjCompPay tjCompPay) {
        if(payInfoService.saveOrUpdate(compPayInfo)){
            LambdaQueryWrapper<TjCompPayInfo> wq=new LambdaQueryWrapper<>();
            wq.eq(TjCompPayInfo::getTjCompPayId,tjCompPay.getId());
            List<TjCompPayInfo> list = payInfoService.list(wq);
            BigDecimal bigDecimal=new BigDecimal("0.00");
            if(null !=list && list.size()>0){
                for (TjCompPayInfo payInfo : list) {
                    bigDecimal=bigDecimal.add(payInfo.getTransactionAmount());
    @Transactional
    public AjaxResult refund(@RequestBody TjCompPay compPay) {
        try {
            if(null !=compPay){
                if (compPayService.removeById(compPay)) {
                    LambdaQueryWrapper<TjCompPayInfo>wq=new LambdaQueryWrapper<>();
                    wq.eq(TjCompPayInfo::getTjCompPayId,compPay.getId());
                    payInfoService.remove(wq);
                    LambdaQueryWrapper<TjFlowingWater> waterLambdaQueryWrappe=new LambdaQueryWrapper<>();
                    waterLambdaQueryWrappe.eq(TjFlowingWater::getJsdh,compPay.getSerialNumber());
                    List<TjFlowingWater> waterList = tjFlowingWaterService.list(waterLambdaQueryWrappe);
                    if(null != waterList && !waterList.isEmpty()){
                        for (TjFlowingWater water : waterList) {
                            water.setSfjs("0");
                            water.setJsdh(null);
                            water.setJsrq(null);
                            water.setJsrxm(null);
                            water.setJsrdm(null);
                            tjFlowingWaterService.updateById(water);
                        }
                    }
                    return AjaxResult.success("操作成功");
                }
            }
            tjCompPay.setCreateBy(String.valueOf(SecurityUtils.getLoginUser().getUserId()));
            if(bigDecimal.compareTo(BigDecimal.valueOf(0.00))>= 0){
                tjCompPay.setPaidIn(bigDecimal);
            }else {
                tjCompPay.setPaidIn(BigDecimal.valueOf(0.00));
            }
            tjCompPay.setDifference(tjCompPay.getCopeWith().subtract(bigDecimal));
            compPayService.updateById(tjCompPay);
            LambdaQueryWrapper<TjTeamSelectRecord>wq0=new LambdaQueryWrapper<>();
            wq0.eq(TjTeamSelectRecord::getTeamNo,tjCompPay.getTeamNo());
            wq0.eq(TjTeamSelectRecord::getCompId,tjCompPay.getCompId());
            TjTeamSelectRecord record = selectRecordService.getOne(wq0);
            record.setTransactionAmount(tjCompPay.getPaidIn());
            selectRecordService.updateById(record);
            return true;
            return AjaxResult.error("操作失败");
        } catch (Exception e) {
            log.error("操作失败", e);
            throw new RuntimeException(e);
        }
        return false;
    }

    /**
@@ -129,34 +153,66 @@
    @GetMapping
    @ApiOperation(value = "所有公司体检收费数据查询接口")
    public AjaxResult list(@RequestParam(required = false) @ApiParam(value = "单位id") String compId) {

        List<TjReservation> rightList = reservationService.list(new LambdaQueryWrapper<TjReservation>().eq(TjReservation::getCompanyId, compId));

        Map<String, List<TjReservation>> collect = rightList.stream().collect(Collectors.groupingBy(TjReservation::getPacId));

        if (!collect.isEmpty()) {
            for (Map.Entry<String, List<TjReservation>> entry : collect.entrySet()) {
                BigDecimal compPay = new BigDecimal("0.00");
                for (TjReservation reservation : entry.getValue()) {
                    TjDwGrouping dwGrouping = dwGroupingService.getById(reservation.getGroupingId());
                    compPay = compPay.add(dwGrouping.getYsPrice());
                }
                LambdaQueryWrapper<TjTeamSelectRecord> wq = new LambdaQueryWrapper<>();
                wq.eq(TjTeamSelectRecord::getTeamNo, entry.getValue().get(0).getTeamNo());
                wq.eq(TjTeamSelectRecord::getPacId, entry.getKey());
                wq.eq(TjTeamSelectRecord::getCompId,compId);
                TjTeamSelectRecord recordServiceOne = selectRecordService.getOne(wq);
                if (null == recordServiceOne) {
                    TjTeamSelectRecord selectRecord = new TjTeamSelectRecord();
                    selectRecord.setCompId(compId);
                    selectRecord.setPacId(entry.getKey());
                    selectRecord.setTeamNo(entry.getValue().get(0).getTeamNo());
                    selectRecord.setTransactionAmount(new BigDecimal("0.00"));
                    selectRecord.setCopeWith(compPay);
                    selectRecord.setCount(entry.getValue().size());
                    selectRecord.setDifference(compPay);
                    selectRecordService.save(selectRecord);
                }
            }
        }

        LambdaQueryWrapper<TjTeamSelectRecord>wq0=new LambdaQueryWrapper<>();
        if(null !=compId){
            wq0.eq(TjTeamSelectRecord::getCompId,compId);
        }
        wq0.ne(TjTeamSelectRecord::getDifference,0);
        List<TjTeamSelectRecord> selectRecordList = selectRecordService.list(wq0);
        if(null !=selectRecordList && selectRecordList.size()>0){
        if(null !=selectRecordList && !selectRecordList.isEmpty()){
            for(TjTeamSelectRecord selectRecord : selectRecordList){
                TjDwDept dwDept = dwDeptService.getById(selectRecord.getPacId());
                if(null !=dwDept){
                    selectRecord.setPacName(dwDept.getDwDeptName());
                    selectRecord.setSigningPrice(dwDept.getSigningPrice());
                selectRecord.setSjCount(orderService.count(new LambdaQueryWrapper<TjOrder>()
                        .eq(TjOrder::getTeamNo,selectRecord.getTeamNo()).eq(TjOrder::getPacId,selectRecord.getPacId())));

                TjDwGrouping dwGrouping = dwGroupingService.getById(selectRecord.getPacId());
                if(null !=dwGrouping){
                    selectRecord.setPacName(dwGrouping.getGroupingName());
                    selectRecord.setSigningPrice(dwGrouping.getSigningPrice());
                }
                LambdaQueryWrapper<TjCompPay>wq1=new LambdaQueryWrapper<>();
                wq1.eq(TjCompPay::getCompId,compId);
                wq1.eq(TjCompPay::getTeamNo,selectRecord.getTeamNo());
                TjCompPay compPay = compPayService.getOne(wq1);
                if (null !=compPay) {
                    LambdaQueryWrapper<TjCompPayInfo>wq=new LambdaQueryWrapper<>();
                    wq.eq(TjCompPayInfo::getTjCompPayId,compPay.getId());
                    selectRecord.setPayInfoList(payInfoService.list(wq));
                    selectRecord.setCopeWith(compPay.getCopeWith());
                    selectRecord.setDifference(compPay.getDifference());
                    selectRecord.setPayer(compService.getById(compPay.getCompId()).getContactPerson());
                    selectRecord.setSjCount(orderService.count(new LambdaQueryWrapper<TjOrder>().eq(TjOrder::getTeamNo,compPay.getTeamNo())));
                    TjCompPayInfo payInfo = new TjCompPayInfo();
                    payInfo.setTjCompPayId(compPay.getId());
                    selectRecord.setPayInfo(payInfo);
                wq1.eq(TjCompPay::getPacId,selectRecord.getPacId());
                List<TjCompPay> compPay = compPayService.list(wq1);
                BigDecimal sumZje = compPayService.sumZje(compId,selectRecord.getTeamNo(),selectRecord.getPacId());
                List<String> SerialNumbers = compPayService.serialNumbers(compId,selectRecord.getTeamNo(),selectRecord.getPacId());
                if (null !=compPay && !compPay.isEmpty()) {
                    selectRecord.setTransactionAmount(sumZje);
                    selectRecord.setDifference(selectRecord.getCopeWith().subtract(sumZje));
                    selectRecord.setYjsrs(tjFlowingWaterService.count(new LambdaQueryWrapper<TjFlowingWater>()
                            .in(TjFlowingWater::getJsdh,SerialNumbers)));
                }else {
                    selectRecord.setYjsrs(0);
                }
            }
        }
@@ -170,34 +226,110 @@
     */
    @GetMapping("/getTeamTjPeopleList")
    @ApiOperation(value = "根据团队体检编号团队人员体检情况查询")
    public AjaxResult getTeamTjPeopleList(@RequestParam @ApiParam(value = "团队编号") String teamNo) {
    public AjaxResult getTeamTjPeopleList(@RequestParam @ApiParam(value = "团队编号") String teamNo,
                                          @RequestParam(required = false) @ApiParam(value = "单位id") String pacId) {

        List<TjReservation> reservationList = reservationService.list(new LambdaQueryWrapper<TjReservation>().eq(TjReservation::getTeamNo,teamNo));
        if (null != reservationList && reservationList.size() > 0) {
            List<TeamTjPeopleVo> voList = new ArrayList<>();
            for (TjReservation reservation : reservationList) {
                TeamTjPeopleVo vo = new TeamTjPeopleVo();
                vo.setName(reservation.getName());
                TjCustomer customer = customerService.getOne(new LambdaQueryWrapper<TjCustomer>().eq(TjCustomer::getCusIdcard, reservation.getIdCard()));
                if (null != customer) {
                    TjOrder tjOrder = orderService.getOne(new LambdaQueryWrapper<TjOrder>().eq(TjOrder::getUserId, customer.getCusId()).eq(TjOrder::getTeamNo, teamNo));
                    if (null != tjOrder) {
                        if (null != tjOrder.getFinishTime()) {
                            vo.setTjStatus("已完成");
                            vo.setTjTime(tjOrder.getFinishTime());
                        } else {
                            vo.setTjStatus("未完成");
                        }
                    } else {
                        vo.setTjStatus("未 检");
        try {
            Map<String,Object> map=new HashMap<>();
            LambdaQueryWrapper<TjReservation> wrapper = new LambdaQueryWrapper<>();
            wrapper.eq(TjReservation::getTeamNo, teamNo);
            if(StringUtil.isNotBlank(pacId))wrapper.eq(TjReservation::getPacId, pacId);
            List<TjReservation> reservationList = reservationService.list(wrapper);
            if (null != reservationList && !reservationList.isEmpty()) {
                List<TeamTjPeopleVo> syList = new ArrayList<>();
                List<TeamTjPeopleVo> yjwjzList = new ArrayList<>();
                List<TeamTjPeopleVo> wjList = new ArrayList<>();
                for (TjReservation reservation : reservationList) {
                    TeamTjPeopleVo vo = new TeamTjPeopleVo();
                    vo.setName(reservation.getName());
                    vo.setXb(reservation.getSex().toString());
                    vo.setDh(reservation.getPhoe());
                    TjCustomer customer = null;
                    try {
                        customer = customerService.getTjCustomerByCusIdCard( reservation.getIdCard());
                    } catch (Exception e) {
                        log.error("根据团队编号查询团队预约信息异常"+reservation.getIdCard());
                        throw new RuntimeException(e);
                    }
                } else {
                    vo.setTjStatus("未 检");
                    if (null != customer) {
                        TjOrder tjOrder = orderService.getOne(new LambdaQueryWrapper<TjOrder>().eq(TjOrder::getUserId, customer.getCusId()).eq(TjOrder::getTeamNo, teamNo));
                        if (null != tjOrder) {
                            TjFlowingWater water = tjFlowingWaterService.getOne(new LambdaQueryWrapper<TjFlowingWater>()
                                    .eq(TjFlowingWater::getOrderId, tjOrder.getOrderId()).eq(TjFlowingWater::getIsAddition, "N"));
                            if(null != water && water.getSfjs().equals("0") && water.getJsrq() ==null){
                                vo.setTjh(tjOrder.getTjNumber());
                                int sfwc = remarkService.panduaniswancheng(tjOrder.getTjNumber());
                                if (sfwc==0) {
                                    vo.setTjStatus("已完成");
                                    vo.setTjTime(DateUtil.format(tjOrder.getCreateTime(),"yyyy-MM-dd"));
                                    vo.setTjf(water.getPaidIn());
                                } else {
                                    vo.setTjTime(DateUtil.format(tjOrder.getCreateTime(),"yyyy-MM-dd"));
                                    vo.setTjf(water.getPaidIn());
                                    vo.setTjStatus("在 检");
                                }
                                yjwjzList.add(vo);
                            }
                        } else {
                            vo.setTjStatus("未 检");
                            vo.setTjf(transitionService.sumNowPrice(reservation.getIdCard()));
                            wjList.add(vo);
                        }
                    }else {
                        vo.setTjStatus("未 检");
                        vo.setTjf(transitionService.sumNowPrice(reservation.getIdCard()));
                        wjList.add(vo);
                    }
                    syList.add(vo);

                }
                voList.add(vo);
                map.put("syList",syList);
                map.put("yjwjzList",yjwjzList);
                map.put("wjList",wjList);
                return AjaxResult.success(map);
            }
            return AjaxResult.success(voList);
            return AjaxResult.success(null);
        } catch (Exception e) {
            log.error("查询团队体检人员信息异常");
            throw new RuntimeException(e);
        }
        return AjaxResult.success(null);
    }



    @GetMapping("/getTjCompPay")
    @ApiOperation(value = "根据团队体检编号和套餐id获取结账信息")
    public AjaxResult getTjCompPay(@RequestParam @ApiParam(value = "团队编号") String teamNo,
                                   @RequestParam @ApiParam(value = "套餐id") String pacId) {

        try {
            LambdaQueryWrapper<TjCompPay> wq = new LambdaQueryWrapper<>();
            wq.eq(TjCompPay::getTeamNo, teamNo);
            wq.eq(TjCompPay::getPacId, pacId);
            List<TjCompPay> tjCompPays = compPayService.list(wq);
            if(null !=tjCompPays && !tjCompPays.isEmpty()){
                for (TjCompPay pay : tjCompPays) {
                    LambdaQueryWrapper<TjCompPayInfo> wqInfo = new LambdaQueryWrapper<>();
                    wqInfo.eq(TjCompPayInfo::getTjCompPayId, pay.getId());
                    List<TjCompPayInfo> payInfos = payInfoService.list(wqInfo);
                    if(null !=payInfos && !payInfos.isEmpty()){
                        for (TjCompPayInfo info : payInfos) {
                            TjOrder order = orderService.getOrderByTjNum(info.getTjh());
                            if(null != order){
                                TjCustomer tjCustomer = customerService.getById(order.getUserId());
                                if (null != tjCustomer) {
                                    info.setName(tjCustomer.getCusName());
                                }
                            }
                        }
                    }
                    pay.setPayInfo(payInfos);
                }
            }
            return AjaxResult.success(tjCompPays);
        } catch (Exception e) {
            log.error("查询团队体检人员信息异常");
            throw new RuntimeException(e);
        }
    }
}

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

@@ -44,6 +44,13 @@
    private String compId;

    /**
     * 套餐id
     */
    @Excel(name = "套餐id")
    @ApiModelProperty(value = "套餐id")
    private String pacId;

    /**
     * 单位缴费流水
     */
    @Excel(name = "单位缴费流水")
@@ -104,10 +111,35 @@
    @ApiModelProperty(value = "是否结账")
    private String isCheckout;

    /**
     * 交款人
     */
    @Excel(name = "交款人")
    @ApiModelProperty(value = "交款人")
    private String payer;

    /**
     * 收款人
     */
    @Excel(name = "收款人")
    @ApiModelProperty(value = "收款人")
    private String payee;

    /**
     * 支付方式
     */
    @Excel(name = "支付方式",dictType="dict_pay_method")
    @ApiModelProperty(value = "支付方式")
    private Long paymentMethod;


    @ApiModelProperty(value = "结账明细表")
    @TableField(exist = false)
    private TjCompPayInfo payInfo;
    private List<TjCompPayInfo> payInfo;

    @ApiModelProperty(value = "体检号集合")
    @TableField(exist = false)
    private List<String> tjhs;


    @Override

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

@@ -1,6 +1,7 @@
package com.ltkj.hosp.domain;

import java.math.BigDecimal;
import java.util.List;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
@@ -33,6 +34,16 @@
     */
    @TableId
    private String id;

    /**
     * 体检号
     */
    @ApiModelProperty(value = "体检号")
    private String tjh;

    @ApiModelProperty(value = "姓名")
    @TableField(exist = false)
    private String name;

    /**
     * 主表id
@@ -75,6 +86,10 @@
    @ApiModelProperty(value = "收款人")
    private String payee;

    @ApiModelProperty(value = "套餐id")
    @TableField(exist = false)
    private String pacId;

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

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

@@ -1,5 +1,6 @@
package com.ltkj.hosp.domain;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.FieldStrategy;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
@@ -189,14 +190,21 @@
    @ApiModelProperty(value = "结算日期")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(fill = FieldFill.UPDATE)
    private Date jsrq;

    @ApiModelProperty(value = "结算人代码")
    @TableField(fill = FieldFill.UPDATE)
    private String jsrdm;

    @ApiModelProperty(value = "结算人姓名")
    @TableField(fill = FieldFill.UPDATE)
    private String jsrxm;

    @ApiModelProperty(value = "结算单号")
    @TableField(fill = FieldFill.UPDATE)
    private String jsdh;

    /**
     * 收费id
     */

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

@@ -77,6 +77,10 @@
    @TableField(exist = false)
    private Integer sjCount;

    @ApiModelProperty(value = "已结算人数")
    @TableField(exist = false)
    private Integer yjsrs;

    /**
     * 交易金额
     */
@@ -97,17 +101,11 @@
    @ApiModelProperty(value = "团队编号")
    private String teamNo;

    @ApiModelProperty(value = "结账明细表")
    @TableField(exist = false)
    private List<TjCompPayInfo> payInfoList;
    @ApiModelProperty(value = "结账明细表")
    @TableField(exist = false)
    private TjCompPayInfo payInfo;

    /**
     * 签约金额
     */
    @ApiModelProperty(value = "应收金额")
    @TableField(exist = false)
    private BigDecimal copeWith;

    @ApiModelProperty(value = "签约金额")
@@ -125,9 +123,6 @@
    @ApiModelProperty(value = "签约人")
    private String payer;

    @ApiModelProperty(value = "单项(父项)")
    @TableField(exist = false)
    private List<TjProject> tjProjectList;


    /**

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

@@ -4,6 +4,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjCompPay;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

/**
 * 体检单位缴费主Mapper接口
@@ -13,4 +18,12 @@
 */
@Mapper
public interface TjCompPayMapper extends BaseMapper<TjCompPay> {

    @Select("SELECT IFNULL(SUM(a.paid_in),0) yf FROM tj_comp_pay a WHERE a.deleted=0 " +
            "AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
    BigDecimal sumZje(@Param("compId")String compId, @Param("teamNo") String teamNo, @Param("pacId") String pacId);

    @Select("SELECT a.serial_number FROM tj_comp_pay a WHERE a.deleted=0 " +
            "AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
    List<String> serialNumbers(@Param("compId")String compId, @Param("teamNo") String teamNo, @Param("pacId") String pacId);
}

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

@@ -4,6 +4,9 @@
import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.domain.TjCompPay;

import java.math.BigDecimal;
import java.util.List;

/**
 * 体检单位缴费主Service接口
 *
@@ -11,4 +14,8 @@
 * @date 2023-03-14
 */
public interface ITjCompPayService extends IService<TjCompPay> {

    BigDecimal sumZje(String compId, String teamNo, String pacId);

    List<String> serialNumbers(String compId, String teamNo, String pacId);
}

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

@@ -5,7 +5,11 @@
import com.ltkj.hosp.domain.TjCompPay;
import com.ltkj.hosp.mapper.TjCompPayMapper;
import com.ltkj.hosp.service.ITjCompPayService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.math.BigDecimal;
import java.util.List;

/**
 * 体检单位缴费主Service业务层处理
@@ -15,4 +19,17 @@
 */
@Service
public class TjCompPayServiceImpl extends ServiceImpl<TjCompPayMapper, TjCompPay> implements ITjCompPayService {

    @Autowired
    private TjCompPayMapper mapper;

    @Override
    public BigDecimal sumZje(String compId, String teamNo, String pacId) {
        return mapper.sumZje(compId, teamNo, pacId);
    }

    @Override
    public List<String> serialNumbers(String compId, String teamNo, String pacId) {
        return mapper.serialNumbers(compId, teamNo, pacId);
    }
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/vodomain/TeamTjPeopleVo.java

@@ -6,6 +6,7 @@
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

/**
@@ -25,6 +26,23 @@
    private String name;

    /**
     * 体检号
     */
    @ApiModelProperty("体检号")
    private String tjh;


    @ApiModelProperty("性别")
    private String xb;


    @ApiModelProperty("电话")
    private String dh;

    @ApiModelProperty("体检费")
    private BigDecimal tjf;

    /**
     * 姓名
     */
    @ApiModelProperty("体检状态")
@@ -37,6 +55,6 @@
    @ApiModelProperty("体检时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date tjTime;
    private String tjTime;

}