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.42 -r1.43 --- openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info 8 Oct 2005 15:09:42 -0000 1.42 +++ openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info 17 Oct 2005 13:03:00 -0000 1.43 @@ -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/tree-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql,v diff -u -N -r1.8 -r1.9 --- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql 29 Aug 2005 11:46:38 -0000 1.8 +++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql 17 Oct 2005 13:03:00 -0000 1.9 @@ -33,6 +33,8 @@ where dc.course_id = ci.live_revision and dc.display_p + and (v.display_section_p = 't' or + v.display_section_p is null) [template::list::filter_where_clauses -and -name course_list] order by lower(dc.course_name), lower(dec.section_name) Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d22-0.1d23.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d22-0.1d23.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d22-0.1d23.sql 17 Oct 2005 13:02:59 -0000 1.1 @@ -0,0 +1,14 @@ +-- +-- packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d22-0.1d23.sql +-- +-- @author Roel Canicula (roelmc@pldtdsl.net) +-- @creation-date 2005-10-17 +-- @arch-tag: eed5abe5-d150-48cc-bcc9-c6d3197cd0ce +-- @cvs-id $Id: upgrade-0.1d22-0.1d23.sql,v 1.1 2005/10/17 13:02:59 roelc Exp $ +-- + +insert into ec_custom_product_fields (field_identifier, field_name, default_value, column_type, last_modified,last_modifying_user, modified_ip_address) values ('display_section_p', 'Display Section', '', 'boolean', now(), '0', '0.0.0.0'); +alter table ec_custom_product_field_values add display_section_p boolean; +alter table ec_custom_p_field_values_audit add display_section_p boolean; + +update ec_custom_product_field_values set display_section_p = 't'; \ No newline at end of file