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

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.