添加查询jumpDetail

yujian

2020-05-22 2a51fd9d05a1dd306dfb480a8789a204cbbdeef0

添加查询jumpDetail

 fanli/src/main/java/com/yeshi/fanli/mapping/homemodule/SwiperPictureMapper.xml

@@ -21,8 +21,10 @@
        <result column="pic_updatetime" property="updatetime" jdbcType="TIMESTAMP" />
        <result column="pic_title" property="title" jdbcType="VARCHAR" />
        <result column="pic_desc" property="desc" jdbcType="VARCHAR" />
			
        <association property="jumpDetail" column="pic_jumpid"
            resultMap="com.yeshi.fanli.dao.mybatis.common.JumpDetailV2Mapper.BaseResultMap" />
            select="com.yeshi.fanli.dao.mybatis.common.JumpDetailV2Mapper.selectByPrimaryKey">
        </association>

    </resultMap>
    <sql id="Base_Column_List">pic_id,pic_banner_id,pic_src,pic_jumpid,pic_params,pic_jump_need_login,pic_order,pic_remark,pic_state,pic_auto_control,pic_start_time,pic_end_time,pic_createtime,pic_updatetime,pic_title,pic_desc
@@ -124,10 +126,9 @@
        </set>
        where pic_id = #{id,jdbcType=BIGINT}
    </update>
    <select id="queryByBannerID" resultMap="BaseResultMap">SELECT * FROM
        yeshi_ec_swiper_banner_picture p LEFT JOIN
        `yeshi_ec_action_jumpdetail_v2` j ON j.`jp_id` = p.`pic_jumpid` WHERE
        pic_banner_id = #{bannerId} ORDER BY pic_order LIMIT ${start},${count}
    <select id="queryByBannerID" resultMap="BaseResultMap">
        SELECT * FROM yeshi_ec_swiper_banner_picture p
         WHERE    pic_banner_id = #{bannerId} ORDER BY pic_order LIMIT ${start},${count}
    </select>
    <select id="countQueryByBannerID" resultType="java.lang.Long">SELECT
        IFNULL(count(pic_id),0) FROM yeshi_ec_swiper_banner_picture WHERE
@@ -175,16 +176,14 @@
    <select id="getByBannerCard" resultMap="BaseResultMap">SELECT
        * FROM `yeshi_ec_swiper_banner` w LEFT JOIN
        `yeshi_ec_swiper_banner_picture` p ON p.`pic_banner_id` = w.`sp_id`
        LEFT JOIN `yeshi_ec_action_jumpdetail_v2` j ON j.`jp_id` =
        p.`pic_jumpid` WHERE w.`sp_card` = #{card} AND w.`sp_state` = 0 AND
        WHERE w.`sp_card` = #{card} AND w.`sp_state` = 0 AND
        p.`pic_state`= 0<![CDATA[AND IF(p.`pic_auto_control` = 1, p.`pic_start_time` <= NOW() AND p.`pic_end_time` >= NOW(),TRUE)]]>
        ORDER BY p.`pic_order`
    </select>
    <select id="getByBannerId" resultMap="BaseResultMap">SELECT
        * FROM `yeshi_ec_swiper_banner` w LEFT JOIN
        `yeshi_ec_swiper_banner_picture` p ON p.`pic_banner_id` = w.`sp_id`
        LEFT JOIN `yeshi_ec_action_jumpdetail_v2` j ON j.`jp_id` =
        p.`pic_jumpid` WHERE w.`sp_id` = #{bannerId} AND w.`sp_state` = 0 AND
        WHERE w.`sp_id` = #{bannerId} AND w.`sp_state` = 0 AND
        p.`pic_state`= 0<![CDATA[AND IF(p.`pic_auto_control` = 1, p.`pic_start_time` <= NOW() AND p.`pic_end_time` >= NOW(),TRUE)]]>
        ORDER BY p.`pic_order`
    </select>