https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryPkgs_status VbzCart/queries/qryPkgs status - Revision history 2026-07-07T12:54:12Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryPkgs_status&diff=11971&oldid=prev Woozle: New page: ==About== * '''Requires''': {{vbzcart|table|ord_pkg_lines}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_shipmt}}, {{vbzcart|table|ord_lines}}, {{vbzcart|table|core_orders}} * '''Group... 2009-07-09T18:16:15Z <p>New page: ==About== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart|table|ord_pkg_lines}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_shipmt}}, {{vbzcart|table|ord_lines}}, {{vbzcart|table|core_orders}} * &#039;&#039;&#039;Group...</p> <p><b>New page</b></p><div>==About==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart|table|ord_pkg_lines}}, {{vbzcart|table|ord_pkgs}}, {{vbzcart|table|ord_shipmt}}, {{vbzcart|table|ord_lines}}, {{vbzcart|table|core_orders}}<br /> * &#039;&#039;&#039;Grouped by&#039;&#039;&#039;: Package<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: VbzAdmin shipment detail display<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2009-07-09&#039;&#039;&#039; Adapted from MS Access version<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryPkgs_status AS<br /> SELECT<br /> p.ID_Order,<br /> p.ID AS ID_Package,<br /> CONCAT(&quot;(&quot;,s.ID,&quot;) &quot;,IF(s.Abbr=&quot;&quot;,s.WhenShipped,s.Abbr)) AS Shipment,<br /> p.ID_Shipment,<br /> CONCAT(o.Number,&quot;-&quot;,p.Seq) AS PackageName,<br /> p.WhenStarted,<br /> p.WhenFinished,<br /> p.ShipCost,<br /> p.PkgCost,<br /> s.WhenShipped,<br /> Sum(oi.QtyOrd) AS Ordered,<br /> Sum(pl.QtyShipped) AS Shipped,<br /> Sum(pl.QtyNotAvail) AS Deleted,<br /> Sum(pl.QtyKilled) AS Cancelled,<br /> Sum(oi.QtyOrd-IFNULL(pl.QtyShipped,0)-IFNULL(pl.QtyNotAvail,0)-IFNULL(pl.QtyKilled,0)) AS Remaining,<br /> WhenChecked<br /> FROM<br /> (<br /> (<br /> (ord_pkg_lines AS pl RIGHT JOIN ord_pkgs AS p ON pl.ID_Pkg = p.ID)<br /> LEFT JOIN ord_shipmt AS s ON p.ID_Shipment = s.ID)<br /> LEFT JOIN ord_lines AS oi ON pl.ID_OrdLine=oi.ID)<br /> LEFT JOIN core_orders AS o ON p.ID_Order=o.ID<br /> GROUP BY p.ID, p.ID_Order, p.ID_Shipment, p.ShipCost, p.PkgCost, s.Abbr, o.Number, p.Seq, p.WhenStarted, p.WhenFinished, s.WhenShipped, s.ID, WhenChecked<br /> ORDER BY o.Number, p.Seq;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div> Woozle