| | |
| | | <if test="record.query != null and record.query != ''"> |
| | | 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 == 4"> |
| | | <if test="record.status == 4 and record.status != 0"> |
| | | and a.status in (5,6) |
| | | </if> |
| | | <if test="record.status != 4"> |
| | | <if test="record.status != 4 and record.status != 0"> |
| | | and a.status = #{record.status} |
| | | </if> |
| | | </where> |
| | |
| | | b.amount |
| | | from mall_order_info a |
| | | inner join mall_order_item b on a.id=b.order_id |
| | | where id=#{id} |
| | | where a.id=#{id} |
| | | </select> |
| | | |
| | | <select id="selectMemberOrderStatusCnt" resultType="java.util.Map"> |