def __init__(self, parent=None):
super().__init__(parent)
self.icons = Icons()
grid = QGridLayout()
base = QWidget()
base.setLayout(grid)
but = QPushButton('OK')
layout = QVBoxLayout()
layout.addWidget(base)
layout.addWidget(but)
self.setLayout(layout)
# click
but.clicked.connect(self.closeEvent)
row = 0
lab_app_name = QLabel(parent.APP_NAME)
lab_app_name.setStyleSheet("QLabel {font-size:14pt; padding: 0 2px;}")
grid.addWidget(lab_app_name, row, 0, 1, 2)
row += 1
lab_app_ver1 = QLabel('VERSION')
lab_app_ver1.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
lab_app_ver2 = QLabel(parent.APP_VER)
lab_app_ver2.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
grid.addWidget(lab_app_ver1, row, 0)
grid.addWidget(lab_app_ver2, row, 1)
row += 1
lab_app_copyright1 = QLabel('COPYRIGHT')
lab_app_copyright1.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_app_copyright2 = QLabel(parent.APP_COPYRIGHT)
lab_app_copyright2.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
grid.addWidget(lab_app_copyright1, row, 0)
grid.addWidget(lab_app_copyright2, row, 1)
row += 1
lab_app_license1 = QLabel('LICENSE')
lab_app_license1.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_app_license2 = QLabel(parent.APP_LICENSE)
lab_app_license2.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_app_license2.setOpenExternalLinks(True)
grid.addWidget(lab_app_license1, row, 0)
grid.addWidget(lab_app_license2, row, 1)
row += 1
self.setWindowIcon(QIcon(self.icons.INFO))
self.show()
def __init__(self):
super().__init__()
self.icons = Icons()
# CONFIGURATION FILE READ
self.config = configparser.ConfigParser()
self.config.read(self.confFile, 'UTF-8')
# INITIALIZE
self.initDB()
self.initUI()
def __init__(self, parent: QMainWindow, sheets: ExcelSPC, num_param: int,
row: int):
super().__init__(parent=parent)
self.icons = Icons()
self.parent = parent
self.sheets = sheets
self.num_param = num_param
self.row = row
self.initUI()
self.setWindowIcon(QIcon(self.icons.CHART))
def __init__(self, db: SqlDB):
super().__init__()
self.setWidgetResizable(True)
self.db = db
self.icons = Icons()
base = QWidget(self)
base.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
self.setWidget(base)
grid = QGridLayout()
base.setLayout(grid)
row = 0
def __init__(self):
super().__init__()
self.icons = Icons()
# CONFIGURATION FILE READ
self.config = configparser.ConfigParser()
self.config.read(self.confFile, 'UTF-8')
self.initDB()
self.initUI()
self.setWindowIcon(QIcon(self.icons.LOGO))
self.setAppTitle()
self.setGeometry(self.x_init, self.y_init, self.w_init, self.h_init)
def __init__(self, parent: QMainWindow):
super().__init__(parent=parent)
self.icons = Icons()
# copy parent values
self.parent = parent
self.db = parent.db
self.config = parent.config
self.confFile = parent.confFile
self.initUI()
self.setWindowIcon(QIcon(self.icons.DB))
self.setWindowTitle('DB Manager')
def __init__(self, db: SqlDB):
super().__init__()
self.db = db
self.icons = Icons()
tab_data = WinDBData(self.db)
self.addTab(tab_data, QIcon(self.icons.PEN), 'Basic')
tab_pcs = WinDBPCS(self.db)
self.addTab(tab_pcs, QIcon(self.icons.CLIP), 'PCS')
tab_spc = WinDBSPC(self.db)
self.addTab(tab_spc, QIcon(self.icons.PLOT), 'SPC')
tab_misc = WinDBMisc(self.db)
self.addTab(tab_misc, QIcon(self.icons.CONF), 'Misc.')
def __init__(self, db: SqlDB):
super().__init__()
self.setWidgetResizable(True)
self.db = db
self.icons = Icons()
base = QWidget(self)
base.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
self.setWidget(base)
grid = QGridLayout()
base.setLayout(grid)
row = 0
# _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
# TEST Label
test = QLabel('TEST')
test.setStyleSheet(
"QLabel {font-size:14pt; padding: 0 2px; background: #ddf;}")
test.setFrameStyle(QFrame.StyledPanel | QFrame.Plain)
grid.addWidget(test, row, 0, 1, 2)
row += 1
# ---------------------------------------------------------------------
# SUPPLIER dump
lab_dump_supplier = QLabel('DUMP table supplier')
lab_dump_supplier.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
but_dump_supplier = QPushButton()
but_dump_supplier.setIcon(QIcon(self.icons.PLAY))
but_dump_supplier.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Expanding)
but_dump_supplier.clicked.connect(self.on_click_dump_supplier)
grid.addWidget(lab_dump_supplier, row, 0)
grid.addWidget(but_dump_supplier, row, 1)
row += 1
# ---------------------------------------------------------------------
# PART dump
lab_dump_part = QLabel('DUMP table part')
lab_dump_part.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
but_dump_part = QPushButton()
but_dump_part.setIcon(QIcon(self.icons.PLAY))
but_dump_part.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Expanding)
but_dump_part.clicked.connect(self.on_click_dump_part)
grid.addWidget(lab_dump_part, row, 0)
grid.addWidget(but_dump_part, row, 1)
row += 1
def __init__(self, db: SqlDB):
super().__init__()
self.setWidgetResizable(True)
self.db = db
self.icons = Icons()
base = QWidget()
base.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
self.setWidget(base)
grid = QGridLayout()
base.setLayout(grid)
row = 0
# ---------------------------------------------------------------------
# SUPPLIER dump
lab_supplier = QLabel('Supplier')
lab_supplier.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
#lab_supplier.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
grid.addWidget(lab_supplier, row, 0)
row += 1
def __init__(self, db: SqlDB):
super().__init__()
self.setWidgetResizable(True)
self.db = db
self.icons = Icons()
base = QWidget(self)
base.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
self.setWidget(base)
grid = QGridLayout()
base.setLayout(grid)
row = 0
# _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
# SPC Label
test = QLabel('SPC data')
test.setStyleSheet(
"QLabel {font-size:14pt; padding: 0 2px; background: #ddf;}")
test.setFrameStyle(QFrame.StyledPanel | QFrame.Plain)
grid.addWidget(test, row, 0, 1, 2)
row += 1
# ---------------------------------------------------------------------
# Excel file read
lab_dump_supplier = QLabel('Excel data uploader')
lab_dump_supplier.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
but_dump_supplier = QPushButton()
but_dump_supplier.setIcon(QIcon(self.icons.EXCEL))
but_dump_supplier.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Expanding)
but_dump_supplier.setStatusTip('read SPC Excel file')
#but_dump_supplier.clicked.connect(self.on_click_dump_supplier)
grid.addWidget(lab_dump_supplier, row, 0)
grid.addWidget(but_dump_supplier, row, 1)
row += 1
def __init__(self, db: SqlDB):
super().__init__()
self.setWidgetResizable(True)
self.db = db
self.icons = Icons()
base = QWidget()
base.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
self.setWidget(base)
grid = QGridLayout()
grid.setColumnStretch(0, 1)
grid.setColumnStretch(1, 1)
grid.setColumnStretch(2, 2)
grid.setColumnStretch(3, 1)
grid.setColumnStretch(4, 1)
grid.setColumnStretch(5, 1)
base.setLayout(grid)
row = 0
# _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
# SUPPLIER Label
supplier = QLabel('SUPPLIER')
supplier.setStyleSheet(
"QLabel {font-size:14pt; padding: 0 2px; background: #ddf;}")
supplier.setFrameStyle(QFrame.StyledPanel | QFrame.Plain)
grid.addWidget(supplier, row, 0, 1, 6)
row += 1
# ---------------------------------------------------------------------
# SUPPLIER NAME SHORT
lab_name_supplier_short = QLabel('SHORT NAME')
lab_name_supplier_short.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_name_supplier_short.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
ent_name_supplier_short = QLineEdit()
ent_name_supplier_short.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
but_name_supplier_short = QPushButton()
but_name_supplier_short.setIcon(QIcon(self.icons.CHECK))
but_name_supplier_short.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Expanding)
grid.addWidget(lab_name_supplier_short, row, 0)
grid.addWidget(ent_name_supplier_short, row, 1)
grid.addWidget(but_name_supplier_short, row, 5, 3, 1)
row += 1
# ---------------------------------------------------------------------
# SUPPLIER NAME FULL
lab_name_supplier = QLabel('FULL NAME')
lab_name_supplier.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_name_supplier.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
ent_name_supplier = QLineEdit()
ent_name_supplier.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
grid.addWidget(lab_name_supplier, row, 0)
grid.addWidget(ent_name_supplier, row, 1, 1, 4)
row += 1
# ---------------------------------------------------------------------
# SUPPLIER NAME in local language
lab_name_supplier_local = QLabel('Local NAME')
lab_name_supplier_local.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_name_supplier_local.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
ent_name_supplier_local = QLineEdit()
ent_name_supplier_local.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
grid.addWidget(lab_name_supplier_local, row, 0)
grid.addWidget(ent_name_supplier_local, row, 1, 1, 4)
row += 1
# click on but_name_supplier_short
but_name_supplier_short.clicked.connect(
lambda: self.on_click_set_supplier(ent_name_supplier_short,
ent_name_supplier,
ent_name_supplier_local))
# _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
# PART Label
part = QLabel('PART')
part.setStyleSheet(
"QLabel {font-size:14pt; padding: 0 2px; background: #ddf;}")
part.setFrameStyle(QFrame.StyledPanel | QFrame.Plain)
grid.addWidget(part, row, 0, 1, 6)
row += 1
# ---------------------------------------------------------------------
# PART NUMBER
lab_num_part = QLabel('PART#')
lab_num_part.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
lab_num_part.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
ent_num_part = QLineEdit()
ent_num_part.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
but_num_part = QPushButton()
but_num_part.setIcon(QIcon(self.icons.CHECK))
but_num_part.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Expanding)
grid.addWidget(lab_num_part, row, 0)
grid.addWidget(ent_num_part, row, 1)
grid.addWidget(but_num_part, row, 5, 5, 1)
row += 1
# ---------------------------------------------------------------------
# Original PART NUMBER
lab_num_part_orig = QLabel('Orig. PART#')
lab_num_part_orig.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;color: gray;}")
lab_num_part_orig.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
combo_num_part_orig = QComboBox()
combo_num_part_orig.setEnabled(False)
combo_num_part_orig.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
check_num_part_orig = QCheckBox('use original drawing')
check_num_part_orig.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
check_num_part_orig.stateChanged.connect(
lambda: self.getPartsOptionCombo(
lab_num_part_orig, combo_num_part_orig, check_num_part_orig))
grid.addWidget(lab_num_part_orig, row, 0)
grid.addWidget(combo_num_part_orig, row, 1)
grid.addWidget(check_num_part_orig, row, 2, 1, 3)
row += 1
# ---------------------------------------------------------------------
# PART Description
lab_desc_part = QLabel('Description')
lab_desc_part.setStyleSheet("QLabel {font-size:10pt; padding: 0 2px;}")
lab_desc_part.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
ent_desc_part = QLineEdit()
ent_desc_part.setSizePolicy(QSizePolicy.Expanding, QSizePolicy.Fixed)
grid.addWidget(lab_desc_part, row, 0)
grid.addWidget(ent_desc_part, row, 1, 1, 4)
row += 1
# ---------------------------------------------------------------------
# PART Supplier
lab_part_supplier = QLabel('Part Supplier')
lab_part_supplier.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_part_supplier.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
combo_part_supplier = QComboBox()
self.add_supplier_list_to_combo(combo_part_supplier)
combo_part_supplier.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
grid.addWidget(lab_part_supplier, row, 0)
grid.addWidget(combo_part_supplier, row, 1)
row += 1
# ---------------------------------------------------------------------
# Assy PART NUMBER
lab_num_part_assy = QLabel('Assy PART#')
lab_num_part_assy.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;color: gray;}")
lab_num_part_assy.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
combo_num_part_assy = QComboBox()
combo_num_part_assy.setEnabled(False)
combo_num_part_assy.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
check_num_part_assy = QCheckBox('link to Assy')
check_num_part_assy.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
#check_num_part_assy.stateChanged.connect(
# lambda: self.getPartsOptionCombo(
# lab_num_part_assy,
# combo_num_part_assy,
# check_num_part_assy
# )
#)
grid.addWidget(lab_num_part_assy, row, 0)
grid.addWidget(combo_num_part_assy, row, 1)
grid.addWidget(check_num_part_assy, row, 2, 1, 3)
row += 1
# click on but_num_part
but_num_part.clicked.connect(lambda: self.on_click_set_part(
ent_num_part, combo_num_part_orig, check_num_part_orig,
ent_desc_part, combo_part_supplier))
# _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
# Drawing Label
drawing = QLabel('Drawing')
drawing.setStyleSheet(
"QLabel {font-size:14pt; padding: 0 2px; background: #ddf;}")
drawing.setFrameStyle(QFrame.StyledPanel | QFrame.Plain)
grid.addWidget(drawing, row, 0, 1, 6)
row += 1
# ---------------------------------------------------------------------
# PART Number
lab_num_part_drawing = QLabel('Part#')
lab_num_part_drawing.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_num_part_drawing.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
combo_num_part_drawing = QComboBox()
combo_num_part_drawing.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
combo_num_part_drawing.setEnabled(False)
self.getParts4Combo(combo_num_part_drawing)
lab_num_supplier_drawing = QLabel()
lab_num_supplier_drawing.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px; color:gray;}")
lab_num_supplier_drawing.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
but_num_part_drawing = QPushButton()
but_num_part_drawing.setIcon(QIcon(self.icons.CHECK))
but_num_part_drawing.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Expanding)
grid.addWidget(lab_num_part_drawing, row, 0)
grid.addWidget(combo_num_part_drawing, row, 1)
grid.addWidget(lab_num_supplier_drawing, row, 2, 1, 3)
grid.addWidget(but_num_part_drawing, row, 5, 4, 1)
row += 1
# ---------------------------------------------------------------------
# PART Drawing Description
lab_num_desc_drawing = QLabel()
lab_num_desc_drawing.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px; color:gray;}")
lab_num_desc_drawing.setSizePolicy(QSizePolicy.Fixed,
QSizePolicy.Fixed)
grid.addWidget(lab_num_desc_drawing, row, 1, 1, 4)
row += 1
self.part_selection_change(combo_num_part_drawing,
lab_num_supplier_drawing,
lab_num_desc_drawing)
combo_num_part_drawing.currentIndexChanged.connect(
lambda: self.part_selection_change(combo_num_part_drawing,
lab_num_supplier_drawing,
lab_num_desc_drawing))
# ---------------------------------------------------------------------
# PART Drawing Revision
lab_rev_drawing = QLabel('Revision')
lab_rev_drawing.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_rev_drawing.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
ent_rev_drawing = QLineEdit()
ent_rev_drawing.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
grid.addWidget(lab_rev_drawing, row, 0)
grid.addWidget(ent_rev_drawing, row, 1)
row += 1
# ---------------------------------------------------------------------
# PART Drawing file
lab_file_drawing = QLabel('PDF file')
lab_file_drawing.setStyleSheet(
"QLabel {font-size:10pt; padding: 0 2px;}")
lab_file_drawing.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
ent_file_drawing = QLineEdit()
ent_file_drawing.setSizePolicy(QSizePolicy.Expanding,
QSizePolicy.Fixed)
but_file_drawing = QPushButton()
but_file_drawing.setIcon(QIcon(self.icons.PDF))
but_file_drawing.setSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
grid.addWidget(lab_file_drawing, row, 0)
grid.addWidget(ent_file_drawing, row, 1, 1, 3)
grid.addWidget(but_file_drawing, row, 4)
row += 1