From 62a447d89331aee1feae7724c7616aa1bb2cfe79 Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期三, 16 十月 2024 14:28:37 +0800 Subject: [PATCH] 将CMQ替换为rabbitmq --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java | 164 ++++++++++++++++++++++++++++++++++++------------------ 1 files changed, 110 insertions(+), 54 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..62e6178 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 @@ -5,9 +5,8 @@ import org.apache.ibatis.annotations.Param; -import com.yeshi.fanli.entity.admin.ReslutOrder; +import com.yeshi.fanli.dto.ChartTDO; import com.yeshi.fanli.entity.taobao.TaoBaoOrder; -import com.yeshi.fanli.vo.order.TaoBaoOrderVO; public interface TaoBaoOrderMapper { @@ -22,6 +21,11 @@ // 閫氳繃璁㈠崟鍙疯幏鍙栬鍗曞垪琛� List<TaoBaoOrder> selectTaoBaoOrderByOrderId(String orderId); + // 閫氳繃浜ゆ槗ID鑾峰彇璁㈠崟 + TaoBaoOrder selectTaoBaoOrderByTradeId(String tradeId); + + List<TaoBaoOrder> listByTradeId(String tradeId); + int updateByPrimaryKeySelective(TaoBaoOrder record); int updateByPrimaryKey(TaoBaoOrder record); @@ -29,62 +33,114 @@ // 鏍规嵁璁㈠崟鍙峰垹闄ゆ暟鎹� 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<ChartTDO> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year, + @Param("startTime") String startTime, @Param("endTime") String endTime); + + + /** + * 缁熻--璁㈠崟绫诲瀷鍖哄垎 + * + * @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(String auctionId); + + /** + * 缁熻鎵�鏈夎鍗� + * + * @param channel + * @return + */ + Long countOrderByDay(@Param("preDay") String preDay); - 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); - + /** + * 鑾峰彇闀挎湡鏈洿鏂扮殑璁㈠崟 + * + * @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