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_address(self,name,args): c=Document('Address') c.address_line1=args['Address'] c.address_type='Shipping' c.customer=name c.customer_name=args['Customer Name'] c.address_title=name c.city=args['City'] c.phone=args['Phone Number'] c.state=args['State'] c.country=args['Country'] c.pincode=args['Pincode'] c.is_primary_address=1 c.save()
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 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