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
35625 180 d 1 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:getpartner error handling  
35618 181 d 23 h amit /trunk/ Fix: Apply visibility filter only for CRM users in viewRecentTickets

- Reverted named query visibility filter (was filtering all users)
- Added role-based filtering in viewRecentTickets and viewRecentTickets/{fofoId}
- CRM users: Filter by visible subcategory names
- Sales/RBM/ABM users: See all tickets without filtering		  
35617 181 d 23 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 0 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Revert ticket visibility changes from TicketChatActivityController  
35614 182 d 0 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 21 h amit /trunk/profitmandi-web/ Add HikariCP dependency for connection pooling  
35596 182 d 21 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 16 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 4 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ Shopify Apis: Sync Products and Orders  
35504 211 d 5 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35500 212 d 0 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Gst Validation  
35494 216 d 19 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 2 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ out of stock allocation  
35486 218 d 5 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Listing Error: List should not be empty  
35469 219 d 22 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Leads Follow ups  
35467 219 d 23 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 22 h amit /trunk/ Revert non-Java file changes from r35458  
35458 220 d 22 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 220 d 23 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fixed method thats not readonly  
35455 221 d 1 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/ order controller @Transaction roll back for current  

←Prev12Next→

Show All