Bug #2873
Display Dashboard Banner During Daily Rollup Processing
Description
Title: Show "Daily Data Refresh in Progress" banner during scheduled dashboard rollup execution
Type: Enhancement
Priority: Medium
Background:
The system executes scheduled rollup jobs daily between 12:01 AM and 12:15 AM IST to calculate and refresh dashboard analytics.
Schedulers involved:
- analytics-rollup
- advanced-analytics-rollup
- tenant/summary-rollup
During this period, dashboard widgets, reports, and analytics may display incomplete or outdated data until processing is completed.
Requirement:
Display an informational banner on the dashboard while the daily rollup jobs are running.
Banner Title:
⚙️ Daily Data Refresh in Progress
Banner Message:
Your dashboard is currently being updated as part of our scheduled daily data refresh (12:01 AM – 12:15 AM IST). During this time, analytics, reports, and summary metrics may temporarily display incomplete or outdated data. Please refresh the dashboard after 12:15 AM IST for the latest information.
Display Conditions:
- Show the banner between 12:01 AM IST and 12:15 AM IST every day.
- Automatically hide the banner after 12:15 AM IST.
- Display the banner on all dashboard pages that consume rollup data.
Functional Requirements:
- Show the banner only during the scheduled rollup window.
- The dashboard should remain accessible.
- Existing APIs should continue functioning normally.
- Users should still be able to navigate the application.
- The banner should disappear automatically after the rollup window.
Acceptance Criteria:
- Banner is visible only between 12:01 AM and 12:15 AM IST.
- Banner is hidden outside the scheduled window.
- Users are informed that analytics and reports may temporarily be incomplete.
- There is no impact on existing dashboard functionality.
- Banner styling follows the application's standard information/notification design.
Expected Outcome:
Users clearly understand that temporary discrepancies in dashboard metrics are due to the scheduled daily rollup process rather than a system issue.
Updated by Shreya Agarwal about 2 months ago
- worked on updating and adding multilingual translations for the Finance and Transactions modules. I added translation entries for transaction management, expenses, cash balances, transfers, claims, approval limit overrides, and related UI messages. I also covered labels and messages for station selection, categories, advance payments, and draft transactions across all supported languages.
-and try to Understand the Sales Module flow: Sales Manager plans visits, and all expenses reuse existing approval/advance/payment modules.
-and side by side learning .net in deep to understand and improve logics.
-Additionally, implemented a maintenance message banner on the dashboard that appears between 12:01 AM to 12:15 AM IST to inform users about daily analytics processing.
Tested and finalized the UI for the maintenance message with proper styling, positioning, and responsive design.
Set up the time-based conditional rendering logic using React hooks to automatically show/hide the message during the maintenance window.
Updated the isMaintenanceWindow() function to check IST time and reverted from test time back to production time (12:01 AM - 12:15 AM IST)