<?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.purchase.DictionaryTagPurchaseStateDao">

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

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

	<select id="listByIds" resultType="com.scm.contract.model.purchase.DictionaryTagPurchaseState">
		SELECT
		<include refid="columns"/>
		FROM dictionary_tag_purchase_state 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.purchase.DictionaryTagPurchaseState">
		SELECT
		<include refid="columns"/>
		FROM dictionary_tag_purchase_state a
		<include refid="joins"/>
	</select>

</mapper>
