public static function findByUCP($userId, $connectionId, $permission)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_connection_permission.user_id as user_id, ' . 'guacamole_connection_permission.connection_id as connection_id, ' . 'guacamole_connection_permission.permission as permission ' . ' FROM guacamole_connection_permission' . ' WHERE guacamole_connection_permission.user_id = ? AND guacamole_connection_permission.connection_id = ? AND LOWER(guacamole_connection_permission.permission) = LOWER(?)', array('iis', &$userId, &$connectionId, &$permission));
$guacamoleConnectionPermission = new Guacamole_Connection_Permission();
if (sizeof($data) > 0) {
$guacamoleConnectionPermission->hydrate($data[0]);
} else {
$guacamoleConnectionPermission = null;
}
return $guacamoleConnectionPermission;
}
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Paramètre port de la connection (connection n°" . $idConnectContainer . ") correctmeent ajoutée.");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("Paramètre port de la connection (connection n°" . $idConnectContainer . ") non ajoutée.");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
//Arret
exit;
}
//=====Créer les permission sur la connection pur l'user donné=====//
$guacUserId = Guacamole_UserDAL::findByUsername($loginUtilisateur);
$permConnectContainer = new Guacamole_Connection_Permission();
$permConnectContainer->setConnection($idConnectContainer);
$permConnectContainer->setUser($guacUserId);
//ajout la permission READ
$permConnectContainer->setPermission("READ");
$validInsertPermR = Guacamole_Connection_PermissionDAL::insertOnDuplicate($permConnectContainer);
if (!is_null(Guacamole_Connection_PermissionDAL::findByUCP($permConnectContainer->getUser()->getUserId(), $permConnectContainer->getConnection()->getConnectionId(), $permConnectContainer->getPermission()))) {
$newLog->setLevel("INFO");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("La permission READ pour la conneciton n°" . $idConnectContainer . " a bien été ajoutée !");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
} else {
$newLog->setLevel("ERROR");
$newLog->setLoginUtilisateur($loginUtilisateur);
$newLog->setMsg("La permission READ pour la conneciton n°" . $idConnectContainer . " n'a pas bien été ajoutée !");
