package com.dy.pipIrrGlobal.voSe; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import com.alibaba.excel.annotation.write.style.ContentRowHeight; import com.alibaba.excel.annotation.write.style.HeadRowHeight; import com.alibaba.fastjson2.annotation.JSONField; import com.alibaba.fastjson2.writer.ObjectWriterImplToString; import com.dy.common.po.BaseEntity; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.annotation.JsonPropertyOrder; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; /** * @author ZhuBaoMin * @date 2024-01-24 17:00 * @LastEditTime 2024-01-24 17:00 * @Description 2024-08-22 朱宝民增加总额字段 */ @Data @JsonPropertyOrder({ "generalId", "cashierId", "cashierName", "tradeAmount", "gift", "refundAmount", "totalAmount", "operateDate", "auditStatus"}) @HeadRowHeight(30) @ContentRowHeight(20) public class VoGeneral implements BaseEntity { private static final long serialVersionUID = 202401241706001L; @Schema(title = "总账ID") @JSONField(serializeUsing= ObjectWriterImplToString.class) @ExcelIgnore private Long generalId; @Schema(title = "收银员ID") @JSONField(serializeUsing= ObjectWriterImplToString.class) @ExcelIgnore private Long cashierId; @ExcelProperty(value = {"${title}", "收银员姓名"}) @ColumnWidth(18) private String cashierName; @ExcelProperty(value = {"${title}", "实收金额"}) @ColumnWidth(15) private Float tradeAmount; @ExcelProperty(value = {"${title}", "赠送金额"}) @ColumnWidth(15) @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) private Float gift; @ExcelProperty(value = {"${title}", "返还金额"}) @ColumnWidth(15) @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) private Float refundAmount; /** * 总额 = 实收金额 + 赠送金额 - 返还金额 */ @ExcelProperty(value = {"${title}", "总额"}) @ColumnWidth(10) @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) private Float totalAmount; @ExcelProperty(value = {"${title}", "交易日期"}) @ColumnWidth(15) private String operateDate; @ExcelProperty(value = {"${title}", "审核状态"}) @ColumnWidth(15) private String auditStatus; }