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) 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 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/')