Subversion Repositories SmartDukaan

Rev

Rev 35493 | Rev 35574 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
26522 amit.gupta 1
package com.spice.profitmandi.dao.cart;
2
 
28653 amit.gupta 3
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
29261 amit.gupta 4
import com.spice.profitmandi.common.model.ProfitMandiConstants;
26522 amit.gupta 5
import com.spice.profitmandi.dao.entity.catalog.Item;
6
import com.spice.profitmandi.dao.entity.catalog.TagListing;
29327 tejbeer 7
import com.spice.profitmandi.dao.entity.cs.PartnerRegion;
8
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
35170 vikas 9
import com.spice.profitmandi.dao.entity.fofo.PartnerType;
32493 amit.gupta 10
import com.spice.profitmandi.dao.entity.inventory.SaholicCISTable;
26522 amit.gupta 11
import com.spice.profitmandi.dao.entity.user.Cart;
28166 tejbeer 12
import com.spice.profitmandi.dao.entity.user.CartLine;
26522 amit.gupta 13
import com.spice.profitmandi.dao.entity.user.User;
33172 tejus.loha 14
import com.spice.profitmandi.dao.model.*;
29327 tejbeer 15
import com.spice.profitmandi.dao.repository.catalog.FocusedModelRepository;
26522 amit.gupta 16
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
17
import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
29327 tejbeer 18
import com.spice.profitmandi.dao.repository.cs.PartnerRegionRepository;
26522 amit.gupta 19
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
29327 tejbeer 20
import com.spice.profitmandi.dao.repository.dtr.RetailerBlockBrandsRepository;
26522 amit.gupta 21
import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
35170 vikas 22
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
32493 amit.gupta 23
import com.spice.profitmandi.dao.repository.inventory.SaholicCISTableRepository;
29327 tejbeer 24
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
28166 tejbeer 25
import com.spice.profitmandi.dao.repository.user.CartLineRepository;
26522 amit.gupta 26
import com.spice.profitmandi.dao.repository.user.CartRepository;
27
import com.spice.profitmandi.dao.repository.user.UserRepository;
32493 amit.gupta 28
import com.spice.profitmandi.dao.repository.warehouse.BrandRegionMappingRepository;
29327 tejbeer 29
import com.spice.profitmandi.service.NotificationService;
30
import com.spice.profitmandi.service.inventory.FocusedShortageModel;
28653 amit.gupta 31
import com.spice.profitmandi.service.inventory.SaholicInventoryService;
35140 ranu 32
import com.spice.profitmandi.service.inventory.WarehouseIntransitDataModel;
29327 tejbeer 33
import com.spice.profitmandi.service.transaction.TransactionService;
32493 amit.gupta 34
import org.apache.logging.log4j.LogManager;
35
import org.apache.logging.log4j.Logger;
36
import org.springframework.beans.factory.annotation.Autowired;
37
import org.springframework.stereotype.Component;
26522 amit.gupta 38
 
35170 vikas 39
import java.time.LocalDate;
32493 amit.gupta 40
import java.time.LocalDateTime;
41
import java.util.*;
42
import java.util.Map.Entry;
43
import java.util.stream.Collectors;
44
 
