#!/usr/bin/env python3 """ZZP Dashboard — JG Consultancy""" import os, sqlite3, hashlib, secrets, json from datetime import datetime, timedelta from functools import wraps from flask import Flask, request, session, redirect, url_for, render_template_string, flash, g from werkzeug.security import generate_password_hash, check_password_hash # ── Config ────────────────────────────────────────────────────────────────── BASE_DIR = os.path.dirname(os.path.abspath(__file__)) DATA_DIR = os.path.join(BASE_DIR, 'data') DB_PATH = os.path.join(DATA_DIR, 'zzp.db') os.makedirs(DATA_DIR, exist_ok=True) app = Flask(__name__) app.config['APPLICATION_ROOT'] = '/zzp' app.secret_key = secrets.token_hex(32) app.config['PERMANENT_SESSION_LIFETIME'] = timedelta(hours=8) app.config['SESSION_COOKIE_PATH'] = '/zzp' # Colors C = dict(primary='#003366', accent='#3B82F6', success='#00A859', warning='#F59E0B', text='#1F2937', bg='#F3F4F6', white='#FFFFFF', border='#E5E7EB', danger='#EF4444') # ── Database ──────────────────────────────────────────────────────────────── def get_db(): if 'db' not in g: g.db = sqlite3.connect(DB_PATH) g.db.row_factory = sqlite3.Row g.db.execute("PRAGMA journal_mode=WAL") return g.db @app.teardown_appcontext def close_db(exc): db = g.pop('db', None) if db: db.close() def init_db(): conn = sqlite3.connect(DB_PATH) conn.row_factory = sqlite3.Row c = conn.cursor() c.executescript(""" CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS settings ( key TEXT PRIMARY KEY, value TEXT ); CREATE TABLE IF NOT EXISTS timesheets ( id INTEGER PRIMARY KEY AUTOINCREMENT, date TEXT NOT NULL, client TEXT NOT NULL, activity TEXT NOT NULL, hours REAL NOT NULL, billable INTEGER DEFAULT 1, note TEXT DEFAULT '', created_at TEXT DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS invoices ( id INTEGER PRIMARY KEY AUTOINCREMENT, invoice_number TEXT UNIQUE NOT NULL, client TEXT NOT NULL, period_year INTEGER, period_month INTEGER, invoice_date TEXT, due_date TEXT, subtotal REAL DEFAULT 0, btw REAL DEFAULT 0, total REAL DEFAULT 0, status TEXT DEFAULT 'Concept', created_at TEXT DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS invoice_lines ( id INTEGER PRIMARY KEY AUTOINCREMENT, invoice_id INTEGER REFERENCES invoices(id), description TEXT, hours REAL, rate REAL, amount REAL ); CREATE TABLE IF NOT EXISTS expenses ( id INTEGER PRIMARY KEY AUTOINCREMENT, date TEXT NOT NULL, category TEXT NOT NULL, description TEXT, amount_excl REAL NOT NULL, btw REAL DEFAULT 0, total REAL NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS btw_quarters ( id INTEGER PRIMARY KEY AUTOINCREMENT, year INTEGER, quarter INTEGER, status TEXT DEFAULT 'Nog doen', filed_at TEXT ); """) # Seed admin user pw_hash = generate_password_hash('Admin123!') c.execute("INSERT OR IGNORE INTO users (username, password_hash) VALUES (?,?)", ('admin', pw_hash)) # Seed settings defaults = { 'company_name': 'JG Consultancy', 'company_address': '', 'company_kvk': '', 'company_btw': '', 'company_bank': '', 'client_phoenix_metals_address': '', 'client_club_of_engineers_address': '', 'rate_phoenix_metals': '100', 'rate_club_of_engineers': '100', 'rate_overig': '85', 'payment_terms': '30', 'client_overig_address': '' } for k, v in defaults.items(): c.execute("INSERT OR IGNORE INTO settings (key, value) VALUES (?,?)", (k, v)) conn.commit() conn.close() # ── Auth ──────────────────────────────────────────────────────────────────── def login_required(f): @wraps(f) def decorated(*args, **kwargs): if 'user' not in session: return redirect(url_for('login')) return f(*args, **kwargs) return decorated # ── Helpers ───────────────────────────────────────────────────────────────── def get_setting(key, default=''): r = get_db().execute("SELECT value FROM settings WHERE key=?", (key,)).fetchone() return r['value'] if r else default def set_setting(key, value): get_db().execute("INSERT OR REPLACE INTO settings (key, value) VALUES (?,?)", (key, value)) get_db().commit() def fmt_eur(v): return f"€ {v:,.2f}".replace(",","X").replace(".",",").replace("X",".") def client_prefix(client): mapping = {'Phoenix Metals': 'PM', 'Club of Engineers': 'COE', 'Overig': 'OVR', 'Overhead': 'OHD'} return mapping.get(client, 'OVR') def next_invoice_number(client, year=2026): prefix = client_prefix(client) r = get_db().execute( "SELECT invoice_number FROM invoices WHERE invoice_number LIKE ? ORDER BY id DESC LIMIT 1", (f"{year}-{prefix}-%",)).fetchone() if r: num = int(r['invoice_number'].split('-')[-1]) + 1 else: num = 1 return f"{year}-{prefix}-{num:03d}" def calc_btw_reserve(): db = get_db() year = datetime.now().year r = db.execute("SELECT COALESCE(SUM(btw),0) as total FROM invoices WHERE status != 'Betaald' AND invoice_date LIKE ?", (f"{year}%",)).fetchone() return r['total'] if r else 0 # ── Base Layout ───────────────────────────────────────────────────────────── LAYOUT = """ {% block title %}ZZP Dashboard{% endblock %} {% block body %}{% endblock %} """ # ── Login Page ────────────────────────────────────────────────────────────── LOGIN_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}

