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
37804 8 d 23 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 132 d 6 h ranu /trunk/ beat plan info commit  
36439 159 d 11 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 180 d 4 h aman /trunk/ Fix:Attachment is Full-stock payment approval ,Timeline ui graphical summary, wod initianl mail after store code creation  
35961 214 d 10 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 224 d 8 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 290 d 19 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 315 d 8 h amit /trunk/ Fixed changes regarding to FofoStore having expired field now ignored  
35301 322 d 5 h amit /trunk/ Fixed minimum investment logic  
35297 323 d 5 h amit /trunk/ Added logic to handle retailer  
35289 326 d 14 h amit /trunk/ Added trial franchisee feature  
35284 327 d 22 h aman /trunk/ Fix:Monthly acceories sale  
35079 376 d 11 h vikas /trunk/ Live Tracking and Shopify Products List Sync  
33124 932 d 8 h ranu /trunk/ area territory for fofo store(phase one)  
32615 1064 d 6 h raveendra.bharati /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Ensured that new store code will always have next code number  
32308 1158 d 2 h amit.gupta /trunk/ Added  
31730 1299 d 5 h tejbeer /trunk/ change  
31682 1311 d 6 h amit.gupta /trunk/ Added Not Yet billed  
31681 1311 d 6 h amit.gupta /trunk/ Added Not Yet Billed State  
30279 1644 d 5 h tejbeer /trunk/ change  

Show All