summaryrefslogtreecommitdiff
path: root/src/core/coreSearch.py
blob: 47f2f693741028cd76b641d2a5f8f2430cda9455 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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)