VbzCart/queries/qryRstkReq Item status
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.
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>