VbzCart/queries/discarded - Revision history

Woozle: /* More Recent */ many more queries no longer in database

2016-03-03T23:12:25Z

More Recent: many more queries no longer in database

← Older revision		Revision as of 23:12, 3 March 2016
Line 10:		Line 10:
	** {{l/vc/query\|qryRstkItms_expected}}		** {{l/vc/query\|qryRstkItms_expected}}
	*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item		*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item
			* {{l/vc/query\|qryStk_History}} - combined current stock history and {{l/vc/table\|stk_history_legacy}} data
			* {{l/vc/query\|qryStock_containers}} - generated IDS codes
			* {{l/vc/query\|qryStock_forOpenOrders}}
			* {{l/vc/query\|qryStock_byOpt_andType}}
			* {{l/vc/query\|qryStock_by_Opt_Type}}
			* {{l/vc/query\|qryStock_by_Supp_Type_Opt}} - unused (and should be Supp_Opt_Type)
			* {{l/vc/query\|qryStock_Titles_most_recent}}
			* {{l/vc/query\|qryStkItms_for_sale_wItem_data}}
			* {{l/vc/query\|qryStk_byItem_byBin_wInfo}} - adds information to {{l/vc/query\|qryStk_byItem_byBin}}

	==Older==		==Older==

Woozle: 4 more

2016-03-02T22:59:32Z

4 more

← Older revision		Revision as of 22:59, 2 March 2016
Line 1:		Line 1:
	==More Recent==		==More Recent==
	* {{~~vbzcart~~/query\|qryCat_Items}} - no longer even works		The pages for these still need to be moved:
	* {{~~vbzcart~~/query\|qryItms_to_restock_w_info}} - wasn't even migrated to current server		* {{l/vc/query\|qryCat_Items}} - no longer even works
			* {{l/vc/query\|qryItms_to_restock_w_info}} - wasn't even migrated to current server
			* {{l/vc/query\|qryCtg_Titles_active}}
			* {{l/vc/query\|qryCtg_src}}
			* {{l/vc/query\|qryCtg_src_sub}}
			* {{l/vc/query\|qryItems_needed_forStock}}
			* {{l/vc/query\|qryRstkItms_active}}
			** {{l/vc/query\|qryRstkItms_expected}}
			*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item


	==Older==		==Older==

Woozle: another

2016-03-02T22:02:54Z

another

← Older revision		Revision as of 22:02, 2 March 2016
Line 1:		Line 1:
	==More Recent==		==More Recent==
	* {{vbzcart/query\|qryCat_Items}} - no longer even works		* {{vbzcart/query\|qryCat_Items}} - no longer even works
			* {{vbzcart/query\|qryItms_to_restock_w_info}} - wasn't even migrated to current server

	==Older==		==Older==
	* [[/v_items]]		* [[/v_items]]

Woozle: moved each query into its own page, for easier management

2016-03-02T21:59:01Z

moved each query into its own page, for easier management

@@ Line 1: / Line 1: @@
-==v_items==
+==More Recent==
-===Details===
+* {{vbzcart/query|qryCat_Items}} - no longer even works
-* '''Used by''': clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.
+==Older==
-===SQL===
+* [[/v_items]]
-<section begin=sql /><mysql>CREATE OR REPLACE VIEW `v_items` AS
+* [[/qryRstkReq_wItem_info]]
-  SELECT
+* [[/qryCbx_Restocks_byStatus]]
-    i.ID,
+* [[/qryCbx_Restocks_byPurchOrd]]
-    i.CatNum,
+* [[/qryCbx_Restocks]]

Woozle: /* qryCbx_Restocks */ updated status

2008-12-22T18:58:37Z

qryCbx_Restocks: updated status

