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
35496 203 d 3 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ given laptop in category  
35495 207 d 16 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 16 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 16 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 20 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ givemn fin service access to alok  
35491 207 d 23 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ out of stock allocation  
35490 208 d 19 h ranu /trunk/ given brandwise placement acesseries qty instead of value  
35489 208 d 21 h aman /trunk/ Fix:Trial Activation Mail  
35488 208 d 23 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/ place ment plan page show catalog status wise  
35487 208 d 23 h ranu /trunk/ place ment plan page show catalog status wise  
35486 209 d 2 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Listing Error: List should not be empty  
35485 209 d 4 h aman /trunk/ Fix:Trial Add required to assign asm and bm in trial form and also add tarun sir in bcc  
35484 209 d 20 h ranu /trunk/profitmandi-fofo/src/main/ in brnd wise placement showed qty instead of stock value as per tarun sir  
35483 210 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Default null partnerType to Rising Star (PartnerType.NEW) in PartnerDetailModel.getPartnerType()  
35482 210 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Default null partnerType to Rising Star (PartnerType.NEW) in getAllStatePartnerType  
35481 210 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fix NPE in getAllStatePartnerType - add null checks for PartnerDetailModel and partnerType  
35480 210 d 0 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fix NPE in getWarehousePartners when warehouseId=0 and show all partner stats; add stack trace logging to GlobalExceptionHandler  
35479 210 d 13 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ Optimize Aging.SoldAgingModel query and fix column mapping

- Changed DATEDIFF(NOW(), inv.invoiceDate) > 15 to sargable condition
- Fixed trailing spaces in column names (SLOWMOVING_Billed, RUNNING_Billed, etc.)
- Enables index usage on invoiceDate column

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>		  
35478 210 d 13 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ Fix Aging.15DaysOurStock query - remove invalid p.warehouseId column

- Removed po.warehouseId = p.warehouseId (purchase table has no warehouseId)
- The warehouseId match is already handled in ii2 join: ii2.physicalWarehouseId = po.warehouseId
- Verified results match original query exactly

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>		  
35477 210 d 13 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ Fix FASTMOVING column name trailing space in SqlResultSetMapping

- Removed trailing space from "FASTMOVING " to "FASTMOVING"
- This was causing SQLGrammarException: could not extract ResultSet

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>		  

←Prev12Next→

Show All