• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Bug fixes.

  1. … 1 more file in changeset.
*** empty log message ***

    • -3159
    • +0
    ./oracle/ecommerce-create.sql.sans.acs.objects
    • -641
    • +0
    ./oracle/ecommerce-plsql.sql.txt
  1. … 130 more files in changeset.

Major overhaul:

- Replaced CyberCash with Payment Service Contract interface.

- Added Shipping Service Contract.

- Many(!) bug fixes.

- Added soft good (goods that don't require shipping) handling capacity.

- And more..

    • -65
    • +30
    ./postgresql/ecommerce-create.sql
    • -42
    • +24
    ./postgresql/pl-sql-utilities.sql
  1. … 269 more files in changeset.

More nextval cleanup. Removed ns_share.

  1. … 46 more files in changeset.
Fixed the OpenFTS search by renaming the impl name to ec_product (= the product type).

  1. … 1 more file in changeset.

Fixed reference from ecommerce-x.sql to ec_produxt-sc-x.sql & removed spaces from datacontainer name.

Enabled the ecommerce products to the searched by the OpenFTS search.

    • -0
    • +55
    ./postgresql/ec-product-sc-create.sql
    • -0
    • +13
    ./postgresql/ec-product-sc-drop.sql
  1. … 2 more files in changeset.
Added products to OpenFTS Search.

  1. … 1 more file in changeset.

removed acs-geo-tables and added dependancy to ref-*

    • -124
    • +0
    ./oracle/bboard-epa-regions-create.sql
    • -494
    • +0
    ./oracle/country-codes-create.sql
    • -335
    • +0
    ./oracle/currency-codes-create.sql
    • -73
    • +0
    ./postgresql/acs-geo-tables-create.sql
    • -37
    • +0
    ./postgresql/acs-geo-tables-drop.sql
    • -124
    • +0
    ./postgresql/bboard-epa-regions-create.sql
    • -6602
    • +0
    ./postgresql/counties-create.sql
    • -494
    • +0
    ./postgresql/country-codes-create.sql
  1. … 3 more files in changeset.
*** empty log message ***

fixed trig_ec_order_state_after_tr

changed number to numeric in one of the functions

temporarily add acs-geo-tables to the ecommerce package. will remove after acs-references is completed

    • -0
    • +73
    ./oracle/acs-geo-tables-create.sql
    • -0
    • +37
    ./oracle/acs-geo-tables-drop.sql
    • -0
    • +53
    ./oracle/acs_geo_parents.sql
    • -0
    • +124
    ./oracle/bboard-epa-regions-create.sql
    • -0
    • +6602
    ./oracle/counties-create.sql
    • -0
    • +494
    ./oracle/country-codes-create.sql
    • -0
    • +335
    ./oracle/currency-codes-create.sql
    • -0
    • +149
    ./oracle/states-create.sql

added acs-geo-tables to the ecommerce package as a temporary solution until acs-references is completed

    • -0
    • +73
    ./postgresql/acs-geo-tables-create.sql
    • -0
    • +37
    ./postgresql/acs-geo-tables-drop.sql
    • -0
    • +53
    ./postgresql/acs_geo_parents.sql
    • -0
    • +124
    ./postgresql/bboard-epa-regions-create.sql
    • -0
    • +6602
    ./postgresql/counties-create.sql
    • -0
    • +494
    ./postgresql/country-codes-create.sql
    • -0
    • +335
    ./postgresql/currency-codes-create.sql
    • -0
    • +149
    ./postgresql/states-create.sql

fixed trigger for address_id insert

fixed date calculation for one_if_within_n_days

fixed trigger for credit card. it needs to be before updates to the ec_financial_tranactions table.

fixed ec_order_cost plpgsql function

changed triggers to after. if set to before, you sometimes cannot delete from the tables.

    • -34
    • +34
    ./postgresql/ecommerce-create.sql

fixed ec_product__new function

    • -21
    • +16
    ./postgresql/ec-product-package-create.sql

fixed helper function timespan_days. use float instead of varchar.

added drop function for timespan_days.

added timespan_days helper function. from OpenACS 3.2.5.

Ported data models for PostgreSQL. The data model create and drop scripts load without errors. *-sws not ported because it is not loaded by ecommerce-create.sql.

    • -0
    • +86
    ./postgresql/ec-product-package-create.sql
    • -0
    • +12
    ./postgresql/ec-product-package-drop.sql
    • -0
    • +50
    ./postgresql/ec-product-sws-drop.sql
    • -0
    • +288
    ./postgresql/ec-product-sws-setup.sql
    • -0
    • +3344
    ./postgresql/ecommerce-create.sql
    • -0
    • +266
    ./postgresql/ecommerce-defaults.sql
    • -0
    • +267
    ./postgresql/ecommerce-drop.sql
    • -0
    • +4
    ./postgresql/pl-sql-utilities-drop.sql
    • -0
    • +77
    ./postgresql/pl-sql-utilities.sql

oops, I accidently committed the PostgreSQL version of this file into the Oracle sql directory. This commit is to fix my error.

    • -1486
    • +1326
    ./oracle/ecommerce-create.sql
ported to PostgreSQL, loads without error, not tested in any other way

    • -1326
    • +1486
    ./oracle/ecommerce-create.sql

Forgot to define binary files before importing, so .gifs were messed up.

    • -0
    • +0
    ./oracle/ec-product-package-create.sql
    • -0
    • +0
    ./oracle/ecommerce-create.sql.sans.acs.objects
  1. … 2468 more files in changeset.
Initial revision

    • -0
    • +120
    ./oracle/ec-product-package-create.sql
    • -0
    • +11
    ./oracle/ec-product-package-drop.sql
    • -0
    • +50
    ./oracle/ec-product-sws-drop.sql
    • -0
    • +288
    ./oracle/ec-product-sws-setup.sql
    • -0
    • +3184
    ./oracle/ecommerce-create.sql
    • -0
    • +3159
    ./oracle/ecommerce-create.sql.sans.acs.objects
    • -0
    • +266
    ./oracle/ecommerce-defaults.sql
    • -0
    • +161
    ./oracle/ecommerce-drop.sql
    • -0
    • +641
    ./oracle/ecommerce-plsql.sql.txt
    • -0
    • +2546
    ./oracle/ecommerce.sql.txt
    • -0
    • +3
    ./oracle/pl-sql-utilities-drop.sql
    • -0
    • +75
    ./oracle/pl-sql-utilities.sql
  1. … 2468 more files in changeset.