package cc.mrbird.febs.mall.mapper;
|
|
import cc.mrbird.febs.common.enumerates.OrderPayMethodEnum;
|
import cc.mrbird.febs.mall.dto.MallOrderInfoDto;
|
import cc.mrbird.febs.mall.dto.OrderListDto;
|
import cc.mrbird.febs.mall.entity.MallOrderInfo;
|
import cc.mrbird.febs.mall.entity.MallOrderItem;
|
import cc.mrbird.febs.mall.vo.AdminGoodsStatisticsVo;
|
import cc.mrbird.febs.mall.vo.AdminMallOrderInfoVo;
|
import cc.mrbird.febs.mall.vo.AdminMallOrderVo;
|
import cc.mrbird.febs.mall.vo.AdminOrderDetailVo;
|
import cn.hutool.core.date.DateTime;
|
import com.baomidou.mybatisplus.annotation.SqlParser;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author wzy
|
* @date 2021-09-18
|
**/
|
public interface MallOrderInfoMapper extends BaseMapper<MallOrderInfo> {
|
|
IPage<MallOrderInfo> selectInPage(@Param("record") MallOrderInfo mallOrderInfo, IPage<MallOrderInfo> page);
|
|
MallOrderInfo selectOrderByMemberIdAndId(@Param("memberId") Long memberId, @Param("id") Long id);
|
|
IPage<AdminMallOrderInfoVo> selectOrderListInPage(Page<AdminMallOrderInfoVo> page, @Param("record") MallOrderInfoDto mallOrderInfo);
|
|
AdminMallOrderVo getMallOrderInfoById(@Param("id")long id);
|
|
IPage<MallOrderInfo> selectApiOrderListInPage(IPage<MallOrderInfo> page,@Param("record") OrderListDto orderListDto);
|
|
MallOrderInfo selectOrderDetailsById(@Param("id") Long id);
|
|
List<Map<String, Integer>> selectMemberOrderStatusCnt(@Param("memberId") Long memberId);
|
|
AdminOrderDetailVo getMallOrderDetailById(@Param("id")long id);
|
|
List<MallOrderItem> getMallOrderItemByOrderId(@Param("id")long id);
|
|
List<MallOrderInfo> selectOrderInfoByStatus(@Param("status") Integer status);
|
|
List<MallOrderInfo> selectOrderInfoByStatusAndIsInvoice(@Param("status") Integer status,@Param("isInvoice") Integer isInvoice);
|
|
List<MallOrderInfo> selectOrderInfoUpTime(@Param("status") Integer status);
|
|
Integer selectCntDirectOrTeam(@Param("type") Integer type, @Param("inviteId") String inviteId);
|
|
Integer selectCntDirect(@Param("inviteId") String inviteId);
|
|
BigDecimal selectTotalAmount(@Param("memberId") Long memberId);
|
|
BigDecimal selectTotalAmountForDate(@Param("date") Date date, @Param("member") Long memberId);
|
|
BigDecimal selectTotalAmountUnCostForDate(@Param("date") Date date, @Param("member") Long memberId, @Param("dateType") String dateType, @Param("isNormal") Integer isNormal);
|
|
MallOrderInfo selectByOrderNo(@Param("orderNo") String orderNo);
|
|
int updateOrderConfirmStatus(@Param("updateTime")DateTime updateTime,@Param("date") Date date);
|
|
List<MallOrderInfo> selectOrderInfoWithNormalGoods(@Param("date") Date date);
|
|
BigDecimal selectSumAmountByPayMethodAndStatue(@Param("payMethod")String name, @Param("statue")int value);
|
|
void updateOrderStateAndDeliveryState(@Param("orderId")Long orderId, @Param("orderState")int orderState, @Param("deliveryState")int deliveryState);
|
|
List<Map<String, Integer>> selectMemberOrderStatusCntByUniquecode(@Param("uniqueCode")String uniqueCode);
|
|
List<MallOrderInfo> selectOrderByStatusAndPayTime(@Param("status")Integer i, @Param("paytime")DateTime offsetDay);
|
|
IPage<MallOrderInfo> selectNewApiOrderListInPage(IPage<MallOrderInfo> page, @Param("record") OrderListDto orderListDto);
|
|
MallOrderInfo selectByIdAndTakeUniqueCode(@Param("orderId")long orderId,@Param("takeUniqueCode") String takeUniqueCode);
|
|
MallOrderInfo selectAllOrderInfoByIdAndTakeUniqueCode(@Param("orderId")long orderId,@Param("takeUniqueCode") String takeUniqueCode);
|
|
@SqlParser(filter = true)
|
IPage<AdminGoodsStatisticsVo> getGoodsStatisticsInPage(Page<AdminGoodsStatisticsVo> page, @Param("record") MallOrderItem mallOrderItem);
|
|
BigDecimal selectAmountOrTeamAmount(@Param("inviteId") String inviteId, @Param("type") Integer type);
|
|
MallOrderInfo selectBypayOrderNo(@Param("payOrderNo")String payOrderNo);
|
}
|