28170 tejbeer 45
@Component
26522 amit.gupta 46
public class CartServiceImpl implements CartService {
47
 
31773 amit.gupta 48
    private static final Set<Integer> tagIds = new HashSet<>(Arrays.asList(4));
26522 amit.gupta 49
 
31773 amit.gupta 50
    private static final Logger logger = LogManager.getLogger(CartServiceImpl.class);
28653 amit.gupta 51
 
31773 amit.gupta 52
    private static final Map<Integer, List<Integer>> focusedModelVariantMap = new HashMap<>();
29404 tejbeer 53
 
31773 amit.gupta 54
    @Autowired
55
    CartRepository cartRepository;
26522 amit.gupta 56
 
31773 amit.gupta 57
    @Autowired
58
    CartLineRepository cartLineRepository;
26522 amit.gupta 59
 
31773 amit.gupta 60
    @Autowired
61
    FofoStoreRepository fofoStoreRepository;
26522 amit.gupta 62
 
31773 amit.gupta 63
    @Autowired
64
    TagListingRepository tagListingRepository;
26522 amit.gupta 65
 
31773 amit.gupta 66
    @Autowired
67
    SaholicInventoryService saholicInventoryService;
26522 amit.gupta 68
 
31773 amit.gupta 69
    @Autowired
70
    UserRepository saholicUserRepository;
26522 amit.gupta 71
 
31773 amit.gupta 72
    @Autowired
73
    ItemRepository itemRepository;
28170 tejbeer 74
 
26522 amit.gupta 75
 
31773 amit.gupta 76
    @Autowired
77
    CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
29327 tejbeer 78
 
31773 amit.gupta 79
    @Autowired
80
    private FocusedModelRepository focusedModelRepository;
29327 tejbeer 81
 
31773 amit.gupta 82
    @Autowired
83
    private PartnerRegionRepository partnerRegionRepository;
29327 tejbeer 84
 
31773 amit.gupta 85
    @Autowired
86
    private TransactionService transactionService;
29327 tejbeer 87
 
31773 amit.gupta 88
    @Autowired
89
    private RetailerBlockBrandsRepository retailerBlockBrandRepository;
29327 tejbeer 90
 
31773 amit.gupta 91
    @Autowired
92
    private OrderRepository orderRepository;
29327 tejbeer 93
 
31773 amit.gupta 94
    @Autowired
95
    private NotificationService notificationService;
96
    @Autowired
97
    private SaholicCISTableRepository saholicCISTableRepository;
29327 tejbeer 98
 
31773 amit.gupta 99
    @Autowired
100
    private BrandRegionMappingRepository brandRegionMappingRepository;
26522 amit.gupta 101
 
35170 vikas 102
    @Autowired
103
    private PartnerTypeChangeService partnerTypeChangeService;
104
 
31773 amit.gupta 105
    @Override
106
    // Unused method
107
    public CartModel addToCart(int cartId, int itemId, int quantity, float sellingPrice) {
108
        CartLine cartItem = cartLineRepository.selectByCartItem(cartId, itemId);
109
        if (cartItem == null) {
110
            this.createCartItem(cartId, itemId, quantity, sellingPrice);
111
        } else {
112
            cartItem.setQuantity(quantity);
113
            cartItem.setActualPrice(sellingPrice);
114
        }
115
        return null;
116
    }
26522 amit.gupta 117
 
31773 amit.gupta 118
    private void createCartItem(int cartId, int itemId, int quantity, float sellingPrice) {
119
        CartLine cartLine = new CartLine();
120
        cartLine.setActualPrice(sellingPrice);
121
        cartLine.setCartId(cartId);
122
        cartLine.setQuantity(quantity);
123
        // TODO: Estmiate Logic
124
        cartLine.setEstimate(2);
125
        cartLineRepository.persist(cartLine);
26522 amit.gupta 126
 
31773 amit.gupta 127
    }
26522 amit.gupta 128
 
31773 amit.gupta 129
    @Override
130
    public boolean clearCart(int cartId) throws ProfitMandiBusinessException {
131
        List<CartLine> cartLines = cartLineRepository.selectAllByCart(cartId);
132
        cartLines.stream().forEach(cartLine -> cartLineRepository.delete(cartLine));
133
        Cart cart = cartRepository.selectById(cartId);
26522 amit.gupta 134
 
31773 amit.gupta 135
        cart.setUpdateTimestamp(LocalDateTime.now());
136
        cart.setCheckoutTimestamp(null);
137
        cart.setTotalPrice(0);
138
        cart.setWalletAmount(0);
139
        return true;
140
    }
26522 amit.gupta 141
 
31773 amit.gupta 142
    @Override
143
    public CartModel getCart(int cartId) {
144
        // TODO Auto-generated method stub
145
        return null;
146
    }
26522 amit.gupta 147
 
31773 amit.gupta 148
    // As of now it only works for Fofo Partners need to be refactored later
149
    private Map<Integer, Integer> getAvailabilityMap(User user, Set<Integer> itemIds) {
150
        Map<Integer, Integer> itemAvailabilityMap = new HashMap<>();
151
        List<TagListing> tags = tagListingRepository.selectByItemIdsAndTagIds(itemIds, tagIds);
152
        tags.stream().forEach(tagListing -> {
153
            if (!tagListing.isActive() || tagListing.isHotDeals()) {
154
                // show actual values here
155
            } else {
32585 amit.gupta 156
                itemAvailabilityMap.put(tagListing.getItemId(), 400);
31773 amit.gupta 157
            }
158
        });
159
        return itemAvailabilityMap;
160
    }
26522 amit.gupta 161
 
31773 amit.gupta 162
    // As of now it only works for Fofo Partners need to be refactored later
33244 ranu 163
    private Map<Integer, Integer> getMinBuyQtyMap(User user, Set<Integer> itemIds) throws ProfitMandiBusinessException {
31773 amit.gupta 164
        List<Item> items = itemRepository.selectByIds(itemIds);
165
        return items.stream().collect(Collectors.toMap(x -> x.getId(), x -> x.getCategoryId() == 10020 ? 1 : 10));
166
    }
26522 amit.gupta 167
 
31773 amit.gupta 168
    // As of now it only works for Fofo Partners need to be refactored later
169
    private Map<Integer, Float> getPriceMap(User user, Set<Integer> itemIds) {
170
        List<TagListing> tags = tagListingRepository.selectByItemIdsAndTagIds(itemIds, tagIds);
171
        return tags.stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x.getSellingPrice()));
