VbzCart/docs/queries/qryStk lines remaining byBin: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (updated because of name-change in underlying query) |
imported>Woozle (obsolete now) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''OBSOLETE''': replaced by '''vcqtStockBinsInfo''' methods | |||
* '''Returns''': list of bins, with stock quantities for each (for sale, for shipping, existing) | * '''Returns''': list of bins, with stock quantities for each (for sale, for shipping, existing) | ||
* '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | ||
| Line 6: | Line 7: | ||
** '''2009-04-29''' Created for Special:VbzAdmin | ** '''2009-04-29''' Created for Special:VbzAdmin | ||
** '''2009-11-29''' Updated to reflect name change of source query | ** '''2009-11-29''' Updated to reflect name change of source query | ||
** '''2017-03-24''' obsoleted | |||
==SQL== | ==SQL== | ||
<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_byBin AS | |||
SELECT | SELECT | ||
ID_Bin, | ID_Bin, | ||
| Line 15: | Line 17: | ||
FROM qryStk_lines_remaining | FROM qryStk_lines_remaining | ||
GROUP BY ID_Bin;</mysql> | GROUP BY ID_Bin;</mysql> | ||
Revision as of 19:21, 24 March 2017
About
- OBSOLETE: replaced by vcqtStockBinsInfo methods
- Returns: list of bins, with stock quantities for each (for sale, for shipping, existing)
- Requires: Template:Vbzcart/query
- Used by: Template:Vbzcart/query
- History:
- 2009-04-29 Created for Special:VbzAdmin
- 2009-11-29 Updated to reflect name change of source query
- 2017-03-24 obsoleted
SQL
<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_byBin AS
SELECT ID_Bin, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Bin;</mysql>