bitcommerceChangelog
Changes and updates to bitcommerce
Created by: spiderr, Last modification: 23 Sep 2009 (19:34 UTC)
Changes to the BitcommercePackage
This is an ongoing list of *any* changes to *any* DataDict array in a schema_inc in *any* package.
- create common_inc.php file to provide central place for shared functions. Have made good headway on massive reduction of duplicate functions in includes/ and admin/includes/
- create new core CommerceProduct class for central query location and remove all possible embedded queries related to products, parituclarly listing queries in sideboxes
- Migrate ))$_SESSIONcustomer_id>'customer_id'(( to $gBitUser->isRegistered()
- Replace all $_GET and $_POST to $_REQUEST - seems to be some issues with this en masse do to very poor HTML form naming conventions
- remove all traces of zencart sideboxes modules and move to bitwaver mod_/.tpl file pairs. control and rendering now uses bitweaver central layout mechanism
- fixed lots and lots of notices and then gave up as they are endless. Still plan on making it to run bitcommerce with all error_reporting on.
- big move and merge of pages tpl files to matching modules/pages/ directory
- nuke all individual requires of currencies.php, now in common_inc.php
- added bulk currency import
- BIG file re-arrangement and move includes/modules/pages directory to the top level pages/ directory. The ~70 directories in pages are what need to be converted to smarty templates to make bitweaver cool.
- make sure failed payflowpro transactions are logged
- add telephone to address_book entries and in order history
- pull out the top of the hard coding of modules, and make any directory in includes/modules/ show up in the admin menu, also allow the .php file to reside *inside* a directory of the same name (allows for proprietary modules to be easily kept in spearate source server)
Schema changes
This is an ongoing list of *any* changes to *any* DataDict array in a schema_inc in *any* package.
Date | Table | Reason | who |
15-SEP-2009 | bitcommerce | major refactor of order and shopping cart, move to database only carts (no more session junk) | /spider |
Sql92 UPDATE: |
| ||
01-AUG-2007 | bitcommerce | trim products_options_html_attributes field name | /lsces |
Sql92 UPDATE: |
| ||
04-APR-2007 | bitcommerce | add commission payment table | /spider |
Sql92 UPDATE: |
| ||
04-FEB-2007 | bitcommerce | Add html attributes field for options controller to provide a handy place to place javascript | /spider |
Sql92 UPDATE: |
| ||
06-JAN-2007 | bitcommerce | Massive normailization and simplication of the products options/values/attributes mess into simple "Product Options" with a table for the options (still called product_attributes for now) and a mapping table, com_products_options_map | /spider |
Sql92 UPDATE: |
| ||
03-SEP-2006 | bitcommerce | add user_id to com_orders_status_history | /spider |
Sql92 UPDATE: |
| ||
06-APR-2006 | bitcommerce | Prefix renaming | /spider |
There was much table prefix madness, so I hardcoded "com_" to schema_inc and database_tables.php, BITCOMMERCE_DB_PREFIX now defaults to BIT_DB_PREFIX if not defined, and is intended to be for placing commerce in a separate schema. install should be working again as expected. The only people affected are those who overrode the default BITCOMMERCE_DB_PREFIX with a custom value, such as for a separate schema. If your old custom BITCOMMERCE_DB_PREFIX was "finance`.`com", the new value is just "finance`.`" | |||
20-FEB-2006 | bitcommerce | removed SQL reserved words | /lsces |
Sql92 UPDATE: |
| ||
10-FEB-2006 | bitcommerce | add products_commission | /spider |
Sql92 UPDATE: |
| ||
23-NOV-2005 | bitcommerce | add products_manufacturers_model from gilesw | gilesw |
Sql92 UPDATE: |
| ||
02-NOV-2005 | bitcommerce | add suppliers info from gilesw | spiderr |
Sql92 UPDATE: |
| ||
02-NOV-2005 | bitcommerce | add shipping code for automated processes that might need it, add Cost Of Goods Sold column for orders | spiderr |
Sql92 UPDATE: |
| ||
08-OCT-2005 | bitcommerce | add telephone for address entires and order history | spiderr |
Sql92 UPDATE: |
| ||
08-OCT-2005 | bitcommerce | add customer id to payflowpro logging | spiderr |
Sql92 UPDATE: |
|
Comments
missing columns
reorders_interval
reorders_pending