package com.ruoyi.warehouseBusiness.excel; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.common.annotation.Excel; import java.math.BigDecimal; import java.util.Date; /** * 查询菜单导出 * * @author shz * @date 2021-12-17 */ public class QueryMenu { private static final long serialVersionUID = 1L; /** * 客户姓名 */ @Excel(name = "客户姓名") private String corpName; /** * 提单号 */ @Excel(name = "提单号") private String fMblno; /** * 业务日期 */ @Excel(name = "业务日期", width = 30, dateFormat = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date fBsdate; /** * 审核日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "审核日期", width = 30, dateFormat = "yyyy-MM-dd") private Date fReviewDate; /** * 计费起始日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "费用起始日期", width = 30, dateFormat = "yyyy-MM-dd") private Date fChargedate; /** * 计费截止日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "费用截止日期", width = 30, dateFormat = "yyyy-MM-dd") private Date fBillingDeadline; /** * 原始入库日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "原始入库日期", width = 30, dateFormat = "yyyy-MM-dd") private Date fOriginalbilldate; /** * 费用名称 */ @Excel(name = "费用名称") private String feeName; /** * 费用状态 */ @Excel(name = "费用状态") private String fBillstatusName; /** * 收、付,D:收 C:付 */ @Excel(name = "收/付", readConverterExp = "D=收,C=付") private String fDc; /** * 金额 */ @Excel(name = "金额") private BigDecimal fAmount; /** * 汇率 */ @Excel(name = "汇率") private String fExrate; /** * 税率 */ @Excel(name = "税率") private String fTaxrate; /** * 结算金额 */ @Excel(name = "结算金额") private BigDecimal fStlamount; /** * 结算日期 */ @Excel(name = "结算日期", width = 30, dateFormat = "yyyy-MM-dd") private Date fStlamountDate; /** * 开票金额 */ @Excel(name = "开票金额") private BigDecimal fInvamount; /** * 发票号 */ @Excel(name = "发票号") private String fInvnos; /** * 对账金额 */ @Excel(name = "对账金额") private BigDecimal fAccamount; /** * 对账日期 */ @Excel(name = "对账日期", width = 30, dateFormat = "yyyy-MM-dd") @JsonFormat(pattern = "yyyy-MM-dd") private Date fAccamountDate; /** * 对账单号 */ @Excel(name = "对账单号") private String fStatementNo; /** * 计价单位 */ @Excel(name = "计价单位", readConverterExp = "1=件数,2=毛重,3=净重,4=尺码,5=固定,6=其他,7=箱量") private Integer fFeeunitid; /** * 数量 */ @Excel(name = "数量") private BigDecimal fQty; /** * 单价 */ @Excel(name = "单价") private BigDecimal fUnitprice; /** * 业务类型 */ @Excel(name = "业务类型", readConverterExp = "SJRK=入库,SJCK=实际出库,CKDB=调拨,HQZY=货权转移,CDZZ=场地直装") private String fBilltype; /** * 业务编号 */ @Excel(name = "业务编号") private String fSrcBillno; /** * 货物名称 */ @Excel(name = "货物名称") private String fProductName; /** * 结算方式 */ @Excel(name = "结算方式", dictType = "data_stltype_type") private Long fStltypeid; /** * 备注 */ @Excel(name = "备注") private String remark; /** * 发货方 */ @Excel(name = "发货方") private String fShipper; /** 出口单号 */ @Excel(name = "出口单号") private String fEmblno; public String getfExrate() { return fExrate; } public void setfExrate(String fExrate) { this.fExrate = fExrate; } public String getfTaxrate() { return fTaxrate; } public void setfTaxrate(String fTaxrate) { this.fTaxrate = fTaxrate; } public Date getfBillingDeadline() { return fBillingDeadline; } public void setfBillingDeadline(Date fBillingDeadline) { this.fBillingDeadline = fBillingDeadline; } public Date getfOriginalbilldate() { return fOriginalbilldate; } public void setfOriginalbilldate(Date fOriginalbilldate) { this.fOriginalbilldate = fOriginalbilldate; } public String getfEmblno() { return fEmblno; } public void setfEmblno(String fEmblno) { this.fEmblno = fEmblno; } public Date getfChargedate() { return fChargedate; } public void setfChargedate(Date fChargedate) { this.fChargedate = fChargedate; } public String getfSrcBillno() { return fSrcBillno; } public void setfSrcBillno(String fSrcBillno) { this.fSrcBillno = fSrcBillno; } public String getfShipper() { return fShipper; } public void setfShipper(String fShipper) { this.fShipper = fShipper; } public String getCorpName() { return corpName; } public void setCorpName(String corpName) { this.corpName = corpName; } public String getfMblno() { return fMblno; } public void setfMblno(String fMblno) { this.fMblno = fMblno; } public Date getfBsdate() { return fBsdate; } public void setfBsdate(Date fBsdate) { this.fBsdate = fBsdate; } public Date getfReviewDate() { return fReviewDate; } public void setfReviewDate(Date fReviewDate) { this.fReviewDate = fReviewDate; } public String getFeeName() { return feeName; } public void setFeeName(String feeName) { this.feeName = feeName; } public String getfBillstatusName() { return fBillstatusName; } public void setfBillstatusName(String fBillstatusName) { this.fBillstatusName = fBillstatusName; } public String getfDc() { return fDc; } public void setfDc(String fDc) { this.fDc = fDc; } public BigDecimal getfAmount() { return fAmount; } public void setfAmount(BigDecimal fAmount) { this.fAmount = fAmount; } public BigDecimal getfStlamount() { return fStlamount; } public void setfStlamount(BigDecimal fStlamount) { this.fStlamount = fStlamount; } public BigDecimal getfInvamount() { return fInvamount; } public void setfInvamount(BigDecimal fInvamount) { this.fInvamount = fInvamount; } public BigDecimal getfAccamount() { return fAccamount; } public void setfAccamount(BigDecimal fAccamount) { this.fAccamount = fAccamount; } public BigDecimal getfUnitprice() { return fUnitprice; } public void setfUnitprice(BigDecimal fUnitprice) { this.fUnitprice = fUnitprice; } public Date getfStlamountDate() { return fStlamountDate; } public void setfStlamountDate(Date fStlamountDate) { this.fStlamountDate = fStlamountDate; } public String getfInvnos() { return fInvnos; } public void setfInvnos(String fInvnos) { this.fInvnos = fInvnos; } public Date getfAccamountDate() { return fAccamountDate; } public void setfAccamountDate(Date fAccamountDate) { this.fAccamountDate = fAccamountDate; } public String getfStatementNo() { return fStatementNo; } public void setfStatementNo(String fStatementNo) { this.fStatementNo = fStatementNo; } public Integer getfFeeunitid() { return fFeeunitid; } public void setfFeeunitid(Integer fFeeunitid) { this.fFeeunitid = fFeeunitid; } public BigDecimal getfQty() { return fQty; } public void setfQty(BigDecimal fQty) { this.fQty = fQty; } public String getfBilltype() { return fBilltype; } public void setfBilltype(String fBilltype) { this.fBilltype = fBilltype; } public String getfProductName() { return fProductName; } public void setfProductName(String fProductName) { this.fProductName = fProductName; } public Long getfStltypeid() { return fStltypeid; } public void setfStltypeid(Long fStltypeid) { this.fStltypeid = fStltypeid; } public String getRemark() { return remark; } public void setRemark(String remark) { this.remark = remark; } @Override public String toString() { return "QueryMenu{" + "corpName='" + corpName + '\'' + ", fMblno='" + fMblno + '\'' + ", fBsdate=" + fBsdate + ", fReviewDate=" + fReviewDate + ", feeName='" + feeName + '\'' + ", fBillstatusName='" + fBillstatusName + '\'' + ", fDc='" + fDc + '\'' + ", fAmount=" + fAmount + ", fStlamount=" + fStlamount + ", fStlamountDate=" + fStlamountDate + ", fInvamount=" + fInvamount + ", fInvnos='" + fInvnos + '\'' + ", fAccamount=" + fAccamount + ", fAccamountDate=" + fAccamountDate + ", fStatementNo='" + fStatementNo + '\'' + ", fFeeunitid=" + fFeeunitid + ", fQty=" + fQty + ", fUnitprice=" + fUnitprice + ", fBilltype='" + fBilltype + '\'' + ", fProductName='" + fProductName + '\'' + ", fStltypeid=" + fStltypeid + ", remark='" + remark + '\'' + '}'; } }