Changeset 2666 for WAeUP_SRP/base/WAeUPTool.py

Timestamp:

15 Nov 2007, 15:06:02 (17 years ago)

Author:

joachim

Message:

forgot

File:

• WAeUP_SRP/base/WAeUPTool.py (modified) (3 diffs)

WAeUP_SRP/base/WAeUPTool.py

@@ -299 +299 @@
     def dumpSchoolfeePayments(self):
         "dump paid schoolfees"
+        mtool = self.portal_membership
+        member = mtool.getAuthenticatedMember()
         logger = logging.getLogger('WAeUPTool.dumpSchoolfees')
         aq_student = self.students_catalog.evalAdvancedQuery
@@ -306 +308 @@
                                    ))
         res = aq_student(query)
-        import pdb;pdb.set_trace()
+        #import pdb;pdb.set_trace()
         l = []
         logger.info("start for %d" % len(res))
@@ -319 +321 @@
             d = {}
             d['student_id'] = student.id
-            d['amount'] = fee_dict.get('new')
+            d['name'] = student.name
+            d['amount'] = fee_dict.get(new_returning)
             l += d,
-        import pdb;pdb.set_trace()
+        csv_name = self.dumpListToCSV(l,'payments')
+        logger.info('%s dumped payments to %s' % (member,export_file))
+    ###)
+
+    security.declarePublic('dumpListToCSV') ###(
+    def dumpListToCSV(self,l,filename,fields=None):
+        """dump a list of dicts to a CSV file"""
+        current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
+        export_file = "%s/export/%s_%s.csv" % (i_home,filename,current,)
+        if fields is None:
+            fields = l[0].keys()
+        headline = ','.join(fields)
+        out = open(export_file,"wb")
+        out.write(headline +'\n')
+        out.close()
+        out = open(export_file,"a")
+        csv_writer = csv.DictWriter(out,fields,)
+        csv_writer.writerows(l)
+        return export_file
     ###)