yhlxj/netflix-dao/src/main/java/com/cyksj/model/excel/ExcelBannerNfAccountData.java

package com.cyksj.model.excel;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

import java.util.Date;

/**
 * 项目名: yhlxj11111111
 * 文件名: ExcelBannerNfAccountData
 * 创建者: JavaZou
 * 创建时间:2025/11/10 14:27
 */
@Getter
@Setter
@SearchBean(tables = "netflix_user_account_status_record ans left join goods_don_sku sku on sku.id = ans.sku_id" +
		" left join account a on a.id = ans.account_id",
		where = "ans.state = 3",
		groupBy = "ans.account,ans.sku_id,sku.goods_id")
@ExcelIgnoreUnannotated
public class ExcelBannerNfAccountData {
	@DbField("ans.account")
	@ExcelProperty("账号")
	private String account;

	@DbField("any_value(ans.password)")
	@ExcelProperty("密码")
	private String password;

	@DbField("min(ans.created_time)")
	@ExcelProperty("检测时间")
	private Date createdTime;

	@DbField("ans.sku_id")
	private Long skuId;

	@DbField("sku.spec_val")
	@ExcelProperty("规格")
	private String specVal;

	@DbField("any_value(a.start_time)")
	@ExcelProperty("首开时间")
	private Date startTime;

	@DbField("any_value(a.remark)")
	@ExcelProperty("备注")
	private String remark;
}