Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35651 168 d 5 h aman /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Fix:Item Wise monthly sale and fofo opening stock minus condition  
35493 209 d 0 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 316 d 6 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ donotcommit  
34938 322 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ smart cart service method updated  
34461 454 d 5 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ recomeneded qty logic updated  
34459 454 d 6 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ recomeneded qty logic updated  
34449 455 d 8 h ranu /trunk/ code commit for suggested po  
34384 470 d 6 h ranu /trunk/ additional point in annalysis model  
33873 643 d 22 h ranu /trunk/ smart cart first phase updated