ZZP Dashboard

Log in om door te gaan

{% if error %}
{{ error }}
{% endif %}
{% endblock %} """) # ── Dashboard ─────────────────────────────────────────────────────────────── DASHBOARD_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
ZZP Dashboard
🚪 Uitloggen

Dashboard

Uren dit jaar

{{ data.total_hours|round(1) }}

Urencriterium (1.225u)

{{ data.pct|round(1) }}%%

Openstaande facturen

{{ data.open_invoices }}

Winst dit jaar

{{ fmt(data.profit) }}

Facturabel vs Overhead

🔵 Facturabel: {{ data.billable_hours|round(1) }}u   ⚪ Overhead: {{ data.overhead_hours|round(1) }}u

BTW Reserve

{{ fmt(data.btw_reserve) }}

Laatste 5 activiteiten

{% if data.recent %} {% for r in data.recent %}{% endfor %}
DatumClientUren
{{ r.date }}{{ r.client }}{{ r.hours }}
{% else %}

Nog geen uren geregistreerd

{% endif %}

⚠️ Openstaande acties

{% if data.alerts %} {% for a in data.alerts %}

{{ a.text }}

{% endfor %} {% else %}

✅ Geen openstaande acties

{% endif %}
{% endblock %} """) # ── Timesheets ────────────────────────────────────────────────────────────── TIMESHEETS_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Urenregistratie
🚪 Uitloggen

Urenregistratie

+ Uren toevoegen
{% if msg %}
{{ msg }}
{% endif %}
Totaal getoond: 0u
{% for t in timesheets %} {% endfor %}
DatumOpdrachtgeverActiviteitUrenFacturabelActies
{{ t.date }}{{ t.client }}{{ t.activity }}{{ t.hours }} {% if t.billable %}Ja{% else %}Nee{% endif %} ✏️

Uren dit jaar

{{ total_hours|round(1) }}

Facturabel

{{ billable_hours|round(1) }}

Overhead

{{ (total_hours - billable_hours)|round(1) }}
{% endblock %} """) TIMESHEET_FORM_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
{{ 'Uren bewerken' if edit else 'Uren toevoegen' }}
🚪 Uitloggen

{{ 'Uren bewerken' if edit else 'Uren toevoegen' }}

{% if error %}
{{ error }}
{% endif %}
Annuleren
{% endblock %} """) # ── Invoices ──────────────────────────────────────────────────────────────── INVOICES_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Facturatie
🚪 Uitloggen

Facturatie

