<?php

function getAllEmployees($conn)
{
    $i = 0;
    $sql = "SELECT voornamen, tussenvoegsels, achternaam, functienaam FROM `personeel` LEFT JOIN `personeel_afdeling` ON personeel.id = personeel_afdeling.personeel_id LEFT JOIN `rollen` ON personeel_afdeling.rol_id = rollen.id";
    $results = mysqli_query($conn, $sql);

    while ($row = mysqli_fetch_array($results)){
        $i++;
        echo $i . ": " . $row[0] . " " . $row[2] . " functie: " . $row[3] . " ";
    }

    return $row;
    // var_dump($row);
}

function getAllDepartments($conn)
{
    $i = 0;
    $sql = "";
    $results = mysqli_query($conn, $sql);

    while ($row = mysqli_fetch_array($results)){
        $i++;
        echo $i . ": " . $row[0] . " " . $row[2] . " functie: " . $row[3] . " ";
    }

    var_dump($row);
}

function getAllManagers($conn)
{
    $i = 0;
    $sql = "";
    $results = mysqli_query($conn, $sql);

    while ($row = mysqli_fetch_array($results)){
        $i++;
        echo $i . ": " . $row[0] . " " . $row[2] . " functie: " . $row[3] . " ";
    }

    var_dump($row);
}

function getEmployeeById($employeeId, $conn)
{
    $i = 0;
    $sql = "SELECT personeel.id, personeel.voornamen, personeel.tussenvoegsels, personeel.achternaam, personeel.geslacht, personeel.geboorte_datum, personeel.email, salarisschalen.salaris, salarisschalen.naam, rollen.functienaam, afdelingen.naam
FROM personeel LEFT JOIN personeel_afdeling
ON personeel.id = personeel_afdeling.personeel_id LEFT JOIN afdelingen
ON personeel_afdeling.afdeling_id = afdelingen.id LEFT JOIN rollen
ON personeel_afdeling.rol_id = rollen.id LEFT JOIN salarissen
ON personeel.id = salarissen.personeel_id LEFT JOIN salarisschalen
ON salarissen.salarisschaal_id = salarisschalen.id
WHERE personeel.id LIKE $employeeId";
    $results = mysqli_query($conn, $sql);

    while ($row = mysqli_fetch_array($results)){
        $i++;
        echo $i . ": " . $row[0] . " " . $row[2] . " " . $row[3] . " " . $row[4] . " " . $row[5]. " " . $row[6]. " " . $row[7] . " " . $row[8] . " " . $row[9] . " " . $row[10];
    };

    var_dump($row);
}

function getAllEmployeesByDepartmentId($departmentId, $conn)
{
    $i = 0;
    $sql = "";
    $results = mysqli_query($conn, $sql);

    while ($row = mysqli_fetch_array($results)){
        $i++;
        echo $i . ": " . $row[0] . " " . $row[2] . " " . $row[3] . " " . $row[4] . " " . $row[5]. " " . $row[6]. " " . $row[7] . " " . $row[8] . " " . $row[9] . " " . $row[10];
    };

    var_dump($row);
}