From e7ffc208813f90877fb4787bc3947f01dd34b81f Mon Sep 17 00:00:00 2001 From: Thomas Mudrunka Date: Tue, 26 Mar 2013 16:15:35 +0100 Subject: [PATCH] Vypis stavu pro konkretni mesice --- assistants/stats/financial.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/assistants/stats/financial.inc.php b/assistants/stats/financial.inc.php index e67e067..92bc51b 100644 --- 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) -- 2.30.2