From 5e23fcc7de84adf23ea52ae0858f31b8934fabd3 Mon Sep 17 00:00:00 2001 From: Debulois Date: Wed, 27 Apr 2022 13:17:19 +0200 Subject: Système de recherche MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- src/core/coreSearch.py | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100644 src/core/coreSearch.py (limited to 'src/core/coreSearch.py') diff --git a/src/core/coreSearch.py b/src/core/coreSearch.py new file mode 100644 index 0000000..47f2f69 --- /dev/null +++ b/src/core/coreSearch.py @@ -0,0 +1,43 @@ + +from src.database import dbsearch +from src.gui import windowRecherche +from PyQt5.QtWidgets import QMessageBox + + +def core_search_id(mainWindow: object, jobId: int) -> None: + search: object = dbsearch.DbSearch(mainWindow) + resRecherche: tuple = search.get_all_pro_by_jobid(jobId) + if resRecherche: + core_search_main(mainWindow, resRecherche) + else: + QMessageBox.information( + mainWindow, + "Résultat", + "Aucun résultat." + ) + +def core_search_name(mainWindow: object, name: str) -> None: + search: object = dbsearch.DbSearch(mainWindow) + resRecherche: tuple = search.get_pro_info_by_lastname(name) + if resRecherche: + core_search_main(mainWindow, resRecherche) + else: + QMessageBox.information( + mainWindow, + "Résultat", + "Aucun résultat." + ) + +def core_search_main(mainWindow: object, resRecherche: tuple) -> None: + search: object = dbsearch.DbSearch(mainWindow) + results: list = [] + for i in resRecherche: + proInfo: dict = {} + proInfo["id"] = i[0] + resJobs = search.get_pro_job_by_proid(proInfo["id"]) + proInfo["text"] = list(i[1:]) + proInfo["text"].insert(2, ", ".join([j[2] for j in resJobs])) + proInfo["text"] = " - ".join(proInfo["text"]) + results.append(proInfo) + + windowRecherche.main(mainWindow, results) -- cgit v1.2.3