Subversion Repositories SmartDukaan

Rev

Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
37089 5 d 6 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ Optimize partnerPerformance data access: fofoId-scoped + month-bucketed query variants

- Order: fofoId-scoped billing-avg named queries (replace all-partner scan+filter)
- MonthlyTarget: selectByDatesAndFofoId batches 7 per-month lookups into one
- SchemeInOut/OfferPayout: month-bucketed ...ByMonth earnings queries collapsing the
per-month loop; new MonthlyBrandIncomeModel / MonthlyOfferPayoutModel
All additive; existing shared queries and their callers unchanged.		  
36525 68 d 8 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ code committed for scheme and offers earning for v2  
36508 70 d 19 h ranu /trunk/ code committed for scheme and offers earning for v2  
36489 73 d 3 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/ Fix NULL handling in CN query NOT clause — reject/rollback IS NOT NULL guard prevents SQL three-valued logic from excluding valid rows  
36485 73 d 6 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/ Fix credit note queries: exclude same-period create+reject rows, replace BETWEEN with >= <= for performance, fix AND/OR precedence bug in SchemeInOut  
36184 106 d 7 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix Credit Note IRN generation for monthly margins

- Add hsnCode to InventoryMarginModel, update 3 named queries to select ii.hsnCode
- Group CN items by taxRate+HSN, set hsnCode on CustomOrderItem
- Add getGenIrnRequest/getItemList overloads in GstProService for credit notes
- Fix IndexOutOfBoundsException from orders-items mismatch in generateCreditNoteIrn
- Wrap fofo and vendor loops in try-catch so one CN failure does not abort the process
- Send summary email with failure details to amit.gupta and ranu.rajput		  
34256 503 d 10 h ranu /trunk/ hid live and cn attachement part live  
33459 759 d 1 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed changes regarding credit issue  
32234 1090 d 1 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ Fixed additional scheme logic  
31860 1177 d 6 h tejbeer /trunk/ change  
31382 1294 d 7 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ F  
31380 1294 d 7 h amit.gupta /trunk/ Added income calculator  
31352 1299 d 10 h amit.gupta /trunk/ Added booster margin/ additional margins  
31139 1348 d 2 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ Fixed  
31134 1350 d 0 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ Fixed  
31008 1382 d 0 h amit.gupta /trunk/ Added CreditNote changes  
30996 1386 d 6 h amit.gupta /trunk/ Fixed commit  
30652 1486 d 4 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Added sellin margin payout