1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
#!/usr/bin/python2
# 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 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" 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 " <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>"
#last 20 calls
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:])
|