public static function findByUAP($userId, $affectedUserId, $permission)
{
$data = BaseSingletonGuacamole::select('SELECT guacamole_user_permission.user_id as user_id, ' . 'guacamole_user_permission.affected_user_id as affected_user_id, ' . 'guacamole_user_permission.permission as permission ' . ' FROM guacamole_user_permission' . ' WHERE guacamole_user_permission.user_id = ? AND guacamole_user_permission.affected_user_id = ? AND LOWER(guacamole_user_permission.permission) = LOWER(?)', array('iis', &$userId, &$affectedUserId, &$permission));
$guacamoleUserPermission = new Guacamole_User_Permission();
if (sizeof($data) > 0) {
$guacamoleUserPermission->hydrate($data[0]);
} else {
$guacamoleUserPermission = null;
}
return $guacamoleUserPermission;
}
//echo "OK pour Expired:".$newUserGuacamole->getExpired();
//Les $accessWindowStart, $accessWindowEnd doivent être à null sinon ils ne pourront pas accéder à n'importe quelle heure sur leurs machines
//$validFrom=null, $validUntil=null, pareils
//echo "Valider";
//====Vérification de doublons====
if (Guacamole_UserDAL::findByUsername($validUserName) == null) {
//=====Insertion=====/ - OK
$validInsertUser = Guacamole_UserDAL::insertOnDuplicate($newUserGuacamole);
if ($validInsertUser != null) {
$newLog->setLevel("INFO");
$newLog->setMsg("Ajout de l'utilisateur reussi dans la base guacamole_db! (id:" . $validInsertUser . ")");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
//echo "Ajout de l'utilisateur reussi dans la base guacamole_db! (id:" . $validInsertUser . ")";
//Paramètres des permissions de l'utilisateur
$guacamoleUserPermission = new Guacamole_User_Permission();
$guacamoleUserPermission->setUser($validInsertUser);
$guacamoleUserPermission->setAffectedUser($validInsertUser);
$guacamoleUserPermission->setPermission("READ");
$valid = Guacamole_User_PermissionDAL::insertOnDuplicate($guacamoleUserPermission);
$guacamoleUserPermission->setPermission("UPDATE");
$valid = Guacamole_User_PermissionDAL::insertOnDuplicate($guacamoleUserPermission);
$guacamoleUserPermission->setPermission("DELETE");
$valid = Guacamole_User_PermissionDAL::insertOnDuplicate($guacamoleUserPermission);
$guacamoleUserPermission->setPermission("ADMINISTER");
$valid = Guacamole_User_PermissionDAL::insertOnDuplicate($guacamoleUserPermission);
$newLog->setLevel("INFO");
$newLog->setMsg("Ajout des permissions réussis pour l'utilisateur avec l'id:" . $validInsertUser . ")");
$newLog->setDateTime(date('Y/m/d G:i:s'));
$validTableLog = Table_logDAL::insertOnDuplicate($newLog);
$message = "ok";
