• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Adding commit email support

    • -0
    • +166
    /openacs-4/packages/CVSROOT.dotlrn/log.pl
Datamodel loads in postgresql. Beginning work on Tcl

added missing declare

added .xql files for www/admin/orders directory

fixed search query

fixed money_select query

used db_map for dynamic queries with date calcs

used db_map for dynamic sql queries with date calcs

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
    /openacs-4/packages/bookmarks/www/bookmarks-check-oracle.xql
Port package_instantiate_object

    • -0
    • +56
    /openacs-4/packages/acs-subsite/tcl/plpgsql-utility-procs.tcl
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

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

fixed template query for OpenACS 4

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

fixed ec_order_cost plpgsql function

added query for ec_mailing_list_widget.get_category_children

fixed subquery syntax. Postgresql requires an as statement