VbzCart/docs/queries/qryStk lines remaining: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (post-move update) |
imported>Woozle (another used-by) |
||
Line 5: | Line 5: | ||
** items neither for shipping nor for sale (probably some kind of recordkeeping purpose) | ** items neither for shipping nor for sale (probably some kind of recordkeeping purpose) | ||
* '''Requires''': {{vbzcart/table|stk_items}}, {{vbzcart/table|stk_places}} | * '''Requires''': {{vbzcart/table|stk_items}}, {{vbzcart/table|stk_places}} | ||
* '''Used by''': {{vbzcart/query|qryStk_lines_remaining_forSale}}, {{vbzcart/query|qryStk_lines_remaining_byBin}} | * '''Used by''': {{vbzcart/query|qryStk_lines_remaining_forSale}}, {{vbzcart/query|qryStk_lines_remaining_byBin}}, {{vbzcart/query|qryStk_items_remaining}} | ||
* '''History''': | * '''History''': | ||
** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining''' | ** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining''' |
Revision as of 23:20, 29 November 2009
About
- Returns: Template:Vbzcart/table actually in stock, which is actually different things:
- "forSale": items which are visible as "in stock" to customers
- "forShip": items which are available for shipping
- items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
- Requires: Template:Vbzcart/table, Template:Vbzcart/table
- Used by: Template:Vbzcart/query, Template:Vbzcart/query, Template:Vbzcart/query
- History:
- 2009-11-29 renamed from v_stk_lines_remaining to qryStk_lines_remaining
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS
SELECT st.ID, st.ID_Bin, st.ID_Item, IF(sb.isForSale,st.Qty,0) AS QtyForSale, IF(sb.isForShip,st.Qty,0) AS QtyForShip, st.Qty AS QtyExisting, st.CatNum, st.WhenAdded, st.WhenChanged, st.WhenCounted, st.Notes, sb.ID_Place, sp.Name AS WhName FROM ( stk_items AS st LEFT JOIN stk_bins AS sb ON sb.ID=st.ID_Bin ) LEFT JOIN stk_places AS sp ON sb.ID_Place=sp.ID WHERE (st.WhenRemoved IS NULL) AND (sb.WhenVoided IS NULL) AND (st.Qty <> 0);</mysql>
<section end=sql />