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);
14 $comment=trim($comment);
15 if(strlen($comment)<4) die("Komentář musí mít alespoň 4 znaky!");
16 $comment=$ctx->db
->quote($comment);
18 $sql="INSERT INTO `bank` (`bank_time`, `bank_from`, `bank_to`, `bank_amount`, `bank_author`, `bank_comment`) VALUES (now(), $from, $to, $amount, $author, $comment);";
19 $ctx->db
->safe_query($sql);
22 function bank_get_accounts($ctx) {
23 $fetch = $ctx->db
->safe_query_fetch('SELECT DISTINCT bank_to FROM bank ORDER BY bank_to;');
24 foreach($fetch as $account) $accounts[]=$account['bank_to'];
28 function bank_add_account($ctx, $name) {
29 bank_transaction($ctx, $name, $name, "Created account \"$name\"");
32 function bank_get_total($ctx, $account, $string=false) {
33 $account_sql=$ctx->db
->quote($account);
34 $result = $ctx->db
->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_to`=$account_sql;");
35 $deposits = $result[0]['SUM(bank_amount)'];
36 $result = $ctx->db
->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_from`=$account_sql;");
37 $withdrawals = $result[0]['SUM(bank_amount)'];
38 if($string) return "$deposits-$withdrawals";
39 return $deposits-$withdrawals;
42 function bank_get_overview($ctx) {
43 $accounts = bank_get_accounts($ctx);
44 foreach($accounts as $acc) $overview[]=array("bank_account"=>$acc,"bank_total"=>bank_get_total($ctx, $acc));
48 if(isset($_POST['create_account'])) {
49 bank_add_account($this, $_POST['account_name']);
50 $this->post_redirect_get("$URL_INTERNAL","Účet byl vytvořen");
52 if(isset($_POST['transaction'])) {
53 if(!is_numeric($_POST['amount']) ||
$_POST['amount'] < 0) $this->post_redirect_get("$URL_INTERNAL","Lze převádět jen kladné částky", true);
54 bank_transaction($this, $_POST['account_from'], $_POST['account_to'], $_POST['comment'], $_POST['amount']);
55 $this->post_redirect_get("$URL_INTERNAL","Transakce byla provedena"); //TODO redirect na account_from
58 //bank_add_account($this, 'material');
59 echo("<a href='$URL/'>Banka</a> - ");
60 echo("<a href='$URL/admin'>Správa účtů</a> - ");
62 $accounts = bank_get_accounts($this);
63 foreach($accounts as $account) echo("<a href='$URL?account=$account'>$account</a>, ");
68 if(!isset($_GET['account'])) {
69 echo("<h1>Banka</h1>");
70 echo ("<h2>Stav</h2>");
71 $result = $this->db
->safe_query_fetch("SELECT COUNT(bank_amount) as troughput FROM bank;");
72 echo("Transakcí: ".$result[0]['troughput']."<br />");
73 $result = $this->db
->safe_query_fetch("SELECT SUM(bank_amount) as troughput FROM bank;");
74 echo("Obrat: ".$result[0]['troughput'].' '.$bank_currency);
75 $result = $this->db
->safe_query_fetch("SELECT * FROM `bank` ORDER BY bank_time DESC;");
76 echo $this->html
->render_item_table(bank_get_overview($this));
77 echo ("<h2>Přehled transakcí</h2>");
79 $account=bank_name($_GET['account']);
80 $account_sql=$this->db
->quote($account);
81 echo("<h1>Účet: ".$account." (".bank_get_total($this,$account).$bank_currency.")</h1>");
84 <form action
="?" method
="POST">
85 Převést
<input type
="number" name
="amount" value
="" /> <?php
echo $bank_currency; ?
>
86 z účtu
<?php
echo $account; ?
> <input type
="hidden" name
="account_from" value
="<?php echo $account; ?>" />
87 na účet
<select name
='account_to'>
88 <?php
foreach($accounts as $acc) echo("<option value='$acc'>$acc</option>"); ?
>
89 </select
> (pozor
, dluhy se převádí opačným směrem než peníze
!)<br
/><br
/>
90 Důvod
: <input type
="text" name
="comment" style
="width:64em;" />
91 <input type
="submit" name
="transaction" value
="Převést" />
95 echo(bank_get_total($this,$account,true)." $bank_currency");
96 $result = $this->db
->safe_query_fetch("SELECT * FROM `bank` WHERE `bank_to`=$account_sql OR `bank_from`=$account_sql ORDER BY bank_time DESC;");
98 $this->html
->table_hide_columns($result, 'bank');
99 echo $this->html
->render_item_table($result);
105 <form action
="<?php echo $ASSISTANT; ?>" method
="POST" >
107 <input type
="text" name
="account_name" />
108 <input type
="submit" name
="create_account" value
="Create account" />