| | |
|---|
| | | "store_name,o.store_id as store_id,o.client_type,o.order_type,o.deliver_status,o.order_promotion_type,o.seller_remark, " + |
|---|
| | | "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.goods_price) as group_goods_price " + |
|---|
| | | ",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 ${ew.customSqlSegment} ") |
|---|
| | | " 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); |
|---|
| | | /** |
|---|
| | | * 查询订单简短信息分页 |
|---|
