VbzCart/tables/shop cart - Revision history

Woozle at 19:08, 7 August 2019

2019-08-07T19:08:54Z

← Older revision		Revision as of 19:08, 7 August 2019
Line 41:		Line 41:
	* '''2016-06-24''' removing '''WhenViewed''', since code never sets it (NULL in all existing records) and the purpose for which it was probably intended (diagnostic) is better served by the event log.		* '''2016-06-24''' removing '''WhenViewed''', since code never sets it (NULL in all existing records) and the purpose for which it was probably intended (diagnostic) is better served by the event log.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `shop_cart` (		<source lang=mysql>CREATE TABLE `shop_cart` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",		`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",
Line 53:		Line 53:
	`FieldData` TEXT DEFAULT NULL COMMENT "other values associated with the cart (serialized)",		`FieldData` TEXT DEFAULT NULL COMMENT "other values associated with the cart (serialized)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = INNODB;</~~mysql~~>		) ENGINE = INNODB;</source>

Woozle: some rules moved from Ferreteria user_session page

2017-02-10T11:17:29Z

some rules moved from Ferreteria user_session page

← Older revision		Revision as of 11:17, 10 February 2017
Line 16:		Line 16:
	** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_custs}} record (it's only zero until the order is placed, but ID_Cust isn't necessarily filled in when this happens)		** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_custs}} record (it's only zero until the order is placed, but ID_Cust isn't necessarily filled in when this happens)
	** each {{vbzcart\|table\|core_custs}} record has one or more {{vbzcart\|table\|shop_cart}}s and one or more {{vbzcart\|table\|core_orders}}		** each {{vbzcart\|table\|core_custs}} record has one or more {{vbzcart\|table\|shop_cart}}s and one or more {{vbzcart\|table\|core_orders}}
			* '''Rules''':
			** Each {{vbzcart\|table\|user_session}} has zero or one {{vbzcart\|table\|shop_cart}}s (currently stored in custom ID_Cart field, but will eventually be Stashed)
			*** A single session may discard one cart and start a new one.
			*** Sessions only use carts they create, never reusing one created by another session (but see Security, below)
			*** Each session knows only the cart it is currently using.

	===Fields===		===Fields===
	* '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out		* '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out
