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
35493 289 d 10 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)		  
35214 358 d 14 h vikas /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ App build Version & Notification Template  
35211 359 d 13 h vikas /trunk/ App build Version & Notification Template  
35170 364 d 13 h vikas /trunk/ Carry bag 1 rupee to NEW, GOLD, PLATINUM, DIAMOND  
35140 367 d 17 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ in transit add in instock  
33244 902 d 19 h ranu /trunk/ add signature added profitmandi exception  
33172 923 d 17 h tejus.lohani /trunk/ add bulk order service in admin dashboard  
32588 1074 d 14 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed cart  
32585 1074 d 18 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Changed quantity to 400  
32493 1106 d 19 h amit.gupta /trunk/ Added changes related to auto order creation when internal po is created  
31792 1282 d 18 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Fixed Item qty bug  
31783 1283 d 13 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed net availability to SaholicCIS Table  
31781 1283 d 15 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed net availability to SaholicCIS Table  
31773 1285 d 12 h amit.gupta /trunk/ Fixed net availability to SaholicCIS Table  
31326 1390 d 12 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed Availablity logic  
30836 1513 d 14 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ change  
29497 1807 d 19 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/  
29404 1827 d 10 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/  
29327 1835 d 21 h tejbeer /trunk/ change  
29261 1846 d 11 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/  

←Prev12Next→

Show All