def fillAllProductsTable(self):
products = executeQuery(
self.db, """SELECT `Наименование`, `Стоимость`, `Единица измерения`
FROM `Товар`;""")
for product in products:
self._addSingleProduct_dict(self.AllProductToAddTableWidget,
product)
def fillAllMatTable(self):
self.MaterialsTableWidget.setRowCount(0)
mats = executeQuery(
self.db, """SELECT `Наименование`, `Стоимость`, `Единица измерения`
FROM `Сырье`;""")
for mat in mats:
self._addSingleMat_dict(self.MaterialsTableWidget, mat)
def fillAllMatTable(self):
self.DocumentTableWidget.setRowCount(0)
docs = executeQuery(
self.db, """SELECT `Наименование`, `Тип документа`
FROM `Нормативный документ`;""")
for doc in docs:
self._addSingleDoc_dict(self.DocumentTableWidget, doc)
def fillTable(self):
self.DeliveryAgentOrClientResultTableWidget.setRowCount(0)
fill_vals = executeQuery(
self.db,
"""SELECT `Наименование`, `Адрес`, `Банковский реквизит`, `Налоговый реквизит`
FROM `{0}`;""".format(
self.fill_type))
for fill in fill_vals:
self._addSingle_dict(self.DeliveryAgentOrClientResultTableWidget,
fill)
def fillComboBox(self):
deps = executeQuery(self.db, """select `Наименование` from `Отдел`;""")
for dept in deps:
dept_name = dept['Наименование']
self.comboBox.addItem(dept_name)