Subversion Repositories SmartDukaan

Rev

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

Filtering Options

Rev Age Author Path Log message Diff
37850 1 d 6 h amit /trunk/profitmandi-dao/src/main/ refactor(warehouse): retire hardcoded Delhi ids - allocation fallback vendor warehouse 7573 -> 13368 (central HR-NSSPL/GGN); Vivo Noida/Ghaziabad partner-sale rule 7573 -> 13370; drop unused InventoryWarehouse WH_DL/WH_HR_DL/WAREHOUSE_IDS; migration 20261005_hr_ggn_central_brand_mapping.sql (13368 central for every ACTIVE warehouse, all brands except Oppo/Vivo, 532 rows, applied on hadb1)  
37804 8 d 2 h amit /trunk/profitmandi-dao/src/main/ fix(fofo-store): store every GSTIN in upper case at the entity setter

FofoStore.setGstNumber now normalises through StringUtils.normalizeGstNumber,
so no write path can store a mixed-case GSTIN. Only the partner-update path
normalised before; the LOI and trial-form paths wrote the field directly,
which is how 06bmlpk3545g1z0 and 03AAccn9802g1zp reached the table. NIC
expects upper case, and case-sensitive comparisons (including the own-seller
GSTIN check behind a NIC refusal) silently failed to match.

uppercase_fofo_store_gstin_20260928.sql corrects the four rows already on
record; it is already applied on hadb1 (0 mixed-case GSTINs remain).
 
36727 131 d 9 h ranu /trunk/ beat plan info commit  
36439 158 d 14 h amit /trunk/profitmandi-dao/src/main/ Add outlet_name field to FofoStore entity, set from address.name on store creation

Adds outlet_name (VARCHAR 255) to FofoStore entity so the store's display
name is persisted directly on fofo_store instead of requiring a join through
retailer_registered_address -> address every time it is needed.

Sets fofoStore.setOutletName(retailerAddress.getName()) in both creation
paths: RetailerServiceImpl.createFofoStoreCodeByRetailerId (primary) and
RetailerController.createFofoStore (secondary).

Includes migration SQL script (migration_outlet_name_to_fofo_store.sql) to
ALTER TABLE and backfill existing rows from address.name. Must be run during
low-traffic window - fofo_store is heavily queried and ALTER takes a metadata
lock that blocks all concurrent SELECTs.
 
36242 179 d 6 h aman /trunk/ Fix:Attachment is Full-stock payment approval ,Timeline ui graphical summary, wod initianl mail after store code creation  
35961 213 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ Add closed state to FofoStore - permanent store closure with store code confirmation. Closed stores cannot be reactivated.  
35848 223 d 10 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  
35463 289 d 22 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Optimize /getMobileBrandWise and /getMobileLMSGraph queries

- Replace concat(year(), month()) pattern with date range comparisons
- Enables index usage on create_timestamp and activation_timestamp columns
- Update repository methods to pass date range parameters instead of string patterns
 
35323 314 d 10 h amit /trunk/ Fixed changes regarding to FofoStore having expired field now ignored  
35301 321 d 7 h amit /trunk/ Fixed minimum investment logic  
35297 322 d 8 h amit /trunk/ Added logic to handle retailer  
35289 325 d 16 h amit /trunk/ Added trial franchisee feature  
35284 327 d 1 h aman /trunk/ Fix:Monthly acceories sale  
35079 375 d 13 h vikas /trunk/ Live Tracking and Shopify Products List Sync  
33124 931 d 10 h ranu /trunk/ area territory for fofo store(phase one)  
32615 1063 d 9 h raveendra.bharati /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Ensured that new store code will always have next code number  
32308 1157 d 4 h amit.gupta /trunk/ Added  
31730 1298 d 8 h tejbeer /trunk/ change  
31682 1310 d 8 h amit.gupta /trunk/ Added Not Yet billed  
31681 1310 d 9 h amit.gupta /trunk/ Added Not Yet Billed State  

Show All