class Ui_evaluate_team(object):
def __init__(self): #initialising score window
self.scoreDialog = QtWidgets.QMainWindow()
self.score_screen = Score()
self.score_screen.setupUi(self.scoreDialog)
def setupUi(self, evaluate_team):
evaluate_team.setObjectName("evaluate_team")
evaluate_team.resize(634, 504)
evaluate_team.setStyleSheet("background-color: rgb(199, 199, 199);")
self.label = QtWidgets.QLabel(evaluate_team)
self.label.setGeometry(QtCore.QRect(90, 20, 391, 51))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(12)
self.label.setFont(font)
self.label.setObjectName("label")
self.selectteam_cb = QtWidgets.QComboBox(evaluate_team)
self.selectteam_cb.setGeometry(QtCore.QRect(90, 70, 141, 21))
self.selectteam_cb.setStyleSheet(
"background-color: rgb(255, 255, 255);\n"
"font: 75 italic 10pt \"Century Gothic\";")
self.selectteam_cb.setObjectName("selectteam_cb")
self.selectteam_cb.addItem("")
self.selectmatch_cb = QtWidgets.QComboBox(evaluate_team)
self.selectmatch_cb.setEnabled(True)
self.selectmatch_cb.setGeometry(QtCore.QRect(360, 70, 141, 22))
font = QtGui.QFont()
font.setFamily("Century Gothic")
font.setPointSize(11)
font.setBold(False)
font.setItalic(True)
font.setWeight(9)
self.selectmatch_cb.setFont(font)
self.selectmatch_cb.setStyleSheet(
"background-color: rgb(255, 255, 255);\n"
"font: 75 italic 11pt \"Century Gothic\";")
self.selectmatch_cb.setObjectName("selectmatch_cb")
self.selectmatch_cb.addItem("")
self.selectmatch_cb.addItem("")
self.line = QtWidgets.QFrame(evaluate_team)
self.line.setGeometry(QtCore.QRect(40, 95, 551, 41))
self.line.setStyleSheet("color: rgb(0, 0, 0);")
self.line.setFrameShape(QtWidgets.QFrame.HLine)
self.line.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line.setObjectName("line")
self.label_2 = QtWidgets.QLabel(evaluate_team)
self.label_2.setGeometry(QtCore.QRect(80, 160, 81, 21))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(12)
font.setBold(False)
font.setWeight(50)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.label_3 = QtWidgets.QLabel(evaluate_team)
self.label_3.setGeometry(QtCore.QRect(350, 150, 81, 21))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(12)
font.setBold(False)
font.setWeight(50)
self.label_3.setFont(font)
self.label_3.setObjectName("label_3")
self.calcscore_btn = QtWidgets.QPushButton(evaluate_team)
self.calcscore_btn.setEnabled(True)
self.calcscore_btn.setGeometry(QtCore.QRect(240, 410, 141, 31))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(10)
self.calcscore_btn.setFont(font)
self.calcscore_btn.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor))
self.calcscore_btn.setAutoDefault(False)
self.calcscore_btn.setObjectName("calcscore_btn")
self.players_lw = QtWidgets.QListWidget(evaluate_team)
self.players_lw.setGeometry(QtCore.QRect(80, 180, 191, 221))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(10)
font.setBold(True)
font.setWeight(75)
self.players_lw.setFont(font)
self.players_lw.setStyleSheet("background-color: rgb(255, 255, 255);")
self.players_lw.setVerticalScrollBarPolicy(QtCore.Qt.ScrollBarAlwaysOn)
self.players_lw.setDefaultDropAction(QtCore.Qt.IgnoreAction)
self.players_lw.setSelectionMode(
QtWidgets.QAbstractItemView.NoSelection)
self.players_lw.setObjectName("players_lw")
self.scores_lw = QtWidgets.QListWidget(evaluate_team)
self.scores_lw.setGeometry(QtCore.QRect(340, 180, 191, 221))
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(10)
font.setBold(True)
font.setWeight(75)
self.scores_lw.setFont(font)
self.scores_lw.setStyleSheet("background-color: rgb(255, 255, 255);")
self.scores_lw.setVerticalScrollBarPolicy(QtCore.Qt.ScrollBarAlwaysOn)
self.scores_lw.setSelectionMode(
QtWidgets.QAbstractItemView.NoSelection)
self.scores_lw.setObjectName("scores_lw")
self.retranslateUi(evaluate_team)
QtCore.QMetaObject.connectSlotsByName(evaluate_team)
self.calcscore_btn.clicked.connect(self.final_score)
selected_team = self.selectteam_cb.currentText()
self.changedname(selected_team)
self.selectteam_cb.currentTextChanged.connect(self.changedname)
def retranslateUi(self, evaluate_team):
_translate = QtCore.QCoreApplication.translate
evaluate_team.setWindowTitle(_translate("evaluate_team", "Dialog"))
self.label.setText(
_translate("evaluate_team",
"Evaluate the Performance of your Fantasy Team"))
self.selectteam_cb.setCurrentText(
_translate("evaluate_team", "Select team"))
self.selectteam_cb.setItemText(
0, _translate("evaluate_team", "Select team"))
self.selectmatch_cb.setItemText(
0, _translate("evaluate_team", "select match"))
self.selectmatch_cb.setItemText(1, _translate("evaluate_team",
"Match1"))
self.label_2.setText(_translate("evaluate_team", "Players"))
self.label_3.setText(_translate("evaluate_team", "Points"))
self.calcscore_btn.setStatusTip(
_translate("evaluate_team", "calculating score"))
self.calcscore_btn.setText(
_translate("evaluate_team", "Calculate Score"))
x = matchcur.execute("SELECT DISTINCT name from teams;")
team = x.fetchall()
for i in team:
self.selectteam_cb.addItem(i[0])
def changedname(self, t):
self.players_lw.clear()
self.scores_lw.clear()
y = matchcur.execute("SELECT players from teams WHERE name='" + t +
"';")
player = y.fetchall()
# print('player',player)
for j in player:
self.players_lw.addItem(j[0])
z = matchcur.execute("SELECT value from teams WHERE name='" + t + "';")
value = z.fetchall()
for k in value:
self.scores_lw.addItem(str(k[0]))
def final_score(self):
total_score = 0
t = self.selectteam_cb.currentText() # current teamname
# print(t)
z = matchcur.execute("SELECT value from teams WHERE name='" + t + "';")
value = z.fetchall()
# print('value', value)
for k in value:
total_score += k[0]
self.score_screen.finalscore.setText(str(
total_score)) # opening score dialog box and setting final score
self.scoreDialog.show()
def __init__(self): #initialising score window
self.scoreDialog = QtWidgets.QMainWindow()
self.score_screen = Score()
self.score_screen.setupUi(self.scoreDialog)
class Ui_Dialog(object):
def __init__(self):
self.scoreDialog = QtWidgets.QMainWindow
self.score_screen = Score()
self.score_screen.setupUi(self.scoreDialog)
def setupUi(self, Dialog):
Dialog.setObjectName("Dialog")
Dialog.resize(761, 634)
self.frame = QtWidgets.QFrame(Dialog)
self.frame.setGeometry(QtCore.QRect(50, 200, 211, 291))
self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame.setObjectName("frame")
self.listWidget1 = QtWidgets.QListWidget(self.frame)
self.listWidget1.setGeometry(QtCore.QRect(0, 0, 211, 291))
self.listWidget1.setObjectName("listWidget1")
self.verticalScrollBar1 = QtWidgets.QScrollBar(self.frame)
self.verticalScrollBar1.setGeometry(QtCore.QRect(190, 0, 21, 291))
self.verticalScrollBar1.setOrientation(QtCore.Qt.Vertical)
self.verticalScrollBar1.setObjectName("verticalScrollBar1")
self.frame_2 = QtWidgets.QFrame(Dialog)
self.frame_2.setGeometry(QtCore.QRect(370, 200, 211, 281))
self.frame_2.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_2.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_2.setObjectName("frame_2")
self.listWidget_2 = QtWidgets.QListWidget(self.frame_2)
self.listWidget_2.setGeometry(QtCore.QRect(0, 0, 211, 281))
self.listWidget_2.setObjectName("listWidget_2")
self.verticalScrollBar_2 = QtWidgets.QScrollBar(self.frame_2)
self.verticalScrollBar_2.setGeometry(QtCore.QRect(190, 0, 21, 281))
self.verticalScrollBar_2.setOrientation(QtCore.Qt.Vertical)
self.verticalScrollBar_2.setObjectName("verticalScrollBar_2")
self.calculatescore = QtWidgets.QPushButton(Dialog)
self.calculatescore.setGeometry(QtCore.QRect(250, 510, 191, 61))
self.calculatescore.setStyleSheet("font: 75 14pt \"Arial\";")
self.calculatescore.setObjectName("calculatescore")
self.frame_3 = QtWidgets.QFrame(Dialog)
self.frame_3.setGeometry(QtCore.QRect(50, 30, 531, 121))
self.frame_3.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_3.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_3.setObjectName("frame_3")
self.ET = QtWidgets.QLabel(self.frame_3)
self.ET.setGeometry(QtCore.QRect(60, 20, 451, 21))
self.ET.setStyleSheet("font: 75 14pt \"Arial\";\n"
"font: 75 16pt \"Arial\";")
self.ET.setObjectName("ET")
self.comboBox1 = QtWidgets.QComboBox(self.frame_3)
self.comboBox1.setGeometry(QtCore.QRect(50, 50, 181, 22))
self.comboBox1.setObjectName("comboBox1")
self.comboBox_2 = QtWidgets.QComboBox(self.frame_3)
self.comboBox_2.setGeometry(QtCore.QRect(330, 50, 171, 22))
self.comboBox_2.setObjectName("comboBox_2")
self.comboBox_2.addItem("")
self.players = QtWidgets.QLabel(Dialog)
self.players.setGeometry(QtCore.QRect(50, 175, 61, 21))
self.players.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";\n"
"font: 75 12pt \"MS Shell Dlg 2\";")
self.players.setObjectName("players")
self.points = QtWidgets.QLabel(Dialog)
self.points.setGeometry(QtCore.QRect(370, 180, 47, 13))
self.points.setStyleSheet("font: 75 12pt \"MS Shell Dlg 2\";")
self.points.setObjectName("points")
self.retranslateUi(Dialog)
QtCore.QMetaObject.connectSlotsByName(Dialog)
self.calcscore_btn.clicked.connect(self.final_score)
selected_team = self.selectteam_cb.currentText()
self.changedname(selected_team)
self.selectteam_cb.currentTextChanged.connect(self.changedname)
def retranslateUi(self, Dialog):
_translate = QtCore.QCoreApplication.translate
Dialog.setWindowTitle(_translate("Dialog", "Dialog"))
self.calculatescore.setText(_translate("Dialog", "Calculate Score"))
self.ET.setText(
_translate("Dialog",
"Evaluate the performance of your fantasy Team"))
self.comboBox_2.setItemText(0, _translate("Dialog", "match"))
self.players.setText(_translate("Dialog", "Players"))
self.points.setText(_translate("Dialog", "Points"))
self.calcscore_btn.setStatusTip(
_translate("Dialog", "calculating score"))
self.calcscore_btn.setText(_translate("Dialog", "Calculate Score"))
x = matchcur.execute("SELECT DISTINCT name from teams;")
team = x.fetchall()
for i in team:
self.selectteam_cb.addItem(i[0])
def changedname(self, t):
self.players_lw.clear()
self.scores_lw.clear()
y = matchcur.execute("SELECT players from teams WHERE name='" + t +
"';")
player = y.fetchall()
for j in player:
self.players_lw.addItem(j[0])
z = matchcur.execute("SELECT value from teams WHERE name='" + t + "';")
value = z.fetchall()
for k in value:
self.scores_lw.addItem(str(k[0]))
def final_score(self):
total_score = 0
t = self.selectteam_cb.currentText()
z = matchcur.execute("SELECT value from teams WHERE name='" + t + "';")
value = z.fetchall()
for k in value:
total_score += k[0]
self.score_screen.finalscore.setText(str(total_score))
self.scoreDialog.show()