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();
}