fanli-server.git

			@@ -1,6 +1,7 @@
			package com.yeshi.fanli.dao.mybatis.order;

			import java.math.BigDecimal;
			import java.util.Date;
			import java.util.List;
			import java.util.Map;

			@@ -11,65 +12,180 @@
			import com.yeshi.fanli.vo.order.CommonOrderVO;

			public interface CommonOrderMapper extends BaseMapper<CommonOrder> {


			/**
			* 查询用户订单并订单号分组
			*
			* @param start
			* @param count
			* @param uid
			* @return
			*/
			List<CommonOrderVO> listGroupOrderNoByUid(@Param("start") long start, @Param("count") int count,
			@Param("uid") Long uid,@Param("state") Integer state, @Param("type") Integer type,
			@Param("orderNo")String orderNo, @Param("startTime")String startTime, @Param("endTime")String endTime);



			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 countGroupOrderNoByUid(@Param("uid") Long uid, @Param("state") Integer state,
			@Param("type") Integer type, @Param("orderNo")String orderNo,
			@Param("startTime")String startTime, @Param("endTime")String endTime);
			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 订单对象
			*
			* @param list
			* 订单对象
			* @return
			*/
			List<CommonOrderVO> listByOrderNoAndType(List<CommonOrderVO> list);

			List<CommonOrderVO> listOrderGoodsInfo(List<CommonOrderVO> list);

			/**
			* 统计订单-根据红包类型自购邀请分享
			* 统计历史订单数量
			*
			* @param uid
			* @return
			*/
			Map<String, BigDecimal> countOrderByHongBaoType(@Param("uid") Long uid, @Param("day") Integer day);


			/**
			* 总订单
			* @param uid
			* @return
			*/
			long countOrder(@Param("uid")Long uid, @Param("isToday")Integer isToday);

			/**
			* 总订单
			* @param uid
			* @return
			*/
			BigDecimal countOrderMoney(@Param("uid")Long uid, @Param("isToday")Integer isToday);


			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("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);


			}