Mybatis分页带<if>

ActivityJoinInfoMapper.java

 复制代码
package cn.jmfen.sport.activitycenter.mapper;
import cn.jmfen.sport.activitycenter.bo.ActivityJoinBo;
import cn.jmfen.sport.activitycenter.vo.ActivityJoinVo;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
/**
 * @Author: Luoma
 * @Description: 活动流水
 * @Date: 2020/2/18 15:59
 */
@Mapper
public interface ActivityJoinInfoMapper {
    /**
     * 查询活动流水列表分页
     * @param page
     * @param activityJoinBo
     * @return
     */
    Page<ActivityJoinVo> queryJoinInfoListByPage(@Param("page") Page page, @Param("joinBo") ActivityJoinBo activityJoinBo);
}

ActivityJoinInfoMapper.xml

 复制代码
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.jmfen.sport.activitycenter.mapper.ActivityJoinInfoMapper">
    <select id="queryJoinInfoListByPage" resultType="cn.jmfen.sport.activitycenter.vo.ActivityJoinVo">
        SELECT
        j.id,
        j.activity_id,
        b.activity_name,
        j.user_id,
        c.user_nickname username,
        c.lottery_code_status drawStatus,
        GROUP_CONCAT(c.lottery_code) lotteryCodeStr,
        (
        SELECT DISTINCT r.winner_lottery_codes
        FROM jmf_activity_round r
        WHERE r.activity_id = j.activity_id AND r.id = j.activity_round_id and r.round_num = j.round_num
        ) winnerLotteryCodeStr,
        j.join_device,
        j.promotion_channel,
        j.join_time
        from jmf_activity_join j
        LEFT JOIN jmf_activity_base_info b on b.id = j.activity_id
        LEFT JOIN jmf_activity_lottery_code c on c.activity_join_id = j.id
        <where>
            <if test="joinBo.activityName != null and joinBo.activityName != ''">
                and b.activity_name like concat('%',#{joinBo.activityName},'%')
            </if>
            <if test="joinBo.promotionChannel != null and joinBo.promotionChannel != ''">
                and j.promotion_channel = #{joinBo.promotionChannel}
            </if>
            <if test="joinBo.drawStatus != null and joinBo.drawStatus != '' or joinBo.drawStatus == 0 ">
                and c.lottery_code_status = #{joinBo.drawStatus}
            </if>
            <if test="joinBo.userSearchText != null and joinBo.userSearchText.length > 0">
                and (
                j.user_id like concat('%',#{joinBo.userSearchText},'%') or
                c.user_nickname like concat('%',#{joinBo.userSearchText},'%')
                )
            </if>
            <if test="joinBo.startJoinTime != null and joinBo.startJoinTime !=''">
                <![CDATA[ and j.join_time >=STR_TO_DATE(#{joinBo.startJoinTime}, '%Y-%m-%d %H:%i:%s') ]]>
            </if>
            <if test="joinBo.endJoinTime !=null and joinBo.endJoinTime !=''">
                <![CDATA[ and j.join_time <=STR_TO_DATE(#{joinBo.endJoinTime}, '%Y-%m-%d %H:%i:%s') ]]>
            </if>
        </where>
        GROUP BY j.id
        order by j.join_time desc
    </select>
</mapper>