VbzCart/docs/pieces/catalog/building: Revision history

25 February 2024

• curprev 01:5301:53, 25 February 2024‎ Woozle talk contribs‎ m 1,291 bytes 0‎ Woozle moved page VbzCart/VbzCart/pieces/catalog/building to VbzCart/docs/pieces/catalog/building without leaving a redirect: correct naming (was no way to import directly to this name)

12 June 2017

• curprev 11:0711:07, 12 June 2017‎ imported>Woozle‎ m 1,291 bytes +2‎ updated template name

30 May 2017

• curprev 10:4210:42, 30 May 2017‎ imported>Woozle‎ 1,289 bytes +119‎ 2017

10 February 2016

• curprev 14:3114:31, 10 February 2016‎ imported>Woozle‎ 1,170 bytes +85‎ 2016

1 February 2016

• curprev 21:2621:26, 1 February 2016‎ imported>Woozle‎ 1,085 bytes +749‎ rescued obsolete explanation from Tables page before deleting it
• curprev 20:5220:52, 1 February 2016‎ imported>Woozle‎ 336 bytes −32‎ →‎Version: rescued 2006 version from vbzwiki (had been deleted)
• curprev 02:1502:15, 1 February 2016‎ imported>Woozle‎ m 368 bytes 0‎ Woozle moved page VbzCart/pieces/catalog/local/building to VbzCart/pieces/catalog/building over redirect: this actually applies to both local and supplier

8 January 2016

• curprev 17:5317:53, 8 January 2016‎ imported>Woozle‎ m 368 bytes 0‎ Woozle moved page VbzCart/pieces/catalog/building to VbzCart/pieces/catalog/local/building: disambiguation

25 January 2015

• curprev 19:1519:15, 25 January 2015‎ imported>Woozle‎ 368 bytes 0‎ updated code link to use GitHub
• curprev 19:1419:14, 25 January 2015‎ imported>Woozle‎ m 368 bytes 0‎ Woozle moved page VbzCart/catalog/building to VbzCart/pieces/catalog/building

10 November 2010

• curprev 16:3616:36, 10 November 2010‎ imported>Woozle‎ 368 bytes +63‎ 2010 version

10 December 2009

• curprev 21:4821:48, 10 December 2009‎ imported>Woozle‎ 305 bytes −5,624‎ moved 2008 to a subpage, and added link to new 2009 page

13 September 2009

• curprev 20:1420:14, 13 September 2009‎ imported>Woozle‎ 5,929 bytes −74‎ navigation section is now redundant
• curprev 20:1420:14, 13 September 2009‎ imported>Woozle‎ m 6,003 bytes 0‎ moved VbzCart catalog building to VbzCart/catalog/building: making use of subpages

3 May 2009

• curprev 22:3122:31, 3 May 2009‎ imported>Woozle‎ 6,003 bytes −5,721‎ →‎SQL - queries - 2008: done extracting, possibly
• curprev 21:5821:58, 3 May 2009‎ imported>Woozle‎ 11,724 bytes −3,266‎ →‎SQL - queries - 2008: extracted 4 queries to separate pages; saving work

6 December 2008

• curprev 03:2303:23, 6 December 2008‎ imported>Woozle‎ 14,990 bytes +503‎ →‎ctg_upd* data building: inactive catalog number update in stage 3

4 April 2008

• curprev 20:0520:05, 4 April 2008‎ imported>Woozle‎ 14,487 bytes −2‎ →‎qryCtg_Upd_join: QtyMin_Stock -> QtyMin_Stk to match cat_items (and updated ctg_upd2)

2 April 2008

• curprev 15:4915:49, 2 April 2008‎ imported>Woozle‎ 14,489 bytes +169‎ →‎qryCtg_src: NULLIF before IFNULL

27 March 2008

• curprev 11:4111:41, 27 March 2008‎ imported>Woozle‎ 14,320 bytes +2,813‎ →‎ctg_upd* data building: working now?

26 March 2008

• curprev 15:1115:11, 26 March 2008‎ imported>Woozle‎ 11,507 bytes +21‎ →‎qryCtg_Items_forUpdJoin: +!isDumped -- otherwise we get unnecessary duplicate keys
• curprev 12:5112:51, 26 March 2008‎ imported>Woozle‎ 11,486 bytes +75‎ →‎qryCtg_Items_forUpdJoin: no, we don't need to save CatNum; it should always get set
• curprev 12:4312:43, 26 March 2008‎ imported>Woozle‎ 11,411 bytes +8‎ →‎qryCtg_Upd_join: no, qtyInStock has now been recalculated; preserve it
• curprev 12:3212:32, 26 March 2008‎ imported>Woozle‎ 11,403 bytes +137‎ →‎qryCtg_Upd_join: we shouldn't be trying to preserve so much data from cat_items

23 March 2008

