[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 08/12: Set current user in PostGresql session
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 08/12: Set current user in PostGresql session (config) so it can be directly used directly by triggers and pgplsql to track user's changes |
Date: |
Wed, 16 Nov 2022 14:39:18 -0500 (EST) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 4bc4658dd7e0372d54b8a6919be3892b5eadaf28
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Tue Nov 8 20:59:30 2022 +0100
Set current user in PostGresql session (config)
so it can be directly used directly by triggers and pgplsql
to track user's changes
---
include/class/noalyss_user.class.php | 14 +++++++++++++-
1 file changed, 13 insertions(+), 1 deletion(-)
diff --git a/include/class/noalyss_user.class.php
b/include/class/noalyss_user.class.php
index 8f4cf107d..b75cbf5e1 100644
--- a/include/class/noalyss_user.class.php
+++ b/include/class/noalyss_user.class.php
@@ -35,7 +35,7 @@ class Noalyss_User
var $id; //!< in account_repository , ac_users.use_id
- var $db; //!< database connx
+ var $db; //!< database connx to the folder NOT repository
var $admin; //!< is or is not admin
var $valid; //!< is or is not valid
var $first_name;
@@ -53,6 +53,7 @@ class Noalyss_User
if ($p_id==-1)
{
$this->connect_user();
+ $this->set_session_var();
}
else // if p_id is set get data of another user
{
@@ -60,6 +61,17 @@ class Noalyss_User
$this->load();
}
}
+
+ /**
+ * @brief put user_login into Postgres config (session), it can be used
for tracking users activities
+ * @return void
+ */
+ protected function set_session_var()
+ {
+ $this->db->exec_sql(sprintf("select
set_config('noalyss.user_login','%s',false)",
+ Database::escape_string($_SESSION[SESSION_KEY.'g_user'])));
+
+ }
public function __toString(): string
{
return "User ".print_r($this,true);
- [Noalyss-commit] [noalyss] branch master updated (7749f97eb -> 1a1bcd567), Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 02/12: code cleaning : rename search_poste to search_accounting, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 03/12: TVA javascript : add callback function, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 08/12: Set current user in PostGresql session (config) so it can be directly used directly by triggers and pgplsql to track user's changes,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 09/12: Fix typo due to code cleaning, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 06/12: Add function __toString, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 04/12: INUM , IText and ITVAPopup add the attribute (for javascript), Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 01/12: WYSIWYG Editor integration and improve of waiting_box, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 05/12: set require to falser and add function __toString, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 10/12: useless file, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 11/12: Clean code : dead code, improve debug, comments, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 12/12: Save the current user in a PostgreSQL session variable noalyss.user_login, Dany De Bontridder, 2022/11/16
- [Noalyss-commit] [noalyss] 07/12: Tag : add color when selected, Dany De Bontridder, 2022/11/16