assistants/stats/reserve.inc.php

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