def displayrankedItemwithBidsPieChart(request):
page_title='Pie Chart on Ranked Item'
year=stat.getYear()
itemBidDict, bidtotalSum = stat.createItemIDBidCountDict()
top_ten_dict = stat.sortedItemDictionary(itemBidDict)
itemobjDict = {}
for key,value in top_ten_dict:
itemObj = get_object_or_404(Item, pk=key)
itemobjDict[itemObj.name] = value
fig=Figure()
ax=fig.add_subplot(111)
title='Top Ten ranked items with the highest bids ({0})'.format(year)
fig.suptitle(title, fontsize=14)
try:
x = itemobjDict.values()
labels = itemobjDict.keys()
ax.pie(x, labels=labels);
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def searchstringPieChart(request):
page_title='Search String Pie Chart'
year=stat.getYear()
searchList = list(SearchTerm.objects.values_list('q', flat=True))
search_string = ' '.join(searchList)
result = Counter(search_string.split()).most_common(10)
searchDict = {}
for key,val in result:
searchDict[key] = val
fig=Figure()
ax=fig.add_subplot(111)
title='Top Ten search string submitted by user ({0})'.format(year)
fig.suptitle(title, fontsize=14)
try:
x = searchDict.values()
labels = searchDict.keys()
ax.pie(x, labels=labels);
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def fillStatBidModel(): numbid = stat.getNumofBid() n_day = stat.getDay() n_month = stat.getMonth() n_year = stat.getYear() n_week = stat.getWeek(n_day, n_month, n_year) bidObj = StatBid(no_of_bids=numbid, day=n_day, month=n_month, year=n_year, week=n_week) bidObj.save()
def fillOnlineUserModel(): onlnum = stat.getNumofOnlineUser() n_day = stat.getDay() n_month = stat.getMonth() n_year = stat.getYear() n_week = stat.getWeek(n_day, n_month, n_year) onlinUsrObj = OnlineUser(no_of_online_user=onlnum, day=n_day, month=n_month, year=n_year, week=n_week) onlinUsrObj.save()
def fillRegisterUserModel(): regnum = stat.getNumofRegisteredUser() n_day = stat.getDay() n_month = stat.getMonth() n_year = stat.getYear() n_week = stat.getWeek(n_day, n_month, n_year) regUsrObj = RegisteredUser(no_of_reg_user=regnum, day=n_day, month=n_month, year=n_year, week=n_week) regUsrObj.save()
def yearOnlineUserReport(request, template_name="stats/yearlyOnlineUserReport.html"):
page_title='Yearly Online User Report'
year=stat.getYear()
OnlineObj = OnlineUser.objects.filter(year=year)
onlobjlist=list(OnlineObj.values_list('no_of_online_user', flat=True))
mean ="N/A"
variance="N/A"
try:
mean = "{0:.2f}".format(thinkstats.Mean(onlobjlist))
variance= "{0:.2f}".format(thinkstats.Var(onlobjlist))
except ZeroDivisionError:
pass
return render_to_response(template_name, locals(), context_instance=RequestContext(request))
def weekRegistdUserReport(request, week_no, template_name="stats/weeklyRegistdUserReport.html"):
page_title='Weekly Registered User Report'
weekno=week_no
year=stat.getYear()
RegUserObj = RegisteredUser.objects.filter(week=weekno).filter(year=year)
regobjlist=list(RegUserObj.values_list('no_of_reg_user', flat=True))
mean ="N/A"
variance="N/A"
try:
mean = "{0:.2f}".format(thinkstats.Mean(regobjlist))
variance= "{0:.2f}".format(thinkstats.Var(regobjlist))
except ZeroDivisionError:
pass
return render_to_response(template_name, locals(), context_instance=RequestContext(request))
def monthOnlineUserReport(request, month_no, template_name="stats/monthlyOnlineUserReport.html"):
page_title='Monthly Online User Report'
monthno=month_no
year=stat.getYear()
monthsDict = {1 : "January", 2 : "February", 3 : "March", 4 : "April", 5 : "May",6 : "June",7 : "July",8 : "August",9 : "September",10 : "October",11 : "November",12 : "December"}
realMonth = monthsDict[int(monthno)]
OnlineObj = OnlineUser.objects.filter(month=monthno).filter(year=year)
onlobjlist=list(OnlineObj.values_list('no_of_online_user', flat=True))
mean ="N/A"
variance="N/A"
try:
mean = "{0:.2f}".format(thinkstats.Mean(onlobjlist))
variance= "{0:.2f}".format(thinkstats.Var(onlobjlist))
except ZeroDivisionError:
pass
return render_to_response(template_name, locals(), context_instance=RequestContext(request))
def weeklyScatterOnlinUsrBid(request, week_no):
page_title='Weekly Scatter Diagram based on Online user verses Bid'
weekno=week_no
fig=Figure()
ax=fig.add_subplot(111)
year=stat.getYear()
onlUserObj = OnlineUser.objects.filter(week=weekno).filter(year=year)
bidObj = StatBid.objects.filter(week=weekno).filter(year=year)
onlUserlist = list(onlUserObj.values_list('no_of_online_user', flat=True))
bidlist = list(bidObj.values_list('no_of_bids', flat=True))
title='Scatter Diagram of number of online User against number of bids (week {0}) {1}'.format(weekno,year)
ax.set_xlabel('Number of online Users')
ax.set_ylabel('Number of Bids')
fig.suptitle(title, fontsize=14)
try:
ax.scatter(onlUserlist, bidlist)
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def createWkBarChartRegUsr(request, week_no):
page_title='Weekly Bar Chart on Registered User'
weekno=week_no
fig=Figure()
ax=fig.add_subplot(111)
year=stat.getYear()
RegdUserObj = RegisteredUser.objects.filter(week=weekno).filter(year=year)
noofuserlist = list(RegdUserObj.values_list('no_of_reg_user', flat=True))
daylist = list(RegdUserObj.values_list('day', flat=True))
daylist = [day-0.4 for day in daylist]
title='Bar Graph of number of Registered User at regular days interval (week {0} {1})'.format(weekno,year)
ax.set_xlabel('Days')
ax.set_ylabel('Number of Registered User')
fig.suptitle(title, fontsize=14)
try:
ax.bar(daylist, noofuserlist);
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def createMthBarChart(request, month_no):
page_title='Monthly Bar Chart'
monthno=month_no
fig=Figure()
ax=fig.add_subplot(111)
year=stat.getYear()
onlUserObj = OnlineUser.objects.filter(month=monthno).filter(year=year)
noofuserlist = list(onlUserObj.values_list('no_of_online_user', flat=True))
daylist = list(onlUserObj.values_list('day', flat=True))
daylist = [day-0.4 for day in daylist]
monthsDict = {1 : "January", 2 : "February", 3 : "March", 4 : "April", 5 : "May",6 : "June",7 : "July",8 : "August",9 : "September",10 : "October",11 : "November",12 : "December"}
realMonth = monthsDict[int(monthno)]
title='Bar Graph of number of online user at regular days interval ({0} {1})'.format(realMonth,year)
ax.set_xlabel('Days')
ax.set_ylabel('Number of Online User')
fig.suptitle(title, fontsize=14)
try:
ax.bar(daylist, noofuserlist);
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def monthlyScatterOnlinUsrBid(request, month_no):
page_title='Monthly Scatter Diagram based on Online user verses Bid'
monthno=month_no
monthsDict = {1 : "January", 2 : "February", 3 : "March", 4 : "April", 5 : "May",6 : "June",7 : "July",8 : "August",9 : "September",10 : "October",11 : "November",12 : "December"}
realMonth = monthsDict[int(monthno)]
fig=Figure()
ax=fig.add_subplot(111)
year=stat.getYear()
onlUserObj = OnlineUser.objects.filter(month=monthno).filter(year=year)
bidObj = StatBid.objects.filter(month=monthno).filter(year=year)
onlUserlist = list(onlUserObj.values_list('no_of_online_user', flat=True))
bidlist = list(bidObj.values_list('no_of_bids', flat=True))
title='Scatter Diagram of number of online User against number of bids ({0} {1})'.format(realMonth,year)
ax.set_xlabel('Number of online Users')
ax.set_ylabel('Number of Bids')
fig.suptitle(title, fontsize=14)
try:
ax.scatter(onlUserlist, bidlist)
except ValueError:
pass
canvas = FigureCanvas(fig)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
