Math on Django Templates

Posted by Leandro Abilio on Stack Overflow See other posts from Stack Overflow or by Leandro Abilio
Published on 2012-09-02T03:30:48Z Indexed on 2012/09/02 3:38 UTC
Read the original article Hit count: 380

Here's another question about Django.

I have this code:

views.py

cursor = connections['cdr'].cursor()
calls = cursor.execute("SELECT * FROM cdr where calldate > '%s'" %(start_date))
result = [SQLRow(cursor, r) for r in cursor.fetchall()]
return render_to_response("cdr_user.html",
    {'calls':result }, context_instance=RequestContext(request))

I use a MySQL query like that because the database is not part of a django project.

My cdr table has a field called duration, I need to divide that by 60 and multiply the result by a float number like 0.16.

Is there a way to multiply this values using the template tags? If not, is there a good way to do it in my views?

My template is like this:

{% for call in calls %}
    <tr class="{% cycle 'odd' 'even' %}"><h3>
        <td valign="middle" align="center"><h3>{{ call.calldate }}</h3></td>
        <td valign="middle" align="center"><h3>{{ call.disposition }}</h3></td>
        <td valign="middle" align="center"><h3>{{ call.dst }}</h3></td>
        <td valign="middle" align="center"><h3>{{ call.billsec }}</h3></td>
        <td valign="middle" align="center">{{ (call.billsec/60)*0.16 }}</td></h3>
    </tr>
{% endfor %}

The last is where I need to show the value, I know the "(call.billsec/60)*0.16" is impossible to be done there. I wrote it just to represent what I need to show.

© Stack Overflow or respective owner

Related posts about python

Related posts about django