feat: enhance authentication and routing with constants; add sidebar configurations for KIR and LUCY

User description

feat: enhance authentication and routing with constants; add sidebar configurations for KIR and LUCY

---

PR Type

Enhancement

---

Description

• Authentication System: Added comprehensive authentication with NextAuth.js, supporting both Azure AD and email/password credentials with bcrypt hashing and database integration • Database Infrastructure: Implemented complete Prisma schema with SQL Server support, Azure Key Vault integration for connection strings, and client factory pattern • API Framework: Created standardized API response utilities, dynamic database table routes, and Prisma context middleware for consistent server-side operations • Logging System: Built comprehensive logging infrastructure with Winston logger, custom database transport, and multiple log levels • UI Components: Enhanced existing components (Table, Badge, Modal, BottomSheet) and added new ones (AlertDialog, TooltipText improvements) with better theming and mobile responsiveness • KIR Application Features: Added complete return policy management with return types, product categorization, and policy mapping functionality including CRUD operations • LUCY Application: Created contact management system with API endpoints and store integration • Routing & Navigation: Expanded route paths for both KIR and LUCY applications with updated sidebar configurations • Constants & Configuration: Organized UI constants, error messages, API headers, and authentication constants for better maintainability • Mobile Support: Enhanced mobile responsiveness across components with BottomSheet integration and responsive layouts

---

Diagram Walkthrough

flowchart LR
  Auth["Authentication System"] --> DB["Database Infrastructure"]
  Auth --> API["API Framework"]
  DB --> Logging["Logging System"]
  API --> KIR["KIR Features"]
  API --> LUCY["LUCY Features"]
  KIR --> ReturnPolicy["Return Policy Management"]
  KIR --> LogsPage["Enhanced Logs Page"]
  LUCY --> Contacts["Contact Management"]
  UI["UI Components"] --> KIR
  UI --> LUCY
  Constants["Constants & Config"] --> UI
  Mobile["Mobile Support"] --> UI

File Walkthrough

	Relevant files
