class MainWindow(QDialog):
def __init__(self):
super(MainWindow, self).__init__()
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.bt = self.ui.pushButton
self.bt.clicked.connect(self.getfile)
def getfile(self):
fpath = QFileDialog.getOpenFileName(self, 'Otwórz plik', 'c:\\',
"Pliki Excel (*.xlsx *.xlsm)")
print(fpath[0])
print(ntpath.basename(fpath[0]))
def __init__(self):
self.newDialog = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.newDialog)
self.EvaluateWindow = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.EvaluateWindow)
self.openDialog = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.openDialog)
def __init__(self): # linking files and creating objects self.new_Window = QtWidgets.QMainWindow() self.new_screen = New() self.new_screen.setupUi(self.new_Window) self.evaluate_Window = QtWidgets.QMainWindow() self.eval_screen = Eva() self.eval_screen.setupUi(self.evaluate_Window) self.open_Window = QtWidgets.QMainWindow() self.open_screen = Open() self.open_screen.setupUi(self.open_Window)
class Ui_MainWindow(object):
def __init__(self):
self.newDialog = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.newDialog)
self.EvaluateWindow = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.EvaluateWindow)
self.openDialog = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.openDialog)
# FILE OPENING MENU
def file_open(self):
self.open_screen.setupUi(self.openDialog)
self.openDialog.show()
self.open_screen.openbtn.clicked.connect(self.openteam)
# EVALUATE TEAM MENU
def file_evaluate(self):
self.eval_screen.setupUi(self.EvaluateWindow)
self.EvaluateWindow.show()
def setupUi(self, MainWindow):
# INITIALISING POINTS AND COUNTS
self.avail_points = 1000
self.used_points = 0
self.totalcount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.alrdscount = 0
self.wicketerscount = 0
# INITIALIZING LISTS
self.a = [] # bowler names list
self.b = [] # batsman nameslist
self.c = [] # allrounder names list
self.d = [] #wicketer names list
self.list1 = [] # selectedplayer's list
MainWindow.setObjectName("MainWindow")
MainWindow.resize(556, 523)
MainWindow.setStyleSheet("background-color: rgb(255, 255, 255);")
self.central_w = QtWidgets.QWidget(MainWindow)
self.central_w.setObjectName("central_w")
self.verticalLayout_3 = QtWidgets.QVBoxLayout(self.central_w)
self.verticalLayout_3.setObjectName("verticalLayout_3")
spacerItem = QtWidgets.QSpacerItem(20, 40,
QtWidgets.QSizePolicy.Minimum,
QtWidgets.QSizePolicy.Preferred)
self.verticalLayout_3.addItem(spacerItem)
self.frame = QtWidgets.QFrame(self.central_w)
self.frame.setStyleSheet("background-color: rgb(241, 235, 255);\n"
"font: 75 10pt \"MS Shell Dlg 2\";\n"
"")
self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame.setObjectName("frame")
self.gridLayout = QtWidgets.QGridLayout(self.frame)
self.gridLayout.setContentsMargins(-1, 5, -1, 24)
self.gridLayout.setObjectName("gridLayout")
self.BAT = QtWidgets.QLabel(self.frame)
self.BAT.setStyleSheet("color: rgb(0, 170, 255);")
self.BAT.setObjectName("BAT")
self.gridLayout.addWidget(self.BAT, 1, 1, 1, 1)
self.label_2 = QtWidgets.QLabel(self.frame)
self.label_2.setObjectName("label_2")
self.gridLayout.addWidget(self.label_2, 1, 0, 1, 1)
self.WK = QtWidgets.QLabel(self.frame)
self.WK.setStyleSheet("color: rgb(0, 170, 255);")
self.WK.setObjectName("WK")
self.gridLayout.addWidget(self.WK, 1, 7, 1, 1)
self.label_4 = QtWidgets.QLabel(self.frame)
self.label_4.setObjectName("label_4")
self.gridLayout.addWidget(self.label_4, 1, 2, 1, 1)
self.label_10 = QtWidgets.QLabel(self.frame)
self.label_10.setObjectName("label_10")
self.gridLayout.addWidget(self.label_10, 1, 4, 1, 1)
self.ARL = QtWidgets.QLabel(self.frame)
self.ARL.setStyleSheet("color: rgb(0, 170, 255);")
self.ARL.setObjectName("ARL")
self.gridLayout.addWidget(self.ARL, 1, 5, 1, 1)
self.BOWL = QtWidgets.QLabel(self.frame)
self.BOWL.setStyleSheet("color: rgb(0, 170, 255);")
self.BOWL.setObjectName("BOWL")
self.gridLayout.addWidget(self.BOWL, 1, 3, 1, 1)
self.label_12 = QtWidgets.QLabel(self.frame)
self.label_12.setObjectName("label_12")
self.gridLayout.addWidget(self.label_12, 1, 6, 1, 1)
self.label = QtWidgets.QLabel(self.frame)
self.label.setStyleSheet("\n" "font: italic 9pt \"Comic Sans MS\";")
self.label.setObjectName("label")
self.gridLayout.addWidget(self.label, 0, 0, 1, 1)
self.verticalLayout_3.addWidget(self.frame)
self.frame_2 = QtWidgets.QFrame(self.central_w)
self.frame_2.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";\n"
"border-color: rgb(255, 255, 255);")
self.frame_2.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_2.setFrameShadow(QtWidgets.QFrame.Plain)
self.frame_2.setLineWidth(0)
self.frame_2.setObjectName("frame_2")
self.horizontalLayout = QtWidgets.QHBoxLayout(self.frame_2)
self.horizontalLayout.setContentsMargins(46, 8, 23, 5)
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_6 = QtWidgets.QLabel(self.frame_2)
self.label_6.setStyleSheet("font: 75 9pt \"MS Shell Dlg 2\";")
self.label_6.setObjectName("label_6")
self.horizontalLayout.addWidget(self.label_6)
self.points_available = QtWidgets.QLabel(self.frame_2)
self.points_available.setStyleSheet("color: rgb(85, 170, 255);")
self.points_available.setObjectName("points_available")
self.horizontalLayout.addWidget(self.points_available)
self.label_7 = QtWidgets.QLabel(self.frame_2)
self.label_7.setObjectName("label_7")
self.horizontalLayout.addWidget(self.label_7, 0, QtCore.Qt.AlignRight)
self.points_used = QtWidgets.QLabel(self.frame_2)
self.points_used.setStyleSheet("color: rgb(85, 170, 255);")
self.points_used.setObjectName("points_used")
self.horizontalLayout.addWidget(self.points_used, 0,
QtCore.Qt.AlignHCenter)
self.verticalLayout_3.addWidget(self.frame_2)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
spacerItem1 = QtWidgets.QSpacerItem(13, 345,
QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem1)
self.frame_3 = QtWidgets.QFrame(self.central_w)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(
self.frame_3.sizePolicy().hasHeightForWidth())
self.frame_3.setSizePolicy(sizePolicy)
self.frame_3.setStyleSheet("border-color: rgb(15, 15, 15);")
self.frame_3.setFrameShape(QtWidgets.QFrame.Box)
self.frame_3.setFrameShadow(QtWidgets.QFrame.Sunken)
self.frame_3.setLineWidth(2)
self.frame_3.setMidLineWidth(1)
self.frame_3.setObjectName("frame_3")
self.verticalLayout = QtWidgets.QVBoxLayout(self.frame_3)
self.verticalLayout.setContentsMargins(19, -1, 19, -1)
self.verticalLayout.setObjectName("verticalLayout")
self.frame_5 = QtWidgets.QFrame(self.frame_3)
self.frame_5.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";")
self.frame_5.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_5.setFrameShadow(QtWidgets.QFrame.Sunken)
self.frame_5.setObjectName("frame_5")
self.horizontalLayout_2 = QtWidgets.QHBoxLayout(self.frame_5)
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.bat_rb = QtWidgets.QRadioButton(self.frame_5) # bat_rb
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(
self.bat_rb.sizePolicy().hasHeightForWidth())
self.bat_rb.setSizePolicy(sizePolicy)
self.bat_rb.setEnabled(False)
self.bat_rb.setTabletTracking(False)
self.bat_rb.setAcceptDrops(False)
self.bat_rb.setObjectName("bat_rb")
self.horizontalLayout_2.addWidget(self.bat_rb)
self.bow_rb = QtWidgets.QRadioButton(self.frame_5) #bat_rb
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
self.bow_rb.setEnabled(False)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(
self.bow_rb.sizePolicy().hasHeightForWidth())
self.bow_rb.setSizePolicy(sizePolicy)
self.bow_rb.setObjectName("bow_rb")
self.horizontalLayout_2.addWidget(self.bow_rb)
self.ar_rb = QtWidgets.QRadioButton(self.frame_5) #ar_rb
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(
self.ar_rb.sizePolicy().hasHeightForWidth())
self.ar_rb.setSizePolicy(sizePolicy)
self.ar_rb.setEnabled(False)
self.ar_rb.setObjectName("ar_rb")
self.horizontalLayout_2.addWidget(self.ar_rb)
self.wk_rb = QtWidgets.QRadioButton(self.frame_5) #wk_rb
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
self.wk_rb.setEnabled(False)
sizePolicy.setHeightForWidth(
self.wk_rb.sizePolicy().hasHeightForWidth())
self.wk_rb.setSizePolicy(sizePolicy)
self.wk_rb.setObjectName("wk_rb")
self.horizontalLayout_2.addWidget(self.wk_rb)
self.verticalLayout.addWidget(self.frame_5) #available_players
self.av_player = QtWidgets.QListWidget(self.frame_3)
self.av_player.setFrameShape(QtWidgets.QFrame.NoFrame)
self.av_player.setObjectName("av_player")
self.verticalLayout.addWidget(self.av_player)
self.horizontalLayout_4.addWidget(self.frame_3)
spacerItem2 = QtWidgets.QSpacerItem(13, 345,
QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem2)
self.label_9 = QtWidgets.QLabel(self.central_w)
self.label_9.setStyleSheet("font: 20pt \"MS Shell Dlg 2\";")
self.label_9.setLineWidth(-10)
self.label_9.setMidLineWidth(-10)
self.label_9.setObjectName("label_9")
self.horizontalLayout_4.addWidget(self.label_9)
spacerItem3 = QtWidgets.QSpacerItem(13, 345,
QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem3)
self.frame_4 = QtWidgets.QFrame(self.central_w)
self.frame_4.setFrameShape(QtWidgets.QFrame.Box)
self.frame_4.setFrameShadow(QtWidgets.QFrame.Sunken)
self.frame_4.setLineWidth(2)
self.frame_4.setMidLineWidth(1)
self.frame_4.setObjectName("frame_4")
self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.frame_4)
self.verticalLayout_2.setContentsMargins(18, 9, 14, -1)
self.verticalLayout_2.setSpacing(6)
self.verticalLayout_2.setObjectName("verticalLayout_2")
self.frame_6 = QtWidgets.QFrame(self.frame_4)
self.frame_6.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";")
self.frame_6.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_6.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_6.setObjectName("frame_6")
self.horizontalLayout_3 = QtWidgets.QHBoxLayout(self.frame_6)
self.horizontalLayout_3.setObjectName("horizontalLayout_3")
self.label_8 = QtWidgets.QLabel(self.frame_6)
self.label_8.setObjectName("label_8")
self.horizontalLayout_3.addWidget(self.label_8, 0,
QtCore.Qt.AlignHCenter)
self.team_name = QtWidgets.QLabel(self.frame_6)
self.team_name.setStyleSheet("color: rgb(85, 170, 255);")
self.team_name.setObjectName("team_name")
self.horizontalLayout_3.addWidget(self.team_name)
self.verticalLayout_2.addWidget(self.frame_6) #select_players
self.sel_player = QtWidgets.QListWidget(self.frame_4)
self.sel_player.setFrameShape(QtWidgets.QFrame.NoFrame)
self.sel_player.setObjectName("sel_player")
self.verticalLayout_2.addWidget(self.sel_player)
self.horizontalLayout_4.addWidget(self.frame_4)
spacerItem4 = QtWidgets.QSpacerItem(13, 345,
QtWidgets.QSizePolicy.Preferred,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem4)
self.verticalLayout_3.addLayout(self.horizontalLayout_4)
MainWindow.setCentralWidget(self.central_w)
self.menubar = QtWidgets.QMenuBar(MainWindow) #Menubar
self.menubar.setGeometry(QtCore.QRect(0, 0, 556, 21))
self.menubar.setObjectName("menubar")
self.menuManage_Teams = QtWidgets.QMenu(self.menubar)
self.menuManage_Teams.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor))
self.menuManage_Teams.setStyleSheet("color: rgb(0, 170, 255);")
self.menuManage_Teams.setStyleSheet(
"background-color: rgb(232, 232, 232);")
self.menuManage_Teams.setStyleSheet(
"selection-background-color: rgb(0, 170, 255);\n"
"\n"
"")
self.menuManage_Teams.setObjectName("menuManage_Teams")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
self.new_t = QtWidgets.QAction(MainWindow) #new window
self.new_t.setIconText("NEW Team")
self.new_t.setShortcut("Ctrl+N")
self.new_t.setShortcutContext(QtCore.Qt.WindowShortcut)
self.new_t.setVisible(True)
self.new_t.setShortcutVisibleInContextMenu(True)
self.new_t.setObjectName("new_t")
self.open_t = QtWidgets.QAction(MainWindow) #open team
self.open_t.setObjectName("open_t")
self.save_t = QtWidgets.QAction(MainWindow) #save team
self.save_t.setObjectName("save_t")
self.evaluate_t = QtWidgets.QAction(MainWindow) #EVALUATETEAM
self.evaluate_t.setObjectName("evaluate_t")
self.actionQuit = QtWidgets.QAction(MainWindow) # Quitwindow
self.actionQuit.setObjectName("actionQuit")
self.actionQuit.triggered.connect(self.quit)
self.menuManage_Teams.addAction(self.new_t)
self.menuManage_Teams.addAction(self.open_t)
self.menuManage_Teams.addAction(self.save_t)
self.menuManage_Teams.addAction(self.evaluate_t)
self.menuManage_Teams.addAction(self.actionQuit)
self.menubar.addAction(self.menuManage_Teams.menuAction())
#Action teiggered
self.new_t.triggered.connect(self.file_new)
self.open_t.triggered.connect(self.file_open)
self.save_t.triggered.connect(self.file_save)
self.evaluate_t.triggered.connect(self.file_evaluate)
self.actionQuit.triggered.connect(self.quit)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
# DOUBLE CLICK
self.av_player.itemDoubleClicked.connect(self.removelist1)
self.sel_player.itemDoubleClicked.connect(self.removelist2)
# -----stats of player
self.stats = {}
self.new_screen.savename.clicked.connect(self.namechange)
# RADIOBUTTONS CLICK
self.bat_rb.clicked.connect(self.load_names)
self.wk_rb.clicked.connect(self.load_names)
self.bow_rb.clicked.connect(self.load_names)
self.ar_rb.clicked.connect(self.load_names)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.BAT.setText(_translate("MainWindow", "##"))
self.label_2.setText(_translate("MainWindow", "Batsman (BAT)"))
self.WK.setText(_translate("MainWindow", "##"))
self.label_4.setText(_translate("MainWindow", "Bowlers (BOW)"))
self.label_10.setText(_translate("MainWindow", "AllRounders (AR) "))
self.ARL.setText(_translate("MainWindow", "##"))
self.BOWL.setText(_translate("MainWindow", "##"))
self.label_12.setText(_translate("MainWindow", "Wicket-Keeper (WK)"))
self.label.setText(_translate("MainWindow", "Your Selection"))
self.label_6.setText(_translate("MainWindow", "Points Availables"))
self.points_available.setText(_translate("MainWindow", "####"))
self.label_7.setText(_translate("MainWindow", "Points Used"))
self.points_used.setText(_translate("MainWindow", "####"))
self.bat_rb.setText(_translate("MainWindow", "BAT"))
self.bow_rb.setText(_translate("MainWindow", "BOW"))
self.ar_rb.setText(_translate("MainWindow", "AR"))
self.wk_rb.setText(_translate("MainWindow", "WK"))
self.label_9.setText(_translate("MainWindow", ">"))
self.label_8.setText(_translate("MainWindow", "Team Name :"))
self.team_name.setText(_translate("MainWindow", "Displayed Here"))
self.menuManage_Teams.setTitle(_translate("MainWindow",
"Manage Teams"))
self.new_t.setText(_translate("MainWindow", "NEW Team"))
self.new_t.setShortcut(_translate("MainWindow", "Ctrl+N"))
self.open_t.setText(_translate("MainWindow", "OPEN Team"))
self.open_t.setShortcut(_translate("MainWindow", "Ctrl+O"))
self.save_t.setText(_translate("MainWindow", "SAVE team"))
self.save_t.setShortcut(_translate("MainWindow", "Ctrl+S"))
self.evaluate_t.setText(_translate("MainWindow", "EVALUATE Team"))
self.evaluate_t.setShortcut(_translate("MainWindow", "Ctrl+E"))
self.actionQuit.setText(_translate("MainWindow", "QUIT"))
# NEW FILE MENU
def file_new(self):
self.newDialog.show()
def namechange(self):
teamname = self.new_screen.team_name.text()
fantcurs.execute("SELECT DISTINCT name FROM teams")
l = fantcurs.fetchall()
for i in l:
if i[0] == teamname:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Information)
msg.setText(
"Team with same name already exists!!\nPlease choose another name"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
if len(teamname) == 0:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("You cannot leave the field blank!!!")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
elif teamname.isnumeric():
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText(
"Please enter a valid teamname\n(Name must contain atleast one character)!!"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
else:
self.reset()
self.tname = self.new_screen.team_name.text()
self.team_name.setText(str(' ' + self.tname))
self.newDialog.close()
#TO RESET ALL COUNTS AND LITS
def reset(self):
self.enablebuttons()
self.load_names()
self.used_points = 0
self.alrdscount = 0
self.wicketerscount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.totalcount = 0
self.avail_points = 1000
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
self.list1.clear()
self.load_names()
self.sel_player.clear()
#SAVE TEAM MENU
def file_save(self):
if not self.error(): #IF THERE IS AN ERROR
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Inufficient Players OR Points !!')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
elif self.error(): # IF NO ERROR
try:
fantcurs.execute("SELECT DISTINCT name FROM teams;")
x = fantcurs.fetchall()
for i in x:
if self.team_name.text(
) == i[0]: # CHECKING IF THE TEAMNAME ALREADY EXISTS
print('Updating already there')
fantcurs.execute("DELETE FROM teams WHERE name='" +
self.team_name.text() +
"';") #DELETING TO UPDATE TEAM
except:
print('error')
for i in range(self.sel_player.count()):
# print('----addding--')
# print('teamnane: ',self.team_name.text())
# print('playername: ',self.list1[i])
# print('points: ', player_points[self.list1[i]])
try:
fantcurs.execute(
"INSERT INTO teams (name,players,value) VALUES (?,?,?)",
(self.team_name.text(), self.list1[i],
player_points[self.list1[i]]))
# self.file_evaluate()
except:
print('error in operation!')
fant.commit()
else:
print('---error in operation')
# QUITING METHOD
def quit(self):
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Bye Bye')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
# print('exit')
sys.exit()
#ON RADIOBUTTONS CLICKED
def load_names(self):
Batsman = 'BAT'
WicketKeeper = 'WK'
Allrounder = 'AR'
Bowler = 'BWL'
sql1 = "SELECT player,value from stats WHERE ctg = '" + Batsman + "';"
sql2 = "SELECT Player,value from stats WHERE ctg = '" + WicketKeeper + "';"
sql3 = "SELECT Player,value from stats WHERE ctg ='" + Allrounder + "';"
sql4 = "SELECT Player,value from stats WHERE ctg = '" + Bowler + "';"
fantcurs.execute(sql1)
x = fantcurs.fetchall()
fantcurs.execute(sql4)
y = fantcurs.fetchall()
fantcurs.execute(sql3)
z = fantcurs.fetchall()
fantcurs.execute(sql2)
w = fantcurs.fetchall()
batsmen = []
bowlers = []
allrounders = []
wcktkeepers = []
for k in x:
batsmen.append(k[0])
self.b.append(k[0])
self.stats[k[0]] = k[1]
for k in y:
bowlers.append(k[0])
self.stats[k[0]] = k[1]
self.a.append(k[0])
for k in w:
wcktkeepers.append(k[0])
self.stats[k[0]] = k[1]
self.d.append(k[0])
for k in z:
allrounders.append(k[0])
self.stats[k[0]] = k[1]
self.c.append(k[0])
for i in self.list1:
if i in allrounders:
allrounders.remove(i)
elif i in batsmen:
batsmen.remove(i)
elif i in bowlers:
bowlers.remove(i)
elif i in wcktkeepers:
wcktkeepers.remove(i)
if self.bat_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(batsmen)):
item = QtWidgets.QListWidgetItem(batsmen[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.bow_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(bowlers)):
item = QtWidgets.QListWidgetItem(bowlers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.ar_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(allrounders)):
item = QtWidgets.QListWidgetItem(allrounders[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.wk_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(wcktkeepers)):
item = QtWidgets.QListWidgetItem(wcktkeepers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
def removelist1(
self,
item): # REMOVE FROM AVAILABLE PLAYERS AND ADD TO SELECTED PLAYERS
self.conditions_1(item.text())
self.av_player.takeItem(self.av_player.row(item))
self.sel_player.addItem(item.text())
self.totalcount = self.sel_player.count()
self.list1.append(item.text())
self.error()
def conditions_1(
self, cat
): # Adding and Deducting respective points from points_calculator.py
self.avail_points -= self.stats[cat]
self.used_points += self.stats[cat]
if cat in self.a:
self.bowlerscount += 1
elif cat in self.d:
self.wicketerscount += 1
elif cat in self.c:
self.alrdscount += 1
elif cat in self.b:
self.batsmencount += 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def conditions_2(
self, cat
): # Adding and Deducting respective poinrs from points_calculator.py
self.avail_points += self.stats[cat]
self.used_points -= self.stats[cat]
if cat in self.a:
self.bowlerscount -= 1
elif cat in self.d:
self.wicketerscount -= 1
elif cat in self.c:
self.alrdscount -= 1
elif cat in self.b:
self.batsmencount -= 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def removelist2(
self,
item): # REMOVE FROM SELECTED PLAYERS AND ADD TO AVAIALBLE PLAYERS
self.sel_player.takeItem(self.sel_player.row(item))
self.av_player.addItem(item.text())
self.list1.remove(item.text())
# self.error()
self.totalcount = self.sel_player.count()
self.conditions_2(item.text())
def openteam(self): #upon open team selected
self.reset()
teamname = self.open_screen.open_cb.currentText()
self.team_name.setText(teamname)
self.enablebuttons()
fantcurs.execute("SELECT players from teams WHERE name= '" + teamname +
"';")
x = fantcurs.fetchall()
score = []
for i in x:
fantcurs.execute("SELECT value from stats WHERE player='" + i[0] +
"';")
y = fantcurs.fetchone()
score.append(y[0])
# print(score)
sum = 0
for i in score:
sum += i
self.sel_player.clear()
self.load_names()
for i in x:
self.sel_player.addItem(i[0])
self.list1.append(i[0])
self.conditions_1(i[0])
self.used_points = sum
self.avail_points = 1000 - sum
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.openDialog.close()
def enablebuttons(self):
self.bat_rb.setEnabled(True)
self.bow_rb.setEnabled(True)
self.ar_rb.setEnabled(True)
self.wk_rb.setEnabled(True)
def disablebuttons(self):
self.bat_rb.setEnabled(False)
self.bow_rb.setEnabled(False)
self.ar_rb.setEnabled(False)
self.wk_rb.setEnabled(False)
def error(self):
msg = QMessageBox()
if self.wicketerscount > 1:
msg.setIcon(QMessageBox.Critical)
# msg.setText("Error")
msg.setInformativeText('Only 1 wicketkeeper is allowed!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
elif self.totalcount > 11:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('No more than 11 players allowed!')
msg.setWindowTitle("Selection Error")
msg.exec_()
return 0
elif self.totalcount < 11:
return 0
elif self.wicketerscount < 1:
return 0
elif self.avail_points <= -1:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Not enough points!')
msg.setWindowTitle("Selection Cricket")
msg.exec_()
return 0
return 1
class Ui_MainWindow(object):
def __init__(self):
self.newDialog = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.newDialog)
self.EvaluateWindow = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.EvaluateWindow)
self.openDialog = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.openDialog)
# FILE OPENING TAB
def file_open(self):
self.open_screen.setupUi(self.openDialog)
self.openDialog.show()
self.open_screen.openbtn.clicked.connect(self.openteam)
# EVALUATE TEAM TAB
def file_evaluate(self):
self.eval_screen.setupUi(self.EvaluateWindow)
self.EvaluateWindow.show()
def setupUi(self, MainWindow):
# INITIALISING POINTS AND COUNTS
self.avail_points = 1000
self.used_points = 0
self.totalcount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.alrdscount = 0
self.wicketerscount = 0
# INITIALIZING CATEGORY
self.a = [] # bowler names list
self.b = [] # batsman nameslist
self.c = [] # allrounder names list
self.d = [] #wicketer names list
self.list1 = [] # selected player's list
MainWindow.setObjectName("MainWindow")
MainWindow.resize(737, 728)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
MainWindow.setFont(font)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.verticalLayout = QtWidgets.QVBoxLayout(self.centralwidget)
self.verticalLayout.setObjectName("verticalLayout")
self.team_name = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(16)
font.setBold(True)
font.setItalic(False)
font.setWeight(75)
# TEAMNAME
self.team_name.setFont(font)
self.team_name.setStyleSheet("")
self.team_name.setObjectName("team_name")
self.verticalLayout.addWidget(self.team_name)
self.line = QtWidgets.QFrame(self.centralwidget)
self.line.setFrameShape(QtWidgets.QFrame.HLine)
self.line.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line.setObjectName("line")
self.verticalLayout.addWidget(self.line)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setSizeConstraint(
QtWidgets.QLayout.SetNoConstraint)
self.horizontalLayout.setContentsMargins(-1, 20, -1, 20)
self.horizontalLayout.setSpacing(0)
self.horizontalLayout.setObjectName("horizontalLayout")
self.Batsman = QtWidgets.QLabel(self.centralwidget)
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
self.Batsman.setPalette(palette)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.Batsman.setFont(font)
self.Batsman.setIndent(1)
self.Batsman.setObjectName("Batsman")
self.horizontalLayout.addWidget(self.Batsman)
#BATSMAN COUNT
self.batcount = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.batcount.setFont(font)
self.batcount.setObjectName("batcount")
self.horizontalLayout.addWidget(self.batcount)
self.Wicketkeeepr = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.Wicketkeeepr.setFont(font)
self.Wicketkeeepr.setObjectName("Wicketkeeepr")
self.horizontalLayout.addWidget(self.Wicketkeeepr)
# WICKETER'S COUNT
self.wicketcount = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.wicketcount.setFont(font)
self.wicketcount.setIndent(10)
self.wicketcount.setObjectName("wicketcount")
self.horizontalLayout.addWidget(self.wicketcount)
self.Allrounder = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.Allrounder.setFont(font)
self.Allrounder.setObjectName("Allrounder")
self.horizontalLayout.addWidget(self.Allrounder)
# ALLROUNDER'S COUNT
self.alrcount = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.alrcount.setFont(font)
self.alrcount.setIndent(10)
self.alrcount.setObjectName("alrcount")
self.horizontalLayout.addWidget(self.alrcount)
self.Bowlers = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.Bowlers.setFont(font)
self.Bowlers.setObjectName("Bowlers")
self.horizontalLayout.addWidget(self.Bowlers)
#BOWLERS COUNT
self.bowlcount = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.bowlcount.setFont(font)
self.bowlcount.setIndent(10)
self.bowlcount.setObjectName("bowlcount")
self.horizontalLayout.addWidget(self.bowlcount)
self.verticalLayout.addLayout(self.horizontalLayout)
self.line_2 = QtWidgets.QFrame(self.centralwidget)
self.line_2.setFrameShape(QtWidgets.QFrame.HLine)
self.line_2.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_2.setObjectName("line_2")
self.verticalLayout.addWidget(self.line_2)
self.horizontalLayout_3 = QtWidgets.QHBoxLayout()
self.horizontalLayout_3.setSizeConstraint(
QtWidgets.QLayout.SetMaximumSize)
self.horizontalLayout_3.setContentsMargins(0, 20, -1, 20)
self.horizontalLayout_3.setSpacing(0)
self.horizontalLayout_3.setObjectName("horizontalLayout_3")
# RADIOBUTTONS FOR CHOOSING CATEGORY
# BAT RB
self.bat_rb = QtWidgets.QRadioButton(self.centralwidget)
self.bat_rb.setEnabled(False)
font = QtGui.QFont()
font.setPointSize(9)
font.setBold(True)
font.setWeight(75)
self.bat_rb.setFont(font)
self.bat_rb.setTabletTracking(False)
self.bat_rb.setAcceptDrops(False)
self.bat_rb.setToolTipDuration(20)
self.bat_rb.setStyleSheet("Batmans")
self.bat_rb.setObjectName("bat_rb")
self.horizontalLayout_3.addWidget(self.bat_rb)
# WK RB
self.wk_rb = QtWidgets.QRadioButton(self.centralwidget)
self.wk_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.wk_rb.setFont(font)
self.wk_rb.setObjectName("wk_rb")
self.horizontalLayout_3.addWidget(self.wk_rb)
# ALLROUUNDER RB
self.ar_rb = QtWidgets.QRadioButton(self.centralwidget)
self.ar_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.ar_rb.setFont(font)
self.ar_rb.setChecked(False)
self.ar_rb.setObjectName("ar_rb")
self.horizontalLayout_3.addWidget(self.ar_rb)
# BOWLER RB
self.bow_rb = QtWidgets.QRadioButton(self.centralwidget)
self.bow_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.bow_rb.setFont(font)
self.bow_rb.setObjectName("bow_rb")
self.horizontalLayout_3.addWidget(self.bow_rb)
self.verticalLayout.addLayout(self.horizontalLayout_3)
self.line_3 = QtWidgets.QFrame(self.centralwidget)
self.line_3.setFrameShape(QtWidgets.QFrame.HLine)
self.line_3.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_3.setObjectName("line_3")
self.verticalLayout.addWidget(self.line_3)
self.label = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label.setFont(font)
self.label.setText("")
self.label.setObjectName("label")
self.verticalLayout.addWidget(self.label)
self.horizontalLayout_5 = QtWidgets.QHBoxLayout()
self.horizontalLayout_5.setObjectName("horizontalLayout_5")
self.Totalplayers = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.Totalplayers.setFont(font)
self.Totalplayers.setIndent(30)
self.Totalplayers.setObjectName("Totalplayers")
self.horizontalLayout_5.addWidget(self.Totalplayers)
#POINTS CALCULATION
#POINTS AVAILABLE
self.points_available = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.points_available.setFont(font)
self.points_available.setIndent(-10)
self.points_available.setObjectName("points_available")
self.horizontalLayout_5.addWidget(self.points_available)
self.TeamName = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.TeamName.setFont(font)
self.TeamName.setIndent(100)
self.TeamName.setObjectName("TeamName")
self.horizontalLayout_5.addWidget(self.TeamName)
# POINTS USED
self.points_used = QtWidgets.QLabel(self.centralwidget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.points_used.setFont(font)
self.points_used.setIndent(60)
self.points_used.setObjectName("points_used")
self.horizontalLayout_5.addWidget(self.points_used)
self.verticalLayout.addLayout(self.horizontalLayout_5)
self.label_2 = QtWidgets.QLabel(self.centralwidget)
self.label_2.setMaximumSize(QtCore.QSize(778, 16))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.verticalLayout.addWidget(self.label_2)
self.Team = QtWidgets.QHBoxLayout()
self.Team.setObjectName("Team")
# PLAYER'S LISTWIDGET
#AVAILABLE PLAYERS LISTWIDGET
self.availplayers_lw = QtWidgets.QListWidget(self.centralwidget)
self.availplayers_lw.setStyleSheet(
"color: rgb(3, 190, 159);background-color: rgb(240, 240, 240);")
self.availplayers_lw.setObjectName("availplayers_lw")
self.Team.addWidget(self.availplayers_lw)
self.selectedplayers_lw = QtWidgets.QListWidget(self.centralwidget)
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0, 128))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled,
QtGui.QPalette.PlaceholderText, brush)
#SELECTED PLAYER'S LISTWIDGET
self.selectedplayers_lw.setPalette(palette)
self.selectedplayers_lw.setStyleSheet(
"color: rgb(3, 190, 159);background-color: rgb(240, 240, 240);")
self.selectedplayers_lw.setObjectName("selectedplayers_lw")
self.Team.addWidget(self.selectedplayers_lw)
self.verticalLayout.addLayout(self.Team)
MainWindow.setCentralWidget(self.centralwidget)
#MENUBAR
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 737, 23))
self.menubar.setObjectName("menubar")
self.menuManage_Teams = QtWidgets.QMenu(self.menubar)
self.menuManage_Teams.setObjectName("menuManage_Teams")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
#NEW_TEAM
self.new_team = QtWidgets.QAction(MainWindow)
self.new_team.setShortcut("Ctrl+N")
self.new_team.triggered.connect(self.file_new)
self.new_team.setShortcutVisibleInContextMenu(True)
self.new_team.setObjectName("new_team")
#OPEN_TEAM
self.open_team = QtWidgets.QAction(MainWindow)
self.open_team.setShortcut("Ctrl+O")
self.open_team.triggered.connect(self.file_open)
self.open_team.setShortcutVisibleInContextMenu(True)
self.open_team.setObjectName("open_team")
# SAVE_TEAM
self.save_team = QtWidgets.QAction(MainWindow)
self.save_team.setShortcut("Ctrl+S")
self.save_team.triggered.connect(self.file_save)
self.save_team.setShortcutVisibleInContextMenu(True)
self.save_team.setObjectName("save_team")
#EVALUATE_TEAM
self.evaluate_team = QtWidgets.QAction(MainWindow)
self.evaluate_team.setShortcut("Ctrl+E")
self.evaluate_team.triggered.connect(self.file_evaluate)
self.evaluate_team.setShortcutVisibleInContextMenu(True)
self.evaluate_team.setObjectName("evaluate_team")
#QUIT_WINDOW
self.actionQuit = QtWidgets.QAction(MainWindow)
self.actionQuit.setObjectName("actionQuit")
self.actionQuit.triggered.connect(self.quit)
self.menuManage_Teams.addAction(self.new_team)
self.menuManage_Teams.addAction(self.open_team)
self.menuManage_Teams.addAction(self.evaluate_team)
self.menuManage_Teams.addAction(self.save_team)
self.menuManage_Teams.addAction(self.actionQuit)
self.menubar.addAction(self.menuManage_Teams.menuAction())
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
# DOUBLE CLICK
self.availplayers_lw.itemDoubleClicked.connect(self.removelist1)
self.selectedplayers_lw.itemDoubleClicked.connect(self.removelist2)
# --statistics of players
self.stats = {}
self.new_screen.savename.clicked.connect(self.namechange)
# RADIOBUTTONS CLICK
self.bat_rb.clicked.connect(self.load_names)
self.wk_rb.clicked.connect(self.load_names)
self.bow_rb.clicked.connect(self.load_names)
self.ar_rb.clicked.connect(self.load_names)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.team_name.setText(
_translate("MainWindow", " TEAM NAME "))
self.Batsman.setText(_translate("MainWindow", "Batsman(Bat)"))
self.batcount.setText(_translate("MainWindow", "##"))
self.Wicketkeeepr.setText(_translate("MainWindow", "WicketKeeper(WK)"))
self.wicketcount.setText(_translate("MainWindow", "##"))
self.Allrounder.setText(_translate("MainWindow", "Allrounder (ALR)"))
self.alrcount.setText(_translate("MainWindow", "##"))
self.Bowlers.setText(_translate("MainWindow", "Bowlers (Bowl)"))
self.bowlcount.setText(_translate("MainWindow", "##"))
self.bat_rb.setText(_translate("MainWindow", "Batsman"))
self.wk_rb.setText(_translate("MainWindow", "WicketKeeper"))
self.ar_rb.setText(_translate("MainWindow", "AllRounder"))
self.bow_rb.setText(_translate("MainWindow", "Bowlers"))
self.Totalplayers.setText(_translate("MainWindow",
"available points "))
self.points_available.setStatusTip(
_translate("MainWindow", "max point=100"))
self.points_available.setText(_translate("MainWindow", "00"))
self.TeamName.setText(_translate("MainWindow", "used points"))
self.points_used.setText(_translate("MainWindow", "00"))
self.label_2.setText(
_translate(
"MainWindow",
" Available Players selected players"
))
self.menuManage_Teams.setTitle(_translate("MainWindow",
"Manage Teams"))
self.new_team.setText(_translate("MainWindow", "New Team"))
self.new_team.setStatusTip(_translate("MainWindow", "enter team name"))
self.new_team.setShortcut(_translate("MainWindow", "Ctrl+N"))
self.open_team.setText(_translate("MainWindow", "Open Team"))
self.open_team.setStatusTip(_translate("MainWindow", "opening team"))
self.open_team.setShortcut(_translate("MainWindow", "Ctrl+O"))
self.save_team.setText(_translate("MainWindow", "Save Team"))
self.save_team.setStatusTip(_translate("MainWindow", "saving team.."))
self.save_team.setShortcut(_translate("MainWindow", "Ctrl+S"))
self.evaluate_team.setText(_translate("MainWindow", "Evaluate Team"))
self.evaluate_team.setShortcut(_translate("MainWindow", "Ctrl+E"))
self.actionQuit.setText(_translate("MainWindow", "Quit"))
# NEW FILE MENU
def file_new(self):
self.newDialog.show()
def namechange(self):
teamname = self.new_screen.team_name.text()
fantcurs.execute("SELECT DISTINCT name FROM teams")
l = fantcurs.fetchall()
for i in l:
if i[0] == teamname:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Information)
msg.setText(
"Team with same name already exists!!\nPlease choose another name"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
if len(teamname) == 0:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("You cannot leave the field blank!!!")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
elif teamname.isnumeric():
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText(
"Please enter a valid teamname\n(Name must contain atleast one character)!!"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
else:
self.reset()
self.tname = self.new_screen.team_name.text()
self.team_name.setText(' ' + self.tname)
self.newDialog.close()
#TO RESET ALL COUNTS AND LISTS
def reset(self):
self.enablebuttons()
self.load_names()
self.used_points = 0
self.alrdscount = 0
self.wicketerscount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.totalcount = 0
self.avail_points = 1000
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
self.list1.clear()
self.load_names()
self.selectedplayers_lw.clear()
#SAVE TEAM MENU
def file_save(self):
if not self.error(): #IF THERE IS AN ERROR
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' 😪Insufficient Players OR Points !!')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
elif self.error(): # IF NO ERROR
try:
fantcurs.execute("SELECT DISTINCT name FROM teams;")
x = fantcurs.fetchall()
for i in x:
if self.team_name.text(
) == i[0]: # CHECKING IF THE TEAMNAME ALREADY EXISTS
print('Updating already there')
fantcurs.execute("DELETE FROM teams WHERE name='" +
self.team_name.text() +
"';") #DELETING TO UPDATE TEAM
except:
print('error')
for i in range(self.selectedplayers_lw.count()):
# print('----addding--')
# print('teamnane: ',self.team_name.text())
# print('playername: ',self.list1[i])
# print('points: ', player_points[self.list1[i]])
try:
fantcurs.execute(
"INSERT INTO teams (name,players,value) VALUES (?,?,?)",
(self.team_name.text(), self.list1[i],
player_points[self.list1[i]]))
# self.file_evaluate()
except:
print('error in operation!')
fant.commit()
else:
print('---error in operation')
# QUITING METHOD
def quit(self):
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Bye 😙')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
# print('exit')
sys.exit()
#ON RADIOBUTTONS CLICKED
def load_names(self):
Batsman = 'BAT'
WicketKeeper = 'WK'
Allrounder = 'AR'
Bowler = 'BWL'
sql1 = "SELECT player,value from stats WHERE ctg = '" + Batsman + "';"
sql2 = "SELECT Player,value from stats WHERE ctg = '" + WicketKeeper + "';"
sql3 = "SELECT Player,value from stats WHERE ctg ='" + Allrounder + "';"
sql4 = "SELECT Player,value from stats WHERE ctg = '" + Bowler + "';"
fantcurs.execute(sql1)
x = fantcurs.fetchall()
fantcurs.execute(sql4)
y = fantcurs.fetchall()
fantcurs.execute(sql3)
z = fantcurs.fetchall()
fantcurs.execute(sql2)
w = fantcurs.fetchall()
batsmen = []
bowlers = []
allrounders = []
wcktkeepers = []
for k in x:
batsmen.append(k[0])
self.b.append(k[0])
self.stats[k[0]] = k[1]
for k in y:
bowlers.append(k[0])
self.stats[k[0]] = k[1]
self.a.append(k[0])
for k in w:
wcktkeepers.append(k[0])
self.stats[k[0]] = k[1]
self.d.append(k[0])
for k in z:
allrounders.append(k[0])
self.stats[k[0]] = k[1]
self.c.append(k[0])
for i in self.list1:
if i in allrounders:
allrounders.remove(i)
elif i in batsmen:
batsmen.remove(i)
elif i in bowlers:
bowlers.remove(i)
elif i in wcktkeepers:
wcktkeepers.remove(i)
if self.bat_rb.isChecked() == True:
self.availplayers_lw.clear()
for i in range(len(batsmen)):
item = QtWidgets.QListWidgetItem(batsmen[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.availplayers_lw.addItem(item)
elif self.bow_rb.isChecked() == True:
self.availplayers_lw.clear()
for i in range(len(bowlers)):
item = QtWidgets.QListWidgetItem(bowlers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.availplayers_lw.addItem(item)
elif self.ar_rb.isChecked() == True:
self.availplayers_lw.clear()
for i in range(len(allrounders)):
item = QtWidgets.QListWidgetItem(allrounders[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.availplayers_lw.addItem(item)
elif self.wk_rb.isChecked() == True:
self.availplayers_lw.clear()
for i in range(len(wcktkeepers)):
item = QtWidgets.QListWidgetItem(wcktkeepers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.availplayers_lw.addItem(item)
def removelist1(
self,
item): # REMOVE FROM AVAILABLE PLAYERS AND ADD TO SELECTED PLAYERS
self.conditions_1(item.text())
self.availplayers_lw.takeItem(self.availplayers_lw.row(item))
self.selectedplayers_lw.addItem(item.text())
self.totalcount = self.selectedplayers_lw.count()
self.list1.append(item.text())
self.error()
def conditions_1(
self, cat
): # Adding and Deducting respective points from points_calculator.py
self.avail_points -= self.stats[cat]
self.used_points += self.stats[cat]
if cat in self.a:
self.bowlerscount += 1
elif cat in self.d:
self.wicketerscount += 1
elif cat in self.c:
self.alrdscount += 1
elif cat in self.b:
self.batsmencount += 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
def conditions_2(
self, cat
): # Adding and Deducting respective poinrs from points_calculator.py
self.avail_points += self.stats[cat]
self.used_points -= self.stats[cat]
if cat in self.a:
self.bowlerscount -= 1
elif cat in self.d:
self.wicketerscount -= 1
elif cat in self.c:
self.alrdscount -= 1
elif cat in self.b:
self.batsmencount -= 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
def removelist2(
self,
item): # REMOVE FROM SELECTED PLAYERS AND ADD TO AVAIALBLE PLAYERS
self.selectedplayers_lw.takeItem(self.selectedplayers_lw.row(item))
self.availplayers_lw.addItem(item.text())
self.list1.remove(item.text())
# self.error()
self.totalcount = self.selectedplayers_lw.count()
self.conditions_2(item.text())
def openteam(self): #upon open team selected
self.reset()
teamname = self.open_screen.open_cb.currentText()
self.team_name.setText(teamname)
self.enablebuttons()
fantcurs.execute("SELECT players from teams WHERE name= '" + teamname +
"';")
x = fantcurs.fetchall()
score = []
for i in x:
fantcurs.execute("SELECT value from stats WHERE player='" + i[0] +
"';")
y = fantcurs.fetchone()
score.append(y[0])
# print(score)
sum = 0
for i in score:
sum += i
self.selectedplayers_lw.clear()
self.load_names()
for i in x:
self.selectedplayers_lw.addItem(i[0])
self.list1.append(i[0])
self.conditions_1(i[0])
self.used_points = sum
self.avail_points = 1000 - sum
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.openDialog.close()
def enablebuttons(self):
self.bat_rb.setEnabled(True)
self.bow_rb.setEnabled(True)
self.ar_rb.setEnabled(True)
self.wk_rb.setEnabled(True)
def error(self):
msg = QMessageBox()
if self.wicketerscount > 1:
msg.setIcon(QMessageBox.Critical)
# msg.setText("Error")
msg.setInformativeText('Only 1 wicketkeeper is allowed!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
elif self.totalcount > 11:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('No more than 11 players allowed!')
msg.setWindowTitle("Selection Error")
msg.exec_()
return 0
elif self.totalcount < 11:
return 0
elif self.wicketerscount < 1:
return 0
elif self.avail_points <= -1:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Not enough points!')
msg.setWindowTitle("Selection Cricket")
msg.exec_()
return 0
return 1
def __init__(self):
super(MainWindow, self).__init__()
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.bt = self.ui.pushButton
self.bt.clicked.connect(self.getfile)
class Ui_MainWindow(object):
def __init__(self): # linking files and creating objects
self.new_Window = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.new_Window)
self.evaluate_Window = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.evaluate_Window)
self.open_Window = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.open_Window)
def setupUi(self, MainWindow): #Ui setup
# local variables
self.avail_points = 1000
self.used_points = 0
self.totalcount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.alrdscount = 0
self.wicketerscount = 0
self.a = [] # bowler names list
self.b = [] # batsman nameslist
self.c = [] # allrounder names list
self.d = [] #wicketer names list
self.selectlist = [] # selectedplayer's list
MainWindow.setObjectName("MainWindow")
MainWindow.resize(789, 728)
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(170, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(170, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(170, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(127, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipText, brush)
MainWindow.setPalette(palette)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
MainWindow.setFont(font)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.team_name = QtWidgets.QLabel(self.centralwidget)
self.team_name.setGeometry(QtCore.QRect(620, 230, 91, 25))
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setPointSize(12)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.team_name.setFont(font)
self.team_name.setStyleSheet("")
self.team_name.setObjectName("team_name")
self.line = QtWidgets.QFrame(self.centralwidget)
self.line.setGeometry(QtCore.QRect(9, 40, 769, 16))
self.line.setFrameShape(QtWidgets.QFrame.HLine)
self.line.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line.setObjectName("line")
self.line_2 = QtWidgets.QFrame(self.centralwidget)
self.line_2.setGeometry(QtCore.QRect(9, 134, 769, 16))
self.line_2.setFrameShape(QtWidgets.QFrame.HLine)
self.line_2.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_2.setObjectName("line_2")
self.line_3 = QtWidgets.QFrame(self.centralwidget)
self.line_3.setGeometry(QtCore.QRect(9, 210, 769, 16))
self.line_3.setFrameShape(QtWidgets.QFrame.HLine)
self.line_3.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_3.setObjectName("line_3")
self.label = QtWidgets.QLabel(self.centralwidget)
self.label.setGeometry(QtCore.QRect(9, 219, 16, 16))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(9)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.label.setFont(font)
self.label.setText("")
self.label.setObjectName("label")
self.widget = QtWidgets.QWidget(self.centralwidget)
self.widget.setGeometry(QtCore.QRect(10, 160, 761, 41))
self.widget.setObjectName("widget")
self.horizontalLayout_5 = QtWidgets.QHBoxLayout(self.widget)
self.horizontalLayout_5.setSizeConstraint(QtWidgets.QLayout.SetDefaultConstraint)
self.horizontalLayout_5.setContentsMargins(0, 0, 0, 0)
self.horizontalLayout_5.setObjectName("horizontalLayout_5")
self.Totalplayers = QtWidgets.QLabel(self.widget)
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(11)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.Totalplayers.setFont(font)
self.Totalplayers.setIndent(30)
self.Totalplayers.setObjectName("Totalplayers")
self.horizontalLayout_5.addWidget(self.Totalplayers)
self.points_available = QtWidgets.QLabel(self.widget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(11)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.points_available.setFont(font)
self.points_available.setIndent(-10)
self.points_available.setObjectName("points_available")
self.horizontalLayout_5.addWidget(self.points_available)
self.TeamName = QtWidgets.QLabel(self.widget)
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(11)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.TeamName.setFont(font)
self.TeamName.setIndent(100)
self.TeamName.setObjectName("TeamName")
self.horizontalLayout_5.addWidget(self.TeamName)
self.points_used = QtWidgets.QLabel(self.widget)
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(11)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.points_used.setFont(font)
self.points_used.setIndent(60)
self.points_used.setObjectName("points_used")
self.horizontalLayout_5.addWidget(self.points_used)
self.label_2 = QtWidgets.QLabel(self.centralwidget)
self.label_2.setGeometry(QtCore.QRect(480, 220, 131, 41))
font = QtGui.QFont()
font.setPointSize(13)
font.setItalic(False)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.label_3 = QtWidgets.QLabel(self.centralwidget)
self.label_3.setGeometry(QtCore.QRect(16, 259, 211, 31))
self.label_3.setObjectName("label_3")
self.label_4 = QtWidgets.QLabel(self.centralwidget)
self.label_4.setGeometry(QtCore.QRect(400, 260, 211, 31))
self.label_4.setObjectName("label_4")
self.label_5 = QtWidgets.QLabel(self.centralwidget)
self.label_5.setGeometry(QtCore.QRect(40, 10, 711, 31))
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.label_5.sizePolicy().hasHeightForWidth())
self.label_5.setSizePolicy(sizePolicy)
font = QtGui.QFont()
font.setPointSize(16)
font.setItalic(False)
self.label_5.setFont(font)
self.label_5.setFrameShape(QtWidgets.QFrame.Box)
self.label_5.setAlignment(QtCore.Qt.AlignCenter)
self.label_5.setObjectName("label_5")
self.availablelist = QtWidgets.QListWidget(self.centralwidget)
self.availablelist.setGeometry(QtCore.QRect(10, 290, 361, 381))
self.availablelist.setStyleSheet("color: rgb(0, 0, 0);background-color: rgb(240, 240, 240);")
self.availablelist.setObjectName("availablelist")
self.selectedlist = QtWidgets.QListWidget(self.centralwidget)
self.selectedlist.setGeometry(QtCore.QRect(390, 290, 381, 381))
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(85, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(113, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(85, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(113, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(85, 127, 127))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(113, 170, 170))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(3, 190, 159))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(240, 240, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(170, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipText, brush)
self.selectedlist.setPalette(palette)
self.selectedlist.setStyleSheet("color: rgb(0, 0, 0);background-color: rgb(240, 240, 240);")
self.selectedlist.setObjectName("selectedlist")
self.batradio = QtWidgets.QRadioButton(self.centralwidget)
self.batradio.setEnabled(False)
self.batradio.setGeometry(QtCore.QRect(10, 240, 69, 21))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(9)
font.setBold(True)
font.setWeight(69)
self.batradio.setFont(font)
self.batradio.setTabletTracking(False)
self.batradio.setAcceptDrops(False)
self.batradio.setToolTipDuration(20)
self.batradio.setStyleSheet("Batmans")
self.batradio.setObjectName("batradio")
self.wkradio = QtWidgets.QRadioButton(self.centralwidget)
self.wkradio.setEnabled(False)
self.wkradio.setGeometry(QtCore.QRect(70, 240, 120, 21))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(9)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.wkradio.setFont(font)
self.wkradio.setObjectName("wkradio")
self.arradio = QtWidgets.QRadioButton(self.centralwidget)
self.arradio.setEnabled(False)
self.arradio.setGeometry(QtCore.QRect(130, 240, 100, 21))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(9)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.arradio.setFont(font)
self.arradio.setChecked(False)
self.arradio.setObjectName("arradio")
self.bowlradio = QtWidgets.QRadioButton(self.centralwidget)
self.bowlradio.setEnabled(False)
self.bowlradio.setGeometry(QtCore.QRect(200, 240, 79, 21))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(9)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.bowlradio.setFont(font)
self.bowlradio.setObjectName("bowlradio")
self.Batsman = QtWidgets.QLabel(self.centralwidget)
self.Batsman.setGeometry(QtCore.QRect(10, 50, 126, 41))
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(233, 233, 233))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(141, 141, 141))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(233, 233, 233))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(233, 233, 233))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(141, 141, 141))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(233, 233, 233))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipText, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.WindowText, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Button, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Light, brush)
brush = QtGui.QBrush(QtGui.QColor(233, 233, 233))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Midlight, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Dark, brush)
brush = QtGui.QBrush(QtGui.QColor(141, 141, 141))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Mid, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Text, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.BrightText, brush)
brush = QtGui.QBrush(QtGui.QColor(106, 106, 106))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ButtonText, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Window, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Shadow, brush)
brush = QtGui.QBrush(QtGui.QColor(212, 212, 212))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.AlternateBase, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipBase, brush)
brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipText, brush)
self.Batsman.setPalette(palette)
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(10)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.Batsman.setFont(font)
self.Batsman.setIndent(1)
self.Batsman.setObjectName("Batsman")
self.Bowlers = QtWidgets.QLabel(self.centralwidget)
self.Bowlers.setGeometry(QtCore.QRect(370, 110, 110, 17))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(10)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.Bowlers.setFont(font)
self.Bowlers.setObjectName("Bowlers")
self.alrcount = QtWidgets.QLabel(self.centralwidget)
self.alrcount.setGeometry(QtCore.QRect(500, 60, 31, 17))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.alrcount.setFont(font)
self.alrcount.setIndent(10)
self.alrcount.setObjectName("alrcount")
self.bowlcount = QtWidgets.QLabel(self.centralwidget)
self.bowlcount.setGeometry(QtCore.QRect(480, 110, 31, 17))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.bowlcount.setFont(font)
self.bowlcount.setIndent(10)
self.bowlcount.setObjectName("bowlcount")
self.batcount = QtWidgets.QLabel(self.centralwidget)
self.batcount.setGeometry(QtCore.QRect(130, 60, 21, 17))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.batcount.setFont(font)
self.batcount.setObjectName("batcount")
self.Allrounder = QtWidgets.QLabel(self.centralwidget)
self.Allrounder.setGeometry(QtCore.QRect(370, 60, 123, 17))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(10)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.Allrounder.setFont(font)
self.Allrounder.setObjectName("Allrounder")
self.Wicketkeeepr = QtWidgets.QLabel(self.centralwidget)
self.Wicketkeeepr.setGeometry(QtCore.QRect(20, 110, 139, 17))
font = QtGui.QFont()
font.setFamily("Sans")
font.setPointSize(10)
font.setBold(True)
font.setItalic(False)
font.setWeight(69)
self.Wicketkeeepr.setFont(font)
self.Wicketkeeepr.setObjectName("Wicketkeeepr")
self.wicketcount = QtWidgets.QLabel(self.centralwidget)
self.wicketcount.setGeometry(QtCore.QRect(160, 110, 31, 17))
font = QtGui.QFont()
font.setFamily("Bookman Old Style")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(69)
self.wicketcount.setFont(font)
self.wicketcount.setIndent(10)
self.wicketcount.setObjectName("wicketcount")
self.line.raise_()
self.line_2.raise_()
self.line_3.raise_()
self.label.raise_()
self.batradio.raise_()
self.wkradio.raise_()
self.arradio.raise_()
self.bowlradio.raise_()
self.label_2.raise_()
self.label_3.raise_()
self.label_4.raise_()
self.label_5.raise_()
self.team_name.raise_()
MainWindow.setCentralWidget(self.centralwidget)
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 789, 20))
self.menubar.setObjectName("menubar")
self.menuManage_Teams = QtWidgets.QMenu(self.menubar)
font = QtGui.QFont()
font.setFamily("Sans")
font.setBold(True)
font.setWeight(69)
self.menuManage_Teams.setFont(font)
self.menuManage_Teams.setObjectName("menuManage_Teams")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
self.new_team = QtWidgets.QAction(MainWindow)
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setBold(False)
font.setWeight(50)
self.new_team.setFont(font)
self.new_team.setProperty("shortcutVisibleInContextMenu", True)
self.new_team.setObjectName("new_team")
self.new_team.triggered.connect(self.file_new)
self.open_team = QtWidgets.QAction(MainWindow)
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setBold(False)
font.setWeight(50)
self.open_team.setFont(font)
self.open_team.setProperty("shortcutVisibleInContextMenu", True)
self.open_team.setObjectName("open_team")
self.open_team.triggered.connect(self.open_file)
self.save_team = QtWidgets.QAction(MainWindow)
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setBold(False)
font.setWeight(50)
self.save_team.setFont(font)
self.save_team.setProperty("shortcutVisibleInContextMenu", True)
self.save_team.setObjectName("save_team")
self.save_team.triggered.connect(self.file_save)
self.evaluate_team = QtWidgets.QAction(MainWindow)
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setBold(False)
font.setWeight(50)
self.evaluate_team.setFont(font)
self.evaluate_team.setProperty("shortcutVisibleInContextMenu", True)
self.evaluate_team.setObjectName("evaluate_team")
self.evaluate_team.triggered.connect(self.eval_file)
self.actionQuit = QtWidgets.QAction(MainWindow)
font = QtGui.QFont()
font.setFamily("DejaVu Sans")
font.setBold(False)
font.setWeight(50)
self.actionQuit.setFont(font)
self.actionQuit.setProperty("shortcutVisibleInContextMenu", True)
self.actionQuit.setObjectName("actionQuit")
self.actionQuit.triggered.connect(lambda: quit())
self.menuManage_Teams.addAction(self.new_team)
self.menuManage_Teams.addAction(self.open_team)
self.menuManage_Teams.addAction(self.evaluate_team)
self.menuManage_Teams.addAction(self.save_team)
self.menuManage_Teams.addAction(self.actionQuit)
self.menubar.addAction(self.menuManage_Teams.menuAction())
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
# Click responses
self.availablelist.itemDoubleClicked.connect(self.transfer1)
self.selectedlist.itemDoubleClicked.connect(self.transfer2)
self.stats = {}
self.new_screen.savename.clicked.connect(self.namechange)
self.batradio.clicked.connect(self.load_names)
self.wkradio.clicked.connect(self.load_names)
self.bowlradio.clicked.connect(self.load_names)
self.arradio.clicked.connect(self.load_names)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.team_name.setText(_translate("MainWindow", "XXX"))
self.Totalplayers.setText(_translate("MainWindow", "Available Points"))
self.points_available.setStatusTip(_translate("MainWindow", "max point=100"))
self.points_available.setText(_translate("MainWindow", "##"))
self.TeamName.setText(_translate("MainWindow", "Points used"))
self.points_used.setText(_translate("MainWindow", "##"))
self.label_2.setText(_translate("MainWindow", "Team Name:"))
self.label_3.setText(_translate("MainWindow", "Available Players"))
self.label_4.setText(_translate("MainWindow", "Selected Players"))
self.label_5.setText(_translate("MainWindow", "Welcome to Fantasy Cricket!"))
self.batradio.setText(_translate("MainWindow", "Bat"))
self.wkradio.setText(_translate("MainWindow", "WK"))
self.arradio.setText(_translate("MainWindow", "AR"))
self.bowlradio.setText(_translate("MainWindow", "BOWL"))
self.Batsman.setText(_translate("MainWindow", "Batsman(Bat)"))
self.Bowlers.setText(_translate("MainWindow", "Bowlers (Bowl)"))
self.alrcount.setText(_translate("MainWindow", "##"))
self.bowlcount.setText(_translate("MainWindow", "##"))
self.batcount.setText(_translate("MainWindow", "##"))
self.Allrounder.setText(_translate("MainWindow", "Allrounder (ALR)"))
self.Wicketkeeepr.setText(_translate("MainWindow", "WicketKeeper(WK)"))
self.wicketcount.setText(_translate("MainWindow", "##"))
self.menuManage_Teams.setTitle(_translate("MainWindow", "Manage Teams"))
self.new_team.setText(_translate("MainWindow", "New Team"))
self.new_team.setStatusTip(_translate("MainWindow", "enter team name"))
self.new_team.setShortcut(_translate("MainWindow", "Ctrl+N"))
self.open_team.setText(_translate("MainWindow", "Open Team"))
self.open_team.setStatusTip(_translate("MainWindow", "opening team"))
self.open_team.setShortcut(_translate("MainWindow", "Ctrl+O"))
self.save_team.setText(_translate("MainWindow", "Save Team"))
self.save_team.setStatusTip(_translate("MainWindow", "saving team.."))
self.save_team.setShortcut(_translate("MainWindow", "Ctrl+S"))
self.evaluate_team.setText(_translate("MainWindow", "Evaluate Team"))
self.evaluate_team.setShortcut(_translate("MainWindow", "Ctrl+E"))
self.actionQuit.setText(_translate("MainWindow", "Quit"))
self.actionQuit.setShortcut(_translate("MainWindow", "Ctrl+Q"))
#Double Click functions:
def transfer1(self, item):# available -> selected
self.calculations_1(item.text())
self.availablelist.takeItem(self.availablelist.row(item))
self.selectedlist.addItem(item.text())
self.totalcount = self.selectedlist.count()
self.selectlist.append(item.text())
self.checkerror()
def transfer2(self, item):#available <- Selected
self.selectedlist.takeItem(self.selectedlist.row(item))
self.availablelist.addItem(item.text())
self.selectlist.remove(item.text())
self.totalcount = self.selectedlist.count()
self.calculations_2(item.text())
def calculations_1(self, cat): # update player and point count
self.avail_points -= self.stats[cat]
self.used_points += self.stats[cat]
if cat in self.a:
self.bowlerscount += 1
elif cat in self.d:
self.wicketerscount += 1
elif cat in self.c:
self.alrdscount += 1
elif cat in self.b:
self.batsmencount += 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
def calculations_2(self, cat): # update player and point count
self.avail_points += self.stats[cat]
self.used_points -= self.stats[cat]
if cat in self.a:
self.bowlerscount -= 1
elif cat in self.d:
self.wicketerscount -= 1
elif cat in self.c:
self.alrdscount -= 1
elif cat in self.b:
self.batsmencount -= 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
#Double click functions end
#Menu Functions
def file_new(self):# opens new.py
self.new_Window.show()
def open_file(self): # opens open file
self.open_screen.setupUi(self.open_Window)
self.open_Window.show()
self.open_screen.openbtn.clicked.connect(self.openteam)
def eval_file(self): # opens evaluate file
self.eval_screen.setupUi(self.evaluate_Window)
self.evaluate_Window.show()
def namechange(self): # set name for team
teamname = self.new_screen.team_name.text()
datacurs.execute("SELECT DISTINCT name FROM teams")
allteams = datacurs.fetchall()
for oneteam in allteams:
if oneteam[0] == teamname:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Information)
msg.setText("Team name already exists, try something else")
msg.setWindowTitle("Error")
msg.exec_()
return 0
if len(teamname) == 0:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("Team name cannot be empty")
msg.setWindowTitle("Error")
msg.exec_()
return 0
elif teamname.isnumeric():
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("Team name cannot be only numbers")
msg.setWindowTitle("Error")
msg.exec_()
return 0
else:
self.reset()
self.tname = self.new_screen.team_name.text()
self.team_name.setText(self.tname)
self.new_Window.close()
def file_save(self): # save teams, if already there -> update
if not self.checkerror(): # if error
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Insufficient Players OR Points !!')
msg.setWindowTitle('Error')
msg.exec_()
elif self.checkerror(): # if no error
try:
datacurs.execute("SELECT DISTINCT name FROM teams;")
allteams = datacurs.fetchall()
for oneteam in allteams:
if self.team_name.text() == oneteam[0]:
print('Updating already there')
datacurs.execute("DELETE FROM teams WHERE name='" + self.team_name.text() + "';")
except:
print('error')
for i in range(self.selectedlist.count()):
try:
datacurs.execute("INSERT INTO teams (name,players,value) VALUES (?,?,?)",
(self.team_name.text(), self.selectlist[i], player_points[self.selectlist[i]]))
except:
print('error in operation!')
data.commit()
else:
print('---error in operation')
def openteam(self): # open saved teams
self.reset()
teamname = self.open_screen.opendrop.currentText()
self.team_name.setText(teamname)
self.enablebuttons()
datacurs.execute("SELECT players from teams WHERE name= '" + teamname + "';")
Players = datacurs.fetchall()
scores = []
for Player in Players:
datacurs.execute("SELECT value from stats WHERE player='"+Player[0]+"';")
playval = datacurs.fetchone()
scores.append(playval[0])
summ = 0
for score in scores:
summ += score
self.selectedlist.clear()
self.load_names()
for Player in Players:
self.selectedlist.addItem(Player[0])
self.selectlist.append(Player[0])
self.calculations_1(Player[0])
self.used_points = summ
self.avail_points = 1000 - summ
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.open_Window.close()
#Menu functions end
#Radio button functions:
def enablebuttons(self):# enables radio buttons
self.batradio.setEnabled(True)
self.bowlradio.setEnabled(True)
self.arradio.setEnabled(True)
self.wkradio.setEnabled(True)
def load_names(self): #when radio buttons clicked
datacurs.execute('SELECT player,value from stats WHERE ctg = "BAT";')
batter = datacurs.fetchall()
datacurs.execute('SELECT Player,value from stats WHERE ctg = "WK";')
wick = datacurs.fetchall()
datacurs.execute('SELECT Player,value from stats WHERE ctg ="AR";')
rounder = datacurs.fetchall()
datacurs.execute('SELECT Player,value from stats WHERE ctg = "BWL";')
bowlin = datacurs.fetchall()
batsmen = []
bowlers = []
allrounders = []
wcktkeepers = []
for boo in bowlin:
bowlers.append(boo[0])
self.stats[boo[0]] = boo[1]
self.a.append(boo[0])
for batt in batter:
batsmen.append(batt[0])
self.b.append(batt[0])
self.stats[batt[0]] = batt[1]
for roun in rounder:
allrounders.append(roun[0])
self.stats[roun[0]] = roun[1]
self.c.append(roun[0])
for wic in wick:
wcktkeepers.append(wic[0])
self.stats[wic[0]] = wic[1]
self.d.append(wic[0])
for selected in self.selectlist:
if selected in allrounders:
allrounders.remove(selected)
elif selected in batsmen:
batsmen.remove(selected)
elif selected in bowlers:
bowlers.remove(selected)
elif selected in wcktkeepers:
wcktkeepers.remove(selected)
if self.batradio.isChecked() == True:
self.availablelist.clear()
for i in range(len(batsmen)):
item = QtWidgets.QListWidgetItem(batsmen[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(69)
item.setFont(font)
self.availablelist.addItem(item)
elif self.bowlradio.isChecked() == True:
self.availablelist.clear()
for i in range(len(bowlers)):
item = QtWidgets.QListWidgetItem(bowlers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(69)
item.setFont(font)
self.availablelist.addItem(item)
elif self.arradio.isChecked() == True:
self.availablelist.clear()
for i in range(len(allrounders)):
item = QtWidgets.QListWidgetItem(allrounders[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(69)
item.setFont(font)
self.availablelist.addItem(item)
elif self.wkradio.isChecked() == True:
self.availablelist.clear()
for i in range(len(wcktkeepers)):
item = QtWidgets.QListWidgetItem(wcktkeepers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(69)
item.setFont(font)
self.availablelist.addItem(item)
#Radio Functions end
#Other functions:
def checkerror(self):# check for errors
msg = QMessageBox()
if self.wicketerscount > 1:
msg.setIcon(QMessageBox.Warning)
msg.setInformativeText('Only 1 wicketkeeper is allowed!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
if self.totalcount < 11 :
return 0
if self.wicketerscount < 1:
return 0
if self.avail_points <= -1:
msg.setIcon(QMessageBox.Warning)
msg.setInformativeText('Not enough points!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
return 1
def reset(self): # reset local variables, lists
self.enablebuttons()
self.load_names()
self.used_points = 0
self.alrdscount = 0
self.wicketerscount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.totalcount = 0
self.avail_points = 1000
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.bowlcount.setText(str(self.bowlerscount))
self.batcount.setText(str(self.batsmencount))
self.alrcount.setText(str(self.alrdscount))
self.wicketcount.setText(str(self.wicketerscount))
self.selectlist.clear()
self.load_names()
self.selectedlist.clear()
class Ui_MainWindow(object):
def __init__(self):
self.newDialog = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.newDialog)
self.EvaluateWindow = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.EvaluateWindow)
self.openDialog = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.openDialog)
def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(860, 556)
MainWindow.setStyleSheet("\n"
"\n"
"background-color: rgb(234, 228, 221);")
self.central_w = QtWidgets.QWidget(MainWindow)
self.central_w.setObjectName("central_w")
self.verticalLayout_3 = QtWidgets.QVBoxLayout(self.central_w)
self.verticalLayout_3.setObjectName("verticalLayout_3")
spacerItem = QtWidgets.QSpacerItem(20, 40, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Preferred)
self.verticalLayout_3.addItem(spacerItem)
self.frame = QtWidgets.QFrame(self.central_w)
self.frame.setStyleSheet("background-color: rgb(241, 235, 255);\n"
"font: 75 10pt \"MS Shell Dlg 2\";\n"
"")
self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame.setObjectName("frame")
self.gridLayout = QtWidgets.QGridLayout(self.frame)
self.gridLayout.setContentsMargins(-1, 5, -1, 24)
self.gridLayout.setObjectName("gridLayout")
self.label_10 = QtWidgets.QLabel(self.frame)
self.label_10.setObjectName("label_10")
self.gridLayout.addWidget(self.label_10, 1, 4, 1, 1)
#bowl
self.BOWL = QtWidgets.QLabel(self.frame)
self.BOWL.setStyleSheet("color: rgb(0, 170, 255);")
self.BOWL.setObjectName("BOWL")
self.gridLayout.addWidget(self.BOWL, 1, 3, 1, 1)
#all-rouder
self.ARL = QtWidgets.QLabel(self.frame)
self.ARL.setStyleSheet("color: rgb(0, 170, 255);")
self.ARL.setObjectName("ARL")
self.gridLayout.addWidget(self.ARL, 1, 5, 1, 1)
#bat
self.BAT = QtWidgets.QLabel(self.frame)
self.BAT.setStyleSheet("color: rgb(0, 170, 255);")
self.BAT.setObjectName("BAT")
self.gridLayout.addWidget(self.BAT, 1, 1, 1, 1)
self.label_2 = QtWidgets.QLabel(self.frame)
font = QtGui.QFont()
font.setFamily("MS Shell Dlg 2")
font.setPointSize(10)
font.setBold(False)
font.setItalic(False)
font.setWeight(9)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.gridLayout.addWidget(self.label_2, 1, 0, 1, 1)
#wicket keeper
self.WK = QtWidgets.QLabel(self.frame)
self.WK.setStyleSheet("color: rgb(0, 170, 255);")
self.WK.setObjectName("WK")
self.gridLayout.addWidget(self.WK, 1, 7, 1, 1)
self.label_12 = QtWidgets.QLabel(self.frame)
self.label_12.setObjectName("label_12")
self.gridLayout.addWidget(self.label_12, 1, 6, 1, 1)
self.label_4 = QtWidgets.QLabel(self.frame)
font = QtGui.QFont()
font.setFamily("MS Shell Dlg 2")
font.setPointSize(10)
font.setBold(False)
font.setItalic(False)
font.setWeight(9)
self.label_4.setFont(font)
self.label_4.setObjectName("label_4")
self.gridLayout.addWidget(self.label_4, 1, 2, 1, 1)
self.label = QtWidgets.QLabel(self.frame)
font = QtGui.QFont()
font.setFamily("Comic Sans MS")
font.setPointSize(9)
font.setBold(False)
font.setItalic(True)
font.setWeight(50)
self.label.setFont(font)
self.label.setStyleSheet("\n"
"font: italic 9pt \"Comic Sans MS\";")
self.label.setObjectName("label")
self.gridLayout.addWidget(self.label, 0, 0, 1, 1)
self.verticalLayout_3.addWidget(self.frame)
self.frame_2 = QtWidgets.QFrame(self.central_w)
self.frame_2.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";\n"
"border-color: rgb(255, 255, 255);")
self.frame_2.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_2.setFrameShadow(QtWidgets.QFrame.Plain)
self.frame_2.setLineWidth(0)
self.frame_2.setObjectName("frame_2")
self.horizontalLayout = QtWidgets.QHBoxLayout(self.frame_2)
self.horizontalLayout.setContentsMargins(46, 8, 23, 5)
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_6 = QtWidgets.QLabel(self.frame_2)
self.label_6.setStyleSheet("font: 75 9pt \"MS Shell Dlg 2\";")
self.label_6.setObjectName("label_6")
self.horizontalLayout.addWidget(self.label_6)
#Points-available
self.points_available = QtWidgets.QLabel(self.frame_2)
self.points_available.setStyleSheet("color: rgb(85, 170, 255);")
self.points_available.setObjectName("points_available")
self.horizontalLayout.addWidget(self.points_available)
self.label_7 = QtWidgets.QLabel(self.frame_2)
self.label_7.setObjectName("label_7")
self.horizontalLayout.addWidget(self.label_7, 0, QtCore.Qt.AlignRight)
#points-used
self.points_used = QtWidgets.QLabel(self.frame_2)
self.points_used.setStyleSheet("color: rgb(85, 170, 255);")
self.points_used.setObjectName("points_used")
self.horizontalLayout.addWidget(self.points_used, 0, QtCore.Qt.AlignHCenter)
self.verticalLayout_3.addWidget(self.frame_2)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
spacerItem1 = QtWidgets.QSpacerItem(13, 345, QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem1)
self.frame_3 = QtWidgets.QFrame(self.central_w)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.frame_3.sizePolicy().hasHeightForWidth())
self.frame_3.setSizePolicy(sizePolicy)
self.frame_3.setStyleSheet("border-color: rgb(15, 15, 15);")
self.frame_3.setFrameShape(QtWidgets.QFrame.Panel)
self.frame_3.setFrameShadow(QtWidgets.QFrame.Plain)
self.frame_3.setLineWidth(2)
self.frame_3.setMidLineWidth(1)
self.frame_3.setObjectName("frame_3")
self.verticalLayout = QtWidgets.QVBoxLayout(self.frame_3)
self.verticalLayout.setContentsMargins(19, -1, 19, -1)
self.verticalLayout.setObjectName("verticalLayout")
self.frame_5 = QtWidgets.QFrame(self.frame_3)
self.frame_5.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";")
self.frame_5.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_5.setFrameShadow(QtWidgets.QFrame.Sunken)
self.frame_5.setObjectName("frame_5")
self.horizontalLayout_2 = QtWidgets.QHBoxLayout(self.frame_5)
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.bat_rb = QtWidgets.QRadioButton(self.frame_5)
self.bat_rb.setEnabled(False)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.bat_rb.sizePolicy().hasHeightForWidth())
#Bat radio button
self.bat_rb.setSizePolicy(sizePolicy)
self.bat_rb.setObjectName("bat_rb")
self.horizontalLayout_2.addWidget(self.bat_rb)
self.bow_rb = QtWidgets.QRadioButton(self.frame_5)
self.bow_rb.setEnabled(False)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.bow_rb.sizePolicy().hasHeightForWidth())
self.bow_rb.setSizePolicy(sizePolicy)
#Bowl radio button
self.bow_rb.setObjectName("bow_rb")
self.horizontalLayout_2.addWidget(self.bow_rb)
self.ar_rb = QtWidgets.QRadioButton(self.frame_5)
self.ar_rb.setEnabled(False)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.ar_rb.sizePolicy().hasHeightForWidth())
self.ar_rb.setSizePolicy(sizePolicy)
#All-rounder radio button
self.ar_rb.setObjectName("ar_rb")
self.horizontalLayout_2.addWidget(self.ar_rb)
self.wk_rb = QtWidgets.QRadioButton(self.frame_5)
self.wk_rb.setEnabled(False)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.wk_rb.sizePolicy().hasHeightForWidth())
self.wk_rb.setSizePolicy(sizePolicy)
#Wicket-keeper radio button
self.wk_rb.setObjectName("wk_rb")
self.horizontalLayout_2.addWidget(self.wk_rb)
self.verticalLayout.addWidget(self.frame_5)
#Available player list(list-widget1)
self.av_player = QtWidgets.QListWidget(self.frame_3)
self.av_player.setFrameShape(QtWidgets.QFrame.NoFrame)
self.av_player.setObjectName("av_player")
self.verticalLayout.addWidget(self.av_player)
self.horizontalLayout_4.addWidget(self.frame_3)
spacerItem2 = QtWidgets.QSpacerItem(13, 345, QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem2)
self.label_9 = QtWidgets.QLabel(self.central_w)
self.label_9.setStyleSheet("font: 20pt \"MS Shell Dlg 2\";")
self.label_9.setLineWidth(-10)
self.label_9.setMidLineWidth(-10)
self.label_9.setObjectName("label_9")
self.horizontalLayout_4.addWidget(self.label_9)
spacerItem3 = QtWidgets.QSpacerItem(13, 345, QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem3)
self.frame_4 = QtWidgets.QFrame(self.central_w)
self.frame_4.setStyleSheet("border-color: rgb(120, 120, 120);")
self.frame_4.setFrameShape(QtWidgets.QFrame.Panel)
self.frame_4.setFrameShadow(QtWidgets.QFrame.Plain)
self.frame_4.setLineWidth(2)
self.frame_4.setMidLineWidth(1)
self.frame_4.setObjectName("frame_4")
self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.frame_4)
self.verticalLayout_2.setContentsMargins(18, 9, 14, -1)
self.verticalLayout_2.setSpacing(6)
self.verticalLayout_2.setObjectName("verticalLayout_2")
self.frame_6 = QtWidgets.QFrame(self.frame_4)
self.frame_6.setStyleSheet("font: 75 10pt \"MS Shell Dlg 2\";")
self.frame_6.setFrameShape(QtWidgets.QFrame.NoFrame)
self.frame_6.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_6.setObjectName("frame_6")
self.horizontalLayout_3 = QtWidgets.QHBoxLayout(self.frame_6)
self.horizontalLayout_3.setObjectName("horizontalLayout_3")
self.label_8 = QtWidgets.QLabel(self.frame_6)
self.label_8.setObjectName("label_8")
self.horizontalLayout_3.addWidget(self.label_8, 0, QtCore.Qt.AlignHCenter)
self.team_name = QtWidgets.QLabel(self.frame_6)
self.team_name.setStyleSheet("color: rgb(85, 170, 255);")
self.team_name.setObjectName("team_name")
self.horizontalLayout_3.addWidget(self.team_name)
self.verticalLayout_2.addWidget(self.frame_6)
#Selected player list(list widget-2)
self.sel_player = QtWidgets.QListWidget(self.frame_4)
self.sel_player.setFrameShape(QtWidgets.QFrame.NoFrame)
self.sel_player.setObjectName("sel_player")
self.verticalLayout_2.addWidget(self.sel_player)
self.horizontalLayout_4.addWidget(self.frame_4)
spacerItem4 = QtWidgets.QSpacerItem(13, 345, QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem4)
self.verticalLayout_3.addLayout(self.horizontalLayout_4)
MainWindow.setCentralWidget(self.central_w)
#Menubar option
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 860, 26))
self.menubar.setObjectName("menubar")
self.menuManage_Teams = QtWidgets.QMenu(self.menubar)
self.menuManage_Teams.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor))
self.menuManage_Teams.setStyleSheet("selection-background-color: rgb(0, 170, 255);\n"
"\n"
"")
self.menuManage_Teams.setObjectName("menuManage_Teams")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
#New window
self.new_t = QtWidgets.QAction(MainWindow)
self.new_t.setShortcut("Ctrl+N")
self.new_t.setIconText("NEW Team")
self.new_t.setShortcutContext(QtCore.Qt.WindowShortcut)
self.new_t.setVisible(True)
self.new_t.setShortcutVisibleInContextMenu(True)
self.new_t.setObjectName("new_t")
self.menuManage_Teams.addAction(self.new_t)
self.new_t.triggered.connect(self.file_new)
#Open window
self.open_t = QtWidgets.QAction(MainWindow)
self.open_t.setObjectName("open_t")
self.menuManage_Teams.addAction(self.open_t)
self.open_t.triggered.connect(self.file_open)
#Save window
self.save_t = QtWidgets.QAction(MainWindow)
self.save_t.setObjectName("save_t")
self.menuManage_Teams.addAction(self.save_t)
self.save_t.triggered.connect(self.file_save)
#Evaluate window
self.evaluat_t = QtWidgets.QAction(MainWindow)
self.evaluat_t.setObjectName("evaluat_t")
self.menuManage_Teams.addAction(self.evaluat_t)
self.evaluat_t.triggered.connect(self.file_evaluate)
#Exit window
self.actionQuit = QtWidgets.QAction(MainWindow)
self.actionQuit.setObjectName("actionQuit")
self.menuManage_Teams.addAction(self.actionQuit)
self.actionQuit.triggered.connect(self.quit)
self.menubar.addAction(self.menuManage_Teams.menuAction())
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
# Click-double
self.av_player.itemDoubleClicked.connect(self.removelist1)
self.sel_player.itemDoubleClicked.connect(self.removelist2)
# Initializing points
self.avail_points = 1000
self.used_points = 0
self.totalcount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.alrdscount = 0
self.wicketerscount = 0
# Stats of player
self.stats = {}
self.new_screen.savename.clicked.connect(self.namechange)
# Initializing list
self.a = [] # Bowler names list
self.b = [] # Batsman nameslist
self.c = [] # Allrounder names list
self.d = [] #Wicketer names list
self.list1 = [] # Selectedplayer's list
# Radiobuttons clicked
self.bat_rb.clicked.connect(self.load_names)
self.wk_rb.clicked.connect(self.load_names)
self.bow_rb.clicked.connect(self.load_names)
self.ar_rb.clicked.connect(self.load_names)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.label_10.setText(_translate("MainWindow", "AllRounders (AR) "))
self.BOWL.setText(_translate("MainWindow", "##"))
self.ARL.setText(_translate("MainWindow", "##"))
self.BAT.setText(_translate("MainWindow", "##"))
self.label_2.setText(_translate("MainWindow", "Batsman (BAT)"))
self.WK.setText(_translate("MainWindow", "##"))
self.label_12.setText(_translate("MainWindow", "Wicket-Keeper (WK)"))
self.label_4.setText(_translate("MainWindow", "Bowlers (BOW)"))
self.label.setText(_translate("MainWindow", "Your Selection"))
self.label_6.setText(_translate("MainWindow", "Points Availables"))
self.points_available.setText(_translate("MainWindow", "####"))
self.label_7.setText(_translate("MainWindow", "Points Used"))
self.points_used.setText(_translate("MainWindow", "####"))
self.bat_rb.setText(_translate("MainWindow", "BAT"))
self.bow_rb.setText(_translate("MainWindow", "BOW"))
self.ar_rb.setText(_translate("MainWindow", "AR"))
self.wk_rb.setText(_translate("MainWindow", "WK"))
self.label_9.setText(_translate("MainWindow", ">"))
self.label_8.setText(_translate("MainWindow", "Team Name :"))
self.team_name.setText(_translate("MainWindow", "Displayed Here"))
self.menuManage_Teams.setTitle(_translate("MainWindow", "Manage Teams"))
self.new_t.setText(_translate("MainWindow", "NEW Team"))
self.new_t.setShortcut(_translate("MainWindow", "Ctrl+N"))
self.open_t.setText(_translate("MainWindow", "OPEN Team"))
self.open_t.setShortcut(_translate("MainWindow", "Ctrl+O"))
self.save_t.setText(_translate("MainWindow", "SAVE team"))
self.save_t.setShortcut(_translate("MainWindow", "Ctrl+S"))
self.evaluat_t.setText(_translate("MainWindow", "EVALUATE Team"))
self.evaluat_t.setShortcut(_translate("MainWindow", "Ctrl+E"))
self.actionQuit.setText(_translate("MainWindow", "QUIT"))
# File Open menu
def file_open(self):
self.openDialog.show()
# Evaluate team menu
def file_evaluate(self):
self.eval_screen.setupUi(self.EvaluateWindow)
self.EvaluateWindow.show()
# Function for new file menu
def file_new(self):
self.newDialog.show()
def namechange(self):
teamname = self.new_screen.team_name.text()
cur.execute("SELECT DISTINCT Name FROM teams")
data = cur.fetchall() #fetching records
for i in data:
if i[0] == teamname:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Information)
msg.setText("Team with same name already exists!!\nPlease choose another name")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
if len(teamname) == 0:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("You cannot leave the field blank!!!")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
elif teamname.isnumeric():
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("Please enter a valid teamname\n(Name must contain atleast one character)!!")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
else:
self.reset()
self.tname = self.new_screen.team_name.text()
self.team_name.setText(str(' '+self.tname))
self.newDialog.close()
#Function for reset
def reset(self):
self.enablebuttons()
self.load_names()
self.used_points = 0
self.alrdscount = 0
self.wicketerscount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.totalcount = 0
self.avail_points = 1000
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
self.list1.clear()
self.load_names()
self.sel_player.clear()
#Function for save team
def file_save(self):
if not self.error(): #check for error
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Inufficient Players OR Points !!')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
elif self.error():
#To catch exceptions
try:
cur.execute("SELECT DISTINCT Name FROM teams;")
data = cur.fetchall()
for i in data:
if self.team_name.text() == i[0]: # Check if team already exists
print('Updating already there')
cur.execute("DELETE FROM teams WHERE Name='" + self.team_name.text() + "';") #Delete the updated team
#To handle exception
except:
print('error')
for i in range(self.sel_player.count()):
#To catch exception
try:
cur.execute("INSERT INTO teams (Name,Players,Value) VALUES (?,?,?)",
(self.team_name.text(), self.list1[i], player_point[self.list1[i]]))
#To handle exceptions
except:
print('error in operation!')
db.commit() #Commit function
else:
print('---error in operation')
# Exit() function
def quit(self):
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Bye ')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
sys.exit()
#Radio-buttons functions
def load_names(self):
Batsman = 'BAT'
WicketKeeper = 'WK'
Allrounder = 'AR'
Bowler = 'BWL'
sql1 = "SELECT Player,Value from stats WHERE ctg = '" + Batsman + "';"
sql2 = "SELECT Player,Value from stats WHERE ctg = '" + WicketKeeper + "';"
sql3 = "SELECT Player,Value from stats WHERE ctg ='" + Allrounder + "';"
sql4 = "SELECT Player,Value from stats WHERE ctg = '" + Bowler + "';"
#for batsmen
cur.execute(sql1)
x = cur.fetchall()
batsmen = []
for k in x:
batsmen.append(k[0])
self.b.append(k[0])
self.stats[k[0]] = k[1]
#for bowlers
cur.execute(sql2)
w = cur.fetchall()
bowlers = []
for k in y:
bowlers.append(k[0])
self.stats[k[0]] = k[1]
self.a.append(k[0])
#for all rounder
cur.execute(sql3)
z =cur.fetchall()
allrounders = []
for k in z:
allrounders.append(k[0])
self.stats[k[0]] = k[1]
self.c.append(k[0])
#for wicket keepers
cur.execute(sql4)
y = cur.fetchall()
wcktkeepers = []
for k in w:
wcktkeepers.append(k[0])
self.stats[k[0]] = k[1]
self.d.append(k[0])
for i in self.list1:
if i in allrounders:
allrounders.remove(i)
elif i in batsmen:
batsmen.remove(i)
elif i in bowlers:
bowlers.remove(i)
elif i in wcktkeepers:
wcktkeepers.remove(i)
if self.bat_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(batsmen)):
item = QtWidgets.QListWidgetItem(batsmen[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.bow_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(bowlers)):
item = QtWidgets.QListWidgetItem(bowlers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.ar_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(allrounders)):
item = QtWidgets.QListWidgetItem(allrounders[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.wk_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(wcktkeepers)):
item = QtWidgets.QListWidgetItem(wcktkeepers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
def removelist1(self, item): # Removing from available list to select list
self.conditions_1(item.text())
self.av_player.takeItem(self.av_player.row(item))
self.sel_player.addItem(item.text())
self.totalcount = self.sel_player.count()
self.list1.append(item.text())
self.error()
def conditions_1(self, cat): # Evaluate respective points calculate points
self.avail_points -= self.stats[cat]
self.used_points += self.stats[cat]
if cat in self.a:
self.bowlerscount += 1
elif cat in self.d:
self.wicketerscount += 1
elif cat in self.c:
self.alrdscount += 1
elif cat in self.b:
self.batsmencount += 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def conditions_2(self, cat): # Evaluate respective points calculate points
self.avail_points += self.stats[cat]
self.used_points -= self.stats[cat]
if cat in self.a:
self.bowlerscount -= 1
elif cat in self.d:
self.wicketerscount -= 1
elif cat in self.c:
self.alrdscount -= 1
elif cat in self.b:
self.batsmencount -= 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def removelist2(self, item): # Remove from available list to select list
self.sel_player.takeItem(self.sel_player.row(item))
self.av_player.addItem(item.text())
self.list1.remove(item.text())
self.totalcount = self.sel_player.count()
self.conditions_2(item.text())
def openteam(self): #Open team
self.reset()
teamname = self.open_screen.open_cb.currentText()
self.team_name.setText(teamname)
self.enablebuttons()
cur.execute("SELECT Players from teams WHERE Name= '" + teamname + "';")
x=cur.fetchall()
score=[]
for i in x:
cur.execute("SELECT Value from stats WHERE Player='"+i[0]+"';")
y=cur.fetchone()
score.append(y[0])
sum=0
for i in score:
sum+=i
self.sel_player.clear()
self.load_names()
for i in x:
self.sel_player.addItem(i[0])
self.list1.append(i[0])
self.conditions_1(i[0])
self.used_points = sum
self.avail_points = 1000 - sum
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.openDialog.close()
def enablebuttons(self):
self.bat_rb.setEnabled(True)
self.bow_rb.setEnabled(True)
self.ar_rb.setEnabled(True)
self.wk_rb.setEnabled(True)
def disablebuttons(self):
self.bat_rb.setEnabled(False)
self.bow_rb.setEnabled(False)
self.ar_rb.setEnabled(False)
self.wk_rb.setEnabled(False)
def error(self):
msg = QMessageBox()
if self.wicketerscount > 1:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Only 1 wicketkeeper is allowed!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
elif self.totalcount > 11:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('No more than 11 players allowed!')
msg.setWindowTitle("Selection Error")
msg.exec_()
return 0
elif self.totalcount < 11 :
return 0
elif self.wicketerscount < 1:
return 0
elif self.avail_points <= -1:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Not enough points!')
msg.setWindowTitle("Selection Cricket")
msg.exec_()
return 0
return 1
class Ui_MainWindow(object):
def __init__(self):
self.newDialog = QtWidgets.QMainWindow()
self.new_screen = New()
self.new_screen.setupUi(self.newDialog)
self.EvaluateWindow = QtWidgets.QMainWindow()
self.eval_screen = Eva()
self.eval_screen.setupUi(self.EvaluateWindow)
self.openDialog = QtWidgets.QMainWindow()
self.open_screen = Open()
self.open_screen.setupUi(self.openDialog)
# FILE OPENING MENU
def file_open(self):
self.open_screen.setupUi(self.openDialog)
self.openDialog.show()
self.open_screen.openbtn.clicked.connect(self.openteam)
# EVALUATE TEAM MENU
def file_evaluate(self):
self.eval_screen.setupUi(self.EvaluateWindow)
self.EvaluateWindow.show()
def setupUi(self, MainWindow):
# INITIALISING POINTS AND COUNTS
self.avail_points = 1000
self.used_points = 0
self.totalcount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.alrdscount = 0
self.wicketerscount = 0
# INITIALIZING LISTS
self.a = [] # bowler names list
self.b = [] # batsman nameslist
self.c = [] # allrounder names list
self.d = [] #wicketer names list
self.list1 = [] # selectedplayer's list
MainWindow.setObjectName("MainWindow")
MainWindow.resize(800, 600)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.frame = QtWidgets.QFrame(self.centralwidget)
self.frame.setGeometry(QtCore.QRect(30, 40, 731, 80))
self.frame.setStyleSheet("background-color: rgb(170, 170, 255);")
self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame.setObjectName("frame")
self.label_2 = QtWidgets.QLabel(self.frame)
self.label_2.setGeometry(QtCore.QRect(10, 50, 121, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.BAT = QtWidgets.QLabel(self.frame)
self.BAT.setGeometry(QtCore.QRect(130, 50, 21, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.BAT.setFont(font)
self.BAT.setStyleSheet("color: rgb(85, 170, 255);\n"
"color: rgb(0, 0, 0);")
self.BAT.setObjectName("BAT")
self.label_4 = QtWidgets.QLabel(self.frame)
self.label_4.setGeometry(QtCore.QRect(10, 10, 121, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_4.setFont(font)
self.label_4.setObjectName("label_4")
self.label_5 = QtWidgets.QLabel(self.frame)
self.label_5.setGeometry(QtCore.QRect(180, 50, 121, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_5.setFont(font)
self.label_5.setObjectName("label_5")
self.BOWL = QtWidgets.QLabel(self.frame)
self.BOWL.setGeometry(QtCore.QRect(300, 50, 21, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.BOWL.setFont(font)
self.BOWL.setStyleSheet("color: rgb(85, 170, 255);\n"
"color: rgb(0, 0, 0);")
self.BOWL.setObjectName("BOWL")
self.label = QtWidgets.QLabel(self.frame)
self.label.setGeometry(QtCore.QRect(360, 50, 141, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label.setFont(font)
self.label.setObjectName("label")
self.ARL = QtWidgets.QLabel(self.frame)
self.ARL.setGeometry(QtCore.QRect(500, 50, 21, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.ARL.setFont(font)
self.ARL.setStyleSheet("color: rgb(85, 170, 255);\n"
"color: rgb(0, 0, 0);")
self.ARL.setObjectName("ARL")
self.label_10 = QtWidgets.QLabel(self.frame)
self.label_10.setGeometry(QtCore.QRect(540, 50, 151, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_10.setFont(font)
self.label_10.setObjectName("label_10")
self.WK = QtWidgets.QLabel(self.frame)
self.WK.setGeometry(QtCore.QRect(690, 50, 21, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.WK.setFont(font)
self.WK.setStyleSheet("color: rgb(85, 170, 255);\n"
"color: rgb(0, 0, 0);")
self.WK.setObjectName("WK")
self.frame_2 = QtWidgets.QFrame(self.centralwidget)
self.frame_2.setGeometry(QtCore.QRect(30, 220, 731, 311))
self.frame_2.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_2.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_2.setObjectName("frame_2")
self.av_player = QtWidgets.QListWidget(self.frame_2)
self.av_player.setGeometry(QtCore.QRect(0, 50, 291, 261))
self.av_player.setObjectName("av_player")
self.sel_player = QtWidgets.QListWidget(self.frame_2)
self.sel_player.setGeometry(QtCore.QRect(440, 50, 291, 261))
self.sel_player.setObjectName("sel_player")
self.label_14 = QtWidgets.QLabel(self.frame_2)
self.label_14.setGeometry(QtCore.QRect(340, 140, 55, 41))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(16)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_14.setFont(font)
self.label_14.setObjectName("label_14")
self.frame_4 = QtWidgets.QFrame(self.frame_2)
self.frame_4.setGeometry(QtCore.QRect(-1, 0, 291, 51))
self.frame_4.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_4.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_4.setObjectName("frame_4")
self.horizontalLayout = QtWidgets.QHBoxLayout(self.frame_4)
self.horizontalLayout.setObjectName("horizontalLayout")
self.bat_rb = QtWidgets.QRadioButton(self.frame_4)
self.bat_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.bat_rb.setFont(font)
self.bat_rb.setObjectName("bat_rb")
self.horizontalLayout.addWidget(self.bat_rb)
self.bow_rb = QtWidgets.QRadioButton(self.frame_4)
self.bow_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.bow_rb.setFont(font)
self.bow_rb.setObjectName("bow_rb")
self.horizontalLayout.addWidget(self.bow_rb)
self.ar_rb = QtWidgets.QRadioButton(self.frame_4)
self.ar_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.ar_rb.setFont(font)
self.ar_rb.setObjectName("ar_rb")
self.horizontalLayout.addWidget(self.ar_rb)
self.wk_rb = QtWidgets.QRadioButton(self.frame_4)
self.wk_rb.setEnabled(False)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.wk_rb.setFont(font)
self.wk_rb.setObjectName("wk_rb")
self.horizontalLayout.addWidget(self.wk_rb)
self.frame_5 = QtWidgets.QFrame(self.frame_2)
self.frame_5.setGeometry(QtCore.QRect(440, 0, 291, 40))
self.frame_5.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_5.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_5.setObjectName("frame_5")
self.horizontalLayout_2 = QtWidgets.QHBoxLayout(self.frame_5)
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_15 = QtWidgets.QLabel(self.frame_5)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_15.setFont(font)
self.label_15.setObjectName("label_15")
self.horizontalLayout_2.addWidget(self.label_15)
self.team_name = QtWidgets.QLabel(self.frame_5)
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.team_name.setFont(font)
self.team_name.setStyleSheet("color: rgb(85, 170, 255);")
self.team_name.setObjectName("team_name")
self.horizontalLayout_2.addWidget(self.team_name)
self.frame_3 = QtWidgets.QFrame(self.centralwidget)
self.frame_3.setGeometry(QtCore.QRect(30, 150, 721, 51))
self.frame_3.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame_3.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame_3.setObjectName("frame_3")
self.label_9 = QtWidgets.QLabel(self.frame_3)
self.label_9.setGeometry(QtCore.QRect(10, 20, 131, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_9.setFont(font)
self.label_9.setObjectName("label_9")
self.points_available = QtWidgets.QLabel(self.frame_3)
self.points_available.setGeometry(QtCore.QRect(140, 20, 41, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.points_available.setFont(font)
self.points_available.setObjectName("points_available")
self.label_12 = QtWidgets.QLabel(self.frame_3)
self.label_12.setGeometry(QtCore.QRect(430, 20, 101, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.label_12.setFont(font)
self.label_12.setObjectName("label_12")
self.points_used = QtWidgets.QLabel(self.frame_3)
self.points_used.setGeometry(QtCore.QRect(530, 20, 41, 16))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(10)
font.setBold(True)
font.setItalic(True)
font.setWeight(75)
self.points_used.setFont(font)
self.points_used.setObjectName("points_used")
MainWindow.setCentralWidget(self.centralwidget)
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 26))
self.menubar.setObjectName("menubar")
self.menuFile = QtWidgets.QMenu(self.menubar)
self.menuFile.setObjectName("menuFile")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
self.new_t = QtWidgets.QAction(MainWindow)
self.new_t.setObjectName("new_t")
self.open_t = QtWidgets.QAction(MainWindow)
self.open_t.setObjectName("open_t")
self.save_t = QtWidgets.QAction(MainWindow)
self.save_t.setObjectName("save_t")
self.evaluat_t = QtWidgets.QAction(MainWindow)
self.evaluat_t.setObjectName("evaluat_t")
self.menuFile.addAction(self.new_t)
self.menuFile.addAction(self.open_t)
self.menuFile.addAction(self.save_t)
self.menuFile.addAction(self.evaluat_t)
self.menubar.addAction(self.menuFile.menuAction())
#Action teiggered
self.new_t.triggered.connect(self.file_new)
self.open_t.triggered.connect(self.file_open)
self.save_t.triggered.connect(self.file_save)
self.evaluat_t.triggered.connect(self.file_evaluate)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
# DOUBLE CLICK
self.av_player.itemDoubleClicked.connect(self.removelist1)
self.sel_player.itemDoubleClicked.connect(self.removelist2)
# -----stats of player
self.stats = {}
self.new_screen.savename.clicked.connect(self.namechange)
# RADIOBUTTONS CLICK
self.bat_rb.clicked.connect(self.load_names)
self.wk_rb.clicked.connect(self.load_names)
self.bow_rb.clicked.connect(self.load_names)
self.ar_rb.clicked.connect(self.load_names)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.label_2.setText(_translate("MainWindow", "Batsmen(BAT)"))
self.BAT.setText(_translate("MainWindow", "##"))
self.label_4.setText(_translate("MainWindow", "Your Selections"))
self.label_5.setText(_translate("MainWindow", "Bowlers(BOW)"))
self.BOWL.setText(_translate("MainWindow", "##"))
self.label.setText(_translate("MainWindow", "All Rounders(AR)"))
self.ARL.setText(_translate("MainWindow", "##"))
self.label_10.setText(_translate("MainWindow", "Wicket Keeper(WK)"))
self.WK.setText(_translate("MainWindow", "##"))
self.label_14.setText(_translate("MainWindow", " >"))
self.bat_rb.setText(_translate("MainWindow", "BAT"))
self.bow_rb.setText(_translate("MainWindow", "BOW"))
self.ar_rb.setText(_translate("MainWindow", "AR"))
self.wk_rb.setText(_translate("MainWindow", "WK"))
self.label_15.setText(_translate("MainWindow", "Team Name"))
self.team_name.setText(_translate("MainWindow", "Displayed Here"))
self.label_9.setText(_translate("MainWindow", "Points Available "))
self.points_available.setText(_translate("MainWindow", "####"))
self.label_12.setText(_translate("MainWindow", "Points Used"))
self.points_used.setText(_translate("MainWindow", "####"))
self.menuFile.setTitle(_translate("MainWindow", "Manage Teams"))
self.new_t.setText(_translate("MainWindow", "NEW Team"))
self.open_t.setText(_translate("MainWindow", "OPEN Team"))
self.save_t.setText(_translate("MainWindow", "SAVE Team"))
self.evaluat_t.setText(_translate("MainWindow", "EVALUATE Team"))
# NEW FILE MENU
def file_new(self):
self.newDialog.show()
def namechange(self):
teamname = self.new_screen.team_name.text()
fantcurs.execute("SELECT DISTINCT name FROM teams")
l = fantcurs.fetchall()
for i in l:
if i[0] == teamname:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Information)
msg.setText(
"Team with same name already exists!!\nPlease choose another name"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
if len(teamname) == 0:
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText("You cannot leave the field blank!!!")
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
elif teamname.isnumeric():
msg = QtWidgets.QMessageBox()
msg.setIcon(QtWidgets.QMessageBox.Warning)
msg.setText(
"Please enter a valid teamname\n(Name must contain atleast one character)!!"
)
msg.setWindowTitle("Invalid Team Name")
msg.exec_()
return 0
else:
self.reset()
self.tname = self.new_screen.team_name.text()
self.team_name.setText(str(' ' + self.tname))
self.newDialog.close()
#TO RESET ALL COUNTS AND LITS
def reset(self):
self.enablebuttons()
self.load_names()
self.used_points = 0
self.alrdscount = 0
self.wicketerscount = 0
self.batsmencount = 0
self.bowlerscount = 0
self.totalcount = 0
self.avail_points = 1000
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
self.list1.clear()
self.load_names()
self.sel_player.clear()
#SAVE TEAM MENU
def file_save(self):
if not self.error(): #IF THERE IS AN ERROR
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText(' Inufficient Players OR Points !!')
msg.setWindowTitle("Fantasy Cricket")
msg.exec_()
elif self.error(): # IF NO ERROR
try:
fantcurs.execute("SELECT DISTINCT name FROM teams;")
x = fantcurs.fetchall()
for i in x:
if self.team_name.text(
) == i[0]: # CHECKING IF THE TEAMNAME ALREADY EXISTS
print('Updating already there')
fantcurs.execute("DELETE FROM teams WHERE name='" +
self.team_name.text() +
"';") #DELETING TO UPDATE TEAM
except:
print('error')
for i in range(self.sel_player.count()):
# print('----addding--')
# print('teamnane: ',self.team_name.text())
# print('playername: ',self.list1[i])
# print('points: ', player_points[self.list1[i]])
try:
fantcurs.execute(
"INSERT INTO teams (name,players,value) VALUES (?,?,?)",
(self.team_name.text(), self.list1[i],
player_points[self.list1[i]]))
# self.file_evaluate()
except:
print('error in operation!')
fant.commit()
else:
print('---error in operation')
#ON RADIOBUTTONS CLICKED
def load_names(self):
Batsman = 'BAT'
WicketKeeper = 'WK'
Allrounder = 'AR'
Bowler = 'BWL'
sql1 = "SELECT player,value from stats WHERE ctg = '" + Batsman + "';"
sql2 = "SELECT Player,value from stats WHERE ctg = '" + WicketKeeper + "';"
sql3 = "SELECT Player,value from stats WHERE ctg ='" + Allrounder + "';"
sql4 = "SELECT Player,value from stats WHERE ctg = '" + Bowler + "';"
fantcurs.execute(sql1)
x = fantcurs.fetchall()
fantcurs.execute(sql4)
y = fantcurs.fetchall()
fantcurs.execute(sql3)
z = fantcurs.fetchall()
fantcurs.execute(sql2)
w = fantcurs.fetchall()
batsmen = []
bowlers = []
allrounders = []
wcktkeepers = []
for k in x:
batsmen.append(k[0])
self.b.append(k[0])
self.stats[k[0]] = k[1]
for k in y:
bowlers.append(k[0])
self.stats[k[0]] = k[1]
self.a.append(k[0])
for k in w:
wcktkeepers.append(k[0])
self.stats[k[0]] = k[1]
self.d.append(k[0])
for k in z:
allrounders.append(k[0])
self.stats[k[0]] = k[1]
self.c.append(k[0])
for i in self.list1:
if i in allrounders:
allrounders.remove(i)
elif i in batsmen:
batsmen.remove(i)
elif i in bowlers:
bowlers.remove(i)
elif i in wcktkeepers:
wcktkeepers.remove(i)
if self.bat_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(batsmen)):
item = QtWidgets.QListWidgetItem(batsmen[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.bow_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(bowlers)):
item = QtWidgets.QListWidgetItem(bowlers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.ar_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(allrounders)):
item = QtWidgets.QListWidgetItem(allrounders[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
elif self.wk_rb.isChecked() == True:
self.av_player.clear()
for i in range(len(wcktkeepers)):
item = QtWidgets.QListWidgetItem(wcktkeepers[i])
font = QtGui.QFont()
font.setBold(True)
font.setWeight(75)
item.setFont(font)
self.av_player.addItem(item)
def removelist1(
self,
item): # REMOVE FROM AVAILABLE PLAYERS AND ADD TO SELECTED PLAYERS
self.conditions_1(item.text())
self.av_player.takeItem(self.av_player.row(item))
self.sel_player.addItem(item.text())
self.totalcount = self.sel_player.count()
self.list1.append(item.text())
self.error()
def conditions_1(
self, cat
): # Adding and Deducting respective points from points_calculator.py
self.avail_points -= self.stats[cat]
self.used_points += self.stats[cat]
if cat in self.a:
self.bowlerscount += 1
elif cat in self.d:
self.wicketerscount += 1
elif cat in self.c:
self.alrdscount += 1
elif cat in self.b:
self.batsmencount += 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def conditions_2(
self, cat
): # Adding and Deducting respective poinrs from points_calculator.py
self.avail_points += self.stats[cat]
self.used_points -= self.stats[cat]
if cat in self.a:
self.bowlerscount -= 1
elif cat in self.d:
self.wicketerscount -= 1
elif cat in self.c:
self.alrdscount -= 1
elif cat in self.b:
self.batsmencount -= 1
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.BOWL.setText(str(self.bowlerscount))
self.BAT.setText(str(self.batsmencount))
self.ARL.setText(str(self.alrdscount))
self.WK.setText(str(self.wicketerscount))
def removelist2(
self,
item): # REMOVE FROM SELECTED PLAYERS AND ADD TO AVAIALBLE PLAYERS
self.sel_player.takeItem(self.sel_player.row(item))
self.av_player.addItem(item.text())
self.list1.remove(item.text())
# self.error()
self.totalcount = self.sel_player.count()
self.conditions_2(item.text())
def openteam(self): #upon open team selected
self.reset()
teamname = self.open_screen.open_cb.currentText()
self.team_name.setText(teamname)
self.enablebuttons()
fantcurs.execute("SELECT players from teams WHERE name= '" + teamname +
"';")
x = fantcurs.fetchall()
score = []
for i in x:
fantcurs.execute("SELECT value from stats WHERE player='" + i[0] +
"';")
y = fantcurs.fetchone()
score.append(y[0])
# print(score)
sum = 0
for i in score:
sum += i
self.sel_player.clear()
self.load_names()
for i in x:
self.sel_player.addItem(i[0])
self.list1.append(i[0])
self.conditions_1(i[0])
self.used_points = sum
self.avail_points = 1000 - sum
self.points_available.setText(str(self.avail_points))
self.points_used.setText(str(self.used_points))
self.openDialog.close()
def enablebuttons(self):
self.bat_rb.setEnabled(True)
self.bow_rb.setEnabled(True)
self.ar_rb.setEnabled(True)
self.wk_rb.setEnabled(True)
def disablebuttons(self):
self.bat_rb.setEnabled(False)
self.bow_rb.setEnabled(False)
self.ar_rb.setEnabled(False)
self.wk_rb.setEnabled(False)
def error(self):
msg = QMessageBox()
if self.wicketerscount > 1:
msg.setIcon(QMessageBox.Critical)
# msg.setText("Error")
msg.setInformativeText('Only 1 wicketkeeper is allowed!')
msg.setWindowTitle("Error")
msg.exec_()
return 0
elif self.totalcount > 11:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('No more than 11 players allowed!')
msg.setWindowTitle("Selection Error")
msg.exec_()
return 0
elif self.totalcount < 11:
return 0
elif self.wicketerscount < 1:
return 0
elif self.avail_points <= -1:
msg.setIcon(QMessageBox.Critical)
msg.setInformativeText('Not enough points!')
msg.setWindowTitle("Selection Cricket")
msg.exec_()
return 0
return 1
