VbzCart/docs/procs/Upd Depts fr DeptIttyps

About

• Purpose: Updates some fields in Template:Vbzcart after that has been filled in by Template:Vbzcart
• Input: Template:Vbzcart (group by ID_Dept)
• Output: Template:Vbzcart (update)

SQL

<section begin=sql /><mysql>CREATE PROCEDURE Upd_Depts_fr_DeptIttyps()

   UPDATE _depts AS d LEFT JOIN (
     SELECT
       ID_Dept,
       SUM(di.cntForSale) AS cntForSale,
       SUM(di.cntInPrint) AS cntInPrint,
       SUM(di.qtyInStock) AS qtyInStock
     FROM _dept_ittyps AS di GROUP BY ID_Dept
     ) AS di ON di.ID_Dept=d.ID
     SET
       d.cntForSale = di.cntForSale,
       d.cntInPrint = di.cntInPrint,
       d.qtyInStock = di.qtyInStock;</mysql>

<section end=sql />