• last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.

Added an ec_timeentrywidget_time_check on the time to pad single digit times with a 0 for PG.

switched form method from get to post as per Bart T. patch

fixed tracking code from Bart T.

fixed state widget call and country query

  1. … 5 more files in changeset.

change state_widget call to ec_multiple_state_widget

fixed state query

  1. … 1 more file in changeset.

ported outer joins and fixed date calculations

    • -0
    • +105
    ./customer-service/actions-oracle.xql
    • -0
    • +106
    ./customer-service/actions-postgresql.xql
    • -1
    • +29
    ./customer-service/interactions-oracle.xql
    • -0
    • +27
    ./customer-service/interactions-postgresql.xql

ported outer joins

    • -0
    • +29
    ./customer-service/interactions-oracle.xql
    • -0
    • +39
    ./customer-service/interactions-postgresql.xql
    • -15
    • +17
    ./customer-service/interactions.tcl
    • -5
    • +12
    ./customer-service/interactions.xql

ported decode and outer joins

    • -0
    • +99
    ./customer-service/statistics-oracle.xql
    • -0
    • +102
    ./customer-service/statistics-postgresql.xql
    • -27
    • +37
    ./customer-service/statistics.tcl

fixed sort_key calculation

    • -1
    • +1
    ./customer-service/picklist-item-add-2-postgresql.xql
    • -7
    • +9
    ./customer-service/picklist-item-add-2.tcl
    • -1
    • +1
    ./customer-service/picklist-item-add-2.xql
    • -4
    • +5
    ./customer-service/picklist-item-add.tcl
    • -1
    • +1
    ./customer-service/picklist-item-add.xql

fixed sysdate and unique calls for postgresql

    • -0
    • +22
    ./customer-service/customer-search-oracle.xql
    • -0
    • +20
    ./customer-service/customer-search-postgresql.xql
    • -8
    • +9
    ./customer-service/customer-search.tcl

removed floating ]

    • -1
    • +0
    ./customer-service/user-identification-search.tcl

fixed reference to /admin/tools/spell after adding the spell checker to the cvs repository

the tools directory was added because the customer-service code calls tools/spell.tcl.

    • -0
    • +65
    ./tools/form-custom.tcl
    • -0
    • +73
    ./tools/sort-custom.tcl
    • -0
    • +287
    ./tools/spell.tcl
    • -0
    • +28
    ./tools/spelling-dictionary-add-to.tcl
    • -0
    • +65
    ./tools/table-custom.tcl

fixed outer joins and nulls and dates

    • -0
    • +36
    ./customer-service/interaction-add-3-oracle.xql
    • -0
    • +38
    ./customer-service/interaction-add-3-postgresql.xql
    • -6
    • +14
    ./customer-service/interaction-add-3.tcl
    • -11
    • +0
    ./customer-service/interaction-add-3.xql
    • -0
    • +11
    ./customer-service/issue-oracle.xql
    • -1
    • +11
    ./customer-service/issue-postgresql.xql

these queries were not picked up by the QE

    • -0
    • +41
    ./products/custom-field-add-3-oracle.xql
    • -0
    • +41
    ./products/custom-field-add-3-postgresql.xql

added partial postgresql support. trigger creation and alter table ... drop column not supported yet.

fixed single quote error for postgresql. Reported by Bart T.

moved the time check inside the if statment for expected_arrival_time

fixed bug when all_items_p is selected, the item_id_list was not set to item_id so only the last item_id would get passed to fulfill-3.tcl. Also added a time check to make sure all parts of the time had two digits. PostgreSQL chokes if it's not formatted exactly (ie. HH:MI:SS). Created a new function called: ec_timeentrywidget_time_check to do the check.

fixed search query

    • -0
    • +74
    ./orders/search-oracle.xql
    • -0
    • +74
    ./orders/search-postgresql.xql

fixed money_select query

used db_map for dynamic queries with date calcs

    • -0
    • +26
    ./orders/refunds-oracle.xql
    • -0
    • +26
    ./orders/refunds-postgresql.xql

used db_map for dynamic sql queries with date calcs

    • -0
    • +27
    ./orders/gift-certificates-issued-oracle.xql
    • -0
    • +27
    ./orders/gift-certificates-issued-postgresql.xql

added db_map for dynamic queries with dates

    • -0
    • +28
    ./orders/gift-certificates-oracle.xql
    • -0
    • +27
    ./orders/gift-certificates-postgresql.xql

fixed date filters by adding db_map for dynamic sql

    • -0
    • +21
    ./orders/by-order-state-and-time-oracle.xql
    • -0
    • +27
    ./orders/by-order-state-and-time-postgresql.xql