OpenACS / openacs-4 / packages / ecommerce / www

admin

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 01 Oct
Commits this week: 0
Total Lines of Code (LoC): 34,372
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 27 Aug 2001
1:37 am

gilbertw

the tools directory was added because the customer-service code calls tools/spell.tcl.

Options
    • -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
    • -0
    • +9
    ./tools/webspell
1:03 am

gilbertw

fixed outer joins and nulls and dates

Options
    • -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
Saturday 25 Aug 2001
7:34 am

gilbertw

these queries were not picked up by the QE

Options
    • -0
    • +41
    ./products/custom-field-add-3-oracle.xql
    • -0
    • +41
    ./products/custom-field-add-3-postgresql.xql
7:33 am

gilbertw

added partial postgresql support. trigger creation and alter table ... drop column not supported yet.

Options
    • -7
    • +10
    ./products/custom-field-add-3.tcl
12:21 am

gilbertw

fixed single quote error for postgresql. Reported by Bart T.

Options
    • -1
    • +1
    ./products/add-4-oracle.xql
    • -19
    • +19
    ./products/add-4-postgresql.xql
    • -1
    • +42
    ./products/add-4.tcl
Wednesday 22 Aug 2001
6:20 am

gilbertw

moved the time check inside the if statment for expected_arrival_time

Options
    • -1
    • +1
    ./orders/fulfill-2.tcl
5:25 am

gilbertw

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.

Options
    • -0
    • +6
    ./orders/fulfill-2.tcl
Monday 23 Jul 2001
8:38 am

gilbertw

fixed search query

Options
    • -0
    • +74
    ./orders/search-oracle.xql
    • -0
    • +74
    ./orders/search-postgresql.xql
    • -49
    • +48
    ./orders/search.tcl
8:21 am

gilbertw

fixed money_select query

Options
    • -2
    • +14
    ./orders/revenue-postgresql.xql
8:02 am

gilbertw

used db_map for dynamic queries with date calcs

Options
    • -0
    • +26
    ./orders/refunds-oracle.xql
    • -0
    • +26
    ./orders/refunds-postgresql.xql
    • -3
    • +6
    ./orders/refunds.tcl
7:56 am

gilbertw

used db_map for dynamic sql queries with date calcs

Options
    • -0
    • +27
    ./orders/gift-certificates-issued-oracle.xql
    • -0
    • +27
    ./orders/gift-certificates-issued-postgresql.xql
    • -3
    • +6
    ./orders/gift-certificates-issued.tcl
7:50 am

gilbertw

added db_map for dynamic queries with dates

Options
    • -0
    • +28
    ./orders/gift-certificates-oracle.xql
    • -0
    • +27
    ./orders/gift-certificates-postgresql.xql
    • -3
    • +6
    ./orders/gift-certificates.tcl
7:40 am

gilbertw

fixed date filters by adding db_map for dynamic sql

Options
    • -0
    • +21
    ./orders/by-order-state-and-time-oracle.xql
    • -0
    • +27
    ./orders/by-order-state-and-time-postgresql.xql
    • -3
    • +6
    ./orders/by-order-state-and-time.tcl
Sunday 22 Jul 2001
9:05 am

gilbertw

fixed date queries to use timespan_days for interval calculation

Options
    • -3
    • +3
    ./customer-service/issues-postgresql.xql
9:04 am

gilbertw

fixed date queries by using db_map

Options
    • -1
    • +1
    ./orders/fulfill-3.xql
    • -6
    • +13
    ./orders/shipments-oracle.xql
    • -0
    • +50
    ./orders/shipments-postgresql.xql
    • -3
    • +6
    ./orders/shipments.tcl
    • -27
    • +0
    ./orders/shipments.xql
8:20 am

gilbertw

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

Options
    • -1
    • +1
    ./orders/fulfillment.xql
7:08 am

gilbertw

fixed order_select query

Options
    • -1
    • +1
    ./orders/by-order-state-and-time.xql
Friday 20 Jul 2001
8:11 am

gilbertw

function logical_negation was changed to util__logical_negation (acs-kernel)

Options
    • -1
    • +1
    ./products/toggle-active-p-postgresql.xql
    • -1
    • +1
    ./products/toggle-no-shipping-avail-p-postgresql.xql
8:01 am

gilbertw

added db_map for sysdate calls in a dynamic query.

Options
    • -0
    • +19
    ./products/edit-3-oracle.xql
    • -0
    • +19
    ./products/edit-3-postgresql.xql
8:00 am

gilbertw

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

Options
    • -2
    • +4
    ./products/edit-3.tcl
    • -1
    • +12
    ./products/edit.tcl
    • -1
    • +1
    ./products/edit.xql
Wednesday 18 Jul 2001
7:40 am

gilbertw

fixed ec_product__new for postgresql. also did a db_map for sysdate call.

Options
    • -0
    • +8
    ./products/add-4-oracle.xql
    • -31
    • +44
    ./products/add-4-postgresql.xql
    • -1
    • +4
    ./products/add-4.tcl
4:52 am

gilbertw

fixed sort key calculation. postgres driver encloses bind variables in ' ' which makes the sort key calculation fail. the key calculation is done in tcl now.

