Index: openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info,v diff -u -N -r1.48 -r1.49 --- openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info 21 Feb 2006 12:49:08 -0000 1.48 +++ openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info 10 Mar 2006 19:28:53 -0000 1.49 @@ -7,15 +7,15 @@ f t - + Roel Canicula Package to tie the dotLRN, Ecommerce, Assessments and dotLRN Catalog packages together 2005-08-10 Solution Grove Package to tie the dotLRN, Ecommerce, Assessments and dotLRN Catalog packages together. Initially intended for the MOS and MGH projects, the goal is to create a reusable module for similar projects. 0 - + Index: openacs-4/packages/dotlrn-ecommerce/lib/section.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/section.tcl,v diff -u -N -r1.32 -r1.33 --- openacs-4/packages/dotlrn-ecommerce/lib/section.tcl 12 Jan 2006 13:26:26 -0000 1.32 +++ openacs-4/packages/dotlrn-ecommerce/lib/section.tcl 10 Mar 2006 19:28:53 -0000 1.33 @@ -114,13 +114,15 @@ {price:currency,to_sql(sql_number) {label "Regular Price"} {html {size 6}} {help_text {Enter any fees related to this course here. \$0 in this field means there is no related fee.}} } + {show_price_p:text(radio) {label "Show Price Information"} {options {{Yes t} {No f}}}} } } else { ad_form -extend -name add_section -form { {section_name:text {label "Section Code"} {help_text {E.g. Section 01, W06}}} {price:currency,to_sql(sql_number) {label "Regular Price"} {html {size 6}} {help_text "Enter any fees related to this course here."} } + {show_price_p:text(radio) {label "Show Price Information"} {options {{Yes t} {No f}}}} } } @@ -405,6 +407,7 @@ } set show_participants_p t set show_sessions_p t + set show_price_p t } -new_request { set product_id 0 set price [template::util::currency::create "$" "0" "." "00" ] @@ -590,8 +593,8 @@ # Use item_id as course_id coz course_id is the revision and # its easier to keep track of the item_id db_dml add_section { - insert into dotlrn_ecommerce_section(section_id, course_id, section_name, community_id,product_id, notify_waiting_number, show_participants_p, show_sessions_p, description) values - (:section_id, :item_id, :section_name, :community_id, :product_id, :notify_waiting_number, :show_participants_p, :show_sessions_p, :description) + insert into dotlrn_ecommerce_section(section_id, course_id, section_name, community_id,product_id, notify_waiting_number, show_participants_p, show_sessions_p, description, show_price_p) values + (:section_id, :item_id, :section_name, :community_id, :product_id, :notify_waiting_number, :show_participants_p, :show_sessions_p, :description, :show_price_p) } # for this to work, dotlrn_eccomerce_section must be an object @@ -672,6 +675,7 @@ notify_waiting_number = :notify_waiting_number, show_participants_p = :show_participants_p, show_sessions_p = :show_sessions_p, + show_price_p = :show_price_p, description = :description where section_id = :section_id } Index: openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-oracle.xql,v diff -u -N -r1.9 -r1.10 --- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-oracle.xql 23 Jan 2006 01:59:47 -0000 1.9 +++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-oracle.xql 10 Mar 2006 19:28:53 -0000 1.10 @@ -21,7 +21,7 @@ select dc.course_id, dc.course_key, dc.course_name, dc.assessment_id, dec.section_id, dec.section_name, dec.product_id, dec.community_id, dc.course_info, - ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p, v.display_section_p + ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p, v.display_section_p, dec.show_price_p $discount_clause Index: openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql,v diff -u -N -r1.11 -r1.12 --- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql 23 Jan 2006 01:59:46 -0000 1.11 +++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql 10 Mar 2006 19:28:53 -0000 1.12 @@ -20,7 +20,7 @@ select dc.course_id, trim(dc.course_key) as course_key, dc.course_name, dc.assessment_id, dec.section_id, dec.section_name, dec.product_id, dec.community_id, dc.course_info, - ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p, v.display_section_p + ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p, v.display_section_p, dec.show_price_p $discount_clause Index: openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk.tcl,v diff -u -N -r1.73 -r1.74 --- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk.tcl 10 Mar 2006 13:26:20 -0000 1.73 +++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk.tcl 10 Mar 2006 19:28:53 -0000 1.74 @@ -325,7 +325,9 @@
@course_list.sessions;noquote@
@course_list.section_zones;noquote@
@course_list.instructor_names;noquote@ +
[_ dotlrn-ecommerce.lt_There_is_no_fee_for_t]@course_list.prices;noquote@ +
@course_list.attendees;noquote@ [_ dotlrn-ecommerce.participant]s ,
@course_list.available_slots;noquote@ [_ dotlrn-ecommerce.available] Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql,v diff -u -N -r1.26 -r1.27 --- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql 27 Feb 2006 02:50:29 -0000 1.26 +++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql 10 Mar 2006 19:28:52 -0000 1.27 @@ -31,6 +31,7 @@ non_member_price numeric, show_participants_p char(1) check (show_participants_p in ('t','f')), show_sessions_p char(1) check (show_sessions_p in ('t','f')), + show_price_p char(1) check (show_price_p in ('t','f')), description text ); Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d24-0.1d25.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d24-0.1d25.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d24-0.1d25.sql 10 Mar 2006 19:28:52 -0000 1.1 @@ -0,0 +1,11 @@ +-- +-- packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d24-0.1d25.sql +-- +-- @author Roel Canicula (roel@solutiongrove.com) +-- @creation-date 2006-03-11 +-- @arch-tag: c8c75af9-53d4-47c4-931b-345860a6553f +-- @cvs-id $Id: upgrade-0.1d24-0.1d25.sql,v 1.1 2006/03/10 19:28:52 roelc Exp $ +-- + +alter table dotlrn_ecommerce_section add show_price_p char(1); +alter table dotlrn_ecommerce_section alter show_price_p set default 't'; \ No newline at end of file