diff options
Diffstat (limited to 'abs/core/supplemental-web/contents/calllog.py')
| -rw-r--r-- | abs/core/supplemental-web/contents/calllog.py | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/abs/core/supplemental-web/contents/calllog.py b/abs/core/supplemental-web/contents/calllog.py index a96813e..0b2fb22 100644 --- a/abs/core/supplemental-web/contents/calllog.py +++ b/abs/core/supplemental-web/contents/calllog.py @@ -1,4 +1,4 @@ -#!/usr/bin/python +#!/usr/bin/python2 # import MySQL module import MySQLdb @@ -14,32 +14,32 @@ def main(argv): # create a cursor cursor = db.cursor() # execute SQL statement - cursor.execute("select name,number,count(number) as '# calls' from cid group by number,name order by '# calls' DESC limit 20;") - result = cursor.fetchall() + # cursor.execute("select name,number,count(number) as '# calls' from cid group by number,name order by '# calls' DESC limit 20;") + # result = cursor.fetchall() + - -#Top shows + #Top 20 callers #print '<div id="content"> <p></p>' print '<div> <p></p>' print '<table class="calllog">' print "Top 20 callers" - searchstring='''<td> <a href="http://www.google.com/search?q=%s" > %s </a> </td> ''' - cursor.execute("select name,number,count(number) as '# calls' from cid group by number,name order by '# calls' DESC limit 20;") + searchstring='''<td> <a href="http://www.google.com/search?q=%s" target="_blank" > %s </a> </td> ''' + cursor.execute("select name,number,count(number) from cid group by number,name order by count(number) DESC limit 20;") result = cursor.fetchall() for row in result: print " <tr>" #print " <td>",row[0],"</td>" - print searchstring % (row[0], row [0]) + print searchstring % (row[0], row [0]) print " <td>",row[2],"</td>" #print " <td>",row[1],"</td>" - print searchstring % (row[1], row [1]) + print searchstring % (row[1], row [1]) print " </tr>" #print "%40s %26s %10s" %(row[0],row[2],row[1]) print "</table>" print "</div>" -#Top categorys - + + #last 20 calls print '<br>' print '<br>' #print '<div id="content"> <p></p>' @@ -54,9 +54,9 @@ def main(argv): print " <td> %s </td>" %(row[0]) print " <td>",row[1],"</td>" #print " <td>",row[2],"</td>" - print searchstring % (row[2], row [2]) + print searchstring % (row[2], row [2]) #print " <td>",row[3],"</td>" - print searchstring % (row[3], row [3]) + print searchstring % (row[3], row [3]) print " </tr>" # print "%26s %26s %26s %26s " %(row[0],row[1],row[2],row[3]) print "</table>" |