def showcarrinho():
if request.method == 'POST':
loja.usr.nif = request.form['nif']
loja.usr.nome = request.form['nome']
loja.usr.morada = request.form['morada']
loja.usr.update()
try:
from fatura import Fatura
loja.fatura = Fatura().cria_pdf(loja)
except:
loja.fatura = 'Brevemente.pdf'
loja.encomenda()
return redirect('/encomenda')
return render_template('carrinho.html', loja=loja)
def main():
app =QApplication(sys.argv)
app.processEvents()
mainWindow = MainWindow()
login=Login()
myddb = Myddb()
recete=Recete()
recete2=Recete2()
fatura=Fatura()
maliyet=Maliyet()
cari = Cari()
stok = Stok()
rapor = Rapor()
workerthread = WorkerThread()
workerthread.start()
bul=myddb.cek("select * from hammadde where kategori=2 or kategori=3 order by hamkod")
logger.info('Program opened '+str(os.getpid()))
@pyqtSlot(int,int)
def slotrecete2(item,item2):
recete2.lineEdit.setText("")
# recete2 ekranı hazırlanıyor
recete2.label_2.setText(str(item))
deger0=recete.tableWidget.item(item,1).text()
recete2.label_3.setText(deger0)
file = open(deger0+".txt", "w")
deger0=recete.tableWidget.item(item,1).text()
deger1=deger0+" "+recete.tableWidget.item(item,2).text()+" "
recete2.label.setText(deger1)
# veritabanından bilgi çek
bul2=myddb.cek2(deger0,"recete","menukod")
bul=myddb.cek("select * from hammadde where kategori=2")
myddb.conn.commit()
recete2.comboBox.clear()
i=len(bul)
for xx1 in range(i):
recete2.comboBox.addItem(str(bul[xx1][1])+" "+bul[xx1][2])
i=len(bul2)
j=5
recete2.tableWidget_2.setRowCount(i)
aa=0
toplam=0
topelma=0
print bul2
for row1 in bul2:
item=str(row1[2])
bul3=myddb.cek2(item,"hammadde","hamkod")
myddb.conn.commit()
print bul3
item=str(bul3[0][1])
file.write(item+" ")
recete2.tableWidget_2.setItem(aa, 0, QtGui.QTableWidgetItem(item))
item=bul3[0][2]
#file.write(item+" ")
recete2.tableWidget_2.setItem(aa, 1, QtGui.QTableWidgetItem(item))
item=bul3[0][3]
file.write(item+" ")
recete2.tableWidget_2.setItem(aa, 2, QtGui.QTableWidgetItem(item))
item=str(row1[3])
recete2.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item))
file.write(item + " ")
item = str(bul3[0][6])
file.write(item + "\n")
recete2.tableWidget_2.setItem(aa, 4, QtGui.QTableWidgetItem(item))
elma=(bul3[0][6])*(row1[3])*(100+(bul3[0][4]))/100
topelma=topelma+elma
item = str(elma)
file.write(item + "\n")
item = str("{:.2f}".format(elma))
item = QtGui.QTableWidgetItem(item)
item.setTextAlignment(QtCore.Qt.AlignVCenter | QtCore.Qt.AlignRight)
recete2.tableWidget_2.setItem(aa, 5, QtGui.QTableWidgetItem(item))
aa=aa+1
recete2.label_4.setText(str("{:.2f}".format(topelma)))
file.close()
recete2.tableWidget.setColumnWidth(0, 50)
recete2.tableWidget.setColumnWidth(1, 250)
recete2.tableWidget.setColumnWidth(2, 50)
recete2.tableWidget.setColumnWidth(3, 50)
recete2.tableWidget_2.setColumnWidth(0, 50)
recete2.tableWidget_2.setColumnWidth(1, 150)
recete2.tableWidget_2.setColumnWidth(2, 50)
recete2.tableWidget_2.setColumnWidth(3, 75)
recete2.tableWidget_2.setColumnWidth(4, 75)
recete2.tableWidget_2.setColumnWidth(5, 60)
recete2.show()
recete2.lineEdit.setFocus(True)
@pyqtSlot()
def slotrecete2sql(item2):
a=item2.toUtf8()
a=str(a)
print a
bul=myddb.cek1(a,"hammadde","hamad")
i=len(bul)
j=5
recete2.tableWidget.setRowCount(i)
recete2.tableWidget.setSelectionBehavior(QAbstractItemView.SelectRows)
aa=0
toplam=0
for row1 in bul:
item=str(row1[1])
recete2.tableWidget.setItem(aa, 0, QtGui.QTableWidgetItem(item))
item=row1[2]
recete2.tableWidget.setItem(aa, 1, QtGui.QTableWidgetItem(item))
item=row1[3]
recete2.tableWidget.setItem(aa, 2, QtGui.QTableWidgetItem(item))
item=str(row1[4])
recete2.tableWidget.setItem(aa, 3, QtGui.QTableWidgetItem(item))
aa=aa+1
@pyqtSlot(int,int)
def slothamclick(item,item2):
# hammadde listesinden çiftklikle tablewidget_2 ye hammadde bilgisini ekliyor.
i=recete2.tableWidget_2.rowCount()
deger1=recete2.tableWidget.item(item,0).text()
deger2=recete2.tableWidget.item(item,1).text()
deger3=recete2.tableWidget.item(item,2).text()
i=i+1
j=5
recete2.tableWidget_2.setRowCount(i)
aa=i-1
item=deger1
recete2.tableWidget_2.setItem(aa, 0, QtGui.QTableWidgetItem(item))
item=deger2
recete2.tableWidget_2.setItem(aa, 1, QtGui.QTableWidgetItem(item))
item=deger3
recete2.tableWidget_2.setItem(aa, 2, QtGui.QTableWidgetItem(item))
item = '0'
recete2.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item))
#recete2.lineEdit.setFocus(True)
recete2.tableWidget_2.setFocus()
recete2.tableWidget_2.setCurrentCell(aa,3)
QtCore.QSound(r"horn.wav").play()
@pyqtSlot()
def slotrecete2kaydet():
deger0=recete2.label_3.text()
myddb.sil(deger0,"recete","menukod")
i=recete2.tableWidget_2.rowCount()
for item in range(i):
deger1=recete2.tableWidget_2.item(item,0).text()
deger2=recete2.tableWidget_2.item(item,3).text()
print deger0 , deger1 , deger2
deger2=fatura.kontrol(deger2)
myddb.kaydet(deger0,deger1,deger2)
myddb.conn.commit()
recete2.close()
slotrecete2(int(recete2.label_2.text()),0)
# veritabanından bilgi çek
@pyqtSlot()
def slotpuss(item2):
print "reçete arayüzü açıldı"
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Reçete Bishop Restaurant")
recete.move(13, 10)
recete.show()
recete.setFixedSize(recete.size()); # dialog penceresi boyutu sabit (fixed)
i=len(bul)
j=5
recete.tableWidget.setRowCount(i)
recete.tableWidget.setSelectionBehavior(QAbstractItemView.SelectRows)
recete.tableWidget.setColumnWidth(0,50)
recete.tableWidget.setColumnWidth(1,50)
recete.tableWidget.setColumnWidth(2,220)
recete.tableWidget.setColumnWidth(3,100)
# TODO: Sutün genişlikleri ayarlanacak
aa=0
toplam=0
for row1 in bul:
item=str(row1[0])
recete.tableWidget.setItem(aa, 0, QtGui.QTableWidgetItem(item))
item=str(row1[1])
bul2 = myddb.cek2(item, "recete", "menukod")
recete.tableWidget.setItem(aa, 1, QtGui.QTableWidgetItem(item))
item=row1[2]
recete.tableWidget.setItem(aa, 2, QtGui.QTableWidgetItem(item))
item=str(row1[3])
proto=QtGui.QTableWidgetItem(item)
proto.setTextAlignment(Qt.AlignRight)
recete.tableWidget.setItem(aa, 3, proto)
item=str(row1[4])
recete.tableWidget.setItem(aa, 4, QtGui.QTableWidgetItem(item))
if len(bul2) == 0:
recete.tableWidget.item(aa, 2).setBackground(QtGui.QColor('red'))
aa=aa+1
recete.lineEdit.setFocus(True)
@pyqtSlot()
def slotfatura(item2):
fatura.goster()
fatura.lineEdit.setText(item2)
@pyqtSlot()
def slottediye(item2):
if item2=="VADE":
cari.show()
cari.slotcarivade()
@pyqtSlot()
def slotmaliyet(item2):
print "maliyet arayüzü açıldı"
maliyet.show()
@pyqtSlot()
def slotcari(item2):
print "cari arayüzü açıldı"
cari.show()
@pyqtSlot()
def slotstok(item2):
print "stok arayüzü açıldı"
stok.show()
stok.raise_()
@pyqtSlot()
def slotkasa(item2):
print "kasa arayüzü açıldı"
rapor.show()
@pyqtSlot()
def slotpuss4(item2):
print item2
if item2 == 100:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Kullanıcı adı girilmedi !!! Bishop Restaurant")
mainWindow.pushButton.blockSignals(1)
mainWindow.pushButton_2.blockSignals(1)
mainWindow.pushButton_3.blockSignals(1)
mainWindow.pushButton_4.blockSignals(1)
mainWindow.pushButton_5.blockSignals(1)
mainWindow.pushButton_6.blockSignals(1)
mainWindow.actionTediye_Fi_i.setEnabled(0)
mainWindow.actionSay_m_Fi_i.setEnabled(0)
mainWindow.actionStok_Tan_mlama.setEnabled(0)
if item2 == 12345:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Mutfak Şef Bishop Restaurant")
mainWindow.pushButton_2.blockSignals(0)
if item2 == 123456:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Kasiyer Bishop Restaurant")
mainWindow.pushButton_5.blockSignals(0)
if item2 == 101:
mainWindow.close()
if item2 == 1234:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 3010 Yönetici Bishop Restaurant")
mainWindow.pushButton.blockSignals(0)
mainWindow.pushButton_2.blockSignals(0)
mainWindow.pushButton_3.blockSignals(0)
mainWindow.pushButton_4.blockSignals(0)
mainWindow.pushButton_5.blockSignals(0)
mainWindow.pushButton_6.blockSignals(0)
mainWindow.actionTediye_Fi_i.setEnabled(1)
mainWindow.actionSay_m_Fi_i.setEnabled(1)
mainWindow.actionStok_Tan_mlama.setEnabled(1)
@pyqtSlot()
def slotpuss5(item2):
logger.info(item2)
print "shdfhdfdjhfg"
@pyqtSlot()
def slotpuss6(item2):
logger.info(item2+u"nolu fişi göster")
fatura.goster()
fatura.lineEdit_5.setText(item2)
fatura.fisgetir(item2)
@pyqtSlot()
def slottextch(item2):
print "kjkljlk reçete"
a=item2.toUtf8()
a='%'+str(a)+'%'
print a
sql3 = "select * from hammadde where (kategori=2 or kategori=3) and ( hamkod like '"+a+"' or hamad like '"+a+"' ) order by hamkod"
myddb.cur.execute(sql3)
bul=myddb.cur.fetchall()
i=len(bul)
j=5
recete.tableWidget.setRowCount(i)
aa=0
toplam=0
for row1 in bul:
item=str(row1[0])
recete.tableWidget.setItem(aa, 0, QtGui.QTableWidgetItem(item))
item=str(row1[1])
recete.tableWidget.setItem(aa, 1, QtGui.QTableWidgetItem(item))
item=row1[2]
recete.tableWidget.setItem(aa, 2, QtGui.QTableWidgetItem(item))
item=str(row1[3])
recete.tableWidget.setItem(aa, 3, QtGui.QTableWidgetItem(item))
item=str(row1[4])
recete.tableWidget.setItem(aa, 4, QtGui.QTableWidgetItem(item))
aa=aa+1
@pyqtSlot()
def copyFunction():
print "f10 a bastın"
elma=fatura.tableWidget_2.currentRow()
elma1=fatura.tableWidget_2.rowCount()
if elma==-1:
abc = QKeyEvent(QEvent.KeyPress, Qt.Key_Tab, Qt.NoModifier)
QCoreApplication.postEvent(fatura, abc)
else:
fatura.tableWidget_2.focusNextChild()
'''
if fatura.tableWidget_2.currentColumn()==5:
if elma1 == elma + 1:
fatura.pushButton.setFocus()
else:
fatura.tableWidget_2.setCurrentCell(elma + 1, 2)
print elma '''
@pyqtSlot()
def slotrecete2satirsil():
bb=recete2.tableWidget_2.currentRow()
recete2.tableWidget_2.removeRow(bb)
# dosya açmak için dialog
# fileName =(QtGui.QFileDialog.getOpenFileName(mainWindow, u"Düzenlenecek dosyayı seçin", ".", u"Metin dosyaları (*.txt)"))
app.setWindowIcon(QtGui.QIcon('nenra.png'))
mainWindow.verticalLayoutWidget_2.setStyleSheet("background-image: url(images/newyork.png);")
mainWindow.pushButton.setStyleSheet("color: black ; background-image: url(images/image.png)")
mainWindow.pushButton_2.setStyleSheet("color: black ; background-image: url(images/fatura.png)")
mainWindow.pushButton_3.setStyleSheet("color: black ; background-image: url(images/maliyet.png)")
mainWindow.pushButton_4.setStyleSheet("color: black ; background-image: url(images/nenra.png)")
mainWindow.pushButton_5.setStyleSheet("color: black ; background-image: url(images/nenra.png)")
mainWindow.pushButton_6.setStyleSheet("color: black ; background-image: url(images/maliyet.png)")
mainWindow.pushButton.clicked.connect(slotpuss)
mainWindow.pushButton_2.clicked.connect(slotfatura)
mainWindow.pushButton_3.clicked.connect(slotmaliyet)
mainWindow.pushButton_4.clicked.connect(slotcari)
mainWindow.pushButton_5.clicked.connect(slotstok)
mainWindow.pushButton_6.clicked.connect(slotkasa)
mainWindow.actionTediye_Fi_i.triggered.connect(lambda:slotfatura("TED"))
mainWindow.actionSay_m_Fi_i.triggered.connect(lambda: slotfatura("SAY"))
mainWindow.actionStok_Tan_mlama.triggered.connect(lambda:slottediye("VADE"))
mainWindow.statusbar.showMessage(u"Namık ERDOĞAN © 2016 v 1.513 Bishop Restaurant")
recete.lineEdit.textChanged.connect(slottextch)
recete.tableWidget.cellClicked.connect(slotrecete2)
recete2.lineEdit.textChanged.connect(slotrecete2sql)
recete2.tableWidget.cellClicked.connect(slothamclick)
recete2.pushButton.clicked.connect(slotrecete2kaydet)
recete2.pushButton_3.clicked.connect(slotrecete2satirsil)
recete.setWindowModality(Qt.ApplicationModal)
recete2.setWindowModality(Qt.ApplicationModal)
fatura.setWindowModality(Qt.ApplicationModal)
maliyet.setWindowModality(Qt.ApplicationModal)
login.setWindowModality(Qt.ApplicationModal)
rapor.setWindowModality(Qt.ApplicationModal)
stok.setWindowModality(Qt.ApplicationModal)
fatura.connect(QtGui.QShortcut(QtGui.QKeySequence(Qt.Key_Enter), fatura), QtCore.SIGNAL('activated()'), copyFunction)
mainWindow.connect(login, QtCore.SIGNAL("acac1(int)"), slotpuss4)
slotpuss4(100)
mainWindow.connect(fatura, QtCore.SIGNAL("acac"), slotpuss5)
mainWindow.connect(cari, QtCore.SIGNAL("fisac"), slotpuss6)
mainWindow.move(13, 10)
#mainWindow.setWindowFlags(QtCore.Qt.FramelessWindowHint)
#mainWindow.raise_()
mainWindow.show()
mainWindow.menubar.setStyleSheet(" QMenuBar { background-color: orange; } QMenuBar::item { background-color: orange; } ")
mainWindow.setStyleSheet(" background-color: orange;")
#mainWindow.setWindowState(mainWindow.windowState() & ~QtCore.Qt.WindowMinimized | QtCore.Qt.WindowActive)
#mainWindow.activateWindow()
login.setWindowFlags(QtCore.Qt.FramelessWindowHint)
login.setStyleSheet("color:red ; background-color: orange;")
login.show()
login.raise_()
return app.exec_()
def masrafkaydet(self, ):
self.pushButton_3.setDisabled(True)
self.pushButton_3.blockSignals(1)
dur = 0.001
fatura = Fatura()
fatura.goster()
fatura.lineEdit.setText('ZZ')
self.dt = self.dateEdit.date().toPyDate()
self.dt = QtCore.QDate.fromString(str(self.dt), 'yyyy-MM-dd')
fatura.dateEdit.setDate(self.dt)
fatura.dateEdit_2.setDate(self.dt)
fatura.lineEdit_3.setText("kasa")
time.sleep(dur)
fatura.slotfatura(0, 0)
time.sleep(dur)
satir = 0
onur = 0
i = self.tableWidget_2.rowCount()
if i == 0:
return
for item in range(i):
deger10 = self.tableWidget_2.item(item, 0).text()
deger11 = self.led[satir].text()
deger12 = self.led[satir+1].text()
deger13 = self.tableWidget_2.item(item, 2).text()
deger14 = self.tableWidget_2.item(item, 1).text()
# deger14 = u' '.join((str(deger14))).encode('utf-8').strip()
deger13 = self.kontrol(deger13)
if float(deger13) < 0:
deger13 = float(deger13)*-1
if deger12 == "":
print("cari yok")
satir += 2
continue
if deger12 == "17":
print("onur")
fatura.lineEdit_3.setText("")
fatura.lineEdit_3.setText(deger11)
time.sleep(dur)
fatura.slotfatura(0, 0)
time.sleep(dur)
fatura.tableWidget_2.setItem(onur, 6, QtWidgets.QTableWidgetItem(str(deger13)))
fatura.tableWidget_2.setItem(onur, 1, QtWidgets.QTableWidgetItem(deger14))
fatura.tableWidget_2.setItem(onur, 3, QtWidgets.QTableWidgetItem("0"))
time.sleep(dur)
onur += 1
fatura.slotfaturakaydet()
self.mydbb.cur.execute("""update bishop.kasa set muhkod=1 where islemid=%s""", (deger10,))
self.mydbb.conn.commit()
else:
dur = 0.02
self.mydbb.cur.execute("""select cariad from cari where cariid=%s""", (deger12,))
cariadd = self.mydbb.cur.fetchone()
print(cariadd[0])
self.mydbb.conn.commit()
fatura1 = Fatura()
fatura1.goster()
fatura1.lineEdit.setText('TED')
self.dt = self.dateEdit.date().toPyDate()
self.dt = QtCore.QDate.fromString(str(self.dt), 'yyyy-MM-dd')
fatura1.dateEdit.setDate(self.dt)
fatura1.dateEdit_2.setDate(self.dt)
fatura1.lineEdit_3.setText(cariadd[0])
time.sleep(dur)
fatura1.slotfatura(0, 0)
time.sleep(dur)
fatura1.lineEdit_3.setText("NAKIT")
time.sleep(dur)
fatura1.slotfatura(0, 0)
time.sleep(dur)
fatura1.tableWidget_2.setItem(0, 6, QtWidgets.QTableWidgetItem(str(deger13)))
fatura1.tableWidget_2.setItem(0, 1, QtWidgets.QTableWidgetItem((deger14)))
fatura1.tableWidget_2.setItem(0, 4, QtWidgets.QTableWidgetItem("-1"))
time.sleep(dur)
fatura1.slotfaturakaydet()
self.mydbb.cur.execute("""update bishop.kasa set muhkod=1 where islemid=%s""", (deger10,))
self.mydbb.conn.commit()
satir += 2
fatura.slotfaturakont()
def main():
app = QApplication(sys.argv)
app.processEvents()
sound = QSound("./images/ses.wav")
sound.play()
mainWindow = MainWindow()
login = Login()
recete = Recete()
fatura = Fatura()
maliyet = Maliyet()
cari = Cari()
stok = Stok()
rapor = Rapor()
masraf = Masraf()
workerthread = WorkerThread()
workerthread.start()
logger.info('Program opened ' + str(os.getpid()))
@pyqtSlot()
def slotpuss(item2):
myddb = Myddb()
print("reçete arayüzü açıldı")
bul = myddb.cek("select * from hammadde where kategori=2 or"
" kategori=3 order by hamkod")
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Reçete 2020.03"
u" Bishop Restaurant")
recete.move(13, 10)
recete.show()
recete.setFixedSize(recete.size())
# dialog penceresi boyutu sabit (fixed)
i = len(bul)
recete.tableWidget.setRowCount(i)
recete.tableWidget.setSelectionBehavior(
QtWidgets.QAbstractItemView.SelectRows)
recete.tableWidget.setColumnWidth(0, 50)
recete.tableWidget.setColumnWidth(1, 50)
recete.tableWidget.setColumnWidth(2, 220)
recete.tableWidget.setColumnWidth(3, 100)
# TODO: Sutün genişlikleri ayarlanacak
aa = 0
toplam = 0
for row1 in bul:
item = str(row1[0])
recete.tableWidget.setItem(aa, 0, QtWidgets.QTableWidgetItem(item))
item = str(row1[1])
bul2 = myddb.cek2(item, "recete", "menukod")
recete.tableWidget.setItem(aa, 1, QtWidgets.QTableWidgetItem(item))
item = row1[2]
recete.tableWidget.setItem(aa, 2, QtWidgets.QTableWidgetItem(item))
item = str(row1[3])
proto = QtWidgets.QTableWidgetItem(item)
proto.setTextAlignment(Qt.AlignRight)
recete.tableWidget.setItem(aa, 3, proto)
item = str(row1[4])
recete.tableWidget.setItem(aa, 4, QtWidgets.QTableWidgetItem(item))
if len(bul2) == 0:
recete.tableWidget.item(aa,
2).setBackground(QtGui.QColor('red'))
aa = aa + 1
recete.lineEdit.setFocus(True)
@pyqtSlot()
def slotfatura(item2):
fatura.goster()
fatura.lineEdit.setText(item2)
@pyqtSlot()
def slottediye(item2):
if item2 == "VADE":
cari.show()
# cari.slotcarivade()
@pyqtSlot()
def slotmaliyet(item2):
print("maliyet arayüzü açıldı")
maliyet.show()
@pyqtSlot()
def slotcari(item2):
print("cari arayüzü açıldı")
cari.show()
@pyqtSlot()
def slotstok(item2):
print("stok arayüzü açıldı")
stok.show()
stok.raise_()
@pyqtSlot()
def slotkasa(item2):
print("kasa arayüzü açıldı")
rapor.show()
@pyqtSlot()
def slotmasraf(item2):
print("masraf arayüzü açıldı")
masraf.show()
masraf.raise_()
@pyqtSlot()
def slotpuss4(item2):
print(item2)
mainWindow.show()
mainWindow.raise_()
if item2 == 100:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Kullanıcı adı girilmedi !!! "
u" Bishop Restaurant")
mainWindow.pushButton.blockSignals(1)
mainWindow.pushButton_2.blockSignals(1)
mainWindow.pushButton_3.blockSignals(1)
mainWindow.pushButton_4.blockSignals(1)
mainWindow.pushButton_5.blockSignals(1)
mainWindow.pushButton_6.blockSignals(1)
mainWindow.actionTediye_Fi_i.setEnabled(0)
mainWindow.actionSay_m_Fi_i.setEnabled(0)
mainWindow.actionStok_Tan_mlama.setEnabled(0)
if item2 == 12345:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Mutfak Şef "
u" Bishop Restaurant")
mainWindow.pushButton_2.blockSignals(0)
if item2 == 123456:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 Kasiyer "
u" Bishop Restaurant")
mainWindow.pushButton_5.blockSignals(0)
if item2 == 101:
mainWindow.close()
if item2 == 1234:
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 12072021 Yönetici "
u" Bishop Restaurant")
mainWindow.pushButton.blockSignals(0)
mainWindow.pushButton_2.blockSignals(0)
mainWindow.pushButton_3.blockSignals(0)
mainWindow.pushButton_4.blockSignals(0)
mainWindow.pushButton_5.blockSignals(0)
mainWindow.pushButton_6.blockSignals(0)
mainWindow.actionTediye_Fi_i.setEnabled(1)
mainWindow.actionSay_m_Fi_i.setEnabled(1)
mainWindow.actionStok_Tan_mlama.setEnabled(1)
@pyqtSlot()
def slotpuss5(item2):
logger.info(item2)
@pyqtSlot()
def slotpuss6(item2):
logger.info(item2 + " nolu fişi göster")
fatura.goster()
fatura.lineEdit_5.setText(item2)
fatura.fisgetir(item2)
@pyqtSlot()
def copyFunction(e):
print("f10 a bastın")
print(e.key())
'''
if fatura.tableWidget_2.currentColumn()==5:
if elma1 == elma + 1:
fatura.pushButton.setFocus()
else:
fatura.tableWidget_2.setCurrentCell(elma + 1, 2)
print elma '''
# dosya açmak için dialog
# fileName =(QtGui.QFileDialog.getOpenFileName(mainWindow,
# u"Düzenlenecek dosyayı seçin", ".", u"Metin dosyaları (*.txt)"))
app.setWindowIcon(QtGui.QIcon('nenra.png'))
mainWindow.pushButton_8.setStyleSheet(
"border-image: url(images/newyork.png) 0 0 0 0 stretch stretch;")
mainWindow.pushButton.setStyleSheet(
"color: black ; background-image: url(images/image.png)")
mainWindow.pushButton_2.setStyleSheet(
"color: black ; background-image: url(images/fatura.png)")
mainWindow.pushButton_3.setStyleSheet(
"color: black ; background-image: url(images/maliyet.png)")
mainWindow.pushButton_4.setStyleSheet(
"color: black ; background-image: url(images/nenra.png)")
mainWindow.pushButton_5.setStyleSheet(
"color: black ; background-image: url(images/nenra.png)")
mainWindow.pushButton_6.setStyleSheet(
"color: black ; background-image: url(images/maliyet.png)")
mainWindow.pushButton_7.setStyleSheet(
"color: black ; background-image: url(images/masraf.png)")
mainWindow.pushButton.clicked.connect(slotpuss)
mainWindow.pushButton_2.clicked.connect(lambda: slotfatura(""))
mainWindow.pushButton_3.clicked.connect(slotmaliyet)
mainWindow.pushButton_4.clicked.connect(slotcari)
mainWindow.pushButton_5.clicked.connect(slotstok)
mainWindow.pushButton_6.clicked.connect(slotkasa)
mainWindow.pushButton_7.clicked.connect(slotmasraf)
mainWindow.actionTediye_Fi_i.triggered.connect(lambda: slotfatura("TED"))
mainWindow.actionSay_m_Fi_i.triggered.connect(lambda: slotfatura("SAY"))
mainWindow.actionStok_Tan_mlama.triggered.connect(
lambda: slottediye("VADE"))
mainWindow.statusbar.showMessage(
u"Namık ERDOĞAN © 2016 v 2021.01 "
u" Bishop Restaurant")
# recete.setWindowModality(Qt.ApplicationModal)
fatura.setWindowModality(Qt.ApplicationModal)
maliyet.setWindowModality(Qt.ApplicationModal)
login.setWindowModality(Qt.ApplicationModal)
rapor.setWindowModality(Qt.ApplicationModal)
stok.setWindowModality(Qt.ApplicationModal)
cari.setWindowModality(Qt.ApplicationModal)
# fatura.keyPressEvent=copyFunction
# fatura.connect(QtGui.QShortcut(QtGui.QKeySequence(Qt.Key_Enter), fatura), QtCore.SIGNAL('activated()'), copyFunction)
# mainWindow.connect(login, QtCore.SIGNAL("acac1(int)"), slotpuss4)
login.acac1.connect(slotpuss4)
# mainWindow.connect(fatura, QtCore.SIGNAL("acac"), slotpuss5)
fatura.acac.connect(slotpuss5)
# mainWindow.connect(cari, QtCore.SIGNAL("fisac"), slotpuss6)
cari.my_signal.connect(slotpuss6)
# mainWindow.setWindowFlags(QtCore.Qt.FramelessWindowHint)
mainWindow.move(13, 10)
# mainWindow.setWindowFlags(QtCore.Qt.FramelessWindowHint)
# mainWindow.raise_()
mainWindow.show()
mainWindow.menubar.setStyleSheet(
" QMenuBar { background-color: orange; } "
"QMenuBar::item { background-color: orange; } ")
mainWindow.setStyleSheet(" background-color: orange;")
# mainWindow.setWindowState(mainWindow.windowState() &
# ~QtCore.Qt.WindowMinimized | QtCore.Qt.WindowActive)
# mainWindow.activateWindow()
login.setWindowFlags(QtCore.Qt.FramelessWindowHint)
login.setStyleSheet("color:red ; background-color: orange;")
login.show()
login.raise_()
return app.exec_()
ac=ac+1
elma="elma"
kesinti="243000000"
#kesinti="1890666868"
print len(data)
satir=3
satir1=1
satir2=1
dur=0.05
ws3 =wb.add_sheet("gelir")
ws4 =wb.add_sheet("gider")
fatura=Fatura()
fatura.goster()
for row in range((len(data)/9)):
for col in range(1,2):
if elma!=data[aa+1]:
elma = data[aa + 1]
dt=data[aa]
fatura.lineEdit.setText('B')
fatura.lineEdit_2.setText(elma)
fatura.dateEdit.setDate(QtCore.QDate(dt.year, dt.month, dt.day))
time.sleep(dur)
def masrafkaydet(self, ):
dur=0.05
fatura = Fatura()
fatura.goster()
fatura.lineEdit.setText('ZZ')
self.dt = self.dateEdit.date().toPyDate()
self.dt = QtCore.QDate.fromString(str(self.dt), 'yyyy-MM-dd')
fatura.dateEdit.setDate(self.dt)
fatura.dateEdit_2.setDate(self.dt)
fatura.lineEdit_3.setText("kasa")
time.sleep(dur)
fatura.slotfatura(0, 0)
time.sleep(dur)
satir=0
onur=0
i = self.tableWidget_2.rowCount()
if i == 0:
return
for item in range(i):
deger10 = self.tableWidget_2.item(item, 0).text()
deger11 = self.led[satir].text()
deger12 = self.led[satir+1].text()
deger13 = self.tableWidget_2.item(item, 2).text()
deger14 = self.tableWidget_2.item(item, 1).text()
# deger14 = u' '.join((str(deger14))).encode('utf-8').strip()
deger13 = self.kontrol(deger13)
if float(deger13)<0:
deger13=float(deger13)*-1
if deger12=="":
print "cari yok"
satir+=2
continue
if deger12=="17":
print "onur"
fatura.lineEdit_3.setText("")
fatura.lineEdit_3.setText(deger11)
time.sleep(dur)
fatura.slotfatura(0, 0)
time.sleep(dur)
fatura.tableWidget_2.setItem(onur, 6, QtGui.QTableWidgetItem(str(deger13)))
fatura.tableWidget_2.setItem(onur,1,QtGui.QTableWidgetItem((deger14)))
fatura.tableWidget_2.setItem(onur,3,QtGui.QTableWidgetItem("0"))
time.sleep(dur)
onur+=1
fatura.slotfaturakaydet()
self.mydbb.cur.execute("""update kasa set muhkod=1 where islemid=%s""",(deger10,))
self.mydbb.conn.commit()
else :
dur = 0.02
self.mydbb.cur.execute("""select cariad from cari where cariid=%s""", (deger12,))
cariadd =self.mydbb.cur.fetchone()
print cariadd[0]
self.mydbb.conn.commit()
fatura1 = Fatura()
fatura1.goster()
fatura1.lineEdit.setText('TED')
self.dt = self.dateEdit.date().toPyDate()
self.dt = QtCore.QDate.fromString(str(self.dt), 'yyyy-MM-dd')
fatura1.dateEdit.setDate(self.dt)
fatura1.dateEdit_2.setDate(self.dt)
fatura1.lineEdit_3.setText(cariadd[0])
time.sleep(dur)
fatura1.slotfatura(0, 0)
time.sleep(dur)
fatura1.lineEdit_3.setText("NAKIT")
time.sleep(dur)
fatura1.slotfatura(0, 0)
time.sleep(dur)
fatura1.tableWidget_2.setItem(0, 6, QtGui.QTableWidgetItem(str(deger13)))
fatura1.tableWidget_2.setItem(0, 1, QtGui.QTableWidgetItem((deger14)))
fatura1.tableWidget_2.setItem(0, 4, QtGui.QTableWidgetItem("-1"))
time.sleep(dur)
fatura1.slotfaturakaydet()
self.mydbb.cur.execute("""update kasa set muhkod=1 where islemid=%s""", (deger10,))
self.mydbb.conn.commit()
satir += 2
fatura.slotfaturakont()
mydb = Myddb()
fname = QtWidgets.QFileDialog.getOpenFileName()
print(fname[0])
openfile = fname[0]
# openfile='/Users/namikerdogan/Downloads/HAVVA AYDIN EYLÜL 2021 SATIŞ FATURALAR.xlsx'
df = pd.ExcelFile(openfile)
print(df)
elma = "elma"
ana = df.parse(skiprows=2, index_col=None, na_values=['NA'])
ana['Tarih'] = pd.to_datetime(ana['Tarih'], dayfirst=True)
satir1 = 1
satir2 = 1
dur = 0.05
fatura = Fatura()
fatura.goster()
print(len(ana.index))
for i in range(len(ana.index)):
print(ana.iloc[i, 0])
if elma != (ana.iloc[i, 0]):
elma = str((ana.iloc[i, 0]))
armut = int(elma.rsplit("N012022")[1])
dt = (ana.iloc[i, 1])
fatura.lineEdit.setText('N03')
fatura.lineEdit_2.setText(str(armut))
fatura.dateEdit.setDate(QtCore.QDate(dt.year, dt.month, dt.day))
time.sleep(dur)
if fatura.label_5.text() == "":