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
35633 179 d 3 h amit /trunk/ Add hikari.keepaliveTime property to all environment configs  
35632 179 d 3 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ call target related changes  
35630 179 d 21 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Error handling  
35626 179 d 22 h amit /trunk/ Ticket system: add unread tracking, pagination, search, and partner notifications  
35625 179 d 22 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:getpartner error handling  
35618 181 d 20 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 21 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 181 d 21 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Revert ticket visibility changes from TicketChatActivityController  
35614 181 d 21 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 18 h amit /trunk/profitmandi-web/ Add HikariCP dependency for connection pooling  
35596 182 d 18 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 13 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 1 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ Shopify Apis: Sync Products and Orders  
35504 211 d 2 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35500 211 d 21 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Gst Validation  
35494 216 d 17 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 0 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ out of stock allocation  
35486 218 d 2 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Listing Error: List should not be empty  
35469 219 d 19 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Leads Follow ups  
35467 219 d 20 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		  

←Prev12Next→

Show All