X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=assistants%2Fbank.inc.php;h=670cfba8c2167e87536edafaf5cdce60601761a5;hb=98437b3bc357f5fed5b5c3a8fd2e04f5539b8901;hp=06a01557d154c4d7ade7f3a8a7e5eb904db84e19;hpb=273c1aac8c2c482b6b76779083c15d69d920e8ad;p=mirrors%2FSokoMan.git diff --git a/assistants/bank.inc.php b/assistants/bank.inc.php index 06a0155..670cfba 100644 --- a/assistants/bank.inc.php +++ b/assistants/bank.inc.php @@ -29,6 +29,22 @@ function bank_add_account($ctx, $name) { bank_transaction($ctx, $name, $name, "Created account \"$name\""); } +function bank_get_total($ctx, $account, $string=false) { + $account_sql=$ctx->db->quote($account); + $result = $ctx->db->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_to`=$account_sql;"); + $deposits = $result[0]['SUM(bank_amount)']; + $result = $ctx->db->safe_query_fetch("SELECT SUM(bank_amount) FROM `bank` WHERE `bank_from`=$account_sql;"); + $withdrawals = $result[0]['SUM(bank_amount)']; + if($string) return "$deposits-$withdrawals"; + return $deposits-$withdrawals; +} + +function bank_get_overview($ctx) { + $accounts = bank_get_accounts($ctx); + foreach($accounts as $acc) $overview[]=array("bank_account"=>$acc,"bank_total"=>bank_get_total($ctx, $acc)); + return $overview; +} + if(isset($_POST['create_account'])) { bank_add_account($this, $_POST['account_name']); $this->post_redirect_get("$URL_INTERNAL","ÃÄet byl vytvoÅen"); @@ -40,28 +56,29 @@ if(isset($_POST['transaction'])) { } //bank_add_account($this, 'material'); - echo("Banka - "); - echo("Správa úÄtů - "); - echo("ÃÄty: "); - $accounts = bank_get_accounts($this); - foreach($accounts as $account) echo("$account, "); +echo("Banka - "); +echo("Správa úÄtů - "); +echo("ÃÄty: "); +$accounts = bank_get_accounts($this); +foreach($accounts as $account) echo("$account, "); switch($SUBPATH[0]) { default: if(!isset($_GET['account'])) { echo("