package cn.iocoder.yudao.module.erp.controller.admin.purchase.vo.plan;
|
|
import cn.idev.excel.annotation.ExcelProperty;
|
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 ErpPurchasePlanImportExcelVO {
|
|
@ExcelProperty("单号")
|
private String no;
|
|
@ExcelProperty("计划名称")
|
private String name;
|
|
@ExcelProperty("需求来源(1库存预警/2运维生产计划)")
|
private Integer demandSource;
|
|
@ExcelProperty("计划日期")
|
private LocalDateTime planDate;
|
|
@ExcelProperty("供应商名称")
|
private String supplierName;
|
|
@ExcelProperty("备注")
|
private String remark;
|
|
// ========== 明细 ==========
|
|
@ExcelProperty("物料编码")
|
private String productCode;
|
|
@ExcelProperty("单位编码")
|
private String productUnitCode;
|
|
@ExcelProperty("数量")
|
private BigDecimal count;
|
|
@ExcelProperty("需求日期")
|
private LocalDate demandTime;
|
|
@ExcelProperty("明细备注")
|
private String itemRemark;
|
|
}
|