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)