VbzCart/queries - Revision history

Woozle: /* new queries */ many more queries no longer in db

2016-03-03T23:12:39Z

new queries: many more queries no longer in db

← Older revision		Revision as of 23:12, 3 March 2016
Line 118:		Line 118:
	*** [[/qryStkItms_for_sale]]		*** [[/qryStkItms_for_sale]]

	** [[/qryStk_items_remaining]]		* [[/qryStk_items_remaining]]
	** [[/qryStk_byItem_byBin]]		* [[/qryStk_byItem_byBin]]
	*** [[/qryStk_byItem_byBin_wInfo]]

	* [[/qryStk_lines_Title_info]]		* [[/qryStk_lines_Title_info]]
	* [[/qryStkItms_for_sale_wItem_data]]
	* [[/qryStock_forOpenOrders]]
	* [[/qryStock_byOpt_andType]]
	* [[/qryStock_by_Opt_Type]]
	* [[/qryStock_by_Supp_Type_Opt]] - unused (and should be Supp_Opt_Type)
	* [[/qryStock_Titles_most_recent]]
	* {{vbzcart/table\|stk_history\|stock history}} queries:
	** [[/qryStock_containers]] - generates IDS codes
	** [[/qryStk_History]] - includes {{vbzcart/table\|stk_history_legacy\|legacy table}} data

	====old queries====		====old queries====

Woozle: 4 more disused queries

2016-03-02T22:59:24Z

4 more disused queries

← Older revision		Revision as of 22:59, 2 March 2016
Line 102:		Line 102:
	* '''filtered by status''':		* '''filtered by status''':
	** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed - see {{l/vc/term\|restock/status}})		** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed - see {{l/vc/term\|restock/status}})
	*** [[/qryRstkItms_active]]
	**** [[/qryRstkItms_expected]]
	***** [[/qryRstkItms_expected_byItem]] - grouped by ID_Item
	*** [[/qryRstks_unsent]]: created but not ordered yet		*** [[/qryRstks_unsent]]: created but not ordered yet
	**** [[/qryRstkItms_unsent]]		**** [[/qryRstkItms_unsent]]
Line 120:		Line 117:
	** [[/qryStk_lines_remaining_forSale]]		** [[/qryStk_lines_remaining_forSale]]
	*** [[/qryStkItms_for_sale]]		*** [[/qryStkItms_for_sale]]
	**** [[/qryItems_needed_forStock]]
	** [[/qryStk_items_remaining]]		** [[/qryStk_items_remaining]]
	** [[/qryStk_byItem_byBin]]		** [[/qryStk_byItem_byBin]]

Woozle: /* Catalog Sources */ 3 more queries that don't work anymore

2016-03-02T22:47:59Z

Catalog Sources: 3 more queries that don't work anymore

← Older revision		Revision as of 22:47, 2 March 2016
Line 45:		Line 45:
	* [[/qryCtg_Items_updates_joinable]]		* [[/qryCtg_Items_updates_joinable]]
	* [[/qryCtg_Items_active]]		* [[/qryCtg_Items_active]]
	* [[/qryCtg_Titles_active]]
	* <s>[[/qryCtg_build_sub]]</s>		* <s>[[/qryCtg_build_sub]]</s>
	* <s>[[/qryCtg_build]]</s>		* <s>[[/qryCtg_build]]</s>
	* '''[[VbzCart catalog building\|building]] process''':		* '''[[VbzCart catalog building\|building]] process''':
	** [[/qryCtg_src]]
	** [[/qryCtg_src_sub]]
	** [[/qryCtg_Items_forUpdJoin]]		** [[/qryCtg_Items_forUpdJoin]]
	** [[/qryCtg_Upd_join]]		** [[/qryCtg_Upd_join]]
	** [[/qryCtg_src_dups]]		** [[/qryCtg_src_dups]]
	** [[/qryCtgCk_dup_keys]]		** [[/qryCtgCk_dup_keys]]

	====Catalog Topics====		====Catalog Topics====
	* '''titles x topics''':		* '''titles x topics''':

Woozle: /* by category */ gaah

2016-03-02T22:35:16Z

by category: gaah

