import os # from module.ImageTool import rotate_image from pdf2image import convert_from_path from PySide6.QtCore import Slot, QUrl from PySide6.QtGui import QPixmap from PySide6.QtWidgets import QDialog from sqlalchemy import func, select from logger import logger from module import create_filename from module.ModelPropusk import PropuskDataMethods from module.wkhtmltopdf import create_pdf from module.QRCode import make from module.TemplatePropusk import TemplatePropusk from module.WorkWithDB import connect, list_personal, list_place, list_propusk from .ui_py.ui_DialogHistory import Ui_DialogHistory from time import sleep class DialogHistory(Ui_DialogHistory, QDialog): def __init__(self, parent=None): super(DialogHistory, self).__init__(parent) self.setupUi(self) self.line_search.textChanged.connect( self.filter_items ) self.list_propusk.itemSelectionChanged.connect( self.selected_item ) self.load_data() self.list_propusk.setCurrentRow(0) def selected_item(self) -> None: try: id_propusk = self.list_propusk.selectedItems()[0].text() self.load_page(int(id_propusk)) except IndexError as err: logger.debug(err) self.browser.clear() except OSError as err: logger.debug(err) @Slot(str) def filter_items(self, text: str) -> None: for index in range(self.list_propusk.count()): item = self.list_propusk.item(index) if text: item.setHidden(not self.match_text(text, item.text())) else: item.setHidden(False) def match_text(self, text: str, keywords:str) -> bool: return text in keywords def load_data(self) -> None: with connect() as conn: rows = conn.execute( list_propusk.select()) \ .all() for line in rows: self.list_propusk.addItem(str(line.id_propusk)) def load_page(self, id_propusk: int) -> None: with connect() as conn: row = conn.execute( select( list_propusk.c.id_propusk, list_propusk.c.date_from, list_propusk.c.date_to, func.format( list_personal.c.lastname + " " + list_personal.c.firstname + " " + list_personal.c.middlename) .label("personal"), func.format(list_place.c.name_place).label("place"), list_propusk.c.receiving_man, list_propusk.c.purpose_visite, list_propusk.c.face, list_propusk.c.document ).select_from(list_propusk).join( list_personal, list_propusk.c.personal == list_personal.c.id ).join( list_place, list_propusk.c.place == list_place.c.id ).where(list_propusk.c.id_propusk == id_propusk) ).fetchone() pdm = PropuskDataMethods(*row) face = os.path.join(os.environ.get( 'PHOTO_DIR'), pdm.get_value("face")) documet = os.path.join(os.environ.get( 'PHOTO_DIR'), pdm.get_value("document")) pdm.set_value("face", face) pdm.set_value("document", documet) pdm.set_value("qrcode", make(pdm.get_value('id_propusk'), create_filename('qr'))) path_doc = os.path.join(os.path.dirname(os.path.abspath(__package__)), 'docs') render_text = str(TemplatePropusk(pdm._propusk_data.__dict__, path_doc)) # print(render_text) # Print(render_text) # pdf = create_pdf(render_text) # sleep(3) # print(F"file://{pdf}") self.browser.setHtml(render_text) # image = convert_from_path(pdf)[0] # image_path = create_filename() # QPixmap.fromImage(image.toqimage()).save(image_path, 'jpg') # self.browser.setText(F"")