Refactor getLinks to calculate total clicks across all links

[AmoabaKelvin]

• Modify totalClicks query to count all visits for user's links
• Use innerJoin to ensure only actual visits are counted
• Separate totalClicks calculation from paginated link query
• Improve accuracy of total click count independent of pagination

This change provides a more accurate total click count across all of a user's links, regardless of the current page or filter settings.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
ishortn-ink	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Aug 16, 2024 9:48am

[what-the-diff[bot]]

PR Summary

• Improved code efficiency for ‘Total Clicks’ count on the Dashboard The way 'Total Clicks' was calculated and accounted for in the dashboard's page code has been changed to make the function more efficient. Instead of an earlier cumbersome calculation method, the 'Total Clicks' is now being directly fetched from the API result.

• Enhanced data fetching process for Link Analytics The data fetching methods for 'Total Links' and 'Total Clicks' have been revamped. As a part of this change, the code now simultaneously fetches the two data sets using Promise.all() leading to better performance and faster data retrieval.

• Amended 'Links' data fetching for improved Analytics The process to fetch 'Links' data has been updated to include 'total_clicks' in the select statement. This change will help in providing a more comprehensive data view for users.

• Optimized calculation for ‘Total Pages’ The process used to calculate 'Total Pages' has been refined which should improve the overall accuracy and operation of the analytics tool.