yhlxj/netflix-dao/src/main/java/com/cyksj/model/views/OrderDonLocationRelateView.java

package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

/**
 * 项目名: yhlxj
 * 文件名: OrderDonLocationRelateView
 * 创建者: JavaZou
 * 创建时间:2024/7/8 11:35
 */
@Getter
@Setter
@SearchBean(tables = "(select id,user_id from order_don :userId:) o inner join order_don_location_relate ocr on ocr.order_id = o.id",
		groupBy = "ocr.ip")
public class OrderDonLocationRelateView {
	@DbField("any_value(o.user_id)")
	private Long uid;

	@DbField("ocr.ip")
	private String ip;

	@DbField("concat(max(ocr.country),max(ocr.province),max(ocr.city))")
	private String address;
}