Difference between revisions of "VbzCart/queries/qryRpt Pkg Trx"

Latest revision as of 23:39, 1 June 2011

Requires: ord_trxact, ord_trx_type, ord_pkgs
History:
- 2011-06-01 ported from MS Access so I can print packing slips from web interface (final major piece?)

<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>

@@ Line 1: / Line 1: @@
-<mysql>SELECT t.ID_Order, tt.Code, t.WhenDone, iif(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr, t.Amount
+==About==
-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
+* '''Requires''': {{vbzcart|table|ord_trxact}}, {{vbzcart|table|ord_trx_type}}, {{vbzcart|table|ord_pkgs}}
+* '''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;
+ORDER BY WhenDone, Amount>0;</mysql>
-</mysql>
+<section end=sql />