OpenACS

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 5
Total Committers: 146
Last Commit: 17 Dec
Commits this week: 5
Total Lines of Code (LoC): 7,561,010
Net change in LoC this week: 8

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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 22 Jul 2001
8:13 am

gilbertw

fixed missing queries and incorrect query names

Options
    • -12
    • +0
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
    • -12
    • +0
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs.tcl
    • -0
    • +12
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs.xql
    • -8
    • +8
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql
    • -8
    • +8
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql
    • -0
    • +6
    /openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql
    • -0
    • +7
    /openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql
7:27 am

gilbertw

fixed template query for OpenACS 4

Options
    • -1
    • +2
    /openacs-4/packages/ecommerce/www/register/index.tcl
7:20 am

gilbertw

fixed date calculation for one_if_within_n_days

Options
    • -1
    • +1
    /openacs-4/packages/ecommerce/sql/postgresql/pl-sql-utilities.sql
7:09 am

gilbertw

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

Options
    • -1
    • +1
    /openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
7:08 am

gilbertw

fixed order_select query

Options
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql
6:51 am

gilbertw

added missing full query update_order_state

Options
    • -0
    • +7
    /openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-oracle.xql
    • -0
    • +7
    /openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql
6:42 am

gilbertw

fixed ec_order_cost plpgsql function

Options
    • -0
    • +2
    /openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
Friday 20 Jul 2001
11:53 pm

gilbertw

added query for ec_mailing_list_widget.get_category_children

Options
    • -0
    • +15
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
    • -0
    • +17
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
8:26 pm

gilbertw

fixed subquery syntax. Postgresql requires an as statement

Options
    • -3
    • +3
    /openacs-4/packages/ecommerce/www/product-postgresql.xql
7:06 pm

gilbertw

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

Options
    • -4
    • +8
    /openacs-4/packages/simple-survey/simple-survey.info
7:02 pm

gilbertw

changed logical_negation calls to util__logical_negation and util.logical_negation.

Options
    • -0
    • +14
    /openacs-4/packages/simple-survey/www/admin/question-active-toggle-oracle.xql
    • -0
    • +14
    /openacs-4/packages/simple-survey/www/admin/question-active-toggle-postgresql.xql
    • -0
    • +14
    /openacs-4/packages/simple-survey/www/admin/question-required-toggle-oracle.xql
    • -0
    • +15
    /openacs-4/packages/simple-survey/www/admin/question-required-toggle-postgresql.xql
    • -0
    • +13
    /openacs-4/packages/simple-survey/www/admin/response-editable-toggle-oracle.xql
    • -0
    • +13
    /openacs-4/packages/simple-survey/www/admin/response-editable-toggle-postgresql.xql
    • -0
    • +14
    /openacs-4/packages/simple-survey/www/admin/response-limit-toggle-oracle.xql
    • -0
    • +14
    /openacs-4/packages/simple-survey/www/admin/response-limit-toggle-postgresql.xql
7:01 pm

gilbertw

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

Options
    • -1
    • +1
    /openacs-4/packages/simple-survey/www/admin/question-active-toggle.tcl
    • -13
    • +0
    /openacs-4/packages/simple-survey/www/admin/question-active-toggle.xql
    • -1
    • +1
    /openacs-4/packages/simple-survey/www/admin/question-required-toggle.tcl
    • -13
    • +0
    /openacs-4/packages/simple-survey/www/admin/question-required-toggle.xql
    • -2
    • +2
    /openacs-4/packages/simple-survey/www/admin/response-editable-toggle.tcl
    • -12
    • +0
    /openacs-4/packages/simple-survey/www/admin/response-editable-toggle.xql
    • -1
    • +1
    /openacs-4/packages/simple-survey/www/admin/response-limit-toggle.tcl
    • -13
    • +0
    /openacs-4/packages/simple-survey/www/admin/response-limit-toggle.xql
9:00 am

gilbertw

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

