#!/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:])