User contributions for Woozle

8 March 2009

• 20:5220:52, 8 March 2009 diff hist +1,367 N VbzCart/procs/Upd StkContainers New page: ==About== * '''Purpose''' update (replace/fill) {{vbzcart|table|_stk_containers}} * '''Status''': in progress; Packages and Restocks were not yet migrated when this was designed, but they ...
• 20:4320:43, 8 March 2009 diff hist +901 N VbzCart/tables/ stk containers New page: ==About== * '''Purpose''': Aggregate table listing all places where stock can be, mainly for the history table * '''Fields''': ** '''Name''': auto-generated but hopefully somewhat descript...
• 20:4020:40, 8 March 2009 diff hist +1,130 N VbzCart/procs/Upd SupplierIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_supp}}, {{vbzcart|table|_titles}}, {{vbzcart|table|_title_ittyps}}, {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_supplier_itty...
• 20:1920:19, 8 March 2009 diff hist +377 N VbzCart/tables/ supplier ittyps New page: ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `_supplier_ittyps`; CREATE TABLE `_supplier_ittyps` ( `ID` int(11) unsigned NOT NULL, `ItemType` varchar(63) NOT NULL, `It...
• 20:1820:18, 8 March 2009 diff hist +395 N VbzCart/procs/Upd DeptIttyps fr CatIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_dept_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_DeptIttyps_fr_CatItty...
• 20:1620:16, 8 March 2009 diff hist +527 N VbzCart/procs/Upd DeptIttyps fr TitleIttyps New page: ==About== * '''Input''': {{vbzcart|table|_title_ittyps}} (grouped by ID_ItTyp, ID_Dept) * '''Output''': {{vbzcart|table|_dept_ittyps}} (replace) ==SQL== <section begin=sql /><mysql>CREATE ...
• 20:1320:13, 8 March 2009 diff hist +572 N VbzCart/tables/ dept ittyps New page: ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...
• 20:0120:01, 8 March 2009 diff hist +419 N VbzCart/procs/Upd TitleIttyps fr CatIttyps New page: ==About== * '''Input''': {{vbzcart|table|cat_ittyps}} * '''Output''': {{vbzcart|table|_title_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_TitleIttyps_fr_CatIt...
• 19:5919:59, 8 March 2009 diff hist +354 N VbzCart/procs/Upd TitleIttyps fr Titles New page: ==About== * '''Input''': {{vbzcart|table|_titles}} * '''Output''': {{vbzcart|table|_title_ittyps}} (update) ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_TitleIttyps_fr_Titles()...
• 19:5719:57, 8 March 2009 diff hist +1,611 N VbzCart/procs/Upd TitleIttyps fr CatItems Titles New page: ==About== * '''Purpose''': fills {{vbzcart|table|_title_ittyps}}. * '''Input''': {{vbzcart|table|cat_items}}, {{vbzcart|table|cat_titles}} * '''Output''': {{vbzcart|table|_title_ittyps}} (...
• 19:4819:48, 8 March 2009 diff hist +1,453 N VbzCart/tables/ title ittyps New page: ==About== * '''Purpose''': list of available titles for each item type * '''History''': ** '''2007-09-20''' Added cntInStock field because we need to be able to figure out how many line it...
• 19:4419:44, 8 March 2009 diff hist +679 N VbzCart/procs/Upd Titles fr TitleIttyps New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} * '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title * '''Output''': {{vbzcart|table|_titles}} (u...
• 19:4119:41, 8 March 2009 diff hist +736 N VbzCart/procs/Upd Titles fr CatItems New page: ==About== * '''Purpose''': sets some fields in {{vbzcart|table|_titles}} after that has been filled in by {{vbzcart|proc|Upd_Titles_fr_Depts}} ==SQL== <section begin=sql /><mysql>CREATE PR...
• 19:3819:38, 8 March 2009 diff hist +455 N VbzCart/procs/Upd Titles fr Depts New page: ==About== * '''Purpose''': Fills {{vbzcart|table|_titles}} ==SQL== <section begin=sql /><mysql> CREATE PROCEDURE Upd_Titles_fr_Depts() REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb) ...
• 19:3619:36, 8 March 2009 diff hist +742 N VbzCart/tables/ titles New page: ==About== * '''Purpose''': cached information about titles ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_titles`; CREATE TABLE `_titles` ( `ID` int(11) unsigned NOT NULL,...
• 19:3519:35, 8 March 2009 diff hist +654 N VbzCart/procs/Upd Depts fr DeptIttyps New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_depts}} after that has been filled in by {{vbzcart|proc|Upd_Depts_fr_Depts_Suppliers}} ==SQL== <section begin=sql /><mysq...
• 19:3119:31, 8 March 2009 diff hist +746 N VbzCart/procs/Upd Depts fr Depts Suppliers New page: ==About== * '''Purpose''': fills {{vbzcart|table|_depts}} (does not set inPrint/inStock fields) ==SQL== <section begin=sql /><mysql> CREATE PROCEDURE Upd_Depts_fr_Depts_Suppliers() BE...
• 19:2919:29, 8 March 2009 diff hist +632 N VbzCart/tables/ depts New page: ==About== * '''Purpose''': Calculated information about departments ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_depts`; CREATE TABLE `_depts` ( `ID` int(11) unsigned NO... current
• 19:2519:25, 8 March 2009 diff hist +646 N VbzCart/archive/tables New page: ==updates== * '''Purpose''': timestamps on tables so we know when update queries need to be run * '''Status''': probably superceded by data flow tables and procs ===SQL=== <section begin=s...
• 19:2019:20, 8 March 2009 diff hist +437 N VbzCart/tables/var global New page: ==About== * '''Status''': not currently being used, but is probably needed for proper stats display in controlbar * '''Purpose''':computed variables, cache timestamps, and other variable s...
• 19:1819:18, 8 March 2009 diff hist +373 N VbzCart/tables/cat title x topic New page: ==About== * '''Status''': under development; may end up not being used ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_titles_x_topics`; CREATE TABLE `brs_titles_x_topics` ( ...
• 19:1719:17, 8 March 2009 diff hist +978 N VbzCart/tables/cat topic New page: ==About== * '''Status''': Under development. May end up not being used. ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; CREATE TABLE `brs_topics` ( `ID` INT...
• 19:1219:12, 8 March 2009 diff hist +732 N VbzCart/tables/shop log New page: ==About== * '''Status''': design is under construction * '''Purpose''': logs customer movement through the store, for analysis of usage patterns and looking for problems ==SQL== <section b... current
• 19:1019:10, 8 March 2009 diff hist +618 N VbzCart/tables/shop cart data type New page: ==About== * '''Purpose''': This table is probably unnecessary, but I can't convince myself of that. If nothing else, it will help prevent inconsistent usage. It might be useful for reports...
• 19:0719:07, 8 March 2009 diff hist +558 N VbzCart/tables/shop cart data New page: ==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. ==SQL== <section begin=sql /><mysql>DROP TAB...
• 19:0619:06, 8 March 2009 diff hist +1,479 N VbzCart/tables/shop cart line New page: ==About== * '''Purpose''': individual items in a shopping cart; child table of {{vbzcart|table|shop_carts}} ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_lines`; CREA...
• 18:5918:59, 8 March 2009 diff hist +1,387 N VbzCart/tables/shop cart New page: ==About== * '''Purpose''': Shopping cart data is kept separate from order data because we end up with a lot of carts that never become orders; eventually they get cleaned out. Order data m...
• 18:5818:58, 8 March 2009 diff hist +842 N VbzCart/tables/ctg upd2 New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. ==SQL== <section begin=sql /><mysql>CREATE TABLE `ct... current
• 18:5618:56, 8 March 2009 diff hist +1,058 N VbzCart/tables/ctg upd1 New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. This table contains only the essential fields from {...
• 18:5418:54, 8 March 2009 diff hist +2,201 N VbzCart/tables/ctg updates New page: ==About== * '''Purpose''': There may be a better way to do this, but haven't been able to figure it out yet. This table keeps track of the correspondence between {items as generated from t...
• 18:5118:51, 8 March 2009 diff hist +940 N VbzCart/tables/ctg items New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...
• 18:5018:50, 8 March 2009 diff hist +1,102 N VbzCart/tables/ctg titles New page: ==About== * '''Purpose''': Specifies which groups a title belongs to ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_titles` ( ID INT NOT NULL AUTO_INCREMENT, ID_Title ...
• 18:4918:49, 8 March 2009 diff hist +1,201 N VbzCart/tables/ctg groups New page: ==About== * '''Purpose''': Master list of groups (CTGs) * '''Fields''': ** '''ID_Supplier''': supplier to which this group applies; NULL = no fixed supplier, can be used for any of them **...
• 18:4418:44, 8 March 2009 diff hist +203 VbzCart/tables/ctg sources shortened SQL doc lines a bit by moving longer explanations to "about"
• 18:4218:42, 8 March 2009 diff hist +926 N VbzCart/tables/ctg sources New page: ==About== * '''Notes''': ** To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble. ==SQL== <section begin=sql />...
• 18:3918:39, 8 March 2009 diff hist +769 N VbzCart/tables/ctg prc funcs New page: ==About== * '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us: *: retail = {(wholesale * '''PriceFactor''') + '''PriceAddend''...
• 18:3718:37, 8 March 2009 diff hist +427 N VbzCart/tables/ctg supp New page: ==About== * '''Purpose''': Information about suppliers which isn't needed for customer web site ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_supp` ( ID INT NOT NULL COMMENT "ca...
• 18:3318:33, 8 March 2009 diff hist +18 m VbzCart/procs/Upd CatPages link to _cat_pages at its new address
• 18:3318:33, 8 March 2009 diff hist +1,106 N VbzCart/queries/ cat pages New page: ==About== * '''Purpose''': catalog index, for translating URLs to page-display requests; {{vbzcart|proc|Upd_CatPages}} caches the output in a table * '''Requires''': {{vbzcart|table|cat_su... current
• 18:2618:26, 8 March 2009 diff hist +115 m VbzCart/procs/Upd CatItems fr StkItems StkBins input/output doc
• 18:2418:24, 8 March 2009 diff hist +626 N VbzCart/procs/Upd CatItems fr StkItems StkBins New page: ==About== * '''Action''': updates availability from current stock ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...
• 18:1718:17, 8 March 2009 diff hist +111 VbzCart →Documents: new subpage for stored procs
• 18:1518:15, 8 March 2009 diff hist +1,013 N VbzCart/procs starting with data flow procs
• 18:0818:08, 8 March 2009 diff hist +231 N VbzCart/procs/Upd CatPages New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ...
• 18:0418:04, 8 March 2009 diff hist +44 N Template:l/vbzcart general vbzcart subpage link

7 March 2009

• 14:2514:25, 7 March 2009 diff hist +10 VbzCart →Documents: code
• 14:2514:25, 7 March 2009 diff hist +125 N VbzCart/archive/code some code pages
• 14:2314:23, 7 March 2009 diff hist −61,445 VbzCart/archive/code/files/store.php →Code - store.php: oops, wrong code (non-working dev code); this is the right one
• 13:4213:42, 7 March 2009 diff hist +63,271 N VbzCart/archive/code/files/store.php New page: ==About== * '''Purpose''': Classes for displaying different types of catalog display pages * '''History''': ** '''2009-03-07''' Transcribed from working code at vbz.net * '''To Do''': ** s...
• 13:2813:28, 7 March 2009 diff hist +2,263 N VbzCart/archive/code/files/cat New page: ==About== * '''Purpose''': Generates basic one-to-one catalog pages (one page each per title, department, and supplier) * '''History''': ** '''2009-03-07''' Copied from actual site; has bu...