Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35719 8 h 38 m amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/ Fix performance issues and email bug in PurchaseOrderServiceImpl

- createPurchaseOrder: batch item loading (selectByIds) and vendor pricing (getVendorPricesOnDate) instead of per-item DB calls; remove duplicate itemIds computation
- grnPoModels: batch load all items upfront instead of selectById per GRN model in nested loop
- generatePdf: fix bug where supplier email recipients were never assigned (Arrays.asList result was discarded)		  
35718 9 h 30 m amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35717 9 h 47 m amit /trunk/ Fix performance issues in PurchaseOrderController

- Replace supplierRepository.selectAll() with targeted selectBySupplierIds() in 2 endpoints
- Replace sellerRepository.selectAll() with new selectByIds() in 2 endpoints
- Add SellerRepository.selectByIds(List<Integer>) batch method
- Remove dead code: unused totalUnitPrice and totalPriceOfLineItem computations		  
35716 9 h 50 m amit /trunk/ Refactor GrnController and PurchaseOrderController: extract business logic into focused services and fix N+1 query performance issues

- Create InvoiceService: invoice item CRUD, validation, vendor price matching
- Create GrnRequestService: GRN request lifecycle, mismatch resolution state machine
- Create DebitNoteService: debit note generation, PDF model building
- Move PO amendment logic from PurchaseOrderController to PurchaseOrderService
- Delegate generateDebitNote from PurchaseOrderServiceImpl to DebitNoteService
- Thin GrnController from ~1215 to ~717 lines, remove 15 unused autowired dependencies
- Thin PurchaseOrderController editPurchaseOrder from 40+ lines to 3 lines

Performance fixes:
- InvoiceServiceImpl.validateInvoiceDetail: batch item/vendor pricing/GST loading (4N+3 queries -> ~5)
- DebitNoteServiceImpl: batch item loading in buildDebitNotePdfModel and generateDebitNote
- GrnController.generateDebitNote: eliminate 2 redundant DB fetches
- Replace 3x supplierRepository.selectAll() with targeted selectBySupplierIds()		  
35715 13 h 52 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/integrations/smartping/model/ code commit for calling target / retailer contact  
35714 14 h 12 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35713 14 h 28 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35712 14 h 34 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35711 14 h 42 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35710 14 h 52 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ code commit for calling target / retailer contact  
35709 15 h 2 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35708 15 h 5 m ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ now recording also fetching  
35707 15 h 9 m amit /trunk/Crm/src/main/webapp/WEB-INF/content/ fix: make refund amount field editable in return order view  
35706 15 h 17 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35705 15 h 25 m amit /trunk/PyProj/src/ Include resource files (cfg, xml, xls) in egg build via package_data  
35704 15 h 31 m amit /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ Fixed SchemeService  
35703 15 h 36 m ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35702 15 h 37 m ranu /trunk/ now recording also fetching  
35701 16 h 47 m amit /trunk/PyProj/src/ Performance fix: reduce logging level to WARNING, remove incompatible pool_pre_ping, fix tornado dependency

- Changed logging.basicConfig from DEBUG to WARNING in 6 service files to stop
SQLAlchemy query spam that caused memory bloat (TransactionServer 553MB -> 63MB)
- Set echoOn=False as default in PurchaseServiceHandler
- Removed pool_pre_ping=True from 7 DataService files (incompatible with SQLAlchemy 0.6.6)
- Updated tornado dependency from 1.0.1 to 1.0 in setup.py (1.0.1 unavailable on PyPI)		  
35700 18 h 5 m amit /trunk/WarehouseService/src/main/ Prevent duplicate sale returns by matching inventory item to specific order  

←Prev12Next→

Show All