From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 18 一月 2020 12:06:27 +0800 Subject: [PATCH] 用户注册信息 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java | 224 +++++++++++++++++++++++++++++++++---------------------- 1 files changed, 135 insertions(+), 89 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java index f06dc8b..5264145 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java @@ -1,90 +1,136 @@ -package com.yeshi.fanli.dao.mybatis.taobao; - -import java.util.List; -import java.util.Map; - -import org.apache.ibatis.annotations.Param; - -import com.yeshi.fanli.entity.admin.ReslutOrder; -import com.yeshi.fanli.entity.taobao.TaoBaoOrder; -import com.yeshi.fanli.vo.order.TaoBaoOrderVO; - -public interface TaoBaoOrderMapper { - - int deleteByPrimaryKey(Long id); - - int insert(TaoBaoOrder record); - - int insertSelective(TaoBaoOrder record); - - TaoBaoOrder selectByPrimaryKey(Long id); - - // 閫氳繃璁㈠崟鍙疯幏鍙栬鍗曞垪琛� - List<TaoBaoOrder> selectTaoBaoOrderByOrderId(String orderId); - - int updateByPrimaryKeySelective(TaoBaoOrder record); - - int updateByPrimaryKey(TaoBaoOrder record); - - // 鏍规嵁璁㈠崟鍙峰垹闄ゆ暟鎹� - int deleteByOrderId(String orderId); - - - List<ReslutOrder> queryJoinHongBao(@Param("start") int start, @Param("count") int count, @Param("key") String key, - @Param("startTime") String startTime, @Param("endTime") String endTime, - @Param("type")Integer type,@Param("days") Integer days); - - int countQueryJoinHongBao( @Param("key") String key,@Param("startTime") String startTime, - @Param("endTime") String endTime, @Param("type")Integer type,@Param("days") Integer days); - - /** - * 缁熻--璁㈠崟绫诲瀷鍖哄垎 - * @return - */ - Map<String, Object> countByOdrerType(); - - - /** - * 缁熻浠婃棩璁㈠崟 - * @return - */ - int countToday(); - - /** - * 缁熻鏄ㄦ棩璁㈠崟 - * @return - */ - int countYesterday(); - - - /** - * 缁熻褰撴棩棰勪及鏀剁泭 - * @param date 2018-09-01 - * @return - */ - double countEstimate(@Param("date")String date); - - - - List<TaoBaoOrder> getStateByOrderIdAndPayment(@Param("orderId")String orderId, @Param("payment")String payment); - - - TaoBaoOrder selectLatestByAuctionId(long auctionId); - - - /** - * 缁熻鎵�鏈夎鍗� - * @param channel - * @return - */ - List<Map<String, Object>> countOrderNumber( @Param("dateType") Integer dateType, @Param("year") String year, - @Param("startTime")String startTime, @Param("endTime")String endTime); - - - List<TaoBaoOrderVO> listQuery(@Param("start")long start, @Param("count") int count, @Param("key") String key, - @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("state")Integer state); - - long countQuery(@Param("key") String key, @Param("startTime") String startTime,@Param("endTime") String endTime, - @Param("state")Integer state); - +package com.yeshi.fanli.dao.mybatis.taobao; + +import java.util.List; +import java.util.Map; + +import org.apache.ibatis.annotations.Param; + +import com.yeshi.fanli.dto.ChartTDO; +import com.yeshi.fanli.entity.taobao.TaoBaoOrder; + +public interface TaoBaoOrderMapper { + + int deleteByPrimaryKey(Long id); + + int insert(TaoBaoOrder record); + + int insertSelective(TaoBaoOrder record); + + TaoBaoOrder selectByPrimaryKey(Long id); + + // 閫氳繃璁㈠崟鍙疯幏鍙栬鍗曞垪琛� + List<TaoBaoOrder> selectTaoBaoOrderByOrderId(String orderId); + + // 閫氳繃浜ゆ槗ID鑾峰彇璁㈠崟 + TaoBaoOrder selectTaoBaoOrderByTradeId(String tradeId); + + List<TaoBaoOrder> listByTradeId(String tradeId); + + int updateByPrimaryKeySelective(TaoBaoOrder record); + + int updateByPrimaryKey(TaoBaoOrder record); + + // 鏍规嵁璁㈠崟鍙峰垹闄ゆ暟鎹� + int deleteByOrderId(String orderId); + + /** + * 缁熻--璁㈠崟绫诲瀷鍖哄垎 + * + * @return + */ + Map<String, Object> countByOdrerType(); + + /** + * 缁熻浠婃棩璁㈠崟 + * + * @return + */ + int countToday(); + + /** + * 缁熻鏄ㄦ棩璁㈠崟 + * + * @return + */ + int countYesterday(); + + /** + * 缁熻褰撴棩棰勪及鏀剁泭 + * + * @param date + * 2018-09-01 + * @return + */ + double countEstimate(@Param("date") String date); + + List<TaoBaoOrder> getStateByOrderIdAndPayment(@Param("orderId") String orderId, @Param("payment") String payment); + + TaoBaoOrder selectLatestByAuctionId(long auctionId); + + /** + * 缁熻鎵�鏈夎鍗� + * + * @param channel + * @return + */ + Long countOrderByDay(@Param("preDay") String preDay); + + + /** + * 鑾峰彇闀挎湡鏈洿鏂扮殑璁㈠崟 + * + * @param start + * @param count + * @return + */ + List<TaoBaoOrder> listLongTimeNoUpdateOrders(@Param("start") long start, @Param("count") int count); + + /** + * 鑾峰彇鎵�鏈夎鍗曞垪琛� + * + * @param orderNo + * @param start + * @param count + * @return + */ + List<TaoBaoOrder> listAllOrder(@Param("orderNo") String orderNo, @Param("start") long start, + @Param("count") int count); + + /** + * 鎵�鏈夎鍗曟暟閲� + * + * @param orderNo + * @return + */ + long countAllOrder(@Param("orderNo") String orderNo); + + /** + * 鏍规嵁缁撶畻鏃堕棿鎷兼帓搴� + * + * @param start + * @param count + * @return + */ + List<TaoBaoOrder> listBySettlementTime(@Param("minTime") Long minTime, @Param("maxTime") Long maxTime, + @Param("start") long start, @Param("count") int count); + + /** + * 鏍规嵁缁撶畻鏃堕棿璁℃暟 + * + * @param minTime + * @param maxTime + * @return + */ + Long countBySettlementTime(@Param("minTime") Long minTime, @Param("maxTime") Long maxTime); + + /** + * 鏍规嵁鐘舵�佷笌鍒涘缓鏃堕棿妫�绱� + * + * @param state + * @param minCreateTime + * @param maxCreateTime + * @return + */ + List<TaoBaoOrder> listByStateAndCreateTime(@Param("state") String state, @Param("minCreateTime") Long minCreateTime, + @Param("maxCreateTime") Long maxCreateTime); } \ No newline at end of file -- Gitblit v1.8.0