VbzCart/docs/procs/Upd DeptIttyps fr TitleIttyps

About

• Input: Template:Vbzcart, Template:Vbzcart (grouped by ID_ItTyp, ID_Dept, (ID_Supp redundant))
• Output: Template:Vbzcart (replace)
• History:
  • 2010-11-10
    • Added DROP PROCEDURE for easier maintenance.
    • Created in database (procs were not ported from L48 to Rizzo).
  • 2011-02-02 added join with Template:Vbzcart so we can update new field ID_Supp

SQL

<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_DeptIttyps_fr_TitleIttyps; CREATE PROCEDURE Upd_DeptIttyps_fr_TitleIttyps()

 REPLACE INTO _dept_ittyps(ID_ItTyp,ID_Dept,ID_Supp,cntForSale,cntInPrint,qtyInStock)
 SELECT
   ti.ID_ItTyp,
   ti.ID_Dept,
   d.ID_Supplier,
   SUM(ti.cntForSale) AS cntForSale,
   SUM(ti.cntInPrint) AS cntInPrint,
   SUM(ti.qtyInStock) AS qtyInStock
 FROM _title_ittyps AS ti LEFT JOIN cat_depts AS d ON ti.ID_Dept=d.ID
 GROUP BY ID_ItTyp, ID_Dept, ID_Supplier;</mysql>

<section end=sql />