GIT.Harvie.CZ / mirrors / SokoMan.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Mezisoučty v kase (sem zvědavej při kolika radcich se to vysere :-)
[mirrors/SokoMan.git] / assistants / bank.inc.php
diff --git a/assistants/bank.inc.php b/assistants/bank.inc.php
index 373e0a38579a63a31243196c1fe202a6746cd4a4..4c816cb975abda280ce8e85a5211986b7e7d93f9 100644 (file)
--- a/assistants/bank.inc.php
+++ b/assistants/bank.inc.php
@@ -2,6 +2,7 @@
 $bank_currency='Kč';
 global $bank_table;
 $bank_table='transaction';
+$recursive=true; //USE RECURSIVE QUERIES???
 
 function bank_name($name) {
        return strtolower(trim($name));
@@ -37,12 +38,22 @@ function bank_add_account($ctx, $name) {
        bank_transaction($ctx, $name, $name, "Created account \"$name\"");
 }
 
-function bank_get_total($ctx, $account, $string=false) {
+function bank_month_sql($ctx, $month=false) {
+       global $bank_table;
+       $month_sql = 'TRUE';
+       if(!is_bool($month)) {
+               $month_q = $ctx->db->quote($month);
+               $month_sql .= " AND DATE_FORMAT(${bank_table}_time, '%Y-%m') = ".$month_q;
+       }
+       return $month_sql;
+}
+
+function bank_get_total($ctx, $account, $month, $string=false) {
        global $bank_table;
        $account_sql=$ctx->db->quote($account);
-       $result = $ctx->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) FROM `${bank_table}` WHERE `${bank_table}_to`=$account_sql;");
+       $result = $ctx->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) FROM `${bank_table}` WHERE `${bank_table}_to`=$account_sql AND ".bank_month_sql($ctx,$month).';');
        $deposits = $result[0]["SUM(${bank_table}_amount)"];
-       $result = $ctx->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) FROM `${bank_table}` WHERE `${bank_table}_from`=$account_sql;");
+       $result = $ctx->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) FROM `${bank_table}` WHERE `${bank_table}_from`=$account_sql AND (".bank_month_sql($ctx,$month).');');
        $withdrawals = $result[0]["SUM(${bank_table}_amount)"];
        if($string) return "$deposits-$withdrawals";
        return $deposits-$withdrawals;
@@ -61,11 +72,11 @@ function bank_rename_account($ctx, $old, $new) {
        );
 }
 
