• last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fix calls with literals instead of variables

  1. … 3 more files in changeset.
fix calls to empty_string_p with missing $

  1. … 8 more files in changeset.
Fixed bug #1699 with Brad Duell's patch

  1. … 3 more files in changeset.
Fixed bug #1698 with Brad Duell's patch

    • -0
    • +20
    ./products/recommendations-oracle.xql
    • -0
    • +20
    ./products/recommendations-postgresql.xql
Fixed bug #1691 with one of Brad Duell's patches

Fixed bug #1689 with Brad Duell's patch

    • -0
    • +19
    ./orders/index-oracle.xql
    • -0
    • +19
    ./orders/index-postgresql.xql
  1. … 1 more file in changeset.
Fixed bug #1286

Fixed bug in money_select query as reported by Janus Dubanik

Fixed bug #1692, based on patch by Brad Buell

    • -0
    • +19
    ./orders/by-order-state-and-time-oracle.xql
    • -0
    • +19
    ./orders/by-order-state-and-time-postgresql.xql
    • -18
    • +0
    ./orders/by-order-state-and-time.xql
cleanup javadoc tags (eg @cvs_id @cvs @cvs-id: instead if @cvs-id)

  1. … 678 more files in changeset.

Fixed typo in the name querytext.

correct my email address.

  1. … 14 more files in changeset.
*** empty log message ***

    • -0
    • +34
    ./orders/items-return-2-postgresql.xql
    • -0
    • +22
    ./problems/index-postgresql.xql
    • -22
    • +0
    ./products/recommendations-oracle.xql
  1. … 128 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..

    • -2
    • +5
    ./customer-service/spam-3-postgresql.xql
    • -30
    • +13
    ./orders/by-order-state-and-time-oracle.xql
    • -22
    • +19
    ./orders/by-order-state-and-time-postgresql.xql
  1. … 261 more files in changeset.

Removed misc. test log messages. Fixed check for new address in shipping-address-2.tcl.

  1. … 4 more files in changeset.

1. Changed a lot of package info files to fix problems ...

2. Added Vinod's bboard patch

3. Rationalized party e-mail checking by putting a "before insert or update"

trigger on the table that lower-cases email (this was already done by the

party.new() func but at least one update missed this). Got rid of all

"lower(email) = " and "upper(email) = " checks and just made all use the

db email column directly and lower-cased Tcl vars. In this way the index

on the email column is always and consistently used without needing to

define functional indexes on the column (an EE feature for Oracle).

4. Rationalized naming of a couple of workflows and fixed a glossary PG bug

where apparently its workflow got overwritten by one from the CMS at some

point in time.

5. Made the .cmp/.dat/.frm filters in the template code usable though not

very beautiful nor exactly correct. But with practice you can use them

to debug pages in the packages/* hierarchy. I also turned these off by

default as there's no need to run these filters on a production site!

6. Performed minor surgery on templating, including adding a new

"ad_return_exception_template" that allows you to return a templated

error page and aborts the script.

7. ??? probably but I think this covers most stuff.

    • -2
    • +2
    ./customer-service/interaction-add-2.tcl
    • -1
    • +1
    ./customer-service/interaction-add-2.xql
    • -1
    • +1
    ./customer-service/user-identification-search.tcl
    • -1
    • +1
    ./customer-service/user-identification.tcl
    • -1
    • +1
    ./customer-service/user-identification.xql
  1. … 68 more files in changeset.

Small query fix: and became a where clause.

    • -1
    • +1
    ./customer-service/email-send-postgresql.xql

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

    • -1
    • +1
    ./products/supporting-files-upload.tcl
  1. … 36 more files in changeset.

Cleanup of double cashing. The ad_parameter procedure was often called

within util_memoize.

    • -1
    • +1
    ./customer-service/customer-search.tcl
    • -1
    • +1
    ./customer-service/gift-certificate-add.tcl
    • -1
    • +1
    ./customer-service/gift-certificates.tcl
  1. … 41 more files in changeset.

The last bit of .nextval cleaning ?!

    • -13
    • +0
    ./cat/subcategory-add-postgresql.xql
    • -13
    • +0
    ./cat/subsubcategory-add-oracle.xql
  1. … 2 more files in changeset.

More nextval cleanup. Removed ns_share.

    • -13
    • +0
    ./cat/subsubcategory-add-postgresql.xql
    • -20
    • +10
    ./customer-service/email-send-oracle.xql
    • -6
    • +8
    ./customer-service/email-send-postgresql.xql
    • -13
    • +0
    ./customer-service/picklist-item-add-oracle.xql
    • -13
    • +0
    ./customer-service/picklist-item-add-postgresql.xql
    • -13
    • +0
    ./orders/address-add-3-postgresql.xql
    • -13
    • +0
    ./orders/creditcard-add-3-oracle.xql
    • -13
    • +0
    ./orders/creditcard-add-3-postgresql.xql
  1. … 32 more files in changeset.

Ported several queries.

    • -0
    • +58
    ./customer-service/spam-2.xql
    • -0
    • +15
    ./customer-service/spam-log-oracle.xql
    • -0
    • +15
    ./customer-service/spam-log-postgresql.xql

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

    • -7
    • +0
    ./customer-service/email-send-2-oracle.xql
    • -7
    • +0
    ./customer-service/email-send-2-postgresql.xql
    • -8
    • +0
    ./customer-service/interaction-add-2-oracle.xql
    • -8
    • +0
    ./customer-service/interaction-add-2-postgresql.xql
    • -1
    • +1
    ./customer-service/interaction-add-2.tcl
    • -22
    • +2
    ./customer-service/interaction-add-3-oracle.xql
    • -21
    • +0
    ./customer-service/interaction-add-3-postgresql.xql
    • -3
    • +3
    ./customer-service/interaction-add-3.tcl
    • -8
    • +11
    ./customer-service/issue-edit-2.tcl
    • -12
    • +10
    ./customer-service/issue-edit-2.xql
  1. … 62 more files in changeset.
Fixed shippable radio buttons. They didn't correspond to the no_shipping_avail_p field.

Changed search by product ID to SKU now that product IDs are assigned automatically.

Fixed order by of query and restricted selection to states chosen in form. Now the page works as intended.

Forgot to change 'product id' to 'sku'.

Reworked product upload so that it checks the column names and uses the SKU rather than the product_id.

Reworked category upload so that it uses the SKU rather than product_id.

    • -0
    • +73
    ./products/categories-upload-2-postgresql.xql
    • -36
    • +46
    ./products/categories-upload-2.tcl
Added missing query.