package com.cyksj.model.excel; import com.ejlchina.searcher.bean.SearchBean; import lombok.Getter; import lombok.Setter; /* *项目名: netflix *文件名: ExcelRealGoodsUserInterestHasPaymentData *创建者: JavaZou *创建时间:2022/12/19 18:25 */ @Getter @Setter @SearchBean(tables = "real_goods_interest_user ru " + " left join goods_don_sku gdk on gdk.id = ru.sku_id" + " left join user u on u.id = ru.user_id" + " left join goods_don gd on gd.id = gdk.goods_id" + " left join order_don_transport ot on ot.order_id = ru.order_id", where = "ru.order_created_time < DATE_ADD(ru.pay_time,interval -1 day)") public class ExcelRealGoodsUserInterestHasPaymentData extends ExcelRealGoodsUserInterestData { }