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
35652 175 d 18 h vikas /trunk/ PineLabs Offer and Create Order  
35650 175 d 23 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ call target related changes  
35649 176 d 1 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ call target related changes  
35633 179 d 0 h amit /trunk/ Add hikari.keepaliveTime property to all environment configs  
35632 179 d 1 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ call target related changes  
35630 179 d 18 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Error handling  
35626 179 d 20 h amit /trunk/ Ticket system: add unread tracking, pagination, search, and partner notifications  
35625 179 d 20 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:getpartner error handling  
35618 181 d 18 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 18 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 19 h amit /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Revert ticket visibility changes from TicketChatActivityController  
35614 181 d 19 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 16 h amit /trunk/profitmandi-web/ Add HikariCP dependency for connection pooling  
35596 182 d 16 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 11 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 210 d 23 h vikas /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ Shopify Apis: Sync Products and Orders  
35504 211 d 0 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35500 211 d 19 h aman /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ Fix:Gst Validation  
35494 216 d 14 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 216 d 21 h ranu /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ out of stock allocation  

←Prev12Next→

Show All