tablodaki fiyat kolonunun tüm dolu olanlarını toplamak istiyorum nasıl yapabilirm
KODLAR:
import typing
from PyQt5.QtWidgets import *
from PyQt5.QtGui import QIntValidator,QIcon,QPixmap,QFont
import sqlite3
from PyQt5.QtCore import QRect
from PyQt5 import QtCore,QtGui,QtWidgets,Qt
from time import sleep as bekle
from taksit import Taksit
class MainW(QMainWindow):
def __init__(self):
super().__init__()
self.connectdb()
self.taksit = Taksit()
self.tableWidget = QTableWidget(self)
self.setFixedSize(797,871)
if (self.tableWidget.columnCount() < 4):
self.tableWidget.setColumnCount(4)
self.tableWidget.setHorizontalHeaderLabels(("Ürün Adı","Barkod","Adet","Fiyat"))
self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
if (self.tableWidget.rowCount() < 20):
self.tableWidget.setRowCount(20)
self.tableWidget.setObjectName(u"tableWidget")
self.tableWidget.setGeometry(QRect(30, 0, 741, 651))
self.tableWidget.setRowCount(20)
self.tableWidget.setColumnCount(4)
self.tableWidget.horizontalHeader().setMinimumSectionSize(0)
self.tableWidget.horizontalHeader().setStretchLastSection(False)
self.tableWidget.verticalHeader().setProperty("showSortIndicator", True)
self.tableWidget.verticalHeader().setStretchLastSection(True)
self.tableWidget.setCurrentIndex(2)
self.satisButton = QPushButton("SATIŞ",self)
self.satisButton.setObjectName(u"pushButton")
self.satisButton.setGeometry(QRect(540, 760, 221, 51))
font = QFont()
font.setPointSize(10)
font.setBold(True)
font.setWeight(75)
self.satisButton.setFont(font)
self.satisButton.setStyleSheet(u"#pushButton {\n"
" color:#ffffff;\n"
" background-color: #0d6efd;\n"
" border-radius: 7px;\n"
"}\n"
"\n"
"#pushButton:hover {\n"
" background-color: #0055ff;\n"
" \n"
"}\n"
"\n"
"#pushButton:pressed {\n"
" border: 4px solid #98c1fe;\n"
"}\n"
"\n"
"")
self.kredibutton = QPushButton("KREDİ KART",self)
self.kredibutton.setObjectName(u"kredibutton")
self.kredibutton.setGeometry(QRect(150, 670, 111, 141))
self.kredibutton.setFont(font)
self.kredibutton.setStyleSheet(u"#kredibutton {\n"
" color:#ffffff;\n"
" background-color: #0d6efd;\n"
" border-radius: 7px;\n"
"}\n"
"\n"
"#kredibutton:hover {\n"
" background-color: #0055ff;\n"
" \n"
"}\n"
"\n"
"#kredibutton:pressed {\n"
" border: 4px solid #98c1fe;\n"
"}\n"
"\n"
"")
self.kredibutton.setCheckable(True)
self.nakitbutton = QPushButton("NAKİT",self)
self.nakitbutton.setObjectName(u"nakitbutton")
self.nakitbutton.setGeometry(QRect(30, 670, 111, 141))
self.nakitbutton.setFont(font)
self.nakitbutton.setStyleSheet(u"#nakitbutton {\n"
" color:#ffffff;\n"
" background-color: #0d6efd;\n"
" border-radius: 7px;\n"
"}\n"
"\n"
"#nakitbutton:hover {\n"
" background-color: #0055ff;\n"
" \n"
"}\n"
"\n"
"#nakitbutton:pressed {\n"
" border: 4px solid #98c1fe;\n"
"}\n"
"\n"
"")
self.nakitbutton.setCheckable(True)
self.kredinakitbutton = QPushButton("KREDİ KART\n+ NAKİT",self)
self.kredinakitbutton.setObjectName(u"kredinakitbutton")
self.kredinakitbutton.setGeometry(QRect(270, 670, 111, 141))
font1 = QFont()
font1.setPointSize(10)
font1.setBold(True)
font1.setUnderline(False)
font1.setWeight(75)
font1.setStrikeOut(False)
self.kredinakitbutton.setFont(font1)
self.kredinakitbutton.setStyleSheet(u"#kredinakitbutton {\n"
" color:#ffffff;\n"
" background-color: #0d6efd;\n"
" border-radius: 7px;\n"
"}\n"
"\n"
"#kredinakitbutton:hover {\n"
" background-color: #0055ff;\n"
" \n"
"}\n"
"\n"
"#kredinakitbutton:pressed {\n"
" border: 4px solid #98c1fe;\n"
"}\n"
"\n"
"")
self.kredinakitbutton.setCheckable(True)
self.taksitbutton = QPushButton("TAKSİT",self)
self.taksitbutton.setObjectName(u"taksitbutton")
self.taksitbutton.setGeometry(QRect(390, 670, 111, 141))
self.taksitbutton.setFont(font1)
self.taksitbutton.setStyleSheet(u"#taksitbutton {\n"
" color:#ffffff;\n"
" background-color: #0d6efd;\n"
" border-radius: 7px;\n"
"}\n"
"\n"
"#taksitbutton:hover {\n"
" background-color: #0055ff;\n"
" \n"
"}\n"
"\n"
"#taksitbutton:pressed {\n"
" border: 4px solid #98c1fe;\n"
"}\n"
"\n"
"")
self.taksitbutton.setCheckable(True)
self.fiyatlabel = QLabel("<html><head/><body><p align=\"right\">{}</p></body></html>".format(""),self)
self.fiyatlabel.setObjectName(u"label")
self.fiyatlabel.setGeometry(QRect(540, 700, 221, 41))
font2 = QFont()
font2.setPointSize(14)
font2.setBold(True)
font2.setWeight(75)
self.fiyatlabel.setFont(font2)
self.fiyatlabel.setStyleSheet(u"background-color:green;\n"
"color:white;\n"
"border-radius: 10px;\n"
"")
self.fiyatlabel.setScaledContents(True)
self.fiyatlabel.setMargin(0)
self.label_2 = QLabel("<html><head/><body><p align=\"center\">TOPLAM</p></body></html>",self)
self.label_2.setObjectName(u"label_2")
self.label_2.setGeometry(QRect(540, 670, 201, 21))
self.label_2.setFont(font)
self.menubar = QMenuBar(self)
self.menubar.setObjectName(u"menubar")
self.menubar.setGeometry(QRect(0, 0, 797, 26))
self.setMenuBar(self.menubar)
self.statusbar = QStatusBar(self)
self.statusbar.setObjectName(u"statusbar")
self.setStatusBar(self.statusbar)
self.taksitbutton.clicked.connect(self.taksitw)
self.satisButton.clicked.connect(self.anamenu)
def taksitw(self):
self.taksit.show()
def connectdb(self):
self.connect = sqlite3.connect("urunler.db")
self.cursorr = self.connect.cursor()
self.cursorr.execute("CREATE TABLE IF NOT EXISTS urunler(urunadi,urunkodu,barkod INT,fiyat)")
self.connect.commit()