diff options
author | James Meyer <james.meyer@operamail.com> | 2011-12-07 19:40:39 (GMT) |
---|---|---|
committer | James Meyer <james.meyer@operamail.com> | 2011-12-07 19:40:39 (GMT) |
commit | f441710103513f9621672152b889bfda7f50f064 (patch) | |
tree | acbcec242d3444383c46162dd27d964c1eeac9e4 /abs/core/supplemental-web/contents/calllog.py | |
parent | f57e609997d91dbdfaa2e18b1e6e7e95876831bc (diff) | |
download | linhes_pkgbuild-f441710103513f9621672152b889bfda7f50f064.zip linhes_pkgbuild-f441710103513f9621672152b889bfda7f50f064.tar.gz linhes_pkgbuild-f441710103513f9621672152b889bfda7f50f064.tar.bz2 |
tilda, wmaker e16 settings: move /reneame to their proper place in the tree.
Diffstat (limited to 'abs/core/supplemental-web/contents/calllog.py')
-rw-r--r-- | abs/core/supplemental-web/contents/calllog.py | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/abs/core/supplemental-web/contents/calllog.py b/abs/core/supplemental-web/contents/calllog.py new file mode 100644 index 0000000..a96813e --- /dev/null +++ b/abs/core/supplemental-web/contents/calllog.py @@ -0,0 +1,66 @@ +#!/usr/bin/python +# import MySQL module + +import MySQLdb +import sys +import getopt +import socket + + +def main(argv): + grandtotal=0 + grandtotal_current=0 + db = MySQLdb.connect(host="localhost", user="mythtv", passwd="mythtv", db="ncid") + # 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() + + +#Top shows + #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;") + result = cursor.fetchall() + for row in result: + print " <tr>" + #print " <td>",row[0],"</td>" + print searchstring % (row[0], row [0]) + print " <td>",row[2],"</td>" + #print " <td>",row[1],"</td>" + print searchstring % (row[1], row [1]) + print " </tr>" + #print "%40s %26s %10s" %(row[0],row[2],row[1]) + print "</table>" + print "</div>" +#Top categorys + + + print '<br>' + print '<br>' + #print '<div id="content"> <p></p>' + print '<div> <p></p>' + print '<table class="calllog">' + print "Last 20 calls" + print '<br>' + cursor.execute("select date,time,name,number from cid order by date(ts) DESC ,time DESC limit 20 ;" ) + result = cursor.fetchall() + for row in result: + print " <tr>" + print " <td> %s </td>" %(row[0]) + print " <td>",row[1],"</td>" + #print " <td>",row[2],"</td>" + print searchstring % (row[2], row [2]) + #print " <td>",row[3],"</td>" + print searchstring % (row[3], row [3]) + print " </tr>" +# print "%26s %26s %26s %26s " %(row[0],row[1],row[2],row[3]) + print "</table>" + print "</div>" + +if __name__ == "__main__": + main(sys.argv[1:]) |