def create_lead_address_contact(self):
if self.doc.lead_name:
details = sql("select name, lead_name, address_line1, address_line2, city, country, state, pincode, phone, mobile_no, fax, email_id from `tabLead` where name = '%s'" %(self.doc.lead_name), as_dict = 1)
d = Document('Address')
d.address_line1 = details[0]['address_line1']
d.address_line2 = details[0]['address_line2']
d.city = details[0]['city']
d.country = details[0]['country']
d.pincode = details[0]['pincode']
d.state = details[0]['state']
d.fax = details[0]['fax']
d.email_id = details[0]['email_id']
d.phone = details[0]['phone']
d.customer = self.doc.name
d.customer_name = self.doc.customer_name
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
c = Document('Contact')
c.first_name = details[0]['lead_name']
c.email_id = details[0]['email_id']
c.phone = details[0]['phone']
c.mobile_no = details[0]['mobile_no']
c.customer = self.doc.name
c.customer_name = self.doc.customer_name
c.is_primary_contact = 1
try:
c.save(1)
except NameError, e:
pass
def create_lead_address_contact(self):
if self.doc.lead_name:
details = sql("select name, lead_name, address_line1, address_line2, city, country, state, pincode, phone, mobile_no, fax, email_id from `tabLead` where name = '%s'" %(self.doc.lead_name), as_dict = 1)
d = Document('Address')
d.address_line1 = details[0]['address_line1']
d.address_line2 = details[0]['address_line2']
d.city = details[0]['city']
d.country = details[0]['country']
d.pincode = details[0]['pincode']
d.state = details[0]['state']
d.fax = details[0]['fax']
d.email_id = details[0]['email_id']
d.phone = details[0]['phone']
d.customer = self.doc.name
d.customer_name = self.doc.customer_name
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
c = Document('Contact')
c.first_name = details[0]['lead_name']
c.email_id = details[0]['email_id']
c.phone = details[0]['phone']
c.mobile_no = details[0]['mobile_no']
c.customer = self.doc.name
c.customer_name = self.doc.customer_name
c.is_primary_contact = 1
try:
c.save(1)
except NameError, e:
pass
def make_address_from_supplier():
for c in webnotes.conn.sql("select * from tabSupplier", as_dict=1):
d = Document('Address')
d.address_line1 = c['address_line1']
d.address_line2 = c['address_line2']
d.city = c['city']
d.country = c['country']
d.pincode = c['pincode']
d.state = c['state']
d.supplier = c['name']
d.supplier_name = c['supplier_name']
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
def make_address_from_supplier():
for c in webnotes.conn.sql("select * from tabSupplier", as_dict=1):
d = Document('Address')
d.address_line1 = c['address_line1']
d.address_line2 = c['address_line2']
d.city = c['city']
d.country = c['country']
d.pincode = c['pincode']
d.state = c['state']
d.supplier = c['name']
d.supplier_name = c['supplier_name']
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
def make_address_from_customer():
for c in webnotes.conn.sql("select * from tabCustomer", as_dict=1):
d = Document('Address')
d.address_line1 = c['address_line1']
d.address_line2 = c['address_line2']
d.city = c['city']
d.country = c['country']
d.pincode = c['pincode']
d.state = c['state']
d.fax = c['fax_1']
d.email_id = c['email_id']
d.phone = c['phone_1']
d.customer = c['name']
d.customer_name = c['customer_name']
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
def make_address_from_customer():
for c in webnotes.conn.sql("select * from tabCustomer", as_dict=1):
d = Document('Address')
d.address_line1 = c['address_line1']
d.address_line2 = c['address_line2']
d.city = c['city']
d.country = c['country']
d.pincode = c['pincode']
d.state = c['state']
d.fax = c['fax_1']
d.email_id = c['email_id']
d.phone = c['phone_1']
d.customer = c['name']
d.customer_name = c['customer_name']
d.is_primary_address = 1
d.address_type = 'Office'
try:
d.save(1)
except NameError, e:
pass
def create_lead_address_contact(self):
if self.doc.lead_name:
details = sql(
"select name, lead_name, address_line1, address_line2, city, country, state, pincode, phone, mobile_no, fax, email_id from `tabLead` where name = '%s'"
% (self.doc.lead_name),
as_dict=1,
)
d = Document("Address")
d.address_line1 = details[0]["address_line1"]
d.address_line2 = details[0]["address_line2"]
d.city = details[0]["city"]
d.country = details[0]["country"]
d.pincode = details[0]["pincode"]
d.state = details[0]["state"]
d.fax = details[0]["fax"]
d.email_id = details[0]["email_id"]
d.phone = details[0]["phone"]
d.customer = self.doc.name
d.customer_name = self.doc.customer_name
d.is_primary_address = 1
d.address_type = "Office"
try:
d.save(1)
except NameError, e:
pass
c = Document("Contact")
c.first_name = details[0]["lead_name"]
c.email_id = details[0]["email_id"]
c.phone = details[0]["phone"]
c.mobile_no = details[0]["mobile_no"]
c.customer = self.doc.name
c.customer_name = self.doc.customer_name
c.is_primary_contact = 1
try:
c.save(1)
except NameError, e:
pass
