OpenACS / openacs-4 / packages / dotlrn-ecommerce

sql

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 12 Mar
Commits this week: 0
Total Lines of Code (LoC): 2,081
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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 15 Sep 2005
8:15 pm

tracya

changine dotlrn_ecommerce_sections to dotlrn_view_sections to add course name

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1d17-0.1d18.sql
6:27 pm

roelc

Renamed views to dotlrn_view_section_report and dotlrn_view_membership_orders

Options
    • -3
    • +3
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-0.1d17-0.1d18.sql
Wednesday 14 Sep 2005
7:45 pm

roelc

Updated dlec_members view to show membership orders instead

Options
    • -11
    • +18
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -11
    • +18
    ./postgresql/upgrade/upgrade-0.1d17-0.1d18.sql
5:47 pm

roelc

Added dlec_sections and dlec_members views and a version bump to run upgrade script

Options
    • -1
    • +35
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-0.1d17-0.1d18.sql
  3. … 1 more file in changeset.
Tuesday 06 Sep 2005
7:25 am

roelc

Improved association of application to assessment

Options
    • -0
    • +22
    ./postgresql/upgrade/upgrade-0.1d14-0.1d15.sql
  2. … 4 more files in changeset.
Saturday 03 Sep 2005
2:56 am

roelc

Moved drop cals from dotlrn-ecommerce-views-create.sql to drop script

Options
    • -1
    • +3
    ./postgresql/dotlrn-ecommerce-drop.sql
    • -18
    • +1
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -0
    • +25
    ./postgresql/dotlrn-ecommerce-views-drop.sql
Thursday 01 Sep 2005
2:23 pm

roelc

Added column in order summary page to keep track if the order was done by the user or by an admin

Options
    • -3
    • +4
    ./postgresql/dotlrn-ecommerce-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-0.1d12-0.1d13.sql
  3. … 5 more files in changeset.
Sunday 21 Aug 2005
12:33 am

roelc

Upgrade scripts to 0.1d8, add show_description_p ecommerce custom field and new parameters

Options
    • -0
    • +12
    ./postgresql/upgrade/upgrade-0.1d7-0.1d8.sql
  2. … 1 more file in changeset.
Saturday 20 Aug 2005
8:27 pm

roelc

Support for accepting discount codes

Options
    • -0
    • +4
    ./oracle/dotlrn-ecommerce-create.sql
    • -1
    • +5
    ./postgresql/dotlrn-ecommerce-create.sql
  3. … 12 more files in changeset.
Wednesday 10 Aug 2005
11:30 pm

roelc

Added support for multi-item discount and lock box payment method

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-0.1d4-0.1d5.sql
  2. … 3 more files in changeset.
11:18 pm

roelc

Added lock box payment method

Options
    • -1
    • +1
    ./oracle/dotlrn-ecommerce-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
  3. … 3 more files in changeset.
Tuesday 09 Aug 2005
5:08 am

hamiltonc

add additional roles and relations to dotlrn_community type for use with dotlrn-ecommerce

Options
    • -0
    • +214
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
    • -0
    • +215
    ./postgresql/upgrade/upgrade-0.1d3-0.1d4.sql
  3. … 2 more files in changeset.
Friday 05 Aug 2005
12:38 pm

hamiltonc

add dotlrn-ecommerce views

Options
    • -1
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
    • -0
    • +204
    ./postgresql/dotlrn-ecommerce-views-create.sql
6:02 am

hamiltonc

fixed a line in dotlrn ecommerce create

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
Thursday 04 Aug 2005
1:35 am

roelc

Add table to hold invoice payments

Options
    • -0
    • +17
    ./postgresql/upgrade/upgrade-0.1d2-0.1d3.sql
  2. … 1 more file in changeset.
12:44 am

roelc

Added table for invoice payments

Options
    • -1
    • +10
    ./postgresql/dotlrn-ecommerce-create.sql
Sunday 31 Jul 2005
12:17 am

roelc

Added support for cash, invoice and scholarships payment methods

