VbzCart/docs/queries/qryRstkReq Item status

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

Details

  • Returns: Information about items Restock Requested and how many have been Received
  • Status: possibly no longer in use (2010-01-04), unless it turns out to be faster this way
  • Requires: Template:Vbzcart/table, Template:Vbzcart/query
  • Used by: Template:Vbzcart/query, Template:Vbzcart/query
  • History:
    • 2008-11-21 Created for new restock process
    • 2010-01-04 QtyExp replaces QtyOrd
  • Fields:
    • WhenFirstOrder / WhenFinalorder are timestamps of customer orders for this item

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Item_status AS SELECT 

 rci.*,
 IFNULL(rqi.QtyExp,rqi.QtyOrd) AS QtyExp,
 rqi.Notes

FROM 

   rstk_req_item AS rqi
 LEFT JOIN qryRstkReq_Item_Rcd_status AS rci ON (rqi.ID_Restock=rci.ID_RstkReq) AND (rqi.ID_Item=rci.ID_Item)

WHERE rci.ID_RstkReq IS NOT NULL ORDER BY rci.ID_RstkReq, rci.ID_Item;</mysql> <section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryRstkReq_Item_status&oldid=6797"