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 -r1.11 -r1.12
--- openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info	22 Jul 2005 00:31:02 -0000	1.11
+++ openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info	22 Jul 2005 10:56:09 -0000	1.12
@@ -7,17 +7,18 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="0.1d" url="http://openacs.org/repository/download/apm/dotlrn-ecommerce-0.1d.apm">
+    <version name="0.1d1" url="http://openacs.org/repository/download/apm/dotlrn-ecommerce-0.1d1.apm">
         <owner url="mailto:roelmc@solutiongrove.com">Roel Canicula</owner>
         <summary>Package to tie the dotLRN, Ecommerce, Assessments and dotLRN Catalog packages together</summary>
         <vendor url="http://www.solutiongrove.com">Solution Grove</vendor>
         <description format="text/html">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.</description>
         <maturity>0</maturity>
 
-        <provides url="dotlrn-ecommerce" version="0.1d"/>
+        <provides url="dotlrn-ecommerce" version="0.1d1"/>
 
         <callbacks>
             <callback type="after-install"  proc="dotlrn_ecommerce::install"/>
+	    <callback type="after-upgrade"  proc="dotlrn_ecommerce::after_upgrade"/>
         </callbacks>
         <parameters>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="AllowRegistrationForOtherUsers"  default="1" description="Allow registration for other users."/>
Index: openacs-4/packages/dotlrn-ecommerce/catalog/dotlrn-ecommerce.en_US.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/catalog/dotlrn-ecommerce.en_US.ISO-8859-1.xml,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/dotlrn-ecommerce/catalog/dotlrn-ecommerce.en_US.ISO-8859-1.xml	22 Jul 2005 00:25:16 -0000	1.13
+++ openacs-4/packages/dotlrn-ecommerce/catalog/dotlrn-ecommerce.en_US.ISO-8859-1.xml	22 Jul 2005 10:56:09 -0000	1.14
@@ -10,6 +10,7 @@
   <msg key="application_pending">(application pending)</msg>
   <msg key="Application_rejected">Application rejected</msg>
   <msg key="apply_for_course">apply for course</msg>
+  <msg key="assistant_instructor">Assistant Instructor</msg>
   <msg key="awaiting_approval">(awaiting approval)</msg>
   <msg key="Balance_due">Balance due:</msg>
   <msg key="Bill_to">Bill to:</msg>
@@ -77,8 +78,7 @@
   <msg key="lt_Please_select_a_secti">Please select a section from the list</msg>
   <msg key="lt_Please_select_a_secti_1">Please select a section under this course</msg>
   <msg key="lt_Process_Purchase_for_">Process Purchase for %section_name%</msg>
-  <msg key="lt_Purchase__another_Cou">Purchase
-	  another Course/Section</msg>
+  <msg key="lt_Purchase__another_Cou">Purchase another Course/Section</msg>
   <msg key="lt_Purchase_another_Cour">Purchase another Course/Section</msg>
   <msg key="lt_Register_for_Another_">Register for Another Course</msg>
   <msg key="lt_Register_for_another_">Register for another course</msg>
@@ -93,8 +93,7 @@
   <msg key="lt_Thank_You_For_Your_Or">Thank You For Your Order</msg>
   <msg key="lt_The_course_only_has_a">The course only has $available_slots slot(s) left</msg>
   <msg key="lt_The_following_has_bee">The following has been sent to the purchaser</msg>
-  <msg key="lt_To_complete_your_orde">To complete your order, submit this form, and confirm the information
-    on the following page.</msg>
+  <msg key="lt_To_complete_your_orde">To complete your order, submit this form, and confirm the information on the following page.</msg>
   <msg key="lt_to_send_us_your_order">to send us your order!</msg>
   <msg key="lt_User_requests_for_app">User requests for approval</msg>
   <msg key="lt_Users_in_waiting_list">Users in waiting list</msg>
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 -r1.14 -r1.15
--- openacs-4/packages/dotlrn-ecommerce/lib/section.tcl	21 Jul 2005 21:19:01 -0000	1.14
+++ openacs-4/packages/dotlrn-ecommerce/lib/section.tcl	22 Jul 2005 10:56:09 -0000	1.15
@@ -105,7 +105,7 @@
 	}
 	
 	ad_form -extend -name add_section -form {
-		{ instructors:string(multiselect),multiple,optional {label "Instructors"} {options { $instructors_list } }	}
+		{ instructors:string(multiselect),multiple,optional {label "#dotlrn-ecommerce.Instructor#"} {options { $instructors_list } }	}
 	}
 }
 
