package com.yeshi.fanli.dao.mybatis.order;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.dao.BaseMapper;
|
import com.yeshi.fanli.entity.order.CommonOrder;
|
import com.yeshi.fanli.vo.order.CommonOrderVO;
|
|
public interface CommonOrderMapper extends BaseMapper<CommonOrder> {
|
|
/**
|
* 查询用户订单 并订单号分组
|
*
|
* @param start
|
* @param count
|
* @param uid
|
* @return
|
*/
|
|
List<CommonOrderVO> listUserOrder(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
|
@Param("state") Integer state, @Param("type") Integer type, @Param("orderState") Integer orderState,
|
@Param("orderNo") String orderNo, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("day") Integer day);
|
|
/**
|
* 统计用户订单 并订单号分组
|
*
|
* @param start
|
* @param count
|
* @param uid
|
* @return
|
*/
|
long countUserOrder(@Param("uid") Long uid, @Param("state") Integer state, @Param("type") Integer type,
|
@Param("orderState") Integer orderState, @Param("orderNo") String orderNo,
|
@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day);
|
|
/**
|
* 判断部分失效状态
|
*
|
* @param uid
|
* @param orderNo
|
* @return
|
*/
|
CommonOrderVO getBuFenOrderState(@Param("uid") Long uid, @Param("orderNo") String orderNo);
|
|
/**
|
* 根据用户ID，订单状态和订单结算时间统计订单的数量
|
*
|
* @param uid
|
* @param state
|
* @param minDate
|
* @param maxDate
|
* @return
|
*/
|
long countByUidAndOrderStateWithOrderBalanceTime(@Param("uid") Long uid, @Param("state") int state,
|
@Param("minDate") Date minDate, @Param("maxDate") Date maxDate);
|
|
/**
|
* 根据订单号、订单类型查询商品
|
*
|
* @param list
|
* 订单对象
|
* @return
|
*/
|
List<CommonOrderVO> listOrderGoodsInfo(List<CommonOrderVO> list);
|
|
/**
|
* 统计历史订单数量
|
*
|
* @param uid
|
* @return
|
*/
|
Map<String, BigDecimal> countHistoryOrder(@Param("uid") Long uid, @Param("day") Integer day);
|
|
/**
|
* 昨日总订单-根据红包类型 自购 邀请 分享
|
*
|
* @param uid
|
* @return
|
*/
|
Map<String, BigDecimal> countByUidAndOrderState(@Param("uid") Long uid, @Param("type") Integer type,
|
@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day);
|
|
/**
|
* 奖金订单数量
|
*
|
* @param uid
|
* @return
|
*/
|
long countBonusOrderNumber(@Param("uid") Long uid, @Param("type") Integer type, @Param("day") Integer day,
|
@Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
/**
|
* 奖金统计
|
*
|
* @param uid
|
* @return
|
*/
|
BigDecimal countBonusOrderMoney(@Param("uid") Long uid, @Param("type") Integer type, @Param("day") Integer day,
|
@Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
/**
|
* 奖金统计
|
*
|
* @param uid
|
* @return
|
*/
|
Map<String, Object> countBonusOrderMoneyAndNumber(@Param("uid") Long uid, @Param("type") Integer type,
|
@Param("day") Integer day, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
|
int countByOrderNOAndOrderType(@Param("orderNO") String orderNO, @Param("orderType") int orderType);
|
|
/**
|
* 根据订单号与订单排序值获取详情
|
*
|
* @param orderNo
|
* -订单号
|
* @param orderBy
|
* -订单排序值
|
* @param orderType
|
* -订单类型
|
* @return
|
*/
|
CommonOrder selectByOrderNoAndOrderTypeAndOrderBy(@Param("orderNo") String orderNo,
|
@Param("orderType") int orderType, @Param("orderBy") int orderBy);
|
|
/**
|
* 订单列表查询
|
*
|
* @param start
|
* @param count
|
* @param uid
|
* @param state
|
* @param type
|
* @param orderState
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
List<CommonOrderVO> listQueryByUid(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid,
|
@Param("state") Integer state, @Param("type") Integer type, @Param("orderState") Integer orderState,
|
@Param("orderNo") String orderNo, @Param("startTime") String startTime, @Param("endTime") String endTime,
|
@Param("day") Integer day);
|
|
/**
|
* 统计
|
*/
|
long countQueryByUid(@Param("uid") Long uid, @Param("state") Integer state, @Param("type") Integer type,
|
@Param("orderState") Integer orderState, @Param("orderNo") String orderNo,
|
@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day);
|
|
/**
|
* 订单列表查询
|
*
|
* @param start
|
* @param count
|
* @param uid
|
* @param state
|
* @param type
|
* @param orderState
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
List<CommonOrderVO> listQuery(@Param("start") long start, @Param("count") int count,
|
@Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state,
|
@Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime,
|
@Param("endTime") String endTime);
|
|
/**
|
* 统计
|
*/
|
long countQuery(@Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state,
|
@Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime,
|
@Param("endTime") String endTime);
|
|
/**
|
* 根据来源类型与订单号查询列表
|
*
|
* @param sourceType
|
* @param orderNo
|
* @return
|
*/
|
List<CommonOrder> listBySourceTypeAndOrderNo(@Param("sourceType") int sourceType, @Param("orderNo") String orderNo);
|
|
/**
|
* 查询券奖励金额以及订单信息
|
*
|
* @param uid
|
* @param state
|
* @param orderNo
|
* @return
|
*/
|
List<CommonOrderVO> getCouponHongbaoByOrderNo(@Param("uid") Long uid, @Param("hongBaoState") Integer hongBaoState,
|
@Param("orderNo") String orderNo);
|
|
/**
|
* 查询券奖励金额以及订单信息
|
*
|
* @param uid
|
* @param state
|
* @param orderNo
|
* @return
|
*/
|
CommonOrderVO getCommonOrderByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo,
|
@Param("orderState") Integer orderState);
|
|
/**
|
* 根据来源和交易ID获取订单详情
|
* @param sourceType
|
* @param tradeId
|
* @return
|
*/
|
|
CommonOrder selectBySourceTypeAndTradeId(@Param("sourceType") int sourceType, @Param("tradeId") String tradeId);
|
|
}
|
