Subversion Repositories SmartDukaan

Rev

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

Filtering Options

Rev Age Author Path Log message Diff
37592 25 d 2 h amit /trunk/profitmandi-dao/src/main/ Fix live-demo deduction lost in the investment snapshot; maintain aged-Apple qty

BUG FIX to r37588. InventoryService.getTotalAmountInStock() returns stock net of
live-demo units held past 90 days, and both original investment paths assigned
that netted value to inStockAmount - which is why
PartnerDailyInvestment.getTotalInvestment() carries no separate demo term. The
sweep stored the RAW snapshot sum and never applied the deduction, overstating
investment for 328 partners by Rs 5.19 crore and their limits by roughly Rs 1.3
crore. Maxwell validated clean earlier only because he holds no demo stock.

Fixed by storing what is measured and deriving what is computed: the column is
now in_stock_gross_amount and getNetInStockAmount() applies the haircut. The demo
holding moves on its own daily clock, so storing the netted figure would have
meant re-netting it in three places every time the haircut changed - the same
'two things must move together' trap behind the original cache bug. Deriving it
means a daily demo refresh flows through to stock and base with nothing to sync.

Also:
- aged_apple_qty stored on the snapshot and maintained on the same daily cycle as
aged_apple_stock_amount, so the partner banner reads a saved count instead of
running a count query per dashboard load, and count and value can never disagree
- selectPartnerStockCountMap mirrors selectPartnerStockValueMap, including the
activated exclusion
- selectAgedAppleStock lists the units behind the haircut for the partner view
- FofoUser exposes aged_apple_stock / aged_apple_qty
- stock-moved detection compares GROSS: a demo unit crossing 90 days changes net
stock but nothing physically moved, and that is the daily refresh's job

Schema: partner_investment_snapshot.sql updated (in_stock_gross_amount,
aged_apple_qty). Applied to prod - the table was empty, so it was dropped and
recreated from the script.
 
35942 215 d 3 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Reduce log noise: demote verbose INFO to DEBUG, fix empty list SQLGrammarException in getItemAvailability, fix copy-paste bug in PartnerTypeChangeServiceImpl, fix string concatenation in log statements  
35848 223 d 6 h amit /trunk/ Refactor investment logic to use own investment (total - utilized), remove minimumInvestmentOld, add OK_INVESTMENT_SHORT_PERCENTAGE constant, update thresholds CUTOFF_INVESTMENT=10 MIN_INVESTMENT_PERCENTAGE=5  
35600 251 d 10 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix Redis serialization bug and add 15-min cache manager

- Fix SerializationException for publishedOffersWithAchievement cache
- Add @JsonIgnore to computed getters getBillingStartDate/getBillingEndDate
- Add @JsonIgnoreProperties(ignoreUnknown=true) to CreateOfferRequest,
ItemCriteriaPayout, TargetSlab for backward compatibility with cached data

- Add redisVeryShortCacheManager (15 min TTL) for frequently changing data
- brandStockPrices, partnerInvestments, partnerSales, partnerDailyInvestment
now use 15-min cache instead of 60-min
 
35595 252 d 0 h amit /trunk/profitmandi-dao/ Migrate from C3P0 to HikariCP connection pooling

- Replace C3P0 properties with HikariCP settings in all properties files
- Delete unused persistence.xml (was not referenced by any code)
- New settings: maximumPoolSize=20, minimumIdle=2, idleTimeout=30s, maxLifetime=30min
 
35285 326 d 10 h aman /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fix:Money Value formatter fix  
35084 375 d 6 h aman /trunk/ Fix: Diplay currency name , fix brandwise item sale and montly sale table ui fix  
35064 377 d 2 h aman /trunk/ Feat:BrandwiseSale and brandWise Item wise sale and live scratch offer  
34685 472 d 5 h aman.kumar /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fix the amount difference for lmtd  
34527 518 d 7 h tejus.lohani /trunk/ hdfc payment report and investometer in partner dashboard  
34466 530 d 6 h tejus.lohani /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ fix  
34463 530 d 9 h tejus.lohani /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ barchart modification  
34426 539 d 4 h tejus.lohani /trunk/ some enhancement in partner dashboard barchart  
34388 546 d 2 h tejus.lohani /trunk/ partner DashBoard model wise barchart with some extra filter , dateRange and value ad quantity , on click bar , open new model wise barchart , that is show detailed chart with sale ,active and unactive models  
33245 899 d 8 h ranu /trunk/ added signature  
33127 929 d 11 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed brands to display method  
33121 932 d 3 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ patch for  
33119 932 d 4 h amit.gupta /trunk/ Fixed Offer  
33087 938 d 2 h amit.gupta /trunk/ Added changes to stop payouts for samsung stock aged above 90 days since primary.  
31884 1253 d 6 h tejbeer /trunk/ change  

Show All