Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35453 216 d 6 h amit /trunk/ Optimize /indent/today_po_rbm endpoint - reduce DB queries by ~99%

- Consolidate 5 weekly billing queries into 1 using SQL CASE statements
- Add RbmWeeklyBillingModel for consolidated weekly billing data
- Batch fetch partner collection remarks to avoid N+1 queries
- Batch fetch collection map for all fofoIds to avoid N+1 queries in nested loop
- Reduces ~1160 queries to ~10 queries for 50 RBMs
 
35044 308 d 7 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm targets fix  
34880 347 d 0 h ranu /trunk/ commit drr issue solved  
34870 351 d 1 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ requested hid alloction valid only till created date  
34764 381 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ bi report correction  
34763 381 d 2 h ranu /trunk/ bi report correction  
34716 393 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ bi report correction  
34641 416 d 6 h ranu /trunk/ bi report completed first commit  
34404 470 d 7 h ranu /trunk/ short invest in suummry  
34397 470 d 8 h ranu /trunk/ analysis code committed as per tarun sir  
34289 500 d 8 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ exclude arr dashboard which have monthly target is 0  
34288 501 d 1 h ranu /trunk/ code commit for franchisee visit and rbm ratings  
34286 501 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm arr dashboard log  
34285 501 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ logeer npa  
34284 501 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ logger addede  
34283 501 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm achievement is null  
34282 501 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ logger added for de bugging  
34281 501 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm rating view on arr dashbiard  
34103 563 d 9 h ranu /trunk/ rbm billing count showd arr dashboard  
34098 564 d 7 h ranu /trunk/ eol-slow, slow-runn migartion  

Show All