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