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

added db_map for dynamic queries with dates

fixed date filters by adding db_map for dynamic sql

Check Links also working for individual users

Bookmarks administration (by Admin) working...

    • -0
    • +47
    ./packages/bookmarks/www/bookmarks-check-oracle.xql
    • -0
    • +55
    ./packages/bookmarks/www/bookmarks-check-postgresql.xql
    • -1
    • +3
    ./packages/bookmarks/www/bookmarks-check.tcl
Port package_instantiate_object

    • -0
    • +2
    ./packages/acs-subsite/acs-subsite.info
Port queries

fixed uplevel name collision

fixed missing " for set carrier_info

fixed trigger for address_id insert

fixed date queries to use timespan_days for interval calculation

fixed date queries by using db_map

    • -0
    • +50
    ./packages/ecommerce/www/admin/orders/shipments-postgresql.xql

changed $addess_link to checkout-2

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 missing queries and incorrect query names

    • -12
    • +0
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
    • -12
    • +0
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql
    • -0
    • +7
    ./packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql

fixed template query for OpenACS 4

    • -1
    • +2
    ./packages/ecommerce/www/register/index.tcl

fixed date calculation for one_if_within_n_days

fixed trigger for credit card. it needs to be before updates to the ec_financial_tranactions table.

fixed order_select query

added missing full query update_order_state

    • -0
    • +7
    ./packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql

fixed ec_order_cost plpgsql function

added query for ec_mailing_list_widget.get_category_children

fixed subquery syntax. Postgresql requires an as statement

updated .info for util.logical_negation corrections. Added -postgresql.xql and -oracle.sql for a few files in admin/

changed logical_negation calls to util__logical_negation and util.logical_negation.

logical_negation changed to util__logical_negation and util.logical_negation in acs-kernel/sql/*/utilities-create.sql

changed triggers to after. if set to before, you sometimes cannot delete from the tables.

fixed fullquery name

function logical_negation was changed to util__logical_negation (acs-kernel)

added db_map for sysdate calls in a dynamic query.

    • -0
    • +19
    ./packages/ecommerce/www/admin/products/edit-3-oracle.xql

added db_map for partialquery. expanded the ec_products query to get date in standard format for ad_dateentrywidget.

    • -1
    • +12
    ./packages/ecommerce/www/admin/products/edit.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/products/edit.xql