Commit | Line | Data |
---|---|---|
1 | <?php | |
2 | $queries += array( | |
3 | "Ceník + Počet kusů skladem" | |
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 | ); |