Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35617 182 d 1 h amit /trunk/ Filter invisible subcategory tickets for CRM and end users only

- CRM users: Cannot see tickets with visibility=0 subcategories
- Sales/RBM/ABM users: Can see all tickets (no filtering)
- End users in web module: CRM users filtered, others see all
- Uses getTicketSubCategoryMap() for efficient batch lookup
- Named query filters by tbc.visibility=true for recent tickets		  
35615 182 d 2 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Revert ticket visibility changes from TicketChatActivityController  
35614 182 d 2 h amit /trunk/ Hide RBM and Sales escalation tickets from end user ticket view

- Filter out subcategory IDs 83 (RBM_L2_ESCALATION) and 84 (SALES_ESCALATION) in viewTickets endpoints
- Update selectRecentClosedTicket named query to exclude these escalation types		  
35599 182 d 22 h amit /trunk/profitmandi-web/ Add HikariCP dependency for connection pooling  
35596 182 d 23 h amit /trunk/profitmandi-web/src/main/ Migrate from C3P0 to HikariCP connection pooling

- Update WebDBContextConfigure to use HikariDataSource instead of DriverManagerDataSource
- Replace C3P0 properties with HikariCP settings
- New settings: maximumPoolSize=20, minimumIdle=2, idleTimeout=30s, maxLifetime=30min		  
35575 191 d 17 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ Return full CartResponse on cart validation failure

- Return cartValidationResponse instead of generic CART_CHANGED error
- Allows app to display specific price change messages to user		  
35506 211 d 5 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ Shopify Apis: Sync Products and Orders  
35504 211 d 7 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35500 212 d 2 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Gst Validation  
35494 216 d 21 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ N+1 query optimization for B2B order creation flow

- OrderController: Pre-fetch items and tagListings before cart line loop
- OrderController: Reuse brand stock data for both limit checks (3 queries instead of 6)

Performance improvement: ~20-30 DB queries reduced per order		  
35491 217 d 4 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ out of stock allocation  
35486 218 d 7 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Listing Error: List should not be empty  
35469 220 d 0 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Leads Follow ups  
35467 220 d 1 h amit /trunk/ Optimize /lead-description endpoint

- Add null check for authUser to prevent NPE
- Move visitRequests query inside followUp block
- Move Comparator outside loop
- Rewrite selectLeadsScheduledBetweenDate using Criteria API with Predicates
- Single query joins Lead + LeadActivity with filters in DB
- Remove in-memory filtering of assignTo		  
35459 220 d 23 h amit /trunk/ Revert non-Java file changes from r35458  
35458 221 d 0 h amit /trunk/ Revert @Transactional(readOnly=true) - keep @Transactional only at Controller level

Changes:
- profitmandi-web: Controllers use @Transactional(rollbackFor = Throwable.class) at class level, removed method-level @Transactional(readOnly = true)
- profitmandi-fofo: Controllers use @Transactional(rollbackFor = Throwable.class) at class level, removed method-level @Transactional
- profitmandi-dao: Removed @Transactional from services/repositories

Exceptions (called from interceptors, need own transaction):
- RoleManager: @Transactional(readOnly = true) - called from interceptor for auth
- PartnerTypeChangeServiceImpl.getBestPartner(): @Transactional - called from JWTUtil via interceptor

Fixed javax.transaction.Transactional to org.springframework.transaction.annotation.Transactional
Fixed rollbackOn to rollbackFor for Spring compatibility		  
35456 221 d 0 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fixed method thats not readonly  
35455 221 d 3 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ order controller @Transaction roll back for current  
35448 221 d 21 h amit /trunk/profitmandi-web/src/main/resources/META-INF/ Add missing think.walnut.digital.recharge.balance.url property to all environments  
35435 222 d 8 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Add @Transactional(readOnly = true) to GET methods in controllers

Added @Transactional(readOnly = true) to all read-only GET methods across 14 controllers:
- RetailerController (10 methods)
- UserController (16 methods)
- WalletController (5 methods)
- CartController (2 methods)
- StoreController (25 methods)
- DealsController (20 methods)
- ShopController (1 method)
- CustomerController (2 methods)
- NotificationController (3 methods)
- SolrSearchController (2 methods)
- InsuranceController (1 method)
- GatewayController (1 method)
- LeadController (13 methods)
- RechargeController (4 methods)

Total: 105 methods updated

All methods verified to only set @Transient fields on entities, ensuring no dirty writes.		  

←Prev12Next→

Show All