VbzCart/docs/queries/qryRstkReq Items expected: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (corrected slightly, but deprecated anyway) |
imported>Woozle (...oh, and the future has been dealt with.) |
||
Line 7: | Line 7: | ||
** '''2010-01-03''' Created for generating list of needed items | ** '''2010-01-03''' Created for generating list of needed items | ||
** '''2010-01-04''' This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results | ** '''2010-01-04''' This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS |
Revision as of 00:16, 6 January 2010
About
- Purpose: Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already received for those requests
- Requires: Template:Vbzcart/query
- Used by : DEPRECATED - seems less accurate than Template:Vbzcart/query
- Related: Like Template:Vbzcart/query, but grouped by Item (eliminates rstk_req data)
- History:
- 2010-01-03 Created for generating list of needed items
- 2010-01-04 This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS SELECT
ID_Item, SUM(QtyRecd) AS QtyRecd, SUM(QtyExp) AS QtyExp
FROM qryRstkReq_Item_status GROUP BY ID_Item HAVING SUM(QtyExp)-SUM(QtyRecd)>0;</mysql> <section end=sql />