Options
    • -1
    • +1
    ./oracle/dotlrn-ecommerce-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
    • -0
    • +12
    ./postgresql/upgrade/upgrade-0.1d1-0.1d2.sql
  4. … 2 more files in changeset.
Monday 25 Jul 2005
3:25 pm

roelc

Added show_session_p and description fields

Options
    • -2
    • +3
    ./postgresql/dotlrn-ecommerce-create.sql
Friday 22 Jul 2005
12:56 pm

hamiltonc

add a description field to dotlrn_ecommerce_section table, internationalize instructor and assistant instructor form labels

Options
    • -1
    • +2
    ./oracle/dotlrn-ecommerce-create.sql
    • -0
    • +5
    ./oracle/upgrade/upgrade-0.1d-0.1d1.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-0.1d-0.1d1.sql
  4. … 4 more files in changeset.
4:46 am

hamiltonc

added missing ); in membership create.sql

Options
    • -1
    • +1
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
Thursday 21 Jul 2005
11:35 am

roelc

Make sessions information optional

Options
    • -2
    • +3
    ./postgresql/dotlrn-ecommerce-create.sql
  2. … 4 more files in changeset.
Wednesday 20 Jul 2005
7:40 pm

roelc

Bugfix on member states

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
1:35 pm

roelc

Added option in section add/edit to display number of participants

Options
    • -3
    • +4
    ./postgresql/dotlrn-ecommerce-create.sql
  2. … 4 more files in changeset.
5:22 am

hamiltonc

fixed membership create for oracle, updated xql file for checkout-one-form-2

Options
    • -4
    • +2
    ./oracle/dotlrn-ecommerce-memberships-create.sql
  2. … 3 more files in changeset.
Tuesday 19 Jul 2005
8:15 pm

roelc

Changed flow for application assessment, assessment is presented before order hits the shopping cart and user is immediately placed in the waiting list

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
  2. … 7 more files in changeset.
Saturday 16 Jul 2005
2:51 pm

hamiltonc

commit changes from July 11 to July 16 the week that cvs.openacs.org was down, added concept of membership and membership pricing in dotlrn-ecommerce shopping cart various bug fixes and modifications to dotlrn-ecommerce

Options
    • -1
    • +5
    ./postgresql/dotlrn-ecommerce-create.sql
    • -1
    • +1
    ./postgresql/dotlrn-ecommerce-drop.sql
  3. … 77 more files in changeset.
Thursday 07 Jul 2005
8:17 pm

roelc

Initial prerequisites support for prerequisites

Options
    • -2
    • +14
    ./postgresql/dotlrn-ecommerce-create.sql
    • -2
    • +5
    ./postgresql/dotlrn-ecommerce-drop.sql
  3. … 3 more files in changeset.
Wednesday 06 Jul 2005
6:58 am

hamiltonc

to get the rels to work on oracle we have to shorten the rel name in many places, this affects postgres too

Options
    • -37
    • +41
    ./oracle/dotlrn-ecommerce-memberships-create.sql
    • -24
    • +24
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
  3. … 10 more files in changeset.
Monday 04 Jul 2005
4:28 pm

hamiltonc

get dotlrn-ecommerce to install.oracle, move queries from tcl files into xql files, removed empty xql files, shortened view names particularly in dotlrn-ecommerce-membership-create due to oracle's limit on identifier names

Options
    • -0
    • +167
    ./oracle/dotlrn-ecommerce-admin-portlet-create.sql
    • -0
    • +73
    ./oracle/dotlrn-ecommerce-create.sql
    • -0
    • +8
    ./oracle/dotlrn-ecommerce-drop.sql
    • -0
    • +209
    ./oracle/dotlrn-ecommerce-memberships-create.sql
    • -6
    • +6
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
  6. … 22 more files in changeset.
Thursday 23 Jun 2005
2:31 pm

roelc

Added dotlrn_ecommerce_transactions table

Options
    • -1
    • +7
    ./postgresql/dotlrn-ecommerce-create.sql