[PR #1897] [MERGED] feat: request log analytics #11551

New Issue

GiteaMirror · 2026-05-06T16:14:11-05:00

GiteaMirror commented

2026-05-06 16:14:11 -05:00

📋 Pull Request Information

Original PR: https://github.com/fosrl/pangolin/pull/1897
Author: @Fredkiss3
Created: 11/19/2025
Status: ✅ Merged
Merged: 12/4/2025
Merged by: @miloschwartz

Base: dev ← Head: feat/log-analytics

📝 Commits (10+)

e90bdf8 ♻️ translate sidebar headings
af4b9e8 ✏️ fix typos
cd76fa0 ✨add analytics endpoint
4ed4515 🚧 starting request analytics page
dc237b8 💬 update text message from the API
4879855 ➕add react compiler
2bc82f4 ✨add enpoint for getting all resource names
d6e8eb5 🧑‍💻add tailwind indicator component
5d1f81a ✨ world map
266fbb1 💄nicer colors

📊 Changes

30 files changed (+4000 additions, -288 deletions)

View changed files

📝 Dockerfile (+4 -3)
📝 messages/en-US.json (+20 -1)
📝 next.config.ts (+3 -0)
📝 package-lock.json (+931 -1)
📝 package.json (+11 -4)
📝 server/db/pg/driver.ts (+28 -9)
📝 server/routers/auditLogs/exportRequestAuditLog.ts (+12 -5)
📝 server/routers/auditLogs/index.ts (+3 -2)
➕ server/routers/auditLogs/queryRequestAnalytics.ts (+192 -0)
📝 server/routers/auditLogs/queryRequestAuditLog.ts (+21 -9)
📝 server/routers/external.ts (+58 -45)
📝 server/routers/resource/index.ts (+1 -0)
➕ server/routers/resource/listAllResourceNames.ts (+90 -0)
📝 server/routers/resource/listResources.ts (+20 -13)
➕ src/app/[orgId]/settings/logs/analytics/page.tsx (+28 -0)
📝 src/app/globals.css (+18 -0)
📝 src/app/layout.tsx (+5 -0)
📝 src/app/navigation.tsx (+12 -6)
📝 src/components/BlueprintDetailsForm.tsx (+0 -1)
📝 src/components/DateTimePicker.tsx (+196 -185)

...and 10 more files

📄 Description

Community Contribution License Agreement

By creating this pull request, I grant the project maintainers an unlimited,
perpetual license to use, modify, and redistribute these contributions under any terms they
choose, including both the AGPLv3 and the Fossorial Commercial license terms. I
represent that I have the right to grant this license for all contributed content.

Description

Main changes:

Request logs analytics page showing analytics grouped by countries and also grouped by day
Also translated the sidebar headings (they weren't before)
Added an endpoint for getting all resource names, this is what is shown in the resource filter of the analytics page

Other changes:

log postgres DB queries in DEV
Added a component TailwindIndicator for showing the current breakpoint and screen width, this component is only shown in DEV
Added react compiler for quick and easy perf wins

Updated the set:pg & set:sqlite scripts to also export a driver variable:

// server/db/index.ts
export * from "./pg";
export const driver: "pg" | "sqlite" = "pg";

Screenshots

-	-
Analytics page chart
Analytics page contries
Tailwind Indicator

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/fosrl/pangolin/pull/1897 **Author:** [@Fredkiss3](https://github.com/Fredkiss3) **Created:** 11/19/2025 **Status:** ✅ Merged **Merged:** 12/4/2025 **Merged by:** [@miloschwartz](https://github.com/miloschwartz) **Base:** `dev` ← **Head:** `feat/log-analytics` --- ### 📝 Commits (10+) - [`e90bdf8`](https://github.com/fosrl/pangolin/commit/e90bdf8f9758f5c1b21fe1c8055f858a9110a07f) ♻️ translate sidebar headings - [`af4b9e8`](https://github.com/fosrl/pangolin/commit/af4b9e83f72446e5f9a7126b3078fea24dbc888e) ✏️ fix typos - [`cd76fa0`](https://github.com/fosrl/pangolin/commit/cd76fa01398964bcc7643ec2086cf0a0fff6b030) ✨add analytics endpoint - [`4ed4515`](https://github.com/fosrl/pangolin/commit/4ed45152624efc3a1b4e6d0439fa8159728f1887) 🚧 starting request analytics page - [`dc237b8`](https://github.com/fosrl/pangolin/commit/dc237b8052e3c46f9e0a60140dfb0d3e9b2029ff) 💬 update text message from the API - [`4879855`](https://github.com/fosrl/pangolin/commit/487985558d3fa5ad0ff856bcd8235313ff08440c) ➕add react compiler - [`2bc82f4`](https://github.com/fosrl/pangolin/commit/2bc82f49ed5dd5dade3522fd7bea86d29c6b030c) ✨add enpoint for getting all resource names - [`d6e8eb5`](https://github.com/fosrl/pangolin/commit/d6e8eb5307486c6c7bebf135a2f74945454c7d9c) 🧑‍💻add tailwind indicator component - [`5d1f81a`](https://github.com/fosrl/pangolin/commit/5d1f81a92c556011b9776643a5788375e3b9562b) ✨ world map - [`266fbb1`](https://github.com/fosrl/pangolin/commit/266fbb176249460b65f554cf21f65eb94404b151) 💄nicer colors ### 📊 Changes **30 files changed** (+4000 additions, -288 deletions) <details> <summary>View changed files</summary> 📝 `Dockerfile` (+4 -3) 📝 `messages/en-US.json` (+20 -1) 📝 `next.config.ts` (+3 -0) 📝 `package-lock.json` (+931 -1) 📝 `package.json` (+11 -4) 📝 `server/db/pg/driver.ts` (+28 -9) 📝 `server/routers/auditLogs/exportRequestAuditLog.ts` (+12 -5) 📝 `server/routers/auditLogs/index.ts` (+3 -2) ➕ `server/routers/auditLogs/queryRequestAnalytics.ts` (+192 -0) 📝 `server/routers/auditLogs/queryRequestAuditLog.ts` (+21 -9) 📝 `server/routers/external.ts` (+58 -45) 📝 `server/routers/resource/index.ts` (+1 -0) ➕ `server/routers/resource/listAllResourceNames.ts` (+90 -0) 📝 `server/routers/resource/listResources.ts` (+20 -13) ➕ `src/app/[orgId]/settings/logs/analytics/page.tsx` (+28 -0) 📝 `src/app/globals.css` (+18 -0) 📝 `src/app/layout.tsx` (+5 -0) 📝 `src/app/navigation.tsx` (+12 -6) 📝 `src/components/BlueprintDetailsForm.tsx` (+0 -1) 📝 `src/components/DateTimePicker.tsx` (+196 -185) _...and 10 more files_ </details> ### 📄 Description ## Community Contribution License Agreement By creating this pull request, I grant the project maintainers an unlimited, perpetual license to use, modify, and redistribute these contributions under any terms they choose, including both the AGPLv3 and the Fossorial Commercial license terms. I represent that I have the right to grant this license for all contributed content. ## Description **Main changes:** - Request logs analytics page showing analytics grouped by countries and also grouped by day - Also translated the sidebar headings (they weren't before) - Added an endpoint for getting all resource names, this is what is shown in the resource filter of the analytics page **Other changes:** - log postgres DB queries in DEV - Added a component `TailwindIndicator` for showing the current breakpoint and screen width, this component is only shown in DEV - Added react compiler for quick and easy perf wins - Updated the `set:pg` & `set:sqlite` scripts to also export a `driver` variable: ```ts // server/db/index.ts export * from "./pg"; export const driver: "pg" | "sqlite" = "pg"; ``` ## Screenshots | - | - | | ------ | ------ | | Analytics page chart | <img width="1868" height="1159" alt="Screenshot 2025-11-21 at 06 01 57" src="https://github.com/user-attachments/assets/bf21e282-0d57-4b3c-9bf7-e667f93495b0" /> | | Analytics page contries | <img width="1868" height="1159" alt="Screenshot 2025-11-21 at 06 02 58" src="https://github.com/user-attachments/assets/275b13f0-b3b4-4d4d-971a-fcbfbb4e1ddc" /> | | Tailwind Indicator | <img width="200" height="101" alt="image" src="https://github.com/user-attachments/assets/eb8c2aa4-e826-4698-9416-ab5341875d2f" /> | --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2026-05-06 16:14:11 -05:00

GiteaMirror closed this issue

2026-05-06 16:14:12 -05:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/pangolin#11551