VbzCart/queries/qryItms to restock w info - Revision history

Woozle: status update

2016-03-02T22:01:52Z

status update

← Older revision		Revision as of 22:01, 2 March 2016
Line 6:		Line 6:
	** '''2008-11-20''' created for new restock process		** '''2008-11-20''' created for new restock process
	** '''2008-11-22''' +ID_Supplier; using qryCat_Items instead of cat_items + cat_titles (+cat_depts would also have been needed to get ID_Supplier)		** '''2008-11-22''' +ID_Supplier; using qryCat_Items instead of cat_items + cat_titles (+cat_depts would also have been needed to get ID_Supplier)
			** '''2016-03-02''' This query never even got migrated to the latest server, so obviously isn't needed. (Also depends on {{vbzcart/query\|qryCat_Items}}, which doesn't work anymore.)
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE OR REPLACE VIEW qryItms_to_restock_w_info AS		<mysql>CREATE OR REPLACE VIEW qryItms_to_restock_w_info AS
	SELECT		SELECT
	qir.*,		qir.*,
Line 18:		Line 19:
	qryItms_to_restock AS qir		qryItms_to_restock AS qir
	LEFT JOIN qryCat_Items AS i ON qir.ID_Item=i.ID;</mysql>		LEFT JOIN qryCat_Items AS i ON qir.ID_Item=i.ID;</mysql>
	~~<section end=sql />~~

Woozle: New page: ==Details== * '''Returns''': Same data as {{vbzcart/query|qryItms_to_restock}} but with additional info as needed for creating a restock request * '''Requires''': {{vbzcart/query|qryItms_t...

2008-12-03T21:31:46Z

New page: ==Details== * '''Returns''': Same data as {{vbzcart/query|qryItms_to_restock}} but with additional info as needed for creating a restock request * '''Requires''': {{vbzcart/query|qryItms_t...

New page

==Details==
* '''Returns''': Same data as {{vbzcart/query|qryItms_to_restock}} but with additional info as needed for creating a restock request
* '''Requires''': {{vbzcart/query|qryItms_to_restock}}, {{vbzcart/query|qryCat_Items}}
* '''Used by''':
* '''History''':
** '''2008-11-20''' created for new restock process
** '''2008-11-22''' +ID_Supplier; using qryCat_Items instead of cat_items + cat_titles (+cat_depts would also have been needed to get ID_Supplier)
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItms_to_restock_w_info AS
SELECT
qir.*,
i.ID_Supplier,
i.isInPrint,
i.PriceBuy,
i.PriceSell,
i.QtyMin_Rstk_Title
FROM
qryItms_to_restock AS qir
LEFT JOIN qryCat_Items AS i ON qir.ID_Item=i.ID;</mysql>
<section end=sql />