VbzCart/procs/Upd Titles fr CatItems - Revision history

Woozle: made it go

2010-11-10T23:12:21Z

made it go

← Older revision		Revision as of 23:12, 10 November 2010
Line 7:		Line 7:
	*** Added DROP PROCEDURE for easier maintenance.		*** Added DROP PROCEDURE for easier maintenance.
	*** Added to database (procs did not get ported from L48 to Rizzo).		*** Added to database (procs did not get ported from L48 to Rizzo).
			*** i.qtyInStock -> i.qtyIn_Stk
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_CatItems;		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_CatItems;
Line 15:		Line 16:
	SUM(IF(i.isForSale,1,0)) AS cntForSale,		SUM(IF(i.isForSale,1,0)) AS cntForSale,
	SUM(IF(i.isInPrint,1,0)) AS cntInPrint,		SUM(IF(i.isInPrint,1,0)) AS cntInPrint,
	SUM(i.~~qtyInStock~~) AS qtyInStock,		SUM(i.qtyIn_Stk) AS qtyInStock,
	MIN(i.PriceSell) AS currMinSell,		MIN(i.PriceSell) AS currMinSell,
	MAX(i.PriceSell) AS currMaxSell		MAX(i.PriceSell) AS currMaxSell

Woozle: added to db

2010-11-10T12:36:24Z

added to db

← Older revision		Revision as of 12:36, 10 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''~~Purpose~~''': sets some fields in {{vbzcart\|table\|_titles}} after that has been filled in by {{vbzcart\|proc\|Upd_Titles_fr_Depts}}		* '''Action''': sets some fields in {{vbzcart\|table\|_titles}} after that has been filled in by {{vbzcart\|proc\|Upd_Titles_fr_Depts}}
			* '''Input''': {{vbzcart\|table\|cat_items}}
			* '''Output''': {{vbzcart\|table\|_titles}}: cntForSale, cntInPrint, qtyInStock
			* '''History''':
			** '''2010-11-10'''
			*** Added DROP PROCEDURE for easier maintenance.
			*** Added to database (procs did not get ported from L48 to Rizzo).
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_Titles_fr_CatItems()		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_CatItems;
			CREATE PROCEDURE Upd_Titles_fr_CatItems()
	UPDATE _titles AS t LEFT JOIN (		UPDATE _titles AS t LEFT JOIN (
	SELECT		SELECT

Woozle: New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL==
CREATE PR...

2009-03-08T19:41:30Z

New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL== <section begin=sql /><mysql>CREATE PR...

New page

==About==
* '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}}
==SQL==
<section begin=sql /><mysql>CREATE PROCEDURE Upd_Titles_fr_CatItems()
UPDATE _titles AS t LEFT JOIN (
SELECT
ID_Title,
SUM(IF(i.isForSale,1,0)) AS cntForSale,
SUM(IF(i.isInPrint,1,0)) AS cntInPrint,
SUM(i.qtyInStock) AS qtyInStock,
MIN(i.PriceSell) AS currMinSell,
MAX(i.PriceSell) AS currMaxSell
FROM cat_items AS i GROUP BY ID_Title
) AS ig ON ig.ID_Title=t.ID
SET
t.cntForSale = ig.cntForSale,
t.cntInPrint = ig.cntInPrint,
t.qtyInStock = ig.qtyInStock;</mysql>
<section end=sql />

VbzCart/procs/Upd Titles fr CatItems - Revision history

Woozle: made it go

Woozle: added to db

Woozle: New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL== CREATE PR...

Woozle: New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL==
CREATE PR...