VbzCart/queries/qryItems needed forStock - Revision history

Woozle: status update

2016-03-02T22:51:41Z

status update

← Older revision		Revision as of 22:51, 2 March 2016
Line 6:		Line 6:
	** '''2010-01-02''' Created		** '''2010-01-02''' Created
	** '''2015-12-30''' Replaced with PHP-generated SQL		** '''2015-12-30''' Replaced with PHP-generated SQL
	* '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin		** '''2016-03-02''' Query no longer works; removing from database.
			* '''Was Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
	* '''Requires''': {{vbzcart/query\|qryStkItms_for_sale}}		* '''Requires''': {{vbzcart/query\|qryStkItms_for_sale}}
	==SQL==		==SQL==

Woozle: obsolete

2015-12-31T02:16:57Z

obsolete

← Older revision		Revision as of 02:16, 31 December 2015
Line 1:		Line 1:
	==About==		==About==
			* '''Obsolete''': use VCA_Items::SQL_forNeeded_forStock() instead
	* '''Returns''': catalog items we need to order more of in order to satisfy stock minima		* '''Returns''': catalog items we need to order more of in order to satisfy stock minima
	** Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.		** Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.
	* '''History''':		* '''History''':
	** '''2010-01-02''' Created		** '''2010-01-02''' Created
			** '''2015-12-30''' Replaced with PHP-generated SQL
	* '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin		* '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
	* '''Requires''': {{vbzcart/query\|qryStkItms_for_sale}}		* '''Requires''': {{vbzcart/query\|qryStkItms_for_sale}}
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS		<mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS
	SELECT		SELECT
	i.ID,		i.ID,
Line 16:		Line 18:
	ON s.ID_Item=i.ID		ON s.ID_Item=i.ID
	WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>		WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>
	~~<section end=sql />~~

Woozle: "returns" explanation

2010-12-05T13:55:21Z

"returns" explanation

← Older revision		Revision as of 13:55, 5 December 2010
Line 1:		Line 1:
	==About==		==About==
			* '''Returns''': catalog items we need to order more of in order to satisfy stock minima
			** Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.
	* '''History''':		* '''History''':
	** '''2010-01-02''' Created		** '''2010-01-02''' Created

Woozle: Created page with '==About== * '''History''': ** '''2010-01-02''' Created * '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin * '''Requires''': {{vbzcart/query|qryStk…'

2010-01-03T00:45:42Z

Created page with '==About== * '''History''': ** '''2010-01-02''' Created * '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin * '''Requires''': {{vbzcart/query|qryStk…'

New page

==About==
* '''History''':
** '''2010-01-02''' Created
* '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
* '''Requires''': {{vbzcart/query|qryStkItms_for_sale}}
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS
SELECT
i.ID,
i.QtyMin_Stk,
s.QtyForSale
FROM cat_items AS i
LEFT JOIN qryStkItms_for_sale AS s
ON s.ID_Item=i.ID
WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>
<section end=sql />