X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Fservice.infodrom.org;a=blobdiff_plain;f=src%2FInfoCon%2Fbuch%2Findex.wml;h=8665361b584f3a65b84f74934b464fff90431e02;hp=3579415dd49eed094a752d769ea107053af86d74;hb=f029e97408bd1747789ce44a33b2ebdf3a70428a;hpb=1642e509ab6e3b42de5bc5d83e7587031065663e

diff --git a/src/InfoCon/buch/index.wml b/src/InfoCon/buch/index.wml
index 3579415..8665361 100644
--- a/src/InfoCon/buch/index.wml
+++ b/src/InfoCon/buch/index.wml
@@ -19,16 +19,35 @@
     printf ("<option value=\"%s\">%s", $cat['category'], $cat['category']);
   }
 ?></select><br>
+<b>Währung</b>: <input type=radio name=currency value=eur checked> Euro <input type=radio name=currency value=dm> DM<br>
 <b>Zahlung</b>: <input type=checkbox name=input value=1 checked> Einnahmen <input type=checkbox name=output value=1 checked> Ausgaben<br>
 
 <p><center><input type=submit value="Query"> <input type=reset value="Reset"></center><p>
 </form>
 
 <?
-  $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 ORDER BY date,nr";
+  $form = 0;
+  $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 ORDER BY date,nr";
   $sth = pg_exec ($dbh, $query);
 
   if (pg_NumRows ($sth) > 0) {
+    $form = 1;
+    echo ("<h3>Nicht bezahlte Rechnungen</h3>");
+    echo ("<form method=\"POST\" action=\"pay.php3\">");
+  }
+
+  for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
+    $row = pg_fetch_array ($sth, $nr);
+    $date = substr ($row['date'],6,2) . "." . substr ($row['date'],4,2) . "." . substr ($row['date'],0,4);
+    printf (" <input type=\"checkbox\" name=\"pay_dm_%d\" value=\"1\">", $row['nr']);
+    printf ("%d. %s %s (%.2f&nbsp;DM)<br>", $row['nr'], $date, $row['description'], $row['price']);
+  }
+
+  $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 ORDER BY date,nr";
+  $sth = pg_exec ($dbh, $query);
+
+  if (!form && pg_NumRows ($sth) > 0) {
+    $form = 1;
     echo ("<h3>Nicht bezahlte Rechnungen</h3>");
     echo ("<form method=\"POST\" action=\"pay.php3\">");
   }
@@ -37,10 +56,10 @@
     $row = pg_fetch_array ($sth, $nr);
     $date = substr ($row['date'],6,2) . "." . substr ($row['date'],4,2) . "." . substr ($row['date'],0,4);
     printf (" <input type=\"checkbox\" name=\"pay_%d\" value=\"1\">", $row['nr']);
-    printf ("%d. %s %s (%.2f)<br>", $row['nr'], $date, $row['description'], $row['price']);
+    printf ("%d. %s %s (%.2f&nbsp;&euro;)<br>", $row['nr'], $date, $row['description'], $row['price']);
   }
 
-  if (pg_NumRows ($sth) > 0) {
+  if ($form > 0) {
     echo ("<p><input type=\"submit\" value=\"Bezahlen\"> <input type=\"reset\" value=\"Reset\"><p>");
     echo ("</form>");
   }