From 0c78c7aaeaa5a427bc8a5c5faf3cd6bbb589c2da Mon Sep 17 00:00:00 2001 From: yujian <yujian@123.com> Date: 星期二, 08 十月 2019 12:08:38 +0800 Subject: [PATCH] map 改造 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/taobao/TaoBaoOrderMapper.java | 269 +++++++++++++++++++++++++++-------------------------- 1 files changed, 135 insertions(+), 134 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 5720897..9cbb16f 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,135 +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.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 - */ - List<Map<String, Object>> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year, - @Param("startTime") String startTime, @Param("endTime") String endTime); - - /** - * 鑾峰彇闀挎湡鏈洿鏂扮殑璁㈠崟 - * - * @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); +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 + */ + List<ChartTDO> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year, + @Param("startTime") String startTime, @Param("endTime") String endTime); + + /** + * 鑾峰彇闀挎湡鏈洿鏂扮殑璁㈠崟 + * + * @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