| | |
| | | "o.logistics_time AS logistics_time," + |
| | | "o.complete_time AS complete_time," + |
| | | "o.store_name AS store_name, " + |
| | | "m.nick_name AS nickName" + |
| | | "m.nick_name AS nickName," + |
| | | "o.member_id AS memberId" + |
| | | " FROM li_order o LEFT JOIN li_order_item oi ON oi.order_sn = o.sn " + |
| | | "LEFT JOIN li_member m on m.id = o.member_id " + |
| | | "${ew.customSqlSegment}") |
| | |
| | | "o.consignee_mobile AS consigneeMobile," + |
| | | "o.member_id AS memberId," + |
| | | "m.nick_name AS nickName," + |
| | | "o.modify_address_flag AS modifyAddressFlag,"+ |
| | | " 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" + |
| | |
| | | "o.consignee_name AS consigneeName," + |
| | | "o.consignee_mobile AS consigneeMobile," + |
| | | "o.member_id AS memberId," + |
| | | "o.modify_address_flag AS modifyAddressFlag,"+ |
| | | " 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" + |
| | |
| | | * @param queryWrapper 查询条件 |
| | | * @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 " + |
| | | @Select("select o.id,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,o.coupon_flag " + |
| | | ",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" + |