VbzCart/queries/qryRstkItms active - Revision history

Woozle at 22:54, 2 March 2016

2016-03-02T22:54:55Z

← Older revision		Revision as of 22:54, 2 March 2016
Line 2:		Line 2:
	* '''Obsolete''': use '''VCT_RstkReqItems::SQLobj_Items_active()''' or '''::SQLstr_Items_active()''' instead		* '''Obsolete''': use '''VCT_RstkReqItems::SQLobj_Items_active()''' or '''::SQLstr_Items_active()''' instead
	* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).		* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
	* '''Requires''': {{~~vbzcart~~/table\|rstk_req_item}}, {{~~vbzcart~~/query\|qryRstks_active}}		* '''Requires''': {{l/vc/table\|rstk_req_item}}, {{l/vc/query\|qryRstks_active}}
	* '''Used by''': {{~~vbzcart~~/query\|qryRstkItms_expected}}		* '''Used by''': {{l/vc/query\|qryRstkItms_expected}}
	* '''Note''': This is different from qryRstkLines_en_route (deprecated):		* '''Note''': This is different from qryRstkLines_en_route (deprecated):
	** Grouped by Item instead of Restock Line		** Grouped by Item instead of Restock Line
Line 11:		Line 11:
	** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp		** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp
	** '''2015-12-31''' replacing this with PHP-generated SQL		** '''2015-12-31''' replacing this with PHP-generated SQL
			** '''2016-03-02''' Query no longer works; removing from database.
	==SQL==		==SQL==
	<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS		<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS

Woozle: obsolete

2015-12-31T20:48:28Z

obsolete

← Older revision		Revision as of 20:48, 31 December 2015
Line 1:		Line 1:
	==Details==		==Details==
			* '''Obsolete''': use '''VCT_RstkReqItems::SQLobj_Items_active()''' or '''::SQLstr_Items_active()''' instead
	* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).		* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
	* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstks_active}}		* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstks_active}}
Line 9:		Line 10:
	** '''2008-11-18''' Created for new restock process		** '''2008-11-18''' Created for new restock process
	** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp		** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp
			** '''2015-12-31''' replacing this with PHP-generated SQL
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS		<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS
	SELECT		SELECT
	rrq.ID_Restock,		rrq.ID_Restock,
Line 19:		Line 21:
	WHERE rq.ID IS NOT NULL		WHERE rq.ID IS NOT NULL
	GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>		GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>
	~~<section end=sql />~~

Woozle: change in qty calculation

2010-01-05T00:34:00Z

change in qty calculation

← Older revision		Revision as of 00:34, 5 January 2010
Line 8:		Line 8:
	* '''History''':		* '''History''':
	** '''2008-11-18''' Created for new restock process		** '''2008-11-18''' Created for new restock process
			** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS
Line 13:		Line 14:
	rrq.ID_Restock,		rrq.ID_Restock,
	rrq.ID_Item,		rrq.ID_Item,
	SUM(rrq.QtyOrd) AS ~~QtyOrd~~		SUM(IFNULL(rrq.QtyExp,rrq.QtyOrd)) AS QtyExp
	FROM		FROM rstk_req_item AS rrq
	rstk_req_item AS rrq		LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID
	LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID
	WHERE rq.ID IS NOT NULL		WHERE rq.ID IS NOT NULL
	GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>		GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>
	<section end=sql />		<section end=sql />

Woozle: used by

2010-01-03T15:26:32Z

used by

← Older revision		Revision as of 15:26, 3 January 2010
Line 2:		Line 2:
	* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).		* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
	* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstks_active}}		* '''Requires''': {{vbzcart/table\|rstk_req_item}}, {{vbzcart/query\|qryRstks_active}}
	* '''Used by'''		* '''Used by''': {{vbzcart/query\|qryRstkItms_expected}}
	* '''Note''': This is different from qryRstkLines_en_route (deprecated):		* '''Note''': This is different from qryRstkLines_en_route (deprecated):
	** Grouped by Item instead of Restock Line		** Grouped by Item instead of Restock Line

Woozle: New page: ==Details== * '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). * '''Requires''': {{vbzcart/table|rstk_req_item}}, {...

2008-12-04T00:29:37Z

New page: ==Details== * '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). * '''Requires''': {{vbzcart/table|rstk_req_item}}, {...

New page

==Details==
* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
* '''Requires''': {{vbzcart/table|rstk_req_item}}, {{vbzcart/query|qryRstks_active}}
* '''Used by'''
* '''Note''': This is different from qryRstkLines_en_route (deprecated):
** Grouped by Item instead of Restock Line
** Uses new Restock tables
* '''History''':
** '''2008-11-18''' Created for new restock process
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS
SELECT
rrq.ID_Restock,
rrq.ID_Item,
SUM(rrq.QtyOrd) AS QtyOrd
FROM
rstk_req_item AS rrq
LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID
WHERE rq.ID IS NOT NULL
GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>
<section end=sql />