package com.ruoyi.sales.excel;
|
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
|
import io.swagger.annotations.ApiModelProperty;
|
import lombok.Data;
|
import org.springframework.format.annotation.DateTimeFormat;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDateTime;
|
|
@Data
|
public class InvoiceRegisAndProductExcelDto {
|
|
@Excel(name = "销售合同号")
|
private String salesContractNo;
|
|
@Excel(name = "客户合同号")
|
private String customerContractNo;
|
|
@Excel(name = "客户名称")
|
private String customerName;
|
|
@Excel(name = "业务员")
|
private String salesman;
|
|
@Excel(name = "项目名称")
|
private String projectName;
|
|
@Excel(name = "合同金额")
|
private BigDecimal contractAmount;
|
|
@Excel(name = "产品大类")
|
private String productCategory;
|
|
@Excel(name = "规格型号")
|
private String specificationModel;
|
|
@Excel(name = "单位")
|
private String unit;
|
|
@Excel(name = "数量")
|
private BigDecimal quantity;
|
|
@Excel(name = "税率%")
|
private BigDecimal taxRate;
|
|
@Excel(name = "含税单价")
|
private BigDecimal taxInclusiveUnitPrice;
|
|
@Excel(name = "含税总价")
|
private BigDecimal taxInclusiveTotalPrice;
|
|
@Excel(name ="不含税总价")
|
private BigDecimal taxExclusiveTotalPrice;
|
|
@Excel(name ="发票类型")
|
private String invoiceType;
|
|
@Excel(name ="开票数")
|
private Integer invoiceNum;
|
|
@Excel(name ="未开票数")
|
private Integer noInvoiceNum;
|
|
@Excel(name ="开票金额")
|
private BigDecimal invoiceAmount;
|
|
@Excel(name ="未开票金额")
|
private BigDecimal noInvoiceAmount;
|
|
|
}
|
