Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java – Rev 35493

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

Filtering Options

From rev	To rev	Max revs

Search history for

Show All

Rev	Age	Author	Path	Log message	Diff	Changes
35493	140 d 7 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)		/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/CartServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepositoryImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepositoryImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PendingOrderItemRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PendingOrderItemRepositoryImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/OrderServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/SchemeServiceImpl.java
34449	386 d 15 h	ranu	/trunk/	code commit for suggested po		/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/po-catalog-items.vm /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/PartnerStockDescriptionModel.java /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/SuggestedPoCatalogModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartServiceImpl.java /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock-detail.vm /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm /trunk/profitmandi-fofo/src/main/webapp/resources/js/partner-brandwise-detail.js
34384	401 d 13 h	ranu	/trunk/	additional point in annalysis model		/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/DateWiseSoldCatalogQtyModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderRepositoryImpl.java /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock-detail.vm /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm
33873	575 d 5 h	ranu	/trunk/	smart cart first phase updated		/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOpeningStock.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerOpeningStockByTodayModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PoAndGrnPendingPartnerStockModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/SoldAllCatalogitemQtyByPartnerModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/SoldFocusedItemPartnerWiseModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepositoryImpl.java /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/SmartCartController.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/FocusedModel.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/CurrentInventorySnapshot.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepository.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepositoryImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/OrderServiceImpl.java /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/TransactionServiceImpl.java /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/DealsController.java /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/services/SolrService.java