OpenSparrow Files

Added

• Print module — block-based (heading/text/table) report templates bound to a PostgreSQL view, with {column} variables, optional dropdown report parameters, per-column width/alignment, and automatic A4 pagination with page numbers.
• Views: grid-style filters and grouping — column filters, row grouping with subtotals, SUMIF/COUNTIF-style aggregates; drill-down now expands/collapses inline instead of navigating away; sidebar submenu per view; configurable PostgreSQL schema selection for view sync.
• Notes panel (avatar menu → Notes) — private per-user notes, optionally linked to a record, with reminder dates delivered through the existing notification cron.
• Multi-board Kanban — configure more than one board, each bound to its own table and appearing under its own sidebar entry.
• Ollama Cloud API key for the RAG assistant — stored encrypted at rest, sent as a Bearer token; settings screen never displays the key back.
• Users: Manage / Statistics / Global Settings tabs — configurable minimum password length and default role for new users, enforced on user creation and password changes.
• Dashboard "Calculate (real data)" — run a widget's current unsaved table/aggregate/filter config against the real database before saving.
• Dev and production Docker install scripts.
• Per-day "+" quick-create button on the calendar.
• Admin config UI to set the automation email "From" address (Cron → Email tab), documented alongside SMTP delivery settings.
• ETL module — import data from external MySQL, MariaDB, PostgreSQL or SQLite databases, or a CSV file over FTP/FTPS, into local PostgreSQL tables. Driver-based and extensible (Oracle/DB2/SQL Server planned). Full refresh, append, and upsert load modes; incremental loads via a {{watermark}} placeholder; column mapping, batch size, parallel runs, retry-on-transient-error, and a preview before saving.

Changed

• Configuration moved from JSON files to PostgreSQL (spw_config table) — optimistic locking, full change history in spw_config_log, read/written exclusively through includes/config_store.php. Only database.json, security.json, migrations.json, and demo_meta.json remain on disk. Config export/import ZIP removed (superseded by pg_dump).
• UI unification across admin and frontend: shared search/filter bar in the app header, single button component, unified typography (14px, one danger red, Title Case labels), unified collapsible cards, and one hover-tooltip component shared by the grid, calendar, and board.
• Grid row actions (edit/duplicate/delete) collapsed behind a single "more actions" icon.
• Admin navigation reorganized: Add Table / M2M Builder / Menu Preview moved into Schema; Database / Audit moved into Settings; Schema Map moved into the Schema tab's sidebar.
• KPI Card widget removed; its count/sum/avg aggregation option merged into Stat Card.
• Files module rebuilt as a grid-style table with sort, pagination, and bulk delete/tagging.
• available_languages restriction removed — all installed languages are now available everywhere.

Fixed

• Grid header "select all" checkbox now selects only the current page instead of every row across all pages.
• Setup wizard no longer fatals on a failed PostgreSQL connection under PHP 8.4, and now displays the real generated admin password instead of a placeholder.
• File form-data handling fixed; files upload 500 error resolved (table schema resolution).
• Admin CSRF gap on settings actions closed; average (avg) aggregation added for stat cards.
• FK config error diagnostics improved in FkOptionsLoader for edit forms and list display.

Security

• File uploads hardened: MIME/extension mismatch rejected, forced attachment download for non-image files, sys_temp_dir fallback, clearer upload error messages.
• Admin API auth gate now returns proper 401/403 responses.
• Automation email action carries header-injection protection.

Removed

• MySQL Gateway (external-table display/CRUD routing) — OpenSparrow's data layer is PostgreSQL-only; use the new ETL module to bring in MySQL/MariaDB/SQLite data instead.

Full changelog: https://github.com/wrobeltomasz/OpenSparrow/compare/2.9...3.0