package cn.iocoder.yudao.module.erp.controller.admin.purchase.vo.request;
|
|
import cn.idev.excel.annotation.ExcelProperty;
|
import cn.iocoder.yudao.framework.excel.core.convert.YesNoBooleanConverter;
|
import cn.idev.excel.annotation.write.style.HeadFontStyle;
|
import lombok.AllArgsConstructor;
|
import lombok.Builder;
|
import lombok.Data;
|
import lombok.NoArgsConstructor;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
|
/**
|
* ERP 采购申请 Excel 导入 VO
|
*
|
* 一行 = 一条申请明细，主表字段在每行重复；相同「单号」的多行会合并成一张采购申请。
|
*/
|
@Data
|
@Builder
|
@AllArgsConstructor
|
@NoArgsConstructor
|
public class ErpPurchaseRequestImportExcelVO {
|
|
@ExcelProperty("单号")
|
private String no;
|
|
@HeadFontStyle(color = 10)
|
@ExcelProperty("申请时间")
|
private LocalDateTime requestTime;
|
|
@ExcelProperty("申请理由")
|
private String requestReason;
|
|
@ExcelProperty("供应商名称")
|
private String supplierName;
|
|
@ExcelProperty("优惠率(%)")
|
private BigDecimal discountPercent;
|
|
@ExcelProperty("定金金额")
|
private BigDecimal depositPrice;
|
|
@ExcelProperty("备注")
|
private String remark;
|
|
// ========== 明细 ==========
|
|
@HeadFontStyle(color = 10)
|
@ExcelProperty("物料编码")
|
private String productCode;
|
|
@HeadFontStyle(color = 10)
|
@ExcelProperty("单位编码")
|
private String productUnitCode;
|
|
@HeadFontStyle(color = 10)
|
@ExcelProperty("参考单价")
|
private BigDecimal productPrice;
|
|
@HeadFontStyle(color = 10)
|
@ExcelProperty("数量")
|
private BigDecimal count;
|
|
@ExcelProperty("税率(%)")
|
private BigDecimal taxPercent;
|
|
@ExcelProperty("需求日期")
|
private LocalDate demandTime;
|
|
@ExcelProperty(value = "是否需要来料检验(是/否)", converter = YesNoBooleanConverter.class)
|
private Boolean qcCheckFlag;
|
|
@ExcelProperty("明细备注")
|
private String itemRemark;
|
|
}
|
