Changeset 2386 for WAeUP_SRP/base

Timestamp:

18 Oct 2007, 16:37:24 (17 years ago)

Author:

joachim

Message:

count online payments + two counts for scratchcards (in custom)

File:

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

WAeUP_SRP/base/skins/waeup_utilities/getPaymentStatistic.py

@@ -27 +27 @@
 pins = context.portal_pins
 aq_pins = context.portal_pins.evalAdvancedQuery
+portal = context.portal_catalog_real
 aq_portal = context.portal_catalog_real.evalAdvancedQuery
 request = context.REQUEST
@@ -36 +37 @@
     response.write("%s<br>\n\r" % s)
 
+# aso = aq_portal(Eq('portal_type','Payment'))# & In("SearchableText",("approved","Approved")))
+# #set_trace()
+# count = 0
+# for pp in aso:
+#     count += 1
+#     if count > 1000:
+#         break
+#     indexdata = portal.getIndexDataForRID(pp.getRID())
+#     rwrite("%s %s %s" % (pp.id,pp.listCreators,indexdata['SearchableText']))
+# return
 pbs = pins.uniqueValuesFor('prefix_batch')
 hostel_pbs = []
@@ -45 +56 @@
 
 schoolfee_pbs = list(pbs)[:]
-for pb in application_pbs + hostel_pbs + clearance_pbs:
+for pb in application_pbs + hostel_pbs + clearance_pbs + ['HOS1','HOS2']:
     schoolfee_pbs.remove(pb)
 fees = {}
@@ -70 +81 @@
                   'prefixes': application_pbs,
                  }
-aso = aq_portal(Eq('portal_type','Payment') & In("SearchableText",("successful",)))
+aso = aq_portal(Eq('portal_type','Payment') & Eq("SearchableText","approved"))
+# for pp in aso:
+#     indexdata = portal.getIndexDataForRID(pp.getRID())
+#     rwrite("%s %s %s" % (pp.id,pp.listCreators,indexdata['SearchableText']))
 fees['schoolfee_onl'] = {'anz' : len(aso),
                  'fee': 1000,
@@ -76 +90 @@
                   'prefixes': (),
                  }
+aspaysc = aq_portal(Eq('portal_type','Payment') &\
+                    Eq("SearchableText","payment") &\
+                    Eq("SearchableText","successful"))
+rwrite("*"*80)
+# for pp in aspaysc:
+    # indexdata = portal.getIndexDataForRID(pp.getRID())
+    # rwrite("%s %s %s" % (pp.id,pp.listCreators,indexdata['SearchableText']))
+fees['schoolfee_paysc'] = {'anz' : len(aspaysc),
+                 'fee': 1000,
+                 'title': 'Schoolfee (sc in payments)',
+                  'prefixes': (),
+                 }
 #assc = [pin for pin in aq_pins(In('prefix_batch', schoolfee_pbs)) if pin.student]
 assc = aq_pins(In('prefix_batch', schoolfee_pbs) & missing_query)
 fees['schoolfee_scratch'] = {'anz' : len(assc),
-                 'fee': 1000,
-                 'title': 'Schoolfee (Scratchcard)',
+                 'fee': 0,
+                 'title': 'Schoolfee (Scratchcard counting)',
                   'prefixes': schoolfee_pbs,
                  }