VbzCart/docs/queries/qryRstkItms expected byItem: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(Created page with '==About== * '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, * '''Requires''': {{vbzcart/query|qryRstkItms_expected}} * '''Used by ''': re…')
 
imported>Woozle
No edit summary
Line 5: Line 5:
* '''History''':
* '''History''':
** '''2010-01-05''' Created for VbzAdmin; replaced {{vbzcart/query|qryRstkReq_Items_expected}}
** '''2010-01-05''' Created for VbzAdmin; replaced {{vbzcart/query|qryRstkReq_Items_expected}}
** '''2016-03-02''' No longer works; dropped from database.
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS
<mysql>CREATE OR REPLACE VIEW qryRstkItms_expected_byItem AS
SELECT
SELECT
   ID_Item,
   ID_Item,
Line 13: Line 14:
FROM qryRstkItms_expected
FROM qryRstkItms_expected
GROUP BY ID_Item;</mysql>
GROUP BY ID_Item;</mysql>
<section end=sql />

Revision as of 22:57, 2 March 2016

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>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryRstkItms_expected_byItem&oldid=5312"