$add = "¤cy=dm";
}
- if (!isset($_GET[blzkto]) && isset($_GET[oid])) {
+ if (!isset($_GET[blzkto]) && isset($_GET[id])) {
pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
$query = "SELECT $table.blz_kto,datum,category,descr,from_to,statement,$value,name "
."FROM $table,account_names "
- ."WHERE $table.oid = $_GET[oid]";
+ ."WHERE $table.id = $_GET[id]";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {
<h3 class=bar><?=$row['name']?></h3>
<form method=post action="update.php">
-<input class=none type=hidden name=oid value="<? echo $_GET[oid]; ?>">
+<input class=none type="hidden" name="id" value="<? echo $_GET[id]; ?>">
<?
echo ("<input class=\"none\" type=\"hidden\" name=\"blzkto\" value=\"$blzkto\">");
echo $hidden;
<?
$query = "SELECT DISTINCT from_to FROM $table ";
- if (!isset($_GET[oid])) {
+ if (!isset($_GET[id])) {
$query .= "WHERE blz_kto = '$blzkto' AND datum >= now() - interval '2 years' ";
}
<textarea id=descr name=descr rows=5 cols=67><? echo $row['descr']; ?></textarea>
<p><center>
-<? if (isset ($_GET[oid])) { ?>
+<? if (isset ($_GET[id])) { ?>
<input class=button type=submit value="Update" tabindex=8>
<input class=button type=submit value="Delete" name=delete tabindex=9>
$where[] = "$value < 0.0";
}
- $query = "SELECT datum,oid,category,descr,$value FROM $table WHERE "
+ $query = "SELECT datum,id,category,descr,$value FROM $table WHERE "
. implode ($where, " AND ")
- . " ORDER BY datum,oid";
+ . " ORDER BY datum,id";
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
$sum = 0.0;
printf ("<tr class=\"t%d\">", $color);
printf ("<td width=\"10%%\" align=\"right\">%s</td>", $date);
printf ("<td width=\"10%%\" align=\"center\">%s</td>", $row['category']);
- printf ("<td width=\"70%%\"><a href=\"edit.php?oid=%d%s\">%s</a></td>",
- $row['oid'], $add, $descr[0]);
+ printf ("<td width=\"70%%\"><a href=\"edit.php?id=%d%s\">%s</a></td>",
+ $row['id'], $add, $descr[0]);
printf ("<td width=\"10%%\" align=\"right\" class=\"%s\">%5.2f</td>",
$row[$value]>0?"in":"out", $row[$value]);
$sum += $row[$value];
$value = ereg_replace (",",".", $_POST[value]);
- if (isset($_POST[oid]) && $_POST[oid] > 0 && strlen ($_POST[delete])) {
- $query = "DELETE FROM $table WHERE oid = $_POST[oid]";
+ if (isset($_POST[id]) && $_POST[id] > 0 && strlen ($_POST[delete])) {
+ $query = sprintf("DELETE FROM %s WHERE id = %d", $table, $_POST[id]);
$output = "Posten gelöscht.";
- } elseif (isset($_POST[oid]) && $_POST[oid] > 0) {
+ } elseif (isset($_POST[id]) && $_POST[id] > 0) {
$query = sprintf("UPDATE %s SET datum='%s',statement='%s',from_to='%s',descr='%s',category='%s',%s=%s,sys_user='%s',sys_edit=now() " .
- "WHERE oid = %d",
+ "WHERE id = %d",
$table,
$date,
$statement,
$category,
$field,$value,
$_SERVER['REMOTE_USER'],
- $_POST['oid']);
+ $_POST['id']);
$output = "Posten aktualisiert.";
} else {
$query = sprintf("INSERT INTO %s (blz_kto,datum,statement,from_to,descr,category,%s,sys_user,sys_edit) ".