| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 37850 |
3 d 2 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) |
|
| 37634 |
23 d 4 h |
amit |
/trunk/profitmandi-dao/src/main/ |
feat(pricing): tag_listing price change log; retire vendoritempricing writes/reads in dao; price drops no longer touch vendor catalog pricing
- New catalog.tag_listing_price_log (sql/create_tag_listing_price_log_20260915.sql, applied on prod 2026-09-15) + TagListingPriceService: the single setter for tag_listing DP/MOP/MRP, logging old/new values, source and user
- Remove applyPriceDrop (r37622): price drops write only price_drop + tag_listing; sql/revert_price_drop_vendor_catalog_pricing_20260915.sql restores the 30 rows it wrote (run on prod)
- VendorCatalogPricingService: reference TP = latest approved external TP (single + batched); internal suppliers rejected on create, bulk upload and approval
- Stop copying pricing into vendoritempricing on approval and item upload; tag listing detail TP from reference TP; indent DP from tag_listing only |
|
| 37601 |
26 d 7 h |
amit |
/trunk/profitmandi-dao/src/main/ |
Remove dead stock-ageing fields rootInvoiceDate and oldest/newest_invoice_date
rootInvoiceDate on WarehouseInventoryItem had no writer anywhere in the codebase and
was read only by ScheduledTasks.refreshSnapshotAgeing(), which therefore matched zero
rows on every 30-minute run. oldest/newest_invoice_date on SaholicInventorySnapshot
were written only by that task and read by nothing. Verified on prod: null on all
1,528,669 inventoryItem rows and all 11,686 snapshot rows respectively.
Stock ageing that is actually in use resolves the original external supplier at query
time by serialNumber + supplier.internal = false, and does not read these columns.
originalInventoryItemId is deliberately left alone - it is populated on 157,020 rows.
Includes sql/drop_dead_ageing_columns_20260912.sql to drop the columns. Run it only
after web, fofo and cron are all on this build. |
|
| 37500 |
37 d 5 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
sales target and achievement added cron and flags |
|
| 37499 |
37 d 6 h |
ranu |
/trunk/ |
sales target and achievement added cron and flags |
|
| 37375 |
49 d 2 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
total show on warehouse wise stock value on item detail |
|
| 36743 |
131 d 4 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ |
Surface internally-sourced serialized stock in warehouse billing
Removed the su.internal=0 filter from the imeisToSecondaryForWarehouseBilling
named query. The query's intent is to find whatever serialized stock is
physically present in the billing warehouse and report its original ageing;
the supplier filter was wrongly excluding units whose original purchase came
from an internal/group supplier (e.g. inter-warehouse transfers), making real
available stock invisible to billing and forcing the UI into a quantity-input
fallback instead of the IMEI picker.
Ageing ordering is preserved: AgeingService dedups by serial keeping the
earliest invoice date, so transferred stock still ages from its original
external purchase. Only 4 internal-only serial units exist network-wide;
those now age from their internal invoice (their only origin). |
|
| 36581 |
144 d 6 h |
amit |
/trunk/ |
Add rootInvoiceDate to inventoryItem and ageing columns to snapshot, with 30-min cron refresh |
|
| 36464 |
157 d 9 h |
amit |
/trunk/ |
Add vendor pricing changes Excel download report on Vendor Price Circular page. Flat file with Vendor/Date/Model/CatalogId/TP/DP/MOP columns, filterable by vendor. Shows baseline pricing as of start date plus subsequent TP changes within period for all non-internal suppliers. |
|
| 36327 |
170 d 8 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fix currentinventorysnapshot/currentreservationsnapshot deadlock and optimize getFirstBillingDate
- SaholicInventoryServiceImpl: enforce reservation-snapshot → inventory-snapshot
lock order in addReservationCount and reduceReservationCount via explicit
session.flush(); eliminates the hadb1 deadlock recorded 2026-04-20 19:43:24
between these two methods' opposite-order writes.
- SaholicInventorySnapshot: add @DynamicUpdate so UPDATEs only rewrite the
changed column instead of all three — cuts redo/binlog write amplification
and makes deadlock dumps pinpoint the actual business path.
- TransactionRepositoryImpl.getFirstBillingDate: replace filesort-over-all-billed-
orders with MIN(billingTimestamp) via new Order.selectFirstBillingByRetailer
named query (Select tables optimized away). Preserves 2017-01-01 cutoff and
null-for-unbilled-partner semantics.
- Add @Cacheable on redisOneDayCacheManager keyed by fofoId (unless null) so the
8 call sites stop piling up identical SELECTs on the order table — this was
the query pinning Hikari slots at 150-460s each in recent processlist dumps. |
|
| 35845 |
225 d 10 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ |
intrasit stock do correct |
|
| 35784 |
232 d 9 h |
vikas |
/trunk/ |
Sync Inventory to Shopify products and Inventory with Insurance Plans |
|
| 35744 |
239 d 3 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ |
Fix batch vendor pricing query: add effected_on date filter to both subqueries to match per-item query behavior |
|
| 35351 |
304 d 6 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ |
fix openinng stock |
|
| 35343 |
308 d 5 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
removing all out of stock and without category catalog from price circular and b2b listing (solr) |
|
| 34813 |
444 d 4 h |
aman |
/trunk/ |
Partner Dashboard Analysis |
|
| 34615 |
499 d 6 h |
vikas.jangra |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/ |
Added tablet category in queries |
|
| 34580 |
507 d 7 h |
ranu |
/trunk/ |
intrasist data modification |
|
| 34569 |
511 d 3 h |
ranu |
/trunk/ |
love intransist data for brandwise placement |
|
| 34405 |
546 d 6 h |
vikas.jangra |
/trunk/ |
Liquidation/Bidding CURD Operation |
|