VbzCart/docs/queries/qryRstkItms unsent for order

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

About

  • Purpose: This should have enough information in it that we can use it to generate a restock order in whatever format the supplier needs it to be in, with minimal hand-massaging.
  • Requires: Template:Vbzcart/query, Template:Vbzcart/query, Template:Vbzcat/table
  • Used by: eventually, the restock order generation form (currently working on this)
  • History:
    • 2008-12-04 Created for new restock process; renamed
    • 2008-12-05 Added cat_ittyps

SQL

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

 ri.ID_Restock,
 ri.ID_Item,
 ci.CatNum,
 ci.Title_CatNum,
 ci.Title_Name,
 ci.ID_ItTyp,
 ci.ID_itOpt,
 ci.ItOpt_Descr,
 ci.ItOpt_Sort,
 ci.Supp_CatNum,
 it.NameSng,
 IFNULL(it.NamePlr,it.NameSng) AS NamePlr,
 ri.QtyOrd,
 ri.QtyExp,
 ci.QtyMin_Stk,
 ri.CostExpPer,
 ci.PriceSell

FROM

 (qryRstkItms_unsent AS ri LEFT JOIN
 qryCat_Items AS ci ON ci.ID=ri.ID_Item) LEFT JOIN
 cat_ittyps AS it ON ci.ID_ItTyp=it.ID

ORDER BY ci.CatNum;</mysql> <section end=sql />