VbzCart/docs/queries/qryRstkReq Item status

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 />