示例#1
0
 def prihodTabShow(self):
     self.ui.prihod_tab = PrihodTab(self)
     self.ui.tabWidget.addTab(self.ui.prihod_tab, _fromUtf8(""))
     self.ui.tabWidget.setTabText(
         self.ui.tabWidget.indexOf(self.ui.prihod_tab),
         QtGui.QApplication.translate("MainWindow", "Приходы", None,
                                      QtGui.QApplication.UnicodeUTF8))
     self.ui.tabWidget.setCurrentWidget(self.ui.prihod_tab)
     QtCore.QObject.connect(self.ui.prihod_tab.prihodWidget.closeButton,
                            QtCore.SIGNAL(_fromUtf8("clicked()")),
                            self.removeCurrentTab)
示例#2
0
    def whsStateTabShow(self):
        self.ui.whsState_tab = WhsStateTab(self)
        self.ui.tabWidget.addTab(self.ui.whsState_tab, _fromUtf8(""))
        self.ui.tabWidget.setTabText(
            self.ui.tabWidget.indexOf(self.ui.whsState_tab),
            QtGui.QApplication.translate("MainWindow", "Состояние склада",
                                         None, QtGui.QApplication.UnicodeUTF8))

        self.ui.tabWidget.setCurrentWidget(self.ui.whsState_tab)

        QtCore.QObject.connect(
            self.ui.whsState_tab.whsStateWidget.CloseWhsStateButton,
            QtCore.SIGNAL(_fromUtf8("clicked()")), self.removeCurrentTab)
示例#3
0
 def __init__(self, parent=None):
     QtGui.QWidget.__init__(self, parent)
     self.addUhodWidget = Ui_addPrihodForm()
     self.addUhodWidget.setupUi(self)
     QtCore.QObject.connect(self.addUhodWidget.goodsButton,
                            QtCore.SIGNAL(_fromUtf8("clicked()")),
                            self.showChooseGoodsWindow)
示例#4
0
 def __init__(self, parent=None):
     QtGui.QWidget.__init__(self, parent)
     self.uhodWidget = Ui_PrihodWidget()
     self.uhodWidget.setupUi(self)
     QtCore.QObject.connect(self.uhodWidget.addButton,
                            QtCore.SIGNAL(_fromUtf8("clicked()")),
                            self.showAddUhodWindow)
示例#5
0
    def whsStateTabShow(self):
        self.ui.whsState_tab = WhsStateTab(self)
        self.ui.tabWidget.addTab(self.ui.whsState_tab, _fromUtf8(""))
        self.ui.tabWidget.setTabText(self.ui.tabWidget.indexOf(self.ui.whsState_tab), QtGui.QApplication.translate("MainWindow", "Состояние склада", None, QtGui.QApplication.UnicodeUTF8))

        self.ui.tabWidget.setCurrentWidget(self.ui.whsState_tab)

        QtCore.QObject.connect(self.ui.whsState_tab.whsStateWidget.CloseWhsStateButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.removeCurrentTab)
示例#6
0
 def __init__(self, parent=None):
     QtGui.QWidget.__init__(self, parent)
     self.addUnitWidget = Ui_addGoods()
     self.addUnitWidget.setupUi(self)
     QtCore.QObject.connect(self.addUnitWidget.buttonBox,
                            QtCore.SIGNAL(_fromUtf8("accepted()")),
                            self.save_unit)
     self.addUnitWidget.NdsEdit.setText(str(NDS))
