Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35717 162 d 11 h 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 162 d 11 h 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 162 d 15 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/integrations/smartping/model/ code commit for calling target / retailer contact  
35714 162 d 15 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35713 162 d 15 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35712 162 d 16 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35711 162 d 16 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35710 162 d 16 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ code commit for calling target / retailer contact  
35709 162 d 16 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35708 162 d 16 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ now recording also fetching  
35707 162 d 16 h amit /trunk/Crm/src/main/webapp/WEB-INF/content/ fix: make refund amount field editable in return order view  
35706 162 d 16 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35705 162 d 16 h amit /trunk/PyProj/src/ Include resource files (cfg, xml, xls) in egg build via package_data  
35704 162 d 17 h amit /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ Fixed SchemeService  
35703 162 d 17 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ code commit for calling target / retailer contact  
35702 162 d 17 h ranu /trunk/ now recording also fetching  
35701 162 d 18 h 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 162 d 19 h amit /trunk/WarehouseService/src/main/ Prevent duplicate sale returns by matching inventory item to specific order  
35699 162 d 19 h amit /trunk/HotspotDashboard/ Upgrade EHCache from 2.4.4 to 3.10.6  
35698 162 d 19 h amit /trunk/Crm/src/main/webapp/WEB-INF/content/ Remove replacement option from returns, make refund amount read-only  

Show All