<select id="getSmsRecords" resultType="com.muxu.cashier.transmission.sms.entity.SmsRecord">
select id,store_front,phone,sms_title,sms_content,biz_id,send_time,status,cost from sms_record
<where>
<if test="keyword != null and keyword != ''">
and (sms_title like concat('%',#{keyword},'%') or sms_content like concat('%',#{keyword},'%') or phone
like concat('%',#{keyword},'%'))
</if>
<if test="startDate != null and endDate != null">
and send_time between #{startDate} and #{endDate}
</if>
<if test="storeFront != null and storeFront != ''">
and store_front = #{storeFront}
</if>
<if test="status != null">
and status = #{status}
</if>
</where>
</select>