跳转方式增加小程序

admin

2020-01-08 d40e978df4717d91f72f6e295c58f98524bbd29c

跳转方式增加小程序

 fanli/src/main/java/com/yeshi/fanli/mapping/common/JumpDetailV2Mapper.xml

@@ -9,12 +9,13 @@
        <result column="jp_controller" property="controller" jdbcType="VARCHAR" />

        <result column="jp_type" property="type" jdbcType="VARCHAR" />

        <result column="jp_need_login" property="needLogin" jdbcType="BOOLEAN" />

        <result column="jp_path" property="path" jdbcType="VARCHAR" />

        <result column="jp_min_android_version" property="minAndroidAppVersion"

            jdbcType="INTEGER" />

        <result column="jp_min_ios_version" property="minIOSAppVersion"

            jdbcType="INTEGER" />

    </resultMap>

    <sql id="Base_Column_List">jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login,jp_min_android_version,jp_min_ios_version

    <sql id="Base_Column_List">jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login,jp_min_android_version,jp_min_ios_version,jp_path

    </sql>

    <select id="selectByPrimaryKey" resultMap="BaseResultMap"

        parameterType="java.lang.Long">

@@ -28,9 +29,9 @@
    <insert id="insert" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2"

        useGeneratedKeys="true" keyProperty="id">insert into

        yeshi_ec_action_jumpdetail_v2

        (jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login,jp_min_android_version,jp_min_ios_version)

        (jp_id,jp_name,jp_activity,jp_controller,jp_type,jp_need_login,jp_min_android_version,jp_min_ios_version,jp_path)

        values

        (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{activity,jdbcType=VARCHAR},#{controller,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR},#{needLogin,jdbcType=BOOLEAN},#{minAndroidAppVersion,jdbcType=INTEGER},#{minIOSAppVersion,jdbcType=INTEGER})

        (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{activity,jdbcType=VARCHAR},#{controller,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR},#{needLogin,jdbcType=BOOLEAN},#{minAndroidAppVersion,jdbcType=INTEGER},#{minIOSAppVersion,jdbcType=INTEGER},#{path,jdbcType=VARCHAR})

    </insert>

    <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2"

        useGeneratedKeys="true" keyProperty="id">

@@ -44,6 +45,7 @@
            <if test="needLogin != null">jp_need_login,</if>

            <if test="minAndroidAppVersion != null">jp_min_android_version,</if>

            <if test="minIOSAppVersion != null">jp_min_ios_version,</if>

            <if test="path != null">jp_path,</if>

        </trim>

        values

        <trim prefix="(" suffix=")" suffixOverrides=",">

@@ -55,6 +57,7 @@
            <if test="needLogin != null">#{jp_need_login,jdbcType=BOOLEAN},</if>

            <if test="minAndroidAppVersion != null">#{minAndroidAppVersion,jdbcType=INTEGER}</if>

            <if test="minIOSAppVersion != null">#{minIOSAppVersion,jdbcType=INTEGER}</if>

            <if test="path != null">#{path,jdbcType=VARCHAR}</if>

        </trim>

    </insert>

    <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2">update

@@ -64,7 +67,10 @@
        #{controller,jdbcType=VARCHAR},jp_type =

        #{type,jdbcType=VARCHAR},jp_need_login = #{needLogin,jdbcType=BOOLEAN}

        ,jp_min_android_version =#{minAndroidAppVersion,jdbcType=INTEGER}

        ,jp_min_ios_version =#{minIOSAppVersion,jdbcType=INTEGER} where jp_id

        ,jp_min_ios_version =#{minIOSAppVersion,jdbcType=INTEGER} 
        ,jp_path =#{path,jdbcType=VARCHAR}

		
        where jp_id

        = #{id,jdbcType=BIGINT}</update>

    <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.common.JumpDetailV2">

        update yeshi_ec_action_jumpdetail_v2

@@ -77,6 +83,9 @@
            <if test="minAndroidAppVersion !=null">jp_min_android_version

                =#{minAndroidAppVersion,jdbcType=INTEGER},</if>

            <if test="minIOSAppVersion !=null">jp_min_ios_version =#{minIOSAppVersion,jdbcType=INTEGER},

            </if>

			
            <if test="path !=null">jp_path =#{path,jdbcType=VARCHAR},

            </if>

        </set>

        where jp_id = #{id,jdbcType=BIGINT}

@@ -104,22 +113,24 @@
        1=1

        <if test="key != null and key != &quot;&quot;">AND (jp_name like '%${key}%')</if>

    </select>

	
	




    <select id="selectAndroidByTypeAndVersion" resultMap="BaseResultMap">

        select

        <include refid="Base_Column_List" />

        from yeshi_ec_action_jumpdetail_v2  jv 
        WHERE jv.`jp_type`=#{type} AND #{version}>=jv.`jp_min_android_version` ORDER BY  jv.`jp_min_android_version` DESC LIMIT 1

        from yeshi_ec_action_jumpdetail_v2 jv

        WHERE jv.`jp_type`=#{type} AND #{version}>=jv.`jp_min_android_version`

        ORDER BY jv.`jp_min_android_version` DESC LIMIT 1

    </select>

	


    <select id="selectIOSByTypeAndVersion" resultMap="BaseResultMap">

        select

        <include refid="Base_Column_List" />

        from yeshi_ec_action_jumpdetail_v2  jv 
        WHERE jv.`jp_type`=#{type} AND #{version}>=jv.`jp_min_ios_version` ORDER BY  jv.`jp_min_ios_version` DESC LIMIT 1

        from yeshi_ec_action_jumpdetail_v2 jv

        WHERE jv.`jp_type`=#{type} AND #{version}>=jv.`jp_min_ios_version` ORDER BY

        jv.`jp_min_ios_version` DESC LIMIT 1

    </select>

	


    <delete id="deleteBatchByPrimaryKey" parameterType="java.util.List">

        delete from yeshi_ec_action_jumpdetail_v2 WHERE jp_id in

        <foreach collection="list" item="item" open="(" close=")"