def get_support_ticket(code,sender_no,message,_type='POST'):
#return "hello"
from webnotes.utils import get_first_day, get_last_day, add_to_date, nowdate, getdate
today = nowdate()
from webnotes.model.doc import Document
import time
#return sender_no[-11:]
if code[1:-1] =="CRT":
#return "hello"
#return sender_no[1:-1]
msg="Dear Customer,According to your request ticket is created"
d= Document('Support Ticket')
d.opening_time=time.strftime("%H:%M:%S")
d.opening_date=today
d.subject=message[1:-1]
d.raised_by=sender_no[1:-1]
d.company='medsynaptic'
d.status='Open'
d.save()
webnotes.conn.commit()
#p=send_sms(message[1:-1],sender_no1[1:-1])
return d.name
elif code[1:-1]=="CLS":
#return "hii"
#msg="Ticket Closed"
#sender_no1=sender_no[-11:]
z="select name from `tabSupport Ticket` where raised_by="+sender_no[1:-1]+" and status='Open'"
x=webnotes.conn.sql(z)
#return x
msg="Dear Customer,according to your request respective ticket is closed"
if x:
g="update `tabSupport Ticket` set status='Closed' where name='%s'"%(x[0][0])
h=webnotes.conn.sql(g)
#e=send_sms(message[1:-1],sender_no1[1:-1])
return "Updated"
else:
pass
else:
pass
def get_customer_issue(installationname,sender_no,message,_type='POST'):
#return installationname[1:-1]
#sender_no1=sender_no[-11:]
qr="select customer,employee_id from `tabInstallation Note` where name='"+installationname[1:-1]+"' "
res=webnotes.conn.sql(qr)
#return qr
x="select customer_name from `tabCustomer` where customer_no='"+sender_no[1:-1]+"' "
y=webnotes.conn.sql(x)
#return x
if y == None:
z="select user_id from `tabEmployee` where cell_number="+sender_no[1:-1]+""
m=webnotes.conn.sql(z)
#return m
w="select status,user_id from `tabEmployee` where name='%s'"%(res[0][1]);
t=webnotes.conn.sql(w)
#return t
from webnotes.utils import get_first_day, get_last_day, add_to_date, nowdate, getdate
today = nowdate()
qry="select name from `tabFiscal Year` where is_fiscal_year_closed='No'"
res1=webnotes.conn.sql(qry)
q=" select territory from `tabCustomer` where name='%s'"%(res[0][0]);
r=webnotes.conn.sql(q)
w=" select parent from `tabDefaultValue` where defkey = '%s' and defvalue = '%s'"%('territory',r[0][0])
a=webnotes.conn.sql(w)
#return a
from webnotes.model.doc import Document
import time
#if res :
d = Document('Support Ticket')
d.opening_time=time.strftime("%H:%M:%S")
if y:
d.raised_by=y[0][0]
elif z:
d.raised_by=z[0][0]
else:
d.raised_by=sender_no1[-11:]
d.subject=installationname[1:-1]
d.customer_name=res[0][0]
d.customer=res[0][0]
d.territory=r[0][0]
d.status='Open'
#d.customer_group='Individual'
d.opening_date=today
#d.fiscal_year=res1[0][0]
d.company='medsynaptic'
d.territory=r[0][0]
#d.raised_by=res[0][1]
if t[0][0] =='Active':
#return t[0][1]
d.assigned_to=t[0][1]
d.assigned_to_higher_level=a[0][0]
else:
d.assigned_to=a[0][0]
d.assigned_to_higher_level=a[0][0]
#d.assigned_to_higher_level=a[0][0]
#return d.fiscal_year
d.save()
webnotes.conn.commit()
#return sender_no[1:-1]
p=send_sms(message[1:-1],sender_no[1:-1])
return d.name
