https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryRstkReq_Item_Rcd_status 2026-07-08T02:28:43Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryRstkReq_Item_Rcd_status&diff=10938&oldid=prev 2008-12-04T00:32:39Z

<p>New page: ==Details== * &#039;&#039;&#039;Returns&#039;&#039;&#039;: Information about received shipments for a given Item in a given Restock Request * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/table|rstk_rcd_line}}, {{vbzcart/table|rstk_rcd}},...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Returns&#039;&#039;&#039;: Information about received shipments for a given Item in a given Restock Request<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/table|rstk_rcd_line}}, {{vbzcart/table|rstk_rcd}}, {{vbzcart/table|rstk_req}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: {{vbzcart/query|qryRstkReq_Item_status}}<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2008-11-21&#039;&#039;&#039; Created for new restock process<br /> ** &#039;&#039;&#039;2008-11-23&#039;&#039;&#039; WhenOrdered -&gt; WhenFirstOrder (MIN), WhenFinalOrder (MAX)<br /> * &#039;&#039;&#039;Fields&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;WhenFirstOrder&#039;&#039;&#039; is the timestamp of the &#039;&#039;earliest&#039;&#039; open customer order for this item. This is so we know the longest time that anyone has been waiting for this item, and hence how urgent the restock is.<br /> ** &#039;&#039;&#039;WhenFinalOrder&#039;&#039;&#039; is the timestamp of the &#039;&#039;latest&#039;&#039; open customer order for this item. This is so we know if there have been further requests for this item, adding further urgency.<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryRstkReq_Item_Rcd_status AS<br /> SELECT<br /> rq.ID AS ID_RstkReq,<br /> MIN(rq.WhenOrdered) AS WhenFirstOrder,<br /> MAX(rq.WhenOrdered) AS WhenFinalOrder,<br /> rcl.ID_Item,<br /> SUM(IFNULL(rcl.QtyFiled,rcl.QtyRecd)) AS QtyRecd<br /> FROM<br /> (rstk_rcd_line AS rcl<br /> LEFT JOIN rstk_rcd AS rc ON rcl.ID_RstkRcd=rc.ID)<br /> LEFT JOIN rstk_req AS rq ON rc.ID_Restock=rq.ID<br /> GROUP BY rq.ID, rcl.ID_Item;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle