一些sql

-----------------------------------------------------------------------------
date_format(`a`.`lossDate` , '%Y-%m-%d') AS lossDate (xml文件该日期格式
-----------------------------------------------------------------------------
CASE a.status WHEN 1 THEN '等待处理' WHEN 2 THEN '处理通过'
		WHEN 3 THEN '拒绝' WHEN 4 THEN '作废' END statusName
-----------------------------------------------------------------------------
c.name like '%${devName}%'
-----------------------------------------------------------------------------
SELECT
	    b.*
	FROM(
		SELECT
			a.*
		FROM
			`fineone_base_appoint` a
		where
			a.del_flag = 0
		  and a.type = #{am.type}
		<include refid="appointQuery" />

		union all

		SELECT
			a.*
		FROM
			`fineone_base_appoint` a
		where
			a.del_flag = 0
		  and a.is_submit != 0
		  and ( a.type = 2
		  	or a.type = 3
			<choose>
				<when test="am.type != null and am.type==4">
					or a.type = 1
				</when>
				<otherwise>
					or a.type = 4
				</otherwise>
			</choose>
		   )
		<include refid="appointQuery" />
		)b
		order by b.create_date desc
-----------------------------------------------------------------------------

<if test="lp.start_time != null and lp.start_time != ''">
			and	 date_format(	a.create_date, '%Y-%m-%d') <![CDATA[>=]]> date_format(#{lp.start_time}, '%Y-%m-%d')
		</if>
		<if test="lp.end_time != null and lp.end_time != ''">
			and	 date_format(	a.create_date, '%Y-%m-%d') <![CDATA[<=]]> date_format(#{lp.end_time}, '%Y-%m-%d')
		</if>
-----------------------------------------------------------------------------
SELECT
			count(*)
		FROM <include refid="masterTable" /> a
		where a.comCode = #{comCode}
		and a.entryDate &gt;= CONCAT(CURDATE(),' 00:00:00')
		and a.entryDate &lt;= CONCAT(DATE_ADD(CURDATE(),INTERVAL 1 DAY)