def dele(self):
pysql.sqlConnect(self)
sql = "delete from ingredient where ingredient_name=%s;"
self.txt
self.cursor.execute(sql, self.txt)
self.conn.commit()
self.conn.close()
def setupUI(self):
pysql.sqlConnect(self)
self.setGeometry(300, 300, 400, 200)
self.setWindowTitle("재료 삭제")
self.pushButton1 = QPushButton("재료삭제")
sql1 = "select ingredient_name from ingredient;"
self.cursor.execute(sql1)
res = self.cursor.fetchall()
rec = [""] + [x[0] for x in res]
label1 = QLabel("재료이름")
self.qcombo1 = QComboBox(self)
self.qcombo1.addItems(rec)
self.pushButton1.clicked.connect(self.ing_del_ok)
self.qcombo1.currentTextChanged.connect(self.selec)
self.pushButton2 = QPushButton("취소")
self.pushButton2.clicked.connect(self.ing_del_cancel)
layout = QGridLayout()
layout.addWidget(label1, 0, 0)
layout.addWidget(self.qcombo1, 0, 1)
layout.addWidget(self.pushButton1, 0, 2)
layout.addWidget(self.pushButton2, 1, 2)
self.setLayout(layout)
def ing_ins_ok(self):
pysql.sqlConnect(self)
if (self.lineEdit1.text() != "") and (self.lineEdit2 != ""):
try:
ing_ins_sql = "insert into ingredient(ingredient_name,ingredient_stock) values (%s,%s);"
txt_ins_ing_name = self.lineEdit1.text()
try:
txt_ins_ing_stock = int(self.lineEdit2.text())
# input으로 받아온 값이 INT형이 아닐 때 나타내는 에러
except:
QMessageBox.information(self, "삽입 오류", "숫자를 입력하세요.",
QMessageBox.Yes, QMessageBox.Yes)
data = (txt_ins_ing_name, txt_ins_ing_stock)
self.cursor.execute(ing_ins_sql, data)
self.conn.commit()
QMessageBox.information(self, "입력완료", "재료가 추가되었습니다.",
QMessageBox.Ok, QMessageBox.Ok)
self.close()
except:
QMessageBox.information(self, "삽입 오류", "올바른 형식으로 입력하세요.",
QMessageBox.Yes, QMessageBox.Yes)
return
else:
QMessageBox.information(self, "입력 오류", "빈칸 없이 입력하세요.",
QMessageBox.Yes, QMessageBox.Yes)
def setupUI(self):
pysql.sqlConnect(self)
sql1 = "select menu_name from menu;"
self.cursor.execute(sql1)
res = self.cursor.fetchall()
rec = [""] + [x[0] for x in res]
self.setGeometry(300, 300, 400, 200)
self.setWindowTitle("메뉴수정")
label1 = QLabel("메뉴이름")
label2 = QLabel("메뉴수정")
self.lineEdit1 = QLineEdit()
self.qc = QComboBox(self)
self.qc.addItems(rec)
self.qc.currentTextChanged.connect(self.selec)
self.pushButton1 = QPushButton("메뉴수정")
self.pushButton1.clicked.connect(self.ing_mod_ok)
self.pushButton2 = QPushButton("취소")
self.pushButton2.clicked.connect(self.ing_mod_cancel)
layout = QGridLayout()
layout.addWidget(label1, 0, 0)
layout.addWidget(self.lineEdit1, 1, 1)
layout.addWidget(self.pushButton1, 0, 2)
layout.addWidget(label2, 1, 0)
layout.addWidget(self.qc, 0, 1)
layout.addWidget(self.pushButton2, 1, 2)
self.setLayout(layout)
def del_ing(self):
pysql.sqlConnect(self)
ing_del_sql = "delete from ingredient where ingredient_name=%s"
txt_del_ing_name = self.txt_ing_del_name.text()
self.cursor.execute(ing_del_sql, txt_del_ing_name)
self.conn.commit()
self.conn.close()
def mod_ing(self):
pysql.sqlConnect(self)
ing_mod_sql = "update ingredient set ingredient_stock=ingredient_stock+10 where ingredient_name=%s;"
b = self.txt_ing_mod_name.text()
self.cursor.execute(b, ing_mod_sql)
self.conn.commit()
self.conn.close()
def setupUI(self):
pysql.sqlConnect(self)
sql1 = "select ingredient_name from ingredient;"
self.cursor.execute(sql1)
res = self.cursor.fetchall()
rec = [""] + [x[0] for x in res]
self.setGeometry(300, 300, 400, 200)
self.setWindowTitle("재료추가")
label1 = QLabel("메뉴이름")
label2 = QLabel("메뉴가격")
label3 = QLabel("메뉴레시피1")
label4 = QLabel("메뉴레시피2")
label5 = QLabel("메뉴레시피3")
self.lineEdit1 = QLineEdit()
self.lineEdit2 = QLineEdit()
self.qc1 = QComboBox(self)
self.qc1.addItems(rec)
self.qc1.currentIndexChanged.connect(self.selec)
self.qc2 = QComboBox(self)
self.qc2.addItems(rec)
self.qc2.currentIndexChanged.connect(self.selec)
self.qc3 = QComboBox(self)
self.qc3.addItems(rec)
self.qc3.currentIndexChanged.connect(self.selec)
self.pushButton1 = QPushButton("메뉴추가")
self.pushButton1.clicked.connect(self.mn_ins_ok)
self.pushButton2 = QPushButton("취소")
self.pushButton2.clicked.connect(self.mn_ins_cancel)
layout = QGridLayout()
layout.addWidget(label1, 0, 0)
layout.addWidget(self.lineEdit1, 0, 1)
layout.addWidget(label2, 1, 0)
layout.addWidget(self.lineEdit2, 1, 1)
layout.addWidget(label3, 2, 0)
layout.addWidget(self.qc1, 2, 1)
layout.addWidget(label4, 3, 0)
layout.addWidget(self.qc2, 3, 1)
layout.addWidget(label5, 4, 0)
layout.addWidget(self.qc3, 4, 1)
layout.addWidget(self.pushButton1, 0, 2)
layout.addWidget(self.pushButton2, 1, 2)
self.setLayout(layout)
def ing_del_ok(self):
pysql.sqlConnect(self)
ing_del_sql = "delete from ingredient where ingredient_name=%s;"
self.a
self.cursor.execute(ing_del_sql, self.a)
self.conn.commit()
self.conn.close()
QMessageBox.information(self, "입력완료", "재료삭제가 완료되었습니다.", QMessageBox.Ok,
QMessageBox.Ok)
self.close()
def ing_mod_ok(self):
pysql.sqlConnect(self)
ing_mod_sql = "update ingredient set ingredient_stock=ingredient_stock+%s where ingredient_name=%s;"
a = int(self.lineEdit1.text())
b = self.b
data = (a, b)
self.cursor.execute(ing_mod_sql, data)
self.conn.commit()
self.conn.close()
QMessageBox.information(self, "입력완료", "재료발주가 완료되었습니다.", QMessageBox.Ok,
QMessageBox.Ok)
self.close()
def setupUI(self):
pysql.sqlConnect(self)
self.setGeometry(300, 300, 400, 200)
self.setWindowTitle("Sign In")
self.push1 = QPushButton("삭제")
sql1 = "select ingredient_name from ingredient;"
self.cursor.execute(sql1)
res = self.cursor.fetchall()
rec = [x[0] for x in res]
print(rec)
self.qcombo1 = QComboBox(self)
self.qcombo1.addItems(rec)
layout = QGridLayout()
layout.addWidget(self.qcombo1, 0, 0)
layout.addWidget(self.push1, 1, 0)
self.push1.clicked.connect(self.dele)
self.qcombo1.currentIndexChanged.connect(self.selec)
self.setLayout(layout)
def ing_mod_ok(self):
pysql.sqlConnect(self)
ing_mod_sql = "update ingredient set ingredient_stock=ingredient_stock+%s where ingredient_name=%s;"
try:
a = int(self.lineEdit1.text())
# input으로 받아온 값이 INT형이 아닐 때 나타내는 에러
except:
QMessageBox.information(self, "삽입 오류", "숫자를 입력하세요.",
QMessageBox.Yes, QMessageBox.Yes)
return
b = self.b
data = (a, b)
self.cursor.execute(ing_mod_sql, data)
self.conn.commit()
self.conn.close()
QMessageBox.information(self, "입력완료", "재료발주가 완료되었습니다.", QMessageBox.Ok,
QMessageBox.Ok)
self.close()
def mn_ins_ok(self):
pysql.sqlConnect(self)
mn_ins_sql = "insert into menu values (%s,%s,%s,NULL,%s,NULL,%s,NULL);"
txt_menu_name = self.lineEdit1.text()
try:
txt_menu_price = int(self.lineEdit2.text())
# input으로 받아온 값이 INT형이 아닐 때 나타내는 에러
except:
QMessageBox.information(self, "삽입 오류", "메뉴가격을 입력하세요.(숫자만)",
QMessageBox.Yes, QMessageBox.Yes)
return
a = self.a
b = self.b
if b == "":
b = None
c = self.c
if c == "":
c = None
data = (txt_menu_name, txt_menu_price, a, b, c)
self.cursor.execute(mn_ins_sql, data)
list_test = [
"update menu,ingredient set menu.stock1 = ingredient.ingredient_stock where menu.menu_recipe1=ingredient.ingredient_name",
"update menu,ingredient set menu.stock2 = ingredient.ingredient_stock where menu.menu_recipe2=ingredient.ingredient_name",
"update menu,ingredient set menu.stock3 = ingredient.ingredient_stock where menu.menu_recipe3=ingredient.ingredient_name"
]
# 쿼리문에서 실행된 내용을 변수에 삽입
for i in list_test:
# 쿼리문 실행
self.cursor.execute(i)
self.conn.commit()
self.conn.close()
QMessageBox.information(self, "입력완료", "메뉴추가가 완료되었습니다.", QMessageBox.Ok,
QMessageBox.Ok)
self.close()