https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryOrdItms_Pkg_qtys VbzCart/queries/qryOrdItms Pkg qtys - Revision history 2026-07-08T03:32:37Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrdItms_Pkg_qtys&diff=10915&oldid=prev Woozle: New page: ==Details== * '''Requires''': qryOrderLines_Active, qry_PkgItem_qtys_byOrder * '''Used by''': * '''History''': ** '''2008-11-16... 2008-12-03T21:22:57Z <p>New page: ==Details== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../qryOrderLines_Active|qryOrderLines_Active]], [[../qry_PkgItem_qtys_byOrder|qry_PkgItem_qtys_byOrder]] * &#039;&#039;&#039;Used by&#039;&#039;&#039;: * &#039;&#039;&#039;History&#039;&#039;&#039;: ** &#039;&#039;&#039;2008-11-16...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../qryOrderLines_Active|qryOrderLines_Active]], [[../qry_PkgItem_qtys_byOrder|qry_PkgItem_qtys_byOrder]]<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: <br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2008-11-16&#039;&#039;&#039; created for new restocking process<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryOrdItms_Pkg_qtys AS<br /> SELECT<br /> oi.ID_Item,<br /> oi.ID_Order,<br /> oi.QtyOrd,<br /> piq.QtySent,<br /> piq.QtyDone,<br /> oi.QtyOrd-IFNULL(piq.QtyDone,0) AS QtyOpen<br /> FROM qryOrderItems_Active AS oi<br /> LEFT JOIN qry_PkgItem_qtys_byOrder AS piq<br /> ON (piq.ID_Item=oi.ID_Item) AND (piq.ID_Order=oi.ID_Order)<br /> ORDER BY oi.ID_Item, oi.ID_Order;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div> Woozle