| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 36910 |
27 d 4 h |
amit |
/trunk/profitmandi-dao/src/main/ |
Internal PO: map created transaction to PO; block warehouse change for PO-mapped orders
- WarehousePurchaseOrder: add transactionId column + selectByTransactionId
- createOrderInternally returns txn id; createPurchaseOrder maps it onto the PO
- Block order.setWarehouseId for PO-mapped orders in changeFulfillmentWarehouse; cron moveOrders skips them
- Migration: add warehouse.purchaseorder.transactionId |
|
| 36568 |
66 d 1 h |
amit |
/trunk/ |
refactor: RTV - add local caching, batch queries, typed DTO, fix documentNumber overwrite and settledAmount validation |
|
| 36544 |
66 d 23 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Refactor RTV (Return to Vendor) flow: replace native SQL with repository/service methods, extract reusable helpers (resolvePurchase, resolveLineItem, markItemReturned, createPurchaseReturnEntity), fix availability bug by adding saholicInventoryService.reduceAvailability, validate returnability by currentQuantity>0 instead of lastScanType |
|
| 36318 |
91 d 20 h |
aman |
/trunk/ |
Fix:Migrate legacy Purchase Return flow (Report + Bulk Create + Debit Notes) into FOFO |
|
| 36316 |
91 d 21 h |
aman |
/trunk/ |
Fix:Migrate legacy Purchase Return flow (Report + Bulk Create + Debit Notes) into FOFO |
|
| 36309 |
92 d 15 h |
amit |
/trunk/profitmandi-dao/src/main/ |
Route phantom orders to per-region Dummy warehouse; complete applyColorChange rename
- Phantom allocations in getFulfillments route to the Dummy/GOOD/OURS warehouse under
vendor 40 for the partner's billing region. WarehouseServiceImpl.ensureDummyForBillingRegion
returns the existing Dummy or creates one on the fly. createVendorWarehouse hook auto-seeds
a Dummy when a new billing region's first warehouse is created.
- WarehouseRepository.selectByVendorBillingAndType supports the lookup.
- OrderService interface: rename notifyColorChange -> applyColorChange to match r36305's impl
rename (r36305 renamed only the impl, leaving trunk inconsistent).
- PurchaseOrderServiceImpl: remove auto-rebalance on PO receive. Real-wh rebalancing and
phantom-to-real binding are now ops-driven via the order billing UI
(changeFulfillmentWarehouse / applyColorChange / moveOrdersFulfilmentWarehouse).
- migration_dummy_warehouses.sql: idempotent seeding script for 14 Dummy/GOOD/OURS warehouses
under vendor 40, one per WAREHOUSE_MAP billing region that lacked one. Already applied to
hadb1 and local. |
|
| 36169 |
109 d 21 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/warehouse/ |
Fix NonUniqueResult for duplicate serial numbers: use latest inventory entry for refurbished items |
|
| 36100 |
114 d 12 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fix margin invoice: resolve GRN purchaseId to PO id for purchase price lookup, rename selectByPurchaseIdItemId to selectByPurchaseOrderIdItemId |
|
| 36016 |
124 d 23 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Optimize UI GRN flow: batch duplicate IMEI check and eliminate redundant DB calls
- Add selectActiveSerialNumbers batch query to check all IMEIs in 1 call instead of N
- Cache supplierWarehouse per PO (1 query per PO instead of per IMEI)
- Pass pre-loaded Item and InventoryWarehouse to addInventoryItem, skip re-fetching
- Add overloaded addInventoryItem(item, supplierWarehouse) to WarehouseService |
|
| 36014 |
124 d 23 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Add duplicate IMEI check at V2 GRN using exists query
- Add existsActiveInventoryItemBySerialNumber to WarehouseInventoryItemRepository
Uses COUNT query to avoid NonUniqueResultException on duplicate serials
- Block GRN when serial number already exists with currentQuantity > 0 |
|
| 35805 |
151 d 19 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Add GRN correction feature: entity, repository, service with serial/qty correction logic. Fix purchaseId/poId mismatch, selectByItemId PK bug, add invoice validation, create missing inventory records, reorder approval status |
|
| 35577 |
183 d 0 h |
aman |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
Feat:add item ID in Aging Stock List: Items that are 4 days old or older report. |
|
| 35051 |
304 d 6 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
Update |
|
| 34317 |
489 d 3 h |
amit.gupta |
/trunk/ |
commit for scheme related changes |
|
| 34240 |
509 d 4 h |
tejus.lohani |
/trunk/ |
10 days aged report and fix pur sale ratio grand data |
|
| 34230 |
514 d 20 h |
tejus.lohani |
/trunk/ |
pur-sale graph report fix |
|
| 34180 |
529 d 20 h |
ranu |
/trunk/ |
warehouse stock table added column according to shankar sir |
|
| 34018 |
598 d 4 h |
tejus.lohani |
/trunk/ |
purchase sele ratio further detail like model aging , on the click of catalog chart click |
|
| 34013 |
599 d 3 h |
tejus.lohani |
/trunk/ |
purchase sele ratio chart data fix |
|
| 34009 |
600 d 4 h |
tejus.lohani |
/trunk/ |
now fetch pur-sale ratio report on the change of period also |
|