X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Fservice.infodrom.org;a=blobdiff_plain;f=src%2FInfoCon%2Fbuch%2Flist.wml;h=041f78e33bbc8a9637c996bd5123b112bb3e3a0e;hp=6e2294e914d21154a9395c44a2770c2b1bafc9d0;hb=f029e97408bd1747789ce44a33b2ebdf3a70428a;hpb=1642e509ab6e3b42de5bc5d83e7587031065663e diff --git a/src/InfoCon/buch/list.wml b/src/InfoCon/buch/list.wml index 6e2294e..041f78e 100644 --- a/src/InfoCon/buch/list.wml +++ b/src/InfoCon/buch/list.wml @@ -15,11 +15,26 @@ pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!"); + if ($currency == "eur") { + $table = "sales"; + } elseif ($currency == "dm") { + $table = "sales_dm"; + } else { + die ("Unknown currency"); + } + if (strlen($year)) { # $where[] = "date >= '$year-01-01'"; # $year++; # $where[] = "date < '$year-01-01'"; $where[] = "date ~* '$year'"; + + # Implicit selection of currency + if ($year < 2002) { + $table = "sales_dm"; + } elseif ($year > 2001) { + $table = "sales"; + } } if (strlen($category)) { $where[] = "category = '$category'"; @@ -30,7 +45,7 @@ $where[] = "price < 0.0"; } - $query = "SELECT date,oid,category,description,price FROM sales "; + $query = "SELECT date,oid,category,description,price FROM $table "; if (count($where) > 0) { $query .= " WHERE " . implode ($where, " AND "); } @@ -51,8 +66,8 @@ printf ("