| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 37805 |
8 d 0 h |
amit |
/trunk/profitmandi-dao/src/main/ |
fix(catalog): trim f_ colour prefix space; age delisted listings from last activation
- Item.normalizeColor drops the space after f_ on every write (upload sheets typed
'f_ Black', which read ' Black' everywhere); ItemLoaderService uses it so the
duplicate-colour check compares the clean value
- tag_listing.last_activated, stamped by TagListing.setActive on off->on;
updateActiveById now goes through the entity (+flush) so the toggle stamps it
- delist cron + SQL script age a listing from GREATEST(start_date, last_activated),
so a re-activated listing is not delisted again the next morning
- migrations: add_tag_listing_last_activated_20260929.sql, fix_item_color_prefix_space_20260929.sql
(both applied on hadb1 2026-09-29; 174 items trimmed, 36830 excluded - clashes with 37089) |
|
| 37782 |
11 d 14 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
fix(catalog): add serializedOnly overloads of selectAllItems/selectAllBrands
r37776 committed InventoryServiceImpl calling the 3-arg selectAllItems and
selectAllBrands, but the repository overloads and the named-query parameters
they bind were left uncommitted, so a build from trunk failed.
serializedOnly = true restricts the model/brand pickers to IMEI items; the
2-arg forms delegate with false, unchanged behaviour. |
|
| 37563 |
27 d 2 h |
amit |
/trunk/profitmandi-dao/src/main/ |
Filter delisted SKUs out of creation pickers; add rolling 24m delist migration
Creation screens could offer items whose catalog.tag_listing.active = 0:
- Item.selectAllModels (scheme/offer model dropdown) joined tag_listing with
no active predicate. Adding tl.active = true also gives the model-level
rollup, since callers dedupe to catalogItemId: a model whose colours are
all inactive now yields no rows, one keeping a listed colour stays.
- The shared partner item picker had no active filter at all. Added a second
basis via getAllPartnerItemStringDescription(anyColor, activeOnly);
activeOnly participates in the fofoItems cache key so the two bases cannot
serve each other's cached results. Default stays false for screens that
inspect or edit existing records.
- New TagListing.selectActiveItemIds named query backs the filter.
Also adds the rolling 24-month delist migration: zero stock both sides, no
outstanding vendor PO (status IN (1,2), external supplier, unfulfilled > 0 --
INIT is excluded as it is a drawer of stale drafts), and re-categorises
fully-dark mobile models to OTHER. Idempotent, audited, rollback documented. |
|
| 37204 |
63 d 16 h |
amit |
/trunk/profitmandi-dao/src/ |
external api v2: category spec + client category entities, cached category exposure, title util, item.brand_identifier, ContentPojo categoryId/categorySpecs |
|
| 37149 |
71 d 14 h |
amit |
/trunk/profitmandi-dao/src/main/ |
External partner API (dao): api_client/api_client_store auth tables + entities, store-scoped feed queries (ExternalFeedRepository), ApiClientAuthService + ExternalApiService, update_timestamp delta-sync columns on tag_listing/item/catalog/current_inventory_snapshot (migration_external_api_client.sql), Mongo siteContent lastModified stamp + paged reads. Prices exposed are mop/mrp only. |
|
| 37071 |
85 d 10 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Normalize whitespace on Catalog/Item setters + ItemLoaderService bulk upload (T9.5 sanitizer) |
|
| 35870 |
221 d 12 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ |
Trim whitespace and NBSP in setModelName and setModelNumber |
|
| 35869 |
221 d 13 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ |
Trim whitespace and NBSP in Item.setColor to prevent color filter mismatch |
|
| 35169 |
361 d 11 h |
aman |
/trunk/ |
FIx: Date time formatter fix in scheme-imei-history |
|
| 33183 |
914 d 9 h |
shampa |
/trunk/ |
show all vendors data report without select any particular vendor. Add download csv file. |
|
| 32417 |
1120 d 12 h |
amit.gupta |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fixed front end related issues with add/remove row |
|
| 32230 |
1169 d 12 h |
amit.gupta |
/trunk/ |
Added focused model in item |
|
| 31846 |
1264 d 13 h |
tejbeer |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ |
|
|
| 31821 |
1268 d 18 h |
amit.gupta |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ |
Fixed in case of mrp missing |
|
| 31773 |
1282 d 8 h |
amit.gupta |
/trunk/ |
Fixed net availability to SaholicCIS Table |
|
| 31767 |
1286 d 12 h |
amit.gupta |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ |
Fixed net availability to SaholicCIS Table |
|
| 31065 |
1450 d 12 h |
tejbeer |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
change |
|
| 30499 |
1594 d 16 h |
amit.gupta |
/trunk/ |
Fixed category |
|
| 30492 |
1595 d 8 h |
amit.gupta |
/trunk/ |
Added Category option |
|
| 30121 |
1676 d 13 h |
amit.gupta |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fixed scheme issue |
|