OpenSparrow Files

Added

• Roadmap (Gantt) module (Admin → Data Management → Roadmap) — admins define multiple roadmaps, each bound to a schema table through chosen title, start-date, end-date, category and progress columns, with an optional per-roadmap color, card columns and a hidden flag. The frontend renders a read-only Gantt timeline with a month grid, milestone markers, a roadmap picker, prev/next navigation and a category filter bar whose color chips toggle whole categories on and off; unconfigured roadmaps are skipped and a not-configured page is shown when nothing is set up. Access follows the existing per-user scope model: a new roadmaps scope gates the menu entries and the front API, and the bound table must also be within the user's table access. The CRM demo data set gained a projects table with sample rows, the UI strings are translated into all 20 locales, and guard tests pin the new endpoints.

Changed

• Record grid and view tables restyled — cell borders, a light header row and no zebra striping, built on the existing design tokens; a static design reference for the new look ships as public/mock.html (not referenced by the application, safe to delete from production deployments).
• Sidebar toggle relocated — the desktop collapse toggle moved from the header to the bottom of the menu (the hamburger stays on mobile), and menu-list nav links align with the grid at 14px font-sans.
• Branding assets refreshed — a new logo.png and a much smaller favicon.ico.
• Cron, anonymization and ETL log status values are documented as running / success / error (previously described as ok) — in docs/DATABASE.md and in the column comments emitted by the system-tables DDL (metadata only; existing installs keep their stored comments unless the comment migration is re-applied).

Removed

• Nothing.

Fixed

• Enum dropdowns keep readable text color via YIQ contrast on both the record grid and the edit/create form — previously a custom enum color could render white-on-light or dark-on-dark option text.
• docs.js inconsistencies across admin modules repaired, plus a broken Polish string in docs-strings.js.

Upgrade notes

• No database migration and no configuration keys are removed by this release. Roadmap configuration lives in the existing spw_config store under the roadmap key; there is nothing to run or clean up after upgrading.
• Per-user access: the new roadmaps scope is independent — granting a user a roadmap does not grant its bound table, so users also need table access to see any roadmap content. An empty grant list means unrestricted, as with all other scopes.

Full changelog: https://github.com/wrobeltomasz/OpenSparrow/compare/3.7...3.8