package com.ruoyi.sales.vo;
|
|
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
|
import com.ruoyi.sales.pojo.SalesLedger;
|
import com.ruoyi.sales.pojo.SalesLedgerProduct;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* 销售台账导出对象（主从表格）。
|
* <p>
|
* 台账字段做纵向合并居中，右侧同行展开该台账下的产品明细，避免出现大片空白单元格。
|
* products 必须是最后一个字段：无产品的台账不会输出产品列，若其后面还有字段会导致列错位。
|
*/
|
@Data
|
public class SalesLedgerExportVo {
|
|
@Excel(name = "销售合同号", needMerge = true)
|
private String salesContractNo;
|
|
@Excel(name = "项目名称", needMerge = true)
|
private String projectName;
|
|
@Excel(name = "录入日期", width = 30, dateFormat = "yyyy-MM-dd", needMerge = true)
|
private Date entryDate;
|
|
@Excel(name = "业务员", needMerge = true)
|
private String salesman;
|
|
@Excel(name = "客户名称", needMerge = true)
|
private String customerName;
|
|
@Excel(name = "录入人", needMerge = true)
|
private String entryPersonName;
|
|
@Excel(name = "合同金额", scale = 2, needMerge = true)
|
private BigDecimal contractAmount;
|
|
@Excel(name = "备注", needMerge = true)
|
private String remarks;
|
|
@Excel(name = "产品明细")
|
private List<Item> products = new ArrayList<>();
|
|
@Data
|
public static class Item {
|
|
@Excel(name = "产品大类")
|
private String productCategory;
|
|
@Excel(name = "规格型号")
|
private String specificationModel;
|
|
@Excel(name = "单位")
|
private String unit;
|
|
@Excel(name = "数量", cellType = Excel.ColumnType.NUMERIC)
|
private BigDecimal quantity;
|
|
@Excel(name = "待发货数量", cellType = Excel.ColumnType.NUMERIC)
|
private BigDecimal noQuantity;
|
|
@Excel(name = "发货状态")
|
private String shippingStatus;
|
|
@Excel(name = "税率(%)", cellType = Excel.ColumnType.NUMERIC)
|
private BigDecimal taxRate;
|
|
@Excel(name = "含税单价(元)", scale = 2)
|
private BigDecimal taxInclusiveUnitPrice;
|
|
@Excel(name = "含税总价(元)", scale = 2)
|
private BigDecimal taxInclusiveTotalPrice;
|
|
@Excel(name = "不含税总价(元)", scale = 2)
|
private BigDecimal taxExclusiveTotalPrice;
|
|
public static Item fromProduct(SalesLedgerProduct product) {
|
Item item = new Item();
|
item.setProductCategory(product.getProductCategory());
|
item.setSpecificationModel(product.getSpecificationModel());
|
item.setUnit(product.getUnit());
|
item.setQuantity(product.getQuantity());
|
item.setNoQuantity(product.getNoQuantity());
|
item.setShippingStatus(product.getShippingStatus());
|
item.setTaxRate(product.getTaxRate());
|
item.setTaxInclusiveUnitPrice(product.getTaxInclusiveUnitPrice());
|
item.setTaxInclusiveTotalPrice(product.getTaxInclusiveTotalPrice());
|
item.setTaxExclusiveTotalPrice(product.getTaxExclusiveTotalPrice());
|
return item;
|
}
|
}
|
|
public static SalesLedgerExportVo fromLedger(SalesLedger ledger) {
|
SalesLedgerExportVo vo = new SalesLedgerExportVo();
|
vo.setSalesContractNo(ledger.getSalesContractNo());
|
vo.setProjectName(ledger.getProjectName());
|
vo.setEntryDate(ledger.getEntryDate());
|
vo.setSalesman(ledger.getSalesman());
|
vo.setCustomerName(ledger.getCustomerName());
|
vo.setEntryPersonName(ledger.getEntryPersonName());
|
vo.setContractAmount(ledger.getContractAmount());
|
vo.setRemarks(ledger.getRemarks());
|
return vo;
|
}
|
|
public void addProduct(SalesLedgerProduct product) {
|
this.products.add(Item.fromProduct(product));
|
}
|
}
|
