| | |
|---|
| | | and (#{cardLevel} is null or #{cardLevel} = '' or r.card_level = #{cardLevel}) |
|---|
| | | and (#{enabled} is null or r.enabled = #{enabled}) |
|---|
| | | and (#{keyword} is null or #{keyword} = '' or m.merchant_name like concat('%', #{keyword}, '%') or m.address like concat('%', #{keyword}, '%')) |
|---|
| | | order by m.sort_no desc, m.id desc, |
|---|
| | | order by m.sort_no desc, m.created_at desc, m.id desc, |
|---|
| | | case r.card_level when '卓越人才卡' then 1 when '杰出人才卡' then 2 when '菁英人才卡' then 3 else 99 end |
|---|
| | | limit #{size} offset #{offset} |
|---|
| | | """) |
|---|
| | |
|---|
| | | and r.status = 1 |
|---|
| | | and r.card_level = #{cardLevel} |
|---|
| | | and (#{merchantId} is null or r.merchant_id = #{merchantId}) |
|---|
| | | order by m.sort_no desc, m.id desc |
|---|
| | | order by m.sort_no desc, m.created_at desc, m.id desc |
|---|
| | | """) |
|---|
| | | List<Map<String, Object>> selectAvailableForCard(@Param("cardLevel") String cardLevel, @Param("merchantId") Long merchantId); |
|---|
| | | } |
|---|
