<?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.yami.shop.distribution.comment.dao.DistributionAuditingSetMapper">
  <resultMap id="BaseResultMap" type="com.yami.shop.distribution.comment.model.DistributionAuditingSet">
    <id column="auditing_set_id" jdbcType="BIGINT" property="auditingSetId" />
    <result column="shop_id" jdbcType="BIGINT" property="shopId" />
    <result column="auditing_conditions_json" jdbcType="VARCHAR" property="auditingConditionsJson" />
    <result column="auditing_info_json" jdbcType="VARCHAR" property="auditingInfoJson" />
    <result column="auto_check" jdbcType="TINYINT" property="autoCheck" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
    <result column="modifier" jdbcType="VARCHAR" property="modifier" />
  </resultMap>

  <select id="getInfoByShopId" resultType="string">
    select
    auditing_info_json
    from
    tz_distribution_auditing_set
    where shop_id = #{shopId}
  </select>
</mapper>

