-----------------------------------------------------------------------------
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 >= CONCAT(CURDATE(),' 00:00:00')
and a.entryDate <= CONCAT(DATE_ADD(CURDATE(),INTERVAL 1 DAY)
一些sql
于 2023-05-20 16:09:16 首次发布