OpenACS / openacs-4 / packages / dotlrn-ecommerce

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 05 Apr
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 05 Jan 2021
9:55 am

gustafn

add explicit casts to all max_n_rels with value null to increase readability and to ease function disambiguation

Options
    • -5
    • +5
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
    • -4
    • +4
    ./postgresql/upgrade/upgrade-0.1d3-0.1d4.sql
  3. … 8 more files in changeset.
Sunday 12 Mar 2006
1:44 am

daveb

CHeck show_price_p on display. Set show_price_p on existing sections.

Options
    • -2
    • +3
    ./postgresql/upgrade/upgrade-0.1d24-0.1d25.sql
  2. … 1 more file in changeset.
Friday 10 Mar 2006
8:28 pm

roelc

Added option to show section price or not

Options
    • -1
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-0.1d24-0.1d25.sql
  3. … 5 more files in changeset.
Monday 27 Feb 2006
3:50 am

roelc

Removed not null constraint in dotlrn_ecommerce_orders.checked_out_by

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
Tuesday 21 Feb 2006
1:50 pm

hamiltonc

the assessmant_map table should be created on package install

Options
    • -1
    • +16
    ./postgresql/dotlrn-ecommerce-create.sql
Saturday 28 Jan 2006
12:10 am

hamiltonc

added a custom field that was defined in an upgrade script, seems we forgot to update the create script to include this custom field for new installs, added additiona fields that should be dropped by dotlrn-ecommerce-views-drop.sql

Options
    • -2
    • +6
    ./postgresql/dotlrn-ecommerce-create.sql
    • -1
    • +6
    ./postgresql/dotlrn-ecommerce-views-drop.sql
Monday 23 Jan 2006
10:16 am

roelc

Changed member states "awaiting payment" to "application sent", and "payment received" to "application approved", functionality had evolved and the old member states had been misnomers.

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.1d23-0.1d24.sql
9:04 am

roelc

Changed member states "awaiting payment" to "application sent", and "payment received" to "application approved", functionality had evolved and the old member states had been misnomers.

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-create.sql
    • -0
    • +6
    ./postgresql/upgrade/upgrade-0.1d23-0.1d24.sql
  3. … 21 more files in changeset.
Wednesday 19 Oct 2005
11:48 am

tracya

adding credit card type to dlec_view_orders

Options
    • -0
    • +55
    ./postgresql/upgrade/upgrade-0.1d23-0.1d24.sql
11:27 am

tracya

addin credit card type to dlec_view_orders

Options
    • -3
    • +7
    ./postgresql/dotlrn-ecommerce-views-create.sql
Monday 17 Oct 2005
3:02 pm

roelc

Support showing/hiding individual sections

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-0.1d22-0.1d23.sql
  2. … 2 more files in changeset.
Thursday 13 Oct 2005
3:47 am

tracya

adding session and start date views

Options
    • -0
    • +46
    ./postgresql/upgrade/upgrade-0.1d21-0.1d22.sql
3:45 am

tracya

formatting

Options
    • -2
    • +9
    ./postgresql/dotlrn-ecommerce-views-create.sql
3:32 am

tracya

adding views for sessions and for start date

Options
    • -2
    • +40
    ./postgresql/dotlrn-ecommerce-views-create.sql
Tuesday 27 Sep 2005
9:12 pm

tracya

fixes to dlec_view_orders to use in order page

Options
    • -5
    • +3
    ./postgresql/dotlrn-ecommerce-views-create.sql
    • -5
    • +3
    ./postgresql/upgrade/upgrade-0.1d19-0.1d20.sql
8:32 pm

tracya

fixes order view and adds location

Options
    • -0
    • +70
    ./postgresql/upgrade/upgrade-0.1d19-0.1d20.sql
8:08 pm

tracya

adding confirmed_date_only_date

Options
    • -3
    • +3
    ./postgresql/dotlrn-ecommerce-views-create.sql
7:26 pm

tracya

changing name to location instead of zone

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-views-create.sql
7:05 pm

tracya

changing zone to location; modifying dlec_view_orders to have same query as orders page

Options
    • -12
    • +46
    ./postgresql/dotlrn-ecommerce-views-create.sql
Monday 19 Sep 2005
7:53 am

hamiltonc

fix membership create so that instructors and teaching assistants are give dotlrn_admin_rel role, fixed a missing close brace in a comment inside tree-chuck.tcl

Options
    • -2
    • +2
    ./postgresql/dotlrn-ecommerce-memberships-create.sql
  2. … 1 more file in changeset.
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.