package com.ruoyi.system.importExcel;
|
|
import cn.afterturn.easypoi.excel.annotation.Excel;
|
import com.baomidou.mybatisplus.annotation.TableField;
|
import io.swagger.annotations.ApiModel;
|
import io.swagger.annotations.ApiModelProperty;
|
import lombok.Data;
|
|
@Data
|
@ApiModel(value = "商品导入Excel")
|
public class TErpGoodsExcel {
|
|
|
@Excel(width = 30,name = "*商品名称")
|
private String goodsName;
|
|
@Excel(width = 30,name = "*商品标识码")
|
private String goodsIdCode;
|
|
@Excel(width = 30,name = "*国药准字号")
|
private String quasiNumber;
|
|
@Excel(width = 30,name = "*生产厂家")
|
private String manufacturer;
|
|
@Excel(width = 30,name = "*制剂规格")
|
private String formulationSpec;
|
|
@Excel(width = 30,name = "*包装规格")
|
private String packingSpec;
|
|
|
@Excel(width = 30,name = "商品69码")
|
private String goodsYards;
|
|
@Excel(width = 30,name = "保养周期(天)")
|
private String maintenanceInterval;
|
|
@Excel(width = 30,name = "最低采购数量")
|
private String lowPurchaseQuantity;
|
|
@Excel(width = 30,name = "最低采购单位")
|
private String lowUnitName;
|
|
@Excel(width = 30,name = "是否为处方药",replace = {"1_是","2_否"})
|
private String isPrescriptionDrug;
|
|
@ApiModelProperty(value = "商品规格")
|
@TableField("goods_spec")
|
private String goodsSpec;
|
|
|
@Excel(width = 30,name = "*预警库存")
|
private String warningInventory;
|
|
@ApiModelProperty(value = "商品售价")
|
@TableField("sales_amount")
|
private String salesAmount;
|
|
|
@Excel(width = 30,name = "包装单位")
|
private String packingUnitName;
|
|
@Excel(width = 30,name = "使用说明")
|
private String instructionsUse;
|
|
@Excel(width = 30,name = "副作用")
|
private String sideEffect;
|
|
@Excel(width = 30,name = "*诊所采购价")
|
private String clinicPurchasePrice;
|
|
@Excel(width = 30,name = "*商品类型")
|
private String typeName;
|
|
@Excel(width = 30,name = "拼音简码")
|
private String simplifiedCode;
|
|
@Excel(width = 30,name = "剂型")
|
private String dosageForm;
|
|
@Excel(width = 30,name = "用途分类")
|
private String usageClassification;
|
|
@Excel(width = 30,name = "商品名(品牌)")
|
private String productBrand;
|
|
@Excel(width = 30,name = "产地")
|
private String placeOfOrigin;
|
|
@Excel(width = 30,name = "主要成分")
|
private String ingredient;
|
|
@Excel(width = 30,name = "性状")
|
private String trait;
|
|
@Excel(width = 30,name = "适应症")
|
private String indication;
|
|
@Excel(width = 30,name = "禁忌")
|
private String taboo;
|
|
@Excel(width = 30,name = "注意事项")
|
private String precautions;
|
|
@Excel(width = 30,name = "相互作用")
|
private String interaction;
|
|
@Excel(width = 30,name = "贮藏")
|
private String storage;
|
|
|
|
|
}
|
