Commit | Line | Data |
---|---|---|
049a7400 TM |
1 | <?php |
2 | $queries += array( | |
bfb8a227 | 3 | "Ceník + Počet kusů skladem (PriceList + Stock)" |
7661315f | 4 | => 'SELECT room_id,room_name,model_id,model_name,barcode_name,model_price_out,COUNT(item_id),SUM(item_quantity)'. |
eca3fc1d | 5 | ' FROM item LEFT JOIN barcode USING(barcode_id) LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'. |
049a7400 TM |
6 | ' WHERE item_valid_till=0 AND status_id=1'. |
7 | ' GROUP BY model_id,room_id'. | |
eca3fc1d | 8 | ' ORDER BY room_id,model_id;' |
049a7400 | 9 | ); |