28653 amit.gupta 172
 
31773 amit.gupta 173
    }
28653 amit.gupta 174
 
31773 amit.gupta 175
    @Override
176
    public CartResponse getCartValidation(int cartId) throws ProfitMandiBusinessException {
177
        /*
178
         * # No need to validate duplicate items since there are only two ways # to add
179
         * items to a cart and both of them check whether the item being # added is a
180
         * duplicate of an already existing item.
181
         */
28653 amit.gupta 182
 
31773 amit.gupta 183
        Cart cart = cartRepository.selectById(cartId);
184
        List<CartLine> cartLines = cartLineRepository.selectAllByCart(cartId);
28653 amit.gupta 185
 
31792 amit.gupta 186
        //User saholicUser = saholicUserRepository.selectByCartId(cartId);
28653 amit.gupta 187
 
31773 amit.gupta 188
        int totalQty = 0;
189
        double totalAmount = 0;
190
        CartResponse cartResponse = new CartResponse();
191
        List<CartMessage> cartMessages = new ArrayList<>();
192
        List<CartItemResponseModel> cartItemModels = new ArrayList<>();
193
        cartResponse.setCartMessages(cartMessages);
194
        cartResponse.setCartItems(cartItemModels);
28653 amit.gupta 195
 
31773 amit.gupta 196
        int cartMessageChanged = 0;
197
        int cartMessageOOS = 0;
198
        int cartMessageUndeliverable = 0;
28653 amit.gupta 199
 
31773 amit.gupta 200
        Set<Integer> itemIds = cartLines.stream().map(x -> x.getItemId()).collect(Collectors.toSet());
31783 amit.gupta 201
        logger.info("Item ids {}", itemIds);
31773 amit.gupta 202
        List<TagListing> tagListings = tagListingRepository.selectByItemIdsAndTagIds(itemIds, tagIds);
203
        Map<Integer, TagListing> tagListingsMap = tagListings.stream()
204
                .collect(Collectors.toMap(x -> x.getItemId(), x -> x));
28653 amit.gupta 205
 
35493 amit 206
        // N+1 fix: Pre-fetch all items before the loop
207
        Map<Integer, Item> itemMap = itemRepository.selectByIds(itemIds).stream()
208
                .collect(Collectors.toMap(Item::getId, item -> item));
209
 
31773 amit.gupta 210
        User user = saholicUserRepository.selectByCartId(cartId);
211
        FofoStore fs = fofoStoreRepository.selectByRetailerId(user.getId());
212
        Map<Integer, Integer> warehouseItemQtyMap = saholicInventoryService.getSaholicNetAvailability(fs.getWarehouseId(), new ArrayList<>(itemIds));
35170 vikas 213
        PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fs.getId(), LocalDate.now());
35140 ranu 214
        // Get in-transit data for this warehouse
215
        List<WarehouseIntransitDataModel> warehouseIntransitDataModels =
216
                saholicInventoryService.getWarehouseIntransistDataList().stream()
217
                        .filter(x -> x.getWarehouseId() == fs.getWarehouseId())
218
                        .collect(Collectors.toList());
28653 amit.gupta 219
 
35140 ranu 220
        // Add in-transit quantities into the map
221
        for (WarehouseIntransitDataModel intransitData : warehouseIntransitDataModels) {
222
            if (intransitData.getQty() > 0) {
223
                int itemId = intransitData.getItemId();
224
                int existingQty = warehouseItemQtyMap.getOrDefault(itemId, 0);
225
                warehouseItemQtyMap.put(itemId, existingQty + intransitData.getQty());
226
            }
227
        }
31773 amit.gupta 228
        cart.setTotalPrice(0);
229
        int nonAccessoryQuantity = 0;
