def create_or_update(site_name, oc_customer, doc_customer):
oc_addresses = oc_customer.get('addresses', {})
oc_address = {}
# gettting first address`
if isinstance(oc_addresses, list):
for addr in oc_addresses:
oc_address = addr
break
else:
for addr_id, addr in oc_addresses.items():
oc_address = addr
break
# no addresses found
if not oc_address:
return
if not oc_address.get('country'):
frappe.msgprint(
'Warning. Country is missed in Address of Customer %s %s' %
(doc_customer.get('name'), doc_customer.get('customer_name')))
return
countries.create_if_does_not_exist(oc_address.get('country'))
firstname = oc_address.get('firstname') or oc_customer.get(
'firstname') or ''
lastname = oc_address.get('lastname') or oc_customer.get('lastname') or ''
customer_name = firstname + ' ' + lastname
oc_address_id = oc_address.get('address_id')
# doc_address = get_address(site_name, oc_address_id)
address_type = 'Office' if oc_address.get('company') else 'Personal'
doc_address = get_address_by_customer(doc_customer.get('name'),
address_type)
if doc_address:
# update existed Address (Billing)
params = {
'address_type': address_type,
'customer': doc_customer.get('name'),
'phone': oc_customer.get('telephone', ''),
'fax': oc_customer.get('fax', ''),
'email_id': oc_customer.get('email', ''),
'customer_name': customer_name,
'pincode': oc_address.get('postcode', ''),
'country': oc_address.get('country', ''),
'state': oc_address.get('zone'),
'city': oc_address.get('city', 'not specified'),
'address_line1': oc_address.get('address_1', ''),
'address_line2': oc_address.get('address_2', ''),
'oc_address_id': oc_address_id
}
doc_address.update(params)
doc_address.save()
else:
# create new Address
params = {
'doctype': 'Address',
'address_type': address_type,
'customer': doc_customer.get('name'),
'phone': oc_customer.get('telephone', ''),
'fax': oc_customer.get('fax', ''),
'email_id': oc_customer.get('email', ''),
'customer_name': customer_name,
'pincode': oc_address.get('postcode', ''),
'country': oc_address.get('country', ''),
'state': oc_address.get('zone'),
'city': oc_address.get('city', 'not specified'),
'address_line1': oc_address.get('address_1', ''),
'address_line2': oc_address.get('address_2', ''),
'oc_site': site_name,
'oc_address_id': oc_address_id
}
doc_address = frappe.get_doc(params)
doc_address.insert(ignore_permissions=True)
# update Customer's name to Company name if needed
if oc_address.get('company') and (
oc_address.get('company') != doc_customer.get('customer_name')
or 'Company' != doc_customer.get('customer_type')):
doc_customer.update({
'oc_is_updating': 1,
'customer_type': 'Company',
'customer_name': oc_address.get('company')
})
doc_customer.save()
def create_or_update_from_order(site_name, doc_customer, oc_order):
# creating address from order payment
if not oc_order.get('shipping_country'):
frappe.msgprint('Warning. Country is missed in Address of Customer %s %s' % (doc_customer.get('name'), doc_customer.get('customer_name')))
return
# billing address
countries.create_if_does_not_exist(oc_order.get('payment_country'))
doc_address = get_address_by_customer(doc_customer.get('name'), 'Billing')
if doc_address:
# update existed Address
params = {
'address_type': 'Billing',
'is_primary_address': 1,
'is_shipping_address': 0,
'phone': oc_order.get('telephone', ''),
'fax': oc_order.get('fax', ''),
'email_id': oc_order.get('email', ''),
'customer_name': oc_order.get('payment_firstname', '') + ' ' + oc_order.get('payment_lastname', ''),
'pincode': oc_order.get('payment_postcode', ''),
'country': oc_order.get('payment_country', ''),
'state': oc_order.get('payment_zone'),
'city': oc_order.get('payment_city', ''),
'address_line1': oc_order.get('payment_address_1', ''),
'address_line2': oc_order.get('payment_address_2', '')
}
doc_address.update(params)
doc_address.save()
else:
# create new Address (Billing)
params = {
'doctype': 'Address',
'address_type': 'Billing',
'is_primary_address': 1,
'is_shipping_address': 0,
'customer': doc_customer.get('name'),
'phone': oc_order.get('telephone', ''),
'fax': oc_order.get('fax', ''),
'email_id': oc_order.get('email', ''),
'customer_name': oc_order.get('payment_firstname', '') + ' ' + oc_order.get('payment_lastname', ''),
'pincode': oc_order.get('payment_postcode', ''),
'country': oc_order.get('payment_country', ''),
'state': oc_order.get('payment_zone'),
'city': oc_order.get('payment_city', ''),
'address_line1': oc_order.get('payment_address_1', ''),
'address_line2': oc_order.get('payment_address_2', ''),
'oc_site': site_name,
}
doc_address = frappe.get_doc(params)
doc_address.autoname()
if frappe.db.get('Address', doc_address.get('name')):
doc_address = frappe.get_doc('Address', doc_address.get('name'))
doc_address.update(params)
doc_address.save()
else:
doc_address.insert(ignore_permissions=True)
# shipping address
countries.create_if_does_not_exist(oc_order.get('shipping_country'))
doc_address = get_address_by_customer(doc_customer.get('name'), 'Shipping')
if doc_address:
# update existed Address
params = {
'address_type': 'Shipping',
'is_primary_address': 0,
'is_shipping_address': 1,
'phone': oc_order.get('telephone', ''),
'fax': oc_order.get('fax', ''),
'email_id': oc_order.get('email', ''),
'customer_name': oc_order.get('shipping_firstname', '') + ' ' + oc_order.get('shipping_lastname', ''),
'pincode': oc_order.get('shipping_postcode', ''),
'country': oc_order.get('shipping_country', ''),
'state': oc_order.get('shipping_zone'),
'city': oc_order.get('shipping_city', ''),
'address_line1': oc_order.get('shipping_address_1', ''),
'address_line2': oc_order.get('shipping_address_2', '')
}
doc_address.update(params)
doc_address.save()
else:
# create new Address (Shipping)
params = {
'doctype': 'Address',
'address_type': 'Shipping',
'is_primary_address': 0,
'is_shipping_address': 1,
'customer': doc_customer.get('name'),
'phone': oc_order.get('telephone', ''),
'fax': oc_order.get('fax', ''),
'email_id': oc_order.get('email', ''),
'customer_name': oc_order.get('shipping_firstname', '') + ' ' + oc_order.get('shipping_lastname', ''),
'pincode': oc_order.get('shipping_postcode', ''),
'country': oc_order.get('shipping_country', ''),
'state': oc_order.get('shipping_zone'),
'city': oc_order.get('shipping_city', ''),
'address_line1': oc_order.get('shipping_address_1', ''),
'address_line2': oc_order.get('shipping_address_2', ''),
'oc_site': site_name,
}
doc_address = frappe.get_doc(params)
doc_address.autoname()
if frappe.db.get('Address', doc_address.get('name')):
doc_address = frappe.get_doc('Address', doc_address.get('name'))
doc_address.update(params)
doc_address.save()
else:
doc_address.insert(ignore_permissions=True)
def create_or_update_from_order(site_name, doc_customer, oc_order):
# creating address from order payment
if not oc_order.get('shipping_country'):
frappe.msgprint(
'Warning. Country is missed in Address of Customer %s %s' %
(doc_customer.get('name'), doc_customer.get('customer_name')))
return
# billing address
countries.create_if_does_not_exist(oc_order.get('payment_country'))
doc_address = get_address_by_customer(doc_customer.get('name'), 'Billing')
if doc_address:
# update existed Address
params = {
'address_type':
'Billing',
'is_primary_address':
1,
'is_shipping_address':
0,
'phone':
oc_order.get('telephone', ''),
'fax':
oc_order.get('fax', ''),
'email_id':
oc_order.get('email', ''),
'customer_name':
oc_order.get('payment_firstname', '') + ' ' +
oc_order.get('payment_lastname', ''),
'pincode':
oc_order.get('payment_postcode', ''),
'country':
oc_order.get('payment_country', ''),
'state':
oc_order.get('payment_zone'),
'city':
oc_order.get('payment_city', ''),
'address_line1':
oc_order.get('payment_address_1', ''),
'address_line2':
oc_order.get('payment_address_2', '')
}
doc_address.update(params)
doc_address.save()
else:
# create new Address (Billing)
params = {
'doctype':
'Address',
'address_type':
'Billing',
'is_primary_address':
1,
'is_shipping_address':
0,
'customer':
doc_customer.get('name'),
'phone':
oc_order.get('telephone', ''),
'fax':
oc_order.get('fax', ''),
'email_id':
oc_order.get('email', ''),
'customer_name':
oc_order.get('payment_firstname', '') + ' ' +
oc_order.get('payment_lastname', ''),
'pincode':
oc_order.get('payment_postcode', ''),
'country':
oc_order.get('payment_country', ''),
'state':
oc_order.get('payment_zone'),
'city':
oc_order.get('payment_city', ''),
'address_line1':
oc_order.get('payment_address_1', ''),
'address_line2':
oc_order.get('payment_address_2', ''),
'oc_site':
site_name,
}
doc_address = frappe.get_doc(params)
doc_address.autoname()
if frappe.db.get('Address', doc_address.get('name')):
doc_address = frappe.get_doc('Address', doc_address.get('name'))
doc_address.update(params)
doc_address.save()
else:
doc_address.insert(ignore_permissions=True)
# shipping address
countries.create_if_does_not_exist(oc_order.get('shipping_country'))
doc_address = get_address_by_customer(doc_customer.get('name'), 'Shipping')
if doc_address:
# update existed Address
params = {
'address_type':
'Shipping',
'is_primary_address':
0,
'is_shipping_address':
1,
'phone':
oc_order.get('telephone', ''),
'fax':
oc_order.get('fax', ''),
'email_id':
oc_order.get('email', ''),
'customer_name':
oc_order.get('shipping_firstname', '') + ' ' +
oc_order.get('shipping_lastname', ''),
'pincode':
oc_order.get('shipping_postcode', ''),
'country':
oc_order.get('shipping_country', ''),
'state':
oc_order.get('shipping_zone'),
'city':
oc_order.get('shipping_city', ''),
'address_line1':
oc_order.get('shipping_address_1', ''),
'address_line2':
oc_order.get('shipping_address_2', '')
}
doc_address.update(params)
doc_address.save()
else:
# create new Address (Shipping)
params = {
'doctype':
'Address',
'address_type':
'Shipping',
'is_primary_address':
0,
'is_shipping_address':
1,
'customer':
doc_customer.get('name'),
'phone':
oc_order.get('telephone', ''),
'fax':
oc_order.get('fax', ''),
'email_id':
oc_order.get('email', ''),
'customer_name':
oc_order.get('shipping_firstname', '') + ' ' +
oc_order.get('shipping_lastname', ''),
'pincode':
oc_order.get('shipping_postcode', ''),
'country':
oc_order.get('shipping_country', ''),
'state':
oc_order.get('shipping_zone'),
'city':
oc_order.get('shipping_city', ''),
'address_line1':
oc_order.get('shipping_address_1', ''),
'address_line2':
oc_order.get('shipping_address_2', ''),
'oc_site':
site_name,
}
doc_address = frappe.get_doc(params)
doc_address.autoname()
if frappe.db.get('Address', doc_address.get('name')):
doc_address = frappe.get_doc('Address', doc_address.get('name'))
doc_address.update(params)
doc_address.save()
else:
doc_address.insert(ignore_permissions=True)
def create_or_update(site_name, oc_customer, doc_customer):
oc_addresses = oc_customer.get('addresses', {})
oc_address = {}
# gettting first address`
if isinstance(oc_addresses, list):
for addr in oc_addresses:
oc_address = addr
break
else:
for addr_id, addr in oc_addresses.items():
oc_address = addr
break
# no addresses found
if not oc_address:
return
if not oc_address.get('country'):
frappe.msgprint('Warning. Country is missed in Address of Customer %s %s' % (doc_customer.get('name'), doc_customer.get('customer_name')))
return
countries.create_if_does_not_exist(oc_address.get('country'))
firstname = oc_address.get('firstname') or oc_customer.get('firstname') or ''
lastname = oc_address.get('lastname') or oc_customer.get('lastname') or ''
customer_name = firstname + ' ' + lastname
oc_address_id = oc_address.get('address_id')
# doc_address = get_address(site_name, oc_address_id)
address_type = 'Office' if oc_address.get('company') else 'Personal'
doc_address = get_address_by_customer(doc_customer.get('name'), address_type)
if doc_address:
# update existed Address (Billing)
params = {
'address_type': address_type,
'customer': doc_customer.get('name'),
'phone': oc_customer.get('telephone', ''),
'fax': oc_customer.get('fax', ''),
'email_id': oc_customer.get('email', ''),
'customer_name': customer_name,
'pincode': oc_address.get('postcode', ''),
'country': oc_address.get('country', ''),
'state': oc_address.get('zone'),
'city': oc_address.get('city', 'not specified'),
'address_line1': oc_address.get('address_1', ''),
'address_line2': oc_address.get('address_2', ''),
'oc_address_id': oc_address_id
}
doc_address.update(params)
doc_address.save()
else:
# create new Address
params = {
'doctype': 'Address',
'address_type': address_type,
'customer': doc_customer.get('name'),
'phone': oc_customer.get('telephone', ''),
'fax': oc_customer.get('fax', ''),
'email_id': oc_customer.get('email', ''),
'customer_name': customer_name,
'pincode': oc_address.get('postcode', ''),
'country': oc_address.get('country', ''),
'state': oc_address.get('zone'),
'city': oc_address.get('city', 'not specified'),
'address_line1': oc_address.get('address_1', ''),
'address_line2': oc_address.get('address_2', ''),
'oc_site': site_name,
'oc_address_id': oc_address_id
}
doc_address = frappe.get_doc(params)
doc_address.insert(ignore_permissions=True)
# update Customer's name to Company name if needed
if oc_address.get('company') and (oc_address.get('company') != doc_customer.get('customer_name') or 'Company' != doc_customer.get('customer_type')):
doc_customer.update({
'oc_is_updating': 1,
'customer_type': 'Company',
'customer_name': oc_address.get('company')
})
doc_customer.save()