def renew_recent_resumers():
resume_date = fmt_date(datetime.date(current_year_end().year, 4, 1))
end_date = fmt_date(datetime.date(current_year_end().year, 8, 1))
query_clauses = [
('Payment', 'date', resume_date, '>=', None),
('Payment', 'type', PaymentType.dues, '=', None),
('Member', 'end_date', end_date, '=', None),
]
members = get_members_for_query(query_clauses)
count = 0
message = []
for member in members:
if member.is_recent_resume():
member.end_date = new_end_date
item = first_or_default([
a for a in member.actions if a.action == MemberAction.card
and a.status == ActionStatus.open
], None)
if not item:
item = Action(member_id=member.id,
date=datetime.date.today(),
action=MemberAction.card,
comment='auto renew recent resumer',
status=ActionStatus.open)
member.actions.append(item)
message += [member.dt_number()]
save_member(member)
count += 1
return '\n'.join(['{} members updated'.format(count)] + message)
def lapse_expired():
query_clauses = [
('Member', 'status', [s.value
for s in MemberStatus.all_active()], 'in', None),
('Member', 'end_date', fmt_date(previous_year_end()), '=', None)
]
members = get_members_for_query(query_clauses)
count = 0
for member in members:
member.status = MemberStatus.lapsed
save_member(member)
count += 1
return '{} records processed'.format(count)
def set_region():
query_clauses = [
('Member', 'status', [s.value
for s in MemberStatus.all_active()], 'in', None),
('Member', 'end_date', fmt_date(current_year_end()), '=', None)
]
members = get_members_for_query(query_clauses)
count = 0
for member in members:
region = get_region(member.address.country, member.address.post_code)
if region:
member.address.region = region
save_member(member)
count += 1
return '{} records processed'.format(count)
def update_member_season_ticket(rec):
# rec is line of payments file with keys dt id, afcw id
message = []
dt_id = rec['dt id'].strip()
afcw_id = rec['afcw id'].strip()
if len(afcw_id) > 0:
if dt_id[0] in ['D', 'J']:
number = int(dt_id[4:])
else:
number = int(dt_id)
season_ticket = int(afcw_id)
member = get_member(number)
if member:
member.season_ticket_id = season_ticket
message += ['Season ticket updated: {}'.format(season_ticket)]
save_member(member)
else:
message += ['Member not found: {}'.format(number)]
return message
def save_member(self, member_id):
member = {
'first_name': self.first_name.data,
'last_name': self.last_name.data,
'handicap': float(self.handicap.data or self.handicap_return.data),
'status': self.status.data,
'as_of': self.as_of.data,
'proposer_id': self.proposer.data,
'email': self.email.data,
'address': self.address.data,
'post_code': self.post_code.data,
'phone': self.phone.data,
'accepted': self.accepted_date.data,
'orig_name': self.name_return.data,
'orig_status': int(self.status_return.data),
'orig_handicap': float(self.handicap_return.data),
'access': self.access.data
}
save_member(member_id, member)
return True
def change_member_type_by_age():
message = []
message += ['standard to senior']
query_clauses = [
('Member', 'status', [s.value
for s in MemberStatus.all_active()], 'in', None),
('Member', 'member_type', MembershipType.standard, '=', None),
('Member', 'birth_date', 65, '>=', 'age()'),
]
members = get_members_for_query(query_clauses)
count_senior = 0
for member in members:
if member.member_type != MembershipType.senior:
message += [member.dt_number()] # member_type_change(member)
member.member_type = MembershipType.senior
count_senior += 1
save_member(member)
message += ['junior to intermediate']
query_clauses = [
('Member', 'status', [s.value
for s in MemberStatus.all_active()], 'in', None),
('Member', 'member_type', MembershipType.junior, '=', None),
('Member', 'birth_date', 16, '>', 'age()'),
]
members = get_members_for_query(query_clauses)
count_junior = 0
for member in members:
new = member.member_type_at_renewal()
if new == MembershipType.intermediate:
message += [member.dt_number()] # member_type_change(member)
member.member_type = MembershipType.intermediate
count_junior += 1
save_member(member)
message += ['Intermediates to standard']
query_clauses = [
('Member', 'status', [s.value
for s in MemberStatus.all_active()], 'in', None),
('Member', 'member_type', MembershipType.intermediate, '=', None),
('Member', 'birth_date', 20, '>', 'age()'),
]
members = get_members_for_query(query_clauses)
count_intermediate = 0
for member in members:
new = member.member_type_at_renewal()
if new == MembershipType.standard:
message += [member.dt_number()] # member_type_change(member)
member.member_type = MembershipType.standard
count_intermediate += 1
save_member(member)
totals = '{} senior records processed, {} junior, {} intermediate'.format(
count_senior, count_junior, count_intermediate)
return '\n'.join([totals] + message)
def update_member_payment(rec, payment_method, save=True):
# rec is line of payments file with keys id, date, amount and note
message = []
number = int(rec['id'][4:])
date = parse_date(rec['date'], sep='/', reverse=True)
amount = float(rec['amount'])
member = get_member(number)
pending = first_or_default([
p for p in member.payments
if p.type == PaymentType.pending and p.method == payment_method
], None)
payment_comment = 'from payments file'
if pending:
comment = ['']
if pending.amount != amount:
comment = [
"Expected amount {}, got {}".format(pending.amount, amount)
]
message += comment
pending.type = PaymentType.dues
pending.date = date
pending.amount = amount
pending.comment = payment_comment + ' ' + comment[0]
else:
dues = first_or_default([
p for p in member.payments
if p.type == PaymentType.dues and p.method == payment_method
], None)
if dues and dues.amount == amount and dues.date == date and dues.comment.startswith(
payment_comment):
message += ['Payment already processed']
return message
else:
message += ["no pending payment: adding one"]
pending = Payment(member_id=member.id,
date=date,
amount=amount,
type=PaymentType.dues,
method=payment_method,
comment=payment_comment)
member.payments.append(pending)
action = first_or_default([
a for a in member.actions
if a.action == MemberAction.card and a.status == ActionStatus.open
], None)
if not action:
action = Action(member_id=member.id,
date=datetime.date.today(),
action=MemberAction.card,
status=ActionStatus.open,
comment=payment_comment)
member.actions.append(action)
upgrade = amount in [20.0, 30.0, 45.0
] and member.status != MemberStatus.plus
action = first_or_default([
a for a in member.actions
if a.action == MemberAction.upgrade and a.status == ActionStatus.open
], None)
if action:
if upgrade:
member.status = MemberStatus.plus
action.status = ActionStatus.closed
# else:
# message += ['expected an upgrade payment, upgrade action removed']
# member.actions.remove(action)
else:
if upgrade:
action = Action(member_id=member.id,
date=date,
action=MemberAction.upgrade,
status=ActionStatus.closed,
comment=payment_comment)
member.actions.append(action)
member.end_date = new_end_date
member.last_payment_method = payment_method
if save:
save_member(member)
return message