← Older revision		Revision as of 22:35, 2 March 2016
Line 103:		Line 103:
	*** [[/qryRstkReq_by_PurchOrd]]		*** [[/qryRstkReq_by_PurchOrd]]
	* '''filtered by status''':		* '''filtered by status''':
	** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed - see {{l/vc/~~terms~~\|restock/status}})		** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed - see {{l/vc/term\|restock/status}})
	*** [[/qryRstkItms_active]]		*** [[/qryRstkItms_active]]
	**** [[/qryRstkItms_expected]]		**** [[/qryRstkItms_expected]]

Woozle: /* by category */ obsoleted 2 queries; moved some terminology closer to where it belongs

2016-03-02T22:34:17Z

by category: obsoleted 2 queries; moved some terminology closer to where it belongs

← Older revision		Revision as of 22:34, 2 March 2016
Line 34:		Line 34:
	* [[/qryCat_pages]]: maps http path info to catalog entities		* [[/qryCat_pages]]: maps http path info to catalog entities
	====Catalog Items====		====Catalog Items====
	* [[/qryCat_Items]]
	* [[/qryCbx_Items_data]]		* [[/qryCbx_Items_data]]
	** [[/qryCbx_Items]]		** [[/qryCbx_Items]]
Line 61:		Line 60:
	** [[/qryTitleTopic_Topics]]: more topic information		** [[/qryTitleTopic_Topics]]: more topic information
	** [[/qryTitleTopic_Title_avail]]: title availability information		** [[/qryTitleTopic_Title_avail]]: title availability information

	===Ordering===		===Ordering===
	====Carts====		====Carts====
Line 82:		Line 80:
	* [[/qryItms_to_restock_union]]		* [[/qryItms_to_restock_union]]
	* [[/qryItms_to_restock]]		* [[/qryItms_to_restock]]
	* [[/qryItms_to_restock_w_info]]
	====Packages====		====Packages====
	* [[/qryPkgLines_byOrdLine_andItem]]		* [[/qryPkgLines_byOrdLine_andItem]]
Line 106:		Line 103:
	*** [[/qryRstkReq_by_PurchOrd]]		*** [[/qryRstkReq_by_PurchOrd]]
	* '''filtered by status''':		* '''filtered by status''':
	** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed)		** [[/qryRstks_active]]: not terminated = !(closed, orphaned or killed - see {{l/vc/terms\|restock/status}})
	*** [[/qryRstkItms_active]]		*** [[/qryRstkItms_active]]
	**** [[/qryRstkItms_expected]]		**** [[/qryRstkItms_expected]]
Line 114:		Line 111:
	***** [[/qryRstkItms_unsent_for_order]]		***** [[/qryRstkItms_unsent_for_order]]
	** [[/qryRstks_inactive]]: all the rest		** [[/qryRstks_inactive]]: all the rest

	~~'''terminology'''~~
	* '''Active''' = not "terminated", i.e. not "closed", "killed", or "orphaned" (may or may not be "expected" yet)
	* '''Closed''' = received from supplier, nothing remaining on backorder
	* '''Expected''' = placed with supplier, but not yet received
	* '''Killed''' = canceled with supplier after having been placed
	* '''Orphaned''' = we don't have records that anything was received, but nothing further is expected (usually old data)
	* '''Terminated''' = closed, orphaned, or killed
	* '''Unsent''' = created but not yet placed with supplier, i.e. not "expected"
	~~'''phases''':~~
	~~{\| border=1~~
	\|-
	~~\| colspan=5 \| Time →~~
	\|-
	~~\| '''Created''' \|\| (Unsent) \|\| '''Ordered''' \|\| (Expected) \|\| '''Closed''', '''Killed''', or '''Orphaned'''~~
	\|-
	~~\| colspan=4 align=center \| --(Active)-- \|\| align=center \| --(Terminated/Inactive)--~~
	\|}

	====Shipping====		====Shipping====

Woozle: /* Catalog */ qryTitles_Imageless

2012-01-11T02:08:06Z

Catalog: qryTitles_Imageless

