#!/bin/bash

DB="company.db"

echo "Swiss corporation"
echo "================================"
echo

echo "Jahresabschluss"
echo "--------------------------------"

sqlite3 -header -column $DB "
SELECT
year AS Jahr,
income AS Einnahmen,
expenses AS Ausgaben,
profit AS Gewinn
FROM yearly_summary;
"

echo
echo "Ausgaben"
echo "--------------------------------"

sqlite3 -header -column $DB "
SELECT
name AS Konto,
total AS Betrag
FROM expense_report;
"

echo
echo "Bank"
echo "--------------------------------"

sqlite3 -header -column $DB "
SELECT
description AS Text,
amount AS Betrag
FROM bank;
"

echo
echo "Kontostand"
echo "--------------------------------"

sqlite3 $DB "
SELECT printf('%.2f CHF',SUM(amount))
FROM bank;
"