4 function bank_name($name) {
5 return strtolower(trim($name));
8 function bank_transaction($ctx, $from, $to, $comment, $amount=0) {
9 $author=$ctx->db
->quote($ctx->db
->auth
->get_user_id());
10 $from=$ctx->db
->quote(bank_name($from));
11 $to=$ctx->db
->quote(bank_name($to));
12 $amount=$ctx->db
->quote($amount);
13 $comment=$ctx->db
->quote(trim($comment));
15 $sql="INSERT INTO `bank` (`bank_time`, `bank_from`, `bank_to`, `bank_amount`, `bank_author`, `bank_comment`) VALUES (now(), $from, $to, $amount, $author, $comment);";
16 $ctx->db
->safe_query($sql);
19 function bank_get_accounts($ctx, $all=false) {
20 $fetch = $ctx->db
->safe_query_fetch('SELECT DISTINCT bank_to FROM bank ORDER BY bank_to;');
21 foreach($fetch as $account) if($all ||
$account['bank_to'][0]!='_') $accounts[]=$account['bank_to'];
25 function bank_add_account($ctx, $name) {
26 bank_transaction($ctx, $name, $name, "Created account \"$name\"");
29 function bank_get_total($ctx, $account, $string=false) {
30 $account_sql=$ctx->db
->quote($account);
31 $result = $ctx->db
->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_to`=$account_sql;");
32 $deposits = $result[0]['SUM(bank_amount)'];
33 $result = $ctx->db
->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_from`=$account_sql;");
34 $withdrawals = $result[0]['SUM(bank_amount)'];
35 if($string) return "$deposits-$withdrawals";
36 return $deposits-$withdrawals;
38 function bank_rename_account($ctx, $old, $new) {
39 if(in_array($new, bank_get_accounts($ctx, true))) return false;
40 $old=$ctx->db
->quote($old);
41 $new=$ctx->db
->quote($new);
43 return $ctx->db
->safe_query(
45 "UPDATE bank SET `bank_to`=$new WHERE `bank_to`=$old;".
46 "UPDATE bank SET `bank_from`=$new WHERE `bank_from`=$old;".
51 function bank_get_overview($ctx) {
52 $accounts = bank_get_accounts($ctx);
53 foreach($accounts as $acc) $overview[]=array("bank_account"=>$acc,"bank_total"=>bank_get_total($ctx, $acc));
57 if(isset($_POST['create_account'])) {
58 bank_add_account($this, $_POST['account_name']);
59 $this->post_redirect_get("$URL_INTERNAL","Účet byl vytvořen");
61 if(isset($_POST['rename_account'])) {
62 if(bank_rename_account($this, $_POST['account_old'], $_POST['account_new'])) {
63 $this->post_redirect_get("$URL_INTERNAL","Účet byl upraven");
65 $this->post_redirect_get("$URL_INTERNAL","Takový účet již existuje!", false);
68 if(isset($_POST['transaction'])) {
69 if(!is_numeric($_POST['amount']) ||
$_POST['amount'] < 0) $this->post_redirect_get("$URL_INTERNAL?account=".$_POST['account_from'],"Lze převádět jen kladné částky", true);
70 $comment=trim($_POST['comment']);
71 if(strlen($comment)<4) $this->post_redirect_get("$URL_INTERNAL?account=".$_POST['account_from'],"Komentář musí mít alespoň 4 znaky!",true);
72 bank_transaction($this, $_POST['account_from'], $_POST['account_to'], $_POST['comment'], $_POST['amount']);
73 $this->post_redirect_get("$URL_INTERNAL?account=".$_POST['account_from'],"Transakce byla provedena");
76 //bank_add_account($this, 'material');
77 echo("<a href='$URL/'>Banka</a> - ");
78 echo("<a href='$URL/admin'>Správa účtů</a> - ");
80 $accounts = bank_get_accounts($this, $SUBPATH[0]=='admin');
81 foreach($accounts as $account) echo("<a href='$URL?account=$account'>$account</a>, ");
86 if(!isset($_GET['account'])) {
87 echo("<h1>Banka</h1>");
88 echo ("<h2>Stav</h2>");
89 $result = $this->db
->safe_query_fetch("SELECT COUNT(bank_amount) as troughput FROM bank;");
90 echo("Transakcí: ".$result[0]['troughput']."<br />");
91 $result = $this->db
->safe_query_fetch("SELECT SUM(bank_amount) as troughput FROM bank;");
92 echo("Obrat: ".$result[0]['troughput'].' '.$bank_currency);
93 $result = $this->db
->safe_query_fetch("SELECT * FROM `bank` ORDER BY bank_time DESC;");
94 echo $this->html
->render_item_table(bank_get_overview($this),'bank');
95 echo ("<h2>Přehled transakcí</h2>");
97 $account=bank_name($_GET['account']);
98 $account_sql=$this->db
->quote($account);
99 echo("<h1>Účet: ".$account." (".bank_get_total($this,$account).$bank_currency.")</h1>");
102 <form action
="?" method
="POST">
103 Převést
<input type
="number" name
="amount" value
="" /> <?php
echo $bank_currency; ?
>
104 z účtu
<?php
echo $account; ?
> <input type
="hidden" name
="account_from" value
="<?php echo $account; ?>" />
105 na účet
<select name
='account_to'>
106 <?php
foreach($accounts as $acc) echo("<option value='$acc'>$acc</option>"); ?
>
107 </select
> (pozor
, dluhy se převádí opačným směrem než peníze
!)<br
/><br
/>
108 Důvod
: <input type
="text" name
="comment" maxlength
="128" style
="width:64em;" />
109 <input type
="submit" name
="transaction" value
="Převést" />
113 echo(bank_get_total($this,$account,true)." $bank_currency");
114 $result = $this->db
->safe_query_fetch("SELECT * FROM `bank` WHERE `bank_to`=$account_sql OR `bank_from`=$account_sql ORDER BY bank_time DESC;");
116 echo $this->html
->render_item_table($result,'bank');
122 <form action
="<?php echo $ASSISTANT; ?>" method
="POST" >
124 <input type
="text" name
="account_name" />
125 <input type
="submit" name
="create_account" value
="Create account" />
127 <form action
="<?php echo $ASSISTANT; ?>" method
="POST" >
128 Account
: <select name
='account_old'>
129 <?php
foreach($accounts as $acc) echo("<option value='$acc'>$acc</option>"); ?
>
131 <input type
="text" name
="account_new" />
132 <input type
="submit" name
="rename_account" value
="Rename account" /> (účty začínající podtržítkem nebudou běžně viditelné
)