| | |
| | | left join mall_member b on a.member_id = b.id |
| | | left join mall_member_payment c on a.member_id = c.member_id |
| | | where a.buy_id = #{productBuyId} |
| | | and a.state != 0 |
| | | </select> |
| | | |
| | | <select id="selectListByBuyId" resultType="cc.mrbird.febs.mall.entity.MallProductBuyRecord"> |
| | |
| | | left join mall_member b on a.member_id = b.id |
| | | left join mall_member_payment c on a.member_id = c.member_id |
| | | where a.sell_id = #{productSellId} |
| | | and a.state != 0 |
| | | </select> |
| | | |
| | | <select id="selectListBySellId" resultType="cc.mrbird.febs.mall.entity.MallProductSellRecord"> |