Système de recherche

1 files changed, 43 insertions, 0 deletions

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)