WebSVN RSS feed – SmartDukaanWed, 07 Oct 2026 19:40:48 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2F20261001_hr_gurugram_vendor_warehouses.sql&max=40& Thu, 01 Oct 2026 21:06:34 +0530amit<div><strong>amit – 24 file(s) modified</strong><br/>feat(warehouse): physical warehouse setup service, supplier mapping PO guard, address active flag<br /> <br /> - WarehouseSetupService + WarehouseSetupValidator: create seller (state from GSTIN,<br /> unique label/GSTIN), address master (city stored last, 6-digit pin, contact),<br /> physical warehouse (OURS/BAD vendor 40 + Dummy/G + sellerwarehouse + mapping in<br /> one transaction), activate/deactivate (sellerwarehouse.is_active), remap address<br /> with internal store sync. Limits follow column sizes (sql_mode is empty).<br /> - WarehouseAddressMaster.active: only active addresses are offered for assignment.<br /> Migration sql/20261001_warehouseaddressmaster_active.sql (applied on hadb1).<br /> - PO guard: createPurchaseOrder refuses a supplier with no OURS/GOOD vendor<br /> warehouse at the destination (GRN could never receive it).<br /> InventoryWarehouseRepository.hasGoodSupplierWarehouse / selectSupplierIdsWithGoodWarehouse<br /> use existence checks; 67 pairs carry duplicate OURS/GOOD rows.<br /> - SellerService.syncInternalStoreAddress(store); RetailerServiceImpl syncs an<br /> INTERNAL store's address when it moves warehouse or becomes internal.<br /> - Record of 2026-10-01 HR Gurugram setup SQL (seller 21, warehouses 13368/13370/13372).<br /> - Tests: WarehouseSetupValidatorTest (10), WarehouseSetupServiceImplTest (7).</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/WarehouseAddressMaster.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/warehouse/NewPhysicalWarehouseRequest.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/warehouse/NewSellerRequest.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/warehouse/NewWarehouseAddressRequest.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/warehouse/PhysicalWarehouseView.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/warehouse/WarehouseAddressView.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/inventory/InventoryWarehouseRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/inventory/InventoryWarehouseRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/WarehouseAddressMappingRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/WarehouseAddressMappingRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/SellerService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/SellerServiceImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/RetailerServiceImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PurchaseOrderService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PurchaseOrderServiceImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/WarehouseSetupService.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/WarehouseSetupServiceImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/WarehouseSetupValidator.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/20261001_delete_hrgn1715_hr_uk_store.sql<br />+ /trunk/profitmandi-dao/src/main/resources/sql/20261001_hr_gurugram_vendor_warehouses.sql<br />+ /trunk/profitmandi-dao/src/main/resources/sql/20261001_hr_gurugram_virtual_warehouses.sql<br />+ /trunk/profitmandi-dao/src/main/resources/sql/20261001_warehouseaddressmaster_active.sql<br />+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/warehouse/WarehouseSetupServiceImplTest.java<br />+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/warehouse/WarehouseSetupValidatorTest.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2F20261001_hr_gurugram_vendor_warehouses.sql&rev=37822https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2F20261001_hr_gurugram_vendor_warehouses.sql&rev=37822