-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.py
173 lines (149 loc) · 5.79 KB
/
main.py
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
from PySide2.QtWidgets import QMainWindow, QWidget, QApplication, QVBoxLayout
from PySide2.QtCore import *
from menus import create_menus
from tagdij_modell import MyFormDialog, add_tagdij
from berlet_modell import BerletFormDialog
from napidij_modell import NapidijFormDialog
from adomany_modell import AdomanyFormDialog
from egyeb_befiz_modell import EgyebBefizFormDialog
from kiadas_model import KiadasFormDialog
from members import ManageMembers
from settings import ManageSettings
from PySide2.QtSql import QSqlDatabase, QSqlTableModel, QSqlQuery, QSqlQueryModel
db = QSqlDatabase.addDatabase('QMYSQL')
db.setHostName('localhost')
db.setDatabaseName('gdcadmindb')
db.setUserName('gdcadminuser')
db.setPassword('GdcAdmin1968')
if not db.open():
QMessageBox.critical(
None,
"App Name - Error!",
"Database Error: %s" % db.lastError().text(),
)
sys.exit(1)
class AppWindows(QMainWindow):
def __init__(self):
super(AppWindows, self).__init__()
self.setWindowTitle("Admin for G.D.C powered by Jcigi")
self.resize(1000,800)
widget = QWidget()
main_layout = QVBoxLayout()
widget.setLayout(main_layout)
self.setCentralWidget(widget)
# A menus.py definiálja a menüpontokat
create_menus(self)
@Slot()
def exit_app(self):
QApplication.quit()
@Slot()
def new_member(self):
manage_members_window = ManageMembers(self)
manage_members_window.show()
@Slot()
def new_tagdij(self):
add_tagdij(self)
@Slot()
def new_berlet(self):
self.berlet_form_window = BerletFormDialog()
self.berlet_form_window.setWindowTitle("Bérlet vásárlás")
self.berlet_form_window.show()
model = QSqlTableModel()
model.setTable("kassza")
record = model.record()
record.remove(record.indexOf('id'))
if self.berlet_form_window.exec_():
for i in range(len(self.berlet_form_window.mezo_ertekek)):
record.setValue(i, self.berlet_form_window.mezo_ertekek[i].text())
if model.insertRecord(-1, record):
model.submitAll()
else:
db.rollback()
@Slot()
def new_napidij(self):
self.napidij_form_window = NapidijFormDialog()
self.napidij_form_window.setWindowTitle("Napidíj befizetés")
self.napidij_form_window.show()
model = QSqlTableModel()
model.setTable("kassza")
record = model.record()
record.remove(record.indexOf('id'))
if self.napidij_form_window.exec_():
mezo_rekord = []
for i in range(len(self.napidij_form_window.mezo_ertekek)):
mezo_rekord.append(self.napidij_form_window.mezo_ertekek[i].text())
for i in range(len(mezo_rekord)):
record.setValue(i, mezo_rekord[i])
if model.insertRecord(-1, record):
model.submitAll()
else:
db.rollback()
@Slot()
def new_adomany(self):
self.adomany_form_window = AdomanyFormDialog()
self.adomany_form_window.setWindowTitle("Adomány befizetés")
self.adomany_form_window.show()
model = QSqlTableModel()
model.setTable("kassza")
record = model.record()
record.remove(record.indexOf('id'))
if self.adomany_form_window.exec_():
mezo_rekord = []
for i in range(len(self.adomany_form_window.mezo_ertekek)):
mezo_rekord.append(self.adomany_form_window.mezo_ertekek[i].text())
for i in range(len(mezo_rekord)):
record.setValue(i, mezo_rekord[i])
if model.insertRecord(-1, record):
model.submitAll()
else:
db.rollback()
@Slot()
def new_egyebfiz(self):
self.egyebbefiz_form_window = EgyebBefizFormDialog()
self.egyebbefiz_form_window.setWindowTitle("Egyéb befizetés")
self.egyebbefiz_form_window.show()
model = QSqlTableModel()
model.setTable("kassza")
record = model.record()
record.remove(record.indexOf('id'))
if self.egyebbefiz_form_window.exec_():
mezo_rekord = []
for i in range(len(self.egyebbefiz_form_window.mezo_ertekek)):
mezo_rekord.append(self.egyebbefiz_form_window.mezo_ertekek[i].text())
for i in range(len(mezo_rekord)):
record.setValue(i, mezo_rekord[i])
if model.insertRecord(-1, record):
model.submitAll()
else:
db.rollback()
@Slot()
def settings_slot(self):
manage_settings_window = ManageSettings(self)
manage_settings_window.show()
@Slot()
def new_kiadas(self):
self.kiadas_form_window = KiadasFormDialog()
self.kiadas_form_window.setWindowTitle("Új kiadás rögzítése")
self.kiadas_form_window.show()
model = QSqlTableModel()
model.setTable("kassza")
record = model.record()
record.remove(record.indexOf('id'))
if self.kiadas_form_window.exec_():
mezo_rekord = []
for i in range(len(self.kiadas_form_window.mezo_ertekek)):
if i != 4:
mezo_rekord.append(self.kiadas_form_window.mezo_ertekek[i].text())
else:
mezo_rekord.append(int(self.kiadas_form_window.mezo_ertekek[i].text()) * -1)
for i in range(len(mezo_rekord)):
record.setValue(i, mezo_rekord[i])
if model.insertRecord(-1, record):
model.submitAll()
else:
db.rollback()
if __name__ == '__main__':
app = QApplication([])
win = AppWindows()
win.show()
app.exec_()