<!--author:wlj -->
<!--date:2016-05-19 -->
<!--desc:查询用户(商家,普通用户)信息列表,根据账号,昵称模糊查询 -->
<select id="listUserPage" resultType="Dto" parameterType="Dto">
SELECT
<include refid="cn.usmaker.common.dao.mapper.Shop_userMapper.column2" />,
(select nickname_ from shop_user as p_user where p_user.id_ = shop_user.fk_introducer_id_) as
introducer_name_
from shop_user
<where>
<if test="hotkey !=null and hotkey !=''">
and
( shop_user.account_ like '%${hotkey}%'
or
shop_user.nickname_ like '%${hotkey}%'
)
</if>
<if test="true">
and
shop_user.type_=#{type_}<!--用户类型:1:普通用户;2:商家用户 -->
</if>
</where>