cbazza/AFC-Demo
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
156 Commits 3 Branches 0 Tags
main
Commit Graph
156 Commits
This Branch
This Branch
All Branches
Author SHA1 Message Date
cbazzaandClaude Opus 4.5 fddc78618e feat: add Azure AKS deployment infrastructure with Terraform
Build and Deploy to Synology NAS / test (push) Failing after 15m0s
Details
Build and Deploy to Synology NAS / build (push) Has been cancelled
Details
Build and Deploy to Synology NAS / deploy (push) Has been cancelled
Details
Build and Deploy to Synology NAS / notify (push) Has been cancelled
Details 
- Add Terraform configuration for AKS cluster deployment
- Add Kubernetes manifests for Laravel app (deployment, services, secrets)
- Add PostgreSQL on Kubernetes with multi-schema support
- Add Nginx Ingress Controller configuration
- Add GitHub Actions workflow for Azure deployment
- Add HTTP Basic Authentication for production
- Add database restore functionality via Kubernetes jobs
- Update Dockerfile and nginx config for production
- Update database.php for multi-schema connections
- Add deployment documentation and quickstart guides

Deployed version: 1.0.7 at http://72.144.113.194/

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-02-03 09:43:08 +01:00
cbazzaandClaude Sonnet 4.5 6cd051d571 fix(ci): replace scp with cat over SSH to avoid SFTP subsystem issues
Build and Deploy to Synology NAS / build (push) Has been skipped
Details
Build and Deploy to Synology NAS / deploy (push) Has been skipped
Details
Build and Deploy to Synology NAS / notify (push) Failing after 1m42s
Details
Build and Deploy to Synology NAS / test (push) Failing after 20m27s
Details 
- Replace scp commands with cat piped over SSH
- Add directory creation step before file transfer
- Avoid SFTP subsystem requirement on Synology
- Resolves "subsystem request failed on channel 0" error

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
 2025-12-19 14:04:45 +01:00
cbazzaandClaude Sonnet 4.5 ed9793937e fix(ci): resolve SSH hostname resolution issue in Gitea deployment
Build and Deploy to Synology NAS / test (push) Successful in 51m26s
Details
Build and Deploy to Synology NAS / build (push) Successful in 2h8m37s
Details
Build and Deploy to Synology NAS / deploy (push) Failing after 3m38s
Details
Build and Deploy to Synology NAS / notify (push) Failing after 11m11s
Details 
- Replace ssh-keyscan with SSH config to avoid DNS lookup
- Disable StrictHostKeyChecking for automated deployment
- Fix cleanup step order to execute SSH command before removing key
- Use IP address directly from SYNOLOGY_HOST secret

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
 2025-12-18 16:29:57 +01:00
cbazzaandClaude 23475f650f fix: downgrade artifact actions to v3 for Gitea compatibility
Build and Deploy to Synology NAS / test (push) Successful in 1h1m38s
Details
Build and Deploy to Synology NAS / build (push) Successful in 2h34m26s
Details
Build and Deploy to Synology NAS / deploy (push) Failing after 3m41s
Details
Build and Deploy to Synology NAS / notify (push) Failing after 14m7s
Details 
- Changed upload-artifact from v4 to v3
- Changed download-artifact from v4 to v3
- Gitea Actions does not support artifact v4 API (GHES compatibility issue)

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
 2025-12-18 08:13:10 +01:00
cbazzaandClaude 284e30da71 fix: remove GitHub Actions cache from Docker build
Build and Deploy to Synology NAS / test (push) Successful in 53m28s
Details
Build and Deploy to Synology NAS / build (push) Failing after 1h47m19s
Details
Build and Deploy to Synology NAS / deploy (push) Has been skipped
Details
Build and Deploy to Synology NAS / notify (push) Failing after 2m5s
Details 
- Removed cache-from and cache-to from Docker build step
- GitHub Actions cache (gha) causes timeout errors in Gitea Actions
- Build will be slower but more reliable

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
 2025-12-17 21:39:52 +01:00
cbazzaandClaude d0bd84f4a2 ci: exclude PostgreSQL tests from CI workflow
Build and Deploy to Synology NAS / test (push) Successful in 1h8m11s
Details
Build and Deploy to Synology NAS / build (push) Failing after 2h11m18s
Details
Build and Deploy to Synology NAS / deploy (push) Failing after 11m20s
Details
Build and Deploy to Synology NAS / notify (push) Has been cancelled
Details 
- Added --exclude-group=backend-db flag to test command in Gitea workflow
- Marked all PostgreSQL-dependent tests with ->group('backend-db')
- Tests in BackendModelsTest.php (8 tests) now excluded from CI
- Tests in SyncBackendDataPoolTest.php (8 tests) now excluded from CI
- These tests still run locally where PostgreSQL backend is available

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
 2025-12-17 18:04:42 +01:00