230
        for (CartLine cartLine : cartLines) {
231
            CartItemResponseModel cartItemResponseModel = new CartItemResponseModel();
232
            int oldEstimate = cartLine.getEstimate();
233
            int itemId = cartLine.getItemId();
35493 amit 234
            // N+1 fix: Use pre-fetched itemMap instead of querying per item
235
            Item item = itemMap.get(itemId);
236
            if (item == null) {
31773 amit.gupta 237
                logger.info("Error finding item with id {}", itemId);
238
                cartLineRepository.delete(cartLine);
239
                continue;
240
            }
35493 amit 241
            cartItemResponseModel.setTitle(item.getItemDescriptionNoColor());
31773 amit.gupta 242
            cartItemResponseModel.setItemId(itemId);
243
            cartItemResponseModel.setQuantity(cartLine.getQuantity());
244
            cartItemResponseModel.setColor(item.getColor());
245
            cartItemResponseModel.setCatalogItemId(item.getCatalogItemId());
246
            cartItemResponseModel.setMinBuyQuantity(1);
247
            cartItemResponseModel.setQuantityStep(1);
32588 amit.gupta 248
            cartItemResponseModel.setMaxQuantity(400);
31773 amit.gupta 249
            int currentAvailability = warehouseItemQtyMap.get(itemId) == null ? 0 : warehouseItemQtyMap.get(itemId);
250
            int oldAvailability = cartLine.getAvailability();
251
            cartItemResponseModel.setAvailability(currentAvailability);
28653 amit.gupta 252
 
31773 amit.gupta 253
            //Current availability is less than required quantity
254
            if (currentAvailability < cartLine.getQuantity()) {
255
                //Current Availability is reduced
256
                if (oldAvailability > currentAvailability) {
257
                    cartMessageChanged += 1;
258
                }
259
            }
28653 amit.gupta 260
 
31773 amit.gupta 261
            //As of now one can buy upto 100 Qty
262
            if (cartLine.getQuantity() > cartItemResponseModel.getMaxQuantity()) {
263
                cartMessageChanged +=1;
264
                cartLine.setQuantity(cartItemResponseModel.getMaxQuantity());
265
            }
28653 amit.gupta 266
 
31773 amit.gupta 267
            if (item.getCategoryId() == 10006 || item.getCategoryId() == 10010) {
268
                nonAccessoryQuantity += cartItemResponseModel.getQuantity();
269
                cartItemResponseModel.setCategoryName("mobile");
270
            }
35211 vikas 271
            if (cartItemResponseModel.getItemId() == ProfitMandiConstants.ITEM_CARRY_BAG) {
35170 vikas 272
                if (partnerType.equals(PartnerType.SILVER) || partnerType.equals(PartnerType.BRONZE)) {
35214 vikas 273
                    cartLine.setActualPrice(tagListingsMap.get(itemId).getSellingPrice());
35170 vikas 274
                    cartItemResponseModel.setSellingPrice(cartLine.getActualPrice());
275
                } else {
276
                    cartItemResponseModel.setSellingPrice(1);
35214 vikas 277
                    cartLine.setActualPrice(1);
35170 vikas 278
                }
279
            } else {
35573 amit 280
                // Check for price mismatch between cart and current TagListing
281
                TagListing currentTagListing = tagListingsMap.get(itemId);
282
                if (currentTagListing != null) {
283
                    float cartPrice = cartLine.getActualPrice();
284
                    float currentPrice = currentTagListing.getSellingPrice();
285
                    if (Float.compare(cartPrice, currentPrice) != 0) {
286
                        cartMessageChanged += 1;
287
                        String priceChangeMsg = String.format("Price updated for %s: Rs. %.2f to Rs. %.2f",
288
                            item.getItemDescriptionNoColor(), cartPrice, currentPrice);
289
                        CartMessage cartMessage = new CartMessage();
290
                        cartMessage.setMessageText(priceChangeMsg);
291
                        cartMessage.setType("PRICE_CHANGED");
292
                        cartMessages.add(cartMessage);
293
                        logger.info("Price mismatch detected for itemId {}: cart price {} vs current price {}",
294
                            itemId, cartPrice, currentPrice);
295
                        // Update cart line with current price
296
                        cartLine.setActualPrice(currentPrice);
297
                    }
298
                }
35170 vikas 299
                cartItemResponseModel.setSellingPrice(cartLine.getActualPrice());
300
            }
28653 amit.gupta 301
 
31773 amit.gupta 302
            //if (availability > 0) {
303
            cart.setTotalPrice(cart.getTotalPrice() + (cartLine.getActualPrice() * cartLine.getQuantity()));
304
            cartItemResponseModel.setQuantity(cartLine.getQuantity());
305
            cartItemResponseModel.setEstimate(2);
306
            cartLine.setEstimate(cartItemResponseModel.getEstimate());
307
            cart.setUpdateTimestamp(LocalDateTime.now());
28653 amit.gupta 308
 
28166 tejbeer 309
 
31773 amit.gupta 310
            totalAmount += cartLine.getActualPrice() * cartLine.getQuantity();
311
            totalQty += cartItemResponseModel.getQuantity();
312
            cartResponse.getCartItems().add(cartItemResponseModel);
28166 tejbeer 313
 
31773 amit.gupta 314
        }
