def search (request):
context = RequestContext(request)
context_dict = {}
if request.method == 'GET':
form = SearchForm(request.GET)
if form.is_valid():
#form has been submitted
search = form.cleaned_data['search']
format = form.cleaned_data['format']
searchlist = search.split(" ")
qor = Q(text__icontains = str(searchlist[0])) | Q(business__name__icontains = str(searchlist[0]))
qor2 = Q(name__icontains = str(searchlist[0]))
qand = Q(text__icontains = str(searchlist[0])) | Q(business__name__icontains = str(searchlist[0]))
qand2 = Q(name__icontains = str(searchlist[0]))
# create qsets for queries. or and and
for s in searchlist[1:] :
qor = qor | Q(text__icontains = str(s)) | Q(business__name__icontains = str(s))
qor2 = qor2 | Q(name__icontains = str(s))
qand = qand & (Q(text__icontains = str(s)) | Q(business__name__icontains = str(s)))
qand2 = qand2 & Q(name__icontains = str(s))
# and search results
andreviews = Review.objects.filter(qand).select_related()
andbusinesses = Business.objects.filter(qand2)
andusers = User.objects.filter(qand2)
and_results = {"reviews" : andreviews, "businesses" : andbusinesses, "users" : andusers}
# or search results
orreviews = Review.objects.filter(qor).exclude(qand).select_related()
orusers = User.objects.filter(qor2).exclude(qand2)
orbusinesses = Business.objects.filter(qor2).exclude(qand2)
or_results = {"reviews" : orreviews, "users" : orusers, "businesses" : orbusinesses}
form = SearchForm()
if format == "json":
context_dict["andresults"] = [serializers.serialize("json", andreviews), serializers.serialize("json", andusers),serializers.serialize("json", andbusinesses)]
context_dict["orresults"] = [serializers.serialize("json", orreviews), serializers.serialize("json", orusers), serializers.serialize("json", orbusinesses)]
context_dict["search_terms"] = search
#context_dict["search_list"] = searchlist
return StreamingHttpResponse(json.dumps(context_dict))
context_dict["form"] = form
context_dict["andresults"] = and_results
context_dict["orresults"] = or_results
context_dict["search_terms"] = search
context_dict["search_list"] = searchlist
return render_to_response('OperationRepo/search.html', context_dict, context)
else:
form = SearchForm() #create form to display
return render_to_response('OperationRepo/search.html', {'form':form }, context)
def business(request, *z):
context = RequestContext(request)
businessID = z[0]
thebusiness = get_object_or_404(Business, business_id=str(businessID))
thereviews = Review.objects.filter(
business=thebusiness).order_by('-date').select_related()
theAttributesList = Attributes.objects.filter(business=thebusiness)
multiAtrributesDict = {}
singleAttributesDict = {}
for objects in theAttributesList:
if "{" in str(objects.value):
multiAtrributesDict[objects.name] = toJS(objects.value)
else:
singleAttributesDict[objects.name] = objects.value
theCategoriesList = Categories.objects.filter(business=thebusiness)
theHoursList = Hours.objects.filter(business=thebusiness)
reviewHistoryLabels = []
reviewHistoryVolumeData = []
reviewHistoryStarsData = []
cursor = connections['default'].cursor()
query = """SELECT date_part('month',date) as month ,date_part('year',date) as year,
count(*) as count, AVG(stars) as avg FROM "OperationRepo_review" where business_id='""" + businessID + """'
group by year,month order by year,month"""
cursor.execute(query)
l = dictfetchall(cursor)
for g in l:
label = str(int(g["month"])) + "/" + str(int(g["year"]))
reviewHistoryLabels += [label]
reviewHistoryVolumeData += [int(g["count"])]
reviewHistoryStarsData += [g["avg"]]
return render_to_response(
'OperationRepo/business.html',
{
"Business": thebusiness,
"Reviews": thereviews,
# "ReviewsArray":thereviews,
"MultiValueAttributes": multiAtrributesDict,
"SingleValueAttributes": singleAttributesDict,
"Categories": theCategoriesList,
"Hours": theHoursList,
"MAPS_API_KEY": 'AIzaSyCJA1o336vHzMhiIAj-3PjLUd2H6xr0be4',
"form": SearchForm(),
"reviewHistoryLabels": reviewHistoryLabels,
"reviewHistoryVolumeData": reviewHistoryVolumeData,
"reviewHistoryStarsData": reviewHistoryStarsData,
"active_page": "business_nav",
"allcategories": allCategories()
},
context)
def review(request, *z):
context = RequestContext(request)
reviewID = z[0]
review = get_object_or_404(Review, review_id=reviewID)
review_votes_list = Review_Votes.objects.filter(review=review)
return render_to_response(
'OperationRepo/review.html', {
"Review": review,
"Review_Votes_List": review_votes_list,
"form": SearchForm(),
"active_page": "review_nav",
"allcategories": allCategories()
}, context)
def user_splash(request):
context = RequestContext(request)
firstletter = request.GET.get('firstletter', '')
if len(firstletter) > 0:
allUsers = User.objects.filter(
name__startswith=firstletter).order_by('name')
else:
allUsers = User.objects.all().order_by('name')
return render_to_response(
'OperationRepo/user_splash.html', {
"userList": allUsers,
"form": SearchForm(),
"active_page": "user_nav",
"allcategories": allCategories()
}, context)
def review_splash(request):
context = RequestContext(request)
numStars = request.GET.get('star', '')
if len(numStars) > 0:
allReviews = Review.objects.filter(stars=numStars).order_by("-date")
avgInfo = allReviews.aggregate(Avg('stars'))
else:
allReviews = Review.objects.all().order_by("-date")
avgInfo = allReviews.aggregate(Avg('stars'))
return render_to_response(
'OperationRepo/review_splash.html', {
"rdict": allReviews,
"avgInfo": avgInfo,
"form": SearchForm(),
"active_page": "review_nav",
"allcategories": allCategories()
}, context)
def business_splash(request):
context = RequestContext(request)
categoryName = request.GET.get('category', '')
if (len(categoryName) > 0):
categories = Categories.objects.filter(
name=categoryName).order_by('name').select_related()
allBusinesses = [c.business for c in categories]
else:
allBusinesses = Business.objects.all().order_by('name')
return render_to_response(
'OperationRepo/business_splash.html', {
"bdict": allBusinesses,
"form": SearchForm(),
"active_page": "business_nav",
"allcategories": allCategories()
}, context)
def user(request, *z):
context = RequestContext(request)
userID = z[0]
user = get_object_or_404(User, user_id=userID)
user_votes_list = User_Votes.objects.filter(user=user)
elite_list = Elite.objects.filter(user=user).order_by('-years_elite')
compliments_list = Compliments.objects.filter(user=user)
users_reviews = Review.objects.filter(user=user).order_by('-date')
# return HttpResponse([str(i.years_elite) for i in elite_list])
return render_to_response(
'OperationRepo/user.html', {
"User": user,
"User_Votes_List": user_votes_list,
"Elite_List": elite_list,
"Compliments_List": compliments_list,
"reviews": users_reviews,
"form": SearchForm(),
"active_page": "user_nav",
"allcategories": allCategories()
}, context)
def api_fun(request):
context = RequestContext(request)
return render_to_response('OperationRepo/apifun.html',
{'form': SearchForm()}, context)
def search(request):
context = RequestContext(request)
context_dict = {}
if request.method == 'GET':
form = SearchForm(request.GET)
if form.is_valid():
#form has been submitted
search = form.cleaned_data['search']
format = form.cleaned_data['format']
searchlist = search.split(" ")
qor = Q(text__icontains=str(searchlist[0])) | Q(
business__name__icontains=str(searchlist[0]))
qor2 = Q(name__icontains=str(searchlist[0]))
qand = Q(text__icontains=str(searchlist[0])) | Q(
business__name__icontains=str(searchlist[0]))
qand2 = Q(name__icontains=str(searchlist[0]))
# create qsets for queries. or and and
for s in searchlist[1:]:
qor = qor | Q(text__icontains=str(s)) | Q(
business__name__icontains=str(s))
qor2 = qor2 | Q(name__icontains=str(s))
qand = qand & (Q(text__icontains=str(s))
| Q(business__name__icontains=str(s)))
qand2 = qand2 & Q(name__icontains=str(s))
# and search results
andreviews = Review.objects.filter(qand).select_related()
andbusinesses = Business.objects.filter(qand2)
andusers = User.objects.filter(qand2)
and_results = {
"reviews": andreviews,
"businesses": andbusinesses,
"users": andusers
}
# or search results
orreviews = Review.objects.filter(qor).exclude(
qand).select_related()
orusers = User.objects.filter(qor2).exclude(qand2)
orbusinesses = Business.objects.filter(qor2).exclude(qand2)
or_results = {
"reviews": orreviews,
"users": orusers,
"businesses": orbusinesses
}
form = SearchForm()
if format == "json":
context_dict["andresults"] = [
serializers.serialize("json", andreviews),
serializers.serialize("json", andusers),
serializers.serialize("json", andbusinesses)
]
context_dict["orresults"] = [
serializers.serialize("json", orreviews),
serializers.serialize("json", orusers),
serializers.serialize("json", orbusinesses)
]
context_dict["search_terms"] = search
#context_dict["search_list"] = searchlist
return StreamingHttpResponse(json.dumps(context_dict))
context_dict["form"] = form
context_dict["andresults"] = and_results
context_dict["orresults"] = or_results
context_dict["search_terms"] = search
context_dict["search_list"] = searchlist
return render_to_response('OperationRepo/search.html',
context_dict, context)
else:
form = SearchForm() #create form to display
return render_to_response('OperationRepo/search.html', {'form': form},
context)
def index(request):
# Request the context of the request.
# The context contains information such as the client's machine details, for example.
context = RequestContext(request)
context_dict = {
'message': "Hello World",
"form": SearchForm(),
"active_page": "index_nav"
}
reviews = Review.objects.order_by("-date").select_related()
arr = "["
for r in reviews:
for i in range(0, int(r.stars)):
arr += "new google.maps.LatLng(" + str(
r.business.latitude) + "," + str(r.business.longitude) + "),"
arr = arr[:-1] + "]"
query = """
SELECT sub.count as "Number of Compliments",
ROUND(CAST(SUM(sub.average_stars)/COUNT(*) AS NUMERIC),2) as "Average Stars Given"
FROM
(
SELECT u.user_id,COUNT(*),
u.average_stars
FROM "OperationRepo_compliments" c
join "OperationRepo_user" u on c.user_id=u.user_id
group by u.user_id
) sub
group by sub.count
order by "Number of Compliments" """
q2a = []
q2b = []
cursor = connections['default'].cursor()
cursor.execute(query)
l = dictfetchall(cursor)
for g in l:
a = int(g["Number of Compliments"])
b = float(g["Average Stars Given"])
q2a += [a]
q2b += [b]
query = """
SELECT COUNT(*), regexp_split_to_table(regexp_replace(lower(text),'[^\sa-zA-Z0-9=+-]','','g'),'\s') as word
from "OperationRepo_review" as r
group by word
order by count desc
limit 10;"""
q3a = []
q3b = []
cursor = connections['default'].cursor()
cursor.execute(query)
l = dictfetchall(cursor)
for g in l:
a = str(g["word"])
b = int(g["count"])
q3a += [a]
q3b += [b]
return render_to_response(
'OperationRepo/index.html', {
"q2a": q2a,
"q2b": q2b,
"q3a": q3a,
"q3b": q3b,
"form": SearchForm(),
"active_page": "index_nav",
"allcategories": allCategories(),
"heatmap": arr
}, context)