GIT.Harvie.CZ
/
mirrors
/
SokoMan.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Oprava nekterych veci rozbitych pri prechodu na novy system carovych kodu
[mirrors/SokoMan.git]
/
assistants
/
stats
/
stock.inc.php
diff --git
a/assistants/stats/stock.inc.php
b/assistants/stats/stock.inc.php
index 1cec846ed47eb4d7e572938fe4c2e942f479e95d..82eb2bc8579aabb65d5d2bfb35f2d7aa8771a255 100644
(file)
--- a/
assistants/stats/stock.inc.php
+++ b/
assistants/stats/stock.inc.php
@@
-1,7
+1,7
@@
<?php
$queries += array(
"Ceník + Počet kusů skladem (PriceList + Stock)"
<?php
$queries += array(
"Ceník + Počet kusů skladem (PriceList + Stock)"
- => 'SELECT room_id,room_name,model_id,model_name,
model_barcod
e,model_price_out,COUNT(item_id),SUM(item_quantity)'.
+ => 'SELECT room_id,room_name,model_id,model_name,
barcode_nam
e,model_price_out,COUNT(item_id),SUM(item_quantity)'.
' FROM item LEFT JOIN barcode USING(barcode_id) LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'.
' WHERE item_valid_till=0 AND status_id=1'.
' GROUP BY model_id,room_id'.
' FROM item LEFT JOIN barcode USING(barcode_id) LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'.
' WHERE item_valid_till=0 AND status_id=1'.
' GROUP BY model_id,room_id'.
This page took
0.097307 seconds
and
4
git commands to generate.