X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;ds=sidebyside;f=assistants%2Fstats%2Ffinancial.inc.php;h=fae0ee276f449b0445432a050791f8ce46f3cdbb;hb=8248c7125a50c5fe61f4ac95046e1ab2fc5379e6;hp=e67e0676609067f91ffc8ef051cb777d4348af91;hpb=f3fca77c92e403dfe746a72ab3d24ad326f96de9;p=mirrors%2FSokoMan.git

diff --git a/assistants/stats/financial.inc.php b/assistants/stats/financial.inc.php
index e67e067..fae0ee2 100644
--- a/assistants/stats/financial.inc.php
+++ b/assistants/stats/financial.inc.php
@@ -26,11 +26,13 @@ $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)
 				-(SELECT SUM(item_price_in) FROM item WHERE item_valid_till=0$month_sql_bought)
 			) FROM item WHERE item_valid_till=0 AND ( status_id = 3 )$month_sql_sold",
+	"Zapůjčený HW dle LMS id"
+		=> 'SELECT item_customer, SUM(item_price_in) FROM item WHERE status_id=6 AND item_valid_till=0 GROUP BY item_customer ORDER BY SUM(item_price_in) DESC;'
 );