Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36743 51 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ Surface internally-sourced serialized stock in warehouse billing

Removed the su.internal=0 filter from the imeisToSecondaryForWarehouseBilling
named query. The query's intent is to find whatever serialized stock is
physically present in the billing warehouse and report its original ageing;
the supplier filter was wrongly excluding units whose original purchase came
from an internal/group supplier (e.g. inter-warehouse transfers), making real
available stock invisible to billing and forcing the UI into a quantity-input
fallback instead of the IMEI picker.

Ageing ordering is preserved: AgeingService dedups by serial keeping the
earliest invoice date, so transferred stock still ages from its original
external purchase. Only 4 internal-only serial units exist network-wide;
those now age from their internal invoice (their only origin).		  
36581 64 d 14 h amit /trunk/ Add rootInvoiceDate to inventoryItem and ageing columns to snapshot, with 30-min cron refresh  
36464 77 d 17 h amit /trunk/ Add vendor pricing changes Excel download report on Vendor Price Circular page. Flat file with Vendor/Date/Model/CatalogId/TP/DP/MOP columns, filterable by vendor. Shows baseline pricing as of start date plus subsequent TP changes within period for all non-internal suppliers.  
36327 90 d 16 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix currentinventorysnapshot/currentreservationsnapshot deadlock and optimize getFirstBillingDate

- SaholicInventoryServiceImpl: enforce reservation-snapshot → inventory-snapshot
lock order in addReservationCount and reduceReservationCount via explicit
session.flush(); eliminates the hadb1 deadlock recorded 2026-04-20 19:43:24
between these two methods' opposite-order writes.
- SaholicInventorySnapshot: add @DynamicUpdate so UPDATEs only rewrite the
changed column instead of all three — cuts redo/binlog write amplification
and makes deadlock dumps pinpoint the actual business path.
- TransactionRepositoryImpl.getFirstBillingDate: replace filesort-over-all-billed-
orders with MIN(billingTimestamp) via new Order.selectFirstBillingByRetailer
named query (Select tables optimized away). Preserves 2017-01-01 cutoff and
null-for-unbilled-partner semantics.
- Add @Cacheable on redisOneDayCacheManager keyed by fofoId (unless null) so the
8 call sites stop piling up identical SELECTs on the order table — this was
the query pinning Hikari slots at 150-460s each in recent processlist dumps.		  
35845 145 d 18 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ intrasit stock do correct  
35784 152 d 17 h vikas /trunk/ Sync Inventory to Shopify products and Inventory with Insurance Plans  
35744 159 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ Fix batch vendor pricing query: add effected_on date filter to both subqueries to match per-item query behavior  
35351 224 d 14 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/ fix openinng stock  
35343 228 d 13 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ removing all out of stock and without category catalog from price circular and b2b listing (solr)  
34813 364 d 12 h aman /trunk/ Partner Dashboard Analysis  
34615 419 d 14 h vikas.jangra /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/ Added tablet category in queries  
34580 427 d 15 h ranu /trunk/ intrasist data modification  
34569 431 d 11 h ranu /trunk/ love intransist data for brandwise placement  
34405 466 d 14 h vikas.jangra /trunk/ Liquidation/Bidding CURD Operation  
34389 468 d 10 h ranu /trunk/ code committed as per tarun sir  
34387 468 d 11 h vikas.jangra /trunk/ Liquidation/Bidding initial work  
34178 529 d 13 h ranu /trunk/ color changes on warehouse stock  
34098 560 d 16 h ranu /trunk/ eol-slow, slow-runn migartion  
34068 578 d 7 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ warehouse invoice migration  
34035 591 d 12 h ranu /trunk/ aging and smart cart instead of focused model  

←Prev12Next→

Show All