def ViewFriendTrack(request, authid): context = RequestContext(request) cursor = connection.cursor() cursor.execute("SELECT * from pahera_viewfriendtracks WHERE auth_id = %s", [authid]) track_details = DictFetchAll.dictfetchall(cursor) js_data = {} trackData = {} single_track = [] for data in track_details: trackData["person_id"] = data["person_id"] cursor1 = connection.cursor() cursor1.execute("SELECT * from pahera_person WHERE id = %s", [data["person_id"]]) person_Data = DictFetchAll.dictfetchall(cursor1) trackData["first_name"] = person_Data[0]["first_name"] trackData["last_name"] = person_Data[0]["last_name"] trackData["location_lat"] = str(data["latitude"]) trackData["location_long"] = str(data["longitude"]) lati = data["latitude"] longi = data["longitude"] trackData["location_name"] = data["address"] trackData["time"] = str(data["time"]) trackData["date"] = str(data["date"]) trackData["id"] = data["id"] trackData["message"] = data["message"] single_track.append(dict(trackData)) js_data["res"] = single_track scriptpath = os.path.dirname("./static/JSON/temp") fName = os.path.join(scriptpath, "FriendTrack.json") WritingToJson.writeJSON(js_data, fName) return render_to_response("pahera/viewFriendTracks.html", context)
def Home(request): context = RequestContext(request) track_details = {} person_ID = request.session.get("username", None) cursor = connection.cursor() cursor1 = connection.cursor() person_Data2 = {} person_Data2["person"] = Person.objects.get(id=person_ID) cursor1.execute("SELECT * from pahera_person WHERE id = %s", [person_ID]) person_Data = DictFetchAll.dictfetchall(cursor1) cursor.execute("SELECT * from pahera_tracks") track_details = DictFetchAll.dictfetchall(cursor) js_data = {} trackData = {} single_track = [] for data in track_details: if data["person_id"] == person_ID: trackData["person_id"] = data["person_id"] trackData["first_name"] = person_Data[0]["first_name"] trackData["last_name"] = person_Data[0]["last_name"] trackData["location_lat"] = str(data["latitude"]) trackData["location_long"] = str(data["longitude"]) lati = data["latitude"] longi = data["longitude"] trackData["location_name"] = data["address"] trackData["time"] = str(data["time"]) trackData["date"] = str(data["date"]) trackData["id"] = data["id"] trackData["message"] = data["message"] single_track.append(dict(trackData)) js_data["res"] = single_track scriptpath = os.path.dirname("./static/JSON/temp/") fName = os.path.join(scriptpath, "TrackResults.json") WritingToJson.writeJSON(js_data, fName) return render_to_response("pahera/home.html", person_Data2, context)
def AddFriend(request): context = RequestContext(request) person = Person.objects.get(id=request.session.get("username", None)) if request.method == "POST": global data, friend_Data data = request.POST cursor = connection.cursor() cursor.execute( "SELECT * from pahera_trusted_friends WHERE person_id = %s AND (friend_email = %s OR friend_phone_no = %s)", [person.id, data["email"], data["phone_no"]], ) friend_Data = DictFetchAll.dictfetchall(cursor) # This method is called only when there are no friends with same phone_no or email..!!! def add_friend(): newFriend = Trusted_friends( person=person, friend_name=data["name"], friend_email=data["email"], friend_phone_no=data["phone_no"] ) newFriend.save() if newFriend: # TO DO..!!! trusteeUpdate = Person.objects.filter(email=data["email"]) return HttpResponseRedirect("/pahera/myContacts") else: addFriendFailed = {} addFriendresult = {} addFriendresult["reason"] = "Friend with this Phone-No or Email Already exists.!" addFriendresult["statement"] = "Please Add friends with Different Email or Phone-No..!" addFriendFailed["result"] = addFriendresult return render_to_response("pahera/addFriend.html", context) if friend_Data: addFriendFailed = {} addFriendresult = {} addFriendresult["reason"] = "Friend with this Phone-No or Email Already exists.!" addFriendresult["statement"] = "Please Add friends with Different Email or Phone-No..!" addFriendFailed["result"] = addFriendresult return render_to_response("pahera/addFriend.html", addFriendFailed, context) else: add_friend() return HttpResponseRedirect("/pahera/myContacts") return render_to_response("pahera/addFriend.html", context)