315
        if (cart.getCheckoutTimestamp() != null) {
316
            if (cart.getUpdateTimestamp().isBefore(cart.getCheckoutTimestamp())) {
317
                cart.setCheckoutTimestamp(null);
318
            }
319
        }
320
        cartResponse.setTotalQty(totalQty);
321
        cartResponse.setTotalAmount(totalAmount);
322
        cartResponse.setNonAccessoryQuantity(nonAccessoryQuantity);
323
        cartResponse.setShippingCharge(0);
324
        cartResponse.setCartMessageChanged(cartMessageChanged);
325
        cartResponse.setCartMessageOOS(cartMessageOOS);
326
        cartResponse.setCartMessageUndeliverable(cartMessageUndeliverable);
327
        cartResponse.setCod(false);
328
        return cartResponse;
329
    }
28653 amit.gupta 330
 
31773 amit.gupta 331
    @Override
332
    public void addItemsToCart(int cartId, List<CartItem> cartItems) throws ProfitMandiBusinessException {
333
        logger.info("cart items {}", cartItems);
334
        cartItems = cartItems.stream().filter(x -> x.getQuantity() > 0).collect(Collectors.toList());
335
        Map<Integer, Integer> itemQuantityMap = cartItems.stream()
336
                .collect(Collectors.toMap(x -> x.getItemId(), x -> x.getQuantity()));
337
        List<CartLine> cartLines = cartLineRepository.selectAllByCart(cartId);
31781 amit.gupta 338
        Map<Integer, CartLine> itemCartLineMap = cartLines.stream().collect(Collectors.toMap(x->x.getItemId(), x->x));
31773 amit.gupta 339
        // Delete cartLines with 0 values
340
        for (CartLine cartLine : cartLines) {
341
            Integer quantity = itemQuantityMap.get(cartLine.getItemId());
342
            if (quantity == null || quantity.intValue() == 0) {
343
                cartLineRepository.delete(cartLine);
344
            } else {
345
                cartLine.setQuantity(itemQuantityMap.get(cartLine.getItemId()));
346
                cartLine.setUpdateTimestapm(LocalDateTime.now());
347
            }
348
        }
349
        for (CartItem cartItem : cartItems) {
31781 amit.gupta 350
            if (!itemCartLineMap.containsKey(cartItem.getItemId())) {
31773 amit.gupta 351
                CartLine cartLineNew = new CartLine();
352
                cartLineNew.setItemId(cartItem.getItemId());
353
                cartLineNew.setQuantity(cartItem.getQuantity());
354
                cartLineNew.setCartId(cartId);
32493 amit.gupta 355
                cartLineNew.setActualPrice((float) cartItem.getSellingPrice());
31773 amit.gupta 356
                cartLineNew.setCreateTimestamp(LocalDateTime.now());
357
                cartLineRepository.persist(cartLineNew);
358
            }
359
        }
29327 tejbeer 360
 
31773 amit.gupta 361
    }
29327 tejbeer 362
 
31773 amit.gupta 363
    @Override
364
    public void addAddressToCart(int cartId, long addressId) throws ProfitMandiBusinessException {
365
        Cart cart = cartRepository.selectById(cartId);
366
        cart.setAddressId((int) addressId);
29404 tejbeer 367
 
31773 amit.gupta 368
    }
29404 tejbeer 369
 
31773 amit.gupta 370
    @Override
371
    public void addShoppingBag(int cartId, long qty) {
372
        CartLine cl = new CartLine();
373
        cl.setItemId(ProfitMandiConstants.ITEM_CARRY_BAG);
374
        cl.setQuantity((int) qty);
375
        cl.setCartId(cartId);
376
        cl.setCreateTimestamp(LocalDateTime.now());
377
        cl.setDataProtectionAmount(0);
378
        cl.setEstimate(0);
379
        cl.setInsuranceAmount(0f);
380
        cl.setDataProtectionInsurer(0);
381
        cl.setActualPrice(0.01f);
382
        cartLineRepository.persist(cl);
29404 tejbeer 383
 
31773 amit.gupta 384
    }
29404 tejbeer 385
 
31773 amit.gupta 386
    @Override
387
    public CartModel removeFromCart(int cartId, int itemId) {
388
        // TODO Auto-generated method stub
389
        return null;
390
    }
29327 tejbeer 391
 
31773 amit.gupta 392
    @Override
