<resultMap id="map1" type="com.health.pojo.Order">
<id property="id" column="id"/>
<result property="memberId" column="memberId"/>
<result property="orderDate" column="orderDate"/>
<result property="orderType" column="orderType"/>
<result property="orderState" column="orderState"/>
<result property="setmealId" column="setmealId"/>
<association property="member" column="id" resultMap="memberMap" javaType="com.health.pojo.Member"></association>
<association property="setMeal" column="id" resultMap="setmealMap" javaType="com.health.pojo.SetMeal"></association>
</resultMap>
<resultMap id="setmealMap" type="com.health.pojo.SetMeal">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="code" column="code"/>
<result property="helpCode" column="helpCode"/>
<result property="sex" column="sex"/>
<result property="age" column="age"/>
<result property="price" column="price"/>
<result property="remark" column="remark"/>
<result property="attention" column="attention"/>
<result property="img" column="img"/>
</resultMap>
<resultMap id="memberMap" type="com.health.pojo.Member">
<id property="id" column="id"/>
<result property="fileNumber" column="fileNumber"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
<result property="idCard" column="idCard"/>
<result property="phoneNumber" column="phoneNumber"/>
<result property="regTime" column="regTime"/>
<result property="email" column="email"/>
<result property="birthday" column="birthday"/>
<result property="remark" column="remark"/>
</resultMap>
<select id="showOrderList" resultMap="map1" parameterType="map">
select o.,m.,s.*
from t_order o left outer join t_setmeal s on o.setmealId=s.id left outer join t_member m on o.memberId=m.id
<where>
<if test="setmealName!=null and setmealName!=''">
and s.name like concat('%',#{setmealName},'%')
</if>
<if test="queryString!=null and queryString!=''">
and (m.name like CONCAT('%',#{queryString},'%') or m.phoneNumber like CONCAT('%',#{queryString},'%'))
</if>
<if test="orderType!=null and orderType!=''">
and o.orderType =#{orderType}
</if>
<if test="orderState!=null and orderState!='' ">
and o.orderState=#{orderState}
</if>
<if test="startDate!=null and startDate!='' and endDate!=null and endDate!=''">
and (o.orderDate between #{startDate} and #{endDate})
</if>
</where>
</select>