示例#7
0
    def __init__(self, parent=None):
        QtGui.QWidget.__init__(self, parent)
        self.ui = Ui_MainWindow()
        self.ui.setupUi(self)
        self.ui.tabWidget.hide()
        self.ui.tabWidget.setTabsClosable(True)
        self.setWindowIcon(QtGui.QIcon('images/shop-icon.png'))
        QtCore.QObject.connect(self.ui.action_open_goods,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.checked_goodsTabShow)
        QtCore.QObject.connect(self.ui.action_change_db,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.open_db)
        QtCore.QObject.connect(self.ui.action_create_db,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.new_db)
        QtCore.QObject.connect(self.ui.action_open_whsstate,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.whsStateTabShow)
        QtCore.QObject.connect(self.ui.action_12,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.prihodTabShow)
        QtCore.QObject.connect(self.ui.action_13,
                               QtCore.SIGNAL(_fromUtf8("activated()")),
                               self.uhodTabShow)
        self.ui.tabWidget.tabCloseRequested.connect(
            self.ui.tabWidget.removeTab)

        # Устанавливаем размер шрифта >>
        font = QtGui.QFont()
        font.setPointSize(11)
        self.ui.centralwidget.setFont(font)
        # << Устанавливаем размер шрифта

        self.ui.tabWidget.show()
示例#8
0
    def __init__(self, parent=None):
        QtGui.QWidget.__init__(self, parent)
        self.editUnitWidget = Ui_addGoods()
        self.editUnitWidget.setupUi(self)
        QtCore.QObject.connect(self.editUnitWidget.buttonBox,
                               QtCore.SIGNAL(_fromUtf8("accepted()")),
                               self.save_unit)
        #self.editUnitWidget.addGoods.setWindowTitle(QtGui.QApplication.translate("addGoods", "Изменение позиции", None, QtGui.QApplication.UnicodeUTF8))

        self.units = myapp.ui.tableWidget.selectedItems()
        self.row = myapp.ui.tableWidget.row(self.units[0])
        self.name = myapp.ui.tableWidget.item(
            myapp.ui.tableWidget.row(self.units[0]), 1).text()
        #print (self.name)

        conn = sqlite3.connect(str(db_filename))
        cur = conn.cursor()
        row = cur.execute('select * from goodscatalog where name=?',
                          (self.name, ))
        keyss = tuple([d[0] for d in cur.description])  # Получаем имена полей

        conn.commit()

        # Создаём словарь из строки базы >>
        for field in row:
            #print (field)
            row1 = field
        #print ('Ключи ', keyss)
        #print('ROW1 = ', row1)

        self.dictionary = dict(zip(keyss, row1))
        #print (self.dictionary)

        # << Создаём словарь из строки базы

        # Вывод данных и словаря в форму >>

        self.editUnitWidget.ArticleEdit.setText(str(
            self.dictionary['article']))
        self.editUnitWidget.NameEdit.setText(str(self.dictionary['name']))
        self.editUnitWidget.PriceEdit.setText(str(self.dictionary['price']))
        self.editUnitWidget.BrendEdit.setText(str(self.dictionary['brand']))
        self.editUnitWidget.CountryEdit.setText(str(
            self.dictionary['country']))
        self.editUnitWidget.NdsEdit.setText(str(self.dictionary['nds']))
示例#9
0
    def __init__(self, parent = None):
        QtGui.QWidget.__init__(self,parent)
        self.editUnitWidget = Ui_addGoods()
        self.editUnitWidget.setupUi(self)
        QtCore.QObject.connect(self.editUnitWidget.buttonBox, QtCore.SIGNAL(_fromUtf8("accepted()")), self.save_unit)
        #self.editUnitWidget.addGoods.setWindowTitle(QtGui.QApplication.translate("addGoods", "Изменение позиции", None, QtGui.QApplication.UnicodeUTF8))

        self.units = myapp.ui.tableWidget.selectedItems()
        self.row = myapp.ui.tableWidget.row(self.units[0])
        self.name = myapp.ui.tableWidget.item(myapp.ui.tableWidget.row(self.units[0]), 1).text()
        #print (self.name)

        conn=sqlite3.connect(str(db_filename))
        cur=conn.cursor()
        row = cur.execute('select * from goodscatalog where name=?', (self.name,))
        keyss = tuple([d[0] for d in cur.description]) # Получаем имена полей

        conn.commit()

        # Создаём словарь из строки базы >>
        for field in row:
            #print (field)
            row1 = field
        #print ('Ключи ', keyss)
        #print('ROW1 = ', row1)

        self.dictionary = dict(zip(keyss, row1))
        #print (self.dictionary)

        # << Создаём словарь из строки базы

        # Вывод данных и словаря в форму >>

        self.editUnitWidget.ArticleEdit.setText(str(self.dictionary['article']))
        self.editUnitWidget.NameEdit.setText(str(self.dictionary['name']))
        self.editUnitWidget.PriceEdit.setText(str(self.dictionary['price']))
        self.editUnitWidget.BrendEdit.setText(str(self.dictionary['brand']))
        self.editUnitWidget.CountryEdit.setText(str(self.dictionary['country']))
        self.editUnitWidget.NdsEdit.setText(str(self.dictionary['nds']))
