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