Commit | Line | Data |
---|---|---|
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 | ); |