def build_invoice(invoice: Invoice) -> Invoice: lp = invoice.order.payments.last() with language(invoice.locale): invoice.invoice_from = invoice.event.settings.get( 'invoice_address_from') invoice.invoice_from_name = invoice.event.settings.get( 'invoice_address_from_name') invoice.invoice_from_zipcode = invoice.event.settings.get( 'invoice_address_from_zipcode') invoice.invoice_from_city = invoice.event.settings.get( 'invoice_address_from_city') invoice.invoice_from_country = invoice.event.settings.get( 'invoice_address_from_country') invoice.invoice_from_tax_id = invoice.event.settings.get( 'invoice_address_from_tax_id') invoice.invoice_from_vat_id = invoice.event.settings.get( 'invoice_address_from_vat_id') introductory = invoice.event.settings.get('invoice_introductory_text', as_type=LazyI18nString) additional = invoice.event.settings.get('invoice_additional_text', as_type=LazyI18nString) footer = invoice.event.settings.get('invoice_footer_text', as_type=LazyI18nString) if lp and lp.payment_provider: if 'payment' in inspect.signature( lp.payment_provider.render_invoice_text).parameters: payment = lp.payment_provider.render_invoice_text( invoice.order, lp) else: payment = lp.payment_provider.render_invoice_text( invoice.order) else: payment = "" invoice.introductory_text = str(introductory).replace('\n', '<br />') invoice.additional_text = str(additional).replace('\n', '<br />') invoice.footer_text = str(footer) invoice.payment_provider_text = str(payment).replace('\n', '<br />') try: ia = invoice.order.invoice_address addr_template = pgettext( "invoice", """{i.company} {i.name} {i.street} {i.zipcode} {i.city} {state} {country}""") invoice.invoice_to = "\n".join( a.strip() for a in addr_template.format( i=ia, country=ia.country.name if ia.country else ia.country_old, state=ia.state_for_address).split("\n") if a.strip()) invoice.internal_reference = ia.internal_reference invoice.invoice_to_company = ia.company invoice.invoice_to_name = ia.name invoice.invoice_to_street = ia.street invoice.invoice_to_zipcode = ia.zipcode invoice.invoice_to_city = ia.city invoice.invoice_to_country = ia.country invoice.invoice_to_state = ia.state invoice.invoice_to_beneficiary = ia.beneficiary if ia.vat_id: invoice.invoice_to += "\n" + pgettext("invoice", "VAT-ID: %s") % ia.vat_id invoice.invoice_to_vat_id = ia.vat_id cc = str(ia.country) if cc in EU_CURRENCIES and EU_CURRENCIES[ cc] != invoice.event.currency: invoice.foreign_currency_display = EU_CURRENCIES[cc] if settings.FETCH_ECB_RATES: gs = GlobalSettingsObject() rates_date = gs.settings.get('ecb_rates_date', as_type=date) rates_dict = gs.settings.get('ecb_rates_dict', as_type=dict) convert = (rates_date and rates_dict and rates_date > (now() - timedelta(days=7)).date() and invoice.event.currency in rates_dict and invoice.foreign_currency_display in rates_dict) if convert: invoice.foreign_currency_rate = ( Decimal( rates_dict[invoice.foreign_currency_display]) / Decimal( rates_dict[invoice.event.currency])).quantize( Decimal('0.0001'), ROUND_HALF_UP) invoice.foreign_currency_rate_date = rates_date except InvoiceAddress.DoesNotExist: ia = None invoice.invoice_to = "" invoice.file = None invoice.save() invoice.lines.all().delete() positions = list( invoice.order.positions.select_related( 'addon_to', 'item', 'tax_rule', 'subevent', 'variation').annotate( addon_c=Count('addons')).prefetch_related( 'answers', 'answers__question').order_by('positionid', 'id')) reverse_charge = False positions.sort(key=lambda p: p.sort_key) for i, p in enumerate(positions): if not invoice.event.settings.invoice_include_free and p.price == Decimal( '0.00') and not p.addon_c: continue desc = str(p.item.name) if p.variation: desc += " - " + str(p.variation.value) if p.addon_to_id: desc = " + " + desc if invoice.event.settings.invoice_attendee_name and p.attendee_name: desc += "<br />" + pgettext( "invoice", "Attendee: {name}").format(name=p.attendee_name) for answ in p.answers.all(): if not answ.question.print_on_invoice: continue desc += "<br />{}{} {}".format( answ.question.question, "" if str(answ.question.question).endswith("?") else ":", str(answ)) if invoice.event.has_subevents: desc += "<br />" + pgettext("subevent", "Date: {}").format( p.subevent) InvoiceLine.objects.create( position=i, invoice=invoice, description=desc, gross_value=p.price, tax_value=p.tax_value, subevent=p.subevent, event_date_from=(p.subevent.date_from if p.subevent else invoice.event.date_from), tax_rate=p.tax_rate, tax_name=p.tax_rule.name if p.tax_rule else '') if p.tax_rule and p.tax_rule.is_reverse_charge( ia) and p.price and not p.tax_value: reverse_charge = True if reverse_charge: if invoice.additional_text: invoice.additional_text += "<br /><br />" invoice.additional_text += pgettext( "invoice", "Reverse Charge: According to Article 194, 196 of Council Directive 2006/112/EEC, VAT liability " "rests with the service recipient.") invoice.reverse_charge = True invoice.save() offset = len(positions) for i, fee in enumerate(invoice.order.fees.all()): fee_title = _(fee.get_fee_type_display()) if fee.description: fee_title += " - " + fee.description InvoiceLine.objects.create( position=i + offset, invoice=invoice, description=fee_title, gross_value=fee.value, tax_value=fee.tax_value, tax_rate=fee.tax_rate, tax_name=fee.tax_rule.name if fee.tax_rule else '') return invoice
def build_invoice(invoice: Invoice) -> Invoice: invoice.locale = invoice.event.settings.get('invoice_language', invoice.event.settings.locale) if invoice.locale == '__user__': invoice.locale = invoice.order.locale or invoice.event.settings.locale lp = invoice.order.payments.last() with language(invoice.locale, invoice.event.settings.region): invoice.invoice_from = invoice.event.settings.get( 'invoice_address_from') invoice.invoice_from_name = invoice.event.settings.get( 'invoice_address_from_name') invoice.invoice_from_zipcode = invoice.event.settings.get( 'invoice_address_from_zipcode') invoice.invoice_from_city = invoice.event.settings.get( 'invoice_address_from_city') invoice.invoice_from_country = invoice.event.settings.get( 'invoice_address_from_country') invoice.invoice_from_tax_id = invoice.event.settings.get( 'invoice_address_from_tax_id') invoice.invoice_from_vat_id = invoice.event.settings.get( 'invoice_address_from_vat_id') introductory = invoice.event.settings.get('invoice_introductory_text', as_type=LazyI18nString) additional = invoice.event.settings.get('invoice_additional_text', as_type=LazyI18nString) footer = invoice.event.settings.get('invoice_footer_text', as_type=LazyI18nString) if lp and lp.payment_provider: if 'payment' in inspect.signature( lp.payment_provider.render_invoice_text).parameters: payment = str( lp.payment_provider.render_invoice_text(invoice.order, lp)) else: payment = str( lp.payment_provider.render_invoice_text(invoice.order)) else: payment = "" if invoice.event.settings.invoice_include_expire_date and invoice.order.status == Order.STATUS_PENDING: if payment: payment += "<br />" payment += pgettext( "invoice", "Please complete your payment before {expire_date}.").format( expire_date=date_format(invoice.order.expires, "SHORT_DATE_FORMAT")) invoice.introductory_text = str(introductory).replace('\n', '<br />') invoice.additional_text = str(additional).replace('\n', '<br />') invoice.footer_text = str(footer) invoice.payment_provider_text = str(payment).replace('\n', '<br />') try: ia = invoice.order.invoice_address addr_template = pgettext( "invoice", """{i.company} {i.name} {i.street} {i.zipcode} {i.city} {state} {country}""") invoice.invoice_to = "\n".join( a.strip() for a in addr_template.format( i=ia, country=ia.country.name if ia.country else ia.country_old, state=ia.state_for_address).split("\n") if a.strip()) invoice.internal_reference = ia.internal_reference invoice.custom_field = ia.custom_field invoice.invoice_to_company = ia.company invoice.invoice_to_name = ia.name invoice.invoice_to_street = ia.street invoice.invoice_to_zipcode = ia.zipcode invoice.invoice_to_city = ia.city invoice.invoice_to_country = ia.country invoice.invoice_to_state = ia.state invoice.invoice_to_beneficiary = ia.beneficiary if ia.vat_id: invoice.invoice_to += "\n" + pgettext("invoice", "VAT-ID: %s") % ia.vat_id invoice.invoice_to_vat_id = ia.vat_id cc = str(ia.country) if cc in EU_CURRENCIES and EU_CURRENCIES[ cc] != invoice.event.currency and invoice.event.settings.invoice_eu_currencies: invoice.foreign_currency_display = EU_CURRENCIES[cc] if settings.FETCH_ECB_RATES: gs = GlobalSettingsObject() rates_date = gs.settings.get('ecb_rates_date', as_type=date) rates_dict = gs.settings.get('ecb_rates_dict', as_type=dict) convert = (rates_date and rates_dict and rates_date > (now() - timedelta(days=7)).date() and invoice.event.currency in rates_dict and invoice.foreign_currency_display in rates_dict) if convert: invoice.foreign_currency_rate = ( Decimal( rates_dict[invoice.foreign_currency_display]) / Decimal( rates_dict[invoice.event.currency])).quantize( Decimal('0.0001'), ROUND_HALF_UP) invoice.foreign_currency_rate_date = rates_date except InvoiceAddress.DoesNotExist: ia = None invoice.invoice_to = "" invoice.file = None invoice.save() invoice.lines.all().delete() positions = list( invoice.order.positions.select_related( 'addon_to', 'item', 'tax_rule', 'subevent', 'variation').annotate( addon_c=Count('addons')).prefetch_related( 'answers', 'answers__question').order_by('positionid', 'id')) reverse_charge = False positions.sort(key=lambda p: p.sort_key) tax_texts = [] for i, p in enumerate(positions): if not invoice.event.settings.invoice_include_free and p.price == Decimal( '0.00') and not p.addon_c: continue desc = str(p.item.name) if p.variation: desc += " - " + str(p.variation.value) if p.addon_to_id: desc = " + " + desc if invoice.event.settings.invoice_attendee_name and p.attendee_name: desc += "<br />" + pgettext( "invoice", "Attendee: {name}").format(name=p.attendee_name) for recv, resp in invoice_line_text.send(sender=invoice.event, position=p): if resp: desc += "<br/>" + resp for answ in p.answers.all(): if not answ.question.print_on_invoice: continue desc += "<br />{}{} {}".format( answ.question.question, "" if str(answ.question.question).endswith("?") else ":", str(answ)) if invoice.event.has_subevents: desc += "<br />" + pgettext("subevent", "Date: {}").format( p.subevent) InvoiceLine.objects.create( position=i, invoice=invoice, description=desc, gross_value=p.price, tax_value=p.tax_value, subevent=p.subevent, item=p.item, variation=p.variation, attendee_name=p.attendee_name if invoice.event.settings.invoice_attendee_name else None, event_date_from=p.subevent.date_from if invoice.event.has_subevents else invoice.event.date_from, event_date_to=p.subevent.date_to if invoice.event.has_subevents else invoice.event.date_to, tax_rate=p.tax_rate, tax_name=p.tax_rule.name if p.tax_rule else '') if p.tax_rule and p.tax_rule.is_reverse_charge( ia) and p.price and not p.tax_value: reverse_charge = True if p.tax_rule: tax_text = p.tax_rule.invoice_text(ia) if tax_text and tax_text not in tax_texts: tax_texts.append(tax_text) offset = len(positions) for i, fee in enumerate(invoice.order.fees.all()): if fee.fee_type == OrderFee.FEE_TYPE_OTHER and fee.description: fee_title = fee.description else: fee_title = _(fee.get_fee_type_display()) if fee.description: fee_title += " - " + fee.description InvoiceLine.objects.create( position=i + offset, invoice=invoice, description=fee_title, gross_value=fee.value, event_date_from=None if invoice.event.has_subevents else invoice.event.date_from, event_date_to=None if invoice.event.has_subevents else invoice.event.date_to, tax_value=fee.tax_value, tax_rate=fee.tax_rate, tax_name=fee.tax_rule.name if fee.tax_rule else '') if fee.tax_rule and fee.tax_rule.is_reverse_charge( ia) and fee.value and not fee.tax_value: reverse_charge = True if fee.tax_rule: tax_text = fee.tax_rule.invoice_text(ia) if tax_text and tax_text not in tax_texts: tax_texts.append(tax_text) if tax_texts: invoice.additional_text += "<br /><br />" invoice.additional_text += "<br />".join(tax_texts) invoice.reverse_charge = reverse_charge invoice.save() return invoice