Python Forum
Python Forum

[PyQt] [Solved]Multiply a number to a DoubleSpinBox
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
[PyQt] [Solved]Multiply a number to a DoubleSpinBox
Extra
Spam, spam, eggs, and spam
Posts: 232
Threads: 81
Joined: Nov 2021
Reputation: 1
#10
May-23-2022, 01:14 PM (This post was last modified: May-23-2022, 01:14 PM by Extra.)
Oh ya, that's much better.
Thanks.

I do have one more questions though:

(1) I got the QsqlTableView formatted to my GUI but now there's a gray box in the top left corner of the screen/GUI under the Window/App name and I don't know what it is, or how it got there (I have attached a screenshot of the GUI/Screen). Why is that there and how do I get rid of it?



Thanks again.

My full code:
import sys
from PyQt5 import QtWidgets
from PyQt5.QtWidgets import (QApplication, QWidget, QPushButton, QMainWindow, 
                                QLabel, QLineEdit, QTableWidget, QTableWidgetItem, 
                                QGridLayout, QVBoxLayout, QSizePolicy, QSpacerItem,
                                QTableView)
from PyQt5.QtCore import Qt, QMetaObject, QCoreApplication
from PyQt5.QtGui import QFont
import sqlite3
from AddItemScreen import Ui_AddItemMenu
from Constants import MainDatabase
from Test2 import spindemo

from PyQt5.QtSql import QSqlDatabase, QSqlTableModel

