Py-cricket/evaluatewindow.py at master · deepnik/Py-cricket · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
import sqlite3
from PyQt5 import QtCore, QtGui, QtWidgets
myteam= sqlite3.connect("TEAM.db")

class Ui_EvaluateWindow(object):
    def setupUi(self, EvaluateWindow):
        EvaluateWindow.setObjectName("EvaluateWindow")
        EvaluateWindow.resize(699, 509)
        self.centralwidget = QtWidgets.QWidget(EvaluateWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.horizontalLayoutWidget = QtWidgets.QWidget(self.centralwidget)
        self.horizontalLayoutWidget.setGeometry(QtCore.QRect(90, 180, 521, 251))
        self.horizontalLayoutWidget.setObjectName("horizontalLayoutWidget")
        self.horizontalLayout = QtWidgets.QHBoxLayout(self.horizontalLayoutWidget)
        self.horizontalLayout.setContentsMargins(0, 0, 0, 0)
        self.horizontalLayout.setObjectName("horizontalLayout")

        self.PlayerList = QtWidgets.QListWidget(self.horizontalLayoutWidget)
        self.PlayerList.setObjectName("listView")
        self.horizontalLayout.addWidget(self.PlayerList)

        self.ScoreList = QtWidgets.QListWidget(self.horizontalLayoutWidget)
        self.ScoreList.setObjectName("listView_2")
        self.horizontalLayout.addWidget(self.ScoreList)


        self.horizontalLayoutWidget_2 = QtWidgets.QWidget(self.centralwidget)
        self.horizontalLayoutWidget_2.setGeometry(QtCore.QRect(100, 110, 501, 51))
        self.horizontalLayoutWidget_2.setObjectName("horizontalLayoutWidget_2")
        self.horizontalLayout_2 = QtWidgets.QHBoxLayout(self.horizontalLayoutWidget_2)
        self.horizontalLayout_2.setContentsMargins(0, 0, 0, 0)
        self.horizontalLayout_2.setObjectName("horizontalLayout_2")

        #label players
        self.Players = QtWidgets.QLabel(self.horizontalLayoutWidget_2)
        font = QtGui.QFont()
        font.setPointSize(9)
        font.setBold(True)
        font.setWeight(75)
        self.Players.setFont(font)
        self.Players.setAlignment(QtCore.Qt.AlignCenter)
        self.Players.setIndent(10)
        self.Players.setObjectName("Players")
        self.horizontalLayout_2.addWidget(self.Players)

        #label points
        self.Points = QtWidgets.QLabel(self.horizontalLayoutWidget_2)
        font = QtGui.QFont()
        font.setPointSize(9)
        font.setBold(True)
        font.setWeight(75)
        self.Points.setFont(font)
        self.Points.setAlignment(QtCore.Qt.AlignCenter)
        self.Points.setIndent(10)
        self.Points.setObjectName("Points")
        self.horizontalLayout_2.addWidget(self.Points)

        #PUSHBUTTON
        self.Calculate = QtWidgets.QPushButton(self.centralwidget)
        self.Calculate.setGeometry(QtCore.QRect(300, 440, 93, 28))
        self.Calculate.setObjectName("Calculate")


        #combox 1
        self.SelectTeam = QtWidgets.QComboBox(self.centralwidget)
        self.SelectTeam.setGeometry(QtCore.QRect(150, 50, 141, 22))
        self.SelectTeam.setObjectName("SelectTeam")

        #combox2
        self.Selectmatch = QtWidgets.QComboBox(self.centralwidget)
        self.Selectmatch.setGeometry(QtCore.QRect(400, 50, 141, 22))
        self.Selectmatch.setObjectName("Selectmatch")
        self.SelectTeam.addItem("")
        self.Selectmatch.addItem("")
        self.Selectmatch.addItem("")
        self.Selectmatch.addItem("")
        self.Selectmatch.addItem("")
        self.Selectmatch.addItem("")

        self.line = QtWidgets.QFrame(self.centralwidget)
        self.line.setGeometry(QtCore.QRect(60, 80, 591, 20))
        self.line.setFrameShape(QtWidgets.QFrame.HLine)
        self.line.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line.setObjectName("line")

        EvaluateWindow.setCentralWidget(self.centralwidget)
        self.statusbar = QtWidgets.QStatusBar(EvaluateWindow)
        self.statusbar.setObjectName("statusbar")
        EvaluateWindow.setStatusBar(self.statusbar)

        self.retranslateUi(EvaluateWindow)
        QtCore.QMetaObject.connectSlotsByName(EvaluateWindow)

    def retranslateUi(self, EvaluateWindow):
        _translate = QtCore.QCoreApplication.translate
        EvaluateWindow.setWindowTitle(_translate("EvaluateWindow", "MainWindow"))
        self.Players.setText(_translate("EvaluateWindow", "Players"))
        self.Points.setText(_translate("EvaluateWindow", "Points"))
        self.Calculate.setText(_translate("EvaluateWindow", "Calculate"))
        self.SelectTeam.setItemText(0,_translate('EvaluateWindow', "--SELECT TEAM--"))
        self.Selectmatch.setItemText(0,_translate('EvaluateWindow', "--SELECT MATCH--"))
        self.Selectmatch.setItemText(1,_translate('EvaluateWindow', "Match1"))
        self.Selectmatch.setItemText(2,_translate('EvaluateWindow', "Match2"))
        self.Selectmatch.setItemText(3,_translate('EvaluateWindow', "Match3"))
        self.Selectmatch.setItemText(4,_translate('EvaluateWindow', "Match4"))
        cu= myteam.cursor()
        cu.execute("SELECT NAMES from team;")
        team= cu.fetchall()
        teamlist=[]
        for i in range(len(team)):
            teamlist.append(team[i][0])

        for name in set(teamlist):
            self.SelectTeam.addItem(name)


if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    EvaluateWindow = QtWidgets.QMainWindow()
    ui = Ui_EvaluateWindow()
    ui.setupUi(EvaluateWindow)
    EvaluateWindow.show()
    sys.exit(app.exec_())