VbzCart/docs/queries/qryStk byItem byBin: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (moved VbzCart/queries/v stk byItemAndBin to VbzCart/queries/qryStk byItem byBin: updated naming canon) |
m (Woozle moved page VbzCart/VbzCart/queries/qryStk byItem byBin to VbzCart/docs/queries/qryStk byItem byBin without leaving a redirect: part 3/5) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 2: | Line 2: | ||
* '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item and Bin (so we have totals for each Item in each Bin) | * '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item and Bin (so we have totals for each Item in each Bin) | ||
* '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | ||
* '''Used by''': {{vbzcart/query|v_stk_byItemAndBin_wInfo}} | * '''Used by''': {{vbzcart/query|v_stk_byItemAndBin_wInfo}}, VbzStockBins::Info_forItems() | ||
* '''History''': | * '''History''': | ||
** '''2010-02-23''' v_stk_lines_remaining was renamed to qryStk_lines_remaining | ** '''2010-02-23''' v_stk_lines_remaining was renamed to qryStk_lines_remaining | ||
Latest revision as of 01:56, 25 February 2024
Details
- Returns: Same records as Template:Vbzcart/query, but grouped by Item and Bin (so we have totals for each Item in each Bin)
- Requires: Template:Vbzcart/query
- Used by: Template:Vbzcart/query, VbzStockBins::Info_forItems()
- History:
- 2010-02-23 v_stk_lines_remaining was renamed to qryStk_lines_remaining
- also renaming this from v_stk_byItemAndBin to qryStk_byItem_byBin
- 2010-02-23 v_stk_lines_remaining was renamed to qryStk_lines_remaining
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_byItem_byBin AS
SELECT ID_Item, ID_Bin, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Item, ID_Bin HAVING SUM(QtyExisting)>0;</mysql>
<section end=sql />