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 if ($_POST['name_' . $row['blz_kto']] != $row['name'] ||
26 ($_POST['display_' . $row['blz_kto']] ? 1 : 0) != $row['display']) {
27 $query = sprintf ("UPDATE account_names SET name='%s',display=%d,sys_user='%s',sys_edit=now() WHERE blz_kto = '%s'",
28 $_POST['name_' . $row['blz_kto']],
29 $_POST['display_' . $row['blz_kto']] ? 1 : 0,
30 $_SERVER['REMOTE_USER'],
33 pg_exec ($dbh, $query);
34 $output = "Kontoinformationen aktualisiert.";
37 } elseif ($_POST[formtype] == "newaccount") {
38 if (isset($_POST['blz']) && isset($_POST['kto']) && isset($_POST['name'])) {
39 $query = sprintf ("INSERT INTO account_names (blz_kto,name,display,sys_user,sys_edit) ".
40 "VALUES ('%s:%s','%s',1,'%s',now())",
44 $_SERVER['REMOTE_USER']);
45 pg_exec ($dbh, $query);
47 $query = sprintf ("INSERT INTO account (blz_kto,statement,datum,from_to,descr,category,value_eur,sys_user,sys_edit) ".
48 "VALUES ('%s:%s','%s','%s','Account Administration','Initial Zero Statement','Miscellaneous',0.0,'%s',now())",
53 $_SERVER['REMOTE_USER']);
54 pg_exec ($dbh, $query);
56 $output = "Neues Konto erstellt.";
58 $output = "Nicht ausreichend Informationen gegeben.";
64 if ((strlen ($_POST[currency]) > 0) && ($_POST[currency] == "dm")) {
65 $table = "account_dm";
69 if (strlen ($_POST[category]) == 0 && strlen ($_POST[newcategory]) > 0) {
70 $category = $_POST[newcategory];
72 $category = $_POST[category];
74 if (strlen ($_POST[from_to]) == 0 && strlen ($_POST[newfrom_to]) > 0) {
75 $from_to = $_POST[newfrom_to];
77 $from_to = $_POST[from_to];
79 $statement = sql_prepare ($_POST[statement]);
80 $category = sql_prepare ($category);
81 $descr = sql_prepare (trim($_POST[descr]));
82 $from_to = sql_prepare ($from_to);
84 $date = form_to_yyyymmdd ($_POST[datum]);
86 $value = ereg_replace (",",".", $_POST[value]);
88 if (isset($_POST[id]) && $_POST[id] > 0 && strlen ($_POST[delete])) {
89 $query = sprintf("DELETE FROM %s WHERE id = %d", $table, $_POST[id]);
90 $output = "Posten gelöscht.";
91 } elseif (isset($_POST[id]) && $_POST[id] > 0) {
92 $query = sprintf("UPDATE %s SET datum='%s',statement='%s',from_to='%s',descr='%s',category='%s',%s=%s,sys_user='%s',sys_edit=now() " .
101 $_SERVER['REMOTE_USER'],
103 $output = "Posten aktualisiert.";
105 $query = sprintf("INSERT INTO %s (blz_kto,datum,statement,from_to,descr,category,%s,sys_user,sys_edit) ".
106 "VALUES ('%s','%s','%s','%s','%s','%s',%s,'%s',now())",
115 $_SERVER['REMOTE_USER']);
116 $output = "Neuen Posten aufgenommen.";
117 $output .= sprintf('</p><p><a href="edit.php?blzkto=%s">Weiteren Posten aufnehmen</a>', $_POST['blzkto']);
119 $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
122 echo ("<p>".$output."</p>");