User contributions for Woozle
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
4 December 2008
- 00:3100:31, 4 December 2008 diff hist +907 N VbzCart/queries/qryRstkItms expected New page: ==Details== * '''Returns''': Restock items requested, not yet received, but possibly expected because the restock request hasn't been closed or orphaned. * '''Requires''': {{vbzcart/table|...
- 00:2900:29, 4 December 2008 diff hist +779 N VbzCart/queries/qryRstkItms active New page: ==Details== * '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). * '''Requires''': {{vbzcart/table|rstk_req_item}}, {...
- 00:2700:27, 4 December 2008 diff hist +669 VbzCart/queries/deprecated →qryFrm_RestockLines_byItem: qryRstkLines_en_route
- 00:2600:26, 4 December 2008 diff hist +1,087 N VbzCart/queries/qryRstks active New page: ==Details== * '''Returns''': List of restock requests for which we are currently expecting one or more shipments * '''Requires''': {{vbzcart/table|rstk_req}} * '''Used by''': * '''History'...
- 00:2300:23, 4 December 2008 diff hist +1,376 N VbzCart/queries/qryRstks info New page: ==Details== * '''Returns''': Information about restock requests and receipts, one line per receipt (or request, if nothing received) * '''Requires''': {{vbzcart/table|rstk_req}}, {{vbzcart... current
- 00:1000:10, 4 December 2008 diff hist +2,030 VbzCart/queries/deprecated →qryCbx_Restocks: two queries using rstk_lines
- 00:0500:05, 4 December 2008 diff hist +2,234 VbzCart/queries/deprecated qryCbx queries based on (obsolete) core_restocks
3 December 2008
- 23:5423:54, 3 December 2008 diff hist +446 VbzCart/queries/discarded qryRstkReq_wItem_info
- 23:5023:50, 3 December 2008 diff hist +427 VbzCart/queries/deprecated v_rstk_lines_wItemInfo
- 23:4523:45, 3 December 2008 diff hist −2,254 VbzCart/queries →Packages: moved queries into separate pages
- 23:4523:45, 3 December 2008 diff hist +1,211 N VbzCart/queries/qryOrdLines open New page: ==Details== * '''Requires''': {{vbzcart/query|qryOrders_Active}}, {{vbzcart/query|qryPkgLines_byOrdLine_andItem}} * '''Used by''': * '''History''': ** '''2008-11-02''' +WhenNeeded, +WhenSt... current
- 23:4323:43, 3 December 2008 diff hist +735 N VbzCart/queries/qryOrdLines PkgdQtys New page: ==Details== * '''Requires''': {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * '''Used by''': order detail in Item table * '''History''': ** '''2008-11-21''... current
- 23:4123:41, 3 December 2008 diff hist +535 N VbzCart/queries/qryPkgLines byOrdLine andItem New page: ==Details== * '''Requires''': {{vbzcart/table|ord_pkg_lines}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryPkgLines_byOrdLine_andItem AS SELECT ID_OrdLi... current
- 21:3421:34, 3 December 2008 diff hist −308 VbzCart/queries →Customers: moved query to separate page
- 21:3421:34, 3 December 2008 diff hist +405 N VbzCart/queries/qryCustAddrs New page: ==Details== * '''Requires''': {{vbzcart/table|cust_addrs}} * '''Used by''': * '''Notes''': Any basic simple calculations not involving other tables can be added to this query as needed. ==... current
- 21:3221:32, 3 December 2008 diff hist −9,131 VbzCart/queries →Orders: split off queries into separate pages
- 21:3121:31, 3 December 2008 diff hist +765 N VbzCart/queries/qryItms to restock w info 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...
- 21:3021:30, 3 December 2008 diff hist +1,332 N VbzCart/queries/qryItms to restock New page: ==Details== * '''Returns''': List of items where we need more of them, either to fill orders or to meet minimum stock levels. Accounts for restock items already requested and items current... current
- 21:2821:28, 3 December 2008 diff hist +1,403 N VbzCart/queries/qryItms to restock union New page: ==Details== * '''Returns''': List of all items relevant to calculating items-to-restock, along with the relevant numbers (quantity on hand, quantity needed for orders...) but not combined ...
- 21:2521:25, 3 December 2008 diff hist +528 N VbzCart/queries/qryItms open New page: ==Details== * '''Returns''': Same rows as {{vbzcart/query|qryOrdItms_open}} but GROUPed by ID_Item * '''Requires''': {{vbzcart/query|qryOrdItms_open}} * '''Used by''': * '''History''': ** ... current
- 21:2521:25, 3 December 2008 diff hist +35 N Template:l/vc/query New page: [[VbzCart/queries/{{{1}}}|{{{1}}}]]
- 21:2321:23, 3 December 2008 diff hist +320 N VbzCart/queries/qryOrdItms open New page: ==Details== * '''Requires''': qryOrdItms_Pkg_qtys * '''Used by''': * '''History''': ** '''2008-11-16''' created for new restocking process ==SQL== <section begin... current
- 21:2221:22, 3 December 2008 diff hist +633 N VbzCart/queries/qryOrdItms Pkg qtys New page: ==Details== * '''Requires''': qryOrderLines_Active, qry_PkgItem_qtys_byOrder * '''Used by''': * '''History''': ** '''2008-11-16... current
- 21:1721:17, 3 December 2008 diff hist +1,132 N VbzCart/queries/qry PkgItem qtys byOrder New page: ==Details== * '''Returns''': data for items packaged for each order -- totals actually put into non-voided packages ("QtySent") and totals "handled" ("QtyDone" - sent ''or'' marked as n/a ... current
- 21:1421:14, 3 December 2008 diff hist +882 N VbzCart/queries/qtyOrderItems Active New page: ==Details== * '''Returns''': Same as qryOrderLines_Active, but by Item instead of OrdLine (and leaving out extra info about items which might return multiple re... current
- 21:1121:11, 3 December 2008 diff hist +585 N VbzCart/queries/qryOrderLines Active New page: ==Details== * '''Returns''': all order lines for orders which are currently active as determined by qryOrders_Active. * '''Requires''': {{vbzcart/table|ord_lines}},... current
- 21:0921:09, 3 December 2008 diff hist +487 VbzCart/queries/qryOrders Active alternate version current
- 21:0821:08, 3 December 2008 diff hist +841 N VbzCart/queries/qryOrders Active New page: ==Details== * '''Returns''': all orders which are currently active. For now, this just shows orders which haven't been pulled , but later it will look at the order state. As simple as it i...
- 21:0721:07, 3 December 2008 diff hist +889 N VbzCart/queries/qryOrderLines notPkgd New page: ==Details== * '''Returns''': Active order lines which have yet to be (completely) put into a package * '''Requires''': {{vbzcart/table|ord_lines}}, {{vbzcart/table|ord_pkg_lines}} * '''Use...
- 21:0621:06, 3 December 2008 diff hist +34 N Template:l/vc/table New page: [[VbzCart/tables/{{{1}}}|{{{1}}}]]
- 21:0321:03, 3 December 2008 diff hist +526 N VbzCart/queries/qryCbx Orders New page: ==Details== * '''Requires''': core_orders * '''Used by''': various forms, I think * '''Fields''': ** '''ID_Pull''' and '''WhenNeeded''' are needed for [[../qry...
- 18:3918:39, 3 December 2008 diff hist +110 m MediaWiki/archive/embedding Reverted edits by 66.63.165.62 (Talk); changed back to last version by 149.166.168.178
30 November 2008
- 19:5619:56, 30 November 2008 diff hist −3,564 m VbzCart/queries →Catalog Sources: moved to separate pages
- 19:5619:56, 30 November 2008 diff hist +343 N VbzCart/queries/qryCtg build moved from single-page listing
- 19:5519:55, 30 November 2008 diff hist +1,601 N VbzCart/queries/qryCtg build sub moved from single-page listing
- 19:5519:55, 30 November 2008 diff hist +531 N VbzCart/queries/qryCtg Titles active moved from single-page listing
- 19:5519:55, 30 November 2008 diff hist +537 N VbzCart/queries/qryCtg Items active moved from single-page listing
- 19:3019:30, 30 November 2008 diff hist +450 N VbzCart/queries/qryCtg Items updates joinable moved from single-page listing current
- 19:2919:29, 30 November 2008 diff hist +1,006 N VbzCart/queries/qryCtg Items updates moved from single-page listing current
- 19:2919:29, 30 November 2008 diff hist +298 N VbzCart/queries/qryCtg Sources active moved from single-page listing
- 19:1419:14, 30 November 2008 diff hist −4,213 m VbzCart/queries →Catalog Items: moved queries to separate pages
- 19:1319:13, 30 November 2008 diff hist +931 N VbzCart/queries/qryItems prices moved from single-page listing current
- 19:1019:10, 30 November 2008 diff hist +656 N VbzCart/queries/qryCbx Items opt moved from single-page listing current
- 19:1019:10, 30 November 2008 diff hist +763 N VbzCart/queries/qryCbx Items for sale moved from single-page listing current
- 19:1019:10, 30 November 2008 diff hist +302 N VbzCart/queries/qryCbx Items active moved from single-page listing current
- 19:0919:09, 30 November 2008 diff hist +233 N VbzCart/queries/qryCbx Items moved from single-page listing current
- 19:0919:09, 30 November 2008 diff hist +755 N VbzCart/queries/qryCbx Items data moved from single-page listing current
- 19:0119:01, 30 November 2008 diff hist +1,300 N VbzCart/queries/qryCat Items moved from single-page listing
- 18:5518:55, 30 November 2008 diff hist +70 VbzCart/queries →Inactive: discarded
- 18:5518:55, 30 November 2008 diff hist +789 N VbzCart/queries/discarded v_items
