VbzCart/docs/queries/qryRstkItms unsent for order: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
imported>Woozle
No edit summary
Line 1: Line 1:
==Details==
==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.
* '''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''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryCat_Items}}
* '''Requires''': {{vbzcart/query|qryRstkItms_unsent}}, {{vbzcart/query|qryCat_Items}}
* '''Used by''': eventually, the restock order generation form (currently working on this)
* '''Used by''': eventually, the restock order generation form (currently working on this)
* '''History''':
* '''History''':
** '''2008-12-04''' Created for new restock process
** '''2008-12-04''' Created for new restock process; renamed
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_for_order AS
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_unsent_for_order AS
SELECT
SELECT
   ri.ID_Restock,
   ri.ID_Restock,
Line 23: Line 23:
   ri.CostExpPer,
   ri.CostExpPer,
   ci.PriceSell
   ci.PriceSell
FROM rstk_req_item AS ri LEFT JOIN qryCat_Items AS ci ON ci.ID=ri.ID_Item
FROM qryRstkItms_unsent AS ri LEFT JOIN qryCat_Items AS ci ON ci.ID=ri.ID_Item
ORDER BY ci.CatNum;</mysql>
ORDER BY ci.CatNum;</mysql>
<section end=sql />
<section end=sql />

Revision as of 01:42, 5 December 2008

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
  • Used by: eventually, the restock order generation form (currently working on this)
  • History:
    • 2008-12-04 Created for new restock process; renamed

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,
 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 ORDER BY ci.CatNum;</mysql> <section end=sql />

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