Esempio n. 1
0
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)
Esempio n. 2
0
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)
Esempio n. 3
0
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)
Esempio n. 4
0
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)
Esempio n. 5
0
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)
Esempio n. 6
0
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)
Esempio n. 7
0
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)
Esempio n. 8
0
def api_fun(request):
    context = RequestContext(request)
    return render_to_response('OperationRepo/apifun.html',
                              {'form': SearchForm()}, context)
Esempio n. 9
0
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)
Esempio n. 10
0
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)