VbzCart/docs/queries/qryStk Bins w info

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Revision as of 23:09, 29 April 2009 by imported>Woozle (created)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Returns: stk_bins with additional information (currently just stock quantities, but other fields could be added)
  • Requires: Template:Vbzcart, Template:Vbzcart/query
  • Used by: Special:VbzAdmin's stock bin listing page
  • History:
    • 2009-04-29 Created for Special:VbzAdmin

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_Bins_w_info AS 

 SELECT
   sb.*,
   sq.QtyForSale,
   sq.QtyForShip,
   sq.QtyExisting
 FROM stk_bins AS sb
   LEFT JOIN qryStk_lines_remaining_byBin AS sq
   ON sb.ID=sq.ID_Bin;</mysql>

<section end=sql />

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