Opravena haluz s wishlistem
[mirrors/SokoMan.git] / assistants / stats / stock.inc.php
CommitLineData
049a7400
TM
1<?php
2$queries += array(
bfb8a227 3 "Ceník + Počet kusů skladem (PriceList + Stock)"
049a7400
TM
4 => 'SELECT room_id,room_name,model_id,model_name,model_barcode,model_price_out,COUNT(item_id),SUM(item_quantity)'.
5 ' FROM item LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'.
6 ' WHERE item_valid_till=0 AND status_id=1'.
7 ' GROUP BY model_id,room_id'.
8 ' ORDER BY room_id,model_id;',
9);
This page took 0.09196 seconds and 4 git commands to generate.