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

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

  1. … 4 more files in changeset.

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

  1. … 37 more files in changeset.

Cleanup of double cashing. The ad_parameter procedure was often called

within util_memoize.

  1. … 53 more files in changeset.

More nextval cleanup. Removed ns_share.

  1. … 37 more files in changeset.

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

  1. … 62 more files in changeset.
Fixed order by of query and restricted selection to states chosen in form. Now the page works as intended.

Added missing query.

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

fixed tracking code from Bart T.

fixed state widget call and country query

  1. … 7 more files in changeset.

change state_widget call to ec_multiple_state_widget

  1. … 2 more files in changeset.

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
    ./search-postgresql.xql

fixed money_select query

used db_map for dynamic queries with date calcs

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

used db_map for dynamic sql queries with date calcs

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

added db_map for dynamic queries with dates

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

fixed date filters by adding db_map for dynamic sql

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

fixed date queries by using db_map

    • -0
    • +50
    ./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

added missing <queryset> tag

fixed .xql files. changed some db_dmls to db_exec_plsql in .tcl files for queries that call functions or package procedures.

  1. … 5 more files in changeset.

Initial commit of admin directory. All subdirectories in admin have been ported with the exception of products/add-4-postgresql.xql. Dynamic queries have not been ported yet. Files in the root directory of admin have not been ported yet.

    • -0
    • +13
    ./address-add-3-oracle.xql
    • -0
    • +13
    ./address-add-3-postgresql.xql
    • -0
    • +20
    ./by-order-state-and-time-oracle.xql
    • -0
    • +18
    ./by-order-state-and-time.xql
    • -0
    • +13
    ./creditcard-add-3-oracle.xql
    • -0
    • +13
    ./creditcard-add-3-postgresql.xql
    • -0
    • +29
    ./creditcard-add-3.xql
    • -0
    • +11
    ./creditcard-add.xql
    • -0
    • +13
    ./fulfill-2-oracle.xql
    • -0
    • +13
    ./fulfill-2-postgresql.xql
  1. … 319 more files in changeset.

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

  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +118
    ./address-add.tcl
    • -0
    • +155
    ./by-order-state-and-time.tcl
    • -0
    • +82
    ./creditcard-add-2.tcl
    • -0
    • +37
    ./creditcard-add-3.tcl
    • -0
    • +60
    ./creditcard-add.tcl
    • -0
    • +55
    ./fulfillment-items-needed.tcl
    • -0
    • +28
    ./gift-certificate-void-2.tcl
  1. … 2465 more files in changeset.