| | |
| | | and (b.goods_name like CONCAT('%', CONCAT(#{record.query}, '%')) or b.style_name like CONCAT('%', CONCAT(#{record.query}, '%')) or b.sku_name like CONCAT('%', CONCAT(#{record.query}, '%'))) |
| | | </if> |
| | | <if test="record.status == 6 and record.status != 0"> |
| | | and a.status = 4 and a.comment_state != 2 |
| | | and a.status = 4 and a.comment_state = 2 |
| | | </if> |
| | | <if test="record.status == 4 and record.status != 0"> |
| | | and a.status = 4 |
| | | and a.status = 4 and a.comment_state != 2 |
| | | </if> |
| | | <if test="record.status != 4 and record.status != 0 and record.status != 5"> |
| | | and a.status = #{record.status} |