-
Notifications
You must be signed in to change notification settings - Fork 0
/
datawindow.py
201 lines (176 loc) · 8.87 KB
/
datawindow.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
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
from data import __data__
from data import checkvar
import datetime
from PyQt5.QtCore import *
from PyQt5.QtWidgets import *
# 데이터 수정창
class DataWindow:
def __init__(self, top, value=None):
master = QDialog(top, Qt.WindowTitleHint | Qt.WindowCloseButtonHint)
self.value = value
# 처음 전체 잔량
self.origin = 0
self.setui(master)
# label = [일자, 품목, 수량, 잔량, 0, 불출자, 비고]
# vart = [QDateEdit(일자), QComboBox(품목), QRadioButton(입고), QRadioButton(출고), QSpinBox(수량),
# , QLineEdit(불출자), QTextEdit(비고)]
def setui(self, root):
grid = QGridLayout(root)
label = list()
vart = list()
label.append(QLabel("일자: "))
grid.addWidget(label[0], 0, 0)
vart.append(QDateEdit(datetime.datetime.today().date()))
vart[0].setCalendarPopup(True)
grid.addWidget(vart[0], 0, 1, 1, 3)
label.append(QLabel("품목: "))
grid.addWidget(label[1], 1, 0)
vart.append(QComboBox())
vart[1].addItem(" ")
for t in __data__.select("select name from product"):
vart[1].addItem(t[0])
grid.addWidget(vart[1], 1, 1, 1, 3)
vart.append(QRadioButton("입고"))
vart.append(QRadioButton("출고"))
label.append(QLabel("수량: "))
grid.addWidget(label[2], 2, 0)
vart.append(QSpinBox())
vart[4].setRange(0, 2147483647)
vart[4].setFixedSize(300, 22)
grid.addWidget(vart[4], 2, 1)
grid.addWidget(vart[2], 2, 2)
grid.addWidget(vart[3], 2, 3)
label.append(QLabel("잔량: "))
grid.addWidget(label[3], 3, 0)
label.append(QLabel(str(self.origin)))
grid.addWidget(label[4], 3, 1, 1, 3)
vart[4].valueChanged.connect(lambda: self.getcharge(vart[2], vart[3], label[4], vart[4].value()))
vart[2].toggled.connect(lambda: self.getcharge(vart[2], vart[3], label[4], vart[4].value()))
vart[3].toggled.connect(lambda: self.getcharge(vart[2], vart[3], label[4], vart[4].value()))
vart[1].currentTextChanged.connect(lambda: self.setcharge(vart[2], vart[3], vart[1].currentText(), label[4],
vart[4].value(), vart[0].date().toPyDate()))
vart[0].dateChanged.connect(lambda: self.setcharge(vart[2], vart[3], vart[1].currentText(), label[4],
vart[4].value(), vart[0].date().toPyDate()))
label.append(QLabel("불출자: "))
grid.addWidget(label[5], 4, 0)
vart.append(QLineEdit())
grid.addWidget(vart[5], 4, 1, 1, 3)
label.append(QLabel("비고: "))
grid.addWidget(label[6], 5, 0)
vart.append(QTextEdit())
grid.addWidget(vart[6], 5, 1, 1, 3)
if self.value is None:
root.setWindowTitle("데이터 추가")
else:
root.setWindowTitle("데이터 수정")
vart[0].setDate(self.value[0])
t = vart[1].findText(self.value[1])
if t != -1:
vart[1].setCurrentIndex(t)
# 입고가 0 이면
if self.value[2] == 0:
vart[4].setValue(self.value[3])
vart[3].setChecked(True)
# 출고가 0 이면
elif self.value[3] == 0:
vart[4].setValue(self.value[2])
vart[2].setChecked(True)
vart[5].setText(self.value[4])
vart[6].setPlainText(self.value[5])
confirm = QPushButton("확인")
confirm.clicked.connect(lambda: self.confirmaction(vart, label[4], root, self.value is None))
grid.addWidget(confirm, 6, 0, 1, 4)
root.setLayout(grid)
root.adjustSize()
root.setFixedSize(root.size())
root.show()
def confirmaction(self, input, charge, root, mode):
result = list()
result.append(input[0].date().toPyDate()) #0
result.append(str(input[1].currentText())) #1
result.append(input[2].isChecked()) #2 입고
result.append(input[3].isChecked()) #3 츨고
result.append(input[4].value()) #4
result.append(str(input[5].text())) #5
result.append(str(input[6].toPlainText())) #6
msg = QMessageBox
if result[1] == " ":
msg.warning(root, "품명", "품명을 선택하지 않았습니다", QMessageBox.Ok)
input[1].setFocus()
return
elif int(result[4]) == 0:
msg.warning(root, "수량", "수량을 입력하지 않았습니다", QMessageBox.Ok)
input[4].setFocus()
return
elif result[2] is False and result[3] is False:
msg.warning(root, "입고 여부", "입고 여부를 선택하지 않았습니다", QMessageBox.Ok)
input[2].setFocus()
return
elif int(str(charge.text())) < 0 and result[3]:
msg.warning(root, "수량", "출고량이 잔량보다 많습니다", QMessageBox.Ok)
input[4].setFocus()
return
elif self.value is not None and result[2]:
sql = "select ((sum(incnt) - sum(outcnt)) - ({} - {})) > 0 from product_table".\
format(str(self.value[2]), str(input[4].value()))
if __data__.select(sql)[0][0] == 0:
msg.warning(root, "수량", "다른 행에서 출고량이 잔량보다 많아집니다.", QMessageBox.Ok)
input[4].setFocus()
return
elif result[5] == "":
msg.warning(root, "불출자", "불출자를 입력하지 않았습니다", QMessageBox.Ok)
input[5].setFocus()
return
product_date = result[0].strftime('%Y-%m-%d')
# 추가모드
if mode:
# 입고
if result[2]:
sql = "insert into product_table(product_date, name, person, incnt, outcnt, note) values ('{}', " \
"'{}', '{}', '{}', 0, '{}')".format(product_date, result[1], result[5], result[4], result[6])
__data__.other(sql)
msg.information(root, "완료", "데이터를 입력했습니다.", QMessageBox.Ok)
root.close()
# 출고
elif result[3]:
sql = "insert into product_table(product_date, name, person, outcnt, incnt, note) values ('{}', " \
"'{}', '{}', '{}', 0, '{}')".format(product_date, result[1], result[5], result[4], result[6])
__data__.other(sql)
msg.information(root, "완료", "데이터를 입력했습니다.", QMessageBox.Ok)
root.close()
# 수정모드
else:
# 입고, 만약 출고에서 입고로 바뀌면 출고가 0이 됨
if result[2]:
sql = "update product_table set product_date = '{}', name = '{}', person = '{}', incnt = '{}'," \
" outcnt = '0', note = '{}' where id = '{}'" \
.format(product_date, result[1], result[5], result[4], result[6], self.value[-1])
__data__.other(sql)
msg.information(root, "완료", "데이터를 수정했습니다.", QMessageBox.Ok)
root.close()
# 출고, 만약 입고에서 출고로 바뀌면 입고가 0이 됨
elif result[3]:
sql = "update product_table set product_date = '{}', name = '{}', person = '{}', outcnt = '{}'," \
" incnt = '0', note = '{}' where id = '{}'"\
.format(product_date, result[1], result[5], result[4], result[6], self.value[-1])
__data__.other(sql)
__data__.other(sql)
msg.information(root, "완료", "데이터를 수정했습니다.", QMessageBox.Ok)
root.close()
def getcharge(self, incnt, outcnt, charge, number):
# 입고면 원값 + 입력 출고면 원값 - 입력
if incnt.isChecked():
charge.setText(str(int(self.origin) + number))
elif outcnt.isChecked():
charge.setText(str(int(self.origin) - number))
def setcharge(self, incnt, outcnt, text, charge, number, datevalue):
# 첫 잔량 설정
if self.value is None:
self.origin = checkvar(__data__.select("select sum(incnt) - sum(outcnt) from product_table where "
"product_date <= cast('{}' as date) and name = '{}'"
.format(datevalue, text))[0][0])
else:
self.origin = checkvar(__data__.select("select sum(incnt) - sum(outcnt) from product_table where "
"product_date <= cast('{}' as date) and name = '{}' and id < '{}'"
.format(datevalue, text, self.value[-1]))[0][0])
self.getcharge(incnt, outcnt, charge, number)