VbzCart/docs/queries/qryRstkItms expected byItem

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

About

  • Purpose: Returns a list of items we're currently expecting to receive in restocks,
  • Requires: Template:Vbzcart/query
  • Used by : restock request generation admin page
  • History:
    • 2010-01-05 Created for VbzAdmin; replaced Template:Vbzcart/query
    • 2016-03-02 No longer works; dropped from database.

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS SELECT

 ID_Item,
 SUM(QtyExp) AS QtyExp,
 SUM(QtyRecd) AS QtyRecd

FROM qryRstkItms_expected GROUP BY ID_Item;</mysql>