From 30d8e227e8d823b6c38c3b9c90ac2df03b63befe Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期二, 25 二月 2025 16:41:22 +0800 Subject: [PATCH] 淘宝转链接口更新 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java | 804 ++++++++++++++++++++++++++++++--------------------------- 1 files changed, 423 insertions(+), 381 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java index ca7be40..c3008ad 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderMapper.java @@ -5,6 +5,8 @@ import java.util.List; import java.util.Map; +import com.ks.lijin.query.BaseDaoQuery; +import com.yeshi.fanli.entity.SystemEnum; import org.apache.ibatis.annotations.Param; import com.yeshi.fanli.dao.BaseMapper; @@ -15,418 +17,458 @@ 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("listSource") List<Integer> listSource); + /** + * 鏌ヨ鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 + * + * @param start + * @param count + * @param uid + * @return + */ - /** - * 缁熻鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 - * - * @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("listSource") List<Integer> listSource); + 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("listSource") List<Integer> listSource); - /** - * 鍒ゆ柇閮ㄥ垎澶辨晥鐘舵�� - * - * @param uid - * @param orderNo - * @return - */ - CommonOrderVO getBuFenOrderState(@Param("uid") Long uid, @Param("orderNo") String orderNo); + /** + * 缁熻鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 + * + * @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("listSource") List<Integer> listSource); - /** - * 鏍规嵁鐢ㄦ埛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 uid + * @param orderNo + * @return + */ + CommonOrderVO getBuFenOrderState(@Param("uid") Long uid, @Param("orderNo") String orderNo); - /** - * 鏍规嵁璁㈠崟鍙枫�佽鍗曠被鍨嬫煡璇㈠晢鍝� - * - * @param list - * 璁㈠崟瀵硅薄 - * @return - */ - List<CommonOrderVO> listOrderGoodsInfo(List<CommonOrderVO> list); + /** + * 鏍规嵁鐢ㄦ埛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 uid - * @return - */ - Map<String, BigDecimal> countHistoryOrder(@Param("uid") Long uid, @Param("day") Integer day, - @Param("source") Integer source); + /** + * 鏍规嵁璁㈠崟鍙枫�佽鍗曠被鍨嬫煡璇㈠晢鍝� + * + * @param list 璁㈠崟瀵硅薄 + * @return + */ + List<CommonOrderVO> listOrderGoodsInfo(List<CommonOrderVO> list); - - /** - * 缁熻鏈夋晥璁㈠崟鏁伴噺 - * @param uid - * @return - */ - OrderCountVO getOrderCount(@Param("uid") Long uid, @Param("day")Integer day, @Param("listSource") List<Integer> listSource); - - /** - * 鏄ㄦ棩鎬昏鍗�-鏍规嵁绾㈠寘绫诲瀷 鑷喘 閭�璇� 鍒嗕韩 - * - * @param uid - * @return - */ - long countUserOrderToApp(@Param("uid") Long uid, @Param("type") Integer type, - @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day, - @Param("source") Integer source,@Param("state") Integer state, @Param("stateOrder") Integer stateOrder); + /** + * 缁熻鍘嗗彶璁㈠崟鏁伴噺 + * + * @param uid + * @return + */ + Map<String, BigDecimal> countHistoryOrder(@Param("uid") Long uid, @Param("day") Integer day, + @Param("source") Integer source); - /** - * 濂栭噾璁㈠崟鏁伴噺 - * - * @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("source") Integer source); - /** - * 濂栭噾缁熻 - * - * @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("source") Integer source); + /** + * 缁熻鏈夋晥璁㈠崟鏁伴噺 + * + * @param uid + * @return + */ + OrderCountVO getOrderCount(@Param("uid") Long uid, @Param("day") Integer day, @Param("listSource") List<Integer> listSource); - /** - * 濂栭噾缁熻 - * - * @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, - @Param("source") Integer source); + /** + * 鏄ㄦ棩鎬昏鍗�-鏍规嵁绾㈠寘绫诲瀷 鑷喘 閭�璇� 鍒嗕韩 + * + * @param uid + * @return + */ + long countUserOrderToApp(@Param("uid") Long uid, @Param("type") Integer type, + @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day, + @Param("source") Integer source, @Param("state") Integer state, @Param("stateOrder") Integer stateOrder); - int countByOrderNOAndOrderType(@Param("orderNO") String orderNO, @Param("orderType") int orderType); + /** + * 濂栭噾璁㈠崟鏁伴噺 + * + * @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("source") Integer source); - /** - * 鏍规嵁璁㈠崟鍙蜂笌璁㈠崟鎺掑簭鍊艰幏鍙栬鎯� - * - * @param orderNo - * -璁㈠崟鍙� - * @param orderBy - * -璁㈠崟鎺掑簭鍊� - * @param orderType - * -璁㈠崟绫诲瀷 - * @return - */ - CommonOrder selectByOrderNoAndOrderTypeAndOrderBy(@Param("orderNo") String orderNo, - @Param("orderType") int orderType, @Param("orderBy") int orderBy); + /** + * 濂栭噾缁熻 + * + * @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("source") Integer source); - /** - * 璁㈠崟鍒楄〃鏌ヨ - * - * @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); + /** + * 濂栭噾缁熻 + * + * @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, + @Param("source") Integer source); - /** - * 缁熻 - */ - 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); + int countByOrderNOAndOrderType(@Param("orderNO") String orderNO, @Param("orderType") int orderType); - /** - * 璁㈠崟鍒楄〃鏌ヨ - * - * @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, @Param("source") Integer source, - @Param("listShopId")List<Long> listShopId, @Param("listGoodsId")List<Long> listGoodsId, - @Param("minTime")Date minTime, @Param("money")BigDecimal money, @Param("payment") BigDecimal payment); + /** + * 鏍规嵁璁㈠崟鍙蜂笌璁㈠崟鎺掑簭鍊艰幏鍙栬鎯� + * + * @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 keyType - * @param key - * @param state - * @param type - * @param orderState - * @param startTime - * @param endTime - * @param source - * @return - */ - List<CommonOrderVO> listQueryWithNoChild(@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, @Param("source") Integer source, @Param("payment") BigDecimal payment); + /** + * 璁㈠崟鍒楄〃鏌ヨ + * + * @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 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("source") Integer source, - @Param("listShopId")List<Long> listShopId, @Param("listGoodsId")List<Long> listGoodsId, - @Param("minTime")Date minTime, @Param("money")BigDecimal money,@Param("payment") BigDecimal payment); + /** + * 缁熻 + */ + 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); - long countQueryWithNoChild(@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("source") Integer source, @Param("payment") BigDecimal payment); + /** + * 璁㈠崟鍒楄〃鏌ヨ + * + * @param start + * @param count + * @param uid + * @param state + * @param typeList + * @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("typeList") List<Integer> typeList, @Param("orderState") Integer orderState, @Param("startTime") String startTime, + @Param("endTime") String endTime, @Param("source") Integer source, + @Param("listShopId") List<Long> listShopId, @Param("listGoodsId") List<Long> listGoodsId, + @Param("minTime") Date minTime, @Param("money") BigDecimal money, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); - /** - * 鏍规嵁鏉ユ簮绫诲瀷涓庤鍗曞彿鏌ヨ鍒楄〃 - * - * @param sourceType - * @param orderNo - * @return - */ - List<CommonOrder> listBySourceTypeAndOrderNo(@Param("sourceType") int sourceType, @Param("orderNo") String orderNo); + /** + * 璁㈠崟鍒楄〃鏌ヨ(涓嶅寘鍚瓙璁㈠崟) + * + * @param start + * @param count + * @param keyType + * @param key + * @param state + * @param type + * @param orderState + * @param startTime + * @param endTime + * @param source + * @return + */ + List<CommonOrderVO> listQueryWithNoChild(@Param("start") long start, @Param("count") int count, + @Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state, + @Param("typeList") List<Integer> typeList, @Param("orderState") Integer orderState, @Param("startTime") String startTime, + @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); - /** - * 鏌ヨ鍒稿鍔遍噾棰濅互鍙婅鍗曚俊鎭� - * - * @param uid - * @param state - * @param orderNo - * @return - */ - List<CommonOrderVO> getCouponHongbaoByOrderNo(@Param("uid") Long uid, @Param("hongBaoState") Integer hongBaoState, - @Param("orderNo") String orderNo); + /** + * 缁熻 + */ + long countQuery(@Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state, + @Param("typeList") List<Integer> typeList, @Param("orderState") Integer orderState, @Param("startTime") String startTime, + @Param("endTime") String endTime, @Param("source") Integer source, + @Param("listShopId") List<Long> listShopId, @Param("listGoodsId") List<Long> listGoodsId, + @Param("minTime") Date minTime, @Param("money") BigDecimal money, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); - /** - * 鏌ヨ鍒稿鍔遍噾棰濅互鍙婅鍗曚俊鎭� - * - * @param uid - * @param state - * @param orderNo - * @return - */ - CommonOrderVO getCommonOrderByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo, - @Param("orderState") Integer orderState, @Param("sourceType") Integer sourceType); + long countQueryWithNoChild(@Param("keyType") Integer keyType, @Param("key") String key, + @Param("state") Integer state, @Param("typeList") List<Integer> typeList, @Param("orderState") Integer orderState, + @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); - /** - * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟璇︽儏 - * - * @param sourceType - * @param tradeId - * @return - */ + /** + * 鏍规嵁鏉ユ簮绫诲瀷涓庤鍗曞彿鏌ヨ鍒楄〃 + * + * @param sourceType + * @param orderNo + * @return + */ + List<CommonOrder> listBySourceTypeAndOrderNo(@Param("sourceType") int sourceType, @Param("orderNo") String orderNo); - CommonOrder selectBySourceTypeAndTradeId(@Param("sourceType") int sourceType, @Param("tradeId") String tradeId); + /** + * 鏌ヨ鍒稿鍔遍噾棰濅互鍙婅鍗曚俊鎭� + * + * @param uid + * @param state + * @param orderNo + * @return + */ + List<CommonOrderVO> getCouponHongbaoByOrderNo(@Param("uid") Long uid, @Param("hongBaoState") Integer hongBaoState, + @Param("orderNo") String orderNo); - /** - * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟鍒楄〃 - * - * @param sourceType - * @param tradeId - * @return - */ - List<CommonOrder> listBySourceTypeAndTradeId(@Param("sourceType") int sourceType, @Param("tradeId") String tradeId); + /** + * 鏌ヨ鍒稿鍔遍噾棰濅互鍙婅鍗曚俊鎭� + * + * @param uid + * @param state + * @param orderNo + * @return + */ + CommonOrderVO getCommonOrderByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo, + @Param("orderState") Integer orderState, @Param("sourceType") Integer sourceType); - /** - * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟鍒楄〃 - * - * @param sourceType - * @param tradeIdList - * @return - */ - List<CommonOrder> listBySourceTypeAndTradeIdList(@Param("sourceType") int sourceType, - @Param("tradeIdList") List<String> tradeIdList); + /** + * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟璇︽儏 + * + * @param sourceType + * @param tradeId + * @return + */ - /** - * - * @param sourceType - * @param state - * @param minTime - * -鏈�澶у垱寤烘椂闂� - * @param maxTime - * -鏈�灏忓垱寤烘椂闂� - * @return - */ - List<CommonOrder> listBySourceTypeAndStateAndThirdCrateTime(@Param("sourceType") int sourceType, - @Param("state") Integer state, @Param("minTime") Long minTime, @Param("maxTime") Long maxTime, - @Param("start") long start, @Param("count") int count); + CommonOrder selectBySourceTypeAndTradeId(@Param("sourceType") int sourceType, @Param("tradeId") String tradeId); - /** - * 鏍规嵁璁㈠崟鍙锋煡璇� - * - * @param orderNO - * @return - */ - List<CommonOrder> getByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo); + /** + * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟鍒楄〃 + * + * @param sourceType + * @param tradeId + * @return + */ + List<CommonOrder> listBySourceTypeAndTradeId(@Param("sourceType") int sourceType, @Param("tradeId") String tradeId); - - /** - * 鏍规嵁鐢ㄦ埛ID鏌ヨ - * @param uid - * @param stateList - * @param start - * @param count - * @return - */ - List<CommonOrder> listByUid(@Param("uid")Long uid,@Param("stateList") List<Integer> stateList,@Param("start") long start,@Param("count") int count); + /** + * 鏍规嵁鏉ユ簮鍜屼氦鏄揑D鑾峰彇璁㈠崟鍒楄〃 + * + * @param sourceType + * @param tradeIdList + * @return + */ + List<CommonOrder> listBySourceTypeAndTradeIdList(@Param("sourceType") int sourceType, + @Param("tradeIdList") List<String> tradeIdList); - - /** - * 鏌ヨ棣栫瑪鏈夋晥鍒拌处璁㈠崟 - * @param uid - * @param typeHB 绫诲瀷锛� 1鑷喘 2鍒嗕韩 3閭�璇� - * @param typeDate 鏃ユ湡绫诲瀷锛� 3鏈湀 4涓婃湀 - * @return - */ - CommonOrderVO firstValidOrderByUid(@Param("uid") Long uid, @Param("typeHB") Integer typeHB, - @Param("typeDate") Integer typeDate); - - - /** - * 鑾峰彇棣栫瑪鍒嗕韩璁㈠崟锛� - * @param uid - * @return - */ - CommonOrder getFirstShareOrderByUid(@Param("uid") Long uid); - - /** - * 缁熻璁㈠崟鍙峰埌璐﹂噾棰� - * @param uid - * @return - */ - BigDecimal getTotalRewardMoneyByOrderNoAndSourceType(@Param("orderNo") String orderNo, @Param("sourceType") Integer sourceType); - - /** - * 缁熻24灏忔椂鏈夋晥鑷喘璁㈠崟 - * @param uid - * @return - */ - long count24HValidOrderByUid(@Param("uid") Long uid, @Param("minTime") Date minTime); - - - /** - * 鎼滅储璁㈠崟 - * @param start - * @param count - * @param uid - * @param list - * @return - */ - List<CommonOrderVO> searchOrderByUid(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid, - @Param("list")List<ESOrder> list); + /** + * @param sourceType + * @param state + * @param minTime -鏈�澶у垱寤烘椂闂� + * @param maxTime -鏈�灏忓垱寤烘椂闂� + * @return + */ + List<CommonOrder> listBySourceTypeAndStateAndThirdCrateTime(@Param("sourceType") int sourceType, + @Param("state") Integer state, @Param("minTime") Long minTime, @Param("maxTime") Long maxTime, + @Param("start") long start, @Param("count") int count); - - /** - * 鎼滅储璁㈠崟 - * @param start - * @param count - * @param uid - * @param list - * @return - */ - long countSearchOrderByUid(@Param("uid") Long uid, @Param("list")List<ESOrder> list); - - - - /** - * 鏌ヨ鏈�灏忕粨绠楁椂闂� - * @return - */ - List<CommonOrder> getMinSettleTimeAndUid(); - - - - - /** - * 鏌ヨ鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 - * - * @param start - * @param count - * @param uid - * @return - */ + /** + * 鏍规嵁璁㈠崟鍙锋煡璇� + * + * @param orderNO + * @return + */ + List<CommonOrder> getByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo); - List<CommonOrderVO> getOrderList(@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("listSource") List<Integer> listSource, @Param("notBackSuVip") boolean notBackSuVip); + /** + * 鏍规嵁璁㈠崟鍙锋煡璇� + * + * @param orderNO + * @return + */ + List<CommonOrder> getByOrderNoAndSourceType(@Param("uid") Long uid, @Param("orderNo") String orderNo, + @Param("sourceType") int sourceType); - /** - * 缁熻鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 - * - * @param start - * @param count - * @param uid - * @return - */ - long countOrderList(@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("listSource") List<Integer> listSource, @Param("notBackSuVip") boolean notBackSuVip); - - /** - * 缁熻宸茬粨绠椾笖浠樻閲戦澶т簬1鐨勮鍗曪紙涓嶅尯鍒嗚鍗曠姸鎬侊級 - * @param uid - * @param payment - * @return - */ - Long countOrderByUidAndSettled(@Param("uid") Long uid, @Param("payment") BigDecimal payment); - - /** - * 鑾峰彇鏈�鏂扮殑娣樺疂璁㈠崟鍙� - * @return - */ - String getNewestOrderNoByTaoBao(); - - /** - * 鏍规嵁璁㈠崟鍙疯繘琛宻ous - * @param orderNo - * @return - */ - List<CommonOrder> listByOrderNo(@Param("orderNo") String orderNo); + /** + * 鏍规嵁鐢ㄦ埛ID鏌ヨ + * + * @param uid + * @param stateList + * @param start + * @param count + * @return + */ + List<CommonOrder> listByUid(@Param("uid") Long uid, @Param("stateList") List<Integer> stateList, @Param("start") long start, @Param("count") int count); + + + /** + * 鏌ヨ棣栫瑪鏈夋晥鍒拌处璁㈠崟 + * + * @param uid + * @param typeHB 绫诲瀷锛� 1鑷喘 2鍒嗕韩 3閭�璇� + * @param typeDate 鏃ユ湡绫诲瀷锛� 3鏈湀 4涓婃湀 + * @return + */ + CommonOrderVO firstValidOrderByUid(@Param("uid") Long uid, @Param("typeHB") Integer typeHB, + @Param("typeDate") Integer typeDate); + + + /** + * 鑾峰彇棣栫瑪鍒嗕韩璁㈠崟锛� + * + * @param uid + * @return + */ + CommonOrder getFirstShareOrderByUid(@Param("uid") Long uid); + + /** + * 缁熻璁㈠崟鍙峰埌璐﹂噾棰� + * + * @param uid + * @return + */ + BigDecimal getTotalRewardMoneyByOrderNoAndSourceType(@Param("orderNo") String orderNo, @Param("sourceType") Integer sourceType); + + /** + * 缁熻24灏忔椂鏈夋晥鑷喘璁㈠崟 + * + * @param uid + * @return + */ + long count24HValidOrderByUid(@Param("uid") Long uid, @Param("minTime") Date minTime); + + + /** + * 鎼滅储璁㈠崟 + * + * @param start + * @param count + * @param uid + * @param list + * @return + */ + List<CommonOrderVO> searchOrderByUid(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid, + @Param("list") List<ESOrder> list); + + + /** + * 鎼滅储璁㈠崟 + * + * @param start + * @param count + * @param uid + * @param list + * @return + */ + long countSearchOrderByUid(@Param("uid") Long uid, @Param("list") List<ESOrder> list); + + + /** + * 鏌ヨ鏈�灏忕粨绠楁椂闂� + * + * @return + */ + List<CommonOrder> getMinSettleTimeAndUid(); + + + /** + * 鏌ヨ鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 + * + * @param start + * @param count + * @param uid + * @return + */ + + List<CommonOrderVO> getOrderList(@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("listSource") List<Integer> listSource); + + /** + * 缁熻鐢ㄦ埛璁㈠崟 骞惰鍗曞彿鍒嗙粍 + * + * @param start + * @param count + * @param uid + * @return + */ + long countOrderList(@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("listSource") List<Integer> listSource); + + + /** + * 缁熻宸茬粨绠椾笖浠樻閲戦澶т簬1鐨勮鍗曪紙涓嶅尯鍒嗚鍗曠姸鎬侊級 + * + * @param uid + * @param payment + * @return + */ + Long countOrderByUidAndSettled(@Param("uid") Long uid, @Param("payment") BigDecimal payment); + + /** + * 鑾峰彇鏈�鏂扮殑娣樺疂璁㈠崟鍙� + * + * @return + */ + String getNewestOrderNoByTaoBao(); + + /** + * 鏍规嵁璁㈠崟鍙疯繘琛宻ous + * + * @param orderNo + * @return + */ + List<CommonOrder> listByOrderNo(@Param("orderNo") String orderNo); + + + /** + * 鑾峰彇棣栦釜璁㈠崟 + * + * @param orderNo + * @return + */ + CommonOrder getFirstOrder(@Param("uid") Long uid); + + + List<CommonOrder> listByGoodsIdAndUidAndMinThirdCreateTime(@Param("goodsId") Long goodsId, @Param("uid") Long uid, @Param("minThirdCreateTime") Date minThirdCreateTime, @Param("start") long start, @Param("count") int count); + + + List<CommonOrder> test(); + + List<CommonOrder> list(@Param("query") DaoQuery query,@Param("start")long start,@Param("count")int count); + + + public static class DaoQuery { + public Integer state; + public String orderId; + public Integer sourceType; + public Date minThirdCreateTime; + public Date maxThirdCreateTime; + public List<String> sortList; + } + } \ No newline at end of file -- Gitblit v1.8.0