Subversion Repositories SmartDukaan

Rev

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

Filtering Options

Rev Age Author Path Log message Diff
36470 9 d 21 h ranu /trunk/ code commit for reports section v2  
36327 23 d 3 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix currentinventorysnapshot/currentreservationsnapshot deadlock and optimize getFirstBillingDate

- SaholicInventoryServiceImpl: enforce reservation-snapshot → inventory-snapshot
lock order in addReservationCount and reduceReservationCount via explicit
session.flush(); eliminates the hadb1 deadlock recorded 2026-04-20 19:43:24
between these two methods' opposite-order writes.
- SaholicInventorySnapshot: add @DynamicUpdate so UPDATEs only rewrite the
changed column instead of all three — cuts redo/binlog write amplification
and makes deadlock dumps pinpoint the actual business path.
- TransactionRepositoryImpl.getFirstBillingDate: replace filesort-over-all-billed-
orders with MIN(billingTimestamp) via new Order.selectFirstBillingByRetailer
named query (Select tables optimized away). Preserves 2017-01-01 cutoff and
null-for-unbilled-partner semantics.
- Add @Cacheable on redisOneDayCacheManager keyed by fofoId (unless null) so the
8 call sites stop piling up identical SELECTs on the order table — this was
the query pinning Hikari slots at 150-460s each in recent processlist dumps.		  
35631 103 d 4 h ranu /trunk/ code commit for calling target  
35490 141 d 21 h ranu /trunk/ given brandwise placement acesseries qty instead of value  
35475 143 d 15 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Optimize selectTodayOrdersRBM: Replace derived table subquery with direct JOINs - 33x faster (78s -> 2.3s)  
35474 143 d 16 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Optimize selectTodayOrders query: Replace OR with UNION ALL to avoid sort_union operation for today_po endpoint  
35473 143 d 16 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Optimize selectTodayOrdersRBM query: Replace OR with UNION ALL to avoid sort_union operation and improve query performance  
35172 214 d 23 h ranu /trunk/ billed po action download option done  
35155 217 d 16 h ranu /trunk/ get quote from backend  
35154 217 d 21 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ get quote from backend  
35153 217 d 21 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ bm wise filter in today po  
35147 218 d 21 h ranu /trunk/ bm wise filter in today po  
34849 285 d 21 h ranu /trunk/ logger added  
34813 296 d 23 h aman /trunk/ Partner Dashboard Analysis  
34754 311 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ method update  
34741 316 d 21 h ranu /trunk/ bi report correction  
34738 317 d 21 h ranu /trunk/ bi report correction  
34721 321 d 0 h ranu /trunk/ bi report correction  
34715 321 d 22 h ranu /trunk/ bi report some correction  
34641 345 d 2 h ranu /trunk/ bi report completed first commit  
34584 359 d 3 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Removed delivery timestamp check  
33947 541 d 1 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ mtd and today target data query correction  
33944 541 d 5 h ranu /trunk/ mtd and today target data query correction  
33873 575 d 16 h ranu /trunk/ smart cart first phase updated  
33823 591 d 5 h amit.gupta /trunk/ Fixed changes related to sort issue  
33805 596 d 0 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Addeed retailer count  
33801 596 d 1 h amit.gupta /trunk/ Addeed retailer count  
33791 597 d 19 h amit.gupta /trunk/ Added rbm wise Performance  
33464 692 d 4 h ranu /trunk/ poco billing mail shoot daily category team  
33443 700 d 1 h ranu /trunk/ print resource and order cancel by partner and cron dao mail shoot for Live Demo  
33430 709 d 22 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Fixed Order quantity availability  
33429 709 d 22 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Fixed Order quantity availability  
33396 721 d 23 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed warehouse related bugs  
33202 764 d 7 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Fixed invoices  
33199 765 d 2 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Previous purchases  
33189 767 d 7 h amit.gupta /trunk/ Fixed logic when pricedrops are reported late  
33145 783 d 1 h tejus.lohani /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ add some fields in rprice_drop_report for fetch and Download  
33052 800 d 8 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/ Added jacket number fields  
32478 965 d 18 h amit.gupta /trunk/ Fixed logic for Monitor  
32445 971 d 18 h amit.gupta /trunk/ Added new monitor