VbzCart/queries/qryCat Items Stock - Revision history

Woozle: underlying query renamed

2009-11-29T23:23:23Z

underlying query renamed

← Older revision		Revision as of 23:23, 29 November 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Requires''': {{vbzcart\|table\|cat_items}}, {{vbzcart/query\|~~v_stk_items_remaining~~}}		* '''Requires''': {{vbzcart\|table\|cat_items}}, {{vbzcart/query\|qryStk_items_remaining}}
	* '''Used by''': {{vbzcart/query\|qryItTypsDepts_grpItems}}		* '''Used by''': {{vbzcart/query\|qryItTypsDepts_grpItems}}
	* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed		* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
	* '''History''':		* '''History''':
	** '''2009-04-12''' Created to replace cat_items.qtyInStock field		** '''2009-04-12''' Created to replace cat_items.qtyInStock field
			** '''2009-11-29''' Underlying query renamed
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS
Line 12:		Line 12:
	SUM(st.qtyForSale) AS qtyForSale,		SUM(st.qtyForSale) AS qtyForSale,
	SUM(st.qtyForShip) AS qtyForShip		SUM(st.qtyForShip) AS qtyForShip
	FROM (cat_items AS i LEFT JOIN ~~v_stk_items_remaining~~ AS st on i.ID=st.ID_Item)		FROM (cat_items AS i LEFT JOIN qryStk_items_remaining AS st on i.ID=st.ID_Item)
	GROUP BY i.ID;</mysql>		GROUP BY i.ID;</mysql>
	<section end=sql />		<section end=sql />

Woozle: /* About */ space -> underscore

2009-05-07T13:42:25Z

About: space -> underscore

← Older revision		Revision as of 13:42, 7 May 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Requires''': {{vbzcart/table\|cat_items}}, {{vbzcart/query\|v_stk_items_remaining}}		* '''Requires''': {{vbzcart\|table\|cat_items}}, {{vbzcart/query\|v_stk_items_remaining}}
	* '''Used by''': {{vbzcart/query\|~~qryItTypsDepts grpItems~~}}		* '''Used by''': {{vbzcart/query\|qryItTypsDepts_grpItems}}
	* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed		* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
	* '''History''':		* '''History''':
	** '''2009-04-12''' Created to replace cat_items.qtyInStock field		** '''2009-04-12''' Created to replace cat_items.qtyInStock field

	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS

Woozle: New page: ==About== * '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_items_remaining}} * '''Used by''': {{vbzcart/query|qryItTypsDepts grpItems}} * '''Notes''': This may turn out...

2009-04-13T01:30:17Z

New page: ==About== * '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_items_remaining}} * '''Used by''': {{vbzcart/query|qryItTypsDepts grpItems}} * '''Notes''': This may turn out...

New page

==About==
* '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_items_remaining}}
* '''Used by''': {{vbzcart/query|qryItTypsDepts grpItems}}
* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
* '''History''':
** '''2009-04-12''' Created to replace cat_items.qtyInStock field
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS
SELECT
i.*,
SUM(st.qtyForSale) AS qtyForSale,
SUM(st.qtyForShip) AS qtyForShip
FROM (cat_items AS i LEFT JOIN v_stk_items_remaining AS st on i.ID=st.ID_Item)
GROUP BY i.ID;</mysql>
<section end=sql />