from PyQt5 import QtCore, QtGui, QtWidgets
import sys
from PyQt5.QtSql import QSqlDatabase, QSqlQuery, QSqlTableModel, QSqlQueryModel
from PyQt5.QtCore import *
from PyQt5.QtWidgets import *
import re
class Ui_Wind(QWidget):
def setupUi(self, Wind):
Wind.setObjectName("Wind")
Wind.resize(948, 803)
font = QtGui.QFont()
font.setFamily("Agency FB")
font.setPointSize(16)
Wind.setFont(font)
Wind.setAcceptDrops(False)
Wind.setStyleSheet("background-color:rgb(255, 217, 179)")
self.buttonBox = QtWidgets.QDialogButtonBox(Wind)
self.buttonBox.setGeometry(QtCore.QRect(600, 770, 341, 32))
self.buttonBox.setStyleSheet("background-color: rgb(157, 157, 157)")
self.buttonBox.setOrientation(QtCore.Qt.Horizontal)
self.buttonBox.setStandardButtons(QtWidgets.QDialogButtonBox.Cancel|QtWidgets.QDialogButtonBox.Ok)
self.buttonBox.setObjectName("buttonBox")
self.listView = QtWidgets.QListView(Wind)
self.listView.setGeometry(QtCore.QRect(-10, 80, 981, 91))
self.listView.setStyleSheet("background-color: rgb(243, 194, 147)")
self.listView.setObjectName("listView")
self.pushButton = QtWidgets.QPushButton(Wind)
self.pushButton.setGeometry(QtCore.QRect(0, 0, 231, 71))
font = QtGui.QFont()
font.setFamily("Script MT Bold")
font.setPointSize(14)
font.setBold(True)
font.setWeight(75)
self.pushButton.setFont(font)
self.pushButton.setCursor(QtGui.QCursor(QtCore.Qt.PointingHandCursor))
self.pushButton.setWhatsThis("")
self.pushButton.setAccessibleName("")
self.pushButton.setStyleSheet("background-color:\n""")
self.pushButton.setText("")
icon = QtGui.QIcon()
icon.addPixmap(QtGui.QPixmap("2.png"), QtGui.QIcon.Disabled, QtGui.QIcon.On)
self.pushButton.setIcon(icon)
self.pushButton.setIconSize(QtCore.QSize(230, 200))
self.pushButton.clicked.connect(self.initializedModel)
self.pushButton_2 = QtWidgets.QPushButton(Wind)
self.pushButton_2.setGeometry(QtCore.QRect(240, 0, 231, 71))
font = QtGui.QFont()
font.setFamily("Script MT Bold")
font.setPointSize(14)
font.setBold(True)
font.setWeight(75)
self.pushButton_2.setFont(font)
self.pushButton_2.setCursor(QtGui.QCursor(QtCore.Qt.PointingHandCursor))
self.pushButton_2.setWhatsThis("")
self.pushButton_2.setAccessibleName("")
self.pushButton_2.setStyleSheet("background-color:\n""")
self.pushButton_2.setText("")
icon1 = QtGui.QIcon()
icon1.addPixmap(QtGui.QPixmap("мясо2.png"), QtGui.QIcon.Disabled, QtGui.QIcon.On)
self.pushButton_2.setIcon(icon1)
self.pushButton_2.setIconSize(QtCore.QSize(230, 200))
self.pushButton_2.setObjectName("pushButton_2")
self.pushButton_2.clicked.connect(self.initializedModel1)
self.pushButton_3 = QtWidgets.QPushButton(Wind)
self.pushButton_3.setGeometry(QtCore.QRect(480, 0, 231, 71))
font = QtGui.QFont()
font.setFamily("Script MT Bold")
font.setPointSize(14)
font.setBold(True)
font.setWeight(75)
self.pushButton_3.setFont(font)
self.pushButton_3.setCursor(QtGui.QCursor(QtCore.Qt.PointingHandCursor))
self.pushButton_3.setWhatsThis("")
self.pushButton_3.setAccessibleName("")
self.pushButton_3.setStyleSheet("background-color:\n""")
self.pushButton_3.setText("")
icon2 = QtGui.QIcon()
icon2.addPixmap(QtGui.QPixmap("xlewb.png"), QtGui.QIcon.Disabled, QtGui.QIcon.On)
self.pushButton_3.setIcon(icon2)
self.pushButton_3.setIconSize(QtCore.QSize(230, 200))
self.pushButton_3.setObjectName("pushButton_3")
self.pushButton_3.clicked.connect(self.initializedModel2)
self.pushButton_4 = QtWidgets.QPushButton(Wind)
self.pushButton_4.setGeometry(QtCore.QRect(720, 0, 231, 71))
font = QtGui.QFont()
font.setFamily("Script MT Bold")
font.setPointSize(14)
font.setBold(True)
font.setWeight(75)
self.pushButton_4.setFont(font)
self.pushButton_4.setCursor(QtGui.QCursor(QtCore.Qt.PointingHandCursor))
self.pushButton_4.setWhatsThis("")
self.pushButton_4.setAccessibleName("")
self.pushButton_4.setStyleSheet("background-color:\n""")
self.pushButton_4.setText("")
icon3 = QtGui.QIcon()
icon3.addPixmap(QtGui.QPixmap("таврары.png"), QtGui.QIcon.Disabled, QtGui.QIcon.On)
self.pushButton_4.setIcon(icon3)
self.pushButton_4.setIconSize(QtCore.QSize(230, 200))
self.pushButton_4.setObjectName("pushButton_4")
self.pushButton_4.clicked.connect(self.initializedModel3)
self.pushButton_5 = QtWidgets.QPushButton(Wind)
self.pushButton_5.setGeometry(QtCore.QRect(430, 270, 131, 61))
self.pushButton_5.setObjectName("pushButton_5")
self.pushButton_5.clicked.connect(self.perenos)
self.pushButton_6 = QtWidgets.QPushButton(Wind)
self.pushButton_6.setGeometry(QtCore.QRect(430, 350, 131, 61))
self.pushButton_6.setObjectName("pushButton_6")
self.pushButton_7 = QtWidgets.QPushButton(Wind)
self.pushButton_7.setGeometry(QtCore.QRect(690, 650, 141, 71))
self.pushButton_7.setObjectName("pushButton_7")
self.pushButton_7.clicked.connect(self.show_window_2)
self.pushButton_8 = QtWidgets.QPushButton(Wind)
self.pushButton_8.setGeometry(QtCore.QRect(430, 430, 131, 61))
self.pushButton_8.setObjectName("pushButton_8")
self.pushButton_9 = QtWidgets.QPushButton(Wind)
self.pushButton_9.setGeometry(QtCore.QRect(830, 650, 71, 71))
self.pushButton_9.setText("")
icon4 = QtGui.QIcon()
icon4.addPixmap(QtGui.QPixmap("изображение_2021-04-24_223918-removebg-preview.png"), QtGui.QIcon.Disabled, QtGui.QIcon.On)
self.pushButton_9.setIcon(icon4)
self.pushButton_9.setIconSize(QtCore.QSize(100, 100))
self.pushButton_9.setObjectName("pushButton_9")
self.retranslateUi(Wind)
self.buttonBox.accepted.connect(Wind.accept)
self.buttonBox.rejected.connect(Wind.reject)
QtCore.QMetaObject.connectSlotsByName(Wind)
def show_window_2(self): # открытие 2 окна
self.w2 = Window2()
self.w2.show()
def initializedModel(self,Wind):
self.db = QSqlDatabase.addDatabase("QSQLITE")
self.db.setDatabaseName("Продукты.db")
if not self.db.open():
return False
self.queryModel.setHeaderData(0, Qt.Horizontal, "Наименование")
self.queryModel.setHeaderData(1, Qt.Horizontal, "Описание")
sql = "SELECT * FROM Наименование"
self.queryModel.setQuery(sql, self.db)
self.totalRecordCount = self.queryModel.rowCount()
sql = "SELECT Наименование, Описание FROM Молочная_продукция limit %d,%d" % (0, self.pageRecordCount)
self.queryModel.setQuery(sql, self.db)
def initializedModel1(self,Wind):
self.db = QSqlDatabase.addDatabase("QSQLITE")
self.db.setDatabaseName("Продукты.db")
if not self.db.open():
return False
self.queryModel.setHeaderData(0, Qt.Horizontal, "Наименование")
self.queryModel.setHeaderData(1, Qt.Horizontal, "Описание")
sql = "SELECT * FROM"
self.queryModel.setQuery(sql, self.db)
self.totalRecordCount = self.queryModel.rowCount()
sql = "SELECT Наименование, Описание FROM Мясная_продукция limit %d,%d" % (0, self.pageRecordCount)
self.queryModel.setQuery(sql, self.db)
def initializedModel2(self,Wind):
self.db = QSqlDatabase.addDatabase("QSQLITE")
self.db.setDatabaseName("Продукты.db")
if not self.db.open():
return False
self.queryModel.setHeaderData(0, Qt.Horizontal, "Наименование")
self.queryModel.setHeaderData(1, Qt.Horizontal, "Описание")
sql = "SELECT * FROM"
self.queryModel.setQuery(sql, self.db)
self.totalRecordCount = self.queryModel.rowCount()
sql = "SELECT Наименование, Описание FROM Хлебобулочные_Изделия limit %d,%d" % (0, self.pageRecordCount)
self.queryModel.setQuery(sql, self.db)
def initializedModel3(self,Wind):
self.db = QSqlDatabase.addDatabase("QSQLITE")
self.db.setDatabaseName("Продукты.db")
if not self.db.open():
return False
self.queryModel.setHeaderData(0, Qt.Horizontal, "Наименование")
self.queryModel.setHeaderData(1, Qt.Horizontal, "Описание")
sql = "SELECT * FROM"
self.queryModel.setQuery(sql, self.db)
self.totalRecordCount = self.queryModel.rowCount()
sql = "SELECT Наименование, Описание FROM Товары_Для_Дома limit %d,%d" % (0, self.pageRecordCount)
self.queryModel.setQuery(sql, self.db)
def Bu(self,Wind):
self.db1 = QSqlDatabase.addDatabase("QSQLITE")
self.db1.setDatabaseName("Покупки.db")
if not self.db1.open():
return False
self.queryModel1.setHeaderData(0, Qt.Horizontal, "Корзина")
self.queryModel1.setHeaderData(1, Qt.Horizontal, "Цена")
sql = "SELECT * FROM Наименование"
self.queryModel1.setQuery(sql, self.db1)
self.totalRecordCount = self.queryModel1.rowCount()
sql = "SELECT * FROM Покупки limit %d,%d" % (0, self.pageRecordCount)
self.queryModel1.setQuery(sql, self.db1)
#Функция подготовленная для переноса
def perenos(self, Wind):
print('help')
#===================================
def closeEvent(self, event):
self.db.close()
self.db1.close()
def retranslateUi(self, Wind):
_translate = QtCore.QCoreApplication.translate
Wind.setWindowTitle(_translate("Wind", "Пампейка"))
self.pushButton_5.setText(_translate("Wind", "Взять"))
self.pushButton_6.setText(_translate("Wind", "???"))
self.pushButton_7.setText(_translate("Wind", "Купить"))
self.pushButton_8.setText(_translate("Wind", "Очистить"))
class Tab(Ui_Wind):
def __init__(self, parent=None):
super(Ui_Wind, self).__init__(parent)
self.db = None
self.db1 = None
#btfl
self.listWidget_2 = QtWidgets.QListWidget(Wind)
self.listWidget_2.setGeometry(QtCore.QRect(640, 190, 261, 421))
self.listWidget_2.setStyleSheet("background-color: rgb(255, 221, 179)")
self.listWidget_2.setObjectName("listWidget_2")
self.listWidget_111 = QtWidgets.QListWidget(Wind)
self.listWidget_111.setGeometry(QtCore.QRect(70, 170, 210, 651))
self.listWidget_111.setStyleSheet("background-color: rgb(255, 221, 187)")
self.listWidget_111.setObjectName("listWidget_111")
self.listWidget_11 = QtWidgets.QListWidget(Wind)
self.listWidget_11.setGeometry(QtCore.QRect(80, 190, 321, 421))
self.listWidget_11.setStyleSheet("background-color: rgb(255, 221, 179)")
self.listWidget_11.setObjectName("listWidget_11")
self.layout = QVBoxLayout(Wind)
self.queryModel = QSqlQueryModel(Wind)
self.layout1 = QVBoxLayout(Wind)
self.queryModel1 = QSqlQueryModel(Wind)
self.tableWidget = QTableView(Wind)
self.tableWidget.setModel(self.queryModel)
self.tableWidget.setGeometry(QtCore.QRect(90, 200, 300, 400))
#2table
self.tableWidget1 = QTableView(Wind)
self.tableWidget1.setModel(self.queryModel1)
self.tableWidget1.setGeometry(QtCore.QRect(650, 200, 240, 400))
self.tableWidget = QTableView()
self.tableWidget1 = QTableView()
self.tableWidget.horizontalHeader().setStretchLastSection(True)
self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
self.layout.addWidget(self.tableWidget)
self.tableWidget1.horizontalHeader().setStretchLastSection(True)
self.tableWidget1.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
self.layout1.addWidget(self.tableWidget1)
self.currentPage = 1
self.totalPage = None
self.totalRecordCount = None
self.pageRecordCount = 26
#vivod
self.setupUi(Wind)
self.initializedModel(Wind)
self.Bu(Wind)
self.tabla(Wind)
self.pds(Wind)
def tabla(self, Wind):
hLayout = QHBoxLayout()
self.layout.addLayout(hLayout)
self.setLayout(self.layout)
def pds(self, Wind):
hLayout1 = QHBoxLayout()
self.layout1.addLayout(hLayout1)
self.setLayout(self.layout1)
class Window2(QWidget):
def __init__(self):
super(Window2, self).__init__()
self.setWindowTitle('Чек')
self.setGeometry(500,150,500,800)
if __name__ == "__main__":
app = QtWidgets.QApplication(sys.argv)
Wind = QtWidgets.QDialog()
tb = Tab()
tb.tabla(Wind)
Wind.show()
sys.exit(app.exec_())