Changeset 3841

Timestamp:

8 Jan 2009, 15:07:41 (16 years ago)

Author:

Henrik Bettermann

Message:

• further improvements for student data archiving by importCSV
• first customizations for AAUE payment
• minor changes

Location:

WAeUP_SRP/trunk

Files:

• WAeUPImport.py (modified) (1 diff)
• WAeUPTables.py (modified) (1 diff)
• skins/waeup_aaue/getPaymentsFolderInfo.py (added)
• skins/waeup_aaue/getSchoolFee.py (added)
• skins/waeup_aaue/interswitch_form.pt (added)
• skins/waeup_aaue/pay_interswitch.py (added)
• skins/waeup_ois/academic_report_slip.pt (modified) (1 diff)
• skins/waeup_ois/academic_report_view.pt (modified) (1 diff)

WAeUP_SRP/trunk/WAeUPImport.py

@@ -910 +910 @@
                 line.append(format % d)
                 open(export_file,"a").write('\n'.join(line) +'\n')
+                self.course_results.getExportRemoveAllCourses(student_id = student_id, export = True, remove = True)
                 # end export
                 students_folder.manage_delObjects((student_id),)         

WAeUP_SRP/trunk/WAeUPTables.py

@@ -1667 +1667 @@
         return courses
     ###)
+    
+    def getExportRemoveAllCourses(self,student_id,export=False,remove=False): ###(
+        ""
+        query = Eq('student_id',student_id)
+        cr_catalog = self.course_results
+        course_results = cr_catalog.evalAdvancedQuery(query)
+        courses = []
+        fields = self.schema()
+        format = '"%(' + ')s","%('.join(fields) + ')s"'
+        for brain in course_results:
+            d = {}
+            for field in fields:
+                d[field] = getattr(brain,field,'')
+            courses.append(format % d)
+                
+        if export:
+            export_file = "%s/export/course_results_removed.csv" % (i_home)
+            file_handler = open(export_file,"a")
+            headline = ','.join(fields)
+            file_handler.write(headline +'\n')
+            for line in courses: 
+                file_handler.write(line +'\n')
+
+        if remove:
+            for brain in course_results:
+                key = getattr(brain,'key','')
+                cr_catalog.deleteRecord(key)
+        
+        return courses
+    ###)    
 
 InitializeClass(CourseResults)

WAeUP_SRP/trunk/skins/waeup_ois/academic_report_slip.pt

@@ -26 +26 @@
                     <tr tal:condition="python:info[sem[1]]">
                         <th />
-                        <th align='center'>ATL</th>  
+                        <th align='center'>Attitude To <br />Learning</th>  
                         <th align='center'>CA 1 <br />Marks</th>
                         <th align='center'>CA 2 <br />Marks</th>    

WAeUP_SRP/trunk/skins/waeup_ois/academic_report_view.pt

@@ -85 +85 @@
         <th tal:attributes="colspan python: test(show_check_boxes,'2','1')" 
             tal:content="python:sem[1]" />
-        <th align='center'>ATL</th>    
+        <th align='center'>Attitude To Learning</th>    
         <th align='center'>CA 1 <br />Marks</th>
         <th align='center'>CA 2 <br />Marks</th>