class Application(object): def __init__(self): self.window = None self.connection = None self._init_window() self._init_connection() GObject.idle_add(self.send_data_to_gtk_thread) #GObject.idle_add(self.retrieve_data_from_gtk) def _init_window(self): self.window = MainWindow() self.window.connect('delete-event', self.quit) def _init_connection(self): self.connection = GtalkConnection() self.connection.start_connection() def send_data_to_gtk_thread(self): data = { 'roster': '', 'messages': [], } if self.connection.roster_changed and self.connection.roster != '': print("Updating roster") data["roster"] = self.connection.roster if self.connection.has_new_messages: print("adding messages") data["messages"] = self.connection.msg_queue if dict_have_data(data): self.window.parse_new_data(data) self.connection.reset_data() return True def retrieve_data_from_gtk(self): to, client_data = self.window.get_send_data() if client_data != None: for msg in client_data: print("sending msg",msg) self.connection.send_msg_to(to, msg) return False def quit(self, widget, event): print("Exiting.. waiting disconnect form server") self.connection.stop_connection() Gtk.main_quit()
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 main(): app =QApplication(sys.argv) app.processEvents() mainWindow = MainWindow() mmdb=Mmdb() simulRunner = SimulRunner() simulRunner1 = SimulRunner1() simulThread = QThread() simulThread1 = QThread() myddb=Myddb() bilgi=mmdb.cek() i=len(bilgi) j=56 mainWindow.tableWidget.setRowCount(i) mainWindow.tableWidget.setColumnCount(j) mainWindow.tableWidget.setColumnWidth( 0, 200 ) aa=0 toplam=0 for row1 in bilgi: for aaa in range(len(row1)): try: item = row1[aaa] mainWindow.tableWidget.setItem(aa, aaa, QtGui.QTableWidgetItem(item)) except TypeError: item = " " mainWindow.tableWidget.setItem(aa, aaa, QtGui.QTableWidgetItem(item)) aa=aa+1 def kontrol(girdi): girdi = str(girdi) ara = re.search(",", girdi) if ara: derle = re.compile(",") cikti = derle.sub(".",girdi) return cikti return girdi @pyqtSlot(int,int) def slotItemClicked(item,item2): print "Row: "+str(item)+" |Column: "+QString.number(item2) mainWindow.tableWidget.horizontalHeaderItem(0).setText(str(item)+" "+str(item2)) QMessageBox.information(mainWindow.tableWidget, "QTableWidget Cell Click", "Text: "+str(toplam)) @pyqtSlot(int,int) def slotrecete2(item,item2): # recete2 ekranı hazırlanıyor deger0=recete.tableWidget.item(item,0).text() recete2.label_3.setText(deger0) deger=recete.tableWidget.item(item,1).text() deger1=deger+" "+recete.tableWidget.item(item,2).text()+" " recete2.label.setText(deger1) # veritabanından bilgi çek bul2=myddb.cek2(deger0,"recete","menuid") i=len(bul2) j=5 recete2.tableWidget_2.setRowCount(i) aa=0 toplam=0 for row1 in bul2: item=str(row1[2]) recete2.tableWidget_2.setItem(aa, 0, QtGui.QTableWidgetItem(item)) bul3=myddb.cek2(item,"hammadde","hammaddeid") item=str(bul3[0][1]) recete2.tableWidget_2.setItem(aa, 1, QtGui.QTableWidgetItem(item)) item=bul3[0][2] recete2.tableWidget_2.setItem(aa, 2, QtGui.QTableWidgetItem(item)) item=bul3[0][3] recete2.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item=str(row1[3]) recete2.tableWidget_2.setItem(aa, 4, QtGui.QTableWidgetItem(item)) aa=aa+1 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) aa=0 toplam=0 for row1 in bul: item=str(row1[0]) recete2.tableWidget.setItem(aa, 0, QtGui.QTableWidgetItem(item)) item=str(row1[1]) recete2.tableWidget.setItem(aa, 1, QtGui.QTableWidgetItem(item)) item=row1[2] recete2.tableWidget.setItem(aa, 2, QtGui.QTableWidgetItem(item)) item=str(row1[3]) recete2.tableWidget.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item=str(row1[4]) recete2.tableWidget.setItem(aa, 4, 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() deger4=recete2.tableWidget.item(item,3).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=deger4 recete2.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item='0' recete2.tableWidget_2.setItem(aa, 4, QtGui.QTableWidgetItem(item)) recete2.lineEdit.setFocus(True) @pyqtSlot() def slotfaturakont(item2): deger5=fatura.lineEdit.text() deger6=fatura.lineEdit_2.text() sql="select * from carihar where serino='"+str(deger5)+"' and sirano='"+str(deger6)+"'" sonuc=myddb.cek(sql) fatura.label_3.setText("") fatura.tableWidget.setRowCount(0) fatura.tableWidget_2.setRowCount(0) # some_date = QtCore.QDate(2011,4,22) some_date = QtCore.QDate.currentDate() fatura.dateEdit.setDate(some_date) if len(sonuc)>0 : dt=sonuc[0][4] QMessageBox.information(fatura.tableWidget, "QTableWidget Cell Click", "Text: "+str(dt.year)) print sonuc for item in sonuc: fatura.dateEdit.setDate(QtCore.QDate(dt.year,dt.month,dt.day)) sonuc1=myddb.cek2(item[1],"cari","cariid") for item2 in sonuc1: deger0=str(item2[0])+" "+item2[1]+" "+item2[2] fatura.label_3.setText(deger0) bul1=str(item[0]) bul2=myddb.cek2(item[0],"cariay","chid") print bul2 i=len(bul2) j=6 fatura.tableWidget_2.setRowCount(i) aa=0 toplam=0 for row1 in bul2: item=str(row1[2]) fatura.tableWidget_2.setItem(aa, 0, QtGui.QTableWidgetItem(item)) bul3=myddb.cek2(item,"hammadde","hammaddeid") item=str(bul3[0][2]) fatura.tableWidget_2.setItem(aa, 1, QtGui.QTableWidgetItem(item)) item=bul3[0][3] fatura.tableWidget_2.setItem(aa, 2, QtGui.QTableWidgetItem(item)) item=str(row1[5]) fatura.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item=str(row1[3]) fatura.tableWidget_2.setItem(aa, 4, QtGui.QTableWidgetItem(item)) item=str(row1[4]) fatura.tableWidget_2.setItem(aa, 5, QtGui.QTableWidgetItem(item)) aa=aa+1 fatura.lineEdit_3.setFocus(True) return @pyqtSlot(int,int) def slotfatura(item,item2): # cari listesinden çiftklikle line edite cari firma bilgisini yazıyor if len(fatura.label_3.text())<12 : deger1=fatura.tableWidget.item(item,0).text() deger2=fatura.tableWidget.item(item,1).text() deger3=fatura.tableWidget.item(item,2).text() deger4=fatura.tableWidget.item(item,3).text() fatura.label_5.setText(deger1) fatura.label_3.setText(deger1+" "+deger2+" "+deger3) bul1=str(deger1) fatura.lineEdit_3.setText("") slotfaturakaydet() return if len(fatura.label_3.text())>12 : # hammadde listesinden çiftklikle tablewidget_2 ye hammadde bilgisini ekliyor. i=fatura.tableWidget_2.rowCount() deger1=fatura.tableWidget.item(item,0).text() deger2=fatura.tableWidget.item(item,2).text() deger3=fatura.tableWidget.item(item,3).text() deger4=fatura.tableWidget.item(item,4).text() i=i+1 j=5 fatura.tableWidget_2.setRowCount(i) aa=i-1 item=deger1 fatura.tableWidget_2.setItem(aa, 0, QtGui.QTableWidgetItem(item)) item=deger2 fatura.tableWidget_2.setItem(aa, 1, QtGui.QTableWidgetItem(item)) item=deger3 fatura.tableWidget_2.setItem(aa, 2, QtGui.QTableWidgetItem(item)) item=deger4 fatura.tableWidget_2.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item='0' fatura.tableWidget_2.setItem(aa, 4, QtGui.QTableWidgetItem(item)) fatura.lineEdit_3.setFocus(True) @pyqtSlot() def slotrecete2kaydet(): deger0=recete2.label_3.text() myddb.sil(deger0,"recete","menuid") i=recete2.tableWidget_2.rowCount() for item in range(i): deger1=recete2.tableWidget_2.item(item,0).text() deger2=recete2.tableWidget_2.item(item,4).text() print deger0 , deger1 , deger2 deger2=kontrol(deger2) myddb.kaydet(deger0,deger1,deger2) myddb.conn.commit() @pyqtSlot() def slotfaturakaydet(): deger0=fatura.label_5.text() deger5=fatura.lineEdit.text() deger6=fatura.lineEdit_2.text() deger7=fatura.dateEdit.date().toPyDate() sql="select * from carihar where serino='"+str(deger5)+"' and sirano='"+str(deger6)+"'" sonuc=myddb.cek(sql) print sonuc if len(sonuc)==0: print "fatura kaydı yok" sql1="insert into carihar (cariid,serino,sirano,tarih) values (%s,%s,%s,%s)" print sql1 myddb.cur.execute(sql1,(deger0,deger5,deger6,deger7)) myddb.conn.commit() else: print " fatura kaydı var" myddb.sil(sonuc[0][0],"cariay","chid") i=fatura.tableWidget_2.rowCount() for item in range(i): deger10=fatura.tableWidget_2.item(item,0).text() deger11=fatura.tableWidget_2.item(item,3).text() deger12=fatura.tableWidget_2.item(item,4).text() deger13=fatura.tableWidget_2.item(item,5).text() deger13=kontrol(deger13) print deger10 sql2="insert into cariay (chid,hammaddeid,kdv,miktar,birimfiy) values (%s,%s,%s,%s,%s)" myddb.cur.execute(sql2,(sonuc[0][0],deger10,deger11,deger12,deger13)) myddb.conn.commit() fatura.lineEdit_3.setFocus(True) # veritabanından bilgi çek def yaz(elmaci): mainWindow.plainTextEdit.appendPlainText(elmaci+" kaydediliyor") @pyqtSlot() def slotpuss(item2): StartDate="31/12/13" EndDate = datetime.datetime.strptime(StartDate, "%d/%m/%y") now = datetime.datetime.now()- datetime.timedelta(days=1) dt=now-EndDate print dt.days mainWindow.plainTextEdit.appendPlainText(str(dt.days)) for i in range(dt.days): EndDate = EndDate + datetime.timedelta(days=1) sql= " select * from satdata where tarih like %s" sonuc=myddb.cur.execute(sql,(EndDate.strftime('%Y-%m-%d')+"%")) if sonuc==0: print " kaydediliyor" tar=EndDate.strftime('%d%m%Y') mainWindow.plainTextEdit.appendPlainText(str(tar)+"kaydediliyor") mainWindow.label_2.setText(mainWindow.label_2.text()+str(tar)) bilgi=mmdb.cekmysql(tar,"satdata") if bilgi!=1978: for row1 in bilgi: sql1="insert into satdata (masaad,konumkod,urunkod,urungrup,yiyic,adisyon,kasiyerkod,kasiyerad,kuver,ikram,fixim,konumad,kdv,saat,tarih,adet,fixmenu,tutarx,tutar) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)" myddb.cur.execute(sql1,(row1[1],row1[2],row1[3],row1[4],row1[5],row1[6],row1[7],row1[8],row1[10],row1[18],row1[19],row1[29],row1[32],row1[39],EndDate,row1[41],row1[45],row1[46],row1[47])) myddb.conn.commit() else: mainWindow.plainTextEdit.appendPlainText(tar+" DOSYASI MEVCUT DEGIL!!!. GUNSONU ALINMAMIS OLABILIR") print EndDate.strftime('%d%m%Y') @pyqtSlot() def slotpuss2(item2): StartDate="31/12/13" EndDate = datetime.datetime.strptime(StartDate, "%d/%m/%y") now = datetime.datetime.now()- datetime.timedelta(days=1) dt=now-EndDate print dt.days mainWindow.plainTextEdit.appendPlainText(str(dt.days)) for i in range(dt.days): EndDate = EndDate + datetime.timedelta(days=1) sql= " select * from satodeme where odetar like %s" sonuc=myddb.cur.execute(sql,(EndDate.strftime('%Y-%m-%d')+"%")) if sonuc==0: print " kaydediliyor" tar=EndDate.strftime('%d%m%Y') mainWindow.plainTextEdit.appendPlainText(str(tar)+"kaydediliyor") bilgi=mmdb.cekmysql(tar,"satodeme") if bilgi!=1978: for row1 in bilgi: sql1="insert into satodeme (odemasaad,odeadisyon,odesekli,odecarikod,odekasiyerkod,odekasiyerad,odead,odecariad,indirimoran,odetip,odetutar,odesaat,odetarih,odetar,odecaritip) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)" myddb.cur.execute(sql1,(row1[1],row1[2],row1[4],row1[5],row1[6],row1[7],row1[8],row1[9],row1[13],row1[14],row1[15],row1[17],row1[21],EndDate,row1[23])) myddb.conn.commit() else: mainWindow.plainTextEdit.appendPlainText(tar+" DOSYASI MEVCUT DEGIL!!!. GUNSONU ALINMAMIS OLABILIR") print EndDate.strftime('%d%m%Y') @pyqtSlot() def slottextch2(item2): print "fatura" a=item2.toUtf8() a=str(a) print a bul=myddb.cek1(a,"cari","cariad") if len(fatura.label_3.text())>12 : bul=myddb.cek1(a,"hammadde","hamad") i=len(bul) j=5 fatura.tableWidget.setRowCount(i) aa=0 toplam=0 for row1 in bul: item=str(row1[0]) fatura.tableWidget.setItem(aa, 0, QtGui.QTableWidgetItem(item)) item=str(row1[1]) fatura.tableWidget.setItem(aa, 1, QtGui.QTableWidgetItem(item)) item=row1[2] fatura.tableWidget.setItem(aa, 2, QtGui.QTableWidgetItem(item)) item=str(row1[3]) fatura.tableWidget.setItem(aa, 3, QtGui.QTableWidgetItem(item)) item=str(row1[5]) fatura.tableWidget.setItem(aa, 4, QtGui.QTableWidgetItem(item)) aa=aa+1 @pyqtSlot() def copyFunction(): print "f10 a bastın" abc = QKeyEvent ( QEvent.KeyPress, Qt.Key_Tab, Qt.NoModifier) QCoreApplication.postEvent (mainWindow, abc) mainWindow.pushButton.setStyleSheet("color: black ; background-image: url(image.png)") mainWindow.pushButton_2.setStyleSheet("color: black ; background-image: url(fatura.png)") mainWindow.tableWidget.cellClicked.connect(slotItemClicked) mainWindow.pushButton.clicked.connect(simulThread.start) mainWindow.pushButton_2.clicked.connect(simulThread1.start) simulRunner.moveToThread(simulThread) simulRunner1.moveToThread(simulThread1) simulRunner.stepIncreased.connect(mainWindow.plainTextEdit.appendPlainText) simulRunner1.stepIncreased.connect(mainWindow.plainTextEdit.appendPlainText) # start the execution loop with the thread: simulThread.started.connect(simulRunner.longRunning) simulThread1.started.connect(simulRunner1.longRunning) sh = QtGui.QShortcut(mainWindow) sh.setKey(Qt.Key_Enter) mainWindow.connect(sh, QtCore.SIGNAL("activated()"), copyFunction) mainWindow.show() return app.exec_()