def getParts4Combo(self, combo: QComboBox):
combo.clear()
combo.clearEditText()
sql = "SELECT num_part FROM part;"
out = self.db.get(sql)
for supplier in out:
combo.addItem(supplier[0])
combo.setEnabled(True)
def add_supplier_list_to_combo(self, combo: QComboBox):
# clear QComboBox
combo.clear()
combo.clearEditText()
# DB Query and update QConboBox
sql = "SELECT name_supplier_short FROM supplier;"
out = self.db.get(sql)
for supplier in out:
combo.addItem(supplier[0])
def on_click_set_part(self, ent_part: QLineEdit, combo_1: QComboBox,
check: QCheckBox, ent_desc: QLineEdit,
combo_2: QComboBox):
# obtain part number
num_part = ent_part.text()
ent_part.setText(None)
# obtain original part number if selected
id_part_orig = 'NULL'
if combo_1.isEnabled():
num_part_org = combo_1.currentText()
sql1 = self.db.sql(
"SELECT id_part FROM part WHERE num_part = '?';",
[num_part_org])
print(sql1)
out = self.db.get(sql1)
for id in out:
id_part_orig = id[0]
combo_1.clear()
combo_1.clearEditText()
combo_1.setEnabled(False)
# clear QCheckBox
if check.isChecked():
check.setEnabled(False)
# obtain part description
description = ent_desc.text()
ent_desc.setText(None)
# obtain id_supplier from selected supplier on the QComboBox
supplier = combo_2.currentText()
sql2 = self.db.sql(
"SELECT id_supplier FROM supplier WHERE name_supplier_short = '?';",
[supplier])
print(sql2)
out = self.db.get(sql2)
for id in out:
id_supplier = id[0]
print(num_part)
print(description)
print(supplier)
print(id_supplier)
# insert new part to part table
sql3 = self.db.sql(
"INSERT INTO part VALUES(NULL, ?, ?, '?', '?', NULL, NULL);",
[id_part_orig, id_supplier, num_part, description])
print(sql3)
self.db.put(sql3)
def getPartsOptionCombo(self, label: QLabel, combo: QComboBox,
check: QCheckBox):
combo.clear()
combo.clearEditText()
if check.checkState() == Qt.Checked:
sql = "SELECT num_part FROM part;"
out = self.db.get(sql)
for supplier in out:
combo.addItem(supplier[0])
label.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;color: black;}")
combo.setEnabled(True)
else:
label.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;color: gray;}")
combo.setEnabled(False)
