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:57, 5 January 2010 by Woozle (talk | contribs) (QtyOrd -> QtyExp)

(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
Status: possibly no longer in use (2010-01-04), unless it turns out to be faster this way
Requires:

REDIRECT Template:l/vc/table,
REDIRECT Template:l/vc/query

Used by: qryRstkReq_Item_status_Req_info, qryRstkReq_Items_expected
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

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

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