@@ -123,7 +123,7 @@
 	}
 	
 	ad_form -extend -name add_section -form {
-		{ assistants:string(multiselect),multiple,optional {label "Assistants"} {options { $assistants_list } }	}
+		{ assistants:string(multiselect),multiple,optional {label "#dotlrn-ecommerce.assistant_instructor#"} {options { $assistants_list } }	}
 	}
 
 }
@@ -168,7 +168,15 @@
     }
 }
 
+# TICKET #159 section_description
+ad_form -extend -name add_section -form {
+	{description:text(textarea)
+	    {label "Description"}
+	    {html {cols 25 rows 10}}
+	}
+}
 
+
 # ecommerce stuff
 
 set exclude_list [list "'classid'"]
@@ -491,8 +499,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) values
-	    (:section_id, :item_id, :section_name, :community_id, :product_id, :notify_waiting_number, :show_participants_p, :show_sessions_p)
+	    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)
 	}
 
 	# for this to work, dotlrn_eccomerce_section must be an object 
@@ -566,7 +574,8 @@
 	    section_name = :section_name,
 	    notify_waiting_number = :notify_waiting_number,
 	    show_participants_p = :show_participants_p,
-	    show_sessions_p = :show_sessions_p
+	    show_sessions_p = :show_sessions_p,
+	    description = :description
 	    where section_id = :section_id
 	}
 
Index: openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-create.sql	4 Jul 2005 14:28:32 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-create.sql	22 Jul 2005 10:56:09 -0000	1.2
@@ -19,7 +19,8 @@
 	waiting_list_p       char(1) check (waiting_list_p in ('t','f')),
 	notify_waiting_number integer,
 	member_price_number   numeric,
-	non_member_price      numeric
+	non_member_price      numeric,
+	description	 text
 );
 
 create index de_community_id_idx ON dotlrn_ecommerce_section (community_id);
Index: openacs-4/packages/dotlrn-ecommerce/sql/oracle/upgrade/upgrade-0.1d-0.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/oracle/upgrade/upgrade-0.1d-0.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-ecommerce/sql/oracle/upgrade/upgrade-0.1d-0.1d1.sql	22 Jul 2005 10:56:09 -0000	1.1
@@ -0,0 +1,5 @@
+-- 
+-- packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql
+-- 
+
+alter table dotlrn_ecommerce_section add column description text;
\ No newline at end of file
Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql	22 Jul 2005 10:56:09 -0000	1.1
@@ -0,0 +1,5 @@
+-- 
+-- packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql
+-- 
+
+alter table dotlrn_ecommerce_section add column description text;
\ No newline at end of file
Index: openacs-4/packages/dotlrn-ecommerce/tcl/apm-callback-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/tcl/apm-callback-procs.tcl,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/dotlrn-ecommerce/tcl/apm-callback-procs.tcl	22 Jul 2005 04:35:11 -0000	1.12
+++ openacs-4/packages/dotlrn-ecommerce/tcl/apm-callback-procs.tcl	22 Jul 2005 10:56:09 -0000	1.13
@@ -62,10 +62,35 @@
 	-datatype "boolean" \
 	-pretty_name "Flag to display or hide course" \
 	-sort_order $sort_order \
-	-default_value "true"
+	-default_value "true" \
 	-column_spec "boolean"
 }
 
+ad_proc -private dotlrn_ecommerce::after_upgrade {
+    -from_version_name
+    -to_version_name
+} {
+    
+    
+    @author Hamilton Chua (hamilton.chua@gmail.com)
+    @creation-date 2005-07-22
+    
+    @param from_version_name
+
+    @param to_version_name
+
+    @return 
+    
+    @error 
+} {
+
+    #apm_upgrade_logic \
+    #    -from_version_name $from_version_name \
+    #    -to_version_name $to_version_name \
+    #    -spec {
+    #	}
+}
+
 ad_proc -private dotlrn-catalog::package_mount {
     -package_id
     -node_id