def create_customer(auth_key,name,mobile_number,email_id,datetime,version,_type='POST'): login =[] loginObj = {} qr="select name from `tabauth keys` where auth_key="+auth_key res=webnotes.conn.sql(qr) if res: qr1="select name from `tabCustomer Details` where customer_name="+name+" and phone_number="+mobile_number rs=webnotes.conn.sql(qr1) rgn=webnotes.conn.sql("select region from `tabFranchise` where contact_email='"+res[0][0]+"'") if rs : key={} key['customer_id']=rs[0][0] login.append(key) loginObj['status']='200' loginObj['customer']=login return loginObj else : from webnotes.model.doc import Document d = Document('Customer Details') if len(name)>3: d.customer_name=name[1:-1] if len(email_id)>3: d.customer_email=email_id[1:-1] if len(mobile_number)>3: d.phone_number=mobile_number[1:-1] d.region=rgn[0][0] d.save() webnotes.conn.commit() key={} key['customer_id']=d.name login.append(key) loginObj['status']='200' loginObj['customer']=login return loginObj else: loginObj['status']='401' return loginObj
def create_customer1(auth_key,name,mobile_number,email_id,datetime,version,_type='POST'): login =[] loginObj = {} qr="select name from `tabauth keys` where auth_key="+auth_key res=webnotes.conn.sql(qr) if res: qr1="select name from `tabCustomer Details` where customer_name="+name+" and phone_number="+mobile_number rs=webnotes.conn.sql(qr1) if rs : key={} key['customer_id']=rs[0][0] login.append(key) loginObj['status']='200' loginObj['customer']=login return loginObj else : from webnotes.model.doc import Document d = Document('Customer Details') if len(name)>3: d.customer_name=name[1:-1] if len(email_id)>3: d.customer_email=email_id[1:-1] if len(mobile_number)>3: d.phone_number=mobile_number[1:-1] d.save() d1 = Document('Customer') d1.customer_name=name[1:-1]+'-'+mobile_number[1:-1] d1.territory='' d1.account_id='' d1.sf_name='' d1.customer_type='Company' d1.customer_group='Commercial' d1.company='PowerCap' d1.save(new=1) if cint(webnotes.defaults.get_global_default("auto_accounting_for_stock")): if not webnotes.conn.get_value("Account", {"master_type": "Customer","master_name": d1.name}) and not webnotes.conn.get_value("Account", {"master_name": d1.name}): if not webnotes.conn.get_value("Stock Ledger Entry", {"Warehouse": d1.name}): ac_bean = webnotes.bean({ "doctype": "Account", 'account_name': d1.name, 'parent_account': "Accounts Receivable - P", 'group_or_ledger':'Ledger', 'debit_or_credit':'Debit', 'company':"PowerCap", "master_type": "Customer", "master_name": d1.name, "freeze_account": "No" }) ac_bean.ignore_permissions = True ac_bean.insert() webnotes.conn.commit() key={} key['customer_id']=d.name login.append(key) loginObj['status']='200' loginObj['customer']=login return loginObj else: loginObj['status']='401' return loginObj
def get_message(number,message,_type='POST'): if (cint(len(message[1:-1]))<=0 or cint(len(number[1:-1]))<=0): invObj={} invObj['status']='401' invObj['error']='Incomplete data to send message, Please provide messages and mobile number' return invObj from webnotes.model.doc import Document from webnotes.utils import nowdate,flt,cstr,add_months m=message[1:-1].split(',') #return m[2] bsrn=m[2] csrn=m[3] vm=m[4] un=m[5] va=m[6] a="select name from `tabCustomer Details` where name='"+m[0]+"-"+number[1:-1]+"'" b=webnotes.conn.sql(a) itm="select item_code from `tabSerial No` where name='"+cstr(m[2])+"'" itemm=webnotes.conn.sql(itm) #webnotes.errprint(itemm[0][0]) #webnotes.errprint(itemm) qrs="select warranty_period from tabItem where name='"+cstr(itemm[0][0])+"'" #webnotes.errprint("item----------------") #webnotes.errprint(itemm[0][0]) ress=webnotes.conn.sql(qrs) #webnotes.errprint("warrenty-----------") #webnotes.errprint(ress[0][0]) if b: l = Document('Customer Details',b[0][0]) l.customer_name=m[0] l.customer_email=m[1] l.phone_number=number[1:-1] l.save() webnotes.conn.commit() m = Document('Customer Data') m.serial_no=bsrn m.warranty_start_on=nowdate() m.vehical_make=vm m.vehical_age=un m.unit_no=va m.item=itemm[0][0] m.capacitor_serial_no=csrn m.warranty_end_on=add_months(cstr(nowdate()),cint(ress[0][0])) m.parent=l.name m.parenttype='Customer Details' m.parentfield='customer_data' #webnotes.errprint(m.item) #webnotes.errprint(add_months(cstr(nowdate()),cint(ress[0][0]))) m.save(new=1) webnotes.conn.commit() else: l = Document('Customer Details') l.customer_name=m[0] l.customer_email=m[1] l.phone_number=number[1:-1] l.save(new=1) webnotes.conn.commit() m = Document('Customer Data') m.serial_no=bsrn m.warranty_start_on=nowdate() m.warranty_end_on=add_months(cstr(nowdate()),cint(ress[0][0])) m.item=itemm[0][0] m.vehical_make=vm m.vehical_age=un m.unit_no=va m.capacitor_serial_no=csrn m.parent=l.name m.parenttype='Customer Details' m.parentfield='customer_data' m.save(new=1) webnotes.conn.commit() import requests from webnotes.model.code import get_obj msg="Dear Customer, welcome to PowerCap You have purchased the battery with serail no. '"+bsrn+"' today, your warrenty will expire on 29/09/2015, \n Regards,\n PowerCap" #msg1=msg.split(",") #return msg #number='9890865260' number1=number[1:-1] webnotes.errprint(number1) nos=[] nos.append(number1) webnotes.errprint(nos) get_obj('SMS Control', 'SMS Control').send_sms(nos, cstr(msg)) login =[] invObj={} invObj['status']='200' invObj['message']='Updated the record' return invObj