assistants/stats/reserve.inc.php

   1 <?php
   2 $queries += array(
   3 /*
   4         "Nakoupit: Došlo úplně (Urgent WishList)" //TODO: Reinvent
   5                 => 'SELECT model_id,model_name,model_barcode,model_reserve,model_reserve as item_quantity_to_buy'.
   6                 ' FROM model'.
   7                 ' WHERE model_reserve>0 AND NOT EXISTS'.
   8                 ' (SELECT item_id FROM item WHERE model.model_id=item.model_id AND status_id=1 AND item_quantity>0 AND item_valid_till=0)',
   9 */
  10         "Nakoupit: Dochází (WishList)"
  11                 => 'SELECT model_id,model_name,model_barcode,model_reserve,'.
  12                 ' COUNT(item_id),SUM(item_quantity),model_reserve-SUM(item_quantity) as item_quantity_to_buy'.
  13                 ' FROM item LEFT JOIN barcode USING(barcode_id) LEFT JOIN model USING(model_id)'.
  14                 ' WHERE item_valid_till=0 AND status_id=1'.
  15                 ' GROUP BY model_id'.
  16                 ' HAVING SUM(item_quantity)<model_reserve'.
  17                 ' ORDER BY model_id;',
  18 );