query("SELECT k.id,
k.bezeichnung,
k.kontostand,
b.name AS bankname,
kb.name AS kontoinhaber,
k.darstellungsfarbe AS color
FROM konto k
JOIN kontotyp kt ON kt.id = k.kontotyp_id
JOIN bank b ON b.id = k.bank_id
JOIN kontobesitzer kb ON kb.id = k.kontobesitzer_id
ORDER BY k.id ASC;");
$kontos = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt = $pdo->query("SELECT SUM(kb.betrag) AS restguthaben,
m.name
FROM kontobewegung kb
JOIN monat m ON CAST(m.wert AS INT) = EXTRACT(MONTH FROM CURRENT_DATE)
WHERE kb.konto_id IN (1, 2)
AND EXTRACT(MONTH FROM kb.datum_ausgegeben) = EXTRACT(MONTH FROM CURRENT_DATE)
AND EXTRACT(YEAR FROM kb.datum_ausgegeben) = EXTRACT(YEAR FROM CURRENT_DATE)
AND COALESCE(kb.bei_restguthaben_ignorieren, false) <> true
GROUP BY m.name;;");
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$restguthaben = $row ? $row['restguthaben'] : 0;
$monat = $row ? $row['name'] : '';
?>
