# Fusion Invoice

Self-hosted invoicing and billing platform.

## Location

- URL: https://invoice.kaburu.co
- Files: /home/invoice.kaburu.co/public_html/
- Database: invoice (MariaDB on kaburusvr)
- Framework: Laravel

## Config

Database config: `config/database.php`
- host: 127.0.0.1
- database: invoice
- username: invoice

## Mail (SMTP via Brevo)

Settings stored in database (settings table), encrypted with Laravel app key.

| Setting | Value |
|---------|-------|
| mailDriver | smtp |
| mailHost | smtp-relay.brevo.com |
| mailPort | 587 |
| mailUsername | a7cdba001@smtp-brevo.com |
| mailFromAddress | accounts@kaburu.co |
| mailFromName | kaburu Accounts |

To update mail password:
```php
// Encrypt new password using Laravel encrypter, then UPDATE settings table
php -r "require 'vendor/autoload.php'; $app = require 'bootstrap/app.php'; $app->make('Illuminate\Contracts\Console\Kernel')->bootstrap(); echo encrypt('NEW_PASSWORD');"
mysql invoice -e "UPDATE settings SET setting_value='ENCRYPTED' WHERE setting_key='mailPassword';"
```

## Known quirks

- Migrated from Chemicloud 2026-05-11
- No .env file — all config in database and config/ PHP files
- Laravel encryption uses app key stored in database (appKey setting)
- Proton Bridge SMTP does not work on server — must use Brevo or other SMTP relay