How to get Company Address in HTML Template?

JoEz · May 19, 2017, 3:21pm

Hi there,

i’m trying to get company address from html template, any hint?

Thx

JoEz · May 19, 2017, 5:07pm

Anyone has the same prob?

Mohammed_Redha · May 19, 2017, 5:15pm

Do you mean this?

please elaborate.

JoEz · May 19, 2017, 5:20pm

@Mohammed_Redha Yup …it is changed in version 8 …now the field is address_html and display addresses from Address DocType …it seems kind of complicated to retrieve Company address …

i’ve tried to use:

github.com

frappe/frappe/blob/30c0f625ab77a82df08815c3f980d4cac1eb98bd/frappe/geo/doctype/address/address.py#L173


      
          	if not result:
          		result = frappe.db.get_value("Address Template", \
          			{"is_default": 1}, ["name", "template"])
          
          
	if not result:
          		frappe.throw(_("No default Address Template found. Please create a new one from Setup > Printing and Branding > Address Template."))
          	else:
          		return result
          
          
@frappe.whitelist()
          def get_shipping_address(company):
          	filters = [
          		["Dynamic Link", "link_doctype", "=", "Company"],
          		["Dynamic Link", "link_name", "=", company],
          		["Address", "is_your_company_address", "=", 1]
          	]
          	fields = ["name", "address_line1", "address_line2", "city", "state", "country"]
          	address = frappe.get_all("Address", filters=filters, fields=fields) or {}
          
          
	if address:
          		address_as_dict = address[0]

But getting an error:

("'dict object' has no attribute 'geo'",)

JoEz · May 19, 2017, 8:30pm

Can someone help on this? It’s really frustrating …

lasalesi · February 18, 2018, 8:06pm

Hi @JoEz,

I know this is far from pretty but it worked for me:

{% set links = frappe.get_all('Dynamic Link', filters={'link_doctype': 'Company', 'link_name': doc.company, 'parenttype': 'Address'}, fields=['parent']) %}
{% if links %}
{% set address = frappe.get_doc("Address", links[0].parent) %}
{% endif %}

Playing with the filters helps if there are multiple addresses. Hope it helps…

pratikcws · April 16, 2019, 2:37am

{% set links = frappe.get_all(‘Dynamic Link’, filters={‘link_doctype’: ‘Company’, ‘link_name’: doc.company, ‘parenttype’: ‘Address’}, fields=[‘parent’]) %}
{% if links %}
{{frappe.db.get_value(“Address”, links[0].parent, “address_line1”)}}
{% endif %}

its working

Gavin_Ji · July 12, 2019, 4:44am