parameterType="String">
SELECT
receive_car_code,
use_time,
sc.coupon_name
FROM
car_coupon cc
LEFT JOIN (SELECT * FROM sys_coupon WHERE coupon_id IN(SELECT coupon_id
FROM sys_coupon_company WHERE 1=1
AND company_id=#{companyId}
)) sc
ON sc.coupon_id = cc.coupon_id
WHERE 1 = 1
AND
(cc.receive_car_code like CONCAT('%',#{keyword},'%') )
AND
sc.oper_datetime < #{endDate}
AND
sc.oper_datetime > #{startDate}
</select>
<select id="getReportAutoCount" resultType="int">
SELECT
count(1)
FROM
car_coupon cc
LEFT JOIN (SELECT * FROM sys_coupon WHERE coupon_id IN(SELECT coupon_id
FROM sys_coupon_company WHERE 1=1
<if test="companyId !=null and companyId !=''">
AND company_id=#{companyId}
</if>
)) sc
ON sc.coupon_id = cc.coupon_id
WHERE 1 = 1
<if test=" endDate != null and endDate != ''">
AND
sc.oper_datetime < #{endDate}
</if>
<if test=" startDate != null and startDate != ''">
AND
sc.oper_datetime > #{startDate}
</if>
<if test=" keyword != null and keyword != ''">
AND
(cc.receive_car_code like CONCAT('%',#{keyword},'%') )
</if>
</select>