def signup(request):
username = "******"
htmls = ""
if request.method == "POST":
#Get the posted form
MyLoginForm = LoginForm(request.POST)
username = request.POST['username']
password = request.POST['pswd']
email_id = request.POST['email']
otp = randint(1000, 9999)
otpuse = Signup(emailid=email_id, otp=otp)
user = Userdata(username=username, password=password, emailid=email_id)
dbuser = Userdata.objects.filter(username=username, status="accepted")
dbuser1 = Userdata.objects.filter(username=username, status="waiting")
otpuser = Signup.objects.filter(emailid=email_id)
if otpuser:
with connection.cursor() as cursor:
cursor.execute(
"update myapp_signup set otp=%s where emailid=%s",
[otp, email_id])
mail(email_id, otp)
username = email_id
txt = "ok"
htmls = "myapp/signedup.html"
if otpuser and dbuser1:
with connection.cursor() as cursor:
cursor.execute(
"update myapp_signup set otp=%s where emailid=%s",
[otp, email_id])
mail(email_id, otp)
username = email_id
txt = "ok"
htmls = "myapp/signedup.html"
if not otpuser:
if (mail(email_id, otp) == 'success'):
otpuse.save()
if not dbuser and not dbuser1:
# user=User.objects.create_user(username=username,password=password)
user.save()
username = email_id
txt = "ok"
htmls = 'myapp/signedup.html'
if dbuser:
username = email_id
txt = "user already exist"
htmls = "myapp/signedup.html"
else:
# MyLoginForm = Loginform()
pass
# return HttpResponseRedirect('/myapp',{"username" : username})
return render(request, htmls, {"username": username, "txt": txt})
def indexmet(request):
username = "******"
htmls=""
if request.method == "POST":
if(request.POST['log']=='SIGNUP'):
username = MyLoginForm.cleaned_data['username']
password = MyLoginForm.cleaned_data['password']
user=Userdata(username=username,password=password)
dbuser=Userdata.objects.filter(username = username)
if not dbuser:
user.save()
username=username+" Your signup success"
htmls='myapp/signedup.html'
else:
username="******"
htmls="myapp/signedup.html"
else:
pass
def login(request):
username = "******"
if request.method == "POST":
#Get the posted form
MyLoginForm = LoginForm(request.POST)
if MyLoginForm.is_valid():
print ("Entered")
username = MyLoginForm.cleaned_data['username']
password = MyLoginForm.cleaned_data['password']
user=Userdata(username=username,password=password)
query="select id from myapp_userdata where username=%s and password=%s and status='accepted'"
params=[username,password]
with connection.cursor() as cursor:
cursor.execute(query,params)
dbuser=cursor.fetchall()
query1="select id from myapp_userdata where username=%s and password=%s "
params=[username,password]
with connection.cursor() as cursor:
cursor.execute(query1,params)
dbuser1=cursor.fetchall()
# dbuser=Userdata.objects.raw("select id from myapp_userdata where username=%s and password=%s",[username,password])
# print (dbuser.fetchone())
if len(dbuser)>0:
print ("USername "+username+" "+"Password "+password)
user=authenticate(username=username,password=password)
if(username=='girish'):
alldata = Userdata.objects.filter(username = username)
request.session['username'] = username
request_context = RequestContext(request)
return HttpResponseRedirect('/myapp/approval',{"User" : alldata})
else:
request.session['username'] = username
print(request.session.get_expiry_age)
query="select a.image from myapp_userdata a where a.username=%s and a.status='accepted'"
params=[username]
with connection.cursor() as cursor:
cursor.execute(query,params)
dbuser_pro=cursor.fetchall()
alldata = Userdata.objects.filter(username = username)
username="******"+username+"\n ,Your login is success"
htmls='myapp/loggedin.html'
return HttpResponseRedirect('/myapp/message',{"User" : dbuser_pro})
elif len(dbuser1)>0:
username="******"+username+"\n ,Waiting for the approval."
htmls='myapp/faillogin.html'
return render(request, htmls, {"username" : username})
else:
username="******"+username+"\n ,Entered Username or Password are wrong. Please try again."
htmls='myapp/faillogin.html'
response=render(request, htmls, {"username" : username})
return response
# username=dbuser
else:
pass
def signup(request):
username = "******"
htmls=""
if request.method == "POST":
#Get the posted form
MyLoginForm = LoginForm(request.POST)
if MyLoginForm.is_valid():
username = MyLoginForm.cleaned_data['username']
password = MyLoginForm.cleaned_data['password']
user=Userdata(username=username,password=password)
dbuser=Userdata.objects.filter(username = username)
if not dbuser:
# user=User.objects.create_user(username=username,password=password)
user.save()
username=username+" Your signup success"
htmls='myapp/signedup.html'
else:
username="******"
htmls="myapp/signedup.html"
else:
# MyLoginForm = Loginform()
pass
return render(request, htmls, {"username" : username})
def messagemet(request):
if (request.session.has_key('username')):
send_req_response=""
send_response=""
from_user_sess=""
res=""
id=""
passwd=""
usermsgs=""
waiting=[]
selmsg="SELECT FRIENDS FROM LEFT"
Frnds=[]
Request=[]
params=[request.session['username']]
dbuser=Userdata.objects.raw("select * from myapp_userdata where username=%s",params)
print (dbuser)
for i in dbuser:
id=i.id
passwd=i.password
print (id)
query="select a.* from myapp_userdata a where a.username=%s and a.status='accepted'"
login_user=request.session['username']
dbuser_pro=Userdata.objects.raw("select a.* from myapp_userdata a where a.username=%s and a.status='accepted'",[request.session['username']])
cc=0
for klk in dbuser_pro:
cc=cc+1
if (cc==0):
dbuser_pro=Userdata.objects.raw("select a.* from myapp_userdata a where a.username=%s and a.status='accepted'",['girish'])
mesgs=Messages.objects.raw("select * from myapp_messages where to_username=%s or from_username=%s order by id ",[request.session['username'],request.session['username']])
mesgs_count=Messages.objects.raw("select id,count(*) as count from myapp_messages where to_username=%s or from_username=%s ",[request.session['username'],request.session['username']])
mcc=0
for mc in mesgs_count:
mcc=mc.count
for lk in mesgs:
print (lk.send_time)
paramsf=[request.session['username'],request.session['username']]
db_frpro=Userdata.objects.raw("select b.image,a.* from (select id,status,case when requested_to=%s then requested_from when requested_from=%s and status<>'waiting' then requested_to else 'b' end as username from myapp_friends where status in ('waiting','accepted')) a, myapp_userdata b where a.username<>'b' and b.username=a.username",paramsf)
# frnds1="select c.id,image,c.username from myapp_userprofile b , myapp_userdata c where c.username in (select a.username from (select id,status,case when requested_to=%s then requested_from when requested_from=%s and status<>'waiting' then requested_to else 'b' end as username from myapp_friends where status in ('waiting','accepted')) a where username<>'b') and b.username_id=c.id"
# with connection.cursor() as cursor:
# cursor.execute(frnds1,paramsf)
# db_frpro=dictfetchall(cursor)
frndss=Friends.objects.raw("select a.* from (select id,status,case when requested_to=%s and status <> 'waiting' then requested_from when requested_from=%s then requested_to else 'b' end as username from myapp_friends where status in ('waiting','accepted')) a where username<>'b'",paramsf)
infofrnds=Friends.objects.raw("select a.* from (select id,status,case when requested_to=%s and status <> 'waiting' then requested_from when requested_from=%s then requested_to else 'b' end as username from myapp_friends where status in ('accepted')) a where username<>'b'",paramsf)
if request.method == "POST":
if(request.POST['action']=="UPDATE"):
print("Yes")
img=request.FILES["img"]
print (img)
# query="insert into myapp_userdata values (%s,%s,%s,%s,%s,%s)"
# params=[img,id]
# with connection.cursor() as cursor:
# cursor.execute(query,params)
user=Userdata(id=id,username=request.session['username'],password=passwd,status='accepted',image=img)
user.save()
dbuser_pro=Userdata.objects.raw("select a.* from myapp_userdata a where a.username=%s and a.status='accepted'",[request.session['username']])
elif(request.POST['action']=="SEND"):
from_user=request.session['username']
to_user=request.POST["username"]
message=request.POST["message"]
paramsf=[request.session['username'],request.session['username']]
fruser=Friends.objects.raw("select id,case when requested_to=%s then requested_from when requested_from=%s then requested_to end as username from myapp_friends ",paramsf)
c=0
for kk in fruser:
if (kk.username==to_user):
c=c+1
if c>0:
mesg=Messages(from_username=from_user,to_username=to_user,message=message)
mesg.save()
send_response="Message sent"
mesgs=Messages.objects.raw("select * from myapp_messages where to_username=%s or from_username=%s order by id ",[request.session['username'],request.session['username']])
mesgs_count=Messages.objects.raw("select id,count(*) as count from myapp_messages where to_username=%s or from_username=%s ",[request.session['username'],request.session['username']])
mcc=0
for mc in mesgs_count:
mcc=mc.count
else:
send_response="Please select Friend from the list"
elif(request.POST['action']=="GO"):
search=request.POST["search"]
a="%"+search+"%"
if " " in search:
bb=search.split(" ")
b="%"+bb[0]+"%"
c="%"+bb[1]+"%"
params=[a,b,c,request.session['username']]
res=Userdata.objects.raw("select * from myapp_userdata where username LIKE %s or username LIKE %s or username LIKE %s and status='accepted' and username <> %s ;",params)
else:
res=Userdata.objects.raw("select * from myapp_userdata where username LIKE %s and status='accepted' and username <> %s ;",[a,request.session['username']])
elif(request.POST['action']=="RESPONSE_ACCEPT"):
requested_to=request.session['username']
requested_from=request.POST["res_usname"]
query="update myapp_friends set status='accepted' where requested_to=%s and requested_from=%s and status='waiting'"
params=[requested_to,requested_from]
with connection.cursor() as cursor:
cursor.execute(query,params)
elif(request.POST['action']=="RESPONSE_REJECT"):
requested_to=request.session['username']
requested_from=request.POST["res_usname"]
query="update myapp_friends set status='rejected' where requested_to=%s and requested_from=%s and status='waiting'"
params=[requested_to,requested_from]
with connection.cursor() as cursor:
cursor.execute(query,params)
elif(request.POST['action']=="SEND_REQUEST"):
requested_to=request.POST["req_usname"]
requested_from=request.session['username']
print (requested_to+"and"+requested_from)
send_req=Friends(requested_from=requested_from,requested_to=requested_to)
send_req.save()
send_req_response="Friend request has sent to "+requested_to
elif(request.POST['action']=="USER_CHAT") :
from_user_sess=request.POST["from_usname"]
login_user=request.session['username']
selmsg=""
# params=[to_user,from_user]
# usermsgs=Messages.objects.raw("select * from myapp_messages where to_username=%s and from_username=%s",params)
elif (request.POST['action']=="REPLY") :
from_user_sess=request.POST["username"]
from_user=request.session['username']
to_user=request.POST["username"]
message=request.POST["message"]
paramsf=[request.session['username'],request.session['username']]
fruser=Friends.objects.raw("select id,case when requested_to=%s then requested_from when requested_from=%s then requested_to end as username from myapp_friends ",paramsf)
c=0
for kk in fruser:
if (kk.username==to_user):
c=c+1
if c>0:
mesg=Messages(from_username=from_user,to_username=to_user,message=message)
mesg.save()
send_response="Message sent"
mesgs=Messages.objects.raw("select * from myapp_messages where to_username=%s or from_username=%s order by id ",[request.session['username'],request.session['username']])
mesgs_count=Messages.objects.raw("select id,count(*) as count from myapp_messages where to_username=%s or from_username=%s ",[request.session['username'],request.session['username']])
mcc=0
for mc in mesgs_count:
mcc=mc.count
else:
send_response="Please select Friend from the list"
elif(request.POST['action'] == "DELETEMESG"):
to_user=request.POST['username1']
if(request.POST["username"] == request.session['username']):
from_user_sess=request.POST["username1"]
else:
from_user_sess=request.POST["username"]
mesgs_count=Messages.objects.raw("select id,count(*) as count from myapp_messages where to_username=%s or from_username=%s ",[request.session['username'],request.session['username']])
mcc=0
for mc in mesgs_count:
mcc=mc.count
from_user=request.POST["username"]
message=request.POST["message"]
idd=request.POST["idd"]
query="delete from myapp_messages where id=%s"
params=[idd]
print (params)
with connection.cursor() as cursor:
cursor.execute(query,params)
mesgs=Messages.objects.raw("select * from myapp_messages where to_username=%s or from_username=%s order by id ",[request.session['username'],request.session['username']])
mesgs_count=Messages.objects.raw("select id,count(*) as count from myapp_messages where to_username=%s or from_username=%s ",[request.session['username'],request.session['username']])
mcc=0
for mc in mesgs_count:
mcc=mc.count
if(res!=""):
waiting=[]
Frnds=[]
Request=[]
print (res)
print(db_frpro)
for i in res:
c=0
k=0
for j in frndss:
print (j.username)
if((i.username==j.username) and str(j.status)=='accepted'):
c=c+1
elif(i.username==j.username and str(j.status)=='waiting'):
k=k+1
if(c>0):
Frnds.append(i.username)
print ("Friends "+i.username)
elif(k>0):
waiting.append(i.username)
print ("waiting" + i.username)
else:
Request.append(i.username)
print ("Request "+i.username)
print (waiting)
return render(request,'myapp/message.html',{'from_user_ses':from_user_sess,'User':dbuser_pro,'selmsgs':selmsg,'mesg_count':mcc,'usermesgs':usermsgs,'messages':mesgs,'friends':db_frpro,'user':login_user,'sr':send_response,'response':res,'waiting':waiting,'Request':Request,'Frnds':Frnds,'send_req_response':send_req_response,'Infofrnds':infofrnds})
else:
return HttpResponseRedirect('/myapp/')