package cn.exrick.xboot.your.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import cn.exrick.xboot.your.entity.DuoZheng;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* 一户多证表数据处理层
|
* @author whj
|
*/
|
public interface DuoZhengMapper extends BaseMapper<DuoZheng> {
|
|
@Select("select DISTINCT(c.name) as customer_name,a.name,a.phone from t_customer_receive a,t_customer_receive b,t_customer c where a.name=b.name and a.phone=b.phone and a.customer_id<>b.customer_id and a.customer_id = c.id")
|
List<DuoZheng> getYiHuDuoZheng();
|
|
@Select("select DISTINCT(name) from t_duo_zheng")
|
List<String> getNames();
|
}
|
