Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35511 201 d 2 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/ Fixed method Number to comma for Cr. Values  
35510 201 d 2 h amit /trunk/profitmandi-fofo/src/main/webapp/resources/js/ Fixed method Number to comma for Cr. Values  
35509 201 d 2 h amit /trunk/ Add manual partner type upgrade support with source tracking

- Add PartnerTypeSource enum (CALCULATED, MANUAL)
- Add source and upgradedBy fields to PartnerTypeChange entity
- Manual upgrades now backdated to 1st of month for full month effect
- Fix repository queries to use id DESC as tie-breaker (MySQL 5.7 compatible)
- Track who performed manual upgrade via upgradedBy field		  
35508 201 d 3 h ranu /trunk/ lead repo done  
35507 201 d 3 h ranu /trunk/ lead repo done  
35506 202 d 4 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ Shopify Apis: Sync Products and Orders  
35505 202 d 5 h ranu /trunk/profitmandi-fofo/src/main/ today offer modal done  
35504 202 d 5 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35503 202 d 5 h vikas /trunk/ Shopify : Orders  
35502 202 d 5 h ranu /trunk/profitmandi-fofo/src/main/ today offer modal done  
35501 202 d 6 h ranu /trunk/ today offer modal done  
35500 203 d 0 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Gst Validation  
35499 203 d 0 h aman /trunk/ Fix:Trial Activation Mail, All trial user page and gst validation  
35498 203 d 2 h ranu /trunk/profitmandi-fofo/src/main/webapp/resources/js/ Laptop show on offer  
35497 203 d 3 h ranu /trunk/profitmandi-fofo/src/main/ Laptop show on offer  
35496 203 d 6 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ given laptop in category  
35495 207 d 19 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fresh money allowance feature for B2B orders with overdue loans

- SDCreditServiceImpl: Added validateOverdueLoans() to check if partner can place order
- SDCreditServiceImpl: Added getAvailableFreshMoney() to calculate same-day fresh money
- SDCreditServiceImpl: Partners with overdue loans can now place orders using fresh money added same day
- OrderRepository: Added selectTodayOrdersExcludingRefund() for fresh money calculation
- UserWalletHistoryRepository: Added methods to get today's payments and refunds

Logic: Fresh money = (Today's PAYMENT_GATEWAY + AUTOMATED_ADVANCE deposits) - (Today's orders excluding refunded) + (Today's refunds)		  
35494 207 d 19 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ N+1 query optimization for B2B order creation flow

- OrderController: Pre-fetch items and tagListings before cart line loop
- OrderController: Reuse brand stock data for both limit checks (3 queries instead of 6)

Performance improvement: ~20-30 DB queries reduced per order		  
35493 207 d 19 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)		  
35492 207 d 23 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ givemn fin service access to alok  

←Prev12Next→

Show All