← Older revision		Revision as of 02:08, 11 January 2012
Line 14:		Line 14:
	===Catalog===		===Catalog===
	* [[/qryCat_Depts]]		* [[/qryCat_Depts]]
	* [[/qryTitles_Item_info]]		* '''Title'''-centric:
	* [[/qryTitles_ItTyps_grpItems]]		** [[/qryTitles_Item_info]]
	* [[/qryTitles_ItTyps_ItTyps]]		** [[/qryTitles_ItTyps_grpItems]]
	* [[/qryTitles_ItTyps_Titles]]		** [[/qryTitles_ItTyps_ItTyps]]
	* [[/~~qryItTypsDepts_grpItems~~]]		** [[/qryTitles_ItTyps_Titles]]
	* ~~[[/qryItTypsDepts_ItTyps]]~~		** [[/qryTitles_Imageless]] - titles with no active images
	* [[/qryCat_Titles]]		** [[/qryCat_Titles]]
	* [[/qryCat_Titles_Item_stats]] -- item/stock statistics		** [[/qryCat_Titles_Item_stats]] -- item/stock statistics
	* [[/qryCat_Titles_Item_count]] -- simpler query for maintenance		** [[/qryCat_Titles_Item_count]] -- simpler query for maintenance
	* [[/qryCat_Titles_web]]		** [[/qryCat_Titles_web]]
	* [[/qryCbx_Titles]]		** [[/qryCbx_Titles]]
	* [[/qryCat_Items_Stock]]: cat_items with stock info		* '''Item'''-centric:
			** [[/qryCat_Items_Stock]]: cat_items with stock info
			* '''ItTyp'''-centric:
			** [[/qryItTypsDepts_grpItems]]
			** [[/qryItTypsDepts_ItTyps]]
			* '''Image'''-centric:
			** [[/qryImgs_byTitle]]: Image info by Title
	* [[/qryCat_pages]]: maps http path info to catalog entities		* [[/qryCat_pages]]: maps http path info to catalog entities
	====Catalog Items====		====Catalog Items====

Woozle: added query I ended up not using, to be deleted later

2011-06-01T23:29:36Z

added query I ended up not using, to be deleted later

← Older revision		Revision as of 23:29, 1 June 2011
Line 86:		Line 86:
	** [[/qryRpt_Pkg_Lines]]		** [[/qryRpt_Pkg_Lines]]
	*** [[/qryPkgLines_qtys_done]]		*** [[/qryPkgLines_qtys_done]]
			*** <s>[[/qryPkgLines_qtys_done_ord_sum]]</s> - not used
	** [[/qryRpt_Pkg_Trx]]		** [[/qryRpt_Pkg_Trx]]

Woozle: /* Packages */ qryRpt_Pkg_Trx

2011-06-01T23:27:36Z

Packages: qryRpt_Pkg_Trx

← Older revision		Revision as of 23:27, 1 June 2011
Line 85:		Line 85:
	* for reports:		* for reports:
	** [[/qryRpt_Pkg_Lines]]		** [[/qryRpt_Pkg_Lines]]
	** [[/qryPkgLines_qtys_done]]		*** [[/qryPkgLines_qtys_done]]
			** [[/qryRpt_Pkg_Trx]]

	====Restocks====		====Restocks====

Woozle: /* Packages */ qryPkgLines_qtys_done

2011-06-01T01:32:11Z

Packages: qryPkgLines_qtys_done

← Older revision		Revision as of 01:32, 1 June 2011
Line 85:		Line 85:
	* for reports:		* for reports:
	** [[/qryRpt_Pkg_Lines]]		** [[/qryRpt_Pkg_Lines]]
			** [[/qryPkgLines_qtys_done]]

	====Restocks====		====Restocks====

Woozle: /* Packages */ qryRpt_Pkg_Lines

2011-05-31T16:34:16Z

Packages: qryRpt_Pkg_Lines

← Older revision		Revision as of 16:34, 31 May 2011
Line 83:		Line 83:
	* [[/qryOrders_Pulled]]		* [[/qryOrders_Pulled]]
	* [[/qryPkgs_Pull_status]]		* [[/qryPkgs_Pull_status]]
			* for reports:
			** [[/qryRpt_Pkg_Lines]]

	====Restocks====		====Restocks====
	* '''all restock requests''':		* '''all restock requests''':