VbzCart/queries/qryCbx Orders: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
New page: ==Details== * '''Requires''': core_orders * '''Used by''': various forms, I think * '''Fields''': ** '''ID_Pull''' and '''WhenNeeded''' are needed for [[../qry... |
m minor doc formatting updates |
||
| Line 1: | Line 1: | ||
== | ==About== | ||
* '''Requires''': | * '''Requires''': {{vbzcart|table|core_orders}} | ||
* '''Used by''': various forms, I think | * '''Used by''': various forms, I think | ||
* '''Fields''': | * '''Fields''': | ||
** '''ID_Pull''' and '''WhenNeeded''' are needed for | ** '''ID_Pull''' and '''WhenNeeded''' are needed for {{vbzcart/query|qryStock_forOpenOrders}} | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS | ||
Latest revision as of 18:17, 9 July 2009
About
- Requires: core_orders
- Used by: various forms, I think
- Fields:
- ID_Pull and WhenNeeded are needed for qryStock_forOpenOrders
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Orders AS SELECT
ID,
CONCAT_WS(' due ',CAST(Number AS CHAR),DATE_FORMAT(WhenNeeded,'%Y-%m-%d')) AS Descr,
ID_Pull,
WhenNeeded
FROM core_orders ORDER BY CONCAT(IFNULL(SortPfx,),Number) DESC;</mysql> <section end=sql />
