Tooltron

import datetime

from datetime import date

            # check if member has paid recently 

            # first, figure out what semester it is

            today = date.today()

            # semester start dates

            aug20 = datetime.date(today.year, 8, 20) # Fall semester

            may21 = datetime.date(today.year, 5, 21) # summer

            jan1  = datetime.date(today.year, 1,  1) # Spring semester

            # if they don't fall after those two, its fall

            if today > aug20:

               print "its fall semester!"

               #its fall, so they must have paid after may21 (either full year of half) to be paid

               qry3 = "SELECT civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + may21.strftime('%m/%d/%Y') + "', '%m/%d/%Y') ,  \

                       DATE_FORMAT(civicrm_value_roboclub_info_2.date_paid_10, '%M %d %Y') \

                       FROM civicrm_value_roboclub_info_2 \

                       WHERE civicrm_value_roboclub_info_2.card_number_1 = " + id.group(1) + ";"

            elif today > may21:

               print "its summer!"

               #its summer, so they need to have paid either full year since aug20 or one semester since jan 1

               qry3 = "SELECT (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + aug20.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                               civicrm_value_roboclub_info_2.amount_paid_11 = 25) OR \

                              (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + jan1.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                               civicrm_value_roboclub_info_2.amount_paid_11 = 15) , \

                       DATE_FORMAT(civicrm_value_roboclub_info_2.date_paid_10, '%M %d %Y') \

                       FROM civicrm_value_roboclub_info_2 \

                       WHERE civicrm_value_roboclub_info_2.card_number_1 = " + id.group(1) + ";"

               cursor.execute(qry3)

               result = cursor.fetchall()

               print result

            else:

               print "its spring!"

               #its spring, so they must have either paid full after aug20 or one semester since jan 1 (this is the same as summer)

               qry3 = "SELECT (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + aug20.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                               civicrm_value_roboclub_info_2.amount_paid_11 = 25) OR \

                              (civicrm_value_roboclub_info_2.date_paid_10 >= STR_TO_DATE('" + jan1.strftime('%m/%d/%Y') + "', '%m/%d/%Y') AND \

                               civicrm_value_roboclub_info_2.amount_paid_11 = 15) , \

                       DATE_FORMAT(civicrm_value_roboclub_info_2.date_paid_10, '%M %d %Y') \

                       FROM civicrm_value_roboclub_info_2 \

                       WHERE civicrm_value_roboclub_info_2.card_number_1 = 810797813"

#" + id.group(1) + ";"

            cursor.execute(qry3)

            result = cursor.fetchall()

            if len(result) == 0 or result[0][0] == 0 or result[0][0] == "NULL":

               print "DENIED: user has not paid recently enough!"

               if len(result[0]) >= 2:

                  print "date_paid: ",result[0][1]

                  logMessage(user + " has not paid since " + result[0][1] + ", revoking access!")

               else:

                  logMessage(user + " has not paid, revoking access!")

               acl = []