• curprev 23:0623:06, 23 March 2008‎ imported>Woozle‎ 11,266 bytes +409‎ →‎qryCtg_Items_forUpdJoin: +isForSale; outdented other queries (probably indented accidentally)
• curprev 22:0722:07, 23 March 2008‎ imported>Woozle‎ 10,857 bytes +39‎ →‎ctg_upd* data building: SQL to drop procedure before creating
• curprev 20:2520:25, 23 March 2008‎ imported>Woozle‎ 10,818 bytes +93‎ →‎ctg_upd* data building: delimiter unnecessary; declaration syntax not quite right (don't need "AS")
• curprev 20:1920:19, 23 March 2008‎ imported>Woozle‎ 10,725 bytes +35‎ →‎qryCtg_src_sub: more filtering: qryCtg_Items_active has only *active* CTG items
• curprev 00:3900:39, 23 March 2008‎ imported>Woozle‎ 10,690 bytes +168‎ →‎ctg_upd* data building: part 3: housekeeping - update timestamp

22 March 2008

• curprev 21:5721:57, 22 March 2008‎ imported>Woozle‎ 10,522 bytes +483‎ →‎qryCtg_Items_forUpdJoin: CatNum never overwritten with NULL
• curprev 21:5121:51, 22 March 2008‎ imported>Woozle‎ 10,039 bytes +7‎ →‎ctg_upd* data building: +CatNum in ctg_upd2

21 March 2008

• curprev 02:4802:48, 21 March 2008‎ imported>Woozle‎ 10,032 bytes +63‎ →‎SQL - queries - 2008: qryCtg_Items_forUpdJoin revised to match ctg_upd2; SQL revised to insert new fields

20 March 2008

• curprev 19:3519:35, 20 March 2008‎ imported>Woozle‎ 9,969 bytes +78‎ →‎qryCtg_Upd_join: more careful matching of fields; need some new fields in ctg_upd2
• curprev 13:2513:25, 20 March 2008‎ imported>Woozle‎ 9,891 bytes −388‎ →‎ctg_upd* data building: simplified due to explicit columns in qryCtg_Upd_join (but not working yet)
• curprev 13:1913:19, 20 March 2008‎ imported>Woozle‎ 10,279 bytes +309‎ →‎qryCtg_Upd_join: now selects fields to match cat_items
• curprev 13:1313:13, 20 March 2008‎ imported>Woozle‎ m 9,970 bytes −691‎ →‎ctg_upd* data building: moved disused code to talkpage
• curprev 12:5912:59, 20 March 2008‎ imported>Woozle‎ 10,661 bytes −5‎ →‎qryCtg_Upd_join: reversed polarity of join so new items will be included
• curprev 01:0501:05, 20 March 2008‎ imported>Woozle‎ 10,666 bytes +1,299‎ →‎ctg_upd* data building: more revisions, but not working yet

19 March 2008

• curprev 12:2412:24, 19 March 2008‎ imported>Woozle‎ 9,367 bytes +1,740‎ →‎SQL - queries - 2008: qryCtg_Upd_join, ctg_upd* data building

18 March 2008

• curprev 00:2600:26, 18 March 2008‎ imported>Woozle‎ 7,627 bytes +25‎ →‎qryCtg_src_sub: "WHERE (c.ID IS NOT NULL)" filters out inactive Sources

17 March 2008

• curprev 17:1217:12, 17 March 2008‎ imported>Woozle‎ 7,602 bytes +125‎ →‎qryCtg_src_sub: +ID_CTG_Group, +ID_CTG_Source

15 March 2008

• curprev 19:1919:19, 15 March 2008‎ imported>Woozle‎ 7,477 bytes +405‎ →‎SQL - queries - 2008: more queries
• curprev 17:4517:45, 15 March 2008‎ imported>Woozle‎ 7,072 bytes +345‎ →‎SQL - queries - 2008: +qryCtg_src
• curprev 17:2917:29, 15 March 2008‎ imported>Woozle‎ 6,727 bytes +1,159‎ →‎SQL - queries: SQL - queries - 2008: qryCtg_src_sub
• curprev 14:1114:11, 15 March 2008‎ imported>Woozle‎ 5,568 bytes −5,012‎ removed src_* table defs; forgot that I had done them here, and went and created the ctg_* bunch instead -- the cost of frequent interruption
• curprev 09:1009:10, 15 March 2008‎ imported>Woozle‎ 10,580 bytes −2,134‎ →‎SQL - queries: updated query definitions
• curprev 08:5708:57, 15 March 2008‎ imported>Woozle‎ 12,714 bytes −577‎ →‎SQL - queries: qryCatNum_Depts and qryCatNum_Titles now defined in Views

8 December 2007

• curprev 18:0818:08, 8 December 2007‎ imported>Woozle‎ 13,291 bytes +3,167‎ →‎SQL - tables: the rest of the tables - first draft
• curprev 17:2817:28, 8 December 2007‎ imported>Woozle‎ 10,124 bytes +1,905‎ →‎SQL: adding table definitions; saving work (this is Windows after all...)

1 October 2007

• curprev 17:4017:40, 1 October 2007‎ imported>Woozle‎ 8,219 bytes −4‎ →‎Process: more descriptive correction