def __init__(self, parent=None):
QtGui.QDialog.__init__(self, parent)
self.ui = Ui_Storage()
self.ui.setupUi(self)
self.parent = parent
self.fillStorage()
self.ui.tableStorageWidget.setCurrentCell(0,0)
self.connect(self.ui.addIncomeButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_addIncomeButton()"))
self.connect(self.ui.delIncomeButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_delIncomeButton()"))
self.connect(self.ui.importFrom1CButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_importFrom1CButton()"))
class Storage_Class(QtGui.QDialog):
"""Склад"""
def __init__(self, parent=None):
QtGui.QDialog.__init__(self, parent)
self.ui = Ui_Storage()
self.ui.setupUi(self)
self.parent = parent
self.fillStorage()
self.ui.tableStorageWidget.setCurrentCell(0,0)
self.connect(self.ui.addIncomeButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_addIncomeButton()"))
self.connect(self.ui.delIncomeButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_delIncomeButton()"))
self.connect(self.ui.importFrom1CButton, QtCore.SIGNAL("clicked()"),QtCore.SLOT("on_click_importFrom1CButton()"))
def renew(self):
#self.ui.tableStorageWidget.clear()
for i in range(self.ui.tableStorageWidget.rowCount()):
self.ui.tableStorageWidget.removeRow(0)
self.fillStorage()
def on_click_addIncomeButton(self):
"""Открывает приход"""
form = Income_Class(self)
form.show()
def on_click_delIncomeButton(self):
"""Удаляет выделенную запись
СДЕЛАТЬ ПРОВЕРКУ НА ССЫЛКИ ИЗ БАЗЫ
"""
rownum = self.ui.tableStorageWidget.currentRow()
id_to_del = int(self.ui.tableStorageWidget.item(rownum,0).text())
if not self.check_refs(id_to_del):
db = localDb_Class()
#db.del_row_by_id('income',id_to_del)
db.close_db()
self.renew()
else:
print "blablabla"
def on_click_importFrom1CButton(self):
form = IncomeFrom1C_Class(self)
form.show()
def check_refs(self,id_to_del):
"""Проверяет есть ли в базе ссылки на этот"""
db = localDb_Class()
answer = db.select_val_by_col('calculate','income',"%s" % id_to_del)
db.close_db()
try:
return answer['rows'][0]
except:
return False
def fillStorage(self):
"""Заполняет склад из базы
TODO сделать по человечьи(вместо циферок значения из справочников поставить)"""
for row in self.select_incomes():
itemNumber = self.ui.tableStorageWidget.rowCount()
self.ui.tableStorageWidget.setRowCount(itemNumber +1)
for col in range(len(row)):
item = QtGui.QTableWidgetItem()
self.ui.tableStorageWidget.setItem(itemNumber, col, item)
self.ui.tableStorageWidget.item(itemNumber, col).setText("%s" % row[col])
def select_incomes(self):
"""Выбирает все необходимые значения из базы"""
db = localDb_Class()
query = "SELECT i.nomenculature, i.name, m.name, i.count, i.rest, i.price, p.for_sale, i.date FROM income as i, measure as m, product as p WHERE "
query += "i.active<>0 AND m.code = i.measure AND p.id = i.product"
incom = db.exec_query(query)['rows']
db.close_db()
return incom
