Subversion Repositories SmartDukaan

Rev

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

Filtering Options

Rev Age Author Path Log message Diff
35947 137 d 8 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Revert r35945: undo cart pessimistic locking (will re-apply after testing)  
35945 137 d 10 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Add pessimistic locking to cart operations to prevent deadlocks; add updateCartItem, removeCartItem, getCartItems methods  
35690 162 d 14 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Optimize order creation performance: add overloaded focusedModelShortageValidation with pre-fetched data, add overloaded payThroughWallet and processTransaction to avoid duplicate fetches, fix N+1 queries in BulkOrderService by batch-fetching items and tagListings  
35574 183 d 19 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fix price mismatch false positives in cart validation

- Handle cart price = 0/unset: silently update to current price (client bug)
- Use tolerance comparison (0.01) instead of exact Float.compare
- Prevents false PRICE_CHANGED errors from float precision issues
 
35573 183 d 20 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Feature: Add price mismatch detection in cart

- Detect when cart item price differs from current TagListing price
- Notify user with PRICE_CHANGED message showing old vs new price
- Auto-update cart line with current price
- Add logging for price mismatch events
 
35493 208 d 22 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 278 d 3 h vikas /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ App build Version & Notification Template  
35211 279 d 2 h vikas /trunk/ App build Version & Notification Template  
35170 284 d 2 h vikas /trunk/ Carry bag 1 rupee to NEW, GOLD, PLATINUM, DIAMOND  
35140 287 d 6 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ in transit add in instock  
33244 822 d 8 h ranu /trunk/ add signature added profitmandi exception  
33172 843 d 5 h tejus.lohani /trunk/ add bulk order service in admin dashboard  
32588 994 d 3 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed cart  
32585 994 d 7 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Changed quantity to 400  
32493 1026 d 8 h amit.gupta /trunk/ Added changes related to auto order creation when internal po is created  
31792 1202 d 7 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Fixed Item qty bug  
31783 1203 d 2 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed net availability to SaholicCIS Table  
31781 1203 d 4 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ Fixed net availability to SaholicCIS Table  
31773 1205 d 1 h amit.gupta /trunk/ Fixed net availability to SaholicCIS Table  
31326 1310 d 1 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed Availablity logic  
30836 1433 d 3 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ change  
29497 1727 d 8 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/  
29404 1746 d 23 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/  
29327 1755 d 10 h tejbeer /trunk/ change  
29261 1766 d 0 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/  
28653 1827 d 9 h amit.gupta /trunk/ Added Changes to order creation  
28170 1931 d 9 h tejbeer /trunk/  
28166 1932 d 4 h tejbeer /trunk/ chnage  
26522 2294 d 3 h amit.gupta /trunk/