cbazza 94d02736f7 ci: add automated Gitea Actions deployment workflow for Synology NAS
Build and Deploy to Synology NAS / test (push) Failing after 1h20m56s
Details
Build and Deploy to Synology NAS / build (push) Failing after 11m7s
Details
Build and Deploy to Synology NAS / deploy (push) Has been cancelled
Details
Build and Deploy to Synology NAS / notify (push) Has been cancelled
Details 
- Add Gitea Actions workflow for automated build and deployment
- Add deployment script for Synology NAS
- Add Docker Compose configurations for production deployment
- Add Gitea runner setup
- Add comprehensive documentation for CI/CD setup
- Add health check endpoint for deployment verification
- Update .gitignore for CI/CD artifacts
 2025-12-17 13:02:38 +01:00
cbazza 2f7bd923df local-docker-db branch openend
Build and Push Docker Image only on Conventional Commits / build (push) Has been cancelled
Details
2025-12-03 12:59:30 +01:00
Marian aa8de00969 fix: seeder
Build and Push Docker Image only on Conventional Commits / build (push) Has been cancelled
Details
linter / quality (push) Has been cancelled
Details
tests / ci (push) Has been cancelled
Details
2025-11-27 09:26:43 +00:00
Marian 741655c548 feat: add init seeder 2025-11-27 09:20:47 +00:00
Marian e598cc475c fix: startup 2025-11-26 14:09:30 +00:00
Marian 09dc2f1125 fix: entrypoint 2025-11-26 13:59:02 +00:00
Marian c5d3e067a0 fix: init problems 2025-11-26 13:53:39 +00:00
Marian 109434b02b fix: read search path from env 2025-11-26 10:34:13 +00:00
Marian 355bbaf0c1 fix: ci 2025-11-26 10:18:52 +00:00
cbazza b33ca76667 chore: project cleanup - remove unused dependencies and routes 
- Remove unused axios package and 22 dependencies
- Fix 2 moderate npm security vulnerabilities
- Remove test route /test-zweite-db (no longer needed)
- Remove unused DB facade import from routes/web.php

This cleanup reduces bundle size and improves maintainability.
 2025-11-21 12:05:52 +01:00
cbazza 3cfb69f0c7 chore: improve .gitignore with better organization 
- Organized entries into logical sections (IDEs, macOS, MCP, etc.)
- Fixed .DS_Store pattern to work in all subdirectories (**/.DS_Store)
- Added macOS-specific ignores (.AppleDouble, .LSOverride)
- Added database SQLite ignores (*.sqlite, *.sqlite-journal)
- Added backup/temporary file patterns (*.bak, *.tmp, *.swp)
- Added log file ignore (*.log)
- Added docs temporary exports (*.pptx, *.docx in diagrams/)
- Removed obsolete AGENTS*.* pattern (file already deleted)
- Removed standalone 'env' pattern (covered by .env.backup)
 2025-11-21 10:48:19 +01:00
cbazza b34612aeaa chore: remove DaxCompanySeeder (legacy demo data) 
The DaxCompanySeeder created fake DAX-40 companies and transactions
for development. We now use real data from the backend via the
TransformDataPoolToProduction job, so this seeder is no longer needed.
 2025-11-21 10:32:15 +01:00
cbazza f23d56a0b7 fix: move database schemas from database/ to docs/schemas 
CSV schema files are database structure documentation, not production
database files. They belong in docs/ alongside other documentation.
 2025-11-21 10:29:25 +01:00
cbazza ac1f72572d fix: move SQL queries from database/ to docs/queries 
SQL query files (playground, test queries) are development documentation,
not production database files. They belong in docs/ alongside other documentation.
 2025-11-21 10:23:33 +01:00
cbazza 03d6a48bfd fix: move migration diagrams from database/schemas to docs/diagrams 
Migration diagrams (Keynote, PDF, Excel, Numbers) are documentation,
not technical database files. They belong in docs/ for better organization.
 2025-11-21 10:21:46 +01:00
cbazza 05b9b13e2e fix: Trigger pipeline 2025-11-21 10:05:05 +01:00
cbazza 1cb38d7080 chore: major project cleanup and restructuring 
## Dokumentation
- Entfernt AGENTS.md (redundant zu CLAUDE.md)
- Verschoben: 3 Dokumentationen von root → docs/
- Gelöscht: 8 historische Migrations-Pläne aus docs/archive/
- Entfernt: misc/ Ordner komplett (43 Dateien)