← Older revision		Revision as of 18:58, 22 December 2008
Line 96:		Line 96:
	==qryCbx_Restocks==		==qryCbx_Restocks==
	===Details===		===Details===
	* '''Status''': ~~deprecated~~ (ultimately depends on old restock table~~); can probably be deleted~~, ~~since nothing should be using those tables~~ anymore.		* '''Status''': deleted (ultimately depends on old restock table, so doesn't work anymore)
	* ''' Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.		* '''Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.
	===SQL===		===SQL===
	<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks AS		<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks AS

Woozle: /* qryCbx_Restocks_byPurchOrd */ updated status

2008-12-22T18:38:19Z

qryCbx_Restocks_byPurchOrd: updated status

← Older revision		Revision as of 18:38, 22 December 2008
Line 78:		Line 78:
	==qryCbx_Restocks_byPurchOrd==		==qryCbx_Restocks_byPurchOrd==
	===Details===		===Details===
	* '''Status''': ~~deprecated~~ (uses old restock table)~~; can probably be deleted, since nothing should be using those tables anymore.~~		* '''Status''': deleted (uses old restock table, and no longer works)
	* '''Requires''': {{vbzcart/table\|core_restocks}}		* '''Requires''': {{vbzcart/table\|core_restocks}}
	* '''Used by''': [[#qryCbx_Restocks]]		* '''Used by''': [[#qryCbx_Restocks]]
Line 93:		Line 93:
	FROM core_restocks AS r WHERE r.PurchOrdNum IS NOT NULL		FROM core_restocks AS r WHERE r.PurchOrdNum IS NOT NULL
	ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;</mysql>		ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;</mysql>

	==qryCbx_Restocks==		==qryCbx_Restocks==
	===Details===		===Details===

Woozle: qryCbx_Restocks* series is now discarded

2008-12-22T17:43:39Z

qryCbx_Restocks* series is now discarded

← Older revision		Revision as of 17:43, 22 December 2008
Line 46:		Line 46:
	LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)		LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)
	LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>		LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>
			==qryCbx_Restocks_byStatus==
			===Details===
			* '''Status''': deprecated (uses old restock tables); can probably be deleted, since nothing should be using those tables anymore.
			* '''Requires''': {{vbzcart/table\|core_restocks}}, {{vbzcart/table\|cat_supp}}
			* '''Used by''': {{vbzcart/query\|qryCbx_Restocks}}
			===SQL===
			<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks_byStatus AS
			SELECT
			r.ID,
			CAST(
			CONCAT(
			CAST(COALESCE(
			CONCAT('X ',DATE_FORMAT(r.WhenKilled,'%Y-%m-%d')),
			CONCAT('R ',DATE_FORMAT(r.WhenReceived,'%Y-%m-%d')),
			CONCAT('O ',DATE_FORMAT(r.WhenOrdered,'%Y-%m-%d')),
			CONCAT('D ',DATE_FORMAT(r.WhenDebited,'%Y-%m-%d')),
			CONCAT('C ',DATE_FORMAT(r.WhenCreated,'%Y-%m-%d'))
			) AS BINARY),
			' ',
			s.CatKey,
			IFNULL(CONCAT(' [',r.PurchOrdNum,']'),'')
			) AS CHAR
			) AS Descr,
			NOT IsLocked AS IsOpen,
			r.WhenOrdered,
			r.WhenReceived,
			r.WhenConfirmed,
			r.ID_Supplier
			FROM core_restocks AS r LEFT JOIN cat_supp AS s ON r.ID_Supplier=s.ID
			ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;</mysql>
			==qryCbx_Restocks_byPurchOrd==
			===Details===
			* '''Status''': deprecated (uses old restock table); can probably be deleted, since nothing should be using those tables anymore.
			* '''Requires''': {{vbzcart/table\|core_restocks}}
			* '''Used by''': [[#qryCbx_Restocks]]
			===SQL===
			<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks_byPurchOrd AS
			SELECT
			r.ID,
			CAST(r.PurchOrdNum AS CHAR) AS Descr,
			NOT IsLocked AS IsOpen,
			r.WhenOrdered,
			r.WhenReceived,
			r.WhenConfirmed,
			r.ID_Supplier
			FROM core_restocks AS r WHERE r.PurchOrdNum IS NOT NULL
			ORDER BY COALESCE(r.WhenKilled,r.WhenReceived,r.WhenOrdered,r.WhenDebited,r.WhenCreated) DESC;</mysql>
			==qryCbx_Restocks==
			===Details===
			* '''Status''': deprecated (ultimately depends on old restock table); can probably be deleted, since nothing should be using those tables anymore.
			* ''' Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.
			===SQL===
			<mysql>CREATE OR REPLACE VIEW qryCbx_Restocks AS
			SELECT * FROM qryCbx_Restocks_byStatus
			UNION
			SELECT * FROM qryCbx_Restocks_byPurchOrd;</mysql>

Woozle: qryRstkReq_wItem_info

2008-12-03T23:54:02Z

qryRstkReq_wItem_info

← Older revision		Revision as of 23:54, 3 December 2008
Line 29:		Line 29:
	((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>		((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>
	<section end=sql />		<section end=sql />
			==qryRstkReq_wItem_info==
			===Details===
			* '''Status''': not being used
			* '''History''':
			** '''2008-11-21''' Created for new restock process
			** '''2008-12-03''' officially abandoned
			===SQL===
			<mysql>CREATE OR REPLACE VIEW qryRstkReq_wItem_info AS
			SELECT
			rqi.*,
			i.ID_Title,
			r.WhenCreated,
			r.WhenOrdered
			FROM
			(rstk_req_item AS rqi
			LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)
			LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>

Woozle: v_items

2008-11-30T18:55:08Z

v_items

New page

==v_items==
===Details===
* '''Used by''': clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.
===SQL===
<section begin=sql /><mysql>CREATE OR REPLACE VIEW `v_items` AS
SELECT
i.ID,
i.CatNum,
i.isForSale,
i.isMaster,
i.qtyInStock,
i.isInPrint,
i.isCloseOut,
i.isPulled,
i.isDumped,
i.ID_Title,
i.ID_ItTyp,
i.ID_ItOpt,
i.ItOpt_Descr,
i.ID_ShipCost,
i.PriceBuy,
i.PriceSell,
i.PriceList,
i.Supp_CatNum,
io.Sort AS OptSort
FROM (
`cat_items` AS `i` LEFT JOIN
`cat_ioptns` AS `io` ON
((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>
<section end=sql />

← Older revision		Revision as of 23:12, 3 March 2016
Line 10:		Line 10:
	** {{l/vc/query\|qryRstkItms_expected}}		** {{l/vc/query\|qryRstkItms_expected}}
	*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item		*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item
			* {{l/vc/query\|qryStk_History}} - combined current stock history and {{l/vc/table\|stk_history_legacy}} data
			* {{l/vc/query\|qryStock_containers}} - generated IDS codes
			* {{l/vc/query\|qryStock_forOpenOrders}}
			* {{l/vc/query\|qryStock_byOpt_andType}}
			* {{l/vc/query\|qryStock_by_Opt_Type}}
			* {{l/vc/query\|qryStock_by_Supp_Type_Opt}} - unused (and should be Supp_Opt_Type)
			* {{l/vc/query\|qryStock_Titles_most_recent}}
			* {{l/vc/query\|qryStkItms_for_sale_wItem_data}}
			* {{l/vc/query\|qryStk_byItem_byBin_wInfo}} - adds information to {{l/vc/query\|qryStk_byItem_byBin}}

	==Older==		==Older==

← Older revision		Revision as of 22:59, 2 March 2016
Line 1:		Line 1:
	==More Recent==		==More Recent==
	* {{~~vbzcart~~/query\|qryCat_Items}} - no longer even works		The pages for these still need to be moved:
	* {{~~vbzcart~~/query\|qryItms_to_restock_w_info}} - wasn't even migrated to current server		* {{l/vc/query\|qryCat_Items}} - no longer even works
			* {{l/vc/query\|qryItms_to_restock_w_info}} - wasn't even migrated to current server
			* {{l/vc/query\|qryCtg_Titles_active}}
			* {{l/vc/query\|qryCtg_src}}
			* {{l/vc/query\|qryCtg_src_sub}}
			* {{l/vc/query\|qryItems_needed_forStock}}
			* {{l/vc/query\|qryRstkItms_active}}
			** {{l/vc/query\|qryRstkItms_expected}}
			*** {{l/vc/query\|qryRstkItms_expected_byItem}} - grouped by ID_Item


	==Older==		==Older==