1 #include <infocon.style>
3 <page func=InfoCon title="Buchhaltung">
5 <form method=POST action=list.php3>
6 <input type=hidden name=blzkto value="<? echo $blzkto; ?>">
7 <b>Jahr</b>: <input name=year size=10 maxlength=4><br>
8 <b>Kategorie:</b> <select name=category>
11 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
12 or die("Unable to connect to SQL server");
14 $query = "SELECT DISTINCT category FROM sales ORDER BY category";
15 $sth = pg_exec ($dbh, $query);
17 for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
18 $cat = pg_fetch_array ($sth, $nr);
19 printf ("<option value=\"%s\">%s", $cat['category'], $cat['category']);
22 <b>Währung</b>: <input type=radio name=currency value=eur checked> Euro <input type=radio name=currency value=dm> DM<br>
23 <b>Zahlung</b>: <input type=checkbox name=input value=1 checked> Einnahmen <input type=checkbox name=output value=1 checked> Ausgaben<br>
25 <p><center><input type=submit value="Query"> <input type=reset value="Reset"></center><p>
30 $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 ORDER BY date,nr";
31 $sth = pg_exec ($dbh, $query);
33 if (pg_NumRows ($sth) > 0) {
35 echo ("<h3>Nicht bezahlte Rechnungen</h3>");
36 echo ("<form method=\"POST\" action=\"pay.php3\">");
39 for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
40 $row = pg_fetch_array ($sth, $nr);
41 $date = substr ($row['date'],6,2) . "." . substr ($row['date'],4,2) . "." . substr ($row['date'],0,4);
42 printf (" <input type=\"checkbox\" name=\"pay_dm_%d\" value=\"1\">", $row['nr']);
43 printf ("%d. %s %s (%.2f DM)<br>", $row['nr'], $date, $row['description'], $row['price']);
46 $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 ORDER BY date,nr";
47 $sth = pg_exec ($dbh, $query);
49 if (!form && pg_NumRows ($sth) > 0) {
51 echo ("<h3>Nicht bezahlte Rechnungen</h3>");
52 echo ("<form method=\"POST\" action=\"pay.php3\">");
55 for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
56 $row = pg_fetch_array ($sth, $nr);
57 $date = substr ($row['date'],6,2) . "." . substr ($row['date'],4,2) . "." . substr ($row['date'],0,4);
58 printf (" <input type=\"checkbox\" name=\"pay_%d\" value=\"1\">", $row['nr']);
59 printf ("%d. %s %s (%.2f €)<br>", $row['nr'], $date, $row['description'], $row['price']);
63 echo ("<p><input type=\"submit\" value=\"Bezahlen\"> <input type=\"reset\" value=\"Reset\"><p>");