Changeset 2391

Timestamp:

19 Oct 2007, 09:24:16 (17 years ago)

Author:

joachim

Message:

current version (NOT in custom)

File:

• WAeUP_SRP/base/skins/waeup_utilities/getPaymentStatistic.py (modified) (5 diffs)

WAeUP_SRP/base/skins/waeup_utilities/getPaymentStatistic.py

@@ -37 +37 @@
     response.write("%s<br>\n\r" % s)
 
-# aso = aq_portal(Eq('portal_type','Payment'))# & In("SearchableText",("approved","Approved")))
+# aso = aq_portal(Eq('portal_type','Payment') &\
+#                 #Eq('review_state','closed') &\
+#                 ~Eq("SearchableText",'sc') &\
+#                 ~Eq("SearchableText",'approved') &\
+#                 ~Eq("SearchableText",'incomplete') &\
+#                 ~Eq("SearchableText",'invalid') &\
+#                 ~Eq("SearchableText",'incorrect') &\
+#                 ~Eq("SearchableText",'card') &\
+#                 ~Eq("SearchableText",'error') &\
+#                 ~Eq("SearchableText",'channels') &\
+#                 ~Eq("SearchableText",'exceeded') &\
+#                 ~Eq("SearchableText",'insufficient'))
 # #set_trace()
 # count = 0
+# rwrite("total: %d" % len(aso))
 # for pp in aso:
 #     count += 1
@@ -47 +59 @@
 #     rwrite("%s %s %s" % (pp.id,pp.listCreators,indexdata['SearchableText']))
 # return
+
 pbs = pins.uniqueValuesFor('prefix_batch')
 hostel_pbs = []
@@ -83 +96 @@
                   'prefixes': application_pbs,
                  }
-aso = aq_portal(Eq('portal_type','Payment') & Eq("SearchableText","approved"))
+aso_query = Eq('portal_type','Payment') & Eq("SearchableText","approved")
+aso = aq_portal(aso_query)
 # for pp in aso:
 #     indexdata = portal.getIndexDataForRID(pp.getRID())
@@ -92 +106 @@
                   'prefixes': (),
                  }
-aspaysc = aq_portal(Eq('portal_type','Payment') &\
+aspaysc_query = Eq('portal_type','Payment') &\
                     Eq("SearchableText","payment") &\
                     Eq("SearchableText","successful") &\
                     ~ Eq("SearchableText","transfer")
-                   )
+
+aspaysc = aq_portal(aspaysc_query)
 #rwrite("*"*80)
 # for pp in aspaysc:
@@ -104 +119 @@
                  'fee': 1000,
                  'title': 'Schoolfee (sc in payments)',
+                  'prefixes': (),
+                 }
+not_query = ~aso_query & ~aspaysc_query
+not_res = aq_portal(aspaysc_query)
+fees['schoolfee_not'] = {'anz' : len(not_res),
+                 'fee': 0,
+                 'title': 'Not Schoolfee',
                   'prefixes': (),
                  }