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

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

fixed date queries to use timespan_days for interval calculation

    • -3
    • +3
    ./customer-service/issues-postgresql.xql

fixed date queries by using db_map

    • -0
    • +50
    ./orders/shipments-postgresql.xql

postgresql returns the full timestamp including the time which screws up some procs which assume that the date returned is formatted as YYYY-MM-DD. a simple to_char statement fixes the problem

fixed order_select query

function logical_negation was changed to util__logical_negation (acs-kernel)

    • -1
    • +1
    ./products/toggle-active-p-postgresql.xql
    • -1
    • +1
    ./products/toggle-no-shipping-avail-p-postgresql.xql

added db_map for sysdate calls in a dynamic query.

    • -0
    • +19
    ./products/edit-3-oracle.xql
    • -0
    • +19
    ./products/edit-3-postgresql.xql