VbzCart/queries/qryRpt Pkg Lines

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
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  1. REDIRECT Template:l/vc/query
  • History:
    • 2011-05-31 ported from MS Access so I can print packing slips from web interface (final major piece?)
    • 2011-06-01 added p.ID_Item so we can pull in the results from qryPkgLines_qtys_done; added PriceShipped so I don't have to implement expressions in w3tpl yet

SQL

<mysql>CREATE OR REPLACE VIEW qryRpt_Pkg_Lines AS SELECT 

 p.ID AS ID,
 p.ID_Pkg,
 o.Seq,
 IFNULL(o.CatNum,i.CatNum) AS CatNum,
 IFNULL(o.Descr,i.Descr) AS Descr,
 o.QtyOrd,
 p.QtyShipped,
 p.QtyExtra,
 p.QtyNotAvail,
 p.QtyKilled,
 o.Price,
 o.Price * p.QtyShipped AS PriceShipped,
 o.ShipItm,
 o.ShipPkg,
 p.ID_Item,
 i.ID_Title

FROM ( 

 ord_pkg_lines AS p LEFT JOIN
 ord_lines AS o ON p.ID_OrdLine=o.ID) LEFT JOIN
 qryCat_Items AS i ON p.ID_Item=i.ID;</mysql>

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