Line 35:		Line 41:
	* '''2016-06-24''' removing '''WhenViewed''', since code never sets it (NULL in all existing records) and the purpose for which it was probably intended (diagnostic) is better served by the event log.		* '''2016-06-24''' removing '''WhenViewed''', since code never sets it (NULL in all existing records) and the purpose for which it was probably intended (diagnostic) is better served by the event log.
	==SQL==		==SQL==
	<mysql>~~DROP TABLE IF EXISTS `shop_cart`;~~		<mysql>CREATE TABLE `shop_cart` (
	CREATE TABLE `shop_cart` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",		`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",

Woozle: decided Stash will be much easier to debug if it's TEXT instead of a BLOB

2016-12-23T12:48:54Z

decided Stash will be much easier to debug if it's TEXT instead of a BLOB

← Older revision		Revision as of 12:48, 23 December 2016
Line 46:		Line 46:
	`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",		`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",
	`ShipZone` VARCHAR(3) DEFAULT NULL COMMENT "shipping cost zone",		`ShipZone` VARCHAR(3) DEFAULT NULL COMMENT "shipping cost zone",
	`FieldData` ~~BLOB~~ DEFAULT NULL COMMENT "other values associated with the cart (serialized)",		`FieldData` TEXT DEFAULT NULL COMMENT "other values associated with the cart (serialized)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = INNODB;</mysql>		) ENGINE = INNODB;</mysql>

Woozle: removed WhenViewed

2016-06-24T13:50:50Z

removed WhenViewed

← Older revision		Revision as of 13:50, 24 June 2016
Line 33:		Line 33:
	* '''2016-03-07''' added '''FieldData''' field		* '''2016-03-07''' added '''FieldData''' field
	* '''2016-06-23''' renaming '''WhenOrdered''' to '''WhenPorted''': when Cart record was used to create an Order (''not'' when the Order was formally submitted)		* '''2016-06-23''' renaming '''WhenOrdered''' to '''WhenPorted''': when Cart record was used to create an Order (''not'' when the Order was formally submitted)
			* '''2016-06-24''' removing '''WhenViewed''', since code never sets it (NULL in all existing records) and the purpose for which it was probably intended (diagnostic) is better served by the event log.
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart`;		<mysql>DROP TABLE IF EXISTS `shop_cart`;
Line 38:		Line 39:
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",		`WhenCreated` DATETIME NOT NULL COMMENT "when the cart was first created",
	~~`WhenViewed` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last displayed by the customer",~~
	`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",
	`WhenPorted` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",		`WhenPorted` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",

Woozle: WhenOrdered -> WhenPorted

2016-06-23T23:32:37Z

WhenOrdered -> WhenPorted

← Older revision		Revision as of 23:32, 23 June 2016
Line 32:		Line 32:
	* '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart		* '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart
	* '''2016-03-07''' added '''FieldData''' field		* '''2016-03-07''' added '''FieldData''' field
			* '''2016-06-23''' renaming '''WhenOrdered''' to '''WhenPorted''': when Cart record was used to create an Order (''not'' when the Order was formally submitted)
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart`;		<mysql>DROP TABLE IF EXISTS `shop_cart`;
Line 39:		Line 40:
	`WhenViewed` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last displayed by the customer",		`WhenViewed` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last displayed by the customer",
	`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",
	`~~WhenOrdered~~` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",		`WhenPorted` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",
	`WhenVoided` DATETIME DEFAULT NULL COMMENT "when this cart was discarded",		`WhenVoided` DATETIME DEFAULT NULL COMMENT "when this cart was discarded",
	`ID_Sess` INT NOT NULL COMMENT "shop_session.ID which used this cart",		`ID_Sess` INT NOT NULL COMMENT "shop_session.ID which used this cart",

Woozle: FieldData

2016-03-08T19:03:47Z

FieldData

← Older revision		Revision as of 19:03, 8 March 2016
Line 16:		Line 16:
	** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_custs}} record (it's only zero until the order is placed, but ID_Cust isn't necessarily filled in when this happens)		** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_custs}} record (it's only zero until the order is placed, but ID_Cust isn't necessarily filled in when this happens)
	** each {{vbzcart\|table\|core_custs}} record has one or more {{vbzcart\|table\|shop_cart}}s and one or more {{vbzcart\|table\|core_orders}}		** each {{vbzcart\|table\|core_custs}} record has one or more {{vbzcart\|table\|shop_cart}}s and one or more {{vbzcart\|table\|core_orders}}
	* '''Fields~~''':~~		===Fields===
	** '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out		* '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out
	** '''ID_Sess''' is the ID of the session ({{vbzcart\|table\|shop_session}}) where the cart was created & accessed		* '''ID_Sess''' is the ID of the session ({{vbzcart\|table\|shop_session}}) where the cart was created & accessed
	*** Different sessions cannot access the same cart. (Is there a good reason for this, or does it just ''sound'' good?)		** Different sessions cannot access the same cart. (Is there a good reason for this, or does it just ''sound'' good?)
	*** One session may have multiple carts.		** One session may have multiple carts.
	** '''ShipZone''' represents the string-code for the shipping zone, which is used to determine shipping cost		* '''ShipZone''' represents the string-code for the shipping zone, which is used to determine shipping cost
	*** currently, this is hard-coded to apply a different multiplier for each zone - {US shipping cost}x{zone multiplier}		** currently, this is hard-coded to apply a different multiplier for each zone - {US shipping cost}x{zone multiplier}
	* '''~~History~~''':		* '''FieldData''' is a [http://php.net/serialize serialize]d array of the data formerly stored in {{l/vc/table\|shop_cart_data}}. This is an experimental field which will become permanent if it works out.
	** '''2009-06-16''' Changing names to singular (tables not in use yet, so this is the time to do it)		===History===
	** '''2009-07-10''' removing '''ID_Session''': each session ties to a cart, not vice-versa		* '''2009-06-16''' Changing names to singular (tables not in use yet, so this is the time to do it)
	*** ...except that we still have ID_Sess		* '''2009-07-10''' removing '''ID_Session''': each session ties to a cart, not vice-versa
	** '''2009-07-16''' added '''ShipZone''' field		** ...except that we still have ID_Sess
	** '''2009-07-18''' added '''ID_Sess''' field (field documentation seems to think it was already there...)		* '''2009-07-16''' added '''ShipZone''' field
	** '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart		* '''2009-07-18''' added '''ID_Sess''' field (field documentation seems to think it was already there...)
			* '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart
			* '''2016-03-07''' added '''FieldData''' field
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart`;		<mysql>DROP TABLE IF EXISTS `shop_cart`;
Line 43:		Line 45:
	`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",		`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",
	`ShipZone` VARCHAR(3) DEFAULT NULL COMMENT "shipping cost zone",		`ShipZone` VARCHAR(3) DEFAULT NULL COMMENT "shipping cost zone",
			`FieldData` BLOB DEFAULT NULL COMMENT "other values associated with the cart (serialized)",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = ~~MYISAM~~;</mysql>		) ENGINE = INNODB;</mysql>

Woozle: status::active

2014-07-09T01:16:33Z

status::active

← Older revision		Revision as of 01:16, 9 July 2014
Line 3:		Line 3:
	[[project::VbzCart]]		[[project::VbzCart]]
	[[subsystem::shopping]]		[[subsystem::shopping]]
			[[status::active]]
	</hide>		</hide>
	==About==		==About==

Woozle: smw; tidying

2014-07-07T22:05:22Z

smw; tidying

← Older revision		Revision as of 22:05, 7 July 2014
Line 1:		Line 1:
			<hide>
			[[thing type::table design]]
			[[project::VbzCart]]
			[[subsystem::shopping]]
			</hide>
	==About==		==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 may eventually get cleaned out too, but with different criteria; for now, we are keeping order data indefinitely.		* '''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 may eventually get cleaned out too, but with different criteria; for now, we are keeping order data indefinitely.
Line 25:		Line 30:
	** '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart		** '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP TABLE IF EXISTS `shop_cart`;		<mysql>DROP TABLE IF EXISTS `shop_cart`;
	CREATE TABLE `shop_cart` (		CREATE TABLE `shop_cart` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 39:		Line 44:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: +WhenVoided; updates to the rules

2011-03-28T01:22:42Z

+WhenVoided; updates to the rules

← Older revision		Revision as of 01:22, 28 March 2011
Line 2:		Line 2:
	* '''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 may eventually get cleaned out too, but with different criteria; for now, we are keeping order data indefinitely.		* '''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 may eventually get cleaned out too, but with different criteria; for now, we are keeping order data indefinitely.
	* '''Relations''':		* '''Relations''':
			** each {{vbzcart\|table\|shop_session}} has one or more {{vbzcart\|table\|shop_cart}}s
			*** a single session can discard one cart and create another
			*** sessions only use carts they create, never reusing one created by another session
			** each {{vbzcart\|table\|shop_cart}} exactly one {{vbzcart\|table\|shop_session}}
	** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_orders}} record (it's only zero until the order is placed)		** each {{vbzcart\|table\|shop_cart}} has zero or one {{vbzcart\|table\|core_orders}} record (it's only zero until the order is placed)
	** each {{vbzcart\|table\|core_orders}} record has exactly one {{vbzcart\|table\|shop_cart}}		** each {{vbzcart\|table\|core_orders}} record has exactly one {{vbzcart\|table\|shop_cart}}