示例#10
0
    def __init__(self, parent = None):
        QtGui.QWidget.__init__(self,parent)
        self.ui=Ui_MainWindow()
        self.ui.setupUi(self)
        self.ui.tabWidget.hide()
        self.ui.tabWidget.setTabsClosable(True)
        self.setWindowIcon(QtGui.QIcon('images/shop-icon.png'))
        QtCore.QObject.connect(self.ui.action_open_goods, QtCore.SIGNAL(_fromUtf8("activated()")), self.checked_goodsTabShow)
        QtCore.QObject.connect(self.ui.action_change_db, QtCore.SIGNAL(_fromUtf8("activated()")), self.open_db)
        QtCore.QObject.connect(self.ui.action_create_db, QtCore.SIGNAL(_fromUtf8("activated()")), self.new_db)
        QtCore.QObject.connect(self.ui.action_open_whsstate, QtCore.SIGNAL(_fromUtf8("activated()")), self.whsStateTabShow)
        QtCore.QObject.connect(self.ui.action_12, QtCore.SIGNAL(_fromUtf8("activated()")), self.prihodTabShow)
        QtCore.QObject.connect(self.ui.action_13, QtCore.SIGNAL(_fromUtf8("activated()")), self.uhodTabShow)
        self.ui.tabWidget.tabCloseRequested.connect(self.ui.tabWidget.removeTab)

        # Устанавливаем размер шрифта >>
        font = QtGui.QFont()
        font.setPointSize(11)
        self.ui.centralwidget.setFont(font)
        # << Устанавливаем размер шрифта

        self.ui.tabWidget.show()
示例#11
0
 def prihodTabShow(self):
     self.ui.prihod_tab = PrihodTab(self)
     self.ui.tabWidget.addTab(self.ui.prihod_tab, _fromUtf8(""))
     self.ui.tabWidget.setTabText(self.ui.tabWidget.indexOf(self.ui.prihod_tab), QtGui.QApplication.translate("MainWindow", "Приходы", None, QtGui.QApplication.UnicodeUTF8))
     self.ui.tabWidget.setCurrentWidget(self.ui.prihod_tab)
     QtCore.QObject.connect(self.ui.prihod_tab.prihodWidget.closeButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.removeCurrentTab)
示例#12
0
 def __init__(self, parent = None):
     QtGui.QWidget.__init__(self, parent)
     self.addUhodWidget = Ui_addPrihodForm()
     self.addUhodWidget.setupUi(self)
     QtCore.QObject.connect(self.addUhodWidget.goodsButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.showChooseGoodsWindow)
示例#13
0
 def __init__(self, parent = None):
     QtGui.QWidget.__init__(self,parent)
     self.addUnitWidget = Ui_addGoods()
     self.addUnitWidget.setupUi(self)
     QtCore.QObject.connect(self.addUnitWidget.buttonBox, QtCore.SIGNAL(_fromUtf8("accepted()")), self.save_unit)
     self.addUnitWidget.NdsEdit.setText(str(NDS))
示例#14
0
 def __init__(self, parent = None):
     QtGui.QWidget.__init__(self, parent)
     self.uhodWidget = Ui_PrihodWidget()
     self.uhodWidget.setupUi(self)
     QtCore.QObject.connect(self.uhodWidget.addButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.showAddUhodWindow)
