def filters(request):
now = timezone.now()
members = MemberDao.members_with_assignments_count()
renderdict = get_menu_dict(request)
renderdict.update({
'members': members
})
return render(request, 'members.html', renderdict)
def excel_export_members_filter(request):
response = HttpResponse(
content_type=
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
response['Content-Disposition'] = 'attachment; filename=Report.xlsx'
output = BytesIO()
workbook = Workbook(output)
worksheet_s = workbook.add_worksheet(Config.vocabulary('member_pl'))
worksheet_s.write_string(0, 0, str(_('Name')))
worksheet_s.write_string(0, 1, str(Config.vocabulary('assignment')))
worksheet_s.write_string(
0, 2, str(Config.vocabulary('assignment') + ' ' + _('Kernbereich')))
worksheet_s.write_string(0, 3, str(_('Taetigkeitsbereiche')))
worksheet_s.write_string(0, 4, str(_('Depot')))
worksheet_s.write_string(0, 5, str(_('Email')))
worksheet_s.write_string(0, 6, str(_('Telefon')))
worksheet_s.write_string(0, 7, str(_('Mobile')))
members = MemberDao.members_with_assignments_count()
row = 1
for member in members:
member.all_areas = ''
for area in member.areas.all():
member.all_areas = member.all_areas + area.name + ' '
if member.all_areas == '':
member.all_areas = str(_('-Kein Tätigkeitsbereich-'))
member.depot_name = str(_('Kein Depot definiert'))
if member.subscription_current is not None:
member.depot_name = member.subscription_current.depot.name
full_name = member.first_name + ' ' + member.last_name
worksheet_s.write_string(row, 0, full_name)
worksheet_s.write(row, 1, member.assignment_count)
worksheet_s.write(row, 2, member.core_assignment_count)
worksheet_s.write_string(row, 3, member.all_areas)
worksheet_s.write_string(row, 4, member.depot_name)
worksheet_s.write_string(row, 5, member.email)
worksheet_s.write_string(row, 6, member.phone)
if member.mobile_phone is not None:
worksheet_s.write_string(row, 7, member.mobile_phone)
row += 1
workbook.close()
xlsx_data = output.getvalue()
response.write(xlsx_data)
return response
def excel_export_members_filter(request):
response = HttpResponse(content_type='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename=Report.xlsx'
output = StringIO()
workbook = xlsxwriter.Workbook(output)
worksheet_s = workbook.add_worksheet(Config.members_string())
worksheet_s.write_string(0, 0, str('Name', 'utf-8'))
worksheet_s.write_string(0, 1, str(Config.assignments_string(), 'utf-8'))
worksheet_s.write_string(0, 2, str(Config.assignments_string() + ' Kernbereich', 'utf-8'))
worksheet_s.write_string(0, 3, str('Taetigkeitsbereiche', 'utf-8'))
worksheet_s.write_string(0, 4, str('Depot', 'utf-8'))
worksheet_s.write_string(0, 5, str('Email', 'utf-8'))
worksheet_s.write_string(0, 6, str('Telefon', 'utf-8'))
worksheet_s.write_string(0, 7, str('Mobile', 'utf-8'))
now = timezone.now()
members = MemberDao.members_with_assignments_count()
row = 1
for member in members:
member.all_areas = ''
for area in member.areas.all():
member.all_areas = member.all_areas + area.name + ' '
if member.all_areas == '':
member.all_areas = str('-Kein Tätigkeitsbereich-', 'utf-8')
member.depot_name = str('Kein Depot definiert', 'utf-8')
if member.subscription is not None:
member.depot_name = member.subscription.depot.name
looco_full_name = member.first_name + ' ' + member.last_name
worksheet_s.write_string(row, 0, looco_full_name)
worksheet_s.write(row, 1, member.assignment_count)
worksheet_s.write(row, 2, member.core_assignment_count)
worksheet_s.write_string(row, 3, member.all_areas)
worksheet_s.write_string(row, 4, member.depot_name)
worksheet_s.write_string(row, 5, member.email)
worksheet_s.write_string(row, 6, member.phone)
if member.mobile_phone is not None:
worksheet_s.write_string(row, 7, member.mobile_phone)
row += 1
workbook.close()
xlsx_data = output.getvalue()
response.write(xlsx_data)
return response
