Revision 291 trunk/swipe/tooltron.py

tooltron.py (revision 291)
268 268 
      else:
269 269 
         print "its spring!"
270 270 
         #its spring, so they must have either paid full after aug20 or one semester since jan 1 (this is the same as summer)
271 
         qry3 = "SELECT (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + aug20.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \
271 
         qry3 = "SELECT (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + may21.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \
272 272 
                         civicrm_value_roboclub_info_2.amount_paid_11 = 25) OR \
273 273 
                        (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + jan1.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \
274 274 
                         civicrm_value_roboclub_info_2.amount_paid_11 = 15) , \

Also available in: Unified diff