1 #include <infocon.style>
3 <page func=InfoCon title="Buchhaltung">
6 function dig ($dbh, $table, $id)
8 $query = sprintf ("SELECT date,description,price FROM %s WHERE nr = %d",
10 $sth = pg_exec ($dbh, $query);
12 if (pg_NumRows ($sth) > 0) {
13 $row = pg_fetch_array ($sth, 0);
16 if ($table == "sales_dm") {
19 $date = substr ($row['date'],6,2) . "." . substr ($row['date'],4,2) . "." . substr ($row['date'],0,4);
20 return sprintf ("<br>#%d: %s %s (%.2f %s)",
21 $id, $date, $row['description'], $row['price'], $cur);
26 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
27 or die("Unable to connect to SQL server");
29 $query = "SELECT nr FROM sales_dm WHERE paid=0";
30 $sth = pg_exec ($dbh, $query);
32 # Collect all to be paid entries
34 <protect>for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {</protect>
35 $row = pg_fetch_array ($sth, $nr);
37 $v = sprintf ("pay_dm_%d", $row['nr']);
39 $paydm[] = $row['nr'];
43 $query = "SELECT nr FROM sales WHERE paid=0";
44 $sth = pg_exec ($dbh, $query);
46 # Collect all to be paid entries
48 <protect>for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {</protect>
49 $row = pg_fetch_array ($sth, $nr);
51 $v = sprintf ("pay_%d", $row['nr']);
58 if (count ($paydm)>0) {
59 echo ("Folgende Buchungen werden bezahlt:<p>");
60 for ($i=0; $i < count ($paydm); $i++) {
61 $query = sprintf ("UPDATE sales_dm SET paid=1 WHERE nr = %d", $paydm[$i]);
63 echo (dig ($dbh, "sales_dm", $paydm[$i]));
64 $sth = pg_exec ($dbh, $query);
68 if (count ($pay) > 0) {
69 if (count ($pay) == 0) {
70 echo ("Folgende Buchungen werden bezahlt:<p>");
72 for ($i=0; $i < count ($pay); $i++) {
73 $query = sprintf ("UPDATE sales SET paid=1 WHERE nr = %d", $pay[$i]);
75 echo (dig ($dbh, "sales", $pay[$i]));
76 $sth = pg_exec ($dbh, $query);