VbzCart/queries/qryRstkReq Item status

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 00:34, 4 December 2008 by Woozle (talk | contribs) (New page: ==Details== * '''Returns''': Information about items Restock Requested and how many have been Received * '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstkReq_Item_Rc...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Returns: Information about items Restock Requested and how many have been Received
  • Requires:
  1. REDIRECT Template:l/vc/table,
  2. REDIRECT Template:l/vc/query
  • Used by: qryRstkReq_Item_status_Req_info
  • History:
    • 2008-11-21 Created for new restock process
  • Fields:
    • WhenFirstOrder / WhenFinalorder are timestamps of customer orders for this item

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkReq_Item_status AS SELECT 

 rci.*,
 rqi.QtyOrd,
 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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryRstkReq_Item_status&oldid=10939"