• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Enable subcategory searching

  1. … 1 more file in changeset.

Big clean up of checkout process, product search and many other fixes scattered throughout the package.

    • -6
    • +3
    ./ecommerce-money-computations-procs.tcl
  1. … 33 more files in changeset.

Cleanup of double cashing. The ad_parameter procedure was often called

within util_memoize.

    • -6
    • +6
    ./ecommerce-customer-service-procs.tcl
    • -3
    • +3
    ./ecommerce-money-computations-procs.tcl
    • -1
    • +1
    ./ecommerce-user-contributions-summary-procs.tcl
  1. … 46 more files in changeset.

The last bit of .nextval cleaning ?!

    • -96
    • +65
    ./ecommerce-email-procs-oracle.xql
    • -96
    • +70
    ./ecommerce-email-procs-postgresql.xql
  1. … 2 more files in changeset.

More nextval cleanup. Removed ns_share.

    • -3
    • +0
    ./ecommerce-user-contributions-summary-procs.tcl
  1. … 43 more files in changeset.

Major clean up. Mostly db_map queries and customer service stuff.

    • -7
    • +0
    ./ecommerce-state-changes-procs-oracle.xql
    • -7
    • +0
    ./ecommerce-state-changes-procs-postgresql.xql
    • -38
    • +37
    ./ecommerce-widgets-procs-oracle.xql
    • -41
    • +40
    ./ecommerce-widgets-procs-postgresql.xql
  1. … 68 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.
Enabled the ecommerce products to the searched by the OpenFTS search.

    • -0
    • +40
    ./ec-product-sc-procs.tcl
  1. … 3 more files in changeset.
Fixed debug statements.

Various minor but crucial query fixes

    • -214
    • +190
    ./ecommerce-scheduled-procs-postgresql.xql

fixed spelling error

fixed state widget call and country query

  1. … 4 more files in changeset.

fixed country queries

fixed country code reference and state_widget call

  1. … 3 more files in changeset.

fixed state query

  1. … 2 more files in changeset.

query fixes to use ref-* instead of acs-geo-tables

fixed audit procs. did a db_type check so that we can run ns_pg_bind for postgresql and ns_ora for oracle. also mapped get_entries_sql because of rowid/oid.

    • -0
    • +17
    ./ec-audit-trail-procs-postgresql.xql

changed ec_column_type_widget to check for postgresql or oracle

added a proc ec_timeentrywidget_time_check to make sure that the time part of the time stamp has all of the necessary digits for HH:MM:SS. If it doesn't, postgresql complains.

fixed to_number call that I missed

    • -2
    • +2
    ./ecommerce-state-changes-procs-postgresql.xql

fixed missing queries and incorrect query names

    • -12
    • +0
    ./ecommerce-customer-service-procs-oracle.xql
    • -12
    • +0
    ./ecommerce-customer-service-procs-postgresql.xql
    • -1
    • +1
    ./ecommerce-customer-service-procs.tcl
    • -0
    • +12
    ./ecommerce-customer-service-procs.xql
    • -8
    • +8
    ./ecommerce-email-procs-postgresql.xql
    • -0
    • +6
    ./ecommerce-state-changes-procs-oracle.xql
    • -0
    • +7
    ./ecommerce-state-changes-procs-postgresql.xql

added missing full query update_order_state

    • -0
    • +7
    ./ecommerce-state-changes-procs-oracle.xql
    • -0
    • +7
    ./ecommerce-state-changes-procs-postgresql.xql

added query for ec_mailing_list_widget.get_category_children

    • -0
    • +15
    ./ecommerce-widgets-procs-oracle.xql
    • -0
    • +17
    ./ecommerce-widgets-procs-postgresql.xql

fixed fullquery name

fixed naming of fullquery. did initial pass on proc vs. QE verification.

    • -2
    • +2
    ./ecommerce-credit-procs-postgresql.xql
    • -30
    • +40
    ./ecommerce-email-procs-oracle.xql
    • -47
    • +56
    ./ecommerce-email-procs-postgresql.xql
    • -16
    • +16
    ./ecommerce-scheduled-procs-oracle.xql
    • -16
    • +16
    ./ecommerce-scheduled-procs-postgresql.xql

changed all procs/proc_docs to ad_proc.

    • -170
    • +170
    ./cybercash-emulator-procs.tcl.for.testing
    • -14
    • +13
    ./ecommerce-customer-service-procs.tcl
    • -4
    • +4
    ./ecommerce-money-computations-procs.tcl
    • -25
    • +27
    ./ecommerce-state-changes-procs.tcl

fixed queryname names. fixed outer join which wasn't picked up by the query extractor.

    • -2
    • +15
    ./ecommerce-widgets-procs-oracle.xql
    • -2
    • +16
    ./ecommerce-widgets-procs-postgresql.xql

fixed date calculations. used timespan_days() to calculate intervals. had to cast some arithmetic into float to pass to timespan_days.

    • -3
    • +3
    ./ecommerce-credit-procs-postgresql.xql
    • -7
    • +7
    ./ecommerce-scheduled-procs-postgresql.xql

fixed oracle sign calculation

    • -2
    • +2
    ./ecommerce-credit-procs-postgresql.xql
    • -2
    • +2
    ./ecommerce-scheduled-procs-postgresql.xql

fixed query name for ec_package_url_lookup_mem.ec_mountpoint