| | |
|---|
| | | "o.consignee_name AS consigneeName," + |
|---|
| | | "o.consignee_mobile AS consigneeMobile," + |
|---|
| | | "o.member_id AS memberId," + |
|---|
| | | "m.nick_name AS nickName," + |
|---|
| | | " GROUP_CONCAT(oi.goods_id) as group_goods_id," + |
|---|
| | | " GROUP_CONCAT(oi.sku_id) as group_sku_id," + |
|---|
| | | " GROUP_CONCAT(oi.num) as group_num" + |
|---|
| | |
|---|
| | | ",GROUP_CONCAT(oi.is_refund) as group_is_refund " + |
|---|
| | | ",GROUP_CONCAT(oi.refund_price) as group_refund_price " + |
|---|
| | | " FROM li_order o LEFT JOIN li_order_item AS oi on o.sn = oi.order_sn " + |
|---|
| | | "LEFT JOIN li_member m on m.id = o.member_id " + |
|---|
| | | "${ew.customSqlSegment}") |
|---|
| | | |
|---|
| | | IPage<OrderSimpleVO> queryByParams(IPage<OrderSimpleVO> page, @Param(Constants.WRAPPER) Wrapper<OrderSimpleVO> queryWrapper); |
|---|
