def get(self, request): header = ['userid', 'companyname', 'country', 'contactname', 'contactemail', 'phone', 'phone2', 'phone3', 'fax'] rows = [] user_obligations = self.get_obligations() persons = ( Person.objects.filter(company__obligation__id__in=user_obligations) .all() ) for person in persons: org = person.company account = org.account if account is None: continue rows.append([v.encode('utf-8') if v else '' for v in [ account.uid, org.name, org.country.name, u"{p.title} {p.first_name} {p.family_name}".format(p=person), person.email, person.phone, person.phone2, person.phone3, person.fax, ]]) xls_doc = backend.generate_excel(header, rows) return HttpResponse(xls_doc, content_type="application/vnd.ms-excel")
def get(self, request): header = ['userid', 'name', 'date_registered', 'active', 'outdated', 'addr_street', 'addr_place1', 'addr_postalcode', 'addr_place2', 'country', 'vat_number', 'obligation'] rows = [] companies = self.get_companies() for company in companies: account = company.account rows.append([v.encode('utf-8') for v in [ '' if account is None else account.uid, company.name, company.date_registered.strftime('%Y-%m-%d %H:%M:%S'), 'on' if company.active else '', 'on' if company.outdated else '', company.addr_street, company.addr_place1, company.addr_postalcode, company.addr_place2, company.country.name, company.vat_number or '', company.obligation.code if company.obligation else '', ]]) xls_doc = backend.generate_excel(header, rows) return HttpResponse(xls_doc, content_type="application/vnd.ms-excel")