ti incollo il codice, fammi sapere come migliorarlo
- User
ti incollo il codice, fammi sapere come migliorarlo
- Assistant
Certo, incolla pure il codice e sarò felice di fornirti suggerimenti per migliorarlo!
- User
import sys import sqlite3 from datetime import datetime, date from PyQt6.QtWidgets import (QApplication, QMainWindow, QWidget, QVBoxLayout, QHBoxLayout, QListWidget, QPushButton, QLabel, QLineEdit, QFormLayout, QDateEdit, QFileDialog, QMessageBox, QTabWidget, QTextEdit, QSpinBox, QDialog, QDialogButtonBox, QSystemTrayIcon, QMenu, QComboBox) from PyQt6.QtCore import Qt, QDate, QTimer from PyQt6.QtGui import QPixmap, QIcon from PIL import Image import io from reportlab.lib.pagesizes import letter from reportlab.pdfgen import canvas import pandas as pd import csv from openpyxl import Workbook import logging
def adapt_date(val): return val.isoformat()
def convert_date(val): return date.fromisoformat(val.decode())
sqlite3.register_adapter(date, adapt_date) sqlite3.register_converter(“DATE”, convert_date)
class NotificationDialog(QDialog): def init(self, parent=None): super().init(parent) self.setWindowTitle(“Impostazioni Notifiche”) layout = QFormLayout(self) self.days_spinbox = QSpinBox() self.days_spinbox.setRange(1, 365) self.days_spinbox.setValue(30) layout.addRow(“Giorni di anticipo per le notifiche:”, self.days_spinbox) buttons = QDialogButtonBox(QDialogButtonBox.StandardButton.Ok | QDialogButtonBox.StandardButton.Cancel) buttons.accepted.connect(self.accept) buttons.rejected.connect(self.reject) layout.addWidget(buttons)
class ValveManager(QMainWindow): def init(self): super().init() self.setWindowTitle(“Gestione Valvole di Sicurezza”) self.setGeometry(100, 100, 1000, 600) self.setWindowIcon(QIcon(‘valve_icon.png’))
# Configura il logger logging.basicConfig(filename=‘app.log’, level=logging.INFO, format=‘%(asctime)s - %(levelname)s - %(message)s’) self.init_db() self.init_ui() self.init_tray() self.check_revisions() self.timer = QTimer(self) self.timer.timeout.connect(self.check_revisions) self.timer.start(86400000) # Controlla ogni 24 ore def init_db(self): self.conn = sqlite3.connect(‘valves.db’, detect_types=sqlite3.PARSE_DECLTYPES) self.cursor = self.conn.cursor() self.cursor.execute(‘’‘CREATE TABLE IF NOT EXISTS valves (serial TEXT PRIMARY KEY, name TEXT, type TEXT, location TEXT, last_revision_date DATE, next_revision_date DATE, revision_interval INTEGER, notification_period INTEGER, nominal_pressure REAL, inlet_diameter REAL, outlet_diameter REAL, image BLOB)’‘’) self.conn.commit() def init_ui(self): main_layout = QHBoxLayout() list_layout = QVBoxLayout() self.valve_list = QListWidget() self.valve_list.itemClicked.connect(self.show_valve_details) list_layout.addWidget(self.valve_list) add_button = QPushButton(“Prepara Nuova Valvola”) add_button.clicked.connect(self.add_new_valve) list_layout.addWidget(add_button) delete_button = QPushButton(“Elimina Valvola”) delete_button.clicked.connect(self.delete_valve) list_layout.addWidget(delete_button) backup_button = QPushButton(“Backup Database”) backup_button.clicked.connect(self.backup_database) list_layout.addWidget(backup_button) main_layout.addLayout(list_layout, 1) tab_widget = QTabWidget() details_widget = QWidget() form_layout = QFormLayout(details_widget) self.serial_input = QLineEdit() self.name_input = QLineEdit() self.type_input = QLineEdit() self.location_input = QLineEdit() self.last_revision_date_input = QDateEdit() self.next_revision_date_input = QDateEdit() self.revision_interval_input = QComboBox() self.revision_interval_input.addItems([“1 mese”, “3 mesi”, “6 mesi”, “1 anno”, “2 anni”, “3 anni”, “5 anni”]) self.notification_period_input = QSpinBox() self.notification_period_input.setRange(1, 365) self.notification_period_input.setSuffix(" giorni") self.nominal_pressure_input = QLineEdit() self.inlet_diameter_input = QLineEdit() self.outlet_diameter_input = QLineEdit() self.image_label = QLabel() self.image_label.setFixedSize(200, 200) self.image_label.setScaledContents(True) form_layout.addRow(“Seriale:”, self.serial_input) form_layout.addRow(“Nome:”, self.name_input) form_layout.addRow(“Tipo:”, self.type_input) form_layout.addRow(“Posizione:”, self.location_input) form_layout.addRow(“Ultima revisione:”, self.last_revision_date_input) form_layout.addRow(“Prossima revisione:”, self.next_revision_date_input) form_layout.addRow(“Intervallo revisione:”, self.revision_interval_input) form_layout.addRow(“Periodo notifica:”, self.notification_period_input) form_layout.addRow(“Pressione nominale (bar):”, self.nominal_pressure_input) form_layout.addRow(“Diametro ingresso (mm):”, self.inlet_diameter_input) form_layout.addRow(“Diametro uscita (mm):”, self.outlet_diameter_input) form_layout.addRow(“Immagine:”, self.image_label) button_layout = QHBoxLayout() save_button = QPushButton(“Salva modifiche”) save_button.clicked.connect(self.save_valve) add_valve_button = QPushButton(“Aggiungi Valvola”) add_valve_button.clicked.connect(self.add_valve) add_image_button = QPushButton(“Aggiungi Immagine”) add_image_button.clicked.connect(self.add_image) button_layout.addWidget(save_button) button_layout.addWidget(add_valve_button) button_layout.addWidget(add_image_button) form_layout.addRow(button_layout) tab_widget.addTab(details_widget, “Dettagli Valvola”) report_widget = QWidget() report_layout = QVBoxLayout(report_widget) self.report_text = QTextEdit() self.report_text.setReadOnly(True) report_layout.addWidget(self.report_text) generate_report_button = QPushButton(“Genera Report”) generate_report_button.clicked.connect(self.generate_report) report_layout.addWidget(generate_report_button) export_layout = QHBoxLayout() export_pdf_button = QPushButton(“Esporta in PDF”) export_pdf_button.clicked.connect(self.export_to_pdf) export_csv_button = QPushButton(“Esporta in CSV”) export_csv_button.clicked.connect(self.export_to_csv) export_excel_button = QPushButton(“Esporta in Excel”) export_excel_button.clicked.connect(self.export_to_excel) export_layout.addWidget(export_pdf_button) export_layout.addWidget(export_csv_button) export_layout.addWidget(export_excel_button) report_layout.addLayout(export_layout) tab_widget.addTab(report_widget, “Report”) main_layout.addWidget(tab_widget, 2) central_widget = QWidget() central_widget.setLayout(main_layout) self.setCentralWidget(central_widget) self.load_valves() # Applica il foglio di stile self.setStyleSheet(“”“ QListWidget { font-size: 14px; } QPushButton { font-size: 14px; padding: 10px; } QLabel { font-size: 14px; } QLineEdit, QDateEdit, QSpinBox, QComboBox { font-size: 14px; } QTextEdit { font-size: 14px; } “””) def init_tray(self): self.tray_icon = QSystemTrayIcon(self) self.tray_icon.setIcon(QIcon(‘valve_icon.png’)) tray_menu = QMenu() show_action = tray_menu.addAction(“Mostra”) show_action.triggered.connect(self.show) quit_action = tray_menu.addAction(“Esci”) quit_action.triggered.connect(QApplication.quit) self.tray_icon.setContextMenu(tray_menu) self.tray_icon.show() def load_valves(self): self.valve_list.clear() self.cursor.execute(“SELECT serial, name, type, location FROM valves”) for row in self.cursor.fetchall(): self.valve_list.addItem(f"{row[0]}: {row[1]} - {row[2]} - {row[3]}“) def show_valve_details(self, item): serial = item.text().split(‘:’)[0] self.cursor.execute(“SELECT * FROM valves WHERE serial=?”, (serial,)) valve = self.cursor.fetchone() if valve: self.serial_input.setText(valve[0]) self.name_input.setText(valve[1]) self.type_input.setText(valve[2]) self.location_input.setText(valve[3]) self.last_revision_date_input.setDate(QDate(valve[4])) self.next_revision_date_input.setDate(QDate(valve[5])) self.revision_interval_input.setCurrentIndex(self.revision_interval_input.findText(self.get_interval_text(valve[6]))) self.notification_period_input.setValue(valve[7]) self.nominal_pressure_input.setText(str(valve[8])) self.inlet_diameter_input.setText(str(valve[9])) self.outlet_diameter_input.setText(str(valve[10])) if valve[11]: pixmap = QPixmap() pixmap.loadFromData(valve[11]) self.image_label.setPixmap(pixmap) else: self.image_label.clear() def save_valve(self): current_item = self.valve_list.currentItem() if not current_item: self.show_warning(“Nessuna valvola selezionata”, “Seleziona una valvola da aggiornare.”) return valve_data = self.collect_valve_data() if valve_data: self.update_valve_in_db(valve_data) self.load_valves() self.show_info(“Aggiornamento completato”, “I dati della valvola sono stati aggiornati con successo.”) logging.info(f"Valvola {valve_data[0]} aggiornata.”) def add_valve(self): valve_data = self.collect_valve_data() if valve_data: try: self.cursor.execute(‘’‘INSERT INTO valves (serial, name, type, location, last_revision_date, next_revision_date, revision_interval, notification_period, nominal_pressure, inlet_diameter, outlet_diameter) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’‘’, valve_data) self.conn.commit() self.load_valves() self.show_info(“Aggiunta completata”, “La nuova valvola è stata aggiunta con successo.”) self.add_new_valve() logging.info(f"Nuova valvola aggiunta: {valve_data[0]}“) except sqlite3.IntegrityError: self.show_warning(“Errore”, “Il seriale della valvola deve essere univoco.”) def add_image(self): current_item = self.valve_list.currentItem() if not current_item: self.show_warning(“Nessuna valvola selezionata”, “Seleziona una valvola per aggiungere un’immagine.”) return file_name, _ = QFileDialog.getOpenFileName(self, “Seleziona un’immagine”, “”, “Image Files (*.png *.jpg .bmp)“) if file_name: with Image.open(file_name) as img: img = img.resize((200, 200)) buf = io.BytesIO() img.save(buf, format=‘PNG’) image_data = buf.getvalue() serial = current_item.text().split(‘:’)[0] self.cursor.execute(“UPDATE valves SET image=? WHERE serial=?”, (image_data, serial)) self.conn.commit() pixmap = QPixmap(file_name) self.image_label.setPixmap(pixmap) logging.info(f"Immagine aggiunta per la valvola {serial}”) def check_revisions(self): today = date.today() self.cursor.execute(“SELECT serial, name, type, location, next_revision_date, notification_period FROM valves”) valves = self.cursor.fetchall() due_valves = [] for valve in valves: days_until_revision = (valve[4] - today).days if days_until_revision <= valve[5]: due_valves.append(valve) if due_valves: message = “Le seguenti valvole necessitano di revisione:\n\n” for valve in due_valves: message += f"Seriale: {valve[0]}, Nome: {valve[1]}, Tipo: {valve[2]}, Posizione: {valve[3]}, Data revisione: {valve[4]}\n" self.tray_icon.showMessage(“Revisioni in scadenza”, message, QSystemTrayIcon.MessageIcon.Warning) logging.warning(“Revisioni in scadenza:\n” + message) def collect_valve_data(self): try: serial = self.serial_input.text() name = self.name_input.text() type_ = self.type_input.text() location = self.location_input.text() last_revision_date = self.last_revision_date_input.date().toPyDate() next_revision_date = self.next_revision_date_input.date().toPyDate() revision_interval = self.get_interval_months(self.revision_interval_input.currentText()) notification_period = self.notification_period_input.value() nominal_pressure = float(self.nominal_pressure_input.text()) inlet_diameter = float(self.inlet_diameter_input.text()) outlet_diameter = float(self.outlet_diameter_input.text()) # Verifica campi obbligatori if not serial or not name or not type_ or not location: raise ValueError(“I campi seriale, nome, tipo e posizione sono obbligatori.”) return (serial, name, type_, location, last_revision_date, next_revision_date, revision_interval, notification_period, nominal_pressure, inlet_diameter, outlet_diameter) except ValueError as e: self.show_warning(“Dati non validi”, str(e)) return None def update_valve_in_db(self, valve_data): self.cursor.execute(‘’‘UPDATE valves SET name=?, type=?, location=?, last_revision_date=?, next_revision_date=?, revision_interval=?, notification_period=?, nominal_pressure=?, inlet_diameter=?, outlet_diameter=? WHERE serial=?’‘’, (valve_data[1], valve_data[2], valve_data[3], valve_data[4], valve_data[5], valve_data[6], valve_data[7], valve_data[8], valve_data[9], valve_data[10], valve_data[0])) self.conn.commit() def delete_valve(self): current_item = self.valve_list.currentItem() if current_item: serial = current_item.text().split(‘:’)[0] reply = QMessageBox.question(self, ‘Conferma eliminazione’, ‘Sei sicuro di voler eliminare questa valvola?’, QMessageBox.StandardButton.Yes | QMessageBox.StandardButton.No, QMessageBox.StandardButton.No) if reply == QMessageBox.StandardButton.Yes: self.cursor.execute(“DELETE FROM valves WHERE serial=?”, (serial,)) self.conn.commit() self.load_valves() self.add_new_valve() logging.info(f"Valvola {serial} eliminata.“) def generate_report(self): self.cursor.execute(“SELECT * FROM valves”) valves = self.cursor.fetchall() report = “Report Valvole di Sicurezza\n\n” for valve in valves: report += f"Seriale: {valve[0]}\n” report += f"Nome: {valve[1]}\n" report += f"Tipo: {valve[2]}\n" report += f"Posizione: {valve[3]}\n" report += f"Ultima revisione: {valve[4]}\n" report += f"Prossima revisione: {valve[5]}\n" report += f"Intervallo revisione: {self.get_interval_text(valve[6])}\n" report += f"Periodo notifica: {valve[7]} giorni\n" report += f"Pressione nominale: {valve[8]} bar\n" report += f"Diametro ingresso: {valve[9]} mm\n" report += f"Diametro uscita: {valve[10]} mm\n" report += “-” * 30 + “\n” self.report_text.setText(report) def export_to_pdf(self): file_name, _ = QFileDialog.getSaveFileName(self, “Salva PDF”, “”, "PDF Files (.pdf)”) if file_name: if not file_name.endswith(‘.pdf’): file_name += ‘.pdf’ c = canvas.Canvas(file_name, pagesize=letter) width, height = letter c.setFont(“Helvetica”, 12) y = height - 40 c.drawString(30, y, “Report Valvole di Sicurezza”) y -= 20 self.cursor.execute(“SELECT * FROM valves”) valves = self.cursor.fetchall() for valve in valves: if y < 50: # New page if not enough space c.showPage() c.setFont(“Helvetica”, 12) y = height - 40 c.drawString(30, y, f"Seriale: {valve[0]}”) y -= 15 c.drawString(30, y, f"Nome: {valve[1]}“) y -= 15 c.drawString(30, y, f"Tipo: {valve[2]}”) y -= 15 c.drawString(30, y, f"Posizione: {valve[3]}“) y -= 15 c.drawString(30, y, f"Ultima revisione: {valve[4]}”) y -= 15 c.drawString(30, y, f"Prossima revisione: {valve[5]}“) y -= 15 c.drawString(30, y, f"Intervallo revisione: {self.get_interval_text(valve[6])}”) y -= 15 c.drawString(30, y, f"Periodo notifica: {valve[7]} giorni") y -= 15 c.drawString(30, y, f"Pressione nominale: {valve[8]} bar") y -= 15 c.drawString(30, y, f"Diametro ingresso: {valve[9]} mm") y -= 15 c.drawString(30, y, f"Diametro uscita: {valve[10]} mm") y -= 20 c.save() QMessageBox.information(self, “Esportazione completata”, “Il report è stato esportato in PDF con successo.”) logging.info(“Report esportato in PDF”) def export_to_csv(self): file_name, _ = QFileDialog.getSaveFileName(self, “Salva CSV”, “”, “CSV Files (.csv)") if file_name: if not file_name.endswith(‘.csv’): file_name += ‘.csv’ self.cursor.execute(“SELECT * FROM valves”) valves = self.cursor.fetchall() df = pd.DataFrame(valves, columns=[‘Seriale’, ‘Nome’, ‘Tipo’, ‘Posizione’, ‘Ultima revisione’, ‘Prossima revisione’, ‘Intervallo revisione’, ‘Periodo notifica’, ‘Pressione nominale’, ‘Diametro ingresso’, ‘Diametro uscita’, ‘Immagine’]) df = df.drop(‘Immagine’, axis=1) # Rimuovi la colonna dell’immagine df.to_csv(file_name, index=False, quoting=csv.QUOTE_NONNUMERIC) QMessageBox.information(self, “Esportazione completata”, “Il report è stato esportato in CSV con successo.”) logging.info(“Report esportato in CSV”) def export_to_excel(self): file_name, _ = QFileDialog.getSaveFileName(self, “Salva Excel”, “”, "Excel Files (.xlsx)”) if file_name: if not file_name.endswith(‘.xlsx’): file_name += ‘.xlsx’ wb = Workbook() ws = wb.active ws.title = “Report Valvole di Sicurezza” # Aggiungi intestazioni headers = [‘Seriale’, ‘Nome’, ‘Tipo’, ‘Posizione’, ‘Ultima revisione’, ‘Prossima revisione’, ‘Intervallo revisione’, ‘Periodo notifica’, ‘Pressione nominale’, ‘Diametro ingresso’, ‘Diametro uscita’] ws.append(headers) # Aggiungi dati self.cursor.execute(“SELECT * FROM valves”) valves = self.cursor.fetchall() for valve in valves: ws.append(valve[:-1]) # Esclude l’ultima colonna (immagine) # Adatta la larghezza delle colonne for column in ws.columns: max_length = 0 column_letter = column[0].column_letter for cell in column: try: if len(str(cell.value)) > max_length: max_length = len(cell.value) except: pass adjusted_width = (max_length + 2) ws.column_dimensions[column_letter].width = adjusted_width wb.save(file_name) QMessageBox.information(self, “Esportazione completata”, “Il report è stato esportato in Excel con successo.”) logging.info(“Report esportato in Excel”) def get_interval_text(self, months): if months == 1: return “1 mese” elif months == 3: return “3 mesi” elif months == 6: return “6 mesi” elif months == 12: return “1 anno” elif months == 24: return “2 anni” elif months == 36: return “3 anni” elif months == 60: return “5 anni” else: return “1 anno” # Valore predefinito def get_interval_months(self, text): if text == “1 mese”: return 1 elif text == “3 mesi”: return 3 elif text == “6 mesi”: return 6 elif text == “1 anno”: return 12 elif text == “2 anni”: return 24 elif text == “3 anni”: return 36 elif text == “5 anni”: return 60 else: return 12 # Valore predefinito def closeEvent(self, event): reply = QMessageBox.question(self, ‘Conferma uscita’, ‘Sei sicuro di voler uscire?’, QMessageBox.StandardButton.Yes | QMessageBox.StandardButton.No, QMessageBox.StandardButton.No) if reply == QMessageBox.StandardButton.Yes: event.accept() logging.info(“Applicazione chiusa dall’utente.”) else: event.ignore() def backup_database(self): options = QFileDialog.Options() file_name, _ = QFileDialog.getSaveFileName(self, “Backup Database”, “”, “SQLite Files (.sqlite);;All Files ()”, options=options) if file_name: try: import shutil shutil.copy(“valves.db”, file_name) self.show_info(“Backup completato”, “Il backup del database è stato completato con successo.”) logging.info(“Backup del database completato”) except Exception as e: self.show_warning(“Errore di backup”, f"Errore durante il backup del database: {str(e)}“) logging.error(f"Errore durante il backup del database: {str(e)}”) def show_warning(self, title, message): QMessageBox.warning(self, title, message) logging.warning(f"{title}: {message}“) def show_info(self, title, message): QMessageBox.information(self, title, message) logging.info(f”{title}: {message}")if name == “main”: app = QApplication(sys.argv) window = ValveManager() window.show() sys.exit(app.exec())
- Assistant
Grazie per aver condiviso il codice. Ecco alcune aree in cui possiamo migliorare questo codice:
Correzioni di base
-
Apostrofi doppi non validi: Nel tuo codice sono presenti molti apostrofi doppi che non sono validi in Python. Usa sempre apostrofi singoli (
') o doppi (").sqlite3.register_converter("DATE", convert_date) logging.basicConfig(filename='app.log', level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s') -
Metodi
__init__: I metodi__init__dovrebbero essere definiti correttamente, invece didef init(self), usaredef __init__(self):.class NotificationDialog(QDialog): def __init__(self, parent=None): super().__init__(parent) self.setWindowTitle("Impostazioni Notifiche") ... -
Eliminare le virgolette curve: Le virgolette curve come
“e”devono essere sostituite con virgolette normali". -
Importazioni ripetute: Controlla se tutte le importazioni sono necessarie e rimuovi quelle inutilizzate, per esempio
import iopotrebbe non essere necessario se non stai usandoBytesIO.
Miglioramenti della Gestione degli Errori
-
Gestione delle eccezioni: Usa
tryeexceptdove possono verificarsi errori, come l'apertura di file o l'interazione con il database.try: self.conn = sqlite3.connect('valves.db', detect_types=sqlite3.PARSE_DECLTYPES) self.cursor = self.conn.cursor() except sqlite3.Error as e: QMessageBox.critical(self, "Errore di Connessione", f"Impossibile connettersi al database: {str(e)}") sys.exit(1) -
Backup Database: Usa una gestione appropriata dei file e delle eccezioni per il backup del database.
Miglioramenti dell'Interfaccia Utente
-
Risoluzione Form e Layout: Assicurati che i form siano costruiti in modo facile da comprendere e utilizzare.
self.last_revision_date_input.setCalendarPopup(True) self.next_revision_date_input.setCalendarPopup(True) -
Centratura della finestra: La finestra principale dovrebbe essere centrata sullo schermo.
def center(self): qr = self.frameGeometry() cp = QScreen.availableGeometry(QApplication.primaryScreen()).center() qr.moveCenter(cp) self.move(qr.topLeft()) -
Uso di QComboBox SetItems: Per migliorare la leggibilità di
QComboBox.self.revision_interval_input.addItems(["1 mese", "3 mesi", "6 mesi", "1 anno", "2 anni", "3 anni", "5 anni"])
Miglioramenti del Codice
-
DRY Principle (Do Not Repeat Yourself): Isola il codice ripetitivo in funzioni separate.
def execute_query(self, query, params=()): self.cursor.execute(query, params) self.conn.commit() -
Funzioni di utilità comuni: Scrivi funzioni di utilità per operazioni ripetitive.
def show_message(self, title, message, icon=QMessageBox.Icon.Information): msg_box = QMessageBox() msg_box.setIcon(icon) msg_box.setText(message) msg_box.setWindowTitle(title) msg_box.exec()
Formattazione e Stile
-
PEP8: Segui le linee guida di stile di PEP8 per una migliore leggibilità (ad esempio, usa 4 spazi per l'indentazione).
def delete_valve(self): current_item = self.valve_list.currentItem() if current_item: serial = current_item.text().split(':')[0] reply = QMessageBox.question(self, 'Conferma eliminazione', 'Sei sicuro di voler eliminare questa valvola?', QMessageBox.StandardButton.Yes | QMessageBox.StandardButton.No, QMessageBox.StandardButton.No) if reply == QMessageBox.StandardButton.Yes: self.cursor.execute("DELETE FROM valves WHERE serial=?", (serial,)) self.conn.commit() self.load_valves() self.add_new_valve() logging.info(f"Valvola {serial} eliminata.")
Esempio Migliorato
import sys import sqlite3 from datetime import date from PyQt6.QtWidgets import (QApplication, QMainWindow, QWidget, QVBoxLayout, QHBoxLayout, QListWidget, QPushButton, QLabel, QLineEdit, QFormLayout, QDateEdit, QFileDialog, QMessageBox, QTabWidget, QSpinBox, QDialog, QDialogButtonBox, QSystemTrayIcon, QMenu, QComboBox) from PyQt6.QtCore import Qt, QDate, QTimer from PyQt6.QtGui import QPixmap, QIcon, QScreen # Rimuovi alberi d'importazione inutilizzati import pandas as pd import logging def adapt_date(val): return val.isoformat() def convert_date(val): return date.fromisoformat(val.decode()) sqlite3.register_adapter(date, adapt_date) sqlite3.register_converter("DATE", convert_date) class NotificationDialog(QDialog): def __init__(self, parent=None): super().__init__(parent) self.setWindowTitle("Impostazioni Notifiche") layout = QFormLayout(self) self.days_spinbox = QSpinBox() self.days_spinbox.setRange(1, 365) self.days_spinbox.setValue(30) layout.addRow("Giorni di anticipo per le notifiche:", self.days_spinbox) buttons = QDialogButtonBox(QDialogButtonBox.StandardButton.Ok | QDialogButtonBox.StandardButton.Cancel) buttons.accepted.connect(self.accept) buttons.rejected.connect(self.reject) layout.addWidget(buttons) class ValveManager(QMainWindow): def __init__(self): super().__init__() self.setWindowTitle("Gestione Valvole di Sicurezza") self.setGeometry(100, 100, 1000, 600) self.setWindowIcon(QIcon('valve_icon.png')) logging.basicConfig(filename='app.log', level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s') self.init_db() self.init_ui() self.init_tray() self.check_revisions() self.timer = QTimer(self) self.timer.timeout.connect(self.check_revisions) self.timer.start(86400000) # Controlla ogni 24 ore self.center() def init_db(self): try: self.conn = sqlite3.connect('valves.db', detect_types=sqlite3.PARSE_DECLTYPES) self.cursor = self.conn.cursor() self.cursor.execute('''CREATE TABLE IF NOT EXISTS valves (serial TEXT PRIMARY KEY, name TEXT, type TEXT, location TEXT, last_revision_date DATE, next_revision_date DATE, revision_interval INTEGER, notification_period INTEGER, nominal_pressure REAL, inlet_diameter REAL, outlet_diameter REAL, image BLOB)''') self.conn.commit() except sqlite3.Error as e: QMessageBox.critical(self, "Errore di Connessione", f"Impossibile connettersi al database: {str(e)}") sys.exit(1) def init_ui(self): main_layout = QHBoxLayout() list_layout = QVBoxLayout() self.valve_list = QListWidget() self.valve_list.itemClicked.connect(self.show_valve_details) list_layout.addWidget(self.valve_list) add_button = QPushButton("Prepara Nuova Valvola") add_button.clicked.connect(self.add_new_valve) list_layout.addWidget(add_button) backup_button = QPushButton("Backup Database") backup_button.clicked.connect(self.backup_database) list_layout.addWidget(backup_button) main_layout.addLayout(list_layout, 1) tab_widget = QTabWidget() details_widget = QWidget() form_layout = QFormLayout(details_widget) self.serial_input = QLineEdit() self.name_input = QLineEdit() self.type_input = QLineEdit() self.location_input = QLineEdit() self.last_revision_date_input = QDateEdit() self.last_revision_date_input.setCalendarPopup(True) self.next_revision_date_input = QDateEdit() self.next_revision_date_input.setCalendarPopup(True) self.revision_interval_input = QComboBox() self.revision_interval_input.addItems(["1 mese", "3 mesi", "6 mesi", "1 anno", "2 anni", "3 anni", "5 anni"]) self.notification_period_input = QSpinBox() self.notification_period_input.setRange(1, 365) self.notification_period_input.setSuffix(" giorni") self.nominal_pressure_input = QLineEdit() self.inlet_diameter_input = QLineEdit() self.outlet_diameter_input = QLineEdit() self.image_label = QLabel() self.image_label.setFixedSize(200, 200) self.image_label.setScaledContents(True) form_layout.addRow("Seriale:", self.serial_input) form_layout.addRow("Nome:", self.name_input) form_layout.addRow("Tipo:", self.type_input) form_layout.addRow("Posizione:", self.location_input) form_layout.addRow("Ultima revisione:", self.last_revision_date_input) form_layout.addRow("Prossima revisione:", self.next_revision_date_input) form_layout.addRow("Intervallo revisione:", self.revision_interval_input) form_layout.addRow("Periodo notifica:", self.notification_period_input) form_layout.addRow("Pressione nominale (bar):", self.nominal_pressure_input) form_layout.addRow("Diametro ingresso (mm):", self.inlet_diameter_input) form_layout.addRow("Diametro uscita (mm):", self.outlet_diameter_input) form_layout.addRow("Immagine:", self.image_label) button_layout = QHBoxLayout() save_button = QPushButton("Salva modifiche") save_button.clicked.connect(self.save_valve) add_valve_button = QPushButton("Aggiungi Valvola") add_valve_button.clicked.connect(self.add_valve) add_image_button = QPushButton("Aggiungi Immagine") add_image_button.clicked.connect(self.add_image) button_layout.addWidget(save_button) button_layout.addWidget(add_valve_button) button_layout.addWidget(add_image_button) form_layout.addRow(button_layout) tab_widget.addTab(details_widget, "Dettagli Valvola") main_layout.addWidget(tab_widget, 2) central_widget = QWidget() central_widget.setLayout(main_layout) self.setCentralWidget(central_widget) self.load_valves() self.setStyleSheet(""" QListWidget { font-size: 14px; } QPushButton { font-size: 14px; padding: 10px; } QLabel { font-size: 14px; } QLineEdit, QDateEdit, QSpinBox, QComboBox { font-size: 14px; } QTextEdit { font-size: 14px; } """) def init_tray(self): self.tray_icon = QSystemTrayIcon(self) self.tray_icon.setIcon(QIcon('valve_icon.png')) tray_menu = QMenu() show_action = tray_menu.addAction("Mostra") show_action.triggered.connect(self.show) quit_action = tray_menu.addAction("Esci") quit_action.triggered.connect(QApplication.quit) self.tray_icon.setContextMenu(tray_menu) self.tray_icon.show() def load_valves(self): self.valve_list.clear() self.cursor.execute("SELECT serial, name, type, location FROM valves") for row in self.cursor.fetchall(): self.valve_list.addItem(f"{row[0]}: {row[1]} - {row[2]} - {row[3]}") def show_valve_details(self, item): serial = item.text().split(':')[0] self.cursor.execute("SELECT * FROM valves WHERE serial=?", (serial,)) valve = self.cursor.fetchone() if valve: self.serial_input.setText(valve[0]) self.name_input.setText(valve[1]) self.type_input.setText(valve[2]) self.location_input.setText(valve[3]) self.last_revision_date_input.setDate(QDate(valve[4])) self.next_revision_date_input.setDate(QDate(valve[5])) self.revision_interval_input.setCurrentIndex(self.revision_interval_input.findText(self.get_interval_text(valve[6]))) self.notification_period_input.setValue(valve[7]) self.nominal_pressure_input.setText(str(valve[8])) self.inlet_diameter_input.setText(str(valve[9])) self.outlet_diameter_input.setText(str(valve[10])) if valve[11]: pixmap = QPixmap() pixmap.loadFromData(valve[11]) self.image_label.setPixmap(pixmap) else: self.image_label.clear() def save_valve(self): current_item = self.valve_list.currentItem() if not current_item: self.show_warning("Nessuna valvola selezionata", "Seleziona una valvola da aggiornare.") return valve_data = self.collect_valve_data() if valve_data: self.update_valve_in_db(valve_data) self.load_valves() self.show_info("Aggiornamento completato", "I dati della valvola sono stati aggiornati con successo.") logging.info(f"Valvola {valve_data[0]} aggiornata.") def add_valve(self): valve_data = self.collect_valve_data() if valve_data: try: self.cursor.execute('''INSERT INTO valves (serial, name, type, location, last_revision_date, next_revision_date, revision_interval, notification_period, nominal_pressure, inlet_diameter, outlet_diameter) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)''', valve_data) self.conn.commit() self.load_valves() self.show_info("Aggiunta completata", "La nuova valvola è stata aggiunta con successo.") self.add_new_valve() logging.info(f"Nuova valvola aggiunta: {valve_data[0]}") except sqlite3.IntegrityError: self.show_warning("Errore", "Il seriale della valvola deve essere univoco.") def add_image(self): current_item = self.valve_list.currentItem() if not current_item: self.show_warning("Nessuna valvola selezionata", "Seleziona una valvola per aggiungere un'immagine.") return file_name, _ = QFileDialog.getOpenFileName(self, "Seleziona un'immagine", "", "Image Files (*.png *.jpg .bmp)") if file_name: with Image.open(file_name) as img: img = img.resize((200, 200)) buf = io.BytesIO() img.save(buf, format='PNG') image_data = buf.getvalue() serial = current_item.text().split(':')[0] self.cursor.execute("UPDATE valves SET image=? WHERE serial=?", (image_data, serial)) self.conn.commit() pixmap = QPixmap(file_name) self.image_label.setPixmap(pixmap) logging.info(f"Immagine aggiunta per la valvola {serial}") def check_revisions(self): today = date.today() self.cursor.execute("SELECT serial, name, type, location, next_revision_date, notification_period FROM valves") valves = self.cursor.fetchall() due_valves = [] for valve in valves: days_until_revision = (valve[4] - today).days if days_until_revision <= valve[5]: due_valves.append(valve) if due_valves: message = "Le seguenti valvole necessitano di revisione:\n\n" for valve in due_valves: message += f"Seriale: {valve[0]}, Nome: {valve[1]}, Tipo: {valve[2]}, Posizione: {valve[3]}, Data revisione: {valve[4]}\n" self.tray_icon.showMessage("Revisioni in scadenza", message, QSystemTrayIcon.MessageIcon.Warning) logging.warning("Revisioni in scadenza:\n" + message) def collect_valve_data(self): try: serial = self.serial_input.text() name = self.name_input.text() type_ = self.type_input.text() location = self.location_input.text() last_revision_date = self.last_revision_date_input.date().toPyDate() next_revision_date = self.next_revision_date_input.date().toPyDate() revision_interval = self.get_interval_months(self.revision_interval_input.currentText()) notification_period = self.notification_period_input.value() nominal_pressure = float(self.nominal_pressure_input.text()) inlet_diameter = float(self.inlet_diameter_input.text()) outlet_diameter = float(self.outlet_diameter_input.text()) if not serial or not name or not type_ or not location: raise ValueError("I campi seriale, nome, tipo e posizione sono obbligatori.") return (serial, name, type_, location, last_revision_date, next_revision_date, revision_interval, notification_period, nominal_pressure, inlet_diameter, outlet_diameter) except ValueError as e: self.show_warning("Dati non validi", str(e)) return None def update_valve_in_db(self, valve_data): self.cursor.execute('''UPDATE valves SET name=?, type=?, location=?, last_revision_date=?, next_revision_date=?, revision_interval=?, notification_period=?, nominal_pressure=?, inlet_diameter=?, outlet_diameter=? WHERE serial=?''', (valve_data[1], valve_data[2], valve_data[3], valve_data[4], valve_data[5], valve_data[6], valve_data[7], valve_data[8], valve_data[9], valve_data[10], valve_data[0])) self.conn.commit() def delete_valve(self): current_item = self.val -