示例#15
0
    def goodsTabShow(self):
        #goods_widget = QtGui.QWidget()
        #self.ui.tabWidget.addTab(goods_widget, _fromUtf8("Справочник товаров"))

        # Вкладка "Справочник товаров" >>
        self.ui.goods_tab = QtGui.QWidget()
        self.ui.goods_tab.setObjectName(_fromUtf8("goods_tab"))
        self.ui.tabWidget.addTab(self.ui.goods_tab, _fromUtf8(""))
        self.ui.goodsgridLayout = QtGui.QGridLayout(self.ui.goods_tab)
        self.ui.goodsgridLayout.setObjectName(_fromUtf8("goodsgridLayout"))
        # << Вкладка "Справочник товаров"
        # Кнопки >>
        self.ui.addGroupButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.addGroupButton.setObjectName(_fromUtf8("addGroupButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.addGroupButton, 7, 0, 1, 1)
        self.ui.deleteGroupButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.deleteGroupButton.setObjectName(_fromUtf8("deleteGroupButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.deleteGroupButton, 7, 1, 1, 1)
        self.ui.copyUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.copyUnitButton.setObjectName(_fromUtf8("copyUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.copyUnitButton, 1, 5, 1, 1)
        self.ui.CloseGoodsButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.CloseGoodsButton.setObjectName(_fromUtf8("CloseGoodsButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.CloseGoodsButton, 7, 5, 1, 1)
        self.ui.addUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.addUnitButton.setObjectName(_fromUtf8("addUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.addUnitButton, 0, 5, 1, 1)
        self.ui.editUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.editUnitButton.setObjectName(_fromUtf8("editUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.editUnitButton, 2, 5, 1, 1)
        self.ui.deleteUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.deleteUnitButton.setObjectName(_fromUtf8("deleteUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.deleteUnitButton, 3, 5, 1, 1)

        self.ui.filter_label = QtGui.QLabel(self.ui.goods_tab)
        self.ui.filter_label.setObjectName(_fromUtf8("filter_label"))
        self.ui.goodsgridLayout.addWidget(self.ui.filter_label, 7, 2, 1, 1)
        self.ui.filter_lineEdit = QtGui.QLineEdit(self.ui.goods_tab)
        self.ui.filter_lineEdit.setObjectName(_fromUtf8("filter_lineEdit"))
        self.ui.goodsgridLayout.addWidget(self.ui.filter_lineEdit, 7, 3, 1, 1)
        self.ui.ClearFilterButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.ClearFilterButton.setObjectName(_fromUtf8("ClearFilterButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.ClearFilterButton, 7, 4, 1, 1)

        # << Кнопки
        # Дерево групп >>
        self.ui.treeWidget = QtGui.QTreeWidget(self.ui.goods_tab)
        self.ui.treeWidget.setObjectName(_fromUtf8("treeView"))
        self.ui.goodsgridLayout.addWidget(self.ui.treeWidget, 0, 0, 7, 2)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_2 = QtGui.QTreeWidgetItem(item_1)
        item_2 = QtGui.QTreeWidgetItem(item_1)
        self.ui.treeWidget.headerItem().setText(0, QtGui.QApplication.translate("MainWindow", "Группы", None, QtGui.QApplication.UnicodeUTF8))
        __sortingEnabled = self.ui.treeWidget.isSortingEnabled()
        self.ui.treeWidget.setSortingEnabled(False)
        self.ui.treeWidget.topLevelItem(0).setText(0, QtGui.QApplication.translate("MainWindow", "Все группы", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).setText(0, QtGui.QApplication.translate("MainWindow", "Водонагреватели", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).child(0).setText(0, QtGui.QApplication.translate("MainWindow", "Проточные водонагреватели", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).child(1).setText(0, QtGui.QApplication.translate("MainWindow", "Накопительные водонагреватели", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).setText(0, QtGui.QApplication.translate("MainWindow", "Теплотехника", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).child(0).setText(0, QtGui.QApplication.translate("MainWindow", "Электрические конвекторы", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).child(1).setText(0, QtGui.QApplication.translate("MainWindow", "Маслонаполненные обогреватели", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).setText(0, QtGui.QApplication.translate("MainWindow", "Водоснабжение", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).setText(0, QtGui.QApplication.translate("MainWindow", "Погружные насосы", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).child(0).setText(0, QtGui.QApplication.translate("MainWindow", "Центробежные погружные насосы", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).child(1).setText(0, QtGui.QApplication.translate("MainWindow", "Вибрационные погружные насосы", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.setSortingEnabled(__sortingEnabled)
        self.ui.treeWidget.setCurrentItem(self.ui.treeWidget.topLevelItem(0))# Устанавливаем активный элемент
        # << Дерево групп
        # Таблица товаров >>
        self.ui.tableWidget = QtGui.QTableWidget(self.ui.goods_tab)
        self.ui.tableWidget.setObjectName(_fromUtf8("tableView"))
        self.ui.tableWidget.setColumnCount(5)
        self.ui.tableWidget.setRowCount(0)
        self.ui.tableWidget.setEditTriggers(QtGui.QAbstractItemView.NoEditTriggers) # Отключаем редактирование
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(0, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(1, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(2, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(3, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(4, item)
        self.ui.goodsgridLayout.addWidget(self.ui.tableWidget, 0, 2, 7, 3)

        item = self.ui.tableWidget.horizontalHeaderItem(0)
        item.setText(QtGui.QApplication.translate("MainWindow", "Артикул", None, QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(1)
        item.setText(QtGui.QApplication.translate("MainWindow", "Название", None, QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(2)
        item.setText(QtGui.QApplication.translate("MainWindow", "Цена", None, QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(3)
        item.setText(QtGui.QApplication.translate("MainWindow", "Бренд", None, QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(4)
        item.setText(QtGui.QApplication.translate("MainWindow", "Страна производства", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.tableWidget.setSortingEnabled(True)


        # << Таблица товаров

        #self.ui.tabWidget.addTab(self.ui.goods_tab, _fromUtf8(""))

        self.ui.tabWidget.setCurrentIndex(0)
        self.ui.tableWidget.horizontalHeader().setStretchLastSection(True) # Растягиваем по-ширине
        self.ui.tableWidget.horizontalHeader().setSortIndicatorShown(True)
        self.ui.tableWidget.setSelectionBehavior(QtGui.QAbstractItemView.SelectRows) # Выбор построчно

        #self.ui.tabWidget.tabCloseRequested.connect(self.ui.tabWidget.removeTab)
        QtCore.QObject.connect(self.ui.CloseGoodsButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.removeCurrentTab)
        QtCore.QObject.connect(self.ui.addUnitButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.showaddUnitWindow)
        QtCore.QObject.connect(self.ui.ClearFilterButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.ui.filter_lineEdit.clear)
        QtCore.QObject.connect(self.ui.deleteUnitButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.deleteUnitDialog)
        QtCore.QObject.connect(self.ui.copyUnitButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.copyUnit)
        QtCore.QObject.connect(self.ui.editUnitButton, QtCore.SIGNAL(_fromUtf8("clicked()")), self.editUnit)



        self.ui.addGroupButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Добавить группу", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.addGroupButton.setText(QtGui.QApplication.translate("MainWindow", "Добавить", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteGroupButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Удалить группу", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteGroupButton.setText(QtGui.QApplication.translate("MainWindow", "Удалить", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.copyUnitButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Копировать позицию", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.copyUnitButton.setText(QtGui.QApplication.translate("MainWindow", "Копировать", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.CloseGoodsButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Закрыть вкладку", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.CloseGoodsButton.setText(QtGui.QApplication.translate("MainWindow", "Закрыть", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.addUnitButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Добавить позицию", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.addUnitButton.setText(QtGui.QApplication.translate("MainWindow", "Добавить", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.editUnitButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Изменить позицию", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.editUnitButton.setText(QtGui.QApplication.translate("MainWindow", "Изменить", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteUnitButton.setToolTip(QtGui.QApplication.translate("MainWindow", "Удалить позицию", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteUnitButton.setText(QtGui.QApplication.translate("MainWindow", "Удалить", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.tabWidget.setTabText(self.ui.tabWidget.indexOf(self.ui.goods_tab), QtGui.QApplication.translate("MainWindow", "Справочник товаров", None, QtGui.QApplication.UnicodeUTF8))
        #self.ui.tabWidget.setTabText(self.ui.tabWidget.indexOf(self.ui.tab_2), QtGui.QApplication.translate("MainWindow", "Tab 2", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.filter_label.setText(QtGui.QApplication.translate("MainWindow", "Фильтр", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.ClearFilterButton.setText(QtGui.QApplication.translate("MainWindow", "Очистить", None, QtGui.QApplication.UnicodeUTF8))

        self.ui.tabWidget.setCurrentWidget(self.ui.goods_tab)


        # Загрузка данных из базы в таблицу>>

        __sortingEnabled = self.ui.tableWidget.isSortingEnabled()
        self.ui.tableWidget.setSortingEnabled(False)
        if db_filename:
            self.load_data('goodscatalog')
        else:
            err = QtGui.QMessageBox(self)
            err.setText('База данных не выбрана !')
            err.setIcon(2)
            err.show()
            self.ui.tabWidget.clear()

        self.ui.tableWidget.setSortingEnabled(__sortingEnabled)
示例#16
0
    def goodsTabShow(self):
        #goods_widget = QtGui.QWidget()
        #self.ui.tabWidget.addTab(goods_widget, _fromUtf8("Справочник товаров"))

        # Вкладка "Справочник товаров" >>
        self.ui.goods_tab = QtGui.QWidget()
        self.ui.goods_tab.setObjectName(_fromUtf8("goods_tab"))
        self.ui.tabWidget.addTab(self.ui.goods_tab, _fromUtf8(""))
        self.ui.goodsgridLayout = QtGui.QGridLayout(self.ui.goods_tab)
        self.ui.goodsgridLayout.setObjectName(_fromUtf8("goodsgridLayout"))
        # << Вкладка "Справочник товаров"
        # Кнопки >>
        self.ui.addGroupButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.addGroupButton.setObjectName(_fromUtf8("addGroupButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.addGroupButton, 7, 0, 1, 1)
        self.ui.deleteGroupButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.deleteGroupButton.setObjectName(_fromUtf8("deleteGroupButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.deleteGroupButton, 7, 1, 1,
                                          1)
        self.ui.copyUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.copyUnitButton.setObjectName(_fromUtf8("copyUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.copyUnitButton, 1, 5, 1, 1)
        self.ui.CloseGoodsButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.CloseGoodsButton.setObjectName(_fromUtf8("CloseGoodsButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.CloseGoodsButton, 7, 5, 1, 1)
        self.ui.addUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.addUnitButton.setObjectName(_fromUtf8("addUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.addUnitButton, 0, 5, 1, 1)
        self.ui.editUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.editUnitButton.setObjectName(_fromUtf8("editUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.editUnitButton, 2, 5, 1, 1)
        self.ui.deleteUnitButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.deleteUnitButton.setObjectName(_fromUtf8("deleteUnitButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.deleteUnitButton, 3, 5, 1, 1)

        self.ui.filter_label = QtGui.QLabel(self.ui.goods_tab)
        self.ui.filter_label.setObjectName(_fromUtf8("filter_label"))
        self.ui.goodsgridLayout.addWidget(self.ui.filter_label, 7, 2, 1, 1)
        self.ui.filter_lineEdit = QtGui.QLineEdit(self.ui.goods_tab)
        self.ui.filter_lineEdit.setObjectName(_fromUtf8("filter_lineEdit"))
        self.ui.goodsgridLayout.addWidget(self.ui.filter_lineEdit, 7, 3, 1, 1)
        self.ui.ClearFilterButton = QtGui.QPushButton(self.ui.goods_tab)
        self.ui.ClearFilterButton.setObjectName(_fromUtf8("ClearFilterButton"))
        self.ui.goodsgridLayout.addWidget(self.ui.ClearFilterButton, 7, 4, 1,
                                          1)

        # << Кнопки
        # Дерево групп >>
        self.ui.treeWidget = QtGui.QTreeWidget(self.ui.goods_tab)
        self.ui.treeWidget.setObjectName(_fromUtf8("treeView"))
        self.ui.goodsgridLayout.addWidget(self.ui.treeWidget, 0, 0, 7, 2)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_0 = QtGui.QTreeWidgetItem(self.ui.treeWidget)
        item_1 = QtGui.QTreeWidgetItem(item_0)
        item_2 = QtGui.QTreeWidgetItem(item_1)
        item_2 = QtGui.QTreeWidgetItem(item_1)
        self.ui.treeWidget.headerItem().setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Группы", None,
                                         QtGui.QApplication.UnicodeUTF8))
        __sortingEnabled = self.ui.treeWidget.isSortingEnabled()
        self.ui.treeWidget.setSortingEnabled(False)
        self.ui.treeWidget.topLevelItem(0).setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Все группы", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Водонагреватели", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).child(0).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Проточные водонагреватели", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(1).child(1).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Накопительные водонагреватели", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Теплотехника", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).child(0).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Электрические конвекторы", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(2).child(1).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Маслонаполненные обогреватели", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Водоснабжение", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).setText(
            0,
            QtGui.QApplication.translate("MainWindow", "Погружные насосы",
                                         None, QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).child(0).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Центробежные погружные насосы", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.topLevelItem(3).child(0).child(1).setText(
            0,
            QtGui.QApplication.translate("MainWindow",
                                         "Вибрационные погружные насосы", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.treeWidget.setSortingEnabled(__sortingEnabled)
        self.ui.treeWidget.setCurrentItem(self.ui.treeWidget.topLevelItem(
            0))  # Устанавливаем активный элемент
        # << Дерево групп
        # Таблица товаров >>
        self.ui.tableWidget = QtGui.QTableWidget(self.ui.goods_tab)
        self.ui.tableWidget.setObjectName(_fromUtf8("tableView"))
        self.ui.tableWidget.setColumnCount(5)
        self.ui.tableWidget.setRowCount(0)
        self.ui.tableWidget.setEditTriggers(
            QtGui.QAbstractItemView.NoEditTriggers)  # Отключаем редактирование
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(0, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(1, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(2, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(3, item)
        item = QtGui.QTableWidgetItem()
        self.ui.tableWidget.setHorizontalHeaderItem(4, item)
        self.ui.goodsgridLayout.addWidget(self.ui.tableWidget, 0, 2, 7, 3)

        item = self.ui.tableWidget.horizontalHeaderItem(0)
        item.setText(
            QtGui.QApplication.translate("MainWindow", "Артикул", None,
                                         QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(1)
        item.setText(
            QtGui.QApplication.translate("MainWindow", "Название", None,
                                         QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(2)
        item.setText(
            QtGui.QApplication.translate("MainWindow", "Цена", None,
                                         QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(3)
        item.setText(
            QtGui.QApplication.translate("MainWindow", "Бренд", None,
                                         QtGui.QApplication.UnicodeUTF8))
        item = self.ui.tableWidget.horizontalHeaderItem(4)
        item.setText(
            QtGui.QApplication.translate("MainWindow", "Страна производства",
                                         None, QtGui.QApplication.UnicodeUTF8))
        self.ui.tableWidget.setSortingEnabled(True)

        # << Таблица товаров

        #self.ui.tabWidget.addTab(self.ui.goods_tab, _fromUtf8(""))

        self.ui.tabWidget.setCurrentIndex(0)
        self.ui.tableWidget.horizontalHeader().setStretchLastSection(
            True)  # Растягиваем по-ширине
        self.ui.tableWidget.horizontalHeader().setSortIndicatorShown(True)
        self.ui.tableWidget.setSelectionBehavior(
            QtGui.QAbstractItemView.SelectRows)  # Выбор построчно

        #self.ui.tabWidget.tabCloseRequested.connect(self.ui.tabWidget.removeTab)
        QtCore.QObject.connect(self.ui.CloseGoodsButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.removeCurrentTab)
        QtCore.QObject.connect(self.ui.addUnitButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.showaddUnitWindow)
        QtCore.QObject.connect(self.ui.ClearFilterButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.ui.filter_lineEdit.clear)
        QtCore.QObject.connect(self.ui.deleteUnitButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.deleteUnitDialog)
        QtCore.QObject.connect(self.ui.copyUnitButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.copyUnit)
        QtCore.QObject.connect(self.ui.editUnitButton,
                               QtCore.SIGNAL(_fromUtf8("clicked()")),
                               self.editUnit)

        self.ui.addGroupButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Добавить группу", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.addGroupButton.setText(
            QtGui.QApplication.translate("MainWindow", "Добавить", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteGroupButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Удалить группу", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteGroupButton.setText(
            QtGui.QApplication.translate("MainWindow", "Удалить", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.copyUnitButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Копировать позицию",
                                         None, QtGui.QApplication.UnicodeUTF8))
        self.ui.copyUnitButton.setText(
            QtGui.QApplication.translate("MainWindow", "Копировать", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.CloseGoodsButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Закрыть вкладку", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.CloseGoodsButton.setText(
            QtGui.QApplication.translate("MainWindow", "Закрыть", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.addUnitButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Добавить позицию",
                                         None, QtGui.QApplication.UnicodeUTF8))
        self.ui.addUnitButton.setText(
            QtGui.QApplication.translate("MainWindow", "Добавить", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.editUnitButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Изменить позицию",
                                         None, QtGui.QApplication.UnicodeUTF8))
        self.ui.editUnitButton.setText(
            QtGui.QApplication.translate("MainWindow", "Изменить", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteUnitButton.setToolTip(
            QtGui.QApplication.translate("MainWindow", "Удалить позицию", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.deleteUnitButton.setText(
            QtGui.QApplication.translate("MainWindow", "Удалить", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.tabWidget.setTabText(
            self.ui.tabWidget.indexOf(self.ui.goods_tab),
            QtGui.QApplication.translate("MainWindow", "Справочник товаров",
                                         None, QtGui.QApplication.UnicodeUTF8))
        #self.ui.tabWidget.setTabText(self.ui.tabWidget.indexOf(self.ui.tab_2), QtGui.QApplication.translate("MainWindow", "Tab 2", None, QtGui.QApplication.UnicodeUTF8))
        self.ui.filter_label.setText(
            QtGui.QApplication.translate("MainWindow", "Фильтр", None,
                                         QtGui.QApplication.UnicodeUTF8))
        self.ui.ClearFilterButton.setText(
            QtGui.QApplication.translate("MainWindow", "Очистить", None,
                                         QtGui.QApplication.UnicodeUTF8))

        self.ui.tabWidget.setCurrentWidget(self.ui.goods_tab)

        # Загрузка данных из базы в таблицу>>

        __sortingEnabled = self.ui.tableWidget.isSortingEnabled()
        self.ui.tableWidget.setSortingEnabled(False)
        if db_filename:
            self.load_data('goodscatalog')
        else:
            err = QtGui.QMessageBox(self)
            err.setText('База данных не выбрана !')
            err.setIcon(2)
            err.show()
            self.ui.tabWidget.clear()

        self.ui.tableWidget.setSortingEnabled(__sortingEnabled)