| | |
| | | } |
| | | |
| | | // 构建购物车key |
| | | String cartKey = buildCartKey(userId,unitId); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, cartItemDTO.getPricingId()); |
| | | String cartKey = buildCartKey(userId,unitId, cartItemDTO.getProductId()); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, cartItemDTO.getProductId(),cartItemDTO.getPricingId()); |
| | | |
| | | // 检查商品是否已在购物车中 |
| | | CartItemVO existingItem = (CartItemVO) redisTemplate.opsForValue().get(cartItemKey); |
| | |
| | | redisTemplate.opsForValue().set(cartItemKey, existingItem, (cartProperties.getExpireDays() != null ? cartProperties.getExpireDays() : CART_EXPIRE_DAYS), TimeUnit.DAYS); |
| | | |
| | | // 更新购物车商品列表 |
| | | updateCartItemList(userId, unitId, cartItemDTO.getPricingId(), true); |
| | | updateCartItemList(userId, unitId, cartItemDTO.getProductId(), cartItemDTO.getPricingId(), true); |
| | | |
| | | // 设置购物车过期时间 |
| | | redisTemplate.expire(cartKey, (cartProperties.getExpireDays() != null ? cartProperties.getExpireDays() : CART_EXPIRE_DAYS), TimeUnit.DAYS); |
| | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean removeFromCart(String userId, String unitId, Long pricingId) { |
| | | public boolean removeFromCart(String userId, String unitId, String productId, Long pricingId) { |
| | | try { |
| | | String cartItemKey = buildCartItemKey(userId, unitId, pricingId); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, productId, pricingId); |
| | | |
| | | // 从Redis中删除商品项 |
| | | Boolean removed = redisTemplate.delete(cartItemKey); |
| | | if (Boolean.TRUE.equals(removed)) { |
| | | // 更新购物车商品列表 |
| | | updateCartItemList(userId, unitId, pricingId, false); |
| | | updateCartItemList(userId, unitId, productId, pricingId, false); |
| | | |
| | | // 异步从数据库中删除(根据配置) |
| | | if (Boolean.TRUE.equals(cartProperties.getEnablePersistence()) && "realtime".equalsIgnoreCase(cartProperties.getSyncStrategy())) { |
| | | cartPersistenceService.remove(userId, unitId, pricingId); |
| | | cartPersistenceService.remove(userId, unitId, productId,pricingId); |
| | | } |
| | | |
| | | log.info("用户{}成功从购物车移除商品{}", userId, pricingId); |
| | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean updateCartItemQuantity(String userId, String unitId, Long pricingId, Integer quantity) { |
| | | public boolean updateCartItemQuantity(String userId, String unitId, String productId, Long pricingId, Integer quantity) { |
| | | try { |
| | | if (quantity <= 0) { |
| | | return removeFromCart(userId, unitId, pricingId); |
| | | return removeFromCart(userId, unitId, productId, pricingId); |
| | | } |
| | | |
| | | String cartItemKey = buildCartItemKey(userId, unitId, pricingId); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, productId, pricingId); |
| | | CartItemVO cartItem = (CartItemVO) redisTemplate.opsForValue().get(cartItemKey); |
| | | if (cartItem == null) { |
| | | throw new BusinessException("购物车商品不存在"); |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean clearCart(String userId, String unitId) { |
| | | public boolean updateCartItemDuration(String userId, String unitId, String productId, Long pricingId, Integer duration) { |
| | | try { |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | List<Long> pricingIds = getCartItemPricingIds(userId, unitId); |
| | | |
| | | String cartItemKey = buildCartItemKey(userId, unitId, productId, pricingId); |
| | | CartItemVO cartItem = (CartItemVO) redisTemplate.opsForValue().get(cartItemKey); |
| | | if (cartItem == null) { |
| | | throw new BusinessException("购物车商品不存在"); |
| | | } |
| | | |
| | | cartItem.setDuration(duration); |
| | | cartItem.setUpdateTime(LocalDateTime.now()); |
| | | |
| | | // 更新到Redis |
| | | redisTemplate.opsForValue().set(cartItemKey, cartItem, (cartProperties.getExpireDays() != null ? cartProperties.getExpireDays() : CART_EXPIRE_DAYS), TimeUnit.DAYS); |
| | | |
| | | // 异步持久化到数据库(根据配置) |
| | | if (Boolean.TRUE.equals(cartProperties.getEnablePersistence()) && "realtime".equalsIgnoreCase(cartProperties.getSyncStrategy())) { |
| | | cartPersistenceService.saveOrUpdate(userId, unitId, cartItem); |
| | | } |
| | | |
| | | log.info("用户{}成功更新购物车商品{}年限为{}", userId, pricingId, duration); |
| | | return true; |
| | | } catch (Exception e) { |
| | | log.error("更新购物车商品数量失败", e); |
| | | throw new BusinessException("更新购物车商品数量失败:" + e.getMessage()); |
| | | } |
| | | } |
| | | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean clearCart(String userId, String unitId, String productId) { |
| | | try { |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = getCartItemPricingIds(userId, unitId, productId); |
| | | |
| | | // 删除所有商品项 |
| | | for (Long pricingId : pricingIds) { |
| | | String cartItemKey = buildCartItemKey(userId, unitId, pricingId); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, productId,pricingId); |
| | | redisTemplate.delete(cartItemKey); |
| | | } |
| | | |
| | |
| | | |
| | | // 异步清空数据库中的购物车数据(根据配置) |
| | | if (Boolean.TRUE.equals(cartProperties.getEnablePersistence()) && "realtime".equalsIgnoreCase(cartProperties.getSyncStrategy())) { |
| | | cartPersistenceService.clear(userId, unitId); |
| | | cartPersistenceService.clear(userId, unitId, productId); |
| | | } |
| | | |
| | | log.info("用户{}成功清空购物车", userId); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public CartVO getCart(String userId, String unitId) { |
| | | public CartVO getCart(String userId, String unitId, String productId) { |
| | | try { |
| | | CartVO cartVO = new CartVO(); |
| | | cartVO.setUserId(userId); |
| | | if (StringUtils.hasText(unitId)){ |
| | | cartVO.setUnitId(unitId); |
| | | } |
| | | List<CartItemVO> items = getCartItems(userId, unitId); |
| | | List<CartItemVO> items = getCartItems(userId, unitId, productId); |
| | | cartVO.setItems(items); |
| | | |
| | | // 计算总数量和总金额 |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<CartItemVO> getCartItems(String userId, String unitId) { |
| | | public List<CartItemVO> getCartItems(String userId, String unitId,String productId) { |
| | | try { |
| | | // 优先从Redis获取 |
| | | List<CartItemVO> items = getCartItemsFromRedis(userId, unitId); |
| | | List<CartItemVO> items = getCartItemsFromRedis(userId, unitId,productId); |
| | | if (items != null && !items.isEmpty()) { |
| | | return items; |
| | | } |
| | | |
| | | // Redis中没有数据,从数据库加载 |
| | | log.info("Redis中无购物车数据,从数据库加载用户{}的购物车", userId); |
| | | return loadCartFromDatabase(userId, unitId) ? getCartItemsFromRedis(userId, unitId) : new ArrayList<>(); |
| | | return loadCartFromDatabase(userId, unitId, productId) ? getCartItemsFromRedis(userId, unitId, productId) : new ArrayList<>(); |
| | | } catch (Exception e) { |
| | | log.error("获取购物车商品列表失败", e); |
| | | // 降级到数据库查询 |
| | | return getCartItemsFromDatabase(userId, unitId); |
| | | return getCartItemsFromDatabase(userId, unitId, productId); |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean batchRemoveFromCart(String userId, String unitId, List<Long> pricingIds) { |
| | | public boolean batchRemoveFromCart(String userId, String unitId, String productId,List<Long> pricingIds) { |
| | | try { |
| | | if (CollectionUtils.isEmpty(pricingIds)) { |
| | | return true; |
| | | } |
| | | |
| | | for (Long pricingId : pricingIds) { |
| | | removeFromCart(userId, unitId, pricingId); |
| | | removeFromCart(userId, unitId, productId,pricingId); |
| | | } |
| | | |
| | | return true; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public Integer getCartItemCount(String userId, String unitId) { |
| | | public Integer getCartItemCount(String userId, String unitId, String productId) { |
| | | try { |
| | | // 优先从Redis获取 |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = (List<Long>) redisTemplate.opsForValue().get(cartKey); |
| | | if (pricingIds != null) { |
| | | return pricingIds.size(); |
| | | } |
| | | |
| | | // 从数据库获取 |
| | | return cartMapper.countByUserIdAndUnitId(userId, unitId); |
| | | return cartMapper.countByUserIdAndUnitId(userId, unitId, productId); |
| | | } catch (Exception e) { |
| | | log.error("获取购物车商品数量失败", e); |
| | | return 0; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public boolean loadCartFromDatabase(String userId, String unitId) { |
| | | public boolean loadCartFromDatabase(String userId, String unitId, String productId) { |
| | | try { |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId); |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId, productId); |
| | | if (CollectionUtils.isEmpty(cartItems)) { |
| | | return false; |
| | | } |
| | | |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = new ArrayList<>(); |
| | | |
| | | for (Cart cartItem : cartItems) { |
| | | CartItemVO itemVO = convertCartToCartItemVO(cartItem); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, cartItem.getPricingId()); |
| | | String cartItemKey = buildCartItemKey(userId, unitId,cartItem.getProductId(), cartItem.getPricingId()); |
| | | |
| | | // 保存到Redis |
| | | redisTemplate.opsForValue().set(cartItemKey, itemVO, CART_EXPIRE_DAYS, TimeUnit.DAYS); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public boolean syncCartToDatabase(String userId, String unitId) { |
| | | public boolean syncCartToDatabase(String userId, String unitId, String productId) { |
| | | try { |
| | | List<CartItemVO> redisItems = getCartItemsFromRedis(userId, unitId); |
| | | List<CartItemVO> redisItems = getCartItemsFromRedis(userId, unitId, productId); |
| | | if (CollectionUtils.isEmpty(redisItems)) { |
| | | return true; |
| | | } |
| | | |
| | | // 清空数据库中的购物车数据 |
| | | clearCartFromDatabase(userId, unitId); |
| | | clearCartFromDatabase(userId, unitId, productId); |
| | | |
| | | // 同步Redis数据到数据库 |
| | | for (CartItemVO item : redisItems) { |
| | | syncCartItemToDatabase(userId, unitId, item); |
| | | syncCartItemToDatabase(userId, unitId,productId, item); |
| | | } |
| | | |
| | | log.info("成功同步Redis购物车数据到数据库,用户{}", userId); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public boolean checkCartConsistency(String userId, String unitId) { |
| | | public boolean checkCartConsistency(String userId, String unitId, String productId) { |
| | | try { |
| | | List<CartItemVO> redisItems = getCartItemsFromRedis(userId, unitId); |
| | | List<Cart> dbItems = cartMapper.selectByUserIdAndUnitId(userId, unitId); |
| | | List<CartItemVO> redisItems = getCartItemsFromRedis(userId, unitId, productId); |
| | | List<Cart> dbItems = cartMapper.selectByUserIdAndUnitId(userId, unitId, productId); |
| | | |
| | | if (redisItems.size() != dbItems.size()) { |
| | | log.warn("购物车数据不一致:Redis数量{},数据库数量{}", redisItems.size(), dbItems.size()); |
| | |
| | | |
| | | // ==================== 私有方法 ==================== |
| | | |
| | | private String buildCartKey(String userId, String unitId) { |
| | | private String buildCartKey(String userId, String unitId,String productId) { |
| | | if(StringUtils.hasText(unitId)){ |
| | | return CART_KEY_PREFIX + userId + ":" + unitId; |
| | | return CART_KEY_PREFIX + userId + ":" + unitId + ":" + productId; |
| | | } |
| | | return CART_KEY_PREFIX + userId; |
| | | return CART_KEY_PREFIX + userId + ":" + productId; |
| | | } |
| | | |
| | | private String buildCartItemKey(String userId, String unitId, Long pricingId) { |
| | | private String buildCartItemKey(String userId, String unitId,String productId, Long pricingId) { |
| | | if(StringUtils.hasText(unitId)){ |
| | | return CART_ITEM_KEY_PREFIX + userId + ":" + unitId + ":" + pricingId; |
| | | return CART_ITEM_KEY_PREFIX + userId + ":" + unitId + ":" + productId + ":" + pricingId; |
| | | } |
| | | return CART_ITEM_KEY_PREFIX + userId + ":" + pricingId; |
| | | return CART_ITEM_KEY_PREFIX + userId + ":" + productId + ":" + pricingId; |
| | | } |
| | | |
| | | private void updateCartItemList(String userId, String unitId, Long pricingId, boolean add) { |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | private void updateCartItemList(String userId, String unitId,String productId ,Long pricingId, boolean add) { |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = (List<Long>) redisTemplate.opsForValue().get(cartKey); |
| | | |
| | | if (pricingIds == null) { |
| | |
| | | redisTemplate.opsForValue().set(cartKey, pricingIds, CART_EXPIRE_DAYS, TimeUnit.DAYS); |
| | | } |
| | | |
| | | private List<Long> getCartItemPricingIds(String userId, String unitId) { |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | private List<Long> getCartItemPricingIds(String userId, String unitId, String productId) { |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = (List<Long>) redisTemplate.opsForValue().get(cartKey); |
| | | return pricingIds != null ? pricingIds : new ArrayList<>(); |
| | | } |
| | | |
| | | private List<CartItemVO> getCartItemsFromRedis(String userId, String unitId) { |
| | | private List<CartItemVO> getCartItemsFromRedis(String userId, String unitId, String productId) { |
| | | try { |
| | | String cartKey = buildCartKey(userId, unitId); |
| | | String cartKey = buildCartKey(userId, unitId, productId); |
| | | List<Long> pricingIds = (List<Long>) redisTemplate.opsForValue().get(cartKey); |
| | | |
| | | if (CollectionUtils.isEmpty(pricingIds)) { |
| | |
| | | |
| | | List<CartItemVO> items = new ArrayList<>(); |
| | | for (Long pricingId : pricingIds) { |
| | | String cartItemKey = buildCartItemKey(userId, unitId, pricingId); |
| | | String cartItemKey = buildCartItemKey(userId, unitId, productId,pricingId); |
| | | CartItemVO item = (CartItemVO) redisTemplate.opsForValue().get(cartItemKey); |
| | | if (item != null) { |
| | | items.add(item); |
| | |
| | | } |
| | | } |
| | | |
| | | private List<CartItemVO> getCartItemsFromDatabase(String userId, String unitId) { |
| | | private List<CartItemVO> getCartItemsFromDatabase(String userId, String unitId, String productId) { |
| | | try { |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId); |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId, productId); |
| | | List<CartItemVO> items = new ArrayList<>(); |
| | | |
| | | for (Cart cartItem : cartItems) { |
| | |
| | | return itemVO; |
| | | } |
| | | |
| | | private void syncCartItemToDatabase(String userId, String unitId, CartItemVO item) { |
| | | private void syncCartItemToDatabase(String userId, String unitId, String productId,CartItemVO item) { |
| | | try { |
| | | Cart cart = new Cart(); |
| | | BeanUtils.copyProperties(item, cart); |
| | |
| | | cart.setUpdateTime(LocalDateTime.now()); |
| | | |
| | | // 检查是否已存在 |
| | | Cart existingCart = cartMapper.selectByUserIdUnitIdAndPricingId(userId, unitId, item.getPricingId()); |
| | | Cart existingCart = cartMapper.selectByUserIdUnitIdAndPricingId(userId, unitId, productId,item.getPricingId()); |
| | | if (existingCart != null) { |
| | | // 更新 |
| | | cart.setId(existingCart.getId()); |
| | |
| | | } |
| | | } |
| | | |
| | | private void removeCartItemFromDatabase(String userId, String unitId, Long pricingId) { |
| | | private void removeCartItemFromDatabase(String userId, String unitId, String productId, Long pricingId) { |
| | | try { |
| | | Cart existingCart = cartMapper.selectByUserIdUnitIdAndPricingId(userId, unitId, pricingId); |
| | | Cart existingCart = cartMapper.selectByUserIdUnitIdAndPricingId(userId, unitId, productId,pricingId); |
| | | if (existingCart != null) { |
| | | cartMapper.deleteByCustomerCondition(existingCart.getId()); |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | private void clearCartFromDatabase(String userId, String unitId) { |
| | | private void clearCartFromDatabase(String userId, String unitId, String productId) { |
| | | try { |
| | | // 使用逻辑删除 |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId); |
| | | List<Cart> cartItems = cartMapper.selectByUserIdAndUnitId(userId, unitId, productId); |
| | | for (Cart item : cartItems) { |
| | | cartMapper.deleteById(item.getId()); |
| | | } |