def subtonews(first_name, last_name, email, chapter_id):
cursor = connection.cursor()
cursor.execute('SELECT u.id, u.email_chapter_optin FROM auth_user as u, auth_memberstatus as ms WHERE u.email = "' + email + '" AND u.id = ms.user_id AND ms.status_date_end IS NULL AND ms.statusType_id = 8 AND u.chapter_id = ' + str(chapter_id))
user = cursor.fetchone()
if user:
if int(user[1]) == 1:
raise SubToNewsException(_('That email address is already subscribed'))
else:
# reinstate a previous subscriber's subscription
user = User.objects.get(pk=user[0])
user.email_chapter_optin = True
user.first_name = first_name
user.last_name = last_name
user.save()
else:
user = User()
columns = ['first_name', 'last_name', 'email']
row = [first_name, last_name, email]
user.username = generate_unique_username(row, columns)
user.first_name = first_name
user.last_name = last_name
user.email = email
user.chapter_id = chapter_id
user.email_chapter_optin = True
user.date_joined = datetime.now()
user.save()
# Must be called after save() because the primary key
# is required for these
mt = MemberStatus(user_id=user.pk, statusType_id=8)
mt.save()
def subtonews(first_name, last_name, email, chapter_id):
cursor = connection.cursor()
cursor.execute(
'SELECT u.id, u.email_chapter_optin FROM auth_user as u, auth_memberstatus as ms WHERE u.email = "'
+ email +
'" AND u.id = ms.user_id AND ms.status_date_end IS NULL AND ms.statusType_id = 8 AND u.chapter_id = '
+ str(chapter_id))
user = cursor.fetchone()
if user:
if int(user[1]) == 1:
raise SubToNewsException(
_('That email address is already subscribed'))
else:
# reinstate a previous subscriber's subscription
user = User.objects.get(pk=user[0])
user.email_chapter_optin = True
user.first_name = first_name
user.last_name = last_name
user.save()
else:
user = User()
columns = ['first_name', 'last_name', 'email']
row = [first_name, last_name, email]
user.username = generate_unique_username(row, columns)
user.first_name = first_name
user.last_name = last_name
user.email = email
user.chapter_id = chapter_id
user.email_chapter_optin = True
user.date_joined = datetime.now()
user.save()
# Must be called after save() because the primary key
# is required for these
mt = MemberStatus(user_id=user.pk, statusType_id=8)
mt.save()
