VbzCart/docs/queries/qryRpt Pkg Trx: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(SQL from MS Access -- not tested on MySQL yet)
 
m (Woozle moved page VbzCart/VbzCart/queries/qryRpt Pkg Trx to VbzCart/docs/queries/qryRpt Pkg Trx without leaving a redirect: part 2)
 
(2 intermediate revisions by one other user not shown)
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
WHERE WhenVoid IS NULL
ORDER BY WhenDone, Amount>0;
ORDER BY WhenDone, Amount>0;</mysql>
</mysql>
<section end=sql />

Latest revision as of 01:55, 25 February 2024

About

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

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryRpt_Pkg_Trx&oldid=6789"