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
36291 94 d 1 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/ Optimize slow DB queries: split fan-out join, FORCE INDEX on wallet history

- CurrentInventorySnapshotRepositoryImpl.getSpilitStockBatch: split
LEFT-JOIN fan-out into two independent aggregates (~8x faster);
fixes SUM(DISTINCT) undercounting bug where same availability/qty
values across items collapsed into one.
- UserWalletRepositoryImpl.getWarehousewiseCollection: HQL -> native
SQL with FORCE INDEX(idx_uwh_wallet_timestamp) so timestamp range
filters at index level instead of row filter (~4x faster, 3.1s -> 722ms).
- PartnerCollectionPlanRepositoryImpl.getCommitmentCollectionSummary:
Criteria 3-Root CROSS JOIN -> explicit INNER JOIN + FORCE INDEX
(idx_uwh_wallet_timestamp) (~3.5x faster).		  
36290 94 d 1 h aman /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix:Finance code to finance team after code creation  
36289 94 d 1 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ hadb1 perf: add SD_CREDIT_LOCK to prevent deadlock on sd_credit_requirement, sort updatePartnerLimit by fofoId  
36288 94 d 1 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ hadb1 perf: cache firstBillingDate, fix N+1 item query, push eInvoice filter to SQL, sort updateRisk by fofoId  
36287 94 d 18 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ sales dispostion updated  
36286 94 d 18 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ sales dispostion updated  
36285 94 d 18 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Force idx_order_customer_billing index on spilitStock queries — optimizer picks wrong index (978K global scan vs 902 rows per partner)  
36284 94 d 18 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ code optimization of today po rbm page  
36283 94 d 18 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/ uday sing maill added in po approval  
36282 94 d 18 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Optimize /partner/hidAllocation: replace N+1 getSpilitStock loop with batch call, add fofo_id filter to sales subquery, fix DATE() preventing index usage on create_timestamp  
36281 94 d 20 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ Replace retailerBlockBrands with DMS code-based brand eligibility check in OrderController.createOrder - use partnerIneligibleBrands from partner_dealer_mapping instead of retailer_block_brands table  
36280 94 d 20 h aman /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Fix:Contact-us list update  
36279 95 d 2 h amit /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ Fix NPE in PurchaseInvoiceModel when grnDate or invoiceDate is null  
36278 95 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/ ADD OPENING STOCK  
36277 95 d 19 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ unique call and recording will show on dashboard  
36276 95 d 21 h ranu /trunk/ unique call and recording will show on dashboard  
36275 95 d 21 h aman /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Fix:Fix unbilled stock sign  
36274 95 d 22 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Hide Receive/Refund actions on Recent Debit Notes from non-admin partners  
36273 96 d 3 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/warehouse/ Fix app config  
36272 96 d 19 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Add receiveDate to WarehouseSupplierInvoice

Added receiveDate field to warehouse.invoice entity to track when goods
were physically received. Set from PORowModel.getReceivedDate() during
GRN processing in PurchaseOrderServiceImpl.addPORowModels.		  

←Prev12Next→

Show All