Subversion Repositories SmartDukaan

Rev

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

Filtering Options

Rev Age Author Path Log message Diff
37609 24 d 14 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Offer the stock a warehouse actually holds when ordering from an internal supplier

The purchase order item picker listed whatever the supplier had vendor catalog pricing rows
for. For an outside vendor that is right - the order is for stock nobody holds yet, so their
catalogue is the only sensible list. For one of our own warehouses it is not: a movement can
only send stock that is standing there, and the pricing rows were never a statement about
stock. Vendor 275 was offering 6,845 items while Noida held 79; Delhi 6,637 against 330.

It also made the picker depend on data the movement no longer needs. Pricing for internal
suppliers is derived from the stock itself since r37603, so those rows are inert - but
clearing them emptied the picker completely, because selectVendorItems joins
VendorCatalogPricing to Item and an internal supplier then matched nothing.

Internal suppliers now list distinct items with currentQuantity > 0 in their mapped
warehouse. External suppliers are untouched and still list from vendor catalog pricing.
 
36309 170 d 8 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.
 
36016 202 d 16 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
 
33384 871 d 17 h amit.gupta /trunk/ Fixed Bad scan types  
33247 899 d 18 h ranu /trunk/ warehouse billing phase one and added signature exception  
33239 900 d 19 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed changes related to warehouse management  
32194 1184 d 15 h tejbeer /trunk/ change  
30826 1512 d 22 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Added bulk grn logic  
28493 1935 d 16 h tejbeer /trunk/