https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2Fdiscarded%2FqryCbx_Restocks_byStatus 2026-07-08T04:33:56Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/discarded/qryCbx_Restocks_byStatus&diff=21733&oldid=prev 2016-03-02T21:58:26Z

<p>extracted from &quot;discarded&quot; page</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Status&#039;&#039;&#039;: deprecated (uses old restock tables); can probably be deleted, since nothing should be using those tables anymore.<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/table|core_restocks}}, {{vbzcart/table|cat_supp}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: {{l/same|qryCbx_Restocks}}<br /> ==SQL==<br /> &lt;mysql&gt;CREATE OR REPLACE VIEW qryCbx_Restocks_byStatus AS<br /> SELECT<br /> r.ID,<br /> CAST(<br /> CONCAT(<br /> CAST(COALESCE(<br /> CONCAT(&#039;X &#039;,DATE_FORMAT(r.WhenKilled,&#039;%Y-%m-%d&#039;)),<br /> CONCAT(&#039;R &#039;,DATE_FORMAT(r.WhenReceived,&#039;%Y-%m-%d&#039;)),<br /> CONCAT(&#039;O &#039;,DATE_FORMAT(r.WhenOrdered,&#039;%Y-%m-%d&#039;)),<br /> CONCAT(&#039;D &#039;,DATE_FORMAT(r.WhenDebited,&#039;%Y-%m-%d&#039;)),<br /> CONCAT(&#039;C &#039;,DATE_FORMAT(r.WhenCreated,&#039;%Y-%m-%d&#039;))<br /> ) AS BINARY),<br /> &#039; &#039;,<br /> s.CatKey,<br /> IFNULL(CONCAT(&#039; [&#039;,r.PurchOrdNum,&#039;]&#039;),&#039;&#039;)<br /> ) AS CHAR<br /> ) AS Descr,<br /> NOT IsLocked AS IsOpen,<br /> r.WhenOrdered,<br /> r.WhenReceived,<br /> r.WhenConfirmed,<br /> r.ID_Supplier<br /> FROM core_restocks AS r LEFT JOIN cat_supp AS s ON r.ID_Supplier=s.ID<br /> ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;&lt;/mysql&gt;</div>

Woozle