package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.Date; import java.math.BigDecimal; /** * 会员收支记录 * @author 江蹄蹄 * @date 2025/07/09 12:00 */ @Data @ApiModel("会员收支记录") @TableName("`member_revenue`") public class MemberRevenue { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键", example = "1") private Integer id; @ApiModelProperty(value = "是否已删除 0未删除 1已删除", example = "1") private Integer deleted; @ApiModelProperty(value = "创建人编码", example = "1") private Integer createUser; @ApiModelProperty(value = "创建时间") @ExcelColumn(name="交易时间",index = 8,dateFormat = "yyyy-MM-dd HH:mm:ss",width = 10) private Date createTime; @ApiModelProperty(value = "更新人编码", example = "1") private Integer updateUser; @ApiModelProperty(value = "更新时间") private Date updateTime; @ApiModelProperty(value = "备注") private String remark; @ApiModelProperty(value = "会员主键", example = "1") private Integer memberId; @ApiModelProperty(value = "变动类型:0=用工单收入;1=货运单收入;2=供餐单收入;3=提现申请;4=提现失败退回", example = "1") private Integer type; @ApiModelProperty(value = "收支类型:1=收入;-1=支出;", example = "1") @ExcelColumn(name="收支类型", valueMapping="1=收入;-1=支出;",index = 5,width = 5) private Integer optType; @ApiModelProperty(value = "变动金额", example = "1") private Long amount; @ApiModelProperty(value = "变动前金额", example = "1") private Long beforeAmount; @ApiModelProperty(value = "变动后金额", example = "1") private Long afterAmount; @ApiModelProperty(value = "业务记录主键", example = "1") private Integer objId; @ApiModelProperty(value = "业务类型:0=订单业务;1=提现业务;", example = "1") private Integer objType; @ApiModelProperty(value = "业务状态:0=成功;1=失败;2=处理中;", example = "1") private Integer status; @ApiModelProperty(value = "变动类型:0=用工单收入;1=货运单收入;2=供餐单收入;3=提现申请;", example = "1") @TableField(exist = false) @ExcelColumn(name="变动业务类型",index = 7,width = 8) private String typeName; @ApiModelProperty(value = "微信交易流水号", example = "1") @ExcelColumn(name="微信交易流水号",index = 9,width = 8) private String transactionNo; @ApiModelProperty(value = "变查询开始时间", example = "1") @TableField(exist = false) private Date startTime; @ApiModelProperty(value = "变查询结束时间", example = "1") @TableField(exist = false) private Date endTime; @ApiModelProperty(value = "变动金额(元)", example = "1") @TableField(exist = false) @ExcelColumn(name="变动金额(元)",index = 6,width = 8) private Double amountInfo; @ApiModelProperty(value = "用户姓名", example = "1") @TableField(exist = false) @ExcelColumn(name="用户姓名",index = 3,width = 5) private String memberName; @ApiModelProperty(value = "用户昵称", example = "1") @TableField(exist = false) @ExcelColumn(name="用户昵称",index = 2,width = 5) private String memberNickname; @ApiModelProperty(value = "用户手机号", example = "1") @TableField(exist = false) @ExcelColumn(name="用户手机号",index = 4,width = 6) private String memberPhone; @ApiModelProperty(value = "用户openId", example = "1") @TableField(exist = false) @ExcelColumn(name="用户openid" ,index = 1,width = 6) private String openid; @ApiModelProperty(value = "用工类型:0=采摘工;1=分拣工;2=包装工", example = "1") @TableField(exist = false) private Integer workType; }