-
-<define-tag account_overview>
-<?
- function account_names ($dbh, $display, $currency)
- {
- if ($currency == "eur")
- $table = "account";
- else
- $table = "account_dm";
-
- $query = "SELECT DISTINCT $table.blz_kto,name "
- ."FROM $table,account_names "
- ."WHERE $table.blz_kto = account_names.blz_kto "
- ."$display "
- ."ORDER BY name";
- $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
-
- $ret = array();
- for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
- $row = pg_fetch_array ($sth, $nr);
- $ret[$row['blz_kto']] = $row['name'];
- }
- return $ret;
- }
-
- function stand ($dbh,$blzkto,$currency)
- {
- if ($currency == "dm") {
- $query = "SELECT value_dm FROM account_dm WHERE blz_kto='$blzkto'";
- } elseif ($currency == "eur") {
- $query = "SELECT value_eur FROM account WHERE blz_kto='$blzkto'";
- } else {
- # Alert: unknown currency
- $query = '';
- }
- $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
-
- $sum = 0.0;
- for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
- $row = pg_fetch_array ($sth, $nr);
- $sum += $row[0];
- }
- return $sum;
- }
-?>
-</define-tag>