Line 15:		Line 19:
	* '''History''':		* '''History''':
	** '''2009-06-16''' Changing names to singular (tables not in use yet, so this is the time to do it)		** '''2009-06-16''' Changing names to singular (tables not in use yet, so this is the time to do it)
	** '''2009-07-10''' removing ID_Session: each session ties to a cart, not vice-versa		** '''2009-07-10''' removing '''ID_Session''': each session ties to a cart, not vice-versa
	** '''2009-07-16''' added ShipZone field		*** ...except that we still have ID_Sess
	** '''2009-07-18''' added ID_Sess field (field documentation seems to think it was already there...)		** '''2009-07-16''' added '''ShipZone''' field
			** '''2009-07-18''' added '''ID_Sess''' field (field documentation seems to think it was already there...)
			** '''2011-03-27''' added '''WhenVoided''' field so we never zero out ID_Cart
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart`;
Line 26:		Line 32:
	`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",
	`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",		`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",
			`WhenVoided` DATETIME DEFAULT NULL COMMENT "when this cart was discarded",
	`ID_Sess` INT NOT NULL COMMENT "shop_session.ID which used this cart",		`ID_Sess` INT NOT NULL COMMENT "shop_session.ID which used this cart",
	`ID_Order` INT DEFAULT NULL COMMENT "core_orders.ID of order into which cart was transferred",		`ID_Order` INT DEFAULT NULL COMMENT "core_orders.ID of order into which cart was transferred",

