Subversion Repositories SmartDukaan

Rev

Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36278 28 d 4 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ ADD OPENING STOCK  
35651 99 d 20 h aman /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Fix:Item Wise monthly sale and fofo opening stock minus condition  
35493 140 d 16 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ N+1 query optimization for B2B order creation flow

- OrderServiceImpl: Batch fetch PendingOrderItems before validation loop (line 402)
- OrderServiceImpl: Batch update opening stock using minusOpeningStockBatch
- OrderServiceImpl: Pre-fetch tagListings and GST rates before createAndGetFofoOrderItem loop
- OrderServiceImpl: Batch fetch PendingOrderItems for status update (line 719)
- CartServiceImpl: Pre-fetch items before getCartValidation loop
- SchemeServiceImpl: Batch fetch SchemeInOut records in processSchemeOut
- SmartCartService: Added minusOpeningStockBatch method for batch updates
- TagListingRepository: Added selectByItemIds batch method
- FofoOpeningStockRepository: Added findByFofoIdAndCatalogIds batch method
- PendingOrderItemRepository: Added selectByIds batch method

Performance improvement: ~70-100 DB queries reduced per order (10 items avg)		  
34972 247 d 21 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ donotcommit  
34938 253 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ smart cart service method updated  
34461 385 d 21 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ recomeneded qty logic updated  
34459 385 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ recomeneded qty logic updated  
34449 387 d 0 h ranu /trunk/ code commit for suggested po  
34384 401 d 22 h ranu /trunk/ additional point in annalysis model  
33873 575 d 14 h ranu /trunk/ smart cart first phase updated