#! /usr/bin/env python
# Created by Paul Johnson
# CSCI 3287 Project #2

from Tkinter import *
import tkMessageBox
import sys
import string
import MySQLdb

totalpoints = 0

class GUIFramework(Frame):
    def __init__(self,master=None):
        Frame.__init__(self,master)
        
        self.master.title("Fantasy Football Score Entry")
        self.grid(padx=70,pady=40)
        self.formCreation()
       
    def formCreation(self):
        self.textDesc = Label(self, text="Player Name:")
        self.textDesc.grid(row=0, column=0)
        self.textDesc = Label(self, text="Touchdowns")
        self.textDesc.grid(row=1, column=0)
        self.textDesc = Label(self, text="Interceptions")
        self.textDesc.grid(row=2, column=0)
        self.textDesc = Label(self, text="Fumbles")
        self.textDesc.grid(row=3, column=0)
        self.textDesc = Label(self, text="Yards")
        self.textDesc.grid(row=4, column=0)
        self.textDesc = Label(self, text="PK:")
        self.textDesc.grid(row=5, column=0)
        self.textDesc = Label(self, text="Field Goals")
        self.textDesc.grid(row=6, column=0)

        self.textBox1 = Entry(self)
        self.textBox1.grid(row=0, column=2, columnspan=2)
        self.textBox2 = Entry(self)
        self.textBox2.grid(row=1, column=2, columnspan=2)
        self.textBox3 = Entry(self)
        self.textBox3.grid(row=2, column=2, columnspan=2)
        self.textBox4 = Entry(self)
        self.textBox4.grid(row=3, column=2, columnspan=2)
        self.textBox5 = Entry(self)
        self.textBox5.grid(row=4, column=2, columnspan=2)
        self.textBox6 = Entry(self)
        self.textBox6.grid(row=5, column=2, columnspan=2)
        self.textBox7 = Entry(self)
        self.textBox7.grid(row=6, column=2, columnspan=2)

        self.btnDisplay = Button(self, text="Find Point Total", command=self.Display)
        self.btnDisplay.grid(row=7, column=2)
        
    def Display(self):        
	string1 = self.textBox1.get()
	string2 = self.textBox2.get()
	string3 = self.textBox3.get()
	string4 = self.textBox4.get()
	string5 = self.textBox5.get()
	string6 = self.textBox6.get()
	string7 = self.textBox7.get()

	master = Tk()
	listbox = Listbox(master)
	listbox.pack()
	conn = MySQLdb.connect(db="football",host="localhost",user="root",passwd="root");
	cursor = conn.cursor()
        cursor.execute("CREATE TABLE IF NOT EXISTS Players ( Name varchar(50), Touchdowns int, Interceptions int, Fumbles int, Yards int, PK int, FieldGoals int, Points int, PRIMARY KEY(Name))")
        cursor.execute("INSERT INTO Players (Name, Touchdowns, Interceptions, Fumbles, Yards, PK, FieldGoals, Points) values (%s, %s, %s, %s, %s, %s, %s, %s)", (string1, string2, string3, string4, string5, string6, string7, string7) );
        cursor.execute("SELECT * FROM Players WHERE Name = %s", (string1) );
        rows = cursor.fetchall()
        for row in rows:
                row1 = string.atof(row[1])
                row2 = string.atof(row[2])
                row3 = string.atof(row[3])
                row4 = string.atof(row[4])
                row5 = string.atof(row[5])
                row6 = string.atof(row[6])
                points = row1*4 + row2*(-2) + row3*(-2) + row4/10 + row5 + row6*3
                print "%s 	%s	%s 	%s 	%s 	%s	%s	%s" % (row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7])
                curs = conn.cursor()
                curs.execute("UPDATE Players SET Points = %s WHERE Name = %s ", (points, row[0]) )
                global totalpoints
                totalpoints = totalpoints + points
                pointsstring = "Player's Points:"
                totalpointsstring = "Total Points:"
                listbox.insert(END, string1, pointsstring, points, totalpointsstring, totalpoints)
    
        cursor.close()
        conn.commit()
        conn.close()
        mainloop()

if __name__ == "__main__":
    guiFrame = GUIFramework()
    guiFrame.mainloop()