+ Factuur genereren
{% if msg %}
{{ msg }}
{% endif %}
{% for inv in invoices %} {% endfor %}
FactuurnummerOpdrachtgeverPeriodeSubtotaalBTWTotaalStatusActies
{{ inv.invoice_number }}{{ inv.client }} {{ inv.period_year }}-{{ '%02d' % inv.period_month }} {{ fmt(inv.subtotal) }}{{ fmt(inv.btw) }}{{ fmt(inv.total) }}
👁️

Totaal gefactureerd

{{ fmt(total_invoiced) }}

Betaald

{{ fmt(total_paid) }}

Openstaand

{{ fmt(total_open) }}
{% endblock %} """) INVOICE_GENERATE_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Factuur genereren
🚪 Uitloggen

Factuur genereren

{% if error %}
{{ error }}
{% endif %}
Annuleren
{% if preview %}

Preview: {{ preview.client }} — {{ preview.year }}-{{ '%02d' % preview.month }}

{{ preview.count }} urenposten, {{ preview.total_hours|round(1) }} uur, subtotaal {{ fmt(preview.subtotal) }}

{% endif %}
{% endblock %} """) INVOICE_VIEW_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Factuur {{ inv.invoice_number }}
🚪 Uitloggen

Factuur {{ inv.invoice_number }}

← Terug
{{ company_name }}
{{ company_address }}
KvK: {{ company_kvk }}
BTW: {{ company_btw }}
FACTUUR
{{ inv.invoice_number }}
{{ inv.invoice_date }}

Status: {{ inv.status }}
Opdrachtgever:
{{ inv.client }}
{{ client_address }}
{% for line in lines %} {% endfor %}
OmschrijvingUrenTariefBedrag
{{ line.description }}{{ line.hours }}{{ fmt(line.rate) }}{{ fmt(line.amount) }}
Subtotaal{{ fmt(inv.subtotal) }}
BTW 21%%{{ fmt(inv.btw) }}
Totaal{{ fmt(inv.total) }}
Betalingsvoorwaarden: {{ payment_terms }} dagen
Bank: {{ company_bank }}
Vervaldatum: {{ inv.due_date }}
{% endblock %} """) # ── Expenses ──────────────────────────────────────────────────────────────── EXPENSES_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Kosten
🚪 Uitloggen

Kosten

+ Kosten toevoegen
{% if msg %}
{{ msg }}
{% endif %}
{% for e in expenses %} {% endfor %}
DatumCategorieOmschrijvingExcl. BTWBTWTotaalActies
{{ e.date }}{{ e.category }}{{ e.description or '' }} {{ fmt(e.amount_excl) }}{{ fmt(e.btw) }}{{ fmt(e.total) }} ✏️

Kosten dit jaar

{{ fmt(total_expenses) }}

BTW op kosten

{{ fmt(total_btw) }}

Netto kosten

{{ fmt(total_expenses - total_btw) }}

Jaaroverzicht {{ year }}

{% for m in monthly %} {% endfor %}
MaandOmzetKostenWinst
{{ m.label }}{{ fmt(m.revenue) }}{{ fmt(m.expenses) }}{{ fmt(m.profit) }}
{% endblock %} """) EXPENSE_FORM_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
{{ 'Kosten bewerken' if edit else 'Kosten toevoegen' }}
🚪 Uitloggen

{{ 'Kosten bewerken' if edit else 'Kosten toevoegen' }}

{% if error %}
{{ error }}
{% endif %}
Annuleren
{% endblock %} """) # ── BTW ───────────────────────────────────────────────────────────────────── BTW_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
BTW-overzicht
🚪 Uitloggen

BTW-overzicht {{ year }}

{% for q in quarters %} {% endfor %}
KwartaalBTW op facturenBTW op kostenNetto verschilDeadlineStatusActie
Q{{ q.quarter }} {{ fmt(q.btw_in) }}{{ fmt(q.btw_out) }} {{ fmt(q.net) }} {{ q.deadline }} {{ q.status }}
{% endblock %} """) # ── Settings ──────────────────────────────────────────────────────────────── SETTINGS_TMPL = LAYOUT.replace('{% block body %}{% endblock %}', """ {% block body %}
Instellingen
🚪 Uitloggen

