| | |
| | | from merchant m |
| | | where m.deleted = 0 |
| | | <if test="merchantId != null">and m.id = #{merchantId}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type = #{merchantType}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type_code = #{merchantType}</if> |
| | | <if test="status != null">and m.status = #{status}</if> |
| | | <if test="keyword != null and keyword != ''"> |
| | | and (m.merchant_name like concat('%', #{keyword}, '%') |
| | |
| | | from merchant m |
| | | where m.deleted = 0 |
| | | <if test="merchantId != null">and m.id = #{merchantId}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type = #{merchantType}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type_code = #{merchantType}</if> |
| | | <if test="status != null">and m.status = #{status}</if> |
| | | <if test="keyword != null and keyword != ''"> |
| | | and (m.merchant_name like concat('%', #{keyword}, '%') |
| | |
| | | ) |
| | | where m.deleted = 0 |
| | | and m.status = 1 |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type = #{merchantType}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type_code = #{merchantType}</if> |
| | | <if test="keyword != null and keyword != ''"> |
| | | and (m.merchant_name like concat('%', #{keyword}, '%') |
| | | or m.contact_mobile like concat('%', #{keyword}, '%') |
| | |
| | | from merchant m |
| | | where m.deleted = 0 |
| | | and m.status = 1 |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type = #{merchantType}</if> |
| | | <if test="merchantType != null and merchantType != ''">and m.merchant_type_code = #{merchantType}</if> |
| | | <if test="keyword != null and keyword != ''"> |
| | | and (m.merchant_name like concat('%', #{keyword}, '%') |
| | | or m.contact_mobile like concat('%', #{keyword}, '%') |