Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36291 26 d 16 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 11 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 9 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 9 h ranu /trunk/ rbm called detail now coming from call log not by remark  
35759 90 d 8 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35757 90 d 10 h ranu /trunk/ rbm calls date wise filter given  
35679 95 d 11 h ranu /trunk/ calling webhook updated  
35654 98 d 17 h ranu /trunk/ code commit for calling target / retailer contact  
35631 102 d 16 h ranu /trunk/ code commit for calling target  
35394 148 d 3 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Improved performance  
35117 219 d 18 h vikas /trunk/ Oppo Diwali Rewards Haryana  
34835 286 d 9 h vikas /trunk/ Added Export Report, And Update total distance  
34780 307 d 13 h vikas.jangra /trunk/ Location Tracking - Saprated CheckIN CheckOut/Punch In Punch Out API  
34769 308 d 9 h vikas.jangra /trunk/ Location Tracking - Calculate distance and ETA for Admin App and call option  
34723 320 d 9 h vikas.jangra /trunk/ Location Tracking - Calculate distance for Admin App  
34678 327 d 17 h vikas.jangra /trunk/ Location Tracking for Admin App  
34658 336 d 11 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ knowlarity api updation on sip_url  
33248 753 d 15 h ranu /trunk/ exception added  
33247 753 d 15 h ranu /trunk/ warehouse billing phase one and added signature exception  
33210 762 d 11 h ranu /trunk/ method change auth by gmail to email and last resolution message updated on chat history  

←Prev12Next→

Show All