Commit | Line | Data |
---|---|---|
fff6ce40 TM |
1 | <?php |
2 | $queries = array( //TODO: use build_query_select()!!! | |
3 | 'Nakoupeno celkem' => 'SELECT COUNT(item_id),SUM(item_price_in) FROM item WHERE item_valid_till=0', | |
4 | 'Použito celkem' => 'SELECT COUNT(item_id),SUM(item_price_in) FROM item WHERE item_valid_till=0 AND status_id = 2', | |
5 | 'Prodáno celkem' => 'SELECT COUNT(item_id),SUM(item_price_in) FROM item WHERE item_valid_till=0 AND status_id = 3', | |
6 | 'Počet kusů skladem' => 'SELECT room_id,room_name,model_id,model_name,model_barcode,COUNT(item_id)'. | |
7 | ' FROM item LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'. | |
8 | ' WHERE item_valid_till=0 AND status_id=1'. | |
9 | ' GROUP BY model_id,room_id'. | |
10 | ' ORDER BY room_id,model_id;' | |
11 | ); | |
12 | ||
13 | foreach($queries as $description => $sql) { | |
14 | echo "<h2>$description</h2>"; | |
15 | echo $this->html->render_item_table($result = $this->db->safe_query($sql)->fetchAll(PDO::FETCH_ASSOC)); | |
16 | } |