VbzCart/queries/qryStk lines remaining

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • OBSOLETE: replaced by a number of things (search for query name to find them)
  • Returns:
  1. REDIRECT Template:l/vc/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: stk_items, stk_places
  • Used by:
  1. REDIRECT Template:l/vc/query, qryStk_lines_remaining_byBin, qryStk_items_remaining, qryStk_byItem_byBin
  • History:
    • 2009-11-29 renamed from v_stk_lines_remaining to qryStk_lines_remaining
    • 2010-06-15 added BinCode (sb.Code) -- needed for clsStkItems::List_forItem()

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.Code AS BinCode,
   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>
Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryStk_lines_remaining&oldid=22441"