<?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.scm.contract.dao.apply.DictionaryTagTypeDao">

	<sql id="columns">
		a.`id` AS "id",
		a.`name` AS "name",
		a.`price` AS "price",
		a.`alarm` AS "alarm"
	</sql>

	<sql id="joins">
	</sql>

    <select id="listByIds" resultType="com.scm.contract.model.apply.DictionaryTagType">
		SELECT
		<include refid="columns"/>
		FROM dictionary_tag_type a
		<include refid="joins"/>
		WHERE a.id IN
		<foreach item="id" index="index" collection="ids" open="(" separator="," close=")">
			#{id}
		</foreach>
	</select>

    <select id="list" resultType="com.scm.contract.model.apply.DictionaryTagType">
		SELECT
		<include refid="columns"/>
		FROM dictionary_tag_type a
		<include refid="joins"/>
	</select>

</mapper>
