package excel;
import java.math.BigDecimal;
import java.util.Date;
* @Title: ExcelSource.java
* @Package excel
* @Description: 报表数据源
* @author Zoro
* @date 2016年12月30日 下午2:33:36
* @version V1.0
*/
public class ExcelSource {
@ExcelAnnotation(name = "账单id", col = 0)
private Long billingId;
@ExcelAnnotation(name = "账单号", col = 1)
private String billingNum;
@ExcelAnnotation(name = "店铺id", col = 4)
private Long storeId;
@ExcelAnnotation(name = "店铺名", col = 3)
private String storeName;
@ExcelAnnotation(name = "开户账号", col = 5)
private String bankAccount;
@ExcelAnnotation(name = "开户用户账号", col = 6)
private String bankUsername;
@ExcelAnnotation(name = "开户行", col = 7)
private String bankName;
@ExcelAnnotation(name = "账单总金额", col = 8)
private BigDecimal orderAmount;
@ExcelAnnotation(name = "应付金额", col = 9)
private BigDecimal handleMoney;
@ExcelAnnotation(name = "实付金额", col = 10)
private BigDecimal paidMoney;
@ExcelAnnotation(name = "账单月", col = 11)
private String billingMonth;
@ExcelAnnotation(name = "账单状态", col = 12)
private Integer status;
@ExcelAnnotation(name = "出账日期", col = 13, dateFormat = "yyyy年MM月dd日 HH时mm分ss秒")
private Date issueDateTime;
@ExcelAnnotation(name = "完成时间", col = 15, dateFormat = "yyyy年MM月dd日 HH时mm分ss秒")
private Date completeDateTime;
@ExcelAnnotation(name = "开始时间", col = 14, dateFormat = "yyyy年MM月dd日 HH时mm分ss秒")
private Date startDateTime;
@ExcelAnnotation(name = "结束时间", col = 2, dateFormat = "yyyy年MM月dd日 HH时mm分ss秒")
private Date endDateTime;
public ExcelSource(Long billingId, String billingNum, Long storeId,
String storeName, String bankAccount, String bankUsername,
String bankName, BigDecimal orderAmount, BigDecimal handleMoney,
BigDecimal paidMoney, String billingMonth, Integer status,
Date issueDateTime, Date completeDateTime, Date startDateTime,
Date endDateTime) {
super();
this.billingId = billingId;
this.billingNum = billingNum;
this.storeId = storeId;
this.storeName = storeName;
this.bankAccount = bankAccount;
this.bankUsername = bankUsername;
this.bankName = bankName;
this.orderAmount = orderAmount;
this.handleMoney = handleMoney;
this.paidMoney = paidMoney;
this.billingMonth = billingMonth;
this.status = status;
this.issueDateTime = issueDateTime;
this.completeDateTime = completeDateTime;
this.startDateTime = startDateTime;
this.endDateTime = endDateTime;
}
public Long getBillingId() {
return billingId;
}
public void setBillingId(Long billingId) {
this.billingId = billingId;
}
public String getBillingNum() {
return billingNum;
}
public void setBillingNum(String billingNum) {
this.billingNum = billingNum;
}
public Long getStoreId() {
return storeId;
}
public void setStoreId(Long storeId) {
this.storeId = storeId;
}
public String getStoreName() {
return storeName;
}
public void setStoreName(String storeName) {
this.storeName = storeName;
}
public String getBankAccount() {
return bankAccount;
}
public void setBankAccount(String bankAccount) {
this.bankAccount = bankAccount;
}
public String getBankUsername() {
return bankUsername;
}
public void setBankUsername(String bankUsername) {
this.bankUsername = bankUsername;
}
public String getBankName() {
return bankName;
}
public void setBankName(String bankName) {
this.bankName = bankName;
}
public BigDecimal getOrderAmount() {
return orderAmount;
}
public void setOrderAmount(BigDecimal orderAmount) {
this.orderAmount = orderAmount;
}
public BigDecimal getHandleMoney() {
return handleMoney;
}
public void setHandleMoney(BigDecimal handleMoney) {
this.handleMoney = handleMoney;
}
public BigDecimal getPaidMoney() {
return paidMoney;
}
public void setPaidMoney(BigDecimal paidMoney) {
this.paidMoney = paidMoney;
}
public String getBillingMonth() {
return billingMonth;
}
public void setBillingMonth(String billingMonth) {
this.billingMonth = billingMonth;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public Date getIssueDateTime() {
return issueDateTime;
}
public void setIssueDateTime(Date issueDateTime) {
this.issueDateTime = issueDateTime;
}
public Date getCompleteDateTime() {
return completeDateTime;
}
public void setCompleteDateTime(Date completeDateTime) {
this.completeDateTime = completeDateTime;
}
public Date getStartDateTime() {
return startDateTime;
}
public void setStartDateTime(Date startDateTime) {
this.startDateTime = startDateTime;
}
public Date getEndDateTime() {
return endDateTime;
}
public void setEndDateTime(Date endDateTime) {
this.endDateTime = endDateTime;
}
}