Options
    • -1
    • +5
    ./cat/subsubcategory-add-0.tcl
    • -1
    • +1
    ./cat/subsubcategory-add-0.xql
    • -1
    • +1
    ./cat/subsubcategory-add-2-oracle.xql
    • -1
    • +1
    ./cat/subsubcategory-add-2-postgresql.xql
    • -2
    • +7
    ./cat/subsubcategory-add-2.tcl
    • -1
    • +1
    ./cat/subsubcategory-add-2.xql
    • -1
    • +5
    ./cat/subsubcategory-add.tcl
    • -1
    • +1
    ./cat/subsubcategory-add.xql
1:59 am

gilbertw

fixed sort key calculations. the postgres driver puts ' ' around the bind variable. the old code performed calculations like "and sort_key = (:prev_sort_key + :next_sort_key)/2", which caused postgres to barf. this calculation is now done in tcl.

Options
    • -1
    • +7
    ./cat/category-add-0.tcl
    • -1
    • +1
    ./cat/category-add-0.xql
    • -1
    • +1
    ./cat/category-add-2-oracle.xql
    • -1
    • +1
    ./cat/category-add-2-postgresql.xql
    • -2
    • +7
    ./cat/category-add-2.tcl
    • -1
    • +1
    ./cat/category-add-2.xql
    • -1
    • +6
    ./cat/category-add.tcl
    • -1
    • +1
    ./cat/category-add.xql
    • -1
    • +5
    ./cat/subcategory-add-0.tcl
    • -1
    • +1
    ./cat/subcategory-add-0.xql
    • -1
    • +1
    ./cat/subcategory-add-2-oracle.xql
    • -1
    • +1
    ./cat/subcategory-add-2-postgresql.xql
    • -2
    • +7
    ./cat/subcategory-add-2.tcl
    • -1
    • +1
    ./cat/subcategory-add-2.xql
    • -1
    • +5
    ./cat/subcategory-add.tcl
    • -1
    • +1
    ./cat/subcategory-add.xql
Tuesday 17 Jul 2001
11:56 pm

gilbertw

fixed oracle sign() calls

Options
    • -5
    • +5
    ./products/offers-postgresql.xql
    • -3
    • +3
    ./products/sale-prices-postgresql.xql
Sunday 15 Jul 2001
10:30 pm

gilbertw

fixed issues.tcl. used db_map to handle dynamic queries. rewrote order_by bind variable to use a normal variable with a switch statement to verify the contents. for some reason the bind variable version kept enclosing the order_by variable in ' ' which is not correct.

Options
    • -0
    • +83
    ./customer-service/issues-oracle.xql
    • -0
    • +86
    ./customer-service/issues-postgresql.xql
    • -50
    • +38
    ./customer-service/issues.tcl
Thursday 12 Jul 2001
1:21 am

gilbertw

added missing <queryset> tag

Options
    • -0
    • +2
    ./orders/by-order-state-and-time.xql
Wednesday 11 Jul 2001
7:22 am

gilbertw

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

Options
    • -1
    • +1
    ./orders/void-2-postgresql.xql
    • -1
    • +1
    ./orders/void-2.tcl
    • -2
    • +2
    ./products/offers-postgresql.xql
  4. … 4 more files in changeset.
5:42 am

gilbertw

Initial Commit of .xql files.

Options
    • -0
    • +15
    ./mailing-lists/member-add.xql
    • -0
    • +25
    ./mailing-lists/member-remove-2.xql
Tuesday 10 Jul 2001
10:33 pm

gilbertw

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.

Options
    • -0
    • +17
    ./audit-table-oracle.xql
    • -0
    • +17
    ./audit-table-postgresql.xql
    • -0
    • +50
    ./index.xql
    • -0
    • +13
    ./restore-one-id-oracle.xql
    • -0
    • +13
    ./restore-one-id-postgresql.xql
    • -0
    • +13
    ./cat/category-add-0.xql
    • -0
    • +16
    ./cat/category-add-2-oracle.xql
    • -0
    • +16
    ./cat/category-add-2-postgresql.xql
    • -0
    • +21
    ./cat/category-add-2.xql
    • -0
    • +13
    ./cat/category-add-oracle.xql
    • -0
    • +13
    ./cat/category-add-postgresql.xql
    • -0
    • +13
    ./cat/category-add.xql
    • -0
    • +76
    ./cat/category-delete-2.xql
    • -0
    • +18
    ./cat/category-edit-oracle.xql
    • -0
    • +18
    ./cat/category-edit-postgresql.xql
  16. … 319 more files in changeset.
Friday 20 Apr 2001
10:51 pm

donb

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

Options
    • -0
    • +0
    ./audit-one-id.tcl
    • -0
    • +0
    ./audit-table.tcl
    • -0
    • +0
    ./audit-tables.tcl
    • -0
    • +0
    ./audit.tcl
    • -0
    • +0
    ./files.list
    • -0
    • +0
    ./index.tcl
    • -0
    • +0
    ./restore-one-id.tcl
    • -0
    • +0
    ./cat/category-add-0.tcl
    • -0
    • +0
    ./cat/category-add-2.tcl
    • -0
    • +0
    ./cat/category-add.tcl
    • -0
    • +0
    ./cat/category-delete-2.tcl
    • -0
    • +0
    ./cat/category-delete.tcl
    • -0
    • +0
    ./cat/category-edit.tcl
    • -0
    • +0
    ./cat/category-swap.tcl
    • -0
    • +0
    ./cat/category.tcl
  16. … 2465 more files in changeset.