393
    public List<FocusedShortageModel> focusedModelShortageValidation(int fofoId,
394
                                                                     Map<Integer, Integer> catalogCartQtyMap) throws ProfitMandiBusinessException {
29327 tejbeer 395
 
31773 amit.gupta 396
        logger.info("fofoId {}", fofoId);
29327 tejbeer 397
 
31773 amit.gupta 398
        focusedModelVariantMap.put(1022771, Arrays.asList(1022771));
399
        focusedModelVariantMap.put(1023025, Arrays.asList(1022975, 1022945));
29327 tejbeer 400
 
31773 amit.gupta 401
        focusedModelVariantMap.put(1023027, Arrays.asList(1022706));
29327 tejbeer 402
 
31773 amit.gupta 403
        focusedModelVariantMap.put(1022976, Arrays.asList(1022744));
404
        focusedModelVariantMap.put(1023045, Arrays.asList(1022768));
29327 tejbeer 405
 
31773 amit.gupta 406
        focusedModelVariantMap.put(1023066, Arrays.asList(1022858));
29327 tejbeer 407
 
31773 amit.gupta 408
        Map<Integer, Long> inStockItemModel = new HashMap<>();
409
        Map<Integer, Long> itempendingIndent = new HashMap<>();
410
        Map<Integer, Long> grnItemPendingOrders = new HashMap<>();
29327 tejbeer 411
 
31773 amit.gupta 412
        Map<Integer, Integer> focusedModelMap = null;
29327 tejbeer 413
 
31773 amit.gupta 414
        inStockItemModel = currentInventorySnapshotRepository.selectSumInMobileStockGroupByCatalog(fofoId).stream()
415
                .collect(Collectors.toMap(x -> x.getCatalogItemId(), x -> x.getQty()));
29327 tejbeer 416
 
31773 amit.gupta 417
        itempendingIndent = transactionService.getInTransitOrders(fofoId).stream()
418
                .collect(Collectors.groupingBy(x -> x.getLineItem().getItem().getCatalogItemId(),
419
                        Collectors.summingLong(x -> (long) x.getLineItem().getQuantity())));
29327 tejbeer 420
 
31773 amit.gupta 421
        grnItemPendingOrders = orderRepository.selectPendingGrnOrders(fofoId).stream()
422
                .collect(Collectors.groupingBy(x -> x.getLineItem().getItem().getCatalogItemId(),
423
                        Collectors.summingLong(x -> (long) x.getLineItem().getQuantity())));
424
        List<PartnerRegion> partnerRegions = partnerRegionRepository.selectByfofoId(fofoId);
29327 tejbeer 425
 
31773 amit.gupta 426
        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(fofoId);
29327 tejbeer 427
 
31773 amit.gupta 428
        List<String> retailerBlockBrands = retailerBlockBrandRepository.selectAllByRetailer(fofoId).stream()
429
                .map(x -> x.getBlockBrands()).collect(Collectors.toList());
29327 tejbeer 430
 
31773 amit.gupta 431
        if (partnerRegions.size() > 0) {
432
            focusedModelMap = focusedModelRepository
433
                    .selectAllByRegionIds(
434
                            partnerRegions.stream().map(x -> x.getRegionId()).collect(Collectors.toList()))
435
                    .stream().collect(Collectors.toMap(x -> x.getCatalogId(), x -> x.getMinimumQty()));
436
        } else {
437
            focusedModelMap = new HashMap<>();
438
        }
29327 tejbeer 439
 
31773 amit.gupta 440
        Map<Integer, Integer> catalogItemAailabilityMap = new HashMap<>();
29327 tejbeer 441
 
31773 amit.gupta 442
        for (Entry<Integer, Integer> fm : focusedModelMap.entrySet()) {
443
            List<Item> items = itemRepository.selectAllByCatalogItemId(fm.getKey());
444
            int allColorNetAvailability = 0;
445
            for (Item item : items) {
446
                if (retailerBlockBrands.contains(item.getBrand()))
447
                    continue;
448
                List<SaholicCISTable> currentAvailability = saholicCISTableRepository.selectByItemWarehouse(item.getId(), fofoStore.getWarehouseId());
29327 tejbeer 449
 
31773 amit.gupta 450
                if (currentAvailability != null) {
451
                    allColorNetAvailability += currentAvailability.stream()
452
                            .collect(Collectors.summingInt(SaholicCISTable::getNetAvailability));
453
                }
454
            }
455
            catalogItemAailabilityMap.put(fm.getKey(), allColorNetAvailability);
456
        }
29327 tejbeer 457
 
31773 amit.gupta 458
        List<FocusedShortageModel> focusedModelShortageList = new ArrayList<>();
29327 tejbeer 459
 
31773 amit.gupta 460
        for (Entry<Integer, Integer> fm : focusedModelMap.entrySet()) {
29327 tejbeer 461
 
31773 amit.gupta 462
            logger.info("fm {}", fm);
29404 tejbeer 463
 
31773 amit.gupta 464
            long overallStock = (inStockItemModel.get(fm.getKey()) == null ? 0 : inStockItemModel.get(fm.getKey()))
465
                    + (itempendingIndent.get(fm.getKey()) == null ? 0 : itempendingIndent.get(fm.getKey()))
466
                    + (grnItemPendingOrders.get(fm.getKey()) == null ? 0 : grnItemPendingOrders.get(fm.getKey()));
467
            logger.info("overallStock {}", overallStock);
29404 tejbeer 468
 
31773 amit.gupta 469
            // Blocked brands available quantity is discussed to zero
470
            long warehouseStock = catalogItemAailabilityMap.get(fm.getKey()) == null ? 0
471
                    : catalogItemAailabilityMap.get(fm.getKey());
472
            logger.info("warehouseStock {}", warehouseStock);
29404 tejbeer 473
 
31773 amit.gupta 474
            long cartValue = catalogCartQtyMap.get(fm.getKey()) == null ? 0 : catalogCartQtyMap.get(fm.getKey());
29404 tejbeer 475
 
31773 amit.gupta 476
            logger.info("cartValue" + cartValue);
477
            long totalStock = overallStock + cartValue;
478
            logger.info("totalStock" + totalStock);
29404 tejbeer 479
 
31773 amit.gupta 480
            long shortQty = Math.min(fm.getValue() - totalStock, warehouseStock);
481
            logger.info("shortQty {}", shortQty);
29404 tejbeer 482
 
31773 amit.gupta 483
            if (shortQty > 0) {
484
                if (focusedModelVariantMap.get(fm.getKey()) != null) {
485
                    List<Integer> variantCatalogIds = focusedModelVariantMap.get(fm.getKey());
486
                    logger.info("variantCatalogIds {}", variantCatalogIds);
29404 tejbeer 487
 
31773 amit.gupta 488
                    int variantAvailability = 0;
489
                    for (Integer vc : variantCatalogIds) {
490
                        long variantOverallStock = (inStockItemModel.get(vc) == null ? 0 : inStockItemModel.get(vc))
491
                                + (itempendingIndent.get(vc) == null ? 0 : itempendingIndent.get(vc))
492
                                + (grnItemPendingOrders.get(vc) == null ? 0 : grnItemPendingOrders.get(vc));
493
                        logger.info("variantOverallStock {}", variantOverallStock);
29404 tejbeer 494
 
31773 amit.gupta 495
                        // Blocked brands available quantity is discussed to zero
496
                        long variantWarehouseStock = catalogItemAailabilityMap.get(vc) == null ? 0
497
                                : catalogItemAailabilityMap.get(vc);
498
                        logger.info("variantWarehouseStock {}", variantWarehouseStock);
29404 tejbeer 499
 
31773 amit.gupta 500
                        long variantCartValue = catalogCartQtyMap.get(vc) == null ? 0 : catalogCartQtyMap.get(vc);
29404 tejbeer 501
 
31773 amit.gupta 502
                        logger.info("variantCartValue" + variantCartValue);
503
                        long variantTotalStock = variantOverallStock + variantCartValue;
504
                        logger.info("variantTotalStock" + variantTotalStock);
29404 tejbeer 505
 
31773 amit.gupta 506
                        variantAvailability += (int) variantTotalStock;
29327 tejbeer 507
 
31773 amit.gupta 508
                    }
29327 tejbeer 509
 
31773 amit.gupta 510
                    logger.info("variantAvailability {}", variantAvailability);
29327 tejbeer 511
 
31773 amit.gupta 512
                    shortQty = shortQty - variantAvailability;
29327 tejbeer 513
 
31773 amit.gupta 514
                }
515
            }
29327 tejbeer 516
 
31773 amit.gupta 517
            logger.info("shortQty" + shortQty);
29327 tejbeer 518
 
31773 amit.gupta 519
            if (shortQty > 0) {
29327 tejbeer 520
 
31773 amit.gupta 521
                Map<Integer, Integer> requiredItemQty = new HashMap<>();
29327 tejbeer 522
 
31773 amit.gupta 523
                List<Item> it = itemRepository.selectAllByCatalogItemId(fm.getKey());
524
                FocusedShortageModel fms = new FocusedShortageModel();
525
                fms.setShortageQty((int) shortQty);
526
                fms.setCatalogId(fm.getKey());
527
                fms.setAvailabitiy(fm.getValue());
528
                fms.setInStock(overallStock);
29327 tejbeer 529
 
31773 amit.gupta 530
                fms.setItemName(it.get(0).getBrand() + it.get(0).getModelNumber() + it.get(0).getModelName());
29327 tejbeer 531
 
31773 amit.gupta 532
                Map<Integer, Integer> itemQtyMap = new HashMap<>();
29327 tejbeer 533
 
31773 amit.gupta 534
                for (Item i : it) {
29327 tejbeer 535
 
31773 amit.gupta 536
                    List<SaholicCISTable> ca = saholicCISTableRepository.selectByItemWarehouse(i.getId(), fofoStore.getWarehouseId());
537
                    if (ca != null) {
538
                        itemQtyMap.put(i.getId(),
539
                                ca.stream().collect(Collectors.summingInt(SaholicCISTable::getNetAvailability)));
540
                    }
541
                }
29327 tejbeer 542
 
31773 amit.gupta 543
                itemQtyMap = itemQtyMap.entrySet().stream()
544
                        .sorted(Collections.reverseOrder(Map.Entry.comparingByValue())).collect(Collectors
545
                                .toMap(Map.Entry::getKey, Map.Entry::getValue, (e1, e2) -> e2, LinkedHashMap::new));
29327 tejbeer 546
 
31773 amit.gupta 547
                for (long i = shortQty; i > 0; i--) {
548
                    if (shortQty == 0) {
549
                        break;
550
                    }
29327 tejbeer 551
 
31773 amit.gupta 552
                    for (Entry<Integer, Integer> itemQty : itemQtyMap.entrySet()) {
29327 tejbeer 553
 
31773 amit.gupta 554
                        int availbleQty = itemQty.getValue();
555
                        if (availbleQty == 0) {
556
                            break;
557
                        }
558
                        if (requiredItemQty.get(itemQty.getKey()) == null) {
559
                            requiredItemQty.put(itemQty.getKey(), 1);
560
                            availbleQty = availbleQty - 1;
561
                            if (availbleQty != 0) {
562
                                itemQtyMap.put(itemQty.getKey(), availbleQty);
563
                            }
564
                            shortQty -= 1;
565
                        } else {
29327 tejbeer 566
 
31773 amit.gupta 567
                            int qty = requiredItemQty.get(itemQty.getKey());
29327 tejbeer 568
 
31773 amit.gupta 569
                            requiredItemQty.put(itemQty.getKey(), qty + 1);
29327 tejbeer 570
 
31773 amit.gupta 571
                            availbleQty = availbleQty - 1;
572
                            if (availbleQty != 0) {
573
                                itemQtyMap.put(itemQty.getKey(), availbleQty);
574
                            }
575
                            shortQty -= 1;
576
                        }
29327 tejbeer 577
 
31773 amit.gupta 578
                        if (shortQty == 0) {
579
                            break;
580
                        }
29327 tejbeer 581
 
31773 amit.gupta 582
                    }
29327 tejbeer 583
 
31773 amit.gupta 584
                }
29327 tejbeer 585
 
31773 amit.gupta 586
                Set<CartItem> cartItems = new HashSet<>();
587
                for (Entry<Integer, Integer> itemQtySet : requiredItemQty.entrySet()) {
29327 tejbeer 588
 
31773 amit.gupta 589
                    CartItem ci = new CartItem();
590
                    Item item = itemRepository.selectById(itemQtySet.getKey());
591
                    TagListing tl = tagListingRepository.selectByItemId(item.getId());
592
                    ci.setItemId(item.getId());
593
                    ci.setQuantity(itemQtySet.getValue());
594
                    ci.setSellingPrice(tl.getSellingPrice());
595
                    cartItems.add(ci);
596
 
597
                }
598
                fms.setCartItems(cartItems);
599
 
600
                // fms.setItemQtyAvailability(requiredItemQty);
601
 
602
                focusedModelShortageList.add(fms);
603
 
604
            }
605
 
606
        }
607
 
608
        logger.info("focusedModelShortageList {}", focusedModelShortageList);
609
        return focusedModelShortageList;
610
    }
611
 
33172 tejus.loha 612
    @Override
613
    public UserCart setCartItems(int fofoId, List<CartItem> cartItems) throws ProfitMandiBusinessException {
614
        User user = saholicUserRepository.selectById(fofoId);
615
        this.clearCart(user.getActiveCartId());
616
        this.addItemsToCart(user.getActiveCartId(), cartItems);
617
 
618
        UserCart userCart = new UserCart();
619
        userCart.setCartId(user.getActiveCartId());
620
        userCart.setUserId(user.getId());
621
        return userCart;
622
    }
623
 
26522 amit.gupta 624
}