def cins_yaz(self): self.yaz = VbagKur() ad = self.lineEdit.text() if ad == "": mesaj = "Lütfen bir gemi türü giriniz !!" mes.uyari(mesaj, "Bilgi Giriş Hatası") else: self.yaz.isle("INSERT INTO gemitur VALUES(NULL, '{}')".format(ad)) mesaj = ad + " türü veritabanına eklendi" mes.uyari(mesaj, "Kayıt Eklendi") self.lineEdit.clear()
def setupUi(self, UzlastirmaciEkle): self.db = VbagKur() UzlastirmaciEkle.setObjectName("UzlastirmaciEkle") UzlastirmaciEkle.resize(441, 257) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap("lib/icon/credentials-preferences.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) UzlastirmaciEkle.setWindowIcon(icon) self.label = QtWidgets.QLabel(UzlastirmaciEkle) self.label.setGeometry(QtCore.QRect(160, 10, 90, 20)) self.label.setObjectName("label") self.lineEdit = QtWidgets.QLineEdit(UzlastirmaciEkle) self.lineEdit.setGeometry(QtCore.QRect(220, 10, 211, 20)) self.lineEdit.setObjectName("lineEdit") self.lineEdit_2 = QtWidgets.QLineEdit(UzlastirmaciEkle) self.lineEdit_2.setGeometry(QtCore.QRect(220, 40, 211, 20)) self.lineEdit_2.setObjectName("lineEdit_2") self.label_2 = QtWidgets.QLabel(UzlastirmaciEkle) self.label_2.setGeometry(QtCore.QRect(160, 40, 90, 20)) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(UzlastirmaciEkle) self.label_3.setGeometry(QtCore.QRect(160, 70, 90, 20)) self.label_3.setObjectName("label_3") self.lineEdit_3 = QtWidgets.QLineEdit(UzlastirmaciEkle) self.lineEdit_3.setGeometry(QtCore.QRect(220, 70, 211, 20)) self.lineEdit_3.setObjectName("lineEdit_3") self.lineEdit_4 = QtWidgets.QLineEdit(UzlastirmaciEkle) self.lineEdit_4.setGeometry(QtCore.QRect(220, 100, 211, 20)) self.lineEdit_4.setObjectName("lineEdit_4") self.label_4 = QtWidgets.QLabel(UzlastirmaciEkle) self.label_4.setGeometry(QtCore.QRect(160, 100, 90, 20)) self.label_4.setObjectName("label_4") self.label_5 = QtWidgets.QLabel(UzlastirmaciEkle) self.label_5.setGeometry(QtCore.QRect(160, 130, 90, 20)) self.label_5.setObjectName("label_5") self.textEdit = QtWidgets.QTextEdit(UzlastirmaciEkle) self.textEdit.setGeometry(QtCore.QRect(220, 130, 211, 81)) self.textEdit.setObjectName("textEdit") self.pushButton = QtWidgets.QPushButton(UzlastirmaciEkle) self.pushButton.setGeometry(QtCore.QRect(360, 220, 75, 23)) self.pushButton.setObjectName("pushButton") self.label_6 = QtWidgets.QLabel(UzlastirmaciEkle) self.label_6.setGeometry(QtCore.QRect(20, 30, 121, 121)) self.label_6.setText("") self.label_6.setPixmap( QtGui.QPixmap("lib/icon/credentials-preferences.png")) self.label_6.setObjectName("label_6") self.retranslateUi(UzlastirmaciEkle) self.pushButton.clicked.connect(self.uz_ekle) QtCore.QMetaObject.connectSlotsByName(UzlastirmaciEkle)
def setupUi(self, SablonDuzenle): self.sablon_id = None self.db = VbagKur() SablonDuzenle.setObjectName("SablonDuzenle") SablonDuzenle.resize(561, 408) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/newPrefix/lib/icon/gnome-contacts.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) SablonDuzenle.setWindowIcon(icon) self.gridLayout = QtWidgets.QGridLayout(SablonDuzenle) self.gridLayout.setObjectName("gridLayout") self.label = QtWidgets.QLabel(SablonDuzenle) self.label.setObjectName("label") self.gridLayout.addWidget(self.label, 0, 0, 1, 1) self.label_3 = QtWidgets.QLabel(SablonDuzenle) self.label_3.setObjectName("label_3") self.gridLayout.addWidget(self.label_3, 0, 1, 1, 1) self.listWidget = QtWidgets.QListWidget(SablonDuzenle) self.listWidget.setMinimumSize(QtCore.QSize(200, 0)) self.listWidget.setMaximumSize(QtCore.QSize(200, 16777215)) self.listWidget.setObjectName("listWidget") self.gridLayout.addWidget(self.listWidget, 1, 0, 3, 1) self.lineEdit = QtWidgets.QLineEdit(SablonDuzenle) self.lineEdit.setObjectName("lineEdit") self.gridLayout.addWidget(self.lineEdit, 1, 1, 1, 3) self.label_2 = QtWidgets.QLabel(SablonDuzenle) self.label_2.setObjectName("label_2") self.gridLayout.addWidget(self.label_2, 2, 1, 1, 1) self.textEdit = QtWidgets.QTextEdit(SablonDuzenle) self.textEdit.setObjectName("textEdit") self.gridLayout.addWidget(self.textEdit, 3, 1, 1, 3) spacerItem = QtWidgets.QSpacerItem(509, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum) self.gridLayout.addItem(spacerItem, 4, 0, 1, 2) self.pushButton = QtWidgets.QPushButton(SablonDuzenle) self.pushButton.setObjectName("pushButton") self.gridLayout.addWidget(self.pushButton, 4, 2, 1, 1) self.pushButton_2 = QtWidgets.QPushButton(SablonDuzenle) self.pushButton_2.setObjectName("pushButton_2") self.gridLayout.addWidget(self.pushButton_2, 4, 3, 1, 1) self.retranslateUi(SablonDuzenle) self.pushButton.clicked.connect(self.sablon_sil) self.pushButton_2.clicked.connect(self.sablon_guncelle) self.listWidget.itemDoubleClicked['QListWidgetItem*'].connect(self.hazirlik_bitir) self.hazirlik() QtCore.QMetaObject.connectSlotsByName(SablonDuzenle)
def setupUi(self, UzlasmaciSil): self.db = VbagKur() UzlasmaciSil.setObjectName("UzlasmaciSil") UzlasmaciSil.resize(525, 389) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap("lib/icon/credentials-preferences.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) UzlasmaciSil.setWindowIcon(icon) self.gridLayout = QtWidgets.QGridLayout(UzlasmaciSil) self.gridLayout.setObjectName("gridLayout") self.verticalLayout = QtWidgets.QVBoxLayout() self.verticalLayout.setObjectName("verticalLayout") self.tableWidget = QtWidgets.QTableWidget(UzlasmaciSil) self.tableWidget.setObjectName("tableWidget") self.tableWidget.setColumnCount(5) self.tableWidget.setRowCount(0) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(0, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(1, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(2, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(3, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(4, item) self.tableWidget.verticalHeader().setVisible(False) self.verticalLayout.addWidget(self.tableWidget) self.horizontalLayout_4 = QtWidgets.QHBoxLayout() self.horizontalLayout_4.setObjectName("horizontalLayout_4") spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum) self.horizontalLayout_4.addItem(spacerItem) self.pushButton = QtWidgets.QPushButton(UzlasmaciSil) self.pushButton.setEnabled(False) self.pushButton.setObjectName("pushButton") self.pushButton.setWhatsThis("Etkin olması için listeden bir uzlaştırmacı seçin") self.horizontalLayout_4.addWidget(self.pushButton) self.verticalLayout.addLayout(self.horizontalLayout_4) self.gridLayout.addLayout(self.verticalLayout, 0, 0, 1, 1) self.uzlasmaci_tarama() self.tableWidget.cellClicked.connect(self.parametre_olustur) self.pushButton.clicked.connect(self.sil) self.retranslateUi(UzlasmaciSil) QtCore.QMetaObject.connectSlotsByName(UzlasmaciSil)
def setupUi(self, SablonEkle): self.db = VbagKur() SablonEkle.setObjectName("SablonEkle") SablonEkle.resize(541, 305) icon = QtGui.QIcon() icon.addPixmap( QtGui.QPixmap(":/newPrefix/lib/icon/gnome-contacts.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) SablonEkle.setWindowIcon(icon) self.gridLayout = QtWidgets.QGridLayout(SablonEkle) self.gridLayout.setObjectName("gridLayout") self.label = QtWidgets.QLabel(SablonEkle) self.label.setMinimumSize(QtCore.QSize(90, 0)) self.label.setMaximumSize(QtCore.QSize(90, 16777215)) self.label.setObjectName("label") self.gridLayout.addWidget(self.label, 0, 0, 1, 1) self.lineEdit = QtWidgets.QLineEdit(SablonEkle) self.lineEdit.setObjectName("lineEdit") self.gridLayout.addWidget(self.lineEdit, 0, 1, 1, 2) self.label_2 = QtWidgets.QLabel(SablonEkle) self.label_2.setMinimumSize(QtCore.QSize(90, 0)) self.label_2.setMaximumSize(QtCore.QSize(90, 16777215)) self.label_2.setObjectName("label_2") self.gridLayout.addWidget(self.label_2, 1, 0, 1, 1) self.textEdit = QtWidgets.QTextEdit(SablonEkle) self.textEdit.setObjectName("textEdit") self.gridLayout.addWidget(self.textEdit, 1, 1, 2, 2) spacerItem = QtWidgets.QSpacerItem(20, 210, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding) self.gridLayout.addItem(spacerItem, 2, 0, 1, 1) spacerItem1 = QtWidgets.QSpacerItem(393, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum) self.gridLayout.addItem(spacerItem1, 3, 0, 1, 2) self.pushButton = QtWidgets.QPushButton(SablonEkle) self.pushButton.setObjectName("pushButton") self.gridLayout.addWidget(self.pushButton, 3, 2, 1, 1) self.retranslateUi(SablonEkle) self.pushButton.clicked.connect(self.sablon_ekle) QtCore.QMetaObject.connectSlotsByName(SablonEkle)
def setupUi(self, Settings): self.db = VbagKur() Settings.setObjectName("Settings") Settings.resize(578, 220) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/newPrefix/lib/icon/application-default-icon.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) Settings.setWindowIcon(icon) self.label = QtWidgets.QLabel(Settings) self.label.setGeometry(QtCore.QRect(10, 10, 141, 20)) self.label.setObjectName("label") self.lineEdit = QtWidgets.QLineEdit(Settings) self.lineEdit.setGeometry(QtCore.QRect(160, 10, 351, 20)) self.lineEdit.setObjectName("lineEdit") self.pushButton = QtWidgets.QPushButton(Settings) self.pushButton.setGeometry(QtCore.QRect(520, 10, 51, 23)) self.pushButton.setObjectName("pushButton") self.label_2 = QtWidgets.QLabel(Settings) self.label_2.setGeometry(QtCore.QRect(10, 40, 141, 20)) self.label_2.setObjectName("label_2") self.lineEdit_2 = QtWidgets.QLineEdit(Settings) self.lineEdit_2.setGeometry(QtCore.QRect(160, 40, 411, 20)) self.lineEdit_2.setObjectName("lineEdit_2") self.label_3 = QtWidgets.QLabel(Settings) self.label_3.setGeometry(QtCore.QRect(10, 70, 141, 20)) self.label_3.setObjectName("label_3") self.lineEdit_3 = QtWidgets.QLineEdit(Settings) self.lineEdit_3.setGeometry(QtCore.QRect(160, 70, 411, 20)) self.lineEdit_3.setObjectName("lineEdit_3") self.pushButton_2 = QtWidgets.QPushButton(Settings) self.pushButton_2.setGeometry(QtCore.QRect(450, 100, 121, 23)) self.pushButton_2.setObjectName("pushButton_2") self.lineEdit.setReadOnly(True) self.veritabani_bilgisi_cek() self.retranslateUi(Settings) self.pushButton.clicked.connect(self.dosya_kayit_yeri) self.pushButton_2.clicked.connect(self.bilgi_guncelle) QtCore.QMetaObject.connectSlotsByName(Settings)
# -*- coding: utf-8 -*- from PyQt5 import QtCore, QtGui, QtWidgets from vtbgln import VbagKur import math, time, os from shutil import copy2 import xlwings as xw t = time.strftime("%d %m %Y") tar = t.replace(" ", ".") yaz = VbagKur() def gemi_listele(arg): return yaz.veri_duzenle(yaz.hepsini_oku("gad", "gemiler", "kod", arg)) def yogunluk_listele(arg): return yaz.veri_duzenle(yaz.hepsini_oku("kesafet", "densitys", "tur", arg)) def v_c_f(density, brut, sicaklik): if len(brut) == 3: sonuc_liste = [] deger = (float(density) * 2000) / 2 if int(deger) >= 839 & int(deger) <= 1075: sonuc = 186.9696 / (math.pow(deger, 2)) + 0.4862 / deger elif int(deger) >= 788 & (deger) <= 838.5: sonuc = 594.5418 / (math.pow(deger, 2)) elif int(deger) >= 770.5 & int(deger) <= 787.5:
def __init__(self): self.yaz = VbagKur() self.change_id = 0
def init_ui(self): self.db = VbagKur() self.resize(423, 263) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/newPrefix/lib/icon/ubuntuone.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) self.setWindowIcon(icon) self.radioButton = QtWidgets.QRadioButton(self) self.radioButton.setGeometry(QtCore.QRect(240, 10, 82, 17)) self.radioButton.setObjectName("radioButton") self.radioButton_2 = QtWidgets.QRadioButton(self) self.radioButton_2.setGeometry(QtCore.QRect(330, 10, 82, 17)) self.radioButton_2.setObjectName("radioButton_2") self.label = QtWidgets.QLabel(self) self.label.setGeometry(QtCore.QRect(130, 40, 90, 20)) self.label.setObjectName("label") self.lineEdit = QtWidgets.QLineEdit(self) self.lineEdit.setGeometry(QtCore.QRect(240, 40, 170, 20)) self.lineEdit.setObjectName("lineEdit") self.lineEdit_2 = QtWidgets.QLineEdit(self) self.lineEdit_2.setGeometry(QtCore.QRect(240, 70, 170, 20)) self.lineEdit_2.setObjectName("lineEdit_2") self.label_2 = QtWidgets.QLabel(self) self.label_2.setGeometry(QtCore.QRect(130, 70, 90, 20)) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(self) self.label_3.setGeometry(QtCore.QRect(130, 100, 90, 20)) self.label_3.setObjectName("label_3") self.lineEdit_3 = QtWidgets.QLineEdit(self) self.lineEdit_3.setGeometry(QtCore.QRect(240, 100, 170, 20)) self.lineEdit_3.setObjectName("lineEdit_3") self.lineEdit_4 = QtWidgets.QLineEdit(self) self.lineEdit_4.setGeometry(QtCore.QRect(240, 130, 170, 20)) self.lineEdit_4.setObjectName("lineEdit_4") self.label_5 = QtWidgets.QLabel(self) self.label_5.setGeometry(QtCore.QRect(130, 130, 90, 20)) self.label_5.setObjectName("label_5") self.lineEdit_5 = QtWidgets.QLineEdit(self) self.lineEdit_5.setGeometry(QtCore.QRect(240, 160, 170, 20)) self.lineEdit_5.setObjectName("lineEdit_5") self.label_7 = QtWidgets.QLabel(self) self.label_7.setGeometry(QtCore.QRect(130, 160, 90, 20)) self.label_7.setObjectName("label_7") self.label_4 = QtWidgets.QLabel(self) self.label_4.setGeometry(QtCore.QRect(130, 10, 90, 20)) self.label_4.setObjectName("label_4") self.label_8 = QtWidgets.QLabel(self) self.label_8.setGeometry(QtCore.QRect(130, 190, 90, 20)) self.label_8.setObjectName("label_8") self.comboBox = QtWidgets.QComboBox(self) self.comboBox.setGeometry(QtCore.QRect(239, 190, 171, 22)) self.comboBox.setObjectName("comboBox") self.frame = QtWidgets.QFrame(self) self.frame.setGeometry(QtCore.QRect(-11, 0, 141, 381)) self.frame.setFrameShape(QtWidgets.QFrame.NoFrame) self.frame.setFrameShadow(QtWidgets.QFrame.Raised) self.frame.setObjectName("frame") self.label_6 = QtWidgets.QLabel(self.frame) self.label_6.setGeometry(QtCore.QRect(30, 50, 121, 121)) self.label_6.setText("") self.label_6.setPixmap( QtGui.QPixmap(":/newPrefix/lib/icon/ubuntuone.png")) self.label_6.setObjectName("label_6") self.pushButton = QtWidgets.QPushButton(self) self.pushButton.setGeometry(QtCore.QRect(336, 230, 75, 23)) self.pushButton.setObjectName("pushButton") self.radioButton.setChecked(True) self.retranslateUi(self) self.pushButton.clicked.connect(self.close) QtCore.QMetaObject.connectSlotsByName(self) self.pushButton.clicked.connect(self.buton_birinci_gorev) self.setWindowTitle("Yeni Uzlaşma Dosyası Ekle") self.uzlastirmaci_cek() self.show()
def __init__(self): self.yaz = VbagKur()
from builtins import FileExistsError from vtbgln import VbagKur import datetime import math, time, os from shutil import copy2 import xlwings as xw from docx import Document from docx.enum.text import WD_ALIGN_PARAGRAPH from docx.shared import Inches, Pt, RGBColor from docx.enum.table import WD_ALIGN_VERTICAL from PyQt5 import QtWidgets import sys db = VbagKur() def kolon_tara(sutun, tablo): sor = db.kolon_oku(sutun, tablo) return sor def dosya_durumu_tara(dosya): arg = db.hepsini_oku("durum", "dosyalar", "uzno", dosya) if arg[0][0] == 0: return ("Dosya Oluşturuldu.") elif arg[0][0] == 1: return ("Uzlaşma aşamasında") elif arg[0][0] == 4: return ("Uzlaşma sonlandı")
def __init__(self): super(Ui_BolgeYerSil, self).__init__() self.yaz = VbagKur() self.setupUi()
def __init__(self): super(TarafDuzenle, self).__init__() self.db = VbagKur()
def initui(self): self.dosya_id = None self.dosya_ad = None self.db = VbagKur() self.setObjectName("DosyaSil") icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/newPrefix/lib/icon/ubuntuone.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) self.setWindowIcon(icon) self.resize(721, 336) self.gridLayout = QtWidgets.QGridLayout(self) self.gridLayout.setObjectName("gridLayout") self.verticalLayout_3 = QtWidgets.QVBoxLayout() self.verticalLayout_3.setObjectName("verticalLayout_3") self.tableWidget = QtWidgets.QTableWidget(self) self.tableWidget.setObjectName("tableWidget") self.tableWidget.setColumnCount(9) self.tableWidget.setRowCount(0) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(0, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(1, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(2, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(3, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(4, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(5, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(6, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(7, item) item = QtWidgets.QTableWidgetItem() self.tableWidget.setHorizontalHeaderItem(8, item) self.verticalLayout_3.addWidget(self.tableWidget) self.gridLayout.addLayout(self.verticalLayout_3, 1, 0, 1, 4) self.label = QtWidgets.QLabel(self) self.label.setObjectName("label") self.gridLayout.addWidget(self.label, 0, 0, 1, 1) spacerItem = QtWidgets.QSpacerItem(443, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum) self.gridLayout.addItem(spacerItem, 0, 3, 1, 1) self.comboBox = QtWidgets.QComboBox(self) self.comboBox.setObjectName("comboBox") self.comboBox.addItem("") self.comboBox.addItem("") self.comboBox.addItem("") self.comboBox.setItemText(3, "") self.gridLayout.addWidget(self.comboBox, 0, 1, 1, 1) self.horizontalLayout_2 = QtWidgets.QHBoxLayout() self.horizontalLayout_2.setObjectName("horizontalLayout_2") spacerItem1 = QtWidgets.QSpacerItem(82, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum) self.horizontalLayout_2.addItem(spacerItem1) self.pushButton = QtWidgets.QPushButton(self) self.pushButton.setMaximumSize(QtCore.QSize(100, 16777215)) self.pushButton.setAcceptDrops(True) self.pushButton.setObjectName("pushButton") self.horizontalLayout_2.addWidget(self.pushButton) self.gridLayout.addLayout(self.horizontalLayout_2, 2, 3, 1, 1) self.tableWidget.cellClicked.connect(self.dosya_bul) self.comboBox.currentIndexChanged.connect(self.adana) self.pushButton.setDisabled(True) self.pushButton.clicked.connect(self.sil) self.tum_dosyalar() self.retranslateUi(self) QtCore.QMetaObject.connectSlotsByName(self)
def __init__(self): super(Ui_UrunEkle, self).__init__() self.setupUi() self.yaz = VbagKur()
def __init__(self): super(Ekler, self).__init__() self.db = VbagKur()
def __init__(self): super(Ui_PersonelSil, self).__init__() self.yaz = VbagKur() self.setupUi()
def __init__(self): super(Ui_YogunlukGuncelle, self).__init__() self.yaz = VbagKur() self.change_id_no = 0 self.setupUi()