<?php
include "../../root.class.php";
$html = new html();
$html->add_styles_page();
$db = new db_safeguard();

$password_res = $db->select_query('passwords', '*', "client_id = '{$_GET['client_id']}' ORDER BY date_time_changed DESC");

function get_status($id)
{
    $db = new db_safeguard();
    $status = $db->select_query("asset_status", "*", "record_id = '{$id}'");
    return $status->fetch_assoc()["name"];
}

function get_type_id($id)
{
    $db = new db_safeguard();
    $asset_type_id = $db->select_query("password_types", "*", "record_id = '{$id}'");
    return $asset_type_id->fetch_assoc()["name"];
}

function get_user($id)
{

    $db = new db_safeguard();
    $user = $db->select_query("users", "*", "record_id = '{$id}'");
    return $user->fetch_assoc()["username"];
}


echo '<table border="1" cellpadding="5" cellspacing="0" width="100%" style="font-size: 1vw">';
echo '<thead>';
echo '<tr>';
echo '<th>Asset Id</th>';
echo '<th>Password Type</th>';
echo '<th>Username</th>';
echo '<th>Password</th>';
echo '<th>Description</th>';
echo '<th>Date Changed</th>';
echo '<th>User Changed</th>';
echo '</tr>';
echo '</thead>';
while ($data = $password_res->fetch_assoc()) {

    echo "<tr>";
    echo "<td>{$data["asset_id"]}</td>";
    echo "<td>" . get_type_id($data["type_id"]) . "</td>";
    echo "<td>{$data["text_type"]}</td>";
    echo "<td>";
    $auth = new authentication();
    echo $auth->decrypt_password($data["password"]);
    echo "</td>";
    echo "<td>{$data["description"]}</td>";
    echo "<td>{$data["date_time_changed"]}</td>";
    echo "<td>" . get_user($data["user_id_changed"]) . "</td>";
    echo "</tr>";

}
echo "</table>";