VbzCart/docs/queries/qryRpt Pkg Trx: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (tidied up but still not converted to MySQL) |
imported>Woozle (well, that was easy.) |
||
| Line 9: | Line 9: | ||
tt.Code, | tt.Code, | ||
t.WhenDone, | t.WhenDone, | ||
CONCAT(IF(t.ID_Package IS NULL,"",CONCAT("pkg #",p.Seq,": ")),t.Descr) AS Descr, | |||
t.Amount | t.Amount | ||
FROM ( | FROM ( | ||
Revision as of 23:39, 1 June 2011
About
- Requires: Template:Vbzcart, Template:Vbzcart, Template:Vbzcart
- History:
- 2011-06-01 ported from MS Access so I can print packing slips from web interface (final major piece?)
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRpt_Pkg_Trx AS SELECT
t.ID_Order,
tt.Code,
t.WhenDone,
CONCAT(IF(t.ID_Package IS NULL,"",CONCAT("pkg #",p.Seq,": ")),t.Descr) AS Descr,
t.Amount
FROM (
ord_trxact AS t LEFT JOIN ord_trx_type AS tt ON t.ID_Type=tt.ID) LEFT JOIN ord_pkgs AS p ON t.ID_Package=p.ID
WHERE WhenVoid IS NULL ORDER BY WhenDone, Amount>0;</mysql> <section end=sql />