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)