class Ui_MainDisplay(QMainWindow):
    def __init__(self, parent = None):
        super(Ui_MainDisplay, self).__init__(parent)
        self.setObjectName("MainDisplay")
        self.setGeometry(0, 0, 1123, 903)
        self.setStyleSheet("background-color: rgb(0, 170, 255);")
        self.centralwidget = QWidget(self)
        self.centralwidget.setObjectName("centralwidget")
        self.gridLayout = QGridLayout(self.centralwidget)
        self.gridLayout.setObjectName("gridLayout")
        self.verticalLayout = QVBoxLayout()
        self.verticalLayout.setContentsMargins(-1, 0, -1, 0)
        self.verticalLayout.setSpacing(6)
        self.verticalLayout.setObjectName("verticalLayout")
        self.AddItemButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.AddItemButton.setFont(font)
        self.AddItemButton.setStyleSheet("background-color: rgb(85, 255, 0);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"\n"
"")
        self.AddItemButton.setObjectName("AddItemButton")
        self.verticalLayout.addWidget(self.AddItemButton)
        self.DeleteItemButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.DeleteItemButton.setFont(font)
        self.DeleteItemButton.setStyleSheet("background-color: rgb(255, 65, 68);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.DeleteItemButton.setObjectName("DeleteItemButton")
        self.verticalLayout.addWidget(self.DeleteItemButton)
        self.CheckoutButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.CheckoutButton.setFont(font)
        self.CheckoutButton.setStyleSheet("background-color: rgb(255, 255, 0);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.CheckoutButton.setObjectName("CheckoutButton")
        self.verticalLayout.addWidget(self.CheckoutButton)
        self.ReturnButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.ReturnButton.setFont(font)
        self.ReturnButton.setStyleSheet("background-color: rgb(255, 170, 32);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.ReturnButton.setObjectName("ReturnButton")
        self.verticalLayout.addWidget(self.ReturnButton)
        self.ScanBarcodeButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.ScanBarcodeButton.setFont(font)
        self.ScanBarcodeButton.setStyleSheet("background-color: rgb(211, 211, 211);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.ScanBarcodeButton.setObjectName("ScanBarcodeButton")
        self.verticalLayout.addWidget(self.ScanBarcodeButton)
        self.MoreInfoButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.MoreInfoButton.setFont(font)
        self.MoreInfoButton.setStyleSheet("background-color: rgb(196, 17, 255);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;")
        self.MoreInfoButton.setObjectName("MoreInfoButton")
        self.verticalLayout.addWidget(self.MoreInfoButton)
        self.RefreshButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.RefreshButton.setFont(font)
        self.RefreshButton.setStyleSheet("background-color: rgb(0, 255, 255);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"\n"
"")
        self.RefreshButton.setObjectName("RefreshButton")
        self.verticalLayout.addWidget(self.RefreshButton)
        spacerItem = QSpacerItem(20, 40, QSizePolicy.Policy.Minimum, QSizePolicy.Policy.Expanding)
        self.verticalLayout.addItem(spacerItem)
        self.LogoutButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.LogoutButton.setFont(font)
        self.LogoutButton.setStyleSheet("background-color: rgb(255, 255, 255);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.LogoutButton.setObjectName("LogoutButton")
        self.verticalLayout.addWidget(self.LogoutButton)
        self.gridLayout.addLayout(self.verticalLayout, 4, 3, 1, 1)
        self.Header = QLabel(self.centralwidget)
        font = QFont()
        font.setPointSize(15)
        font.setBold(True)
        font.setWeight(75)
        self.Header.setFont(font)
        self.Header.setStyleSheet("background-color: rgb(0, 0, 0);\n"
"color: rgb(255, 255, 255);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;")
        self.Header.setAlignment(Qt.AlignmentFlag.AlignCenter)
        self.Header.setObjectName("Header")
        self.gridLayout.addWidget(self.Header, 0, 1, 1, 3)
        self.SearchButton = QPushButton(self.centralwidget)
        font = QFont()
        font.setPointSize(10)
        font.setBold(True)
        font.setWeight(75)
        self.SearchButton.setFont(font)
        self.SearchButton.setStyleSheet("background-color: rgb(211, 211, 211);\n"
"border-style: outset;\n"
"border-width: 2px;\n"
"border-radius: 15px;\n"
"border-color: black;\n"
"padding: 4px;\n"
"")
        self.SearchButton.setObjectName("SearchButton")
        self.gridLayout.addWidget(self.SearchButton, 2, 1, 1, 1)
        self.SearchBar = QLineEdit(self.centralwidget)
        self.SearchBar.setStyleSheet("background-color: rgb(255, 255, 255);")
        self.SearchBar.setObjectName("SearchBar")
        self.gridLayout.addWidget(self.SearchBar, 2, 2, 1, 1)
        self.InventoryDisplay = QTableWidget(self.centralwidget)
        font = QFont()
        font.setBold(False)
        font.setWeight(50)
        self.InventoryDisplay.setFont(font)
        self.InventoryDisplay.setStyleSheet("background-color: rgb(255, 255, 255);\n"
"")
        # self.InventoryDisplay.setObjectName("InventoryDisplay")
        # self.InventoryDisplay.setColumnCount(11)
        # self.InventoryDisplay.setRowCount(0)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(0, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(1, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(2, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(3, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(4, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(5, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(6, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(7, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(8, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(9, item)
        # item = QTableWidgetItem()
        # self.InventoryDisplay.setHorizontalHeaderItem(10, item)
        # self.gridLayout.addWidget(self.InventoryDisplay, 4, 1, 1, 2)
        # self.setCentralWidget(self.centralwidget)
        # self.statusbar = self.statusBar()
        # self.statusbar.setObjectName("statusbar")
        #self.setStatusBar(self.statusbar)

#----------------------------------------------------------------------------------------------------
        #Connect to Database
        self.db = QSqlDatabase.addDatabase('QSQLITE')
        self.db.setDatabaseName('inventory.db')
        self.model = QSqlTableModel()
        self.delrow = -1
        self.initializeModel()

        self.sbar = self.statusBar()

        self.InventoryDisplay = QTableView()
        self.InventoryDisplay.setModel(self.model)
        self.InventoryDisplay.clicked.connect(self.findrow)
        self.InventoryDisplay.selectionModel().selectionChanged.connect(self.getCellText)

        # self.layout = QGridLayout()
        # self.layout.addWidget(self.InventoryDisplay, 0, 0, 1, 3)
        self.gridLayout.addWidget(self.InventoryDisplay, 4, 1, 1, 2)
        self.setCentralWidget(self.centralwidget)
         
        # button = QPushButton("add a row")
        # button.setFixedWidth(btnWidth)
        # button.clicked.connect(self.addrow)
        # self.layout.addWidget(button, 1, 0)
         
        # btn1 = QPushButton("delete a row")
        # btn1.setFixedWidth(btnWidth)
        # btn1.clicked.connect(self.delete_row)
        # self.layout.addWidget(btn1,1, 1)
 
        # self.myWidget = QWidget()
        # self.myWidget.setLayout(self.layout)
   
        # self.setCentralWidget(self.myWidget)
        # self.setGeometry(0,0,800,550)
        # self.setWindowTitle("Database Demo")
        # self.sbar.showMessage("Ready")
        
        self.retranslateUi(self)
        QMetaObject.connectSlotsByName(self)
 
    def initializeModel(self):
       self.model.setTable('items')
       self.model.setEditStrategy(QSqlTableModel.OnFieldChange)
       self.model.select()
       #self.model.setHeaderData(0, Qt.Horizontal, "Index")
       #self.model.setHeaderData(1, Qt.Horizontal, "Name")
       #self.model.setHeaderData(2, Qt.Horizontal, "Quantity")
       #self.model.setHeaderData(3, Qt.Horizontal, "Price")
       #self.model.setHeaderData(4, Qt.Horizontal, "Sell_Price")
       #self.model.setHeaderData(5, Qt.Horizontal, "Description")
       #self.model.setHeaderData(6, Qt.Horizontal, "Category")
       #self.model.setHeaderData(7, Qt.Horizontal, "Location")
       #self.model.setHeaderData(8, Qt.Horizontal, "Length_Ft ")
       #self.model.setHeaderData(9, Qt.Horizontal, "Barcode ")
       #self.model.setHeaderData(10, Qt.Horizontal, "Image ")
       #self.model.setHeaderData(11, Qt.Horizontal, "Date ")       
         
    def addrow(self):
        print(self.model.rowCount())
        ret = self.model.insertRows(self.model.rowCount(), 1)
        print(ret)
         
    def delete_row(self):
        row = self.InventoryDisplay.currentIndex().row()
        self.model.removeRow(row)
        self.initializeModel()
        self.InventoryDisplay.selectRow(row)
         
    def findrow(self, i):
        self.delrow = i.row()
 
    def getCellText(self):
        if self.InventoryDisplay.selectedIndexes():
            item = self.InventoryDisplay.selectedIndexes()[0]
            row = self.selectedRow()
            column = self.selectedColumn()
            if not item == None:
                name = item.data()
                self.sbar.showMessage(str(name))
 
    def selectedRow(self):
        if self.InventoryDisplay.selectionModel().hasSelection():
            row =  self.InventoryDisplay.selectionModel().selectedIndexes()[0].row()
            return int(row)
 
    def selectedColumn(self):
        column =  self.InventoryDisplay.selectionModel().selectedIndexes()[0].column()
        return int(column)
#----------------------------------------------------------------------------------------------------

        #Display the inventory
        #self.DisplayInventory()

#----------------------------------------------------------------------------------------------------
#                                 Display Inventory
#----------------------------------------------------------------------------------------------------

    def DisplayInventory(self):
        connection = sqlite3.connect(MainDatabase)
        cursor = connection.cursor()
        cursor.execute('SELECT * FROM items')
        row = 0
        self.InventoryDisplay.setRowCount(40)
        while True:
                form = cursor.fetchone()
                if form == None:
                        break
                for column, item in enumerate(form):
                        self.InventoryDisplay.setItem(row, column, QTableWidgetItem(str(item)))
                print(str(item))
                row += 1
        connection.close()
#----------------------------------------------------------------------------------------------------

  
    def retranslateUi(self, MainDisplay):
        _translate = QCoreApplication.translate
        self.setWindowTitle(_translate("MainDisplay", "AdminMenu"))
        self.AddItemButton.setText(_translate("MainDisplay", "Add Item"))
        self.DeleteItemButton.setText(_translate("MainDisplay", "Delete Item"))
        self.CheckoutButton.setText(_translate("MainDisplay", "Check Out"))
        self.ReturnButton.setText(_translate("MainDisplay", "Return"))
        self.ScanBarcodeButton.setText(_translate("MainDisplay", "Scan Barcode"))
        self.MoreInfoButton.setText(_translate("MainDisplay", "More Info"))
        self.RefreshButton.setText(_translate("MainDisplay", "Refresh"))
        self.LogoutButton.setText(_translate("MainDisplay", "Log Out"))
        self.Header.setText(_translate("MainDisplay", "Admin Menu"))
        self.SearchButton.setText(_translate("MainDisplay", "Search"))
        # item = self.InventoryDisplay.horizontalHeaderItem(0)
        # item.setText(_translate("MainDisplay", "ID"))
        # item = self.InventoryDisplay.horizontalHeaderItem(1)
        # item.setText(_translate("MainDisplay", "Name"))
        # item = self.InventoryDisplay.horizontalHeaderItem(2)
        # item.setText(_translate("MainDisplay", "Quantity"))
        # item = self.InventoryDisplay.horizontalHeaderItem(3)
        # item.setText(_translate("MainDisplay", "Price ($)"))
        # item = self.InventoryDisplay.horizontalHeaderItem(4)
        # item.setText(_translate("MainDisplay", "Sell Price ($)"))
        # item = self.InventoryDisplay.horizontalHeaderItem(5)
        # item.setText(_translate("MainDisplay", "Description"))
        # item = self.InventoryDisplay.horizontalHeaderItem(6)
        # item.setText(_translate("MainDisplay", "Category"))
        # item = self.InventoryDisplay.horizontalHeaderItem(7)
        # item.setText(_translate("MainDisplay", "Location"))
        # item = self.InventoryDisplay.horizontalHeaderItem(8)
        # item.setText(_translate("MainDisplay", "Length (Ft)"))
        # item = self.InventoryDisplay.horizontalHeaderItem(9)
        # item.setText(_translate("MainDisplay", "Barcode #"))
        # item = self.InventoryDisplay.horizontalHeaderItem(10)
        # item.setText(_translate("MainDisplay", "Date Updated"))

#----------------------------------------------------------------------------------------------------
#                                       Button Actions
#----------------------------------------------------------------------------------------------------
        #------------------------------------------
                        #Logout Button
        #------------------------------------------
        #When the Logout button is clicked -> LogoutClicked Function
        LogoutButton = self.LogoutButton
        LogoutButton.clicked.connect(self.LogoutClicked)
        #------------------------------------------
        #------------------------------------------
                        #Add Item Button
        #------------------------------------------
        #When the AddItem button is clicked -> AddItem Function
        AddItemButton = self.AddItemButton
        AddItemButton.clicked.connect(self.AddItemClicked)
        #------------------------------------------
        #------------------------------------------
                     #Remove Item Button
        #------------------------------------------
        #When the RemoveItem button is clicked -> RemoveItem Function
        RemoveItemButton = self.DeleteItemButton
        RemoveItemButton.clicked.connect(self.RemoveItemClicked)
        #------------------------------------------
        #------------------------------------------
                     #Checkout Item Button
        #------------------------------------------
        #When the Checkout button is clicked -> Checkout Function
        CheckoutButton = self.CheckoutButton
        CheckoutButton.clicked.connect(self.CheckoutClicked)
        #------------------------------------------
        #------------------------------------------
                     #Return Item Button
        #------------------------------------------
        #When the Return button is clicked -> Return Function
        ReturnButton = self.ReturnButton
        ReturnButton.clicked.connect(self.ReturnClicked)
        #------------------------------------------
        #------------------------------------------
                     #Scan Barcode Button
        #------------------------------------------
        #When the Scan Barcode button is clicked -> ScanBarcode Function
        ScanBarcodeButton = self.ScanBarcodeButton
        ScanBarcodeButton.clicked.connect(self.ScanBarcodeClicked)
        #------------------------------------------
        #------------------------------------------
                     #More Info Button
        #------------------------------------------
        #When the More Info button is clicked -> MoreInfo Function
        MoreInfoButton = self.MoreInfoButton
        MoreInfoButton.clicked.connect(self.MoreInfoClicked)
        #------------------------------------------
        #------------------------------------------
                     #Refresh Button
        #------------------------------------------
        #When the More Info button is clicked -> MoreInfo Function
        RefreshButton = self.RefreshButton
        RefreshButton.clicked.connect(self.RefreshClicked)
        #------------------------------------------
        #------------------------------------------
                     #Search Button
        #------------------------------------------
        #When the More Info button is clicked -> MoreInfo Function
        SearchButton = self.SearchButton
        SearchButton.clicked.connect(self.SearchClicked)
        #------------------------------------------
#----------------------------------
    #Logout Function
    def LogoutClicked(self):
        #Print in terminal for testing:
        print("The Logout Button was clicked")
        #Switch from this screen to the LoginScreen
        #(Import LoginScreen here to prevent circular import error)
        from LoginScreen import Ui_Loginscreen
        self.win = Ui_Loginscreen() #Define LoginScreen
        self.win.show() #Show Login Screen
        self.close() #Close this screen (AdminMenu)
#----------------------------------
#----------------------------------
    #AddItem Function
    def AddItemClicked(self):
        #Print in terminal for testing:
        print("The Add Item Button was clicked")
        #Switch from this screen to the AddItems Screen (Scene Swap):
        self.win = Ui_AddItemMenu()
        self.win.show()
        self.close()
#----------------------------------
#----------------------------------
    #RemoveItem Function
    def RemoveItemClicked(self):
        #Print in terminal for testing:
        print("The Delete Item Button was clicked")

        #Delete Items from the Inventory
        index = self.InventoryDisplay.currentIndex()
        NewIndex = self.InventoryDisplay.model().index(index.row(), 0)
        indexID = self.InventoryDisplay.model().data(NewIndex)
        print(indexID)

        connection = sqlite3.connect("inventory.db")
        cursor = connection.cursor()
        cursor.execute("DELETE FROM items WHERE id = ?", (indexID,))
        connection.commit()
        connection.close()
#----------------------------------
#----------------------------------
    #Checkout Function
    def CheckoutClicked(self):
        #Print in terminal for testing:
        print("The Checkout Button was clicked")
        #Switch from this screen to the AddItems Screen (Scene Swap):
        self.win = spindemo()
        self.win.show()
        # self.close()
        print()
#----------------------------------
#----------------------------------
    #Return Function
    def ReturnClicked(self):
        #Print in terminal for testing:
        print("The Return Button was clicked")
#----------------------------------
#----------------------------------
    #ScanBarcode Function
    def ScanBarcodeClicked(self):
        #Print in terminal for testing:
        print("The Scan Barcode Button was clicked")
#----------------------------------
#----------------------------------
    #MoreInfo Function
    def MoreInfoClicked(self):
        #Print in terminal for testing:
        print("The More Info Button was clicked")
#----------------------------------
#----------------------------------
    #Refresh Function
    def RefreshClicked(self):
        #Print in terminal for testing:
        print("The Refresh Button was clicked")
        #Close and reopen the app (Refresh)
        self.win = Ui_MainDisplay()
        self.win.show()
        self.close()
#----------------------------------
#----------------------------------
    #Search Function
    def SearchClicked(self):
        #Print in terminal for testing:
        print("The Search Button was clicked")
#----------------------------------
#----------------------------------------------------------------------------------------------------

 
if __name__ == '__main__':
    app = QApplication(sys.argv)
    win = Ui_MainDisplay()
    win.show()

    sys.exit(app.exec_())
Find
Reply


Messages In This Thread
RE: Multiply a number to a DoubleSpinBox - by Extra - May-22-2022, 05:14 PM
RE: Multiply a number to a DoubleSpinBox - by Extra - May-22-2022, 05:52 PM
RE: Multiply a number to a DoubleSpinBox - by Extra - May-22-2022, 09:27 PM
RE: Multiply a number to a DoubleSpinBox - by Extra - May-22-2022, 09:54 PM
RE: [Solved]Multiply a number to a DoubleSpinBox - by Extra - May-23-2022, 01:14 PM
RE: Multiply a number to a DoubleSpinBox - by Extra - May-23-2022, 01:22 PM

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020