VbzCart/docs/queries/qryStk Bins w info: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(obsolete now)
m (Woozle moved page VbzCart/VbzCart/queries/qryStk Bins w info to VbzCart/docs/queries/qryStk Bins w info without leaving a redirect: part 3/5)
 
(No difference)

Latest revision as of 01:56, 25 February 2024

About

  • OBSOLETE: replaced by vcqtStockBinsInfo methods
  • Returns: stk_bins with additional information
  • Requires: Template:Vbzcart, Template:Vbzcart/query
  • Used by: Special:VbzAdmin's stock bin listing page
  • History:
    • 2009-04-29 Created for Special:VbzAdmin
    • 2017-03-24 obsoleted

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_Bins_w_info AS 

 SELECT
   sb.*,
   sp.Name AS PlaceName,
   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 

   LEFT JOIN stk_places as sp

ON sb.ID_Place=sp.ID;</mysql>

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