Options
    • -34
    • +34
    /openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
8:27 am

gilbertw

fixed fullquery name

Options
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-oracle.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs-postgresql.xql
8:11 am

gilbertw

function logical_negation was changed to util__logical_negation (acs-kernel)

Options
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/products/toggle-active-p-postgresql.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/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
    /openacs-4/packages/ecommerce/www/admin/products/edit-3-oracle.xql
    • -0
    • +19
    /openacs-4/packages/ecommerce/www/admin/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
    /openacs-4/packages/ecommerce/www/admin/products/edit-3.tcl
    • -1
    • +12
    /openacs-4/packages/ecommerce/www/admin/products/edit.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/products/edit.xql
12:41 am

gilbertw

updated with correct names for sql creation/deletion scripts

Options
    • -4
    • +6
    /openacs-4/packages/simple-survey/simple-survey.info
12:40 am

gilbertw

renamed files to package-name-create/drop format so that the APM will recognize it during installation.

Options
    • -0
    • +584
    /openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql
    • -0
    • +73
    /openacs-4/packages/simple-survey/sql/postgresql/simple-survey-drop.sql
    • -584
    • +0
    /openacs-4/packages/simple-survey/sql/postgresql/survsimp-create.sql
    • -73
    • +0
    /openacs-4/packages/simple-survey/sql/postgresql/survsimp-drop.sql
12:36 am

gilbertw

renamed the files to package-name-create/drop.sql so the APM will recognize it

Options
    • -0
    • +548
    /openacs-4/packages/simple-survey/sql/oracle/simple-survey-create.sql
    • -0
    • +69
    /openacs-4/packages/simple-survey/sql/oracle/simple-survey-drop.sql
    • -548
    • +0
    /openacs-4/packages/simple-survey/sql/oracle/survsimp-create.sql
    • -69
    • +0
    /openacs-4/packages/simple-survey/sql/oracle/survsimp-drop.sql
Thursday 19 Jul 2001
6:01 pm

kenk

Fixed error in actually selecting bookmarks to view. Hadn't tried that yet...you can use them now.

Options
    • -0
    • +2
    /openacs-4/packages/bookmarks/bookmarks.info
    • -5
    • +5
    /openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql
    • -0
    • +16
    /openacs-4/packages/bookmarks/www/bookmark-access-oracle.xql
    • -0
    • +26
    /openacs-4/packages/bookmarks/www/bookmark-access-postgresql.xql
5:15 pm

kenk

Fixed error in sort order on index page. Added editing and viewing. Basic

functionality is working.

Options
    • -0
    • +8
    /openacs-4/packages/bookmarks/bookmarks.info
    • -44
    • +16
    /openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql
    • -0
    • +47
    /openacs-4/packages/bookmarks/www/bookmark-add-one-2-oracle.xql
    • -0
    • +49
    /openacs-4/packages/bookmarks/www/bookmark-add-one-2-postgresql.xql
    • -0
    • +34
    /openacs-4/packages/bookmarks/www/bookmark-add-one-2.xql
    • -0
    • +35
    /openacs-4/packages/bookmarks/www/bookmark-edit-2-oracle.xql
    • -0
    • +45
    /openacs-4/packages/bookmarks/www/bookmark-edit-2-postgresql.xql
    • -0
    • +20
    /openacs-4/packages/bookmarks/www/bookmark-edit-2.xql
    • -0
    • +8
    /openacs-4/packages/bookmarks/www/bookmark-edit-oracle.xql
    • -0
    • +15
    /openacs-4/packages/bookmarks/www/bookmark-edit-postgresql.xql
    • -1
    • +1
    /openacs-4/packages/bookmarks/www/bookmark-edit.tcl
    • -0
    • +40
    /openacs-4/packages/bookmarks/www/bookmark-edit.xql
    • -0
    • +32
    /openacs-4/packages/bookmarks/www/bookmark-view-oracle.xql
    • -2
    • +1
    /openacs-4/packages/bookmarks/www/bookmark-view.tcl
    • -0
    • +22
    /openacs-4/packages/bookmarks/www/bookmark-view.xql
    • -2
    • +3
    /openacs-4/packages/bookmarks/www/index-postgresql.xql
