VbzCart/tables/ctg prc funcs - Revision history

Woozle: /* History */

2016-02-01T23:07:11Z

History

← Older revision		Revision as of 23:07, 1 February 2016
Line 4:		Line 4:
	==History==		==History==
	* '''2009-07-02''' finally implemented on L48 server		* '''2009-07-02''' finally implemented on L48 server
	* '''2016-02-01''' {{l/vc/table\|cat_supp}} now has ID_PriceFunc field, so reclassifying this as a ''local'' catalog table. ~~Need~~ to be renamed '''cat_prc_funcs'''.		* '''2016-02-01''' {{l/vc/table\|cat_supp}} now has ID_PriceFunc field, so reclassifying this as a ''local'' catalog table. Needs to be renamed '''cat_prc_funcs'''.

	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_prc_funcs` (		<mysql>CREATE TABLE `ctg_prc_funcs` (

Woozle: reclassified

2016-02-01T22:53:47Z

reclassified

← Older revision		Revision as of 22:53, 1 February 2016
Line 2:		Line 2:
	* '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us:		* '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us:
	: retail = {(wholesale '''PriceFactor''') + '''PriceAddend'''} rounded up to next '''PriceRound'''		: retail = {(wholesale '''PriceFactor''') + '''PriceAddend'''} rounded up to next '''PriceRound'''
	* '''History~~''':~~		==History==
	** '''2009-07-02''' finally implemented on L48 server		* '''2009-07-02''' finally implemented on L48 server
			* '''2016-02-01''' {{l/vc/table\|cat_supp}} now has ID_PriceFunc field, so reclassifying this as a ''local'' catalog table. Need to be renamed '''cat_prc_funcs'''.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ctg_prc_funcs` (		<mysql>CREATE TABLE `ctg_prc_funcs` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	Name VARCHAR(63) NOT NULL COMMENT "descriptive name for this price function",		Name VARCHAR(63) NOT NULL COMMENT "descriptive name for this price function",
Line 15:		Line 16:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: 7/2 implementation

2009-07-02T23:45:42Z

7/2 implementation

← Older revision		Revision as of 23:45, 2 July 2009
Line 2:		Line 2:
	* '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us:		* '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us:
	: retail = {(wholesale '''PriceFactor''') + '''PriceAddend'''} rounded up to next '''PriceRound'''		: retail = {(wholesale '''PriceFactor''') + '''PriceAddend'''} rounded up to next '''PriceRound'''
			* '''History''':
			** '''2009-07-02''' finally implemented on L48 server
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ctg_prc_funcs` (		<section begin=sql /><mysql>CREATE TABLE `ctg_prc_funcs` (

Woozle: New page: ==About== * '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us: : retail = {(wholesale '''PriceFactor''') + '''PriceAddend''...

2009-03-08T18:39:58Z

New page: ==About== * '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us: *: retail = {(wholesale * '''PriceFactor''') + '''PriceAddend''...

New page

==About==
* '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us:
*: retail = {(wholesale * '''PriceFactor''') + '''PriceAddend'''} rounded up to next '''PriceRound'''
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_prc_funcs` (
ID INT NOT NULL AUTO_INCREMENT,
Name VARCHAR(63) NOT NULL COMMENT "descriptive name for this price function",
PriceFactor DECIMAL(9,2) COMMENT "amount by which to multiple wholesale cost",
PriceAddend DECIMAL(9,2) COMMENT "amount by which to pad wholesale cost",
PriceRound DECIMAL(9,2) COMMENT "round-up-to-next this amount",
Notes VARCHAR(255) COMMENT "usage notes etc.",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/ctg prc funcs - Revision history

Woozle: /* History */

Woozle: reclassified

Woozle: 7/2 implementation

Woozle: New page: ==About== * '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us: *: retail = {(wholesale * '''PriceFactor''') + '''PriceAddend''...

Woozle: New page: ==About== * '''Purpose''': Repository of function parameters for calculating our retail price from the wholesale cost-to-us: : retail = {(wholesale '''PriceFactor''') + '''PriceAddend''...