Woozle: ID_Sess field

2009-07-19T00:52:44Z

ID_Sess field

← Older revision		Revision as of 00:52, 19 July 2009
Line 8:		Line 8:
	* '''Fields''':		* '''Fields''':
	** '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out		** '''ID_Cust''' is for future use when customers can log in to retrieve their personal data before checking out
	** '''~~ID_Session~~''' is the ID of the session ({{vbzcart\|table\|shop_session}}) where the cart was created & accessed		** '''ID_Sess''' is the ID of the session ({{vbzcart\|table\|shop_session}}) where the cart was created & accessed
	*** Different sessions cannot access the same cart. (Is there a good reason for this, or does it just ''sound'' good?)		*** Different sessions cannot access the same cart. (Is there a good reason for this, or does it just ''sound'' good?)
			*** One session may have multiple carts.
	** '''ShipZone''' represents the string-code for the shipping zone, which is used to determine shipping cost		** '''ShipZone''' represents the string-code for the shipping zone, which is used to determine shipping cost
	*** currently, this is hard-coded to apply a different multiplier for each zone - {US shipping cost}x{zone multiplier}		*** currently, this is hard-coded to apply a different multiplier for each zone - {US shipping cost}x{zone multiplier}
Line 16:		Line 17:
	** '''2009-07-10''' removing ID_Session: each session ties to a cart, not vice-versa		** '''2009-07-10''' removing ID_Session: each session ties to a cart, not vice-versa
	** '''2009-07-16''' added ShipZone field		** '''2009-07-16''' added ShipZone field
			** '''2009-07-18''' added ID_Sess field (field documentation seems to think it was already there...)
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart`;
Line 24:		Line 26:
	`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",		`WhenUpdated` DATETIME DEFAULT NULL COMMENT "when the cart's contents were last changed",
	`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",		`WhenOrdered` DATETIME DEFAULT NULL COMMENT "when the cart's contents were transferred to an order",
			`ID_Sess` INT NOT NULL COMMENT "shop_session.ID which used this cart",
	`ID_Order` INT DEFAULT NULL COMMENT "core_orders.ID of order into which cart was transferred",		`ID_Order` INT DEFAULT NULL COMMENT "core_orders.ID of order into which cart was transferred",
	`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",		`ID_Cust` INT DEFAULT NULL COMMENT "core_custs.ID of customer for this order",