1 #include <infocon.style>
2 #include <phptools.inc>
5 <page func=InfoCon title="Kontoführung">
8 if ($_POST[formtype] == "admin" || $_POST[formtype] == "newaccount")
9 $ktoname = "Administration";
18 if ($_POST[formtype] == "admin") {
19 $query = "SELECT blz_kto,name,display FROM account_names ORDER BY name";
20 $sth = pg_exec ($dbh, $query);
22 for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
23 $row = pg_fetch_array ($sth, $nr);
25 $query = sprintf ("UPDATE account_names SET name='%s',display=%d,sys_user='%s',sys_edit=now() WHERE blz_kto = '%s'",
26 $_POST['name_' . $row['blz_kto']],
27 $_POST['display_' . $row['blz_kto']] ? 1 : 0,
28 $_SERVER['REMOTE_USER'],
31 pg_exec ($dbh, $query);
32 $output = "Kontoinformationen aktualisiert.";
34 } elseif ($_POST[formtype] == "newaccount") {
35 if (isset($_POST['blz']) && isset($_POST['kto']) && isset($_POST['name'])) {
36 $query = sprintf ("INSERT INTO account_names (blz_kto,name,display,sys_user,sys_edit) ".
37 "VALUES ('%s:%s','%s',1,'%s',now())",
41 $_SERVER['REMOTE_USER']);
42 pg_exec ($dbh, $query);
44 $query = sprintf ("INSERT INTO account (blz_kto,statement,datum,from_to,descr,category,value_eur,sys_user,sys_edit) ".
45 "VALUES ('%s:%s','%s','%s','Account Administration','Initial Zero Statement','Miscellaneous',0.0,'%s',now())",
50 $_SERVER['REMOTE_USER']);
51 pg_exec ($dbh, $query);
53 $output = "Neues Konto erstellt.";
55 $output = "Nicht ausreichend Informationen gegeben.";
61 if ((strlen ($_POST[currency]) > 0) && ($_POST[currency] == "dm")) {
62 $table = "account_dm";
66 if (strlen ($_POST[category]) == 0 && strlen ($_POST[newcategory]) > 0) {
67 $category = $_POST[newcategory];
69 $category = $_POST[category];
71 if (strlen ($_POST[from_to]) == 0 && strlen ($_POST[newfrom_to]) > 0) {
72 $from_to = $_POST[newfrom_to];
74 $from_to = $_POST[from_to];
76 $statement = sql_prepare ($_POST[statement]);
77 $category = sql_prepare ($category);
78 $descr = sql_prepare (trim($_POST[descr]));
79 $from_to = sql_prepare ($from_to);
81 $date = form_to_yyyymmdd ($_POST[datum]);
83 $value = ereg_replace (",",".", $_POST[value]);
85 if (isset($_POST[oid]) && $_POST[oid] > 0 && strlen ($_POST[delete])) {
86 $query = "DELETE FROM $table WHERE oid = $_POST[oid]";
87 $output = "Posten gelöscht.";
88 } elseif (isset($_POST[oid]) && $_POST[oid] > 0) {
89 $query = sprintf("UPDATE %s SET datum='%s',statement='%s',from_to='%s',descr='%s',category='%s',%s=%s,sys_user='%s',sys_edit=now() " .
98 $_SERVER['REMOTE_USER'],
100 $output = "Posten aktualisiert.";
102 $query = sprintf("INSERT INTO %s (blz_kto,datum,statement,from_to,descr,category,%s,sys_user,sys_edit) ".
103 "VALUES ('%s','%s','%s','%s','%s','%s',%s,'%s',now())",
112 $_SERVER['REMOTE_USER']);
113 $output = "Neuen Posten aufgenommen.";
114 $output .= sprintf('</p><p><a href="edit.php?blzkto=%s">Weiteren Posten aufnehmen</a>', $_POST['blzkto']);
116 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
119 echo ("<p>".$output."</p>");