开票信息

zhangmei

2025-02-11 44ec2edf3a35ef4ab776e4c97f5d8e5741c0b12b

开票信息

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInvoiceController.java

@@ -46,11 +46,11 @@
        return R.ok(invoiceService.removeById(id));
    }

    @ApiOperation(value = "关联账单信息")
    @GetMapping(value = "/getBillByInvoiceId")
    public AjaxResult<List<TBill>> getBillByInvoiceId(String invoiceId){
        return AjaxResult.success(invoiceService.getBillByInvoiceId(invoiceId));
    }
    // @ApiOperation(value = "关联账单信息")
    // @GetMapping(value = "/getBillByInvoiceId")
    // public AjaxResult<List<TBill>> getBillByInvoiceId(String invoiceId){
    //     return AjaxResult.success(invoiceService.getBillByInvoiceId(invoiceId));
    // }

}


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInvoiceToBillController.java

New file
@@ -0,0 +1,20 @@
package com.ruoyi.web.controller.api;


import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * <p>
 * 账单开票中间表 前端控制器
 * </p>
 *
 * @author xiaochen
 * @since 2025-02-10
 */
@RestController
@RequestMapping("/t-invoice-to-bill")
public class TInvoiceToBillController {

}


 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TInvoiceToBillMapper.java

New file
@@ -0,0 +1,16 @@
package com.ruoyi.system.mapper;

import com.ruoyi.system.model.TInvoiceToBill;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 * 账单开票中间表 Mapper 接口
 * </p>
 *
 * @author xiaochen
 * @since 2025-02-10
 */
public interface TInvoiceToBillMapper extends BaseMapper<TInvoiceToBill> {

}

 ruoyi-system/src/main/java/com/ruoyi/system/model/TInvoiceToBill.java

New file
@@ -0,0 +1,40 @@
package com.ruoyi.system.model;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableField;
import java.io.Serializable;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * <p>
 * 账单开票中间表
 * </p>
 *
 * @author xiaochen
 * @since 2025-02-10
 */
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("t_invoice_to_bill")
@ApiModel(value="TInvoiceToBill对象", description="账单开票中间表")
public class TInvoiceToBill implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId("id")
    private String id;

    @ApiModelProperty(value = "开票id")
    @TableField("invoice_id")
    private String invoiceId;

    @ApiModelProperty(value = "账单id")
    @TableField("bill_id")
    private String billId;


}

 ruoyi-system/src/main/java/com/ruoyi/system/query/TInvoiceToBillQuery.java

New file
@@ -0,0 +1,19 @@
package com.ruoyi.system.query;

import com.ruoyi.common.core.domain.BasePage;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;



@Data
@ApiModel(value="开票查询列表Query")
public class TInvoiceToBillQuery extends BasePage {
    @ApiModelProperty(value = "开票申请id")
    private String invoiceId;

    @ApiModelProperty(value = "账单id")
    private String billId;

}

 ruoyi-system/src/main/java/com/ruoyi/system/service/TInvoiceToBillService.java

New file
@@ -0,0 +1,23 @@
package com.ruoyi.system.service;

import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.model.TInvoice;
import com.ruoyi.system.model.TInvoiceToBill;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.system.query.TInvoiceQuery;
import com.ruoyi.system.query.TInvoiceToBillQuery;

import java.util.List;

/**
 * <p>
 * 账单开票中间表 服务类
 * </p>
 *
 * @author xiaochen
 * @since 2025-02-10
 */
public interface TInvoiceToBillService extends IService<TInvoiceToBill> {
    List<TInvoiceToBill> makeQuery(TInvoiceToBillQuery query);
}


 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceToBillServiceImpl.java

New file
@@ -0,0 +1,33 @@
package com.ruoyi.system.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.system.model.TInvoice;
import com.ruoyi.system.model.TInvoiceToBill;
import com.ruoyi.system.mapper.TInvoiceToBillMapper;
import com.ruoyi.system.query.TInvoiceToBillQuery;
import com.ruoyi.system.service.TInvoiceToBillService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 * 账单开票中间表 服务实现类
 * </p>
 *
 * @author xiaochen
 * @since 2025-02-10
 */
@Service
public class TInvoiceToBillServiceImpl extends ServiceImpl<TInvoiceToBillMapper, TInvoiceToBill> implements TInvoiceToBillService {

    @Override
    public List<TInvoiceToBill> makeQuery(TInvoiceToBillQuery query) {
        LambdaQueryWrapper<TInvoiceToBill> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(null != query.getInvoiceId(),TInvoiceToBill::getInvoiceId,query.getInvoiceId())
                .eq(null != query.getBillId(),TInvoiceToBill::getBillId,query.getBillId());
        return this.baseMapper.selectList(queryWrapper);
    }
}

 ruoyi-system/src/main/resources/mapping/TInvoiceToBillMapper.xml

New file
@@ -0,0 +1,17 @@
<?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.ruoyi.system.mapper.TInvoiceToBillMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TInvoiceToBill">
        <id column="id" property="id" />
        <result column="invoice_id" property="invoiceId" />
        <result column="bill_id" property="billId" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, invoice_id, bill_id
    </sql>

</mapper>