| | |
|---|
| | | * @return 简短订单分页 |
|---|
| | | */ |
|---|
| | | @Select("select o.sn,o.flow_price,o.create_time,o.order_status,o.pay_status,o.payment_method,o.payment_time,o.member_name,o.store_name as " + |
|---|
| | | "store_name,o.store_id as store_id,o.client_type,o.order_type,o.deliver_status,o.order_promotion_type,o.seller_remark " + |
|---|
| | | ",GROUP_CONCAT(oi.goods_id) as group_goods_id," + |
|---|
| | | "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," + |
|---|
| | | " 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.image) as group_images" + |
|---|
| | |
|---|
| | | ",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 " + |
|---|
| | | "${ew.customSqlSegment}") |
|---|
| | | |
|---|
| | | IPage<OrderSimpleVO> queryByParams(IPage<OrderSimpleVO> page, @Param(Constants.WRAPPER) Wrapper<OrderSimpleVO> queryWrapper); |
|---|
| | | /** |
|---|
| | | * 查询订单简短信息分页 |
|---|
