<?php
//_________________________________________________________________________________
//Récupération des applications
$reqAllApplications = getQueries("nx_applications", array("ORDER BY" => "application_name DESC"));
$allApplications = $reqAllApplications['result'];
//Récupération des utilisateurs
$reqUsers = getQueries("nx_users", array("ORDER BY" => "idUser"));
$users = $reqUsers['result'];
//Récupération des applications, utilisateurs et jointure
$applicationsIds = array();
foreach($allApplications as $applicationInfo) {
$usersIds = array();
$reqApplicationUsers= getQueries('nx_applications_as_users', array('application_id' => $applicationInfo['idApplication']));
foreach($reqApplicationUsers['result'] as $applicationUser)
array_push($usersIds, $applicationUser['user_id']);
$applicationsIds[$applicationInfo['idApplication']] = $usersIds;
}
//_________________________________________________________________________________
?>
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
<!--begin::Container-->
<div class="container-xxl" id="kt_content_container">
<!--begin::Navbar-->
<div class="card mb-5 mb-xl-10">
<div class="card-body pt-9 pb-0">
<!--begin::Details-->
<div class="d-flex flex-wrap flex-sm-nowrap mb-3">
<!--begin::Info-->
<div class="flex-grow-1">
<!--begin::Title-->
<div class="d-flex justify-content-between align-items-start flex-wrap mb-2">
<!--begin::User-->
<div class="d-flex flex-column">
<!--begin::Name-->
<div class="d-flex align-items-center mb-2">
<a href="#" class="text-gray-900 text-hover-primary fs-2 fw-bolder me-1">Vue d'ensemble</a>
<span class="btn btn-sm btn-light-success fw-bolder ms-2 fs-8 py-1 px-3"><?= $reqUsers['count']?> utilisateurs</span>
</div>
<!--end::Name-->
</div>
<!--end::User-->
</div>
<!--end::Title-->
</div>
<!--end::Info-->
</div>
<!--end::Details-->
<!--begin::Navs-->
<ul class="nav nav-stretch nav-line-tabs nav-line-tabs-2x border-transparent fs-5 fw-bolder">
<!--begin::Nav item-->
<li class="nav-item mt-2">
<a class="nav-link text-active-primary ms-0 me-10 py-5 active" href="index.php?page_slug=users-insights">Insights</a>
</li>
<!--end::Nav item-->
<!--begin::Nav item-->
<li class="nav-item mt-2">
<a class="nav-link text-active-primary ms-0 me-10 py-5" href="index.php?page_slug=users">Gestion</a>
</li>
<!--end::Nav item-->
</ul>
<!--begin::Navs-->
</div>
</div>
<!--end::Navbar-->
<!--begin::Card-->
<div class="card">
<!--begin::Card header-->
<div class="card-header border-0 pt-6">
<div class="card-title">
<h2>Attribution des applications aux utilisateurs</h2>
</div>
</div>
<!--end::Card header-->
<!--begin::Card body-->
<div class="card-body pt-0">
<!--begin::Table-->
<div class="table-responsive">
<table class="table align-middle table-hover table-rounded table-striped border gy-7 gs-7">
<thead>
<tr class="fw-bold fs-8 text-gray-800 border-bottom-2 border-gray-200">
<td></td>
<?php
foreach($allApplications as $applicationInfo)
echo '<th class="min-w-100px">'.$applicationInfo['application_name'].'</th>';
?>
</tr>
</thead>
<tbody>
<?php
foreach($users as $userInfo) {
echo '<tr>';
echo '<td class="fs-8 text-gray-800">'.encrypt_decrypt("decrypt", $userInfo['user_firstname'], $key_user, $iv_user).' '.encrypt_decrypt("decrypt", $userInfo['user_lastname'], $key_user, $iv_user).' <a href="index.php?page_slug=user-single&element='.rawurlencode(encrypt_decrypt("encrypt", $userInfo['idUser'], $key_user, $iv_user)).'" target="_blank"><i class="bi bi-box-arrow-up-right"></i></a></td>';
foreach($allApplications as $applicationInfo) {
if( in_array($userInfo['idUser'], $applicationsIds[$applicationInfo['idApplication']]) )
echo '<td class="align-middle"><i class="bi bi-check-circle text-success"></i></td>';
else
echo '<td></td>';
}
echo '</tr>';
}
?>
</tbody>
</table>
</div>
<!--end::Table-->
</div>
<!--end::Card body-->
</div>
<!--end::Card-->
</div>
<!--end::Container-->
</div>
