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
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: rstk_req_item, qryRstkReq_Item_Rcd_status
- 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
<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 />