-function bank_get_overview($ctx,$prefix='') {
+function bank_get_overview($ctx,$prefix='',$month=false) {
        global $bank_table;
        $accounts = bank_get_accounts($ctx);
        foreach($accounts as $acc) {
-               $total=bank_get_total($ctx, $acc);
+               $total=bank_get_total($ctx, $acc, $month);
                $overview['table'][]=array("${prefix}account"=>$acc,"${prefix}total"=>$total);
                $overview['array'][$acc]=$total;
        }
@@ -73,7 +84,7 @@ function bank_get_overview($ctx,$prefix='') {
 }
 
 if(isset($bank_json_only) && $bank_json_only) {
-       $overview=bank_get_overview($this);
+       $overview=bank_get_overview($this,'');
        die(json_encode(array(
                'overview'=>$overview['array']
        )));
@@ -82,15 +93,15 @@ if(isset($bank_json_only) && $bank_json_only) {
 if(isset($_POST['create_account'])) {
        $new_account=$_POST['account_name'];
        bank_add_account($this, $new_account);
-       $this->post_redirect_get("$URL_INTERNAL/admin","Účet '$new_account' byl vytvořen!");
+       $this->post_redirect_get("$URL_INTERNAL/admin","Účet <b>$new_account</b> byl vytvořen!");
 }
 if(isset($_POST['rename_account'])) {
        $new_account=$_POST['account_new'];
        $old_account=$_POST['account_old'];
        if(bank_rename_account($this, $_POST['account_old'], $_POST['account_new'])) {
-               $this->post_redirect_get("$URL_INTERNAL/admin","Účet '$old_account' byl přejmenován na '$new_account'!");
+               $this->post_redirect_get("$URL_INTERNAL/admin","Účet <b>$old_account</b> byl přejmenován na <b>$new_account</b>!");
        } else {
-               $this->post_redirect_get("$URL_INTERNAL/admin","Účet '$new_account' již existuje!", false);
+               $this->post_redirect_get("$URL_INTERNAL/admin","Účet <b>$new_account</b> již existuje!", false);
        }
 }
 if(isset($_POST['transaction'])) {
@@ -101,12 +112,20 @@ if(isset($_POST['transaction'])) {
        if(!is_numeric($amount) || $amount < 0) $this->post_redirect_get("$URL_INTERNAL?account=".$account_from,"Lze převádět jen kladné částky", true);
        if(strlen($comment)<4) $this->post_redirect_get("$URL_INTERNAL?account=".$account_from,"Komentář musí mít alespoň 4 znaky!",true);
        bank_transaction($this, $account_from, $account_to, $comment, $amount);
-       $this->post_redirect_get("$URL_INTERNAL?account=".$account_from,"Transakce byla provedena:<br />Převod $amount $bank_currency z účtu $account_from na účet $account_to.<br />($comment)");
+       $this->post_redirect_get("$URL_INTERNAL?account=".$account_from,"Transakce byla provedena:<br />Převod <b>$amount $bank_currency</b> z účtu <b>$account_from</b> na účet <b>$account_to</b>.<br />($comment)");
 }
 
+$month = isset($_GET['month']) ? $_GET['month'] : false;
+
 //bank_add_account($this, 'material');
 echo("<a href='$URL/'>Banka</a> - ");
-echo("<a href='$URL/admin'>Správa účtů - </a>");
+echo("<a href='$URL/admin'>Správa účtů</a> - ");
+echo('<span style="float:right;">');
+echo $this->html->form($URL, 'GET', array(
+  array('month',$month,'text',false,'','YYYY-MM:'),
+  array(false,'SELECT BY MONTH','submit')
+));
+echo('</span>');
 echo("Účty: <br />");
 $accounts = bank_get_accounts($this, $SUBPATH[0]=='admin');
 $lastaccount=false;
@@ -116,24 +135,25 @@ foreach($accounts as $account) {
        $lastaccount=$account;
 }
 
+
+
 switch($SUBPATH[0]) {
        default:
 
                if(!isset($_GET['account'])) {
-                       echo("<h1>Banka</h1>");
-                       echo ("<h2>Stav</h2>");
-           $result = $this->db->safe_query_fetch("SELECT COUNT(${bank_table}_amount) as troughput FROM ${bank_table};");
-                       echo("Transakcí: ".$result[0]['troughput']."<br />");
-           $result = $this->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) as troughput FROM ${bank_table};");
-                       echo("Obrat: ".$result[0]['troughput'].' '.$bank_currency);
-           $result = $this->db->safe_query_fetch("SELECT * FROM `${bank_table}` ORDER BY ${bank_table}_time DESC;");
-                       $overview=bank_get_overview($this,$bank_table.'_');
+                       echo("<h1>Banka $month</h1>");
+                       echo ("<h2>Stav $month</h2>");
+                       $result = $this->db->safe_query_fetch("SELECT COUNT(${bank_table}_amount) as troughput FROM ${bank_table} WHERE ".bank_month_sql($this,$month).';');
+                       echo("Transakcí $month: ".$result[0]['troughput']."<br />");
+                       $result = $this->db->safe_query_fetch("SELECT SUM(${bank_table}_amount) as troughput FROM ${bank_table} WHERE ".bank_month_sql($this,$month).';');
+                       echo("Obrat $month: ".$result[0]['troughput'].' '.$bank_currency);
+                       $result = $this->db->safe_query_fetch("SELECT * FROM `${bank_table}` WHERE ".bank_month_sql($this,$month)." ORDER BY ${bank_table}_time DESC;");
+                       $overview=bank_get_overview($this,$bank_table.'_',$month);
                        echo $this->html->render_item_table($overview['table'],'bank');
-                       echo ("<h2>Přehled transakcí</h2>");
                } else {
                        $account=bank_name($_GET['account']);
                        $account_sql=$this->db->quote($account);
-                       echo("<h1>Účet: ".$account." (".bank_get_total($this,$account).$bank_currency.")</h1>");
+                       echo("<h1>Účet: ".$account." $month (".bank_get_total($this,$account,$month).$bank_currency.")</h1>");
 
                        ?>
                        <form action="?" method="POST">
@@ -154,9 +174,14 @@ switch($SUBPATH[0]) {
                        </form>
                        <?php
 
-                       echo(bank_get_total($this,$account,true)." $bank_currency");
-           $result = $this->db->safe_query_fetch("SELECT * FROM `${bank_table}` WHERE `${bank_table}_to`=$account_sql OR `${bank_table}_from`=$account_sql ORDER BY ${bank_table}_time DESC;");
+                       echo(bank_get_total($this,$account,$month,true)." $bank_currency");
+                       $subtotal=$recursive?",(
+                               (SELECT SUM(${bank_table}_amount) FROM ${bank_table} x WHERE ${bank_table}_to=$account_sql AND x.${bank_table}_id<=${bank_table}.${bank_table}_id)
+                               -(SELECT SUM(${bank_table}_amount) FROM ${bank_table} x WHERE ${bank_table}_from=$account_sql AND x.${bank_table}_id<=${bank_table}.${bank_table}_id)
+                               ) as ${bank_table}_subtotal":'';
+                       $result = $this->db->safe_query_fetch("SELECT *${subtotal} FROM `${bank_table}` WHERE (`${bank_table}_to`=$account_sql OR `${bank_table}_from`=$account_sql) AND (".bank_month_sql($this,$month).") ORDER BY ${bank_table}_time DESC;"); //TADY
                }
+               echo ("<h2>Přehled transakcí $month</h2>");
                echo $this->html->render_item_table($result,$bank_table);
 
                break;
https://github.com/Harvie/SokoMan.git (mirrored @ Sat, 01 Jun 2024 04:10:11 +0200)
This page took 0.172437 seconds and 4 git commands to generate.