Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so dont bother with any of their useless mail servers here and just use oauth login instead. Thank the nice Russians for causing that. :)
Paste
Pasted as Plain Text by Bishnu ( 13 years ago )
views.py includes
def graph(request):
age = ['below 20', '20-22','22-24','24-26','26-28','28-30','30-40','above 40']
avg_call_group = [0, 0, 0, 0, 0, 0, 0, 0]
cursor = connection.cursor()
cursor.execute("select p.age_group,sum(c.avg_duration) as age_avg_dur from demo p,(select card_no as card_n, avg(duration) as avg_duration from call_details where service_key = 1 and card_no =calling_no group by card_no) as c where p.card_no = c.card_n group by p.age_group ")
numrows = int(cursor.rowcount)
for x in range(numrows):
row = cursor.fetchone()
avg_call_group[x] = row[1]
cursor.close()
import matplotlib.pyplot as plt
f=plt.figure(figsize = (3,3))
exploding = [.04, .04, .04, .04 , .04, .04, .04, .04]
age = ['below 20', '20-22','22-24','24-26','26-28','28-30','30-40','40-50']
plt.pie(avg_call_group, labels= age, autopct='%1.3f%%', explode = exploding)
canvas = FigureCanvasAgg(f)
response = HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
urls.py includes
from django.conf.urls import patterns, include, url
from welcome.views import *
from django.contrib import admin
admin.autodiscover()
urlpatterns = patterns('',
url(r'^admin/', include(admin.site.urls)),
url(r'^hello/', hello, name = 'nhello'),
url(r'^graph/', graph, name = 'ngraph'),
)
home.html includes
<div >
<a href = "{% url 'ngraph' %}">Customer Count</a>
</div>
Revise this Paste