- Timestamp:
- 19 Oct 2007, 09:24:16 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
WAeUP_SRP/base/skins/waeup_utilities/getPaymentStatistic.py
r2387 r2391 37 37 response.write("%s<br>\n\r" % s) 38 38 39 # aso = aq_portal(Eq('portal_type','Payment'))# & In("SearchableText",("approved","Approved"))) 39 # aso = aq_portal(Eq('portal_type','Payment') &\ 40 # #Eq('review_state','closed') &\ 41 # ~Eq("SearchableText",'sc') &\ 42 # ~Eq("SearchableText",'approved') &\ 43 # ~Eq("SearchableText",'incomplete') &\ 44 # ~Eq("SearchableText",'invalid') &\ 45 # ~Eq("SearchableText",'incorrect') &\ 46 # ~Eq("SearchableText",'card') &\ 47 # ~Eq("SearchableText",'error') &\ 48 # ~Eq("SearchableText",'channels') &\ 49 # ~Eq("SearchableText",'exceeded') &\ 50 # ~Eq("SearchableText",'insufficient')) 40 51 # #set_trace() 41 52 # count = 0 53 # rwrite("total: %d" % len(aso)) 42 54 # for pp in aso: 43 55 # count += 1 … … 47 59 # rwrite("%s %s %s" % (pp.id,pp.listCreators,indexdata['SearchableText'])) 48 60 # return 61 49 62 pbs = pins.uniqueValuesFor('prefix_batch') 50 63 hostel_pbs = [] … … 83 96 'prefixes': application_pbs, 84 97 } 85 aso = aq_portal(Eq('portal_type','Payment') & Eq("SearchableText","approved")) 98 aso_query = Eq('portal_type','Payment') & Eq("SearchableText","approved") 99 aso = aq_portal(aso_query) 86 100 # for pp in aso: 87 101 # indexdata = portal.getIndexDataForRID(pp.getRID()) … … 92 106 'prefixes': (), 93 107 } 94 aspaysc = aq_portal(Eq('portal_type','Payment') &\108 aspaysc_query = Eq('portal_type','Payment') &\ 95 109 Eq("SearchableText","payment") &\ 96 110 Eq("SearchableText","successful") &\ 97 111 ~ Eq("SearchableText","transfer") 98 ) 112 113 aspaysc = aq_portal(aspaysc_query) 99 114 #rwrite("*"*80) 100 115 # for pp in aspaysc: … … 104 119 'fee': 1000, 105 120 'title': 'Schoolfee (sc in payments)', 121 'prefixes': (), 122 } 123 not_query = ~aso_query & ~aspaysc_query 124 not_res = aq_portal(aspaysc_query) 125 fees['schoolfee_not'] = {'anz' : len(not_res), 126 'fee': 0, 127 'title': 'Not Schoolfee', 106 128 'prefixes': (), 107 129 }
Note: See TracChangeset for help on using the changeset viewer.