Instellingen

{% if msg %}
{{ msg }}
{% endif %}

Bedrijfsgegevens

Tarieven & Voorwaarden

{% endblock %} """) # ════════════════════════════════════════════════════════════════════════════ # ROUTES # ════════════════════════════════════════════════════════════════════════════ @app.route('/zzp/login', methods=['GET','POST']) def login(): if request.method == 'POST': r = get_db().execute("SELECT * FROM users WHERE username=?", (request.form['username'],)).fetchone() if r and check_password_hash(r['password_hash'], request.form['password']): session.permanent = True session['user'] = r['username'] return redirect(url_for('dashboard')) return render_template_string(LOGIN_TMPL, error='Ongeldige inloggegevens') return render_template_string(LOGIN_TMPL, error=None) @app.route('/zzp/logout') def logout(): session.clear() return redirect(url_for('login')) # ── Dashboard ─────────────────────────────────────────────────────────────── @app.route('/zzp/') @login_required def dashboard(): db = get_db() year = datetime.now().year # Hours r = db.execute("SELECT COALESCE(SUM(hours),0) as h FROM timesheets WHERE date LIKE ?", (f"{year}%",)).fetchone() total_hours = r['h'] r = db.execute("SELECT COALESCE(SUM(hours),0) as h FROM timesheets WHERE date LIKE ? AND billable=1", (f"{year}%",)).fetchone() billable_hours = r['h'] overhead_hours = total_hours - billable_hours pct = (total_hours / 1225) * 100 if total_hours else 0 # Invoices open_inv = db.execute("SELECT COUNT(*) as c FROM invoices WHERE status IN ('Verstuurd','Over tijdig') AND invoice_date LIKE ?", (f"{year}%",)).fetchone()['c'] # Revenue & expenses rev = db.execute("SELECT COALESCE(SUM(total),0) as t FROM invoices WHERE status='Betaald' AND invoice_date LIKE ?", (f"{year}%",)).fetchone()['t'] exp = db.execute("SELECT COALESCE(SUM(total),0) as t FROM expenses WHERE date LIKE ?", (f"{year}%",)).fetchone()['t'] profit = rev - exp btw_reserve = calc_btw_reserve() # Recent recent = db.execute("SELECT * FROM timesheets ORDER BY date DESC LIMIT 5").fetchall() # Alerts alerts = [] overdue = db.execute("SELECT invoice_number, due_date FROM invoices WHERE status='Verstuurd' AND due_date < date('now')").fetchall() for o in overdue: alerts.append({'text': f"⚠️ Factuur {o['invoice_number']} is achterstallig ( vervaldatum {o['due_date']})", 'style': 'color:%s' % C['danger']}) # BTW deadline now = datetime.now() q = (now.month - 1) // 3 + 1 deadlines = {1: '30 april', 2: '31 juli', 3: '31 oktober', 4: '31 januari'} btws = db.execute("SELECT * FROM btw_quarters WHERE year=? AND quarter=? AND status='Nog doen'", (year, q)).fetchall() if btws: alerts.append({'text': f"📋 BTW Q{q} deadline: {deadlines[q]}", 'style': 'color:%s' % C['warning']}) data = dict(total_hours=total_hours, billable_hours=billable_hours, overhead_hours=overhead_hours, pct=pct, open_invoices=open_inv, profit=profit, btw_reserve=btw_reserve) return render_template_string(DASHBOARD_TMPL, data=data, recent=recent, alerts=alerts, fmt=fmt_eur) # ── Timesheets ────────────────────────────────────────────────────────────── @app.route('/zzp/timesheets') @login_required def timesheets(): db = get_db() year = datetime.now().year rows = db.execute("SELECT * FROM timesheets WHERE date LIKE ? ORDER BY date DESC", (f"{year}%",)).fetchall() r = db.execute("SELECT COALESCE(SUM(hours),0) as h FROM timesheets WHERE date LIKE ?", (f"{year}%",)).fetchone() total = r['h'] r = db.execute("SELECT COALESCE(SUM(hours),0) as h FROM timesheets WHERE date LIKE ? AND billable=1", (f"{year}%",)).fetchone() billable = r['h'] months = sorted(set(r['date'][:7] for r in rows), reverse=True) if rows else [] return render_template_string(TIMESHEETS_TMPL, timesheets=rows, total_hours=total, billable_hours=billable, months=months, msg=request.args.get('msg')) @app.route('/zzp/timesheets/add', methods=['GET','POST']) @login_required def timesheet_add(): if request.method == 'POST': get_db().execute("INSERT INTO timesheets (date,client,activity,hours,billable,note) VALUES (?,?,?,?,?,?)", (request.form['date'], request.form['client'], request.form['activity'], float(request.form['hours']), int(request.form.get('billable',1)), request.form.get('note',''))) get_db().commit() return redirect(url_for('timesheets', msg='Uren toegevoegd')) return render_template_string(TIMESHEET_FORM_TMPL, edit=False, ts=None, today=datetime.now().strftime('%Y-%m-%d')) @app.route('/zzp/timesheets/edit/', methods=['GET','POST']) @login_required def timesheet_edit(tid): db = get_db() if request.method == 'POST': db.execute("UPDATE timesheets SET date=?,client=?,activity=?,hours=?,billable=?,note=? WHERE id=?", (request.form['date'], request.form['client'], request.form['activity'], float(request.form['hours']), int(request.form.get('billable',1)), request.form.get('note',''), tid)) db.commit() return redirect(url_for('timesheets', msg='Uren bijgewerkt')) ts = db.execute("SELECT * FROM timesheets WHERE id=?", (tid,)).fetchone() return render_template_string(TIMESHEET_FORM_TMPL, edit=True, ts=ts, today=ts['date']) @app.route('/zzp/timesheets/delete/', methods=['POST']) @login_required def timesheet_delete(tid): get_db().execute("DELETE FROM timesheets WHERE id=?", (tid,)) get_db().commit() return redirect(url_for('timesheets', msg='Uren verwijderd')) # ── Invoices ──────────────────────────────────────────────────────────────── @app.route('/zzp/invoices') @login_required def invoices(): db = get_db() invs = db.execute("SELECT * FROM invoices ORDER BY id DESC").fetchall() total_invoiced = db.execute("SELECT COALESCE(SUM(total),0) as t FROM invoices").fetchone()['t'] total_paid = db.execute("SELECT COALESCE(SUM(total),0) as t FROM invoices WHERE status='Betaald'").fetchone()['t'] return render_template_string(INVOICES_TMPL, invoices=invs, fmt=fmt_eur, total_invoiced=total_invoiced, total_paid=total_paid, total_open=total_invoiced - total_paid, msg=request.args.get('msg')) @app.route('/zzp/invoices/generate', methods=['GET','POST']) @login_required def invoice_generate(): db = get_db() if request.method == 'POST': client = request.form['client'] year = int(request.form['year']) month = int(request.form['month']) inv_date = request.form['invoice_date'] prefix = client_prefix(client) rate_key = f'rate_{client.lower().replace(" ","_")}' rate = float(get_setting(rate_key, '100')) # Get billable hours for this period rows = db.execute("SELECT activity, SUM(hours) as hours FROM timesheets WHERE client=? AND billable=1 AND date LIKE ? GROUP BY activity", (client, f"{year}-{month:02d}%")).fetchall() if not rows: return render_template_string(INVOICE_GENERATE_TMPL, error='Geen facturabele uren gevonden voor deze periode/opdrachtgever.', year=year, month=month, today=inv_date, preview=None) inv_num = next_invoice_number(client, year) terms = int(get_setting('payment_terms','30')) due_date = (datetime.strptime(inv_date, '%Y-%m-%d') + timedelta(days=terms)).strftime('%Y-%m-%d') subtotal = sum(r['hours'] * rate for r in rows) btw = subtotal * 0.21 total = subtotal + btw db.execute("INSERT INTO invoices (invoice_number,client,period_year,period_month,invoice_date,due_date,subtotal,btw,total) VALUES (?,?,?,?,?,?,?,?,?)", (inv_num, client, year, month, inv_date, due_date, subtotal, btw, total)) inv_id = db.execute("SELECT last_insert_rowid()").fetchone()[0] for r in rows: db.execute("INSERT INTO invoice_lines (invoice_id,description,hours,rate,amount) VALUES (?,?,?,?,?)", (inv_id, r['activity'], r['hours'], rate, r['hours'] * rate)) db.commit() return redirect(url_for('invoices', msg=f'Factuur {inv_num} gegenereerd')) today = datetime.now().strftime('%Y-%m-%d') return render_template_string(INVOICE_GENERATE_TMPL, error=None, year=datetime.now().year, month=datetime.now().month, today=today, preview=None) @app.route('/zzp/invoices/view/') @login_required def invoice_view(iid): db = get_db() inv = db.execute("SELECT * FROM invoices WHERE id=?", (iid,)).fetchone() lines = db.execute("SELECT * FROM invoice_lines WHERE invoice_id=?", (iid,)).fetchall() client_addr_key = f'client_{inv["client"].lower().replace(" ","_")}_address' client_addr = get_setting(client_addr_key, '') return render_template_string(INVOICE_VIEW_TMPL, inv=inv, lines=lines, fmt=fmt_eur, company_name=get_setting('company_name'), company_address=get_setting('company_address'), company_kvk=get_setting('company_kvk'), company_btw=get_setting('company_btw'), company_bank=get_setting('company_bank'), payment_terms=get_setting('payment_terms','30'), client_address=client_addr) @app.route('/zzp/invoices/status/', methods=['POST']) @login_required def invoice_status(iid): get_db().execute("UPDATE invoices SET status=? WHERE id=?", (request.form['status'], iid)) get_db().commit() return redirect(url_for('invoices')) @app.route('/zzp/invoices/delete/', methods=['POST']) @login_required def invoice_delete(iid): db = get_db() db.execute("DELETE FROM invoice_lines WHERE invoice_id=?", (iid,)) db.execute("DELETE FROM invoices WHERE id=?", (iid,)) db.commit() return redirect(url_for('invoices', msg='Factuur verwijderd')) # ── Expenses ──────────────────────────────────────────────────────────────── EXPENSE_CATEGORIES = ['Boekhouper','Verzekeringen','Reiskosten','Software','Hardware','Opleiding','Kantoor','Overig'] @app.route('/zzp/expenses') @login_required def expenses(): db = get_db() year = datetime.now().year rows = db.execute("SELECT * FROM expenses WHERE date LIKE ? ORDER BY date DESC", (f"{year}%",)).fetchall() total_exp = db.execute("SELECT COALESCE(SUM(total),0) as t FROM expenses WHERE date LIKE ?", (f"{year}%",)).fetchone()['t'] total_btw_exp = db.execute("SELECT COALESCE(SUM(btw),0) as t FROM expenses WHERE date LIKE ?", (f"{year}%",)).fetchone()['t'] # Monthly overview monthly = [] for m in range(1,13): label = f"{year}-{m:02d}" rev = db.execute("SELECT COALESCE(SUM(subtotal),0) as t FROM invoices WHERE invoice_date LIKE ?", (f"{label}%",)).fetchone()['t'] exp_m = db.execute("SELECT COALESCE(SUM(total),0) as t FROM expenses WHERE date LIKE ?", (f"{label}%",)).fetchone()['t'] monthly.append({'label': label, 'revenue': rev, 'expenses': exp_m, 'profit': rev - exp_m}) return render_template_string(EXPENSES_TMPL, expenses=rows, total_expenses=total_exp, total_btw=total_btw_exp, monthly=monthly, year=year, fmt=fmt_eur, msg=request.args.get('msg')) @app.route('/zzp/expenses/add', methods=['GET','POST']) @login_required def expense_add(): if request.method == 'POST': excl = float(request.form['amount_excl']) btw = float(request.form.get('btw','0')) get_db().execute("INSERT INTO expenses (date,category,description,amount_excl,btw,total) VALUES (?,?,?,?,?,?)", (request.form['date'], request.form['category'], request.form.get('description',''), excl, btw, excl + btw)) get_db().commit() return redirect(url_for('expenses', msg='Kosten toegevoegd')) return render_template_string(EXPENSE_FORM_TMPL, edit=False, exp=None, today=datetime.now().strftime('%Y-%m-%d'), categories=EXPENSE_CATEGORIES) @app.route('/zzp/expenses/edit/', methods=['GET','POST']) @login_required def expense_edit(eid): db = get_db() if request.method == 'POST': excl = float(request.form['amount_excl']) btw = float(request.form.get('btw','0')) db.execute("UPDATE expenses SET date=?,category=?,description=?,amount_excl=?,btw=?,total=? WHERE id=?", (request.form['date'], request.form['category'], request.form.get('description',''), excl, btw, excl + btw, eid)) db.commit() return redirect(url_for('expenses', msg='Kosten bijgewerkt')) exp = db.execute("SELECT * FROM expenses WHERE id=?", (eid,)).fetchone() return render_template_string(EXPENSE_FORM_TMPL, edit=True, exp=exp, today=exp['date'], categories=EXPENSE_CATEGORIES) @app.route('/zzp/expenses/delete/', methods=['POST']) @login_required def expense_delete(eid): get_db().execute("DELETE FROM expenses WHERE id=?", (eid,)) get_db().commit() return redirect(url_for('expenses', msg='Kosten verwijderd')) # ── BTW ───────────────────────────────────────────────────────────────────── @app.route('/zzp/btw') @login_required def btw(): db = get_db() year = datetime.now().year quarters = [] deadlines_map = {1: '30 april', 2: '31 juli', 3: '31 oktober', 4: '31 januari'} for q in range(1,5): m_start = (q-1)*3+1 m_end = q*3 patterns = [f"{year}-{m:02d}%" for m in range(m_start, m_end+1)] btw_in = 0 btw_out = 0 for p in patterns: r = db.execute("SELECT COALESCE(SUM(btw),0) as t FROM invoices WHERE invoice_date LIKE ?", (p,)).fetchone() btw_in += r['t'] r = db.execute("SELECT COALESCE(SUM(btw),0) as t FROM expenses WHERE date LIKE ?", (p,)).fetchone() btw_out += r['t'] r = db.execute("SELECT * FROM btw_quarters WHERE year=? AND quarter=?", (year, q)).fetchone() status = r['status'] if r else 'Nog doen' quarters.append({'quarter': q, 'btw_in': btw_in, 'btw_out': btw_out, 'net': btw_in - btw_out, 'deadline': deadlines_map[q], 'status': status}) return render_template_string(BTW_TMPL, quarters=quarters, year=year, fmt=fmt_eur) @app.route('/zzp/btw/toggle//', methods=['POST']) @login_required def btw_toggle(year, quarter): db = get_db() r = db.execute("SELECT * FROM btw_quarters WHERE year=? AND quarter=?", (year, quarter)).fetchone() if r: new_status = 'Nog doen' if r['status'] == 'Gedaan' else 'Gedaan' db.execute("UPDATE btw_quarters SET status=?, filed_at=? WHERE year=? AND quarter=?", (new_status, datetime.now().isoformat() if new_status=='Gedaan' else None, year, quarter)) else: db.execute("INSERT INTO btw_quarters (year,quarter,status) VALUES (?,?,?)", (year, quarter, 'Gedaan')) db.commit() return redirect(url_for('btw')) # ── Settings ──────────────────────────────────────────────────────────────── SETTINGS_KEYS = ['company_name','company_address','company_kvk','company_btw','company_bank', 'rate_phoenix_metals','rate_club_of_engineers','rate_overig','payment_terms', 'client_phoenix_metals_address','client_club_of_engineers_address','client_overig_address'] @app.route('/zzp/settings', methods=['GET','POST']) @login_required def settings_page(): if request.method == 'POST': for k in SETTINGS_KEYS: if k in request.form: set_setting(k, request.form[k]) return render_template_string(SETTINGS_TMPL, msg='Instellingen opgeslagen', s={k: get_setting(k) for k in SETTINGS_KEYS}) return render_template_string(SETTINGS_TMPL, msg=None, s={k: get_setting(k) for k in SETTINGS_KEYS}) # ── Run ───────────────────────────────────────────────────────────────────── init_db() if __name__ == '__main__': print("=" * 50) print("ZZP Dashboard running on http://127.0.0.1:5060/") print("=" * 50) app.run(host='0.0.0.0', port=5065, debug=False)