1:46 am

gilbertw

fixed naming of fullquery. did initial pass on proc vs. QE verification.

Options
    • -2
    • +2
    /openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ec-style-procs.xql
    • -2
    • +2
    /openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-oracle.xql
    • -2
    • +2
    /openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql
    • -30
    • +40
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql
    • -47
    • +56
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql
    • -23
    • +23
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.tcl
    • -24
    • +16
    /openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql
    • -8
    • +8
    /openacs-4/packages/ecommerce/tcl/ecommerce-procs.xql
    • -16
    • +16
    /openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql
    • -16
    • +16
    /openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql
    • -3
    • +3
    /openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl
    • -13
    • +13
    /openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ecommerce-ssl-procs.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl
Wednesday 18 Jul 2001
8:19 pm

gilbertw

changed all procs/proc_docs to ad_proc.

Options
    • -170
    • +170
    /openacs-4/packages/ecommerce/tcl/cybercash-emulator-procs.tcl.for.testing
    • -6
    • +7
    /openacs-4/packages/ecommerce/tcl/ec-audit-trail-procs.tcl
    • -19
    • +20
    /openacs-4/packages/ecommerce/tcl/ec-style-procs.tcl
    • -80
    • +82
    /openacs-4/packages/ecommerce/tcl/ecommerce-credit-procs.tcl
    • -14
    • +13
    /openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs.tcl
    • -4
    • +4
    /openacs-4/packages/ecommerce/tcl/ecommerce-money-computations-procs.tcl
    • -49
    • +56
    /openacs-4/packages/ecommerce/tcl/ecommerce-procs.tcl
    • -16
    • +15
    /openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl
    • -25
    • +27
    /openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs.tcl
    • -4
    • +3
    /openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl
    • -38
    • +35
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
    • -3
    • +3
    /openacs-4/packages/ecommerce/tcl/qmail-procs.tcl
7:40 am

gilbertw

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

Options
    • -0
    • +8
    /openacs-4/packages/ecommerce/www/admin/products/add-4-oracle.xql
    • -31
    • +44
    /openacs-4/packages/ecommerce/www/admin/products/add-4-postgresql.xql
    • -1
    • +4
    /openacs-4/packages/ecommerce/www/admin/products/add-4.tcl
7:39 am

gilbertw

fixed ec_product__new function

Options
    • -21
    • +16
    /openacs-4/packages/ecommerce/sql/postgresql/ec-product-package-create.sql
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
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-0.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-0.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-2-oracle.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-2-postgresql.xql
    • -2
    • +7
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-2.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-2.xql
    • -1
    • +5
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add.xql
2:03 am

gilbertw

fixed queryname names. fixed outer join which wasn't picked up by the query extractor.

Options
    • -2
    • +15
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
    • -2
    • +16
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
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
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-0.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-0.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-2-oracle.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-2-postgresql.xql
    • -2
    • +7
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-2.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/category-add-2.xql
    • -1
    • +6
    /openacs-4/packages/ecommerce/www/admin/cat/category-add.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/category-add.xql
    • -1
    • +5
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-0.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-0.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-2-oracle.xql
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-2-postgresql.xql
    • -2
    • +7
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-2.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-2.xql
    • -1
    • +5
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add.tcl
    • -1
    • +1
    /openacs-4/packages/ecommerce/www/admin/cat/subcategory-add.xql
Tuesday 17 Jul 2001
11:56 pm

gilbertw

fixed oracle sign() calls

Options
    • -5
    • +5
    /openacs-4/packages/ecommerce/www/admin/products/offers-postgresql.xql
    • -3
    • +3
    /openacs-4/packages/ecommerce/www/admin/products/sale-prices-postgresql.xql