Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36291 27 d 1 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/ Optimize slow DB queries: split fan-out join, FORCE INDEX on wallet history

- CurrentInventorySnapshotRepositoryImpl.getSpilitStockBatch: split
LEFT-JOIN fan-out into two independent aggregates (~8x faster);
fixes SUM(DISTINCT) undercounting bug where same availability/qty
values across items collapsed into one.
- UserWalletRepositoryImpl.getWarehousewiseCollection: HQL -> native
SQL with FORCE INDEX(idx_uwh_wallet_timestamp) so timestamp range
filters at index level instead of row filter (~4x faster, 3.1s -> 722ms).
- PartnerCollectionPlanRepositoryImpl.getCommitmentCollectionSummary:
Criteria 3-Root CROSS JOIN -> explicit INNER JOIN + FORCE INDEX
(idx_uwh_wallet_timestamp) (~3.5x faster).		  
36018 56 d 19 h amit /trunk/profitmandi-dao/ Add Knowlarity live call monitoring - WebSocket client, auth, agent resolver, event processing. Maps CC-Agent-Number/CC-SR-Number to sip_master for agent identification. Added authId to SipMaster entity, selectBySipUrl and selectAll to SipRepository. Added Tyrus WebSocket client dependency.  
35780 85 d 18 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Remove unused AuthUserPartnerMapping entity and repository - dead code replaced by Position-based partner mapping  
35765 89 d 18 h ranu /trunk/ rbm called detail now coming from call log not by remark  
35759 90 d 17 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35757 90 d 19 h ranu /trunk/ rbm calls date wise filter given  
35679 95 d 20 h ranu /trunk/ calling webhook updated  
35654 99 d 2 h ranu /trunk/ code commit for calling target / retailer contact  
35631 103 d 1 h ranu /trunk/ code commit for calling target  
35394 148 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Improved performance  
35117 220 d 2 h vikas /trunk/ Oppo Diwali Rewards Haryana  
34835 286 d 18 h vikas /trunk/ Added Export Report, And Update total distance  
34780 307 d 22 h vikas.jangra /trunk/ Location Tracking - Saprated CheckIN CheckOut/Punch In Punch Out API  
34769 308 d 18 h vikas.jangra /trunk/ Location Tracking - Calculate distance and ETA for Admin App and call option  
34723 320 d 18 h vikas.jangra /trunk/ Location Tracking - Calculate distance for Admin App  
34678 328 d 2 h vikas.jangra /trunk/ Location Tracking for Admin App  
34658 336 d 20 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ knowlarity api updation on sip_url  
33248 754 d 0 h ranu /trunk/ exception added  
33247 754 d 0 h ranu /trunk/ warehouse billing phase one and added signature exception  
33210 762 d 20 h ranu /trunk/ method change auth by gmail to email and last resolution message updated on chat history  

←Prev12Next→

Show All