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

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(tidied up but still not converted to MySQL)
(well, that was easy.)
 
Line 9: Line 9:
 
   tt.Code,
 
   tt.Code,
 
   t.WhenDone,
 
   t.WhenDone,
−
   iif(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr,
+
   CONCAT(IF(t.ID_Package IS NULL,"",CONCAT("pkg #",p.Seq,": ")),t.Descr) AS Descr,
 
   t.Amount
 
   t.Amount
 
FROM (
 
FROM (

Latest revision as of 23:39, 1 June 2011

About

  • 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?)

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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryRpt_Pkg_Trx&oldid=15399"