Vypis stavu pro konkretni mesice

diff --git a/assistants/stats/financial.inc.php b/assistants/stats/financial.inc.php
index e67e0676609067f91ffc8ef051cb777d4348af91..92bc51b8300377256541139e3fa55d0a8b9886d2 100644 (file)
--- a/assistants/stats/financial.inc.php
+++ b/assistants/stats/financial.inc.php
@@ -26,8 +26,8 @@ $queries += array( //TODO: use build_query_select()!!!
                => 'SELECT COUNT(item_id),SUM(item_price_out),SUM(item_price_in),(SUM(item_price_out)-SUM(item_price_in)) as sale_profit FROM item WHERE item_valid_till=0 AND status_id = 3'.$month_sql_sold,
        "Skladem celkem $month"
                => 'SELECT COUNT(item_id),SUM(item_price_in) FROM item WHERE item_valid_till=0 AND status_id = 1'.$month_sql,
-       "Stavy (podrobně)"
-               => 'SELECT status_id, status_name, SUM(item_price_in), SUM(item_price_out) FROM status LEFT JOIN item USING(status_id) WHERE item_valid_till=0 GROUP BY status_id;',
+       "Stavy (podrobně) $month"
+               => 'SELECT status_id, status_name, SUM(item_price_in), SUM(item_price_out) FROM status LEFT JOIN item USING(status_id) WHERE item_valid_till=0'.$month_sql.' GROUP BY status_id;',
        "Bilance celkem =(prodej - všechny nákupy) $month"
                => "SELECT (
                                SUM(item_price_out)