Enhancement	79 files logsData.ts Update logs data structure and content for new schema        src/utils/data/logsData.ts • Updated log entries to use new schema with logLevel instead of exceptionType • Changed application names to KIR, NetSuite, and BigCommerce • Updated stack traces to use JavaScript/TypeScript format instead of C# • Modified exception messages to reflect actual application operations +77/-57  ui.ts Expand UI constants for enhanced user interface elements  src/utils/constants/ui.ts • Added new action buttons: ADD, UPDATE, MANAGE_MAPPINGS, ADD_PRODUCT_CATEGORIZATION, ADD_RETURN_TYPE • Added dropdown options for log level, application, code, and value selection • Updated search placeholder text and added new UI constants for logs, stack trace, and copy functionality • Added text input configurations and modal labels for various operations +73/-3    route.ts Enhance authentication with credentials provider and database integration src/app/api/auth/[...nextauth]/route.ts • Added credentials provider for email/password authentication alongside Azure AD • Implemented bcrypt password hashing and Prisma database integration • Added session callbacks for JWT token handling and user ID management • Enhanced authentication with proper error handling and session configuration +90/-6    useContactStore.ts Add contact store for state management                                      src/store/useContactStore.ts • Created new Zustand store for contact management • Implemented fetchContacts function with API integration • Added loading states, error handling, and proper headers for API requests +96/-0    kirSidebarConfigs.ts Update KIR sidebar configuration with routing paths            src/utils/data/kirSidebarConfigs.ts • Updated sidebar configuration to use route paths instead of onClick handlers • Added proper routing paths for KIR application sections • Reorganized imports and updated icon assignments for better consistency +16/-27  apiResponse.ts Add standardized API response utility class                            src/server/utils/apiResponse.ts • Created comprehensive API response utility class with standardized error handling • Implemented static methods for common HTTP responses (ok, fail, badRequest, notFound, etc.) • Added NextResponse integration for consistent API responses +71/-0    returnTypeResponse.ts Add return type response mock data                                              src/utils/data/returnTypeResponse.ts • Added mock data structure for return type responses • Implemented return type details with proper typing and sample data +35/-1    productCategorizationResponse.ts Add product categorization response mock data                        src/utils/data/productCategorizationResponse.ts • Added mock data structure for product categorization responses • Implemented product categorization details with proper typing and sample data +38/-1    route.ts Add dynamic database table API route                                          src/app/api/config/[table]/route.ts • Created dynamic API route for database table queries • Implemented GET and POST methods with PrismaClientFactory integration • Added SQL Server syntax support with proper error handling +50/-0    loggerService.ts Add comprehensive logging service utility                                src/server/utils/loggerService.ts • Created logging service with multiple log levels (error, warning, info, debug) • Integrated with Winston logger and added proper metadata handling • Implemented consistent logging interface across the application +63/-0    returnTypesMappingDetails.ts Add return type mapping details data structure                      src/utils/data/returnTypesMappingDetails.ts • Added return type mapping details with categorization data • Implemented mapping structure for return types with associated product categories +33/-1    withPrismaContext.ts Add Prisma context middleware for database operations        src/server/middleware/withPrismaContext.ts • Created middleware for Prisma database context handling • Added header validation for application, environment, and storefront context • Implemented proper error handling and response formatting +39/-0    DbTransport.ts Add database transport for Winston logging                              src/server/infrastructure/logging/transports/DbTransport.ts • Created custom Winston transport for database logging • Implemented log entry insertion into configPortalLogs table • Added proper error handling for database operations +39/-0    PrismaClientFactory.ts Add Prisma client factory with Key Vault integration          src/server/infrastructure/db/PrismaClientFactory.ts • Created factory pattern for Prisma client management • Implemented Azure Key Vault integration for connection strings • Added support for multiple database contexts and global client access +30/-0    route-paths.ts Expand route paths for KIR and LUCY applications                  src/utils/constants/route-paths.ts • Added HOME route and expanded KIR and LUCY application routes • Added specific routes for roles, privileges, return status, and other KIR features • Added account mapping route for LUCY application +10/-0    app.ts Add UI constants and standardized error messages                  src/utils/constants/app.ts • Added LogLevel and BadgeColors constants for UI components • Added ERRORS constant with standardized error messages • Removed DROPDOWN_CONFIGS in favor of more specific constants +19/-5    messages.ts Add server-side error message constants                                    src/server/utils/constants/messages.ts • Added comprehensive error message constants for server operations • Organized messages by category (COMMON, FAILED_TO_FETCH, DB) +23/-0    lucySidebarConfigs.ts Add LUCY sidebar configuration                                                      src/utils/data/lucySidebarConfigs.ts • Created sidebar configuration for LUCY application • Added roles, account mapping, and loggers navigation items with proper routing +25/-1    LoggerResponse.ts Update logger response model structure                                      src/models/response/LoggerResponse.ts • Updated LogDetails interface to use logLevel instead of exceptionType • Made all properties optional except id and customStatusCode • Updated property types for better null handling +12/-14  storefront.profile.ts Add storefront data mapping profile                                            src/server/mapper/profiles/storefront.profile.ts • Created AutoMapper profile for storefront data transformation • Implemented mapping between StorefrontDetailsResponse and StorefrontItem +23/-0    app.ts Refactor position enum and remove width variants                  src/utils/enums/app.ts • Renamed ToolTipPosition to Position enum for broader usage • Removed widthVariants constant (likely moved elsewhere) +2/-10    ReturnTypeResponse.ts Add return type response model definitions                              src/models/response/ReturnTypeResponse.ts • Added comprehensive return type response models • Implemented ReturnTypeDetails and ReturnTypeMappingDetails interfaces • Added product categorization integration +23/-0    route.ts Add LUCY contact API endpoint                                                        src/app/api/lucy/contact/route.ts • Created API endpoint for LUCY contact management • Implemented GET method with Prisma context middleware • Added proper error handling and response formatting +16/-0    keyVaultService.ts Add Azure Key Vault service integration                                    src/server/infrastructure/azure/keyVaultService.ts • Implemented Azure Key Vault service for secure secret retrieval • Added DefaultAzureCredential authentication • Created function to fetch connection strings from Key Vault +15/-0    auth.ts Add authentication error constants                                              src/utils/constants/auth.ts • Added comprehensive authentication error constants • Included specific error messages for various authentication scenarios +11/-0    ProductCategorization.ts Add product categorization response models                              src/models/response/ProductCategorization.ts • Added product categorization response models • Implemented ProductCategorizationDetails and ProductCategorization interfaces • Added support for return window days and active status +21/-0    productCategorization.ts Add product categorization mock data                                          src/utils/data/productCategorization.ts • Added mock product categorization data with return window days • Implemented sample data for Hardware, Refurb/K2G Keys, and OEM parts +7/-1      prismaCache.ts Add Prisma client caching infrastructure                                  src/server/infrastructure/db/prismaCache.ts • Implemented Prisma client caching mechanism • Added connection string-based client management • Created reusable client factory function +16/-0    logger.ts Add Winston logger configuration                                                  src/server/infrastructure/logging/logger.ts • Created Winston logger configuration with custom database transport • Set up JSON formatting and error stack trace handling +11/-0    httpStatusCodes.ts Add HTTP status code constants                                                      src/server/utils/constants/httpStatusCodes.ts • Added comprehensive HTTP status code constants • Organized common status codes for API responses +13/-0    index.ts Add AutoMapper configuration                                                          src/server/mapper/index.ts • Created AutoMapper configuration with classes strategy • Set up mapper instance for data transformations +12/-0    messages.ts Add client-side error message constants                                    src/utils/constants/messages.ts • Added client-side error message constants • Organized common error messages for UI components +7/-0      api.ts Add API header constants                                                                  src/utils/constants/api.ts • Added API header constants for request context • Defined standard headers for storefront, application, and environment +5/-0      api.ts Add server-side API constants                                                        src/server/utils/constants/api.ts • Added server-side API constants for database and common operations • Defined default values for app name and created by fields +8/-0      logLevels.ts Add log level constants                                                                    src/server/utils/constants/logLevels.ts • Added log level constants for consistent logging • Defined standard log levels (debug, error, fatal, warning, information) +7/-0      globals.css Update CSS utilities for layout and animations                      src/app/globals.css • Added viewport height utilities and header/main layout classes • Updated loading animation positioning and scrollbar styling • Added mobile sidebar height utilities +24/-27  page.tsx Enhance KIR logs page with advanced filtering and details view src/app/kir/logs/page.tsx • Enhanced logs page with filtering, search, and view details functionality • Added mobile-responsive filter section and bottom sheet integration • Implemented log details modal and improved table layout with pagination +89/-32  ManageMappings.tsx Add return type and product category mapping management    src/app/kir/return-Policy/components/ManageMappings.tsx • Created comprehensive mapping management component for return types and product categories • Implemented editable return window days with inline editing functionality • Added category selection with visual feedback and validation +212/-0  Playground.tsx Update playground with BottomSheet and loading animations src/components/common/Playground.tsx • Added BottomSheet component integration for mobile UI testing • Updated imports and removed unused StatCard import • Added new loading animation demonstration +41/-27  LogsFilterSection.tsx Add responsive logs filter section with mobile support      src/app/kir/logs/components/LogsFilterSection.tsx • Created comprehensive filter section with mobile-responsive design • Implemented BottomSheet for mobile filters and desktop dropdown filters • Added search, date range, log level, and application filtering capabilities +172/-0  ProductCategorization.tsx Add product categorization management page                              src/app/kir/return-Policy/ProductCategorization.tsx • Created product categorization management page with CRUD operations • Implemented filtering, pagination, and modal dialogs for add/edit/delete • Added search functionality and date range filtering +161/-0  ViewLogDetails.tsx Add detailed log view with copy functionality                        src/app/kir/logs/components/ViewLogDetails.tsx • Created detailed log view component with OffCanvas integration • Implemented copy functionality for stack traces and log properties • Added log level-specific icons and color coding +151/-0  ReturnType.tsx Add return type management page                                                    src/app/kir/return-Policy/ReturnType.tsx • Created return type management page with full CRUD operations • Implemented filtering, search, pagination, and modal dialogs • Added date range filtering and table-based data display +144/-0  OffCanvas.tsx Enhance OffCanvas component with header and external control src/components/shared/OffCanvas.tsx • Enhanced OffCanvas component with header support and improved positioning • Added external control for open/close state and better responsive design • Updated styling and backdrop behavior for better UX +50/-36  Table.tsx Table component enhancements and icon updates                        src/components/shared/Table.tsx • Updated import statements to use Position enum instead of ToolTipPosition • Changed sort icons from ChevronDown/ChevronUp to single DownArrow with rotation • Added tooltipEnabled property to column configuration • Enhanced table styling with hover effects and improved layout +19/-25  ProductPolicyMapping.tsx Add ProductPolicyMapping component for return type management src/app/kir/return-Policy/ProductPolicyMapping.tsx • New React component for managing product policy mappings with return types • Implements state management for return types, selected items, and modal visibility • Includes edit functionality with callback handlers and modal integration • Uses constants from UI_CONSTANTS and HEADING_LABELS for labels and text +95/-0    ConfigDataFetcher.tsx Add ConfigDataFetcher component for API data retrieval      src/components/common/ConfigDataFetcher.tsx • New client-side component for fetching configuration data via API • Implements form inputs for store, application, environment, and table parameters • Makes POST requests to /api/lucy/contact endpoint with form data • Displays fetched data in a dynamic table format with error handling +111/-0  DropDown.tsx Refactor DropDown component with enum-based positioning    src/components/shared/DropDown.tsx • Replaced DROPDOWN_CONFIGS.POSITIONS import with Position enum • Updated position prop type to use Position.TOP | Position.BOTTOM • Added zIndex prop with default value and updated styling classes • Modified search placeholder to use DROPDOWN_SEARCH_PLACEHOLDER constant +9/-7      LogDetailsColumns.tsx Enhance LogDetailsColumns with badges and view actions      src/app/kir/config/table/LogDetailsColumns.tsx • Added onViewDetails callback prop and action column with view button • Integrated Badge component with withBadgeCustomization HOC for log levels • Updated column widths and added themed badges for logLevel and appName • Removed ID column and enhanced visual presentation with icons +42/-23  TooltipText.tsx Refactor TooltipText with enum positioning and styling updates src/components/shared/TooltipText.tsx • Updated position prop to use Position enum instead of string literals • Added showTooltip prop to conditionally enable/disable tooltip display • Changed tooltip styling from tertiary colors to primary gradient • Updated arrow border colors to use primary color variables +16/-9    TextInput.tsx Redesign TextInput component with standard label layout    src/components/shared/TextInput.tsx • Renamed isrequired prop to isRequired for consistency • Added backgroundColor and borderColor props for customization • Completely redesigned layout from floating labels to standard label-above-input • Updated styling with new background colors and focus states +25/-27  UpsertCategorizationModal.tsx Add UpsertCategorizationModal for product categorization management src/app/kir/return-Policy/components/UpsertCategorizationModal.tsx • New modal component for creating/editing product categorization details • Implements form state management with ProductCategorizationDetails model • Uses TextInput components with constants for labels and placeholders • Includes conditional field disabling based on existing data presence +87/-0    UpsertReturnTypeModal.tsx Add UpsertReturnTypeModal for return type management          src/app/kir/return-Policy/components/UpsertReturnTypeModal.tsx • New modal component for creating/editing return type details • Implements form handling with ReturnTypeDetails model structure • Uses standardized UI constants for input labels and placeholders • Includes form validation and conditional field disabling +85/-0    Pagination.tsx Update Pagination component with enum positioning                src/components/shared/Pagination.tsx • Replaced DROPDOWN_CONFIGS.POSITIONS with Position enum import • Updated dropdown positioning to use Position.TOP • Modified styling classes for rounded borders and button padding • Adjusted dropdown width from 8rem to 7rem +8/-7      ProductCategorizationFilter.tsx Add ProductCategorizationFilter component for data filtering src/app/kir/return-Policy/components/ProductCategorizationFilter.tsx • New filter component with search, date range, and dropdown filters • Implements multiple filter states for value, code, search, and date range • Includes "Add Product Categorization" button with callback handler • Uses shared components like SearchBar, DateRangePicker, and Dropdown +85/-0    layout.tsx Simplify Lucy layout by removing sidebar configuration      src/app/lucy/layout.tsx • Removed entire sidebar configuration and layout logic • Simplified to return only the children content without sidebar • Eliminated imports for sidebar components and configuration data +1/-87    StatCard.tsx Update StatCard styling with consistent color theming        src/components/common/StatCard.tsx • Renamed iconColor property to color in borderStyles object • Updated value display styling to use the dynamic color instead of fixed secondary color • Applied consistent color theming across both icon and value elements +8/-8      ReturnTypeFilters.tsx Add ReturnTypeFilters component for return type filtering src/app/kir/return-Policy/components/ReturnTypeFilters.tsx • New filter component specifically for return type data filtering • Implements search, date range, and type dropdown filtering capabilities • Includes "Add Return Type" button with callback functionality • Uses responsive flex layout with proper gap spacing +70/-0    AlertDialog.tsx Add AlertDialog component for user confirmations                  src/components/shared/AlertDialog.tsx • New alert dialog component for confirmation and warning messages • Implements modal overlay with customizable title, content, and action buttons • Includes cancel and submit button handling with callback functions • Uses consistent styling with other modal components +62/-0    Modal.tsx Update Modal component styling and layout improvements      src/components/shared/Modal.tsx • Removed React import (using automatic JSX runtime) • Updated modal width from max-w-md to max-w-lg • Enhanced styling with gradient background for submit button • Adjusted gap spacing and padding for better visual hierarchy +6/-5      Badge.tsx Redesign Badge component with comprehensive theming system src/components/shared/Badge.tsx • Completely redesigned badge component with new theming system • Added support for primary, secondary, tertiary, and quaternary color themes • Implemented filled and outline variants for each theme • Updated styling with proper padding and border radius +27/-12  Toast.tsx Simplify Toast component by removing Button dependency      src/components/shared/Toast.tsx • Removed React import and Button component dependency • Replaced Button with direct Close icon for dismiss functionality • Added text truncation for long descriptions with max-width constraint • Updated close button styling and positioning +14/-12  getProductCategorizationColumns.tsx Add table column configuration for product categorization src/app/kir/return-Policy/config/getProductCategorizationColumns.tsx • New column configuration for product categorization table • Defines columns for ID, NetSuite details, code, name, status, and dates • Includes action column with edit and delete buttons using SVG icons • Implements callback functions for edit and delete operations +70/-0    getReturnTypeDetailsColumns.tsx Add table column configuration for return type details      src/app/kir/return-Policy/config/getReturnTypeDetailsColumns.tsx • New column configuration for return type details table • Defines columns for return type ID, NetSuite details, type code, and value • Includes sortable columns and action buttons for edit/delete operations • Uses consistent styling with other table configurations +65/-0    page.tsx Add main return policy page with tabs and statistics          src/app/kir/return-Policy/page.tsx • New main page component for return policy management • Implements tabbed interface with Return Types, Product Categorization, and Policy Mapping • Includes statistical cards showing return types and product categories counts • Uses StatCard and Tabs components for layout structure +40/-0    Navbar.tsx Enhance Navbar with mobile hamburger menu support                src/components/common/Navbar.tsx • Added hamburger menu support for mobile sidebar toggling • Implemented NavbarProps interface with sidebar toggle callback • Added mobile detection using useIsMobile hook • Updated padding and responsive layout for mobile compatibility +21/-3    withBadgeCustomization.tsx Add withBadgeCustomization HOC for dynamic badge theming  src/components/hoc/withBadgeCustomization.tsx • New Higher-Order Component for badge theming and customization • Implements column-specific badge color mapping for logLevel and appName • Provides type-safe badge color assignment based on data values • Supports both pill and outline badge variants +53/-0    Sidebar.tsx Add external control for sidebar open state                            src/components/common/Sidebar.tsx • Added isSidebarOpen prop to control initial sidebar state • Updated isExpanded state initialization to use the new prop • Removed React import (using automatic JSX runtime) • Enhanced sidebar responsiveness for mobile usage +4/-2      SearchBar.tsx Add width customization to SearchBar component                      src/components/shared/SearchBar.tsx • Added width prop with default value of "w-full" • Removed React import (using automatic JSX runtime) • Updated input styling to use the configurable width prop • Adjusted padding from px-4 to px-2 for more compact appearance +5/-3      ToastProvider.tsx Update ToastProvider with optional description parameter  src/utils/context/ToastProvider.tsx • Made description parameter optional in showToast function • Updated toast context interface to reflect optional description • Removed React import (using automatic JSX runtime) • Increased z-index from z-50 to z-1500 for better layering +4/-4      Button.tsx Update Button component styling and z-index adjustments    src/components/shared/Button.tsx • Reduced z-index from z-80 to z-40 for better layer management • Removed text-primary class from outline variant styling • Adjusted icon spacing from pr-1.5 to pr-[0.3rem] for tighter layout • Updated button styling for better visual consistency +3/-3      BottomSheet.tsx Add BottomSheet component for mobile modal presentations  src/components/shared/BottomSheet.tsx • New bottom sheet component for mobile-friendly modal presentations • Implements backdrop overlay with blur effect and click-to-close functionality • Includes slide-up animation and responsive width constraints • Features header section with close button and scrollable content area +41/-0    create-users.mjs Add user creation script with password hashing                      scripts/create-users.mjs • New script for generating SQL INSERT statements for user creation • Implements bcrypt password hashing with 12 salt rounds • Creates users for Rashmi Gaddam and Brock Morrison with default passwords • Generates UUID for each user and outputs formatted SQL statements +27/-0    DateRangePicker.tsx Export DateRange interface and update imports                        src/components/shared/DateRangePicker.tsx • Added DateRange interface export for external usage • Updated import path from date-utils to dateUtils • Removed React import (using automatic JSX runtime) • Enhanced type definitions for better component integration +7/-2      layout.tsx Simplify KIR layout by removing sidebar configuration        src/app/kir/layout.tsx • Removed entire sidebar configuration and layout logic • Simplified to return only children content without sidebar wrapper • Eliminated imports for sidebar components and configuration data +1/-25    Tabs.tsx Simplify Tabs component layout and content rendering          src/components/shared/Tabs.tsx • Removed overflow-x-auto class from main container • Changed content rendering from div wrapper to React fragment • Simplified tab content display without additional container +2/-2      ContactList.tsx Add ContactList component with store integration                  src/components/common/ContactList.tsx • New component for displaying contact list using Zustand store • Implements loading, error, and data states from useContactStore • Fetches contacts on component mount with useEffect • Displays contact information including first name, last name, and email +27/-0    page.tsx Integrate ContactList component into Lucy main page            src/app/lucy/page.tsx • Added import and integration of ContactList component • Enhanced page content to display both welcome message and contact list • Updated component structure to include multiple child elements +8/-1      page.tsx Convert home page to client component with updated imports src/app/page.tsx • Added "use client" directive for client-side rendering • Updated import path to use absolute path with @ alias • Converted from server component to client component +2/-1
Formatting	3 files userConfigStore.ts Update code formatting for consistency                                      src/store/userConfigStore.ts • Updated code formatting from single quotes to double quotes • Improved code consistency and readability throughout the file +29/-28  environmentSettings.ts Update environment settings formatting and structure          src/utils/data/environmentSettings.ts • Updated import statements to use double quotes for consistency • Commented out status properties and improved code formatting +16/-16  Accordion.tsx React import optimization in Accordion component                  src/components/shared/Accordion.tsx • Simplified React import by removing default import and using named imports only +1/-1
Configuration changes	2 files sessionConfig.ts Add session configuration constants                                            src/utils/config/sessionConfig.ts • Added session configuration constants • Defined max age and update age for session management +4/-0      schema.prisma Complete Prisma database schema implementation                      prisma/schema.prisma • Added complete Prisma database schema with generator and datasource configuration for SQL Server • Defined comprehensive data models for e-commerce, inventory, and user management systems • Included models for authentication, orders, returns, products, and configuration management • Added staging and temporary tables with ignore annotations for data processing +1927/-2
Dependencies	1 files package.json Database, authentication, and Azure integration dependencies package.json • Added database and authentication dependencies: @prisma/client, @next-auth/prisma-adapter, bcrypt • Included Azure Key Vault integration packages for secure configuration management • Added AutoMapper packages for object mapping functionality • Integrated logging support with winston package ...