linhes-web: initial inclusion

1 files changed, 66 insertions, 0 deletions

diff --git a/linhes/linhes-web/website/contents/calllog.py b/linhes/linhes-web/website/contents/calllog.py
new file mode 100644
index 0000000..0b2fb22
--- /dev/null
+++ b/linhes/linhes-web/website/contents/calllog.py
@@ -0,0 +1,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:])