VbzCart/procs/Upd CatItems fr StkItems StkBins - Revision history

Woozle: isEnabled condition

2012-02-06T19:07:47Z

isEnabled condition

← Older revision		Revision as of 19:07, 6 February 2012
Line 5:		Line 5:
	* '''History''':		* '''History''':
	** '''2011-01-24''' Corrected '''i.QtyInStock''' to '''i.QtyIn_Stk'''		** '''2011-01-24''' Corrected '''i.QtyInStock''' to '''i.QtyIn_Stk'''
			** '''2012-02-06''' Added "AND (sb.isEnabled)" condition (isEnabled flag is new)
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS `Upd_CatItems_fr_StkItems_StkBins`;		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS `Upd_CatItems_fr_StkItems_StkBins`;
Line 13:		Line 14:
	SUM(si.Qty) AS QtyInStock		SUM(si.Qty) AS QtyInStock
	FROM stk_items AS si LEFT JOIN stk_bins AS sb ON si.ID_Bin=sb.ID		FROM stk_items AS si LEFT JOIN stk_bins AS sb ON si.ID_Bin=sb.ID
	WHERE (sb.isForSale) AND ISNULL(sb.WhenVoided) AND ISNULL(si.WhenRemoved)		WHERE (sb.isForSale) AND (sb.isEnabled) AND ISNULL(sb.WhenVoided) AND ISNULL(si.WhenRemoved)
	GROUP BY ID_Item		GROUP BY ID_Item
	) AS sig ON i.ID=sig.ID_Item		) AS sig ON i.ID=sig.ID_Item

Woozle: corrected i.QtyInStock

2011-01-24T19:06:51Z

corrected i.QtyInStock

← Older revision		Revision as of 19:06, 24 January 2011
Line 3:		Line 3:
	* '''Input''': {{vbzcart\|table\|stk_items}}, {{vbzcart\|table\|stk_bins}}		* '''Input''': {{vbzcart\|table\|stk_items}}, {{vbzcart\|table\|stk_bins}}
	* '''Output''': {{vbzcart\|table\|cat_items}}		* '''Output''': {{vbzcart\|table\|cat_items}}
			* '''History''':
			** '''2011-01-24''' Corrected '''i.QtyInStock''' to '''i.QtyIn_Stk'''
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS `Upd_CatItems_fr_StkItems_StkBins`;
			CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()
	UPDATE cat_items AS i LEFT JOIN (		UPDATE cat_items AS i LEFT JOIN (
	SELECT		SELECT
Line 14:		Line 17:
	) AS sig ON i.ID=sig.ID_Item		) AS sig ON i.ID=sig.ID_Item
	SET		SET
	i.~~QtyInStock~~ = sig.QtyInStock,		i.QtyIn_Stk = sig.QtyInStock,
	i.isForSale = i.isInPrint OR (sig.QtyInStock > 0);</mysql>		i.isForSale = i.isInPrint OR (sig.QtyInStock > 0);</mysql>
	<section end=sql />		<section end=sql />

Woozle: input/output doc

2009-03-08T18:26:41Z

input/output doc

← Older revision		Revision as of 18:26, 8 March 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Action''': updates availability from current stock		* '''Action''': updates availability from current stock
			* '''Input''': {{vbzcart\|table\|stk_items}}, {{vbzcart\|table\|stk_bins}}
			* '''Output''': {{vbzcart\|table\|cat_items}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()		<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()

Woozle: New page: ==About== * '''Action''': updates availability from current stock ==SQL==
CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...

2009-03-08T18:24:57Z

New page: ==About== * '''Action''': updates availability from current stock ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...

New page

==About==
* '''Action''': updates availability from current stock
==SQL==
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()
UPDATE cat_items AS i LEFT JOIN (
SELECT
si.ID_Item,
SUM(si.Qty) AS QtyInStock
FROM stk_items AS si LEFT JOIN stk_bins AS sb ON si.ID_Bin=sb.ID
WHERE (sb.isForSale) AND ISNULL(sb.WhenVoided) AND ISNULL(si.WhenRemoved)
GROUP BY ID_Item
) AS sig ON i.ID=sig.ID_Item
SET
i.QtyInStock = sig.QtyInStock,
i.isForSale = i.isInPrint OR (sig.QtyInStock > 0);</mysql>
<section end=sql />

VbzCart/procs/Upd CatItems fr StkItems StkBins - Revision history

Woozle: isEnabled condition

Woozle: corrected i.QtyInStock

Woozle: input/output doc

Woozle: New page: ==About== * '''Action''': updates availability from current stock ==SQL== CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...

Woozle: New page: ==About== * '''Action''': updates availability from current stock ==SQL==
CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...