VbzCart/queries/qryRstkReq Items expected - Revision history

Woozle: ...oh, and the future has been dealt with.

2010-01-06T00:16:37Z

...oh, and the future has been dealt with.

← Older revision		Revision as of 00:16, 6 January 2010
Line 7:		Line 7:
	** '''2010-01-03''' Created for generating list of needed items		** '''2010-01-03''' Created for generating list of needed items
	** '''2010-01-04''' This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results		** '''2010-01-04''' This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results
	* '''Future''': This probably does not take into account the '''QtyExp''' field, which should override the '''QtyOrd''' field.
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS

Woozle: corrected slightly, but deprecated anyway

2010-01-06T00:16:13Z

corrected slightly, but deprecated anyway

← Older revision		Revision as of 00:16, 6 January 2010
Line 2:		Line 2:
	* '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already received for those requests		* '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already received for those requests
	* '''Requires''': {{vbzcart/query\|qryRstkReq_Item_status}}		* '''Requires''': {{vbzcart/query\|qryRstkReq_Item_status}}
	* '''Used by ''': ~~"items needed" admin page~~		* '''Used by ''': DEPRECATED - seems less accurate than {{vbzcart/query\|qryRstkItms_expected_byItem}}
	* '''Related''': Like {{vbzcart/query\|qryRstkItms_expected}}, but grouped by Item (eliminates rstk_req data)		* '''Related''': Like {{vbzcart/query\|qryRstkItms_expected}}, but grouped by Item (eliminates rstk_req data)
	* '''History''':		* '''History''':
	** '''2010-01-03''' Created for generating list of needed items		** '''2010-01-03''' Created for generating list of needed items
			** '''2010-01-04''' This query now deprecated and can probably be deleted; using QtyExp instead of QtyOrd for verification of results
			* '''Future''': This probably does not take into account the '''QtyExp''' field, which should override the '''QtyOrd''' field.
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS
Line 11:		Line 13:
	ID_Item,		ID_Item,
	SUM(QtyRecd) AS QtyRecd,		SUM(QtyRecd) AS QtyRecd,
	SUM(~~QtyOrd~~) AS ~~QtyOrd~~		SUM(QtyExp) AS QtyExp
	FROM qryRstkReq_Item_status		FROM qryRstkReq_Item_status
	GROUP BY ID_Item		GROUP BY ID_Item
	HAVING SUM(~~QtyOrd~~)-SUM(QtyRecd)>0;</mysql>		HAVING SUM(QtyExp)-SUM(QtyRecd)>0;</mysql>
	<section end=sql />		<section end=sql />

Woozle: Created page with '==About== * '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already…'

2010-01-04T02:32:12Z

Created page with '==About== * '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already…'

New page

==About==
* '''Purpose''': Returns a list of items we're currently expecting to receive in restocks, based on items requested (in active restock requests only) less items already received for those requests
* '''Requires''': {{vbzcart/query|qryRstkReq_Item_status}}
* '''Used by ''': "items needed" admin page
* '''Related''': Like {{vbzcart/query|qryRstkItms_expected}}, but grouped by Item (eliminates rstk_req data)
* '''History''':
** '''2010-01-03''' Created for generating list of needed items
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryRstkReq_Items_expected AS
SELECT
ID_Item,
SUM(QtyRecd) AS QtyRecd,
SUM(QtyOrd) AS QtyOrd
FROM qryRstkReq_Item_status
GROUP BY ID_Item
HAVING SUM(QtyOrd)-SUM(QtyRecd)>0;</mysql>
<section end=sql />