## Struktur
- Erstellt: database/queries/ für SQL Test-Queries (4 Dateien)
- Erstellt: database/schemas/ für Schema-Dokumentation (17 Dateien)
  - output_keys_mapping/ (8 CSV-Mappings)
  - migration-diagrams/ (4 Diagramme)

## Code-Qualität
- Formatiert: 7 Style-Issues in 74 Dateien mit Laravel Pint
- Gefixed: Migration für PostgreSQL/SQLite Kompatibilität
- Gefixed: 2 fehlgeschlagene Tests (CSRF + Text-Assertion)

## Tests
- Alle 73 Tests bestehen jetzt (100% Success Rate)
- AuthenticationTest: CSRF-Token Fix für Logout-Test
- CompanySearchTest: Text-Assertion aktualisiert

## Ergebnis
- Root ist sauber (nur CLAUDE.md)
- Dokumentation strukturiert in docs/
- Database-Dateien organisiert in database/
- Code entspricht Style-Guide
- Alle Tests bestehen
 2025-11-21 10:00:32 +01:00
cbazza 3a54f6cba3 fix: changes and fixes for the detail transaction view 2025-11-20 14:56:28 +01:00
cbazza 67df5f36c1 fix: placeholder for Stimmrecht added on level 8 to the menue 2025-11-20 12:24:43 +01:00
cbazza ce80a5a022 fix: all 8 categories integrated into the detail view of transactions 2025-11-20 12:16:00 +01:00
cbazza 5e36c85fd9 Merge branch 'main' of ssh://git.trai-infra.comstack.de:9922/bob.molitor/frontend 2025-11-20 11:54:32 +01:00
cbazza a36d2b4cc4 fix: added new command - complete rebuild 2025-11-20 11:54:08 +01:00
Marian 6254583ce8 fix: ci and k8s resource 2025-11-20 10:11:35 +00:00
cbazza 1505975ebb fix: Menue Transaktionen und Stammdaten added to trasaction details 2025-11-20 11:08:23 +01:00
u00lipp 7d085f417c add cronjob 2025-11-20 10:39:02 +01:00
cbazza cb168f3dd8 fix: Trigger pipeline 2025-11-19 12:26:55 +01:00
cbazza 85e4fce229 removed KycRiskCalculator, added 3 new field for the database table data_pool_backend, added simple risk level and mapping funcion for these new risk factor 2025-11-19 12:23:27 +01:00
cbazza 976af0f2e6 Build functions/ jobs for data_pool and transformation 2025-11-17 15:27:21 +01:00
cbazza 46820e9515 Migration & Datapool created with job and scheduler backend->frontend(public) schema 2025-11-16 22:28:42 +01:00
cbazza a4df2d0fae removed trash columns and added 102 columns to transaction, made migration Files, added some stuff to misc 2025-11-16 15:09:59 +01:00
cbazza b9d9276de0 Zuordnung SQL Statements je Seite im public Schema 2025-11-14 12:23:27 +01:00
cbazza 4aa221ab29 moved folder database table schemas to the folder misc 2025-11-14 11:21:01 +01:00
cbazza 699603dde7 CSV Tables scheme describtion added 2025-11-14 11:17:20 +01:00
cbazza 3b1488209e fix: minor optical changes on the upload side 2025-11-13 17:23:34 +01:00
cbazza 93fc8d821a fix: database.php changed 2025-11-13 16:55:22 +01:00
cbazza 0d534f5013 fix: added upload formular, reorganized some files and put them into a new folder misc 2025-11-13 16:21:26 +01:00
cbazza 100fe2de18 gitignore changed 2025-11-11 18:36:30 +01:00
cbazza 16a58cfae3 .gitignore changed 2025-11-11 18:24:59 +01:00
cbazza 86e99d2e4d edited gitignore 2025-11-11 18:20:29 +01:00
cbazza 21801c2149 fix: anpassungen Romans Vorschlag 11.11.2025 2025-11-11 16:50:09 +01:00
cbazza 64b8ff48da fix: anpassungen lt. Besprechung Frontend/ Powerpoint 10-11-2025 2025-11-10 21:35:52 +01:00
cbazza 08faf9fb86 fix: anpassungen aus der powerpoint final sprintende 2025-11-10 14:08:26 +01:00
cbazza 175aebffa5 fix: transactions edited so it matches the powerpoint overview 2025-11-10 11:25:18 +01:00
cbazza 6331785fda typo and design changes Frontend-Optimierung Powerpoint 2025-11-07 13:52:36 +01:00