| | |
|---|
| | | AND toc.shop_id = #{param.shopId} AND (toc.unbinding_flag = 0 OR (toc.unbinding_flag = 1 AND toc.order_from = 1) OR (toc.unbinding_flag = 1 AND toc.order_from = 2 AND toc.order_status = 3)) |
|---|
| | | </if> |
|---|
| | | <if test="param.shopIds != null and param.shopIds != ''"> |
|---|
| | | and toc.order_status = 3 AND FIND_IN_SET(toc.shop_id, #{param.shopIds}) > 0 |
|---|
| | | AND FIND_IN_SET(toc.shop_id, #{param.shopIds}) > 0 |
|---|
| | | </if> |
|---|
| | | <if test="param.keyword != null and param.keyword != ''"> |
|---|
| | | AND (toc.order_no LIKE CONCAT('%',#{param.keyword},'%') OR toc.activity_name LIKE CONCAT('%',#{param.keyword},'%') OR FIND_IN_SET(toc.user_id, #{param.userIds}) > 0) |
|---|
