def extract_certificates(page, type):
# new member packs, type is std/plus/junior
if type == "std":
sel = [('Member', 'status', MemberStatus.plus, '!=', None),
('Member', 'member_type', MembershipType.junior.value, '!=',
None)]
if type == "plus":
sel = [('Member', 'status', MemberStatus.plus, '=', None),
('Member', 'member_type', MembershipType.junior.value, '!=',
None)]
if type == "junior":
sel = [
('Member', 'member_type', MembershipType.junior, '=', None),
]
query_clauses = sel + [
('Member', 'status', [s.value for s in MemberStatus.all_active()
], 'in', None),
('Action', 'status', ActionStatus.open.value, '=', None),
('Action', 'action',
[a.value for a in MemberAction.send_certificates()], 'in', None)
]
display_fields = [
'number', 'status', 'member type', 'full name', 'address (line 1)',
'address (line 2)', 'address (line 3)', 'city', 'county', 'state',
'post code', 'country for post', 'fan id', 'certificate date',
'upgrade', 'comment', 'card start year', 'first name', 'last name'
]
return Query.show_found_do(query_clauses,
display_fields,
action='cert_' + type,
page=page)
def extract_email_junior():
query_clauses = [
('Member', 'member_type', MembershipType.junior.value, '=', None),
('Member', 'status', [s.value for s in MemberStatus.all_active()
], 'in', None),
('Member', 'comms', CommsType.email.value, '=', None),
('Member', 'comms_status', CommsStatus.all_ok.value, '=', None)
]
display_fields = ['number', 'first name', 'email', 'junior email']
return Query.show_found_do(query_clauses, display_fields)
def list_actions(action, page):
if action.startswith('cert_'):
return Extracts.extract_certificates(page, action[5:])
if action == 'card':
return Extracts.extract_cards(page)
if action == 'other':
return Extracts.extract_other_actions(page)
if action == 'renewal':
return Extracts.extract_pending_renewals(page)
if action == 'query':
return Query.show_found()
def extract_cards_all():
# annual replacement cards for printers
query_clauses = [
('Member', 'status',
[s.value
for s in MemberStatus.all_active_including_life()], 'in', None)
]
display_fields = [
'status at renewal', 'type at renewal', 'number at renewal',
'full name', 'card start year', 'fan id'
]
return Query.show_found_do(query_clauses, display_fields)
def extract_renewals():
# for renewal notices at membership year end
end_date = fmt_date(current_year_end())
query_clauses = [('Member', 'end_date', end_date, '=', None),
('Member', 'status',
[s.value
for s in MemberStatus.all_active()], 'in', None)]
display_fields = \
['number', 'id number', 'full name', 'address (line 1)', 'address (line 2)', 'address (line 3)',
'city', 'county', 'state', 'post code', 'country for post', 'fan id', 'status', 'member type',
'type at renewal', 'email', 'comms', 'payment method', 'renewal notes', 'home phone', 'mobile phone',
'birth date', 'junior email', 'AFCW access', '3rd pty access', 'recent new', 'recent resume']
return Query.show_found_do(query_clauses, display_fields)
def extract_juniors():
query_clauses = [
('Member', 'member_type', MembershipType.junior.value, '=', None),
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None)
]
display_fields = [
'number', 'status', 'full name', 'address (line 1)',
'address (line 2)', 'address (line 3)', 'city', 'county', 'state',
'post code', 'country for post', 'dues', 'age', 'use email',
'email', 'email bounced', 'junior email', 'first name', 'last name'
]
return Query.show_found_do(query_clauses, display_fields)
def extract_comms():
query_clauses = [('Member', 'status',
[s.value
for s in MemberStatus.all_active()], 'in', None)]
display_fields = [
'number', 'full name', 'member type', 'use email', 'email',
'mobile phone', 'home phone', 'address (line 1)',
'address (line 2)', 'address (line 3)', 'city', 'county', 'state',
'post code', 'country for post', 'voter', 'AFCW access',
'first name', 'last name', 'status', 'end'
]
return Query.show_found_do(query_clauses,
display_fields,
action='query')
def extract_for_afcw():
query_clauses = [('Member', 'status',
[s.value
for s in MemberStatus.all_active()], 'in', None)]
display_fields = [
'number', 'title', 'first name', 'last name', 'sex', 'status',
'member type', 'start', 'end', 'birth date', 'email', 'home phone',
'mobile phone', 'comms', 'payment method', 'address (line 1)',
'address (line 2)', 'address (line 3)', 'city', 'county', 'state',
'post code', 'country code', 'use email', 'fan id', 'AFCW access',
'last updated'
]
return Query.show_found_do(query_clauses,
display_fields,
action='query')
def extract_debits():
end_date = fmt_date(current_year_end())
query_clauses = [
('Member', 'end_date', end_date, '=', None),
('Member', 'last_payment_method',
[PaymentMethod.dd.value,
PaymentMethod.dd_pending.value], 'in', None),
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None)
]
display_fields = \
['number', 'type at renewal', 'full name', 'dues pending', 'email', 'phone',
'address (line 1)', 'address (line 2)', 'address (line 3)', 'city', 'county', 'state', 'post code',
'country for post', 'title', 'first name', 'last name']
return Query.show_found_do(query_clauses, display_fields)
def extract_other_actions(page):
# other actions
query_clauses = [
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None),
('Action', 'action', [a.value for a in MemberAction.send_other()],
'in', None),
('Action', 'status', ActionStatus.open.value, '=', None)
]
display_fields = [
'number', 'member type', 'full name', 'action', 'action date',
'action comment'
]
return Query.show_found_do(query_clauses,
display_fields,
action='other',
page=page)
def extract_pending_renewals(page):
# pending renewals
query_clauses = [
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None),
('Payment', 'type', PaymentType.pending.value, '=', None)
]
display_fields = [
'number', 'member type', 'full name', 'use email', 'email',
'action', 'action date', 'action comment', 'last payment date',
'last payment amount', 'last payment type', 'payment type',
'last payment method', 'last payment comment', 'end'
]
return Query.show_found_do(query_clauses,
display_fields,
action='renewal',
payment='pending',
page=page)
def extract_junior_birthdays(month=None):
today = datetime.date.today()
if not month:
month = today.month % 12 + 1 # next month
query_clauses = [
('Member', 'member_type', MembershipType.junior.value, '=', None),
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None),
('Member', 'birth_date', month, '=', 'birth_month()'),
# ('Member', 'age_next_birthday', 16, '<', None)
]
display_fields = [
'number', 'full name', 'address (line 1)', 'address (line 2)',
'address (line 3)', 'city', 'county', 'state', 'post code',
'country for post', 'use email', 'email', 'junior email',
'home phone', 'mobile phone', 'birth date', 'age next bday',
'first name', 'last name'
]
return Query.show_found_do(query_clauses, display_fields)
def extract_cards(page):
# renewal acknowledgement
query_clauses = [
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None),
('Action', 'status', ActionStatus.open.value, '=', None),
('Action', 'action', [a.value for a in MemberAction.send_cards()],
'in', None)
]
display_fields = [
'number', 'status', 'member type', 'full name', 'address (line 1)',
'address (line 2)', 'address (line 3)', 'city', 'county', 'state',
'post code', 'country for post', 'fan id', 'recent new',
'recent resume', 'email', 'use email', 'email bounced',
'card start year', 'first name', 'last name'
]
return Query.show_found_do(query_clauses,
display_fields,
action='card',
page=page)
def extract_debits_for_ptx():
end_date = fmt_date(current_year_end())
query_clauses = [
('Member', 'end_date', end_date, '=', None),
('Member', 'last_payment_method',
[PaymentMethod.dd.value,
PaymentMethod.dd_pending.value], 'in', None),
('Member', 'status', [s.value for s in MemberStatus.all_active()],
'in', None)
]
display_fields = [(None, 'Contact Reference'),
('fmt id number', 'Mandate Reference'),
(None, 'Mandate Status'), ('title for ptx', 'Title'),
('first name', 'First Name'),
('last name', 'Last Name'), (None, 'Company'),
('address (line 1)', 'Street1'),
('address (line 2)', 'Street2'),
('address (line 3)', 'Street3'), ('city', 'City'),
('post code', 'Post Code'), ('county', 'County'),
('country for post', 'Country'),
('phone', 'Telephone'), ('email', 'Email'),
('number at renewal', 'Alternative Reference'),
(None, 'Account Name'), (None, 'Sort Code'),
(None, 'Account Number'), (None, 'Plan Index'),
(None, 'Frequency Type', '{YEARLY}'),
(None, 'Start Date', '{2021-08-11}'),
(None, 'End Date'), (None, 'Number of Occurrences'),
(None, 'Recurrence'),
(None, 'Frequency Details1', '{DAY11}'),
(None, 'Frequency Details2', '{AUGUST}'),
('fmt dues pending', 'Regular Amount'),
(None, 'First Amount'), (None, 'Last Amount'),
(None, 'Total Amount'),
('extended type at renewal', 'Comments'),
(None, 'Profile Name'),
('comms for ptx', 'Communication Preference')]
return Query.show_found_do(query_clauses, display_fields)
def clear_actions(query_clauses):
Query.reset_member_actions(query_clauses)
def extracts_bulk_update():
return Query.bulk_update()
def extracts_extract():
return return_csv_file(Query.extract(), 'extract.csv')
def extracts_show():
return Query.show_found()
def extracts_custom():
return Query.select(title='Custom extract')
