<?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="com.imooc.o2o.dao.ShopCategoryDao">
    <select id="queryShopCategory" resultType="com.imooc.o2o.entity.ShopCategory">
        SELECT
        shop_category_id,
        shop_category_name,
        shop_category_desc,
        shop_category_img,
        priority,
        create_time,
        last_edit_time,
        parent_id
        FROM
        tb_shop_category
        <where>
            <if test="shopCategoryCondition == null">
                and parent_id is null
            </if>
            <if test="shopCategoryCondition != null">
                and parent_id is not null
            </if>
            <if
                test="shopCategoryCondition != null and shopCategoryCondition.parent != null and shopCategoryCondition.parent.shopCategoryId != null">
                and parent_id = #{shopCategoryCondition.parent.shopCategoryId}
            </if>
        </where>
        ORDER BY
        priority DESC
    </select>
    <select id="queryShopCategoryById" resultType="com.imooc.o2o.entity.ShopCategory">
        SELECT
        shop_category_id,
        shop_category_name,
        shop_category_desc,
        shop_category_img,
        priority,
        create_time,
        last_edit_time,
        parent_id
        FROM
        tb_shop_category
        WHERE
        shop_category_id=#{shopCategoryId}
    </select>
    <select id="queryShopCategoryByIds" resultType="com.imooc.o2o.entity.ShopCategory">
        SELECT
        shop_category_id,
        shop_category_name,
        shop_category_desc,
        shop_category_img,
        priority,
        create_time,
        last_edit_time,
        parent_id
        FROM
        tb_shop_category
        WHERE shop_category_id IN
        <foreach collection="list" item="shopCategoryId" open="("
            separator="," close=")">
            #{shopCategoryId}
        </foreach>
    </select>
    <insert id="insertShopCategory" useGeneratedKeys="true"
        keyProperty="shopCategoryId" keyColumn="shop_category_id">
        INSERT INTO
        tb_shop_category(shop_category_name,shop_category_desc,shop_category_img,
        priority,create_time,last_edit_time,parent_id)
        VALUES
        (#{shopCategoryName},#{shopCategoryDesc},#{shopCategoryImg},
        #{priority},#{createTime},#{lastEditTime},#{parentId})
    </insert>
    <update id="updateShopCategory" parameterType="com.imooc.o2o.entity.ShopCategory">
        update tb_shop_category
        <set>
            <if test="shopCategoryName != null">shop_category_name=#{shopCategoryName},</if>
            <if test="shopCategoryDesc != null">shop_category_desc=#{shopCategoryDesc},</if>
            <if test="shopCategoryImg != null">shop_category_img=#{shopCategoryImg},</if>
            <if test="priority != null">priority=#{priority},</if>
            <if test="lastEditTime != null">last_edit_time=#{lastEditTime},</if>
            <if test="parentId != null">parent_id=#{parentId}</if>
        </set>
        where shop_category_id=#{shopCategoryId}
    </update>
    <delete id="deleteShopCategory">
        DELETE FROM
        tb_shop_category
        WHERE
        shop_category_id =
        #{shopCategoryId}
    </delete>
    <delete id="batchDeleteShopCategory" parameterType="long">
        DELETE FROM
        tb_shop_category
        WHERE shop_category_id IN
        <foreach collection="list" item="shopCategoryId" open="("
            separator="," close=")">
            #{shopCategoryId}
        </foreach>
    </delete>
</mapper>