Welcome, guest! Login / Register - Why register?
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

Your Name: Code Language: